Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Ordinance 2009-11
i STATE OF ILLINOIS COUNTY OF KENDALL - FILED . STATE OF ILLINOIS ) MAR 2 4 200,9 ss. kfib COUNTY OF KENDALL ) COUNTY CLERK KENDALL COUNTY ORDINANCE NO. 2009- ORDINANCE APPROVING THE REVISION OF 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 considered revision of the budget for the 2008 -2009 Fiscal Year; and WHEREAS, a revised budget was available for examination at the City offices of the UNITED CITY OF YORKVILLE and posted on the city's website; and WHEREAS, the Mayor and City Council of the UNITED CITY OF YORKVILLE deem it in the best interest of the City for the orderly operation thereof to pass and approve the revised 2008 -2009 Fiscal Year Budget submitted on February 21, 2009 at a Special City Council meeting and further revised and presented in this ordinance: NOW, THEREFORE, BE IT ORDAINED by the Mayor and City Council of the United City of Yorkville, revision of the 2008 -2009 Fiscal Budget as presented is hereby adopted for the 2008 -2009 Fiscal Year. Passed by the City Council of the United City of Yorkville, Kendall County, Illinois this \13 day of , A.D. 2009. �i� CPERK i ROBYN SUTCLIFF JOSEPH BESCO n ARDEN JOE PLOCHER WALLY WERDERICH GARY GOLINSKI MARTY MUNNS ROSE SPEARS BOB ALLEN Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this day of M-R R. C-H , A.D. 2009. MAYOR I i i I i �I UNITED CITY OF YORKVILLE 6 MONTH FY 2008 -2009 BUDGET REVISION GENERALFUND 2008 -2009 2008 -2009 2005 -2006 2006 -2007 2007 -2008 Original Revised % DESCRIPTION A ctual Actual Actual Budget Budget $ CHANGE CHANGE Revenues Revenues 15,020,809 14,494,476 12,235,653 12,731,770 10,913,842 (1,817,928) -14% TOTAL REVENUES: 15,020,809 14,494,476 12,235,653 12,731,770 10,913,842 (1,817,928) -14% Expenditures Administration 2,455,366 2,785,245 2,472,040 2,316,703 1,720,367 (596,336) -26% Finance 2,635,915 3,534,973 4,666,816 4,598,950 4,307,487 (291,463) -6% Com Relations - - - 164,319 158,151 (6,168) -4% Engineering 432,818 470,545 430,507 549,097 525,240 (23,857) -4% Police 2,165,111 2,589,749 3,015,178 3,239,524 3,125,952 (113,572) -4% Com Develop 193,088 378,108 541,649 583,704 487,295 (96,409) -17% Streets 2,970,154 1,691,788 3,429,973 573,473 553,237 (20,236) -4% Health & Sanita 598,567 752,421 1,043,849 1,306,000 1,126,000 (180,000) -14% TOTAL EXPENDITURES: 11,451,019 12,202,829 15,600,012 13,331,770 12,003,728 (1,328,042) -10% CHANGE IN FUND BALANCE 3,569,790 2,291,647 (3,364,359) (600,000) (1,089,886) I Page 1 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION GENERALFUND 2008 -2009 2008 -2009 2005 -2006 2006 -2007 2007 -2008 Original November Revised % ACCOUNT NUMBER DESCRIPTION Actual Actual Actual Budget Acluals Budget $ CHANGE CHANGE GENERAL FUND REVENUES 01- 000 -40 -00 -3999 RESERVE FUND BALANCE CARRY OVER FY 06/07 01- 000 -40 -00 -3991 CARRY OVER FY 05/06 01- 000 -40 -00 -3992 LIBRARY BOND PAYBACK - - - 01- 000 -40 -00 -3993 EMPLOY CONTRIB HEALTH REIMB 106,117 55,600 93,425 (12,692) -12% 01- 000 -40 -00 -3994 AMUSEMENT TAX 135,000 111,083 111,083 (23,917) -18% 01- 000 -40 -00 -3995 CIB / CD'S IN BANK - - - - - - 01- 000 -40 -00 -3996 ROAD CONTRIBUTION FEE 973,098 850,661 578,000 01- 000 -40 -00 -3997 IN -TOWN ROAD PROGRAM FUND 3,783,562 2,783,075 - 01- 000 -40 -00 -3998 ROAD FUNDING - MPI 40 - - - - - - 01- 000 -40 -00 -4000 REAL ESTATE TAXES 1,633,808 1,337,599 1,832,180 1,992,991 2,100,005 2,018,496 25,505 1% 01- 000 -40 -00 -4001 TOWN ROAD /BRIDGE TAX 125,171 99,155 128,425 131,000 143,506 131,000 - 0% 01- 000 -40 -00 -4002 FOX HILL LEVY REVENUE - - - - - 01- 000 -40 -00 -4010 PERSONAL PROPERTY TAX 16,203 20,233 18,977 20,000 6,886 20,000 0% 01- 000 -40 -00 -4020 STATE INCOME TAX 679,842 1,040,678 1,053,292 1,008,360 216,446 1,008,360 0% 01- 000 -40 -00 -4030 MUNICIPAL SALES TAX 2,548,784 2,676,261 2,506,434 2,900,000 1,113,763 2,625,000 (275,000) -9% 01- 000 -40 -00 -4032 STATE USE TAX 106,042 145,026 157,093 150,652 52,585 160,000 9,348 6% 01- 000 -40 -00 -4040 MUNICIPAL UTILITY TAX 403,657 463,480 549,535 430,000 270,869 540,000 110,000 26% 01- 000 -40 -00 -4041 UTILITY TAX - NICOR 264,183 232,616 384,088 350,000 244,599 360,000 10,000 3% 01- 000 -40 -00 -4042 UTILITY TAX - CABLE TV 102,791 138,527 172,913 167,000 92,342 180,000 13,000 8% 01- 000 -40 -00 -4043 UTILITYTAX - TELEPHONE 442,253 448,351 504,019 417,000 224,636 550,000 133,000 32% 01- 000 -40 -00 -4050 HOTELTAX 18,894 19,728 22,192 20,000 13,395 20,022 22 0% 0 -41 -00 -4100 LIQUOR LICENSE 24,366 15,691 46,970 32,900 17,826 25,000 (7,900) -24% „00 -41 -00 -4101 OTHER LICENSES 2,700 1,518 4,323 4,200 2,738 3,958 (242) -6% 01- 000 -41 -00 -4110 BUILDING PERMITS 1,373,536 1,278,672 867,869 1,200,000 272,121 481,947 (718,053) -60% 01- 000 -42 -00 -4205 FILING FEES 7,023 9,860 2,561 5,000 1,680 3,624 (1,376) -28% 01- 000 -42 -00 -4206 GARBAGE SURCHARGE 208,455 248,024 577,389 1,200,000 536,572 1,050,000 (150,000) -13% 01- 000 -42 -00 -4208 COLLECTION FEE - YBSD 31,881 32,916 55,916 60,000 66,075 66,000 6,000 10% 01- 000 -42 -00 -4210 DEVELOPMENT FEES 1,229,216 1,153,125 1,366,886 1,475,000 159,635 166,766 (1,308,234) -89% 01- 000 -42 -00 -4211 ENGINEERING CAPITAL FEE 52,400 38,900 31,700 - - - 01- 000 -42 -00 -4281 BEECHER DEPOSITS - - - - - - 01- 000 -42 -00 -4286 BEECHER RENTALS - - - 9,000 840 1,596 (7,404) -82% 01- 000 -43 -00 -4310 TRAFFIC FINES 76,534 88,841 111,271 100,000 79,539 132,000 32,000 32% 01- 000 -43 -00 -4315 REIMBURSE POLICE TRAINING 11,805 - 15,106 15,000 8,040 8,040 (6,960) -46% 01- 000 -43 -00 -4320 ORDINANCE FEES 2,670 2,925 4,235 2,500 4,075 2,280 (220) - 9% 01- 000 -44 -00 -4401 DARE DONATIONS 125 - - 1,250 70 120 (1,130) -90% 01- 000 -44 -00 -4402 ROB ROY CREEK HYDRAULIC STY 22,700 - - - - - 01- 000 -44 -00 -4403 MISCELLANEOUS DONATIONS - 400 480 - - - - 01- 000 -44 -00 -4404 HANGING BASKET DONATIONS 3,820 - 500 1,550 1,550 1,050 210% 01- 000 -44 -00 -4405 RAYMOND SEWER OUTFALL - _ _ - _ 01- 000 -44 -00 -4407 HOLIDAY UNDER THE STARS - 12,500 9,900 12,500 0% 01- 000 -44 -00 -4410 REIMB - FROM OTHER GOVT'S - - 313,375 - - - 01- 000 -44 -00 -4411 REIMB- POLICE PROTECTION 2,502 3,308 4,555 3,300 1,754 3,300 0% 01- 000 -44 -00 -4420 SIDEWALK CONSTRUCTION - - - - - - 01- 000 -44 -00 -4490 MISCELLANEOUS INCOME 85,953 291,836 774,327 15,000 16,779 15,001 1 0% 01- 000 -44 -00 -4499 BAD DEBT RECOVERY - - - - - - - 01- 000 -45 -00 -4504 TRAFFICE SIGNAL REVENUE 8,779 5,000 18,289 18,289 13,289 266% 01- 000 -45 -00 -4505 COPS GRANT - VESTS 5,280 - 3,000 - - (3,000) -100% 01- 000 -45 -00 -4510 COPS GRANT - - r � -45 -00 -4511 POLICE - STATE TOBACCO GRANT 1,540 1,500 1,870 (1,500) - 100% 045 -00 -4521 ICJIA BLOCK GRANT - - _ 01- 000 -45 -00 -4525 GRANTS - BROWNFIELD COM DEV 49,675 - 01- 000 -45 -00 -4540 BEAVER ST DEVELOP GRANT - 222,540 - - - - 01- 000 -46 -00 -4600 INVESTMENT INCOME 120,940 153,890 142,763 65,000 14,891 195,000 130,000 200% 01- 000 -42 -00 -4287 DEVELOPER SIGNS REIM - - 5,000 - 5,000 - 0% Page 2 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION GENERALFUND 2008 -2009 2008 -2009 2005 -2006 2006 -2007 2007 -2008 Original November Revised % ACCOUNT NUM BER DESCRIPTION Actual Actual Actual Budget Actuals Budget $ CHANGE CHANGE GENERAL FUND REVENUES CONTINUED 01- 000 -44 -00 -4412 INSURANCE REIMBURSEMENTS - - 2,000 231 2,000 - 0% TRANSFER FROM FOX INDUS TIF - - 25,680 25,680 100% TRANSFER FROM DOWNTOWN TIF - - - - 25,805 25,805 100% 01- 000 -49 -00 -4915 TRANSFER FROM WATER OPS 200,000 250,000 250,000 125,000 250,000 - 0% 01- 000 -49 -00 -4920 TRANSFER FROM SEWER MAINT. 70,000 70,000 70,000 35,000 70,000 0% 01- 000 -49 -00 -4925 TRANSFER FROM SAN. SEWER IMP 150,000 150,000 150,000 75,000 150,000 0% 01- 000 -49 -00 -4930 TRANSFER FROM WATER IMPROVE 200,000 200,000 200,000 100,000 200,000 - 0% 01- 000 -49 -00 -4935 TRANSFER FROM LAND CASH - 16,000 16,000 8,000 181,000 165,000 1031% 01- 000 -49 -00 -4940 TRANSFER FROM MUNICIPAL BLDG - - - - - TOTAL REVENUES: GENERAL 15,020,809 14,494,476 12,235,653 12,731,770 6,203,191 10,913,842 (1,817,928) -14% I i i � Page 3 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION GENERAL FUND 2008 -2009 2008 -2009 2005 -2006 2006 -2007 2007 -2008 Original November Revised % ACCOUNT N DESCRIPTION Actual Actual Actual Budget Actuals Budget b CHANGE CHANGE ADMINISTRATION EXPENSES 01- 110 -50 -00 -5100 SALARIES - MAYOR 8,095 7,394 9,960 11,310 5,125 11,310 - 0% 01- 110 -50 -00 -5101 SALARIES - CITY CLERK 3,600 4,500 8,525 8,600 4,490 8,980 380 4% 01- 110 -50 -00 -5102 SALARIES - CITY TREASURER 3,635 3,705 5,770 6,410 3,472 6,315 (95) -1% 01- 110 -50 -00 -5103 SALARIES - ALDERMAN 29,405 30,970 38,925 30,970 19,905 39,810 8,840 29% 01- 110 -50 -00 -5104 SALARIES - LIQUOR COMM 500 1,281 1,000 1,000 500 1,000 - 0% 01- 110 -50 -00 -5105 SALARIES - CITY ATTORNEY 11,502 11,503 310 - - - 01- 110 -50 -00 -5106 SALARIES - ADMINISTRATIVE 580,191 715,063 519,417 460,985 277,287 414,113 (46,872) -10% 01- 110 -50 -00 -5115 SALARIES - SPECIAL CENSUS - - - - 17,455 114,384 114,384 100% 01- 110 -50 -00 -5136 SALARIES - PART TIME 50,341 28,909 9,095 5,000 2,053 2,053 (2,947) -59% 01- 110 -50 -00 -5137 SALARIES - OVERTIME 998 3,691 387 500 - - (500) -100% 01- 110 -61 -00 -5300 LEGAL SERVICES 77,265 188,534 311,369 120,000 190,425 250,000 130,000 108% 01- 110 -61 -00 -5301 LEGISLATIVE ATTORNEY - - - 10,000 - 10,000 - 0% 01- 110 -61 -00 -5311 CODIFICATION 5,614 1,822 3,342 3,500 3,071 3,500 0% 01- 110 -61 -00 -5314 BUILDING INSPECTIONS 1,142,685 990,782 721,278 950,000 221,427 374,772 (575,228) -61% 01- 110 -62 -00 -5401 CONTRACTUAL SERVICES 42,005 114,563 59,171 20,000 11,979 20,000 - 0% 01- 110 -62 -00 -5403 SPECIAL CENSUS 67,377 (19) - - 3,758 5,000 5,000 100% 01- 110 -62 -00 -5404 CABLE CONSORTIUM FEE 32,591 39,923 66,562 35,000 (25,246) - (35,000) -100% 01- 110 -62 -00 -5406 OFFICE CLEANING 6,600 7,737 7,599 7,500 4,630 7,500 0% 01- 110 -62 -00 -5410 MAINTENANCE - OFFICE EQUIP 190 129 - 100 88 100 - 0% 01- 110 -62 -00 -5421 WEARING APPAREL 897 28 235 540 - - (540) -100% 0 1 - 110 -62 -00 -5427 FACADE PROGRAM 20,000 - 16,100 - - - - 0 -62 -00 -5436 TELEPHONE 14,174 18,758 20,140 16,000 10,286 11,000 (5,000) -31% 01- 110 -62 -00 -5438 CELLULAR TELEPHONE 1,962 2,654 3,501 2,500 1,699 2,040 (460) -18% 01- 110 -62 -00 -5439 TELEPHONE SYSTEMS MAIN 2,836 3,648 7,199 3,500 1,472 3,000 (500) -14% 01- 110 -64 -00 -5600 DUES 3,758 5,197 9,523 9,000 6,486 9,000 - 0% 01- 110 -64 -00 -5601 ILLINOIS MUNICIPAL LEAGUE DUES 781 900 918 918 957 918 0% 01- 110 -64 -00 -5603 SUBSCRIPTIONS /BOOKS 315 733 263 100 - 100 0% 01- 110 -64 -00 -5604 TRAINING & CONFERENCES 7,325 19,441 6,414 5,875 4,579 5,875 0% 01- 110 -64 -00 -5605 TRAVEL / MEALS / LODGING 14,268 2,931 24,630 17,380 8,718 13,000 (4,380) -25% 01- 110 -64 -00 -5610 TUITION REIMBURSEMENT - - - 6,000 3,574 6,000 0% 01- 110 -64 -00 -5606 PROMOTIONAL /MARKETING EXP'S - 2,941 12,511 - - - 01- 110 -64 -00 -5607 PUBLIC RELATIONS 27,109 8,570 - 100 140 100 0% 01- 110 -64 -00 -5608 HRC SPONSORSHIPS 300 620 1,500 250 250 (1,250) -83% STREET NAMING SPONSORSHIP - - - - - 1,250 1,250 100% 01- 110 -64 -00 -5609 YMCA PARTNERSHIP - - 1,500 - - - - 01- 110 -65 -00 -5800 CONTINGENCIES 46,460 334,355 67,813 20,000 14,773 15,471 (4,529) -23% 01- 110 -65 -00 -5802 OFFICE SUPPLIES 15,995 15,616 12,882 7,000 4,687 7,000 0% 01- 110 -65 -00 -5804 OPERATING SUPPLIES 7,416 14,435 8,742 5,000 4,169 5,000 0% 01- 110 -65 -00 -5808 POSTAGE & SHIPPING 9,761 16,257 16,971 17,000 4,566 14,000 (3,000) -18% 01- 110 -65 -00 -5809 PRINTING & COPYING 14,952 20,525 20,609 9,000 7,375 9,000 0% 01- 110 -65 -00 -5810 PUBLISHING & ADVERTISING 3,866 3,866 1,959 2,000 188 2,000 0% 01- 110 -72 -00 -6500 IMRF PARTICIPANTS 47,499 55,136 40,634 41,173 22,282 38,765 (2,408) -6% 01- 110 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 57,187 62,202 45,185 41,339 24,233 41,278 (61) 0% 01- 110 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE - - 2,020 - - - - 01- 110 -75 -00 -7003 OFFICE EQUIPMENT 1,591 2,876 540 500 - - (500) -100% 01- 110 -78 -00 -9002 NICOR GAS 40,052 25,881 33,391 30,000 10,059 30,543 543 2% 01- 110 -78 -00 -9004 MISCELLANEOUS 54,271 - 272,462 - - - - 01- 110 -78 -00 -9005 MERIT /COLA - 17,188 - 18,439 - - (18,439) -100% ) -78 -00 -9007 APPRECIATION DINNER - - 2,000 1,977 1,977 (23) -1% 01- 110 -78 -00 -9008 VOLUNTEER APPRECIATION DAY 2,235 - - - - 01- 110 -78 -00 -9009 WEBSITE 232 01- 110 -78 -00 -9010 COMMUNITY EVENTS 20,802 01- 110 -78 -00 -9011 TENNIS CRT REFURBISHING 45,823 01- 110 -78 -00 -9012 SALARY SURVEY - 01- 110 -78 -00 -9013 HOLIDAY UNDER THE STARS Page - 4 Of 39 14.096 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION GENERAL FUND 2008 -2009 2008 -2009 2005 -2006 2006 -2007 2007 -2008 Original November Revised % ACCOUNT NUMBER DESCRIPTION Actual Actual Actual Budget Acluals Budget $ CHANGE CHANGE ADMINISTRATION EXPENSES CONTINUED 01- 110 -99 -00 -9970 TRANSFER TO CW CAP FOR LAND 100,000 50,000 100,000 0% 01- 110 -99 -00 -9975 TRANSFER TO CITY WIDE CAPITAL 275,000 137,500 120,000 (155,000) -56% 01- 110 -64 -00 -5611 KENDALL COUNTY PARATRANSIT - - 13,964 - 13, 0% TOTAL EXPENSES: ADMINISTRATION 2,455,366 2,785,245 2,472,040 2,316,703 1,060,388 1,720,367 (596,336) -26% I i Page 5 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION GENERALFUND 2008 -2009 2008 -2009 2005 -2006 2006 -2007 2007 -2008 Original November Revised % ACCOUNT NUMBER DESCRIPTION Actual Actual Actual Budget Actuals Budget $ CHANGE CHANGE FINANCE EXPENSES 01- 120 -50 -00 -5106 SALARIES - ADMINISTRATIVE 325,803 329,120 187,727 328,487 (633) 0% 01- 120 -50 -00 -5136 SALARIES - PART TIME 3,546 - 237 237 237 01- 120 -50 -00 -5137 SALARIES - OVERTIME - - - 750 616 750 - 0% 01- 120 -50 -00 -5202 BENEFITS- UNEMPLOY. COMP. TAX 15,233 20,308 17,466 28,800 2,879 28,800 - 0% 01- 120 -50 -00 -5203 BENEFITS - HEALTH INSURANCE 713,313 753,400 925,178 980,800 577,687 980,000 (800) 0% 01- 120 -50 -00 -5204 BENEFITS - GROUP LIFE INSUR 19,864 22,126 30,707 28,240 3,565 28,240 - 0% 01- 120 -50 -00 -5205 BENEFITS - DENTALNISION ASST 70,910 75,193 91,374 96,495 49,839 83,891 (12,604) -13% 01- 120 -61 -00 -5304 AUDIT FEES & EXPENSES 25,500 49,083 32,000 40,325 30,000 40,700 375 1% 01- 120 -61 -00 -5305 ACCOUNTING ASSISTANCE - 2,785 - - - - - 01- 120 -61 -00 -5308 GASB 34 23,806 - - - - - 01- 120 -61 -00 -5310 EMPLOYEE ASSISTANCE 2,867 3,068 3,000 4,500 1,250 3,500 (1,000) -22% 01- 120 -62 -00 -5400 INSURANCE- LIABILITY & PROPERTY 124,161 137,233 266,737 210,000 3731614 240,757 30,757 15% 01- 120 -62 -00 -5401 CONTRACTUAL SERVICES - - 13,847 15,000 2,470 15,000 - 0% 01- 120 -62 -00 -5410 MAINTENANCE - OFFICE EQUIP - - - 500 1,669 1,700 1,200 240% 01- 120 -62 -00 -5411 MAINTENANCE - COMPUTERS 1,808 1,364 125 1,000 - - (1,000) -100% 01- 120 -62 -00 -5412 MAINTENANCE - PHOTOCOPIERS 19,478 22,530 21,612 28,000 12,487 24,500 (3,500) -13% 01- 120 -62 -00 -5437 ACCTG SYSTEM SERVICE FEE 8,090 9,652 12,972 15,000 2,065 15,000 - 0% 01- 120 -62 -00 -5438 CELLULAR TELEPHONE - - 978 950 586 990 40 4% ! 01- 120 -64 -00 -5603 SUBSCRIPTIONS /BOOKS 128 250 - - (250) -100% 01- 120 -64 -00 -5604 TRAINING & CONFERENCES 3,777 2,000 2,190 2,000 - 0% '0 -64 -00 -5605 TRAVEL / MEALS / LODGING 2,460 3,000 522 1,500 (1,500) -50% .GO -65 -00 -5802 OFFICE SUPPLIES 7,207 4,000 1,105 2,500 (1,500) -38% 01- 120 -65 -00 -5804 OPERATING SUPPLIES 8,136 5,500 1,584 4,500 (1,000) -18% 01- 120 -65 -00 -5808 POSTAGE & SHIPPING - - - 2,500 764 1,000 (1,500) -60% 01- 120 -65 -00 -5844 MARKETING - HOTEL TAX 18,469 19,332 18,632 20,000 10,208 19,406 (594) -3% 01- 120 -72 -00 -6500 IMRF PARTICIPANTS - - 24,986 27,185 14,660 26,277 (908) -3% 01- 120 -72 -00 -6501 SOCIAL SECURITY & MEDICARE - - 26,353 26,048 14,915 26,139 91 0% 01- 120 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 15,709 28,144 27,402 20,000 3,059 6,500 (13,500) -68% 01- 120 -75 -00 -7003 OFFICE EQUIPMENT - - 1,000 1,000 - - (1,000) -100% 01- 120 -78 -00 -9001 CITY TAX REBATE 70 57 - 750 1,005 1,005 255 34% 01- 120 -78 -00 -9003 SALES TAX REBATE 540,687 600,253 376,045 620,000 212,063 500,000 (120,000) -19% 01- 120 -78 -00 -9005 MERIT /COLA - - - 13,165 - - (13,165) -100% 01- 120 -78 -00 -9009 BAD DEBT 508,438 - 5,254 7,540 7,540 100% 01- 120 -78 -00 -9013 AMUSEMENT TAX REBATE - - - 74,250 61,096 61,096 (13,154) -18% 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 75,000 150,000 0% 01- 120 -99 -00 -9930 TRANSFER TO WATER IMPROVE - - 200,000 200,000 100,000 200,000 0% 01- 120 -99 -00 -9935 TRANSFER TO LAND CASH - - 48,245 - - - 01- 120 -99 -00 -9940 TRANSFER TO PARK & REC 755,908 1,015,107 1,161,778 1,224,698 705,429 1,080,348 (144,350) -12% 01- 120 -99 -00 -9941 TRANSFER TO PARK & REC CAP - 150,000 - - - - 01- 120 -99 -00 -9942 TRANSFER TO POLICE CAPITAL - 82,402 125,000 01- 120 -99 -00 -9945 TRANSFER TO GF FOR PD 102,043 64,647 - - - - 01- 120 -99 -00 -9965 TRANSFER TO DEBT SERVICE - 292,859 231,884 425,124 212,562 425,124 0% TOTAL EXPENSES: FINANCE 2,635,915 3,534,973 4,666,816 4,598,950 2,668,108 4,307,487 (291,463) -6% Page 6 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION GENERALFUND 2008 -2009 2008 -2009 2005 -2006 2006 -2007 2007 -2008 Original November Revised % ACCOU NU MBER DESCRIPTION Actual Actual Actual Budget Actuals Budget $ CHANGE CHANGE COMMUNITY RELATIONS 01- 130 -50 -00 -5106 SALARIES - EMPLOYEES - - 59,662 37,438 65,000 5,338 9% 01- 130 -50 -00 -5136 PART TIME SALARIES 9,880 5,103 9,880 - 0% 01- 130 -62 -00 -5401 CONTRACTUAL SERVICES 4,000 2,197 5,000 1,000 25% 01- 130 -64 -00 -5607 PUBLIC RELATIONS 8,000 322 4,000 (4,000) -50% 01- 130 -65 -00 -5810 PUBLISHING & ADVERTISING 15,000 7,430 16,000 1,000 7% 01- 130 -64 -00 -5603 SUBSCRIPTIONS / BOOKS 400 - 400 - 0% 01- 130 -64 -00 -5604 TRAINING & CONFERENCES 1 1,500 50 450 (1,050) -70% 01- 130 -64 -00 -5605 TRAVEL / MEALS / LODGING 1,000 1,000 0% 01- 130 -65 -00 -5802 OFFICE SUPPLIES 750 - 750 - 0% 01- 130 -65 -00 -5808 POSTAGE & SHIPPING 7,520 4,462 10,000 2,480 33% 01- 130 -65 -00 -5809 PRINTING & COPYING 14,000 1,010 8,000 (6,000) -43 % 01- 130 -72 -00 -6500 IMRF PARTICIPANTS 4,747 2,913 4,973 226 5% 01- 130 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 5,474 3,428 5,698 224 4% 01- 130 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE - - - - 01- 130 -78 -00 -9005 MERIT /COLA 2,386 - - (2,386) -100% 01- 130 -78 -00 -9010 COMMUNITY EVENTS 5,000 3,310 6,000 1,000 20% 01- 130 -78 -00 -9013 HOLIDAY UNDER THE STARS'" 25,000 14,528 21,000 (4,000) -16% TOTAL EXPENSES: COMMUNITY RELATIONS 164,319 82,191 158,151 (6,168) 4% - Donations have been collected for this event. Please see line item 01- 000 -44 -00 -4407 under revenues in the amount of $15,000. The total cost to taxpayers for this event is $6,000. The net effect on the community relations budget would show an overall decrease of 13 %. I i I i t I Page 7 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION GENERALFUND 2008 -2009 2008 -2009 2005 -2006 2006 -2007 2007 -2008 Original November Revised % ACCOUNT NUMBER DESCRIPTION Actual Actual Actual Budget Actuals Budget $ CHANGE CHANGE ENGINEERING EXPENSES 01- 150 -50 -00 -5107 SALARIES - EMPLOYEES 254,527 271,075 353,766 406,935 241,327 426,262 19,327 5% 01- 150 -50 -00 -5137 SALARIES - OVERTIME - 800 1,388 1,000 (99) 200 (800) -80% 01- 150 -62 -00 -5401 CONTRACTUAL SERVICES 114,830 94,026 (3,372) 30,000 7,125 15,000 (15,000) -50% 01- 150 -62 -00 -5402 GIS SYSTEM 5,000 294 - - - 01- 150 -62 -00 -5403 FEES 1,000 1,000 1,062 1,000 1,000 1,000 0% 01- 150 -62 -00 -5409 MAINTENANCE - VEHICLES 866 1,482 792 2,000 796 1,000 (1,000) -50% 01- 150 -62 -00 -5410 MAINTENANCE - OFFICE EQUIP 276 164 347 1,000 - 200 (800) -80/a 01- 150 -62 -00 -5411 MAINTENANCE - COMPUTERS 1,587 487 7 2,000 - - (2,000) - 100% 01- 150 -62 -00 -5421 WEARING APPAREL 254 269 1,060 1,400 143 300 (1,100) -79% 01- 150 -62 -00 -5438 CELLULAR TELEPHONE 2,426 2,537 3,542 4,100 1,824 3,400 (700) -17% 01- 150 -64 -00 -5600 DUES 293 339 235 600 - 300 (300) -50% 01- 150 -64 -00 -5604 TRAINING &CONFERENCES 227 552 82 2,000 417 1,000 (1,000) -50% 01- 150 -64 -00 -5605 TRAVEL EXPENSE 1,231 496 880 1,000 186 500 (500) -50% 01- 150 -64 -00 -5608 TUITION REIMBURSEMENT - - - 2,000 1,064 2,000 - 0% 01- 150 -64 -00 -5616 BOOKS & PUBLICATIONS 163 - - 200 - - (200) - 100% 01- 150 -65 -00 -5801 ENGINEERING SUPPLIES 2,520 2,205 1,497 2,500 535 1,500 (1,000) -40% 01- 150 -65 -00 -5802 OFFICE SUPPLIES 2,464 1,563 1,181 2,000 639 2,000 0% 01- 150 -65 -00 -5809 PRINTING & COPYING 1,667 1,853 1,629 2,250 455 1,000 (1,250) -56% 01- 150 -65 -00 -5816 ISWS GROUNDWTR STUDY - - - 1,000 - 1,000 0% 01- 150 -65 -00 -5820 ENGINEERING CAPITAL RESERVE - 39,691 - - - - - 01- 150 -72 -00 -6500 IMRF PARTICIPANTS 20,583 21,193 27,244 32,452 18,794 32,624 172 1% r - 0 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 19,075 20,403 26,759 32,283 18,269 32,454 171 1% L 0 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 3,759 9,224 9,887 4,100 846 3,500 (600) -15% 01- 150 -75 -00 -7003 OFFICE EQUIPMENT 70 892 2,521 1,000 - - (1,000) -100% 01- 150 -78 -00 -9005 MERIT /COLA - - - 16,277 - (16,277) - 100% 01- 150 -78 -00 -9012 SALARY SURVEY - - - - - TOTAL EXPENSES: ENGINEERING 432,818 470,545 430,507 549,097 293,320 525,240 (23,857) -4% Page 8 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION GENERALFUND 2008 -2009 2008 -2009 2005 -2006 2006 -2007 2007 -2008 Original November Revised % ACCOUNT N DESCRIPTION Actual Actual Actual Budget Actuals Budget $ CHANGE CHANGE PUBLIC SAFETY /POLICE DEPT. EXPENSES 01- 210 -50 -00 -5107 SALARIES - EMPLOYEES 637,629 859,924 1,209,876 1,181,811 715,978 1,231,043 49,232 4% 01- 210 -50 -00 -5131 SALARIES - LIEUTJSERGEANTS /CHIEI 561,935 606,857 659,733 705,227 388,294 691,041 (14,186) -2% 01- 210 -50 -00 -5133 SALARIES - COPS 104,490 116,455 - - - - 01- 210 -50 -00 -5134 SALARIES - CROSSING GUARD 17,281 18,824 21,167 26,350 10,742 26,350 0% 01- 210 -50 -00 -5135 SALARIES - POLICE CLERKS 106,758 128,326 168,213 202,535 121,794 213,581 11,046 5% 01- 210 -50 -00 -5136 SALARIES - PART TIME 38,966 21,895 20,933 30,000 14,141 39,000 9,000 30% 01- 210 -50 -00 -5137 SALARIES - OVERTIME 45,872 47,584 61,862 70,000 27,737 60,000 (10,000) -14% 01- 210 -50 -00 -5200 CADET PROGRAM 10,134 18,324 29,640 36,000 15,014 30,000 (6,000) -17% 01- 210 -61 -00 -5300 LEGAL SERVICES 17,726 33,874 3,994 10,000 1,032 4,000 (6,000) -60% 01- 210 -62 -00 -5408 MAINTENANCE - EQUIPMENT 8,000 8,600 11,000 15,000 8,068 14,000 (1,000) -7% 01- 210 -62 -00 -5409 MAINTENANCE - VEHICLES 27,805 35,405 41,818 40,000 16,812 37,000 (3,000) -8% 01- 210 -62 -00 -5410 MAINT- OFFICE EQUIPMENT 2,500 2,625 4,500 5,000 - - (5,000) - 100% 01- 210 -62 -00 -5411 MAINTENANCE - COMPUTERS 2,100 6,000 9,971 10,000 5,272 4,812 (5,188) -52% 01- 210 -62 -00 -5412 MAINTENANCE - K9 - - 567 2,000 285 1,000 (1,000) -50% 01- 210 -62 -00 -5414 WEATHER WARNING SIREN MAINT 3,310 6,520 5,946 6,930 4,348 6,930 0% 01- 210 -62 -00 -5421 WEARING APPAREL 24,773 29,656 26,191 33,000 5,644 18,000 (15,000) -45% 01- 210 -62 -00 -5422 COPS GRANT IV - VESTS 2,634 3,471 5,144 8,000 1,212 3,000 (5,000) -63% 01- 210 -62 -00 -5423 CLASY GRANT - 1,000 - - - 01- 210 -62 -00 -5429 PSYCHOLOGICAL TESTING 1,470 3,250 2,620 2,000 - - (2,000) - 100% 01- 210 -62 -00 -5430 HEALTH SERVICES 2,357 7,527 4,658 6,000 104 500 (5,500) -92% 01- 210 -62 -00 -5431 LABORATORY FEES - - - 2,000 - 500 (1,500) -75% 0 -62 -00 -5432 KENDALL CO. JUVE PROBATION - - - 3,000 2,685 2,685 (315) -11% u- - 10 -62 -00 -5436 TELEPHONE 16,908 17,245 17,558 23,000 11,352 21,500 (1,500) -7% 01- 210 -62 -00 -5438 CELLULAR TELEPHONE 11,993 14,524 16,819 19,420 8,969 17,920 (1,500) -8% 01- 210 -62 -00 -5441 MTD- ALERTS FEE 4,620 5,038 5,534 12,000 2,838 5,838 (6,162) -51% 01- 210 -62 -00 -5442 NEW WORLD LIVE SCAN - - - 8,634 1,180 8,000 (634) -7% 01- 210 -62 -00 -5443 ADMIN ADJUDICATION - - - - 1,875 01- 210 -64 -00 -5600 DUES 1,953 2,500 3,725 4,000 105 2,000 (2,000) -50% 01- 210 -64 -00 -5603 SUBSCRIPTIONS 266 346 93 600 140 350 (250) -42% 01- 210 -64 -00 -5604 TRAINING & CONFERENCE 19,214 16,532 26,334 33,025 9,091 18,025 (15,000) -45% 01- 210 -64 -00 -5605 TRAVEL EXPENSES 10,367 8,735 14,548 12,075 3,559 7,575 (4,500) -37% 01- 210 -64 -00 -5606 COMMUNITY RELATIONS 5,500 11,685 10,000 10,000 1,926 3,250 (6,750) -68% 01- 210 -64 -00 -5607 POLICE COMMISSION 7,600 8,333 15,727 25,000 5,991 10,000 (15,000) -60% 01- 210 -64 -00 -5608 TUITION REIMBURSEMENT 12,522 13,328 6,866 10,000 1,706 4,500 (5,500) -55% 01- 210 -64 -00 -5609 POLICE RECRUIT ACADEMY - 19,340 13,795 - - - 01- 210 -64 -00 -5610 GUN RANGE FEES 625 400 500 1,000 - 500 (500) -50% 01- 210 -64 -00 -5611 SPECIAL RESPONSE TEAM FEE 2,000 3,490 3,722 4,000 3,500 3,500 (500) -13% 01- 210 -64 -00 -5612 NEIGHBORHOOD WATCH - - 328 1,500 1,239 1,500 - 0% 01- 210 -64 -00 -5613 CITIZENS POLICE ACADEMY 2,406 2,500 532 1,775 (725) -29% 01- 210 -64 -00 -5614 CHAPLAIN PROGRAM 36 400 - - (400) -100% 01- 210 -64 -00 -5615 COMPLIANCE CHECKS 497 500 175 500 - 0% 01- 210 -64 -00 -5616 DARE PROGRAM - - 4,765 5,250 - 3,000 (2,250) -43% 01- 210 -65 -00 -5802 OFFICE SUPPLIES 6,499 7,751 8,879 9,000 2,101 4,700 (4,300) -48% 01- 210 -65 -00 -5803 EVIDENCE TECH SUPPLIES - - 1,116 2,500 1,067 1,500 (1,000) -40% 01- 210 -65 -00 -5804 OPERATING SUPPLIES 16,000 20,027 13,162 19,500 7,521 14,500 (5,000) -26% 01- 210 -65 -00 -5808 POSTAGE & SHIPPING 2,662 3,635 3,186 5,250 1,327 3,750 (1,500) -29% 01- 210 -65 -00 -5809 PRINTING & COPYING 4,500 5,484 5,331 7,500 3,343 5,000 (2,500) -33% 01- 210 -65 -00 -5810 PUBLISHING & ADVERTISING 1,000 521 1,537 2,000 301 500 (1,500) -75% 0 -1 0-65-00-5812 GASOLINE 53,503 60,618 80,359 80,000 51,281 100,000 20,000 25% J -65 -00 -5813 AMMUNITION 5,000 5,439 6,482 6,300 - 800 (5,500) -87% 01- 210 -72 -00 -6500 IMRF PARTICIPANTS 8,653 10,344 15,601 18,272 9,430 18,272 0% 01- 210 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 116,940 139,421 165,051 174,135 98,089 174,135 0% 01- 210 -72 -00 -6502 POLICE PENSION 231,124 248,988 275,144 300,000 285,518 300,000 0% 01- 210 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 8,499 8,716 7,500 10,000 4,077 7,000 (3,000) -30% 01- 210 -78 -00 -9004 BIKE PATROL 1,423 1,192 744 1,000 - - (1,000) 100% Page 9 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION GENERALFUND 2008 -2009 2008 -2009 2005 -2006 2006 -2007 2007 -2008 Original November Revised % A NUMBER DESCRIPTION Actual Actual Actual Budget Actuals Budget $ CHANGE CHANGE PUBLIC SAFETY EXPENSES CONTINUED 01- 210 -78 -00 -9005 MERIT /COLA - - 36,310 2,620 (33,690) -93% 01- 210 -78 -00 -9012 SALARY SURVEY - - - - - - TOTAL EXPENSES: PUBLIC SAFETY /POLICE DEPT. 2,165,111 2,589,749 3,015,178 3,239,524 1,857,396 3,125,952 (113,572) -4 % I I Page 10 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION GENERALFUND 2008 -2009 2008 -2009 2005 -2006 2006 -2007 2007 -2008 Original November Revised % ACCOUNT NUMBER DESCRIPTION Actual Actual Actual Budget Acluals Budget $ CHANGE CHANGE COMMUNITY DEVELOPMENT EXPENSES 01- 220 -50 -00 -5107 EMPLOYEE SALARIES 7,665 121,163 301,857 340,955 202,232 355,245 14,290 4% 01- 220 -61 -00 -5300 LEGAL SERVICES 50,291 28,805 17,435 20,000 1,938 4,000 (16,000) -80% 01- 220 -62 -00 -5401 CONTRACTUAL SERVICES 34,669 55,415 89,492 30,000 11,282 11,100 (18,900) -63% 01- 220 -62 -00 -5430 PLANNING CONSULTANT 8,028 37,958 - 50,000 (50,000) - 100% 01- 220 -62 -00 -5432 ECONOMIC DEVELOPMENT 45,000 45,000 45,000 45,000 - 45,000 - 0% 01- 220 -62 -00 -5438 CELLULAR TELEPHONE 307 1,059 978 1,500 726 1,440 (60) -4% 01- 220 -64 -00 -5600 DUES 400 1,753 1,397 1,500 743 1,000 (500) -33% 01- 220 -64 -00 -5604 TRAINING & CONFERENCES 2,284 5,175 7,352 5,000 1,424 1,850 (3,150) -63% 01- 220 -64 -00 -5605 TRAVEL EXPENSE - 2,479 1,376 2,000 154 200 (1,800) -90% 01- 220 -64 -00 -5616 BOOKS & PUBLICATIONS 423 - - - - - 01- 220 -65 -00 -5804 OPERATING SUPPLIES 1,676 5,761 6,873 8,000 2,511 5,000 (3,000) -38% 01- 220 -65 -00 -5809 PRINTING & COPYING 558 521 815 1,500 367 500 (1,000) -67% 01- 220 -65 -00 -5810 PUBLISHING &ADVERTISING 4,660 3,040 972 1,500 14 1,500 0% 01- 220 -65 -00 -5814 BOOKS & MAPS 1,079 2,469 456 2,000 690 500 (1,500) -75% 01- 220 -72 -00 -6500 IMRF PARTICIPANTS - 9,345 23,171 27,126 15,740 27,176 50 0% 01- 220 -72 -00 -6501 SOCIAL SECURITY & MEDICARE - 9,221 23,049 26,985 15,385 27,034 49 0% 01- 220 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 8,966 47,630 9,994 6,000 5,528 5,700 (300) -5% 01- 220 -75 -00 -7003 OFFICE EQUIPMENT 27,081 1,314 11,432 1,000 - 50 (950) -95% 01- 220 -75 -00 -7004 IL TOMORROW GRANT MATCH - - - - - 01- 220 -78 -00 -9005 MERIT /COLA - 13,638 (13,638) - 100% 01- 220 -78 -00 -9012 SALARY SURVEY - - - - - - \L EXPENSES: E PLANNING & DEVELOPMENT 193,088 378,108 541,649 583,704 258,734 487,295 (96,409) -17% i III I Page 11 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION GENERALFUND 2008 -2009 2006 -2009 2005 -2006 2006 -2007 2007 -2008 Original November Revised % ACCOUNT NUMBER DE Actual Actual Actual Budget Actuals Budget $ CHANGE CHANGE STREETS EXPENSES 01- 410 -50 -00 -5107 SALARIES - EMPLOYEE 177,898 222,077 271,449 240,825 146,007 253,530 12,705 5% 01- 410 -50 -00 -5136 SALARIES - PART TIME 1,484 3,096 4,475 10,000 6,752 7,000 (3,000) -30% 01- 410 -50 -00 -5137 SALARIES - OVERTIME 16,815 12,637 32,012 15,000 3,820 11,328 (3,672) -24% 01- 410 -61 -00 -5313 ENGINEERING - IN TOWN ROAD PG 101,814 - 180,651 - - - - 01- 410 -61 -00 -5314 INSPECTIONS & LICENSES 318 509 752 400 595 100 (300) -75% 01- 410 -62 -00 -5401 CONTRACTUAL SERVICES 1,176 2,659 1,370 2,000 593 1,000 (1,000) -50% 01- 410 -62 -00 -5408 MAINTENANCE - EQUIPMENT 10,505 5,803 15,214 9,000 1,604 5,000 (4,000) -44% 01- 410 -62 -00 -5409 MAINTENANCE - VEHICLES 14,913 17,030 11,933 18,000 9,032 10,000 (8,000) -44% 01- 410 -62 -00 -5414 MAINTENANCE - TRAFFIC SIGNALS 11,299 22,645 14,794 15,000 1,203 14,436 (564) -4% 01- 410 -62 -00 -5415 MAINTENANCE - STREET LIGHTS 26,333 15,824, 25,408 20,000 6,816 18,000 (2,000) -1,0% 01- 410 -62 -00 -5416 PROPERTY MAINTENANCE - - - - 21,126 21,000 21,000 100% 01- 410 -62 -00 -5420 MAINTENANCE -STORM SEWER - 2,231 9,508 10,000 151 2,000 (8,000) -80% 01- 410 -62 -00 -5421 WEARING APPAREL 5,157 4,401 4,676 4,150 1,138 2,114 (2,036) -49% 01- 410 -62 -00 -5422 RAYMOND DETENTION BASE - - 1,390 - 3,558 3,825 3,825 100% 01- 410 -62 -00 -5423 RAYMD STORM SEWER OUTFLOW 8,141 530,371 - 339 - - 01- 410 -62 -00 -5434 RENTAL - EQUIPMENT - 1,271 353 1,000 - 1,000 0% 01- 410 -62 -00 -5435 ELECTRICITY 56,246 77,684 100,847 78,120 51,887 73,526 (4,594) -6% 01- 410 -62 -00 -5438 CELLULAR TELEPHONE 2,814 3,197 3,630 3,300 1,479 2,880 (420) -13% 01- 410 -62 -00 -5440 STREET LIGHTING 687 200 2,295 1,000 226 230 (770) -77% 01- 410 -64 -00 -5604 TRAINING & CONFERENCES 4,862 947 4,395 4,500 734 1,000 (3,500) -78% 01- 410 -65 -00 -5804 OPERATING SUPPLIES 19,236 18,166 10,938 15,000 3,603 14,435 (565) -4% '0 -65 -00 -5812 GASOLINE 32,943 36,368 41,627 33,275 19,944 31,332 (1,943) -6% u. X10 -65 -00 -5815 HAND TOOLS 2,507 187 786 1,500 759 1,500 - 0% 01- 410 -65 -00 -5817 GRAVEL 902 2,149 2,147 2,500 1,914 2,155 (345) -14% 01- 410 -72 -00 -6500 IMRF PARTICIPANTS 15,724 18,313 23,282 20,308 11,661 19,395 (913) -4% 01- 410 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 15,008 18,200 23,468 20,962 11,923 19,294 (1,668) -8% 01- 410 -75 -00 -5418 MOSQUITO CONTROL 20,296 28,414 28,414 30,000 29,832 29,832 (168) -1% 01- 410 -75 -00 -5419 MAINTEN SUPPLIES - STREETS - - - - - - - 01- 410 -75 -00 -7004 SAFETY EQUIPMENT 708 1,793 969 1,000 281 500 (500) -50% 01- 410 -75 -00 -7099 GRANDE RES PERIMETER RIDS 440,975 385,659 - - - - - 01- 410 -75 -00 -7100 STREET REHAB PROJECTS 44,118 52,755 3,372 - 01- 410 -75 -00 -7101 IN -TOWN ROAD PROGRAM 1,702,017 451,122 2,036,590 - 43 - 01- 410 -75 -00 -7102 TREE & STUMP REMOVAL 9,510 9,623 13,150 5,000 4,990 5,000 0% 01- 410 -75 -00 -7103 SIDEWALK CONSTRUCTION 570 (316) 1,473 - - - 01- 410 -75 -00 -7104 FOX HILL SSA EXPENSES 7,278 8,625 26,434 01- 410 -75 -00 -7105 FOX ROAD SIDEWALK - - - 01- 410 -75 -00 -7106 ROAD CONTRIB FUND PROJECTS 11,043 37,936 01- 410 -75 -00 -7107 ROAD CONTRIB FUND - RESERVE - - 01- 410 -75 -00 -7108 126/71 IMPROVEMENTS - 01- 410 -75 -00 -7109 TRAFFIC SIGNALS RT. 34 & SYC - 01- 410 -75 -00 -7110 ASPHAULT PAVEMENT - - - - - - - 01- 410 -75 -00 -4404 HANGING BASKETS - 2,442 1,800 2,000 1,825 1,825 (175) -9% 01- 410 -78 -00 -9012 SALARY SURVEY - - - - - - - 01- 410 -78 -00 -9005 MERIT /COLA - - 9,633 (9,633) - 100% 01- 410 -99 -00 -9930 TRANSFER TO WATER IMPROVE 215,000 220,000 - - - - TOTAL EXPENSES: STREETS 2,970,154 1,691,788 3,429,973 573,473 343,835 553,237 (20,236) -4% Page 12 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION GENERALFUND 2008 -2009 2008.2009 2005 -2006 2006 -2007 2007 -2008 Original November Revised % ACCOUNT N DESCRIPTION Actual Actual Actual Budget Acluals Budget $ CHANGE CHANGE HEALTH & SANITATION EXPENSES 01- 540 -62 -00 -5442 GARBAGE SERVICES 591,517 747,186 1,038,809 1,300,000 559,985 1,120,000 (180,000) -14% 01- 540 -62 -00 -5443 LEAF PICKUP 7,050 5,23 5,040 6,0 1,2 6,00 0% TOTAL EXPENSES: HEALTH & SANITATION 598,567 752,421 1,043,849 1,306,000 561,185 1,126,000 (180,000) -14% I SUMMARY TOTAL GENERAL FUND REVENUES 15,020,809 14,494,476 12,235,653 12,731,770 6,203,191 10,913,842 (1,817,928) -14% TOTAL GENERAL FUND EXPENSES 11,451,019 12,202, 1 13,331,77 7,1 25,156 12,003,728 (1,328,042) -1 FUND SURPLUS (DEFICIT) BALANCE 3,569,790 2,291,647 (3,364,359) (600,000) (921,965) (1,089,886) (489,886) 82% GENERAL FUND BALANCE RESERVE 600,000 ' Page 13 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 - 2009 BUDGET REVISION MOTOR FUEL TAX 2008 -2009 2008 -2009 2005 -2006 2006 -2007 2007 -2008 Original November Revised % ACCOUNT NUMBER DESCRIPTION Actual Actual Actual Budget Actuals Budget $ C HANGE CHANGE REVENUES 15- 000 -40 -00 -3999 BEGINNING FUND BALANCE - 505,226 479,294 118,520 - 336,488 217,968 184% 15- 000 -40 -00 -4060 MOTOR FUEL TAX ALLOTMENTS 266,560 307,043 328,650 325,000 133,080 252,500 (72,500) -22% 15- 000 -44 -00 -4490 MISC INCOME - 11,806 42,818 - - - 0% 15- 000 -44 -00 -4401 GAME FARM ROAD DESIGN - - - 157,000 - 157,000 0% 15- 000 -46 -00 -4600 INVESTMENT INCOME 15,528 24,062 22,600 14,000 4,324 6,600 (7,400) -53% TOTAL REVENUES: 282,089 848,137 873,362 614,520 137,404 752,588 138,068 22% EXPENSES 15- 000 -65 -00 -5800 CONTINGENCY 11,936 455 43,032 - - - - 0% 15- 000 -65 -00 -5818 SALT 46,482 63,801 97,754 86,000 86,197 86,000 0% 15- 000 -75 -00 -7007 SIGNS 9,799 9,574 8,751 14,550 9,981 14,550 0% 15- 000 -75 -00 -7008 CRACK FILLING 32,200 18,759 2,084 20,000 23,736 20,000 - 0% 15- 000 -75 -00 -7106 GAME FARM SURVEYING - - 92,862 68,000 99,753 158,800 90,800 134% 15- 000 -75 -00 -7107 GAME FARM ENGINEERING 65,721 34,902 151,208 314,000 - 314,000 - 0% 15- 000 -75 -00 -7110 COLD PATCH 886 3,996 11,459 3,720 528 3,720 0% 15- 000 -75 -00 -7111 HOT PATCH 1,830 6,977 2,136 8,250 - 8,250 0% 15- 000 -75 -00 -7112 VAN EMMON - - - - - - 0% 15- 000 -75 -00 -7113 COUNTRYSIDE PKWY CONST. 201,442 - 8,380 0% 15- 000 -75 -00 -7114 RT. 126 / 71 TRAFFIC SIGNALS - 560 - 0% 15- 000 -75 -00 -7115 PALMER COURT - 0% 15- 000 -75 -00 -7116 WOOD DALE - 0% 15- 000 -75 -00 -7117 FAXON ROAD ROW ACQ 5,915 - 0% 15- 000 -75 -00 -7118 Rt. 34 & SYCAMORE TRAFF SIG 121,113 - 2,517 - 0% 15- 000 -75 -00 -7119 GAME FARM ROW - - 100,000 - 100,000 0% 15- 000 -99 -00 -9960 TRANSFER TO FOX INDUSTRIAL 31,190 - - 0% TOTAL EXPENSES: 200,044 339,906 536,874 614,520 231,092 705,320 90,800 15% TOTAL FUND REVENUES 282,089 848,137 873,362 614,520 137,404 752,588 138,068 22% TOTAL FUND EXPENSES 200,044 339,906 536,874 614,520 23 705,320 90,800 15% FUND SURPLUS (DEFICIT) BALANCE 82,045 508,231 336,488 - (93,688) 47,268 47,268 Page 14 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION MUNICIPAL BUILDING 2008 -2009 2005 -2006 2006 -2007 2007 -2008 Original November 2008 -2009 $ % ACCOUNT NUMBER DESCRIPTION Actual Actual Actual Budget Actuals Revised Budget CHANGE CHANGE REVENUES 16- 000 -40 -00 -3999 BEGINNING FUND BALANCE - (208,136) (276,106) - - (514,524) (514,524) 16- 000 -42 -00 -4211 DEVELOPMENT FEES - BUILDING 85,950 79,350 64,650 100,000 11,700 22,000 (78,000) -78% 16- 000 -42 -00 -4215 BEECHER RENTAL FEE 7,095 12,100 - - 7,000 6,000 6,000 100% 16- 000 -42 -00 -4216 RENTAL FEES 40,000 - - - - - 0% 16- 000 -44 -00 -4400 BEECHER CENTER DONATION - - 25,000 0% 16- 000 -49 -00 -4901 TRANSFER FROM GENERAL FUND 102,043 64,647 - 0% 16- 000 -49 -00 -4902 TRANS FROM LAND ACQUISITION - 13,618 - 0% TOTAL REVENUES: 235,088 (38,421) (186,456) 100,000 18,700 (486,524) (586,524) -587% EXPENSES 16- 000 -62 -00 -5416 GENERAL BLDG & GRNDS 689 1,171 - - - 0% 16- 000 -75 -00 -7008 ENTRY WAY SIGNS - - 257 0% 16- 000 -75 -00 -7200 BLDG IMPROV- PARK & REC 17,379 12,105 - 0% 16- 000 -75 -00 -7202 BLDG IMPROVE - CITY HALL - - - 0% 16- 000 -75 -00 -7203 BLDG IMPROVE - PUBLIC WKS 9,704 8,939 5,079 0% 16- 000 -75 -00 -7204 BLDG MAINT - CITY HALL 15,549 6,497 20,311 0% 16- 000 -75 -00 -7205 BLDG IMPROVEMENTS - LIBRARY 2,548 - - 0% 16- 000 -75 -00 -7206 LANDSCAPING - PUBLIC BLDINGS 2,044 1,678 1,289 0% 16- 000 -75 -00 -7209 BEECHER PARKING LOT 41,120 - 16,208 0% 16- 000 -75 -00 -7210 BLDG IMPROVE - POST OFFICE - 104,873 - - 0% 16- 000 -75 -00 -7211 NEW BUILDINGS - 40,600 (40,600) -100% '90 -78 -00 -9009 USE OF RESERVE - - 0% JO -99 -00 -9901 TRANSFER TO GENERAL FUND - - 182,500 - - - 0% 16- 000 -99 -00 -9965 TRANSFER TO DEBT SERVICE 103,923 102,423 102,423 59,400 29,700 59,400 0% TOTAL EXPENSES: 192,957 237,685 328,068 100,000 29,700 59,400 (40,600) -41% TOTAL FUND REVENUES 235,088 (38,421) (186,456) 100,000 18,700 (486,524) (586,524) -587% TOTAL FUND EXPENSES 192,957 237,685 328,068 100,000 29,700 59,400 (40,600) -41% FUND SURPLUS (DEFICIT) BALANCE 42,131 (276,106) (514,524) - (11,000) (545,924) (545,924) I Page 15 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION FOX HILL SPECIAL SERVICE AREA 2008 -2009 2006 -2007 2007 -2008 2008 -2009 November Revised $ % ACCOUNT NUMBER DESCRIPTION Actual Actual Original Budget Actuals Budget C HANGE CHANGE REVENUES 11- 000 -40 -00 -4002 FOX HILL LEVY REVENUE 18,204 17,872 6,376 6,347 6,376 0% TOTAL REVENUES: 18,204 17,872 6,376 6,347 6,376 0% EXPENSES 11- 000 -65 -00 -5416 FOX HILL SSA EXPENSES 8,625 26,434 14,362 16,140 1 9,892 1 39% TOTAL EXPENSES: 8,625 26,434 14,362 16,140 19,892 39% TOTAL FUND REVENUES 18,204 17,872 6,376 6,347 6,376 0% TOTAL FUND EXPENSES 8,625 26,434 14,362 16,140 19,89 39% FUND SURPLUS (DEFICIT) BALANCE 9,579 (8,563) (7,986) (9,793) (13,516) SSA COMMENTS: 1 Mowing 11,172 Beautification 550 Weeding 340 Mulching 100 Trail Maintenance 6,720 Trimming 385 Monument Repairs - General Maintenance 625 I Page 16 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION SUNFLOWER SPECIAL SERVICE AREA 2006 -2007 2007 -2008 2008 -2009 November 2008 -2009 $ % ACCOUNT NUMBER DESCRIPTION Actual Actual Original Budget Actuals Revised Budget CHANGE CHANGE REVENUES 12- 000 -40 -00 -4002 SUNFLOWER LEVY REVENUE 15,925 15,925 15,925 (15,925) 0 TOTAL REVENUES: 15,925 15,925 15,925 (15,925) 0% EXPENSES 12- 000 -65 -00 -5416 SUNFLOWER MAIN 15,925 - : 13, 15,925 1 (15,925) 0% TOTAL EXPENSES: 15,925 13,868 15,925 (15,925) 0% TOTAL FUND REVENUES - 15,925 15,925 15,925 (15,925) 0% TOTAL FUND EXPENSES 15,925 13,868 1 ( 15,9 2 5) 0% FUND SURPLUS (DEFICIT) BALANCE - - 2,057 - 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 15,925 Page 17 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION POLICE CAPITAL 2008 -2009 2008 -2009 2005 -2006 2006 -2007 2007 -2008 Original November Revised $ % ACCOUNT NUMBER DESCRIPTION Actual Actual Actual Budget Actuals Budget CHANGE CHANGE REVENUES 20- 000 -40 -00 -3999 BEGINNING FUND BALANCE - 165,558 229,374 125,598 - 114,617 (10,981) -9% 20- 000 -42 -00 -4212 DEV FEES - POLICE 195,600 140,850 101,100 200,000 33,300 30,300 (169,700) -85% 20- 000 -44 -00 -4402 K -9 DONATIONS 200 2,977 - 50 2,124 - (50) - 100% 20- 000 -44 -00 -4403 IN CAR VIDEO DONATIONS 8,130 11,150 - 2,000 - 1,751 (249) -12% 20- 000 -44 -00 -4404 DONATIONS 1,500 42 4,295 2,000 - (2,000) - 100% 20- 000 -44 -00 -4405 WEATHER WARNING SIREN 29,231 8,358 - 7,500 - 82,648 75,148 1002% 20- 000 -44 -00 -4431 SALE OF POLICE SQUADS - 950 400 - 480 480 480 0% 20- 000 -44 -00 -4440 SEIZED VEHICLES - - - - - - 0% 20- 000 -44 -00 -4489 RICP DISASTER PLAN GRANT 9,990 0% 20- 000 -44 -00 -4490 MISC INCOME 36,523 - - 0% 20- 000 -49 -00 -4901 TRANSFER - 82,402 125,000 - - - 0% TOTAL REVENUES: 281,174 412,287 460,169 337,148 35,904 229,796 (107,352) -327 EXPENSES 20- 000 -44 -00 -5440 SEIZED VEHICLES - - - - - - 0% 20- 000 -65 -00 -5811 LETHAL /NON- LETHAL WEAPON 6,825 7,000 4,811 10,000 400 400 (9,600) -96% 20- 000 -75 -00 -7001 EQUIPMENT 20,000 36,604 30,026 40,000 1,588 30,000 (10,000) -25% 20- 000 -75 -00 -7002 K -9 EQUIPMENT - 1,242 - 2,500 - 2,000 (500) -20% 20- 000 -75 -00 -7005 VEHICLES 72,385 104,270 70,189 85,000 - 60,000 (25,000) -29% 20- 000 -75 -00 -7006 CAR BUILD OUT 25,621 47,136 62,295 50,000 8,025 18,250 (31,750) -64% 20- 000 -75 -00 -7008 NEW WEATHER WARN SIRENS 10,450 - - 37,000 - 36,498 (502) -1% 20- 000 -75 -00 -7009 RES- WEATHER WARN SIREN 82,648 82,648 0% 20- 000 -75 -00 -7010 NEW WORLD SOFTWARE - 95,583 - - 0% 20- 000 -75 -00 -7011 ARCHITECT FEES - 30,000 (30,000) - 100% 20- 000 -78 -00 -9009 USE OF RESERVE 26,526 - 0% 20- 000 -99 -00 -9965 TRANSFER TO DEBT SERV FD 24,110 - - - - - 0% TOTAL EXPENSES: 185,916 196,252 262,904 337,148 10,012 229,796 (107,352) -32% TOTAL FUND REVENUES 281,174 412,287 460,169 337,148 35,904 229,796 (107,352) -32% TOTAL FUND EXPENSES 185,916 196,252 262,904 337,148 10,012 229,796 (107,352 -32% FUND SURPLUS (DEFICIT) BALANCE 95,258 216,035 197,265 - 25,891 - i t POLICE CAPITAL COMMENTS: I Page 18 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION PUBLIC WORKS CAPITAL 2008 -2009 2005 -2006 2006 -2007 2007 -2008 Original November 2008 -2009 ACCOUNT NUMBER D ESCRIP T I ON Actual Actual Actual Budget Actuals Revised Budget $ CHANGE CHANGE REVENUES 21- 000 -40 -00 -3999 BEGINNING FUND BALANCE - 585,955 520,344 90,000 - 507,295 417,295 464% 21- 000 -42 -00 -4213 DEVELOPMENT FEES - PUBLIC WK: 481,500 344,750 239,900 280,000 77,400 105,000 (175,000) -63% 21- 000 -44 -00 -4430 SALE OF EQUIPMENT 34,114 - 72,316 16,000 8,000 - (16,000) -100% 21- 000 -49 -00 -4915 TRANSFER FROM WATER FUND 50,000 50,000 - - - 0% 21- 000 -49 -00 -4920 TRANSFER FROM SEWER FUND 30,000 30,000 - - - - 0% TOTAL REVENUES: 595,614 1,010,705 832,560 386,000 85,400 612,295 226,295 59% EXPENSES 21- 000 -75 -00 -7001 EQUIPMENT - - - 55,000 6,655 55,000 1 0% 21- 000 -75 -00 -7005 VEHICLES 184,968 286,326 268,429 161,000 38,195 80,000 (81,000) -50% 21- 000 -75 -00 -7015 SKID STEER UPGRADE 3,952 4,500 3,600 5,000 4,399 5,000 0% 21- 000 -75 -00 -7107 TRUCK ACCESSORIES 11,445 5,185 5,587 9,000 1,031 5,000 (4,000) -44% 21- 000 -75 -00 -7130 FACILITY EXPANSION 4,000 7,442 5,149 128,600 325,122 375,000 246,400 192% 21- 000 -78 -00 -9009 USE OF RESERVE 4,800 60,158 - - - - - 0% 21- 000 -99 -00 -9941 TRANSFER TO PARKS CAPITAL - 42,500 - - - 0% TOTAL EXPENSES: 209,165 363,611 325,265 358,600 375,402 520,000 161,400 457 TOTAL FUND REVENUES 595,614 1,010,705 832,560 386,000 85,400 612,295 226,295 59% TOTAL FUND EXPENSES 209,165 3 3 25,265 358, 600 375,4 520,000 161,400 45% - UND SURPLUS (DEFICIT) BALANCE 386,449 647,094 507,295 27,400 (290,002) 92,295 64,895 1 PUBLIC WORKS CAPITAL COMMENTS: 1 Tractor and large ditch mower / enclosed trailer and barricades / safety supplies for street closures Page 19 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION PARKS & RECREATION CAPITAL 2005 -2006 2006 -2007 2007 -2008 2008 -2009 November 2008 -2009 % A NUMBER DESCRIPTION Actual Actual Actual Original Budget Acluals Revised Budget $ CHANGE CHANGE REVENUES 22- 000 -40 -00 -3999 BEGINNING FUND BALANCE - 11,454 106,203 26,948 - 43,375 16,427 61% 22- 000 -42 -00 -4216 PARKS CAPITAL FEE 23,900 17,350 18,800 18,000 3,950 8,000 (10,000) -56% 22- 000 -42 -00 -4217 PARK CAPTIAL DONATIONS 7,000 - - - 8,822 8,822 8,822 100% 22- 000 -44 -00 -4430 SALE OF VEHICLES /EQUIPMENT - - 14,000 20,000 - 20,000 - 0% 22- 000 -49 -00 -4930 TRANSFER FROM GENERAL FD 150,000 - - - 0% 22- 000 -49 -00 -4950 TRANSFER FROM PW CAPITAL - 42,500 - - - 0% TOTAL REVENUES: 30,900 178,804 181,503 64,948 12,772 80,197 15,249 23% EXPENSES 22- 610 -75 -00 -7006 PICK UP TRUCK/DUMP TRUCK 60,020 68,722 21,635 0% 22- 610 -75 -00 -7009 COMPUTER WORKSTATIONS 8,351 - - 0% 22- 610 -75 -00 -7012 RIVERFRONT PLAYGROUND 630 0% 22- 610 -75 -00 -7014 SIGN REPLACEMENTS 4,000 - - 0% 22- 610 -75 -00 -7015 PARKS EQUIPMENT 5,961 13,267 59,975 19,948 8,822 28,770 8,822 44% 22- 610 -75 -00 -7016 COMPUTER SERVER - - 4,729 - - 8,427 8,427 0% 22- 610 -75 -00 -7017 RECREATION EQUIPMENT 6,175 - - - - - 0% 22- 610 -75 -00 -7018 PARK REDEVELOPMENTS - - 51,789 45,000 42, 43,0 1 (2,000) -4% TOTAL EXPENSES: PARKS 85,136 81,989 138,128 64,948 51,095 80,197 15,249 23% TOTAL FUND REVENUES 30,900 178,804 181,503 64,948 12,772 80,197 15,249 23% TOTAL FUND EXPENSES 85,136 81,989 138,128 64,948 51, 80, 15,249 23% "'ND SURPLUS (DEFICIT) BALANCE (54,236) 96,815 43,375 - (38,323) - - I PARKS AND RECREATION CAPITAL COMMENTS: 1 Cobb Park redevelopment i I i I I I I Page 20 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION CITY WIDE CAPITAL 2007 -2008 2008 -2009 November 2008 -2009 % ACCOUNT NUMBER DESCRIPTION Actual Original Budget Acluals Revised Budget $ CHANGE CHANGE REVENUES 23- 000 -40 -00 -3996 ROAD CONTRIBUTION - 800,000 58,000 80,000 2 (80,000) New 23- 000 -42 -00 -4211 ENGINEERING CAPITAL FEE 40,000 10,800 20,000 1 (20,000) New 23- 000 -45 -00 -4500 DOWNTOWN BRWN GRANT 100,000 - 100,000 (100,000) New 23- 000 -49 -00 -4901 TRANSFER FROM GEN FD 375,000 187,500 220,000 (220,000) New TOTAL REVENUES: 1,315,000 256,300 420,000 - New EXPENSES 23- 000 -75 -00 -7005 ENGINEER CAPITAL (VEHICLES) 40,000 - 20,000 1 (20,000) New 23- 000 -75 -00 -7099 PERIMETER RD STUDY 40,000 - - 2 - New 23- 000 -75 -00 -7101 RON CLARK PROPERTY 100,000 100,000 100,000 (100,000) New 23- 000 -75 -00 -7102 MCHUGH ROAD 300,000 162,684 162,684 2 (162,684) New 23- 000 -75 -00 -7103 SIDEWALK REPLACEMENT 15,000 2,229 1,186 (1,186) New j 23- 000 -75 -00 -7104 ROB ROY FALLS SIGNAL 75,000 - - New 23- 000 -75 -00 -7105 BEECHER RD STUDY 100,000 - 2 New 23- 000 -75 -00 -7106 DOWNTOWN BROWNFIELD 100,000 100,000 (100,000) New 23- 000 -75 -00 -7107 COMED BIKE TRAIL 50,000 - New 23- 000 -75 -00 -7108 RAYMOND BASIN 30,000 New 23- 000 -75 -00 -7109 KENNEDY ROAD 90,000 - - 2 New 23- 000 -75 -00 -7110 ASPHUALT PAVEMENT TREAT 50,000 46,606 46,606 (46,606) New 23- 000 -75 -00 -7115 PALMER COURT 65,000 70,841 70,841 (70,841) New 23- 000 -75 -00 -7117 FAXON ROAD ROW 100,000 - - 2 New TOTAL EXPENSES 1,155,000 382,360 501,317 New TOTAL FUND REVENUES 1,315,000 256,300 420,000 New TOTAL FUND EXPENSES 1,155,000 382,360 501,317 New FUND SURPLUS (DEFICIT) BALANCE 160,000 (126,060) (81,317) CITY WIDE CAPITAL COMMENTS: 1 $100' 400 Permits 2 These projects are tied to the road contribution fees collected I Page 21 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION DEBT SERVICE 2008 -2009 2005 -2006 2006 -2007 2007 -2008 2008 -2009 November Revised $ % ACCOUNT NUMBER DE SCRIPTION Actual Actual Actual Original Budget Actuals Budget CHANGE CHANGE REVENUES 42- 000 -40 -00 -3999 BEGINNING FUND BALANCE - - (100,567) - (237,259) (237,259) 42- 000 -44 -00 -4440 RECAPTURE- WATERISEWER 114,554 153,252 24,144 0% 42- 000 -44 -00 -4441 LIBRARY BOND REFERENDUM - - - - - - 0% 42- 000 -49 -00 -4901 TRANSFER FROM GENERAL FUND - 292,859 231,884 425,124 212,562 425,124 0% 42- 000 -49 -00 -4910 TRANSFER FROM POLICE EQUIP CAP 24,110 - - - - - 0% 42- 000 -49 -00 -4925 TRANSFER FROM SANITARY SEWER 646,213 640,041 0% 42- 000 -49 -00 -4930 TRANSFER FROM WATER IMPRV FUND 296,442 443,121 - - - - 0% 42- 000 -49 -00 -4940 TRANSFER FROM MUNICIPAL BLDG 103,923 102,423 102,423 59,400 29,700 59,400 0% TOTAL REVENUES: 1,185,242 1,631,696 233,740 484,524 266,406 247,265 (237,259) 49% EXPENSES 42- 000 -66 -00 -6001 CITY HALL BONDS - PRINCIPAL PMT 50,000 50,000 50,000 59,400 - 59,400 0% 42- 000 -66 -00 -6002 CITY HALL BONDS - INTEREST PMT 53,923 52,423 6,400 - 2,200 - 0% 42- 000 -66 -00 -6003 IRBB - BRUELL STREET INTEREST PYMT 85,435 83,795 - - 0% 42- 000 -66 -00 -6004 IRBB - BRUELL STREET PRINCIPAL PYMT 80,000 80,000 0% 42- 000 -66 -00 -6005 NORTH H2O TOWER INT PYMT 1,912 2,832 0% 42- 000 -66 -00 -6006 NORTH H2O TOWER PRIN PYMNT 23,088 21,795 0% 42- 000 -66 -00 -6007 4.8 MILLION DEBT CERT INT PYMT(WATER) 233,150 233,150 0% 42- 000 -66 -00 -6008 COUNTRYSIDE ALT REV PRINCIPAL PYMT 120,000 125,000 0% 42- 000 -66 -00 -6009 COUNTRYSIDE ALT REV INTEREST PYMT 120,638 118,012 0% 42- 000 -66 -00 -6010 COM ED /HYDRAULIC DEBT CERT. INT PYMT 43,217 41,328 0% 42- 000 -66 -00 -6011 COM ED /HYDRAULIC DEBT CERT. PRINC. 135,000 140,000 0% 42- 000 -66 -00 -6013 LIBRARY BOND 2005B INTEREST - - 0% 1 00 -66 -00 -6015 LIBRARY BOND 2006 INTEREST 0% JO -66 -00 -6016 ROB ROY CREEK BOND 0% 42- 000 -66 -00 -6041 IEPA DRINKING WTR PROJ L17 -1563 0% 42- 000 -66 -00 -6042 IEPA DRINK WTR PROJ L17 -1563 INT - 0% 42- 000 -66 -00 -6045 LOAN PYMT SSES IEPA PRINCIPAL 31,275 0% 42- 000 -66 -00 -6049 SANITARY SIPHON L17- 115300 INTEREST 8,301 0% 42- 000 -66 -00 -6050 SANITARY SIPHON L17- 115300 PRINCIPAL 38,980 (596) 0% 42- 000 -66 -00 -6054 LOAN PYMT POLICE SQUAD CAR 24,037 - 0% 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 PRIN( - - 0% 42- 000 -66 -00 -6056 Refunding 2006 Interest 0% 42- 000 -66 -00 -6057 Refunding 2006 A Principal 0% 42- 000 -66 -00 -6058 $2.8M North Water Tower 2002 Issue 0% 42- 000 -66 -00 -6059 2007 A GO REFUND 02, 02A, 03 - - - - - - 0% 42- 000 -66 -00 -6070 $650K ROAD IMPROVEMENT FROG INT. 14,273 26,070 22,820 29,745 9,873 19,745 (10,000) -34% 42- 000 -66 -00 -6071 $650K ROAD IMPROVEMENT FROG PRINC 50,000 65,000 75,000 75,000 - 85,000 10,000 13% 42- 000 -66 -00 -6072 2 MILLION ALT REVENUE (B.2 & B.3) INT. 29,800 234,139 - - - - 0% 42- 000 -66 -00 -6073 2 MILLION ALT REVENUE (B.2 & B.3) PRINC - - - - - - 0% 42- 000 -66 -00 -6074 $3.825 MILLION IN TOWN ROAD - INT. 183,870 156,779 160,379 75,189 150,379. (10,000) -6% 42- 000 -66 -00 -6075 $3.825 MILLION IN TOWN ROAD - PRINC - 160, 1 - 17 10,000 6% TOTAL EXPENSES: 1,210,501 1,603,445 470,999 484,524 87,262 484,524 - 0% TOTAL FUND REVENUES 1,185,242 1,631,696 233,740 484,524 266,406 247,265 (237,259) -49% TOTAL FUND EXPENSES 1,210,501 1,603,445 470,999 484,524 87,262 484,524 0% FUND SURPLUS (DEFICIT) BALANCE (25,259) 28,251 (237,259) - 179,144 (237,259) (237,259) DEBT SERVICE COMMENTS: ALL WATER / SEWER / LIBRARY BOND PAYMENTS MOVED TO THEIR ORIGINATING DEPARTMENT'S OPERATING BUDGET Page 22 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION WATER IMPROVEMENTS AND OPERATIONS 2005 -2006 2006 -2007 2007 -2008 2008 -2009 Original November 2008 -2009 % ACCOUNT N UMBER DESCRIPTION Actual Actual Actual Budget Actuals Revised Budget $ CHANGE CHANGE REVENUES 51- 100 -40 -00 -3999 BEGINNING FUND BALANCE 441,462 600,497 - 296,858 - (296,858) -100% 51- 100 -42 -00 -4240 BULK WATER SALES 11,973 11,833 16,899 10,000 4,405 5,000 (5,000) -50% 51- 100 -42 -00 -4241 WATER SALES 1,222,781 1,324,777 1,604,884 1,450,000 926,711 1,500,000 50,000 3% 51- 100 -42 -00 -4242 WATER METER SALES 291,498 418,028 269,566 200,000 61,312 100,000 (100,000) -50% 51- 100 -42 -00 -4243 LEASE REVENUE - H2O TOWER 22,415 23,287 28,680 31,000 16,354 31,000 0% 51- 100 -44 -00 -4490 MISCELLANEOUS INCOME 290 488 498,257 - 775 - 0% 51- 100 -46- 00.4600 INVESTMENT INCOME 25,069 74,789 85,606 35,000 14,718 27,500 (7,500) -21% TOTAL OPERATING REVENUES: 2,015,487 2,453,699 2,503,892 2,022,858 1,024,275 1,663,500 (359,358) -18% 51- 200 -40 -00 -3999 BEGINNING FUND BALANCE (417,093) (52,217) - 527,625 - (164,225 (691,850) -131% 51- 200 -42 -00 -4220 CONNECTION FEES 1,537,680 1,319,125 938,120 532,000 272,180 532,000 0% 51- 200 -42 -00 -4230 MPI CONNECTION FEE RECOV - - - 425,600 - 425,600 0% 51- 200 -42 -00 -4240 AUTUMN CREEK CONN RECO - - 106,400 106,400 0% 51- 200 -42 -00 -4221 SW WTR MAIN PROJECT REV 35,958 515 - 10,800,000 (10,800,000) -100% 51- 200 -42 -00 -4222 USGS SHALLOW WATER REV - - 96,000 - - 0% 51- 200 -46 -00 -4600 INVESTMENT INCOME 71,127 44,232 30,379 30,000 7,906 (30,000) - 100% 51- 200 -48 -00 -4800 LOAN PROCEEDS CONTRACT B.1 - 1,402,853 - - - 0% 51- 200 -48 -00 -4801 ]EPA LOAN CONTRACT B PROC 2,046,893 - - 00/ 51- 200 -49 -00 -4901 TRANSFER FROM GENERAL FD 215,000 220,000 200,000 200,000 100,000 200,000 0% 51- 200 -49 -00 -4915 TRANSFER FROM WATER FUND - - - - - 0% TOTAL IMPROVEMENTS REVENUES: 3,489,565 2,934,508 1,264,499 12,621,625 380,086 1,099,775 (11,521,850) -91% TOTAL REVENUES: 5,505,052 5,388,207 3,768,391 14,644,483 1,404,361 2,763,275 (11,881,208) -100% OPERATIONS EXPENSES: 51- 100 -50 -00 -5107 SALARIES - EMPLOYEE 250,525 272,639 337,316 330,849 183,307 342,698 11,849 4% 1 00 -50 -00 -5136 SALARIES -PART TIME 5,216 2,766 3,413 5,000 3,582 3,500 (1,500) -30% 00 -50 -00 -5137 SALARIES - OVERTIME 38,898 42,723 30,020 35,000 8,553 30,000 (5,000) -14% 51- 100 -61 -00 -5300 LEGAL SERVICES 338 - 65 2,000 - 2,000 0% 51- 100 -61 -00 -5303 JULIE SERVICE 8,494 9,975 9,029 11,000 2,315 5,500 (5,500) -50% 51- 100 -62 -00 -5401 CONTRACTUAL SERVICES 4,227 4,925 9,454 7,500 8,803 10,000 2,500 33% 51- 100 -62 -00 -5407 TREATMENT FACILITIES O & M 73,749 101,895 203,597 220,000 113,022 220,000 2 - 0% 51- 100 -62 -00 -5408 MAINTENANCE - EQUIPMENT 1,941 7,137 1,944 7,500 2,842 7,500 0% 51- 100 -62 -00 -5409 MAINTENANCE - VEHICLES 1,109 2,072 2,506 8,000 1,457 8,000 0% 51- 100 -62 -00 -5411 MAINTENANCE - COMPUTERS 132 150 791 500 - 500 0% 51- 100 -62 -00 -5413 MAINTENANCE - CONTROL SYS 1,654 2,073 646 - - - 0% 51- 100 -62 -00 -5421 WEARING APPAREL 2,451 4,499 4,741 4,500 1,253 4,500 0% 51- 100 -62 -00 -5422 WATER TOWER PAINTING 219,870 - - 335,000 169,063 270,000 (65,000) -19% 51- 100 -62 -00 -5434 RENTAL - EQUIPMENT - 240 - 2,000 233 2,000 0% 51- 100 -62 -00 -5435 ELECTRICITY 116,401 121,844 307,101 275,000 153,195 275,000 0% 51- 100 -62 -00 -5436 TELEPHONE 16,126 35,764 19,467 22,000 10,278 22,000 0% 51- 100 -62 -00 -5438 CELLULAR TELEPHONE 3,930 3,733 4,273 3,300 2,072 3,300 0% 51- 000 -62 -00 -5439 LEAK DETECTION SURVEY - - - 18,000 - - (18,000) -100% 51- 100 -64 -00 -5600 DUES 770 1,161 1,064 1,000 785 1,000 0% 51- 100 -64 -00 -5603 SUBSCRIPTIONS 164 21 141 250 46 250 0% 51- 100 -64 -00 -5604 TRAINING & CONFERENCES 2,741 2,514 1,198 1,900 1,063 1,900 3 0% 51- 100 -64 -00 -5605 TRAVEL / MEALS / LODGING 945 1,321 2,470 4,000 786 3,000 (1,000) -25% 51- 100 -65 -00 -5804 OPERATING SUPPLIES 41,750 44,423 38,746 45,000 14,159 45,000 0% 51- 100 -65 -00 -5808 POSTAGE & SHIPPING 14,002 13,935 16,710 18,000 9,634 18,000 0% 51- 100 -65 -00 -5809 PRINTING & COPYING 9,610 9,981 12,664 13,000 1,710 13,000 0% 51- 100.65 -00 -5810 PUBLISHING & ADVERTISING 150 1,137 286 1,200 37 1,200 0% 51- 100 -65 -00 -5812 GASOLINE 21,296 31,628 38,594 38,500 20,217 35,891 (2,609) -7% 51- 100 -65 -00 -5815 HAND TOOLS 20 38 1,231 1,000 - 1,000 0% 51- 100 -65 -00 -5817 GRAVEL 2,256 3,248 2,036 4,000 445 4,000 0% 51- 100 -65 -00 -5820 CHEMICALS 18,098 51,474 - - - _ - 00/ 51- 100 -65 -00 -5822 WATER SAMPLES 21,412 18,592 10,459 14,000 10,100 18,000 4,000 29% 51- 000 -66.00 -8200 INTEREST EXPENSE - (30,050) 329,223 - - - - 0% 1 00 -72 -00 -6500 IMRF PARTICIPANTS 23,343 26,570 28,165 29,000 14,933 28,362 (638) -2% J0 -72 -00 -6501 SOCIAL SECURITY & MEDICARE 23,026 26,725 28,573 29,229 15,048 28,779 (450) -2% 51- 100 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 2,570 2,311 1,143 - 1,320 1,320 1,320 100% 51- 100 -75 -00 -7004 SAFETY EQUIPMENT 2,385 1,000 787 1,000 399 1,000 - 0% 51- 100 -75 -00 -7506 METER READERS 7,177 7,219 13,005 12,000 2,770 9,000 (3,000) -25% Page 23 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION WATER IMPROVEMENTS AND OPERATIONS 2005 -2006 2006 -2007 2007 -2008 2008 -2009 Original November 2008 -2009 % ACCOUNT NUMBER DESCRIP Actual Actual Actual Budget Actuats Revised Budget $ C HANGE CHANGE OPERATIONS EXPENSES CONTINUED 51- 100 -75 -00 -7507 HYDRANT REPLACEMENT 1,976 - 9,169 6,500 - 2,500 (4,000) -62% 51- 100 -75 -00 -7508 METERS 8 PARTS 285,457 252,008 189,452 280,000 68,230 178,680 4 (101,320) -36% 51- 000 -75 -00 -7509 ELECTRICITY MONITOR - - - 12,000 - - (12,000) - 100% 51- 100 -78 -00 -9005 REFUND 1,500 390 1,500 0% 51- 100 -62 -00 -5422 WATER TOWER PAINTING _ _ _ 0% 51- 100 -78 -00 -9006 MERIT - 13,234 - (13,234) -100% 51- 100 -78 -00 -9009 USE OF RESERVE 65,805 1,536 1,536 0% 51- 000 -78 -00 -9012 SALARY SURVEY - _ Doi 51- 100 -99 -00 -9901 TRANSFER TO GENERAL FUND 200,000 250,000 250,000 250,000 125,000 (250,000) -100% 51- 100 -99 -00 -9950 TRANSFER TO PW EQUIP CAP 50,000 5 0,000 - - - 0% TOTAL OPERATIONS EXPENSES: 1,474,211 1,377,691 1,975,286 2,064,998 947,046 1,601,416 (463,582) -22% IMPROVEMENT EXPENSES: 51- 200 -61 -00 -5300 LEGAL SERVICES 3,153 428 4,000 - 4,000 0% 51- 200 -61 -00 -5301 ENGINEERING - GENERAL SVCS 14,636 20,000 4,967 20,000 - 20,000 0% 51- 200 -61 -00 -5400 RADIUM COMP PROJICNT B.2 & 3 1,001,893 265,993 3,023 - 274 - 0 %, 51- 200 -61 -00 -5401 ENG - RADIUMICNT B.2 & B.3 1,228,007 270,953 41,835 598 0% 51- 200 -61 -00 -5402 ENG -SW H2O PROJ -F - 233,296 - - 0% 51- 200 -61 -00 -5405 PROF SVCICONTRACT B.2 & 3 31,686 15,830 0% 51- 200 -61 -00 -5407 CONTRACT 131 CONSRUCTION - 1,211,358 0 %, 51- 200 -61 -00 -5408 CENTRAL ZONE WATER IMP 127,272 45,210 0% 51- 200 -61 -00 -5410 ENGINEERING - CENTRAL ZONE 33,072 11,207 poi 51- 200 -61 -00 -5414 CONTRACT D SCADA SYSTEM 5,261 - Doi 51- 200 -61 -00 -5415 USGS GROUNDWATER STUDY 40,290 8,000 - 0% 51- 200 -61 -00 -5416 USGS GRNDWTR COUNTYWIDE 15,082 13,828 13,128 0% 70 -61 -00 -5417 USGS GRDWTR SHALLOW WTR 65,923 45,491 8,328 0% 00 -61 -00 -5418 ENG TOWER LANE REHAB H.1 - - 18,962 0% 51- 200 -61 -00 -5419 ENG WELL 4 REHAB H.1 136,409 - 0 %, 51- 200 -61 -00 -5421 WELL 4 CONSTRUCTION - 9,670 - 0% 51- 200 -62 -00 -5460 MPI RECOVERY 425,600 - 425,600 0% 51- 200 -62 -00 -5461 AUTUMN CREEK RECOVERY 106,400 106,400 0% 51- 200 -62 -00 -5462 FOX HILL WATERMAIN RECAPTURE 410,000 - - (410,000) -100% 51- 200 -62 -00 -5463 KENDALLWOOD ESTATES REIMB - - - 96,902 0% 51- 200 -65 -00 -5421 GIS SYSTEM 11,642 8,465 - 0% 51- 200 -65 -00 -5800 CONTINGENCY 23,388 - 113,123 - - - 0% 51- 200 -66 -00 -6007 RADIUM COMPLIANCE BOND - - 33,150 33,150 33,150 0% 51- 200 -66 -00 -6041 IEPA DRINKING WATER PRINCIPAL 56,528 28,974 56,528 0% 51- 200 -66 -00 -6042 ]EPA DRINKING WATER INTEREST 52,708 16,906 52,708 0% 51- 200 -66 -00 -6056 2006A REFUNDING WTR INTEREST BD 5,100 46,053 5,100 0% 51- 200 -66 -00 -6057 2006A REFUNDING WTR PRINCIPAL BD 97,007 - 97,007 0% 51- 200 -66 -00 -6058 NORTH WTR TOWER 2002 ISSUE BD 60,000 60,000 60,000 0% 51- 200 -66 -00 -6059 2007A REFUNDING WTR BOND 135,066 62,533 135,066 0% 51- 200 -66 -00 -6072 $2101 ALT REV WATER INTEREST BOND 91,300 43,150 91,300 0% 51- 200 -66 -00 -6073 $21A ALT REV WATER PRINCIPAL BOND - 75,000 - 75,000 0% 51- 200 -75 -00 -7503 SOUTHWEST WATER MAIN PROJ 24,800 10,800,000 - (10,800,000) -100% 51- 200 -75 -00 -7504 NORTH WATER TOWER 234,942 4,418 0% 51- 200 -75 -00 -7507 OVERSIZING - KYLYN'S CROSSING 38,877 - - 0% 51- 200 -75 -00 -7509 SCADA System 17,360 197,741 19,754 0% 51- 200 -75 -00 -7520 SW Interceptor - 184,681 11,493 0% 51- 200 -75.00 -7520 WATERMAIN PROJECTS - _ Ooh 51- 200 -75.00 -7522 IN TOWN ROAD PROGRAM WTR PROJ - - 102,004 - 5,305 0% 51- 200 -99 -00 -9901 TRANSFER TO GENERAL FUND 200,000 200,000 419,947 200,000 100,000 (200,000) -100% 51- 200 -99 -00 -9965 TRANSFER TO DEBT FUND 296,442 443,121 584,555 - - - 0% TOTAL IMPROVEMENT EXPENSES: 3,413,724 2,995,339 1,650,717 12,571,859 515,009 1,161,859 (11,410,000) -91% %L EXPENSES: 4,887,935 4,373,030 3,626,003 14,636,857 1,462,055 2,763,275 (11,873,582) -81% TOTAL FUND REVENUES 5,505,052 5,388,207 3,768,391 14,644,483 1,404,361 2,763,275 (11,881,208) -100% TOTAL FUND EXPENSES 4,887,935 4,373,030 3,6 14,636,857 1,462,055 2,763,275 (11, 8 7 3,582) -100% FUND SURPLUS (DEFICIT) BALANCE 617,118 1,015,177 142,389 7,626 (57,694) (0) (7,626) Page 24 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION WATER IMPROVEMENTS AND OPERATIONS 2005 -2006 2006 -2007 2007 -2008 2008 -2009 Original November 2008 -2009 % A NUMBER DESCRIPTION Actual Actual Actual Budget Actuals Revised Budget $ CHANGE CHANGE WATER COMMENTS: 2 Rising cost of salt and chemicals - producing more water 3 CEU classes for all license holders / class for MW 1 for license / 1/3 cost for Director 4 $75,000 for more fixed base radio read conversion / 3,000 hydrant Rushers i II I i I I � Page 25 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION SEWER MAINTENANCE AND IMPROVEMENTS 2008 -2009 2008-2009 'COUNT 2005 -2006 2006 -2007 2007 -2008 Original November Revised % NUMBER DE SCRIPT ION Actual Actual Actual Budget Actuals Budget $ CHANGE CHANGE REVENUES 52- 100 -40 -00 -3999 BEGINNING FUND BALANCE 327,526 657,374 - 309,383 (309,383) - 100% 52- 100 -42 -00 -4240 LIFT STATION INCOME - 19,097 10,101 - - - 0% 52- 100 -42 -00 -4250 SEWER MAINTENANCE FEES 478,385 576,524 668,132 500,000 354,716 500,000 1 0% 52- 100 -42 -00 -4251 SEWER CONNECTION FEES 180,600 142,660 177,188 200,000 64,150 200,000 2 0% 52- 100 -46 -00 -4600 INVESTMENT INCOME 25,154 74,824 1,310,042 35,000 14,718 22,80 (12,200) - 35% TOTAL MAINTENANCE REVENUES: 1,011,665 1,470,479 2,165,463 1,044,383 433,584 722,800 (321,583) -31% IMPROVEMENT REVENUES: 52- 200 -40 -00 -3999 BEGINNING FUND BALANCE 3,521,714 3,314,989 - - - 2,435,879 2,435,879 0% 52- 200 -42 -00 -4220 CONNECTION FEES 1,281,300 1,033,136 731,850 800,000 203,738 62,350 (737,650) -92% 52- 200 -42 -00 -4221 RIVER CROSSING FEES 6,576 1,818 526 - 151 - 0% 52- 200 -42 -00 -4229 NORTH BRANCH #2 (DEV REV) - - - 1,650,000 - - (1,650,000) -100% 52- 200 -46 -00 -4600 INVESTMENT INCOME 243,928 158,809 28,621 30,000 5,579 9,170 (20,830) -69% 52- 200 -48 -00 -4803 ROB ROY CREEK REVENUE 12,150,313 360,755 - - - - 0% 52- 200 -48 -00 -4804 SWEST SERVICE AREA INTERCPT 253,662 56,181 - 0% 52- 200 -48 -00 -4805 COUNTRYSIDE INTERCEPTOR - 1,215,401 (87) - - - 0% 52- 200 -49 -00 -4901 TRANSFER FROM GENERAL FUND 150,000 1 50,000 1 150,000 75,000 150,000 - 0% TOTAL IMPROVEMENT REVENUES: 17,607,493 6,291,089 910,909 2,630,000 284,468 2,657,399 27,399 1% TOTAL REVENUES: 18,619,158 7,761,568 3,076,372 3,674,383 718,052 3,380,199 (294,184) -8% MAINTENANCE EXPENSES: 52- 100 -50 -00 -5108 SALARIES- REGULAR 108,174 117,603 173,630 131,000 88,608 145,944 3 14,944 11% 52- 100 -50 -00 -5136 PART TIME 2,300 3,622 340 - - - - 0% - ?- 100 -50 -00 -5137 SALARIES - OVERTIME 3,060 3,300 3,846 8,000 2,716 8,000 0% !- 100 -62 -00 -5401 CONTRACTUAL SERVICES 4,090 895 3,543 6,500 1,570 6,500 4 0% 52- 100 -62 -00 -5408 MAINTENANCE - EQUIPMENT 5,112 3,606 3,044 5,000 69 5,000 0% 52- 100 -62 -00 -5409 MAINTENANCE- VEHICLES 668 2,112 2,187 4,000 416 4,000 0% 52- 100 -62 -00 -5419 MAINTENANCE- SANITARY SEWER 11,877 4,420 5,201 20,000 1,302 15,000 (5,000) -25% 52- 100 -62 -00 -5421 WEARING APPAREL 3,398 4,234 3,059 2,500 1,061 2,500 0% 52- 100 -62 -00 -5422 LIFT STATION MAINTENANCE 23,232 11,626 13,822 25,000 11,882 25,000 0% 52- 100 -62 -00 -5434 RENTAL - EQUIPMENT - - - 1,000 - 1,000 0% 52- 100 -62 -00 -5435 ELECTRICITY 33,628 78,450 15,619 75,000 11,995 75,000 0% 52- 100 -62 -00 -5438 CELLULAR TELEPHONE 2,328 3,614 2,180 2,500 800 2,500 - 0% 52- 100 -64 -00 -5604 TRAINING & CONFERENCES 526 40 650 1,000 733 500 5 (500) -50% 52- 100 -64 -00 -5605 TRAVEL / MEALS / LODGING 849 779 466 2,000 - 500 (1,500) -75% 52- 100 -65 -00 -5800 CONTINGENCIES - - - - - - 0% 52- 100 -65 -00 -5802 OFFICE SUPPLIES 2,179 2,329 1,510 2,500 351 2,500 0% 52- 100 -65 -00 -5804 OPERATING SUPPLIES 53 - - - - - 0% 52- 100 -65 -00 -5805 SHOP SUPPLIES 1,457 1,933 1,649 2,500 819 2,500 - 0% 52- 100 -65 -00 -5812 GASOLINE 15,735 20,977 39,739 26,500 19,899 34,500 8,000 30% 52- 100 -65 -00 -5815 HAND TOOLS 415 - 694 1,000 - 500 (500) -50% 52- 100 -65 -00 -5817 GRAVEL 1,216 - 874 2,000 1,000 (1,000) -50% 52- 000 -65 -00 -5823 SEWER CHEMICALS 2,327 2,783 - - - 0% 52- 000 -66 -00 -8200 INTEREST EXPENSE - (175,119) 738,314 - - - - 0% 52- 100 -72 -00 -6500 IMRF PARTICIPANTS 8,999 9,613 10,938 11,034 7,006 11,715 681 6% 52- 100 -72 -00 -6501 SOCIAL SECURITY 8, MEDICARE 8,672 9,537 10,996 10,977 6,900 11,777 800 7% 52- 100 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 443 976 521 2,000 - 1,000 (1,000) -50% 52- 100 -75 -00 -7003 OFFICE EQUIPMENT 2,269 524 828 3,500 - 500 (3,000) -86% 52- 100 -75 -00 -7004 SAFETY EQUIPMENT 1,207 1,621 1,150 1,000 426 1,000 0% 52- 100 -78 -00 -9005 MERIT - - - 5,240 - - (5,240) -100% 52- 100 -78 -00 -9009 USE OF RESERVE 9,800 4,658 156,657 (156,657) - 100% 52- 000 -78 -00 -9012 SALARY SURVEY - - - - - - 0% 100 -99 -00 -9901 TRANSFER TO GENERAL FUND 70,000 70,000 70,578 70,000 35,000 70,000 0% 100 -99 -00 -9950 TRANSFER TO PW EQUIP CAPITAL 30,000 30,000 - - - - 0% TOTAL MAINTENANCE EXPENSES: 354,014 209,475 1,110,037 578,408 191,553 428,436 (149,972) -26% Page 26 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION SEWER MAINTENANCE AND IMPROVEMENTS 2008 -2009 2008 -2009 ;COUNT 2005 -2006 2006 -2007 2007 -2008 Original November Revised % NUMBER DESCRIPTION Actual Actual Actual Budget Acluals Budget $ CHANGE CHANGE IMPROVEMENT EXPENSES: 52- 200 -62 -00 -5401 CONTRACTUAL /PROF SVCS 7,218 5,953 - 20,000 20,000 0% 52- 200 -62 -00 -5402 ENG /LEGAL /CONTINGEN- COUNSDE 142,893 33,698 1,741 - - 0% 52- 200 -62 -00 -5403 ENGINEERING - ZANGLER - - - 20,000 20,000 0% 52- 200 -62 -00 -5405 ENGINEERING - BRUELL ST 94,428 (6) - - 0% 52- 200 -62 -00 -5406 HYDRAULIC INTERCEPTOR 1,940 0 % 52- 200 -62 -00 -5407 ENG /LEG/ ROB ROY CREEK 225 - 0% 52- 200 -62 -00 -5462 FOX HILL SEWER RECAPTURE - 385,000 (385,000) -100% 52- 200 -65 -00 -5800 CONTINGENCY - - - 0% 52- 200 -66 -00 -6003 BRUELL ST INTEREST BOND 84,475 39,738 84,475 0% 52- 200 -66 -00 -6004 BRUELL ST PRINCIPAL BOND 80,006 - 80,000 0% 52- 200 -66 -00 -6008 COUNTRYSIDE PRINCIPAL BOND 135,000 - 135,000 0% 52- 200 -66 -00 -6009 COUNTRYSIDE INTEREST BOND 116,138 55,569 116,138 0% 52- 200 -66 -00 -6010 COMED HYDRALIC INTEREST BOND 40,975 17,988 40,975 0% 52- 200 -66 -00 -6011 COMED HYDRALIC PRINCIPAL BOND 145,000 - 145,000 0% 52- 200 -66 -00 -6016 ROB ROY BOND 468,950 234,475 468,950 0% 52- 200 -66 -00 -6049 SANITARY SIPHON INTEREST [EPA 8,301 3,168 8,301 0% 52- 200 -66 -00 -6050 SANITARY SIPHON PRINCIPAL IEPA 30,679 16,322 30,679 0% 52- 200 -66 -00 -6055 ]EPA WASTE WATER LOAN - 109,234 53,525 109,234 0% 52- 200 -66 -00 -6012 BOND COSTS - BANK CHARGES 216,425 - - - - - 0% 52- 200 -75 -00 -7503 COUNTRYSIDE INTERCEPTOR 2,288,310 22,588 20,835 0% 52- 200 -75 -00 -7504 BRUELL ST LIFT STATION 821,296 - - - 0% 52- 200 -75 -00 -7505 ROB ROY CREEK SANITARY 7,662,913 - 8,188 1,650,000 - (1,650,000) -100% 52- 200 -75 -00 -7506 SOUTHWEST SERVICE AREA INTER 626,817 51,291 4,806 - 550,735 0% 52- 200 -75 -00 -7508 MANHOLE REHAB PROJECT 6,456 - - 0% - ?- 200 -75 -00 -7509 NORTH BRANCH #2 - 0% !- 200 -00 -00 -7509 SCADA SYSTEM 0 %, 52- 200 -75 -00 -7510 FOX HILL SANITARY SEWER RECAP 0%, 52- 200 -75 -00 -7511 PALMER COURT - 0% 52- 200 -75 -00 -7515 HEARTLAND ONSITE INTERCEPTOR 278,893 - - - - 0% 52- 200 -99 -00 -9901 TRANSFER TO GENERAL FUND 150,000 150,000 150,000 150,000 75,000 (150,000) -100% 52- 200 -99 -00 -9905 TRANSFER TO WATER FUND - 0 - - - 0% 52- 200 -99 -00 -9965 TRANSFER TO DEBT SERVICE 6 4 6, 21 3 640,0 1,210,236 - - - 0% TOTAL IMPROVEMENT EXPENSES: 12,944,026 903,565 1,395,806 3,443,752 1,046,520 1,258,752 (2,185,000) -63% TOTAL EXPENSES: 13,298,040 1,113,040 2,505,843 4,022,160 1,238,073 1,687,188 (2,334,972) -58% TOTAL FUND REVENUES 18,619,158 7,761,568 3,076,372 3,674,383 718,052 3,380,199 (294,184) -8% TOTAL FUND EXPENSES 13,298,040 1,113,040 2,505,843 4,022,160 1,238,073 1,687,188 (2,334,972) -58% FUND SURPLUS (DEFICIT) BALANCE 5,321,118 6,648,528 570,529 (347,777) (520,021) 1,693,011 2,040,788 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 4 Includes $6,500 for servicemasler 5 stale and regional training for all employees Page 27 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION LAND CASH 2008 -2009 2008 -2009 2005 -2006 2006 -2007 2007 -2008 Original November Revised % ACCOUNT N DESCRIPTION Actual Actual Actual Budget Acluals Budget $ CHANGE CHANGE REVENUES 72- 000 -40 -00 -3999 BEGINNING FUND BALANCE 442,437 (200,757) (251,283) (521,508) (272,822) 248,686 -48% REIMB FROM OTHER GOV'TS - - - 600,000 72- 000 -47 -00 -4700 OSLAD GRANT - PRAIRIE MEADOW - 127,207 400,000 400,000 1 - 0% 72- 000 -47 -00 -4700 OSLAD GRANT - WHISPERING MEA 74,000 142,463 362,000 - 2 (362,000) -100% 72- 000 -47 -00 -4701 GREENBRIAR 1,071 1,071 - - 0% 72- 000 -47 -00 -4702 BIKE PATH GRANT - - 200,000 3 (200,000) -100% 72- 000 -47 -00 -4703 PRAIRIE GARDEN 12,285 - - 0% 72- 000 -47 -00 -4705 COUNTRY HILLS 6,921 3,076 1,700 (1,700) -100% 72- 000 -47 -00 -4707 FOX HIGHLANDS 1,406 - 0% 72- 000 -47 -00 -4709 SUNFLOWER 1,805 - 361 - 0% 72- 000 -47 -00 -4712 RIVER'S EDGE 13,420 2,684 - 3,684 (3,684) -100% 72- 000 -47 -00 -4715 WHITE OAK UNIT 182 1,406 1,226 - 1,406 1,406 1,406 100% 72- 000 -47 -00 -4717 KYLYN'S CROSSING - - 1,570 - - (1,570) -100% 72- 000 -47 -00 -4718 FOXFIELD If PARK LC - 1,688 - - 0% 72- 000 -47 -00 -4719 WILDWOOD 1,836 - 1,071 0% 72- 000 -47 -00 -4722 KYLN'S RIDGE 4,155 - 0% 72- 000 -47 -00 -4751 CANNONBALL RIDGE GRANT - - 128,000 - 0% 72- 000 -47 -00 -4723 HEARTLAND CIRCLE -LAND CASH 49,000 20,000 - 30,000 (30,000) -100% 72- 000 -47 -00 -4727 GRAND RESERVE -LAND CASH 5,167 - - 0% 72- 000 -47 -00 -4732 RAINTREE VILLAGE 29,000 133,400 - - - - 0% 72- 000 -47 -00 -4734 WHISPERING MEADOWS - (Kimball Hill) 46,239 43,983 11,842 12,000 13,533 12,000 0% 72- 000 -47 -00 -4736 Gerner Stone BRIARWOOD - - - 113,043 - - (113,043) -100% 72- 000 -47 -00 -4737 CALEDONIA - - - 158,000 - - 4 (158,000) - 100% 72- 000 -47 -00 -4738 AUTUMN CREEK 55,241 17,844 34,750 25,000 24,845 25,000 0% 000 -47 -00 -4740 VILLAS AT THE PRESERVE 3,469 - - - - - 0% 2- 000 -47 -00 -4744 HUDSON LAKES - - 10,000 (10,000) - 100% 72- 000 -47 -00 -4745 PRESTWICK 6,607 30,000 (30,000) -100% 72- 000 -47 -00 -4746 WESTBURY EAST - - - - - 0% 72- 000 -47 -00 -4749 BLACKBERRY WOODS 75,568 5,682 4,000 568 2,000 (2,000) -50% 72- 000 -47 -00 -4750 KENDALLWOOD ESTATES - - 15,000 - - (15,000) -100% BRISTOL BAY - 85,000 85,000 85,000 100% 72- 000 -49 -00 -4901 TRANSFER FROM GENERAL FUND - - - - - 0% 72- 000 -49 -00 -4902 TRANSFER FROM LAND ACQ 150,000 48,245 0% 72- 000 -49 -00 -4903 TRANSFER FROM PARK 8 REC 4,949 - - - - - 0% TOTAL REVENUES: 748,857 254,732 254,945 844,489 125,353 852,584 8,095 1% EXPENSES 72- 000 -75 -00 -7201 RIVERFRONT BUILDING IMPROV. - 66,496 - - - - - 0% 72- 000 -75 -00 -7300 GREENBRIAR 3,000 - 0% 72- 000 -75 -00 -7304 SUNFLOWER 72,112 33,221 0% 72- 000 -75 -00 -7308 RIVER'S EDGE PARK II 26,901 - 0% 72- 000 -75 -00 -7311 CANNONBALL ESTATESlKYLYNS 263,776 65 - - - 0% 72- 000 -75 -00 -7317 HEARTLAND CIRCLE - - - 167,000 101,992 167,000 0% 72- 000 -75 -00 -7326 MOSIER HOLDING COSTS - 15,685 42,974 10,000 6,000 6,000 5 (4,000) -40% 72- 000 -75 -00 -7327 GRANDE RESERVE PARK DEV 17,512 40,974 19,678 - - - 0% 72- 000 -75 -00 -7328 PRAIRIE MEADOWS - (Menards Res.) - 22,964 231,450 295,000 138,636 138,636 6 (156,364) -53% 72- 000 -75 -00 -7329 ELSIE LOUISE GILBERT PARK 75,946 - - - - - 0% 72- 000 -75 -00 -7330 WHISPERING MEADOWS - (Kimball Hill) 19,811 49,248 215,865 374,000 57,991 200,000 7 (174,000) -47% 72- 000 -75 -00 -7332 CALEDONIA - - - 88,000 - - (88,000) -100% 72- 000 -75 -00 -7333 RAINTREE VILLAGE 72,539 1,800 70,000 3,405 5,000 8 (65,000) -93% 72- 000 -75 -00 -7334 HOOVER HOLDING COSTS 178,518 - - - - - 0% GRANDE RESERVE BIKE TRAIL - 50,187 50,187 50,187 - 100% REC CENTER AGREEMENT - 100,000 100,000 100,000 -100% '- 000 -75 -00 -7700 PARKS MAINTENANCE FACILITY 4,000 10,306 - - - 0% 000 -99 -00 -9901 TRANSFER TO GENERAL FUND - 16,000 1 16,000 8,000 181, 165,000 1031% TOTAL EXPENSES: 868,734 506,016 527,767 1,020,000 466,211 847,823 (172,177) -17% TOTAL FUND REVENUES 748,857 254,732 254,945 844,489 125,353 852,584 8,095 1% TOTAL FUND EXPENSES 868,734 506,016 527,767 1,020,000 466,211 8 (172,17 -17% Page 28 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION LAND CASH 2008 -2009 2008 -2009 2005 -2006 2006 -2007 2007 -2008 Original November Revised % ACCOUN N UMBER DESCRIPTION Actual Actual Actual Budget Actuals Budget $ CHANGE CHANGE FUND SURPLUS (DEFICIT) BALANCE (119,876) (251,284) (272,822) (175,511) (340,858) 4,761 180,272 LAND CASH COMMENTS: 1 Grant reimbursement expected 2 Grant reimbursement expected 3 Grant reimbursement expected 4 Land cash is expected from developer 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 i I I Page 29 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION PARKS & RECREATION 2008 -2009 2008 -2009 2005 -2006 2006 -2007 2007 -2008 Original November Revised % ACCOUNT NUMBER DESCRIPTION Actual Actual Actual Budget Actuals Budget $ CH ANGE CHANGE REVENUES 79- 000 -40 -00 -3999 BEGINNING FUND BALANCE 142,356 77,292 55,140 - - (27,539) (27,539) 79- 000 -42 -00 -4270 FEES FOR PROGRAMS 235,917 243,507 279,040 300,000 175,266 240,000 (60,000) -20% 79- 000 -42 -00 -4280 CONCESSIONS /ALL SALE ITEMS 14,428 15,681 18,704 23,000 27,037 31,000 1 8,000 35% 79- 000 -42 -00 -4281 DEPOSITS 6,755 1,070 - - - - - 0% 79- 000 -42 -00 -4285 VENDING MACHINE INCOME 459 207 2,150 700 2 (700) -100% 79- 000 -42 -00 -4286 RENTAL INCOME 2,360 445 3,215 - - 0% 79- 000 -42 -00 -4287 PARK RENTAL INCOME 390 810 - 4,000 8,305 15,000 3 11,000 275% 79- 000 -42 -00 -4288 GOLF OUTING REVENUE 40,160 40,888 30,694 32,100 33,130 33,130 1,030 3% 79- 000 -42 -00 -4291 HOMETOWN DAYS - 72,543 110,937 115,000 110,763 110,363 (4,637) 4% 79- 000 -44 -00 -4400 DONATIONS 14,843 10,896 18,223 20,000 10,536 12,000 (8,000) -40% 79- 000 -44 -00 -4404 TREE DONATIONS 900 1,405 - 1,300 - 2,300 4 1,000 77% 79- 000 -45 -00 -4550 YOUTH SERVICES GRANT 2,000 2,000 2,000 2,000 1,000 2,000 - 0% 79- 000 -46 -00 -4600 INVESTMENT INCOME 11,576 11,647 7,133 12,000 1,195 3,000 (9,000) -75% 79- 000 -49 -00 -4901 TRANSFER FROM GENERAL FD 755,908 1,015,107 1,161,778 1,206,742 705,429 1,080,348 (126,394) -10% 79- 000 -49 -00 -4980 TRANSFER FROM REC CENTER - - - 46,956 23, - (46,956) -100% TOTAL REVENUES: 1,228,053 1,493,498 1,689,014 1,763,798 1,096,139 1,501,602 (262,196) -15% PARKS EXPENSES 79- 610 -50 -00 -5107 SALARIES - EMPLOYEES 287,508 332,926 428,388 412,500 227,707 393,250 5 (19,250) -5% 79- 610 -50 -00 -5136 SALARIES - PART -TIME 38,528 41,155 33,153 55,000 27,583 30,000 (25,000) -45% 79- 610 -50 -00 -5137 SALARIES - OVERTIME 2,011 1,416 3,593 10,000 3,220 7,500 6 (2,500) -25% 79- 610 -61 -00 -5320 MASTER PLAN / COMMUNITY SURVEY - - 10,772 2,709 1,155 1,500 7 (1,209) -45% 79- 610 -62 -00 -5405 PARK CONTRACTUAL 15,624 13,468 20,400 26,000 20,294 22,000 (4,000) -15% 610 -62 -00 -5408 MAINTENANCE - EQUIPMENT 9,161 9,503 6,254 10,000 4,648 7,000 (3,000) -30% i .,,-610-62-00-5417 MAINTENANCE -PARKS 34,250 46,240 47,568 55,000 17,237 35,000 8 (20,000) -36% 79- 610 -62 -00 -5421 WEARING APPAREL 6,363 6,928 6,992 9,000 1,637 7,000 9 (2,000) -22% 79- 610 -62 -00 -5434 RENTAL - EQUIPMENT 612 1,968 2,783 4,000 1,566 2,000 (2,000) -50% 79- 610 -62 -00 -5438 CELLULAR TELEPHONE 3,903 4,521 4,259 5,000 1,718 5,000 10 0% 79- 610 -62 -00 -5440 LAND DEVELOPER 554 - 7,556 - 7,026 - - 0% 79- 610 -62 -00 -5445 LEGAL EXPENSES 2,213 1,125 14,385 7,200 - 8,200 1,000 14% 79- 610 -64 -00 -5602 PROFESSIONAL GROWTH /SUBS 3,681 1,185 - - - - - 0% 79- 610 -64 -00 -5604 TRAINING AND CONFERENCE - - 11,082 4,500 745 1,000 (3,500) -78% 79- 610 -64 -00 -5605 TRAVEL EXPENSE 2,792 4,337 3,109 1,550 41 100 (1,450) -94% 79- 610 -64 -00 -5612 CONTINUING EDUCATION 2,528 3,708 - - - - 0% 79- 610 -65 -00 -5802 OFFICE SUPPLIES 1,569 1,403 1,094 1,500 94 500 (1,000) -67% 79- 610 -65 -00 -5804 OPERATING SUPPLIES 25,545 35,877 29,646 35,750 13,600 25,750 (10,000) -28% 79- 610 -65 -00 -5812 GASOLINE 725 1,077 - - - - 0% 79- 610 -65 -00 -5815 HAND TOOLS 4,116 3,657 3,450 3,500 802 1,500 (2,000) -57% 79- 610 -65 -00 -5824 CHRISTMAS DECORATIONS 6,409 6,629 3,250 2,500 1,898 2,500 11 0% 79- 610 -65 -00 -5825 PUBLIC DECORATION 1,160 1,332 1,730 1,500 - 500 (1,000) -67% 79- 610 -72 -00 -6500 IMRF PARTICIPANTS 22,694 26,021 33,486 33,584 17,950 30,497 (3,087) -9% 79- 610 -72-00 -6501 SOCIAL SECURITY /MEDICARE 24,250 28,558 35,845 37,593 19,776 32,952 (4,641) -12% 79- 610 -75 -00 -7003 OFFICE EQUIPMENT 1,424 1,421 565 4,000 - 500 (3,500) -88% 79- 610 -75 -00 -7701 FLOWERS /TREES 5,746 7,372 7,108 6,000 (33) 4,000 (2,000) -33% 79- 610 -78 -00 -9005 MERIT - - - 16,500 - - (16,500) -100% TOTAL EXPENSES: PARKS 503,366 581,827 716,468 744,886 368,663 618,249 (126,637) -17% RECREATION EXPENSES 79- 650 -50 -00 -5107 EMPLOYEE SALARIES 254,258 353,326 409,665 359,525 196,850 370,282 10,757 3% 650 -50 -00 -5108 CONCESSION STAFF 3,281 3,557 7,905 8,000 8,499 9,500 1,500 19% 350 -50 -00 -5109 PRE SCHOOL SALARIES - 61,411 73,453 90,000 24,605 24,000 12 (66,000) -73% 79- 650 -50 -00 -5136 PART TIME SALARIES - - 39,110 24,920 36,110 17 (3,000) -8% 79- 650 -50 -00 -5137 OVERTIME - 93 15 350 - 200 (150) -43% 79- 650 -50 -00 -5150 SALARIES - INSTRUCTOR CONTRACT 125,146 73,120 105,573 80,000 83,201 99,000 13 19,000 24% 79- 650 -50 -00 -5155 SALARIES - RECORDING SECRETARY 2,052 2,465 3,169 2,750 1,657 2,500 (250) -9% Page 30 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION PARKS & RECREATION 2008 -2009 2008 -2009 2005 -2006 2006 -2007 2007 -2008 Original November Revised % ACCOUNT NUMBER DESCRIPTION Actual Actual Actual Budget Acluals Budget $ CHANGE CHANGE RECREATION EXPENSES CONT'D 79- 650 -62 -00 -5408 MAINTENANCE SUPPLIES 6,728 5,799 4,205 5,500 2,882 4,200 (1,300) -24% 79- 650 -62 -00 -5409 MAINTENANCE - VEHICLES 484. 2,282 1,334 3,000 1,245 2,000 (1,000) -33% 79- 650 -62 -00 -5410 MAINTENANCE - OFFICE EQUIPMENT 4,779 7,043 4,294 7,000 2,862 6,000 14 (1,000) -14% 79- 650 -62 -00 -5426 YOUTH SERVICES GRANT EXPENSES 539 358 2,100 2,000 454 1,000 15 (1,000) -50% 79- 650 -62 -00 -5435 ELECTRICITY - - 8,900 10,000 10,155 10,000 - 0% 79- 650 -62 -00 -5437 TELEPHONE /INTERNET 446 1,973 1,328 1,500 731 1,300 (200) -13% 79- 650 -62 -00 -5438 CELLULAR TELEPHONE 4,574 4,720 5,599 5,000 2,065 4,500 (500) -10% 79- 650 -62 -00 -5445 PORTABLE TOILETS 3,990 2,986 8,743 6,000 4,523 4,500 (1,500) -25% 79- 650 -62 -00 -5603 PUBLISHING /ADVERTISING 23,444 27,735 28,052 29,060 24,816 29,000 - 0% 79- 650 -62 -00 -5605 BOOKS /PUBLICATIONS 584 581 321 422 708 300 (122) -29% 79- 650 -62 -00 -5606 DEPOSIT REFUND 5,695 4,145 - - - _ _ pes 79- 650 -64 -00 -5600 DUES 1,462 2,372 3,552 2,750 75 2,000 (750) -27% 79- 650 -64 -00 -5602 PROF GROWTH /SUBSCRIPT 7,426 458 - - - - _ 0% 79- 650 -64 -00 -5604 TRAINING AND CONFERENCE - 7,606 5,281 4,500 2,200 1,500 (3,000) -67% 79- 650 -64 -00 -5605 TRAVEL EXPENSE 1,960 1,577 1,390 1,550 328 700 (850) -55% 79- 650 -64 -00 -5614 TOURNAMENT FEES - - - - _ _ _ 0% 79- 650 -65 -00 -5802 OFFICE SUPPLIES 6,058 6,993 6,612 7,000 3,046 6,000 (1,000) -14% 79- 650 -65 -00 -5803 PROGRAM EXPENSES 47,176 55,472 64,351 50,000 39,089 50,000 - 0% 79- 650 -65 -00 -5804 OPERATING SUPPLIES 5,191 4,935 3,407 3,600 576 3,000 (600) -17% 79- 650 -65 -00 -5805 RECREATION EQUIPMENT 3,544 4,018 6,424 10,000 1,788 5,000 (5,000) -50% 79- 650 -65 -00 -5808 POSTAGE & SHIPPING 7,565 8,597 11,086 7,800 7,292 9,600 1,800 23% 79- 650 -65 -00 -5812 GASOLINE 1,573 3,823 4,521 5,000 3,683 5,000 - 0% 79- 650 -65 -00 -5826 MILEAGE 818 456 370 400 107 400 - 0% 650 -65 -00 -5827 GOLF OUTING EXPENSES 21,945 22,177 18,779 20,200 21,457 21,457 1,257 6% ' .350 -65 -00 -5828 CONCESSIONS 11,660 14,011 25,142 11,500 16,459 18,000 6,500 57% 79- 650 -65 -00 -5833 HOMETOWN DAYS EXPENSES - 78,863 98,780 95,000 93,881 94,000 (1,000) -1% 79- 650 -65 -00 -5840 SCHOLARSHIPS 1,570 413 512 6,825 760 3,000 (3,825) -56% 79- 650 -65 -00 -5841 PROGRAM REFUND 11,688 7,827 8,842 9,000 6,811 9,000 0% 79- 650 -72 -00 -6500 IMRF PARTICIPANTS 22,246 29,623 31,891 29,678 18,729 28,194 (1,484) -5% 79- 650 -72 -00 -6501 SOCIAL SECURITY /MEDICARE 25,999 34,546 39,543 45,003 23,367 33,667 (11,336) -25% 79- 650 -75 -00 -7002 COMPUTER EQUIP & SOFTWARE 6,755 5,680 1,807 3,400 155 1,000 (2,400) -71% 79- 650 -78 -00 -9009 USE OF RESERVE - 16,835 7,525 42,168 440 1,000 16 (41,168) -98% 79- 650 -78 -00 -9012 SALARY SURVEY - - - _ _ 0% 79- 650 -78 -00 -9005 MERIT - - - 14,381 - - (14,381) - 100% TOTAL EXPENSES: RECREATION 620,636 857,876 1,004,471 1,018,912 630,417 896,910 (122,002) -12% TOTAL FUND REVENUES 1,228,053 1,493,498 1,689,014 1,763,798 1,096,139 1,501,602 (262,196) -15% TOTAL FUND EXPENSES 1,124,002 1,439,703 1,720,939 1,763,798 999,080 1,5 (248,6 -14% FUND SURPLUS (DEFICIT) ENDING BALANCE 104,050 53,795 (31,925) - 97,059 (13,557) (13,557) 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. 3 Increase due to Bridge Park ballfields 4 Anticipate response to gift catalog released in 07/08. 5 Request 1 new employee - MW 1 6 Pay out of comp time for 1 or 2 individuals per new policy 7 Recreation survey completed in 07/08 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 4% increase for teachers and an additional PT assistant 13 New classes 14 Purchase of new AED per legislation 15 Am uncertain of continuance of United Way $$ which was supplementing us. 16 Would like to add the dollars taken out for unforseen costs. 17 An increase for additional part time help was added. Page 31 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION RECREATION CENTER 2008 -2009 2007 -2008 Original November 2008 -2009 % ACCOUNT NUMBER DESCRIPTION Actual Budget Actuals Revised Budget $ CHANGE CHANGE REVENUES 80- 000 -42 -00 -4200 MEMBERSHIP FEES 423,890 147,220 333,000 (90,890) -21% 80- 000 -42 -00 -4210 GUEST FEES 7,167 5,154 7,200 33 0% 80- 000 -42 -00 -4220 SWIM CLASS 20,000 7,784 20,000 0% 80- 000 -42 -00 -4230 PERSONAL TRAINING FEES 18,750 6,516 18,750 0% 80- 000 -42 -00 -4240 TANNING SESSIONS 7,500 664 5,000 (2,500) -33% 80- 000 -42 -00 -4270 FEES FOR PROGRAMS 125,000 60,192 159,300 34,300 27% 80- 000 -42 -00 -4280 CONCESSIONS 11,666 3,697 12,000 334 3% 80- 000 -42 -00 -4285 VENDING MACHINES 500 - - (500) -100% 80- 000 -42 -00 -4286 RENTAL INCOME 4,333 1,649 4,400 67 2% 80- 000 -44 -00 -4400 DONATIONS / SPONSORSHIPS 3,200 230 9,000 5,800 181% 80- 000 -45 -00 -4550 GRANTS / SCHOLARSHIPS 1,000 - 1,000 - 0 TOTAL REVENUES: 623,006 233,105 569,650 (53,356) -9% EXPENSES 80- 000 -50 -00 -5107 SALARIES 32,000 13,285 29,000 (3,000) -9% 80- 000 -50 -00 -5109 SALARIES - PRE SCHOOL 63,000 13,359 61,000 (2,000) -3% 80- 000 -50 -00 -5136 SALRIES - PART TIME 114,515 44,518 109,541 (4,974) -4% 80- 000 -50 -00 -5137 SALARIES - OVER TIME 2,000 953 2,000 - 0% 80- 000 -50 -00 -5150 SALARIES - INSTRUCTORS 8,000 28,504 47,000 39,000 488% 80- 000 -62 -00 -5408 MAINTENANCE SUPPLIES 6,750 9,902 12,000 5,250 78% 80- 000 -62 -00 -5410 MAINTENANCE - OFFICE EQUIP 5,650 650 4,000 (1,650) -29% 80- 000 -62 -00 -5416 MAINTENANCE - GENERAL 3,800 9,853 12,000 8,200 216% 80- 000 -62 -00 -5426 GRANTS 1,000 - 1,000 - 0% 80- 000 -62 -00 -5430 TOWEL RENTAL 900 20 900 - 0% 80- 000 -62 -00 -5431 POOL REPAIR 1,240 275 3,240 2,000 161% 80- 000 -62 -00 -5432 LEASE PAYMENT 175,000 122,500 175,000 - 0% 80- 000 -62 -00 -5433 LICENSES /PERMITS 5,300 250 1,000 (4,300) -81% 80- 000 -62 -00 -5434 POOL SUPPLIES 4,400 3,437 5,000 600 14% 80- 000 -62 -00 -5435 ELECTRICITY 47,250 14,067 27,250 (20,000) -42% 80- 000 -62 -00 -5437 TELEPHONE 4,900 740 2,500 (2,400) -49% 80- 000 -62 -00 -5438 CELLULAR PHONE 500 278 500 0% 80- 000 -62 -00 -5439 PROPERTY TAX - - - 0% 80- 000 -62 -00 -5440 SECURITY 720 - 720 0% 80- 000 -62 -00 -5603 PUBLISHING / ADVERTISING 2,100 234 1,100 (1,000) -48% 80- 000 -62 -00 -5605 BOOKS / PUBLICATION 100 105 100 - 0% 80- 000 -64 -00 -5600 DUES 900 85 200 (700) -78% 80- 000 -64 -00 -5604 TRAINING & CONFERENCES 1,000 338 600 (400) -40% 80- 000 -64 -00 -5605 TRAVEL EXPENSES 500 70 200 (300) -60% 80- 000 -65 -00 -5802 OFFICE SUPPLIES 4,375 4,998 5,500 1,125 26% 80- 000 -65 -00 -5803 PROGRAM EXPENSES 18,300 10,459 12,000 (6,300) -34% 80- 000 -65 -00 -5804 OPERATING SUPPLIES 2,000 2,810 3,800 1,800 90% 80- 000 -65 -00 -5805 RECREATION EQUIPMENT 10,000 2,340 13,000 3,000 30% 80- 000 -65 -00 -5808 POSTAGE & SHIPPING 1,100 73 300 (800) -73% 80- 000 -65 -00 -5812 GASOLINE 1,000 - 200 (800) -80% 80- 000 -65 -00 -5826 MILEAGE 300 87 300 - 0% 80- 000 -65 -00 -5828 CONCESSIONS 9,000 2,051 8,136 (864) -10% 80- 000 -65 -00 -5840 SCHOLARSHIPS 1,000 288 1,000 - 0% 80- 000 -65 -00 -5841 PROGRAM REFUNDS 4,000 358 2,000 (2,000) -50% 80- 000 -72 -00 -6500 IMRF 3,801 1,879 2,359 (1,442) -38% Page 32 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION RECREATION CENTER 2008 -2009 2007 -2008 Original November 2008 - 2009 % ACCOUNT N UMBER DESCRIPTION Actual Budget Actuals Revised Budget $ C H A NGE CHANGE RECREATION CENTER EXPENSES CONTINUED 80- 000 -72 -00 -6501 SOCIAL SECURITY 12,348 7,472 19,013 6,665 54% 80- 000 -75 -00 -7002 COMPUTER EQUIP & EQUIP 16,500 22,278 13,873 (2,627) -16% 80- 000 -75 -00 -7003 OFFICE EQUIPMENT 2,500 - 200 (2,300) -92% 80- 000 -75 -00 -7500 PHONE SYSTEM 8,300 6,074 6,100 (2,200) -27% 80- 000 -78 -00 -9909 BAD DEBT / LOSS - - - - 0% 80- 000 -99 -00 -9979 TRANSFER TO PARKS & REC 46,956 23,478 - (46,956) - 100% TOTAL RECREATION EXPENSES: 623,005 348,067 583,632 (39,373) -6% TOTAL FUND REVENUES 623,006 233,105 569,650 (53,356) -9% TOTAL FUND EXPENSES 623,005 348,067 583,632 (39,373) -6% I FUND SURPLUS (DEFICIT) ENDING BALANCE 1 (114,962) (13,982) (13,983) I i i I i i I Page 33 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION LIBRARY 2008 -2009 2008 -2009 2005 -2006 2006 -2007 2007 -2008 Original November Revised ACCOUN NUMBER DESCRIPTION Actual Actual Actual Budget Actuals Budget $ CHANGE °% CHANGE REVENUES 82- 000 -40 -00 -3992 LIBRARY BOND PER RE TAXES 421,935 467,425 444,934 467,425 1 0% 82- 000 -40 -00 -3995 CARRY OVER - BOND EXPAN - - _ _ 0% 82- 000 -40 -00 -3996 CARRY OVER - BOOK DEV FEES 102,125 186,700 - (186,700) - 100% 82- 000 -40 -00 -3997 CARRY OVER - BLDG DEV FEES 1,557,975 171,782 282,310 110,528 64% 82- 000 -40 -00 -3998 CARRY OVER - MEMORIALS 1,522 - 1,644 1,644 100% 82- 000 -40 -00 -3999 BEGINNING FUND BALANCE 5,461,107 - - - 600,755 600,755 100% 82- 000 -40 -00 -4000 REAL ESTATE TAXES 356,387 386,235 1,049,994 658,252 626,202 658,252 - 0% 82- 000 -40 -00 -4010 PERSONAL PROPERTY TAX 3,398 3,182 6,320 3,360 3,450 3,360 0% 82- 000 -40 -00 -4015 TRANS FROM GENERAL FUND 28,000 35,430 - 0% 82- 000 -42 -00 -4211 DEVELOPMENT FEES - BUILDING 99,300 86,300 81,025 100,000 30,450 100,000 0°% 82- 000 -42 -00 -4215 DEVELOPMENT FEES -BOOKS 99,300 70,385 81,025 100,000 30,450 100,000 0% 82- 000 -42 -00 -4260 COPY FEES 1,286 1,379 2,292 2,500 1,509 2,500 0% 82- 000 -42 -00 -4261 LIBRARY SUBSCRIPTION CARDS 10,400 12,904 17,459 15,000 10,328 15,000 0% 82- 000 -42 -00 -4286 RENTAL INCOME 1,303 1,836 4,024 4,000 329 4,000 0% 82- 000 -42 -00 -4287 LIBRARY BLDG RENTAL - - - 1,500 334 1,500 0% 82- 000 -43 -00 -4330 LIBRARY FINES 4,000 5,033 7,294 7,000 5,649 7,000 0°% 82- 000 -44 -00 -4432 SALE OF BOOKS 518 973 1,137 1,000 477 1,000 0°% 82- 000 -44 -00 -4450 MEMORIALS 1,522 7,097 8,509 4,000 1,468 4,000 0% 82- 000 -45 -00 -4550 GRANTS - - 13,565 17,500 - 17,500 0% 82- 000 -45 -00 -4560 LIBRARY PER CAPITA GRANT 10,824 13,708 - - - - 0% 82- 000 -46 -00 -4600 INVESTMENT INCOME 15,693 31,546 39,531 2,500 7,753 2,500 0% 82- 000 -46 -00 -4601 INVESTMENT INCOME -BLDG 162,968 123,886 - - - - 0% 82- 000 -48 -00 -4801 LIB BOND PROCEEDS 7,263,881 - - - - 0% 'AL REVENUES: 8,058,781 7,902,623 1,734,110 1,742,519 1,163,333 2,268,746 526,227 30% EXPENSES 82- 000 -50 -00 -5107 SALARIES- EMPLOYEES 165,445 277,247 394,851 600,000 233,238 600,000 - 0% 82- 000 -50 -00 -5203 GROUP HEALTH INSURANCE 36,678 44,681 47,950 52,800 23,768 52,800 0°% 82- 000 -50 -00 -5204 GROUP LIFE INSURANCE 646 889 744 3,000 413 3,000 0% 82- 000 -50 -00 -5205 DENTAL R VISION ASSISTANCE 3,014 3,376 3,204 4,200 2,022 4,200 0% 82- 000 -61 -00 -5322 BONDING 1,014 1,875 1,875 2,000 1,875 2,000 0°% 82- 000 -61 -00 -5323 ATTORNEY 863 - 960 3,000 595 3,000 0% 82- 000 -62 -00 -5401 CONTRACT SERVICES 811 2,251 4,891 20,000 7,169 20,000 0% 82- 000 -62 -00 -5407 MAINTENANCE- BLDG(JANITORIAL 3,730 5,655 5,609 10,000 3,309 10,000 0% 82- 000 -62 -00 -5410 MAINTENANCE - OFFICE EQUIP 2,992 2,470 4,554 10,000 4,485 10,000 0% 82- 000 -62 -00 -5412 MAINTENANCE - PHOTOCOPIER 411 946 461 10,000 1,568 10,000 0% 82- 000 -62 -00 -5435 ELECTRICITY 1,419 547 23,723 5,000 1,371 5,000 0 82- 000 -62 -00 -5436 TELEPHONE 1,558 2,640 5,941 7,000 1,912 7,000 0% 82- 000 -62 -00 -5437 GAS HEAT - - - 40,000 1,709 40,000 0% 82- 000 -64 -00 -5603 SUBSCRIPTIONS 3,140 3,581 3,745 8,000 4,256 8,000 0% 82- 000 -64 -00 -5604 TRAINING & CONFERENCES 20 60 225 2,000 895 2,000 0% 82- 000 -64 -00 -5607 PUBLIC RELATIONS 121 978 918 2,000 - 2,000 0% 82- 000 -64 -00 -5616 EMPLOYEE RECOGNITION 723 1,616 1,526 3,000 258 3,000 - 0% 82- 000 -65 -00 -5800 CONTINGENCIES 1,739 16,918 12,380 64,574 3,349 590,801 526,227 815% 82- 000 -65 -00 -5802 OFFICE SUPPLIES 3,490 5,732 6,365 10,000 2,211 10,000 - 0% 82- 000 -65 -00 -5806 LIBRARY SUPPLIES 3,124 6,355 9,934 10,000 4,568 10,000 0% 82- 000 -65 -00 -5807 CUSTODIAL SUPPLIES 3,072 8,211 9,452 15,000 4,741 15,000 0% 82- 000 -65 -00 -5808 POSTAGE R SHIPPING 843 964 1,791 2,000 420 2,000 0% 82- 000 -65 -00 -5810 PUBLISHING 8 ADVERTISING 586 333 60 2,000 28 2,000 0% 82- 000 -65 -00 -5826 MILEAGE 578 512 1,110 1,000 524 1,000 0% 82- 000 -65 -00 -5832 VIDEOS 2,678 4,830 6,058 5,000 4,336 5,000 0% 82- 000 -65 -00 -5833 ALARM MONITORING 931 489 3,411 - - _ 0% 70 -65 -00 -5834 LIBRARY PROGRAMMING 6,140 5,541 10,450 10,000 4,694 10,000 0% j00 -65 -00 -5835 LIBRARY BOARD EXPENSES 75 666 295 2,000 148 2,000 0% 82- 000 -65 -00 -5836 BOOKS -ADULT 9,027 9,731 26,364 15,000 14,874 15,000 0% 82- 000 -65 -00 -5837 BOOKS - JUVENILE 9,058 11,020 30,496 20,000 12,905 20,000 0% 82- 000 -65 -00 -5838 BOOKS -AUDIO 6,415 6,630 5,511 10,000 3,508 10,000 0% Page 34 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION LIBRARY 2008 -2009 2008 -2009 2005 -2006 2006 -2007 2007 -2008 Original November Revised ACCOUNT N UMBER DESCRIPTION Actual Actual Actual Budget Actuals Budget $ C % CHANGE LIBRARY EXPENSES CONT'D 82- 000 -65 -00 -5839 BOOKS - REFERENCE 9,346 10,019 24,789 20,000 7,157 20,000 0% 82- 000 -65 -00 -5840 BOOKS - DEVELOPMENT FEE 23,782 40,285 53,569 100,000 22,311 100,000 0% 82- 000 -65 -00 -5841 MEMORIALS /GIFTS 2,093 7,147 10,682 4,000 733 4,000 0% 82- 000 -65 -00 -5842 BLDG- DEVELOPMENT FEES 46,697 8,233 2,043 100,000 6,850 100,000 0% 82- 000 -65 -00 -5843 CD's /Music - - 3,798 5,000 1,709 5,000 0% 82- 000 -65 -00 -5844 MEETING ROOM 800 1,500 - 1,500 0% 82- 000 -66 -00 -6012 2005B LIBRARY BOND - 346,145 160,563 346,145 0% 82- 000 -66 -00 -6014 2006 LIBRARY BOND - - - 121,300 35,650 121,300 0% 82- 000 -72 -00 -6500 IMRF PARTICIPANTS 7,426 10,451 12,457 13,000 7,459 13,000 0% 82- 000 -72 -00 -6501 SOCIAL SECURITY /MEDICARE 12,657 21,209 30,207 40,000 17,843 40,000 0% 82- 000 -75 -00 -7002 COMPUTER EQUIP & SOFT - - 14,876 18,000 3,543 18,000 0% 82- 000 -75 -00 -7003 AUTOMATION 10,543 32,794 19,313 25,000 9,158 25,000 0% 82- 000 -75 -00 -7703 BUILDING EXPANSION 2,281,851 6,240,073 514,787 - 14,958 - 0% 82- 000 -78 -00 -9020 TRANSFER TO DEBT SVC - - 42 - - - - 0% TOTAL EXPENSES: 2,664,736 6,796,955 1,734,110 1,742,519 633,083 2,268,746 526,227 30% TOTAL FUND REVENUES 8,058,781 7,902,623 1,734,110 1,742,519 1,163,333 2,268,746 526,227 30% TOTAL FUND EXPENSES 2,664,736 6,796,955 1,734,110 1,742,519 633,083 2,26 526,227 30% FUND SURPLUS (DEFICIT) BALANCE 5,394,045 1,105,668 - - 530,250 - - LIBRARY COMMENTS: 1 $467,425 is for the library bond payments I I Page 35 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL j 6 MONTH FY 2008 -2009 BUDGET REVISION FOX INDUSTRIAL 2008 -2009 2008 -2009 2005 -2006 2006 -2007 2007 -2008 Original November Revised % ACCOUNT NUMBER DESCRIPTION Actual Actual Actual Budget Actuals Budget $ CHANGE CHANGE REVENUES 85- 000 -40 -00 -3999 BEGINNING FUND BALANCE 11,817 32,799 87,553 93,924 - 183,227 89,303 -49% 85- 000 -40 -00 -4090 TIF REVENUES 70,997 130,078 169,251 77,430 207,215 200,863 123,433 -61% 85- 000 -46 -00 -4600 INVESTMENT INCOME 3,290 5,375 4,707 3,500 1,301 1,800 (1,700) 94% 85- 000 -49 -00 -4905 TRANSFER FROM MFT FUND 31,190 - - - - _ - 0% TOTAL REVENUES: 117,293 168,252 261,511 174,854 208,516 385,890 211,036 -55% EXPENSES 85- 000 -66 -00 -6021 FOX IND BOND - PRINCIPAL PMT 55,000 60,000 60,000 60,000, 65,000 65,000 5,000 -8% 85- 000 -66 -00 -6022 FOX IND BOND -INT PAYMENT 11,225 20,415 18,015 20,555 15,555 15,555 (5,000) 32% 85- 000 -75 -00 -7901 FOX IND NON MFT PAYMENT 233 - - - - - 0% 85- 000 -75 -00 -7902 FOX INDUSTRIAL EXPENSES 5,068 - - - - 0% 85- 000 -78 -00 -9007 ADMINISTRATION FEES 1,744 284 269 375 375 - 0% TRANSFER TO GEN FUND - - - - 25,680 25,680 100% 85- 000 -78 -00 -9010 RESERVE - FUTURE BOND PYMT - - - 93,924 - 27 185,356 -66% TOTAL EXPENSES: 73,269 80,699 78,284 174,854 80,555 385,890 211,036 -55% TOTAL FUND REVENUES 117,293 168,252 261,511 174,854 208,516 385,890 211,036 -55% TOTAL FUND EXPENSES 73,269 80,699 78,284 174,854 80,555 385,890 211,036 -55% FUND SURPLUS (DEFICIT) BALANCE 44,024 87,553 183,227 - 127,961 - - i I I Page 36 of 39 UNITED CITY OF YORKVILLE KENDALL COUNTY, IL 6 MONTH FY 2008 -2009 BUDGET REVISION COUNTRYSIDE TIF 2008 -2009 2008 -2009 2005 -2006 2006 -2007 2007 -2008 Original November Revised ACCOUNT N UMBER DESCRIPTION Actual Actual Actual Budget Actuals Budget $ CH ANGE % CHANGE REVENUES 87- 000 -40 -00 -3999 BEGINNING FUND BALANCE 3,456,521 3,463,672 2,919,125 2,856,390 - 2,882,609 26,219 1% 87- 000 -40 -00 -4090 TIF REVENUES - - 7,954 - 8,448 8,442 8,442 0% 87- 000 -46 -00 -4600 INVESTMENT INCOME 109,570 98,340 103,312 .75,000 _ , 28,196 40,000 (35,000) -47% 87- 000 -48 -00 -4801 BOND PROCEEDS - - - - - - 0% TOTAL REVENUES: 3,566,092 3,562,012 3,030,391 2,931,390 36,643 2,931,051 (339) 0% EXPENSES 87- 000 -66 -00 -6021 BOND- PRINCIPAL PMT - - - - - - - 87- 000 -66 -00 -6022 BOND -INT PAYMENT - 142,868 142,868 142,868 142,868 142,868 - 0% 87- 000 -78 -00 -9007 ADMINISTRATION FEES 825 19 4,914 2,500 12,915 14,315 11,815 473% 87- 000 -78 -00 -9010 RESERVE - FUTURE BOND PYMT - 500,000 2,786,022 - 2,773,868 (12,154) 0% TOTAL EXPENSES: 825 642,887 147,782 2,931,390 155,783 2,931,051 (339) 0% TOTAL FUND REVENUES 3,566,092 3,562,012 3,030,391 2,931,390 36,643 2,931,051 (339) 0% TOTAL FUND EXPENSES 825 642,887 1 47,7 8 2 2,931 ,390 1 2,9 (3 0% FUND SURPLUS (DEFICIT) BALANCE 3,565,267 2,919,125 2,882,609 - (119,139) - - I I I i I Page 37 of 39 UNITED CITY OF YORKVILLE 6 MONTH FY 2008 -2009 BUDGET REVISION KENDALL COUNTY, IL DOWNTOWN TIF 2008 -2009 2008 -2009 2005 -2006 2006 -2007 2007 -2008 Original November Revised $ % ACCOUNT NUMBER DESCRIPTI Actual Actual Actual Budget Actuals Budget CHANGE CHANGE REVENUES 88- 000 -40 -00 -3999 BEGINNING FUND BALANCE - - 28,693 - 28,372 (321) -1% 88- 000 -40 -00 -4090 TIF REVENUES - 34,760 28,000 71,525 65,119 37,119 133% 88- 000 -46 -00 -4600 INVESTMENT INCOME - - - - - 0% TOTAL REVENUES: - 34,760 56,693 71,525 93,491 36,798 65% EXPENSES TRANSFER TO GEN FUND - - - - 25,805 25,805 100% 88- 000 -78 -00 -7101 IN -TOWN ROAD - - - 24,063 25,859 25,859 100% 88- 000 -78 -00 -9007 ADMINISTRATION FEES - 6,388 10,000 45 45 (9,955) - 100% 88- 000 -78 -00 -9010 RESERVE - FUTURE REIMB - - 46,693 - 41,782 (4,911) -11% TOTAL EXPENSES: - 6,388 56,693 24,108 93,491 36,798 65% TOTAL FUND REVENUES - 34,760 56,693 71,525 93,491 36,798 65% T TAL FUND EXPENSES - 6,388 56,693 24,108 93,491 36,798 65% D SURPLUS (DEFICIT) BALANCE - 28,372 - 47,417 - - II I I I I I I Page 38 of 39 Revenues Expenses Difference General Fund 10,913,842 12,003,728 (1,089,886) MFT 752,588 705,320 47,268 Municipal Building (486,524) 59,400 (545,924) Fox Hill SSA 6,376 19,892 (13,516) Sunflower SSA 15,925 15,925 - Police Capital 229,796 229,796 - PW Capital 612,295 520,000 92,295 Park & Rec Capital 80,197 80,197 - City Wide Capital 420,000 501,317 (81,317) Sewer Improv 3,380,199 1,687,188 1,693,011 Water Improv 2,763,275 2,763,275 (0) Debt Svc 247,265 484,524 (237,259) Land Cash 852,584 847,823 4,761 Park & Rec 1,501,602 1,515,159 (13,557) Library 2,268,746 2,268,746 - Fox Industrial TIF 385,890 385,890 - Countryside TIF 2,931,051 2,931,051 - Downtown TIF 93,491 93,491 - I Grand Total 26,968,599 27,112,723 (144,124) I i Page 39 of 39