Loading...
HomeMy WebLinkAbout3. FINANCIAL REPORT AND BILLS 09/15/2009 INTEROFFICE MEMORANDUM Village of Mount Prospect Mount Prospect, Illinois TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM: FINANCE DIRECTOR DATE: SEPTEMBER 11, 2009 MONTHLY FINANCIAL REPORT - AUGUST 2009 SUBJECT: Attached hereto are the cash position and investment statements of the Village for the month ended August 31, 2009. These statements provide a snapshot of the Village's cash position as of the month end date noted and are intended to supplement the budget revenue and expenditure summary and listing of bills you currently 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 July 31 were $23.4 million. During August, cash receipts totaled $3,615,958.83. In addition investment income for the month was $6,899.79 and inflows due to Interfund activity generated $12,325.00. Reductions in cash and cash equivalents during August totaled $5,455,535.22. Of this amount, payments to vendors were $4,128,148.54, employee payroll and related expenses were $1,327,392.02 and other disbursements were $3,492.76. There was also a net decrease in cash due to investment activities of $5,448.04. Cash and cash equivalents at August 31 were $21.6 million. Monthly Financial Report - August 2009 September 11, 2009 Page 2 Total investments at July 31 were $10.6 million. During the month, investments increased $5,448.04. This was due to rolling over of a maturing CD, interest included. Total investments at August 31 were $10,581,020.08. Total cash and investments for Governmental and Enterprise Funds at July 31 were $34,013,843.94. Cash and investments at August 31 totaled $32,189,994.24. This is a decrease of $1,823,849.70 for the month. Trust and Agency Funds - Cash and cash equivalents at July 31 were $5.4 million. During August, cash receipts totaled $222,317.26. In addition investment income for the month was $334,479.52 and outflows due to Interfund activity totaled $12,125.00. There was also a net increase in cash due to investment activities of $509,655.55. Reductions in cash and cash equivalents during August totaled $596,857.31. Of this amount, payments to vendors were $167,283.95, employee payroll and related expenses were $406,367.56, payments related to the flexible spending program totaled $22,534.80 and other disbursements were $671.00. Cash and cash equivalents at August 31 were $5.9 million. Total investments at August 31 were $70,297,219.04, a decrease of $315,927.42 from July 31, 2009. There were investment gains of $193,728.13 and a transfer to cash of $509,655.55 that accounted for the change. Total cash and investments for Trust and Agency Funds at July 31 were $76,031 ,811.53. Cash and investments at August 31 totaled $76,173,354.13. This is an increase from the balance at July 31 of $141 ,542.60. 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 July 31 totaled $3,580,157.91. During August, cash receipts totaled $2,191,262.10 and investment income was $3,062.69. Significant cash receipts included sales and income taxes and telecommunication taxes. Sales tax revenues for the month totaled $796,642. Of this amount, $711,625 was generated from the 1 % state portion while $85,017 was generated from the .25% home rule portion. The state portion showed a decrease of 18.5% from last year same time. The home rule portion fell by 28.6%. The difference in the change from prior year is due to the tax being assessed on a different set of goods. Sales taxes received in August are for May sales as there is a three- month lag in getting this distribution from the state. H:\ACCT\Treasurer's Report\2009\Monthly Financial Report\Monthly Cash Position Report - August 2009.doc Monthly Financial Report - August 2009 September 11, 2009 Page 3 Telecommunication tax receipts for August reflect May activity. Total receipts during August were $238,668. This is at the level we received in August 2008. For the year, telecommunication taxes are ahead by 10.7%. This year-end estimate for this revenue was also adjusted based on activity to date. We estimate that the total receipts for 2009 will exceed the budget by $266,000. Landlord/Tenant license fees in the amount of $222,406 were received in August. The annual bills for this license goes out in August for a September 1 due date. For 2009 a total of $240,000 was budgeted. To-date we have received 92.7%. I would expect that the balance of the budgeted amount will be received in September. Disbursements from the General Fund for August included payments to vendors of $1,329,575.54 and payments for employee wages and benefits of $1,046,139.25. Interfund transfers of $402,873.43 for health premiums and vehicle lease and maintenance payments were also made during August. Cash and cash equivalents at August 31 were $2,992,241.79. In addition, investments consisting of certificates of deposit were $2,068,717.92 bringing total cash and investments for the General Fund to $5,060,959.71. Statement of Investments (paQes 3-4) This report provides a breakdown of investments by governmental and enterprise funds and trust and agency funds. The report also provides a fund-by fund breakdown of the investments. Government and Enterprise Funds - The investments for the governmental and agency funds are made up solely of certificates of deposit. Certificates of deposit have maturities of between 30 and 120 days and are currently placed with two different banks, Harris and Citibank. Below is a breakdown of where the monies are placed. Harris CDs CitibanklPMA CDs Market Value 4,843,475.08 5,737,545.00 $ 10,581,020.08 Representing Total Portfolio 45.775% 54.225% 100.000% The portfolio weighted average return is 0.90%. The portfolio return remains low on the types of investments available to municipalities, typically certificate of deposits, money market accounts and short-term treasuries. Investment of the Village's general funds is governed by the Village Investment Policy. The policy was last amended in November 2007. Trust and Agency Funds - The investments for the trust and agency funds are made up of certificates of deposits, fixed income investments and equity mutual funds. Certificates of deposit held in the Escrow Deposit Fund have maturities of between 30 and 120 days. Most of the reserves for this fund are invested in the more liquid money market account due to the nature of the deposit. Escrow refunds are processed two times per month. H:\ACCT\Treasurer's Report\2009\Monthly Financial Report\Monthly Cash Position Report - August 2009.doc Monthly Financial Report - August 2009 September 11, 2009 Page 4 Investments for the Police and Firefighter Pension Funds consist of various fixed income securities as well as equity mutual fund accounts. Wells Fargo is the third-party holder of the fixed income securities. The funds are managed by two investment management firms. Capital Gains and Segall Bryant each hold approximately one-half of the total fixed income securities. They also maintain a portion of these assets 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. Maturity Purchase Financial Investment CUSIP/ Interest Date Date Institution Description Acct # Rate % POLICE PENSION FUND (710) Various Various Wells Fargo Wells Fargo Investments Various Various Various Various Various Mutual Fund Investments Various Various Market Value 19,966,436.21 14,857,106.09 34,823,542.30 FIRE PENSION FUND (720) Various Various Wells Fargo Various Various Various Wells Fargo Investments Mutual Fund Investments Various Various Various Various 21,528,440.04 13,945,236.70 35,473,676.74 TOTAL TRUST AND AGENCY FUND INVESTMENTS $ 70,297,219.04 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 offunds to meet the Village's commitments. The cash position report will be provided to the Village Board and Finance Commission on a monthly basis moving forward. "~C1~ ,(/4. David O. Erb Finance Director H:\ACCT\Treasurer's Report\2009\Monthly Financial Report\Monthly Cash Position Report - August 2009.doc VILLAGE OF MOUNT PROSPECT Preliminary Cash and Investment Position Report - All Funds For the Month Ended August 31, 2009 GOVERNMENTAL AND ENTERPRISE FUNDS Cash and Cash Total Cash and Equivalents Investments Investments Balance at July 31, 2009 $ 23,433,213.20 $ 10,580,630.74 $ 34,013,843.94 Cash receipts 3,615,958.83 3,615,958.83 Investment income 6,899.79 6,899.79 Transfers from investments to cash 1,230,203.03 (1,230,203.03) Transfers to investments from cash (1,230,592.37) 1,230,592.37 Interfund activity 12,325.00 12,325.00 Disbursements: Accounts payable (4,128,148.54) (4,128,148.54) Payroll (1,327,392.02) (1,327,392.02) Other (3,492.76) (3,492.76) Balance at August 31,2009 $ 21,608,974.16 $ 10,581,020.08 $ 32,189,994.24 TRUST AND AGENCY FUNDS * Cash and Cash Total Cash and Equivalents Investments Investments Balance at July 31, 2009 $ 5,418,665.07 $ 70,613,146.46 $ 76,031,811.53 Cash receipts 222,317.26 222,317.26 Investment income (loss) 334,479.52 193,728.13 528,207.65 Transfers from investments to cash 2,825,821.55 (2,825,821.55) Transfers to investments from cash (2,316,166.00) 2,316,166.00 Interfund activity (12,125.00) (12,125.00) Disbursements: Accounts payable (167,283.95) (167,283.95) Payroll (406,367.56) (406,367.56) Flex spending (22,534.80) (22,534.80) Other (671.00) (671.00) Balance at August 31, 2009 $ 5,876,135.09 $ 70,297,219.04 $ 76,173,354.13 * Assets are restricted in purpose and do not represent discretionary assets of the government. I- U W l1. III o II:: l1. I- Z :J o :! II.. o W C) c( -' -' s: ~'" >-0 1-0 "ON c: - ::J~ 11..'" >-00 D::J ~g' ." <( ts"O c({g .c:C: lIlW '".c: U- _ c: o 0 ~:iE '" Ol E,s E ~ ::J 0 III II.. III o Z :J II.. >- U Z W C) c( o Z <( I- III :J II:: I- 1->- ~U II::ZU) I-WO II::C)Z Wc(:J I 011.. I-Z 0<( o U) ZWZ <(UO W::iiij o::OZ -o.W II.. a. o Z <(W .U) !;:O::U) 00.0 ,n II:: Z '"'W:J ...JI-ll.. ~Z OW I- III o Z :J II.. W U) 0:: l1. II:: W I- Z W o Z c( ...J ~ Z W :iE Z II:: W > o C) ...Jill c(1-U) I-UO ii:~Z <(O:J UII::II.. l1. ...JW c(:Ju) -ZO UWZ W>:J o.WLL. U)II:: vl'-CO '" '" I'- Narioo;i oco ro '" m-a:i '" '" ~ 000 ~ ~ ~ ~ ,~ 1.0,-"'" M Nf"--M CO ,....<Ol.O CO N-C\i ,....- S ~ 1.0 ... (f')ClU)Ll)O ......m,....l.OO N....;~....;cri <Dlt),.....NCD co..........,. co,.... a;)-ri~l.t'ic.O I.ONMN..- Lt).....-('t)0)('l') M~ N ct. ... OMtnMr::-OW NCO......OMOf'.. McOo)et>N..nN ......l.OmOmNm NmCOC\ll.OMv (1)- 10 w- 0- 0 N cwi (f)..- M('l')......- ...,.CO NN M-ri ~~ N ... III o ...JZ c(:J ZII.. II::W Wu !zs: -0:: W U) cor--,,....mLt)M OlOl.O,...........N cOC"":o)NM' ("").qNOC\l.,... MMCOClOm"'lt If)-~~a:iaiM NV LOl.Ol.O ......,.... MMl.O 00 ~ ... W U) O::U) 0.0 II::Z W:J I-LL. Z W CO....,.,-...,.N,.......... com ~ ~"! CX!"': ~~ I""'''''' m......NMCO,............ mo co......mMmm- ,-('l') COMNOOl.O ca...... a:i ci ..0 I.t)- N -.;t- ari NO) OOM COM ~_...... N~~ ~<O ... N<DVCOCO COOOOv<D C"'.i..q:a)cx)...t COV.......LOr--.. OO......I.ONN cD ci ..; T"""- T"""- lOO lOLl') roN ~ ~ ... W U ~U) wO U)Z I-:J c:cLL. W o "'NN 1'-"'1'- McOari a"'''' v'" M'r--: a'" co ... CONNNwmo .qaJaJO)('I')<OO N~"":ccia)"":..o "I;fOV'-V,- LOO>NLOl.OU> cO ....,.- N N- ..0 MO> 00- "'~ ~ ... o Z :J LL. ...J ~ W Z W C> ~~~ ~~ '-OCDC'\I<OMl.O l.Ov m,-<o<ocovv Nl.O r-.:NNoctcOC'?O m..n l.Oco(OtO...,.......m C"'>t--. .....-NOLO......CO""" ,-l.O O~riNNNM we>> com ,-,-0- vN ll),- LOLOv OM cnN" -- -- ... U) ~ ~ I- 15 '" Z c: ill ~ COllIl!l! ~ ~ > _ Q)_c 5 .sffi di;ee5 aOl Ol8l>.5 ,s~ill8 Wu Ec:lIl 00::0.," ~ c 0 .- ~ ~ ~ 0 ~ U).!2U)gEs cccc <C~o..'-eo Q,)Q)Q.JQ) UCl.Qic-- EEEE .".E~E~~-g~m~~ :J:E'--1n"U)='S:555 cn'ii~ ~ ffi ffi~~~~~ 51~U~L~~~:soooo co '" ,-.: '" ~- ;:: ro ID~ "'a ""':0 COO "'v w- ari o~ ~~ '" ~ ,-.: I'- '" ~ a a ~ NV a'" Na) "'v "'~ ~a> NN "'~ i: oq-- CO "" I'- 0> 00 a CO_ N o~ '" '" ~,...: 1'-1'- roro <t:itri I'- ro ~co '" '" ~ ro ci CO CO 00 CO '" "" '" '" cD co '" ~ ~ CO ~ cD N co_ W a ~ '" I'- ,-.: '" v_ a I'- m~ Nro 0)0) '" '" "'''' ~a> NI'- ~v I'- ro ro v cD N co '" ": ~ N N '" '" N Ol U c: '" (ij D Cl c: 15 c: W ro a o N ~ ro '" ci ~ III III c.:E :::OlOl ~.5.5 Q.lIllll IIlOlOlOl I-~i:> Z 0.-.= w(/)o"'O :!Ole'C: 1-~~.2 :3!E.!!l~ >t:-_ ~~~~ a "" co '" ~ ~ N I'- cD '" a ~ '" '" ro co cri m 00 ro I'- ~ CO CO cri i5 M '" v N '" ,-.: I'- 00 CO a N '" '" NI'- rDN I'-v ro", ~N "'a v 00 ~a:i vN v a cri N ,..: '" N ci I'- ro a o N a_ m '" ci a "" CO '" ~ 0;_ N I'- cD '" a ",- '" '" ro CO cri ~ ro 00 ro I'- ~ CO co cri i5 M '" v N '" ,-.: I'- 00 co a N III C Ol .5 III Ol > .= (ij o I- '" en ,..; II) ..... ..... ,... co. .... t:: cO ~ N <:> ... ..; ,... .... ", N ..t en en .,; ~ ri ... .... en <:> cO ..... N <Ii ,... II) ~ .... co N ..; ... "'. ..... N en ~ .... ", co .n ~ ci II) co .,; .... en ,... ,..; ... "'. ..... <:> ,... "E Ol E c: Q; > o Cl Ol ,s '0 III Q; III III '" ~ '" c: g ~ U III 15 C Ol III ~ Q. ~ o c: o "0 "0 c: '" Ol III o e- ::J 0. .= "0 Ol ~ III ~ ~ '" III Q; III III <( .... ... III ..... '" II) .,; ,... "'. .... ;:: .,; II) en ci '" <:> ... .... III I- Z W :! I- III W > ~ o Z c( I III c( U -' c( I- o I- 2 VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of August 31,2009 GOVERNMENTAL AND ENTERPRISE FUNDS Maturity Purchase Financial Investment CUSIP/ Interest Market Weighted Date Date Institution Description Acct# Rate % Value Avg Yield GENERAL FUND (001) 09/08/09 06/09/09 Harris Certificate of Deposit 6900200546 0.650% 505,030.46 3,282.70 09/08/09 07/07/09 Harris Certificate of Deposit 6900214015 0.410% 500,940.60 2,053.86 09/15/09 08/1 1/09 Harris Certificate of Deposit 6900156783 0.290% 512,746.86 1,486.97 10/13/09 06/09/09 Harris Certificate of Deposit 6900221843 1.030% 550,000.00 5,665.00 2,068,717.92 12,488.52 Weighted Average Return 0.604% REFUSE DISPOSAL FUND (030) 09/08/09 07/07/09 Harris Certificate of Deposit 6900214015 0.410% 250,470.30 1,026.93 09/1 5/09 08/11/09 Harris Certificate of Deposit 6900156783 0.290% 102,549.36 297.39 10/1 3/09 06/09/09 H arri s Certificate of Deposit 6900221843 1.030% 100,000.00 1,030.00 453,019.66 2,354.32 Weighted Average Return 0.520% CAPITAL IMPROVEMENT FUND (510) 09/1 5/09 08/1 1/09 Harris Certificate of Deposit 6900156783 0.290% 51,274.68 148.70 51,274.68 148.70 Weighted Average Return 0.290% SERIES 2009 CONSTRUCTION FUND (528) 09/1 6/09 04/30/09 Citibank/PMA Certificate of Deposit 132426 0.960% 1,567,942.00 15,052.24 10/21/09 04/30/09 Citibank/PMA Certificate of Deposit 132425 1.160% 1,687,941.00 19,580. I 2 11/18/09 04/30/09 Citibank/PMA Certificate of Deposit 132424 1.280% 248,200.00 3,176.96 11/18/09 04/30/09 Citibank/PMA Certificate of Deposit 132423 1.280% 248,200.00 3,176.96 11/1 8/09 04/30/09 Citibank/PMA Certificate of Deposit 132422 1.260% 1,071,542.00 13,501.43 12/1 6/09 04/30/09 Citibank/PMA Certificate of Deposit 132418 1.541% 245,200.00 3,778.53 12/1 6/09 04/30/09 Citibank/PMA Certificate of Deposit 132419 1.490% 245,400.00 3,656.46 12/1 6/09 04/30/09 Citibank/PMA Certificate of Deposit 132420 1.402% 245,600.00 3,443.31 12/16/09 04/30/09 Citibank/PMA Certificate of Deposit 13242 I 1.370% 177,520.00 2,432.02 5,737,545.00 67,798.04 Weighted Average Return 1.182% WATER AND SEWER FUND (610) 09/1 5/09 08/11/09 Harris Certificate of Deposit 6900156783 0.290% 205,098.72 594.79 10/13/09 06/09/09 Harris Certificate of Deposit 6900221843 1.030% 150,000.00 1,545.00 355,098.72 2,139.79 Weighted Average Return 0.603% VEHICLE MAINTENANCE FUND (660) 09/1 5/09 08/1 1/09 Harris Certificate of Deposit 6900156783 0.290% 51,274.67 148.70 51,274.67 148.70 Weighted Average Return 0.290% VEHICLE REPLACEMENT FUND (670) 09/08/09 07/07/09 Harris Certificate of Deposit 6900214015 0.410% 500,940.60 2,053.86 09/08/09 06/09/09 Harris Certificate of Deposit 6900200546 0.650% 505,030.45 3,282.70 091 15/09 08/1 1/09 Harris Certificate of Deposit 6900156783 0.290% 5 I ,274.67 148.70 10/13/09 06/09/09 Harris Certificate of Deposit 6900221843 1.030% 50,000.00 515.00 1,107,245.72 6,000.25 Weighted Average Return 0.542% 3 VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of August 31, 2009 GOVERNMENTAL AND ENTERPRISE FUNDS (continued) Interest Market Weighted Rate % Value Avg Yield 0.410% 250,470.30 1,026.93 0.290% 256,373.41 743.48 1.030% 250,000.00 2,575.00 756,843.71 4,345.41 0.574% Market Representing Weighted Value Total Portfolio Avg Yield 4,843,475.08 45.775% 27,625.68 5,737,545.00 54.225% 67,798.04 $ 10,581,020.08 100.000% 95,423.72 0.902% Maturity Date Purchase Date Financial Institution Investment Description CUS1P/ Acct # RISK MANAGEMENT FUND (690) 09/08/09 07/07/09 Harris 09/15/09 08/11/09 Harris 10/13/09 06/09/09 Harris Certificate of Deposit Certificate of Deposit Certificate of Deposit 6900214015 6900156783 6900221843 Weighted Average Return GOVERNMENTAL AND ENTERPRISE FUNDS SUMMARY BY TYPE OF INVESTMENT/INSTITUTION: Harris CDs CitibanklPMA CDs Portfolio Weighted Average Return TRUST AND AGENCY FUNDS * Maturity Purchase Financial Investment CUSIP/ Interest Market Weighted Date Date Institution Description Acct# Rate % Value Avg Yield POLICE PENSION FUND (710) Various Various Wells Fargo Wells Fargo Investments Various Various 19,966,436.21 Various Various Various Mutual Fund Investments Various Various 14,857, I 06.09 34,823,542.30 FIRE PENSION FUND (720) Various Various Wells Fargo Wells Fargo Investments Various Various 21,528,440.04 Various Various Various Mutual Fund Investments Various Various 13,945,236.70 35,473,676.74 TOTAL TRUST AND AGENCY FUND INVESTMENTS $ 70,297,219.04 * Assets are restricted in purpose and do not represent discretionary assets of the government. 4 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE & EXPENDITURE SUMMARIES January 1 '"'"' August 31,2009 09/09/2009 10:09:48 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/09 - 08/31/09 Cur Mo Received REVENUE BY CLASSIFICATION PROPERTY TAXES OTHER TAXES LICENSES, PERMITS & FEES INTERGOVERMENT REV. CHARGES FOR SERVICE FINES AND FORFEITS INVESTMENT INCOME REIMBURSEMENTS OTHER REVENUE OTHER FINANCING SOURCES Total All Funds 123,676 892,421 546,894 941,271 1,833,606 53,222 450,501 34,800 217,588 124 5,094,103 REVENUE BY FUND GENERAL FUND REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND FOREIGN FIRE TAX BOARD FUND SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2009 B&I, FD/PW SERIES 1999 B&I, TIF SERIES 1998A B&I, FLOOD SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD CAPITAL IMPROVEMENT FUND SERIES 2009 CONST FUND DOWNTOWN REDEVLPMNT CaNST STREET IMPROVEMENT CaNST FUND FLOOD CONTROL CONST FUND WATER AND SEWER FUND VILLAGE PARKING SYSTEM FUND PARKING SYSTEM REVENUE FUND VEHICLE MAINTENANCE FUND VEHICLE REPLACEMENT FUND COMPUTER REPLACEMENT FUND RISK MANAGEMENT FUND POLICE PENSION FUND FIRE PENSION FUND SSA #6 GEORGE/ALBERT B&I GENERAL FIXED ASSETS ACCT GP Total All Funds 2,268,465 256,175 136,638 o 1 6 7 1,185 9,618 o 3,398 8,073 1,541 o o -11 85,033 o o 78,337 7,090 12,293 107,844 3,403 820,523 12,165 14,261 138,165 79,704 16,450 474,117 277,726 281,896 o o 5,094,103 1 Y-T-D Received 6,803,171 6,508,507 2,878,158 7,882,374 13,638,513 336,239 3,580,643 174,786 3,247,558 10,117,734 55,167,683 20,023,479 2,383,746 906,980 o 105,512 1,696 53 11,920 17,912 7 184,403 440,723 244,037 o o o 382,778 o o 375,803 9,905,331 959,555 542,807 12,358 6,395,432 82,532 87,256 1,106,126 889,778 132,105 4,272,232 2,949,930 2,753,186 6 o 55,167,683 8 Months 4 Months 2009 Budget 13,678,000 15,803,000 3,857,000 18,986,414 22,435,567 730,000 6,839,000 401,000 5,958,952 12,623,000 101,311,933 41,460,000 4,166,000 1,812,000 o 785,604 12,000 2,000 21,000 41,000 o 385,000 918,000 o o o o 1,250,000 o o 1,374,810 12,784,000 2,675,000 1,530,000 108,500 11,983,000 161,000 161,000 1,671,682 1,159,700 220,281 6,683,556 4,966,500 4,980,300 o o 101,311,933 66.6% 33.3% Unreceived Balance 6,874,829 9,294,493 978,842 11,104,040 8,797,054 393,761 3,258,357 226,214 2,711,394 2,505,266 46,144,250 21,436,521 1,782,254 905,020 o 680,092 10,304 1,947 9,080 23,088 -7 200,597 477,277 -244,037 o o o 867,222 o o 999,007 2,878,669 1,715,445 987,193 96,142 5,587,568 78,468 73,744 565,556 269,922 88,176 2,411,324 2,016,570 2,227,114 -6 o 46,144,250 Completed Remaining unreceived Percent 50.3 58.8 25.4 58.5 39.2 53.9 47.6 56.4 45.5 19.8 45.5 51. 7 42.8 49.9 86.6 85.9 97.4 43.2 56.3 52.1 52.0 69.4 72.7 22.5 64.1 64.5 88.6 46.6 48.7 45.8 33.8 23.3 40.0 36.1 40.6 44.7 45.5 09/09/2009 10:10:28 8 Months 4 Months 66.6% 33.3% FRRBRR03 SUM021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/09 - 08/31/09 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 93,710 579,105 541,761 805,821 148,274 48,829 3,969 33,052 13,820 124 TOTAL GENERAL FUND 2,268,465 REFUSE DISPOSAL FUND 40 PROPERTY TAXES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 17,045 238,863 267 o TOTAL REFUSE DISPOSAL FUND 256,175 MOTOR FUEL TAX FUND 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 47 REIMBURSEMENTS 135,450 129 1,059 TOTAL MOTOR FUEL TAX FUND 136,638 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,087,968 3,484,322 2,854,620 6,933,865 1,017,299 307,746 51,287 162,948 122,679 745 20,023,479 847,046 1,464,043 7,698 64,959 2,383,746 897,379 821 8,780 906,980 o o o o 1 o 32,380 16 73,116 1 105,512 o 6 1,589 107 6 1,696 o 7 2009 Budget 10,637,000 7,594,000 3,775,000 16,250,500 1,590,500 699,000 402,000 329,000 183,000 o 41,460,000 1,750,000 2,230,000 35,000 151,000 4,166,000 1,736,000 16,000 60,000 1,812,000 o o o 745,604 o 40,000 785,604 10,000 2,000 12,000 o 53 1,000 1,000 Unreceived Balance 5,549,032 4,109,678 920,380 9,316,635 573,201 391,254 350,713 166,052 60,321 -745 21,436,521 902,954 765,957 27,302 86,041 1,782,254 838,621 15,179 51,220 905,020 o o o 713,224 -16 -33,116 680,092 8,411 1,893 10,304 1,000 947 Completed Remaining Unreceived Percent 52.2 54.1 24.4 57.3 36.0 56.0 87.2 50.5 33.0 51.7 51.6 34.3 78.0 57.0 42.8 48.3 94.9 85.4 49.9 o o o 95.7 -82.8 86.6 84.1 94.7 85.9 100.0 94.7 09/09/2009 10:10:28 FRRBRR03 SUM021 8 Months 4 Months 66.6% Completed Remaining Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/09 - 08/31/09 Cur Mo Received 33.3% Y-T-D Received 2009 Budget Unreceived Balance Unreceived Percent 97.4 TOTAL DEA SHARED FUNDS FUND nUl FINE FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME 1,185 o TOTAL DUI FINE FUND 1,185 FOREIGN FIRE TAX BOARD FUND 41 OTHER TAXES 46 INVESTMENT INCOME 9,617 1 TOTAL FOREIGN FIRE TAX BOARD FUND 9,618 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 7 53 2,000 1,947 11,916 4 20,000 1,000 8,084 996 40.4 99.6 11,920 21,000 9,080 43.2 17,887 25 40,000 1,000 22,113 975 55.3 97.5 17,912 41,000 23,088 56.3 o o o 7 o o o -7 o 7 o -7 3,381 184,194 381,000 196,806 51.7 17 209 4,000 3,791 94.8 0 0 0 0 3,398 184,403 385,000 200,597 52.1 TOTAL SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 8,031 440,180 910,000 469,820 51. 6 42 543 8,000 7,457 93.2 0 0 0 0 8,073 440,723 918,000 477,277 52.0 TOTAL SERIES 2003 B&I, VILLAGE HALL SERIES 2009 B&I, FD/PW 40 PROPERTY TAXES 46 INVESTMENT INCOME 1,509 32 TOTAL SERIES 2009 B&I, FD/PW 1,541 SERIES 1999 B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 1999 BU, TIF SERIES 1998A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 1998A BU, FLOOD 2 243,783 254 o o -243,783 -254 244,037 o -244,037 o o o o o o o o o o o o o o o o o o o o o o o o 09/09/2009 10:10:28 FRRBRR03 SUM021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/09 - 08/31/09 8 Months 4 Months 66.6% 33.3% Completed Remaining SERIES 1998C B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME Cur Mo Y-T-D 2009 Unreceived Unreceived Received Received Budget Balance Percent 0 0 0 0 -11 0 0 0 -11 0 0 0 TOTAL SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I 41 OTHER TAXES 46 INVESTMENT INCOME 85,017 16 382,762 16 1,250,000 o 867,238 -16 69.4 TOTAL IEPA FLOOD CONTROL LOANS B&I 85,033 382,778 1,250,000 867,222 69.4 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 78,216 352,141 1,150,000 797,859 69.4 0 18,750 206,810 188,060 90.9 121 2,047 18,000 15,953 88.6 0 0 0 0 0 2,865 0 -2,865 0 0 0 0 78,337 375,803 1,374,810 999,007 72.7 TOTAL CAPITAL IMPROVEMENT FUND SERIES 2009 CONST FUND 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 7,090 33,342 220,000 186,658 84.8 0 0 1,000 1,000 100.0 0 9,871,989 12,563,000 2,691,011 21.4 7,090 9,905,331 12,784,000 2,878,669 22.5 TOTAL SERIES 2009 CONST FUND DOWNTOWN REDEVLPMNT CONST 41 OTHER TAXES 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES TOTAL DOWNTOWN REDEVLPMNT CONST 12,172 956,481 2,640,000 1,683,519 63.8 121 1,322 35,000 33,678 96.2 0 1,752 0 -1,752 0 0 0 0 0 0 0 0 12,293 959,555 2,675,000 1,715,445 64.1 STREET IMPROVEMENT CONST FUND 41 OTHER TAXES 46 INVESTMENT INCOME 107,844 o 533,659 892 1,520,000 10,000 986,341 9,108 64.9 91.1 3 09/09/2009 10:10:28 FRRBRR03 SUM02l 8 Months 4 Months 66.6% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/09 - 08/31/09 Cur Mo Received 48 OTHER REVENUE TOTAL STREET IMPROVEMENT CONST FUND 107,844 FLOOD CONTROL CONST FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME o 3,403 o o TOTAL FLOOD CONTROL CONST FUND 3,403 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 13,648 1,730 801,975 405 o 2,765 o TOTAL WATER AND SEWER FUND 820,523 VILLAGE PARKING SYSTEM FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 3,061 o 9,099 5 TOTAL VILLAGE PARKING SYSTEM FUND 12,165 PARKING SYSTEM REVENUE FUND 41 OTHER TAXES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 3,741 10,518 2 TOTAL PARKING SYSTEM REVENUE FUND 14,261 VEHICLE MAINTENANCE FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 138,060 105 o TOTAL VEHICLE MAINTENANCE FUND 138,165 VEHICLE REPLACEMENT FUND 44 CHARGES FOR SERVICE 45 FINES AND FORFEITS 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 75,132 3,208 1,364 o o 4 Y-T-D Received o 8,256 542,807 o 12,188 o 170 12,358 750,634 11,350 5,601,247 15,894 o 16,307 o 6,395,432 13,779 o 68,681 72 82,532 16,842 70,329 85 87,256 1,104,454 1,380 292 1,106,126 601,068 14,988 28,722 o 245,000 2009 Budget 1,530,000 o 60,000 47,500 1,000 108,500 1,509,000 16,000 10,236,000 195,000 2,000 25,000 o 11,983,000 45,000 6,000 108,000 2,000 161,000 55,000 105,000 1,000 161,000 1,656,682 15,000 o 1,671,682 899,700 o 200,000 o 60,000 33.3% Unreceived Balance o -8,256 987,193 o 47,812 47,500 830 96,142 758,366 4,650 4,634,753 179,106 2,000 8,693 o 5,587,568 31,221 6,000 39,319 1,928 78,468 38,158 34,671 915 73,744 552,228 13,620 -292 565,556 298,632 -14,988 171,278 o -185,000 Completed Remaining Unreceived Percent 64.5 79.7 100.0 83.0 88.6 50.3 29.1 45.3 91. 8 100.0 34.8 46.6 69.4 100.0 36.4 96 .4 48.7 69.4 33.0 91. 5 45.8 33.3 90.8 33.8 33.2 85.6 -308.3 09/09/2009 10:10:28 FRRBRR03 SUM021 8 Months 4 Months 66.6% 33.3% Completed Remaining Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/09 - 08/31/09 Cur Mo Received Y-T-D Received 2009 Budget Unreceived Balance Unreceived Percent TOTAL VEHICLE REPLACEMENT FUND 79,704 269,922 23.3 395,411 3,581,204 5,414,404 1,833,200 33.9 766 12,088 90,000 77,912 86.6 689 1,306 10,000 8,694 86.9 77,251 677,634 1,169,152 491,518 42.0 474,117 4,272,232 6,683,556 2,411,324 36.1 COMPUTER REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 16,274 176 TOTAL COMPUTER REPLACEMENT FUND 16,450 RISK MANAGEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE TOTAL RISK MANAGEMENT FUND POLICE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE 209,049 68,677 277 ,726 TOTAL POLICE PENSION FUND FIRE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE 226,821 55,075 TOTAL FIRE PENSION FUND 281,896 SSA #6 GEORGE/ALBERT B&I 46 INVESTMENT INCOME TOTAL SSA #6 GEORGE/ALBERT B&I GENERAL FIXED ASSETS ACCT GP 47 REIMBURSEMENTS 49 OTHER FINANCING SOURCES TOTAL GENERAL FIXED ASSETS ACCT GP MOUNT PROSPECT LIBRARY FUND 49 OTHER FINANCING SOURCES TOTAL MOUNT PROSPECT LIBRARY FUND 5 889,778 130,188 1,917 132,105 1,757,893 1,192,037 2,949,930 1,663,773 1,089,413 2,753,186 o o o o o o o 1,159,700 195,281 25,000 220,281 2,693,000 2,273,500 4,966,500 2,864,000 2,116,300 4,980,300 6 6 o o o o 9,450,626 o 9,450,626 65,093 23,083 33.3 92.3 88,176 40.0 935,107 1,081,463 34.7 47.6 2,016,570 40.6 1,200,227 1,026,887 41. 9 48.5 2,227,114 44.7 o -6 o -6 o o o o o o 9,450,626 100.0 9,450,626 100.0 8 Months 4 Months 09/09/2009 10:08:27 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/09 - 08/31/09 Cur Mo Expended Y-T-D Expended 2009 Budget 66.6% 33.3% Unexpended Balance Completed Remaining Unexpended Percent EXPENDITURE BY CLASSIFICATION PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS PENSION BENEFITS CONTRACTUAL SERVICES UTILITIES INSURANCE COMMODITIES & SUPPLIES OTHER EXPENDITURES LAND IMPROVEMENTS BUILDING IMPROVEMENTS OFFICE EQUIPMENT MOBILE EQUIPMENT OTHER EQUIPMENT DISTRIBUTION SYSTEMS INFRASTRUCTURE BOND PRINCIPAL INTEREST EXPENSE BANK AND FISCAL FEES INTERFUND TRANSFERS Total All Funds 1,988,614 508,856 24,222 525,568 1,525,808 42,139 488,300 122,474 17,074 4,812 1,058,217 21,910 169,240 124,167 197,674 345,142 o o o o 7,164,217 EXPENDITURE BY FUND GENERAL FUND REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND FOREIGN FIRE TAX BOARD FUND SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2009 B&I, FD/PW SERIES 1999 B&I, TIF SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL CAPITAL IMPROVEMENT FUND SERIES 2009 CONST FUND DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST FUND WATER AND SEWER FUND VILLAGE PARKING SYSTEM FUND PARKING SYSTEM REVENUE FUND VEHICLE MAINTENANCE FUND 2,853,811 339,145 160,974 o 25,430 o 7,350 o o o o o o o o o o o o 116,100 1,105,443 67,915 63,345 153,405 938,782 8,204 15,705 148,003 17,378,529 5,754,427 247,386 4,087,540 10,678,990 302,072 4,552,592 1,016,640 160,993 58,138 2,843,453 151,533 1,270,915 564,386 509,435 3,052,885 265,053 344,092 1,050 o 53,240,109 25,855,765 2,601,804 1,509,227 o 379,847 7,416 7,350 853 8,237 o 83,320 200,553 o o o o o 326,322 o 221,914 3,333,466 243,700 1,073,497 663,453 5,719,138 49,752 89,843 1,078,319 1 26,976,217 9,732,355 528,119 5,985,000 19,097,242 657,765 6,962,783 1,886,244 1,920,250 62,800 11,008,906 503,564 2,535,500 3,127,373 2,337,040 4,935,000 1,225,219 678,783 1,200 o 100,161,360 41,954,900 4,196,092 2,113,102 o 810,604 2,000 1,000 1,500 15,500 o 381,340 910,508 o o o o o 613,354 o 1,544,850 12,784,000 1,925,650 2,856,600 235,000 12,515,305 131,484 143,903 1,671,682 9,597,688 3,977,928 280,733 1,897,460 8,418,252 355,693 2,410,191 869,604 1,759,257 4,662 8,165,453 352,031 1,264,585 2,562,987 1,827,605 1,882,115 960,166 334,691 150 o 46,921,251 16,099,135 1,594,288 603,875 o 430,757 -5,416 -6,350 647 7,263 o 298,020 709,955 o o o o o 287,032 o 1,322,936 9,450,534 1,681,950 1,783,103 -428,453 6,796,167 81,732 54,060 593,363 35.6 40.9 53.2 31.7 44.1 54.1 34.6 46.1 91. 6 7.4 74.2 69.9 49.9 82.0 78 .2 38.1 78.4 49.3 12.5 46.8 38.4 38.0 28.6 53.1 -270.8 -635.0 43.1 46.9 78.2 78.0 46.8 85.6 73.9 87.3 62.4 -182.3 54.3 62.2 37.6 35.5 Cur Mo Y-T-D 2009 Unexpended Unexpended Expended Expended Budget Balance Percent VEHICLE REPLACEMENT FUND 169,240 1,270,915 2,535,500 1,264,585 49.9 COMPUTER REPLACEMENT FUND 5,000 121,613 188,150 66,537 35.4 RISK MANAGEMENT FUND 464,597 4,334,961 6,684,336 2,349,375 35.1 POLICE PENSION FUND 270,460 2,069,704 2,993,500 923,796 30.9 FIRE PENSION FUND 251,308 1,989,140 2,951,500 962,360 32.6 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,164,217 53,240,109 100,161,360 46,921,251 46.8 09/09/2009 10:08:27 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/09 - 08/31/09 2 8 Months 4 Months 66.6% 33.3% Completed Remaining 09/09/2009 10:11:02 FRRDBROl SUM031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 08/31/09 NON-DEPARTMENTAL Cur Mo Expended Unexpended Unexpended Balance Percent 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 2009 Budget o o o o o o o o o o o o 1 66.6% Completed 33.3% Remaining o o o o o o o o o o o o 09/09/2009 10:11:02 FRRDBROl SUM031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 08/31/09 PUBLIC REPRESENTATION Cur Mo Expended PROGRAM TOTALS 02 MAYOR AND BOARD OF TRUSTEES 03 ADVISORY BOARDS & COMMISSIONS 3,767 339 Totals 4,106 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 2,786 469 250 570 31 o Totals 4,106 SOURCE OF FUNDS 001 GENERAL FUND 4,106 Totals 4,106 2 Y-T-D Expended 96,652 3,299 99,951 22,685 3,966 1,173 68,726 163 3,238 99,951 99,951 99,951 2009 Budget 129,856 7,448 137,304 33,967 5,955 8,900 83,132 500 4,850 137,304 13 7 , 304 137,304 66.6% 33.3% Completed Remaining Unexpended Unexpended Balance Percent 33,204 4,149 37,353 11,282 1,989 7,727 14,406 337 1,612 37,353 37,353 37,353 25.6 55.7 27.2 33.2 33.4 86.8 17.3 67.4 33.2 27.2 27.2 27.2 09/09/2009 10:11:02 FRRDBROl SUM031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 08/31/09 VILLAGE MANAGER'S OFFICE Cur Mo Expended PROGRAM TOTALS 01 VILLAGE MANAGER'S OFFICE 02 LEGAL SERVICES 03 HUMAN RESOURCES 04 INFORMATION TECHNOLOGY 05 PUBLIC INFORMATION 40,578 76,572 20,555 72,723 32,180 Totals 242,608 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 74,293 24,818 552 140,993 717 1,235 o o Totals 242,608 SOURCE OF FUNDS 001 GENERAL FUND 242,608 Totals 242,608 Y-T-D Expended 388,607 528,915 184,210 575,938 197,740 1,875,410 656,389 226,964 17,390 964,390 4,354 5,704 219 o 1,875,410 1,875,410 1,875,410 3 2009 Budget 558,634 560,750 373,141 1,105,852 276,839 2,875,216 1,024,771 342,016 44,700 1,418,824 9,860 14,315 19,130 1,600 2,875,216 2,875,216 2,875,216 66.6% 33.3% Completed Remaining Unexpended Unexpended Balance Percent 170,027 31,835 188,931 529,914 79,099 999,806 368,382 115,052 27,310 454,434 5,506 8,611 18,911 1,600 999,806 999,806 999,806 30.4 5.7 50.6 47.9 28.6 34.8 35.9 33.6 61.1 32.0 55.8 60.2 98.9 100.0 34.8 34.8 34.8 09/09/2009 8 Months 66.6% Completed 10,11:02 VILLAGE OF MOUNT PROSPECT 4 Months 33.3% Remaining FRRDBROl SUM031 Department Budget Expenditure Summary 01/01/09 - 08/31/09 Cur Mo Y-T-D 2009 Unexpended Unexpended TV SERVICES DIVISION Expended Expended Budget Balance Percent PROGRAM TOTALS 02 CABLE TV OPERATIONS 9,202 99,583 141,989 42,406 29.9 04 INTERGOVERNMENTAL PROGRAMMING 3,170 30,998 49,424 18,426 37.3 Totals 12,372 130,581 191,413 60,832 31.8 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 8,585 76,091 111,064 34,973 31.5 51 EMPLOYEE BENEFITS 3,063 27,872 41,653 13,781 33.1 52 OTHER EMPLOYEE COSTS 0 1,229 2,900 1,671 57.6 54 CONTRACTUAL SERVICES 572 11,876 18,936 7,060 37.3 55 UTILITIES 152 1,035 1,600 565 35.3 57 COMMODITIES & SUPPLIES 0 6,246 5,760 -486 -8.4 67 OTHER EQUIPMENT 0 6,232 9,500 3,268 34.4 Totals 12,372 130,581 191,413 60,832 31.8 SOURCE OF FUNDS 001 GENERAL FUND 12,372 130,581 191,413 60,832 31. 8 Totals 12,372 130,581 191,413 60,832 31.8 4 09/09/2009 10:11:02 FRRDBROl SUM031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 08/31/09 8 Months 4 Months 66.6% 33.3% Completed Remaining VILLAGE CLERK'S OFFICE Cur Mo Expended Y-T-D Expended 2009 Budget Unexpended Balance Unexpended Percent PROGRAM TOTALS 02 VILLAGE CLERK' S OFFICE 13,772 131,837 217,076 217,076 85,239 39.3 Totals 13,772 131,837 85,239 39.3 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES Totals 9,231 82,846 123,762 40,916 33.1 3,293 29,781 44,900 15,119 33.7 175 1,262 2,580 1,318 51.1 886 15,561 39,331 23,770 60.4 105 546 1,700 1,154 67.9 82 1,841 4,803 2,962 61. 7 13,772 131,837 217,076 85,239 39.3 SOURCE OF FUNDS 001 GENERAL FUND 13,772 131,837 131,837 217,076 217,076 85,239 39.3 Totals 13,772 85,239 39.3 5 09/09/2009 10:11:02 FRRDBROl SUM031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 08/31/09 FINANCE DEPARTMENT Cur Mo Expended PROGRAM TOTALS 01 FINANCE ADMINISTRATION 02 ACCOUNTING 05 INSURANCE PROGRAMS 06 CUSTOMER SERVICE 07 CASH MANAGEMENT 24,618 35,897 21,417 33,845 2,130 Totals 117,907 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 62, 962 21,862 429 15,254 515 15,503 1,382 o Totals 117,907 SOURCE OF FUNDS 001 GENERAL FUND 117,907 Totals 117,907 6 Y-T-D Expended 229,671 311,277 202,545 273,587 18,492 1,035,572 542,558 194,114 5,282 122,559 2,954 152,025 15,650 430 1,035,572 1,035,572 1,035,572 2009 Budget 357,182 479,410 311,373 418,917 27,913 1,594,795 831,555 295,308 11,900 189,454 6,520 234,038 25,020 1,000 1,594,795 1,594,795 1,594,795 66.6% 33.3% Completed Remaining Unexpended Unexpended Balance Percent 127,511 168,133 108,828 145,330 9,421 559,223 288,997 101,194 6,618 66,895 3,566 82,013 9,370 570 559,223 559,223 559,223 35.7 35.1 35.0 34.7 33.8 35.1 34.8 34.3 55.6 35.3 54.7 35.0 37.5 57.0 35.1 35.1 35.1 09/09/2009 10:11:02 FRRDBROl SUM031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 08/31/09 COMMUNITY DEVELOPMENT Cur Mo Expended PROGRAM TOTALS 01 COMMUNITY DEVELOPMENT ADMIN 02 PLANNING & ZONING 03 ECONOMIC DEVELOPMENT 05 BUILDING INSPECTIONS 06 HOUSING INSPECTIONS 07 HEALTH INSPECTIONS 16,101 18,712 10,066 71,495 38,786 9,578 Totals 164,738 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 102,717 38,026 3,360 17,816 1,373 1,446 o Totals 164,738 SOURCE OF FUNDS 001 GENERAL FUND 550 DOWNTOWN REDEVLPMNT CONST 164,738 o Totals 164,738 7 Y-T-D Expended 180,413 193,985 65,625 565,533 335,427 81,359 1,422,342 896,571 334,991 16,491 153,496 8,223 12,570 o 1,422,342 1,421,342 1,000 1,422,342 2009 Budget 285,081 367,504 148,732 995,627 580,743 127,033 2,504,720 1,390,145 511,065 35,808 496,195 19,274 22,633 29,600 2,504,720 2,503,720 1,000 2,504,720 66.6% 33.3% Unexpended Balance 104,668 173,519 83,107 430,094 245,316 45,674 1,082,378 493,574 176,074 19,317 342,699 11,051 10,063 29,600 1,082,378 1,082,378 o 1,082,378 Completed Remaining Unexpended Percent 36.7 47.2 55.9 43.2 42.2 36.0 43.2 35.5 34.5 53.9 69.1 57.3 44.5 100.0 43.2 43.2 43.2 09/09/2009 10:11:02 FRRDBROl SUM031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 08/31/09 COMMUNITY DEVELOPMENT - CDBG Cur Mo Expended PROGRAM TOTALS 04 CDBG ADMINISTRATION 05 CDBG COMMUNITY PROGRAMS 06 ACCESSIBLTY & NEIGHBRHD IMPRV 07 CDBG RESIDENTIAL REHAB 6,981 1,375 o 17,074 Totals 25,430 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 7,944 1,601 149 -1,338 o 17,074 o o Totals 25,430 SOURCE OF FUNDS 070 COMMUNITY DEVELPMNT BLOCK GRNT 25,430 Totals 25,430 8 Y-T-D Expended 60,138 32,750 130,269 156,690 379,847 40,741 14,188 702 42,912 105 98,439 52,491 130,269 379,~47 379,847 379,847 2009 Budget 95,604 80,000 380,000 255,000 810,604 61,473 22,064 2,165 148,925 977 195,000 o 380,000 810,604 810,604 810,604 66.6% 33.3% Completed Remaining Unexpended Unexpended Balance Percent 35,466 47,250 249,731 98,310 430,757 20,732 7,876 1,463 106,013 872 96,561 -52,491 249,731 430,757 430,757 430,757 37.1 59.1 65.7 38.6 53.1 33.7 35.7 67.6 71.2 89.3 49.5 65.7 53.1 53.1 53.1 09/09/2009 10:11:02 FRRDBROl SUM031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 08/31/09 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 11,622 28,086 14,385 1,987 36,509 Totals 92,589 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 48,436 5,226 143 9,851 952 285 14,916 12,780 Totals 92,589 SOURCE OF FUNDS 001 GENERAL FUND 92,589 Totals 92,589 9 Y-T-D Expended 103,991 242,609 120,734 18,051 129,443 614,828 353,202 130,103 1,563 50,851 5,324 6,941 45,375 21,469 614,828 614,828 614,828 2009 Budget 200,270 366,097 195,471 42,596 405,857 1,210,291 677,842 238,166 10,700 138,968 15,200 56,750 43,470 29,195 1,210,291 1,210,291 1,210,291 66.6% 33.3% Unexpended Balance 96,279 123,488 74,737 24,545 276,414 595,463 324,640 108,063 9,137 88,117 9,876 49,809 -1,905 7,726 595,463 595,463 595,463 Completed Remaining Unexpended Percent 48.1 33.7 38.2 57.6 68.1 49.2 47.9 45.4 85.4 63.4 65.0 87.8 -4.4 26.5 49.2 49.2 49.2 09/09/2009 10:11:02 FRRDBROl SUM031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 08/31/09 POLICE Cur Mo Expended PROGRAM TOTALS 01 POLICE ADMINISTRATION 02 PATROL & TRAFFIC ENFORCEMENT 03 CRIME PREVTN & PUBLIC SERVICES 04 INVESTIGATIVE & JUVENILE PRGM 05 CROSSING GUARDS 06 EQUIPMENT MAINTENANCE 134,970 640,637 20,697 91,833 105 53,110 Totals 941,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 80 INTERFUND TRANSFERS 663,991 151,707 11,583 96,490 3,050 6,288 o 8,243 o Totals 941,352 SOURCE OF FUNDS 001 GENERAL FUND 060 LAW ENFORCEMENT BLOCK GRANT 080 ASSET SEIZURE FUND 085 DEA SHARED FUNDS FUND 086 DUI FINE FUND 934,002 o o 7,350 o Totals 941,352 10 Y-T-D Expended 1,870,605 5,640,859 162,302 838,811 18,514 470,540 9,001,631 5,974,744 1,937,091 99,898 866,923 21,424 74,374 3,172 24,005 o 9,001,631 8,986,012 o 7,416 7,350 853 9,001,631 2009 Budget 3,306,324 8,780,279 252,788 1,305,331 30,410 712,890 14,388,022 9,322,355 3,402,707 156,500 1,303,890 38,400 122,420 17,550 24,200 o 14,388,022 14,383,522 o 2,000 1,000 1,500 14,388,022 66.6% 33.3% Unexpended Balance 1,435,719 3,139,420 90,486 466,520 11,896 242,350 5,386,391 3,347,611 1,465,616 56,602 436,967 16,976 48,046 14,378 195 o 5,386,391 Completed Remaining Unexpended Percent 43.4 35.8 35.8 35.7 39.1 34.0 37.4 35.9 43.1 36.2 33.5 44.2 39.2 81. 9 0.8 37.4 5,397,510 37.5 o -5,416 -270.8 -6,350 -635.0 647 43.1 5,386,391 37.4 09/09/2009 8 Months 66.6% Completed 10:11:02 VILLAGE OF MOUNT PROSPECT 4 Months 33.3% Remaining FRRDBROl SUM031 Department Budget Expenditure Summary 01/01/09 - 08/31/09 Cur Mo Y-T-D 2009 Unexpended Unexpended FIRE Expended Expended Budget Balance Percent PROGRAM TOTALS 01 FIRE ADMINISTRATION 89,436 1,385,852 2,527,246 1,141,394 45.2 02 FIRE DEPARTMENT OPERATIONS 555,218 4,950,934 7,548,123 2,597,189 34.4 03 FIRE TRAINING ACADEMY 0 4,512 14,131 9,619 68.1 04 FIRE PREVENTION 44,032 379,230 594,865 215,635 36.2 05 FIRE COMMUNICATIONS 3,544 33,988 59,300 25,312 42.7 06 EQUIPMENT MAINTENANCE 9,242 188,514 548,839 360,325 65.7 07 EMERGENCY PREPAREDNESS PRGM 7,358 63,657 49,579 -14,078 -28.4 08 PAID-ON-CALL PROGRAM 1,400 13,228 36,948 23,720 64.2 10 FOREIGN FIRE INSURANCE 0 8,237 15,500 7,263 46.9 Totals 710,230 7,028,152 11,394,531 4,366,379 38.3 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 548,195 4,875,379 7,479,511 2,604,132 34.8 51 EMPLOYEE BENEFITS 98,677 1,587,029 2,920,735 1,333,706 45.7 52 OTHER EMPLOYEE COSTS 4,980 63,337 159,005 95,668 60.2 53 PENSION BENEFITS 0 473 500 27 5.4 54 CONTRACTUAL SERVICES 43,129 322,564 475,065 152,501 32.1 55 UTILITIES 2,561 18,587 42,000 23,413 55.7 57 COMMODITIES & SUPPLIES 9,894 100,307 173,475 73,168 42.2 64 BUILDING IMPROVEMENTS 0 3,887 3,800 -87 -2.3 65 OFFICE EQUIPMENT 0 199 2,150 1,951 90.7 67 OTHER EQUIPMENT 2,794 56,390 138,290 81,900 59.2 Totals 710,230 7,028,152 11,394,531 4,366,379 38.3 SOURCE OF FUNDS 001 GENERAL FUND 710,230 7,019,915 11,379,031 4,359,116 38.3 095 FOREIGN FIRE TAX BOARD FUND 0 8,237 15,500 7,263 46.9 Totals 710,230 7,028,152 11,394,531 4,366,379 38.3 11 09/09/2009 10:11:02 FRRDBROl SUM031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 08/31/09 PUBLIC WORKS - ADMINISTRATION Cur Mo Expended PROGRAM TOTALS 01 PUBLIC WORKS ADMINISTRATION 108,339 108,339 Totals 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 17,146 11,165 1,306 77,107 1,115 500 o o Totals 108,339 SOURCE OF FUNDS 001 GENERAL FUND 108,339 Totals 108,339 12 Y-T-D Expended 895,366 895,366 150,019 94,393 17,000 613,136 9,286 11,277 o 255 895,366 895,366 895,366 2009 Budget 1,390,732 1,390,732 256,740 145,597 30,802 920,101 20,837 14,909 1,123 623 1,390,732 1,390,732 1,390,732 66.6% Completed 33.3% Remaining Unexpended Unexpended Balance Percent 495,366 495,366 106,721 51,204 13,802 306,965 11,551 3,632 1,123 368 495,366 495,366 495,366 35.6 35.6 41.6 35.2 44.8 33.4 55.4 24.4 100.0 59.1 35.6 35.6 35.6 09/09/2009 10:11:02 FRRDBROl SUM031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 08/31/09 PUBLIC WORKS - STREETS/SLDGS Cur Mo Expended PROGRAM TOTALS 01 STREET DIVISION ADMINISTRATION 02 MAINTENANCE - PUBLIC BUILDINGS 04 STREET MAINTENANCE 05 SNOW REMOVAL 06 LEAF REMOVAL 07 STORM SEWER & BASIN MAINT 08 MAINTENANCE OF STATE HIGHWAYS 09 TRAFFIC SIGN MAINTENANCE 10 VILLAGE PARKING LOT MAINT 11 PARKING LOT MAINTENANCE 12 FLOOD CONTROL 13 STORM EVENT 9,853 81,008 72,423 13,807 o 12,156 5,729 10,096 8,204 15,705 o o Totals 228,981 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 84,919 25,103 96,038 3,336 133 15,707 o o o 3,745 Totals 228,981 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 620 VILLAGE PARKING SYSTEM FUND 630 PARKING SYSTEM REVENUE FUND 158,088 46,984 8,204 15,705 Totals 228,981 13 Y-T-D Expended 100,439 591,742 295,053 593,183 o 116,817 36,638 77,195 49,752 89,843 o o 1,950,662 905,062 253,695 427,315 19,296 1,065 282,758 o o o 61,471 1,950,662 1,570,756 240,311 49,752 89,843 1,950,662 2009 Budget 66.6% 33.3% Completed Remaining Unexpended Unexpended Balance Percent 153,041 1,009,924 557,674 660,832 o 189,420 81,210 128,034 131,484 143,903 o o 3,055,522 1,277,373 367,460 720,879 84,230 1,598 400,056 o 13,056 5,870 185,000 3,055,522 2,480,703 299,432 131,484 143,903 3,055,522 52,602 418,182 262,621 67,649 o 72,603 44,572 50,839 81,732 54,060 o o 1,104,860 372,311 113,765 293,564 64,934 533 117,298 o 13,056 5,870 123,529 1,104,860 909,947 59,121 81,732 54,060 1,104,860 34.4 41.4 47.1 10.2 38.3 54.9 39.7 62.2 37.6 36.2 29.1 31.0 40.7 77.1 33.4 29.3 100.0 100.0 66.8 36.2 36.7 19.7 62.2 37.6 36.2 09/09/2009 10:11:02 FRRDBROl SUM031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 08/31/09 PUBLIC WORKS - FORESTRY/GRNDS Cur Mo Expended PROGRAM TOTALS 01 FORESTRY DIVISION ADMIN 02 MAINTENANCE OF GROUNDS 03 FORESTRY PROGRAM 04 PUBLIC GROUNDS BEAUTIFICATION 16,814 36,574 126,742 2,322 Totals 182,452 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT 58,425 17,452 o 105,533 3,267 -2,225 Totals 182,452 SOURCE OF FUNDS 001 GENERAL FUND 690 RISK MANAGEMENT FUND 182,452 o Totals 182,452 14 Y-T-D Expended 150,318 300,809 606,133 52,769 1,110,029 490,337 152,408 1,701 412,109 36,974 16,500 1,110,029 1,110,029 o 1,110,029 2009 Budget 226,515 537,937 1,188,133 102,986 2,055,571 748,292 232,023 3,662 942,738 74,549 54,307 2,055,571 2,044,071 11,500 2,055,571 66.6% 33.3% Completed Remaining Unexpended Unexpended Balance Percent 76,197 237,128 582,000 50,217 945,542 257,955 79,615 1,961 530,629 37,575 37,807 945,542 934,042 11,500 945,542 33.6 44.1 49.0 48.8 46.0 34.5 34.3 53.5 56.3 50.4 69.6 46.0 45.7 100.0 46.0 09/09/2009 10:11:02 FRRDBROl SUM031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 08/31/09 PUBLIC WORKS - ENGINEERING Cur Mo Expended PROGRAM TOTALS 01 ENGINEERING SERVICES 05 TRAFFIC CNTRL & STREET LGHTNG 64,307 128,750 Totals 193,057 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 69 INFRASTRUCTURE 53,421 14,825 o 9,654 17,249 4,986 o 1,326 91,596 Totals 193,057 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 79,067 113,990 Totals 193,057 15 Y-T-D Expended 552,450 425,946 978,396 468,802 133,100 2,782 57,480 124,608 14,228 o 1,326 176,070 978,396 675,305 303,091 978,396 2009 Budget 830,223 721,493 1,551,716 683,255 197,263 5,552 156,907 225,000 32,855 546 1,638 248,700 1,551,716 1,066,146 485,570 1,551,716 66.6% 33.3% Unexpended Balance 277,773 295,547 573,320 214,453 64,163 2,770 99,427 100,392 18,627 546 312 72,630 573,320 390,841 182,479 573,320 Completed Remaining Unexpended Percent 33.5 41.0 36.9 31.4 32.5 49.9 63.4 44.6 56.7 100.0 19.0 29.2 36.9 36.7 37.6 36.9 09/09/2009 10:11:02 FRRDBROl SUM031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 08/31/09 PUBLIC WORKS - WATER/SEWER Cur Mo Expended PROGRAM TOTALS 01 WATER & SEWER DIVISION ADMIN 02 MAINTENANCE OF BUILDINGS 03 MAINTENANCE OF GROUNDS 04 WATER SUPPLY MAINT & REPAIR 05 WATER DISTRBT MAINT & REPAIR 06 WATER VALVE/HYDRNT MAINT & REP 07 WATER METER MAINT & REPL 08 EQUIPMENT MAINTENANCE 09 SANITARY SEWER MAINT & REPAIR 10 WATER & SEWER SYSTEM IMPROV 12 LAKE MICHIGAN WATER SUPPLY 91,442 14,408 10,792 43,120 62,360 35,678 23,014 55,819 42,658 249,494 309,997 Totals 938,782 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 155,761 49,639 1,145 483,532 10,912 5,856 23,848 o 4,130 6,285 197,674 Totals 938,782 SOURCE OF FUNDS 610 WATER AND SEWER FUND 938,782 Totals 938,782 16 Y-T-D Expended 825,300 122,230 59,377 337,397 572,796 218,284 191,376 446,549 265,232 645,740 2,034,857 5,719,138 1,128,616 404,508 15,753 3,137,247 85,583 46,851 92,975 o 4,431 293,739 509,435 5,719,138 5,719,138 5,719,138 2009 Budget 1,425,582 203,986 101,058 1,030,137 1,092,408 392,170 390,778 669,823 1,115,863 2,315,500 3,778,000 12,515,305 1,874,948 637,578 49,430 6,052,354 190,944 70,276 236,365 o 7,575 1,058,795 2,337,040 12,515,305 12,515,305 12,515,305 66.6% 33.3% Unexpended Balance 600,282 81,756 41,681 692,740 519,612 173,886 199,402 223,274 850,631 1,669,760 1,743,143 6,796,167 746,332 233,070 33,677 2,915,107 105,361 23,425 143,390 o 3,144 765,056 1,827,605 6,796,167 6,796,167 6,796,167 Completed Remaining Unexpended Percent 42.1 40.1 41.2 67.2 47.6 44.3 51. 0 33.3 76.2 72 .1 46.1 54.3 39.8 36.6 68.1 48.2 55.2 33.3 60.7 41. 5 72.3 78 .2 54.3 54.3 54.3 09/09/2009 10:11:02 FRRDBROl SUM 031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 08/31/09 PUBLIC WORKS - REFUSE DISPOSAL Cur Mo Expended PROGRAM TOTALS 01 REFUSE DISPOSAL PROGRAM 02 REFUSE LEAF REMOVAL PROGRAM 329,052 10,093 Totals 339,145 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 14 , 213 4,636 150 311,314 20 2,211 6,601 Totals 339,145 SOURCE OF FUNDS 030 REFUSE DISPOSAL FUND 339,145 Totals 339,145 17 Y-T-D Expended 2,511,478 90,326 2,601,804 118,617 40,527 150 2,412,446 197 17,690 12,177 2,601,804 2,601,804 2,601,804 2009 Budget 3,981,744 214,348 4,196,092 244,027 71,799 1,200 3,819,121 610 26,535 32,800 4,196,092 4,196,092 4,196,092 66.6% 33.3% Unexpended Balance 1,470,266 124,022 1,594,288 125,410 31,272 1,050 1,406,675 413 8,845 20,623 1,594,288 1,594,288 1,594,288 Completed Remaining Unexpended Percent 36.9 57.9 38.0 51. 4 43.6 87.5 36.8 67.7 33.3 62.9 38.0 38.0 38.0 09/09/2009 8 Months 66.6% Completed 10:11:02 VILLAGE OF MOUNT PROSPECT 4 Months 33.3% Remaining FRRDBROl SUM031 Department Budget Expenditure Summary 01/01/09 - 08/31/09 Cur Mo Y-T-D 2009 Unexpended Unexpended PUBLIC WORKS - VEHICLE MAl NT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 VEHICLE MAINTENANCE ADMIN 12,579 110,009 189,625 79,616 42.0 02 VEHICLE MAINTENANCE PROGRAM 135,424 968,310 1,482,057 513,747 34.7 Totals 148,003 1,078,319 1,671,682 593,363 35.5 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 64,738 519,894 737,906 218,012 29.5 51 EMPLOYEE BENEFITS 35,474 179,634 239,272 59,638 24.9 52 OTHER EMPLOYEE COSTS 0 1,673 2,315 642 27.7 54 CONTRACTUAL SERVICES 9,255 75,403 88,017 12,614 14.3 55 UTILITIES 51 492 1,090 598 54.9 57 COMMODITIES & SUPPLIES 38,485 299,774 599,037 299,263 50.0 59 OTHER EXPENDITURES 0 0 0 0 65 OFFICE EQUIPMENT 0 0 545 545 100.0 67 OTHER EQUIPMENT 0 1,449 3,500 2,051 58.6 Totals 148,003 1,078,319 1,671,682 593,363 35.5 SOURCE OF FUNDS 660 VEHICLE MAINTENANCE FUND 148,003 1,078,319 1,671,682 593,363 35.5 Totals 148,003 1,078,319 1,671,682 593,363 35.5 18 09/09/2009 10:11:02 FRRDBROl SUM031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 08/31/09 COMMUNITY SERVICE PROGRAMS Cur Mo Expended PROGRAM TOTALS 02 COMMUNITY GROUPS & MISC 03 4TH OF JULY & CIVIC EVENTS,ETC 04 HOLIDAY DECORATIONS 05 BLOOD DONOR PROGRAM 3,747 25,118 604 272 Totals 29,741 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 10,851 1,820 8,602 8,468 o Totals 29,741 SOURCE OF FUNDS 001 GENERAL FUND 29,741 Totals 29,741 19 Y-T-D Expended 90,112 145,670 20,950 1,736 258,468 75,976 10,063 132,928 39,501 o 258,468 258,468 258,468 2009 Budget 138,700 182,009 110,774 2,897 434,380 97,231 16,794 249,685 62,670 8,000 434,380 434,380 434,380 66.6% 33.3% Unexpended Balance 48,588 36,339 89,824 1,161 175,912 21,255 6,731 116,757 23,169 8,000 175,912 175,912 175,912 Completed Remaining Unexpended Percent 35.0 20.0 81.1 40.1 40.5 21. 9 40.1 46.8 37.0 100.0 40.5 40.5 40.5 09/09/2009 10:11:02 FRRDBROl SUM031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 08/31/09 CAPITAL IMPROVEMENT PROJECTS Cur Mo Expended PROGRAM TOTALS 01 VILLAGE IMPROVEMENTS & EQUIP 02 COMMUNITY IMPROVEMENT PROJECTS 03 DOWNTOWN REDEVELOPMENT CONST 04 FLOOD CONTROL PROJECTS 06 STREET IMPROVEMENT PROJECTS 09 MOTOR EQUIPMENT REPLACEMENT 10 COMPUTER REPLACEMENT 11 STATION 14 12 EMERGENCY OPERATION CENTER 13 PUBLIC WORKS EXPANSION 68,481 19,820 67,915 153,405 91,144 169,240 5,000 582,631 214,208 308,604 Totals 1,680,448 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 100,550 o 4,812 1,043,301 5,000 169,240 107,744 249,801 o o o Totals 1,680,448 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 116,100 1,105,443 67,915 63,345 153,405 o 169,240 5,000 Totals 1,680,448 20 Y-T-D Expended 165,300 28,815 242,700 663,453 2,067,121 1,270,915 121,613 1,968,940 662,875 701,651 7,893,383 788,898 62,554 5,647 2,794,191 121,613 1,270,915 164,490 2,685,075 o o o 7,893,383 965,825 221,914 3,333,466 242,700 1,073,497 663,453 o 1,270,915 121,613 7,893,383 2009 Budget 1,463,850 216,000 1,924,650 235,000 4,184,700 2,535,500 188,150 8,378,000 2,034,000 2,237,000 23,396,850 1,814,720 1,717,250 62,800 10,948,580 395,150 2,535,500 1,801,550 4,121,300 o o o 23,396,850 1,328,100 1,544,850 12,784,000 1,924,650 2,856,600 235,000 o 2,535,500 188,150 23,396,850 66.6% 33.3% Completed Remaining Unexpended Unexpended Balance Percent 1,298,550 187,185 1,681,950 -428,453 2,117,579 1,264,585 66,537 6,409,060 1,371,125 1,535,349 15,503,467 1,025,822 1,654,696 57,153 8,154,389 273,537 1,264,585 1,637,060 1,436,225 o o o 15,503,467 362,275 1,322,936 9,450,534 1,681,950 1,783,103 -428,453 o 1,264,585 66,537 15,503,467 88.7 86.7 87.4 -182.3 50.6 49.9 35.4 76.5 67.4 68.6 66.3 56.5 96 .4 91. 0 74.5 69.2 49.9 90.9 34.8 66.3 27.3 85.6 73.9 87.4 62.4 -182.3 49.9 35.4 66.3 09/09/2009 10,11,02 FRRDBROl SUM031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 08/31/09 DEBT SERVICE Cur Mo Expended PROGRAM TOTALS 02 DEBT SERVICE - PROPERTY TAXES 03 DEBT SERVICE - TAX INCREMENT 04 DEBT SERVICE - H/R SALES TAX 1 06 SPECIAL SERVICE AREA B & I Totals EXPENDITURE CLASSIFICATION 59 OTHER EXPENDITURES 71 BOND PRINCIPAL 72 INTEREST EXPENSE 73 BANK AND FISCAL FEES 80 INTERFUND TRANSFERS 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 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 283,873 o 326,322 o o 610,195 o o o o o o 265,053 344,092 1,050 o o 610,195 o o o o o o o o o o o o 83,320 200,553 o o o o o 326,322 o o o 610,195 2009 Budget 66.6% 33.3% Completed Remaining Unexpended Unexpended Balance Percent 1,291,848 o 613,354 o 1,905,202 1,225,219 678,783 1,200 o 1,905,202 o 381,340 910,508 o o o o o 613,354 o o 1,905,202 1,007,975 o 287,032 o 1,295,007 o o 960,166 334,691 150 o 1,295,007 o 298,020 709,955 o o o o o 287,032 o o 1,295,007 78.0 46.8 68.0 78 .4 49.3 12.5 68.0 78.2 78.0 46.8 68.0 09/09/2009 8 Months 66.6% Completed 10:11:02 VILLAGE OF MOUNT PROSPECT 4 Months 33.3% Remaining FRRDBROl SUM031 Department Budget Expenditure Summary 01/01/09 - 08/31/09 Cur Mo Y-T-D 2009 Unexpended Unexpended RETIREE PENSIONS Expended Expended Budget Balance Percent PROGRAM TOTALS 01 MISCELLANEOUS PENSIONS 3,800 30,393 46,500 16,107 34.6 02 POLICE PENSIONS 270,460 2,069,704 2,993,500 923,796 30.9 03 FIRE PENSIONS 251,308 1,989,140 2,951,500 962,360 32.6 Totals 525,568 4,089,237 5,991,500 1,902,263 31.7 EXPENDITURE CLASSIFICATION 53 PENSION BENEFITS 525,568 4,087,067 5,984,500 1,897,433 31.7 54 CONTRACTUAL SERVICES 0 2,170 5,000 2,830 56.6 57 COMMODITIES & SUPPLIES 0 0 2,000 2,000 100.0 Totals 525,568 4,089,237 5,991,500 1,902,263 31.7 SOURCE OF FUNDS 001 GENERAL FUND 3,800 30,393 46,500 16,107 34.6 710 POLICE PENSION FUND 270,460 2,069,704 2,993,500 923,796 30.9 720 FIRE PENSION FUND 251,308 1,989,140 2,951,500 962,360 32.6 Totals 525,568 4,089,237 5,991,500 1,902,263 31.7 22 09/09/2009 10:11:02 FRRDBROl SUM031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 08/31/09 8 Months 4 Months 66.6% 33.3% Completed Remaining Totals Cur Mo Y-T-D 2009 Unexpended Unexpended Expended Expended Budget Balance Percent 32,429 1,024,882 967,700 -57,182 -5.9 432,168 3,310,079 5,705,136 2,395,057 42.0 464,597 4,334,961 6,672,836 2,337,875 35.0 RISK MANAGEMENT PROGRAM TOTALS 01 CASUALTY & PROPERTY INSURANCE 02 MEDICAL INSURANCE EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 56 INSURANCE 67 OTHER EQUIPMENT Totals 0 0 15,000 15,000 100.0 464,597 4,334,961 6,630,336 2,295,375 34.6 0 0 27,500 27,500 100.0 464,597 4,334,961 6,672,836 2,337,875 35.0 SOURCE OF FUNDS 690 RISK MANAGEMENT FUND 464,597 4,334,961 6,672,836 2,337,875 35.0 Totals 464,597 4,334,961 6,672,836 2,337,875 35.0 23 09/09/2009 10:11:02 FRRDBROl SUM031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 08/31/09 NON-DEPARTMENTAL Cur Mo Expended 2009 Budget Y-T-D Expended PROGRAM TOTALS 01 CONTINGENCIES o o Totals o o EXPENDITURE CLASSIFICATION 80 INTERFUND TRANSFERS o o Totals o o SOURCE OF FUNDS 001 GENERAL FUND o o Totals o o 24 66.6% 33.3% Completed Remaining Unexpended Unexpended Balance Percent o o o o o o o o o o o o 09/09/2009 10:11:02 FRRDBROl SUM031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 08/31/09 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 2009 Budget o o o o o o o o o o o o 66.6% 33.3% Completed Remaining Unexpended Unexpended Balance Percent o o o o o o o o o o o o 09/09/2009 10:11:02 FRRDBROl SUM031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 08/31/09 MOUNT PROSPECT LIBRARY Cur Mo Expended Y-T-D Expended Unexpended Unexpended Balance Percent PROGRAM TOTALS 02 LIBRARY SERVICES o Totals o EXPENDITURE CLASSIFICATION 90 COMPONENT UNIT EXPENDITURES o Totals o SOURCE OF FUNDS 950 MOUNT PROSPECT LIBRARY FUND o Totals o 26 2009 Budget o 9,450,626 o 9,450,626 o 9,450,626 o 9,450,626 o 9,450,626 o 9,450,626 66.6% Completed 33.3% Remaining 9,450,626 100.0 9,450,626 100.0 9,450,626 100.0 9,450,626 100.0 9,450,626 100.0 9,450,626100.0 REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY SEP082009 14:16 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AOGUST 27 2009 TO SEPTEMBER 09 2009 ............................................... --.......................... -_............................. --.................. --............................ ---................................................. --... --..................... ---... ---- --.. ----... --............. --......... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOONT ............................... --.................................................................................................... --............................. --................................................... --........................................................ -- --.. -- -..... --.. --........... )01 09146 ADI 1 SWI PE CARD READER 180.80 09380 AMERICAN BUILDING SERVICES TRACK FOR BI -FOLD DOOR 55.62 01561 AMERICAN CHARGE SERVICE SENIOR TAX PROGRAM 27.00 01620 AMERICAN LANDSCAPING INC. INV#2D09-1886 932 GREENFIELD 132.00 INV#2009-1885 1 S.ALBERT 132.00 INV#2009-1882 1206 ROBIN 132.00 INV#2009-1881 1714 VERDE 132 .00 INV#2009-1884 1826 E.CAMP MCD 132.00 INV#2009-1883 1758 CARIB 198.00 INV#2009-1880 121 WAVERLY 132.00 INV#2009-1879 216 S.OWEN 13 2.0 0 ..------------ 1122.00 01840 ANDERSON PEST SOLUTIONS INV#1163760 908 PECOS LANE 75.00 INV#1164845 2916 S.BRIARWOOD 75.00 INV#1166167 908 PECOS LANE 45.00 INV#1167123/ 109 EASTWOOD 75.00 INV#1167644/ 1000 WESTGATE 75.00 ------------- 345.00 00372 ANDLER, GLEN REIMB EXP JAN09-AUG09 42.99 REIMB EXP JAN09-AOG09 232.33 REIMB EXP JAN09-AUG09 142.18 REIMB EXP JAN09-AUG09 150.88 REIMB EXP JAN09-AUG09 9.40 REIMB EXP JAN09-AUG09 13 4.0 0 ..---.....--..---- 711.78 11699 ANDRADE, CONSUELO REIMB I1 APA CONF 9/24-9/25/09 260.00 11257 ANGAROLA, MI CHAEL REIMB EXP 8/25-8/27/09 24.00 02108 ARLINGTON POWER EQUIPMENT TUNE-UP FOR CHAIN SAW 54.20 10290 ARROWHEAD SCIENTIFIC INC. ET SUPPLIES 127 .00 02270 AT&T SERVICE 08/16/09-9/15/09 3.24 SERVICE 08/16/09-9/15/09 10.79 SERVICE 08/16/09-9/15/09 2.16 SERVICE 08/16/09-9/15/09 3.24 SERVICE 08/16/09-9/15/09 21.57 SERVICE 08/16/09-9/15/09 10.79 SERVICE 08/16/09-9/15/09 40.97 SERVICE 08/16/09-9/15/09 10.79 SERVICE 08/16/09-9/15/09 16.18 SERVICE 08/16/09-9/15/09 28.05 SERVICE 08/16/09-9/15/09 8.63 SERVICE 08/16/09-9/15/09 8.63 SERVICE 08/16/09-9/15/09 38.83 :EPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY SEP082009 14: 16 RELEASE I D : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 27 2009 TO SEPTEMBER 09 2009 -.. - -............ ---.. -............ ---................... -- ---.... --........................................ -.. --................ --.. --...... -- --...... --..................................... ----.................. --.............. -_.. DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ................ ........ -.............................-.......... -- --........................................................ -............... ---- ---................................ --.. --............................- --- -- -- --.............. SERVICE 08/16/09-9/15/09 218.97 SERVICE 08/16/09-9/15/09 214.65 SERVICE 08/16/09-9/15/09 138 . 07 SERV 8/16/09-9/15/09 331.78 -------..----- 1107.34 02270 AT&T LONG DISTANCE ACCT#857502328 0.13 11719 ATKINS, KELLY REFUND BUILDING PERMIT 109.00 05044 AVIS RENT A CAR SYSTEM TAC UNIT LEASE-JULY09&AUGUST09 195 6.18 10128 BALDINI, CAROL REIMB EXP 8/4/09 265.71 00435 BEACH, JUSTIN REIMB EXP 7/26-7/31/09 220.00 REIMB EXP 8/12-8/14/09 24.00 REIMB EXP 7/20-7/24/09 40.00 ------------- 284.00 05339 BOUND TREE MEDICAL, LLC Paramedic Equipment Pads, 513.82 02945 BRISTOL COURT SPECIAL EVENTS COMMISSION 2000.00 00474 BROWN, STEVE REIMBURSEMENT FOR RENEWAL OF C 50.00 01008 BUSSE I S FLOWERS & GIFTS FLOWER-CC . CENTER 70.00 01014 CADE INDUSTRIES CARPET RUNNERS-CC. CENTER 125.90 11697 CARINGELLA, SANTINO REAL ESTATE TAX REBATE 09 850.00 11706 CASEY, RICHARD J. REAL ESTATE TAX REBATE 1120.00 01049 CDW GOVERNMENT, INC 12 BELKIN UNIV 15FT EXT.CORDS 101.98 3 Digital Cameras for Vehicles 427 . 67 SHIPPING 0.04 -..-----...----- 529.69 05375 CENTURY CLEANERS UNIFORM CLEANING 6/4-8/20/09 764.85 07281 CL GRAPHICS, INC. SCHOOL CRISIS PLAN/STAFF CARDS 113.06 CREDIT#48800 10.00- ....---....--..--- 103.06 03800 CLARK, SANDRA M. REIMB FEE PAID SAMPLING OF DED 15.00 01147 COMMONWEALTH EDISON ACCT#0191054001 21.76 01218 DAHLBERG, JOHN REIMB EXP MEETING8/18,23,24/09 166.39 10554 DALLAS, MICHAEL EMERGENCY EQUIP. -CC CENTER 70.85 EMERGENCY SUPPLIES-CC.CENTER 15.34 ---.......------- EPORT: APBOARDRPT GENERATED: 15 APR 09 n:42 RUN: TUESDAY SEP082009 14:16 RELEASE I D : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 27 2009 TO SEPTEMBER 09 2009 -........................................... -- --........ -- --.............-.........................-.............................. --........................................ --............. --.. --... --......... --.. --............. ---............ DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .................................................... --............. --........ --..................... --........................................................ --.. --................................................ -- ---.............. --.. --............ 86.19 01233 DATA MEDIA PRODUCTS, INC. 50 SONY MINI CASSETTES 213.02 11696 DAVIS, DONALD REFUND OVER PYMT P#3885783 20.00 03916 DECATUR ELECTRONICS, INC. RADAR REPAIR/LABOR/CERTIF. 840.00 01253 DES PLAINES GLASS COMPANY 4-1" TEMPERED INSULATING UNITS 1705.00 09653 ETERNO, DAVID G. ADMIN HEARING -08/09 262.50 10393 EXPERTPAY PAYROLL FOR - 082709 3097.62 n212 FDC DIGITAL IMAGING SOLUTIONS SERVICE AND MAINTENANCE AGREEM 118.0 0 01377 FEDERAL EXPRESS CORP COURIER SERVICES 2009 64.60 DELIVERY CHARGES 08/11/09 58.42 ---...-..------- 123.02 00102 FIRE PENSION FUND PAYROLL FOR - 082709 21270.99 n720 GARZA, GABRIEL REFUND OVER PYMT-LANDLORD T. 120.00 09198 GE CAPITAL CD ADMIN 8/15/09-9/14/09 192.74 CD BUILDING 8/15/09-9/14/09 192.74 CD HOUSING 8/15/09-9/14/09 192.74 CD HEALTH 8/15/09-9/14/09 192.74 ----.....------- 770.96 10451 GIL HERBARD GUNS, INC. AMMUNITION 2874.00 n725 GOLDYN, RAFAL REFUND PYMT MADE TO ARMOR COL. 575.00 01522 GRAINGER INC. EMERGENCY EQUIP-WEATHER RADIO 49.00 WALL MIRRORS&PADDOCKS LOCKERS 228.51 ---..---..............- 277.51 06420 GRAYBAR ELECTRIC CO. FUSES FOR FLUKE METER 60.10 n695 GUTOWSKI, MICHAEL REFUND OVER PYMT P#3880867 20.00 09876 HAMPTON INN AT U OF I LODGING 8/3-8/7/09 & 8/24/09 876.90 01559 HANSEN INFORMATION TECHNOLOGY QUARTERLY MAINT .12/1-2/28/10 11700.00 09113 HEALY ASPHALT COMPANY,LLC. PATCHING MATERIALS #19403MB 61.20 PATCHING MATERIALS #19430MB 21. 42 PATCHING MATERIALS #19453 40.80 PATCHING MATERIALS #19502MB 48.96 PATCHING MATERIALS #19532MB 21. 93 --------...---- 194.31 PORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY SEP082009 14: 16 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 27 2009 TO SEPTEMBER 09 2009 -............. -.... --........... ----.......... -_.............. --.. ---...... ---.. -- --- ---.... ---...... --...... ---...... --.............. -....... --.... -........ --...... --.. --....... --.. --..... -- --- -- -_......-- EPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ........ --.................. --.. --.. -- -- ---.. --................. --............ --.............................. --...... --....... --...... --.................................. -_.. --.... --.. ----......... -- --............... --.._- 11717 HEIDEMAN, RAYMOND REAL ESTATE TAX REBATE 318.00 01580 HENRICKSEN & COMPANY, INC. 1 WHITE FOLD DOWN EXPRESS DESK 336.00 01610 HOME DEPOT CREDIT SERVICES SUPPLIES FOR HAZMAT 15.05 GRINDING WHEEL/SHARPENING TOOL 14.74 REFRIGERATOR 539.10 ------------- 568 .89 11727 HORN, BARBARA A. REFUND PYMT MADE TO ARMOR COL. 500.00 09425 HSBC BUSINESS SOLUTIONS FOOD&WATER- 3DAYSB .CANCERWALK 100.47 MINI FRIDGE-FIRE ADMIN OFFICE 89.99 SALES TAX CREDIT 10.00- TV & HOUNT 478.98 TV & MOUNT 478 .98 RETURN ONE MOUNT 78.99- WATER 3.67 FOOD&BEVERAGE-VILLAGE PICNIC 284.14 OFFICE COFFEE 27.38 ------------- 1374.62 01650 ICMA I CMA ANNUAL MEHBERSH I P DUE 175.00 10257 ICMA 401A PLAN PAYROLL FOR - 082709 3019.16 00107 ICMA RETIREMENT TRUST - 457 PAYROLL FOR - 082709 23182.53 00108 ILLINOIS DEPARTMENT OF REVENUE PAYROLL FOR - 082709 24879.42 O1ll9 ILLINOIS DEPT OF PUBLIC AID REFUND DUPLICATE PYMT 123.49 01690 ILLINOIS HOUSING DEV.AUTHORITY IHDA HOME WORKSHOP 9/15/09 30.00 10295 ILLINOIS STUDENT ASSISTANCE COMMISSION PAYROLL FOR - 082709 205.41 07433 IHAGETEC LP ID#90133770128 INV#52516805 356.00 ID#90133759827 INV#52520073 275.00 ID#90133770126 INV#52520054 275.00 ID#90133759828 INV#52516824 356.00 10#90133770131 INV#52513554 390.00 ----------.....- 1652.00 09562 IMRF PAYROLL FOR - 082709 411.63 PAYROLL FOR - 082709 38146.77 PAYROLL FOR - 082709 19309.44 ------------... 57867.84 11701 INSIDE THE TAPE REGISTER-R. NAVA&D .OLLECH&W. RYA 500.00 01744 INTERNATIONAL COUNCIL OF SHOPING CENTERS lYR MEMBERSHIP 2009-2010 50.00 09832 INTERNATIONAL UNION OF OPERATING ENGINEERS PAYROLL FOR - 082709 859.12 IEPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY SEP082009 14:16 RELEASE I D : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 27 2009 TO SEPTEMBER 09 2009 . -...... --- --......... --...... --............................................................... --... -- --.................................... --...................... --...... --............................................................................................ --..................... --.................. -... --...... --... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .-................................. -............................................... --............................................. --....................... ---............... --...... ---..................... -_............................. --....................................................................................... -- --... --...... PAYROLL FOR - 082709 249.48 ------------- 1108.60 01753 IPELRA REGISTRATION-ANNUAL CONF OCT09 375.00 09563 IRS PAYROLL FOR - 082709 188324.24 01758 ISFSI Membership/Truty Annual Dues 75.00 11709 JACK E. ENTER AND ASSOCIATES, INC 6 TEXBOOKS UPCOMING CLASS 129.70 00353 JANONIS, MICHAEL E. REIMB LUNCH MEETING 8/25/09 60.69 06874 JOHN DEERE LANDSCAPES SPRINKLER COUPLER 40.10 01783 JOURNAL & TOPICS NEWSPAPERS LEGAL NOTICE BID 8/2/09 13 3.3 8 05656 KANUPKE, JOSEPH REIMB EXP 8/17-8/21/09 17 4.8 5 11702 KINSELLA, JOHN REBATE 6 SQUARES PUBLIC WALK 294.00 05336 KLEINSTEIN, HOWARD EXTERNAL HARD DR.-AVID EDITING 141.10 BATTERIES 40.89 BATTERIES 13.09 ------...------ 195.08 01849 KUSTOM SI GNALS, INC. 4 PL3 8ATTERY RING RETAINERS 51.68 11716 LALA, JOSEPH REFUND DUPLICATE PYMT 63.00 01861 LANDS I END BUSINESS OUTFITTERS CLOTHING-ENV. HEALTH/HOUSING 42.50 CLOTHING EXP. -BUILDING DEPT 33.00 ------------- 75.50 11722 LAVACCH I, RI CHARD A. REFUND LANDLORD TENANT FEE 75.00 08325 LAW ENFORCEMENT EXECUTIVE DEVELOPMENT ASSOC. REGIST .FEE-LEEDA CONF OCT 09 125.00 08631 LECHNER AND SONS 2009 UNIFORM RENTAL AND CLEAN I 121.78 2009 UNIFORM RENTAL AND CLEANI 121.78 ------------- 243.56 01897 LIFE ASSIST Pulse Oximeter and Black Case 565.00 11723 LOZA, LUCAS OVER PYMT TICKET P#3889281 30.00 01918 LUNDSTROM I S NURSERY, INC. 2009 TURF MOWING CONTRACT 3529.94 2009 LANDSCAPE MAINTENANCE CON 2464.98 ------------- 5994.92 01941 MALCOLM, JOHN IMITATION OUT DOOR SECURITYCAM 49.72 IEPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TOESDAY SEP082009 14:16 RELEASE 1D : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 27 2009 TO SEPTEMBER 09 2009 ....... --............................................................... --....................... -- --.......... --.............................................................. -_.... --.......... --............ --- --.... --.... --......................... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .......... --.... -- ---........................................................................ --.. --........................ --... --.................. --..............- --.... --..... --.... --............ ...-_............................ --.... -- --.. 08698 MARTINEZ, MIGUEL REIMB EXP 8/24-8/26/09 24.00 11710 MCCARTHY I CHARLES J. REAL ESTATE TAX REBATE 570.00 11714 MCKILLOP, ROBERT & LOIS REAL ESTATE TAX REBATE 470.00 05021 MENARDS SUPPLIES 16.56 01502 MES- ILLINOIS Chopper Blades I Extinguisher, 672.00 S&H 12.66 ------------- 684.66 00116 METRO FEDERAL CREDIT ONION PAYROLL FOR - 082709 2417.92 00117 METROPOLITAN ALLIANCE - POLICE PAYROLL FOR - 082709 1039.00 08783 METROPOLITAN MAYORS CAUCUS MEMBERSHIP RENEWAL 1981.8 8 02826 MICHAEL WAGNER & SONS, INC. FLOW REGULATOR 56.38 10009 MID-AMERICAN SPECIALTIES INC ET SUPPLIES 237.62 11718 MIDWEST GLASS TINTERS INSTALLATION OF WINDOW FILM 400.00 02046 MOBILE PRINT INC. Note Pads for Uidl, Truty Busi 115.43 NAME PLATE-KIM SHEAGREN 33.95 N. PLATES-ANABEL, YESENIA&HUIZAR 101.86 VOLUNTEER STICKERS 62.08 NOT APPROVED LABELS 195.94 BUSINESS CARDS-LES HANNEMAN 26.19 ------......--...-- 535.45 02057 MORTON ARBORETOM REGISTRATION FEE-S. CLARK&D. HUL 338.00 08025 MORTON SUGGESTION CO. CRIME FREE HOUSING SOP PLIES 322.91 02064 MOTOROLA, INC. 3 CABLE SPEAKER 84.78 00123 NATIONWIDE MUTUAL INSURANCE COMPANY PAYROLL FOR - 082709 16578.76 05337 NATOA REPLACE CHECK#13013324 400.00 06389 NEMEROW, JASON REIMB EXP 8/24-8/26/09 24.00 02155 NEXTEL COMMUNICATIONS SERVICE 7/18/09-8/17/09 706.82 SERVICE 7/18/09-8/17/09 143.03 SERVICE 7/18/09-8/17/09 136.35 SERVICE 7/18/09-8/17/09 691.50 SERVICE 7/18/09-8/17/09 25.57 SERVICE 7/18/09-8/17/09 252.73 SERVICE 7/18/09-8/17/09 1129.56 SERVICE 7/18/09-8/17/09 240.00 SERVICE 7/18/09-8/17/09 261. 40 SERVICE 7/18/09-8/17/09 460.00 SERVICE 7/18/09-8/17/09 22.71 ~PORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY SEP082009 14: 16 RELEASE 10 : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 27 2009 TO SEPTEMBER 09 2009 - - - - -.......... --.......................................................................-........... --- ---...................................... --- --........ --.... ----................ --..............................................-- lEPT VENDOR NBR VE N DO R NAME INVOICE DESCRIPTION AMOUNT -................................................................ ......................................... --................ ---................................... --......... --............ --...............................-................................ SERVICE 7/18/09-8/17/09 330 .83 ------------- 4400.50 05256 NICOR ACCT#03- 35-77-9926-5 26.95 ACCT#97-78-90-2800-4 26.98 ACCT#60761400005 173.29 ACCT#690226000006 135.46 ACCT#29072700007 48.93 ------------- 411.61 02165 NIPSTA Registration/Skindingsrude, Sc 300.00 02170 NORTH EAST MULTI REGIONAL TRNG REGISTER -M.MEISTER 7/23-24/09 300.00 05843 NORTH SHORE OMEGA FITNESS DUTY EXAM: J. FOLEY 192.00 10497 NORTHWEST CENTRAL 9-1-1 SYSTEM PA SYSTEM REPAIR FOR ST#14 105.61 02189 NORTHWEST CENTRAL DISPATCH SYS OCTOBER 09 MEMBER ASSESSMENT 39558.70 OCTOBER 09 MEMBER ASSESSMENT 9889.68 ------------- 49448.38 10498 O'SHEA, CLARE REIMB.CONF REGIST .FEE SEPT 09 260 .00 10162 OVERHEAD GARAGE DOOR, INC. REPAIRS TO WEST DOOR-P .SAFETY 5B5.00 10476 PACIFIC TELEMANAGEMENT SERVICES PAY PHONE SERV. SEPT 2009 78.00 02256 PADDOCK PUBLICATIONS INC ADS-KIDS DAY@FARMERS MARKET 557.20 10366 PARK RIDGE TAXI SENIOR TAXI PROGRAM 77.80 11708 PENN CAMERA EXCHANGE 6 DIGITAL EVIDENCE BAGS 130.80 02305 PETTY CASH - PUBLIC WORKS TRAVEL & SUPPLIES 4.80 TRAVEL & SUPPLIES 53.86 ------------- 58.66 09021 PITNEY BOWES ANNUAL MAINT. AGREEMNT-FOLDING 1382.00 00124 POLICE PENSION FUND PAYROLL FOR - 082709 27380.01 04921 POPE, ELIZABETH A. PAYROLL FOR - 082709 92 3.0 8 10258 POWELL TREE CARE, INC. 2009 PARKWAY TREE REMOVAL CONT 1770.00 2009 PARKWAY TREE REMOVAL CONT 1679.00 ------------- 3449.00 10435 PROCESSWORKS, INC. FLEX AUGUST 09 688.75 ADMIN FOR MONTH OF AUGUST 09 50.00 ------------- 73 8.7 5 EPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY SEP082009 14:16 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 27 2009 TO SEPTEMBER 09 2009 ............... -_............ --.............................. --.............................................................................. -_........................... ---........... -- --........... --........................................................ ---... --......................................................................-- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ................................. --..................... --......................... --................ --............................... --...................................... --............... -- -- --....................................... ---...................... --.............................. --................. --... 11726 PRODANOV, JASON A. REFUND PYMT MADE TO ARMOR COL. 250.00 11694 RAMIREZ, KRISTIAN REFUND OVER PYMT mOO78 30.00 02444 RIVER TRAILS PARK DISTRICT FAMILY BIKE RIDE SHIRTS 684.00 09423 RONCO INDUSTRIAL SUPPLY SHELVING FOOD PANTRY&COMP AREA 1655.48 00425 RZEPECKI, ROBERT L. REIMB EXP HEAT OPERATION 9/1 80.00 10452 SAEWERT, JANET REIMB IL APA CONF 9/24-9/25/09 260.00 04052 SCHROEDER & SCHROEDER INC 2009 SIDEWALK PROGRAM 11442.61 27511.19 ------------- 38953.80 09058 SELEEN, WENDY REPLACE CHECKmOl0558 24.68 11728 SERRANO, DAVID REFUND PYMT MADE TO ARMOR COL. 500.00 05975 SIGNS BY TOMORROW WINDOW CLINGS 125 215.50 BANNER SAMPLES 80.00 ------------- 295.50 10715 SIMMONS, BRIAN REIMB CONF REGIST. FEE SEPT09 260.00 11707 SMORCZEWSKI, LISA & JACK REAL ESTATE TAX REBATE 400.00 02583 SOUND INCORPORATED CC.CENTER PHONE &PANIC BUTTONS 4876.00 06002 SOUTHERN ILLINOIS UNIVERSITY AT EDWARDSVILLE REGISTRATION-C.O'SHEA 10/19-21 595.00 0413 9 STANARD & ASSOCIATES PRE-EMPLOYMENT EXAM-WNEK, P. 375.00 09165 STAPLES BUSINESS ADVANTAGE 40 CARTONS OF PAPER 730.60 40 CARTONS OF PAPER 365. 30 40 CARTONS OF PAPER 365.30 -----...------- 1461.20 02627 STEINER ELECTRIC CO. STREET LIGHT REPAIR SUPPLIES 114.40 REPAIRS TO GENERATOR AT STATIO 203.80 -...----------... 318.20 00441 STRAHL, DAVID ADVANCE LODGING- IPELRA CONF 10 476.91 02660 SUBURBAN PRINTING FAMILY BIKE RIDE POSTERS 80.00 11721 THOMAS, ABRAHAM REFUND OVER PYMT- LANDLORD T 37.50 02691 THOMPSON ELEVATOR INSPECTIONS 1 SEMI -ANNUAL ELEVATOR INSPECT 37.00 11698 THOMPSON, DENISE N. PERFORMANCE-11/3/09 @MPPL 450.00 ;PORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY SEP082009 14:16 RELEASE 10 : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 27 2009 TO SEPTEMBER 09 2009 PAGE IEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION .... - -.. ~................................."'''''' ---........................................................................... ---.................... --........................... --................. --....................................................................... --.......... --- AMOUNT ... --................. ---.........................................................................-...................................................................-.............................................. --................................................................ 10925 TRANSYSTEMS CORPORATION RTA RQUISITION#12 SER THRU5/15 02717 TRAVIS SOUND INSTALLATIONS,INC REPAIRED TOA912 STATION#13 05686 ULINE INC. PHOTO STORAGE SUPPLIES 08526 ULTIMATE PLUMBING SUPPLY TOILET SEATS & PLUMBING SUPPLY 07526 UNITED PARCEL SERVICE MISC. SHIPPING-EQUIP. REPAIRS 00127 UNITED WAY PAYROLL FOR - 082709 04025 UNIVERSITY OF ILLINOIS - GAR REGI STER-J . KANUPKE 11724 VELASQUEZ, JOEL REFUND PYMT MADE TO ARMOR COL. 02802 VILLAGE OF ARLINGTON HEIGHTS Registration/Wnek, Philip - FF 00128 VILLAGE OF MOUNT PROSPECT PAYROLL FOR - 082709 SEMINAR-K. SHEAGREN IN. PERSINO PAYROLL FOR - 082709 04314 VILLAGE OF MOUNT PROSPECT - PAYROLL WIRES PAYROLL FOR - 082709 02835 WAREHOUSE DIRECT MISC OFFICE SUPPLIES AND TONER SUPPLIES SUPPLIES 10974 WDCB PUBLIC RADIO-UNDERWRITING RADIO SPOTS FOR BLUES FEST 09 06001 WINKLER I S TREE SERVICE 2009 PARKWAY TRIMMING CONTRACT 2009 PARKWAY TRIMMING CONTRACT 05746 PAYROLL FOR - 082709 WISCTF 11711 ZALEWSKI, PETER REFUND OVER PAYMENT 11705 ZBOROWSKA, ZOFIA REBATE 5 SQUARES PUBLIC WALK TOTAL 616207.81 245.00 02270 SERVICE 08/16/09-9/15/09 AT&T 01008 BUSSE I S FLOWERS & GIFTS SYMPATHY FLORAL ARRANGEMENT - 01990 MCMASTER-CARR SUPPLY CO. DRAIN PLUGS FOR LEAF MACHINES 11715 NELSON, CHRISTOPHER REFUND FINAL UTILITY BILL 7414.76 135.00 84.18 69.75 27.75 492.75 629.00 125.00 2000.00 22247.73 60.00 11868.54 34176.27 811.86 967.63 124.87 16 7.0 8 125 9.5 8 336.00 16228.69 11410.42 27639.11 542.48 27.00 4.31 73.50 115 .3 0 12.50 ~PORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY SEP082009 14:16 RELEASE 10 : PAGE 10 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 27 2009 TO SEPTEMBER 09 2009 - - - -...................... ---............. -- --.. --.. ...-..- --.. --.. --.. --............... -.................................... --........ -- --................. --......................... ---............... --... --....................... ---.......... --..-.. )EPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT -.......................... ---........ --.. ----- --........ --..... --.................... --.. ---................................................................... --.. --................. --.............. ---................... ---.. ---.. --.............. --... ---- TOTAL : 205.61 iO 05709 MEADE ELECTRIC CO. INC. 2009 TRAFFIC SIGNAL MAINTENANC 1145.00 05211 STATE TREASURER TRAFFIC SIGNAL MAINTENANCE 4/0 5118 .51 11677 TRAFFIC CONTROL CORPORATION SOFTWARE UPGRADE TO ASC/2 450.00 TOTAL 6713.51 )0 09198 GE CAPITAL CDBG 8/15/09-9/14/09 192.74 04434 GEWALT HAMILTON ASSOCIATES, INC. CONTRACT FOR ENGINEERING 9503.00 11014 LEAD INSPECTORS, USA INC INSPECTION-I02 N . OWEN 275.00 07502 LYONS & PINNER ELECTRIC COMPANIES CONSTRUCTION CONTRACT FOR 45895.82 10452 SAEWERT, JANET REIMB EXP CDBG TRAVEL&MEETINGS 30.36 TOTAL 55896.92 l5 01049 CDW GOVERNMENT, INC MICROSOFT SQL SERVER 2008 STAN 3570.88 TOTAL 3570.88 to 04434 GEWALT HAMILTON ASSOCIATES, INC. KENSINGTON RD IMPROVEMENT PT#2 28760.00 TOTAL 28760.00 ?8 01148 COMMONWEALTH EDISON FACILITIES CHARGE UPGRADE SERV 31657.28 10238 ECS ILLINOIS, LLC MATERIALS TESTING ST#14 SITE 1082.50 11496 HORIGAN URBAN FOREST PRODUCTS, INC MILL AND KI1N DRY RECLAIMED AS 3015.00 11255 LEO PARDO COMPANIES, INC Fire Station 14 - Construction 482394.00 Modifications at Public Works 275822.00 EOC - Construction 188867.00 -......_--------- 947083.00 06406 SRBL ARCHITECHTS, LTD. Architectural Services for Fir 10089.93 Architectural Services for Pub 498 D.6 8 Archi tectural Services for the 748 3.6 5 ----...._------ 22554.26 08569 TESTING SERVICE CORP MATERIALS TESTING @ FIRE ST# 14 13474.00 MATERIALS TESTING @ EOC SITE 8419.25 ------------- 21893.25 EPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY SEP082009 14:16 PAGE 11 RELEASE 10 : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 27 2009 TO SEPTEMBER 09 2009 .... - - - - -........... -- -.... -.. -.......... --............ - -... -............ --.. - -.... - - - - -................................. -.... --.............. -.. - - - -.. - - - - - -.... -.......... -- - -................. --........................... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - -... -... - - - ---.. - -.. -...... --.... --.. - -.. --........ - - - -.... -........................ -.. - --.... -.. - - - - -.. -- -..... - -.. --....................................... -- --.... --.. --.. ---........ --........ --...- TOTAL : 1027285.29 50 07730 ADVANCED PAVEMENT TECHNOLOGIES 2009 BRICK PAVER SEALING CONTR 11628.78 01918 LUNDSTROM I S NURSERY, INC. 2009 LANDSCAPE MAINTENANCE CON 5305.05 TOTAL 16933.83 60 04493 A LAMP CONCRETE 2009 STREET RESURFACING CONTRA 2739.80 08659 NAFISCO INC 2009 NEIGHBORHOOD TRAFFIC SIGN 2245.38 TOTAL 4985.18 10 11445 AMERICAN PIPE LINERS INC 2009 CIPP PROJECT 232453.58 02270 AT&T SERVICE 08/16/09-9/15/09 288.00 10540 BATTERIES PLUS BATTERY SUPPLY - VARIOUS SIZES 143.50 05773 BAXTER & WOODMAN, INC. ENGINEERING SERVICES FOR 2009 8211.62 ENGINEERING SERVICES FOR 2009 8211.61 ENGINEERING SURVEY AND SUBSURF 236.00 ------------- 16659.23 01049 CDW GOVERNMENT, I NC REPLACMENT USB CABLE 4.00 09682 CE DESIGN,LTD. BIDDING SERVICES FOR PROSPECT 14427.18 05375 CENTURY CLEANERS UNIFORM CLEANING 6/4-8/20/09 764.85 01147 COMMONWEALTH EDISON ACCT#05040 140000 39.36 ACCT#0123132132 28.03 ACCT#0984158009 42.11 ACCT#0753122039 35.63 ACCT#03000699050 339.10 ACCT#0981004004 35.99 ACCT#0018021059 28.63 ACCT#1074086017 392.40 ACCT#O 144035012 32.77 ACCT#4475624003 25.88 ACCT#O 774 0 170 15 456.10 ACCT#0228061 02 3 496.84 ACCT#0144070011 40.70 ACCT#0630089039 254. ]7 ------...--.......- 2247.71 08829 ENGLEWOOD ELECTRICAL SUPPLY 855 SMART BENDER 8350.00 DELUXE PENDANT REMOTE CONTROL 1020.00 TRANSP CHARGE 17.50 -----------.... ;PORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY SEP082009 14:16 PAGE 12 RELEASE I D : VILLAGE OF MOUNT PROSPECT LIST OF B111S PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 27 2009 TO SEPTEMBER 09 2009 -..... -............... --...... ---.. --.................. ---............... --...................... --............. --......... --.. -......... --.................. --........................ --...... ----- --............... -- --......... -_...... lEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT -..................... ---........ --............. --...... --............ --................... --..... --................... --.... --......................... ---.......... --........................ --.. --.... --_............... ---............. 9387.50 11700 GARllNSKI, MARIAN REFUND FINAL UTILITY BILL 68.09 01544 HBK WATER METER SERVICE WATER METER TESTING SERVICES 119.00 BUILDING INSPECTION SERVICES 1449.80 ------------- 1568.80 08631 LECHNER AND SONS 2009 UNIFORM RENTAL AND CLEANl 121.78 2009 UNIFORM RENTAL AND CLEANl 121. 78 ------------- 243.56 01918 LUNDSTROM I S NURSERY, INC. 2009 TURF MOWING CONTRACT 381.90 01965 MARTAM CONSTRUCTION CURB REPLACE-COMB.SEWER REPAIR 9642.00 11185 MATICH, LOUIS REPLACE CHECK#13012319 17.57 02002 METRON-FARNIER, LLC 3" ENCODED USG WATER METER WIT 1739.90 10155 MIDAMERICAN TECHNOLOGY, INC. REPAIRS TO LOCATING EQUIPMENT 570.00 11715 NELSON, CHRISTOPHER REFUND FINAL UTILITY BILL 59.52 02155 NEXTEL COMMUNICATIONS SERVICE 7/18/09-8/17/09 578.56 SERVICE 7/18/09-8/17/09 42.52 ------------- 621.08 05256 NICOR ACCT#94322600001 88.88 ACCT#75532700004 76.84 ACCT#63019600004 76.79 ------------- 242.51 04856 NORLAB, INC. 2 CASES-LIQUID YELLOW TRACING 409.20 11623 R.A. MANCINI, INC 2009 SPOT RELAY PROJECT 15727 . 81 2009 SPOT RELAY PROJECT 15728.19 BALANCE OF PYMT#2 PO#S009468 1570.31 FINAL PAYMENT#3 4528.70 -------..----- 37555.01 08624 RAINBOW ELECTRIC CO. REPLACE MOTOR PUMPff2 1450.00 REPLACE FAN MOTOR-STATION#16 508.96 ------------- 1958.96 02538 SEWER EQUIPMENT CO. OF AMERICA TV TRUCK CAMERA REPAIR 475.18 11703 SHAMOON, DANNY/MARIE REFUND FINAL UTILITY BILL 37.15 02655 SUBURBAN LABORATORI ES, INC. ANNUAL CONTRACT FOR WATER SAMP 507.00 :PORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY SEP082009 14: 16 RELEASE 10 : PAGE 13 IEPT VENDOR NBR . - - - --........ -... -........................... --........................... --......... ---............... --............... --....................... --.............................. --.................. -- --....................................... --... --................................................................... ...-- AMOUNT VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 27 2009 TO SEPTEMBER 09 2009 VENDOR NAME INVOICE DESCRIPTION 09789 .................................. -...................................................... --......................................... --........ --- --................................. ---...... --........... -- --..... --.......................................................... --......... --.......................................... 990.00 11209 02835 11704 ,0 01147 05256 ,0 02796 02108 02270 02938 02940 01049 09610 09166 08154 07276 01750 SULLIVAN ROOFING REPAIR BOOSTER STATION #4 ROOF UNITED UTILITIES, INC 73 PIT AMR MODULES - TO REPLA WAREHOUSE DIRECT MISC OFFICE SUPPLIES AND TONER WILLIAMS, BETH REFUND FINAL UTILITY BILL TOTAL 33650Q. 58 12.38 COMMONWEALTH EDISON ACCT#4475767003 ACCT#4447577000 NICOR ACCT#240 61600003 TOTAL 446.58 81.19 ALPHA PRIME COMMUNICATIONS CELL PHONE HOLSTERS ARLINGTON POWER EQUIPMENT BASKET FUEL TANK G-40GENERATOR HEDGE TRIMMER REWIND STARTER AT&T SERVICE 08/16/09-9/15/09 BOWMAN DISTRIBUTION CENTER VEHICLE REPAIR & REPLACE PARTS VEHICLE REPAIR & REPLACE PARTS BRAKE ALIGN PARTS & SERVICES U-JOINT-VEHI CLE# 272 8 COW GOVERNMENT, INC IOMEGA EGO ENCR USB 320GB HD CERTIFIED FLEET SERVICES, INC. VALVE & PUMP PARTS FOR VEHICLE TURN SIGNAL SWITCH - VEHICLE # CYLINDERS, INC. 8 YRD LIFT CYLINDER REBUILD GLOBAL EMERGENCY PRODUCTS HEADLIGHT VEHICLE#515-#AGI9786 CLUTH KIT VEHICLE#515-#AGI9829 HUB CAP KIT V#518-#AGI9693 INV#AGI9810 CREDIT#AGI9871 RETURN#AGI9810 HARRINGTON IND. PLASTICS, INC. FUEL TANK FILL HOSE - VEHICLE INTERSTATE BATTERY REPLACEMENT BATTERIES: P-l&#324 2775.00 250.22 257.14 108.25 365.39 56.75 3.49 38.41 41.90 10.79 641.54 148.45 789.99 24.32 186.92 212.44 112.7 5 325.19 761.45 488.36 326.28 53.49 164.86 156.49- 876.50 114.3 9 160.90 ~PORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY SEP082009 14:16 RELEASE ID : PAGE 14 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 27 2009 TO SEPTEMBER 09 2009 ............. -...... ---........... ----................................................. --.................. --................. -- --........................... --...................................... --...... --............ ---................................................ lEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ............................ --........ --........... -............................... --......................................... --...... --........ -_.. --................. --_............ --........ ---.......... --...... --........ --............................................ -- --.........-- 06691 JUST TIRES #399453 REPLACE 2 TIRESV#4555 13 4.42 #399498 REPLACE 4 TIRES#4514 546.92 #399760 REPLACE 9 TIRES SQUADS 921.06 ----..-------- 1602.40 06855 KUSSMAUL ELECTRONICS AUTO EJECT#092159- 30-120ENGINE 410.08 01914 LUND INDUSTRIES, INC. STROBE LIGHTS - FIRE VEHICLE # 217.20 MARS LIGHTS CENTER ROTATORS FO 148.12 ------------- 365.32 02155 NEXTEL COMMUNICATIONS SERVICE 7/18/09-8/17/09 362 .43 SERVICE 7/18/09-8/17/09 25.5 7 --...-...-------.. 388.00 11290 PARENT PETROLEUM, INC 3- 55 GALLON ANTIFREEZE 743.85 02305 PETTY CASH - PUBLIC WORKS TRAVEL Ii SUPPLIES 115.28 01191 R. L. CORTY Ii COMPANY REPAIRS TO PRESSURE WASHER 198.00 02424 REX RADIATOR SALES Ii DISTRIBUTION, INC NEW RADIATOR FOR VEHICLE #2728 895.00 02581 SOLVENT SYSTEMS INT'L. INC. RENTAL OF PARTS WASHER 117.13 09217 WAYTEK, INC. TRAILER PLUGS Ii REPAIR PARTS 123.22 02870 WHOLESALE DIRECT INC. REPAIR OF LED LIGHT - SQUAD CA 47.29 02883 WIPECO INC 30 CASES - CUT POLO RAGS 907.00 11315 WOODFIELD CHEVROLET, INC INV#307706 BRAKE CABLE-V#502 28.74 INV#307320 ULATE BRACKET 15.17 INV#436205 REPAIRS S-41 155.80 ------------- 199.71 TOTAL 9461.38 10793 ' LIEBOVICH BROS, INC 25' ANGLE ALUMINUM FOR VEHICLE 13 7.0 0 ALUMINUM TUBE FOR FENDERS - 864.00 ------------- 1001.00 02569 R.G. SMITH EQUIPMENT CO. SUB FRAME EXT-V3HICLE#4528 85.00 HYDRAULIC GLAND NUT 156.64 ------------- 241.64 01229 W.S. DARLEY CO. Ventmaster ChainSaw and Raptor 2155.00 TOTAL 3397.64 :PORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY SEP082009 14:16 RELEASE ID : PAGE 15 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 27 2009 TO SEPTEMBER 09 2009 IEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 10 01335 ALEXIAN BROTHERS CORPORATE HEALTH SERVICES MICHAEL CHEN-DOI:8/ll/09 259.09 VICTOR PIERCE-DOl: 8/13/09 424.04 -----...------- 683.13 05082 AMG/AHHC (12) MICHAEL FELLOW-DOl 7/22/09 90.00 02070 ARLINGTON HEIGHTS FORD NEW RIM-ACCIDENT REPAIR P- 34 132.02 01102 GAB ROBINS N .A., INC - CITIBANK PAYMENT OF INS CLAIMS 8/26/09 645.05 09097 ILLINOIS STATE TREASURER W/C RATE ASSESSMENTl/H/30/09 2163.91 06691 JUST T I RES DAMAGED TIRE-ACCIDENT REPAIR 88.17 TOTAL 3802.28 '0 08178 GUARDIAN EMP DENTAL PLAN: SEPTEMBER 09 7696.95 TOTAL 7696.95 10 02689 THIRD DISTRICT CIRCUIT COURT BOND MONEY 8/27/09 1875.00 BOND MONEY 9/1/09 3785.00 BOND MONEY 9/3/09 1025.00 BOND MONEY 9/8/09 560.00 ------------- 7245.00 02886 WISCONSIN DEPARTMENT OF REVENUE WISC INCOME TAX AUGUST 09 230.69 TOTAL 7475.69 GRAND TOTAL 2129340.13 EPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY SEP082009 14:16 RELEASE ID : PAGE 16 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 27 2009 TO SEPTEMBER 09 2009 SUMMARY BY FUND 001 GENERAL FUND 616207.81 030 REFUSE DISPOSAL FUND 205.61 050 MOTOR FUEL TAX FUND 6713 .51 070 COMMUNITY DEVELPMNT BLOCK GRNT 55896.92 085 DEA SHARED FUNDS FUND 3570.88 510 CAPITAL IMPROVEMENT FUND 28760.00 528 SERIES 2009 CONST FUND 1027285.29 550 DOWNTOWN REDEVLPMNT CONST 16933.83 560 STREET IMPROVEMENT CONST FUND 4985.18 610 WATER AND SEWER FUND 336500.58 630 PARKING SYSTEM REVENUE FUND 446.58 660 VEHICLE MAINTENANCE FUND 9461.38 670 VEHICLE REPLACEMENT FUND 3397.64 690 RISK MANAGEMENT FUND 380 2.2 8 770 FLEXCOMP ESCROW FUND 7696.95 790 ESCROW DEPOSIT FUND 7475.69 -------------- TOTAL : 2129340.13 EPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY SEP082009 14: 16 PAGE REPORT PARAMETERS ORGANIZATION NO. : 001 STARTING CHECK DATE : 08/27/09 ENDING CHECK DATE : 09/09/09 STARTING BANK ENDING BANK SEGMENT NUMBER TO SORT BY : 01 STARTING ACCOUNT SEGMENT NUMBER: ALL ENDING ACCOUNT SEGMENT NUMBER : ALL RELEASE LEVEL Village of Mount Prospect List of Escrow Checks Presented to the Board of Trustees 09/09/09 To 09/09/09 1/08/09 lR025 Paid to Permit # 091730 090883 091337 091314 091174 081547 081907 091840 081646 ALLIED AC & HEATING CORP AMERICAN DRILLING AMERICAN NATIONAL SPRINKLER ANDERSON, MICHAEL ANZALONE, KIRSTEN AQUA PLUMBING SERVICES ARCHPRO DESIGN ATKINS, KELLY ATLAS RESTORATION BAZULA, ANDRZEJ 082630 BOCHENEK, JAN 091444 COMFORT MASTERS HTG & COOLING LLC 091625 CONCRETE CRAWLS PACES CORP 091652 061094 061095 061096 061097 061098 DISCOVERY HOMES/WALTER WYSZYNSKI EFFECTIVE AIR INC 081363 090447 090643 091105 091253 FLORES, PHILIP FORTIS CONCRETE CO INC FOUR SEASONS CARPENTRY 081141 FOUR SEASONS INC 091527 091700 FUERTE SYSTEMS INC 091096 091564 091739 HARNEY, ROGER JAMES HOFFMAN, WALTER HUNZINGER WILLIAMS INC 082796 J & S PLUMBING 081519 082866 090214 091260 091357 090942 091277 081153 080434 091177 090966 JEROME RATIGAN JRC CONSTRUCTION JSI LTD KARRAS, THANOS KEELEY CONSTRUCTION KEY SAC GROUP LEW, MARIUSZ LUCHECHKO (JOINT TENANTS), MARIA MAGIC IRRIGATION LLC MARIO GAMBINO & SONS LANDSCAPING IN nQl<IlQ Check # 13016931 13016932 Amount 125.00 150.00 13016933 500.00 200.00 13016934 13016935 13016936 200.00 125.00 850.00 500.00 125.00 13016937 13016938 13016939 13016940 13016941 13016942 13016943 13016944 13016945 13016946 13016947 13016948 1,125.00 150.00 75.00 125.00 450.00 500.00 500.00 500.00 500.00 2,450.00 * 13016949 13016950 13016951 13016952 13016953 125.00 75.00 200.00 150.00 75.00 425.00 * 13016954 13016955 13016956 75.00 75.00 125.00 200.00 * 13016957 13016958 13016959 13016960 125.00 200.00 125.00 125.00 25.00 150.00 950.00 13016961 13016962 13016963 13016964 13016965 13016966 13016967 13016968 13016969 13016970 13016971 1,000.00 200.00 1,000.00 125.00 450.00 525.00 500.00 100.00 1 <n1 F;q7? ?nn nn Page 1 9/08/09 MR025 Village of Mount Prospect List of Escrow Checks Presented to the Board of Trustees 09/09/09 To 09/09/09 Page 2 Paid to Permit # Check # Amount 300.00 * NORTON, ROBERT 091597 13016973 200.00 P & S CONCRETE PLUS 090507 13016974 200.00 PRECISION PLUMBING SERVICES INC 090207 13016975 125.00 PRO BUILDERS & CONSULTING 071250 13016976 725.00 RAIMAN, LEE 091264 13016977 200.00 SCHMIDT, MATHIAS H 091261 13016978 200.00 SHEEHAN, MICHAEL J 091348 13016979 200.00 SKOWRONSKI, ROBERT 091685 13016980 200.00 SKWIERCZYNSKI, LEROY 091740 13016981 125.00 THUER, MARK G 091255 13016982 150.00 US HOME CENTER 091142 13016983 135.00 VINYLGUARD INDUSTRIES 081685 13016984 125.00 WABIK, TOM 091484 13016985 200.00 ZAKRZEWSKI, RAFAL 080736 13016986 600.00 *** TOTAL NUMBER OF CHECKS 56 16,785.00