Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Ordinance 2007-095
STATE OF ILLINOIS COUNTY OF KENDALL FILED - STATE OF ILLINOIS ) DEC 2 0 2007 )SS COUNiY CLERK COUNTY KENDALL ) KENDALL COUNTY. ORDINANCE NO. 2007- °►5 ORDINANCE APPROVING THE REVISION OF THE 2007 -2008 FISCAL BUDGET FOR THE UNITED CITY OF YORKVILLE WHEREAS, the Mayor and City Council of the UNITED CITY OF YORKVILLE have i duly allowed Public input, and through its committee system has duly considered revision of the 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 revised I 2007 -2008 Fiscal Year Budget being submitted on December 4, 2007 at its regular Administration Committee Meeting: NOW THEREFORE, upon Motion duly made, seconded and approved by a majority of those so voting, revision of the 2007 -2008 Budget as presented is hereby adopted for the 2007- 2008 Fiscal Year. i Page 1 of 2 ADOPTED this \ \ day of December, 2007, pursuant to a roll call vote as follows: ROBYN SUTCLIFF JOSEPH BESCO ARDEN JOE PLOCHER WALLY WERDERICH GARY GOLINSKI LA MARTY MUNNS u ROSE SPEARS JASON LESLIE i Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this \\ day of , A.D. 2007. V� MAYOR Passed by the City Council of the United City of Yorkville, Kendall County, Illinois this \\ day o A.D. 2007. I ATTEST: CITY CLERK �I Page 2 of 2 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL GENERALFUND ACCOUNT 2006- 2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Budget Change Budget YTD BUDGET GENERAL FUND REVENUES 01- 000 -40 -00 -3999 RESERVE FUND BALANCE 372,849 -66% 125,000 62,500 125,000 1 CARRY OVER FY 06/07 - 415,940 01- 000 -40 -00 -3991 CARRY OVER FY 05/06 417,177 - 417,177 01- 000 -40 -00 -3992 LIBRARY BOND PAYBACK 160,000 160,000 160,000 01- 000 -40 -00 -3993 EMPLOY CONTRIB HEALTH REIMB 18,000 55,403 100,000 01- 000 -40 -00 -3994 AMUSEMENT TAX 135,000 - - 01- 000 -40 -00 -3995 CIB / CD'S IN BANK 104,000 - 104,000 3 01- 000 -40 -00 -3996 ROAD CONTRIBUTION FEE 1,500,000 -20% 1,200,000 508,000 800,000 4 01- 000 -40 -00 -3997 IN -TOWN ROAD PROGRAM FUND 2,070,000 24% 2,575,000 - 2,575,000 5 01- 000 -40 -00 -3998 ROAD FUNDING - MPI 1,600,000 -38% 1,000,000 - 1,000,000 6 01- 000 -40 -00 -4000 REAL ESTATE TAXES 1,571,133 15% 1,810,490 1,860,388 1,860,387 7 01- 000 -40 -00 -4001 TOWN ROAD /BRIDGE TAX 105,000 19% 125,000 109,442 125,000 8 01- 000 -40 -00 -4002 FOX HILL LEVY REVENUE 18,000 0% 18,000 15,426 18,000 9 01- 000 -40 -00 -4010 PERSONAL PROPERTY TAX 10,000 0% 10,000 7,283 10,000 01- 000 -40 -00 -4020 STATE INCOME TAX 885,000 10% 974,748 205,189 974,748 10 01- 000 -40 -00 -4030 MUNICIPAL SALES TAX 2,845,000 10% 3,120,000 907,054 2,775,000 01- 000 -40 -00 -4032 STATE USE TAX 137,000 5% 144,532 50,731 144,532 11 01- 000 -40 -00 -4040 MUNICIPAL UTILITY TAX 375,000 13% 425,000 133,560 425,000 01- 000 -40 -00 -4041 UTILITY TAX - NICOR 250,000 20% 300,000 176,358 350,000 01- 000 -40 -00 -4042 UTILITY TAX - CABLE TV 90,000 43% 129,144 40,872 150,000 01- 000 -40 -00 -4043 UTILITY TAX - TELEPHONE 425,000 0% 425,000 206,390 425,000 01- 000 -40 -00 -4050 HOTEL TAX 20,000 0% 20,000 10,298 20,000 01- 000 -40 -00 -4060 TRAFFIC SIGNAL REVENUE 5,000 0% 5,000 8,779 8,775 01- 000 -41 -00 -4100 LIQUOR LICENSE 26,000 0% 26,000 27,316 27,316 01- 000 -41 -00 -4101 OTHER LICENSES 4,500 -33% 3,000 3,403 3,400 01- 000 -41 -00 -4110 BUILDING PERMITS 1,550,000 0% 1,550,000 593,317 1,200,000 01- 000 -42 -00 -4205 FILING FEES 25,000 -20% 20,000 1,527 10,000 01- 000 -42 -00 -4206 GARBAGE SURCHARGE 227,648 138% 540,756 284,573 540,756 01- 000 -42 -00 -4208 COLLECTION FEE - YBSD 35,000 0% 35,000 55,916 55,916 01- 000 -42 -00 -4210 DEVELOPMENT FEES 1,475,000 0% 1,475,000 963,882 1,475,000 01- 000 -42 -00 -4211 ENGINEERING CAPITAL FEE 52,000 15% 60,000 24,700 48,000 12 01- 000 -43 -00 -4310 TRAFFIC FINES 75,000 7% 80,000 54,102 80,000 01- 000 -43 -00 -4315 REIMBURSE POLICE TRAINING 11,805 78% 21,000 15,106 21,000 01- 000 -43 -00 -4320 ORDINANCE FEES 2,500 0% 2,500 2,305 2,500 01- 000 -44 -00 -4401 DARE DONATIONS 1,250 0% 1,250 - 1,250 01- 000 -44 -00 -4402 ROB ROY CREEK HYDRAULIC STUDY 10,000 0% 10,000 - 10,000 13 01- 000 -44 -00 -4404 HANGING BASKET DONATIONS - 450 450 01- 000 -44 -00 -4405 RAYMOND SEWER OUTFALL 0 100% 1,300,000 - - 01- 000 -44 -00 -4407 HOLIDAY UNDER THE STARGS 0 - 6,168 01- 000 -44 -00 -4411 REIMB- POLICE PROTECTION 3,000 10% 3,300 2,733 3,300 01- 000 -44 -00 -4490 MISCELLANEOUS INCOME 10,000 50% 15,000 2,913 3,500 01- 000 -45 -00 -4505 COPS GRANT - VESTS 2,500 20% 3,000 - 3,000 01- 000 -45 -00 -4511 POLICE - STATE TOBACCO GRANT 1,250 20% 1,500 - 1,500 01- 000 -45 -00 -4525 GRANTS - BROWNFIELD COM DEV 30,000 -100% - - 55,160 01- 000 -46 -00 -4600 INVESTMENT INCOME 75,000 0% 75,000 78,487 100,000 01- 000 -49 -00 -4915 TRANSFER FROM WATER OPS 250,000 6% 265,000 125,000 265,000 01- 000 -49 -00 -4920 TRANSFER FROM SEWER MAINT. 70,000 0% 70,000 35,290 70,000 01- 000 -49 -00 -4925 TRANSFER FROM SAN. SEWER IMP 150,000 0% 150,000 75,000 150,000 01- 000 -49 -00 -4930 TRANSFER FROM WATER IMPROVE. 200,000 0% 200,000 100,000 200,000 01- 000 -49 -00 -4935 TRANSFER FROM LAND CASH 16,000 0% 16,000 8,000 16,000 14 01- 000 -49 -00 -4940 TRANSFER FROM MUNICIPAL BLDG 182,500 91,250 182,500 15 TOTAL REVENUES: GENERAL 16,583,575 17% 19,346,897 7,069,109 17,509,107 Page 1 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL GENERALFUND ACCOUNT 2006 -2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Budget Change Budget YTD BUDGET GENERAL FUND REVENUES - COMMENTS 1 New World Software 3 Moved to Contingencies 4 750 Permits @ $2,000 5 Project is completed 6 Grande Reserve Perimeter Roads - funded by developer $2,000 per permit in Grande Reserve Only 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 To fund a portion of the Parks Designer salary 15 $32,500 goes to Contingencies /Reserve Page 2 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL GENERAL FUND ACCOUNT 2006 -2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Budget Change Budget YTD BUDGET ADMINISTRATION EXPENSES 01- 110 -50 -00 -5100 SALARIES - MAYOR 7,500 51% 11,310 5,325 11,310 01- 110 -50 -00 -5101 SALARIES - CITY CLERK 3,600 78% 6,410 4,240 8,600 01- 110 -50 -00 -5102 SALARIES - CITY TREASURER 3,600 78% 6,410 2,940 6,410 01- 110 -50 -00 -5103 SALARIES - ALDERMAN 29,080 41% 40,880 20,300 40,880 1 01- 110 -50 -00 -5104 SALARIES - LIQUOR COMMISSIONER 1,000 0% 1,000 250 1,000 01- 110 -50 -00 -5105 SALARIES - CITY ATTORNEY 11,502 -17% 9,500 310 310 01- 110 -50 -00 -5106 SALARIES - ADMINISTRATIVE 626,215 -29% 446,025 243,125 522,421 2 01- 110 -50 -00 -5136 SALARIES - PART TIME 50,000 -55% 22,500 4,203 7,500 3 01- 110 -50 -00 -5137 SALARIES - OVERTIME 1,500 -50% 750 181 750 01- 110 -61 -00 -5300 LEGAL SERVICES 55,000 55% 85,000 45,863 180,000 01- 110 -61 -00 -5311 CODIFICATION 5,000 0% 5,000 2,012 5,000 01- 110 -61 -00 -5314 BUILDING INSPECTIONS 1,115,000 1% 1,125,000 406,356 950,000 01- 110 -62 -00 -5401 CONTRACTUAL SERVICES 40,000 -31% 27,500 31,405 50,000 4 01- 110 -62 -00 -5403 SPECIAL CENSUS 0 100% - - 300,000 5 01- 110 -62 -00 -5404 CABLE CONSORTIUM FEE 30,000 17% 35,000 31,826 38,000 01- 110 -62 -00 -5406 OFFICE CLEANING 7,500 0% 7,500 3,125 7,500 01- 110 -62 -00 -5410 MAINTENANCE - OFFICE EQUIPMENT 500 0% 500 - 500 01- 110 -62 -00 -5427 FACADE PROGRAM 30,000 -50% 15,000 - 17,500 01- 110 -62 -00 -5436 TELEPHONE 15,000 0% 15,000 7,669 15,000 01- 110 -62 -00 -5438 CELLULAR TELEPHONE 2,300 -17% 1,920 1,447 2,500 01- 110 -62 -00 -5439 TELEPHONE SYSTEMS MAINTENANCE 11,000 -32% 7,500 5,100 10,000 01- 110 -64 -00 -5600 DUES 5,000 10% 5,510 5,849 5,900 7 01- 110 -64 -00 -5601 ILLINOIS MUNICIPAL LEAGUE DUES 781 2% 800 - 800 01- 110 -64 -00 -5603 SUBSCRIPTIONS /BOOKS 900 -44% 500 - 500 01- 110 -64 -00 -5604 TRAINING & CONFERENCES 13,000 50% 19,500 4,170 6,000 8 01- 110 -64 -00 -5605 TRAVEL / MEALS / LODGING 17,000 -56% 7,500 10,117 24,000 9 01- 110 -64 -00 -5606 PROMOTIONAL /MARKETING EXP'S 9,577 25% 12,000 4,403 12,000 10 01- 110 -64 -00 -5608 SPONSORSHIPS 1,500 0% 1,500 - 1,500 01- 110 -64 -00 -5609 YMCA PARTNERSHIP 0 100% 1,500 1,500 1,500 01- 110 -65 -00 -5800 CONTINGENCIES 595,000 -75% 146,500 - 146,500 11 01- 110 -65 -00 -5801 FUND BALANCE RESERVE 0 0% - - - 01- 110 -65 -00 -5802 OFFICE SUPPLIES 15,000 -43% 8,500 6,780 10,000 01- 110 -65 -00 -5804 OPERATING SUPPLIES 10,000 -50% 5,000 4,238 6,250 01- 110 -65 -00 -5808 POSTAGE & SHIPPING 12,500 75% 21,925 7,479 21,925 12 01- 110 -65 -00 -5809 PRINTING & COPYING 11,000 0% 11,000 7,901 11,000 01- 110 -65 -00 -5810 PUBLISHING & ADVERTISING 5,000 0% 5,000 738 5,000 01- 110 -72 -00 -6500 IMRF PARTICIPANTS 49,471 -20% 39,756 18,957 39,756 13 01- 110 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 56,151 -29% 39,965 21,513 39,965 14 01- 110 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 30,000 -93% 2,000 2,020 3,500 15 01- 110 -75 -00 -7003 OFFICE EQUIPMENT 5,000 -50% 2,500 251 2,500 01- 110 -78 -00 -9002 NICOR GAS 30,000 0% 30,000 6,333 30,000 01- 110 -78 -00 -9004 MISCELLANEOUS 100 150% 250 - - 01- 110 -78 -00 -9005 MERIT /COLA 104,400 -84% 16,333 - 01- 110 -78 -00 -9007 APPRECIATION DINNER 0.00 100% 10,000 - - 01- 110 -78 -00 -9008 VOLUNTEER APPRECIATION DAY 0.00 100% 2,000 1,106 2,000 01- 110 -78 -00 -9009 WEBSITE 0.00 100% 2,500 142 1,250 16 01- 110 -78 -00 -9010 COMMUNITY EVENTS 0.00 100% 45,200 11,915 35,200 17 01- 110 -78 -00 -9011 TENNIS CRT REFURBISHING 40,000 45,823 46,000 01- 110 -78 -00 -9012 SALARY SURVEY 60,063 - - 01- 110 -78 -00 -9013 HOLIDAY UNDER THE STARTS 0 0 % - 640 - TOTAL EXPENSES: ADMINISTRATION 3,034,677 -21% 2,407,007 977,551 2,628,227 Page 3 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL GENERAL FUND ACCOUNT 2006- 2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Budget Change Budget YTD 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 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 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL GENERAL FUND ACCOUNT 2006 -2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Budget Change Budget YTD BUDGET FINANCE EXPENSES 01- 120 -50 -00 -5106 SALARIES - ADMINISTRATIVE 0.00 100% 293,883 158,332 328,883 01- 120 -50 -00 -5136 SALARIES - PART TIME 0.00 100% 5,000 1,076 5,000 01- 120 -50 -00 -5137 SALARIES - OVERTIME 0.00 100% 750 - 750 01- 120 -50 -00 -5202 BEN EFITS- UNEMPLOY. COMP. TAX 12,000 100% 24,000 5,854 24,000 2 01- 120 -50 -00 -5203 BENEFITS - HEALTH INSURANCE 852,458 0% 850,000 419,950 850,000 01- 120 -50 -00 -5204 BENEFITS - GROUP LIFE INSURANCE 74,049 1% 75,000 9,179 32,000 01- 120 -50 -00 -5205 BENEFITS - DENTAL/VISION ASST 23,668 15% 27,218 35,724 75,000 01- 120 -61 -00 -5304 AUDIT FEES & EXPENSES 2,675 1196% 32,000 22,500 32,000 3 01- 120 -61 -00 -5310 EMPLOYEE ASSISTANCE 4,500 0% 4,500 1,500 4,500 01- 120 -62 -00 -5400 INSURANCE- LIABILITY & PROPERTY 130,000 26% 163,422 - 163,422 4 01- 120 -62 -00 -5401 CONTRACTUAL SERVICES 0 0% - 1,777 10,000 01- 120 -62 -00 -5410 MAINTENANCE - OFFICE EQUIPMENT 0.00 100% 500 - 500 01- 120 -62 -00 -5411 MAINTENANCE - COMPUTERS 2,000 0% 2,000 125 2,000 01- 120 -62 -00 -5412 MAINTENANCE - PHOTOCOPIERS 19,392 17% 22,750 9,823 24,000 5 01- 120 -62 -00 -5437 ACCTG SYSTEM SERVICE FEE 8,500 8% 9,200 1,900 12,200 01- 120 -62 -00 -5438 CELLULAR TELEPHONE 0.00 100% 720 488 800 6 01- 120 -64 -00 -5603 SUBSCRIPTIONS /BOOKS 0.00 100% 100 - 100 01- 120 -64 -00 -5604 TRAINING & CONFERENCES 0.00 100% 3,125 222 4,500 7 01- 120 -64 -00 -5605 TRAVEL / MEALS / LODGING 0.00 100% 4,000 1,784 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 1,485 7,500 01- 120 -65 -00 -5804 OPERATING SUPPLIES 0.00 100% 5,000 5,186 8,000 01- 120 -65 -00 -5844 MARKETING - HOTEL TAX 20,000 0 %u 20,000 7,359 20,000 01- 120 -72 -00 -6500 IMRF PARTICIPANTS 0.00 100 %u 28,642 12,049 28,642 01- 120 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 0.00 100% 28,793 12,483 28,793 01- 120 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 30,000 0% 30,000 2,462 30,000 8 01- 120 -75 -00 -7003 OFFICE EQUIPMENT 0.00 100% 2,500 250 750 01- 120 -78 -00 -9001 CITY TAX REBATE 500 50% 750 - 750 01- 120 -78 -00 -9003 SALES TAX REBATE 450,000 61% 725,000 98,002 625,000 01- 120 -78 -00 -9005 MERIT /COLA 0.00 100% 12,444 - - 01- 120 -78 -00 -9012 SALARY SURVEY 0 100% 67,051 - - 01- 120 -78 -00 -9013 AMUSEMENT TAX REBATE 74,250 - - 9 01- 120 -99 -00 -9925 TRANSFER TO SAN SEWER 0.00 0% 150,000 75,000 150,000 01- 120 -99 -00 -9930 TRANSFER TO WATER IMPROVEMENT 0.00 0% 200,000 100,000 200,000 01- 120 -99 -00 -9935 TRANSFER TO LAND CASH 0.00 100% 48,245 24,122 48,245 01- 120 -99 -00 -9940 TRANSFER TO PARK & RECREATION 0.00 0% 1,161,778 582,889 1,161,778 01- 120 -99 -00 -9945 TRANSFER TO GEN FD REV FOR PD 0.00 100% 125,000 62,500 125,000 10 01- 120 -99 -00 -9965 TRANSFER TO DEBT SERVICE 0.00 100 % 284,202 142,102 231,884 TOTAL EXPENSES: FINANCE 1,634,742 100% 4,490,323 1,796,124 4,239,997 Page 5 of 40 UNITED CITY OF YORKVILLE FY 07108 BUDGET 6 MONTH FINAL GENERAL FUND ACCOUNT 2006 -2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Budget Change Budget YTD BUDGET FINANCE - COMMENTS 2 Increase based on actual numbers 3 FY 06/07's amount is scriveners 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 40 UNITED CITY OF YORKVILLE FY 07108 BUDGET 6 MONTH FINAL GENERALFUND ACCOUNT 2006 -2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Budget Change Budget YTD BUDGET ENGINEERING EXPENSES 01- 150 -50 -00 -5107 SALARIES - EMPLOYEES 313,306 2% 318,914 165,187 359,959 01- 150 -50 -00 -5137 SALARIES - OVERTIME 1,000 0% 1,000 871 1,000 01- 150 -62 -00 -5401 CONTRACTUAL SERVICES 50,000 -5% 47,500 (3,605) - 1 01- 150 -62 -00 -5403 FEES 2,000 0% 2,000 1,062 2,000 2 01- 150 -62 -00 -5409 MAINTENANCE - VEHICLES 2,000 0% 2,000 393 2,000 01- 150 -62 -00 -5410 MAINTENANCE- OFFICE EQUIP 1,000 0% 1,000 240 1,000 01- 150 -62 -00 -5411 MAINTENANCE - COMPUTERS 3,000 -33% 2,000 - 2,000 01- 150 -62 -00 -5421 WEARING APPAREL 1,400 0% 1,400 322 1,400 01- 150 -62 -00 -5438 CELLULAR TELEPHONE 3,360 -25% 2,520 1,327 2,520 01- 150 -64 -00 -5600 DUES 400 50% 600 235 600 01- 150 -64 -00 -5604 TRAINING & CONFERENCES 6,000 -33% 4,000 17 4,000 01- 150 -64 -00 -5605 TRAVEL EXPENSE 1,000 0% 1,000 - 1,000 01- 150 -64 -00 -5608 TUITION REIMBURSEMENT 0 100% 2,580 - 2,580 01- 150 -64 -00 -5616 BOOKS & PUBLICATIONS 200 0% 200 - 200 01- 150 -65 -00 -5801 ENGINEERING SUPPLIES 3,000 0% 3,000 535 3,000 01- 150 -65 -00 -5802 OFFICE SUPPLIES 2,500 0% 2,500 451 2,500 01- 150 -65 -00 -5809 PRINTING & COPYING 2,000 13% 2,250 340 2,250 01- 150 -65 -00 -5820 ENGINEERING CAPITAL RESERVE 52,000 -23% 40,000 - - 01- 150 -72 -00 -6500 IMRF PARTICIPANTS 24,830 10% 27,393 12,637 27,393 01- 150 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 24,044 15% 27,537 12,491 27,537 01- 150 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 7,900 159% 20,500 4,557 10,500 3 01- 150 -75 -00 -7003 OFFICE EQUIPMENT 3,000 -17% 2,500 577 2,500 01- 150 -78 -00 -9005 MERIT /COLA 0 100% 13,843 - - 01- 150 -78 -00 -9012 SALARY SURVEY 0 100% 27,202 - - TOTAL EXPENSES: ENGINEERING 508,941 9% 553,439 197,636 455,939 Page 7 of 40 UNITED CITY OF YORKVILLE FY 07108 BUDGET 6 MONTH FINAL GENERALFUND ACCOUNT 2006 -2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Budget Change Budget YTD 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 $15,000 is allocated in the Engineering buget. Page 8 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL GENERAL FUND ACCOUNT 2006 -2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Budget Change Budget YTD BUDGET PUBLIC SAFETY /POLICE DEPT. EXPENSES 01- 210 -50 -00 -5107 SALARIES - EMPLOYEES 822,230 53% 1,254,261 595,296 1,315,000 01- 210 -50 -00 -5131 SALARIES - LIEUT. /SERGEANTS /CHIEF 612,203 -9% 555,341 317,604 660,000 01- 210 -50 -00 -5133 SALARIES - COPS 106,226 -100% - - - 1 01- 210 -50 -00 -5134 SALARIES - CROSSING GUARD 19,500 15% 22,425 8,081 22,425 01- 210 -50 -00 -5135 SALARIES - POLICE CLERKS 122,418 -9% 111,269 81,980 180,000 01- 210 -50 -00 -5136 SALARIES - PART TIME 35,000 5% 36,750 9,232 36,750 01- 210 -50 -00 -5137 SALARIES - OVERTIME 65,000 23% 80,000 36,349 80,000 2 01- 210 -50 -00 -5200 CADET PROGRAM 22,000 50% 33,000 13,679 33,000 3 01- 210 -61 -00 -5300 LEGAL SERVICES 20,000 0% 20,000 1,704 10,000 01- 210 -62 -00 -5408 MAINTENANCE - EQUIPMENT 8,400 31% 11,000 7,865 11,000 4 01- 210 -62 -00 -5409 MAINTENANCE - VEHICLES 28,000 25% 35,000 14,687 35,000 01- 210 -62 -00 -5410 MAINT- OFFICE EQUIPMENT 2,625 71% 4,500 - 4,500 5 01- 210 -62 -00 -5411 MAINTENANCE - COMPUTERS 6,000 67% 10,000 - 10,000 6 01- 210 -62 -00 -5412 MAINTENANCE - K9 2,000 394 2,000 7 01- 210 -62 -00 -5414 WEATHER WARNING SIREN MAINT 6,000 10% 6,600 1,602 6,600 8 01- 210 -62 -00 -5421 WEARING APPAREL 30,000 0% 30,000 7,803 30,000 9 01- 210 -62 -00 -5422 COPS GRANT IV - VESTS 3,000 100% 6,000 3,820 6,000 10 01- 210 -62 -00 -5423 CLASY GRANT 1,000 -100% - - - 11 01- 210 -62 -00 -5429 PSYCHOLOGICAL TESTING 1,750 100% 3,500 1,750 4,000 01- 210 -62 -00 -5430 HEALTH SERVICES 3,500 0% 3,500 2,889 4,000 01- 210 -62 -00 -5431 LABORATORY FEES 1,500 -100% - - - 12 01- 210 -62 -00 -5436 TELEPHONE 20,000 15% 23,000 6,964 23,000 01- 210 -62 -00 -5438 CELLULAR TELEPHONE 14,500 21% 17,500 6,861 17,500 13 01- 210 -62 -00 -5441 MTD- ALERTS FEE 8,450 25% 10,562 2,960 10,562 14 01- 210 -64 -00 -5600 DUES 2,500 60% 4,000 1,885 4,000 15 01- 210 -64 -00 -5603 SUBSCRIPTIONS 350 43% 500 40 500 01- 210 -64 -00 -5604 TRAINING & CONFERENCE 19,950 66% 33,025 9,537 33,025 16 01- 210 -64 -00 -5605 TRAVEL EXPENSES 10,500 15% 12,075 4,306 12,075 17 01- 210 -64 -00 -5606 COMMUNITY RELATIONS 7,800 28% 10,000 3,925 10,000 18 01- 210 -64 -00 -5607 POLICE COMMISSION- 21,000 5% 22,050 3,419 22,050 19 01- 210 -64 -00 -5608 TUITION REIMBURSEMENT 14,000 0% 14,000 3,589 14,000 01- 210 -64 -00 -5609 POLICE RECRUIT ACADEMY 10,500 90% 20,000 7,969 20,000 01- 210 -64 -00 -5610 GUN RANGE FEES 700 43% 1,000 - 1,000 01- 210 -64 -00 -5611 SPECIAL RESPONSE TEAM FEE 3,500 15% 4,025 1,490 4,025 01- 210 -64 -00 -5612 NEIGHBORHOOD WATCH 100% 1,200 149 1,200 01- 210 -64 -00 -5613 CITIZENS POLICE ACADEMY 100% 2,420 318 2,420 20 01- 210 -64 -00 -5614 CHAPLAIN PROGRAM 100% 1,400 - 1,400 01- 210 -64 -00 -5615 COMPLIANCE CHECKS 100% 500 (1,794) 500 21 01- 210 -64 -00 -5616 DARE PROGRAM 100% 5,000 - 5,000 01- 210 -64 -00 -5617 HUMAN RESOURCE COMMITTEE 100% - - - 22 01- 210 -65 -00 -5802 OFFICE SUPPLIES 6,825 47% 10,000 2,316 10,000 23 01- 210 -65 -00 -5803 EVIDENCE TECH SUPPLIES 100% 5,000 - 5,000 24 01- 210 -65 -00 -5804 OPERATING SUPPLIES 16,800 15% 19,320 4,647 19,320 01- 210 -65 -00 -5808 POSTAGE & SHIPPING 3,500 43% 5,000 1,432 5,000 25 01- 210 -65 -00 -5809 PRINTING & COPYING 4,725 27% 6,000 2,988 6,000 26 01- 210 -65 -00 -5810 PUBLISHING & ADVERTISING 1,500 33% 2,000 181 2,000 27 01- 210 -65 -00 -5812 GASOLINE 63,000 19% 75,000 22,493 75,000 Page 9 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL GENERAL FUND ACCOUNT 2006 -2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Budget Change Budget YTD BUDGET PUBLIC SAFETY /POLICE DEPT. CONT'D EXPENSES 01- 210 -65 -00 -5813 AMMUNITION 5,500 9% 6,000 - 6,000 01- 210 -72 -00 -6500 IMRF PARTICIPANTS 9,671 22% 11,800 7,493 16,000 01- 210 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 137,591 2% 140,750 81,357 165,500 01- 210 -72 -00 -6502 POLICE PENSION 250,000 10% 275,000 79,434 275,000 28 01- 210 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 9,500 -21% 7,500 3,986 7,500 01- 210 -78 -00 -9004 BIKE PATROL 2,500 0% 2,500 - 2,500 01- 210 -78 -00 -9005 MERIT /COLA 27,318 - - 29 01- 210 -78 -00 -9012 SALARY SURVEY 215,041 - - 01- 210 -99 -00 -9910 TRANSFER TO POLICE CAPITAL 0 0 % - - - TOTAL EXPENSES: PUBLIC SAFETY /POLICE DEPT. 2,561,214 26% 3,215,632 1,362,679 3,227,352 I I Page 10 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL GENERALFUND ACCOUNT 2006- 2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Budget Change Budget YTD 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 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL GENERALFUND ACCOUNT 2006 -2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Budget Change Budget YTD BUDGET COMMUNITY DEVELOPMENT EXPENSES 01- 220 -50 -00 -5107 EMPLOYEE SALARIES 218,000 39% 302,853 129,039 305,000 1 01- 220 -61 -00 -5300 LEGAL SERVICES 20,000 0% 20,000 6,680 20,000 01- 220 -62 -00 -5401 CONTRACTUAL SERVICES 80,000 -53% 37,500 35,372 54,315 2 01- 220 -62 -00 -5430 PLANNING CONSULTANT 70,000 -29% 50,000 - - 01- 220 -62 -00 -5432 ECONOMIC DEVELOPMENT 45,000 0% 45,000 - 45,000 01- 220 -62 -00 -5438 CELLULAR TELEPHONE 1,000 0% 1,000 325 1,000 01- 220 -64 -00 -5600 DUES 1,000 50% 1,500 520 1,500 01- 220 -64 -00 -5604 TRAINING & CONFERENCES 6,000 25% 7,500 2,780 7,500 01- 220 -64 -00 -5605 TRAVEL EXPENSE 3,000 -17% 2,500 351 2,500 01- 220 -64 -00 -5616 BOOKS & PUBLICATIONS 0 0% - - - 01- 220 -65 -00 -5804 OPERATING SUPPLIES 5,000 50% 7,500 2,324 7,500 01- 220 -65 -00 -5809 PRINTING & COPYING 2,500 -20% 2,000 51 2,000 01- 220 -65 -00 -5810 PUBLISHING & ADVERTISING 8,000 0% 8,000 459 2,000 01- 220 -65 -00 -5814 BOOKS & MAPS 4,000 0% 4,000 117 2,000 01- 220 -72 -00 -6500 IMRF PARTICIPANTS 17,222 43% 24,563 9,820 24,563 01- 220 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 16,677 48% 24,693 9,863 24,693 01- 220 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 25,000 -60% 10,000 5,878 10,000 3 01- 220 -75 -00 -7003 OFFICE EQUIPMENT 3,000 67% 5,000 1,936 5,000 IL TOMORROW GRANT MATCH - 10,200 01- 220 -78 -00 -9005 MERIT /COLA 0 11,645 - - 01- 220 -78 -00 -9012 SALARY SURVEY 0 8,281 - - TOTAL EXPENSES: I PLANNING & DEVELOPMENT 525,399 9% 573,535 205,516 524,771 I I ' Page 12 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL GENERAL FUND ACCOUNT 2006 - 2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Budget Change Budget YTD 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 Page 13 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL GENERAL FUND ACCOUNT 2006 -2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Budget Change Budget YTD BUDGET STREETS EXPENSES 01- 410 -50 -00 -5107 SALARIES - EMPLOYEE 225,437 17% 263,748 133,763 280,000 01- 410 -50 -00 -5136 SALARIES - PART TIME 8,500 13% 9,600 4,475 5,500 1 01- 410 -50 -00 -5137 SALARIES - OVERTIME 20,000 0% 20,000 2,829 20,000 01- 410 -61 -00 -5313 ENGINEERING - IN TOWN ROAD PG 261,802 -5% 250,000 131,989 250,000 01- 410 -61 -00 -5314 INSPECTIONS & LICENSES 400 0% 400 166 400 01- 410 -62 -00 -5401 CONTRACTUAL SERVICES 2,000 0% 2,000 347 2,000 01- 410 -62 -00 -5408 MAINTENANCE- EQUIPMENT 8,000 0% 8,000 1,922 8,000 01- 410 -62 -00 -5409 MAINTENANCE - VEHICLES 9,000 67% 15,000 9,009 15,000 2 01- 410 -62 -00 -5414 MAINTENANCE - TRAFFIC SIGNALS 18,000 0% 18,000 10,144 18,000 01- 410 -62 -00 -5415 MAINTENANCE - STREET LIGHTS 25,000 6% 26,500 11,349 26,500 3 01- 410 -62 -00 -5420 MAINTENANCE -STORM SEWER 10,000 0% 10,000 508 10,000 01- 410 -62 -00 -5421 WEARING APPAREL 6,000 2% 6,150 1,306 6,150 4 01- 410 -62 -00 -5422 RAYMOND DETENTION BASE 100% 75,000 1,390 75,000 01- 410 -62 -00 -5423 RAYMOND STORM SEWER OUTFLOW 100% 1,300,000 508,755 529,913 01- 410 -62 -00 -5424 RAYMOND OUTFALL - - 01- 410 -62 -00 -5434 RENTAL - EQUIPMENT 2,000 0% 2,000 353 2,000 01- 410 -62 -00 -5435 ELECTRICITY 60,000 24% 74,400 39,797 74,400 5 01- 410 -62 -00 -5438 CELLULAR TELEPHONE 3,300 21% 4,000 1,536 4,000 6 01- 410 -62 -00 -5440 STREET LIGHTING 6,000 0% 6,000 - 6,000 7 01- 410 -64 -00 -5604 TRAINING & CONFERENCES 5,000 51% 7,525 4,275 7,525 8 01- 410 -65 -00 -5804 OPERATING SUPPLIES 30,000 0% 30,000 (45) 15,000 01- 410 -65 -00 -5812 GASOLINE 27,500 10% 30,250 14,618 30,250 9 01- 410 -65 -00 -5815 HAND TOOLS 2,500 0% 2,500 524 2,500 10 01- 410 -65 -00 -5817 GRAVEL 6,500 -62% 2,500 1,278 2,500 01- 410 -72 -00 -6500 IMRF PARTICIPANTS 19,390 10% 21,238 10,395 21,238 01- 410 -72 -00 -6501 SOCIAL SECURITY& MEDICARE 19,426 10% 21,349 10,753 21,349 01- 410 -75 -00 -5418 MOSQUITO CONTROL 27,000 11% 30,000 28,414 30,000 11 01- 410 -75 -00 -7004 SAFETY EQUIPMENT 1,000 0% 1,000 540 1,000 01- 410 -75 -00 -7099 GRANDE RES PERIMETER RDS 1,600,000 -38% 1,000,000 3,120 750,000 12 01- 410 -75 -00 -7100 STREET REHAB PROJECTS 75,000 -100% - - - 01- 410 -75 -00 -7101 IN -TOWN ROAD PROGRAM 1,588,198 57% 2,500,000 1,364,219 2,500,000 01- 410 -75 -00 -7102 TREE & STUMP REMOVAL 25,000 -8% 23,000 8,475 23,000 01- 410 -75 -00 -7103 SIDEWALK CONSTRUCTION 25,000 -90% 2,500 1,473 2,500 01- 410 -75 -00 -7104 FOX HILL SSA EXPENSES 18,000 0% 18,000 18,480 18,000 01- 410 -75 -00 -7105 FOX ROAD SIDEWALK 0 100% 25,000 - 25,000 01- 410 -75 -00 -7106 ROAD CONTRIB FUND PROJECTS 30,000 500% 180,000 - - 13 01- 410 -75 -00 -7107 ROAD CONTRIB FUND - RESERVE 1,500,000 -32% 1,020,000 - 620,000 14 01- 410 -75 -00 -7108 126 /71 IMPROVEMENTS 100% 19,000 - 19,000 01- 410 -75 -00 -7109 TRAFFIC SIGNALS RT. 34 & Sycamore 100% - - - 15 01- 410 -75 -00 -7110 ASPHAULT PAVEMENT 100% 27,573 - - 01- 410 -75 -00 -4404 HANGING BASKETS 2,442 -18% 2,000 1,800 2,000 01- 410 -78 -00 -9012 SALARYSURVEY 0 100% 6,353 - - 01- 410 -78 -00 -9005 MERIT /COLA 0 100% 8,974 - - 01- 410 -99 -00 -9930 TRANSFER TO WATER IMPROVE 220,000 -100% - - - TOTAL EXPENSES: STREETS 5,887,394 20% 7,069,560 2,327,953 5,423,725 Page 14 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL GENERAL FUND ACCOUNT 2006 -2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Budget Change Budget YTD 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 Reserve for Arterial road improvements per agreement 13 Traffic Signal at Route 34 & Sycamore 14 Tied to match the Road Contrib Fee Rev (minus the amount used for Road Contribution Fund Proj's) 15 Under Road Contribution Fund Projects Page 15 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL GENERALFUND ACCOUNT 2006 -2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Budget Change Budget YTD BUDGET HEALTH & SANITATION EXPENSES 01- 540 -62 -00 -5442 GARBAGE SERVICES 676,163 53% 1,031,401 417,333 1,000,000 01- 540 -62 -00 -5443 LEAF PICKUP 5,000 2 0% 6,000 600 6,000 TOTAL EXPENSES: HEALTH & SANITATION 681,163 52% 1,037,401 417,933 1,006,000 TOTAL GENERAL FUND REVENUES 16,583,575 17% 19,346,897 7,069,109 17,509,107 TOTAL GENERAL FUND EXPENSES 14,804,671 31% 19,346,897 14,354,502 17,506,011 FUND SURPLUS (DEFICIT) 1,778,904 -100% (0) (7,285,392) 3,096 I I Page 16 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL MFT ACCOUNT 2006 -2007 2007 -2008 REVISED NUMBER DESCRIPTION Budget % Change Budget YTD BUDGET REVENUES 15- 000 -40 -00 -3999 CARRY OVER BALANCE 300,000 -35% 194,152 - 190,000 15- 000 -40 -00 -4060 MOTOR FUEL TAX ALLOTMENTS 318,601 -1% 315,000 159,970 315,000 15- 000 -44 -00 -4490 MISC INCOME 0 0% - - - 15- 000 -44 -00 -4401 GAME FARM ROAD DESIGN 157,000 - 157,000 15- 000 -46 -00 -4600 INVESTMENT INCOME 12,000 13 % 13,500 10,980 15,000 TOTAL REVENUES: 630,601 8% 679,652 170,949 677,000 EXPENSES 15- 000 -65 -00 -5800 CONTINGENCY 34,011 -73% 9,052 2,452 9,052 15- 000 -65 -00 -5818 SALT 60,000 30% 78,010 - 75,925 15- 000 -75 -00 -7007 SIGNS 9,990 0% 9,990 6,650 9,990 15- 000 -75 -00 -7008 CRACK FILLING 40,000 -100% - 2,084 2,085 15- 000 -75 -00 -7106 GAME FARM SURVEYING 68,000 52,884 68,000 15- 000 -75 -00 -7107 CONSTRUCTION ENGINEERING 150,000 111% 317,000 - 317,000 1 15- 000 -75 -00 -7110 COLD PATCH 8,000 0% 8,000 1,902 8,000 15- 000 -75 -00 -7111 HOT PATCH 9,600 0% 9,600 - 9,600 15- 000 -75 -00 -7112 VAN EMMON 100% 30,000 - 30,000 '5-000-75-00-7113 COUNTRYSIDE PKWY CONST. 300,000 -100% - - - 5- 000 -75 -00 -7115 PALMER COURT 100% 70,000 - 67,348 2 15- 000 -75 -00 -7116 WOOD DALE 100% 30,000 - 30,000 15- 000 -75 -00 -7117 FAXON ROAD ROW ACQ 100% 50,000 5,915 50,000 15- 000 -99 -00 -9960 TRANSFER TO FOX INDUSTRIAL 0 0% - 14,419 - TOTAL EXPENSES: 630,601 8% 679,652 86,307 677,000 TOTAL FUND REVENUES 630,601 679,652 170,949 677,000 TOTAL FUND EXPENSES 630,601 679,652 86,307 677,000 FUND SURPLUS (DEFICIT) 0 0 84,643 0 COMMENTS: 1 Game Farm Road 2 Ocean Atlantic's Shortfall I Page 17 of 40 I UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL MUNICIPAL BUILDING ACCOUNT 2006 -2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Budget Change Budget YTD BUDGET REVENUES 16- 000 -40 -00 -3999 CARRY OVER BALANCE 32,500 -100% - - - 16- 000 -42 -00 -4211 DEVELOPMENT FEES - BUILDING 137,423 191% 400,000 1 44,250 296,705 16- 000 -42 -00 -4215 BEECHER RENTAL FEE 12,000 -25% 9,000 6,000 9,000 16- 000 -49 -00 -4901 TRANSFER FROM GENERAL FUND 30,865 -100% - - - TOTAL REVENUES: 212,788 92% 409,000 50,250 305,705 EXPENSES 16- 000 -62 -00 -5416 MAINT - GENERAL BLDG & GROUNDS 5,000 0% 5,000 2,440 2,441 16- 000 -75 -00 -7008 ENTRY WAY SIGNS 4,000 -50% 2,000 - - 16- 000 -75 -00 -7200 BLDG IMPROV- PARK & REC 10,000 20% 12,000 2,721 2,721 16- 000 -75 -00 -7203 BLDG IMPROVEMENTS - PUBLIC WKS 10,000 20% 12,000 1,990 2,000 16- 000 -75 -00 -7204 BLDG MAINT - CITY HALL 12,000 -33% 8,000 12,758 12,760 16- 000 -75 -00 -7205 BLDG IMPROVEMENTS - LIBRARY 4,000 -100% - - - 16- 000 -75 -00 -7206 LANDSCAPING - PUBLIC BUILDINGS 2,000 75% 3,500 859 860 16- 000 -75 -00 -7209 BEECHER PARKING LOT 0 0% - - - 16- 000 -75 -00 -7210 BLDG IMPROV - POST OFFICE 30,865 -100% - - - 16- 000 -75 -00 -7211 NEW BUILDINGS 100% 51,577 - - 6- 000 -78 -00 -9009 RESERVE 0 100% 30,000 5,237 - 16- 000 -99 -00 -9901 TRANSFER TO GENERAL FUND 182,500 91,250 182,500 16- 000 -99 -00 -9965 TRANSFER TO DEBT SERVICE 102,423 0 % 102,423 51,212 102,423 TOTAL EXPENSES: 212,788 92% 409,000 168,468 305,705 TOTAL FUND REVENUES 212,788 409,000 50,250 305,705 TOTAL FUND EXPENSES 212,788 409,000 168,468 305,705 FUND SURPLUS (DEFICIT) 0 0 (118,218) - COMMENTS: 1 Tied to permit estimates Page 18 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL POLICE CAPITAL 2006 -2007 2007 -2008 REVISED ACCOUNT NUMBER DESCRIPTION Budget % Change Budget YTD BUDGET REVENUES 20- 000 -40 -00 -3999 CARRY OVER BALANCE 169,648 -51% 82,648 - 80,000 20- 000 -42 -00 -4212 DEV FEES - POLICE 188,000 25% 235,000 1 78,600 155,000 20- 000 -44 -00 -4402 K -9 DONATIONS 1,000 -100% - 50 50 20- 000 -44 -00 -4403 IN CAR VIDEO DONATIONS 2,500 140% 6,000 2 1,035 2,000 20- 000 -44 -00 -4404 DONATIONS 1,000 -100% - 2,000 2,000 20- 000 -44 -00 -4405 WEATHER WARNING SIREN 20,000 -25% 15,000 - 7,500 20- 000 -44 -00 -4431 SALE OF POLICE SQUADS 500 -100% - 400 400 20- 000 -44 -00 -4489 RICP DISASTER PLAN GRANT 0 0% - - 20- 000 -44 -00 -4490 MISC INCOME 0 0% - - 20- 000 -48 -00 -4800 LOAN PROCEEDS 0 0% - - 20- 000 -49 -00 -4901 TRANSFER FROM GENERAL FD 75,000 -100% - _ TOTAL REVENUES: 457,648 -26 338,648 82,085 246,950 EXPENSES 20- 000 -65 -00 -5811 LETHAL /NON- LETHAL WEAPONS 7,000 43% 10,000 2,190 8,000 20- 000 -75 -00 -7001 EQUIPMENT 36,722 -1% 36,411 9,750 20,000 20- 000 -75 -00 -7002 K -9 EQUIPMENT 1,500 67% 2,500 3 - 2,500 20- 000 -75 -00 -7005 VEHICLES 97,222 -18% 80,000 5 21,310 80,000 20- 000 -75 -00 -7006 CAR BUILD OUT 49,415 40% 68,948 4 - 53,802 1- 000 -75 -00 -7008 NEW WEATHER WARN SIRENS 37,000 0% 37,000 - - 20- 000 -75 -00 -7009 RES- WEATHER WARN SIREN 82,648 0% 82,648 - 82,648 20- 000 -75 -00 -7010 NEW WORLD SOFTWARE 125,000 -100% - - - 20- 000 -78 -00 -9009 RESERVE 21,141 0% 21,141 - - 20- 000 -99 -00 -9965 TRANSFER TO DEBT SERV FD 0 0 % - - - TOTAL EXPENSES: 457,648 -26% 338,648 33,250 246,950 TOTAL FUND REVENUES 457,648 338,648 82,085 246,950 TOTAL FUND EXPENSES 457,648 338,648 33,250 246,950 FUND SURPLUS (DEFICIT) 0 0 48,834 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 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL PUBLIC WORKS CAPITAL ACCOUNT 2006 -2007 2007 -2008 REVISED NUMBER DESCRIPTION Budget % Change Budget YTD BUDGET REVENUES 21- 000 -40 -00 -3999 CARRY OVER BALANCE 175,000 14% 200,000 - 200,000 21- 000 -42 -00 -4213 DEVELOPMENT FEES - PUBLIC WKS 435,000 38% 600,000 1 186,400 369,600 21- 000 -44 -00 -4430 SALE OF EQUIPMENT 40,000 63% 65,000 2 63,316 63,316 21- 000 -49 -00 -4915 TRANSFER FROM WATER FUND 50,000 -100% - - 21- 000 -49 -00 -4920 TRANSFER FROM SEWER FUND 30,000 -100% - - - TOTAL REVENUES: 730,000 18% 865,000 249,716 632,916 EXPENSES 21- 000 -75 -00 -7001 EQUIPMENT 150,000 -17% 125,000 3 - 125,000 21- 000 -75 -00 -7005 VEHICLES 309,000 25% 385,000 4 - 313,316 21- 000 -75 -00 -7015 SKID STEER UPGRADE 4,500 111% 9,500 3,600 9,500 21- 000 -75 -00 -7107 TRUCK ACCESSORIES 14,000 0% 14,000 - 14,000 21- 000 -75 -00 -7115 SALT DOME 0 0% - - - 21- 000 -75 -00 -7130 FACILITY EXPANSION 200,000 0% 200,000 - 53,600 21- 000 -78 -00 -9009 RESERVE 52,500 70% 89,000 - 75,000 21- 000 -99 -00 -9941 TRANSFER TO PARKS CAPITAL 100% 42,500 21,250 42,500 TOTAL EXPENSES: 730,000 18% 865,000 24,850 632,916 'OTAL FUND REVENUES 730,000 865,000 249,716 632,916 i OTAL FUND EXPENSES 730,000 865,000 24,850 632,916 FUND SURPLUS (DEFICIT) 0 0 224,866 0 I COMMENTS: 1 Increased by new permit projections 2 3 Utility Trucks 3 Utility Machine w /mower & snow blower 4 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 Page 20 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL PARKS & RECREATION CAPITAL ACCOUNT 2006 -2007 2007 -2008 REVISED NUMBER DESCRIPTION Budget % Change Budget YTD BUDGET REVENUES 22- 000 -40 -00 -3999 CARRY OVER 13,100 702% 105,000 - 85,000 22- 000 -42 -00 -4216 PARKS CAPITAL FEE 26,000 15% 30,000 1 12,050 18,000 22- 000 -42 -00 -4217 PARK CAPTIAL DONATIONS 0 0% - - - 22- 000 -42 -00 -4218 IL CLEAN ENERGY GRANT 0 0% - - - 22- 000 -44 -00 -4430 SALE OF VEHICLES /EQUIPMENT 10,000 -100% - - 16,000 22- 000 -49 -00 -4950 TRANSFER FROM PW CAPITAL 100% 45,000 2 21,250 42,500 TOTAL REVENUES: 199,100 -10% 180,000 33,300 161,500 EXPENSES PARKS CAPITAL OUTLAY 22- 610 -65 -00 -5800 RESERVE 0 0% - - - 22- 610 -75 -00 -7006 PICK UP TRUCK 75,000 -40% 45,000 3 - 25,000 22- 610 -75 -00 -7015 PARKS EQUIPMENT 15,000 100% 30,000 4 - 66,000 22- 610 -75 -00 -7016 COMPUTER SERVER 5,000 4,729 5,000 22- 610 -75 -00 -7018 PARK REDEVELOPMENTS 105,000 -5 % 100,000 52,193 65,500 TOTAL EXPENSES: PARKS 196,500 -8% 180,000 56,922 161,500 TOTAL FUND REVENUES 199,100 180,000 33,300 161,500 TOTAL FUND EXPENSES 196,500 180,000 56,922 161,500 FUND SURPLUS (DEFICIT) 2,600 0 (23,622) 0 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 40 UNITED CITY OF YORKVILLE FY 07108 BUDGET 6 MONTH FINAL SEWER IMPROVEMENT Rio 2005 -2006 2006 -2007 Chang 2007 -2008 REVISED ACCOUNT NUMBER DESCRIPTION Actual Budget a Budget YTD 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 559,400 874,375 37- 000 -42 -00 -4221 RIVER CROSSING FEES 6,576 20,000 -100% - 151 150 37- 000 -46 -00 -4600 INVESTMENT INCOME 243,928 150,000 -50% 75,000 15,355 30,000 37- 000 -48 -00 -4803 ROB ROY CREEK REVENUE 12,150,313 0 100% 550,745 - 550,745 37- 000 -48 -00 -4804 SOUTHWEST SERVICE AREA INTERCPT 253,662 5,500,000 0% 5,500,000 - 5,500,000 37- 000 -48 -00 -4805 COUNTRYSIDE INTERCEPTOR - 0 0% - (22,967) - 37- 000 -49 -00 -4901 TRANSFER FROM GENERAL FUND 150,000 150,000 0% 150,000 75,000 150,000 TOTAL REVENUES: 18,101,950 10,526,800 -32% 7,180,236 626,939 7,105,270 EXPENSES 37- 000 -62 -00 -5401 CONTRACTUAL /PROFESSIONAL SVCS 7,218 40,000 -25% 30,000 - - 37- 000 -62 -00 -5402 ENG /LEGAL /CONTINGENCIES - COUNSDE 142,893 0 0% - 1,140 - 37- 000 -62 -00 -5405 ENG /LEGAL /CONTINGENCIES - BRUL ST. 94,428 0 0% - - 37- 000 -62 -00 -5406 ENGHLEGAL /CONTINGEN - HYDRALIC 1,940 0 0% - - 37- 000 -65 -00 -5421 GIS SYSTEM - 5,000 -100% - - - 37- 000 -65 -00 -5800 CONTINGENCY - 796,759 -100% - 37- 000 -66 -00 -6012 DEBT ISSUANCE COSTS 216,425 0 0% - - 37- 000 -75 -00 -7503 COUNTRYSIDE INTERCEPTOR 2,288,310 0 0% (883) 20,232 37- 000 -75 -00 -7504 BRUELL STREET LIFT STATION 821,296 0 0% - 8,188 - ?- 000 -75 -00 -7505 ROB ROY CREEK SANITARY 7,662,913 3,130,000 0% - 4,806 8,188 1- 000 -75 -00 -7506 SOUTHWEST SERVICE AREA INTERCPT 626,817 5,500,000 0% 5,500,000 - 5,504,807 37- 000 -75 -00 -7508 MANHOLE REHAB PROJECT 6,456 15,000 0% 15,000 - 11,807 37- 000 -75 -00 -7509 SCADA SYSTEM - 100,000 -25% 75,000 - - 37- 000 -75 -00 -7510 FOX HILL SANITARY SEWER RECAPTRE - 150,000 0% 150,000 - 150,000 37- 000 -75 -00 -7511 PALMER COURT 100% 50,000 - 50,000 37- 000 -75 -00 -7515 HRTLAND ONSITE INTERCEPT OVER SIZ 278,893 0 0% - - - 37- 000 -99 -00 -9901 TRANSFER TO GENERAL FUND 150,000 150,000 0% 150,000 75,000 150,000 37- 000 -99 -00 -9965 TRANSFER TO DEBT SERVICE 646,213 640,041 89 % 1,210,236 605,118 1,210,236 TOTAL EXPENSES: 12,943,801 10,526,800 -32% 7,180,236 693,369 7,105,270 TOTAL FUND REVENUES 18,101,950 10,526,800 7,180,236 626,939 7,105,270 TOTAL FUND EXPENSES 12,943,801 10,526,800 7,180,236 693,369 7,105,270 FUND SURPLUS (DEFICIT) 5,158,148 0 - (66,430) - Page 22 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL WATER IMPROVEMENT Rio ACCOUNT 2005 -2006 2006 -2007 Chang 2007 -2008 REVISED NUMBER DESCRIPTION Actual Budget a Budget YTD 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 667,760 1,062,000 41- 000 -42 -00 -4221 SOUTHWEST WATER MAIN PROJECT REVEI` 35,958 2,648,276 0% 2,648,276 - 2,000,000 41- 000 -42 -00 -4222 USGS SHALLOW WATER REVENUE - 0 0% - 96,000 96,000 41- 000 -46 -00 -4600 INVESTMENT INCOME 71,127 55,000 0% 55,000 14,808 30,000 LOAN PROCEEDS - 1,412,960 -100% - 456,410 456,410 41- 000 -49 -00 -4901 TRANSFER FROM GENERAL FUND 215,000 220,000 -9 % 200,000 100,000 200,000 TOTAL REVENUES: 3,906,658 8,364,318 -18% 6,887,516 1,334,978 3,844,410 EXPENSES 41- 000 -61 -00 -5300 LEGAL SERVICES 3,153 8,000 0% 8,000 - 8,000 41- 000 -61 -00 -5301 ENGINEERING - GENERAL SERVICES 14,636 20,000 100% 40,000 3,104 40,000 41- 000 -61 -00 -5400 RADIUM COMPLIANCE PROJECT /CONTRACT 1,001,893 1,238,082 -100% - 709 709 41- 000 -61 -00 -5401 ENGINEERING - RADIUM /CONTRACT B.2 & B.3 1,228,007 75,000 -100% - 38,073 40,000 41- 000 -61 -00 -5405 PROFESSIONAL SERVICE /CONTRACT B.2 & ; 31,686 20,000 150% 50,000 - 50,000 41- 000 -61 -00 -5415 USGS GROUNDWATER STUDY 40,290 10,500 -62% 4,000 - 4,000 41- 000 -61 -00 -5416 USGS GROUNDWATER STUDY COUNTYWIDI 1,582 15,000 -100% 13,128 13,128 41- 000 -61 -00 -5417 USGS GROUNDWATER STUDY SHALLOW Wi 65,923 50,000 -100% 1,173 1,173 41- 000 -61 -00 -5418 ENG WELL 4 REHAB H.1 - 0 0% - 400 400 1 1- 000 -65 -00 -5800 CONTINGENCY 23,388 1,124,677 221% 3,608,441 59,978 442,843 1- 000 -75 -00 -7509 SCADA System 17,360 450,000 -100% 22,312 22,313 41- 000 -75 -00 -7510 SW INTERCEPTOR 100% 2,000,000 - 2,000,000 41- 000 -75 -00 -7520 WATERMAIN PROJECTS - 311,000 -4% 300,000 7,009 217,289 41- 000 -75 -00 -7522 IN TOWN ROAD PROGRAM WATER PROJECI - 220,000 0% 220,000 102,004 220,000 41- 000 -99 -00 -9901 TRANSFER TO GENERAL FUND 200,000 200,000 0% 200,000 100,000 200,000 41- 000 -99 -00 -9965 TRANSFER TO DEBT FUND 296,442 443,121 3% 457,075 228,538 584,555 TOTAL EXPENSES: 3,394,963 8,364,318 -18% 6,887,516 576,428 3,844,410 TOTAL FUND REVENUES 3,906,658 8,364,318 6,887,516 1,334,978 3,844,410 TOTAL FUND EXPENSES 3,394,963 8,364,318 6,887,516 576,428 3,844,410 FUND SURPLUS (DEFICIT) 511,694 0 - 758,550 - I I i I I i Page 23 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL DEBT SERVICE ACCOUNT 2005 -2006 2006 -2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Actual Budget Change Budget YTD BUDGET REVENUES 42- 000 -40 -00 -3999 CARRY OVER 13,918 0 0% 0.00 0.00 - 42- 000 -44 -00 -4440 RECAPTURE- WATER/SEWER 114,554 125,000 0% 125,000 23,076 44,500 42- 000 -44 -00 -4441 LIBRARY BOND REFERENDUM - 0 100% 421,936 578,661 578,661 42- 000 -49 -00 -4901 TRANSFER FROM GENERAL FUND - 292,859 -3% 284,202 142,102 231,884 42- 000 -49 -00 -4910 TRANSFER FROM POLICE EQUIP CAP 24,110 0 0% 0.00 0.00 - 42- 000 -49 -00 -4925 TRANSFER FROM SANITARY SEWER 646,213 640,041 89% 1,210,236 605,118 1,210,236 42- 000 -49 -00 -4930 TRANSFER FROM WATER IMPRV FUND 296,442 443,121 3% 457,075 228,538 584,555 42- 000 -49 -00 -4940 TRANSFER FROM MUNICIPAL BLDG 103,923 102,423 0% 102,423 51,212 102,423 TOTAL REVENUES: 1,199,160 1,603,444 62% 2,600,872 1,628,707 2,752,259 EXPENSES 42- 000 -66 -00 -6001 CITY HALL BONDS - PRINCIPAL PMT 50,000 50,000 0% 50,000 0 50,000 42- 000 -66 -00 -6002 CITY HALL BONDS - INTEREST PMT 53,923 52,423 -88% 6,400 3,200 6,400 42- 000 -66 -00 -6003 IRBB - BRUELL STREET INTEREST PYMT 85,435 83,795 -2% 81,794 40,898 81,795 42- 000 -66 -00 -6004 IRBB - BRUELL STREET PRINCIPAL PYMT 80,000 80,000 0% 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 58,313 160,630 42- 000 -66 -00 -6008 COUNTRYSIDE ALT REV PRINCIPAL PYMT 120,000 125,000 8% 135,000 0 135,000 42- 000 -66 -00 -6009 COUNTRYSIDE ALT REV INTEREST PYMT 120,638 117,638 -3% 114,513 57,256 114,513 42- 000 -66 -00 -6010 COM ED /HYDRAULIC DEBT CERT. INT PYMT 43,217 41,328 -6% 38,947 19,474 38,947 42- 000 -66 -00 -6011 COM ED /HYDRAULIC DEBT CERT. PRINC. 135,000 140,000 4% 145,000 0 145,000 42- 000 -66 -00 -6013 Library Bond 2005bB Interest - 0 100% 321,125 160,563 321,125 42- 000 -66 -00 -6015 Library Bond 2006 Interest - 0 100% 100,811 65,160 130,322 000 -66 -00 -6016 ROB ROY CREEK BOND - 0 100% 468,950 234,475 468,950 IEPA DRINKING WTR PROD L17 -1563 0 0 56 IEPA DRINK WTR PROJ L17 -1563 INT 0 0 52,708 42- 000 -66 -00 -6049 SANITARY SIPHON L17- 115300 INTEREST 38,980 8,301 0% 8,301 3,737 8,301 2007 A GO REFUND 02, 02A, 03 0 83,476 42- 000 -66 -00 -6050 SANITARY SIPHON L17- 115300 PRINCIPAL - 30,679 0% 30,679 15,753 30,679 42- 000 -66 -00 -6055 LOAN PAYMENT - SSES IEPA L17 -1153 PRINC - 31,275 242% 107,051 108,142 109,234 42- 000 -66 -00 -6056 Refunding 2006 Interest 100% 95,027 48,974 95,027 42- 000 -66 -00 -6057 Refunding 2006 A Principal 100% 5,100 0 5,100 42- 000 -66 -00 -6058 $2.8M North Water Tower 2002 Issue 100% 60,000 0 42- 000 -66 -00 -6070 $650K ROAD IMPROVEMENT PROG INT. 14,273 26,070 -12% 22,820 0 22,820 42- 000 -66 -00 -6071 $6501K ROAD IMPROVEMENT PROG PRINC 50,000 65,000 15% 75,000 0 75,000 42- 000 -66 -00 -6072 2 MILLION ALT REVENUE (B.2 & B.3) INT. 29,800 90,150 -1% 88,925 55,873 88,925 42- 000 -66 -00 -6073 2 MILLION ALT REVENUE (B.2 & B.3) PRINC - 35,000 114% 75,000 0 75,000 42- 000 -66 -00 -6074 $3.825 MILLION IN TOWN ROAD - INT. - 262,859 -40% 156,779 78,389 156,779 42- 000 -66 -00 -6075 $3.825 MILLION IN TOWN ROAD - PRINC - 55,001 191% 160,000 0 160,000 TOTAL EXPENSES: 1,161,464 1,603,444 62% 2,600,872 950,206 2,752,259 TOTAL FUND REVENUES 1,199,160 1,603,444 2,600,872 1,628,707 2,752,259 TOTAL FUND EXPENSES 1,161,464 1,603,444 2,600,872 950,206 2,752,259 FUND SURPLUS (DEFICIT) 37,696 0 0 678,501 - I Page 24 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL WATER OPERATIONS 2006 -2007 % 2007 -2008 REVISED ACCOUNT NUMBER DESCRIPTION Budget Change Budget YTD BUDGET REVENUES 51- 000 -40 -00 -3999 CARRY OVER BALANCE 500,000 -100% - - - 51- 000 -42 -00 -4240 BULK WATER SALES 10,000 0% 10,000 8,806 20,000 51- 000 -42 -00 -4241 WATER SALES 1,150,000 13% 1,300,000 917,861 1,350,000 51- 000 -42 -00 -4242 WATER METER SALES 220,000 77% 390,000 1 176,016 240,000 51- 000 -42 -00 -4243 LEASE REVENUE - H2O TOWER 25,000 24% 31,000 2 11,801 31,000 51- 000 -46 -00 -4600 INVESTMENT INCOME 15,000 58% 23,683 34,229 35,000 TOTAL REVENUES: 1,922,000 -9% 1,754,683 1,148,713 1,676,000 EXPENSES 51- 000 -50 -00 -5107 SALARIES - EMPLOYEE 318,439 -7% 297,738 170,024 350,000 51- 000 -50 -00 -5136 SALARIES -PART TIME 8,500 0% 8,500 3,413 8,500 51- 000 -50 -00 -5137 SALARIES - OVERTIME 40,000 0% 40,000 16,678 40,000 51- 000 -61 -00 -5300 LEGAL SERVICES 2,000 0% 2,000 - 2,000 51- 000 -61 -00 -5303 JULIE SERVICE 10,000 10% 11,000 3 4,715 11,000 51- 000 -62 -00 -5401 CONTRACTUAL SERVICES 5,000 80% 9,000 4 2,143 9,000 51- 000 -62 -00 -5407 TREATMENT FACILITIES O & M 100,000 57% 157,000 84,047 157,000 51- 000 -62 -00 -5408 MAINTENANCE - EQUIPMENT 9,000 -44% 5,000 1,467 5,000 - 000 -62 -00 -5409 MAINTENANCE - VEHICLES 7,000 0% 7,000 1,858 7,000 a1 000 -62 -00 -5411 MAINTENANCE - COMPUTERS 1,000 -50% 500 - - 51- 000 -62 -00 -5413 MAINTENANCE - CONTROL SYSTEM 10,000 -100% 5 775 775 51- 000 -62 -00 -5421 WEARING APPAREL 5,500 -12% 4,850 6 1,857 4,850 51- 000 -62 -00 -5434 RENTAL - EQUIPMENT 2,000 0% 2,000 - 2,000 51- 000 -62 -00 -5435 ELECTRICITY 130,000 24% 161,200 7 149,415 250,000 51- 000 -62 -00 -5436 TELEPHONE 22,000 0% 22,000 8,037 22,000 51- 000 -62 -00 -5438 CELLULAR TELEPHONE 5,700 -42% 3,300 8 1,725 3,300 51- 000 -64 -00 -5600 DUES 1,000 0% 1,000 591 1,000 51- 000 -64 -00 -5603 SUBSCRIPTIONS 250 0% 250 110 250 51- 000 -64 -00 -5604 TRAINING & CONFERENCES 5,000 -42% 2,900 9 330 2,900 51- 000 -64 -00 -5605 TRAVEL / MEALS / LODGING 5,000 8% 5,400 1,212 5,400 51- 000 -65 -00 -5800 CONTINGENCIES 30,000 -100% - - - 51- 000 -65 -00 -5804 OPERATING SUPPLIES 48,500 3% 50,000 28,652 50,000 51- 000 -65 -00 -5808 POSTAGE & SHIPPING 15,000 20% 18,000 7,537 18,000 51- 000 -65 -00 -5809 PRINTING & COPYING 9,075 21% 11,000 6,282 11,000 51- 000 -65 -00 -5810 PUBLISHING &ADVERTISING 1,000 0% 1,000 240 1,000 51- 000 -65 -00 -5812 GASOLINE 15,000 133% 35,000 12,250 35,000 51'- 000 -65 -00 -5815 HAND TOOLS 2,000 -50% 1,000 1,231 1,300 51- 000 -65 -00 -5817 GRAVEL 6,000 -17% 5,000 1,179 5,000 51- 000 -65 -00 -5820 CHEMICALS 30,000 -100% - - 51- 000 -65 -00 -5821 CATHODIC PROTECTION 0 0% - - - 51- 000 -65 -00 -5822 WATER SAMPLES 12,000 17% 14,000 6,929 14,000 �- 000 -72 -00 -6500 IMRF PARTICIPANTS 28,317 -10% 25,467 14,207 30,250 Page 25 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL WATER OPERATIONS 2006 -2007 % 2007 -2008 REVISED ACCOUNT NUMBER DESCRIPTION Budget Change Budget YTD BUDGET EXPENSES CONT'D 51- 000 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 28,071 -9% 25,601 14,634 30,000 51- 000 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 5,000 -70% 1,500 10 1,096 1,500 51- 000 -75 -00 -7004 SAFETY EQUIPMENT 3,000 0% 3,000 236 1,500 51- 000 -75 -00 -7506 METER READERS 11,500 4% 12,000 2,611 12,000 51- 000 -75 -00 -7507 HYDRANT REPLACEMENT 10,000 0% 10,000 3,840 10,000 51- 000 -75 -00 -7508 METERS & PARTS 265,000 13% 300,000 123,653 266,976 51- 000 -78 -00 -9005 REFUND 1,500 0% 1,500 11 - 1,500 51- 000 -78 -00 -9006 MERIT 10,543 13% 11,910 - - 51- 000 -78 -00 -9009 RESERVE 373,105 -41% 221,557 1,596 54,999 51- 000 -78 -00 -9012 SALARY SURVEY 0 100% 16,510 - - 51- 000 -99 -00 -9901 TRANSFER TO GENERAL FUND 250,000 0% 250,000 125,000 250,000 51- 000 -99 -00 -9950 TRANSFER TO PW EQUIP CAPITAL 50,000 -100% - - - TOTAL EXPENSES: 1,922,000 -9% 1,754,683 799,571 1,676,000 TOTAL FUND REVENUES 1,922,000 1,754,683 1,148,713 1,676,000 TOTAL FUND EXPENSES 1,922,000 1,754,683 799,571 1,676,000 FUND SURPLUS (DEFICIT) 0 0 349,142 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 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL SEWER MAINTENANCE ^ 2006 -2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Budget Change Budget YTD BUDGET REVENUES 52- 000 -40 -00 -3999 CARRY OVER/FUND BALANCE 350,000 -100% - - 52- 000 -42 -00 -4240 LIFT STATION INCOME 8,000 0% 8,000 1 588 4,000 52- 000 -42 -00 -4250 SEWER MAINTENANCE FEES 475,000 2% 486,000 2 327,357 486,000 52- 000 -42 -00 -4251 SEWER CONNECTION FEES 260,000 0% 260,000 97,800 146,000 52- 000 -46 -00 -4600 INVESTMENT INCOME 15,000 0 % 15,000 34,229 35,000 TOTAL REVENUES: 1,108,000 -31% 769,000 459,974 671,000 EXPENSES 52- 000 -50 -00 -5108 SALARIES - REGULAR 141,858 9% 154,756 69,199 170,343 52- 000 -50 -00 -5136 PART TIME 4,200 19% 5,000 3 340 1,000 52- 000 -50 -00 -5137 SALARIES - OVERTIME 12,000 0% 12,000 781 12,000 52- 000 -62 -00 -5401 CONTRACTUAL SERVICES 5,000 60% 8,000 4 1,286 4,000 52- 000 -62 -00 -5408 MAINTENANCE - EQUIPMENT 5,000 0% 5,000 1,773 4,500 52- 000 -62 -00 -5409 MAINTENANCE- VEHICLES 4,000 0% 4,000 993 3,500 52- 000 -62 -00 -5419 MAINTENANCE - SANITARY SEWER 27,500 -27% 20,000 1,557 20,000 52- 000 -62 -00 -5421 WEARING APPAREL 3,500 -33% 2,350 5 1,209 2,350 52- 000 -62 -00 -5422 LIFT STATION MAINTENANCE 25,000 0% 25,000 2,895 25,000 52- 000 -62 -00 -5434 RENTAL - EQUIPMENT 1,000 0% 1,000 - 1,000 - "- 000 -62 -00 -5435 ELECTRICITY 14,400 421% 75,000 3,987 50,000 - 000 -62 -00 -5438 CELLULAR TELEPHONE 2,500 -30% 1,750 6 1,323 2,500 52- 000 -64 -00 -5604 TRAINING & CONFERENCES 4,000 -50% 2,000 7 650 2,000 52- 000 -64 -00 -5605 TRAVEL / MEALS / LODGING 3,000 0% 3,000 388 3,000 52- 000 -65 -00 -5800 CONTINGENCIES 10,000 -49% 5,054 - 5,054 52- 000 -65 -00 -5802 OFFICE SUPPLIES 2,500 20% 3,000 620 2,500 52- 000 -65 -00 -5805 SHOP SUPPLIES 2,500 20% 3,000 850 2,500 52- 000 -65 -00 -5812 GASOLINE 14,000 11% 15,500 12,032 25,000 52- 000 -65 -00 -5815 HAND TOOLS 2,000 -50% 1,000 680 1,200 52- 000 -65 -00 -5817 GRAVEL 3,000 0% 3,000 874 3,000 52- 000 -72 -00 -6500 IMRF PARTICIPANTS 12,155 10% 13,344 5,325 13,344 52- 000 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 12,091 11% 13,414 5,380 13,414 52- 000 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 2,500 -20% 2,000 51 2,000 52- 000 -75 -00 -7003 OFFICE EQUIPMENT 6,000 0% 6,000 8 828 5,000 52- 000 -75 -00 -7004 SAFETY EQUIPMENT 2,000 0% 2,000 210 2,000 52- 000 -78 -00 -9005 MERIT 5,282 17% 6,190 - - 52- 000 -78 -00 -9009 RESERVE 676,013 -56% 296,667 - 224,217 52- 000 -78 -00 -9012 SALARY SURVEY 0 100% 9,397 - - 52- 000 -99 -00 -9901 TRANSFER TO GENERAL FUND 70,000 1% 70,578 35,290 70,578 52- 000 -99 -00 -9950 TRANSFER TO PW EQUIP CAPITAL 30,000 -100% - - 0 TOTAL EXPENSES: 1,108,000 -31% 769,000 148,522 671,000 TOTAL FUND REVENUES 1,108,000 769,000 459,974 671,000 TOTAL FUND EXPENSES 1,108,000 769,000 148,522 671,000 'ND SURPLUS (DEFICIT) 0 0 311,452 0 i Page 27 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL SEWER MAINTENANCE r,CCOUNT 2006- 2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Budget Change Budget YTD 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; Rep[ 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'l, 1 state $1,413 8 desks for PW remodel I I i I i I Page 28 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL LAND CASH _.;COUNT 2006 -2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Budget Change Budget YTD BUDGET REVENUES 72- 000 -40 -00 -3999 CARRY OVER / STARTING BALANCE (202,757) -74% (52,757) - (251,283) 72- 000 -47 -00 -4700 OSLAD GRANT - PRAIRIE MEADOW 0 100% 400,000 1 - 400,000 72- 000 -47 -00 -4700 OSLAD GRANT - WHISPERING MEA 362,000 0% 362,000 2 - 362,000 72- 000 -47 -00 -4702 BIKE PATH GRANT 0 100% 200,000 3 - - 72- 000 -47 -00 -4705 COUNTRY HILLS -LAND CASH 30,825 -96% 1,200 - 1,200 72- 000 -47 -00 -4709 SUNFLOWER -LAND CASH 0 0% 0 361 361 72- 000 -47 -00 -4712 RIVER'S EDGE -LAND CASH 13,285 -80% 2,684 - 2,684 72- 000 -47 -00 -4717 KYLYN'S CROSSING - LAND CASH 3,367 -53% 1,570 - 1,570 72- 000 -47 -00 -4722 KYLN'S RIDGE -LAND CASH 0 0% 0 128,000 - CANNONBALL RIDGE GRANT 0 0 - 128,000 72- 000 -47 -00 -4723 HEARTLAND CIRCLE -LAND CASH 49,500 -60% 20,000 - 20,000 72- 000 -47 -00 -4734 WHISPERING MEADOWS - (Kimball Hill) 41,868 -66% 14,100 9,586 14,100 72- 000 -47 -00 -4736 GerReF Stone BRIARWOOD 113,043 0% 113,043 - 113,043 72- 000 -47 -00 -4738 AUTUMN CREEK 85,765 -74% 22,280 26,517 26,517 72- 000 -47 -00 -4740 VILLAS AT THE PRESERVE 90,008 -15% 76,335 0 - 72- 000 -47 -00 -4744 HUDSON LAKES 28,449 -65% 10,000 0 10,000 72- 000 -47 -00 -4745 PRESTWICK 76,303 -74% 20,000 6,607 20,000 72- 000 -47 -00 -4746 WESTBURY EAST 62,414 -68% 20,000 0 - 72- 000 -47 -00 -4749 BLACKBERRY WOODS 0 4,545 4,545 '- 000 -47 -00 -4750 KENDALLWOOD ESTATES 100% 10,000 0 10,000 72- 000 -49 -00 -4901 TRANSFER FROM GENERAL FUND - 100% 48,245 24,122 48,245 TOTAL REVENUES: 1,830,052 -31% 1,268,700 199,739 910,982 EXPENSES 72- 000 -75 -00 -7308 RIVER'S EDGE PARK II 0 100% 25,000 - - 72- 000 -75 -00 -7326 MOSIER HOLDING COSTS 0 100% 15,700 10,000 15,700 72- 000 -75 -00 -7327 GRANDE RESERVE PARK DEVELOPME 0 0% 16,680 72- 000 -75 -00 -7328 PRAIRIE MEADOWS - (Menards Res.) 6,000 7267% 442,000 34,267 150,000 72- 000 -75 -00 -7330 WHISPERING MEADOWS - (Kimball Hill) 724,000 -3% 700,000 67,192 350,000 72- 000 -75 -00 -7333 RAINTREE VILLAGE 80,000 -88% 10,000 4 1,800 - 72- 000 -75 -00 -7334 HOOVER HOLDING COSTS 100,000 -40% 60,000 5 - 60,000 72- 000 -78 -00 -9009 RESERVE 212,809 - 100% - 6 - 319,282 72- 000 -99 -00 -9901 TRANSFER TO GENERAL FUND 16,000 0 % 16,000 7 8,000 16,000 TOTAL EXPENSES: 1,882,809 -33% 1,268,700 137,938 910,982 TOTAL FUND REVENUES 1,830,052 1,268,700 199,739 910,982 TOTAL FUND EXPENSES 1,882,809 1,268,700 137,938 910,982 FUND SURPLUS (DEFICIT) (52,757) 0 61,800 - 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 Page 29 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL LAND CASH . ,,COUNT 2006 -2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Budget Change Budget YTD BUDGET 7 Designer Salary I Page 30 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL LAND ACQUISITION 2006 -2007 2007 -2008 REVISED ACCOUNT NUMBER DESCRIPTION Budget % Change Budget YTD BUDGET REVENUES 73- 000 -40 -00 -3999 CARRY OVER BALANCE 213,618 -77% 50,000 - 50,000 73- 000 -49 -00 -4935 TRANSFER FROM LAND CASH 0 0% - - - TOTAL REVENUES: 213,618 -77% 50,000 - 50,000 EXPENSES LAND ACQUISITION 150,000 0% - - 49,000 LAND APPRAISALS 0 - - 1,000 73- 000 -65 -00 -5800 CONTINGENCY 50,000 0 % 50,000 - - TOTAL EXPENSES: 213,618 -77% 50,000 - 50,000 TOTAL FUND REVENUES 213,618 50,000 - 50,000 TOTAL FUND EXPENSES 213,618 50,000 - 50,000 FUND SURPLUS (DEFICIT) 0 0 0 0 Page 31 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL PARKS & RECREATION 2006 -2007 % 2007 -2008 REVISED ACCOUNT NUMBER DESCRIPTION Budget Change Budget YTD BUDGET REVENUES 79- 000 -40 -00 -3999 CARRY OVER BALANCE 50,000 -100% - - 42,540 79- 000 -42 -00 -4270 FEES FOR PROGRAMS 266,000 -6% 250,000 1 150,583 275,000 79- 000 -42 -00 -4280 CONCESSIONS /ALL SALE ITEMS 15,000 72% 25,864 15,087 18,000 79- 000 -42 -00 -4281 BEECHER BLDG DEPOSITS 1,500 0% 1,500 - 1,500 79- 000 -42 -00 -4285 VENDING MACHINE INCOME 650 -38% 400 2,150 2,150 79- 000 -42 -00 -4287 PARK RENTAL INCOME(SHELTEPS) 1,000 -40% 600 1,815 1,815 79- 000 -42 -00 -4288 GOLF OUTING REVENUE 38,000 7% 40,700 30,694 30,694 79- 000 -42 -00 -4291 HOMETOWN DAYS 30,000 293% 118,000 110,937 110,936 79- 000 -44 -00 -4400 DONATIONS 15,000 27% 19,000 5,917 13,000 79- 000 -44 -00 -4404 TREE DONATIONS 600 33% 800 764 1,300 79- 000 -45 -00 -4550 YOUTH SERVICES GRANT 2,000 0% 2,000 1,000 3,600 79- 000 -46 -00 -4600 INVESTMENT INCOME 6,500 54% 10,000 4,020 6,200 79- 000 -49 -00 -4901 TRANSFER FROM GENERAL FUND 1,046,127 11% 1,161,778 582,889 1,161,778 TOTAL REVENUES: 1,472,377 11% 1,630,642 905,856 1,668,513 i PARKS EXPENSES 79- 610 -50 -00 -5107 SALARIES - EMPLOYEES 383,107 -12% 339,047 212,528 427,000 79- 610 -50 -00 -5136 SALARIES - PART -TIME 48,000 21% 58,000 31,842 48,000 79- 610 -50 -00 -5137 SALARIES - OVERTIME 8,000 13% 9,000 2,982 7,000 79- 610 -61 -00 -5320 MASTER PLAN / COMMUNITY SURVEY 0 0% 13,000 765 10,500 9- 610 -62 -00 -5405 PARK CONTRACTUAL 18,000 25% 22,500 2 17,099 21,500 79- 610 -62 -00 -5408 MAINTENANCE - EQUIPMENT 10,000 0% 10,000 2,790 8,000 79- 610 -62 -00 -5417 MAINTENANCE -PARKS 40,000 25% 50,000 7,541 50,000 79- 610 -62 -00 -5421 WEARING APPAREL 8,000 0% 8,000 2,816 7,000 79- 610 -62 -00 -5434 RENTAL - EQUIPMENT 1,700 18% 2,000 1,161 3,000 79- 610 -62 -00 -5438 CELLULAR TELEPHONE 5,750 -13% 5,000 1,746 4,000 79- 610 -62 -00 -5440 LAND DEVELOPER 10,000 -100% - - 8,550 79- 610 -62 -00 -5445 LEGAL EXPENSES 10,000 -50% 5,000 607 3,000 79- 610 -64 -00 -5604 TRAINING AND CONFERENCE 0 100% 9,000 3 1,770 8,000 79- 610 -64 -00 -5605 TRAVEL EXPENSE 3,800 -21% 3,000 469 3,000 79- 610 -65 -00 -5802 OFFICE SUPPLIES 1,500 0% 1,500 63 1,500 79- 610 -65 -00 -5804 OPERATING SUPPLIES 30,000 0% 30,000 16,063 30,000 79- 610 -65 -00 -5815 HAND TOOLS 3,000 17% 3,500 975 3,500 79- 610 -65 -00 -5824 CHRISTMAS DECORATIONS 7,000 -29% 5,000 40 5,000 79- 610 -65 -00 -5825 PUBLIC DECORATION 3,000 0% 3,000 818 3,000 79- 610 -72 -00 -6500 IMRF PARTICIPANTS 30,897 2% 31,420 16,348 32,500 79- 610 -72 -00 -6501 SOCIAL SECURITY /MEDICARE 33,592 -6% 31,585 18,835 37,750 79- 610 -75 -00 -7003 OFFICE EQUIPMENT 6,000 -50% 3,000 - 2,500 79- 610 -75 -00 -7701 FLOWERS/TREES 7,000 14% 8,000 634 7,000 79- 610 -75 -00 -9012 SALARY SURVEY 0 100% 15,827 - - 79- 610 -78 -00 -9005 MERIT 11,053 14 % 12,642 - - TOTAL EXPENSES: PARKS 691,899 -2% 679,020 337,891 731,300 Page 32 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL PARKS & RECREATION 2006 -2007 % 2007 -2008 REVISED ACCOUNT NUMBER DESCRIPTION Budget Change Budget YTD BUDGET I RECREATION EXPENSES 79- 650 -50 -00 -5107 EMPLOYEE SALARIES 312,226 15% 358,532 196,447 393,000 79- 650 -50 -00 -5108 CONCESSION STAFF 4,000 69% 6,750 5,844 6,750 79- 650 -50 -00 -5109 PRE SCHOOL SALARIES 87,000 -3% 84,000 27,872 83,000 79- 650 -50 -00 -5137 OVERTIME 0 0% - 15 15 79- 650 -50 -00 -5150 SALARIES - INSTRUCTOR CONTRACTUAL 58,400 -2% 57,400 38,261 57,400 79- 650 -50 -00 -5155 SALARIES - RECORDING SECRETARY 3,000 -17% 2,500 1,252 2,500 79- 650 -62 -00 -5408 MAINTENANCE SUPPLIES 5,000 40% 7,000 2,581 5,000 79- 650 -62 -00 -5409 MAINTENANCE - VEHICLES 1,200 192% 3,500 602 2,500 79- 650 -62 -00 -5410 MAINTENANCE - OFFICE EQUIPMENT 6,500 0% 6,500 2,734 6,000 79- 650 -62 -00 -5426 YOUTH SERVICES GRANT EXPENSES 2,000 0% 2,000 326 2,000 79- 650 -62 -00 -5435 ELECTRICITY 0 0% - 6,429 8,820 79- 650 -62 -00 -5437 TELEPHONE /INTERNET 1,600 -19% 1,300 556 1,300 79- 650 -62 -00 -5438 CELLULAR TELEPHONE 6,500 -15% 5,500 2,384 5,000 79- 650 -62 -00 -5445 PORTABLE TOILETS 5,000 20% 6,000 6,863 7,000 79- 650 -62 -00 -5603 PUBLISHING /ADVERTISING 25,700 9% 27,920 6,874 27,920 79- 650 -62 -00 -5605 BOOKS /PUBLICATIONS 750 -33% 500 - 500 79- 650 -62 -00 -5606 REST DEPOSIT REFUND 1,500 0% 1,500 - 1,500 79- 650 -64 -00 -5600 DUES 2,700 -7% 2,500 701 2,500 79- 650 -64 -00 -5604 TRAINING AND CONFERENCE 7,500 36% 10,200 4 1,240 10,200 79- 650 -64 -00 -5605 TRAVEL EXPENSE 2,500 109% 5,220 223 5,220 9- 650 -65 -00 -5802 OFFICE SUPPLIES 7,000 0% 7,000 3,139 6,000 79- 650 -65 -00 -5803 PROGRAM EXPENSES 50,400 -1% 50,100 30,312 50,100 79- 650 -65 -00 -5804 OPERATING SUPPLIES 4,200 -10% 3,800 463 3,800 79- 650 -65 -00 -5805 RECREATION EQUIPMENT 8,000 -11% 7,100 1,964 6,000 79- 650 -65 -00 -5808 POSTAGE & SHIPPING 7,200 6% 7,600 5,288 7,600 79- 650 -65 -00 -5812 GASOLINE 3,600 17% 4,200 2,256 4,200 79- 650 -65 -00 -5826 MILEAGE 750 0% 750 72 200 79- 650 -65 -00 -5827 GOLF OUTING EXPENSES 20,000 15% 23,000 18,779 18,780 79- 650 -65 -00 -5828 CONCESSIONS 9,000 72% 15,500 16,650 17,650 79- 650 -65 -00 -5833 HOMETOWN DAYS EXPENSES 25,000 332% 108,000 95,685 95,686 79- 650 -65 -00 -5840 SCHOLARSHIPS 3,600 0% 3,600 437 1,800 79- 650 -65 -00 -5841 PROGRAM REFUND 7,000 -7% 6,500 5,386 8,000 79- 650 -72 -00 -6500 IMRF PARTICIPANTS 24,666 47% 36,346 15,551 36,346 79- 650 -72 -00 -6501 SOCIAL SECURITY /MEDICARE 35,544 3% 36,537 19,184 36,537 79- 650 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 4,750 -57% 2,025 5 310 2,025 79- 650 -78 -00 -9009 RESERVE 27,688 -36% 17,700 5,372 14,364 79- 650 -78 -00 -9012 SALARY SURVEY 0 100% 15,559 - - 79- 650 -78 -00 -9005 MERIT 9,004 94 % 17,482 - TOTAL EXPENSES: RECREATION 780,478 22% 951,622 522,051 937,213 TOTAL FUND REVENUES 1,472,377 11% 1,630,642 905,856 1,668,513 TOTAL FUND EXPENSES 1,472,377 11% 1,630,642 859,943 1,668,513 FUND SURPLUS (DEFICIT) 0 0 45,913 0 Page 33 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL PARKS & RECREATION 2006 -2007 % 2007 -2008 REVISED ACCOUNT NUMBER DESCRIPTION Budget Change Budget YTD 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 I I Page 34 of 40 UNITED CITY OF YORKVILLE FY 07108 BUDGET 6 MONTH FINAL LIBRARY 8/14/07 ACCOUNT 2006 - 2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Budget Change Budget BUDGET YTD REVENUES 82- 000 -40 -00 -3999 CARRY OVER 231,590 41% 325,749 336,372 - CARRY OVER - BOND EXPAN 82- 000 -40 -00 -3996 CARRY OVER - BOOK DEV FEES 0 0% - - 82- 000 -40 -00 -3997 CARRY OVER - BLDG DEV FEES 7,263,881 -100% - - - 82- 000 -40 -00 -4000 REAL ESTATE TAXES 464,741 21% 560,702 627,000 172,686 82- 000 -40 -00 -4010 PERSONAL PROPERTY TAX 2,500 34% 3,360 3,360 2,443 82- 000 -42 -00 -4211 DEVELOPMENT FEES - BUILDING 95,000 58% 150,000 150,000 54,275 82- 000 -42 -00 -4215 DEVELOPMENT FEES -BOOKS 95,000 58% 150,000 150,000 54,275 82- 000 -42 -00 -4260 COPY FEES 900 36% 1,221 1,221 1,254 82- 000 -42 -00 -4261 LIBRARY SUBSCRIPTION CARDS 8,000 6% 8,500 8,500 8,797 82- 000 -42 -00 -4286 RENTAL INCOME 1,000 -4% 960 960 2,040 82- 000 -42 -00 -4287 LIBRARY BLDG RENTAL 0 0% - - 195 82- 000 -43 -00 -4330 LIBRARY FINES 3,000 -6% 2,808 2,808 3,784 82- 000 -44 -00 -4432 SALE OF BOOKS 500 129% 1,144 1,144 598 82- 000 -44 -00 -4450 MEMORIALS 5,000 -36% 3,202 3,202 5,719 82- 000 -45 -00 -4550 GRANTS 1,000 1650% 17,500 17,500 - 82- 000 -46 -00 -4600 INVESTMENT INCOME 1,500 307% 6,102 6,102 13,177 82- 000 -46 -00 -4601 INVESTMENT INCOME -BLDG 100,000 -100% - - 7,143 TOTAL REVENUES: 8,316,562 -85% 1,231,248 1,308,169 326,386 EXPENSES 82- 000 -50 -00 -5107 SALARIES - EMPLOYEES 350,000 35% 471,377 500,000 189,586 82- 000 -50 -00 -5203 GROUP HEALTH INSURANCE 55,000 -17% 45,717 45,717 20,278 82- 000 -50 -00 -5204 GROUP LIFE INSURANCE 2,000 -100% - 3,000 248 82- 000 -50 -00 -5205 DENTAL & VISION ASSISTANCE 6,000 -30% 4,200 4,200 1,098 82- 000 -61 -00 -5322 BONDING 2,000 -41% 1,176 1,176 1,875 82- 000 -61 -00 -5323 ATTORNEY 2,000 75% 3,500 3,500 - 82- 000 -62 -00 -5401 CONTRACT SERVICES 3,000 -100% 5,000 539 82- 000 -62 -00 -5407 MAINTENANCE - BLDG /JANITORIAL 5,000 0% 5,000 5,000 2,624 82- 000 -62 -00 -5410 MAINTENANCE - OFFICE EQUIP 3,000 67% 5,000 15,298 2,380 82- 000 -62 -00 -5412 MAINTENANCE - PHOTOCOPIER 1,000 1168% 12,680 12,680 102 82- 000 -62 -00 -5435 ELECTRICITY 2,500 1400% 37,500 37,500 263 82- 000 -62 -00 -5436 TELEPHONE 1,700 253% 6,000 6,000 2,106 82- 000 -62 -00 -5437 GAS HEAT 7,000 614% 50,000 50,000 7,119 82- 000 -64 -00 -5603 SUBSCRIPTIONS 4,000 -100% - 10,000 2,482 82- 000 -64 -00 -5604 TRAINING & CONFERENCES 1,500 33% 2,000 2,000 155 82- 000 -64 -00 -5607 PUBLIC RELATIONS 1,000 150% 2,500 2,500 - 82- 000 -64 -00 -5616 EMPLOYEE RECOGNITION 2,000 0% 2,000 2,000 55 82- 000 -65 -00 -5800 CONTINGENCIES 22,031 13% 25,000 25,000 2,958 82- 000 -65 -00 -5806 LIBRARY SUPPLIES 8,000 25% 10,000 10,000 3,072 82- 000 -65 -00 -5807 CUSTODIAL SUPPLIES 10,000 -10% 9,000 20,000 3,011 82- 000 -65 -00 -5802 OFFICE SUPPLIES 6,000 -100% - 10,000 2,097 82- 000 -65 -00 -5808 POSTAGE & SHIPPING 1,000 300% 4,000 3,000 537 82- 000 -65 -00 -5810 PUBLISHING & ADVERTISING 1,000 100% 2,000 2,000 36 82- 000 -65 -00 -5826 MILEAGE 1,000 0% 1,000 1,000 156 82- 000 -65 -00 -5832 VIDEOS 5,000 0% 5,000 5,000 2,013 82- 000 -65 -00 -5833 ALARM MONITORING 1,000 200% 3,000 3,000 - 82- 000 -65 -00 -5834 LIBRARY PROGRAMMING 12,000 -17% 10,000 10,000 2,183 Page 35 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL LIBRARY 8/14/07 ACCOUNT 2006 -2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Budget Change Budget BUDGET YTD LIBRARY EXPENSES CONT'D 82- 000 -65 -00 -5835 LIBRARY BOARD EXPENSES 1,000 100% 2,000 2,000 295 82- 000 -65 -00 -5836 BOOKS -ADULT 10,000 200% 30,000 30,000 8,211 82- 000 -65 -00 -5837 BOOKS - JUVENILE 10,000 200% 30,000 30,000 12,210 82- 000 -65 -00 -5838 BOOKS -AUDIO 10,000 0% 10,000 10,000 1,553 82- 000 -65 -00 -5839 BOOKS - REFERENCE 10,000 200% 30,000 30,000 544 82- 000 -65 -00 -5840 BOOKS - DEVELOPMENT FEE 95,000 58% 150,000 150,000 11,310 82- 000 -65 -00 -5841 MEMORIALS /GIFTS 5,000 -36% 3,202 3,202 - 82- 000 -65 -00 -5842 BLDG - DEVELOPMENT FEES 95,000 58% 150,000 150,000 - 82- 000 -65 -00 -5843 CD's /Music 100% 5,000 5,000 378 82- 000 -72 -00 -6500 IMRF PARTICIPANTS 9,000 74% 15,641 15,641 6,025 82- 000 -72 -00 -6501 SOCIAL SECURITY /MEDICARE 26,250 51% 39,755 39,755 14,504 82- 000 -75 -00 -7002 Computer Equipment & Software 100% 18,000 18,000 3,768 82- 000 -75 -00 -7003 AUTOMATION 164,700 -82% 30,000 30,000 10,118 82- 000 -75 -00 -7703 BUILDING EXPANSION 7,363,881 -100% - - 297,747 TOTAL EXPENSES: 8,316,562 -85% 1,231,248 1,308,169 613,639 TOTAL FUND REVENUES 8,316,562 1,231,248 1,308,169 326,386 TOTAL FUND EXPENSES 8,316,562 1,231,248 1,308,169 613,639 FUND SURPLUS (DEFICIT) 0 0 - (287,253) Page 36 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL FOX INDUSTRIAL ACCOUNT 2006 -2007 % 2007 -2008 REVISED NUMBER DESCRIPTION Budget Change Budget YTD BUDGET REVENUES 85- 000 -40 -00 -3999 CARRY OVER BALANCE 30,000 67% 50,000 - 87,553 85- 000 -40 -00 -4090 TIF REVENUES 75,000 0% 75,000 146,642 146,600 85- 000 -46 -00 -4600 INVESTMENT INCOME 3,000 17% 3,500 2,327 3,500 85- 000 -49 -00 -4905 TRANSFER FROM MFT FUND 0 0% - - - TOTAL REVENUES: 108,000 19% 128,500 148,968 237,653 EXPENSES 85- 000 -66 -00 -6021 FOX IND BOND - PRINCIPAL PMT 60,000 0% 60,000 - 60,000 85- 000 -66 -00 -6022 FOX IND BOND -INT PAYMENT 20,415 -12% 18,015 9,008 18,015 85- 000 -75 -00 -7901 FOX IND NON MFT PAYMENT 0 0% - - - 85- 000 -75 -00 -7902 FOX INDUSTRIAL EXPENSES 0 0% - - - 85- 000 -78 -00 -9007 ADMINISTRATION FEES 300 25% 375 - 375 85- 000 -78 -00 -9010 RESERVE - FUTURE BOND PYMT 27,285 84% 50,110 - 159,263 TOTAL EXPENSES: 108,000 19% 128,500 9,008 237,653 TOTAL FUND REVENUES 108,000 128,500 148,968 237,653 TOTAL FUND EXPENSES 108,000 128,500 9,008 237,653 -UND SURPLUS (DEFICIT) 0 0 139,961 0 Page 37 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL COUNTRYSIDE TIF 2006 -2007 % 2007 -2008 REVISED ACCOUNT NUMBER DESCRIPTION Budget Change Budget YTD BUDGET REVENUES 87- 000 -40 -00 -3999 CARRY OVER BALANCE 3,000,000 0% 3,000,000 - 2,919,125 87- 000 -40 -00 -4090 TIF REVENUES 0 0% - 3,965 3,965 87- 000 -46 -00 -4600 INVESTMENT INCOME 75,000 0 % 75,000 39,006 75,000 TOTAL REVENUES: 3,075,000 0% 3,075,000 42,971 2,998,090 EXPENSES 87- 000 -66 -00 -6021 BOND - PRINCIPAL PMT 0 0% - - - 87- 000 -66 -00 -6022 BOND -INT PAYMENT 142,868 0% 142,868 71,434 142,868 87- 000 -78 -00 -9007 ADMINISTRATION FEES 2,500 0% 2,500 1,125 2,500 87- 000 -78 -00 -9010 RESERVE - FUTURE BOND PYMT 2,929,632 0 % 2,929,632 - 2,852,722 TOTAL EXPENSES: 3,075,000 0% 3,075,000 72,559 2,998,090 TOTAL FUND REVENUES 3,075,000 3,075,000 42,971 2,998,090 TAL FUND EXPENSES 3,075,000 3,075,000 72,559 2,998,090 FUND SURPLUS (DEFICIT) 0 - (29,588) - i Page 38 of 40 UNITED CITY OF YORKVILLE FY 07/08 BUDGET 6 MONTH FINAL DOWNTOWN TIF 2006 -2007 % 2007 -2008 REVISED ACCOUNT NUMBER DESCRIPTION Budget Change Budget YTD BUDGET REVENUES 87- 000 -40 -00 -3999 CARRY OVER BALANCE 0 0% - - - 87- 000 -40 -00 -4090 TIF REVENUES 0 0% - 26,059 26,059 87- 000 -46 -00 -4600 INVESTMENT INCOME 0 0 % - - - TOTAL REVENUES: 0 0% - 26,059 26,059 EXPENSES 87- 000 -78 -00 -9007 ADMINISTRATION FEES 0 0% - 5,713 10,000 87- 000 -78 -00 -9010 RESERVE - FUTURE REIMB 0 0 % - - 16,059 TOTAL EXPENSES: 0 0% - 5,713 26,059 TOTAL FUND REVENUES 0 - 26,059 26,059 TOTAL FUND EXPENSES 0 - 5,713 26,059 .FUND SURPLUS (DEFICIT) 0 - 20,346 - Page 39 of 40 i Revenues Expenses General Fund 19,346,897 19,346,897 I MFT 679,652 679,652 Municipal Building 409,000 409,000 Police Capital 338,648 338,648 PW Capital 865,000 865,000 Park & Rec Capital 180,000 180,000 Sewer Improv 7,180,236 7,180,236 Water Improv 6,887,516 6,887,516 Debt Svc 2,600,872 2,600,872 Water Ops 1,754,683 1,754,683 Sewer Main 769,000 769,000 Land Cash 1,268,700 1,268,700 Land Acq 50,000 50,000 Park & Rec 1,630,642 1,630,642 Library 1,231,248 1,231,248 Fox Industrial TIF 128,500 128,500 Countryside TIF 3,075,000 3,075,000 Grand Total 48,395,594 48,395,594 i I