The URL can be used to link to this page

Home My WebLink About3. MONTHLY FINANCIAL REPORT AND BILLS 04/20/2010 Mount Prospect Village of Mount Prospect Mount Prospect, Illinois ~ INTEROFFICE MEMORANDUM TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM: FINANCE DIRECTOR DATE: APRIL 16, 2010 SUBJECT: MONTHLY FINANCIAL REPORT - MARCH 2010 Attached hereto are the cash position and investment statements of the Village for the month ended March 31, 2010. These statements provide a snapshot of the Village's cash position as of the month end date noted and are intended to supplement the budget revenue and expenditure summary and listing of bills you receive. The first statement presents the Village's cash position broken down by governmental and enterprise funds and trust and agency funds. The second statement presents the Village's cash position by fund type. The third statement presents the list of investments again broken down by governmental and enterprise funds and trust and agency funds. It is important to note that although we have included the trust and agency funds in the cash position report, these are not funds accessible for Village operations. They are restricted for pension and escrow funding only. Please read the summary that follows for further detail on the cash position of the Village. Cash and Investment Position Report - All Funds (paQe 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 February 28 were $25.9 million. During March, cash receipts totaled $10,625,491.17. In addition investment income for the month was $6,556.10. Reductions to cash and cash equivalents during March totaled $4,972,883.49. Of this amount, payments to vendors were $3,599,479.26, employee payroll and related expenses were $1 ,369,706.48 and other disbursements were $3,697.75. There was also a net increase in cash due to interfund activity of $1 0,350.00. Cash and cash equivalents at March 31 increased to $31.6 million. Monthly Financial Report - March 2010 April 16, 2010 Page 2 There were no funds held in investments during the month of March. Funds were held in cash money market accounts that currently earn competitive rates of interest. Total cash and investments for Governmental and Enterprise Funds at February 28 were $25,936,491.47. Cash and investments at March 31 totaled $31,606,005.25. This is an increase of $5,669,513.78 for the month. The increase is primarily due to the receipt of the first installment of 2009 property taxes. Trust and Agency Funds - Cash and cash equivalents at February 28 were $7.1 million. During March, cash receipts totaled $1,481,859.05. In addition investment income for the month was $205,368.23 and outflows due to interfund activity totaled $10,350.00. There was also a net decrease in cash due to investment activities of $988,154.59. Reductions to cash and cash equivalents during March totaled $721,302.77. Of this amount, payments to vendors were $267,956.71 employee payroll and related expenses were $429,838.09, and payments related to the flexible spending program totaled $23,245.53. There were also other expenses totaling $262.44. Cash and cash equivalents at March 31 were $7.0 million. Total investments at March 31 were $78,519,365.74, an increase of $2,275,773.06 from February 28. There were investment income of $1,287,618.47 and a net transfer in totaling $988,154.59 that accounted for the change. Total cash and investments for Trust and Agency Funds at February 28 were $83,317,017.50. Cash and investments at March 31 totaled $85,560,210.48. This is an increase of $2,243,192.98 from the prior month. Summary of Cash Activity by Fund Type (paQe 2) This report provides a breakdown of the cash activity for the month broken down by fund type. This breakdown is useful in identifying where the activity (receipts and disbursements) is occurring. There are times during the year when activity in certain funds such as the capital improvement and special revenue funds is higher than normal. This will distort the financial picture of some of the other components of the governmental funds such as the General Fund which tends to be more level and predictable in terms of spending and receipt of revenue. Each month the report will provide further explanation on the activity of the General Fund, the Village's primary operating fund. The report will also provide additional information on fund types that experienced higher than normal activity for the month. Activity for the General Fund is highlighted below. General Fund - Cash and cash equivalents at February 28 totaled $2,774,627.10. During March, cash receipts totaled $6,012,877.46 and investment income was $3,952.89. Significant cash receipts included property taxes, sales taxes and vehicle stickers. The Village continued receiving the first installment of 2009 Property taxes during March. A total of $4,558,760 was received in the General Fund during the month. This represents roughly 49.1 % of the total budget. Sales tax revenues for the month totaled $1,117,626. Of this amount, $1,010,467 was generated from the 1% state portion while $107,159 was generated from the .25% home rule portion. Sales taxes received in March are for December sales. There is a normal three-month lag in getting this distribution from the state. Receipts representing December sales were the Monthly Financial Report - March 2010 April 16, 2010 Page 3 first increase over the prior year on a month to month comparison in 12 months for the state portion and 18 months in the home rule portion. The Village budget would definitely benefit from a positive trend in these revenues. As a side note, April sales taxes (representing January sales) were up over 3% from the prior year for the state portion, but down 3% for the home rule portion. Home rule sales taxes have typically lagged in their recovery coming out of a down period. Vehicle Stickers went on sale February 1 for the 2010-2011 license period. Total receipts for March were $270,753. The total budget for this line item is $1 ,405,000. We are at 41.6% of the total budget. A majority of the sticker sales will occur in April with the April 30 deadline required. Disbursements from the General Fund for March included payments to vendors of $1,276,985.28, payments for employee wages and benefits of $1,098,848.99 and other disbursements of $5,697.75. lnterfund transfers of $407,991.06 for health premiums and vehicle lease and maintenance payments were also made during the month. Cash and cash equivalents at March 31 were $6,001,934.37. There were no investments in the General Fund at March 31. Statement of Investments (paQe 3) This report provides a breakdown of investments by governmental and enterprise funds and trust and agency funds. The report also provides a fund-by fund breakdown of the investments. Government and Enterprise Funds - Investments for the governmental and agency funds are typically made up of Certificates of Deposit. At March 31 there were no CD's placed at any bank. This is due to the extremely low interest rates being offered. Money instead has been placed in interest bearing money market accounts Trust and Agency Funds - The investments for the trust and agency funds are made up of certificates of deposits, fixed income investments and equity mutual funds. CD's (if any) held in the Escrow Deposit Fund will generally have maturities of between 30 and 120 days. Most of the reserves for this fund are invested in the more liquid money market account due to the nature of the deposit. Escrow refunds are processed two times per month. I nvestments for the Police and Firefighter Pension Funds consist of various fixed income securities as well as equity mutual fund accounts. Wells Fargo is the third-party holder of the fixed income securities. The funds are managed by three investment management firms, Capital Gains, Segall Bryant and Mesirow Financial. Segall Bryant holds approximately half of the fixed income investments for the two pension funds while Capital Gains and Mesirow manage the balance of fixed income investments for these two funds. Each manager maintains a small portion of their portfolio in cash to help facilitate liquidity and trading. Investments in equities consist of mutual funds spread across various sectors (small, mid and large- cap stocks) as well as investment philosophies (value, core and growth). The pension funds also have a small portion of their portfolio invested in international stocks. Each year the investment mix is evaluated for optimal diversification to meet the pension funds investment policy goals and objectives. Below is a breakdown of how the pension fund portfolios are invested. Monthly Financial Report - March 2010 April 16, 2010 Page 4 Investment Dcscription CUSIP/ Acct# Interest Rate % Market Value Maturity Date Purchase Financial Date Institution POLICE PENSION FUND (710) Various Various Wells Fargo Various Various Various Wells Fargo Investments Mutual Fund Investments Various Various Various Various 19,251,002.89 19,447,761.56 38,698,764.45 FIRE PENSION FUND (720) Various Various Wells Fargo Various Various Various Wells Fargo Investments Mutual Fund Investments Various Various Various Various 21,175,408.10 18,645,193.19 39,820,601.29 TOTAL TRUST AND AGENCY FUND INVESTMENTS $ 78,519,365.74 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 ongoing commitments. //7 ../?;/ /' /"' C/~. G . l>L../ David O. Erb Finance Director VILLAGE OF MOUNT PROSPECT Preliminary Cash and Investment Position Report - All Funds For the Month Ended March 31,2010 GOVERNMENTAL AND ENTERPRISE FUNDS Cash and Cash Total Cash and Equivalents Investments Investments Balance at February 28" 2010 $ 25,936,491.47 $ $ 25,936,491.47 Cash receipts 10,625,491.17 10,625,491.17 Investment income 6,556.10 6,556.10 Transfers from investments to cash Transfers to investments from cash Interfund activity 10,350.00 10,350.00 Disbursements: Accounts payable (3,599,479.26) (3,599,479.26) Payroll (1,369,706.48) (1,369,706.48) Other (3,697.75) (3,697.75) Balance at March 31, 2010 $ 31,606,005.25 $ $ 31,606,005.25 TRUST AND AGENCY FUNDS * Cash and Cash Total Cash and Equivalents Investments Investments Balance at February 28" 2010 $ 7,073,424.82 $ 76,243,592.68 $ 83,317,017.50 Cash receipts 1,481,859.05 1,481,859.05 Investment income (loss) 205,368.23 1,287,618.47 1,492,986.70 Transfers from investments to cash 1,774,933.24 (1,774,933.24) Transfers to investments from cash (2,763,087.83) 2,763,087.83 Interfund activity (10,350.00) (10,350.00) Disbursements: Accounts payable (267,956.71 ) (267,956.71) Payroll (429,838.09) (429,838.09) Flex spending (23,245.53) (23,245.53) Other (262.44 ) (262.44) Balance at March 31, 2010 $ 7,040,844.74 $ 78,519,365.74 $ 85,560,210.48 * Assets are restricted in purpose and do not represent discretionary assets of the government. 1 I- U W Q. IJ) o 0:: Q. I- Z ::> o :;; LL o W Cl <t ...J ...J :> Q) Cl. >. I- "C C ttTI ~ >.~ 0 Z ~Lt 0 ~ :~ =: N. W t)CT'"""Cf) ~~~ (Z ~ ~ ~ ~ U::::2 W '0 ~ ~ >. W Co 0 E Z E <( :J ...J CfJ <( I- Z W :2 Z 0:: W > o Cl U) o Z ::> LL :>- U Z W Cl <( o Z <( I- U) ::> 0:: I- 1-:>- ~U o::ZIJ) I-wO o::ClZ W<(::> :z:OLL I-Z 0<( o IJ) ZWZ <(UO W::;U; o::OZ -Q.W LL Q. o Z <(W .U) I-(ZIJ) >Q.O Oo::Z Clw::> ...JI-LL <(Z tiW I- ...JU) <(I-CfJ I-UO a::~Z <(0::> Uo::LL Q. ...JW <(::>CfJ -ZO UWZ W>::> Q.WLL CfJo:: ...J <( I- o I- OlC\l<1>...rc;)Oo>(1)'r::::-,..... NNM:NCX)O~lI)LOm crici~etl,...:c:iciujvlri m~~~~-~~~~ ai"':~~M ('t")Mmr--: OOT'"""t---CO -NC1'J(o OT'"""NI"'-t- -t-OO MN' ~N ~C":r CW')T""" - - f7> 00> CO ~COV cw)a>cO N LD 0><0 ritti N~ '<l:~ f7> N<OlO-q-Ct) 0 t-T"""r-NOO 0 ~cri~cr:ir---: 0 omCOMCO LO LC)T-C")O>O ,..... oicOll'i~(1"j """COOt-CO CO('l')N......r-- Lfi-r= ~~ f7> r--r--O v~~ ~~cO O>O>LD VVLD cD.ncD C')N 0><0 lfi o. N~ f7> CfJ o ...JZ <(::> ZLL O::w Wu 1-- Z> -0:: W (/) r--LD~ V<OO r---:C'icO OO>N NOlO ll'i cD --- C')LD V~ ci ~ f7> W CfJ (Z(/) Q.O o::Z W::> I-LL Z W vcor-- <OO>N No>lfi' vO> r--N -q-N <Ov OLD ~~ f7> O>C')<O NOlCO mmr--.: LDLDr-- Olr--N crir--:r= <OC') N ~ c.ri~ f7> W U >CfJ 0::0 Wz U)::> biLL W o <or--v vOlO ~cOr----: N<OCO NV criai o I!) '" r-- f7> ~COC') LD ~ 0 et:i-=ui "'0>0 r--ON a:icri CO~ aJ_ O. f7> o Z ::> LL ...J <( a:: W Z W Cl 0<00> ~VCO ""':""':N' Nr--LD <0 CO 0> ~N-ri r--~ r--o NeD f7> U) I- Z W UJ <l 1j~ > EC 5 -Q) OQ) Q):Il>S wo EcUJ :I: [ij 0 - ~ rnm~g5's ~~'~E~.9 a5.5~~~~~ :J:2::1ii'1ii'tn.2 o~;;) ~ ovll> 0 ONLO (f') LOor-"o;;t ('I") (l')ON co ci~ri ~ T"""-N ,..... ~ ~ ~ OlD Dr-- a......: LDO> C')<O ciri ~~ LD N 0; '" v r--. V LD ;;) ~ aj o v c<i N =- <00 DO cia LD 0 r--o ~N ~:e ~,....: 0>0> 0><0 r--:t.6 o~ :::!:- g> ~ :0 co c >- Q) m Cl. Cl. UJ UJ Q) _ C ~:::o <5 ~ :5 .~ ~ 8 0;;: a. co (/) U) U) (/) c:ccc Q)Q)Q)Q) EEEE Q)Q)Q)Q) ~ ~ f ~ :=J ::S:::l ::s 0> 0> 0; V co cD v <0 a:i C') 0> v aj v '" c<i '" "'. m~ Dr-- cOM "'N co'" aicD NO> :::!:- I!) N cO 0> V "..: o r-- .n co <0 vN cOo; Dr-- r-- v aio> <00> '" LD sri I!) N ui o o cD o <0. ;;; o~ LD LD 0""': 0> CO <0 v 010 co '" ~<D <O~ 0> <D "';'<1' NCO Oil) r--:c.6 ill r-- =-'" ~ ;;; o Il) Il) .,f N v ci ~ Il) ~ ~ '" o ci v 0> .,f V N aj co co "..: r-- v <0. r-- v .-.: r-- r-- N ill "!. ;;)~ 00> cr.iN v~ ~ '" ria> Nr-- -~ ~ ,..; N <0 a:i 0> v N mco O>N crir.ri vco co OJ a:icD 0> r-- ~N_ ~~ r-- (") '<I' '" 0>. e; o cD B c m 1i'i D OJ c: UJ rn Cc :!:<PQ) 2SS ~rnrn cn-8~~ ~ '0 .5 .5: wrnO"C :E.S! ~ 5 I-COro- ffl~~~ 0> LD o>r-- 0'<1' ~I!) vo> cDN NO> vo a.a) v'" 0>1l) 0> r-- 0'<1' ~Il) vo> <<iN NO> vo cia:) v'" v r-- ui <0 C') ai U; 05 r-- v r-- ui <0 C') ai U; 05 r-- rn i: Q) E in Q) > .!; C') .... ..; .... N uS CD .... ...:- ~ ~ ... '" .., 00 .., C') ...; C') ~ ... '" "! .... CD co uS N N ~ co ... '" N ..; o o uS o "!. M ... ~ M ci '" '" ~ N .., o ~ ... '" ~ ~ M o o .., '" ~ ... .., N 00 co co ...:- .... .., uS f7> .... .., ,..: .... .... N CD "'- -E Q) E E Q) > o C) Q) f; '0 UJ W UJ rn m 2:- m c: .Q W t; UJ is C Q) rn Q) a. ~ (5 c o "C "C C m Q) UJ o Cl. :; Cl. .!; "C Q) t5 .C in ~ ~ m UJ a; ~ 2 ... ... .... M '" co <Xi '" "" N ... .... M ~ M CO!. ... o o uS ... IJ) I- Z W :;; I- IJ) W > ~ o Z <t :I: IJ) <( U ...J :<( VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of March 31, 2010 Maturi ty Date Purchase Date Financial Institution GOVERNMENTAL AND ENTERPRISE Fl"NDS Investment Description CUSJP; Acct" Interest Rate % Market Value As of March 3/, 20/0, there were no certificate of deposits held by the Governmental and Enterprise Funds. Maturity Date Purchase Date Financial Institution POLICE PENSION FUND (710) Various Various Wells Fargo Various Various Various FIRE PENSION FUND (720) V arious Various W ells 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 Fl'ND INVESTMENTS CUSIP: Acct" Interest Rate%, Various Various Various Various Various Various Various Various · Assets are restricted in purpose and do not represent discretionary assets of the government. Market Value 19,251,002.89 19,447,761.56 38,698,764.45 21,175,408.[0 18,645,[93.19 39,820,601.29 S 78,519,365.74 Weighted Avg Yield Weighted Ave: Yield 3 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE & EXPENDITURE SUMMARIES January 1 - March 31,2010 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/10 - 03/31/10 04/14/2010 09:33:00 Cur Mo Received Y-T-D Received 3 Months 9 Months 2010 Budget 25.0% 75.0% Unreceived Balance Completed Remaining Unreceived Percent 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 5,920,262 625,991 397,908 -1,672,367 1,372,461 35,358 1,563,940 29,762 1,497,340 o 9,770,655 REVENUE BY FUND GENERAL FUND REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND FOREIGN FIRE TAX BOARD FUND SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2009 B&I, FD/PW 2009B B&I, FD/PW 2009C B&I, FD/PW SERIES 1999 B&I, TIF SERIES 1998A B&I, FLOOD SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD CAPITAL IMPROVEMENT FUND SERIES 2009 CONST FUND DOWNTOWN REDEVLPMNT 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 2,898,483 815,347 106,058 o o 14 3 496 o o o 380,521 174,367 42,388 55,089 o o o -177,650 o o -163,385 978 796,076 -154,989 57,214 1,307,868 1,266 1,630 137,369 6,855 126 560,946 1,421,375 1,502,210 o o 1 7,380,299 2,555,278 918,487 471,280 4,667,422 73,573 2,428,112 88,262 2,299,294 o 20,882,007 7,752,604 1,364,182 264,796 o 22,463 22 10 1,415 o o o 474,365 217,294 52,619 63,591 o o o 63 o o 215 3,424 1,152,419 45,046 57,916 2,859,003 23,574 25,760 412,111 20,904 387 1,728,441 2,121,089 2,218,293 1 o 14,999,000 15,665,000 3,487,000 18,102,647 21,970,880 704,000 5,696,250 467,000 7,023,160 1,023,505 89,138,442 40,691,100 4,038,500 1,836,500 o 565,447 6,000 1,500 20,500 35,500 o 379,000 904,000 414,000 o o o o o 1,140,708 o o 1,421,500 1,124,505 2,567,000 1,717,600 198,792 12,225,500 152,000 159,500 1,654,192 238,200 12,000 6,865,098 5,585,500 5,184,300 o o 7,618,701 13,109,722 2,568,513 17,631,367 17,303,458 630,427 3,268,138 378,738 4,723,866 1,023,505 68,256,435 32,938,496 2,674,318 1,571,704 o 542,984 5,978 1,490 19,085 35,500 o 379,000 429,635 196,706 -52,619 -63,591 o o o 1,140,645 o o 1,421,285 1,121,081 1,414,581 1,672,554 140,876 9,366,497 128,426 133,740 1,242,081 217,296 11,613 5,136,657 3,464,411 2,966,007 -1 o 50.8 83.7 73.7 97.4 78.8 89.5 57.4 81.1 67.3 100.0 76.6 80.9 66.2 85.6 96 .0 99.6 99.3 93.1 100.0 100.0 47.5 47.5 100.0 100.0 99.7 55.1 97.4 70.9 76.6 84.5 83.8 75.1 91. 2 96 .8 74.8 62.0 57.2 04/14/2010 09:33:00 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/10 - 03/31/10 Cur Mo Received Y-T-D Received 3 Months 9 Months 2010 Budget 25.0% Completed 75.0% Remaining Unreceived Balance Unreceived Percent Total All Funds 9,770,655 20,882,007 2 89,138,442 68,256,435 76.6 04/14/2010 09:33:33 FRRBRR03 SUM021 3 Months 9 Months 25.0% 75.0% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/10 - 03/31/10 Cur Mo Received GENERAL FUND 40 PROPERTY TAXES 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 43 INTERGOVERMENT REV. 44 CHARGES FOR SERVICE 45 FINES AND FORFEITS 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 4,558,760 -301,144 396,063 -1,856,259 16,116 34,852 3,952 29,762 16,381 o TOTAL GENERAL FUND 2,898,483 REFUSE DISPOSAL FUND 40 PROPERTY TAXES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 730,064 62,649 80 22,554 TOTAL REFUSE DISPOSAL FUND 815,347 MOTOR FUEL TAX FUND 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 47 REIMBURSEMENTS 105,941 117 o TOTAL MOTOR FUEL TAX FUND 106,058 LAW ENFORCEMENT BLOCK GRANT 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME TOTAL LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 48 OTHER REVENUE TOTAL COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME TOTAL ASSET SEIZURE FUND DEA SHARED FUNDS FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME 1 Y-T-D Received 5,683,274 565,207 913,305 151,271 235,461 72,149 9,820 64,281 57,836 o 7,752,604 910,098 431,304 226 22,554 1,364,182 240,470 345 23,981 264,796 o o o o o o 1,588 o 20,875 o 22,463 10 4 14 o 3 2010 Budget 11,575,000 7,576,000 3,426,000 15,240,100 1,640,000 642,000 130,000 296,000 166,000 o 40,691,100 1,731,000 2,151,000 22,500 134,000 4,038,500 1,675,000 1,500 160,000 1,836,500 o o o 515,447 o 50,000 565,447 10 12 5,000 1,000 22 6,000 o 10 1,000 500 unreceived Balance 5,891,726 7,010,793 2,512,695 15,088,829 1,404,539 569,851 120,180 231,719 108,164 o 32,938,496 820,902 1,719,696 22,274 111,446 2,674,318 1,434,530 1,155 136,019 1,571,704 o o o 513,859 o 29,125 542,984 4,990 988 5,978 1,000 490 Completed Remaining unreceived Percent 50.9 92.5 73.3 99.0 85.6 88.8 92.4 78.3 65.2 80.9 47.4 79.9 99.0 83.2 66.2 85.6 77.0 85.0 85.6 o o o 99.7 58.3 96.0 99.8 98.8 99.6 100.0 98.0 04/14/2010 09:33:33 FRRBRR03 SUM021 3 Months 9 Months Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/10 - 03/31/10 Cur Mo Received TOTAL DEA SHARED FUNDS FUND DUI FINE FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME 496 o TOTAL DUI FINE FUND 496 FOREIGN FIRE TAX BOARD FUND 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL FOREIGN FIRE TAX BOARD FUND SERIES 1987A B&I, PW FACILITY 40 PROPERTY TAXES 46 INVESTMENT INCOME TOTAL SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 380,485 36 o TOTAL SERIES 2003 B&I, VILLAGE HALL 380,521 SERIES 2009 B&I, FD/PW 40 PROPERTY TAXES 46 INVESTMENT INCOME 174,356 11 TOTAL SERIES 2009 B&I, FD/PW 174,367 2009B B&I, FD/PW 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 42,383 5 o TOTAL 2009B B&I, FD/PW 42,388 2009C B&I, FD/PW 40 PROPERTY TAXES 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 34,214 20,872 3 ., Y-T-D Received 3 10 1,414 1 1,415 o o o o o o o o o o 474,314 51 o 474,365 217,283 11 217,294 52,614 5 o 52,619 42,716 20,872 3 2010 Budget 1,500 20,000 500 20,500 o o 35,000 500 o 35,500 o o o o o o 378,000 1,000 o o 379,000 902,000 2,000 o 904,000 413,000 1,000 414,000 o o o o o o o o Unreceived Balance o o 25.0% 75.0% 1,490 18,586 499 19,085 35,000 500 35,500 378,000 1,000 o 379,000 427,686 1,949 o 429,635 195,717 989 196,706 -52,614 -5 o -52,619 -42,716 -20,872 -3 Completed Remaining Unreceived Percent 99.3 92.9 99.8 93.1 100.0 100.0 100.0 o o o 100.0 100.0 100.0 47.4 97.5 47.5 47.4 98.9 47.5 04/14/2010 09:33:33 FRRBRR03 SUM 021 75.0% Completed Remaining Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/10 - 03/31/10 3 Months 9 Months 25.0% Cur Mo Received Y-T-D Received 2010 Budget Unreceived Balance Unreceived Percent TOTAL 2009C B&I, FD/PW 55,089 63,591 o -63,591 SERIES 1999 B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME o o o o o o o o TOTAL SERIES 1999 B&I, TIP o o o o SERIES 1998A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME o o o o o o o o TOTAL SERIES 1998A B&I, FLOOD o o o o SERIES 1998C B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME o o o o o o o o TOTAL SERIES 1998C B&I, TIP o o o o IEPA FLOOD CONTROL LOANS B&I 41 OTHER TAXES 46 INVESTMENT INCOME -177,682 32 o 63 1,140,708 o 1,140,708 100.0 -63 TOTAL IEPA FLOOD CONTROL LOANS B&I -177,650 63 1,140,708 1,140,645 100.0 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 -163,468 0 1,146,000 1,146,000 100.0 0 0 264,000 264,000 100.0 83 215 11,500 11,285 98.1 0 0 0 0 0 0 0 0 0 0 0 0 -163,385 215 1,421,500 1,421,285 100.0 TOTAL CAPITAL IMPROVEMENT FUND SERIES 2009 CONST FUND 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 48 OTHER REVENUE o 978 o o 3,424 o 150,000 1,000 o 150,000 100.0 -2,424 -242.4 o 04/14/2010 09:33:33 3 Months 9 Months 25.0%- 75.0%- FRRBRR03 SUM02l Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/10 - 03/31/10 Cur Mo Received 49 OTHER FINANCING SOURCES TOTAL SERIES 2009 CONST FUND 978 DOWNTOWN REDEVLPMNT CONST 41 OTHER TAXES 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 795,858 218 o o o TOTAL DOWNTOWN REDEVLPMNT CONST 796,076 STREET IMPROVEMENT CONST FUND 41 OTHER TAXES 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 48 OTHER REVENUE -154,989 o o o TOTAL STREET IMPROVEMENT CONST FUND -154,989 FLOOD CONTROL CONST FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME o 135 57,079 o TOTAL FLOOD CONTROL CONST FUND 57,214 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 641,631 1,710 662,548 4 o 1,975 o TOTAL WATER AND SEWER FUND 1,307,868 VILLAGE PARKING SYSTEM FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME - 6,397 o 7,662 1 TOTAL VILLAGE PARKING SYSTEM FUND 1,266 PARKING SYSTEM REVENUE FUND 41 OTHER TAXES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME -7,818 9,448 o Y-T-D Received o 3,424 1,151,990 429 o o o 1,152,419 45,046 o o o 45,046 o 837 57,079 o 57,916 793,035 4,345 2,057,409 72 o 4,142 o 2,859,003 o o 23,569 5 23,574 o 25,758 2 2010 Budget o 973,505 1,124,505 2,556,000 11,000 o o o 2,567,000 1,506,000 210,600 1,000 o 1,717,600 105,292 45,000 47,500 1,000 198,792 1,500,000 16,000 10,596,000 92,500 1,000 20,000 o 12,225,500 45,000 o 106,000 1,000 152,000 55,000 104,000 500 unreceived Balance Completed Remaining Unreceived Percent 1,121,081 973,505 100.0 99.7 1,404,010 10,571 o o o 1,414,581 1,460,954 210,600 1,000 o 1,672,554 105,292 44,163 -9,579 1,000 140,876 706,965 11,655 8,538,591 92,428 1,000 15,858 o 9,366,497 45,000 o 82,431 995 128,426 55,000 78,242 498 54.9 96 .1 55.1 97.0 100.0 100.0 97.4 100.0 98.1 -20.2 100.0 70.9 47.1 72 .8 80.6 99.9 100.0 79.3 76.6 100.0 77 .8 99.5 84.5 100.0 75.2 99.6 04/14/2010 09:33:33 FRRBRR03 SUMon 3 Months 9 Months 25.0% 75.0% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/10 - 03/31/10 Cur Mo Received TOTAL PARKING SYSTEM REVENUE FUND 1,630 VEHICLE MAINTENANCE FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 137,288 81 o TOTAL VEHICLE MAINTENANCE FUND 137,369 VEHICLE REPLACEMENT FUND 44 CHARGES FOR SERVICE 45 FINES AND FORFEITS 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 6,308 o 547 o o TOTAL VEHICLE REPLACEMENT FUND 6,855 COMPUTER REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME o 126 TOTAL COMPUTER REPLACEMENT FUND 126 RISK MANAGEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 470,442 273 o 90,231 TOTAL RISK MANAGEMENT FUND 560,946 POLICE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE 728,777 692,598 TOTAL POLICE PENSION FUND 1,421,375 FIRE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE 828,609 673,601 TOTAL FIRE PENSION FUND 1,502,210 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 5 Y-T-D Received 25,760 411,858 253 o 412,111 18,925 o 1,979 o o 20,904 o 387 387 1,463,138 883 o 264,420 1,728,441 1,138,946 982,143 2,121,089 1,270,969 947,324 2,218,293 o o o o 2010 Budget 159,500 1,647,442 6,750 o 1,654,192 75,700 36,000 76,500 o 50,000 238,200 o 12,000 12,000 5,650,738 31,500 10,000 1,172,860 6,865,098 2,635,500 2,950,000 5,585,500 2,654,000 2,530,300 5,184,300 1 1 o o Unreceived Balance 133,740 1,235,584 6,497 o 1,242,081 56,775 36,000 74,521 o 50,000 217,296 o 11,613 11,613 4,187,600 30,617 10,000 908,440 5,136,657 1,496,554 1,967,857 3,464,411 1,383,031 1,582,976 2,966,007 o o o o Completed Remaining Unreceived Percent 83.8 75.0 96.3 75.1 75.0 100.0 97.4 100.0 91.2 96.8 96.8 74.1 97.2 100.0 77.5 74.8 56.8 66.7 62.0 52.1 62.6 57.2 -1 -1 o o 04/14/2010 09:33:33 FRRBRR03 SUM021 3 Months 9 Months Budget VILLAGE Revenue by Category within 01/01/10 - 03/31/10 OF MOUNT PROSPECT Fund Summary 25.0% 75.0% Cur Mo Received Y-T-D Received o TOTAL GENERAL FIXED ASSETS ACCT GP o MOUNT PROSPECT LIBRARY FUND 49 OTHER FINANCING SOURCES o TOTAL MOUNT PROSPECT LIBRARY FUND o '" 2010 Budget o o 9,715,689 o 9,715,689 unreceived Balance o Completed Remaining Unreceived Percent 9,715,689 100.0 9,715,689 100.0 04/14/2010 09:31:57 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/10 - 03/31/10 Cur Mo Expended Y-T-D Expended 2010 Budget 25.0% 75.0% Unexpended Balance Completed Remaining Unexpended Percent EXPENDITURE BY CLASSIFICATION PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS PENSION BENEFITS CONTRACTUAL SERVICES UTILITIES INSURANCE COMMODITIES & SUPPLIES OTHER EXPENDITURES LAND IMPROVEMENTS BUILDING IMPROVEMENTS OFFICE EQUIPMENT MOBILE EQUIPMENT OTHER EQUIPMENT DISTRIBUTION SYSTEMS INFRASTRUCTURE BOND PRINCIPAL INTEREST EXPENSE BANK AND FISCAL FEES INTERFUND TRANSFERS OTHER FINANCING USES Total All Funds 2,065,529 1,835,157 21,277 529,224 1,184,588 27,196 592,005 157,271 150 o 900,151 99,535 o 48,138 9,855 24,028 o o o o o 7,494,104 EXPENDITURE BY FUND GENERAL FUND REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND FOREIGN FIRE TAX BOARD FUND SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2009 B&I, FD/PW 2009B B&I, FD/PW 2009C B&I, FD/PW SERIES 1999 B&I, TIF SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL CAPITAL IMPROVEMENT FUND SERIES 2009 CONST FUND DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST FUND WATER AND SEWER FUND 4,099,359 313,641 62,857 o 22,930 o o o 6,000 o o o o o o o o o o o o 55,948 939,325 3,252 342 o 647,567 1 6,224,055 3,261,197 66,150 1,587,437 2,935,235 52,163 1,738,161 428,657 13,882 o 1,678,918 113,920 3,322 179,827 10,523 42,524 17,193 2,451 878 o o 18,356,493 9,986,951 791,925 165,508 o 69,978 1,133 o o 8,587 o 150 300 428 o o o o o o 19,644 o 118,185 1,829,138 4,332 3,400 o 1,551,103 27,253,599 11,075,849 461,274 6,404,900 16,954,659 631,674 7,175,232 1,713,926 2,628,150 76,065 1,260,658 488,343 810,000 3,148,636 2,870,346 3,509,015 1,271,204 1,053,076 1,600 o o 88,788,206 41,145,530 4,240,941 1,736,302 o 565,447 2,000 1,000 1,500 15,500 o 382,203 912,658 417,663 o o o o o o 613,356 o 2,130,265 2,183,633 2,736,500 1,575,880 161,425 13,549,749 21,029,544 7,814,652 395,124 4,817,463 14,019,424 579,511 5,437,071 1,285,269 2,614,268 76,065 -418,260 374,423 806,678 2,968,809 2,859,823 3,466,491 1,254,011 1,050,625 722 o o 70,431,713 31,158,579 3,449,016 1,570,794 o 495,469 867 1,000 1,500 6,913 o 382,053 912,358 417,235 o o o o o o 593,712 o 2,012,080 354,495 2,732,168 1,572,480 161,425 11,998,646 77 .2 70.6 85.7 75.2 82.7 91. 7 75.8 75.0 99.5 100.0 -33.2 76.7 99.6 94.3 99.6 98.8 98.6 99.8 45.1 79.3 75.7 81. 3 90.5 87.6 43.4 100.0 100.0 44.6 100.0 100.0 99.9 96 .8 94.5 16.2 99.8 99.8 100.0 88.6 04/14/2010 09:31:57 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/10 - 03/31/10 3 Months 9 Months 25.0% 75.0% Completed Remaining Cur Mo Y-T-D 2010 Unexpended Unexpended Expended Expended Budget Balance Percent VILLAGE PARKING SYSTEM FUND 7,244 22,752 175,098 152,346 87.0 PARKING SYSTEM REVENUE FUND 11,677 32,185 174,597 142,412 81. 6 VEHICLE MAINTENANCE FUND 138,692 414,181 1,814,711 1,400,530 77.2 VEHICLE REPLACEMENT FUND 0 3,322 810,000 806,678 99.6 COMPUTER REPLACEMENT FUND 94,822 99,284 206,050 106,766 51. 8 RISK MANAGEMENT FUND 565,035 1,657,251 6,872,398 5,215,147 75.9 POLICE PENSION FUND 270,670 808,078 3,242,300 2,434,222 75.1 FIRE PENSION FUND 254,743 768,678 3,121,500 2,352,822 75.4 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 7,494,104 18,356,493 88,788,206 70,431,713 79.3 04/14/2010 09:34:02 FRRDBROl SUM031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 03/31/10 NON-DEPARTMENTAL Cur Mo Expended PROGRAM TOTALS 00 ADMINISTRATION Totals EXPENDITURE CLASSIFICATION 72 INTEREST EXPENSE Totals SOURCE OF FUNDS 930 GENERAL LONG-TERM DEBT ACCT GP Totals Y-T-D Expended 2010 Budget o o o o o o o o o o o o 1 25.0% 75.0% Completed Remaining Unexpended Unexpended Balance Percent o o o o o o o o o o o o 04/14/2010 3 Months 25.0% Completed 09:34:02 VILLAGE OF MOUNT PROSPECT 9 Months 75.0% Remaining FRRDBROl SUMon Department Budget Expenditure Summary 01/01/10 - 03/31/10 Cur Mo Y-T-D 2010 Unexpended Unexpended PUBLIC REPRESENTATION Expended Expended Budget Balance Percent PROGRAM TOTALS 02 MAYOR AND BOARD OF TRUSTEES 9,779 19,965 120,261 100,296 83.4 03 ADVISORY BOARDS & COMMISSIONS 365 1,077 6,149 5,072 82.5 Totals 10,144 21,042 126,410 105,368 83.4 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 2,786 8,361 34,311 25,950 75.6 51 EMPLOYEE BENEFITS 508 1,523 6,291 4,768 75.8 52 OTHER EMPLOYEE COSTS 25 105 4,400 4,295 97.6 54 CONTRACTUAL SERVICES 6,761 10,966 76,853 65,887 85.7 55 UTILITIES 38 61 455 394 86.6 57 COMMODITIES & SUPPLIES 26 26 4,100 4,074 99.4 Totals 10,144 21,042 126,410 105,368 83.4 SOURCE OF FUNDS 001 GENERAL FUND 10,144 21,042 126,410 105,368 83.4 Totals 10,144 21,042 126,410 105,368 83.4 2 04/14/2010 09:34:02 FRRDBROl SUM031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 03/31/10 VILLAGE MANAGER'S OFFICE Cur Mo Expended PROGRAM TOTALS 01 VILLAGE MANAGER'S OFFICE 02 LEGAL SERVICES 03 HUMAN RESOURCES 04 INFORMATION TECHNOLOGY 05 PUBLIC INFORMATION 43,381 43,461 18,287 50,689 9,534 Totals 165,352 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 76,696 25,780 976 55,791 841 723 4,545 o Totals 165,352 SOURCE OF FUNDS 001 GENERAL FUND 165,352 Totals 165,352 3 Y-T-D Expended 136,628 53,604 55,630 176,249 34,104 456,215 233,802 77,734 3,726 123,687 1,370 1,557 14,339 o 456,215 456,215 456,215 2010 Budget 575,229 538,250 265,181 892,193 248,098 2,518,951 1,011,435 321,215 28,200 1,115,200 8,601 15,200 19,100 o 2,518,951 2,518,951 2,518,951 25.0% 75.0% Unexpended Balance 438,601 484,646 209,551 715,944 213,994 2,062,736 777,633 243,481 24,474 991,513 7,231 13,643 4,761 o 2,062,736 2,062,736 2,062,736 Completed Remaining Unexpended Percent 76.2 90.0 79.0 80.2 86.3 81.9 76.9 75.8 86.8 88.9 84.1 89.8 24.9 81.9 81. 9 81.9 04/14/2010 3 Months 25.0% Completed 09:34:02 VILLAGE OF MOUNT PROSPECT 9 Months 75.0% Remaining FRRDBROl SUM031 Department Budget Expenditure Summary 01/01/10 - 03/31/10 Cur Mo Y-T-D 2010 Unexpended Unexpended TV SERVICES DIVISION Expended Expended Budget Balance Percent PROGRAM TOTALS 02 CABLE TV OPERATIONS 12,602 37,234 139,639 102,405 73.3 04 INTERGOVERNMENTAL PROGRAMMING 3,364 10,857 62,410 51,553 82.6 Totals 15,966 48,091 202,049 153,958 76.2 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 8,419 26,994 114,194 87,200 76.4 51 EMPLOYEE BENEFITS 3,448 10,738 44,177 33,439 75.7 52 OTHER EMPLOYEE COSTS 0 725 700 -25 -3.6 54 CONTRACTUAL SERVICES 3,339 5,407 27,378 21,971 80.3 55 UTILITIES 254 407 1,600 1,193 74.6 57 COMMODITIES & SUPPLIES 506 1,254 5,500 4,246 77 .2 67 OTHER EQUIPMENT 0 2,566 8,500 5,934 69.8 Totals 15,966 48,091 202,049 153,958 76.2 SOURCE OF FUNDS 001 GENERAL FUND 15,966 48,091 202,049 153,958 76.2 Totals 15,966 48,091 202,049 153,958 76.2 4 04/14/2010 3 Months 25.0% Completed 09:34:02 VILLAGE OF MOUNT PROSPECT 9 Months 75.0% Remaining FRRDBROl SUM031 Department Budget Expenditure Summary 01/01/10 - 03/31/10 Cur Mo Y-T-D 2010 Unexpended Unexpended VILLAGE CLERK'S OFFICE Expended Expended Budget Balance Percent PROGRAM TOTALS 02 VILLAGE CLERK'S OFFICE 17,468 48,980 208,643 159,663 76.5 Totals 17,468 48,980 208,643 159,663 76.5 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 11,900 32,977 126,804 93,827 74.0 51 EMPLOYEE BENEFITS 4,173 12,007 47,646 35,639 74.8 52 OTHER EMPLOYEE COSTS 0 333 1,485 1,152 77.6 54 CONTRACTUAL SERVICES 1,116 3,308 29,679 26,371 88.9 55 UTILITIES 127 203 1,549 1,346 86.9 57 COMMODITIES & SUPPLIES 152 152 1,480 1,328 89.7 Totals 17,468 48,980 208,643 159,663 76.5 SOURCE OF FUNDS 001 GENERAL FUND 17,468 48,980 208,643 159,663 76.5 Totals 17,468 48,980 208,643 159,663 76.5 5 04/14/2010 3 Months 25.0%- Completed 09:34:02 VILLAGE OF MOUNT PROSPECT 9 Months 75.0%- Remaining FRRDBROl SUM on Department Budget Expenditure Summary 01/01/10 - 03/31/10 Cur Mo Y-T-D 2010 Unexpended Unexpended FINANCE DEPARTMENT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 FINANCE ADMINISTRATION 29,073 74,875 359,820 284,945 79.2 02 ACCOUNTING 37,342 111,955 491,793 379,838 77.2 05 INSURANCE PROGRAMS 25,471 76,625 311,872 235,247 75.4 06 CUSTOMER SERVICE 30,912 108,382 420,812 312,430 74.2 07 CASH MANAGEMENT 2,187 6,707 28,416 21,709 76.4 Totals 124,985 378,544 1,612,713 1,234,169 76.5 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 63,399 189,502 843,557 654,055 77.5 51 EMPLOYEE BENEFITS 24,683 73,897 312,122 238,225 76.3 52 OTHER EMPLOYEE COSTS 276 1,586 5,650 4,064 71.9 54 CONTRACTUAL SERVICES 14,772 51,344 181,213 129,869 71.7 55 UTILITIES 632 995 4,900 3,905 79.7 56 INSURANCE 19,393 58,178 232,711 174,533 75.0 57 COMMODITIES & SUPPLIES 1,830 3,042 32,160 29,118 90.5 65 OFFICE EQUIPMENT 0 0 400 400 100.0 Totals 124,985 378,544 1,612,713 1,234,169 76.5 SOURCE OF FUNDS 001 GENERAL FUND 124,985 378,544 1,612,713 1,234,169 76.5 Totals 124,985 378,544 1,612,713 1,234,169 76.5 6 04/14/2010 09:34:02 FRRDBROl SUM031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 03/31/10 COMMUNITY DEVELOPMENT Cur Mo Expended PROGRAM TOTALS 01 COMMUNITY DEVELOPMENT ADMIN 02 PLANNING & ZONING 03 ECONOMIC DEVELOPMENT 05 BUILDING INSPECTIONS 06 HOUSING INSPECTIONS 07 HEALTH INSPECTIONS 19,103 20,148 8,754 64,328 39,862 10,854 Totals 163,049 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 105,714 43,177 2,607 8,044 1,268 2,239 o Totals 163,049 SOURCE OF FUNDS 001 GENERAL FUND 550 DOWNTOWN REDEVLPMNT CONST 163,049 o Totals 163,049 7 Y-T-D Expended 60,292 58,406 21,429 189,660 115,980 31,178 476,945 316,116 129,220 6,087 20,653 2,153 2,716 o 476,945 476,945 o 476,945 2010 Budget 25.0% 75.0% Completed Remaining Unexpended Unexpended Balance Percent 261,596 333,616 95,383 940,912 529,946 128,093 2,289,546 1,402,026 541,145 31,246 269,117 17,671 24, 141 4,200 2,289,546 2,288,046 1,500 2,289,546 201,304 275,210 73,954 751,252 413,966 96,915 1,812,601 1,085,910 411,925 25,159 248,464 15,518 21,425 4,200 1,812,601 1,811,101 1,500 1,812,601 77 .0 82.5 77 .5 79.8 78.1 75.7 79.2 77 .5 76.1 80.5 92.3 87.8 88.7 100.0 79.2 79.2 100.0 79.2 04/14/2010 09:34:02 FRRDBROl SUM031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 03/31/10 COMMUNITY DEVELOPMENT - CDBG Cur Mo Expended PROGRAM TOTALS 04 CDBG ADMINISTRATION 05 CDBG COMMUNITY PROGRAMS 06 ACCESSIBLTY & NEIGHBRHD IMPRV 07 CDBG RESIDENTIAL REHAB 08 CDBG RECOVERY ACT 6,673 7,657 o 3,125 5,475 Totals 22,930 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,811 o 16,563 62 150 o o Totals 22,930 SOURCE OF FUNDS 070 COMMUNITY DEVELPMNT BLOCK GRNT 22,930 Totals 22,930 8 Y-T-D Expended 19,989 27,657 o 16,407 5,925 69,978 13 , 032 5,431 25 37,546 62 13,882 o o 69,978 69,978 69,978 2010 Budget 25.0% 75.0% Completed Remaining Unexpended Unexpended Balance Percent 94 , 947 90,500 100,000 280,000 o 565,447 62,569 23,311 1,965 106,625 977 200,000 50,000 120,000 565,447 565,447 565,447 74,958 62,843 100,000 263,593 -5,925 495,469 49,537 17,880 1,940 69,079 915 186,118 50,000 120,000 495,469 495,469 495,469 78.9 69.4 100.0 94.1 87.6 79.2 76.7 98.7 64.8 93.7 93.1 100.0 100.0 87.6 87.6 87.6 04/14/2010 09:34:02 FRRDBROl SUM031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 03/31/10 HUMAN SERVICES Cur Mo Expended PROGRAM TOTALS 01 HUMAN SERVICES ADMINISTRATION 02 SOCIAL SERVICES 03 NURSING/HEALTH SERVICES 04 SENIOR CITIZEN LEIS ACTIVITIES 05 COMMUNITY CONNECTIONS CENTER 16,917 29,626 15,533 2,745 26,929 Totals 91,750 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 64 BUILDING IMPROVEMENTS 65 OFFICE EQUIPMENT 55,829 19,911 387 12,638 1,779 1,206 o o Totals 91,750 SOURCE OF FUNDS 001 GENERAL FUND 91,750 Totals 91,750 9 Y-T-D Expended 45,682 88,804 44,388 6,976 69,586 255,436 163,076 58,939 449 26,532 2,699 3,741 o o 255,436 255,436 255,436 2010 Budget 25.0% 75.0% Completed Remaining Unexpended Unexpended Balance Percent 184,075 389,713 239,089 35,821 306,071 1,154,769 689,812 241,687 12,581 154,168 14,756 39,065 o 2,700 1,154,769 1,154,769 1,154,769 138,393 300,909 194,701 28,845 236,485 899,333 526,736 182,748 12,132 127,636 12,057 35,324 o 2,700 899,333 899,333 899,333 75.2 77.2 81.4 80.5 77.3 77.9 76.4 75.6 96 .4 82.8 81.7 90.4 100.0 77 .9 77.9 77 .9 04/14/2010 09:34:02 FRRDBROl SUMon 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 03/31/10 POLICE Cur Mo Expended PROGRAM TOTALS 01 POLICE ADMINISTRATION 02 PATROL & TRAFFIC ENFORCEMENT 03 CRIME PREVTN & PUBLIC SERVICES 04 INVESTIGATIVE & JUVENILE PRGM 05 CROSSING GUARDS 06 EQUIPMENT MAINTENANCE 817,592 654,366 20,700 95,759 3,027 37,687 Totals 1,629,131 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 728,014 798,163 5,401 87,150 4,546 5,689 168 o o Totals 1,629,131 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,629,131 o o o o Totals 1,629,131 10 Y-T-D Expended 1,257,600 2,050,679 64,129 291,088 8,592 132,662 3,804,750 2,168,585 1,272,993 27,517 315,032 7,393 11,628 297 1,305 o 3,804,750 3,803,617 o 1,133 o o 3,804,750 2010 Budget 3,958,608 8,946,765 271,910 1,318,756 31,480 515,145 15,042,664 9,490,554 4,146,442 140,300 1,080,543 33,160 127,315 6,150 18,200 o 15,042,664 15,038,164 o 2,000 1,000 1,500 15,042,664 25.0% 75.0% Completed Remaining Unexpended Unexpended Balance Percent 2,701,008 6,896,086 207,781 1,027,668 22,888 382,483 11,237,914 7,321,969 2,873,449 112,783 765,511 25,767 115,687 5,853 16,895 o 11,237,914 11,234,547 o 867 1,000 1,500 11,237,914 68.2 77.1 76.4 77.9 72.7 74.2 74.7 77.2 69.3 80.4 70.8 77.7 90.9 95.2 92.8 74.7 74.7 43.4 100.0 100.0 74.7 04/14/2010 09:34:02 FRRDBROl SUM031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expendi.ture Summary 01/01/10 - 03/31/10 FIRE Cur Mo Expended PROGRAM TOTALS 01 FIRE ADMINISTRATION 02 FIRE DEPARTMENT OPERATIONS 03 FIRE TRAINING ACADEMY 04 FIRE PREVENTION 05 FIRE COMMUNICATIONS 06 EQUIPMENT MAINTENANCE 07 EMERGENCY PREPAREDNESS PRGM 08 PAID-ON-CALL PROGRAM 10 FOREIGN FIRE INSURANCE 706,182 542,332 o 47,540 7,679 16,475 20 2,315 6,000 Totals 1,328,543 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 527,017 746,432 9,321 o 34,116 4,334 6,775 o o 548 Totals 1,328,543 SOURCE OF FUNDS 001 GENERAL FUND 095 FOREIGN FIRE TAX BOARD FUND 1,322,543 6,000 Totals 1,328,543 11 Y-T-D Expended 1,034,321 1,757,040 o 132,517 11,292 49,425 20 5,687 8,587 2,998,889 1,716,099 1,133,446 12,202 o 119,542 6,858 9,765 o o 977 2,998,889 2,990,302 8,587 2,998,889 2010 Budget 25.0% 75.0% Completed Remaining Unexpended Unexpended Balance Percent 2,933,025 7,578,769 14,131 603,725 55,611 197,950 62,436 33,180 15,500 11,494,327 7,402,167 3,333,594 140,880 500 413,665 38,311 73,970 3,800 9,000 78,440 11,494,327 11,478,827 15,500 11,494,327 1,898,704 5,821,729 14, 131 471,208 44,319 148,525 62,416 27,493 6,913 8,495,438 5,686,068 2,200,148 128,678 500 294,123 31,453 64,205 3,800 9,000 77,463 8,495,438 8,488,525 6,913 8,495,438 64.7 76.8 100.0 78.1 79.7 75.0 100.0 82.9 44.6 73.9 76.8 66.0 91.3 100.0 71.1 82.1 86.8 100.0 100.0 98.8 73.9 73.9 44.6 73.9 04/14/2010 09:34:02 FRRDBROl SUM03l 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 03/31/10 PUBLIC WORKS - ADMINISTRATION Cur Mo Expended PROGRAM TOTALS 01 PUBLIC WORKS ADMINISTRATION 86,291 Totals 86,291 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 24,920 13,459 911 44,609 1,985 407 o o Totals 86,291 SOURCE OF FUNDS 001 GENERAL FUND 86,291 Totals 86,291 12 Y-T-D Expended 240,040 240,040 59,509 37,677 3,001 132,626 3,281 3,946 o o 240,040 240,040 240,040 2010 Budget 982,823 982,823 234,319 149,319 25,802 538,489 19,470 15,169 o 255 982,823 982,823 982,823 25.0% 75.0% Completed Remaining Unexpended Unexpended Balance Percent 742,783 742,783 174,810 111,642 22,801 405,863 16,189 11,223 o 255 742,783 742,783 742,783 75.6 75.6 74.6 74.8 88.4 75.4 83.1 74.0 100.0 75.6 75.6 75.6 04/14/2010 09:34:02 FRRDBROl SUM 031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 03/31/10 PUBLIC WORKS - STREETS/BLDGS CUr Mo Expended PROGRAM TOTALS 01 STREET DIVISION ADMINISTRATION 02 MAINTENANCE - PUBLIC BUILDINGS 04 STREET MAINTENANCE 05 SNOW REMOVAL 06 LEAF REMOVAL 07 STORM SEWER & BASIN MAINT 08 MAINTENANCE OF STATE HIGHWAYS 09 TRAFFIC SIGN MAINTENANCE 10 VILLAGE PARKING LOT MAINT 11 PARKING LOT MAINTENANCE 12 FLOOD CONTROL 13 STORM EVENT 22,677 64,400 13,371 150,079 o 6,962 7,893 8,940 7,244 11,677 o o Totals 293,243 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 127,625 30,208 62,642 1,703 158 70,002 o 905 o o Totals 293,243 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 620 VILLAGE PARKING SYSTEM FUND 630 PARKING SYSTEM REVENUE FUND 217,805 56,517 7,244 11,677 Totals 293,243 13 Y-T-D Expended 51,904 198,623 40,990 406,847 o 19,099 25,979 21,820 22,752 32,185 o o 820,199 350,605 96,998 171,857 2,602 474 196,758 o 905 o o 820,199 609,228 156,034 22,752 32,185 820,199 2010 Budget 25.0% Completed 75.0% Remaining Unexpended Unexpended Balance Percent 161,866 1,010,405 418,912 669,384 o 112,657 70,394 122,044 175,098 149,597 o o 2,890,357 1,246,055 382,210 738,939 79,230 1,894 382,174 o 19,855 o 40,000 2,890,357 2,266,230 299,432 175,098 149,597 2,890,357 109,962 811,782 377,922 262,537 o 93,558 44,415 100,224 152,346 117,412 o o 2,070,158 895,450 285,212 567,082 76,628 1,420 185,416 o 18,950 o 40,000 2,070,158 1,657,002 143,398 152,346 117,412 2,070,158 67.9 80.3 90.2 39.2 83.0 63.1 82.1 87.0 78.5 71.6 71.9 74.6 76.7 96.7 75.0 48.5 95.4 100.0 71.6 73.1 47.9 87.0 78.5 71.6 04/14/2010 09:34:02 FRRDBROl SUM031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 03/31/10 PUBLIC WORKS - FORESTRY/GRNDS Cur Mo Expended PROGRAM TOTALS 01 FORESTRY DIVISION ADMIN 02 MAINTENANCE OF GROUNDS 03 FORESTRY PROGRAM 04 PUBLIC GROUNDS BEAUTIFICATION 19,706 30,006 113,596 2,454 Totals 165,762 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT 54,719 20,742 108 89,532 661 o Totals 165,762 SOURCE OF FUNDS 001 GENERAL FUND 690 RISK MANAGEMENT FUND 165,762 o Totals 165,762 14 Y-T-D Expended 56,016 73,734 240,994 7,191 377,935 153,737 57,014 893 164,691 1,600 o 377 , 935 377,935 o 377 , 935 2010 Budget 237,763 473,321 998,138 72, 010 1,781,232 761,579 246,330 3,662 718,112 51,549 o 1,781,232 1,762,432 18,800 1,781,232 25.0% Completed 75.0% Remaining Unexpended Unexpended Balance Percent 181,747 399,587 757,144 64,819 1,403,297 607,842 189,316 2,769 553,421 49,949 o 1,403,297 1,384,497 18,800 1,403,297 76.4 84.4 75.9 90.0 78.8 79.8 76.9 75.6 77 .1 96.9 78.8 78.6 100.0 78.8 04/14/2010 09:34:02 FRRDBROl SUMon 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 03/31/10 PUBLIC WORKS - ENGINEERING Cur Mo Expended PROGRAM TOTALS Ol ENGINEERING SERVICES 05 TRAFFIC CNTRL & STREET LGHTNG 63,590 20,959 Totals 84,549 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 5l EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 69 INFRASTRUCTURE 54,250 l7,078 o 8,4B o 4,808 o o o Totals 84,549 SOURCE OF FUNDS 00 l GENERAL FUND 050 MOTOR FUEL TAX FUND 78,209 6,340 84,549 Totals l5 Y-T-D Expended l85,57l 44,949 230,520 l58,089 50,l25 l,6l5 ll,446 3, B4 6,lll o o o 230,520 22l,046 9,474 230,520 2010 Budget 25.0% 75.0% Completed Remaining Unexpended Unexpended Balance Percent 83l,493 756,494 1,587,987 70l,400 2ll,200 3,552 Bl,796 225,000 32,855 546 1,638 280,000 1,587,987 l,07l,ll7 516,870 1,587,987 645,922 7l1,545 1,357,467 543,3ll 16l,075 l,937 l20,350 221,866 26,744 546 l,638 280,000 1,357,467 850,07l 507,396 1,357,467 77.7 94.l 85.5 77 .5 76.3 54.5 9l. 3 98.6 8l.4 lOO.O lOO.O lOO.O 85.5 79.4 98.2 85.5 04/14/2010 09:34:02 FRRDBROl SUM031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 03/31/10 PUBLIC WORKS - WATER/SEWER Cur Mo Expended PROGRAM TOTALS 01 WATER & SEWER DIVISION ADMIN 02 MAINTENANCE OF BUILDINGS 03 MAINTENANCE OF GROUNDS 04 WATER SUPPLY MAINT & REPAIR 05 WATER DISTRBT MAINT & REPAIR 06 WATER VALVE!HYDRNT MAINT & REP 07 WATER METER MAINT & REPL 08 EQUIPMENT MAINTENANCE 09 SANITARY SEWER MAINT & REPAIR 10 WATER & SEWER SYSTEM IMPROV 12 LAKE MICHIGAN WATER SUPPLY 106,043 15,367 7,579 60,471 50,403 22,044 22,428 42,889 35,721 o 284,622 Totals 647,567 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 136,182 55,147 765 408,331 9,511 5,524 22,252 o o o 9,855 Totals 647,567 SOURCE OF FUNDS 610 WATER AND SEWER FUND 647,567 Totals 647,567 16 Y-T-D Expended 315,958 43,430 17,301 146,345 108,007 62,464 51,089 128,667 74,721 5,712 597,409 1,551,103 389,756 156,083 7,386 907,234 20,723 16,574 42,824 o o o 10,523 1,551,103 1,551,103 1,551,103 2010 Budget 25.0% 75.0% Completed Remaining Unexpended Unexpended Balance Percent 1,415,111 226,997 136,428 1,585,848 868,982 413,162 963,266 514,668 1,079,772 2,315,515 4,030,000 13,549,749 1,900,352 671,563 57,336 6,202,726 185,406 66,295 291,120 o 7,652 1,296,953 2,870,346 13,549,749 13,549,749 13,549,749 1,099,153 183,567 119,127 1,439,503 760,975 350,698 912,177 386,001 1,005,051 2,309,803 3,432,591 11,998,646 1,510,596 515,480 49,950 5,295,492 164,683 49,721 248,296 o 7,652 1,296,953 2,859,823 11,998,646 11,998,646 11,998,646 77.7 80.9 87.3 90.8 87.6 84.9 94.7 75.0 93.1 99.8 85.2 88.6 79.5 76.8 87.1 85.4 88.8 75.0 85.3 100.0 100.0 99.6 88.6 88.6 88.6 04/14/2010 09:34:02 FRRDBROl SUM031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 03/31/10 PUBLIC WORKS - REFUSE DISPOSAL Cur Mo Expended PROGRAM TOTALS 01 REFUSE DISPOSAL PROGRAM 02 REFUSE LEAF REMOVAL PROGRAM 302,694 10,947 Tota1.s 31.3,641 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 14,319 5,770 o 291,606 51 1,895 o Totals 313,641 SOURCE OF FUNDS 030 REFUSE DISPOSAL FUND 313,641 Totals 313,641 17 Y-T-D Expended 762,006 29,919 791,925 41,373 16,037 o 728,750 81 5,684 o 791,925 791,925 791,925 2010 Budget 25.0% 75.0% Completed Remaining Unexpended Unexpended Balance Percent 4,019,373 221,568 4,240,941 251,942 77,148 1,200 3,853,608 572 22,734 33,737 4,240,941 4,240,941 4,240,941 3,257,367 191,649 3,449,016 210,569 61,111 1,200 3,124,858 491 17,050 33,737 3,449,016 3,449,016 3,449,016 81.0 86.5 81.3 83.6 79.2 100.0 81.1 85.8 75.0 100.0 81.3 81.3 81.3 04/14/2010 09:34:02 FRRDBROl SUM03l 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 03/31/10 PUBLIC WORKS - VEHICLE MAINT Cur Mo Expended PROGRAM TOTALS 01 VEHICLE MAINTENANCE ADMIN 02 VEHICLE MAINTENANCE PROGRAM 14,237 124,455 Totals 138,692 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 68,778 24,446 500 5,699 127 39,142 o o o Totals 138,692 SOURCE OF FUNDS 660 VEHICLE MAINTENANCE FUND 138,692 Totals 138,692 18 Y-T-D Expended 50,842 363,339 414,181 200,705 70,734 500 10,329 203 131,710 o o o 414,181 414,181 414,181 2010 Budget 180,836 1,633,875 1,814,711 879,792 301,789 2,315 95,738 993 530,039 o 545 3,500 1,814,711 1,814,711 1,814,711 25.0% 75.0% Completed Remaining Unexpended Unexpended Balance Percent 129,994 1,270,536 1,400,530 679,087 231,055 1,815 85,409 790 398,329 o 545 3,500 1,400,530 1,400,530 1,400,530 71.9 77.8 77.2 77.2 76.6 78.4 89.2 79.6 75.2 100.0 100.0 77 .2 77.2 77 .2 04/14/2010 09:34:02 FRRDBROl SUM031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 03/31/10 COMMUNITY SERVICE PROGRAMS Cur Mo Expended PROGRAM TOTALS 02 COMMUNITY GROUPS & MISC 03 4TH OF JULY & CIVIC EVENTS,ETC 04 HOLIDAY DECORATIONS 05 BLOOD DONOR PROGRAM 5,463 o 1,393 237 Totals 7,093 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 618 221 5,463 791 o Totals 7,093 SOURCE OF FUNDS 001 GENERAL FUND 7,093 7,093 Totals 19 Y-T-D Expended 33,996 1,416 12,049 638 48,099 1,737 601 33,996 11,765 o 48,099 48,099 48,099 2010 Budget 137,105 166,992 80,885 2,774 387,756 100,731 18,660 208,490 51,875 8,000 387,756 387,756 387,756 25.0% 75.0% Completed Remaining Unexpended Unexpended Balance Percent 103,109 165,576 68,836 2,136 339,657 98,994 18,059 174,494 40,110 8,000 339,657 339,657 339,657 75.2 99.2 85.1 77 .0 87.6 98.3 96 .8 83.7 77.3 100.0 87.6 87.6 87.6 04/14/2010 09:34:02 FRRDBROl SUM031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 03/31/10 CAPITAL IMPROVEMENT PROJECTS Cur Mo Expended PROGRAM TOTALS 01 VILLAGE IMPROVEMENTS & EQUIP 02 COMMUNITY IMPROVEMENT PROJECTS 03 DOWNTOWN REDEVELOPMENT CONST 04 FLOOD CONTROL PROJECTS 06 STREET IMPROVEMENT PROJECTS 09 MOTOR EQUIPMENT REPLACEMENT 10 COMPUTER REPLACEMENT 11 STATION 14 12 EMERGENCY OPERATION CENTER 13 PUBLIC WORKS EXPANSION 31,920 2,890 3,252 o 21,480 o 94,822 821,815 26,446 91,064 Totals 1,093,689 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 28,003 o o 899,246 94,822 o 47,590 24,028 o o o Totals 1,093,689 SOURCE OF FUNDS 050 MOTOR FUEL TAX FUND 510 CAPITAL IMPROVEMENT FUND 528 SERIES 2009 CONST FUND 550 DOWNTOWN REDEVLPMNT CONST 560 STREET IMPROVEMENT CONST FUND 590 FLOOD CONTROL CONST FUND 630 PARKING SYSTEM REVENUE FUND 670 VEHICLE REPLACEMENT FUND 680 COMPUTER REPLACEMENT FUND o 55,948 939,325 3,252 342 o o o 94,822 Totals 1,093,689 20 Y-T-D Expended 76,807 7,917 4,332 o 36,861 3,322 99,284 1,481,980 151,047 196,111 2,057,661 59,539 o o 1,678,013 99,284 3,322 174,979 42,524 o o o 2,057,661 o 118,185 1,829,138 4,332 3,400 o o 3,322 99,284 2,057,661 2010 Budget 25.0% 75.0% Completed Remaining Unexpended Unexpended Balance Percent 1,829,500 155,765 2,735,000 161,425 2,665,880 810,000 206,050 1,380,963 456,741 345,929 10,747,253 1,005,820 2,420,150 26,065 1,237,003 438,050 810,000 1,741,150 3,069,015 o o o 10,747,253 920,000 2,130,265 2,183,633 2,735,000 1,575,880 161,425 25,000 810,000 206,050 10,747,253 1,752,693 147,848 2,730,668 161,425 2,629,019 806,678 106,766 -101,017 305,694 149,818 8,689,592 946,281 2,420,150 26,065 -441,010 338,766 806,678 1,566,171 3,026,491 o o o 8,689,592 920,000 2,012,080 354,495 2,730,668 1,572,480 161,425 25,000 806,678 106,766 8,689,592 95.8 94.9 99.8 100.0 98.6 99.6 51. 8 -7.3 66.9 43.3 80.9 94.1 100.0 100.0 -35.7 77 .3 99.6 90.0 98.6 80.9 100.0 94.5 16.2 99.8 99.8 100.0 100.0 99.6 51. 8 80.9 04/14/2010 09:34:02 FRRDBROl SUM031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 03/31/10 DEBT SERVICE Cur Mo Expended PROGRAM TOTALS 02 DEBT SERVICE - PROPERTY TAXES 03 DEBT SERVICE - TAX INCREMENT 04 DEBT SERVICE - H/R SALES TAX 1 06 SPECIAL SERVICE AREA B & I Totals EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 59 OTHER EXPENDITURES 71 BOND PRINCIPAL 72 INTEREST EXPENSE 73 BANK AND FISCAL FEES 80 INTERFUND TRANSFERS 81 OTHER FINANCING USES Totals SOURCE OF FUNDS 140 SERIES 1987A B&I, PW FACILITY 180 SERIES 2001 B&I, VILLAGE HALL 190 SERIES 2003 B&I, VILLAGE HALL 195 SERIES 2009 B&I, FD/PW 196 2009B B&I, FD/PW 197 2009C B&I, FD/PW 290 SERIES 1999 B&I, TIF 340 SERIES 1996A B&I, FLOOD 350 SERIES 1998A B&I, FLOOD 360 SERIES 1998C B&I, TIF 380 IEPA FLOOD CONTROL LOANS B&I 390 SERIES 2000 B&I, FLOOD CONTROL 830 SSA #6 GEORGE/ALBERT B&I Totals 21 Y-T-D Expended o o o o 878 o 19,644 o o 20,522 o o o o o o o o o 17,193 2,451 878 o o o 20,522 o o o o o o o o o o o o o o 150 300 428 o o o o o o 19,644 o o o 20,522 2010 Budget 25.0% Completed 75.0% Remaining Unexpended Unexpended Balance Percent 1,712,524 o 613,356 o 2,325,880 1,271,204 1,053,076 1,600 o o 2,325,880 o 382,203 912,658 417,663 o o o o o o 613,356 o o 2,325,880 1,711,646 o 593,712 o 2,305,358 o o o o 1,254,011 1,050,625 722 o o 2,305,358 o 382,053 912,358 417,235 o o o o o o 593,712 o o 2,305,358 99.9 96 .8 99.1 98.6 99.8 45.1 99.1 100.0 100.0 99.9 96 .8 99.1. 04/14/2010 09:34:02 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Departmen t Budget Expenditure Summary 01/01/10 - 03/31/10 3 Months 9 Months 25.0% 75.0% Completed Remaining Totals Cur Mo Y-T-D 2010 Unexpended Unexpended Expended Expended Budget Balance Percent 3,811 11,431 46,600 35,169 75.5 270,670 808,078 3,242,300 2,434,222 75.1 254,743 768,678 3,121,500 2,352,822 75.4 529,224 1,588,187 6,410,400 4,822,213 75.2 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 529,224 1,587,437 6,404,400 4,816,963 75.2 0 750 4,500 3,750 83.3 0 0 1,500 1,500 100.0 529,224 1,588,187 6,410,400 4,822,213 75.2 SOURCE OF FUNDS 001 GENERAL FUND 710 POLICE PENSION FUND 720 FIRE PENSION FUND Totals 3,811 11,431 46,600 35,169 75.5 270,670 808,078 3,242,300 2,434,222 75.1 254,743 768,678 3,121,500 2,352,822 75.4 529,224 1,588,187 6,410,400 4,822,213 75.2 22 04/14/2010 09:34:02 FRRDBROl SUM031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 03/31/10 3 Months 9 Months 25.0% 75.0% Completed Remaining Totals Cur Mo Y-T-D 2010 Unexpended Unexpended Expended Expended Budget Balance Percent 132,577 360,418 927,700 567,282 61.1 432,458 1,296,833 5,925,898 4,629,065 78.1 565,035 1,657,251 6,853,598 5,196,347 75.8 RISK MANAGEMENT PROGRAM TOTALS 01 CASUALTY & PROPERTY INSURANCE 02 MEDICAL INSURANCE EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 56 INSURANCE 67 OTHER EQUIPMENT Totals 0 0 2,000 2,000 100.0 565,035 1,657,251 6,851,598 5,194,347 75.8 0 0 0 0 565,035 1,657,251 6,853,598 5,196,347 75.8 SOURCE OF FUNDS 690 RISK MANAGEMENT FUND 565,035 1,657,251 6,853,598 5,196,347 75.8 Totals 565,035 1,657,251 6,853,598 5,196,347 75.8 23 04/14/2010 09:34:02 FRRDBROl SUM031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 03/31/10 NON-DEPARTMENTAL Cur Mo Expended PROGRAM TOTALS 01 CONTINGENCIES Totals EXPENDITURE CLASSIFICATION 80 INTERFUND TRANSFERS Totals SOURCE OF FUNDS 001 GENERAL FUND Totals 24 Y-T-D Expended 2010 Budget o o o o o o o o o o o o 25.0% 75.0% Completed Remaining Unexpended Unexpended Balance Percent o o o o o o o o o o o o 04/14/2010 09:34:02 FRRDBROl SUM031 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/10 - 03/31/10 CAPITAL FIXED ASSETS Cur Mo Expended PROGRAM TOTALS 00 CAPITAL FIXED ASSETS Totals EXPENDITURE CLASSIFICATION 59 OTHER EXPENDITURES Totals SOURCE OF FUNDS 910 GENERAL FIXED ASSETS ACCT GP Totals 25 Y-T-D Expended 2010 Budget o o o o o o o o o o o o 25.0% 75.0% Completed Remaining Unexpended Unexpended Balance Percent o o o o o o o o o o o o 04/14/2010 09:34:02 FRRDBROl SUM03l 3 Months 9 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Swmnary 01/01/10 - 03/31/10 MOUNT PROSPECT LIBRARY Cur Mo Expended Unexpended Unexpended Balance Percent PROGRAM TOTALS 02 LIBRARY SERVICES Totals EXPENDITURE CLASSIFICATION 90 COMPONENT UNIT EXPENDITURES Totals SOURCE OF FUNDS 950 MOUNT PROSPECT LIBRARY FUND Totals 26 Y-T-D Expended o o o o o o 2010 Budget o 9,715,689 o 9,715,689 o 9,715,689 o 9,715,689 o 9,715,689 o 9,715,689 25.0% 75.0% Completed Remaining 9,715,689 100.0 9,715,689 100.0 9,715,689 100.0 9,715,689 100.0 9,715,689 100.0 9,715,689 100.0 REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY APR132010 15:22 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE Bom OF TRUSTEES FROM APRIL 01 2010 TO APRIL 14 2010 ----------------------------------------------------------------------------------------------------------------------------------- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - -- 001 10135 A-AWESOME AMUSEMENTS CO. EQUIP!1ENT RENTAL 5/15/10 414.00 12121 ADA!1S, ROBERT J. REFUND OVER PYMT VEHICLE L. 12.00 04203 ADDANTE, ANTHONY REIMB EXP 3/9/10- 3/ll/l0 24.00 01071 ADDISON BUILDING MATERIAL CO. 30LB KRAFT PAPER 36"X1200 I ROL 43.19 LINE MARKING FLUOR. ORG. OIL. 3.83 ROBE HOOK. 37.98 MISC. PARTS USED AT POLICE/FIR 18.39 ------------- 103.39 01367 AIMFES MEMBERSHIP 20l0-FRANK KRUPA 10.00 REGISTRATION -F .KRUPA 5/4/10 30.00 ------------- 40.00 01246 AIRGAS NORTH CENTRAL # 1 0 5516635 OXYGEN SUPPLIES 187.56 #105516636 OXYGEN SUPPLIES 211.7 5 ------------- 399.31 01699 AMERICAN PUBLIC WORKS ASSOC. APWA WEBINAR ON LED TECHNOLOGY 175.00 10095 AMSAN, LLC TOPLINE 25 UHS FLOOR COATING. 165.46 01833 ANDERSON LOCK COMPANY RESECURE LATCH ON SIMPLEX LOCK 215.00 09544 ANDRES MEDICAL BILLING,LTD MARCH2010 AMBULANCE BILLING 5371.64 02265 ASSOCIATION OF POLICE SOCIAL WORKERS MEMBERSHIP 2010-KIM SHEAGREN 40.00 10383 BACK ON TRACK FITNESS INC. FITNESS EQUIP .MAINT .PART&LABOR 759.07 06287 8EDCO MECHANICAL 2010 BI -MONTHLY HVAC PREVENTAT 1421.65 2010 MAINTENANCE CONTRACT FOR 866.65 ------------- 2288.30 12120 BILL, LAUREN REI!1B EXP 4/6/10 15.68 09609 BONO, CSR, LTD., KATHLEEN COURT REPORTER FR,~NKI E' SHEAR 179.00 02938 BOW!1AN DISTRIBUTION CENTER CABLE TIE BL,~CK AND NATURAL. 94.03 06549 BROWN, DONNA CLOTHING ALLOWANCE. 93.10 01008 BUSSE'S FLOWERS & GIFTS #486037 MINA'S 50.00 #485984 WILKS 60.00 ------------- 110.00 01014 CADE INDUSTRIES CUSTODm SUPPLIES. 2409.00 REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY APR132010 15:22 RELEASE 10 : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 01 2010 TO APRIL 14 2010 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT -- - - - - - - - - - - - - - - - - - - - - - - - - - - - -... - - - - - - - -- - - - -... - -......... - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -... - - - - - - - - - - - - - -- ---- - - - -- 12117 cmONE, CELIA M. REFUND DUP,PYMT #P3896474 30,00 05375 CENTURY CLEANERS UNIFORM CLEANING3/l211O-412i10 36.97 UNIFORM CLEANING 3/23-4/1/10 69.72 UNIFORM CLEANING3!2J/l0-4/511O 41.32 UNIFORM CLEANING 3130-4/9/10 67.42 ------------- 215.43 12056 CHEM-WISE ECOLOGICAL PEST MGMT INC PEST CONTROL SERVICE PER MONTH 230.00 01077 CHICAGO COMMUNICATIONS LLC RADIO MAINT.-MAY,JUNE,JULY2010 1903.95 00309 COONEY, WILLIAM J. REIMB MILEAGES 1/5/10-3/30/10 187.60 11403 COSTAR REALTY INFORMATION, INC ED SITE SOFTWARE 435.00 09797 CROWN COPIER SERVICE, LTD EQUIP MAINT-STATION# 12 17 6.6 5 EQUIP MAINT-STATION#14 188.25 ------------- 364.90 05503 CRYSTAL MAINTENANCE SERVICES CORP. CUSTODIAL SERVICE AT VILLAGE 110.49 CCC SHARE OF MONTHLY CLEANING 590.00 CUSTODIAL SERVICE AT VILLAGE 7529.44 ------------- 8229.93 01218 DAHLBERG, JOHN REIMB EXP 3/19,3122,3/23,3131 125.22 12095 DE LA CRUZ, ED & PAPA WIN REFUND VEHICLE LICENSE FEE 36.00 12097 DE LA CRUZ, PAPA W. REFUND VEHICLE LICENSE FEE 36.00 09653 ETERNO, DAVID G. SERVICE 3/24/10-3/25110 375.00 01366 EXPERIAN BACKGROUND CHECKS MARCH 2010 77.00 10393 EXPERTPAY PAYROLL FOR - 040810 3266.41 01377 FEDERAL EXPRESS CORP PICK UP#841305628766 67.36 SHIPPING FOR PLANNING DIV. 13.48 -----------...- 80.84 01398 FIRE INVESTIGATORS STRIKE FORCE REGISTRATION-C.PIKORA 5/19110 30.00 00102 FIRE PENSION FUND PAYROLL FOR - 040810 21575.35 11674 FIRE TRAINING RESOURCES Registration! Wojcik Wolczyz F 185.00 11936 FITNESS EQUIPMENT SERVICES, INC REPms TO FITNESS EQUIPMENT, 1222.00 09363 GARCIA, RAFAELA REIMB ICC CERT. EXM4 2/13/10 180.00 12096 GCLDEN OPENINGS, INC GRm OPENING SCISSORS 185.00 REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY APR132010 15:22 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 01 2010 TO APRIL 14 2010 DEPT VENDOR NBR VENDOR N,~ME INVOICE DESCRIPTION AMOUNT ----------------------------------------------------------------------------------------------------------------------------------- 01522 GRAINGER MEZZANINE LIGHT REPLACEt~ENT. 849.51 01522 GRmGER INC. INSPECTION SUPPLIES 79.84 12104 HALVORSEN, ROY REIMB 1 SQUJi,RE OF PUBLIC WALK 55.00 00345 HANNEHMJ, LESTER A. REIMB CLOTHING ALLOWANCE 3/10 51.71 09113 HEm mHALr C0/1PANY,LLC. 5.99 TONS UPM ASPHALT PATCH 646.92 08948 HEART PRINTING INC. 17,000 TSR FORMS 1837.00 05012 HEFFERAN ROOFING INSTALLATION OF 12 SOFFIT VENT 600.00 05729 HEINRICH, LARRY REIMB CLOTHING ALLOWANCE 4/5 150.00 00349 HOSKINSON, THOt~AS PEIMB EXP 3/16-3/17/10 48.00 09425 HSBC BUSINESS SOLUTIONS BOARD MEETING 3/8110 36.52 CRIME FREE HOUSING EXPO 3/6110 !73.77 MEETING SUPPLIES 3/5110 19.91 OFFICE COFFEE 3/10/10 110.99 OFFICE SUPPLIES 3/10/10 26.28 REFRESHMENTS 2/25/10 96.90 REFRESHMENTS 3/5/10 96.90 REFRESHMENTS 3/5/10 17 .90 REFRESHMENTS 3/6110 92.46 MENTOR SUPPLIES 3/17110 2.16 ------------- 673.79 01642 IACP LEIM REGISTRATION-S. BURRELL 5/24- 27 300.00 00107 ICMA RETIREMENT TRUST - 457 PAYROLL FOR - 040810 19859.26 08428 ILEETA REGISTRATlON-J.SCHMITZ 4119-24 345.00 MEMBERSHIP 2010-J.SCHMITZ 45.00 ------------- 390.00 06690 ILLINOIS AMERICAN WATER CO. PRIVATE FIRE SERVICE RATE 39.02 00108 ILLINOIS DEPARTMENT OF REVENUE MANUAL PR FOR - 040710 23.44 PAYROLL FOR - 040810 23726.33 MANU.H PR FOR - 040910 20.83 ------------- 23770.60 11754 ILLINOIS PROSECUTOR SERVICES, LLC 2010 IL CRIMINAL OFFENSE GUIDE 100.00 07433 m~GETEC L P LEASE PAYMENT FOR TOSHIBA COPI 246.00 09562 H1RF MANUAL PR FOR - 040710 79.04 i1ANOAL PR FOR - 040710 36.82 PJi.YROLL FOR - 040810 411.63 PAYROLL FOR - 040810 40468.81 L~,,{ROLL FOR - 040810 18620.58 REPORT: ~,PBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY APR132010 15:22 RELEASE 1 D : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TROSTEES FROM APRIL 01 2010 TO APRIL 14 2010 DEPT VENDOR NER VENDOR N.3.t~JE INVOICE DESCRIPTION 09832 INTERNmON,U ONION OF OPERATING ENGINEERS PAYROLL FOR - 0400310 PAYROLL FOR - 040310 09563 IRS MANUAL PR FOR - 040710 PAYROLL FOR - 040310 MANUAL PR FOR - 040910 01733 JOURNAL & TOPICS NEWSPAPERS LEGAL PZ-05/10 lYR SUBSCRIPTION3/13/lO- 3/1/11 lYR SUBSCRIPTION3/13/lO- 3/1/11 om8 KERSTEIN I JUNE REIMB EXP MARCH 2010 01827 KLEIN, THORPE AND JENKINS/LTD, GENERAL LEGAL SERV-FEB 2010 01861 LANDS I END BUSINESS OUTFITTERS FLEECE PULLOVER "GO KIT" 09766 LANER MUCHIN LABOR LEGAL SERV-MARCH 2010 08631 LECHNER AND SONS PW UNIFORM RENTAL AND CLEANING 05678 LEIB, JASON REIMBURSEMENT FOR PROCUREMENT 10450 LEXISNEXIS RISK DATA MANAGEMENT INC BACKGROUND CHECKS MARCH 2010 05744 LICARI I NICK REIMB CLOTHING ALLOWANCE 3/10 01918 LUNDSTROM'S NURSERY I INC. LANDSCAPE MAINTENANCE AT VARIO 01941 MALCOLM I JOHN REIMB EXP 3/30/10 12116 MELLEN I MAC'{ REFUND OVER PYMT #P3896683 05021 MENARDS MAILBOX REPAIR PARTS. MISCELLANEOUS SUPPLIES MAILBOX REPAIR PARTS. 4 SHOWER H.&9 GLASSES&2 L.SOAP 4PC GLASS & TILE DRILL BIT. HANDRAIL & HANDR,m BRACKETS. BATTERIES. DI9'?! MERIT EMPLOY. .mESS. SERV. INC FIRE LIEUTENANT PROMO. TEST Ie::;, t~ETRO FEDERH CREDIT UNION PAYROLL FOR - 040810 '~: ::! 11 - METROPOLITAN ALLIANCE - POLICE PAYROLL FOR - '!40BlQ PAGE AMOUNT 59616.38 964.49 277 . 20 1241.69 320.53 181143.54 173.61 181637.68 115.92 23.00 28.00 171.92 63.53 36533.51 25.50 407.50 243.58 159.83 69.60 150.00 3071.42 32.99 50.00 25.92 33.31 29.97 199.78 12.98 18.78 26.97 352.71 320 7.0 5 249 3.4 8 103l.O0 REPORT: APBOARDRPT GENERmD: 15 APR 09 11:42 RUN: TUESDAY APR132010 15:22 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 01 2010 TO APRIL 14 2010 DEPT VENDOR NBR VENDOR Np,ME INVOICE DESCRIPTION AMOUNT 04322 MIDDLETOlJ, JOMl REIMB MILEAGE 4/1/10 44.00 RE 1MB TOLLS 4 II II 0 1.60 REIMB EXP CABLE LABELS 7.69 REIMB MILEAGE l/22ilO 26.00 ------------- 79.29 12098 MIDWEST FOLDING PRODUCTS, INC 2 STEP 16" PLASTIC STAIRS 393.00 02046 MOBILE PRINT INC. MEMO PADS - STRAHL 30.07 POSTERS-AMERICAN IDOL 100.88 MEMO PADS-NANCY MORGAN 34.92 MEMO PADS: D. ZBORIL 51.41 ------------- 217.2 8 02057 HORTON ARBORETUM 400 ARBOR DAY BOOKLETS 2010 40.00 02066 HOUNT PROSPECT CHAMBER OF COMMERCE 2010 SP/FALL GOLF OUTINGS 147 5.0 0 02072 HOUNT PROSPECT PUBLIC LIBRARY INTERNET 1/16110-4/15/10 138 2.0 4 INTERNET 1/16/10-4/15/10 175 7.2 8 ------------- 3139.32 09521 MS GOVERN ANNUAL MAINT 6/1/10-5/31/11 39025.00 06216 NATIONAL NOTARY ASSOC. lYR MEMBERSHIP 2010-2011 52.00 00123 NATIONWIDE MUTUAL INSURANCE COMPANY PAYROLL FOR - 040810 16431.13 02148 NEOPOST INC. MONEY ENTERED POSTAGE MACHINE 3000.00 02155 NEXTEL COMMUNICATIONS SERVICE 2/18/10-3/17/10 671.09 SERVICE 2/18/10-3/17110 115 .18 SERVICE 2/18/10-3/17110 107.32 SERVICE 2/18/10-3/17110 486.78 SERVICE 2/18110-3/17/10 28.00 SERVICE 2/18/10-3/17/10 186.74 SERVICE 2/18/10-3/17/10 28.00 SERVICE 2/18/10-3/17/10 1207.61 SERVICE 2/18/10-3/17110 221. 95 SERVICE 2/18/10-3117110 301.20 SERVICE 2/18/10-3/17 110 26.43 SERVICE 2/18110-3/17 110 292.99 INV#512698347-039 EQUIPHENT 14.98 ------------- 3688.27 05256 NICOR ACCT#138178696I6 3/1- 313G11O 353.55 02165 NIPSTA Registration/ Dawson, Henry Ma 75.00 021 iO NORTH Em 140LTl REGIONAL TRNG #130926 G.SILL,M.BECHIOLD,l\.LE 450.00 #130986 A.LIETZOW 300.00 #130916 G.SILL&M.BECHTOLD 300.00 REPORT: APBOARDRPT DEPT VENDOR NBR 02189 02193 02204 02228 10163 10162 02264 02301 02304 12114 GENERmD: 15 ,I,PR 09 11: 42 RUN: TUESDAY APR132010 15:22 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 0] 2010 TO APRIL 14 2010 "lENDe? NflME NORTHWEST CENTRAL DISPATCH SYS NORTHWEST ELECTRICAL SUPPLY NOVAK & Pf,RKER INC. OAKTON PAVILLION HEALTHCARE ON TlHE INC. OVERHEAD GARAGE DOOR, INC. PAPERDIRECT I INC. PETTY CASH - FINANCE DEPT. PETTY mH - POLICE DEPT. POCHRORT ~II, THOMAS A. INVOICE DESCRIPTION PAGE AHOUNT RESERVED SLOTS 3/16- 3/18/lO 800 ANNUAL TRAINING MEMBERSHIP 7650.00 M,W 2010 MEMBER ASSESSMENT MAY 2010 MEMBER ASSESSMENT ELECTRICIAL SUPPLIES. ELECTRICAL SUPPLIES. ELECTRICAL SUPPLIES. Countertop microwave for Fire 672 HOME DELIVERED MEALS- 3/10 UNIFORM SUPPLIES C.A.T. SEMI ANNUAL MAINTENANCE AND ADDITIONAL MATERIALS NOT TO EX CHECK GATE OPERATOR. EMERGENCY REPAIR TO MAIN GATE SUPPLIES MISCELLANEOUS MARCH 2010 MISCELLANEOUS MARCH 20]0 MISCELLANEOUS MARCH 2010 MISCELLANEOUS MARCH 2010 MISCELLANEOUS MARCH 2010 MISCELLANEOUS MARCH 2010 MI SCELLANEOUS MARCH 2010 MISCELLANEOUS MARCH 2010 MISCELLANEOUS MARCH 2010 MI SCELLANEOUS MARCH 2010 MISCELLANEOUS MARCH 2010 MISCELLANEOUS MARCH 2010 TRAINING 2/18/10-4/1/10 TRAVEL&METTINGS 3/4/10 ,~DMIN .OTHER SUPPLIES 2/18&3/15 ORG.MEMBERSHIP 2/18/10 mROL OTHER SUPPLIES 3/4/lD INVESTIG.OTHER SUPPLIES 4/1/lO REFUND OVER PYMT #P389668] 9500.00 36807.60 9201.90 46009.50 564.56 17 .29 74.50 656.35 123.00 2688.00 97J .5 0 2105.00 438.72 190.00 490.00 3223.72 21.94 21.99 70.27 17 .80 16.00 21.10 4.81 32.30 ]5.00 65.97 28.39 93.90 113.23 500.76 248.00 30.00 ]2.07 25. DC 4.49 10.99 330.55 10.0C REPORT: momRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY APR132010 15:22 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FRotJ APRIL 01 2010 TO APRIL 14 2010 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - -- DEPT VENDOR NBR VENDOR NMjE INVOICE DESCRIPTION AMOUNT - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - -- 00124 POLICE PENSION FUND PAYROLL FOR - 040810 26911.97 04921 POPE, ELIZABETH A. PAYROLL FOR - 040810 923.08 02333 PORTER LEE CORPORATION BAR CODE LABELS&PRINTER RIBBON 166.50 10435 PROCESSWORKS, INC. FLEX MARCH 2010 638.00 PARK RIGHT SERV MARCH 2010 50.00 ------------- 688.00 02379 QUILL CORPORATION OFFICE SUPPLIES. 259.18 OFFICE SUPPLIES. 54.00 OFFICE SUPPLIES. 87.96 OFFICE SUPPLIES. 7.49 ------------- 408.63 11066 RANO, DENISE REIMB EXP YOUNG AUTHOR I S SHOW 11.05 02399 REBEL I S TROPHIES, INC. RETIREMENT PLAGQUE 35.00 11481 SCHOOL SAFETY ADVOCACY COUNCIL, INC REGISTER-J.BEACH 7/26-7/30/10 400.00 12119 SCHULTZ, WALTER REIMB EXP SHOE 3/22/10 97.00 02525 SECRETARY OF STATE S26&S32 LICENSE PLATE STICKER 198.00 TITLE & MP PLATES-9 NEW POLICE 945.00 ------------- 1143.00 046B2 SERVICEMASTER KIM SHEAGREN I S OFFICE 150.00 02544 SHRED FIRST INC. SHREDDER BAGS-ADMIN. 154.30 05975 SIGNS BY TOMORROW BANNERS-AMERICAN IDOL (3) 683.00 10316 SOS TECHNOLOGIES 1 Box of Adult Difib Peds 2 FR 278.95 02583 SOUND INCORPORATED SERVICE CALL - INSPECT EXTERIO 278.00 02592 SPECIAL T UNLIMITED YOUTH COMMISSION T-SHIRTS 439.00 02155 SPRINT SERVICE 2/24/10-3/23/10 39.99 02672 SYSTEMS FORMS, INC. 35,000 #9 RETURN EVELOPES 849.45 09668 T .P. 1. PLUMBING INSPECTIONS 135.00 BUILDING INSPECTIONS 147.00 MEETING 105.00 ------------- 387.00 09784 TEMPLE DISm.Y, LTD. tjmITEN~.NCE ON HOLIDAY LIGHTS, 670.DO l2lIl THE CITY OF FmFIELD REGISTER P.LYONS 7/l2-7!l4/10 225 REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY APR132010 15:22 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BlLLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 01 2:)10 Te .!,PRIL 14 2010 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION P,MOUNT - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- 02691 THOMPSON ELEVATOR INSPECTIONS 2 SEMI -ANNUAL RE- INSPECTIONS 74.00 2 ELEVATOR PL~N REVIEWS 150.00 ------------- 224.00 08472 TREE CARE INDUSTRY ASSOCIATION 2YR SUBSCRIPTlON6/1/10-5/3l/l2 35.95 00447 TRUTY, CHRIS J. REIMB EXP 3/4/10 102.12 11277 TYGRIS VENDOR FINANCE, INC SERVICE 3/24/10-4123/10 467.29 SERVICE 3/24/10-4/23/10 321.91 SERVICE 3/24/10-4/23/10 456.90 SERVICE 3/24/10-4123/10 830.73 SERVICE 3/24/10-4123/10 16.80 SERVICE 3/24/10-4123/10 16.80 SERVICE 3/24/10-4123/10 16.80 SERVICE 3/24/10-4/23/10 16.80 SERVICE 3/25/10-4/24/10 372.46 ------------- 2516.49 05686 ULINE INC. #31845446 SHIPPING ITEM RETURN 16.21 #31861671 STORAGE BINS 158.82 STORAGE BINS 81.03 ------------- 256.06 07526 UNITED PARCEL SERVICE SHIPPING CHARGES 3/30/10 19.90 02756 UNITED STATES POSTAL SERVICE EMS CARDS MARCH 2010 17.07 BULK MAIL PERMIT MARCH 2010 185.00 PUBLIC INFORMATION MARCH 2010 3536.51 SISTER CITIES MARCH 2010 64.33 ------------- 3802.91 00127 UNITED WAY PAYROLL FOR - 040810 374.91 04025 UNIVERSITY OF ILLINOIS - GAR REGISTER DANE PHENEGAR 250.00 10831 UNIVERSITY OF LOUISVILLE REGISTRATlON-J. BELMONTE3 /15-16 675.00 12001 US BANK 4/20/10 USAGE & LATE CHARGE 197.91 4/20/10 USAGE & LATE CHARGE 267.92 4/20/10 USAGE & LATE CHARGE 277 . 92 4/20/10 USAGE & LATE CHARGE 197.92 4/20/10 USAGE & Lm CHARGE 158.92 4/20/10 USAGE & LATE CHARGE 140.42 ------------- 1241.0 1 11834 VAN METER & ASSOCIATES, INC REGISTER-D.OKON & A.ANZALONE 240.00 09527 VILLAGE CYCLES PORT 2 POLICE BIKE HEL!1ETS 90.00 00128 VILLAGE OF MOUNT PROSPECT pm,OLL FOR - O4OBl'J 26601.27 PAYROLL FOR - 04GB 10 12370.80 RUN: TUESDAY APR132010 15:22 RELEASE ID : REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 DEFT VENDOR NBR 09580 02835 02876 06001 05746 12115 030 12113 050 05709 070 01670 10292 10452 11277 095 02046 510 01049 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 01 2010 TO APRIL 14 2010 VENDOR NAME INVOICE DESCRIPTION VILLAGE OF ROMEOVILLE FIRE ACADEMY Registration/ Miller, Lloyd WAREHOUSE DIRECT #681793-0 TONER 3/30/10 #681870-0 SUPPLIES 3/30/10 #682370-0 SUPPLIES 3!3I/10 WILKS I IRVANA REIMB EXP 1/30110 BLACKBERRY SERV 2116-3115110 WINKLER'S TREE SERVICE 2010 PARKWAY TREE TRIMMING PRO WI SCT F PAYROLL FOR - 040810 YOON, JOHN REFUND OVER PYMT #P3896309 TOTAL 610893.28 2.00 CORCOR.~N I DMI REFUND FINAL UTILITY BILL TOTAL 12.50 12.50 MEADE ELECTRIC CO. INC. 2010 EMERGENCY & PREVENTATIVE TOTAL 1976.00 1976.00 AMERICAN PLANNING ASSOC. -ILLINOIS CHAPTER 2010 PLANNING INTERN JOB AD CNM DEVELOPMENT REHAB 316 S. PINE STREET SAEWERT, JANET REIMB EXP 3/30/10 TiGRIS VENDOR FINANCE, INC SERVICE 3/24/10-4/23/10 TOTAL 17873.91 16.80 MOBILE PRINT INC. FOREIGN FIRE TAX B. -ENVELOPES TOTAL 62.08 62.08 CDW GOVERNMENT I INC P~,TCH CmES FOR ESX SERVER MS SQL 2008 STD SVR LICS FOR E MS SQL 2008 CHS - CDW # 15416 PAGE AMOUNT 38972.07 540.00 154.25 105.22 436.66 696.13 99.74 45.00 144.74 1087.30 542.48 25.00 17746.16 85.95 14.00 1118.14 5933.40 :065.54 REPORT: APBOARDRPT DEPT VENDOP. NBP. 12084 11970 528 09417 01049 00331 09913 11479 12063 07800 02204 11859 06406 00447 610 CI07l !J17'!3 1m] GENERATED: 15 APR 09 11: 42 RUN: TUESDAY APR132010 15:22 RELEASE I D : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 01 2010 TO APRIL 14 2010 VENDOR NFJ1E INVOICE DESCRIPTION ELECTRICAL RESOURCE MMLAGEMENT, INC 13 VALMONT HUMUNUM NEW WORLD SYSTEMS CORPOR,!,TION ERP SOFTWARE APPLIUTlONS - VB TOTAL 108530.54 84630.00 AMERICAN MATTRESS Mattresses, BOl Springs, Bed 550 01827 KLEIN, THORPE AND JENKINS, LTD. 01918 LUNDSTROM'S NURSERY, INC. 12106 MMPV PROPERTIES 12108 NUDO, ANTHONY 12118 REAL DEALS HOME DECOR CDW GOVERNMENT, INC Patch Cables for the EOC SHIPPING Patch Cables for Fire Station FIGOLAH, MICHAEL REIMB EXP 3/15110 KIMBALL INTERNATIONAL Work stations for the telephon KRUEGER INTERNAmNH, INC KI Furniture for Fire Station LZB FURNITURE GALLERIES OF ARLINGTON HTS 6 - Recliner Chairs for New MAGNUM FITNESS SYSTEMS Power Rack,3 Tier Flat Rack, 7 ' NOVAK & PARKER INC. Kitchen & Laundry Room Appllan OEC BUSINESS INTERIORS, INC Kimball Furniture for Fire Sta SRBL ARCHITECHTS, LTD. Architectural Services for Fir TRUTY, CHRIS J. REIMB EXP 3/23110 TOTAL TIt LEGAL SERV-FEB 2010 LANDSCAPE MAINTENANCE AT VARIO INV#9192 -REIMB 50~ 2/26/10 #031810 REIMB 50~ 3/18110 REIMB 50~ OCT 12009 TOTAL ADDISON BUILDING t1ATERm CO. WOOD STAKES FOR WATER M,m REP SAWZm BLmS FOR WATER MAIN .~MEHIC.~N WATE? WORKS ?,SS'::e. Wl-JER ':IPERATCRS ::ERTIFICp.TION ANm ~J1THCN: REFUND t'lrL:,L TilisITY BILL PAGE 10 ~.MOUNT 16835.00 2506.00 280.00 0.18 59.47 339.65 572.00 4957.40 3939.00 3753.99 7775.80 920 7.0 0 30663.66 14976.23 66.86 78757.59 4895.70 7344.69 1923.50 3711.5 0 617 . 72 18493.11 41.76 49.12 90.88 2690.00 25.7(. REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY APR132010 15:22 RELEASE 10 : PAGE 11 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 01 2010 TO APRIL 14 2010 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 12100 AN,m, PHILIP REFUND FINAL UTILITY BILL 48.34 02451 BADGER METER INC BADGER TRACE/CONNECT ANNUAL 989.00 10540 BATTERIES PLUS REPLACEMENT BATTERIES. 183.56 07147 CARDINAL FENCE & SUPPLY INC. REPAIR/REPLACE FENCE AND GATE 2582.00 05375 CENTURY CLEANERS UNIFORM CLEANING3/12/l0-4/2/l0 36.98 UNIFORM CLEANING 3/23-4/1/10 69.73 UNIFORM CLEANING3/23/l0-4/5/l0 41.33 UNIFORM CLEANING 3/30-4/9110 67.43 ------------- 215.47 01147 COMMONWEALTH EDISON ELECTRICAL SERVICE DELIVERY AT 26.34 ELECTRICAL SERVICE DELIVERY AT 46.49 ELECTRICAL SERVICE DELIVERY AT 268.11 ELECTRICAL SERVICE DELIVERY AT 26.19 ELECTRICAL SERVICE DELIVERY AT 692.98 ------------- 1060.11 12113 CORCORAN, DAN REFUND FINAL UTILITY BILL 122.06 12102 ESTATE OF BRUNO PINKOS REFUND FINAL UTILITY BILL 77 .42 01377 FEDERAL EXPRESS CORP SHIPPING CHARGES. 34.79 12103 GLUTH, JOSEPH REFUND FINAL UTILITY BILL 45.08 01546 HACH COMPANY 1 CASE OF DPD FREE CHLORINE 178.95 01559 HANSEN INFORMATION TECHNOLOGIES DATA INTEGRATION - CONSULTANT 1312.50 01544 HBK WATER METER SERVICE WATER METER TESTING SERVICES. 357.00 WATER METER 375 7.0 5 BUILDING INSPECTION SERVICES. 125 2.3 5 WATER METER 1169.40 BUILDING INSPECTION SERVICES. 389.80 ------------- 6925.60 12105 HOME VESTORS REFUND FINAL UTILITY BILL 238.28 07433 IMAGETEC L P LEASE PAYMENT FOR TOSHIB~, COPI 246.00 04851 JOLIET JUNIOR COLLEGE METER MAINTENANCE CLASS FOR TO 99.00 08631 LECHNER AND SONS PW UNIFORM RENTAL AND CLEANING 243.54 01965 [.lARTAt1 ':ONSTRUCTION WATERMAIN REPAIR-CONCRETE REST 11697.00 12107 MICHALS, KATHERINE REFUND FIN~,1 UTILITY BILL 30.00 oms NEXIEL COM!1UNICATIDNS SERVICE 2/lBilO- 3il7 m.J3 02660 SUBURBAN PRINTING 10516 SYTECH, INC. 118 64 TANK INDUSTRY CONSULTANTS, INC 02756 UNITED STATES POSTAL SERVICE 07860 UPS STORE #707 12001 US BANK REPORT: APBOARDRPT DEPT VENDOR NBR 05256 02274 02538 02655 620 05503 02301 630 01B33 01147 05503 02826 GENERATED: 15 ,!,pR 09 11:42 RUN: TUESDAY APR132010 15: 22 RELEASE 10 : VILLAGE Of MOUNT PROSPECT LIST Of BILLS PRESENTED TO THE BOARD Of TRUSTEES fROM APRIL 01 2010 TO APRIL 14 2010 "iEN[,;:F N_~,t1E INVOICE DESCRIPTION SERVICE 2/1B/1O- 3/17 /10 NICOR GP,S SERVICE DELIVERY AT 117 N. GAS SERVICE DELIVERY AT SS GaL G,~S SERVICE DELIVERY AT 112 E. PATTEN INDUSTRIES, INC. 100 HOUR PM AND fLUID CHANGES SEWER EQUIPMENT CO. Of AMERICA EMERGENCY REPAIR Of ARIES SUBURBAN LABORATORIES, INC. ANNUAL IEPA-REQUIRED WATER SAM ANNUAL TEPA-REQUIRED WATER SAM 250 RED WATER SHUT Off TAGS. SOFTWARE SUPPORT fOR SCADA XL PREPARE BID DOCS FOR ELEVATED PERMIT 699-WATER MARCH 2010 SHIPPING CHARGES. 4/20/10 USAGE & LATE CHARGE TOTAL CRYSTAL MAINTENANCE SERVICES CORP. CUSTODIAL SERVICE AT VILLAGE CUSTODIAL SERVICE AT VILLAGE PETTY CASH - FINANCE DEPT. MISCELLANEOUS MARCH 2010 TOTAL 1506.14 3.00 ANDERSON LOCK COMPP.NY KEYS fOR RAILROAD DEPOT. CO~jMONWEALTH EDISON ELECTRICAL SERVICE DELIVERY AT ELECTRICAL SERVICE DELIVERY AT CRYSEL M,'.:NTEN,ANCE SERVICES CORP. CUSTODIAL SERVICE AT ViLLAGE CUSTODIAL SERVICE AT VILLAGE ;} ~"":':'; ::-. .... :i-'- ~."-._~ 1'.~. PARSIS FO NEW HAND RAIL AT ~:ES' ,~ j::tE, HE. PAGE 12 AMOijNT 32.09 450.42 144.06 129.27 231.13 504.46 1046.7B 2929.B1 32B.32 123.1B 451.50 74.50 500.00 1095.00 2205.74 120.62 140.41 38654.5B 21.74 1481.40 1503.14 9.50 158. B2 122.18 281.00 2.77 1B9.16 191. 9 3 lit.. 39 R~PORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY APR132010 15:22 RELEASE ID : PAGE 13 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BO~.RD OF TRUSTEES FROM APRIL 01 2010 TO ~.PRIL 14 2010 DEPT VENDOR NBR VENDOP NAME IN'JOICE DESCRIPTION .~MOUNT - - - - - - - - - - - - - - - -- -- - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - -- 05256 NICOR GF.S SEPVICE DELIVERY AT 11 E. 306.00 02193 NORTHWEST ELECTRICAL SUPPLY 1001'1 B~.LLAST KIT. 102.53 02301 PETTY CASH - FINANCE DEPT. MISCELLANEOUS MARCH 2010 41.00 MISCELLANEOUS MARCH 2010 20.00 ------------- 61.00 02754 UNION PACIFIC RAILROAD L~.ND LEASE MARCH 2010 3149.40 TOTAL 4219.7 5 660 01071 ADDISON BUILDING MATERIAL CO. 1/4" & 5/16" BPASS HOSEBARB UN 17 .18 EXTENSION COPD FOR FIRE FOAM 59.92 ------------- 77.10 01246 AIRGAS NORTH CENTRAL STAINLESS WELDING WIRE. 2lU5 02796 ALPHA PRIME COMMUNICATIONS HANG UP CLIP. 11.00 02070 ARLINGTON HEIGHTS FORD FRONT PADS FOR P-4. 92.87 FUEL FILTERS & CAP FOR FIRE TR 98.40 OEM - OIL COOLER HOSE; 4 FRONT 377 .41 ------------- 568.68 02108 ARLINGTON POWER EQUIPMENT HT-95. 1.15 SMALL ENG. 6.51 ABI46-REWIND/PAWI. 28.50 1'11'1-83. 4.40 SMALL EQUI PMENT GASKETS. 10.58 C.~RBURETOR FOR FIRE FOAM TRAIL 122.01 AIR CLEARNER FOR SMALL EQ. 23.04 WB148. 63.72 ------------- 259.91 12109 AUTO TRUCK, INC UNDERBODY REPAIR PARTS. 435.00 01045 CATCHING FLUIDPOWER HYDRAULIC FITTINGS. 351.67 09610 CERTIFIED FLEET SERVICES, INC. SW. BRACKETS FOR FIRE TRUCK # 171.6 2 03958 CHICAGO INTERN,mONAL TRUCK TURBO PARTS FOR VEHICLE #4510. 32.42 08154 GLOBAL EMERGENCY PRODUCTS PULL HANDLE BRACKETS FOR FIRE 70.70 01750 INTERSTATE B~,TTERY 1m F,;RM FIRE TRAILER 3 BATTE 113.8 5 BATTERY FOR P-14. 87.95 B,~TmY FeR T-42. 8 E.. 9~1 ------------- "Q q "1 ~ L".;. . REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY APR132010 15:22 RELEASE ID : PAGE 14 VILLAGE OF HOUNT PROSPECT LIST OF BILLS PRESENTED TO THE Bom OF TRUSTEES FROH APRIL 01 2010 TO APRIL 14 2010 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - -- - - - - -- 0,1990 MCMASTEHARR SUPPLY CO. BATTERY BOX toR FIRE FOAM TRUC 18.43 C'2826 HICHAEL W,!.GNER & SONS, INC. Pi',RT FOR RIVER PU~lP. 243.75 02107 NAPA-HEIGHTS AUTOMOTIVE SUPPLY SPARK PLUG. 14.94 NAPAGOLD AIR FILTER. 48.40 WI PER BLADES. 42.85 SWAY BAR BUSHING FOR VEHICLE # 11.57 SHOP SUPPLIES. 127.49 STOCK MIRROR. 6.28 FUEL LINE HOSE. 24.50 SPARK PLUG. 27.24 NmGOLD OIL FILTER. 4.13 NmGOLD AIR FILTER. 96.80 SMALL ENGINE BELTS. 35.30 HEADLIGHT FOR FIRE TRUCK #518. 11.70 BATTERY CHARGER FOR FIRE FOAM 34.68 SPARKPLOGS FOR SMALL ENGINES. 20.43 ------------- 506.31 02155 NEXTEL COMMUNICATIONS SERVICE 2118110-3/17/10 216.58 02327 POMP I S TIRE SERVICE, INC. 12 POOL CAR TIRES - STATE PRIC 882.84 MISC. PARTS FOR FIRE TRUCK #51 32.00 SHOP SUPPLIES. 89.00 4 TIRES FOR VEHICLE #2708 - ST 573.24 ------------- 157 7.0 8 0766] PRAIRIE INTERNATIONAL TRUCK SALES TUBE; GAUGE. 15.71 07882 PRECISION SERVICE & PARTS OEM - IMPALA POLICE AIR FILTER 84.04 BLOWER MOTOR. 36.02 CABIN AIR FILTER. 28.00 ------------- 148.06 02355 PRO FINISH PRESSURE WASHER CHEMICALS. 660.00 01191 R. L. CORTY & COMPANY SERVICE CALL - REPLACE SOAP WA 99.00 09423 RONCO INDUSTRIAL SUPPLY VARIOUS DRILL BITS NEEDED TO 1032.68 m8l SOLVENT SYSTEMS INT'L. INC. PARTS WASHER RENTAL. 117 .13 02684 TERRACE SUPPLY COMPANY GAS RENTAL. 16.52 GRINDING DISCS - WELDER PARTS. 125.42 GAS FOR STAINLESS WELDING. 118.04 ------------- 259.9B 09217 W,:JTEK, INC. MISC. PARTS FOR P-55. 48.72 11836 WICKSTRO~l FORD LINCOLN MERCURY REPAIR ENGINE & AIC SYSTEM FOR 313.93 LJl:i WOrJDFIELD CHEVROLET / INC CONNECTOR. 27 .3] REpORT: APBOARDRPT GENERATED: 15 APR 09 11:42 DEPT VENDOE NBE 670 01045 05007 10239 02569 09423 02491 04951 680 01049 690 10051 01236 12124 06420 01737 RUN: TUESDAY APE132010 15:22 RELEASE 10 : VILLAGE OF MOUNT PEOSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 01 2010 TO APRIL 14 2010 VENDOR NAME CATCHING FLUIDPOWER L~,NDK;RK FOED MAEK'S MACHINE SHOP INC. E.G. SMITH EQUIPMENT CO. EONCO INDUSTEIAL SUPPLY SAUBER MFG. CO. SUBURBAN ACCENTS INC. COW GOVERNMENT, INC CCMSI DAVE & JIM'S AUTO BODY, INC. G. PORTER & COMPANY GRAYBAR ELECTRIC CO. INTERGOVERNt~ENTAL PER. BEN .COOP INVOICE DESCRIPTION PAGE 15 AMOUNT OEM-TPANSMISSION FITTINGS & HO 69.33 OEM-EBE DOOR Ll,TCH FOR P-5. 216.49 OEM-TRANSMISSION LINES FOE P-4 38.60 TOTAL 8090.81 351.75 2 SPOOLS OF #451TC8 1/2" HYDRA SEEVICE MANUAL. 2010 FORD POLICE INTEECEPTOR 2010 FORD POLICE INTERCEPTOR DURACLASS "HH" 10FT DUMP BODIE LEG BRACKETS FOR NEW TEUCKS #4 REAE MUD FLAPS FOR NEW TEUCKS 8 SINGLE AXLE TRUCK REAR ALUMI GRAPHICS & LETTERING PACKAGES 2415.70 175.00 112500.00 21887.00 134562.00 17223.50 921.05 533.20 2200.00 TOTAL 159780.45 1925.00 HP LJ P3015DN PEINTER - COW # SHIPPING 2637.00 41.02 TOTAL 2678.02 2678.02 W/C REIMBURSEMENT 4/7/10 REPAIR P-2 ACCIDENT 3/10/10 REPAIR P- 35 ACCIDENT 3/16/10 REPAIR VEHICLE - 12/23/09 REIMB EXP VANDALISM ON 9/5/09 #946657856 -9 E.PROSPECT AVE #946628153 -299 W.CENTRAL RD CL~IMS ,!,DMIN-MEDICAL APR 2010 HMO MEDlm APRIL 2010 LIFE INSUE,!,NCE APRIL 2010 PPO MEDIC~,1 CLAIMS APRIL 2010 38772.68 299.60 854.40 821.60 1975.60 1500.00 21.82 286 4.2 8 2886.10 23431.56 125591.19 2829.00 mm.71 REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 DEPT 'lENDOR NBP 11255 11839 710 02637 720 02637 01027 118 60 770 08178 790 oom 01719 02689 ;)2886 RUN: TUESDAY APR132010 15:22 RELEASE I D : VILLAGE OF MOUNT PROSPECT LISI OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM mIL 01 2010 TO APRIL 14 2010 VENDOR N~,ME LEOPtl.RDO COHPANIES, INC WILLIS OF ILLINOIS, INC BECKER, BURKE ASSOClmS INC BECKER, BURKE ASSOCIATES INC CAPITAL GAINS INC. WERDERITCH, RANDY GU.ARDIAN INDIANA DEPT OF REVENUE NCPERS GROUP LIFE INS. THIRD DISTRICT CIRCUIT COURT WISCONSIN DEPARTt1ENT OF PEVENUE INVOICE DESCRIPTION REIMB EXP VANDALISM 9/5/iO #265847 511/10-511111 #265873 D.ERB 5/1/10-5/1/11 #265865 M.JANONIS5I1!1O-5/1/11 #265874 !.WILKS 511/10-511/11 PAGE 16 AMOUNT 432187.46 929.61 242 3.0 0 1150.00 400.00 400.00 TOTAL 482624.45 437 3.0 0 CONSULTING SERV 4/1/10-6/30/10 TOTAL 8500.00 8500.00 CONSULTING SERV 4/1110-6/30/10 FIRE PENSION - APRIL 2010 1ST QUARTER ADMIN FEE 2010 8500.00 2193.00 TOTAL 10993.00 300.00 EMP.DENTAL PLAN APRIL 2010 TOTAL 8552.69 8552.69 1ST QTR INDIANA TAX REMITTANCE PREMIUM APPIL 2010 PREMIUM APRIL 2010 BOND MONEY 4/1/10 BOND MONEY 4/6/10 BOND MONEY 4/8/10 BOND MONEY 4113/10 WISC. INCOME TAX FOP. Mtl.P.CH 10 TOTAL GRAND TOTAL 36.12 720.00 16.00 736.00 1900.00 1450.00 650.00 2400.00 6400.00 346.71 7518.83 1569717.73 R~PORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RON: TOESDAY APR132010 15:22 RELEASE ID : PAGE 17 VILLAGE OF MOONT PROSPECT LIST OF BILLS PRESENTED TO THE Bom OF TROSTEES FROM mIL 01 2010 TO APRIL 14 2010 - - - - - -- - - -- - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- SUMMm BY FUND - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --- - - - - - - -- - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --- - - - - - -- '101 GENERAL FUND 610893.28 030 REFUSE DISPOSAL FOND 12.50 050 MOTOR FUEL TAX FOND 1976.00 070 COMMUNITY DEVELPMNT BLOCK GRNT 17873.91 095 FOREIGN FIRE TAX BOARD FUND 62.08 510 WITAL IMPROVEMENT FUND 108530.54 528 SERIES 2009 CONST FOND 78757.59 550 DOWNTOWN REDEVLPMNT CONST 18493.11 610 WATER AND SEWER FUND 38654.58 620 VILLAGE PARKING SYSTEM FUND 1506.14 630 PARKING SYSTEM REVENUE FOND 4219.75 660 VEHICLE MAINTENANCE FUND 8090.81 670 VEHICLE REPLACEMENT FOND 159780.45 680 COMPDTER REPLACEMENT FOND 2678.02 690 RISK MANAGEMENT FOND 482624.45 710 POLICE PENSION FOND 8500.00 720 FIRE PENSION FUND 10993.00 770 FLEXCOMP ESCROW FUND 8552.69 790 ESCROW DEPOSIT FOND 7518.83 -------------- TOT AL : 1569717.73 REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY APR132010 15:22 PAGE REPORT PARAMETERS ORGANmTI0N NO. : 001 STAPTING CHECK DATE : 04/01/10 ENDING CHECK DATE : 04/14/10 mRTING BP,NK ENDING BANK SEGMENT NUMBER TO SORT BY : 01 STARTING ACCOUNT SEGMENT NUMBER: ALL ENDING ACCOUNT SEGMENT NUMBER : ALL PELEASE LEVEL 04/13/10 EMR025 Village of Mount Prospect List of Escrow Checks Presented to the Board of Trustees 04/14/10 To 04/14/10 Paid to Permit # 100217 ADR CONTRACTING INC ALLIED AC & HEATING CORP 090123 090960 090278 100256 ALVARADO, INCON AQUA PLUMBING SERVICES ARS OF ILLINOIS BLAKE, ARTURO A 100262 BREX-ARLINGTON, INC 092630 091524 100182 100224 090233 091562 CHUNG, EUGENE DESIGN GROUP SIGNAGE CORPORATION DUANE BLANTON PLUMBING SEWER DURA SHIELD COMPANIES ESTRELLAS, LAS FOUR SEASONS 100227 GRATE SIGNS 100027 HORN, MATTHEW 090536 100229 100004 090245 100257 091209 091131 060164 092657 100133 090209 090385 100098 100221 IBBOTSON HEATING CO ITASCA CONSTRUCTION ASSOCIATES J & S PLUMBING JOZWIAK, WAYNE JRS CONCRETE CONSTRUCTION INC LUSSUM JAMES AND PETERS, LEA NORWOOD FOUNDERS ROW PARAGON MGMT GROUP LLC PERFORMANCE TANK INC PRECISION PLUMBING SERVICES INC RELIANCE PLUMBING SEWER RICK'S SEWER & DRAINAGE UNITED STRUCTURAL SYSTEMS OF CHGO 090235 *** TOTAL NUMBER OF CHECKS 29 Check # 13021316 13021317 13021318 13021319 13021320 13021321 Amount 125.00 125.00 75.00 125.00 125.00 125.00 13021322 75.00 13021323 13021324 13021325 13021326 13021327 13021328 13021329 13021330 13021331 13021332 13021333 13021334 13021335 13021336 125.00 125.00 125.00 125.00 125.00 125.00 200.00 200.00 125.00 650.00 125.00 125.00 150.00 275.00 13021337 1,150.00 950.00 13021338 13021339 13021340 13021341 13021342 13021343 375.00 125.00 75.00 125.00 125.00 250.00 * 13021344 75.00 6,375.00 Page 1