Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
3. BILLS & FINANCIALS 12/21/04
VILLAGE OF MOUNT PROSPECT BUDGET REVENUE & EXPEND ITURE SUMMARIES January 1 '" November 30, 2004 '12/10/2004 16:32:48 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 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 SERIES 1987A B&I, PW FACILITY SERIES 1993B B&I, PUBLIC BLDGS SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2002B B&I, PUBLIC BLDGS SERIES 2002A B&I, TIF SERIES 1993A B&I, TIF SERIES 1994B B&I, TIF SERIES 1996B B&I, TIF SERIES 1998B B&I, TIF SERIES 1999 B&I, TIF SERIES 1992A B&I, FLOOD SERIES 1993B B&I, FLOOD SERIES 1994A B&I, FLOOD 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 1994A B&I, STREET IMP. SERIES 1996A B&I, STREET IMP. SERIES 1998A B&I, STREET IMP. SERIES 2002B B&I, STREET IMP. CAPITAL IMPROVEMENT FUND POLICE & FIRE BLDG CONST FUND SERIES 2001 PROJECT FUND SERIES 2003 PROJECT FUND 2002 LIBRARY PROJECT FUND VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/04 11/30/04 Cur Mo Received 4,006,913 2,095,178 118,311 1,211,096 1,264,498 61,799 116,899 18,797 591,741 140,390 9,625,622 4,748,293 872,149 120,543 1 45,083 70 76 2,320 24,069 0 135,193 135,581 203,289 22,677 0 0 0 0 " 415,289 0 0 0 17,573 7,247 77,170 9,136 12,738 47,041 0 0 56,187 37,743 3,249 0 0 30,000 0 1 Y-T-D Received 9,455,613 9,762,390 2,900,625 10,745,704 13,733,492 521,614 2,643,386 501,382 3,360,238 1,809,830 55,434,274 24,845,814 2,832,048 1,362,977 20 476,724 526 33,847 18,177 56,982 0 326,452 776,040 480,903 39,051 0 0 0 0 712,450 o 0 0 138,657 57,308 132,808 72,542 100,868 371,247 0 0 443,925 297,858 220,917 0 0 25,493 0 11 Months ( 1 Month ( 2004 Budget 11,453,283 12,378,646 2,814,250 14,903,344 15,373,741 556,500 4,431,950 627,051 4,147,865 1,022,730 67,709,360 31,218,204 3,317,523 1,662,015 10,000 550,450 7,700 12,000 10,100 67,700 0 387,967 942,795 581,500 44,500 0 0 0 0 812,500 0 0 0 206,000 85,100 151,000 107,926 150,250 551,000 0 0 657,591 440,335 452,551 0 0 40,000 0 91.6% ) Completed 8.3% ) Remaining Unreceived Balance 1,997,670 2,616,256 -86,375 4,157,640 1,640,249 34,886 1,788,564 125,669 787,627 -787,100 12,275,086 6,372,390 485,475 299,038 9,980 73,726 7,174 -21,847 -8,077 10,718 0 61,515 166,755 100,597 5,449 0 0 0 0 100,050 0 67,343 27,792 18,192 35,384 49,382 179,753 0 0 213,666 142,477 231,634 0 0 14,507 0 Unreceived Percent 17.4 21.1 -3.1 27.9 10.7 6.3 40.4 20.0 19.0 -77.0 18.1 20.4 14.6 18.0 99.8 13.4 93.2 -182.1 -80.0 15.8 15.9 17.7 17.3 12.2 12.3 0 0 32.7 32.7 12.0 32.8 32.9 32.6 32.5 32.4 51. 2 36.3 12/10/2004 16:32:48 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/04 11/30/04 11 Months ( 1 Month ( 91.6% ) Completed. 8.3% ) Remaining Cur Mo Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent CAPITAL IMPROVEMENT CONST FUND 0 0 0 0 DOWNTOWN REDEVLPMNT CONST 224,758 1,092,277 440,077 -652,200 -148.2 STREET IMPROVEMENT CONST FUND 109,546 1,214,824 1,500,165 285,341 19.0 FLOOD CONTROL CONST 1998A 0 0 0 0 FLOOD CONTROL CONST FUND 2,002 16,214 15,000 -1,214 -8.1 WATER AND SEWER FUND 1,039,786 7,189,485 8,246,940 1,057,455 12.8 VILLAGE PARKING SYSTEM FUND 6,947 318,789 135,650 -183,139 -135.0 PARKING SYSTEM REVENUE FUND 9,428 71,515 241,655 170,140 70.4 VEHICLE MAINTENANCE FUND 102,397 1,124,236 1,228,529 104,293 8.5 VEHICLE REPLACEMENT FUND 78,836 891,955 1,045,548 153,593 14.7 COMPUTER REPLACEMENT FUND 19,136 206,531 227,906 21,375 9.4 RISK MANAGEMENT FUND 441,026 4,794,741 5,269,830 475,089 9.0 POLICE PENSION FUND 270,302 2,347,671 3,431,674 1,084,003 31.6 FIRE PENSION FUND 285,927 2,310,849 3,428,691 1,11 7,842 32.6 BENEFIT TRUST #2 FUND 0 0 0 0 ESCROW DEPOSIT FUND -4,064 0 0 0 SSA #1 PROSPECT MEADOWS B&I 0 0 0 0 SSA #6 GEORGE/ALBERT B&I 15,499 29,853 30,988 1,135 3.7 SERIES 2002 LIBRARY BND ESCROW 1,379 1,700 0 -1,700 Total All Funds 9,625,622 55,434,274 67,709,360 12,275,086 18.1 2 '12/10/2004 16:33:43 FRRBRRO3 SUM 021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund 01/0~/04 11/30/04 11 Months ( 1 Month ( 91.6% ) Completed 8.3% ) Remaining Summary 40 41 42 43 44 Cur Mo Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent 2,855,568 6,746,578 8,164,528 1,417,950 17.4 553,358 4,766,517 5,921,639 1,155,122 19.5 114,618 2,677,126 2,581,250 -95,876 -3.7 1,068,799 9,040,468 12,535,274 3,494,806 27.9 68,952 668,265 806,863 138,598 17.2 59,499 470,197 527,000 56,803 10.8 1,104 45,514 230,000 184,486 80.2 16,117 240,462 316,650 76,188 24.1 10,278 190,687 135,000 -55,687 -41.2 4,748,293 24,845,814 31,218,204 6,372,390 20.4 GENERAL FUND 45 46 47 48 PROPERTY TAXES OTHER TAXES LICENSES, PERMITS & FEES INTERGOVERMENT REV. CHARGES FOR SERVICE FINES AND FORFEITS INVESTMENT INCOME REIMBURSEMENTS OTHER REVENUE TOTAL GENERAL FUND REFUSE DISPOSAL FUND 40 44 46 48 PROPERTY TAXES CHARGES FOR SERVICE INVESTMENT INCOME OTHER REVENUE 795,035 1,871,549 2,278,223 406,674 17.9 74,974 934,511 1,009,300 74,789 7.4 2,140 25,371 30,000 4,629 15.4 0 617 0 -617 872,149 2,832,048 3,317,523 485,475 14.6 TOTAL REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND 43 46 47 INTERGOVERMENT REV. INVESTMENT INCOME REIMBURSEMENTS 116,021 1,331,044 1,630,765 299,721 18.4 2,435 19,773 30,000 10,227 34.1 2,087 12,160 1,250 -10,910 -872.8 120,543 1,362,977 1,662,015 299,038 18.0 TOTAL MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT 43 46 INTERGOVERMENT REV. INVESTMENT INCOME 0 1 0 20 10,000 0 10,000 -20 100.0 TOTAL LAW ENFORCEMENT BLOCK GRANT 1 20 10,000 9,980 99.8 COMMUNITY DEVELPMNT BLOCK GRNT 43 46 48 INTERGOVERMENT REV. INVESTMENT INCOME OTHER REVENUE 26,276 374,192 485,450 111,258 22.9 -28 -17 0 17 18,835 102,549 65,000 -37,549 -57.8 45,083 476,724 550,450 73,726 13.4 TOTAL COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND 45 46 FINES AND FORFEITS INVESTMENT INCOME 0 70 8 518 7,500 200 7,492 -318 99.9 -159.0 TOTAL ASSET SEIZURE FUND 70 526 7,700 7,174 93.2 DEA SHARED FUNDS FUND 45 46 FINES AND FORFEITS INVESTMENT INCOME 0 76 33,365 482 12,000 0 -21,365 -482 -178.0 TOTAL DEA SHARED FUNDS FUND 76 33,847 12,000 -21,847 -182.1 1 12/10/2004 11 Months ( 91.6%) Completed 16:33:43 VILLAGE OF MOUNT PROSPECT 1 Month ( 8.3%) Remaining FRRBRRO3 SUM 021 Budget Revenue by Category within Fund Summary 01/01/04 11/30/04 Cur Mo Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent DUI FINE FUND 45 FINES AND FORFEITS 2,300 18,044 10,000 -8,044 -80.4 46 INVESTMENT INCOME 20 133 100 -33 -33.0 TOTAL DUI FINE FUND 2,320 18,177 10,100 -8,077 -80.0 SERIES 1987A B&I, PW FACILITY 40 PROPERTY TAXES 24,006 56,649 67,500 10,851 16.1 46 INVESTMENT INCOME 63 333 200 -133 -66.5 TOTAL SERIES 1987A B&I, PW FACILITY 24,069 56,982 67,700 10,718 15.8 SERIES 1993B B&I, PUBLIC BLDGS 40 PROPERTY TAXES 0 0 0 0 46 INVESTMENT INCOME 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 1993B B&I, PUBLIC BLDGS 0 0 0 0 SERIES 2001 B&I, VILLAGE HALL 40 PROPERTY TAXES 129,652 304,004 366,032 62,028 16.9 46 INVESTMENT INCOME 182 1,013 500 -513 -102.6 49 OTHER FINANCING SOURCES 5,359 21,435 21,435 0 TOTAL SERIES 2001 B&I, VILLAGE HALL 135,193 326,452 387,967 61,515 15.9 SERIES 2003 B&I, VILLAGE HALL 40 PROPERTY TAXES 0 0 0 0 46 INVESTMENT INCOME 581 2,569 1,500 -1,069 -71.3 49 OTHER FINANCING SOURCES 135,000 773,471 941,295 167,824 17.8 TOTAL SERIES 2003 B&I, VILLAGE HALL 135,581 776,040 942,795 166,755 17.7 SERIES 2002B B&I, PUBLIC BLDGS 40 PROPERTY TAXES 202,652 476,833 577,000 100,167 17.4 46 INVESTMENT INCOME 637 4,070 4,500 430 9.6 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2002B B&I, PUBLIC BLDGS 203,289 480,903 581,500 100,597 17.3 SERIES 2002A B&I, TIF 41 OTHER TAXES 22,575 38,588 44,000 5,412 12.3 46 INVESTMENT INCOME 71 432 500 68 13.6 49 OTHER FINANCING SOURCES 31 31 0 -31 TOTAL SERIES 2002A B&I, TIF 22,677 39,051 44,500 5,449 12.2 SERIES 1993A B&I, TIF 41 OTHER TAXES 0 0 0 0 46 INVESTMENT INCOME 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 0 0 2 '12/10/2004 16:33:43 FRRBRRO3 SUM 021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/04 - 11/30/04 11 Months ( 1 Month ( 91.6% ) Completed 8.3% ) Remaining TOTAL SERIES 1993A B&I, TIF Cur Mo Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent 0 0 0 0 SERIES 1994B B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 0 0 0 0 0 0 0 0 TOTAL SERIES 1994B B&I, TIF 0 0 0 0 SERIES 1996B B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL SERIES 1996B B&I, TIF SERIES 1998B B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 0 0 0 0 0 0 0 0 TOTAL SERIES 1998B B&I, TIF 0 0 0 0 SERIES 1999 B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 415,063 709,480 809,000 99,520 12.3 226 2,970 3,500 530 15.1 0 0 0 0 415,289 712,450 812,500 100,050 12.3 TOTAL SERIES 1999 B&I, TIF SERIES 1992A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 0 0 0 0 0 0 0 0 TOTAL SERIES 1992A B&I, FLOOD 0 0 0 0 SERIES 1993B B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL SERIES 1993B B&I, FLOOD SERIES 1994A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL SERIES 1994A B&I, FLOOD SERIES 1996A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 17,353 220 137,606 1,051 205,000 1,000 67,394 -51 32.9 -5.1 3 12/10/2004 11 Months ( 91.6%) Completed ., 16,33:43 PROSPECT 1 Month ( 8.3%) Remaining FRRBRRO3 VILLAGE OF MOUNT SUM 021 Budget Revenue by Category within Fund Summary 01/01/04 11/30/04 Cur Mo Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent TOTAL SERIES 1996A B&I, FLOOD 17,573 138,657 206,000 67,343 32.7 SERIES 1998A B&I, FLOOD 41 OTHER TAXES 7,195 57,056 85,000 27,944 32.9 46 INVESTMENT INCOME 52 252 100 -152 -152.0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 1998A B&I, FLOOD 7,247 57,308 85,100 27,792 32.7 SERIES 1998C B&I, TIF 41 OTHER TAXES 76,959 131,548 150,000 18,452 12.3 46 INVESTMENT INCOME 211 1,260 1,000 -260 -26.0 TOTAL SERIES 1998C B&I, TIF 77,170 132,808 151,000 18,192 12.0 IEPA FLOOD CONTROL LOANS B&I 41 OTHER TAXES 9,136 72,445 107,926 35,481 32.9 46 INVESTMENT INCOME 0 97 0 -97 TOTAL IEPA FLOOD CONTROL LOANS B&I 9,136 72,542 107,926 35,384 32.8 SERIES 2000 B&I, FLOOD CONTROL 41 OTHER TAXES 12,697 100,687 150,000 49,313 32.9 46 INVESTMENT INCOME 41 181 250 69 27.6 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2000 B&I, FLOOD CONTROL 12,738 100,868 150,250 49,382 32.9 SERIES 2002B B&I, FLOOD 41 OTHER TAXES 46,557 369,187 550,000 180,813 32.9 46 INVESTMENT INCOME 484 2,060 1,000 -1,060 -106.0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2002B B&I, FLOOD 47,041 371,247 551,000 179,753 32.6 SERIES 1994A B&I, STREET IMP. 41 OTHER TAXES 0 0 0 0 46 INVESTMENT INCOME 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 1994A B&I, STREET IMP. 0 0 0 0 SERIES 1996A B&I, STREET IMP. 41 OTHER TAXES 0 0 0 0 46 INVESTMENT INCOME 0 0 0 0 TOTAL SERIES 1996A B&I, STREET IMP. 0 0 0 0 SERIES 1998A B&I, STREET IMP. 41 OTHER TAXES 55,664 441,407 657,591 216,184 32.9 46 INVESTMENT INCOME 523 2,518 0 -2,518 49 OTHER FINANCING SOURCES 0 0 0 0 4 . 12/10/2004 11 Months ( 91. 6% ) Completed 16:33:43 MOUNT 1 Month ( 8.3%) Remaining FRRBRRO3 VILLAGE OF PROSPECT SUM 021 Budget Revenue by Category within Fund Summary 01/01/04 - 11/30/04 Cur Mo Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent TOTAL SERIES 1998A B&I, STREET IMP. 56,187 443,925 657,591 213,666 32.5 SERIES 2002B B&I, STREET IMP. 41 OTHER TAXES 37,274 295,574 440,335 144,761 32.9 46 INVESTMENT INCOME 469 2,284 0 -2,284 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2002B B&I, STREET IMP. 37,743 297,858 440,335 142,477 32.4 CAPITAL IMPROVEMENT FUND 43 INTERGOVERMENT REV. 0 0 112,400 112,400 100.0 46 INVESTMENT INCOME 3,249 25,172 20,000 -5,172 -25.9 47 REIMBURSEMENTS 0 162,105 239,151 77,046 32.2 48 OTHER REVENUE 0 13,640 81,000 67,360 83.2 49 OTHER FINANCING SOURCES 0 20,000 0 -20,000 TOTAL CAPITAL IMPROVEMENT FUND 3,249 220,917 452,551 231,634 51.2 POLICE & FIRE BLDG CONST FUND 46 INVESTMENT INCOME 0 0 0 0 TOTAL POLICE & FIRE BLDG CONST FUND 0 0 0 0 SERIES 2001 PROJECT FUND 46 INVESTMENT INCOME 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2001 PROJECT FUND 0 0 0 0 SERIES 2003 PROJECT FUND 46 INVESTMENT INCOME 30,000 25,493 40,000 14,507 36.3 48 OTHER REVENUE 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2003 PROJECT FUND 30,000 25,493 40,000 14,507 36.3 2002 LIBRARY PROJECT FUND 46 INVESTMENT INCOME 0 0 0 0 48 OTHER REVENUE 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL 2002 LIBRARY PROJECT FUND 0 0 0 0 CAPITAL IMPROVEMENT CONST FUND 43 INTERGOVERMENT REV. 0 0 0 0 46 INVESTMENT INCOME 0 0 0 0 TOTAL CAPITAL IMPROVEMENT CONST FUND 0 0 0 0 DOWNTOWN REDEVLPMNT CONST 41 OTHER TAXES 224,758 384,187 438,077 53,890 12.3 46 INVESTMENT INCOME 0 3,090 2,000 -1,090 -54.5 5 12/10/2004 11 Months ( 91.6%) Completed 16:33:43 VILLAGE OF MOUNT PROSPECT 1 Month ( 8.3%) Remaining FRRBRRO3 SUM 021 Budget Revenue by Category within Fund Summary 01/01/04 11/30/04 Cur Mo Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent 47 REIMBURSEMENTS 0 0 0 0 48 OTHER REVENUE 0 0 0 0 49 OTHER FINANCING SOURCES 0 705,000 0 -705,000 TOTAL DOWNTOWN REDEVLPMNT CONST 224,758 1,092,277 440,077 -652,200 -148.2 STREET IMPROVEMENT CONST FUND 41 OTHER TAXES 104,780 978,511 1,252,165 273,654 21. 9 42 LICENSES, PERMITS & FEES 3,693 223,499 228,000 4,501 2.0 46 INVESTMENT INCOME 1,073 12,814 20,000 7,186 35.9 48 OTHER REVENUE 0 0 0 0 TOTAL STREET IMPROVEMENT CONST FUND 109,546 1,214,824 1,500,165 285,341 19.0 FLOOD CONTROL CONST 1998A 46 INVESTMENT INCOME 0 0 0 0 TOTAL FLOOD CONTROL CONST 1998A 0 0 0 0 FLOOD CONTROL CONST FUND 41 OTHER TAXES 0 0 0 0 43 INTERGOVERMENT REV. 0 0 0 0 46 INVESTMENT INCOME 2,002 16,214 15,000 -1,214 -8.1 47 REIMBURSEMENTS 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL FLOOD CONTROL CONST FUND 2,002 16,214 15,000 -1,214 -8.1 WATER AND SEWER FUND 41 OTHER TAXES 496,363 1,250,033 1,537,025 286,992 18.7 44 CHARGES FOR SERVICE 537,440 5,872,438 6,624,915 752,477 11.4 46 INVESTMENT INCOME 3,509 48,660 70,000 21,340 30.5 47 REIMBURSEMENTS 0 0 0 0 48 OTHER REVENUE 2,474 18,354 15,000 -3,354 -22.4 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL WATER AND SEWER FUND 1,039,786 7,189,485 8,246,940 1,057,455 12.8 VILLAGE PARKING SYSTEM FUND 42 LICENSES, PERMITS & FEES 0 0 5,000 5,000 100.0 44 CHARGES FOR SERVICE 7,685 72,014 119,850 47,836 39.9 46 INVESTMENT INCOME -738 1,145 10,800 9,655 89.4 49 OTHER FINANCING SOURCES 0 245,630 0 -245,630 TOTAL VILLAGE PARKING SYSTEM FUND 6,947 318,789 135,650 -183,139 -135.0 PARKING SYSTEM REVENUE FUND 42 LICENSES, PERMITS & FEES 0 0 0 0 43 INTERGOVERMENT REV. 0 0 129,455 129,455 100.0 44 CHARGES FOR SERVICE 9,280 68,956 105,000 36,044 34.3 46 INVESTMENT INCOME 148 2,559 7,200 4,641 64.5 48 OTHER REVENUE 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 0 0 6 +12/10/2004 16:33:43 FRRBRRO3 SUM 021 11 Months ( 1 Month ( 91.6% ) Completed 8.3% ) Remaining Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/04 - 11/30/04 Cur Mo Received TOTAL PARKING SYSTEM REVENUE FUND 9,428 VEHICLE MAINTENANCE FUND 44 46 48 CHARGES FOR SERVICE INVESTMENT INCOME OTHER REVENUE 101,752 645 0 TOTAL VEHICLE MAINTENANCE FUND 102,397 VEHICLE REPLACEMENT FUND 44 46 67,965 10,871 0 0 CHARGES FOR SERVICE INVESTMENT INCOME OTHER REVENUE OTHER FINANCING SOURCES 48 49 TOTAL VEHICLE REPLACEMENT FUND 78,836 COMPUTER REPLACEMENT FUND 44 46 CHARGES FOR SERVICE INVESTMENT INCOME 17,993 1,143 TOTAL COMPUTER REPLACEMENT FUND 19,136 RISK MANAGEMENT FUND 43 44 INTERGOVERMENT REV. CHARGES FOR SERVICE INVESTMENT INCOME REIMBURSEMENTS OTHER REVENUE 0 378,457 2,137 593 59,839 46 47 48 TOTAL RISK MANAGEMENT FUND 441,026 POLICE PENSION FUND 46 48 INVESTMENT INCOME OTHER REVENUE 16,588 253,714 TOTAL POLICE PENSION FUND 270,302 FIRE PENSION FUND 46 48 INVESTMENT INCOME OTHER REVENUE 39,326 246,601 TOTAL FIRE PENSION FUND 285,927 BENEFIT TRUST #2 FUND 46 INVESTMENT INCOME TOTAL BENEFIT TRUST #2 FUND ESCROW DEPOSIT FUND 46 INVESTMENT INCOME -4,064 7 Y-T-D Received 71,515 1,119,279 4,957 0 1,124,236 747,586 100,106 0 44,263 891,955 197,913 8,618 206,531 0 4,052,530 18,722 86,655 636,834 4,794,741 1,087,883 1,259,788 2,347,671 1,173,080 1,137,769 2,310,849 0 0 2004 Budget Unreceived Balance 241,655 1,221,029 7,500 0 1,228,529 815,548 170,000 0 60,000 1,045,548 215,906 12,000 227,906 0 4,455,330 42,000 70,000 702,500 5,269,830 1,786,000 1,645,674 3,431,674 1,925,000 1,503,691 3,428,691 0 0 ° 0 0 0 170,140 101,750 2,543 0 104,293 67,962 69,894 0 15,737 153,593 17,993 3,382 21,375 0 402,800 23,278 -16,655 65,666 475,089 698,117 385,886 1,084,003 751,920 365,922 1,117,842 Unreceived Percent 70.4 8.3 33.9 8.5 8.3 41.1 26.2 14.7 8.3 28.2 9.4 9.0 55.4 -23.8 9.3 9.0 39.1 23.4 31.6 39.1 24.3 32.6 0 0 0 12/10/2004 16:33:43 FRRBRRO3 SUM 021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/04 - 11/30/04 11 Months ( 1 Month ( 91.6% ) Completed. 8.3% ) Remaining TOTAL ESCROW DEPOSIT FUND Cur Mo Y-T-D 2004 Unreceived unreceived Received Received Budget Balance Percent -4,064 0 0 0 SSA #1 PROSPECT MEADOWS B&I 41 OTHER TAXES 46 INVESTMENT INCOME 0 0 0 0 0 0 0 0 TOTAL SSA #1 PROSPECT MEADOWS B&I 0 0 0 0 SSA #6 GEORGE/ALBERT B&I 41 OTHER TAXES 46 INVESTMENT INCOME 15,446 53 29,564 289 30,888 100 1,324 4.3 -189 -189.0 TOTAL SSA #6 GEORGE/ALBERT B&I 15,499 29,853 30,988 1,135 3.7 SERIES 2002 LIBRARY BND ESCROW 46 INVESTMENT INCOME 1,379 1,700 0 -1,700 TOTAL SERIES 2002 LIBRARY BND ESCROW 1,379 1,700 0 -1,700 MOUNT PROSPECT LIBRARY FUND 49 OTHER FINANCING SOURCES 0 0 23,641,875 23,641,875 100.0 TOTAL MOUNT PROSPECT LIBRARY FUND 0 0 23,641,875 23,641,875 100.0 8 -12/10/2004 16:31:35 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/04 11/30/04 11 Months ( 1 Month ( 91.6% ) Completed 8.3% ) Remaining Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent EXPENDITURE BY CLASSIFICATION PERSONAL SERVICES 1,590,377 19,211,980 21,229,055 2,017,075 9.5 EMPLOYEE BENEFITS 834,830 6,172,412 7,323,690 1,151,278 15.7 OTHER EMPLOYEE COSTS 36,779 212,602 286,426 73 ,824 25.8 PENSION BENEFITS 388,992 3,982,333 4,544,714 562,381 12.4 CONTRACTUAL SERVICES 1,043, 311 11,937,609 13,604,973 1,667,364 12.3 UTILITIES 36,592 365,908 528,812 162,904 30.8 INSURANCE 483,604 5,278,273 6,079,627 801,354 13.2 COMMODITIES & SUPPLIES 86,787 1,000,990 1,106,272 105,282 9.5 OTHER EXPENDITURES 714,168 1,055,137 754,005 -301,132 -39.9 LAND IMPROVEMENTS 6,160 33,550 27,390 -6,160 -22.5 BUILDING IMPROVEMENTS -750,438 5,813,815 6,079,855 266,040 4.4 OFFICE EQUIPMENT 410,422 989,794 618,458 -371,336 -60.0 MOBILE EQUIPMENT 23,333 695,576 1,115,300 419,724 37.6 OTHER EQUIPMENT 17,311 292,481 549,395 256,914 46.8 DISTRIBUTION SYSTEMS 4,400 636,174 1,387,632 751,458 54.2 INFRASTRUCTURE 493,755 5,018,056 6,674,146 1,656,090 24.8 BOND PRINCIPAL 3,822,409 4,524,373 4,608,069 83,696 1.8 INTEREST EXPENSE 535,544 1,418,124 1,452,835 34,711 2.4 BANK AND FISCAL FEES 900 4,650 7,800 3,150 40.4 INTERFUND TRANSFERS 140,390 1,040,567 962,730 -77,837 -8.1 OTHER FINANCING USES 0 0 0 0 Total All Funds 9,919,626 69,684,404 78,941,184 9,256,780 11.7 EXPENDITURE BY FUND GENERAL FUND 3,181,727 28,529,097 31,655,480 3,126,383 9.9 REFUSE DISPOSAL FUND 322,602 3,131,713 3,533,222 401,509 11.4 MOTOR FUEL TAX FUND 212,023 1,783,155 2,461,793 678,638 27.6 LAW ENFORCEMENT BLOCK GRANT -1,392 11,123 12,524 1,401 11.2 COMMUNITY DEVELPMNT BLOCK GRNT 12,129 447,887 620,305 172,418 27.8 ASSET SEIZURE FUND 0 0 7,000 7,000 100.0 DEA SHARED FUNDS FUND 0 18,653 4,700 -13,953 -296.9 DUI FINE FUND 0 10,144 3,000 -7,144 -238.1 SERIES 1987A B&I, PW FACILITY 0 66,000 66,000 0 SERIES 1993B B&I, PUBLIC BLDGS 0 0 0 0 SERIES 2001 B&I, VILLAGE HALL 283,889 387,778 387,778 0 SERIES 2003 B&I, VILLAGE HALL 677,816 916,231 916,232 1 SERIES 2002B B&I, PUBLIC BLDGS 632,778 649,656 649,956 300 SERIES 2002A B&I, TIF 51,450 52,900 53,800 900 1.7 SERIES 1992B B&I, TIF 0 0 0 0 SERIES 1993A B&I, TIF 0 0 0 0 SERIES 1994B B&I, TIF 0 0 0 0 SERIES 1996B B&I, TIF 24 24 0 -24 SERIES 1998B B&I, TIF 7 7 0 -7 SERIES 1999 B&I, TIF 0 708,500 708,500 0 SERIES 1991A B&I, FLOOD 0 0 0 0 SERIES 1992A B&I, FLOOD 0 0 0 0 SERIES 1993B B&I, FLOOD 0 0 0 0 SERIES 1994A B&I, FLOOD 0 0 0 0 SERIES 1996A B&I, FLOOD 202,590 215,630 216,080 450 0.2 SERIES 1998A B&I, FLOOD 59,976 65,102 65,252 150 0.2 SERIES 1998C B&I, TIF 134,588 149,475 149,775 300 0.2 1 -. . - 12/10/2004 16:31:35 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/04 11/30/04 11 Months ( 1 Month ( 91.6% ) Completed 8.3% ) Remaining Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent IEPA FLOOD CONTROL LOANS B&I 168,629 494,952 613,357 118,405 19.3 SERIES 2000 B&I, FLOOD CONTROL 55,749 112,098 112,098 0 SERIES 2002B B&I, FLOOD 482,591 492,081 492,381 300 0.1 SERIES 1994A B&I, STREET IMP. 0 0 0 0 SERIES 1996A B&I, STREET IMP. 0 0 0 0 SERIES 1998A B&I, STREET IMP. 877,737 895,624 895,775 151 SERIES 2002B B&I, STREET IMP. 592,312 599,625 600,225 600 0.1 CAPITAL IMPROVEMENT FUND 32,889 390,181 912,111 521,930 57.2 POLICE & FIRE BLDG CONST FUND 0 0 0 0 SERIES 2001 PROJECT FUND 0 0 100,000 100,000 100.0 SERIES 2003 PROJECT FUND -715,896 6,150,629 5,786,400 -364,229 -6.3 2002 LIBRARY PROJECT FUND 0 0 0 0 CAPITAL IMPROVEMENT CONST FUND 0 0 0 0 DOWNTOWN REDEVLPMNT CONST 708,284 2,032,897 1,824,982 -207,915 -11.4 STREET IMPROVEMENT CONST FUND 294,637 2,399,300 2,893,980 494,680 17.1 FLOOD CONTROL CONST FUND 2,678 289,683 686,744 397,061 57.8 WATER AND SEWER FUND 645,841 7,396,940 9,308,159 1,911,219 20.5 VILLAGE PARKING SYSTEM FUND 19,367 124,160 227,014 102,854 45-3 PARKING SYSTEM REVENUE FUND 7,878 374,609 262,591 -112,018 -42.7 VEHICLE MAINTENANCE FUND 88,894 1,158,543 1,277,582 119,039 9.3 VEHICLE REPLACEMENT FUND 23,333 695,576 1,115,300 419,724 37.6 COMPUTER REPLACEMENT FUND 0 125,509 147,150 21,641 14.7 RISK MANAGEMENT FUND 442,237 4,834,294 5,640,293 805,999 14.3 POLICE PENSION FUND 196,656 1,963,035 2,226,120 263,085 11.8 FIRE PENSION FUND 187,855 1,971,098 2,267,030 295,932 13.1 BENEFIT TRUST #2 FUND 0 0 0 0 SSA #1 PROSPECT MEADOWS B&I 0 0 0 0 SSA #6 GEORGE/ALBERT B&I 37,748 40,495 40,495 0 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 Total All Funds 9,919,626 69,684,404 78,941,184 9,256,780 11.7 2 .12/10/2004 16:34:33 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 11/30/04 11 Months ( 1 Honth ( 91.6% ) Completed 8.3% } Remaining Totals Cur Mo Y-T-D Expended Expended 31 31 31 31 2004 Budget Unexpended Unexpended Balance Percent NON-DEPARTMENTAL PROGRAM TOTALS 00 ADMINISTRATION 0 -31 0 -31 EXPENDITURE CLASSIFICATION 80 INTERFUND TRANSFERS 31 31 0 -31 Totals 31 31 0 -31 SOURCE OF FUNDS 270 280 SERIES 1996B B&I, TIF SERIES 1998B B&I, TIF 24 7 24 7 0 -24 0 -7 0 -31 Totals 31 31 1 12/10/2004 16:34:33 FRRDBROl SUM 031 11 Months ( 1 Month ( 91.6% ) Completed 8.3% ) Remaining' VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 11/30/04 MAYOR AND BOARD OF TRUSTEES ADVISORY BOARDS & COMMISSIONS Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 4,027 88,537 92,916 4,379 4.7 1,004 13,883 14,958 1,075 7.2 5,031 102,420 107,874 5,454 5.1 PUBLIC REPRESENTATION PROGRAM TOTALS 02 03 Totals EXPENDITURE CLASSIFICATION 50 51 52 54 55 57 65 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES UTILITIES COMMODITIES & SUPPLIES OFFICE EQUIPMENT 2,803 31,415 34,370 2,955 8.6 458 5,135 5,648 513 9.1 0 379 0 -379 1,498 62,568 61,856 -712 -1. 2 0 359 500 141 28.2 272 2,564 5,500 2,936 53.4 0 0 0 0 5,031 102,420 107,874 5,454 5.1 Totals 001 SOURCE OF FUNDS GENERAL FUND 5,031 102,420 107,874 5,454 5.1 5,031 102,420 107,874 5,454 5.1 Totals 2 .12/10/2004 11 Months ( 91. 6% ) Completed 16,34:34 VILLAGE OF MOUNT PROSPECT 1 Month ( 8.3%) Remaining FRRDBROl SUMO31 Department Budget Expenditure Summary 01/01/04 11/30/04 Cur Mo Y-T-D 2004 Unexpended Unexpended VILLAGE MANAGER'S OFFICE Expended Expended Budget Balance Percent PROGRAM TOTALS 01 VILLAGE MANAGER'S OFFICE 33,054 393,102 391,807 -1,295 -0.3 02 LEGAL SERVICES 42,403 488,620 340,000 -148,620 -43.7 03 PERSONNEL SERVICES 22,235 209,304 265,353 56,049 21.1 04 INFORMATION TECHNOLOGY 63,600 592,917 692,715 99,798 14.4 05 PUBLIC INFORMATION 6,147 102,168 144,478 42,310 29.3 Totals 167,439 1,786,111 1,834,353 48,242 2.6 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 55,916 619,928 683,850 63,922 9.3 51 EMPLOYEE BENEFITS 15,030 177,551 197,321 19,770 10.0 52 OTHER EMPLOYEE COSTS 4,768 22,172 27,800 5,628 20.2 54 CONTRACTUAL SERVICES 89,986 910,623 892,752 -17,871 -2.0 55 UTILITIES 434 4,872 7,580 2,708 35.7 57 COMMODITIES & SUPPLIES 1,305 35,989 10,400 -25,589 -246.0 65 OFFICE EQUIPMENT 0 14,976 14,650 -326 -2.2 67 OTHER EQUIPMENT 0 0 0 0 Totals 167,439 1,786,111 1,834,353 48,242 2.6 SOURCE OF FUNDS 001 GENERAL FUND 167,439 1,786,111 1,834,353 48,242 2.6 Totals 167,439 1,786,111 1,834,353 48,242 2.6 3 12/10/2004 16:34:34 FRRDBROl SUM 031 11 Months ( 1 Month ( 91.6% ) Completed 8.3% ) Remaining - VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 11/30/04 02 03 CABLE TV OPERATIONS OTHER SERVICES INTERGOVERNMENTAL PROGRAMMING Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 8,157 111,764 126,336 14,572 11.5 0 0 0 0 2,657 35,575 43,926 8,351 19.0 10,814 147,339 170,262 22,923 13.5 TV SERVICES DIVISION PROGRAM TOTALS 04 Totals EXPENDITURE CLASSIFICATION 50 51 52 54 55 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES UTILITIES COMMODITIES & SUPPLIES OTHER EQUIPMENT 6,418 80,218 90,770 10,552 11.6 2,743 31,529 34,920 3,391 9.7 100 635 1,850 1,215 65.7 1,158 17,634 24,397 6,763 27.7 0 1,137 1,350 213 15.8 395 6,366 7,225 859 11. 9 0 9,820 9,750 -70 -0.7 10,814 147,339 170,262 22,923 13.5 57 67 Totals SOURCE OF FUNDS 001 GENERAL FUND 10,814 147,339 170,262 22,923 13.5 170,262 22,923 13.5 Totals 10,814 147,339 4 }2/10/2004 16:34:34 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 11/30/04 11 Months ( 1 Month ( 91.6% ) Completed 8.3% ) Remaining Totals Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 10,530 146,123 163,256 17,133 10.5 10,530 146,123 163,256 17,133 10.5 VILLAGE CLERK'S OFFICE PROGRAM TOTALS 02 VILLAGE CLERK'S OFFICE EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES Totals 6,800 80,926 90,790 9,864 10.9 2,836 32,137 35,726 3,589 10.0 30 1,625 1,700 75 4.4 590 23,705 29,040 5,335 18.4 1 1,219 1,600 381 23.8 273 6,511 4,400 -2,111 -48.0 10,530 146,123 ~63,256 17,133 10.5 SOURCE OF FUNDS 001 GENERAL FUND 10,530 146,123 163,256 17,133 10.5 Totals 10,530 146,123 163,256 17,133 10.5 5 12/10/2004 11 Months ( 91.6% ) Completed 16:34:34 1 Month 8.3% ) Remaining '. FRRDBROI VILLAGE OF MOUNT PROSPECT SUM 031 Department Budget Expenditure Summary 01/01/04 - 11/30/04 Cur Mo Y-T-D 2004 Unexpended Unexpended FINANCE DEPARTMENT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 FINANCE ADMINISTRATION 16,636 175,261 202,133 26,872 13.3 02 ACCOUNTING 31,358 362,830 387,505 24,675 6.4 03 DATA PROCESSING 0 0 0 0 04 DUPLICATING SERVICES 319 10,332 12,665 2,333 18.4 05 INSURANCE PROGRAMS 30,001 333,871 364,465 30,594 8.4 06 CUSTOMER SERVICES 31,162 318,311 357,712 39,401 11. 0 07 CASH MANAGEMENT 2,363 27,368 43,851 16,483 37.6 Totals 111,839 1,227,973 1,368,331 140,358 10.3 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 52,768 631,988 703,910 71,922 10.2 51 EMPLOYEE BENEFITS 19,580 224,675 248,252 23,577 9.5 52 OTHER EMPLOYEE COSTS 604 5,077 4,650 -427 -9.2 54 CONTRACTUAL SERVICES 6,832 62,743 76,240 13,497 17.7 55 UTILITIES 5 4,485 6,700 2,215 33.1 56 INSURANCE 25,207 277,272 302,479 25,207 8.3 57 COMMODITIES & SUPPLIES 6,843 20,141 23,900 3,759 15.7 65 OFFICE EQUIPMENT 0 1,592 2,200 608 27.6 Totals 111,839 1,227,973 1,368,331 140,358 10.3 SOURCE OF FUNDS 001 GENERAL FUND 111,839 1,227,973 1,368,331 140,358 10.3 Totals 111,839 1,227,973 1,368,331 140,358 10.3 6 ." .12/10/2004 16:34:34 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 11/30/04 11 Months ( 1 Month ( 91.6% ) Completed 8.3% ) Remaining Cur Mo Y-T-D 2004 Unexpended Unexpended COMMUNITY DEVELOPMENT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 COMMUNITY DEVELOPMENT ADMIN 10,179 168,801 189,713 20,912 11.0 02 PLANNING & ZONING 10,702 140,669 160,244 19,575 12.2 03 ECONOMIC DEVELOPMENT 2,988 62,313 94,879 32,566 34.3 05 BUILDING INSPECTIONS 51,331 602,961 71 7,261 114,300 15.9 06 HOUSING INSPECTIONS 22,762 260,690 306,296 45,606 14.9 07 HEALTH INSPECTIONS 8,534 98,378 112,134 13,756 12.3 Totals 106,496 1,333,812 1,580,527 246,715 15.6 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT Totals 67,644 877,758 1,016,985 139,227 13.7 27,698 329,157 369,823 40,666 11.0 447 9,292 13,166 3,874 29.4 8,015 93,364 138,501 45,137 32.6 2,074 14,962 24,904 9,942 39.9 618 9,279 17,148 7,869 4S. 9 0 0 0 0 106,496 1,333,812 1,580,527 246,715 15.6 SOURCE OF FUNDS 001 GENERAL FUND 550 DOWNTOWN REDEVLPMNT CONST Totals 106,496 0 1,333,812 0 1,580,046 481 246,234 481 15.6 100.0 106,496 1,333,812 1,580,527 246,715 15.6 7 12/10/2004 16034:34 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 11/30/04 11 Months ( 1 Month ( 91.6% ) Completed 8.3% ) Remaining' Cur Mo Y-T-D 2004 Unexpended Unexpended COMMUNITY DEVELOPMENT - CDBG Expended Expended Budget Balance Percent PROGRAM TOTALS 04 CDBG ADMINISTRATION 4,596 56,045 67,714 11,669 17.2 05 CDBG COMMUNITY PROGRAMS 6,232 88,478 136,500 48,022 35.2 06 ACCESSIBLTY & NEIGHBRHD IMPRV 0 115,404 140,000 24,596 17.6 07 CDBG RESIDENTIAL REHAB 1,301 187,960 276,091 88,131 31.9 Totals 12,129 447,887 620,305 172,418 27.8 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 Totals 3,201 38,023 45,400 7,377 16.2 1,390 15,680 17,429 1,74~ 10.0 0 590 1,075 485 45.1 6,237 89,827 138,915 49,088 35.3 0 403 1,395 992 71.1 1,301 187,960 276,091 88,131 31. 9 0 50,804 75,000 24,196 32.3 0 64,600 65,000 400 0.6 12,129 447,887 620,305 172,418 27.8 SOURCE OF FUNDS 070 COMMUNITY DEVELPMNT BLOCK GRNT 12,129 447,887 620,305 172,418 27.8 Totals 12,129 447,887 620,305 172,418 27.8 8 .12/10/2004 16:34:34 FRRDBROI SUM 031 11 Months ( 1 Month ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 11/30/04 HUMAN SERVICES Cur Mo Expended PROGRAM TOTALS 01 02 03 04 05 HUMAN SERVICES ADMINISTRATION SOCIAL SERVICES NURSING/HEALTH SERVICES SENIOR CTR. LEISURE ACTIVITIES YOUTH ACTIVITIES 10,660 22,938 13,813 1,957 1,912 Totals 51,280 EXPENDITURE CLASSIFICATION 50 51 52 54 55 57 65 67 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES UTILITIES COMMODITIES & SUPPLIES OFFICE EQUIPMENT OTHER EQUIPMENT 34,143 11,203 172 2,418 41 3,303 0 0 Totals 51,280 SOURCE OF FUNDS 001 GENERAL FUND 51,280 Totals 51,280 9 Y-T-D Expended 174,507 255,407 132,567 38,263 18,478 619,222 391,816 126,966 2,116 77,411 11,762 9,151 0 0 619,222 619,222 619,222 2004 Budget 214,418 283,879 179,757 44,164 62,649 784,867 477,790 147,120 3,900 107,302 9,180 38,075 1,500 0 784,867 784,867 784,867 91.6% ) Completed 8.3% ) Remaining Unexpended Unexpended Balance Percent 39,911 28,472 47,190 5,901 44,171 165,645 85,974 20,154 1,784 29,891 -2,582 28,924 1,500 0 165,645 165,645 165,645 18.6 10.0 26.3 13.4 70.5 21.1 18.0 13.7 45.7 27.9 -28.1 76.0 100.0 21.1 21.1 21.1 12/10/2004 1.1 Montns \ "l.b'!; I l:Ompletea 16,34:34 VILLAGE OF MOUNT PROSPECT 1 Month ( 8.3%) Remaining FRRDBROl SUM 031 Department Budget Expenditure Sununary 01/01/04 - 11/30/04 Cur Mo Y-T-D 2004 Unexpended Unexpended POLICE Expended Expended Budget Balance Percent PROGRAM TOTALS 01 POLICE ADMINISTRATION 294,612 1,928,601 2,331,095 402,494 17.3 02 PATROL & TRAFFIC ENFORCEMENT 478,167 6,371,526 6,923,190 551,664 8.0 03 CRIME PREVTN & PUBLIC SERVICES 19,084 207,697 227,489 19,792 8.7 04 INVESTIGATIVE & JUVENILE PRGM 86,633 946,417 1,173,577 227,160 19.4 05 CROSSING GUARDS 2,397 21,555 26,750 5,195 19.4 06 EQUIPMENT MAINTENANCE 51,980 555,172 638,811 83,639 13.1 Totals 932,873 10,030,968 11,320,912 1,289,944 11.4 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 534,086 6,623,510 7,301,240 677,730 9.3 51 EMPLOYEE BENEFITS 329,191 2,041,334 2,521,297 479,963 19.0 52 OTHER EMPLOYEE COSTS 4,028 77,594 79,450 1,856 2.3 54 CONTRACTUAL SERVICES 55,890 1,134,924 1,243,496 108,572 8.7 55 UTILITIES 1,155 32,267 52,000 19,733 37.9 57 COMMODITIES & SUPPLIES 9,915 71,997 74,005 2,008 2.7 59 OTHER EXPENDITURES 0 0 0 0 65 OFFICE EQUIPMENT -1,392 12,279 13,674 1,395 10.2 67 OTHER EQUIPMENT 0 37,063 35,750 -1,313 -3.7 Totals 932,873 10,030,968 11,320,912 1,289,944 11.4 SOURCE OF FUNDS 001 GENERAL FUND 934,265 9,991,048 11,293,688 1,302,640 11.5 060 LAW ENFORCEMENT BLOCK GRANT -1,392 11,123 12,524 1,401 11.2 080 ASSET SEIZURE FUND 0 0 7,000 7,000 100.0 085 DEA SHARED FUNDS FUND 0 18,653 4,700 -13,953 -296.9 086 DUI FINE FUND 0 10,144 3,000 -7,144 -238.1 Totals 932,873 10,030,968 11,320,912 J.,289,944 11.4 10 ,12/10/2004 11 Months ( 91.6% ) Completed 16:34:34 VILLAGE OF MOUNT PROSPECT 1 Month ( 8.3%) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/04 11/30/04 Cur Mo Y-T-D 2004 Unexpended Unexpended FIRE Expended Expended Budget Balance Percent PROGRAM TOTALS 01 FIRE ADMINISTRATION 288,409 1,441,150 1,933,565 492,415 25.5 02 FIRE DEPARTMENT OPERATIONS 465,538 5,330,031 5,932,540 602,509 10.2 03 FIRE TRAINING ACADEMY 2,654 12,325 13,140 815 6.2 04 FIRE PREVENTION 27,144 352,849 414,400 61,551 14.9 05 FIRE COMMUNICATIONS 3,790 48,104 60,100 11,996 20.0 06 EQUIPMENT MAINTENANCE 38,252 406,769 433,470 26,701 6.2 07 EMERGENCY PREPARDENESS PRGM 4,898 9,939 10,500 561 5.3 08 PAID-ON-CALL PROGRAM 2,039 17,167 31,685 14,518 45.8 Totals 832,724 7,618,334 8,829,400 1,211,066 13.7 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 455,796 5,242,578 5,913,390 670,812 11.3 51 EMPLOYEE BENEFITS 302,336 1,745,318 2,198,047 452,729 20.6 52 OTHER EMPLOYEE COSTS 24,104 60,060 95,915 35,855 37.4 54 CONTRACTUAL SERVICES 37,433 391,894 424,618 32,724 7.7 55 UTILITIES 1,923 35,219 42,750 7,531 17.6 57 COMMODITIES & SUPPLIES 9,924 76,425 81,010 4,585 5.7 64 BUILDING IMPROVEMENTS 0 5,647 5,000 -647 -12.9 65 OFFICE EQUIPMENT 522 876 5,000 4,124 82.5 67 OTHER EQUIPMENT 686 60,317 63,670 3,353 5.3 Totals 832,724 7,618,334 8,829,400 ~,211,066 13.7 SOURCE OF FUNDS 001 GENERAL FUND 832,724 7,618,334 8,829,400 1,211,066 13.7 Totals 832,724 7,618,334 8,829,400 ~,21~,066 13.7 11 12/10/2004 16:34:34 FRRDBROI SUM 031 .Ll. l"Jon'Cns \ ~~.b~ ) Lomp~e'Cea 8.3% ) Remaining 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 11/30/04 - ADMINISTRATION Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Bal ance Percent 79,234 900,249 1,001,751 101,502 10.1 79,234 900,249 1,001,751 101,502 10.1 PROGRAM TOTALS PUBLIC WORKS 01 PUBLIC WORKS ADMINSTRATION Totals EXPENDITURE CLASSIFICATION 50 51 52 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES UTILITIES COMMODITIES & SUPPLIES OFFICE EQUIPMENT OTHER EQUIPMENT 17,760 200,432 21 7,705 17,273 7.9 8,344 97,896 107,427 9,531 8.9 1,193 15,958 23,700 7,742 32.7 51,109 565,673 626,004 60,331 9.6 587 12,740 17,955 5,215 29.0 241 6,837 7,400 563 7.6 0 153 1,000 847 84.7 0 560 560 0 79,234 900,249 1,001,751 101,502 10.1 54 55 57 65 67 Totals SOURCE OF FUNDS 001 GENERAL FUND 79,234 900,249 1,001,751 101,502 10.1 101,502 10.1 79,234 900,249 1,001,751 Totals 12 12/10/2004 16,34:34 FRRDBROl SUM 031 11 Months ( 1 Month ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 11/30/04 PUBLIC WORKS - STREETS/BLDGS Cur Me Expended PROGRAM TOTALS 01 02 04 STREET DIVISION ADMINISTRATION MAINTENANCE - PUBLIC BUILDINGS STREET MAINTENANCE SNOW REMOVAL LEAF REMOVAL STORM SEWER & BASIN MAINT MAINTENANCE OF STATE HIGHWAYS TRAFFIC SIGN MAINTENANCE VILLAGE PARKING LOT MAINT PARKING LOT MAINTENANCE FLOOD CONTROL 8,252 65,288 20,856 8,407 0 11,433 2,877 9,721 19,367 7,878 0 05 06 07 08 09 10 11 12 Totals 154,079 EXPENDITURE CLASSIFICATION 50 51 70,820 21,945 34,750 551 1,063 8,882 0 886 PERSONAL SERVICES EMPLOYEE BENEFITS CONTRACTUAL SERVICES UTILITIES INSURANCE COMMODITIES & SUPPLIES OTHER EXPENDITURES BUILDING IMPROVEMENTS OTHER EQUIPMENT INFRASTRUCTURE INTERFUND TRANSFERS 54 55 56 57 59 64 67 69 0 15,182 0 80 Totals 154,079 SOURCE OF FUNDS 001 050 620 630 GENERAL FUND MOTOR FUEL TAX FUND VILLAGE PARKING SYSTEM FUND PARKING SYSTEM REVENUE FUND 126,834 0 19,367 7,878 Totals 154,079 13 Y-T-D Expended 118,027 684,811 379,142 336,357 1 147,135 57,765 106,958 124,160 374,609 177,991 2,506,956 1,067,089 289,344 506,511 28,122 11,693 240,824 0 3,922 0 113,821 245,630 2,506,956 1,828,574 179,613 124,160 374,609 2,506,956 2004 Budget 91.6% ) Completed 8.3% ) Remaining Unexpended Unexpended Balance Percent 154,747 712,005 426,170 353,609 0 158,969 64,700 105,417 227,014 133,136 0 2,335,767 992,640 289,642 528,204 18,650 12,756 253,875 0 5,000 0 235,000 0 2,335,767 1,771,822 203,795 227,014 133,136 2,335,767 36,720 27,194 47,028 17,252 -1 11,834 6,935 -1,541 102,854 -241,473 -177,991 -171,189 -74,449 298 21,693 -9,472 1,063 13,051 0 1,078 0 121,179 -245,630 -171,189 -56,752 24,182 102,854 -241,473 -171,189 23.7 3.8 11.0 4.9 7.4 10.7 -1. 5 45.3 -181.4 -7.3 -7.5 0.1 4.1 -50.8 8.3 5.1 21. 6 51. 6 -7.3 -3.2 11.9 45.3 -181.4 -7.3 FRRDBROI SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 11/30/04 1 Month ".t.o" I I...ump.t",:..,=,u 8.3% ) Remaining 12/10/2004 16:34:34 .L.L ~loncns \ Cur Mo Y-T-D 2004 Unexpended Unexpended PUBLIC WORKS - FORESTRY/GRNDS Expended Expended Budget Balance Percent PROGRAM TOTALS 01 FORESTRY DIVISION ADMIN 14,177 176,073 195,375 19,302 9.9 02 MAINTENANCE OF GROUND 38,448 373,518 395,583 22,065 5.6 03 FORESTRY PROGRAM 83,624 576,065 640,665 64,600 10.1 04 PUBLIC GROUNDS BEAUTIFICATION 2,169 35,571 41,615 6,044 14.5 Totals 138,418 1,161,227 1,273,238 112,011 8.8 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT Totals 45,257 600,781 631,475 30,694 4.9 15,161 180,784 193,228 12,444 6.4 0 750 750 0 72,811 352,073 413,105 61,032 14.8 1,179 22,829 28,910 6,081 21. 0 4,010 4,010 5,770 1,760 30.5 138,418 1,161,227 1,273,238 112,011 8.8 SOURCE OF FUNDS 001 690 GENERAL FUND RISK MANAGEMENT FUND 138,418 0 1,161,227 0 1,263,238 10,000 102,011 10,000 8.1 100.0 Totals 138,418 1,161,227 1,273,238 112,011 8.8 14 .12/10/2004 16:34:34 FRRDBROl SUM031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 11/30/04 11 Months ( 1 Month ( 91.6% ) Completed 8.3% ) Remaining Cur Mo Y-T-D 2004 Unexpended Unexpended PUBLIC WORKS - ENGINEERING Expended Expended Budget Balance Percent PROGRAM TOTALS 01 ENGINEERING SERVICES 53,192 588,624 670,588 81,964 12.2 05 TRAFFIC CNTRL & STREET LGHTNG 35,466 270,226 569,563 299,337 52.6 Totals 88,658 858,850 1,240,151 381,301 30.7 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 42,412 476,147 540,740 64,593 11.9 51 EMPLOYEE BENEFITS 13,225 147,298 162,834 15,536 9.5 52 OTHER EMPLOYEE COSTS 225 3,575 3,450 -125 -3.6 54 CONTRACTUAL SERVICES 10,055 79,227 162,007 82,780 51.1 55 UTILITIES 21,044 126,548 188,575 62,027 32.9 57 COMMODITIES & SUPPLIES 1,232 23,754 25,095 1,341 5.3 65 OFFICE EQUIPMENT 0 0 500 500 100.0 67 OTHER EQUIPMENT 465 465 1,500 1,035 69.0 69 INFRASTRUCTURE 0 1,836 155,450 153,614 98.8 Totals 88,658 858,850 1,240,151 381,301 30.7 SOURCE OF FUNDS 001 GENERAL FUND 61,368 751,821 883,976 132,155 15.0 050 MOTOR FUEL TAX FUND 27,290 107,029 356,175 249,146 70.0 Totals 88,658 858,850 1,240,151 381,301 30.7 15 12/10/2004 16:34:34 FRRDBROl SUM 031 11 Mont!lS \ 1 Month ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 11/30/04 PROGRAM TOTALS PUBLIC WORKS - WATER/SEWER Cur Mo Expended 01 02 03 WATER & SEWER DIVISION ADMIN MAINTENANCE OF BUILDINGS MAINTENANCE OF GROUNDS WATER SUPPLY MAINT & REPAIR WATER DISTRBT MAINT & REPAIR WATER VALVE/HYDRNT MAINT & REP WATER METER MAINT & REPL EQUIPMENT MAINTENANCE SANITARY SEWER MAINT & REPAIR WATER & SEWER SYSTEM IMPROV LAKE MICHIGAN WATER SUPPLY 190,769 13,609 5,114 37,339 35,736 19,775 17,789 44,172 19,107 8,123 254,308 04 05 06 07 08 09 10 12 Totals 645,841 EXPENDITURE CLASSIFICATION 50 51 52 54 55 56 57 59 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES UTILITIES INSURANCE COMMODITIES & SUPPLIES OTHER EXPENDITURES OFFICE EQUIPMENT OTHER EQUIPMENT DISTRIBUTION SYSTEMS BOND PRINCIPAL 106,848 40,041 1,108 360,754 8,775 14,701 3,782 2,457 0 1,975 4,400 101,000 65 67 68 71 Totals 645,841 SOURCE OF FUNDS 610 WATER AND SEWER FUND 645,841 Totals 645,841 16 Y-T-D Expended 1,202,278 141,920 69,578 431,356 467,301 277,105 266,284 485,894 296,081 877.086 2,882,057 7,396,940 1,409,426 482,254 12,404 4,276,452 91,163 161,705 147,112 4,914 4,494 69,842 636,174 101,000 7,396,940 7,396.940 7,396,940 2004 Budget 1,482,835 170,295 82,664 478,131 846,358 285,706 308,474 530,066 364,271 1,689,359 3,070,000 9,308,159 1,602,190 528,341 26,270 4,790,629 155,123 165,801 166,148 15,172 6,200 363,653 1,387,632 101,000 9,308,159 9,308,159 9,308,159 ~1.b~ ) completea 8.3% ) Remaining Unexpended Unexpended Balance Percent 280,557 28,375 13,086 46,775 379,057 8,601 42,190 44,172 68,190 812,273 187,943 1.,911,219 192,764 46,087 13,866 514,177 63,960 4,096 19,036 10,258 1,706 293,811 751,458 0 1.,911,219 1.,911,219 1.,911,219 18.9 16.7 15.8 9.8 44.8 3.0 13.7 8.3 18.7 48.1 6.1 20.5 12.0 8.7 52.8 10.7 41.2 2.5 11. 5 67.6 27.5 80.8 54.2 20.5 20.5 20.5 .12/10/2004 16:34:34 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 11/30/04 11 Months ( 1 Month ( 91.6% ) Completed 8.3% ) Remaining Cur Mo Y-T-D 2004 Unexpended Unexpended PUBLIC WORKS - REFUSE DISPOSAL Expended Expended Budget Balance Percent PROGRAM TOTALS 01 REFUSE DISPOSAL PROGRAM 269,849 2,949,855 3,362,241 412,386 12.3 02 REFUSE LEAF REMOVAL PROGRAM 52,753 181,858 170,981 -10,877 -6.4 Totals 322,602 3,131,713 3,533,222 401,509 11.4 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES Totals 45,754 210,447 202,005 -8,442 -4.2 8,751 58,775 60,718 1,943 3.2 0 175 750 575 76.7 261,618 2,836,597 3,236,561 399,964 12.4 1 293 545 252 46.2 396 4,352 4,298 -54 -1. 3 6,082 21,074 28,345 7,271 25.7 322,602 3,131,713 3,533,222 401,509 11.4 SOURCE OF FUNDS 030 REFUSE DISPOSAL FUND 322,602 3,131,713 3,533,222 401,509 11.4 Totals 322,602 3,131,713 3,533,222 401,509 11.4 17 12/10/2004 .L.L Montns t ;tJ..b'tS I LOmpJ.etea 16:34:34 VILLAGE OF MOUNT PROSPECT 1 Month 8.3% ) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/04 11/30/04 Cur Mo Y-T-D 2004 Unexpended Unexpended PUBLIC WORKS - VEHICLE MAINT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 VEHICLE DIVISION ADMINSTRATION 10,954 135,321 178,656 43,335 24.3 02 VEHICLE MAINTENANCE PROGRAM 77,940 1,023,222 1,098,926 75,704 6.9 Totals 88,894 1,158,543 1,277,582 119,039 9.3 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 40,054 569,401 628,415 59,014 9.4 51 EMPLOYEE BENEFITS 14,532 179,777 196,550 16,773 8.5 52 OTHER EMPLOYEE COSTS 0 200 2,000 1,800 90.0 54 CONTRACTUAL SERVICES 3,887 57,136 71,026 13,890 19.6 55 UTILITIES 1 760 1,000 240 24.0 57 COMMODITIES & SUPPLIES 30,420 286,735 310,741 24,006 7.7 59 OTHER EXPENDITURES 0 0 0 0 65 OFFICE EQUIPMENT 0 0 500 500 100.0 67 OTHER EQUIPMENT 0 64,534 67,350 2,816 4.2 Totals 88,894 1,158,543 1,277,582 119,039 9.3 SOURCE OF FUNDS 660 VEHICLE MAINTENANCE FUND 88,894 1,158,543 1,277,582 119,039 9.3 Totals 88,894 1,158,543 1,277,582 119,039 9.3 18 .12/10/2004 16:34:34 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 11/30/04 11 Months ( 1 Month ( 91.6% ) Completed 8.3% ) Remaining Cur Mo Y-T-D 2004 Unexpended Unexpended COMMUNITY SERVICE PROGRAMS Expended Expended Budget Balance Percent PROGRAM TOTALS 02 COMMUNITY GROUPS & MISC 14,427 79,871 88,900 9,029 10.2 03 4TH OF JULY & CIVIC EVENTS,ETC 332 98,777 117,975 19,198 16.3 04 HOLIDAY DECORATIONS 31,510 55,211 69,227 14,016 20.2 05 BLOOD DONOR PROGRAM 395 2,384 2,800 416 14.9 Totals 46,664 236,243 278,902 42,659 15.3 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES Totals 1,897 60,097 55,390 -4,707 -8.5 366 6,802 9,367 2,565 27.4 36,870 150,935 184,245 33,310 18.1 0 0 400 400 100.0 2,121 12,999 22,500 9,501 42.2 5,410 5,410 7,000 1,590 22.7 46,664 236,243 278,902 42,659 15.3 SOURCE OF FUNDS 001 GENERAL FUND 46,664 236,243 278,902 42,659 15.3 Totals 46,664 236,243 278,902 42,659 15.3 19 12/10/2004 16:34:34 FRRDBROI SUM 031 11 Months \ 1 Month ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 11/30/04 CAPITAL IMPROVEMENT PROJECTS Cur Mo Expended PROGRAM TOTALS 01 02 03 04 06 09 10 VILLAGE IMPROVEMENTS & EQUIP COMMUNITY IMPROVEMENT PROJECTS DOWNTOWN REDEVELOPMENT CONST FLOOD CONTROL PROJECTS STREET IMPROVEMENT PROJECTS MOTOR EQUIPMENT REPLACEMENT COMPUTER REPLACEMENT -689,167 6,160 708,284 2,678 474,011 23,333 0 Totals 525,299 EXPENDITURE CLASSIFICATION 54 55 59 62 64 65 66 67 CONTRACTUAL SERVICES UTILITIES OTHER EXPENDITURES 1,400 0 705,000 6,160 -751,324 411,292 23,333 10,175 478,573 -359,310 69 80 LAND IMPROVEMENTS BUILDING IMPROVEMENTS OFFICE EQUIPMENT MOBILE EQUIPMENT OTHER EQUIPMENT INFRASTRUCTURE INTERFUND TRANSFERS Totals 525,299 SOURCE OF FUNDS 050 060 510 520 525 526 527 530 550 MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT CAPITAL IMPROVEMENT FUND 184,733 o 32,889 0 0 -715,896 0 0 708,284 289,278 2,678 0 23,333 0 560 590 630 POLICE & FIRE BLDG CONST FUND SERIES 2001 PROJECT FUND SERIES 2003 PROJECT FUND 2002 LIBRARY PROJECT FUND CAPITAL IMPROVEMENT CONST FUND DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CaNST FUND FLOOD CONTROL CONST FUND PARKING SYSTEM REVENUE FUND VEHICLE REPLACEMENT FUND COMPUTER REPLACEMENT FUND RISK MANAGEMENT FUND 670 680 690 Totals 525.299 20 Y-T-D Expended 6,367,411 173,399 2,326,879 289,683 3,076,925 695,576 125,509 13,055,382 236,178 0 856,853 33,550 5,753,442 955,424 695,576 45,870 4,837,799 -359,310 13,055,382 1,496,513 0 390,181 0 0 6,150,629 0 0 0 2,032,897 1,874,394 289,683 0 695,576 125,509 0 13,055,382 2004 Budget ~l.b~ ) compleçea 8.3% ) Remaining Unexpended Unexpended Balance Percent 6,622,331 251,635 2,150,189 686,744 3,831,385 1,115,300 147,150 14,804,734 418,125 0 455,742 27,390 5,994,855 573,234 1,115,300 1,392 6,218,696 0 14,804,734 1,901,823 0 912,111 0 100,000 5,786,400 0 0 1,824,501 2,201,250 686,744 129,455 1,115,300 147,150 0 14,804,734 254,920 78,236 -176,690 397,061 754,460 419,724 21,641 1,749,352 181,947 0 -401,111 -6,160 241,413 -382,190 419,724 -44,478 1.,380,897 359,310 1,749,352 405,310 0 521,930 0 100,000 -364,229 0 0 -208,396 326,856 397,061 129,455 419,724 21,641 0 1,749,352 3.8 31.1 -8.2 57.8 19.7 37.6 14.7 11.8 43.5 -88.0 -22.5 4.0 -66.7 37.6 **** * 22.2 11.8 21. 3 57.2 100.0 -6.3 -11.4 14.8 57.8 100.0 37.6 14.7 11.8 12/10/2004 11 Months ( 91. 6% ) Completed 16:34:34 VILLAGE OF MOUNT PROSPECT 1 Month ( 8.3%) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/04 - 11/30/04 Cur Mo Y-T-D 2004 Unexpended Unexpended DEBT SERVICE Expended Expended Budget Balance Percent PROGRAM TOTALS 02 DEBT SERVICE - PROPERTY TAXES 1,594,483 2,019,665 2,019,966 301 03 DEBT SERVICE - TAX INCREMENT 186,038 910,875 912,075 1,200 0.1 04 DEBT SERVICE - H/R SALES TAX 1 969,535 1,379,863 1,499,168 119,305 8.0 05 DEBT SERVICE - H/R SALES TAX 2 1,470,049 1,495,249 1,496,000 751 0.1 06 SPECIAL SERVICE AREA B & I 37,748 40,495 40,495 0 Totals 4,257,853 5,846,147 5,967,704 121,557 2.0 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 0 0 0 0 59 OTHER EXPENDITURES 0 0 0 0 71 BOND PRINCIPAL 3,721,409 4,423,373 4,507,069 83,696 1.9 72 INTEREST EXPENSE 535,544 1,418,124 1,452,835 34,711 2.4 73 BANK AND FISCAL FEES 900 4,650 7,800 3,150 40.4 80 INTERFUND TRANSFERS 0 0 0 0 81 OTHER FINANCING USES 0 0 0 0 Totals 4,257,853 5,846,147 5,967,704 121,557 2.0 SOURCE OF FUNDS 140 SERIES 1987A B&I, PW FACILITY 0 66,000 66,000 0 170 SERIES 1993B B&I, PUBLIC BLDGS 0 0 0 0 180 SERIES 2001 B&I, VILLAGE HALL 283,889 387,778 387,778 0 190 SERIES 2003 B&I, VILLAGE HALL 677,816 916,231 916,232 1 200 SERIES 2002B B&I, PUBLIC BLDGS 632,778 649,656 649,956 300 230 SERIES 2002A B&I, TIF 51,450 52,900 53,800 900 1.7 240 SERIES 1992B B&I, TIF 0 0 0 0 250 SERIES 1993A B&I, TIF 0 0 0 0 260 SERIES 1994B B&I, TIF 0 0 0 0 270 SERIES 1996B B&I, TIF 0 0 0 0 280 SERIES 1998B B&I, TIF 0 0 0 0 290 SERIES 1999 BU, TIF 0 708,500 708,500 0 300 SERIES 1991A B&I, FLOOD 0 0 0 0 310 SERIES 1992A B&I, FLOOD 0 0 0 0 320 SERIES 1993B B&I, FLOOD 0 0 0 0 330 SERIES 1994A B&I, FLOOD 0 0 0 0 340 SERIES 1996A B&I, FLOOD 202,590 215,630 216,080 450 0.2 350 SERIES 1998A B&I, FLOOD 59,976 65,102 65,252 150 0.2 360 SERIES 1998C B&I, TIF 134,588 149,475 149,775 300 0.2 380 IEPA FLOOD CONTROL LOANS B&I 168,629 494,952 613,357 118,405 19.3 390 SERIES 2000 B&I, FLOOD CONTROL 55,749 112,098 112,098 0 400 SERIES 2002B B&I, FLOOD 482,591 492,081 492,381 300 0.1 410 SERIES 1994A B&I, STREET IMP. 0 0 0 0 420 SERIES 1996A B&I, STREET IMP. 0 0 0 0 430 SERIES 1998A B&I, STREET IMP. 877,737 895,624 895,775 151 440 SERIES 2002B B&I, STREET IMP. 592,312 599,625 600,225 600 0.1 810 SSA #1 PROSPECT MEADOWS B&I 0 0 0 o 830 SSA #6 GEORGE/ALBERT B&I 37,748 40,495 40,495 0 Totals 4,257,853 5,846,147 5,967,704 121,557 2.0 21 12/10/2004 16:34:34 FRRDBROl SUM031 11 Months ( 1 Month ( 91.6% ) Completed 8.3% ) Remaining VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 11/30/04 RETIREE PENSIONS Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 4,481 49,291 53,714 4,423 8.2 196,656 1,963,035 2,226,120 263,085 11.8 187,855 1,971,098 2,267,030 295,932 13.1 388,992 3,983,424 4,546,864 563,440 12.4 PROGRAM TOTALS 01 02 03 MISCELLANEOUS PENSIONS POLICE PENSIONS FIRE PENSIONS Totals EXPENDITURE CLASSIFICATION 53 54 57 65 PENSION BENEFITS CONTRACTUAL SERVICES COMMODITIES & SUPPLIES OFFICE EQUIPMENT Totals SOURCE OF FUNDS 001 710 720 730 GENERAL FUND POLICE PENSION FUND FIRE PENSION FUND BENEFIT TRUST #2 FUND Totals 388,992 3,982,333 4,544,714 562,381 12.4 0 1,091 1,950 859 44.1 0 0 200 200 100.0 0 0 0 0 388,992 3,983,424 4,546,864 563,440 12.4 4,481 49,291 53,714 4,423 8.2 196,656 1,963,035 2,226,120 263,085 11.8 187,855 1,971,098 2,267,030 295,932 13.1 0 0 0 0 388,992 3,983,424 4,546,864 563,440 12.4 22 12/10/2004 ., 16:34,34 FRRDBROI SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 11/30/04 11 Months ( 1 Month ( 91.6% ) Completed 8.3% ) Remaining Totals Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 104,677 1,210,492 1,069,013 -141,479 -13.2 337,560 3,623,802 4,561,280 937,478 20.6 442,237 4,834,294 5,630,293 795,999 14.1 RISK MANAGEMENT PROGRAM TOTALS 01 02 CASUALTY & PROPERTY INSURANCE MEDICAL INSURANCE EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 56 INSURANCE 0 442,237 11,043 4,823,251 36,000 5,594,293 24,957 771,042 69.3 13.8 Totals 442,237 4,834,294 5,630,293 795,999 14 .1 SOURCE OF FUNDS 690 RISK MANAGEMENT FUND 442,237 4,834,294 5,630,293 795,999 14.1 Totals 442,237 4,834,294 5,630,293 795,999 14 .1 23 12/10/2004 16:34:34 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 11/30/04 11 Months ( 1 Month ( 91.6% ) Completed 8.3% ) Remaining' Totals Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 499,669 1.154,216 962,730 -191,486 -19.9 499,669 1,154,216 962,730 -191,486 -19.9 NON-DEPARTMENTAL PROGRAM TOTALS 01 CONTINGENCIES EXPENDITURE CLASSIFICATION Totals 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 499,669 1,154,216 962,730 -191,486 -19.9 499,669 1,154,216 962,730 -191,486 -19.9 54 59 PERSONAL SERVICES PENSION BENEFITS CONTRACTUAL SERVICES OTHER EXPENDITURES INTERFUND TRANSFERS 50 53 80 SOURCE OF FUNDS 001 GENERAL FUND 560 STREET IMPROVEMENT CONST FUND 670 VEHICLE REPLACEMENT FUND Totals 494,310 629,310 270,000 -359,310 -133.1 5,359 524,906 692,730 167,824 24.2 0 0 0 0 499,669 1,154,216 962,730 -191,486 -19.9 24 .12/10/2004 16:34:34 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 11/30/04 11 Months ( 1 Month ( 91.6% ) Completed 8.3% ) Remaining CAPITAL FIXED ASSETS Cur Mo Expended Y-T-D Expended 2004 Budget Unexpended Unexp~nded Balance Percent PROGRAM TOTALS 00 CAPITAL FIXED ASSETS 0 0 0 0 Totals 0 0 0 0 EXPENDITURE CLASSIFICATION 59 OTHER EXPENDITURES 0 0 0 0 Totals 0 0 0 0 SOURCE OF FUNDS 910 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 Totals 0 0 0 0 25 12/10/2004 16:34:34 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 11/30/04 11 Months ( 1 Month ( 91.6~ ) Completed 8.3% ) Remaining' MOUNT PROSPECT LIBRARY Cur Mo Expended Y-T-D Expended 2004 Unexpended Unexpended Budget Balance Percent 0 23,641,875 23,641,875 100.0 0 23,641,875 23,641,875 100.0 PROGRAM TOTALS 02 LIBRARY SERVICES 0 Totals 0 EXPENDITURE CLASSIFICATION 90 COMPONENT UNIT EXPENDITURES 0 0 23,641,875 23,641,875 100.0 Totals 0 0 23,641,875 23,641,875 100.0 SOURCE OF FUNDS 950 MOUNT PROSPECT LIBRARY FUND 0 0 23,641,875 23,641,875 100.0 Totals 0 0 23,641,875 23,641,875 100.0 26