The URL can be used to link to this page

Home My WebLink About3. FINANCIAL REPORT & BILLS 12/15/2009 Mount Prospect INTEROFFICE MEMORANDUM Village of Mount Prospect Mount Prospect, Illinois TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM: FINANCE DIRECTOR DATE: DECEMBER 11, 2009 MONTHLY FINANCIAL REPORT - NOVEMBER 2009 SUBJECT: Attached hereto are the cash position and investment statements of the Village for the month ended November 30, 2009. 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 October 31 were $21.8 million. During November, cash receipts totaled $6,534,851.78. In addition investment income for the month was $17,324.67. Reductions in cash and cash equivalents during November totaled $8,120,193.21. Of this amount, payments to vendors were $6,808,229.82, employee payroll and related expenses were $1,311,963.39. Other disbursements actually show an inflow of $161,986.91 due to a voided check in the amount of $165,000.000. Other disbursements typically show an outflow accounting for bank fees. There was also a net increase in cash due to investment Monthly Financial Report - November 2009 December 13, 2009 Page 2 activities of $1,567,507.62 and inflows due to interfund activity of $15,275.00. Cash and cash equivalents at November 30 were $22.0 million. Total investments at October 31 were $4.8 million. During the month, investments decreased $1,567,507.62. This was due to one maturing CD maturing where proceeds were not reinvested. Total investments at November 30 were $3.2 million. Total cash and investments for Governmental and Enterprise Funds at October 31 were $26,615,702.96. Cash and investments at November 30 totaled $25,224,948.11. This is a decrease of $1,390,754.85 for the month. The drawdown is the result of the delay in property taxes that are typically received during this period resulting in fewer taxes than anticipated. Trust and Agency Funds - Cash and cash equivalents at October 31 were $6.5 million. During November, cash receipts totaled $999,759.95. In addition investment income for the month was $112,645.66 and outflows due to interfund activity totaled $15,275.00. There was also a net decrease in cash due to investment activities of $40,159.77. Reductions in cash and cash equivalents during November totaled $1,882,589.55. Of this amount, payments to vendors were $1,455,617.94, employee payroll and related expenses were $407,328.35, payments related to the flexible spending program totaled $15,693.26 and other disbursements were $3,950.00. Cash and cash equivalents at November 30 were $5.6 million. Total investments at November 30 were $75,950,568.93, an increase of $435,909.68 from October 31. There were investment gains of $395,749.91 and a net transfer in from cash of $40, 159.77 that accounted for the change. Total cash and investments for Trust and Agency Funds at October 31 were $81 ,971 ,932.64. Cash and investments at November 30 totaled $81,582,223.61. This is a decrease from the balance at October 31 of $389,709.03. Summary of Cash Activity by Fund Type (paae 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 October 31 totaled $1,783,268.64. During November, cash receipts totaled $2,967,577.12 and investment income was $3,579.70. Significant cash receipts included sales and income taxes and telecommunication taxes. The Village began receiving the second installment of 2008 Property taxes during November. A total of $1 ,420,419 was received in the General Fund during the month. Monthly Financial Report - November 2009 December 13, 2009 Page 3 Sales tax revenues for the month totaled $678,631. Of this amount, $575,511 was generated from the 1 % state portion while $103,120 was generated from the .25% home rule portion. Sales taxes received in November are for August sales as there is a normal three-month lag in getting this distribution from the state. Telecommunication tax receipts for November also reflect July activity. Total receipts during October were $224,172. This revenue continues to be the lone bright spot exceeding prior year receipts by 6.5%. Disbursements from the General Fund for November included payments to vendors of $1,175,500.75 and payments for employee wages and benefits of $1,005,515.06. Interfund transfers of $442,406.06 for health premiums and vehicle lease and maintenance payments were also made during the month. Cash and cash equivalents at November 30 were $2,127,791.88. In addition, investments consisting of certificates of deposit totaling $1,065,178.06 bring total cash and investments for the General Fund to $3,192,969.94. Statement of Investments (paaes 3-4) 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 - The investments for the governmental and agency funds are made up solely of certificates of deposit. Certificates of deposit have maturities of between 30 and 120 days and are currently placed with two different banks, Harris and Citibank. Below is a breakdown of where the monies are placed. Harris CDs CitibankJPMA CDs Market Value 2,335,609.04 913,720.00 $ 3,249,329.04 Representing Total Portfolio 71.880% 28.120% 100.000% Weighted A vg Yield 3,269.85 13,310.33 16,580.18 The portfolio weighted average return is 0.510%, down from the return in October of 0.785%. The drop is due to investments that held a higher rate of return maturing with reinvestment at a lower rate. Short-term rates continue to remain low and are not expected to rise in the near future. Investment of the Village's general funds is governed by the Village Investment Policy. The policy was last amended in November 2007. 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. Certificates of deposit held in the Escrow Deposit Fund 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 Monthly Financial Report - November 2009 December 13, 2009 Page 4 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. Investment CUSIP/ Interest Description Acct # Rate % Wells Fargo Investments Various Various Mutual Fund Investments Various Various Market Value Maturity Date Purchase Financial Date Institution POLICE PENSION FUND (710) Various Various Wells Fargo Various Various Various 20,170,933.20 17,595,340.43 37,766,273.63 FIRE PENSION FUND (720) Various Various Wells Fargo Various Various Various Wells Fargo Investments Mutual Fund Investments Various Various Various Various 21,509,387.93 16,674,907.37 38, J 84,295.30 TOTAL TRUST AND AGENCY FUND INVESTMENTS $ 75,950,568.93 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. 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 commitments. J~~ {;L--' David O. Erb Finance Director VILLAGE OF MOUNT PROSPECT Preliminary Cash and Investment Position Report - All Funds For the Month Ended November 30, 2009 GOVERNMENTAL AND ENTERPRISE FUNDS Cash and Cash Total Cash and Equivalents Investments Investments Balance at October 31, 2009 $ 21,798,866.30 $ 4,816,836.66 $ 26,615,702.96 Cash receipts 6,534,851.78 6,534,851.78 Investment income 17,324.67 17,324.67 Transfers from investments to cash 3,903,116.66 (3,903,116.66) Transfers to investments from cash (2,335,609.04) 2,335,609.04 Interfund activity 15,275.00 15,275.00 Disbursements: Accounts payable (6,808,229.82) (6,808,229.82) Payroll (1,311,963.39) (1,311,963.39) Other 161,986.91 161,986.91 Balance at November 30, 2009 $ 21,975,619.07 $ 3,249,329.04 $ 25,224,948.11 TRUST AND AGENCY FUNDS * Cash and Cash Total Cash and Equivalents Investments Investments Balance at October 31, 2009 $ 6,457,273.39 $ 75,514,659.25 ** $ 81,971,932.64 Cash receipts 999,759.95 999,759.95 Investment income (loss) 112,645.66 395,749.91 508,395.57 Transfers from investments to cash 1,102,588.77 (1,102,588.77) Transfers to investments from cash (1,142,748.54) 1,142,748.54 Interfund activity (15,275.00) (15,275.00) Disbursements: Accounts payable (1,455,617.94 ) (1,455,617.94 ) Payroll (407,328.35) (407,328.35) Flex spending (15,693.26) (15,693.26) Other (3,950.00) (3,950.00) Balance at November 30, 2009 $ 5,631,654.68 $ 75,950,568.93 $ 81,582,223.61 * Assets are restricted in purpose and do not represent discretionary assets of the government. ** Restated 10-31-09 balance due to misclassification of Library Fund transfer. 1 I- U W a.. lI) o a:: a.. I- z ;:) o ::e LL. o W Cl j ..J :; <l>0l 0.0 :.,0 I-C\l '00 C:M ~ .... LL. :.,.<:1 .c E .?;-~ '> 0 :t:iZ .a!ijl .r::.1J VJ c: mw U.r::. -- - o c: ~o m:2 E E= ~ .... (/) 0 LL. (/) o Z ::J LL.' >- U Z W Cl < o Z < l- (/) ::J 0::: I- 1->- ~U o:::Z(/) I-WO o:::C>Z w<::J IOLL. I-Z 0< o (/) zWz <UO w:::iCi) o:::OZ -Q.w LL. 0. o Z <W .(/) >D::(/) 00.0 ,n 0::: Z .....w::J ...JI-LL. ~Z OW I- (/) o Z ::J LL. W (/) D:: 0. 0::: W I- Z W o Z < ..J ~ Z W :2 Z 0::: W > o C> ...J(/) ....I-(/) ~UO -wZ Q.""::J 5~LL. 0. ...JW <::J(/) -zo Uwz W>::J Q.WLL. (/)0::: MCOr-- COO"l" r---:~N' COMOl coo cOlLi CO<t r--C\l N So CO' OON Lrici<'i r--lClOl NOlCO Ll'ictiLri ::;.-S ~ (()Olmf'oo..~ f"o-.CO__f"--.1.O LONMcOcQ' COC\llClCO<t LO ....... L() 1.0 r-- O-.iNNN O)I.()__OOli:t COf'..,....T""r M -~ ~ ocor--co:<rO.... Mr--COCOOOOl U:)~...t-ccio;Llia:i' co lOC'\I.,....e,," co co CO M....CO NOl < -0::: w (/) r---.<ooo r--<t"l"0 Lricci-.cto I COONO __MCOO oooriori COCOOlCO <O@..LOT"" M....C\l ....CON -.icO-.i COOlr-- "'COC\l <"i 0 - O>lCl 0.... o .... ~ w (/) D::(/) 0.0 o:::Z W::J I-LL. Z W NN.......CO~M r--OOlCOCO.,.... &i~~~~~ cor-- r--COCO cOo lCl-lriN COlCl lCllClM en.,.... C"')(f')T"" (f')-~ -- ~ NT""mLOM OM<tO>N dcri"';Lrir-i' NO(Ov-- o 1.0.,.... N ('I) r-:ciNa)~ (OLl).,.....,....1l) coco co~ -.i - ~ W U >(/) 0:::0 Wz (/)::J ~LL. W o Or--C\l co 0> r-- MtO-..t' OCOlCl coco rriori 0'" r-- <t ~ ClLO,.....VG'~ c)f'-..lt)COvN <o<o~cicOr--: M.,....COCOO>N O)N__mOlL!) aio NNori ......f'.. 00- lCl Ol C\l ~ ~ o Z ::J LL. ..J ~ W Z W C> VNOVtOCOCD ~or-:r--:"=':C!~~l CC"""Q')C)CO(O(f') <0""" "..............O'r"'" NI.Olt)CJ)....vO g~<"it~~!i r--Ol 00<t ~N """-i.- ~ lI) g> ~ I- 'g ~ Z m W VJ 0. 0. ~ C U) rn <> <l>E~ <1>_1:: 1...:0 e is ~ 81 ~ ~ .~ ~ tl w~ E~81 o-=o.m ~ ffi 8 .- > VJ VJ VJ VJ lI) ~ ,l!! c: g .5 1:: 1:: 1:: 1:: ~ .c .9-:: ~ .s Q) OJ Q) dJ ollg>~5il!!l!!1J~~~~ .2~E~.!!C~f!!~f!! ;::j.5.r::.]j ~ ~.e.E.E.E.E ..,.ClVJ>mm<l>VJVJVJVJ u~8.5~~Ei5i5i5i5 N C\l Lri '" r-- ",- lCl "'- :s co co <'i co .... <"i C\l ~ LOC\l ",r-- cON NCO '" co ,.....~~ 00 ~S o C! .... 0> "l" rri o o -.i O)N '" co <'io> CON O>N __~a;) ....0 '" co ~~ r-- o 0> U; ori r-- 0>_ .... N ~N <to> 0><0 lClr-- oco -.iN t:.~ .... '" N N lCl ai co 0> ai co<t O><t <'icO cor-- NlCl ,fori lClCO :sCO o N Lri co 0> ,f <t .... ,f ~ lCl cO 0> 0> r--: v 0_ ~ r-- Ol -.i N co rri lCl 0_ lCl ~ N .... co <"i .... ~ :s LO N cO co N ai co ~ MO Ol v -.iN N co ....co rriN r--N ~~ co 0> N co 0> <"i S_ COlCl or-- Lrici ....0 lCllCl &ti ..6 or-- o~ T""_ .... .... co co ;;; r-- r--- N .... N C) c: m ~ .<:I Cl c: '6 c: W v "" 0>' N '" ai v N <"i co v cO o '" o co co v co ci ;;; ori lCl '" '" N <'i' C') o ori co Ol lCl v cO 0> 0> N o N co o cO r-- .... ori co 0_ VJ,l!! 1:: c: .- ~ E E a. Vi 1i5 (/)~~~ !z '0 .5 .5 wVJ01J ::e ~ c: I-mm2 U).g~"ffi ~:e=.a i!i:~~~ '" 0 .... co ,..;,....: Nv MN 00 co r-- CON ~...t v'" M Ol cO co lCl ci lCl 0> ori r-- <t o 0> N C') ai <t C\l <"i co <t cO o C') o co co <t co ci ;;; ori lCl '" C') C\l <'i M o lCl- co 0> lCl "<t cO 0> 0> N o C\l co o cO r-- .... ori co 0_ VJ 1:: E (;) > .5 ~ 15 I- co '" ..; '" .... ..; N II!. ... ... en en It) o en It) en en' r-- ~ .... .... cO v en ..; N N It)" N ... ..... ..... o ... co en N Ul o .... ... .., o ui ..... ..... o o It) ..; ~ o N cO It) Ul ..; N o ui ~ il) N cO Ul N en Ul e 1:: E c: Q; > o Cl = '0 II> Q3 II> II> m ~ m c: g ~ C) VJ '6 1:: VJ 5- ~ 15 c: o '0 1J c: m VJ o 0. :s 0. .5 1J tl E II> ~ ~ m VJ Q3 VJ II> < 2 ~ .... "": .... co en ~ N. ... .., en en Ul en N en .... ...- ... (/) I- Z W ::e l- (/) W > i!i: o Z < ~ lI) < U ...J <( I- o I- VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of November 30,2009 GOVERNMENTAL AND ENTERPRISE FUNDS Maturity Purchase Financial Investment CDSIP/ Interest Market Weighted Date Date Institution Description Acct# Rate % Value Avg Yield GENERAL FUND (001) 12/22/09 lI/17/09 Harris Certificate of Deposit 6900221843 0.140% 552,045.86 772.86 12/22/09 lI/1 7/09 Harris Certificate of Deposit 6900156783 0.140% 513,132.20 718.39 1,065, I 78.06 1,491.25 Weighted Average Return 0.140% REFUSE DISPOSAL FUND (030) 12/22/09 lI/17/09 Harris Certificate of Deposit 6900221843 0.140% 100,371.97 140.52 12/22/09 lI/17/09 Harris Certificate of Deposit 6900156783 0.140% 102,626.48 143.68 202,998.45 284.20 Weighted Average Return 0.140% CAPITAL IMPROVEMENT FUND (510) 12/22/09 11/17109 Harris Certificate of Deposit 6900156783 0.140% 51,313.23 71.84 51,313.23 71.84 Weighted Average Return 0.140% SERIES 2009 CONSTRUCTION FUND (528) 12/16/09 04/30/09 CitibankIPMA Certificate of Deposit 132418 1.541% 245,200.00 3,778.53 12/16/09 04/30/09 CitibankIPMA Certificate of Deposit 132419 1.490% 245,400.00 3,656.46 12/16/09 04/30/09 CitibankIPMA Certificate of Deposit 132420 1.402% 245,600.00 3,443.31 12/16/09 04/30/09 CitibankIPMA Certificate of Deposit 132421 1.370% 177,520.00 2,432.02 913,720.00 13,310.33 Weighted Average Return 1.457% WATER AND SEWER FUND (610) 12/22/09 I 1117/09 Harris Certificate of Deposit 6900221843 0.140% 150,557.96 210.78 12/22/09 I 1117/09 Harris Certificate of Deposit 6900156783 0.140% 205,252.88 287.35 355,810.84 498.14 Weighted Average Return 0.140% VEHICLE MAINTENANCE FUND (660) 12/22/09 lI/17/09 Harris Certificate of Deposit 6900156783 0.140% 51,313.22 71.84 5 1,313.22 71.84 Weighted Average Return 0.140% VEHICLE REPLACEMENT FUND (670) 12/22/09 I 1117/09 Harris Certificate of Deposit 6900221843 0.140% 50,185.98 70.26 12/22/09 II/I 7/09 Harris Certificate of Deposit 6900156783 0.140% 51,313.22 71.84 101,499.20 142.10 Weighted Average Return 0.140% RISK MANAGEMENT FUND (690) 12/22/09 lI/17/09 Harris Certificate of Deposit 6900221843 0.140% 250,929.93 351.30 12/22/09 11117/09 Harris Certificate of Deposit 6900156783 0.140% 256,566.11 359.19 507,496.04 710.49 Weighted Average Return 0.140% GOVERNMENTAL AND ENTERPRISE FUNDS Market Representing Weighted SUMMARY BY TYPE OF INVESTMENT/INSTITUTION: Value Total Portfolio Avg Yield Harris CDs 2,335,609.04 71.880% 3,269.85 CitibanklPMA CDs 913,720.00 28.120% 13,310.33 $ 3,249,329.04 100000% 16,580.18 Portfolio Weighted Average Return 0.510% 3 VILLAGE OF MOUNT PROSPECT STA TEMENT OF INVESTMENTS As of November 30,2009 Maturity Purchase Financial Date Date Institution POLICE 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 Wells Fargo Investments Mutual Fund Investments Wells Fargo Investments Mutual Fund Investments TOTAL TRUST AND AGENCY FUND INVESTMENTS CUSIP/ Acct # Various Various Various Various * Assets are restricted in purpose and do not represent discretionary assets of the government. Interest Rate % Various Various Various Various Market Value 20,170,933.20 17,595,340.43 37,766,273.63 21,509,387.93 16,674,907.37 38,184,295.30 $ 75,950,568.93 Weighted Avg Yield 4 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE & EXPENDITURE SUMMARIES January 1 - November 30, 2009 12/08/2009 17:17:14 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/09 - 11/30/09 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 2,721,398 1,824,811 199,816 1,049,313 1,618,164 21,801 539,278 40,231 857,444 26,500 8,898,756 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 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 CONST STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST 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 Total All Funds 3,656,070 428,626 96,060 o 328,762 4 4 508 21,148 o 70,387 168,227 94,278 o o o 103,130 o o 94, 928 3,134 638,090 127,080 381 1,000,654 10,924 12,456 157,032 102,361 16,377 482,432 651,820 633,883 o o 8,898,756 1 Y-T-D Received 9,559,406 10,018,036 3,370,164 11,792,528 19,008,671 460,642 9,627,442 286,610 4,567,568 10,259,942 78,951,009 27,822,097 3,218,950 1,238,473 o 705,555 3,071 69 13,452 50,223 8 255,659 611,007 338,365 o o o 658,644 o o 631,207 9,918,580 1,596,938 898,422 76,379 9,056,617 117,436 126,441 1,728,254 1,267,174 181,335 5,747,499 6,708,254 5,980,893 7 o 78,951,009 11 Months 1 Month 2009 Budget 13,570,000 14,761,000 3,857,000 18,579,514 22,435,567 730,000 6,501,000 401,000 5,958,952 12,623,000 99,417,033 40,153,100 4,166,000 1,812,000 o 785,604 12,000 2,000 21,000 41,000 o 385,000 918,000 o o o o 1,054,000 o o 1,178,810 12,784,000 2,675,000 1,334,000 108,500 11,983,000 161,000 161,000 1,671,682 1,159,700 220,281 6,683,556 4,966,500 4,980,300 o o 99,417,033 91. 6% 8.3% Unreceived Balance 4,010,594 4,742,964 486,836 6,786,986 3,426,896 269,358 -3,126,442 114,390 1,391,384 2,363,058 20,466,024 12,331,003 947,050 573,527 o 80,049 8,929 1,931 7,548 -9,223 -8 129,341 306,993 -338,365 o o o 395,356 o o 547,603 2,865,420 1,078,062 435,578 32,121 2,926,383 43,564 34,559 -56,572 -107,474 38,946 936,057 -1,741,754 -1,000,593 -7 o 20,466,024 Completed Remaining Unreceived Percent 29.6 32.1 12.6 36.5 15.3 36.9 -48.1 28.5 23.3 18.7 20.6 30.7 22.7 31.7 10.2 74.4 96 .6 35.9 -22.5 33.6 33.4 37.5 46.5 22.4 40.3 32.7 29.6 24.4 27.1 21.5 -3.4 -9.3 17.7 14.0 -35.1 -20.1 20.6 12/08/2009 11 Months 91. 6% Completed 17:17:41 1 Month 8.3% Remaining FRRBRR03 VILLAGE OF MOUNT PROSPECT SUM021 Budget Revenue by Category within Fund Summary 01/01/09 - 11/30/09 Cur Mo Y-T-D 2009 Unreceived Unreceived Received Received Budget Balance Percent GENERAL FUND 40 PROPERTY TAXES 2,065,466 7,180,999 10,529,000 3,348,001 31. 8 41 OTHER TAXES 562,726 5,144,262 7,140,000 1,995,738 28.0 42 LICENSES, PERMITS & FEES 198,535 3,278,035 3,775,000 496,965 13 .2 43 INTERGOVERMENT REV. 625,756 9,931,059 15,843,600 5,912,541 37.3 44 CHARGES FOR SERVICE 135,460 1,383,522 1,590,500 206,978 13 .0 45 FINES AND FORFEITS 18,613 422,258 699,000 276,742 39.6 46 INVESTMENT INCOME 3,528 62,345 64,000 1,655 2.6 47 REIMBURSEMENTS 39,100 271,351 329,000 57,649 17 .5 48 OTHER REVENUE 6,886 147,521 183,000 35,479 19.4 49 OTHER FINANCING SOURCES 0 745 0 -745 TOTAL GENERAL FUND 3,656,070 27,822,097 40,153,100 12,331,003 30.7 REFUSE DISPOSAL FUND 40 PROPERTY TAXES 323,084 1,174,561 1,750,000 575,439 32.9 44 CHARGES FOR SERVICE 82,714 1,926,797 2,230,000 303,203 13 .6 46 INVESTMENT INCOME 28 8,022 35,000 26,978 77 .1 48 OTHER REVENUE 22,800 109,570 151,000 41,430 27.4 TOTAL REFUSE DISPOSAL FUND 428,626 3,218,950 4,166,000 947,050 22.7 MOTOR FUEL TAX FUND 43 INTERGOVERMENT REV. 94,798 1,225,069 1,736,000 510,931 29.4 46 INVESTMENT INCOME 131 1,203 16,000 14,797 92.5 47 REIMBURSEMENTS 1,131 12,201 60,000 47,799 79.7 TOTAL MOTOR FUEL TAX FUND 96,060 1,238,473 1,812,000 573,527 31. 7 LAW ENFORCEMENT BLOCK GRANT 43 INTERGOVERMENT REV. 0 0 0 0 46 INVESTMENT INCOME 0 0 0 0 TOTAL LAW ENFORCEMENT BLOCK GRANT 0 0 0 0 COMMUNITY DEVELPMNT BLOCK GRNT 43 INTERGOVERMENT REV. 328,759 617,650 745,604 127,954 17.2 46 INVESTMENT INCOME 3 23 0 -23 48 OTHER REVENUE 0 87,882 40,000 -47,882 -119.7 TOTAL COMMUNITY DEVELPMNT BLOCK GRNT 328,762 705,555 785,604 80,049 10.2 ASSET SEIZURE FUND 45 FINES AND FORFEITS 0 2,949 10,000 7,051 70.5 46 INVESTMENT INCOME 4 122 2,000 1,878 93.9 TOTAL ASSET SEIZURE FUND 4 3,071 12,000 8,929 74.4 DEA SHARED FUNDS FUND 45 FINES AND FORFEITS 0 0 1,000 1,000 100.0 46 INVESTMENT INCOME 4 69 1,000 931 93.1 12/08/2009 17:17:41 11 Months 1 Month 91. 6% 8.3% Completed Remaining FRRBRR03 SUM021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/09 - 11/30/09 Cur Mo Received Y-T-D Received 2009 Budget Unreceived Balance Unreceived Percent 96.6 TOTAL DEA SHARED FUNDS FUND DUI FINE FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME 508 o TOTAL DUI FINE FUND 508 FOREIGN FIRE TAX BOARD FUND 41 OTHER TAXES 46 INVESTMENT INCOME 21,147 1 TOTAL FOREIGN FIRE TAX BOARD FUND 21,148 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 4 69 2,000 20,000 1,000 21,000 40,000 1,000 41,000 o 8 8 13,447 5 13,452 50,196 27 50,223 o o o 1,931 6,553 995 32.8 99.5 7,548 35.9 -10,196 973 -25.5 97.3 -9,223 -22.5 o o o -8 o -8 70,379 255,414 381,000 125,586 33.0 8 245 4,000 3,755 93.9 0 0 0 0 70,387 255,659 385,000 129,341 33.6 TOTAL SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 168,206 21 o TOTAL SERIES 2003 B&I, VILLAGE HALL 168,227 SERIES 2009 B&I, FD/PW 40 PROPERTY TAXES 46 INVESTMENT INCOME 94,263 15 TOTAL SERIES 2009 B&I, FD/PW 94,278 SERIES 1999 B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 1999 B&I, TIF SERIES 1998A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 1998A B&I, FLOOD 610,380 627 o 611,007 338,052 313 338,365 o o o o o o 910,000 8,000 o 918,000 o o o o o o 299,620 32.9 92.2 7,373 o 306,993 33.4 o o -338,052 -313 o -338,365 o o o o o o o o o o o o FRRBRR03 SUM021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/09 - 11/30/09 11 Months 1 Month 91.6% 8.3% Completed Remaining 12/08/2009 17:17:41 SERIES 1998C B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME Cur Mo Y-T-D 2009 Unreceived Unreceived Received Received Budget Balance Percent 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I 41 OTHER TAXES 46 INVESTMENT INCOME 103,120 10 658,592 52 1,054,000 o 395,408 -52 37 _ 5 TOTAL IEPA FLOOD CONTROL LOANS B&I 103,130 658,644 1,054,000 395,356 37.5 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 B&I, 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 94,871 605,905 954,000 348,095 36.5 0 18,750 206,810 188,060 90.9 57 2,237 18,000 15,763 87.6 0 0 0 0 0 4,315 0 -4,315 0 0 0 0 94,928 631,207 1,178,810 547,603 46.5 TOTAL CAPITAL IMPROVEMENT FUND SERIES 2009 CONST FUND 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 3,134 46,591 220,000 173,409 78.8 0 0 1,000 1,000 100.0 0 9,871,989 12,563,000 2,691,011 21.4 3,134 9,918,580 12,784,000 2,865,420 22.4 TOTAL SERIES 2009 CONST FUND DOWNTOWN REDEVLPMNT CONST 41 OTHER TAXES 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES TOTAL DOWNTOWN REDEVLPMNT CONST 638,035 1,593,674 2,640,000 1,046,326 39.6 55 1,512 35,000 33,488 95.7 0 1,752 0 -1,752 0 0 0 0 0 0 0 0 638,090 1,596,938 2,675,000 1,078,062 40.3 STREET IMPROVEMENT CONST FUND 41 OTHER TAXES 46 INVESTMENT INCOME 127,080 o 889,274 892 1,324,000 10,000 434,726 9,108 32.8 91.1 12/08/2009 17:17:41 FRRBRR03 SUM021 11 Months 1 Month 91. 6% 8.3% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/09 - 11/30/09 Cur Mo Received 48 OTHER REVENUE TOTAL STREET IMPROVEMENT CONST FUND 127,080 FLOOD CONTROL CONST FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME o 381 o o TOTAL FLOOD CONTROL CONST FUND 381 WATER AND SEWER FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 269,583 900 729,053 53 o 1,065 o TOTAL WATER AND SEWER FUND 1,000,654 VILLAGE PARKING SYSTEM FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 3,712 o 7,209 3 TOTAL VILLAGE PARKING SYSTEM FUND 10,924 PARKING SYSTEM REVENUE FUND 41 OTHER TAXES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 4,537 7,919 o TOTAL PARKING SYSTEM REVENUE FUND 12,456 VEHICLE MAINTENANCE FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 156,939 93 o TOTAL VEHICLE MAINTENANCE FUND 157,032 VEHICLE REPLACEMENT FUND 44 CHARGES FOR SERVICE 45 FINES AND FORFEITS 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 75,132 2,680 729 -2,680 26,500 Y-T-D Received o 8,256 898,422 o 76,209 o 170 76,379 1,023,446 15,920 7,971,969 16,364 o 28,918 o 9,056,617 23,709 o 93,650 77 117,436 28,978 97,377 86 126,441 1,726,298 1,664 292 1,728,254 826,468 21,988 31,510 o 387,208 2009 Budget 1,334,000 o 60,000 47,500 1,000 108,500 1,509,000 16,000 10,236,000 195,000 2,000 25,000 o 11,983,000 45,000 6,000 108,000 2,000 161,000 55,000 105,000 1,000 161,000 1,656,682 15,000 o 1,671,682 899,700 o 200,000 o 60,000 Unreceived Balance o -8,256 435,578 o -16,209 47,500 830 32,121 485,554 80 2,264,031 178,636 2,000 -3,918 o 2,926,383 21,291 6,000 14,350 1,923 43,564 26,022 7,623 914 34,559 -69,616 13,336 -292 -56,572 73,232 -21,988 168,490 o -327,208 Completed Remaining Unreceived Percent 32.7 -27.0 100.0 83.0 29.6 32.2 0.5 22.1 91. 6 100.0 -15.7 24.4 47.3 100.0 13 .3 96.2 27.1 47.3 7.3 91.4 21.5 -4.2 88.9 -3.4 8.1 84.2 -545.3 12/08/2009 17:17:41 FRRBRR03 SUM021 11 Months 1 Month 91.6% 8.3% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/09 - 11/30/09 Cur Mo Received TOTAL VEHICLE REPLACEMENT FUND 102,361 COMPUTER REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 16,274 103 TOTAL COMPUTER REPLACEMENT FUND 16,377 RISK MANAGEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 407,464 317 o 74,651 TOTAL RISK MANAGEMENT FUND 482,432 POLICE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE 265,418 386,402 TOTAL POLICE PENSION FUND 651,820 FIRE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE 265,563 368,320 TOTAL FIRE PENSION FUND 633,883 SSA #6 GEORGE/ALBERT B&I 46 INVESTMENT INCOME TOTAL SSA #6 GEORGE/ALBERT B&I GENERAL FIXED ASSETS ACCT GP 47 REIMBURSEMENTS 49 OTHER FINANCING SOURCES TOTAL GENERAL FIXED ASSETS ACCT GP MOUNT PROSPECT LIBRARY FUND 49 OTHER FINANCING SOURCES TOTAL MOUNT PROSPECT LIBRARY FUND Y-T-D Received 1,267,174 179,008 2,327 181,335 4,803,582 13,554 1,306 929,057 5,747,499 5,007,747 1,700,507 6,708,254 4,429,643 1,551,250 5,980,893 o o o o o o o 2009 Budget 1,159,700 195,281 25,000 220,281 5,414,404 90,000 10,000 1,169,152 6,683,556 2,693,000 2,273,500 4,966,500 2,864,000 2,116,300 4,980,300 7 7 o o o o 9,450,626 o 9,450,626 Unreceived Balance -107,474 16,273 22,673 38,946 610,822 76,446 8,694 240,095 936,057 -2,314,747 572,993 -1,741,754 -1,565,643 565,050 -1,000,593 o o o o o Completed Remaining Unreceived Percent -9.3 8.3 90.7 17.7 11.3 84.9 86.9 20.5 14.0 -86.0 25.2 -35.1 -54.7 26.7 -20.1 -7 -7 o o o 9,450,626 100.0 9,450,626 100.0 12/08/2009 17:16:28 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/09 - 11/30/09 Cur Mo Expended Y-T-D Expended 2009 Budget 91.6% 8.3% 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 Total All Funds 1,969,865 1,147,480 30,497 512,711 1,414,049 44,957 325,201 79,273 59,924 4,076 1,385,825 23,043 429,886 20,477 188,958 591,370 925,000 588,513 150 o 9,741,255 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 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 VILLAGE PARKING SYSTEM FUND PARKING SYSTEM REVENUE FUND VEHICLE MAINTENANCE FUND 3,256,856 360,984 28,570 o 174,922 o o o 145 o 298,020 709,953 505,690 o o o o o o 64,587 1,449,026 13,215 500,377 20,795 957,883 4,762 9,484 134,860 23,454,021 7,895,219 349,632 5,609,673 15,192,323 453,434 6,010,808 1,334,285 291,839 71,105 5,856,990 211,748 1,875,933 729,281 1,725,745 4,081,268 1,330,261 961,027 1,200 o 77,435,792 35,117,155 3,627,922 1,644,148 o 786,109 7,416 12,721 7,443 8,966 o 381,340 910,506 505,690 o o o o 494,952 o 507,502 6,475,734 311,547 1,715,073 689,273 9,214,744 63,996 133,588 1,518,902 26,898,560 9,451,590 455,860 5,985,000 18,634,507 638,765 6,956,783 1,781,692 1,920,250 112,800 11,008,906 487,021 2,535,500 3,038,724 2,337,040 4,889,416 1,225,219 678,783 1,200 o 99,037,616 40,472,925 4,194,247 2,113,102 o 876,710 2,000 1,000 1,500 15,500 o 381,340 910,508 o o o o o 613,354 o 1,544,850 12,784,000 1,925,650 2,856,600 235,000 12,508,845 131,101 143,648 1,972,750 3,444,539 1,556,371 106,228 375,327 3,442,184 185,331 945,975 447,407 1,628,411 41,695 5,151,916 275,273 659,567 2,309,443 611,295 808,148 -105,042 -282,244 o o 21,601,824 5,355,770 566,325 468,954 o 90,601 -5,416 -11,721 -5,943 6,534 o o 2 -505,690 o o o o 118,402 o 1,037,348 6,308,266 1,614,103 1,141,527 -454,273 3,294,101 67,105 10,060 453,848 12.8 16.5 23.3 6.3 18.5 29.0 13 .6 25.1 84.8 37.0 46.8 56.5 26.0 76.0 26.2 16.5 -8.6 -41.6 21.8 13 .2 13 .5 22.2 10.3 -270.8 **** * -396.2 42.2 19.3 67.1 49.3 83.8 40.0 -193.3 26.3 51. 2 7.0 23.0 12/08/2009 17,16,28 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/09 - 11/30/09 11 Months 1 Month 91.6% 8.3% Completed Remaining Cur Mo Y-T-D 2009 Unexpended Unexpended Expended Expended Budget Balance Percent VEHICLE REPLACEMENT FUND 429,886 1,875,933 2,535,500 659,567 26.0 COMPUTER REPLACEMENT FUND 14,031 144,229 188,150 43,921 23.3 RISK MANAGEMENT FUND 297,998 5,711,564 6,684,336 972,772 14.6 POLICE PENSION FUND 258,204 2,830,584 2,993,500 162,916 5.4 FIRE PENSION FUND 251,007 2,738,755 2,951,500 212,745 7.2 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 9,741,255 77,435,792 99,037,616 21,601,824 21.8 12/08/2009 17:18:11 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 11/30/09 NON-DEPARTMENTAL Cur Mo Expended Y-T-D Expended 2009 Budget Unexpended Unexpended Balance Percent PROGRAM TOTALS 00 ADMINISTRATION o o Totals o o EXPENDITURE CLASSIFICATION 72 INTEREST EXPENSE o o Totals o o SOURCE OF FUNDS 930 GENERAL LONG-TERM DEBT ACCT GP o o Totals o o 91. 6% 8.3% Completed Remaining o o o o o o o o o o o o 12/08/2009 17:18:11 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 11/30/09 PUBLIC REPRESENTATION Cur Mo Expended PROGRAM TOTALS 02 MAYOR AND BOARD OF TRUSTEES 03 ADVISORY BOARDS & COMMISSIONS 4,968 341 Totals 5,309 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 2,786 469 1,092 793 19 150 Totals 5,309 SOURCE OF FUNDS 001 GENERAL FUND 5,309 Totals 5,309 ? Y-T-D Expended 1l0,854 4,336 115,190 31,046 5,374 2,332 72,654 288 3,496 115,190 115,190 115,190 2009 Budget 113,705 6,162 119,867 33,967 5,848 3,650 71,802 500 4,100 119,867 119,867 119,867 91. 6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent 2,851 1,826 4,677 2,921 474 1,318 -852 212 604 4,677 4,677 4,677 2.5 29.6 3.9 8.6 8.1 36.1 -1. 2 42.4 14.7 3.9 3.9 3.9 12/08/2009 17,18,12 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 11/30/09 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 40,297 58,396 21,754 73,963 13,108 Totals 207,518 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,293 24,353 781 96,750 582 2,225 8,534 o Totals 207,518 SOURCE OF FUNDS 001 GENERAL FUND 207,518 Totals 207,518 Y-T-D Expended 514,820 742,080 250,01l 832,935 258,221 2,598,067 891,520 302,800 21,144 1,350,827 6,525 8,922 16,329 o 2,598,067 2,598,067 2,598,067 2009 Budget 555,008 540,750 333,265 988,204 264,491 2,681,718 1,023,225 333,606 26,600 1,258,836 9,360 1l,761 18,330 o 2,681,718 2,681,718 2,681,718 91. 6% 8.3% Unexpended Balance 40,188 -201,330 83,254 155,269 6,270 83,651 131,705 30,806 5,456 -91,991 2,835 2,839 2,001 o 83,651 83,651 83,651 Completed Remaining Unexpended Percent 7.2 -37.2 25.0 15.7 2.4 3.1 12.9 9.2 20.5 -7.3 30.3 24.1 10.9 3.1 3.1 3.1 12/08/2009 11 Months 91. 6% Completed 17:18:12 VILLAGE OF MOUNT PROSPECT 1 Month 8.3% Remaining FRRDBROl SUM031 Department Budget Expenditure Summary 01/01/09 - 11/30/09 Cur Mo Y-T-D 2009 Unexpended Unexpended TV SERVICES DIVISION Expended Expended Budget Balance Percent PROGRAM TOTALS 02 CABLE TV OPERATIONS 8,583 129,238 134,362 5,124 3.8 04 INTERGOVERNMENTAL PROGRAMMING 4,650 44,005 44,853 848 1.9 Totals 13,233 173,243 179,215 5,972 3.3 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 8,257 102,517 110,068 7,551 6.9 51 EMPLOYEE BENEFITS 3,073 37,338 40,234 2,896 7.2 52 OTHER EMPLOYEE COSTS 0 1,229 700 -529 -75.6 54 CONTRACTUAL SERVICES 1,775 17,000 15,670 -1,330 -8.5 55 urILITIES 128 1,870 1,600 -270 -16.9 57 COMMODITIES & SUPPLIES 0 6,915 4,300 -2,615 -60.8 67 OTHER EQUIPMENT 0 6,374 6,643 269 4.0 Totals 13,233 173,243 179,215 5,972 3.3 SOURCE OF FUNDS 001 GENERAL FUND 13,233 173,243 179,215 5,972 3.3 Totals 13,233 173,243 179,215 5,972 3.3 4 12/08/2009 17:18:12 FRRDBROl SUM031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 11/30/09 11 Months 1 Month 91. 6% 8.3% Completed Remaining VILLAGE CLERK'S OFFICE Cur Mo Expended Y-T-D Expended 2009 Budget Unexpended Unexpended Balance Percent PROGRAM TOTALS 02 VILLAGE CLERK'S OFFICE 13,816 176,727 209,032 32,305 15.5 Totals 13,816 176,727 209,032 32,305 15.5 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES Totals 9,231 112,654 123,762 11,108 9.0 3,293 40,008 43,481 3,473 8.0 30 1,292 1,280 -12 -0.9 1,198 18,571 35,350 16,779 47.5 64 964 1,700 736 43.3 0 3,238 3,459 221 6.4 13,816 176,727 209,032 32,305 15.5 SOURCE OF FUNDS 001 GENERAL FUND 13,816 176,727 209,032 32,305 15.5 Totals 13,816 176,727 209,032 32,305 15.5 5 12/08/2009 11 Months 91.6% Completed 17:18:12 VILLAGE OF MOUNT PROSPECT 1 Month 8.3% Remaining FRRDBROl SUM031 Department Budget Expenditure Summary 01/01/09 - 11/30/09 Cur Mo Y-T-D 2009 Unexpended Unexpended FINANCE DEPARTMENT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 FINANCE ADMINISTRATION 23,908 311,221 340,438 29,217 8.6 02 ACCOUNTING 36,310 419,788 473,813 54,025 11.4 05 INSURANCE PROGRAMS 24,810 277,193 304,841 27,648 9.1 06 CUSTOMER SERVICE 35,469 365,046 414,206 49,160 11.9 07 CASH MANAGEMENT 2,130 24,883 27,736 2,853 10.3 Totals 122,627 1,398,131 1,561,034 162,903 10.4 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 62,839 735,020 830,440 95,420 11.5 51 EMPLOYEE BENEFITS 21,416 259,872 286,084 26,212 9.2 52 OTHER EMPLOYEE COSTS 45 5,385 5,650 265 4.7 54 CONTRACTUAL SERVICES 12,146 159,212 182,954 23,742 13.0 55 UTILITIES 379 4,950 6,020 1,070 17.8 56 INSURANCE 19,003 209,035 228,038 19,003 8.3 57 COMMODITIES & SUPPLIES 6,799 24,227 21,418 -2,809 -13 .1 65 OFFICE EQUIPMENT 0 430 430 0 Totals 122,627 1,398,131 1,561,034 162,903 10.4 SOURCE OF FUNDS 001 GENERAL FUND 122,627 1,398,131 1,561,034 162,903 10.4 Totals 122,627 1,398,131 1,561,034 162,903 10.4 6 12/08/2009 17:18:12 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 11/30/09 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 18,149 18,239 6,250 73, III 38,997 8,949 Totals 163,695 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 101,663 36,996 720 22,617 1,149 550 o Totals 163,695 SOURCE OF FUNDS 001 GENERAL FUND 550 DOWNTOWN REDEVLPMNT CONST 163,695 o Totals 163,695 Y-T-D Expended 236,001 259,988 87,342 764,214 457,543 112,170 1,917,258 1,204,226 447,161 20,704 216,301 13,171 15,695 o 1,917,258 1,916,258 1,000 1,917,258 7 2009 Budget 284,017 359,303 118,377 957,641 555,123 126,146 2,400,607 1,390,145 495,454 30,105 423,086 19,274 20,543 22,000 2,400,607 2,399,607 1,000 2,400,607 91.6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent 48,016 99,315 31,035 193,427 97,580 13,976 483,349 185,919 48,293 9,401 206,785 6,103 4,848 22,000 483,349 483,349 o 483,349 16.9 27.6 26.2 20.2 17.6 11.1 20.1 13 .4 9.7 31.2 48.9 31.7 23.6 100.0 20.1 20.1 20.1 12/08/2009 17:18:12 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 11/30/09 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,319 4,554 45,213 118,836 o Totals 174,922 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,344 1,601 45 64,688 95 58,936 o 45,213 Totals 174,922 SOURCE OF FUNDS 070 COMMUNITY DEVELPMNT BLOCK GRNT 174,922 Totals 174,922 '" Y-T-D Expended 79,321 45,078 341,927 319,783 o 786,109 53,774 18,988 1,073 112,652 297 204,907 52,491 341,927 786,109 786,109 786,109 2009 Budget 94,894 95,000 381,816 305,000 o 876,710 61,473 21,354 2,165 163,925 977 195,000 50,000 381,816 876,710 876,710 876,710 91. 6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent 15,573 49,922 39,889 -14,783 o 90,601 7,699 2,366 1,092 51,273 680 -9,907 -2,491 39,889 90,601 90,601 90,601 16.4 52.5 10.4 -4.8 10.3 12.5 11.1 50.4 31.3 69.6 -5.1 -5.0 10.4 10.3 10.3 10.3 12/08/2009 11 Months 91. 6% Completed 17:18:12 VILLAGE OF MOUNT PROSPECT 1 Month 8.3% Remaining FRRDBROl SUM031 Department Budget Expenditure Summary 01/01/09 - 11/30/09 Cur Mo Y-T-D 2009 Unexpended Unexpended HUMAN SERVICES Expended Expended Budget Balance Percent PROGRAM TOTALS 01 HUMAN SERVICES ADMINISTRATION 14,438 142,724 194,547 51,823 26.6 02 SOCIAL SERVICES 30,008 329,210 362,971 33,761 9.3 03 NURSING/HEALTH SERVICES 14,886 175,590 193,244 17',654 9.1 04 SENIOR CITIZEN LEIS ACTIVITIES 3,002 26,613 41,962 15,349 36.6 05 COMMUNITY CONNECTIONS CENTER -34,368 173,574 381,101 207,527 54.5 Totals 27,966 847,711 1,173,825 326,114 27.8 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 53,457 509,968 677,842 167,874 24.8 51 EMPLOYEE BENEFITS 15,083 175,372 208,444 33,072 15.9 52 OTHER EMPLOYEE COSTS 29 2,436 9,370 6,934 74.0 54 CONTRACTUAL SERVICES 5,579 73,091 137,067 63,976 46.7 55 UTILITIES 775 9,062 15,200 6,138 40.4 57 COMMODITIES & SUPPLIES 3,012 23,447 53,537 30,090 56.2 64 BUILDING IMPROVEMENTS -49,969 12,566 43,470 30,904 71.1 65 OFFICE EQUIPMENT 0 41,769 28,895 -12,874 -44.6 Totals 27,966 847,711 1,173,825 326,114 27.8 SOURCE OF FUNDS 001 GENERAL FUND 27,966 847,711 1,173,825 326,114 27.8 Totals 27,966 847,711 1,173,825 326,114 27.8 q 12/08/2009 17:18:12 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 11/30/09 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 443,681 635,905 20,905 92,936 3,206 50,891 Totals 1,247,524 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 667,593 468,996 1,416 100,568 2,939 5,534 478 o o Totals 1,247,524 SOURCE OF FUNDS 001 GENERAL FUND 060 LAW ENFORCEMENT BLOCK GRANT 080 ASSET SEIZURE FUND 085 DEA SHARED FUNDS FUND 086 DUI FINE FUND 1,247,524 o o o o Totals 1,247,524 10 Y-T-D Expended 2,656,107 7,612,334 221,270 1,134,593 27,673 629,704 12,281,681 8,106,211 2,690,215 133,177 1,175,913 34,507 100,957 4,361 36,340 o 12,281,681 12,254,101 o 7,416 12,721 7,443 12,281,681 2009 Budget 91.6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent 3,254,349 8,678,721 250,585 1,280,616 30,410 689,990 14,184,671 9,292,355 3,310,006 149,300 1,253,040 37,400 112,320 14,050 16,200 o 14,184,671 14,180,171 o 2,000 1,000 1,500 14,184,671 598,242 1,066,387 29,315 146,023 2,737 60,286 1,902,990 1,186,144 619,791 16,123 77,127 2,893 11,363 9,689 -20,140 o 1,902,990 1,926,070 o -5,416 -11,721 -5,943 1,902,990 18.4 12.3 11.7 11.4 9.0 8.7 13.4 12.8 18.7 10.8 6.2 7.7 10.1 69.0 -124.3 13.4 13.6 -270.8 ****.* -396.2 13.4 12/08/2009 17,18,12 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 11/30/09 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 401,721 560,219 o 41,509 3,764 38,779 1,404 7,973 145 Totals 1,055,514 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 526,963 425,706 24,797 o 51,785 2,466 3,320 o o 20,477 Totals 1,055,514 SOURCE OF FUNDS 001 GENERAL FUND 095 FOREIGN FIRE TAX BOARD FUND 1,055,369 145 Totals 1,055,514 Y-T-D Expended 1,945,606 6,639,664 6,375 510,888 47,333 426,635 72,560 27,543 8,966 9,685,570 6,526,945 2,218,656 107,504 1,013 628,105 30,453 86,789 3,887 199 82,019 9,685,570 9,676,604 8,966 9,685,570 2009 Budget 2,496,719 7,453,342 14,131 570,607 59,300 465,349 19,303 32,737 15,500 11,126,988 7,305,165 2,801,338 142,729 500 663,466 42,000 61,767 3,800 o 106,223 11,126,988 11,111,488 15,500 11,126,988 91.6% 8.3% Unexpended Balance 551,113 813,678 7,756 59,719 11,967 38,714 -53,257 5,194 6,534 1,441,418 778,220 582,682 35,225 -513 35,361 11,547 -25,022 -87 -199 24,204 1,441,418 1,434,884 6,534 1,441,418 Completed Remaining Unexpended Percent 22.1 10.9 54.9 10.5 20.2 8.3 -275.9 15.9 42.2 13.0 10.7 20.8 24.7 -102.6 5.3 27.5 -40.5 -2.3 22.8 13.0 12.9 42.2 13.0 12/08/2009 17:18:12 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 11/30/09 PUBLIC WORKS - ADMINISTRATION Cur Mo Expended PROGRAM TOTALS 01 PUBLIC WORKS ADMINISTRATION 105,266 Totals 105,266 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,597 10,692 1,157 75,559 1,261 o o o Totals 105,266 SOURCE OF FUNDS 001 GENERAL FUND 105,266 Totals 105,266 12 Y-T-D Expended 1,230,278 1,230,278 208,386 128,152 22,871 842,034 16,000 12,580 o 255 1,230,278 1,230,278 1,230,278 2009 Budget 1,376,962 1,376,962 256,740 143,468 23,552 917,501 20,837 14,609 o 255 1,376,962 1,376,962 1,376,962 91.6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent 146,684 146,684 48,354 15,316 681 75,467 4,837 2,029 o o 146,684 146,684 146,684 10.7 10.7 18.8 10.7 2.9 8.2 23.2 13.9 10.7 10.7 10.7 12/08/2009 17:18:12 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 11/30/09 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 9,855 51,776 14,652 11,733 o 8,485 2,296 7,722 4,762 9,484 o o Totals 120,765 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 69,381 23,065 19,535 2,907 133 5,107 o o o 637 Totals 120,765 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 620 VILLAGE PARKING SYSTEM FUND 630 PARKING SYSTEM REVENUE FUND 106,519 o 4,762 9,484 Totals 120,765 1, Y-T-D Expended 137,256 767,514 467,276 625,924 o 141,352 50,998 100,077 63,996 133,588 o o 2,487,981 1,128,887 325,359 568,337 27,755 1,465 302,091 o o o 134,087 2,487,981 1,997,638 292,759 63,996 133,588 2,487,981 2009 Budget 152,331 960,151 503,336 651,319 o 178,718 65,695 114,339 131,101 143,648 o o 2,900,638 1,277,373 358,165 672,656 71,230 1,598 368,960 o 13,056 o 137,600 2,900,638 2,326,457 299,432 131,101 143,648 2,900,638 91.6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent 15,075 192,637 36,060 25,395 o 37,366 14,697 14,262 67,105 10,060 o o 412,657 148,486 32,806 104,319 43,475 133 66,869 o 13,056 o 3,513 412,657 328,819 6,673 67,105 10,060 412,657 9.9 20.1 7.2 3.9 20.9 22.4 12.5 51.2 7.0 14.2 11.6 9.2 15.5 61. 0 8.3 18.1 100.0 2.6 14.2 14.1 2.2 51.2 7.0 14.2 12/08/2009 17,18,12 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 11/30/09 PUBLIC WORKS - FORESTRY/GRNDS Cur Mo Expended PROGRAM TOTALS 01 FORESTRY DIVISION ADMIN 02 MAINTENANCE OF GROUNDS 03 FORESTRY PROGRAM 04 PUBLIC GROUNDS BEAUTIFICATION 16,841 24,229 49,093 2,599 Totals 92,762 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT 53,069 16,671 o 22,617 405 o Totals 92,762 SOURCE OF FUNDS 001 GENERAL FUND 690 RISK MANAGEMENT FUND 92,762 o Totals 92,762 14 Y-T-D Expended 200,960 403,980 825,830 62,161 1,492,931 652,407 202,894 3,665 573,564 43,901 16,500 1,492,931 1,492,931 o 1,492,931 2009 Budget 225,096 447,623 986,313 75,707 1,734,739 748,292 225,495 3,662 688,595 51,964 16,731 1,734,739 1,723,239 11,500 1,734,739 91. 6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent 24,136 43,643 160,483 13,546 241,808 95,885 22,601 -3 115,031 8,063 231 241,808 230,308 11,500 241,808 10.7 9.7 16.3 17.9 13.9 12.8 10.0 -0.1 16.7 15.5 1.4 13.9 13 .4 100.0 13.9 12/08/2009 17:18:12 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 11/30/09 PUBLIC WORKS - ENGINEERING Cur Mo Expended PROGRAM TOTALS 01 ENGINEERING SERVICES 05 TRAFFIC CNTRL & STREET LGHTNG 59,309 39,008 Totals 98,317 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 49,916 14,532 385 14,333 18,344 807 o o o Totals 98,317 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 69,747 28,570 Totals 98,317 15 Y-T-D Expended 737,440 543,090 1,280,530 624,597 177,688 3,944 89,450 178,155 19,102 o 1,326 186,268 1,280,530 894,966 385,564 1,280,530 2009 Budget 806,084 708,712 1,514,796 683,255 192,224 4,152 137,237 221,000 26,855 46 1,327 248,700 1,514,796 1,029,226 485,570 1,514,796 91.6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent 68,644 165,622 234,266 58,658 14,536 208 47,787 42,845 7,753 46 1 62,432 234,266 134,260 100,006 234,266 8.5 23.4 15.5 8.6 7.6 5.0 34.8 19.4 28.9 100.0 0.1 25.1 15.5 13 .0 20.6 15.5 12/08/2009 17:18:12 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 11/30/09 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 96,531 13,654 5,796 44,307 88,164 21,776 18,894 55,819 28,332 299,248 285,362 Totals 957,883 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,350 45,443 o 566,943 13,854 5,856 7,479 o o o 188,958 Totals 957,883 SOURCE OF FUNDS 610 WATER AND SEWER FUND 957,883 Totals 957,883 16 Y-T-D Expended 1,130,736 234,047 81,367 481,669 759,793 302,444 266,192 614,004 373,173 2,042,688 2,928,631 9,214,744 1,548,973 546,242 20,078 4,716,829 128,460 64,420 142,615 o 4,431 316,951 1,725,745 9,214,744 9,214,744 9,214,744 2009 Budget 91.6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent 1,421,679 202,567 107,453 616,596 1,100,921 390,041 382,538 669,823 1,113,947 2,725,280 3,778,000 12,508,845 1,874,948 620,618 49,430 6,056,104 190,944 70,276 243,115 o 7,575 1,058,795 2,337,040 12,508,845 12,508,845 12,508,845 290,943 -31,480 26,086 134,927 341,128 87,597 116,346 55,819 740,774 682,592 849,369 3,294,101 325,975 74,376 29,352 1,339,275 62,484 5,856 100,500 o 3,144 741,844 611,295 3,294,101 3,294,101 3,294,101 20.5 -15.5 24.3 21.9 31.0 22.5 30.4 8.3 66.5 25.0 22.5 26.3 17.4 12.0 59.4 22.1 32.7 8.3 41.3 41.5 70.1 26.2 26.3 26.3 26.3 12/08/2009 17:18:12 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 11/30/09 PUBLIC WORKS - REFUSE DISPOSAL Cur Mo Expended PROGRAM TOTALS 01 REFUSE DISPOSAL PROGRAM 02 REFUSE LEAF REMOVAL PROGRAM 293,806 67,178 Totals 360,984 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 62,807 12,608 o 283,008 26 2,211 324 Totals 360,984 SOURCE OF FUNDS 030 REFUSE DISPOSAL FUND 360,984 Totals 360,984 Y-T-D Expended 3,434,574 193,348 3,627,922 216,348 63,475 199 3,299,891 364 24,324 23,321 3,627,922 3,627,922 3,627,922 2009 Budget 3,980,963 213,284 4,194,247 244,027 69,954 1,200 3,819,121 610 26,535 32,800 4,194,247 4,194,247 4,194,247 91.6% 8.3% Unexpended Balance 546,389 19,936 566,325 27,679 6,479 1,001 519,230 246 2,211 9,479 566,325 566,325 566,325 Completed Remaining Unexpended Percent 13.7 9.3 13.5 11.3 9.3 83.4 13.6 40.3 8.3 28.9 13.5 13 .5 13.5 12/08/2009 17:18:12 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 11/30/09 PUBLIC WORKS - VEHICLE MAINT Cur Mo Expended PROGRAM TOTALS 01 VEHICLE MAINTENANCE ADMIN 02 VEHICLE MAINTENANCE PROGRAM 12,276 122,584 Totals 134,860 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 63,686 21,179 o 7,129 64 42,802 o o o Totals 134,860 SOURCE OF FUNDS 660 VEHICLE MAINTENANCE FUND 134,860 Totals 134,860 18 Y-T-D Expended 148,257 1,370,645 1,518,902 709,741 242,909 2,599 89,618 910 471,676 o o 1,449 1,518,902 1,518,902 1,518,902 2009 Budget 190,315 1,782,435 1,972,750 874,252 279,094 2,315 118,417 1,090 693,537 o 545 3,500 1,972,750 1,972,750 1,972,750 91.6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent 42,058 411,790 453,848 164,511 36,185 -284 28,799 180 221,861 o 545 2,051 453,848 453,848 453,848 22.1 23.1 23.0 18.8 13 .0 -12.3 24.3 16.5 32.0 100.0 58.6 23.0 23.0 23.0 12/08/2009 17:18:12 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 11/30/09 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 5,104 15,766 604 231 Totals 21,705 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 13,633 2,304 4,116 664 988 Totals 21,705 SOURCE OF FUNDS 001 GENERAL FUND 21,705 Totals 21,705 19 Y-T-D Expended 112,101 165,815 23,177 2,426 303,519 90,801 12,716 153,998 45,016 988 303,519 303,519 303,519 2009 Budget 123,475 162,509 65,703 2,897 354,584 91,231 16,723 184,960 53,670 8,000 354,584 354,584 354,584 91.6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent 11,374 -3,306 42,526 471 51,065 430 4,007 30,962 8,654 7,012 51,065 51,065 51,065 9.2 -2.0 64.7 16.3 14.4 0.5 24.0 16.7 16.1 87.7 14.4 14 .4 14.4 12/08/2009 17:18:12 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 11/30/09 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 40,099 4,076 13,215 20,795 520,789 429,886 14,031 782,477 427,029 239,520 Totals 2,491,917 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 62,610 o 4,076 1,435,794 14,031 429,886 o 545,520 o o o Totals 2,491,917 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 64,587 1,449,026 13,215 500,377 20,795 o 429,886 14,031 Totals 2,491,917 20 Y-T-D Expended 371,485 44,311 310,547 689,273 2,772,604 1,875,933 144,229 3,582,214 1,462,499 1,431,021 12,684,116 1,031,806 85,944 18,614 5,840,537 144,229 1,875,933 268,067 3,418,986 o o o 12,684,116 o 965,825 507,502 6,475,734 310,547 1,715,073 689,273 o 1,875,933 144,229 12,684,116 2009 Budget 1,463,850 216,000 1,924,650 235,000 4,184,700 2,535,500 188,150 8,378,000 2,034,000 2,237,000 23,396,850 1,814,720 1,717,250 62,800 10,948,580 395,150 2,535,500 1,801,550 4,121,300 o o o 23,396,850 1,328,100 1,544,850 12,784,000 1,924,650 2,856,600 235,000 o 2,535,500 188,150 23,396,850 91. 6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent 1,092,365 171,689 1,614,103 -454,273 1,412,096 659,567 43,921 4,795,786 571,501 805,979 10,712,734 782,914 1,631,306 44,186 5,108,043 250,921 659,567 1,533,483 702,314 o o o 10,712,734 362,275 1,037,348 6,308,266 1,614,103 1,141,527 -454,273 o 659,567 43,921 10,712,734 74.6 79.5 83.9 -193.3 33.7 26.0 23.3 57.2 28.1 36.0 45.8 43.1 95.0 70.4 46.7 63.5 26.0 85.1 17.0 45.8 27.3 67.1 49.3 83.9 40.0 -193.3 26.0 23.3 45.8 12/08/2009 17:18:12 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 11/30/09 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 1,513,663 o o o Totals 1,513,663 EXPENDITURE CLASSIFICATION 59 OTHER EXPENDITURES 71 BOND PRINCIPAL 72 INTEREST EXPENSE 73 BANK AND FISCAL FEES 80 INTERFUND TRANSFERS o 925,000 588,513 150 o Totals 1,513,663 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 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 o 298,020 709,953 505,690 o o o o o o o Totals 1,513,663 21 Y-T-D Expended 1,797,536 o 494,952 o 2,292,488 o 1,330,261 961,027 1,200 o 2,292,488 o 381,340 910,506 505,690 o o o o 494,952 o o 2,292,488 2009 Budget 91.6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent 1,291,848 o 613,354 o 1,905,202 1,225,219 678,783 1,200 o 1,905,202 o 381,340 910,508 o o o o o 613,354 o o 1,905,202 -505,688 o 118,402 o -387,286 o o -105,042 -282,244 o o -387,286 o o 2 -505,690 o o o o 118,402 o o -387,286 -39.1 19.3 -20.3 -8.6 -41. 6 -20.3 19.3 -20.3 12/08/2009 17:18:12 FRRDBROl SUM031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 11/30/09 11 Months 1 Month 91. 6% 8.3% Completed Remaining Totals Cur Mo Y-T-D 2009 Unexpended Unexpended Expended Expended Budget Balance Percent 3,800 41,791 46,500 4,709 10.1 258,204 2,830,584 2,993,500 162,916 5.4 251,007 2,738,755 2,951,500 212,745 7.2 513,011 5,611,130 5,991,500 380,370 6.3 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 512,711 5,608,660 5,984,500 375,840 6.3 300 2,470 5,000 2,530 50.6 0 0 2,000 2,000 100.0 513,011 5,611,130 5,991,500 380,370 6.3 SOURCE OF FUNDS 001 GENERAL FUND 710 POLICE PENSION FUND 720 FIRE PENSION FUND Totals 3,800 41,791 46,500 4,709 10.1 258,204 2,830,584 2,993,500 162,916 5.4 251,007 2,738,755 2,951,500 212,745 7.2 513,011 5,611,130 5,991,500 380,370 6.3 22 12/08/2009 17:18:12 FRRDBROl SUM031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 11/30/09 11 Months 1 Month 91.6%- 8.3%- Completed Remaining Cur Mo Y-T-D 2009 Unexpended Unexpended RISK MANAGEMENT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 CASUALTY & PROPERTY INSURANCE -134,190 1,104,923 967,700 -137,223 -14.2 02 MEDICAL INSURANCE 432,188 4,606,641 5,705,136 1,098,495 19.3 Totals 297,998 5,711,564 6,672,836 961,272 14.4 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 0 0 15,000 15,000 100.0 56 INSURANCE 297,998 5,711,564 6,630,336 918,772 13.9 67 OTHER EQUIPMENT 0 0 27,500 27,500 100.0 Totals 297,998 5,711,564 6,672,836 961,272 14.4 SOURCE OF FUNDS 690 RISK MANAGEMENT FUND 297,998 5,711,564 6,672,836 961,272 14 .4 Totals 297,998 5,711,564 6,672,836 961,272 14.4 23 12/08/2009 17:18:12 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 11/30/09 NON-DEPARTMENTAL Cur Mo Expended Unexpended Unexpended Balance Percent PROGRAM TOTALS 01 CONTINGENCIES Totals EXPENDITURE CLASSIFICATION 80 INTERFUND TRANSFERS Totals SOURCE OF FUNDS 001 GENERAL FUND Totals 24 Y-T-D Expended 2009 Budget o o o o o o o o o o o o 91.6% Completed 8.3% Remaining o o o o o o o o o o o o 12/08/2009 17:18:12 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 11/30/09 CAPITAL FIXED ASSETS Cur Mo Expended Unexpended Unexpended Balance Percent 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 2009 Budget o o o o o o o o o o o o 91.6% 8.3% Completed Remaining o o o o o o o o o o o o 12/08/2009 17:18:12 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 11/30/09 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 2009 Budget o 9,450,626 o 9,450,626 o 9,450,626 o 9,450,626 o 9,450,626 o 9,450,626 91.6%- S.3%- Completed Remaining 9,450,626 100.0 9,450,626 100.0 9,450,626 100.0 9,450,626 100.0 9,450,626 100.0 9,450,626100.0 REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY DEC082009 15:44 RELEASE ID : PAGE VI11AGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 26 2009 TO DECEMBER 09 2009 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 001 06607 ADAMS, CYNTHIA PROPERTY TAX RELIEF GRANT 09 100.00 01335 ALEXIAN BROTHERS CORPORATE HEALTH SERVICES PRE-EMPLOYMENT DT /PHYSICALS 69.00 01561 AMERICAN CHARGE SERVICE SENIOR TAXI PROGRAM 21.00 02270 AT&T SERVICE 11/16/09 - 12/15/09 3.25 SERVICE 11/16/09 - 12/15/09 10.84 SERVICE 11/16/09 - 12/15/09 2.17 SERVICE 11/16/09 - 12/15/09 3.25 SERVICE 11/16/09 - 12/15/09 21.68 SERVICE 11/16/09 - 12/15/09 10.84 SERVICE 11/16/09 - 12/15/09 41.19 SERVICE 11/16/09 - 12/15/09 10.84 SERVICE 11/16/09 - 12/15/09 16.26 SERVICE 11/16/09 - 12/15/09 28.18 SERVICE 11/16/09 - 12/15/09 8.67 SERVICE 11/16/09 - 12/15/09 8.67 SERVICE 11/16/09 - 12/15/09 39.02 SERVICE 11/16/09 - 12/15/09 220.05 SERVICE 11/16/09 - 12/15/09 215.71 SERVICE 11/16/09 - 12/15/09 138.75 SERVICE 11/16/09 - 12/15/09 331.81 ------------- 1111.18 04215 AUTUMN TREE CARE EXPERTS FALL FERTILIZATION&SOIL INJECT 353.50 10517 AVANT! CAFE & SANDWICH BAR, INC. HOLIDAY LUNCHEON 2009 710.00 10540 BATTERIES PLUS #290- 33690 STOCK BATTERIES 63.16 #290- 33199 STOCK BATTERIES 119.73 #291- 32954 GEORGE STREET LIFT 19.99 #290- 33404 FIRE PANELS-V, HALL 159.92 ------------- 362.80 09875 BENSON, ETHEL J. PROPERTY TAX RELIEF GRANT 09 13.57 08914 BERTUCA, ANGELINE PROPERTY TAX RELIEF GRANT 09 100.00 08853 BIANCO, JOSEPHINE M' PROPERTY TAX RELIEF GRANT 09 100.00 09609 BONO,CSR,LTD., KATHLEEN WU SUNG HEARING COSTS 402.75 09367 BUGL, JOAN C. PROPERTY TAX RELIEF GRANT 09 18.75 07425 BURZAK, GERALDINE PROPERTY TAX RELIEF GRANT 09 77.30 09373 BUSSE, JEANNE M. PROPERTY TAX RELIEF GRANT 09 100.00 01009 BYRNE, WANDA PROPERTY TAX RELIEF GRANT 2009 90.99 01049 COW GOVERNMENT, INC SMARTNET RENEWAL FOR 3560GTS S 500.00 SMARTNET RENEWAL FOR 3560GPS 600.00 REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY DEC082009 15:44 RELEASE 10 : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 26 2009 TO DECEMBER 09 2009 -.................. --.............................................................................. --...................... --- --................ --...................................................................................... ---............ DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ........................................................................................................................ --_...................... --.... ---- --.................... --................ --.................................. --............ MS SQL SVR STD 2008 PROC LIC - 7141.76 ------------- 8241. 76 09804 CHOE, PYONG PROPERTY TAX RELIEF GRANT 2009 100.00 07281 CL GRAPHICS, INC. INV#49834 CALENDAR SELF MAILER 3363.74 INV# 137 48 POSTAGE 399.26 INV#13676 POSTAGE 176.69 ------------- 3939.69 11922 CLINE, KEITH PROPERTY TAX RELIEF GRANT 2009 100.00 08871 CORSO, SENA M. PROPERTY TAX RELIEF GRANT 2009 5.37 04504 CORTESI, VICTORIA J. PROPERTY TAX RELIEF GRANT 09 21. 45 11403 COSTAR REALTY INFORMATION, INC ED SITE SOFTWARE 435.00 01200 CRAIN I S CHICAGO BUSINESS CRAINS 2010 RENEWAL 97.95 11408 CRYSTAL COURT SHOPPING CENTER DECEMBER 2009 RENT 3338.00 09115 D. J. I S SCUBA LOCKER Water Rescue & Recovery Equipm 4090.18 11129 DAVE, KALPANA PROPERTY TAX RELIEF GRANT 2009 100.00 05982 DELUXE BUSINESS CHECKS & SOLUTIONS DEPOSIT TICKETS-GENERAL ACCT 83.38 07403 DISTEFANO, FRANK PROPERTY TAX RELIEF GRANT 2009 51.41 11237 DULTMEIER SALES DAVENPORT INC REPLACEMENT BALL VALVES 398.21 04447 DUREC, ANNA RITA PROPERTY TAX RELIEF GRANT 2009 58.97 09653 ETERNO, DAVID G. ADMINISTRATIVE ADJUDICATION 862.50 10393 EXPERTPAY PAYROLL FOR - 120309 3207.52 04501 FAVIA, CORRINE M. PROPERTY TAX RELIEF GRANT 09 94.05 11212 FDC DIGITAL IMAGING SOLUTIONS SERVICE AND MAINTENANCE AGREEM 59.00 01377 FEDERAL EXPRESS CORP FEDEX EXPRESS SERVICE 11/06/09 11.02 DELIVERY CHARGES 11/13/09 21.25 ------------- 32.27 08242 FERRARO, MARY S. PROPERTY TAX RELIEF GRANT 09 71.34 05563 FERSTAND, BARBARA PROPERTY TAX RELIEF GRANT 2009 100.00 04438 FETZER, KATHAR1NA PROPERTY TAX RELIEF GRANT 2009 5.02 08765 FIFTH THIRD BANK WEB CERTIFICATE RENEWAL-W. MAIL 399.00 WEB CERTIFICATE RENEWAL-MSGBD 399.00 REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY DEC082009 15: 44 RELEASE 10 : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 26 2009 TO DECEMBER 09 2009 ...... -.......................... --...... --.............................................................................................................................. ---.............................. --.................... --........................ DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .......... --............ --.... --.......................................................... --.......................... --.................................................................................................................................... BOOKS 237.70 WINZIP UPGRADE 140.00 ------------- 1175.70 00102 FIRE PENSION FUND PAYROLL FOR - 120309 28647.17 01422 FOLGERS FLAG & DECORATING, INC INV#0014804- IN HOLIDAY DEC/BAN 3195.00 INV#0014737-IN HOLIDAY DEC/BAN 1500.00 ------------- 4695.00 06411 FRIEDMAN, CHAYA ACCESS DATABASE FOR 11/18/09 375.00 NEW DATABASE FOR THE MRC 375.00 ------------- 750.00 08918 FRIES, MARIE E. PROPERTY TAX RELIEF GRANT 09 100.00 01456 GABZDYL, BOZENA PROPERTY TAX RELIEF GRANT 2009 63.89 09198 GE CAPITAL SERVICE 11/15/09 - 12/14/09 192.74 SERVICE 11/15/09 - 12/14/09 192.74 SERVICE 11/15/09 - 12/14/09 192.74 SERVICE 11/15/09 - 12/14/09 192.74 ------------- 770.96 1I893 GLUNZBEER, LOUIS REFUND OVER PYMT P#3891460 30.00 04489 GOER INGER, CAROL D. PROPERTY TAX RELIEF GRANT 2009 100.00 01522 GRAINGER LAUNDRY DETERGENT 96.35 06420 GRAYBAR ELECTRIC CO. 36 - 150 W HPS BULBS 392.76 5 - 150 W HPS BALLAST KITS 288.75 5 - 250 W HPS BALLAST KITS 281.00 5 - 400 W HPS BALLAST KITS 342.50 ------------- 1305.01 11918 GRINIOUK, SVETLAMA REFUND OVER PYMT P#3870893 10.00 04449 GUNIA, ANNA PROPERTY TAX RELIEF GRANT 2009 100.00 11074 HANDZEL, VIRGINIA PROPERTY TAX RELIEF GRANT 09 95.08 01559 HANSEN INFORMATION TECHNOLOGY DATA CONVERSION OF TREE MANAGE 9187.50 03552 HARDESTY, ELI ZABETH M. PROPERTY TAX RELIEF GRANT 09 81.50 09205 HEALTH ENDEAVORS ANNUAL MEDICAL EXAMS 6780.00 05547 HEHN, HERTA A. PROPERTY TAX RELIEF GRANT 09 81.87 05729 HEINRICH, LARRY CLOTHING ALLOWANCE 150.00 REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY DEC082009 15:44 RELEASE 10 : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 26 2009 TO DECEMBER 09 2009 ...................... --.............. --........................................................................ --..................................... -....................................... --...... --............ --.... ---.. --..................- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ................................ ---.................................................................................. --...... --.... --....... --...... -- --................................ ---.. --...... --.... -_.. ---........................- 11923 HENGLER, RICHARD PROPERTY TAX RELIEF GRANT 2009 100.00 11777 HINCKLEY SPRINGS BOTTLED WATER & COOLER RENTAL 78 .06 08618 HORIZON BLUE CROSS BLUE SHIELD OF NEW JERSEY REFUND DUPLICATE PAYMENT 36.20 10708 HUFFMAN LANDSCAPE 2009 FALL TREE PLANTING PROG 21665.00 2009 FALL TREE PLANTING PROG 3700.00 RETAINAGE 1268.25- RETRAINER RELEASE FALL 08 1684.25 ------------- 25781.00 04450 HURIN, MARIANNE PROPERTY TAX RELIEF GRANT 09 98.79 10257 ICMA 401A PLAN PAYROLL FOR - 120309 3019.16 00107 ICMA RETIREMENT TRUST - 457 PAYROLL FOR - 120309 18118.79 07367 ILLINOIS CENTURY NETWORK COMMUNICATION CHARGES 310.00 00108 ILLINOIS DEPARTMENT OF REVENUE PAYROLL FOR - 120309 29919.46 01681 ILLINOIS FIRE CHIEFS ASSOC. Registration/Skindingsrude, La 250.00 Registration/Hunt, Wojci k, Peter 250.00 ------------- 500.00 10295 ILLINOIS STUDENT ASSISTANCE COMMISSION PAYROLL FOR - 120309 205.41 09562 IMRF PAYROLL FOR - 120309 475.63 PAYROLL FOR - 120309 44033.18 PAYROLL FOR - 120309 22288.97 ------------- 66797.78 07694 INTERNATIONAL CODE COUNCIL REGISTRATION -ADAM PANEK 59.00 09832 INTERNATIONAL UNION OF OPERATING ENGINEERS PAYROLL FOR - 120309 964.49 PAYROLL FOR - 120309 277.20 ------------- 1241.69 09563 IRS PAYROLL FOR - 120309 237634.52 04451 JACOBS, JULIA M. PROPERTY TAX RELIEF GRANT 2009 98.31 10438 JAMAL I , NOORUDDIN PROPERTY TAX RELIEF GRANT 09 100.00 11130 JANKOWSKA, JANINA PROPERTY TAX RELIEF GRANT 2009 75.48 11131 JANNISH, SUSAN PROPERTY TAX RELIEF GRANT 2009 100.00 11436 JONES, PERCY REPLACE CHECK#13014576 36.00 01783 JOORNAL & TOPICS NEWSPAPERS DISPLAY ADVERTISING 11/11/09 288.00 LEGAL FOR PZ-28-09 126.96 REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY DEC082009 15:44 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 26 2009 TO DECEMBER 09 2009 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ------------- 414.96 09788 KARLSTEDT LANDSCAPE, INC. FALL VILLAGE HALL URN PLANTING 830.00 11896 KAZANIS, THEODORE PROPERTY TAX RELIEF GRANT 09 54.16 01Bl8 KERSTEIN, JUNE REIMB EXP NOVEMBER 09 83.88 01823 KIPLINGER LETTER RENEWAL 2010 ACCT#0018458372 89.00 06545 KLINGBEIL, INGEBORG PROPERTY TAX RELIEF GRANT 09 51.53 11898 KOUTRIS, NICK PROPERTY TAX RELIEF GRANT 09 100.00 09806 LACORTE, MARIA PROPERTY TAX RELIEF GRANT 09 100.00 01856 LAGERHOLM, GLORIA PROPERTY TAX RELIEF GRANT 2009 37.93 04436 LAKE, KAREN PROPERTY TAX RELIEF GRANT 2009 100.00 09766 LANER MOCHIN LABOR RELATIONS LEGAL SERV-NOV 7630.23 08899 LEMBERG, VIRGINIA L. PROPERTY TAX RELIEF GRANT 2009 39.04 01897 LIFE ASSIST Ambulance Supplies, Ring Cutte 390.40 00379 LINDELOF, CHARLES M. REIMB RENEWAL OF PE LICENSE 60.00 01903 LOCKWOOD, BARBARA B. PROPERTY TAX RELIEF GRANT 09 100.00 04366 LOWRY, DOREEN M. PROPERTY TAX RELIEF GRANT 09 62.61 01955 MARGARITIS, DINA P. PROPERTY TAX RELIEF GRANT 09 47.13 08515 MCCALL, JEANNE PROPERTY TAX RELIEF GRANT 09 100.00 00116 METRO FEDERAL CREDIT UNION PAYROLL FOR - 120309 2493.48 00117 METROPOLITAN ALLIANCE - POLICE PAYROLL FOR - 120309 1039.00 05317 MICHALSKI, JAMES REFUND BUILDING PERMIT#OH51 75.00 00396 MILLER, JAMES REIMB EXP SUPPLIES 10/20/09 91.62 02035 MILLER, JANE PROPERTY TAX RELIEF GRANT 09 100.00 06489 MIODUSZEWSKA, ELZBIETA PROPERTY TAX RELIEF GRANT 2009 93.46 11894 MISEVSKI, MISA REFUND OVER PYMT P#3892964 10.00 11738 MONTOYA TREE SERVICE REMOVE PRIVATE DISEASED ELM&G 800.00 09521 MS GOVERN GEMS UPGRADE TO FMS 6.7 600.00 00123 NATIONWIDE MUTUAL INSURANCE COMPANY PAYROLL FOR - 120309 19719.50 REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY DEC082009 15: 44 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 26 2009 TO DECEMBER 09 2009 ... -..................... --...................... --.................................................................................................................. -_..................... --........................... --................. --..................... --......................... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .................. --................. -- --........................................................... -- -_................ ---.......................... -- --................... --............... -- --... --_................ --.. -- ---..... --.................. --... 02148 NEOPOST INC. MONET ENTERED INTO POSTAGE M. 3000.00 02155 NEXTEL COMMUNICATIONS SERVICE 10/18/09-11/17/09 949.00 SERVICE 10/18/09-11/17/09 14 5.0 8 SERVICE 10/18/09-11/17/09 136.53 SERVICE 10/18/09-11/17/09 701.36 SERVICE 10/18/09-11/17/09 25.78 SERVICE 10/18/09-11/17/09 223.88 SERVICE 10/18/09-11/17/09 25.55 SERVICE 10/18/09-11/17/09 1421.47 SERVICE 10/18/09-11/17/09 262.30 SERVICE 10/18/09-11/17/09 452.58 SERVICE 10/18/09-11/17/09 22.70 SERVICE 10/18/09-11/17/09 331.2 8 ------------- 4697.51 05256 NICOR ACCT#97-78-90-2800-4 61.41 ACCT#03- 35-77-9926-5 41.16 ACCT#13-81-78-6961-6 18.45 ------------- 121.02 04485 NORDIN, JAMES REIMB FOR CDL RENEWAL 50.00 11897 NORRIS, HENRIETTA B. PROPERTY TAX RELIEF GRANT 09 57.25 02189 NORTHWEST CENTRAL DISPATCH SYS JANUARY 2010 MEMBER ASSESSMENT 39558.70 JANUARY 2010 MEMBER ASSESSMENT 9889.68 ------------- 49448.38 11916 NOWAK, CHRISTOPHER & CHRISTINA REAL ESTATE TAX REBATE 940.00 02212 NUTOYS LEISURE PRODUCTS BIKE RACKS FOR THE CC CENTER 474.00 10162 OVERHEAD GARAGE DOOR, INC. #D37344 REPAIRS PUBLIC SAFETY 2221.66 #D37359 REPAIRS 1700 \'l.CENTRAL 373.04 #D37557 REPAIRS 1601 W.GOLF RD 486.74 #D37097 REPAIRS PUBLIC SAFETY 550.00 #D37142 REPLACEMENT P. SAFETY 1485.00 ------------- 5116.44 11071 OZENI, SHIRa PROPERTY TAX RELIEF GRANT 09 100.00 10476 PACIFIC TELEMANAGEMENT SERVICES PAY PHONE SERVICE DECEMBER 09 78.00 02256 PADDOCK PUBLICATIONS AD#T4188354 ACCT#8478185370 64.00 AD#T4189l7O ACCT#8473926000 596.70 PUBLICATION OF LEGAL NOTICE 302.40 ------------- 963.10 11901 PALADINO, JOE REBATE 15 SQ PUBLIC WALK 735.00 REBATE 52 LIN FT CURB & GUTTER 390.00 ------------- REPORT: APBOARDRPT GENERATED: 15 APR 09 II: 42 RUN: TUESDAY DEC082009 15: 44 RELEASE I D : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 26 2009 TO DECEMBER 09 2009 - -.......................................................................... -_.................... --.................................. --.................................................................................................................... --....... --....- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ...................... --....................... --........ --............................ -_......................... --.............................................................................. --........................ -- --........................................ 1125.00 07457 PERAKIS, ELLY P. PROPERTY TAX RELIEF GRANT 09 100.00 02303 PETTY CASH - FIRE DEPT. MEETING & SUPPLIES & TRAINING 13.77 MEETING & SUPPLIES & TRAINING 18.00 MEETING & SUPPLIES & TRAINING 9.00 MEETING & SUPPLIES & TRAINING 29.04 MEETING & SUPPLIES & TRAINING 1.94 ------------- 71.75 10002 PLANET CERT IFI CAT ION RENEWAL-M. FELLOW 25.00 04437 POKUTA, LORRAINE PROPERTY TAX RELIEF GRANT 2009 83.53 00124 POLICE PENSION FUND PAYROLL FOR - 120309 34085.13 04921 POPE, ELIZABETH A. PAYROLL FOR - 120309 92 3.0 8 09855 POTTER, JOYCE PROPERTY TAX RELIEF GRANT 09 41.87 10258 POWELL TREE CARE, INC. 2009 PARKWAY TREE REMOVAL CONT 3922. 00 10435 PROCESSWORKS, INC. FLEX NOV 09 688.75 PARKRIGHT SERV MONTHLY ADMIN 50.00 ------------- 738.75 05814 R.A. ADAMS ENTERPRISES SALT SPREADER PARTS 223.96 08850 RAIK, ALICE PROPERTY TAX RELIEF GRANT 09 100.00 02394 RAYCO SIGN SUPPLY 15"X50'&24"X25'SIGN M.MATERIAL 118 .5 0 02399 REBEL'S TROPHIES, INC. PLAQUE YEAR OF SERVICE-ROSCOP 35.00 02401 RED WING SHOE STORE INVff7000000002829 J.PICARDI 140.24 11895 RIEMEHSCHNEIDER, JUNE PROPERTY TAX RELIEF GRANT 09 29.38 02497 SCHIMANSKI, HELEN T. PROPERTY TAX RELEIF GRANT 2009 44.96 05421 SCHMELZER, MARY PROPERTY TAX RELIEF GRANT 09 29.47 11072 SCHOFIELD, THOMAS M. PROPERTY TAX RELIEF GRANT 2009 100.00 10439 SHEA, MARY C. PROPERTY TAX RELIEF GRANT 09 75.97 08849 SKARB, JOHN PROPERTY TAX RELIEF GRANT 09 90.72 08181 SOBOTKA, EDWARD A. PROPERTY TAX RELIEF GRANT 09 100.00 02583 SOUND INCORPORATED SERVICE AGREEMENT DEC 09 828.83 08897 STASCH, EDWARD PROPERTY TAX RELIEF GRANT 2009 78.18 REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY DEC082009 15: 44 RELEASE 1 D : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 26 2009 TO DECEMBER 09 2009 - -...... -... -... -............. --.................... --............................ --.................................................................... --.. --........... --.................... --.. --.............................. -- --.............. --........... -- --.......... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ........... -_........... -- --........................................ -- --........................................ --.......................................... --...... --............. --.. --......... --.. -............ --..........................................................-- 02627 STEINER ELECTRIC CO. OVERAGE PO#S009627 21.64 INV#S003027259-00 1 187.16 INV#S003037692-001 284.80 INV#S003045875-00 1 359.77 INV#S003048 875-00 1 118.20 INV#S003059873-00 1 230.40 INV#S0030 61564-001 1041.87 INV#S003061702-001 538.80 INV#SOO 30 64 522-00 1 208.15 ANNUAL MAINTENANCE AND FLUID 697.23 ------------- 3688.02 11845 STOBE, ROY REISSUE CK#13018510-WRONG NAME 98.00 11892 THE BUDDY FOUNDATION 3 STRAY DOGS-INTAKE 100.00 02691 THOMPSON ELEVATOR INSPECTIONS INV#09- 3958 2 SEMI -ANNUAL&INEW 149.00 INV#09- 3991 2 SEMI -ANNUAL 74. 00 ------------- 223.00 02701 TONER, VIOLET E. PROPERTY TAX RELIEF GRANT 09 62.86 02722 TRI -STATE ELECTRONIC CORP PATCH PANELS 644.08 10011 TRIPLE CROWN SUPPLY WHEELCHAIR REPAIRS 300.00 00447 TRUTY, CHRIS J. REIMB MEMBERSHIP FEE 2010 50.00 11168 TULEJ, PAWEL PROPERTY TAX RELIEF GRANT 2009 100.00 11413 UNITED HEALTHCARE REFUND DUPLICATE PAYMENT 456.22 02756 UNITED STATES POSTAL SERVICE EMS CARDS NOV 09 8.35 PUBLIC INFORMATION NOV 09 346 7.0 8 ------------- 3475.43 00127 UNITED WAY PAYROLL FOR - 120309 394.52 10531 VCG UNIFORM Various Uniform & Footwear 422 .85 11914 VELIBOR, JELIC REFUND OVERPYMT P#3893271&2702 20.00 11669 VENIT, STEVEN REPLACE CHECK#13016567 10.00 10732 VIKING LIFE-SAVING EQUIPMENT INC. ONE SET OF GEAR l17 4.0 0 00128 VILLAGE OF MOUNT PROSPECT PAYROLL FOR - 120309 22148.72 PAYROLL FOR - 120309 11868.54 ------------- 34017 .26 04314 VILLAGE OF MOUNT PROSPECT - PAYROLL WIRES PAYROLL FOR - 120309 343.86 11657 VISION INTERNET PROVIDERS, INC PROJECT PAYMENT#3 12750.00 REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY DEC082009 15:44 RELEASE 10 : PAGE VILLAGE OF MOONT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 26 2009 TO DECEMBER 09 2009 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 11915 WEIGLE, HUONG REFOND RE- INSPECTION FEE 50.00 06544 WENDT, BIRDELL L. PROPERTY TAX RELIEF GRANT 09 75.44 11924 WERDERITCH, DOROTHY PROPERTY TAX RELIEF GRANT 2009 85.13 02876 WILKS, IRVANA REIMB EXP LUNCH MEET 11/19/09 18.25 PHONE SERVICE 10/16-11/5/09 45.00 ------------- 63.25 11900 WILLIAMS, STELA REBATE 4 SQ POBLIC WALK 196.00 08915 WILLIAMSON, CRAIG PROPERTY TAX RELIEF GRANT 09 100.00 05746 WI SCTF PAYROLL FOR - 120309 542.48 02891 WOJNICKI, WALTER PROPERTY TAX RELIEF GRANT 09 100.00 11903 WOOD, CARLA M. PROPERTY TAX RELIEF GRANT 09 100.00 04491 WUERL, PATRICIA H. PROPERTY TAX RELIEF GRANT 2009 27.68 TOTAL 670793.62 030 02270 AT&T SERVICE 11/16/09 - 12/15/09 4.34 02058 MORTON GROVE AUTOMOTIVE REBOILT ALTRANATOR- LEAF M. 125.00 REBUILT ALTRNATOR-MINl MOOSE 35.00 ------------- 160.00 TOTAL 164.34 J50 11377 GAFFNEY I S PROTECTIVE MAl NT. INC CONSTRUCTION CONTRACT FOR THE 36575.37 05709 MEADE ELECTRIC CO. INC. 2009 TRAFFIC SIGNAL MAINTENANC 18007.00 TOTAL 54582.37 )70 10428 AMERICAN INSTITUTE OF ARCHTECTS 2010 MEMBERSHIP-J .SAEWERT 631. 00 02848 ARTHUR WEILER, I NC. 2009 FALL PARKWAY PLANTINGS 3475.00 01377 FEDERAL EXPRESS CORP SHIPPING ON 11/12/09 25.70 09198 GE CAPITAL SERVICE 11/15/09 - 12/14/09 192.74 TOT AL 4324.44 :80 06752 ILLINOIS ENVIRONMENTAL PROTECTION AGENCY PRINCIPAL PAYMENT 50078.35 INTEREST PAYMENT 10072.38 REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY DEC082009 15:44 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 26 2009 TO DECEMBER 09 2009 PAGE 10 DEPT VENDOR NBR ............. --......... ---.................. --............ --............................................. --........ -- --............ --.............................................................. --........ --................. --.......... --........................... AMOUNT VENDOR NAME INVOICE DESCRIPTION ...... -.................. --.......................... -- --................... --...... --.................. --........................ --........ --........ ---.......................... --......... -- -- ---............ --- --........................... 510 11794 08107 11919 02627 528 11255 06406 11798 05567 i60 11430 PRINCI PAL PAYMENT INTEREST PAYMENT 44880.33 13372.46 TOTAL 118403.52 118403.S2 CHICAGO DROPCLOTH & TARPAULIN 53 - 50' SECTIONS OF 24" TARP 10 - 15' SECTIONS OF 24" TARP FREIGHT ERB I DAVID REIMB EXP 11/20/09 HAYDEN LANDSCAPING CONTRACTORS CORRIDOR IMPROVEMENTS- INST. BR STEINER ELECTRIC CO. INV#S0030578 5 1-002 INV#S003057851-003 INV#SOO 30 67118-00 1 INV#S00307l7S8-001 INV#S003071758-002 INV#S003071758-003 INV#S003088388-001 4256.96 252.00 81.69 4590.65 151.43 4148.90 83.36 83.36 97.22 432.81 370.80 84,38 19.98 TOTAL 10062.89 1171.91 LEO PARDO COMPANIES, INC Modifications at Public Works Fire Station 14 - Construction EOC - Construction SRBL ARCHITECHTS, LTO. Archi tectural Services for Fir Archi tectural Services for Pub Architectural Services for the TOWER WORKS I INC Communications Tower for New F UNITED VISUAL, INC. PROJECTOR SCREEN & SCREEN BOX TOTAL 1646294.66 2070.92 HD SUPPLY WHITE CAP CONSTRUCTION SUPPLY #605012020 100 RED CAST TITLE #605012493 MEASURING&SUPPLIES # 60 30 0 9 9 55 - 0 2MEASURI NG& SUP PL IE #605012575-01MEASURING&SUPPLIE 227815.00 1093036.00 297876.00 1618727 .00 10329.06 5465.23 747 2.4 5 23266.74 2230.00 7180.00 199.44 176.78 119 .12 7675.34 REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY DEC082009 15: 44 PAGE 11 RELEASE I D : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 26 2009 TO DECEMBER 09 2009 .. -.................................................... --..... --........... ---.................................................. --......................... --........ --.......................................................................................... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ......................................... --................... --.. ---....... -- -_................................................................. --................... --............................................................................................ --........ 11774 RUBINO ENGINEERING, INC MATERIAL TESTING SERVICES 880.00 TOTAL 8555.34 610 01620 AMERICAN LANDSCAPING INC. 2009 PARKWAY RESTORATION CONTR 1775.66 2009 PARKWAY RESTORATION CONTR 1045.34 ---..--.....----- 2821.00 02270 AT&T SERVICE 11/16/09 - 12/15/09 289.42 05773 BAXTER & WOODMAN, INC. ENGINEERING SERVICES FOR 2009 1076.19 ENGINEERING SERVICES FOR 2009 1076.19 ------------- 215 2.3 8 01008 BUSSE I S FLOWERS & GIFTS FLORAL ARRANGMENT-D. JONES 75.00 11909 CAMPBELL, LOY REFUND FINAL UTILITY BILL 37.14 05982 DELUXE BUSINESS CHECKS & SOLUTIONS DEPOSIT TICKETS-WATER ACCOUNT 37.98 11904 DEUTSCH BANK REFUND FINAL UTILITY BILL 49.52 01313 DUPAGE TOPSOIL INC. 3 LOADS OF PULVERIZED TOPSOIL 729.00 09050 ELAN TECHNOLOGIES INC. SANITARY SEWER FLOW MONITORING 931.50 SANITARY SEWER FLOW MONITORING 480.65 SANITARY SEWER FLOW MONITORING 450.85 ------------- 1863.00 01544 HBK WATER METER SERVICE WATER METER INSTALLATION SERVI 725.40 11907 HUENE, THOMAS J. REFUND FINAL UTILITY BILL 41.50 01819 KIEFT BROTHERS INC. CONCRETE BLOCK FOR MANHOLE 2590.40 01878 LAYNE CHRISTENSEN COMPANY 5 - DEEP WELL PUMP OILER SYSTE 2500.00 5 - DEEP WELL PUMP OILER SYSTE 2500.00 PROFESSIONAL SERVICES TO DIAGN 1248.00 ------------- 6248.00 06403 LINDCO EQUIPMENT SALES, INC. SNOW PLOW BLADES 9346.80 11908 MACINTOSH, DAVID REFUND FINAL UTILITY BILL 55.71 01965 MART AM CONSTRUCTION PROSPECT MEADOWS WATERMAIN 236036.70 24145.60 ------------- 260182.30 02155 NEXTEL COMMUNICATIONS SERVICE 10/18/09-11/17 /09 581.72 SERVICE 10/18/09-11/17/09 42.50 ------------- REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY DEC082009 15: 44 PAGE 12 RELEASE 10 : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 26 2009 TO DECEMBER 09 2009 ............................................. ---...... -- --....................................... --........... --...... --............................................ --............ --........................ --............................... --.............- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .................................................................................................................. ---........................................................ --................. --........................ ---................ --.........................- 624.22 02287 PEERLESS MIDWEST INC EMERGENCY SERV. CALL PUMP 2 1925.00 11905 PEPLIN, LEONARD A. REFUND FINAL UTILITY BILL 99.04 04417 QUALITY BLACKTOP INC. 2009 ASPHALT RESTORATION CONTR 5349.31 2009 ASPHALT RESTORATION CONTR 4368.61 ------------- 9717.92 02401 RED WING SHOE STORE INV#7000000002844 M.SCHUSTER 89.99 11245 REDWOOD APT PARTNERS REFUND FINAL UTILITY BILL 14.64 02627 STEINER ELECTRIC CO. INV#SO 0 3 0 298 02 -00 1 875.50 02655 SUBURBAN LABORATORIES, INC. ANNUAL CONTRACT FOR WATER SAMP 285.00 02660 SUBURBAN PRINTING PRINTING OF LEAF PROG 60.00 07277 THOMPSON RENTAL STATION EQUIPMENT RENTAL & FINANCE C. 131.2 5 02756 UNITED STATES POSTAL SERVICE PERMIT 699-WATER NOV 09 2205.55 11906 WACHOVIA BANK REFUND FINAL UTILITY BILL 12.38 02832 WALMART COMMUNITY COOLERS FOR SAMPLES 23.76 TOTAL 303308.80 )30 02754 UNION PACIFIC RAILROAD LAND LEASE NOVEMBER 2009 2639.35 TOTAL 2639.35 ]60 11917 ADVANCED TECHNICAL SERVICES REPAIR P-5 RADIO & CLUSTER 488.00 07423 ALEXANDER EQUIP.CO.,INC. STUMP GRINDER BEARINGS 456.85 02070 ARLINGTON HEIGHTS FORD #503848 VEHICLE REPAIR/PARTS 85.54 #504108 VEHICLE REPAIR/PARTS 390.38 #504757 VEHICLE REPAIR/PARTS 48.08 #504596 VEHICLE REPAIR/PARTS 335.97 #504945 VEHICLE REPAIR/PARTS 42.40 #498724 VEHICLE REPAIR/PARTS 16.50 #498830 VEHICLE REPAIR/PARTS 103.12 REPAIR PARTS FOR P-9 322.47 ------------- 1344.46 02270 AT&T SERVICE 11/16/09 - 12/15/09 10.84 10240 AURORA TRl STATE FIRE PROTECTION CO. ,INC. FIRE EXTINGUISHER BRACKETS 12 100.95 10540 BATTERIES PLUS #290- 33793 DIVE TRAILER 24.70 REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY DEC082009 15:44 PAGE 13 RELEASE I D : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 26 2009 TO DECEMBER 09 2009 - - - - -- - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --- - - - - - - - - - - - - -- - - - - - - - - -- - - - - - - - - - - - - -- - - - - - - - - - - - --- - - - - - -- - - - - - - - - - - - - - - - - -- - -- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - - - - - - - -- - - - - - - - -- -- - - -- - - - - - - - - - - - - - - - - - - - - - - --- - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - -- 11337 BREITZMAN, JAMES REIMB REGISTRATION FEE 9/30/09 107.00 MECHANIC TOOL ALLOWANCE 2009 284.90 ------------- 391.90 06642 BRISTOL HOSE & FITTING PLOW/SPREADER HYDRAULIC C. 826.95 01006 BUSSE CAR WASH, INC. CAR WASHES OCTOBER 2009 1157.00 00302 CASTELLANOS, SAL MECHANIC TOOL ALLOWANCE 2009 840.00 01045 CATCHING FLUI DPOWER PARKER TOBE CONNECTOR 10.36 03958 CHICAGO INTERNATIONAL TRUCK HINGE FOR VEHICLE#2727 47.16 09166 CYLINDERS, INC. REPAIR OF HYDRAULIC CYLINDER 299.00 01236 DAVE & JIM I S AUTO BODY, INC. FRONT END ALIGNMENT-V#2731 45.00 01278 DISPLAY SUPPLY & LIGHTING, iNC. 50 YARDS - HOOK AND LOOP 212 .18 00322 EISEN, BARRY MECHANIC TOOL ALLOWANCE 2009 840.00 06375 EJ EQUIPMENT HYDRAULIC FILTERS-VEHICLE#4508 107.51 08154 GLOBAL EMERGENCY PRODUCTS REPLACEMENT PARTS-VEHICLE#517 212.35 06042 HOFFMANN, MICHAEL MECHANIC TOOL ALLOWANCE 2009 840.00 01750 INTERSTATE BATTERY INV#130051135 VEHICLE#2738 281.8 5 INV#130051097 VEHICLE#4531 72.95 INV#110103528 2743&AMBULANCES 275.85 INV#130047568 GENERATORS 301.90 ------------- 932.55 06691 JUST TIRES 10-SQUAD TIRES P235-55R17 1023.40 117 63 KROTKY, KEVIN MECHANIC TOOL ALLOWANCE 2009 700.00 00389 MARK, JOHN MECHANIC TOOL ALLOWANCE 2009 840.00 02018 MIDWAY TRUCK PARTS OIL FILTERS FOR HUNTINGTON L. 24.82 04416 MSC INDUSTRIAL SUPPLY CO. 8" STROKE STEP CYCLE 65.04 11367 NAPA OF DES PLAINES INV#323704 VEHICLE REPAIR PART 68.99 INV#323829 VEHICLE REPAIR PART 71.64 INV#342355 VEHICLE REPAIR PART 14.13 ------------- 154.76 02107 NAPA-HEIGHTS AUTOMOTIVE SUPPLY INV#186048 VEHICLE REPAIR PART 99.14 INV#186009 VEHICLE REPAIR PART 76.38 INV#181018 VEHICLE REPAIR PART 161.76 ------------- REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY DEC082009 15:44 RELEASE 10 : PAGE 14 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 26 2009 TO DECEMBER 09 2009 - - - -................................................................ --......... --.............................................................. --.......................................... --............................................... -............................................................................ --....................... --......... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .......................................... --......... --............ --..................... --.............................. -_............... --.............................................. ----...... -- -- --............ --................................. --......................................................... ---..................... 337.28 02155 NEXTEL COMMUNICATIONS SERVICE 10/18/09-11/17/09 352.17 SERVICE 10/18/09-11/17/09 25.55 ------------- 377.72 02195 NORTHWEST FORD TRUCK CENTER INV#6099173 309.09 CREDIT#CM6099173 294.84- ------------- 14.25 11290 PARENT PETROLEUM, INC 2 BARRELS - TIRE GREASE 905.40 11643 PARKSIDE AUTO BODY INC REPAIR DAMAGE BUMPER P- 6 250.00 02327 POMP I S TIRE SERVICE, INC. REPLACEMENT SWEEPER TIRES 230.00 REPLACEMENT SWEEPER TIRES 1200.00 ------------- 1430.00 02336 POWER EQUIPMENT LEASING CO INV#15524 JOYSTICK BOOTS#2721 94.12 INV#15232 HYDRAULIC TUBING 136.76 ------------- 230.88 07663 PRAIRIE INTERNATIONAL TRUCK SALES RADIO KIT FOR VEHICLE#4522 240.04 00415 RISTOW, DAVID MECHANIC TOOL ALLOWANCE 2009 840.00 09383 SCHNITTKER, JOHN MECHANIC TOOL ALLOWANCE 2009 840.00 02581 SOLVENT SYSTEMS INT'L. INC. INV#1I7976 RENTAL OF PARTS W. 117.13 INV#1I7805 RENTAL OF PARTS W. 300.00 ------------- 417.13 02684 TERRACE SUPPLY COMPANY INV#588111Z GAS CYCLINDER RENT 27.47 INV#585044 GAS CYCLINDER RENT 19.75 ------------- 47.22 09217 WAYTEK, INC. SHOP SUPPLIES & TRAILER WIRE 147.70 02861 WEST SIDE TRACTOR SALES FUEL &011 FILTER-VEHICLE#2738B 261.40 11836 WICKSTROM FORD LINCOLN MERCURY INV#1027 REPAIR VEHICLE#523 100.00 INV#62654 VEHICLE#524 & P-6 198.44 ------------- 298.44 02913 Z I EBART UNDERCOAT I NG- VAN#5 08 280.00 10272 ZONATHERM PRODUCTS, INC. FILTER KIT-VEHICLE 2764 213.10 TOT AL 19126.34 ~EPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY DEC082009 15: 44 PAGE 15 RELEASE 10 : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 26 2009 TO DECEMBER 09 2009 - -- -...... -... -... -... --... --....................................... --..................... --............ --... --................................. --...................................................................................................... --......... --.................................... --....................................... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ............ --.................................................................. --................................................ --.................. -- --........................... --......... --.................. --....................................... --............ --............ -- --...... --.............................. --............ 670 04939 CERTIFIED POWER INC PRE-WET CABLE-NEW VEHICLE#4528 70.08 11643 PARKS IDE AUTO BODY INC PAINT VEHICLE P-4 807.06 TOTAL 877.14 680 05508 TKB ASSOCIATES, INC. PANASONIC KV-S7065C SCANNER FO 5575.00 TOTAL 5575.00 690 02070 ARLINGTON HEIGHTS FORD REPAIR PARTS FOR P-9 342.48 118 99 BURGER, DONALD D.BURGER-EXPOSURE RX 10/7/09 23.00 11902 CARRAO, DAN I EL REIMB.CAR MIRROR ACCIDENT 8/1 234.17 10051 CCMSI W/C REIMBURSEMENT 12/4/09 33611.91 01093 CHRISTENSEN, RICHARD R. CHRISTENSEN- EXPOSURE RX 10/7 23.00 01102 GAB ROBINS N.A., INC - CITIBANK PAYMENT OF INS CLAIMS 11/25/09 229.70 PAYMENT OF INS CLAIMS 11/30/09 2617.27 ------------- 2846.97 01451 GAB ROBINS NORTH AMERICA CONTRACT AMOUNTS DUE2004-DIXIT 906.40 09205 HEALTH ENDEAVORS A.MINARCIK-BACK STRAIN 11/3/09 75.00 01737 INTERGOVERNMENTAL PER. BEN. COOP CLAIMS ADMIN - MEDICAL DEC 09 37614.97 HMO MEDICAL DEC 09 125040.85 LIFE INSURANCE DEC 09 2829.00 PPO MEDICAL CLAIMS DEC 09 266702.64 ------------- 432187.46 11911 JULIA RACKLEY PERRY MEMORIAL HOSPITAL W.FOEHRING FINGER INJURY 10/28 127.20 06675 NUGENT CONSOLTING GROUP, LLC 2010 RENEWAL NEGOTIATIONS 500.00 11643 PARKSIDE AUTO BODY INC REPAIRS TO VEHICLE#4554 582.03 09569 SLAASTED, SCOTT S.SLAASTED-EXPOSORE RX 10/7/09 20.00 04951 SUBURBAN ACCENTS INC. REPAIRS TO P-6 75.00 TOT AL 471554.62 110 09635 WELLS FARGO BANK, N. A. POLICE PENSION-BANK CHARGES 628.60 POLICE PENSION-BANK CHARGES 10 314.30 ------------- 942.90 REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY DEC082009 15: 44 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 26 2009 TO DECEMBER 09 2009 PAGE 16 DEPT VENDOR NBR ................................. -- --.......................... --.......................................... --........ --.............. --.............. ---.............................. ---............ --............ --.................. --.................... AMOUNT VENDOR NAME INVOICE DESCRIPTION TOTAL : 942.90 ........ --........................... -.......................... --.................... --............................................... ---.................................................... --.............. --.. --.. --......... --........ ---...................... 720 09635 770 08178 790 11913 01719 02689 11910 02886 WELLS FARGO BANK, N. A. FIRE PENSION-BANK CHARGES FIRE PENSION-BANK CHARGES 2010 677.47 338.74 TOTAL 1016.21 1016.21 GUARDIAN EMP. DENTAL PLAN PREM. 12/09 TOTAL 7800.37 7800.37 COMPOSTO, DENNIS REFUND FOR REMOVAL OF ELM TREE NCPERS GROUP LI FE INS. PREMIUM: DECEMBER 2009 PREMIUM: DECEMBER 2009 THIRD DISTRICT CIRCUIT COURT BOND MONEY 11/25/09 BOND MONEY 12/1/09 BOND MONEY 12/3/09 BOND MONEY 12/8/09 WINKLER, TERRENCE JOHN REFUND FOR REMOVAL OF ELM TREE WISCONSIN DEPARTMENT OF REVENUE WISC. INCOME TAX- NOV 2009 TOTAL GRAND TOTAL 26.31 688.00 16.00 704.00 600.00 2230.00 775.00 1725.00 5330.00 26.31 298.06 638 4.6 8 3332406.59 :EPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY DEC082009 15:44 RELEASE I D : PAGE 17 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 26 2009 TO DECEMBER 09 2009 SUMMARY BY FUND 001 GENERAL FUND 670793.62 030 REFOSE DISPOSAL FUND 164.34 050 MOTOR FUEL TAX FUND 54582.37 070 COMMUNITY DEVELPMNT BLOCK GRNT 4324.44 380 IEPA FLOOD CONTROL LOANS B& I 118403.52 510 CAPITAL IMPROVEMENT FUND 10062.89 528 SERIES 2009 CONST FUND 1646294.66 560 STREET IMPROVEMENT CONST FUND 8555.34 610 WATER AND SEWER FUND 303308.80 630 PARKING SYSTEM REVENUE FUND 2639.35 660 VEHICLE MAINTENANCE FUND 19126.34 670 VEHICLE REPLACEMENT FUND 877.14 680 COMPUTER REPLACEMENT FUND 5575.00 690 RISK MANAGEMENT FUND 471554.62 710 POLICE PENSION FUND 942.90 720 FIRE PENSION FUND 1016.21 770 FLEXCOMP ESCROW FUND 7800.37 790 ESCROW DEPOSIT FUND 638 4.6 8 -------------- TOTAL : 3332406.59 REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY DEC082009 15: 44 PAGE REPORT PARAMETERS ORGANIZATION NO. : 001 STARTING CHECK DATE : 11/26/09 ENDING CHECK DATE : 12/09/09 STARTING BANK ENDING BANK SEGMENT NUMBER TO SORT BY : 01 STARTING ACCOUNT SEGMENT NUMBER: ALL ENDING ACCOUNT SEGMENT NUMBER : ALL RELEASE LEVEL '::/Vtl/U~ :MR025 Village of Mount Prospect List of Escrow Checks Presented to the Board of Trustees 12/09/09 To 12/09/09 Paid to Permit # 091827 070290 092401 092408 092242 3 BROTHERS CONCRETE ALTER CONSTRUCTION GROUP, INC APEX LANDSCAPING INC ARS OF ILLINOIS ATTN GLORIA RICHARDS, MARATHON BRADFORD & KENT INC 082974 BRAUNER, DOMINIC 091413 092162 092517 CAPPS PLUMBING & SEWER CENTERGUARD PLUMBING CHARLES MCQUILLAN 091889 CONCRETE CRAWLS PACES CORP 092383 092331 092389 092483 092300 DAHL, ERIK H DAVIS, BETH/MIKE DEPENDABLE CONCRETE DRIVE UP SERVICES FM & J ASPHALT PAVING INC 092154 FOUR SEASONS INC 092229 092437 GABRIEL'S LANDSCAPE & TREE SERVICE 091566 091951 092509 092512 GEHRKE, KENNETH IBBOTSON HEATING CO INTERNATIONAL GYMNASTICS 090862 090967 092508 092340 JDW HOME IMPORVEMENTS PLUS JENSEN, MICHAEL JONES, CHRISTINE JRC CONSTRUCTION 091650 KAP-SUM PROPERTIES INC 00R902 KEEFER, JAMES 092493 LADAS, DEAN 092002 LEDCOR CONSTRUCTION INC 082887 LEJKOWSKI, KENNETH 092518 091109 091923 MCCARTHY, JOHN MENDEZ CONSTRUCTION MICHALSKI, JAMES 080651 MILLER, MICHAEL 092456 080421 MULCRONE, DAVID P NELSON, HEATHER 082730 NELSON, PAMELA S 091948 090685 091345 NIGHOGHOSIAN, BERGE H NnR1'HWF'.S1' SF'WF'R 092498 Check # 13018896 13018897 13018898 Amount 200.00 28,280.00 200.00 75.00 500.00 13018899 13018900 13018901 13018902 13018903 13018904 13018905 13018906 13018907 13018908 13018909 13018910 13018911 13018912 13018913 625.00 500.00 125.00 125.00 200.00 75.00 75.00 125.00 75.00 500.00 500.00 75.00 75.00 150.00 * 13018914 13018915 13018916 13018917 200.00 150.00 125.00 125.00 250.00 * 13018918 13018919 13018920 13018921 575.00 625.00 200.00 150.00 13018922 500.00 13018923 21,314.00 75.00 200.00 16,950.00 125.00 200.00 150.00 375.00 13018924 13018925 13018926 13018927 13018928 13018929 13018930 13018931 13018932 13018933 13018934 13018935 13018936 200.00 450.00 150.00 125.00 150.00 125.00 275.00 * 13018937 l?'i nn t'dge 1 J..u':::f...... village or Mount I-'rospect List of Escrow Checks Presented to the Board of Trustees 12/09/09 To 12/09/09 <.:MR025 Paid to Permit # Check # 091360 13018938 091361 13018939 091362 13018940 092241 13018941 08272 6 13018942 05R786 13018943 092450 13018944 092447 13018945 091842 13018946 090378 13018947 092194 13018948 082861 13018949 091432 13018950 091431 13018951 082837 13018952 OSCEOLA FENCE CORP PDN CONSTRUCTION PERMA SEAL BASEMENT SYSTM PINNACLE AT VLG CTR RAY'S HEATING & AIC ROCK BRICK PAVING ROOTER, ROTO ROSAUER, CHRISTOPHER ROTO ROOTER SERVICES CO SMITH, JAMES THIEL, GERALD THIEL, KATHLEEN & GERALD U S WATERPROOFING *** TOTAL NUMBER OF CHECKS 57 Amount 75.00 75.00 75.00 225.00 * 200.00 75.00 17,320.00 75.00 200.00 400.00 200.00 450.00 275.00 125.00 125.00 75.00 95,439.00