Loading...
Administration Packet 2006 02-02-06 f United City of Yorkville 800 Game Farm Road EW. 1 '' Yorkville, Illinois 60560 Telephone: 630-553-4350 9 Fax: 630-553-7575 <LE AGENDA ADMINISTRATION COMMITTEE MEETING Thursday, February 2,2006 6:30 P.M. CITY CONFERENCE ROOM REVISED 2/2/06 Presentation: None Old Business: 1. Minutes for Approval/Correction: January 5, 2006 New Business: 1. Monthly Budget Report for December 2005 2. ADM 2006-10 Monthly Treasurer's Report for December 2005 3. ADM 2006-14 Proposed Revised Budget—Fiscal Year 2005/2006 4. ADM 2006-04 Library Buildout Repayment Information 5. ADM 2006-05 Fiscal Year 2006/2007 Budget Requests 6. ADM 2006-11 Health Insurance Information 7. ADM 2006-12 Minute Taking Policy 8. ADM 2006-13 Hiring Policy 9. ADM 2006-15 Municipal Building Impact Fee 10. ADM 2006-16 Draft Job Descriptions for Community Development Department a. Senior Planner b. City Park Designer b. Urban Designer c. GIS Coordinator 11. ADM 2006-17 Waterworks System - EEI Contracts B.2 and B.3 Abatement Ordinance 12. ADM 2006-18 Rob Roy Creek Interceptor Abatement Ordinance 13. ADM 2006-19 Plan Review Fees 14. ADM 2006-20 Amending the Administrative Assistant Job Description Additional Business: United City of Yorkville 800 Game Farm Road EST. 1$36 Yorkville, Illinois 60560 Telephone: 630-553-4350 2� Fax: 630-553-7575 WOW SCE AGENDA ADMINISTRATION COMMITTEE MEETING Thursday,February 2,2006 6:30 P.M. CITY CONFERENCE ROOM Presentation: None Old Business: 1. Minutes for Approval/Correction: None New Business: 1. Monthly Budget Report for December 2005 2. ADM 2006-10 Monthly Treasurer's Report for December 2005 3. ADM 2006-14 Proposed Revised Budget—Fiscal Year 2005/2006 4. ADM 2006-04 Library Buildout Repayment Information 5. ADM 2006-05 Fiscal Year 2006/2007 Budget Requests 6. ADM 2006-11 Health Insurance Information 7. ADM 2006-12 Minute Taking Policy 8. ADM 2006-13 Hiring Policy 9. ADM 2006-15 Municipal Building Impact Fee 10. ADM 2006-16 Draft Job Descriptions for Community Development Department a. Senior Planner b. City Park/Urban Designer c. GIS Coordinator Additional Business: Page 1 of 3 DRAFT ADMINISTRATION COMMITTEE MEETING Thursday,January 5,2006 6:30 P.M. City Conference Room Present Alderman Paul James, Chairman Finance Director Tracy Pleckham Alderwoman Rose Spears Denise Kasper Alderwoman Wanda Ohare Bart Olson Alderwoman Valerie Burd City Treasurer Bill Powell City Administrator John Crois Presentations: -None. Old Business: 1. Minutes for Approval/Correction: -December 1, 2005 —The minutes were approved. 2. ADM 2005-12 Tuition Policy—In the additions to the existing Employee Manual, Section 8.6b(proposed),the first sentence where it says college degree or certificate was changed to say a college degree program or certificate program, and there was discussion about adding a list of eligible certificates. There was discussion about schooling for Maintenance Workers, and they may want to go for Certifications. The eligible degree level list should include certificates for Parks, Recreation, Streets, Sewer, or Water department employees, and any other departments it would apply. The staff that needs to be included in this list would be the Police Department Office Staff and the Community Relations Director. There was concern that the schooling requirements for the new job descriptions were not reflected in this list. These will be checked and the list will be updated if necessary. A footer should be added to tell the draft date and updated dates on the bottom of documents. This will move on to COW. New Business: 1. Monthly Budget Report for November 2005—The year is 58.3% of the way through, and the General Fund revenue is at 49.76%, and the expenditures are at 35.92%. There are a lot of contractual expenses which may mean more personnel . is needed. There was a question about why some of the expenditure percents were so high for certain items. Those items were one or two time collections or payouts, and they are finished for the year. The revised budget requests will be at February's Administration Committee meeting. This does not move forward at this time. Page 2 of 3 2. ADM 2006-01 Monthly Treasurer's Report for November 2005—The Sewer Maintenance Fund Balance is high because they have a smaller fund balance, and when the percent is taken, it is higher. This is for maintenance items they have not yet expended this year. There will be a new expanded Treasurer's Report format hopefully for next month. This will go on to COW on Consent Agenda. 3. ADM 2006-02 Quarterly Department Vehicle Reports—The new format was not coordinated yet. These reports should be done monthly, but reviewed quarterly. This does not need to go on to COW. 4. ADM 2006-06 Fog Industrial Park Abatement Ordinance—Items 4—7 are similar. These were city issued bonds that the city will not need to collect the dollars from the taxpayers for. They are alternate revenue bonds with an alternate revenue source. Taxes can be levied if the alternate revenue is not available The Tax Levy is attached as a third funding mechanism for the protection of the Bond holder. The county is required to levy the tax unless the City tells them to abate it. This is something that must be done annually. The abatement ordinance must be sent to the County by the last Tuesday in February. Glory Spies will be asked to send out a press release for these abatements. This will move on to COW on Consent Agenda. 5. ADM 2006-07 Countryside Interceptor Abatement Ordinance—This will move on to COW on Consent Agenda. 6. ADM 2006-08 Countryside Center TIF Abatement Ordinance—This will move on to COW on Consent Agenda. 7. ADM 2006-09 In-Town Road Program Abatement Ordinance—This will move on to COW on Consent Agenda. Additional Business: FY 2006/2007 Budget Requests—There should be a separate line item for the Rt. 47 improvements. This will go on the agenda next month. A punch list will be created of items to add or delete identified from other committees and Staff. Alderwoman Burd would like to see more money for the Facade Program and for Public Relations to be expanded. She would also like to work on an incentive program for Small Business. Alderwoman Spears said Mrs.Austin called her about the rezoning of the duplex sold to the Van Riper Insurance Agency. Alderwoman Ohare spoke to her also. She had a concern that there was no covenant mentioned. Mrs.Austin pays a monthly association fee and the Business is not exempt. Mrs.Austin was concerned because the restrictions don't come out until after the closing. Alderwoman Spears has had concerns from residents that some of the residents were not notified of the Public Hearing or of a vote.. The city sends out a certified letter to the residents for the Public Hearings, and knows they received the letter, but they do not notify the residents of when the voting will take place,that is up to the residents to track. Rose Spears asked about the turnaround time of meeting notes from minute takers and court reporters. She said the two week turnaround policy should be enforced. This will be brought back to Administration next month. Page 3 of 3 Tracy Pleckham said there will be a special meeting, possibly on March 13th, for the next fiscal year's budget. Goals and Objectives should be thought about beforehand. Alderman James said there are 5 Tuesdays in January, and that maybe the 5th Tuesday should be set aside for Goal setting. Alderwoman Burd would like to see a resolution put on the agenda for Tuesday night supporting the School District Referendum. John Crois said there was a press release that FE Wheaton was purchased by Lanoga Corporation. They now have more capital and staff and expertise and will be expanding their services. Bill Powell said there is an inverted yield curve right now and the City is making such good interest on the short term investments that there is no rush to turn them into long term investments. The meeting was adjourned at 7:30 pm. Minutes submitted by Laura Leppert. UNITED CITY OF YORKVILLE BUDGET 2005-2006 GENERAL FUND SUMMARY PERIOD ENDING DECEMBER 31, 2005 67.0% OF FISCAL YEAR REVENUE/EXPENSE 2005-2006 PERCENT VS. THRU DECEMBER 31, 2005 BUDGET BUDGET AMOUNT fi r t }y= ..� �+ .U.�aynk �'r a ', `, TOfiAL (aN RAL�F�UNDREVENIlE� y _>:';', 1 Orv5�4$56a 'p;,00-494 36 �, o 58 67/ GENERAL FUND EXPENSES FINANCE & ADMINISTRATION 2,882,815 5,134,030 56.15% ENGINEERING 244,320 373,132 65.48% POLICE 1,445,998 2,145,143 67.41% PLANNING & DEVELOPMENT 125,368 324,607 38.62% STREETS 2,264,593 9,459,954 23.94% HEALTH & SANITATION 338,172 571,170 59.21% *s axe 'h-" ,a.. no: '' S -=` �"-'r, psi+:" .aL _L.a'.£ .�� _.�:i Y _+ ..e_xF '"°--�-brl` �L TOTAL G IVERA' FUIDECPENSS ��' 7, 30�1-;265 � � 4 ` 1.$;00$;0364 UNITED CITY OF YOXKvLu6js DECEMBER 2005 BUDGET 67.0% FISCAL YTD PAGE FISCAL YEAR-TO FISCAL YEAR %COLLECTED/ FUND # ACCOUNT NUMBER DESCRIPTION DATE ACTUAL BUDGET EXPENDED COMMENTS GENERAL "Q0POL_40;00,a% 90APtPONTRIBPTI 65' o 0.'W- 8'Y 1 RISTO IBAY 4F E RMMFEES _COLLECTED 2M lm!�Vnk�msmv oft LIU UP ADMIN 3 01-110-61-00-5300 LEGAL SERVICES $ 38,381.67 $ 35,000.00 109.66% 7,800.00 LABOR ATTORNEY ADMIN 4 01-110-62-00-5400 INSURANCE-LIABILITY&PROPERTY $ 121,210.58 $ 130,000.00 93.24% ONE TIME LUMP SUM PAYMENT ADMIN 4 .01-110-64-00-5605 TRAVEL/MEALS/LODGING $ 13,634.06 $ 17,000.00 80.20%_DUE TO IML CONFERENCE HALLOWEEN&CHRISTMAS TROLLEY,CITY ADMIN 4 01-110-64-00-5607 PUBLIC RELATIONS $ 12,074.23 $ 18,000.00 67.08% MAGNETS,WATER SHED PROGRAM ADMIN 5 01-110-75-00-7002 COMPUTER EQUIP&SOFTWARE $ 10,693.61 $ 13,500.00 79.21% PAYMENT FOR HR MODULE&PROJECTOR ENGINEERING 6 01-150-62-00-5401 CONTRACTUAL SERVICES $ 42,174.54 $ 20,000.00 210.87% BROWNFIELD EXPENSE _21,000 ENGINEERING 7 01-150-64-00-5605 TRAVEL EXPENSES $ 956.40 $ 1,000.00 95.64% ONE TIME CONFERENCE TRAVEL EXPENSES T 3D,ACCIDENM&TRANSMISSIO g m MAIT,8 HIPPK§ DUE TO INCREASED COST-WILL BE REVISED ON POLICE 8 101-210-62-00-5441 MTD-ALERTS FEE $ 4,620.00 $ 2,400.00 192.50% BUDGET POLICE 9 01-210-64-00-5605 TRAVEL EXPENSES $ 9,009.73 $ 9,000.00 100.11% POLICE 9 01-210-72-00-6502 POLICE PENSION $ 231,123.76 $ 231,686.00 99.76% PAYOUTS BASED ON PROPERTY TAX REVENUE POLICE 10 01-210-78-00-9004 BIKE PATROL $ 1,422.51 $ 2,000.00 71.13% SEASONAL EXPENSE x- ---- --sl _5a tEGAI;_c� "'Rvictsi"Rpa qi� 'Zo§7E oa BOUNDARY 4-4i6 I w All vf "12 6,69,Vm W, 28r.6 h Ewp �Q�6 f� -"_ -A I _ .- "nl' _0,6m , _jE STREETS 13 01-410-75-00-7100 STREET REHAB-PROJECTS $ 35,646.99 $ 40,000.00 89.12% PROJECTS DONE/NEAR COMPLETION YORKVILLE MOOSE DONATION FOR POLICE PD CAPITAL 19 20-000-44-00-4404 DONATIONS $ 1,500.00 $ 500.00 300.00% VESTS I'15 CAPITAL tl , ; 00 00°/a POI;I E=CAPITALGRANT _ .19w,,20-000,144LOQ-44 0 ;99 4�t -A- 19 PD CAPITAL 20-000-44-00-4490 MISCELLANEOUS INCOME $ 24,609.27 $ 100.00% RECEIVED 1998 GRANT DOLLARS YORKVILLE JUNIOR WOMEN'S TEAM DONATED PARKS&REC $1000 FOR PLAYGROUND CAPITAL, YYBS CAPITAL 23 22-000-42-00-4217 PARKS CAPITAL-DONATIONS $ 7,000.00 $ - 100.00% DONATED$6,000 FOR FOX HILL FIELD DONATION SHALLOW WELL$3,754.00,EEI-GENERAL WATER ENGINEERING$6,900.00&WATER QUALITY IMPROVEMENT 29 41-000-61-00-5301 ENGINEERING-GENERAL SERVICES $ 12,681.00 $ 8,000.00 158.51% $1,550.00 WATER LOANER/RENTAL GAS DETIETTO-19-TUTNITTO BE OPERATIONS 35 51-000-75-00-7004 SAFETY EQUIPMENT $ 2,325.01 $ 2,000.00 116.25% CREDITED ON RETURN SEWER REST ENT SEWER&DRIVEWAY REPAIR @ OPERATIONS 37 52-000-62-00-5401 CONTRACTUAL SERVICES $ 3,010.50 $ 2,000.00 150.53% $2818.00 -$1,466.00 GATOR REPAIRS,$1,806.00 ENGINE PARKS&REC 46 79-610-62-00-5408 MAINTENANCE EQUIPMENT $ 6,691.21 $ 6,000.00 111.52% REPAIRS&PARTS LIBRARY 54 82-000-65-00-5842 BLDG-DEVELOPMENT FEES $ 1,145,060.71 $ 153,570.00 745.63% LIBRARY EXPANSION INTEREST RATE INCREASES&ADDITIONAL BOND ALL VARIOUS INVESTMENT INCOME 133.6%-8,109.3% PROCEEDS NOT YET EXPENDED JALL VARIOUS GASOLINE 33.1%-152.8% 1 GAS PRICE 17VCREASES 1� 21-8 UNITED CITY OF YORKVILLE DETAILED REVENUE & EXPENSE REPORT AS OF DECEMBER 31, 2005 General Fund Revenue 1 Sanitary Sewer Improvement&Expansion 25 Finance 3 Water Improvement& Expansion 28 Engineering 6 Debt Service Fund 31 Police 7 Water Operations 33 Planning and Development 10 Sewer Maintenance 37 Streets and Alleys 11 Land Cash 40 Health and Sanitation 13 Land Acquisition 44 Motor Fuel Tax Fund 15 Parks &Recreation 45 Municipal Building 17 Working Cash 51 Police Equipment Capital 19 Library 52 Public Works Equipment Capital 21 Fox Industrial 56 Parks&Recreation Equipment Capital 23 Countryside TIF 58 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 1 'IME: 13:13:45 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 :D: GL470002.WOW 67.0% of Fiscal Year FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL g ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ 3ENERAL 3EVENUES TAXES 01-000-40-00-3995 FUND BALANCE 0.00 0.00 0.00 0.0 01-000-40-00-3996 ROAD CONTRIBUTION FEE 372,000.00 651,098.00 550,000.00 118.3 01-000-40-00-3997 IN TOWN ROAD PROGRAM FUNDING 0.00 3,783,562.20 4,350,210.00 86.9 01-000-40-00-3998 MPI BRISTOL RIDGE RD FUNDING 0.00 40.00 4,000,000.00 0.0 01-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 50,000.00 0.0 01-000-40-00-4000 REAL ESTATE TAXES (9,672.98) 1,387,085.39 1,393,821.00 99.5 01-000-40-00-4001 TOWN ROAD/BRIDGE TAX 186.39 101,790.99 98,000.00 103.8 01-000-40-00-4002 FOX HILL LEVY REVENUE 0.00 0.00 7,850.00 0.0 01-000-40-00-4010 PERSONAL PROPERTY TAX 949.02 8,137.22 10,000.00 81.3 01-000-40-00-4020 STATE INCOME TAX 108,375.58 305,591.47 638,820.00 47.8 01-000-40-00-4030 MUNICIPAL SALES TAX 213,813.00 1,289,912.72 2,308,900.00 55.8 01-000-40-00-4032 STATE USE TAX 8,685.77 51,485.88 97,006.00 53.0 01-000-40-00-4040 MUNICIPAL UTILITY TAX 0.00 172,353.14 500,000.00 34.4 01-000-40-00-4041 UTILITY TAX - NICOR 23,657.39 49,044.21 100,000.00 49.0 01-000-40-00-4042 UTILITY TAX - CABLE TV 0.00 57,346.37 65,000.00 88.2 01-000-40-00-4043 UTILITY TAX - TELEPHONE 34,115.43 218,012.60 325,000.00 67.0 01-000-40-00-4050 HOTEL TAX _ 1,480.94 13,032.32 20,000.00 65.1 01-000-40-00-4060 TRAFFIC SIGNAL REVENUE 0.00 0.00 5,000.00 0.0 --------------------------------------------------------------------------------- TOTAL TAXES 753,590.54 8,088,492.51 14,519,607.00 55.7 LICENSES & PERMITS 01-000-41-00-4100 LIQUOR LICENSE 600.00 11,990.80 25,000.00 47.9 01-000-41-00-4101 OTHER LICENSES 0.00 1,409.50 4,500.00 31.3 01-000-41-00-4110 BUILDING PERMITS 245,952.00 847,283.00 11100,000.00 77.0 --------------------------------------------------------------------------------- TOTAL LICENSES & PERMITS 246,552.00 860,683.30 1,129,500.00 76.2 CHARGES FOR SERVICES 01-000-42-00-4205 FILING FEES 85.00 5,534.40 25,000.00 22.1 01-000-42-00-4206 GARBAGE SURCHARGE 35,072.10 135,825.55 192,780.00 70.4 01-000-42-00-4207 REFUSE STICKERS 0.00 0.00 0.00 0.0 01-000-42-00-4208 COLLECTION FEE - YBSD 0.00 0.00 34,000.00 0.0 01-000-42-00-4209 PLANNING FEE 0.00 0.00 39,899.00 0.0 01-000-42-00-4210 DEVELOPMENT FEES 530,642.34 932,164.48 1,175,000.00 79.3 P1 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 2 'IME: 13:13:45 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 :D: GL470002.WOW FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL °s ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ 3ENERAL ZEVENUES CHARGES FOR SERVICES 01-000-42-00-4211 ENGINEERING CAPITAL FEE 19,500.00 27,900.00 27,500.00 101.4 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 585,299.44 1,101,424.43 1,494,179.00 73.7 FINES & FORFEITS 01-000-43-00-4310 TRAFFIC FINES 7,194.98 50,698.30 73,500.00 68.9 01-000-43-00-4315 REIMBURSE POLICE TRAINING 0.00 11,805.06 0.00 100.0 01-000-43-00-4320 ORDINANCE FEES 165.00 695.00 2,500.00 27.8 --------------------------------------------------------------------------------- TOTAL FINES & FORFEITS 7,359.98 63,198.36 76,000.00 83.1 MISCELLANEOUS 01-000-44-00-4401 DARE DONATIONS 25.00 125.00 1,250.00 10.0 01-000-44-00-4402 ROB ROY CREEK HYDRAULIC STUDY 0.00 22,700.00 40,000.00 56.7 01-000-44-00-4410 REIMBURSEMENTS - OTHER GOVTS 0.00 0.00 0.00 0.0 01-000-44-00-4411 REIMBURSEMENTS-POLICE PROTECTN 361.10 1,904.20 3,000.00 63.4 01-000-44-00-4420 SIDWALK CONSTRUCTION 0.00 0.00 0.00 0.0 01-000-44-00-4490 MISCELLANEOUS INCOME 293.19 8,847.00 10,000.00 88.4 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 679.29 33,576.20 54,250.00 61.8 INTERGOVERNMENTAL 01-000-45-00-4504 TRAFFIC SIGNAL REVENUE 0.00 0.00 0.00 0.0 01-000-45-00-4505 COPS GRANT - VESTS 0.00 0.00 1,250.00 0.0 01-000-45-00-4510 COPS GRANT 0.00 0.00 0.00 0.0 01-000-45-00-4511 POLICE-STATE TOBACCO GRANT 0.00 0.00 1,250.00 0.0 01-000-45-00-4521 ICJIA BLOCK GRANT 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL INTERGOVERNMENTAL 0.00 0.00 2,500.00 0.0 INTEREST 01-000-46-00-4600 INVESTMENT INCOME 10,346.80 82,481.21 20,000.00 412.4 --------------------------------------------------------------------------------- TOTAL INTEREST. 10,346.80 82,481.21 20,000.00 412.4 P2 'ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 3 'IME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 D: GL470002.WOW FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ----------------------------------------------------------------------------------------------------------------------------------- :ENERAL TRANSFERS 01-000-49-00-4914 TRANSFER FROM WORKING CASH 0.00 0.00 0.00 0.0 01-000-49-00-4915 TRANSFER FROM WATER OPERATIONS 0.00 100,000.00 200,000.00 50.0 01-000-49-00-4920 TRANSFER FROM SEWER MAINT. 0.00 35,000.00 70,000.00 50.0 01-000-49-00-4925 TRANSFER FROM SAN. SEWER IMPR 0.00 100,000.00 200,000.00 50.0 01-000-49-00-4930 TRANSFER FROM WATER IMPROVE. 0.00 100,000.00 200,000.00 50.0 01-000-49-00-4935 TRANSFER FROM LAND CASH 0.00 0.00 42,000.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 335, 000.00 712, 000.00 47.0 TOTAL REVENUES: GENERAL 1,603,828.05 10,564,856.01 18,008,036.00 58.6 FINANCE & ADMINISTRATION EXPENSES PERSONNEL SERVICES 01-110-50-00-5100 SALARIES - MAYOR 0.00 3,775.00 7,500.00 50.3 01-110-50-00-5101 SALARIES - CITY CLERK 0.00 1,800.00 3,600.00 50.0 01-110-50-00-5102 SALARIES - CITY TREASURER 0.00 1,800.00 3,600.00 50.0 01-110-50-00-5103 SALARIES - ALDERMAN 0.00 14,550.00 29,080.00 50.0 01-110-50-00-5104 SALARIES - LIQUOR COMMISSIONER 0.00 500.00 1,000.00 50.0 01-110-50-00-5105 SALARIES - CITY ATTORNEY 884.80 7,520.80 13, 500.00 55.7 01-110-50-00-5106 SALARIES - ADMINISTRATIVE 45,556.87 375,194.09 557,237.00 67.3 01-110-50-00-5136 SALARIES - PART TIME 3,575.38 35,322.06 45,072.00 78.3 01-110-50-00-5137 SALARIES - OVERTIME 71.12 125.93 1,500.00 8.3 01-110-50-00-5199 MSI PAYROLL 0.00 0.00 0.00 0.0 01-110-50-00-5202 BENEFITS-UNEMPLOY. COMP. TAX 0.00 6,633.00 10,000.00 66.3 01-110-50-00-5203 BENEFITS - HEALTH INSURANCE 54,807.87 474,710.41 825,000.00 57.5 01-110-50-00-5204 BENEFITS - GROUP LIFE INSURANC (505.32) 7,592.24 20,000.00 37.9 01-110-50-00-5205 BENEFITS - DENTAL/VISION ASST 990.72 34,970.06 68,093.00 51.3 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 105,381.44 964,493.59 1,585,182.00 60.8 PROFESSIONAL SERVICES 01-110-61-00-5300 LEGAL SERVICES 1,186.25 38,381.67 35,000.00 109.6 01-110-61-00-5304 AUDIT FEES & EXPENSES 2,021.60 17,153.23 25,500.00 67.2 P3 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 4 'IME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 D: GL470002.WOW FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL o ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ ?INANCE & ADMINISTRATION ,XPENSES PROFESSIONAL SERVICES 01-110-61-00-5305 ACCOUNTING ASSISTANCE 0.00 0.00 5,000.00 0.0 01-110-61-00-5307 ACCOUNTING SYSTEM REVIEW .0.00 0.00 0.00 0.0 01-110-61-00-5308 GASB 34 3,118.25 9,847.02 15,000.00 65.6 01-110-61-00-5310 EMPLOYEE ASSISTANCE 0.00 1,306.50 4,500.00 29.0 01-110-61-00-5311 CODIFICATION 1,523.00 4,438.00 5,000.00 88.7 01-110-61-00-5314 BUILDING INSPECTIONS 81,976.40 490,597.45 880,000.00 55.7 01-110-61-00-5322 BONDING 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 89,825.50 561,723.87 970,000.00 57.9 CONTRACTUAL SERVICES 01-110-62-00-5400 INSURANCE-LIABILITY & PROPERTY 2,068.06 121,210.58 130,000.00 93.2 01-110-62-00-5401 CONTRACTUAL SERVICES 8,276.45 22,898.49 37,500.00 61.0 01-110-62-00-5403 SPECIAL CENSUS 39,107.26 39,631.37 66,000.00 60.0 01-110-62-00-5404 CABLE CONSORTIUM FEE 9,876.41 19,528.55 30,000.00 65.0 01-110-62-00-5406 OFFICE CLEANING 550.00 3,850.00 7,500.00 51.3 01-110-62-00-5410 MAINTENANCE - OFFICE EQUIPMENT 0.00 189.50 500.00 37.9 01-110-62-00-5411 MAINTENANCE - COMPUTERS 1,275.00 1,331.64 2,000.00 66.5 01-110-62-00-5412 MAINTENANCE - PHOTOCOPIERS 1,702.30 11,398.30 19,392.00 58.7 01-110-62-00-5421 WEARING APPAREL 0.00 388.52 1,740.00 22.3 01-110-62-00-5427 FACADE PROGRAM 20,000.00 20,000.00 20,000.00 100.0 01-110-62-00-5436 TELEPHONE 1,194.44 7,729.45 21,000.00 36.8 01-110-62-00-5437 ACCTG SYSTEM SERVICE FEE 7,790.00 8,090.00 7,650.00 105.7 01-110-62-00-5438 CELLULAR TELEPHONE 216.03 1,069.08 2,300.00 46.4 01-110-62-00-5439 TELEPHONE SYSTEMS MAINTENANCE 0.00 1,411.20 11,000.00 12.8 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 92,055.95 258,726.68 356,582.00 72.5 PROFESSIONAL DEVELOPMENT 01-110-64-00-5600 DUES 2,750.00 3,310.00 4,000.00 82.7 01-110-64-00-5601 ILLINOIS MUNICIPAL LEAGUE DUES 781.00 781.00 690.00 113.1 01-110-64-00-5603 SUBSCRIPTIONS 0.00 230.00 500.00 46.0 01-110-64-00-5604 TRAINING & CONFERENCES 589.00 5,818.60 11,000.00 52.8 01-110-64-00-5605 TRAVEL/MEALS/LODGING 353.31 13,634.06 17,000.00 80.2 01-110-64-00-5607 PUBLIC RELATIONS 0.00 12,074.23 18,000.00 67-0 P4 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 5 LIME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ED: GL470002.WOW FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL g ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ FINANCE & ADMINISTRATION EXPENSES PROFESSIONAL DEVELOPMENT 01-110-64-00-5608 SPONSORSHIPS 0.00 250.00 1,500.00 16.6 ---------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 4,473.31 36,097.89 52,690.00 68.5 OPERATIONS 01-110-65-00-5800 CONTINGENCIES 2,096.40 6,716.40 185,170.00 3.6 01-110-65-00-5801 FUND BALANCE RESERVE 0.00 0.00 0.00 0.0 01-110-65-00-5802 OFFICE SUPPLIES 2,246.33 9,238.20 12,000.00 76.9 01-110-65-00-5804 OPERATING SUPPLIES 686.49 4,136.98 13,000.00 31.8 01-110-65-00-5808 POSTAGE & SHIPPING 947.11 6,060.27 11,000.00 55.0 01-110-65-00-5809 PRINTING & COPYING 192.44 7,675.25 10,500.00 73.0 01-110-65-00-5810 PUBLISHING & ADVERTISING 380.80 1,616.69 3,500.00 46.1 01-110-65-00-5844 MARKETING - HOTEL TAX 1,450.19 10,345.45 20,000.00 51.7 --------------------------------------------------------------------------------- TOTAL OPERATIONS 7,999.76 45,789.24 255,170.00 17.9 RETIREMENT 01-110-72-00-6500 IMRF PARTICIPANTS 3,362.07 30,799.76 47,791.00 64.4 01-110-72-00-6501 SOCIAL SECURITY & MEDICARE 6,505.17 35,522.08 52,821.00 67.2 --------------------------------------------------------------------------------- TOTAL RETIREMENT 9,867.24 66,321.84 100,612.00 65.9 CAPITAL OUTLAY 01-110-75-00-7002 COMPUTER EQUIP & SOFTWARE 359.99 10,693.61 13,500.00 79.2 01-110-75-00-7003 OFFICE EQUIPMENT 412.00 841.92 3,000.00 28.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 771.99 11,535.53 16, 500.00 69.9 OTHER OPERATING EXPENSES 01-110-78-00-9001 CITY TAX REBATE 0.00 70.09 1,200.00 5.8 01-110-78-00-9002 NICOR GAS 2,540.80 14,115.31 30,000.00 47.0 01-110-78-00-9003 SALES TAX REBATE 2,600.07 184,134.71 555,300.00 33.1 01-110-78-00-9004 MISCELLANEOUS 0.00 0.00 100.00 0.0 01-110-78-00-9005 MERIT/PAY EQUITY 0.00 0.00 51,104.00 0.0 ---------------------------------------------------------------------------------- TOTAL OTHER OPERATING EXPENSES 5,140.87 198,320.11 637,704.00 31.0 P5 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 6 LIME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 CD: GL470002.WOW FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL °s ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ FINANCE & ADMINISTRATION TRANSFERS 01-110-99-00-9923 TRANSFER TO LIBRARY 2,625.00 21,000.00 31,500.00 66.6 01-110-99-00-9925 TRANSFER TO SAN SEWER 0.00 75,000.00 150,000.00 50.0 01-110-99-00-9940 TRANSFER TO PARK & RECREATION 77,380.58 619,044.64 928,567.00 66.6 01-110-99-00-9941 TRANSFER TO PARK/REC CAPITAL 0.00 0.00 0.00 0.0 01-110-99-00-9945 TRANSFER TO MUNICIPAL BLDG 0.00 24,761.50 49,523.00 50.0 01-110-99-00-9965 TRANSFER TO DEBT SERVICE 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 80,005.58 739,806.14 1,159,590.00 63.7 TOTAL EXPENSES: FINANCE & ADMINISTRATION 395,521.64 2,882,814.89 5,134,030.00 56.1 ENGINEERING EXPENSES PERSONNEL SERVICES 01-150-50-00-5107 SALARIES-EMPLOYEES 19,529.76 166,643.00 248,919.00 66.9 01-150-50-00-5137 SALARIES-OVERTIME 0.00 0.00 1,000.00 0.0 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 19,529.76 166,643.00 249,919.00 66.6 CONTRACTUAL SERVICES 01-150-62-00-5401 CONTRACTUAL SERVICES 554.07 42,174.54 20,000.00 210.8 01-150-62-00-5402 GIS SYSTEM 0.00 0.00 5,000.00 0.0 01-150-62-00-5403 FEES 0.00 '1,000.00 1,000.00 100.0 01-150-62-00-5409 MAINTENANCE-VEHICLES 40.56 369.54 3,500.00 10.5 01-150-62-00-5410 MAINTENANCE-OFFICE EQUIP 0.00 215.98 1,000.00 21.5 01-150-62-00-5411 MAINTENANCE-COMPUTERS 0.00 186.45 2,500.00 7.4 01-150-62-00-5421 WEARING APPAREL 0.00 0.00 11100.00 0.0 01-150-62-00-5438 CELLULAR TELEPHONE 196.57 1,377.16 2,800.00 49.1 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 791.20 45,323.67 36,900.00 122.8 PROFESSIONAL DEVELOPMENT 01-150-64-00-5600 DUES 0.00 293.00 300.00 97.6 01-150-64-00-5604 TRAINING & CONFERENCES 0.00 0.00 6,000.00 0.0 P6 ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 7 IME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 D: GL470002.WOW FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ----------------------------------------------------------------------------------------------------------------------------------- -;NGINEERING ;XPENSES PROFESSIONAL DEVELOPMENT 01-150-64-00-5605 TRAVEL EXPENSE 0.00 956.40 1,000.00 95.6 01-150-64-00-5616 BOOKS & PUBLICATIONS 0.00 0.00 200.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 0.00 1,249.40 7,500.00 16.6 OPERATIONS 01-150-65-00-5801 ENGINEERING SUPPLIES 24.10 764.06 3,000.00 25.4 01-150-65-00-5802 OFFICE SUPPLIES 78.74 1,081.37 2,500.00 43.2 01-150-65-00-5809 PRINTING & COPYING 13.80 417.16 2,000.00 20.8 01-150-65-00-5814 STORM WATER SOFTWARE/TRAINING 0.00 0.00 0.00 0.0 01-150-65-00-5815 ROB ROY CREEK HYDRAULIC STUDY 0.00 0.00 0.00 0.0 01-150-65-00-5820 PICK UP TRUCK 0.00 0.00 27,500.00 0.0 --------------------------------------------------------------------------------- TOTAL OPERATIONS 116.64 2,262.59 35,000.00 6.4 RETIREMENT 01-150-72-00-6500 IMRF PARTICIPANTS 1,589.74 13,594.12 20,343.00 66.8 01-150-72-00-6501 SOCIAL SECURITY & MEDICARE 1,461.38 12,498.22 19,120.00 65.3 --------------------------------------------------------------------------------- TOTAL RETIREMENT 3,051.12 26,092.34 39,463.00 66.1 CAPITAL OUTLAY 01-150-75-00-7002 COMPUTER EQUIPMENT & SOFTWARE 0.00 2,678.79 3,850.00 69.5 01-150-75-00-7003 OFFICE EQUIPMENT 0.00 69.98 500.00 13.9 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 2,748.77 4,350.00 63.1 TOTAL EXPENSES: ENGINEERING 23,488.72 244,319.77 373,132.00 65.4 PUBLIC SAFETY/POLICE DEPT. EXPENSES PERSONNEL SERVICES 01-210-50-00-5107 SALARIES - EMPLOYEES 49,487.32 409,815.40 608,512.00 67.3 P7 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 8 LIME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 CD: GL470002.WOW FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ PUBLIC SAFETY/POLICE DEPT. EXPENSES PERSONNEL SERVICES 01-210-50-00-5131 SALARIES-CHIEF/LIEUTENANT/SERG 42,826.12 365,785.85 522,284.00 70.0 01-210-50-00-5133 SALARIES - COPS 7,912.62 68,883.63 150,158.00 45.8 01-210-50-00-5134 SALARIES - CROSSING GUARD 1,556.25 9,917.25 19,000.00 52.1 01-210-50-00-5135 SALARIES - POLICE CLERKS 8,148.33 69,260.78 103,626.00 66.8 01-210-50-00-5136 SALARIES - PART TIME 3,464.09 25,758.21 30,000.00 85.8 01-210-50-00-5137 SALARIES - OVERTIME 4,225.77 30,962.20 50,000.00 61.9 01-210-50-00-5200 CADET PROGRAM 842.00 5, 622.67 10,000.00 56.2 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 118,462.50 986,005.99 1,493,580.00 66.0 PROFESSIONAL SERVICES 01-210-61-00-5300 LEGAL SERVICES 498.75 7,411.62 20,000.00 37.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 498.75 7,411.62 20,000.00 37.0 CONTRACTUAL SERVICES 01-210-62-00-5408 MAINTENANCE - EQUIPMENT 1,759.00 5,337.73 8,000.00 66.7 01-210-62-00-5409 MAINTENANCE - VEHICLES 4,429.93 19,092.36 21,000.00 90.9 01-210-62-00-5410 MAINT-OFFICE EQUIPMENT 0.00 1,844.00 2,500.00 73.7 01-210-62-00-5411 MAINTENANCE - COMPUTERS 665.00 972.35 2,100.00 46.3 01-210-62-00-5414 WEATHER WARNING SIREN MAINT 2,569.60 3,309.60 8,000.00 41.3 01-210-62-00-5421 WEARING APPAREL 1,127.77 8,739.20 27,000.00 32.3 01-210-62-00-5422 COPS GRANT IV - VESTS 0.00 425.00 2,500.00 17.0 01-210-62-00-5423 CLASY GRANT 0.00 0.00 1,000.00 0.0 01-210-62-00-5424 ICJIA-JUVENILE 0.00 0.00 0.00 0.0 01-210-62-00-5427 ICJIA BLOCK GRANT 0.00 0.00 0.00 0.0 01-210-62-00-5429 PSYCHOLOGICAL TESTING 0.00 420.00 1,500.00 28.0 01-210-62-00-5430 HEALTH SERVICES 0.00 1,117.08 3,000.00 37.2 01-210-62-00-5431 LABORATORY FEES 0.00 0.00 1,000.00 0.0 01-210-62-00-5436 TELEPHONE 1,423.54 9,136.83 20,000.00 45.6 01-210-62-00-5438 CELLULAR TELEPHONE 943.51 6,812.33 14,000.00 48.6 01-210-62-00-5440 PAGERS 0.00 0.00 0.00 0.0 01-210-62-00-5441 MTD-ALERTS FEE 2,310.00 4,620.00 2,400.00 192.5 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 15,228.35 61,826.48 114,000.00 54.2 P8 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 9 LIME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 CD: GL470002.WOW FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ PUBLIC SAFETY/POLICE DEPT. PROFESSIONAL DEVELOPMENT 01-210-64-00-5600 DUES 481.20 531.20 2,250.00 23.6 01-210-64-00-5603 SUBSCRIPTIONS 0.00 151.95 300.00 50.6 01-210-64-00-5604 TRAINING & CONFERENCE 192.00 12,247.25 19,000.00 64.4 01-210-64-00-5605 TRAVEL EXPENSES 463.19 9,009.73 9,000.00 100.1 01-210-64-00-5606 COMMUNITY RELATIONS 836.07 1,757.72 5,500.00 31.9 01-210-64-00-5607 POLICE COMMISSION 979.04 5,092.28 23,000.00 22.1 01-210-64-00-5608 TUITION REIMBURSEMENT 0.00 2,082.12 14,000.00 14.8 01-210-64-00-5609 POLICE RECRUIT ACADEMY 0.00 0.00 3,500.00 0.0 01-210-64-00-5610 GUN RANGE FEES 0.00 0.00 625.00 0.0 01-210-64-00-5611 SRT FEE 0.00 0.00 2,000.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 2,951.50 30,872.25 79, 175.00 38.9 OPERATIONS 01-210-65-00-5800 CONTINGENCIES 0.00 0.00 0.00 0.0 01-210-65-00-5802 OFFICE SUPPLIES 752.94 3,680.60 6,500.00 56.6 01-210-65-00-5804 OPERATING SUPPLIES 1,345.09 7,269.29 16,000.00 45.4 01-210-65-00-5808 POSTAGE & SHIPPING 0.00 1,008.17 3, 000.00 33.6 01-210-65-00-5809 PRINTING & COPYING 0.00 3,167.03 4,500.00 70.3 01-210-65-00-5810 PUBLISHING & ADVERTISING 0.00 215.28 1,000.00 21.5 01-210-65-00-5812 GASOLINE 4,124.62 29,187.41 36,300.00 80.4 01-210-65-00-5813 AMMUNITION 0.00 0.00 5,000.00 0.0 --------------------------------------------------------------------------------- TOTAL OPERATIONS 6,222.65 44,527.78 72,300.00 61.5 RETIREMENT 01-210-72-00-6500 IMRF PARTICIPANTS 663.28 5,656.86 8,732.00 64.7 01-210-72-00-6501 SOCIAL SECURITY & MEDICARE 8,977.78 75,272.11 115,170.00 65.3 01-210-72-00-6502 POLICE PENSION 8,345.82 231,123.76 231,686.00 99.7 --------------------------------------------------------------------------------- TOTAL RETIREMENT 17,986.88 312,052.73 355,588.00 87.7 CAPITAL OUTLAY 01-210-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 1,878.38 8,500.00 22.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 1,878.38 8,500.00 22.0 P9 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 10 .'IME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 :D: GL470002.WOW FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL °s ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ ?UBLIC SAFETY/POLICE DEPT. OTHER OPERATING EXPENSES 01-210-78-00-9004 BIKE PATROL 0.00 1,422.51 2,000.00 71.1 --------------------------------------------------------------------------------- TOTAL OTHER OPERATING EXPENSES 0.00 1,422.51 2,000.00 71.1 TRANSFERS 01-210-99-00-9910 TRANSFER TO PD CAPITAL FUND 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 0.00 0.0 TOTAL EXPENSES: PUBLIC SAFETY/POLICE DEPT. 161,350.63 1,445,997.74 2,145,143.00 67.4 PLANNING & DEVELOPMENT EXPENSES PERSONNEL SERVICES 01-220-50-00-5107 EMPLOYEE SALARIES 0.00 7,665.00 131,086.00 5.8 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 0.00 7,665.00 131,086.00 5.8 PROFESSIONAL SERVICES 01-220-61-00-5300 LEGAL SERVICES 12,471.12 25,731.18 20,000.00 128.6 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 12,471.12 25,731.18 20,000.00 128.6 CONTRACTUAL SERVICES 01-220-62-00-5401 CONTRACTUAL SERVICES (1,510.00) 28,950.39 50,000.00 57.9 01-220-62-00-5430 PLANNING CONSULTANT 0.00 12,165.42 20,000.00 60.8 01-220-62-00-5432 ECONOMIC DEVELOPMENT 45,000.00 45,000.00 45,000.00 100.0 01-220-62-00-5438 CELULAR TELEPHONE 0.00 0.00 1,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 43,490.00 86,115.81 116,000.00 74.2 PROFESSIONAL DEVELOPMENT 01-220-64-00-5600 DUES 100.00 100.00 200.00 50.0 01-220-64-00-5604 TRAINING & CONFERENCES 0.00 0.00 6,000.00 0.0 P10 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 11 'IME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 CD: GL470002.WOW FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL g ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ PLANNING & DEVELOPMENT EXPENSES PROFESSIONAL DEVELOPMENT 01-220-64-00-5605 TRAVEL EXPENSE 0.00 0.00 3,000.00 0.0 01-220-64-00-5616 BOOKS & PUBLICATIONS 0.00 0.00 425.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 100.00 100.00 9,625.00 1.0 OPERATIONS 01-220-65-00-5804 OPERATING SUPPLIES 55.33 874.02 5,000.00 17.4 01-220-65-00-5809 PRINTING & COPYING 0.00 332.75 2,500.00 13.3 01-220-65-00-5810 PUBLISHING & ADVERTISING 0.00 3,251.17 10,000.00 32.5 01-220-65-00-5814 BOOKS & MAPS 0.00 1,042.00 3,000.00 34.7 --------------------------------------------------------------------------------- TOTAL OPERATIONS 55.33 5,499.94 20,500.00 26.8 RETIREMENT 01-220-72-00-6500 IMRF PARTICIPANTS 0.00 0.00 9,672.00 0.0 01-220-72-00-6501 SOCIAL SECURITY & MEDICARE 0.00 0.00 7,724.00 0.0 --------------------------------------------------------------------------------- TOTAL RETIREMENT 0.00 0.00 17,396.00 0.0 CAPITAL OUTLAY 01-220-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 19.95 7,500.00 0.2 01-220-75-00-7003 OFFICE EQUIPMENT 0.00 235.96 2,500.00 9.4 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 255.91 10,000.00 2.5 TOTAL EXPENSES: PLANNING & DEVELOPMENT 56,116.45 125,367.84 324,607.00 38.6 STREETS EXPENSES PERSONNEL SERVICES 01-410-50-00-5107 SALARIES - EMPLOYEE 17,826.88 115,681.84 182,345.00 63.4 01-410-50-00-5136 SALARIES - PART TIME 0.00 1,484.00 11,000.00 13.4 01-410-50-00-5137 SALARIES - OVERTIME 2,719.08 10,532.69 20,400.00 51.6 P11 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 12 .'IME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 :D: GL470002.WOW FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL e ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ----------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 20,545.96 127,698.53 213,745.00 59.7 PROFESSIONAL SERVICES 01-410-61-00-5313 ENGINEERING - IN TOWN RD PROG 0.00 101,814.23 215,210.00 47.3 01-410-61-00-5314 INSPECTIONS & LICENSES 218.00 298.00 200.00 149.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 218.00 102,112.23 215,410.00 47.4 CONTRACTUAL SERVICES 01-410-62-00-5401 CONTRACTUAL SERVICES 98.32 548.32 2,000.00 27.4 01-410-62-00-5408 MAINTENANCE-EQUIPMENT 2,340.38 3,790.94 9,000.00 42.1 01-410-62-00-5409 MAINTENANCE-VEHICLES 58.54 8,077.31 11,550.00 69.9 01-410-62-00-5414 MAINTENANCE-TRAFFIC SIGNALS 1,987.27 9,486.64 24,000.00 39.5 01-410-62-00-5415 MAINTENANCE-STREET LIGHTS 0.00 13,905.38 25,000.00 55.6 01-410-62-00-5420 MAINTENANCE-STORM SEWER 0.00 0.00 10,000.00 0.0 01-410-62-00-5421 WEARING APPAREL 594.48 1,823.61 6,000.00 30.3 01-410-62-00-5434 RENTAL-EQUIPMENT 0.00 0.00 2,000.00 0.0 01-410-62-00-5435 ELECTRICITY 4,630.20 37,781.31 51,800.00 72.9 01-410-62-00-5438 CELLULAR TELEPHONE 196.57 1,584.58 3,300.00 48.0 01-410-62-00-5440 STREET LIGHTING 0.00 686.50 6,000.00 11.4 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 9,905.76 77,684.59 150,650.00 51.5 PROFESSIONAL DEVELOPMENT 01-410-64-00-5604 TRAINING & CONFERENCES 0.00 2,112.55 5,000.00 42.2 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 0.00 2,112.55 5,000.00 42.2 OPERATIONS 01-410-65-00-5421 GIS SYSTEM 0-00 0.00 0.00 0.0 01-410-65-00-5800 CONTINGENCIES 0.00 0.00 0.00 0.0 01-410-65-00-5804 OPERATING SUPPLIES 1,061.92 13,078.77 25,800.00 50.6 01-410-65-00-5812 GASOLINE 4,808.33 19,710.41 24,000.00 82.1 01-410-65-00-5815 HAND TOOLS 0.00 0.00 2,500.00 0.0 01-410-65-00-5817 GRAVEL 0.00 719.52 6,500.00 11.0 --------------------------------------------------------------------------------- TOTAL OPERATIONS 5,870.25 33,508.70 58,800.00 56.9 P12 ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 13 IME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 D: GL470002.WOW FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ----------------------------------------------------------------------------------------------------------------------------------- ;TREETS RETIREMENT 01-410-72-00-6500 IMRF PARTICIPANTS 1,672.40 10,273.75 16,783.00 61.2 01-410-72-00-6501 SOCIAL SECURITY & MEDICARE 1,571.81 9,769.18 16,616.00 58.7 --------------------------------------------------------------------------------- TOTAL RETIREMENT 3,244.21 20,042.93 33,399.00 60.0 CAPITAL OUTLAY 01-410-75-00-5418 MOSQUITO CONTROL 0.00 20,295.60 28,950.00 70.1 01-410-75-00-5419 MAINT SUPPLIES - STREET 0.00 0.00 0.00 0.0 01-410-75-00-7004 SAFETY EQUIPMENT 121.82 669.21 1,000.00 66.9 01-410-75-00-7099 GRANDE RESERVE PERIMETER ROADS 0.00 315,598.70 4,000,000.00 7.8 01-410-75-00-7100 STREET REHAB PROJECTS 1, 003.55 35,646.99 40,000.00 89.1 01-410-75-00-7101 IN TOWN ROAD PROGRAM 99,859.00 1,394,528.03 2,345,000.00 59.4 01-410-75-00-7102 TREE & STUMP REMOVAL 900.00 9,510.00 30,000.00 31.7 01-410-75-00-7103 SIDEWALK CONSTRUCTION 0.00 0.00 30,000.00 0.0 01-410-75-00-7104 FOX HILL SSA EXPENSES 633.00 6,642.00 18,000.00 36.9 01-410-75-00-7105 IN-TOWN ROAD PRORAM-RESERVE 0.00 0.00 1,575,000.00 0.0 01-410-75-00-7106 ROAD CONTRIBUTION FUND PROJ 201.08 11,042.71 10,000.00 110.4 01-410-75-00-7107 ROAD CONTRIBUTION FUND-RESERVE 0.00 0.00 490,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 102,718.45 1,793, 933.24 8,567,950.00 20.9 TRANSFERS 01-410-99-00-9930 TRANSFER TO WATER IMPROVEMENT 0.00 107,500.00 215,000.00 50.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 107,500.00 215,000.00 50.0 TOTAL EXPENSES: STREETS 142,502.63 2,264,592.77 9,459,954.00 23.9 HEALTH & SANITATION EXPENSES CONTRACTUAL SERVICES 01-540-62-00-5442 GARBAGE SERVICES 48,932.24 332,921.84 565,670.00 58.8 01-540-62-00-5443 LEAF PICKUP 4,200.00 5,250.00 5,500.00 95.4 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 53,132.24 338, 171.84 571,170.00 59.2 P13 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 14 'IME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 =D: GL470002.WOW FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TOTAL EXPENSES: HEALTH & SANITATION 53,132.24 338,171.84 571,170.00 59.2 DOTAL FUND REVENUES 1,603,828.05 10,564,856.01 18,008,036.00 58.6 TOTAL FUND EXPENSES 832,112.31 7,301,264.85 18,008,036.00 40.5 FUND SURPLUS (DEFICIT) 771,715.74 3,263,591.16 0.00 100.0 P14 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 15 LIME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 CD: GL470002.WOW FUND: MOTOR FUEL TAX FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES TAXES 15-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 475,000.00 0.0 15-000-40-00-4060 MOTOR FUEL TAX ALLOTMENTS 22,986.69 182,478.88 268,304.00 68.0 15-000-40-00-4065 IDOT TRUCK ACCESS GRANT 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL TAXES 22,986.69 182,478.88 743,304.00 24.5 MISCELLANEOUS 15-000-44-00-4490 MISCELLANEOUS INCOME 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 0.00 0.00 0.00 0.0 INTEREST 15-000-46-00-4600 INVESTMENT INCOME 1,423.16 9,331.58 5,000.00 186.6 --------------------------------------------------------------------------------- TOTAL INTEREST 1,423.16 9,331.58 5,000.00 186.6 TOTAL REVENUES: 24,409.85 191,810.46 748,304.00 25.6 EXPENSES OPERATIONS 15-000-65-00-5800 CONTINGENCY 0.00 11, 936.00 145,250.00 8.2 15-000-65-00-5818 SALT 19,580.13 19,580.13 51,800.00 37.7 --------------------------------------------------------------------------------- TOTAL OPERATIONS 19,580.13 31,516.13 197,050.00 15.9 CAPITAL OUTLAY 15-000-75-00-7007 SIGNS 3,216.99 7,049.84 9,990.00 70.5 15-000-75-00-7008 CRACK FILLING 0.00 28,797.41 30,000.00 95.9 15-000-75-00-7107 CONSTRUCTION ENGINEERING 0.00 45,205.34 150,000.00 30.1 15-000-75-00-7108 VAN EMMON STREET 0.00 0.00 0.00 0.0 15-000-75-00-7110 COLD PATCH 0.00 197.73 9,600.00 2.0 15-000-75-00-7111 HOT PATCH 0.00 1,830.18 8,000.00 22.8 15-000-75-00-7112 FAXON ROAD ENGINEERING 0.00 0.00 1,000.00 0.0 15-000-75-00-7113 COUNTRYSIDE PKWY CONSTRUCTION 0.00 0.00 300,000.00 0.0 P15 DATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 16 DIME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: MOTOR FUEL TAX FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 3,216.99 83,080.50 508,590.00 16.3 TRANSFERS 15-000-99-00-9960 TRANSFER TO FOX IND FUND 0.00 31,189.68 42,664.00 73.1 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 31,189.68 42,664.00 73.1 TOTAL EXPENSES: 22,797.12 145,786.31 748,304.00 19.4 TOTAL FUND REVENUES 24,409.85 191,810.46 748,304.00 25.6 TOTAL FUND EXPENSES 22,797.12 145,786.31 748,304.00 19.4 FUND SURPLUS (DEFICIT) 1,612.73 46,024.15 0.00 100.0 P16 DATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 17 TIME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: MUNICIPAL BUILDLING FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 16-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 45,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 45,000.00 0.0 CHARGES FOR SERVICES 16-000-42-00-4211 DEVELOPMENT FEES-BUILDING 28,950.00 48,000.00 105,000.00 45.7 16-000-42-00-4215 BEECHER RENTAL FEE 3,000.00 3, 000.00 0.00 100.0 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 31,950.00 51,000.00 105,000.00 48.5 TRANSFERS 16-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 24,761.50 49,523.00 50.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 24,761.50 49,523.00 50.0 TOTAL REVENUES: 31,950.00 75,761.50 199,523.00 37.9 EXPENSES CONTRACTUAL SERVICES 16-000-62-00-5416 MAINT-GENERAL BLDG & GROUNDS 0.00 225.00 8,000.00 2.8 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 0.00 225.00 8,000.00 2.8 CAPITAL OUTLAY 16-000-75-00-7008 ENTRY WAY SIGNS 0.00 0.00 3,600.00 0.0 16-000-75-00-7200 BLDG IMPROV- BEEHCER/RIVFRNT 2,830.57 6, 100.48 13,000.00 46.9 16-000-75-00-7202 BLDG IMPROVEMENTS-CITY HALL 0.00 0.00 0.00 0.0 16-000-75-00-7203 BLDG IMPROVEMENTS-PUBLIC WORKS 150.00 9,072.40 10,000.00 90.7 16-000-75-00-7204 BLDG MAINT - CITY HALL 850.00 9, 173.75 10,000.00 91.7 16-000-75-00-7205 BLDG IMPROVEMENTS-LIBRARY 742.00 2,223.20 4,000.00 55.5 16-000-75-00-7206 LANDSCAPING-PUBLIC BUILDINGS 0.00 0.00 2,000.00 0.0 16-000-75-00-7209 BEECHER PARKING LOT 0.00 41,119.60 45,000.00 91.3 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 4,572.57 67,689.43 87,600.00 77.2 P17 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 18 LIME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 CD: GL470002.WOW FUND: MUNICIPAL BUILDLING FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL g ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ OTHER 16-000-78-00-9009 RESERVE 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 0.00 0.0 TRANSFERS 16-000-99-00-9965 TRANSFER TO DEBT SERVICE 0.00 51,961.50 103,923.00 50.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 51,961.50 103,923.00 50.0 TOTAL EXPENSES: 4,572.57 119,875.93 199,523.00 60.0 TOTAL FUND REVENUES 31,950.00 75,761.50 199,523.00 37.9 TOTAL FUND EXPENSES 4,572.57 119,875.93 199,523.00 60.0 FUND SURPLUS (DEFICIT) 27,377.43 (44,114.43) 0.00 100.0 P18 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 19 LIME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 [D: GL470002.WOW FUND: POLICE EQUIPMENT CAPITAL FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 20-000-40-00-3999 CARRY OVER -WEATHER WARN SIREN 0.00 0.00 70,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 70,000.00 0.0 CHARGES FOR SERVICES 20-000-42-00-4212 DEV FEES - POLICE 63,150.00 110,100.00 146,250.00 75.2 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 63,150.00 110,100.00 146,250.00 75.2 MISCELLANEOUS 20-000-44-00-4402 K-9 DONATIONS 0.00 200.00 1,000.00 20.0 20-000-44-00-4403 IN CAR VIDEO DONATIONS 600.00 3,270.00 2,200.00 148.6 20-000-44-00-4404 DONATIONS 0.00 1,500.00 500.00 300.0 20-000-44-00-4405 WEATHER WARNING SIREN 16, 844.25 29,230.50 30, 000.00 97.4 20-000-44-00-4431 SALE OF POLICE SQUADS 0.00 0.00 500.00 0.0 20-000-44-00-4489 RICP DISASTER PLAN GRANT 9,990.27 9,990.27 0.00 100.0 20-000-44-00-4490 MISCELLANEOUS INCOME 0.00 24,609.27 0.00 100.0 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 27,434.52 68,800.04 34,200.00 201.1 OTHER OPERATING RECEIPTS 20-000-48-00-4800 LOAN PROCEEDS 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER OPERATING RECEIPTS 0.00 0.00 0.00 0.0 TRANSFERS 20-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 0.00 0.0 TOTAL REVENUES: 90,584.52 178,900.04 250,450.00 71.4 EXPENSES WEAPONS P19 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 20 LIME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 CD: GL470002.WOW FUND: POLICE EQUIPMENT CAPITAL FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL °s ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES WEAPONS 20-000-65-00-5811 LETHAL/NON-LETHAL WEAPONS 0.00 1,962.00 6,825.00 28.7 --------------------------------------------------------------------------------- TOTAL WEAPONS 0.00 1,962.00 6,825.00 28.7 CAPITAL OUTLAY 20-000-75-00-7001 EQUIPMENT 0.00 0.00 0.00 0.0 20-000-75-00-7002 K-9 EQUIPMENT 0.00 0.00 1,000.00 0.0 20-000-75-00-7003 EXPEDITION AND ACCESSORIES 0.00 0.00 0.00 0.0 20-000-75-00-7005 VEHICLES 0.00 72,384.64 74,000.00 97.8 20-000-75-00-7006 CAR BUILD OUT 4,198.40 4,850.16 26,000.00 18.6 20-000-75-00-7008 NEW WEATHER WARNING SIRENS 0.00 0.00 60,000.00 0.0 20-000-75-00-7009 RESERVE-WEATHER WARNING SIREN 0.00 0.00 40,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 4,198.40 77,234.80 201,000.00 38.4 OTHER 20-000-78-00-9009 RESERVE 2,352.00 10,587.51 18,515.00 57.1 --------------------------------------------------------------------------------- TOTAL OTHER 2,352.00 10,587.51 18,515.00 57.1 TRANSFERS 20-000-99-00-9965 TRANSFER TO DEBT SERV FUND 0.00 12,055.00 24,110.00 50.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 12,055.00 24,110.00 50.0 TOTAL EXPENSES: 6,550.40 101,839.31 250,450.00 40.6 TOTAL FUND REVENUES 90,584.52 178,900.04 250,450.00 71.4 TOTAL FUND EXPENSES 6,550.40 101,839.31 250,450.00 40.6 FUND SURPLUS (DEFICIT) 84,034.12 77,060.73 0.00 100.0 P20 DATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 21 LIME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: PUBLIC WORKS EQUIP CAPITAL FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL °s ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 21-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 234,174.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 234,174.00 0.0 CHARGES FOR SERVICES 21-000-42-00-4213 DEVELOPMENT FEES-PUBLIC WORKS 150,450.00 273,600.00 383,750.00 71.2 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 150,450.00 273,600.00 383,750.00 71.2 MISCELLANEOUS 21-000-44-00-4430 SALE OF EQUIPMENT 0.00 34,113.84 32,000.00 106.6 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 0.00 34,113.84 32,000.00 106.6 TRANSFERS 21-000-49-00-4915 TRANSFER FROM WATER FUND 0.00 25,000.00 50,000.00 50.0 21-000-49-00-4920 TRANSFER FROM SEWER FUND 0.00 15,000.00 30, 000.00 50.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 40,000.00 80,000.00 50.0 TOTAL REVENUES: 150,450.00 347,713.84 729,924.00 47.6 EXPENSES CAPITAL OUTLAY 21-000-75-00-7001 EQUIMPENT 0.00 0.00 85,000.00 0.0 21-000-75-00-7005 VEHICLES 0.00 184,968.00 375, 000.00 49.3 21-000-75-00-7006 F150 PICK UPS 0.00 0.00 0.00 0.0 21-000-75-00-7007 5 YARD DUMP 0.00 0.00 0.00 0.0 21-000-75-00-7008 WATER DEPT PICK UP 0.00 0.00 0.00 0.0 21-000-75-00-7009 1 TON DUMP 0.00 0.00 0.00 0.0 21-000-75-00-7010 POWER BREAKER 0.00 0.00 0.00 0.0 21-000-75-00-7015 SKIDSTEER UPGRADE 0.00 3,951.86 3,500.00 112.9 21-000-75-00-7100 BOB CAT EXCHANGE 0.00 0.00 0.00 0.0 21-000-75-00-7107 TRUCK ACCESSORIES 3,483.00 9,602.73 14,000.00 68.5 P21 DATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 22 TIME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: PUBLIC WORKS EQUIP CAPITAL FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL $ ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES CAPITAL OUTLAY 21-000-75-00-7108 SKIDSTEE GRADER 0.00 0.00 0.00 0.0 21-000-75-00-7109 MOWER 0.00 0.00 0.00 0.0 21-000-75-00-7110 LEAF CHOPPER/VAC 0.00 0.00 0.00 0.0 21-000-75-00-7115 SALT DOME 0.00 0.00 175,000.00 0.0 21-000-75-00-7120 STREET SWEEPER 0.00 0.00 0.00 0.0 21-000-75-00-7130 PUBLIC WORKS BLDG ADDITION 0.00 0.00 77,424.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 3,483.00 198,522.59 729,924.00 27.1 OTHER 21-000-78-00-9009 RESERVE 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 0.00 0.0 TOTAL EXPENSES: 3,483.00 198,522.59 729,924.00 27.1 TOTAL FUND REVENUES 150,450.00 347,713.84 729,924.00 47.6 TOTAL FUND EXPENSES 3,483.00 198,522.59 729,924.00 27.1 FUND SURPLUS (DEFICIT) 146,967.00 149,191.25 0.00 100.0 P22 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 23 'IME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 :D: GL470002.WOW FUND: PARKS & REC EQUIP CAPITAL FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL g ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED •----------------------------------------------------------------------------------------------------------------------------------- ZEVENUES CARRY OVER 22-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 0.00 0.0 CHARGES FOR SERVICES 22-000-42-00-4216 PARKS CAPITAL FEE 900.00 4,200.00 13,750.00 30.5 22-000-42-00-4217 PARKS CAPITAL - DONATIONS 0.00 7,000.00 0.00 100.0 22-000-42-00-4218 IL CLEAN ENERGY GRANT 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 900.00 11,200.00 13,750.00 81.4 MISCELLANEOUS 22-000-44-00-4430 SALE OF VEHICLES/EQUIPMENT 0.00 0.00 10,000.00 0.0 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 0.00 0.00 10, 000.00 0.0 TRANSFERS 22-000-49-00-4930 TRANSFER FRM GENERAL FUND 0.00 0.00 0.00 0.0 22-000-49-00-4935 TRANSFER FROM LAND CASH 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 0.00 0.0 TOTAL REVENUES: 900.00 11,200.00 23,750.00 47.1 EXPENSES OTHER 22-000-65-00-5800 RESERVE 0.00 0.00 1,650.00 0.0 22-000-65-00-5805 BEECHER LIGHTING 0.00 0.00 0.00 0.0 -----------------------7--------------------------------------------------------- TOTAL OTHER 0.00 0.00 1,650.00 0.0 PARKS EXPENSES P23 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 24 LIME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 [D: GL470002.WOW FUND: PARKS & REC EQUIP CAPITAL FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL °s ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ PARKS CAPITAL OUTLAY 22-610-75-00-7005 VEHICLES 0.00 0.00 0.00 0.0 22-610-75-00-7006 PICK UP TRUCK 0.00 0.00 0.00 0.0 22-610-75-00-7007 SOCCER GOALS 12' REPLACEMENT 0.00 0.00 0.00 0.0 22-610-75-00-7008 SOCCER GOALS 9' 0.00 0.00 0.00 0.0 22-610-75-00-7009 COMPUTER WORKSTATIONS 0.00 0.00 9,000.00 0.0 22-610-75-00-7010 TOWN SQUARE FOUNTAIN 0.00 0.00 0.00 0.0 22-610-75-00-7011 UTILITY TRAILER 0.00 0.00 0.00 0.0 22-610-75-00-7012 PLAYGROUNDS 0.00 630.00 0.00 (100.0) 22-610-75-00-7013 PLAYGROUND REPAIRS 0.00 0.00 2,500.00 0.0 22-610-75-00-7014 SIGN REPLACEMENTS 0.00 0.00 4,000.00 0.0 22-610-75-00-7015 MOWER 0.00 0.00 0.00 0.0 22-610-75-00-7016 BEECHER PATHWAY 0.00 0.00 0.00 0.0 22-610-75-00-7017 RECREATION EQUIPMENT 600.00 6,174.76 6,600.00 93.5 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 600.00 6,804.76 22, 100.00 30.7 TOTAL EXPENSES: PARKS 600.00 6,804.76 22,100.00 30.7 TOTAL FUND REVENUES 900.00 11,200.00 23,750.00 47.1 TOTAL FUND EXPENSES 600.00 6,804.76 23,750.00 28.6 FUND SURPLUS (DEFICIT) 300.00 4,395.24 0.00 100.0 P24 DATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 25 TIME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: SANITARY SEWER IMPROVEMENT FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 37-000-40-00-3999 CARRY OVER 0.00 0.00 3,720,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 3,720,000.00 0.0 CHARGES FOR SERVICES 37-000-42-00-4220 CONNECTION FEES 374,400.00 737,600.00 1,260,000.00 58.5 37-000-42-00-4221 RIVER CROSSING FEES 430.50 5,482.50 20,000.00 27.4 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 374,830.50 743,082.50 1,280,000.00 58.0 INTEREST 37-000-46-00-4600 INVESTMENT INCOME 40,076.46 90,672.04 35,000.00 259.0 --------------------------------------------------------------------------------- TOTAL INTEREST 40,076.46 90,672.04 35,000.00 259.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 12,100,312.50 12,150,312.50 10,000,000.00 121.5 37-000-48-00-4804 SOUTHWEST SVC AREA INTERCEPTOR 0.00 0.00 5,500,000.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER OPERATING RECEIPTS 12,100,312.50 12,150,312.50 15,500,000.00 78.3 TRANSFERS 37-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 75,000.00 150,000.00 50.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 75,000.00 150,000.00 50.0 TOTAL REVENUES: 12,515,219.46 13,059,067.04 20,685,000.00 63.1 EXPENSES CONTRACTUAL SERVICES 37-000-62-00-5401 CONTRACTURAL/PROFESSIONAL SERV 3,012.00 3,012.00 50,000.00 6.0 P25 DATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 26 TIME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: SANITARY SEWER IMPROVEMENT FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES CONTRACTUAL SERVICES 37-000-62-00-5402 ENG/LGL/CONTINGNCY-COUNTRYSIDE 9,090.59 53,735.74 300,000.00 17.9 37-000-62-00-5405 ENG/LGL/CONTINGENCY-BRUELL ST. 6,177.62 84,385.32 70,000.00 120.5 37-000-62-00-5406 ENG/LGL/CONTINGENCY-HYDRAULIC 0.00 1,940.43 0.00 (100.0) 37-000-62-00-5407 ENG/LGL/CONTING ROB ROY CREEK 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 18,280.21 143,073.49 420,000.00 34.0 OTHER 37-000-65-00-5421 GIS SYSTEM 0.00 0.00 10,000.00 0.0 37-000-65-00-5800 CONTINGENCY 0.00 0.00 86,952.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 96,952.00 0.0 DEBT SERVICE 37-000-66-00-6012 DEBT ISSUANCE COSTS 85,674.50 85,674.50 0.00 (100.0) --------------------------------------------------------------------------------- TOTAL DEBT SERVICE 85,674.50 85,674.50 0.00 (100.0) CAPITAL OUTLAY 37-000-75-00-7109 CONTRACTUAL/PROFESSIONAL SVC 0.00 0.00 0.00 0.0 37-000-75-00-7502 HYDRAULIC INTERCEPTOR 0.00 0.00 0.00 0.0 37-000-75-00-7503 COUNTRYSIDE INTERCEPTOR 665,093.13 1,332,844.13 2,850,000.00 46.7 37-000-75-00-7504 BRUELL STREET LIFT STATION 282.00 633,246.83 500,000.00 126.6 37-000-75-00-7505 ROB ROY CREEK SANITARY 221,980.80 2,137,377.01 10,000,000.00 21.3 37-000-75-00-7506 SOUTHWEST SVC AREA INTERCEPTOR 3,750.00 96,287.50 5,500,000.00 1.7 37-000-75-00-7507 SANITARY JETTER TRUCK 0.00 0.00 0.00 0.0 37-000-75-00-7508 MANHOLE REHAB PROJECT 0.00 0.00 15,000.00 0.0 37-000-75-00-7509 SCADA SYSTEM 0.00 0.00 100,000.00 0.0 37-000-75-00-7515 HEARTLAND ONSITE INTERCEPTOR 0.00 278,893.00 278,893.00 100.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 891,105.93 4,478,648.47 19,243,893.00 23.2 TRANSFERS 37-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 100,000.00 200,000.00 50.0 37-000-99-00-9965 TRANSFER TO DEBT SERVICE 0.00 323,106.50 724,155.00 44.6 P26 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 27 'IME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 :D: GL470002.WOW FUND: SANITARY SEWER IMPROVEMENT FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL $ ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 423,106.50 924,155.00 45.7 TOTAL EXPENSES: 995,060.64 5,130,502.96 20,685,000.00 24.8 DOTAL FUND REVENUES 12,515,219.46 13,059,067.04 20,685,000.00 63.1 DOTAL FUND EXPENSES 995,060.64 5,130,502.96 20,685,000.00 24.8 FUND SURPLUS (DEFICIT) 11,520,158.82 7,928,564.08 0.00 100.0 P27 DATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 28 TIME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: WATER IMPROV. EXPANSION FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL g ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 41-000-40-00-3999 CARRY OVER 0.00 0.00 4,700,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 4,700,000.00 0.0 CHARGES FOR SERVICES 41-000-42-00-4220 CONNECTION FEES 421,260.00 859,720.00 1, 125,000.00 76.4 41-000-42-00-4221 SOUTHWEST WATER MAIN REVENUE 0.00 0.00 0.00 0.0 41-000-42-00-4230 SOUTHWEST WATER MAIN PROJ REV 0.00 0.00 2,600,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 421,260.00 859,720.00 3,725,000.00 23.0 MISCELLANEOUS 41-000-44-00-4490 MISCELLANEOUS INCOME 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 0.00 0.00 0.00 0.0 INTERGOVERNMENTAL 41-000-45-00-4530 RADIUM GRANT 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL INTERGOVERNMENTAL 0.00 0.00 0.00 0.0 INTEREST 41-000-46-00-4600 INVESTMENT INCOME 8,571.46 46,776.53 35,000.00 133.6 --------------------------------------------------------------------------------- TOTAL INTEREST 8,571.46 46,776.53 35,000.00 133.6 OTHER OPERATING RECEIPTS 41-000-48-00-4800 LOAN PROCEEDS 0.00 0.00 0.00 0.0 41-000-48-00-4801 IEPA LOAN/CONTRACT B PROCEEDS 0.00 2,046,892.96 0.00 100.0 41-000-48-00-4802 PROCEEDS ON SALE OF ASSETS 0.00 0.00 0.00 0.0 41-000-48-00-4803 LOAN PROCEEDS-CENTRAL ZONE 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER OPERATING RECEIPTS 0.00 2,046,892.96 0.00 100.0 TRANSFERS P28 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 29 'IME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 :D: GL470002.WOW FUND: WATER IMPROV. EXPANSION FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED •----------------------------------------------------------------------------------------------------------------------------------- ZEVENUES TRANSFERS 41-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 107,500.00 215,000.00 50.0 41-000-49-00-4915 TRANSFER FROM WATER FUND 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 107,500.00 215,000.00 50.0 TOTAL REVENUES: 429,831.46 3,060,889.49 8,675, 000.00 35.2 EXPENSES PROFESSIONAL SERVICE 41-000-61-00-5300 LEGAL SERVICES 0.00 2,928.20 8,000.00 36.6 41-000-61-00-5301 ENGINEERING - GENERAL SERVICES 0.00 12,681.00 8,000.00 158.5 41-000-61-00-5400 RADIUM COMPLIANCE -CONTRACT B 558,359.10 558,359.10 3,662,730.00 15.2 41-000-61-00-5401 ENGINEERING-RADIUM CONTRACT B 8,013.89 53,686.05 425,000.00 12.6 41-000-61-00-5405 PROF. SVCS- RADIUM CONTRACT B 415.86 29,701.39 250,000.00 11.8 41-000-61-00-5408 CENTRAL ZONE - CONTRACT C 0.00 17,382.91 150,000.00 11.5 41-000-61-00-5410 ENGINEERING-CENTRAL ZONE 511.88 30,659.28 20,000.00 153.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 5,260.60 100,000.00 5.2 41-000-61-00-5415 USGS GROUNDWATER STUDY 0.00 25,315.00 24,490.00 103.3 41-000-61-00-5416 USGS GROUNDWATER COUNTYWIDE 0.00 1,953.00 13,000.00 15.0 41-000-61-00-5417 USGS GROUNDWATER SHALLOW WATER 0.00 32,019.50 55,108.00 58.1 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICE 567,300.73 769,946.03 4,716,328.00 16.3 OTHER 41-000-65-00-5421 GIS SYSTEM 0.00 0.00 10,000.00 0.0 41-000-65-00-5800 CONTINGENCY 0.00 1,532.50 8,353.00 18.3 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 1,532.50 18,353.00 8.3 DEBT SERVICE 41-000-66-00-6012 DEBT CERTIFICATE EXPENSES 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL DEBT SERVICE 0.00 0.00 0.00 0.0 P29 DATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 30 TIME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: WATER IMPROV. EXPANSION FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL k ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ CAPITAL OUTLAY 41-000-75-00-7503 SOUTHWEST WATER MAIN PROJECT 0.00 19,026.33 2,600,000.00 0.7 41-000-75-00-7504 NORTH WATER TOWER-CONTRACT A 121,152.29 227,267.37 130,000.00 174.8 41-000-75-00-7506 APPLETREE COURT 0.00 0.00 0.00 0.0 41-000-75-00-7507 OVERSIZING - HEARTLAND CIRCLE 0.00 38,877.00 38,877.00 100.0 41-000-75-00-7509 SCADA SYSTEM 0.00 0.00 420,000.00 0.0 41-000-75-00-7515 JOHNSON STREET WATER MAIN 0.00 0.00 0.00 0.0 41-000-75-00-7520 WATERMAIN PROJECTS 0.00 0.00 40,000.00 0.0 41-000-75-00-7521 RADIO-READ METER RETRO-FITTING 0.00 0.00 0.00 0.0 41-000-75-00-7522 IN TOWN ROAD PROG WATER PROJ 0.00 0.00 215,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 121,152.29 285,170.70 3,443,877.00 8.2 TRANSFERS 41-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 100,000.00 200,000.00 50.0 41-000-99-00-9965 TRANSFER TO DEBT FUND 0.00 148,221.00 296,442.00 50.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 248,221.00 496,442.00 50.0 TOTAL EXPENSES: 688,453.02 1,304,870.23 8,675,000.00 15.0 TOTAL FUND REVENUES 429,831.46 3,060,889.49 8,675,000.00 35.2 TOTAL FUND EXPENSES 688,453.02 1,304,870.23 8,675,000.00 15.0 FUND SURPLUS (DEFICIT) (258,621.56) 1,756,019.26 0.00 100.0 P30 DATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 31 TIME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: DEBT SERVICE FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL g ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 42-000-40-00-3999 CARRY OVER 0.00 0.00 10,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 10,000.00 0.0 MISCELLANEOUS 42-000-44-00-4440 RECAPTURE-WATER/SEWER 18,467.76 78,330.39 100,000.00 78.3 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 18,467.76 78,330.39 100,000.00 78.3 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 0.00 12, 055.00 24, 110.00 50.0 42-000-49-00-4920 TRANSFER FROM SEWER FUND 0.00 0.00 0.00 0.0 42-000-49-00-4925 TRANSFER FROM SANITARY SEWER 0.00 323,106.50 646,213.00 50.0 42-000-49-00-4930 TRANSFER FROM WATER IMPRV FUND 0.00 148,221.00 296,442.00 50.0 42-000-49-00-4940 TRANSFER FROM MUNICIPAL BLDG 0.00 51,961.50 103,923.00 50.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 535,344.00 1,070,688.00 50.0 TOTAL REVENUES: 18,467.76 613,674.39 1, 180,688.00 51.9 EXPENSES DEBT SERVICE 42-000-66-00-6001 CITY HALL BONDS-PRINCIPAL PMT 50,000.00 50,000.00 50,000.00 100.0 42-000-66-00-6002 CITY HALL BONDS - INTEREST PMT 26,961.25 53,922.50 53,923.00 99.9 42-000-66-00-6003 IRBB-BRUELL ST. INTEREST PMTS 0.00 42,717.50 85,435.00 50.0 42-000-66-00-6004 IRBB-BRUELL ST. PRINCIPAL PYMT 0.00 0.00 80,000.00 0.0 42-000-66-00-6005 NORTH H2O TOWER INTEREST PYMT 0.00 1,912.25 1,912.00 100.0 42-000=66-00-6006 NORTH H2O TOWER PRINCIPAL PYMT 0.00 23,087.75 23,088.00 99.9 42-000-66-00-6007 4.8 MILLION DEBT CERT INT PYMT 116,575.00 233, 150.00 233, 150.00 100.0 42-000-66-00-6008 COUNTRYSIDE ALT REV PRINC PYMT 120,000.00 120,000.00 120,000.00 100.0 42-000-66-00-6009 COUNTRYSIDE ALT REV INT PYMT 60,318.75 120,637.50 120,638.00 99.9 42-000-66-00-6010 COMED/HYDRAULIC INTEREST PYMT 21,608.25 43,216.50 43,128.00 100.2 42-000-66-00-6011 COM ED/HYDRAUL DEBT CERT PRINC 135,000.00 135,000.00 135,000.00 100.0 P31 DATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 32 TIME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: DEBT SERVICE FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL o ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES DEBT SERVICE 42-000-66-00-6050 LOAN PAYMENT-SANITARY SIPHON 19,489.99 38,979.98 38,980.00 99.9 42-000-66-00-6051 LOAN PAYMENT-NORTH WTR/SWR-EDC 0.00 0.00 0.00 0.0 42-000-66-00-6052 LOAN PAYMENT-NORTH WTR/SWR-YNB 0.00 0.00 0.00 0.0 42-000-66-00-6053 LOAN PAYMENT-RIVER CROSSING 0.00 0.00 0.00 0.0 42-000-66-00-6054 LOAN PAYMENT-POLICE SQUAD CAR 0.00 24,037.15 24,110.00 99.6 42-000-66-00-6055 LOAN PAYMENT-SSES IEPA L171153 0.00 53,525.35 107,051.00 49.9 42-000-66-00-6056 YNB-POLICE/ADMIN CARS 0.00 0.00 0.00 0.0 42-000-66-00-6058 ROAD IMPROV. PROG. INT PYMT 0.00 0.00 0.00 0.0 42-000-66-00-6070 $650K ROAD IMPROV PROG INT 14,272.50 14,272.50 14,273.00 99.9 42-000-66-00-6071 $650K ROAD IMPROV PROG PRINC 50,000.00 50,000.00 50,000.00 100.0 42-000-66-00-6072 $2 MIL ALT REV B.2&3 INT PYMT 29,799.58 29,799.58 0.00 (100.0) --------------------------------------------------------------------------------- TOTAL DEBT SERVICE 644,025.32 1,034,258.56 1,180,688.00 87.5 TOTAL FUND REVENUES 18,467.76 613,674.39 1,180,688.00 51.9 TOTAL FUND EXPENSES 644,025.32 1,034,258.56 1,180,688.00 87.5 FUND SURPLUS (DEFICIT) (625,557.56) (420,584.17) 0.00 100.0 P32 DATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 33 TIME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 51-000-40-00-3999 CARRY OVER BALANCE 0.00 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 3,350.00 9,861.90 10,000.00 98.6 51-000-42-00-4241 WATER SALES 183,124.75 871,349.07 900,000.00 96.8 51-000-42-00-4242 WATER METER SALES 73,450.00 176,975.00 . 130,000.00 136.1 51-000-42-00-4243 LEASE REVENUE - H2O TOWER 1,854.00 14,832.00 21,600.00 68.6 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 261,778.75 1,073,017.97 1,061,600.00 101.0 MISCELLANEOUS 51-000-44-00-4490 MISCELLANEOUS INCOME 0.00 290.00 2,000.00 14.5 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 0.00 290.00 2,000.00 14.5 INTEREST 51-000-46-00-4600 INVESTMENT INCOME 1,445.29 11,141.76 12,000.00 92.8 --------------------------------------------------------------------------------- TOTAL INTEREST 1,445.29 11, 141.76 12,000.00 92.8 TOTAL REVENUES: 263,224.04 1,084,449.73 2,575,600.00 42.1 EXPENSES PERSONNEL 51-000-50-00-5107 SALARIES - EMPLOYEE 20,250.57 169,445.42 264,873.00 63.9 51-000-50-00-5136 SALARIES-PART TIME 0.00 5,216.00 8,200.00 63.6 51-000-50-00-5137 SALARIES - OVERTIME 4,483.27 27,970.03 27,000.00 103.5 --------------------------------------------------------------------------------- TOTAL PERSONNEL 24,733.84 202,631.45 300,073.00 67.5 PROFESSIONAL SERVICES 51-000-61-00-5300 LEGAL SERVICES 0.00 337.50 2,000.00 16.8 P33 kTE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 34 IME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 GL470002.WOW FUND: WATER OPERATIONS FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL g ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ----------------------------------------------------------------------------------------------------------------------------------- XPENSES PROFESSIONAL SERVICES 51-000-61-00-5303 JULIE SERVICE 1,510.90 5,589.75 6,800.00 82.2 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 1,510.90 5,927.25 8,800.00 67.3 CONTRACTURAL SERVICES 51-000-62-00-5401 CONTRACUAL SERVICES 335.24 2,430.62 4,500.00 54.0 51-000-62-00-5407 TREATMENT FACILITIES O&M 8,477.20 42,665.41 150,000.00 28.4 51-000-62-00-5408 MAINTENANCE-EQUIPMENT 205.89 506.39 9,000.00 5.6 51-000-62-00-5409 MAINTENANCE - VEHICLES 0.00 339.98 7,000.00 4.8 51-000-62-00-5411 MAINTENANCE-COMPUTERS 0.00 0.00 1,000.00 0.0 51-000-62-00-5413 MAINTENANCE-CONTROL SYSTEM 0.00 500.37 10,000.00 5.0 51-000-62-00-5414 TRUCK LETTERING 0.00 0.00 0.00 0.0 51-000-62-00-5421 WEARING APPAREL 0.00 1,952.12 5,500.00 35.4 51-000-62-00-5422 WATER TOWER PAINTING 0.00 209,870.00 220,000.00 95.3 51-000-62-00-5434 RENTAL - EQUIPMENT 0.00 0.00 11000.00 0.0 51-000-62-00-5435 ELECTRICITY 14,572.14 77,362.06 170,000.00 45.5 51-000-62-00-5436 TELEPHONE 1,435.90 9,472.62 22,600.00 41.9 51-000-62-00-5438 CELLULAR TELEPHONE 423.58 2,127.70 5,700.00 37.3 --------------------------------------------------------------------------------- TOTAL CONTRACTURAL SERVICES 25,449.95 347,227.27 606,300.00 57.2 PROFESSIONAL DEVELOPMENT 51-000-64-00-5600 DUES 0.00 0.00 1,000.00 0.0 51-000-64-00-5603 SUBSCRIPTIONS 0.00 42.30 250.00 16.9 51-000-64-00-5604 TRAINING & CONFERENCES 0.00 1,977.34 3,000.00 65.9 51-000-64-00-5605 TRAVEL EXPENSES 0.00 803.24 3,000.00 26.7 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 0.00 2,822.88 7,250.00 38.9 OPERATIONS 51-000-65-00-5800 CONTINGENCIES 0.00 0.00 30,000.00 0.0 51-000-65-00-5804 OPERATING SUPPLIES 1,566.72 26,959.94 46,200.00 58.3 51-000-65-00-5808 POSTAGE & SHIPPING 2,014.02 8,479.16 13,500.00 62.8 51-000-65-00-5809 PRINTING & COPYING 147.50 5,258.02 5,500.00 95.6 51-000-65-00-5810 PUBLISHING & ADVERTISING 0.00 150.00 1,000.00 15.0 P34 ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 35 IME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 D: GL470002.WOW FUND: WATER OPERATIONS FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL g ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ----------------------------------------------------------------------------------------------------------------------------------- XPENSES OPERATIONS 51-000-65-00-5812 GASOLINE 3,163.65 14,629.03 9,570.00 152.8 51-000-65-00-5815 HAND TOOLS 0.00 19.94 1,000.00 1.9 51-000-65-00-5817 GRAVEL 0.00 1,192.75 5,000.00 23.8 51-000-65-00-5819 CHLORINE 0.00 0.00 0.00 0.0 51-000-65-00-5820 CHEMICALS 1,457.13 9, 179.80 30, 000.00 30.5 51-000-65-00-5821 CATHODIC PROTECTION 0.00 0.00 6,250.00 0.0 51-000-65-00-5822 WATER SAMPLES 775.00 9,171.00 12,000.00 76.4 --------------------------------------------------------------------------------- TOTAL OPERATIONS 9,124.02 75,039.64 160,020.00 46.8 RETIREMENT 51-000-72-00-6500 IMRF PARTICIPANTS 2,013.34 16,018.74 24,354.00 65.7 51-000-72-00-6501 SOCIAL SECURITY & MEDICARE 1,979.82 15,835.36 23,515.00 67.3 --------------------------------------------------------------------------------- TOTAL RETIREMENT 3,993.16 31,854.10 47,869.00 66.5 CAPITAL OUTLAY 51-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 237.06 4,000.00 5.9 51-000-75-00-7004 SAFETY EQUIPMENT 0.00 2,325.01 2,000.00 116.2 51-000-75-00-7506 METER READERS 1,214.00 4,941.63 10,900.00 45.3 51-000-75-00-7507 HYDRANT REPLACEMENT 0.00 1,976.00 10,000.00 19.7 51-000-75-00-7508 METERS & PARTS 1,661.36 116,454.34 262,500.00 44.3 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 2,875.36 125,934.04 289,400.00 43.5 OTHER 51-000-78-00-9003 MERIT 0.00 0.00 7,318.00 0.0 51-000-78-00-9005 REFUND 0.00 0.00 1,500.00 0.0 51-000-78-00-9008 RESERVE-H20 TOWER MAINTENANCE 0.00 0.00 43,200.00 0.0 51-000-78-00-9009 RESERVE 0.00 0.00 853,870.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 905,888.00 0.0 TRANSFERS 51-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 100,000.00 200,000.00 50.0 P35 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 36 LIME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 CD: GL470002.WOW FUND: WATER OPERATIONS FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES TRANSFERS 51-000-99-00-9930 TRANSFER TO WATER IMPRV FUND 0.00 0.00 0.00 0.0 51-000-99-00-9950 TRANSFER TO PW EQUIP CAPITAL 0.00 25,000.00 50,000.00 50.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 125,000.00 250,000.00 50.0 TOTAL EXPENSES: 67,687.23 916,436.63 2,575,600.00 35.5 TOTAL FUND REVENUES 263,224.04 1,084,449.73 2,575,600.00 42.1 TOTAL FUND EXPENSES 67,687.23 916,436.63 2,575,600.00 35.5 FUND SURPLUS (DEFICIT) 195,536.81 168,013.10 0.00 100.0 P36 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 37 'IME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 :D: GL470002.WOW FUND: SEWER MAINTENANCE FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ----------------------------------------------------------------------------------------------------------------------------------- REVENUES CARRY OVER 52-000-40-00-3999 CARRY OVER/FUND BALANCE 0.00 0.00 450,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 450,000.00 0.0 CHARGES FOR SERVICES 52-000-42-00-4240 LIFT STATION INCOME 0.00 0.00 8,000.00 0.0 52-000-42-00-4250 SEWER MAINTENANCE FEES 80,959.20 309,857.92 355,000.00 87.2 52-000-42-00-4251 SEWER CONNNECTION FEES 45,600.00 109,600.00 140,000.00 78.2 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 126,559.20 419,457.92 503,000.00 83.3 INTEREST 52-000-46-00-4600 INVESTMENT INCOME 1,450.28 11,206.73 15,000.00 74.7 --------------------------------------------------------------------------------- TOTAL INTEREST 1,450.28 11,206.73 15,000.00 74.7 TOTAL REVENUES: 128,009.48 430,664.65 968,000.00 44.4 EXPENSES PERSONNEL SERVICES 52-000-50-00-5108 SALARIES-REGULAR 7,925.27 74,141.46 137,555.00 53.8 52-000-50-00-5136 PART TIME 0.00 2,299.50 5,000.00 45.9 52-000-50-00-5137 SALARIES-OVERTIME 139.38 2,867.14 12,000.00 23.8 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 8,064.65 79,308.10 154,555.00 51.3 CONTRACTUAL SERVICES 52-000-62-00-5401 CONTRACTUAL SERVICES 105.00 3,010.50 2,000.00 150.5 52-000-62-00-5408 MAINTENANCE-EQUIPMENT 404.66 2,101.04 5,000.00 42.0 52-000-62-00-5409 MAINTENANCE-VEHICLES 0.00 40.00 3,000.00 1.3 52-000-62-00-5419 MAINTENANCE-SANITARY SEWER 216.76 7,844.52 25,000.00 31.3 52-000-62-00-5421 WEARING APPAREL 253.00 1,906.69 4,500.00 42.3 52-000-62-00-5422 LIFT STATION MAINTENANCE 200.00 19,055.06 25,000.00 76.2 52-000-62-00-5434 RENTAL - EQUIPMENT 0.00 0.00 1,000.00 0.0 P37 7ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 38 DIME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: SEWER MAINTENANCE FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL °s ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES CONTRACTUAL SERVICES 52-000-62-00-5435 ELECTRICITY 489.08 5,836.98 16,500.00 35.3 52-000-62-00-5438 CELLULAR TELEPHONE 170.36 1,059.89 2,500.00 42.3 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 1,838.86 40,854.68 84,500.00 48.3 PROFESSIONAL DEVELOPMENT 52-000-64-00-5604 TRAINING & CONFERENCES 0.00 181.32 1,500.00 12.0 52-000-64-00-5605 TRAVEL/MEALS/LODGING 46.08 849.31 1,500.00 56.6 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 46.08 1,030.63 3,000.00 34.3 OPERATIONS 52-000-65-00-5800 CONTINGENCIES 0.00 0.00 9,300.00 0.0 52-000-65-00-5802 OFFICE SUPPLIES 405.15 1,505.39 2,000.00 75.2 52-000-65-00-5804 OPERATING SUPPLIES 0.00 0.00 0.00 0.0 52-000-65-00-5805 SHOP SUPPLIES 28.73 650.13 2,500.00 26.0 52-000-65-00-5812 GASOLINE 3,163.66 13,244.70 10,500.00 126.1 52-000-65-00-5815 HAND TOOLS 0.00 109.40 1,000.00 10.9 52-000-65-00-5817 GRAVEL 617.47 1,216.28 2,000.00 60.8 52-000-65-00-5823 SEWER CHEMICALS 0.00 1,368.87 5,000.00 27.3 --------------------------------------------------------------------------------- TOTAL OPERATIONS 4,215.01 18,094.77 32,300.00 56.0 RETIREMENT 52-000-72-00-6500 IMRF PARTICIPANTS 661.69 6,273.71 12,475.00 50.2 52-000-72-00-6501 SOCIAL SECURITY & MEDICARE 620.40 6,059.52 12,106.00 50.0 --------------------------------------------------------------------------------- TOTAL RETIREMENT 1,282.09 12,333.23 24,581.00 50.1 CAPITAL OUTLAY 52-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 94.94 2,500.00 3.7 52-000-75-00-7003 OFFICE EQUIPMENT 0.00 413.17 6,000.00 6.8 52-000-75-00-7004 SAFETY EQUIPMENT 0.00 455.64 2,000.00 22.7 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 963.75 10,500.00 9.1 P38 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 39 'IME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 :D: GL470002.WOW FUND: SEWER MAINTENANCE FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ OTHER 52-000-78-00-9005 MERIT 0.00 0.00 3, 695.00 0.0 52-000-78-00-9009 RESERVE 0.00 9,800.00 554,869.00 1.7 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 9,800.00 558,564.00 1.7 TRANSFERS 52-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 35,000.00 70,000.00 50.0 52-000-99-00-9925 TRANSFER TO SAN SEWER IMPROV. 0.00 0.00 0.00 0.0 52-000-99-00-9950 TRANSFER TO PW EQUIP CAPITAL 0.00 15,000.00 30,000.00 50.0 52-000-99-00-9965 TRANSFER TO DEBT SERVICE FUND 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 50,000.00 100,000.00 50.0 TOTAL EXPENSES: 15,446.69 212,385.16 968,000.00 21.9 TOTAL FUND REVENUES 128,009.48 430,664.65 968, 000.00 44.4 TOTAL FUND EXPENSES 15,446.69 212,385.16 968,000.00 21.9 FUND SURPLUS (DEFICIT) 112,562.79 218,279.49 0.00 100.0 P39 ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 40 IME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 D: GL470002.W0W FUND: LAND CASH FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL $ ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ----------------------------------------------------------------------------------------------------------------------------------- EVENUES CARRY OVER 72-000-40-00-3999 CARRY OVER/STARTING BALANCE 0.00 0.00 650,000.00 0.0 72-000-40-00-4700 LAND CASH - OTHER 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 650,000.00 0.0 CONTRIBUTIONS 72-000-47-00-4700 OSLAD GRANT 0.00 74,000.00 320,000.00 23.1 72-000-47-00-4701 GREENBRIAR-LAND CASH 0.00 1,071.00 15,498.00 6.9 72-000-47-00-4702 GREENBRIAR(DUPLEX) -LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4703 PRAIRIE GARDEN-LAND CASH 3,780.00 9,450.00 0.00 100.0 72-000-47-00-4704 FOX HILL-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4705 COUNTRY HILLS-LAND CASH 0.00 6,921.00 30,468.00 22.7 72-000-47-00-4706 COUNTRY HILLS DUPLEX-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4707 FOX HIGHLANDS-LAND CASH 0.00 1,406.00 0.00 100.0 72-000-47-00-4708 FOX HIGHLANDS DUPLEX-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4709 SUNFLOWER-LAND CASH 0.00 1,805.00 9,025.00 20.0 72-000-47-00-4710 CIMMERON RIDGE-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4711 BLACKBERRY CREEK-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4712 RIVER'S EDGE-LAND CASH 2,013.00 10,065.00 26,840.00 37.5 72-000-47-00-4713 CANNONBALL HILLS-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4714 WOODWORTH-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4715 WHITE OAK UNIT 1&2-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4716 WHITE OAK UNIT 3&4-LAND CASH 0.00 1,406.00 0.00 100.0 72-000-47-00-4717 KYLN'S CROSSING-LAND CASH 0.00 0.00 7,065.00 0.0 72-000-47-00-4718 F0XFIELD(2ND EDITION)-LAND CAS 0.00 0.00 0.00 0.0 72-000-47-00-4719 WILDWOOD-LAND CASH 0.00 918.00 0.00 100.0 72-000-47-00-4720 HEARTLAND-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4721 COUNTRYSIDE CNTR#9-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4722 KYLN'S RIDGE-LAND CASH 831.00 4,155.00 41,550.00 10.0 72-000-47-00-4723 HEARTLAND CIRCLE-LAND CASH 3,000.00 28,000.00 75,000.00 37.3 72-000-47-00-4724 RAINTREE VILLAGE-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4725 WINDETTE RIDGE-LAND CASH 0.00 0.00 50,000.00 0.0 72-000-47-00-4726 RESERVE @ THE FOX LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4727 GRAND RESERVE-LAND CASH 0.00 5,166.53 290,000.00 1.7 72-000-47-00-4728 BRISBEN RESERVE-LAND CASH 0.00 0.00 0.00 0.0 P40 DATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 41 TIME: 13:13:46 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: LAND CASH FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CONTRIBUTIONS 72-000-47-00-4730 CANNONBALL EST/KYLYNS CROSSING 0.00 0.00 0.00 0.0 72-000-47-00-4731 MONTALBANO HOMES LAND CASH 0.00 0.00 10,620.00 0.0 72-000-47-00-4732 RAINTREE VILLAGE LAND CASH 29,000.00 29,000.00 29,000.00 100.0 72-000-47-00-4734 WHISPERING MEADOWS (K. HILL) 6,202.79 29,322.28 17,735.00 165.3 72-000-47-00-4735 PRAIRIE MEADOWS (MENARD RES) 0.00 0.00 0.00 0.0 72-000-47-00-4736 CORNERSTONE 0.00 0.00 41,340.00 0.0 72-000-47-00-4737 CALEDONIA 0.00 0.00 7,672.00 0.0 72-000-47-00-4738 AUTUMN CREEK 3,384.10 3,384.10 314,065.00 1.0 72-000-47-00-4739 WYNSTONE TOWNHOMES 0.00 0.00 24,216.00 0.0 72-000-47-00-4740 VILLAS AT THE PRESERVE 0.00 0.00 72,839.00 0.0 --------------------------------------------------------------------------------- TOTAL CONTRIBUTIONS 48,210.89 206,069.91 1,382,933.00 14.9 TOTAL REVENUES: 48,210.89 206,069.91 2,032,933.00 10.1 EXPENSES CONTRACTUAL SERVICES 72-000-62-00-5408 MAINTENANCE-EQUIPMENT 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 0.00 0.00 0.00 0.0 CAPITAL OUTLAY 72-000-75-00-7007 SIGNS 0.00 0.00 0.00 0.0 72-000-75-00-7008 MISC. BALLFIELD EQUIP 0.00 0.00 0.00 0.0 72-000-75-00-7200 BLDG IMPROVE - BEECHER 0.00 0.00 0.00 0.0 72-000-75-00-7201 RIVERFRONT EQUIP IMPROVEMENT 0.00 0.00 0.00 0.0 72-000-75-00-7300 GREENBRIAR 0.00 3,000.00 20,000.00 15.0 72-000-75-00-7301 FOX HILL 0.00 0.00 0.00 0.0 72-000-75-00-7302 COUNTRYHILLS 0.00 0.00 0.00 0.0 72-000-75-00-7303 FOX HIGHLANDS 0.00 0.00 0.00 0.0 72-000-75-00-7304 SUNFLOWER 50,626.00 71,697.27 145,000.00 49.4 72-000-75-00-7305 CIMMERON RIDGE 0.00 0.00 0.00 0.0 72-000-75-00-7306 BLACKBERRY CREEK 0.00 0.00 0.00 0.0 72-000-75-00-7307 RIVERS EDGE (21,092.00) 0.00 0.00 0.0 P41 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 42 'IME: 13:13:47 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 :D: GL470002.WOW FUND: LAND CASH FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL g ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED •----------------------------------------------------------------------------------------------------------------------------------- 3XPENSES CAPITAL OUTLAY 72-000-75-00-7308 RIVERS EDGE PARK #2 21,092.00 26,901.22 50,000.00 53.8 72-000-75-00-7309 WHITE OAK 0.00 0.00 0.00 0.0 72-000-75-00-7310 WILDWOOD 0.00 0.00 0.00 0.0 72-000-75-00-7311 CANNONBALL ESTATES/KYLIN 88,285.05 201,949.61 229,000.00 88.1 72-000-75-00-7312 FOXFIELD 2ND EDITION 0.00 0.00 0.00 0.0 72-000-75-00-7313 HEARTLAND 0.00 0.00 0.00 0.0 72-000-75-00-7314 PRAIRIE GARDENS 0.00 0.00 0.00 0.0 72-000-75-00-7315 BRISBEN 0.00 0.00 0.00 0.0 72-000-75-00-7316 KYLN'S RIDGE 0.00 0.00 0.00 0.0 72-000-75-00-7317 HEARTLAND CIRCLE 0.00 0.00 6,000.00 0.0 72-000-75-00-7318 THE RESERVE 0.00 0.00 0.00 0.0 72-000-75-00-7319 THE HIGHLANDS 0.00 0.00 0.00 0.0 72-000-75-00-7320 BLACKHAWK 0.00 0.00 0.00 0.0 72-000-75-00-7321 CANNBALL HILL/KYLYN'S 0.00 0.00 0.00 0.0 72-000-75-00-7322 BEECHER 0.00 0.00 0.00 0.0 72-000-75-00-7323 BLACKHAWK 0.00 0.00 0.00 0.0 72-000-75-00-7324 TOWN SQUARE 0.00 0.00 10,000.00 0.0 72-000-75-00-7325 VAN EMMON 0.00 0.00 0.00 0.0 72-000-75-00-7326 CORLANDS 0.00 0.00 0.00 0.0 72-000-75-00-7327 GRANDE RESERVE PARK DEV. 0.00 9,693.74 465,500.00 2.0 72-000-75-00-7328 PRAIRIE MEADOWS (MENARDS RES) 0.00 0.00 70,000.00 0.0 72-000-75-00-7329 ELSIE LOUISE GILBERT PARK 4,975.80 75,946.12 0.00 (100.0) 72-000-75-00-7330 WHISPERING MEADOWS (K. HILL) 0.00 19,746.37 5,000.00 394.9 72-000-75-00-7331 WINDETT RIDGE 0.00 0.00 65,000.00 0.0 72-000-75-00-7700 PARK MAINTENANCE FACILITY 0.00 0.00 500,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 143,886.85 408,934.33 1,565,500.00 26.1 OTHER 72-000-78-00-9009 RESERVE 0.00 329,736.22 419,433.00 78.6 72-000-78-00-9010 BEECHER CONCESSION STAND 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 329,736.22 419,433.00 78.6 TRANSFERS P42 ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 43 IME: 13:13:47 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 D: GL470002.WOW FUND: LAND CASH FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ----------------------------------------------------------------------------------------------------------------------------------- ;XPENSES TRANSFERS 72-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 0.00 48,000.00 0.0 72-000-99-00-9955 TRANSFER TO PARKS/REC CAP FUND 0.00 0.00 0.00 0.0 72-000-99-00-9970 TRANSFER TO LAND ACQUISITION 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 48,000.00 0.0 TOTAL EXPENSES: 143,886.85 738,670.55 2,032,933.00 36.3 COTAL FUND REVENUES 48,210.89 206, 069.91 2,032, 933.00 10.1 COTAL FUND EXPENSES 143,886.85 738,670.55 2,032,933.00 36.3 FUND SURPLUS (DEFICIT) (95,675.96) (532,600.64) 0.00 100.0 P43 DATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 44 LIME: 13:13:47 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: LAND ACQUISITION FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL %- ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 73-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 214,078.00 0.0 73-000-40-00-4930 COLT FUNDING 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 214,078.00 0.0 TRANSFERS 73-000-49-00-4935 TRANSFER FROM LAND CASH 0.00 0.00 0.00 0.0 73-000-49-00-4937 TRANSFER FROM PARKS & REC 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 0.00 0.0 TOTAL REVENUES: 0.00 0.00 214,078.00 0.0 EXPENSES OTHER 73-000-65-00-5800 CONTINGENCY 0.00 0.00 214,078.00 0.0 73-000-65-00-5805 WEST HYDRAULIC ACQUISITION 0.00 0.00 0.00 0.0 73-000-65-00-5808 GILBERT PARK ACQUISITION 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 214,078.00 0.0 TOTAL FUND REVENUES 0.00 0.00 214,078.00 0.0 TOTAL FUND EXPENSES 0.00 0.00 214,078.00 0.0 FUND SURPLUS (DEFICIT) 0.00 0.00 0.00 0.0 P44 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 45 LIME: 13:13:47 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 CD: GL470002.WOW FUND: PARKS & RECREATION FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL g ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 79-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 0.00 0.0 CHARGES FOR SERVICES 79-000-42-00-4270 FEES FOR PROGRAMS 16,738.37 179,222.84 176,825.00 101.3 79-000-42-00-4280 CONCESSIONS 10.00 13,822.23 10,500.00 131.6 79-000-42-00-4281 BEECHER BLDG/SHELTER DEPOSITS 50.00 750.00 4,500.00 16.6 79-000-42-00-4282 FARMERS MARKET 0.00 0.00 0.00 0.0 79-000-42-00-4285 VENDING MACHINE INCOME 0.00 459.42 650.00 70.6 79-000-42-00-4286 RENTAL INCOME 275.00 1,530.00 4,000.00 38.2 79-000-42-00-4287 RENTAL INCOME - SHELTERS 0.00 275.00 1,000.00 27.5 79-000-42-00-4288 GOLF OUTING REVENUE 0.00 40,160.00 38,000.00 105.6 79-000-42-00-4289 DAY TRIPS 0.00 0.00 0.00 0.0 79-000-42-00-4290 YOUTH/SPECIAL EVENTS 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 17,073.37 236,219.49 235,475.00 100.3 MISCELLANEOUS 79-000-44-00-4400 DONATIONS 974.50 11,178.00 15,000.00 74.5 79-000-44-00-4404 TREE DONATIONS 0.00 900.00 500.00 180.0 79-000-44-00-4490 MISCELLANEOUS INCOME 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 974.50 12,078.00 15,500.00 77.9 INTERGOVERNMENTAL 79-000-45-00-4540 ILLINOIS FIRST GRANT 0.00 0.00 0.00 0.0 79-000-45-00-4545 IDNR GRANT 0.00 0.00 0.00 0.0 79-000-45-00-4550 YOUTH SERVICES GRANT 0.00 1,000.00 2,000.00 50.0 --------------------------------------------------------------------------------- TOTAL INTERGOVERNMENTAL 0.00 1,000.00 2,000.00 50.0 INTEREST 79-000-46-00-4600 INVESTMENT INCOME 1,060.58 6,419.10 1,500.00 427.9 --------------------------------------------------------------------------------- TOTAL INTEREST 1,060.58 6,419.10 1,500.00 427.9 P45 ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 46 IME: 13:13:47 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 D: GL470002.WOW FUND: PARKS & RECREATION FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL a ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ----------------------------------------------------------------------------------------------------------------------------------- TRANSFERS 79-000-49-00-4901 TRANSFER FROM GENERAL FUND 77,380.58 619,044.64 928,567.00 66.6 --------------------------------------------------------------------------------- TOTAL TRANSFERS 77,380.58 619,044.64 928,567.00 66.6 TOTAL REVENUES: 96,489.03 874,761.23 1,183,042.00 73.9 )ARKS 3XPENSES PERSONNAL SERVICES 79-610-50-00-5107 SALARIES-EMPLOYEES 19,341.11 196,667.10 312,678.00 62.8 79-610-50-00-5136 SALARIES - PART-TIME 1,784.00 38,143.52 45,000.00 84.7 79-610-50-00-5137 SALARIES - OVERTIME 120.00 1,840.98 81000.00 23.0 --------------------------------------------------------------------------------- TOTAL PERSONNAL SERVICES 21,245.11 236,651.60 365,678.00 64.7 PROFESSIONAL SERVICES 79-610-61-00-5320 MASTER PLAN 0.00 0.00 0.00 0.0 `--------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 0.00 0.00 0.00 0.0 CONTRACTUAL SERVICES 79-610-62-00-5405 PARK CONTRACTUAL 2,756.00 10,585.00 12,000.00 88.2 79-610-62-00-5408 MAINTENANCE-EQUIPMENT 316.37 6,691.21 6,000.00 111.5 79-610-62-00-5417 MAINTENANCE-PARKS 111.32 19,770.07 32,000.00 61.7 79-610-62-00-5421 WEARING APPAREL 380.83 1,610.01 8,000.00 20.1 79-610-62-00-5425 ILLINOIS FIRST GRANT 0.00 0.00 0.00 0.0 79-610-62-00-5434 RENTAL-EQUIPMENT 0.00 309.49 1,700.00 18.2 79-610-62-00-5438 CELLULAR TELEPHONE 275.19 1,838.13 5,750.00 31.9 79-610-62-00-5440 LAND DEVELOPER 0.00 553.50 10,000.00 5.5 79-610-62-00-5445 LEGAL EXPENSES 375.00 1,462.50 10,000.00 14.6 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 4,214.71 42,819.91 85,450.00 50.1 PROFESSIONAL DEVELOPMENT P46 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 47 DIME: 13:13:47 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ED: GL470002.WOW FUND: PARKS & RECREATION FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ PARKS EXPENSES PROFESSIONAL DEVELOPMENT 79-610-64-00-5602 PROFESSIONAL GROWTH/SUBSCRPT 390.00 1,682.23 4,500.00 37.3 79-610-64-00-5605 TRAVEL EXPENSE 0.00 2,411.02 3,000.00 80.3 79-610-64-00-5612 CONTINUING EDUCATION 0.00 1,080.00 4,200.00 25.7 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 390.00 5,173.25 11,700.00 44.2 OPERATIONS 79-610-65-00-5800 CONTINGENCIES 0.00 0.00 0.00 0.0 79-610-65-00-5802 OFFICE SUPPLIES 60.80 554.25 1,500.00 36.9 79-610-65-00-5804 OPERATING SUPPLIES 1,882.83 9,568.10 25,000.00 38.2 79-610-65-00-5812 GASOLINE 0.00 73.75 3, 500.00 2.1 79-610-65-00-5815 HAND TOOLS 32.91 599.86 3,000.00 19.9 79-610-65-00-5824 CHRISTMAS DECORATIONS 761.40 6,129.45 7,000.00 87.5 79-610-65-00-5825 PUBLIC DECORATION 0.00 589.91 3,000.00 19.6 --------------------------------------------------------------------------------- TOTAL OPERATIONS 2,737.94 17,515.32 43,000.00 40.7 RETIREMENT 79-610-72-00-6500 IMRF PARTICIPANTS 1,682.47 15,451.15 26,702.00 57.8 79-610-72-00-6501 SOCIAL SECURITY/MEDICARE 1,609.95 17,319.29 28,537.00 60.6 --------------------------------------------------------------------------------- TOTAL RETIREMENT 3,292.42 32,770.44 55,239.00 59.3 CAPITAL OUTLAY 79-610-75-00-7003 OFFICE EQUIPMENT 0.00 24.99 27,000.00 0.0 79-610-75-00-7701 FLOWERS/TREES 534.00 2,361.86 6,500.00 36.3 79-610-75-00-7705 TRANSFER TO LAND ACQUISITION 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 534.00 2,386.85 33,500.00 7.1 OTHER 79-610-78-00-9005 MERIT 0.00 0.00 7,359.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 7,359.00 0.0 P47 ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 48 IME: 13:13:47 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 D: GL470002.WOW FUND: PARKS & RECREATION FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL a ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ----------------------------------------------------------------------------------------------------------------------------------- TOTAL EXPENSES: PARKS 32,414.18 337,317.37 601,926.00 56.0 :ECREATION ;XPENSES PERSONNEL SERVICES 79-.650-50-00-5107 EMPLOYEE SALARIES 18,287.44 170,039.81 260,696.00 65.2 79-650-50-00-5108 CONCESSION STAFF 96.25 3,280.50 3,600.00 91.1 79-650-50-00-5150 SALARIES-INSTRUCTOR CONTRACTUA 9,147.38 73,102.60 88,000.00 83.0 79-650-50-00-5155 SALARIES-RECORDING SECRETARY 237.00 1,070.00 5,000.00 21.4 79-650-50-00-5156 SALARIES-CUSTODIAL 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 27,768.07 247,492.91 357,296.00 69.2 PROFESSIONAL SERVICES 79-650-61-00-5321 RECREATION RESEARCH 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 0.00 0.00 0.00 0.0 CONTRACTUAL SERVICES 79-650-62-00-5408 MAINTENANCE SUPPLIES 851.61 2,780.64 8,000.00 34.7 79-650-62-00-5409 MAINTENANCE-VEHICLES 0.00 122.17 1,200.00 10.1 79-650-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 411.63 3,552.11 5,500.00 64.5 79-650-62-00-5426 YOUTH SERVICES GRANT EXPENSES 0.00 463.42 2,000.00 23.1 79-650-62-00-5437 TELEPHONE/INTERNET 74.42 300.46 1,400.00 21.4 79-650-62-00-5438 CELLULAR TELEPHONE 496.05 2,263.97 4,500.00 50.3 79-650-62-00-5445 PORTABLE TOILETS 0.00 3,273.65 4,500.00 72.7 79-650-62-00-5603 PUBLISHING/ADVERTISING 4,599.43 18,746.23 25,200.00 74.3 79-650-62-00-5605 BOOKS/PUBLICATIONS 75.00 159.50 750.00 21.2 79-650-62-00-5606 BEECHER DEPOSIT REFUND 400.00 3,200.00 4,000.00 80.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 6,908.14 34,862.15 57,050.00 61.1 PROFESSIONAL DEVELOPMENT 79-650-64-00-5600 DUES 80.00 80.00 2,700.00 2.9 79-650-64-00-5602 PROFESSIONAL GROWTH/SUBSCRIPT 1,473.00 3,233.00 7,500.00 43.1 79-650-64-00-5605 TRAVEL EXPENSE 0.00 1,104.03 2,500.00 44.1 P48 DATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 49 TIME: 13:13:47 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL °s ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ RECREATION EXPENSES PROFESSIONAL DEVELOPMENT 79-650-64-00-5614 TOURNAMENT FEES 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 1,553.00 4,417.03 12,700.00 34.7 OPERATIONS 79-650-65-00-5800 CONTINGENCIES 0.00 0.00 0.00 0.0 79-650-65-00-5802 OFFICE SUPPLIES 463.15 3,253.80 6,600.00 49.3 79-650-65-00-5803 PROGRAM EXPENSES 4,376.00 29,154.38 39,185.00 74.4 79-650-65-00-5804 OPERATING SUPPLIES 79.78 3,142.48 4,000.00 78.5 79-650-65-00-5805 RECREATION EQUIPMENT 299.99 514.56 3,500.00 14.7 79-650-65-00-5808 POSTAGE & SHIPPING 140.05 4,065.95 6,500.00 62.5 79-650-65-00-5812 GASOLINE 299.38 530.41 1,600.00 33.1 79-650-65-00-5826 MILEAGE 87.31 513.27 750.00 68.4 79-650-65-00-5827 GOLF OUTING EXPENSES 0.00 21,944.65 20,000.00 109.7 79-650-65-00-5828 CONCESSIONS 0.00 9,734.06 5,000.00 194.6 79-650-65-00-5830 YOUTH/SPECIAL EVENTS 0.00 0.00 0.00 0.0 79-650-65-00-5831 DAY TRIP EXPENSES 0.00 0.00 0.00 0.0 79-650-65-00-5840 SCHOLARSHIPS 0.00 1,570.00 1,500.00 104.6 79-650-65-00-5841 PROGRAM REFUND 1,158.50 9,007.30 6,500.00 138.5 --------------------------------------------------------------------------------- TOTAL OPERATIONS 6,904.16 83,430.86 95,135.00 87.6 RETIREMENT 79-650-72-00-6500 IMRF PARTICIPANTS 1,642.59 15,007.59 21,754.00 68.9 79-650-72-00-6501 SOCIAL SECURITY/MEDICARE 2,072.43 17,049.41 24,132.00 70.6 --------------------------------------------------------------------------------- TOTAL RETIREMENT 3,715.02 32,057.00 45,886.00 69.8 CAPITAL OUTLAY 79-650-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 6,754.63 6,500.00 103.9 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 6,754.63 6,500.00 103.9 OTHER 79-650-78-00-9005 MERIT 0.00 0.00 6,549.00 0.0 P49 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 50 'IME: 13:13:47 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 D: GL470002.WOW FUND: PARKS & RECREATION FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 6,549.00 0.0 TOTAL EXPENSES: RECREATION 46,848.39 409,014.58 581,116.00 70.3 TOTAL FUND REVENUES 96,489.03 874,761.23 1,183,042.00 73.9 TOTAL FUND EXPENSES 79,262.57 746,331.95 1,183,042.00 63.0 FUND SURPLUS (DEFICIT) 17,226.46 128,429.28 0.00 100.0 P50 DATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 51 TIME: 13:13:47 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: WORKING CASH FUND FOR 8 PERIODS ENDING DECEMBER 31, 2005 - FISCAL FISCAL a ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 80-000-40-00-3999 CARRY OVER/BEG FUND BALANCE 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 0.00 0.0 EXPENSES TRANSFERS 80-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 0.00 0.0 TOTAL FUND REVENUES 0.00 0.00 0.00 0.0 TOTAL FUND EXPENSES 0.00 0.00 0.00 0.0 FUND SURPLUS (DEFICIT) 0.00 0.00 0.00 0.0 P51 IATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 52 'IME: 13:13:47 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 D: GL470002.WOW FUND: LIBRARY FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ ZEVENUES TAXES 82-000-40-00-3996 CARRY OVER - BOOK DEV FEES 0.00 0.00 57,736.00 0.0 82-000-40-00-3997 CARRY OVER - BLDG DEV FEES 0.00 0.00 31,695.00 0.0 82-000-40-00-3998 CARRY OVER-MEMORIALS 0.00 0.00 5,362.00 0.0 82-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 75,916.00 0.0 82-000-40-00-4000 REAL ESTATE TAXES 12,866.24 356,387.49 370,500.00 96.1 82-000-40-00-4010 PERSONAL PROPERTY TAX 0.00 1,667.90 2,500.00 66.7 82-000-40-00-4015 TRANSFER FROM GENERAL FUND 2,625.00 21,000.00 31,500.00 66.6 --------------------------------------------------------------------------------- TOTAL TAXES 15,491.24 379,055.39 575,209.00 65.8 CHARGES FOR SERVICES 82-000-42-00-4211 DEVELOPMENT FEES - BUILDING 6,675.00 31,725.00 121,875.00 26.0 82-000-42-00-4215 DEVELOPMENT FEES-BOOKS 6,675.00 31,725.00 121,875.00 26.0 82-000-42-00-4260 COPY FEES 72.10 875.30 900.00 97.2 82-000-42-00-4261 LIBRARY SUBSCRIPTION CARDS 500.00 6,200.00 8,000.00 77.5 82-000-42-00-4286 RENTAL INCOME 107.00 787.00 1,000.00 78.7 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 14,029.10 71,312.30 253,650.00 28.1 FINES 82-000-43-00-4330 LIBRARY FINES 277.97 2,742.92 3,000.00 91.4 --------------------------------------------------------------------------------- TOTAL FINES 277.97 2,742.92 3,000.00 91.4 MISCELLANEOUS 82-000-44-00-4432 SALE OF BOOKS 16.50 332.69 500.00 66.5 82-000-44-00-4450 MEMORIALS 730.00 1,417.00 1,000.00 141.7 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 746.50 1,749.69 1,500.00 116.6 INTERGOVERNMENTAL 82-000-45-00-4550 GRANTS 0.00 0.00 1,000.00 0.0 82-000-45-00-4560 LIBRARY PER CAPITA GRANT 0.00 0.00 7,700.00 0.0 --------------------------------------------------------------------------------- TOTAL INTERGOVERNMENTAL 0.00 0.00 8,700.00 0.0 P52 ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 53 IME: 13:13:47 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 D: GL470002.WOW FUND: LIBRARY FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ INTEREST 82-000-46-00-4600 INVESTMENT INCOME 1,762.25 8,466.89 1,500.00 564.4 82-000-46-00-4601 INVESTMENT INCOME-BLDG 19, 566.04 101,366.31 1,250.00 8109.3 --------------------------------------------------------------------------------- TOTAL INTEREST 21,328.29 109,833.20 2,750.00 3993.9 OTHER OPERATING RECEIPTS 82-000-48-00-4801 LIBRARY EXPAN BOND PROCEEDS 0.00 7,263,880.86 0.00 100.0 --------------------------------------------------------------------------------- TOTAL OTHER OPERATING RECEIPTS 0.00 7,263,880.86 0.00 100.0 TOTAL REVENUES: 51,873.10 7,828,574.36 844,809.00 926.6 3XPENSES PERSONNEL SERVICES 82-000-50-00-5107 SALARIES-EMPLOYEES 14,038.61 110,356.58 300,000.00 36.7 82-000-50-00-5203 GROUP HEALTH INSURANCE 6,697.75 20,022.27 45,000.00 44.4 82-000-50-00-5204 GROUP LIFE INSURANCE 124.02 336.36 1,500.00 22.4 82-000-50-00-5205 DENTAL & VISION ASSISTANCE 472.73 1,743.33 4,000.00 43.5 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 21,333.11 132,458.54 350,500.00 37.7 PROFESSIONAL SERVICES 82-000-61-00-5300 LEGAL SERVICES 0.00 0.00 0.00 0.0 82-000-61-00-5322 BONDING 0.00 1,014.00 2,000.00 50.7 82-000-61-00-5323 ATTORNEY 0.00 862.50 2,000.00 43.1 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 0.00 1,876.50 4,000.00 46.9 CONTRACTUAL SERVICES 82-000-62-00-5401 CONTRACT SERVICES 99.33 467.33 3,000.00 15.5 82-000-62-00-5407 MAINTENANCE-BLDG/JANITORIAL 300.00 2,100.00 5,000.00 42.0 82-000-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 0.00 2,611.77 3,000.00 87.0 82-000-62-00-5412 MAINTENANCE-PHOTOCOPIER 49.64 301.86 500.00 60.3 82-000-62-00-5435 ELECTRICITY 100.26 297.79 2,500.00 11.9 82-000-62-00-5436 TELEPHONE 200.50 538.56 1,700.00 31.6 P53 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 54 'IME: 13:13:47 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 :D: GL470002.WOW FUND: LIBRARY FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED •----------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 749.73 6,317.31 15,700.00 40.2 PROFESSIONAL DEVELOPMENT 82-000-64-00-5603 SUBSCRIPTIONS 1,956.34 2,199.34 4,000.00 54.9 82-000-64-00-5604 TRAINING & CONFERENCES 0.00 10.00 1,500.00 0.6 82-000.64-00-5607 PUBLIC RELATIONS 0.00 121.23 1,000.00 12.1 82-000-64-00-5616 EMPLOYEE RECOGNITION 395.99 444.51 2,000.00 22.2 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 2,352.33 2,775.08 8,500.00 32.6 OPERATIONS 82-000-65-00-5800 CONTINGENCIES 0.00 585.57 14,616.00 4.0 82-000-65-00-5802 OFFICE SUPPLIES 0.00 301.90 3,000.00 10.0 82-000-65-00-5806 LIBRARY SUPPLIES 470.74 2,812.04 8,000.00 35.1 82-000-65-00-5807 CUSTODIAL SUPPLIES 281.65 1,549.80 6,000.00 25.8 82-000-65-00-5808 POSTAGE & SHIPPING 0.00 444.00 1,000.00 44.4 82-000-65-00-5810 PUBLISHING & ADVERTISING 0.00 264.44 1,000.00 26.4 82-000-65-00-5826 MILEAGE 29.10 308.35 1,000.00 30.8 82-000-65-00-5832 VIDEOS 530.38 1,219.35 5,000.00 24.3 82-000-65-00-5833 ALARM MONITORING 46.85 640.05 1,000.00 64.0 82-000-65-00-5834 LIBRARY PROGRAMMING 245.22 3,321.60 9,500.00 34.9 82-000-65-00-5835 LIBRARY BOARD EXPENSES 42.50 74.50 500.00 14.9 82-000-65-00-5836 BOOKS-ADULT 872.99 3,926.38 9,000.00 43.6 82-000-65-00-5837 BOOKS-JUVENILE 0.00 3,043.57 9,000.00 33.8 82-000-65-00-5838 BOOKS-AUDIO 251.32 1,321.61 9,000.00 14.6 82-000-65-00-5839 BOOKS-REFERENCE 11911.00 7,569.59 9,000.00 84.1 82-000-65-00-5840 BOOKS-DEVELOPMENT FEE 4,520.54 22,539.77 179,611.00 12.5 82-000-65-00-5841 MEMORIALS/GIFTS 26.21 1,821.71 6,362.00 28.6 82-000-65-00-5842 BLDG-DEVELOPMENT FEES 801,838.40 1,145,060.71 153,570.00 745.6 --------------------------------------------------------------------------------- TOTAL OPERATIONS 811,066.90 1,196,804.94 426,159.00 280.8 RETIREMENT 82-000-72-00-6500 IMRF PARTICPANTS 605.66 5,022.56 9,000.00 55.8 82-000-72-00-6501 SOCIAL SECURITY/MEDICARE 1,073.94 8,442.46 22,950.00 36.7 --------------------------------------------------------------------------------- TOTAL RETIREMENT 1,679.60 13,465.02 31,950.00 42.1 P54 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 55 LIME: 13:13:47 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 CD: GL470002.WOW FUND: LIBRARY FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ CAPITAL OUTLAY 82-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 0.00 0.00 0.0 82-000-75-00-7003 AUTOMATION 817.30 6,917.19 8,000.00 86.4 82-000-75-00-7703 BUILDING EXPANSION 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 817.30 6,917.19 8,000.00 86.4 TOTAL EXPENSES: 837,998.97 1,360,614.58 844,809.00 161.0 TOTAL FUND REVENUES 51,873.10 7,828,574.36 844,809.00 926.6 TOTAL FUND EXPENSES 837,998.97 1,360,614.58 844,809.00 161.0 FUND SURPLUS (DEFICIT) (786,125.87) 6,467,959.78 0.00 100.0 P55 )ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 56 .'IME: 13:13:47 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 :D: GL470002.WOW FUND: FOX INDUSTRIAL FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL g ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ 2EVENUES TAXES 85-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 0.00 0.0 85-000-40'-00-4090 TIF REVENUES 130.03 70,996.87 34,000.00 208.8 --------------------------------------------------------------------------------- TOTAL TAXES 130.03 70,996.87 34,000.00 208.8 INTEREST 85-000-46-00-4600 INVESTMENT INCOME 329.65 1,867.51 1,000.00 186.7 --------------------------------------------------------------------------------- TOTAL INTEREST 329.65 1,867.51 1,000.00 186.7 TRANSFERS 85-000-49-00-4905 TRANSFER FROM MFT FUND 0.00 31,189.68 42,664.00 73.1 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 31,189.68 42,664.00 73.1 TOTAL REVENUES: 459.68 104,054.06 77,664.00 133.9 EXPENSES DEBT SERVICES 85-000-66-00-6021 FOX IND BOND-PRINCIPAL PMT 0.00 55,000.00 55,000.00 100.0 85-000-66-00-6022 FOX IND BOND-INT PAYMENT 0.00 11,225.00 22,450.00 50.0 --------------------------------------------------------------------------------- TOTAL DEBT SERVICES 0.00 66,225.00 77,450.00 85.5 CAPITAL OUTLAY 85-000-75-00-7901 FOX INDUSTRIAL - NON MFT 0.00 232.50 0.00 (100.0) 85-000-75-00-7902 FOX INDUSTRIAL EXPENSES 0.00 5,067.50 0.00 (100.0) --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 5,300.00 0.00 (100.0) OTHER 85-000-78-00-9007 ADMINSITRATION FEES 0.00 1,106.50 214.00 517.0 85-000-78-00-9010 RESERVE-FUTURE BOND PYMTS 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 1,106.50 214.00 517.0 P56 IATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 57 'IME: 13:13:47 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 :D: GL4700O2.WOW FUND: FOX INDUSTRIAL FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED •----------------------------------------------------------------------------------------------------------------------------------- TOTAL EXPENSES: 0.00 72,631.50 77,664.00 93.5 COTAL FUND REVENUES 459.68 104,054.06 77,664.00 133.9 COTAL FUND EXPENSES 0.00 72,631.50 77,664.00 93.5 FUND SURPLUS (DEFICIT) 459.68 31,422.56 0.00 100.0 P57 ATE: 01/31/2006 UNITED CITY OF YORKVILLE PAGE: 58 'IME: 13:13:47 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 D: GL470002.WOW FUND: COUNTRYSIDE TIF PROJECT FOR 8 PERIODS ENDING DECEMBER 31, 2005 FISCAL FISCAL ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ----------------------------------------------------------------------------------------------------------------------------------- IEVENUES CARRY OVER 87-000-40-00-3999 CARRY OVER BALANCE 0.00 3,456,521.17 0.00 100.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 3,456,521.17 0.00 100.0 INTEREST 87-000-46-00-4600 INVESTMENT INCOME 9,220.53 73,641.39 0.00 100.0 --------------------------------------------------------------------------------- TOTAL INTEREST 9,220.53 73,641.39 0.00 100.0 TOTAL REVENUES: 9,220.53 3,530,162.56 0.00 100.0 EXPENSES OTHER FINANCING 87-000-66-00-6001 COUNTRYSIDE TIF-PRINCIPAL PMT 0.00 0.00 0.00 0.0 87-000-66-00-6002 COUNTRYSIDE TIF-INTEREST PMT 0.00 101,594.73 0.00 (100.0) --------------------------------------------------------------------------------- TOTAL OTHER FINANCING 0.00 101,594.73 0.00 (100.0) TOTAL FUND REVENUES 9,220.53 3,530,162.56 0.00 100.0 TOTAL FUND EXPENSES 0.00 101,594.73 0.00 (100.0) FUND SURPLUS (DEFICIT) 9,220.53 3,428,567.83 0.00 100.0 P58 0)4 a ♦.4 C/ry Reviewed By: J= �•n ❑ City Council Legal Finance EST. -� �= isss Engineer ❑ '�- Agenda Item Tracking Number City Administrator F1 �O E] ADM 2006- Consultant ♦ ❑ �44L.E ,w City Council Agenda Item Summary Memo Title: Monthly Treasurer's Report—December 2005 City Council/COW/Committee Agenda Date: Administration 2/02/06 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Traci Pleckham Finance Name Department Agenda Item Notes: United City of Yorkville Monthly Treasurer's Report Pre Audit Financial Summary As of December 31, 2005 Beginning Ending Fund Balance Revenues Expenses Transfers Balance 1 General 4,915,695.99 1,622,870.74 749,680.33 (80,005.58) 5,708,880.82 15 Motor Fuel Tax 163,244.08 24,409.85 22,797.12 - 164,856.81 16 Municipal Building (321,911.64) 31,950.00 4,572.57 - (294,534.21) 20 PD Capital 61,326.09 90,584.52 6,550.40 - 145,360.21 21 PW Capital 198,980.15 150,450.00 3,483.00 - 345,947.15 22 Parks&Rec Equip Capital 9,785.38 900.00 600.00 - 10,085.38 37 Sanitary Sewer Improvement (196,862.53) 12,515,219.46 995,060.64 - 11,323,296.29 41 Water Improvement Exp 1,656,294.76 429,831.46 688,453.02 - 1,397,673.20 42 Debt Service 218,891.69 18,467.76 644,025.32 - (406,665.87) 51 Water 510,332.52 182,818.40 70,321.20 - 622,829.72 52 Sewer 453,177.46 82,795.99 15,510.83 - 520,462.62 72 Land Cash 5,511.63 48,210.89 143,886.85 - (90,164.33) 73 Land Acquisition 213,617.69 - - - 213,617.69 79 Parks&Recreation 193,825.01 18,429.55 78,583.67 77,380.58 211,051.47 82 Library 7,612,790.01 49,248.10 837,998.97 2,625.00 6,826,664.14 85 Fox Industrial (2,233.05) 459.68 - (1,773.37) 87 Countryside TIF Project 3,419,347.30 9,220.53 - 3,428,567.83 95 Trust&Agency (228,361.41) 653,820.13 14,420.26 - 411,038.46 Totals 18,883,451.13 15,929,687.06 4,275,944.18 - 30,537,194.01 As Treasurer of the United City of Yorkville,I hereby attest,to the best of my knowledge,that the information contained in this Treasurer's Report is accurate as of the date detailed herein. Full detail information is available in the Finance Department. William Powell,Treasurer Fund Balance Reserve General Fund 39.81% Water O s 24.18%1 Sewer Maint. 53.77% Combined Fund Balance Reserve 37.78% Prepared by:Julie Ciesla-Senior Accounting Clerk 1/31/2006 N6-43 Co. Reviewed ByP:E3 Legal City Council Finance EST. '� ` ,:1836 Engineer ❑ Agenda Item Tracking Number City dministrator ❑ � � y ADM 2006- 14 �� �sw �O Consultant ❑ K""V« ` ❑ ALE. w� City Council Agenda Item Summary Memo Title: Proposed Revised Budget Fiscal Year 2005/2006 City Council/COW/Committee Agenda Date: Administration 2/02/06 Synopsis: The following is a draft of the proposed revised 05/06 budget. Library Fund will Be updated prior to COW meeting and Park Board will also be reviewing at their 2/9 meeting. Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Traci Pleckham Finance Name Department Agenda Item Notes: UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET 2005-2006 GENERAL FUND SUMMARY 2005-2006 PROPOSED 2005-2006 REVISED PERCENT BUDGET BUDGET NET CHANGE CHANGE TOTAL,�EWERAl,�UND � r "'5" Y{, f ( } fir "„. .. "t ,4 /0 GENERAL FUND EXPENSES FINANCE &ADMINISTRATION 5,134,030 5,076,588 (57,442) -1.12% ENGINEERING 373,132 440,342 67,210 18.01% POLICE 2,145,143 2,224,534 79,391 3.70% PLANNING & DEVELOPMENT 324,607 259,250 (65,357) -20.13% STREETS 9,459,954 6,509,602 (2,950,352) -31.19% HEALTH &SANITATION 571,170 530,000 (41,170) -7.21% L FUND F,a' , EN,, 111 --93 x,040}3"I6, (2} **Reduction in revenue&expenses primarily related to a decrease in the Grande Reserve Perimeter road funding. Will receive additional dollars FY 06107** 1/30/2006 Prepared by Traci Pleckham UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2005-2006 ""Items identified in color are project-specific revenue streams. Expenses also identified in the same GENERAL FUND color. REQUESTED REVISIONS IN YELLOW Proposed Revised ACCOUNT 2005-2006 2005-2006 NUMBER DESCRIPTION Budget Budget COMMENTS GENERAL FUND REVENUES FUND BALANCE 0 01-000-40-00-3999 CARRY OVER BALANCE 50,000 0 Carry over identified for Cadet Program($10k)&Phase II for Downtown Planning($40k)Not needed 01-000-40-00-3996 ROAD CONTRIBUTION FEE 550,000 950,000 $2,000 per home permit fee 01-000-40-00-3998 ROAD FUNDING-MPI 4,000,000 500,000 Grande Reserve Perimiter roads-funded by developer//road project schedule modified 01-000-40-00-3997 IN-TOWN ROAD PROGRAM FUNDING 4,350,210 4,357,225 includes carry over of 573,662.50 from FY 04/05 01-000-40-00-4000 REAL ESTATE TAXES 1,393,821 1,387,100 01-000-40-00-4001 TOWN ROAD/BRIDGE TAX 98,000 102,000 FOX HILL LEVY REVENUE 7,850 0 Seasonal maintenance of SSA area-tax will not be received until FY 06/07 01-000-40-00-4010 PERSONAL PROPERTY TAX 10,000 10,000 01-000-40-00-4020 STATE INCOME TAX 638,820 666,000 Per updated State numbers-does not include special census 01-000-40-00-4030 MUNICIPAL SALES TAX 2,308,900 2,308,900 01-000-40-00-4032 STATE USE TAX 97,006 97,006 01-000-40-00-4040 MUNICIPAL UTILITY TAX 500,000 340,000 Actual$335k FY 04/05 01-000-40-00-4041 UTILITY TAX-NICOR 100,000 200,000 Actual$223k FY 04/05 01-000-40-00-4042 UTILITY TAX-CABLE TV 65,000 75,000 Actual$82k FY 04/05 01-000-40-00-4043 UTILITY TAX-TELEPHONE 325,000 380,000 Actual$381k FY 04/05 01-000-40-00-4050 HOTEL TAX 20,000 20,000 TRAFFIC SIGNAL REVENUE 5,000 5,000 01-000-41-00-4100 LIQUOR LICENSE 25,000 25,000 01-000-41-00-4101 OTHER LICENSES 4,500 4,500 01-000-41-00-4110 BUILDING PERMITS 1,100,000 1,225,000 01-000-42-00-4205 FILING FEES 25,000 25,000 01-000-42-00-4206 GARBAGE SURCHARGE 192,780 192,780 01-000-42-00-4208 COLLECTION FEE-YBSD 34,000 34,000 PLANNING FEE 39,899 0 01-000-42-00-4210 DEVELOPMENT FEES 1,175,000 1,175,000 01-000-42-00-4211 ENGINEERING CAPITAL FEE 27,500 40,000 capital fee of$100/permit 01-000-43-00-4310 TRAFFIC FINES 73,500 73,500 01-000-43-00-4315 REIMBURSE POLICE TRAINING 0 11,805 01-000-43-00-4320 ORDINANCE FEES 2,500 2,500 01-000-44-00-4401 DARE DONATIONS 1,250 1,250 01-000-44-00-4402 ROB ROY CREEK HYDRAULIC STUDY 40,000 40,000 01-000-44-00-4411 REIMB-POLICE PROTECTION 3,000 3,000 01-000-44-00-4490 MISCELLANEOUS INCOME 10,000 10,000 GRANTS 0 50,000 Brownfield Grant 01-000-45-00-4505 COPS GRANT-VESTS 1,250 2,500 01-000-45-00-4511 POLICE-STATE TOBACCO GRANT 1,250 1,250 01-000-46-00-4600 INVESTMENT INCOME 20,000 105,000 Better interest rates&road program interest TRANSFER FROM LAND CASH 42,000 0 Park designer not hired when anticipated 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 150,000 150k Required per loan agreement 01-000-49-00-4930 TRANSFER FROM WATER IMPROVE. 200,000 200,000 TOTAL REVENUES: GENERAL 18,008,036 15,040,316 Page 1 of 30 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2005-2006 Items identified in color are project-specific revenue streams. Expenses also identified in the same GENERAL FUND color.REQUESTED REVISIONS IN YELLOW lProposed Revised ACCOUNT 2005-2006 2005-2006 NUMBER DESCRIPTION Budget Budget COMMENTS FINANCE &ADMINISTRATION EXPENSES 01-110-50-00-5100 SA 01-110-50-00-5101 SALARIES-CITY CLERK 3,600 3,6001 01-110-50-00-5102 SALARIES.-CITY TREASURER 3,600 3,6 01-110-50-00-5103 SALARIES-ALDERMAN 29,080 29,080_�!___ 01-110-50-00-5104 SALARIES-LIQUOR COMMISSIONER 1,000L- 01-110-50-00-5105 SALARIES-CITY ATTORNEY 13,500 11,502 true up salary 01-110-50-00-5106 SALARIES-ADMINISTRATIVE 557,237 583,931 Increase due to true up of cola/merit and additional request for Assistant Administrator position 01-110-50-00-5136 SALARIES-PART TIME 45,072 60,000 increase due to offset increased hours for Administrative Intern,IT,and clerical staff 01-110-50-00-5137 SALARIES-OVERTIME 1,5001 01-110-50-00-5202 BENEFITS-UNEMPLOY.COMP.TAX 10,0001 10,000 ------ 01-110-50-00-5203 BENEFITS-HEALTH INSURANCE 825,000 750,000 Cos7 t savings due to vacant positions and delay of new hires [ 01-110-50-00-5204 BENEFITS-GROUP LIFE INSURANCE 20,000 20,000 01-110-50-00-5205 BENEFITS-DENTAL/VISION ASST 68,093 60,000 Cost savings due to vacant positions and delay of new hires 01-110-61-00-5300 LEGAL SERVICES 35,000 55,000 01-110-61-00-5304 AUDIT FEES&EXPENSES 25,500 25,500 _-T ------ 01-110-61-00-5305 ACCOU NT IN G ASSISTANCE 5,0001 5,000 1 01-110-61-00-5308 GA S B 34 15,000 21,200 final costs per contract 01-110-61-00-5310 EMPLOYEE ASSISTANCE 4,590 4,500 � 5,000 01-110-61-00-5311 CODIFICATION 5,0 00 01-110-61-00-5314 BUILDING INSPECTIONS 880,000 915,000 Approx.75%of Building Permit Fees ---------------- 01-110-62-00-5400 INSURANCE-LIABILITY&PROPERTY 130,000 121,211 Actual cost 01-110-62-00-5401 CONTRACTUAL SERVICES 37,500 42,500 Includes Protect Kendall Now!Funding Approved 10/11/05(for 7/1/05-6/30/06 was to be paid 5/06) SPECIAL CENSUS 66,000 66,000 ---------- 01-110-62-00-5404 CABLE CONSORTIUM FEE i 30,000 30,000 --- -------- 01-110-62-00-5406 OFFICE CLEANING 7,500 01-110-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 500 500 01-110-62-00-5411 MAINTENANCE-COMPUTERS 2,0001 2000 01-110-62-00-5412 MAINTENANCE-PHOTOCOPIERS 19,3921 19,3921 WEARING APPAREL 1,740 ---------- 01-110-62-00-5427 FACADE PROGRAM 20,000 31,000 Additional request for facade program 01-110-62-00-5436 TELEPHONE 21,000 15,000 Restructured city regular and long distance plans 01-110-62-00-5437 ACCTG SYSTEM SERVICE FEE 7,650 8,100 true cost 01-110-62-00-5438 CELLULAR TELEPHONE 2,300'300' -2.300'- ------------ 01-110-62-00-5439 TELEPHONE---S-Y--STEMS MAINTENANCE ii bdo 11,0001 01-110-64-00-5600 DUES - 4,000'L____ 01-110-64-00-5601 ILLINOIS MUNICIPAL LEAGUE DUES 690 781 Actual dues amount for FY 04/05 01-110-64-00-5603 SUBSCRIPTIONS/BOOKS 50101 500 01-110-64-00-5604 TRAINING&CONFERENCES ly,� 0' obl 11,666 01-110-64-00-5605 TRAVEL/MEALS/LODGING 17,0001 17,000 01-110-64-00-5607 PUBLIC RELATIONS 18,000 30,000 1 ISPONSORSHIPS -1 1,5001 1,500 F___ DRAFT 1/30/06 Page 2 of 30 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2005-2006 * Items identified in color are project-specific revenue streams. Expenses also identified in the same GENERAL FUND ---------- color.REQUESTED REVISIONS IN YELLOW Prop6 Revised ACCOUNT 2005-2006 2005-2006 NUMBER DESCRIPTION Budget Budget COMMENTS FINANCE &ADMINISTRATION 01-110-65-00-5800 CONTINGENCIES 185,170 275,988 Dedicated Contingency dollars of$139,870 for Smith,Parkview,URS TIF. 3%per policy approx$175k - - , ------------- FUND BALANCE RESERVE 01 0 needed. ---- ---IToreserve fund balance if necessary per policy. Currently,not n 01-110-65-00-5802 OFFICE SUPPLIES ------- 12,000 12,000�---- 01-110-65-00-5804 OPERATING SUPPLIES 13,000 13,000 01-110-65-00-5808 POSTAGE&SHIPPING -11,000 -11,000 01-110-65-00-5809 PRINTING&COPYING 10,500 10,500 01-110-65-00-5810 PUBLISHING&ADVERTISING 3,500 3,500 01-110-65-00-5844 MARKETING-HOTEL TAX 20,000 20,000 01-110-72-00-6500 IMRF PARTICIPANTS 47,791 47,791 01-110-72-00-6501 SOCIAL SECURITY&MEDICARE 52,8211 52,82111 ------------- 01-110-75-00-7002 COMPUTER EQUIP&SOFTWARE 13,500 18,500 To include-server updates including domain licenses 01-110-75-00-7003 OFFICE EQUIPMENT 3,000 3,000 F 01-110-78-00-9001 CITY TAX REBATE 1,200 1,2001 01-110-78-00-9002 !NICORGAS 30000 30,000 01-110-78-00-9003 SALES TAX REBATE 300 555,300 01-110-78-00-9004 MISCELLANEOUS 11001 1001 01-110-78-00-9005 MERIT/PAY EQUITY 51,104 0 Moved to employee salary line items within all General Fund Departments ----------- 01-110-99-00-9923 TRANSFER TO LIBRARY 31,500 28,000 To reflect more accurate projected cost of SS/IMRF for Library budget 01-110-99-00-9925 TRANSFER TO SAN SEWER 150,000 150,000 01-110-99-00-9940 TRANSFER TO PARK&RECREATION 928,567 755,908 01-110-99-00-9941 TRANSFER TO PARK/REC CAPITAL 01 L--- -------- ------ ------------- 01-110-99-00-9945 TRANSFER TO MUNICIPAL BLDG 49,523 102,043 Increase due to municipal building fees less than anticipated .T�- --. ------------- ....... EXPENSES:FINANCE&ADMINISTRATION 5,134,030 5,076,588 DRAFT 1/30/06 Page 3 of 30 UNITED CITY OF YORKVILLE ------------- PROPOSED REVISED BUDGET FY 2005-2006 T *"Items identified in color are project-specific revenue streams. Expenses also identified in the same GENERAL FUND I color.REQUESTED REVISIONS IN YELLOW ------------41,Proposed Revised ACCOUNT i2005-2006 2005-2006 i NUMBER DESCRIPTION Bud et Budget COMMENTS ENGINEERING ——-------- 01-150-50-00-5107 ,SALARIES-EMPLOYEES 248,919 257,929 increase due to true-up of cola/merit —--------- ------ 01-150-50-00-5137 SALARIES-OVERTIME 1,0001 1,000L________ 01-150-62-00-5401 CONTRAC-TU-AL SERVICES 20,000, 65,000 Increase related-to-Brownfield-cos-is$50k to be-reimbursed via grant GIS SYSTEM 1 51000 ---—--5,000' FEES 1,000 ------ 01-150-62-00-5409 MAINTENANCE-VEHICLES 3,500 4,200 Unanticipated transmission and exhaust work 01-150-62-00-5410 MAINTENANCE-OFFICE EQUIP 1,000 01-150-62-00-5411 !MAINTENANCE-COMPUTERS I 2,500 2,500 ----------- 01-150-62-00-5421 rWEARINGAPPAREL 1,100 ol-1 56-62-6C-6438 CELLULAR TELEPHONE 2,800 2,800 —------------ 01-150-64-00-5600 DUES 300 _300, 01-150-64-00-5604 TRAINING&CONFERENCES ---6,000 6_,_000 01-150-64-00-5605 TRAVEL EXPENSE 1,000 1,000_______ ------ 01-150-64-00-5616 BOOKS-&PUBLICATIONS 200 2001 01-150-65-0,075801 ENGINEERING SUPPLIES 3,0001 3,0001 01-150-65-00-5802 OFFICE SUPPLIES 2,5001 01-150-65-00-5809 PRINTING&COPYING 2,000 ------ ------- 01-150-72-00-6500 IMRF PARTICIPANTS 20,343 - 20,343 —------ 01-150-72-00-6501 SOCIAL SECURITY&MEDICARE 19 120 19,120 01-150-75-00-7002 1 COMPUTER EQUIP&SOFTWARE 3,8501 3,850 -T- 01-150-75-00-7003 OFFICEEQUIPMENT 5001 5001- FY 05106 Replacement Truck for Engineering Tech$20k+Replace 96 sedan w/small SUV($25k to be partially 01-150-65-00-5820 Vehicles/ENGINEERING CAPITAL 40,000 paid thru PW). —__------- —-------- Transfer ENGINEERING CAPITAL to PW Dept.ie FY 06/07-To repay PW from FY 04/05(20k for 04/05 truck$17,500 05/06 SUV) _ TOTAL EXPENSES:ENGINEERING 37: ,132 440,342 342 --------- --------- DRAFT 1/30/06 Page 4 of 30 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2005-2006 ---------- ***Items identified in color are project-specific revenue streams. Expenses alsb identified in the same GENERAL FUND Zolor.REQUESTED REVISIONS IN YELLOW Proposed Revised ACCOUNT 12005-2006 2005-2006 NUMBER DESCRIPTION Budget Budget COMMENTS PUBLIC SAFETY/POLICE DEPT.____ ------------------ EXPENSES i 01-210-50-00-5107 SALARIES-EMPLOYEES 608,512 670,154 Increase due to officer originally budgeted in Salaries-COPS line item 01-210-50-00-5131 SALARIES-LIEUT./SERGEANTS/CHIEF 522,284 565,295 Increase due to true-up of cola/merit and budget of accrued vacation ------- 01-210-50-00-5133 SALARIES-COPS 150,158 105,693 Decrease due to 1 officer originally budgeted in this line item;should be Salaries-Employees line 19,00 01-210-50-00-5134 SALARIES-CROSSING GUARD 0 19,000[:L7 01-210-50-00-5135 SALARIES-POLICE CLERKS 103,626 107,179 Increase due to true-up of cola/merit 01-210-50-00-5136 SALARIES-PART TIME 30,000 35,000 Increased because of sickness,training,also unable to hire new people in October 2005 01-210-5-0-00-51- - 37 SALARIES-OVERTIME -1 50,00011 501000LI ------- I CADET PROGRAM 10,000 10,000 01-210-61-00-5300 LEGAL SERVICES --J--2010-00 20,000 ------ 01-210-62-00-5408 MAINTENANCE-EQUIPMENT 8,000 8,000T----- 01-210-62-00-5409 MAINTENANCE-VEHICLES 21,000 24,000 Increased because of an accident($1,700),replaced a transmission in an Expedition($2,300). 2,5004 2,500[------- 01-210-62-00-5410 MAINT-OFFICE EQUIPMENT ------ 01-210-62-00-5411 MAINTENANCE-COMPUTERS 2,100 2,100 L 01-210-62-00-5414 WEATHER WARNING SIREN MAINT 8,000 5,000 Decrased to use funds for Increased Line Items 01-210-62-00-5421 WEARINGAPPAREL 27,000 27,000 E 01-210-62-00-5422 COPS GRANT IV-VESTS 2,500 3,000 01-210-62-00-5423 C L A SY GRANT 1,0001 ----------- 01210-62-00-5429 PSYCHOLOGICAL TESTING 1,500 ------__ 01-210-62-00-5430 HEALTH SERVICES 3,000 _3,000 --- 01-210-62-00-5431 LABORATORY FEES 1,000 ------------------------- 01-210-62-00-5436 TELEPHONE 20,000 20,000 ------- ­------------ ---------- 01-210-62-00-5438 CELLULAR TELEPHONE 14,0001 14,000 ------------ ----------- 01-210-62-00-5441 MTD-ALERTS FEE 2,400 4,620 Increased because of doubling of fees by the State for each unit,will increase again next fiscal year 01-210-64-00-5600 DUES 2,2501 2,2501 -------------- 01-210-64-00-5603 SUBSCRIPTIONS 3001 + 01-210-64-00-5604 TRAINING&CONFERENCE- 19,000 19,0001 01-210-64-00-5605 TRAVEL EXPENSES 9,000 10,500 Increased because of cost of lodging for Training @ Northwestern,as well as more lodging for extended courses. 01-210-64-00-5606 COMMUNITY RELATIONS 5,5001 5,500i- 01-210-64-00-5607 POLICE COMMISSION 23,000 13,000 Decreased to use funds for Increased Line Items -- --------------------- 01-210-64-00-5608 TUITION REIMBURSEMENT 14,000 ------ 14,000­----------------- 01-210-64-00-5609 POLICE RECRUIT ACADEMY ----3,50-01 3,500 ---------- 01-210-64-00-5610 GUN RANGE 625i 625 01-210-64-00-5611 SRT FEE 2,000 2,000 01-210-65-00-5802 OFFICE SUPPLIES 6,500 6,509,1 01-210-65-00-5804 OPERATING SUPPLIES 16,000 16,000 01-210-65-00-5808 POSTAGE&SHIPPING 3 0001 3,000 01-210-65-00-5809 PRINTING&COPYING ---4,500 4,500 ------ 01-210-65-00-5810 PUBLISHING&ADVERTISI N G 1,000 1,000 -------------- ------------------- Increase in gasoline prices-I do not have the funds in my budget to off set this increase. I will need to use money 01-210-65-00-5812 IGASOLINE 36,300 51,300 from the contingency line item per Mayor Prochaska DRAFT 1/30/06 Page 5 of 30 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2005-2006 Items identified in color are project-specific revenue streams. Expenses also identified in the same GENERAL FUND '*"Items REQUESTED REVISIONS IN YELLOW lProposed Revised ACCOUNT 12005-2006 2005-2006 NUMBER DESCRIPTION I Bud get !,Budget COMMENTS PUBLIC SAFETY/POLICE DEPT. 01-210-65-00-5813 AMMUNITION —------ 01-210-72-00-6500 IMRF PARTICIPANTS- 8,732� 8,7321___ 01-210-72-00-65-01 SOCIAL SECURITY&MEDICARE 115,170, 116,600 F— —----- 01-210-72-00-6502 POLICE PENSION 231,686 231,686, 01-210-75-00-7002 COMPUTER EQUIP&SOFTWARE 11 8 01-210-78-00-9004 BIKE PATROL 2,OOOL 2,000 01-210-99-00-9910 !TRANSFER TO POLICE CAPITAL 01 0 TOTAL EXPENSES--:PIJ-ku-b SAFE--T--Y--/P-OL-I--C—E—D--E--P--T. 1 2,145,143i 2,224,534� DRAFT 1/30/06 Page 6 of 30 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2005-2006 -T 'Items identified in color are project-specific revenue streams. Expenses also identified in the same GENERAL FUND Proposed--color.REQUESTED REVISIONS IN YELLOW Revised ACCOUNT 2005-2006 2005-2006 NUMBER DESCRIPTION Budget Budget COMMENTS PLANNIING & DEVELOPMENT EXPENSES 01-220-50-00-5107 !EMPLOYEE SALARIES 131,086 43,700 true up salary line item based on actual and delayed hirings and recruitment costs 01-220-61-00-5300 LEGAL SERVICES 20,000 38,000 01-220-62-00-5401 CONTRACTUAL SERVICES 50000 50 000 ----- —--------- 01-220-62-00-5430 PLANNING CONSULTANT -2-0,000. 45, 01-220-69-00-5439 ECONOMIC DEVELOPMENT 45,000 000i 01-220-62-00-5438 CELLULAR TELEPHONE 1,000 Boo 01-220-64-00-5600 DUES 200 300 01-220-64-00-5604 TRAINING&CONFERENCES 6,000 3,000 ------- 01-220-64-00-5605 TRAVEL EXPENSE 3,000 1,000 01-220-64-00-5616 BOOKS&PUBLICATIONS 425 425 01-220-65-00-5804 OPERATING SUPPLIES 5,0-00 5,000 01-220-65-00-5809 PRINTING&COPYING 21500 1,000 01-220-65-00-5810 PUBLISHING&ADVERTISING 10,000 10,0001 01-220-65-00-5814 1 BOOKS&MAPS 3,000 3,00-0- 01-220-72-00-6500 IMRF PARTICIPANTS 9,672 3,475 ---------- 01-220-72-00-6501 SOCIAL—SECURITY&MEDICARE 7,724 3,350 .01-220-75-00-7002 !COMPUTER EQUIP&SOFTWARE 1 7,5001 7,500L----- 01--2-20-�6-oo-766�-�bF�i---C--E--E--QbiP--M-E--N---T 21500 24,000 Includes$20,000 for plotter PLANNING&DEVELOPMENT 324,6071 259,250 TOTAL EXPENSES: DRAFT 1/30/06 Page 7 of 30 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2005-2006 Items identified in color are project-specific revenue streams. Expenses also identified in the same GENERAL FUND i color.REQUESTED REVISIONS IN YELLOW _Jpr�Proposed 0 Revised p� ACCOUNT 052006 12005-206 0 NUMBER DESCRIPTION Bud et IBudget COMMENTS STREETS EXPENSES 01-410-50-00-5107 SALARIES-EMPLOYEE 182,345 186,178 Increase due to true up of cola/merit 01-410-50-00-5136 iSALARIES--PART TIME 11,000 2,500 01-410-50-00-5137 SALARIES-OVERTIME 20,4001 20,400 ------------- 01-410-61-00-5313 ENGINEERING-IN TOWN ROAD PROG 215,210F 216.21,0,starting phase I I of the program ------------- 01-410-61-00-5314 INSPECTIONS&LICENSES 200 500 additional licenses and certificates 01-410-62 00-5401 ICONTRACTUAL SERVICES 2,000 2,000_______ _- ----- ---_ 01-410-62-00-5408 MAINTENANCE EQUIPMENT 9-6001 q'000 01-410-62-00-5409 MAINTENANCE-VEHICLES 11,550 15,500 Additional unplanned maintenance needed 01-410-62-00-5414 MAINTENANCE- -TRAFFIC SIGNALS- - 24,000 24,000 ------- 01-410-62-00-5415 MAINTENANCE STREET LIGHTS 25,000 25,000 -------- 01-410-62-00-5420 MAINTENANCE STORM SEWER 10,000 --- -------- 01-410-62-00-5421 WEARING APPAREL 6,000 6,000, 01-410-62-00-5434 RENTAL-EQUIPMENT 2,000] 2,000 01-410-62-00-5435 ELECTRICITY 51,800 55,000 Additional street lights 01-410-62-00-5438 CELLULAR TELEPHONE 1 3,300 3,300 01-410-62-00-5440 STREET LIGHTING 6,000 6,000 01-410-64-00-5604 TRAINING&CONFERENCES 5,000 5,000 ------------------- --------- ------- --------- 01-410-65-00-5804 OPERATING SUPPLIES 25,800 25,800 01-410-65-00-5§12_1 GASOLINE 24,000 30,000 Increase in gas costs 01-410-65-00-5815 HAND TOOLS 2,500 5,000 new jack,air tools and shop tool set -------------- � ___ 01-410-65-00-5817 IGRAVEL 6,500 6,500] 01-410-72-00-6500 IMRF PARTICIPANTS 16,783! 16,7831 01-410-72-00-6501 SOCIAL SECURITY&MEDICARE 16,6161 16,616 01-410-75-00-5418 !MOSQUITO CONTROL 28,950 20,300 contract complete for this fiscal year 01-410-75-00-7004 SAFETY EQUIPMENT 1,000 1 1,00011.1 01-410-75-00-7100 STVEET_REHAB-PROJECTS- 40,0061-1 -­ 40,000� ROAD CONTRIBUTION FUND PROJECTS 12,000 FY 05/06 Countryside/McHugh/Marketview re-striping$10K ROAD CONTRIBUTION FUND-RESERVE 938,000 reserve for next FY 05:Phase 1 Storm Sewer$500K Phase 1 Roadways$1,030,000K Construction Inspection$230K Phase 2 01-410-75-00-7101 IN-TOWN ROAD PROGRAM 2 Wj,_stprm sewer$48 OK Construction Inspection$105K IN-TOWN ROAD PROGRAM RESERVE 1,672,015 Reserve for next FY(includes FY accrued interest) FY P 01-410-75-00-7099 GRANDE RESERVE PERIMETER ROADS 4,000,000 500,000 01-410-75-00-7102 --TREE&STUMP REMOVAL 30,000 30,000 01-410-75-00-7103 SIDEWALK CONSTRUCTION J­ 3010001 30,000 ----------- 0 -! i 0 SSA EXPENSES 18,0 0 TRANSFER RANSFER TO WATER IMPROVEMENT n, x In Town Road Program-Proceeds received in Gen Fund,project costs also in Water Imp. ,TOTAL EXPENSES:STREETS 1 9,459,9541 6,509,6021 DRAFT 1/30/06 Page 8 of 30 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2005-2006 ***Items identified in color are project-specific revenue streams. Expenses also identified in the same GENERAL FUND color.REQUESTED REVISIONS IN YELLOW Proposed Revised ACCOUNT 2005-2006 12005-2006 NUMBER DESCRIPTION Bud et l Bud get COMMENTS HEALTH &SANITATION EXPENSES 01-540-62-00-5442 GARBAGE SERVICES 565,670 525,000 01-540-62-00-5443 LEAF PICKUP 5,500 5,000F_ TOTAL EXPENSES:HEALTH&SANITATION 571,170 530,000 ----------- TOTAL GENERAL FUND REVENUES 18,008,036; 15,040,316 TOTAL GENERAL FUND EXPENSES 18 008,036' 15, 40,316 VU � , NDSURPLUS DEFICIT 0 01 DRAFT 1/30/06 Page 9 of 30 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET --------------- - --------- FY 2005-2006 --------------------- MFT - !Proposed ACCOUNT Proposed Revised 2005-2006 2005-2006 NUMBER (DESCRIPTION Bud et Budget (COMMENTS REVENUES I 15-000-40-00-3999 CARRY OVER BALANCE 475,000 423,181 Per audit 15-000-40-00-4060 MOTOR FUEL TAX ALLOTMENTS 268,304 250,487 Per updated State numbers-does not include special census 15-000-46-00-4600 INVESTMENT INCOME 5,000 12,000 TOTAL REVENUES: 748,3041 685,668 Countryside being constructed this FY-Reserve—for FYOW-0-6-Game-F--a--r--m/-S-om—on--a--u--k--- 15-000-65-00-5800 CONTINGENCY 145,250 94,088 Project$500k 15-000-65-00-5818 SALT-­­-, 51,800 51,800:1--­­- 15-000-75-00-7007 SIGNS 9,990 9,990 15-000-75-00-7008 iCRACK FILLING 30,000 30,000 15-000-75-00-7107 CONSTRUCTION ENGINEERING 150,000 150,000 15-000-75-00-7110 COLD PATCH 9,600 9,600 15-000-75-00-7111 HOT PATCH 8,000 8,000; 15-000-75-00-7112 FAXON RD ENG/CONSTRUCTION 1,000 1,000 ­­­---------- Countryside Parkway Construction 300,000 i 300,0001--- 15-000-99-00-9960 TRANSFER TO FOX INDUSTRIAL 42,664 31,190 True up transfer amount per MFT audit TOTAL EXPENSES:' 748,304 68576T TOTAL FUND REVENUES 748,304' 685,668 TOTAL FUND EXPENSES 748,304 685,668 FUND SURPLUS DEFICIT 01 0i DRAFT 1/30/06 Page 10 of 30 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2005-2006 MUNICIPAL BUILDING Proposed Proposed Revised ACCOUNT 2005-2006 2005-2006 NUMBER iDESCRIPTION Budget Budget �(COMMENTS REVENUES —------ CARRY OVER 16-000-40-00-3999 CARRY OVER BALANCE 45,000 0 per audit --------- 16-000-42-00-4211 DEVELOPMENT FEES-BUILDING 105,000 80,000 decrease due to#of permits received this FY already prepaid this fee BEECHER RENTAL FEE 0 6,000 New line for Beecher Center rental 16-000-49-00-4901 TRANSFER FROM GENERAL FUND 49'523 102,043 To offset decrease in permit fee revenue ....... TOTAL REVENUES: 199,523� 188,0431 16-000-62-00-5416 !MA INT-GENE RAL BLDG &GROUNDS 8,000 5,000 16-000-75-00-7008 ENTRY WAY SIGNS 3,600 0 will order this FY, but expend in FY 06/07 16-000-75-00-7200 BLDG IMPROV-SEEHGEPURP IF R NIT PARK& REC 13,000 10,000 16-000-75-00-7203 BLDG IMPROVEM ENTS-PUBLIC 10,000� 10,000 ------- 16-000-75-00-7204 BLDG MAI NT-CITY H ALL 10,000 12,000 16-000-75-00-7205 BLDG IMPROVEMENTS LIBRARY 4,000 16-000-75-00-7209 1 BEECHER PARKING LOT 45,000 41,120 true cost 16-000-75-00-7206 LANDSCAPING- PUBLIC BUILDINGS 2,000 2,000 ---------- -------------- 16-000-78-00-9009 RESERVE TRANSFER TO DEBT SERVICE 103,923 103,923 01 TOTAL EXPENSES 199,523 188 043 —------------- -__-_- ---------- TOTAL FUND REVENUES 199,523 188,043 ----------- TOTAL FUND EXPENSES 199,523 188,043 ,FUND SURPLUS(DEFICIT) 0 0 DRAFT 1/30/06 Page 11 of 30 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET - ---------- ------- FY 2005-2006 ----------- POLICE CAPITAL Proposed Proposed Revised 2005-2006 2005-2006 ACCOUNT NUMBER DESCRIPTION Budget !Budget COMMENTS REVENUES 20-000-40-00-3999 CARRY OVER-WEATHER WARINING 70,000 69,250 Per Audit-weather warning siren carryover 20-000-42-00-4212 DEV FEES-POLICE 146,250 170,000 20-000-44-00-4402 K-9 DONATIONS 0001 10001 - -----—::::::� -- -1-., i ---------._I - --- ----- ------ -- -- IN CAR VIDEO DONATIONS 2,2001 2,2001 20-000-44-00-4403 1, ­-------------- 20-000-44-00-4404 DONATIONS 500 1,500 —----- 20-000-44-00-4405 WEATHER WARNING SIREN 30,000 30,000 20-000-44-00-4431 iSALE OF POLICE SQUADS 5001 500 RICP DISASTER PLAN GRANT 0 9,990 Grant dollars MISC INCOME 0 24,600 1998 Police Grant 20-000-48-00-4800 LOAN PROCEEDS 0I 0 —------------- 20-000-49-00-4901 TRANSFER FROM GENERAL FUND 01 0 TOTAL REVENUES: 250,4501 309,040 ——----------- EXPENSES LETHAUNON-LETHAL WEAPONS 6,K5 825 20-000-65-00-5811 il -- 20-000-75-00-7001 EQUIPMENT 0 20,000 To outfit already purchased new squads 20-000-75-00-7002 K-9 EQUIPMENT 1,000 1,000 20-000-75-00-7006 CAR BUILD OUT 26,0001 261000L------- 20-000-75-00-7008 NEW WEATHER WARNING SIRENS 60,000 60,000 20-000-75-00-7005 -VEHICLES ---j 74,0001 74,000 —------- RESERVE-WEATHER WARNING SIREN 40,000 39,648 reserve for next FY 20-000-78-00-9009 RESERVE 18,515 57,457 —---------- 20-000-99-00-9965 TRANSFER TO DEBT SERV FUND 24,1101 24,110 -------­­­---- TOTAL EXPENSES: 250,4501 309,040 ---------- TOTAL FUND REVENUES 250,450-- , ---- TOTAL FUND EXPENSES 250,450 309,0401 ----------- ,FUND SURPLUS(DEFICIT) 0 01 DRAFT 1/30/06 Page 12 of 30 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2005-2006 PUBLIC WORKS CAPITAL Proposed i - Proposed Revised ACCOUNT 2005-2006 2005-2006 NUMBER (DESCRIPTION Budget Bud et COMMENTS REVENUES 21-000-40-00-3999 CARRY OVER BALANCE ------- 234,174 186,721 Actual per audit---------- 21-000-42-00-4213 DEVELOPMENT FEES-PUBLIC WORKS 383,750 485,000 21-000-44-00-4430 SALE OF EQUIPMENT 32,000 34,113 21-000-49-00-4915 ITRANSFER FROM WATER FUND 50,000 1 1 50,0010 21-000-49-00-4920 !TRANSFER FROM SEWER FUND 30,0001 30,000 TOTAL REVENUES: 729,9241 785,834 EXPENSES 21-000-75-00-7005 VEHICLES 375,000 375,000'L, 21-000-75-00-7015 SKID STEER UPGRADE 3,500 3,952 paid extra on trade in for tire wear on our machine 21-000-75-00-7107 TRUCK ACCESSORIES 14,0001 14 000 21-000-75-00-7130 PUBLIC WORKS BL D G A-D__D1 T_1-0-N 77,42411 77 424 wwill notbebuilithisFY SALT D.0,M_E 175,000 j 175,000 EQUIPMENT 85,000 90,500 FY 05: Backhoe$85k plus trailer$5500 - -------------- --------- —------- 21-000-78-00-9009 jRESERVE 0 49,958 TOTAL EXPENSES: 1 729,924 785,8� _ 4 L --------- ------ TOTAL FUND REVENUES 924 785,634 TOTAL FUND EXPENSES 729,924 785,834-- 858341 FUND SURPLUS(DEFICIT) 0 DRAFT 1/30/06 Page 13 of 30 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2005-2006 PARKS & RECREATION CAPITAL -Pro pose-d---4- Proposed Revised ACCOUNT 12005-2006 2005-2006 NUMBER DESCRIPTION Bud et 'Budget COMMENTS REVENUES 22-000-40-00-3999 'CARRY OVER 0 65,691 $60,000 for 2 trucks from FY 04/05 22-000-49-00-4930 TRANSFER FROM GENERAL FUND 0I 0 22-000-42-00-4216 PARKS CAPITAL FEE 13,750 20,000..----- —------ PARK CAPTIAL DONATIONS 0 7,000 received from Youth Baseball-for ballpark equipment SALE OF VEHICLES/EQUIPMENT 10,000 10,0001 22-000-42-00-4218 IL CLEAN ENERGY GRANT 0 0 TOTAL REVENUES: 23,750 S J- - EXPENSES-----------� . -- -- ---71- PARKS CAPITAL OUTLAY 22-610-75-00-7006 PICK UP TRUCK 0 60,000 2 trucks 22-610-75-00-7009 COMPUTER WORKSTATIONS 9,000 9,000 22-610-75-00-7013 PLAYGROUND REPLACEMENT 2,500 2,500, 22-610-75-00-7014 SIGN REPLACEMENTS 4,000 4,0001. 22-610-75-00-7015 M0*1046 PARKS EQUIPMENT 0 7,000 sprayer&ballfield drag 22-610-75-00-7017 RECREATION EQUIPMENT 6,600 22-610-65-00-5800 RESERVE 1,650 13,591 TOTAL EXPENSES: PARKS 23,750 -102,691' TOTAL FUND REVENUES 23,750 102,6911 TOTAL FUND EXPENSES 23,750 102,691 I FUND 0 01 DRAFT 1/30/06 Page 14 of 30 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET ---------- ......--------- FY 2005-2006 SEWER IMPROVEMENT Proposed Proposed Revised ACCOUNT 2005-2006 2005-2006 NUMBER �DESCRIPTION Budget Bud et �COMMENTS 37-000-40-00-3999 CARRY OVER BALANCE 3,720,000 4,016,171 $2.8M Countryside Interceptor$300k Bruell St. 37-000-42-00-4220 CONNECTION FEES 1 11,260,000 1,260,000*Y05/06 700 permits @$1800 37-000-42-00-4221 RIVER CROSSING FEES 20,0001 20,0001 --- —------ 37-000-48-00-4803 ROB ROY CREEK REVENUE 12,150,313 SOUTHWEST SERVICE AREA INTERCEPTOR )01 5,500,000' 5,500,0( 1 —------- I - - 150'000t#�red for SSES Loan------- 37-000-49-00-4901 TRANSFER FROM GENERAL FUND 150,000 37-000-46-00-4600 INVESTMENT INCOME 35,000 170,000 Increase primarily due to Rob Roy Creek$12M bond proceeds ------------ ------ - ------------------- ------ TOTAL REVENUES: —--------- 20_,6-85,000 23,266,484f___ EXPENSES 2-00-5401 CONTRACTUAL/PROFESSIONAL SERVICES 50,000 50,000L 37-000-6 37-000-62-00-5402 ENGINEERING/LEGAL/CONTINGENCIES-COUNTRYSIDE 300,000 100,000 ,____ __------------- 37-000-62-00-5405 ENGINEERING/LEGAL/CONTINGENCIES- BRUELL ST. 70,000 95,000 37-000-62-00-5406 ENGINEERING/LEGAUCONTINGENCIES-HYDRAULIC 0 2,000 37-000-65-00-5421 'GIS SYSTEM 10'000� ------- 1 10,000[ -- ---- 37-000-65-00-5800 CONTINGENCY 86,952 434,610 C( 37-000-66-00-6012 �DIE' BT ISSUANCE COSTS 0 85,700 Rob Roy Creek 37-000-75-00-7502 ;HYDRAULIC INTERCEPTOR 01 0L 37-000-75-00-7503 COUNTRYSIDE INTERCEPTOR 2,850,000 2,823,455 37-000-75-00-7505 ROB ROY CREEK SANITARY 10,000,000 12,177,613 bond proceeds plus interest SOUTHWEST SERVICE AREA INTERCEPTOR l 5,500,000 5,500,000 MANHOLE REHAB PROJECT 15 000 15,000 37-000-75 664M_ OR 5 HEARTLAND ONSITE INTERCEPT OVER SIZING 278,8931 278,8931 37-000-75-00-7504 t1BRUELL STREET LIFT STATION 500,000 798,000 SCADA System- 100,0001 100,000, 37-000-99-00-9901 TRANSFER TO GENERAL FUND 200,000 150,000 $150K required for SSES Loan 37-000-99-00-9965 TRANSFER TO DEBT SERVICE 724155 646,213 TOTAL- EXPENSES: ------- 20,685!000 23,266,484 —------—---------- ------------- ---------------- ------_ ------------ TOTAL FUND REVENUES 20,685,000 23,266,484' TOTAL FUND EXPENSES 20,685,00 23,266,484- , , - RUINID SURPLUS(DEFICIT j 0 01 DRAFT 1/30/06 Page 15 of 30 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2005-2006 ------- WATER IMPROVEMENT i F_ Proposed Proposed evised ACCOUNT 1 2005-2006 ;2005-2006 NUMBER DESCRIPTION Budget 'Bud et 'COMMENTS 41-000-40-00-3999 CARRY OVER 4,700,000 0-Per-audit 41-000-42-00-4220 CONNECTION FEES 1,125,000 1,450,000 SOUTHWEST WATER MAIN PROJECT REVENUE 21600,0001 2,600,000 41-000-46-00-46001 INVESTMENT INCOME 35,000 80,000 Due to bond proceeds+slight increase in interest rates 41-000-48-00-4800 1 LOAN PROCEEDS 0 1,947,070 IEPA Loan for contract B.1 ---------- 4- 1612A LOAN/CONTRACT B PROCEEDS 0 2,046,893 Contracts 6.2&B.3 41-000-48-00 8014- 41-000-49-00-4915 TRANSFER FROM WATER FUND 01 0[_ ------ TRANSFER_- _ -FROM -GENERAL- - -- FUND------- 215,000 215,000 To fund In-Town Road Program water imp. portion TOTAL REVENUES: 8,675,000 8,338,963' EXPENSES 41-000-61-00-5300 !LEGAL SERVICES j 8,000, 8,000 __ 411-000-6 66-_poi JENGINEERING-GENERAL SERVICES 8,000 15,000 increase in engineers rates 41-000-61-00-5400 RADIUM COMPLIANCE PROJECT/CONTRACT D 3,662,730 3,756,097 41-000-61-00-5401 ENGINEERING-RADIUM 425,000 274,000 ------------ ------- 41-000-61-00-5405 !PROFESSIONAL SERVICE RADIUM/CONTRACT B 250,000 35,000 41-000-61-00-5408 CENTRAL ZONE-CONTRACT C WATER IMPRV 150,000 30,000 project nearing completion 41-000-61-00-5410 ENGINEERING-CENTRAL ZONE-CONTRACT C 20,000 30,000 100,000 100,000 F 41-000-61-00-5414 CONTRACT D-SCADA SYSTEM New project for this FY 41-000-61-00-5415 USGS GROUNDWATER STUDY 24,490 40,000 Blackberry Creek flood study-should be reimbursed a portion from USGS USGS GROUNDWATER STUDY COUNTYWIDE 13,000 13,000�Deep acqui-fer-study USGS GROUND I WATER-STUDY- - SHALLOW WATER 55,108 55,108 1 S-hal bow-acquifer study 41-000-65-00-5421 GIS SYSTEM 10,0001 10,000 Lphased project ------------- ------------ 41-000-65-00-5800 CONTINGENCY 8,353 2,439 41-000-75-00-7503 SOUTHWEST WATER PROJECT--- 2,600,0001 2,600,000[___ 41-000-75-00-7504 NORTH WATER TOWER-CONTRACT A 130,000 230,000 41-000-75-00-7507 OVERSIZING- HEARTLAND 38,8771 38,877 WATERMAIN PROJECTS --------- A 40,000� 40,000-0range/Olsen------ -- ------ ---------- ------ IN TOWN ROAD PROGRAM WATER_PROJECTS___ Z',J,4,QW Fox/Washington Watermain loop+Heustis Watermain Replacement -_-------------- SCADA System 420,000 350,000 Installation for Water Facilities-will begin late FY 05/06 41-000-99-00-9901 TRANSFER TO GENERAL FUND 200,0001 200,0001 41-000-99-00-9965 ITRANSFER TO DEBT FUND 296,442 296,442 TOTAL EXPENSES: 8,675,000 8,338,963 ---- ---------- TOTAL FUND REVENUES 8,675,000 8,338,963 TOTAL FUND EXPENSES.------------.--. 8,675,000 8,338,963 FUND SURPLUS(DEFICIT) 0 0 DRAFT 1/30/06 Page 16 of 30 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET ------------ FY 2005-2006 DEBT SERVICE Proposed �Proposed Revised 12005-2006 2005-2006 ACCOUNT NUMBER DESCRIPTION Budget Bud et COMMENTS 42-000-40-00-3999 CARRY OVER 10,000 13,918 Per audit 42-000-44-00-4440 RECAPTURE-WATER/SEWER 100,000 125,8821---- 42-000-44-00-4940 TRANSFER FROM MUNICIPAL BLDG -103,923] _ 103,923 ------- 42-000-49-00-4901 TRANSFER FROM GENERAL FUND 42-000-49-00-4910 TRANSFER FROM POLICE EQUIP CAP 24,111101 24,110 42-000-49-00-4925 ITRANSFER FROM SANITARY SEWER 646,2 13 646,213 -------------- - 42-000-49-00-4930 !,TRANSFER FROM WATER IMPRV FUND 296,4421 296,442 TOTAL REVENUES: 1,180,6881 11,210,48_8_ -------------- EXPENSES ------------- 42-000-66-00-6001 CITY HALL BONDS-PRINCIPAL PMT 50,0001 Due 1/11/2022 Munic Bldg ---------- 42-000-66-00-6002 CITY HALL BONDS - INTEREST PMT 53,923 53,923!Due 1/11/2022 Munic Bldg 42-000-66-00-6003 IRBB-BRUELL STREET INTEREST PYMT 85,435 85,4-35Due 2/11/2023 Sewer Imp. 42-000-66-00-6004 IRBB-BRUELL STREET PRINCIPAL PYMT 80,0001 80,000;Due 2/11/2023 Sewer Imp. 42-000-66-00-6005 NORTH WATER TOWER-INTEREST PYMT 1,912 1,912!Due 5/11/2021 Water Imp. 42-000-66-00-6006 NORTH WATER TOWER-PRIN PYMT 23,088 23,088 Due 5/1/2021 Water Imp. ---- ------- 42-000-66-00-6007 4.8 MILLION DEBT CERT INT PYMT(WATER) 233,150 233,1150 Due 12/15/2022 Water Imp. 42-000-66-00-6008 COUNTRYSIDE ALT REV PRINCIPAL PYMT 120,000 120,000 New line(1st principal payment)Due 2018 Sewer Imp. 42-000-66-00-6009 COUNTRYSIDE ALT REV INTEREST PYMT 120,6381 120,638 Due 2018 Sewer Imp. ------ -------- 42-000-66-00-6010 CO M ED/HYDRAULIC DEBT CERT. INT PYMT 43,1281 43,128 f Due 12/30/2014 Sewer Imp. 42-000-66-00-6011 COM ED/HYDRAULIC DEBT CERT. PRINC. 135,000 135,000 New line(1st principal payment)_Due 12/30/2014 Sewer Imp-----------_ 42-000-66-00-6050 LOAN PAYMENT-SANITARY SIPHON 38,980 38,980 Due 1/25/13 Sewer Imp. 42-000-66-00-6054 LOAN PAYMENT-POLICE SQUAD CAR 10 110 Due 7/15/05 Police 42-000-66-00-6055 L_0-AN-P AYM__EN T-----S-S_E­S_ I E P A L17-_1153- - 107,051 1 107,051 Due 9/6/19 Sewer Imp. 42-000-66-00-6056 YNB-POLICE/ADMIN CARS 01 0 Final pymt 5/1/04 42-000-66-00-6072 2 MILLION ALT REVENUE(B.2&B.3)INT. 0 29,800 2005 Bond issue ------------- Fw 42-000-66-00-6070 $650K ROAD IMPROVEMENT PROG INT. 14,273 14,273 New line Due 12/30/2012 Water Imp.(due to portion of project H2O related) 42-000-66-00-6071 $650K ROAD IMPROVEMENT PROG PRINC 50,000 50,000) New line Due 12/30/2012 Water lmp�due to portion of project H2O related) ---------- TOTAL DEBT SERVICE 1,180,688 1,210,488 ------------ TOTAL FUND REVENUES 1,180,688' 1,210,488 TOTAL FUND EXPENSES 11,11 80 688 _1 121148811___ [FUND SURPLUS DEFICIT 0 01 DRAFT 1/30/06 Page 17 of 30 UNITED CITY OF-YORKVILLE PROPOSED REVISED BUDGET FY 2005-2006 WATER OPERATIONS Proposed Proposed Revised 2005-2006 2005-2006 ACCOUNT NUMBER DESCRIPTION Budget Budget �COMMENTS REVENUES 51-000-40-00-3999 CARRY OVER BALANCE 1,500,000 441,642 Per audit ------------- 51-000-42-00-4240 '!BULK WATER SALES 10,000 15,000 Increased use of bulk water 51-000-42-00-4241 WATER SALES 900,000 1,000,000 FY 04/05 was$983k 51-000-42-00-4242 WATER METER SALES 130,000 250,000 Currently at$205k 51-000-42-00-4243 LEASE REVENUE-H2O TOWER 21,600 24,000 -------------- 51-000-44-00-4490 MISCELLANEOUS INCOME 2,0001 2,000 ---------- 51-000-46-00-4600 INVESTMENT INCOME 15,000 TOTAL REVENUES: 2,575,6001 1,747,6421, ------- EXPENSES 51-000- , -50-00-510 7 SA-LARIES --EMPLOYEE -264,873--- 264,873 decrease to delay in hiring PT UB clerk - ----------- 51-000-50-00-5136 SALARIES PART TIME 8,200 200 8,20012 part time employees from ju-ne-1 through sept 51-000-50-00-5137 SALARIES-OVERTIME 27,000 27,000 L-- ---------- 51-000-61-00-5300 LEGAL SERVICES 2,000, 2,000 51-000-61-00-5303 JULIE SERVICE 6,800 6,800 ---------- 51-000-62-00-5401 CONTRACTUAL SERVICES 4,500 4,500 51-000-62-00-5408 MAI NTENANCE-EQU I PMENT 91000 9100 51-000-62-00-5409 MAINTENANCE-VEHICLES 51-000-62-00-5411 MAINTENANCE-COMPUTERS 11000 -­.­,-----1,000:-­ ------------ 51-000-62-00-5413 MAINTENANCE-CONTROL SYSTEM 10,0001 100001 ----------------- 51-000-62-00-5421 WEARING APPAREL 5,500, 51-000-62-00-5434 RENTAL- EQUIPMENT 1,00011, 1,0001 51-000-62-00-5435 ELECTRICITY 170,000 130,000 51-000-62-00-5436----TEL-EPHONE 22,600, 20,000 ---------------- 51-000-62-00-5438 CELLULAR TELEPHONE-- ----- 5,7001 5,700 ------ --------- 51-000-64-00-5600 DUES 1,000 1,000 51-000-64-00-5603 SUBSCRIPTIONS 250 51-000-64-00-5604 TRAINING &CONFERENCES 3,000 3,000 ----------- 51-000-64-00-5605 TRAVEL/MEALS/LODGING 3,000 3,000 51-000-65-00-5800 CONTINGENCIES 30,000 30,000 3%of day to day operating expenses per policy 51-000-65-00-5804 OPERATING SUPPLIES 46,200 46,200 51-000-65-00-5808 POSTAGE&SHIPPING 13,5001 13,500 51-000-65-00-5809 PRINTING &COPYING 5,500 8,250 due to increase in customers 51-000-65-00-5810 PUBLISHING&ADVERTISING 1,0001 1,0001 51-000-65-00-5812 GASOLINE 9,570 20,000 Increase in gas costs 51-000-65-00-5815 HAND TOOLS GRAVEL 5,00011 5,000 DRAFT 1/30/06 Page 18 of 30 --------------,-- UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2005-2006 WATER OPERATIONS Proposed Proposed Revised 2005-2006 ACCOUNT NUMBER DESCRIPTION !Budget Budget (COMMENTS 51-000-65-00-5820 CHEMICALS 30,000 30,000 51-000-65-00-5821 CATHODIC PROTECTION 6,250 6,_2_50 51-000-65-00-5822 (WATER SAMPLES 12,000 12,000 51-000-72-00-6500-- IMRF PARTICIPANTS 24,354 24,354 —--.- 51-000 72-00-6501 SOCIAL SECURITY&MEDICARE 23,5151 23,515 51-000-75-00-7002 COMPUTER EQUIP&SOFTWARE 4,000 4,000 51-000-75-00-7004 SAFETY EQUIPMENT 2,000 3,000 purchased-equipment for-new treatm-ent-facilities- 51-000-75-00-7506 METER READERS 10'900!, 10,900!,more meters to read, may need additional time 51-000-75-00-7507 HYDRANT REPLACEMENT 10,000 101000i 51-000-75-00-7508 METERS&PARTS 262,500 262,W6 l000 meters+5%increase in price - 51-000-78-00-9005 REFUND 1,500 1,500 51-000-62-00-5407 TREATMENT FACILITIES 0&M 150,000 110,000 from EEI memo dated 8/15/03 includes electricity ----------- WATER TOWER PAINTING 220,0001 _220,000 RESERVE H2O TOWER MAI NT. 43,2001 43,200 51-000-78-00-9005 MERIT 7,318 0 Moved to employee salary line item 51-000-78-00-9009 IRESERVE 853,870 101,650 Decrease primarily due to water tower painting and O&M for treatment facilities 51-000-99-00-9901 1TRANSFER TO GENERAL FUND 200,000] 200,000� 51-000-99-00-9950 TRANSFER TO PW EQUIP CAPITAL 50,0001 50,000 TOTAL EXPENSES: 2,575,600 1,747,6421 —---------------- - ---- ---- --- ------ ---------- TOTAL FUND REVENUES 2,575,600 1,747,642 TOTAL FUND EXPENSES 2,575,6001 1,747,6421 FUND SURPLUS(DEFICIT) 0 0� DRAFT 1/30/06 Page 19 of 30 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET ----------- FY 2005-2006 SEWER MAINTENANCE Proposed Proposed Revised 12005-2006 2005-2006 ACCOUNT NUMBER DESCRIPTION 'Bud et Budget �COMMENTS REVENUES CARRY OVER/FUND BALANCE 450,000 327,526 Per audit LIFT STATION INCOME 8,000; 8,000[-- 52-000-42-00-4250 1 SEWER MAINTENANCE FEES 355,000 450,000 FY 04/05 was$422k -­------------------- 52-000-42-00-4251 iSEWER CONNECTION FEES 140,000 165,000 52-000-46-00-460-0- INVESTMENT INCOME 15,000 15,000 1 Increase due to slight increase in interest rate&fund balance TOTAL REVENUES: ....... �_968o0_00-- 965,5261 EXPENSES 52-000-50-00-5108 SALARIES REGULAR 137,555 125,245 decrease due to replacement of MW II position with MWI ­­----------------- 52-000-50-00-5136 ?ARTTIME 5,000 2,500 52-0.00-50-00-5137 --4 SALARIES-OVERTIME 12,000;i 12,0001 52-000-62-0075401--�CONTRACTUAL SERVICES- 2,000 5,000. 52-000-62-00-5408 MAINTENANCE-EQUIPMENT 5,000 5,000 52-000-62-00-5409 MAINTENANCE-VEHICLES 3,000 3,000 0 52- ,00,-62-00-54-1.9 MAINTENANCE-SANITARY- -- - S,EWER 2-5,000 25,000 52-000-62-00-5421 WEARING APPAREL r 4,500 4,500 ---------- 52-000-62-00-5422 LIFT STATION MAINTENANCE 25,000 30,000 increase number of lift stations started motor rotation-program- - EQUIPMENT 1,0001 52-000-62-00-5434 1 RENTAL-EQUIPMENT 110W ---------- ----------- -- 52-000-62-00-5435 ELECTRICITY 16,500 13,500 approx true cost,always in with pumping costs 52-000-62-00-5438 CELLULAR TELEPHONE 2,500 .......2,500 52-000-64-00-5604 TRAINING&CONFERENCES 1,500 1,500 52-000-64-00-5605 TRAVEL MEALS/LODGING 1,500 -------------- 52-000-65-00-5800 CONTINGENCIES 9,3001 9,300 3%of day to day operating expenses per policy i --­-.1 ---------- 52-000-65-00-5802 OFFICE SUPPLIES 2,000 2,200 --------- 52-000-65-00-5805 SHOP SUPPLIES J 2,500 2,500 52-000-65-00-5812 GASOLINE 10,500 18,000 increase in costs and number of vehicles 1,0001 )00 52-000-65-00-5815 HAND 1 1( ­­-­- ­ -­-------- 52-000-65-00-5817 GRAVEL 2,000! 2,000 52-000-65-00-5823 !SEWER CHEMICALS 5,000 3,000 using new methods that are less expensive but more effective 52-000-72-00-6500 IMRF PARTICIPANTS------ 12,475 12,475 52-000-72-00-6501 SOCIAL SECURITY&MEDICARE 12,106 12,106 ---------- ------------- ----------- 52-000-75-00-7002 COMPUTER EQUIP&SOFTWARE 2,500 2,500 no new work stations planned_ 52-000-75-00-7003 OFFICE EQUIPMENT 6 OM 6000 ---------- ....... ­� ­­­---------- ---M --- - ---- ---- - -- 2'0�ot 2,000 52-000-75-00-7004 SAFETY EQUIPMENT-----------'' -- f- --_ __ - 52-000-78-00-9005 MERIT 3,695 0 Moved to reserve 52-000-78-00-9009 RESERVE 554,869 560,200 Reserve for SSES Phase 11 Analysis 52-000-99-00-9901 TRANSFER TO GENERAL FUND 70,000� 70,000 52-000-99-00-9950 TRANSFER TO PW EQUIP CAPITAL— 30,000 30,000 - TOTAL EXPENSES 968,000 965,526 ---------- TOTAL FUND REVENUES 968,000 965,526 TOTAL FUND EXPENSES 968,000 965,526 ------------- (DEFICIT) 0 01 DRAIr"i t!T11806 Ad AW Page o t W UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET ------- FY 2005-2006 _-G -1 LAND CASH Proposed ------ lProposed Revised ACCOUNT i2005-2006 2005-2006 NUMBER DESCRIPTION Bud et Budget �COMMENTS REVENUES 72-000-40-00-3999 CARRY-OVER/-STARTING BALANCE -1 650,000 442,437 Per audit 72-000-40-00-4700 LAND CASH -OTHER 0I 0 TRANSFER FROM LAND ACQUISITION 0 150,000 Recommended for Hoover holding costs To be discussed-at Park Board 2/9 72-000-47-00-4701 GREENBRIAR-LA ND CASH 15,4981 15,498 --- -------- 72-000-47-00-4703 ]PRAIRIE GARDEN-LAND CASH 0 9,450 ------------- 72-000-47-00-4705 ';COUNTRY HILLS-LAND CASH 30,468 15,380 Currently at$1,071 72-000-47-00-4707 FOX HIGHLANDS-LAND CASH 0 1,406 72-000-47-00-4708 FOX HIGHLANDS DUPLEX LAND CASH 0 Or 72-000-47-00-4709 SUNFLOWER-LAND CASH J 9,0251 9,025 72-000-47-00-4712 RIVER'S EDGE-LAND CASH 26,840 17,446 Currently at$10,736($671/permit) ----------- 72-000-47-00-4716 IWHITE OAK UNIT 3&4-LAND CASH 0 1,406 --------------- 72-000-47-00-4717 'AYLYN'S CROSSING-LAND CASH 7,065 7,065�___ 72-000-47-00-4719 WILDWOOD-LAND CASH 0! ---------- --- --- 72-000-47-00-4720 HEARTLAND-LAND CASH Ji 0 0 72-000-47-00-4722 KYLN'S RIDGE-LAND CASH 41,550 12,465 Currently at$4,155 72-000-47-00-4723 HEARTLAND CIRCLE-LAND CASH 75,000 62,000 Currently at$32,000 -RAINTREE 29,0001 29,000,F 72-000-47-00-4724 THE HIGHLANDS 72-000-47-00-4725 !WINDETTE RIDGE-LAND CASH VILLAGE 50,000 50,0001--______ 72-000-47-00-4727 GRAND RESERVE-LAND CASH 290,000 10,000 Developer will construct park,oversight by city 72-000-47-00-4731 MONTALBANO HOMES LAND CASH 10,620 5,310 - ------- 72-000-47-00-4734 WHISPERING MEADOWS-(Kimball lHill) 17,735 43,984 Currently at-$29,886 72-000-47-00-4737 !CALEDONIA 7,6721 7,672 Developer will construct park($300K),oversight by city-balance of land cash per 72-000-47-00-4738 AUTUMN CREEK 314,065 16,921 permit 72-000-47-00-4736 CORNERSTONE 41,3401 41,340: 72-000-47-00-4739 WYNSTONE TOWNHOMES 24,216 45,40250%due a t final plat 72-000-47-00-4740 VILLAS AT THE PRESERVE 72,8391 72,839 72-000-47-00-4700_IOSLAD GRANT 320,000 202,000 Rivers Edge&Cannonball Estates ------ ------ TOTAL CONTRIBUTIONS 2,032,933 �...1,268, ---------- ------- EXPENSES 72-000-75-00-7300 GREENBRIAR 20,000 20,000 72-000-75-00-7304 SUNFLOWER 145,000 145,000 72-000-75-00-7308 Rivers Edge Park#I1 50,000 50,000 72-000-75-00-7311 CANNONBALL ESTATES/KYLYNS 229,000 229,000 72-000-75-00-7317- - - . HEARTLAND C-IRCLE 6,000--- 6,0001I 72-000-75-00-7324 !TOWN SQUARE 10,000, 10,00011 DRAFT 1/30/06 Page 21 of 30 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2005-2006 Proposed �Proposed Revised ACCOUNT 12005-2006 2005-2006 Due to Hoover holding costs, unanticipated expense during original budget 72-000-75-00-7327 GRANDE RESERVE PARK DEVELOPMENT 465,500 10,000 72-000-75-00-7,198 PRAIRIE MEADOWS-(Menards_R!n)_____ 70,0001 70,000[ 72-000-75-00-7700 !PARKS MAINTENANCE FACILITY 500,000 252,046 Decreased due to scheduled park developments&Hoover holding costs 72-000-75-00-7331__'WINDETT RIDGE 65,000 50,000 72-000-75-00-7330 !WHISPERING MEADOWS-(Kimball Hill)__ 5,000 20,000 TO GENERAL FUND 48,000 0 To fund 80%of Park Designer-delay in hiring(hired Comm. Dev Director) TOTALEXPENSES: 2,032,933 1,268,0461 TOTAL FUND REVENUES 2,032,9331: 1,268,046 FUND SURPLUS(DEFICIT) 0i 0 DRAFT 1/30/06 Page 22 of 30 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2005-2006 LAND ACQUISITION --------- Proposed Proposed Revised 2005-2006 2005-2006 ACCOUNT NUMBER DESCRIPTION Budget Bud et COMMENTS REVENUES 73-000-40-00-3999 CARRY_ -OVER- -BALANCE- 214,078 213,618 Per audit ------- 73-000-40-00-4930 COLT FUNDING 73-000-49-00-4935 TRANSFER FROM LAND CASH 01 0 TOTAL REVENUES: 214,078 _21_3,618� EXPENSES TRANSFER TO LAND CASH 0 150,000 Recommended for Hoover holding costs-To be discussed at Park Board 2/9 73-000-65-00-5800 CONTINGENCY 214,078 63,618 TOTAL EXPENSES: 214,078[ 213,618 ---------- ------ TOTAL FUND REVENUES 214,078 213,618 TOTAL FUND EXPENSES 214,078 213,618 FUND SURPLUS(DEFICIT) 0 0; , DRAFT 1/30/06 Page 23 of 30 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2005-2006 PARKS & RECREATION Proposed 'Proposed Revised 12005-2006 12005-2006 ACCOUNT NUMBER DESCRIPTION I �Budget !Budget COMMENTS REVENUES 79-000-40-00-3999 CARRY OVER BALANCE 0 142,356 Per audit 79-000-42-00-4270 ll FEES FOR PROGRAMS 176,825 190,700 includes farmers market and increased because of additional programs 79-000-42-00-4280 CONCESSIONS 10,500 13,812 79-000-42-00-4281 BEECHER BLDG DEPOSIT 4,500 4,500 6501 79-000-42-00-4285 VENDING MACHINE INCOME ...... --6350 -------------- 79-000-42-00-4286 RENTAL INCOME 4,0001 4,000 79-000-42-00-4287 RENTAL INCOME(SHELTERS)_ --- 1,000� 1,0001 79-000-42-00-4288 GOLF OUTING REVENUE 38,000 40,160 Actual revenue 79-000-44-00-4400 DONATIONS 15,000'L__ ______ 79-000-44-00-4404 TREE DONATIONS 500 900 reduced to be inline with actual participation 79-000-45-00-4550 -YOUTH-SERVICES I-G-RAW 2,0001 2,000 79-000-46-00-4600 INVESTMENT INCOME 1,500 8,500 -79-000-49-00-4901 1 - - - - 7TR A N_ S_F_E_R_FROM_ GENERAL FUND 928,567 755,908 TOTAL REVENUES: 1,183,042 1,179,486 __-- ------ -------- PARKS EXPENSES 79-610-50-00-5107 SALARIES-EMPLOYEES 312,678 300,000 decrease due to Exec Director vacancy 79-610-50-00-5136 SALARIES- PART-TIME 45,000 45,000F_______ 79-610-50-00-5137 SALARIES-OVERTIME 61,9008,0-0-0If new planning tech is hired no external expense, If this is not completed there will 79-610-61-00-5320 MASTER PLAN 0 0!need to be an addition of$10,000 for Master Plan update. 79-610-62-00-5405 PARK CONTRACTUAL 12,000 15,000 additional parks-spot weeding,fertilizing,sealcoating 79-610-62-00-5408 MAINTENANCE-EQUIPMENT 6,000 9,000 additional equipment as a result of new employees in 04-05 79-610-62-00-5417 MAINTENANCE PARKS 32,000 32,0001- _ _____ __- I- -__ ­ ­­----______ ----------- 79-610-62-00-5421 'WEARING APPAREL 8,000 8,000{ 79-610-62-00-5434 RENTAL-EQUIPMENT 1,700 1,7001 79-610-62-00-5438 CELLULAR TELEPHONE r 5,750 5,750 79-610-62-00-5440 LAND DEVELOPER 10,000 10,000, 79-610-62-00-5445 LEGAL EXPENSES 10,000 10,000' PARKS EXPENSES - 79-610-64-00-5602 PROFESSIONAL GROWTH/SUBSCRPT 4,500 4,500 79-610-64-00-5605 TRAVEL EXPENSE 3,000 3,000' 79-610-64-00-5612 CONTINUING EDUCATION 4,200 4,_2_0Z 79-610-65-00-5802 OFFICE SUPPLIES 1,500 3,000 79-610-65-00-5804 OPERATING SUPPLIES 25,000 25,000 79-610-65-00-5812 GASOLINE- - - 3,500- 3,5001_ 79-610-65-00-5815 3,000 3,000] 79-610-65-00-5824 CHRISTMAS DECORATIONS 7,000 7,000 DRAFT 1/30/06 Page 24 of 30 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2005-2006 PARKS & RECREATION- Proposed Proposed Revised 2005-2006 2005-2006 ACCOUNT NUMBER DESCRIPTION Budget Budget COMMENTS 79-610-65-00-5825 PUBLIC DECORATION 3,000 79-610-72-00-6500 IMRF PARTICIPANTS 26,702 25,071 ---------- 79-610-72-00-6501 SOCIAL SECURITY/MEDICARE 28,537L 27,005 79-610-75-00-7003 -OFFICE EQUIPMENT 27,000 0 79-610-75-00-7701 1 FLOWERS/TREES 6,§66 F 6,500___ 79-610-78-00-9005 1MERIT 7,359 0 moved to employee salary line item TOTAL EXPENSES: PARKS j 601,927 586,2126 RECREATION EXPENSES 79-650-50-00-5107 'EMPLOYEE SALARIES 260,696 255,600 decrease due to Exec Director vacancy 79-650-50-00-5150 S ALARIES-INSTRUCTOR CONTRACTUAL 88,000 98,000 full year of preschool instructors costs and additional programs offered ----------- 79-650-50-00-5155 SALARIES-RECORDING SECRETARY 1 5,000 5,000' 79-650-50-00-5108 CONCESSION STAFF 3,600 3,600 79-650-62-00-5408 MAINTENANCE SUPPLIES 8,000 79-650-62-00-5409 MAINTENANCE-VEHICLES 1,200 1s2001 - ______ __ I-- -- -___----------- - - 79-650-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 5,500 5,500 -2,0-0-01 79-650-62-00-5426 YOUTH SERVICES GRANT EXPENSES 2,000 _______-I- - I------------ � ___ - _____ - - [ -__- -- ---------- 79-650-62-00-5437 TELEPHONE/INTERNET 1,400 1,400 79-650-62-00-5438 -C-E-LLULAR.TELEPHONE 4,500 41500[------ 79-650-62-00-5445 PORTABLE TOILETS 4,500 4,500 1 79--6-5-0--6-2----O--O---5-663------(PUBLISHING/ADVERTISING 25,200 RECREATION EXPENSES 79-650-62-00-5605 BOOKS/PUBLICATIONS 750 7501 ---------- ---------- 79-650-62-00-5606 BEECHER DEPOSIT REFUND 4,000 4,00011 79-650-64-00-5600 DUES 2,700 2,7001 79-650-64-00-5602 PROFESSIONAL GROWTH/SUBSCRIPT 7,500 7,5001 ,500 79-650-64-00-5605 TRAVEL EXPENSE 2 2,500 i 1-- 79-650-65-00-5802 OFFICE SUPPLIES 6, 00 6,600 , 79-650-65-00-5803 PROGRAM EXPENSE-S - ------ 39,185 39,185�_ 79-650-65-00-5804 OPERATING SUPPLIES 4,000 4, 79-650-65-00-5805 IRECREATION EQUIPMENT 3,500 3,500 i 79-650-65-00-5808 LPOSTAGE&SHIPPING 6,500 6,500 79-650-65-00-5812 GASOLINE 1,6001 1,600 79-650-65-00-5826 MILEAGE 750 1,200 Increase in distance for various offices/program locations 79-650-65-00-5827 GOLF OUTING EXPENSES 20,000 21,945 true cost 79-650-65-00-5828 CONCESSIONS 5,000 9,734 true cost includes point of sale items 79-650-65-00-5840 SCHOLARSHIPS 1,500 2,000 impacted by Fox Valley Special Rec 79-650-65-00-5841 PROGRAM REFUND 6,500 13,000 --------------- 79-650-72-00-6500 IMRF PARTICIPANTS 21,754 20,806 15RAFT 1/30/06 Page 25 of 30 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2005-2006 PARKS & RECREATION Pro posed Proposed I Revised 2005-2006 2005-2006 ACCOUNT NUMBER DESCRIPTION liBudget Budget lCOMMENTS 79-650-72-00-6501 "SOCIAL SECURITY/MEDICARE CARE 1 24,132 23,2411L 0-7002 COMPUTER EQUIP&SOFTWARE 6,500 79-650-78-00-9005 MERIT 6,549 0 decreased transfer amount TOTAL EXPENSES: RECREATION 581,115' F TOTAL FUND REVENUES 1,183,042 1,179,4861 TOTAL FUND EXPENSES 1,183,042 183,042 1,179,4861 FUND SURPLUS (DEFICIT) 0 DRAFT 1/30/06 Page 26 of 30 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2005-2006 LIBRAR Y (Proposed Proposed 'Revised ACCOUNT 2005-2006 2005-2006 NUMBER DESCRIPTION Budget Budget COMMENTS Approved budget through Library Board/currently working with Library-will update when REVENUES available ---------- 82-000-40-00-3999 CARRY OVER 75,91611 82-000-40-00-3996 CARRY OVER- BOOK DEV FEES 57,736 82-000-40-00-3997 CARRY OVER- BLDG DEV FEES 31,695 82-000-40-00-3998 CARRY OVER-MEMORIALS 5,362 1 82-000-40-00-4015 iTRANSFER FROM GENERAL FUND 31,500 28,000 transfer for Library SS&IMRF costs- true up of costs 82-000-40-00-4000 REAL ESTATE TAXES 370,500 i 82-000-42-00-4211 DEVELOPMENT FEES-BUILDING 121 875 82-000-40-00-4010 PERSONAL PROPERTY TAX 2,500 82-000-42-00-4215 DEVELOPMENT FEES-BOOKS 1 21,8 751 82-000-42-00-4260 COPY FEES f 900i 8,2-000-4:2-00-4261__j LIBRARY- -SUBSCRIPTION- -- CARDS, 8,0001 82-000-42-00-4286 RENTAL INCOME 1,000 82-000-43-00-4330_ !LIBRARY FINES 3,000 82-000-44-00-4432 SALE OF BOOKS 500! 82-000-44-00-4450 MEMORIALS 1 000 GRANTS 1,000 82-000-45-00-4560 !;LIBRARY PER CAPITA GRANT 7,700 ------------ 82-000-46-00-4600 INVESTMENT INCOME 82-000-46-00-4601 IINVESTMENT INCOME-BLDG 1,250 TOTAL REVENUES: 844,809 ---------- EXPENSES 82-000-50-00-5107 SALARIES-EMPLOYEES 300,000, 82-000-50-00-5203 GROUP HEALTH INSURANCE --,,5,-000 82-000-50-00-5204 GROUP LIFE INSURANCE 1,500 82-000-50-00-5205 DENTAL&VISION ASSISTANCE ____41000__ 82-000-61-00-5322 !BONDING 2,000 82-000-611-00-8-32-3- ATTORNEY 2 000 ------ ——----------- 82-000-62-00-_______ 5401 CONTRACT SERVICES 3,000 82-000-62 00-5407 'MAINTENANCE-BLDG/JANITORIAL 5,000) -6- - EQUIPMENT 3,_oW _82-000-62: OZ 0 MAINTENANCE--OF-FICE EQU MENT_ 82-000-62-00-5412 MAINTENANCE-OFFICE 500 82-000-62-00-5435 ELECTRICITY 2,500 82-000-62-00-5436 TELEPHONE- - -------- 1,70.01 82-000-64-00-5603 S UBSCRIPTIONS 4,000 .82-000-64-00-5604 TRAINING&CONFERENCES 1,500 DRAFT 1/30/06 Page 27 of 30 ------ UNITED CITY OF YORKVILLE --------- _PROPOSED REVISED BUDGET ------------ FY 2005-20061_________­_____ LIBRARY 'Proposed ,Proposed Revised ACCOUNT 2005-2006 2005-2006 NUMBER DESCRIPTION Bud et Budget COMMENTS 82-000-64-00-5607 PUBLIC RELATIONS 11,000 82-000-64-00-5616 EMPLOYEE RECOGNITION 82-000-65-00-5800 CONTINGENCIES 14,616A'_ Includes 3%of operating expenses per policy 82-000-65-00-5806 LIBRARY SUPPLIES 8,000 82-000-65-00-5807 CUSTODIAL SUPPLIES 6V000 82-000-65-00-5802 !OFFICE SUPPLIES 3,000, 82-000-65-00-5808 POSTAGE&SHIPPING 1,000 82-000-65-00-5810 PUBLISHING &ADVERTISING 1,000 82-000-65-00-5826 MILEAGE 10001 6:606- 82-000-65-00-5832 !VIDEOS 82-000-65-00-5833 !ALARM MONITORING 1,0001 82-000-65-00-5834 'LIBRARY PROGRAMMING 9,500! 82-000-65-00-583-5 �LIBRARY,BOARD-EXPENSES, - - 5-001------- 82 00 36 -658' j 9,000 -_0__ _ 5-00- BOOKS-ADULT 82-000-65-00-5 BOOKS-JUVENILE 9,000 82-000-65-00-58 }BOOKS-AUDIO- -- 6,66-6 — 82-000-65-00-58 9 BOOKS-REFERENCE 9000 82-000-65-00-5840 BOOKS-DEVELOPMENT FEE 179,611 82-000-65-00-584 MEMORIALS/GIFTS_ 6,362 82-000-65-00-5842 BLDG-DEVELOPMENT FEES 1153,570 82-000-72-00-6500 IMRF PARTICIPANTS 9,000 82-000-72-00-6501 SOCIAL SECURITY/MEDICARE 22,950 82-000-75-00-7003 AUTOMATION 8,000 TOTAL EXPENSES: 844,809 TOTAL FUND REVENUES 844,809 ----------- TOTAL FUND EXPENSES 844,809! .FUND SURPLUS DEFICIT 01 DRAFT 1/30/06 Page 28 of 30 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2005-2006 FOX INDUSTRIAL lProposed Proposed Revised ACCOUNT 12005-2006 2005-2006 NUMBER DESCRIPTION Budget Budget COMMENTS REVENUES 85-000-40-00-3999 CARRY OVER BALANCE 0 11,817 Per Audit 85-000-40-00-4090 TIF REVENUES 34,000 71,000 Actual 85-000-46-00-4600 INVESTMENT INCOME 1,000 2,800 ............ 85-000-49-00-4905 TRANSFER FROM MFTFUND 42,664 31,190 TOTAL REVENUES: 77,664! 116,807 A EXPENSES 85-000-66-00-6021 FOX IND BOND-PRINCIPAL PMT 55,000 55,000 Due 12/1/2012 85-000-66-00-6022 JFOX IND BOND-INT PAYMENT 22,4501 22,450 Due 12/1/2012 FOX IND NON MIFT PAYMENT 0 FOX INDUSTRIAL EXPENSES 0 5,068 85-000-78-00-9007 ADMINISTRATION FEES 214 1,107 85-000-78-00-9010 RESERVE-7-FUTURE BOND PYMT 0 32,949 TOTAL EXPENSES: 116,807 TOTAL FUND REVENUES .116,8071 TO"TAL FUND EXPENSES 77,6641 116,807j FUND SURPLUS pmcm Oi 0� DRAFT 1/30/06 Page 29 of 30 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2005-2006 COUNTRYSIDE TIF Proposed Proposed Revised ACCOUNT 2005-2006 2005-2006 NUMBER DESCRIPTION Budget Budget COMMENTS REVENUES 87-000-40-00-3999 CARRY OVER BALANCE 0 3,456,521 Bond issued FY 04/05________ 87-000-40-00-4090 TIF REVENUES 0 01 1 87-000-46-00-4600 INVESTMENT INCOME 0 100`000 TOTAL REVENUES: 01 3556,521 EXPENSES —_----- ---- 87-000-66-00-6021 FOX IND BOND-PRINCIPAL PMT 0' 0 87-000-66-00-6022 FOX IND BOND-INT PAYMENT O� 101,595 87-000-78-00-9007 ADMINISTRATION FEES _ 0 87-000-78-00-9010 RESERVE 0 3,454,926, TOTAL EXPENSES. 0 3,556,521 .......... -------------- ----------- --------- TOTAL FUND REVENUES 0 3,556,521 –-------- TOTAL FUND EXPENSES 0 3,556,521 ,FUND SURPLUS DEFICIT 0 01 Page 30 of 30 DRAFT 1/30/06 Reviewed By: Legal ❑ City Council Finance _ EST. :.,1836 \ _ Engineer ❑ Agenda Item Tracking Number City Administrator El ADM 2006-0� �/ `�O Consultant El 7� E ,�♦, ❑ City Council Agenda Item Summary Memo Title: Library Payout Schedule City Council/COW/Committee Agenda Date: Administration 2/02/06 Synopsis: The following is a copy of Henry Brother's estimated payout schedule for the Library Expansion Project. The Treasurer and I will look at various investment options, however at this time,the interest rate on the money market is reasonably good for the short term the funds will be held. Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: None Submitted by: Traci Pleckham Finance Name Department Agenda Item Notes: Jan 18 2006 10: 05RM HENRY HROS 17084305897 p. 1 Yorkville Public Library Tenative Payout Schedule Month Payment 05-Se 05-oct 05-Nov 786 305.00 05-Dec 104 948.74 06-Jan 102 890.70 06-Feb 595 629.10 06-Mar 528,386.20 06-Apr 852 872.00 06-may 1589,467.80 06-Jun 1 ,128,704.50 06-Jul 598,133.30 08-Aug 468,955.15 08-Sep 232 276.51 08-Oct 375,565.00 Allowances 147,165.00 TOTAL 7,511,300.00 Reviewed By: ❑ City Council J .K► Legal Finance ❑ yeas Engineer El-�� Agenda Item Tracking Number City Administrator ❑ t' Consultant ❑ LE City Council Agenda Item Summary Memo Title: Fiscal Year 2006/2007 Budget Requests City Council/COW/Committee Agenda Date: Synopsis: As the FY 2006/2007 Budget process is beginning Department Heads are rquesting input from the elected officials for any proposed budget requests consideration Input is needed toniobt in order to move forward wit t e budget process. (Additional Council input will also be received as a result of the Goal Settine Session.l Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Traci Pleckham Finance Name Department Agenda Item Notes: Ill e)�t�,, CIP Reviewed By: Jam♦ �-� Legal ❑ City Council Finance ❑ Esr `1836 Engineer ❑ City Administrator ❑ Agenda Item Tracking Number O� ® 2006-11 O•. Consultant ❑ ALE" City Council Agenda Item Summary Memo Title: Health Insurance Information City Council/COW/Committee Agenda Date: Admin 2/2/06 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Traci Pleckham Finance Name Department Agenda Item Notes: � wood ssve��tes Insurance& Financial Services 11,000 E Rt 34, Suite 1, Plano, IL 60545 (630)552-3447 Fax(630)552-3850 January 11, 2006 United City of Yorkville 800 Game Farm Road Yorkville, IL 60560 Attention: Traci Pleckham RE: Health Insurance Dear Traci: Based upon our conversation last week I wanted to give you a brief overview of the course of action that I will peruse for the City to obtain additional quotes for the group health insurance policy. The city's policy comes up for renewal with Blue Cross Blue Shield on May 1, which means we will have renewal rates around March 1. In the meantime I will prepare the census to send to a number of carriers all who will provide the same coverage options as you currently have. Final rates from these companies can only be obtained once they have the renewal rates so at the earliest we would be looking at March 15 to have some comparison. One thing that is working against us in this process will be the city's high loss ratio, 144%last year with a similar loss ratio expected this year. It will make some companies shy away from quoting; however I do anticipate we can secure 2 or 3 comparative rates. As we proceed I will be in touch to keep you informed on what companies we are quoting and what information I may need. If you have any questions regarding this please feel free to give me a call. Sincerely, Joe Roberts N81? Reviewed By: Legal El City Council Finance ❑ EST. `Baas Engineer ❑ C City Administrator El Item Tracking Number ..:3 Consultant ❑ 2006-12 City Council Agenda Item Summary Memo Title: Minute Taking Policy City Council/COW/Committee Agenda Date: Admin 2/2/06 Synopsis: At the January 5, 2006 Administration Committee meeting, it was requested that the Minute Taking Policy be looked at. Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Traci Pleckham Finance Name Department Agenda Item Notes: Based on staff research, there has been no indication of an approved minute taking policy, other than in reference to a salary increase. ♦,��D C/r j, Reviewed By: J� �•c� Legal ❑ City Council Finance ❑ EST. -� ' lass Engineer ❑ �� City Administrator ❑ Agenda Item Tracking Number 71ft `24 Consultant ❑ Al ��'�'�" 11J ♦ ❑ �LE `Vv City Council Agenda Item Summary Memo Title: Hiring Policy City Council/COW/Committee Agenda Date: Admin—Feb. 2°d, 2006 Synopsis: Policy discussion questions for a hiring policy Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Discussion Submitted by: John Crois Administration Name Department Agenda Item Notes: United City of Yorkville .r County Seat of Kendall County 800 Game Farm Road EST. Z 1$36 Yorkville, Illinois, 60560 Telephone: 630-553-4350 Fax: 630-553-7575 Website: www.yorkville.il.us <CE DATE: January 31,2006 TO: Members of the Administration Committee FROM: John H. Crois,Interim City Administrator SUBJECT: Hiring Policy In establishing a uniform hiring policy,the Committee needs to address several questions. 1. What level or classification of employees would be covered by the policy? I would recommend the City Administrator and Department Heads. 2. Do you want a search firm to conduct the recruitment? 3. How should the search firm be selected? You should do an RFP. Will the proposals be reviewed by a committee with a recommendation to COW or will the review be done totally at COW? 4. Who will the search firm present its candidates to and who will make the decision on whom to interview? 5. Will a committee conduct the interviews or will a separate group be appointed? 6. Will the Mayor interview the finalist or will he be part of the interview in number 5? 7. Any offer of employment should be conditional upon the successful completion of a background check. If you have any questions or need additional information,please contact me. e I Reviewed By: J2 �� Legal El City Council Finance ■ EST: '� 1836 Engineer ❑ � � � City Administrator � Agenda Item Tracking Number t "20 ❑ ��� � C Consultant A L L E ``'�? Community Development City Council Agenda Item Summary Memo Title: Municipal Building Impact Fee City Council/COW/Committee Agenda Date: Administration Committee—Feb. 2, 2006_ Synopsis: Presentation of Master Facilities Plan building cost estimates in relation to our municipal building impact fee Council Action Previously Taken: Date of Action: N/A Action Taken: Item Number: Type of Vote Required: N/A Council Action Requested: Discussion on policy options, move forward to COW for general discussion Submitted by: Bart Olson Administration Name Department Agenda Item Notes: Within the packet for this item, is a memo explaining policy options and a chart with the supporting data and individual scenarios. Discussion should be emphasized within the context of the importance of producing a timely decision, as we have several annexation agreements currently in the draft stage. C!T United City of Yorkville Memo 800 Game Farm Road Esr sss Yorkville, Illinois 60560 Telephone: 630-553-4350 o " I & P Fax: 630-553-7575 jCE !V`' Date: January 31, 2006 To: Administration Committee From: Bart Olson, Administrative Intern CC: John Crois, City Administrator Subject: Municipal building impact fee One of the last steps of the Municipal Facilities Master Plan was to get a cost estimate for municipal buildings that would serve the City through a population of 60,000. With these cost estimates,the City can begin to look at revising the municipal building impact fee so that builders and new residents are appropriately paying their fair share of growth. The City currently is estimating that the population at the time of completion of plan was 12,000 and since we are at full capacity for all city buildings,the cost of the buildings should be extrapolated against the 48,000 new residents (assuming 2.65 residents per unit). However, executing such a concept has its problems. The first issue regarding such a program is to identify the timeline of building construction. I have laid out seven different timelines in the following documents. For all scenarios, a 5% inflation is assumed from year to year. For scenarios 1 —4,the description title should be sufficient to explain the scenario. Scenarios 3 and 4 are predicated from the preliminary discussions that a Public Works and Police Facility are the more pressing needs of the group of buildings. Scenario 5 is based on the timeline presented in Scenarios 3 and 4 and the possibility that the City would enter into a public-private partnership for a pool facility, and therefore wouldn't need to fund an Aquatic Center. Scenario 6 is based on the timeline presented in Scenarios 3 and 4 and attributes 80% of the cost of the Community Center to the new residents; an argument could be made that the City does not currently own a Senior,Aquatic or Community Center, and thus the cost of the buildings should be spread over the entire population as a whole. In Scenario 6, some sort of revenue (be it bond or general revenue stream)would have to be identified to make up the remaining 20%of the cost of the Community Center. Scenario 7 is based on the timeline presented in Scenarios 3 and 4, but removes the entire cost of the Community, Senior and Aquatic Centers. In this scenario,the City could have entered into a public-private partnership for all three buildings, or may have chose to go to a referendum to fund the three buildings. At this point, discussion should focus on identifying or altering one of the scenarios listed on the chart. The last page of the packet contains a breakdown of approved units within the City. Using the population projection and residential development key, I identified how many units have been locked into the current municipal building fee of$150. It is currently estimated that the City has 7,769 units approved and NOT BUILT that are locked into the $150. These "fee locks"are for a variety of lengths, and it can be safely assumed that some percentage of the units will be built after the lock expires (thus allowing the fee to be raised). Of the developments that have some form of entitlement(annexed or through preliminary plan), approximately 2,853 units MAY be subject to a fee raise—although this is based on early research, and staff would have to individually research each annexation agreement to verify the possibility. Of the remaining developments,there are approximately 7,631 units that are early enough in the approval process that we could negotiate the higher fees into the annexation/development agreement. Extrapolating these figures out, assuming that: 1) all 7,769 entitled units at$150 are not subject to the new fee (worst case scenario) 2) all 2,853 entitled units currently at$150 could be raised to the new fee 3) all 7,631 not-entitled units could be raised to the new fee ...using Scenario 5 and a new impact fee of$5,649 ($102 million total project cost divided by 48,000 new residents)—we come to a total project deficit of$42 million. In order to completely fund Scenario 5, we would have to be able to capture roughly 7,400 of the 7,769 at the higher impact fee. Even with"short fee locks" (5 years or so) and recently added clauses into annexation agreements stipulating we can raise the fee as long as we apply the fee equally to all developments in the city, we are likely to fall significantly short. Possible discussion items are as follows: 1) identifying an alternate stream of revenue to make up the shortfall 2) bonding the amount of the project deficit 3) eliminating buildings 4) only calculating the impact fee for certain buildings(i.e. calculating the impact fee through 2010, and identifying that the fee would be reviewed at that time to fund any buildings built after that) 5) per the population projection,with all developments that have received entitlement(and are currently at$150), a population of 42,000 is guaranteed—68,000 with all total developments; the 26,000 residents who are in the not-entitled developments could be burdened with the entire cost of the project(impact fee of roughly$10,500) Building Name I S% Ft. Cost/SF 1 20051 2007 2010 2015 2020 SCENARIO 1 All built at same time, Community Center has Senior and Aquatic Center City Hall 28,265 $180 $5,876,294 $6,478,614 $7,499,805 $9,571,863 $12,216,392 Police Facility 54,623 $200 $12,617,913 $13,911,249 $16,104,010 $20,553,251 $26,231,735 Police Outpost N 729 $170 $143,139 $157,811 $182,686 $233,159 $297,576 Police Outpost S 729 $170 $143,139 $157,811 $182,686 $233,159 $297,576 Community Center, A 198,044 $200 $45,748,164 $50,437,351 $58,387,538 $74,518,939 $95,107,147 Public Works/Parks 1 73,295 $165 $13,968,195 $15,399,935 $17,827,349 $22,752,717 $29,038,873 Public Works/Parks 2 73,295 $165 $13,968,195 $15,399,935 $17,827,349 $22,752,717 $29,038,873 TOTAL $92,465,039 $101,942,705 $118,011,423 $150,615,805 $192,228,172 IMPACT FEE $5,105 $5,628 $6,515 $8,315 $10,613 SCENARIO 2 All built at same time, Community Center, Senior Center,and 2 Aquatic Centers City Hall 28,265 $180 $5,876,294 $6,478,614 $7,499,805 $9,571,863 $12,216,392 Police Facility 54,623 $200 $12,617,913 $13,911,249 $16,104,010 $20,553,251 $26,231,735 Police Outpost N 729 $170 $143,139 $157,811 $182,686 $233,159 $297,576 Police Outpost S 729 $170 $143,139 $157,811 $182,686 $233,159 $297,576 Community Center B 123,269 $200 $28,475,139 $31,393,841 $36,342,295 $46,383,001 $59,197,769 Senior Center 22,650 $185 $4,839,739 $5,335,812 $6,176,869 $7,883,424 _$10,061,469 Aquatic Center N 55,855 $165 $10,644,567 $11,735,635 $13,585,464 $17,338,877 $22,129,290 Aquatic Center S 55,855 $165 $10,644,567 $11,735,635 $13,585,464 $17,338,877 $22,129,290 Public Works/Parks 1 73,295 $165 $13,968,195 $15,399,935 $17,827,349 $22,752,717 $29,038,873 Public Works/Parks 2 73,295 $165 $13,968,195 $15,399,935 $17,827,349 $22,752,717 $29,038,873 TOTAL $101,320,887 $111,706,278 $129,313,977 $165,041,0451 $210,638,843 IMPACT FEE $5,594 $6,167 $7,139 $9,112 $11,629 Page 1 of 4 Building Name IS g. Ft. Cost/SF 1 2005 zi 2020 _ SCENARIO 3 Police and Public Works built in 2007; City Hall, Community Center A, and Police Outpost N built in 2010; Public Works 2 and Police Outpost S built in 2015 City Hall 28,265 $180 $0 $0 $7,499,805 $0 $0 Police Facility 54,623 $200 $0 $13,911,249 $0 $0 $0 Police Outpost N 729 $170 $0 $0 $182,686 $0 $0 Police Outpost S 729 $170 $0 $0 $0 $233,159 $0 Community Center, A 198,044 $200 $0 $0 $58,387,538 $0 $0 Public Works/Parks 1 73,295 $165 $0 $15,399,935 $0 $0 $0 Public Works/Parks 2 73,295 $165 $0 $0 _ $0 $22,752,717 _ $0 TOTAL $118,367,089 IMPACT FEE $6,535 L L SCENARIO 4 Same as Scenario 3, except Community Center B, Senior Center, and Aquatic Center N is built in 2010,Aquatic Center S is built in 2020 _ City Hall 28,265 $180 $0 $0 $7,499,805 $0 $0 Police Facility 54,623 $200 $0 $13,911,249 $0 $0 $0 Police Outpost N 729 $170 $0 $0 $182,686 $0 $0 Police Outpost S 729 $170 $0 $0 $0 $233,159 $0 Community Center B 123,269 $200 $0 $0 $36,342,295 $0 $0 Senior Center 22,650 $185 $0 $0 $6,176,869 $0 $0 Aquatic Center N 55,855 $165 $0 $0 $13,585,464 $0 $0 Aquatic Center S 55,855 $165 $0 $0 $0 $0 $22,129,290 Public Works/Parks 1 73,295 $165 $0 $15,399,935 $0 $0 $0 Public Works/Parks 2 73,295 $165 $0 $0 $0 $22,752,717 $0 TOTAL _$138,213,469 IMPACT FEE $7,631 Page 2 of 4 Building Name I Sg• Ft. Cost/SF 2005 2007 2010 2015 2020 SCENARIO 5 Same as Scenario 4,Aquatic Centers not built at all City Hall 28,265 $180 $0 $0 $7,499,805 $0 $0 Police Facility 54,623 $200 $0 $13,911,249 $0 $0 $0 Police Outpost N 729 $170 $0 $0 $182,686 $0 $0 Police Outpost S 729 $170 $0 $0 $0 $233,159 $0 Community Center B 123,269 $200 $0 $0 $36,342,295 $0 $0 Senior Center 22,650 $185 $0 $0 $6,176,869 $0 $0 Public Works/Parks 1 73,295 $165 $0 $15,399,935 $0 $0 $0 Public Works/Parks 2 73,295 $165 $0 $0 $0 $22,752,717 $0 TOTAL $102,498,715 IMPACT FEE $5,659 SCENARIO 6 Same as Scenario 5, but attributing only 80%of cost of Community Center and Senior Center to new residents City Hall 28,265 $180 $0 $0 $7,499,805 so[- 0 $0 Police Facility 54,623 $200 $0 $13,911,249 _ $0 $0 $0 Police Outpost N 729 $170 $0 $0 $182,686 $0 $0 Police Outpost S 729 $170 $0 $0 $0 $233,159 $0 Community Center B 123,269 $200 $0 $0 $29,073,836 $0 $0 Senior Center 22,650 $185 $0 $0 $4,941,495 $0 $0 Public Works/Parks 1 73,295 $165 $0 $15,399,935 $0 $0 $0 Public Works/Parks 2 73,295 $165 $0 $0 _ $0 $22,752,717 $0 TOTAL $93,994,882 IMPACT FEE $5,189 Page 3 of 4 Building Name Sg• Ft. Cost/SF 2005 fO:0:7:1 010 1 0 51 2020 SCENARIO 7 Same as Scenario 5, but assuming entire cost of Community Center and Senior Center to be financed by entire community City Hall 28,265 $180 $0 $0 $7,499,805 $0 $0 Police Facility 54,623 $200 $0 $13,911,249 $0 $0 $0 Police Outpost N 729 $170 $0 $0 $182,686 $0 $0 Police Outpost S 729 $170 $0 $0 $0 $233,159 $0 Public Works/Parks 1 73,295 $165 $0 $15,399,935 $0 $0 $0 Public Works/Parks 2 73,295 $165 $0 $0 $0 $22,752,717 $0 TOTAL $59,979,551 IMPACT FEE $3,311 Page 4 of 4 Units PE Units and PE NOT locked in and current 2,853 8,698 Units and PE locked in 7,769 22,107 Units and PE NOT locked in and future 7,631 25,883 Best Case Scenario 2,853 Units @ $5,659(Scenario 5) 16,145,127 7,769 Units @ $150 1,165,350 7,631 Units @ $5,659 43,183,829 TOTAL 60,494,306 Minus Cost of Projects ($102,498,715) -42,004,409 (FUNDING DEFICIT) N� 11l© C4 Reviewed By: Legal ❑ City Council Finance ❑ ESE Engineer ❑ Agenda Item Tracking Number City Administrator ❑ 'p .. O Consultant ❑ A City Council Agenda Item Summary Memo Title: .A06 DESCF-A F6r1QA4. - C_VKM ur►t TY paimatitpta Ddr- City Council/COW/Committee Agenda Date: Synopsis: -3��t� ilk- �,t?TtcKS CHIT`t' agrdLIO&W 'Dg&-,t rcM. &I 5 G�i�t�47� Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: �ea�1S �tu.Eer C-r:;M MUK rry Name Department Agenda Item Notes: ♦'�tio ��r o United City of Yorkville Memo 800 Game Farm Road a, s Yorkville, Illinois 60560 Telephone: 630-553-8545 O Fax: 630-553-3436 LLE �Vti Date: January 30,2006 To: Administration Committee From: Travis Miller jV i1 CC: John Crois Subject: Community Development Department—Job Descriptions Attached are three job descriptions I've prepared for your review and comment. Currently there are two positions funded in the current FY 2005/2006 budget and I will be requesting the third position as part of the FY 2006/2007 budget. The Senior Planner will primarily be responsible for current plan review, however, will also be assigned various long-range planning tasks. The City Park and Urban Designer will primarily work with the Park Board and staff on developing plans, renderings, and construction documents for park related projects. This position will also be assigned to produce plans, renderings and construction documents for downtown redevelopment projects as necessary including streetscaping,facade improvements, etc. The Geographic Information System (GIS)Coordinator/Analyst will work directly with the Engineering and Public Work Departments as well as Community Development to ensure our digital mapping system is comprehensive and accurate. This will enable all decision makers to be informed with accurate, comprehensive infrastructure data. The technology will also allow for 3D analysis of development projects and quickly analyze and forecast development trends and impacts. I look forward to discussing these draft descriptions with you in more detail on the 2"d Thanks, Travis ��o cir� N /o a DRAFT 2106 EST. _ 1836 UNITED CITY OF YORKVMU Senior Planner—Job Description <CE Department: Community Development Reports to: Community Development Director Status: Full Time, Non-exempt Pay Classification: Senior Support Staff Position Description Overview The Senior Planner will assist the Community Development Director with all phases of planning; including comprehensive planning, subdivision and site plan review, and plan implementation processes. Primary responsibilities will include reviewing development projects, assisting in the preparation of comprehensive, corridor, downtown, redevelopment, and other planning documents and reports. Essential Job Functions 1. Perform routine application reviews and analysis for residential and commercial developments including site plans, subdivision plans and landscape plans to ensure code compliance with established ordinances, development regulations and policies. 2. Conduct special studies and prepare plans, reports,presentations and proposals as directed by the Community Development Director. 3. Assist applicants, City departments, and any applicable boards, commissions and committees in the support, development and implementation of Community Development activities. 4. Provide technical assistance and professional advice to clients, developers, engineers, architects and the public. 5. Assist the Community Development Director with managerial tasks that involve establishing priorities. 6. Research code amendments for updates and revisions. 7. Research and prepare data for reports and recommendations. Position Requirements 1. Knowledge of principles and practices of city planning as they pertain to urban development and zoning. DRAFT 2/06 2. Excellent written and public speaking skills are required for presentation to boards, commissions, the City Council and citizen groups. Minimum and Preferred Experience and Education 1. Bachelor's degree in urban planning, urban design, architecture, or related field; three (3) years of experience; or , an equivalent combination of education and experience sufficient to perform the essential duties of the job as those listed above. 2. Must possess a valid Class D driver's license. The duties listed above are intended only as illustrations of the various types of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar,related or a logical assignment of the position. The job description does not constitute an employment agreement between the employer and employee and is subject to change by the employer as the needs of the employer and requirements of the job change. Ne,4-1 b. o����p cirr DRAFT 2106 Esr. �c UNITED CITY OF YORKVII..LE City Park and Urban Designer—Job Description <l.E 1V Department: Community Development Reports to: Community Development Director Status: Full Time,Non-exempt Pay Classification: Senior Support Staff Position Description Overview The City Park and Urban Designer is responsible for coordination of all city park design, city park redevelopment and downtown urban redevelopment projects under the direction of the Community Development Director. This includes producing park design,master and facility plans, conducting public outreach workshops, and building relationships with local agencies, stakeholders, and allied organizations in the recreation, alternative transportation,health and conservation fields. Essential Job Functions 1. Serve as designer and project manager for the Parks and Recreation Department on assigned municipal projects involving parks, facilities,natural areas, greenways, landscaping and trails. 2. Prepare streetscape, corridor, downtown, neighborhood, waterfront,park,plaza, and revitalization planning concepts, construction documents, and reports. 3. Conduct special studies and prepare plans, reports,presentations and proposals as directed by the Community Development Director. 4. Perform routine application reviews and analysis for all landscape plans,to ensure code compliance with established ordinances, development regulations and policies. 5. Participate in the development of standards relating to park planning, trail planning and natural resource programs. 6. Provide technical assistance and professional advice to developers, engineers, architects and the public. 7. Represent the Community Development Department at all regular Park Board meetings. 8. Maintain and implement the City's Park and Recreation Master Plan. 9. Perform other duties and functions as directed by the Community Development Director. DRAFT 2/06 Position Requirements 1. Knowledge of aspects involved in natural resource planning, including natural systems, relevant federal and state law, and best management practices. 2. Excellent written and oral communication skills. 3. Highly organized and able to prioritize job assignments. 4. Ability to develop high quality graphics and reports. Minimum and Preferred Experience and Education 1. Bachelor's degree in landscape architecture, urban planning, urban design, parks/recreation, or related field;three (3) years of experience; or, an equivalent combination of education and experience sufficient to perform the essential duties of the job as those listed above. 2. Must possess a valid Class D driver's license. The duties listed above are intended only as illustrations of the various types of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar, related or a logical assignment of the position. The job description does not constitute an employment agreement between the employer and employee and is subject to change by the employer as the needs of the employer and requirements of the job change. cir` K 6 DRAFT 2/06 EST. IBM ' . y UNITED CITY OF YORKVILLE <tE I�� GIS Coordinator—Job Description Department: Community Development Reports to: Community Development Director Status: Full Time,Non-exempt Pay Classification: Senior Support Staff Position Description Overview The GIS Coordinator is responsible for the coordination and expansion of design, development, analysis, implementation, and maintenance of the United City of Yorkville Geographic Information System. This includes coordinating related activities with City departments, consulting with department staff in the use and functions of GIS, and determining quality control standards for the datasets. Essential Job Functions 1. Plan and coordinate the administration and maintenance scheduling of all layers defined in the geographical information system in conjunction with all other land based systems and/or files in the City. 2. Perform digitizing and drafting as required. 3. Develop and document GIS procedures. 4. Provide consultation to senior staff on the use of advanced spatial analysis techniques and technologies in data dissemination. 5. Assist with the City's Geographic Information System implementation and maintenance activities, including resource planning,policy and procedures development, departmental needs assessments, systems analysis, organization requirements, and education/training coordination. 6. Conduct and coordinate activities using both Autodesk and ESRI ArcView 9 software; including spatial analysis, data modeling, development and management of databases, digital mapping, and GIS data standards and quality assurance procedures. 7. Manage GIS data development and/or conversion projects including providing technical expertise, obtaining milestones, and meeting deadlines. 8. Expand attribute fields of current datasets 9. Assign attribute data from other datasets to GIS format (i.e. AutoCAD). DRAFT 2/06 10. Create/update utility atlas books for PW Department trucks. 11. Handle compliance with City's GASB 34 requirements. 12. Conduct special studies or develop additional information for senior staff as directed. 13. General mapping preparation and management. Position Requirements 1. Experience with ARCView 9.x software. 2. Excellent written and oral communication skills. 3. Highly organized and able to prioritize job assignments. Minimum and Preferred Experience and Education 1. Bachelor's degree in planning; three (3) years of experience; or, an equivalent combination of education and experience sufficient to perform the essential duties of the job as those listed above. 2. Must possess a valid Class D driver's license. The duties listed above are intended only as illustrations of the various types of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar, related or a logical assignment of the position. The job description does not constitute an employment agreement between the employer and employee and is subject to change by the employer as the needs of the employer and requirements of the job change. UNITED CITY OF YORKVILLE SALARY SCHEDULES ApprovedII123 104; Revised 6128105 FY 2004-2005 Min. Max. City Administrator $76,004 $107,023 Finance Director $59,175 $83,325 Community Development Director $72,000 $95,000 "Approved 6/28/05 City Engineer $59,760 $84,150 City Park and Urban Designer $41,000 $57,000 ••Proposed Updated 2/02/06 Senior Engineering Tech $41,000 $57,000 Engineering Tech $37,260 $53,524 Reception ist/Assi stant $20,800 $27,967 Administrative Support Staff $32,085 $43,675 General Support Staff $26,910 $42,820 Chief of Police $65,078 $86,916 Police Office Supervisor $34,096 $48,172 Police Lieutenant $53,652 $72,200 Police Sergeant $46,506 $62,088 Police Officers "(Per Contract $39,627 $48,942 "Updated 5/1/05 Director of Public Works* $62,972 $82,204 "Revised 1/25/05 Foreman Street/Water/Park $45,550 $59,989 Maintenance Worker 1 $29,900 $41,749 Maintenance Worker II $34,155 $47,101 Operator $39,330 $52,454 Janitorial Tool Shop $23,805 $34,256 Executive Director- Parks & Rec $61,300 $86,319 Superintendent of Recreation $42,106 $59,291 Recreation Supervisor $32,085 $51,383 The salary range is subject to review and can be modified annually by Mayor & City Council. Annual Longevity Stipends will be made to all employees based upon the following After 6 years but less than 9 years $750 After 9 years but less than 14 years $1,000 After 14 years but less than 20 years $1,250 After 20 years but less than 25 years $1,500 After 25 years $2,000 Educational Stipends will be paid for education in their related field over that required for entry level of that position as follows: Associate Degree or 60 credit hours 2% Bachelor's Degree 2% Master's Degree 2% This will be applicable only to 1 degree level beyond that necessary for entry level of that position except that all are eligible to earn up to the Bachelor Degree Level as outlined above (one time salary adjustment) CIPy Reviewed By: J2 O� Legal ❑ City Council Finance ❑ M. � 1836 Engineer ❑ y City Administrator El Agenda Item Tracking Number �O Consultant ❑ SCE w City Council Agenda Item Summary Memo Title: Community Development Department—New Job Descriptions City Council/COW/Committee Agenda Date: February 2, 2006 Synopsis: 4 new job descriptions including 2 for current fiscal year and 2 proposed for 2006- 2007 fiscal year. City Park Designer and Urban Designer are included in current year's budget and Senior Planner and GIS Coordinator are proposed for FY 2006- 2007 Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Approval of Park Designer and Urban Designer Job Descriptions Submitted by: Travis Miller Community Development Name Department Agenda Item Notes: D cl o United City of Yorkville Memo 800 Game Farm Road '036 Yorkville, Illinois 60560 Telephone: 630-553-8545 Fax: 630-553-3436 <LE � ,v Date: February 2, 2006 To: Administration Committee From: Travis Millerjj CC: John Crois Subject: Community Development Department—Job Descriptions Attached are four job descriptions I've prepared for your review and comment. Currently there are two positions funded in the current FY 2005/2006 budget and I will be requesting the third and fourth positions as part of the FY 2006/2007 budget. Current Budget The City Park Designer will primarily work with the Park Board and staff on developing plans, renderings, and construction documents for park related projects. The Urban Designer will be assigned to produce plans, renderings and construction documents for downtown redevelopment projects as necessary including streetscaping,fagade improvements, etc. and will assist with preparation of the Comprehensive Plan District/Sector plans. Proposed in FY 2007-2007 The Senior Planner will primarily be responsible for current plan review, however, will also be assigned various long-range planning tasks. The Geographic Information System (GIS)Coordinator/Analyst will work directly with the Engineering and Public Work Departments as well as Community Development to ensure our digital mapping system is comprehensive and accurate. This will enable all decision makers to be informed with accurate, comprehensive infrastructure data. The technology will also allow for 3D analysis of development projects and quickly analyze and forecast development trends and impacts. I look forward to discussing these draft descriptions with you in more detail on the 2`d Thanks, Travis United City of Yorkville Community Development Planning Department Schematic Mayor/Council City Administrator Parks Engineering Public Works Board Department Department' Director Park Designer Senior Planner G I S Coordinator r------------------------------- i r----------------------------� Intern Draftsperson Intern Technician �- ----------------------------- -- -------------------------- Urban Designer /06 UNITED CITY OF YORKVILLE SALARY SCHEDULES Approvedl l/23/04;Revised 6128105 FY 2004-2005 Min. Max. City Administrator $76,004 $107,023 Finance Director $59,175 $83,325 Community Development Director $72,000 $95,000 **Approved 6/28/05 City Engineer $59,760 $84,150 City Park Designer $41,000 $57,000 -Proposed Updated 2102106 Urban Designer $41,000 $57,000 ~Proposed Updated 2/02106 Senior Engineering Tech $41,000 $57,000 Engineering Tech $37,260 $53,524 Reception ist/Assistant $20,800 $27,967 Administrative Support Staff $32,085 $43,675 General Support Staff $26,910 $42,820 Chief of Police $65,078 $86,916 Police Office Supervisor $34,096 $48,172 Police Lieutenant $53,652 $72,200 Police Sergeant $46,506 $62,088 Police Officers **(Per Contract $39,627 $48,942 **Updated 5/1/05 Director of Public Works* $62,972 $82,204 *Revised 1/25/05 Foreman Street/Water/Park $45,550 $597989 Maintenance Worker 1 $29,900 $41,749 Maintenance Worker II $34,155 $47,101 Operator $39,330 $52,454 Janitorial Tool Shop $23,805 $34,256 Executive Director- Parks & Rec $61,300 $86,319 Superintendent of Recreation $42,106 $59,291 Recreation Supervisor $32,085 $51,383 The salary range is subject to review and can be modified annually by Mayor& City Council. Annual Longevity Stipends will be made to all employees based upon the following After 6 years but less than 9 years $750 After 9 years but less than 14 years $1,000 After 14 years but less than 20 years $1,250 After 20 years but less than 25 years $1,500 After 25 years $2,000 Educational Stipends will be paid for education in their related field over that required for entry level of that position as follows: Associate Degree or 60 credit hours 2% Bachelor's Degree 2% Master's Degree 2% This will be applicable only to 1 degree level beyond that necessary for entry level of that position except that all are eligible to earn up to the Bachelor Degree Level as outlined above (one time salary adjustment) DRAFT 2/06 UNTIED CITY OF YORKVILLE x.20 Senior Planner—Job Description <CE Department: Community Development Reports to: Community Development Director Status: Full Time,Non-exempt Position Description Overview The Senior Planner will assist the Community Development Director with all phases of planning; including comprehensive planning, subdivision and site plan review, and plan implementation processes. Primary responsibilities will include reviewing development projects, assisting in the preparation of comprehensive, corridor, downtown, redevelopment, and other planning documents and reports. Essential Job Functions 1. Perform routine application reviews and analysis for residential and commercial developments including site plans, subdivision plans and landscaping plans to ensure code compliance with established ordinances, development regulations and policies. 2. Conduct special studies and prepare plans, reports, presentations and proposals as directed by the Community Development Director. 3. Assist applicants, City departments, and any applicable boards, commissions and committees in the support, development and implementation of Community Development activities. 4. Provide technical assistance and professional advice to clients, developers, engineers, architects and the public. 5. Assist the Community Development Director with managerial tasks that involve establishing priorities. 6. Research code amendments for updates and revisions. 7. Research and prepare data for reports and recommendations. Position Requirements 1. Knowledge of principles and practices of city planning as they pertain to urban development and zoning. DRAFT 2/06 2. Excellent written and public speaking skills are required for presentation to boards, commissions, the City Council and citizen groups. Minimum and Preferred Experience'and Education 1. Bachelor's degree in urban planning, urban design, architecture, or related field; three (3) years of experience; or, an equivalent combination of education and experience sufficient to perform the essential duties of the job as those listed above. 2. Must possess a valid Class D driver's license. The duties listed above are intended only as illustrations of the various types of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar,related or a logical.assignment of the position. The job description does not constitute an employment agreement between the employer and employee and is subject to change by the employer as the needs of the employer and requirements of the job change. DRAFT 2106 y UNITED CITY OF YORKVE= City Park Designer—Job Description <CE ��'�• Department: Community Development Reports to: Community Development Director Status: Full Time,Non-exempt Pay Classification: City Park Designer Position Description Overview The City Park Designer is responsible for coordination of all city park design under the direction of the Community Development Director. This includes design of new parks and redevelopment of current city parks. Responsibilities also include building relationships with local agencies, stakeholders, and allied organizations in the recreation, alternative transportation, health and conservation fields. Essential Job Functions 1. Serve as project designer for the Parks and Recreation Department on assigned municipal projects involving parks, facilities,natural areas, greenways, landscaping and trails. 2. Prepare planning concepts, construction documents, and reports for mini parks, neighborhood park/playgrounds, community parks, sports complexes, and waterfront parks. 3. Conduct special studies and prepare plans, reports, presentations and proposals as directed by the Community Development Director. 4. Participate in the development of standards relating to park planning,trail planning and natural resource programs. 5. Provide technical assistance and professional advice to developers, engineers, architects and the public related to existing and future park and recreation facilities. 6. Attend all regular Park Board meetings. 7. Maintain and implement the City's Park and Recreation Master Plan. 8. Perform other duties and functions as directed by the Community Development Director. DRAFT 2/06 Position Requirements 1. Knowledge of aspects involved in natural resource planning, including natural systems, relevant federal and state law, and best management practices. 2. Proficient with AutoCAD 2000 or better software. 3. Excellent written and oral communication skills. 4. Highly organized and able to prioritize job assignments. 5. Ability to develop high quality graphics and reports. Minimum and Preferred Experience and Education 1. Bachelor's degree in landscape architecture,urban planning, urban design, parks/recreation, or related field;three (3) years of experience; or, an equivalent combination of education and experience sufficient to perform the essential duties of the job as those listed above. 2. Must possess a valid Class D driver's license. The duties listed above are intended only as illustrations of the various types of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar,related or a logical assignment of the position. The job description does not constitute an employment agreement between the employer and employee and is subject to change by the employer as the needs of the employer and requirements of the job change. DRAFT 2106 EST. 1836 ,T UNITED CITY OF YORKV LJLE 'Fy<<E . Urban Designer—Job Description Department: Community Development Reports to: Community Development Director Status: Full Time,Non-exempt Pay Classification: Urban Designer Position Description Overview The Urban Designer is responsible for coordination of all downtown urban redevelopment projects under the direction of the Community Development Director. Responsibilities also include preparing land use studies and reviews, district/sector plan studies, and urban design evaluations. Essential Job Functions 1. Prepare streetscape, corridor, downtown,neighborhood, waterfront,park,plaza, and revitalization planning concepts, construction documents, and reports. 2. Providing expertise on urban design issues for district/sector plans and small area planning projects, design studies, development proposals, site specific land use and design studies and other types of land use studies. 3. Preparing urban design analyses including preparation of architectural massing and figure-ground studies, concept plans, illustrative plans, landscape designs and urban design guidelines for district/sector plans and other special studies. 4. Conduct special studies and prepare plans, reports, presentations and proposals as directed by the Community Development Director. 5. Perform routine application reviews and analysis for all site and landscape plans, to ensure code compliance with established ordinances, development regulations and policies. 6. Provide technical assistance and professional advice to developers, engineers, architects and the public. 7. Perform other duties and functions as directed by the Community Development Director. DRAFT 2/06 Position Requirements 1. Proficient with AutoCAD 2000 or better software. 2. Experience with ArcView 9 software. 3. Excellent written and oral communication skills. 4. Highly organized and able to prioritize job assignments. 5. Ability to develop high quality graphics and reports. Minimum and Preferred Experience and Education 1. Bachelor's degree in landscape architecture,urban planning, urban design or related field;three(3) years of experience; or, an equivalent combination of education and experience sufficient to perform the essential duties of the job as those listed above. 2. Must possess a valid Class D driver's license. The duties listed above are intended only as illustrations of the various types of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar, related or a logical assignment of the position. The job description does not constitute an employment agreement between the employer and employee and is subject to change by the employer as the needs of the employer and requirements of the job change. CI P, DRAFT 2106 .I UNITED CITY OF YORKVILLE .� GIS Coordinator—Job Description <CE Department: Community Development Reports to: Community Development Director Status: Full Time,Non-exempt Position Description Overview The GIS Coordinator is responsible for the coordination and expansion of design, development, analysis, implementation, and maintenance of the United City of Yorkville Geographic Information System. This includes coordinating related activities with City departments, consulting with department staff in the use and functions of GIS, and determining quality control standards for the datasets. Essential Job Functions 1. Plan and coordinate the administration and maintenance scheduling of all layers defined in the geographical information system in conjunction with all other land based systems and/or files in the City. 2. Perform digitizing and drafting as required. 3. Develop and document GIS procedures. 4. Provide consultation to senior staff on the use of advanced spatial analysis techniques and technologies in data dissemination. 5. Assist with the City's Geographic Information System implementation and maintenance activities, including resource planning,policy and procedures development, departmental needs assessments, systems analysis, organization requirements, and education/training coordination. 6. Conduct and coordinate activities using both Autodesk and ESRI ArcView 9 software; including spatial analysis, data modeling, development and management of databases, digital mapping, and GIS data standards and quality assurance procedures. 7. Manage GIS data development and/or conversion projects including providing technical expertise, obtaining milestones, and meeting deadlines. 8. Expand attribute fields of current datasets 9. Assign attribute data from other datasets to GIS format(i.e. AutoCAD). DRAFT 2/06 10. Create/update utility atlas books for use by the City's Public Works Department. 11. Handle compliance with City's GASB 34 requirements. 12. Conduct special studies or develop additional information for senior staff as directed. 13. General mapping preparation and management. Position Requirements 1. Proficient with ArcView 9 software. 2. Experience with AutoCAD 2000 or better. 3. Excellent written and oral communication skills. 4. Highly organized and able to prioritize job assignments. Minimum and Preferred Experience and Education 1. Bachelor's degree in planning;three (3)years of experience; or, an equivalent combination of education and experience sufficient to perform the essential duties of the job as those listed above. 2. Must possess a valid Class D driver's license. The duties listed above are intended only as illustrations of the various types of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar, related or a logical assignment of the position. The job description does not constitute an employment agreement between the employer and employee and is subject to change by the employer as the needs of the employer and requirements of the job change. `,QED Clry Reviewed By: J� O� Legal ❑ City Council Esr Finance Engineer ❑ t ' City Administrator ❑ Agenda Item Tracking Number �� °� �O Consultant ❑ '� cC�(G ' 7 <<E �w City Council Agenda Item Summary Memo Title: $2,000,000 Series 2005C Annual Abatement Ordinance City Council/COW/Committee Agenda Date: Administration 2/02/06 Synopsis: This is the annual abatement ordinance for the Water Improvement Alternate Revenue Bond(EEI Contracts B.2 & B.3) approved 8/23/05. Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Because the filing requirement for this ordinance is 2/28/06, staff is requesting this item move to the 2/7/06 COW meeting. Submitted by: Traci Pleckham Finance Name Department Agenda Item Notes: ORDINANCE No. ORDINANCE abating the tax hereto levied for the year 2005 to pay the principal of and interest on $2,000,000 General Obligation Bonds (Alternate Revenue Source), Series 2005C, of the United City of Yorkville, Kendall County,Illinois. WHEREAS the City Council (the "Corporate Authorities") of the United City of Yorkville, Kendall County, Illinois (the "City"), by Ordinance Number 2005- , adopted on the 23rd day of August, 2005 (the "Ordinance"), did provide for the issue of $2,000,000 General Obligation Bonds (Alternate Revenue Source), Series 2005C (the "Bonds"), and the levy of a direct annual tax sufficient to pay the principal of and interest on the Bonds; and WHEREAS the City will have the Pledged Revenues (as defined in the Ordinance) available for the purpose of paying the principal of and interest on the Bonds during the next succeeding bond year•, and WHEREAS it is necessary and in the best interests of a the City that the tax heretofore levied for the year 2005 to pay the principal of and interest on the Bonds be abated; Now, THEREFORE, Be It Ordained by the City Council of the United City of Yorkville, Kendall County,Illinois, as follows: Section 1. Abatement of Tax. The tax heretofore levied for the year 2005 in the Ordinance is hereby abated in its entirety. Section 2. Filing of Ordinance. Forthwith upon the adoption of this ordinance, the City Clerk shall file a certified copy hereof with the County Clerk of The County of Kendall, Illinois, and it shall be the duty of said County Clerk to abate said tax levied for the year 2005 in accordance with the provisions hereof. Section 3. Effective Date. This Ordinance shall be in full force and effect upon its passage and approval as provided by law. ADOPTED by the Corporate Authorities on the 14th day of February, 2006, pursuant to a roll call vote as follows: PAUL JAMES MARTY MUNNS JASON LESLIE WANDA OHARE VALERIE BURD ROSE SPEARS DEAN WOLFER JOSEPH BESCo APPRovED by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, the 14th day of February, 2006. MAYOR PASSED by the City Council of the United City of Yorkville, Kendall County, Illinois, the 14'h day of February , 2006. Attest: CITY CLERK -2- STATE OF ILLINOIS ) ) SS COUNTY OF KENDALL ) FILING CERTIFICATE I, the undersigned, do hereby certify that I am the duly qualified and acting County Clerk of The County of Kendall, Illinois, and as such official I do further certify that on the day of February, 2006, there was filed in my office a duly certified copy of Ordinance No. entitled: ORDINANCE abating the tax hereto levied for the year 2005 to pay the principal of and interest on $2,000,000 General Obligation Bonds (Alternate Revenue Source), Series 2005C, of the United City of Yorkville, Kendall County, Illinois. (the "Ordinance") duly adopted by the City Council of the United City of Yorkville, Kendall County, Illinois (the "City"), on the 14`h day of February, 2006, and that the same has been deposited in the official files and records of my office. I do further certify that the taxes heretofore levied for the year 2004 for the payment of the City's $2,000,000 General Obligation Bonds (Alternate Revenue Source), Series 2005C, as described in the Ordinance will be abated in their entirety as provided in the Ordinance. IN WITNESS WBEREoF I hereunto affix my official signature and the seal of said County this day of 2006 County Clerk [SEAL] `,QED C/ry Reviewed By: Legal ❑ City Council Finance im EST 1 Engineer ❑ ��- Agenda Item Tracking Number City Administrator ❑ 20 Consultant F-1 lLE w City Council Agenda Item Summary Memo Title: $11,300,000 Series 2005D Annual Abatement Ordinance City Council/COW/Committee Agenda Date: Administration 2/02/06 Synopsis: This is the annual abatement ordinance for the Rob Roy Creek Interceptor Alternate Revenue Bond approved 10/25/05. Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Because the filing requirements for this ordinance is 2/28/06, staff is requesting this item move to the 2/7/06 COW meeting, Submitted by: Traci Pleckham Finance Name Department Agenda Item Notes: ORDINANCE NO. ORDINANCE abating the tax hereto levied for the year 2005 to pay the principal of and interest on $11,300,000 General Obligation Bonds (Alternate Revenue Source), Series 2005D, of the United City of Yorkville, Kendall County,Illinois. WBEREAS the City Council (the "Corporate Authorities") of the United City of Yorkville, Kendall County, Illinois (the "City"), by Ordinance Number 2005- 88, adopted on the 25th day of October, 2005 (the "Ordinance"), did provide for the issue of$11,300,000 General Obligation Bonds (Alternate Revenue Source), Series 2005D(the "Bonds"), and the levy of a direct annual tax sufficient to pay the principal of and interest on the Bonds; and WBEREAS the City will have the Pledged Revenues (as defined in the Ordinance) available for the purpose of paying the principal of and interest on the Bonds during the next succeeding bond year; and WHEREAS it is necessary and in the best interests of a the City that the tax heretofore levied for the year 2005 to pay the principal of and interest on the Bonds be abated; Now, TBEREFORE, Be It Ordained by the City Council of the United City of Yorkville, Kendall County, Illinois, as follows: Section 1. Abatement of Tax. The tax heretofore levied for the year 2005 in the Ordinance is hereby abated in its entirety. Section 2. Filing of Ordinance. Forthwith upon the adoption of this ordinance, the City Clerk shall file a certified copy hereof with the County Clerk of The County of Kendall, Illinois, and it shall be the duty of said County Clerk to abate said tax levied for the year 2005 in accordance with the provisions hereof. Section 3. Effective Date. This Ordinance shall be in full force and effect upon its passage and approval as provided by law. ADOPTED by the Corporate Authorities on the 14`h day of February, 2006, pursuant to a roll call vote as follows: PAUL JAMES MARTY MUNNS JASON LESLIE WANDA OHARE VALERIE BURD ROSE SPEARS DEAN WOLFER JOSEPH BESCO APPRovED by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, the 14th day of February, 2006. MAYOR PASSED by the City Council of the United City of Yorkville, Kendall County, Illinois, the 14`h day of February , 2006. Attest: CITY CLERK -2- STATE OF ILLINOIS ) ) SS COUNTY OF KENDALL ) FILING CERTIFICATE I, the undersigned, do hereby certify that I am the duly qualified and acting County Clerk of The County of Kendall, Illinois, and as such official I do further certify that on the day of February, 2006, there was filed in my office a duly certified copy of Ordinance No. entitled: ORDINANCE abating the tax hereto levied for the year 2005 to pay the principal of and interest on $11,300,000 General Obligation Bonds (Alternate Revenue Source), Series 2005D, of the United City of Yorkville, Kendall County, Illinois. (the "Ordinance") duly adopted by the City Council of the United City of Yorkville, Kendall County, Illinois (the "City"), on the 10 day of February, 2006, and that the same has been deposited in the official files and records of my office. I do further certify that the taxes heretofore levied for the year 2004 for the payment of the City's $11,300,000 General Obligation Bonds (Alternate Revenue Source), Series 2005D, as described in the Ordinance will be abated in their entirety as provided in the Ordinance. IN WITNESS WBEEREOF I hereunto affix my official signature and the seal of said County this day of 2006 County Clerk [SEAL] Reviewed By: Legal ❑ City Council ESE � � .. ...1836 Finance ❑ Engineer 9%e 1,6 City Administrator El Agenda Item Tracking Number Consultant ❑ 14 biro d c)M° 19 <CbE���,v�� ❑ City Council Agenda Item Summary Memo Title: Plan Review Fees City Council/COW/Committee Agenda Date: Administration Committee 2/2/06 Synopsis: This is a proposal to establish a plan review surcharge fee for developments whose engineering plan reviews are performed by consultant. Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Majority Council Action Requested: Approval Submitted by: Joe Wywrot Engineering Name Department Agenda Item Notes: United City of Yorkville Memo 800 Game Farm Road 1836 Yorkville, Illinois 60560 Telephone: 630-553-8545 o Fax: 630-553-3436 Date: January 31, 2006 To: Traci Pleckham, Finance Director From: Joe Wywrot, City Engineer CC: John Crois, Interim City Administrator John Wyeth, City Attorney Travis Miller, Community Development Director Subject: Plan Review Fees Plan review for new developments is performed either in-house or farmed out to Engineering Enterprises. For in-house reviews, we have historically charged a plan review fee of 1.25%as authorized by Resolution 2002-27. This fee reimburses the city not only for the cost of time spent performing the review, but also for coordination, meetings, etc. performed by various city personnel. For reviews performed by EEI, however, we have historically only charged the developer EEI's actual time spent. The city absorbs the cost of city staff for time spent related to those developments. Attached find a spreadsheet detailing the cost of reviews for several developments. There is a fairly wide spread of review costs, ranging from 0.40%to 1.55%of the approved engineer's estimate of cost. Some of the reasons for the wide range are the quality of the plans submitted, development issues that require meetings to work out, etc. The average review cost,however, is around 0.88%. This cost does not include the cost of city personnel. In order to recoup the cost of city staff for developments whose plan reviews are farmed out, I recommend that we add a plan review surcharge fee of 0.35%. This surcharge would keep the average plan review costs just below 1.25%. The surcharge would be based on the approved engineer's estimate of cost for the development, and would be due prior to recording the final plat of subdivision. Please review and let me know if you feel any revisions should be made. Please place this item on the next Administration Committee meeting for review. 31-Jan-06 Plan Review Fees Actual Review Cost Review Cost Proposed City Surcharge plus Development Infrastructure Cost Landscape Cost ED Fees Schoppe Fees Total Fees Percentage at 1.25% City Surcharge Hourly Fees Autumn Creek Unit 1 $7,970,000 $691,000 $33,000 $1,485 $34,485 0.40% $108,263 $30,313.50 $64,798.50 Bristol Bay Units 1-7 $14,867,000 $981,000 $74,000 $14,241 $88,241 0.56% $198,100 $55,468.00 $143,709.00 Caledonia Unit $3,755,000 $126,000 $55,000 $5,014 $60,014 1.55% $48,513 $13,583.50 $73,597.50 Grand Reserve Units 1-9 $15,233,000 $1,607,000 $179,000 $52,295 $231,295 1.37% $210,500 $58,940.00 $290,235.00 Whispering Meadows Units $6,214,000 $817,000 $40,000 $5,300 $45,300 0.64% $87,888 $24,608.50 $69,908.50 Totals $48,039,000 $4,222,000 $381,000 $78,335 $459,335 0.88% $653,263 $182,914 $642,249 Proposed City Surcharge=0.35% Surcharge to reimburse for time spent by city staff for meetings,coordination,administration,etc.during plan review process. C►r� United City of Yorkville Abitl dcoo -,q�c a2 County Seat of Kendall County 800 Game Farm Road EST. 1 Yorkville, Illinois, 60560 Telephone: 630-553-4350 Fax: 630-553-7575 Website: www.yorkville.il.us <LE 1�• Date: February 2,2006 To: Members of the Administrative Committee From: John H. Crois,Interim City Administrator Subject: Amending the Administrative Assistant Job Description An e-mail was received from Alderwoman Burd this morning requesting that amending the job description of the Administrative Assistant be discussed. The job description would be amended so that the administrative assistant would report directly to the City Council and add that this person keeps track of alderman's calendars and notifies aldermen of extra meetings they are supposed to attend or specific items affecting their wards,and acts as a liaison with the city administrator to ensure that they are aware of issues affecting their wards. Since the Administrative Committee agenda was being amended,I took the liberty to add this item to the agenda. COUNTY OF KENDALL ) )ss STATE OF ILLINOIS ) RESOLUTION NO. 2005- A RESOLUTION CREATING THE POSITION OF ADMINISTRATIVE ASSISTANT IN THE UNITED CITY OF YORKVILLE, ]KENDALL COUNTY, ILLINOIS WHEREAS, the Mayor and City Council of UNITED CITY OF YORKVILLE, after careful consideration,have found and deemed it necessary for the benefit of the UNITED CITY OF YORKVILLE to create the position of Administrative Assistant; and WHEREAS,the job position for Administrative Assistant will have the duties and responsibilities as set forth in the attached job description; and NOW,THEREFORE, BE IT RESOLVED BY THE MAYOR AND CITY COUNCIL OF THE UNITED CITY OF YORKVILLE THAT THE POSITION OF ADMINISTRATIVE ASSISTANT IS HEREBY CREATED. Said position will be directed by and report directly to the City Administrator. The job description for said position is attached hereto and is made part hereof as Exhibit"A". The hiring of a person to fill the said position should be subject to all probationary rules and regulations as set out in the current Employee Manual. This resolution shall become effective upon its passage. PAUL JAMES MARTY MUNNS JASON LESLIE WANDA OHARE VALERIE BURR ROSE SPEARS DEAN WOLFER JOSEPH BESCO Page 1 of 2 APPROVED by me, as Mayor of the United City of Yorkville,Kendall County, Illinois, this day o —` , A.D. 2005. MAYOR PASSED by the City Council of the United City of Yorkville, Kendall County, Illinois, this of A.D. 2005. CITY CLERK Prepared by: John Justin Wyeth City Attorney United City of Yorkville 800 Game Farm Road Yorkville, Illinois 60560 630-553-8570 Page 2 of 2 Passed 6-28-2005 UNITED CITY OF YORKVILLE ADMINISTRATIVE ASSISTANT—JOB DESCRIPTION Department: Administration Reports to: City Administrator Status: Full Time; Non-exempt Salary Classification: Administrative Support Staff Position Description Overview This position provides assistance to the Administrative staff relating to following and implementing policy and procedures particularly related to land development and City Council documentation and proceedings. This position will be supervised by the City Administrator in the performance of all general administrative office duties and act as an administrative liaison to the City Council. This position works closely with the elected officials, City Attorney, department heads, and citizens to properly facilitate information, especially for public meetings. The City Administrator will complete the performance evaluation,with input from City Council. Essential Job Functions 1. Type and distribute City agendas and calendar for public meetings as well as miscellaneous correspondence including distribution of minutes as needed. 2. Responsible for recording City documents at the Kendall County Recorder's Office including, water liens,bond documents, SSA easements, annexation agreements, etc. and other documents as they are approved by City Council. 3. Prepare and distribute all packets for public meetings. 4. Prepare, issue and file paperwork for tobacco, amusement, and liquor license renewals and freedom of information requests. 5. Gather and distribute Plan Commission material packets for the Commission, City Council, City Attorney, and City Planner. 6. Update and maintain various lists of Aldermen, City Council, committee members and other board members. 7. Serve as a liaison to City Council for general information and queries,particularly for agenda items and City projects. 8. Prepare and distribute Plan Council agendas and/or minutes. 9. Work closely with the City Administrator to assure smooth and organized daily administrative functions. Assist with organizing and maintaining City records. Assist with the publishing of legal notices,public hearings, and media releases. Passed 6-28-2005 10. Coordinate and facilitate all schedule requests for petitions for annexations, zoning, preliminary and final platting, and any other request pertaining to Plan Commission and/or City Council meetings regarding development. 11. Other duties as directed by the City Administrator. Requirements 1. Independent writing and proofreading skills. 2. Ability to communicate clearly and concisely in both oral and written format. 3. Ability to establish and maintain a good working relationship with City Officials, employees and the residential and business community. 4. Ability to understand and follow general instructions and carry out policy decisions and/or recommendations quickly and accurately. 5. Ability to operate a variety of office equipment including a typewriter, word processor, personal computer, facsimile machine, and transcribing equipment rapidly and accurately. 6. Ability to type a minimum of sixty(60)words per minute. 7. Ability to maintain strict confidentiality. Experience and Education 1. Minimum of three(3) years administrative experience,preferably in a government setting. 2. High School Degree supplemented by courses in typing and business subjects,preferably with some college level courses in business related subjects. 3. Experience and education that provides the required knowledge, skills, and abilities is preferred. 4. Must successfully complete a background investigation. The duties listed above are intended only as an illustration of the various types of tasks that may be required. The omission of specific statements of duties does note exclude them from the position if the work is similar,related, or a logical assignment to the position. This job description does not constitute an employment agreement between the employer and the employee, and is subject to modification by the employer as the needs of the employer and/or agency change, or requirements of the position change.