Loading...
HomeMy WebLinkAbout3. BILLS & FINANCIALS 7/20/04 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE & . EXPEND ITURE SUMMARIES January 1 - June 30,2004 ., 07/l4/2004 10:49:14 REVENUE BY CLASSIFICATION PROPERTY TAXES OTHER TAXES LICENSES, PERMITS & FEES INTERGOVERMENT REV. CHARGES FOR SERVICE FINES AND FORFEITS INVESTMENT INCOME REIMBURSEMENTS OTHER REVENUE OTHER FINANCING SOURCES Total All Funds REVENUE BY FUND GENERAL FUND REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND SERIES 1987A B&I, PW FACILITY SERIES 199388&1, PUBLIC BLDGS SERIES 2001 B&I, VILLAGE HALL SERIES 2003 8&1, VILLAGE HALL SERIES 2002B B&I, PUBLIC BLDGS SERIES 2002A B&I, TIF SERIES 1993A 3&1, TIF SERIES 19948 B&I, TIF SERIES 1996B 8&1, TIF SERIES 1998B 8&1, T1F SERIES 1999 8&1, TIF SERIES 1992A 8&1, FLOOD SERIES 19938 B&I, FLOOD SERIES 1994A 8&1, FLOOD SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 8&1, FLOOD CONTROL SERIES 2002B B&I, FLOOD SERIES 1994A B&I, STREET IMP. SERIES 1996A B&I, STREET IMP. SERIES 1998A 8&1, STREET IMP. SERIES 20028 B&I, STREET IMP. CAPITAL IMPROVEMENT FUND POLICE & FIRE BLDG CaNST FUND SERIES 2001 PROJECT FUND SERIES 2003 PROJECT FUND VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/04 06/30/04 Cur Mo Received 0 879,395 155,372 1,353,010 1,300,795 49,402 547,682 42,214 232,515 240,683 4,801,068 1,998,212 128,894 161,304 0 64,136 38 45 11 27 o 5,420 235,386 306 29 0 0 0 o 373 0 ° 0 18,497 7,673 82 9,708 13,492 49,564 0 0 59,237 39,732 3,256 0 ° 1,428 1 .......m...".'..~.'."'.....'..mc...~.,..~.'.....'.........'.............m............ Y-T-D Received 5,374,058 4,979,472 2,359,586 5,002,786 7,188,296 255,060 2,174,432 347,285 1,977,945 501,366 30,160,286 13,117,334 1,598,619 683,510 18 177,234 229 33,598 7,637 32,221 0 183,703 471,156 272,361 14,557 o 0 ° 0 266,538 0 0 o 99,788 36,122 49,563 145,014 52,075 236,325 0 0 335,765 234,051 207,197 0 o 14,208 6 Months ( 6 Months ( 2004 Budget 11,453,283 12,378,646 2,814,250 14,903,344 15,373,741 556,500 4,431,950 627,051 4,147,865 1,022,730 67,709,360 31,218,204 3,317,523 1,662,015 10,000 550,450 7,700 12,000 10,100 67,700 0 387,967 942,795 581,500 44,500 0 a 0 0 812,500 0 0 o 206,000 85,100 151,000 107,926 150,250 551,000 o 0 657,591 440,335 452,551 0 0 40,000 50.0% ) Completed 50.0% ) Remaining Unreceived Balance 6,079,225 7,399,174 454,664 9,900,558 8,185,445 301,440 2,257,518 279,766 2,169,920 521,364 37,549,074 18,100,870 1,718,904 978,505 9,982 373,216 7,471 -21,598 2,463 35,479 0 204,264 471,639 309,139 29,943 o 0 ° 0 545,962 o 0 0 106,212 48,978 101,437 -37,088 98,175 314,675 o 0 321,826 206,284 245,354 0 0 25,792 Unreceived Percent 53.1 59.8 16.2 66.4 53.2 54.2 50.9 44.6 52.3 51.0 55.5 58.0 51. 8 58.9 99.8 67.8 97.0 -180.0 24.4 52.4 52.6 50.0 53.2 67.3 67.2 51. 6 57.6 67.2 -34.4 65.3 57.1 48.9 46.8 54.2 64.5 C7/14!2CO" 1C:49:14 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/04 06/30/04 Cur Mo Received Y-TD Received 6 ~1onths ( 6 Months ( 2004 Budget 50.0% ) Completed 50.0% ) Remaining unreceived Balance unreceived Percent 0 0 2002 LIBRARY PROJECT FUND CAPITAL IMPROVEMENT CaNST FUND DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CaNST FUND FLOOD CONTROL CaNST 1998A 856 120,838 0 1,156 579,576 7,064 6,945 106,133 76,490 18,539 443,884 300,035 342,982 0 -296 0 16 0 FLOOD CONTROL CaNST FUND WATER AND SEWER FUND VILLAGE PARKING SYSTEM FUND PARKING SYSTEM REVENUE FUND VEHICLE MAINTENANCE FUND VEHICLE REPLACEMENT FUND COMPUTER REPLACEMENT F~~D RISK ~~AGEMENT FUND POLICE PENSION FUND FIRE PENSION FUND BENEFIT TRUST #2 FUND ESCROW DEPOSIT F~~D SSA #1 PROSPECT MEADOWS B&I SSA #6 GEORGE/ALBERT B&I SERIES 2002 LIBRARY BND ESCROW Total All Funds 4,801,068 2 0 0 146,026 688,406 0 7,689 3,717,454 39,833 37,922 623,393 458,551 112,132 2,546,512 1,781,880 1,717,971 0 13,380 314 30,160,286 0 0 0 0 440,077 1,500,165 0 0 0 15,000 8,246,940 135,650 241,655 1,228,529 1,045,548 227,906 5,269,830 3,431,674 3,428,691 0 0 0 30,988 0 67,709,360 294,051 811,759 0 7,311 4,529,486 95,817 203,733 605,136 586,997 115,774 2,723,318 1,649,794 1,710,720 0 0 0 17,608 -314 37,549,074 66.8 54.1 48.7 54. ;3 70.6 84.3 49.3 56.1 50.8 51. 7 48.1 49.9 56.8 55.5 . 07 i14/2004 10:49,52 FRRBRRO3 SUM on 6 Months ( 6 Months ( 50.0% ) Completed 50.0% ) Remaining Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund 01/01/04 06/30/04 Summary 40 41 42 43 44 45 46 Cur Me Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent o 3,837,761 8,164,528 4,326,767 53.0 567,817 2,136,342 5,921,639 3,785,297 63.9 149,581 2,160,342 2,581,250 420,908 16.3 1,129,060 4,166,490 12,535,274 8,368,784 66.8 52,846 339,138 806,863 467,725 58.0 49,402 214,083 527,000 312,917 59.4 4,901 35,093 230,000 194,907 84.7 41,855 153,974 316,650 162,676 51.4 2,750 74,111 135,000 60,889 45.1 1,998,212 13,117,334 31,218,204 18,100,870 58.0 GENERAL FUND PROPERTY TAXES OTHER TAXES LICENSES, PERMITS & FEES INTERGOVERMENT REV. CHARGES FOR SERVICE FINES AND FORFEITS INVESTMENT INCOME 47 REIMBURSEMENTS OTHER REVENUE 48 TOTAL GENERAL FUND REFUSE DISPOSAL FUND 40 44 46 48 PROPERTY TAXES CHARGES FOR SERVICE INVESTMENT INCOME OTHER REVENUE 0 1,061,213 2,278,223 1,217,010 53.4 126,932 523,165 1,009,300 486,135 48.2 1,962 13,727 30,000 16,273 54.2 0 514 0 -514 128,894 1,598,619 3,317,523 1,718,904 51.8 TOTAL REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND 43 46 47 INTERGOVERMENT REV. INVESTMENT INCOME REIMBURSEMENTS 159,814 669,128 1,630,765 961,637 59.0 1,490 9,803 30,000 20,197 67.3 0 4,579 1,250 -3,329 -266.3 161,304 683,510 1,662,015 978,505 58.9 TOTAL MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT 43 46 INTERGOVERMENT REV. INVESTMENT INCOME 0 0 0 18 10,000 0 10,000 -18 100.0 TOTAL LAW ENFORCEMENT BLOCK GRANT 0 18 10,000 9,982 99.8 COMMUNITY DEVELPMNT BLOCK GRNT 43 46 48 INTERGOVERMENT REV. INVESTMENT INCOME OTHER REVENUE 64, 136 167,168 485,450 318,282 65.6 0 1 0 -1 0 10,065 65,000 54,935 84.5 64,136 177,234 550,450 373,216 67.8 TOTAL COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND 45 46 FINES AND FORFEITS INVESTMENT INCOME 0 38 8 221 7,500 200 7,492 -21 99.9 -10.5 TOTAL ASSET SEIZURE FUND 38 229 7,700 7,471 97.0 DEA SHARED FUNDS FUND 45 46 FINES AND FORFEITS INVESTMENT INCOME 0 45 33,365 233 12,000 0 -21,365 -233 -178.0 1 .....n.._n..m.'...........:.:.:.,.",."".:.:..............~.-.-...'.........'.,.m.w.w.......w._n.._.. 07/14í2004 10,49:52 FRRBRRO3 SUM 021 6 Months ( 6 Months ( 50.0% ) Completed 50.0% ) Remaining Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund 01/01/04 06/30/04 Summary Cur r.¡o Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent 45 33,598 12,000 -21,598 -180.0 TOTAL DEA SHARED FUNDS FUND DUI FINE FUND 45 46 FINES AND FORFEITS INVESTMENT INCOME 0 11 7,604 33 10,000 100 2,396 67 24.0 67.0 TOTAL DUI FINE FUND 11 7,637 10,100 2,463 24.4 SERIES 1987A B&I, PW FACILITY 40 46 PROPERTY TAXES INVESTMENT INCOME 0 27 32,116 105 67,500 35,384 95 52.4 47.5 200 TOTAL SERIES 1987A B.d, PW FACILITY 27 32,221 67,700 35,479 52.4 SERIES 19938 B&I, PUBLIC BLDGS 40 PROPERTY 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, PUBLIC BLDGS SERIES 2001 3&1, VILLAGE HALL 40 46 49 PROPERTY TAXES INVESTMENT INCOME 0 172,559 366,032 193,473 52.9 61 426 500 74 14.8 5,359 10,718 21,435 10,717 50.0 5,420 183,703 387,967 204,264 52.6 OTHER FINANCING SOURCES TOTAL SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE R~LL 40 46 49 PROPERTY TAXES I~~ESTMENT INCOME OTHER FINfu~CING SOURCES 0 0 0 0 62 508 1,500 992 66.1 235,324 470,648 941,295 470,647 50.0 235,386 471,156 942,795 471,639 50.0 TOTAL SERIES 2003 B&:1. VILLAGE HALL SERIES 2002B 8&1, PUBLIC BLDGS 40 PROPERTY TAXES 46 49 INVESTMENT INCOME O~HER FINANCING SOURCES 0 270,409 577,000 306,591 53.1 306 1,952 4,500 2,548 56.6 0 0 0 0 306 272,361 581,500 309,139 53.2 TOTAL SERIES 2002B B&:I, PUBLIC BLDGS SERIES 2002A B&I, TIF 41 46 OTHER TAXES INVESTMENT INCOME OTHER FINANCING SOURCES 0 14,314 44,000 29,686 67.5 29 243 500 257 51. 4 0 0 0 0 29 14,557 44,500 29,943 67.3 49 TOTAL SERIES 2002A B&:I, TIF 2 . 07 i14/2004 10,49,52 FRRBRRO3 SUM 021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/04 - 06/30/04 6 Months ( 6 Months ( 50.0% ) Completed 50.0% ) Remaining Cur Mo Received Y-T-D Received 2004 Budget Unreceived Bala!1ce Unreceived Percent SERIES 1993A B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 (} 0 TOTAL SERIES 1993A 8&1, TIP' SERIES 19948 B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 0 0 0 0 0 0 0 0 TOTAL SERIES 19948 B&I, TIP' 0 0 0 0 SERIES 1996B B&I, TIP 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL SERIES 1996B B&1, TIP' SERIES 1998B 8&1, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 0 0 0 0 0 0 0 0 TOTAL SERIES 1998B B&1, TIF 0 0 0 0 SERIES 1999 8&1, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 0 263,181 809,000 545,819 67.5 373 3,357 3,500 143 4.1 0 0 0 0 373 266,538 812,500 545,962 67.2 TOTAL SERIES 1999 BU, TIP' SERIES 1992A 8&1, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 0 0 0 0 0 0 0 0 TOTAL SERIES 1992A 8&I, FLOOD 0 0 0 0 SERIES 19938 8&1, 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 19938 8&:1, FLOOD SERIES 1994A 3&1, FLOOD 41 OTHER TAXES INVESTMENT INCOME OTHER FINANCING SOURCES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 46 49 TOTAL SERIES 1994A B&1, FLOOD 3 07í14í200'; 10,49:52 FRRBRRO3 SUM 021 6 ManthE! ( 6 Months ( 50.0% ) Completed 50.0% ) Remaining Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund 01/01/04 06/30/04 Summary Cur 140 Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent 18,440 99,461 205,000 105,519 51. 5 57 307 1,000 693 69.3 13.497 99,788 20G,OOO 106,212 51.6 SERIES 1996A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD 41 46 OTHER TAXES INVESTMENT INCOME 7,646 36,022 85,000 48,978 57.6 27 100 100 0 0 0 0 0 7.673 36.122 85,100 48.978 5706 49 OTHER FINANCING SOURCES TOTAL SERIES 1998A 8&1, FLOOD SERIES 1998C B&I, TIF 41 46 OTHER TAXES INVESTMENT INCOME 0 82 48,797 766 150,000 1,000 101,203 234 67.5 23 .4 TOTAL SERIES 1998C B&I, TIP 82 49,563 151,000 101,437 6702 IEPA FLOOD CONTROL LOANS B&1 9,708 o 144,917 97 107,926 0 -36,991 -97 -34.3 41 46 OTHER TAXES INVESTMENT INCOME TOTAL IEPA FLOOD CONTROL LOANS B&I 9,708 145,014 107.926 -37,088 -34 .4 SERIES 2000 B&I, FLOOD CONTROL 41 OTHER TAXES 46 49 INVESTMENT INCOME OTHER FINANCING SOURCES 13,492 51,989 150,000 98, all 65.3 0 86 250 164 65.6 0 0 0 0 13,492 52,075 150.250 98,175 6503 TOTAL SERIES 2000 8&1, FLOOD CONTROL SERIES 2002B B&I, FLOOD 41 46 49 OTHER TAXES INVESTMENT INCOME OTHER FINANCING SOURCES 49,472 235,815 550,000 314,185 57.1 92 510 1,000 490 49.0 0 0 0 0 49.564 236,325 551.000 314,675 5701 TOTAL SERIES 20028 B&I, FLOOD SERIES 1994A B&I, STREET IMP. 41 46 49 OTHER TAXES INVESTMENT INCOME OTHER FINANCING SOURCES 0 0 0 0 0 0 0 0 0 ° 0 0 0 0 0 0 TOTAL SERIES 1994A 8&1, STREET IMPo SERIES 1996A B&I, STREET IMP. 41 46 OTHER TÞ"XES INVESTMENT INCOME 0 0 0 C 0 0 0 0 TOTAL SERIES 1996A B&I, STREET IMP. ° ° 0 ° 4 0 07/.;.4/2004 10:49:52 FRRBRRO3 SUM 021 6 Months ( 6 Months ( 50.0% ) Completed 50.0% } Remaining Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund 01/01/04 06/30/04 Summary Cur Mo Received Y-T-D Received 2004 Budget Unreceived Balance Unreceived Percent SERIES 1998A B&I, STREET IMP. TOTAL SERIES 199811. 13&:I. STREET IMP. 41 46 49 OTHER TAXES INVESTMENT INCOME OTHER FINANCING SOURCES 59,150 334,863 657,591 322,728 87 902 0 -902 0 0 0 0 59,237 335,765 657,591 321,826 48.9 49.1 SERIES 2002B 8&1, STREET IMP. 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL SERIES 200213 13&I. STREET IMP. 39,608 233,363 440,335 206,972 124 688 0 -688 0 0 0 0 39,732 234,051 440,335 206,284 46.8 47.0 CAPITAL IMPROVEMENT FL~D 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 0 0 112,400 112,400 100.0 1,766 11,452 20,000 8,548 42.7 0 162,105 239,151 77,046 32.2 1,490 13,640 81,000 67,360 83.2 0 20,000 0 -20,000 3,256 207,197 452,551 245,354 54.2 TOTAL CAPITAL IMPROVEMENT FUND POLICE & FIRE BLDG CONST FUND 46 INVESTMENT INCOME 0 0 0 0 TOTAL POLICE I< FIRE BLDG CONST FUND 0 0 0 0 SERIES 2001 PROJECT FL~D 46 49 0 0 INVESTMENT INCOME OTHER FINANCING SOURCES 0 0 0 0 0 0 TOTAL SERIES 2001 PROJECT FUND 0 0 0 0 SERIES 2003 PROJECT FUND 46 49 INVESTMENT INCOME OTHER FINANCING SOURCES 1,428 0 14,208 0 40,000 0 25,792 0 64.5 TOTAL SERIES 2003 PROJECT FUND 1,428 14,208 40,000 25,792 6405 2002 LIBRARY PROJECT FUND 46 48 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 INVESTMENT INCOME OTHER REVENUE OTHER FINANCING SOURCES 49 TOTAL 2002 LIBRARY PROJECT FUND CAPITAL IMPROVEMENT CaNST FUND 43 46 0 0 INTERGOVERMENT REV. INVESTMENT INCOME 0 0 a 0 0 0 TOTAL CAPITAL IMPROVEMENT CONST FUND 0 0 0 0 5 ..."~.-.W.....c...c.'...m..........'......~... 07/14/200' 10:49:52 FRRBRRO3 SUM 021 6 Months ( 6 Months ( 50.0% ) Comple'::ed 50.0% ) Remaining Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund 01/01/04 06/30/04 Summary Cur Mo Received Y-T-D Received 2004 Budget unreceived Balance Unreceived Percent DOWNTOWN REDEVLPMNT CONST 67.5 -75.7 41 OTHER TAXES 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 0 142,513 438,077 295,564 856 3,513 2,000 -1,513 0 0 0 0 0 0 ° 0 C 0 ° 0 856 146,026 440,077 294,051 66.8 TOTAL DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CONST FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 46 INVESTMENT INCOl'!E 48 OTHER REVENUE 114,061 481,575 1,252,165 770,590 61.5 5,791 199,244 228,000 28,756 12.6 986 7,587 20,000 12,413 62.1 0 0 0 0 120,838 688,406 1,500.165 811,759 54.1 TOTAL STREET IMPROVEMENT CONST FUND 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 43 OTHER TAXES INTERGOVERMENT REV. 0 0 0 0 0 0 0 0 1,156 7,689 15,000 7,311 o 0 Q 0 0 0 0 0 1,156 7,689 15,000 7,311 48.7 46 47 49 INVESTMENT INCOME REHIBURSEMENTS 48.7 OTHER FINANCING SOURCES TOTAL FLOOD CONTROL CaNST FUND WATER AND SEWER FUND 41 OTHER TAXES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 0 743,022 1,537,025 794,003 51. 7 574,248 2,946,639 6,624,915 3,678,276 55.5 3,370 22,688 70,000 47,312 67.6 0 0 0 0 1,958 5,105 15,000 9,895 66.0 0 0 0 0 579,576 3,717,454 8,246,940 4,529,486 54.9 TOTAL WATER AND SEWER FUND VILLAGE PARKING SYSTEM FUND 42 44 LICENSES, PERMITS & FEES CHARGES FOR SERVICE INVESTMENT INCOME 0 0 5,000 5,000 100.0 7,060 39,815 119,850 80,035 66.8 4 18 10,800 10,782 99.8 7,064 39,833 1.35,650 95,817 70.6 46 TOTAL VILLAGE PARKING SYSTEM FUND PARKING SYSTEM REVENUE FUND 42 LICENSES, PERMITS & FEES INTERGOVERMENT REV. CHARGES FOR SERVICE 0 0 6,646 0 0 0 129,455 105,000 0 129,455 68,838 100.0 65.6 43 44 36,162 6 . 07/14/2004 10,49:52 FRRBRRO3 SUM 021 6 Months ( 6 Months ( 50.0% ) Completed 50.0% ) Remaining Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund 01/01/04 06/30/04 Summ.ary 46 Cur Me Y-T-D 2004 Unreceived Unreceived Received Received Budget Balance Percent 299 1,760 7,200 5,440 75.6 0 0 0 0 0 0 0 0 6,945 37,922 241,655 203,733 84.3 48 49 INVESTMENT INCOME OTHER REVENUE OTHER FINANCING SOURCES TOTAL PARKING SYSTEM REVENUE FUND VEHICLE MAINTENANCE FUND 44 46 48 CHARGES FOR SERVICE INVESTMENT INCOME 103,048 618,290 1,221,029 602,739 49.4 3,085 5,103 7,500 2,397 32.0 0 0 0 0 106,133 623,393 1,228,529 605,136 49.3 OTHER REVENUE TOTAL VEHICLE MAINTENANCE FUND VEHICLE REPLACEMENT FUND 44 46 48 49 CHARGES FOR SERVICE INVESTMENT INCOME 67,965 407,774 815,548 407,774 50.0 8,525 50,777 170,000 119,223 70.1 0 0 0 0 0 0 60,000 60,000 100.0 76,490 458,551 1,045,548 586,997 56.1 OTHER REVENUE OTHER FINANCING SOURCES TOTAL VEHICLE REPLACEMENT FUND COMPUTER REPLACEMENT FUND 44 46 50.0 65.2 CHARGES FOR SERVICE INVESTMENT INCOME 17,993 546 107,953 4,179 215,906 12,000 107,953 7,821 TOTAL COMPUTER REPLACEMENT FUND 18,539 112,132 227,906 115,774 50.8 RISK MA.>':AGEMENT FUND 43 INTERGOVERMENT REV. 44 CHARGES FOR SERVICE 46 Il<VESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 0 0 0 0 344,057 2,169,360 4,455,330 2,285,970 51. 3 844 11,155 42,000 30,845 73.4 359 26,627 70,000 43,373 62.0 98,624 339,370 702,500 363,130 51. 7 443,884 2,546,512 5,269,830 2,723,318 51.7 TOTAL RISK MANAGEMENT FUND POLICE PENSION FUND 46 48 I!<VESTMENT INCOME OTHER REVENUE 220,241 79,794 974,720 607,160 1,786,000 1,645,674 811,280 838,514 45.4 51. 0 TOTAL POLICE PENSION FUND 300,035 1,781,S80 3,431,674 ~,649,794 48.1 FIRE PENSION FUND 46 48 INVESTMENT INCOME OTHER REVENUE 295,083 47,899 989,991 727,980 1,925,000 1,503,691 935,009 775,711 48.6 51. 6 TOTAL FIRE PENSION FUND 342,982 1,717,971 3.428,691 1,710,720 49.9 BENEFIT TRUST #2 FUND 46 I~~ESTMENT 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 06/30;04 6 ?4onths ( 6 Months ( 50.0% ) Cc~pleted 50.0% ) Remaining 0i!14!2004 10:49,52 Cur Me Received Y-T.D Received 2004 Budget unreceived Balance unreceived Percent ESCROW DEPOSIT FUND 46 INVESTMENT INCOME -296 0 0 0 TOTAL ESCROW DEPOSIT FUND -296 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&1 0 0 0 0 SSA #6 GEORGE/ALBERT B&I 41 46 OTHER TAXES INvESTMENT INCOME 1 15 13,278 102 30,888 100 17,610 -2 57.0 -2.0 TOTAL SSA #6 GEORGE/ALBERT B&1 16 13,380 30,988 17,608 56.8 SERIES 2002 LIBRARY BND ESCROW 46 INVESTMENT INCOME 0 314 0 -314 TOTAL SERIES 2002 LIBRARY BND ESCROW 0 314 0 -314 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 0 07/14/2004 10:48,18 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/04 06/30/04 6 Months ( 6 Months ( 50.0% ) Completed 50.0% ) Remaining PENSION BENEFITS CONTRACTUAL SERVICES UTILITIES Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 1,807,884 10,021,832 21,233,555 11,211,723 52.8 425,126 3,546,758 7,323,690 3,776,932 51.6 37,192 94,883 272,476 17ï,593 65.2 375,346 2,099,730 4,544, 714 2,444,984 53.8 1,184,583 6,243,213 13,605,533 7,362,320 54.1 34,464 188,213 551,812 363,599 65.9 429,850 3,003,644 6,079,627 3,075,983 50.6 119,003 544, 964 1,076,172 531,208 49.4 34,422 121,961 754,005 632,044 83.8 0 0 27,390 27,390 100.0 1,082,373 4,912,435 5,852,855 940,420 16.1 51,532 151,995 618,458 466,463 75.4 13,318 359,300 1,115,300 756,000 67.8 76,000 193,624 772,385 578,761 74.9 3,500 392,381 1,397,632 1,005,251 71.9 1,421,827 2,926,541 6,684,146 3,757,505 56.2 80,576 232,650 4,608,069 4,375,419 95.0 37,828 750,802 1,452,835 702,033 48.3 1,050 2,850 7,800 4,950 63.5 240,683 481,366 962,730 481,364 50.0 0 0 ° 0 7,456,557 36,269,H2 78,941,184 42,672,042 54.1 EXPENDITURE BY CLASSIFICATION PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS 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 EXPENDITURE BY FUND GENERAL FUND 2,693,368 15,296,688 31,655,480 16,358,792 51. 7 REFUSE DISPOSAL FUND 297,827 1,626,379 3,533,222 1,906,843 54.0 MOTOR FUEL TAX FUND 477,575 978,886 2,461,793 1,482,907 60.2 LAW ENFORCEMENT BLOCK GRANT 0 12,515 12,524 9 0.1 COMMUNITY DEVELPMNT BLOCK GRNT 52,063 167,958 620,305 452,347 72.9 ASSET SEIZURE FUND 0 0 7,000 7,000 100.0 DEA SHARED FUNDS FUND 0 10,430 4,700 -5,730 -121.9 DUI FINE FUND 0 0 3,000 3,000 100.0 SERIES 1987A B&I, PW FACILITY 0 66,000 66,000 0 SERIES 1993B B&I, PUBLIC BLOGS 0 0 0 0 SERIES 2001 B&I, VILLAGE HALL 0 103,889 387,778 283,889 73.2 SERIES 2003 8&1, 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 a 1,450 53,800 52,350 97.3 SERIES 1992B B&I, TIF 0 0 0 o SERIES 1993A 8&I, TIF 0 0 0 o SERIES 1994B B&I, TIF 0 0 0 0 SERIES 1996B 8&1, TIF C 0 0 0 SERIES 1998B B&1, TIF 0 0 0 0 SERIES 1999 8&1, TIP 0 126,750 708,500 581,750 82.1 SERIES 1991A B&I, FLOOD 0 0 0 0 SERIES 1992A B&I, FLOOD 0 0 0 0 SERIES 1993B 8&1, FLOOD 0 0 0 0 SERIES 1994A B&I, FLOOD 0 0 0 0 SERIES 1996A B&I, FLOOD 450 13,040 216,080 203,040 94.0 SERIES 1998A B&I, FLOOD 150 5,126 65,252 60,126 92.1 1 6 ¡'¡onths ( 6 Months ( 07/14/2004 10:4E:18 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/Ql/04 06/30/04 Cur Me Expended Y-T-D Expended 2004 Budget 5000% ) Completed 50.0% ) Remaining Unexpended Balance Unexpended Percent SERIES 1998C B&I, TIF IEFA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD SERIES 1994A B&I, STREET IMPo SERIES 1996A B&I, STREET IMPo SERIES 1998A B&I, STREET IMPo SERIES 2002B B&I, STREET IMP. CAPITAL IMPROVEMENT FUND POLICE & FIRE BLDG CONST FUND SERIES 2001 PROJECT FUND 300 118,404 0 0 0 0 150 0 114,115 0 0 1,068,617 SERIES 2003 PROJECT FUND 2002 LIBRARY PROJECT FUND CAPITAL IMPROVEMENT CONST FUND DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CONST FUND 0 0 428,049 586,107 630 603,112 3,003 31,868 156,311 13,318 50,870 389,405 182,794 188,071 0 FLOOD CONTROL CaNST FUND WATER AND SEWER FUND VILLAGE PARKING SYSTEM FUND PARKING SYSTEM REVENUE FUND VEHICLE MAINTENANCE Fù~D VEHICLE REPLACEMENT FUND COMPUTER REPLACEMENT FUND RISK ~JU~AGEMENT FUND POLICE PENSION FUND FIRE PENSION FUND BENEFIT TRUST #2 FUND SSA #1 PROSPECT MEADOWS B&I SSA #6 GEORGE/ALBERT 8&1 GENERAL FIXED ASSETS ACCT GP Total All Funds 0 7.456.557 14,888 306,678 56,049 9,490 0 0 17,887 7,313 188,579 0 0 4,925,216 0 0 0 0 786,128 1,393,881 202,564 3,653,005 28,837 77,299 614,582 359,300 124,637 2,762,021 1,012,559 1,061,376 0 0 2,748 o 36.269.142 2 149,775 613,357 112,098 492,381 0 0 895,775 600,225 912, lli 0 100,000 5,786,400 0 0 1,824,982 2,893,980 686,744 9,308,159 227,014 262,591 1,277,582 1,115,300 147,150 5,640,293 2,226,120 2,267,030 0 0 40,495 0 78.941.184 134,887 306,679 56,049 482,891 0 0 877,888 592,912 723,532 0 100,000 861,184 o 0 1,038,854 1,500,099 484,180 5,655,154 198,177 185,292 663,000 756,000 22,513 2,878,272 1,213,551 1,205,654 0 0 37,747 0 42. 672. 1:J42 90.1 5000 5000 9801 98.0 9808 7903 10000 14 09 56.9 5108 70.5 6008 8703 7006 5109 6708 1503 5100 5405 5302 93.2 54.1 07/14/2004 10:50,25 FRRDBROl SUM 031 6 Months ( 6 ~1onths ( 50.0% ) Completed 50.0% ) Remaining VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 06/30/04 02 03 Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 7,807 67,635 92,916 25,281 27.2 1,144 7,835 14,958 7,123 47.6 8,95~ 75,470 107,874 32,404 30.0 PROGRAM TOTALS PUBLIC REPRESENTATION MAYOR AND BOARD OF TRUSTEES ADVISORY BOARDS & COMMISSIONS Totals EXPENDITURE CLASSIFICATION 50 51 2,803 17,037 34,370 17,333 50.4 458 2,786 5,648 2,862 50.7 0 0 0 0 5,606 55,062 61,856 6,794 11.0 18 106 500 394 78.8 66 479 5,500 5,021 91. 3 0 a 0 0 8,951 75,470 107,874 32,404 30.0 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES UTILITIES COMMODITIES & SUPPLIES OFFICE EQUIPMENT 52 54 55 57 65 Totals 001 SOURCE OF FUNDS GENERAL FUND 8,951 8,951 75,470 107,874 32,404 30.0 Totals 75,470 107,874 32,404 30.0 1 .....'.....'..................'m"'..'.'~"... 07/14/2 ~O4 10:50:25 FRRDBROl SUM 031 6 Months ( 6 Months ( 50.0% ) Completed 50.0% ) Remaining VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Sunu.uary 01/01/04 - 06/30/04 01 02 03 04 VILLAGE ~~AGER'S OFFICE LEGAL SERVICES PERSONNEL SERVICES Cur Me Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 30,226 199,478 391,807 192,329 49.1 59,905 248,251 340,000 91,749 27.0 20,916 114,155 265,353 151,198 57.0 50,342 305,516 692,715 387,199 55.9 14,105 60,969 144,478 83,509 57.8 175,494 928,369 1,834,353 905,984 49.4 VILLAGE MANAGER'S OFFICE PROGRAM TOTALS INFORMATION TECHNOLOGY PUBLIC INFORÞi~TION 05 Totals EXPENDITURE CLASSIFICATION 50 51 52 54 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS 49,593 328,602 683,850 355,248 51.9 15,546 97,951 197,321 99,370 50.4 5,101 11,107 27,800 16,693 60.0 100,808 474,761 892,752 417,991 46.8 443 1,759 7,580 5,821 76.8 3,632 5,261 10,400 5,139 49.4 371 8,928 14,650 5,722 39.1 0 0 0 0 175,494 928,369 1,834,353 905,984 49.4 55 57 CONTRACTUAL SERVICES UTILITIES COMMODITIES & SUPPLIES OFFICE EQUIPMENT OTHER EQUIPMENT 65 67 Totals SOURCE OF FUNDS 001 GENERAL FUND 175,494 928,369 1,834,353 905,984 49.4 175,494 928,369 1,834,353 905,984 49.4 Totals 2 < 07/14/2004 10050:25 FRRDBROl SUM 031 6 Months ( 6 Months ( 50.0% ) Completed 50.0% ) Remaining VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 06/30/04 02 03 04 Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 17,973 62,083 126,336 64,253 50.9 0 0 0 0 2,864 20,610 43,926 23,316 53.1 20,837 82,693 170,262 87,569 51.4 PROGRAM TOTALS TV SERVICES DIVISION CABLE TV OPERATIONS OTHER SERVICES INTERGOVERNMENTAL PROGRAMMING Totals EXPENDITURE CLASSIFICATION 50 51 6,834 42,682 92,770 50,088 54.0 2,804 17,050 34,920 17,870 51.2 0 535 1,850 1,315 71.1 2,723 10,089 22,397 12,308 55.0 a 0 1,350 1,350 100.0 319 3,457 7,225 3,768 52.2 8,157 8,880 9,750 870 8.9 20,837 82,693 170,262 87,569 51.4 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES UTILITIES COMMODITIES & SUPPLIES OTHER EQUIPMENT 52 54 55 57 67 Totals SOURCE OF FUNDS 001 GENERAL FUND 20,837 82,693 170,262 87,569 51.4 Totals 20,837 82,693 170,262 87,569 51.4 3 .n~m'.m.W"""".....".w."."...".....y...".'."..'. ...""'.W.....".'...wm.'. 07/14/2004 10:50:25 FRRDBROl SUM 031 6 Months ( 6 Months ( 50.0% ) Completed 50.0% ) Remaining VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 06/30/04 VILLAGE CLERK'S OFFICE Cur Me Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 11,226 79,760 163,256 83,496 51.1 11,226 79,760 163,256 83,496 51.1 VILLAGE CLERK'S OFFICE PROGRAM TOTALS 02 Totals EXPENDITURE CLASSIFICATION 50 51 S2 54 55 57 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS 6,873 43,437 90,790 47,353 52.2 2,848 17,422 35,726 18,304 51.2 63 151 1,700 1,549 91.1 1,113 16,572 29,040 12,468 42.9 52 346 1,600 1,254 78.4 277 1,832 4,400 2,568 58.4 11,226 79,760 163,256 83,496 51.~ CONTRACTUAL SERVICES UTILITIES COMMODITIES & SUPPLIES Totals SOURCE OF FUNDS 001 GENERAL FUND 11,226 79,760 163,256 83,496 51.1 79,760 163,256 53,496 51.1 Totals 11.226 4 , 07/14/2004 10:50:25 FRRDBROl SUMO31 6 ~lonths ( 6 Nonths ( 50,.0% ) Completed 50.0% ) Remaining VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 06/30/04 01 02 03 Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 13,988 93,594 202,133 108,539 53.7 31,544 193,249 387,505 194,256 50.1 0 o 0 0 1,132 7,280 12,665 5,385 42.5 30,035 181,449 364,465 163,016 50.2 24,334 172,321 357,712 185,391 51.8 2,363 14,600 43,851 29,251 66.7 103,396 662,493 1,368,331 705,838 51.6 PROGRAM TOTALS FINANCE DEPARTMENT FINANCE ADMINISTRATION ACCOUNTING DATA PROCESSING DUPLICATING SERVICES 04 05 INSURANCE PROGRAMS CUSTOMER SERVICES CASH MANAGEMENT 06 07 Totals EXPENDITURE CLASSIFICATION 50 51 52 54 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES UTILITIES 53,189 340,743 703,910 363,167 51.6 19,782 122,117 248,252 126,135 50.8 64 2,263 4,650 2,387 51.3 3,773 38,175 76,240 38,065 49.9 235 1,380 6,700 5,320 79.4 25,207 151,239 302,479 151,240 50.0 1,146 5,854 23,900 18,046 75.5 0 722 2,200 1,478 67.2 103,396 662,493 1,368,331 705,838 51.6 55 56 57 INSURANCE COMMODITIES & SUPPLIES OFFICE EQUIPMENT 65 Totals SOURCE OF FUNDS ....""'w.....w,."...... 001 GENERAL FUND 103,396 103,396 662,493 1,368,331 705,838 51. 6 Totals 662,493 1,368,331 705,838 51.6 5 .-.o.-..........w.w.'.w.'.'.'.'.'.'..mNNo-.'-"'.- 07/14/2004 10:50,25 FRRDBROl SUM 031 6 Months ( 6 Months ( 50.0% ) Completed 50.0% ) Remaining VILLAGE OF MOUNT PROSPECT Department-Budget Expenditure Summary 01/01/04 - 06/30/04 01 02 03 05 06 07 COMM~~ITY DEVELOPMENT ADMIN PLANNING & ZONING ECONOMIC DEVELOPMENT Cur Me Y-T.D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 14,297 93,036 189,713 96,677 51. 0 12,798 75,658 160,244 84,586 52.8 4,856 31,242 94,879 63,637 67.1 55,960 326,534 717,261 390,727 54.5 23,430 137,377 306,296 168,919 55.1 8,254 52,305 112,134 59,829 53.4 119,595 716,152 1,5aD,527 864,375 54.7 COMMUNITY DEVELOPMENT PROGRAM TOTALS BUILDING INSPECTIONS HOUSING INSPECTIONS HEALTH INSPECTIONS Totals EXPENDITURE CLASSIFICATION 50 51 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES UTILITIES 78,092 473,576 1,016,985 543,409 53.4 29,578 179,126 369,823 190,697 51.6 1.040 7,111 13,166 6,055 46.0 9,222 47,220 138,501 91,281 65.9 827 4,754 24,904 20,150 80.9 836 4,365 17,14 9 12,783 74.5 0 [) 0 0 119,595 716,152 1,58D,527 864,375 54.7 52 54 55 57 65 COMMODITIES & SUPPLIES OFFICE EQUIPMENT Totals SOURCE OF FUNDS 001 550 GENERAL FUND DOWNTO~~ REDEVLPMNT CaNST 219,595 0 716,152 0 1,580,046 481 863,894 481 54.7 100.0 Totals 119,595 716,152 1,580,527 864,375 54.7 6 , 07/14/2C04 10,50:25 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 06/30/04 6 Months ( 6 Months ( 50.0% ) Completed 50.0% } Remaining FRRDBROI SUM 031 04 CDBG ADMINISTRATION 05 CDBG COMMUNITY PROGRAMS 06 ACCESSIBLTY & NEIGHBRHD IMPRV 07 CDBG RESIDENTIAL REHAB Totals Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 5,084 30,830 67,714 36,884 54.5 12,557 41,453 136,500 95,047 69.6 0 0 140,000 140,000 100.0 34,422 95,675 276,091 180,416 65.3 52,063 167,958 620,305 452,347 72.9 COMMUNITY DEVELOPMENT - CDBG PROGRAM TOTALS EXPENDITURE CLASSIFICATION 50 51 52 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES Totals 3,201 20,416 45,400 24, 984 55.0 1,390 8,486 17,429 8,943 51. 3 46 493 1,075 582 54.1 13,004 42,485 138,915 96,430 69.4 0 403 1,395 992 71.1 34,422 95,675 276,091 180,416 65.3 o 0 75,000 75,000 100.0 0 0 65,000 65,000 100.0 52,063 167,958 620,305 452,347 72.9 54 57 COMMODITIES & SUPPLIES OTHER EXPENDITURES BUILDING IMPROVEMENTS INFRASTRUCTURE 59 64 69 SOURCE OF FUNDS 070 COMMUNITY DEVELPMNT BLOCK GRNT 52,063 167,958 620,305 620,305 452,347 72.9 Totals 52,063 167,958 452,347 72.9 7 ...~.'m.'.'...'mmm.'.'.......' 07/14/2004 10:50,25 FRRDBROl SUMO31 6 Months ( 6 Months ( 50.0% ) Completed 50.0% ) Remaining VILLAGE OF MOUNT PROSPECT Department Budget Expenditure summary 01/01/04 - 06/30/04 01 02 03 HUMAN SERVICES ADMINISTRATION SOCIAL SERVICES NURSING/HEALTH SERVICES SENIOR CTR. LEISURE ACTIVITIES YOUTH ACTIVITIES Cur Mo Y-T-D 2004 Unexpended Unexpended Expended EÀ"Pended Budget Balance Percent 11,787 96,515 2l4, 418 117,903 55.0 21,444 136,410 283,779 147,369 51. 9 10,971 69,635 179,857 110,222 61. 3 3,774 22,548 44,164 21,616 48.9 1,358 9,534 62,649 53,115 84.8 49,334 334,642 784,867 450,225 57.4 PROGRAM TOTALS HUMAN SERVICES 04 05 Totals EXPENDITURE CLASSIFICATION 50 51 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES 32,289 207,709 477,790 270,081 56.5 11,061 68,477 147,120 78,643 53.5 0 779 3,900 3,121 80.0 4,673 50,690 107,302 56,612 52.8 1,045 5,274 9,180 3,906 42.5 266 1,713 38,075 36,362 95.5 o 0 1,500 1,500 100.0 0 0 0 0 49,334 334,642 784,867 450,225 57.4 52 54 55 57 UTILITIES COMMODITIES & SUPPLIES 65 67 OFFICE EQUIPMENT OTHER EQUIPMENT Totals SOURCE OF FUNDS 001 GENERAL FUND 49,334 334,642 784,867 450,225 57.4 49,334 334,642 784,867 450,225 57.4 Totals 8 ~ 07/14/2004 10:50:25 FRRDBROl SUM 031 POLICE 6 Months ( 6 Months ( 50.0% ) Completed 50.0% ) Remaining VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 06/30/04 01 02 03 Cur Me Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 108,855 1,154,750 2,327,595 1,172,845 50.4 655,926 3,480,514 6,922,590 3,442,076 49.7 22,812 107,614 227,489 119,875 52.7 98,897 508,893 1,173,577 664,684 56.6 1,474 13,776 26,750 12,974 48.5 56,585 310,332 642,911 332,579 51. 7 944,549 5,575,879 11,320,912 5,745,033 50.7 PROGRAM TOTALS 04 05 06 POLICE ADMINISTRATION PATROL & TRAFFIC ENFORCEMENT CRIME PREVTN & PUBLIC SERVICES INVESTIGATIVE & JUVENILE PRGM CROSSING GUARDS EQUIPMENT MAINTENANCE Totals EXPENDITURE CLASSIFICATION 50 51 52 54 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES UTILITIES COMMODITIES & SUPPLIES OTHER EXPENDITURES OFFICE EQUIPMENT OTHER EQUIPMENT 686,261 3,550,369 7,301,240 3,750,871 51. 4 118,205 1,220,473 2,521,297 1,300,824 51. 6 19,908 38,296 65,500 27,204 41.5 112,386 690,355 1,260,546 570,191 45.2 2,330 13,612 52,000 38,388 73.8 3,319 31,589 70,905 39,316 55.4 0 0 0 0 291 13,186 13,674 488 3.6 1,849 17,999 35,750 17,751 49.7 944,549 5,515,879 11,320,912 5,145,033 50.7 55 57 59 65 67 Totals SOURCE OF FUNDS 001 060 080 085 086 GENERAL FUND LAW ENFORCEMENT BLOCK GRANT ASSET SEIZURE FUND DEA SHARED FUNDS FL'ND DUI FINE FUND 944,549 5,552,934 11,293,688 5,740,754 50.8 0 12,515 12,524 9 0.1 0 0 7,000 7,000 100.0 0 10,430 4,700 -5,730 -121. 9 0 0 3,000 3,000 100.0 944,549 5,575,879 11,320,912 5,745,033 50.7 Totals 9 "..m,~~.................".,.:.:...w........"'... 07/14/2004 10:50:25 FRRDBROl SUM 031 FIRE PROGRAM TOTALS 6 Months ( 6 ¡VIonths ( 50.0% ) Completed 50.0% ) Remaining VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 06/30/04 01 02 03 FIRE ADMINISTRATION FIRE DEPARTMENT OPERATIONS FIRE TRAINING ACADEMY FIRE PREVENTION Cur Me Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 60,533 873,914 1,929,555 1,055,641 54.7 474,325 2,834,308 5,936,550 3,102,242 52.3 1,150 3,176 13,140 9,964 75.8 32,924 189,096 414,400 225,304 54.4 4,232 25,962 60,100 34,138 56.8 36,664 225,042 433,470 208,428 48.1 0 1,052 10,500 9,448 90.0 1,192 7,387 31,685 24,298 76.7 611,020 4,159.937 8.829.400 4.669.463 52.9 04 05 06 FIRE COMMUNICATIONS EQUIPMENT ¡V~INTENANCE EMERGENCY PREPARDENESS PRGM PAID-ON-CALL PROGRAM 07 08 Totals EXPENDITURE CLASSIFICATION 50 51 52 54 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS 462,723 2,766,134 5,913,390 3,147,256 53.2 93,106 1,059,954 2,198,047 1,138,093 51. 8 6,828 14,231 95,915 81,684 85.2 31,479 214,008 428,628 214,620 50.1 2,398 19,558 42,750 23,182 54.2 9,424 41,621 81,010 39,389 48.6 0 5,647 5,000 -647 -12.9 :) 0 5,000 5,000 100.0 5,062 38,774 59,660 20,886 35.0 611,020 4,159,937 8.829.400 4.669,463 52.9 CONTRACTUAL SERVICES UTILITIES 55 57 64 65 67 COMMODITIES & SUPPLIES BUILDING IMPROVEMENTS OFFICE EQUIPMENT OTHER EQUIPMENT Totals SOURCE OF FUNDS 001 GENERAL FUND 611,020 4,159,937 8,829,400 4,669,463 52.9 Totals 611.020 4.159,937 8.829.400 4,669.463 52.9 10 " 07/14/2004 10:50:25 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 06/30/04 6 Months ( 6 Months ( 50.0% ) Co~pleted 50.0% ) Remaining Totals Cur tolo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Pe:!"cent 82,056 490,487 1,001,751 511,264 51. 0 82,056 490,487 1,001,751 511,264 51.0 PUBLIC WORKS - ADMINISTRATION PROGRAM TOTALS 01 PUBLIC WORKS ADMINSTRATION 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 Totals 16,148 105,646 217,705 112,059 51.5 8,702 53,573 107,427 53,854 50.1 2,690 7,605 23,700 16,095 67.9 52,374 309,220 626,004 316,784 50.6 1,296 8,281 17,955 9,674 53.9 846 5,602 7,400 1,798 24.3 0 0 1,000 1,000 100.0 0 560 560 0 82,056 490,487 1,001,751 511,264 51.0 SOURCE OF FUNDS 001 GENERAL FUND 82,056 490,487 1,001,751 511,264 51. 0 Totals 82,056 490,487 1,001,751 511,264 51.0 11 -....'.....m.w.'.'.'m.'.'.w.......-.-.w... ...".'....'...'.VN.'.'.'.'.....W.-...' 07f:¡4/2004 10,50:25 FRRDBROI SUM 031 6 Months ( 6 Months ( 50.0% ) Completed 50.0% ) Remaining VILLAGE OF MOUNT PROSPECT Department Budget Expendi ture SWllm.ary 01/01/04 06/3G/04 Cür Me Y-T-D 2004 Dnexpended Unexpended PUBLIC WORKS STREETS/SLDGS Expended Expended Budget Balance Percent PROGRAM TOTALS 01 STREET DIVISION ADMINISTRATION 8,257 63,426 154,747 91,321 59.0 02 MAINTENANCE - PUBLIC BUILDINGS 60,446 334,074 692,005 357,931 51. 7 04 STREET MAINTENANCE 25,253 124,052 436,170 312,118 71.6 05 SNOW REMOVAL 9,036 282,431 353,609 71,178 20.1 06 LEAF REMOVAL 8 8 0 -8 07 STORM SEWER & BASIN I"AINT 11,083 62,731 158,969 96,238 60.5 08 MAINTENANCE OF STATE HIGHWAYS 5,225 33,652 64,700 31,048 48.0 09 TRAFFIC SIGN MAINTENANCE 8,344 49,816 l05,417 55,601 52.7 10 VILLAGE PARKING LOT MAINT 3,003 28,837 227,014 198,177 87.3 11 PARKING LOT M.!\1NTENANCE 31,868 77,844 133,136 55,292 41. 5 12 FLOOD CONTROL 166,623 166,623 0 -166,623 Totals 329,146 1,223,494 2,325,767 1,102,273 47.4 EXPENDITURE CLASSIFICATION 50 51 S4 55 56 PERSONAL SERVICES EMPLOYEE BENEFITS CONTRACTUAL SERVICES UTILITIES INSURANCE 148,381 592,206 992,640 400,434 40.3 32,977 160,910 289,642 128,732 44.4 106,784 238,883 518,204 279,321 53.9 4,063 23,328 18,650 -4,678 -25.1 1,063 6,378 12,756 6,378 50.0 32,109 178,502 243,875 65,373 26.8 0 0 0 0 0 344 5,000 4,656 93.1 0 0 0 0 3,769 22,943 245,000 222,057 90.6 329,146 1,223,494 2,325,767 1,102,273 47.4 57 59 64 67 69 COMMODITIES & SUPPLIES OTHER EXPENDITURES BUILDING IMPROVEMENTS OTHER EQUIPMENT INFRASTRUCTURE Totals SOURCE OF FUNDS 001 GENERAL FUND 294,275 1,025,036 1,761,822 736,786 41. B 050 MOTOR FUEL TAX FUND o 91,777 203,795 112,018 55.0 620 VILLAGE PARKING SYSTEM FUND 3,003 28,837 227,014 198,177 87.3 630 PARKING SYSTEM REVENUE FUND 31,868 77,844 133,136 55,292 41. 5 Totals 329,146 1,223,494 2.325.767 1,102,273 47.4 12 " 07/l4/2004 10,50,25 FRRDBROI SUM 031 6 Months ( 6 Months ( 50.0% ) Completed 50.0% ) Remaining VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 06/30/04 PROGRAM TOTALS 01 02 Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 14,178 92,648 195,375 102,727 52.6 40,743 156,919 395,583 238,664 60.3 48,866 280,123 637,665 357,542 56.1 2,555 20,054 41,615 21,561 51. 8 106,342 549,744 1,270,238 720,494 56.7 PUBLIC WORKS - FORESTRY/GRNDS 03 04 FORESTRY DIVISION ADMIN MAINTENANCE OF GROUND FORESTRY PROGRAM PUBLIC GROUNDS BEAUTIFICATION Totals EXPENDITURE CLASSIFICATION 50 51 52 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES COMMODITIES & SUPPLIES 56,846 283,974 631,475 347,501 55.0 16,278 92,876 193,228 100,352 51. 9 0 750 750 0 30,303 153,888 414,105 260,217 62.8 2,915 18,256 24,910 6,654 26.7 0 0 5,770 5,770 100.0 106,342 549,744 1,270,238 720,494 56.7 54 57 67 OTHER EQUIPMENT Totals SOURCE OF FUNDS 001 690 56.4 100.0 GENERAL FUND RISK MANAGEMENT FUND 106,342 0 549,744 0 1,260,238 10,000 710,494 10,000 Totals 106,342 549,744 1,270,238 720,494 56.7 13 ~.......-...................<'.'.'...'.W._._.m..__....... ~--.."..'.........'...'mN.'.'.'.'...'._.--_.. 07/14/2.004 10 :50:25 FRRDBROl SUMan 6 Mo:a.ths ( 6 Months ( 50.0% ) Completed 50.0% ) Remaining VILLAGE OF MOUNT PROSPECT Department Budget Expenditure S1.U111tI.ary 01/01/04 - 06/30;04 01 05 ENGINEERING SERVICES TRAFFIC CNTRL & STREET LGHTNG Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 54,917 298,425 670,588 372,163 55.5 18,644 11.2,551 582,563 470,012 80.7 73,561 410,976 1,253,151 842,175 67.2 PUBLIC WORKS - ENGINEERING PROGRAM TOTALS Totals EXPENDITURE CLASSIFICATION PERSONAL SERVICES EMPLOYEE BENEFITS 43,049 238,503 540,740 302,237 55.9 13,263 77,389 162,834 85,445 52.5 0 3,350 3,450 100 2.9 6,816 31,297 162,007 130,710 80.7 9,085 51,853 211,575 159,722 75.5 1,348 8,584 15,095 6,511 43.1 0 0 500 500 100.0 0 0 1,500 1,500 100.0 0 0 155,450 1.55,450 100.0 73,561 410,976 1,253,151 842,175 67.2 50 51 52 54 OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES UTILITIES 55 57 COMMODITIES & SUPPLIES OFFICE EQUIPMENT OTHER EQUIPMENT INFRÞ.STRUCTURE 65 67 69 Totals SOURCE OF FUNDS GENERAL FUND MOTOR FUEL TAX FUND 72,441 1,120 386,719 24,257 896,976 356,175 510,257 331,918 56.9 93.2 001 050 Totals 73,561 410,976 1,253,151 842,175 67.2 14 07/14/2004 10:50:25 FRRDBROI SUM 031 6 Months ( 6 ~lonths ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 06/30/04 PUBLIC WORKS - WATER/SEWER Cur Me Expended PROGRAM TOTALS 01 02 99,316 13,685 13,288 37,888 51,547 21,389 15,100 44,172 30,772 4,562 271,393 WATER & SEWER DIVISION ADMIN MAINTENANCE OF BUILDINGS MAINTENANCE OF GROUNDS WATER SUPPLY MAINT & REPAIR 03 04 OS 06 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 07 08 09 10 12 Totals 603,112 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 101,818 39,331 1,452 398,404 12,588 13,817 20,437 o 54 55 56 57 59 65 0 11,765 67 68 3,500 0 71 Totals 603,11.2 SOURCE OF FUNDS 610 WATER AND SEWER FUND 603,112 Totals 603,112 15 ...T~...'..~WN.v........c..... --.'."..._._._-c.~.wm.."'.... Y-T-D Expended 61l,981 65,773 31,925 200,538 231,675 128,248 127,233 265,033 128,123 402,574 1,459,902 3,653,005 663,973 247,948 8,037 2,066,089 57,230 82,900 68,174 2,457 4,256 59,560 392,381 0 3,653,005 3,653,005 3,653,005 2004 Budget 1,482,635 160,295 82,664 478,131 846,358 287,706 306,474 530,066 364,271 1,699,359 3,070,000 9,308,159 1,604,690 528,341 26,270 4,776,129 155,123 165,801 168,148 15,172 6,200 363,653 1,397,632 101,000 9,308,159 9,308,159 9,308,159 50.0% ) Completed 50.0% ) Remaining Unexpended Unexpended Balance Percent 870,854 94,522 50,739 277,593 614,683 159,458 179,241 265,033 236,148 1,296,785 1,610,098 5,655,154 940,717 280,393 18,233 2,710,040 97,893 82,901 99,974 12,715 1,944 304,093 1,005,251 101,000 5,655,154 5,655,154 5,655,154 58.7 59.0 61.4 58.1 72.6 55.4 58.5 50.0 64.8 76.3 52.4 60.8 58.6 53.1 69.4 56.7 63.1 50.0 59.5 83.8 31.4 83.6 71.9 100.0 60.8 60.8 60.8 07/14/2004 10:50:25 FRRDBROl SUM 031 6 ¡>1onths ( 6 r"1onths ( 50.0% ) Completed 50.0% ) Remaining VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 06/30/04 REFUSE DISPOSAL PROGRAM REFUSE LEAF REMOVAL PROGRAM Cur Me Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 289,910 1,575,017 3,362,241 1,787,224 53.2 7,917 51,362 170,981 119,619 70.0 297,827 1.626,379 3,533,222 1,906,843 54.0 PUBLIC WORKS - REFUSE DISPOSAL PROGRAM TOTALS 01 02 Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES 12,092 75,472 202,005 126,533 62.6 4,308 26,509 60,718 34,209 56.3 0 175 750 575 76.7 281,045 1,517,126 3,241,561 1,724,435 53.2 24 198 545 347 63.7 358 2,149 4,298 2,149 50.0 0 4,750 23,345 18,595 79.7 297,827 1,626,379 3,533,222 1,906,843 54.0 51 52 54 55 UTILITIES INSURANCE COMMODITIES & SUPPLIES 56 57 Totals SOURCE OF FUNDS 030 REFUSE DISPOSAL FUND 297,827 1,626,379 3,533,222 1,906,843 54.0 54.0 297,827 1,626,379 3,533,222 1,906,643 Totals 16 07i14/2004 10:50,25 FRRDBROl SUM 031 6 Mo!lths ( 6 Months ( 50.0% ) Completed 50.0% ) Remaining VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 06/30/04 01 02 Cur 1<10 Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 11,178 73,149 178,656 105,507 59.1 145,133 541,433 1,098,926 557,493 50.7 156,311 614,582 1,277,582 663,000 51.9 PROGRI\M TOTALS PUBLIC WORKS - VEHICLE MAINT VEHICLE DIVISION ADMINSTRATION VEHICLE MAINTENANCE PROGRAM Totals EXPENDITURE CLASSIFICATION 50 51 47,168 268,190 628,415 360,225 57.3 15,330 92, 712 196,550 103,838 52.8 o 0 2,000 2,000 100.0 5,505 33, 847 71,026 37,179 52.3 60 524 1,000 476 47.6 39,081 159,196 310,741 151,545 48.8 o o 0 0 0 0 500 500 100.0 49,167 60,113 67,350 7,237 10.7 156,311 614,582 1,277,582 663,000 51.9 PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES UTILITIES COMMODITIES & SUPPLIES OTHER EXPENDITL~ES OFFICE EQUIPMENT OTHER EQUIPMENT 52 54 55 57 59 65 67 Totals SOURCE OF FUNDS 660 VEHICLE MAINTENANCE FUND 156,311 614,582 1,277,582 663,000 51.9 Totals 156,311 614,582 1,277,582 663,000 51.9 17 '."".".'.'.W.~.~.~.W.W.W.'.......'... 07/l4/2004 10,50,25 FRRDBROl SUM 031 6 Months ( 6 Months ( 50.0% ) Completed 50.0% ) Remaining VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04- 06/30/04 COMMUNITY GROUPS & MISC 4TH OF JULY & CIVIC EVENTS,ETC Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 4,693 47,124 88,900 41,776 47.0 14,896 28,167 11 7,975 89,808 76.1 2,017 13,796 69,227 55,431 80.1 265 1,279 2,800 1,521 54.3 21,871 90,366 278,902 1.88,536 67.6 COMMUNITY SERVICE PROGRAMS PROGRAM TOTALS 02 03 04 05 HOLIDAY DECORATIONS BLOOD DONOR PROGRAM Totals EXPENDITURE CLASSIFICATION 50 51 54 PERSONAL SERVICES EMPLOYEE BENEFITS CONTRACTUAL SERVICES UTILITIES COMMODITIES & SUPPLIES OTHER EXPENDITURES 524 3,163 55,390 52,227 94.3 159 999 9,367 8,368 89.3 18,206 80,878 184,245 103,367 56.1 0 0 400 400 100.0 2,982 5,326 22,500 17,174 76.3 0 o 7,000 7,000 100.0 21,871 90,366 278,902 188,536 67.6 55 57 59 Totals SOURCE OF FUNDS 001 GENERAL FUND 22,871 90,366 278,902 188,536 67.6 67.6 21,871 90,366 278,902 188,536 Totals 18 07 i14í2004 10:50,25 FRRDBROl SUM 031 6 !'Ianthe ( 6 Months ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 06/30/04 CAPITAL IMPROVEMENT PROJECTS Cur 1'10 Expended PROGRAM TOTALS 01 02 03 VILLAGE IMPROVEMENTS & EQUIP COMMUNITY IMPROVEMENT PROJECTS DOWNTOWN REDEVELOPMENT CONST FLOOD CONTROL PROJECTS STREET IMPROVEMENT PROJECTS 1,082,373 100,359 545,316 630 772,112 13,318 50,870 04 06 09 10 MOTOR EQUIPMENT REPLACEMENT COMPUTER REPLACEMENT Totals 2,564,978 BXPENDITURE CLASSIFICATION 54 55 59 CONTRACTUAL SERVICES UTILITIES OTHER EXPENDITURES 62 64 65 LAND IMPROVEMENTS BUILDING IMPROVEMENTS OFFICE EQUIPMENT MOBILE EQUIPMENT OTHER EQUIPMENT INFRASTRUCTURE 0 1,082,373 50,870 13,318 0 1,418,058 66 67 69 Totals 2,564,978 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 476,455 0 114,115 0 0 1,068,617 0 0 530 550 560 590 630 670 680 690 CAPITAL IMPROVEMENT CONST FUND DOWNTOWN REDEVLPMNT CaNST STREET IMPROVEMENT CONST FUND FLOOD CONTROL CaNST FUND 428,049 412,924 630 0 PARKING SYSTEM REVENUE FUND VEHICLE REPLACEMENT FUND 13,318 50,870 0 COMPUTER REPLACEMENT FUND RISK MANAGEMENT FUND Totals 2,564,978 19 ...'m'.'.'.'.WmN.W.W........ Y-T-D Expended 5,011,052 102,198 976,687 202,564 1,719,808 359,300 124,637 8,496,246 359 0 0 170,434 o 23,829 0 4,906,444 124,903 359,300 7,738 2,903,598 8,496,246 862,852 0 188,579 0 0 4,925,216 0 0 786,128 1,047,515 202,564 - 545 359,300 124,637 0 8,496,246 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 o 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 50.0% ) Completed 50.0% ) Remaining Unexpended Unexpended Balance Percent 1,611,279 149,437 1,173,502 484,180 2,111,577 756,000 22,513 6,308,488 247,691 0 431,913 27,390 861,411 448,331 756,000 220,654 3,315,098 6,308,488 1,038,971 0 723,532 0 100,000 861,184 0 0 1,038,373 1,153,735 484,180 130,000 756,000 22,513 0 6,308,488 24.3 59,4 54.6 70.5 55.1 67.8 15.3 42.6 59.2 94.8 100.0 14.9 78.2 67.8 96.6 53.3 42.6 54.6 79.3 100.0 14 .9 56.9 52.4 70.5 100.4 67.8 15.3 42.6 07/14ì2004 6 Months ( 50.0% ) Completed 10050:25 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0% ) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/04 - 06/30/04 Cur Mo Y-T-D 2004 Unexpended Unexpended DEBT SERVICE Expended Expeáded Budget Balance Percent PROGRAM TOTALS 02 DEBT SERVICE - PROPERTY TAXES 0 424,883 2,019,966 1,595,083 79.0 03 DEBT SERVICE - TAX INCREMENT 30e 143,088 912,075 768,987 84.3 04 DEBT SERVICE - H/R SALES TAX 1 119,004 390,383 1,499,168 1,108,785 74.0 05 DEBT SERVICE - H/R SALES TAX 2 150 25,200 1,496,000 1,470,800 98.3 06 SPECIAL SERVICE AREA 8 & I 0 2,748 40,495 37,747 93.2 Totals 119,454 986,302 5,967,704 4,981,402 83.5 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 0 0 0 0 59 OTHER EXPENDITURES 0 0 0 0 71 BOND PRINCIPAL 80,576 232,650 4,507,069 4,274,419 94.8 72 INTEREST EXPENSE 37,828 750,802 1,452,835 702,033 48.3 73 BANK AND FISCAL FEES 1,050 2,850 7,800 4,950 63.5 80 INTERFUND TRANSFERS 0 0 0 0 81 OTHER FINANCING USES 0 0 0 o Totals 119,454 986,302 5,967,704 4,981,402 83.5 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 0 238,116 916,232 678,116 74.0 200 SERIES 20028 8&1, 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 19928 8&1, TIP 0 0 0 0 250 SERIES 1993A B&I, TIF 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, TIP 0 0 0 0 290 SERIES 1999 8&1, TIF 0 126,750 708,500 581,750 82.1 300 SERIES 1991A B&I, FLOOD 0 0 0 0 310 SERIES 1992A B&I, FLOOD 0 0 0 o 320 SERIES 19938 B&I, FLOOD 0 0 0 0 330 SERIES 1994A B&1, FLOOD 0 0 0 C 340 SERIES 1996A B&I, FLOOD 450 13,040 216,080 203,040 94.0 350 SERIES 1998A B&I, FLOOD 150 5,126 65,252 60,126 92.1 360 SERIES 1998C B&I, TIF 300 14,888 149,775 134,887 90.1 380 IEPA FLOOD CONTROL LOANS B&I 118,404 306,678 613,357 306,679 50.0 390 SERIES 2000 8&1, FLOOD CONTROL 0 56,049 112,098 56 , 049 50.0 400 SERIES 2002B 8&1, 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. 150 17,887 895,775 877,888 98.0 440 SERIES 2002B B&1, STREET IMP. 0 7,313 600,225 592,912 98.8 810 SSA #1 PROSPECT MEADOWS B&I a 0 0 0 830 SSA #6 GEORGE/ALBERT B&I 0 2,748 40,495 37,747 93.2 20 , 07/14/2004 10:50:25 FRRDBROl SUM 033 DEBT SERVICE 6 I'10nths ( VILLAGE OF MOUNT PROSPECT 6 Months ( Department Budget Expenditure Summary 01/01/04 - 06/30/04 50.0% ) Completed 50.0% ) Remaining Cur 1'10 Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 119,454 986,302 5,967,704 4,981,402 83.5 Totals 21 ..--_.~.W.......-........~'..'..'.NNNm.....-...... 07/14/2004 10:50:25 FRRDBROI SUM 031 6 Months ( 6 Months ( 50.0% ) Completed 50.0% ) Remaining VILLAGE. OF MOUNT PROSPECT Department. Budget Expenditure Summary 01/01/04 06/30/04 01 02 03 MISCELLANEOUS PENSIONS POLICE PENSIONS FIRE PENSIONS Cur Me Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 4,481 26,886 53,714 26,828 49.9 182,794 1,012,559 2,226,120 1,213,561 54.5 188,071 1,061,376 2,267,030 1,205,654 53.2 375,346 2,100,821 4,546,864 2,446,043 53.8 RETIREE PENSIONS PROGRAM TOTALS Totals EXPENDITURE CLASSIFICATION 53 PENSION BENEFITS 54 57 65 CONTRACTUAL SERVICES COMMODITIES & SUPPLIES OFFICE EQUIPMENT 375,346 2,099,730 4,544,714 2,444,984 53.8 0 1,091 1,950 859 44.1 0 0 200 200 100.0 0 0 0 0 375,346 2,100,821 4,546,664 2,446,043 53.8 Totals SOURCE OF FUNDS 001 710 GENERAL FUND POLICE PENSION FUND FIRE PENSION FUND BENEFIT TRUST #2 FUND 4,481 26,886 53,714 26,828 49.9 182,794 1,012,559 2,226,120 1,213,561 54.5 188,071 1,061,376 2,267,030 1,205,654 5302 0 0 0 0 375,346 2,100,821 4,546,864 2,446,043 53.8 720 730 Totals 22 , 07/14/2004 10:50:25 FRRDBROl SUM 031 Cur Mo Y-T-D 2004 Unexpended Unexpended Expended Expended Budget Balance Percent 64,989 829,513 1,069,013 239,500 22.4 324,416 1,932,508 4,561,280 2,628,772 57.6 389,405 2.762.021 5.630,293 2.868,272 50.9 6 Months ( 6 Months ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 06/30/04 PROGRAM TOTALS RISK MANAGEMENT 01 02 CASUALTY & PROPERTY INSURANCE MEDICAL INSURANCE Totals 54 56 EXPENDITURE CLASSIFICATION SOURCE OF FUNDS 690 CONTRACTUAL SERVICES INSURANCE 0 389,405 1,043 2,760,978 36,000 5,594,293 Totals 389,405 2,762,021 5,630.293 RISK MANAGEMENT FUND 389,405 2,762,021 5,630,293 Totals 389,405 2,762,021 5,630,293 23 ..,"n~....'.'.'...'.'mm.'.----_. 50.0% ) Completed 50.0% ) Remaining 34,957 2,833,315 97.1 50.6 2,868,272 50.9 2,868,272 50.9 2,868,272 50.9 07/14/2004 ::'0:50:25 FRRDBROI SUM 031 6 Months ( 6 ~1onths ( 50.0% ) Completed 50.0% ) Remaining VILLAGE ..OF .:OO:OUNT PROSPECT Department . Budget. .Expendi cure Summary 01/~1/04 - o6/~G/O4 01 CONTINGENCIES Cur Me Y-T-D Expended Expended 240,683 481,366 240,6133 481,366 2004 Budget Unexpended Unexpended Balance Percent NON-DEPARTMENTAL PROGRAM TOTALS 962,730 481,364 50.0 Totals 962,730 431,364 50.0 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES PENSION BENEFITS 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 240,683 481,366 962,730 481,364 50.0 240,683 481,366 962,730 481,364 50,0 53 54 CONTRACTUAL SERVICES OTHER EXPENDITURES 59 80 INTERFUND TRANSFERS Totals SOURCE OF FUNDS 001 560 670 GENERAL FUND STREET IMPROVEMENT CONST FUND VEHICLE REPLACEMENT FUND 67,500 135,000 270,000 135,000 50.0 173,183 346,366 692,730 346,364 50.0 0 0 0 0 240,683 481,366 962,730 481,364 50.0 Totals 24 , 07/14/2004 ~0:50,25 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 06/30/04 6 Months ( 6 Nonths ( 50.0% ) Completed 50.0% ) Remaining CAPITAL FIXED ASSETS Cur Me 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 ~..'.~.W......"".~.....'mH..'~W.....'.W.'...'.'.'.'...,......,.,......... 07/14Î2004 10:50:25 FRRDBROl SUM 031 6 tJjonths ( 6 Months ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/04 - 06/30/04 MOUNT PROSPECT LIBRARY Cur Mo Expended Y-T-D Expended 2004 Budget 50.0% ) Completed 50.0% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS 100.0 02 LIBRARY SERVICES 0 Totals 0 90 EXPENDITURE CLASSIFICATION SOURCE OF FUNDS 950 COMPONENT UNIT EXPENDITURES 0 Totals 0 MOUNT PROSPECT LIBRARY FUND 0 Totals 0 26 {) 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