The URL can be used to link to this page

Home My WebLink About3. BILLS & FINANCIAL REPORT 08/18/2009 Mount Prospect INTEROFFICE MEMORANDUM Village of Mount Prospect Mount Prospect, Illinois TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM: FINANCE DIRECTOR DATE: AUGUST 14, 2009 SUBJECT: MONTHLY FINANCIAL REPORT - JULY 2009 Attached hereto are the cash position and investment statements of the Village for the month ended July 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 June 30 were $23.9 million. During July, cash receipts totaled $3,684,395.69. In addition investment income for the month was $15,855.48 and inflows due to Interfund activity generated $10,700.00. Reductions in cash and cash equivalents during July totaled $6,713,972.32. Of this amount, payments to vendors were $4,621,532.84, employee payroll and related expenses were $2,089,758.92 and other disbursements were $2,680.56. There was also a net increase in cash due to investment activities of $2,496,588.52. Cash and cash equivalents at July 31 were $23.4 million. Monthly Financial Report - July 2009 August 14, 2009 Page 2 Total investments at June 30 were $13.1 million. During the month, investments decreased $2,496,588.52 as a result of fewer CD's being placed. Four CD's matured and just two were purchased due to the low interest rates being offered. Total investments at July 31 were $10,580,630.74, Total cash and investments for Governmental and Enterprise Funds at June 30 were $37,016,865.09. Cash and investments at July 30 totaled $34,013,843.94. This is a decrease of $3,003,021.15 for the month. Trust and Agency Funds - Cash and cash equivalents at June 30 were $4.5 million. During July, cash receipts totaled $274,911.80. In addition investment income for the month was $135,883.06 and outflows due to Interfund activity totaled $10,700.00. There was also a net increase in cash due to investment activities of $1,090,638.29. Reductions in cash and cash equivalents during July totaled $615,826.12. Of this amount, payments to vendors were $186,188.36, employee payroll and related expenses were $405,983.98, payments related to the flexible spending program totaled $23,108.78 and other disbursements were $545.00. Cash and cash equivalents at July 31 were $5.4 million. Total investments at July 31 were $70,613,146.46, a decrease of $842,095.42 from June 30, 2009. There were investment gains of $248,542.87 and a transfer to cash of $1,090,638.29 that accounted for the change. Total cash and investments for Trust and Agency Funds at June 30 were $75,998,999.92. Cash and investments at July 31 totaled $76,031,811.53. This is an increase from the balance at June 30 of $32,811.61. Summary of Cash Activity by Fund Type (paae 2) This report provides a breakdown of the cash activity for the month broken down by fund type. This breakdown is useful in identifying where the activity (receipts and disbursements) is occurring. There are times during the year when activity in certain funds such as the capital improvement and special revenue funds is higher than normal. This will distort the financial picture of some of the other components of the governmental funds such as the General Fund which tends to be more level and predictable in terms of spending and receipt of revenue. Each month the report will provide further explanation on the activity of the General Fund, the Village's primary operating fund. The report will also provide additional information on fund types that experienced higher than normal activity for the month. Activity for the General Fund is highlighted below. General Fund - Cash and cash equivalents at June 30 totaled $4,399,893.09. During July, cash receipts totaled $2,140,880.08 and investment income was $5,988.83. Significant cash receipts included sales and income taxes and telecommunication taxes. Sales tax revenues for the month totaled $801,809. Of this amount, $722,387 was generated from the 1 % state portion while $79,422 was generated from the .25% home rule portion. The state portion showed a decrease of 16.0% from last year same time. The home rule portion fell by a lesser amount, 28.8%. 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 July are for April 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 - July 2009.doc Monthly Financial Report - July 2009 August 14,2009 Page 3 Income tax receipts in July totaled $365,907. Income tax receipts compared to last year are down 20.1 % for the month and 14.6% for the year. We have adjusted the year-end estimate for income taxes downward as a result. The new year-end estimate is $5,007,000, down from the $5,424,000 originally budgeted. Telecommunication tax receipts for July reflect April activity. Total receipts during July were $301,740. This is 41.9% over July 2008. For the year, telecommunication taxes are ahead by 13.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. Disbursements from the General Fund for July included payments to vendors of $1,793,530.12 and payments for employee wages and benefits of $1,691 ,755.32. Interfund transfers of $477,451.77 for health premiums and vehicle lease and maintenance payments were also made during July. Cash and cash equivalents at July 31 were $3,580,157.91. In addition, investments consisting of certificates of deposit were $2,068,555.68 bringing total cash and investments for the General Fund to $5,648,713.59. Statement of Investments (pages 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,085.74 5,737,545.00 $ 10,580,630.74 Representing Total Portfolio 45.773% 54.227% 100.000% The portfolio weighted average return is 0.91 %. 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. 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 H:\ACCT\Treasurer's Report\2009\Monthly Financial Report\Monthly Cash Position Report - July 2009.doc Monthly Financial Report - July 2009 August14,2009 Page 4 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 Market Date Date Institution Description Acct # Rate % Value POLICE PENSION FUND (710) Various Various Wells Fargo Wells Fargo Investments Various Various 20,119,335.90 Various Various Various Mutual Fund Investments Various Various 14,857,106.09 34,976,441.99 FIRE PENSION FUND (720) Various Various Wells Fargo Wells Fargo Investments Various Various 21,691,467.77 Various Various Various Mutual Fund Investments Various Various 13,945,236.70 35,636,704.47 TOTAL TRUST AND AGENCY FUND INVESTMENTS $ 70,613,146.46 Investment of the Village's pension funds is governed by an Investment Policy adopted by each Pension Board. The policy was last amended in 2007. Conclusion As mentioned earlier, this cash position report is intended to provide a snapshot of the Village's cash position as of a particular month end date. Over time, this report will be able to provide trend information to help in cash management duties, maximizing investment earnings while ensuring availability of funds to meet the Village's commitments. The cash position report will be provided to the Village Board and Finance Commission on a monthly basis moving forward. ~c7 CL- David O. Erb Finance Director H:\ACCT\Treasurer's Report\2009\Monthly Financial Report\Monthly Cash Position Report - July 2009.doc VILLAGE OF MOUNT PROSPECT Preliminary Cash and Investment Position Report - All Funds For the Month Ended July 31, 2009 GOVERNMENTAL AND ENTERPRISE FUNDS Cash and Cash Total Cash and Equivalents Investments Investments Balance at June 30, 2009 $ 23,939,645.83 $ 13,077,219.26 $ 37,016,865.09 Cash receipts 3,684,395.69 3,684,395.69 Investment income 15,855.48 15,855.48 Transfers from investments to cash 5,229,613.35 (5,229,613.35) Transfers to investments from cash (2,733,024.83) 2,733,024.83 Interfund activity 10,700.00 10,700.00 Disbursements: Accounts payable (4,621,532.84 ) (4,621,532.84) Payroll (2,089,758.92) (2,089,758.92) Other (2,680.56) (2,680.56) Balance at July 31, 2009 $ 23,433,213.20 $ 10,580,630.74 $ 34,013,843.94 TRUST AND AGENCY FUNDS * Cash and Cash Total Cash and Equivalents Investments Investments Balance at June 30, 2009 $ 4,543,758.04 $ 71,455,241.88 $ 75,998,999.92 Cash receipts 274,911.80 274,911.80 Investment income (loss) 135,883.06 248,542.87 384,425.93 Transfers from investments to cash 1,991,895.29 (1,991,895.29) Transfers to investments from cash (901,257.00) 901,257.00 Interfund activity (10,700.00) (10,700.00) Disbursements: Accounts payable (186,188.36) (186,188.36) Payroll (405,983.98) (405,983.98) Flex spending (23,108.78) (23,108.78) Other (545.00) (545.00) Balance at July 31, 2009 $ 5,418,665.07 $ 70,613,146.46 $ 76,031,811.53 * Assets are restricted in purpose and do not represent discretionary assets of the government. 1 I- () W CL CJl o a; CL I- Z :) o :! u. o W C) <( ..I ..I > Ol 0. >-0> 1-0 -00 eN ~ . u.;;; >->- .0- >-~ - -. 'S; "0 U Q) <(-g .r:UJ Ul.r: ro_ Ue 'O~ e::-Ol ro= E ~ E 0 ~u. CJl CJl o z :) u. >- U Z UJ C) <( o Z <( I- CJl :::> a; I- CJlr :::>U a;ZCJl I-UJO o::C)Z UJ<(:::> :cOu. I-Z 0<( OUJ~ ZUO <(-- UJ-'CJl o::OZ -CLUJ u. CL o Z <(UJ .CJl !;OCCJl OCLO ,n 0:: Z '-'UJ:) -'I-u. ~Z oUJ I- CJl o Z :::> u. UJ CJl OC a.. 0:: UJ I- Z UJ o Z <( ..I ~ Z UJ :iE Z 0:: UJ > o (!) -,CJl <(I-CJl f-'UO -UJZ 0..-.:) C3~u. a.. -,W <(:)CJl -ZO UUJZ UJ>:) o..UJu. CJlo:: """ '" tricriari' It>It>N It> 0> ~a; It> 0 ~..... ~ C"')C'\Immo ~~<')NO N~"""&.ri""":' o It> It> 0) It> NO>lXllXlN ~t~-~C; <o~..-CJ)CJ) N ~- ~ ('I) 0) co U')c;)oco lXl<O"'-<')lXlOIt> &.riLriLriM~ool ~C)L()"-NCCO <OM lXl <00 1'-<0 a;~Ltia;MON ('l")CX)..-NM..-- 0><0 NI'- MM .oN N ~ ~ CJl o ..lZ <(:::> Zu. O::UJ UJu 1-- Z> -0:: UJ CJl O..-ONcnCO ~~6~~~' <OM<O<,)N<,) MN.....<ON..,- <oo.Ltiaioo .....0 1O.....C"') 0,.... ClOT""CO as - ~ ~ UJ CJl OC(l) 0..0 O::Z UJ:::> I-u. Z UJ Q)NOCO~o) COCO.....ll)CX)(O C"i"";oLriC"i<ci1 "'-1'-0 <,)M lXl c.oc:ovmo-.:- cO ex; ..-- -.:i Lr) cO MIt> 00<') ...rco """N..- ~ ~~ ~ It>..,-..... t--<OI'- r-:.o<"i It> 0 It> <Ol'-lXl M<O. . 0)1'- ..,-..... .0 0><0 lXl..,- Mcri' <')It> N.. N. u:ie ~ UJ U >(1) 0::0 UJz (I):) lou. UJ o .....N..,- 1'-0..,- -=Lri-= ..,-00 ..,-It>..... <0<0 MlXl It> ~ ONOCONN r--:~":f':~~l M..,-Ol'-I'-"'- "'-C>>It><olXlC>> <O..-M...,.O)O cOT"'"-~NN.<<i It>N Olt>~ o. <') <O!::?. ~ o Z :::> u. -' ~ UJ Z UJ (!) o)CO('t)ON~CO C!C!<<!O>NI'-It> MococriLri""':o' C>>lXllXlMNlt>lXl lXllXlC>><')It>..,-<O a;oLtiNMr'N mv ...-..-,......- <')..... 00..,- ~N N-~- ~ CJl ~ ~ I- :c ~ Zero W Ul :!i 0. >~ ~E ~=~ EOl ~:ceo ~ Ol Ol gj ~ € .~ ~ tl Wu E~Ol o;;::o.ro :z:ffi 0'-> ~~cn0 U)cal'lgE.~ cc1:c <(.oo.::;eo OlOlOlOl () ~.~ 5i ~ -;; -0 ~ ~ ~ ~ 05'2 f!! E.!.e! C!?!?!? ~ iJi.5.r:-OlUl ~ ~-EEEEE <(ClUl ",,,,OlUlUlUlUl ()&l~~~~:Ei5i5i5i5 OCJf'- co 6 Lri ex) I ~ 0..,-0 lXl """L()..- ('t) ci-C"'i ci ~ ~ ~ <') N o lXl a; It> ~ CX)N' C>>I'- <"i<"i lXlO C)lXl .0.0 0..... ~:s. <') I'- N <0 lXl ai It> It> M N~ C) lXl criN It> M I'-It> ai~ lXlN 0<0 ~:i o N <"i ..... N M <') ..,- M N U)(i) C>>1t> .oN lXlC>> 1'-"'- .0 a; ..... It> :s!E. lXl o .0 M M .0 N I'- ai ~~ .......,- MI'- .o~ .....N 01'- ~o It> lXl ~<O lXl M ai lXl lXl ai N I'- ~ ..... C) ai o M. It> ~ N <0 <"i lXl lXl <0 It> lXl ~ N ..,- ~ (b a; ..... It> I'- <"i o ..,- M o <0 ~<O ~~ ..... ..... OM NlXl ~C'\i <') It> ~~ <0 ..,- N ..,- It> ai M C) NN <') ..... 0.00 It> M I'- It> ~M c)c>> <0.1'-. ..... ..... ~~ ..... C) r-: It> ..... o lXl It> M Ol u e '" 1ii .0 Cl e :c e UJ ~ 0' M <0 o lXl It> o ..... ..,- It> 0' It> N .0 ..... ~ ..,- lXl <"i' <') o .0 It> M <0 ..,- <"i' o lXl ai lXl I'- .0 N N.., I'- lXl C) N It> ..,- lXl <0 0.0 It> It> ai <0 o N E~ ==G>Q) l!l E E o.~u; U).g~~ IE '0 .5 .5 WUlO-o ::EOl2le l-iiiro,2 (I).g~1i5 ~:e=.a :!:~~~ I'- C) <0 I'- <"iN 0..,- lXl<') ON .....0 lXl lXl ~<<i "'-N <0 ..,- .0 ..,- ..... M co o I'- ..,- I'- o <') <0 o lXl It> o ..... ..,- It> o It> N .0 0;. ..,- lXl <"i <') o .0 It> <') <0 ..,- <"i o lXl ai co I'- It) N N r-: lXl C) N It> ..,- co <0 0.0 It> II) ai <0 o N Ul C Ol E "Iii ~ .5 :e ~ ... N o co en II) IX!. ... G> ... Cli o o N .... ... .,f .... ~ ~ G> M ~ co ..; ... o .,f M ... N U) ui co II) o ~ o ... ... N N M N G> ..; co o iii ... co o ....: co U) iii ~ U) o ... ... II) .... M o ~ ..; o CD E Ol E E Ol > o Cl Ol = '0 Ul q; Ul Ul '" e::- ro e o ~ u Ul :c c Ol Ul l!! 0. l!! "5 e o "0 "0 e ro Ol Ul o 0. 5 0. .5 "0 ~ .'" "Iii l!! l!! '" Ul q; Ul Ul <( 2 ... co U) Cli N ~ ... G> M. ... G> II) M ..... .... ffIi ~ iii ... CJl I- Z UJ :! I- CJl W > :!: c z <( :J: CJl <( () ..I ~ o I- VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of July 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) 08/11/09 07/07/09 Harris Certificate of Deposit 6900156783 0.330% 512,584.62 1,691.53 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 10/13/09 06/09/09 Harris Certificate of Deposit 6900221843 1.030% 550,000.00 5,665.00 2,068,555.68 12,693.08 Weighted Average Return 0.614% REFUSE DISPOSAL FUND (030) 08/11109 07/07/09 Harris Certificate of Deposit 6900156783 0.330% 102,516.92 338.31 09/08/09 07/07/09 Harris Certificate of Deposit 6900214015 0.410% 250,4 70.30 1,026.93 10/13/09 06/09/09 Harris Certificate of Deposit 6900221843 1.030% 100,000.00 1,030.00 452,987.22 2,395.23 Weighted Average Return 0.529% CAPITAL IMPROVEMENT FUND (510) 08/11109 07/07/09 Harris Certificate of Deposit 6900156783 0.330% 51,258.46 169.15 51,258.46 169.15 Weighted Average Return 0.330% SERIES 2009 CONSTRUCTION FUND (528) 09/16/09 04/30/09 Citibank/PMA Certificate of Deposit 132426 0.960% 1,567,942.00 15,052.24 10/21109 04/30/09 Citibank/PMA Certificate of Deposit 132425 1.160% 1,687,941.00 19,580.12 11/18/09 04/30/09 Citibank/PMA Certificate of Deposit 132424 1.280% 248,200.00 3,176.96 11118/09 04/30/09 Citibank/PMA Certificate of Deposit 132423 1.280% 248,200.00 3,176.96 11118/09 04/30/09 Citibank/PMA Certificate of Deposit 132422 1.260% 1,071,542.00 13,501.43 12/16/09 04/30/09 Citibank/PMA Certificate of Deposit 132418 1.541% 245,200.00 3,778.53 12/16/09 04/30/09 Citibank/PMA Certificate of Deposit 132419 1.490% 245,400.00 3,656.46 12/16/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 132421 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) 08/11109 07/07/09 Harris Certificate of Deposit 6900156783 0.330% 205,033.84 676.61 10/13/09 06/09/09 Harris Certificate of Deposit 6900221843 1.030% 150,000.00 1,545.00 355,033.84 2,221.61 Weighted Average Return 0.626% VEHICLE MAINTENANCE FUND (660) 08/11109 07/07/09 Harris Certificate of Deposit 6900156783 0.330% 51,258.45 169.15 51,258.45 169.15 Weighted Average Return 0.330% VEHICLE REPLACEMENT FUND (670) 08/11109 07/07/09 Harris Certificate of Deposit 6900156783 0.330% 51,258.45 169.15 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 10/13/09 06/09/09 Harris Certificate of Deposit 6900221843 1.030% 50,000.00 515.00 1,107,229.50 6,020.71 Weighted Average Return 0.544% 3 VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of July 31, 2009 GOVERNMENTAL AND ENTERPRISE FUNDS (continued) Maturity Purchase Financial Investment CUSIP/ Interest Market Weighted Date Date Institution Description Acct# Rate % Value Avg Yield RISK MANAGEMENT FUND (690) 08/11/09 07/07/09 Harris Certificate of Deposit 6900156783 0.330% 256,292.29 845.76 09/08/09 07/07/09 Harris Certificate of Deposit 6900214015 0.410% 250,4 70.30 1,026.93 10/13/09 06/09/09 Harris Certificate of Deposit 6900221843 1.030% 250,000.00 2,575.00 756,762.59 4,447.69 Weighted Average Return 0.588% GOVERNMENTAL AND ENTERPRISE FUNDS Market Representing Weighted SUMMARY BY TYPE OF INVESTMENTIINSTITUTION: Value Total Portfolio Avg Yield Harris CDs 4,843,085.74 45.773% 28,116.64 Citibank/PMA CDs 5,737,545.00 54.227% 67,798.04 $ 10,580,630.74 100.000% 95,914.67 Portfolio Weighted Average Return 0.907% TRUST AND AGENCY FUNDS * Maturity Purchase Financial Date Date Institution POLICE PENSION FUND (710) Various Various Wells Fargo Various Various Various Investment Description CUSIP/ Acct# Interest Rate % Market Value Weighted Avg Yield Wells Fargo Investments Mutual Fund Investments Various Various Various Various 20,119,335.90 14,857,106.09 34,976,441.99 FIRE PENSION FUND (720) Various Various Wells Fargo Various Various Various Wells Fargo Investments Mutual Fund Investments Various Various Various Various 21,691,467.77 13,945,236.70 35,636,704.47 TOTAL TRUST AND AGENCY FUND INVESTMENTS $ 70,613,146.46 * Assets are restricted in purpose and do not represent discretionary assets of the government. 4 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE & EXPENDITURE SUMMARIES July 1 - July 31, 2009 08/12/2009 09:44:40 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/09 - 07/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 54,304 910,743 99,122 1,348,097 1,576,690 56,932 398,029 5,584 289,205 120 4,738,826 REVENUE BY FUND GENERAL FUND REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND FOREIGN FIRE TAX BOARD FUND SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2009 B&I, FD/PW SERIES 1999 B&I, TIF SERIES 1998A B&I, FLOOD SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD CAPITAL IMPROVEMENT FUND SERIES 2009 CONST FUND DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST FUND WATER AND SEWER FUND VILLAGE PARKING SYSTEM FUND PARKING SYSTEM REVENUE FUND VEHICLE MAINTENANCE FUND VEHICLE REPLACEMENT FUND COMPUTER REPLACEMENT FUND RISK MANAGEMENT FUND POLICE PENSION FUND FIRE PENSION FUND SSA #6 GEORGE/ALBERT B&I GENERAL FIXED ASSETS ACCT GP Total All Funds 2,184,338 126,529 84,687 o 29,068 7 7 4,118 8,241 1 1,435 3,440 2,308 o o o 79,422 o o 76,068 7,296 -1,338 100,071 720 724,855 9,944 11,450 138,173 80,795 16,471 503,731 277,255 269,734 o o 4,738,826 1 Y-T-D Received 6,679,493 5,616,088 2,331,265 6,941,103 11,804,912 283,018 3,130,144 139,986 3,029,971 10,117,610 50,073,590 17,755,012 2,127,574 770,342 o 105,512 1,690 46 10,735 8,294 7 181,006 432,650 242,495 o o 11 297,745 o o 297,466 9,898,241 947,262 434,963 8,955 5,574,909 70,369 72,995 967,967 810,071 115,656 3,798,117 2,672,203 2,471,291 6 o 50,073,590 7 Months 5 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 58.3% 41.6% Unreceived Balance 6,998,507 10,186,912 1,525,735 12,045,311 10,630,655 446,982 3,708,856 261,014 2,928,981 2,505,390 51,238,343 23,704,988 2,038,426 1,041,658 o 680,092 10,310 1,954 10,265 32,706 -7 203,994 485,350 -242,495 o o -11 952,255 o o 1,077,344 2,885,759 1,727,738 1,095,037 99,545 6,408,091 90,631 88,005 703,715 349,629 104,625 2,885,439 2,294,297 2,509,009 -6 o 51,238,343 Completed Remaining Unreceived Percent 51.2 64.5 39.6 63.4 47.4 61.2 54.2 65.1 49.2 19.8 50.6 57.2 48.9 57.5 86.6 85.9 97.7 48.9 79.8 53.0 52.9 76.2 78.4 22.6 64.6 71.6 91. 7 53.5 56.3 54.7 42.1 30.1 47.5 43.2 46.2 50.4 50.6 08/12/2009 09:45:13 FRRBRR03 SUM021 7 Months 5 Months 58.3% 41.6% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/09 - 07/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 40,905 639,745 96,702 1,237,392 99,839 48,934 4,090 2,460 14,151 120 TOTAL GENERAL FUND 2,184,338 REFUSE DISPOSAL FUND 40 PROPERTY TAXES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 6,317 108,964 383 10,865 TOTAL REFUSE DISPOSAL FUND 126,529 MOTOR FUEL TAX FUND 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 47 REIMBURSEMENTS 81,638 129 2,920 TOTAL MOTOR FUEL TAX FUND 84,687 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 29,067 1 o TOTAL COMMUNITY DEVELPMNT BLOCK GRNT 29,068 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 Y-T-D Received 4,994,256 2,905,217 2,312,860 6,128,044 869,024 258,918 47,317 129,896 108,859 621 17,755,012 830,002 1,225,182 7,431 64,959 2,127,574 761,929 692 7,721 770,342 o o o 32,380 16 73,116 105,512 o 7 1,589 101 7 1,690 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 46 1,000 1,000 Unreceived Balance 5,642,744 4,688,783 1,462,140 10,122,456 721,476 440,082 354,683 199,104 74,141 -621 23,704,988 919,998 1,004,818 27,569 86,041 2,038,426 974,071 15,308 52,279 1,041,658 o o o 713,224 -16 -33,116 680,092 8,411 1,899 10,310 1,000 954 Completed Remaining Unreceived Percent 53.0 61. 7 38.7 62.3 45.4 63.0 88.2 60.5 40.5 57.2 52.6 45.1 78.8 57.0 48.9 56.1 95.7 87.1 57.5 o o o 95.7 -82.8 86.6 84.1 95.0 85.9 100.0 95.4 08/12/2009 09:45:13 FRRBRR03 SUM021 7 Months 5 Months 58.3% Completed Remaining 41. 6% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/09 - 07/31/09 Cur Mo Received Y-T-D Received 2009 Budget Unreceived Balance Unreceived Percent 97.7 TOTAL DEA SHARED FUNDS FUND DUI FINE FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME 4,118 o TOTAL DUI FINE FUND 4,118 FOREIGN FIRE TAX BOARD FUND 41 OTHER TAXES 46 INVESTMENT INCOME 8,240 1 TOTAL FOREIGN FIRE TAX BOARD FUND 8,241 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 46 2,000 20,000 1,000 21,000 40,000 1,000 41,000 o 7 7 10,731 4 10,735 8,270 24 8,294 o 1 1 1,954 9,269 996 46.3 99.6 10,265 48.9 31,730 976 79.3 97.6 32,706 79.8 o o o -7 o -7 1,417 180,813 381,000 200,187 52.5 18 193 4,000 3,807 95.2 0 0 0 0 1,435 181,006 385,000 203,994 53.0 TOTAL SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 3,393 47 o TOTAL SERIES 2003 B&I, VILLAGE HALL 3,440 SERIES 2009 B&I, FD/PW 40 PROPERTY TAXES 46 INVESTMENT INCOME 2,272 36 TOTAL SERIES 2009 B&I, FO/PW 2,308 SERIES 1999 B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 1999 B&I, TIF SERIES 1998A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 1998A B&I, FLOOD 432,149 501 o 432,650 242,273 222 242,495 o o o o o o 910,000 8,000 o 918,000 o o o o o o 477,851 7,499 o 52.5 93.7 485,350 52.9 o o -242,273 -222 o -242,495 o o o o o o o o o o o o 08/12/2009 09:45:13 FRRBRR03 SUM021 7 Months 5 Months 58.3% 41.6% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/09 - 07/31/09 Cur Mo Received SERIES 1998C B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I 41 OTHER TAXES 46 INVESTMENT INCOME 79,422 o TOTAL IEPA FLOOD CONTROL LOANS B&I 79,422 SERIES 2000 B&I, FLOOD CONTROL 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD 41 OTHER TAXES 49 OTHER FINANCING SOURCES TOTAL SERIES 2002B B&I, FLOOD CAPITAL IMPROVEMENT FUND 41 OTHER TAXES 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 73,068 o 135 o 2,865 o TOTAL CAPITAL IMPROVEMENT FUND 76,068 SERIES 2009 CONST FUND 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 7,296 o o TOTAL SERIES 2009 CONST FUND 7,296 DOWNTOWN REDEVLPMNT CONST 41 OTHER TAXES 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES -1,490 152 o o o TOTAL DOWNTOWN REDEVLPMNT CONST -1,338 STREET IMPROVEMENT CONST FUND 41 OTHER TAXES 46 INVESTMENT INCOME 100,054 17 Y-T-D Received o o o 297,745 o 297,745 o o o o o o 273,925 18,750 1,926 o 2,865 o 297,466 26,252 o 9,871,989 9,898,241 944,309 1,201 1,752 o o 947,262 425,815 892 2009 Budget o 11 11 1,250,000 o 1,250,000 o o o o o o 1,150,000 206,810 18,000 o o o 1,374,810 220,000 1,000 12,563,000 12,784,000 2,640,000 35,000 o o o 2,675,000 1,520,000 10,000 Unreceived Balance o o o 952,255 o 952,255 o o o o o o 876,075 188,060 16,074 o -2,865 o 1,077,344 193,748 1,000 2,691,011 2,885,759 1,695,691 33,799 -1,752 o o 1,727,738 1,094,185 9,108 Completed Remaining Unreceived Percent o -11 -11 76.2 76.2 o o o o o o 76.2 90.9 89.3 78.4 88.1 100.0 21. 4 22.6 64.2 96.6 64.6 72.0 91.1 08/12/2009 09:45:13 FRRBRR03 SUM021 7 Months 5 Months 58.3% 41. 6% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/09 - 07/31/09 Cur Mo Received 48 OTHER REVENUE TOTAL STREET IMPROVEMENT CONST FUND 100,071 FLOOD CONTROL CONST FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME o 720 o o TOTAL FLOOD CONTROL CONST FUND 720 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 5,350 1,700 716,106 701 o 998 o TOTAL WATER AND SEWER FUND 724,855 VILLAGE PARKING SYSTEM FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 2,859 o 7,079 6 TOTAL VILLAGE PARKING SYSTEM FUND 9,944 PARKING SYSTEM REVENUE FUND 41 OTHER TAXES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 3,495 7,951 4 TOTAL PARKING SYSTEM REVENUE FUND 11,450 VEHICLE MAINTENANCE FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 138,060 113 o TOTAL VEHICLE MAINTENANCE FUND 138,173 VEHICLE REPLACEMENT FUND 44 CHARGES FOR SERVICE 45 FINES AND FORFEITS 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 75,132 3,880 1,783 o o Y-T-D Received o 8,256 434,963 o 8,785 o 170 8,955 736,987 9,620 4,799,271 15,489 o 13,542 o 5,574,909 10,719 o 59,583 67 70,369 13,101 59,811 83 72,995 966,400 1,275 292 967,967 525,932 11,780 27,359 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 Unreceived Balance o -8,256 1,095,037 o 51,215 47,500 830 99,545 772,013 6,380 5,436,729 179,511 2,000 11,458 o 6,408,091 34,281 6,000 48,417 1,933 90,631 41,899 45,189 917 88,005 690,282 13,725 -292 703,715 373,768 -11,780 172,641 o -185,000 Completed Remaining Unreceived Percent 71.6 85.4 100.0 83.0 91. 7 51.2 39.9 53.1 92.1 100.0 45.8 53.5 76.2 100.0 44.8 96.7 56.3 76.2 43.0 91. 7 54.7 41.7 91.5 42.1 41.5 86.3 -308.3 08/12/2009 09:45:13 FRRBRR03 SUM 021 7 Months 5 Months 58.3% 41. 6% Completed Remaining Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/09 - 07/31/09 Cur Mo Received Y-T-D Received 2009 Budget Unreceived Balance Unreceived Percent TOTAL VEHICLE REPLACEMENT FUND 80,795 30.1 COMPUTER REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 16,274 197 TOTAL COMPUTER REPLACEMENT FUND 16,471 RISK MANAGEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 810,071 113,915 1,741 115,656 1,159,700 195,281 25,000 220,281 349,629 81,366 23,259 41. 7 93.0 104,625 47.5 407,285 3,185,794 5,414,404 2,228,610 41.2 869 11,322 90,000 78,678 87.4 204 617 10,000 9,383 93.8 95,373 600,384 1,169,152 568,768 48.6 503,731 3,798,117 6,683,556 2,885,439 43.2 TOTAL RISK MANAGEMENT FUND POLICE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE 185,630 91,625 TOTAL POLICE PENSION FUND 277,255 FIRE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE 196,406 73,328 TOTAL FIRE PENSION FUND 269,734 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 1,548,843 1,123,360 2,672,203 1,436,953 1,034,338 2,471,291 o o o o o o o 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 1,144,157 1,150,140 42.5 50.6 2,294,297 46.2 1,427,047 1,081,962 49.8 51.1 2,509,009 50.4 o -6 o -6 o o o o o o 9,450,626 100.0 9,450,626 100.0 08/12/2009 09:43:30 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/09 - 07/31/09 Cur Mo Expended Y-T-D Expended 2009 Budget 58.3% 41. 6% Unexpended Balance Completed Remaining Unexpended Percent EXPENDITURE BY CLASSIFICATION PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS PENSION BENEFITS CONTRACTUAL SERVICES UTILITIES INSURANCE COMMODITIES & SUPPLIES OTHER EXPENDITURES LAND IMPROVEMENTS BUILDING IMPROVEMENTS OFFICE EQUIPMENT MOBILE EQUIPMENT OTHER EQUIPMENT DISTRIBUTION SYSTEMS INFRASTRUCTURE BOND PRINCIPAL INTEREST EXPENSE BANK AND FISCAL FEES INTERFUND TRANSFERS Total All Funds EXPENDITURE BY FUND GENERAL FUND REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND FOREIGN FIRE TAX BOARD FUND SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2009 B&I, FD/PW SERIES 1999 B&I, TIF SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL CAPITAL IMPROVEMENT FUND SERIES 2009 CONST FUND DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST FUND WATER AND SEWER FUND VILLAGE PARKING SYSTEM FUND PARKING SYSTEM REVENUE FUND VEHICLE MAINTENANCE FUND 3,127,619 639,089 22,011 525,312 1,406,613 45,924 556,689 94,834 45,761 52,491 632,586 45,395 26,322 110,774 235,868 594,697 16,909 2,735 o o 8,181,629 4,032,615 337,758 99,889 o 247,345 921 o o o o o o o o o o o 19,644 o o 647,186 53,828 354,815 o 1,069,700 5,510 11,983 178,030 15,389,913 5,245,589 223,165 3,561,972 9,153,172 259,934 4,064,290 894,161 143,918 53,326 1,785,235 129,623 1,101,675 440,220 311,761 2,707,742 265,053 344,092 1,050 o 46,075,891 23,001,949 2,262,660 1,348,252 o 354,418 7,416 o 853 8,237 o 83,320 200,553 o o o o o 326,322 o 105,814 2,228,023 175,785 1,010,152 510,048 4,780,360 41,550 74,137 930,316 26,976,217 9,732,355 526,619 5,985,000 19,097,242 657,765 6,962,783 1,887,744 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 11,586,304 4,486,766 303,454 2,423,028 9,944,070 397,831 2,898,493 993,583 1,776,332 9,474 9,223,671 373,941 1,433,825 2,687,153 2,025,279 2,227,258 960,166 334,691 150 o 54,085,469 18,952,951 1,933,432 764,850 o 456,186 -5,416 1,000 647 7,263 o 298,020 709,955 o o o o o 287,032 o 1,439,036 10,555,977 1,749,865 1,846,448 -275,048 7,734,945 89,934 69,766 741,366 43.0 46.1 57.6 40.5 52.1 60.5 41. 6 52.6 92.5 15.1 83.8 74.3 56.5 85.9 86.7 45.1 78.4 49.3 12.5 54.0 45.2 46.1 36.2 56.3 -270.8 100.0 43.1 46.9 78.2 78.0 46.8 93.2 82.6 90.9 64.6 -117.0 61. 8 68.4 48.5 44.3 08/12/2009 09:43:30 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/09 - 07/31/09 7 Months 5 Months 58.3% 41.6% Completed Remaining Cur Mo Y-T-D 2009 Unexpended Unexpended Expended Expended Budget Balance Percent VEHICLE REPLACEMENT FUND 26,322 1,101,675 2,535,500 1,433,825 56.5 COMPUTER REPLACEMENT FUND 45,000 116,613 188,150 71,537 38.0 RISK MANAGEMENT FUND 528,986 3,870,363 6,684,336 2,813,973 42.1 POLICE PENSION FUND 264,495 1,799,243 2,993,500 1,194,257 39.9 FIRE PENSION FUND 257,602 1,737,832 2,951,500 1,213,668 41.1 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 8,181,629 46,075,891 100,161,360 54,085,469 54.0 08/12/2009 09,45,43 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 07/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 58.3% Completed 41.6% Remaining o o o o o o o o o o o o 08/12/2009 09:45:43 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 07/31/09 PUBLIC REPRESENTATION Cur Mo Expended PROGRAM TOTALS 02 MAYOR AND BOARD OF TRUSTEES 03 ADVISORY BOARDS & COMMISSIONS 12,494 543 Totals 13,037 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 3,139 549 4 8,494 19 832 Totals 13,037 SOURCE OF FUNDS 001 GENERAL FUND 13,037 Totals 13,037 ? Y-T-D Expended 92,884 2,960 95,844 19,897 3,498 923 68,156 132 3,238 95,844 95,844 95,844 2009 Budget 129,856 7,448 137,304 33,967 5,955 8,900 83,132 500 4,850 137,304 137,304 137,304 58.3% 41. 6% Completed Remaining Unexpended Unexpended Balance Percent 36,972 4,488 41,460 14,070 2,457 7,977 14,976 368 1,612 41,460 41,460 41,460 28.5 60.3 30.2 41.4 41.3 89.6 18.0 73.6 33.2 30.2 30.2 30.2 08/12/2009 09:45:43 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 07/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 59,933 74,626 29,548 87,647 24,279 Totals 276,033 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 111,589 34,488 1,166 128,033 545 212 o o Totals 276,033 SOURCE OF FUNDS 001 GENERAL FUND 276,033 Totals 276,033 3 Y-T-D Expended 348,032 452,342 163,656 503,216 165,560 1,632,806 582,100 202,147 16,838 823,398 3,635 4,469 219 o 1,632,806 1,632,806 1,632,806 2009 Budget 58.3% 41.6% Completed Remaining Unexpended Unexpended Balance Percent 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 210,602 108,408 209,485 602,636 111,279 1,242,410 442,671 139,869 27,862 595,426 6,225 9,846 18,911 1,600 1,242,410 1,242,410 1,242,410 37.7 19.3 56.1 54.5 40.2 43.2 43.2 40.9 62.3 42.0 63.1 68.8 98.9 100.0 43.2 43.2 43.2 08/12/2009 7 Months 58.3% Completed 09:45:43 VILLAGE OF MOUNT PROSPECT 5 Months 4l.6% Remaining FRRDBROl SUM031 Department Budget Expenditure Summary 01/01/09 - 07/31/09 Cur Mo Y-T-D 2009 Unexpended Unexpended TV SERVICES DIVISION Expended Expended Budget Balance Percent PROGRAM TOTALS 02 CABLE TV OPERATIONS 15,512 90,381 141,989 51,608 36.3 04 INTERGOVERNMENTAL PROGRAMMING 4,556 27,830 49,424 21, 594 43.7 Totals 20,068 118,211 191,413 73,202 38.2 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 14,851 67,507 111,064 43,557 39.2 51 EMPLOYEE BENEFITS 4,203 24,809 41,653 16,844 40.4 52 OTHER EMPLOYEE COSTS 0 1,229 2,900 1,671 57.6 54 CONTRACTUAL SERVICES 888 11,305 18,936 7,631 40.3 55 UTILITIES 126 883 1,600 717 44.8 57 COMMODITIES & SUPPLIES 0 6,246 5,760 -486 -8.4 67 OTHER EQUIPMENT 0 6,232 9,500 3,268 34.4 Totals 20,068 118,211 191,413 73,202 38.2 SOURCE OF FUNDS 001 GENERAL FUND 20,068 118,211 191,413 73,202 38.2 Totals 20,068 118,211 191,413 73,202 38.2 4 08/12/2009 7 Months 58.3% Completed 09:45:43 VILLAGE OF MOUNT PROSPECT 5 Months 41.6% Remaining FRRDBROl SUM031 Department Budget Expenditure Sununary 01/01/09 - 07/31/09 Cur Mo Y-T-D 2009 Unexpended Unexpended VILLAGE CLERK'S OFFICE Expended Expended Budget Balance Percent PROGRAM TOTALS 02 VILLAGE CLERK'S OFFICE 24,034 118,065 217,076 99,011 45.6 Totals 24,034 118,065 217,076 99,011 45.6 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 13,846 73,615 123,762 50,147 40.5 51 EMPLOYEE BENEFITS 4,340 26,488 44,900 18,412 41.0 52 OTHER EMPLOYEE COSTS 0 1,087 2,580 1,493 57.9 54 CONTRACTUAL SERVICES 5,884 14,675 39,331 24,656 62.7 55 UTILITIES 63 441 1,700 1,259 74.1 57 COMMODITIES & SUPPLIES -99 1,759 4,803 3,044 63.4 Totals 24,034 118,065 217,076 99,011 45.6 SOURCE OF FUNDS 001 GENERAL FUND 24,034 118,065 217,076 99,011 45.6 Totals 24,034 118,065 217,076 99,011 45.6 5 08/12/2009 09:45:43 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 07/31/09 FINANCE DEPARTMENT Cur Mo Expended PROGRAM TOTALS 01 FINANCE ADMINISTRATION 02 ACCOUNTING 05 INSURANCE PROGRAMS 06 CUSTOMER SERVICE 07 CASH MANAGEMENT 24,464 51,792 28,153 47,592 3,124 Totals 155,125 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 94,263 28,893 786 11,006 375 19,503 299 o Totals 155,125 SOURCE,OF FUNDS 001 GENERAL FUND 155,125 Totals 155,125 Y-T-D Expended 205,053 275,380 181,129 239,742 16,360 917,664 479,595 172,251 4,854 107,304 2,439 136,522 14,269 430 917,664 917,664 917,664 6 2009 Budget 58,3% 41,6% Completed Remaining Unexpended Unexpended Balance Percent 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 152,129 204,030 130,244 179,175 11,553 677,131 351,960 123,057 7,046 82,150 4,081 97,516 10,751 570 677,131 677,131 677,131 42,6 42,6 41.8 42,8 41.4 42.5 42.3 41.7 59.2 43.4 62.6 41.7 43.0 57.0 42.5 42.5 42.5 08/12/2009 09:45:43 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 07/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 32,466 27,381 8,783 93,023 58,161 12,758 Totals 232,572 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 158,978 49,735 378 16,998 1,129 5,354 o Totals 232,572 SOURCE OF FUNDS 001 GENERAL FUND 550 DOWNTOWN REDEVLPMNT CONST 232,572 o Totals 232,572 Y-T-D Expended 164,314 175,274 55,557 494,036 296,640 71,780 1,257,601 793,854 296,965 13,131 135,675 6,852 11,124 o 1,257,601 1,256,601 1,000 1,257,601 7 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 58.3% 41.6% Unexpended Balance 120,767 192,230 93,175 501,591 284,103 55,253 1,247,119 596,291 214,100 22,677 360,520 12,422 11,509 29,600 1,247,119 1,247,119 1,247,119 Completed Remaining Unexpended Percent 42.4 52.3 62.6 50.4 48.9 43.5 49.8 42.9 41. 9 63.3 72.7 64.4 50.9 100.0 49.8 49.8 o 49.8 08/12/2009 09:45:43 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 07/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 10,513 n,375 126,972 78,485 Totals 247,345 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 6,516 2,101 61 33,210 o 25,994 52,491 126,972 Totals 247,345 SOURCE OF FUNDS 070 COMMUNITY DEVELPMNT BLOCK GRNT 247,345 Totals 247,345 8 Y-T-D Expended 53,159 31,375 130,269 139,615 354,418 32,797 12,590 553 44,249 105 81,364 52,491 130,269 354,418 354,418 354,418 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 58.3% 41. 6% Completed Remaining Unexpended Unexpended Balance Percent 42,445 48,625 249,731 115,385 456,186 28,676 9,474 1,612 104,676 872 113,636 -52,491 249,731 456,186 456,186 456,186 44.4 60.8 65.7 45.2 56.3 46.6 42.9 74.5 70.3 89.3 58.3 65.7 56.3 56.3 56.3 08/12/2009 7 Months 58.3% Completed 09:45:43 VILLAGE OF MOUNT PROSPECT 5 Months 41.6% Remaining FRRDBROl SUM031 Department Budget Expenditure Summary 01/01/09 - 07/31/09 Cur Mo Y-T-D 2009 Unexpended Unexpended HUMAN SERVICES Expended Expended Budget Balance Percent PROGRAM TOTALS 01 HUMAN SERVICES ADMINISTRATION 16,546 92,367 200,270 107,903 53.9 02 SOCIAL SERVICES 37,878 2l4,521 366,097 151,576 41.4 03 NURSING/HEALTH SERVICES 20,208 106,349 195,471 89,122 45.6 04 SENIOR CITIZEN LEIS ACTIVITIES 3,096 16,064 42,596 26,532 62.3 05 COMMUNITY CONNECTIONS CENTER 28,129 92,933 405,857 312,924 77.1 Totals 105,857 522,234 1,210,291 688,057 56.9 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 65,825 304,764 677,842 373,078 55.0 51 EMPLOYEE BENEFITS 21,549 124,876 238,166 113,290 47.6 52 OTHER EMPLOYEE COSTS 220 1,420 10,700 9,280 86.7 54 CONTRACTUAL SERVICES 7,277 41,000 138,968 97,968 70.5 55 UTILITIES 746 4,371 15,200 10,829 7l.2 57 COMMODITIES & SUPPLIES 764 6,656 56,750 50,094 88.3 64 BUILDING IMPROVEMENTS 9,081 30,458 43,470 13,012 29.9 65 OFFICE EQUIPMENT 395 8,689 29,195 20,506 70.2 Totals 105,857 522,234 1,210,291 688,057 56.9 SOURCE OF FUNDS 001 GENERAL FUND 105,857 522,234 1,210,291 688,057 56.9 Totals 105,857 522,234 1,210,291 688,057 56.9 9 08/12/2009 09:45:43 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 07/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 162,927 948,494 27,213 140,037 280 56,762 Totals 1,335,713 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 1,040,372 172,053 4,855 99,045 2,947 10,218 o 6,223 o Totals 1,335,713 SOURCE OF FUNDS 001 GENERAL FUND 060 LAW ENFORCEMENT BLOCK GRANT 080 ASSET SEIZURE FUND 085 DEA SHARED FUNDS FUND 086 DUI FINE FUND 1,334,792 o 921 o o Totals 1,335,713 10 Y-T-D Expended 1,735,638 5,000,219 141,606 746,975 18,409 417,429 8,060,276 5,310,753 1,785,384 88,316 770,431 18,375 68,083 3,172 15,762 o 8,060,276 8,052,007 o 7,416 o 853 8,060,276 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 58.3% 41. 6% Completed Remaining Unexpended Unexpended Balance Percent 1,570,686 3,780,060 111,182 558,356 12,001 295,461 6,327,746 4,011,602 1,617,323 68,184 533,459 20,025 54,337 14,378 8,438 o 6,327,746 6,331,515 o -5,416 1,000 647 6,327,746 47.5 43.1 44.0 42.8 39.5 41.4 44.0 43.0 47.5 43.6 40.9 52.1 44.4 81.9 34.9 44.0 44.0 -270.8 100.0 43.1 44.0 08/12/2009 09:45:43 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 07/31/09 FIRE Cur Mo Expended PROGRAM TOTALS 01 FIRE ADMINISTRATION 02 FIRE DEPARTMENT OPERATIONS 03 FIRE TRAINING ACADEMY 04 FIRE PREVENTION 05 FIRE COMMUNICATIONS 06 EQUIPMENT MAINTENANCE 07 EMERGENCY PREPAREDNESS PRGM 08 PAID-ON-CALL PROGRAM 10 FOREIGN FIRE INSURANCE 138,718 831,124 2,276 66,084 4,260 25,998 6,253 1,727 o Totals 1,076,440 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 53 PENSION BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 64 BUILDING IMPROVEMENTS 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 879,292 127,013 8,968 o 43,548 2,380 8,692 o o 6,547 Totals 1,076,440 SOURCE OF FUNDS 001 GENERAL FUND 095 FOREIGN FIRE TAX BOARD FUND 1,076,440 o Totals 1,076,440 Y-T-D Expended 1,296,418 4,395,717 4,512 335,198 30,444 179,272 56,298 11,827 8,237 6,317,923 4,327,185 1,488,354 58,356 473 279,436 16,026 90,411 3,887 199 53,596 6,317,923 6,309,686 8,237 6,317,923 2009 Budget 58.3% 41. 6% Completed Remaining Unexpended Unexpended Balance Percent 2,525,746 7,549,623 14,131 594,865 59,300 548,839 49,579 36,948 15,500 11,394,531 7,479,511 2,920,735 157,505 500 475,065 42,000 174,975 3,800 2,150 138,290 11,394,531 11,379,031 15,500 11,394,531 1,229,328 3,153,906 9,619 259,667 28,856 369,567 -6,719 25,121 7,263 5,076,608 3,152,326 1,432,381 99,149 27 195,629 25,974 84,564 -87 1,951 84,694 5,076,608 5,069,345 7,263 5,076,608 48.7 41.8 68.1 43.7 48.7 67.3 -13.6 68.0 46.9 44.6 42.1 49.0 62.9 5.4 41. 2 61. 8 48.3 -2.3 90.7 61. 2 44.6 44.5 46.9 44.6 08/12/2009 7 Months 58.3% Completed 09:45:43 VILLAGE OF MOUNT PROSPECT 5 Months 41.6% Remaining FRRDBROl SUM031 Department Budget Expenditure Summary 01/01/09 - 07/31/09 Cur Mo Y-T-D 2009 Unexpended Unexpended PUBLIC WORKS - ADMINISTRATION Expended Expended Budget Balance Percent PROGRAM TOTALS 01 PUBLIC WORKS ADMINISTRATION 118,988 787,025 1,390,732 603,707 43.4 Totals 118,988 787,025 1,390,732 603,707 43.4 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 25,145 132,872 256,740 123,868 48.2 51 EMPLOYEE BENEFITS 12,919 83,229 145,597 62,368 42.8 52 OTHER EMPLOYEE COSTS 2,838 15,694 30,802 15,108 49.0 54 CONTRACTUAL SERVICES 76,085 536,027 920,101 384,074 41. 7 55 UTILITIES 1,260 8,171 20,837 12,666 60.8 57 COMMODITIES & SUPPLIES 741 10,777 14,909 4,132 27.7 65 OFFICE EQUIPMENT 0 0 1,123 1,123 100.0 67 OTHER EQUIPMENT 0 255 623 368 59.1 Totals 118,988 787,025 1,390,732 603,707 43.4 SOURCE OF FUNDS 001 GENERAL FUND 118,988 787,025 1,390,732 603,707 43.4 Totals 118,988 787,025 1,390,732 603,707 43.4 08/12/2009 09:45:43 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 07/31/09 PUBLIC WORKS - STREETS/BLDGS Cur Mo Expended PROGRAM TOTALS 01 STREET DIVISION ADMINISTRATION 02 MAINTENANCE - PUBLIC BUILDINGS 04 STREET MAINTENANCE 05 SNOW REMOVAL 06 LEAF REMOVAL 07 STORM SEWER & BASIN MAINT 08 MAINTENANCE OF STATE HIGHWAYS 09 TRAFFIC SIGN MAINTENANCE 10 VILLAGE PARKING LOT MAINT 11 PARKING LOT MAINTENANCE 12 FLOOD CONTROL 13 STORM EVENT 15,033 96,913 98,347 15,335 o 22,171 3,136 17,759 5,510 11,983 o o Totals 286,187 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 144,061 36,357 38,232 6,904 133 5,174 o o o 55,326 Totals 286,187 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 620 VILLAGE PARKING SYSTEM FUND 630 PARKING SYSTEM REVENUE FUND 268,694 o 5,510 11,983 Totals 286,187 13 Y-T-D Expended 90,586 510,736 222,630 579,376 o 104,659 30,906 67,101 41,550 74,137 o o 1,721,681 820,143 228,592 331,276 15,962 932 267,050 o o o 57,726 1,721,681 1,412,667 193,327 41,550 74,137 1,721,681 2009 Budget 58.3% 41.6% 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 62,455 499,188 335,044 81,456 o 84,761 50,304 60,933 89,934 69,766 o o 1,333,841 457,230 138,868 389,603 68,268 666 133,006 o 13,056 5,870 127,274 1,333,841 1,068,036 106,105 89,934 69,766 1,333,841 40.8 49.4 60.1 12.3 44.7 61. 9 47.6 68.4 48.5 43.7 35.8 37.8 54.0 81. 0 41. 7 33.2 100.0 100.0 68.8 43.7 43.1 35.4 68.4 48.5 43.7 08/12/2009 09:45:43 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Swmnary 01/01/09 - 07/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 24,635 59,801 89,760 6,138 Totals 180,334 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT 90,196 23,598 564 62,213 3,763 o Totals 180,334 SOURCE OF FUNDS 001 GENERAL FUND 690 RISK MANAGEMENT FUND 180,334 o Totals 180,334 14 Y-T-D Expended 133,505 264,235 479,392 50,445 927,577 431,911 134,956 1,701 306,577 33,707 18,725 927,577 927,577 o 927,577 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 58.3% 41. 6% Completed Remaining Unexpended Unexpended Balance Percent 93,010 273,702 708,741 52,541 1,127,994 316,381 97,067 1,961 636,161 40,842 35,582 1,127,994 1,116,494 11,500 1,127,994 41.1 50.9 59.7 51. 0 54.9 42.3 41. 8 53.5 67.5 54.8 65.5 54.9 54.6 100.0 54.9 08/12/2009 09:45:43 FRRDBROl SUM031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 07/31/09 7 Months 5 Months 58.3% 41. 6% Completed Remaining Cur Mo Y-T-D 2009 Unexpended Unexpended PUBLIC WORKS - ENGINEERING Expended Expended Budget Balance Percent PROGRAM TOTALS 01 ENGINEERING SERVICES 96 , 129 488,143 830,223 342,080 41.2 05 TRAFFIC CNTRL & STREET LGHTNG 116,086 297,199 721,493 424,294 58.8 Totals 212,215 785,342 1,551,716 766,374 49.4 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 86,251 415,381 683,255 267,874 39.2 51 EMPLOYEE BENEFITS 20,769 118,279 197,263 78,984 40.0 52 OTHER EMPLOYEE COSTS 0 2,782 5,552 2,770 49.9 54 CONTRACTUAL SERVICES 4,874 47,826 156,907 109,081 69.5 55 UTILITIES 17,489 107,359 225,000 117,641 52.3 57 COMMODITIES & SUPPLIES 1,556 9,242 32,855 23,613 71. 9 65 OFFICE EQUIPMENT 0 0 546 546 100.0 67 OTHER EQUIPMENT 0 0 1,638 1,638 100.0 69 INFRASTRUCTURE 81,276 84,473 248,700 164,227 66.0 Totals 212,215 785,342 1,551,716 766,374 49.4 SOURCE OF FUNDS 001 GENERAL FUND 112,326 596,242 1,066,146 469,904 44.1 050 MOTOR FUEL TAX FUND 99,889 189,100 485,570 296,470 61.1 Totals 212,215 785,342 1,551,716 766,374 49.4 15 08/12/2009 09:45:43 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 07/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 116,507 27,198 17,236 57,910 144,813 42,584 41,055 55,819 29,945 240,050 296,583 Totals 1,069,700 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 211,269 61,536 2,171 431,504 11,853 5,856 11,790 o o 97,853 235,868 Totals 1,069,700 SOURCE OF FUNDS 610 WATER AND SEWER FUND 1,069,700 Totals 1,069,700 16 Y-T-D Expended 733,855 107,820 48,586 294,281 510,435 182,608 168,365 390,730 222,575 396,245 1,724,860 4,780,360 972,854 354,876 14,608 2,653,713 74,670 40,994 69,128 o 301 287,455 311,761 4,780,360 4,780,360 4,780,360 2009 Budget 58.3% 41.6% Completed Remaining Unexpended Unexpended Balance Percent 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 691,727 96,166 52,472 735,856 581,973 209,562 222,413 279,093 893,288 1,919,255 2,053,140 7,734,945 902,094 282,702 34,822 3,398,641 116,274 29,282 167,237 o 7,274 771,340 2,025,279 7,734,945 7,734,945 7,734,945 48.5 47.1 51.9 71.4 53.3 53.4 56.9 41.7 80.1 82.9 54.3 61.8 48.1 44.3 70.4 56.2 60.9 41.7 70.8 96.0 72.9 86.7 61.8 61.8 61.8 08/12/2009 09:45:43 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 07/31/09 PUBLIC WORKS - REFUSE DISPOSAL Cur Mo Expended PROGRAM TOTALS 01 REFUSE DISPOSAL PROGRAM 02 REFUSE LEAF REMOVAL PROGRAM 323,067 14,691 Totals 337,758 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 20,312 6,015 o 309,195 25 2,211 o Totals 337,758 SOURCE OF FUNDS 030 REFUSE DISPOSAL FUND 337,758 Totals 337,758 17 Y-T-D Expended 2,182,427 80,233 2,262,660 104,403 35,892 o 2,101,133 177 15,479 5,576 2,262,660 2,262,660 2,262,660 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 58.3% 41. 6% Completed Remaining Unexpended Unexpended Balance Percent 1,799,317 134,115 1,933,432 139,624 35,907 1,200 1,717,988 433 11,056 27,224 1,933,432 1,933,432 1,933,432 45.2 62.6 46.1 57.2 50.0 100.0 45.0 71.0 41. 7 83.0 46.1 46.1 46.1 08/12/2009 7 Months 58.3% Completed 09:45:43 VILLAGE OF MOUNT PROSPECT 5 Months 41.6% Remaining FRRDBROl SUM031 Department Budget Expenditure Swmnary 01/01/09 - 07/31/09 Cur Mo Y-T-D 2009 Unexpended Unexpended PUBLIC WORKS - VEHICLE MAINT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 VEHICLE MAINTENANCE ADMIN 17,910 97,431 189,625 92,194 48.6 02 VEHICLE MAINTENANCE PROGRAM 160,120 832,885 1,482,057 649,172 43.8 Totals 178,030 930,316 1,671,682 741,366 44.3 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 100,090 455,157 737,906 282,749 38.3 51 EMPLOYEE BENEFITS 25,846 144,160 239,272 95,112 39.8 52 OTHER EMPLOYEE COSTS 0 1,673 2,315 642 27.7 54 CONTRACTUAL SERVICES 11,481 66,147 88,017 21,870 24.8 55 UTILITIES 63 441 1,090 649 59.5 57 COMMODITIES & SUPPLIES 40,399 261,289 599,037 337,748 56.4 59 OTHER EXPENDITURES 0 0 0 0 65 OFFICE EQUIPMENT 0 0 545 545 100.0 67 OTHER EQUIPMENT 151 1,449 3,500 2,051 58.6 Totals 178,030 930,316 1,671,682 741,366 44.3 SOURCE OF FUNDS 660 VEHICLE MAINTENANCE FUND 178,030 930,316 1,671,682 741,366 44.3 Totals 178,030 930,316 1,671,682 741,366 44.3 18 08/12/2009 09:45:43 FRRDBROl SUM031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 07/31/09 7 Months 5 Months 58.3% 41.6% Completed Remaining Totals Cur Mo Y-T-D 2009 Unexpended Unexpended Expended Expended Budget Balance Percent 17,627 86,365 138,700 52,335 37.7 91,420 120,551 182,009 61,458 33.8 1,302 20,345 110,774 90,429 81. 6 166 1,465 2,897 1,432 49.4 110,515 228,726 434,380 205,654 47.3 COMMUNITY SERVICE PROGRAMS PROGRAM TOTALS 02 COMMUNITY GROUPS & MISC 03 4TH OF JULY & CIVIC EVENTS, ETC 04 HOLIDAY DECORATIONS 05 BLOOD DONOR PROGRAM EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES Totals 61,624 65,125 97,231 32,106 33.0 7,125 8,243 16,794 8,551 50.9 36,627 124,326 249,685 125,359 50.2 5,139 31,032 62,670 31,638 50.5 0 0 8,000 8,000 100.0 110,515 228,726 434,380 205,654 47.3 SOURCE OF FUNDS 001 GENERAL FUND 110,515 228,726 228,726 434,380 205,654 47.3 Totals 110,515 434,380 205,654 47.3 19 08/12/2009 09:45:43 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 07/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 o o 53,828 o 354,815 26,322 45,000 390,259 150,862 106,065 Totals 1,127,151 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 81,434 19,767 o 623,505 45,000 26,322 o 331,123 o o o Totals 1,127,151 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 o 647,186 53,828 354,815 o o 26,322 45,000 Totals 1,127,151 20 Y-T-D Expended 96,819 8,995 174,785 510,048 1,975,977 1,101,675 116,613 1,386,309 448,667 393,047 6,212,935 688,348 62,554 835 1,750,890 116,613 1,101,675 56,746 2,435,274 o o o 6,212,935 965,825 105,814 2,228,023 174,785 1,010,152 510,048 o 1,101,675 116,613 6,212,935 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 58.3% 41. 6% Completed Remaining Unexpended Unexpended Balance Percent 1,367,031 207,005 1,749,865 -275,048 2,208,723 1,433,825 71,537 6,991,691 1,585,333 1,843,953 17,183,915 1,126,372 1,654,696 61,965 9,197,690 278,537 1,433,825 1,744,804 1,686,026 o o o 17,183,915 362,275 1,439,036 10,555,977 1,749,865 1,846,448 -275,048 o 1,433,825 71,537 17,183,915 93.4 95.8 90.9 -117.0 52.8 56.5 38.0 83.5 77.9 82.4 73.4 62.1 96.4 98.7 84.0 70.5 56.5 96.9 40.9 73.4 27.3 93.2 82.6 90.9 64.6 -117.0 56.5 38.0 73.4 08/12/2009 09:45:43 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 07/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 o o 19,644 o Totals 19,644 EXPENDITURE CLASSIFICATION 59 OTHER EXPENDITURES 71 BOND PRINCIPAL 72 INTEREST EXPENSE 73 BANK AND FISCAL FEES 80 INTERFUND TRANSFERS o 16,909 2,735 o o Totals 19,644 SOURCE OF FUNDS 140 SERIES 1987A B&I, PW FACILITY 180 SERIES 2001 B&I, VILLAGE HALL 190 SERIES 2003 B&I, VILLAGE HALL 195 SERIES 2009 B&I, FD/PW 290 SERIES 1999 B&I, TIF 340 SERIES 1996A B&I, FLOOD 350 SERIES 1998A B&I, FLOOD 360 SERIES 1998C B&I, TIF 380 IEPA FLOOD CONTROL LOANS B&I 390 SERIES 2000 B&I, FLOOD CONTROL 830 SSA #6 GEORGE/ALBERT B&I o o o o o o o o 19,644 o o Totals 19,644 21 Y-T-D Expended 283,873 o 326,322 o 610,195 o 265,053 344,092 1,050 o 610,195 o 83,320 200,553 o o o o o 326,322 o o 610,195 2009 Budget 58.3% 41. 6% Completed Remaining Unexpended Unexpended Balance Percent 1,291,848 o 613,354 o 1,905,202 o 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 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 08/12/2009 09:45:43 FRRDBROl SUM031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 07/31/09 7 Months 5 Months 58.3% 41. 6% Completed Remaining Totals Cur Mo Y-T-D 2009 Unexpended Unexpended Expended Expended Budget Balance Percent 3,800 26,594 46,500 19,906 42.8 264,495 1,799,243 2,993,500 1,194,257 39.9 257,602 1,737,832 2,951,500 1,213,668 41.1 525,897 3,563,669 5,991,500 2,427,831 40.5 RETIREE PENSIONS PROGRAM TOTALS 01 MISCELLANEOUS PENSIONS 02 POLICE PENSIONS 03 FIRE PENSIONS EXPENDITURE CLASSIFICATION 53 PENSION BENEFITS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES Totals 525,312 3,561,499 5,984,500 2,423,001 40.5 585 2,170 5,000 2,830 56.6 0 0 2,000 2,000 100.0 525,897 3,563,669 5,991,500 2,427,831 40.5 SOURCE OF FUNDS 001 GENERAL FUND 710 POLICE PENSION FUND 720 FIRE PENSION FUND Totals 3,800 26,594 46,500 19,906 42.8 264,495 1,799,243 2,993,500 1,194,257 39.9 257,602 1,737,832 2,951,500 1,213,668 41.1 525,897 3,563,669 5,991,500 2,427,831 40.5 22 08/12/2009 09:45:43 FRRDBROl SUM03l VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 07/31/09 7 Months 5 Months 58.3'0 41.6'0 Completed Remaining Totals Cur Mo Y-T-D 2009 Unexpended Unexpended Expended Expended Budget Balance Percent 96,470 992,452 967,700 -24,752 -2.6 432,516 2,877,911 5,705,136 2,827,225 49.6 528,986 3,870,363 6,672,836 2,802,473 42.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 528,986 3,870,363 6,630,336 2,759,973 41.6 0 0 27,500 27,500 100.0 528,986 3,870,363 6,672,836 2,802,473 42.0 SOURCE OF FUNDS 690 RISK MANAGEMENT FUND Totals 528,986 528,986 3,870,363 6,672,836 2,802,473 42.0 3,870,363 6,672,836 2,802,473 42.0 23 08/12/2009 09:45:43 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 07/31/09 NON-DEPARTMENTAL Cur Mo Expended Y-T-D Expended 2009 Budget Unexpended Unexpended Balance Percent 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 58.3% Completed 41.6% Remaining o o o o o o o o o o o o 08/12/2009 09:45:43 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 07/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 58.3% 41. 6% Completed Remaining Unexpended Unexpended Balance Percent o o o o o o o o o o o o 08/12/2009 09:45:43 FRRDBROl SUM031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/09 - 07/31/09 7 Months 5 Months 58.3% 41.6% Completed Remaining Cur Mo Y-T-D 2009 Unexpended Unexpended MOUNT PROSPECT LIBRARY Expended Expended Budget Balance Percent PROGRAM TOTALS 02 LIBRARY SERVICES 0 0 9,450,626 9,450,626 100.0 Totals 0 0 9,450,626 9,450,626 100.0 EXPENDITURE CLASSIFICATION 90 COMPONENT UNIT EXPENDITURES o o 9,450,626 9,450,626 100.0 9,450,626 100.0 Totals o o 9,450,626 SOURCE OF FUNDS 950 MOUNT PROSPECT LIBRARY FUND o o 9,450,626 9,450,626 100.0 Totals o o 9,450,626 9,450,626 100.0 26 REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY AUG1l2009 13:22 RELEASE 10 : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 3D 2009 TO AUGUST 12 2009 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 001 11451 A STARS & STRIPES FLAG CORPORATION BANNER MATERIALS 2059.80 11660 ABERNETHY, JANET EMPLOYEE RECOGNITION REIMB EXP 10.00 01227 AIR ONE EQUIPMENT, INC. 1 Rescue Air Pack MSA for Engi 2200.00 SHIPPING FEE 10. DO VARIOUS FIREFIGHTER PLUS GLOVE 515.00 ------------- 2725. DO 01246 AIRGAS NORTH CENTRAL OXYGEN TANK SUPPLIES 197.08 01335 ALEXIAN BROTHERS CORPORATE HEALTH SERVICES RANDOM DOT DRUNG SCREENING 490.00 PRE-EMPLOYMENT PHYS: Y. NUNEZ 104.00 PRE-EMPLOYMENT PHSY: A. VALDEZ 104.00 PRE-EMPLOYMENT PHYS: K. SHEAGREN 104.00 ------------- 802.00 11665 ANDERSON, CAROLINE REBATE 6 SQ OF PUBLIC WALK 294.00 11257 ANGAROLA, MICHAEL REIMB EXP 7/21/09-7/23/09 24.00 02108 ARLINGTON POWER EQUIPMENT REPLACEMENT TRIMMER LINE AND S 501.34 CREDIT 0.02- ------------- 501.32 01124 ARTHUR CLESEN, INC. 75 - 20 GALLON GATOR BAGS 1111.5 0 04215 AUTUMN TREE CARE EXPERTS FERTILIZATION OF SELECTED TREE 96.64 11670 BAHENA, ALFONSO REFUND OVER PYMT P#3889712 18.00 02599 BAYMONT INNS & SUITES A.LIETZO\'I-CRIMINAL ST. GANG CO 239.40 06287 BEDCO MECHANICAL 2009 MAINTENANCE CONTRACT FOR 128 7.5 5 02686 BEN MEADOWS COMPANY, INC. CLOTHING ALLOWANCE-D. RANDOLPH 47.7I 10708 BILL HUFFMAN LANDSCAPE SERVICE RETAINER RELEASE 4/24/08 150.00 RETAINER RELEASE 5/09/08 848.75 ------------- 998.75 08618 BLUE CROSS/BLUE SHIELD REFUND WRONG DATE OF SERVICE 306.53 05339 BOUND TREE MEDICAL, LLC AED CABINET / SURFACE MOUNT/ALAR 188.10 01014 CADE INDUSTRIES CUSTODIAL SUPPLIES FOR THE MON 3286.50 05707 CASH DONATION PUBLIC WORKS PICNIC 500.00 01049 COW GOVERNMENT / INC BLUETOOTH CAR KIT T305 118.37 HP LJ 5500 TONER - BLACK - COW 199.00 REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY AUG1l2009 13:22 RELEASE 10 : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 30 2009 TO AUGUST 12 2009 - - - - - - -... - - - -..... - - -......... --.............................. -.......... -.................................................................... --..................................................................................................................................................... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ............................................. -...................................... --...................................................................................................................... -............................................................................................- HP LJ 5500 TONER - YELLOW - CD 298.00 HP LJ 5500 TONER - MAGENTA - C 298.00 HP LJ 5500 TONER - CYAN - COW 298.00 SHIPPING 14.99 ET SUPPLIES 7.57 ------------- 1233.93 01077 CHICAGO COMMUNICATIONS LLC 1 VRM REPAIR 580.00 11663 CHLOPEK, CHRIS REBATE 4 SQ PUBLIC WALK 192.00 01097 CINTAS CORP REPLACEMENT SWEATSHIRT - 124.98 07281 CL GRAPHICS, INC. VILLAGE BOARD CITIZENS GUIDE 551.31 EXPERIENCE MT. PROSPECT-PRINT 250.00 EXPERIENCE MT. PROSPECT-MAIL 196.20 SPANISH COMM.GUIDE PRINTIGN 385.55 SPANISH COMM GUIDE LAYOUT&DESI 410.00 ------------- 1793.06 03800 CLARK, SANDRA M. CLOTHING ALLOWANCE 6/27/09 55.53 11664 CONNOLL Y, MI KE REBATE 8 SQ PUBLIC WALK 392.00 00309 COONEY, WILLIAM J. REIMB EXP- ICSC CONFERENCE05/09 113 4.3 3 11403 COSTAR REALTY INFORMATION, INC ED SITE SOFTWARE 435.00 01200 CRAIN'S CHICAGO BUSINESS 2009-2010 SUBSCRIPTION 97.95 06745 CROWN TROPHY RIBBONS FOR FINE ARTS FESTIVAL 47.40 05503 CRYSTAL MAINTENANCE SERVICES CORP. 2009 CUSTODIAL CONTRACT - PUBL 8882.83 01218 DAHLBERG, JOHN REIMB EXP 7/23,28,29,30&8/3/09 457.13 03916 DECATUR ELECTRONICS, INC. RADAR REPAIRS & LABOR 206.45 RADAR REPAIR, LABOR, CERTIF. 906.15 --..---------.. 1112.60 11650 DIGHE, VIKAS REFUND-OVERCHARGED FOR NEW CAR 27.00 09653 ETERNO, DAVID G. PROFESSIONAL SERV JULY 2009 375.00 01377 FEDERAL EXPRESS CORP COURIER SERVICES 2009 34.56 FED EX SHIPPING-PLANNING DIV. 14.09 ----...-------- 48.65 00331 FIGOLAH, MI CHAEL REIMB EXP LUNCH MEETING7/20/09 110 . 62 11667 FIORITO, MATTHEW REBATE 12 SQ PUBLIC WALK 588.00 REBATE 13 LINFT CURB & GUTTER 97.50 ------------- REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY AUG1l2009 13:22 RELEASE 10 : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 30 2009 TO AUGUST 12 2009 ----------------------------------------------------------------------------------------------------------------------------------- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT -... -... - - - - -... - - - - -... - -... -..................... -... -... -............... -...... -...... -... - -...... -... -... -............ -...... - - - - - - -... - - - -........................... -... - - - - - - -...... -... - - - - - -...... - - - - - - -......... - - -...... - - -... -...... -... --...... 685.50 05334 FIRST SECURITY SYSTEMS, INC. SERVICE TO REPAIR - SOUTH STAI 242.50 01432 FOX VALLEY SYSTEMS INC. 3 CASES-EASY MARKER PAINT 146.78 01461 GALL'S, INC. SUSPENDERS FOR ARSON GEAR 23.18 09198 GE CAPITAL CD ADMIN 7/15/09-8/14/09 192.74 CD BUILDING 7/15/09-8/14/09 192.74 CD HOUSING 7/15/09-8/14/09 192.74 CD HEALTH 7/15/09-8/14/09 192.74 ------------- 770.96 11649 GPS INTELLIGENCE LLC AIRTIME FEES - ONE YEAR 360.00 01522 GRAINGER INC. 4A260 CONNECTOR BODY-AMBULANCE 38.07 08725 GREAT LAKES IPM INC. GYPSY MOTH LURE AND VAPORTAPE 53.20 10386 GUZIEL, FRAN MARKETING CONSULTING-JULY09 1877.50 08638 HELM, MARTHA REIMB EXP 7/27 /09S0USA CONCERT 83.70 10322 HIGHWAY TECHNOLOGIES, INC. BARRICADE RENTAL 210.56 325 TYPE I FLASHING BARRICADES 2000.00 ------------- 2210.56 01610 HOME DEPOT CREDIT SERVICES CCC-KITCHEN CABINETS&COUNTER 138 8.5 0 10719 HORIBA INTERNATIONAL CORPORATION ET SUPPLIES 158.43 09425 HSBC BUSINESS SOLUTIONS GATORADE- LIONS CARNIVAR 65.94 WIPES, COFFEE, FILTERS 49.18 15 BAGS OF CANDY-4TH OF JULY 163.35 REFRESHMENTS-CHILD SAFETY 45.97 4TH OF JULY PARADE SUPPLIES 359.14 4TH OF JULY PARADE SUPPLIES 89.97 BLOCK PARTY SUPPLIES 195.37 CLOSED SESSION MEETING-FOOD 11.28 COFFEE SUPPLIES 23.98 WATER FOR WELLNESS LUNCH 5.93 ---...--------- 1010.11 06690 ILLINOIS AMERICAN WATER CO. SERV 7/1/09 - 8/3/09 229.76 07430 ILLINOIS ENVIRONMENTAL HEALTH ASSC. 09 FOOD SAFETY CONF. -C. SCHERBAU 50.00 09FOOO SAFETY CONF.-R.GARCIA 50.00 ----_.....------ 100.00 01743 INTERNATIONAL ASSOCIATION OF FIRE CHIEFS MEMBERSHIP 09-10 TRUTY,CHRIS 204.00 07694 INTERNATIONAL CODE COUNCIL SUBSCRI PT IONS /VALENT I NE 180.00 REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY AUG1l2009 13:22 RELEASE I D : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 30 2009 TO AUGUST 12 2009 ----------------------------------------------------------------------------------------------------------------------------------- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ................ -.............. -.................................. -.... - --................................. -............................ -............................................ -...... -.. -..................... -...................................... 01753 I PELRA REGISTRATION-J.MALCOLM 9/18/09 55.00 09563 IRS BALANCE DUE 2ND QUARTER 941 454.43 01783 JOURNAL & TOPICS NEWSPAPERS JULY AD-BLOCK PARTY 2009 288.90 AD-JULY INV#I29526 288.90 BLOCK PARTY SPECIAL SEC#I29527 735.00 ------------- 1312.80 10528 KAST, RYAN EMPLOYEE RECOGNITION-REIMB EXP 10.00 01818 KERSTEIN, JUNE REIMB EXP JUNE09 & JULY09 105.77 09911 LAMINATOR WAREHOUSE 2 - Rolls of Laminate Film 213.88 01861 LANDS I END BUSINESS OUTFITTERS CLOTHING EXP BUILDING DEPT. 493.44 08631 LECHNER AND SONS 2009 UNIFORM RENTAL AND CLEANI 243.56 10450 LEXISNEXIS PRE-EMPLOYMENT BACKGROUND CK 56.20 09606 LIETZOW, ANTHONY REIMB EXP 7/21/09-7/23/09 84.00 11641 LIVING BLUES MAGAZINE QUARTER PAGE AD-BLUES FEST 392.00 01918 LUNDSTROM I S NURSERY, INC. 2009 LANDSCAPE MAINTENANCE CON 2464.98 CREEK BANK RAKING & WEED WHIP 380.00 2009 TURF MOWING CONTRACT 3529.94 ------------- 6374.92 09238 LYONS, PATRICK REIMB EXP. 6/29/09-7/1/09 201.58 10857 MABAS DIVISION 3 MABAS DIV. 3 COMPANY DRILLS 1545.24 10527 MCINTOSH PHOTOGRAPHY PHOTOGRAPHY SER-ART&BLUES FEST 350.00 PHOTOGRAPHY SERV-4TH JULY 125.00 PHOTOGRAPHY SERV- BLOCK PARTY 200.00 ------------- 675.00 05709 MEADE ELECTRIC CO. INC. PARTS&LABOR EMERGENCY VEHICLE 497.58 06719 METEORLOGIX ANNUAL RENTAL OF WEATHER 819.29 ANNUAL RENTAL OF WEATHER 50.71 -----....._----- 870.00 00395 MICHALIK, JOEL CLOTHING ALLOWANCE 7/09 200.00 02046 MOBILE PRINT INC. EXPERIENCE MT PROSPECT POSTERS 189.15 BLOCK PARTY POSTERS 348.80 MEMO PADS-DAVE ERB 30.07 1500 ARREST JACKETS 698.40 ------------- REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY AUG112009 13:22 RELEASE I D : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 30 2009 TO AUGUST 12 2009 -- -- --- - - ------ -- - --- ---- -- --... -... --- - - ---- -- --...... ---- --------- -- - --- - - --- ----- -- - - - -...... -------......... - -...... ----- - ---- -... ---- --... ---... - --... --_..._- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - -... - - - -... -......... - -............ -.................. -......... -........................... - - - - - - -...... -............ - -................................................ -- -..................... -......... -............................................................ -............ -......... -..........................................- 1266.42 02072 MOUNT PROSPECT PUBLIC LIBRARY REIMB.EXP FRENCH NIGHT 7/14/09 78.75 COMPUTER EQUI PMENT 1103.71 FIBER O. INSTALL VILL. INTERNET 2791.86 ------------- 3974.32 11102 MOUNT PROSPECT/PROSPECT HEIGHTS ROTARY CLUB APRIL-JUNE09 MEMBERSHIP 143.00 02087 MUNICIPAL CLERKS OF ILLINOIS MEMBERSHIP 10/1/09-9/30/10 85.00 02148 NEOPOST INC. MONEY ENTERED POSTAGE MACHINE 3000.00 11375 NETZEL, CHARLES REBATE 14 SQ OF PUBLIC WALK 686.00 23 LIN FEET OF CURB 172 .5 0 ------------- 858.50 04191 NEW PIG CORPORATION Chemical Suppliess for Inciden 1007.70 02155 NEXTEL COMMUNICATIONS SERV 6/18/09-7 /l7 /09 718.25 SERV 6/18/09-7 /l7 /09 156.02 SERV 6/18/09-7/l7 /09 136.80 SERV 6/18/09-7 /l7 /09 685.18 SERV 6/18/09-7 /l7 /09 25.57 SERV 6/18/09-7 /l7 /09 287.46 SERV 6/18/09-7 /l7 /09 1128.60 SERV 6/18/09-7 /l7 /09 240.00 SERV 6/18/09-7 /l7 /09 261.80 SERV 6/18/09-7 /l7 /09 461.72 SERV 6/18/09-7 /l7 /09 22.71 SERV 6/18/09-7 /l7 /09 330.83 ------------- 4454.94 05256 NICOR ACCT#97-78-90-2800-4 26.38 ACCT#03- 35-77-9926-5 26.38 ACCT#6076140000-5 934.45 ACCT# 3 0 4 8 3 4 0 000- 5 144.63 ACCT#8861879971-7 1259.43 ACCT#69022600000-6 171. 44 ACCT#2907270000-7 48.72 ------------- 2611.43 02170 NORTH EAST MULTI REGIONAL TRNG REGISTER c.cHARAK&J. ZIOLKOWSKI 550.00 05843 NORTHSHORE OMEGA VACCINATION-J. DAHLBERG 70.00 02189 NORTHWEST CENTRAL DISPATCH SYS SEPTEMBER 09 MEMBER ASSESSMENT 39558.70 SEPTEMBER 09 MEMBER ASSESSMENT 9889.68 -...----------- 49448.38 05124 NORTHWESTERN UNIVERSITY CTR FOR PUBLIC SAFETY REGISTER R. SMITH & S. SULLIVAN 3000.00 REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY AUG1l2009 13:22 PAGE RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 30 2009 TO AUGUST 12 2009 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - - -- - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- 11504 O'NElL, PAIGE REIMB OTAINING CDL 50.00 10476 PACIFIC TELEMANAGEMENT PAY PHONE SERV AUGUST 2009 78.00 07863 PACON CORPORATION SIGN MATERIALS 225.00 SIGN MATERIALS 489.00 SIGN MATERIALS 73.38 ------------- 78 7.3 8 02301 PETTY CASH - FINANCE DEPT. MISCELLANEOUS PETTY CASH 07/09 7.92 MISCELLANEOUS PETTY CASH 07/09 14.64 MISCELLANEOUS PETTY CASH 07/09 12.16 MISCELLANEOUS PETTY CASH 07/09 100.00 MISCELLANEOUS PETTY CASH 07/09 34.43 MISCELLANEOUS PETTY CASH 07/09 22.80 MISCELLANEOUS PETTY CASH 07/09 233.52 MISCELLANEOUS PETTY CASH 07/09 15.00 MISCELLANEOUS PETTY CASH 07/09 21.99 MISCELLANEOUS PETTY CASH 07/09 42.71 MISCELLANEOUS PETTY CASH 07/09 14.00 MISCELLANEOUS PETTY CASH 07/09 2.91 ------------- 522.08 11446 PHOTODON, LLC Toughbook Screen Protectors 61.70 10258 POWELL TREE CARE, INC. 2009 PARKWAY TREE REMOVAL CONT 20031.50 2009 PARKWAY TREE REMOVAL CONT 6486.50 ------------- 26518.00 06148 PREClSlON MIDWEST SPECTRA PREClSlON #LL400 LASER 132 6.2 5 06592 PRO-TECH SECURITY SALES TRAINING SUPPLIES 110.00 02536 PROFORMA CUSTOMIZED GRAPHICS REPLACEMENT NAME BADGES - PW S 118.00 10271 RANDALL INDUSTRIES, INC. PARADE RENTALS 1l12.40 02444 RIVER TRAILS PARK DISTRICT 144 DODGEBALL SHIRTS 492.48 07964 RMS BUSINESS SYSTEMS, INC. 2 CISCO POE3560G 24PORT SWITCH 8716.00 11472 RYAN, ELISE RElMB OBTAINING CDL 50.00 00425 RZEPECKI, ROBERT L. REIMB EXP 7/25/09-7/29/09 728.04 11659 SANTEE, JOHN C. REFUND OVER PYMT BUSINESS L. 10.00 10445 SCHERBAUM, CHERYL REIMB CLOTHING ALLOWANCE 7/23 150.00 10717 SCHNEIDER, ELIZABETH REIMB OBTAINING CDL 50.00 11640 SIERRO, LUPE REFUND OVER PYMT P#3887245 2.00 05975 SIGNS BY TOMORROW LIGHT POLE BANNERS 2000.00 REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY AUG1l2009 ]]: 22 RELEASE 10 : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 30 2009 TO AUGUST 12 2009 ----------------------------------------------------------------------------------------------------------------------------------- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- LIGHT POLE BANNERS 2653.90 ------------- 4653.90 10715 SIMMONS, BRIAN REIMB EXP 7/31/09 209.91 11666 SKOPIS, ALEX REBATE 8 SQ PUBLIC WALK 392.00 11639 SOFIANOS, THERESA M. REFUND OVER PYMT P#3888845 10.00 02583 SOUND INCORPORATED VOICE MAlL ANNUAL MAINTENANCE 15.36 VOICE MAlL ANNUAL MAINTENANCE 53.76 VOICE MAIL ANNUAL MAINTENANCE 46.08 VOICE MAlL ANNUAL MAINTENANCE 49.92 VOICE MAlL ANNUAL MAINTENANCE 53.76 VOICE MAlL ANNUAL MAINTENANCE 184.32 VOICE MAIL ANNUAL MAINTENANCE 53.76 VOICE MAlL ANNUAL MAINTENANCE 69.12 VOICE MAlL ANNUAL MAINTENANCE 124.80 VOICE MAlL ANNUAL MAINTENANCE 36.48 VOICE MAlL ANNUAL MAINTENANCE 36.48 VOICE MAlL ANNUAL MAINTENANCE 174.72 VOICE MAIL ANNUAL MAINTENANCE 675.84 VOICE MAlL ANNUAL MAINTENANCE 345.60 ------------- 1920.00 04951 SUBURBAN ACCENTS INC. GRAPHICS- 3DAYS CANCER WALK 650.00 11644 SULLIVAN, DAN REBATE 3 SQ OF PUBLIC WALK 147.00 07187 SUPERIOR WIRELESS 10 CELL PHONE HOLSTERS 90.00 11658 SUTLAN, SHEIKH REFUND OVER PYMT P#3889049 10.00 09903 S YMBOLART S, LLC UNIFORM BADGES INV#01l5894- IN 140.00 UNIFORM BADGES INV#01l5825- IN 350.00 UNIFORM BADGES INV#0l15509- IN 310.00 ------------- 800.00 09668 T.P.1. PLUMBING INSPECTIONS 405.00 BUILDING INSPECTIONS 4662.00 ------------- 5067.00 01238 THE DAVEY TREE EXPERTS COMPANY REMOVE/TREAT GYPSY MOTH EGG 2543.00 113 64 THE GUTHRIE PARTNERS WEB SITE REDESIGN&EBLASTS 1356.67 04014 THE UPS STORE VISION INTERNET CONTRACT 28.74 11662 THOMAS CURTIS REIMB OBTAINING CDL 50.00 02691 THOMPSON ELEVATOR INSPECTIONS 25 SEMI -ANNUAL ELEVATOR INSP. 925.00 11652 TODAY'S UNIFORMS REPLACEMENT DAMAGED UNIFORM 55.99 REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY AUG112009 13: 22 RELEASE 10 : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 30 2009 TO AUGUST 12 2009 ----------------------------------------------------------------------------------------------------------------------------------- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ...... -.... - - -.. - -............ -.................... - -............ -.......... -.. - -...... -........ -.......... - -.. -........ -.... - -.... - -.... - - -.... -........ - - -.............. - -................ - - -.................................... 04276 TRUGREEN-CHEMLAWN WEED CONTROL -HIST .BUILDING 30.00 11277 TYGRIS VENDOR FINANCE, INC POLICE ADMIN 8/09 467.29 POLICE INVEST 8/09 321.91 FIRE DEPT 8/09 456.90 CLERKS 8/09 830.73 CD ADMIN 8/09 16.80 CD BUILDING 8/09 16.80 CD HOUSING INSPECTION 8/09 16.80 CD HEALTH INSPECTION 8/09 16.80 ------------- 2144.03 08526 ULTIMATE PLUMBING SUPPLY CCC-PLUMBING SUPPLIES 1332.30 CCC-PLUMBING SUPPLIES 59.84 ------------- 1392.14 07526 UNITED PARCEL SERVICE MISCELLANEOUS SHIPPING CHARGES 15.91 SHIPPING CHARGES-EQUIP REPAIRS 35.04 ------------- 50.95 11668 UNITED STATES FIRE PROTECTION, INC CCC: FIRE SUPPRESSION SYSTEM 7600.00 02756 UNITED STATES POSTAL SERVICE EMS CARDS JULY09 35.58 EMS CARDS JULY09 3.81 EMS CARDS JUL YO 9 3.81 PUBLIC INFORMATION JULY09 94.16 ------------- 137.36 04025 UNIVERSITY OF ILLINOIS - GAR REGISTER CLASS -FRANK RAUS 250.00 10531 VCG UNIFORM BIKE UNIT UNIFORM SUPPLIES 673.90 BIKE UNIT UNIFORM SUPPLIES 886.80 Various Uniforms 1495.20 17 PEER JURY SHIRTS 344.00 ------------- 3399.90 11669 VENIT, STEVEN REFUND OVER PYMT P#3889399 10.00 09527 VILLAGE CYCLESPORT BICYCLE EQUIPMENT 219.46 02802 VILLAGE OF ARLINGTON HEIGHTS Registration/ Schmitt July 6 F 450.00 02810 VILLAGE OF MOUNT PROSPECT EMERGENCY FOOD PANTRY 780.00 05700 VILLAGE PROFILE AD-MT PROSPECT CHAMBER OF COMM 2995.00 11657 VISION INTERNET PROVIDERS, INC WEB SITE PROJECT 1ST INSTALL 12750.00 02835 WAREHOUSE DIRECT TONER CATRIDGES PHOTO PRINTER 130.26 CERTIFICATES & HOLDERS 67.31 SUPPLIES 352.72 lEPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESOAY AUG1l2009 13:22 RELEASE 10 : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 30 2009 TO AUGUST 12 2009 PAGE DEPT VENDOR NBR INVOICE DESCRIPTION ----- -- -.... - ---.. -- ---.. ---...... -- -- -- -- --.......... --- --- -----.. ---.. -- --- ------------ ---.. --.. ---.. --- ------.......... ------ ------........ -- --- -- --.... ---.. AMOUNT VENDOR NAME ..................... --........................................................................................................................................ --...................................................................................... --...... PHOTO PAPER 1 DATE STAMP LIFTER EASY FLOW INV#3BB29B-0 22B41PAPER LETTER INV#3BB29B-0 CREDIT C3B829B-O LIFTER EASY FLOW INV#3B9307-1 LIFTER E.F &PAPER INV#389307-0 3 AVERY DIVIDERR INV#385379-0 10BOXES PAPER INV#387475-0 CERTIFICATE&HOLDER #38799B-0 . CREDIT INV#387998-0 CERTIFICATE&HOLER #38B739-0 OFFICE SUPPLIES INV#406656-0 OFFICE SUPPLIES INV#3B4939-0 OFFICE SUPPLY#399144-0/399623 05476 WGN FLAG & DECORATING CO. 02876 WILKS, IRVANA 06001 WINKLER'S TREE SERVICE 112 94 WPS MEDICARE 00464 WULBECKER, JEFFREY 11646 WORBIA, ANITA 11645 ZAOCHA, MIKE 4TH JULY PARADE DECORATIONS PHONE SERV 7/16-B/15/09 2009 PARKWAY TRIMMING CONTRACT REFUND DUPLICATE PYMT CLOTHING ALLOWANCE 7/14&7/24 REBATE 4SQ OF PUBLIC WALK REBATE 12 SQ OF PUBLIC WALK TOTAL 30 02016 JULY 2009 COLLECTIONS JULY 2009 COLLECTIONS JULY 2009 COLLECTIONS JULY 2009 COLLECTIONS JULY 2009 COLLECTIONS ARC DISPOSAL COMPANY 11655 REFUND CREDIT BALANCE REFUSE CATTAPAN, PETER 11654 REFUND CREDIT BALANCE REFUSE DALE I RACHEL 11656 REFUND CREDIT BALANCE REFUSE OVIGIAN, JOSEPH 098B7 SCHAEFER SYSTEMS INTERNATIONAL, INC. 125 - 95 GALLON BLUE RECYCLING FREIGHT 69.98 35.96 25.44 132.08 132.08- 15.90 593.1B 79.95 279.50 15.04 15.04- 21.12 258.67 15B .11 1190.00 3278.10 1727.17 45.00 B973.72 341.00 67.73 196.00 5B8.00 233028.B3 97578.11 49394.71 35539.90 70B1.47 15B3.53 191177.72 12.50 12.50 12.50 5796.00 B05.00 50 TOTAL 197B16.22 6601.00 ~EPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY AUGll2009 13:22 PAGE 10 RELEASE I D : VILLAGE OF MOUNT PROSPECT LI ST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 30 2009 TO AUGUST 12 2009 ................ - -............ --............................................. --_................. --............................................................................................................................................ --............................... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRI PTION AMOUNT '....... --..... -....... -........ --.................. --.......................................... --............................................ --.......... ---....................... --......................................................................... 10103 CIVILTECH ENGINEERING, INC. CONTRACT FOR ENGINEERING 7846.99 04355 COOK COUNTY TREASURER TRAFFIC SIGNAL MAINT 4/1-6130 2840.50 11377 GAFFNEY I S PROTECTIVE MAl NT. INC CONSTRUCTION CONTRACT FOR THE 81185.24 07373 H & H ELECTRIC CO. SIDEWALK REPLACEMENT TRAFFIC L 2118.60 05709 MEADE ELECTRIC CO. INC. 2009 TRAFFIC SIGNAL MAINTENANC 2325.30 TOTAL 96316.63 70 01377 FEDERAL EXPRESS CORP FED EX SHIPPING-PLANNING DIV. 18.40 09198 GE CAPITAL CDBG 7/15/09-8/14/09 192.74 01796 K.A.M. CONSTRUCTION SINGLE FAMILY REHAB-616N.WILLE 13367.40 11277 TYGRIS VENDOR FINANCE, INC CDBG 8/09 16.80 TOTAL 13595.34 85 06592 PRO-TECH SECURITY SALES TRAINING SUPPLIES 7350.00 TOTAL 7350.00 10 01227 AIR ONE EQUIPMENT, INC. 1 Breathing Air Compressor W/F 42611.00 3 - Thermal Imaging Cameras 22522.33 ------------- 65133 .33 04434 GEWALT HAMILTON ASSOCIATES, INC. KENSINGTON RD IMPROVEMENT PY#l 27798.75 06420 GRAYBAR ELECTRIC CO. ELECTRICAL PARTS/LIGHTING 1829.26 ELECTRICAL PARTS/LIGHTING 1049.04 40 I HAPCO LIGHT POLE (4) 2275.00 40 I HAPCO LIGHT POLE (4) 5965.00 ------------- 11l18.30 10134 MR. DAVID I S FLOORING INTERNATIONAL,LTD REMOVAL, FLOOR PREP. AND INSTA 3347.s0 09216 UTILITY DYNAMICS CORP. INSTALL STREETLIGHT BASE/FOUND 3890.00 TOTAL 11l287.88 18 01227 AIR ONE EQUIPMENT, INC. 1 Breathing Air compressor W/F 42611.00 10321 BRUSSEAU DESIGN GROUP, LLC. RTPD SOFTBALL FIELD CD PHASE 122.50 CONSTRUCTION OBSERVATION SERV 430.70 ------------.. 553.20 REPORT: APBOARDRPT DEPT VENDOR NBR 11496 11255 06406 550 07730 01620 07267 01918 01965 11661 560 09218 i90 01918 01965 jl0 01543 02451 GENERATED: 15 APR 09 11:42 RUN: TUESDAY AUG1l2009 13: 22 RELEASE 1 D : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 30 2009 TO AUGUST 12 2009 VENDOR NAME INVOICE DESCRIPTION HORIGAN URBAN FOREST PRODUCTS, INC MIL1 AND KILN DRY RECLAIMED AS LEOPARDO COMPANIES, INC EOC - Construction Fire Station 14 - Construction Modifications at Public Works SRBL ARCHITECHTS, LTD. Archi tectural Services for Fir Architectural Services for Pub Archi tectural Services for the PAGE 11 AMOUNT 215.00 129937.00 312930.00 89336.00 532203.00 9849.78 5014.23 7462.00 TOTAL 597908.21 22326.01 ADVANCED PAVEMENT TECHNOLOGIES CLEAN BRICK PAVERS FOR FEST 09 2009 BRICK PAVER SEALING CONTR AMERICAN LANDSCAPING INC. TRIANGLE PARKING&BUSSE LANDSCA LPS PAVEMENT CO. BRICK REPAIRS TRIANGLE PARKING LUNDSTROM I S NURSERY, INC. 2009 LANDSCAPE MAINTENANCE CON MARTAM CONSTRUCTION REPAIRS TRIANGLE PARKING TMA AFFINITY CORPORATION LEGAL & FINANCING TOTAL 63912.65 16778.19 KLOA, INC. ENGINEERING SERVIST POST STUDY ENGINEERING SERV2ND POST STUDY 3050.10 15370.31 18420.41 4605.00 9665.00 530 5.0 5 9139.00 24067.78 18544.19 TOTAL 42611. 97 42611.97 LUNDSTROM I S NURSERY, INC. 60 HOURS AND $80.00 PER HOUR MARTAM CONSTRUCTION 2009 BACKYARD DRAINAGE PROGRAM TOTAL 153405.00 148905.00 AMERICAN BACKFLOW PREVENTION INC. TESTING&REPAIR BACKFLOW516E NW BADGER METER INC HBRASS FLANGE ASSY NUT&BOLTS CREDIT#42680 4500.00 285.00 349.59 212.85- 136.74 REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY AUGl12009 13:22 PAGE 12 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTEO TO THE BOARD OF TRUSTEES FROM JULY 30 2009 TO AUGUST 12 2009 .................. -- -...................................................... --......................................................................................................................................................................................... ---.......................................................................................... OEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ................................... --......... --..... -----......................... --................................... -- --...... --........................................ ---..... -_............ --..... -- --................................................................................................................ 05773 BAXTER & WOODMAN, INC. ENGINEERING SERVICES FOR 2009 19679.20 ENGINEERING SERVICES FOR 2009 19679.20 ENGINEERING SERV-411 N .MAPLE S 840.00 ------------- 40198.40 02938 BOWMAN DISTRIBUUQN CENTER BUILDING MATERIALS 281.48 11648 BRANDENBURG, WILLIAM REFUND FINAL UTILITY BILL 208.20 11655 CATTAPAN, PETER REFUND CREDIT BALANCE WATER 42.12 REFUND CREDIT BALANCE SEWER 23.59 ------------- 65.71 05005 CDS OFFICE TECHNOLOGIES PANASONIC TOUGHBOOK 30 RUGGEDI 4130.00 01049 CDW GOVERNMENT, INC MS OFFICE PRO LICENSE FOR PW - 301.34 11654 DALE, RACHEL REFUND CREDIT BALANCE WATER 4.68 REFUND CREDIT BALANCE SEWER 11. 51 ------------- 16.19 01313 DUPAGE TOPSOIL INC. 4 SEMI LOADS OF PULVERIZED TOP 972.00 01522 GRAINGER INFARED THERMOMETER 113.00 THERMOSTAT FOR ELEVATED TANK 64.74 ------------- 177.74 01522 GRAINGER INC. REPLACEMENT DEHUMIDIFIER 328.59 01819 KI EFT BROTHERS INC. 1 - 48" X 32" FLAT BOTTOM VALV 489.00 08631 LECHNER AND SONS REPLACEMENT RAINGEAR 984.79 2009 UNIFORM RENTAL AND CLEAN I 243.56 -...----...------ 122 B.3 5 11653 LORD, ROBERT J. REFUND CREDIT BALANCE WA&SW 61.90 01918 LUNDSTROM I S NURSERY, INC. 2009 TURF MOWING CONTRACT 381. 90 02155 NEXTEL COMMUNICATIONS SERV 6118 /09- 7/17/09 587.71 SERV 6/18/09-7/17/09 42.52 .....----------- 630.23 05256 NICOR ACCT#94- 32-26-0000-1 76.24 ACCT# 7 5- 53- 27 -0000-4 77 . 84 ACCT#63-01-96-0000-4 76.24 ---..--------- 230.32 11656 OVIGIAN, JOSEPH REFUND CREDIT BALANCE WATER 42.12 REFUND CREDIT BALANCE SEWER 23.59 REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY AUGl12009 13:22 PAGE 13 RELEASE I D : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 30 2009 TO AUGUST 12 2009 .. -................................................................................ --............................................ -................................................................................................................................ DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ............................................ --........................ --........ --.......... ---............................ --.................................. --.......................... --.................. --...... -- --.......... --........ ------------- 65.71 02256 PADDOCK PUBLICATIONS PUBLICATION OF BID NOTICES 158.60 02287 PEERLESS-MIDWEST LABOR AND MATEIRALS TO REPAIR 2910.00 LABOR AND MATEIRALS TO REPAIR 590.00 REPLACE PUMPS/BACKFLOW 4100.00 -..----------- 7600.00 04954 PRO MIX AUDIO AND LIGHTING ELECTRICAL SUPPLIES 196.75 11623 R.A. MANCINI, INC EMERGENCY REPAIRS-411N .MAPLE 9450.00 2009 SPOT RELAY PROJECT 26509.19 2009 SPOT RELAY PROJECT 26509.81 -..----------- 62469.00 02655 SUBURBAN LABORATORIES, INC. ANNUAL CONTRACT FOR WATER SAMP 181.50 02660 SUBURBAN PRINTING TREE TRIMMING GREEN DOOR HANG 310.00 EMERALD ASH BORER BROCHURES 230.00 WA SHUTOFF DOOR HANG& INK&TYPE 113.00 WATER SHUT OFF DOOR HANG&TYPE 109.00 ------------- 762.00 11647 TAMAS, LIVIU REFUND FINAL UTILITY BILL 396.16 02756 UNITED STATES POSTAL SERVICE PERMIT 699-WATER JULY09 2206.34 DB 8 93 VID TECH CONTROL SYSTEM REPAIRS 330.00 02914 ZIEBELL WATER SERVICE PRODUCTS 1 - 5 1/4 MUELLER HYDRANT 415.80 3/4 FLANGES AND ADAPTERS 1337.21 2 - 5' BORY A423 MUELLER FIRE 4519.90 2 - 5.5' BURY A423 MUELLER FIR 4593.90 ------------- 10866.81 TOTAL 135355.96 i20 02301 PETTY CASH - FINANCE DEPT. MISCELLANEOUS PETTY CASH 07/09 24.00 TOTAL 24.00 i30 05503 CRYSTAL MAINTENANCE SERVICES CORP. 2009 CUSTODIAL CONTRACT - PUBL 317 .17 05256 NICOR ACCT#24-06-16-0000- 3 27 .37 02301 PETTY CASH - FINANCE DEPT. MISCELLANEOUS PETTY CASH 07/09 20.00 02754 UNION PACIFIC RAILROAD LAND LEASE JULY 09 2650.43 REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY AUGl12009 13:22 PAGE 14 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 30 2009 TO AUGUST 12 2009 .......... --........................................... ---......................................................... --.... --................... -- -- --........................................ --.................. --.................... --.......... --........ --.. DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ..................................... -- --.. ---........................ -_........... --.... -- -- --................ --............ --................................. ---............................................................................ -- --.................. TOTAL : 3014.97 660 02184 ABBOTT RUBBER CO., INC. FUEL HOSE FOR FIRE VEHICLE #51 25.43 11199 ALL PRODUCTS AUTOMOTIVE, INC WIPER BLADES REPLACEMENTS - PO 398.20 09676 AMERICAN MESSAGING MESSAGE SERVICES THROUGH 7/31/ 184.52 02070 ARLINGTON HEIGHTS FORD REPAIR ENGINE&AIR COMP. #523 506.96 REPLACEMENT SOLENOID #319 50.23 REAR WI PER # P-13 16.46 POWER WINDOW SWITCHES- POLICE V 193.12 ------------- 766.77 10240 AURORA TRI STATE FIRE PROTECTION CO., INC. 10 FIRE EXTINGUISHER BRACKETS 80.00 09289 BEACON SSI, INC. REPAIR OF FUEL PUMP# 1 175.48 (30) REPLACEMENT FUEL KEYS 266. 67 -----...------- 442.15 02940 BRAKE ALIGN PARTS & SERVICES FRONT CALIPERS FOR FIRE VEHICL 700.00 01045 CATCHING FLUIDPOWER #S-12 CTX-S ELBOW FOR #4528 5.97 01236 DAVE & JIM I S AUTO BODY, INC. A/C RECHARGE - VEHICLE #523 93.50 REPAIRS TO DOOR/FENDER - VEHIC 622.20 WHEEL ALIGNMENT - VEHICLE #S- 3 35.00 A/C RECHARGE- VEHICLE#515 80.00 -.._---------- 830.70 01352 ENGINEMASTERS, INC. 6" PUMP AIR FILTERS 63.50 08154 GLOBAL EMERGENCY PRODUCTS FUEL TANK AND STRAPS FOR FIRE 981.65 01616 HOSKINS CHEVROLET, INC. HINGE KITS FOR VEHICLE #2722 86.06 01750 INTERSTATE BATTERY BATTERIES INV#130050455 73.95 BATTERIES INV#130050363 575.70 BATTERIES INV#l30050344 75.90 BATTERIES INV#l10101204 379.80 BATTERIES INV#l10101445 263.85 ----------...-- 1369.20 02486 JOHN SAKASH COMPANY, INC. REPAIR OF WINCH ROPE - VEHICLE 60.00 01879 LEACH ENTERPRISES, INC. FRONT AND REAR BRAKES FOR FIRE 2250.98 02018 MIDWAY TRUCK PARTS 6-TURN SIGNAL VEHICLE#516 37.32 2-STEP LIGHT VEHICLE#515 46.82 ------------- 84.14 REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY AUGII2009 13: 22 PAGE 15 RELEASE ID : VILLAGE OF MOUNT PROS PECT LI ST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 30 2009 TO AUGUST 12 2009 ---- -- -- ----- -- -- -------- -------... -----------... -- - - ------- --... --- -------... -.. ---- ----- ---.... -.. - -.... -.. -.. -.... --... -- ----- -----.. ------------- --- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ..... -...... --......................... --........... --.......... ---........................ - --.... -....................... -.. -........................... -....... -....................... -.. -.. -.............................. -_...... --................... 02023 MIDWEST LUBE, INC. I5-BLANKING PLUGS 14.40 04416 MSC INDUSTRIAL SUPPLY CO. COUNTER SINK BIT 67.65 113 67 NAPA OF DES PLAINES INV#309660 MISC. VEHICLE REPAIR 199.57 MISe. VEHICLE REPAIR&PARTS 7/09 696.40 ---_..-------- 895.97 02107 NAPA-HEIGHTS AUTOMOTIVE SUPPLY MISC VEHICLE REPAIR&PARTS 7/09 162.48 CREDIT INV#135420 11.49- ----------..-.. 150.99 02155 NEXTEL COMMUNICATIONS SERV 6/18/09-7/17/09 351.64 SERV 6/18/09-7/17/09 25.57 -..-...--------- 377.21 09423 RONCO INDUSTRIAL SUPPLY MISC VEHICLE REPAIR&PARTS 7/09 98.00 MISC VEHICLE REPAIR&PARTS 7/09 50.00 MISC VEHICLE REPAIR&PARTS 7/09 95.22 CREDIT# 1508 955-0 1 61.50- CREDIT# 1509003-000 1-0 1 8.63- MISC VEHICLE REPAIR&PARTS 7/09 70.13 MISC VEHICLE REPAIR&PARTS 7/09 87.02 MISC VEHICLE REPAIR&PARTS 7/09 107.53 MISC VEHICLE REPAIR&PARTS 7/09 272.00 ------------- 709.77 09122 TAYLOR MADE AMBULANCES DOOR SWITCHES-AMBULANCE#521 100.95 04472 TEXOR PETROLEUM CO 07/31/09 FUEL PURCHASED 19538.78 02870 WHOLESALE DIRECT INC. HALOGEN BULBS FIRE VEHICLES 368.80 PRE-EMP POWER SUPPLY #503 462.12 ------------- 830.92 TOTAL 31015.91 570 05007 LANDMARK FORD 8 FORD CROWN VICTORIA INTERCEP 155419.00 11241 ULTRA STROBE COMMUNICATIONS, INC SQUAD CONVERSION P-21 4275.34 8LIGHT BARS SQUAD P=CONVERSION 9160.00 ------------- 13435.34 TOTAL 168854.34 i80 05005 CDS OFFICE TECHNOLOGIES PANASONIC TOUGHBOOK 30 RUGGED I 4130.00 01049 COW GOVERNMENT, INC HP LJ P3005DN PRINTER - COW # 855.00 SHIPPING 14.99 REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY AUGl12009 13:22 PAGE 16 RELEASE I D : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 30 2009 TO AUGUST 12 2009 ... -........... -................. --................. --......... --..................................................................................................... --........................................... -- --................................................. DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .. --.......... - --......................................................................... --.. --.. --.... --....... --............. --................................................................................. --.......................................-- ------------- 869.99 TOT AL 4999.99 690 01335 ALEXIAN BROTHERS CORPORATE HEALTH SERVICES B .EISEN-DOI: 2/2/09 ELBOW 314.38 A.BRAGAGNOLO DOI:2/20/09 BACK 95.27 G.REBECCA- 001 :7/13/09 ELBOW 142.24 ---------....--- 551.89 08161 ARLINGTON RIDGE PATHOLOGY, S. C. R.NAVA-SOI: 6/3/09 122.00 01460 ARTHUR J. GALLAGHER RMS, INC. AUDIT -EXCESS WORKERS I COMP 2572.00 10051 CCMSI W/C REIMBURSEMENT 7/29/09 20353.87 01102 GAB ROBINS N.A., INC - CITIBANK PYMT OF INS CLAIMS 7/30/09 16504.71 01737 INTERGOVERNMENTAL PER.BEN.COOP CLAIMS ADMIN-MEDICAL 7/09 37614.96 HMO MEDICAL 7/09 125040.85 LIFE INSURANCE 7/09 2829.00 PPO MEDICAL CLAIMS 7/09 266722 .15 ------------- 432206.96 02192 NORTHWEST COMMUNITY HOSPITAL ERIC MERTES-DOl: 7 /5/09 319.60 MICHAEL ANGAROLA 001:7/16/09 127 . 68 -----....._----- 447.28 11643 PARKSIDE AUTO BODY INC REPAIR P- 33 FRONT END DAMAGE 1263.87 TOTAL 474022.58 710 01460 ARTHUR J. GALLAGHER RMS,INC. INSURANCE 8/1/09-8/01/10 9061.00 09677 INSPE ASSOCIATES LTD. MEDICAL EXP-C.SCHMIDT 1386.00 07263 RICHARD REIMER & ASSOC., LLC. INV#2192-12080 04/09 LEGAL EXP 2802.67 INV#2192-12151 05/09 LEGAL EXP 659.94 INV#2192-12248 06/09 LEGAL EXP 3462.31 INV#2192-12351 7/09 LEGAL EXP 3341.2 8 -------..--..-- 10266.20 08650 WILLIAM C. MALIK, M.D. MEDICAL EXPENSE 1350.00 TOTAL 22063.20 120 01460 ARTHUR J. GALLAGHER RMS, INC. INSURANCE 8/1/09-8/1/10 10378.00 TOTAL 10378.00 REPORT: APBOARDRPT GENERATED: 15 APR 09 11 :42 RUN: TUESDAY AUGl12009 13:22 RELEASE 10 : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 30 2009 TO AUGUST 12 2009 DEPT VENDOR NBR INVOICE DESCRIPTION VENDOR NAME 790 11601 GENOVESE, JOSEPH REPLACE CHECK#13015700 01791 K-PLUS ENVIRONMENTAL, INC. GOLF PLAZA II 01719 NCPERS GROUP LIFE PREMIUM -AUGUST 2009 09942 RANDOLPH, W. DICKSON AND/OR EYDIE REISSUE CK#77257 1/3/2007 08337 RICK I S SEWER AND DRAINAGE REFUND BOND-NON VILLAGE ADORES 02689 THIRD DISTRICT CIRCUIT COORT BOND MONEY 7/30/09 BOND MONEY 8/4/09 BOND MONEY 8/6/09 BOND MONEY 8/11/09 02886 WISC. INCOME TAX JULY09 WISCONSIN DEPARTMENT OF REVENUE TOTAL GRAND TOTAL PAGE 17 AMOUNT 200.00 780.00 704.00 4000.00 125.00 1725.00 237 5.0 0 1055.00 3468.00 8623.00 446.93 14878.93 2381840.61 REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY AUG1l2009 13: 22 RELEASE ID : PAGE 18 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 30 2009 TO AUGUST 12 2009 - - - - -.... --.................................. --...... --...... --............ --.... --...... --........................................................................................................................................................ SUMMARY BY FUND ....................... -_................ --........ --...................................................................................... ---- --........ --................ --.. --.......... -- --................................................... 001 GENERAL FUND 233028.83 030 REFUSE DISPOSAL FUND 197816.22 050 MOTOR FUEL TAX FUND 96316.63 070 COMMUNITY DEVELPMNT BLOCK GRNT 13595.34 085 DEA SHARED FUNDS FUND 7350.00 510 CAPITAL IMPROVEMENT FUND 11l287.88 528 SERIES 2009 CONST FUND 597908.21 550 DOWNTOWN REDEVLPMNT CONST 63912.65 560 STREET IMPROVEMENT CONST FUND 42611. 97 590 FLOOD CONTROL CONST FUND 153405.00 610 WATER AND SEWER FUND 135 355 . 96 620 VILLAGE PARKING SYSTEM FUND 24.00 630 PARKING SYSTEM REVENUE FUND 3014.97 660 VEHICLE MAINTENANCE FUND 31015.91 670 VEHICLE REPLACEMENT FUND 168854.34 680 COMPUTER REPLACEMENT FUND 4999.99 690 RISK MANAGEMENT FUND 474022.58 710 POLICE PENSION FUND 22063.20 720 FIRE PENSION FUND 10378.00 790 ESCROW DEPOSIT FUND 14878.93 -.....----------- TOTAL : 2381840.61 REPORT: APBOARDRPT GENERATED: 15 APR 09 11: 42 RUN: TUESDAY AUG1l2009 13:22 PAGE REPORT PARAMETERS ORGANIZATION NO. : 001 STARTING CHECK DATE : 07/30/09 ENDING CHECK DATE : 08/12/09 STARTING BANK ENDING BANK SEGMENT NUMBER TO SORT BY : 01 STARTING ACCOUNT SEGMENT NUMBER: ALL ENDING ACCOUNT SEGMENT NUMBER : ALL RELEASE LEVEL .. .......::7..., ""'. ...""'......... · · ""'~t""""'.. List of Escrow Checks Presented to the Board of Trustees 08/12/09 To 08/12/09 EMR025 Paid to Permit # 091386 091327 091470 082571 090070 081800 081180 090858 091470 091274 091403 BEAUTIFUL STONES CONTRACTOR INC BENJAMIN VARGA CHAVEZ, CLEMENTE CHLOPEK, DIANE CHYNEK, MIROSLAW COWELL, GEOFFREY DEMETER, ANDRAS DURO PAVE CONSTRUCTION EXSTINK INC FOUR SEASONS INC GENESIS CONSTRUCTION INC 090156 091211 081195 082182 081495 090469 091350 091049 091437 091219 091134 091430 090415 090947 090263 090887 090767 060458 091525 091136 090727 091410 GERLACH, LILLIAN HOLLOWAY, ROBERT KEY SAC GROUP MARTIN, TRACY MCGUIGAN, PATRICIA MILLER, MELVIN R MUELLER, JOHN P NELSON, WENDY NEON NEON DESIGN CORP PAVEWORKS INC PETERSON, TODD PIOTROWSKI, DONNA RUANE, TIMOTHY G SPERLING, RICHARD E STAVOE, RONALD SWIDERSKI, JOSEPH M TOKAR, ADOLPH VALEX INTERNATIONAL INC VEGA, JOSE WOZNIAK, ALICE J Z-BEST LANDSCAPING *** TOTAL NUMBER OF CHECKS 33 Check # 13016332 13016333 13016334 13016335 13016336 13016337 13016338 13016339 13016340 13016341 13016342 Amount 200.00 200.00 400.00 150.00 325.00 150.00 1,225.00 500.00 125.00 75.00 125.00 200.00 * 250.00 150.00 75.00 500.00 100.00 125.00 200.00 200.00 200.00 125.00 150.00 200.00 450.00 200.00 200.00 100.00 325.00 200.00 125.00 225.00 250.00 125.00 13016343 13016344 13016345 13016346 13016347 13016348 13016349 13016350 13016351 13016352 13016353 13016354 13016355 13016356 13016357 13016358 13016359 13016360 13016361 13016362 13016363 13016364 7,950.00