Loading...
HomeMy WebLinkAbout3. BILLS & FINANCIALS 9/21/04 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE & EXPEND ITURE SUMMARIES January 1 -- August 31, 2004 09/14/2004 VILLAGE OF MOUNT PROSPECT 8 Months ( 66.6% ) Completed 09:45:57 Budget 4 Months ( 33.3% ) Remaining Revenue Summary 01/01/04 08/31/04 Cur Mo Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent REVENUE BY CLASSIFICATION PROPERTY TAXES 40,390 5,449,110 11,453,283 6,004,173 52.4 OTHER TAXES 839,070 6,047,394 12,378,646 6,331,252 51.1 LICENSES, PERMITS & FEES 41,423 2,501,711 2,814,250 312,539 11.1 INTERGOVERMENT REV. 1,231,288 7,491,000 14,903,344 7,412,344 49.7 CHARGES FOR SERVICE 1,328,142 9,781,969 15,373,741 5,591,772 36.4 FINES AND FORFEITS 42,579 374,720 556,500 181,780 32.7 INVESTMENT INCOME 178,333 2,534,159 4,431,950 1,897,791 42.8 REIMBURSEMENTS 5,340 360,421 627,051 266,630 42.5 OTHER REVENUE 141,543 2,287,312 4,147,865 1,860,553 44.9 OTHER FINANCING SOURCES 0 501,366 1,022,730 521,364 51. 0 Total All Funds 3,848,108 37,329,162 67,709,360 30,380,198 44.9 REVENUE BY FUND GENERAL FUND 1,668,079 16,715,482 31,218,204 14,502,722 46.5 REFUSE DISPOSAL FUND 93,969 1,794,020 3,317,523 1,523,503 45.9 MOTOR FUEL TAX FUND 140,698 949,778 1,662,015 712,237 42.9 LAW ENFORCEMENT BLOCK GRANT 0 18 10,000 9,982 99.8 COMMUNITY DEVELPMNT BLOCK GRNT 141,264 372,739 550,450 177,711 32.3 ASSET SEIZURE FUND 54 331 7,700 7,369 95.7 DEA SHARED FUNDS FUND 44 33,682 12,000 -21,682 -180.7 DUI FINE FUND 23 12,473 10,100 -2,373 -23.5 SERIES 1987A B&I, PW FACILITY 287 32,754 67,700 34,946 51.6 SERIES 1993B B&I, PUBLIC BLDGS 0 0 0 0 SERIES 2001 B&I, VILLAGE HALL 1,191 185,690 387,967 202,277 52.1 SERIES 2003 B&I, VILLAGE HALL 293 471,707 942,795 471,088 50.0 SERIES 2002B B&I, PUBLIC BLDGS 2,088 276,587 581,500 304,913 52.4 SERIES 2002A B&I, TIF 315 14,910 44,500 29,590 66.5 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 5,163 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 18,385 85,155 206,000 120,845 58.7 SERIES 1998A B&I, FLOOD 7,610 35,239 85,100 49,861 58.6 SERIES 1998C 8&I, TIF 1,044 50,710 151,000 100,290 66.4 IEPA FLOOD CONTROL LOANS B&I 9,640 44,681 107,926 63,245 58.6 SERIES 2000 8&I, FLOOD CONTROL 13,399 62,051 150,250 88,199 58.7 SERIES 2002B B&I, FLOOD 49,270 228,022 551,000 322,978 58.6 SERIES 1994A B&I, STREET IMP. 0 0 0 0 SERIES 1996A B&I, STREET IMP. 0 0 0 0 SERIES 1998A 8&I, STREET IMP. 58,832 272,813 657,591 384,778 58.5 SERIES 20028 B&I, STREET IMP. 39,484 182,937 440,335 257,398 58.5 CAPITAL IMPROVEMENT FUND 2,217 211,643 452,551 240,908 53.2 POLICE & FIRE 8LDG CaNST FUND 0 0 0 0 SERIES 2001 PROJECT FUND 0 0 0 0 SERIES 2003 PROJECT FUND -19,881 -4,507 40,000 44,507 111.3 1 09/14/2004 09:45:57 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/04 08/31/04 8 Months ( 4 Months ( 66.6% ) Completed 33.3% ) Remaining Cur Mo Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent 2002 LIBRARY PROJECT FUND 0 0 0 0 CAPITAL IMPROVEMENT CONST FUND 0 0 0 0 DOWNTOWN REDEVLPMNT CONST 2,722 148,747 440,077 291,330 66.2 STREET IMPROVEMENT CONST FUND 109,331 892,762 1,500,165 607,403 40.5 FLOOD CONTROL CONST 1998A 0 0 0 0 FLOOD CONTROL CONST FUND 1,418 10,408 15,000 4,592 30.6 WATER AND SEWER FUND 586,759 4,863,939 8,246,940 3,383,001 41. 0 VILLAGE PARKING SYSTEM FUND 7,137 52,738 135,650 82,912 61.1 PARKING SYSTEM REVENUE FUND 6,712 51,102 241,655 190,553 78.9 VEHICLE MAINTENANCE FUND 99,370 817,000 1,228,529 411,529 33.5 VEHICLE REPLACEMENT FUND 74,679 609,173 1,045,548 436,375 41. 7 COMPUTER REPLACEMENT FUND 18,561 149,184 227,906 78,722 34.5 RISK MANAGEMENT FUND 430,496 3,405,570 5,269,830 1,864,260 35.4 POLICE PENSION FUND 130,838 2,018,391 3,431,674 1,413,283 41.2 FIRE PENSION FUND 146,585 1,995,294 3,428,691 1,433,397 41.8 BENEFIT TRUST #2 FUND 0 0 0 0 ESCROW DEPOSIT FUND 0 0 0 0 SSA #1 PROSPECT MEADOWS B&I 0 0 0 0 SSA #6 GEORGE/ALBERT B&I 32 13,515 30,988 17,473 56.4 SERIES 2002 LIBRARY BND ESCROW 0 315 0 -315 Total All Funds 3,848,108 37,329,162 67,709,360 30,380,198 44.9 2 09/14/2004 8 Months ( 66.6%) Completed 09:46:27 4 Months ( 33.3%) Remaining FRRBRRO3 VILLAGE OF MOUNT PROSPECT SUM 021 Budget Revenue by Category within Fund Summary 01/01/04 08/31/04 Cur Mo Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent GENERAL FUND 40 PROPERTY TAXES 28,816 3,891,349 8,164,528 4,273,179 52.3 41 OTHER TAXES 527,930 3,225,969 5,921,639 2,695,670 45.5 42 LICENSES, PERMITS & FEES 34,529 2,290,854 2,581,250 290,396 11.3 43 INTERGOVERMENT REV. 978,381 6,235,630 12,535,274 6,299,644 50.3 44 CHARGES FOR SERVICE 62,112 458,435 806,863 348,428 43.2 45 FINES AND FORFEITS 42,579 328,943 527,000 198,057 37.6 46 INVESTMENT INCOME -13,958 27,447 230,000 202,553 88.1 47 REIMBURSEMENTS 3,737 162,115 316,650 154,535 48.8 48 OTHER REVENUE 3,953 94,740 135,000 40,260 29.8 TOTAL GENERAL FUND 1,668,079 16,715,482 n,218,204 14,502,722 46.5 REFUSE DISPOSAL FUND 40 PROPERTY TAXES 8,184 1,076,605 2,278,223 1,201,618 52.7 44 CHARGES FOR SERVICE 83,553 698,428 1,009,300 310,872 30.8 46 INVESTMENT INCOME 2,232 18,370 30,000 11,630 38.8 48 OTHER REVENUE 0 617 0 -617 TOTAL REFUSE DISPOSAL FUND 93,969 1,794,020 3,317,523 1,523,503 45.9 MOTOR FUEL TAX FUND 43 INTERGOVERMENT REV. 138,046 928,191 1,630,765 702,574 43.1 46 INVESTMENT INCOME 1,619 12,947 30,000 17,053 56.8 47 REIMBURSEMENTS 1,033 8,640 1,250 -7,390 -591. 2 TOTAL MOTOR FUEL TAX FUND 140,698 949,778 1,662,015 712,237 42.9 LAW ENFORCEMENT BLOCK GRANT 43 INTERGOVERMENT REV. 0 0 10,000 10,000 100.0 46 INVESTMENT INCOME 0 18 0 -18 TOTAL LAW ENFORCEMENT BLOCK GRANT 0 18 10,000 9,982 99.8 COMMUNITY DEVELPMNT BLOCK GRNT 43 INTERGOVERMENT REV. 114,861 327,179 485,450 158,271 32.6 46 INVESTMENT INCOME 0 2 0 -2 48 OTHER REVENUE 26,403 45,558 65,000 19,442 29.9 TOTAL COMMUNITY DEVELPMNT BLOCK GRNT 141,264 372,739 550,450 177,711 32.3 ASSET SEIZURE FUND 45 FINES AND FORFEITS 0 8 7,500 7,492 99.9 46 INVESTMENT INCOME 54 323 200 -123 -61.5 TOTAL ASSET SEIZURE FUND 54 3n 7,700 7,369 95.7 DEA SHARED FUNDS FUND 45 FINES AND FORFEITS 0 33,365 12,000 -21,365 -178.0 46 INVESTMENT INCOME 44 317 0 -317 1 09/14/2004 09:46:27 8 Months ( 4 Months ( 66.6% ) Completed' 33.3% ) Remaining FRRBRRO3 SUM 021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/04 - 08/31/04 Cur Mo Received TOTAL DEA SHARED FUNDS FUND 44 DUI FINE FUND 45 46 FINES AND FORFEITS INVESTMENT INCOME 0 23 TOTAL DUI FINE FUND 23 SERIES 1987A B&I, PW FACILITY 40 PROPERTY TAXES 46 INVESTMENT INCOME 249 38 TOTAL SERIES 1987A B&I, PW FACILITY 287 SERIES 19938 B&I, PUBLIC BLDGS 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL SERIES 1993B B&I, PUBLIC BLDGS SERIES 2001 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 1,098 93 0 TOTAL SERIES 2001 B&I, VILLAGE HALL 1,191 SERIES 2003 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 0 293 0 TOTAL SERIES 2003 B&I, VILLAGE HALL 293 SERIES 2002B B&I, PUBLIC BLDGS 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 2,043 45 TOTAL SERIES 2002B B&I, PUBLIC BLDGS 2,088 SERIES 2002A B&I, TIF 41 46 OTHER TAXES INVESTMENT INCOME OTHER FINANCING SOURCES 336 -21 0 49 TOTAL SERIES 2002A B&I, TIF 315 2 Y-T-D Received 33,682 12,404 69 12,473 32,577 177 32,754 0 0 0 0 174,373 599 10,718 185,690 0 1,059 470,648 471,707 0 274,206 2,381 0 276,587 14,650 260 0 14,910 2004 Budget 12,000 10,000 100 10,100 67,500 200 67,700 0 0 0 0 366,032 500 21,435 387,967 0 1,500 941,295 942,795 577,000 4,500 0 581,500 44,000 500 0 44,500 Unreceived Balance Unreceived Percent -21,682 -180.7 -2,404 31 -2,373 34,923 23 34,946 0 0 0 0 191,659 -99 10,717 202,277 0 441 470,647 471,088 302,794 2,n9 0 304,913 29,350 240 0 29,590 -24.0 31.0 -23.5 51. 7 n.5 51.6 0 0 0 0 52.4 -19.8 50.0 52.1 29.4 50.0 50.0 52.5 47.1 52.4 66.7 48.0 66.5 09/14/2004 09:46:27 FRRBRRO3 SUM 021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/04 - 08/31/04 8 Months ( 4 Months ( 66.6% ) Completed 33.3% ) Remaining SERIES 1993A B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES Cur Mo Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL SERIES 1993A B&I, TIF 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 TOTAL SERIES 1996B B&I, TIF 0 0 0 0 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 6,184 269,365 809,000 539,635 66.7 -1,021 2,744 3,500 756 21.6 0 0 0 0 5,163 272,109 812,500 540,391 66.5 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 46 49 INVESTMENT INCOME OTHER FINANCING SOURCES TOTAL SERIES 1994A B&I, FLOOD 3 09/14/2004 8 Months ( 66.6% ) Completed' 09:46:27 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3% ) Remaining FRRBRRO3 SUM 021 Budget Revenue by Category within Fund Summary 01/01/04 - 08/31/04 Cur Mo Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent SERIES 1996A B&I, FLOOD 41 OTHER TAXES 18,311 84,685 205,000 120,315 58.7 46 INVESTMENT INCOME 74 470 1,000 530 53.0 TOTAL SERIES 1996A B&I, FLOOD 18,385 85,155 206,000 120,845 58.7 SERIES 1998A B&I, FLOOD 41 OTHER TAXES 7,592 35,113 85,000 49,887 58.7 46 INVESTMENT INCOME 18 126 100 -26 -26.0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 1998A B&I, FLOOD 7,610 35,239 85,100 49,861 58.6 SERIES 1998C B&I, TIF 41 OTHER TAXES 1,147 49,944 150,000 100,056 66.7 46 INVESTMENT INCOME -103 766 1,000 234 23.4 TOTAL SERIES 1998C B&I, TIF 1,044 50,710 151,000 100,290 66.4 IEPA FLOOD CONTROL LOANS B&I 41 OTHER TAXES 9,640 44,584 107,926 63,342 58.7 46 INVESTMENT INCOME 0 97 0 -97 TOTAL IEPA FLOOD CONTROL LOANS B&I 9,640 44,681 107,926 63,245 58.6 SERIES 2000 B&I, FLOOD CONTROL 41 OTHER TAXES 13,398 61,965 150,000 88,035 58.7 46 INVESTMENT INCOME 1 86 250 164 65.6 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2000 B&I, FLOOD CONTROL 13,399 62,051 150,250 88,199 58.7 SERIES 2002B B&I, FLOOD 41 OTHER TAXES 49,127 227,203 550,000 322,797 58.7 46 INVESTMENT INCOME 143 819 1,000 181 18.1 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2002B B&I, FLOOD 49,270 228,022 551,000 322,978 58.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 ° 4 09/14/2004 8 Months ( 66.6%) Completed 09:46:27 MOUNT 4 Months ( 33.3% ) Remaining FRRBRRO3 VILLAGE OF PROSPECT SUM 021 Budget Revenue by Category within Fund Summary 01/01/04 08/31/04 Cur Mo Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent SERIES 1998A B&I, STREET IMP. 41 OTHER TAXES 58,737 271,648 657,591 385,943 58.7 46 INVESTMENT INCOME 95 1,165 0 -1,165 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 1998A B&I, STREET IMP. 58,832 272,813 657,591 384,778 58.5 SERIES 2002B B&I, STREET IMP. 41 OTHER TAXES 39,331 181,901 440,335 258,434 58.7 46 INVESTMENT INCOME 153 1,036 0 -1,036 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2002B B&I, STREET IMP. 39,484 182,937 440,335 257,398 58.5 CAPITAL IMPROVEMENT FUND 43 INTERGOVERMENT REV. 0 0 112,400 112,400 100.0 46 INVESTMENT INCOME 2,217 15,898 20,000 4,102 20.5 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,217 211,643 452,551 240,908 53.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 -19,881 -4,507 40,000 44,507 111.3 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2003 PROJECT FUND -19,881 -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 o TOTAL 2002 LIBRARY PROJECT FUND 0 0 0 o CAPITAL IMPROVEMENT CONST FUND 43 INTERGOVERMENT REV. 0 0 0 0 46 INVESTMENT INCOME 0 0 0 0 TOTAL CAPITAL IMPROVEMENT CONST FUND o 0 0 0 5 09/14/2004 09:46:27 FRRBRRO3 SUM 021 8 Months ( 4 Months ( 66.6% ) Completed' 33.3% ) Remaining Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund 01/01/04 08/31/04 Summary Cur Mo Received Y-T-D Received 2004 Budget unreceived Balance unreceived Percent DOWNTOWN REDEVLPMNT CONST 66.7 -44.3 41 46 47 OTHER TAXES INVESTMENT INCOME REIMBURSEMENTS OTHER REVENUE OTHER FINANCING SOURCES 3,349 145,862 438,077 292,215 -627 2,885 2,000 -885 0 0 0 0 0 0 0 0 0 0 0 0 2,722 148,747 440,077 291,330 66.2 48 49 TOTAL DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CONST FUND 41 42 OTHER TAXES LICENSES, PERMITS INVESTMENT INCOME OTHER REVENUE 102,159 672,475 1,252,165 579,690 46.3 6,894 210,857 228,000 17,143 7.5 278 9,430 20,000 10,570 52.9 0 0 0 0 109,331 892,762 1,500,165 607,403 40.5 & FEES 46 48 TOTAL STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST 1998A 46 INVESTMENT INCOME 0 0 0 0 TOTAL FLOOD CONTROL CONST 1998A 0 ° 0 0 FLOOD CONTROL CONST FUND 41 43 OTHER TAXES INTERGOVERMENT REV. INVESTMENT INCOME REIMBURSEMENTS OTHER FINANCING SOURCES 0 0 0 0 0 0 0 0 1,418 10,408 15,000 4,592 0 0 0 0 0 0 0 0 1,418 10,408 15,000 4,592 30.6 30.6 46 47 49 TOTAL FLOOD CONTROL CONST FUND WATER AND SEWER FUND 41 44 46 47 48 49 OTHER TAXES CHARGES FOR SERVICE INVESTMENT INCOME REIMBURSEMENTS OTHER REVENUE 1,829 748,677 1,537,025 788,348 51.3 579,041 4,076,779 6,624,915 2,548,136 38.5 3,883 30,200 70,000 39,800 56.9 0 0 0 0 2,006 8,283 15,000 6,717 44.8 0 0 0 0 586,759 4,863,939 8,246,940 3,383,001 41.0 OTHER FINANCING SOURCES TOTAL WATER AND SEWER FUND VILLAGE PARKING SYSTEM FUND 42 44 46 LICENSES, PERMITS & FEES CHARGES FOR SERVICE INVESTMENT INCOME 0 0 5,000 5,000 100.0 7,124 52,700 119,850 67,150 56.0 13 38 10,800 10,762 99.6 7,137 52,738 135,650 82,912 61.1 TOTAL VILLAGE PARKING SYSTEM FUND PARKING SYSTEM REVENUE FUND 42 43 44 LICENSES, PERMITS & FEES INTERGOVERMENT REV. CHARGES FOR SERVICE 0 0 6,527 0 0 48,997 0 129,455 105,000 0 129,455 56,003 100.0 53.3 6 09/14/2004 8 Months ( 66. 6%- ) Completed 09:46:27 PROSPECT 4 Months ( 33.3% ) Remaining FRRBRRO3 VILLAGE OF MOUNT SUM021 Budget Revenue by Category within Fund Summary 01/01/04 08/31/04 Cur Mo Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent 46 INVESTMENT INCOME 185 2,105 7,200 5,095 70.8 48 OTHER REVENUE 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL PARKING SYSTEM REVENUE FUND 6,712 51,102 241,655 190,553 78.9 VEHICLE MAINTENANCE FUND 44 CHARGES FOR SERVICE 101,752 814,020 1,221,029 407,009 33.3 46 INVESTMENT INCOME -2,382 2,980 7,500 4,520 60.3 48 OTHER REVENUE 0 0 0 0 TOTAL VEHICLE MAINTENANCE FUND 99,370 817,000 1,228,529 411,529 33.5 VEHICLE REPLACEMENT FUND 44 CHARGES FOR SERVICE 67,965 543,699 815,548 271,849 33.3 46 INVESTMENT INCOME 6,714 65,474 170,000 104,526 61. 5 48 OTHER REVENUE 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 60,000 60,000 100.0 TOTAL VEHICLE REPLACEMENT FUND 74,679 609,173 1,045,548 436,375 41.7 COMPUTER REPLACEMENT FUND 44 CHARGES FOR SERVICE 17,993 143,937 215,906 71,969 33.3 46 INVESTMENT INCOME 568 5,247 12,000 6,753 56.3 TOTAL COMPUTER REPLACEMENT FUND 18,561 149,184 227,906 78,722 34.5 RISK MANAGEMENT FUND 43 INTERGOVERMENT REV. 0 0 0 0 44 CHARGES FOR SERVICE 402,075 2,944,974 4,455,330 1,510,356 33.9 46 INVESTMENT INCOME 589 12,459 42,000 29, 541 70.3 47 REIMBURSEMENTS 570 27,561 70,000 42,439 60.6 48 OTHER REVENUE 27,262 420,576 702,500 281,924 40.1 TOTAL RISK MANAGEMENT FUND 430,496 3,405,570 5,269,830 1,864,260 35.4 POLICE PENSION FUND 46 INVESTMENT INCOME 87,453 1,118,505 1,786,000 667,495 37.4 48 OTHER REVENUE 43,385 899,886 1,645,674 745,788 45.3 TOTAL POLICE PENSION FUND 130,838 2,018,391 3,431,674 1,413,283 41.2 FIRE PENSION FUND 46 INVESTMENT INCOME 108,051 1,191,282 1,925,000 733,718 38.1 48 OTHER REVENUE 38,534 804,012 1,503,691 699,679 46.5 TOTAL FIRE PENSION FUND 146,585 1,995,294 3,428,691 1,433,397 41.8 BENEFIT TRUST #2 FUND 46 INVESTMENT INCOME 0 0 0 0 TOTAL BENEFIT TRUST #2 FUND 0 0 0 0 7 FRRBRRO3 SUM 021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/04 08/31/04 8 Months ( 4 Months ( 66.6% ) Completed 33.3% } Remaining 09/14/2004 09:46:27 Cur Mo Received Y-T-D Received 2004 Budget unreceived Balance Unreceived Percent ESCROW DEPOSIT FUND 46 INVESTMENT INCOME 0 0 0 0 TOTAL ESCROW DEPOSIT FUND 0 0 0 0 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 32 13,353 162 30,888 100 17,535 -62 56.8 -62.0 TOTAL SSA #6 GEORGE/ALBERT B&I 32 13,515 30,988 17,473 56.4 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 09/14/2004 VILLAGE OF MOUNT PROSPECT 8 Months ( 66.6% ) Completed 09:45:10 Budget Expenditure 4 Months ( 33.3% ) Remaining Summary 01/01/04 08/31/04 Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent EXPENDITURE BY CLASSIFICATION PERSONAL SERVICES 1,565,352 13,347,939 21,231,055 7,883,116 37.1 EMPLOYEE BENEFITS 422,453 4,395,557 7,323,690 2,928,133 40.0 OTHER EMPLOYEE COSTS 16,113 127,980 272,476 144,496 53.0 PENSION BENEFITS 392,942 2,852,516 4,544,714 1,692,198 37.2 CONTRACTUAL SERVICES 1,144,210 8,508,843 13,608,033 5,099,190 37.5 UTILITIES 65,655 282,083 548,812 266,729 48.6 INSURANCE 446,199 3,865,082 6,079,627 2,214,545 36.4 COMMODITIES & SUPPLIES 108,536 745,246 1,079,172 333,926 30.9 OTHER EXPENDITURES 19,811 269,056 754,005 484,949 64.3 LAND IMPROVEMENTS 27,390 27,390 27,390 0 BUILDING IMPROVEMENTS 850,936 6,110,320 5,852,855 -257,465 -4.4 OFFICE EQUIPMENT 307,803 571,697 618,458 46,761 7.6 MOBILE EQUIPMENT 44,506 406,088 1,115,300 709,212 63.6 OTHER EQUIPMENT 21,526 228,738 772,385 543,647 70.4 DISTRIBUTION SYSTEMS 51,068 531,869 1,397,632 865,763 61.9 INFRASTRUCTURE 636,596 4,174,601 6,684,146 2,509,545 37.5 BOND PRINCIPAL 0 701,964 4,608,069 3,906,105 84.8 INTEREST EXPENSE 0 882,582 1,452,835 570,253 39.3 BANK AND FISCAL FEES 0 3,150 7,800 4,650 59.6 INTERFUND TRANSFERS 0 481,366 962,730 481,364 50.0 OTHER FINANCING USES 0 0 0 0 Total All Funds 6,121,096 48,514,067 78,941,184 30,427,117 38.5 EXPENDITURE BY FUND GENERAL FUND 2,300,147 20,030,283 31,655,480 11,625,197 36.7 REFUSE DISPOSAL FUND 281,657 2,201,688 3,533,222 1,331,534 37.7 MOTOR FUEL TAX FUND 292,912 1,409,855 2,461,793 1,051,938 42.7 LAW ENFORCEMENT BLOCK GRANT 0 12,515 12,524 9 0.1 COMMUNITY DEVELPMNT BLOCK GRNT 27,319 356,364 620,305 263,941 42.6 ASSET SEIZURE FUND 0 0 7,000 7,000 100.0 DEA SHARED FUNDS FUND 7,296 17,726 4,700 -13,026 -277.1 DUI FINE FUND 0 410 3,000 2,590 86.3 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 0 103,889 387,778 283,889 73.2 SERIES 2003 B&I, VILLAGE HALL 0 238,116 916,232 678,116 74.0 SERIES 2002B B&I, PUBLIC BLDGS 0 16,878 649,956 633,078 97.4 SERIES 2002A B&I, TIF 0 1,450 53,800 52,350 97.3 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 0 0 0 0 SERIES 1998B B&I, TIF 0 0 0 0 SERIES 1999 B&I, TIF 0 708,200 708,500 300 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 0 13, 040 216,080 203,040 94.0 SERIES 1998A B&I, FLOOD 0 5,126 65,252 60,126 92.1 1 09/14/2004 09,45:10 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/04 08/31/04 8 Months ( 4 Months ( 66.6% ) Completed 33.3% ) 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. o 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 84,753 316,087 912,111 596,024 65.3 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 1,138,444 6,428,938 5,786,400 -642,538 -11.1 2002 LIBRARY PROJECT FUND 0 0 0 0 CAPITAL IMPROVEMENT CONST FUND 0 0 0 0 DOWNTOWN REDEVLPMNT CONST 13,379 1,259,762 1,824,982 565,220 31. 0 STREET IMPROVEMENT CONST FUND 349,139 1,807,946 2,893,980 1,086,034 37.5 FLOOD CONTROL CONST FUND 2,940 223,534 686,744 463,210 67.5 WATER AND SEWER FUND 640,831 5,020,897 9,308,159 4,287,262 46.1 VILLAGE PARKING SYSTEM FUND 22,324 53,972 227,014 173,042 76.2 PARKING SYSTEM REVENUE FUND 11,014 88,771 262,591 173,820 66.2 VEHICLE MAINTENANCE FUND 100,220 796,571 1,277,582 481,011 37.7 VEHICLE REPLACEMENT FUND 44,506 406,088 1,115,300 709,212 63.6 COMPUTER REPLACEMENT FUND 0 124,637 147,150 22,513 15.3 RISK MANAGEMENT FUND 415,754 3,552,569 5,640,293 2,087,724 37.0 POLICE PENSION FUND 197,953 1,392,547 2,226,120 833,573 37.4 FIRE PENSION FUND 190,508 1,425,211 2,267,030 841,819 37.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 Total All Funds 6,121,096 48,514,067 78,941,184 30,427,117 38.5 2 . 09/14/2004 09:47:00 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 08/31/04 8 Months ( 4 Months ( 66.6% ) Completed 33.3% ) Remaining Cur Mo Y-T-D 2004 Unexpended Unexpended PUBLIC REPRESENTATION Expended Expended Budget Balance Percent PROGRAM TOTALS 02 MAYOR AND BOARD OF TRUSTEES 3,914 77,127 92,916 15,789 17.0 03 ADVISORY BOARDS & COMMISSIONS 1,087 9,894 14,958 5,064 33.9 Totals 5,001 87,021 107,874 20,853 19.3 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT Totals 2,803 22,645 34,370 11,725 34.1 458 3,704 5,648 1,944 34.4 0 339 0 -339 1,432 58,180 61,856 3,676 5.9 200 325 500 175 35.0 108 1,828 5,500 3,672 66.8 0 0 0 0 5,001 87,021 107,874 20,853 19.3 SOURCE OF FUNDS 001 GENERAL FUND 5,001 87,021 107,874 20,853 19.3 Totals 5,001 87,021 107,874 20,853 19.3 1 09/14/2004 8 Months ( 66.6%-) Completed 09:47,00 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3% ) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/04 - 08/31/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 40,257 278,529 391,807 113,278 28.9 02 LEGAL SERVICES 71,322 353,377 340,000 -13,377 -3.9 03 PERSONNEL SERVICES 16,472 147,029 265,353 118,324 44.6 04 INFORMATION TECHNOLOGY 59,206 410,075 692,715 282,640 40.8 05 PUBLIC INFORMATION 5,262 71,382 144,478 73,096 50.6 Totals 192,519 1,260,392 1,834,353 573,961 31.3 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 50,827 431,744 683,850 252,106 36.9 51 EMPLOYEE BENEFITS 15,047 128,505 197,321 68,816 34.9 52 OTHER EMPLOYEE COSTS 1,405 13,989 27,800 13,811 49.7 54 CONTRACTUAL SERVICES 110,714 641,047 892,752 251,705 28.2 55 UTILITIES 1,248 3,247 7,580 4,333 57.2 57 COMMODITIES & SUPPLIES 12,984 26,943 10,400 -16,543 -159.1 65 OFFICE EQUIPMENT 294 14,917 14,650 -267 -1. 8 67 OTHER EQUIPMENT 0 0 0 0 Totals 192,519 1,260,392 1,834,353 573,961 31.3 SOURCE OF FUNDS 001 GENERAL FUND 192,519 1,260,392 1,834,353 573,961 31. 3 Totals 192,519 1,260,392 1,834,353 573,961 31.3 2 . 09/14/2004 09:47:00 FRRDBROl SUM 031 8 Months ( 4 Months ( 66.6% ) Completed 33.3% ) Remaining VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 08/31/04 02 03 04 Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 9,796 80,962 126,336 45,374 35.9 0 0 0 0 2,610 26,030 43,926 17,896 40.7 12,406 106,992 170,262 63,270 37.2 PROGRAM TOTALS TV SERVICES DIVISION CABLE TV OPERATIONS OTHER SERVICES INTERGOVERNMENTAL PROGRAMMING Totals EXPENDITURE CLASSIFICATION 50 51 52 54 55 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES UTILITIES COMMODITIES & SUPPLIES OTHER EQUIPMENT 6,598 56,379 92,770 36,391 39.2 2,735 22,631 34,920 12,289 35.2 0 535 1,850 1,315 71.1 1,648 13,404 22,397 8,993 40.2 1,137 1,137 1,350 213 15.8 288 4,026 7,225 3,199 44.3 0 8,880 9,750 870 8.9 12,406 106,992 170,262 63,270 37.2 57 67 Totals 001 SOURCE OF FUNDS GENERAL FUND 12,406 106,992 170,262 63,270 37.2 Totals 12,406 106,992 170,262 63,270 37.2 3 09/14/2004 09:47:00 FRRDBROl SUM 031 8 Months ( 4 Months ( 66.6% ) Completed 33.3% ) Remaining VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 08/31/04 VILLAGE CLERK'S OFFICE Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 16,726 107,725 163,256 55,531 34.0 16,726 107,725 163,256 55,531 34.0 VILLAGE CLERK'S OFFICE PROGRAM TOTALS 02 Totals EXPENDITURE CLASSIFICATION 50 51 52 54 55 57 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES UTILITIES COMMODITIES & SUPPLIES 6,800 57,038 90,790 33,752 37.2 2,836 23,097 35,726 12,629 35.3 165 785 1,700 915 53.8 5,231 22,536 29,040 6,504 22.4 698 1,104 1,600 496 31.0 996 3,165 4,400 1,235 28.1 16,726 107,725 163,256 55,531 34.0 Totals SOURCE OF FUNDS 001 GENERAL FUND 16,726 107,725 163,256 55,531 34.0 34.0 16,726 107,725 163,256 55,531 Totals 4 . 09/14/2004 09:47:00 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 08/31/04 8 Months ( 4 Months ( 66.6% ) Completed 33.3% ) Remaining Totals Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 15,581 124,836 202,133 77,297 38.2 31,082 255,382 387,505 132,123 34.1 0 0 0 0 861 8,461 12,665 4,204 33.2 30,035 241,726 364,465 122,739 33.7 27,302 224,347 357,712 133,365 37.3 2,363 19,326 43,851 24,525 55.9 107,224 874,078 1,368,331 494,253 36.1 FINANCE DEPARTMENT PROGRAM TOTALS 01 02 FINANCE ADMINISTRATION ACCOUNTING DATA PROCESSING DUPLICATING SERVICES INSURANCE PROGRAMS CUSTOMER SERVICES CASH MANAGEMENT 03 04 05 06 07 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT Totals 52,923 447,246 703,910 256,664 36.5 19,742 161,652 248,252 86,600 34.9 225 3,290 4,650 1,360 29.2 5,193 47,142 76,240 29,098 38.2 2,423 4,037 6,700 2,663 39.7 25,207 201,653 302,479 100,826 33.3 1,511 8,201 23,900 15,699 65.7 0 857 2,200 1,343 61. 0 107,224 874,078 1,368,331 494,253 36.1 SOURCE OF FUNDS 001 GENERAL FUND 107,224 874,078 1,368,331 1,368,331 494,253 36.1 Totals 107,224 874,078 494,253 36.1 5 09/14/2004 09:47:00 FRRDBROl SUM 031 8 Months ( 4 Months ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 08/31/04 COMMUNITY DEVELOPMENT Cur Mo Expended PROGRAM TOTALS 01 02 03 05 06 07 COMMUNITY DEVELOPMENT PLANNING & ZONING ECONOMIC DEVELOPMENT BUILDING INSPECTIONS HOUSING INSPECTIONS HEALTH INSPECTIONS ADMIN 15,200 13,958 4,788 53,843 24,808 8,616 Totals 121,213 EXPENDITURE CLASSIFICATION PERSONAL SERVICES EMPLOYEE BENEFITS 77,972 29,582 600 50 51 52 54 55 57 65 OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES UTILITIES 7,587 4,215 1,257 0 COMMODITIES & SUPPLIES OFFICE EQUIPMENT Totals 121,213 SOURCE OF FUNDS GENERAL FUND DOWNTOWN REDEVLPMNT CONST 121,213 0 001 550 Totals 121,213 Y-T-D Expended 122,958 101,886 40,884 433,807 185,698 69,176 954,409 629,602 238,306 8,175 62,143 10, Oll 6,172 0 954,409 954,409 0 954,409 6 2004 Budget 66.6% ) Completed 33.3% ) Remaining Unexpended Unexpended Balance Percent 189,713 160,244 94,879 717,261 306,296 ll2,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 66,755 58,358 53,995 283,454 120,598 42,958 626,118 387,383 131,517 4,991 76,358 14,893 10,976 0 626,118 625,637 481 626,118 35.2 36.4 56.9 39.5 39.4 38.3 39.6 38.1 35.6 37.9 55.1 59.8 64.0 39.6 39.6 100.0 39.6 09/14/2004 09:47:00 FRRDBROl SUM 031 8 Months ( 4 Months ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 08/31/04 PROGRAM TOTALS COMMUNITY DEVELOPMENT - CDBG Cur Mo Expended 04 05 06 07 CDBG ADMINISTRATION CDBG COMMUNITY PROGRAMS ACCESSIBLTY & NEIGHBRHD CDBG RESIDENTIAL REHAB IMPRV 4,613 1,783 1,112 19,811 Totals 27,319 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 SOURCE OF FUNDS 070 3,201 1,390 0 1,805 0 19,811 1,112 0 Totals 27,319 COMMUNITY DEVELPMNT BLOCK GRNT 27,319 Totals 27,319 7 Y-T-D Expended 40,216 65,043 102,482 148,623 356,364 26,818 11,267 508 66,263 403 148,623 45,186 57,296 356,364 356,364 356,364 2004 Budget 67,714 136,500 140,000 276,091 620,305 45,400 17,429 1,075 138,915 1,395 276,091 75,000 65,000 620,305 620,305 620,305 66.6% ) Completed 33.3% ) Remaining Unexpended Unexpended Balance Percent 27,498 71,457 37,518 127,468 263,941 18,582 6,162 567 72,652 992 127,468 29,814 7,704 263,941 263,941 263,941 40.6 52.3 26.8 46.2 42.6 40.9 35.4 52.7 52.3 71.1 46.2 39.8 11.9 42.6 42.6 42.6 09/14/2004 8 Months ( 66.6%) Completed 09:47:00 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3% ) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/04 08/31/04 Cur Mo Y-T-D 2004 Unexpended Unexpended HUMAN SERVICES Expended Expended Budget Balance Percent PROGRAM TOTALS 01 HUMAN SERVICES ADMINISTRATION 13,826 130,208 214,418 84,210 39.3 02 SOCIAL SERVICES 21,424 180,125 283,779 103,654 36.5 03 NURSING/HEALTH SERVICES 11,723 92,649 179,857 87,208 48.5 04 SENIOR CTR. LEISURE ACTIVITIES 4,010 29,102 44,164 15,062 34.1 05 YOUTH ACTIVITIES 1,358 12,310 62,649 50,339 80.4 Totals 52,341 444,394 784,867 340,473 43.4 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 32,408 273,468 477,790 204,322 42.8 51 EMPLOYEE BENEFITS 11,070 90,687 147,120 56,433 38.4 52 OTHER EMPLOYEE COSTS 0 1,456 3,900 2,444 62.7 54 CONTRACTUAL SERVICES 5,251 66,370 107,302 40,932 38.1 55 UTILITIES 3,030 9,305 9,180 -125 -1.4 57 COMMODITIES & SUPPLIES 582 3,108 38,075 34,967 91. 8 65 OFFICE EQUIPMENT 0 0 1,500 1,500 100.0 67 OTHER EQUIPMENT 0 0 0 0 Totals 52,341 444,394 784,867 340,473 43.4 SOURCE OF FUNDS 001 GENERAL FUND 52,341 444,394 784,867 340,473 43.4 Totals 52,341 444,394 784,867 340,473 43.4 8 09/14/2004 8 Months ( 66.6%) Completed 09:47:00 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3%) Remaining FRRDBROl SUM031 Department Budget Expenditure Summary 01/01/04 08/31/04 Cur Mo Y-T-D 2004 Unexpended Unexpended POLICE Expended Expended Budget Balance Percent PROGRAM TOTALS 01 POLICE ADMINISTRATION 92,780 1,386,235 2,327,595 941,360 40.4 02 PATROL & TRAFFIC ENFORCEMENT 551,734 4,612,206 6,922,590 2,310,384 33.4 03 CRIME PREVTN & PUBLIC SERVICES 18,936 144,958 227,489 82,531 36.3 04 INVESTIGATIVE & JUVENILE PRGM 75,533 665,409 1,173,577 508,168 43.3 05 CROSSING GUARDS 0 13,776 26,750 12,974 48.5 06 EQUIPMENT MAINTENANCE 46,534 406,119 642,911 236,792 36.8 Totals 785,517 7,228,703 11,320,912 4,092,209 36.1 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 535,719 4,716,116 7,301,240 2,585,124 35.4 51 EMPLOYEE BENEFITS 122,517 1,465,470 2,521,297 1,055,827 41. 9 52 OTHER EMPLOYEE COSTS 7,799 51,245 65,500 14,255 21. 8 54 CONTRACTUAL SERVICES 90,106 881,879 1,260,546 378,667 30.0 55 UTILITIES 11,253 27, 204 52,000 24,796 47.7 57 COMMODITIES & SUPPLIES 10,760 47,467 70,905 23,438 33.1 59 OTHER EXPENDITURES 0 0 0 0 65 OFFICE EQUIPMENT 67 13,572 13,674 102 0.7 67 OTHER EQUIPMENT 7,296 25,750 35,750 10,000 28.0 Totals 785,517 7,228,703 11,320,912 4,092,209 36.1 SOURCE OF FUNDS 001 GENERAL FUND 778,221 7,198,052 11,293,688 4,095,636 36.3 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 7,296 17,726 4,700 -13,026 -277.1 086 DUI FINE FUND 0 410 3,000 2,590 86.3 Totals 785,517 7,228,703 11,320,912 4,092,209 36.1 9 09/14/2004 8 Months ( 66.6%) Completed - 09,47:00 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3%) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/04 08/31/04 Cur Mo Y-T-D 2004 Unexpended Unexpended FIRE Expended Expended Budget Balance Percent PROGRAM TOTALS 01 FIRE ADMINISTRATION 62,271 1,006,670 1,929,555 922,885 47.8 02 FIRE DEPARTMENT OPERATIONS 452,735 3,784,086 5,936,550 2,152,464 36.3 03 FIRE TRAINING ACADEMY 1,279 4,568 13,140 8,572 65.2 04 FIRE PREVENTION 31,938 256,869 414,400 157,531 38.0 05 FIRE COMMUNICATIONS 7,648 36,015 60,100 24,085 40.1 06 EQUIPMENT MAINTENANCE 36,778 294,949 433,470 138,521 32.0 07 EMERGENCY PREPARDENESS PRGM 0 1,052 10,500 9,448 90.0 08 PAID-ON-CALL PROGRAM 1,853 11,120 31,685 20,565 64.9 Totals 594,502 5,395,329 8,829,400 3,434,071 38.9 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 438,572 3,693,514 5,913,390 2,219,876 37.5 51 EMPLOYEE BENEFITS 96,481 1,252,681 2,198,047 945,366 43.0 52 OTHER EMPLOYEE COSTS 3,507 23,378 95,915 72,537 75.6 54 CONTRACTUAL SERVICES 34,262 279,930 428,628 148,698 34.7 55 UTILITIES 6,530 28,502 42,750 14,248 33.3 57 COMMODITIES & SUPPLIES 9,075 54,961 81,010 26,049 32.2 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 6,075 56,362 59,660 3,298 5.5 Totals 594,502 5,395,329 8,829,400 3,434,071 38.9 SOURCE OF FUNDS 001 GENERAL FUND 594,502 5,395,329 8,829,400 3,434,071 38.9 Totals 594,502 5,395,329 8,829,400 3,434,071 38.9 10 , 09/14/2004 09:47,00 FRRDBROl SUM 031 8 Months ( 4 Months ( 66.6% ) Completed 33.3% ) Remaining VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 08/31/04 01 PUBLIC WORKS ADMINSTRATION Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 79,940 650,758 1,001,751 350,993 35.0 79,940 650,758 1,001,751 350,993 35.0 PROGRAM TOTALS PUBLIC WORKS - ADMINISTRATION Totals EXPENDITURE CLASSIFICATION 50 51 52 54 55 57 65 67 SOURCE OF FUNDS PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES UTILITIES COMMODITIES & SUPPLIES OFFICE EQUIPMENT OTHER EQUIPMENT 15,871 139,707 217,705 77,998 35.8 8,661 71,111 107,427 36,316 33.8 2,025 10,827 23,700 12,873 54.3 51,733 412,036 626,004 213,968 34.2 1,336 10,403 17,955 7,552 42.1 314 6,114 7,400 1,286 17.4 0 0 1,000 1,000 100.0 0 560 560 0 79,940 650,758 1,001,751 350,993 35.0 Totals 001 GENERAL FUND 79,940 650,758 1,001,751 350,993 35.0 Totals 79,940 650,758 1,001,751 350,993 35.0 11 09/14/2004 09:47:00 FRRDBROl SUM 031 8 Months ( 4 Months ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 08/31/04 PUBLIC WORKS - STREETS/BLDGS Cur Mo Expended PROGRAM TOTALS 01 02 04 05 06 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,254 59,179 74,359 7,923 -7 14,020 07 08 09 10 11 12 1,710 7,915 22,324 11,014 11,000 Totals 217,691 EXPENDITURE CLASSIFICATION 50 51 54 55 56 57 PERSONAL SERVICES EMPLOYEE BENEFITS CONTRACTUAL SERVICES UTILITIES INSURANCE COMMODITIES & SUPPLIES OTHER EXPENDITURES BUILDING IMPROVEMENTS OTHER EQUIPMENT INFRASTRUCTURE 73 , 534 22,428 97,803 607 1,063 19,088 0 0 0 59 64 67 69 3,168 Totals 217,691 SOURCE OF FUNDS 001 050 620 630 GENERAL FUND MOTOR FUEL TAX FUND VILLAGE PARKING SYSTEM FUND PARKING SYSTEM REVENUE FUND 142,753 41,600 22,324 11,014 Totals 217,691 12 Y-T-D Expended 81,988 443,173 261,127 298,902 1 89,591 39,610 67,942 53,972 89,316 177,623 1,603,245 742,485 206,053 346,837 24,408 8,504 210,764 0 344 0 63,850 1,603,245 1,326,580 133,377 53,972 89,316 1,603,245 2004 Budget 66.6% ) Completed 33.3% ) Remaining Unexpended Unexpended Balance Percent 154,747 692,005 436,170 353,609 0 158,969 64,700 105,417 227,014 133,136 0 2,325,767 992,640 289,642 518,204 18,650 12,756 243,875 0 5,000 0 245,000 2,325,767 1,761,822 203,795 227,014 133,136 2,325,767 72,759 248,832 175,043 54,707 -1 69,378 25,090 37,475 173,042 43,820 -177,623 722,522 250,155 83,589 171,367 -5,758 4,252 33,111 0 4,656 0 181,150 722,522 435,242 70,418 173,042 43,820 722,522 47.0 36.0 40.1 15.5 43.6 38.8 35.5 76.2 32.9 31.1 25.2 28.9 33.1 -30.9 33.3 13.6 93.1 73.9 31.1 24.7 34.6 76.2 32.9 31.1 . 09/14/2004 09:47:00 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 08/31/04 8 Months ( 4 Months ( 66.6% ) Completed 33.3% ) Remaini~g Cur Mo Y-T-D 2004 Unexpended Unexpended PUBLIC WORKS - FORESTRY/GRNDS Expended Expended Budget Balance Percent PROGRAM TOTALS 01 FORESTRY DIVISION ADMIN 14,178 123,170 195,375 72,205 37.0 02 MAINTENANCE OF GROUND 43,772 241,589 395,583 153,994 38.9 03 FORESTRY PROGRAM 49,608 373,727 640,665 266,938 41.7 04 PUBLIC GROUNDS BEAUTIFICATION 2,103 24,827 41,615 16,788 40.3 Totals 109,661 763,313 1,273,238 509,925 40.0 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT Totals 52,495 392,474 631,475 239,001 37.8 15,561 124,421 193,228 68,807 35.6 0 750 750 0 40,525 225,197 417,105 191,908 46.0 1,080 20,471 24,910 4,439 17.8 0 0 5,770 5,770 100.0 109,661 763,313 1,273,238 509,925 40.0 SOURCE OF FUNDS 001 690 GENERAL FUND RISK MANAGEMENT FUND 109,661 0 763,313 0 1,263,238 10,000 499,925 10,000 509,925 39.6 100.0 Totals 109,661 763,313 1,273,238 40.0 13 09/14/2004 09:47:00 FRRDBROl SUM 031 8 Months ( 4 Months ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 08/31/04 PUBLIC WORKS - ENGINEERING Cur Mo Expended PROGRAM TOTALS 01 05 ENGINEERING SERVICES TRAFFIC CNTRL & STREET LGHTNG 52,651 39,051 Totals 91,702 EXPENDITURE CLASSIFICATION 50 51 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES UTILITIES COMMODITIES & SUPPLIES OFFICE EQUIPMENT OTHER EQUIPMENT INFRASTRUCTURE 42,266 13,085 0 12,875 21,689 1,787 0 0 0 52 54 55 57 65 67 69 Totals 91,702 SOURCE OF FUNDS 001 050 GENERAL FUND MOTOR FUEL TAX FUND 70,709 20,993 Totals 91,702 14 Y-T-D Expended 407,222 177,801 585,023 324,618 103,806 3,350 52,980 86,031 12,402 0 0 1,836 585,023 524,899 60,124 585,023 2004 Budget 66.6% ) Completed 33.3% ) Remaining Unexpended Unexpended Balance Percent 670,588 579,563 1,250,151 540,740 162,834 3,450 162,007 208,575 15,095 500 1,500 155,450 1,250,151 893,976 356,175 1,250,151 263,366 401,762 665,128 216,122 59,028 100 109,027 122,544 2,693 500 1,500 153,614 665,128 369,077 296,051 665,128 39.3 69.3 53.2 40.0 36.3 2.9 67.3 58.8 17.8 100.0 100.0 98.8 53.2 41. 3 83.1 53.2 09/14/2004 09,47:00 FRRDBROl SUM 031 8 Months ( 4 Months ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 08/31/04 PUBLIC WORKS - WATER/SEWER Cur Mo Expended PROGRAM TOTALS 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 92,277 13,187 9,171 37,799 34,680 23,338 20,909 44,172 04 05 06 07 08 09 10 12 22,599 51,872 290,827 Totals 640,831 EXPENDITURE CLASSIFICATION 50 51 52 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES UTILITIES INSURANCE COMMODITIES & SUPPLIES OTHER EXPENDITURES OFFICE EQUIPMENT OTHER EQUIPMENT DISTRIBUTION SYSTEMS BOND PRINCIPAL 110,730 40,715 312 391,730 11,202 13,817 17,523 0 0 3,734 51,068 0 54 55 56 57 59 65 67 68 71 Totals 640,831 SOURCE OF FUNDS 610 WATER AND SEWER FUND 640,831 Totals 640,831 15 Y-T-D Expended 792,907 88,995 49,503 271,622 312,924 178,550 180,393 353,377 196,340 547,765 2,048,521 5,020,897 879,703 328,402 9,053 2,900,214 75,477 110,534 113,780 2,457 4,494 64,914 531,869 0 5,020,897 5,020,897 5,020,897 2004 Budget 1,482,835 160,295 82,664 478,131 846,358 285,706 308,474 530,066 364,271 1,699,359 3,070,000 9,308,159 1,602,190 528,341 26,270 4,780,629 155,123 165,801 166,148 15,172 6,200 363,653 1,397,632 101,000 9,308,159 9,308,159 9,308,159 66.6% ) Completed 33.3% ) Remaining Unexpended Unexpended Balance Percent 689,928 71,300 33,161 206,509 533,434 107,156 128,081 176,689 167,931 1,151,594 1,021,479 4,287,262 722,487 199,939 17,217 1,880,415 79,646 55,267 52,368 12,715 1,706 298,739 865,763 101,000 4,287,262 4,287,262 4,287,262 46.5 44.5 40.1 43.2 63.0 37.5 41.5 33.3 46.1 67.8 33.3 46.1 45.1 37.8 65.5 39.3 51. 3 33.3 31. 5 83.8 27.5 82.1 61. 9 100.0 46.1 46.1 46.1 09/14/2004 09:47:00 FRRDBROl SUM 031 8 Months ( 4 Months ( 66.6% ) Completed. 33.3% ) Remaining VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 08/31/04 REFUSE DISPOSAL PROGRAM REFUSE LEAF REMOVAL PROGRAM Totals EXPENDITURE CLASSIFICATION 50 51 52 54 55 56 57 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES UTILITIES INSURANCE COMMODITIES & SUPPLIES Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 273,676 2,134,264 3,362,241 1,227,977 36.5 7,981 67,424 170,981 103,557 60.6 281,657 2,201,688 3,533,222 1,331,534 37.7 PUBLIC WORKS - REFUSE DISPOSAL PROGRAM TOTALS 01 02 Totals SOURCE OF FUNDS 030 REFUSE DISPOSAL FUND Totals 11,272 98,369 202,005 103,636 51.3 4,180 34, 91 7 60,718 25,801 42.5 0 175 750 575 76.7 264,329 2,051,052 3,236,561 1,185,509 36.6 25 247 545 298 54.7 358 2,865 4,298 1,433 33.3 1,493 14,063 28,345 14,282 50.4 281,657 2,201,688 3,533,222 1,331,534 37.7 281,657 2,201,688 3,533,222 1,331,534 37.7 281,657 2,201,688 3,533,222 1,331,534 37.7 16 09/14/2004 09:47:00 FRRDBROl SUM 031 8 Months ( 4 Months ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 08/31/04 PROGRAM TOTALS PUBLIC WORKS - VEHICLE MAINT Cur Mo Expended 01 02 VEHICLE DIVISION ADMINSTRATION VEHICLE MAINTENANCE PROGRAM 12,183 88,037 Totals 100,220 EXPENDITURE CLASSIFICATION 50 51 52 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES UTILITIES COMMODITIES & SUPPLIES OTHER EXPENDITURES OFFICE EQUIPMENT OTHER EQUIPMENT 45,958 15,120 75 5,505 62 29,079 0 0 4,421 54 55 57 59 65 67 Totals 100,220 SOURCE OF FUNDS 660 VEHICLE MAINTENANCE FUND 100,220 Totals 100,220 17 Y-T-D Expended 95,667 700,904 796,571 360,098 122,916 125 43,668 645 204,585 0 0 64,534 796,571 796,571 796,571 2004 Budget 178,656 1,098,926 1,277,582 628,415 196,550 2,000 71,026 1,000 310,741 0 500 67,350 1,277,582 1,277,582 1,277,582 66.6% ) Completed 33.3% ) Remaining Unexpended Unexpended Balance Percent 82,989 398,022 481,011 268,317 73,634 1,875 27,358 355 106,156 0 500 2,816 481,011 481,011 481,011 46.5 36.2 37.7 42.7 37.5 93.8 38.5 35.5 34.2 100.0 4.2 37.7 37.7 37.7 09/14/2004 09:47:00 FRRDBROl SUM 031 8 Months ( 4 Months ( 66.6% ) Completed, 33.3% ) Remaining VILLAGE OF MOUNT PR9êPECT Department Budget Expenditure Summary 01/01/04 08/31/04 COMMUNITY GROUPS & MISC 4TH OF JULY & CIVIC EVENTS,ETC HOLIDAY DECORATIONS BLOOD DONOR PROGRAM Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 3,591 53,764 88,900 35,136 39.5 8,176 94,225 117,975 23,750 20.1 517 15,845 69,227 53,382 77.1 166 1,658 2,800 1,142 40.8 12,450 165,492 278,902 113,410 40.7 COMMUNITY SERVICE PROGRAMS PROGRAM TOTALS 02 03 04 05 Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 54 55 57 59 EMPLOYEE BENEFITS CONTRACTUAL SERVICES UTILITIES COMMODITIES & SUPPLIES OTHER EXPENDITURES 5,403 55,915 55,390 -525 -0.9 845 5,931 9,367 3,436 36.7 5,591 96,853 184,245 87,392 47.4 0 0 400 400 100.0 611 6,793 22,500 15,707 69.8 0 0 7,000 7,000 100.0 12,450 165,492 278,902 113,410 40.7 Totals SOURCE OF FUNDS 001 GENERAL FUND 12,450 165,492 278,902 113,410 40.7 113,410 40.7 12,450 165,492 278,902 Totals 18 09/14/2004 09:47:00 FRRDBROl SUM 031 8 Months ( 4 Months ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 08/31/04 CAPITAL IMPROVEMENT PROJECTS Cur Mo Expended PROGRAM TOTALS 01 02 03 04 VILLAGE IMPROVEMENTS & EQUIP COMMUNITY IMPROVEMENT PROJECTS DOWNTOWN REDEVELOPMENT CONST FLOOD CONTROL PROJECTS STREET IMPROVEMENT PROJECTS MOTOR EQUIPMENT REPLACEMENT COMPUTER REPLACEMENT 1,158,156 65,041 13,379 2,940 579,458 44,506 0 06 09 10 Totals 1,863,480 EXPENDITURE CLASSIFICATION 54 55 59 CONTRACTUAL SERVICES UTILITIES OTHER EXPENDITURES LAND IMPROVEMENTS BUILDING IMPROVEMENTS OFFICE EQUIPMENT MOBILE EQUIPMENT OTHER EQUIPMENT INFRASTRUCTURE 890 0 0 27,390 849,824 307,442 44,506 0 633,428 62 64 65 66 67 69 Totals 1,863,480 SOURCE OF FUNDS 050 060 510 520 525 526 527 530 550 560 590 630 670 680 690 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 230,319 0 84,753 0 0 1,138,444 0 0 13,379 349,139 2,940 0 44,506 0 0 Totals 1,863,480 19 Y-T-D Expended 6,577,241 167,239 1,553,744 223,534 2,383,952 406,088 124,637 11,436,435 228,978 0 11 7,976 27,390 6,059,143 537,503 406,088 7,738 4,051,619 11,436,435 1,216,354 0 316,087 0 0 6,428,938 0 0 1,259,762 1,461,580 223,534 -545 406,088 124,637 0 11,436,435 2004 Budget 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,767,855 573,234 1,115,300 228,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 66.6% ) Completed 33.3% ) Remaining Unexpended Unexpended Balance Percent 45,090 84,396 596,445 463,210 1,447,433 709,212 22,513 3,368,299 189,147 0 337,766 0 -291,288 35,731 709,212 220,654 2,167,077 3,368,299 685,469 0 596,024 0 100,000 -642,538 0 0 564,739 739,670 463,210 130,000 709,212 22,513 0 3,368,299 0.7 33.5 27.7 67.5 37.8 63.6 15.3 22.8 45.2 74.1 -5.1 6.2 63.6 96 .6 34.8 22.8 36.0 65.3 100.0 -11.1 31.0 33.6 67.5 100.4 63.6 15.3 22.8 09/14/2004 09:47:00 FRRDBROl SUM 031 8 Months ( 4 Months ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 08/31/04 PROGRAM TOTALS DEBT SERVICE Cur Mo Expended 02 03 04 05 06 DEBT SERVICE - PROPERTY TAXES DEBT SERVICE - TAX INCREMENT DEBT SERVICE - H/R SALES TAX 1 DEBT SERVICE - H/R SALES TAX 2 SPECIAL SERVICE AREA B & I Totals EXPENDITURE CLASSIFICATION 54 59 71 72 73 80 81 CONTRACTUAL SERVICES OTHER EXPENDITURES BOND PRINCIPAL INTEREST EXPENSE BANK AND FISCAL FEES INTERFUND TRANSFERS OTHER FINANCING USES Totals SOURCE OF FUNDS 140 170 180 190 200 230 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 SERIES 1996B B&I, TIF SERIES 1998B B&I, TIF SERIES 1999 B&I, TIF SERIES 1991A B&I, FLOOD 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. SSA #1 PROSPECT MEADOWS B&I SSA #6 GEORGE/ALBERT B&I 240 250 260 270 280 290 300 310 320 330 340 350 360 380 390 400 410 420 430 440 810 830 20 Y-T-D Expended 0 0 0 0 0 424,883 724,538 410,327 25,200 2,748 0 1,587,696 0 0 0 0 0 701,964 882,582 3,150 0 0 0 0 0 0 0 1,587,696 0 0 0 0 0 0 0 0 0 0 0 66,000 0 103,889 238,116 16,878 1,450 0 0 0 0 0 708,200 0 0 0 0 13,040 5,126 14,888 326,322 56,349 9,490 0 0 17,887 7,313 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2,748 2004 Budget 66.6% ) Completed 33.3% ) Remaining Unexpended Unexpended Balance Percent 2,019,966 912,075 1,499,168 1,496,000 40,495 5,967,704 0 0 4,507,069 1,452,835 7,800 0 0 5,967,704 66,000 0 387,778 916,232 649,956 53,800 0 0 0 0 0 708,500 0 0 216,080 65,252 149,775 613,357 112,098 492,381 0 0 895,775 600,225 0 40,495 1,595,083 187,537 1,088,841 1,470,800 37,747 4,380,008 3,805,105 570,253 4,650 0 0 4,380,008 0 0 0 0 283,889 678,116 633,078 52,350 0 0 0 0 0 300 0 0 0 0 203,040 60,126 134,887 287,035 55,749 482,891 0 0 877,888 592,912 0 37,747 79.0 20.6 72.6 98.3 93.2 73.4 0 0 84.4 39.3 59.6 73.4 73.2 74.0 97.4 97.3 94.0 92.1 90.1 46.8 49.7 98.1 98.0 98.8 93.2 . 09/14/2004 09:47:00 FRRDBROl SUM 033 8 Months ( 66.6%) Completed VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3%) Remaining Department Budget Expenditure Summary 01/01/04 - 08/31/04 Totals Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 0 1,587,696 5,967,704 4,380,008 73.4 DEBT SERVICE 21 09/14/2004 09:47:00 FRRDBROl SUM 031 8 Months ( 4 Months ( 66.6% ) Completed 33.3% ) Remaining VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 08/31/04 01 02 03 MISCELLANEOUS PENSIONS POLICE PENSIONS FIRE PENSIONS Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 4,481 35,849 53,714 17,865 33.3 197,953 1,392,547 2,226,120 833,573 37.4 190,508 1,425,211 2,267,030 841,819 37.1 392,942 2,853,607 4,546,864 1,693,257 37.2 RETIREE PENSIONS PROGRAM TOTALS Totals EXPENDITURE CLASSIFICATION 53 54 PENSION BENEFITS CONTRACTUAL SERVICES COMMODITIES & SUPPLIES OFFICE EQUIPMENT 392,942 2,852,516 4,544,714 1,692,198 37.2 0 1,091 1,950 859 44.1 0 0 200 200 100.0 0 0 0 0 392,942 2,853,607 4,546,864 1,693,257 37.2 57 65 Totals SOURCE OF FUNDS 001 710 720 730 GENERAL FUND POLICE PENSION FUND FIRE PENSION FUND BENEFIT TRUST #2 FUND 4,481 35,849 53,714 17,865 33.3 197,953 1,392,547 2,226,120 833,573 37.4 190,508 1,425,211 2,267,030 841,819 37.1 0 0 0 0 392,942 2,853,607 4,546,864 1,693,257 37.2 Totals 22 . 09/14/2004 09:47:00 FRRDBROI SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 08/31/04 8 Months ( 4 Months ( 66.6% ) Completed 33.3% ) Remaining Cur Mo Y-T-D 2004 Unexpended Unexpended RISK MANAGEMENT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 CASUALTY & PROPERTY INSURANCE 78,206 944,967 1,069,013 124,046 11.6 02 MEDICAL INSURANCE 337,548 2,607,602 4,561,280 1,953,678 42.8 Totals 415,754 3,552,569 5,630,293 2,077,724 36.9 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 56 INSURANCE 10,000 405,754 11,043 3,541,526 36,000 5,594,293 24,957 2,052,767 69.3 36.7 Totals 415,754 3,552,569 5,630,293 2,077,724 36.9 SOURCE OF FUNDS 690 RISK MANAGEMENT FUND 415,754 3,552,569 5,630,293 2,077,724 36.9 Totals 415,754 3,552,569 5,630,293 2,077 , 724 36.9 23 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 08/31/04 8 Months ( 4 Months ( 66.6% ) Completed - 33.3% ) Remaining 09/14/2004 09:47:00 Totals Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 0 481,366 962,730 481,364 50.0 0 481,366 962,730 481,364 50.0 NON-DEPARTMENTAL PROGRAM TOTALS 01 CONTINGENCIES EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 53 PENSION BENEFITS 54 CONTRACTUAL SERVICES 59 OTHER EXPENDITURES 80 INTERFUND TRANSFERS 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 481,366 962,730 481,364 50.0 0 481,366 962,730 481,364 50.0 Totals SOURCE OF FUNDS 001 560 670 GENEPAL FUND STREET IMPROVEMENT CONST FUND VEHICLE REPLACEMENT FUND 0 135,000 270,000 135,000 50.0 0 346,366 692,730 346,364 50.0 0 0 0 0 0 481,366 962,730 481,364 50.0 Totals 24 09/14/2004 09:47:00 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 08/31/04 8 Months ( 4 Months ( 66.6% ) Completed 33.3% } Remaining CAPITAL FIXED ASSETS Cur Mo Expended Y-T-D Expended 2004 Budget Unexpended Unexpended 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 09/14/2004 09:47:00 FRRDBROl SUM 031 8 Months ( 4 Months ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 08/31/04 MOUNT PROSPECT LIBRARY Cur Mo Expended Y-T-D Expended 2004 Budget 66.6% ) Completed 33.3% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS 100.0 02 LIBRARY SERVICES Totals 90 EXPENDITURE CLASSIFICATION COMPONENT UNIT EXPENDITURES Totals 950 SOURCE OF FUNDS ..; MOUNT PROSPECT LIBRARY FUND Totals 0 0 0 0 0 0 26 0 23,641,875 0 23,641,875 0 23,641,875 0 23,641,875 0 23,641,875 0 23,641,875 23,641,875 23,641,875 23,641,875 23,641,875 23,641,875 23,641,875 100.0 100.0 100.0 100.0 100.0