Loading...
HomeMy WebLinkAbout3. BILLS AND FINANCIALS 07/17/2007 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE & EXPENDITURE SUMMARIES June 1 - June 30, 2007 07/13/2007 , 09,05,26 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/07 06/30/07 Cur Mo Received REVENUE BY CLASSIFICATION PROPERTY TAXES OTHER TAXES LICENSES, PERMITS & FEES INTERGOVERMENT REV. CHARGES FOR SERVICE FINES AND FORFEITS INVESTMENT INCOME REIMBURSEMENTS OTHER REVENUE OTHER FINANCING SOURCES Total All Funds 1,239,050 -210,716 288,386 2,001,390 2,015,903 72,673 80,857 14,715 192,155 o 5,694.413 REVENUE BY FUND GENERAL FUND REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND FOREIGN FIRE TAX BOARD FUND SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2002B B&I, PUBLIC BLDGS SERIES 2002A B&I, TIF SERIES 1999 B&I, TIF SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD SERIES 1998A B&I, STREET IMP. SERIES 2002B B&I, STREET IMP. CAPITAL IMPROVEMENT FUND DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST FUND WATER AND SEWER FUND VILLAGE PARKING SYSTEM FUND PARKING SYSTEM REVENUE FUND VEHICLE MAINTENANCE FUND VEHICLE REPLACEMENT FUND COMPUTER REPLACEMENT FUND RISK MANAGEMENT FUND POLICE PENSION FUND FIRE PENSION FUND ESCROW DEPOSIT FUND 3,816,869 192,479 151,826 -18 o 289 o 4,130 205 1,784 1,155 1,734 o o 5,197 -49,886 -12,297 530 -114,248 -48,198 o o o 9,936 10,159 -190,847 2,709 971,079 8,884 7,389 157,417 113,874 19,035 597,650 29,841 5,660 o 1 Y-T-D Received 6,444,663 5,324,563 2,257,107 6,051,231 10,383,854 254,591 2,129,635 160,860 2,442,306 o 35.448.810 16,464,645 2,121,749 729,504 10 67,360 6,953 667 12,897 1,260 211,044 197,719 306,444 o o 577,260 669 11,416 48,492 131,851 165,283 2 o o 37,434 667,052 486,398 16,412 5,203,702 51,889 49,316 787,886 589,396 100,971 3,290,993 1,599,840 1,510,090 o 6 Months 6 Months 2007 Budget 13,374,952 15,384,659 2,954,888 16,480,809 21,409,733 553,000 5,501,950 271,240 4,972,704 60,000 80.963.935 38,420,223 4,300,751 1,628,750 1,000 549,809 2,600 2,500 20,350 51,500 1,000 394,500 926,250 o o 1,076,500 o 49,367 88,507 582,933 735,250 o o o 262,800 1,220,052 1,711,100 32,000 11,149,100 96,738 111,100 1,573,353 1,093,626 189,547 6,473,939 4,125,500 4,093,290 o 50.0% 50.0% Unreceived Balance 6,930,289 10,060,096 697,781 10,429,578 11,025,879 298,409 3,372,315 110,380 2,530,398 60,000 45.515.125 21,955,578 2,179,002 899,246 990 482,449 -4,353 1,833 7,453 50,240 -210,044 196,781 619,806 o o 499,240 -669 37,951 40,015 451,082 569,967 -2 o o 225,366 553,000 1,224,702 15,588 5,945,398 44,849 61,784 785,467 504,230 88,576 3,182,946 2,525,660 2,583,200 o Completed Remaining Unreceived Percent 51. 8 65.4 23.6 63.3 51. 5 54.0 61.3 40.7 50.9 100.0 56.2 57.1 50.7 55.2 99.0 87.7 -167.4 73 .3 36.6 97.6 **** * 49.9 66.9 46.4 76.9 45.2 77.4 77.5 85.8 45.3 71.6 48.7 53.3 46.4 55.6 49.9 46.1 46.7 49.2 61. 2 63.1 07/.13/2007 09:05:26 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/07 - 06/30/07 6 Months 6 Months 50.0% 50.0% Completed Remaining Cur Mo Y-T-D 2007 Unreceived Unreceived Received Received Budget Balance Percent SSA #6 GEORGE/ALBERT B&I 68 415 0 -415 SERIES 2002 LIBRARY BND ESCROW 8 1,791 0 -1,791 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 Total All Funds 5.694.413 35.448.810 80.963.935 45.515.125 56.2 2 07/13{2007 6 Months 50.0% Completed 09:04:59 6 Months 50.0% Remaining FRRBRR03 VILLAGE OF MOUNT PROSPECT SUM 021 Budget Revenue by Category within Fund Summary 01/01/07 06/30/07 Cur Mo Y-T-D 2007 Unreceived Unreceived Received Received Budget Balance Percent GENERAL FUND 40 PROPERTY TAXES 1,233,230 4,788,782 10,050,926 5,262,144 52.4 41 OTHER TAXES 207,984 2,590,633 8,447,000 5,856,367 69.3 42 LICENSES, PERMITS & FEES 285,945 2,245,401 2,935,250 689,849 23.5 43 INTERGOVERMENT REV. 1,854,731 5,319,468 14,162,700 8,843,232 62.4 44 CHARGES FOR SERVICE 108,687 845,453 1,551,507 706,054 45.5 45 FINES AND FORFEITS 68,621 237,168 531,000 293,832 55.3 46 INVESTMENT INCOME 39,243 261,337 397,000 135,663 34.2 47 REIMBURSEMENTS 14,715 120,225 189,740 69,515 36.6 48 OTHER REVENUE 3,713 56,178 155,100 98,922 63.8 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL GENERAL FUND 3,816,869 16,464,645 38,420,223 21,955,578 57.1 REFUSE DISPOSAL FUND 40 PROPERTY TAXES 3,295 953,180 2,016,276 1,063,096 52.7 44 CHARGES FOR SERVICE 181,975 1,125,730 2,211,475 1,085,745 49.1 46 INVESTMENT INCOME 7,209 42,732 72,000 29,268 40.7 48 OTHER REVENUE 0 107 1,000 893 89.3 TOTAL REFUSE DISPOSAL FUND 192,479 2,121,749 4,300,751 2,179,002 50.7 MOTOR FUEL TAX FUND 43 INTERGOVERMENT REV. 146,659 691,427 1,587,500 896,073 56.4 46 INVESTMENT INCOME 5,167 36,139 34,750 -1,389 -4.0 47 REIMBURSEMENTS 0 1,938 6,500 4,562 70.2 TOTAL MOTOR FUEL TAX FUND 151,826 729,504 1,628,750 899,246 55.2 LAW ENFORCEMENT BLOCK GRANT 43 INTERGOVERMENT REV. 0 0 1,000 1,000 100.0 46 INVESTMENT INCOME -18 10 0 -10 TOTAL LAW ENFORCEMENT BLOCK GRANT -18 10 1,000 990 99.0 COMMUNITY DEVELPMNT BLOCK GRNT 43 INTERGOVERMENT REV. 0 40,336 489,809 449,473 91. 8 46 INVESTMENT INCOME 0 620 0 -620 48 OTHER REVENUE 0 26,404 60,000 33,596 56.0 TOTAL COMMUNITY DEVELPMNT BLOCK GRNT 0 67,360 549,809 482,449 87.7 ASSET SEIZURE FUND 45 FINES AND FORFEITS 0 5,159 1,000 -4,159 -415.9 46 INVESTMENT INCOME 289 1,794 1,600 -194 -12.1 TOTAL ASSET SEIZURE FUND 289 6,953 2,600 -4,353 -167.4 DEA SHARED FUNDS FUND 45 FINES AND FORFEITS 0 0 1,000 1,000 100.0 46 INVESTMENT INCOME 0 667 1,500 833 55.5 1 07~13/2007 09,05,00 FRRBRR03 SUM 021 6 Months 6 Months 50.0% 50.0% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 06/30/07 Cur Mo Received TOTALDEA SHARED FUNDS FUND DUI FINE FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME 4,052 78 TOTAL DUI FINE FUND 4,130 FOREIGN FIRE TAX BOARD FUND 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES o 205 o TOTAL FOREIGN FIRE TAX BOARD FUND 205 SERIES 1987A B&I, PW FACILITY 40 PROPERTY TAXES 46 INVESTMENT INCOME 812 972 TOTAL SERIES 1987A B&I, PW FACILITY 1,784 SERIES 2001 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 673 482 o TOTAL SERIES 2001 B&I, VILLAGE HALL 1,155 SERIES 2003 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 1,040 694 o TOTAL SERIES 2003 B&I, VILLAGE HALL 1,734 SERIES 2002B B&I, PUBLIC BLDGS 40 PROPERTY TAXES TOTAL SERIES 2002B B&I, PUBLIC BLDGS SERIES 2002A B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 2002A B&I, TIF SERIES 1999 B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 1,580 3,617 o TOTAL SERIES 1999 B&I, TIF 5,197 2 Y-T-D Received o 667 12,264 633 12,897 o 1,260 o 1,260 207,189 3,855 211,044 194,772 2,947 o 197,719 300,740 5,704 o 306,444 o o o o o 560,401 16,859 o 577,260 2007 Budget 2,500 20,000 350 20,350 46,500 5,000 o 51,500 1,000 o 1,000 390,500 4,000 o 394,500 916,250 10,000 o 926,250 o o o o o 1,053,500 23,000 o 1,076,500 o o Unreceived Balance 1,833 7,736 -283 7,453 46,500 3,740 o 50,240 -206,189 -3,855 -210,044 195,728 1,053 o 196,781 615,510 4,296 o 619,806 o o o 493,099 6,141 o 499,240 Complet,ed Remaining Unreceived Percent 73.3 38.7 -80.9 36.6 100.0 74.8 97.6 ****.* ****.* 50.1 26.3 49.9 67.2 43.0 66.9 o o o o o 46.8 26.7 46.4 07/1V2007 09:05:00 FRRBRR03 SUM 021 6 Months 6 Months 50.0% 50.0% Completed Remaining Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 06/30/07 Cur Mo Y-T-D 2007 Unreceived Unreceived Received Received Budget Balance Percent -49,975 0 0 0 89 669 0 -669 -49,886 669 0 -669 SERIES 1996A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME -12,412 115 TOTAL SERIES 1998A B&I, FLOOD -12,297 SERIES 1998C B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I 41 OTHER TAXES 46 INVESTMENT INCOME -114,248 o TOTAL IEPA FLOOD CONTROL LOANS B&I -114,248 SERIES 2000 B&I, FLOOD CONTROL 41 OTHER TAXES 46 INVESTMENT INCOME -48,832 634 TOTAL SERIES 2000 B&I, FLOOD CONTROL -48,198 SERIES 2002B B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 2002B B&I, FLOOD SERIES 1998A B&I, STREET IMP. 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 1998A B&I, STREET IMP. SERIES 2002B B&I, STREET IMP. 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 2002B B&I, STREET IMP. CAPITAL IMPROVEMENT FUND 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 10,984 432 11,416 131 399 46,442 2,050 49,067 300 49,367 87,307 1,200 88,507 582,933 o 582,933 728,000 7,250 735,250 o 2 2 o 38,083 -132 77.6 -44.0 530 48,492 o o o o 130,494 1,357 131,851 162,968 2,315 165,283 o o o o o o o o o o o o o 37,951 76.9 o o 40,865 -850 46.8 -70.8 40,015 45.2 452,439 -1,357 77.6 451,082 77 .4 565,032 4,935 77.6 68.1 569,967 77 .5 o o o -2 -2 o o o o o o o o 0 0 239,800 239,800 100.0 3,357 23,043 8,500 -14,543 -171.1 0 0 0 0 6,579 14,391 14,500 109 0.8 3 07/13/2007 09:05:00 FRRBRR03 SUM 021 6 Months 6 Months 50.0% 50.0% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 06/30/07 Cur Mo Received 49 OTHER FINANCING SOURCES TOTAL CAPITAL IMPROVEMENT FUND 9,936 DOWNTOWN REDEVLPMNT CONST 41 OTHER TAXES 46 INVESTMENT INCOME 47 REIMBURSEMENTS 49 OTHER FINANCING SOURCES 1,752 8,407 o o TOTAL DOWNTOWN REDEVLPMNT CONST 10,159 STREET IMPROVEMENT CONST FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES -198,443 o 7,596 o o TOTAL STREET IMPROVEMENT CONST FUND -190,847 FLOOD CONTROL CONST FUND 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES o 2,709 o TOTAL FLOOD CONTROL CONST FUND 2,709 WATER AND SEWER FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 4 8 OTHER REVENUE 49 OTHER FINANCING SOURCES 1,747 1,020 947,064 19,060 o 2,188 o TOTAL WATER AND SEWER FUND 971,079 VILLAGE PARKING SYSTEM FUND 42 LICENSES, PERMITS & FEES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 1,421 7,138 325 o TOTAL VILLAGE PARKING SYSTEM FUND 8,884 PARKING SYSTEM REVENUE FUND 42 LICENSES, PERMITS & FEES 43 INTERGOVERMENT REV. 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE o o 7,389 o o 4 Y-T-D Received o 37,434 621,070 45,982 o o 667,052 447,855 o 38,543 o o 486,398 o 16,412 o 16,412 753,716 6,660 4,308,406 113,079 1,083 20,758 o 5,203,702 5,046 45,050 1,793 o 51,889 o o 49,316 o o 2007 Budget o 262,800 1,167,552 52,500 o o 1,220,052 1,688,700 o 22,400 o o 1,711,100 o 32,000 o 32,000 1,534,100 12,000 9,420,000 168,000 o 15,000 o 11,149,100 7,638 88,500 600 o 96,738 o o 110,000 1,100 o Unreceived Balance o 225,366 546,482 6,518 o o 553,000 1,240,845 o -16,143 o o 1,224,702 o 15,588 o 15,588 780,384 5,340 5,111,594 54,921 -1,083 -5,758 o 5,945,398 2,592 43,450 -1,193 o 44,849 o o 60,684 1,100 o Completed Remaining Unreceived Percent o 85.8 46.8 12.4 45.3 73.5 -72.1 71.6 48.7 48.7 50.9 44.5 54.3 32.7 -38.4 53.3 33.9 49.1 -198.8 46.4 55.2 100.0 07/1~/2007 6 Months 50.0% Completed 09,05,00 6 Months 50.0% Remaining FRRBRR03 VILLAGE OF MOUNT PROSPECT SUM 021 Budget Revenue by Category within Fund Swmnary 01/01/07 06/30/07 Cur Mo Y-T-D 2007 Unreceived Unreceived Received Received Budget Balance Percent 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL PARKING SYSTEM REVENUE FUND 7,389 49,316 111,100 61,784 55.6 VEHICLE MAINTENANCE FUND 44 CHARGES FOR SERVICE 155,595 777,982 1,555,953 777, 971 50.0 46 INVESTMENT INCOME 1,822 9,904 17,400 7,496 43.1 48 OTHER REVENUE 0 0 0 0 TOTAL VEHICLE MAINTENANCE FUND 157,417 787,886 1,573,353 785,467 49.9 VEHICLE REPLACEMENT FUND 44 CHARGES FOR SERVICE 84,963 424,816 849,626 424,810 50.0 46 INVESTMENT INCOME 28,911 164,580 184,000 19,420 10.6 48 OTHER REVENUE 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 60,000 60,000 100.0 TOTAL VEHICLE REPLACEMENT FUND 113,874 589,396 1,093,626 504,230 46.1 COMPUTER REPLACEMENT FUND 44 CHARGES FOR SERVICE 15,872 82,188 159,547 77,359 48.5 46 INVESTMENT INCOME 3,163 18,783 30,000 11,217 37.4 TOTAL COMPUTER REPLACEMENT FUND 19,035 100,971 189,547 88,576 46.7 RISK MANAGEMENT FUND 44 CHARGES FOR SERVICE 507,220 2,724,913 5,463,125 2,738,212 50.1 46 INVESTMENT INCOME 10,655 54,033 92,000 37,967 41.3 47 REIMBURSEMENTS 0 37,614 75,000 37,386 49.8 48 OTHER REVENUE 79,775 474,433 843,814 369,381 43.8 TOTAL RISK MANAGEMENT FUND 597,650 3,290,993 6,473,939 3,182,946 49.2 POLICE PENSION FUND 46 INVESTMENT INCOME -23,298 636,388 2,131,000 1,494,612 70.1 48 OTHER REVENUE 53,139 963,452 1,994,500 1,031,048 51. 7 TOTAL POLICE PENSION FUND 29,841 1,599,840 4,125,500 2,525,660 61.2 FIRE PENSION FUND 46 INVESTMENT INCOME -41,101 623,507 2,204,500 1,580,993 71.7 48 OTHER REVENUE 46,761 886,583 1,888,790 1,002,207 53.1 TOTAL FIRE PENSION FUND 5,660 1,510,090 4,093,290 2,583,200 63.1 ESCROW DEPOSIT FUND 46 INVESTMENT INCOME 0 0 0 0 TOTAL ESCROW DEPOSIT FUND 0 0 0 0 SSA #6 GEORGE/ALBERT B&I 41 OTHER TAXES 0 0 0 0 46 INVESTMENT INCOME 68 415 0 -415 5 07/13/2007 09,05,00 FRRBRR03 SUM 021 6 Months 6 Months Budget OF MOUNT PROSPECT Fund Swmnary 50.0% 50.0% Completed Remaini"ng VILLAGE Revenue by Category within 01/01/07 06/30/07 Cur Mo Received Y-T-D Received 2007 Budget unreceived Balance Unreceived Percent TOTALSSA #6 GEORGE/ALBERT B&I - 41.5 SERIES 2002 LIBRARY BND ESCROW 46 INVESTMENT INCOME TOTAL SERIES 2002 LIBRARY BND ESCROW GENERAL FIXED ASSETS ACCT GP 47 REIMBURSEMENTS 49 OTHER FINANCING SOURCES TOTAL GENERAL FIXED ASSETS ACCT GP MOUNT PROSPECT LIBRARY FUND 49 OTHER FINANCING SOURCES TOTAL MOUNT PROSPECT LIBRARY FUND 68 8 8 1,791 o o o o o 6 1,791 415 o o o o 8,572,028 o 8,572,028 o o -1,791 o -1,791 o o o o o o 8,572,028 100.0 8,572,028 100.0 07/13/2007 09:08:26 6 Months 6 Months VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/07 06/30/07 Cur Mo Expended Y-T-D Expended 2007 Budget 50.0% 50.0% Unexpended Balance Completed' Remaining Unexpended Percent EXPENDITURE BY CLASSIFICATION PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS PENSION BENEFITS CONTRACTUAL SERVICES UTILITIES INSURANCE COMMODITIES & SUPPLIES OTHER EXPENDITURES LAND IMPROVEMENTS BUILDING IMPROVEMENTS OFFICE EQUIPMENT MOBILE EQUIPMENT OTHER EQUIPMENT DISTRIBUTION SYSTEMS INFRASTRUCTURE BOND PRINCIPAL INTEREST EXPENSE BANK AND FISCAL FEES INTERFUND TRANSFERS Total All Funds EXPENDITURE BY FUND GENERAL FUND REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND FOREIGN FIRE TAX BOARD FUND SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2002A B&I, TIF SERIES 1999 B&I, TIF SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD SERIES 1998A B&I, STREET IMP. SERIES 2002B B&I, STREET IMP. CAPITAL IMPROVEMENT FUND DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST FUND WATER AND SEWER FUND VILLAGE PARKING SYSTEM FUND 1,873,099 1,813,519 30,598 428,339 1,245,390 80,358 604,078 120,793 1,444 o o 73,843 105,575 26,280 12,841 465,013 88,124 30,280 o o 6,999,574 3,961,849 342,140 332,028 o 9,925 500 o 1,020 400 o o o o o o o o 118,404 o o o o 52,994 4,311 150,794 6,025 792,416 4,946 1 11,400,572 4,364,860 178,043 2,580,716 6,642,888 210,189 3,668,186 785,603 65,987 o 25,110 115,305 440,438 129,476 504,293 1,408,027 332,483 827,618 1,200 o 33,680,994 17,479,797 1,816,603 1,520,138 670 89,554 2,122 o 6,632 1,082 405,000 91,883 216,097 o 73,050 o 1,398 3,988 306,679 41,371 o o o 204,173 90,583 160,801 6,025 4,045,431 39,253 24,621,815 9,104,278 457,138 5,131,797 16,317,762 745,159 7,174,552 1,578,257 1,978,000 50,000 318,220 371,035 1,566,810 1,418,958 2,134,134 4,596,585 2,874,195 1,329,033 3,000 o 81,770,728 38,192,984 4,029,607 1,764,301 1,000 752,309 1,000 1,000 1,000 10,473 405,000 383,765 896,594 o 916,100 o 67,795 153,575 613,356 727,743 o o o 1,026,993 2,455,187 2,258,907 244,000 11,675,919 123,154 13,221,243 4,739,418 279,095 2,551,081 9,674,874 534,970 3,506,366 792,654 1,912,013 50,000 293,110 255,730 1,126,372 1,289,482 1,629,841 3,188,558 2,541,712 501,415 1,800 o 48,089,734 20,713,187 2,213,004 244,163 330 662,755 -1,122 1,000 -5,632 9,391 o 291,882 680,497 o 843,050 o 66,397 149,587 306,677 686,372 o o o 822,820 2,364,604 2,098,106 237,975 7,630,488 83,901 53.7 52.1 61.1 49.7 59.3 71.8 48.9 50.2 96.7 100.0 92.1 68.9 71. 9 90.9 76.4 69.4 88.4 37.7 60.0 58.8 54.2 54.9 13.8 33.0 88.1 -112.2 100.0 -563.2 89.7 76.1 75.9 92.0 97.9 97.4 50.0 94.3 80.1 96.3 92.9 97.5 65.4 68.1 07,/13/2007 09:08:26 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/07 - 06/30/07 6 Months 6 Months 50.0% 50.0% Completed Remaining Cur Mo Y-T-D 2007 Unexpended Unexpended Expended Expended Budget Balance Percent PARKING SYSTEM REVENUE FUND 9,113 62,565 156,448 93,883 60.0 VEHICLE MAINTENANCE FUND 119,675 667,051 1,578,353 911,302 57.7 VEHICLE REPLACEMENT FUND 57,043 335,136 1,406,810 1,071,674 76.2 COMPUTER REPLACEMENT FUND 71,495 101,919 249,050 147,131 59.1 RISK MANAGEMENT FUND 539,868 3,353,198 6,585,214 3,232,016 49.1 POLICE PENSION FUND 204,179 1,226,084 2,465,133 1,239,049 50.3 FIRE PENSION FUND 220,449 1,332,711 2,627,958 1,295,247 49.3 SSA #6 GEORGE/ALBERT B&I 0 0 0 0 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 Total All Funds 6,999,574 33,680,994 81,770,728 48,089,734 58.8 2 07/13/2007 6 Months 50.0% Completed 09,04,18 VILLAGE OF MOUNT PROSPECT 6 Months 50.0% Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/07 - 06/30/07 Cur Mo Y-T-D 2007 Unexpended Unexpended PUBLIC REPRESENTATION Expended Expended Budget Balance Percent PROGRAM TOTALS 02 MAYOR AND BOARD OF TRUSTEES 4,862 77,323 111,270 33,947 30.5 03 ADVISORY BOARDS & COMMISSIONS 874 10,937 17,010 6,073 35.7 Totals 5,736 88,260 128,280 40,020 31.2 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 2,660 20,470 35,466 14,996 42.3 51 EMPLOYEE BENEFITS 509 3,633 6,361 2,728 42.9 52 OTHER EMPLOYEE COSTS 0 0 3,000 3,000 100.0 54 CONTRACTUAL SERVICES 2,332 63,144 77,353 14,209 18.4 55 UTILITIES 38 116 500 384 76.8 57 COMMODITIES & SUPPLIES 197 897 5,600 4,703 84.0 Totals 5,736 88,260 128,280 40,020 31.2 SOURCE OF FUNDS 001 GENERAL FUND 5,736 88,260 128,280 40,020 31. 2 Totals 5,736 88,260 128,280 40,020 31.2 1 07/13/2007 09:04:18 FRRDBROl SUM031 6 Months 6 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 06/30/07 VILLAGE MANAGER'S OFFICE Cur Mo Expended PROGRAM TOTALS 01 VILLAGE MANAGER'S OFFICE 02 LEGAL SERVICES 03 PERSONNEL SERVICES 04 INFORMATION TECHNOLOGY 05 PUBLIC INFORMATION 34,821 10,990 17,676 54,330 10,887 Totals 128,704 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 63,760 24,176 1,875 38,919 621 230 -877 o Totals 128,704 SOURCE OF FUNDS 001 GENERAL FUND 128,704 Totals 128,704 2 Y-T-D Expended 273,362 201,277 117,202 373,414 54,300 1,019,555 427,144 136,484 16,522 432,646 2,446 3,491 822 o 1,019,555 1,019,555 1,019,555 2007 Budget 509,550 630,750 287,303 921,335 143,372 2,492,310 898,539 281,625 46,400 1,215,596 10,145 11,485 26,920 1,600 2,492,310 2,492,310 2,492,310 50.0% 50.0% Completed Remaining Unexpended Unexpended Balance Percent 236,188 429,473 170,101 547,921 89,072 1,472,755 471,395 145,141 29,878 782,950 7,699 7,994 26,098 1,600 1,472,755 1,472,755 1,472,755 46.4 68.1 59.2 59.5 62.1 59.1 52.5 51.5 64.4 64.4 75.9 69.6 96 .9 100.0 59.1 59.1 59.1 07/13/2007 6 Months 50.0% Completed' 09,04,18 VILLAGE OF MOUNT PROSPECT 6 Months 50.0% Remaining FRRDBROl SUM 031 Department Budget Expenditure Sununary 01/01/07 - 06/30/07 Cur Mo Y-T-D 2007 Unexpended Unexpended TV SERVICES DIVISION Expended Expended Budget Balance Percent PROGRAM TOTALS 02 CABLE TV OPERATIONS 8,228 56,010 130,245 74,235 57.0 04 INTERGOVERNMENTAL PROGRAMMING 3,183 18,584 48,322 29,738 61. 5 Totals 11,411 74,594 178,567 103,973 58.2 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 7,204 45,992 102,484 56,492 55.1 51 EMPLOYEE BENEFITS 3,617 19,739 41,133 21,394 52.0 52 OTHER EMPLOYEE COSTS 0 535 2,650 2,115 79.8 54 CONTRACTUAL SERVICES 334 3,708 13,150 9,442 71.8 55 UTILITIES 256 886 1,600 714 44.6 57 COMMODITIES & SUPPLIES 0 2,681 7,050 4,369 62.0 67 OTHER EQUIPMENT 0 1,053 10,500 9,447 90.0 Totals 11,411 74,594 178,567 103,973 58.2 SOURCE OF FUNDS 001 GENERAL FUND 11,411 74,594 178,567 103,973 58.2 Totals 11,411 74,594 178,567 103,973 58.2 3 07!13/2007 6 Months 50.0% Completed 09:04:18 VILLAGE OF MOUNT PROSPECT 6 Months 50.0% Remaining FRRDBROl SUM 031 Department Budget Expenditure Swmnary 01/01/07 - 06/30/07 Cur Mo Y-T-D 2007 Unexpended Unexpended VILLAGE CLERK'S OFFICE Expended Expended Budget Balance Percent PROGRAM TOTALS 02 VILLAGE CLERK'S OFFICE 14,544 94,482 205,188 110,706 54.0 Totals 14,544 94,482 205,188 110,706 54.0 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 8,538 56,112 113,075 56,963 50.4 51 EMPLOYEE BENEFITS 3,904 21,792 43,977 22,185 50.4 52 OTHER EMPLOYEE COSTS 0 105 2,625 2,520 96.0 54 CONTRACTUAL SERVICES 1,195 14,298 38,748 24,450 63.1 55 UTILITIES 128 271 1,650 1,379 83.6 57 COMMODITIES & SUPPLIES 779 1,904 5,113 3,209 62.8 Totals 14,544 94,482 205,188 110,706 54.0 SOURCE OF FUNDS 001 GENERAL FUND 14,544 94,482 205,188 110,706 54.0 Totals 14,544 94,482 205,188 110,706 54.0 4 07/13/2007 09:04:18 FRRDBROl SUM 031 6 Months 6 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 06/30/07 FINANCE DEPARTMENT Cur Mo Expended PROGRAM TOTALS 01 FINANCE ADMINISTRATION 02 ACCOUNTING 04 DUPLICATING SERVICES 05 INSURANCE PROGRAMS 06 CUSTOMER SERVICES 07 CASH MANAGEMENT 24,532 36,873 o 50,741 29,013 2,776 Totals 143,935 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 60,382 26,132 730 9,422 487 45,061 1,721 o Totals 143,935 SOURCE OF FUNDS 001 GENERAL FUND 143,935 Totals 143,935 5 Y-T-D Expended 160,140 219,175 o 259,426 189,863 16,472 845,076 369,674 142,211 3,792 95,342 1,466 225,303 6,988 300 845,076 845,076 845,076 2007 Budget 301,287 444,679 o 521,445 409,237 49,732 1,726,380 796,825 295,144 10,640 137,776 5,150 450,605 24,240 6,000 1,726,380 1,726,380 1,726,380 50.0% 50.0% Unexpended Balance 141,147 225,504 o 262,019 219,374 33,260 881,304 427,151 152,933 6,848 42,434 3,684 225,302 17,252 5,700 881,304 881,304 881,304 Completed' Remaining Unexpended Percent 46.8 50.7 50.2 53.6 66.9 51.0 53.6 51. 8 64.4 30.8 71.5 50.0 71. 2 95.0 51.0 51. 0 51.0 07/13/2007 09:04:18 FRRDBROl SUM03l 6 Months 6 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 06/30/07 COMMUNITY DEVELOPMENT Cur Mo Expended PROGRAM TOTALS 01 COMMUNITY DEVELOPMENT ADMIN 02 PLANNING & ZONING 03 ECONOMIC DEVELOPMENT 05 BUILDING INSPECTIONS 06 HOUSING INSPECTIONS 07 HEALTH INSPECTIONS 18,764 19,811 10,005 62,334 39,553 9,825 Totals 160,292 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 98,593 45,464 1,177 13,736 1,664 -342 o Totals 160,292 SOURCE OF FUNDS 001 GENERAL FUND 550 DOWNTOWN REDEVLPMNT CONST 160,292 o Totals 160,292 6 Y-T-D Expended 112,937 121,491 51,327 367,242 205,123 58,135 916,255 576,220 242,172 11,456 73,590 6,255 6,562 o 916,255 915,355 900 916,255 2007 Budget 240,629 265,580 109,436 812,491 490,180 128,318 2,046,634 1,255,645 497,667 30,563 212,484 18,555 18,720 13,000 2,046,634 2,045,734 900 2,046,634 50.0% 50.0% Completed Remainirig Unexpended Unexpended Balance Percent 127,692 144,089 58,109 445,249 285,057 70,183 1,130,379 679,425 255,495 19,107 138,894 12,300 12,158 13,000 1,130,379 1,130,379 o 1,130,379 53.1 54.3 53.1 54.8 58.2 54.7 55.2 54.1 51. 3 62.5 65.4 66.3 64.9 100.0 55.2 55.3 55.2 07/13/2007 09:04:18 FRRDBROl SUM 031 6 Months 6 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 06/30/07 COMMUNITY DEVELOPMENT - CDBG Cur Mo Expended PROGRAM TOTALS 04 CDBG ADMINISTRATION 05 CDBG COMMUNITY PROGRAMS 06 ACCESSIBLTY & NEIGHBRHD IMPRV 07 CDBG RESIDENTIAL REHAB 8,856 625 o 444 Totals 9,925 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 64 BUILDING IMPROVEMENTS 69 INFRASTRUCTURE 5,148 1,995 1,666 672 o 444 o o Totals 9,925 SOURCE OF FUNDS 070 COMMUNITY DEVELPMNT BLOCK GRNT 9,925 Totals 9,925 7 Y-T-D Expended 40,374 15,751 o 33,429 89,554 25,948 10,437 2,534 17,206 o 33,429 o o 89,554 89,554 89,554 2007 Budget 83,309 134,000 310,000 225,000 752,309 52,004 20,697 6,020 147,639 949 190,000 o 335,000 752,309 752,309 752,309 50.0% 50.0% Unexpended Balance 42,935 118,249 310,000 191,571 662,755 26,056 10,260 3,486 130,433 949 156,571 o 335,000 662,755 662,755 662,755 Completed Remaining Unexpended Percent 51. 5 88.2 100.0 85.1 88.1 50.1 49.6 57.9 88.3 100.0 82.4 100.0 88.1 88.1 88.1 07/13/2007 09:04:19 FRRDBROl SUM 031 6 Months 6 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 06/30/07 HUMAN SERVICES Cur Mo Expended PROGRAM TOTALS 01 HUMAN SERVICES ADMINISTRATION 02 SOCIAL SERVICES 03 NURSING/HEALTH SERVICES 04 SENIOR CTR. LEISURE ACTIVITIES 05 YOUTH ACTIVITIES 12,947 25,031 13,097 1,954 o Totals 53,029 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 34,690 14,373 293 2,895 701 77 o Totals 53,029 SOURCE OF FUNDS 001 GENERAL FUND 53,029 Totals 53,029 8 Y-T-D Expended 83,321 162,206 80,498 13,417 o 339,442 227,424 80,756 1,187 22,863 2,245 2,967 2,000 339,442 339,442 339,442 2007 Budget 176,277 342,827 191,981 44,922 o 756,007 478,186 171,605 3,900 53,601 8,000 37,215 3,500 756,007 756,007 756,007 50.0% 50.0% Completed Remaining Unexpended Unexpended Balance Percent 92,956 180,621 111,483 31,505 o 416,565 250,762 90,849 2,713 30,738 5,755 34,248 1,500 416,565 416,565 416,565 52.7 52.7 58.1 70.1 55.1 52.4 52.9 69.6 57.3 71.9 92.0 42.9 55.1 55.1 55.1 07/13/2007 09:04:19 FRRDBROl SUM 031 6 Months 6 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 06/30/07 POLICE Cur Mo Expended PROGRAM TOTALS 01 POLICE ADMINISTRATION 02 PATROL & TRAFFIC ENFORCEMENT 03 CRIME PREVTN & PUBLIC SERVICES 04 INVESTIGATIVE & JUVENILE PRGM 05 CROSSING GUARDS 06 EQUIPMENT MAINTENANCE 749,519 636,058 23,712 89,374 2,01l 78,353 Totals 1,579,027 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 622,532 802,933 16,095 121,737 4,330 9,532 725 1,143 Totals 1,579,027 SOURCE OF FUNDS 001 GENERAL FUND 060 LAW ENFORCEMENT BLOCK GRANT 080 ASSET SEIZURE FUND 085 DEA SHARED FUNDS FUND 086 DUI FINE FUND 1,577,507 o 500 o 1,020 Totals 1,579,027 Y-T-D Expended 1,436,341 3,782,832 129,948 552,703 14,720 389,533 6,306,077 3,886,085 1,531,167 73,782 726,892 16,091 54,254 7,355 10,451 6,306,077 6,296,653 670 2,122 o 6,632 6,306,077 9 2007 Budget 2,945,090 8,218,329 342,746 1,205,678 29,380 8ll,753 13,552,976 8,592,849 3,185,309 123,000 1,427,145 49,200 ll5,423 14,000 46,050 13,552,976 13,548,976 1,000 1,000 1,000 1,000 13,552,976 50.0% 50.0% Unexpended Balance 1,508,749 4,435,497 212,798 652,975 14,660 422,220 7,246,899 4,706,764 1,654,142 49,218 700,253 33,109 61,169 6,645 35,599 7,246,899 7,252,323 330 -1,122 1,000 -5,632 7,246,899 Completed Remaining Unexpended Percent 51. 2 54.0 62.1 54.2 49.9 52.0 53.5 54.8 51. 9 40.0 49.1 67.3 53.0 47.5 77.3 53.5 53.5 33.0 -1l2.2 100.0 -563.2 53.5 0"(/13/2007 09:04:19 FRRDBROl SUM031 6 Months 6 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 06/30/07 FIRE Cur Mo Expended PROGRAM TOTALS 01 FIRE ADMINISTRATION 02 FIRE DEPARTMENT OPERATIONS 03 FIRE TRAINING ACADEMY 04 FIRE PREVENTION 05 FIRE COMMUNICATIONS 06 EQUIPMENT MAINTENANCE 07 EMERGENCY PREPARDENESS PRGM 08 PAID-ON-CALL PROGRAM 09 EMERGENCY ASSISTANCE PROGRAM 10 FOREIGN FIRE INSURANCE 663,859 567,566 o 41,603 5,930 49,037 1,408 1,874 o 400 Totals 1,331,677 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 53 PENSION BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 64 BUILDING IMPROVEMENTS 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 543,825 725,507 3,760 o 40,268 5,619 11,747 o o 951 Totals 1,331,677 SOURCE OF FUNDS 001 GENERAL FUND 095 FOREIGN FIRE TAX BOARD FUND 1,331,277 400 Totals 1,331,677 10 Y-T-D Expended 1,052,576 3,285,898 14,546 245,967 29,283 242,343 10,764 10,406 o 1,082 4,892,865 3,209,067 1,274,468 44,031 473 239,559 25,383 72,055 586 o 27,243 4,892,865 4,891,783 1,082 4,892,865 2007 Budget 2,256,288 6,929,243 21,731 547,561 64,500 505,633 37,885 35,748 o 10,473 10,409,062 6,833,619 2,691,797 151,640 473 459,819 43,200 131,039 4,000 4,000 89,475 10,409,062 10,398,589 10,473 10,409,062 50.0% 50.0% Unexpended Balance 1,203,712 3,643,345 7,185 301,594 35,217 263,290 27,121 25,342 o 9,391 5,516,197 3,624,552 1,417,329 107,609 o 220,260 17,817 58,984 3,414 4,000 62,232 5,516,197 5,506,806 9,391 5,516,197 Completed Remaining Unexpended Percent 53.3 52.6 33.1 55.1 54.6 52.1 71.6 70.9 89.7 53.0 53.0 52.7 71.0 47.9 41.2 45.0 85.4 100.0 69.6 53.0 53.0 89.7 53.0 07/13/2007 6 Months 50.0% Completed 09,0'4,19 VILLAGE OF MOUNT PROSPECT 6 Months 50.0% Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/07 - 06/30/07 Cur Mo Y-T-D 2007 Unexpended Unexpended PUBLIC WORKS - ADMINISTRATION Expended Expended Budget Balance Percent PROGRAM TOTALS 01 PUBLIC WORKS ADMINSTRATION 122,811 630,305 1,259,759 629,454 50.0 Totals 122,811 630,305 1,259,759 629,454 50.0 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 18,432 116,107 237,193 121,086 51. 0 51 EMPLOYEE BENEFITS 12,761 67,838 135,476 67,638 49.9 52 OTHER EMPLOYEE COSTS 3,040 10,149 30,095 19,946 66.3 54 CONTRACTUAL SERVICES 84,401 419,274 821,835 402,561 49.0 55 UTILITIES 2,223 7,941 18,990 11,049 58.2 57 COMMODITIES & SUPPLIES 1,776 8,590 14,475 5,885 40.7 65 OFFICE EQUIPMENT 0 0 1,090 1,090 100.0 67 OTHER EQUIPMENT 178 406 605 199 32.9 Totals 122,811 630,305 1,259,759 629,454 50.0 SOURCE OF FUNDS 001 GENERAL FUND 122,811 630,305 1,259,759 629,454 50.0 Totals 122,811 630,305 1,259,759 629,454 50.0 11 07/13/2007 09,04,19 FRRDBROl SUM 031 6 Months 6 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 06/30/07 PUBLIC WORKS - STREETS/BLDGS Cur Mo Expended PROGRAM TOTALS 01 STREET DIVISION ADMINISTRATION 02 MAINTENANCE - PUBLIC BUILDINGS 04 STREET MAINTENANCE 05 SNOW REMOVAL 06 LEAF REMOVAL 07 STORM SEWER & BASIN MAINT 08 MAINTENANCE OF STATE HIGHWAYS 09 TRAFFIC SIGN MAINTENANCE 10 VILLAGE PARKING LOT MAINT 11 PARKING LOT MAINTENANCE 12 FLOOD CONTROL 9,617 63,032 29,207 24,543 o 16,721 4,597 11,775 4,946 9,113 o Totals 173,551 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 64 BUILDING IMPROVEMENTS 67 OTHER EQUIPMENT 69 INFRASTRUCTURE 80 INTERFUND TRANSFERS 84,669 30,611 27,541 674 317 13,844 o o 12,902 2,993 o Totals 173,551 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 620 VILLAGE PARKING SYSTEM FUND 630 PARKING SYSTEM REVENUE FUND 157,768 1,724 4,946 9,113 Totals 173,551 12 Y-T-D Expended 69,014 390,570 121,473 497,766 o 77,439 34,925 56,282 39,253 62,565 o 1,349,287 643,636 191,811 216,270 5,928 1,587 273,925 o o 12,902 3,228 o 1,349,287 1,047,639 199,830 39,253 62,565 1,349,287 2007 Budget 146,860 1,002,815 514,141 445,928 o 178,890 70,548 119,916 123,154 156,448 o 2,758,700 1,108,580 354,511 696,035 134,644 3,172 300,993 o 6,365 19,400 135,000 o 2,758,700 2,255,928 223,170 123,154 156,448 2,758,700 50.0% 50.0% Unexpended Balance 77,846 612,245 392,668 -51,838 o 101,451 35,623 63,634 83,901 93,883 o 1,409,413 464,944 162,700 479,765 128,716 1,585 27,068 o 6,365 6,498 131,772 o 1,409,413 1,208,289 23,340 83,901 93,883 1,409,413 Completed Remainin:g Unexpended Percent 53.0 61.1 76.4 -11.6 56.7 50.5 53.1 68.1 60.0 51.1 41.9 45.9 68.9 95.6 50.0 9.0 100.0 33.5 97.6 51.1 53.6 10.5 68.1 60.0 51.1 07/13/2007 09:04:19 FRRDBROl SUM 031 6 Months 6 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 06/30/07 PUBLIC WORKS - FORESTRY/GRNDS Cur Mo Expended PROGRAM TOTALS 01 FORESTRY DIVISION ADMIN 02 MAINTENANCE OF GROUND 03 FORESTRY PROGRAM 04 PUBLIC GROUNDS BEAUTIFICATION 16,561 49,191 73,018 10,386 Totals 149,156 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT 65,077 21,879 o 52,295 9,905 o Totals 149,156 SOURCE OF FUNDS 001 GENERAL FUND 690 RISK MANAGEMENT FUND 149,156 o Totals 149,156 13 Y-T-D Expended 99,805 212,179 352,872 23,304 688,160 324,598 109,556 456 222,920 17,115 13,515 688,160 688,160 o 688,160 2007 Budget 216,107 543,385 946,789 95,998 1,802,279 697,162 228,406 3,555 764,291 70,470 38,395 1,802,279 1,789,016 13,263 1,802,279 50.0% 50.0% Unexpended Balance 116,302 331,206 593,917 72,694 1,114,119 372,564 118,850 3,099 541,371 53,355 24,880 1,114,119 1,100,856 13,263 1,114,119 Completed Remaining Unexpended Percent 53.8 61. 0 62.7 75.7 61.8 53.4 52.0 87.2 70.8 75.7 64.8 61.8 61. 5 100.0 61.8 07/13/2007 09,04,19 FRRDBROl SUM 031 6 Months 6 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 06/30/07 PUBLIC WORKS - ENGINEERING Cur Mo Expended PROGRAM TOTALS 01 ENGINEERING SERVICES 05 TRAFFIC CNTRL & STREET LGHTNG 67,171 44,763 Totals 111,934 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 69 INFRASTRUCTURE 53,768 17,450 635 5,132 16,914 3,684 o o 14,351 Totals 111,934 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 79,847 32,087 Totals 111,934 14 Y-T-D Expended 365,825 166,997 532,822 298,481 93,923 1,197 36,376 72,731 15,763 o o 14,351 532,822 447,034 85,788 532,822 2007 Budget 768,027 526,180 1,294,207 622,116 191,927 5,390 146,669 249,000 26,985 530 1,590 50,000 1,294,207 1,010,867 283,340 1,294,207 50.0% 50.0% Unexpended Balance 402,202 359,183 761,385 323,635 98,004 4,193 110,293 176,269 11,222 530 1,590 35,649 761,385 563,833 197,552 761,385 Completed RemainirJg Unexpended Percent 52.4 68.3 58.8 52.0 51.1 77.8 75.2 70.8 41.6 100.0 100.0 71.3 58.8 55.8 69.7 58.8 07/13/2007 09,04',19 FRRDBROl SUM 031 6 Months 6 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 06/30/07 PUBLIC WORKS - WATER/SEWER Cur Mo Expended PROGRAM TOTALS 01 WATER & SEWER DIVISION ADMIN 02 MAINTENANCE OF BUILDINGS 03 MAINTENANCE OF GROUNDS 04 WATER SUPPLY MAINT & REPAIR 05 WATER DISTRBT MAINT & REPAIR 06 WATER VALVE/HYDRNT MAINT & REP 07 WATER METER MAINT & REPL 08 EQUIPMENT MAINTENANCE 09 SANITARY SEWER MAINT & REPAIR 10 WATER & SEWER SYSTEM IMPROV 12 LAKE MICHIGAN WATER SUPPLY 122,465 16,972 10,220 128,148 67,832 21,573 25,608 60,609 23,391 11,501 304,097 Totals 792,416 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 68 DISTRIBUTION SYSTEMS 71 BOND PRINCIPAL 139,312 56,181 1,327 484,987 46,524 13,566 27,322 o o 10,356 12,841 o Totals 792,416 SOURCE OF FUNDS 610 WATER AND SEWER FUND 792,416 Totals 792,416 15 Y-T-D Expended 700,313 81,423 31,112 347,890 296,398 144,712 165,938 303,046 183,464 504,998 1,286,137 4,045,431 786,309 297,490 12,167 2,171,883 67,643 67,832 81,223 o 409 56,182 504,293 o 4,045,431 4,045,431 4,045,431 2007 Budget 50.0% 50.0% Completed Remaining Unexpended Unexpended Balance Percent 1,468,391 193,622 102,407 945,024 1,443,752 364,297 355,821 606,091 524,861 2,223,348 3,448,305 11,675,919 1,783,337 633,956 33,625 5,738,343 202,875 135,664 205,285 o 7,415 801,285 2,134,134 o 11,675,919 11,675,919 11,675,919 768,078 112,199 71,295 597,134 1,147,354 219,585 189,883 303,045 341,397 1,718,350 2,162,168 7,630,488 997,028 336,466 21,458 3,566,460 135,232 67,832 124,062 o 7,006 745,103 1,629,841 o 7,630,488 7,630,488 7,630,488 52.3 57.9 69.6 63.2 79.5 60.3 53.4 50.0 65.0 77.3 62.7 65.4 55.9 53.1 63.8 62.2 66.7 50.0 60.4 94.5 93.0 76.4 65.4 65.4 65.4 07/13/2007 09,04,19 FRRDBROl SUM 031 6 Months 6 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 06/30/07 PUBLIC WORKS - REFUSE DISPOSAL Cur Mo Expended PROGRAM TOTALS 01 REFUSE DISPOSAL PROGRAM 02 REFUSE LEAF REMOVAL PROGRAM 331,659 10,481 Totals 342,140 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 14,543 5,667 o 314,265 51 5,266 2,348 Totals 342,140 SOURCE OF FUNDS 030 REFUSE DISPOSAL FUND 342,140 Totals 342,140 16 Y-T-D Expended 1,755,836 60,767 1,816,603 82,282 29,758 o 1,671,390 216 26,330 6,627 1,816,603 1,816,603 1,816,603 2007 Budget 3,825,838 203,769 4,029,607 230,544 71,446 1,785 3,654,352 590 52,660 18,230 4,029,607 4,029,607 4,029,607 50.0% 50.0% Completed Remaining Unexpended Unexpended Balance Percent 2,070,002 143,002 2,213,004 148,262 41,688 1,785 1,982,962 374 26,330 11,603 2,213,004 2,213,004 2,213,004 54.1 70.2 54.9 64.3 58.3 100.0 54.3 63.4 50.0 63.6 54.9 54.9 54.9 07/13/2007 09:04:19 FRRDBROl SUM 031 6 Months 6 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 06/30/07 PUBLIC WORKS - VEHICLE MAINT Cur Mo Expended PROGRAM TOTALS 01 VEHICLE DIVISION ADMINSTRATION 02 VEHICLE MAINTENANCE PROGRAM 14,231 105,444 Totals 119,675 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 49,446 20,163 o 12,056 128 37,882 o o o Totals 119,675 SOURCE OF FUNDS 660 VEHICLE MAINTENANCE FUND 119,675 Totals 119,675 17 Y-T-D Expended 85,291 581,760 667,051 301,834 110,570 130 31,796 571 221,650 o o 500 667,051 667,051 667,051 2007 Budget 50.0% 50.0% Completed' Remaining Unexpended Unexpended Balance Percent 185,783 1,392,570 1,578,353 695,541 237,031 2,250 78,151 1,060 555,370 o 530 8,420 1,578,353 1,578,353 1,578,353 100,492 810,810 911,302 393,707 126,461 2,120 46,355 489 333,720 o 530 7,920 911,302 911,302 911,302 54.1 58.2 57.7 56.6 53.4 94.2 59.3 46.1 60.1 100.0 94.1 57.7 57.7 57.7 07)13/2007 09,04,19 FRRDBROl SUM 031 6 Months 6 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 06/30/07 COMMUNITY SERVICE PROGRAMS Cur Mo Expended PROGRAM TOTALS 02 COMMUNITY GROUPS & MISC 03 4TH OF JULY & CIVIC EVENTS,ETC 04 HOLIDAY DECORATIONS 05 BLOOD DONOR PROGRAM 10,810 10,594 551 166 Totals 22,121 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 520 197 21,313 o 91 o Totals 22,121 SOURCE OF FUNDS 001 GENERAL FUND 22,121 Totals 22,121 18 Y-T-D Expended 49,452 12,418 16,129 1,193 79,192 3,189 1,055 66,195 o 8,842 -89 79,192 79,192 79,192 2007 Budget 126,100 136,685 87,178 2,887 352,850 88,650 16,210 208,875 o 29,115 10,000 352,850 352,850 352,850 50.0% 50.0% Completed Remaining Unexpended Unexpended Balance Percent 76,648 124,267 71,049 1,694 273,658 85,461 15,155 142,680 o 20,273 10,089 273,658 273,658 273,658 60.8 90.9 81. 5 58.7 77 .6 96 .4 93.5 68.3 69.6 100.9 77 .6 77.6 77 .6 07/13/2007 09:04:19 FRRDBROl SUM 031 6 Months 6 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 06/30/07 CAPITAL IMPROVEMENT PROJECTS Cur Mo Expended PROGRAM TOTALS 01 VILLAGE IMPROVEMENTS & EQUIP 02 COMMUNITY IMPROVEMENT PROJECTS 03 DOWNTOWN REDEVELOPMENT CONST 04 FLOOD CONTROL PROJECTS 06 STREET IMPROVEMENT PROJECTS 09 MOTOR EQUIPMENT REPLACEMENT 10 COMPUTER REPLACEMENT 52,994 o 4,311 6,025 449,011 57,043 71,495 Totals 640,879 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 55 UTILITIES 59 OTHER EXPENDITURES 62 LAND IMPROVEMENTS 64 BUILDING IMPROVEMENTS 65 OFFICE EQUIPMENT 66 MOBILE EQUIPMENT 67 OTHER EQUI PMENT 69 INFRASTRUCTURE 72 INTEREST EXPENSE 80 INTERFUND TRANSFERS 11,890 o 1,000 o o 73,995 105,575 750 447,669 o o Totals 640,879 SOURCE OF FUNDS 050 MOTOR FUEL TAX FUND 510 CAPITAL IMPROVEMENT FUND 550 DOWNTOWN REDEVLPMNT CONST 560 STREET IMPROVEMENT CONST FUND 590 FLOOD CONTROL CONST FUND 630 PARKING SYSTEM REVENUE FUND 670 VEHICLE REPLACEMENT FUND 680 COMPUTER REPLACEMENT FUND 298,217 52,994 4,311 150,794 6,025 o 57,043 71,495 Totals 640,879 19 Y-T-D Expended 204,173 o 89,683 6,025 1,395,321 335,136 101,919 2,132,257 110,722 o 32,647 o 24,524 104,419 440,438 7,224 1,390,448 21,835 o 2,132,257 1,234,520 204,173 89,683 160,801 6,025 o 335,136 101,919 2,132,257 2007 Budget 891,993 60,000 2,454,287 244,000 3,591,698 1,406,810 249,050 8,897,838 386,100 o 1,778,000 50,000 307,855 294,050 1,566,810 396,138 4,076,585 42,300 o 8,897,838 1,257,791 1,026,993 2,454,287 2,258,907 244,000 o 1,406,810 249,050 8,897,838 50.0% 50.0% Unexpended Balance 687,820 60,000 2,364,604 237,975 2,196,377 1,071,674 147,131 6,765,581 275,378 o 1,745,353 50,000 283,331 189,631 1,126,372 388,914 2,686,137 20,465 o 6,765,581 23,271 822,820 2,364,604 2,098,106 237,975 o 1,071,674 147,131 6,765,581 Completed Remaining Unexpended Percent 77.1 100.0 96 .3 97.5 61. 2 76.2 59.1 76.0 71.3 98.2 100.0 92.0 64.5 71.9 98.2 65.9 48.4 76.0 1.9 80.1 96 .3 92.9 97.5 76.2 59.1 76.0 07/13/2007 09:04:19 FRRDBROl SUM 031 6 Months 6 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 06/30/07 DEBT SERVICE Cur Mo Expended PROGRAM TOTALS 02 DEBT SERVICE - PROPERTY TAXES 03 DEBT SERVICE - TAX INCREMENT 04 DEBT SERVICE - H/R SALES TAX 1 05 DEBT SERVICE - H/R SALES TAX 2 06 SPECIAL SERVICE AREA B & I o o 118,404 o o Totals 118,404 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 71 BOND PRINCIPAL 72 INTEREST EXPENSE 73 BANK AND FISCAL FEES 80 INTERFUND TRANSFERS SOURCE OF FUNDS 140 180 190 230 290 340 350 360 380 390 400 430 440 830 o 88,124 30,280 o o Totals 118,404 SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2002A B&I, TIF SERIES 1999 B&I, TIF SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD SERIES 1998A B&I, STREET IMP. SERIES 2002B B&I, STREET IMP. SSA #6 GEORGE/ALBERT B&I o o o o o o o o 118,404 o o o o o Totals 118,404 20 Y-T-D Expended 712,980 77,038 349,448 o o 1,139,466 o 332,483 805,783 1,200 o 1,139,466 405,000 91,883 216,097 o 73,050 o 1,398 3,988 306,679 41,371 o o o o 1,139,466 2007 Budget 1,685,359 1,069,675 1,408,894 o o 4,163,928 o 2,874,195 1,286,733 3,000 o 4,163,928 405,000 383,765 896,594 o 916,100 o 67,795 153,575 613,356 727,743 o o o o 4,163,928 50.0% 50.0% Completed Remaining Unexpended Unexpended Balance Percent 972,379 992,637 1,059,446 o o 3,024,462 o 2,541,712 480,950 1,800 o 3,024,462 o 291,882 680,497 o 843,050 o 66,397 149,587 306,677 686,372 o o o o 3,024,462 57.7 92.8 75.2 72.6 88.4 37.4 60.0 72.6 76.1 75.9 92.0 97.9 97.4 50.0 94.3 72.6 07/13/2007 09:04:19 FRRDBROl SUM 031 6 Months 6 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 06/30/07 RETIREE PENSIONS Cur Mo Expended PROGRAM TOTALS 01 MISCELLANEOUS PENSIONS 02 POLICE PENSIONS 03 FIRE PENSIONS 3,nl 204,179 220,449 Totals 428,339 EXPENDITURE CLASSIFICATION 53 PENSION BENEFITS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 428,339 o o Totals 428,339 SOURCE OF FUNDS 001 GENERAL FUND 710 POLICE PENSION FUND 720 FIRE PENSION FUND 3,711 204,179 220,449 Totals 428,339 21 Y-T-D Expended 22,267 1,226,084 1,332,n1 2,581,062 2,580,243 750 69 2,581,062 22,267 1,226,084 1,332,711 2,581,062 2007 Budget 44,533 2,465,133 2,627,958 5,137,624 5,131,324 5,800 500 5,137,624 44,533 2,465,133 2,627,958 5,137,624 50.0% 50.0% Unexpended Balance 22,266 1,239,049 1,295,247 2,556,562 2,551,081 5,050 431 2,556,562 22,266 1,239,049 1,295,247 2,556,562 Completed' Remaining Unexpended Percent 50.0 50.3 49.3 49.8 49.7 87.1 86.2 49.8 50.0 50.3 49.3 49.8 07/13/2007 09,04,19 FRRDBROl SUM031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 06/30/07 6 Months 6 Months 50.0% 50.0% Completed Remainirlg Totals Cur Mo Y-T-D 2007 Unexpended Unexpended Expended Expended Budget Balance Percent 130,324 831,123 1,360,353 529,230 38.9 409,544 2,522,075 5,211,598 2,689,523 51.6 539,868 3,353,198 6,571,951 3,218,753 49.0 RISK MANAGEMENT PROGRAM TOTALS 01 CASUALTY & PROPERTY INSURANCE 02 MEDICAL INSURANCE EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 56 INSURANCE 67 OTHER EQUIPMENT Totals 0 6,064 34,000 27,936 82.2 539,868 3,347,134 6,532,451 3,185,317 48.8 0 0 5,500 5,500 100.0 539,868 3,353,198 6,571,951 3,218,753 49.0 SOURCE OF FUNDS 690 RISK MANAGEMENT FUND 539,868 3,353,198 6,571,951 3,218,753 49.0 Totals 539,868 3,353,198 6,571,951 3,218,753 49.0 22 07/13/2007 09':04: 19 FRRDBROl SUM 031 6 Months 6 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 06/30/07 NON-DEPARTMENTAL Cur Mo Expended Y-T-D Expended 2007 Budget Unexpended Percent PROGRAM TOTALS 01 CONTINGENCIES o o Totals o o EXPENDITURE CLASSIFICATION 80 INTERFUND TRANSFERS o o Totals o o SOURCE OF FUNDS 001 GENERAL FUND 560 STREET IMPROVEMENT CONST FUND 670 VEHICLE REPLACEMENT FUND o o o o o o Totals o o 23 50.0% Completed' 50.0% Remaining Unexpended Balance o o o o o o o o o o o o o o o o 07/13/2007 09:04:19 FRRDBROl SUM 031 6 Months 6 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 06/30/07 CAPITAL FIXED ASSETS Cur Mo Expended Unexpended Unexpended Balance Percent PROGRAM TOTALS 00 CAPITAL FIXED ASSETS Totals EXPENDITURE CLASSIFICATION 59 OTHER EXPENDITURES Totals SOURCE OF FUNDS 910 GENERAL FIXED ASSETS ACCT GP Totals 24 Y-T-D Expended 2007 Budget o o o o o o o o o o o o 50.0% Completed 50.0% Remaining o o o o o o o o o o o o 07/13/2007 09':04:19 FRRDBROl SUM 031 6 Months 6 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 06/30/07 MOUNT PROSPECT LIBRARY Cur Mo Expended Unexpended Unexpended Balance Percent PROGRAM TOTALS 02 LIBRARY SERVICES Totals EXPENDITURE CLASSIFICATION 90 COMPONENT UNIT EXPENDITURES Totals SOURCE OF FUNDS 950 MOUNT PROSPECT LIBRARY FUND Totals Y-T-D Expended o o o o o o 25 2007 Budget o 8,572,028 o 8,572,028 o 8,572,028 o 8,572,028 o 8,572,028 o 8,572,028 50.0% 50.0% Completed Remaining 8,572,028 100.0 8,572,028 100.0 8,572,028 100.0 8,572,028 100.0 8,572,028 100.0 8,572,028 100.0 VILLAGE OF MOUNT PROSPECT CASH POSITION July 01 -11,2007 Cash & Invstmt Receipts Disbursements Disbursements Cash & Invstmt Balance 07/01/07 Per Attached Per Attached Balance 07/01/07 07/11/07 List of Bills List of Bills 07/11/07 General Fund 8,885,019 898,015 642,901 9,140,133 Special Revenue Funds Refuse Disposal Fund 1,472,495 67,286 104,134 1,435,647 Motor Fuel Tax Fund 843,160 119,140 3,898 958,402 Local Law Enforcement Block Grant Fund 629 629 Community Development Blk Grant Fund 60,861 24,971 1,634 84,198 Asset Seizure Fund 79,600 79,600 DEA Shared Funds 50,160 50,160 DUI Fine Fund 42,039 42,039 Foreign Fire Tax Board Fund 52,710 1,500 51,210 Debt Service Funds 1,697,357 862,994 834,363 Capital Proiects Funds Capital Improvement Fund 758,950 19,427 739,523 Downtown Redevelopment Const Fund 2,002,849 2,002,849 Street Improvement Construction Fund 1,750,396 2,836 1,753,232 Flood Control Construction Fund 636,783 636,783 Enterprise Funds Water & Sewer Fund 4,633,830 381,678 322,388 4,693,120 Village Parking System Fund 85,416 3,077 3,646 84,847 Parking System Revenue Fund (14,722) 3,715 594 (11,601) Internal Service Funds Vehicle Maintenance Fund 539,634 302 28,109 511,827 Vehicle Replacement Fund 6,474,991 2,121 6,472,870 Computer Replacement Fund 700,738 1,152 699,586 Risk Management Fund 2,764,236 59,058 681 ,824 2,141,470 Trust & Aaencv Funds Police Pension Fund 40,455,652 26,512 5,000 40,477,164 Fire Pension Fund 40,344,263 23,400 5,650 40,362,013 Flexcomp Trust Fund 19,596 10,525 12,966 17,155 Escrow Deposit Fund 1,798,944 35,784 11,077 10,505 1,813,146 116,135,586 1,656,299 10,505 115,070,365 TOTAL DISBURSEMENTS PER ATTACHED LISTS OF BILLS 2,721,520 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY JUL112007 15: 59 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 01 2007 TO JULY 11 2007 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 001 02919 303 TAXI SENIOR TAXI PROGRAM 762.15 10217 AHERN, FRANK FINE ARTS FESTIVAL-AWARD 200.00 01227 AIR ONE EQUIPMENT, INC. VALVE,GLAND PACKING,WASHER 319.94 05205 AIRGAS NORTH CENTRAL OXYGEN SUPPLIES 197.00 01561 AMERICAN CHARGE SERVICE SENIOR TAXI DISCOUNT PROGRAM 29.00 01620 AMERICAN LANDSCAPING INC. REPLACEMENT PERENNIALS FOR VAR 2791.60 REPLACEMENT SHRUBS - VARIOUS 9864.50 CUT LAWN AT 1400 LINCOLN 252.00 CUT LAWN AT EMPTY LOT 1044.00 REPAIR RETAINING WALL ON PROSP 350.00 ------------- 14302.10 01670 AMERICAN PLANNING ASSOCIATION MEMBERSHIP DUES 365.00 09544 ANDRES MEDICAL BILLING,LTD AMBULANCE COLLECTION FEE 3532.34 02001 ARAMARK UNIFORM SERVICES, INC. UNI FORM EXPENSE /MECHANI CS 79.44 UNIFORM EXPENSE FOR MECHANICS 52.96 .------------ 132.40 02848 ARTHUR WEILER, INC. REPLACEMENT SHRUBS - VARIOUS 8731.00 10221 ASH FISK, NANCY FINE ARTS FESTIVAL-BOOTH REFUN 60.00 02270 AT&T ACCOUNT 84725321415772 944.00 PHONE SERVICE 84729929511565 1354.5 9 PHOME SERVICE 84729754147966 295.29 PHONE SERVICE 84725321517528 226.36 ------------- 2820.24 02566 BASIC FIRE PROTECTION INC. ANSUL & EXTINGUISHER TRAINING 2018.00 10218 BLACK, BARB FINE ARTS FESTIVAL-JUDGE 100.00 01006 BUSSE CAR WASH, INC. CAR WASH 6.50 01049 COW GOVERNMENT, INC APC REPLACEMENT BATTERY 11 0 . 99 01056 CENTRAL CONTINENTAL BAKERY PASTRY HAZMAT DRILL 38.88 01079 CHI CAGO HONEY BEAR DANCERS 4TH OF JULY PARADE 795.00 10236 CHRUSCIK, DANIEL DOWNPAYMENT ASSISTANCE-CHRUSCI 9775.00 07281 CL GRAPH I CS , INC. GUIDE TO CLEANING YOUR RENTAL 338.00 PRINTING SUMMER 2007 NEWSLETTE 7210.00 EXPERIENCE MT PROSPECT POSTCAR 505.71 REPORT: APBOARDRPT GENERATED: 09 AOG 06 16:39 RON: WEDNESDAY JOL112007 15: 59 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 01 2007 TO JULY 11 2007 - - - - -. - - - -.. -. -. -. - - - - -. - - - - - - - - - - - - - - - - - - - - - -. - - - - -- -. - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - -. - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - --- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - --- --- - -- ---. -- -- ----. ------- -- - -- - - ---- -- - -- -- - --- - - -- ----- -._------ ----- --. -- - -- - -- --- -- - ----- - ----------. ---- -- -- --- -- -._------ PRINTING 45.00 ------------- 8098.71 01123 CLESEN WHOLESALE SUPPLEMENT TO PO #S006856 15.00 800 - 4.5 POTTED ZONAL"PINK 1720.00 ------------ - 1735.00 01139 COLLEGE OF LAKE COUNTY REGISTRATION 278.00 01153 COMMUNITY CAB CO. SENIOR TAXI PROGRAM 134 6.2 5 00308 CONNOLLY I JUDY REIMBURSEMENT 59.79 06745 CROWN TROPHY FINE ARTS FESTIVAL-RIBBONS 46.20 09461 DEALMAKERS VOMP AD IN DEALMAKERS 800.00 10219 DESWICK, JAN FINE ARTS FESTIVAL AWARD WINNE 100.00 10220 ENGLEHARDT, NI CK FINE ARTS FESTIVAL AWARD WINNE 100.00 05843 ENH OMEGA PRE - EMPLOYMENT TESTING 814.00 PHYSICAL EXAM-T . NOWAK 497.00 --------- ---- 1311.00 06160 ENTERPRISE RENT - A-CAR RENTAL OF MID-SIZED PICKUP TRU 880.00 RENTAL OF (4) CARS FOR 3 MONTH 415.00 ------------- 1295.00 10125 FACTORY CLEANING 20" - 2000 RPM FLOOR BURNI SHER 1350.00 10222 FAREJOWI C I TRENA FINE ARTS FESTIVAL-AWARD WINNE 150.00 01374 FAWLEY I S INC. ACCOUNTABILITY TAGS 327.00 01377 FEDERAL EXPRESS CORP PASTAGE FOR LEGAL DOCUMENTS 18.67 DELIVERY FEE 11.18 FEDEX PICK-UP 35.47 FEDEX SHIP 12.03 DELIVERY TO KTJ 20.48 - --------- --- 97.83 08765 FIFTH THIRD BANK TEMPERATURE GUARD FOR VH COMP 780.25 01394 FIRE ENGINEERING SUBSCRIPTION/DAWSON 29.95 00102 FIRE PENSION FUND PAYROLL FOR - 070507 23399.79 07261 FRI ZANE, KEN 4TH OF JULY PARADE 350.00 09198 GE CAPITOL ID #90133712112 LEASE 117.18 ID #90133712112 LEASE 117 .16 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY JULl12007 15: 59 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 01 2007 TO JULY 11 2007 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - - - ~ - - - -. - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - -- - - - - - - - - - - - -- - - - - - - - -- - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- ID #90133712112 LEASE 117 .16 .----_.- --- -- 351.50 10234 GERAGHTY I KATHLEEN BURKE PHOTOGRAPHY SERVI CES 175.00 01522 GRAINGER INC. 10 Medaphene Scrubs 90365 76.80 20 . Sets of Knee Pads for 317.85 EAR PLUGS I SAFETY GLASSES 175.42 -----_.---. -- 570.07 06384 GRUMMEL, KATELYN FINE ARTS FESTIVAL-SCHOLARSHIP 700.00 01548 HAIGES MACHINERY I INC. EQUIPMENT MAINTENANCE 946.04 08948 HEART PRINTING INC. TSR FORMS 1368.00 09425 HSBC BUSINESS SOLUTIONS INV #0312050 42.87 INV #0336650 17.97 INV #565370 15.99 INV #04588700 41.92 PAST CHARGES RECONCILIATION 0.32 PAST CHARGES RECONCILIATION 7.19 PAST CHARGES RECONCILIATION 17.97 ---- --------- 144.23 10235 HUI ZAR I CARLOS REIMBURSE EXPENSES 40.00 00107 ICMA RETIREMENT TRUST. 457 PAYROLL FOR . 070507 20127.55 04271 ICSC REGISTER ELLEN DIVITA 70.00 04671 ILCA ANNUAL MEMBERSHIP FEE 375.00 00108 ILLINOIS DEPARTMENT OF REVENUE PAYROLL FOR - 070507 24478.41 PAYROLL FOR . 070607 4.08 -------- -- --- 24482.49 01675 ILLINOIS DEVELOPMENT COUNCIL IDC 2007 MEMBERSHIP 250.00 06752 ILLINOIS EPA ANNUAL NPDES FEE FOR STORM SEW 1000.00 01689 ILLINOIS GFOA TRAVEL & MEETINGS 255.00 REGISTRATION-CAROL WIDMER 255.00 TRAVEL & MEETINGS 180.00 ------------- 690.00 01122 ILLINOIS STATE DISBURSEMENT UNIT PAYROLL FOR . 070507 357.69 PAYROLL FOR - 070507 969.24 PAYROLL FOR - 070507 116.31 PAYROLL FOR - 070507 442.31 PAYROLL FOR . 070507 520.75 PAYROLL FOR - 070507 200.00 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY JUL112007 15: 59 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 01 2007 TO JULY 11 2007 - -.. - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- -- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- PAYROLL FOR - 070507 300.00 ---------.--- 2906.30 07433 IMAGETEC L P STAPLE CARTRIDGES FOR STUDIO 105.50 07433 IMAGETEC LP ID #90133759827 275.00 ID #90133759828 LEASE 356.00 POTROL COPIER LEASE PAYMENT 275.00 MONTHLY LEASE PAYMENT FOR TOSH 236.00 ID #90133643910 LEASE PMT. 320.35 COPIER LEASE PAYMENT FOR FEB- D 586 .13 ID #90133686576 LEASE PMT 320.35 -----------_. 2368.83 09562 IMRF PAYROLL FOR - 070507 433.58 PAYROLL FOR - 070507 36963.62 PAYROLL FOR - 070507 17601.67 ------------- 54998.87 10211 INFO- TECH RESEARCH GROUP INFO-TECH ANNUAL SUBSCRIPTION 420.00 09832 INTERNATIONAL UNION OF OPERATING ENGINEERS PAYROLL FOR - 070507 776.17 PAYROLL FOR - 070507 242.55 -- - ----- ____a 1018.72 01753 I PELRA IPELRA 50.00 09563 IRS PAYROLL FOR - 070507 193871.67 PAYROLL FOR - 070607 24.21 - - ---- -----.- 193895.88 01783 JOURNAL & TOPICS NEWSPAPERS INV #114839 LEGAL 115.46 INV #114B40 LEGAL 110 .44 INV #114841 LEGAL 110.44 INV #114842 LEGAL 110 .44 INV #114843 LEGAL 11 0 . 44 INV #114844 LEGAL 100.40 INV #114845 LEGAL 100.40 ------------- 758.02 10224 JOYCE, MAGGIE FINE ARTS FESTIVAL-AWARD WINNE 100.00 01794 KALE UNI FORMS I INC. UNIFORM SUPPLIES 100.40 09788 KARLSTEDT LANDSCAPE, INC. REPLACEMENT SHRUBS - VARIOUS 1917.00 09646 KENNING, KRAI G FINE ARTS FESTIVAL-MUSIC 650.00 01818 KERSTEIN, JUNE BLOOD DRIVE REIMBURSEMENT 30.20 01827 KLEIN, THORPE AND JENKINS, LTD. LEGAL SERVICES 37521.54 REPORT: APBOARDRPT GENERATED: 09 AOG 06 16:39 RON: WEDNESDAY JOL112007 15:59 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 01 2007 TO JULY 11 2007 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 10225 KONSEWI CZ, ANTHONY & GERAL YN REAL ESTATE TAX REBATE 850.00 01838 KRAMER TREE SPECIALISTS 2007 TREE REMOVAL CONTRACT 7998.50 2007 TREE REMOVAL CONTRACT 1300.50 ~.. - - - -- - - - -- 9299.00 10226 LAHLUM, JENNIFER FINE ARTS FESTIVAL-SCHOLARSHIP 700.00 05467 LEAD INSPECTORS, INC. LEAD INSPECTION FTB CONFORD CL 225.00 08631 LECHNER AND SONS 2007 UNIFORM RENTAL AND CLEANI 114.14 2007 UNIFORM RENTAL AND CLEANI 114.14 -----------.- 228.28 01918 LUNDSTROM I S NURSERY I INC. LANDSCAPING MAINTENANCE THROUG 6690.56 TURF MOWING AT VARIOUS LOCATIO 3203.07 ----- -------- 9893.63 09238 LYONS, PATRICK REIMBURSE EXPENSES 364.80 08775 MAGNET STREET MAGNETS 722.00 10227 MALEWCHIK, THIA FINE ARTS FESTIVAL-AWARD WINNE 100.00 00116 METRO FEDERAL CREDIT UNION PAYROLL FOR - 070507 2275.00 00117 METROPOLITAN ALLIANCE - POLICE PAYROLL FOR - 070507 739.00 04322 MIDDLETON, JOAN ELECTRONIC COMPONENTS 15.71 A VAYA DEMO 26.61 -------- - ---- 42.32 02046 MOBILE PRINT INC. BUSINESS CARDS/MEMO PADS 359.88 COURT TRANSMITTALS 403.34 --------- ---- 763.22 02064 MOTOROLA COMMUNICATIONS VEHICLE CHARGERS 2152.80 02066 MOUNT PROSPECT CHAMBER OF COMMERCE FULL PAGE AD IN COMM. GUIDE 1700.00 02105 NAGEL, KIMBERLEY REIMBURSE EXPENSES 383.18 00123 NATIONWIDE MUTUAL INSURANCE COMPANY PAYROLL FOR - 070507 17535.79 08857 NELLESSEN I JEFFREY FINE ARTS FESTIVAL-SCHOLARSHIP 700.00 02148 NEOPOST INC. POSTAGE MACHINE 3000.00 10212 NEU, HEIDI IPELRA TRAINING 17.46 SHRM CONFERENCE 111.55 ---.- --- ----- REPORT: APBOARDRPT GENERmD: 09 AUG 06 16:39 RUN: WEDNESDAY JUL1l2007 15: 5 9 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 01 2007 TO JULY 11 2007 PAGE DEPT VENDOR NBR INVOICE DESCRIPTION - - - ~ - - - - - ~ - - - - - - - - -. - - - - - - - - - - - - -- - - -. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - -- AMOUNT VENDOR NAME - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- 09783 NEWSCLIP NEWSCLIP-JUNE 2007 05256 NI COR SERVI CE 09228 NIU I L SHRM CONFERENCE 02189 NORTHWEST CENTRAL DISPATCH SYS SERVI CES RENDERED SERVI CES RENDERED 02199 NORTHWEST STATIONERS INC. FOLDERS FOR FILING 02210 NUMBERS AUTOMAT ION INC SHREDDER SERVICE AGREEMENT 02229 OFFI CE DEPOT BUILDING SUPPLIES ENV.HEALTH SUPPLIES PLANNING SUPPLIES ENV . HEALTH SUPPLIES OFFICE SUPPLIES OFFICE SUPPLIES (RECORDER) BUILDING SUPPLIES ADMIN. SUPPLIES BUILDING SUPPLIES ADMIN. SUPPLIES PLANNING SUPPLIES 10216 PAUL HALL CLUB WARRIORS D&BC 4TH OF JULY PARADE 05026 PAYFORMANCE CORP. LASER CHECK STOCK 0B758 PEACHTREE BUSINESS PRODUCTS PRINTING OF STATIC STICKERS 02304 PETTY CASH - POLICE DEPT. TRAINING TRAVEL & MEETING EMPLOYMENT TESTING OTHER SERVICES 04896 PETTY CASH-MANAGER' S OFFICE PARKING FOR WORKSHOP LUNCH MEETING FOR STATION 14 ELECTED OFFICIAL RECEPTION CERTIFICATES FOR OUTDOOR DINIG PLANT FOOD MANAGERS PARTY SUPPLIES TIP FOR CATERING TRUSTEE TIP FOR BUSSE FLORIST BAKERY FOR SPECIAL EVENTS JIMMY JOHN'S CLOSED SESSION JIMMY JOHN'S CLOSED SESSION SUPPLIES FOR BOARD MEETING SUPPPLIES FOR BOARD MEETING 129 .01 92.50 4853.91 325.00 39390.57 9847.60 49238.17 237.58 195.00 24.48 212.28 29.90 77. 00 58.23 39.99 53.76 22.41 26.28 2.65 14.99 561.97 900.00 554.00 63.00 104.60 20.00 55.97 21.00 201.57 20.00 21.31 14.08 6.29 3.12 54.31 20.00 10.00 7.57 72 .00 85.48 15.99 13 .82 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY JUL1l2007 15: 59 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 01 2007 TO JULY 11 2007 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -.- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- SUPPLIES FOR BOARD MEETING 21.98 SUPPLIES FOR BOARD MEETING 4.99 SUPPLIES FOR BOARD MEETING 6.09 --------- - --- 377.03 00124 POLICE PENSION FUND PAYROLL FOR - 070507 26199.89 04921 POPE, ELIZABETH A. PAYROLL FOR - 070507 923.08 05792 POWER SYSTEMS INC. Physical Training Equipment an 436.35 FRT. 4.80 --- ------ _.-- 441.15 08640 POWERTRON REPAIRS TO EMERGENCY GENERATOR 2435.99 07598 PRACKO, SCOTT & AMY OVERPAYMENT 72 .00 06988 PRO DIGITAL GRAPHICS REPLACEMENT WORK SHIRTS 320.00 02536 PROFORMA CUSTOMIZED GRAPHICS T-SHIRTS 199.40 08711 QUALITY MAINTENANCE SYSTEMS, INC. 2007 CONTRACT FOR CUSTODIAL SE 8276.85 2007 CONTRACT FOR CUSTODIAL SE 8276.85 .-------.---- 16553.70 09612 RISOLUTE, SCOTT REISSUED CHECK FOR SAFETY SHOE 108.50 09261 ROBERTS, JOAN FINE ARTS FESTIVAL-AWARD WINNE 100.00 02465 ROTARY LUNCH CLUB MT. PROSPECT /PROSPECT HTS ROTARY MEMBERSHIP 293.00 10213 SANT I, SETH REIMBURSE EXPENSES 95.16 10229 SEARLES, DAVE SIDEWALK SQUARE REIMBURSEMENT 188.00 10215 SEMINARS INC HOMEBUYER COUNSELING 99.00 10230 SHOEMAKER, MERRILYN FINE ARTS FESTIVAL-BOOTH REFUN 60.00 02546 SIDWELL COMPANY AERIAL PHOTOGRAPHY AND PLANIME 2370.00 05297 SPRINGFIELD HILTON LODGING 391.60 10228 STANDARD & ASSOCIATES PRE - EMPLOYMENT TESTING 375.00 EMPLOYMENT TESTING 375.00 ------------- 750.00 09165 STAPLES BUSINESS ADVANTAGE FOLD OUT SHEET PROTECTORS 188.65 SUPPLIES 139.40 SUPPLIES 99.98 ------------- 428.03 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY JUL1l2007 15: 59 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 01 2007 TO JULY 11 2007 -- - - ---- .-- --. ~ -- ------ - - -. - --- -. - - -- - -- ----- - --- - --- ----- -- ---- --- -.- - - -- --- - - ---- - - - - -- ------- - --- - -- - - - - - --- -- - -- -- -- - - -- - - - - - -- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - - - - - - -- -- - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - -- - - - - - - - - - - - -- 02660 SUBURBAN PRINTING INSPECTION REPORT PRINTING 107.00 10214 SULLIVANT, SCOTT REIMBURSE EXPENSES 30.00 05463 SUMMERFIELD FARMS DEPOSIT FOR RAINDEER 425.00 09915 SUPER WAREHOUSE GOV CANON S 3 5 BLACK TONER 216.00 HP BLACK TONER C8061A 88.00 C8061X TONER FOR 4100 428.00 Q5942X TONER FOR 4250 380.00 TOSHIBA TONER CARTRIDGE 84.00 --------- - --- 1196.00 09536 THOMPSON, ROSENTHAL & WATTS LLP LEGAL REPRESENTATION 5320.80 05508 TKB ASSOCIATES, INC. BUILDING FILE 4334.22 04276 TRUGREEN-CHEMLAWN NON SELECTIVE WEED CONTROL - 5780.00 05686 ULINE INC. DVD'S & CS'S STORAGE 138.31 08821 UNIFORMITY INCORPORATED UNI FORM SUPPLI ES 102.00 Uniforms/ Clothing 351.50 Uniforms/ Clothing 1239.49 ------------- 1692.99 02756 UNITED STATES POSTAL SERVI CE RENEWAL 75.00 00127 UNITED WAY PAYROLL FOR - 070507 313.35 07860 UPS STORE POSTAGE FOR LEGAL DOCUMENTS 58.06 09644 VASEY, MAUREEN FINE ARTS FESTIVAL-JUDGE 100.00 00128 VILLAGE OF MOUNT PROSPECT PAYROLL FOR - 070507 23895.84 04314 VILLAGE OF MOUNT PROSPECT - PAYROLL WIRES PAYROLL FOR - 070507 2395.86 10231 VOTZMEYER, LISA SIDEWALK SQ,REIMBURSEMENT 235.00 02860 WEST GROUP PAYMENT CENTER IL COMP. STATE BAR 395.05 00461 WIDMER, CAROL WALL ST JOURNAL SUBSCRIPTION 99.00 05746 WISCTF PAYROLL FOR - 070507 542.48 09149 WOLF, TERESA FINE ARTS FESTIVAL-SUPPLIES 94.70 10232 WOOD, MARLENE FINE ARTS FESTIVAL-JUDGE 100.00 10233 ZADWORNY, JOSEPH FINE ARTS FESTIVAL-BOOTH REFUN 60.00 TOTAL 642901.37 )30 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY JUL1l2007 15: 59 PAGE RELEASE ID : VI LLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 01 2007 TO JULY 11 2007 . - ~ - - - - - - -. - - - - - - - - - - - - - - - - - - - -. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - -- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - -- 09635 WELLS FARGO BANK TIPPING FEES 97667.78 FIXED COSTS 6465.94 --- - - ---_.- -- 104133.72 TOTAL 104133.72 050 01148 COMMONWEALTH EDISON STREET LIGHTS #0817084003 2897.89 05709 MEADE ELECTRIC CO. INC. 2007 TRAFFIC SIGNAL MAINTENANC 1000.00 TOTAL 3897.89 070 09198 GE CAP I TOL ID #90133712112 LEASE 117.16 10223 HIGHER UP MINISTRIES CDBG SUB. RECIPIENT 1000.00 05467 LEAD INSPECTORS, INC. LEAD BASED PAINT 275.00 02256 PADDOCK PUBLICATIONS, INC. CDBG 2008 62.10 08509 PROPERTY INSI GHT ORDER #S9637071 223 S ELMHURST 60.00 ORDER #S9636679 508 GARWOOD DR 60.00 ORDER #S9636867 1726 PHEASANT 60.00 ------------ - 180.00 TOTAL 1634.26 095 09425 HSBC BUSINESS SOLUTIONS INV #0116790 1499.99 TOTAL 1499.99 290 09852 BANK OF NEW YORK 1999 BOND P&I DUE 8/1/07 770000.00 1999 BOND P&i DUE 8.1-07 72750.00 ----- .----_.- 842750.00 TOTAL 842750.00 350 09852 BANK OF NEW YORK BANK FEES 300.00 TOTAL 300.00 360 09852 BANK OF NEW YORK BANK FEES 300.00 TOTAL 300.00 l80 06752 ILLINOIS EPA IEPA LOAN#2 L170856 P&I 15818.93 IEPA LOAN#2 L170856 P&I 3825.49 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY JUL1l2007 15: 59 PAGE 10 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 01 2007 TO JULY 11 2007 _ _ _ _ _ w _ _ _.. _ _ __ _.. ~.... _ _.. _.. _. _ _ _ _ _ _ _ _ _ _.... _ _ _ _ _ _........ _ _ _ _.... _ _ _ _ _ _ _ _ _ _ _ _ _ _.. _.. _ _ _ _.. _.. _ _ _ _.... _ _ _ _ _ _ _.. _.. _ _ _.. _.. _.. _ _ _ _ _.. _ _.. _.. _ _.. _ _ _ _.. _ _.. _ _ _ _ _ __ DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT -.. - - - -.. - - -.... - - - - - - - - - - -.. - - - - - - -.... - - - - -.. - - - - -...... - - - - - -.. - - - - - - - - - - - - - - - -.. - - - - - -................................ -........................ -.. -............ --............................ ----- --_.. ---- 19644.42 TOTAL 19644.42 510 09508 L- 3 COMMUNICATIONS MOBILE VISION IN CAR VIDEO SYS 10530.00 09813 MAVRON, INC. UNDERCOATING 950.00 10156 MERIDIAN IT INC. CONSULTING 300.00 10167 NEXGEN BUILDING SUPPLY SHIPPING CHARGES 75.00 192 CARTONS - 2 X 4 ARMSTRONG 5462.16 33 CARTONS - 2 X 2 ARMSTRONG 909.74 ------------- 6446.90 06406 SRBL ARCHITECHTS I LTD. FACILITY STUDY 1200.00 TOTAL 19426.90 610 01620 AMERI CAN LANDSCAPING INC. PARKWAY RESTORATION AT VARIOUS 685.81 PARKWAY RESTORATION AT VARIOUS 388.19 ------- ------ 1074.00 09852 BANK OF NEW YORK WATER 193977 .00 POWER 11602.00 O&M 17297.00 FIXED 83355.00 ------------- 306231.00 02849 BISHOP PLUMBING COMPANY 2007 CROSS CONNECTION SURVEYS 150.00 07281 CL GRAPHICS, INC. CCR-WATER QUALITY REPORT 1799.00 06160 ENTERPRISE RENT-A-CAR RENTAL OF (4) CARS FOR 3 MONTH 2185.00 01377 FEDERAL EXPRESS CORP COURIER SERVICES 2007 94.24 01544 HBK WATER METER SERVICE 2007 CONTRACT FOR WATER METER 1624.53 2007 CONTRACT FOR WATER METER 3829.26 2007 CONTRACT FOR WATER METER 1581.21 ----------....- 7035.00 07433 IMAGETEC LP MONTHLY LEASE PAYMENT FOR TOSH 236.00 08631 LECHNER AND SONS 2007 UNIFORM RENTAL AND CLEANI 114.13 2007 UNIFORM RENTAL AND CLEANI 114.13 -- -- --------- 228.26 01918 LUNDSTROM I S NURSERY I INC. TURF MOWING AT VARIOUS LOCATIO 486.33 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY JUL1l2007 15: 59 RELEASE ID : PAGE 11 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 01 2007 TO JULY 11 2007 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 09605 MURPHY, DANI EL J. HYDRANT PAINTING SERVICES 387.50 05256 NI COR SERVI CE 584.19 06988 PRO DIGITAL GRAPHICS REPLACEMENT WORK SHIRTS 320.00 09423 RONCO INDUSTRIAL SUPPLY HOLE SAW 320.24 0483 8 THIRD MILLENNIUM ASSOC. INC. UTILITY BILLING 1257.31 TOTAL 322388.07 520 08711 QUALITY MAINTENANCE SYSTEMS, INC. 2007 CONTRACT FOR CUSTODIAL SE 1822.86 2007 CONTRACT FOR CUSTODIAL SE 1822.86 ------- -- - .-. 3645.72 TOTAL 3645.72 530 08711 QUALITY MAINTENANCE SYSTEMS, INC. 2007 CONTRACT FOR CUSTODIAL SE 296 . 96 2007 CONTRACT FOR CUSTODIAL SE 296 . 96 -- ------ - - --- 593.92 TOTAL 593.92 )60 01187 AETNA TRUCK PARTS PUBLIC SAFETY ELECTRONIC STROB 533.40 09676 AMERICAN MESSAGING PAGER MESSAGING SERVICE 53.52 02283 ATLAS BOBCAT INC. BOBCAT OIL FILTER 134.76 06468 BP REPORT DELIVERY FEE 9.95 10196 GAS DEPOT INC. UNLEADED GASOLINE 23059.94 06691 JUST TIRES 4 - LT245/75R16 GOODYEAR SILEN 483.36 4 - LT235/85R16 GOODYEAR SILEN 443.72 STATE TIRE FEE 20.00 P225/60R16 GOODYEAR EAGLE RSA 970.92 STATE TIRE FEE 30.00 ------------- 1948.00 01872 LATTOF ARLINGTON HEIGHTS PARTS & SERVICE FOR JULY 2007 263.00 PARTS & SERVICE FOR JULY 2007 72.71 ------------. 335.71 01879 LEACH ENTERPRISES, INC. DEXTER WHEEL SEALS 286.61 DEXTER WHEEL CYLINDER 68.95 ----- - ------- 355.56 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY JUL1l2007 15: 59 RELEASE ID : PAGE 12 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 01 2007 TO JULY 11 2007 - - - -- - _.- -- -- - - --- - ----. -. ---.- ---- ---- --- - --. - - - - - -- -- -. -- --- --.. -- ------- ----- --- - ---... - -- -- - - -- --... - -... ------------- -- -- ---.... -- - --- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT --- - ----... - - --- --... - ------ -- ---...... - - --- ---... --- -... -- - --... --...... --- --- -- - -- -- ------- - ----- -- - --- --- - -... -- ------- -- - - ---... --- -- --- ------- - -- --- 01990 MCMASTER-CARR SUPPLY CO. SUPPLIES 156.30 02424 REX RADIATOR & WELDING CO, INC. INTERNATIONAL RADIATOR 661.00 09423 RONCO INDUSTRIAL SUPPLY HOLE SAW 118.0 5 02581 SOLVENT SYSTEMS INT I L. INC. GREASE GATOR AQUA PARTS WASHER 100.00 02684 TERRACE SUPPLY COMPANY GRIT SANDING DISC 593.74 RENTAL OF WELDING CYLINDERS FO 22.02 ---..._- ------- 615.76 02861 WEST S IDE TRACTOR SALES CONTROL VALVE SEAL KIT 26.72 TOTAL 28108.67 670 02319 AUTO COLOR BASECOAT BLACK PAINT 203.52 DITZLER EPOXY PRIMER 74.64 DITZLER PAINT REDUCER 36.76 ------ ------... 314.92 02402 REDISTRIP COMPANY MEDIA BLAST TRAILER PARTS 956.00 04951 SUBURBAN ACCENTS INC. INSTALL GRAPHICS & LETTERING 550.00 09028 ZIEBART TIDY CAR UNDERCOAT UNDERSIDE OF CAR 300.00 TOTAL 2120.92 680 08146 DELL MARKETING L. P . DELL OPTIPLEX 745 1'1/ E6600 PRO 1152.45 TOTAL 1152.45 690 10051 CCMSI W/C REIMBURSEMENT 34953.60 W/C REIMBURSEMENT 7 - 9- 07 119165.93 --- ---------- 154119.53 01102 GAB ROBINS N. A., INC - CmBANK PAYMENT OF INSURANCE CLAIMS 3044.07 06461 HELP HELP EXCESS LIABILITY 35730.00 01737 INTERGOVERNMENTAL PER. BEN. COOP CLAIMS ADMINISTRATION 42616.46 HMO MEDICAL 133856.68 LIFE INSURANCE 2176.74 PPO MEDI CAL 310280.48 --------- ---- 488930.36 TOTAL 681823.96 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY JULll2007 15: 5 9 PAGE 13 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 01 2007 TO JULY 11 2007 - - -- --. -- ----- --- .--- --- -- -- - - - -- -- - - - - - -.-- - -- - -- --- -- -- - ----- - -- -- - - - - - --- ---- - --------- - --- -- -- .-------- - ---- --- ---- ---- ------ -- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- 710 02637 BECKER, BURKE ASSOCIATES INC INVESTMENT ADVISORS 5000.00 TOTAL 5000.00 720 02637 BECKER, BURKE ASSOCIATES INC INVESTMENT ADVISORS 5000.00 06608 CARY J. COLLINS, P.C. LEGAL EXPENSE 650.00 TOTAL 5650.00 770 02513 ABERNETHY, JANET T. FLEX PLAN JULY, 07 277.77 04203 ADDANTE, ANTHONY FLEX PLAN 07/07 123.12 02667 BERUN, DAVID FLEX PLAN 07/07 1109.46 10085 BONNER, MARK FLEX PLAN 07/07 632.12 10081 BRATU, CATHY FLEX PLAN 07/07 184.82 00477 BURES, PAUL FLEX PLAN 07/07 38.50 08107 ERB, DAVID FLEX PLAN 07/07 1573.26 00330 FELTEN, BARBARA FLEX PLAN 07/07 90.00 07082 FONSECA, MICHAEL FLEX PLAN 07/07 480.00 00343 GUTIERREZ, JULIE M. FLEX PLAN 07/07 231.62 00345 HANNEMAN, LESTER A. FLEX PLAN 07/07 402.38 08928 HERMANN, JAMES FLEX PLAN 07/07 158.79 01765 JANONIS, MICHAEL E. FLEX PLAN 07/07 1028.26 10020 JAROG, LYNN FLEX PLAN 07/07 416.66 01902 LIVINGSTON, CHARLES E. FLEX PLAN 07/07 1075.84 01941 MALCOLM, JOHN FLEX PLAN 07/07 508.00 10089 ROSEN, JUDY FLEX PLAN 07/07 741.21 02473 RUMORE, CINDY JO FLEX PLAN 07/07 103.99 06868 SCHWEGLER, RICHARD FLEX PLAN 07/07 575.99 10090 SIWAK, FRANK FLEX PLAN 07/07 475.03 09237 SLOAN, CLARE FLEX PLAN 07/07 40.00 10091 SLOBE, STEVEN FLEX PLAN 07/07 250.00 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY JUL1l2007 15: 59 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 01 2007 TO JULY 11 2007 PAGE 14 DEPT VENDOR NBR -----.----------------------------------------------------------------------------------------------------------------------------- AMOUNT VENDOR NAME INVOICE DESCRIPTION 02631 ----------------------------------------------------------------------------------------------------------------------------------- 221. 00 02635 02644 02828 02901 790 10237 02689 02886 STEPHENSON, MI CHAEL R. FLEX PLAN 07/07 STEWARD, DALE R. FLEX PLAN 07/07 STRAHL, DAVID FLEX PLAN 07/07 WAGNER, JOHN R. FLEX PLAN 07/07 WULBECKER, JEFFREY A. FLEX PLAN 07/07 TOTAL 12966.46 205.00 HORWITZ, HORWITZ & ASSOCIATES, LTD REFUND OF OVERPAYMENT THIRD DISTRICT CIRCUIT COURT BOND MONEY BOND MONEY BOND MONEY WISCONSIN DEPARTMENT OF REVENUE WISC. INCOME TAX TOTAL GRAND TOTAL 1336.64 435.00 252.00 17.00 5612.00 1350.00 3335.00 10297.00 762.82 11076.82 2711015.54 REPORT: APBOARDRPT GENERATED: 09 AOG 06 16:39 RON: WEDNESDAY JOL11?007 15:59 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 01 2007 TO JULY 11 2007 SUMMARY BY FUND 001 GENERAL FUND 642901.37 030 REFUSE DISPOSAL FUND 104133.72 050 MOTOR FUEL TAX FUND 3897.89 070 COMMUNI TY DEVELPMNT BLOCK GRNT 1634.26 095 FOREIGN FIRE TAX BOARD FUND 1499.99 290 SERIES 1999 B&I, TIF 842750.00 350 SERIES 1998A B&I, FLOOD 300.00 360 SERIES 1998C B&I, TIF 300.00 380 IEPA FLOOD CONTROL LOANS B&I 19644.42 510 CAPITAL IMPROVEMENT FUND 19426.90 610 WATER AND SEWER FUND 322388.07 620 VILLAGE PARKING SYSTEM FUND 3645.72 630 PARKING SYSTEM REVENUE FUND 593.92 660 VEHI CLE MAINTENANCE FUND 28108.67 670 VEHI CLE REPLACEMENT FUND 2120.92 680 COMPUTER REPLACEMENT FUND 1152.45 690 RISK MANAGEMENT FUND 681823.96 710 POLICE PENSION FUND 5000.00 720 FIRE PENSION FUND 5650.00 770 FLEXCOMP ESCROW FUND 12966.46 790 ESCROW DEPOSIT FUND 11076.82 -----------..- TOTAL : 2711015.54 PAGE 15 Village of Mount Prospect List of Escrow Checks Presented to the Board of Trustees 06/28/07 To 07/10/07 VI/U::I/VI EMR025 Paid to Permit # ALLIED AC & HEATING CORP 071287 AMERICAN DECK BUILDERS INC 070955 AMI BEARINGS INC 061223 BABIARZ, RICHARD 070266 BONILLA, BARBARA 070454 BUETTNER, M 071237 A CHOJDECKI, CHRISTOPHER 061699 061699 DICK'S TILE SERVICE & SON INC 070622 DIRSMITH (TRUST), BRIAN 071086 DOMAIN, ENA 071272 DUFFY, KEVIN 070852 FOUR SEASONS INC 071306 GAMBER, MARK A 063417 GEISER-BERNER PLBG 071137 GEORGES GARAGE & DOORS 061939 HOLOWATYJ, IRENE 070819 ISA BRICK PAVING & LANDSCAPING 071294 LYSY, MITCHELL 071258 NALEPKA & KECINSKA, MIROSLAW & 071100 NSI SIGNS INC 071213 o LEARY, MICHAEL 071318 OAK TERACE APTS/ARUN KANNAN 070948 PAWELKO, PIOTR 070654 PICKWICK COMMONS WEST ASSOCIATION 070428 PLUMB IN TIME 071341 PRICE, STEVEN 071333 REGAN, MICHAEL RICK'S SEWER & DRAINAGE 070324 070802A RIIS, ROY 071274 ROURKE, TIMOTHY 0 STRZELEC, MARIUSZ SUN SPACE DESIGN/PARADISE ROOMS TORPHY, BARRY A VILLAGE SEWER 070056 062599 070169 070518 070100 070165 070206 070652 071061 071184 071196 VUONG, NGHIA AND CONNIE 071285 "d~'" .L Check # Amount 13000296 125.00 13000297 150.00 13000298 2,330.00 400.00 13000299 13000300 125.00 13000301 200.00 13000302 50.00 13000303 500.00 550.00 * 13000304 150.00 13000305 200.00 13000306 125.00 13000307 500.00 13000308 75.00 13000309 350.00 13000310 75.00 13000311 150.00 13000312 200.00 13000313 200.00 13000314 200.00 13000315 200.00 13000316 125.00 13000317 125.00 13000318 75.00 13000319 200.00 13000320 200.00 13000321 125.00 13000322 200.00 13000323 125.00 13000324 375.00 13000325 125.00 13000326 125.00 13000327 400.00 13000328 175.00 13000329 150.00 13000330 500.00 13000331 125.00 13000332 25.00 13000333 125.00 13000334 125.00 13000335 125.00 13000336 125.00 1,150.00 * 13000337 200.00 07/09/07 EMR025 Paid to Village of Mount Prospect List of Escrow Checks Presented to the Board of Trustees 06/28/07 To 07/10/07 Page 2 Permit # Check # Amount 125.00 WALLY BLATON 071321 13000338 070817 13000339 200.00 WOODRIDGE BUILDERS INC *** TOTAL NUMBER OF CHECKS 44 10,505.00