Loading...
HomeMy WebLinkAbout3. FINANCIAL REPORT AND BILLS 05/18/2010 INTEROFFICE MEMORANDUM Mount Prospect Village of Mount Prospect Mount Prospect, Illinois TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM: FINANCE DIRECTOR DATE: MAY 14, 2010 SUBJECT: MONTHLY FINANCIAL REPORT - APRIL 2010 Attached hereto are the cash position and investment statements of the Village for the month ended April 30, 2010. These statements provide a snapshot of the Village's cash position as of the month end date noted and are intended to supplement the budget revenue and expenditure summary and listing of bills you receive. The first statement presents the Village's cash position broken down by governmental and enterprise funds and trust and agency funds. The second statement presents the Village's cash position by fund type. The third statement presents the list of investments again broken down by governmental and enterprise funds and trust and agency funds. It is important to note that although we have included the trust and agency funds in the cash position report, these are not funds accessible for Village operations. They are restricted for pension and escrow funding only. Please read the summary that follows for further detail on the cash position of the Village. Cash and Investment Position Report - All Funds (paae 1) This report provides a detailed summary of cash and investments for the Village broken out by governmental and enterprise funds and trust and agency funds. Governmental funds include the General Fund, Special Revenue Funds, Debt Service Funds, Capital Project Funds and Internal Service Funds. The Enterprise Funds consist of the Water and Sewer Fund and two (2) Parking Funds. Trust funds include the Village's two public safety pensions (Police and Firefighters') while the agency funds include the Escrow Deposit, Flexcomp Escrow, Special Service Area and Library Bonds Escrow Funds. The Escrow Deposit Fund accounts for refundable deposits held by the Village to ensure completion of public improvements. The Flexcomp Escrow Fund accounts for employee payroll deductions pursuant to a Section 125 flexible compensation plan. The Special Service Area Fund and Library Bonds Escrow Fund account for the accumulation of monies for debt service payments. Governmental and Enterprise Funds - Cash and cash equivalents at March 31 were $31.6 million. During April, cash receipts totaled $4,188,895.02. In addition investment income for the month was $5,790.47. Reductions to cash and cash equivalents during April totaled $4,336,188.82. Of this amount, payments to vendors were $3,080,205.10, employee payroll and related expenses were $1,251,345.32 and other disbursements were $4,638.40. There was also a net increase in cash from interfund activity of $5,051.94. Cash and cash equivalents at April 30 were $31.5 million. There were no funds held in investments during the month of April. Funds were held in cash money market accounts that currently earn competitive rates of interest. Monthly Financial Report - April 2010 May 14, 2010 Page 2 Total cash and investments for Governmental and Enterprise Funds at March 31 were $31,606,005.25. Cash and investments at April 30 totaled $31,469,553.86. This is a decrease of $136,451.39 for the month. Trust and Agency Funds - Cash and cash equivalents at March 31 were $7.0 million. During April, cash receipts totaled $591,212.71. In addition investment income for the month was $78,038.04 and outflows due to interfund activity totaled $5,051.94. There was also a net increase in cash due to investment activities of $783,500.40. Reductions to cash and cash equivalents during April totaled $714,609.81. Of this amount, payments to vendors were $239,347.49 employee payroll and related expenses were $437,215.35, and payments related to the flexible spending program totaled $38,046.97. In addition, other receipts totaling $46,887 were recorded during the month the result of a single large voided check of $47,500. Cash and cash equivalents at April 30 were $7.8 million. Total investments at April 30 were $78,074,604.81, a decrease of $444,760.93 from March 31. There were investment income of $338,739.47 and a net transfer out totaling $783,500.40 that accounted for the change. Total cash and investments for Trust and Agency Funds at March 31 were $85,560,210.48. Cash and investments at April 30 totaled $85,895,425.95. This is an increase of $335,215.47 from the prior month. Summary of Cash Activity by Fund Type (paQe 2) This report provides a breakdown of the cash activity for the month broken down by fund type. This breakdown is useful in identifying where the activity (receipts and disbursements) is occurring. There are times during the year when activity in certain funds such as the capital improvement and special revenue funds is higher than normal. This will distort the financial picture of some of the other components of the governmental funds such as the General Fund which tends to be more level and predictable in terms of spending and receipt of revenue. Each month the report will provide further explanation on the activity of the General Fund, the Village's primary operating fund. The report will also provide additional information on fund types that experienced higher than normal activity for the month. Activity for the General Fund is highlighted below. General Fund - Cash and cash equivalents at March 31 totaled $6,001 ,934.37. During April, cash receipts totaled $2,807,579.73 and investment income was $3,592.80. Significant cash receipts included sales taxes, telecommunication taxes and vehicle sticker fees. Sales tax revenues for the month totaled $819,454. Of this amount, $746,394 was generated from the 1 % state portion while $73,060 was generated from the .25% home rule portion. Sales taxes received in April are for January sales. There is a normal three-month lag in getting this distribution from the state. Telecommunication tax receipts for April reflect January activity. Total receipts during April were $281,860 and exceeded prior year receipts by 5.7%. Vehicle stickers went on sale February 1 for the 2010-2011 license period. Total receipts for April were $514,337. The total budget for this line item is $1,405,000. We are at 78.2% of the total budget. Monthly Financial Report - April 2010 May 14, 2010 Page 3 Disbursements from the General Fund for April included payments to vendors of $1,132,081.57, payments for employee wages and benefits of $1,002,657.61 and other disbursements of $4,638.40. Interfund transfers of $413,178.94 for health premiums and vehicle lease and maintenance payments were also made during the month. Cash and cash equivalents at April 30 were $6,260,550.38. There were no investments in the General Fund at April 30. Statement of Investments (paae 3) This report provides a breakdown of investments by governmental and enterprise funds and trust and agency funds. The report also provides a fund-by fund breakdown of the investments. Government and Enterprise Funds - Investments for the governmental and agency funds are typically made up of Certificates of Deposit. At April 30 there were no CD's placed at any bank. This is due to the extremely low interest rates being offered. Money instead has been placed in interest bearing money market accounts Trust and Agency Funds - The investments for the trust and agency funds are made up of certificates of deposits, fixed income investments and equity mutual funds. CD's (if any) held in the Escrow Deposit Fund will generally have maturities of between 30 and 120 days. Most of the reserves for this fund are invested in the more liquid money market account due to the nature of the deposit. Escrow refunds are processed two times per month. Investments for the Police and Firefighter Pension Funds consist of various fixed income securities as well as equity mutual fund accounts. Wells Fargo is the third-party holder of the fixed income securities. The funds are managed by three investment management firms, Capital Gains, Segall Bryant and Mesirow Financial. Segall Bryant holds approximately half of the fixed income investments for the two pension funds while Capital Gains and Mesirow manage the balance of fixed income investments for these two funds. Each manager maintains a small portion of their portfolio in cash to help facilitate liquidity and trading. Investments in equities consist of mutual funds spread across various sectors (small, mid and large- cap stocks) as well as investment philosophies (value, core and growth). The pension funds also have a small portion of their portfolio invested in international stocks. Each year the investment mix is evaluated for optimal diversification to meet the pension funds investment policy goals and objectives. Below is a breakdown of how the pension fund portfolios are invested. Monthly Financial Report - April 2010 May 14, 2010 Page 4 Maturity Date Purchase Financial Date Institution Investment CUSIPI Interest Description Acct# Rate % Wells Fargo Investments Various Various Mutual Fund Investments Various Various Market Value POLICE PENSION FUND (710) Various Various Wells Fargo Various Various Various 19,575,704.02 19,447,761.56 39,023,465.58 FIRE PENSION FUND (720) Various Various Wells Fargo Various Various Various Wells Fargo Investments Mutual Fund Investments Various Various Various Various 20,405,946.04 18,645, I 93. I 9 39,051,139.23 $ 78,074,604.81 TOTAL TRUST AND AGENCY FUND INVESTMENTS Investment of the Village's pension funds is governed by an Investment Policy adopted by each Pension Board. The policy was last amended in 2007 and is currently being under review. Conclusion As mentioned earlier, this cash position report is intended to provide a snapshot of the Village's cash position as of a particular month end date. Over time, this report will be able to provide trend information to help in cash management duties, maximizing investment earnings while ensuring availability of funds to meet the Village's ongoing commitments. d~o, ~ David O. Erb Finance Director VILLAGE OF MOUNT PROSPECT Preliminary Cash and Investment Position Report - All Funds For the Month Ended April 30, 2010 GOVERNMENTAL AND ENTERPRISE FUNDS Cash and Cash Equivalents Investments Balance at March 31, 2010 $ 31,606,005.25 $ Cash receipts 4,188,895.02 Investment income 5,790.47 Transfers from investments to cash Transfers to investments from cash Interfund activity 5,051.94 Disbursements: Accounts payable (3,080,205.10) Payroll (1,251,345.32) Other (4,638.40) Balance at April 30, 2010 $ 31,469,553.86 $ Total Cash and Investments $ 31,606,005.25 4,188,895.02 5,790.47 5,051.94 (3,080,205.10) (1,251,345.32) (4,638.40) $ 31,469,553.86 TRUST AND AGENCY FUNDS * Cash and Cash Total Cash and Equivalents Investments Investments Balance at March 31, 2010 $ 7,040,844.74 $ 78,519,365.74 $ 85,560,210.48 Cash receipts 591,212.71 591,212.71 Investment income (loss) 78,038.04 338,739.47 416,777.51 Transfers from investments to cash 3,000,665.68 (3,000,665.68) Transfers to investments from cash (2,217,165.28) 2,217,165.28 Interfund activity (5,051.94) (5,051.94) Disbursements: Accounts payable (239,347.49) (239,347.49) Payroll (437,215.35) (437,215.35) Flex spending (38,046.97) (38,046.97) Other ** 46,887.00 46,887.00 Balance at April 30, 2010 $ 7,820,821.14 $ 78,074,604.81 $ 85,895,425.95 * Assets are restricted in purpose and do not represent discretionary assets of the government. ** Includes prior month accounts payable check voided in the current period 1 ..... o W 0.. f/) o 0:: 0.. ..... Z ~ o :E II.. o w 5 ....I :> <Il !;;o .....~ -g~ "0 u..", 1I~ ~<( ~al <(-g .r:W "'.r: 01_ oe ....0 o~ 2:-<Il 0I.r: E-::: E 0 "u.. f/) . m o Z ~ U. >- o Z W ~ o Z <( ..... m ~ 0:: ..... .....>- ~o o::Zm .....wo o::C)Z w<(~ :c0u. .....Z 0<( o m ZWZ <(00 W:JU; o::OZ -o..W U. 0.. o z <(W .C/) !>D:C/) 00..0 ,n 0:: Z '-'W~ -l.....u. ~Z OW ..... C/) o Z ~ u.. W m D: c.. 0:: W ..... Z W o Z <( -l ~ Z W ~ Z 0:: W > o C) -lC/) <(.....m .....UO -WZ 0..""::J 5~u. c.. -lW <(~C/) -ZO OWZ W>~ c..Wu. mo:: -l ~ o ..... mM~coroSor:::-r::-m O>...IOIONOIOO>IOIO ai~cxilt"ilt"idcxicOdN ~...~18~-~~~:2 ~- 0 ri 8- ,.: N lXi lXi oj coCX) r v('f')CO~ ... ON -10'" oo..f MN ~ri '" - - <09 ~;Us cxicxir-: ;:1;~ riri ~-~ <09 1.0 f'--CO co co NOIOION g~~~~ v""'OtO-- ":":lXio": :2:rr-...8N <6 rit:!: <09 ION... NO"<t It"ilt"id 80>0> "'... ~g<6 10... r~ '" <09 C/) o -lZ <(::J Zu. O::w Wo !z5 -0:: W m ~:gs; d"':ai :2~~ ..,f,.: NO "<t... o ~ <09 <tOt:" ~ I I fJ:!~~ r CC! '-""'<0 (t) 8~~ ~ ~~~ ~ - ~ ~~, ~'" 10'" 010 uf:;t. to N ai 0> "<t ,.: "<t 10 ~ It"i '" "<t ri ~ CD o C'"i '" '" ~ ~s ~~I ...'" ~ 10 ri "<t- ~- f/) ~ ~ '6 01 ..... e ,.. Z <Il 01 W .'!l 0. C- ....I e "'.'!l ~ ~~ ...~'55 :5 <Il'gl~ ~.~~@ g8 E>'" 0=0.01 e S.SQ) 1111 ~.!!!(/)t:E.~ E~~~ c(~a.=.g.s Q)Cl)Q)Q) o ~.8 5i ~ e!"O ~ ~ ~ ~ aI.2!.5~.!C~~~~ ~'~-5 ~ ~ ~~.E.5.5.5 W m D:m c..0 o::Z W::J .....u. Z W 10"'''' ~O>N ~ol"'i '" ... 000 ci~ "<t1O 0>... ..,f <09 "<too... N"'O> cxiooiai 00"'''' oo...~ r-: N .-- "'N "<tN cD <09 W u 5m 0::0 Wz m::J liiu.. W o ......N "<tLO~ ~cxici ...10... "'N NO 100> "!. <09 ~lOoo ...oo"<t gif2~1 oo"'N lXiai 0>0 "<tN N <09 o Z ::J U. -l ~ W Z W (9 "''''0 "''''00 ooiaiN "''''0> 0> 10 to ~ r---- cti 00 000 cDN <09 o o It"i ... '" o m N oj '" ... 0> cxi 0> 10 oj 10 C!!. iO~ '" 00 ..oM ~o N'" r--:ai "'~ ~~ ... ~ N N "!. ~ ~ cD NO "'~ It"ilt"i ;:1;~ ~a- 1000 NO i:,C"'i 10 00 C'"i 10 10 oj 10 "<t_ ~ ~~co. ...~ ... 0> "'''' o..,f ...... -00 r! 8 ~ <6 '" ~ o ~ o~ ...~ ~~ co ~ Lri" .-- IO~ ~"<t '~ ~ co "<t_ o o <6 ~ d o '" o 10 '" cD o ~ ~ ~ ri 10 ~ ~~~ :2~ "<to N-r NN -'" :;;: ai 0> m lXi 10 '" N 00 '" d 10 10 o 10 N cD 8 e 01 1ii .Q OJ ~ Ss e e ~~~ Q. Ui 1i) f/)~~~ !z '0 .5 .5 W"'O"O :E <Il !:!' e .....~~~ ~~~2 ii i I ~le dooi 1010 100> rN com mo ailXi '" '" ~ 00 ~ 10 ..,f ... o lXi ... '" 1:: <Il E "Iii <Il > .5 "iii Ii; cD ." II) ai II) U!. ... Sil cD N co iii .., N 'i ... lD co ... II) II) ai ~ .... .., <09 "<t ,.. cD o .... iii .., .... o .... <09 ." "'": ~ .... o o iii ... ~ d o .., o CD .., uS ... o .... cD .... .... ..; II) l'? .... E <Il E E <Il > o 0> <Il :5 '0 .l!l <Il '" '" 01 2:- 01 e ~ f!! o '" '6 "E <Il '" f!! 0. f!! "0 e o "0 "0 e t1l <Il '" o ~ " c- .5 "0 ~ ~ f!! f!! 01 ~ '" '!! 2 ... :;;: cIi ." ." a> II) .., N ... co .., d II) II) o CD N uS ... m ..... Z w :E ..... m w > ;!; C Z <( :r: ~ o ....I ~ VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of April 30, 2010 Maturity Date Financial Institution Purchase Date GOVERNMENTALANDENTERPIDSEFUNDS Investment Description CUSIPI Acct # Interest Rate % Market Value As of April 30, 2010, there were no certificate of deposits held by the Governmental and Enterprise Funds. Maturity Date Financial Institution Purchase Date POLlCE PENSION FUND (710) Various Various Wells Fargo Various Various Various FIRE PENSION FUND (720) Various Various Wells Fargo Various Various Various TRUST AND AGENCY FUNDS * Investment Description CUSIPI Acct # Interest Rate % Wells Fargo Investments Mutual Fund Investments Various Various Various Various Wells Fargo Investments Mutual Fund Investments Various Various Various Various TOTAL TRUST AND AGENCY FUND INVESTMENTS * Assets are restricted in purpose and do not represent discretionary assets of the government. Market Value 19,575,704.02 19,447,761.56 39,023,465.58 20,405,946.04 18,645,193.19 39,051,139.23 $ 78,074,604.81 Weighted Avg Yield Weighted Avg Yield 3 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE & EXPENDITURE SUMMARIES January 1 - April 30, 2010 05/12/2010 10:39:44 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/10 - 04/30/10 Cur Mo Received REVENUE BY CLASSIFICATION PROPERTY TAXES OTHER TAXES LICENSES, PERMITS & FEES INTERGOVERMENT REV. CHARGES FOR SERVICE FINES AND FORFEITS INVESTMENT INCOME REIMBURSEMENTS OTHER REVENUE OTHER FINANCING SOURCES Total All. Funds 225,422 1,031,946 626,888 1,029,539 1,675,657 78,426 470,884 34,921 269,294 o 5,442,977 REVENUE BY FUND GENERAL FUND REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND FOREIGN FIRE TAX BOARD FUND SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2009 B&I, FD/PW 2009B B&I, FD/PW 2009C B&I, FD/PW SERIES 1999 B&I, TIF 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 CAPITAL IMPROVEMENT FUND SERIES 2009 CONST FUND DOWNTOWN REDEVLPMNT CaNST STREET IMPROVEMENT CaNST FUND FLOOD CONTROL CaNST FUND WATER AND SEWER FUND VILLAGE PARKING SYSTEM FUND PARKING SYSTEM REVENUE FUND VEHICLE MAINTENANCE FUND VEHICLE REPLACEMENT FUND COMPUTER REPLACEMENT FUND RISK MANAGEMENT FUND POLICE PENSION FUND FIRE PENSION FUND SSA #6 GEORGE/ALBERT B&I GENERAL FIXED ASSETS ACCT GP 2,639,010 275,455 120,467 o 33,582 3,591 3 1,377 o o o 14,325 6,457 1,267 1,388 o o o 66,899 o o 67,285 20,871 30,517 98,472 6,770 749,968 11,478 13,341 137,473 12,326 92 517,753 308,755 304,055 o o 1 Y-T-D Received 7,605,724 3,587,223 1,545,375 1,500,817 6,343,075 151,999 2,898,997 123,183 2,568,587 o 26,324,980 10,391,614 1,639,637 385,262 o 56,044 3,612 13 2,792 o o o 488,692 223,751 53,888 64,978 o o o 66,962 o o 67,500 24,296 1,182,936 143,517 64,686 3,608,971 35,052 39,100 549,583 33,230 479 2,246,192 2,429,843 2,522,349 1 o 4 Months 8 Months 2010 Budget 14,999,000 15,665,000 3,487,000 18,102,647 21,970,880 704,000 5,696,250 467,000 7,023,160 1,023,505 89,138,442 40,691,100 4,038,500 1,836,500 o 565,447 6,000 1,500 20,500 35,500 o 379,000 904,000 414,000 o o o o o 1,140,708 o o 1,421,500 1,124,505 2,567,000 1,717,600 198,792 12,225,500 152,000 159,500 1,654,192 238,200 12,000 6,865,098 5,585,500 5,184,300 o o 33.3% 66.6% Unreceived Balance 7,393,276 12,077,777 1,941,625 16,601,830 15,627,805 552,001 2,797,253 343,817 4,454,573 1,023,505 62,813,462 30,299,486 2,398,863 1,451,238 o 509,403 2,388 1,487 17,708 35,500 o 379,000 415,308 190,249 -53,888 -64,978 o o o 1,073,746 o o 1,354,000 1,100,209 1,384,064 1,574,083 134,106 8,616,529 116,948 120,400 1,104,609 204,970 11,521 4,618,906 3,155,657 2,661,951 -1 o Completed Remaining unreceived Percent 49.3 77.1 55.7 91. 7 71.1 78 .4 49.1 73.6 63.4 100.0 70.5 74.5 59.4 79.0 90.1 39.8 99.1 86.4 100.0 100.0 45.9 46.0 94.1 95.3 97.8 53.9 91. 6 67.5 70.5 76.9 75.5 66.8 86.0 96.0 67.3 56.5 51.3 05/12/2010 10:39:44 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/10 - 04/30/10 Cur Mo Received Y-T-D Received 4 Months 8 Months 2010 Budget 33.3% Completed 66.6% Remaining unreceived Balance Unreceived Percent Total. All Funds 5,442,977 26,324,980 2 89,138,442 62,813,462 70.5 05/12/2010 10:40:12 4 Months 8 Months 33.3% 66.6% FRRBRR03 SUM021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category wi thin Fund Summary 01/01/10 - 04/30/10 Cur Mo Received GENERAL FUND 40 PROPERTY TAXES 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 43 INTERGOVERMENT REV. 44 CHARGES FOR SERVICE 45 FINES AND FORFEITS 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 174,621 732,869 624,677 860,559 150,257 67,912 3,592 16,478 8,045 o TOTAL GENERAL FUND 2,639,010 REFUSE DISPOSAL FUND 40 PROPERTY TAXES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 27,420 236,567 86 11,382 TOTAL REFUSE DISPOSAL FUND 275,455 MOTOR FUEL TAX FUND 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 47 REIMBURSEMENTS 115,398 110 4,959 TOTAL MOTOR FUEL TAX FUND 120,467 LAW ENFORCEMENT BLOCK GRANT 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME TOTAL LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 48 OTHER REVENUE 33,582 o o TOTAL COMMUNITY DEVELPMNT BLOCK GRNT 33,582 ASSET SEIZURE FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME 3,586 5 TOTAL ASSET SEIZURE FUND 3,591 DEA SHARED FUNDS FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME Y-T-D Received 5,857,896 1,298,076 1,537,982 1,011,830 385,717 140,061 13,412 80,759 65,881 o 10,391,614 937,518 667,871 312 33,936 1,639,637 355,867 455 28,940 385,262 o o o 35,169 o 20,875 56,044 3,596 16 3,612 o 3 2010 Budget 11,575,000 7,576,000 3,426,000 15,240,100 1,640,000 642,000 130,000 296,000 166,000 o 40,691,100 1,731,000 2,151,000 22,500 134,000 4,038,500 1,675,000 1,500 160,000 1,836,500 o o o 515,447 o 50,000 565,447 5,000 1,000 6,000 o 13 1,000 500 Unreceived Balance 5,717,104 6,277,924 1,888,018 14,228,270 1,254,283 501,939 116,588 215,241 100,119 o 30,299,486 793,482 1,483,129 22,188 100,064 2,398,863 1,319,133 1,045 131,060 1,451,238 o o o 480,278 o 29,125 509,403 1,404 984 2,388 1,000 487 Completed Remaining Unreceived Percent 49.4 82.9 55.1 93.4 76.5 78.2 89.7 72.7 60.3 74.5 45.8 69.0 98.6 74.7 59.4 78.8 69.7 81. 9 79.0 o o o 93.2 58.3 90.1 28.1 98.4 39.8 100.0 97.4 05/12/2010 10:40:12 4 Months 8 Months 33.3% 66.6% Completed Remaining FRRBRR03 SUM021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/10 - 04/30/10 Cur Mo Received Y-T-D Received 2010 Budget Unreceived Balance Unreceived Percent 1,487 99.1 TOTAL OEA SHARED FUNDS FUND DUI FINE FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME 1,376 1 TOTAL OUI FINE FUND 1,377 FOREIGN FIRE TAX BOARD FUND 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL FOREIGN FIRE TAX BOARD FUND SERIES 1987A B&I, PW FACILITY 40 PROPERTY TAXES 46 INVESTMENT INCOME TOTAL SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 3 13 1,500 20,000 500 20,500 o o 35,000 500 2,790 2 2,792 o o o o o o o 35,500 17,210 498 86.1 99.6 o o o o 17,708 86.4 35,000 500 100.0 100.0 35,500 100.0 o o o o o 0 0 378,000 378,000 100.0 0 0 1,000 1,000 100.0 0 0 0 0 0 0 379,000 379,000 100.0 TOTAL SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 14, 292 488,608 902,000 413,392 45.8 33 84 2,000 1,916 95.8 0 0 0 0 14,325 488,692 904,000 415,308 45.9 TOTAL SERIES 2003 B&I, VILLAGE HALL SERIES 2009 B&I, FO/PW 40 PROPERTY TAXES 46 INVESTMENT INCOME 6,445 12 TOTAL SERIES 2009 B&I, FO/PW 6,457 2009B B&I, FD/PW 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 1,262 5 o TOTAL 2009B B&I, FO/PW 1,267 2009C B&I, FD/PW 40 PROPERTY TAXES 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 1,382 o 6 223,728 23 223,751 53,877 11 o 53,888 44,097 20,872 9 413,000 1,000 414,000 189,272 977 45.8 97.7 190,249 46.0 o o o -53,877 -11 o o -53,888 o o o -44,097 -20,872 -9 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/10 - 04/30/10 4 Months 8 Months 33.3% Completed Remaining 05/12/2010 10:40:12 FRRBRR03 SUM 021 66.6% Cur Mo Received Y-T-D Received 2010 Budget unreceived Balance Unreceived Percent TOTAL 2009C B&I, FO/PW 1,388 64,978 o -64,978 SERIES 1999 B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME o o o o o o o o TOTAL SERIES 1999 B&I, TIF o o o o SERIES 1998A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME o o o o o o o o TOTAL SERIES 1998A B&I, FLOOD o o o o SERIES 1998C B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME o o o o o o o o TOTAL SERIES 1998C B&I, TIF o o o o IEPA FLOOD CONTROL LOANS B&I 41 OTHER TAXES 46 INVESTMENT INCOME 66,886 13 66,886 76 1,140,708 o 1,073,822 -76 94.1 TOTAL IEPA FLOOD CONTROL LOANS B&I 66,899 66,962 1,140,708 1,073,746 94.1 SERIES 2000 B&I, FLOOD CONTROL 41 OTHER TAXES 46 INVESTMENT INCOME o o o o o o o o TOTAL SERIES 2000 B&I, FLOOD CONTROL o o o o SERIES 2002B B&I, FLOOD 41 OTHER TAXES 49 OTHER FINANCING SOURCES o o o o o o o o TOTAL SERIES 2002B BU, FLOOD o o o o CAPITAL IMPROVEMENT FUND 41 OTHER TAXES 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 67,197 67,197 1,146,000 1,078,803 94.1 0 0 264,000 264,000 100.0 88 303 11,500 11,197 97.4 0 0 0 0 0 0 0 0 0 0 0 0 67,285 67,500 1,421,500 1,354,000 95.3 TOTAL CAPITAL IMPROVEMENT FUND SERIES 2009 CONST FUND 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 48 OTHER REVENUE 20,000 871 o 20,000 4,296 o 150,000 1,000 o 130,000 86.7 -3,296 -329.6 o 3 05/12/2010 10:40:12 4 Months 8 Months 33.3% 66.6% FRRBRR03 SUM021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/10 - 04/30/10 Cur Mo Received 49 OTHER FINANCING SOURCES TOTAL SERIES 2009 CONST FUND 20,871 DOWNTOWN REDEVLPMNT CONST 41 OTHER TAXES 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 30,336 181 o o o TOTAL DOWNTOWN REDEVLPMNT CaNST 30,517 STREET IMPROVEMENT CONST FUND 41 OTHER TAXES 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 48 OTHER REVENUE 97,968 o o 504 TOTAL STREET IMPROVEMENT CONST FUND 98,472 FLOOD CONTROL CONST FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 6,174 596 o o TOTAL FLOOD CONTROL CONST FUND 6,770 WATER AND SEWER FUND 41 42 44 46 47 48 49 OTHER TAXES LICENSES, PERMITS & FEES CHARGES FOR SERVICE INVESTMENT INCOME REIMBURSEMENTS OTHER REVENUE OTHER FINANCING SOURCES 24,652 1,615 709,846 2 9,450 4,403 o TOTAL WATER AND SEWER FUND 749,968 VILLAGE PARKING SYSTEM FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 2,639 o 8,838 1 TOTAL VILLAGE PARKING SYSTEM FUND 11,478 PARKING SYSTEM REVENUE FUND 41 OTHER TAXES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 3,225 10,116 o Y-T-D Received o 24,296 1,182,326 610 o o o 1,182,936 143,013 o o 504 143,517 6,174 1,433 57,079 o 64,686 817,687 5,960 2,767,255 74 9,450 8,545 o 3,608,971 2,639 o 32,407 6 35,052 3,225 35,873 2 2010 Budget o 973,505 1,124,505 2,556,000 ll,OOO o o o 2,567,000 1,506,000 210,600 1,000 o 1,717,600 105,292 45,000 47,500 1,000 198,792 1,500,000 16,000 10,596,000 92,500 1,000 20,000 o 12,225,500 45,000 o 106,000 1,000 152,000 55,000 104,000 500 unreceived Balance Completed Remaining Unreceived Percent 1,100,209 973,505 100.0 97.8 1,373,674 10,390 o o o 1,384,064 1,362,987 210,600 1,000 -504 1,574,083 99,ll8 43,567 -9,579 1,000 134,106 682,313 10,040 7,828,745 92,426 -8,450 11,455 o 8,616,529 42,361 o 73,593 994 116,948 51,775 68,127 498 53.7 94.5 53.9 90.5 100.0 100.0 91.6 94.1 96.8 -20.2 100.0 67.5 45.5 62.8 73.9 99.9 -845.0 57.3 70.5 94.1 69.4 99.4 76.9 94.1 65.5 99.6 05/12/2010 4 Months 33.3% Completed 10:40:12 8 Months 66.6% Remaining FRRBRR03 VILLAGE OF MOUNT PROSPECT SUM021 Budget Revenue by Category within Fund Sununary 01/01/10 - 04/30/10 Cur Mo Y-T-D 2010 Unreceived Unreceived Received Received Budget Balance Percent TOTAL PARKING SYSTEM REVENUE FUND 13,341 39,100 159,500 120,400 75.5 VEHICLE MAINTENANCE FUND 44 CHARGES FOR SERVICE 137,288 549,145 1,647,442 1,098,297 66.7 46 INVESTMENT INCOME 60 313 6,750 6,437 95.4 48 OTHER REVENUE 125 125 0 -125 TOTAL VEHICLE MAINTENANCE FUND 137,473 549,583 1,654,192 1,104,609 66.8 VEHICLE REPLACEMENT FUND 44 CHARGES FOR SERVICE 6,308 25,233 75,700 50,467 66.7 45 FINES AND FORFEITS 5,552 5,552 36,000 30,448 84.6 46 INVESTMENT INCOME 466 2,445 76,500 74,055 96 .8 48 OTHER REVENUE 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 50,000 50,000 100.0 TOTAL VEHICLE REPLACEMENT FUND 12,326 33,230 238,200 204,970 86.0 COMPUTER REPLACEMENT FUND 44 CHARGES FOR SERVICE 0 0 0 0 46 INVESTMENT INCOME 92 479 12,000 11,521 96.0 TOTAL COMPUTER REPLACEMENT FUND 92 479 12,000 11,521 96.0 RISK MANAGEMENT FUND 44 CHARGES FOR SERVICE 416,437 1,879,574 5,650,738 3,771,164 66.7 46 INVESTMENT INCOME 161 1,044 31,500 30,456 96.7 47 REIMBURSEMENTS 4,034 4,034 10,000 5,966 59.7 48 OTHER REVENUE 97,121 361,540 1,172,860 811,320 69.2 TOTAL RISK MANAGEMENT FUND 517,753 2,246,192 6,865,098 4,618,906 67.3 POLICE PENSION FUND 46 INVESTMENT INCOME 228,596 1,367,541 2,635,500 1,267,959 48.1 48 OTHER REVENUE 80,159 1,062,302 2,950,000 1,887,698 64.0 TOTAL POLICE PENSION FUND 308,755 2,429,843 5,585,500 3,155,657 56.5 FIRE PENSION FUND 46 INVESTMENT INCOME 236,500 1,507,470 2,654,000 1,146,530 43.2 48 OTHER REVENUE 67,555 1,014,879 2,530,300 1,515,421 59.9 TOTAL FIRE PENSION FUND 304,055 2,522,349 5,184,300 2,661,951 51.3 SSA #6 GEORGE/ALBERT B&I 46 INVESTMENT INCOME 0 1 0 -1 TOTAL SSA *6 GEORGE/ALBERT B&I 0 1 0 -1 GENERAL FIXED ASSETS ACCT GP 47 REIMBURSEMENTS 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 0 0 5 05/12/2010 10:40:12 4 Months 8 Months 33.3% 66.6% Completed Remaining VILLAGE Revenue by Category within 01/01/10 - 04/30/10 OF MOUNT PROSPECT Fund Summary FRRBRR03 SUM021 Budget Cur Mo Received Y-T-D Received o o TOTAL GENERAL FIXED ASSETS ACCT GP o MOUNT PROSPECT LIBRARY FUND 49 OTHER FINANCING SOURCES o TOTAL MOUNT PROSPECT LIBRARY FUND o 6 2010 Budget o o 9,715,689 o 9,715,689 Unreceived Unreceived Balance Percent 9,715,689 100.0 9,715,689 100.0 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/10 - 04/30/10 05/12/2010 10:38:40 Cur Mo Expended Y-T-D Expended 2010 Budget 33.3% 66.6% Unexpended Balance Completed Remaining Unexpended Percent EXPENDITURE BY CLASSIFICATION PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS PENSION BENEFITS CONTRACTUAL SERVICES UTILITIES INSURANCE COMMODITIES & SUPPLIES OTHER EXPENDITURES LAND IMPROVEMENTS BUILDING IMPROVEMENTS OFFICE EQUIPMENT MOBILE EQUIPMENT OTHER EQUIPMENT DISTRIBUTION SYSTEMS INFRASTRUCTURE BOND PRINCIPAL INTEREST EXPENSE BANK AND FISCAL FEES INTERFUND TRANSFERS OTHER FINANCING USES Total All Funds 1,882,782 595,862 29,031 559,030 1,265,233 28,770 553,895 90,455 49,247 o 36,797 3,140 288,577 120,804 17,472 35,230 o o o o o 5,556,325 EXPENDITURE BY FUND GENERAL FUND REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND FOREIGN FIRE TAX BOARD FUND SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2009 B&I, FD/PW 2009B B&I, FD/PW 2009C B&I, FD/PW SERIES 1999 B&I, TIF SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL CAPITAL IMPROVEMENT FUND SERIES 2009 CONST FUND DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST FUND WATER AND SEWER FUND 2,644,301 343,590 7,443 o 27,621 o o o 1,362 o o o o o o o o o o o o 159,306 123,424 58,524 250 o 673,262 1 8,106,841 3,857,038 95,181 2,146,464 4,200,463 80,935 2,292,054 519,110 63,129 o 1,715,715 117,060 291,899 300,629 27,995 77,754 17,193 2,451 878 o o 23,912,789 12,631,234 1,135,516 172,951 o 97,596 1,133 o o 9,949 o 150 300 428 o o o o o o 19,644 o 277,490 1,952,562 62,856 3,650 o 2,224,360 27,253,599 11,075,849 461,274 6,404,900 16,941,174 631,674 7,175,232 1,727,411 2,628,150 76,065 1,260,658 488,343 810,000 3,148,636 2,870,346 3,509,015 1,271,204 1,053,076 1,600 o o 88,788,206 41,145,530 4,240,941 1,736,302 o 565,447 2,000 1,000 1,500 15,500 o 382,203 912,658 417,663 o o o o o o 613,356 o 2,130,265 2,183,633 2,736,500 1,575,880 161,425 13,549,749 19,146,758 7,218,811 366,093 4,258,436 12,740,711 550,739 4,883,178 1,208,301 2,565,021 76,065 -455,057 371,283 518,101 2,848,007 2,842,351 3,431,261 1,254,011 1,050,625 722 o o 64,875,417 28,514,296 3,105,425 1,563,351 o 467,851 867 1,000 1,500 5,551 o 382,053 912,358 417,235 o o o o o o 593,712 o 1,852,775 231,071 2,673,644 1,572,230 161,425 11,325,389 70.3 65.2 79.4 66.5 75.2 87.2 68.1 69.9 97.6 100.0 -36.1 76.0 64.0 90.5 99.0 97.8 98.6 99.8 45.1 73.1 69.3 73.2 90.0 82.7 43.4 100.0 100.0 35.8 100.0 100.0 99.9 96 .8 87.0 10.6 97.7 99.8 100.0 83.6 05/12/2010 10:38:40 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/10 - 04/30/10 4 Months 8 Months 33.3% Completed 66.6% Remaining Cur Mo Y-T-D 2010 Unexpended Unexpended Expended Expended Budget Balance Percent VILLAGE PARKING SYSTEM FUND 6,292 29,045 175,098 146,053 83.4 PARKING SYSTEM REVENUE FUND 9,668 41,851 174,597 132,746 76.0 VEHICLE MAINTENANCE FUND 127,583 541,765 1,814,711 1,272,946 70.1 VEHICLE REPLACEMENT FUND 288,577 291,899 810,000 518,101 64.0 COMPUTER REPLACEMENT FUND 2,678 101,962 206,050 104,088 50.5 RISK MANAGEMENT FUND 526,925 2,184,175 6,872,398 4,688,223 68.2 POLICE PENSION FUND 286,102 1,094,180 3,242,300 2,148,120 66.3 FIRE PENSION FUND 269,417 1,038,093 3,121,500 2,083,407 66.7 SSA #6 GEORGE/ALBERT B&I 0 0 0 0 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 GENERAL LONG-TERM DEBT ACCT GP 0 0 0 0 Total All Funds 5,556,325 23,912,789 88,788,206 64,875,417 73.1 ? 05/12/2010 10:40:56 FRRDBROl SUM031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 04/30/10 NON-DEPARTMENTAL Cur Mo Expended PROGRAM TOTALS 00 ADMINISTRATION Totals EXPENDITURE CLASSIFICATION 72 INTEREST EXPENSE Totals SOURCE OF FUNDS 930 GENERAL LONG-TERM DEBT ACCT GP Totals Y-T-D Expended 2010 Budget o o o o o o o o o o o o 1 33.3% 66.6% Completed Remaining Unexpended Unexpended Balance Percent o o o o o o o o o o o o 05/12/2010 4 Months 33.3% Completed 10:40:56 VILLAGE OF MOUNT PROSPECT 8 Months 66.6% Remaining FRRDBROl SUM031 Department Budget Expenditure Summary 01/01/10 - 04/30/10 Cur Mo Y-T-D 2010 Unexpended Unexpended PUBLIC REPRESENTATION Expended Expended Budget Balance Percent PROGRAM TOTALS 02 MAYOR AND BOARD OF TRUSTEES 3,608 23,573 120,261 96,688 80.4 03 ADVISORY BOARDS & COMMISSIONS 436 1,515 6,149 4,634 75.4 Totals 4,044 25,088 126,410 101,322 80.2 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 2,786 11,149 34,311 23,162 67.5 51 EMPLOYEE BENEFITS 507 2,030 6,291 4,261 67.7 52 OTHER EMPLOYEE COSTS 1 106 4,400 4,294 97.6 54 CONTRACTUAL SERVICES 549 11,515 76,853 65,338 85.0 55 UTILITIES 16 77 455 378 83.1 57 COMMODITIES & SUPPLIES 185 211 4,100 3,889 94.9 Totals 4,044 25,088 126,410 101,322 80.2 SOURCE OF FUNDS 001 GENERAL FUND 4,044 25,088 126,410 101,322 80.2 Totals 4,044 25,088 126,410 101,322 80.2 2 05/12/2010 10:40:57 FRRDBROl SUM031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 04/30/10 VILLAGE MANAGER'S OFFICE CUr Mo Expended PROGRAM TOTALS 01 VILLAGE MANAGER'S OFFICE 02 LEGAL SERVICES 03 HUMAN RESOURCES 04 INFORMATION TECHNOLOGY 05 PUBLIC INFORMATION 42,538 37,600 19,476 78,978 27,308 Totals 205,900 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 74,877 25,600 454 102,939 462 1,546 22 o Totals 205,900 SOURCE OF FUNDS 001 GENERAL FUND 205,900 Totals 205,900 3 Y-T-D Expended 179,167 91,204 75,108 255,226 61,410 662,115 308,677 103,336 4,180 226,626 1,832 3,103 14,361 o 662,115 662,115 662,115 2010 Budget 575,229 538,250 265,181 892,193 248,098 2,518,951 1,011,435 321,215 28,200 1,115,200 8,601 15,200 19,100 o 2,518,951 2,518,951 2,518,951 33.3% 66.6% Unexpended Balance 396,062 447,046 190,073 636,967 186,688 1,856,836 702,758 217,879 24,020 888,574 6,769 12,097 4,739 o 1,856,836 1,856,836 1,856,836 Completed Remaining Unexpended Percent 68.9 83.1 71.7 71.4 75.2 73.7 69.5 67.8 85.2 79.7 78.7 79.6 24.8 73.7 73.7 73.7 05/12/2010 4 Months 33.3% Completed 10:40:57 VILLAGE OF MOUNT PROSPECT 8 Months 66.6% Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/10 - 04/30/10 Cur Mo Y-T-D 2010 Unexpended Unexpended TV SERVICES DIVISION Expended Expended Budget Balance Percent PROGRAM TOTALS 02 CABLE TV OPERATIONS 12,409 49,641 139,639 89,998 64.5 04 INTERGOVERNMENTAL PROGRAMMING 4,574 15,434 62,410 46,976 75.3 Totals 16,983 65,075 202,049 136,974 67.8 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 8,971 35,964 114,194 78,230 68.5 51 EMPLOYEE BENEFITS 3,546 14,285 44,177 29,892 67.7 52 OTHER EMPLOYEE COSTS 0 725 700 -25 -3.6 54 CONTRACTUAL SERVICES 1,690 7,099 27,378 20,279 74.1 55 UTILITIES 107 514 1,600 1,086 67.9 57 COMMODITIES & SUPPLIES 956 2,210 5,500 3,290 59.8 67 OTHER EQUIPMENT 1,713 4,278 8,500 4,222 49.7 Totals 16,983 65,075 202,049 136,974 67.8 SOURCE OF FUNDS 001 GENERAL FUND 16,983 65,075 202,049 136,974 67.8 Totals 16,983 65,075 202,049 136,974 67.8 4 05/12/2010 4 Months 33.3% Completed 10:40:57 VILLAGE OF MOUNT PROSPECT 8 Months 66.6% Remaining FRRDBROl SUM031 Department Budget Expenditure Summary 01/01/10 - 04/30/10 CUr Mo Y-T-D 2010 Unexpended Unexpended VILLAGE CLERK'S OFFICE Expended Expended Budget Balance Percent PROGRAM TOTALS 02 VILLAGE CLERK'S OFFICE 13,987 62,966 208,643 145,677 69.8 Totals 13,987 62,966 208,643 145,677 69.8 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 9,231 42,208 126,804 84,596 66.7 51 EMPLOYEE BENEFITS 3,708 15,714 47,646 31,932 67.0 52 OTHER EMPLOYEE COSTS 0 333 1,485 1,152 77.6 54 CONTRACTUAL SERVICES 995 4,302 29,679 25,377 85.5 55 UTILITIES 53 257 1,549 1,292 83.4 57 COMMODITIES & SUPPLIES 0 152 1,480 1,328 89.7 Totals 13,987 62,966 208,643 145,677 69.8 SOURCE OF FUNDS 001 GENERAL FUND 13,987 62,966 208,643 145,677 69.8 Totals 13,987 62,966 208,643 145,677 69.8 5 05/12/2010 4 Months 33.3% Completed 10:40:57 VILLAGE OF MOUNT PROSPECT 8 Months 66.6% Remaining FRRDBROl SUM031 Department Budget Expenditure Summary 01/01/10 - 04/30/10 Cur Mo Y-T-D 2010 Unexpended Unexpended FINANCE DEPARTMENT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 FINANCE ADMINISTRATION 27,474 102,354 359,820 257,466 71..6 02 ACCOUNTING 37,327 149,282 491,793 342,511 69.6 05 INSURANCE PROGRAMS 25,471 102,095 311,872 209,777 67.3 06 CUSTOMER SERVICE 28,943 1.37,323 420,812 283,489 67.4 07 CASH MANAGEMENT 2,187 8,894 28,416 19,522 68.7 Totals 121,402 499,948 1,612,713 1,112,765 69.0 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 62,401 251,905 843,557 591,652 70.1 51 EMPLOYEE BENEFITS 24,510 98,405 312,122 213,717 68.5 52 OTHER EMPLOYEE COSTS 165 1,752 5,650 3,898 69.0 54 CONTRACTUAL SERVICES 1.3,120 64,464 181,213 116,749 64.4 55 UTILITIES 309 1,305 4,900 3,595 73 .4 56 INSURANCE 19,393 77,570 232,711 155,1.41 66.7 57 COMMODITIES & SUPPLIES 1,504 4,547 32,160 27,613 85.9 65 OFFICE EQUIPMENT 0 0 400 400 100.0 Totals 121,402 499,948 1,612,713 1,112,765 69.0 SOURCE OF FUNDS 001 GENERAL FUND 121,402 499,948 1,612,71.3 1,112,765 69.0 Totals 121,402 499,948 1,612,713 1,112,765 69.0 6 05/12/2010 10:40:57 FRRDBROl SUM031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 04/30/10 COMMUNITY DEVELOPMENT Cur Mo Expended PROGRAM TOTALS 01 COMMUNITY DEVELOPMENT ADMIN 02 PLANNING & ZONING 03 ECONOMIC DEVELOPMENT 05 BUILDING INSPECTIONS 06 HOUSING INSPECTIONS 07 HEALTH INSPECTIONS 19,113 18,886 7,753 69,854 37,230 8,964 161,800 Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 103,282 42,753 869 13,203 873 820 o Totals 161,800 SOURCE OF FUNDS 001 GENERAL FUND 550 DOWNTOWN REDEVLPMNT CONST 161,800 o Totals 161,800 7 Y-T-D Expended 79,406 77,288 29,183 259,512 153,207 40,140 638,736 419,399 171,971 6,956 33,850 3,025 3,535 o 638,736 638,736 o 638,736 2010 Budget 33.3% Completed 66.6% Remaining Unexpended Unexpended Balance Percent 261,596 333,616 95,383 940,912 529,946 128,093 2,289,546 1,402,026 541,145 31,246 269,117 17,671 24,141 4,200 2,289,546 2,288,046 1,500 2,289,546 182,190 256,328 66,200 681,400 376,739 87,953 1,650,810 982,627 369,174 24,290 235,267 14,646 20,606 4,200 1,650,810 1,649,310 1,500 1,650,810 69.6 76.8 69.4 72.4 71.1 68.7 72.1 70.1 68.2 77.7 87.4 82.9 85.4 100.0 72.1 72 .1 100.0 72.1 05/12/2010 10:40:57 FRRDBROl SUM031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 04/30/10 COMMUNITY DEVELOPMENT - CDBG Cur Mo Expended PROGRAM TOTALS 04 CDBG ADMINISTRATION 05 CDBG COMMUNITY PROGRAMS 06 ACCESSIBLTY & NEIGHBRHD IMPRV 07 CDBG RESIDENTIAL REHAB 08 CDBG RECOVERY ACT 6,317 o 3,360 198 17,746 27,621 Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 62 LAND IMPROVEMENTS 69 INFRASTRUCTURE 4,369 1,811 o 118 19 17,944 o 3,360 Totals 27,621 SOURCE OF FUNDS 070 COMMUNITY DEVELPMNT BLOCK GRNT 27,621 Totals 27,621 8 Y-T-D Expended 26,303 27,657 3,360 16,605 23,671 97,596 17,401 7,240 25 37,663 81 31,826 o 3,360 97,596 97,596 97,596 2010 Budget 33.3% 66.6% Completed Remaining Unexpended Unexpended Balance Percent 94,947 90,500 100,000 280,000 o 565,447 62,569 23,311 1,965 106,625 977 200,000 50,000 120,000 565,447 565,447 565,447 68,644 62,843 96,640 263,395 -23,671 467,851 45,168 16,071 1,940 68,962 896 168,174 50,000 116,640 467,851 467,851 467,851 72 .3 69.4 96.6 94.1 82.7 72.2 68.9 98.7 64.7 91. 7 84.1 100.0 97.2 82.7 82.7 82.7 05/12/2010 10:40:57 FRRDBROl SUM on 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 04/30/10 HUMAN SERVICES Cur Mo Expended PROGRAM TOTALS 01 HUMAN SERVICES ADMINISTRATION 02 SOCIAL SERVICES 03 NURSING/HEALTH SERVICES 04 SENIOR CITIZEN LEIS ACTIVITIES 05 COMMUNITY CONNECTIONS CENTER 12,902 31,320 16,124 2,124 21,098 Totals 83,568 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 64 BUILDING IMPROVEMENTS 65 OFFICE EQUIPMENT 53,909 19,240 419 8,324 701 975 o o Totals 83,568 SOURCE OF FUNDS 001 GENERAL FUND 83,568 Totals 83,568 9 Y-T-D Expended 58,584 120,124 60,512 9,099 90,684 339,003 216,988 78,178 868 34,855 3,398 4,716 o o 339,003 339,003 339,003 2010 Budget 184,075 389,713 239,089 35,821 306,071 1,154,769 689,812 241,687 12,581 154,168 14,756 39,065 o 2,700 1,154,769 1,154,769 1,154,769 33.3% 66.6% Unexpended Balance 125,491 269,589 178,577 26,722 215,387 815,766 472,824 163,509 11,713 119,313 11,358 34,349 o 2,700 815,766 815,766 815,766 Completed Remaining Unexpended Percent 68.2 69.2 74.7 74.6 70.4 70.6 68.5 67.7 93.1 77.4 77.0 87.9 100.0 70.6 70.6 70.6 05/12/2010 10:40:57 FRRDBROl SUM 031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 04/30/10 POLICE Cur Mo Expended PROGRAM TOTALS 01 POLICE ADMINISTRATION 02 PATROL & TRAFFIC ENFORCEMENT 03 CRIME PREVTN & PUBLIC SERVICES 04 INVESTIGATIVE & JUVENILE PRGM 05 CROSSING GUARDS 06 EQUIPMENT MAINTENANCE 154,387 626,824 19,037 97,499 2,878 45,208 Totals 945,833 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 80 INTERFUND TRANSFERS 651,493 183,993 12,932 85,807 2,748 8,115 440 305 o Totals 945,833 SOURCE OF FUNDS 001 GENERAL FUND 060 LAW ENFORCEMENT BLOCK GRANT 080 ASSET SEIZURE FUND 085 DEA SHARED FUNDS FUND 086 DUI FINE FUND 945,833 o o o o Totals 945,833 10 Y-T-D Expended 1,411,982 2,677,502 83,167 388,587 11,469 177,870 4,750,577 2,820,075 1,456,986 40,449 400,839 10,140 19,741 737 1,610 o 4,750,577 4,749,444 o 1,133 o o 4,750,577 2010 Budget 3,958,608 8,946,765 271,910 1,318,756 31,480 515,145 15,042,664 9,490,554 4,146,442 140,300 1,080,543 33,160 127,315 6,150 18,200 o 15,042,664 15,038,164 o 2,000 1,000 1,500 15,042,664 33.3% Completed 66.6% Remaining Unexpended Unexpended Balance Percent 2,546,626 6,269,263 188,743 930,169 20,011 337,275 10,292,087 6,670,479 2,689,456 99,851 679,704 23,020 107,574 5,413 16,590 o 10,292,087 10,288,720 o 867 1,000 1,500 10,292,087 64.3 70.1 69.4 70.5 63.6 65.5 68.4 70.3 64.9 71.2 62.9 69.4 84.5 88.0 91.2 68.4 68.4 43.4 100.0 100.0 68.4 05/12/2010 10:40:57 FRRDBROl SUM 031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 04/30/10 FIRE Cur Mo Expended PROGRAM TOTALS 01 FIRE ADMINISTRATION 02 FIRE DEPARTMENT OPERATIONS 03 FIRE TRAINING ACADEMY 04 FIRE PREVENTION 05 FIRE COMMUNICATIONS 06 EQUIPMENT MAINTENANCE 07 EMERGENCY PREPAREDNESS PRGM 08 PAID-ON-CALL PROGRAM 10 FOREIGN FIRE INSURANCE 100,739 541,704 o 34,088 3,089 16,475 289 2,628 1,362 700,374 Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 53 PENSION BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 64 BUILDING IMPROVEMENTS 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 516,139 138,026 6,814 o 31,303 2,351 2,898 o o 2,843 700,374 Totals SOURCE OF FUNDS 001 GENERAL FUND 095 FOREIGN FIRE TAX BOARD FUND 699,012 1,362 Totals 700,374 11 Y-T-D Expended 1,135,061 2,298,740 o 166,606 14,381 65,900 309 8,315 9,949 3,699,261 2,232,237 1,271,473 19,015 o 150,845 9,209 12,662 o o 3,820 3,699,261 3,689,312 9,949 3,699,261 2010 Budget 33.3% 66.6% Completed Remaining Unexpended Unexpended Balance Percent 2,933,025 7,578,769 14,131 603,725 55,611 197,950 62,436 33,180 15,500 11,494,327 7,402,167 3,333,594 140,880 500 413,665 38,311 73,970 3,800 9,000 78,440 11,494,327 11,478,827 15,500 11,494,327 1,797,964 5,280,029 14,131 437,119 41,230 132,050 62,127 24,865 5,551 7,795,066 5,169,930 2,062,121 121,865 500 262,820 29,102 61,308 3,800 9,000 74,620 7,795,066 7,789,515 5,551 7,795,066 61.3 69.7 100.0 72 .4 74.1 66.7 99.5 74.9 35.8 67.8 69.8 61. 9 86.5 100.0 63.5 76.0 82.9 100.0 100.0 95.1 67.8 67.9 35.8 67.8 05/12/2010 10:40:57 FRRDBROl SUMon 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 04/30/10 PUBLIC WORKS - ADMINISTRATION Cur Mo Expended PROGRAM TOTALS 01 PUBLIC WORKS ADMINISTRATION 77,806 Totals 77,806 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 16,530 12,005 2,899 44,299 983 1,090 o o Totals 77,806 SOURCE OF FUNDS 001 GENERAL FUND 77,806 77,806 Totals 12 Y-T-D Expended 317,845 317,845 76,039 49,680 5,900 176,926 4,264 5,036 o o 317,845 317,845 317,845 2010 Budget 33.3% 66.6% Completed Remaining Unexpended Unexpended Balance Percent 982,823 982,823 234,319 149,319 25,802 538,489 19,470 15,169 o 255 982,823 982,823 982,823 664,978 664,978 158,280 99,639 19,902 361,563 15,206 10,133 o 255 664,978 664,978 664,978 67.7 67.7 67.5 66.7 77.1 67.1 78.1 66.8 100.0 67.7 67.7 67.7 05/12/2010 10:40:57 FRRDBROl SUM031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 04/30/10 PUBLIC WORKS - STREETS/BLDGS Cur Mo Expended PROGRAM TOTALS 01 STREET DIVISION ADMINISTRATION 02 MAINTENANCE - PUBLIC BUILDINGS 04 STREET MAINTENANCE 05 SNOW REMOVAL 06 LEAF REMOVAL 07 STORM SEWER & BASIN MAINT 08 MAINTENANCE OF STATE HIGHWAYS 09 TRAFFIC SIGN MAINTENANCE 10 VILLAGE PARKING LOT MAINT 11 PARKING LOT MAINTENANCE 12 FLOOD CONTROL 13 STORM EVENT 10,687 70,222 15,787 11,229 o 6,211 8,528 12,065 6,292 9,668 o o Totals 150,689 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 64 BUILDING IMPROVEMENTS 67 OTHER EQUIPMENT 69 INFRASTRUCTURE 72,070 26,417 33,160 2,313 158 16,516 o o o 55 Totals 150,689 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 620 VILLAGE PARKING SYSTEM FUND 630 PARKING SYSTEM REVENUE FUND 134,729 o 6,292 9,668 Totals 150,689 13 Y-T-D Expended 62,590 268,847 56,780 418,074 o 25,309 34,507 33,885 29,045 41,851 o o 970,888 422,678 123,411 205,018 4,915 632 213,274 o 905 o 55 970,888 743,958 156,034 29,045 41,851 970,888 2010 Budget 33.3% 66.6% Completed Remaining Unexpended Unexpended Balance Percent 161,866 1,010,405 418,912 669,384 o 112,657 70,394 122,044 175,098 149,597 o o 2,890,357 1,246,055 382,210 726,159 79,230 1,894 394,954 o 19,855 o 40,000 2,890,357 2,266,230 299,432 175,098 149,597 2,890,357 99,276 741,558 362,132 251,310 o 87,348 35,887 88,159 146,053 107,746 o o 1,919,469 823,377 258,799 521,141 74,315 1,262 181,680 o 18,950 o 39,945 1,919,469 1,522,272 143,398 146,053 107,746 1,919,469 61.3 73.4 86.4 37.5 77 .5 51. 0 72 .2 83.4 72 .0 66.4 66.1 67.7 71. 8 93.8 66.6 46.0 95.4 99.9 66.4 67.2 47.9 83.4 72 .0 66.4 05/12/2010 4 Months 33.3% Completed 10:40:57 VILLAGE OF MOUNT PROSPECT 8 Months 66.6% Remaining FRRDBROl SUM03l Department Budget Expenditure Sununary 01/01/10 - 04/30/10 Cur Mo Y-T-D 2010 Unexpended Unexpended PUBLIC WORKS - FORE STRY/GRND S Expended Expended Budget Balance Percent PROGRAM TOTALS Ol FORESTRY DIVISION ADMIN l7,367 73,382 237,763 l64,38l 69.l 02 MAINTENANCE OF GROUNDS 27,l24 lOO,857 473,32l 372,464 78.7 03 FORESTRY PROGRAM 49,794 290,789 998, D8 707,349 70.9 04 PUBLIC GROUNDS BEAUTIFICATION 2,367 9,557 72,OlO 62,453 86.7 Totals 96,652 474,585 1,781,232 1,306,647 73.4 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 53, U8 207,l55 76l,579 554,424 72.8 5l EMPLOYEE BENEFITS l8,78l 75,79l 246,330 170,539 69.2 52 OTHER EMPLOYEE COSTS 0 893 3,662 2,769 75.6 54 CONTRACTUAL SERVICES 23,855 l88,547 7l8,ll2 529,565 73.7 57 COMMODITIES & SUPPLIES 598 2,l99 5l,549 49,350 95.7 67 OTHER EQUIPMENT 0 0 0 0 Totals 96,652 474,585 1,781,232 1,306,647 73.4 SOURCE OF FUNDS OOl GENERAL FUND 96,652 474,585 l,762,432 l,287,847 73.l 690 RISK MANAGEMENT FUND 0 0 l8,800 l8,800 lOO.O Totals 96,652 474,585 1,781,232 1,306,647 73.4 l4 05/12/2010 10:40:57 FRRDBROl SUM031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Swmnary 01/01/10 - 04/30/10 PUBLIC WORKS - ENGINEERING Cur Mo Expended PROGRAM TOTALS 01 ENGINEERING SERVICES 05 TRAFFIC CNTRL & STREET LGHTNG 56,753 17,692 Totals 74,445 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 69 INFRASTRUCTURE 48,850 16,027 175 9,195 o 198 o o o Totals 74,445 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 67,002 7,443 Totals 74,445 15 Y-T-D Expended 242,324 62,641 304,965 206,941 66,150 1,790 20,641 3,134 6,309 o o o 304,965 288,048 16,917 304,965 2010 Budget 831,493 756,494 1,587,987 701,400 211,200 3,552 131,796 225,000 32,855 546 1,638 280,000 1,587,987 1,071,117 516,870 1,587,987 33.3% 66.6% Unexpended Balance 589,169 693,853 1,283,022 494,459 145,050 1,762 111,155 221,866 26,546 546 1,638 280,000 1,283,022 783,069 499,953 1,283,022 Completed Remaining Unexpended Percent 70.9 91. 7 80.8 70.5 68.7 49.6 84.3 98.6 80.8 100.0 100.0 100.0 80.8 73.1 96.7 80.8 05/12/2010 10:40:57 FRRDBROl SUM031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 04/30/10 PUBLIC WORKS - WATER/SEWER Cur Mo Expended PROGRAM TOTALS 01 WATER & SEWER DIVISION ADMIN 02 MAINTENANCE OF BUILDINGS 03 MAINTENANCE OF GROUNDS 04 WATER SUPPLY MAINT & REPAIR 05 WATER DISTRBT MAINT & REPAIR 06 WATER VALVE/HYDRNT MAINT & REP 07 WATER METER MAINT & REPL 08 EQUIPMENT MAINTENANCE 09 SANITARY SEWER MAINT & REPAIR 10 WATER & SEWER SYSTEM IMPROV 12 LAKE MICHIGAN WATER SUPPLY 103,207 14,225 9,977 53,528 41,692 23,979 22,745 42,889 58,019 11,697 291,304 Totals 673,262 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 68 DISTRIBUTION SYSTEMS 129,563 50,704 4,273 434,682 17,780 5,524 10,152 o o 3,112 17,472 Totals 673,262 SOURCE OF FUNDS 610 WATER AND SEWER FUND 673,262 Totals 673,262 16 Y-T-D Expended 419,161 57,656 27,276 199,875 149,697 86,441 73,834 171,556 132,742 17,409 888,713 2,224,360 519,318 206,784 11,659 1,341,913 38,505 22,099 52,975 o o 3,112 27,995 2,224,360 2,224,360 2,224,360 2010 Budget 33.3% 66.6% Completed Remaining Unexpended Unexpended Balance Percent 1,415,111 226,997 136,428 1,585,848 868,982 413,162 963,266 514,668 1,079,772 2,315,515 4,030,000 13,549,749 1,900,352 671,563 57,336 6,202,726 185,406 66,295 291,120 o 7,652 1,296,953 2,870,346 13,549,749 13,549,749 13,549,749 995,950 169,341 109,152 1,385,973 719,285 326,721 889,432 343,112 947,030 2,298,106 3,141,287 11,325,389 1,381,034 464,779 45,677 4,860,813 146,901 44,196 238,145 o 7,652 1,293,841 2,842,351 11,325,389 11,325,389 11,325,389 70.4 74.6 80.0 87.4 82.8 79.1 92 .3 66.7 87.7 99.2 77.9 83.6 72.7 69.2 79.7 78.4 79.2 66.7 81.8 100.0 99.8 99.0 83.6 83.6 83.6 05/12/2010 10:40:57 FRRDBROl SUM031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 04/30/10 PUBLIC WORKS - REFUSE DISPOSAL Cur Mo Expended PROGRAM TOTALS 01 REFUSE DISPOSAL PROGRAM 02 REFUSE LEAF REMOVAL PROGRAM 333,130 10,460 Totals 343,590 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 14,169 5,230 o 322,275 21 1,895 o Totals 343,590 SOURCE OF FUNDS 030 REFUSE DISPOSAL FUND 343,590 Totals 343,590 17 Y-T-D Expended 1,095,136 40,380 1,135,516 55,543 21,266 o 1,051,026 103 7,578 o 1,135,516 1,135,516 1,135,516 2010 Budget 4,019,373 221,568 4,240,941 251,942 77,148 1,200 3,853,608 572 22,734 33,737 4,240,941 4,240,941 4,240,941 33.3% Completed 66.6% Remaining Unexpended Unexpended Balance Percent 2,924,237 181,188 3,105,425 196,399 55,882 1,200 2,802,582 469 15,156 33,737 3,105,425 3,105,425 3,105,425 72 .8 81.8 73.2 78.0 72.4 100.0 72.7 82.0 66.7 100.0 73.2 73.2 73.2 05/12/2010 10:40:57 FRRDBROl SUM031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 04/30/10 PUBLIC WORKS - VEHICLE MAINT Cur Mo Expended PROGRAM TOTALS 01 VEHICLE MAINTENANCE ADMIN 02 VEHICLE MAINTENANCE PROGRAM 12,466 115,117 Totals 127,583 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 60,106 22,805 30 5,841 53 38,748 o o o Totals 127,583 SOURCE OF FUNDS 660 VEHICLE MAINTENANCE FUND 127,583 Totals 127,583 18 Y-T-D Expended 63,309 478,456 541,765 260,811 93,539 530 16,169 257 170,459 o o o 541,765 541,765 541,765 2010 Budget 33.3% 66.6% Completed Remaining Unexpended Unexpended Balance Percent 180,836 1,633,875 1,814,711 879,792 301,789 2,315 95,738 993 530,039 o 545 3,500 1,814,711 1,814,711 1,814,711 117,527 1,155,419 1,272,946 618,981 208,250 1,785 79,569 736 359,580 o 545 3,500 1,272,946 1,272,946 1,272,946 65.0 70.7 70.1 70.4 69.0 77 .1 83.1 74.1 67.8 100.0 100.0 70.1 70.1 70.1 05/12/2010 10:40:57 FRRDBROl SUM031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 04/30/10 COMMUNITY SERVICE PROGRAMS Cur Mo Expended PROGRAM TOTALS 02 COMMUNITY GROUPS & MISC 03 4TH OF JULY & CIVIC EVENTS,ETC 04 HOLIDAY DECORATIONS 05 BLOOD DONOR PROGRAM 4,150 6,071 1,321 230 Totals 11,772 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 618 199 4,820 6,135 o Total.s 11,772 SOURCE OF FUNDS 001 GENERAL FUND 11,772 Total.s 11,772 19 Y-T-D Expended 38,148 7,487 13,369 866 59,870 2,353 799 38,818 17,900 o 59,870 59,870 59,870 2010 Budget 33.3% 66.6% Completed Remaining Unexpended Unexpended Balance Percent 136,400 167,252 81,330 2,774 387,756 100,731 18,660 207,785 52,580 8,000 387,756 387,756 387,756 98,252 159,765 67,961 1,908 327,886 98,378 17,861 168,967 34,680 8,000 327,886 327,886 327,886 72 .0 95.5 83.6 68.8 84.6 97.7 95.7 81.3 66.0 100.0 84.6 84.6 84.6 05/12/2010 10:40:57 FRRDBROl SUM031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 04/30/10 CAPITAL IMPROVEMENT PROJECTS Cur Mo Expended PROGRAM TOTALS 01 VILLAGE IMPROVEMENTS & EQUIP 02 COMMUNITY IMPROVEMENT PROJECTS 03 DOWNTOWN REDEVELOPMENT CONST 04 FLOOD CONTROL PROJECTS 06 STREET IMPROVEMENT PROJECTS 09 MOTOR EQUIPMENT REPLACEMENT 10 COMPUTER REPLACEMENT 11 STATION 14 12 EMERGENCY OPERATION CENTER 13 PUBLIC WORKS EXPANSION 142,471 16,835 58,524 o 250 288,577 2,678 117,548 5,876 o Totals 632,759 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 59 OTHER EXPENDITURES 62 LAND IMPROVEMENTS 64 BUILDING IMPROVEMENTS 65 OFFICE EQUIPMENT 66 MOBILE EQUIPMENT 67 OTHER EQUIPMENT 69 INFRASTRUCTURE 71 BOND PRINCIPAL 72 INTEREST EXPENSE 80 INTERFUND TRANSFERS 128,758 31,303 o 36,797 2,678 288,577 112,831 31,815 o o o Totals 632,759 SOURCE OF FUNDS 050 MOTOR FUEL TAX FUND 510 CAPITAL IMPROVEMENT FUND 528 SERIES 2009 CONST FUND 550 DOWNTOWN REDEVLPMNT CONST 560 STREET IMPROVEMENT CONST FUND 590 FLOOD CONTROL CONST FUND 630 PARKING SYSTEM REVENUE FUND 670 VEHICLE REPLACEMENT FUND 680 COMPUTER REPLACEMENT FUND o 159,306 123,424 58,524 250 o o 288,577 2,678 Totals 632,759 20 Y-T-D Expended 219,277 24,752 62,856 o 37,111 291,899 101,962 1,599,527 156,924 196,111 2,690,419 188,297 31,303 o 1,714,810 101,962 291,899 287,809 74,339 o o o 2,690,419 o 277,490 1,952,562 62,856 3,650 o o 291,899 101,962 2,690,419 2010 Budget 33.3% 66.6% Completed Remaining Unexpended Unexpended Balance Percent 1,829,500 155,765 2,735,000 161,425 2,665,880 810,000 206,050 1,380,963 456,741 345,929 10,747,253 1,005,820 2,420,150 26,065 1,237,003 438,050 810,000 1,741,150 3,069,015 o o o 10,747,253 920,000 2,130,265 2,183,633 2,735,000 1,575,880 161,425 25,000 810,000 206,050 10,747,253 1,610,223 131,013 2,672,144 161,425 2,628,769 518,101 104,088 -218,564 299,817 149,818 8,056,834 817,523 2,388,847 26,065 -477,807 336,088 518,101 1,453,341 2,994,676 o o o 8,056,834 920,000 1,852,775 231,071 2,672,144 1,572,230 161,425 25,000 518,101 104,088 8,056,834 88.0 84.1 97.7 100.0 98.6 64.0 50.5 -15.8 65.6 43.3 75.0 81.3 98.7 100.0 -38.6 76.7 64.0 83.5 97.6 75.0 100.0 87.0 10.6 97.7 99.8 100.0 100.0 64.0 50.5 75.0 05/12/2010 10:40:57 FRRDBROl SUM031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 04/30/10 DEBT SERVICE Cur Mo Expended PROGRAM TOTALS 02 DEBT SERVICE - PROPERTY TAXES 03 DEBT SERVICE - TAX INCREMENT 04 DEBT SERVICE - H/R SALES TAX 1 06 SPECIAL SERVICE AREA B & I Totals EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 59 OTHER EXPENDITURES 71 BOND PRINCIPAL 72 INTEREST EXPENSE 73 BANK AND FISCAL FEES 80 INTERFUND TRANSFERS 81 OTHER FINANCING USES Totals SOURCE OF FUNDS 140 SERIES 1987A B&I, PW FACILITY 180 SERIES 2001 B&I, VILLAGE HALL 190 SERIES 2003 B&I, VILLAGE HALL 195 SERIES 2009 B&I, FD/PW 196 2009B B&I, FD/PW 197 2009C B&I, FD/PW 290 SERIES 1999 B&I, TIF 340 SERIES 1996A B&I, FLOOD 350 SERIES 1998A B&I, FLOOD 360 SERIES 1998C B&I, TIF 380 IEPA FLOOD CONTROL LOANS B&I 390 SERIES 2000 B&I, FLOOD CONTROL 830 SSA #6 GEORGE/ALBERT B&I Totals 21 Y-T-D Expended o o o o 878 o 19,644 o o 20,522 o o o o o o o o o 17,193 2,451 878 o o o 20,522 o o o o o o o o o o o o o o 150 300 428 o o o o o o 19,644 o o o 20,522 2010 Budget 1,712,524 o 613,356 o 2,325,880 o o 1,271,204 1,053,076 1,600 o o 2,325,880 o 382,203 912,658 417,663 o o o o o o 613,356 o o 2,325,880 33.3% 66.6% Unexpended Balance 1,711,646 o 593,712 o 2,305,358 o o 1,254,011 1,050,625 722 o o 2,305,358 o 382,053 912,358 417,235 o o o o o o 593,712 o o 2,305,358 Completed Remaining Unexpended Percent 99.9 96.8 99.1 98.6 99.8 45.1 99.1 100.0 100.0 99.9 96 .8 99.~ 05/12/2010 10:40:57 FRRDBROl SUM 031. VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 04/30/10 4 Months 8 Months 33.3% 66.6% Completed Remaining Tota1.s Cur Mo Y-T-D 201.0 Unexpended Unexpended Expended Expended Budget Balance Percent 3,81.1. 1.5,241. 46,600 31.,359 67.3 286,1.02 1.,094,1.80 3,242,300 2,1.48,1.20 66.3 269,41.7 1.,038,093 3,1.21.,500 2,083,407 66.7 559,330 2,147,51.4 6,410,400 4,262,886 66.5 RETIREE PENSIONS PROGRAM TOTALS 01. MISCELLANEOUS PENSIONS 02 POLICE PENSIONS 03 FIRE PENSIONS EXPENDITURE CLASSIFICATION 53 PENSION BENEFITS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES Totals 559,030 2,1.46,464 6,404,400 4,257,936 66.5 300 1.,050 4,500 3,450 76.7 0 0 1.,500 1.,500 1.00.0 559,330 2,147,51.4 6,41.0,400 4,262,886 66.5 SOURCE OF FUNDS 001. GENERAL FUND 71.0 POLICE PENSION FUND 720 FIRE PENSION FUND Totals 3,81.1. 1.5,241. 46,600 31.,359 67.3 286,1.02 1.,094,1.80 3,242,300 2,1.48,1.20 66.3 269,41.7 1.,038,093 3,1.21.,500 2,083,407 66.7 559,330 2,147,51.4 6,41.0,400 4,262,886 66.5 22 05/12/2010 10:40:57 FRRDBROl SUMon VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 04/30/10 4 Months 8 Months 33.3% 66.6% Completed Remaining Totals Cur Mo Y-T-D 2010 Unexpended Unexpended Expended Expended Budget Balance Percent 94,737 455,155 927,700 472,545 50.9 432,188 1,729,020 5,925,898 4,196,878 70.8 526,925 2,184,175 6,853,598 4,669,423 68.1 RISK MANAGEMENT PROGRAM TOTALS 01 CASUALTY & PROPERTY INSURANCE 02 MEDICAL INSURANCE EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 56 INSURANCE 67 OTHER EQUIPMENT Totals 0 0 2,000 2,000 100.0 526,925 2,184,175 6,851,598 4,667,423 68.1 0 0 0 0 526,925 2,184,175 6,853,598 4,669,423 68.1 SOURCE OF FUNDS 690 RISK MANAGEMENT FUND 526,925 2,184,175 6,853,598 4,669,423 68.1 Totals 526,925 2,184,175 6,853,598 4,669,423 68.1 23 05/12/2010 10:40:57 FRRDBROl SUM03l 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 04/30/10 NON-DEPARTMENTAL Cur Mo Expended 2010 Budget Y-T-D Expended PROGRAM TOTALS 01 CONTINGENCIES o o Totals o o EXPENDITURE CLASSIFICATION 80 INTERFUND TRANSFERS o o Totals o o SOURCE OF FUNDS 001 GENERAL FUND o o Totals o o 24 33.3% 66.6% Completed Remaining Unexpended Unexpended Balance Percent o o o o o o o o o o o o 05/12/2010 10:40:57 FRRDBROl SUM031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 04/30/10 CAPITAL FIXED ASSETS CUr Mo Expended o PROGRAM TOTALS 00 CAPITAL FIXED ASSETS Totals EXPENDITURE CLASSIFICATION 59 OTHER EXPENDITURES Totals SOURCE OF FUNDS 910 GENERAL FIXED ASSETS ACCT GP Totals 25 Y-T-D Expended 2010 Budget o o o o o o o o o o o o 33.3% 66.6% Completed Remaining Unexpended Unexpended Balance Percent o o o o o o o o o o o 05/12/2010 10:40:57 FRRDBROl SUM 031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 04/30/10 MOUNT PROSPECT LIBRARY CUr Mo Expended Y-T-D Expended Unexpended Unexpended Balance Percent PROGRAM TOTALS 02 LIBRARY SERVICES o Totals o EXPENDITURE CLASSIFICATION 90 COMPONENT UNIT EXPENDITURES o Totals o SOURCE OF FUNDS 950 MOUNT PROSPECT LIBRARY FUND o Totals o 26 2010 Budget o 9,715,689 o 9,715,689 o 9,715,689 o 9,715,689 o 9,715,689 o 9,715,689 33.3% Completed 66.6% Remaining 9,715,689 100.0 9,715,689 100.0 9,715,689 100.0 9,715,689 100.0 9,715,689 100.0 9,715,689 100.0 REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY MAYl12010 11: 44 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 29 2010 TO MAY 12 2010 - - - - - - - - -- - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - -- - - - - - - - -- - - - - - - - - - - - - - - - - - - -- - - - - - - -- - - - -- - - - - - - - - - - - - - ------ DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - -- - - - - - - - -- - - - - - - - - - - - - - - - - -- -- - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - -- - -- - - - - - - - -- - -- 001 02919 303 TAXI & FLASH CAB SENIOR TAXI PROG MARCH 2010 327 . 70 01071 ADDISON BUILDING MATERIAL CO. 4" CORRUGATED SNAP TEE & 4" 21.15 S. S. TOOTHBRUSH PLASTIC HANDLE 16.60 ------------- 37.75 01227 AIR ONE EQUIPMENT I INC. 50 - Thread Saver Caps for Air 223.50 50 - THREAD SAVER CAPS FOR AIR 0.01 ------------- 223.51 09380 AMERICAN BUILDING SERVICES HID CARDS FOR pI-ilEaC CARD ACCE 464.00 01561 AMERICAN CHARGE SERVICE SENIOR TAXI PROG MARCH 2010 45.00 01620 AMERICAN LANDSCAPING INC. VILLAGE HALL URN PLANTING FOR 743.00 09676 AMERICAN MESSAGING Monthl y Pager Rental 934.15 01699 AMERICAN PUBLIC WORKS ASSOC. OPEN HOUSE GIVEAWAYS. 715.00 10095 AMSAN, LLC 3M CORNERSTONE FLOOR FINISH/SE 106.00 09544 ANDRES MEDICAL BILLING, LTD APRIL 2010 AMBULANCE BILLING 3961. 44 08911 APPLIED CONTROLS, INC. REPLACEMENT OF HVAC CONTROLLER 688.50 01973 APWA CHICAGO METRO CHAPTER REGISTRATION FOR APWA FRONT-EN 300.00 02270 AT&T SERVICE 4/16/10-5/15/10 3.24 SERVICE 4/16/10-5II5/1O 10.79 SERVICE 4/16/10-5/15/10 2.16 SERVICE 4/16/10-5/15/10 3.24 SERVICE 4/16/10-5/15/10 21.53 SERVICE 4/16/10-5/15/10 10.79 SERVICE 4/16/10-5/15/10 41.00 SERVICE 4/16/10-5/15/10 10.79 SERVICE 4/16/10-5/15/10 16.18 SERVICE 4/16/10-5/15/10 28.05 SERVICE 4/16/10-5/15/10 8.63 SERVICE 4/16/10-5/15/10 8.63 SERVICE 4/16/10-5/15/10 38.84 SERVICE 4/16/10-5/15/10 219.02 SERVICE 4/16/10-5/15/10 214.71 SERVICE 4/16/10-5/15/10 13 8.1 0 SERVICE 4/16/10-5/15/10 331.81 ------------- 1107.56 10729 AUTUMN LANDSCAPING INC SPRINKLER MAINTENANCE PER REQU 496.00 04215 AUTUMN TREE CARE EXPERTS REMOVE GYPSY MOTH EGG MASSES F 8100.00 10128 BALDINI I CAROL REIMB EXP 4/20/10-4/21/10 57.26 REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY MAYll2010 11:44 RELEASE 10 : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 29 2010 TO MAY 12 2010 DEPT VENDOR NBR VE N DO R NAME INVOICE DESCRIPTION AMOUNT 10540 BATTERIES PLUS ASSORTED BATTERIES 202.80 02795 BESTHOFF, LANCE REIMB EXP 4!l9/10-4/24/1O 40.00 05707 CASH LIONS CLOB DONATION-OP HOUSE 1100.00 01049 COW GOVERNMENT, 1NC CISCO SMARTNET FOR 3550-48E - 900.00 CISCO SMARTNET FOR 28lI - COW 399.48 ------------- 1299.48 05375 CENTURY CLEANERS UNIFORM CLEANING 4/24-5/6/10 113 .10 UNIFORM CLEANING 4/23-4/27/10 32.75 UNIFORM CLEANING 4/30 & 5/7 26.10 ------------- 171.9 5 01077 CHICAGO COMMUNICATIONS LLC REPAIR VHF RADIO FROM V#546 217 . 40 08975 CHICAGO OFFICE TECHNOLOGY GROUP STAPLES 130.00 01084 CHICAGO TRIBUNE 2ND QTR 2010 SUBSCRIPTION 74.75 07281 CL GRAPHICS, INC. BLUES/ARTS FESTIVAL&BLOCK PART 547.88 PRINTING/!NVITE AND ENVELOPES 398.00 ------------- 945.88 1I403 COSTAR REALTY INFORMATION, INC ED SITE SOFTWARE 435.00 12188 COSTELLO, PHYLLIS REAL ESTATE TAX REBATE 2010 518.00 1I408 CRYSTAL COURT SHOPPING CENTER MAY 2010 RENT & WATER 3358.00 05503 CRYSTAL MAINTENANCE SERVICES CORP. CCC SHARE OF MONTHLY CLEANING 590.00 CUSTODIAL SERVICE AT VILLAGE 7529.44 ------------- 8119.44 01218 DAHLBERG, JOHN REIMB EXP4/14, 4/16, 4/22-23, /26 97.45 03916 DECATUR ELECTRONICS, INC. RADAR REPAIR, PARTS & CERTIF. 352.05 RADAR REPAIR, LABOR & CERTIF 457.50 ------------- 809.55 05154 EMSAR CH I CAGO #SI -14088 MAINT.SERVICE 741.20 #SI -14089 MAINT .SERVICE 170.44 ------------- 911.64 09653 ETERNO, DAVID G. SERVICE 4/28/10-4/29/10 312.00 01366 EXPERIAN BACKGROUND CHECKS APRIL 2010 77 .24 10393 EXPERTPAY PAYROLL FOR - 050610 3202.90 REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY MAYll2Ol0 11: 44 RELEASE 10 : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 29 2010 TO MAY 12 2010 - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - -- - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - -- - - - - - - -- - - - - - - - - - - - - -- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT -- - - - - - -- - -- - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - -- - - - -- - - - - - -- - -- - - - -- - - - - - - - - - - - - - - -- - - - - - - - - - -- -- 11212 FDC DIGITAL IMAGING SOLUTIONS ANNUAL MAINTENANCE FOR KI P PLO 59.00 01377 FEDERAL EXPRESS CORP SHIPPING CHARGES. 47.49 00331 FIGOLAH, MICHAEL RE1MB EXP 3/12/10 99.00 00102 FIRE PENSION FUND PAYROLL FOR - 050610 21566.64 12170 FORENSIC ENTOMOLOGY WORKSHOPS REGISTER - T. HOSKINSON 225.00 11512 FRANK CURTIS ATTRACTIONS RENTAL FEE-ART/BLUES FEST 2010 3000.00 06411 FRIEDMAN, CHAYA UPDATES HUMAN SERV DATABASE 125.00 12162 GANKO, CHRISTINE REFUND OVER PYMT VEHICLE L. FEE 24.00 09198 GE CAPITAL SERVICE 4/15/10-5/14/10 192.74 SERVICE 4/15/10-5114/10 192.74 SERVICE 4/15/10-5114/10 192.74 SERVICE 4/15/10-5/14/10 192.74 ------------- 770.96 01522 GRAINGER INC. LOOPED END FINISH MOP; FEATHER 76.47 06420 GRAYBAR ELECTRIC CO. PW FUEL ISLAND QUARTZITE BOXES 481.08 1217 6 HALL, DON & DONNA REFUND VEHICLE LICENSE FEE 54.00 09113 HEALY ASPHALT COMPANY,LLC. 6.4 TONS OF UPM ASPHALT PATCH 691.20 0.43 TONS UPM ASPHALT PATCH 23.65 0.97 TONS UPM MATERIAL DELIVER 53.35 ------------- 768.20 01610 HOME DEPOT CREDIT SERVICES #5082416 1 MISC FITTINGS #546 19.44 #3232021 TRAINING SUPPLIES 20.70 #4232019 TRAINING SUPPLIES 291.00 ------------- 331.14 00349 HOSKINSON, THOMAS REIMB EXP 4119/20-4/23/10 40.00 09425 HSBC BUSINESS SOLUTIONS BATTERIES/ FPB 41. 97 SUPPLIES FOR EOC 19.47 SUPPLIES FOR EOC 14.12 SUPPLIES FOR EOC 14.11 SUPPLIES FOR EOC 14.11 SUPPLIES FOR EOC 14.11 SUPPLIES FOR EOC 14.11 SUPPLIES FOR EOC 14.11 SUPPLIES FOR EOC 14.11 SUPPLIES 3.70 DVD/PHOTO PLAYER 119.99 PROMOTIONAL TEST /PASTRY /DRINKS 43.98 KITCHEN SUPPLIES 15.87 REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY MAYll2Ol0 11:44 RELEASE 10 : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 29 2010 TO MAY 12 2010 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - --- - -- - - - - - - - - - - --- -- - - - - - - - - -- -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- -- - - -- - - --- - - -- KITCHEN SUPPLIES 8.15 KITCHEN SUPPLIES 4.83 2 MONITORS PATROL 388.10 ------------- 144.84 10108 HUFFMAN LANDSCAPE ONE - 5' 'TWOMBLEY I S RED SENTI 1200.00 04121 HAC 2010 MEMBERSHIP DUES 50.00 00101 ICMA RETIREMENT TRUST - 451 PAYROLL FOR - 050610 20004.42 09561 10 NETWORKS,INC. ANNUAL SERVICE MAINT. 5/1-4/30 10041.00 04671 !LCA ANNUAL CLASS G MEMBERSHIP DUES 395.00 01658 ILCMA REGISTRATION 6/9/10-6/11/10 240.00 08450 !LEAS 2010 ANNUAL MEMBERSHIP DUES 150.00 06690 ILLINOIS AMERICAN WATER CO. PRIVATE FIRE SERVICE 28.28 00108 ILLINOIS DEPARTMENT OF REVENUE PAYROLL FOR - 050610 23816.38 09562 IMRF PAYROLL FOR - 050610 438.54 PAYROLL FOR - 050610 42031.11 PAYROLL FOR - 050610 19339.75 ------------- 61810.06 09889 INFECTION CONTROL/EMERGING CONCEPTS, INC. Registration/Se1een, Wendy Apri 595.00 10211 INFO-TECH RESEARCH GROUP INFO-TECH ANNUAL 5/25-5/25/11 495.00 01143 INTERNATIONAL ASSOCIATION OF FIRE CHIEFS MEMBERSHIP 2010-TRUTY,CHRIS 184.00 GREAT LAKES DIV. DUES 20.00 MEMBERSHIP 2010-r~ALCOLt~,JOHN I'\l'\tl "n U,.VV ------------- 433.00 09832 INTERNATIONAL UNION OF OPERATING ENGINEERS PAYROLL FOR - 050610 964.16 PAYROLL FOR - 050610 211 .20 ------------- 1241.96 09563 IRS PAYROLL FOR - 050610 183446.40 00353 maNIS, MICHAEL E. REIMB EXP 4/15/10 35.34 REIMB EXP 5/3/10 36.91 ------------- 12.31 12183 JOBSKI, KRISTIN REFUND VEHICLE LICENSE FEE 189.00 05136 JUHL, JONATHP.N REIMB EXP 4/12/10-4/16/10 40.00 0I8l8 KERSTEIN, JUNE REIMB EXP 3/10 & 5/10 66.28 REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY MAY1l2010 11:44 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 29 2010 TO MAY 12 2010 - - - - -- - - - -- - - - - - - - - - - - -- - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - --- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- --- - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - -- - - - - - - - - - - - -- - - - --- - - - - - - - - - - - - - - - - - - - - - -- 12182 KI EL, ADAM REIMB EXP 5/5/10 38.30 01827 KLEIN I THORPE AND JENKINS, LTD. GENERAL LEGAL EXP - MARCH 2010 43077.30 01838 KRAMER TREE SPECIALISTS TREAT 11 AUSTRIAN PINES FOR 124.50 SPRAY TREATMENTS TO CONTROL GY 225.00 ------------- 349.50 12159 KUHN, JOHN J. REFUND VEHICLE LICENSE FEE 36.00 01858 LAKE-COOK LAND SURVEY TREE LOCATION SURVEY 2721.5 0 00374 LAWRIE, MATT REIMBURSEMENT FOR MANUAL ON 100.00 08631 LECHNER AND SONS PW UNIFORM RENTAL AND CLEANING 238.23 10450 LEXISNEXIS RISK DATA MANAGEMENT INC BACKGROUND CHECKS - APRIL 2010 53.20 12185 LINDENMEYR MUNROE REVERSE FLAP ENVELOPES 123 3.15 01918 LUNDSTROM'S NURSERY I INC. LANDSCAPE MAINTENANCE AT VARIO 3071. 42 PLOW DAMAGE REPAIR SERVICES 3750.00 $750.00 PER 8 HOUR DAY FOR A T 3750.00 ------------- 10571.42 01939 MAJOR CASE ASSISTANCE TEAM (10) ATTENDEES MCAT AWARDS 200.00 01941 MALCOLM, JOHN REIMB EXP 4/14/10 53.89 05021 MENARDS BRICK SEALER. 6.59 CATCH BASIN/ INLET REPAIR SUPP 24.42 ELECTRICAL SUPPLIES. 44.86 1 BOX OF GALVANIZED NAILS; 10' 32.43 ------------- 108.30 01502 MES- ILLINOIS 4 - 12 Rit Bags 185.00 00116 METRO FEDERAL CREDIT UNION PAYROLL FOR - 050610 2493.48 00117 METROPOLITAN ALLIANCE - POLICE PAYROLL FOR - 050610 1018.00 00396 MILLER, JAMES REIMB EXP 4/12/10 80.29 02046 MOBILE PRINT INC. BUSINESS CARDS-B. SCHROEDER 48.50 MEMO PADS:A.ADDANTE 51. 41 BUSINESS CARD-M. FIGOLAH 50.44 ------------- 150.35 02127 NhTIONAL FIRE SPRINKLER ASSOC. MEMBERSHI P20 1 0- LOOMI S, BRYAN 85.00 00123 NATIONWIDE MUTUAL INSURANCE COMPANY PAYROLL FOR - 050610 16394.91 REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY MAYll2Ol0 11:44 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 29 2010 TO MAY 12 2010 -- - - - - --- - - - - - - --- - - - -- - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - -- - - - - - - -- - - -- - - - - -- - - ----- - - - - - - - - - - --- --- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - - - - - - - -- -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - -- - - - - - - - - - -- - - - - - - - -- - - - - - - - - -- -- - - - - - - - - -- - -- - - - -- - -- - - - - - - -- - - - - -- 02155 NEXTEL COMMUNICATIONS SERVICE 3/18/10-4/17/10 663.16 SERVICE 3/18110-4/17110 106.10 SERVICE 3/18/10-4/17/10 100.88 SERVICE 3/18110-4/17/10 497.78 SERVICE 3/18/10-4/17110 28.08 SERVICE 3/18/10-4/17/10 167.10 SERVICE 3/18/10-4/17/10 55.20 SERVICE 3/18/10-4/17/10 1292.93 SERVICE 3/18/10-4/17/10 222.74 SERVICE 3/18/10-4/17/10 306.35 SERVICE 3/18 /10-4/17 /10 26.75 SERVICE 3/18/10-4/17/10 356.68 NEXTEL 576 PHONES 27 .98 ------------- 3851.73 05256 NICOR ACCT#97789028004 3/22-4/22/10 102.84 ACCT#03357799265 3/22-4/22/10 44.12 ------------- 146.96 07549 NORTHEASTERN ILL. PUB. SAFETY TRNG. REGI STRAT I ON / 0 4 - PASTORI I MATT 450.00 05843 NORTHSHORE OMEGA NIPAS PHYSICAL:M.MEISTER 547.00 02189 NORTHWEST CENTRAL DISPATCH SYS JUNE 2010 MEMBER ASSESSMENT 36767.60 JUNE 2010 MEMBER ASSESSMENT 9191. 90 ------------- 45959.50 02192 NORTHWEST COMMUNITY HOSPITAL ADMIN. FEE 4TH QUARTER 02-03-04 875.00 02197 NORTHWEST POLICE ACADEMY 2010 ANNUAL MEMBERSHIP DUES 50.00 02228 OAKTON PAVILLION HEALTHCARE 659 HOME DELIVERED MEALS-4110 2636.00 10163 ON TIME INC. T-SHIRTS 275.00 UNIFORM SUPPLIES 179.00 ------------- 454.00 10162 OVERHEAD GARAGE DOOR, INC. REPAIR TO SECTIONAL DOOR AT FI 229.12 10476 PACIFIC TELEMANAGEMENT SERVICES PAY PHONE SERVICE MAY 2010 78.00 02256 PADDOCK PUBLICATIONS 4 - BID NOTICES [SEWER SPOT 99.90 BIKE PLAN LEGAL PUBLISHED 52.65 IHDA 1ST HOME BUYER PROG PUB. 179.55 ------------- 332 .10 10366 PARK RIDGE TAXI SENIOR TAXI PROGRAM APRIL2010 134.40 12168 PATEL, SHOBHANA & HAREN REFUND BUILDING PERMIT#09-2281 25.00 12171 PATEL, SURESHBHAI H REFUND OVER PYMT- SENIOR RATE 24.00 REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY MAY1l2010 11:44 RELEASE 10 : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 29 2010 TO MAY 12 2010 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT -- - - - - -- - - - - - - - - - - - - - - -- - - - - - - -- - - - - - - - - -- - -- - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - --- 06591 PERMA SEAL BASEMENT SYSTEMS REFUND SEWER REPAIR 2010-316 39.60 00124 POLICE PENSION FUND PAYROLL FOR - 050610 26609.93 12179 POMURAN, VLADIMIR REFUND DUPLICATE PYMT 36. DO 04921 POPE, ELIZABETH A. PAYROLL FOR - 050610 923.08 12177 PRINTER RIBBONS PLUS INC TONER FOR PHOTO PRINTER 132.50 02536 PROFORMA CUSTOMIZED GRAPHICS OPEN HOUSE GIVE-AWAYS 665.49 02358 PROSAFETY, INC 24 CASES OF WHITE PAINT; 1000- 114.8 0 02379 QUILL CORPORATION OFFICE SUPPLIES. 65.76 BUILDING DEPT. OFFICE SUPPLIES 21.43 ------------- 87.19 00412 RANDOLPH, DANIEL SAFETY SHOE REIMBURSEMENT. 128.40 09541 RBR PRODUCTIONS INC. IN CASE OF DISASTER DVD 250.00 02401 RED WING SHOE STORE SAFETY SHOE PURCHASE - KEVIN 114.99 05929 RESOURCE MANAGEMENT ASSOC. FIRE LIEUTENANT ASSESSMENT C. 5244.10 m02 ROTARY CLUB OF MT. PROSPECT-PROSPECT HEIGHTS ROTARY DUES JAN2010-MARCH2010 137 . 00 ROTARY MAGAZINE 3.00 ------------- 140.00 12172 SACKETS HARBOR CENTRAL SCHOOL MEMORIAL GIFT-GARRETT LOOMIS 60.00 02524 SEARS COMMERCIAL ONE ACCOUNT N95 PARTICLE RESPIRATOR MASK 64.71 02525 SECRETARY OF STATE TITLE & PLATES FOR I -60 194.00 12085 SECURITY RESEARCH INC BACKGROUND CHECKS-VOLUNTEERS 50.00 11846 SHEAGREN, KIMBERLY REIMB EXP 4/29/10 68.85 12178 S IMUNITION REGISTER- B. TWEEDIE 6/15-6/17 595.00 12156 SIU SCHOOL OF MEDICINE REGISTER-B .ARCISZEWSKI 5/12/lO 25.00 02155 SPRINT SERVICE 3/24/10-4/23/10 39.99 09165 STAPLES BUSINESS ADVANTAGE TONER 166.99 SUPPLIES 4.79 ------------- 171.7 8 02619 STAT TECHNOLOGIES, INC. LIPID PROFILE TEST CASSETTES 340.07 02627 STEINER ELECTRIC CO. LIGHTS FOR POLICE FRONT DESK 659.49 REPORT: APBOARDRPT GENERATED; 15 APR 09 11: 42 RUN: TUESDAY MAYll2010 11:44 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 29 2010 TO MAY 12 2010 - - - - - - - - -- - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - -- - - - - - - - - - - - - - --- - - - - - - - - - -- - - - - - - - - - - - - - - - - -- - - -- - - - - - - - - - - - - - - - -- - - - - -- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - -- - - - - - - - - - - -- - - - -- - - - - - - - - - - - - -- - - -- - - - - - ---- -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - --- 00441 STRAHL, DAVID ADVANCE 2010 ILCMA CONF. 355.35 02672 SYSTEMS FORMS / INC. #15366 AUDIT SUPPLIES 195.40 #15367 AUDIT SUPPLIES 221.00 ------------- 416.40 11992 TELVENT DTN, INC ANNUAL wEATHER FORECASTING 894.00 11014 THE LEAD INSPECTORS, USA INC LEAD-BASED PAINT INSPECTION 175.00 01910 TRI -STATE HYDRAULIC INC. 101-100H09 CHARRLYNN HYDRAUL 1991.13 11261 TUCKER, TOM REIMB EXP 4/22/10 & 4/29/10 45.00 REIMB EXP 4/30/10 4.90 REIMB EXP SEMINAR 5/7/10 30.00 ------------- 79.90 11277 TYGRIS VENDOR FINANCE, INC SERVICE 4/24/10-5/23/10 467.29 SERVICE 4/24/10-5/23/10 321.91 SERVICE 4/24/10-5/23/10 456.90 SERVICE 4/24/10-5/23/10 830.73 SERVICE 4/24/10-5/23/10 16.80 SERVICE 4/24/10-5/23/10 16.80 SERVICE 4/24/10-5/23/10 16.80 SERVICE 4/24/10-5/23/10 16.80 SERVICE 4/25/10-5/24/10 372.46 ------------- 2516.49 07526 UNITED PARCEL SERVICE 2010 TRAFFIC SAFETY CHALLENGE 29.32 SHIPPING CHARGES EQUIP REPAIRS 37.74 ------------- 67.06 00121 UNITED WAY PAYROLL FOR - 050610 374.91 07860 UPS STORE #3057 INV#00000003293 3/10/10 19.93 INV#OOOOooomo 3131/10 11.59 ------------- 31.52 12001 US BANK 5/20/10 USAGE 195.00 5/20/10 USAGE 265.00 5/20/10 USAGE 275.00 5/20/10 USAGE 195.00 5/20/10 OSAGE 156.00 5/20/10 OSAGE 137 . 50 ------------- 1223 .50 10531 VCG UNIFORM Various uniform items per clot 528.45 08459 VILLAGE OF CAROL STREAM REGISTER-M. JOLIE / D. OLLECH&B. T 900.00 00128 VILLAGE OF MOUNT PROSPECT PAYROLL FOR - 042410 414.47 RUN: TUESUAY MAYI12010 11:44 RELEASE 10 : REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 DEPT VENDOR NBR 04314 m80 12163 02835 12173 06001 05746 030 02270 02536 050 om5 05709 070 01377 09198 01827 11277 380 06752 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 29 2010 TO MAY 12 2010 VENDOR NAME INVOICE DESCRIPTION PAYROLL FOR - 050610 PAYROLL FOR - 050610 VILLAGE OF MOUNT PROSPECT - PAYROLL WIRES PAYROLL FOR - 042410 VILLAGE OF WESTMONT REGISTER- A. ADDANTE WANG, TOM REIMB EXP 4/17/10 WAREHOUSE DIRECT #716736-0 SUPPLIES #718122-0 SUPPLIES WIDERA, JOHN W. REAL ESTATE TAX REBATE 2010 WINKLER I S TREE SERVICE 2010 PARKWAY TREE TRIMMING PRJ WISCTF PAYROLL FOR - 050610 TOTAL 599879.80 542.48 AT&T SERVICE 4/16/10-5/15/10 PROFORMA CUSTOMIZED GRAPHICS RECYCLED SUPPLIES TOTAL 929.32 925.00 COOK COUNTY TREASURER 2010 TRAFFIC SIGNAL MAINTENANC MEADE ELECTRIC CO. INC. 2010 EMERGENCY & PREVENTATIVE TOTAL 4579.58 1839.08 FEDERAL EXPRESS CORP FED EXP SHIPPING 4/20/10 GE CAPITAL SERVICE 4/15/10-5/14/10 KLEIN, THORPE AND JENKINS, LTD. CDBG LEGAL SERV - MARCH 2010 TYGRIS VENDOR FINANCE, INC SERVICE 4/24/10-5/23/10 TOTAL 2632.60 16.80 ILLINOIS ENVIRONMENTAL PROTECTION AGENCY PRINCIPAL PAYMENT INTEREST PAYMENT PRINCIPAL PAYMENT INTEREST PAYMENT PAGE AMOUNT 26376.76 12257.16 39048.39 462.61 945.00 48.80 165.21 19.25 184.46 748.00 3547.49 4.32 2740.50 23.86 192.74 2399.20 1lO394.47 17858.42 32094.90 8281.39 168629.18 REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY MAY112010 11:44 PAGE 10 RELEASE 10 : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 29 2010 TO MAY 12 2010 - - - - - - - - -- - - - - - - - - - - - - -- - - - - - - - - ---- - -- - - - - -- - - - - - - - - - - - - - - - -- - - - - - - - - - -- - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - -- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT -- - - - - - -- - - - -- - - - - - - - - --- - - - - - - - -- - - --- - - - - - - -- - -- - - - -- - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- -- TOTAL 168629.18 510 09380 AMERICAN BUILDING SERVICES OVERAGE PO#S010080 200.00 SUPPLY AND INSTALL 4 INTERIOR 3506.28 ELECTRIFIED LOCKSET CARD ACCES 247.00 PROXIMITY CARD ACCESS READER F 1672.00 ------------- 5625.28 01020 CAMP DRESSER & MCKEE INC. CONSULTING SERVICES 6157.00 10554 DALLAS, MICHAEL REIMB EXP 4/15/10 35.39 04434 GEWALT HAMILTON ASSOCIATES, INC. KENSINGTON RD IMPROV PYMT #10 12536.56 09425 HSBC BUSINESS SOLUTIONS 3 MONITORS FRONT DESK 568 .10 11970 NEW WORLD SYSTEMS CORPORATION ERP SOFTWARE APPLICATIONS - VB 5674.39 10162 OVERHEAD GARAGE DOOR, INC. INSTALLATION OF 2 ELECTRIC EYE 3000.00 11788 PLANTE & MORAN, PLLC ERP SYSTEM CONSULTING SERVICES 3270.00 07964 RMS TECHNOLOGY SOLUTIONS CISCO 3560 G POE SWITCH 3605.00 SMART NET 8X5XNBD 346.00 INSTALLATION & CONFIGURATION 370.00 ------------- 4321.00 TOTAL 41187.72 528 11828 ACCURATE TANK CONSTRUCTION REMOVE & REPLACE 3 OIL TANKS 436 4.0 0 P. W. FUEL ISLAND NETWORK CARD. 600.00 ------------- 4964.00 02983 BUCOM INC. Move Radio Equipment from the 3379.70 118 58 BUSINESS OFFICE SYSTEMS, INC Task Lighting for Fire Station 2445.60 Task Lighting for the EOC 917 .10 ------------- 3362.70 01049 COW GOVERNMENT, INC 1 TELEPHONE WALL MOUNT-EOC 32.34 5 TELEPHONE WALL MOONTS-#14 129.06 SPEAKERS FOR STATION#14 111.2 4 ------------- 272.64 00331 FIGOLAH, MICHAEL REIMB EXP 4/21110 31.13 01522 GRAINGER INC. #9225167551 BULLETIN BOARD 143.76 #9223993370 ENTRY FLOOR MAT 39.92 #9229627295 VINYL HAMPER 28.04 #9226725894 (8)RECYCLING CANS 56.72 REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESUAY MAYllZOI0 11:44 RELEASE I D : PAGE 11 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 29 2010 TO MAY 12 2010 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - -- - - - - - - - -- - - - - -- - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - -- - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - -- - - - - - -- - - - - - - - - - - - - - - --- - -- - - -- - - -- #9227175446 (8)GARBAGE CANS 160.7Z #9228772928 (2) JANITOR CARTS 351.00 #9230518707 SOAP/LOTION 214.34 #9231007361 RETURN LOTION 108.82- #9231007353 HAND SOAP 153.50 #9231007346 HAMPER STAND 28.58 #9231601429 HAND SOAP 76.75 ------------- 1144.51 01610 HOME DEPOT CREDIT SERVICES #3086183 SUPPLIES 4 TV MOUNTS 11.84 #2064285 SUPPLIES 4 TV MOUNTS 70.78 #7079809 CLEANING SUPPLIES #14 68.98 #8065123 MAILBOX STATION#14 79.62 #1078226 SUPPLIES PRINTER #14 52.64 CREDIT#1295406 20.94- #6571582 A/V CABLE STATION#14 9.96 #6584985 A/V SUPPLIES #14 14.43 #6070137 MISC SUPPLIES #14 54.47 #6088497 FLOOR MAT & A/V CABLE 11.26 #5088950 VACUUM CLEANER&SUPPLY 425.20 #6562771 CARBONM. ALARMS- #14 79.94 #2077936 ELECTRICAL SUPPLIES14 206.84 #2077936 RETURN 110.00- ------------- 955.02 09425 HSBC BUSINESS SOLUTIONS 3 TV MOUNTS - STATION#14 399.97 1 TV MOUNT - STATION#14 109.99 1 TV MOUNT RETURNED 199.99- GLASSES,DISHES,COOKWARE -ST#14 327.95 5 TV'S - STATION#14 5149.95 2 TV'S RETURNED 1699.98- 2 TV'S - STATION#14 1059.98 ------------- 5147.87 12006 LAUNDRY CONCEPTS, INC BASE NEIi liASHER AT STATION#14 365.00 1lZ55 LEO PARDO COMPANIES, INC EOC - Construction 12249.00 Fire Station #14 Construction 193616.00 Modifications at Public liorks 844.00 ------------- 206709.00 05021 MENARDS HOLE SAIi INSTALLATION ST# 14 13.48 05256 NICOR SERVICE 3/22/l0-4/ZZ/lO 861.66 09423 RONCO INDUSTRIAL SUPPLY liILTON #17 65 TRADESMAN VISE. 7Z5.96 FREI GHT 10.00 EQUIPTO #275U6 liORKBENCH. 865.10 APP. COST OF ALL SHIPPING COST 221.00 ------------- 1822.06 06406 SRBL ARCHITECHTS, LTD. Architectural Services for Fir 14827.47 REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY MAY112010 11 :44 RELEASE ID : PAGE 12 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 29 2010 TO MAY 12 2010 -- - - - - - - - - - - - - - - - - - -- - - - - - - - - - -- - - - - - - - - - - - - -- - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - -- - - - - - -- - - - - - - -- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - -- - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - -- -- - - - - -- - - -- - - - - - - - - - - - - - - - - - - --- - - -- - -- -- -- -- - - - - - - - - - - - - - - - -- 04951 SUBURBAN ACCENTS INC. INSTALL RED VINYL ON GAS DISPE 560.00 02622 THE STATE FIRE MARSHAL REGISTRATION/04 STATION#14 ELV 30.00 12050 WORKROOM INC DRAPES 4 BUNK ROOM AT ST# 14 1185.25 TOTAL 245631.49 550 01B27 KLEIN, THORPE AND JENKINS,LTD. TIF LEGAL SERV - MARCH 2010 12255.94 01918 LUNDSTROM I S NURSERY, INC. LANDSCAPE MAINTENANCE AT VARIO 7344.69 TOTAL 19600.63 560 02167 ARROW ROAD CONSTRUCTION 2010 STREET RESURFACING PROG 160B19.00 TOTAL 160819.00 610 04493 A LAMP CONCRETE CATCH BASIN & INLET REPAIR 19920.39 CATCH BASIN & INLET REPAIR 14113.11 ------------- 34033.50 12187 ACTION FENCE CONTRACTORS INC FURNISH&INSTALL SAFETY EDGES 1141.20 01620 AMERICAN LANDSCAPING INC. SOD RESTORATION AT VARIOUS SIT 9526.56 SOD RESTORATION AT VARIOUS SIT 5715.94 #2010-1071 PARKWAY RESTORATION 4935.00 #2010-1072 COMBINED SW REPAIR 3786.00 SOD RESTORATION AT VARIOUS SIT 4798.44 SOD RESTORATION AT VARIOUS SIT 2879.06 ------------- 31641.O0 01773 AMERICAN WATER WORKS ASSOC. G400 STANDARD BINDER. 57.50 AWWA MEMBERSHIP RENEWAL FOR 10 7S. 00 ------------- 132.s0 02270 AT&T SERVICE 4/16/10-5/15/lO 2BB.OB 02270 AT&T LONG DISTANCE SERVICE 3/15/10-4/2/10 3.35 12161 BEAR COMMUNICATIONS, INC REPAIR OF COMMUNICATIONS ANTEN BOO. DO 06476 BURNS & MCDONNELL ENGINEERING DESIGN ELEVATED TANK PIPING 13654.20 01049 COW GOVERNMENT, INC INDESIGN PUBLISHING SOFTWARE. 625.00 05375 CENTUR Y CLEANERS UNIFORM CLEANING 4/24-5/6110 113.1 0 UNIFORM CLEANING 4/23-4/27/10 32.75 UNIFORM CLEANING 4130 & 5/7 26.10 ------------- REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY MAYl12010 11:44 PAGE 13 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 29 2010 TO MAY 12 2010 - - - - - - - - - -- - - - - - - - - - - - - - -- - - - - - - -- - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - -- -- -- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT -- - - - --- - - - - - - - - - - - - -- - -- - - - - - - - -- - - - - - - - - -- - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - -- 171.95 11801 CHICAGO SWITCHBOARD CO. INC. LABOR AND EQUIPMENT TO INSTALL 699.00 LABOR AND EQUIPMENT TO INSTALL 408.00 ------------- 1107.00 01147 COMMONWEALTH EDISON ELECTRICAL SERVICE DELIVERY AT 27 3.0 8 06112 CURRAN, SEAN REFUND FINAL UTILITY BILL 23.09 09052 DEFRANCO PLUMBING ANNUAL TEST & CERTIFICATION OF 811.00 12062 FRAZIER CONCRETE, INC CONCRETE RESTORATION CONTRACT 6091.68 CONCRETE RESTORATION CONTRACT 8302.87 CONCRETE RESTORATION CONTRACT 282 3.8 5 CONCRETE RESTORATION CONTRACT 1616.00 ------------- 18834.40 12184 GOLF PLAZA 1 REFUND FINAL UTILITY BILL 105.00 01544 HBK WATER METER SERVICE WATER METER 1654.80 BUILDING INSPECTION SERVICES. 551.60 ------------- 2206.40 09883 HD SUPPLY WATERWORKS, LTD. 6" MUELLER MJ TO MJ GATE VALAV 3560.00 8" MUELLER MJ TO MJ GATE VALVE 1392.00 6" FLANGE ACCESSORY KITS. 72.00 8" FLANGE ACCESSORY KITS. 20.00 ANTI -ROTATIONAL BOLTS. 25.00 ------------- 5069.00 12167 HERT Z, JANET REFUND FINAL UTILITY BILL 19.32 08631 LECHNER AND SONS PW UNIFORM RENTAL AND CLEANING 238.19 06994 LEE JENSEN SALES CO. INC. STIHL TS420 CUT OFF SAWS. 850.00 STIHL TS420 CUT OFF SAWS. 850.00 ------------- 1700.00 01965 MARTAM CONSTRUCTION HAULING DIRT&GRAVEL 4/20-4/22 3049.30 HAULING DIRT&GRAVEL 4/20-4/22 1227.75 HAULING DIRT&GRAVEL 4/20-4/22 1254.47 ------------- 5531.52 02155 NEXTEL COMMUNICATIONS SERVICE 3/18/10-4/17/10 440.29 SERVICE 3/18/10-4/17/10 52.70 NEXTEL EQUIPMENT CHARGES 99.98 ------------- 592.97 05256 NICOR GAS SERVICE DELIVERY AT 117 N. 107.35 REPORT: APBOARDRPT GENERmD: 15 APR 09 11:42 RUN: TUESDAY MAYll2010 11:44 RELEASE 10 : PAGE 14 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 29 2010 TO MAY 12 2010 - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - -- - - - - - - - - - - -- -- - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- -- - - - - - - - - - - - - - - - -- -- -- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - - - - - - - - - - - - - - --- - - --- - - - - - - -- - - - -- - - - - - - - - --- - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - -- - - -- - - - - - - --- 02256 PADDOCK PUBLICATIONS 4 - BID NOTICES [SEWER SPOT 144.45 12165 PAPS CAFE LTD REFUND FINAL UTILITY BILL 6.44 02287 PEERLESS MIDWEST INC m216 LIFT STATION EMERGENCY 5100.00 #28217 LIFT STATION EMERGENCY 7598.00 #28219 LIFT STATION EMERGENCY 5790.00 ------------- 18488.00 02536 PROFORMA CUSTOMIZED GRAPHICS OPEN HOOSE GIVE-AWAYS 1538.35 OPEN HOUSE GIVE-AWAYS 490.24 REPLACEMENT INVENTORY 780.00 ------------- 2808.59 12166 SCHOVANEC / A J REFUND FINAL UTILITY BILL 30.00 07487 SEILER INSTROMENT & MFG. CO. INC. GEO EXP SERIES SUPPORT MODULE. 125.08 GEO EXP 2008 SERIES POWER SUPP 56.00 ------------- 181.08 04838 THIRD MILLENNIUM ASSOC. INC. APRIL 2010 UTILITY BILLING 1257.74 12001 US BANK 5/20/10 USAGE 137 . 50 12164 VOLLMAR, JUD ITA REFUND FINAL UTILITY BILL 12.88 02914 ZIEBELL WATER SERVICE PRODUCTS ROAD BOX ASSEMBLY. 265.00 ACCESSORY KITS FOR VALVES. 156.00 COPPER TUBING; BRASS NIPPLES; 726.68 ------------- 1147.68 TOTAL 143m.46 620 05503 CRYSTAL MAINTENANCE SERVICES CORP. CUSTODm SERVICE .~T VILLAGE 1481.40 TOTAL 1481.40 630 02927 BOESCHE, JAMES REPAIR OF MASONRY WALLS ON 1800.00 01147 COMMONWEALTH EDISON ELECTRICAL SERVICE DELIVERY AT 179.93 ELECTRICAL SERVICE DELIVERY AT 125.07 ------------- 305.00 05503 CRYSTAL MAINTENANCE SERVICES CORP. CUSTODIAL SERVICE AT VILLAGE 189.16 12186 MARK, KATHRYN REFUND METR.~ P.~RKING 4/26110 5.00 Tom 2299.16 REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY MAY1l2010 11: 44 PAGE 15 RELEASE 10 : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 29 2010 TO MAY 12 2010 - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - -- - - -- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - -- - ---- - - - - - -- - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - -- 660 01071 ADDISON BUILDING MATERIAL CO. BLACK PAINT, BRUSHES FOR VEHIC 43.41 0Il87 AETNA TRUCK PARTS TIRE REPAIR SUPPLIES. 192.74 02070 ARLINGTON HEIGHTS FORD FORD REPLACEMENT AND REPAIR PA 771.78 02270 AT&T SERVICE 4/16/10-5/15/10 10.79 02938 BOWMAN DISTRIBUTION CENTER SHOP SUPPLIES. 560.90 10632 CHICAGO PARTS & SOUND LLC MOTOCRAFT SQUAD PARTS FOR CROW 1655.16 01236 DAVE & JIM'S AUTO BODY, INC. REPAIRS TO VEHICLE #4534. 916.70 11237 DULTMEIER SALES DAVENPORT INC WASH BAY NOZZLES. 22.65 01431 FOSTER COACH SALES INC. SLIDING WINDOW FOR #52l. 52.13 06691 JUST TIRES NEW TIRE FOR #4555. 71.50 02089 MUNICIPAL FLEET MANAGERS ASSOCIATION FORD ANTI -THEFT/PASSIVE RESTRA 68.00 02107 NAPA-HEIGHTS AUTOMOTIVE SUPPLY FRONT BRm PADS. 5.05 LADDER BULBS FOR FIRE TROCK #5 41.98 ------------- 47.03 02155 NEXTEL COMMUNICATIONS SERVICE 3/18/1H/17 /lO 240.39 02327 POMP'S TIRE SERVICE, INC. 2 REAR TIRES INSTALLED FOR 118.00 07663 PR.~IRIE INTERNATIONAL TRUCK SALES EXHAUST P,~RTS FOR VEHICLE #272 610.56 07882 PRECISION SERVICE & PARTS FUEL FILTER FOR FIRE TRUCK #52 53.88 OEM POLICE IMPALA BRAKE PADS. 321.34 AIR CONTROL VALVE. 74.30 HYBRID ESCAPE OIL FILTER. 74.16 IDLE AIR CONTROL FOR VEHICLE # 85.48 ------------- 609.16 02684 TERRACE SOP PLY COMPANY G,!.S TANK RENTAL. 22.34 02791 VEHICLE MAINTENANCE PROGRAM INC. VEHICLE BULBS. 95.90 Il836 WICKSTROM FORD LINCOLN MERCURY TR.~NSMISSION REPAIR - VEHICLE 538.89 11315 WOODFIELD CHEVROLET, INC LEAF SPRINGS SPACER INSERT FOR 43.14 TOTAL 6691.17 670 10793 LIEBOVICH BROS, INC STEEL FOR NEW TRUCK BUILDS #45 689.25 06403 LINDCO EQUIPMENT SALES, INC. S.S. HOSE PROTECTION FOR NEW 624.05 REPORT: APBOARDRPT GENERATED: 15 APR 09 ll: 42 RUN: TUESDAY MAY1l2010 1l:44 PAGE 16 RELEASE 10 : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 29 2010 TO MAY 12 2010 -- -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - -- --- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --- -- -- - - - - - - - - - - - - - - - - - - - - -- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT -- - - - -- - - - -- - - - - - -- - - - - - - - - - -- - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - -- - - - - - - - - -- -- Tom : 13l J.J 0 690 01460 ARTHUR J. GALLAGHER RMS, INC. BUILDERS I RISK PROJECT 838.00 01236 DAVE & JIM I S AUTO BODY, INC. REPAIR T- 38 ACCIDENT DATE 4/13 590.80 01451 GAB ROBINS NORTH AMERICA, INC #1500006516 1/1/10-12/31/10 1000.00 #1700000765 1/1/10-12/31/10 1009.00 #45306120234 1/1/10-12/31/10 8000.00 ------------- 10009.00 12174 GRAY, HELEN REIMB MAILBOX DAMAGED 125.00 10707 HIGH-LEVEL EXCESS LIABILITY POOL 1ST PYMT- MAY 2010 38376.00 05943 IL DEPT. OF EMPLOYMENT SECURITY 1ST QTR 2010-JUSTIN FOLEY 1155.00 01737 INTERGOVERNMENTAL PER. BEN .COOP CLAIMS ADMIN-MEDICAL MAY 2010 23431.56 HMO MEDICAL MAY 2010 125591.19 LIFE INSURANCE MAY 2010 2829.00 PPO MEDICAL CLAIMS 280335.71 ------------- 432187.46 TOTAL 483281.26 710 07263 RICHARD REIMER & ASSOC., LLC. LEGAL EXPENSE MARCH 2010 7108.99 00128 VILLAGE OF MOUNT PROSPECT PAYROLL FOR - 042310 18695.51 04314 VILLAGE OF MOUNT PROSPECT - PAYROLL WIRES PAYROLL FOR - 042310 29688.38 TOT AL 55492.88 720 00128 VILLAGE OF MOUNT PROSPECT PAYROLL FOR - 042510 11513.51 04314 VILLAGE OF MOUNT PROSPECT - PAYROLL WIRES PAYROLL FOR - 042510 23928.66 TOTAL 35442.17 790 12160 AMERPOL GENERAL REMODELING, INC REPLACE CK#77605 300.00 01719 NCPERS GROUP LIFE INS. PREMIUM MAY 2010 720.00 PREMIUM MAY 2010 16.00 ------------- 736.00 10984 NORWOOD EMERSON, LLC REPLACE CK# 13021337 1150.00 12172 SACKETS HARBOR CENTRAL SCHOOL MEMORIAL GIFT-GARRETT LOOMIS 90.00 02689 THIRD DISTRICT CIRCUIT COURT BOND MONEY 4/29/10 1570.00 RUN: TUESDAY MAYll2010 11:44 RELEASE 10 : REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 DEPT VENDOR NBR 02886 850 09852 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 29 2010 TO MAY 12 2010 VENDOR NAME INVOICE DESCRIPTION BOND MONEY 5/4/10 BOND MONEY 5/6/10 BOND MONEY 5/11/10 WISCONSIN DEPARTMENT OF REVENUE WISC.INCOME TAX FOR APRIL 2010 'rOTAL 11495.10 310.10 BANK OF NEW YORK AGENT FEE 12/1/09-5/31/10 TOTAL GRAND TOTAL P,~GE 17 AMOUNT 3542.00 1350.00 2447.00 8909.00 300.00 300.00 1985009.22 REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY MAYll2Ol0 11:44 RELEASE 10 : PAGE 18 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 29 2010 TO MAY 12 2010 - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - -- -- - - - - - - - - - - - - - - - - - - - - - -- SUMMARY BY FUND --- - - - - - - - - - - - - - - --- - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- -- - - - -- - - - - - - - - - - - - - - - - - - - - -- - - --- - -- - - - - - -- - - - - - - - - - - -- 001 GENERAL FUND 599879.80 030 REFUSE DISPOSAL FUND 929.32 050 MOTOR FUEL TAX FUND 4579.58 070 COMMUNITY DEVELPMNT BLOCK GRNT 2632.60 380 IEPA FLOOD CONTROL LOANS B&I 168629.18 510 CAPITAL IMPROVEMENT FUND 41187.72 528 SERIES 2009 CONST FUND 245631.49 550 DOWNTOWN REDEVLPMNT CONST 19600.63 560 STREET IMPROVEMENT CONST FUND 160819.00 610 WATER AND SEWER FUND 143323.46 620 VILLAGE PARKING SYSTEM FUND 1481.40 630 PARKING SYSTEM REVENUE FUND 2299.16 660 VEHICLE MAINTENANCE FUND 6691.17 670 VEHICLE REPLACEMENT FUND 1313.3 0 690 RISK MANAGEMENT FUND 483281.26 710 POLICE PENSION FUND 55492.88 720 FIRE PENSION FUND 35442.17 790 ESCROW DEPOSIT FUND 11495.10 850 SERIES 2002 LIBRARY BND ESCROW 300.00 -------------- TOTAL : 1985009.22 REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY MAYl12010 11 :44 PAGE REPORT PARAMETERS ORGANIZATlON NO. : 001 STARTING CHECK DATE : 04/29/10 ENDING CHECK DATE : 05/12/10 STARTING BANK ENDING BANK SEGMENT NOMBER TO SORT BY : 01 STARTING ACCOUNT SEGMENT NUMBER: ALL ENDING ACCOUNT SEGMENT NOMBER : ALL RELEASE LEVEL 05/11ho EMR025 Village of Mount Prospect List of Escrow Checks Presented to the Board of Trustees 05/12/10 To 05/12/10 Paid to Permit # 100426 ABLE CONCRETE CORRECTION INC AGT ELECTRIC 100435 ANTHONY JAMES BUILDERS 100372 BAAS, W R 100402 CHICAGO BATH SYSTEMS LLC 100397 COSTCO WHOLESALE 092296 F & F CEMENT CONSTRUCTION 090841 100388 FOUR SEASONS HANNING, ELIZABETH 082598 HOME PLUMBING & HEATING CO INC 092431 J & S PLUMBING 090246 092582 JOHN'S ROOFING & CONSTRUCTION KINNARE BUILDERS 092067 MIDCITY PLUMBING INC 100263 092281 PATEL, SHOBHANA PAWLAK, RENATA 090817 PERMA SEAL BASEMENT SYSTM 100290 100316 RICK'S SEWER & DRAINAGE 092668 100286 100409 SPEC ENGINEERING 091773 TC MAJER CARPENTRY 100146 WOOTEN ELECTRIC 092562 *** TOTAL NUMBER OF CHECKS 24 Check # 13022091 Amount 200.00 13022092 125.00 13022093 200.00 13022094 125.00 13022095 125.00 13022096 13022097 400.00 200.00 125.00 13022098 13022099 125.00 13022100 75.00 13022101 75.00 13022102 125.00 13022103 1,000.00 125.00 200.00 13022104 13022105 13022106 200.00 13022107 75.00 13022108 125.00 200.00 * 13022109 13022110 13022111 75.00 125.00 125.00 325.00 * 13022112 1,000.00 200.00 13022113 13022114 125.00 5,275.00 Page 1