Loading...
HomeMy WebLinkAbout3. BILLS & FINANCIALS 04/18/2007 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE & EXPENDITURE SUMMARIES March 1 - March 31, 2007 04/10/2007 09:18:08 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/07 03/31/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 3,591,002 1,990,209 365,549 791,407 1,769,989 -3,292 162,437 37,622 1,091,903 o 9,796,826 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 SERIES 2003 PROJECT 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 4,103,662 806,011 148,888 5 10,086 4,570 131 108 219 143,057 134,487 207,919 o o 332,867 20,392 6,706 27,718 65,916 44,180 1 o o 4,037 o 373,760 135,930 2,817 1,291,065 5,398 7,796 157,253 113,207 19,076 645,667 514,843 468,895 1 Y-T-D Received 4,695,442 3,448,512 855,265 1,393,092 4,573,616 53,293 1,113,767 97,901 1,760,135 o 17,991,023 6,815,571 1,378,504 294,966 9 52,643 5,160 396 4,634 632 186,732 175,823 272,157 o o 474,607 50,169 16,548 39,667 162,413 108,772 1 o o 13,916 o 540,018 412,463 8,151 2,785,535 21,924 21,986 315,878 248,794 41,644 1,387,198 1,073,077 1,080,577 3 Months 9 Months 2007 Budget 10,740,712 15,384,659 2,954,888 16,480,809 21,409,733 553,000 5,501,950 271,240 4,972,704 60,000 78,329,695 35,785,983 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 o 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 25.0% 75.0% Unreceived Balance 6,045,270 11,936,147 2,099,623 15,087,717 16,836,117 499,707 4,388,183 173,339 3,212,569 60,000 60,338,672 28,970,412 2,922,247 1,333,784 991 497,166 -2,560 2,104 15,716 50,868 -185,732 218,677 654,093 o o 601,893 -50,169 32,819 48,840 420,520 626,478 -1 o o 248,884 o 680,034 1,298,637 23,849 8,363,565 74,814 89,114 1,257,475 844,832 147,903 5,086,741 3,052,423 3,012,713 Completed Remaining Unreceived Percent 56.3 77.6 71.1 91. 5 78.6 90.4 79.8 63.9 64.6 100.0 77.0 81. 0 67.9 81. 9 99.1 90.4 -98.5 84.2 77.2 98.8 **** * 55.4 70.6 55.9 66.5 55.2 72.1 85.2 94.7 55.7 75.9 74.5 75.0 77.3 80.2 79.9 77.3 78.0 78.6 74.0 73.6 04/10/2007 09,18,08 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/07 - 03/31/07 3 Months 9 Months 25.0% 75.0% Completed Remaining Cur Mo Y-T-D 2007 Unreceived Unreceived Received Received Budget Balance Percent ESCROW DEPOSIT FUND 0 0 0 0 SSA #6 GEORGE/ALBERT B&I 72 207 0 -207 SERIES 2002 LIBRARY BND ESCROW 87 251 0 -251 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 Total All Funds 9,796,826 17,991,023 78,329,695 60,338,672 77 .0 2 04/10/2007 3 Months 25.0% Completed 09:18:38 9 Months 75.0% Remaining FRRBRR03 VILLAGE OF MOUNT PROSPECT SUM 021 Budget Revenue by Category within Fund Sunnnary 01/01/07 - 03/31/07 Cur Mo Y-T-D 2007 Unreceived Unreceived Received Received Budget Balance Percent GENERAL FUND 40 PROPERTY TAXES 2,452,733 3,207,318 7,416,686 4,209,368 56.8 41 OTHER TAXES 476,752 1,010,462 8,447,000 7,436,538 88.0 42 LICENSES, PERMITS & FEES 365,964 850,745 2,935,250 2,084,505 71.0 43 INTERGOVERMENT REV. 638,419 1,079,341 14,162,700 13,083,359 92.4 44 CHARGES FOR SERVICE 107,526 386,162 1,551,507 1,165,345 75.1 45 FINES AND FORFEITS -7,551 44,766 531,000 486,234 91.6 46 INVESTMENT INCOME 43,407 129,674 397,000 267,326 67.3 47 REIMBURSEMENTS 22,785 64,899 189,740 124,841 65.8 48 OTHER REVENUE 3,627 42,204 155,100 112,896 72 .8 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL GENERAL FUND 4,103,662 6,815,571 35,785,983 28,970,412 81.0 REFUSE DISPOSAL FUND 40 PROPERTY TAXES 655,260 856,851 2,016,276 1,159,425 57.5 44 CHARGES FOR SERVICE 141,468 500,076 2,211,475 1,711,399 77.4 46 INVESTMENT INCOME 9,263 21,450 72,000 50,550 70.2 48 OTHER REVENUE 20 127 1,000 873 87.3 TOTAL REFUSE DISPOSAL FUND 806,011 1,378,504 4,300,751 2,922,247 67.9 MOTOR FUEL TAX FUND 43 INTERGOVERMENT REV. 142,949 276,593 1,587,500 1,310,907 82.6 46 INVESTMENT INCOME 6,937 18,373 34,750 16,377 47.1 47 REIMBURSEMENTS -998 0 6,500 6,500 100.0 TOTAL MOTOR FUEL TAX FUND 148,888 294,966 1,628,750 1,333,784 81.9 LAW ENFORCEMENT BLOCK GRANT 43 INTERGOVERMENT REV. 0 0 1,000 1,000 100.0 46 INVESTMENT INCOME 5 9 0 -9 TOTAL LAW ENFORCEMENT BLOCK GRANT 5 9 1,000 991 99.1 COMMUNITY DEVELPMNT BLOCK GRNT 43 INTERGOVERMENT REV. 10,039 37,158 489,809 452,651 92 .4 46 INVESTMENT INCOME 47 112 0 -112 48 OTHER REVENUE 0 15,373 60,000 44,627 74.4 TOTAL COMMUNITY DEVELPMNT BLOCK GRNT 10,086 52,643 549,809 497,166 90.4 ASSET SEIZURE FUND 45 FINES AND FORFEITS 4,259 4,259 1,000 -3,259 -325.9 46 INVESTMENT INCOME 311 901 1,600 699 43.7 TOTAL ASSET SEIZURE FUND 4,570 5,160 2,600 -2,560 -98.5 DEA SHARED FUNDS FUND 45 FINES AND FORFEITS 0 0 1,000 1,000 100.0 46 INVESTMENT INCOME 131 396 1,500 1,104 73.6 1 04/10/2007 09,18,38 FRRBRR03 SUM 021 3 Months 9 Months 25.0% 75.0% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 03/31/07 Cur Mo Received TOTAL DEA SHARED FUNDS FUND 131 DUI FINE FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME o 108 TOTAL DUI FINE FUND 108 FOREIGN FIRE TAX BOARD FUND 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES o 219 o TOTAL FOREIGN FIRE TAX BOARD FUND 219 SERIES 1987A B&I, PW FACILITY 40 46 PROPERTY TAXES INVESTMENT INCOME 142,371 686 TOTAL SERIES 1987A B&I, PW FACILITY 143,057 SERIES 2001 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 133,895 592 o TOTAL SERIES 2001 B&I, VILLAGE HALL 134,487 SERIES 2003 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 206,743 1,176 o TOTAL SERIES 2003 B&I, VILLAGE HALL 207,919 SERIES 2002B B&I, PUBLIC BLDGS 40 PROPERTY TAXES 46 INVESTMENT INCOME 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 330,092 2,775 o 2 Y-T-D Received 396 4,268 366 4,634 o 632 o 632 185,837 895 186,732 175,088 735 o 175,823 270,348 1,809 o 272,157 o o o o o o 468,735 5,872 o 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 o 1,053,500 23,000 o o o o o o o unreceived Balance 2,104 15,732 -16 15,716 46,500 4,368 o 50,868 Completed Remaining Unreceived Percent 84.2 78.7 -4.6 77.2 100.0 87.4 98.8 -184,837 ****.* -895 -185,732 215,412 3,265 o 218,677 645,902 8,191 o 654,093 584,765 17,128 o ****..* 55.2 81. 6 55.4 70.5 81.9 70.6 o o o o o o 55.5 74.5 04/10/2007 09,18:38 FRRBRR03 SUM 021 3 Months 9 Months Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 - 03/31/07 Cur Mo Received Y-T-D Received 2007 Budget Unreceived Balance 25.0% 75.0% Completed Remaining Unreceived Percent TOTAL SERIES 1999 B&I, TIF 332,867 55.9 SERIES 1996A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 20,198 194 TOTAL SERIES 1996A B&:I, FLOOD 20,392 SERIES 1998A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 6,639 67 TOTAL SERIES 1998A B&I, FLOOD 6,706 SERIES 1998C B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 27,356 362 TOTAL SERIES 1998C B&I, TIF 27,718 IEPA FLOOD CONTROL LOANS B&I 41 OTHER TAXES 46 INVESTMENT INCOME 65,454 462 TOTAL IEPA FLOOD CONTROL LOANS B&I 65,916 SERIES 2000 B&I, FLOOD CONTROL 41 OTHER TAXES 46 INVESTMENT INCOME 43,814 366 TOTAL SERIES 2000 B&I, FLOOD CONTROL 44,180 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. 3 474,607 49,975 194 50,169 16,427 121 16,548 38,846 821 39,667 161,951 462 162,413 108,406 366 108,772 o 1 1 o o o o o o 1,076,500 49,067 300 49,367 87,307 1,200 88,507 582,933 o 582,933 728,000 7,250 735,250 o 1 1 o o o o o o o o 601,893 -49,975 -194 -50,169 o 32,640 179 32,819 48,461 379 48,840 420,982 -462 420,520 619,594 6,884 o o o 626,478 o o o o o o 66.5 59.7 66.5 55.5 31. 6 55.2 72 .2 72.1 85.1 95.0 85.2 o -1 -1 o o o o o o 04/10/2007 3 Months 25.0% Completed 09:18:38 PROSPECT 9 Months 75.0% Remaining FRRBRR03 VILLAGE OF MOUNT SUM 021 Budget Revenue by Category within Fund Swmnary 01/01/07 03/31/07 Cur Mo Y-T-D 2007 Unreceived Unreceived Received Received Budget Balance Percent CAPITAL IMPROVEMENT FUND 43 INTERGOVERMENT REV. 0 0 239,800 239,800 100.0 46 INVESTMENT INCOME 4,037 12,269 8,500 -3,769 -44.3 47 REIMBURSEMENTS 0 0 0 0 48 OTHER REVENUE 0 1,647 14,500 12,853 88.6 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL CAPITAL IMPROVEMENT FUND 4,037 13,916 262,800 248,884 94.7 SERIES 2003 PROJECT FUND 46 INVESTMENT INCOME 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2003 PROJECT FUND 0 0 0 0 DOWNTOWN REDEVLPMNT CONST 41 OTHER TAXES 365,828 519,480 1,167,552 648,072 55.5 46 INVESTMENT INCOME 7,932 20,538 52,500 31,962 60.9 47 REIMBURSEMENTS 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL DOWNTOWN REDEVLPMNT CONST 373,760 540,018 1,220,052 680,034 55.7 STREET IMPROVEMENT CONST FUND 41 OTHER TAXES 129,867 395,486 1,688,700 1,293,214 76.6 42 LICENSES, PERMITS & FEES 0 0 0 0 46 INVESTMENT INCOME 6,063 16,977 22,400 5,423 24.2 48 OTHER REVENUE 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL STREET IMPROVEMENT CONST FUND 135,930 412,463 1,711,100 1,298,637 75.9 FLOOD CONTROL CONST FUND 41 OTHER TAXES 0 0 0 0 46 INVESTMENT INCOME 2,817 8,151 32,000 23,849 74.5 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL FLOOD CONTROL CONST FUND 2,817 8,151 32,000 23,849 74.5 WATER AND SEWER FUND 41 OTHER TAXES 524,209 678,744 1,534,100 855,356 55.8 42 LICENSES, PERMITS & FEES 1,610 4,020 12,000 7,980 66.5 44 CHARGES FOR SERVICE 742,429 2,037,346 9,420,000 7,382,654 78.4 46 INVESTMENT INCOME 19,954 51,989 168,000 116,011 69.1 47 REIMBURSEMENTS 1,083 1,083 0 -1,083 48 OTHER REVENUE 1,780 12,353 15,000 2,647 17.6 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL WATER AND SEWER FUND 1,291,065 2,785,535 11,149,100 8,363,565 75.0 4 '04/10/2007 09:18:39 FRRBRR03 SUM 021 3 Months 9 Months 25.0% 75.0% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 03/31/07 Cur Mo Received VILLAGE PARKING SYSTEM FUND 42 LICENSES, PERMITS & FEES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES -2,025 7,120 303 o TOTAL VILLAGE PARKING SYSTEM FUND 5,398 PARKING SYSTEM REVENUE FUND 42 LICENSES, PERMITS & FEES 43 INTERGOVERMENT REV. 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES o o 7,796 o o o TOTAL PARKING SYSTEM REVENUE FUND 7,796 VEHICLE MAINTENANCE FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 155,595 1,658 o TOTAL VEHICLE MAINTENANCE FUND 157,253 VEHICLE REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 84,963 28,244 o o TOTAL VEHICLE REPLACEMENT FUND 113,207 COMPUTER REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 15,872 3,204 TOTAL COMPUTER REPLACEMENT FUND 19,076 RISK MANAGEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 507,220 7,552 14,752 116,143 TOTAL RISK MANAGEMENT FUND 645,667 POLICE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE 9,916 504,927 TOTAL POLICE PENSION FUND 514,843 5 Y-T-D Received 500 20,569 855 o 21,924 o o 21,986 o o o 21,986 311,189 4,689 o 315,878 169,925 78,869 o o 248,794 32,573 9,071 41,644 1,093,790 25,197 31,919 236,292 1,387,198 321,124 751,953 1,073,077 2007 Budget 7,638 88,500 600 o 96,738 o o 110,000 1,100 o o 111,100 1,555,953 17,400 o 1,573,353 849,626 184,000 o 60,000 1,093,626 159,547 30,000 189,547 5,463,125 92,000 75,000 843,814 6,473,939 2,131,000 1,994,500 4,125,500 Unreceived Balance 7,138 67,931 -255 o 74,814 o o 88,014 1,100 o o 89,114 1,244,764 12,711 o 1,257,475 679,701 105,131 o 60,000 844,832 126,974 20,929 147,903 4,369,335 66,803 43,081 607,522 5,086,741 1,809,876 1,242,547 3,052,423 Completed Remaining Unreceived Percent 93.5 76.8 -42.5 77.3 80.0 100.0 80.2 80.0 73.1 79.9 80.0 57.1 100.0 77.3 79.6 69.8 78.0 80.0 72 .6 57.4 72.0 78.6 84.9 62.3 74.0 04/10/2007 09,18,39 FRRBRR03 SUM 021 3 Months 9 Months 25.0% 75.0% Completed Remaining Budget VILLAGE Revenue by 01/01/07 OF MOUNT PROSPECT Category within Fund Summary - 03/31/07 FIRE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE TOTAL FIRE PENSION FUND ESCROW DEPOSIT FUND 46 INVESTMENT INCOME TOTAL ESCROW DEPOSIT FUND SSA #6 GEORGE/ALBERT B&I 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SSA #6 GEORGE/ALBERT B&I 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 Cur Mo Y-T-D 2007 Unreceived Unreceived Received Received Budget Balance Percent 3,489 380,391 2,204,500 1,824,109 82.7 465,406 700,186 1,888,790 1,188,604 62.9 468,895 1,080,577 4,093,290 3,012,713 73.6 o o o o o o o o o 72 o 207 o o o -207 72 207 o -207 87 251 o -251 87 251 o -251 o o o o o o o o o o o o o o 8,572,028 8,572,028 100.0 o o 8,572,028 8,572,028 100.0 6 '04/10/2007 09:17:14 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/07 03/31/07 Cur Mo Expended Y-T-D Expended 2007 Budget 25.0% 75.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 2002B B&I, PUBLIC BLDGS SERIES 2002A B&I, TIF SERIES 1999 8&1, 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 SERIES 2003 PROJECT FUND DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST FUND 2,192,369 683,898 23,477 417,729 1,393,184 41,951 570,214 242,353 52 o 483 213 56,272 33,389 24,585 o o o 600 o 5,680,769 3,163,149 483,589 139,365 o 8,420 o o o o o o 300 o o 300 o o o o o o o o 57,700 o 1,173 o o 1 5,939,389 1,373,825 80,040 1,259,086 2,687,064 83,017 1,891,301 373,143 4,726 o 483 3,169 61,902 47,263 25,285 6,293 115,018 404,212 900 o 14,356,116 7,901,633 787,197 152,106 o 24,049 801 o o 209 405,000 o 300 o o 73,050 o o o 19,645 300 o o o 71,574 o 36,202 o o 24,621,815 6,470,038 452,438 5,131,324 16,012,741 745,159 7,105,878 1,566,987 1,978,000 o 255,365 351,035 1,065,470 1,319,820 1,724,800 3,565,000 2,874,195 1,329,033 3,000 o 76,572,098 35,371,051 4,029,607 1,729,610 1,000 527,309 1,000 1,000 1,000 10,000 405,000 383,765 896,594 o o 916,100 o 67,795 153,575 613,356 727,743 o o o 738,000 o 1,881,200 2,071,000 244,000 18,682,426 5,096,213 372,398 3,872,238 13,325,677 662,142 5,214,577 1,193,844 1,973,274 o 254,882 347,866 1,003,568 1,272,557 1,699,515 3,558,707 2,759,177 924,821 2,100 o 62,215,982 27,469,418 3,242,410 1,577,504 1,000 503,260 199 1,000 1,000 9,791 o 383,765 896,294 o o 843,050 o 67,795 153,575 593,711 727,443 o o o 666,426 o 1,844,998 2,071,000 244,000 75.9 78.8 82.3 75.5 83.2 88.9 73.4 76.2 99.8 99.8 99.1 94.2 96 .4 98.5 99.8 96.0 69.6 70.0 81.3 77.7 80.5 91.2 100.0 95.4 19.9 100.0 100.0 97.9 100.0 100.0 92.0 100.0 100.0 96 .8 100.0 90.3 98.1 100.0 100.0 04/10/2007 09,17,14 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/07 03/31/07 3 Months 9 Months 25.0% 75.0% Completed' Remaining Cur Mo Y-T-D 2007 Unexpended Unexpended Expended Expended Budget Balance Percent WATER AND SEWER FUND 715,897 1,455,221 11,131,631 9,676,410 86.9 VILLAGE PARKING SYSTEM FUND 7,493 19,867 123,154 103,287 83.9 PARKING SYSTEM REVENUE FUND 11,843 33,304 156,448 123,144 78.7 VEHICLE MAINTENANCE FUND 130,061 317,669 1,573,353 1,255,684 79.8 VEHICLE REPLACEMENT FUND 35,457 41,087 961,470 920,383 95.7 COMPUTER REPLACEMENT FUND 0 0 249,050 249,050 100.0 RISK MANAGEMENT FUND 512,004 1,768,880 6,514,196 4,745,316 72 .8 POLICE PENSION FUND 199,159 598,116 2,465,133 1,867,017 75.7 FIRE PENSION FUND 214,859 649,906 2,627,958 1,978,052 75.3 SSA #6 GEORGE/ALBERT B&I 0 0 0 0 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 Total All Funds 5,680,769 14,356,116 76,572,098 62,215,982 81.3 ? b4/10/2007 09:19:14 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 03/31/07 3 Months 9 Months 25.0% 75.0% Completed Remaining Totals Cur Mo Y-T-D 2007 Unexpended Unexpended Expended Expended Budget Balance Percent 5,314 26,723 111,270 84,547 76.0 1,227 8,130 17,010 8,880 52.2 6,541 34,853 128,280 93,427 72.8 PUBLIC REPRESENTATION PROGRAM TOTALS 02 MAYOR AND BOARD OF TRUSTEES 03 ADVISORY BOARDS & COMMISSIONS EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES Totals 2,716 12,467 35,466 22,999 64.8 558 2,109 6,361 4,252 66.8 0 0 3,000 3,000 100.0 3,166 19,599 77,353 57,754 74.7 23 59 500 441 88.2 78 619 5,600 4,981 88.9 6,541 34,853 128,280 93,427 72.8 SOURCE OF FUNDS 001 GENERAL FUND 6,541 34,853 128,280 93,427 72.8 Totals 6,541 34,853 128,280 93,427 72.8 1 04/10/2007 09:19:14 FRRDBROl SUM 031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 03/31/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 44,959 33,643 18,381 69,128 7,725 Totals 173,836 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 74,038 28,836 670 69,448 419 425 o o Totals 173,836 SOURCE OF FUNDS 001 GENERAL FUND 173,836 Totals 173,836 2 Y-T-D Expended 164,569 73,833 53,454 146,567 18,391 456,814 237,176 64,172 7,163 146,062 949 940 352 o 456,814 456,814 456,814 2007 Budget 509,550 630,750 287,303 919,135 143,372 2,490,110 898,539 281,625 46,400 1,213,396 10,145 11,485 26,920 1,600 2,490,110 2,490,110 2,490,110 25.0% 75.0% Completed Remaining Unexpended Unexpended Balance Percent 344,981 556,917 233,849 772,568 124,981 2,033,296 661,363 217,453 39,237 1,067,334 9,196 10,545 26,568 1,600 2,033,296 2,033,296 2,033,296 67.7 88.3 81.4 84.1 87.2 81.7 73.6 77.2 84.6 88.0 90.6 91. 8 98.7 100.0 81.7 81. 7 81.7 '04/10/2007 3 Months 25.0% Completed 09:19:14 VILLAGE OF MOUNT PROSPECT 9 Months 75.0% Remaining FRRDBROl SUM 031 Department Budget Expenditure Sunnnary 01/01/07 - 03/31/07 Cur Mo Y-T-D 2007 Unexpended Unexpended TV SERVICES DIVISION Expended Expended Budget Balance Percent PROGRAM TOTALS 02 CABLE TV OPERATIONS 11,808 28,537 130,245 101,708 78.1 04 INTERGOVERNMENTAL PROGRAMMING 3,525 9,056 48,322 39,266 81.3 Totals 15,333 37,593 178,567 140,974 78.9 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 8,608 24,159 102,484 78,325 76.4 51 EMPLOYEE BENEFITS 4,210 8,842 41,133 32,291 78.5 52 OTHER EMPLOYEE COSTS 0 535 2,650 2,115 79.8 54 CONTRACTUAL SERVICES 334 1,498 13,150 11,652 88.6 55 UTILITIES 150 506 1,600 1,094 68.4 57 COMMODITIES & SUPPLIES 978 1,000 7,050 6,050 85.8 67 OTHER EQUIPMENT 1,053 1,053 10,500 9,447 90.0 Totals 15,333 37,593 178,567 140,974 78.9 SOURCE OF FUNDS 001 GENERAL FUND 15,333 37,593 178,567 140,974 78.9 Totals 15,333 37,593 178,567 140,974 78.9 3 04(10(2007 3 Months 25.0% Completed 09:19:14 VILLAGE OF MOUNT PROSPECT 9 Months 75.0% Remaining FRRDBROl SUM 031 Department Budget Expenditure Surmnary 01/01/07 03/31/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 19,854 47,786 200,188 152,402 76.1 Totals 19,854 47,786 200,188 152,402 76.1 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 13,466 30,427 113,075 82,648 73 .1 51 EMPLOYEE BENEFITS 5,165 10,068 43,977 33,909 77.1 52 OTHER EMPLOYEE COSTS 30 70 2,625 2,555 97.3 54 CONTRACTUAL SERVICES 1,005 6,440 33,748 27,308 80.9 55 UTILITIES 75 81 1,650 1,569 95.1 57 COMMODITIES & SUPPLIES 113 700 5,113 4,413 86.3 Totals 19,854 47,786 200,188 152,402 76.1 SOURCE OF FUNDS 001 GENERAL FUND 19,854 47,786 200,188 152,402 76.1 Totals 19,854 47,786 200,188 152,402 76.1 4 '04/10/2007 09:19:14 FRRDBROl SUM 031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 03/31/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 33,685 43,887 o 51,959 41,556 3,324 Totals 174,411 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 72,638 31,195 803 22,595 286 45,061 1,833 o Totals 174,411 SOURCE OF FUNDS 001 GENERAL FUND 174,411 Totals 174,411 5 Y-T-D Expended 83,526 107,888 o 107,199 96,467 8,144 403,224 187,422 63,626 2,078 55,765 743 90,121 3,169 300 403,224 403,224 403,224 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 25.0% 75.0% Unexpended Balance 217,761 336,791 o 414,246 312,770 41,588 1,323,156 609,403 231,518 8,562 82,011 4,407 360,484 21,071 5,700 1,323,156 1,323,156 1,323,156 Completed Remaining Unexpended Percent 72 .3 75.7 79.4 76.4 83.6 76.6 76.5 78.4 80.5 59.5 85.6 80.0 86.9 95.0 76.6 76.6 76.6 04/10/2007 09,19,14 FRRDBROl SUM 031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 03/31/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 22,705 25,322 10,454 72,334 38,371 11,557 Totals 180,743 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 108,872 51,762 3,350 13,655 1,162 1,942 o Totals 180,743 SOURCE OF FUNDS 001 GENERAL FUND 550 DOWNTOWN REDEVLPMNT CONST 180,743 o Totals 180,743 6 Y-T-D Expended 57,260 60,547 24,945 177,663 84,961 28,727 434,103 286,689 106,425 6,617 27,419 2,489 4,464 o 434,103 433,203 900 434,103 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 25.0% 75.0% Completed Remaining Unexpended Unexpended Balance Percent 183,369 205,033 84,491 634,828 405,219 99,591 1,612,531 968,956 391,242 23,946 185,065 16,066 14,256 13,000 1,612,531 1,612,531 o 1,612,531 76.2 77.2 77.2 78.1 82.7 77.6 78.8 77.2 78.6 78.3 87.1 86.6 76.2 100.0 78.8 78.8 78.8 04/10/2007 09:19:14 FRRDBROl SUM 031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 03/31/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,216 152 o 52 Totals 8,420 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 4,869 2,249 630 620 o 52 o o Totals 8,420 SOURCE OF FUNDS 070 COMMUNITY DEVELPMNT BLOCK GRNT 8,420 Totals 8,420 7 Y-T-D Expended 19,082 152 o 4,815 24,049 12,800 4,626 848 960 o 4,815 o o 24,049 24,049 24,049 2007 Budget 83,309 134,000 85,000 225,000 527,309 52,004 20,697 6,020 147,639 949 190,000 o 110,000 527,309 527,309 527,309 25.0% 75.0% Unexpended Balance 64,227 133,848 85,000 220,185 503,260 39,204 16,071 5,172 146,679 949 185,185 o 110,000 503,260 503,260 503,260 Completed Remaining Unexpended Percent 77.1 99.9 100.0 97.9 95.4 75.4 77.6 85.9 99.3 100.0 97.5 100.0 95.4 95.4 95.4 04/10/2007 09:19:14 FRRDBROl SUM 031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 03/31/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 15,382 33,168 18,396 2,977 o Totals 69,923 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 44,555 17,820 275 5,898 385 990 o Totals 69,923 SOURCE OF FUNDS 001 GENERAL FUND 69,923 Totals 69,923 8 Y-T-D Expended 42,534 80,829 40,376 6,882 o 170,621 118,504 36,977 694 11,739 980 1,727 o 170,621 170,621 170,621 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 25.0% 75.0% Completed Remaining Unexpended Unexpended Balance Percent 133,743 261,998 151,605 38,040 o 585,386 359,682 134,628 3,206 41,862 7,020 35,488 3,500 585,386 585,386 585,386 75.9 76.4 79.0 84.7 77.4 75.2 78.5 82.2 78.1 87.8 95.4 100.0 77 .4 77.4 77 .4 '04/10/2007 09:19:14 FRRDBROl SUM 031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 03/31/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 193,272 667,521 21,679 106,298 2,564 72,405 Totals 1,063,739 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 746,481 187,086 2,984 118,322 3,250 5,403 213 o Totals 1,063,739 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,063,739 o o o o Totals 1,063,739 9 Y-T-D Expended 435,068 1,869,838 59,303 275,434 8,070 159,259 2,806,972 2,013,645 378,068 29,026 348,652 7,478 26,605 2,517 981 2,806,972 2,806,171 o 801 o o 2,806,972 2007 Budget 1,612,340 8,218,329 342,746 1,205,678 29,380 811,753 12,220,226 8,592,849 1,852,559 123,000 1,427,145 49,200 115,423 14,000 46,050 12,220,226 12,216,226 1,000 1,000 1,000 1,000 12,220,226 25,0% 75,0% Unexpended Balance 1,177,272 6,348,491 283,443 930,244 21,310 652,494 9,413,254 6,579,204 1,474,491 93,974 1,078,493 41,722 88,818 11,483 45,069 9,413,254 9,410,055 1,000 199 1,000 1,000 9,413,254 Completed Remaining Unexpended Percent 73,0 77,2 82.7 77.2 72.5 80.4 77.0 76.6 79.6 76.4 75.6 84.8 77.0 82.0 97.9 77 .0 77.0 100.0 19.9 100.0 100.0 77.0 04/10/2007 09,19,14 FRRDBROl SUM 031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 03/31/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 93,869 582,308 53 48,460 6,032 44,554 2,261 2,359 o o Totals 779,896 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 575,634 140,378 12,055 o 36,330 5,716 8,669 483 o 631 Totals 779,896 SOURCE OF FUNDS 001 GENERAL FUND 095 FOREIGN FIRE TAX BOARD FUND 779,896 o Totals 779,896 10 Y-T-D Expended 232,516 1,648,819 10,523 121,024 18,367 105,129 2,609 5,036 o 209 2,144,232 1,666,716 282,974 18,944 o 115,413 15,846 34,556 483 o 9,300 2,144,232 2,144,023 209 2,144,232 2007 Budget 944,298 6,929,243 13,631 546,561 64,500 505,633 35,715 35,748 o 10,000 9,085,329 6,833,619 1,390,307 146,940 o 454,019 43,200 119,769 4,000 4,000 89,475 9,085,329 9,075,329 10,000 9,085,329 25.0% 75.0% Unexpended Balance 711,782 5,280,424 3,108 425,537 46,133 400,504 33,106 30,712 o 9,791 6,941,097 5,166,903 1,107,333 127,996 o 338,606 27,354 85,213 3,517 4,000 80,175 6,941,097 6,931,306 9,791 6,941,097 Completed Remaining Unexpended Percent 75.4 76.2 22.8 77.9 71.5 79.2 92.7 85.9 97.9 76.4 75.6 79.6 87.1 74.6 63.3 71.1 87.9 100.0 89.6 76.4 76.4 97.9 76.4 '04/10/2007 3 Months 25.0% Completed 09:19:14 VILLAGE OF MOUNT PROSPECT 9 Months 75.0% Remaining FRRDBROl SUM 031 Department Budget Expenditure Swnmary 01/01/07 - 03/31/07 Cur Mo Y-T-D 2007 Unexpended Unexpended PUBLIC WORKS - ADMINISTRATION Expended Expended Budget Balance Percent PROGRAM TOTALS 01 PUBLIC WORKS ADMINSTRATION 141,096 277,156 1,259,759 982,603 78.0 Totals 141,096 277,156 1,259,759 982,603 78.0 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 25,739 63,232 237,193 173,961 73.3 51 EMPLOYEE BENEFITS 14,833 29,966 135,476 105,510 77.9 52 OTHER EMPLOYEE COSTS 2,046 5,152 30,095 24,943 82.9 54 CONTRACTUAL SERVICES 96,512 173,196 821,835 648,639 78.9 55 UTILITIES 1,291 4,310 18,990 14,680 77.3 57 COMMODITIES & SUPPLIES 447 1,072 14,475 13,403 92.6 65 OFFICE EQUIPMENT 0 0 1,090 1,090 100.0 67 OTHER EQUIPMENT 228 228 605 377 62.3 Totals 141,096 277,156 1,259,759 982,603 78.0 SOURCE OF FUNDS 001 GENERAL FUND 141,096 277,156 1,259,759 982,603 78.0 Totals 141,096 277,156 1,259,759 982,603 78.0 11 04/10/2007 09,19,14 FRRDBROl SUM 031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 03/31/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 18,964 63,631 16,281 297,563 o 13,778 18,423 9,070 7,493 11,843 o Totals 457,046 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 194,646 55,147 50,453 2,346 317 154,137 o o o o o Totals 457,046 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 620 VILLAGE PARKING SYSTEM FUND 630 PARKING SYSTEM REVENUE FUND 306,966 130,744 7,493 11,843 Totals 457,046 12 Y-T-D Expended 40,167 163,385 45,132 369,602 o 34,708 25,011 23,640 19,867 33,304 o 754,816 387,642 98,673 98,695 2,805 635 166,366 o o o o o 754,816 569,177 132,468 19,867 33,304 754,816 2007 Budget 146,860 982,815 504,141 445,928 o 178,890 70,548 119,916 123,154 156,448 o 2,728,700 1,108,580 354,511 676,035 134,644 3,172 300,993 o 6,365 19,400 125,000 o 2,728,700 2,225,928 223,170 123,154 156,448 2,728,700 25.0% 75.0% Unexpended Balance 106,693 819,430 459,009 76,326 o 144,182 45,537 96,276 103,287 123,144 o 1,973,884 720,938 255,838 577,340 131,839 2,537 134,627 o 6,365 19,400 125,000 o 1,973,884 1,656,751 90,702 103,287 123,144 1,973,884 Completed Remaining Unexpended Percent 72.6 83.4 91.0 17.1 80.6 64.5 80.3 83.9 78.7 72.3 65.0 72.2 85.4 97.9 80.0 44.7 100.0 100.0 100.0 72.3 74.4 40.6 83.9 78.7 72.3 . 04/10/2007 09:19:15 FRRDBROl SUM 031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 03/31/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 20,412 30,017 62,987 2,967 Totals 116,383 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT 54,373 23,859 120 33,255 311 4,465 Totals 116,383 SOURCE OF FUNDS 001 GENERAL FUND 690 RISK MANAGEMENT FUND 116,383 o Totals 116,383 13 Y-T-D Expended 50,127 72,032 109,763 7,301 239,223 153,143 47,331 396 33,281 607 4,465 239,223 239,223 o 239,223 2007 Budget 216,107 517,535 841,572 95,998 1,671,212 697,162 228,406 3,555 644,224 70,470 27,395 1,671,212 1,660,293 10,919 1,671,212 25.0% 75.0% Completed Remaining Unexpended Unexpended Balance Percent 165,980 445,503 731,809 88,697 1,431,989 544,019 181,075 3,159 610,943 69,863 22,930 1,431,989 1,421,070 10,919 1,431,989 76.8 86.1 87.0 92.4 85.7 78.0 79.3 88.9 94.8 99.1 83.7 85.7 85.6 100.0 85.7 04/10/2007 09:19:15 FRRDBROl SUM 031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 03/31/07 PUBLIC WORKS - ENGINEERING Cur Mo Expended PROGRAM TOTALS 01 ENGINEERING SERVICES 05 TRAFFIC CNTRL & STREET LGHTNG 71,803 34,402 Totals 106,205 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 57,085 20,619 145 5,297 21,082 1,977 o o o Totals 106,205 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 97,584 8,621 Totals 106,205 14 Y-T-D Expended 177,888 62,061 239,949 151,561 43,243 562 10,141 31,099 3,343 o o o 239,949 220,311 19,638 239,949 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 25.0% 75.0% Completed Remaining Unexpended Unexpended Balance Percent 590,139 464,119 1,054,258 470,555 148,684 4,828 136,528 217,901 23,642 530 1,590 50,000 1,054,258 790,556 263,702 1,054,258 76.8 88.2 81. 5 75.6 77.5 89.6 93.1 87.5 87.6 100.0 100.0 100.0 81. 5 78.2 93.1 81.5 '04/10/2007 09019,15 FRRDBROl SUM 031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 03/31/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 148,642 14,299 5,629 64,531 48,149 21,199 56,663 60,609 27,675 11,812 256,689 Totals 715,897 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 131,804 66,382 369 430,625 5,661 13,566 15,893 o o 27,012 24,585 o Totals 715,897 SOURCE OF FUNDS 610 WATER AND SEWER FUND 715,897 Totals 715,897 15 Y-T-D Expended 311,978 37,434 12,841 118,102 112,199 61,458 84,703 121,218 57,844 11,812 525,632 1,455,221 389,509 131,980 7,955 811,394 15,151 27,133 19,802 o o 27,012 25,285 o 1,455,221 1,455,221 1,455,221 2007 Budget 1,468,391 193,622 102,407 880,371 1,390,832 364,297 355,821 606,091 491,494 1,830,000 3,448,305 11,131,631 1,783,337 633,956 33,625 5,603,389 202,875 135,664 205,285 o 7,415 801,285 1,724,800 o 11,131,631 11,131,631 11,131,631 25.0% 75.0% Unexpended Balance 1,156,413 156,188 89,566 762,269 1,278,633 302,839 271,118 484,873 433,650 1,818,188 2,922,673 9,676,410 1,393,828 501,976 25,670 4,791,995 187,724 108,531 185,483 o 7,415 774,273 1,699,515 9,676,410 9,676,410 9,676,410 Completed Remaining Unexpended Percent 78.8 80.7 87.5 86.6 91.9 83.1 76.2 80.0 88.2 99.4 84.8 86.9 78.2 79.2 76.3 85.5 92.5 80.0 90.4 100.0 96 .6 98.5 o 86.9 86.9 86.9 04/10/2007 09,19,15 FRRDBROl SUM 031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 03/31/07 PUBLIC WORKS - REFUSE DISPOSAL Cur Mo Expended PROGRAM TOTALS 01 REFUSE DISPOSAL PROGRAM 02 REFUSE LEAF REMOVAL PROGRAM 470,000 13,589 Totals 483,589 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 14,885 6,662 o 453,346 30 5,266 3,400 Totals 483,589 SOURCE OF FUNDS 030 REFUSE DISPOSAL FUND 483,589 Totals 483,589 16 Y-T-D Expended 756,494 30,703 787,197 41,529 13,246 o 718,350 140 10,532 3,400 787,197 787,197 787,197 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 25.0% 75.0% Completed. Remaining Unexpended Unexpended Balance Percent 3,069,344 173,066 3,242,410 189,015 58,200 1,785 2,936,002 450 42,128 14,830 3,242,410 3,242,410 3,242,410 80.2 84.9 80.5 82.0 81. 5 100.0 80.3 76.3 80.0 81. 3 80.5 80.5 80.5 .04/10/2007 09,19,15 FRRDBROl SUM 031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 03/31/07 PUBLIC WORKS - VEHICLE MAINT Cur Mo Expended PROGRAM TOTALS 01 VEHICLE DIVISION ADMINSTRATION 02 VEHICLE MAINTENANCE PROGRAM 20,538 109,523 Totals 130,061 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 EQUI PMENT 61,781 26,908 o 3,589 75 37,708 o o o Totals 130,061 SOURCE OF FUNDS 660 VEHICLE MAINTENANCE FUND 130,061 Totals 130,061 17 Y-T-D Expended 44,565 273,104 317,669 161,137 51,034 o 8,618 381 96,499 o o o 317,669 317,669 317,669 2007 Budget 185,783 1,387,570 1.573.353 695,541 237,031 2,250 78,151 1,060 555,370 o 530 3,420 1,573.353 1,573,353 1,573.353 25.0% 75.0% Unexpended Balance 141,218 1,114,466 1.255.684 534,404 185,997 2,250 69,533 679 458,871 o 530 3,420 1,255.684 1,255,684 1.255.684 Completed Remaining Unexpended Percent 76.0 80.3 79.8 76.8 78.5 100.0 89.0 64.1 82.6 100.0 100.0 79.8 79.8 79.8 04/10/2007 09,19,15 FRRDBROl SUM031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 03/31/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 4,676 o 8,242 215 Totals 13. 13 3 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 179 229 4,676 o 8,049 o Totals 13.133 SOURCE OF FUNDS 001 GENERAL FUND 13,133 Totals 13.133 18 Y-T-D Expended 35,168 105 14,476 596 50.345 1,631 465 40,133 o 8,205 -89 50.345 50,345 50.345 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 25.0% 75.0% Unexpended Balance 90,932 136,580 72,702 2,291 302.505 87,019 15,745 168,742 o 20,910 10,089 302.505 302,505 302.505 Completed Remaining Unexpended Percent 72.1 99.9 83.4 79.4 85.7 98.2 97.1 80.8 71.8 100.9 85.7 85.7 85.7 '04/10/2007 09:19:15 FRRDBROl SUM 031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 03/31/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 57,700 o 1,173 o o 35,457 o Totals 94,330 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 55 UTILITIES 59 OTHER EXPENDITURES 62 LAND IMPROVEMENTS 64 BUILDING IMPROVEMENTS 65 OFFICE EQUIPMENT 66 MOBILE EQUIPMENT 67 OTHER EQUIPMENT 69 INFRASTRUCTURE 72 INTEREST EXPENSE 80 INTERFUND TRANSFERS 38,058 o o o o o 56,272 o o o o Totals 94,330 SOURCE OF FUNDS 050 MOTOR FUEL TAX FUND 510 CAPITAL IMPROVEMENT FUND 526 SERIES 2003 PROJECT 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 o 57,700 o 1,173 o o o 35,457 o Totals 94,330 19 Y-T-D Expended 71,574 o 35,302 o o 41,087 o 147,963 53,709 o o o o o 61,902 4,224 6,293 21,835 o 147,963 o 71,574 o 35,302 o o o 41,087 o 147,963 2007 Budget 653,000 10,000 1,880,300 244,000 3,369,100 961,470 249,050 7,366,920 369,100 o 1,778,000 o 245,000 274,050 1,065,470 313,000 3,280,000 42,300 o 7,366,920 1,223,100 738,000 o 1,880,300 2,071,000 244,000 o 961,470 249,050 7,366,920 25.0% 75.0% Completed Remaining Unexpended Unexpended Balance Percent 581,426 10,000 1,844,998 244,000 3,369,100 920,383 249,050 7,218,957 315,391 o 1,778,000 o 245,000 274,050 1,003,568 308,776 3,273,707 20,465 o 7,218,957 1,223,100 666,426 o 1,844,998 2,071,000 244,000 o 920,383 249,050 7,218,957 89.0 100.0 98.1 100.0 100.0 95.7 100.0 98.0 85.4 100.0 100.0 100.0 94.2 98.7 99.8 48.4 98.0 100.0 90.3 98.1 100.0 100.0 95.7 100.0 98.0 04/10/2007 09,19,15 FRRDBROl SUM 031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 03/31/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 300 300 o o o Totals 600 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 200 230 290 340 350 360 380 390 400 430 440 830 o o o 600 o Totals 600 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. SSA #6 GEORGE/ALBERT B&I o o 300 o o 300 o o o o o o o o o Totals 600 20 Y-T-D Expended 405,300 73,050 19,945 o o 498,295 o 115,018 382,377 900 o 498,295 405,000 o 300 o o 73,050 o o o 19,645 300 o o o o 498,295 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 o 916,100 o 67,795 153,575 613,356 727,743 o o o o 4,163,928 25.0% 75.0% Unexpended Balance 1,280,059 996,625 1,388,949 o o 3,665,633 2,759,177 904,356 2,100 o 3,665,633 o 383,765 896,294 o o 843,050 o 67,795 153,575 593,711 727,443 o o o o 3,665,633 Completed Remaining Unexpended Percent 76.0 93.2 98.6 88.0 o 96 .0 70.3 70.0 88.0 100.0 100.0 92.0 100.0 100.0 96.8 100.0 88.0 '04/10/2007 09,19,15 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 03/31/07 3 Months 9 Months 25.0% 75.0% Completed Remaining Totals Cur Mo Y-T-D 2007 Unexpended Unexpended Expended Expended Budget Balance Percent 3,711 11,133 44,533 33,400 75.0 199,159 598,116 2,465,133 1,867,017 75.7 214,859 649,906 2,627,958 1,978,052 75.3 417,729 1,259,155 5,137,624 3,878,469 75.5 RETIREE PENSIONS PROGRAM TOTALS 01 MISCELLANEOUS PENSIONS 02 POLICE PENSIONS 03 FIRE PENSIONS EXPENDITURE CLASSIFICATION 53 PENSION BENEFITS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES Totals 417,729 1,259,086 5,131,324 3,872,238 75.5 0 0 5,800 5,800 100.0 0 69 500 431 86.2 417,729 1,259,155 5,137,624 3,878,469 75.5 SOURCE OF FUNDS 001 GENERAL FUND 710 POLICE PENSION FUND 720 FIRE PENSION FUND Totals 3,711 11,133 44,533 33,400 75.0 199,159 598,116 2,465,133 1,867,017 75.7 214,859 649,906 2,627,958 1,978,052 75.3 417,729 1,259,155 5,137,624 3,878,469 75.5 21 04/10/2007 09,19,15 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 03/31/07 3 Months 9 Months 25.0% 75.0% Completed Remaining Totals Cur Mo Y-T-D 2007 Unexpended Unexpended Expended Expended Budget Balance Percent 103,747 475,435 1,360,353 884,918 65.1 408,257 1,293,445 5,142,924 3,849,479 74.9 512,004 1,768,880 6,503,277 4,734,397 72.8 RISK MANAGEMENT PROGRAM TOTALS 01 CASUALTY & PROPERTY INSURANCE 02 MEDICAL INSURANCE EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 56 INSURANCE 67 OTHER EQUIPMENT Totals 6,000 6,000 34,000 28,000 82.4 506,004 1,762,880 6,463,777 4,700,897 72.7 0 0 5,500 5,500 100.0 512,004 1,768,880 6,503,277 4,734,397 72.8 SOURCE OF FUNDS 690 RISK MANAGEMENT FUND 512,004 1,768,880 6,503,277 4,734,397 72.8 Totals 512,004 1,768,880 6,503,277 4,734,397 72 .8 22 , 04/10/2007 09:19:15 FRRDBROl SUM 031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 03/31/07 NON-DEPARTMENTAL Cur Mo Expended 2007 Budget Y-T-D Expended 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 25.0% 75.0% Completed Remaining Unexpended Unexpended Balance Percent o o o o o o o o o o o o o o o o 04/10/2007 09,19,15 FRRDBROl SUM 031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 03/31/07 CAPITAL FIXED ASSETS Cur Mo Expended 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 25.0% 75.0% Completed Remaining Unexpended Unexpended Balance Percent o o o o o o o o o o o o '04/10/2007 09:19:15 FRRDBROl SUM 031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 03/31/07 MOUNT PROSPECT LIBRARY Cur Mo Expended Y-T-D Expended Unexpended Unexpended Balance Percent PROGRAM TOTALS 02 LIBRARY SERVICES o Totals o EXPENDITURE CLASSIFICATION 90 COMPONENT UNIT EXPENDITURES o Totals o SOURCE OF FUNDS 950 MOUNT PROSPECT LIBRARY FUND o Totals 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 25.0% 75.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 April 01 - 11, 2007 Cash & Invstmt Receipts Disbursements Other Cash & Invstmt Balance 04/01/07 Per Attached Credits/ Balance 04/01/07 04111/07 List of Bills Debits 04/11/07 General Fund 8,825,220 401,132 190,867 9,035,485 Soecial Revenue Funds Refuse Disposal Fund 2,035,559 44,988 175,699 1,904,848 Motor Fuel Tax Fund 1,488,257 905 1,342 1,487,820 Local Law Enforcement Block Grant Fund 3,489 3,489 Community Development Blk Grant Fund 16,190 98,787 114,977 Asset Seizure Fund 79,129 79,129 DEA Shared Funds 49,889 49,889 DUI Fine Fund 40,407 1,644 42,051 Foreign Fire Tax Board Fund 52,955 473 52,482 Debt Service Funds 1,791,214 4,490 1,795,704 Caoital Proiects Funds Capital Improvement Fund 868,030 6,165 874,195 Downtown Redevelopment Const Fund 1,930,196 1,541 34,647 1,897,090 Street Improvement Construction Fund 1,500,503 1,500,503 Flood Control Construction Fund 634,548 634,548 Enterorise Funds Water & Sewer Fund 4,780,267 335,282 18,953 5,096,596 Village Parking System Fund 72,628 4,700 1,823 75,505 Parking System Revenue Fund (14,603) 5,834 297 (9,066) Internal Service Funds Vehicle Maintenance Fund 393,258 7,989 385,269 Vehicle Replacement Fund 6,428,441 122 6,428,319 Computer Replacement Fund 743,329 743,329 Risk Management Fund 2,346,325 52,243 38,154 2,360,414 Trust & AQencv Funds Police Pension Fund 40,467,207 2,681 2,651 40,467,237 Fire Pension Fund 40,522,292 2,491 3,950 40,520,833 Flexcomp Trust Fund 16,833 128 14,493 2,468 Escrow Deposit Fund 1,712,139 40,040 13,831 1,738,348 116,783,702 1,003,051 505,291 117,281,462 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY APR122007 11: 15 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 01 2007 TO APRIL 11 2007 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 001 10075 A- EXPRESS TOWING & RECOVERY REPAIR THE BLUES MOBILE 108.00 02572 ABM OFFICE EQUIPMENT MAINT . CONTRACT FOR FAX MACHINE 250.00 09656 ACCURINT - ACCOUNT#! 03 7332 BACKGROUND CHECKS 93.05 01071 ADDISON BUILDING MATERIAL CO. MISC. BUILDING MATERIALS AND 86.73 MISC. BUILDING MATERIALS AND 15.59 MISC. BUILDING MATERIALS AND 22.58 MISC. BUILDING MATERIALS AND 8.44 MISC. BUILDING MATERIALS AND 281. 42 MISC. BUILDING MATERIALS AND 152.50 -.--.-------- 567.26 09146 ADI 26BIT CARDS 387.74 03655 ADT SECURITY SERVICES, INC. QUARTERLY ALARM SERVICES - PUB 2150.29 01169 AERIAL EQUIPMENT, INC. STI - BG 85 BLOWER 209.95 5' CANT HOOK AND 35' PICEROON 106.94 .... --------- 316.89 09510 AFCI REGISTER D.BEHUN 90.00 01227 AIR ONE EQUIPMENT, INC. Hose & Pouch Kit Quick - Fill 2060.00 SHIPPING 8.72 -------.----- 2068.72 01246 AIRGAS NORTH CENTRAL OXYGEN CYLINDER RENTAL 88.50 08573 ALAN O.AMOS & ASSOC., P. C. REAL ESTATE TAX VOID 360.00 01399 ALLIANCE FIRE PROTECTION ANNUAL SPRINKLER SYSETEM 300.00 01561 AMERICAN CHARGE SERVICE SENIOR TAXI PROGRAM 61. 50 09676 AMERICAN MESSAGING QUARTERLY PAYMENTS 64.63 01670 AMERICAN PLANNING ASSOCIATION MEMBERSHIP FOR ELLEN DIVITA 319.00 09544 ANDRES MEDICAL BILLING,LTD AMBULANCE BILLING 3088.47 05044 AVIS RENT A CAR SYSTEM TAC UNIT LEASE-MARCH,2007 769.99 08566 BARCA, VITO REFUND 36.00 06287 BEDCO MECHANICAL BI -MONTHLY HVAC SERVICES 1/07 1421.65 08566 BENTLEY, MICHAEL SENIOR RATE 24.00 10073 BEST TECHNOLOGY SYSTEMS, INC. RANGE MAINTENANCE 2975.00 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16: 3 9 RUN: THURSDAY APR122007 11: 15 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 01 2007 TO APRIL 11 2007 .. - - - --.. -...... -.. -...... -.. --- --.. -- --.................................... --............ --........................ --.... -_...... --................ --...................... --...... ---.................... --- --.............. DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ...... --.......... --.. -- --- -- ---...... ----- --.................... --.................... --...... ---................ --.... -...... ------...................... ----...................... --.. --.............................. 10077 BOGIES ALE HOUSE, INC. DEPOSIT FOR MENTOR PROGRAM 50.00 08566 BOLL, ELIZABETH OVERPAYMENT 36.00 09609 BONO, CSR, LTD., KATHLEEN LIQUOR COMMISSION HEARING 168.00 05774 BOUNDTREE MED I CAL, LLC. Ambulance Supplies, Suction 277.84 10078 CAMPION, SHANE REIMBURSE EXPENSES 1553.41 08566 CANNON, MARY J. SENIOR RATE 24.00 04267 CARDINAL CARTRIDGE INC. TONER CARTRIDGES /MISC . PRINTERS 327.18 TONER CARTRIDGES /MISC. PRINTERS 327.19 TONER CARTRIDGES/MISC . PRINTERS 233.79 TONER CARTRIDGES /MISC. PRINTERS 321.73 TONER CARTRIDGES/MISC. PRINTERS 40.00 TONER CARTRIDGES/MISC. PRINTERS 107.58 TONER CARTRIDGES/MISC. PRINTERS 315.72 ---- -------.... 1673.19 01049 CDW GOVERNMENT, INC UPS FOR PD 470.00 UPS NETWORK CARDS FOR PD 440.00 PANASONI C TOUGHBOOK CF 27 BATT 168.99 ADOBE ACROBAT PRO UPGRADE FOR 89.00 ------------- 1167.99 01056 CENTRAL CONTINENTAL BAKERY EXPENSES 20.25 SHEET CAKE FOR CHIEF DAHLBERG 87.93 ---- --------- 108.18 05375 CENTURY CLEANERS UNIGORM CLEANING-SUPERVISORS 226.07 01061 CERTIFIED LABORATORIES 1 120# Perrnaval ve Chassis Lube 591.75 01077 CHICAGO COMM. SERVICE, INC. W/O REPAIRED ANTENNA 123.50 01088 CHI EF SUPPLY CORP. BOTTERIES FOR FLASHLIGHTS 53.97 07281 CL GRAPH I CS, INC. SPRING 2007 NEWSLETTER PRINT IN 8725.00 08865 CLOSED CIRCUIT INNOVATIONS, INC. IVACS MAINTENANCE AGREEMENT 427.00 10006 CUSTOM DESIGN AND TENT SERVICE, INC. RENTAL OF HANDRAILS 90.00 04579 CUSTOM VEHICLE SYSTEMS, INC. PARTS FOR REPAIR 236.00 10079 CZERWINSKI, FLORENCE REFUND 12.00 06411 DACRA COMPUTER SERVICE ACCESS DATABASE 687.50 01218 DAHLBERG, JOHN REIMBURSEMENT 1060.95 01233 DATA MEDIA PRODUCTS, INC. SONY DIGITAL VIDEO 373.58 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY APR122007 11: 15 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 01 2007 TO APRIL 11 2007 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 09037 DIGITAL VISION TSR FORM DEVELOPMENT 2350.00 06343 EDDINGTON, RICHARD FLAG & CERTIFICATE FRAMING 111.6 5 01328 EL-COR INDUSTRIES, INC. 4 Bottle Bracket Holders, Repa 486.74 01333 ELGIN REGIONAL FIRE ACADEMY Registration/ Graham POC FAE 250.00 08566 ELLERMAN, MARY A. OVERPAYMENT 24.00 05843 ENH OMEGA PHYS I CAL/ SCHMITZ / SPARR 537.00 PHYSICALS 1693.00 PRE- EMPLOYMENT PHYSICALS 2473.00 ---_.-----.- - 4703.00 01356 ENVIRONMENTAL SAFETY GROUP, INC FIRE VULCAN LIGHT 623.90 01377 FEDERAL EXPRESS CORP MISC. SHIPPING CHARGES 113.6 8 SHEEPING FEE 65.78 ------------- 179.46 00331 FIGOLAH, MICHAEL COFFEE/MULTI HAZARD TRAINING C 71.18 FOOD FOR FIREFIGHTERS 47.34 LUNCH FOR MULTI HAZARD TRAIN IN 396.00 1- TRAINING VIDEO 285.00 ------------- 799.52 08566 FINN, PATRICK SENIOR RATE 24.00 08992 GASB PUBLICATIONS 175.00 10083 GOLD EAGLE LI QUORS REFUND- FOOD & BEVERAGE TAX 4482.39 01522 GRAINGER INC. DIO-HAND CLEANER REFILLS 345.70 05519 GRAPHIC ENTERPRISES K & E 3036 PLAN COPIER - 22.89 01559 HANSEN INFORMATION TECHNOLOGY QUARTERLY MAINT. 8556.75 08948 HEART PRINTING INC. CRIME FREE HOUSING PROGRAM 677. 00 01578 HENDRICKSEN, ROBERT W. DISPOSAL OF 28 LOADS OF LOGS 3332.00 09362 HERNANDEZ, JASMINE REFUND FOR TESTERS 31.48 00106 ICMA RETIREMENT TRUST - 401 EDDINGTON-401K PAYROLL 3/29/07 245.09 01689 I GFOA TRAVEL & MEETINGS 405.00 01701 ILLINOIS PAPER CO. 10 Boxes of Copy Paper 270.00 01714 ILLINOIS STATE POLICE ACADEMY REGISTRATION 1164.08 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY APR122007 11: 15 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 01 2007 TO APRIL 11 2007 . -.... -.. -........ --.... --.... --.. --...................... ---.... --.... --.. -- --........ -- --................................ --.... --.................................................................... --.. --............ --...... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ........ -_.............. -- ---............ --- --.... ----.................. --...... --............................................ --.................... --........ ---........ -- ---.. --.... --........ --...... --_............ --.. 07763 ILLINOIS STATE SITER CITIES CHAPTER STATE CONVENTION REGISTRATION 180.00 07433 I MAGETEC LP OPEN PURCHASE ORDER/ Copier Le 128.11 ID #90133759827-LEASE 275.00 ID #90133759828-LEASE 356.00 ID #90133770128-LEASE 356.00 ID #9013377013l-LEASE 390.00 ID #90133770126-LEASE 275.00 MONTHLY LEASE PAYMENT FOR TOSH 236.00 ID #90133643910-LEASE 320.35 COPIER LEASE PAYMENT FOR FEB-D 586.13 ----- ----- --- 2922.59 05725 ISSA ISSA ANNUAL MEMBERSHIP 120.00 00353 JANONIS, MICHAEL E. LUNCH MEETING 74.70 LUNCH MEETING 31.08 ----- --- ----- 105.78 02408 JOHN E. REID AND ASSOCIATES PRE - EMPLOYMENT TEST ING 700.00 PRE- EMPLOYMENT TESTING 175.00 ---- --- -----.. 875.00 01783 JOURNAL & TOPICS NEWSPAPERS 3 YR.SUBSCRIPTION 69.00 SUBSCRIPTION RENEWAL 26.00 PUBLICATIONS 26.00 LEGAL FOR PLAN UPDATE 195.78 .... ----------- 316.78 06691 JUST TIRES Ti res, Mount and Balance 439.64 Tire Purchases and Repairs 397.09 -- ------ ---..- 836.73 01794 KALE UNIFORMS, INC. UNIFORM SUPPLIES 41.65 RAINCOATS FOR CSO I S 636.65 -- --- --- -- --- 678.30 01798 KANE, RYAN REIMBURSE EXPENSES 158.00 01818 KERSTE IN, JUNE BLOOD DRIVE REIMBURSEMENT 5D.60 06145 KIMBALL MIDWEST Shop Supplies/ Nuts, Bolts and 550.00 ADD I L SHIPPING CHARGES 1.43 ------------- 551. 43 09508 L- 3 COMMUNICATIONS REPAIRS TO WIRELESS TRANSMITTE 46.95 10076 LABARBERA, RICHARD REIMBURSE EXPENSES 137 . 75 01861 LANDS I END BUSINESS OUTFITTERS 28 Long Sleeve Shirts With FD 834.00 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY APR122007 11: 15 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 01 2007 TO APRIL 11 2007 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - - - -.. - - --- - - - - - - - - - -- -- - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- ----- - - - - - - - - - - - - - - - - -- - - -- - -- - - - -- - - - - - - -- - - - - - - -- - -- - - -- CLOTHING EXPENSE 66.20 ------------- 900.20 08631 LECHNER AND SONS 2007 UNIFORM RENTAL AND CLEAN I 228.27 08566 LEE, SOHNG HO OVERPAYMENT 36.00 01897 LIFE AsSIST Paramedic Supplies 13 2.0 0 10084 LINDA DOERING TRANSCRIPTION SERVICE 210 1.00 01918 LUNDSTROM'S NURSERY, INC. LANDSCAPING MAINTENANCE THROUG 6690.56 01922 LYNN PEAVEY COMPANY SUPPLIES-PHOTO EQUIPMENT 2300.00 ET SUPPLIES 66.75 ---- ----- ---- 2366.75 01939 MAJOR CASE ASSISTANCE TEAM MCAT AWARDS LUNCHEON 180.00 01941 MALCOLM, JOHN EXPENSES/MEETING 46.00 08731 MALKO TECH SERVICES SECURITY CARD SYSTEM 1995.00 08566 MANNO JR., PAUL OVERPAYMENT 36.00 04339 MCGUFFIN I MARK REIMBURSE EXPENSES 546.94 05021 MENARDS TARPS AND BOX FAN 95.75 00396 MILLER, JAMES EXPENSES/04 MILLER/JAMES 155.40 02046 MOBILE PRINT INC. BUSINESS CARDS 21.60 SUPPLIES 308.28 BUSINESS CARD FOR ERB/WHEATLEY 52.34 MEMO PADS 84.34 WATER METER POST CARDS 78.79 LETTERHEAD/BUSINESS CARDS 289.42 MEMO PADS 179.72 POTLUCK DINNER INVITATION CARD 29.47 - ------------ 1043.96 08025 MORTON SUGGESTION CO. DVD'S 13 .00 09650 NCPAA MEMBERSHIP RENEWAL 25.00 MEMBERSHIP RENEWAL 25.00 ----- -------- 50.00 02148 NEOPOST INC. MAINT . FOR POSTAGE MACHINE 525.00 POSTAGE 3000.00 -- --- -- ------ 3525.00 09783 NEWSCLIP NEWSCLIPPING SERVICE 114 . 50 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY APR122007 11:15 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 01 2007 TO APRIL 11 2007 -.......... -........ - -.... ----.......... ---........ -_.................. --............ -- --.......... --.......................... --...... -_.. --.................................. --.............. ---.............. -_.......... ---.. DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ...................... ---.. -_.............. -- --.... --...... --................ --.......................................................... --.................................... --............ --.................................... -_.......... 02155 NEXTEL COMMUNICATIONS SERVICE- FIRE DEPARTMENT 761.90 FIRE DEPT. (EQUIPMENT ACCT) 99.99 VILLAGE MANAGER I S OFFICE 158.79 COMMUNITY DEVELOPMENT (COONEY) 543.27 HUMAN SERVICES (NANCY MORGAN) 170.82 POLICE DEPARTMENT (STANDARD FEE 1252.02 POLICE DEPT. (MCAT NAXTEL'S) 120.00 IT DIVISION-MIDDLETON 146.84 PUBLIC WORKS GUENTHER 305.78 BUBLI C WORKS 25.55 PUBLI C WORKS 350.34 ------------- 3935.30 02170 NORTH EAST MULTI REGIONAL TRNG ANNUAL MEMBERSHIP 86 OFFICERS 7740.00 REGISTRATION 450.00 REGISTRATION 525.00 ------------- 8715.00 09168 NORTHCENTER CAMERA FILM PROCESSING 52.20 FLASHER FOR ET CAMERAS 657.00 ------------- 709.20 07549 NORTHEASTERN ILL. PUB. SAFETY TRNG. REGISTRATION 230.00 02189 NORTHWEST CENTRAL DISPATCH SYS SERVI CE RENDERED 39390.54 SERVICE RENDERED 9847.63 ---------.. --- 49238.17 02193 NORTHWEST ELECTRICAL SUPPLY REPAIR PARTS 45.00 02204 NOVAK & PARKER INC. COMPACT REFRIGERATOR 99.00 08566 NOVAK, JOHN HANDICAPPED RATE 36.00 02229 OFF I CE DEPOT OFFICE SUPPLIES 391. 42 10003 OFFI CETEAM TEMPORARY EMPLOYEE 806.25 TEMPORAR Y EMPLOYEE 645.00 ----...-- -- --- 1451.25 09551 PACC MEMBERSHIP RENEWAL 40.00 10080 PERI PUBLICATIONS 25.00 02303 PETTY CASH - FIRE DEPT. FIRE DEPT 15.29 FIRE DEPARTMENT-SUPPLIES 26.01 FIRE DEPARTMENT-SUPPLIES 8.14 FIRE DEPARTMENT-SUPPLIES 9.31 FIRE DEPARTMENT-SUPPLIES 10.80 FIRE DEPARTMENT-SUPPLIES 38.29 ------------- REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY APR122007 11: 15 RELEASE 10 : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 01 2007 TO APRIL 11 2007 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT -.. - - -.. - - -- - - - - -- - - - _.- - - - - - - - - - - - - - - - - -- - - - --- - - --- - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - -- - - - -- 107.84 02304 PETTY CASH - POLl CE DEPT. TRAINING 124.00 TRAVEL & MEETINGS 123.66 EMPLOYMENT TESTING 24.38 CLOTHING SUPPLIES 50.48 EVIDENCE TECH SUPPLIES 18.65 ------------- 341.17 04896 PETTY CASH - MANAGER I S OFFICE LUNCH MEETING 80.00 LUNCH MEETING 27.16 SEMINAR FOR INTERN 10.00 WATER & POP FOR BOARD MEETING 7.86 CLOSED SESSION SNACKS 9.76 TAGS FOR NRE CANDIDATE BAGS 8.66 SHIPPING OF DOCUMENTS 8.38 DISC ASSESSMENT TRAINING SNACK 22.95 GIFT CARD FOR FRED PAMPEL 50.00 NEED TO BALANCE 12.23 ----- -------- 237.00 08573 POLANOWSKI, LEOPOLD REAL ESTATE TAX REBATE 400.00 02333 PORTER LEE CORPORATION BARCODE LABELS & RIBBONS 154.00 08640 POWERTRON ANNUAL MAINTENANCE ON 4 EMERGE 1532.69 08509 PROPERTY INSIGHT TRACK SEARCH 60.00 08711 QUALITY MAINTENANCE SYSTEMS, INC. 2007 CONTRACT FOR CUSTODIAL SE 827 6.8 5 08566 ROYSTER, RICHARD REFUND 90.00 00425 RZEPECKI, ROBERT L. REIMBURSE EXPENSES 74.44 07529 SCHAMBACH SOFTWARE SOLUTIONS, INC. CONSULTING SERVICES 6066.25 MUNICIPAL LICENSES ANNUAL 1155,00 ------ - - - ---- 7221.2 5 10071 SCHOOLMATER, TIMOTHY L. LEGAL-GENERAL COUNSEL 1050.00 02525 SECRETARY OF STATE PLATE STICKER RENEWAL 312.00 02542 SHEPP PEST CONTROL MONTHLY PEST CONTROL SERVICES 850.00 08566 SMITH, JOAN SENIOR RARE 24.00 00433 SMITH, ROBERT REIMBURSEMENT 88.00 09145 SNAP ON TOOLS 3/8 Wrench and Socket Set 1 Co 394 , 90 05720 SPECHT, CHERYL REIMBURSEMENT 40.00 09620 SPRINT AIR CARDS 71.57 REPORT: IIPBOIIRDRPT GENERIITED: 09 IIUG 06 16: 3 9 RUN: THURSDIIY IIPR122007 11: 15 RELEIISE ID : PIIGE VILLIIGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOIIRD OF TRUSTEES FROM IIPRIL 01 2007 TO IIPRIL 11 2007 ~. - - - - - - - - - -- - - -- - - - -- - - - - - -- - - -- - - - -- - - - - - -- - - - - - - - - ---- - - - - - - - - - -- - --- - - - -- -. - - - - - ----- - - - - - - - - - - - - - - - - - - - - - - -- - - - -- - - - - - - - - --- -- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - - - - - - - -- - - -- - - - - -- - - -- - - - - - - - -- -- - - - - - - -- - - - - - - - - - - - --- - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - --- 04454 ST. VIIITOR HIGH SCHOOL POST PROM DONAT I ON 200.00 04139 STIINARD & ASSOCIATES PRE- EMPLOYMENT TESTING 1125.00 09165 STIIPLES BUSINESS ADVANTAGE SUPPLIES 67.32 02620 STIITE ATTORNEY IIPPELLIITE PROSECUTOR 2 SETS OF 2006 COMPLIIINT BOOKS 260.00 07365 STEINWEG I ED REIMBURSE EXPENSES 45.72 00441 STRAHL I DAVID REIMBURSEMENT 242.25 REIMBURSEMENT 85.00 ---- --------- 327.25 02649 STREICHER I S UNIFORM SUPPLIES 115.80 02672 SYSTEMS FORMS I INC. ENVELOPES 535.60 1ST NOTICE TICKETS 636.35 BLllNK PERF PIIPER 428.45 LETTERHEAD 636.35 #10 ENVELOPES 156.00 ENVELOPES #10 817.96 COVERS & BACKS 305.00 BUSINESS REPLY ENVELOPES 72 .38 BUSINESS REPLY EVVELOPES 72 .37 - ------------ 3660.46 08703 TIISER INTERNATIONAL REGISTER W.NELSON 80.00 10074 TEAM SALES ACADEMY UNIFORMS (S. CAMPION) 150.00 02691 THOMPSON ELEVIlTOR INSPECTIONS NEW CONSTRUCTION INSPECTIONS 150.00 09536 THOMPSON I ROSENTHAL & WATTS LLP LEGAL SERVI CES 3864.00 07002 TRIINSPERFECT TRANSLIITIONS LEGAL-GENERAL COUNSEL 1295.00 07375 TRI -STIIR SUPPLY INC. REPLIICEMENT DYNAMI C 1425.00 05686 ULINE INC. CD MAl LERS FOR PHOTO 65.68 08821 UNIFORMITY INCORPORATED GLOVER 114.9 8 07860 UPS MISC. SHIPPING CHllRGES 18.69 MISC .SHIPPING CHIIRGES 50.67 ------------- 69.36 08893 VID TECH 2 -1000 I ROLLS OF SPEAKER WIRE 550.00 02835 WIIREHOUSE DIRECT SUPPLIES 123 . 94 SUPPLIES 123.93 ---- ------ --- 247.87 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16: 39 RUN: THURSDAY APR122007 11: 15 PAGE RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 01 2007 TO APRIL 11 2007 - - - - - - - - -. - -. - - - - - - - -- - - - - - - -. - - - - - -- - - - - - - - - - -- - -- -- - - - - - - - - - - - - - - - -- - - - - - --- - - - - - -- - -- - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - --- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - - - - - - - - - - - - -- - - - - - - - - - -- - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - -- - - - - - - - ---- - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - -- 02860 WEST GROUP PAYMENT CENTER LAW OFFICERS BULLETIN 209.91 00461 WIDMER, CAROL REVERSE FLAP ENVELOPES 445.25 02912 ZEP MANUFACTURING COMPANY Case of Big Orange Degreaser 1 314.00 ADD I L FREIGHT 21.99 ------------- 335.99 07299 ZOLL MEDICAL CORPORATION ELECTRDES 119.20 TOTAL 190867.35 030 02016 ARC DISPOSAL COMPANY MARCH COLLECTION 77254.95 MARCH COLLECTION 13728.23 MARCH COLLECTION 46164.54 MARCH COLLECTION 30874.27 MARCH COLLECTION 5396.54 MARCH COLLECTION 2175.66 - ------------ 175594.19 08572 LESSNER, RICHARD F. REFUND. REFUSE 12.50 02155 NEXTEL COMMUNI CAT! ONS PUBLI C WORKS 91.90 TOTAL 175698.59 050 01148 COMMONWEALTH ED I SON STREET/TRAFFIC SIGNAL LIGHTING 341. 72 05709 MEADE ELECTRI C CO. INC. 2007 TRAFFIC SIGNAL MAINTENANC 1000.00 TOTAL 1341. 72 095 08991 HILS ROGAL & HOBBS INSURANCE EXPENSE 473.00 TOTAL 473.00 550 09476 H.M. WITT & CO. COMPLETION OF SIGNS & INSTALL 3000.00 03675 NORTHWEST PROPERTIES LLC SALES TAX REBATE 31647.37 TOTAL 34647.37 610 01071 ADDISON BUILDING MATERIAL CO. MISC. BUILDING MATERIALS AND 24.24 MISC. BUILDING MATERIALS AND 251.91 ----- -- ------ 276.15 08572 BEILKE, R. REFUND FINAL BILL 28.41 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY APR122007 11: 15 RELEASE ID : PAGE 10 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 01 2007 TO APRIL 11 2007 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT . - - -. - - - - - - -- - - - - - - -- -- - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - -- -- - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - -- - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- 08567 BRZEZINSKI, ROBERT WATER SERVI CE FEE 50.00 08572 CABOT I I-ILM08 ,LLC REFUND FINAL BILL 87.93 09682 CE DESIGN,LTD. PROFESSIONAL SERVICES FOR PROS 14013.78 05375 CENTURY CLEANERS UNIGORM CLEANING-SUPERVISORS 226.08 08572 EKEDAHL, JAMES REFUND FINAL BILL 69.24 01544 HBK WATER METER SERVI CE 2007 CONTRACT FOR WATER METER 88.21 2007 CONTRACT FOR WATER METER 207.93 2007 CONTRACT FOR WATER METER 85.86 - ----- -- -- --- 382.00 07433 IMAGETEC LP MONTHLY LEASE PAYMENT FOR TOSH 236.00 01427 JOSEPH D. FOREMAN & CO. 15 II MISSION COUPLING 136.00 18" MISSION COUPLING 337.00 6" MISSION COUPLING 280.00 8 II MISSION COUPLING 322.00 8" TO 6 II CLAY TO PLASTIC MISSI 110.00 12 II MISSION COUPLING 73.00 15" MISSION COUPLING 130.00 - - - --- ---- --- 1388.00 08631 LECHNER AND SONS 2007 UNIFORM RENTAL AND CLEANI 228.27 08572 LESSNER, RICHARD F. REFUND-SEWER 4.32 08572 MC CLELLAN, CHARLES REFUND-UTILITY BILL 34.09 02155 NEXTEL COMMUNICATIONS POOLI C WORKS 485.80 POOLI C WORKS 33.93 -- - -- --- --- -- 519.73 05256 NI COR GAS SERVICE 1164.73 08572 PRILESKY, KAREL REFUND FINAL BILL 5.68 08572 REPETA, MARION REFUND FINAL BILL 45.44 08572 RIES, MADELEINE REFUND FINAL BILL 159.04 08572 WILLIAMS, MICHAEL REFUND FINAL BILL 11.36 08572 YOUSIF, EDWARD REFUND FINAL BILL 22.94 TOTAL 18953.19 620 08711 QUALITY MAINTENANCE SYSTEMS, INC. 2007 CONTRACT FOR CUSTODIAL SE 1822.86 TOTAL 1822.86 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY APR122007 11: 15 RELEASE ID : PAGE 11 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 01 2007 TO APRIL 11 2007 DEPT VENDOR NBR VENDOR NAME INVOI CE DESCRIPTION AMOUNT 530 08711 QUALITY MAINTENANCE SYSTEMS I INC. 2007 CONTRACT FOR CUSTODIAL SE 296.96 TOTAL 296.96 560 02940 BRAKE ALIGN COMPANY 66864F WEBCO REAR BRAKE DRUM 179.90 357 BENDIX REAR BRAKE SHOES 162.00 ADD I L CHARGE/BRAKE DRUM 29.85 BENDIX REAR BRAKE SHOES 8D.35 . ------- ----- 452.10 01006 BUSSE CAR WASH I INC. CAR WASHES FROM 1/1/07 - 6/30/ 858.00 01045 CATCHING FLUID POWER PARKER HYDRAULIC FITTING 155.11 06691 JUST TIRES P2355/55WR17 GOODYEAR EAGLE RS 1150.32 STATE TIRE FEE 30.00 ---- ---- ----- 1180.32 06470 LYNCH AUTO GROUP - FORD FORD CROWN VI CTOIA AND FORD 2514.8 8 02155 NEXTEL COMMUNI CATI ONS PUBLIC WORKS 270.88 02684 TERRACE SUPPLY COMPANY OXYGEN CYLINDER EXCHANGE 381.65 02769 UPTOWN AUTO SUPPLY AC DELCO HORN KIT 84.34 02861 WEST S IDE TRACTOR SALES JOHN DEERE TRACTOR PARTS 2091.97 TOTAL 7989.25 i70 02861 WEST SIDE TRACTOR SALES WORK LAMPS 121.68 TOTAL 121.68 i90 05523 BUTZ I BARBARA REPLACEMENT OF MAILBOX 125.00 08109 CAMBRIDGE INTEGRATED SERVICE W/C REIMBURSEMENT 10667.92 W/C REIMBURSEMENT 7461.54 -- -------- - -- 18129.46 10072 CANNON COCHRAN MANAGEMENT SERVI CES I INC. CLAIMS ADMIN-GENERAL 2583.32 01451 GAB ROBINS NORTH AMERICA LIABILITY CLAIMS 379.00 CLAIMS ADMIN-GENERAL 1000.00 CLAIMS ADMIN-GENERAL 1652.50 ------------- 3031.50 08991 HILB ROGAL & HOBBS SURETY BONDS - ERB 1150.00 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY APR122007 11: 15 PAGE 12 RELEASE ID : VI LLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 01 2007 TO APRIL 11 2007 ~ - - - - - - - - - - --- - - - - - - - - -. - - - - - - - - - - - -- - - -. - - - - - - - - - - - - - - - - - - - --- - -- - - - - - - - - -- - - - - - - - -- - - - - -- - - - - -- - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - -- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - -- - - - - - --- - - - - - - - - - - - - - - - - - -- - - - - - - - - -- - - - - - - - - - - - - - -- - - - - - - - -- - - - - - - - - - - - - - -- - - - - - - - - - - - - - -- - - - -- - - - - - - - - - __a - - - - - - __ - - - - - - __ SURETY BONDS -JANONIS 400.00 SURETY BONDS - WILKS 400.00 FATHFUL PERFORMANCE 2423.00 -----------_. 4373.00 08710 MILLIMAN, INC. PROPERTY INSURANCE B551.25 09900 P.J.D. SALES,INC. REPLACEMENT LIGHT POLE 1360.00 TOTAL 3B153.53 710 01027 CAPITAL GAINS INC. POLICE PENSION 1785.62 09635 WELLS FARGO BANK POLICE PENSION B65.10 TOTAL 2650.72 720 01027 CAPITAL GAINS INC. FIRE PENSION 2315.70 0660B CARY J. COLLINS, P.C. LEGAL EXPENSE 650.00 09635 WELLS FARGO BANK FIRE PENSION 9B4.52 TOTAL 3950.22 770 02513 ABERNETHY, JANET T. FLEX COMP 42B.00 00301 ADAMCZYK, TED D. FLEX COMP 216.33 02667 BEHUN, DAVID FLEX COMP 299. B6 100B5 BONNER, MARK FLEX COMP 136 7.B B 00477 BURES, PAUL FLEX COMP 5B9.29 0030B CONNOLLY, JUDY FLEX COMP 519.76 01219 DAHLBERG, JOHN K. FLEX COMP 206.00 00321 DRAFFONE, RICHARD FLEX COMP 32.17 FLEC COMP 190.42 -- -- __a - ___._ 222.59 04B40 EVANS, MARGARET FLEX COMP 195.66 00330 FELTEN, BARBARA FLEX COMP 120.00 05276 FIGOLAH, MICHAEL FLEX COMP 518.40 07082 FONSECA, MICHAEL FLEX COMP 520.00 05989 GARRIS, JOSEPH FLEX COMP 161.99 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY APR122007 11: 15 RELEASE ID : PAGE 13 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 01 2007 TO APRIL 11 2007 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 05093 GRANDGEORGE, ARRON FLEX COMP 218.00 00342 GUENTHER, JAMES E. FLEX COMP 2228.37 00343 GUTIERREZ, JULIE M. FLEX COMP 18.00 01722 INGEBRIGTSEN, JAMES FLEX COMP 689.88 01765 JANONI S, MI CHAEL E. FLEX COMP 71.50 10020 JAROG, LYNN FLEX COMP 416.66 FLEX COMP 101.92 - ~ ~. - - - - - - - -- 518.58 01844 KRUPA, FRANK M. FLEX COMP 182.31 07611 LAMBEL, BRIAN FLEX COMP 305.55 07237 LOPOTKO, THOMAS FLEX COMP 300.00 02034 MILLER, JAMES FLEX COMP 916.00 00399 MORGAN, NANCY FLEX COMP 107.31 02206 NOWAK, THOMAS J. FLEX COMP 965.15 02433 RICKER, JEFFREY FLEX COMP 111.0 0 02450 ROELS, ROBERT J. FLEX COMP 115.31 02473 RUMORE, CINDY JO FLEX COMP 202.81 09896 SCHMITZ, JEFFREY FLEX COMP 703.00 09778 SCHRAEDER, TRICIA FLEX COMP 62.44 02508 SCHULTZ, WALTER FLEX COMP 337.51 02631 STEPHENSON, MI CHAEL R. FLEX COMP 96.00 02644 STRAHL, DAVID FLEX COMP 371.47 02710 TRACY, RI CHARD L. FLEX COMP 607.00 TOTAL 14492.95 790 01791 K - PLUS ENVIRONMENTAL, INC. PROFESSIONAL CONSULTING 520.00 PROFESSIONAL CONSULTING 520.00 .----------.- 1040.00 02689 THIRD DISTRICT CIRCUIT COURT BOND MONEY 800.00 BOND MONEY 1450.00 BOND MONEY 275.00 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16: 39 DEPT VENDOR NBR 02808 02886 RUN: THURSDAY APR122007 11:15 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 01 2007 TO APRIL 11 2007 VENDOR NAME VILLAGE OF MOUNT PROSPECT WISCONSIN DEPARTMENT OF REVENUE INVOICE DESCRIPTION BOND MONEY ESCROW CHECKS 79025-79056 WISC. INCOME TAX FOR MARCH TOTAL GRAND TOTAL PAGE 14 AMOUNT 1555.00 4080.00 7600.00 1110.99 13830.99 505290 .3 8 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY APR122001 11: 15 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 01 2001 TO APRIL 11 2001 SUMMARY BY FUND 001 GENERAL FUND 190861.35 030 REFUSE DISPOSAL FUND 115698.59 050 MOTOR FUEL TAX FUND 1341.12 095 FOREIGN FIRE TAX BOARD FUND 413.00 550 DOWNTOWN REDEVLPMNT CONST 34641.31 610 WATER AND SEWER FUND 18953.19 620 VILLAGE PARKING SYSTEM FUND 1822.86 630 PARKING SYSTEM REVENUE FUND 296.96 660 VEHICLE MAINTENANCE FUND 198 9.2 5 670 VEHI CLE REPLACEMENT FUND 121.68 690 RISK MANAGEMENT FUND 38153.53 710 POLICE PENSION FUND 2650.12 720 FIRE PENSION FUND 3950.22 170 FLEXCOMP ESCROW FUND 14492.95 790 ESCROW DEPOSIT FUND 13830.99 ..-..-....-.-- TOTAL : 505,290.38 -: PAGE 15