Loading...
HomeMy WebLinkAbout3. BILLS 10/19/04 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE & EXPEND ITURE SUMMARIES January 1 -- September 30,2004 '10/14/2004 VILLAGE OF MOUNT PROSPECT 9 Months ( 75.0%) Completed 09:13:58 Budget 3 Months ( 25.0%) Remaining Revenue Summary 01/01/04 09/30/04 Cur Mo Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent REVENUE BY CLASSIFICATION PROPERTY TAXES 34,785 5,483,895 11,453,283 5,969,388 52.1 OTHER TAXES 800,080 6,847,475 12,378,646 5,531,171 44.7 LICENSES, PERMITS & FEES 107,429 2,609,138 2,814,250 205,112 7.3 INTERGOVERMENT REV. 886,402 8,377,400 14,903,344 6,525,944 43.8 CHARGES FOR SERVICE 1,383,202 11,165,166 15,373,741 4,208,575 27.4 FINES AND FORFEITS 45,959 420,679 556,500 135,821 24.4 INVESTMENT INCOME -237,338 2,296,822 4,431,950 2,135,128 48.2 REIMBURSEMENTS 31,318 391,739 627,051 235,312 37.5 OTHER REVENUE 305,177 2,592,487 4,147,865 1,555,378 37.5 OTHER FINANCING SOURCES 1,123,813 1,625,177 1,022,730 -602,447 -58.9 Total All Funds 4.480.827 41,809,978 67,709,360 25,899,382 38.3 REVENUE BY FUND GENERAL FUND 1,602,294 18,317,772 31,218,204 12,900,432 41.3 REFUSE DISPOSAL FUND 86,247 1,880,267 3,317,523 1,437,256 43.3 MOTOR FUEL TAX FUND 143,858 1,093,635 1,662,015 568,380 34.2 LAW ENFORCEMENT BLOCK GRANT 0 18 10,000 9,982 99.8 COMMUNITY DEVELPMNT BLOCK GRNT 40,910 413,649 550,450 136,801 24.9 ASSET SEIZURE FUND 58 389 7,700 7,311 94.9 DEA SHARED FUNDS FUND 41 33,723 12,000 -21,723 -181.0 DUI FINE FUND 3,364 15,837 10,100 -5,737 -56.8 SERIES 1987A B&I. PW FACILITY 262 33,016 67,700 34,684 51. 2 SERIES 1993B B&I, PUBLIC BLDGS 0 0 0 0 SERIES 2001 B&I, VILLAGE HALL 6,590 192,280 387,967 195,687 50.4 SERIES 2003 B&I, VILLAGE HALL 168,166 639,872 942,795 302,923 32.1 SERIES 2002B B&I, PUBLIC BLDGS 2,273 278,860 581,500 302,640 52.0 SERIES 2002A B&I, TIF 50 14,959 44,500 29,541 66.4 SERIES 1993A B&I, TIF 0 0 0 0 SERIES 1994B B&I, TIF 0 0 0 0 SERIES 1996B B&I, TIF 0 0 0 0 SERIES 1998B B&I, TIF 0 0 0 0 SERIES 1999 B&I, TIF 0 272.109 812,500 540,391 66.5 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 17,830 102,985 206,000 103,015 50.0 SERIES 1998A B&I, FLOOD 7,355 42,595 85,100 42,505 49.9 SERIES 1998C B&I, TIF 139 50,849 151,000 100,151 66.3 IEPA FLOOD CONTROL LOANS B&I 9,299 53,980 107,926 53,946 50.0 SERIES 2000 B&I, FLOOD CONTROL 12,942 74,993 150,250 75,257 50.1 SERIES 2002B B&I. FLOOD 47,728 275,750 551,000 275,250 50.0 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. 57,028 329,842 657,591 327,749 49.8 SERIES 2002B B&I, STREET IMP. 38,297 221,234 440,335 219,101 49.8 CAPITAL IMPROVEMENT FUND 2,735 214,378 452,551 238,173 52.6 POLICE & FIRE BLDG CaNST FUND 0 0 0 0 SERIES 2001 PROJECT FUND 0 0 0 0 SERIES 2003 PROJECT FUND 0 -4,507 40,000 44,507 111.3 1 10/14/2004 09:13:58 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/04 - 09/30/04 9 Months ( 3 Months ( 75.0% ) Completed 25.0% ) Remaining Cur Mo Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent 2002 LIBRARY PROJECT FUND o 0 0 0 CAPITAL IMPROVEMENT CONST FUND o 0 0 0 DOWNTOWN REDEVLPMNT CONST 705,141 853,888 440,077 -413,811 -94.0 STREET IMPROVEMENT CONST FUND 108,254 1,001,016 1,500,165 499,149 33.3 FLOOD CONTROL CONST 1998A 0 0 0 0 FLOOD CONTROL CONST FUND 1,689 12,096 15,000 2,904 19.4 WATER AND SEWER FUND 659,393 5,523,330 8,246,940 2,723,610 33.0 VILLAGE PARKING SYSTEM FUND 254,335 307,073 135,650 -171,423 -126.4 PARKING SYSTEM REVENUE FUND 6,341 57,442 241,655 184,213 76.2 VEHICLE MAINTENANCE FUND 102,439 919,442 1,228,529 309,087 25.2 VEHICLE REPLACEMENT FUND 80,735 689,907 1,045,548 355,641 34.0 COMPUTER REPLACEMENT FUND 19,123 168,306 227,906 59,600 26.2 RISK MANAGEMENT FUND 497,606 3,903,174 5,269,830 1,366,656 25.9 POLICE PENSION FUND -75,280 1,943,112 3,431,674 1,488,562 43.4 FIRE PENSION FUND -127,589 1,867,703 3,428,691 1,560,988 45.5 BENEFIT TRUST #2 FUND 0 0 0 0 ESCROW DEPOSIT FUND 1,140 1,140 0 -1,140 SSA #1 PROSPECT MEADOWS B&I 0 0 0 0 SSA #6 GEORGE/ALBERT B&I 34 13,549 30,988 17,439 56.3 SERIES 2002 LIBRARY BND ESCROW 0 315 0 -315 Total All Funds 4,480,827 41,809,978 67.709,360 25,899,382 38.3 2 . 10/14/2004 09:14:36 FRRBRRO3 SUM 021 GENERAL FUND 9 Months ( 3 Months ( 75.0% ) Completed 25.0% ) Remaining Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/04 - 09/30/04 Cur Mo Received 40 41 42 43 PROPERTY TAXES OTHER TAXES LICENSES, PERMITS & FEES INTERGOVERMENT REV. CHARGES FOR SERVICE FINES AND FORFEITS INVESTMENT INCOME REIMBURSEMENTS OTHER REVENUE 24,786 503,465 102,846 743,206 75,067 42,619 11,548 20,722 78,035 44 45 46 47 48 TOTAL GENERAL FUND 1,602,294 REFUSE DISPOSAL FUND 40 44 46 PROPERTY TAXES CHARGES FOR SERVICE INVESTMENT INCOME OTHER REVENUE 6,904 76,909 2,434 0 48 TOTAL REFUSE DISPOSAL FUND 86,247 MOTOR FUEL TAX FUND 43 46 47 INTERGOVERMENT REV. INVESTMENT INCOME REIMBURSEMENTS 140,445 1,979 1,434 TOTAL MOTOR FUEL TAX FUND 143,858 LAW ENFORCEMENT BLOCK GRANT 43 46 INTERGOVERMENT REV. INVESTMENT INCOME TOTAL LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT 43 46 48 INTERGOVERMENT REV. INVESTMENT INCOME OTHER REVENUE 2,751 3 38,156 TOTAL COMMUNITY DEVELPMNT BLOCK GRNT 40,910 ASSET SEIZURE FUND 45 46 FINES AND FORFEITS INVESTMENT INCOME TOTAL ASSET SEIZURE FUND DEA SHARED FUNDS FUND FINES AND FORFEITS INVESTMENT INCOME 45 46 1 Y-T-D Received 3,916,135 3,729,435 2,393,699 6,978,834 533,501 371,562 38,994 182,837 172,775 18,317,772 1,083,509 775,337 20,804 617 1,880,267 1,068,636 14,925 10,074 1,093,635 0 0 0 329,930 5 83,714 413,649 0 58 58 0 41 33,365 358 2004 Budget 8,164,528 5,921,639 2,581,250 12,535,274 806,863 527,000 230,000 316,650 135,000 31,218,204 2,278,223 1,009,300 30,000 0 3,317,523 1,630,765 30,000 1,250 1,662,015 0 18 10,000 0 18 10,000 485,450 0 65,000 550,450 8 381 7,500 200 389 7,700 12,000 0 Unreceived Balance 4,248,393 2,192,204 187,551 5,556,440 273,362 155,438 191,006 133,813 -37,775 12,900,432 1,194,714 233,963 9,196 -617 1,437,256 unreceived Percent 52.0 37.0 7.3 44.3 33.9 29.5 83.0 42.3 -28.0 41.3 52.4 23.2 30.7 43.3 562,129 34.5 15,075 50.3 -8,824 -705.9 568,380 10,000 -18 9,982 155,520 -5 -18,714 136,801 7,492 -181 7,311 34.2 100.0 99.8 32.0 -28.8 24.9 99.9 -90.5 94.9 -21,365 -178.0 -358 10/14/2004 9 Months ( 75.0%) Completed . 09:14:36 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0%) Remaining FRRBRRO3 SUM 021 Budget Revenue by Category within Fund Summary 01/01/04 - 09/30/04 Cur Mo Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent TOTAL DEA SHARED FUNDS FUND 41 33,723 12,000 -21,723 -181. 0 DUI FINE FUND 45 FINES AND FORFEITS 3,340 15,744 10,000 -5,744 -57.4 46 INVESTMENT INCOME 24 93 100 7 7.0 TOTAL DUI FINE FUND 3,364 15,837 10,100 -5,737 -56.8 SERIES 1987A B&I, PW FACILITY 40 PROPERTY TAXES 216 32,793 67,500 34,707 51.4 46 INVESTMENT INCOME 46 223 200 -23 -11.5 TOTAL SERIES 1987A B&I, PW FACILITY 262 33,016 67,700 34,684 51.2 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 1,121 175,494 366,032 190,538 52.1 46 INVESTMENT INCOME 110 710 500 -210 -42.0 49 OTHER FINANCING SOURCES 5,359 16,076 21,435 5,359 25.0 TOTAL SERIES 2001 B&I, VILLAGE HALL 6,590 192,280 387,967 195,687 50.4 SERIES 2003 B&I, VILLAGE HALL 40 PROPERTY TAXES 0 0 0 0 46 INVESTMENT INCOME 342 1,401 1,500 99 6.6 49 OTHER FINANCING SOURCES 167,824 638,471 941,295 302,824 32.2 TOTAL SERIES 2003 B&I, VILLAGE HALL 168,166 639,872 942,795 302,923 32.1 SERIES 2002B B&I, PUBLIC BLDGS 40 PROPERTY TAXES 1,758 275,964 577,000 301,036 52.2 46 INVESTMENT INCOME 515 2,896 4,500 1,604 35.6 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2002B B&I, PUBLIC BLDGS 2,273 278,860 581,500 302,640 52.0 SERIES 2002A B&I, TIF 41 OTHER TAXES 0 14,650 44,000 29,350 66.7 46 INVESTMENT INCOME 50 309 500 191 38.2 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2002A B&I, TIF 50 14,959 44,500 29,541 66.4 2 . 10/14/2004 9 Months ( 75.0%) Completed 09:14:36 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0%) Remaining FRRBRRO3 SUM 021 Budget Revenue by Category within Fund Summary 01/01/04 - 09/30/04 Cur Mo Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent 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 TOTAL SERIES 1993A B&I, TIF 0 0 0 0 SERIES 1994B B&I, TIF 41 OTHER TAXES 0 0 0 0 46 INVESTMENT INCOME 0 0 0 0 TOTAL SERIES 1994B B&I, TIF 0 0 0 0 SERIES 1996B 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 TOTAL SERIES 1996B B&I, TIF 0 0 0 0 SERIES 1998B B&I, TIF 41 OTHER TAXES 0 0 0 0 46 INVESTMENT INCOME 0 0 0 0 TOTAL SERIES 1998B B&I, TIF 0 0 0 0 SERIES 1999 B&I, TIF 41 OTHER TAXES 0 269,365 809,000 539,635 66.7 46 INVESTMENT INCOME 0 2,744 3,500 756 21.6 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 1999 B&I, TIF 0 272,109 812,500 540,391 66.5 SERIES 1992A B&I, FLOOD 41 OTHER TAXES 0 0 0 0 46 INVESTMENT INCOME 0 0 0 0 TOTAL SERIES 1992A B&I, FLOOD 0 0 0 0 SERIES 1993B B&I, FLOOD 41 OTHER 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, FLOOD 0 0 0 0 SERIES 1994A B&I, FLOOD 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, FLOOD 0 0 0 0 3 10/14/2004 09:14:36 FRRBRRO3 SUM 021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/04 - 09/30/04 9 Months ( 3 Months ( 75.0% ) Completed' 25.0% ) Remaining SERIES 1996A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME Cur Mo Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent 17,663 102,348 205,000 102,652 50.1 167 637 1,000 363 36.3 17,830 102,985 206,000 103,015 50.0 TOTAL SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 7,324 42,437 85,000 42,563 50.1 31 158 100 -58 -58.0 0 0 0 0 7,355 42,595 85,100 42,505 49.9 TOTAL SERIES 1998A B&I, FLOOD SERIES 1998C B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 0 139 49,944 905 150,000 1,000 151,000 100,056 95 66.7 9.5 TOTAL SERIES 1998C B&I, TIF 139 50,849 100,151 66.3 IEPA FLOOD CONTROL LOANS B&I 41 46 OTHER TAXES INVESTMENT INCOME 9,299 0 53,883 97 107,926 0 54,043 -97 50.1 TOTAL IEPA FLOOD CONTROL LOANS B&I 9,299 53,980 107,926 53,946 50.0 SERIES 2000 B&I, FLOOD CONTROL 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 12,924 74,889 150,000 75,111 50.1 18 104 250 146 58.4 0 0 0 0 12,942 74,993 150,250 75,257 50.1 TOTAL SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 47,389 274,592 550,000 275,408 50.1 339 1,158 1,000 -158 -15.8 0 0 0 0 47,728 275,750 551,000 275,250 50.0 TOTAL SERIES 2002B B&I, FLOOD SERIES 1994A B&I, STREET IMP. 41 OTHER TAXES 46 INVESTMENT INCOME 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 49 OTHER FINANCING SOURCES TOTAL SERIES 1994A B&I, STREET IMP. SERIES 1996A B&I, STREET IMP. 41 OTHER TAXES 46 INVESTMENT INCOME 0 0 0 0 0 0 0 0 TOTAL SERIES 1996A B&I, STREET IMP. 0 0 0 0 4 . 10/14/2004 9 Months ( 75.0%) Completed 09:14:36 3 Months ( 25.0% ) Remaining FRRBRRO3 VILLAGE OF MOUNT PROSPECT SUM 021 Budget Revenue by Category within Fund Summary 01/01/04 - 09/30/04 Cur Mo Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent SERIES 1998A B&I, STREET IMP. 41 OTHER TAXES 56,659 328,308 657,591 329,283 50.1 46 INVESTMENT INCOME 369 1,534 0 -1,534 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 1998A B&I, STREET IMP. 57,028 329,842 657,591 327,749 49.8 SERIES 2002B B&I, STREET IMP. 41 OTHER TAXES 37,940 219,841 440,335 220,494 50.1 46 INVESTMENT INCOME 357 1,393 0 -1,393 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2002B B&I, STREET IMP. 38,297 221,234 440,335 219,101 49.8 CAPITAL IMPROVEMENT FUND 43 INTERGOVERMENT REV. 0 0 112,400 112,400 100.0 46 INVESTMENT INCOME 2,735 18,633 20,000 1,367 6.8 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 2,735 214,378 452,551 238,173 52.6 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 0 -4,507 40,000 44,507 111.3 48 OTHER REVENUE 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2003 PROJECT FUND 0 -4,507 40,000 44,507 111.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 5 10/14/2004 9 Months ( 75.0% ) Completed 09:14:36 OF 3 Months ( 25.0% ) Remaining FRRBRRO3 VILLAGE MOUNT PROSPECT SUM 021 Budget Revenue by Category within Fund Summary 01/01/04 - 09/30/04 Cur Mo Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent TOTAL CAPITAL IMPROVEMENT CONST FUND 0 0 0 0 DOWNTOWN REDEVLPMNT CONST 41 OTHER TAXES 0 145,862 438,077 292,215 66.7 46 INVESTMENT INCOME 141 3,026 2,000 -1,026 -51.3 47 REIMBURSEMENTS 0 0 0 0 48 OTHER REVENUE 0 0 0 0 49 OTHER FINANCING SOURCES 705,000 705,000 0 -705,000 TOTAL DOWNTOWN REDEVLPMNT CONST 705,141 853,888 440,077 -413,811 -94.0 STREET IMPROVEMENT CONST FUND 41 OTHER TAXES 102,424 774,899 1,252,165 477,266 38.1 42 LICENSES, PERMITS & FEES 4,583 215,439 228,000 12,561 5.5 46 INVESTMENT INCOME 1,247 10,678 20,000 9,322 46.6 48 OTHER REVENUE 0 0 0 0 TOTAL STREET IMPROVEMENT CONST FUND 108,254 1,001,016 1,500,165 499,149 33.3 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 1,689 12,096 15,000 2,904 19.4 47 REIMBURSEMENTS 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL FLOOD CONTROL CONST FUND 1,689 12,096 15,000 2,904 19.4 WATER AND SEWER FUND 41 OTHER TAXES 4,993 753,669 1,537,025 783,356 51. 0 44 CHARGES FOR SERVICE 646,313 4,723,091 6,624,915 1,901,824 28.7 46 INVESTMENT INCOME 7,590 37,791 70,000 32,209 46.0 47 REIMBURSEMENTS 0 0 0 0 48 OTHER REVENUE 497 8,779 15,000 6,221 41. 5 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL WATER AND SEWER FUND 659,393 5,523,330 8,246,940 2,723,610 33.0 VILLAGE PARKING SYSTEM FUND 42 LICENSES, PERMITS & FEES 0 0 5,000 5,000 100.0 44 CHARGES FOR SERVICE 7,109 59,809 119,850 60,041 50.1 46 INVESTMENT INCOME 1,596 1,634 10,800 9,166 84.9 49 OTHER FINANCING SOURCES 245,630 245,630 0 -245,630 TOTAL VILLAGE PARKING SYSTEM FUND 254,335 307,073 135,650 -171,423 -126.4 6 . 10/14/2004 9 Months ( 75.0%) Completed 09:14:36 VILLAGE MOUNT 3 Months ( 25.0%) Remaining FRRBRRO3 OF PROSPECT SUM 021 Budget Revenue by Category within Fund Sununary 01/01/04 - 09/30/04 Cur Mo Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent 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 6,165 55,161 105,000 49,839 47.5 46 INVESTMENT INCOME 176 2,281 7,200 4,919 68.3 48 OTHER REVENUE 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL PARKING SYSTEM REVENUE FUND 6,341 57,442 241,655 184,213 76.2 VEHICLE MAINTENANCE FUND 44 CHARGES FOR SERVICE 101,752 915,774 1,221,029 305,255 25.0 46 INVESTMENT INCOME 687 3,668 7,500 3,832 51.1 48 OTHER REVENUE 0 0 0 0 TOTAL VEHICLE MAINTENANCE FUND 102,439 919,442 1,228,529 309,087 25.2 VEHICLE REPLACEMENT FUND 44 CHARGES FOR SERVICE 67,965 611,662 815,548 203,886 25.0 46 INVESTMENT INCOME 12,770 78,245 170,000 91,755 54.0 48 OTHER REVENUE 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 60,000 60,000 100.0 TOTAL VEHICLE REPLACEMENT FUND 80,735 689,907 1,045,548 355,641 34.0 COMPUTER REPLACEMENT FUND 44 CHARGES FOR SERVICE 17,993 161,929 215,906 53,977 25.0 46 INVESTMENT INCOME 1,130 6,377 12,000 5,623 46.9 TOTAL COMPUTER REPLACEMENT FUND 19,123 168,306 227,906 59,600 26.2 RISK MANAGEMENT FUND 43 INTERGOVERMENT REV. 0 0 0 0 44 CHARGES FOR SERVICE 383,929 3,328,902 4,455,330 1,126,428 25.3 46 INVESTMENT INCOME 2,321 14,780 42,000 27,220 64.8 47 REIMBURSEMENTS 9,162 36,723 70,000 33,277 47.5 48 OTHER REVENUE 102,194 522,769 702,500 179,731 25.6 TOTAL RISK MANAGEMENT FUND 497,606 3,903,174 5,269,830 1,366,656 25.9 POLICE PENSION FUND 46 INVESTMENT INCOME -121,689 996,817 1,786,000 789,183 44.2 48 OTHER REVENUE 46,409 946,295 1,645,674 699,379 42.5 TOTAL POLICE PENSION FUND -75,280 1,943,112 3,431,674 1,488,562 43.4 FIRE PENSION FUND 46 INVESTMENT INCOME -167,475 1,023,805 1,925,000 901,195 46.8 48 OTHER REVENUE 39,886 843,898 1,503,691 659,793 43.9 TOTAL FIRE PENSION FUND -127,589 1,867,703 3,428,691 1,560,988 45.5 7 10/14/2004 09:14:36 FRRBRRO3 SUM 021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/04 - 09/30/04 9 Months ( 3 Months ( 75.0% ) Completed 25.0% ) Remaining Cur Mo Received Y-T-D Received 2004 Budget Unreceived Balance Unreceived Percent BENEFIT TRUST #2 FUND 46 INVESTMENT INCOME 0 0 0 0 TOTAL BENEFIT TRUST #2 FUND 0 0 0 0 ESCROW DEPOSIT FUND 46 INVESTMENT INCOME 1,140 1,140 0 -1,140 TOTAL ESCROW DEPOSIT FUND 1,140 1,140 0 -1,140 SSA #1 PROSPECT MEADOWS B&I 41 46 OTHER TAXES 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 0 34 13,353 196 30,888 100 17,535 -96 56.8 -96 .0 TOTAL SSA #6 GEORGE/ALBERT B&I 34 13,549 30,988 17,439 56.3 SERIES 2002 LIBRARY BND ESCROW 46 INVESTMENT INCOME 0 315 0 -315 TOTAL SERIES 2002 LIBRARY BND ESCROW 0 315 0 -315 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 9 Months ( 3 Months ( . 10/14/2004 09:12:57 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/04 09/30/04 Cur Mo Expended Y-T-D Expended 2004 Budget 75.0% ) Completed 25.0% ) Remaining Unexpended Balance 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 OTHER FINANCING USES Total All Funds 2,372,873 479,978 13,468 377,765 1,129,284 34,543 443,225 73,027 5,468 0 402,866 3,378 184,492 43,553 19,870 33,215 0 0 600 418,813 0 6,036,418 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 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 1992B B&I, TIF SERIES 1993A B&I, TIF SERIES 1994B B&I, TIF 2,966,648 284,898 66,163 0 33,428 0 927 8,878 0 0 0 300 0 0 0 0 0 0 0 SERIES SERIES SERIES SERIES SERIES SERIES SERIES SERIES SERIES 1996B B&I, TIF 1998B B&I, TIF 1999 B&I, TIF 1991A B&I, FLOOD 1992A B&I, FLOOD 1993B B&I, FLOOD 1994A B&I, FLOOD 1996A B&I, FLOOD 1998A B&I, FLOOD 15,720,798 4,875,542 141,445 3,230,276 9,638,119 316,628 4,308,303 818,268 274,524 27,390 6,513,186 575,074 590,580 272,292 551,739 4,207,818 701,964 882,582 3,750 900,177 0 54,550,455 22,996,922 2,486,584 1,476,019 12,515 389,793 0 18,653 9,287 66,000 0 103,889 238,416 16,878 1,450 0 0 0 0 300 0 0 0 0 0 708,500 0 0 0 0 0 0 13,040 5,126 1 21,229,055 7,323,690 286,426 4,544,714 13,596,083 528,812 6,079,627 1,099,172 754,005 27,390 6,079,855 618,458 1,115,300 545,385 1,397,632 6,684,146 4,608,069 1,452,835 7,800 962,730 0 78,941,184 31,655,480 3,533,222 2,461,793 12,524 620,305 7,000 4,700 3,000 66,000 0 387,778 916,232 649,956 53,800 0 0 0 0 0 708,500 0 0 0 0 216,080 65,252 5,508,257 2,448,148 144,981 1,314,438 3,957,964 212,184 1,771,324 280,904 479,481 0 -433,331 43,384 524,720 273,093 845,893 2,476,328 3,906,105 570,253 4,050 62,553 0 24,390,729 8,658,558 1,046,638 985,774 9 230,512 7,000 -13,953 -6,287 0 0 283,889 677,816 633,078 52,350 0 0 0 0 0 0 0 0 0 0 203,040 60,126 25.9 33.4 50.6 28.9 29.1 40.1 29.1 25.6 63.6 -7.1 7.0 47.0 50.1 60.5 37.0 84.8 39.3 51. 9 6.5 30.9 27.4 29.6 40.0 0.1 37.2 100.0 -296.9 -209.6 73.2 74.0 97.4 97.3 94.0 92 .1 10/14/2004 09:12:57 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/04 - 09/30/04 9 Months ( 3 Months ( 75.0% ) Completed 25.0% ) Remaining Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent SERIES 1998C B&I, TIF 0 14,888 149,775 134,887 90.1 IEPA FLOOD CONTROL LOANS B&I 0 326,322 613,357 287,035 46.8 SERIES 2000 B&I, FLOOD CONTROL 0 56,349 112,098 55,749 49.7 SERIES 2002B B&I, FLOOD 0 9,490 492,381 482,891 98.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. 0 17,887 895,775 877,888 98.0 SERIES 2002B B&I, STREET IMP. 0 7,313 600,225 592,912 98.8 CAPITAL IMPROVEMENT FUND 33,931 350,017 912,111 562,094 61. 6 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 391,629 6,820,567 5,786,400 -1,034,167 -17.9 2002 LIBRARY PROJECT FUND 0 0 0 0 CAPITAL IMPROVEMENT CONST FUND 0 0 0 0 DOWNTOWN REDEVLPMNT CONST 18,663 1,278,425 1,824,982 546,557 29.9 STREET IMPROVEMENT CONST FUND 177,283 1,985,227 2,893,980 908,753 31.4 FLOOD CONTROL CONST FUND 0 223,534 686,744 463,210 67.5 WATER AND SEWER FUND 724,806 5,745,694 9,308,159 3,562,465 38.3 VILLAGE PARKING SYSTEM FUND 8,501 62,473 227,014 164,541 72.5 PARKING SYSTEM REVENUE FUND 257,285 346,056 262,591 -83,465 -31.8 VEHICLE MAINTENANCE FUND 109,802 906,372 1,277,582 371,210 29.1 VEHICLE REPLACEMENT FUND 184,492 590,580 1,115,300 524,720 47.0 COMPUTER REPLACEMENT FUND 711 125,348 147,150 21,802 14.8 RISK MANAGEMENT FUND 394,489 3,947,055 5,640,293 1,693,238 30.0 POLICE PENSION FUND 190,433 1,582,978 2,226,120 643,142 28.9 FIRE PENSION FUND 182,851 1,608,060 2,267,030 658,970 29.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 0 2,748 40,495 37,747 93.2 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 Total All Funds 6,036,418 54,550,455 78,941,184 24,390,729 30.9 2 . 10/14/2004 9 Months ( 75.0%) Completed 09:15:12 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0%) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/04 - 09/30/04 Cur Mo Y-T-D 2004 Unexpended Unexpended PUBLIC REPRESENTATION Expended Expended Budget Balance Percent PROGRAM TOTALS 02 MAYOR AND BOARD OF TRUSTEES 3,194 80,320 92,916 12,596 13.6 03 ADVISORY BOARDS & COMMISSIONS 1,764 11,657 14,958 3,301 22.1 Totals 4,958 91,977 107,874 15,897 14.7 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 3,163 25,808 34,370 8,562 24.9 51 EMPLOYEE BENEFITS 513 4,217 5,648 1,431 25.3 52 OTHER EMPLOYEE COSTS 40 379 0 -379 54 CONTRACTUAL SERVICES 851 59,030 61,856 2,826 4.6 55 UTILITIES 17 341 500 159 31.8 57 COMMODITIES & SUPPLIES 374 2,202 5,500 3,298 60.0 65 OFFICE EQUIPMENT 0 0 0 0 Totals 4,958 91,977 1.07,874 15,897 14.7 SOURCE OF FUNDS 001 GENERAL FUND 4,958 91,977 107,874 15,897 14.7 Totals 4,958 91,977 107,874 15,897 14.7 1 10/14/2004 9 Months ( 75.0%) Completed 09:15:12 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0%) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/04 - 09/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 51,027 329,557 391,807 62,250 15.9 02 LEGAL SERVICES 56,643 410,020 340,000 -70,020 -20.6 03 PERSONNEL SERVICES 23,494 170,523 265,353 94,830 35.7 04 INFORMATION TECHNOLOGY 68,589 478,664 692,715 214,051 30.9 05 PUBLIC INFORMATION 9,087 80,468 144,478 64,010 44.3 Totals 208,840 1,469,232 1,834,353 365,121 19.9 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 81,729 513,471 683,850 170,379 24.9 51 EMPLOYEE BENEFITS 19,060 147,565 197,321 49,756 25.2 52 OTHER EMPLOYEE COSTS 2,936 16,925 27,800 10,875 39.1 54 CONTRACTUAL SERVICES 100,102 741,150 892,752 151,602 17.0 55 UTILITIES 1,153 4,401 7,580 3,179 41. 9 57 COMMODITIES & SUPPLIES 3,860 30,803 10,400 -20,403 -196.2 65 OFFICE EQUIPMENT 0 14,917 14,650 -267 -1. 8 67 OTHER EQUIPMENT 0 0 0 0 Totals 208,840 1,469,232 1,834,353 365,121 19.9 SOURCE OF FUNDS 001 GENERAL FUND 208,840 1,469,232 1,834,353 365,121 19.9 Totals 208,840 1,469,232 1,834,353 365,121 19.9 2 - 10/14/2004 09:15:12 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 ~ 09/30/04 9 Months ( 3 Months ( 75.0% ) Completed 25.0% ) Remaining Cur Mo Y-T-D 2004 Unexpended Unexpended TV SERVICES DIVISION Expended Expended Budget Balance Percent PROGRAM TOTALS 02 CABLE TV OPERATIONS 15,596 96,556 126,336 29,780 23.6 03 OTHER SERVICES 0 0 0 0 04 INTERGOVERNMENTAL PROGRAMMING 4,102 30,131 43,926 13,795 31.4 Totals 19,698 126,687 170,262 43,575 25.6 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT Totals 10,640 67,019 90,770 23,751 26.2 3,361 25,990 34,920 8,930 25.6 0 535 1,850 1,315 71.1 2,812 16,215 24,397 8,182 33.5 0 1,137 1,350 213 15.8 1,945 5,971 7,225 1,254 17.4 940 9,820 9,750 -70 -0.7 19,698 126,687 170,262 43,575 25.6 SOURCE OF FUNDS 001 GENERAL FUND 19,698 126,687 170,262 43,575 25.6 Totals 19,698 126,687 170,262 43,575 25.6 3 10/14/2004 9 Months ( 75.0%) Completed 09:15:12 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0%) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/04 - 09/30/04 Cur Mo Y-T-D 2004 Unexpended Unexpended VILLAGE CLERK'S OFFICE Expended Expended Budget Balance Percent PROGRAM TOTALS 02 VILLAGE CLERK'S OFFICE 16,748 124,477 163,256 38,779 23.8 Totals 16,748 124,477 163,256 38,779 23.8 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 10,201 67,239 90,790 23,551 25.9 51 EMPLOYEE BENEFITS 3,351 26,450 35,726 9,276 26.0 52 OTHER EMPLOYEE COSTS 377 1,162 1,700 538 31. 6 54 CONTRACTUAL SERVICES 307 22,844 29,040 6,196 21.3 55 UTILITIES 55 1,160 1,600 440 27.5 57 COMMODITIES & SUPPLIES 2,457 5,622 4,400 -1,222 -27.8 Totals 16,748 124,477 163,256 38,779 23.8 SOURCE OF FUNDS 001 GENERAL FUND 16,748 124,477 163,256 38,779 23.8 Totals 16,748 124,477 163,256 38,779 23.8 4 '10/14/2004 9 Months ( 75.0%) Completed 09:15:12 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0%) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/04 - 09/30/04 Cur Mo Y-T-D 2004 Unexpended Unexpended FINANCE DEPARTMENT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 FINANCE ADMINISTRATION 20,594 145,430 202,133 56,703 28.1 02 ACCOUNTING 43,301 298,683 387,505 88,822 22.9 03 DATA PROCESSING 0 0 0 0 04 DUPLICATING SERVICES 0 8,461 12,665 4,204 33.2 05 INSURANCE PROGRAMS 32,112 273,837 364,465 90,628 24.9 06 CUSTOMER SERVICES 38,904 263,251 357,712 94,461 26.4 07 CASH MANAGEMENT 3,319 22,643 43,851 21,208 48.4 Totals 138,230 1,012,305 1,368,331 356,026 26.0 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 79,046 526,288 703,910 177,622 25.2 51 EMPLOYEE BENEFITS 23,699 185,353 248,252 62,899 25.3 52 OTHER EMPLOYEE COSTS 398 3,688 4,650 962 20.7 54 CONTRACTUAL SERVICES 7,041 54,183 76,240 22,057 28.9 55 UTILITIES 216 4,253 6,700 2,447 36.5 56 INSURANCE 25,207 226,859 302,479 75,620 25.0 57 COMMODITIES & SUPPLIES 1,912 10,113 23,900 13,787 57.7 65 OFFICE EQUIPMENT 711 1,568 2,200 632 28.7 Totals 138,230 1,012,305 1,368,331 356,026 26.0 SOURCE OF FUNDS 001 GENERAL FUND 138,230 1,012,305 1,368,331 356,026 26.0 Totals 138,230 1,012,305 1,368,331 356,026 26.0 5 10/14/2004 09:15:12 FRRDBROl SUM 031 9 Months ( 3 Months ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 09/30/04 COMMUNITY DEVELOPMENT Cur Mo Expended PROGRAM 01 02 03 05 06 07 TOTALS COMMUNITY DEVELOPMENT PLANNING & ZONING ECONOMIC DEVELOPMENT BUILDING INSPECTIONS HOUSING INSPECTIONS HEALTH INSPECTIONS ADMIN 21,487 15,109 8,441 67,072 30,491 11,606 Totals 154,206 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT SOURCE OF FUNDS 001 550 108,454 34,337 139 7,744 2,323 1,209 0 Totals 154,206 GENERAL FUND DOWNTOWN REDEVLPMNT CONST 154,206 0 Totals 154,206 6 Y-T-D Expended 144,447 116,993 49,322 500,875 216,191 80,781 1,108,609 738,054 272,637 8,314 69,887 12,337 7,380 0 1,108,609 1,108,609 0 1,108,609 2004 Budget 189,713 160,244 94,879 717,261 306,296 112, 134 1,580,527 1,016,985 369,823 13,166 138,501 24,904 17,148 0 1,580,527 1,580,046 481 1,580,527 75.0% ) Completed 25.0% ) Remaining Unexpended Unexpended Balance Percent 45,266 43,251 45,557 216,386 90,105 31,353 471,918 278,931 97,186 4,852 68,614 12,567 9,768 0 471,918 471,437 481 471,918 23.9 27.0 48.0 30.2 29.4 28.0 29.9 27.4 26.3 36.9 49.5 50.5 57.0 29.9 29.8 100.0 29.9 . 10/14/2004 9 Months ( 75.0%) Completed 09:15:12 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0%) Remaining FRRDBROl SUM031 Department Budget Expenditure Summary 01/01/04 - 09/30/04 Cur Mo Y-T-D 2004 Unexpended Unexpended COMMUNITY DEVELOPMENT - CDBG Expended Expended Budget Balance Percent PROGRAM TOTALS 04 CDBG ADMINISTRATION 6,538 46,755 67,714 20,959 31.0 05 CDBG COMMUNITY PROGRAMS 8,500 73,543 136,500 62,957 46.1 06 ACCESSIBLTY & NEIGHBRHD IMPRV 12,922 115,404 140,000 24,596 17.6 07 CDBG RESIDENTIAL REHAB 5,468 154,091 276,091 122,000 44.2 Totals 33,428 389,793 620,305 230,512 37.2 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 4,802 31,620 45,400 13,780 30.4 51 EMPLOYEE BENEFITS 1,633 12,901 17,429 4,528 26.0 52 OTHER EMPLOYEE COSTS 0 508 1,075 567 52.7 54 CONTRACTUAL SERVICES 8,603 74,866 138,915 64,049 46.1 57 COMMODITIES & SUPPLIES 0 403 1,395 992 71.1 59 OTHER EXPENDITURES 5,468 154,091 276,091 122,000 44.2 64 BUILDING IMPROVEMENTS 5,618 50,804 75,000 24,196 32.3 69 INFRASTRUCTURE 7,304 64,600 65,000 400 0.6 Totals 33,428 389,793 620,305 230,512 37.2 SOURCE OF FUNDS 070 COMMUNITY DEVELPMNT BLOCK GRNT 33,428 389,793 620,305 230,512 37.2 Totals 33,428 389,793 620,305 230,512 37.2 7 10/14/2004 09:15:12 FRRDBROl SUM 031 9 Months ( 3 Months ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 09/30/04 PROGRAM TOTALS HUMAN SERVICES Cur Mo Expended 01 02 03 04 05 HUMAN SERVICES ADMINISTRATION SOCIAL SERVICES NURSING/HEALTH SERVICES SENIOR CTR. LEISURE ACTIVITIES YOUTH ACTIVITIES 21,388 30,793 14,979 3,606 2,179 Totals 72,945 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 SOURCE OF FUNDS 001 51,879 14,009 323 4,153 939 1,642 0 0 Totals 72,945 GENERAL FUND 72,945 Totals 72,945 8 Y-T-D Expended 151,595 210,920 107,626 32,708 14,489 517,338 325,346 104,698 1,779 70,522 10,243 4,750 517,338 517,338 517,338 2004 Budget 214,418 283,779 179,857 44,164 62,649 784,867 0 0 477,790 147,120 3,900 107,302 9,180 38,075 1,500 0 784,867 784,867 784,867 75.0% ) Completed 25.0% ) Remaining Unexpended Unexpended Balance Percent 62,823 72,859 72,231 11,456 48,160 267,529 152,444 42,422 2,121 36,780 -1,063 33,325 1,500 0 267,529 267,529 267,529 29.3 25.7 40.2 25.9 76.9 34.1 31. 9 28.8 54.4 34.3 -11.6 87.5 100.0 34.1 34.1 34.1 '10/14/2004 9 Months ( 75.0%) Completed 09:15:12 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0%) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/04 - 09/30/04 Cur Mo Y-T-D 2004 Unexpended Unexpended POLICE Expended Expended Budget Balance Percent PROGRAM TOTALS 01 POLICE ADMINISTRATION 148,605 1,534,837 2,327,595 792,758 34.1 02 PATROL & TRAFFIC ENFORCEMENT 740,434 5,352,641 6,922,590 1,569,949 22.7 03 CRIME PREVTN & PUBLIC SERVICES 24,475 169,434 227,489 58,055 25.5 04 INVESTIGATIVE & JUVENILE PRGM 111,776 777,185 1,173,577 396,392 33.8 05 CROSSING GUARDS 2,785 16,559 26,750 10,191 38.1 06 EQUIPMENT MAINTENANCE 50,393 456,511 642,911 186,400 29.0 Totals 1,078,468 8,307,167 11,320,912 3,013,745 26.6 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 826,865 5,542,979 7,301,240 1,758,261 24.1 51 EMPLOYEE BENEFITS 130,197 1,595,669 2,521,297 925,628 36.7 52 OTHER EMPLOYEE COSTS 6,149 57,394 79,450 22,056 27.8 54 CONTRACTUAL SERVICES 98,561 980,438 1,246,596 266,158 21.4 55 UTILITIES 2,432 29,635 52,000 22.365 43.0 57 COMMODITIES & SUPPLIES 3,807 51,274 70,905 19,631 27.7 59 OTHER EXPENDITURES 0 0 0 0 65 OFFICE EQUIPMENT 0 13,572 13,674 102 0.7 67 OTHER EQUIPMENT 10,457 36,206 35,750 -456 -1. 3 Totals 1,078,468 8,307,167 11,320,912 3,013,745 26.6 SOURCE OF FUNDS 001 GENERAL FUND 1,068,663 8,266,712 11,293,688 3,026,976 26.8 060 LAW ENFORCEMENT BLOCK GRANT 0 12,515 12,524 9 0.1 080 ASSET SEIZURE FUND 0 0 7,000 7,000 100.0 085 DEA SHARED FUNDS FUND 927 18,653 4,700 -13,953 -296.9 086 DUI FINE FUND 8,878 9,287 3,000 -6,287 -209.6 Totals 1,078,468 8,307,167 11,320,912 3,013,745 26.6 9 10/14/2004 9 Months ( 75.0%) Completed 09:15:12 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0% ) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/04 - 09/30/04 Cur Mo Y-T-D 2004 Unexpended Unexpended FIRE Expended Expended Budget Balance Percent PROGRAM TOTALS 01 FIRE ADMINISTRATION 82,201 1,088,871 1,929,555 840,684 43.6 02 FIRE DEPARTMENT OPERATIONS 649,640 4,433,726 5,936,550 1,502,824 25.3 03 FIRE TRAINING ACADEMY 1,094 5,661 13,140 7,479 56.9 04 FIRE PREVENTION 38,885 295,755 414,400 118,645 28.6 05 FIRE COMMUNICATIONS 4,842 40,858 60,100 19,242 32.0 06 EQUIPMENT MAINTENANCE 36,537 331,488 433,470 101,982 23.5 07 EMERGENCY PREPARDENESS PRGM 3,989 5,041 10,500 5,459 52.0 08 PAID-ON-CALL PROGRAM 2,288 13,409 31,685 18,276 57.7 Totals 819.476 6,214,809 8,829,400 2,614,591 29.6 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 672,710 4,366,224 5,913,390 1,547,166 26.2 51 EMPLOYEE BENEFITS 101,237 1,353,919 2,198,047 844,128 38.4 52 OTHER EMPLOYEE COSTS 465 23,844 95,915 72,071 75.1 54 CONTRACTUAL SERVICES 36,206 316,136 428,628 112,492 26.2 55 UTILITIES 2,316 30,818 42,750 11,932 27.9 57 COMMODITIES & SUPPLIES 4,263 59,223 81,010 21,787 26.9 64 BUILDING IMPROVEMENTS 0 5,647 5,000 -647 -12.9 65 OFFICE EQUIPMENT 0 354 5,000 4,646 92.9 67 OTHER EQUIPMENT 2,279 58,644 59,660 1,016 1.7 Totals 819,476 6,214,809 8,829,400 2,614,591 29.6 SOURCE OF FUNDS 001 GENERAL FUND 819,476 6,214,809 8,829,400 2,614,591 29.6 Totals 819,476 6,214,809 8,829,400 2,614,591 29.6 10 . 10/14/2004 9 Months ( 75.0%) Completed 09,15:12 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0% ) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/04 - 09/30/04 Cur Mo Y-T-D 2004 Unexpended Unexpended PUBLIC WORKS - ADMINISTRATION Expended Expended Budget Balance Percent PROGRAM TOTALS 01 PUBLIC WORKS ADMINSTRATION 90,056 740,810 1,001,751 260,941 26.0 Totals 90,056 740,810 1,001,751 260,941 26.0 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 26,158 165,865 217,705 51,840 23.8 51 EMPLOYEE BENEFITS 9,994 81,104 107,427 26,323 24.5 52 OTHER EMPLOYEE COSTS 984 11,809 23,700 11,891 50.2 54 CONTRACTUAL SERVICES 51,512 463,547 626,004 162,457 26.0 55 UTILITIES 989 11,392 17,955 6,563 36.6 57 COMMODITIES & SUPPLIES 266 6,380 7,400 1,020 13.8 65 OFFICE EQUIPMENT 153 153 1,000 847 84.7 67 OTHER EQUIPMENT 0 560 560 0 Totals 90,056 740,810 1,001,751 260,941 26.0 SOURCE OF FUNDS 001 GENERAL FUND 90,056 740,810 1,001,751 260,941 26.0 Totals 90,056 740,810 1,001,751 260,941 26.0 11 10/14/2004 09:15:12 FRRDBROl SUM 031 9 Months ( 3 Months ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 09/30/04 PUBLIC WORKS - STREETS/BLDGS Cur Mo Expended PROGRAM TOTALS 01 02 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 18,325 71,279 65,513 11,493 0 18,037 10,202 7,549 8,501 256,740 368 04 05 06 07 08 09 10 11 12 Totals 468,007 EXPENDITURE CLASSIFICATION 50 51 99,574 26,729 80,029 488 1,063 11,185 0 903 0 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 80 2,406 245,630 Totals 468,007 SOURCE OF FUNDS 001 050 620 630 GENERAL FUND MOTOR FUEL TAX FUND VILLAGE PARKING SYSTEM FUND PARKING SYSTEM REVENUE FUND 156,530 46,236 8,501 256,740 Totals 468,007 12 Y-T-D Expended 100,312 514,454 326,639 310,395 1 107,630 49,813 75,492 62,473 346,056 177,991 2,071,256 842,059 232,786 426,864 24,897 9,567 221,949 0 1,247 0 66,257 245,630 2,071,256 1,483,114 179,613 62,473 346,056 2,071,256 2004 Budget 75.0% ) Completed 25.0% ) Remaining Unexpended Unexpended Balance Percent 154,747 702,005 436,170 353,609 0 158,969 64,700 105,417 227,014 133,136 0 2,335,767 992,640 289,642 518,204 18,650 12,756 253,875 0 5,000 0 245,000 0 2,335,767 1,771,822 203,795 227,014 133,136 2,335,767 54,435 187,551 109,531 43,214 -1 51,339 14,887 29,925 164,541 -212,920 -177,991 264,511 150,581 56,856 91,340 -6,247 3,189 31,926 0 3,753 0 178,743 -245,630 264,511 288,708 24,182 164,541 -212,920 264,511 35.2 26.7 25.1 12.2 32.3 23.0 28.4 72 .5 -159.9 11.3 15.2 19.6 17.6 -33.5 25.0 12.6 75.1 73.0 11.3 16.3 11.9 72.5 -159.9 11.3 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 09/30/04 9 Months ( 3 Months ( 75.0% ) Completed 25.0% ) Remaining . 10/14/2004 09:15:12 Totals Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 24,331 147,501 195,375 47,874 24.5 33,791 275,380 395,583 120,203 30.4 44,939 418,667 640,665 221,998 34.7 3,971 28,799 41,615 12,816 30.8 107,032 870,347 1,273,238 402,891 31. 6 PUBLIC WORKS - FORESTRY/GRNDS PROGRAM TOTALS 01 02 FORESTRY DIVISION ADMIN MAINTENANCE OF GROUND FORESTRY PROGRAM PUBLIC GROUNDS BEAUTIFICATION 03 04 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT Totals 71,349 463,822 631,475 167,653 26.5 18,992 143,416 193,228 49,812 25.8 0 750 750 0 16,070 241,267 417,105 175,838 42.2 621 21,092 24,910 3,818 15.3 0 0 5,770 5,770 100.0 107,032 870,347 1,273,238 402,891 31.6 SOURCE OF FUNDS 001 690 GENERAL FUND RISK MANAGEMENT FUND 107,032 0 870,347 0 1,263,238 10,000 1,273,238 392,891 10,000 402,891 31.1 100.0 Totals '107,032 870,347 31.6 13 10/14/2004 09:15:12 FRRDBROl SUM 031 9 Months ( 3 Months ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 09/30/04 PROGRAM TOTALS PUBLIC WORKS - ENGINEERING Cur Mo Expended 01 05 ENGINEERING SERVICES TRAFFIC CNTRL & STREET LGHTNG 73,869 39,783 Totals 113,652 EXPENDITURE CLASSIFICATION 50 51 52 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES UTILITIES COMMODITIES & SUPPLIES OFFICE EQUIPMENT OTHER EQUIPMENT INFRASTRUCTURE 64,332 16,616 0 11,610 19,472 1,622 0 54 55 57 65 67 69 Totals 113,652 SOURCE OF FUNDS 001 050 95,173 18,479 113,652 GENERAL FUND MOTOR FUEL TAX FUND Totals 14 Y-T-D Expended 481,093 217,582 698,675 0 0 388,951 120,420 3,350 64,591 105,503 14,024 0 0 1,836 698,675 620,072 78,603 698,675 2004 Budget 670,588 569,563 1,240,151 540,740 162,834 3,450 162,007 188,575 25,095 500 1,500 155,450 1,240,151 883,976 356,175 1,240,151 75.0% ) Completed 25.0% ) Remaining Unexpended Unexpended Balance Percent 189,495 351,981 541,476 151,789 42,414 100 97,416 83,072 11,071 500 1,500 153,614 541,476 263,904 277,572 541,476 28.3 61. 8 43.7 28.1 26.0 2.9 60.1 44.1 44.1 100.0 100.0 98.8 43.7 29.9 77.9 43.7 .10/14/2004 9 Months ( 75.0%) Completed 09:15:12 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0%) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/04 - 09/30/04 Cur Mo Y-T-D 2004 Unexpended Unexpended PUBLIC WORKS - WATER/SEWER Expended Expended Budget Balance Percent PROGRAM TOTALS 01 WATER & SEWER DIVISION ADMIN 122,653 915,553 1,482,835 567,282 38.3 02 MAINTENANCE OF BUILDINGS 11,905 100,898 160,295 59,397 37.1 03 MAINTENANCE OF GROUNDS 7,510 57,011 82,664 25,653 31.0 04 WATER SUPPLY MAINT & REPAIR 49,607 321,231 478,131 156,900 32.8 05 WATER DISTRBT MAINT & REPAIR 43,524 356,449 846,358 489,909 57.9 06 WATER VALVE/HYDRNT MAINT & REP 27,953 206,502 285,706 79,204 27.7 07 WATER METER MAINT & REPL 27,039 207,430 308,474 101,044 32.8 08 EQUIPMENT MAINTENANCE 44,172 397,550 530,066 132,516 25.0 09 SANITARY SEWER MAINT & REPAIR 36,196 232,537 364,271 131,734 36.2 10 WATER & SEWER SYSTEM IMPROV 62,023 609,788 1,699,359 1,089,571 64.1 12 LAKE MICHIGAN WATER SUPPLY 292,224 2,340,745 3,070,000 729,255 23.8 Totals 724,806 5,745,694 9,308,159 3,562,465 38.3 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 175,716 1,055,417 1,602,190 546,773 34.1 51 EMPLOYEE BENEFITS 52,271 380,676 528,341 147,665 27.9 52 OTHER EMPLOYEE COSTS 1,582 10,633 26,270 15,637 59.5 54 CONTRACTUAL SERVICES 430,667 3,330,880 4,780,629 1,449,749 30.3 55 UTILITIES 4,066 79,541 155,123 75,582 48.7 56 INSURANCE 21,771 132,304 165,801 33,497 20.2 57 COMMODITIES & SUPPLIES 16,943 130,720 166,148 35,428 21.3 59 OTHER EXPENDITURES 0 2,457 15,172 12, 715 83.8 65 OFFICE EQUIPMENT 0 4,494 6,200 1,706 27.5 67 OTHER EQUIPMENT 1,920 66,833 363,653 296,820 81.6 68 DISTRIBUTION SYSTEMS 19,870 551,739 1,397,632 845,893 60.5 71 BOND PRINCIPAL 0 0 101,000 101,000 100.0 Totals 724,806 5,745,694 9,308,159 3,562,465 38.3 SOURCE OF FUNDS 610 WATER AND SEWER FUND 724,806 5,745,694 9,308,159 3,562,465 38.3 Totals 724,806 5,745,694 9,308,159 3,562,465 38.3 15 10/14/2004 9 Months ( 75.0%) Completed 09:15:12 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0%) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/04 - 09/30/04 Cur Mo Y-T-D 2004 Unexpended Unexpended PUBLIC WORKS - REFUSE DISPOSAL Expended Expended Budget Balance Percent PROGRAM TOTALS 01 REFUSE DISPOSAL PROGRAM 272,901 2,407,163 3,362,241 955,078 28.4 02 REFUSE LEAF REMOVAL PROGRAM 11,997 79,421 170,981 91,560 53.5 Totals 284.898 2,486,584 3,533,222 1,046,638 29.6 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 17,614 115,984 202,005 86,021 42.6 51 EMPLOYEE BENEFITS 5,275 40,190 60,718 20,528 33.8 52 OTHER EMPLOYEE COSTS 0 175 750 575 76.7 54 CONTRACTUAL SERVICES 260,828 2,311,878 3,236,561 924,683 28.6 55 UTILITIES 22 269 545 276 50.6 56 INSURANCE 695 3,561 4,298 737 17.1 57 COMMODITIES & SUPPLIES 464 14,527 28,345 13,818 48.7 Totals 284,898 2,486,584 3,533,222 1,046,638 29.6 SOURCE OF FUNDS 030 REFUSE DISPOSAL FUND 284,898 2,486,584 3,533,222 1,046,638 29.6 Totals 284,898 2,486,584 3,533,222 1,046,638 29.6 16 '10/14/2004 9 Months ( 75.0%) Completed 09:15:12 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0%) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/04 - 09/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 17,266 112,934 178,656 65,722 36.8 02 VEHICLE MAINTENANCE PROGRAM 92,536 793,438 1,098,926 305,488 27.8 Totals 109,802 906,372 1,277,582 371,210 29.1 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 67,910 428,007 628,415 200,408 31. 9 51 EMPLOYEE BENEFITS 18,514 141,429 196,550 55,121 28.0 52 OTHER EMPLOYEE COSTS 75 200 2,000 1,800 90.0 54 CONTRACTUAL SERVICES 3,876 47,544 71,026 23,482 33.1 55 UTILITIES 55 701 1,000 299 29.9 57 COMMODITIES & SUPPLIES 19,372 223,957 310,741 86,784 27.9 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 109,802 906,372 1,277,582 371,210 29.1 SOURCE OF FUNDS 660 VEHICLE MAINTENANCE FUND 109,802 906,372 1,277,582 371,210 29.1 Totals 109,802 906,372 1,277,582 371,210 29.1 17 10/14/2004 9 Months ( 75.0%) Completed 09:15:12 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0%) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/04 09/30/04 Cur Mo Y-T-D 2004 Unexpended Unexpended COMMUNITY SERVICE PROGRAMS Expended Expended Budget Balance Percent PROGRAM TOTALS 02 COMMUNITY GROUPS & MISC 4,471 58,235 88,900 30,665 34.5 03 4TH OF JULY & CIVIC EVENTS,ETC 4,220 98,445 117,975 19,530 16.6 04 HOLIDAY DECORATIONS 755 16,601 69,227 52,626 76.0 05 BLOOD DONOR PROGRAM 166 1,823 2,800 977 34.9 Totals 9,612 175,104 278,902 103,798 37.2 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 731 56,645 55,390 -1,255 -2.3 51 EMPLOYEE BENEFITS 190 6,122 9,367 3,245 34.6 54 CONTRACTUAL SERVICES 7,606 104,459 184,245 79,786 43.3 55 UTILITIES 0 0 400 400 100.0 57 COMMODITIES & SUPPLIES 1,085 7,878 22,500 14,622 65.0 59 OTHER EXPENDITURES 0 0 7,000 7,000 100.0 Totals 9,612 175,104 278,902 103,798 37.2 SOURCE OF FUNDS 001 GENERAL FUND 9,612 175,104 278,902 103,798 37.2 Totals 9,612 175,104 278,902 103,798 37.2 18 . 10/14/2004 09,15:12 FRRDBROl SUM 031 9 Months ( 3 Months ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 09/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 426,105 0 18,663 0 5,548 184,492 711 Totals 635,519 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 706 0 0 0 396,345 2,514 184,492 27,957 23,505 Totals 635,519 SOURCE OF FUNDS 050 060 510 520 525 526 527 MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT CAPITAL IMPROVEMENT FUND 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 CONST FUND FLOOD CONTROL CONST FUND PARKING SYSTEM REVENUE FUND VEHICLE REPLACEMENT FUND COMPUTER REPLACEMENT FUND RISK MANAGEMENT FUND 1,448 0 33,931 0 0 391,629 0 0 530 550 560 590 630 670 680 690 18,663 4,100 0 545 184,492 711 Totals 635,519 19 Y-T-D Expended 7,003,345 167,239 1,572,407 223,534 2,389,501 590,580 125,348 12,071,954 229,684 0 117,976 27,390 6,455,488 540,016 590,580 35,695 4,075,125 12,071,954 0 1,217,803 0 350,017 0 0 6,820,567 0 0 1,278,425 1,465,680 223,534 0 590,580 125,348 0 12,071,954 2004 Budget 75.0% ) Completed 25.0% ) 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 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 -381,014 84,396 577,782 463,210 1,441,884 524,720 21,802 2,732,780 188,441 0 337,766 0 -460,633 33,218 524,720 -34,303 2,143,571 2,732,780 684,020 0 562,094 0 100,000 -1,034,167 0 0 546,076 735,570 463,210 129,455 524,720 21,802 0 2,732,780 -5.8 33.5 26.9 67.5 37.6 47.0 14.8 18.5 45.1 74.1 -7.7 5.8 47.0 ****.* 34.5 18.5 36.0 61.6 100.0 -17.9 29.9 33.4 67.5 100.0 47.0 14.8 18.5 10/14/2004 9 Months ( 75.0% ) Completed 09:15:12 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0%) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/04 - 09/30/04 Cur Mo Y-T-D 2004 Unexpended Unexpended DEBT SERVICE Expended Expended Budget Balance Percent PROGRAM TOTALS 02 DEBT SERVICE - PROPERTY TAXES 300 425,183 2,019,966 1,594,783 79.0 03 DEBT SERVICE - TAX INCREMENT 300 724,838 912,075 187,237 20.5 04 DEBT SERVICE - H/R SALES TAX 1 0 410,327 1,499,168 1,088,841 72.6 05 DEBT SERVICE - H/R SALES TAX 2 0 25,200 1,496,000 1,470,800 98.3 06 SPECIAL SERVICE AREA B & I 0 2,748 40,495 37,747 93.2 Totals 600 1,588,296 5,967,704 4,379,408 73.4 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 0 0 0 0 59 OTHER EXPENDITURES 0 0 0 0 71 BOND PRINCIPAL 0 701, 964 4,507,069 3,805,105 84.4 72 INTEREST EXPENSE 0 882,582 1,452,835 570,253 39.3 73 BANK AND FISCAL FEES 600 3,750 7,800 4,050 51. 9 80 INTERFUND TRANSFERS 0 0 0 0 81 OTHER FINANCING USES 0 0 0 0 Totals 600 1,588,296 5,967,704 4,379,408 73.4 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 0 103,889 387,778 283,889 73.2 190 SERIES 2003 B&I, VILLAGE HALL 300 238,416 916,232 677,816 74.0 200 SERIES 2002B B&I, PUBLIC BLDGS 0 16,878 649,956 633,078 97.4 230 SERIES 2002A B&I, TIF 0 1,450 53,800 52,350 97.3 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 B&I, TIF 300 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 0 13,040 216,080 203,040 94.0 350 SERIES 1998A B&I, FLOOD 0 5,126 65,252 60,126 92.1 360 SERIES 1998C B&I, TIF 0 14,888 149,775 134,887 90.1 380 IEPA FLOOD CONTROL LOANS B&I 0 326,322 613,357 287,035 46.8 390 SERIES 2000 B&I, FLOOD CONTROL 0 56,349 112,098 55,749 49.7 400 SERIES 2002B B&I, FLOOD 0 9,490 492,381 482,891 98.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. 0 17,887 895,775 877,888 98.0 440 SERIES 2002B B&I, STREET IMP. 0 7,313 600,225 592,912 98.8 810 SSA #1 PROSPECT MEADOWS B&I 0 0 0 0 830 SSA #6 GEORGE/ALBERT B&I 0 2,748 40,495 37,747 93.2 20 , 10/14/2004 09:15:12 FRRDBROl SUM 033 DEBT SERVICE 9 Months ( 75.0%) Completed VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0%) Remaining Department Budget Expenditure Summary 01/01/04 - 09/30/04 Totals Cur Me Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 600 1,588,296 5,967,704 4,379,408 73.4 21 10/14/2004 9 Months ( 75.0%) Completed 09:15:12 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0%) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/04 09/30/04 Cur Mo Y-T-D 2004 Unexpended Unexpended RETIREE PENSIONS Expended Expended Budget Balance Percent PROGRAM TOTALS 01 MISCELLANEOUS PENSIONS 4,481 40,329 53,714 13,385 24.9 02 POLICE PENSIONS 190,433 1,582,978 2,226,120 643,142 28.9 03 FIRE PENSIONS 182,851 1,608,060 2,267,030 658,970 29.1 Totals 377,765 3,231,367 4,546,864 1,315,497 28.9 EXPENDITURE CLASSIFICATION 53 PENSION BENEFITS 377,765 3,230,276 4,544,714 1,314,438 28.9 54 CONTRACTUAL SERVICES 0 1,091 1,950 859 44.1 57 COMMODITIES & SUPPLIES 0 0 200 200 100.0 65 OFFICE EQUIPMENT 0 0 0 0 Totals 377,765 3,231,367 4,546,864 1,315,497 28.9 SOURCE OF FUNDS 001 GENERAL FUND 4,481 40,329 53,714 13,385 24.9 710 POLICE PENSION FUND 190,433 1,582,978 2,226,120 643,142 28.9 720 FIRE PENSION FUND 182,851 1,608,060 2,267,030 658,970 29.1 730 BENEFIT TRUST #2 FUND 0 0 0 0 Totals 377,765 3,231,367 4,546,864 1,315,497 28.9 22 . 10/14/2004 09:15:12 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 09/30/04 9 Months ( 3 Months ( 75.0% ) Completed 25.0% ) Remaining Cur Mo Y-T-D 2004 Unexpended Unexpended RISK MANAGEMENT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 CASUALTY & PROPERTY INSURANCE 55,632 1.000,599 1,069,013 68,414 6.4 02 MEDICAL INSURANCE 338,857 2,946,456 4,561,280 1,614,824 35.4 Totals 394,489 3.947,055 5,630,293 1,683,238 29.9 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 56 INSURANCE 0 394,489 11,043 3,936,012 36,000 5,594,293 24,957 1,658,281 69.3 29.6 Totals 394,489 3,947,055 5,630,293 1,683,238 29.9 SOURCE OF FUNDS 690 RISK MANAGEMENT FUND 394,489 3,947,055 5,630,293 1,683,238 29.9 Totals 394,489 3,947,055 5,630,293 1,683,238 29.9 23 10/14/2004 9 Months ( 75.0%) Completed 09:15:12 VILLAGE OF MOUNT PROSPECT 3 Months ( 25.0%) Remaining FRRDBROl SUM 031 Department Budget Expenditure Sununary 01/01/04 - 09/30/04 Cur Mo Y-T-D 2004 Unexpended Unexpended NON-DEPARTMENTAL Expended Expended Budget Balance Percent PROGRAM TOTALS 01 CONTINGENCIES 173,183 654,547 962,730 308,183 32.0 Totals 173,183 654,547 962,730 308,183 32.0 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 0 0 0 0 53 PENSION BENEFITS 0 0 0 0 54 CONTRACTUAL SERVICES 0 0 0 0 59 OTHER EXPENDITURES 0 0 0 0 80 INTERFUND TRANSFERS 173,183 654,547 962,730 308,183 32.0 Totals 173,183 654,547 962,730 308,183 32.0 SOURCE OF FUNDS 001 GENERAL FUND 0 135,000 270,000 135,000 50.0 560 STREET IMPROVEMENT CONST FUND 173,183 519,547 692,730 173,183 25.0 670 VEHICLE REPLACEMENT FUND 0 0 0 0 Totals 173,183 654,547 962,730 308,183 32.0 24 . 10/14/2004 09:15:12 FRRDBROl SUM 031 9 Months ( 3 Months ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 09/30/04 CAPITAL FIXED ASSETS Cur Mo Expended Y-T-D Expended 2004 Budget 75.0% ) Completed 25.0% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS 0 00 CAPITAL FIXED ASSETS 0 0 Totals 0 0 59 EXPENDITURE CLASSIFICATION OTHER EXPENDITURES 0 0 0 Totals 0 910 SOURCE OF FUNDS 0 GENERAL FIXED ASSETS ACCT GP 0 0 Totals 0 25 0 0 0 0 0 0 0 0 0 0 0 10/14/2004 09:15:12 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 09/30/04 9 Months ( 3 Months ( 75.0% ) Completed 25.0% ) 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