Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Ordinance 2007-038
NDALL STATE OF ILLINOIS ) ) ss APR 3 0 2007 COUNTY OF KENDALL ) � �iunty Coo. KondA ✓J'� n'� ORDINANCE NO. 2007- - 4 , % ORDINANCE APPROVING THE 2007 -2008 FISCAL BUDGET FOR THE UNITED CITY OF YORKVILLE WHEREAS, the Mayor and City Council of the UNITED CITY OF YORKVILLE have duly held all Public Hearings, allowed public input, and through its committee system has duly considered formation of a budget for the 2007 -2008 Fiscal Year; and WHEREAS, a tentative budget was duly announced and available for examination at the City offices of the UNITED CITY OF YORKVILLE; and WHEREAS, the Mayor and City Council of the UNITED CITY OF YORKVILLE deem it in the best interest of the City for the orderly operation thereof to pass and approve the tentative 2007 -2008 Fiscal Year Budget being submitted on April 24, 2007 at its regular City Council Meeting: NOW, THEREFORE, upon Motion duly made, seconded and approved by a majority of those so voting, the 2007 -2008 Budget totaling including the amounts of $�5 3`ll� - 1 General Fund, $ 6 b Motor Fuel Tax Fund, $ gtF1, C C�C�_ Municipal Building, $ 3� , lam_ Police Equipment Capital Fund, GCVO Public Works Equipment Capital Fund, $ Parks & Recreation Equipment Capital, $� k �$C� j '( Sewer Improvement & Expansion, $le � �6��1,5�� Water Improvement & Expansion, Water Operations, Debt Service Fund, $\ I $ - Ux , , Sewer Maintenance, $ \ �'3�s' _ Land Cash, $ S000 -> Land Acquisition, $ 1030. Parks & Recreation Library, $_G-% Fox Industrial, and .b"1S ,boo Countryside TIF is hereby adopted for the 2007 -2008 Fiscal Year, as presented. i ADOPTED this 24 day of April, 2007, pursuant to a roll call vote as follows: JAMES BOCK JOSEPH BESCO VALERIE BURD v PAUL JAMES GARY GOLINSKI MARTY MUNNS ROSE SPEARS JASON LESLIE h APPROVED by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this 24 Day of April, A.D. 2007. MAYOR PASSED by the City Council of the United City of Yorkville, Kendall County, Illinois this 24 day of April, A.D. 2007. ATTEST: CITY CLERK Prepared by: John Justin Wyeth City Attorney United City of Yorkville 800 Game Farm Road Yorkville, IL 60560 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL GENERALFUND ACCOUNT 2005 -2006 2006 -2007 % 2007 -2008 NUMBER DESCRIPTION Actual Budget Change Budget GENERAL FUND REVENUES 01- 000 -40 -00 -3999 RESERVE FUND BALANCE - 372,849 -66% 125,000 1 CARRY OVER FY 05/06 417,177 LIBRARY BOND PAYBACK 160,000 EMPLOY CONTRIB HEALTH REIMB 18,000 AMUSEMENT TAX 135,000 2 CIB / CD'S IN BANK 104,000 3 01- 000 -40 -00 -3996 ROAD CONTRIBUTION FEE 971,098 1,500,000 -20% 1,200,000 4 01- 000 -40 -00 -3998 ROAD FUNDING - MPI 40 1,600,000 -38% 1,000,000 5 01- 000 -40 -00 -3997 IN -TOWN ROAD PROGRAM FUND 3,783,562 2,070,000 24% 2,575,000 6 01- 000 -40 -00 -4000 REAL ESTATE TAXES 1,387,085 1,571,133 15% 1,810,490 7 01- 000 -40 -00 -4001 TOWN ROAD /BRIDGE TAX 101,791 105,000 19% 125,000 8 01- 000 -40 -00 -4002 FOX HILL LEVY REVENUE - 18,000 0% 18,000 9 01- 000 -40 -00 -4010 PERSONAL PROPERTY TAX 13,337 10,000 0% 10,000 01- 000 -40 -00 -4020 STATE INCOME TAX 516,423 885,000 10% 974,748 10 01- 000 -40 -00 -4030 MUNICIPAL SALES TAX 1,958,806 2,845,000 10% 3,120,000 01- 000 -40 -00 -4032 STATE USE TAX 89,252 137,000 5% 144,532 11 01- 000 -40 -00 -4040 MUNICIPAL UTILITY TAX 388,592 375,000 13% 425,000 01- 000 -40 -00 -4041 UTILITY TAX - NICOR 159,111 250,000 20% 300,000 01- 000 -40 -00 -4042 UTILITY TAX - CABLE TV 83,248 90,000 43% 129,144 01- 000 -40 -00 -4043 UTILITY TAX - TELEPHONE 335,574 425,000 0% 425,000 01- 000 -40 -00 -4050 HOTEL TAX 18,894 20,000 0% 20,000 01- 000 -40 -00 -4060 TRAFFIC SIGNAL REVENUE - 5,000 0% 5,000 01- 000 -41 -00 -4100 LIQUOR LICENSE 24,366 26,000 0% 26,000 01- 000 -41 -00 -4101 OTHER LICENSES 2,700 4,500 -33% 3,000 01- 000 -41 -00 -4110 BUILDING PERMITS 1,363,781 1,550,000 0% 1,550,000 01- 000 -42 -00 -4205 FILING FEES 7,023 25,000 -20% 20,000 01- 000 -42 -00 -4206 GARBAGE SURCHARGE 208,490 227,648 138% 540,756 01- 000 -42 -00 -4208 COLLECTION FEE - YBSD 31,881 35,000 0% 35,000 01- 000 -42 -00 -4210 DEVELOPMENT FEES 1,227,206 1,475,000 0% 1,475,000 01- 000 -42 -00 -4211 ENGINEERING CAPITAL FEE 52,200 52,000 15% 60,000 12 01- 000 -43 -00 -4310 TRAFFIC FINES 76,534 75,000 7% 80,000 01- 000 -43 -00 -4315 REIMBURSE POLICE TRAINING 11,805 11,805 78% 21,000 01- 000 -43 -00 -4320 ORDINANCE FEES 2,670 2,500 0% 2,500 01- 000 -44 -00 -4401 DARE DONATIONS 125 1,250 0% 1,250 01- 000 -44 -00 -4402 ROB ROY CREEK HYDRAULIC STUDY 22,700 10,000 0% 10,000 13 RAYMOND SEWER OUTFALL - 0 100% 1,300,000 01- 000 -44 -00 -4411 REIMB- POLICE PROTECTION 2,477 3,000 10% 3,300 01- 000 -44 -00 -4490 MISCELLANEOUS INCOME 11,798 10,000 50% 15,000 01- 000 -45 -00 -4525 GRANTS 49,675 30,000 -100% - 01- 000 -45 -00 -4505 COPS GRANT - VESTS - 2,500 20% 3,000 01- 000 -45 -00 -4511 POLICE - STATE TOBACCO GRANT - 1,250 20% 1,500 01- 000 -46 -00 -4600 INVESTMENT INCOME 117,808 75,000 0% 75,000 TRANSFER FROM MUNICIPAL BLDG 182,500 14 01- 000 -49 -00 -4935 TRANSFER FROM LAND CASH - 16,000 0% 16,000 15 01- 000 -49 -00 -4915 TRANSFER FROM WATER OPS 200,000 250,000 6% 265,000 01- 000 -49 -00 -4920 TRANSFER FROM SEWER MAINT. 70,000 70,000 0% 70,000 01- 000 -49 -00 -4925 TRANSFER FROM SAN. SEWER IMP 150,000 150,000 0% 150,000 01- 000 -49 -00 -4930 TRANSFER FROM WATER IMPROVE. 200,000 200,000 0% 200,000 TOTAL REVENUES: GENERAL 13,640,052 16,583,575 17% 19,346,897 Page 1 of 39 4/27/2007 UNITED CITY OF YORKVILLE FY 07108 BUDGET FINAL { GENERALFUND ACCOUNT 2005 -2006 2006 -2007 % 2007 -2008 NUMBER DESCRIPTION Actual Budget Change Budget GENERAL FUND REVENUES - COMMENTS 1 New World Software 2 5% of 1500 daily passes per day for 100 days per year @$20 per pass 3 Moved to Contingencies 4 750 Permits @ $2,000 5 Grande Reserve Perimeter Roads - funded by developer $2,000 per permit in Grande Reserve Only 6 Project is completed 7 Increase in new EAV 8 This is a property tax that is County -Wide / Township wide 9 SSA 2 yr assessment 10 $87 per person X 11,204 POPULATION 11 $12.90 per person X 11,204 POPULATION 12 $100 per every builing permit collected 13 We anticipate receiving those funds this year 14 $32,500 goes to Contingencies /Reserve 15 To fund a portion of the Parks Designer salary I Page 2 of 39 4/27/2007 UNITED CITY OF YORKVILLE FY 07108 BUDGET FINAL GENERALFUND ACCOUNT 2005 -2006 2006 -2007 % 2007 -2008 NUMBER DESCRIPTION Actual Budget Change Budget ADMINISTRATION EXPENSES 01- 110 -50 -00 -5100 SALARIES-MAYOR 3,775 7,500 51% 11,310 01- 110 -50 -00 -5101 SALARIES - CITY CLERK 1,800 3,600 78% 6,410 01- 110 -50 -00 -5102 SALARIES - CITY TREASURER 1,800 3,600 78% 6,410 01- 110 -50 -00 -5103 SALARIES - ALDERMAN 15,450 29,080 41% 40,880 1 01- 110 -50 -00 -5104 SALARIES - LIQUOR COMMISSIONER 500 1,000 0% 1,000 01- 110 -50 -00 -5105 SALARIES - CITY ATTORNEY 11,060 11,502 -17% 9,500 01- 110 -50 -00 -5106 SALARIES - ADMINISTRATIVE 568,870 626,215 -29% 446,025 2 01- 110 -50 -00 -5136 SALARIES - PART TIME 49,393 50,000 -55% 22,500 3 01- 110 -50 -00 -5137 SALARIES - OVERTIME 375 1,500 -50% 750 01- 110 -61 -00 -5300 LEGAL SERVICES 77,265 55,000 55% 85,000 01- 110 -61 -00 -5311 CODIFICATION 5,614 5,000 0% 5,000 01- 110 -61 -00 -5314 BUILDING INSPECTIONS 1,142,685 1,115,000 1% 1,125,000 01- 110 -62 -00 -5401 CONTRACTUAL SERVICES 41,995 40,000 -31% 27,500 4 01- 110 -62 -00 -5403 SPECIAL CENSUS 67,377 0 100% - 5 01- 110 -62 -00 -5404 CABLE CONSORTIUM FEE 41,116 30,000 17% 35,000 01- 110 -62 -00 -5406 OFFICE CLEANING 6,600 7,500 0% 7,500 01- 110 -62 -00 -5410 MAINTENANCE - OFFICE EQUIPMENT 190 500 0% 500 01- 110 -62 -00 -5427 FACADE PROGRAM 20,000 30,000 -50% 15,000 6 01- 110 -62 -00 -5436 TELEPHONE 14,174 15,000 0% 15,000 01- 110 -62 -00 -5438 CELLULAR TELEPHONE 1,962 2,300 -17% 1,920 01- 110 -62 -00 -5439 TELEPHONE SYSTEMS MAINTENANCE 2,836 11,000 -32% 7,500 01- 110 -64 -00 -5600 DUES 3,576 5,000 10% 5,510 7 01- 110 -64 -00 -5601 ILLINOIS MUNICIPAL LEAGUE DUES 781 781 2% 800 01- 110 -64 -00 -5603 SUBSCRIPTIONS /BOOKS 315 900 -44% 500 01- 110 -64 -00 -5604 TRAINING & CONFERENCES 7,325 13,000 50% 19,500 8 01- 110 -64 -00 -5605 TRAVEL / MEALS / LODGING 14,268 17,000 -56% 7,500 9 01- 110 -64 -00 -5606 PROMOTIONAL/MARKETING EXP'S - 9,577 25% 12,000 10 YMCA PARTNERSHIP - 0 100% 1,500 01- 110 -64 -00 -5608 SPONSORSHIPS 300 1,500 0% 1,500 01- 110 -65 -00 -5800 CONTINGENCIES 46,460 595,000 -75% 146,500 11 01- 110 -65 -00 -5801 FUND BALANCE RESERVE - 0 0% - 01- 110 -65 -00 -5802 OFFICE SUPPLIES 15,995 15,000 -43% 8,500 01- 110 -65 -00 -5804 OPERATING SUPPLIES 7,416 10,000 -50% 5,000 01- 110 -65 -00 -5808 POSTAGE & SHIPPING 9,761 12,500 75% 21,925 12 01- 110 -65 -00 -5809 PRINTING & COPYING 14,952 11,000 0% 11,000 01- 110 -65 -00 -5810 PUBLISHING & ADVERTISING 3,866 5,000 0% 5,000 01- 110 -72 -00 -6500 IMRF PARTICIPANTS 45,400 49,471 -20% 39,756 13 01- 110 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 53,429 56,151 -29% 39,965 14 01- 110 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 15,709 30,000 -93% 2,000 15 01- 110 -75 -00 -7003 OFFICE EQUIPMENT 1,591 5,000 -50% 2,500 01- 110 -78 -00 -9002 NICOR GAS 40,052 30,000 0% 30,000 APPRECIATION DINNER - 0.00 100% 10,000 VOLUNTEER APPRECIATION DAY - 0.00 100% 2,000 WEBSITE - 0.00 100% 2,500 16 COMMUNITY EVENTS - 0.00 100% 45,200 17 TENNIS CRT REFURBISHING 40,000 01- 110 -78 -00 -9004 MISCELLANEOUS - 100 150% 250 SALARY SURVEY 60,063 01- 110 -78 -00 -9005 MERIT /COLA - 104,400 -84% 16,333 TOTAL EXPENSES: ADMINISTRATION 2,384,038 3,034,677 -21% 2,407,007 Page 3 of 39 4/27/2007 UNITED CITY OF YORKVILLE FY 07108 BUDGET FINAL GENERALFUND ACCOUNT 2005 -2006 2006 -2007 % 2007 -2008 NUMBER DESCRIPTION Actual Budget Change Budget ADMINISTRATION - COMMENTS 1 $6,000 increase with the new year 2 Separated Finance 3 $15,000 Transfer to Comm Devel; $7,500 for Comm Relations Intern 4 $5,000 for Comm Relations Video taping 5 Pulled out until 6 month review - special census likely to be completed summer and fall of 2008 6 Needs to be looked at by City Council - no $ spent in FY 0607 7 $510 Com Relations 8 IML Conference $575 Each / Asst Admin Conf / $1,500 Com Relations 9 $500 for Comm Relations 10 Comm Relations 11 Trans from Mun Bldgs /Grant Study/ CD's matured 12 $5,300 Comm Relations $2,800 for Newsletter & $2,500 Misc 13 $446,025 X 7.61 % 14 $446,025 X 7.65% 15 1 laptop and microsoft upgrades (City Administrator laptop for e- documents and regular use) 16 E- Newsletter 17 5oth Ann $43,000; Hometown Days, Kendall Arts Guild $300; Theatre in the park $1,200; City Hall $700 Page 4 of 39 4/27/2007 UNITED CITY OF YORKVILLE FY 07108 BUDGET FINAL GENERALFUND ACCOUNT 2005 -2006 2006 -2007 % 2007 -2008 NUMBER DESCRIPTION Actual Budget Change Budget FINANCE EXPENSES 01- 120 -50 -00 -5106 SALARIES - ADMINISTRATIVE - 0.00 100% 293,883 1 01- 120 -50 -00 -5136 SALARIES - PART TIME - 0.00 100% 5,000 01- 120 -50 -00 -5137 SALARIES - OVERTIME - 0.00 100% 750 01- 120 -50 -00 -5202 BENEFITS- UNEMPLOY. COMP. TAX 15,233 12,000 100% 24,000 2 01- 120 -50 -00 -5203 BENEFITS - HEALTH INSURANCE 771,967 852,458 0% 850,000 01- 120 -50 -00 -5204 BENEFITS - GROUP LIFE INSURANCE 19,864 74,049 1% 75,000 01- 120 -50 -00 -5205 BENEFITS - DENTAL/VISION ASST 70,770 23,668 15% 27,218 01- 120 -61 -00 -5304 AUDIT FEES & EXPENSES 25,500 2,675 1196% 32,000 3 01- 120 -61 -00 -5310 EMPLOYEE ASSISTANCE 2,867 4,500 0% 4,500 01- 120 -62 -00 -5400 INSURANCE - LIABILITY & PROPERTY 124,161 130,000 26% 163,422 4 01- 120 -62 -00 -5410 MAINTENANCE - OFFICE EQUIPMENT - 0.00 100% 500 01- 120 -62 -00 -5411 MAINTENANCE - COMPUTERS 1,808 2,000 0% 2,000 01- 120 -62 -00 -5412 MAINTENANCE - PHOTOCOPIERS 19,478 19,392 17% 22,750 5 01- 120 -62 -00 -5437 ACCTG SYSTEM SERVICE FEE 8,090 8,500 8% 9,200 01- 120 -62 -00 -5438 CELLULAR TELEPHONE - 0.00 100% 720 6 01- 120 -64 -00 -5603 SUBSCRIPTIONS /BOOKS - 0.00 100% 100 01- 120 -64 -00 -5604 TRAINING & CONFERENCES - 0.00 100% 3,125 7 01- 120 -64 -00 -5605 TRAVEL / MEALS / LODGING - 0.00 100% 4,000 01- 120 -65 -00 -5800 CONTINGENCIES - 0.00 0% - 01- 120 -65 -00 -5801 FUND BALANCE RESERVE - 0.00 0% - 01- 120 -65 -00 -5802 OFFICE SUPPLIES - 0.00 100% 8,500 01- 120 -65 -00 -5804 OPERATING SUPPLIES - 0.00 100% 5,000 01- 120 -65 -00 -5844 MARKETING - HOTEL TAX 18,469 20,000 0% 20,000 01- 120 -72 -00 -6500 IMRF PARTICIPANTS - 0.00 100% 28,642 01- 120 -72 -00 -6501 SOCIAL SECURITY & MEDICARE - 0.00 100% 28,793 01- 120 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 15,709 30,000 0% 30,000 8 01- 120 -75 -00 -7003 OFFICE EQUIPMENT - 0.00 100% 2,500 01- 120 -78 -00 -9001 CITY TAX REBATE 70 500 50% 750 01- 120 -78 -00 -9003 SALES TAX REBATE 278,920 450,000 61% 725,000 Amusement Tax Rebate 74,250 9 SALARY SURVEY - 0 100% 67,051 01- 120 -78 -00 -9005 MERIT /COLA - 0.00 100% 12,444 TRANSFER TO LAND CASH - 0.00 100% 48,245 01- 120 -99 -00 -9925 TRANSFER TO SAN SEWER - 0.00 0% 150,000 01- 120 -99 -00 -9940 TRANSFER TO PARK & RECREATION - 0.00 0% 1,161,778 TRANSFER TO WATER IMPROVEMENT - 0.00 0% 200,000 TRANSFER TO GEN FD REV FOR PD - 0.00 100% 125,000 10 01- 120 -99 -00 -9965 TRANSFER TO DEBT SERVICE - 0.00 100% 284,202 TOTAL EXPENSES: FINANCE 1,396,712 1,634,742 100% 4,490,323 Page 5 of 39 4/27/2007 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL GENERALFUND ACCOUNT 2005 -2006 2006 -2007 % 2007 -2008 NUMBER DESCRIPTION Actual Budget Change Budget FINANCE - COMMENTS 1 Includes 1 New Hire 2 Increase based on actual numbers 3 FY 06/07's amount is scrivener's error 4 IMRLA & Boiler Insurance & Library Addition 5 Per agreement 6 2 Cell Phones 7 IML $575 / GFOA $450 / IPERLA $800& MSI $1,000 / $300 IT Seminar 8 Rotation Policy and other IT equipment / Paperless System 9 55% of total amusement tax to water park 10 New World Software Police Page 6 of 39 4/27/2007 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL GENERALFUND ACCOUNT 2005 -2006 2006 -2007 % 2007 -2008 NUMBER DESCRIPTION Actual Budget Change Budget ENGINEERING EXPENSES 01- 150 -50 -00 -5107 SALARIES- EMPLOYEES 244,762 313,306 2% 318,914 01- 150 -50 -00 -5137 SALARIES- OVERTIME - 1,000 0% 1,000 01- 150 -62 -00 -5401 CONTRACTUAL SERVICES 88,889 50,000 -5% 47,500 1 01- 150 -62 -00 -5403 FEES 1,000 2,000 0% 2,000 2 01- 150 -62 -00 -5409 MAINTENANCE - VEHICLES 866 2,000 0% 2,000 01- 150 -62 -00 -5410 MAINTENANCE - OFFICE EQUIP 276 1,000 0% 1,000 01- 150 -62 -00 -5411 MAINTENANCE - COMPUTERS 1,587 3,000 -33% 2,000 01- 150 -62 -00 -5421 WEARING APPAREL 254 1,400 0% 1,400 01- 150 -62 -00 -5438 CELLULAR TELEPHONE 2,426 3,360 -25% 2,520 01- 150 -64 -00 -5600 DUES 293 400 50% 600 01- 150 -64 -00 -5604 TRAINING & CONFERENCES 227 6,000 -33% 4,000 01- 150 -64 -00 -5605 TRAVEL EXPENSE 1,231 1,000 0% 1,000 01- 150 -64 -00 -5608 TUITION REIMBURSEMENT - 0 100% 2,580 01- 150 -64 -00 -5616 BOOKS & PUBLICATIONS 163 200 0% 200 01- 150 -65 -00 -5801 ENGINEERING SUPPLIES 2,520 3,000 0% 3,000 01- 150 -65 -00 -5802 OFFICE SUPPLIES 2,464 2,500 0% 2,500 01- 150 -65 -00 -5809 PRINTING & COPYING 1,667 2,000 13% 2,250 01- 150 -72 -00 -6500 IMRF PARTICIPANTS 19,812 24,830 10% 27,393 01- 150 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 18,344 24,044 15% 27,537 01- 150 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 3,759 7,900 159% 20,500 3 01- 150 -75 -00 -7003 OFFICE EQUIPMENT 70 3,000 -17% 2,500 01- 150 -65 -00 -5820 Engineering Capital Reserve - 52,000 -23% 40,000 SALARY SURVEY - 0 100% 27,202 01- 150 -78 -00 -9005 MERIT /COLA - 0 100% 13,843 TOTAL EXPENSES: ENGINEERING 395,610 508,941 9% 553,439 Page 7 of 39 4/27/2007 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL GENERALFUND ACCOUNT 2005 -2006 2006 -2007 % 2007 -2008 NUMBER DESCRIPTION Actual Budget Change Budget ENGINEERING - COMMENTS 1 Reduced for Comm Relations Intern 2 Engineering Licenses, NPDES License 3 Auto Cad License $2,700; 2 new computers; copies of microsoft office -- $15,000 Is Comm Develop Page 8 of 39 4/27/2007 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL GENERALFUND ACCOUNT 2005 -2006 2006 -2007 % 2007 -2008 NUMBER DESCRIPTION Actual Budget Change Budget PUBLIC SAFETY /POLICE DEPT. EXPENSES 01- 210 -50 -00 -5107 SALARIES - EMPLOYEES 612,211 822,230 53% 1,254,261 01- 210 -50 -00 -5131 SALARIES - LIEUT. /SERGEANTS /CHIEF 541,474 612,203 -9% 555,341 01- 210 -50 -00 -5133 SALARIES - COPS 100,534 106,226 -100% - 1 01- 210 -50 -00 -5134 SALARIES - CROSSING GUARD 16,406 19,500 15% 22,425 01- 210 -50 -00 -5135 SALARIES - POLICE CLERKS 102,684 122,418 -9% 111,269 01- 210 -50 -00 -5136 SALARIES - PART TIME 37,588 35,000 5% 36,750 01- 210 -50 -00 -5137 SALARIES - OVERTIME 43,671 65,000 23% 80,000 2 01- 210 -50 -00 -5200 CADET PROGRAM 9,814 22,000 50% 33,000 3 01- 210 -61 -00 -5300 LEGAL SERVICES- 17,726 20,000 0% 20,000 01- 210 -62 -00 -5408 MAINTENANCE - EQUIPMENT 8,000 8,400 31% 11,000 4 01- 210 -62 -00 -5409 MAINTENANCE - VEHICLES 27,805 28,000 25% 35,000 01- 210 -62 -00 -5410 MAINT- OFFICE EQUIPMENT 2,500 2,625 71% 4,500 5 01- 210 -62 -00 -5411 MAINTENANCE - COMPUTERS 2,100 6,000 67% 10,000 6 MAINTENANCE - K9 2,000 7 01- 210 -62 -00 -5414 WEATHER WARNING SIREN MAINT 3,310 6,000 10% 6,600 8 01- 210 -62 -00 -5421 WEARING APPAREL 24,773 30,000 0% 30,000 9 01- 210 -62 -00 -5422 COPS GRANT IV - VESTS 2,634 3,000 100% 6,000 10 01- 210 -62 -00 -5423 CLASY GRANT - 1,000 -100% - 11 01- 210 -62 -00 -5429 PSYCHOLOGICAL TESTING 1,470 1,750 100% 3,500 01- 210 -62 -00 -5430 HEALTH SERVICES 2,357 3,500 0% 3,500 01- 210 -62 -00 -5431 LABORATORY FEES - 1,500 -100% - 12 01- 210 -62 -00 -5436 TELEPHONE 16,908 20,000 15% 23,000 01- 210 -62 -00 -5438 CELLULAR TELEPHONE 11,993 14,500 21% 17,500 13 01- 210 -62 -00 -5441 MTD- ALERTS FEE 4,620 8,450 25% 10,562 14 01- 210 -64 -00 -5600 DUES 1,953 2,500 60% 4,000 15 01- 210 -64 -00 -5603 SUBSCRIPTIONS 266 350 43% 500 01- 210 -64 -00 -5604 TRAINING & CONFERENCE 19,214 19,950 66% 33,025 16 01- 210 -64 -00 -5605 TRAVEL EXPENSES 10,367 10,500 15% 12,075 17 01- 210 -64 -00 -5606 COMMUNITY RELATIONS 5,500 7,800 28% 10,000 18 01- 210 -64 -00 -5607 POLICE COMMISSION 7,600 21,000 5% 22,050 19 01- 210 -64 -00 -5608 TUITION REIMBURSEMENT 12,522 14,000 0% 14,000 01- 210 -64 -00 -5609 POLICE RECRUIT ACADEMY - 10,500 90% 20,000 01- 210 -64 -00 -5610 GUN RANGE FEES 625 700 43% 1,000 01- 210 -64 -00 -5611 Special Response Team FEE 2,000 3,500 15% 4,025 NEIGHBORHOOD WATCH 100% 1,200 CITIZENS POLICE ACADEMY 100% 2,420 20 CHAPLAIN PROGRAM 100% 1,400 COMPLIANCE CHECKS 100% 500 21 DARE PROGRAM 100% 5,000 HUMAN RESOURCE COMMITTEE 100% - 22 01- 210 -65 -00 -5802 OFFICE SUPPLIES 6,499 6,825 47% 10,000 23 EVIDENCE TECH SUPPLIES 100% 5,000 24 01- 210 -65 -00 -5804 OPERATING SUPPLIES 16,000 16,800 15% 19,320 01- 210 -65 -00 -5808 POSTAGE & SHIPPING 2,662 3,500 43% 5,000 25 01- 210 -65 -00 -5809 PRINTING & COPYING 4,500 4,725 27% 6,000 26 01- 210 -65 -00 -5810 PUBLISHING & ADVERTISING 1,000 1,500 33% 2,000 27 01- 210 -65 -00 -5812 GASOLINE 53,503 63,000 19% 75,000 Page 9 of 39 4/27/2007 UNITED CITY OF YORKVILLE FY 07108 BUDGET FINAL GENERALFUND ACCOUNT 2005 -2006 2006 -2007 % 2007 -2008 NUMBER DESCRIPTION Actual Budget Change Budget PUBLIC SAFETY /POLICE DEPT. CONT'D EXPENSES 01- 210 -65 -00 -5813 AMMUNITION 5,000 5,500 9% 6,000 01- 210 -72 -00 -6500 IMRF PARTICIPANTS 8,331 9,671 22% 11,800 01- 210 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 112,468 137,591 2% 140,750 01- 210 -72 -00 -6502 POLICE PENSION 231,124 250,000 10% 275,000 28 01- 210 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 8,499 9,500 -21% 7,500 01- 210 -78 -00 -9004 BIKE PATROL 1,423 2,500 0% 2,500 MERIT /COLA 27,318 29 SALARY SURVEY 215,041 01- 210 -99 -00 -9910 TRANSFER TO POLICE CAPITAL - 0 0% - TOTAL EXPENSES: PUBLIC SAFETY /POLICE DEPT. 2,101,634 2,561,214 26% 3,215,632 Page 10 of 39 4127/2007 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL GENERALFUND ACCOUNT 2005 -2006 2006 -2007 % 2007 -2008 NUMBER DESCRIPTION Actual Budget Change Budget POLICE / PUBLIC SAFETY - COMMENTS 1 No more federal grant tracking 2 Due to staffing increases 3 True -up account for college and 40 -hour work -weeks during breaks 4 More Equipment Repairs 5 Furniture Replacement/Additional Equipment 6 Squad laptop maintenance 7 3 Canines - Assumes 2 visits per K9 per year 8 Add New Warning Siren (Lightning) / New Batteries for Weather Sirens New System for Elementary School (Grande Reserve) 9 $500 /year for records staff ($3000) 10 $600 /Officer 5 Replacement 11 Move $1000 from here to Community Relations & Eliminate this line item 12 Move $1500 to Health Services and Combine Line Items 13 Increase of 10 Phones = $40 /Phone & 300/Year for Each 14 Increase by 4 squad costs ($528 /year for each) (3 squads /1 detective) 15 Major Crimes Task Force = $1000 / Mobile Command Center - $500 16 5% increase to accommodate new hire /advanced training + 2 Staff & Command Courses @ $3000 each ($6000) + EMP ($2,025) + Detective Training (Northwestern - $5,000) 17 15% increase 18 Bike Rodeo / YPD Pins & Patches / Promotional Items / Increase in Programs 19 5% increase 20 Includes CPA / SPA 21 4 Liquor / 3 Tobacco 22 Removed and put in Admin Sponsorships 23 Includes allotment for small furniture /file cabinet purchases 24 Evidence Tech Supplies / Drug Test Kits 25 True -up account to allow for UPS charge -backs 26 True -up account for paper purchasing /increased business card printing 27 Increase for job advertisements 28 Matches levy amount ** Note: Actual amount determined by actuary for Police Pension Board 29 All Non -union staff get merit and salary survey increases Page 11 of 39 4/27/2007 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL GENERALFUND ACCOUNT 2005 -2006 2006 -2007 % 2007 -2008 NUMBER DESCRIPTION Actual Budget Change Budget COMMUNITY DEVELOPMENT EXPENSES 01- 220 -50 -00 -5107 EMPLOYEE SALARIES 7,665 218,000 39% 302,853 1 01- 220 -61 -00 -5300 LEGAL SERVICES 50,291 20,000 0% 20,000 01- 220 -62 -00 -5401 CONTRACTUAL SERVICES 34,669 80,000 -53% 37,500 2 01- 220 -62 -00 -5430 PLANNING CONSULTANT 8,028 70,000 -29% 50,000 01- 220 -62 -00 -5432 ECONOMIC DEVELOPMENT 45,000 45,000 0% 45,000 01- 220 -62 -00 -5438 CELLULAR TELEPHONE 307 1,000 0% 1,000 01- 220 -64 -00 -5600 DUES 400 1,000 50% 1,500 01- 220 -64 -00 -5604 TRAINING & CONFERENCES 2,284 6,000 25% 7,500 01- 220 -64 -00 -5605 TRAVEL EXPENSE - 3,000 -17% 2,500 01- 220 -64 -00 -5616 BOOKS & PUBLICATIONS 423 0 0% - 01- 220 -65 -00 -5804 OPERATING SUPPLIES 1,676 5,000 50% 7,500 01- 220 -65 -00 -5809 PRINTING & COPYING 558 2,500 -20% 2,000 01- 220 -65 -00 -5810 PUBLISHING & ADVERTISING 4,660 8,000 0% 8,000 01- 220 -65 -00 -5814 BOOKS & MAPS 1,079 4,000 0% 4,000 01- 220 -72 -00 -6500 IMRF PARTICIPANTS - 17,222 43% 24,563 01- 220 -72 -00 -6501 SOCIAL SECURITY & MEDICARE - 16,677 48% 24,693 01- 220 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 8,966 25,000 -60% 10,000 3 01- 220 -75 -00 -7003 OFFICE EQUIPMENT 27,081 3,000 67% 5,000 SALARY SURVEY - 0 8,281 01- 220 -78 -00 -9005 MERIT /COLA - 0 11,645 TOTAL EXPENSES: I PLANNING & DEVELOPMENT 193,088 525,399 9% 573,535 Page 12 of 39 4/27/2007 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL GENERALFUND ACCOUNT 2005 -2006 2006 -2007 % 2007 -2008 NUMBER DESCRIPTION Actual Budget Change Budget COMMUNITY DEVELOPMENT - COMMENTS 1 Includes 1 New Hire 2 Reduced for Comm Relations Intern 3 $5,000 Server; $10,000 1st License set up; $6,200 GPS Geo; GPS Analyst $2,000; auto cad licenses I Page 13 of 39 4/27/2007 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL GENERALFUND ACCOUNT 2005 -2006 2006 -2007 % 2007 -2008 NUMBER DESCRIPTION Actual Budget Change Budget STREETS EXPENSES 01- 410 -50 -00 -5107 SALARIES - EMPLOYEE 169,756 225,437 17% 263,748 01- 410 -50 -00 -5136 SALARIES - PART TIME 1,484 8,500 13% 9,600 1 01- 410 -50 -00 -5137 SALARIES - OVERTIME 16,557 20,000 0% 20,000 01- 410 -61 -00 -5313 ENGINEERING - IN TOWN ROAD PG 101,814 261,802 -5% 250,000 01- 410 -61 -00 -5314 INSPECTIONS & LICENSES 318 400 0% 400 01- 410 -62 -00 -5401 CONTRACTUAL SERVICES 1,176 2,000 0% 2,000 01- 410 -62 -00 -5408 MAINTENANCE - EQUIPMENT 10,505 8,000 0% 8,000 01- 410 -62 -00 -5409 MAINTENANCE - VEHICLES 14,913 9,000 67% 15,000 2 01- 410 -62 -00 -5414 MAINTENANCE - TRAFFIC SIGNALS 11,299 18,000 0% 18,000 01- 410 -62 -00 -5415 MAINTENANCE - STREET LIGHTS 28,548 25,000 6% 26,500 3 01- 410 -62 -00 -5420 MAINTENANCE -STORM SEWER - 10,000 0% 10,000 RAYMOND DETENTION BASE 100% 75,000 RAYMOND STORM SEWER OUTFLOW 100% 1,300,000 01- 410 -62 -00 -5421 WEARING APPAREL 5,157 6,000 2% 6,150 4 01- 410 -62 -00 -5434 RENTAL - EQUIPMENT - 2,000 0% 2,000 01- 410 -62 -00 -5435 ELECTRICITY 56,246 60,000 24% 74,400 5 01- 410 -62 -00 -5438 CELLULAR TELEPHONE 2,814 3,300 21% 4,000 6 01- 410 -62 -00 -5440 STREET LIGHTING 687 6,000 0% 6,000 7 01- 410 -64 -00 -5604 TRAINING & CONFERENCES 4,862 5,000 51% 7,525 8 01- 410 -65 -00 -5804 OPERATING SUPPLIES 19,236 30,000 0% 30,000 01- 410 -65 -00 -5812 GASOLINE 32,943 27,500 10% 30,250 9 01- 410 -65 -00 -5815 HAND TOOLS 2,507 2,500 0% 2,500 10 01- 410 -65 -00 -5817 GRAVEL 902 6,500 -62% 2,500 01- 410 -72 -00 -6500 IMRF PARTICIPANTS 15,060 19,390 10% 21,238 01- 410 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 14,365 19,426 10% 21,349 01- 410 -75 -00 -5418 MOSQUITO CONTROL 20,296 27,000 11% 30,000 11 01- 410 -75 -00 -7004 SAFETY EQUIPMENT 708 1,000 0% 1,000 01- 410 -75 -00 -7100 STREET REHAB PROJECTS 35,647 75,000 -100% 126 /71 Improvements 100% 19,000 TRAFFIC SIGNALS RT. 34 & Sycamore 100% - 12 ASPHAULT PAVEMENT 100% 27,573 01- 410 -75 -00 -7106 ROAD CONTRIB FUND PROJECTS 11,043 30,000 500% 180,000 13 01- 410 -75 -00 -7107 ROAD CONTRIB FUND - RESERVE - 1,500,000 -32% 1,020,000 14 01- 410 -75 -00 -7101 IN -TOWN ROAD PROGRAM 1,646,805 1,588,198 57% 2,500,000 01- 410 -75 -00 -7099 GRANDE RES PERIMETER RIDS 401,370 1,600,000 -38% 1,000,000 15 01- 410 -75 -00 -7102 TREE & STUMP REMOVAL 9,510 25,000 -8% 23,000 01- 410 -75 -00 -7103 SIDEWALK CONSTRUCTION 570 25,000 -90% 2,500 FOX ROAD SIDEWALK - 0 100% 25,000 01- 410 -75 -00 -7104 FOX HILL SSA EXPENSES 7,278 18,000 0% 18,000 01- 410 -75 -00 -4404 HANGING BASKETS - 2,442 -18% 2,000 SALARY SURVEY - 0 100% 6,353 01- 220 -78 -00 -9005 MERIT /COLA - 0 100% 8,974 01- 410 -99 -00 -9930 TRANSFER TO WATER IMPROVE 215,000 220,000 -100% TOTAL EXPENSES: STREETS 2,859,373 5,887,394 20% 7,069,560 Page 14 of 39 4/27/2007 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL GENERALFUND ACCOUNT 2005 -2006 2006 -2007 % 2007 -2008 NUMBER DESCRIPTION Actual Budget Change Budget STREETS - COMMENTS 1 2 pt @ 9hrX12 Wks = $8640 +$1000 more than 12 wks 2 Increase due to more vehicles 3 5% Increase for parts & # of Poles 4 5 employees + 2 new emp. @ 8.85/wk = 61.95/wk x 52 = 3221 x 5% inc = 3382 sweatshirt $40.00 ; work coat $85.00; winter coat $109.00; coveralls $95.00; boots $150.00; gloves $20.00; hat $10.00; rubber boots $75.00; hard hat $20.00; vest $30.00; t -shirts $75.00 TOTAL $709.00 x 2 = $1,418.00 Replacement Boots X 5 = $750.00; Replace Gear X 5= $100.00 Summer help t -shirts $100.00 5 24% Increase 6 5 emp. @ 35 /mo. = $2100 + 2 new emp = $2940 ; Batteries, cliops & Repairs = $300 2 new phones @ 150 = 300 + 2 repl phones @ 150 = 600 7 3 Complete light replacements 8 National = flight - $400, lodging 5 nights @ $150, Meals 5 days @$40 /day conference cost $700, reimbursables - $100 TOTAL $2,150.00 Regional = flight - $250, lodging 3 nights@ $150, Meals 3 x $40 conference cost $200, reimbursables - $100 TOTAL $1,120 State lodging - 3 x $150, meals 3 x $40, conf cost $600, reimburseables - $100 TOTAL $1,270 Local $50.00 John - 1 nat'I, 1 reg'I (snow conf) 2 local $3,370 MATT 1 reg'I, 2 local $1,220.00 -- JR. 2 local $100; BOB 2 local $100 Durk - 1 reg'I, 2 local $1,220 ERIC - 1 national, 1 regional, 1 state $1,513 9 10% Increase 10 Outfit new employee trucks 11 Per contract 12 Under Road Contribution Fund Projects 13 Traffic Signal at Route 34 & Sycamore 14 Tied to match the Road Contrib Fee Rev (minus the amount used for Road Contribution Fund Projects 15 Reserve for Arterial road improvements per agreement Page 15 of 39 4/27/2007 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL GENERALFUND ACCOUNT 2005 -2006 2006 -2007 % 2007 -2008 NUMBER DESCRIPTION Actual Budget Change Budget HEALTH & SANITATION EXPENSES 01- 540 -62 -00 -5442 GARBAGE SERVICES 591,517 676,163 53% 1,031,400 01- 540 -62 -00 -5443 LEAF PICKUP 7,050 5,000 20% 6,000 TOTAL EXPENSES: HEALTH & SANITATION 598,567 681,163 52% 1,037,400 TOTAL GENERAL FUND REVENUES 13,640,052 16,583,575 17% 19,346,897 TOTAL GENERAL FUND EXPENSES 9,913,313 14,804,671 31% 19,346,896 FUND SURPLUS (DEFICIT) 3,726,739 1,778,904 -100% 0 I I Page 16 of 39 4/27/2007 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL MFT ACCOUNT 2005 -2006 2006 -2007 2007 -2008 NUMBER DESCRIPTION Actual Budget % Change Budget REVENUES 15- 000 -40 -00 -3999 CARRY OVER BALANCE 423,181 300,000 -35% 194,152 15- 000 -40 -00 -4060 MOTOR FUEL TAX ALLOTMENTS 266,560 318,601 -1% 315,000 15- 000 -44 -00 -4490 MISC INCOME 0 0 0% Game Farm Road Design 157,000 15- 000 -46 -00 -4600 INVESTMENT INCOME 15,528 12,000 13% 13,500 TOTAL REVENUES: 705,270 630,601 8% 679,652 EXPENSES 15- 000 -65 -00 -5800 CONTINGENCY 11,936 34,011 -73% 9,052 15- 000 -65 -00 -5818 SALT 46,482 60,000 30% 78,010 15- 000 -75 -00 -7007 SIGNS 9,799 9,990 0% 9,990 15- 000 -75 -00 -7008 CRACK FILLING 32,200 40,000 -100% - Game Farm Surveying 68,000 15- 000 -75 -00 -7107 CONSTRUCTION ENGINEERING 65,721 150,000 111% 317,000 1 15- 000 -75 -00 -7110 COLD PATCH 886 8,000 0% 8,000 15- 000 -75 -00 -7111 HOT PATCH 1,830 9,600 0% 9,600 j- 000 -75 -00 -7113 COUNTRYSIDE PKWY CONST. 0 300,000 -100% - Van Emmon 100% 30,000 Palmer Court 100% 70,000 Wood Dale 100% 30,000 Faxon Road ROW Acq 100% 50,000 15- 000 -99 -00 -9960 TRANSFER TO FOX INDUSTRIAL 31,190 0 0% - TOTAL EXPENSES: 200,044 630,601 8% 679,652 TOTAL FUND REVENUES 705,270 630,601 679,652 TOTAL FUND EXPENSES 200,044 630,601 679,652 FUND SURPLUS (DEFICIT) 505,226 0 0 COMMENTS: 1 Game Farm Road Page 17 of 39 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL MUNICIPAL BUILDING ACCOUNT 2005 -2006 2006 -2007 2007 -2008 NUMBER DESCRIPTION Actual Budget % Change Budget REVENUES 16- 000 -40 -00 -3999 CARRY OVER BALANCE - 32,500 -100% - 16- 000 -42 -00 -4211 DEVELOPMENT FEES - BUILDING 85,950 137,423 191% 400,000 1 16- 000 -42 -00 -4215 BEECHER RENTAL FEE 7,095 12,000 -25% 9,000 16- 000 -49 -00 -4901 TRANSFER FROM GENERAL FUND 102,043 30,865 -100% - TOTAL REVENUES: 195,088 212,788 92% 409,000 EXPENSES 16- 000 -62 -00 -5416 MAINT - GENERAL BLDG & GROUNDS 689 5,000 0% 5,000 16- 000 -75 -00 -7008 ENTRY WAY SIGNS - 4,000 -50% 2,000 16- 000 -75 -00 -7200 BLDG IMPROV- PARK & REC 17,379 10,000 20% 12,000 16- 000 -75 -00 -7203 BLDG IMPROVEMENTS - PUBLIC WKS 9,704 10,000 20% 12,000 16- 000 -75 -00 -7204 BLDG MAINT - CITY HALL 15,549 12,000 -33% 8,000 16- 000 -75 -00 -7205 BLDG IMPROVEMENTS - LIBRARY 2,548 4,000 -100% - 16- 000 -75 -00 -7206 LANDSCAPING - PUBLIC BUILDINGS 2,044 2,000 75% 3,500 16- 000 -75 -00 -7209 BEECHER PARKING LOT 41,120 0 0% - •000 -75 -00 -7210 BLDG IMPROV - POST OFFICE - 30,865 -100% - NEW BUILDINGS 100% 51,577 16- 000 -78 -00 -9009 RESERVE - 0 100% 30,000 TRANSFER TO GENERAL FUND 182,500 TRANSFER TO DEBT SERVICE - 102,423 0% 102,423 TOTAL EXPENSES: 89,034 212,788 92% 409,000 I TOTAL FUND REVENUES 195,088 212,788 409,000 TOTAL FUND EXPENSES 89,034 212,788 409,000 FUND SURPLUS (DEFICIT) 106,054 0 0 I COMMENTS: 1 Tied to permit estimates i i i I Page 18 of 39 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL POLICE CAPITAL 2005 -2006 2006 -2007 2007 -2008 ACCOUNT NUMBER DESCRIPTION Actual Budget % Change Budget REVENUES 20- 000 -40 -00 -3999 CARRY OVER BALANCE 69,250 169,648 -51% 82,648 20- 000 -42 -00 -4212 DEV FEES - POLICE 195,600 188,000 25% 235,000 1 20- 000 -44 -00 -4402 K -9 DONATIONS 200 1,000 -100% 20- 000 -44 -00 -4403 IN CAR VIDEO DONATIONS 8,103 2,500 140% 6,000 2 20- 000 -44 -00 -4404 DONATIONS 1,500 1,000 -100% - 20- 000 -44 -00 -4405 WEATHER WARNING SIREN 29,231 20,000 -25% 15,000 20- 000 -44 -00 -4431 SALE OF POLICE SQUADS - 500 -100% - 20- 000 -44 -00 -4489 RICP DISASTER PLAN GRANT 990 0 0% - 20- 000 -44 -00 -4490 MISC INCOME 36,523 0 0% - 20- 000 -48 -00 -4800 LOAN PROCEEDS - 0 0% - 20- 000 -49 -00 -4901 TRANSFER FROM GENERAL FUNI - 75,000 -100% - TOTAL REVENUES: 341,397 457,648 -26% 338,648 i EXPENSES 20- 000 -65 -00 -5811 LETHAL /NON- LETHAL WEAPONS 6,825 7,000 43% 10,000 ^- 000 -75 -00 -7001 EQUIPMENT 20,000 36,722 -1% 36,411 . - 000 -75 -00 -7002 K -9 EQUIPMENT - 1,500 67% 2,500 3 20- 000 -75 -00 -7006 CAR BUILD OUT 25,621 49,415 40% 68,948 4 20- 000 -75 -00 -7008 NEW WEATHER WARNING SIREN 10,450 37,000 0% 37,000 20- 000 -75 -00 -7005 VEHICLES 72,385 97,222 -18% 80,000 5 20- 000 -75 -00 -7009 RES- WEATHER WARNING SIREN - 82,648 0% 82,648 NEW WORLD SOFTWARE - 125,000 -100% - 20- 000 -78 -00 -9009 RESERVE 26,526 21,141 0% 21,141 20- 000 -99 -00 -9965 TRANSFER TO DEBT SERV FUND 24,110 0 0% - TOTAL EXPENSES: 185,916 457,648 -26% 338,648 TOTAL FUND REVENUES 341,397 457,648 338,648 TOTAL FUND EXPENSES 185,916 457,648 338,648 FUND SURPLUS (DEFICIT) 155,481 0 0 COMMENTS: 1 Increased based on projections 2 Based on 6 month income anal 3 New K9's 4 3 Build Outs $22,100 each 5 4 squads Page 19 of 39 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL PUBLIC WORKS CAPITAL ACCOUNT 2005 -2006 2006 -2007 2007 -2008 NUMBER DESCRIPTION Actual Budget % Change Budget REVENUES 21- 000 -40 -00 -3999 CARRY OVER BALANCE 186,721 175,000 14% 200,000 21- 000 -42 -00 -4213 DEVELOPMENT FEES - PUBLIC WORK; 481,500 435,000 38% 600,000 1 21- 000 -44 -00 -4430 SALE OF EQUIPMENT 34,114 40,000 63% 65,000 2 21- 000 -49 -00 -4915 TRANSFER FROM WATER FUND 50,000 50,000 -100% - 21- 000 -49 -00 -4920 TRANSFER FROM SEWER FUND 30,000 30,000 -100% - TOTAL REVENUES: 782,335 730,000 18% 865,000 EXPENSES 21- 000 -75 -00 -7005 VEHICLES 184,968 309,000 25% 385,000 3 21- 000 -75 -00 -7015 SKID STEER UPGRADE 3,952 4,500 111% 9,500 21- 000 -75 -00 -7107 TRUCK ACCESSORIES 11,445 14,000 0% 14,000 21- 000 -75 -00 -7130 FACILITY EXPANSION 4,000 200,000 0% 200,000 21- 000 -75 -00 -7115 SALT DOME - 0 0% - 21- 000 -75 -00 -7001 EQUIPMENT - 150,000 -17% 125,000 4 TRANSFER TO PARKS CAPITAL 100% 42,500 21- 000 -78 -00 -9009 RESERVE 4,800 52,500 70% 89,000 TAL EXPENSES: 209,165 730,000 18% 865,000 TOTAL FUND REVENUES 782,335 730,000 865,000 TOTAL FUND EXPENSES 209,165 730,000 865,000 FUND SURPLUS (DEFICIT) 573,170 0 0 I COMMENTS: 1 Increased by new permit projections 2 3 Utility Trucks 3 street utility truck $46,000; water utility truck $46,000; sewer utility truck $41,000 skid steer upgrade w /trailer $9,500; truck accessories $14,000 single axle dump truck $92,000; tandem axle dump truck $100,000 utility machine w /attachments $125,000; new pick up trucks (2) $60,000 4 Utility Machine w /mower & snow blower Page 20 of 39 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL PARKS & RECREATION CAPITAL ACCOUNT 2005 -2006 2006 -2007 2007 -2008 NUMBER DESCRIPTION Actual Budget % Change Budget REVENUES 22- 000 -40 -00 -3999 CARRY OVER 65,691 13,100 702% 105,000 22- 000 -42 -00 -4216 PARKS CAPITAL FEE 23,900 26,000 15% 30,000 1 22- 000 -42 -00 -4217 PARK CAPTIAL DONATIONS 7,000 0 0% - 22- 000 -44 -00 -4430 SALE OF VEHICLES /EQUIPMENT - 10,000 -100% - TRANSFER FROM PW CAPITAL -100% 45,000 2 22- 000 -42 -00 -4218 IL CLEAN ENERGY GRANT - 0 0% - TOTAL REVENUES: 96,591 199,100 -10% 180,000 EXPENSES PARKS CAPITAL OUTLAY 22- 610 -75 -00 -7006 PICK UP TRUCK 60,020 75,000 -40% 45,000 3 22- 610 -75 -00 -7018 PARK REDEVELOPMENTS - 105,000 -5% 100,000 COMPUTER SERVER 5,000 22- 610 -75 -00 -7015 PARKS EQUIPMENT 5,961 15,000 100% 30,000 4 ?- 610 -65 -00 -5800 RESERVE - 0 0% - fOTAL EXPENSES: PARKS 84,506 199,100 -10% 180,000 TOTAL FUND REVENUES 96,591 199,100 180,000 TOTAL FUND EXPENSES 84,506 199,100 180,000 FUND SURPLUS (DEFICIT) 12,085 0 0 II COMMENTS: 1 Inc based on new permits 2 To fund 1 truck 3 1 new pick up 4 1 mower and utility Page 21 of 39 UNITED CITY OF YORKVILLE FY 07108 BUDGET FINAL SEWER IMPROVEMENT 2005 -2006 2006 -2007 % 2007 -2008 ACCOUNT NUMBER DESCRIPTION Actual Budget Change Budget REVENUES 37- 000 -40 -00 -3999 CARRY OVER BALANCE 4,016,171 3,130,000 -100% - 37- 000 -42 -00 -4220 CONNECTION FEES 1,281,300 1,576,800 -43% 904,491 37- 000 -42 -00 -4221 RIVER CROSSING FEES 6,576 20,000 -100% 37- 000 -48 -00 -4803 ROB ROY CREEK REVENUE 12,150,313 0 100% 550,745 37- 000 -48 -00 -4804 SOUTHWEST SERVICE AREA INTERCEPTC 253,662 5,500,000 0% 5,500,000 37- 000 -49 -00 -4901 TRANSFER FROM GENERAL FUND 150,000 150,000 0% 150,000 37- 000 -46 -00 -4600 INVESTMENT INCOME 243,928 150,000 -50% 75,000 TOTAL REVENUES: 18,101,950 10,526,800 -32% 7,180,236 i EXPENSES 37- 000 -62 -00 -5401 CONTRACTUAL /PROFESSIONAL SERVICE; 7,218 40,000 -25% 30,000 37- 000 -62 -00 -5402 ENG /LEGAL /CONTINGENCIES - COUNTRYSI 142,893 0 0% - 37- 000 -62 -00 -5405 ENG /LEGAL /CONTINGENCIES - BRUELL ST 94,428 0 0% - 37- 000 -62 -00 -5406 ENGHLEGAL /CONTINGENCIES - HYDRAULI 1,940 0 0% - 37- 000 -65 -00 -5421 GIS SYSTEM - 5,000 -100% - •000 -65 -00 -5800 CONTINGENCY - 796,759 -100% - 000 -66 -00 -6012 DEBT ISSUANCE COSTS 216,425 0 0% 37- 000 -75 -00 -7503 COUNTRYSIDE INTERCEPTOR 2,288,310 0 0% 37- 000 -75 -00 -7505 ROB ROY CREEK SANITARY 7,662,913 3,130,000 0% - 37- 000 -75 -00 -7506 SOUTHWEST SERVICE AREA INTERCEPTC 626,817 5,500,000 0% 5,500,000 37- 000 -75 -00 -7508 MANHOLE REHAB PROJECT 6,456 15,000 0% 15,000 37- 000 -75 -00 -7515 HRTLAND ONSITE INTERCEPT OVER SIZIN 278,893 0 0% - 37- 000 -75 -00 -7504 BRUELL STREET LIFT STATION 821,296 0 0% - 37- 000 -75 -00 -7509 SCADA SYSTEM - 100,000 -25% 75,000 FOX HILL SANITARY SEWER RECAPTURE - 150,000 0% 150,000 PALMER COURT 100% 50,000 37- 000 -99 -00 -9901 TRANSFER TO GENERAL FUND 150,000 150,000 0% 150,000 37- 000 -99 -00 -9965 TRANSFER TO DEBT SERVICE 646,213 640,041 89% 1,210,236 TOTAL EXPENSES: 12,943,801 10,526,800 -32% 7,180,236 TOTAL FUND REVENUES 18,101,950 10,526,800 7,180,236 TOTAL FUND EXPENSES 12,943,801 10,526,800 7,180,236 FUND SURPLUS (DEFICIT) 5,158,148 0 - Page 22 of 39 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL WATER IMPROVEMENT ACCOUNT 2005 -2006 2006 -2007 % 2007 -2008 NUMBER DESCRIPTION Actual Budget Change Budget REVENUES 41- 000 -40 -00 -3999 CARRY OVER - 1,945,082 28% 2,484,240 41- 000 -42 -00 -4220 CONNECTION FEES 1,537,680 2,083,000 -28% 1,500,000 41- 000 -42 -00 -4221 SOUTHWEST WATER MAIN PROJECT REVEL 35,958 2,648,276 0% 2,648,276 41- 000 -46 -00 -4600 INVESTMENT INCOME 71,127 55,000 0% 55,000 41- 000 -49 -00 -4901 TRANSFER FROM GENERAL FUND 215,000 220,000 -9% 200,000 TOTAL REVENUES: 3,906,658 8,364,318 -18% 6,887,516 EXPENSES 41- 000 -61 -00 -5300 LEGAL SERVICES 3,153 8,000 0% 8,000 41- 000 -61 -00 -5301 ENGINEERING - GENERAL SERVICES 14,636 20,000 100% 40,000 41- 000 -61 -00 -5405 PROFESSIONAL SERVICE /CONTRACT B.2 &, 31,686 20,000 150% 50,000 41- 000 -61 -00 -5415 USGS GROUNDWATER STUDY 40,290 10,500 -62% 4,000 SW INTERCEPTOR 100% 2,000,000 41- 000 -65 -00 -5800 CONTINGENCY 23,388 1,124,677 221% 3,608,441 '- 000 -75 -00 -7520 WATERMAIN PROJECTS - 311,000 -4% 300,000 -► 1- 000 -75 -00 -7522 IN TOWN ROAD PROGRAM WATER PROJEC - 220,000 0% 220,000 41- 000 -75 -00 -7509 SCADA System 17,360 450,000 -100% 41- 000 -99 -00 -9901 TRANSFER TO GENERAL FUND 200,000 200,000 0% 200,000 41- 000 -99 -00 -9965 TRANSFER TO DEBT FUND 296,442 443,121 3% 457,075 TOTAL EXPENSES: 3,394,963 8,364,318 -18% 6,887,516 TOTAL FUND REVENUES 3,906,658 8,364,318 6,887,516 TOTAL FUND EXPENSES 3,394,963 8,364,318 6,887,516 FUND SURPLUS (DEFICIT) 511,694 0 - Page 23 of 39 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL DEBT SERVICE ACCOUNT 2005 -2006 2006 -2007 % 2007 -2008 NUMBER DESCRIPTION Actual Budget Change Budget REVENUES 42- 000 -40 -00 -3999 CARRY OVER 13,918 0 0% 0.00 42- 000 -44 -00 -4440 RECAPTURE - WATER /SEWER 114,554 125,000 0% 125,000 ' 42- 000 -44 -00 -4441 LIBRARY BOND REFERENDUM - 0 100% 421,936 42- 000 -49 -00 -4901 TRANSFER FROM GENERAL FUND - 292,859 -3% 284,202 42- 000 -49 -00 -4910 TRANSFER FROM POLICE EQUIP CAP 24,110 0 0% 0.00 42- 000 -49 -00 -4925 TRANSFER FROM SANITARY SEWER 646,213 640,041 89% 1,210,236 42- 000 -49 -00 -4930 TRANSFER FROM WATER IMPRV FUND 296,442 443,121 3% 457,075 42- 000 -49 -00 -4940 TRANSFER FROM MUNICIPAL BLDG 103,923 102,423 0% 102,423 TOTAL REVENUES: 1,199,160 1,603,444 62% 2,600,872 EXPENSES 42- 000 -66 -00 -6001 CITY HALL BONDS - PRINCIPAL PMT 50,000 50,000 0% 50,000 42- 000 -66 -00 -6002 CITY HALL BONDS - INTEREST PMT 53,923 52,423 -88% 6,400 42- 000 -66 -00 -6003 IRBB - BRUELL STREET INTEREST PYMT 85,435 83,795 -2% 81,794 42- 000 -66 -00 -6004 IRBB - BRUELL STREET PRINCIPAL PYMT 80,000 80,000 0% 80,000 42- 000 -66 -00 -6007 4.8 MILLION DEBT CERT INT PYMT(WATER) 233,150 233,150 -26% 173,650 '?- 000 -66 -00 -6008 COUNTRYSIDE ALT REV PRINCIPAL PYMT 120,000 125,000 8% 135,000 .2- 000 -66 -00 -6009 COUNTRYSIDE ALT REV INTEREST PYMT 120,638 117,638 -3% 114,513 42- 000 -66 -00 -6010 COM ED /HYDRAULIC DEBT CERT. INT PYMT 43,217 41,328 -6% 38,947 42- 000 -66 -00 -6011 COM ED /HYDRAULIC DEBT CERT. PRINC. 135,000 140,000 4% 145,000 42- 000 -66 -00 -6013 Library Bond 2005bB Interest - 0 100% 321,125 42- 000 -66 -00 -6015 Library Bond 2006 Interest - 0 100% 100,811 ROB ROY CREEK BOND - 0 100% 468,950 42- 000 -66 -00 -6049 SANITARY SIPHON L17- 115300 INTEREST 38,980 8,301 0% 8,301 42- 000 -66 -00 -6050 SANITARY SIPHON L17- 115300 PRINCIPAL - 30,679 0% 30,679 LOAN PAYMENT - SSES IEPA L17 -1153 PRINC - 31,275 242% 107,051 42- 000 -66 -00 -6070 $650K ROAD IMPROVEMENT PROG INT. 14,273 26,070 -12% 22,820 Refunding 2006 Interest 100% 95,027 Refunding 2006 A Principal 100% 5,100 $2.8M North Water Tower 2002 Issue 100% 60,000 42- 000 -66 -00 -6071 $650K ROAD IMPROVEMENT PROG PRINC 50,000 65,000 15% 75,000 42- 000 -66 -00 -6072 2 MILLION ALT REVENUE (B.2 & B.3) INT. 29,800 90,150 -1% 88,925 42- 000 -66 -00 -6073 2 MILLION ALT REVENUE (B.2 & B.3) PRINC - 35,000 114% 75,000 42- 000 -66 -00 -6074 $3.825 MILLION IN TOWN ROAD - INT. - 262,859 -40% 156,779 42- 000 -66 -00 -6075 $3.825 MILLION IN TOWN ROAD - PRINC - 30,000 433% 160,000 TOTAL EXPENSES: 1,161,464 1,578,443 65% 2,600,872 TOTAL FUND REVENUES 1,199,160 1,603,444 2 TOTAL FUND EXPENSES 1,161,464 1,578,443 2,600,872 JND SURPLUS (DEFICIT) 37,696 25,001 0 Page 24 of 39 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL WATER OPERATIONS 2005 -2006 2006 -2007 % 2007 -2008 ACCOUNT NUMBER DESCRIPTION Actual Budget Change Budget REVENUES 51- 000 -40 -00 -3999 CARRY OVER BALANCE 441,462 500,000 -100% - 51- 000 -42 -00 -4240 BULK WATER SALES 11,973 10,000 0% 10,000 51- 000 -42 -00 -4241 WATER SALES 1,222,781 1,150,000 13% 1,300,000 51- 000 -42 -00 -4242 WATER METER SALES 291,498 220,000 77% 390,000 1 51- 000 -42 -00 -4243 LEASE REVENUE - H2O TOWER 22,415 25,000 24% 31,000 2 51- 000 -46 -00 -4600 INVESTMENT INCOME 25,099 15,000 58% 23,683 TOTAL REVENUES: 2,015,517 1,922,000 -9% 1,754,683 EXPENSES 51- 000 -50 -00 -5107 SALARIES - EMPLOYEE 250,525 318,439 -7% 297,738 51- 000 -50 -00 -5136 SALARIES -PART TIME 5,216 8,500 0% 8,500 51- 000 -50 -00 -5137 SALARIES - OVERTIME 38,898 40,000 0% 40,000 51- 000 -61 -00 -5300 LEGAL SERVICES 338 2,000 0% 2,000 51- 000 -61 -00 -5303 JULIE SERVICE 8,494 10,000 10% 11,000 3 51- 000 -62 -00 -5401 CONTRACTUAL SERVICES 4,227 5,000 80% 9,000 4 51- 000 -62 -00 -5408 MAINTENANCE - EQUIPMENT 1,941 9,000 -44% 5,000 i1- 000 -62 -00 -5409 MAINTENANCE - VEHICLES 1,109 7,000 0% 7,000 51- 000 -62 -00 -5411 MAINTENANCE - COMPUTERS 132 1,000 -50% 500 51- 000 -62 -00 -5413 MAINTENANCE - CONTROL SYSTEN 1,654 10,000 -100% 5 51- 000 -62 -00 -5421 WEARING APPAREL 2,451 5,500 -12% 4,850 6 51- 000 -62 -00 -5434 RENTAL - EQUIPMENT - 2,000 0% 2,000 51- 000 -62 -00 -5435 ELECTRICITY 116,401 130,000 24% 161,200 7 51- 000 -62 -00 -5436 TELEPHONE 16,126 22,000 0% 22,000 51- 000 -62 -00 -5438 CELLULAR TELEPHONE 3,930 5,700 -42% 3,300 8 51- 000 -64 -00 -5600 DUES 770 1,000 0% 1,000 51- 000 -64 -00 -5603 SUBSCRIPTIONS 164 250 0% 250 51- 000 -64 -00 -5604 TRAINING & CONFERENCES 2,741 5,000 -42% 2,900 9 51- 000 -64 -00 -5605 TRAVEL / MEALS / LODGING 945 5,000 8% 5,400 51- 000 -65 -00 -5800 CONTINGENCIES - 30,000 -100% - 51- 000 -65 -00 -5804 OPERATING SUPPLIES 41,750 48,500 3% 50,000 51- 000 -65 -00 -5808 POSTAGE & SHIPPING 14,002 15,000 20% 18,000 51- 000 -65 -00 -5809 PRINTING & COPYING 9,610 9,075 21% 11,000 51- 000 -65 -00 -5810 PUBLISHING & ADVERTISING 150 1,000 0% 1,000 51- 000 -65 -00 -5812 GASOLINE 21,296 15,000 133% 35,000 51- 000 -65 -00 -5815 HAND TOOLS 20 2,000 -50% 1,000 51- 000 -65 -00 -5817 GRAVEL 2,256 6,000 -17% 5,000 51- 000 -65 -00 -5820 CHEMICALS 18,098 30,000 -100% 51- 000 -65 -00 -5821 CATHODIC PROTECTION - 0 0% - A- 000 -65 -00 -5822 WATER SAMPLES 21,412 12,000 17% 14,000 51- 000 -72 -00 -6500 IMRF PARTICIPANTS 23,343 28,317 -10% 25,467 51- 000 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 23,026 28,071 -9% 25,601 Page 25 of 39 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL WATER OPERATIONS 2005 -2006 2006 - 2007 % 2007 -2008 ACCOUNT NUMBER DESCRIPTION Actual Budget Change Budget EXPENSES CONT'D ' 51- 000 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 2,570 5,000 -70% 1,500 10 51- 000 -75 -00 -7004 SAFETY EQUIPMENT 2,385 3,000 0% 3,000 51- 000 -75 -00 -7506 METER READERS 7,177 11,500 4% 12,000 51- 000 -75 -00 -7507 HYDRANT REPLACEMENT 1,976 10,000 0% 10,000 51- 000 -75 -00 -7508 METERS & PARTS 285,457 265,000 13% 300,000 51- 000 -78 -00 -9005 REFUND - 1,500 0% 1,500 11 51- 000 -62 -00 -5407 TREATMENT FACILITIES O & M 73,749 100,000 57% 157,000 51- 000 -78 -00 -9006 MERIT - 10,543 13% 11,910 SALARY SURVEY - 0 100% 16,510 51- 000 -78 -00 -9009 RESERVE - 373,105 -41% 221,557 51- 000 -99 -00 -9901 TRANSFER TO GENERAL FUND 200,000 250,000 0% 250,000 51- 000 -99 -00 -9950 TRANSFER TO PW EQUIP CAPITAL 50,000 50,000 -100% - TOTAL EXPENSES: 1,474,211 1,922,000 -9% 1,754,683 TOTAL FUND REVENUES 2,015,517 1,922,000 1,754,683 TOTAL FUND EXPENSES 1,474,211 1,922,000 1,754,683 rUND SURPLUS (DEFICIT) 541,307 0 0 COMMENTS: 1 1,000 meters @390 each 2 Sprint Contract and PDQ 3 Add locate requests 4 new items pw cleaning, alarm monitoring 5 move to treatment facility 6 5 employees + 1 new employee @18.85 per emp per week = $2,761 sweatshirt $40; work coat $85; winter coat $109; coveralls $95; boots $150; gloves $20; hat $10; rub boots $75; hard hat $20; vest $30; t -shirts $75 TOTAL $709 Repl. Boots x 5 $750; Repl. Gear X 5 $500; summer help t -shirts $100; TOTAL $4,820 7 24% increase 8 5 emp. @ 35 /mo. = $2100 + 1 new emp = $2520; 1 new phone @150 + 2 replac @150 = $450; batteries, clips, repairs = $300 9 National = flight - $400, lodging 5 nights @ $150; Meals 5 days @$40 /day conf cost $700, reimburseables - $100 - $2,150; Reg'I = flight $250, lodging 3 nights @ $150; Meals 3 @$40; conf cost $200, reimbur $100 - $1,120 State lodging 3 X $150, meals 3 X $40. local conf $300, reimb $100 Brian $3,370; Joe M $1,070; Brett $1,070, Kevin $1,070; Mike $150;1/3 Eric $1,513 10 4 office $1,000 & Antivirus 11 move to treatment facility Page 26 of 39 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL SEWER MAINTENANCE , .:,COUNT 2005 -2006 2006 -2007 % 2007 -2008 NUMBER DESCRIPTION Actual Budget Change Budget REVENUES 52- 000 -40 -00 -3999 CARRY OVER /FUND BALANCE 327,526 350,000 -100% - 52- 000 -42 -00 -4240 LIFT STATION INCOME - 8,000 0% 8,000 1 52- 000 -42 -00 -4250 SEWER MAINTENANCE FEES 478,385 475,000 2% 486,000 2 52- 000 -42 -00 -4251 SEWER CONNECTION FEES 180,600 260,000 0% 260,000 52- 000 -46 -00 -4600 INVESTMENT INCOME 25,154 15,000 0% 15,000 TOTAL REVENUES: 1,011,665 1,108,000 -31% 769,000 EXPENSES 52- 000 -50 -00 -5108 SALARIES - REGULAR 108,174 141,858 9% 154,756 52- 000 -50 -00 -5136 PART TIME 2,300 4,200 19% 5,000 3 52- 000 -50 -00 -5137 SALARIES- OVERTIME 3,060 12,000 0% 12,000 52- 000 -62 -00 -5401 CONTRACTUAL SERVICES 4,090 5,000 60% 8,000 4 52- 000 -62 -00 -5408 MAINTENANCE - EQUIPMENT 5,112 5,000 0% 5,000 52- 000 -62 -00 -5409 MAINTENANCE - VEHICLES 668 4,000 0% 4,000 52- 000 -62 -00 -5419 MAINTENANCE - SANITARY SEWER 11,877 27,500 -27% 20,000 52- 000 -62 -00 -5421 WEARING APPAREL 3,398 3,500 -33% 2,350 5 52- 000 -62 -00 -5422 LIFT STATION MAINTENANCE 23,232 25,000 0% 25,000 - 000 -62 -00 -5434 RENTAL - EQUIPMENT - 1,000 0% 1,000 ;,z- 000 -62 -00 -5435 ELECTRICITY 33,628 14,400 421% 75,000 52- 000 -62 -00 -5438 CELLULAR TELEPHONE 2,328 2,500 -30% 1,750 6 52- 000 -64 -00 -5604 TRAINING & CONFERENCES 526 4,000 -50% 2,000 7 52- 000 -64 -00 -5605 TRAVEL / MEALS / LODGING 849 3,000 0% 3,000 52- 000 -65 -00 -5800 CONTINGENCIES - 10,000 -49% 5,054 52- 000 -65 -00 -5802 OFFICE SUPPLIES 2,179 2,500 20% 3,000 52- 000 -65 -00 -5805 SHOP SUPPLIES 1,457 2,500 20% 3,000 52- 000 -65 -00 -5812 GASOLINE 15,735 14,000 11% 15,500 52- 000 -65 -00 -5815 HAND TOOLS 415 2,000 -50% 1,000 52- 000 -65 -00 -5817 GRAVEL 1,216 3,000 0% 3,000 52- 000 -72 -00 -6500 IMRF PARTICIPANTS 8,999 12,155 10% 13,344 52- 000 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 8,672 12,091 11% 13,414 52- 000 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 443 2,500 -20% 2,000 52- 000 -75 -00 -7003 OFFICE EQUIPMENT 2,269 6,000 0% 6,000 8 52- 000 -75 -00 -7004 SAFETY EQUIPMENT 1,207 2,000 0% 2,000 52- 000 -78 -00 -9005 MERIT - 5,282 17% 6,190 SALARY SURVEY - 0 100% 9,397 52- 000 -78 -00 -9009 RESERVE 9,800 676,013 -56% 296,667 52- 000 -99 -00 -9901 TRANSFER TO GENERAL FUND 70,000 70,000 1% 70,578 52- 000 -99 -00 -9950 TRANSFER TO PW EQUIP CAPITAL 30,000 30,000 -100% - TOTAL EXPENSES: 353,961 1,108,000 -31% 769,000 , JTAL FUND REVENUES 1,011,665 1,108,000 769,000 TOTAL FUND EXPENSES 353,961 1,108,000 769,000 FUND SURPLUS (DEFICIT) 657,705 0 0 Page 27 of 39 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL SEWER MAINTENANCE ..;COUNT 2005 -2006 2006 -2007 % 2007 -2008 NUMBER DESCRIPTION Actual Budget Change Budget SEWER MAINTENANCE COMMENTS: 1 MPI Lift Station Grande Reserve 2 18 *6 *4,500 accounts 3 1 seasonal $9 hr *12wks + extra 4 alarm monitoring & Contract costs 5 3 employees @ 8.85 per emp per week .= $1,400; Repl boots X 3 = $450; Repl gear X 3 =$300; Summer help t- shirts $100; employee t- shirts $100; TOTAL $2,350 6 3 emp. @ 35 /mo. = $1260; 1 repl phone $150; batteries, clips, repairs $300 7 National = flight - $400, lodging 5 nits @ $150, meals 5 days @$40 day; conf cost $700 Reimburseable $100; TOTAL $2,150; Reg'I flight $250 lodging 3 nites @$150, Meals 3 X $40; conf cost $200, reimbursables $100; TOTAL $1,120 State lodging 3 X $150, meals 3 X $40, conf cost $300, reimbursables $100; TOTAL $970 Dave 1 nat'I, 1 state, 2 local $3,370; Tony 2 local $100; Matt 2 local $100 Eric 1 nat'I, 1 reg'I, 1 state $1,413 8 desks for PW remodel Page 28 of 39 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL LAND CASH _.,COUNT 2005 -2006 2006 -2007 % 2007 -2008 NUMBER DESCRIPTION Actual Budget Change Budget REVENUES 72- 000 -40 -00 -3999 CARRY OVER / STARTING BALANCE 442,437 (202,757) -74% (52,757) 72- 000 -47 -00 -4700 OSLAD GRANT - 0 100% 400,000 1 72- 000 -47 -00 -4700 OSLAD GRANT 74,000 362,000 0% 362,000 2 72- 000 -47 -00 -4702 Bike Path Grant - 0 100% 200,000 3 72- 000 -47 -00 -4705 COUNTRY HILLS -LAND CASH 6,921 30,825 -96% 1,200 72- 000 -47 -00 -4712 RIVER'S EDGE -LAND CASH 13,420 13,285 -80% 2,684 72- 000 -47 -00 -4717 KYLYN'S CROSSING - LAND CASH - 3,367 -53% 1,570 72- 000 -47 -00 -4723 HEARTLAND CIRCLE -LAND CASH 49,000 49,500 -60% 20,000 72- 000 -47 -00 -4734 WHISPERING MEADOWS - (Kimball Hill) 46,240 41,868 -66% 14,100 72- 000 -47 -00 -4738 Autumn Creek 55,241 85,765 -74% 22,280 72- 000 -47 -00 -4736 Corner Stepe BRIARWOOD - 113,043 0% 113,043 72- 000 -47 -00 -4740 Villas at the Preserve 3,469 90,008 -15% 76,335 72- 000 -47 -00 -4744 HUDSON LAKES - 28,449 -65% 10,000 72- 000 -47 -00 -4745 PRESTWICK - 76,303 -74% 20,000 72- 000 -47 -00 -4746 WESTBURY EAST - 62,414 -68% 20,000 Kendallwood Estates 100% 10,000 TRANSFER FROM GENERAL FUND - - 100% 48,245 TAL REVENUES: 702,925 1,830,052 -31% 1,268,700 EXPENSES 72- 000 -75 -00 -7308 Rivers Edge Park # II 26,901 0 100% 25,000 72- 000 -75 -00 -7326 Mosier Holding Costs - 0 100% 15,700 72- 000 -75 -00 -7328 PRAIRIE MEADOWS - (Menards Res.) - 6,000 7267% 442,000 72- 000 -75 -00 -7330 WHISPERING MEADOWS - (Kimball Hill) 19,811 724,000 -3% 700,000 72- 000 -75 -00 -7333 RAINTREE VILLAGE - 80,000 -88% 10,000 4 72- 000 -75 -00 -7334 HOOVER HOLDING COSTS - 100,000 -40% 60,000 5 72- 000 -78 -00 -9009 RESERVE 385,674 212,809 - 100% - 6 72- 000 -99 -00 -9901 TRANSFER TO GENERAL FUND - 16,000 0% 16,000 7 TOTAL EXPENSES: 792,787 1,882,809 -33% 1,268,700 TOTAL FUND REVENUES 702,925 1,830,052 1,268,700 TOTAL FUND EXPENSES 792,787 1,882,809 1,268,700 FUND SURPLUS (DEFICIT) (89,862) (52,757) 0 COMMENTS: 1 Prairie Meadows 2 Whispering Meadows 3 New for 07/08 4 OSLAD Grant 5 Possibly eliminate $165,000 6 Removed - To eliminate Hoover hd cost 7 Designer Salary Page 29 of 39 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL LAND ACQUISITION 2005 -2006 2006 -2007 2007 -2008 ACCOUNT NUMBER DESCRIPTION Actual Budget % Change Budget REVENUES 73- 000 -40 -00 -3999 CARRY OVER BALANCE 213,618 213,618 -77% 50,000 73- 000 -49 -00 -4935 TRANSFER FROM LAND CASH - 0 0% - TOTAL REVENUES: 213,618 213,618 -77% 50,000 EXPENSES 73- 000 -65 -00 -5800 CONTINGENCY - 50,000 0% 50,000 TOTAL EXPENSES: - 213,618 -77% 50,000 TOTAL FUND REVENUES 213,618 213,618 50,000 TOTAL FUND EXPENSES - 213,618 50,000 FUND SURPLUS (DEFICIT) 213,618 0 0 I III Page 30 of 39 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL PARKS & RECREATION 2005 -2006 2006 -2007 % 2007 -2008 ACCOUNT NUMBER DESCRIPTION Actual Budget Change Budget REVENUES 79- 000 -40 -00 -3999 CARRY OVER BALANCE 142,356 50,000 -100% - 79- 000 -42 -00 -4270 FEES FOR PROGRAMS 235,917 266,000 -6% 250,000 1 79- 000 -42 -00 -4280 CONCESSIONS /ALL SALE ITEMS 14,428 15,000 72% 25,864 79- 000 -42 -00 -4281 €?EECHER BLDG DEPOSITS 6,755 1,500 0% 1,500 79- 000 -42 -00 -4285 VENDING MACHINE INCOME 459 650 -38% 400 79- 000 -42 -00 -4287 PARK RENTAL INCOME 390 1,000 -40% 600 79- 000 -42 -00 -4288 GOLF OUTING REVENUE 40,160 38,000 7% 40,700 79- 000 -42 -00 -4291 HOMETOWN DAYS - 30,000 293% 118,000 79- 000 -44 -00 -4400 DONATIONS 14,843 15,000 27% 19,000 79- 000 -44 -00 -4404 TREE DONATIONS 900 600 33% 800 79- 000 -45 -00 -4550 YOUTH SERVICES GRANT 2,000 2,000 0% 2,000 79- 000 -46 -00 -4600 INVESTMENT INCOME 11,576 6,500 54% 10,000 79- 000 -49 -00 -4901 TRANSFER FROM GENERAL FUND 755,908 1,046,127 11% 1,161,778 TOTAL REVENUES: 1,228,053 1,472,377 11% 1,630,642 PARKS EXPENSES 79- 610 -50 -00 -5107 SALARIES- EMPLOYEES 287,508 383,107 -12% 339,047 79- 610 -50 -00 -5136 SALARIES - PART -TIME 38,528 48,000 21% 58,000 9- 610 -50 -00 -5137 SALARIES - OVERTIME 2,011 8,000 13% 9,000 19- 610 -61 -00 -5320 MASTER PLAN / COMMUNITY SURVEY - 0 0% 13,000 79- 610 -62 -00 -5405 PARK CONTRACTUAL 15,624 18,000 25% 22,500 2 79- 610 -62 -00 -5408 MAINTENANCE - EQUIPMENT 9,161 10,000 0% 10,000 79- 610 -62 -00 -5417 MAINTENANCE -PARKS 34,250 40,000 25% 50,000 79- 610 -62 -00 -5421 WEARING APPAREL 6,363 8,000 0% 8,000 79- 610 -62 -00 -5434 RENTAL - EQUIPMENT 612 1,700 18% 2,000 79- 610 -62 -00 -5438 CELLULAR TELEPHONE 3,903 5,750 -13% 5,000 79- 610 -62 -00 -5445 LEGAL EXPENSES 2,213 10,000 -50% 5,000 79- 610 -64 -00 -5604 TRAINING AND CONFERENCE - 0 100% 9,000 3 79- 610 -64 -00 -5605 TRAVEL EXPENSE 2,792 3,800 -21% 3,000 79- 610 -65 -00 -5802 OFFICE SUPPLIES 1,569 1,500 0% 1,500 79- 610 -65 -00 -5804 OPERATING SUPPLIES 25,545 30,000 0% 30,000 79- 610 -65 -00 -5815 HAND TOOLS 4,116 3,000 17% 3,500 79- 610 -65 -00 -5824 CHRISTMAS DECORATIONS 6,409 7,000 -29% 5,000 79- 610 -65 -00 -5825 PUBLIC DECORATION 1,160 3,000 0% 3,000 79- 610 -72 -00 -6500 IMRF PARTICIPANTS 22,694 30,897 2% 31,420 79- 610 -72 -00 -6501 SOCIAL SECURITY /MEDICARE 24,250 33,592 -6% 31,585 79- 610 -75 -00 -7003 OFFICE EQUIPMENT 1,424 6,000 -50% 3,000 79- 610 -75 -00 -7701 FLOWERS/TREES 5,746 7,000 14% 8,000 SALARY SURVEY - 0 100% 15,827 79- 610 -78 -00 -9005 MERIT - 11,053 14% 12,642 TOTAL EXPENSES: PARKS 503,366 691,899 -2% 679,020 Page 31 of 39 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL PARKS & RECREATION 2005 -2006 2006 -2007 % 2007 -2008 ACCOUNT NUMBER DESCRIPTION Actual Budget Change Budget RECREATION EXPENSES 79- 650 -50 -00 -5107 EMPLOYEE SALARIES 254,258 312,226 15% 358,532 79- 650 -50 -00 -5108 PRE SCHOOL SALARIES - 87,000 -3% 84,000 79- 650 -50 -00 -5150 SALARIES - INSTRUCTOR CONTRACTUA 125,146 58,400 -2% 57,400 79- 650 -50 -00 -5155 SALARIES - RECORDING SECRETARY 2,052 3,000 -17% 2,500 79- 650 -50 -00 -5108 CONCESSION STAFF 3,281 4,000 69% 6,750 79- 650 -62 -00 -5408 MAINTENANCE SUPPLIES 6,728 5,000 40% 7,000 79- 650 -62 -00 -5409 MAINTENANCE - VEHICLES 484 1,200 192% 3,500 79- 650 -62 -00 -5410 MAINTENANCE - OFFICE EQUIPMENT 4,779 6,500 0% 6,500 79- 650 -62 -00 -5426 YOUTH SERVICES GRANT EXPENSES 539 2,000 0% 2,000 79- 650 -62 -00 -5437 TELEPHONE /INTERNET 446 1,600 -19% 1,300 79- 650 -62 -00 -5438 CELLULAR TELEPHONE 4,574 6,500 -15% 5,500 79- 650 -62 -00 -5445 PORTABLE TOILETS 3,990 5,000 20% 6,000 79- 650 -62 -00 -5603 PUBLISHING /ADVERTISING 23,444 25,700 9% 27,920 79- 650 -62 -00 -5605 BOOKS /PUBLICATIONS 584 750 -33% 500 79- 650 -62 -00 -5606 RCC �T DEPOSIT REFUND 5,695 1,500 0% 1,500 79- 650 -64 -00 -5600 DUES 1,462 2,700 -7% 2,500 79- 650 -64 -00 -5604 TRAINING AND CONFERENCE - 7,500 36% 10,200 4 79- 650 -64 -00 -5605 TRAVEL EXPENSE 1,960 2,500 109% 5,220 79- 650 -65 -00 -5802 OFFICE SUPPLIES 6,058 7,000 0% 7,000 1 - 650 -65 -00 -5803 PROGRAM EXPENSES 47,176 50,400 - 1% 50,100 9- 650 -65 -00 -5804 OPERATING SUPPLIES 5,191 4,200 -10% 3,800 79- 650 -65 -00 -5805 RECREATION EQUIPMENT 3,544 8,000 -11% 7,100 79- 650 -65 -00 -5808 POSTAGE & SHIPPING 7,565 7,200 6% 7,600 79- 650 -65 -00 -5812 GASOLINE 1,573 3,600 17% 4,200 79- 650 -65 -00 -5826 MILEAGE 818 750 0% 750 79- 650 -65 -00 -5827 GOLF OUTING EXPENSES 21,945 20,000 15% 23,000 79- 650 -65 -00 -5833 HOMETOWN DAYS EXPENSES - 25,000 332% 108,000 79- 650 -65 -00 -5828 CONCESSIONS 11,660 9,000 72% 15,500 79- 650 -65 -00 -5840 SCHOLARSHIPS 1,570 3,600 0% 3,600 79- 650 -65 -00 -5841 PROGRAM REFUND 11,688 7,000 -7% 6,500 79- 650 -72 -00 -6500 IMRF PARTICIPANTS 22,246 24,666 47% 36,346 79- 650 -72 -00 -6501 SOCIAL SECURITY /MEDICARE 25,999 35,544 3% 36,537 79- 650 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 6,755 4,750 -57% 2,025 5 RESERVE - 27,688 -36% 17,700 SALARY SURVEY - 0 100% 15,559 79- 650 -78 -00 -9005 MERIT - 9,004 94% 17,482 TOTAL EXPENSES: RECREATION 620,636 780,478 22% 951,622 TOTAL FUND REVENUES 1,228,053 1,472,377 11% 1,630,642 TOTAL FUND EXPENSES 1,124,002 1,472,377 11% 1,630,642 FUND SURPLUS (DEFICIT) 104,050 0 0 Page 32 of 39 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL PARKS & RECREATION 2005 -2006 2006 -2007 % 2007 -2008 ACCOUNT NUMBER DESCRIPTION Actual Budget Change Budget PARKS & RECREATION COMMENTS: 1 Drop due to not doing third pre - school 2 Work internal staff can't do 3 See Dave Mogule's Memo in the Appendix 4 See Dave Mogule's Memo in the Appendix 5 $5,000 Server; Micro Office $1,400; $400 Antivirus: 1 monitor $225 I I Page 33 of 39 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL LIBRARY ACCOUNT 2005 -2006 2006 -2007 2007 -2008 NUMBER DESCRIPTION Actual Budget % Change Budget REVENUES 82- 000 -40 -00 -3999 CARRY OVER 231,590 231,590 41% 325,749 82- 000 -40 -00 -4000 REAL ESTATE TAXES 356,387 464,741 21% 560,702 82- 000 -40 -00 -4010 PERSONAL PROPERTY TAX 3,398 2,500 34% 3,360 82- 000 -42 -00 -4211 DEVELOPMENT FEES - BUILDING 99,300 95,000 58% 150,000 82- 000 -42 -00 -4215 DEVELOPMENT FEES -BOOKS 99,300 95,000 58% 150,000 82- 000 -42 -00 -4260 COPY FEES 1,286 900 36% 1,221 82- 000 -42 -00 -4261 LIBRARY SUBSCRIPTION CARDS 10,400 8,000 6% 8,500 82- 000 -42 -00 -4286 RENTAL INCOME 1,303 1,000 -4% 960 82- 000 -43 -00 -4330 LIBRARY FINES 4,000 3,000 -6% 2,808 82- 000 -44 -00 -4432 SALE OF BOOKS 518 500 129% 1,144 82- 000 -44 -00 -4450 MEMORIALS 1,522 5,000 -36% 3,202 82- 000 -45 -00 -4550 GRANTS - 1,000 1650% 17,500 82- 000 -46 -00 -4600 INVESTMENT INCOME 15,693 1,500 307% 6,102 TOTAL REVENUES: 1,204,928 8,316,562 -85% 1,231,248 EXPENSES 92- 000 -50 -00 -5107 SALARIES- EMPLOYEES 165,445 350,000 35% 471,377 s2- 000 -50 -00 -5203 GROUP HEALTH INSURANCE 36,678 55,000 -17% 45,717 82- 000 -50 -00 -5205 DENTAL & VISION ASSISTANCE 3,014 6,000 -30% 4,200 82- 000 -61 -00 -5322 BONDING 1,014 2,000 -41% 1,176 82- 000 -61 -00 -5323 ATTORNEY 863 2,000 75% 3,500 82- 000 -62 -00 -5407 MAINTENANCE - BLDG /JANITORIAL 3,730 5,000 0% 5,000 82- 000 -62 -00 -5410 MAINTENANCE - OFFICE EQUIPMEN 2,992 3,000 67% 5,000 82- 000 -62 -00 -5412 MAINTENANCE - PHOTOCOPIER 411 1,000 1168% 12,680 82- 000 -62 -00 -5435 ELECTRICITY 1,419 2,500 1400% 37,500 82- 000 -62 -00 -5436 TELEPHONE 1,558 1,700 253% 6,000 82- 000 -62 -00 -5437 GAS HEAT - 7,000 614% 50,000 82- 000 -64 -00 -5604 TRAINING & CONFERENCES 20 1,500 33% 2,000 82- 000 -64 -00 -5607 PUBLIC RELATIONS 121 1,000 150% 2,500 82- 000 -64 -00 -5616 EMPLOYEE RECOGNITION 723 2,000 0% 2,000 82- 000 -65 -00 -5800 CONTINGENCIES 1,739 22,031 13% 25,000 82- 000 -65 -00 -5806 LIBRARY SUPPLIES 3,124 8,000 25% 10,000 82- 000 -65 -00 -5807 CUSTODIAL SUPPLIES 3,072 10,000 -10% 9,000 82- 000 -65 -00 -5808 POSTAGE & SHIPPING 843 1,000 300% 4,000 82- 000 -65 -00 -5810 PUBLISHING & ADVERTISING 586 1,000 100% 2,000 82- 000 -65 -00 -5826 MILEAGE 578 1,000 0% 1,000 82- 000 -65 -00 -5832 VIDEOS 2,678 5,000 0% 5,000 82- 000 -65 -00 -5833 ALARM MONITORING 931 1,000 200% 3,000 92- 000 -65 -00 -5834 LIBRARY PROGRAMMING 6,140 12,000 -17% 10,000 ,2- 000 -65 -00 -5835 LIBRARY BOARD EXPENSES 75 1,000 100% 2,000 82- 000 -65 -00 -5836 BOOKS -ADULT 9,027 10,000 200% 30,000 82- 000 -65 -00 -5837 BOOKS - JUVENILE 9,058 10,000 200% 30,000 Page 34 of 39 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL LIBRARY ACCOUNT 2005 -2006 2006 -2007 2007 -2008 NUMBER DESCRIPTION Actual Budget % Change Budget LIBRARY EXPENSES CONT'D 82- 000 -65 -00 -5838 BOOKS -AUDIO 6,415 10,000 0% 10,000 82- 000 -65 -00 -5839 BOOKS - REFERENCE 9,346 10,000 200% 30,000 82- 000 -65 -00 -5840 BOOKS - DEVELOPMENT FEE 23,782 95,000 58% 150,000 82- 000 -65 -00 -5841 MEMORIALS /GIFTS 2,093 5,000 -36% 3,202 82- 000 -65 -00 -5842 BLDG - DEVELOPMENT FEES 46,697 95,000 58% 150,000 82- 000 -65 -00 -5843 CD's /Music 100% 5,000 82- 000 -72 -00 -6500 IMRF PARTICIPANTS 7,426 9,000 74% 15,641 82- 000 -72 -00 -6501 SOCIAL SECURITY /MEDICARE 12,657 26,250 51% 39,755 82- 000 -75 -00 -7002 Computer Equipment & Software 100% 18,000 82- 000 -75 -00 -7003 AUTOMATION 10,543 164,700 -82% 30,000 82- 000 -75 -00 -7703 BUILDING EXPANSION 2,281,851 7,363,881 -100% - TOTAL EXPENSES: 2,664,736 8,316,562 -85% 1,231,248 TOTAL FUND REVENUES 1,204,928 8,316,562 1,231,248 TOTAL FUND EXPENSES 2,664,736 8,316,562 1,231,248 FUND SURPLUS (DEFICIT) (1,459,808) 0 0 Page 35 of 39 UNITED CITY OF YORKVILLE FY 07108 BUDGET FINAL FOX INDUSTRIAL ACCOUNT 2005 -2006 2006 -2007 2007 -2008 NUMBER DESCRIPTION Actual Budget % Change Budget REVENUES 85- 000 -40 -00 -3999 CARRY OVER BALANCE 11,817 30,000 67% 50,000 85- 000 -40 -00 -4090 TIF REVENUES 70,997 75,000 0% 75,000 85- 000 -46 -00 -4600 INVESTMENT INCOME 3,290 3,000 17% 3,500 85- 000 -49 -00 -4905 TRANSFER FROM MFT FUND 31,190 0 0% - TOTAL REVENUES: 117,293 108,000 19% 128,500 EXPENSES 85- 000 -66 -00 -6021 FOX IND BOND - PRINCIPAL PMT 55,000 60,000 0% 60,000 85- 000 -66 -00 -6022 FOX IND BOND -INT PAYMENT 11,225 20,415 -12% 18,015 85- 000 -75 -00 -7901 FOX IND NON MFT PAYMENT 233 0 0% - 85- 000 -75 -00 -7902 FOX INDUSTRIAL EXPENSES 5,068 0 0% - 85- 000 -78 -00 -9007 ADMINISTRATION FEES 1,744 300 25% 375 85- 000 -78 -00 -9010 RESERVE - FUTURE BOND PYMT - 27,285 84% 50,110 TOTAL EXPENSES: 73,269 108,000 19% 128,500 TOTAL FUND REVENUES 117,293 108,000 128,500 OTAL FUND EXPENSES 73,269 108,000 128,500 FUND SURPLUS (DEFICIT) 44,024 0 0 r Page 36 of 39 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL COUNTRYSIDE TIF 2005 -2006 2006 -2007 % 2007 -2008 ACCOUNT NUMBER DESCRIPTION Actual Budget Change Budget REVENUES 87- 000 -40 -00 -3999 CARRY OVER BALANCE 3,456,521 3,000,000 0% 3,000,000 87- 000 -40 -00 -4090 TIF REVENUES - 0 0% - 87- 000 -46 -00 -4600 INVESTMENT INCOME 109,570 75,000 0% 75,000 TOTAL REVENUES: 3,566,092 3,075,000 0% 3,075,000 EXPENSES 87- 000 -66 -00 -6021 BOND - PRINCIPAL PMT - 0 0% - 87- 000 -66 -00 -6022 BOND -INT PAYMENT - 142,868 0% 142,868 87- 000 -78 -00 -9007 ADMINISTRATION FEES 825 2,500 0% 2,500 87- 000 -78 -00 -9010 RESERVE - FUTURE BOND PYMT - 2,929,632 0% 2,929,632 TOTAL EXPENSES: 825 3,075,000 0% 3,075,000 )TAL FUND REVENUES 3,566,092 3,075,000 3,075,000 TOTAL FUND EXPENSES 825 3,075,000 3,075,000 FUND SURPLUS (DEFICIT) 3,565,267 0 0 Page 37 of 39 UNITED CITY OF YORKVILLE FINAL Options #1 New Hires Department Position Salary Hire Time Frame 1 FT Water & Sewer Super of Water & Sewer $ 57,000 June 1 1 FT Com Develop Administrative Assistant $ 20,000 July 2 1 Finance Human Resource Manager $ 5,000 June 3 1 FT Finance Assistant Finance Director $ 20,000 January 2008 4 1 FT Police Police Officer $ 36,500 July 5 1 FT Police Police Officer $ 29,200 September 6 2 FT Police Police Officer $ 14,600 March 2008 $ 125,300 NEW HIRE COMMENTS: 1 This will be funded from the Water & Sewer Fund Reserves 2 This will be funded from the General Fund 3 Promotion for the Payroll /Benefits Coor 4 Newly created position based on new audit requirements - this will also allow the Finance Director to focus on forecasting 5 Additional Staff 6 Additional Staff #2 Covers Corlands shortfall in case the the Forest Preserve Referendum does not pass in April $ 105,000 Land Acquistion (50,000) Additional Shortfall 55,000 Take this from Park & Recreation (allow Dave to pick where he can cut for this) Page 38 of 39 UNITED CITY OF YORKVILLE FY 07/08 BUDGET FINAL Additional Requests during revisions: Department Old Title New Title Requested Amount Comments Sewer Promotion 1 Water Foreman Same $3.40 an hour / $7,075 a year Employee has been with the City for 6 years, 2 years in this position. Adjusting salary to be in line with the other Foremen. *Funds can be taken from the reserve line item in sewer. * *This will be reviewed & approved by the City Administrator Water Promotion 1 MW I MWII $2.04 an hour / $4,245 a year Employee has been with the City Full Time for 7 months. *Funds can be taken from the reserve line item in water. Streets Promotion 1 MWII Operator $2.23 an hour / $4,640 a year *Funds can be transferred from the water reserve to the general fund to cover this. Page 39 of 39