HomeMy WebLinkAbout3. FINANCIAL REPORT AND BILLS 07/20/2010 Motuit Prospect
Village of Mount Prospect
Mount Prospect, Illinois
INTEROFFICE MEMORANDUM
TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES
FINANCE COMMISSION
FROM: FINANCE DIRECTOR
DATE: JULY 16, 2010
SUBJECT: MONTHLY FINANCIAL REPORT — JUNE 2010
Attached hereto are the cash position and investment statements of the Village forthe month ended
June 30, 2010. These statements provide a snapshot of the Village's cash position as of the month
end date noted and are intended to supplement the budget revenue and expenditure summary and
listing of bills you receive. The first statement presents the Village's cash position broken down by
governmental and enterprise funds and trust and agency funds. The second statement presents the
Village's cash position by fund type. The third statement presents the list of investments again
broken down by governmental and enterprise funds and trust and agency funds. It is important to
note that although we have included the trust and agency funds in the cash position report, these
are not funds accessible for Village operations. They are restricted for pension and escrow funding
only. Please read the summary that follows for further detail on the cash position of the Village.
Cash and Investment Position Report — All Funds (page 1)
This report provides a detail 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 /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 accounts for the accumulation of monies for
debt service payments.
Governmental and Enterprise Funds - Cash and cash equivalents at May 31 were $29.9 million.
During June, cash receipts totaled $3,983,199.67. In addition investment income forthe month was
$5,825.60 and inflows due to Interfund activity generated $3,010.28. Reductions in cash and cash
equivalents during May totaled $6,003,684.93. Of this amount, payments to vendors were
$4,612,728.25, employee payroll and related expenses were $1,388,117.38 and other
disbursements were $2,839.30. Cash and cash equivalents at June 30 were $27.9 million.
There were no funds held in investments during the month of June. Funds were held in cash money
market accounts that currently earn competitive rates of interest.
Monthly Financial Report — June 2010
July 16, 2010
Page 2
Total cash and investments for Governmental and Enterprise Funds at May 31 were
$29,887,465.34. Cash and investments at June 30 totaled $27,875,815.96. This is a decrease of
$2,011,649.38.
Trust and Agency Funds - Cash and cash equivalents at May 31 were $7.0 million. During June,
cash receipts totaled $206,840.45. In addition investment income for the month was $198,024.43
and outflows due to interfund activity totaled $3,010.28. There was also a net decrease in cash due
to investment activities of $1,837,553.65. Reductions in cash and cash equivalents during June
totaled $625,768.74. Of this amount, payments to vendors were $164,146.65, employee payroll and
related expenses were $438,762.65, payments related to the flexible spending program totaled
$21,367.45. Other disbursements were $1,491.99. Cash and cash equivalents at June 30 were
$4,895,845.46 million.
Total investments at June 30 were $76,592,397.28, a decrease of $2,162,246.52 from May 31,
2010. There were unrealized investment losses of $3,999,800.17 and a transfer from cash of
$1,837,553.65 that accounted for the change.
Total cash and investments for Trust and Agency Funds at May 31 were $85,711,957.05. Cash and
investments at June 30 totaled $81,488,242.74. This is a decrease for the month of $4,223,714.31.
Summary of Cash Activity by Fund Type (page 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 detail explanation on 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. Each of these is highlighted below.
General Fund — Cash and cash equivalents at May 31 totaled $5,574,576.51. During June, cash
receipts totaled $2,358,317.99 and investment income was $3,363.67. Significant cash receipts
included sales taxes, state income tax, telecommunication tax and building permits
Sales tax revenues for the month totaled $956,224. Of this amount, $866,579 was generated
from the 1% state portion while $89,645 was generated from the .25% home rule portion. The
state portion showed an increase of 36.1% from last year same time. The home rule portion
also grew from the prior year by 10.2 %. The difference between the two sales tax sources in
their change from prior year is due to the tax being assessed on a different set of goods. Sales
taxes received in June are for March sales as there is a three -month lag in getting this
distribution from the state. The reason for the large increase over the prior year was due to a
large retailer being closed (from February to August) in 2009 for remodeling.
State income tax receipts for June totaled $415,403. These monies were actually to be
received by the Village in January. The state is 150+ days delinquent in making these
remittances to the Village. The state is currently $2.3 million in arrears in remitting income taxes
to the Village.
H:\ACCT\Treasurer's Report\2010 \Monthly Financial Report \Monthly Cash Position Report - June 2010.doc
Monthly Financial Report — June 2010
July 16, 2010
Page 3
Telecommunication tax receipts for June reflect March activity. Total receipts during June
were $256,913 and exceeded prior year receipts by 33.2% for the month and 12.8% above year -
to -date.
Building permit revenues continue to reflect construction activity at Randhurst and other sites
within the Village. Permit revenues for June were $156,445 and are $383,567 for the year.
These year -to -date collections represent 69.7% of the total year's projection. This revenue is
expected to exceed budget for 2010
Disbursements from the General Fund for June included payments to vendors of $1,258,202.16 and
payments for employee wages and benefits of $1,121,448.03. Interfund transfers of $411,848.83
for health premiums and vehicle lease and maintenance payments were also made during June.
Cash and cash equivalents at June 30 were $5,141,919.85. There were no investments in the
General Fund at June 30.
Statement of Investments (pane 3)
This report provides a breakdown of investments by governmental and enterprise funds and trust
and agency funds. The report also provides a fund -by fund breakdown of the investments.
Government and Enterprise Funds - Investments for the governmental and agency funds are
typically made up of Certificates of Deposit. At June 30 there were no CD's placed at any bank.
This is due to the extremely low interest rates being offered. Money instead has been placed in
interest bearing money market accounts
Trust and Agency Funds — The investments for the trust and agency funds are made up of
certificates of deposits, fixed income investments and equity mutual funds. CD's (if any) held in the
Escrow Deposit Fund will generally have maturities of between 30 and 120 days. Most of the
reserves for this fund are invested in the more liquid money market account due to the nature of the
deposit. Escrow refunds are processed two times per month.
Investments for the Police and Firefighter Pension Funds consist of various fixed income securities
as well as equity mutual fund accounts. Wells Fargo is the third -party holder of the fixed income
securities. The funds are managed by three investment management firms, Capital Gains, Segall
Bryant and Mesirow Financial. Segall Bryant holds approximately half of the fixed income
investments for the two pension funds while Capital Gains and Mesirow manage the balance of
fixed income investments for these two funds. Each manager maintains a small portion of their
portfolio in cash to help facilitate liquidity and trading.
Investments in equities consist of mutual funds spread across various sectors (small, mid and large -
cap stocks) as well as investment philosophies (value, core and growth). The pension funds also
have a small portion of their portfolio invested in international stocks. Each year the investment mix
is evaluated for optimal diversification to meet the pension funds investment policy goals and
objectives. Below is a breakdown of how the pension fund portfolios are invested.
H:\ACCT\Treasurer's Report\2010 \Monthly Financial Report\Monthly Cash Position Report - June 2010.doc
•
Monthly Financial Report — June 2010
July 16, 2010
Page 4
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 21,036,777.98
Various Various Various Mutual Fund Investments Various Various 17,185,687.56
38,222,465.54
FIRE PENSION FUND (720)
Various Various Wells Fargo Wells Fargo Investments Various Various 21,918,338.68
Various Various Various Mutual Fund Investments Various Various 16,451,593.06
38,369,931.74
TOTAL TRUST AND AGENCY FUND INVESTMENTS $ 76,592,397.28
Investment of the Village's pension funds is governed by an Investment Policy adopted by each
Pension Board.
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.
H:WCCT\Treasurer's Report\2010 \Monthly Financial Report \Monthly Cash Position Report - June 2010.doc
VILLAGE OF MOUNT PROSPECT
Preliminary Cash and Investment Position Report - All Funds
For the Month Ended June 30, 2010
GOVERNMENTAL AND ENTERPRISE FUNDS
Cash and Cash Total Cash and
Equivalents Investments Investments
Balance at May 31, 2010 $ 29,887,465.34 $ - $ 29,887,465.34
Cash receipts 3,983,199.58 3,983,199.58
Investment income 5,825.60 5,825.60
Transfers from investments to cash - - -
Transfers to investments from cash - - -
Interfund activity 3,010.28 3,010.28
Disbursements:
Accounts payable (4,612,728.25) (4,612,728.25)
Payroll (1,388,117.38) (1,388,117.38)
Other (2,839.30) (2,839.30)
Balance at June 30, 2010 $ 27,875,815.87 $ - $ 27,875,815.87
TRUST AND AGENCY FUNDS *
Cash and Cash Total Cash and
Equivalents Investments Investments
Balance at May 31, 2010 $ 6,957,313.25 $ 78,754,643.80 $ 85,711,957.05
Cash receipts 206,840.45 206,840.45
Investment income (loss) 198,024.43 (3,999,800.17) (3,801,775.74)
Transfers from investments to cash 2,050,871.35 (2,050,871.35) -
Transfers to investments from cash (3,888,425.00) 3,888,425.00 -
Interfund activity (3,010.28) (3,010.28)
Disbursements:
Accounts payable (164,146.65) (164,146.65)
Payroll (438,762.65) (438,762.65)
Flex spending (21,367.45) (21,367.45)
Other ** (1,491.99) (1,491.99)
Balance at June 30, 2010 $ 4,895,845.46 $ 76,592,397.28 $ 81,488,242.74
* Assets are restricted in purpose and do not represent discretionary assets of the government.
** Includes prior month accounts payable check voided in the current period
1
O CO C) O O 0m lnM O c0 CO N 0
OO O C) O O N C O 0) C) OCO N CO
auo T 0(5 nov ' coo r` m
J N. 10 r N CO CO 00 1'- CD T - (0 0) O
¢ r 0 00 CD C co co 0 (O CD y- N C) 0
H C O () ( CO C 66 iri r N C
0 C 0) 0 CO OD NNn r LO C) CO 40
H CO N O CO 0 f` r CD CD (0 CO
O C N v r , N N C) (0 O)
C) `-' 0) C co r- O
t-
69- 4)
cn Y N CO 0)) N 0) C C r r N
co = 2 n - , 0 0) ((0 , N- V 7
0 �W 47 Cs/ OCco C) V sr
2 0 Z O o c o) o
O w Q O M0 . PN) M
LL LL T.
0< r ta 4a
W
(.
¢ a) 04 0) L0 0 LO V CO CO N CO C
0 0) N 0 C) 0 ' ,, (O N 1-- CO 0 N 0
Z Cl Cr) C 0 c() N co (A ' 0 O n r
¢ Z W Z C N 1■ N (O CD CO s- OD 0) O)
H Q 00 0000 C 1� C) y- C4 C) r�
(n w J CO r 0 O0 0O) O ID 1- N co
04 O 0) 41) 0 co 0 (o co co O) N
0 LL' 0 Z co a- y- 0 CO 7 I!) O) (0 LLD
CC LL LL 0 N v C) CM co
69 CA
Z C CO 0 COO 0)u) 1 P
Z W CO to CO N CO C) c4 CO CO
0 of ui ' 0 of r-: o5 ((i ((�
5 Lx ra c° a NO oCO .- c o c o
0 0_ 0 co c o r;V o� 1.6 wi
0 w n 0D 0) c (D OD ao
J Z LL N 0 N N
H w
O ua to
co 0 CO W co N r 0 a
J Z 00 CD r r. c0 N n r r. ' r ai
Z L=L co co N V c co
W w co r- V � co- CCco co
H V N '- 10 v N N
Z 5 O O O
w 69.
a)
Q
1- O
T
0 H o C) W u) N v n C C
441 ON W c0 r 0 0 CD r- 0 co
(1) 0 co 0c000C . . r i 0 n 0 0 r i r 0 0)
0 u_ a) 0 a0 N " C./ ao r- v d'
a 9 C Z w Z a1 ( N CO ( N N
F LL H LL O 0 v to 0 0
2 ? '0 W Z C CD (D
D o 0 CO W
O ¢ C lY 69 CA
2 .c w CL
LL
co Q'
O U c w CO ((°i m (o 0 )
W o m Z J co 1 C r r r r . 0 ■ i
Q W F_ co co 0 o u
J co .. 0 d N 1' N N h
J E O Q < V Z
N C V co
> Li_ Q U d ( p co cci
H ea 69
Z
w
Z W r- CO 0 N 0) CO
CL U (0 CO r r r r i 0 r i i co 0
> , co (O D1 ' o co co C
0 cn Z C C) 0 0) 0 C
I- LL r0 n n iTi w °1)
D)
0 69 us a)
L
N0 OD N (+7 r N N O
�0)ti 0) N-
J LU m
m
¢0 CO V V W r` N r, r N OD O y
U 1 0 0 v C) co co w ca
a w Z 0)) 4)) v E00 0 N N
0 W W r •- CC
Q
Vf 69 0
0
N
0 O
O
CAO co ) '-
Z O 0 co a)
LL. (O N C r r V CO C . 7 N O) r . O) W N. O CO C) CO CO C N 0) 0 ) 0
J C L
c[ 10 C v rN a- Zr 0 LLD T
Z 1.6 N v b c
W
0 to w - 0 0
a
co c
o) 0 Z 0
CO o % 2 0
Z (a
w co 0_ D U) n
¢ a) u) a) — C w w c
> E c p c c 2 v
0 N 0 " 0 0 a)
a a) a)a) t a x i( 6 c ° ) o EE ❑ °
E C y O (1 , 0-.). y Z • C S N N 0 0 E C co N N c 0 F a C C a) < N
c C Z
CCCC 0 E u) m
¢ , a) a) a) a) m wm N < `m
U _ c
ad CI 0 E 0 w r0 0 CD CD CD N CO .0 O N ' r U u) 2
0) 8 LL c J a)
= C 0 0 7 7 7 3 C W w N 3 ¢ 0)
Q N N > l6 a) I 0 „ N N N W C N 3 ) 0 <
VILLAGE OF MOUNT PROSPECT
STATEMENT OF INVESTMENTS
As of June 30, 2010
GOVERNMENTAL AND ENTERPRISE FUNDS
Maturity Purchase Financial Investment CUSIP/ Interest Market Weighted
Date Date Institution Description Acct # Rate % Value Avg Yield
As of June 30, 2010, there were no certificates of deposit held by the Governmental and Enterprise Funds.
TRUST AND AGENCY FUNDS *
Maturity Purchase Financial Investment CUSIP/ Interest Market Weighted
Date Date Institution Description Acct # Rate % Value Avg Yield
POLICE PENSION FUND (710)
Various Various Wells Fargo Wells Fargo Investments Various Various 21,036,777.98
Various Various Various Mutual Fund Investments Various Various 17,185,687.56
38,222,465.54
FIRE PENSION FUND (720)
Various Various Wells Fargo Wells Fargo Investments Various Various 21,918,338.68
Various Various Various Mutual Fund Investments Various Various 16,451,593.06
38,369,931.74
TOTAL TRUST AND AGENCY FUND INVESTMENTS $ 76,592,397.28
* Assets are restricted in purpose and do not represent discretionary assets of the government.
3
VILLAGE OF MOUNT PROSPECT
BUDGET REVENUE
&
EXPENDITURE SUMMARIES
January 1— June 30, 2010
07/15/2010 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.00 ) Completed
09:50:11 6 Months ( 50.0% ) Remaining
Budget Revenue Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
REVENUE BY CLASSIFICATION
PROPERTY TAXES 17,671 7,721,370 14,999,000 7,277,630 48.5
OTHER TAXES 970,169 5,330,992 15,665,000 10,334,008 66.0
LICENSES, PERMITS & FEES 230,296 2,159,958 3,487,000 1,327,042 38.1
INTERGOVERMENT REV. 1,594,320 4,454,870 18,102,647 13,647,777 75.4
CHARGES FOR SERVICE 1,730,327 9,686,652 21,970,880 12,284,228 55.9
FINES AND FORFEITS 56,937 263,671 704,000 440,329 62.5
INVESTMENT INCOME - 3,875,844 - 383,668 5,696,250 6,079,918 106.7
REIMBURSEMENTS 12,997 160,507 467,000 306,493 65.6
OTHER REVENUE 442,475 3,237,188 7,023,160 3,785,972 53.9
OTHER FINANCING SOURCES 0 1,083 1,023,505 1,022,422 99.9
Total All Funds 1,179,348 32,632,623 89,138,442 56,505,819 63.4
REVENUE BY FUND
GENERAL FUND 2,450,157 14,814,400 40,691,100 25,876,700 63.6
REFUSE DISPOSAL FUND 261,350 2,110,954 4,038,500 1,927,546 47.7
MOTOR FUEL TAX FUND 118,227 625,641 1,836,500 1,210,859 65.9
LAW ENFORCEMENT BLOCK GRANT 0 0 0 0
COMMUNITY DEVELPMNT BLOCK GRNT 148,277 204,321 565,447 361,126 63.9
ASSET SEIZURE FUND 6 3,624 6,000 2,376 39.6
DEA SHARED FUNDS FUND 4 20 1,500 1,480 98.7
DUI FINE FUND 2,697 5,489 20,500 15,011 73.2
FOREIGN FIRE TAX BOARD FUND 4,300 4,301 35,500 31,199 87.9
SERIES 1987A B &I, PW FACILITY 0 0 0 0
SERIES 2001 B &I, VILLAGE HALL 1 1 379,000 378,999 100.0
SERIES 2003 B &I, VILLAGE HALL 1,079 496,085 904,000 407,915 45.1
SERIES 2009 B &I, FD /PW 302 227,113 414,000 186,887 45.1
2009B B &I, FD /PW -422 54,711 0 - 54,711
2009C B &I, FD /PW 251 65,640 0 - 65,640
SERIES 1999 B &I, TIF 0 0 0 0
SERIES 1998A B &I, FLOOD 0 0 0 0
SERIES 1998C B &I, TIF 0 0 0 0
IEPA FLOOD CONTROL LOANS B &I 82,110 214,159 1,140,708 926,549 81.2
SERIES 2000 B &I, FLOOD CONTROL 0 0 0 0
SERIES 2002B B &I, FLOOD 0 0 0 0
CAPITAL IMPROVEMENT FUND 82,551 230,865 1,421,500 1,190,635 83.8
SERIES 2009 CONST FUND 0 24,644 1,124,505 1,099,861 97.8
DOWNTOWN REDEVLPMNT CONST 11,432 1,240,753 2,567,000 1,326,247 51.7
STREET IMPROVEMENT CONST FUND 116,296 770,936 1,717,600 946,664 55.1
FLOOD CONTROL CONST FUND 8,110 79,347 198,792 119,445 60.1
WATER AND SEWER FUND 737,975 5,021,194 12,225,500 7,204,306 58.9
VILLAGE PARKING SYSTEM FUND 10,461 55,268 152,000 96,732 63.6
PARKING SYSTEM REVENUE FUND 13,455 64,411 159,500 95,089 59.6
VEHICLE MAINTENANCE FUND 137,362 824,305 1,654,192 829,887 50.2
VEHICLE REPLACEMENT FUND 10,553 54,533 238,200 183,667 77.1
COMPUTER REPLACEMENT FUND 114 700 12,000 11,300 94.2
RISK MANAGEMENT FUND 564,248 3,363,366 6,865,098 3,501,732 51.0
POLICE PENSION FUND - 1,785,049 1,005,365 5,585,500 4,580,135 82.0
FIRE PENSION FUND - 1,796,499 1,070,475 5,184,300 4,113,825 79.4
SSA #6 GEORGE /ALBERT B &I 0 2 0 -2
GENERAL FIXED ASSETS ACCT GP 0 0 0 0
1
07/15/2010 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.00 ) Completed
09:50:12 6 Months ( 50.0t ) Remaining
Budget Revenue Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
Total All Funds 1,179,348 32,632,623 89,138,442 56,505,819 63.4
2
07/15/2010 6 Months ( 50.0% ) Completed
09:51:18 6 Months ( 50.0% ) Remaining
FRRBRR03 VILLAGE OF MOUNT PROSPECT
SUM 021 Budget Revenue by Category within Fund Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
GENERAL FUND
40 PROPERTY TAXES 14,554 5,947,514 11,575,000 5,627,486 48.6
41 OTHER TAXES 657,597 2,435,568 7,576,000 5,140,432 67.9
42 LICENSES, PERMITS & FEES 228,511 2,149,263 3,426,000 1,276,737 37.3
43 INTERGOVERMENT REV. 1,357,595 3,187,703 15,240,100 12,052,397 79.1
44 CHARGES FOR SERVICE 106,645 626,750 1,640,000 1,013,250 61.8
45 FINES AND FORFEITS 50,764 241,904 642,000 400,096 62.3
46 INVESTMENT INCOME 3,365 20,087 130,000 109,913 84.5
47 REIMBURSEMENTS 11,743 116,829 296,000 179,171 60.5
48 OTHER REVENUE 19,383 87,699 166,000 78,301 47.2
49 OTHER FINANCING SOURCES 0 1,083 0 -1,083
TOTAL GENERAL FUND 2,450,157 14,814,400 40,691,100 25,876,700 63.6
REFUSE DISPOSAL FUND
40 PROPERTY TAXES 1,963 951,472 1,731,000 779,528 45.0
44 CHARGES FOR SERVICE 259,225 1,113,444 2,151,000 1,037,556 48.2
46 INVESTMENT INCOME 161 613 22,500 21,887 97.3
48 OTHER REVENUE 1 45,425 134,000 88,575 66.1
TOTAL REFUSE DISPOSAL FUND 261,350 2,110,954 4,038,500 1,927,546 47.7
MOTOR FUEL TAX FUND
43 INTERGOVERMENT REV. 118,083 595,998 1,675,000 1,079,002 64.4
46 INVESTMENT INCOME 144 703 1,500 797 53.1
47 REIMBURSEMENTS 0 28,940 160,000 131,060 81.9
TOTAL MOTOR FUEL TAX FUND 118,227 625,641 1,836,500 1,210,859 65.9
LAW ENFORCEMENT BLOCK GRANT
43 INTERGOVERMENT REV. 0 0 0 0
46 INVESTMENT INCOME 0 0 0 0
TOTAL LAW ENFORCEMENT BLOCK GRANT 0 0 0 0
COMMUNITY DEVELPMNT BLOCK GRNT
43 INTERGOVERMENT REV. 118,642 153,811 515,447 361,636 70.2
46 INVESTMENT INCOME 0 0 0 0
48 OTHER REVENUE 29,635 50,510 50,000 -510 -1.0
TOTAL COMMUNITY DEVELPMNT BLOCK GRNT 148,277 204,321 565,447 361,126 63.9
ASSET SEIZURE FUND
45 FINES AND FORFEITS 0 3,596 5,000 1,404 28.1
46 INVESTMENT INCOME 6 28 1,000 972 97.2
TOTAL ASSET SEIZURE FUND 6 3,624 6,000 2,376 39.6
DEA SHARED FUNDS FUND
45 FINES AND FORFEITS 0 0 1,000 1,000 100.0
46 INVESTMENT INCOME 4 20 500 480 96.0
1
07/15/2010 6 Months ( 50.00 ) Completed
09:51:15 RBR R03 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0 ) Remaining
FRRBRRO3
SUMO21 Budget Revenue by Category within Fund Summary
01/01/10 - 06/30/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
TOTAL DEA SHARED FUNDS FUND 4 20 1,500 1,480 98.7
DUI FINE FUND
45 FINES AND FORFEITS 2,696 5,486 20,000 14,514 72.6
46 INVESTMENT INCOME 1 3 500 497 99.4
TOTAL DUI FINE FUND 2,697 5,489 20,500 15,011 73.2
FOREIGN FIRE TAX BOARD FUND
41 OTHER TAXES 4,296 4,296 35,000 30,704 87.7
46 INVESTMENT INCOME 4 5 500 495 99.0
TOTAL FOREIGN FIRE TAX BOARD FUND 4,300 4,301 35,500 31,199 87.9
SERIES 1987A B &I, PW FACILITY
40 PROPERTY TAXES 0 0 0 0
46 INVESTMENT INCOME 0 0 0 0
TOTAL SERIES 1987A B &I, PW FACILITY 0 0 0 0
SERIES 2001 B &I, VILLAGE HALL
40 PROPERTY TAXES 0 0 378,000 378,000 100.0
46 INVESTMENT INCOME 1 1 1,000 999 99.9
49 OTHER FINANCING SOURCES 0 0 0 0
TOTAL SERIES 2001 B &I, VILLAGE HALL 1 1 379,000 378,999 100.0
SERIES 2003 B &I, VILLAGE HALL
40 PROPERTY TAXES 1,027 495,879 902,000 406,121 45.0
46 INVESTMENT INCOME 52 206 2,000 1,794 89.7
49 OTHER FINANCING SOURCES 0 0 0 0
TOTAL SERIES 2003 B &I, VILLAGE HALL 1,079 496,085 904,000 407,915 45.1
SERIES 2009 B &I, FD /PW
40 PROPERTY TAXES 300 227,062 413,000 185,938 45.0
46 INVESTMENT INCOME 2 51 1,000 949 94.9
TOTAL SERIES 2009 B &I, FD /PW 302 227,113 414,000 186,887 45.1
2009B B &I, FD /PW
40 PROPERTY TAXES -423 54,693 0 - 54,693
46 INVESTMENT INCOME 1 18 0 -18
49 OTHER FINANCING SOURCES 0 0 0 0
TOTAL 2009B B6I, FD /PW -422 54,711 0 - 54,711
2009C B &I, FD /PW
40 PROPERTY TAXES 250 44,750 0 - 44,750
43 INTERGOVERMENT REV. 0 20,872 0 . - 20,872
46 INVESTMENT INCOME 1 18 0 -18
2
07/15/2010 6 Months ( 50.0% ) Completed
0R VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0% ) Remaining
FR BRR03
suMO21 Budget Revenue by Category within Fund Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
TOTAL 2009C B &I, FD /Pw 251 65,640 0 - 65,640
SERIES 1999 B &I, TIF
41 OTHER TAXES 0 0 0 0
46 INVESTMENT INCOME 0 0 0 0
TOTAL SERIES 1999 B &I, TIF 0 0 0 0
SERIES 1998A B &I, FLOOD
41 OTHER TAXES 0 0 0 0
46 INVESTMENT INCOME 0 0 0 0
TOTAL SERIES 1998A B &I, FLOOD 0 0 0 0
SERIES 1998C B &I, TIF
41 OTHER TAXES 0 0 0 0
46 INVESTMENT INCOME 0 0 0 0
TOTAL SERIES 1998C B &I, TIF 0 0 0 0
IEPA FLOOD CONTROL LOANS B &I
41 OTHER TAXES 82,070 214,001 1,140,708 926,707 81.2
46 INVESTMENT INCOME 40 158 0 -158
TOTAL IEPA FLOOD CONTROL LOANS B &I 82,110 214,159 1,140,708 926,549 81.2
SERIES 2000 B &I, FLOOD CONTROL
41 OTHER TAXES 0 0 0 0
46 INVESTMENT INCOME 0 0 0 0
TOTAL SERIES 2000 B &I, FLOOD CONTROL 0 0 0 0
SERIES 2002B B &I, FLOOD
41 OTHER TAXES 0 0 0 0
49 OTHER FINANCING SOURCES 0 0 0 0
TOTAL SERIES 2002E B &I, FLOOD 0 0 0 0
CAPITAL IMPROVEMENT FUND
41 OTHER TAXES 82,451 214,994 1,146,000 931,006 81.2
43 INTERGOVERMENT REV. 0 6,157 264,000 257,843 97.7
46 INVESTMENT INCOME 100 504 11,500 10,996 95.6
47 REIMBURSEMENTS 0 0 0 0
48 OTHER REVENUE 0 9,210 0 -9,210
49 OTHER FINANCING SOURCES 0 0 0 0
TOTAL CAPITAL IMPROVEMENT FUND 82,551 230,865 1,421,500 1,190,635 83.8
SERIES 2009 CONST FUND
43 INTERGOVERMENT REV. 0 20,000 150,000 130,000 86.7
46 INVESTMENT INCOME 0 4,644 1,000 -3,644 -364.4
48 OTHER REVENUE 0 0 0 0
3
07/15/2010 6 Months ( 50.0% ) Completed
0 R03 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0 ) Remaining
F R
SUMO21 Budget Revenue by Category within Fund Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
49 OTHER FINANCING SOURCES 0 0 973,505 973,505 100.0
TOTAL SERIES 2009 CONST FUND 0 24,644 1,124,505 1,099,861 97.8
DOWNTOWN REDEVLPMNT CONST
41 OTHER TAXES 11,028 1,239,519 2,556,000 1,316,481 51.5
46 INVESTMENT INCOME 404 1,234 11,000 9,766 88.8
47 REIMBURSEMENTS 0 0 0 0
48 OTHER REVENUE 0 0 0 0
49 OTHER FINANCING SOURCES 0 0 0 0
TOTAL DOWNTOWN REDEVLPMNT CONST 11,432 1,240,753 2,567,000 1,326,247 51.7
STREET IMPROVEMENT CONST FUND
41 OTHER TAXES 116,055 354,324 1,506,000 1,151,676 76.5
43 INTERGOVERMENT REV. 0 413,250 210,600 - 202,650 -96.2
46 INVESTMENT INCOME 0 0 1,000 1,000 100.0
47 REIMBURSEMENTS 0 0 0 0
48 OTHER REVENUE 241 3,362 0 -3,362
TOTAL STREET IMPROVEMENT CONST FUND 116,296 770,936 1,717,600 946,664 55.1
FLOOD CONTROL CONST FUND
41 OTHER TAXES 7,575 19,753 105,292 85,539 81.2
42 LICENSES, PERMITS & FEES 535 2,515 45,000 42,485 94.4
43 INTERGOVERMENT REV. 0 57,079 47,500 -9,579 -20.2
46 INVESTMENT INCOME 0 0 1,000 1,000 100.0
TOTAL FLOOD CONTROL CONST FUND 8,110 79,347 198,792 119,445 60.1
WATER AND SEWER FUND
41 OTHER TAXES 1,902 829,777 1,500,000 670,223 44.7
42 LICENSES, PERMITS & FEES 1,250 8,180 16,000 7,820 48.9
44 CHARGES FOR SERVICE 733,722 4,163,551 10,596,000 6,432,449 60.7
46 INVESTMENT INCOME 291 460 92.500 92,040 99.5
47 REIMBURSEMENTS 0 9,450 1,000 -8,450 -845.0
48 OTHER REVENUE 810 9,776 20,000 10,224 51.1
49 OTHER FINANCING SOURCES 0 0 0 0
TOTAL WATER AND SEWER FUND 737,975 5,021,194 12,225,500 7,204,306 58.9
VILLAGE PARKING SYSTEM FUND
41 OTHER TAXES 3,238 8,442 45,000 36,558 81.2
42 LICENSES, PERMITS & FEES 0 0 0 0
44 CHARGES FOR SERVICE 7,209 46,799 106,000 59,201 55.9
46 INVESTMENT INCOME 14 27 1,000 973 97.3
TOTAL VILLAGE PARKING SYSTEM FUND 10,461 55,268 152,000 96,732 63.6
PARKING SYSTEM REVENUE FUND
41 OTHER TAXES 3,957 10,318 55,000 44,682 81.2
44 CHARGES FOR SERVICE 9,488 54,081 104,000 49,919 48.0
46 INVESTMENT INCOME 10 12 500 488 97.6
4
07/15/2010 6 Months ( 50.00 ) Completed
09:51:19 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0 ) Remaining
FRRBRR03
STJMO21 Budget Revenue by Category within Fund Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
TOTAL PARKING SYSTEM REVENUE FUND 13,455 64,411 159,500 95,089 59.6
VEHICLE MAINTENANCE FUND
44 CHARGES FOR SERVICE 137,288 823,721 1,647,442 823,721 50.0
46 INVESTMENT INCOME 74 459 6,750 6,291 93.2
48 OTHER REVENUE 0 125 0 -125
TOTAL VEHICLE MAINTENANCE FUND 137,362 824,305 1,654,192 829,887 50.2
VEHICLE REPLACEMENT FUND
44 CHARGES FOR SERVICE 6,308 37,850 75,700 37,850 50.0
45 FINES AND FORFEITS 3,477 12,685 36,000 23,315 64.8
46 INVESTMENT INCOME 768 3,998 76,500 72,502 94.8
48 OTHER REVENUE 0 0 0 0
49 OTHER FINANCING SOURCES 0 0 50,000 50,000 100.0
TOTAL VEHICLE REPLACEMENT FUND 10,553 54,533 238,200 183,667 77.1
COMPUTER REPLACEMENT FUND
44 CHARGES FOR SERVICE 0 0 0 0
46 INVESTMENT INCOME 114 700 12,000 11,300 94.2
TOTAL COMPUTER REPLACEMENT FUND 114 700 12,000 11,300 94.2
RISK MANAGEMENT FUND
44 CHARGES FOR SERVICE 470,442 2,820,456 5,650,738 2,830,282 50.1
46 INVESTMENT INCOME 271 1,562 31,500 29,938 95.0
47 REIMBURSEMENTS 1,254 5,288 10,000 4,712 47.1
48 OTHER REVENUE 92,281 536,060 1,172,860 636,800 54.3
TOTAL RISK MANAGEMENT FUND 564,248 3,363,366 6,865,098 3,501,732 51.0
POLICE PENSION FUND
46 INVESTMENT INCOME - 1,939,554 - 275,484 2,635,500 2,910,984 110.5
48 OTHER REVENUE 154,505 1,280,849 2,950,000 1,669,151 56.6
TOTAL POLICE PENSION FUND - 1,785,049 1,005,365 5,585,500 4,580,135 82.0
FIRE PENSION FUND
46 INVESTMENT INCOME -1,942,118 - 143,697 2,654,000 2,797,697 105.4
48 OTHER REVENUE 145,619 1,214,172 2,530,300 1,316,128 52.0
TOTAL FIRE PENSION FUND - 1,796,499 1,070,475 5,184,300 4,113,825 79.4
SSA #6 GEORGE /ALBERT B &I
46 INVESTMENT INCOME 0 2 0 -2
TOTAL SSA #6 GEORGE /ALBERT B &I 0 2 0 - 2
GENERAL FIXED ASSETS ACCT GP
47 REIMBURSEMENTS 0 0 0 0
49 OTHER FINANCING SOURCES 0 0 0 0
5
07/15/2010 6 Months ( 50.0e ) Completed
09:51:19 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0 ) Remaining
FRRBRR03
SUMO21 Budget Revenue by Category within Fund Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
TOTAL GENERAL FIXED ASSETS ACCT GP 0 0 0 0
MOUNT PROSPECT LIBRARY FUND
49 OTHER FINANCING SOURCES 0 0 9,715,689 9,715,689 100.0
TOTAL MOUNT PROSPECT LIBRARY FUND 0 0 9,715,689 9,715,689 100.0
c
07/15/2010 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0% ) Completed
09:48:51 6 Months ( 50.0% ) Remaining
Budget Expenditure Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
Expended Expended Budget Balance Percent
EXPENDITURE BY CLASSIFICATION
PERSONAL SERVICES 2,071,611 12,128,555 27,253,599 15,125,044 55.5
EMPLOYEE BENEFITS 752,223 5,179,829 11,075,849 5,896,020 53.2
OTHER EMPLOYEE COSTS 25,815 139,020 461,274 322,254 69.9
PENSION BENEFITS 532,342 3,229,289 6,404,900 3,175,611 49.6
CONTRACTUAL SERVICES 1,367,115 6,838,751 16,941,174 10,102,423 59.6
UTILITIES 100,241 206,829 631,674 424,845 67.3
INSURANCE 472,950 3,279,585 7,175,232 3,895,647 54.3
COMMODITIES & SUPPLIES 149,301 764,525 1,727,411 962,886 55.7
OTHER EXPENDITURES 52,298 118,826 2,628,150 2,509,324 95.5
LAND IMPROVEMENTS 0 0 76,065 76,065 100.0
BUILDING IMPROVEMENTS 578,049 2,524,773 1,260,658 - 1,264,115 -100.3
OFFICE EQUIPMENT -155 123,660 488,343 364,683 74.7
MOBILE EQUIPMENT 44,269 339,196 810,000 470,804 58.1
OTHER EQUIPMENT 78,753 490,243 3,148,636 2,658,393 84.4
DISTRIBUTION SYSTEMS 71,263 147,981 2,870,346 2,722,365 94.8
INFRASTRUCTURE 740,813 1,374,007 3,509,015 2,135,008 60.8
BOND PRINCIPAL 96,389 256,071 1,271,204 1,015,133 79.9
INTEREST EXPENSE 22,014 556,538 1,053,076 496,538 47.2
BANK AND FISCAL FEES 0 878 1,600 722 45.1
INTERFUND TRANSFERS 0 0 0 0
OTHER FINANCING USES 0 0 0 0
Total All Funds 7,155,291 37,698,556 88,788,206 51,089,650 57.5
EXPENDITURE BY FUND
GENERAL FUND 3,063,044 18,347,248 41,145,530 22,798,282 55.4
REFUSE DISPOSAL FUND 364,400 1,846,687 4,240,941 2,394,254 56.5
MOTOR FUEL TAX FUND 649,041 1,175,908 1,736,302 560,394 32.3
LAW ENFORCEMENT BLOCK GRANT 0 0 0 0
COMMUNITY DEVELPMNT BLOCK GRNT 77,869 184,289 565,447 381,158 67.4
ASSET SEIZURE FUND 3,985 5,118 2,000 -3,118 -155.9
DEA SHARED FUNDS FUND 0 0 1,000 1,000 100.0
DUI FINE FUND 343 343 1,500 1,157 77.1
FOREIGN FIRE TAX BOARD FUND 836 19,466 15,500 -3,966 -25.6
SERIES 1987A B &I, PW FACILITY 0 0 0 0
SERIES 2001 B &I, VILLAGE HALL 0 150 382,203 382,053 100.0
SERIES 2003 B &I, VILLAGE HALL 0 191,328 912,658 721,330 79.0
SERIES 2009 B &I, FD /PW 0 209,059 417,663 208,604 49.9
2009B B &I, FD /PW 0 46,640 0 - 46,640
2009C B &I, FD /PW 0 59,635 0 - 59,635
SERIES 1999 B &I, TIF 0 0 0 0
SERIES 1996A B &I, FLOOD 0 0 0 0
SERIES 1998A B &I, FLOOD 0 0 0 0
SERIES 1998C B &I, TIF 0 0 0 0
IEPA FLOOD CONTROL LOANS B &I 118,403 306,675 613,356 306,681 50.0
SERIES 2000 B &I, FLOOD CONTROL 0 0 0 0
CAPITAL IMPROVEMENT FUND 106,900 430,415 2,130,265 1,699,850 79.8
SERIES 2009 CONST FUND 562,562 2,836,028 2,183,633 - 652,395 -29.9
DOWNTOWN REDEVLPMNT CONST 50,453 132,909 2,736,500 2,603,591 95.1
STREET IMPROVEMENT CONST FUND 141,794 367,460 1,575,880 1,208,420 76.7
FLOOD CONTROL CONST FUND 4,266 5,266 161,425 156,159 96.7
WATER AND SEWER FUND 814,651 3,821,809 13,549,749 9,727,940 71.8
1
07/15/2010 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.O% ) Completed
09.48:51 6 Months ( 50.0% ) Remaining
Budget Expenditure Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
Expended Expended Budget Balance Percent
VILLAGE PARKING SYSTEM FUND 9,682 45,013 175,098 130,085 74.3
PARKING SYSTEM REVENUE FUND 11,644 64,789 174,597 109,808 62.9
VEHICLE MAINTENANCE FUND 157,138 831,053 1,814,711 983,658 54.2
VEHICLE REPLACEMENT FUND 44,269 339,196 810,000 470,804 58.1
COMPUTER REPLACEMENT FUND -500 106,829 206,050 99,221 48.2
RISK MANAGEMENT FUND 445,980 3,117,766 6,872,398 3,754,632 54.6
POLICE PENSION FUND 275,497 1,655,906 3,242,300 1,586,394 48.9
FIRE PENSION FUND 253,034 1,551,571 3,121,500 1,569,929 50.3
SSA #6 GEORGE /ALBERT B &I 0 0 0 0
GENERAL FIXED ASSETS ACCT GP 0 0 0 0
GENERAL LONG -TERM DEBT ACCT GP 0 0 0 0
Total All Funds 7,155,291 37,698,556 88,788,206 51,089,650 57.5
07/15/2010 6 Months ( 50.0t ) Completed
09:52:13 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.00 ) Remaining
FRRDBRO1
SUM on Department Budget Expenditure Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
NON - DEPARTMENTAL Expended Expended Budget Balance Percent
PROGRAM TOTALS
00 ADMINISTRATION 0 0 0 0
Totals 0 0 0 0
EXPENDITURE CLASSIFICATION
72 INTEREST EXPENSE 0 0 0 0
Totals 0 0 0 0
SOURCE OF FUNDS
930 GENERAL LONG -TERM DEBT ACCT GP 0 0 0 0
Totals 0 0 0 0
1
•
07/15/2010 6 Months ( 50.0% ) Completed
09 :52:13 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0% ) Remaining
FRRDBR01
SUM031 Department Budget Expenditure Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
PUBLIC REPRESENTATION Expended Expended Budget Balance Percent
PROGRAM TOTALS
02 MAYOR AND BOARD OF TRUSTEES 47,450 113,768 120,261 6,493 5.4
03 ADVISORY BOARDS & COMMISSIONS 354 2,229 6,149 3,920 63.8
Totals 47,804 115,997 126,410 10,413 8.2
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 2,786 16,723 34,311 17,588 51.3
51 EMPLOYEE BENEFITS 507 3,045 6,291 3,246 51.6
52 OTHER EMPLOYEE COSTS 0 112 4,400 4,288 97.5
54 CONTRACTUAL SERVICES 44,451 95,692 76,853 - 18,839 -24.5
55 UTILITIES 23 120 455 335 73.6
57 COMMODITIES & SUPPLIES 37 305 4,100 3,795 92.6
Totals 47,804 115,997 126,410 10,413 8.2
SOURCE OF FUNDS
001 GENERAL FUND 47,804 115,997 126,410 10,413 8.2
Totals 47,804 115,997 126,410 10,413 8.2
07 /15/2010 6 Months ( 50.0% ) Completed
09:52:13 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.05 ) Remaining
FRRDBR01
SUM031 Department Budget Expenditure Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
VILLAGE MANAGER'S OFFICE Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 VILLAGE MANAGER'S OFFICE 43,242 266,210 575,229 309,019 53.7
02 LEGAL SERVICES 60,824 196,153 538,250 342,097 63.6
03 HUMAN RESOURCES 20,734 115,032 265,181 150,149 56.6
04 INFORMATION TECHNOLOGY 46,779 361,583 892,193 530,610 59.5
05 PUBLIC INFORMATION 24,742 95,723 248,098 152,375 61.4
Totals 196,321 1,034,701 2,518,951 1,484,250 58.9
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 76,624 460,361 1,011,435 551,074 54.5
51 EMPLOYEE BENEFITS 25,769 154,596 321,215 166,619 51.9
52 OTHER EMPLOYEE COSTS 3,024 9,557 28,200 18,643 66.1
54 CONTRACTUAL SERVICES 89,144 388,046 1,115,200 727,154 65.2
55 UTILITIES 683 3,022 8,601 5,579 64.9
57 COMMODITIES & SUPPLIES 952 4,633 15,200 10,567 69.5
65 OFFICE EQUIPMENT 125 14,486 19,100 4,614 24.2
67 OTHER EQUIPMENT 0 0 0 0
Totals 196,321 1,034,701 2,518,951 1,484,250 58.9
SOURCE OF FUNDS
001 GENERAL FUND 196,321 1,034,701 2,518,951 1,484,250 58.9
Totals 196,321 1,034,701 2,518,951 1,484,250 58.9
1
07/15/2010 6 Months ( 50.0% ) Completed
09:52:13 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0% ) Remaining
FRRDBR01
SUM 031 Department Budget Expenditure Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
TV SERVICES DIVISION Expended Expended Budget Balance Percent
PROGRAM TOTALS
02 CABLE TV OPERATIONS 12,377 71,247 139,639 68,392 49.0
04 INTERGOVERNMENTAL PROGRAMMING 5,377 26,006 62,410 36,404 58.3
Totals 17,754 97,253 202,049 104,796 51.9
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 9,145 53,848 114,194 60,346 52.8
51 EMPLOYEE BENEFITS 3,619 21,417 44,177 22,760 51.5
52 OTHER EMPLOYEE COSTS 0 725 700 -25 -3.6
54 CONTRACTUAL SERVICES 1,438 10,576 27,378 16,802 61.4
55 UTILITIES 154 800 1,600 800 50.0
57 COMMODITIES & SUPPLIES 1,281 3,492 5,500 2,008 36.5
67 OTHER EQUIPMENT 2,117 6,395 8,500 2,105 24.8
Totals 17,754 97,253 202,049 104,796 51.9
SOURCE OF FUNDS
001 GENERAL FUND 17,754 97,253 202,049 104,796 51.9
Totals 17,754 97,253 202,049 104,796 51.9
07/15/2010 6 Months ( 50.0% ) Completed
09:52:13 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0W ) Remaining
FRRDBR01
SLIM on Department Budget Expenditure Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
VILLAGE CLERK' S OFFICE Expended Expended Budget Balance Percent
PROGRAM TOTALS
02 VILLAGE CLERK'S OFFICE 15,462 92,492 208,643 116,151 55.7
Totals 15,462 92,492 208,643 116,151 55.7
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 9,231 60,669 126,804 66,135 52.2
51 EMPLOYEE BENEFITS 3,708 23,127 47,646 24,519 51.5
52 OTHER EMPLOYEE COSTS 60 393 1,485 1,092 73.5
54 CONTRACTUAL SERVICES 2,056 7,421 29,679 22,258 75.0
55 UTILITIES 77 400 1,549 1,149 74.2
57 COMMODITIES & SUPPLIES 330 482 1,480 998 67.4
Totals 15,462 92,492 208,643 116,151 55.7
SOURCE OF FUNDS
001 GENERAL FUND 15,462 92,492 208,643 116,151 55.7
Totals 15,462 92,492 208,643 116,151 55.7
5
•
07/15/2010 6 Months ( 50.0% ) Completed
09:52:13 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0 %) Remaining
FRRDBR01
SuM 031 Department Budget Expenditure Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
FINANCE DEPARTMENT Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 FINANCE ADMINISTRATION 24,693 152,547 359,820 207,273 57.6
02 ACCOUNTING 37,176 224,741 491,793 267,052 54.3
05 INSURANCE PROGRAMS 25,471 153,038 311,872 158,834 50.9
06 CUSTOMER SERVICE 28,122 195,476 420,812 225,336 53.5
07 CASH MANAGEMENT 2,187 13,271 28,416 15,145 53.3
Totals 117,649 739,073 1,612,713 873,640 54.2
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 61,721 376,489 843,557 467,068 55.4
51 EMPLOYEE BENEFITS 24,346 147,342 312,122 164,780 52.8
52 OTHER EMPLOYEE COSTS 213 1,979 5,650 3,671 65.0
54 CONTRACTUAL SERVICES 11,366 88,377 181,213 92,836 51.2
55 UTILITIES 388 2,044 4,900 2,856 58.3
56 INSURANCE 19,393 116,356 232,711 116,355 50.0
57 COMMODITIES & SUPPLIES 222 6,486 32,160 25,674 79.8
65 OFFICE EQUIPMENT 0 0 400 400 100.0
Totals 117,649 739,073 1,612,713 873,640 54.2
SOURCE OF FUNDS
001 GENERAL FUND 117,649 739,073 1,612,713 873,640 54.2
Totals 117,649 739,073 1,612,713 873,640 54.2
6
07/15/2010 6 Months ( 50.0% ) Completed
09:52:13 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.00 ) Remaining
FRRDBRO1
SUM031 Department Budget Expenditure Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
COMMUNITY DEVELOPMENT Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 COMMUNITY DEVELOPMENT ADMIN 18,597 116,584 261,596 145,012 55.4
02 PLANNING & ZONING 28,899 125,746 333,616 207,870 62.3
03 ECONOMIC DEVELOPMENT 6,058 41,371 95,383 54,012 56.6
05 BUILDING INSPECTIONS 66,174 395,191 940,912 545,721 58.0
06 HOUSING INSPECTIONS 44,351 234,999 529,946 294,947 55.7
07 HEALTH INSPECTIONS 9,179 58,326 128,093 69,767 54.5
Totals 173,258 972,217 2,289,546 1,317,329 57.5
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 105,436 628,136 1,402,026 773,890 55.2
51 EMPLOYEE BENEFITS 42,722 257,322 541,145 283,823 52.4
52 OTHER EMPLOYEE COSTS 654 8,009 31,246 23,237 74.4
54 CONTRACTUAL SERVICES 22,398 67,476 269,117 201,641 74.9
55 UTILITIES 1,039 5,033 17,671 12,638 71.5
57 COMMODITIES & SUPPLIES 1,009 6,241 24,141 17,900 74.1
65 OFFICE EQUIPMENT 0 0 4,200 4,200 100.0
Totals 173,258 972,217 2,289,546 1,317,329 57.5
SOURCE OF FUNDS
001 GENERAL FUND 173,258 972,217 2,288,046 1,315,829 57.5
550 DOWNTOWN REDEVLPMNT CONST 0 0 1,500 1,500 100.0
Totals 173,258 972,217 2,289,546 1,317,329 57.5
7
07/15/2010 6 Months ( 50.00 ) Completed
09:52:13 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0% ) Remaining
FRRDBROI
SUM031 Department Budget Expenditure Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
COMMUNITY DEVELOPMENT - CDBG Expended Expended Budget Balance Percent
PROGRAM TOTALS
04 CDBG ADMINISTRATION 863 33,591 94,947 61,356 64.6
05 CDBG COMMUNITY PROGRAMS 19,125 46,782 90,500 43,718 48.3
06 ACCESSIBLTY & NEIGHBRHD IMPRV 0 3,360 100,000 96,640 96.6
07 CDBG RESIDENTIAL REHAB 18,539 37,543 280,000 242,457 86.6
08 CDBG RECOVERY ACT 39,342 63,013 0 - 63,013
Totals 77,869 184,289 565,447 381,158 67.4
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 4,345 26,090 62,569 36,479 58.3
51 EMPLOYEE BENEFITS 1,811 10,861 23,311 12,450 53.4
52 OTHER EMPLOYEE COSTS 0 25 1,965 1,940 98.7
54 CONTRACTUAL SERVICES 19,415 57,349 106,625 49,276 46.2
57 COMMODITIES & SUPPLIES 0 81 977 896 91.7
59 OTHER EXPENDITURES 52,298 86,523 200,000 113,477 56.7
62 LAND IMPROVEMENTS 0 0 50,000 50,000 100.0
69 INFRASTRUCTURE 0 3,360 120,000 116,640 97.2
Totals 77,869 184,289 565,447 381,158 67.4
SOURCE OF FUNDS
070 COMMUNITY DEVELPMNT BLOCK GRNT 77,869 184,289 565,447 381,158 67.4
Totals 77,869 184,289 565,447 381,158 67.4
e
07/15/2010 6 Months ( 50.0% ) Completed
09:52:13 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0% ) Remaining
FRRDBRO1
SUrM031 Department Budget Expenditure Summary
01/01/10 - 06/30/10
Cur Mo Y - - 2010 Unexpended Unexpended
HUMAN SERVICES Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 HUMAN SERVICES ADMINISTRATION 12,061 82,538 184,075 101,537 55.2
02 SOCIAL SERVICES 29,141 178,513 389,713 211,200 54.2
03 NURSING /HEALTH SERVICES 14,729 90,721 239,089 148,368 62.1
04 SENIOR CITIZEN LEIS ACTIVITIES 2,728 14,402 35,821 21,419 59.8
05 COMMUNITY CONNECTIONS CENTER 22,248 135,191 306,071 170,880 55.8
Totals 80,907 501,365 1,154,769 653,404 56.6
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 52,087 321,238 689,812 368,574 53.4
51 EMPLOYEE BENEFITS 19,139 116,533 241,687 125,154 51.8
52 OTHER EMPLOYEE COSTS 25 937 12,581 11,644 92.6
54 CONTRACTUAL SERVICES 8,135 51,547 154,168 102,621 66.6
55 UTILITIES 930 5,230 14,756 9,526 64.6
57 COMMODITIES & SUPPLIES 591 5,880 39,065 33,185 84.9
64 BUILDING IMPROVEMENTS 0 0 0 0
65 OFFICE EQUIPMENT 0 0 2,700 2,700 100.0
Totals 80,907 501,365 1,154,769 653,404 56.6
SOURCE OF FUNDS
001 GENERAL FUND 80,907 501,365 1,154,769 653,404 56.6
Totals 80,907 501,365 1,154,769 653,404 56.6
9
07/15/2010 6 Months ( 50.0% ) Completed
09:52:13 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0% ) Remaining
FRRDBR01
SUM 031 Department Budget Expenditure Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
PUBLIC WORKS - ADMINISTRATION Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 PUBLIC WORKS ADMINISTRATION 81,736 478,949 982,823 503,874 51.3
Totals 81,736 478,949 982,823 503,874 51.3
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 16,378 108,961 234,319 125,358 53.5
51 EMPLOYEE BENEFITS 11,977 73,664 149,319 75,655 50.7
52 OTHER EMPLOYEE COSTS 4,242 12,185 25,802 13,617 52.8
54 CONTRACTUAL SERVICES 45,649 266,766 538,489 271,723 50.5
55 UTILITIES 1,288 6,704 19,470 12,766 65.6
57 COMMODITIES & SUPPLIES 2,202 10,669 15,169 4,500 29.7
65 OFFICE EQUIPMENT 0 0 0 0
67 OTHER EQUIPMENT 0 0 255 255 100.0
Totals 81,736 478,949 982,823 503,874 51.3
SOURCE OF FUNDS
001 GENERAL FUND 81,736 478,949 982,823 503,874 51.3
Totals 81,736 478,949 982,823 503,874 51.3
12
07/15/2010 6 Months ( 50.0. ) Completed
09:52:13 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.00) Remaining
FRRDBR01
SUM 031 Department Budget Expenditure Summary
01/01/10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
PUBLIC WORKS - STREETS /BLDGS Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 STREET DIVISION ADMINISTRATION 10,105 82,799 161,866 79,067 48.8
02 MAINTENANCE - PUBLIC BUILDINGS 79,952 416,768 1,010,405 593,637 58.8
04 STREET MAINTENANCE 22,759 97,569 418,912 321,343 76.7
05 SNOW REMOVAL 13,315 456,185 669,384 213,199 31.9
06 LEAF REMOVAL 0 0 0 0
07 STORM SEWER & BASIN MAINT 10,188 41,939 112,657 70,718 62.8
08 MAINTENANCE OF STATE HIGHWAYS 2,647 39,403 70,394 30,991 44.0
09 TRAFFIC SIGN MAINTENANCE 11,758 52,968 122,044 69,076 56.6
10 VILLAGE PARKING LOT MAINT 9,682 45,013 175,098 130,085 74.3
11 PARKING LOT MAINTENANCE 11,644 64,789 149,597 84,808 56.7
12 FLOOD CONTROL 0 0 0 0
13 STORM EVENT 0 0 0 0
Totals 172,050 1,297,433 2,890,357 1,592,924 55.1
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 83,897 583,262 1,246,055 662,793 53.2
51 EMPLOYEE BENEFITS 27,878 178,435 382,210 203,775 53.3
54 CONTRACTUAL SERVICES 30,310 271,827 726,159 454,332 62.6
55 UTILITIES 8,435 17,461 79,230 61,769 78.0
56 INSURANCE 158 948 1,894 946 49.9
57 COMMODITIES & SUPPLIES 15,934 239,102 394,954 155,852 39.5
59 OTHER EXPENDITURES 0 0 0 0
64 BUILDING IMPROVEMENTS 3,360 4,265 19,855 15,590 78.5
67 OTHER EQUIPMENT 0 0 0 0
69 INFRASTRUCTURE 2,078 2,133 40,000 37,867 94.7
Totals 172,050 1,297,433 2,890,357 1,592,924 55.1
SOURCE OF FUNDS
001 GENERAL FUND 150,724 1,031,597 2,266,230 1,234,633 54.5
050 MOTOR FUEL TAX FUND 0 156,034 299,432 143,398 47.9
620 VILLAGE PARKING SYSTEM FUND 9,682 45,013 175,098 130,085 74.3
630 PARKING SYSTEM REVENUE FUND 11,644 64,789 149,597 84,808 56.7
Totals 172,050 1,297,433 2,890,357 1,592,924 55.1
13
07/15/2010 6 Months ( 50.0% ) Completed
09:52:13 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0W ) Remaining
FRRDBR01
SUM031 Department Budget Expenditure Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
PUBLIC WORKS - FORESTRY /GRNDS Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 FORESTRY DIVISION ADMIN 17,367 108,112 237,763 129,651 54.5
02 MAINTENANCE OF GROUNDS 38,529 167,181 473,321 306,140 64.7
03 FORESTRY PROGRAM 83,250 433,852 998,138 564,286 56.5
04 PUBLIC GROUNDS BEAUTIFICATION 23,009 37,655 72,010 34,355 47.7
Totals 162,155 746,800 1,781,232 1,034,432 58.1
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 61,841 322,355 761,579 439,224 57.7
51 EMPLOYEE BENEFITS 19,866 114,406 246,330 131,924 53.6
52 OTHER EMPLOYEE COSTS 2,769 3,662 3,662 0
54 CONTRACTUAL SERVICES 54,264 278,541 718,112 439,571 61.2
57 COMMODITIES & SUPPLIES 23,415 27,836 51,549 23,713 46.0
67 OTHER EQUIPMENT 0 0 0 0
Totals 162,155 746,800 1,781,232 1,034,432 58.1
SOURCE OF FUNDS
001 GENERAL FUND 162,155 746,800 1,762,432 1,015,632 57.6
690 RISK MANAGEMENT FUND 0 0 18,800 18,800 100.0
Totals 162,155 746,800 1,781,232 1,034,432 58.1
•
14
07/15/2010 6 Months ( 50.00 ) Completed
09:52:13 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.00) Remaining
FRRDBR01
SUM031 Department Budget Expenditure Summary
01/01/10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
PUBLIC WORKS - ENGINEERING Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 ENGINEERING SERVICES 63,969 367,193 831,493 464,300 55.8
05 TRAFFIC CNTRL & STREET LGHTNG 89,571 169,016 756,494 587,478 77.7
Totals 153,540 536,209 1,587,987 1,051,778 66.2
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 55,143 312,001 701,400 389,399 55.5
51 EMPLOYEE BENEFITS 16,552 98,855 211,200 112,345 53.2
52 OTHER EMPLOYEE COSTS 0 2,090 3,552 1,462 41.2
54 CONTRACTUAL SERVICES 4,250 35,986 131,796 95,810 72.7
55 UTILITIES 73,944 77,078 225,000 147,922 65.7
57 COMMODITIES & SUPPLIES 3,651 10,199 32,855 22,656 69.0
65 OFFICE EQUIPMENT 0 0 546 546 100.0
67 OTHER EQUIPMENT 0 0 1,638 1,638 100.0
69 INFRASTRUCTURE 0 0 280,000 280,000 100.0
Totals 153,540 536,209 1,587,987 1,051,778 66.2
SOURCE OF FUNDS
001 GENERAL FUND 77,139 436,335 1,071,117 634,782 59.3
050 MOTOR FUEL TAX FUND 76,401 99,874 516,870 416,996 80.7
Totals 153,540 536,209 1,587,987 1,051,778 66.2
15
07/15/2010 6 Months ( 50.0% ) Completed
09:52:13 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0t ) Remaining
FRRDBROI
SUMo31 Department Budget Expenditure Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
PUBLIC WORKS - WATER /SEWER Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 WATER & SEWER DIVISION ADMIN 113,308 655,514 1,415,111 759,597 53.7
02 MAINTENANCE OF BUILDINGS 13,974 86,371 226,997 140,626 62.0
03 MAINTENANCE OF GROUNDS 13,036 48,731 136,428 87,697 64.3
04 WATER SUPPLY MAINT & REPAIR 51,190 306,740 1,585,848 1,279,108 80.7
05 WATER DISTRBT MAINT & REPAIR 84,945 301,745 868,982 567,237 65.3
06 WATER VALVE /HYDRNT MAINT & REP 25,387 156,817 413,162 256,345 62.0
07 WATER METER MAINT & REPL 24,224 115,781 963,266 847,485 88.0
08 EQUIPMENT MAINTENANCE 42,889 257,334 514,668 257,334 50.0
09 SANITARY SEWER MAINT & REPAIR 46,965 246,412 1,079,772 833,360 77.2
10 WATER & SEWER SYSTEM IMPROV 80,858 157,613 2,315,515 2,157,902 93.2
12 LAKE MICHIGAN WATER SUPPLY 317,875 1,488,751 4,030,000 2,541,249 63.1
Totals 814,651 3,821,809 13,549,749 9,727,940 71.8
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 139,275 822,513 1,900,352 1,077,839 56.7
51 EMPLOYEE BENEFITS 51,764 311,934 671,563 359,629 53.6
52 OTHER EMPLOYEE COSTS 1,253 15,661 57,336 41,675 72.7
54 CONTRACTUAL SERVICES 513,487 2,307,107 6,202,726 3,895,619 62.8
55 UTILITIES 7,082 57,211 185,406 128,195 69.1
56 INSURANCE 5,524 33,148 66,295 33,147 50.0
57 COMMODITIES & SUPPLIES 15,983 95,634 291,120 195,486 67.1
59 OTHER EXPENDITURES 0 0 0 0
65 OFFICE EQUIPMENT 220 220 7,652 7,432 97.1
67 OTHER EQUIPMENT 8,800 30,400 1,296,953 1,266,553 97.7
68 DISTRIBUTION SYSTEMS 71,263 147,981 2,870,346 2,722,365 94.8
Totals 814,651 3,821,809 13,549,749 9,727,940 71.8
SOURCE OF FUNDS
610 WATER AND SEWER FUND 814,651 3,821,809 13,549,749 9,727,940 71.8
Totals 814,651 3,821,809 13,549,749 9,727,940 71.8
16
07/15/2010 6 Months ( 50.0 % - ) Completed
09:52:13 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0% ) Remaining
FRRDBRO1
SUM 031 Department Budget Expenditure Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
PUBLIC WORKS - REFUSE DISPOSAL Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 REFUSE DISPOSAL PROGRAM 353,519 1,785,018 4,019,373 2,234,355 55.6
02 REFUSE LEAF REMOVAL PROGRAM 10,881 61,669 221,568 159,899 72.2
Totals 364,400 1,846,687 4,240,941 2,394,254 56.5
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 15,056 84,817 251,942 167,125 66.3
51 EMPLOYEE BENEFITS 5,253 31,695 77,148 45,453 58.9
52 OTHER EMPLOYEE COSTS 0 0 1,200 1,200 100.0
54 CONTRACTUAL SERVICES 335,430 1,710,842 3,853,608 2,142,766 55.6
55 UTILITIES 31 160 572 412 72.0
56 INSURANCE 1,895 11,367 22,734 11,367 50.0
57 COMMODITIES & SUPPLIES 6,735 7,806 33,737 25,931 76.9
Totals 364,400 1,846,687 4,240,941 2,394,254 56.5
SOURCE OF FUNDS
030 REFUSE DISPOSAL FUND 364,400 1,846,687 4,240,941 2,394,254 56.5
Totals 364,400 1,846,687 4,240,941 2,394,254 56.5
17
07/15/2010 6 Months ( 50.00 ) Completed
09:52:13 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0% ) Remaining
FRRDBR01
SUM 031 Department Budget Expenditure Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
PUBLIC WORKS - VEHICLE MAINT Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 VEHICLE MAINTENANCE ADMIN 12,667 89,415 180,836 91,421 50.6
02 VEHICLE MAINTENANCE PROGRAM 144,471 741,638 1,633,875 892,237 54.6
Totals 157,138 831,053 1,814,711 983,658 54.2
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 67,488 389,526 879,792 490,266 55.7
51 EMPLOYEE BENEFITS 23,642 140,154 301,789 161,635 53.6
52 OTHER EMPLOYEE COSTS 314 1,898 2,315 417 18.0
54 CONTRACTUAL SERVICES 10,160 30,138 95,738 65,600 68.5
55 UTILITIES 77 400 993 593 59.7
57 COMMODITIES & SUPPLIES 55,378 268,858 530,039 261,181 49.3
59 OTHER EXPENDITURES 0 0 0 0
65 OFFICE EQUIPMENT 0 0 545 545 100.0
67 OTHER EQUIPMENT 79 79 3,500 3,421 97.7
Totals 157,138 831,053 1,814,711 983,658 54.2
SOURCE OF FUNDS
660 VEHICLE MAINTENANCE FUND 157,138 831,053 1,814,711 983,658 54.2
Totals 157,138 831,053 1,814,711 983,658 54.2
18
07/15/2010 6 Months ( 50.0% ) Completed
09:52:13 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0% ) Remaining
FRRDBR01
suMo3l Department Budget Expenditure Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
COMMUNITY SERVICE PROGRAMS Expended Expended Budget Balance Percent
PROGRAM TOTALS
02 COMMUNITY GROUPS & MISC 5,791 53,845 136,400 82,555 60.5
03 4TH OF JULY & CIVIC EVENTS,ETC 19,968 32,122 167,252 135,130 80.8
04 HOLIDAY DECORATIONS 651 14,914 81,330 66,416 81.7
05 BLOOD DONOR PROGRAM 233 1,330 2,774 1,444 52.1
Totals 26,643 102,211 387,756 285,545 73.6
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 12,698 19,851 100,731 80,880 80.3
51 EMPLOYEE BENEFITS 2,259 3,984 18,660 14,676 78.6
54 CONTRACTUAL SERVICES 5,791 54,515 207,785 153,270 73.8
57 COMMODITIES & SUPPLIES 5,895 23,861 52,580 28,719 54.6
59 OTHER EXPENDITURES 0 0 8,000 8,000 100.0
Totals 26,643 102,211 387,756 285,545 73.6
SOURCE OF FUNDS
001 GENERAL FUND 26,643 102,211 387,756 285,545 73.6
Totals 26,643 102,211 387,756 285,545 73.6
19
07/15/2010 6 Months ( 50.0% ) Completed
09:52:13 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0% ) Remaining
FRRDBR01
SUM o31 Department Budget Expenditure Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
CAPITAL IMPROVEMENT PROJECTS Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 VILLAGE IMPROVEMENTS & EQUIP 106,930 359,695 1,829,500 1,469,805 80.3
02 COMMUNITY IMPROVEMENT PROJECTS 0 24,752 155,765 131,013 84.1
03 DOWNTOWN REDEVELOPMENT CONST 50,453 132,909 2,735,000 2,602,091 95.1
04 FLOOD CONTROL PROJECTS 4,266 5,266 161,425 156,159 96.7
06 STREET IMPROVEMENT PROJECTS 714,434 1,333,458 2,665,880 1,332,422 50.0
09 MOTOR EQUIPMENT REPLACEMENT 44,269 339,196 810,000 470,804 58.1
10 COMPUTER REPLACEMENT -500 106,829 206,050 99,221 48.2
11 STATION 14 422,109 2,266,754 1,380,963 - 885,791 -64.1
12 EMERGENCY OPERATION CENTER 37,266 196,679 456,741 260,062 56.9
13 PUBLIC WORKS EXPANSION 103,157 372,565 345,929 - 26,636 -7.7
Totals 1,482,384 5,138,103 10,747,253 5,609,150 52.2
EXPENDITURE CLASSIFICATION
54 CONTRACTUAL SERVICES 63,436 337,702 1,005,820 668,118 66.4
59 OTHER EXPENDITURES 0 32,303 2,420,150 2,387,847 98.7
62 LAND IMPROVEMENTS 0 0 26,065 26,065 100.0
64 BUILDING IMPROVEMENTS 574,689 2,520,508 1,237,003 - 1,283,505 -103.8
65 OFFICE EQUIPMENT -500 107,829 438,050 330,221 75.4
66 MOBILE EQUIPMENT 44,269 339,196 810,000 470,804 58.1
67 OTHER EQUIPMENT 61,755 432,051 1,741,150 1,309,099 75.2
69 INFRASTRUCTURE 738,735 1,368,514 3,069,015 1,700,501 55.4
71 BOND PRINCIPAL 0 0 0 0
72 INTEREST EXPENSE 0 0 0 0
80 INTERFUND TRANSFERS 0 0 0 0
Totals 1,482,384 5,138,103 10,747,253 5,609,150 52.2
SOURCE OF FUNDS
050 MOTOR FUEL TAX FUND 572,640 920,000 920,000 0
510 CAPITAL IMPROVEMENT FUND 106,900 430,415 2,130,265 1,699,850 79.8
528 SERIES 2009 CONST FUND 562,562 2,836,028 2,183,633 - 652,395 -29.9
550 DOWNTOWN REDEVLPMNT CONST 50,453 132,909 2,735,000 2,602,091 95.1
560 STREET IMPROVEMENT CONST FUND 141,794 367,460 1,575,880 1,206,420 76.7
590 FLOOD CONTROL CONST FUND 4,266 5,266 161,425 156,159 96.7
630 PARKING SYSTEM REVENUE FUND 0 0 25,000 25,000 100.0
670 VEHICLE REPLACEMENT FUND 44,269 339,196 810,000 470,804 58.1
680 COMPUTER REPLACEMENT FUND -500 106,829 206,050 99,221 48.2
Totals 1,482,384 5,138,103 10,747,253 5,609,150 52.2
20
07/15/2010 6 Months ( 50.0% ) Completed
09:52:13 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0% ) Remaining
FRRDBR01
SUM o31 Department Budget Expenditure Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
DEBT SERVICE Expended Expended Budget Balance Percent
PROGRAM TOTALS
02 DEBT SERVICE - PROPERTY TAXES 0 506,812 1,712,524 1,205,712 70.4
03 DEBT SERVICE - TAX INCREMENT 0 0 0 0
04 DEBT SERVICE - H/R SALES TAX 1 118,403 306,675 613,356 306,681 50.0
06 SPECIAL SERVICE AREA B & I 0 0 0 0
Totals 118,403 813,487 2,325,880 1,512,393 65.0
EXPENDITURE CLASSIFICATION
54 CONTRACTUAL SERVICES 0 0 0 0
59 OTHER EXPENDITURES 0 0 0 0
71 BOND PRINCIPAL 96,389 256,071 1,271,204 1,015,133 79.9
72 INTEREST EXPENSE 22,014 556,538 1,053,076 496,538 47.2
73 BANK AND FISCAL FEES 0 878 1,600 722 45.1
80 INTERFUND TRANSFERS 0 0 0 0
81 OTHER FINANCING USES 0 0 0 0
Totals 118,403 813,487 2,325,880 1,512,393 65.0
SOURCE OF FUNDS
140 SERIES 1987A B &I, PW FACILITY 0 0 0 0
180 SERIES 2001 B &I, VILLAGE HALL 0 150 382,203 382,053 100.0
190 SERIES 2003 B &I, VILLAGE HALL 0 191,328 912,658 721,330 79.0
195 SERIES 2009 B &I, FD /PW 0 209,059 417,663 208,604 49.9
196 2009B B &I, FD /PW 0 46,640 0 - 46,640
197 2009C B &I, FD /PW 0 59,635 0 - 59,635
290 SERIES 1999 B &I, TIF 0 0 0 0
340 SERIES 1996A B &I, FLOOD 0 0 0 0
350 SERIES 1998A B &I, FLOOD 0 0 0 0
360 SERIES 1998C B &I, TIF 0 0 0 0
380 IEPA FLOOD CONTROL LOANS B &I 118,403 306,675 613,356 306,681 50.0
390 SERIES 2000 B &I, FLOOD CONTROL 0 0 0 0
830 SSA #6 GEORGE /ALBERT B &I 0 0 0 0
Totals 118,403 813,487 2,325,880 1,512,393 65.0
21
07/15/2010 6 Months ( 50.0% ) Completed
09:52:13 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.(A ) Remaining
FRRDBR01
Svr4031 Department Budget Expenditure Summary
01/01/10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
RETIREE PENSIONS Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 MISCELLANEOUS PENSIONS 3,811 22,862 46,600 23,738 50.9
02 POLICE PENSIONS 275,497 1,655,906 3,242,300 1,586,394 48.9
03 FIRE PENSIONS 253,034 1,551,571 3,121,500 1,569,929 50.3
Totals 532,342 3,230,339 6,410,400 3,180,061 49.6
EXPENDITURE CLASSIFICATION
53 PENSION BENEFITS 532,342 3,229,289 6,404,400 3,175,111 49.6
54 CONTRACTUAL SERVICES 0 1,050 4,500 3,450 76.7
57 COMMODITIES & SUPPLIES 0 0 1,500 1,500 100.0
Totals 532,342 3,230,339 6,410,400 3,180,061 49.6
SOURCE OF FUNDS
001 GENERAL FUND 3,811 22,862 46,600 23,738 50.9
710 POLICE PENSION FUND 275,497 1,655,906 3,242,300 1,586,394 48.9
720 FIRE PENSION FUND 253,034 1,551,571 3,121,500 1,569,929 50.3
Totals 532,342 3,230,339 6,410,400 3,180,061 49.6
22
07/15/2010 6 Months ( 50.0% ) Completed
09:52:13 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.00) Remaining
FRRDBR01
SUM on. Department Budget Expenditure Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
RISK MANAGEMENT Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 CASUALTY & PROPERTY INSURANCE 13,208 523,788 927,700 403,912 43.5
02 MEDICAL INSURANCE 432,772 2,593,978 5,925,898 3,331,920 56.2
Totals 445,980 3,117,766 6,853,598 3,735,832 54.5
EXPENDITURE CLASSIFICATION
54 CONTRACTUAL SERVICES 0 0 2,000 2,000 100.0
56 INSURANCE 445,980 3,117,766 6,851,598 3,733,832 54.5
67 OTHER EQUIPMENT 0 0 0 0
Totals 445,980 3,117,766 6,853,598 3,735,832 54.5
SOURCE OF FUNDS
690 RISK MANAGEMENT FUND 445,980 3,117,766 6,853,598 3,735,832 54.5
Totals 445,980 3,117,766 6,853,598 3,735,832 54.5
23
07/15/2010 6 Months ( 50.0 ) Completed
09:52:13 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0% ) Remaining .
FRRDBRO1
sU4o31 Department Budget Expenditure Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
NON - DEPARTMENTAL Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 CONTINGENCIES 0 0 0 0
Totals 0 0 0 0
EXPENDITURE CLASSIFICATION
80 INTERFUND TRANSFERS 0 0 0 0
Totals 0 0 0 0
SOURCE OF FUNDS
001 GENERAL FUND 0 0 0 0
Totals 0 0 0 0
24
07/15/2010 6 Months ( 50.(A ) Completed
09:52:13 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.CM ) Remaining
FRRDBRO1
SUM031 Department Budget Expenditure Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
CAPITAL FIXED ASSETS Expended Expended Budget Balance Percent
PROGRAM TOTALS
00 CAPITAL FIXED ASSETS 0 0 0 0
Totals 0 0 0 0
EXPENDITURE CLASSIFICATION
59 OTHER EXPENDITURES 0 0 0 0
Totals 0 0 0 0
SOURCE OF FUNDS
910 GENERAL FIXED ASSETS ACCT GP 0 0 0 0
Totals 0 0 0 0
25
07/15/2010 6 Months ( 50.0% ) Completed
09:52:13 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.00 ) Remaining
FRRDBRO1
SUM 031 Department Budget Expenditure Summary
01 /01 /10 - 06/30/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
MOUNT PROSPECT LIBRARY Expended Expended Budget Balance Percent
PROGRAM TOTALS
02 LIBRARY SERVICES 0 0 9,715,689 9,715,689 100.0
Totals 0 0 9,715,689 9,715,689 100.0
EXPENDITURE CLASSIFICATION
90 COMPONENT UNIT EXPENDITURES 0 0 9,715,689 9,715,689 100.0
Totals 0 0 9,715,689 9,715,689 100.0
SOURCE OF FUNDS
950 MOUNT PROSPECT LIBRARY FUND 0 0 9,715,689 9,715,689 100.0
Totals 0 0 9,715,689 9,715,689 100.0
26
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY JUL132010 11:56 PAGE 1
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 01 2010 TO JULY 14 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
001
04630 AATP ETHICS SEMINAR - K.SHEAGREN 8/13 95.00
07921 ACCOMANDO, JOE VOLUNTEER DRIVE APR,MAY,JUN 10 35.00
01071 ADDISON BUILDING MATERIAL CO. OUTLET SUPPLIES FOR VILLAGE HA 43.76
STREETLIGHT MATERIALS 28.54
MISC. SUPPLIES FOR 4TH OF JULY 87.97
ECLIPSE COT. CLOSELINE 7/32X50 11.58
171.85
01246 AIRGAS NORTH CENTRAL OXYGEN & CYLINDER RENTAL 170.34
09619 ALANIZ LANDSCAPING GROUP TURF MOWING AT VARIOUS LOCATIO 3641.34
01335 ALEXIAN BROTHERS CORPORATE HEALTH SERVICES PRE-EMPLOYMENT DT /PHYSICALS -PW 69.00
08110 AMBIUS ANNUAL SERVICE /MAINTENANCE 1081.80
09380 AMERICAN BUILDING SERVICES LOCKSETS FOR HUNTINGTON LIFT, 48.69
REPIN 13 LOCKS 130.00
VON DOPRIN QUICK CONNECT HARNE 332.00
DUMMY CYLINDERS FOR OH DOORS 6 244.00
754.69
08042 AMERICAN SOLUTIONS FOR BUSINESS 2,000 COMPLIANCE TICKETS 485.11
10,000 PARKING TICKETS 2024.14
2509.25
01833 ANDERSON LOCK COMPANY STRAIGHT DOOR PULL; STANDARD C 92.58
00372 ANDLER, GLEN REIMB EXP. FEB 2010 -JUNE 2010 85.11
REIMB EXP. FEB 2010-JUNE 2010 125.52
REIMB EXP. FEB 2010 -JUNE 2010 156.90
367.53
02270 AT &T SERVICE 6/16/10 - 7/15/10 3.21
SERVICE 6 /16/10- 7/15/10 10.71
SERVICE 6/16/10-7/15/10 2.14
SERVICE 6/16/10 - 7/15/10 3.21
SERVICE 6/16/10 - 7/15/10 21.42
SERVICE 6/16/10- 7/15/10 10.71
SERVICE 6/16/10 - 7/15/10 40.70
SERVICE 6/16/10 - 7/15/10 10.71
SERVICE 6/16/10 - 7/15/10 16.07
SERVICE 6/16/10 - 7/15/10 27.85
SERVICE 6/16/10 - 7/15/10 8.57
SERVICE 6/16/10 - 7/15/10 8.57
SERVICE 6/16/10 - 7/15/10 38.56
SERVICE 6/16/10 - 7/15/10 217.45
SERVICE 6/16/10 - 7/15/10 213.16
SERVICE 6/16/10 - 7/15/10 137.11
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY JUL132010 11:56 PAGE 2
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 01 2010 TO JULY 14 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
770.15
10729 AUTUMN LANDSCAPING INC SPRINKLER MAINTENANCE PER REQU 2060.00
10517 AVANTI CAFE & SANDWICH BAR,INC. DINNER - FINANCE COMM.MEETING 163.00
02472 BAHNMAIER, IRENE VOLUNTEER DRIVE APR,MAY,JUN 10 45.50
10040 BARTELS PLANTS, INC. ANNUAL FLOWERS PER ATTACHED LI 3722.40
11624 BECKER - KRISTUFEK, KRISTINE VOLUNTEER DRIVE APR,MAY,JUN 10 21.00
06287 BEDCO MECHANICAL 2010 MAINTENANCE CONTRACT FOR 1558.85
2010 MAINTENANCE CONTRACT FOR 1842.70
3401.55
05600 BENCIC, CHARLES VOLUNTEER DRIVE APR,MAY,JUN 10 35.00
07142 BENNETT, CHARLES VOLUNTEER DRIVE APR,MAY,JUN 10 35.00
02757 BESSE MEDICAL SUPPLY CHOLESTEROL SUPPLIES 32.73
05051 BLUE SAINTS 4TH OF JULY PARADE 2010 1500.00
09609 BONO,CSR,LTD., KATHLEEN COURT REPORTER ATTENDANCE 6/3 331.20
02938 BOWMAN DISTRIBUTION CENTER BANNER HARDWARE 137.40
11455 BRIGGS, ART VOLUNTEER DRIVE APR,MAY,JUN 10 73.50
07930 BROGAN, KIRSTEN VOLUNTEER DRIVE APR,MAY,JUN 10 45.50
11480 BUILDER 1YR SUBSCRIPTION - W.SCHROEDER 69.95
10736 BURGER, JEFF REIMB SAFETY SHOE 7/6/10 160.00
01008 BUSSE'S FLOWERS & GIFTS Floral Arrangement/ Tucker Nic 60.00
SERVICE FEE 3.50
63.50
06297 CAPANNARI'S ICE CREAM DELIVERY CHARGE 6/27/10 86.61
01045 CATCHING FLUIDPOWER 20 NIPPLE MALE PARKER HOSE FIT 37.17
20 SOCKET PARKER HOSE FITTING; 108.19
145.36
01049 CDW GOVERNMENT, INC MS OFFICE PRO 2010 FOR ADD'L F 316.41
PGP UNIV SRV ANNUAL MAINTENANC 2000.00
PGP WHOLE DISK ENCRYPTION ANNU 1750.00
4066.41
01056 CENTRAL CONTINENTAL BAKERY BAKERY STORE ITEMS FOR PW OPEN 326.03
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY JUL132010 11:56 PAGE 3
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 01 2010 TO JULY 14 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
05375 CENTURY CLEANERS UNIFORM CLEANING6 /24 &6/25 &6/26 43.50
UNIFORM CLEANING 7/1 &7/2 &7/12 45.67
UNIFORM CLEANING 7/3/10&7/7/10 43.50
132.67
01077 CHICAGO COMMUNICATIONS LLC RADIO MAINT. AUG,SEP,OCT 2010 1903.95
01084 CHICAGO TRIBUNE #949996001 AD- ART &BLUES FEST 1592.00
#949996002 AD- ART &BLUES FEST 1592.00
#949996003 AD- ART &BLUES FEST 1592.00
4776.00
01088 CHIEF SUPPLY CORP. BATTERIES 61.96
12291 CIESIELSKI, ERIC SUMEMR INTERN JUNE 2010 100.00
07281 CL GRAPHICS, INC. #51187 SUMMER NEWSLETTER 10920.00
#14181 MAILING 350.00
11270.00
06670 CLARTON, FRANK & JOAN VOLUNTEER DRIVE APR,MAY,JUN 10 31.50
12310 COGAN, BETTE REIMB SIDEWALK 1 SQ PUBLIC W 55.00
09422 COLACICCO, CAROL VOLUNTEER DRIVE APR,MAY,JUN 10 45.50
00309 COONEY, WILLIAM J. REIMB EXP 5/22/10 - 5/25/10 1314.40
11403 COSTAR REALTY INFORMATION, INC ED SITE SOFTWARE 435.00
06745 CROWN TROPHY BLK PLATE & ENGRAVING 63.00
11408 CRYSTAL COURT SHOPPING CENTER JULY 2010 RENT & WATER 3358.00
05503 CRYSTAL MAINTENANCE SERVICES CORP. CCC SHARE OF MONTHLY CLEANING 590.00
CUSTODIAL SERVICE AT VILLAGE 7529.44
8119.44
01218 DAHLBERG, JOHN REIMB 6/29 - 30,7/1,7/2,7/4/,1 /6 157.40
REIMB 6/8,6/11,6/17,6 /18,6/28 96.96
254.36
10102 DOWLING, JOAN & ED VOLUNTEER DRIVE APR,MAY,JUN 10 38.50
01329 EL- DINARY, SAID & PHYLLIS VOLUNTEER DRIVE APR,MAY,JUN 10 45.50
09653 ETERNO, DAVID G. PROFESSIONAL SERV 6/23 -6/24 349.50
08814 EVANS, TIM REIMB EXP 6/30/10 50.78
01366 EXPERIAN BACKGROUND CHECKS JUNE 2010 77.00
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY JUL132010 11:56 PAGE 4
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 01 2010 TO JULY 14 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
10393 EXPERTPAY PAYROLL FOR - 070110 3266.41
11212 FDC DIGITAL IMAGING SOLUTIONS ANNUAL MAINTENANCE FOR KIP PLO 59.00
01377 FEDERAL EXPRESS CORP SHIPPING CHARGES 20.38
SHIPPING FEES 46.20
QAL -TEK ASSOCIATES REPAIR 33.42
SHIPPING CHARGES 20.38
120.38
00102 FIRE PENSION FUND PAYROLL FOR - 070110 21645.08
01412 FLEET SAFETY SUPPLY OUTER EAR CUP FOAM 156.00
07261 FRIZANE, KENNETH 4TH OF JULY PARADE 2010 300.00
09198 GE CAPITAL SERVICE 6/15/10 - 7/14/10 198.96
SERVICE 6/15/10- 7/14/10 198.94
SERVICE 6/15/10 - 7/14/10 198.94
SERVICE 6/15/10- 7/14/10 198.94
795.78
12292 GLENN, SHAUN REFUND OVER PYMT V.LICENSE 9.00
12127 GOLF ROSE ANIMAL HOSPITAL STRAYS - JUNE 2010 318.00
01522 GRAINGER 12IN DUCT FAN 854.88
01522 GRAINGER INC. WHITE HARD CAP 46.64
12304 GRAY, BRIAN & DIANE REAL ESTATE TAX REBATE 2010 710.00
12296 GREENBERG, JOSHUA SUMMER INTERN JUNE 2010 100.00
12299 GURAK, KAMIL REFUND OVER PYMT #C53380 5.00
09113 HEALY ASPHALT COMPANY,LLC. 8.45 TONS UPM MATERIAL DELIVER 912.60
1.29 TONS ASPHALT SURFACE MATE 70.95
1.96 TONS ASPHALT SURFACE MATE 107.80
1.04 TONS ASPHALT SURFACE MATE 57.20
0.97 TONS ASPHALT SURFACE MATE 53.35
1.09 TONS ASPHALT SURFACE MATE 59.95
1.04 TONS ASPHALT SURFACE MATE 57.20
1319.05
12207 HIGH 5 PRINTWEAR INC Summer T- Shirts 2967.65
04360 HOLTZ, RAY VOLUNTEER DRIVE APR,MAY,JUN 10 45.50
09425 HSBC BUSINESS SOLUTIONS PANASONIC SC -HC20 STEREO 89.99
PHOTO EVIDENCE 99.96
INVESTGATIONS' PRINTER 99.99
PRINTER 99.76
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY JUL132010 11:56 PAGE 5
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 01 2010 TO JULY 14 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
4TH OF JULY PARADE 115.06
BLUES FEST SUPPLIES 333.64
AMERICAN IDOL- REFRESHMENTS 71.07
BOARD MEETING-REFRESHMENTS 34.76
OFFICE SUPPLIES 66.94
BLUES FEST LIGHTS 44.97
BLUES FEST TENTS /LIGHTS 614.31
RETURN 26.34 -
SALES TAX REFUND 28.12-
1615.99
01636 IACE QUARTERLY MEETING - A.PANEK 30.00
QUARTERLY MEETING - C.SCHERBAUM 30.00
QUARTERLY MEETING- J.HERNANDEZ 30.00
QUARTERLY MEETING - M.YOUSIF 30.00
QUARTERLY MEETING-R.GARCIA 30.00
QUARTERLY MEETING- S.DUNN 30.00
QUARTERLY MEETING - W.SCHROEDER 30.00
QUARTERLY MEETING - K,DEWIS 30.00
240.00
01650 ICMA MEMBERSHIP 2010 -2011 M.DALLAS 289.80
00107 ICMA RETIREMENT TRUST - 457 PAYROLL FOR - 070110 18488.74
00108 ILLINOIS DEPARTMENT OF REVENUE PAYROLL FOR - 070110 24747.98
01681 ILLINOIS FIRE CHIEFS ASSOC. MEMBERSHIP - M.FIGOLAH ACCT #619 300.00
MEMBERSHIP - C.TRUTY ACCT #1292 40.00
MEMBERSHIP - C.LIVINGSTON #1293 40.00
MEMBERSHIP - H.DAWSON ACCT #1294 40.00
420.00
01701 ILLINOIS PAPER CO. 40 CTNS COPY PAPER 1180.00
06142 ILLINOIS REGION - MARC 4TH OF JULY PARADE 2010 300.00
01712 ILLINOIS STATE POLICE BACKGROUND CHECKS JUNE 2010 239.50
07433 IMAGETEC L P LEASE PAYMENT FOR TOSHIBA COPI 246.00
09562 IMRF PAYROLL FOR - 070110 478.91
PAYROLL FOR - 070110 43259.35
PAYROLL FOR - 070110 19904.61
63642.87
01743 INTERNATIONAL ASSOCIATION OF FIRE CHIEFS REGISTRATION-U.RANDY 8/24 -8/28 475.00
REGISTRATION - D.HENRY 8/24 -8/28 475.00
950.00
09832 INTERNATIONAL UNION OF OPERATING ENGINEERS PAYROLL FOR - 070110 986.88
PAYROLL FOR - 070110 284.13
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY JUL132010 11:56 PAGE 6
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 01 2010 TO JULY 14 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
1271.01
01753 IPELRA IPELRA SUPERVISORY TRAINING 75.00
09563 IRS PAYROLL FOR - 070110 192944.00
01772 JESSE WHITE TUMBLING TEAM 4TH OF JULY PARADE 2010 950.00
10823 JOE WALEGA HAPPY HEARTS 4TH OF JULY PARADE 2010 850.00
12309 JOHNSON, MARIE REIMB EXP 7/3/10 56.95
01783 JOURNAL & TOPICS NEWSPAPERS 1/4 PAGE AD - EXMP 288.00
PROGRESS EDITION AD 698.00
LEGAL -2009 TREASUER'S REPORT 775.00
1/4 PAGE AD - EXMP 288.00
2049.00
01838 KRAMER TREE SPECIALISTS #232549 SPRAY TREATMENTS -TREES 1383.00
#232551 SPRAY TREATMENTS-TREES 72.00
1455.00
01851 LAB SAFETY SUPPLY 1 ACID PROOF CABINET 419.90
00371 LANDEWEER, MICHAEL REIMB EXP 6/28 - 7/2/10 40.00
09766 LANER MUCHIN LEGAL SERVICES 6/20/10 367.50
12288 LAUTERBACH & AMEN, LLP AUDITING SERVICES 2009 18750.00
AUDITING SERVICES 2009 2250.00
21000.00
06608 LAW OFFICES OF CARY J. COLLINS LEGAL SERVICES JULY,AUG,SEPT10 700.00
08631 LECHNER AND SONS PW UNIFORM RENTAL AND CLEANING 116.43
PW UNIFORM RENTAL AND CLEANING 116.43
232.86
10450 LEXISNEXIS RISK DATA MANAGEMENT INC BACKGROUND CHECKS JUNE 2010 90.40
01897 LIFE ASSIST 3 BLOOD PRESSURE KITS 788.19
07923 LINSKEY, BARBARA & ED VOLUNTEER DRIVE APR,MAY,JUN 10 35.00
01915 LUNDIN, RAY VOLUNTEER DRIVE APR,MAY,JUN 10 73.50
01918 LUNDSTROM'S NURSERY, INC. LANDSCAPE MAINTENANCE AT VARIO 3111.78
09163 MAALA, MARIO VOLUNTEER DRIVE APR,MAY,JUN 10 42.00
11233 MAY, LANA VOLUNTEER DRIVE APR,MAY,JUN 10 21.00
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY JOL132010 11:56 PAGE 7
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 01 2010 TO JULY 14 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
05021 MENARDS MISCELLANEOUS SUPPLIES 26.37
MISCELLANEOUS SUPPLIES 77.51
MISCELLANEOUS SUPPLIES 46.12
STANDARD BALLASTS 34.90
9 SAWZALL BLADES & 1 BOARD 46.45
MISCELLANEOUS SUPPLIES 30.41
261.76
01502 MES- ILLINOIS 12 - PBI HOODS 273.81
00116 METRO FEDERAL CREDIT UNION PAYROLL FOR - 070110 2493.48
00117 METROPOLITAN ALLIANCE - POLICE PAYROLL FOR - 070110 1010.50
09523 MICRO TECH SYSTEMS,INC. REPAIR SERVICE TO TOSHIBA 2860 172.45
02046 MOBILE PRINT INC. BUSINESS CARDS - SKIC,MILLER,JIM 79.54
11331 MOORE LANDSCAPES, INC D/T HANGING BASKET MAINTENANCE 912.00
02068 MOUNT PROSPECT LIONS CLUB, INC FARMERS MARKET AD -SPLIT 262.50
06003 MT.PROSPECT PARK DISTRICT 4TH OF JULY PARADE 2010 350.00
07791 MURPHY, WILLIAM VOLUNTEER DRIVE APR,MAY,JON 10 3.50
00123 NATIONWIDE MUTUAL INSURANCE COMPANY PAYROLL FOR - 070110 15997.46
02148 NEOPOST INC. MONEY ENTERED INTO POSTAGE M. 3000.00
07905 NEW GENERATION FANCY DRILL TEAM 4TH OF JULY PARADE 2010 2000.00
02155 NEXTEL COMMUNICATIONS SERVICE 5/18/10-6/17/10 715.94
SERVICE 5/18/10- 6/17/10 102.48
SERVICE 5/18/10 - 6/17/10 95.16
SERVICE 5/18/10- 6/17/10 491.48
SERVICE 5/18/10 - 6/17/10 28.08
SERVICE 5/18/10 - 6/17/10 186.35
SERVICE 5/18/10- 6/17/10 28.08
SERVICE 5/18/10- 6/17/10 1291.05
SERVICE 5/18/10 - 6/17/10 219.88
SERVICE 5/18/10- 6/17/10 1434.03
4592.53
05256 NICOR NATURAL GAS CONSUMPTION AT 160 137.49
NATURAL GAS CONSUMPTION AT 172 49.11
NATURAL GAS CONSUMPTION AT 112 163.05
NATURAL GAS CONSUMPTION AT 50 1581.14
NATURAL GAS CONSUMPTION AT 200 312.86
2243.65
02170 NORTH EAST MULTI REGIONAL TRNG REGISTRATION- C.HUIZAR 75.00
07564 NORTHERN SAFETY CO. INSPECTION SUPPLIES 41.50
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY JUL132010 11:56 PAGE 8
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 01 2010 TO JULY 14 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
02187 NORTHWEST ASSOC. OF PROVIDER EMS COORDINATORS 2010 MEMBERSHIP - W.SELEEN 50.00
02189 NORTHWEST CENTRAL DISPATCH SYS AUGUST 2010 MEMBER ASSESSMENT 36767.60
AUGUST 2010 MEMBER ASSESSMENT 9191.90
45959.50
02193 NORTHWEST ELECTRICAL SUPPLY MISC. ELECTRICAL SUPPLIES 189.77
05124 NORTHWESTERN UNIVERSITY CTR FOR PUBLIC SAFETY 3 ATTENDEES - SGT.GARRIS GRAD 135.00
02228 OAKTON PAVILLION HEALTHCARE 606 HOME DELIVERED MEALS 06/10 2424.00
10163 ON TIME INC. UNIFORM SUPPLIES 256.50
07863 PACON CORPORATION DECORATIONS FOR 4TH OF JULY PA 682.05
02256 PADDOCK PUBLICATIONS LEGAL NOTICE 6/23/10 40.50
02256 PADDOCK PUBLICATIONS INC ART FEST /BLUES FEST 6/4/10 722.46
ARTFEST /BLUES FEST 6/6/10 722.46
ARTFEST /BLUES FEST 6/11/10 722.46
ARTFEST /BLUES FEST 6/13/10 722.46
ARTFEST /BLUES FEST 6/18/10 722.47
3612.31
10366 PARK RIDGE TAXI SENIOR TAXI PROGRAM JUNE 2010 161.40
12311 PARKE HOTEL LLC IATAI CONE 9/15- 9/17/10 598.08
10216 PAUL HALL COMMUNITY CENTER 4TH OF JULY PARADE 2010 1000.00
05257 PESCHE'S FLOWER SHOP WHITE HANGING BASKETS 179.91
RED HANGING BASKETS 179.91
DELPHINIUMS 89.91
449.73
02305 PETTY CASH - PUBLIC WORKS TRAVEL & SUPPLIES 2010 27.60
TRAVEL & SUPPLIES 2010 171.57
199.17
00124 POLICE PENSION FUND PAYROLL FOR - 070110 26268.41
07927 POORE, MURIEL VOLUNTEER DRIVE APR,MAY,JUN 10 38.50
04921 POPE, ELIZABETH A. PAYROLL FOR - 070110 923.08
02338 PRAIRIE BRASS BAND 4TH OF JULY PARADE 2010 2000.00
02339 PRCHAL, ARLENE & PAUL VOLUNTEER DRIVE APR,MAY,JUN 10 45.50
02536 PROFORMA CUSTOMIZED GRAPHICS OPEN HOUSE GIVE -AWAYS 94.36
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY JUL132010 11:56 PAGE 9
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 01 2010 TO JULY 14 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
02363 PROSPECT MARCHING KNIGHTS 4TH OF JULY PARADE 2010 2000.00
12227 PROTECH SERVICES 1 YEAR WARRANTY AGREEMENT FOR 1800.00
02379 QUILL CORPORATION OFFICE SUPPLIES 62.24
OFFICE SUPPLIES 54.02
OFFICE SUPPLIES 5.59
121.85
02401 RED WING SHOE STORE PURCHASE OF SAFETY SHOES - TON 89.99
10983 RIVARD, JOHN ADVANCE COURSE EXP 10/18 -12/12 296.00
09010 RUSSO POWER EQUIPMENT STHIL BG 86 HAND BLOWERS 189.00
STHIL FS 90 R STRING TRIMMERS 0.90
STHIL FS 90 R STRING TRIMMERS 101.00
STHIL FS 90 R STRING TRIMMERS 348.10
639.00
07127 SERVICE SANITATION,INC. PORTA POTTIES FOR BLUES /ART FE 850.00
06671 SHEEHAN, DOT & JACK VOLUNTEER DRIVE APR,MAY,JUN 10 42.00
03803 SHORE GALLERIES, INC. MISCELLANEOUS AMMUNITION 1020.00
05975 SIGNS BY TOMORROW DECALS FOR EXISTING BLUES /ART 637.50
24 IDOL BANNERS 1080.00
DECALS FOR BLOCK PARTY BANNERS 1027.30
2744.80
07058 SOUTH SHORE DRILL TEAM &PERFORMING ARTS 4TH OF JULY PARADE 2010 3500.00
12061 SPERIAN PROTECTION AMERICAS, INC 1 Biosystem Test Machine Ca1ib 575.00
09478 SPORTS AUTHORITY Various Footwear 5929.67
02155 SPRINT SERVICE 5/24/10- 6/23/10 39.99
09165 STAPLES BUSINESS ADVANTAGE SUPPLIES 35.94
04532 TAYLOR RENTAL CENTER TENTS, CHAIRS, TABLES AND LIGH 3582.66
02691 THOMPSON ELEVATOR INSPECTIONS 11 SEMI - ANNUAL RE- INSPECTIONS 407.00
18 SEMI - ANNUAL RE- INSPECTIONS 666.00
1073.00
04217 TIMOTHY W. SHARPE SERVICE MARCH 2010 -JUNE 2010 2500.00
11261 TUCKER, TOM REIMB EXP 7/6/10 30.00
REIMB EXP 6/15/10 &6/22/10 55.00
85.00
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY JUL132010 11:56 PAGE 10
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 01 2010 TO JULY 14 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
11277 TYGRIS VENDOR FINANCE, INC SERVICE 6/24/10 - 7/23/10 467.29
SERVICE 6/24/10 - 7/23/10 321.91
SERVICE 6/24/10 - 7/23/10 456.90
SERVICE 6/24/10 - 7/23/10 830.73
SERVICE 6/24/10 - 7/23/10 16.80
SERVICE 6/24/10 - 7/23/10 16.80
SERVICE 6/24/10 - 7/23/10 16.80
SERVICE 6/24/10- 7/23/10 16.80
SERVICE 6/25/10 - 7/24/10 372.46
2516.49
12300 UNDERW00D, RICHARD REIMB SIDEWALK 1SQ PUBLIC WALK 55.00
07526 UNITED PARCEL SERVICE SHIPPING EQUIP REPAIRS 16.15
02756 UNITED STATES POSTAL SERVICE EMS CARDS JUNE 2010 16.33
PUBLIC INFORMATION JUNE 2010 3453.58
DELIVERY STATISTICS RETRIEVAL 75.00
3544.91
00127 UNITED WAY PAYROLL FOR - 070110 372.64
12001 US BANK 7/20/10 USAGE & LATE CHARGE 199.42
7/20/10 USAGE & LATE CHARGE 269.42
7/20/10 USAGE & LATE CHARGE 279.43
7/20/10 USAGE & LATE CHARGE 199.43
7/20/10 USAGE & LATE CHARGE 160.43
7/20/10 USAGE & LATE CHARGE 143.21
7/20/10 USAGE & LATE CHARGE 141.93
1393.27
11427 VICTORIA GROUP, INC EVENT #E14335 DEPOSIT 10/21/10 140.00
09527 VILLAGE CYCLESPORT BIKE CHAIN REPLACEMENT 18.99
00128 VILLAGE OF MOUNT PROSPECT PAYROLL FOR - 070110 24020.85
PAYROLL FOR - 070110 12690.64
36711.49
09580 VILLAGE OF ROMEOVILLE FIRE ACADEMY Registration/ Miller, Lloyd 540.00
02835 WAREHOUSE DIRECT 12 USB FLASH DRIVES 119.88
10974 WDCB PUBLIC RADIO- UNDERWRITING RADIO AD- ART /BLUES FEST 2010 495.00
12298 WEST, CHARLES H REFUND OVER PYMT V. LICENSE 18.00
05476 WGN FLAG & DECORATING CO. AMERICAN FLAGS FOR 4TH OF JULY 1684.56
MISC. SUPPLIES FOR 4TH OF JULY 195.50
1880.06
05746 WISCTF PAYROLL FOR - 070110 542.48
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY JUL132010 11:56 PAGE 11
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 01 2010 TO JULY 14 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
12157 ZADEL, CAROLINE VOLUNTEER DRIVE APR,MAY,JUN 10 24.50
TOTAL : 624625.87
030
02270 AT &T SERVICE 6/16/10- 7/15/10 4.28
12305 LEO, EILEEN REFUND FINAL UTILITY 25.00
12306 PEMIDOV, ALEXANDRE REFUND FINAL UTILITY BILL 12.50
02536 PROFORMA CUSTOMIZED GRAPHICS RECYCLED SUPPLIES 210.00
TOTAL : 251.78
050
05709 MEADE ELECTRIC CO. INC. 2010 EMERGENCY & PREVENTATIVE 1976.00
TOTAL : 1976.00
070
01050 CEDA NORTHWEST SELF -HELP CTR 2ND QUARTER 2010 DAYCARE PROG 1375.00
2ND QUARTER 2010 EMERGENCY H.P 2125.00
3500.00
09198 GE CAPITAL SERVICE 6/15/10-7/14/10 198.94
08442 GREATER WHEELING YOUTH OUTREACH INC. SUMMER ADVENTURE CAMP NORTH 3500.00
SUMMER ADVENTURE CAMP SOUTH 3500.00
7000.00
11277 TYGRIS VENDOR FINANCE, INC SERVICE 6/24/10-7/23/10 16.80
TOTAL : 10715.74
095
01227 AIR ONE EQUIPMENT, INC. BELT RESCUE KEVLAR SCBA MOUNT 9480.00
TOTAL : 9480.00
510
09380 AMERICAN BUILDING SERVICES REPLACEMENT LOCKS AND LOCKSETS 1205.00
PROXIMITY CARD FOR VEHICLE 1797.00
LOCK CORES, CYLINDERS, AND 4506.00
7508.00
01049 CDW GOVERNMENT, INC CISCO CS1-AIR- LAP1252G -A -K9 WA 2520.00
POWER INJECTOR FOR CISCO 1252 294.00
SHIPPING 14.99
2828.99
08766 CENTRAL RUG AND CARPET CO. INSTALLATION OF LEVELING CEMEN 9795.00
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY JUL132010 11:56 PAGE 12
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 01 2010 TO JULY 14 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
12307 GRANZOW, NEIL REBATE ENERGY EFFICIENCY HOME 1500.00
09425 HSBC BUSINESS SOLUTIONS SALES TAX REFUND 28.13-
09912 MOUNT PROSPECT PAINT,INC. PAINT AND MISC. PAINT SUPPLIES 170.07
11970 NEW WORLD SYSTEMS CORPORATION ERP SOFTWARE APPLICATIONS - VB 10400.00
10720 SCHOOL OUTFITTERS LLC 1 ENCLOSED BULLETIN BOARD 124.81
12308 SEYMOUR, BILL REBATE ENERGY EFFICIENCY HOME 980.00
12273 TESSCO INCORPORATED 14X12X6 MIMO ENCLOSURE FOR WAP 470.40
2.4 /5GHz 6dBi MIMO OMNI ANTENN 1048.71
SHIPPING 13.87
1532.98
02835 WAREHOUSE DIRECT FURNITURE FOR FRONT DESK AREA 12723.34
UNLOAD & INSTALL FURNITURE 1370.00
14093.34
TOTAL : 48905.06
528
09046 BRADFORD SYSTEMS CORPORATION Shelving at New Station #14 13595.80
01049 CDW GOVERNMENT, INC POWER STRIP A/V CABINET ST #14 16.10
INV #SST2631 CABLES 46.04
INV #SXX4133 BELKIN 25FT 20.32
82.46
11507 FUERTE SYSTEMS, INC CONSTRUCTION OF RT PD ATHLETIC 38223.30
09425 HSBC BUSINESS SOLUTIONS STATION #14 DEDICATION CEREMONY 256.29
12233 LUCENTA TIRE & EQUIPMENT, INC COATS 7065AX RIM CLAMP TIRE 6595.00
COATS 1000 WHEEL BALANCER (220 2552.00
113276C CONE KIT 163.75
9310.75
02444 RIVER TRAILS PARK DISTRICT FOAM FENCE PAD -RTPD A.FIELD 600.00
06406 SRBL ARCHITECHTS, LTD. OVERAGE PO #S009833 240.49
Architectural Services for Fir 15266.12
15506.61
TOTAL : 77575.21
550
07730 ADVANCED PAVEMENT TECHNOLOGIES BRICK PAVER SEALING CONTRACT F 1292.17
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY JUL132610 11:56 PAGE 13
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 01 2010 TO JULY 14 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
01716 ILLINOIS TAX INCREMENT ASSOC. JULY2010 - JUNE2010 375.00
01918 LUNDSTROM'S NURSERY, INC. LANDSCAPE MAINTENANCE AT VARIO 7441.22
TOTAL : 9108.39
560
04417 QUALITY BLACKTOP INC. STREET REPAIRS. 5248.62
11774 RUBINO ENGINEERING, INC 2010 MATERIAL TESTING. 1600.00
TOTAL : 6848.62
610
01071 ADDISON BUILDING MATERIAL CO. PAINT SUPPLIES FOR HYDRANT PAI 21.53
METER SUPPLIES 32.43
PAINT SUPPLIES 61.15
PAINT SUPPLIES 128.04
MEASURING WHEEL 48.95
HYDRO -PLUG SAKRETE CONCRETE FO 78.46
FITTINGS FOR JULY 4TH FESTIVAL 9.67
CAUTION TAPE 10.79
391.02
07730 ADVANCED PAVEMENT TECHNOLOGIES RETAINAGE RELEASE 2009 1707.81
09619 ALANIZ LANDSCAPING GROUP TURF MOWING AT VARIOUS LOCATIO 1059.10
09380 AMERICAN BUILDING SERVICES LOCKSETS FOR HUNTINGTON LIFT, 711.36
00372 ANDLER, GLEN REIMB EXP. FEB 2010 -JUNE 2010 154.63
09673 APWA-IPSI REGISTRATION FEE FOR JOHN 695.00
02270 AT &T SERVICE 6/16/10 - 7/15/10 286.03
05773 BAXTER & WOODMAN, INC. SANITARY SEWER EVALUATION STUD 247.50
PROFESSIONAL SERVICES FOR 2010 13472.10
PROFESSIONAL SERVICES FOR 2010 8981.40
22701.00
01049 CDW GOVERNMENT, INC 2 - CRYSTAL 2008 UPGRADE 270.00
3 - CRYSTAL 2008 FULL 894.00
1164.00
09682 CE DESIGN,LTD. ENGINEERING SERV - PROSPECT MEAD 834.10
05375 CENTURY CLEANERS UNIFORM CLEANING6 /24 &6/25 &6/26 43.50
UNIFORM CLEANING 7/1 &7/2 &7/12 45.68
UNIFORM CLEANING 7/3/10 &7/7/10 43.50
132.68
12291 CHEAPEST LLC 1506 MURA REFUND FINAL UTILITY BILL 25.00
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY JUL132010 11:56 PAGE 14
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 01 2010 TO JULY 14 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
06345 CONSERV F /S, INC. 2 - 1GAL JUG OF PENNANT MAGNUM 414.80
06160 ENTERPRISE RENT -A -CAR 4 MONTH RENTAL OF A FULL SIZE 832.09
01377 FEDERAL EXPRESS CORP SHIPPING CHARGES 33.24
01544 HBK WATER METER SERVICE WATER METER 7338.75
BUILDING INSPECTION SERVICES. 2446.25
9785.00
01757 ILLINOIS SECTION AWWA REGISTRATION FEE FOR JAY GOMEZ 200.00
07433 IMAGETEC L P LEASE PAYMENT FOR TOSHIBA C0P1 246.00
01819 KIEFT BROTHERS INC. 48 "X24" OFFSET CONE 159.00
01858 LAKE -COOK LAND SURVEY SURVEY -1480 N.ELMHORST RD 2900.00
12288 LAUTERBACH & AMEN, LLP AUDITING SERVICES 2009 6250.00
AUDITING SERVICES 2009 750.00
7000.00
08631 LECHNER AND SONS PW UNIFORM RENTAL AND CLEANING 116.41
PW UNIFORM RENTAL AND CLEANING 116.41
232.82
01965 MARTAM CONSTRUCTION DEBRIS DISPOSAL - SEWER REPAIR 1624.90
05021 MENARDS FILTERS FOR FILTRATION SYSTEM 6.48
FILTERS FOR FILTRATION SYSTEM 30.98
37.46
05256 NICOR NATURAL GAS CONSUMPTION AT 117 189.41
NATURAL GAS CONSUMPTION AT 112 62.58
NATURAL GAS CONSUMPTION AT SS 88.83
340.82
12293 PAPPAS, GEORGE REFUND FINAL UTILITY BILL 22.58
12306 PEMIDOV, ALEXANDRE REFUND FINAL UTILITY BILL 10.00
02536 PROFORMA CUSTOMIZED GRAPHICS OPEN HOUSE GIVE-AWAYS 218.13
OPEN HOUSE GIVE -AWAYS 69.51
#1056 SHIPPING /SET UP CHARGES 185.08
#1057 SHIPPING /SET UP CHARGES 552.09
1024.81
04417 QUALITY BLACKTOP INC. PAVEMENT REPAIRS DUE TO SPOT 932.88
12294 RICKARD, JOE REFUND FINAL UTILITY BILL 64.62
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY JUL132010 11:56 PAGE 15
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 01 2010 TO JULY 14 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
10916 SEMPRA ENERGY SOLUTIONS LLC PHYSICAL ENERGY JUNE08 &DEC08 5193.63
PHYSICAL ENERGY MAY 2010 886.57
PHYSICAL ENERGY MAY 2010 2938.37
PHYSICAL ENERGY JAN09 &JULY09 2843.63
11862.20
08612 SLESICKI, KYLE SAFETY SHOES REIMBURSEMENT 160.00
02655 SUBURBAN LABORATORIES, INC. ANNUAL IEPA - REQUIRED WATER SAM 106.17
ANNUAL IEPA - REQUIRED WATER SAM 39.83
146.00
02756 UNITED STATES POSTAL SERVICE PERMIT 699 -WATER JUNE 2010 2052.10
12001 US BANK 7/20/10 USAGE & LATE CHARGE 141.93
02775 USA BLUEBOOK 50FT'ERS 3/4" GRAY PVC DRINKIN 299.37
02914 ZIEBELL WATER SERVICE PRODUCTS VALVE PARTS 335.91
CURB STOP FOR EMERGENCY B -BOX 159.00
494.91
TOTAL : 70879.26
620
01071 ADDISON BUILDING MATERIAL CO. 5 "X1000' TAPE ROLL 13.49
05503 CRYSTAL MAINTENANCE SERVICES CORP. CUSTODIAL SERVICE AT VILLAGE 1481.40
02193 NORTHWEST ELECTRICAL SUPPLY PARKING DECK LIGHTS 101.72
TOTAL : 1596.61
630
05503 CRYSTAL MAINTENANCE SERVICES CORP. CUSTODIAL SERVICE AT VILLAGE 189.16
05256 NICOR NATURAL GAS CONSUMPTION AT 11 22.54
TOTAL : 211.70
660
01071 ADDISON BUILDING MATERIAL CO. AIRLINE BUSHINGS 4.58
SHOP SUPPLIES 44.18
48.76
02070 ARLINGTON HEIGHTS FORD TRANSMISSION SEAL 16.50
CV POLICE (2) WINDOW SWITCH AS 99.64
LUMBAR SEAT SWITCH COVER FOR P 15.19
131.33
02270 AT &T SERVICE 6/16/10 - 7/15/10 10.71
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY JUL132010 11:56 PAGE 16
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 01 2010 TO JULY 14 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
01045 CATCHING FLUIDPOWER 3-WASH BAY PRESSURE HOSES 230.33
PIPE ADAPTERS FOR SPRAY BOOTH 6.04
HYD. LINE FOR TRUCK #4536 76.83
313.20
09610 CERTIFIED FLEET SERVICES,INC. OEM DOOR SWITCHES AND RIVERTS 291.96
03958 CHICAGO INTERNATIONAL TRUCK OEM E -BRAKE CONTROL VALVE FOR 174.86
01236 DAVE & JIM'S AUTO BODY, INC. #12827 REAPIR P -6 50.00
#12975 REPAIR P -20A 371.90
421.90
08154 GLOBAL EMERGENCY PRODUCTS PUMP PANEL SWITCHES FOR FIRE T 22.64
01750 INTERSTATE BATTERY 3 BATTERIES (P -5; 2731; FIRE T 254.85
06691 JUST TIRES 9 CV SQUAD TIRES 913.50
01914 LUND INDUSTRIES, INC. C.V. POLICE WARNING LIGHTS 132.00
12200 MARTIN IMPLEMENT SALES, INC FREIGHT CHARGE FOR DIRECT SHIP 45.19
OEM PARTS FOR TRUCK #45 705.63
750.82
01990 MCMASTER -CARR SUPPLY CO. PIANO HINGE WITHOUT HOLES; DOW 42.87
02107 NAPA - HEIGHTS AUTOMOTIVE SUPPLY A/C DYE 17.98
NAPA OIL FILTER FOR TRUCK 4453 8.55
TRAILER ELECTRIC BRAKES FOR 45 11.94
NAPA FUEL AND OIL FILTER 3.21
INTAKE MANIFOLD FOR TRUCK #309 231.97
OIL FILTERS FOR FIRE TRUCK #54 8.84
2 POWER OUTLETS FOR STOCK 13.98
POWER OUTLET FOR FIRE TRUCK #5 6.99
303.46
04101 NATIONAL PARTS NETWORK,LLC DBA SPI 0150010. RADIATOR FOR V -56 122.77
02155 NEXTEL COMMUNICATIONS SERVICE 5/18/10-6/17/10 2.80-
02193 NORTHWEST ELECTRICAL SUPPLY FIRE SHORELINE MALE ELECTRIC P 32.57
02327 POMP'S TIRE SERVICE, INC. NEW TIRE FOR P -1 149.51
07663 PRAIRIE INTERNATIONAL TRUCK SALES ALTERNATOR FOR NEW TRUCKS # 45 210.36
AIR DRYER FILTER; COOLANT; WAT 653.36
C -BRACK ARM; MIRROR HEAD FOR T 39.90
903.62
02355 PRO FINISH CLEANER FOR AROUND FUEL ISLAND 114.80
REPORT • APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY JOL132010 11:56 PAGE 17
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 01 2010 TO JULY 14 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
01191 R.L. CORTY & COMPANY REPLACE PRESSURE WASHER NOZZLE 221.00
09423 RONCO INDUSTRIAL SUPPLY 6 - SHOP AIR TIRE INFLATOR GAG 251.00
FIRE MECHANICS LADDER 231.95
DISPOSABLE GLOVES 198.60
WINDEX FOAMING CLEANER 50.50
732.05
02491 SAUBER MFG. CO. R/R TOOL BOX(CUSTOM TO OUR SPE 541.00
02684 TERRACE SUPPLY COMPANY HELIUM CYLINDER RENTAL 124.12
HELIUM CYLINDER DELIVERY CHARG 19.75
TIG ROD FOR MILLER WELDER 44.28
188.15
04472 TEXOR PETROLEUM CO FUEL PURCHASE 6/24/10 18055.14
11955 TRIANGLE RADIATOR SERVICE INC NEW RADIATOR FOR #2730 293.00
02791 VEHICLE MAINTENANCE PROGRAM INC. HEADLIGHT /TURN BULBS 24.10
02861 WEST SIDE TRACTOR SALES ELBOW FITTING FOR TRUCK #4516 12.94
02870 WHOLESALE DIRECT INC. TRAILER JACKS FOR #4555 169.31
11315 WOODFIELD CHEVROLET, INC BLEND DOOR ACTUATOR FOR P -5 184.49
TOTAL : 25554.51
670
01414 FLINK COMPANY 4 - TAILGATE SALT SPREADERS 11200.00
06403 LINDCO EQUIPMENT SALES, INC. REX ROTH ROD SENSING PISTON PU 2273.60
3- PRE -WET PLUMBING KIT. 407.89
3 -240 GAL PRE -WET TANK AND 3063.33
2-SS PRE -WET FRAMES. 3428.58
9173.40
10239 MARK'S MACHINE SHOP INC. 2 - DURACLASS "HH" 10FT DUMP 17223.50
02327 POMP'S TIRE SERVICE, INC. 11R22 -5 GOODYEAR (H) FRONT TIR 657.78
11R22 -5 GOODYEAR (H) REAR TIRE 1393.20
ACCURIDE HUB PILOT STEEL WHITE 600.00
MOUNT TIRES ON WHEELS W /NEW BR 111.00
STATE USER FEE 15.00
SHOP SUPPLIES 5.00
2781.98
02569 R.G. SMITH EQUIPMENT CO. 2 - FLINK PF91QLF 23" CENTERS 1122.00
4 -464P PLOW LIFT CYLINDERS - 860.00
1982.00
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY JUL132010 11:56 PAGE 18
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 01 2010 TO JULY 14 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
TOTAL : 42360.88
680
08146 DELL MARKETING L.P. DELL LATITUDE E6410 W/ i5 -520M 1326.11
TOTAL : 1326.11
690
01620 AMERICAN LANDSCAPING INC. REPAIRED SOD DAMAGED FROM CAR 217.00
10294 BESTPRACTICES OF NORTHWEST,SC JOSE MELENDEZ-DOI:6 /7/10 339.00
10051 CCMSI W/C REIMBURSEMENT 5/27/10 54448.21
W/C REIMBURSEMENT 6/11/10 104467.47
158915.68
01102 GAB ROBINS N.A., INC - CITIBANK PAYMENT OF INS CLAIMS 6/30/10 479.05
TOTAL : 159950.73
710
02637 BECKER, BURKE ASSOCIATES INC CONSULTING SERV 7/1/10- 9/30/10 8500.00
10472 BURKEMPER, LISA REIMB EXP 7/12/10 125.92
TOTAL : 8625.92
720
02637 BECKER, BURKE ASSOCIATES INC CONSULTING SERV 7/1/10- 9/30/10 8500.00
11860 WERDERITCH, RANDY 2ND QUARTER ADMIN.ASSISTANCE F 300.00
TOTAL : 8800.00
790
12301 IHC CONSTRUCTION COMPANIES,LLC ESCROW REFUND #2009 -M -004 500.00
12295 MURTAGH, MICHAEL D REPLACE CK #13019283 PT #08 -2799 125.00
01719 NCPERS GROUP LIFE INS. PREMIUM - JULY 2010 752.00
PREMIUM - JULY 2010 16.00
768.00
02689 THIRD DISTRICT CIRCUIT COURT BOND MONEY 7/1/10 775.00
BOND MONEY 7/6/10 1375.00
BOND MONEY 7/8/10 4195.00
BOND MONEY 7/13/10 2375.00
8720.00
TOTAL : 10113.00
GRAND TOTAL : 1118905.39
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY JUL132010 11:56 PAGE 19
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 01 2010 TO JULY 14 2010
SUMMARY BY FUND
001 GENERAL FUND 624625.87
030 REFUSE DISPOSAL FUND 251.78
050 MOTOR FUEL TAX FUND 1976.00
070 COMMUNITY DEVELPMNT BLOCK GRNT 10715.74
095 FOREIGN FIRE TAX BOARD FUND 9480.00
510 CAPITAL IMPROVEMENT FUND 48905.06
528 SERIES 2009 CONST FUND 77575.21
550 DOWNTOWN REDEVLPMNT CONST 9108.39
560 STREET IMPROVEMENT CONST FUND 6848.62
610 WATER AND SEWER FUND 70879.26
620 VILLAGE PARKING SYSTEM FUND 1596.61
630 PARKING SYSTEM REVENUE FUND 211.70
660 VEHICLE MAINTENANCE FUND 25554.51
670 VEHICLE REPLACEMENT FUND 42360.88
680 COMPUTER REPLACEMENT FUND 1326.11
690 RISK MANAGEMENT FUND 159950.73
710 POLICE PENSION FUND 8625.92
720 FIRE PENSION FUND 8800.00
790 ESCROW DEPOSIT FUND 10113.00
TOTAL : 1118905.39
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY JUL132010 11:56 PAGE 1
REPORT PARAMETERS
ORGANIZATION NO. : 001
STARTING CHECK DATE : 07/01/10
ENDING CHECK DATE : 07/14/10
STARTING BANK 1
ENDING BANK 1
SEGMENT NUMBER TO SORT BY : 01
STARTING ACCOUNT SEGMENT NUMBER: ALL
ENDING ACCOUNT SEGMENT NUMBER : ALL
RELEASE LEVEL .
EMR02+510 Village of Mount Prospect Page 1
List of Escrow Checks Presented to the Board of Trustees
07/14/10 To 07/14/10
Paid to Permit # Check # Amount
ALL CLEAR SEWER & DRAINAGE 091079 13023156 125.00
091175 13023157 125.00
250.00 *
AMERICAN THERMAL 101108 13023158 125.00
ARS OF ILLINOIS 100664 13023159 125.00
AUGUSTYNSKI, TOM 100484 13023160 150.00
CHE, YOONSOO 092560 13023161 150.00
CHICAGO BATH SYSTEMS 091022 13023162 125.00
COMFORT MASTERS HTG & COOLING LLC 092609 13023163 125.00
100356 13023164 125.00
250.00 *
DISTINCTIVE HOME RENOVATIONS INC 100191 13023165 375.00
EXSTINK INC 090975 13023166 125.00
091286 13023167 125.00
250.00 *
FASTSIGNS OF SCHAUMBURG 091130 13023168 125.00
FLUSH SEWER & DRAINAGE 101084 13023169 125.00
GAIDA, TIMOTHY C 100321 13023170 200.00
GAVRILA, NICOLAE 091441 13023171 25.00
GIANOPULOS, MARK 100104 13023172 75.00
HANSON, ELLEN 101088 13023173 125.00
HORNER CONCRETE CONSTRUCTION 091108 13023174 75.00
ITT EDUCATIONAL SERVICES,INC 100067 13023175 200.00
J C CONSTRUCTION INC 091126 13023176 200.00
JEDRAS, PAUL 090744 13023177 150.00
KJE INSTALLATION SERVICES 091074 13023178 125.00
KNAPCIK, KEITH 100377 13023179 125.00
MAEV, GEORGE 092558 13023180 125.00
MARTINSON GROUP 092461 13023181 350.00
MIKE NITTI NIT. CEMENT CONTR INC 090997 i 150.00
091184 13023183 200.00
350.00 *
PRECISION PLUMBING SERVICES INC 100001 13023184 450.00
SCIURBA, ANTHONY 100802 13023185 200.00
SMART GROUP, LTD 062153 13023186 5,925.00
SMITH, ROBERT 100545 13023187 200.00
WALLY BLANTON 091202 13023188 125.00
* ** TOTAL NUMBER OF CHECKS 33 11,075.00