Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Ordinance 2008-030
STATE OF ILLINOIS COUNTY OF KENDALL - FILED - STATE OF ILLINOIS ) APR 2 8 2008 ) ss COUNTY CLERK COUNTY OF KENDALL ) KENDALL COUNTY ORDINANCE NO. 2008- ORDINANCE APPROVING THE 2008 -2009 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 2008 -2009 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 2008 -2009 Fiscal Year Budget being submitted on April 8, 2008 at its regular City Council Meeting: NOW, THEREFORE, BE IT ORDAINED, by the Mayor and City Council of the United City of Yorkville, Kendall County, Illinois that the 2008 -2009 Budget totaling $42,788,081 including the amounts of $13,331,770 General Fund, $614,520 Motor Fuel Tax Fund, $100,000 Municipal Building, $337,148 Police Equipment Capital Fund, $358,600 Public Works Equipment Capital Fund, $64,948 Parks & Recreation Equipment Capital, $4,022,160 Sanitary Sewer Maintenance and Improvements, $14,636,857 Water Improvements & Operation, $1,155,000 City Wide Capital, $484,524 Debt Service Fund, $1,020,000 Land Cash, $1,734,798 Parks & Recreation, $1,742,519 Library, $174,854 Fox Industrial, $2,931,390 Countryside TIF, $56,693 Downtown TIF, I i I $15,925 Sunflower Estates SSA, and $6,376 Fox Hill SSA is hereby adopted for the 2008 -2009 Fiscal Year, as presented. Passed by the City Council of the United City of Yorkville, Kendall County, Illinois this day of , A.D. 2008. CITY CLERK ROBYN SUTCLIFF JOSEPH BESCO V, ARDEN JOE PLOCHER WALLY WERDERICH GARY GOLINSKI MARTY MUNNS ROSE SPEARS V� Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this 0 7,:R day of APR t t_ 2008. J MAYOR UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET GENERAL FUND A D E E -A E -A 2006 -2007 2007 -2008 DEPT PROPOSED FY DESCRIPTION 2005 -2006 Actual Actual Budget REQUEST 08/09 BUDGET $ CHANGE % CHANGE Revenues Revenues 13,640,046 14,625,881 19,346,897 13,836,653 12,731,770 (6,615,127) - TOTAL REVENUES: 13,640,046 14,625,881 19,346,897 13,836,653 12,731,770 (6,615,127) -34% Expenditures Administration 2,368,511 2,933,160 2,407,007 3,799,683 2,316,703 (90,304) -4% Finance 2,432,663 3,645,004 4,490,323 4,851,783 4,598,949 108,626 2% Com Relations - - - 232,723 164,319 164,319 100% Engineering 395,610 470,658 553,439 593,678 549,097 (4,342) -1% Police 2,101,634 2,589,749 3,215,632 3,936,195 3,239,524 23,892 1% Com Develop 193,088 386,864 573,535 665,564 583,704 10,169 2% Streets 2,859,373 1,657,567 7,069,560 761,979 573,473 (6,496,087) -92% Health & Sanita 598,567 752,421 1,037,401 1,306,000 1,306,000 268,599 26% TOTAL EXPENDITURES: 10,949,446 12,435,423 19,346,897 16,147,605 13,331,770 (6,015,128) -31% CHANGE IN FUND BALANCE 2,690,600 2,190,458 (1) (2,310,952) (600,000) Page 1 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET GENERALFUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 I DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08/09 BUDGET RECOMM 4/11108 $ CHANGE % CHANGE GENERAL FUND REVENUES 01- 000 -40 -00 -3999 RESERVE FUND BALANCE - 5,185 125,000 - (125,000) CARRY OVER FY 06/07 - - - - - - 01- 000 -40 -00 -3991 CARRY OVER FY 05/06 - - 417,177 800,000 800,000 - (417,177) 01- 000 -40 -00 -3992 LIBRARY BOND PAYBACK - - 160,000 - - - (160,000) 01- 000 -40 -00 -3993 EMPLOY CONTRIB HEALTH REIMB - - 18,000 100,000 100,000 106,117 88,117 490% 01- 000 -40 -00 -3994 AMUSEMENT TAX - - 135,000 135,000 1 135,000 135,000 - 0% 01- 000 -40 -00 -3995 CIB / CD'S IN BANK - - 104,000 - - - (104,000) 01- 000 -40 -00 -3996 ROAD CONTRIBUTION FEE 971,098 850,661 1,200,000 - - - (1,200,000) 01- 000 -40 -00 -3997 IN -TOWN ROAD PROGRAM FUND 3,783,562 2,783,075 2,575,000 - - - (2,575,000) 01- 000 -40 -00 -3998 ROAD FUNDING - MPI 40 0 1,000,000 - - - (1,000,000) 01- 000 -40 -00 -4000 REAL ESTATE TAXES 1,387,085 1,319,395 1,810,490 1,992,991 1,992,991 1,992,991 182,501 10% 01- 000 -40 -00 -4001 TOWN ROAD /BRIDGE TAX 101,791 99,155 125,000 131,000 2 131,000 131,000 6,000 5% 01- 000 -40 -00 -4002 FOX HILL LEVY REVENUE - 18,204 18,000 - - - (18,000) 01- 000 -40 -00 -4010 PERSONAL PROPERTY TAX 13,337 20,233 10,000 20,000 3 20,000 20,000 10,000 100% 01- 000 -40 -00 -4020 STATE INCOME TAX 516,423 1,187,293 974,748 1,008,360 4 1,008,360 1,008,360 33,612 3% 01- 000 -40 -00 -4030 MUNICIPAL SALES TAX 1,958,806 2,934,185 3,120,000 2,775,000 2,775,000 2,900,000 (220,000) -7% 01- 000 -40 -00 -4032 STATE USE TAX 89,252 145,026 144,532 145,652 - 5 145,652 150,652 6,120 4% 01- 000 -40 -00 -4040 MUNICIPAL UTILITY TAX 388,592 463,480 425,000 425,000 425,000 430,000 5,000 1% 01- 000 -40 -00 -4041 UTILITY TAX - NICOR 159,111 232,616 300,000 350,000 350,000 350,000 50,000 17% 01- 000 -40 -00 -4042 UTILITY TAX - CABLE TV 83,242 138,527 129,144 150,000 150,000 167,000 37,856 29% 01- 000 -40 -00 -4043 UTILITY TAX - TELEPHONE 335,574 448,351 425,000 400,000 400,000 417,000 (8,000) -2% 01- 000 -40 -00 -4050 HOTEL TAX 18,894 19,085 20,000 20,000 20,000 20,000 - 0% 01- 000 -40 -00 -4060 TRAFFIC SIGNAL REVENUE - 0 5,000 5,000 5,000 5,000 - 0% 01- 000 -41 -00 -4100 LIQUOR LICENSE 24,366 15,691 26,000 32,900 32,900 32,900 6,900 27% 01- 000 -41 -00 -4101 OTHER LICENSES 2,700 1,518 3,000 4,200 4,200 4,200 1,200 40% 01- 000 -41 -00 -4110 BUILDING PERMITS 1,363,781 1,278,672 1,550,000 1,200,000 1,200,000 1,200,000 (350,000) -23% 01- 000 -42 -00 -4205 FILING FEES 7,023 9,860 20,000 5,000 5,000 5,000 (15,000) -75% 01- 000 -42 -00 -4206 GARBAGE SURCHARGE 208,490 248,024 540,756 1,200,000 6 1,200,000 1,200,000 659,244 122% Page 2 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET GENERALFUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 I DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08/09 BUDGET RECOMM 4/11/08 $ CHANGE % CHANGE GENERAL FUND REVENUES CONTINUED 01- 000 -42 -00 -4207 REFUSE STICKERS - - 01- 000 -42 -00 -4208 COLLECTION FEE - YBSD 31,881 32,916 35,000 60,000 60,000 60,000 25,000 71% 01- 000 -42 -00 -4210 DEVELOPMENT FEES 1,227,206 1,153,125 1,475,000 1,475,000 1,475,000 1,475,000 - 0% 01- 000 -42 -00 -4211 ENGINEERING CAPITAL FEE 52,200 38,900 60,000 - - - (60,000) - 100% 01- 000 -42 -00 -4281 BEECHER DEPOSITS - 1,010 - - - - - 01- 000 -42 -00 -4286 BEECHER RENTALS - 2,325 - 9,000 9,000 9,000 9,000 New 01- 000 -43 -00 -4310 TRAFFIC FINES 76,534 83,379 80,000 90,000 90,000 100,000 20,000 25% 01- 000 -43 -00 -4315 REIMBURSE POLICE TRAINING 11,805 0 21,000 15,000 15,000 15,000 (6,000) -29% 01- 000 -43 -00 -4320 ORDINANCE FEES 2,670 2,925 2,500 2,500 2,500 2,500 - 0% 01- 000 -44 -00 -4401 DARE DONATIONS 125 0 1,250 1,250 1,250 1,250 - 0% 01- 000 -44 -00 -4402 ROB ROY CREEK HYDRAULIC STUDY 22,700 0 10,000 - - - (10,000) - 100% 01- 000 -44 -00 -4403 MISCELLANEOUS DONATIONS - 400 - - - - - 01- 000-44 -00 -4404 HANGING BASKET DONATIONS - 3,820 - 500 500 500 500 01- 000 -44 -00 -4405 RAYMOND SEWER OUTFALL - 0 1,300,000 500,000 500,000 - (1,300,000) -100% 01- 000 -44 -00 -4407 HOLIDAY UNDER THE STARS - 0 - 12,500 12,500 12,500 12,500 01- 000 -44 -00 -4410 REIMB - FROM OTHER GOVT'S - _ _ _ _ 01- 000 -44 -00 -4411 REIMB- POLICE PROTECTION 2,477 3,308 3,300 3,300 _ 3,300 3,300 - 0% 01- 000 -44 -00 -4420 SIDEWALK CONSTRUCTION - - _ _ _ 01- 000 -44 -00 -4490 MISCELLANEOUS INCOME 11,798 16,287 15,000 5,000 5,000 15,000 - 0% 01- 000 -44-00 -4499 BAD DEBT RECOVERY _ _ 01- 000 -45 -00 -4504 TRAFFICE SIGNAL REVENUE - - _ _ _ 01- 000 -45 -00 -4505 COPS GRANT - VESTS - 5,280 3,000 3,000 3,000 3,000 - 0% 01- 000 -45 -00 -4510 COPS GRANT - _ _ _ _ 01- 000 -45 -00 -4511 POLICE - STATE TOBACCO GRANT - 1,540 1,500 1,500 1,500 1,500 - 0% 01- 000 -45 -00 -4521 ICJIA BLOCK GRANT - - _ _ _ 01- 000 -45 -00 -4525 GRANTS - BROWNFIELD COM DEV 49,675 0 - - - - 01- 000 -45 -00 -4540 BEAVER ST DEVELOP GRANT - 222,540 - - - - 01- 000 -46 -00 -4600 INVESTMENT INCOME 117,808 153,890 75,000 65,000 65,000 65,000 (10,000) -13% Page 3 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET GENERAL FUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 I DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08/09 BUDGET RECOMM 4 /11 108 $ CHANGE % CHANGE GENERAL FUND REVENUES CONTINUED DEVELOPER SIGNS REIMBURSEMENT - 5,000 5,000 5,000 5,000 New INSURANCE REIMBURSEMENTS - 2,000 2,000 2,000 2,000 New 01- 000 -49 -00 -4914 TRANSFER FROM WORKING CASH - - - - - 01- 000 -49 -00 -4915 TRANSFER FROM WATER OPS 200,000 250,000 265,000 250,000 250,000 250,000 (15,000) -6% 01- 000 -49 -00 -4920 TRANSFER FROM SEWER MAINT. 70,000 70,000 70,000 70,000 70,000 70,000 - 0% 01- 000 -49 -00 -4925 TRANSFER FROM SAN. SEWER IMP 150,000 150,000 150,000 150,000 150,000 150,000 - 0% 01- 000 -49 -00 -4930 TRANSFER FROM WATER IMPROVE. 200,000 200,000 200,000 200,000 200,000 200,000 - 0% 01- 000 -49 -00 -4935 TRANSFER FROM LAND CASH - 16,000 16,000 16,000 16,000 16,000 - 0% 01- 000 -49 -00 -4940 TRANSFER FROM MUNICIPAL BLDG 0 182,500 - - - (182,500) -100% TOTAL REVENUES: GENERAL 13,640,046 14,625,881 19,346,897 13,836,653 13,836,653 12,731,770 (6,615,127) -34% Page 4 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET GENERALFUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 I DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget + REQUEST 08109 BUDGET RECOMM 4/11108 $ CHANGE % CHANGE GENERAL FUND REVENUES - COMMENTS FROM THE DEPT REQUEST COLUMN 1 5% of 1,500 daily passes per day for 100 days per year @$20 per pass 2 This is a property tax that is County -Wide / Township Wide 3 This is based off of 2.5% of income from the State 4 $90 * 11,204 (Population) 5 $13 * 11,204 (Population) 6 Senior Discount will result in $100,000 loss minimum Page 5 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET GENERALFUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08/09 BUDGET RECOMM 4/11108 $ CHANGE % CHANGE ADMINISTRATION EXPENSES 01- 110 -50 -00 -5100 SALARIES - MAYOR 3,775 7,394 11,310 11,310 11,310 11,310 - 0% 01- 110 -50 -00 -5101 SALARIES - CITY CLERK 1,800 4,500 6,410 8,600 8,600 8,600 2,190 34% 01- 110 -50 -00 -5102 SALARIES - CITY TREASURER 1,800 3,705 6,410 6,410 6,410 6,410 - 0% 01- 110 -50 -00 -5103 SALARIES - ALDERMAN 15,450 30,970 40,880 30,970 30,970 30,970 (9,910) -24% 01- 110 -50 -00 -5104 SALARIES - LIQUOR COMMISSIONER 500 1,281 1,000 1,000 1,000 1,000 - 0% 01- 110 -50 -00 -5105 SALARIES - CITY ATTORNEY 11,060 11,503 9,500 - - - (9,500) -100% 01- 110 -50 -00 -5106 SALARIES - ADMINISTRATIVE 568,870 715,063 446,025 465,985 1 460,985 460,985 14,960 3% 01- 110 -50 -00 -5136 SALARIES - PART TIME 49,393 28,909 22,500 15,000 2 5,000 5,000 (17,500) -78% 01- 110 -50 -00 -5137 SALARIES - OVERTIME 375 3,691 750 750 500 500 (250) -33% 01- 110 -61 -00 -5300 LEGAL SERVICES 77,265 188,534 85,000 240,000 120,000 120,000 35,000 41% LEGISLATIVE ATTORNEY - 0 - - - 10,000 10,000 New 01- 110 -61 -00 -5311 CODIFICATION 5,614 1,822 5,000 3,500 3,500 3,500 (1,500) -30% 01- 110 -61 -00 -5314 BUILDING INSPECTIONS 1,142,685 995,966 1,125,000 950,000 950,000 950,000 (175,000) -16% 01- 110 -61 -00 -5322 BONDING - - _ _ _ _ 01- 110 -62 -00 -5401 CONTRACTUAL SERVICES 41,995 47,792 27,500 50,000 20,000 20,000 (7,500) -27% 01- 110 -62 -00 -5403 SPECIAL CENSUS 67,377 (19) - - - - 01- 110 -62 -00 -5404 CABLE CONSORTIUM FEE 41,116 39,923 35,000 40,000 _ 35,000 35,000 - 0% 01- 110 -62 -00 -5406 OFFICE CLEANING 6,600 7,737 7,500 7,500 7,500 7,500 - 0% 01- 110 -62 -00 -5410 MAINTENANCE - OFFICE EQUIPMENT 190 129 500 250 250 100 (400) -80% 01- 110 -62 -00 -5421 WEARING APPAREL 897 28 - 540 540 540 540 New 01- 110 -62 -00 -5427 FACADE PROGRAM 20,000 - 15,000 20,000 15,000 - (15,000) -100% 01- 110 -62 -00 -5436 TELEPHONE 14,174 18,758 15,000 19,000 16,000 16,000 1,000 7% 01- 110 -62 -00 -5438 CELLULAR TELEPHONE 1,962 2,654 1,920 2,500 2,500 2,500 580 30% 01- 110 -62 -00 -5439 TELEPHONE SYSTEMS MAINTENANCE 2,836 3,648 7,500 5,000 5,000 3,500 (4,000) -53% 01- 110 -62 -00 -5440 BEAVER ST GRANT EXPENSE - - - _ _ - 01- 110 -64 -00 -5600 DUES 3,758 5,197 5,510 12,000 11,000 9,000 3,490 63% 01- 110 -64 -00 -5601 ILLINOIS MUNICIPAL LEAGUE DUES 781 900 800 918 918 918 118 15% 01- 110 -64 -00 -5603 SUBSCRIPTIONS /BOOKS 315 733 500 250 250 100 (400) -80% Page 6 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET GENERAL FUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 I DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08109 BUDGET RECOMM 4111108 $ CHANGE % CHANGE ADMINISTRATION EXPENSES CONTINUED 01- 110 -64 -00 -5604 TRAINING & CONFERENCES 7,325 19,441 19,500 10,000 3 5,875 B 5,875 (13,625) -70% 01- 110 -64 -00 -5605 TRAVEL / MEALS / LODGING 14,268 2,931 7,500 21,000 4 17,380 B 17,380 9,880 132% TUITION REIMBURSEMENT 6,000 5 6,000 6,000 6,000 New 01- 110 -64 -00 -5606 PROMOTIONAL/MARKETING EXP'S - 2,941 12,000 - - - (12,000) -100% 01- 110 -64 -00 -5607 PUBLIC RELATIONS 27,109 8,570 - - 6 500 100 100 01- 110 -64 -00 -5608 HRC SPONSORSHIPS 300 620 1,500 2,500 1,500 1,500 - 0% 01- 110 -64 -00 -5609 YMCA PARTNERSHIP - - 1,500 - - - (1,500) -100% 01- 110 -65 -00 -5800 CONTINGENCIES 46,460 561,045 146,500 150,000 50,000 20,000 (126,500) -86% 01- 110 -65 -00 -5801 FUND BALANCE RESERVE - - - - - - - 01- 110 -65 -00 -5802 OFFICE SUPPLIES 15,995 15,616 8,500 8,000 7,000 7,000 (1,500) -18% 01- 110 -65 -00 -5804 OPERATING SUPPLIES 7,416 14,435 5,000 6,250 5,000 5,000 - 0% 01- 110 -65 -00 -5808 POSTAGE & SHIPPING 9,761 16,257 21,925 18,000 18,000 17,000 (4,925) -22% 01- 110 -65 -00 -5809 PRINTING & COPYING 14,952 20,525 11,000 11,000 9,000 9,000 (2,000) -18% 01- 110 -65 -00 -5810 PUBLISHING & ADVERTISING 3,866 3,866 5,000 4,000 3,500 2,000 (3,000) -60% 01- 110 -72 -00 -6500 IMRF PARTICIPANTS 45,400 55,136 39,756 42,303 41,173 A 41,173 1,417 4% 01- 110 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 53,429 62,202 39,965 43,224 41,339 A 41,339 1,373 3% 01- 110 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE - 0 2,000 11,000 _ 7 - - (2,000) -100% 01- 110 -75 -00 -7003 OFFICE EQUIPMENT 1,591 2,876 2,500 3,000 1,000 500 (2,000) -80% 01- 110 -78 -00 -9002 NICOR GAS 40,052 25,881 30,000 30,000 30,000 30,000 - 0% 01- 110 -78 -00 -9004 MISCELLANEOUS - - 250 - - - (250) -100% 01- 110 -78 -00 -9005 MERIT /COLA - - 16,333 27,959 18,439 A 18,439 2,106 13% 01- 110 -78 -00 -9007 APPRECIATION DINNER - - 10,000 2,000 2,000 2,000 (8,000) -80% 01- 110 -78 -00 -9008 VOLUNTEER APPRECIATION DAY - - 2,000 - - - (2,000) -100% 01- 110 -78 -00 -9009 WEBSITE - - 2,500 - - - (2,500) -100% 01- 110 -78 -00 -9010 COMMUNITY EVENTS - - 45,200 - - - (45,200) -100% 01- 110 -78 -00 -9011 TENNIS CRT REFURBISHING - 40,000 - - - (40,000) -100% 01- 110 -78 -00 -9012 SALARY SURVEY - 60,063 - - - (60,063) -100% Page 7 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET GENERALFUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 I DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08/09 BUDGET RECOMM 4111108 $ CHANGE % CHANGE ADMINISTRATION EXPENSES CONTINUED TRANSFER TO CW CAP FOR LAND - 100,000 100,000 100,000 100,000 New 01- 110 -99 -00 -9923 TRANSFER TO LIBRARY - - - - - - 01- 110 -99 -00 -9925 TRANSFER TO SAN SEWER - - - - - - 01- 110 -99 -00 -9940 TRANSFER TO PARK & RECREATION - - - - - - 01- 110 -99 -00 -9941 TRANSFER TO PARK/REC CAPITAL - - - - - - 01- 110 -99 -00 -9942 TRANSFER TO POLICE CAPITAL - - - - - - 01- 110 -99 -00 -9945 TRANSFER TO MUNICIPAL BLDG - - - - - - 01- 110 -99 -00 -9965 TRANSFER TO DEBT SERVICE - - - - - - TRANSFER TO CITY WIDE CAPITAL - 1,376,000 465,000 275,000 275,000 New 01- 110 -78 -00 -9013 HOLIDAY UNDER THE STARS - - - - - - COUNCIL CHAMBER RENOVATIONS - 20,000 - - - New KENDALL COUNTY PARATRANSIT - 13,964 13,964 13,964 13,964 New CITY HALL OFFICE RENOVATIONS - 2,000 - - New TOTAL EXPENSES: ADMINISTRATION 2,368,511 2,933,160 2,407,007 3,799,683 2,548,903 2,316,703 (90,304) -4% Page 8 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08109 BUDGET GENERALFUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 I DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08109 BUDGET RECOMM 4111108 $ CHANGE % CHANGE ADMINISTRATION - COMMENTS FROM THE DEPT REQUEST COLUMN 1 Decrease tied to maternity leave for employee 2 For part-time employee while other employee is on maternity leave. Also, Admin Intern removed from budget. 3 IML $1,750; ICMA $2,000; ILCMA $200; IAMMA $390; Metro Managers $280; Admin Employees & Elected Officials $5,000 4 IML $16,940; ICMA $3,280; ILCMA $120; IAMMA $40; Metro Managers $550 5 Tuition reimbursement breakdown on separate spreadsheet. 6 Condolences, Openings 7 Computer replacement for Admin Secretary only. (This has been eliminated) ADMINISTRATION COMMITTEE RECOMMENDATIONS: A Merit was reduced to 4 %. Social Security and IMRF reflect that change. B The Treasurer will not be attending the IML conference this year. The reduction is reflected. Page 9 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET GENERAL FUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08109 BUDGET RECOMM 4/11108 $ CHANGE % CHANGE FINANCE EXPENSES 01- 120 -50 -00 -5106 SALARIES - ADMINISTRATIVE - - 293,883 329,120 329,120 329,120 35,237 12% 01- 120 -50 -00 -5136 SALARIES - PART TIME - - 5,000 5,000 5,000 - (5,000) -100% 01- 120 -50 -00 -5137 SALARIES - OVERTIME - - 750 750 750 750 - 0% 01- 120 -50 -00 -5202 BENEFITS- UNEMPLOY. COMP. TAX 15,233 20,308 24,000 28,800 1 28,800 28,800 4,800 20% 01- 120 -50 -00 -5203 BENEFITS - HEALTH INSURANCE 771,967 818,559 850,000 1,064,000 2 1,064,000 980,800 130,800 15% 01- 120 -50 -00 -5204 BENEFITS - GROUP LIFE INSURANCE 19,864 24,355 75,000 28,000 3 28,000 28,240 (46,760) -62% 01- 120 -50 -00 -5205 BENEFITS - DENTAL/VISION ASST 70,770 81,550 27,218 95,000 3 85,000 96,495 69,277 255% 01- 120 -61 -00 -5304 AUDIT FEES & EXPENSES 25,500 49,083 32,000 40,325 4 40,325 40,325 8,325 26% 01- 120 -61 -00 -5305 ACCOUNTING ASSISTANCE - 2,785 - - - - 01- 120 -61 -00 -5307 ACCOUNTING SYSTEM REVIEW - - 01- 120 -61 -00 -5308 GASB 34 23,806 - - - - - 01- 120 -61 -00 -5310 EMPLOYEE ASSISTANCE 2,867 3,068 4,500 4,500 4,500 4,500 - 0% 01- 120 -62 -00 -5400 INSURANCE - LIABILITY & PROPERTY 124,161 173,519 163,422 210,000 210,000 210,000 46,578 29% 01- 120 -62 -00 -5401 CONTRACTUAL SERVICES - - - 15,000 5 15,000 15,000 15,000 New 01- 120 -62 -00 -5410 MAINTENANCE - OFFICE EQUIPMENT - - 500 500 500 500 - 0% 01- 120 -62 -00 -5411 MAINTENANCE - COMPUTERS 1,808 1,364 2,000 1,000 - 1,000 1,000 (1,000) -50% 01- 120 -62 -00 -5412 MAINTENANCE - PHOTOCOPIERS 19,478 22,530 22,750 28,000 28,000 28,000 5,250 23% 01- 120 -62 -00 -5437 ACCTG SYSTEM SERVICE FEE 8,090 9,652 9,200 15,000 15,000 15,000 5,800 63% 01- 120 -62 -00 -5438 CELLULAR TELEPHONE - - 720 950 950 950 230 32% 01- 120 -64 -00 -5603 SUBSCRIPTIONS /BOOKS - - 100 250 250 250 150 150% 01- 120 -64 -00 -5604 TRAINING & CONFERENCES - - 3,125 4,600 6 2,000 2,000 (1,125) -36% 01- 120 -64 -00 -5605 TRAVEL / MEALS / LODGING - - 4,000 4,000 7 3,000 3,000 (1,000) -25% 01- 120 -65 -00 -5802 OFFICE SUPPLIES - - 8,500 6,000 5,000 4,000 (4,500) -53% 01- 120 -65 -00 -5804 OPERATING SUPPLIES - - 5,000 8,000 6,500 5,500 500 10% 01- 120 -65 -00 -5808 POSTAGE & SHIPPING 2,500 2,500 2,500 2,500 New 01- 120 -65 -00 -5844 MARKETING - HOTEL TAX 18,469 19,332 20,000 20,000 20,000 20,000 - 0% Page 10 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET GENERALFUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 I DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08/09 BUDGET RECOMM 4/11108 $ CHANGE % CHANGE FINANCE EXPENSES CONTINUED 01- 120 -72 -00 -6500 IMRF PARTICIPANTS - - 28,642 27,549 27,185 A 27,185 (1,458) -5% 01- 120 -72 -00 -6501 SOCIAL SECURITY & MEDICARE - - 28,793 28,071 26,428 A 26,048 (2,745) -10% 01- 120 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 15,709 28,144 30,000 34,000 20,000 20,000 (10,000) -33% 01- 120 -75 -00 -7003 OFFICE EQUIPMENT - - 2,500 2,500 1,000 1,000 (1,500) -60% 01- 120 -78 -00 -9001 CITY TAX REBATE 70 57 750 750 750 750 - 0% 01- 120 -78 -00 -9003 SALES TAX REBATE 278,920 600,253 725,000 630,000 630,000 620,000 (105,000) -14% 01- 120 -78 -00 -9005 MERIT /COLA - - 12,444 19,747 13,165 A 13,165 721 6% 01- 120 -78 -00 -9012 SALARY SURVEY - - 67,051 - - - (67,051) -100% 01- 120 -78 -00 -9013 AMUSEMENT TAX REBATE - - 74,250 74,250 8 74,250 74,250 - 0% 01- 120 -99 -00 -9923 TRANSFER TO THE LIBRARY 28,000 35,430 - 01- 120 -99 -00 -9925 TRANSFER TO SAN SEWER 150,000 150,000 150,000 150,000 150,000 150,000 - 0% 01- 120 -99 -00 -9930 TRANSFER TO WATER IMPROVEMENT - - 200,000 200,000 200,000 200,000 - 0% 01- 120 -99 -00 -9935 TRANSFER TO LAND CASH - - 48,245 - - - (48,245) -100% 01- 120 -99 -00 -9940 TRANSFER TO PARK & RECREATION 755,908 1,015,107 1,161,778 1,348,497 1,243,233 1,224,698 62,920 5% 01- 120 -99 -00 -9941 TRANSFER TO PARK & REC CAP - 150,000 - 01- 120 -99 -00 -9942 TRANSFER TO POLICE CAPITAL - 82,402 - 01- 120 -99 -00 -9945 TRANSFER TO MUN BLDG 102,043 64,647 125,000 - _ - - (125,000) -100% 01- 120 -99 -00 -9965 TRANSFER TO DEBT SERVICE - 292,859 284,202 425,124 425,124 425,124 140,922 50% TOTAL EXPENSES: FINANCE 2,432,663 3,645,004 4,490,323 4,851,783 4,706,330 4,598,949 108,626 2% 1,302,708 Page 11 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET GENERALFUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 I DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08109 BUDGET RECOMM 4111108 $ CHANGE % CHANGE FINANCE - COMMENTS FROM THE DEPT REQUEST COLUMN 1 Increase is projected to be 20% over last year 2 $950,000 is the projected expenditure for Fiscal Year 2008 and then an additional 6% increase 3 There is a net increase of $10,000 between these two funds. Budgeting error in the previous fiscal year. 4 There are 3 TIF's that need an independent report 5 Arbitrage Calculations need to be completed on the bonds sold in 2003 6 IPERLA $800; HR $450; GASB Updates $900 7 IML $525; IGFOA $950; IPERLA $1,200; Gasb $325 8 55% of total amusement tax rebate back to the water park ADMINISTRATION COMMITTEE RECOMMENDATIONS: A Merit was reduced to 4 %. Social Security and IMRF reflect that change. Page 12 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08109 BUDGET GENERALFUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08109 BUDGET RECOMM 4111108 $ CHANGE % CHANGE COMMUNITY RELATIONS 01- 130 -50 -00 -5106 SALARIES- EMPLOYEES - - - 104,662 59,662 59,662 59,662 0% 01- 130 -50 -00 -5136 PART TIME SALARIES - - - 9,880 1 9,880 9,880 9,880 0% 01- 130 -62 -00 -5401 CONTRACTUAL SERVICES - - - 4,000 4,000 4,000 4,000 0% 01- 130 -64 -00 -5607 PUBLIC RELATIONS - - - 10,000 2 8,000 8,000 8,000 0% 01- 130 -65 -00 -5810 PUBLISHING & ADVERTISING - - - 20,000 3 15,000 15,000 15,000 0% 01- 130 - 64-00 -5603 SUBSCRIPTIONS / BOOKS - - - 400 400 400 400 0% 01- 130 -64 -00 -5604 TRAINING & CONFERENCES - - - 2,050 4 1,500 1,500 1,500 0% 01- 130 -64 -00 -5605 TRAVEL / MEALS / LODGING - - - 1,000 1,000 1,000 1,000 0% 01- 130 -65 -00 -5802 OFFICE SUPPLIES - - - 750 750 750 750 0% 01- 130 -65 -00 -5808 POSTAGE & SHIPPING - - - 7,520 7,520 7,520 7,520 0% 01- 130 -65 -00 -5809 PRINTING & COPYING - - - 14,000 14,000 14,000 14,000 0% 01- 130 -72 -00 -6500 IMRF PARTICIPANTS - - - 8,487 4,747 A 4,747 4,747 0% 01- 130 -72 -00 -6501 SOCIAL SECURITY & MEDICARE - - - 9,195 5,474 A 5,474 5,474 0% 01- 130 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE - - - 4,500 - - - 0% 01- 130 -78 -00 -9005 MERIT /COLA - - - 6,280 2,386 A 2,386 2,386 0% 01- 130 -78 -00 -9010 COMMUNITY EVENTS - - - 5,000 5 5,000 5,000 5,000 0% 01- 130 -78 -00 -9013 HOLIDAY UNDER THE STARS - - - 25,000 25,000 25,000 25,000 0% TOTAL EXPENSES: COMMUNITY RELATIONS - - - 232,723 164,319 164,319 164,319 New Page 13 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET GENERALFUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 I DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08109 BUDGET RECOMM 4111108 $ CHANGE % CHANGE COMMUNITY RELATIONS - COMMENTS FROM THE DEPT REQUEST COLUMN 1 19 hrs per week / $10 per hour 2 Magnets $1,500 / New Resident folders $1,700 / event brochures $1,700 / newsletters $4,000 / Misc $1,100 3 Newsletters to residents $16,000 / Promenade of the Arts / Theatre in the park / Art in City Hall / City of Yorkville Fact Sheet 4 Dealing with the Angry Public conference / Certificate from the Civic Leadership from Northern 3 classes @ $99 each session 5 Theatre in the Park $1,000 / Community Appreciation day $2,000 ADMINISTRATION COMMITTEE RECOMMENDATIONS: A Merit was reduced to 4 %. Social Security and IMRF reflect that change. Page 14 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET GENERALFUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 I DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08109 BUDGET RECOMM 4/11108 $ CHANGE % CHANGE ENGINEERING EXPENSES 01- 150 -50 -00 -5107 SALARIES- EMPLOYEES 244,762 271,075 318,914 406,935 406,935 406,935 88,021 28% 01- 150 -50 -00 -5137 SALARIES- OVERTIME - 800 1,000 1,000 1,000 1,000 - 0% 01- 150 -62 -00 -5401 CONTRACTUAL SERVICES 88,889 92,475 47,500 60,000 30,000 30,000 (17,500) -37% 01- 150 -62 -00 -5402 GIS SYSTEM 5,000 294 - - - - - 01- 150 -62 -00 -5403 FEES 1,000 1,000 2,000 2,000 1,000 1,000 (1,000) -50% 01- 150 -62 -00 -5409 MAINTENANCE- VEHICLES 866 1,482 2,000 2,000 2,000 2,000 - 0% 01- 150 -62 -00 -5410 MAINTENANCE- OFFICE EQUIP 276 164 1,000 1,000 1,000 1,000 - 0% 01- 150 -62 -00 -5411 MAINTENANCE - COMPUTERS 1,587 487 2,000 2,000 2,000 2,000 - 0% 01- 150 -62 -00 -5421 WEARING APPAREL 254 269 1,400 1,400 1,400 1,400 - 0% 01- 150 -62 -00 -5438 CELLULAR TELEPHONE 2,426 2,537 2,520 4,100 1 4,100 4,100 1,580 63% 01- 150 - 64-00 -5600 DUES 293 339 600 600 600 600 - 0% 01- 150 -64 -00 -5604 TRAINING & CONFERENCES 227 552 4,000 4,000 2,000 2,000 (2,000) -50% 01- 150 -64 -00 -5605 TRAVEL EXPENSE 1,231 496 1,000 1,000 1,000 1,000 - 0% 01- 150 -64 -00 -5608 TUITION REIMBURSEMENT - - 2580 2,000 2,000 2,000 (580) -22% 01- 150 - 64-00 -5616 BOOKS & PUBLICATIONS 163 - 200 200 200 200 - 0% 01- 150 -65 -00 -5801 ENGINEERING SUPPLIES 2,520 2,205 3,000 3,000 2,500 2,500 (500) -17% 01- 150 -65 -00 -5802 OFFICE SUPPLIES 2,464 1,563 2,500 2,500 2,000 2,000 (500) -20% 01- 150 -65 -00 -5809 PRINTING & COPYING 1,667 1,853 2,250 2,250 2,250 2,250 - 0% 01- 150 -65 -00 -5814 STORMWTR SOFTWARE TRAINING - - - - - - - 01- 150 -65 -00 -5815 ROB ROY HYDRALIC STUDY - - - - - - - ISWS GROUNDWTR STUDY - - - 1,000 1,000 1,000 1,000 New 01- 150 -65 -00 -5820 ENGINEERING CAPITAL RESERVE - 39,691 40,000 - - - (40,000) -100% 01- 150 -72 -00 -6500 IMRF PARTICIPANTS 19,812 21,193 27,393 33,075 32,452 A 32,452 5,059 18% 01- 150 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 18,344 20,403 27,537 32,902 32,283 A 32,283 4,746 17% 01- 150 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 3,759 9,224 20,500 5,300 2 4,100 4,100 (16,400) -80% 01- 150 -75 -00 -7003 OFFICE EQUIPMENT 70 2,556 2,500 1,000 1,000 1,000 (1,500) -60% 01- 150 -78 -00 -9005 MERIT /COLA - - 13,843 24,416 16,277 A 16,277 2,434 18% 01- 150 -78 -00 -9012 SALARY SURVEY - - 27,202 - - - (27,202) -100% TOTAL EXPENSES: ENGINEERING 395,610 470 658 553,439 593,678 549,097 549,097 (4,342) -1% Page 15 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET GENERALFUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 I DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08/09 BUDGET RECOMM 4111108 $ CHANGE % CHANGE ENGINEERING - COMMENTS FROM THE DEPT REQUEST COLUMN 1 $40 per month per employee, plus $740 for 3 new camera phones 2 Software subscriptions ($3,900) new monitor $200 ADMINISTRATION COMMITTEE RECOMMENDATIONS: A Merit was reduced to 4 %. Social Security and IMRF reflect that change. Page 16 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET GENERALFUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 I DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08/09 BUDGET RECOMM 4/11108 $ CHANGE % CHANGE PUBLIC SAFETY /POLICE DEPT. EXPENSES 01- 210 -50 -00 -5107 SALARIES - EMPLOYEES 612,211 859,924 1,254,261 1,586,326 1 1,470,876 A 1,181,811 (72,450) -6% 01- 210 -50 -00 -5131 SALARIES - LIEUT. /SERGEANTS /CHIEF 541,474 606,857 555,341 760,227 2 705,227 705,227 149,886 27% 01- 210 -50 -00 -5133 SALARIES - COPS 100,534 116,455 - - - - - 01- 210 -50 -00 -5134 SALARIES - CROSSING GUARD 16,406 18,824 22,425 26,350 26,350 26,350 3,925 18% 01- 210 -50 -00 -5135 SALARIES - POLICE CLERKS 102,684 128,326 111,269 238,535 3 202,535 202,535 91,266 82% 01- 210 -50 -00 -5136 SALARIES - PART TIME 37,588 21,895 36,750 40,000 40,000 30,000 (6,750) -18% 01- 210 -50 -00 -5137 SALARIES - OVERTIME 43,671 47,584 80,000 90,000 85,000 70,000 (10,000) -13% 01- 210 -50 -00 -5200 CADET PROGRAM 9,814 18,324 33,000 36,000 36,000 36,000 3,000 9% 01- 210 -61 -00 -5300 LEGAL SERVICES 17,726 33,874 20,000 15,000 15,000 10,000 (10,000) -50% ARCHITECT FEES - - 20,000 - - - 01- 210 -62 -00 -5408 MAINTENANCE - EQUIPMENT 8,000 8,600 11,000 20,000 15,000 15,000 4,000 36% 01- 210 -62 -00 -5409 MAINTENANCE - VEHICLES 27,805 35,405 35,000 40,000 40,000 40,000 5,000 14% 01- 210 -62 -00 -5410 - MAINT- OFFICE EQUIPMENT 2,500 2,625 4,500 5,000 5,000 5,000 500 11% 01- 210 -62 -00 -5411 MAINTENANCE - COMPUTERS 2,100 6,000 10,000 15,000 4 10,000 10,000 - 0% 01- 210 -62 -00 -5412 MAINTENANCE - K9 - - 2,000 2,000 2,000 2,000 - 0% 01- 210 -62 -00 -5414 WEATHER WARNING SIREN MAINT 3,310 6,520 6,600 6,930 6,930 6,930 330 5% 01- 210 -62 -00 -5421 WEARING APPAREL 24,773 29,656 30,000 42,000 46,000 33,000 3,000 10% 01- 210 -62 -00 -5422 COPS GRANT IV - VESTS 2,634 3,471 6,000 8,000 5 6,600 8,000 2,000 33% 01- 210 -62 -00 -5423 CLASY GRANT - 1,000 - - - - - 01- 210 -62 -00 -5424 ICJIA - JUVENILE - - - 01- 120 -62 -00 -5427 ICJIA BLOCK GRANT - - 01- 210 -62 -00 -5429 PSYCHOLOGICAL TESTING 1,470 3,250 3,500 4,500 3,400 B 2,000 (1,500) -43% 01- 210 -62 -00 -5430 HEALTH SERVICES 2,357 7,527 3,500 8,000 7,956 B 6,000 2,500 71% 01- 210 -62 -00 -5431 LABORATORY FEES - - - - 2,000 B 2,000 2,000 KENDALL CO. JUVENILE PROBATION - - 3,000 3,000 3,000 3,000 New 01- 210 -62 -00 -5436 TELEPHONE 16,908 17,245 23,000 26,000 26,000 23,000 - 0% Page 17 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET GENERALFUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 I DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08109 BUDGET RECOMM 4111108 $ CHANGE % CHANGE PUBLIC SAFETY EXPENSES CONTINUED 01- 210 -62 -00 -5438 CELLULAR TELEPHONE 11,993 14,524 17,500 19,420 19,420 19,420 1,920 11% 01- 210 -62 -00 -5440 PAGERS - - 01- 210 -62 -00 -5441 MTD- ALERTS FEE 4,620 5,038 10,562 15,086 15,086 12,000 1,438 14% 01- 210 -64 -00 -5600 DUES 1,953 2,500 4,000 4,500 4,500 4,000 - 0% 01- 210 -64 -00 -5603 SUBSCRIPTIONS 266 346 500 600 600 600 100 20% 01- 210 -64 -00 -5604 TRAINING & CONFERENCE 19,214 16,532 33,025 39,750 33,025 33,025 - 0% 01- 210 -64 -00 -5605 TRAVEL EXPENSES 10,367 8,735 12,075 15,500 12,075 12,075 - 0% 01- 210 - 64-00 -5606 COMMUNITY RELATIONS 5,500 11,685 10,000 11,000 10,000 10,000 - 0% 01- 210 -64 -00 -5607 POLICE COMMISSION 7,600 8,333 22,050 30,000 30,000 25,000 2,950 13% 01- 210 -64 -00 -5608 TUITION REIMBURSEMENT 12,522 13,328 14,000 14,700 14,700 10,000 (4,000) -29% 01- 210 -64 -00 -5609 POLICE RECRUIT ACADEMY - 19,340 20,000 13,000 7,000 - (20,000) - 100% 01- 210 -64 -00 -5610 GUN RANGE FEES 625 400 1,000 1,000 1,000 1,000 - 0% 01- 210 -64 -00 -5611 SPECIAL RESPONSE TEAM FEE 2,000 3,490 4,025 4,250 4,250 4,000 (25) -1% 01- 210 -64 -00 -5612 NEIGHBORHOOD WATCH - - 1,200 1,500 1,500 1,500 300 25% 01- 210 -64 -00 -5613 CITIZENS POLICE ACADEMY - - 2,420 2,500 2,500 2,500 80 3% 01- 210 -64 -00 -5614 CHAPLAIN PROGRAM - - 1,400 1,400 1,400 400 (1,000) -71% 01- 210 -64 -00 -5615 COMPLIANCE CHECKS - - 500 500 500 500 - 0% 01- 210 -64 -00 -5616 DARE PROGRAM - - 5,000 5,250 5,250 5,250 250 5% 01- 210 -64 -00 -5617 HUMAN RESOURCE COMMITTEE - - - - - - - 01- 210 -65 -00 -5800 CONTINGENCIES - - - - - _ 01- 210 -65 -00 -5802 OFFICE SUPPLIES 6,499 7,751 10,000 10,500 9,000 9,000 (1,000) -10% 01- 210 -65 -00 -5803 EVIDENCE TECH SUPPLIES - - 5,000 5,250 5,250 2,500 (2,500) -50% 01- 210 -65 -00 -5804 OPERATING SUPPLIES 16,000 20,027 19,320 20,500 19,500 19,500 180 1% 01- 210 -65 -00 -5808 POSTAGE & SHIPPING 2,662 3,635 5,000 5,250 5,250 5,250 250 5% 01- 210 -65 -00 -5809 PRINTING & COPYING 4,500 5,484 6,000 7,500 7,500 7,500 1,500 25% 01- 210 -65 -00 -5810 PUBLISHING & ADVERTISING 1,000 521 2,000 2,000 2,000 2,000 - 0% 01- 210 -65 -00 -5812 GASOLINE 53,503 60,618 75,000 92,000 80,000 80,000 5,000 7% 01- 210 -65 -00 -5813 AMMUNITION 5,000 5,439 6,000 6,300 6,300 6,300 300 5% Page 18 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET GENERAL FUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 I DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget , REQUEST 08/09 BUDGET RECOMM 4/11/08 $ CHANGE % CHANGE PUBLIC SAFETY EXPENSES CONTINUED 01- 210 -72 -00 -6500 IMRF PARTICIPANTS 8,331 10,344 11,800 22,832 18,272 C 18,272 6,472 55% 01- 210 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 112,468 139,421 140,750 211,179 198,035 C 174,135 33,385 24% 01- 210 -72 -00 -6502 POLICE PENSION 231,124 248,988 275,000 300,000 300,000 300,000 25,000 9% 01- 210 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 8,499 8,716 7,500 9,000 10,000 10,000 2,500 33% NEW WORLD LIVE SCAN - - 8,634 6 8,634 8,634 8,634 New 01- 210 -78 -00 -9004 BIKE PATROL 1,423 1,192 2,500 2,500 2,500 1,000 (1,500) -60% 01- 210 -78 -00 -9005 MERIT /COLA - - 27,318 59,926 36,310 C 36,310 8,992 33% 01- 210 -78 -00 -9012 SALARY SURVEY - - 215,041 - - - (215,041) -100% 01- 210 -99 -00 -9910 TRANSFER TO POLICE CAPITAL - - - - - - - TOTAL EXPENSES: PUBLIC SAFETY /POLICE DEPT. 2,101,634 2,589,749 3,215,632 3,936,195 3,626,231 3,239,524 23,892 1% Page 19 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET GENERALFUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 I DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08/09 BUDGET RECOMM 4111108 $ CHANGE % CHANGE POLICE / PUBLIC SAFETY - COMMENTS FROM THE DEPT REQUEST COLUMN 1 4 New Officers ($46,000 each) (These were eliminated) 2 Promotions: 1 Deputy Chief / 1 LT / 1 Srgt / Add 1 Srgt for the Traffic Unit ($55,000 total) (These were eliminated) 3 1 New Records Clerk ($36,000) (This was eliminated) 4 1 New Lap Top / Docking Station for Squad ($4,560) & Refurbish 2 Lap Tops for Squads ($800 each) 5 These are all replacement vests 6 $6,639 New World / $ 1,995 Live Scan ADMINISTRATION COMMITTEE RECOMMENDATIONS: A 2 New Police Officers were added at 9 months salary $68,550. (This was eliminated) B These were increased as a correlation to the new hires recommended. (These were eliminated) C Merit was reduced to 4 %. Social Security and IMRF reflect that change. Page 20 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08109 BUDGET GENERALFUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 I DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08109 BUDGET RECOMM 4/11108 $ CHANGE % CHANGE COMMUNITY DEVELOPMENT EXPENSES 01- 220 -50 -00 -5107 EMPLOYEE SALARIES 7,665 121,163 302,853 340,955 340,955 340,955 38,102 13% 01- 220 -61 -00 -5300 LEGAL SERVICES 50,291 28,805 20,000 20,000 20,000 20,000 - 0% 01- 220 -62 -00 -5401 CONTRACTUAL SERVICES 34,669 55,415 37,500 75,000 30,000 30,000 (7,500) -20% 01- 220 -62 -00 -5430 PLANNING CONSULTANT 8,028 37,958 50,000 75,000 50,000 50,000 - 0% 01- 220 -62 -00 -5432 ECONOMIC DEVELOPMENT 45,000 45,000 45,000 45,000 45,000 45,000 - 0% 01- 220 -62 -00 -5438 CELLULAR TELEPHONE 307 1,059 1,000 2,000 1,500 1,500 500 50% 01- 220 -64 -00 -5600 DUES 400 1,753 1,500 1,500 1,500 1,500 - 0% 01- 220 -64 -00 -5604 TRAINING & CONFERENCES 2,284 5,175 7,500 7,500 5,000 5,000 (2,500) -33% 01- 220 -64 -00 -5605 TRAVEL EXPENSE - 2,479 2,500 2,500 2,000 2,000 (500) -20% 01- 220 -64 -00 -5616 BOOKS & PUBLICATIONS 423 - - - _ _ _ 01- 220 -65 -00 -5804 OPERATING SUPPLIES 1,676 5,761 7,500 8,000 8,000 8,000 500 7% 01- 220 -65 -00 -5809 PRINTING & COPYING 558 521 2,000 1,500 1,500 1,500 (500) -25% 01- 220 -65 -00 -5810 PUBLISHING &ADVERTISING 4,660 3,040 8,000 1,500 1,500 1,500 (6,500) -81% 01- 220 -65 -00 -5814 BOOKS & MAPS 1,079 2,469 4,000 2,000 2,000 2,000 (2,000) -50% 01- 220 -72 -00 -6500 IMRF PARTICIPANTS - 9,345 24,563 27,648 _ 27,126 A 27,126 2,563 10% 01- 220 -72 -00 -6501 SOCIAL SECURITY & MEDICARE - 9,221 24,693 27,503 26,985 A 26,985 2,292 9% 01- 220 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 8,966 47,630 10,000 5,000 6,000 6,000 (4,000) -40% 01- 220 -75 -00 -7003 OFFICE EQUIPMENT 27,081 10,070 5,000 2,500 1,000 1,000 (4,000) -80% 01- 220 -75 -00 -7004 IL TOMORROW GRANT MATCH - _ _ _ - 01- 220 -78 -00 -9005 MERIT /COLA - - 11,645 20,457 13,638 A 13,638 1,993 17% 01- 220 -78 -00 -9012 SALARY SURVEY - - 8,281 - _ _ (8,281) - 100% TOTAL EXPENSES: BU PLANNING & DEVELOPMENT 193,088 386,864 573,535 665,564 583,704 583,704 10,169 2% Page 21 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08109 BUDGET GENERALFUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 I DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08109 BUDGET RECOMM 4/11108 $ CHANGE % CHANGE COMMUNITY DEVELOPMENT COMMENTS: ADMINISTRATION COMMITTEE RECOMMENDATIONS: A Merit was reduced to 4 %. Social Security and IMRF reflect that change. Page 22 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET GENERAL FUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 I DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08109 BUDGET RECOMM 4/11/08 $ CHANGE % CHANGE STREETS EXPENSES 01- 410 -50 -00 -5107 SALARIES - EMPLOYEE 169,756 222,077 263,748 329,625 1 240,825 240,825 (22,923) -9% 01- 410 -50 -00 -5136 SALARIES - PART TIME 1,484 3,096 9,600 10,000 10,000 10,000 400 4% 01- 410 -50 -00 -5137 SALARIES - OVERTIME 16,557 12,637 20,000 20,000 15,000 15,000 (5,000) -25% 01- 410 -61 -00 -5313 ENGINEERING - IN TOWN ROAD PG 101,814 - 250,000 - 2 - - (250,000) -100% 01- 410 -61 -00 -5314 INSPECTIONS & LICENSES 318 509 400 400 400 400 - 0% 01410 -62 -00 -5401 CONTRACTUAL SERVICES 1,176 2,659 2,000 2,000 2,000 2,000 - 0% 01410 -62 -00 -5408 MAINTENANCE - EQUIPMENT 10,505 5,803 8,000 10,000 9,000 9,000 1,000 13% 01- 410 -62 -00 -5409 MAINTENANCE- VEHICLES 14,913 17,030 15,000 25,000 3 18,000 18,000 3,000 20% 01- 410 -62 -00 -5414 MAINTENANCE - TRAFFIC SIGNALS 11,299 22,645 18,000 15,000 15,000 15,000 (3,000) -17% 01410 -62 -00 -5415 MAINTENANCE- STREET LIGHTS 28,548 15,824 26,500 20,000 20,000 20,000 (6,500) -25% 01410 -62 -00 -5420 MAINTENANCE -STORM SEWER - 2,231 10,000 10,000 4 10,000 10,000 - 0% 01410 -62 -00 -5421 WEARING APPAREL 5,157 4,401 6,150 6,150 4,150 4,150 (2,000) -33% 01- 410 -62 -00 -5422 RAYMOND DETENTION BASE - 75,000 - - - (75,000) - 100% 01410 -62 -00 -5423 RAYMOND STORM SEWER OUTFLOW - 1,300,000 - - - (1,300,000) -100% 01410 -62 -00 -5424 RAYMOND OUTFALL _ _ 01410 -62 -00 -5434 RENTAL - EQUIPMENT - 1,271 2,000 1,000 1,000 1,000 (1,000) -50% 01- 410 -62 -00 -5435 ELECTRICITY 56,246 77,684 74,400 78,120 78,120 78,120 3,720 5% 01410 -62 -00 -5438 CELLULAR TELEPHONE 2,814 3,197 4,000 4,500 5 3,300 3,300 (700) -18% 01410 -62 -00 -5440 STREET LIGHTING 687 200 6,000 4,000 1,000 1,000 (5,000) -83% 01410 -64 -00 -5604 TRAINING & CONFERENCES 4,862 947 7,525 7,500 6 5,500 4,500 (3,025) 40% 01410 -65 -00 -5421 GIS SYSTEM _ _ 01- 410 -65 -00 -5804 OPERATING SUPPLIES 19,236 18,166 30,000 20,000 15,000 15,000 (15,000) -50% 01410 -65 -00 -5812 GASOLINE 32,943 36,368 30,250 33,275 33,275 33,275 3,025 10% 01- 410 -65 -00 -5815 HAND TOOLS 2,507 187 2,500 1,500 1,500 1,500 (1,000) -40% 01- 410 -65 -00 -5817 GRAVEL 902 2,149 2,500 2,500 2,500 2,500 - 0% 01- 410 -72 -00 -6500 IMRF PARTICIPANTS 15,060 18,313 21,238 28,259 20,308 A 20,308 (930) -4% 01- 410 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 14,365 18,200 21,349 28,873 20,962 A 20,962 (387) -2% Page 23 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET GENERALFUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 I DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08109 BUDGET RECOMM 4111/08 $ CHANGE % CHANGE STREETS EXPENSES CONTINUED 01- 410 -75 -00 -5418 MOSQUITO CONTROL 20,296 28,414 30,000 31,500 30,000 30,000 - 0% 01- 410 -75 -00 -5419 MAINTENANCE SUPPLIES - STREETS - - - - - PROPERTY MAINTENANCE - - - 25,000 15,000 - - New 01- 410 -75 -00 -7004 SAFETY EQUIPMENT 708 1,793 1,000 1,000 1,000 1,000 - 0% 01- 410 -75 -00 -7099 GRANDE RES PERIMETER RDS 401,370 385,659 1,000,000 - 7 - - (1,000,000) -100% 01- 410 -75 -00 -7100 STREET REHAB PROJECTS 35,647 52,755 - - 8 - - - 01- 410 -75 -00 -7101 IN -TOWN ROAD PROGRAM 1,646,805 424,726 2,500,000 - 9 - - (2,500,000) -100% 01- 410 -75 -00 -7102 TREE & STUMP REMOVAL 9,510 9,623 23,000 20,000 5,000 5,000 (18,000) -78% 01- 410 -75 -00 -7103 SIDEWALK CONSTRUCTION 570 - 2,500 - 10 - - (2,500) -100% 01- 410 -75 -00 -7104 FOX HILL SSA EXPENSES 7,278 8,625 18,000 - 11 - - (18,000) -100% 01- 410 -75 -00 -7105 FOX ROAD SIDEWALK - - 25,000 - 12 - - (25,000) -100% 01- 410 -75 -00 -7106 ROAD CONTRIB FUND PROJECTS 11,043 37,936 180,000 - 13 - - (180,000) -100% 01- 410 -75 -00 -7107 ROAD CONTRIB FUND - RESERVE - - 1,020,000 - 14 - - (1,020,000) -100% 01- 410 -75 -00 -7108 126/71 IMPROVEMENTS - 19,000 - - - (19,000) -100% 01- 410 -75 -00 -7109 TRAFFIC SIGNALS RT. 34 & Sycamore - - - - - - 01- 410 -75 -00 -7110 ASPHAULT PAVEMENT - 27,573 - 15 - - (27,573) -100% DEVELOPER SIGNS 5,000 - - - 01- 410 -75 -00 -4404 HANGING BASKETS - 2,442 2,000 2,000 2,000 2,000 - 0% 01- 410 -78 -00 -9012 SALARY SURVEY - - 6,353 - - - (6,353) -100% 01- 410 -78 -00 -9005 MERIT /COLA - - 8,974 19,778 9,633 A 9,633 659 7% 01- 410 -99 -00 -9930 TRANSFER TO WATER IMPROVE 215,000 220,000 - - - - - TOTAL EXPENSES: STREETS 2,859,373 1,657,567 7,069,560 761,979 589,473 573,473 (6,496,087) -92% 682,560 Page 24 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET GENERAL FUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 I DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08109 BUDGET RECOMM 4/11108 $ CHANGE % CHANGE STREETS - COMMENTS FROM THE DEPT REQUEST COLUMN 1 1 New Hire MW 1 $35,000 (This was eliminated) 2 Moved to City -Wide Capital Fund 3 Increase for other department work can lower other departments line items 4 West Main storm sewer and maintenance 5 Additional Phone and Service 6 Certification updates for 4 employees / National Congress Foreman and 1/3 for Director (National was eliminated) 7 Moved to City -Wide Capital Fund 8 Moved to City -Wide Capital Fund 9 Moved to City -Wide Capital Fund 10 Moved to City -Wide Capital Fund 11 Moved to Fox Hill SSA Fund 12 Moved to City -Wide Capital Fund 13 Moved to City -Wide Capital Fund 14 Moved to City -Wide Capital Fund 15 Moved to City -Wide Capital Fund ADMINISTRATION COMMITTEE RECOMMENDATIONS: A Merit was reduced to 4 %. Social Security and IMRF reflect that change. Page 25 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET GENERALFUND A D E F F -A F -A ADMIN PROPOSED 2005 -2006 2006 -2007 2007 -2008 I DEPT PROPOSED FY COMM AS OF ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08109 BUDGET RECOMM 4/11108 $ CHANGE % CHANGE HEALTH & SANITATION EXPENSES 01- 540 -62 -00 -5442 GARBAGE SERVICES 591,517 747,186 1,031,401 1,300,000 1,300,000 1,300,000 268,599 26% 01- 540 -62 -00 -5443 LEAF PICKUP 7,050 5,235 6,000 6,000 6,000 6,000 - 0% TOTAL EXPENSES: HEALTH & SANITATION 598,567 752,421 1,037,401 1,306,000 1,306,000 1,306,000 268,599 26% TOTAL GENERAL FUND REVENUES 13,640,046 14,625,881 19,346,897 13,836,653 13,836,653 12,731,770 (6,615,127) -34% TOTAL GENERAL FUND EXPENSES 10,949,446 12,435,423 19,346,897 16,147,605 14,074,058 13,331,770 (6,015,128) -31% FUND SURPLUS (DEFICIT) BALANCE 2,690,600 2,190,458 (0) (2,310,952) (237,405) (600,000) (599,999) — The ($600,000) is projected to come from the general fund balance. Page 26 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET MOTOR FUEL TAX A D E E -A E -A ACCOUNT 2005 -2006 2006 -2007 2007 -2008 DEPT PROPOSED FY % NUMBER DESCRIPTION Actual Actual Budget REQUEST 08/09 BUDGET $ CHANGE CHANGE REVENUES 15- 000 -40 -00 -3999 BEGINNING FUND BALANCE - 505,226 194,152 117,440 118,520 (75,632) -39% 15- 000 -40 -00 -4060 MOTOR FUEL TAX ALLOTMENTS 266,560 307,043 315,000 325,000 325,000 10,000 3% 15- 000 -40 -00 -4065 IDOT TRUCK ACCESS GRANT - _ 15- 000 -44 -00 -4490 MISC INCOME - 11,806 - - - - 15- 000 -44- 00-4401 GAME FARM ROAD DESIGN - 157,000 157,000 157,000 - 0% 15- 000 -46 -00 -4600 INVESTMENT INCOME 15,528 24,062 13,500 14,000 14,000 500 4% 15- 000 -49 -00 -4901 TRANSFER FROM GEN FD - _ TOTAL REVENUES: 282,089 848,137 679,652 613,440 614,520 (65,132) -10% EXPENSES 15- 000 -65 -00 -5800 CONTINGENCY 11,936 455 9,052 - - (9,052) -100% 15- 000 -65 -00 -5818 SALT 46,482 63,801 78,010 83,850 86,000 7,990 10% 15- 000 -75 -00 -7007 SIGNS 9,799 9,574 9,990 9,990 14,550 4,560 46% 15- 000 -75 -00 -7008 CRACK FILLING 32,200 18,759 - 20,000 20,000 20,000 15- 000 -75 -00 -7106 GAME FARM SURVEYING - 68,000 68,000 68,000 - 0% 15- 000 -75 -00 -7107 GAME FARM ENGINEERING 65,721 34,902 317,000 314,000 314,000 (3,000) -1% 15- 000 -75 -00 -7108 VAN EMMON STREET - _ 15- 000 -75 -00 -7110 COLD PATCH 886 3,996 8,000 8,000 3,720 (4,280) -54% 15- 000 -75 -00 -7111 HOT PATCH 1,830 6,977 9,600 9,600 8,250 (1,350) -14% 15- 000 -75 -00 -7112 VAN EMMON - 30,000 - - (30,000) - 100% 15- 000 -75 -00 -7113 COUNTRYSIDE PKWY CONST. - 201,442 - - - - RT. 126 / 71 TRAFFIC SIGNALS - - _ _ 15- 000 -75 -00 -7115 PALMER COURT - 70,000 - - (70,000) -100% 15- 000 -75 -00 -7116 WOOD DALE - 30,000 - - (30,000) - 100% 15- 000 -75 -00 -7117 FAXON ROAD ROW ACQ - 50,000 - - (50,000) - 100% 15- 000 -75 -00 -7118 Rt. 34 & SYCAMORE TRAFF SIG - - _ _ Page 27 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08109 BUDGET MOTOR FUEL TAX A D E E -A E -A ACCOUNT 2005 -2006 2006 -2007 2007 -2008 DEPT PROPOSED FY % NUMBER DESCRIPTION Actual Actual Budget REQUEST 08/09 BUDGET $ CHANGE CHANGE MFT EXPENSES CONTINUED GAME FARM ROW - 100,000 100,000 100,000 New 15- 000 -99 -00 -9960 TRANSFER TO FOX INDUSTRIAL 31,190 - - - - - TOTAL EXPENSES: 200,044 339,906 679,652 613,440 614,520 (65,132) -10% TOTAL FUND REVENUES 282,089 848,137 679,652 613,440 614,520 (65,132) -10% TOTAL FUND EXPENSES 200,044 339,906 679,652 613,440 614,520 (65,132) -10% FUND SURPLUS (DEFICIT) BALANCE 82,045 508,231 0 0 0 0 MFT COMMENTS: Page 28 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET MUNICIPAL BUILDING A D E E -A E -A ACCOUNT 2005 -2006 2006 -2007 2007 -2008 DEPT PROPOSED FY % NUMBER DESCRIPTION Actual Actual Budget REQUEST 08/09 BUDGET $ CHANGE CHANGE REVENUES 16- 000 -40 -00 -3999 BEGINNING FUND BALANCE - (208,136) - - - - 16- 000 -42 -00 -4211 DEVELOPMENT FEES - BUILDING 85,950 79,350 400,000 100,000 1 100,000 - -75% 16- 000 -42 -00 -4215 BEECHER RENTAL FEE 7,095 12,100 9,000 - - (300,000) -100% 16- 000 -42 -00 -4216 RENTAL FEES 40,000 - - - - (9,000) 16- 000 -44 -00 -4400 BEECHER CENTER DONATION - - - 16- 000 -49 -00 -4901 TRANSFER FROM GENERAL FUND 102,043 64,647 - - - - 16- 000 -49 -00 -4902 TRANS FROM LAND ACQUISITION - 13,618 - - - - TOTAL REVENUES: 235,088 (38,421) 409,000 100,000 100,000 (309,000) -76% EXPENSES 16- 000 -62 -00 -5416 GENERAL BLDG & GRNDS 689 1,171 5,000 2,500 - - - 100% 16- 000 -62 -00 -5402 RECREATIONAL RENTAL FEE - - - - - (5,000) 16- 000 -75 -00 -7008 ENTRY WAY SIGNS - - 2,000 2,500 - - - 100% 16- 000 -75 -00 -7200 BLDG IMPROV- PARK & REC 17,379 12,105 12,000 12,000 - (2,000) - 100% 16- 000 -75 -00 -7202 BLDG IMPROVE - CITY HALL - - - - - (12,000) 16- 000 -75 -00 -7203 BLDG IMPROVE - PUBLIC WKS 9,704 8,939 12,000 5,500 - - - 100% 16- 000 -75 -00 -7204 BLDG MAINT - CITY HALL 15,549 6,497 8,000 15,000 - (12,000) - 100% 16- 000 -75 -00 -7205 BLDG IMPROVEMENTS - LIBRARY 2,548 - - - - (8,000) 16- 000 -75 -00 -7206 LANDSCAPING - PUBLIC BLDINGS 2,044 1,678 3,500 3,500 - - - 100% 16- 000 -75 -00 -7209 BEECHER PARKING LOT 41,120 - - - - (3,500) 16- 000 -75 -00 -7210 BLDG IMPROVE - POST OFFICE - 104,873 - - - - 16- 000 -75 -00 -7211 NEW BUILDINGS - - 51,577 40,600 40,600 - -21% 16- 000 -78 -00 -9009 USE OF RESERVE - - 30,000 - - (10,977) - 100% 16- 000 -99 -00 -9901 TRANSFER TO GENERAL FUND - - 182,500 - - (30,000) -100% 16- 000 -99 -00 -9965 TRANSFER TO DEBT SERVICE 103,923 102,423 102,423 59,400 59,400 (182,500) -42% TOTAL EXPENSES: 192,957 237,685 409,000 141,000 100,000 (265,977) -76% Page 29 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET MUNICIPAL BUILDING A D E E -A E -A ACCOUNT 2005 -2006 2006 -2007 2007 -2008 DEPT PROPOSED FY % NUMBER DESCRIPTION Actual Actual Budget REQUEST 08109 BUDGET $ CHANGE CHANGE TOTAL FUND REVENUES 235,088 (38,421) 409,000 100,000 100,000 (309,000) -76% TOTAL FUND EXPENSES 192,957 237,685 409,000 141,000 100,000 (265,977) -76% FUND SURPLUS (DEFICIT) BALANCE 42,131 (276,106) 0 (41,000) - (43,023) MUNICIPAL BUILDING COMMENTS: 1 181 Permits* $550 each Page 30 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET FOX HILL SPECIAL SERVICE AREA A D E E -A E -A ACCOUNT 2006 -2007 2007 -2008 DEPT PROPOSED FY NUMBER DESCRIPTION Actual Budget REQUEST 08109 BUDGET $ CHANGE % CHANGE REVENUES 17- 000 -40 -00 -4002 FOX HILL LEVY REVENUE 18,204 18,000 6,376 6,376 (11,624) -65% TOTAL REVENUES: 18,204 18,000 6,376 6,376 (11,624) -65% EXPENSES 01- 410 -75 -00 -7104 FOX HILL SSA EXPENSES 8,625 18,000 6,376 1 6,376 (11,624) -65% TOTAL EXPENSES: 8,625 18,000 6,376 6,376 (11,624) -65% TOTAL FUND REVENUES 18,204 18,000 6,376 6,376 (11,624) -65% TOTAL FUND EXPENSES 8,625 18,000 6,376 6,376 (11,624) -65% FUND SURPLUS (DEFICIT) BALANCE 9,579 0 (0) (0) (0) SSA COMMENTS: 1 Mowing 2,678 Beautification 510 Weeding 255 Mulching 765 Trail Maintenance 1,020 Trimming 829 Monument Repairs 64 General Maintenance 255 Page 31 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET SUNFLOWER SPECIAL SERVICE AREA A D E E -A E -A ACCOUNT 2006 -2007 2007 -2008 DEPT PROPOSED FY NUMBER DESCRIPTION Actual Budget REQUEST 08109 BUDGET $ CHANGE % CHANGE REVENUES 18- 000 -40 -00 -4002 SUNFLOWER LEVY REVENUE - 18,000 15,925 15,925 (2,075) -12% TOTAL REVENUES: - 18,000 15,925 15,925 (2,075) -12% EXPENSES 18- 410 -75 -00 -7104 SUNFLOWER SSA EXPENSES 0 18,000 15,925 1 15,925 (2,075) -12% TOTAL EXPENSES: 0 18,000 15,925 15,925 (2,075) -12% TOTAL FUND REVENUES - 18,000 15,925 15,925 (2,075) -12% TOTAL FUND EXPENSES - 18,000 15,925 15,925 (2,075) -12% FUND SURPLUS (DEFICIT) BALANCE - 0 - - - SSA COMMENTS: 1 Mowing 7,485 Beautification 1,274 Weeding 637 Mulching 1,592 Pond Maintenance 2,229 Trimming 1,911 Monument Repairs 159 General Maintenance 637 Page 32 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET POLICE CAPITAL A D E E -A E -A 2005 -2006 2006 -2007 2007 -2008 DEPT PROPOSED FY % ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08109 BUDGET $ CHANGE CHANGE REVENUES 20- 000 -40 -00 -3999 BEGINNING FUND BALANCE - 165,558 82,648 - 125,598 42,950 52% 20- 000 -42 -00 -4212 DEV FEES - POLICE 195,600 140,850 235,000 200,000 1 200,000 (35,000) -15% 20- 000 -44 -00 -4402 K -9 DONATIONS 200 2,977 - 50 50 50 20- 000 -44 -00 -4403 IN CAR VIDEO DONATIONS 8,130 11,150 6,000 2,000 2,000 (4,000) -67% 20- 000 -44 -00 -4404 DONATIONS 1,500 42 - 2,000 2,000 2,000 20- 000 -44 -00 -4405 WEATHER WARNING SIREN 29,231 8,358 15,000 7,500 7,500 (7,500) -50% 20- 000 -44- 00-4431 SALE OF POLICE SQUADS - 950 - - - - 20- 000 -44 -00 -4489 RICP DISASTER PLAN GRANT 9,990 - - - - - 20- 000 -44 -00 -4490 MISC INCOME 36,523 - - - - - 20- 000 -48 -00 -4800 LOAN PROCEEDS - - - - - - 20- 000 -49 -00 -4901 TRANSFER FROM GENERAL FD - 82,402 - - - - TOTAL REVENUES: 281,174 412,287 338,648 211,550 337,148 (1,500) 0% EXPENSES 20- 000 -65 -00 -5811 LETHAUNON- LETHAL WEAPON 6,825 7,000 10,000 10,000 10,000 - 0% 20- 000 -75 -00 -7001 EQUIPMENT 20,000 36,604 36,411 40,000 40,000 3,589 10% 20- 000 -75 -00 -7002 K -9 EQUIPMENT - 1,242 2,500 2,500 2,500 - 0% 20- 000 -75 -00 -7003 EXPEDITION AND ACCESSOR - - - - 20- 000 -75 -00 -7005 VEHICLES 72,385 104,270 80,000 85,000 2 85,000 5,000 6% 20- 000 -75 -00 -7006 CAR BUILD OUT 25,621 47,136 68,948 50,000 3 50,000 (18,948) -27% 20- 000 -75 -00 -7008 NEW WEATHER WARN SIRENS 10,450 - 37,000 37,000 4 37,000 - 0% 20- 000 -75 -00 -7009 RES- WEATHER WARN SIREN - - 82,648 82,648 82,648 - 0% 20- 000 -75 -00 -7010 NEW WORLD SOFTWARE - - - - - - ARCHITECT FEES 30,000 30,000 20- 000 -78 -00 -9009 USE OF RESERVE 26,526 - 21,141 - - (21,141) -100% 20- 000 -99 -00 -9965 TRANSFER TO DEBT SERV FD 24,110 - - - - TOTAL EXPENSES: 185,916 196,252 338,648 337,148 337,148 (1,500) 0% Page 33 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET POLICE CAPITAL A D E E -A E -A 2005 -2006 2006 -2007 2007 -2008 DEPT PROPOSED FY % ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08109 BUDGET $ CHANGE CHANGE TOTAL FUND REVENUES 281,174 412,287 338,648 211,550 337,148 (1,500) 0% TOTAL FUND EXPENSES 185,916 196,252 338,648 337,148 337,148 (1,500) 0% FUND SURPLUS (DEFICIT) BALANCE 95,258 216,035 0 (125,598) - - POLICE CAPITAL COMMENTS: 1 400 Permits @ $500 each 2 4 New Squad Cars 3 Outfit 2 New / Replace 2 Old 4 New Subdivisions Page 34 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET PUBLIC WORKS CAPITAL A D E E -A E -A ACCOUNT 2005 -2006 2006 -2007 2007 -2008 DEPT PROPOSED FY % NUMBER DESCRIPTION Actual Actual Budget REQUEST 08/09 BUDGET $ CHANGE CHANGE REVENUES 21- 000 -40 -00 -3999 BEGINNING FUND BALANCE - 585,955 200,000 - 90,000 (110,000) -55% 21- 000 -42 -00 -4213 DEVELOPMENT FEES - PUBLIC WKS 481,500 344,750 600,000 300,000 280,000 (320,000) -53% 21- 000 -44 -00 -4430 SALE OF EQUIPMENT 34,114 - 65,000 16,000 16,000 (49,000) -75% 21- 000 -49 -00 -4915 TRANSFER FROM WATER FUND 50,000 50,000 - - - - 21- 000 -49 -00 -4920 TRANSFER FROM SEWER FUND 30,000 30,000 - - - - TOTAL REVENUES: 595,614 1,010,705 865,000 316,000 386,000 (479,000) -55% EXPENSES 21- 000 -75 -00 -7001 EQUIPMENT - - 125,000 55,000 1 55,000 (70,000) -56% 21- 000 -75 -00 -7005 VEHICLES 184,968 286,326 385,000 161,000 2 161,000 (224,000) -58% 21- 000 -75 -00 -7006 F150 PICK UP TRUCKS - - - - 21- 000 -75 -00 -7007 5 YARD DUMP - - - - 21- 000 -75 -00 -7008 WATER DEPT PICK UP - - - - 21- 000 -75 -00 -7009 1 TON DUMP - - - - 21- 000 -75 -00 -7010 POWER BREAKER - - - - 21- 000 -75 -00 -7015 SKID STEER UPGRADE 3,952 4,500 9,500 5,000 5,000 (4,500) -47% 21- 000 -75 -00 -7100 BOB CAT EXCHANGE - - - - 21- 000 -75 -00 -7107 TRUCK ACCESSORIES 11,445 5,185 14,000 9,000 9,000 (5,000) -36% 21- 000 -75 -00 -7108 SKIDSTEER GRADER - - - - 21- 000 -75 -00 -7109 MOWER - - - - 21- 000 -75 -00 -7115 SALT DOME - - - - - - 21- 000 -75 -00 -7120 STREET SWEEPER - - - - 21- 000 -75 -00 -7130 FACILITY EXPANSION 4,000 7,442 200,000 38,600 128,600 (71,400) -36% 21- 000 -78 -00 -9009 USE OF RESERVE 4,800 60,158 89,000 47,400 3 - (89,000) -100% 21- 000 -99 -00 -9941 TRANSFER TO PARKS CAPITAL - 42,500 - - (42,500) -100% TOTAL EXPENSES: 209,165 363,611 865,000 316,000 358,600 (506,400) -59% Page 35 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08109 BUDGET PUBLIC WORKS CAPITAL A D E E -A E -A ACCOUNT 2005 -2006 2006 -2007 2007 -2008 DEPT PROPOSED FY % NUMBER DESCRIPTION Actual Actual Budget REQUEST 08/09 BUDGET $ CHANGE CHANGE TOTAL FUND REVENUES 595,614 1,010,705 865,000 316,000 386,000 (479,000) -55% TOTAL FUND EXPENSES 209,165 363,611 865,000 316,000 358,600 (506,400) -59% FUND SURPLUS (DEFICIT) BALANCE 386,449 647,094 0 - 27,400 27,400 PUBLIC WORKS CAPITAL COMMENTS: 1 Tractor and large ditch mower / enclosed trailer and barricades / safety supplies for street closures 2 Water and street utility / truck for PW Director / 2 small trucks for meter readers and seasonal help 3 Reserve Policy 15% Page 36 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET PARKS & RECREATION CAPITAL A B C D E E -A E -A ACCOUNT 2005 -2006 2006 -2007 2007 -2008 YTD As of REVISED DEPT PROPOSED FY % NUMBER DESCRIPTION Actual Actual Budget 01/08 BUDGET REQUEST 08/09 BUDGET $ CHANGE CHANGE REVENUES 22- 000 -40 -00 -3999 BEGINNING FUND BALANCE - 11,454 105,000 - 85,000 - 26,948 (78,052) -74% 22- 000 -42 -00 -4216 PARKS CAPITAL FEE 23,900 17,350 30,000 16,750 18,000 18,000 18,000 (12,000) -40% 22- 000 -42 -00 -4217 PARK CAPTIAL DONATIONS 7,000 - - - - - - - 22- 000 -42 -00 -4218 IL CLEAN ENERGY GRANT - - - - - - - - 22- 000 -44-00 -4430 SALE OF VEHICLES /EQUIPMENT - - - - 16,000 20,000 20,000 20,000 22- 000 -49 -00 -4930 TRANSFER FROM GENERAL FD - 150,000 - - - - 22- 000 -49 -00 -4935 TRANSFER FROM LAND CASH - - 22- 000 -49 -00 -4950 TRANSFER FROM PW CAPITAL - - 45,000 21,250 42,500 - - (45,000) -100% TOTAL REVENUES: 30,900 178,804 180,000 38,000 161,500 38,000 64,948 (115,052) -64% EXPENSES PARKS CAPITAL OUTLAY 22- 610 -65 -00 -5800 USE OF RESERVE - - - - - - - - 22- 610 -65 -00 -5805 BEECHER LIGHTING - - - - - 22- 610 -65 -00 -7005 VEHICLES - - - - - 22- 610 -75 -00 -7006 PICK UP TRUCKIDUMP TRUCK 60,020 68,722 45,000 - 25,000 57,000 1 - (45,000) -100% 22- 610 -75 -00 -7008 SOCCER GOALS 9' - - - - - 22- 610 -75 -00 -7009 COMPUTER WORKSTATIONS 8,351 - - - - - - - 22- 610 -75 -00 -7010 TOWN SQUARE FOUNTAIN - - - - 22- 610 -75 -00 -7011 PLAYER BENCHES - - - - - 22- 610 -75 -00 -7012 RIVERFRONT PLAYGROUND 630 - - - 22- 610 -75 -00 -7013 PLAYGROUND REPAIRS - - - - - 22- 610 -75 -00 -7014 SIGN REPLACEMENTS 4,000 - - - - 22- 610 -75 -00 -7015 PARKS EQUIPMENT 5,961 13,267 30,000 9,388 66,000 44,000 19,948 (10,052) -34% 22- 610 -75 -00 -7016 COMPUTER SERVER - - 5,000 4,729 5,000 - - (5,000) -100% 22- 610 -75 -00 -7017 RECREATION EQUIPMENT 6,175 - - - - Page 37 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET PARKS & RECREATION CAPITAL PARK AND RECREATION CAPITAL EXPENSES CONTINUED 22- 610 -75 -00 -7018 PARK REDEVELOPMENTS - - 100,000 52,519 65,500 45,000 45,000 (55,000) -55% TOTAL EXPENSES: PARKS 85,136 81,989 180,000 66,635 161,500 146,000 64,948 (115,052) -64% TOTAL FUND REVENUES 30,900 178,804 180,000 38,000 161,500 38,000 64,948 (115,052) -64% TOTAL FUND EXPENSES 85,136 81,989 180,000 66,635 161,500 146,000 64,948 (115,052) -64% FUND SURPLUS (DEFICIT) BALANCE (54,236) 96,815 0 (28,635) 0 (108,000) - - PARKS AND RECREATION CAPITAL COMMENTS: 1 Replace 1 4X4 pickup and 1 dump truck (These have been eliminated) 2 Replace Smithco groomer, zero turn vacuum mower, purchase paint sprayer, purchase turf roller 3 Cobb Park redevelopment Page 38 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08109 BUDGET CITY WIDE CAPITAL A B B -A B -A ACCOUNT DEPT PROPOSED FY NUMBER DESCRIPTION REQUEST 08 /09 BUDGET $ CHANGE % CHANGE REVENUES 23- 000 -40 -00 -3996 ROAD CONTRIBUTION 800,000 2 800,000 - 0% 23- 000 -40 -00 -3998 ROAD FUNDING - MPI _ _ _ 23- 000 -40 -00 -3999 RESERVE FUND BALANCE 90,000 - (90,000) -100% 01- 000 -42 -00 -4211 ENGINEERING CAPITAL FEE 40,000 1 40,000 - 0% DOWNTOWN BRWN GRANT 100,000 100,000 - 0% TRANSFER FROM GEN FD 575,000 385,000 (190,000) -33% TOTAL REVENUES: 1,605,000 1,325,000 (280,000) -17% EXPENSES 23- 000 -75 -00 -7107 ROAD CONTRIBUTION RESER - - - ENGINEER CAPITAL (VEHICLES) 40,000 1 40,000 - 0% 23- 000- 75 -00- MPI RESERVE - - - RON CLARK PROPERTY 100,000 100,000 - 0% 23- 000 -75 -00 -7130 PW BUILDING 90,000 - (90,000) -100% FAXON ROAD ROW 100,000 2 100,000 - 0% PALMER COURT 90,000 65,000 (25,000) -28% MCHUGH ROAD 300,000 2 300,000 - 0% VAN EMMON GUARD RAIL 10,000 - (10,000) -100% KENNEDY ROAD 200,000 2 90,000 (110,000) -55% ROB ROY FALLS SIGNAL 150,000 75,000 (75,000) -50% ASPHUALT PAVEMENT TREAT 50,000 50,000 - 0% PERIMETER RD STUDY 40,000 2 40,000 - 0% RIVER RD BRIDGE 50,000 - (50,000) -100% BEECHER RD STUDY 100,000 2 100,000 - 0% PARKING LOT SEALING 50,000 - (50,000) -100% TOWN SQUARE DRAINAGE 10,000 - (10,000) -100% DOWNTOWN BROWNFIELD 100,000 100,000 - 0% TOWN SQUARE SIDEWALK 25,000 - (25,000) -100% COMED BIKE TRAIL 55,000 50,000 (5,000) -9% RAYMOND BASIN - 30,000 30,000 100% Page 39 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08109 BUDGET CITY WIDE CAPITAL A B B -A B -A ACCOUNT DEPT PROPOSEDFY NUMBER DESCRIPTION REQUEST 08/09 BUDGET $ CHANGE % CHANGE PARKWAY TREE PLANTING 25,000 - (25,000) -100% SIDEWALK REPLACEMENT 20,000 15,000 (5,000) -25% TOTAL EXPENSES 1,605,000 1,155,000 (450,000) -28% TOTAL FUND REVENUES 1,605,000 1,325,000 (280,000) -17% TOTAL FUND EXPENSES 1,605,000 1,155,000 (450,000) -28% FUND SURPLUS (DEFICIT) BALANCE - 170,000 170,000 CITY WIDE CAPITAL COMMENTS: 1 $100 " 400 Permits 2 These projects are tied to the road contribution fees collected Page 40 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET DEBT SERVICE A B C D E E -A E -A ACCOUNT 2005 -2006 2006 -2007 2007 -2008 YTD As of REVISED DEPT PROPOSED FY % NUMBER DESCRIPTION Actual Actual Budget 01/08 BUDGET REQUEST 08/09 BUDGET $ CHANGE CHANGE REVENUES 42- 000 -40 -00 -3999 BEGINNING FUND BALANCE - - 0.00 0.00 - - - - 42- 000 -44 -00 -4440 RECAPTURE- WATER/SEWER 114,554 153,252 125,000 26,438 44,500 - - (125,000) -100% 42- 000 -44 -00 -4441 LIBRARY BOND REFERENDUM - - 421,936 713,479 578,661 - - (421,936) -100% 42- 000 -49 -00 -4901 TRANSFER FROM GENERAL FUND - 292,859 284,202 173,913 231,884 425,124 425,124 140,922 50% 42- 000 -49 -00 -4910 TRANSFER FROM POLICE EQUIP CAP 24,110 - 0.00 - - - - 42- 000 -49 -00 -4925 TRANSFER FROM SANITARY SEWER 646,213 640,041 1,210,236 907,677 1,210,236 - - (1,210,236) -100% 42- 000 -49 -00 -4930 TRANSFER FROM WATER IMPRV FUND 296,442 443,121 457,075 438,416 584,555 - - (457,075) -100% 42- 000 -49 -00 -4940 TRANSFER FROM MUNICIPAL BLDG 103,923 102,423 102,423 76,817 102,423 59,400 59,400 (43,023) -42% TOTAL REVENUES: 1,185,242 1,631,696 2,600,872 2,336,740 2,752,259 484,524 484,524 (2,116,348) -81% EXPENSES 42- 000 -66 -00 -6001 CITY HALL BONDS - PRINCIPAL PMT 50,000 50,000 50,000 50,000 50,000 59,400 59,400 9,400 19% 42- 000 -66 -00 -6002 CITY HALL BONDS - INTEREST PMT 53,923 52,423 6,400 6,400 6,400 - - (6,400) -100% 42- 000 -66 -00 -6003 IRBB - BRUELL STREET INTEREST PYMT 85,435 83,795 81,794 81,795 81,795 - - (81,794) -100% 42- 000 -66 -00 -6004 IRBB - BRUELL STREET PRINCIPAL PYMT 80,000 80,000 80,000 80,000 80,000 - - (80,000) -100% 42- 000 -66 -00 -6005 NORTH H2O TOWER INT PYMT 1,912 2,832 - - - - - 42- 000 -66 -00 -6006 NORTH H2O TOWER PRIN PYMNT 23,088 21,795 - - - - - 42- 000 -66 -00 -6007 4.8 MILLION DEBT CERT INT PYMT(WATER) 233,150 233,150 173,650 168,021 160,630 - - (173,650) -100% 42- 000 -66 -00 -6008 COUNTRYSIDE ALT REV PRINCIPAL PYMT 120,000 125,000 135,000 135,000 135,000 - - (135,000) -100% 42- 000 -66 -00 -6009 COUNTRYSIDE ALT REV INTEREST PYMT 120,638 118,012 114,513 114,513 114,513 - - (114,513) -100% 42- 000 -66 -00 -6010 COM ED /HYDRAULIC DEBT CERT. INT PYMT 43,217 41,328 38,947 38,948 38,947 - - (38,947) -100% 42- 000 -66 -00 -6011 COM ED /HYDRAULIC DEBT CERT. PRINC. 135,000 140,000 145,000 145,000 145,000 - - (145,000) -100% 42- 000 -66 -00 -6012 Library Bond 2005B Principal - - 0 - - - - 42- 000 -66 -00 -6013 Library Bond 2005bB Interest - - 321,125 321,125 321,125 - - (321,125) -100% 42- 000 -66 -00 -6014 Library Bond 2006 Principal - - 0 - - - 42- 000 -66 -00 -6015 Library Bond 2006 Interest - - 100,811 100,810 130,322 - - (100,811) -100% 42- 000 -66 -00 -6016 ROB ROY CREEK BOND - - 468,950 468,950 468,950 - - (468,950) -100% IEPA DRINKING WTR PROJ L17 -1563 - - 0 - 56,528 - - Page 41 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET DEBT SERVICE A B C D E E -A E -A ACCOUNT 2005 -2006 2006 -2007 2007 -2008 YTD As of REVISED DEPT PROPOSED FY % NUMBER DESCRIPTION Actual Actual Budget 01/08 BUDGET REQUEST 08/09 BUDGET $ CHANGE CHANGE DEBT SERVICE EXPENSES CONTINUED IEPA DRINK WTR PROJ L17 -1563 INT - - 0 - 52,708 - - - 42- 000 -66 -00 -6043 INTER PYMT NORTH WATER TOWER - - - 42- 000 -66 -00 -6044 INTER PYMT POLICE CARS - - 42- 000 -66 -00 -6045 LOAN PYMT SSES IEPA PRINCIPAL - 31,275 - - - - 42- 000 -66 -00 -6046 INTER POLICE SQUAD CARS - - 42- 000 -66 -00 -6047 INTER PYMT RIVER CROSSING - 42- 000 -66 -00 -6048 INTER PYMT NORTH WATER TOWER - - _ _ _ _ 42- 000 -66 -00 -6049 SANITARY SIPHON L17- 115300 INTEREST - 8,301 8,301 8,301 8,301 - - (8,301) -100% 2007 A GO REFUND 02, 02A, 03 - - 83,476 - - - 42- 000 -66 -00 -6050 SANITARY SIPHON L17- 115300 PRINCIPAL 38,980 (596) 30,679 30,679 30,679 - - (30,679) -100% 42- 000 -66 -00 -6051 LOAN PYMT NORTH WATER TOWER - - _ _ _ 42- 000 -66 -00 -6052 LOAN PYMT NORTH WATER TOWER 42- 000 -66 -00 -6053 LOAN PYMT RIVER CROSSING - 42- 000 -66 -00 -6054 LOAN PYMT POLICE SQUAD CAR 24,037 - 42- 000 -66 -00 -6055 LOAN PAYMENT - SSES IEPA L17 -1153 INT 107,051 107,051 0 - - - 42- 000 -66 -00 -6055 LOAN PAYMENT - SSES IEPA L17 -1153 PRINC - - 107,051 154,023 109,234 - - (107,051) -100% 42- 000 -66 -00 -6056 Refunding 2006 Interest - - 95,027 95,027 95,027 (95,027) -100% 42- 000 -66 -00 -6057 Refunding 2006 A Principal - - 5,100 5,100 5,100 (5,100) -100% 42- 000 -66 -00 -6058 $2.8M North Water Tower 2002 Issue - - 60,000 - (60,000) -100% 42- 000 -66 -00 -6070 $650K ROAD IMPROVEMENT PROG INT. 14,273 26,070 22,820 22,820 22,820 29,745 29,745 6,925 30% 42- 000 -66 -00 -6071 $650K ROAD IMPROVEMENT PROG PRINC 50,000 65,000 75,000 75,000 75,000 75,000 75,000 - 0% 42- 000 -66 -00 -6072 2 MILLION ALT REVENUE (B.2 & B.3) INT. 29,800 234,139 88,925 88,925 88,925 (88,925) -100% 42- 000 -66 -00 -6073 2 MILLION ALT REVENUE (B.2 & B.3) PRINC - - 75,000 75,000 75,000 (75,000) -100% 42- 000 -66 -00 -6074 $3.825 MILLION IN TOWN ROAD - INT. - 183,870 156,779 156,779 156,779 160,379 160,379 3,600 2% 42- 000 -66 -00 -6075 $3.825 MILLION IN TOWN ROAD - PRINC - - 160,000 160,000 160,000 160,000 160,000 - 0% TOTAL EXPENSES: 1,210,501 1,603,445 2,600,872 2,582,215 2,752,259 484,524 484,524 (2,116,348) -81% Page 42 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET DEBT SERVICE A B C D E E -A E -A ACCOUNT 2005 -2006 2006 -2007 2007 -2008 YTD As of REVISED DEPT PROPOSED FY % NUMBER DESCRIPTION Actual Actual Budget 01/08 BUDGET REQUEST 08109 BUDGET $ CHANGE CHANGE TOTAL FUND REVENUES 1,185,242 1,631,696 2,600,872 2,336,740 2,752,259 484,524 484,524 (2,116,348) -81% TOTAL FUND EXPENSES 1,210,501 1,603,445 2,600,872 2,582,215 2,752,259 484,524 484,524 (2,116,348) -81% FUND SURPLUS (DEFICIT) BALANCE (25,259) 28,251 0 (245,475) - - - (0) -100% DEBT SERVICE COMMENTS: ALL WATER / SEWER / LIBRARY BOND PAYMENTS MOVED TO THEIR ORIGINATING DEPARTMENTS OPERATING BUDGET Page 43 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET WATER IMPROVEMENTS AND OPERATIONS A D E E -A E -A 2005 -2006 2006 -2007 2007 -2008 DEPT PROPOSED FY % ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08 /09 BUDGET $ CHANGE CHANGE REVENUES 51- 100 -40 -00 -3999 BEGINNING FUND BALANCE 441,462 600,497 - 296,858 296,858 296,858 New 51- 100 -42 -00 -4240 BULK WATER SALES 11,973 11,833 10,000 10,000 10,000 - 0% 51- 100 -42 -00 -4241 WATER SALES 1,222,781 1,324,777 1,300,000 1,450,000 1,450,000 150,000 12% 51- 100 -42 -00 -4242 WATER METER SALES 291,498 418,028 390,000 200,000 1 200,000 (190,000) -49% 51- 100 -42 -00 -4243 LEASE REVENUE - H2O TOWER 22,415 23,287 31,000 31,000 31,000 - 0% 51- 100 -44 -00 -4490 MISCELLANEOUS INCOME 290 488 - - - - 51- 100 -46 -00 -4600 INVESTMENT INCOME 25,069 74,789 23,683 35,000 35,000 11,317 48% 51- 000 -49 -00 -4901 TRANSFER FROM WTR IMPROVE - - - - 51- 000 -49 -00 -4902 TRANSFER FROM SAN IMPROVE - - - - TOTAL OPERATING REVENUES: 2,015,487 2,453,699 1,754,683 2,022,858 2,022,858 268,175 15% 51- 200 -40 -00 -3999 BEGINNING FUND BALANCE (417,093) (52,217) (1,472,375) 527,625 527,625 2,000,000 -136% 51- 200 -42 -00 -4220 CONNECTION FEES 1,537,680 1,319,125 1,500,000 532,000 532,000 (968,000) -65% MPI CONNECTION FEE RECOV - - 425,600 425,600 425,600 New AUTUMN CREEK CONN RECO - - 106,400 106,400 106,400 New 51- 200 -42 -00 -4221 SW WTR MAIN PROJECT REV 35,958 515 2,648,276 10,800,000 10,800,000 8,151,724 308% 51- 200 -42 -00 -4222 USGS SHALLOW WATER REV - - - - - - 51- 200 -44 -00 -4490 MISCELLANEOUS INCOME - - - - - 51- 200 -45 -00 -4530 RADIUM GRANT - - - - - 51- 200 -46 -00 -4600 INVESTMENT INCOME 71,127 44,232 55,000 30,000 30,000 (25,000) -45% 51- 200 -46 -00 -4601 ACCRUED INTEREST ON BONDS - - - - - 51- 200 -46 -00 -4602 PREMIUM ON BONDS - - - - - 51- 200 -48 -00 -4800 LOAN PROCEEDS CONTRACT B.1 - 1,402,853 - - - - 51- 200 -48 -00 -4801 IEPA LOAN CONTRACT B PROC 2,046,893 - - - - 51- 200 -48 -00 -4802 PROCEEDS ON SALE OF ATS - - - - - 51- 200 -48 -00 -4803 LOAN PROCEEDS - CTL ZONE - - - - - 51- 200 -49 -00 -4901 TRANSFER FROM GENERAL FD 215,000 220,000 200,000 200,000 200,000 - 0% 51- 200 -49 -00 -4915 TRANSFER FROM WATER FUND - - - TOTAL IMPROVEMENTS REVENUES: 3,489,565 2,934,508 2,930,901 12,621,625 12,621,625 9,690,724 331% Page 44 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET WATER IMPROVEMENTS AND OPERATIONS A D E E -A E -A 2005 -2006 2006 -2007 2007 -2008 DEPT PROPOSED FY % ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08109 BUDGET $ CHANGE CHANGE TOTAL REVENUES: 5,505,052 5,388,207 4,685,584 14,644,483 14,644,483 9,958,899 213% OPERATIONS EXPENSES: 51- 100 -50 -00 -5107 SALARIES - EMPLOYEE 250,525 272,639 297,738 420,200 2 330,849 33,111 11% 51- 000 -17 -00 -1000 DEPRECIATION EXPENSE - - - - - 51- 000 -50 -00 -5110 SALARIES - SECRETARIAL - - - - - 51- 100 -50 -00 -5136 SALARIES -PART TIME 5,216 2,766 8,500 5,000 5,000 (3,500) -41% 51- 100 -50 -00 -5137 SALARIES - OVERTIME 38,898 42,723 40,000 40,000 35,000 (5,000) -13% 51- 100 -61 -00 -5300 LEGAL SERVICES 338 - 2,000 2,000 2,000 - 0% 51- 100 -61 -00 -5303 JULIE SERVICE 8,494 9,975 11,000 11,000 11,000 - 0% 51- 100 -62 -00 -5401 CONTRACTUAL SERVICES 4,227 4,925 9,000 7,500 7,500 (1,500) -17% 51- 100 -62 -00 -5407 TREATMENT FACILITIES O & M 73,749 101,895 157,000 220,000 3 220,000 63,000 40% 51- 100 -62 -00 -5408 MAINTENANCE- EQUIPMENT 1,941 7,137 5,000 7,500 7,500 2,500 50% 51- 100 -62 -00 -5409 MAINTENANCE- VEHICLES 1,109 2,072 7,000 10,000 8,000 1,000 14% 51- 100 -62 -00 -5411 MAINTENANCE- COMPUTERS 132 150 500 500 500 - 0% 51- 100 -62 -00 -5413 MAINTENANCE - CONTROL SYS 1,654 2,073 - - - 51- 100 -62 -00 -5414 TRUCK LETTERING - - - - - 51- 100 -62 -00 -5421 WEARING APPAREL 2,451 4,499 4,850 5,500 4,500 (350) -7% 51- 100 -62 -00 -5422 WATER TOWER PAINTING 219,870 - - - - 51- 100 -62 -00 -5434 RENTAL - EQUIPMENT - 240 2,000 2,000 2,000 - 0% 51- 100 -62 -00 -5435 ELECTRICITY 116,401 121,844 161,200 275,000 275,000 113,800 71% 51- 100 -62 -00 -5436 TELEPHONE 16,126 35,764 22,000 22,000 22,000 - 0% 51- 100 -62 -00 -5438 CELLULAR TELEPHONE 3,930 3,733 3,300 3,300 3,300 - 0% 51- 100 -64 -00 -5600 DUES 770 1,161 1,000 1,000 1,000 - 0% 51- 100 -64 -00 -5603 SUBSCRIPTIONS 164 21 250 250 250 - 0% 51- 100 -64 -00 -5604 TRAINING & CONFERENCES 2,741 2,514 2,900 2,900 4 1,900 (1,000) -34% 51- 100 -64 -00 -5605 TRAVEL / MEALS / LODGING 945 1,321 5,400 5,400 4,000 (1,400) -26% 51- 100 -65 -00 -5800 CONTINGENCIES - - - - - - 51- 100 -65 -00 -5804 OPERATING SUPPLIES 41,750 44,423 50,000 52,500 45,000 (5,000) -10% Page 45 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET WATER IMPROVEMENTS AND OPERATIONS A D E E -A E -A 2005 -2006 2006 -2007 2007 -2008 DEPT PROPOSED FY % ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08109 BUDGET $ CHANGE CHANGE OPERATIONS EXPENSES CONTINUED 51- 100 -65 -00 -5808 POSTAGE & SHIPPING 14,002 13,935 18,000 18,000 18,000 - 0% 51- 100 -65 -00 -5809 PRINTING & COPYING 9,610 9,981 11,000 13,000 13,000 2,000 18% 51- 100 -65 -00 -5810 PUBLISHING &ADVERTISING 150 1,137 1,000 1,200 1,200 200 20% 51- 100 -65 -00 -5812 GASOLINE 21,296 31,628 35,000 38,500 38,500 3,500 10% 51- 100 -65 -00 -5815 HAND TOOLS 20 38 1,000 1,000 1,000 - 0% 51- 100 -65 -00 -5817 GRAVEL 2,256 3,248 5,000 4,000 4,000 (1,000) -20% 51- 100 -65 -00 -5819 CHLORINE - - - - - 51- 100 -65 -00 -5820 CHEMICALS 18,098 51,474 - - - 51- 000 -65 -00 -5821 CATHODIC PROTECTION - - - - - - 51- 100 -65 -00 -5822 WATER SAMPLES 21,412 18,592 14,000 14,000 14,000 - 0% 51- 000 -66 -00 -8200 INTEREST EXPENSE - (30,050) - - - 51- 100 -72 -00 -6500 IMRF PARTICIPANTS 23,343 26,570 25,467 37,134 29,000 3,532 14% 51- 100 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 23,026 26,725 25,601 37,320 29,229 3,627 14% 51- 100 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 2,570 2,311 1,500 - - (1,500) -100% 51- 100 -75 -00 -7004 SAFETY EQUIPMENT 2,385 1,000 3,000 1,000 1,000 (2,000) -67% 51- 100 -75 -00 -7506 METER READERS 7,177 7,219 12,000 12,000 12,000 - 0% 51- 100 -75 -00 -7507 HYDRANT REPLACEMENT 1,976 - 10,000 6,500 6,500 (3,500) -35% 51- 100 -75 -00 -7508 METERS & PARTS 285,457 252,008 300,000 280,000 5 280,000 (20,000) -7% 51- 100 -78 -00 -9005 REFUND - - 1,500 1,500 1,500 - 0% 51- 100 -62 -00 -5422 WATER TOWER PAINTING - - - 335,000 335,000 335,000 51- 100 -78 -00 -9008 RESERVE - H2O TOWER MAINT. - - - - - - 51- 100 -78 -00 -9006 MERIT - - 11,910 25,212 13,234 1,324 11% 51- 100 -78 -00 -9009 USE OF RESERVE - - 221,557 303,429 6 1,536 (220,021) -99% 51- 000 -78 -00 -9012 SALARY SURVEY - - 16,510 - - (16,510) -100% ELECTRICITY MONITOR - - 12,000 7 12,000 12,000 New LEAK DETECTION SURVEY - - 18,000 18,000 18,000 New Page 46 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08 /09 BUDGET WATER IMPROVEMENTS AND OPERATIONS A D E E -A E -A 2005 -2006 2006 -2007 2007 -2008 DEPT PROPOSED FY % ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08/09 BUDGET $ CHANGE CHANGE OPERATIONS EXPENSES CONTINUED 51- 100 -99 -00 -9901 TRANSFER TO GENERAL FUND 200,000 250,000 250,000 250,000 250,000 - 0% 51- 100 -99 -00 -9930 TRANSFER TO WTR IMPROVE - - - - - 51- 100 -99 -00 -9950 TRANSFER TO PW EQUIP CAP 50,000 50,000 - - - - TOTAL OPERATIONS EXPENSES: 1,474,211 1,377,691 1,754,683 2,502,345 2,064,998 310,314 18% IMPROVEMENT EXPENSES: 51- 200 -61 -00 -5300 LEGAL SERVICES 3,153 428 8,000 8,000 4,000 (4,000) -50% 51- 200 -61 -00 -5301 ENGINEERING - GENERAL SVCS 14,636 20,000 40,000 20,000 20,000 (20,000) -50% 51- 200 -61 -00 -5400 RADIUM COMP PROJ /CNT B.2 & 3 1,001,893 265,993 - - - - 51- 200 -61 -00 -5401 ENG- RADIUM /CNT B.2 & B.3 1,228,007 270,953 - - - - 51- 200 -61 -00 -5402 ENG -SW H2O PROJ -F - 233,296 - - - 51- 200 -61 -00 -5405 PROF SVC /CONTRACT B.2 & 3 31,686 15,830 50,000 - - (50,000) -100% 51- 200 -61 -00 -5407 CONTRACT B1 CONSRUCTION - 1,211,358 - - - 51- 200 -61 -00 -5408 CENTRAL ZONE WATER IMP 127,272 45,210 - - - 51- 200 -61 -00 -5410 ENGINEERING - CENTRAL ZONE 33,072 11,207 - - - 51- 200 -61 -00 -5413 PROF SVCS - CENTRAL ZONE - - - - - 51- 200 -61 -00 -5414 CONTRACT D SCADA SYSTEM 5,261 - - - - 51- 200 -61 -00 -5415 USGS GROUNDWATER STUDY 40,290 8,000 4,000 - - (4,000) -100% 51- 200 -61 -00 -5416 USGS GRNDWTR COUNTYWIDE 15,082 13,828 - - - 51- 200 -61 -00 -5417 USGS GRDWTR SHALLOW WTR 65,923 45,491 - - - 51- 200 -61 -00 -5418 ENG TOWER LANE REHAB H.1 - - - - - - 51- 200 -61 -00 -5419 ENG WELL 4 REHAB H.1 - - - - 51- 200 -65 -00 -5421 GIS SYSTEM 11,642 8,465 - - - 51- 200 -65 -00 -5800 CONTINGENCY 23,388 - 3,608,441 - - (3,608,441) -100% 51- 200 -66 -00 -6012 BOND COSTS - BANK CHARGES - - - - - 51- 200 -66 -00 -6007 RADIUM COMPLIANCE BOND - - 33,150 33,150 33,150 New 51- 200 -66 -00 -6041 IEPA DRINKING WATER PRINCIPAL - - 56,528 56,528 56,528 New Page 47 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET WATER IMPROVEMENTS AND OPERATIONS A D E E -A E -A 2005 -2006 2006 -2007 2007 -2008 DEPT PROPOSED FY % ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08109 BUDGET $ CHANGE CHANGE IMPROVEMENT EXPENSES CONTINUED 51- 200 -66 -00 -6042 [EPA DRINKING WATER INTEREST - - 52,708 52,708 52,708 New 51- 200 -66 -00 -6056 2006A REFUNDING WTR INTEREST BD - - 5,100 5,100 5,100 New 51- 200 -66 -00 -6057 2006A REFUNDING WTR PRINCIPAL BD - - 97,007 97,007 97,007 New 51- 200 -66 -00 -6058 NORTH WTR TOWER 2002 ISSUE BD - - 60,000 60,000 60,000 New 51- 200 -66 -00 -6059 2007A REFUNDING WTR BOND - - 135,066 135,066 135,066 New 51- 200 -66 -00 -6072 $2M ALT REV WATER INTEREST BOND - - 91,300 91,300 91,300 New 51- 200 -66 -00 -6073 $2M ALT REV WATER PRINCIPAL BOND - - 75,000 75,000 75,000 New 51- 200 -75 -00 -7503 SOUTHWEST WATER MAIN PROJ 24,800 - 10,800,000 10,800,000 10,800,000 New 51- 200 -75 -00 -7504 NORTH WATER TOWER 234,942 4,418 - - - 51- 200 -75 -00 -7505 JOHNSON STREET WATERMAIN - - - - - 51- 200 -75 -00 -7506 APPLETREE COURT - - - - - 51- 200 -75 -00 -7507 OVERSIZING - KYLYN'S CROSSING 38,877 - - - - 51- 200 -75 -00 -7509 SCADA System 17,360 197,741 - - - 51- 200 -75 -00 -7515 JOHNSON STREET WATERMAIN - - - - - 51- 200 -75 -00 -7520 WATERMAIN PROJECTS - - 300,000 - - (300,000) -100% 51- 200 -75 -00 -7522 IN TOWN ROAD PROGRAM WTR PROJ - - 220,000 - - (220,000) -100% MPI RECOVERY - - 425,600 425,600 425,600 New AUTUMN CREEK RECOVERY - - 106,400 106,400 106,400 New FOX HILL WATERMAIN RECAPTURE - - 410,000 410,000 410,000 New 51- 200 -99 -00 -9901 TRANSFER TO GENERAL FUND 200,000 200,000 200,000 200,000 200,000 - 0% 51- 200 -99 -00 -9905 TRANSFER TO WATER FUND - - - - - 51- 200 -99 -00 -9910 PREMIUM ON BONDS - - - - - 51- 200 -99 -00 -9920 ACCRUED INTEREST ON BONDS - - - - - 51- 200 -99 -00 -9965 TRANSFER TO DEBT FUND 296,442 443,121 457,075 - - (457,075) -100% TOTAL IMPROVEMENT EXPENSES: 3,413,724 2,995,339 4,887,516 12,575,859 12,571,859 7,684,343 157% TOTAL EXPENSES: 4,887,935 4,373,030 6,642,199 15,078,204 14,636,857 7,994,657 120% Page 48 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET WATER IMPROVEMENTS AND OPERATIONS A D E E -A E -A 2005 -2006 2006 -2007 2007 -2008 DEPT PROPOSED FY % ACCOUNT NUMBER DESCRIPTION Actual Actual Budget REQUEST 08/09 BUDGET $ CHANGE CHANGE TOTAL FUND REVENUES 5,505,052 5,388,207 4,685,584 14,644,483 14,644,483 9,958,899 213% TOTAL FUND EXPENSES 4,887,935 4,373,030 6,642,199 15,078,204 14,636,857 7,994,657 120% FUND SURPLUS (DEFICIT) BALANCE 617,118 1,015,177 (1,956,615) (433,721) 7,626 1,964,242 -100% WATER COMMENTS: 1 200 @$390 / 200 @$485 / 10@ $2,800 2 $37,500 included for Superintendant position and 10% for vacation and sick time sold (This was eliminated) 3 Rising cost of salt and chemicals - producing more water 4 CEU classes for all license holders / class for MW 1 for license / 1/3 cost for Director National Congress (National was eliminated) 5 $75,000 for more fixed base radio read conversion / 3,000 hydrant flushers 6 Reserve Policy is 15% 7 This is for well 8 and 9 treatment facility Page 49 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET SEWER MAINTENANCE AND IMPROVEMENTS A D E E -A E -A ACCOUNT 2005 -2006 2006 -2007 2007 -2008 DEPT PROPOSED FY % NUMBER DESCRIPTION Actual Actual Budget REQUEST 08109 BUDGET $ CHANGE CHANGE REVENUES 52- 100 -40 -00 -3999 BEGINNING FUND BALANCE 327,526 657,374 - 309,383 309,383 309,383 New 52- 100 -42 -00 -4240 LIFT STATION INCOME - 19,097 8,000 - - (8,000) -100% 52- 100 -42 -00 -4250 SEWER MAINTENANCE FEES 478,385 576,524 486,000 500,000 1 500,000 14,000 3% 52- 100 -42 -00 -4251 SEWER CONNECTION FEES 180,600 142,660 260,000 200,000 2 200,000 (60,000) -23% 52- 100 -46 -00 -4600 INVESTMENT INCOME 25,154 74,824 15,000 35,000 35,000 20,000 133% TOTAL MAINTENANCE REVENUES: 1,011,665 1,470,479 769,000 1,044,383 1,044,383 275,383 36% IMPROVEMENT REVENUES: 52- 200 -40 -00 -3999 BEGINNING FUND BALANCE 3,521,714 3,314,989 5,387,523 - - (5,387,523) -100% 52- 200 -42 -00 -4220 CONNECTION FEES 1,281,300 1,033,136 904,491 800,000 800,000 (104,491) -12% 52- 200 -42 -00 -4221 RIVER CROSSING FEES 6,576 1,818 - - - - NORTH BRANCH #2 (DEV REV) - - 1,650,000 1,650,000 1,650,000 New 52- 200 -46 -00 -4600 INVESTMENT INCOME 243,928 158,809 75,000 30,000 30,000 (45,000) -60% 52- 200 -46 -00 -4601 ACCRUED INTEREST ON BONDS - - - - 52- 200 -48 -00 -4800 COMED /HYD DEBT CERT - - - - - 52- 200 -48 -00 -4801 BRUEL ST DEBT CERT - - - - - 52- 200 -48 -00 -4802 COUNTRYSIDE INTER BOND PRD - - - - - 52- 200 -48 -00 -4803 ROB ROY CREEK REVENUE 12,150,313 360,755 550,745 - - (550,745) -100% 52- 200 -48 -00 -4804 SWEST SERVICE AREA INTERCPT 253,662 56,181 5,500,000 - - (5,500,000) -100% 52- 200 -48 -00 -4805 COUNTRYSIDE INTERCEPTOR - 1,215,401 - - - - 52- 200 -49 -00 -4901 TRANSFER FROM GENERAL FUND 150,000 150,000 150,000 150,000 150,000 - 0% 52- 200 -49 -00 -4902 TRANSFER FROM SOUTH SEW FD - - - TOTAL IMPROVEMENT REVENUES: 17,607,493 6,291,089 12,567,759 2,630,000 2,630,000 (9,937,759) -79% TOTAL REVENUES: 18,619,158 7,761,568 13,336,759 3,674,383 3,674,383 (9,662,376) -72% MAINTENANCE EXPENSES: 52- 100 -50 -00 -5108 SALARIES - REGULAR 108,174 117,603 154,756 279,225 3 131,000 (23,756) -15% 52- 100 -50 -00 -5136 PART TIME 2,300 3,622 5,000 - - (5,000) -100% Page 50 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET SEWER MAINTENANCE AND IMPROVEMENTS A D E E -A E -A ACCOUNT 2005 -2006 2006 -2007 2007 -2008 DEPT PROPOSED FY % NUMBER DESCRIPTION Actual Actual Budget REQUEST 08/09 BUDGET $ CHANGE CHANGE MAINTENANCE EXPENSES CONTINUED: 52- 100 -50 -00 -5137 SALARIES- OVERTIME 3,060 3,300 12,000 10,000 8,000 (4,000) -33% 52- 100 -62 -00 -5401 CONTRACTUAL SERVICES 4,090 895 8,000 10,500 4 6,500 (1,500) -19% 52- 100 -62 -00 -5408 MAINTENANCE - EQUIPMENT 5,112 3,606 5,000 6,000 5,000 - 0% 52- 100 -62 -00 -5409 MAINTENANCE- VEHICLES 668 2,112 4,000 6,000 4,000 - 0% 52- 100 -62 -00 -5419 MAINTENANCE- SANITARY SEWER 11,877 4,420 20,000 20,000 20,000 - 0% 52- 100 -62 -00 -5421 WEARING APPAREL 3,398 4,234 2,350 3,000 2,500 150 6% 52- 100 -62 -00 -5422 LIFT STATION MAINTENANCE 23,232 11,626 25,000 25,000 25,000 - 0% 52- 100 -62 -00 -5434 RENTAL - EQUIPMENT - - 1,000 1,000 1,000 - 0% 52- 100 -62 -00 -5435 ELECTRICITY 33,628 78,450 75,000 75,000 75,000 - 0% 52- 100 -62 -00 -5438 CELLULAR TELEPHONE 2,328 3,614 1,750 2,500 2,500 750 43% 52- 100 -64 -00 -5604 TRAINING & CONFERENCES 526 40 2,000 2,000 5 1,000 (1,000) -50% 52- 100 - 64-00 -5605 TRAVEL / MEALS / LODGING 849 779 3,000 3,000 2,000 (1,000) -33% 52- 100 -65 -00 -5800 CONTINGENCIES - - 5,054 - - (5,054) -100% 52- 100 -65 -00 -5802 OFFICE SUPPLIES 2,179 2,329 3,000 2,500 2,500 (500) -17% 52- 100 -65 -00 -5804 OPERATING SUPPLIES 53 - - - 52- 100 -65 -00 -5805 SHOP SUPPLIES 1,457 1,933 3,000 2,500 2,500 (500) -17% 52- 100 -65 -00 -5812 GASOLINE 15,735 20,977 15,500 26,500 26,500 11,000 71% 52- 100 -65 -00 -5815 HAND TOOLS 415 - 1,000 1,000 1,000 - 0% 52- 100 -65 -00 -5817 GRAVEL 1,216 - 3,000 2,000 2,000 (1,000) -33% 52- 000 -65 -00 -5823 SEWER CHEMICALS 2,327 2,783 - - - - 52- 000 -66 -00 -8200 INTEREST EXPENSE - (175,119) - - - 52- 100 -72 -00 -6500 IMRF PARTICIPANTS 8,999 9,613 13,344 23,407 11,034 (2,309) -17% 52- 100 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 8,672 9,537 13,414 23,285 10,977 (2,437) -18% 52- 100 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 443 976 2,000 2,000 2,000 - 0% 52- 100 -75 -00 -7003 OFFICE EQUIPMENT 2,269 524 6,000 3,500 3,500 (2,500) -42% 52- 100 -75 -00 -7004 SAFETY EQUIPMENT 1,207 1,621 2,000 1,000 1,000 (1,000) -50% 52- 100 -78 -00 -9005 MERIT - - 6,190 16,754 5,240 (950) -15% 52- 100 -78 -00 -9009 USE OF RESERVE 9,800 - 296,667 156,657 6 156,657 (140,010) -47% Page 51 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET SEWER MAINTENANCE AND IMPROVEMENTS A D E E -A E -A ACCOUNT 2005 -2006 2006 -2007 2007 -2008 DEPT PROPOSED FY % NUMBER DESCRIPTION Actual Actual Budget REQUEST 08109 BUDGET $ CHANGE CHANGE MAINTENANCE EXPENSES CONTINUED: 52- 000 -78 -00 -9012 SALARY SURVEY - - 9,397 - - (9,397) -100% 52- 100 -99 -00 -9901 TRANSFER TO GENERAL FUND 70,000 70,000 70,578 70,000 70,000 (578) -1% 52- 100 -99 -00 -9950 TRANSFER TO PW EQUIP CAPITAL 30,000 30,000 - - - - TOTAL MAINTENANCE EXPENSES: 354,014 209,475 769,000 774,328 578,408 (190,591) -25% IMPROVEMENT EXPENSES: 52- 200 -62 -00 -5401 CONTRACTUAUPROF SVCS 7,218 5,953 30,000 20,000 20,000 (10,000) -33% 52- 200 -62 -00 -5402 ENG /LEGAUCONTINGEN- COUNSDE 142,893 33,698 - - - - ENGINEERING - ZANGLER - - - 20,000 20,000 - 0% 52- 200 -62 -00 -5405 ENGINEERING - BRUELL ST 94,428 (6) - - - 52- 200 -62 -00 -5406 HYDRAULIC INTERCEPTOR 1,940 - - - - 52- 200 -62 -00 -5407 ENG /LEG/ ROB ROY CREEK 225 - - - - 52- 200 -65 -00 -5800 CONTINGENCY - - - - - 52- 200 -66 -00 -6003 BRUELL ST INTEREST BOND - - 84,475 84,475 84,475 New 52- 200 -66 -00 -6004 BRUELL ST PRINCIPAL BOND - - 80,000 80,000 80,000 New 52- 200 -66 -00 -6008 COUNTRYSIDE PRINCIPAL BOND - - 135,000 135,000 135,000 New 52- 200 -66 -00 -6009 COUNTRYSIDE INTEREST BOND - - 116,138 116,138 116,138 New 52- 200 -66 -00 -6010 COMED HYDRALIC INTEREST BOND - - 40,975 40,975 40,975 New 52- 200 -66 -00 -6011 COMED HYDRALIC PRINCIPAL BOND - - 145,000 145,000 145,000 New 52- 200 -66 -00 -6016 ROB ROY BOND - - 468,950 468,950 468,950 New 52- 200 -66 -00 -6049 SANITARY SIPHON INTEREST IEPA - - 8,301 8,301 8,301 New 52- 200 -66 -00 -6050 SANITARY SIPHON PRINCIPAL IEPA - - 30,679 30,679 30,679 New 52- 200 -66 -00 -6055 IEPA WASTE WATER LOAN - - 109,234 109,234 109,234 New 52- 200 -66 -00 -6012 BOND COSTS - BANK CHARGES 216,425 - - - - 52- 200 -75 -00 -7109 CONTRACTUAUPROFESSIONAL SVC: - - - - - 52- 200 -75 -00 -7502 HYDRAULIC INTERCEPTOR - - - - - 52- 200 -75 -00 -7503 COUNTRYSIDE INTERCEPTOR 2,288,310 22,588 - - - 52- 200 -75 -00 -7504 BRUELL ST LIFT STATION 821,296 - - - - NORTH BRANCH #2 - - 1,650,000 1,650,000 1,650,000 New Page 52 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08109 BUDGET SEWER MAINTENANCE AND IMPROVEMENTS A D E E -A E -A ACCOUNT 2005 -2006 2006 -2007 2007 -2008 DEPT PROPOSED FY % NUMBER DESCRIPTION Actual Actual Budget REQUEST 08109 BUDGET $ CHANGE CHANGE IMPROVEMENT EXPENSES CONTINUED: 52- 200 -75 -00 -7505 ROB ROY CREEK SANITARY 7,662,913 - - - - - 52- 200 -75 -00 -7506 SOUTHWEST SERVICE AREA INTER 626,817 51,291 5,500,000 - - (5,500,000) -100% 52- 200 -75 -00 -7507 SANITARY JETTER TRUCK - - - 52- 200 -75 -00 -7508 MANHOLE REHAB PROJECT 6,456 - 15,000 - - (15,000) -100% 52- 200 -75 -00 -7509 SCADA SYSTEM - - 75,000 - - (75,000) -100% 52- 200 -75 -00 -7510 FOX HILL SANITARY SEWER RECAP - - 150,000 385,000 385,000 235,000 157% 52- 200 -75 -00 -7511 PALMER COURT - - 50,000 - - (50,000) -100% 52- 200 -75 -00 -7515 HEARTLAND ONSITE INTERCEPTOR 278,893 - - - - 52- 200 -99 -00 -9901 TRANSFER TO GENERAL FUND 150,000 150,000 150,000 150,000 150,000 - 0% 52- 200 -99 -00 -9905 TRANSFER TO WATER FUND - 0 - - - 52- 200 -99 -00 -9965 TRANSFER TO DEBT SERVICE 646,213 640,041 1,210,236 - - (1,210,236) -100% TOTAL IMPROVEMENT EXPENSES: 12,944,026 903,565 7,180,236 3,443,752 3,443,752 (3,736,485) -52% TOTAL EXPENSES: 13,298,040 1,113,040 7,949,236 4,218,080 4,022,160 (3,927,076) -49% TOTAL FUND REVENUES 18,619,158 7,761,568 13,336,759 3,674,383 3,674,383 (9,662,376) -72% TOTAL FUND EXPENSES 13,298,040 1,113,040 7,949,236 4,218,080 4,022,160 (3,927,076) -49% FUND SURPLUS (DEFICIT) BALANCE 5,321,118 6,648,528 5,387,523 (543,697) (347,777) (5,735,300) -106% SEWER COMMENTS: 1 18 * 6 cycles * 5,000 accounts 2 18 * 6 cycles * 5,000 accounts 3 Included 10% for sale of vacation and sick time/ 1/2 of Superintendant position/ Promotion MW II (Superintendant and promotion MW II positions eliminated) 4 Includes $6,500 for servicemaster 5 1 National Congress foreman / state and regional training for all employees / 1/3 cost for National Congress for Director (National eliminated) 6 Reserve Policy 15% Page 53 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET LAND CASH A B C D E E -A E -A ACCOUNT 2005 -2006 2006 -2007 2007 -2008 YTD As of REVISED DEPT PROPOSED FY % NUMBER DESCRIPTION Actual Actual Budget 01/08 BUDGET REQUEST 08109 BUDGET $ CHANGE CHANGE REVENUES 72- 000 -40 -00 -3999 BEGINNING FUND BALANCE 442,437 (200,757) (52,757) - (251,283) - (521,508) (468,751) 889% 72- 000 -47 -00 -4700 OSLAD GRANT - PRAIRIE MEADOW - - 400,000 - 400,000 400,000 1 400,000 - 0% 72- 000 -47 -00 -4700 OSLAD GRANT - WHISPERING MEA 74,000 - 362,000 - 362,000 362,000 2 362,000 - 0% 72- 000 -47 -00 -4701 GREENBRIAR 1,071 1,071 0 - - - 72- 000 -47 -00 -4702 BIKE PATH GRANT - - 200,000 - - 200,000 3 200,000 - 0% 72- 000 -47 -00 -4703 PRAIRIE GARDEN 12,285 - - - - - 72- 000 -47 -00 -4704 FOX HILL - - - - - - 72- 000 -47 -00 -4705 COUNTRY HILLS 6,921 3,076 1,200 - 1,200 500 1,700 500 42% 72- 000 -47 -00 -4707 FOX HIGHLANDS 1,406 - - - - - 72- 000 -47 -00 -4709 SUNFLOWER 1,805 - 0 361 361 - - - 72- 000 -47 -00 -4712 RIVER'S EDGE 13,420 2,684 2,684 - 2,684 1,000 3,684 1,000 37% 72- 000 -47 -00 -4714 WOODWORTH - - - - - - 72- 000 -47 -00 -4715 WHITE OAK UNIT 182 1,406 1,226 0 - - - - - 72- 000 -47 -00 -4717 KYLYN'S CROSSING - - 1,570 - 1,570 - 1,570 - 0% 72- 000 -47 -00 -4718 FOXFIELD II PARK LC - 1,688 - - - - - 72- 000 -47 -00 -4719 WILDWOOD 1,836 - - - - - 72- 000 -47 -00 -4720 HEARTLAND - - - - - - 72- 000 -47 -00 -4721 COUNTRYSIDE CENTER - - - - - - 72- 000 -47 -00 -4722 KYLN'S RIDGE 4,155 - 0 - - - - - 72- 000 -47 -00 -4751 CANNONBALL RIDGE GRANT - - 0 128,000 128,000 - - - 72- 000 -47 -00 -4723 HEARTLAND CIRCLE -LAND CASH 49,000 20,000 20,000 - 20,000 10,000 30,000 10,000 50% 72- 000 -47 -00 -4724 THE HIGHLANDS- RAINTREE VILLAGE - - 0 - - - - 72- 000 -47 -00 -4725 WINDETTE RIDGE -LAND CASH - - 0 - - - - 72- 000 -47 -00 -4726 RESERVE AT THE FOX - - 72- 000 -47 -00 -4727 GRAND RESERVE -LAND CASH 5,167 - 0 - - - - 72- 000 -47 -00 -4730 CANNONBALL ESTATES - - 72- 000 -47 -00 -4731 MONTALBANO HOMES LAND CASH - - 0 - - - - 72- 000 -47 -00 -4732 RAINTREE VILLAGE 29,000 133,400 - - - - Page 54 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET LAND CASH A B C D E E -A E -A ACCOUNT 2005 -2006 2006 -2007 2007 -2008 YTD As of REVISED DEPT PROPOSED FY % NUMBER DESCRIPTION Actual Actual Budget 01/08 BUDGET REQUEST 08 109 BUDGET $ CHANGE CHANGE LAND CASH REVENUES CONT'D 72- 000 -47 -00 -4734 WHISPERING MEADOWS - (Kimball Hill) 46,239 43,983 14,100 11,278 14,100 12,000 12,000 (2,100) -15% 72- 000 -47 -00 -4735 PRAIRIE MEADOWS - (Menards Res.) - - 0 - - - - - 72- 000 -47 -00 -4736 G9FReF StGne BRIARWOOD - - 113,043 - 113,043 - 113,043 - 0% 72- 000 -47 -00 -4737 CALEDONIA - - 0 - - 158,000 4 158,000 158,000 New 72- 000 -47 -00 -4738 AUTUMN CREEK 55,241 17,844 22,280 26,517 26,517 25,000 25,000 2,720 12% 72- 000 -47 -00 -4739 WYNSTONE TOWNHOMES - - 0 0 - - - - 72- 000 -47 -00 -4740 VILLAS AT THE PRESERVE 3,469 - 76,335 0 - - - (76,335) -100% 72- 000 -47 -00 -4741 BAILEY MEADOWS - - 0 0 - - - - 72- 000 -47 -00 -4742 BLACKBERRY WOODS - - 0 0 - - - - 72- 000 -47 -00 -4743 CORNEILS CROSSING - - 0 0 - - - - 72- 000 -47 -00 -4744 HUDSON LAKES - - 10,000 0 10,000 - 10,000 - 0% 72- 000 -47 -00 -4745 PRESTWICK - - 20,000 6,607 20,000 10,000 30,000 10,000 50% 72- 000 -47 -00 -4746 WESTBURY EAST - - 20,000 0 - - - (20,000) -100% 72- 000 -47 -00 -4747 WESTHAVEN - - 0 0 - - - - 72- 000 -47 -00 -4749 BLACKBERRY WOODS - 75,568 0 4,545 4,545 4,000 4,000 4,000 New 72- 000 -47 -00 -4750 KENDALLWOOD ESTATES - - 10,000 0 10,000 5,000 15,000 5,000 50% BRISTOL RIDGE - 0 0 - - - - ASPEN RIDGE - 0 0 - - - CHALLY FARM - 0 0 - - - - EVERGREEN FARM - 0 0 - - - - SILVER FOX - 0 0 - - - - TOWNES AT WINDETT RESERVE - 0 0 - - - - WESTBURY SOUTH - 0 0 - - - - YORKWOOD ESTATES - 0 0 - - - - YORKSHIRE ESTATES - 0 0 - - - - 72- 000 -49 -00 -4901 TRANSFER FROM GENERAL FUND - - 48,245 36,184 48,245 - - (48,245) -100% TRANSFER FROM LAND ACQ - 150,000 0 0 - - - - Page 55 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET LAND CASH A B C D E E -A E -A ACCOUNT 2005 -2006 2006 -2007 2007 -2008 YTD As of REVISED DEPT PROPOSED FY % NUMBER DESCRIPTION Actual Actual Budget 01/08 BUDGET REQUEST 08109 BUDGET $ CHANGE CHANGE LAND CASH REVENUES CONTINUED 72- 000 -49 -00 -4903 TRANSFER FROM PARK & REC - 4,949 0 0 - - - TOTAL REVENUES: 748,857 254,732 1,268,700 213,492 910,982 1,187,500 844,489 (424,211) -33% EXPENSES 72- 000 -75 -00 -7008 MISC BALLFIELD EQUIP - - - - - 72- 000 -75 -00 -7200 BLDG IMPROVE BEECHER CTR - - - - - 72- 000 -75 -00 -7201 RIVERFRONT BUILDING IMPROV. - 66,496 0.00 - - - - - 72- 000 -75 -00 -7300 GREENBRIAR 3,000 - 0.00 - - - - - 72- 000 -75 -00 -7301 FOX HILL - - - - 72- 000 -75 -00 -7302 COUNTRY HILLS - - - - - 72- 000 -75 -00 -7304 SUNFLOWER 72,112 33,221 - - - - - - 72- 000 -75 -00 -7307 RIVERS EDGE - - - - - 72- 000 -75 -00 -7308 RIVER'S EDGE PARK II 26,901 - 25,000 - - - - (25,000) -100% 72- 000 -75 -00 -7311 CANNONBALL ESTATES /KYLYNS 263,776 65 - - - - - 72- 000 -75 -00 -7317 HEARTLAND CIRCLE - - - - 167,000 167,000 167,000 New 72- 000 -75 -00 -7321 CANNONBALL HILL - - - - - 72- 000 -75 -00 -7322 BEECHER - - - - - 72- 000 -75 -00 -7324 TOWN SQUARE - - - - - - - 72- 000 -75 -00 -7325 VAN EMMON - - - - - 72- 000 -75 -00 -7326 MOSIER HOLDING COSTS - 15,685 15,700 10,000 15,700 10,000 5 10,000 (5,700) -36% 72- 000 -75 -00 -7327 GRANDE RESERVE PARK DEVELOPME 17,512 40,974 19,177 - - - 72- 000 -75 -00 -7328 PRAIRIE MEADOWS - (Menards Res.) - 22,964 442,000 178,487 150,000 295,000 6 295,000 (147,000) -33% 72- 000 -75 -00 -7329 ELSIE LOUISE GILBERT PARK 75,946 - 72- 000 -75 -00 -7330 WHISPERING MEADOWS - (Kimball Hill) 19,811 49,248 700,000 214,689 350,000 374,000 7 374,000 (326,000) -47% 72- 000 -75 -00 -7331 WINDETT RIDGE - - - - - - 72- 000 -75 -00 -7332 CALEDONIA - - - - 158,000 88,000 88,000 New 72- 000 -75 -00 -7333 RAINTREE VILLAGE - 72,539 10,000 1,800 - 183,500 8 70,000 60,000 600% Page 56 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET LAND CASH A B C D E E -A E -A ACCOUNT 2005 -2006 2006 -2007 2007 -2008 YTD As of REVISED DEPT PROPOSED FY % NUMBER DESCRIPTION Actual Actual Budget 01/08 BUDGET REQUEST 08/09 BUDGET $ CHANGE CHANGE LAND CASH EXPENSES CONT'D 72- 000 -75 -00 -7334 HOOVER HOLDING COSTS - 178,518 60,000 - 60,000 - - (60,000) - 100% 72- 000 -75 -00 -7700 PARKS MAINTENANCE FACILITY 4,000 10,306 - - - - - - 72- 000 -78 -00 -9009 USE OF RESERVE 385,674 - - - 319,282 - - - 72- 000 -78 -00 -9010 BEECHER CONCESSION STAND - - - - 72- 000 -99 -00 -9955 TRANSFER TO PARK & REC CAP - - - - - 72- 000 -99 -00 -9970 TRANSFER TO LAND ACQ - - - - - 72- 000 -99 -00 -9901 TRANSFER TO GENERAL FUND - 16,000 16,000 12,000 16,000 - 16,000 - 0% TOTAL EXPENSES: 868,734 506,016 1,268,700 436,154 910,982 1,187,500 1,020,000 (248,700) -20% TOTAL FUND REVENUES 748,857 254,732 1,268,700 213,492 910,982 1,187,500 844,489 (424,211) -33% TOTAL FUND EXPENSES 868,734 506,016 1,268,700 436,154 910,982 1,187,500 1,020,000 (248,700) -20% FUND SURPLUS (DEFICIT) BALANCE (119,876) (251,284) 0 (222,662) - - (175,511) (175,511) LAND CASH COMMENTS: 1 Grant reimbursement expected 2 Grant reimbursement expected 3 Grant reimbursement expected 4 Land cash is expected 5 Could drop Mosier costs thru the Foundation 6 Park projected to be finished this fiscal year 7 Park projected to be finished this fiscal year 8 Start Raintree Park if awarded the grant Page 57 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08109 BUDGET PARKS & RECREATION A B C D E E -A E -A 2005 -2006 2006 -2007 2007 -2008 YTD As of REVISED DEPT PROPOSED FY ACCOUNT NUMBER DESCRIPTION Actual Actual Budget 01/08 BUDGET REQUEST 08109 BUDGET $ CHANGE % CHANGE REVENUES 79- 000 -40 -00 -3999 BEGINNING FUND BALANCE 142,356 77,292 - - 42,540 42,540 - - 79- 000 -42 -00 -4270 FEES FOR PROGRAMS 235,917 243,507 250,000 210,340 275,000 275,000 300,000 50,000 20% 79- 000 -42 -00 -4280 CONCESSIONS /ALL SALE ITEMS 14,428 . 15,681 25,864 15,304 18,000 23,000 1 23,000 (2,864) -11% 79- 000 -42 -00 -4281 DEPOSITS 6,755 1,070 1,500 - 1,500 - - (1,500) -100% 79- 000 -42 -00 -4282 FARMERS MARKET - - - - - - 79- 000 -42 -00 -4283 SKATE PARK RENTAL - - - - - - 79- 000 -42 -00 -4284 SAFETY TOWN BLDG - - - - - - 79- 000 -42 -00 -4285 VENDING MACHINE INCOME 459 207 400 2,150 2,150 700 2 700 300 75% 79- 000 -42 -00 -4286 RENTAL INCOME 2,360 445 - - - - - - 79- 000 -42 -00 -4287 PARK RENTAL INCOME 390 810 600 1,815 1,815 4,000 3 4,000 3,400 567% 79- 000 -42 -00 -4288 GOLF OUTING REVENUE 40,160 40,888 40,700 30,694 30,694 32,100 32,100 (8,600) -21% 79- 000 -42 -00 -4289 DAY TRIPS - - - - - - 79- 000 -42 -00 -4290 YOUTH SPECIAL EVENTS - - - - - - 79- 000 -42 -00 -4291 HOMETOWN DAYS - 72,543 118,000 110,937 110,936 120,000 115,000 (3,000) -3% 79- 000 - 44-00 -4400 DONATIONS 14,843 10,896 19,000 11,078 13,000 13,000 20,000 1,000 5% 79- 000 -44 -00 -4404 TREE DONATIONS 900 1,405 800 1,300 1,300 2,500 4 1,300 500 63% 79- 000 - 44-00 -4490 MISC INCOME - - - - - - 79- 000 -45 -00 -4550 YOUTH SERVICES GRANT 2,000 2,000 2,000 2,000 3,600 2,000 2,000 - 0% 79- 000 -46 -00 -4600 INVESTMENT INCOME 11,576 11,647 10,000 5,619 6,200 12,000 12,000 2,000 20% 79- 000 -49 -00 -4901 TRANSFER FROM GENERAL FD 755,908 1,015,107 1,161,778 873,333 1,161,778 1,348,497 1,224,698 62,920 5% TOTAL REVENUES: 1,228,053 1,493,498 1,630,642 1,264,569 1,668,513 1,875,337 1,734,798 104,156 6% PARKS EXPENSES 79- 610 -50 -00 -5107 SALARIES- EMPLOYEES 287,508 332,926 339,047 311,961 427,000 457,682 5818 412,500 73,453 22% 79- 610 -50 -00 -5136 SALARIES - PART -TIME 38,528 41,155 58,000 32,841 48,000 60,000 55,000 (3,000) -5% 79- 610 -50 -00 -5137 SALARIES - OVERTIME 2,011 1,416 9,000 3,504 7,000 10,000 6 10,000 1,000 11% 79- 610 -61 -00 -5320 MASTER PLAN / COMMUNITY SURVEY - - 13,000 5,747 10,500 3,000 7 2,709 (10,291) -79% 79- 610 -62 -00 -5405 PARK CONTRACTUAL 15,624 13,468 22,500 17,597 21,500 26,000 26,000 3,500 16% 79- 610 -62 -00 -5408 MAINTENANCE - EQUIPMENT 9,161 9,503 10,000 4,345 8,000 11,000 10,000 - 0% 79- 610 -62 -00 -5417 MAINTENANCE -PARKS 34,250 46,240 50,000 21,275 50,000 60,000 8 55,000 5,000 10% 79- 610 -62 -00 -5421 WEARING APPAREL 6,363 6,928 8,000 4,003 7,000 10,000 9 9,000 1,000 13% Page 58 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET PARKS & RECREATION A B C D E E -A E -A 2005 -2006 2006 -2007 2007 -2008 YTD As of REVISED DEPT PROPOSED FY ACCOUNT NUMBER DESCRIPTION Actual Actual Budget 01/08 BUDGET REQUEST 08/09 BUDGET $ CHANGE % CHANGE PARKS EXPENSES CONT'D 79- 610 -62 -00 -5434 RENTAL - EQUIPMENT 612 1,968 2,000 1,504 3,000 4,000 4,000 2,000 100% 79- 610 -62 -00 -5438 CELLULAR TELEPHONE 3,903 4,521 5,000 2,860 4,000 5,500 10 5,000 - 0% 79- 610 -62 -00 -5440 LAND DEVELOPER 554 - - 7,556 8,550 - - - 79- 610 -62 -00 -5445 LEGAL EXPENSES 2,213 1,125 5,000 5,772 3,000 5,000 7,200 2,200 44% 79- 610 -64 -00 -5602 PROFESSIONAL GROWTH /SUBS 3,681 1,185 - - - - - - 79- 610 -64 -00 -5604 TRAINING AND CONFERENCE - - 9,000 3,130 8,000 9,000 4,500 (4,500) -50% 79- 610 -64 -00 -5605 TRAVEL EXPENSE 2,792 4,337 3,000 1,492 3,000 3,500 1,550 (1,450) -48% 79- 610 -64 -00 -5612 CONTINUING EDUCATION 2,528 3,708 - - - - - 79- 610 -65 -00 -5802 OFFICE SUPPLIES 1,569 1,403 1,500 63 1,500 1,500 1,500 - 0% 79- 610 -65 -00 -5804 OPERATING SUPPLIES 25,545 35,877 30,000 20,432 30,000 37,500 35,750 5,750 19% 79- 610 -65 -00 -5812 GASOLINE 725 1,077 - - - - - 79- 610 -65 -00 -5815 HAND TOOLS 4,116 3,657 3,500 1,263 3,500 4,000 3,500 - 0% 79- 610 -65 -00 -5824 CHRISTMAS DECORATIONS 6,409 6,629 5,000 1,022 5,000 7,500 11 2,500 (2,500) -50% 79- 610 -65 -00 -5825 PUBLIC DECORATION 1,160 1,332 3,000 830 3,000 3,500 1,500 (1,500) -50% 79- 610 -72 -00 -6500 IMRF PARTICIPANTS 22,694 26,021 31,420 24,013 32,500 41,290 33,584 2,164 7% 79- 610 -72 -00 -6501 SOCIAL SECURITY /MEDICARE 24,250 28,558 31,585 26,517 37,750 40,890 37,593 6,009 19% 79- 610 -75 -00 -7003 OFFICE EQUIPMENT 1,424 1,421 3,000 204 2,500 7,000 4,000 1,000 33% 79- 610 -75 -00 -7701 FLOWERSITREES 5,746 7,372 8,000 4,668 7,0 8,000 6,000 (2,000) -25% PARKS MISCELLANEOUS - - - 500 - - New 79- 610 -78 -00 -9005 MERIT - - 12,642 - - 8,335 16,500 3,858 31% TOTAL EXPENSES: PARKS 503,366 581,827 679,020 502,599 731,300 824,697 744,886 65,865 10% RECREATION EXPENSES 79- 650 -50 -00 -5107 EMPLOYEE SALARIES 254,258 353,326 358,532 280,240 393,000 429,386 12 359,525 993 0% PART TIME SALARIES 19 39,110 79- 650 -50 -00 -5108 CONCESSION STAFF 3,281 3,557 6,750 6,292 6,750 8,000 8,000 1,250 19% 79- 650 -50 -00 -5109 PRE SCHOOL SALARIES - 61,411 84,000 48,155 83,000 90,000 13 90,000 6,000 7% 79- 650 -50 -00 -5137 OVERTIME 93 - 15 15 350 350 350 79- 650 -50 -00 -5150 SALARIES- INSTRUCTOR CONTRACT 125,146 73,120 57,400 63,447 57,400 80,000 14 80,000 22,600 39% Page 59 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08109 BUDGET PARKS & RECREATION A B C D E E -A E -A 2005 -2006 2006 -2007 2007 -2008 YTD As of REVISED DEPT PROPOSED FY ACCOUNT NUMBER DESCRIPTION Actual Actual Budget 01/08 BUDGET REQUEST 08 109 BUDGET $ CHANGE % CHANGE RECREATION EXPENSES CONT'D 79- 650 -50 -00 -5155 SALARIES- RECORDING SECRETARY 2,052 2,465 2,500 1,931 2,500 2,750 2,750 250 10% 79- 650 -62 -00 -5321 RECREATION RESEARCH - - - - 79- 650 -62 -00 -5408 MAINTENANCE SUPPLIES 6,728 5,799 7,000 3,312 5,000 6,000 5,500 (1,500) -21% 79- 650 -62 -00 -5409 MAINTENANCE - VEHICLES 484 2,282 3,500 842 2,500 3,000 3,000 (500) -14% 79- 650 -62 -00 -5410 MAINTENANCE - OFFICE EQUIPMENT 4,779 7,043 6,500 3,202 6,000 7,300 15 7,000 500 8% 79- 650 -62 -00 -5426 YOUTH SERVICES GRANT EXPENSES 539 358 2,000 1,450 2,000 2,000 16 2,000 - 0% 79- 650 -62 -00 -5435 ELECTRICITY - - 7,574 8,820 10,000 10,000 10,000 New 79- 650 -62 -00 -5437 TELEPHONE /INTERNET 446 1,973 1,300 887 1,300 1,300 1,500 200 15% 79- 650 -62 -00 -5438 CELLULAR TELEPHONE 4,574 4,720 5,500 3,870 5,000 5,500 5,000 (500) -9% 79- 650 -62 -00 -5445 PORTABLE TOILETS 3,990 2,986 6,000 8,163 7,000 6,900 6,000 - 0% 79- 650 -62 -00 -5603 PUBLISHING /ADVERTISING 23,444 27,735 27,920 20,797 27,920 29,000 29,000 1,080 4% 79- 650 -62 -00 -5605 BOOKS /PUBLICATIONS 584 581 500 46 500 500 422 (78) -16% 79- 650 -62 -00 -5606 DEPOSIT REFUND 5,695 4,145 1,500 - 1,500 - - (1,500) -100% 79- 650 -6400 -5600 DUES 1,462 2,372 2,500 1,991 2,500 2,500 2,750 250 10% 79- 650 - 6400 -5602 PROF GROWTH /SUBSCRIPT 7,426 458 - - - - - 79- 650 -64 -00 -5604 TRAINING AND CONFERENCE - 7,606 10,200 4,575 10,200 8,650 4,500 (5,700) -56% 79- 650 -64 -00 -5605 TRAVEL EXPENSE 1,960 1,577 5,220 670 5,220 2,900 1,550 (3,670) -70% 79- 650 -64 -00 -5614 TOURNAMENT FEES - - - - 79- 650 -65 -00 -5802 OFFICE SUPPLIES 6,058 6,993 7,000 4,902 6,000 7,000 7,000 - 0% 79- 650 -65 -00 -5803 PROGRAM EXPENSES 47,176 55,472 50,100 47,624 50,100 48,000 50,000 (100) 0% 79- 650 -65 -00 -5804 OPERATING SUPPLIES 5,191 4,935 3,800 3,074 3,800 5,000 3,600 (200) -5% 79- 650 -65-00 -5805 RECREATION EQUIPMENT 3,544 4,018 7,100 3,650 6,000 19,150 10,000 2,900 41% 79- 650 -65 -00 -5808 POSTAGE & SHIPPING 7,565 8,597 7,600 6,249 7,600 7,820 7,800 200 3% 79- 650 -65 -00 -5812 GASOLINE 1,573 3,823 4,200 3,403 4,200 5,200 5,000 800 19% 79- 650 -65 -00 -5826 MILEAGE 818 456 750 202 200 500 400 (350) -47% 79- 650 -65 -00 -5827 GOLF OUTING EXPENSES 21,945 22,177 23,000 18,779 18,780 20,200 20,200 (2,800) -12% 79- 650 -65 -00 -5828 CONCESSIONS 11,660 14,011 15,500 16,676 17,650 11,500 11,500 (4,000) -26% 79- 650 -65 -00 -5829 SKATE PARKE EXPENSES - - - - 79- 650 -65 -00 -5830 YOUTH SPECIAL EVENTS - - - - 79- 650 -65 -00 -5831 DAY TRIP EXPENSES - - - - Page 60 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08 /09 BUDGET PARKS & RECREATION A B C D E E -A E -A 2005 -2006 2006 -2007 2007 -2008 YTD As of REVISED DEPT PROPOSED FY ACCOUNT NUMBER DESCRIPTION Actual Actual Budget 01/08 BUDGET REQUEST 08/09 BUDGET $ CHANGE % CHANGE RECREATION EXPENSES CONT'D 79- 650 -65 -00 -5832 SKATE PARK PAYROLL - - - _ 79- 650 -65 -00 -5833 HOMETOWN DAYS EXPENSES - 78,863 108,000 98,780 95,686 100,000 95,000 (13,000) -12% 79- 650 -65 -00 -5840 SCHOLARSHIPS 1,570 413 3,600 512 1,800 6,875 6,825 3,225 90% 79- 650 -65 -00 -5841 PROGRAM REFUND 11,688 7,827 6,500 6,643 8,000 8,000 9,000 2,500 38% 79- 650 -72 -00 -6500 IMRF PARTICIPANTS 22,246 29,623 36,346 22,594 36,346 36,212 29,678 (6,669) -18% 79- 650 -72 -00 -6501 SOCIAL SECURITY /MEDICARE 25,999 34,546 36,537 27,969 36,537 43,761 45,003 8,466 23% 79- 650 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 6,755 5,680 2,025 1,568 2,025 4,600 3,400 1,375 68% RECREATION MISCELLANEOUS - - - 500 - - 79- 650 -78 -00 -9009 USE OF RESERVE - 16,835 17,700 5,372 14,364 22,396 17 13,169 (4,531) -26% 79- 650 -78 -00 -9012 SALARY SURVEY - - 15,559 - - - - (15,559) - 100% 79- 650 -78 -00 -9005 MERIT - - 17,482 - - 7,890 14,381 (3,101) -18% TOTAL EXPENSES: RECREATION 620,636 857,876 951,622 725,455 937,213 1,050,640 989,913 38,291 4% TOTAL FUND REVENUES 1,228,053 1,493,498 1,630,642 1,264,569 1,668,513 1,875,337 1,734,798 104,156 6% TOTAL FUND EXPENSES 1,124,002 1,439,703 1,630,642 1,228,054 1,668,513 1,875,337 1,734,798 104,156 6% FUND SURPLUS (DEFICIT) ENDING BALANCE 104,050 53,795 0 36,515 0 - (0) (0) Page 61 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET PARKS & RECREATION A B C D E E -A E -A 2005 -2006 2006 -2007 2007 -2008 YTD As of REVISED DEPT PROPOSED FY ACCOUNT NUMBER DESCRIPTION Actual Actual Budget 01/08 BUDGET REQUEST 08/09 BUDGET $ CHANGE % CHANGE PARKS & RECREATION COMMENTS: 1 Bridge Park will be open a full season 2 Budgeted amount is normal. 07/08 YTD is inflated most likely to miscoding. Looking into it. 3 Increase due to Bridge Park ballfields 4 Anticipate response to gift catalog released in 07/08. 5 Request 3 new employees - Park Operator / MW I / MW II (MWI was granted) 6 Pay out of comp time for 1 or 2 individuals per new policy 7 Recreation survey completed in 07108 8 5 new parks opening 9 For new personnel 10 For new personnel 11 Growth of Holiday Under the Stars and additional downtown decorations 12 Request 1 new employee - Administrative Assistant (This was eliminated) 13 4% increase for teachers and an additional PT assistant 14 New classes 15 Purchase of new AED per legislation 16 Am uncertain of continuance of United Way $$ which was supplementing us. 17 Would like to add the dollars taken out for unforseen costs. 18 A full time MW I was added to the Parks Department. 19 An increase for additional part time help was added. Page 62 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET LIBRARY A B C D E F F -A F -A 8/14/07 6 MONTH ACCOUNT 2005 -2006 2006 -2007 2007 -2008 REVISED YTD As of REVISED DEPT PROPOSED FY % NUMBER DESCRIPTION Actual Actual Budget BUDGET 01/08 BUDGET REQUEST 08/09 BUDGET $ CHANGE CHANGE REVENUES 82- 000 -40 -00 -3992 LIBRARY BOND PER RE TAXES - - - - 874,041 - 467,425 1 467,425 467,425 New 82- 000 -40 -00 -3995 CARRY OVER - BOND EXPAN - - - - - 547,893 - - - 82- 000 -40 -00 -3996 CARRY OVER - BOOK DEV FEES - 102,125 - - - 66,700 186,700 186,700 186,700 82- 000 -40-00 -3997 CARRY OVER - BLDG DEV FEES - 1,557,975 - - - 74,782 171,782 171,782 171,782 82- 000 -40 -00 -3998 CARRY OVER - MEMORIALS - 1,522 - - - - - - - 82- 000 -40 -00 -3999 BEGINNING FUND BALANCE - 5,461,107 325,749 336,372 - 20,273 - - (325,749) -100% 82- 000 -40 -00 -4000 REAL ESTATE TAXES 356,387 386,235 560,702 627,000 597,888 573,258 658,252 658,252 97,550 17% 82- 000-40 -00 -4010 PERSONAL PROPERTY TAX 3,398 3,182 3,360 3,360 3,674 3,360 3,360 3,360 - 0% 82- 000 -40 -00 -4015 TRANS FROM GENERAL FUND 28,000 35,430 - - - - - - - 82- 000 -42 -00 -4211 DEVELOPMENT FEES - BUILDING 99,300 86,300 150,000 150,000 78,275 100,000 100,000 100,000 (50,000) -33% 82- 000 -42 -00 -4215 DEVELOPMENT FEES -BOOKS 99,300 70,385 150,000 150,000 78,275 100,000 100,000 100,000 (50,000) -33% 82- 000 -42 -00 -4260 COPY FEES 1,286 1,379 1,221 1,221 1,745 1,254 2,500 2,500 1,279 105% 82- 000 -42 -00 -4261 LIBRARY SUBSCRIPTION CARDS 10,400 12,904 . 8,500 8,500 12,136 8,797 15,000 15,000 6,500 76% 82- 000 -42 -00 -4286 RENTAL INCOME 1,303 1,836 960 960 2,780 2,040 4,000 4,000 3,040 317% 82- 000 -42 -00 -4287 LIBRARY BLDG RENTAL - - - - 705 195 1,500 1,500 1,500 New 82- 000 -43 -00 -4330 LIBRARY FINES 4,000 5,033 2,808 2,808 5,431 3,784 7,000 7,000 4,192 149% 82- 000 -44 -00 -4432 SALE OF BOOKS 518 973 1,144 1,144 872 1,144 1,000 1,000 (144) -13% 82- 000 -44 -00 -4450 MEMORIALS 1,522 7,097 3,202 3,202 7,849 5,719 4,000 4,000 798 25% 82- 000 -45-00 -4550 GRANTS - - 17,500 17,500 - 17,500 17,500 17,500 - 0% 82- 000 -45 -00 -4560 LIBRARY PER CAPITA GRANT 10,824 13,708 - - - - - - - 82- 000 -46 -00 -4600 INVESTMENT INCOME 15,693 31,546 6,102 6,102 24,041 13,177 2,500 2,500 (3,602) -59% 82- 000 -46 -00 -4601 INVESTMENT INCOME -BLDG 162,968 123,886 - - 7,143 7,143 - - - 82- 000 -48 -00 -4801 LIB BOND PROCEEDS 7,263,881 - TOTAL REVENUES: 8,058,781 7,902,623 1,231,248 1,308,169 1,694,855 1,547,019 1,742,519 1,742,519 511,271 42% EXPENSES 82- 000 -50 -00 -5107 SALARIES- EMPLOYEES 165,445 277,247 471,377 500,000 281,715 500,000 600,000 600,000 128,623 27% 82- 000 -50 -00 -5203 GROUP HEALTH INSURANCE 36,678 44,681 45,717 45,717 32,355 45,717 52,800 52,800 7,083 15% 82- 000 -50 -00 -5204 GROUP LIFE INSURANCE 646 889 - 3,000 413 3,000 3,000 3,000 3,000 Page 63 of 69 4/28/2008 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET LIBRARY A B C D E F F -A F -A 8/14/07 6 MONTH ACCOUNT 2005 -2006 2006 -2007 2007 -2008 REVISED YTD As of REVISED DEPT PROPOSED FY % NUMBER DESCRIPTION Actual Actual Budget BUDGET 01/08 BUDGET REQUEST 08/09 BUDGET $ CHANGE CHANGE LIBRARY EXPENSES CONTINUED 82- 000 -50 -00 -5205 DENTAL & VISION ASSISTANCE 3,014 3,376 4,200 4,200 1,831 4,200 4,200 4,200 - 0% 82- 000 -61 -00 -5322 BONDING 1,014 1,875 1,176 1,176 1,875 2,000 2,000 2,000 824 70% 82- 000 -61 -00 -5323 ATTORNEY 863 - 3,500 3,500 960 3,500 3,000 3,000 (500) -14% 82- 000 -62 -00 -5401 CONTRACT SERVICES 811 2,251 5,000 768 5,000 20,000 20,000 20,000 New 82- 000 -62 -00 -5407 MAINTENANCE - BLDG /JANITORIAL 3,730 5,655 5,000 5,000 4,699 5,000 10,000 10,000 5,000 100% 82- 000 -62 -00 -5410 MAINTENANCE - OFFICE EQUIP 2,992 2,470 5,000 15,298 2,992 15,298 10,000 10,000 5,000 100% 82- 000 -62 -00 -5412 MAINTENANCE - PHOTOCOPIER 411 946 12,680 12,680 174 12,680 10,000 10,000 (2,680) -21% 82- 000 -62 -00 -5435 ELECTRICITY 1,419 547 37,500 37,500 499 37,500 5,000 5,000 (32,500) -87% 82- 000 -62 -00 -5436 TELEPHONE 1,558 2,640 6,000 6,000 4,497 6,000 7,000 7,000 1,000 17% 82- 000 -62 -00 -5437 GAS HEAT - - 50,000 50,000 8,546 50,000 40,000 40,000 (10,000) -20% 82- 000 -64 -00 -5603 SUBSCRIPTIONS 3,140 3,581 - 10,000 3,327 10,000 8,000 8,000 8,000 82- 000 -64 -00 -5604 TRAINING & CONFERENCES 20 60 2,000 2,000 195 2,000 2,000 2,000 - 0% 82- 000 -64-00 -5607 PUBLIC RELATIONS 121 978 2,500 2,500 561 2,500 2,000 2,000 (500) -20% 82- 000 -64 -00 -5616 EMPLOYEE RECOGNITION 723 1,616 2,000 2,000 1,097 2,000 3,000 3,000 1,000 50% 82- 000 -65 -00 -5800 CONTINGENCIES 1,739 16,918 25,000 25,000 7,332 313,026 64,574 64,574 39,574 158% 82- 000 -65-00 -5802 OFFICE SUPPLIES 3,490 5,732 - 10,000 4,357 10,000 10,000 10,000 10,000 82- 000 -65 -00 -5806 LIBRARY SUPPLIES 3,124 6,355 10,000 10,000 5,478 10,000 10,000 10,000 - 0% 82- 000 -65 -00 -5807 CUSTODIAL SUPPLIES 3,072 8,211 9,000 20,000 4,666 20,000 15,000 15,000 6,000 67% 82- 000 -65 -00 -5808 POSTAGE & SHIPPING 843 964 4,000 3,000 783 3,000 2,000 2,000 (2,000) -50% 82- 000 -65 -00 -5810 PUBLISHING & ADVERTISING 586 333 2,000 2,000 60 2,000 2,000 2,000 - 0% 82- 000 -65-00 -5826 MILEAGE 578 512 1,000 1,000 421 1,000 1,000 1,000 - 0% 82- 000 -65 -00 -5832 VIDEOS 2,678 4,830 5,000 5,000 3,049 5,000 5,000 5,000 - 0% 82- 000 -65 -00 -5833 ALARM MONITORING 931 489 3,000 3,000 1,390 3,000 - - (3,000) -100% 82- 000 -65 -00 -5834 LIBRARY PROGRAMMING 6,140 5,541 10,000 10,000 5,193 10,000 10,000 10,000 - 0% 82- 000 -65 -00 -5835 LIBRARY BOARD EXPENSES 75 666 2,000 2,000 295 2,000 2,000 2,000 - 0% 82- 000 -65-00 -5836 BOOKS -ADULT 9,027 9,731 30,000 30,000 16,243 30,000 15,000 15,000 (15,000) -50% 82- 000 -65 -00 -5837 BOOKS - JUVENILE 9,058 11,020 30,000 30,000 18,256 30,000 20,000 20,000 (10,000) -33% 82- 000 -65 -00 -5838 BOOKS -AUDIO 6,415 6,630 10,000 10,000 1,553 10,000 10,000 10,000 - 0% Page 64 of 69 4/28/2008 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET LIBRARY A B C D E F F -A F -A 8/14/07 6 MONTH ACCOUNT 2005 -2006 2006 -2007 2007 -2008 REVISED YTD As of REVISED DEPT PROPOSED FY % NUMBER DESCRIPTION Actual Actual Budget BUDGET 01/08 BUDGET REQUEST 08/09 BUDGET $ CHANGE CHANGE LIBRARY EXPENSES CONT'D 82- 000 -65 -00 -5839 BOOKS - REFERENCE 9,346 10,019 30,000 30,000 8,663 30,000 20,000 20,000 (10,000) -33% 82- 000 -65-00 -5840 BOOKS - DEVELOPMENT FEE 23,782 40,285 150,000 150,000 41,949 100,000 100,000 100,000 (50,000) -33% 82- 000 -65 -00 -5841 MEMORIALS /GIFTS 2,093 7,147 3,202 3,202 1,717 3,202 4,000 4,000 798 25% 82- 000 -65 -00 -5842 BLDG - DEVELOPMENT FEES 46,697 8,233 150,000 150,000 2,043 150,000 100,000 100,000 (50,000) -33% 82- 000 -65 -00 -5843 CD's /Music - - 5,000 5,000 1,946 5,000 5,000 5,000 - 0% 82- 000 -65 -00 -5844 MEETING ROOM - - - - - - 1,500 1,500 1,500 New 82- 000 -66 -00 -6012 2005B LIBRARY BOND - - - 346,145 346,145 346,145 New 82- 000 -66 -00 -6014 2006 LIBRARY BOND - - - 121,300 121,300 121,300 New 82- 000 -72 -00 -6500 IMRF PARTICIPANTS 7,426 10,451 15,641 15,641 8,974 15,641 13,000 13,000 (2,641) -17% 82- 000 -72 -00 -6501 SOCIAL SECURITY /MEDICARE 12,657 21,209 39,755 39,755 21,552 39,755 40,000 40,000 245 1% 82- 000 -75 -00 -7002 COMPUTER EQUIP & SOFT - - 18,000 18,000 5,900 18,000 18,000 18,000 - 0% 82- 000 -75 -00 -7003 AUTOMATION 10,543 32,794 30,000 30,000 13,920 30,000 25,000 25,000 (5,000) -17% 82- 000 -75 -00 -7703 BUILDING EXPANSION 2,281,851 6,240,073 - - 475,936 - - - - 82- 000 -78 -00 -9020 TRANSFER TO DEBT SVC - 874,041 - - - - TOTAL EXPENSES: 2,664,736 6,796,955 1,231,248 1,308,169 1,872,221 1,547,019 1,742,519 1,742,519 511,271 42% TOTAL FUND REVENUES 8,058,781 7,902,623 1,231,248 1,308,169 1,694,855 1,547,019 1,742,519 1,742,519 511,271 42% TOTAL FUND EXPENSES 2,664,736 6,796,955 1,231,248 1,308,169 1,872,221 1,547,019 1,742,519 1,742,519 511,271 42% FUND SURPLUS (DEFICIT) BALANCE 5,394,045 1,105,668 0 - (177,366) 0 - - - LIBRARY COMMENTS: 1 $467,425 is for the library bond payments Page 65 of 69 4/28/2008 UNITED CITY OF YORKVILLE PROPOSED FY 08/09 BUDGET FOX INDUSTRIAL A B C D E E -A E -A ACCOUNT 2005 -2006 2006 -2007 2007 -2008 YTD As of REVISED DEPT PROPOSED FY % NUMBER DESCRIPTION Actual Actual Budget 01/08 BUDGET REQUEST 08109 BUDGET $ CHANGE CHANGE REVENUES 85- 000 -40 -00 -3999 BEGINNING FUND BALANCE 11,817 32,799 50,000 - 87,553 93,924 93,924 43,924 88% 85- 000 -40 -00 -4090 TIF REVENUES 70,997 130,078 75,000 169,251 146,600 77,430 77,430 2,430 3% 85- 000 -46 -00 -4600 INVESTMENT INCOME 3,290 5,375 3,500 3,584 3,500 3,500 3,500 - 0% 85- 000 -49 -00 -4905 TRANSFER FROM MFT FUND 31,190 - - - - - - - TOTAL REVENUES: 117,293 168,252 128,500 172,835 237,653 174,854 174,854 46,354 36% EXPENSES 85- 000 -66 -00 -6021 FOX IND BOND - PRINCIPAL PMT 55,000 60,000 60,000 60,000 60,000 60,000 60,000 - 0% 85- 000 -66 -00 -6022 FOX IND BOND -INT PAYMENT 11,225 20,415 18,015 18,015 18,015 20,555 20,555 2,540 14% 85- 000 -75 -00 -7901 FOX IND NON MFT PAYMENT 233 - - - - - - - 85- 000 -75 -00 -7902 FOX INDUSTRIAL EXPENSES 5,068 - - - - - - - 85- 000 -78 -00 -9007 ADMINISTRATION FEES 1,744 284 375 179 375 375 375 - 0% 85- 000 -78 -00 -9010 RESERVE - FUTURE BOND PYMT - - 50,110 - 159,263 93,924 93,924 43,814 87% TOTAL EXPENSES: 73,269 80,699 128,500 78,194 237,653 174,854 174,854 46,354 36% TOTAL FUND REVENUES 117,293 168,252 128,500 172,835 237,653 174,854 174,854 46,354 36% TOTAL FUND EXPENSES 73,269 80,699 128,500 78,194 237,653 174,854 174,854 46,354 36% FUND SURPLUS (DEFICIT) BALANCE 44,024 87,553 0 94,640 0 - - - Page 66 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08109 BUDGET COUNTRYSIDE TIF A B C D E E -A E -A 2005 -2006 2006 -2007 2007 -2008 YTD As of REVISED DEPT PROPOSED FY % ACCOUNT NUMBER DESCRIPTION Actual Actual Budget 01/08 BUDGET REQUEST 08109 BUDGET $ CHANGE CHANGE REVENUES 87- 000 -40 -00 -3999 BEGINNING FUND BALANCE 3,456,521 3,463,672 3,000,000 - 2,919,125 2,856,390 2,856,390 (143,610) -5% 87- 000 -40 -00 -4090 TIF REVENUES - - - 7,954 3,965 - - - 87- 000 -46 -00 -4600 INVESTMENT INCOME 109,570 98,340 75,000 73,674 75,000 75,000 75,000 - 0% 87- 000 -48 -00 -4801 BOND PROCEEDS _ TOTAL REVENUES: 3,566,092 3,562,012 3,075,000 81,627 2,998,090 2,931,390 2,931,390 (143,610) -5% EXPENSES 87- 000 -66 -00 -6021 BOND - PRINCIPAL PMT - - - 71,434 - - - - 87- 000 -66 -00 -6022 BOND -INT PAYMENT - 142,868 142,868 71,434 142,868 142,868 142,868 - 0% 87- 000 -78 -00 -9007 ADMINISTRATION FEES 825 19 2,500 1,323 2,500 2,500 2,500 - 0% 87- 000 -78 -00 -9010 RESERVE - FUTURE BOND PYMT - 500,000 2,929,632 - 2,852,722 2,786,022 2,786,022 (143,610) -5% TOTAL EXPENSES: 825 642,887 3,075,000 144,191 2,998,090 2,931,390 2,931,390 (143,610) -5% TOTAL FUND REVENUES 3,566,092 3,562,012 3,075,000 81,627 2,998,090 2,931,390 2,931,390 (143,610) -5% TOTAL FUND EXPENSES 825 642,887 3,075,000 144,191 2,998,090 2,931,390 2,931,390 (143,610) -5% FUND SURPLUS (DEFICIT) BALANCE 3,565,267 2,919,125 - (62,563) - - - - Page 67 of 69 UNITED CITY OF YORKVILLE PROPOSED FY 08109 BUDGET DOWNTOWN TIF A B C D E E -A E -A 2007 -2008 YTD As of REVISED DEPT PROPOSED FY ACCOUNT NUMBER DESCRIPTION Budget 01108 BUDGET REQUEST 08 /09 BUDGET $ CHANGE % CHANGE REVENUES 88- 00040 -00 -3999 BEGINNING FUND BALANCE - - - 28,693 28,693 28,693 88- 00040 - 004090 TIF REVENUES - 34,760 26,059 28,000 28,000 28,000 88- 000 -46 -00 -4600 INVESTMENT INCOME - - - - - - TOTAL REVENUES: - 34,760 26,059 56,693 56,693 56,693 EXPENSES 88- 000 -78 -00 -9007 ADMINISTRATION FEES - 6,037 10,000 10,000 10,000 10,000 88- 000 -78 -00 -9010 RESERVE - FUTURE REIMB - - 16,059 46,693 46,693 46,693 TOTAL EXPENSES: - 6,037 26,059 56,693 56,693 56,693 TOTAL FUND REVENUES - 34,760 26,059 56,693 56,693 56,693 TOTAL FUND EXPENSES - 6,037 26,059 56,693 56,693 56,693 FUND SURPLUS (DEFICIT) BALANCE - 28,723 - - - - Page 68 of 69 Revenues Expenses General Fund 12,731,770 13,331,770 MFT 613,440 613,440 Municipal Building 305,705 305,705 Fox Hill SSA 6,376 6,376 Sunflower SSA 15,925 15,925 Police Capital 337,148 337,148 PW Capital 316,000 316,000 Park & Rec Capital 64,948 64,948 City Wide Capital 1,325,000 1,155,000 Sewer Improv - - Water Improv - - Debt Svc 484,524 484,524 Water Ops 14,644,483 14,636,857 Sewer Main 3,674,383 4,022,160 Land Cash 844,489 1,020,000 Park & Rec 1,734,798 1,734,798 Library 1,742,519 1,742,519 Fox Industrial TIF 174,854 174,854 Countryside TIF 2,931,390 2,931,390 Downtown TIF 56,693 56,693 Grand Total 42,004,444 42,950,106 I I I II I I i I I