HomeMy WebLinkAbout3. Bills 05/17/2011It Mount Prospc
Village of Mount Prospect
Mount Prospect, Illinois
INTEROFFICE MEMORANDUM
TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES
FINANCE COMMISSION
FROM: FINANCE DIRECTOR
DATE: MAY 13, 2011
SUBJECT: MONTHLY FINANCIAL REPORT — APRIL 2011
Attached hereto are the cash position and investment statements of the Village for the month ended
April 30, 2011. 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 detailed summary of cash and investments for the Village broken out by
governmental and enterprise funds and trust and agency funds. Governmental funds include the
General Fund, Special Revenue Funds, Debt Service Funds, Capital Project Funds and Internal
Service Funds. The Enterprise Funds consist of the Water and Sewer Fund and two (2) Parking
Funds.
Trust funds include the Village's two public safety pensions (Police and Firefighters') while the
agency funds include the Escrow Deposit, Flexcomp Escrow, Special Service Area and Library
Bonds Escrow Funds. The Escrow Deposit Fund accounts for refundable deposits held by the
Village to ensure completion of public improvements. The Flexcomp Escrow Fund accounts for
employee payroll deductions pursuant to a Section 125 flexible compensation plan. The Special
Service Area Fund and Library Bonds Escrow Fund account for the accumulation of monies for debt
service payments.
Governmental and Enterprise Funds - Cash and cash equivalents at March 31 were $25.1 million.
During April, cash receipts totaled $9,502,210.12. In addition investment income for the month was
$3,988.60. Reductions to cash and cash equivalents during April totaled $5,550,834.92. Of this
amount, payments to vendors were $4,312,157.90, employee payroll and related expenses were
$1,197,928.74 and other disbursements were $40,748.28. Cash and cash equivalents at April 30
were $29.1 million.
There were no funds held in investments during the month of April. Funds were held in cash money
market accounts that currently earn competitive rates of interest.
Monthly Financial Report — April 2011
May 13, 2011
Page 2
Total cash and investments for Governmental and Enterprise Funds at March 31 were
$25,123,717.87. Cash and investments at April 30 totaled $29,079,081.67. This is an increase of
$3,955,363.80 for the month.
Trust and Agency Funds - Cash and cash equivalents at March 31 were $6.0 million. During April,
cash receipts totaled $1,726,312.75. In addition investment income was a net loss of $54,435.30.
There was also a net decrease in cash due to investment activities of $114,870.32. Reductions to
cash and cash equivalents during April totaled $711,490.79. Of this amount, payments to vendors
were $172,333.32 employee payroll and related expenses were $495,037.75, and payments related
to the flexible spending program totaled $42,165.55. In addition, other adjustments related to 2010
totaled $1,954.17. Cash and cash equivalents at April 30 were $6.9 million.
Total investments at April 30 were $85,387,334.73, an increase of $796,072.16 from March 31.
There were investment income of $681,201.84 and a net transfer in totaling $114,870.32 that
accounted for the change.
Total cash and investments for Trust and Agency Funds at March 31 were $90,634,322.64. Cash
and investments at April 30 totaled $92,275,911.14. This is an increase of $1,641,588.50 from the
prior month.
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 further explanation on the activity of the General Fund, the Village's primary operating fund.
The report will also provide additional information on fund types that experienced higher than normal
activity for the month. Activity for the General Fund is highlighted below.
General Fund — Cash and cash equivalents at March 31 totaled $5,968,673.88. During April, cash
receipts totaled $5,175,674.11 and investment income was $2,305.08. Significant cash receipts
included sales taxes and vehicle sticker fees.
Sales tax revenues for the month totaled $878,555. Of this amount, $794,687 was generated
from the 1 % state portion while $83,868 was generated from the .25% home rule portion. Sales
taxes received in April are for January sales. There is a normal three -month lag in getting this
distribution from the state.
Vehicle stickers went on sale February 1 for the 2011 -2012 license period. Total receipts for
April were $527,763. The total budget for this line item is $1,405,000. We are at 76% of the
total budget.
Disbursements from the General Fund for April included payments to vendors of $1,246,988.30,
payments for employee wages and benefits of $944,963.29 and other adjustments related to 2010
of $40,764.42.
Monthly Financial Report —April 2011
May 13, 2011
Page 3
Cash and cash equivalents at April 30 were $8,913,937.06. There were no investments in the
General Fund at April 30.
Statement of Investments (page 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 April 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.
Maturity Purchase Financial
Date Date Institution
Investment CUSIP/
Description Acct #
Interest Market
Rate % Value
POLICE PENSION FUND (070)
Various Various Wells Fargo
Various Various Various
FIRE PENSION FUND (071)
Various Various Wells Fargo
Various Various Various
TOTAL TRUST AND AGENCY FUND INVESTMENTS
Various Various 21,592,157.17
Various Various 21,912,874.30
43,505,031.47
Wells Fargo Investments
Mutual Fund Investments
Various Various 21,851,552.25
Various Various 20,030,751.01
41,882,303.26
$ 85,387,334.73
Wells Fargo Investments
Mutual Fund Investments
Investment of the Village's pension funds is governed by an Investment Policy adopted by each
Pension Board. The policy was last amended in 2007 and is currently being under review.
Monthly Financial Report — April 2011
May 13, 2011
Page 4
Conclusion
As mentioned earlier, this cash position report is intended to provide a snapshot of the Village's
cash position as of a particular month end date. Over time, this report will be able to provide trend
information to help in cash management duties, maximizing investment earnings while ensuring
availability of funds to meet the Village's ongoing commitments.
David O. Erb
Finance Director
VILLAGE OF MOUNT PROSPECT
Preliminary Cash and Investment Position Report - All Funds
For the Month Ended April, 2011
GOVERNMENTAL AND ENTERPRISE FUNDS
Cash and Cash Total Cash and
Equivalents Investments Investments
Balance at March 31, 2011 $ 25,123,717.87 $ - $ 25,123,717.87
Cash receipts 9,502,210.12 9,502,210.12
Investment income 3,988.60 3,988.60
Transfers from investments to cash - - -
Transfers to investments from cash - -
Interfund activity - -
Disbursements:
Accounts payable (4,312,157.90) (4,312,157.90)
Payroll (1,197,928.74) (1,197,928.74)
Other (40,748.28) (40,748.28)
Balance at April 30, 2011 $ 29,079,081.67 $ - $ 29,079,081.67
TRUST AND AGENCY FUNDS
Cash and Cash
Eauivalents
Balance at March 31, 20 1 1 $ 6,043,060.07
Investments
Total Cash and
Investments
T
� 84,591,262.57 $ 90,634 ,322.64
Cash receipts 1,726,312.75 1,726,312.75
Investment income (loss) (54,435.30) 681,201.84 626,766.54
Transfers from investments to cash 1,600,545.40 (1 -
Transfers to investments from cash (1,715,415.72) 1,715,415.72 -
Interfund activity - -
Disbursements:
Accounts payable
Payroll
Flex spending
2010 Adjustments
Balance at April 30, 2011
(172,333.32)
(495,037.75)
(42,165.55)
(1,954.17)
(172,333.32)
(495,037.75)
(42,165.55)
(1,954.17)
$ 6,888,576.41 $ 85,387 $ 92,275,911.14
* Assets are restricted in purpose and do not represent discretionary assets of the government.
1
F
U
W
IL
N
O
a
F
z
D
O
LL
O
W
Q
J
V' f O O N
m aO t-- V r—
f-- " 0 0 6 N n 0 r
0
F a m
Z
W y d °
J C C u
Q a) w ( D — c
> Ea�i so0
O a`�i E m m 0
N E fn N a (6
U
N
S (6 2 V E C E I fA N N
U QI w C O O I E E E
U ur m a
°) E °? a? Q P 2 N
S C N m m 7 7 7
Q N .1-- > l6 l6 p m v1 n
0 mU -E I— N00C2
N
U
C
a
m
a
G
W
cli co
V 0 t` m
m iO 'I7 N
O (0 Cl ai
ci Cl) I— V
d V 0 m
0 M cl
co � Ln r
d0 N
EA
n
T
M
00
m
O N co t�
r- (C Cl c7
c � ^ m m
V 0) Cl) w
C6 v co ° m
N
V'
n
M
4]
n
0
U i
N
N
O
r
M
W
v
T
00
an
N
F
Z
W
F
N
N N W
C C >
a) Z
0 E o
OL / N w Z
N N N C Q
a >
Zo E to
W 0
a N
d @ > U
F U LL C J
cn W ? N F-
0 o
2
J
r V :
O �
Q
1N
0 R
I--
O
(000000
0 N u O
N N
V V
N Q'
m 0
F
r N `"' 0 1�
""
0 V
r �
V3
>
U
V'0)
r lO
LO
W
0 I— N
00 r
V' U7
M �
0
cq
ooc
Z
LL . 0 Z
f`O
V co
LL
= 0 LL
N C
C
r
z
U Q
u>
W
C7
Q
0 0 O O N
0
Q
Z W Z
-It
LO V
O V
F
Q U O
10n 7
J
r ch V O LO
4') l!]
Z
[r O z
1- Cl) ` 0
LL a a
v
Gs
W
I- N O
co
v o
(n
CO r 0
N
I- 01
f-
r 0 W
O LL fn
I-NO
V
r
C' i
0)r
(7W O
cli
J Z
C11 C)
cO
V
Or
co
H
r
r
w LL
0 O
.r_. V
O
z
N
f
Z
Q
6�1
0
r o 00
OD�
J Z
Q
O c7 V
i i
65 cO
D
z LL
n M N
0 cO LO
O 0
03 I—
Of W
V V
c LO
W U
0) r
CD
N
W
GO
Q
F
O
II N
W
(
0 V
U)
Cl) N N
0
UO 0)
LL c )
U)
� U)
� N
r
V
z
d O
Of z
C)
ch
co v
Q
LL
WD
N
r I
T
N
a
W
Z
v r
v N
W
Q c
E
63
L W
ca L
ca
U C
W
O CA
O)
O
O
F-
U
0 f—
O
W
Q F - (�
_
OO L7
N
N
L
`o
~ O W
FL Z
N O r
OD
Q
Q O D
fn
Q
�I
co
0
CO
c
N
O W
co
(7
crD
Nc00
0
LLI
�s
C) U)
m v
Co O0
i
0OD
J W
V
M(D
O 0
UZ0 r.r
coca
W W z
O0)
N O
N
0
�
cal
U WLL
Cr
EA
0 r 0
N
W O
z
CO r O
r
N M
D
c`i V L6
V
M aO
LL
J
ti r— O
0 0 OJ
0
r1
0 CO
m O
Q
W
I
0:
V
�-'
7 dr
0) r
Q) N
z
W 0
W
(D
e»
0
F a m
Z
W y d °
J C C u
Q a) w ( D — c
> Ea�i so0
O a`�i E m m 0
N E fn N a (6
U
N
S (6 2 V E C E I fA N N
U QI w C O O I E E E
U ur m a
°) E °? a? Q P 2 N
S C N m m 7 7 7
Q N .1-- > l6 l6 p m v1 n
0 mU -E I— N00C2
N
U
C
a
m
a
G
W
cli co
V 0 t` m
m iO 'I7 N
O (0 Cl ai
ci Cl) I— V
d V 0 m
0 M cl
co � Ln r
d0 N
EA
n
T
M
00
m
O N co t�
r- (C Cl c7
c � ^ m m
V 0) Cl) w
C6 v co ° m
N
V'
n
M
4]
n
0
U i
N
N
O
r
M
W
v
T
00
an
N
F
Z
W
F
N
N N W
C C >
a) Z
0 E o
OL / N w Z
N N N C Q
a >
Zo E to
W 0
a N
d @ > U
F U LL C J
cn W ? N F-
0 o
2
0
VILLAGE OF MOUNT PROSPECT
STATEMENT OF INVESTMENTS
As of April 30, 2011
GOVERNMENTAL AND ENTERPRISE FUNDS
Maturity Purchase Financial Investment CUSIP/ Interest Market Weighted
Date Date Institution Description Acct # Rate % Value Avg Yield
As of April 30, 2011, there were no certificates of deposit held by the Governmental and Enterprise Funds.
Maturity
Purchase
Financial
Date
Date
Institution
POLICE PENSION FUND (070)
Various
Various
Wells Fargo
Various
Various
Various
FIRE PENSION FUND (071)
Various Various Wells Fargo
Various Various Various
TRUST AND
AGENCY FUNDS
Investment
CUSIP/
Description
Acct #
Various
Wells Fargo Investments
Various
Mutual Fund Investments
Various
Wells Fargo Investments Various
Mutual Fund Investments Various
TOTAL TRUST AND AGENCY FUND INVESTMENTS
* Assets are restricted in purpose and do not represent discretionary assets of the government.
Interest
Market
Weighted
Rate %
Value
Avg Yield
Various
21,592,157.17
Various
21,912,874.30
43,505,031.47
Various
21,851,552.25
Various
20,030,751.01
41,882,303.26
$85,387,334.73
3
U
W
a
O
a
N
O
w
O
w
W
w
�
N
°
w
�
N
z
�
a
MID
w
� ur
� U
LL > N p c
U U IL
LL C (n E C U
47 f0 d E O 'C C E a) a3 C
N C
3 N I - cn O N LL C N LL
Z U a C O 0) °� E 9 N N
`m a) 2) (n E E a�
c o m o J m r c '� = O o
3 0 a O U> O H
0 v � ' LL ' U) LL W R I C
Q m a) a 0 °� LL U LL =� O O LL
L
1
Lq
(
V
.
�
rn
Lq
�
V
O
O
~
}
ao
co
(ri
U')
L �2
U)
�i
of
Ui
V
o
ri
O
V
N
�2
V
h
O
a)
Y
O
'V
O
Cl)
V
'cY
M
M
r
CA
m
N
u7
O
Cl)
64
69
M
6
O
U) V
d U
LE
O
�
�
u7
O
�
N
N
N
�
O
�-
C'4
M
N
e-
0
O N
C
N
N
C
W
h
O)
Cl)
W�
M
M
CO
N
O
h
N
V
N
O
N
U7
F O
} ._
In
O
00
U')
O
h
h
t-
V
V
co
-It
h
O
O
N
O
co
LO
N
O
U
O
r
O
O
O
(C)
v
O
h
oc
O a7 C
CO
M
O
h
V
h
M
LO
N
64
r-
h
V
N
M
"t�
"
N
CA
m N
EA
693
69
EfT
�
Q y
00
r
M
O
N
h
v
h
Cl?
V'
h
0
M
M
u)
M
O
M
V:
�' y
M
V
N
N
Lo
V'
U
T
h
-It
N
O
U
U7
M
O
C
h
M
(D
h
N
M
N
O
O
O
CO
O
N
O
64
N
C
h
N
V'
Lr
C-
64
�
69
69
�
M
C)
F'
to
H3
(hT
Q7
b9
64
m
V
N
O
O
O
o
o
O
O
O
O
O
o
O
O
O
O
O
O
O
O
O
O
o
H U
O
69
O
69
c)
O
O
V>
O
64
O
V3
O
W.
O
o
o
64
c)
O
O
64
E
/�/�
m
m o
t
N
W
V
C
a+ C
M
co
O)
h
u7
O
to
�
U7
m
00
O
N
V
0D
h
M
00
m
O
h
M
CD
M
-
N
h
CO
O
Q
N
LL
M
r
9+
w
O ++
c� U
N
M
h
O
Ln
M
M
M
M
O
M
O
co
V'
;:
V'
O
O
V
N
CU
O
M
w
M
o0
M
4
N
1C)
("�'
Cl)
d
\
V
(O
CD
m
M
�
6
E9
M
co
O
}
�
o
O
O
0
O
0
O
0
O
0
O
q
o
0
O
9
o
0
O
0
(p
U
'a
o
O
0
O
0
O
0
o
0
m
0
O
0
O
0
O
0
V
0
O
0
M
C
E
N
m
to
O
O
C
M
O
LQ
N
o0
O
V:
f6
E
"C
V
O
O
O
L
O
O
w
M
64
O
3
co
LO
a3
h
h
q)
([)
V'
O
64
Ef3
N
69
M
Efl
(fl
O
d
E
h
fH
N
69
��/
ci
Q
(�
N
d
o
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
E 6F1
O
o
H3
O
64
o
O
O
(»
o
(Al
O
64
O
64
O
69
O
69
O
O
m
o
co
o
co
L
E
U0,
(fl
m
Q
E o
CD
0
0
0
0
0
0
0
0
0
C)
0
0
0
0
0
0
0
0
0
0
0
m
-0
0
O
O
O
O
O
O
O
0
O
O
3
m
O
LQ
O
C
O
O
O
O
O
M
O
O
O
(f)
O
N
V'
M
O
O
M
w
O
O
�
U7
O
O)
00
M
(A
h
h
h
00
V
(O
EA
N
M
LQ
t2
p
.-
h
w
N
Lo
_
69
(H
69
C)
Q
� ur
� U
LL > N p c
U U IL
LL C (n E C U
47 f0 d E O 'C C E a) a3 C
N C
3 N I - cn O N LL C N LL
Z U a C O 0) °� E 9 N N
`m a) 2) (n E E a�
c o m o J m r c '� = O o
3 0 a O U> O H
0 v � ' LL ' U) LL W R I C
Q m a) a 0 °� LL U LL =� O O LL
L
1
2
7
m
U
E
Z O
04
c 0
O o
U L
a
m
N
m
ro
T
a�i
CL
o
a
x
~
m
0
O
m
7
C
m
N
E
E
O
m
c
N =
N 7
U LL
m
U
m
E v
° C ++
c m
c LL
E
E r (6
> H
O LL
}
w
�
O
M
m
r
O
O
N
r
N
m
O
(O
O
CC)
}
6
69
OO
a`
° u
w m
co
LO
w
o
(O
o
+
+
0
° o
° o
p c
F O
rn
�
o
o
o
�
v
} 'Z
co
r
to
_
o)
N
O
va
N
U
R
N N
o =
N
V
r
u7
O
M
(O
M
N
lO
N
Efl
O
O
M
r
va
(o
v>
va
V
m ~
i a
O
O
N
O)
O
O
N
OD
N
O va
�
Co
o
�
V
(O
Oc
N
M
V
=
I
Ql
N
(O
4kJ
H
W.
r m
o 0
° 0
0 0
0 0
0 0
0
V =
�
m
c
.
U
C
T
�
-D
W
r
a+
N
(.1
N
O)
r
M
O
O
O
U
C
C
c
N
O
O
O
M
N
d.
w
U
m
LO
7
(O
(O
0
C C
d)
_
t17
CO
N
O
a
°
64
(fl
O L
O
O
O
O
O
O
O
O
O
O
O
O
o 0
0 o
O
0 0
o va
C o
y
m
o
o
NIl
r
LL
—
3
"
d
n
M CO
�
V
to
O
d
_
6e
.,
L
C
CD
EH
vj
Ice
E
a
{�
y •5
O
O
O
O
O
O
�'
Ova
CD
C) o va
o va
o va
o va
O
3 E
m �
c
L
m
E
m
a
E
d
o
0 0
0
0 0
0
o O
°
0
0
0
0
0
00
O
m
0
O
v
0
O
U')
N
r
0
tO
va
(O
r
co
m
w
6 p
`�
c
6
v
Q
�
N
O
va
a
2
7
m
U
E
Z O
04
c 0
O o
U L
a
m
N
m
ro
T
a�i
CL
o
a
x
~
m
0
O
m
7
C
m
N
E
E
O
m
c
N =
N 7
U LL
m
U
m
E v
° C ++
c m
c LL
E
E r (6
> H
O LL
p m
o
m
0
0
o m
F Lr
o
0
0
0
o m
} 0
O
o
V!
M
o
O
E»
o
Vi
o m
69 O
M
V
m r
b
}
co
L
a`
P o 0 0 + o +
tU m O O + 0 t
N , V + O +
0
O CD N
CD O O O O
> - : m O 69 0 63 (O
U (O m O Vi W
R
d N
[o V) V) O)
C O V3 O
i
E9 V3
3 F
m
L O O O � O O O O m
V M O V
J� R (D O V
v, N ( o 69
64 V3
k J I-
m
V a000000
~ U O O O o O O O
�^^ } Vj VJ H} EA (n 69. 69
/ � / �1 E
m 3
N
to W
O
V N L C O O O 0 0 O O O
0
N aT+ 0 .0 M V} 63 Vj 63 69
LL
_ R
Q ) N M M
.. O Q
O w U
W r O o o O o 0 0
O �+ C 0 0 0 0 0 0 0
(0 U '6 O o o O o O O 0 69 CD
M E N In O O O d9 O O
E LL L
� / a E
a
0 0 0 0 0 0 0
y 0 0 0 0 0 0 0
0
m =
m
L E
m a
E
0 0 0 0 0 0 0
E
0 0 0 0 0 0 0
0 0 0 0 0 0 C.
3 0 0 0 69 O 69 0
m 0 0 0 0 0
C) LO LO
w O O fR Gq N
Ga
vJ G3 O
O
Q
C
d
LL a) u E
N d
CD M o
E a') E CL
>
° a� °'
L E m a 0 .c y
E C: c: a
W X C c N > C R
R j LL V
3 c6
Z U rn
C N N E N N L O p
o=3 O C> O H
O c: - c
Q ti °' 0 - 0 0 LL 3
3
p
CD
�
o
o r-
H
o
n
o
o r-
>-
o
Lo
o
o to
o
C
m
N
bc�
v) m
N
O
}
O
N
V
603
V
N
L
, U
b4
a`
w �
0 d
+
+
+
+
N Q
0
4
O� O
O
O
O
O
O
, U
w �
y N
� C
aR
3 �
Ln
N
O
O
O
O
O
C
O
O
O
O
O
,
��69
0
U
N
C
�Y
V
pN
°0000
Cl
t- (D
} R
°
O
0
O
0
O
0
O
O
9
O
U
�
c-
d
a
w
r
�
N
=
c
° o
0
° o
-O
c
C0
0
dS
o
0
0
0
0
0
N
LL
O
S
N
CL
7
V
d
°
0
0
0
0
0
0
0
0
0
O
v
C)
CD ° o
° �
0
°�
d
N
�
U)
t4
A 1
LL
m
1
cn
a
p
_0
L
a
C C
E
[
T �
N
y
O
O
O
O
O
O
O
O
O
O
O O
E
to
fA
6=1
� C
L
d
E
�
a
° o
° o
° o
Co
0
°
0
0
0
0
�
ss
61�1
69
tfr
f»
m
V1
a
m
CL
0
a
Q
�
c
c
p
7
LL
U
C
7
O
t
U
y
C
O
m
3
U
°
°
o
U
0
m
N
N
L
O
N
- i- - _f
O
E
U
m
U
C
o
m
s
E
C
>
`m
E
y
C
5
ii
CO
3
a)
o
�
o c
z
u)
O ,
E
a�
,—��
3
cv
0
m
>
=
O
O
o
H
Q
°'
O
LL
O
li ti
W O O 0 O n
>- to o o O o to
N O 64 V3 E9 M
co co l7
d N N
W O
i
O
a`
'a + + +
v + + +
0
N 0 0 0 0
N c 0 0 0 0
0 0
> n o 0
69 6 0 69. r-
U Cl) N cl
N LC5 N N
d N
c u) 64 to
L Q
a ca -
L 0 o M 0 0 0 0 0 0 0 0 rn
O 1' :✓ N 64 6 � 64 N
U I CO
l4
N O O
c �
/w� H 69
m
V D y 0 0 ° 0 0 0 0 0 0 0 0 0
U O o 0 o o O
^� 6q Q9�
a v
N c
� w
T
T
O
(�j N r c
C 0 0 O O O O CC!
O r p
N (D o 0 0 0 c0
N LL 4 + T + ' ) t� 69 69 64 Efl
t0
V C
Q 6
O w d U
.,
O �+ 0 0 0 0 O O O 0 0,
O O � � 6q O
CD
O to �A
E LL L6 cli
W 7 L C3 cfl
co
-
rQ a
ce a
x 0 0 0 0 0
y O o 0 0 0 0
�
E
d
L E
m a
d 0 0 0 0 0 ° o 0 0 ° O
"' 0 0 0 0 0 0
a o 0 69 U> 64 O
O 1x 'n
m Ln N n
d (D U<l O
Q N N
O
Q U
7
N
c
O
U
c
a)
E N
O U
a) 0 Y
O U
'o U) c i
N N p =
C N E C '
N U
p c = O
3 X o E c U
�, c 3
s� � � a�i > c
iT
0—
E 3 > c m
O O_ E N L_ H Q
= O m
C N N OL N .O L O O p
00 � > �0
LL a - O O LL a
E
p w
0
0
0
0
0
0 w
H X
0
0
0
0
0
0 r`
} m
o
o
Ci
o
v
o r-
v�
W
a»
o
Vy
O
u7
in
m ri
V
ri
CL
a + + + + +
m r + + ° + + +
N �
0
p N LO O O O O O O U')
C N O O O O O O N
} 0 t0 O O O O O O U
U ( fA fH O EA fA EA CD
U)
C3 N O 64 O
m N ER fA
(1) LO O O O O O O Lo
L O o r- 0 0 0 0 0 0 r`
O }' M � � � � 64 69 M
U N N
1�\ U N N
V ■ N co cfl
C
63 69
/0� ~
m
V 00000000
~ U O O O O O O O O
} Ull U). E9 69 6A EfT V> W9
E
m � U
C
t � lJJ
r
r+ N_ U N (O O O O O O O 0
U y C O O O O 0 0 O O
d C O
R
L N r r
d � V i �
O ate+ fa U
y
o a, ° o 0 0 0 0 ° 0 o 0
M V a o 0 0 0 0 0 0 0
d C y z 0 FR ER 0 (f� ff? ER O
�) C LL m
L a C
O
a a
N O O O O O O O O
m= 0 0 0 0 0 0 0 0
0 o Ci Ci CD o CD CD o
E <» <» ua Ea f» Gp� sv va
pp a
c
L E
m a
E
O O O O O O O O
o Ci o o Ci o o C,
CD Es e3 o us v3 Y) o
0 C C
m _ N
d M M
Q
O to tt?
a
a
c
LL
U
C
C C
U m c n
N
N
C U d
E 0 p O
N v Q
o m N m E
° a� o a m
Q X IL C C
N
3 F - > N j
Z fn C O -0 N mLL
L N N L U N d L Q Y O j
3 O c Q
O C
6 ¢ , 0��_ w O O� o
L - LL U
F
SG
§ /
\
\ \
\
§
/
\
2
/(
\
L
\
3®
\ 7 0 / ƒ
in
c@
SG
G
\
CD
\
§
\
/(
\
}
\
3®
14
\ \
\
\
}
/
0
( �
40
e
�
°
8
°
8
/§
¥§
\
Q
\
¢
E
Lu
\
o
2
R
£
=R
0
C,
\
R
/u
e
e
&
\ LL
§
k
g
=
g
C)
/
\
/
6
/
%
\
LO
6%
2
LL
G
2
_
\
\
s
®
2
\
a
E
«
\
°
E
C.
' r-
_
a
e
e
i
E
�
E
CD
CD
§
E
/
°
/
LQ
2
Lo
a
\
J
}
\
\
)
/
U
)
E
L
F
§
\
}
\
L
LL
0
E
§
ƒ
\
\
\
0
\
}
\
/
\
\ \
2
LL LL
0
F
0o
Cl) co
}
o
rn
�,
(
C7 C
m jLL
Z O
7 p
O
U C
¢ LL
C)
N
N
O
O
O
O
a`
0 0
w
O co
O
U
R
N
C
r
EA
h
EA
0
Q N
C
O
O
O O
O O
F O
1 i
0)
O W
U
� N
N
E9
Lo n
ER to
C1 f!1
� C
a �
7 H
/-�J
lY
LI]
a
c
a
i
LL
�,
E LL c
C7 C
m jLL
Z O
7 p
O
U C
¢ LL
C)
O
p
LL
w
C
LL
LL
LL
O LL
E N
E
N O
H
a
C
- ii
O
O
O
O
0 0
w
O co
O
U
R
N
C
r
EA
h
EA
w'
W
�
~
/-�J
lY
V
o'u
o00
~ U
O
O
O
Tt
`/
>" _
l4
3
ER
64
E
.
U
C
T
N
a
W
T
CV
s
C
O
O
O
C
O
V
CD
U>
O
O
.>
N
69
}
0
0
0
0
0
0
O
Cu
U
D
cts
w '
E
L
LL
m
o
�n
a
m
c
E
N
y
O
O
O
O
O
O
O
CD
O E
69
Ef)
69
�a
c
L
E
�
a
E
y
o
0
0
0
0
0
cm
O
o
0
0
�
0
0
0
VJ
Q
0
a
a
c
a
LL
�,
E LL c
C7 C
m jLL
Z O
7 p
O
U C
¢ LL
C)
O
p
LL
w
C
LL
LL
LL
O LL
E N
E
N O
H
a
C
- ii
13
Q o
v v
H
O
r ' -
r o
69
r2 ri
U
O
m
tu
d N
r
L
`o
L
a R
d U N V
N d O
[� C?
0
Q N
C
O
O
N N
O O
O
r ' -
Cl)
N
o Cl)
W O
U
O
V
tu
d N
O
L
O
a R
O F
m
IZ
O
CO
L
O
O
r
C'i
_
co
v 69
V
Q�
o00
U
O
O
O
r
fig
69
6p,
E
/�
' v
T
d
LL.,
�j
O
N
O
U
L C
O
C
C
O
Q .
0
C
4
> ,
w
O.
E R
W.
O
>
rn
0
L
�
W
}
4-
0
o
0
o
0
O
O
m
C.1
N
a
O
U
O
Lo
O
O
(0
m
—
69
O
w•
u.
Q
(�
°
0 0
0
O
rn�
3 E
0
E»
0
f»
0
s9
CO a
L
m
E
�
a
E
0 0
0 0
0 0
a
0
0 0
0
m
Ln
�
U') Ff3
o
M)
N
Q
O
a
Q
a
C
7
a
LL
c
7
N
a
U-
C
N
a
LL
c
a
�
11
m
a
N
N
E
�
v
co
0
N
W
LL
C
Q
3
Z
W
Q
,6
N
O
E
Ni
O
O
~
U
c
m
LL
a
a
Q
LL
LL
=
LL
ti
CR
F
C
} 0
tD
O
O O
Ci
LO
d M
r 69
M
69
0
ER fA
a`
c
to C
O U O
N d �
0
11
N
N
C
} 0
tD
O
O O
U
LO
LQ O
N M
� C
L
ER fA
� R
c
°
LY]
11
r-
CD
(0
L
c
°
> _
W.
LO
O
C
w'
W
�
m
V
o�
o00
~ U
O
WA
O
EH
O
fA
■V
O
U
�
r
d
-D
LLI
0
V
N
O
O
O
U
C
C
O
O
O
N
LL
>,
w
O �
S
64
�
Y)
�
S
•>
t O a
N
d
=
V
i L
.+
C
�
Q
3 F
`
G
iJ
o
0
0
O
N
V
M
E
N
m
oo
E
LL
fA
U3
�
- o
E
4
y r
o
0
0
0
0
0
O
�
CO c
L
m
E
m
a
E
o
o
O
0
o
0
rn
p
o
0
0
m
o
° o
u
i
(w
Efl
N
EA
CO
U9.
O
a
L=
a
LL
c
m
L
N
N
N
E
a)
U
O
E
L p
L
Q
Z
a
.6
N
E
E
N
C
Ch
"} N
N
C
N
N
p
C
O
U
C
LL
C
Q
LL Q f
LL
=
U-
11
p o + o
CU) O + CO
0
10
tt
O
C0 N
} of
o
v v
�
ao 0
a) u
r Cl)
o co
C-4 U
`o
a`
rn
p o + o
CU) O + CO
0
10
O
w
O
C)
w
T3
v
N
rn
r
r
N
C
i j
(h
Cl)
E9
m
Cl)
3 �
m
N
N
O
O
N
L
0
0
0�
o 9
Lq
O
Y
V
v
N
o
N
v
V
R
N
ti
Cl
N
w
m
LO
V/
@
�V
V
om
o000
E
N
M
L)
O
C
10
o
o
r
N
w
v
ao
ao
p
L
R
C C
co
Ce)
a
•+
69
fR
�
L
L
W
0
0
0
0
0
0
0
0
E
N
�
Q
O
O
N
m
N
LO
CD
LO
'
• L
a
i
m
fA
a
N
a
N
0)
O
O
O
O
o E
CD
0
CD
`
Ma
0
L
E
E
CD
O
O
O
O
m
a
of
o
0
of
3
m
N
E»
o
O
N
U')
O
In
EA
Q
O
a
c
R
Y
O
C
CD
N
E
c
N
C
CL
O
E
CL
N
N
d
N
d'
Q
N
d
E
0
?+
E
c
E
E
E
a�i
U
3
Z
E
U
>
0
a�i
y
C
N
O
O
= C
C
O
~ Y
U
a
LL
U-
p co
w
o v
F M
M
M O
} 1-
LO
O M
(D
c0
m
V
I�r O
O N
G) tC)
6 ' 3
M ui
>- LO
N 00
y Cl)
69
64 M
U3
O
N
C N
a`
a
) o 0 0
O U U') O Q)
N d N
0
C
7
N LL
a C X
C C to
LL 1
X iL
co x
m N LL
L N U O O
m LL E c a) o
E c n
Z 6 E 6
2) E E
Q
O c > f-
O c
Q N — ry U.
9
0 O
O
O
It �
> 0
r
O
O
r co
M M
U
U
C
N
C N
a
y y
LO
;;
"r
o
C
c»
. ca
L
�.
�
m
fl7
64
N
I-
O
00
n
L
a o
01
0
� v
O
}
CO
N
O
U
U
O V
N
(D
�
C
�
Cl)
EA
fA
m
V
oa)
0000
~ U
>'
O
E!)
O
64
O O
6 fH
E
�V
O
U
O
d
r
Q
U
=
N
C
c
'It
CD
V)
m
—
c o
�n
M
O
Ci
CO
CD
�
04
U)
+_�'
U
CO oO
fn N_
dpi
L
L
W
O
O
O O
U
'p
O
O
O O
C f C 0
C
N
m
LQ
N CD
CD CD
O f-
LL
W
a
E
a
_
o o
° o
Co o
O
m
0
0
0 0
3 E
e»
ej
e3 e»
� c
L
E
a
y
o
0
0
0
0 0
0 0
�
a
o
o
C) o
m
0
0
CD
N
0 0
O r
(w
M
ER
u7 of
y,
V
H3 �t
Q.
O
fR
Q
C
7
N LL
a C X
C C to
LL 1
X iL
co x
m N LL
L N U O O
m LL E c a) o
E c n
Z 6 E 6
2) E E
Q
O c > f-
O c
Q N — ry U.
9
LL
a
LL p
cc a
(D
_ ur
o Cl
Z a�
A2 CO O E O W
0 X U 3
N LL O > w
Z d' N CD
Q (n N
o
c ° aD s c o
c o a` C> LL > O F
G > c
Q =� d U LL LL
= 0 LL
c
rn
�
c
° v
H
u�
(D
O
n
00
M
CD
d
1
r
M
r
M
r
N
Lo
O
co
L
6
W
U9,
(D
M
EA
U)
(D
L
a
U U
d
(D
Cl)
M
N
O
O
N
U)
0
O N
c
(D
V
(D
(D
Uf
O
O
O
OD
a+
O
r�
N
O
W
M
U
M
(Ci
N_
M
N
d N
N
M
co
N
f--
C
O
n
M
U3
N
UT
M
no F
_-
E»
N
Ua
L
Q
O
M
r
�
V
o
O
o
Cl!
d'
0
(D
(h
0
U
(0
N
C`7
(T
N
R
N
(o
r-
co
co
n
Ui
—
(h
O
�
(D
U'
(D
kJ
H
U)
m
V U)
O
O
O
O
O
O
O
O
O
O
H U
O
O
63
U>
fA
w
E
/�/�
m
d
O
O
N
b,
U
d
«)
M
V
N
(D
p
v
m
ri
v
Cy)
a
`
U3.
6R,
�
w+
C
0
O
a
L
`
W
U
O w'
W
w
}
m
CD
0
CD
0
o
0
0
0
0
0
0
0
S6
U
N
-p
O
p
N
�
O
�
O
N
O
I
N
CD
m
E
LL
co
7
co
O
I-
�
U)
U>
O
r
^ W '
a
E
a
y..
In
y +-'
O
O
O
O
O
O
O
O
O
O
O
O
c
°°°�°
�E
L
E
m
a
E O
O
O
O
O
O
O
O
O
O
O
O
O
C)
00
o
o
�
co
m
O
1�
(D
N
'It
Cfl
w
7 0
In
OD
Cl)
M
Cn
M
U3
(D
W
v,
Q1
I-
m
U)
co
O
a
W,
v
Q
u,
U3
a
LL
a
LL p
cc a
(D
_ ur
o Cl
Z a�
A2 CO O E O W
0 X U 3
N LL O > w
Z d' N CD
Q (n N
o
c ° aD s c o
c o a` C> LL > O F
G > c
Q =� d U LL LL
= 0 LL
o CO
0 0
0 0
0
�
o Iq
r of
o
6v
m
M
o
F»
0
n
o ui
vj o
m
v
o
m
m co
n
v
4
a`
P o + o + o +
o U W + Cl) + O +
N O O
0
D O co O O O W O
tD O (D O V O M
1' ._ 64 M 64 M HT M
U O U7 Cl) In
LSS C m
64
m
N O O O O
L O (D O O O O W
O >- ,_ V O �_ O V' O N
U co n lr
co
N Cl) cli 64 ( D (A
= 69 64 64
4 ~
m
V D 4 o 0 0 0 0 0 0 0 0 0 0 0
F U O o O o o O O
64 (A 61) 69 69 64
m L)
O U
(D O
r � lJ.l
(�j L c ( O O O O O C
Q) — c O
(Q LL '0 co M ff-J T 69 EA 69 W
•� a+ N M M
W r 0 0 0 0 0 0 0
O o 0 0 0 0 0
N m o C 0 0
(V LO LO co co
U) i 69 69
Q
LL
a
N O O O O O O O
�j O O O O O O O
O O EA U� 69 69 64 64 64
m C
N
L E
m a
E
0 0 0 0 0 0 0
0 0 0 0 0 0 0
p o o 0 o 0 o m
0 64 0 (fl n 69 n
m o o O o
m o r (D
o v &a 69 (
a 69 (»
0
-a
a
a
U-
0
U
O co
U
cn O M O
L) U) =
o Z a) N - o
O N O N c a L
m U o aa) c o 3
E o m � iL LL LL
O O ~ O a) .n N N O
Z L� o E L m
a� 0 E
C N Q) L 2 L N - N O p L
co LL a
a LL O U— 0 0
L
VILLAGE OF MOUNT PROSPECT
BUDGET REVENUE
EXPENDITURE SUMMARIES
January 1— April 30, 2011
Village of Mount Prospect
Summary of Revenue by Fund and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Account Number
Adopted Budget
Amendments
Amended Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund: 001 General Fund
Revenue
PT - Property Taxes
$11,514,500.00
$0.00
$11,514,500.00
$3,663,628.88
$0.00
$5,797,534.78
$5,716,965.22
50%
$5,910,021.52
OT - Other Taxes
$7,703,000.00
$0.00
$7,703,000.00
$628,978.79
$0.00
$1,204,841.16
$6,498,158.84
16%
$1,245,948.66
LPF - Licenses, Permits & Fees
$2,704,000.00
$0.00
$2,704,000.00
$633,654.05
$0.00
$1,497,929.29
$1,206,070.71
55%
$1,506,436.44
IR - Intergovernmental Revenue
$15,879,000.00
$30,000.00
$15,909,000.00
$1,318,633.45
$0.00
$1,536,022.81
$14,372,977.19
10%
$1,032,276.14
CS - Charges For Services
$1,455,390.00
$0.00
$1,455,390.00
$86,061.95
$0.00
$310,745.47
$1,144,644.53
21%
$348,155.72
FF - Fines & Forfeits
$601,000.00
$0.00
$601,000.00
$44,934.88
$0.00
$127,456.37
$473,543.63
21%
$143,155.97
II - Investment Income
$97,500.00
$0.00
$97,500.00
$2,432.21
$0.00
$11,392.74
$86,107.26
12%
$13,412.57
RE - Reimbursements
$282,200.00
$0.00
$282,200.00
$411.84
$0.00
$27,679.30
$254,520.70
10%
$80,759.52
OR - Other Revenue
$331,840.00
$0.00
$331,840.00
$15,007.67
$0.00
$106,778.58
$225,061.42
32%
$111,446.49
OFS - Other Financing Sources
$2,000.00
$0.00
$2,000.00
$246.98
$0.00
$246.98
$1,753.02
12%
$0.00
Fund Totals: General Fund
$40,570,430.00
$30,000.00
$40,600,430.00
$6,393,990.70
$0.00
$10,620,627.48
$29,979,802.52
$10,391,613.03
N
Account Number
Fund: 002 Debt Service Fund
Revenue
PT - Property Taxes
OT - Other Taxes
IR - Intergovernmental Revenue
II - Investment Income
OFS - Other Financing Sources
Fund Totals: Debt Service Fund
Village of Mount Prospect
Summary of Revenue
by Fund
and Category
Summary - through
4130/2011
Prior Fiscal Year
Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Adopted Budget
Amendments
Amended Budget
Transactions Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
$1,754,000.00
$0.00
$1,754,000.00
$619,532.19
$0.00
$979,721.02
$774,278.98
56%
$810,309.19
$682,000.00
$0.00
$682,000.00
$51,483.27
$0.00
$51,483.27
$630,516.73
8%
$66,886.48
$47,258.00
$0.00
$47,258.00
$23,628.93
$0.00
$23,628.93
$23,629.07
50%
$20,872.23
$2,500.00
$0.00
$2,500.00
$0.00
$0.00
$0.00
$2,500.00
0%
$204.57
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$2,485,758.00
$0.00
$2,485,758.00
$694,644.39
$0.00
$1,054,833.22
$1,430,924.78
$898,272.47
'Village of Mount Prospect
Summary of Revenue by Fund and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
w
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Account Number
Adopted Budget
Amendments
Amended Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund: 020 Capital Improvement Fund
Revenue
OT - Other Taxes
$1,011,000.00
$0.00
$1,011,000.00
$76,319.04
$0.00
$76,319.04
$934,680.96
8%
$67,196.79
IR - Intergovernmental Revenue
$100,000.00
$0.00
$100,000.00
$0.00
$0.00
$40,185.79
$59,814.21
40%
$0.00
II - Investment Income
$5
$0.00
$5,000.00
$0.00
$0.00
$0.00
$5,000.00
0%
$303.09
RE - Reimbursements
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
OR - Other Revenue
$5,000.00
$0.00
$5,000.00
$0.00
$0.00
$4,933.00
$67.00
99%
$0.00
OFS - Other Financing Sources
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
Fund Totals: Capital Improvement
$1,121,000.00
$0.00
$1,121,000.00
$76,319.04
$0.00
$121,437.83
$999,562.17
$67,499.88
Fund
w
Village of Mount Prospect
Summary of
Revenue by Fund
and Category
Summary - through 4/30/2011
Priior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Account Number
Adopted Budget
Amendments
Amended Budget Transactions Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund: 021 Series 2009 Construction Fund
Revenue
IR - Intergovernmental Revenue
$0.00
$0.00
$0.00 $0.00
$0.00
$0.00
$0.00
+ ++
$20,000.00
II - Investment Income
$0.00
$0.00
$0.00 $0.00
$0.00
$0.00
$0.00
+ ++
$4,295.77
OR - Other Revenue
$0.00
$0.00
$0.00 $0.00
$0.00
$0.00
$0.00
+ ++
$0.00
OFS - Other Financing Sources
$0.00
$0.00
$0.00 $0.00
$0.00
$0.00
$0.00
+ ++
$0.00
Fund Totals: Series 2009 Construction
$0.00
$0.00
$0.00 $0.00
$0.00
$0.00
$0.00
$24,295.77
Fund
Village of Mount Prospect
Summary of Revenue by Fund and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget Current Month YTD YTD
Account Number Adopted Budget Amendments Amended Budget Transactions Encumbrances Transactions
Fund: 022 Downtown Redevelopment Construct
$2,665,000.00
Revenue
$0.00
PT - Property Taxes
$2,665,000.00
II - Investment Income
$2,500.00
RE - Reimbursements
$0.00
OR - Other Revenue
$0.00
OFS - Other Financing Sources
$0.00
Fund Totals: Downtown
$2,667,500.00
Redevelopment Construct
$0.00
Budget - YTD % Used/
Transactions Rec'd Prior Year YTD
$0.00
$2,665,000.00
$662,506.86
$0.00
$1,109,622.99
$1,555,377.01
42%
$1,182,325.84
$0.00
$2,500.00
$0.00
$0.00
$0.00
$2,500.00
0%
$609.91
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$0.00
$2,667,500.00
$662,506.86
$0.00
$1,109,622.99
$1,557,877.01
$1,182,935.75
u,
0
Village of Mount Prospect
Summary of Revenue by Fund and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Account Number Adopted
Budget
Amendments
Amended Budget
Transactions
Encumbrances
Transactions
Transactions
Recd
Prior Year YTD
Fund: 023 Street Improvement Construc Fund
Revenue
OT - Other Taxes
$1,371,000.00
$0.00
$1,371,000.00
$111,048.06
$0.00
$162,234.75
$1,208,765.25
12%
$143,013.78
LPF - Licenses, Permits & Fees
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
IR - Intergovernmental Revenue
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
II - Investment Income
$1,000.00
$0.00
$1,000.00
$0.00
$0.00
$0.00
$1,000.00
0%
$0.00
RE - Reimbursements
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
OR - Other Revenue
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$504.00
OFS - Other Financing Sources
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
Fund Totals: Street Improvement
$1,372,000.00
$0.00
$1,372,000.00
$111,048.06
$0.00
$162,234.75
$1,209,765.25
$143,517.78
Construc Fund
Village of Mount Prospect
Summary of Revenue by Fund and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget Current Month YTD YTD
Account Number Adopted Budget Amendments Amended Budget Transactions Encumbrances Transactions
Fund: 024 Flood Control Construction Fund
Revenue
OT - Other Taxes
$429,000.00
IR - Intergovernmental Revenue
$0.00
CS - Charges For Services
$50,000.00
II - Investment Income
$0.00
RE - Reimbursements
$57,079.00
OFS - Other Financing Sources
$0.00
Fund Totals: Flood Control
$536,079.00
Construction Fund
$0.00
Budget - YTD % Used/
Transactions Rec'd Prior Year YTD
$0.00
$429,000.00
$32,384.64
$0.00
$32,384.64
$396,615.36
8%
$6,173.89
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$0.00
$50,000.00
$457.00
$0.00
$1,414.00
$48,586.00
3%
$1,433.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$0.00
$57,079.00
$0.00
$0.00
$56,744.17
$334.83
99%
$57,078.75
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$0.00
$536,079.00
$32,841.64
$0.00
$90,542.81
$445,536.19
$64,685.64
ON
Account Number
Fund: 040 Refuse Disposal Fund
Revenue
PT - Property Taxes
CS - Charges For Services
FF - Fines & Forfeits
II - Investment Income
OR - Other Revenue
Fund Totals: Refuse Disposal Fund
'Village of Mount Prospect
Summary
of Revenue
by Fund
and Category
Summary - through
4/30/2011
Prior Fiscal Year
Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Adopted Budget Amendments
Amended Budget
Transactions Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
$1,751,000.00
$0.00
$1,751,000.00
$618,581.53
$0.00
$978,697.39
$772,302.61
56%
$937,517.84
$1,938,782.00
$0.00
$1,938,782.00
$213,359.19
$0.00
$635,209.46
$1,303,572.54
33%
$637,663.51
$35,500.00
$0.00
$35,500.00
$1,427.47
$0.00
$7,370.44
$28,129.56
21%
$11,262.92
$1,200.00
$0.00
$1,200.00
$0.00
$0.00
$0.00
$1,200.00
0%
$312.33
$364,150.00
$0.00
$364,150.00
$46,282.90
$0.00
$71,966.20
$292,183.80
20%
$52,879.80
$4,090,632.00
$0.00
$4,090,632.00
$879,651.09
$0.00
$1,693,243.49
$2,397,388.51
$1,639,636.40
Account Number
Fund: 041 Motor Fuel Tax Fund
Revenue
iR - Intergovernmental Revenue
II - Investment Income
RE - Reimbursements
Fund Totals: Motor Fuel Tax Fund
r
Village of Mount Prospect
Summary
of
Revenue by Fund
and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Adopted Budget Amendments
Amended Budget Transactions Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
$1,432,500.00
$0.00
$1,432,500.00 $119,880.14
$0.00
$356,528.97
$1,075,971.03
25%
$355,867.36
$1,200.00
$0.00
$1,200.00 $0.00
$0.00
$0.00
$1,200.00
0%
$455.38
$52,000.00
$0.00
$52,000.00 $4,932.51
$0.00
$4,932.51
$47,067.49
9%
$28,940.30
$1,485,700.00
$0.00
$1,485,700.00 $124,812.65
$0.00
$361,461.48
$1,124,238.52
$385,263.04
r
F.
0
'Village of Mount Prospect
Summary
of Revenue by Fund
and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Account Number
Adopted Budget Amendments
Amended Budget Transactions Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund: 042 Cmmty Development Block Grant
Revenue
IR - Intergovernmental Revenue
$395,219.00
$0.00
$395,219.00 $30
$0.00
$37,243.02
$357,975.98
9%
$35,169.47
II - Investment Income
$0.00
$0.00
$0.00 $0.00
$0.00
$0.00
$0.00
+ ++
$0.00
OR - Other Revenue
$60,000.00
$0.00
$60,000.00 $0.00
$0.00
$22,206.50
$37,793.50
37%
$20,874.80
Fund Totals: Cmmty Development
$455,219.00
$0.00
$455,219.00 $30,858.13
$0.00
$59,449.52
$395,769.48
$56,044.27
Block Grant
Account Number
Fund: 043 Asset Seizure Fund
Revenue
FF - Fines & Forfeits
II - Investment Income
Fund Totals: Asset Seizure Fund
'Village of Mount Prospect
Summary of Revenue by Fund
and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget Current Month
YTD YTD
Budget - YTD
% Used/
Adopted Budget Amendments Amended Budget Transactions Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
$1,000.00 $0.00 $1,000.00 $0.00
$0.00 $453.76
$546.24
45%
$3,595.73
$2,500.00 $0.00 $2,500.00 $0.00
$0.00 $0.00
$2,500.00
0%
$16.11
$3,500.00 $0.00 $3,500.00 $0.00
$0.00 $453.76
$3,046.24
$3,611.84
N
Account Number
Fund: 044 DEA Shared Funds Fund
Revenue
FF - Fines & Forfeits
II - investment Income
Fund Totals: DEA Shared Funds Fund
Village of Mount Prospect
Summary
of Revenue by Fund
and Category
Summary - through 4/3012011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD YTD
Budget - YTD
% Used/
Adopted Budget Amendments
Amended Budget Transactions Encumbrances Transactions
Transactions
Rec'd
Prior Year YTD
$1,500.00
$0.00
$1,500.00 $0.00
$0.00 ($5,423.00)
$6,923.00
-362%
$0.00
$500.00
$0.00
$500.00 $4.65
$0.00 $19.08
$480.92
4%
$13.41
$2,000.00
$0.00
$2,000.00 $4.65
$0.00 ($5,403.92)
$7,403.92
$13.41
Account Number
Fund: 045 DUI Fine Fund
Revenue
FF - Fines & Forfeits
II - Investment Income
Fund Totals: DUI Fine Fund
r
w
Village of Mount Prospect
Summary of
Revenue by Fund and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget
Current Month YTD YTD
Budget - YTD % Used/
Adopted Budget Amendments
Amended Budget Transactions Encumbrances Transactions
Transactions Rec'd
Prior Year YTD
$1,000.00 $0.00
$1,000.00 $706.00 $0.00 $706.00
$294.00 71%
$2,790.00
$500.00 $0.00
$500.00 $0.00 $0.00 $0.00
$500.00 0%
$1.63
$1,500.00 $0.00
$1,500.00 $706.00 $0.00 $706.00
$794.00
$2,791.63
r
w
Account Number
Fund: 046 Foreign Fire Tax Board Fund
Revenue
OT - Other Taxes
II - Investment Income
OFS - Other Financing Sources
Fund Totals: Foreign Fire Tax Board
Fund
Village of Mount Prospect
Summary of Revenue by Fund
and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Adopted Budget
Amendments
Amended Budget Transactions Encumbrances
Transactions
Transactions
Recd
Prior Year YTD
$44,000.00
$0.00
$44,000.00 $0.00
$0.00
$0.00
$44,000.00
0%
$0.00
$500.00
$0.00
$500.00 $0.00
$0.00
$0.00
$500.00
0%
$0.00
$0.00
$0.00
$0.00 $0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$44,500.00
$0.00
$44,500.00 $0.00
$0.00
$0.00
$44,500.00
$0.00
Account Number
Fund: 050 Water and Sewer Fund
Revenue
PT - Property Taxes
LPF - Licenses, Permits & Fees
CS - Charges For Services
FF - Fines & Forfeits
II - Investment Income
RE - Reimbursements
OR - Other Revenue
OFS - Other Financing Sources
Fund Totals: Water and Sewer Fund
Ln
Village of Mount Prospect
Summary
of Revenue
by Fund
and Category
Summary - through
4/30/2011
Prior Fiscal Year
Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Adopted Budget Amendments
Amended Budget
Transactions Encumbrances
Transactions
Transactions
Recd
Prior Year YTD
$1,516,000.00
$0.00
$1,516,000.00
$506,861.42
$0.00
$782,442.41
$733,557.59
52%
$817,687.63
$17,000.00
$0.00
$17,000.00
$1,070.00
$0.00
$4,920.00
$12,080.00
29%
$5,960.00
$9,177,000.00
$0.00
$9,177,000.00
$731,173.07
$0.00
$2,807,814.84
$6,369,185.16
31%
$2,728,949.00
$120,000.00
$0.00
$120,000.00
$8,478.05
$0.00
$40,932.95
$79,067.05
34%
$38,306.45
$7,000.00
$0.00
$7,000.00
$2.40
$0.00
$9.75
$6,990.25
0%
$74.21
$1,000.00
$0.00
$1,000.00
$0.00
$0.00
$0.00
$1,000.00
0%
$9,450.00
$20,000.00
$0.00
$20,000.00
$413.24
$0.00
$28,441.71
($8,441.71)
142%
$8,544.83
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$10,858,000.00
$0.00
$10,858,000.00
$1,247,998.18
$0.00
$3,664,561.66
$7,193,438.34
$3,608,972.12
Ln
rn
Account Number
Fund: 051 Village Parking System Fund
Revenue
OT - Other Taxes
CS - Charges For Services
II - Investment Income
OR - Other Revenue
OFS - Other Financing Sources
Fund Totals: Village Parking System
Fund
Village of Mount Prospect
Summary of Revenue
by Fund
and Category
Summary - through
4/30/2011
Prior Fiscal Year
Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Adopted Budget
Amendments
Amended Budget
Transactions Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
$45,000.00
$0.00
$45,000.00
$3,396.99
$0.00
$3,396.99
$41,603.01
8%
$2,638.62
$102,000.00
$0.00
$102,000.00
$8,316.21
$0.00
$37,341.11
$64,658.89
37%
$32,407.01
$500.00
$0.00
$500.00
$0.00
$0.00
$0.00
$500.00
0%
$6.29
$3,300.00
$0.00
$3,300.00
$0.00
$0.00
$1,650.00
$1,650.00
50%
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$150,800.00
$0.00
$150,800.00
$11,713.20
$0.00
$42,388.10
$108,411.90
$35,051.92
Village of Mount Prospect
Summary of Revenue by Fund and Category
Summary - through 4/3012011
Prior Fiscal Year Activity Included
Budget Current Month YTD YTD
Account Number Adopted Budget Amendments Amended Budget Transactions Encumbrances Transactions
Fund: 052 Parking System Revenue Fund
Revenue
OT - Other Taxes
$55,000.00
IR - Intergovernmental Revenue
$0.00
CS - Charges For Services
$111,000.00
II - Investment Income
$500.00
OR - Other Revenue
$0.00
OFS - Other Financing Sources
$0.00
Fund Totals: Parking System Revenue
$166,500.00
Fund
Budget - YTD % Used/
Transactions Recd Prior Year YTD
$0.00
$55,000.00
$4,151.88
$0.00
$4,151.88
$50,848.12
8%
$3,224.99
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$0.00
$111,000.00
$8,602.86
$0.00
$34,482.26
$76,517.74
31%
$35,872.81
$0.00
$500.00
$0.00
$0.00
$0.00
$500.00
0%
$1.63
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$0.00
$166,500.00
$12,754.74
$0.00
$38,634.14
$127,865.86
$39,099.43
r-�
I
Account Number
Fund: 060 Vehicle Maintenance Fund
Revenue
CS - Charges For Services
II - Investment Income
OR - Other Revenue
Fund Totals Vehicle Maintenance
Fund
Village of Mount Prospect
Summary of Revenue by Fund
and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Adopted Budget
Amendments
Amended Budget Transactions Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
$1,902,802.00
$0.00
$1,902,802.00 $158,566.84
$0.00
$634,267.36
$1,268,534.64
33%
$549,147.28
$1,000.00
$0.00
$1,000.00 $31.79
$0.00
$129.15
$870.85
13%
$313.04
$0.00
$0.00
$0.00 $0.00
$0.00
$158.75
($158.75)
+ ++
$125.00
$1,903,802.00
$0.00
$1,903,802.00 $158,598.63
$0.00
$634,555.26
$1,269,246.74
$549,585.32
ON
Village of Mount Prospect
Summary
of Revenue by Fund
and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Account Number
Adopted Budget Amendments
Amended Budget Transactions Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund: 061 Vehicle Replacement Fund
Revenue
CS - Charges For Services
$697,600.00
$0.00
$697,600.00 $58,133.34
$0.00
$232,533.36
$465,066.64
33%
$25,233.32
FF - Fines & Forfeits
$26,000.00
$0.00
$26,000.00 $3,644.15
$0.00
$3,644.15
$22,355.85
14%
$5,552.00
II - Investment Income
$10,000.00
$0.00
$10,000.00 $317.88
$0.00
$1,290.86
$8,709.14
13%
$2,445.22
OR - Other Revenue
$0.00
$0.00
$0.00 $0.00
$0.00
$0.00
$0.00
+ ++
$0.00
OFS - Other Financing Sources
$50,000.00
$0.00
$50,000.00 $3,720.00
$0.00
$16,670.00
$33,330.00
33%
$0.00
Fund Totals: Vehicle Replacement
$783,600.00
$0.00
$783,600.00 $65,815.37
$0.00
$254,138.37
$529,461.63
$33,230.54
Fund
ON
N
O
Village of Mount Prospect
Summary of Revenue by Fund
and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget Current Month
YTD YTD
Budget - YTD
% Used/
Account Number
Adopted Budget Amendments Amended Budget Transactions Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund: 062 Computer Replacement Fund
Revenue
CS - Charges For Services
$231,921.00 $0.00 $231,921.00 $19,326.75
$0.00 $77,307.00
$154,614.00
33%
$0.00
II - Investment Income
$5,000.00 $0.00 $5,000.00 $47.68
$0.00 $193.69
$4,806.31
4%
$479.43
Fund Totals: Computer Replacement
$236,921.00 $0.00 $236,921.00 $19,374.43
$0.00 $77,500.69
$159,420.31
$479.43
Fund
Account Number
Fund: 063 Risk Management Fund
Revenue
CS - Charges For Services
II - Investment Income
RE - Reimbursements
OR - Other Revenue
Fund Totals: Risk Management Fund
N
Village of Mount Prospect
Summary
of Revenue by Fund
and Category
Summary - through 4130/2011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Adopted Budget Amendments
Amended Budget Transactions Encumbrances
Transactions
Transactions
Recd
Prior Year YTD
$5,206,224.00
$0.00
$5,206,224.00 $435,645.72
$0.00
$1,798,585.14
$3,407,638.86
35%
$1,879,572.58
$5,000.00
$0.00
$5,000.00 $127.13
$0.00
$516.26
$4,483.74
10%
$1,044.49
$11,000.00
$0.00
$11,000.00 $539.10
$0.00
$539.10
$10,460.90
5%
$4,034.01
$1,321,500.00
$0.00
$1,321,500.00 $77,773.23
$0.00
$353,751.67
$967,748.33
27%
$361,540.50
$6,543,724.00
$0.00
$6,543,724.00 $514,085.18
$0.00
$2,153,392.17
$4,390,331.83
$2,246,191.58
N
N
N
Account Number
Fund: 070 Police Pension Fund
Revenue
CS - Charges For Services
II - Investment Income
OR - Other Revenue
Fund Totals: Police Pension Fund
Village of Mount Prospect
Summary
of Revenue by Fund
and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Adopted Budget Amendments
Amended Budget Transactions Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
$0.00
$0.00
$0.00 $0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$2,637,000.00
$0.00
$2,637,000.00 $465,100.73
$0.00
$1,497,025.15
$1,139,974.85
57%
$1,367,540.82
$3,115,500.00
$0.00
$3,115,500.00 $712,633.61
$0.00
$1,281,692.02
$1,833,807.98
41%
$1,062,302.25
$5,752,500.00
$0.00
$5,752,500.00 $1,177,734.34
$0.00
$2,778.717.17
$2,973,782.83
$2,429,843.07
Account Number
Fund: 071 Fire Pension Fund
Revenue
II - Investment Income
OR - Other Revenue
Fund Totals: Fire Pension Fund
Revenue Grand Totals:
Grand Totals:
N
W
Village of Mount Prospect
Summary of
Revenue
by Fund
and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Usedl
Adopted Budget
Amendments
Amended Budget
Transactions Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
$2,544,500.00
$0.00
$2,544,500.00
$238,282.57
$0.00
$1,497,807.33
$1,046,692.67
59%
$1,507,469.97
$2,695,300.00
$0.00
$2,695,300.00
$610,801.15
$0.00
$1,103,054.61
$1,592,245.39
41%
$1,014,879.42
$5,239,800.00
$0.00
$5,239,800.00
$849,083.72
$0.00
$2,600,861.94
$2,638,938.06
$2,522,349.39
$86,471,465.00
$30,000.00
$86,501,465.00
$13,064,541.00
$0.00
$27,513,958.91
$58,987,506.09
32%
$26,324,983.71
$86,471,465.00
$30,000.00
$86,501,465.00
$13,064,541.00
$0.00
$27,513,958.91
$58,987,506.09
$26,324,983.71
N
W
Village of Mount Prospect
Summary of Expenses by Fund and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Account Number
Adopted Budget
Amendments
Amended Budget
Transactions
Encumbrances
Transactions
Transactions
Recd
Prior Year YTD
Fund: 001 General Fund
Expense
PS - Personal Services, Scheduled
$21,164,041.00
$0.00
$21,164,041.00
$1,579,353.69
$0.00
$6,406,592.50
$14,757,448.50
30%
$6,702,829.70
Salaries & Wages
PSU - Personal Services, Unscheduled
$1,334,549.18
$107,000.00
$1,441,549.18
$49,409.99
$0.00
$403,587.59
$1,037,961.59
28%
$312,615.53
Salaries & Wages
EB - Employee Benefits
$10,125,347.78
$0.00
$10,125,347.78
$1,646,750.24
$0.00
$3,875,116.29
$6,250,231.49
38%
$3,745,417.25
OEC - Other Employee Costs
$381,675.00
$10,006.42
$391,681.42
$22,258.94
$17,938.07
$93,458.48
$280,284.87
28%
$85,064.73
PB - Pension Benefits
$45,863.00
$0.00
$45,863.00
$3,821.80
$0.00
$15,287.20
$30,575.80
33%
$15,241.28
CS - Contractual Services
$6,016,947.00
$254,161.00
$6,271,108.00
$446,947.87
$529,142.30
$1,794,465.21
$3,947,500.49
37%
$1,496,178.60
UT - Utilities
$284,227.00
$0.00
$284,227.00
$8,843.62
$0.00
$28,783.90
$255,443.10
10%
$36,734.26
IN - Insurance
$318,468.00
$0.00
$318,468.00
$26,539.01
$0.00
$106,156.04
$212,311.96
33%
$77,570.32
CSU - Commodities & Supplies
$661,150.00
$2,950.00
$664,100.00
$39,206.72
$43,278.34
$142,841.64
$477,980.02
28%
$137,154.35
OE - Other Expenditures
$12,000.00
$0.00
$12,000.00
$0.00
$0.00
$0.00
$12,000.00
0%
$0.00
BI - Building Improvements
$3,933.00
$0.00
$3,933.00
$0.00
$0.00
$0.00
$3,933.00
0%
$0.00
OEQ - Office Equipment
$48,696.00
$0.00
$48,696.00
$0.00
$11,078.00
$0.00
$37,618.00
23%
$15,098.41
OTE - Other Equipment
$156,533.00
$0.00
$156,533.00
$20,163.32
$17,088.60
$32,644.19
$106,800.21
32%
$7,276.59
INF - Infrastructure
$17,000.00
$0.00
$17,000.00
$55.00
$0.00
$55.00
$16,945.00
0%
$55.00
IT - Interfund Transfers
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
TBD - To Be Determined
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
Fund Totals: General Fund
$40,570,429.96
$374,117.42
$40,944,547.38
$3,843,350.20
$618,525.31
$12,898,988.04
$27,427,034.03
$12,631,236.02
N
Account Number
Fund: 002 Debt Service Fund
Expense
CS - Contractual Services
OE - Other Expenditures
BP - Bond Principal
IE - Interest Expense
BFF - Bank & Fiscal Fees
IT - Interfund Transfers
OFU - Other Financing Uses
Fund Totals: Debt Service Fund
Village of Mount Prospect
Summary of Expenses by Fund
and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Adopted Budget
Amendments
Amended Budget Transactions Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
$0.00
$0.00
$0.00 $0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$0.00
$0.00
$0.00 $0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$1,312,701.00
$0.00
$1,312,701.00 $164,939.70
$0.00
$164,939.70
$1,147,761.30
13%
$17,193.13
$1,102,047.00
$0.00
$1,102,047 00 $23,333.90
$0.00
$23,333.90
$1,078,713.10
2%
$2,451.29
$1,800.00
$0.00
$1,800.00 $0.00
$0.00
$1,584.00
$216.00
88%
$878.00
$0.00
$0.00
$0.00 $0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$0.00
$0.00
$0.00 $0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$2,416,548.00
$0.00
$2,416,548.00 $188,273.60
$0.00
$189,857.60
$2,226,690.40
$20,522.42
Village of Mount Prospect
Summary of Expenses by Fund and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
w
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Account Number
Adopted Budget
Amendments
Amended Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund: 020 Capital Improvement Fund
Expense
CS - Contractual Services
$200,000.00
$342,700.00
$542,700.00
$16,433.53
$376,063.26
$28,069.20
$138,567.54
74%
$109,675.22
OE - Other Expenditures
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
LI - Land Inprovements
$0.00
$26,065.00
$26,065.00
$0.00
$0.00
$0.00
$26,065.00
0%
$0.00
BI - Building Improvements
$371,000.00
$32,000.00
$403,000.00
$0.00
$29,577.01
$115.00
$373,307.99
7%
$80,406.35
OEQ - Office Equipment
$108,000.00
$0.00
$108,000.00
$0.00
$0.00
$0.00
$108,000.00
0%
$0.00
ME - Motor Equipment
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
OTE - Other Equipment
$32,500.00
$256,089.00
$288,589.00
$35,252.86
$13,097.00
$35,252.86
$240,239.14
17%
$29,196.55
INF- Infrastructure
$264,000.00
$231,086.00
$495,086.00
$0.00
$21,835.58
$3,025.00
$470,225.42
5%
$58,213.20
IT - Interfund Transfers
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
Fund Totals: Capital Improvement
$975,500.00
$887,940.00
$1,863,440.00
$51,686.39
$440,572.85
$66,462.06
$1,356,405.09
$277,491.32
Fund
w
Village of Mount Prospect
Summary of Expenses by Fund and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget Current Month YTD YTD Budget - YTD % Used/
Account Number Adopted Budget Amendments Amended Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund: 021 Series 2009 Construction Fund
Expense
CS - Contractual Services
$0.00
$750.00
$750.00
$350.13
$0.00
$350.13
$399.87
47%
$59,545.02
BI - Building Improvements
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$1,634,403.76
OEQ - Office Equipment
$0.00
$2,200.00
$2,200.00
$2,123.61
$232.35
$2,123.61
($155.96)
107%
$0.00
OTE - Other Equipment
$0.00
$145,200.00
$145,200.00
$41,178.55
$15,147.95
$80,752.05
$49,300.00
66%
$258,613.25
Fund Totals: Series 2009 Construction
$0.00
$148,150.00
$148,150.00
$43,652.29
$15,380.30
$83,225.79
$49,543.91
$1,952,562.03
Fund
Village of Mount Prospect
Summary of Expenses by Fund and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget Current Month YTD YTD
Account Number Adopted Budget Amendments Amended Budget Transactions Encumbrances Transactions
Fund: 022 Downtown Redevelopment Construct
$88,500.00
Expense
$46,320.00
CS - Contractual Services
$88,500.00
UT - Utilities
$0.00
OE - Other Expenditures
$2,590,155.00
INF - Infrastructure
$210,002.00
BP - Bond Principal
$0.00
IE - Interest Expense
$0.00
Fund Totals: Downtown
$2,888,657.00
Redevelopment Construct
$0.00
Budget - YTD % Used/
Transactions Rec'd Prior Year YTD
$0.00
$88,500.00
$13,886.10
$46,320.00
$77,972.07
($35,792.07)
140%
$15,492.80
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$0.00
$2,590,155.00
$22,204.86
$0.00
$1,333,048.86
$1.257,106.14
51%
$31,303.07
$68,134.00
$278,136.00
$0.00
$201,547.50
$0.00
$76,588.50
72%
$16,059.64
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$68,134.00
$2,956,791.00
$36,090.96
$247,867.50
$1,411,020.93
$1,297,902.57
$62,855.51
V1
99
Village of Mount Prospect
Summary of Expenses by Fund and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget Current Month YTD YTD Budget - YTD % Used/
Account Number Adopted Budget Amendments Amended Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund: 023 Street Improvement Construe Fund
Expense
CS - Contractual Services
$142,000.00
$12,708.00
$154,708.00
$0.00
$50,881.00
$0.00
$103,827.00 33%
$3,58410
INF - Infrastructure
$1,605,000.00
$812,932.00
$2,417,932.00
$6,434.95
$2,055,145.42
$41,439.53
$321,347.05 87%
$66.15
IT - Interfund Transfers
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00 + ++
$0.00
Fund Totals: Street Improvement
$1,747,000.00
$825,640.00
$2,572,640.00
$6,434.95
$2,106,026.42
$41,439.53
$425,174.05
$3,650.25
Construe Fund
Village of Mount Prospect
Summary of Expenses by Fund and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget Current Month YTD YTD
Account Number Adopted Budget Amendments Amended Budget Transactions Encumbrances Transactions
Fund: 024 Flood Control Construction Fund
$0.00
Expense
$0.00
CS - Contractual Services
$0.00
OE - Other Expenditures
$5,150.00
OTE - Other Equipment
$0.00
INF - Infrastructure
$400,000.00
Fund Totals: Flood Control
$405,150.00
Construction Fund
$0.00
Budget - YTD % Used/
Transactions Recd Prior Year YTD
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00 + ++
$0.00
$0.00
$5,150.00
$0.00
$0.00
$0.00
$5,150.00 0%
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00 + ++
$0.00
$50,000.00
$450,000.00
$0.00
$4,800.00
$0.00
$445,200.00 1%
$0.00
$50,000.00
$455,150.00
$0.00
$4,800.00
$0.00
$450,350.00
$0.00
..
Account Number
Fund: 040 Refuse Disposal Fund
Expense
PS - Personal Services, Scheduled
Salaries & Wages
PSU - Personal Services, Unscheduled
Salaries & Wages
EB - Employee Benefits
OEC - Other Employee Costs
CS - Contractual Services
UT - Utilities
IN - Insurance
CSU - Commodities & Supplies
Fund Totals: Refuse Disposal Fund
Village of Mount Prospect
Summary of Expenses
by Fund
and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Adopted Budget
Amendments
Amended Budget
Transactions Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
$197,495.00
$0.00
$197,495.00
$14,760.50
$0.00
$58,702.33
$138,792.67
30%
$54,431.58
$61,832.00
$0.00
$61,832.00
$0.00
$0.00
$269.93
$61,562.07
0%
$0.00
$90,328.00
$0.00
$90,328.00
$6,339.48
$0.00
$26,682.47
$63,645.53
30%
$22,376.81
$1,200.00
$0.00
$1,200.00
$0.00
$0.00
$0.00
$1,200.00
0%
$0.00
$3,968,555.00
$0.00
$3,968,555.00
$316,014.87
$0.00
$1,054,770.20
$2,913,784.80
27%
$1,051,026.00
$572.00
$0.00
$572.00
$21.68
$0.00
$54.72
$517.28
10%
$102.70
$25,175.00
$0.00
$25,175.00
$2,097.92
$0.00
$8,391.68
$16,783.32
33%
$7,578.00
$33,737.00
$0.00
$33,737.00
$11,096.70
$1,941.50
$11,096.70
$20,698.80
39%
$0.00
$4,378,894.00
$0.00
$4,378,894.00
$350,331.15
$1,941.50
$1,159,968.03
$3,216,984.47
$1,135,515.09
Account Number
Fund: 041 Motor Fuel Tax Fund
Expense
CS - Contractual Services
UT - Utilities
CSU - Commodities & Supplies
INF - Infrastructure
Fund Totals: Motor Fuel Tax Fund
M
Village of Mount Prospect
Summary of Expenses by Fund
and Category
Summary - through 4/3012011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Adopted Budget
Amendments
Amended Budget Transactions Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
$186,302.00
$0.00
$186,302.00 $11,282.42
$48,334.00
$15,234.42
$122,733.58
34%
$13,782.91
$150,000.00
$0.00
$150,000.00 $21,105.01
$0.00
$59,714.10
$90,285.90
40%
$3,134.43
$200,000.00
$0.00
$200,000.00 $0,00
$15,000.00
$197,693.60
($12,693.60)
106%
$156,03181
$550,000.00
$60,000.00
$610,000.00 $17,291.00
$579,925.00
$17,291.00
$12,784.00
98%
$0.00
$1,086,302.00
$60,000.00
$1,146,302.00 $49,678.43
$643,259.00
$289,933.12
$213,109.88
$172,951.15
M
F-
0
Village of Mount Prospect
Summary of Expenses by Fund and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget Current Month YTD YTD Budget-YTD % Used/
Account Number Adopted Budget Amendments Amended Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund: 042 Cmmty Development Block Grant
$63,550.00
Expense
$4,425.76
PS - Personal Services, Scheduled
$63,550.00
Salaries & Wages
$16,897.92
PSU - Personal Services, Unscheduled
$0.00
Salaries & Wages
$17,401.13
EB - Employee Benefits
$25,162.00
OEC - Other Employee Costs
$1,850.00
CS - Contractual Services
$183,680.00
CSU - Commodities & Supplies
$977.00
OE - Other Expenditures
$180,000.00
LI - Land Inprovements
$0.00
BI - Building Improvements
$0.00
INF - Infrastructure
$0.00
Fund Totals: Cmmty Development
$455,219.00
Block Grant
$7,654.74
$0.00
$63,550.00
$4,425.76
$0.00
$16,897.92
$46,652.08
27%
$17,401.13
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$0,00
$25,162.00
$1,947.70
$0.00
$7,654.74
$17,507.26
30%
$7,240.84
$0.00
$1,850.00
$0.00
$0.00
$253.56
$1,596.44
14%
$25.00
$0.00
$183,680.00
$425.83
$0.00
$14,529.88
$169,150.12
8%
$37,663.44
$0.00
$977.00
$0.00
$0.00
$56.99
$920.01
6%
$81.26
$0.00
$180,000.00
$0.00
$7,170.00
$29,637.75
$143,192.25
20%
$31,826.16
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$3,360.00
$0.00
$455,219.00
$6,799.29
$7,170.00
$69,030.84
$379,018.16
$97,597.83
Account Number
Fund: 043 Asset Seizure Fund
Expense
OEC - Other Employee Costs
CS - Contractual Services
OTE - Other Equipment
Fund Totals: Asset Seizure Fund
Village of Mount Prospect
Summary of Expenses by Fund
and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Adopted Budget
Amendments
Amended Budget Transactions Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
$1,000.00
$0.00
$1,000.00 $0.00
$0.00
$0.00
$1,000.00
0%
$0.00
$1,500.00
$0.00
$1,500.00 $0.00
$0.00
$0.00
$1,500.00
0%
$0.00
$1,000.00
$0.00
$1,000.00 $0.00
$5,290.00
$0.00
($4,290.00)
529%
$1,133.00
$3,500.00
$0.00
$3,500.00 $0.00
$5,290.00
$0.00
($1,790.00)
$1,133.00
F-
hi
Account Number
Fund: 044 IDEA Shared Funds Fund
Expense
CS - Contractual Services
OTE - Other Equipment
Fund Totals: DEA Shared Funds Fund
Village of Mount Prospect
Summary
of Expenses by Fund
and Category
Summary - through 4/3012011
Prior Fiscal Year Activity Included
Budget Current Month
YTD YTD
Budget - YTD % Used/
Adopted Budget Amendments
Amended Budget Transactions Encumbrances Transactions
Transactions Rec'd
Prior Year YTD
$1,000.00
$0.00 $1,000.00 $0.00
$0.00 $0.00
$1,000.00 0%
$0.00
$1,000.00
$0.00 $1,000.00 $0.00
$6,076.78 $0.00
($5,076.78) 608%
$0.00
$2,000.00
$0.00 $2,000.00 $0.00
$6,076.78 $0.00
($4,076.78)
$0.00
Account Number
Fund: 045 DUI Fine Fund
Expense
OEC - Other Employee Costs
OTE - Other Equipment
IT - Interfund Transfers
Fund Totals: DUI Fine Fund
F—
w
Village of Mount Prospect
Summary of Expenses by Fund
and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Adopted Budget
Amendments
Amended Budget Transactions Encumbrances
Transactions
Transactions
Recd
Prior Year YTD
$0.00
$0.00
$0.00 $0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$1,500.00
$0.00
$1,500.00 $0.00
$0.00
$0.00
$1,500.00
0%
$0.00
$0.00
$0.00
$0.00 $0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$1,500.00
$0.00
$1,500.00 $0.00
$0.00
$0.00
$1,500.00
$0.00
F—
w
Account Number
Fund: 046 Foreign Fire Tax Board Fund
Expense
CS - Contractual Services
IN - Insurance
CSU - Commodities & Supplies
OTE - Other Equipment
Fund Totals: Foreign Fire Tax Board
Fund
Village of Mount Prospect
Summary of Expenses by Fund
and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Adopted Budget
Amendments
Amended Budget Transactions Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
$10,000.00
$0.00
$10,000.00 $0.00
$0.00
$2,532.53
$7,467.47
25%
$8,586.56
$550.00
$0.00
$550.00 $0.00
$0.00
$417.21
$132.79
76%
$0.00
$3,000.00
$0.00
$3,000.00 $0.00
$0.00
$0.00
$3,000.00
0%
$62.08
$15,000.00
$0.00
$15,000.00 $0.00
$0.00
$0.00
$15,000.00
0%
$1,299.99
$28,550.00
$0.00
$28,550.00 $0.00
$0.00
$2,949.74
$25,600.26
$9,948.63
Account Number
Fund: 050 Water and Sewer Fund
Expense
PS - Personal Services, Scheduled
Salaries & Wages
PSU - Personal Services, Unscheduled
Salaries & Wages
EB - Employee Benefits
OEC - Other Employee Costs
CS - Contractual Services
UT - Utilities
IN - Insurance
CSU - Commodities & Supplies
OE - Other Expenditures
OEQ - Office Equipment
OTE - Other Equipment
DS - Distribution Systems
BP - Bond Principal
IE - Interest Expense
IT - Interfund Transfers
TBD - To Be Determined
Fund Totals: Water and Sewer Fund
v,
Village of Mount Prospect
Summary
of Expenses
by Fund
and Category
Summary - through 4130/2011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Adopted Budget
Amendments
Amended Budget
Transactions Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
$1,790,680.00
$0.00
51,790,680.00
$111.069.40
$0.00
$444,117.80
$1,346,562.20
25%
$490,241.76
$180,295.00
$0.00
$180,295.00
$15,275.84
$0.00
$59,747.49
$120,547.51
33%
$19,330.51
$726,681.00
$0.00
$726,681.00
$52,830.09
$0.00
$219,827.32
$506,853.68
30%
$216,527.74
$35,941.00
$25,285.00
$61,226.00
$3,771.42
$2,436.16
$12,551.85
$46,237.99
24%
$11,658.10
$5,571,684.00
$276,737.00
$5,848,421.00
$445,497.57
$333,784.64
$1,315,295.29
$4,199,341.07
28%
$1,341,911.84
$198,006.00
$0.00
$198,006.00
$8,908.75
$0.00
$33,314.78
$164,691.22
17%
$38,504.75
$76,838.00
$0.00
$76,838.00
$6,403.16
$0.00
$25,612.64
$51,225.36
33%
$22,098.36
$302,620.00
$0.00
$302,620.00
$19,658.49
$38,297.06
$47,035.60
$217,287.34
28%
$52,973.66
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$1,344.00
$6,088.00
$7,432.00
$0.00
$0.00
$0.00
$7,432.00
0%
$0.00
$288,345.00
$710,418.00
$998,763.00
$7,650.65
$86,719.94
$17,213.33
$894,829.73
10%
$3,112.06
$1,658,000.00
$1,327,210.00
$2,985,210.00
$337,109.45
$71,198.34
$913,920.92
$2,000,090.74
33%
$27,994.50
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$10,830,434.00
$2,345,738.00
$13,176,172.00
$1,008,174.82
$532,436.14
$3,088,637.02
$9,555,098.84
$2,224,353.28
v,
R
Village of Mount Prospect
Summary of Expenses by Fund and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Account Number
Adopted Budget
Amendments
Amended Budget
Transactions
Encumbrances
Transactions
Transactions
Recd
Prior Year YTD
Fund: 051 Village Parking System Fund
Expense
PS - Personal Services, Scheduled
$29,176.00
$0.00
$29,176.00
$1,223.04
$0.00
$4,831.00
$24,345.00
17%
$4,302.70
Salaries & Wages
PSU - Personal Services, Unscheduled
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
Salaries & Wages
EB - Employee Benefits
$11,146.00
$0.00
$11,146.00
$700.79
$0.00
$2,799.26
$8,346.74
25%
$3,077.57
CS - Contractual Services
$81,640.00
$0.00
$81,640.00
$5,296.53
$15,362.47
$25,429.63
$40,847.90
50%
$20,259.66
IN - Insurance
$755.00
$0.00
$755.00
$62.92
$0.00
$251.68
$503.32
33%
$315.68
CSU - Commodities & Supplies
$500.00
$0.00
$500.00
$0.00
$0.00
$0.00
$500.00
0%
$184.13
OE - Other Expenditures
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
BI - Building Improvements
$6,800.00
$0.00
$6,800.00
$0.00
$0.00
$5,000.00
$1,800.00
74%
$904.76
INF - Infrastructure
$80,000.00
$0.00
$80,000.00
$0.00
$0.00
$0.00
$80,000.00
0%
$0.00
IT - Interfund Transfers
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
TBD - To Be Determined
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
Fund Totals: Village Parking System
$210,017.00
$0.00
$210,017.00
$7,283.28
$15,362.47
$38,311.57
$156,342.96
$29,044.50
Fund
Village of Mount Prospect
Summary of Expenses by Fund and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget Current Month YTD YTD
Account Number Adopted Budget Amendments Amended Budget Transactions Encumbrances Transactions
Fund: 052 Parking System Revenue Fund
Expense
PS - Personal Services, Scheduled
$23,866.00
Salaries & Wages
PSU - Personal Services, Unscheduled
$0.00
Salaries & Wages
EB - Employee Benefits
$9,488.00
CS - Contractual Services
$103,027.00
UT - Utilities
$10,317.00
IN - Insurance
$1,011.00
CSU - Commodities & Supplies
$9,586.00
OE - Other Expenditures
$0.00
BI - Building Improvements
$25,000.00
INF - Infrastructure
$80,000.00
IT - Interfund Transfers
$0.00
TBD - To Be Determined
$0.00
Fund Totals: Parking System Revenue
$262,295.00
Fund
Budget - YTD % Used/
Transactions Rec'd Prior Year YTD
$0.00
$23,866.00
$2,761.99
$0.00
$10,909.80
$12,956.20
46%
$10,391.50
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$0.00
$9,488.00
$914.07
$0.00
$3,645.21
$5,842.79
38%
$3,338.10
$0.00
$103,027.00
$2,556.19
$3,212.20
$20,314.88
$79,499.92
23%
$23,438.76
$0.00
$10,317.00
$934.26
$0.00
$2,808.75
$7,508.25
27%
$2,202.61
$0.00
$1,011.00
$84.25
$0.00
$337.00
$674.00
33%
$315.68
$0.00
$9,586.00
$0.00
$0.00
$98.04
$9,487.96
1%
$2,162.47
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$25,000.00
$50,000.00
$0.00
$0.00
$0.00
$50,000.00
0%
$0.00
$0.00
$80,000.00
$0.00
$0.00
$0.00
$80,000.00
0%
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$25,000.00
$287,295.00
$7,250.76
$3,212.20
$38,113.68
$245,969.12
$41,849.12
J
I
Account Number
Fund: 060 Vehicle Maintenance Fund
Expense
PS - Personal Services, Scheduled
Salaries & Wages
PSU - Personal Services, Unscheduled
Salaries & Wages
EB - Employee Benefits
OEC - Other Employee Costs
CS - Contractual Services
UT - Utilities
CSU - Commodities & Supplies
OE - Other Expenditures
OEQ - Office Equipment
OTE - Other Equipment
Fund Totals: Vehicle Maintenance
Fund
Village of Mount Prospect
Summary of
Expenses
by Fund
and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Adopted Budget
Amendments
Amended Budget
Transactions Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
$793,652.00
$0.00
$793,652.00
$60,790.18
$0.00
$242,462.33
$551,189.67
31%
$224,900.89
$68,250.00
$0.00
$68,250.00
$4,337.78
$0.00
$33,217.17
$35,032.83
49%
$24,455.65
$332,734.00
$0.00
$332,734.00
$24,922.82
$0.00
$105,003.52
$227,730.48
32%
$104,993.87
$2,315.00
$0.00
$2,315.00
$290.00
$0.00
$320.00
$1,995.00
14%
$530.00
$98,464.00
$0.00
$98,464.00
$6,122.29
$5,880.06
$28,381.13
$64,202.81
35%
$16,169.78
$993.00
$0.00
$993.00
$54.26
$0.00
$136.92
$856.08
14%
$256.75
$603,349.00
$0.00
$603,349.00
$43,705.68
$281,227.67
$212,004.16
$110,117.17
82%
$170,457.70
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$545.00
$0.00
$545.00
$0.00
$0.00
$0.00
$545.00
0%
$0.00
$3,500.00
$0.00
$3,500.00
$205.97
$0.00
$2,806.67
$693.33
80%
$0.00
$1,903,802.00
$0.00
$1,903,802.00
$140,428.98
$287,107.73
$624,331.90
$992,362.37
$541,764.64
Account Number
Fund: 061 Vehicle Replacement Fund
Expense
OE - Other Expenditures
ME - Motor Equipment
IT - Interfund Transfers
TBD - To Be Determined
Fund Totals: Vehicle Replacement
Fund
F-
Village of Mount Prospect
Summary
of Expenses by Fund
and Category
Summary - through 4/3012011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Adopted Budget
Amendments
Amended Budget Transactions Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
$0.00
$0.00
$0.00 $0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$613,650.00
$57,000.00
$670,650.00 $11,965.32
$155,033.00
$18,998.70
$496,618.30
26%
$291,898.69
$0.00
$0.00
$0.00 $0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$0.00
$0.00
$0.00 $0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$613,650.00
$57,000.00
$670,650.00 $11,965.32
$155,033.00
$18,998.70
$496,618.30
$291,898.69
F-
N
O
Village of Mount Prospect.
Summary of Expenses by Fund
and Category
Summary - through 4130/2011
Prior Fiscal Year Activity Included
Budget Current Month
YTD YTD
Budget - YTD % Used/
Account Number
Adopted Budget Amendments Amended Budget Transactions Encumbrances Transactions
Transactions Recd Prior Year YTD
Fund: 062 Computer Replacement Fund
Expense
OEQ - Office Equipment
$194,950.00 $0.00 $194,950.00 $9,953.89
$5,502.73 $18,993.79
$170,453.48 13% $101,962.12
Fund Totals: Computer Replacement
$194,950.00 $0.00 $194,950.00 $9,953.89
$5,502.73 $18,993.79
$170,453.48 $101,962.12
Fund
Account Number
Fund: 063 Risk Management Fund
Expense
CS - Contractual Services
IN - Insurance
OTE - Other Equipment
INF - Infrastructure
Fund Totals: Risk Management Fund
N
F-'
Village of Mount Prospect
Summary
of Expenses by Fund
and Category
Summary - through 4130/2011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Adopted Budget Amendments
Amended Budget Transactions Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
$13,500.00
$0.00
$13,500.00 $6,906.00
$0.00
$500.00
$13,000.00
4%
$0.00
$6,785,343.00
$0.00
$6,785,343.00 $597,713.95
$2,980.29
$2,324,734.93
$4,457,627.78
34%
$2,184,174.98
$0.00
$0.00
$0.00 $0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$0.00
$0.00
$0.00 $0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$6,798,843.00
$0.00
$6,798,843.00 $604,619.95
$2,980.29
$2,325,234.93
$4,470,627.78
$2,184,174.98
N
F-'
N
N
Account Number
Fund: 070 Police Pension Fund
Expense
PB - Pension Benefits
CS - Contractual Services
IN - Insurance
CSU - Commodities & Supplies
OE - Other Expenditures
OEQ - Office Equipment
Fund Totals: Police Pension Fund
B
Village of Mount Prospect
Summary of Expenses by Fund
and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Adopted Budget
Amendments
Amended Budget Transactions Encumbrances
Transactions
Transactions
Recd
Prior Year YTD
$3,431,110.00
$0.00
$3,431,110.00 $297,009.68
$0.00
$1,188,038.72
$2,243,071.28
35%
$1,066,933.35
$123,500.00
$0.00
$123,500.00 $15,827.77
$0.00
$27,454.01
$96,045.99
22%
$26,396.20
$10,000.00
$0.00
$10,000.00 $0.00
$0.00
$0.00
$10,000.00
0%
$0.00
$500.00
$0.00
$500.00 $0.00
$0.00
$0.00
$500.00
0%
$0.00
$12,000.00
$0.00
$12,000.00 $0.00
$0.00
$275.00
$11,725.00
2%
$850.00
$0.00
$0.00
$0.00 $0.00
$0.00
$0.00
$0.00
+ ++
$0.00
$3,577,110.00
$0.00
$3,577,110.00 $312,837.45
$0.00
$1,215,767.73
$2,361,342.27
$1,094,179.55
B
Account Number
Fund: 071 Fire Pension Fund
Expense
PB - Pension Benefits
CS - Contractual Services
IN - Insurance
CSU - Commodities & Supplies
OE - Other Expenditures
Fund Totals: Fire Pension Fund
Expenditure Grand Totals:
Grand Totals:
N
W
Village of Mount Prospect
Summary
of Expenses
by Fund
and Category
Summary - through 4/30/2011
Prior Fiscal Year Activity Included
Budget
Current Month
YTD
YTD
Budget - YTD
% Used/
Adopted Budget
Amendments
Amended Budget
Transactions Encumbrances
Transactions
Transactions
Recd
Prior Year YTD
$3,112,073.00
$0.00
$3,112,073.00
$295,298.03
$0.00
$1,181,168.63
$1,930,904.37
38%
$1,001,782.31
$132,000.00
$1,000.00
$133,000.00
$12,259.00
$0.00
$28,874.41
$104,125.59
22%
$36,310.84
$12,000.00
($1,000.00)
$11,000.00
$0.00
$0.00
$0.00
$11,000.00
0%
$0.00
$1,000.00
$0.00
$1,000.00
$0.00
$0.00
$0.00
$1,000.00
0%
$0.00
$12,000.00
$0.00
$12,000.00
$120.00
$0.00
$120.00
$11,880.00
1%
$0.00
$3,269,073.00
$0.00
$3,269,073.00
$307,677.03
$0.00
$1,210,163.04
$2,058,909.96
$1,038,093.15
$82,619,423.96
$4,841,719.42
$87,461,143.38
$6,986,488.74
$5,098,544.22
$24,791,428.04
$57,571,171.12
34%
$23,912,783.28
$82,619,423.96
$4,841,719.42
$87,461,143.38
$6,986,488.74
$5,098,544.22
$24,791,428.04
$57,571,171.12
$23,912,783.28
N
W
VILLAGE OF MOUNT PROSPECT
List of Bills
April 28 - May 11, 2011
Fund Vendor
Description
Amount
001- General Fund
ACS State & Local Government Solutions
04/28/11 Payroll
S 3,115.21
ACS State & Local Government Solutions
5/11/2011 Payroll EFT
3,595.45
Active Alarm Company, Inc.
Property Maintenance
221.25
Addison Building Material Co.
Black paint for banner hardware
65.56
Addison Building Material Co.
Maintenance and repair supplies
10.96
Air One Equipment, Inc.
Breathing Apparatus Supplies/ Fit Test Kit
175.00
Airgas North Central
Oxygen
373.89
Alexian Brothers Medical Center
Pre - employment Screening K. Opalacz
69.00
Amer Reprographics Co Lic
Equipment Maintenance
59.00
American Messaging
Monthly Pager Rental - May
701.59
American Professional Management Services
Registration/ Malcolm International Conference for Fire & Rescue
712.28
Anderson Lock Company
Maintenance and repair supplies
42.00
Anderson Pest Solutions
Pest Control for May - Community Connection Ctr
48.00
Andres Medical Billing, Ltd.
Ambulance Billing -April 2011
4,412.73
Andrew & Seana Mc Pherson
Real Estate tax Rebate 2011
820.00
ARC Disposal Company
Stump Grinding Disposal
343.62
ASCE
Membership Renewal
240.00
AT & T
Service 4/16/11 - 5/15/11
746.37
AT&T
Service 4/16/11 - 5/15/11
332.14
Autumn Tree Care Experts
Gypsy moth spraying
1,456.00
Bald Eagle Window Cleaning
Window Cleaning
1,705.00
Bedco Mechanical
Maintenance and repair supplies
284.80
Bedco Mechanical
Add R -22 to air conditioner at the Village Hall.
466.00
Bedco Mechanical
2011 HVAC Maintenance
1,421.65
Bound Tree Medical, L-C.
64 - MRX Recording paper 989803138181
331.52
Bound Tree Medical, L-C.
Paramedic Supplies
1,509.44
Brian Lambel
Refreshments for Training Session
61.83
Bright Electrical Supply Co.
Building Maintenance
704.78
Bristol Court
5/3/11 Event Catering
605.00
Cash
PW Open House - MP Lion's Club Donation
1,100.00
Central Continental Bakery
D. Zboril's Promotion reception
74.70
Central Continental Bakery
2010 Officer of the Year reception
107.01
Century Cleaners
Uniform Cleaning
24.47
Century Cleaners
Uniform Cleaning
8.90
Century Cleaners
Uniform Cleaning
35.60
Century Cleaners
Uniform Cleaning
8.90
Century Cleaners
Uniform Cleaning
22.25
Century Cleaners
Uniform Cleaning
33.37
Century Cleaners
Uniform Cleaning
33.37
Century Cleaners
Uniform Cleaning
26.70
Cheryl Schmadebeck
Refund Duplicate Payments
72.00
Cook County Recorder of Deeds
Replenish CCRD On Line Account
1,000.00
Crystal Court Shopping Center
May 2011 Rental
3,408.00
Crystal Maintenance Services Corp.
Custodial Services
6,163.62
Cygnus Business Media, Inc.
Subscription/ Malcolm, Firehouse Magazine
25.95
Daniel P Usalis
Refund vehicle License #22826
36.00
Dirk 011ech
Reimburse expenses
67.00
Donna Klopotowski
Refund Vehicle License
54.00
Dreisilker Electric Motors, Inc.
Maintenance and repair supplies
1,045.96
Elizabeth A. Pope
04/28/11 Payroll Checks
923.08
Elvira C Villanueva
Refund Overpayment Vehicle License # 16328
24.00
Entersect Corporation
Entersect Police Online service
88.95
Everbank Commercial Finance, Inc.
Rental 5/24/11- CC Center
396.90
Everbank Commercial Finance, Inc.
Rental 5/23/11
2,252.07
Federal Express Corp
Shipping Charges
18.86
Fire Pension Fund
04/28/11 Payroll Checks
21,211.28
Forrest Keeling Nursery
Forestry Equipment and Supplies
100.85
Francisco Guerrero
Safety Shoes
117.98
Frank M. Krupa
Reimbursement for 1 ICC Certification Renewal
50.00
GE Capital
Service 4/15/11- 5/14/11
795.78
Gerard Klos
Refund vehicle License Fee
54.00
Government Finance Officers Assoc
Distinguished Budget Presentation Awards Program
425.00
Government Mangement Information Sciences
Annual Membership Renewal
150.00
Grainger Inc.
Custodial Supplies
41.88
Grainger Inc.
Compressor Air Repairs
1,490.77
Page 1 of 7
VILLAGE OF MOUNT PROSPECT
List of Bills
April 28 - May 11, 2011
Fund Vendor
Description
Amount
Grainger Inc.
Building Maintenance & Supplies
210.25
Gregory Sill
Reimburse training expenses
40.00
Healy Asphalt Company, LLC.
Patching & Paving Materials
23.92
Heart Printing Inc.
Printing
297.50
Heather Mcelroy
Refund Vehicle License #175227
36.00
Homer Tree Care, Inc.
Parkway Tree Removal
600.00
Homer Tree Care, Inc.
Parkway Tree Removal
4,577.00
House of Szechwan
Refund Vehicle License
36.00
HSBC Business Solutions
Purchased 3/29/11- 4/19/11
273.52
ICMA Retirement Trust - 457
04/28/11 Payroll
19,814.87
ICMA Retirement Trust - 457
5/11/2011 Payroll EFT
19,907.35
ILEAS
2011 Membership dues
150.00
ILEETA
Conference registrations & memberships
3,628.00
Illinois American Water Company
Private Fire Service 5/2/11
28.28
Illinois Department of Revenue
04/28/11 Payroll
38,348.39
Illinois Department of Revenue
5/11/2011 Payroll EFT
38,135.76
Illinois Dept.of Agriculture
Public Applicator License Renewal
20.00
Illinois Dept.of Agriculture
Public Applicator License Renewal
20.00
Illinois Landscape Contractors Assoc.
ILCA Membership Renewal
395.00
Illinois society of Fire Service Instructors
Registration/ Wisniewski Incident Safety Officer Sep 19 -23, 2011
300.00
Illinois Society of Fire Service Instructors
Registration/ Wisniewski Training Program Mgr Aug 22 -26, 2011
300.00
Illinois State Police
Fingerprinting fees for Liquor Licenses
34.25
Inlander Brothers Inc
Custodial Supplies
69.75
Inlander Brothers Inc
Custodial Supplies
47.25
Inlander Brothers Inc
Custodial Supplies
4.80
Inlander Brothers Inc
Custodial Supplies
45.00
Inlander Brothers Inc
Custodial Supplies
42.61
Internal Revenue Service
04/28/11 Payroll
179,570.99
Internal Revenue Service
5/11/2011 Payroll EFT
178,629.14
International Association of Fire Chiefs
Membership/ Malcolm
229.00
International Code Council, Inc.
Turbo tabs
32.00
International Union of Operating Engineers
04/28/11 Payroll Checks
1,051.15
International Union of Operating Engineers
04/28/11 Payroll Checks
471.75
Janet Keena
Refund Vehicle License
36.00
Janice Hedberg
Refund Overpayment Vehicle License
24.00
Jobs In Horticulture
Job Placement Ad
49.00
John Dahlberg
Reimburse expenses
146.82
John Malcolm
Expenses/ Malcolm Oct 16 -19,2011 Sch - "A"
1,107.40
John Malcolm
Lunch for Interfaith Council Meeting at EOC
201.25
Jozef Antosz
Refund Overpayment Vehicle License #9192
24.00
Julie A. Bolin
Framing of pictures
42.69
Julie A. Bolin
Reimbursement
34.94
Kathleen W. Bono,csr,ltd.
Court reporter liquor hearing
179.00
Kiesler Police Supply, Inc.
Simunition training ammo
810.00
Klein, Thorpe and Jenkins, Ltd.
Klein Thorpe & Jenkins
31,652.00
Kramer Tree Specialists
Grounds Maintenance
520.00
Kramer Tree Specialists
Grounds Maintenance
520.00
Kurt Aspen
Safety Shoes
64.52
L & B Business Services Inc.
Batteries for SCBA Equipment
97.20
Lands' End Business Outfitters
Replacement garments for staff
266.22
Lands' End Business Outfitters
Retiree shirt for Glen
40.45
Lands' End Business Outfitters
Replacement garments
22.70
Laner Muchin
Legal Labor
9,125.09
Larry Heinrich
Clothing Allowance
150.00
Laserline, Inc.
Equipment
81.58
Lechner and Sons
Uniform Rental & Cleaning
113.74
Lechner and Sons
Uniform Rental & Cleaning
113.74
Lexisnexis Risk Data Management Inc.
Background checks - April, 2011
77.75
Linda Both
Refund Vehicle License Fee
54.00
Lisa Kwan
Refund Vehicle License Fee
36.00
Lundstrom's Nursery, Inc.
Grounds Maintenance
1,097.49
Lyon Financial Services, Inc.
Usage 5/16/11
167.50
Major Case Assistance Team
MCAT Awards banquet
160.00
Maryellen Wheatley
Refund Vehicle License
36.00
Mcmaster -Carr Supply Co.
Maintenance & Repair Supplies
513.73
Meade Electric Co. Inc.
Traffic Signal Maintenance
913.18
Page 2 of 7
VILLAGE OF MOUNT PROSPECT
List of Bills
April 28 - May 11, 2011
Fund
Vendor
Description
Amount
Meinert J Mischnick
Refund Vehicle License
12.00
Menards
Shop Vacuum Filters and Bags Station 13
26.85
Menards
Materials for Ceremonial Bell Base
77.67
Menards
Supplies for Simunitions training
61.80
Metro Federal Credit Union
04/28/11 Payroll Checks
2,357.40
Metropolitan Alliance - Police
04/28/11 Payroll Checks
1,190.50
Michael Wagner & Sons, Inc.
Storm sewer repair parts
62.71
Micro Tech Systems, Inc.
Tape Library Repair Attempt
273.20
Micro Tech Systems, Inc.
Equipment Maintenance
228.70
Mobile Print Inc.
Printing Expense - Outsource
48.50
Mobile Print Inc.
Business Cards /Memo Pads for K. Greenlee
61.11
Mobile Print Inc.
Name Plate - K. Greenlee
21.00
Mobile Print Inc.
Fire Department Envelopes
285.18
Mobile Print Inc.
Business Cards
26.19
Nagurski Kiddie Rides, Inc.
Deposit for Downtown Block Parry
1,550.00
Nagurski Kiddie Rides, Inc.
Deposit for Oktoberfest
550.00
National Fire Sprinkler Assoc.
Annual membership dues
85.00
Nationwide Mutual Insurance Company
04/28/11 Payroll
13,743.00
Nationwide Mutual Insurance Company
5/11/2011 Payroll EFT
13,943.00
Nextel Communications
Service 3/18/11- 4/17/11
3,741.06
Nextel Communications
Project Shield
39.99
NICOR
Natural Gas Consumption
92.13
NICOR
Natural Gas Consumption
75.58
Northeastern III. Pub. Safety Trng.
FAE Training Fee for FF /P Schram (April 11 -13 & 18 -20, 2011)
575.00
Northeastern III. Pub. Safety Trng.
Registration/ Slobe Fae April 11, 2011 FAE SCHOOL
575.00
Northeastern III. Pub. Safety Trng.
Training
150.00
Northeastern III. Pub. Safety Trng.
Registration/ Slobe May 2 -6, 2011 Vehicle/ Machine Ops
575.00
Northeastern III. Pub. Safety Trng.
Registration/ Redlin Tactics/ Strategy I April & May
400.00
Northwest Central Dispatch System
June 2011- Member Assessment
44,914.36
Northwest Electrical Supply
Maintenance and repair supplies
175.82
Northwest Landscape Services, Inc.
Rake, Till and Seed Sites on River Road
200.00
Northwest Suburban United Way
04/28/11 Payroll Checks
263.78
Oklahoma State University
Fire inspection and code enforcement manual, 7th edition
92.23
Otis Elevator Company
Elevator Maintenance
10,390.33
Otto Engineering, Inc.
Radio equipment
511.45
Paul Fahey
Reimbursement
20.21
Peter Morris
Holmotro Tool Repair Parts
31.19
Petty Cash
Petty cash
301.25
Petty Cash
Petty Cash - Fire Department
90.49
Petty Cash
Petty Cash 4/1/11- 5/2/11
489.91
Pickard, Incorporated
Sister Cities Event
734.00
Police Pension Fund
04/28/11 Payroll Checks
26,835.03
Powell Tree Care, Inc.
Stump Removal
3,350.99
Powell Tree Care, Inc.
Stump Removal
3,069.39
Powell Tree Care, Inc.
Stump Removal
5,435.62
Powell Tree Care, Inc.
Stump Removal
2,162.93
Powell Tree Care, Inc.
Stump Removal
2,985.62
Red Wing Shoe Store
Safety Shoes
144.49
Red Wing Shoe Store
Safety Shoes
140.24
Red Wing Shoe Store
Safety Shoes
463.23
Red Wing Shoe Store
ET Supplies
221.44
Richard Beyna
Rebate Sidewalk Cost Program 4/6/11
110.00
Richard Neumann
Refund -Vehicle License
54.00
Richard Reichart
Consultation / - Foehring, William
500.00
Rotary Club of Mount Prospect
Rotary memberahip
170.00
Security Research Inc
Background Check for Guillermina Albanil -Golpe
25.00
Sirius Information, Inc.
Webinar
299.00
Staples Contract & Commercial, Inc.
Copy paper
797.80
Steiner Electric Company
Streetlight Supplies
411.76
Stephanie Cwiok
Reimb. Sidewalk Square 1/26/11
55.00
Surveymonkey.com
Annual subscription
200.00
Susan Roth
Refund Vehicle License
36.00
Thomas A. Clinger
Videotaped Retirement Party for Retirees
500.00
Tony Zisis
Refund Vehicle License
36.00
U.S. Bancorp Equipment Finance, Inc.
Usage 5/20/11
1,362.28
U.S. Bancorp Equipment Finance, Inc.
Usage 5/22/11 -1601 W Golf Road
138.78
Page 3 of 7
VILLAGE OF MOUNT PROSPECT
List of Bills
April 28 - May 11, 2011
Fund Vendor
Description
$
Amount
Ultra Strobe Communications, Inc.
Equipment supplies
54.24
United Healthcare
Administration -April 2011
705.50
United Parcel Service
Shipping charges for equipment repairs
25.58
Village of Arlington Heights
Registration/ Swat FAE April 18,19,20,25,26,27, 2011
$
475.00
Village of Mount Prospect
04/28/11 Payroll Checks
25,335.81
Village of Mount Prospect
04/28/11 Payroll Checks
$
13,242.03
Village of Romeoville
Registration/ Miller Lloyd- April 8, 2011 Vehicle Ops
$
140.00
Vojislav Domanovic
Refund Vehicle License Fee
36.00
Waterway Illinois
NFPA Required Annual Ground Ladder Test
$
456.25
Weeb Enterprises, LLC
Printing of 2010 FD Annual Report
1,199.16
WISCTF
04/28/11 Payroll Checks
542.48
Z Search Recruiting, Inc.
Photography services
400.00
Total: 001- General Fund
Recycling Supplies
$
793,126.03
002 - Debt Service Fund
Recycling Supplies
507.50
Illinois EPA
IEPA Loan L17 -0855
$
40,376.29
Illinois EPA
[EPA Loan L17 -0744
128,252.89
Total: 002 - Debt Service Fund
Sweeper main brooms
$
168,629.18
020 - Capital Improvement Fund
$
3,987.56
American Landscaping Inc.
Corridor Improvements
$
2,860.00
Midwest Media Group
2 Avid Editors
$
13,496.97
New World Systems Corporation
ERP - Installation Services and Travel Time
5,200.00
New World Systems Corporation
ERP - Installation Services and Travel Time
5,070.00
Total: 020 - Capital Improvement Fund
Electrical Service Delivery
$
26,626.97
022 - Downtown Redevelopment Construction
Arrow Road Construction
2011 Street Resurfacing/Streetscape Contract
$
178,563.00
Cook County Government
2010 Property Taxes Payable in 2011- Installment #1
1,108,000.00
Klein, Thorpe and Jenkins, Ltd.
Klein Thorpe & Jenkins
3,206.10
Lundstrom's Nursery, Inc.
Landscape Maintenance
10,680.00
Total: 022 - Downtown Redevelopment Construction
$
1,300,449.10
023 - Street Improvement Construction Fund
Arrow Road Construction
2011 Street Resurfacing/Streetscape Contract
$
186,022.00
Total: 023 - Downtown Redevelopment Construction
$
186,022.00
040 - Refuse Disposal Fund
American Future Systems, Inc.
Recycling Newsletter
$
299.00
AT&T
Service 4/16/11 - 5/15/11
4.1S
Groot Industries, Inc.
Debris Disposal
71.21
Proforma Customized Graphics
Recycling Supplies
560.00
Proforma Customized Graphics
Recycling Supplies
278.00
Proforma Customized Graphics
Recycling Supplies
507.50
Proforma Customized Graphics
Recycling Supplies
540.00
Proforma Customized Graphics
Recycling Supplies
802.50
United Rotary Brush
Sweeper main brooms
925.20
Total: 040 - Refuse Disposal Fund
$
3,987.56
041- Motor Fuel Tax Fund
Exelon Corporation
Electrical Service Delivery
$
2,693.83
Exelon Corporation
Electrical Service Delivery
106.99
Exelon Corporation
Electrical Service Delivery
77.80
Exelon Corporation
Electrical Service Delivery
291.11
Exelon Corporation
Electrical Service Delivery
110.99
Exelon Corporation
Electrical Service Delivery
100.27
Exelon Corporation
Electrical Service Delivery
123.43
Exelon Corporation
Electrical Service Delivery
78.17
Exelon Corporation
Electrical Service Delivery
177.99
Exelon Corporation
Electrical Service Delivery
53.02
Exelon Corporation
Electrical Service Delivery
126.40
Exelon Corporation
Electrical Service Delivery
125.07
Exelon Corporation
Electrical Service Delivery
214.21
Exelon Corporation
Electrical Service Delivery
153.55
Exelon Corporation
Electrical Service Delivery
7.54
Illinois State Treasurer
Traffic Signal Maintenance
5,090.67
Page 4 of 7
VILLAGE OF MOUNT PROSPECT
List of Bills
April 28 - May 11, 2011
Fund Vendor
Meade Electric Co. Inc.
Total: 041- Motor Fuel Tax Fund
2011 Traffic Signal Maintenance
Amount
1,976.00
$ 11,507.04
042 - Community Development Block Grant
CNM Development
CDBG SFR final paymentfor 1808 Cree
$
2,416.00
Everbank Commercial Finance, Inc.
Rental S /23/11
16.80
Federal Express Corp
CDBG Shipping
28.37
GE Capital
Service 4/15/11- 5/14/11
198.94
The Lead Inspectors, USA Inc
1804 Camp McDonald
275.00
The Lead Inspectors, USA Inc
229 Hatlen CDBG SFR Lead Inspection
275.00
The Lead Inspectors, USA Inc
300 S. Pine CDBG SFR Lead Inspection
275.00
Total: 042 - Community Development Block Grant
$
3,485.11
044 - DEA Shared Funds Fund
Midwest Commercial Fitness
StairMaster SM916 Stepmill
$
4,890.00
Total: 044 - DEA Shared Funds Fund
$
4,890.00
050 - Water and Sewer Fund
A Lamp Concrete
Retainage Release
$
2,926.90
Addison Building Material Co.
Maintenance & Repair Supplies
143.46
Addison Building Material Co.
Maintenance & Repair Supplies
107.64
Addison Building Material Co.
Credit
(25.56)
Alexander Chemical
Cylinder Rental 1st Quarter
216.00
American Landscaping Inc.
Landscape Restoration
13,887.00
American Waterworks Assoc.
Registration Fee
40.00
ASCO Services, Inc.
Emergency call out on ATS
450.00
AT & T
Service 4/16/11 - 5/15/11
277.17
Baxter & Woodman, Inc.
Engineering Services
22,984.75
Baxter & Woodman, Inc.
Professional Engineering
405.00
Baxter & Woodman, Inc.
Engineering Services
5,185.02
Baxter & Woodman, Inc.
Professional Engineering
2,096.62
Baxter & Woodman, Inc.
Application Development
4,939.50
Baxter & Woodman, Inc.
Application Development
7,450.00
Burns & Mcdonnell Engineering Co.
Professional Services
1,575.00
Century Cleaners
Uniform Cleaning
24.48
Century Cleaners
Uniform Cleaning
8.90
Century Cleaners
Uniform Cleaning
35.60
Century Cleaners
Uniform Cleaning
8.90
Century Cleaners
Uniform Cleaning
22.25
Century Cleaners
Uniform Cleaning
33.38
Century Cleaners
Uniform Cleaning
33.38
Century Cleaners
Uniform Cleaning
26.70
Dupage Topsoil Inc.
Pulverized Soil Delivery
510.00
East Jordan Ironworks
Maintenance & Repair Supplies
8,200.00
Elan Technologies Inc.
Sanitary Flow Monitoring
16,277.50
Exelon Corporation
Electrical Service Delivery
203.49
Exelon Corporation
Electrical Service Delivery
194.82
HBK Water Meter Service
Water Meter Repair Parts and Supplies
483.75
HBK Water Meter Service
Water Meters
635.00
HBK Water Meter Service
Water Meter Installation /Building Inspection /Meter Testing
1,061.20
HD Supply Waterworks, Ltd.
Hydrants
3,940.40
Homer Tree Care, Inc.
Tree Removal
3,038.00
Hy -Viz, Inc.
Water Hydrants
2,488.75
Jjs Global Ventures Inc
Maintenance & Repair Supplies
710.00
Joseph D. Foreman & Co.
Hydrants
3,225.55
Joseph D. Foreman & Co.
Credit
(2,000.00)
L & B Business Services Inc.
Maintenance & Repair Supplies
749.82
L & B Business Services Inc.
Maintenance and repair supplies
47.98
Lands' End Business Outfitters
Replacement garments for staff
266.22
Lands' End Business Outfitters
Replacement garments
22.70
Lechner and Sons
Uniform Rental & Cleaning
113.75
Lechner and Sons
Uniform Rental & Cleaning
113.75
Lyon Financial Services, Inc.
Usage 5/16/11
167.50
Madalyn Fortunato
Refund Final Utility Bill #660701
70.52
Marjorie Richter
Refund Final Utility Bill # 681801
40.14
Mary H Platt
Refund Overpayment Water Bill 768901
198.27
Page 5 of 7
VILLAGE OF MOUNT PROSPECT
List of Bills
April 28 - May 11, 2011
Fund Vendor
Description
$ 290.52
Amount
Matt Overeem
Safety Shoes
NICOR
99.99
Metron - Farnier, U.C.
Water Meter Repair Parts and Supplies
Petty Cash 4/1/11 - S /2/11
790.69
Metron - Farnier, L-C.
Water Meters
$ 621.29
1,757.41
Mid American Water of Wauconda, Inc.
Maintenance & Repair Supplies
Addison Building Material Co.
1,440.40
National Power Rodding Corp.
Sewer Maintenance
Vehicle Maintenance Supplies
3,100.00
Nextel Communications
Service 3/18/11- 4/17/11
132.00
633.70
NICOR
Natural Gas Consumption
Arlington Heights Ford
206.13
NICOR
Natural Gas Consumption
P -8 mirror
121.01
NICOR
Natural Gas Consumption
79.16
196.89
Northeastern III. Pub. Safety Trng.
Training
Arlington Heights Ford
75.00
Northwest Electrical Supply
Maintenance and repair supplies
Foglight bulbs
122.99
Proforma Customized Graphics
Open House and Water Conservation Supplies
34.72
397.50
Proforma Customized Graphics
Open House and Water Conservation Supplies
AT&T
314.00
Proforma Customized Graphics
Open House and Water Conservation Supplies
Shop supplies -nuts, bolts, washers, ties, tire valves, hose clam
442.50
Proforma Customized Graphics
Open House and Water Conservation Supplies
951.00
167.50
Proforma Customized Graphics
Open House and Water Conservation Supplies
Brad's Sales Company, Inc.
370.00
Proforma Customized Graphics
Open House and Water Conservation Supplies
Equipment Maintenance
240.00
Proforma Customized Graphics
Open House and Water Conservation Supplies
19.94
294.00
Red Wing Shoe Store
Safety Shoes
Hoskins Chevrolet, Inc.
152.99
Red Wing Shoe Store
Safety Shoes
Vehicle Maintenance Supplies
295.99
Red Wing Shoe Store
Safety Shoes
393.00
152.99
Suburban Laboratories, Inc.
Annual IEPA- Required Water Sample Testing
441.00
Terrace Supply Company
Maintenance Supplies
61.71
Thomas Parochelli
Refund Final Utility Bill #541803
53.53
U.S. Bancorp Equipment Finance, Inc.
Usage 5/20/11
137.50
UPS Store #707
Shipping Charges
26.98
USA Bluebook
Maintenance & Repair Supplies
1,030.90
Ziebell Water Service Products
Hydrant Supplies
691.60
Ziebell Water Service Products
Sprinkler system materials
1,360.40
Total: 050 - Water and Sewer Fund
$
118,786.50
051- Village Parking System Fund
Crystal Maintenance Services Corp.
Custodial Services
$
2,015.86
Total: 051 - Village Parking System Fund
$
2,015.86
052 - Parking System Revenue Fund
Crystal Maintenance Services Corp.
Custodial Services
$ 290.52
Dreisilker Electric Motors, Inc.
Maintenance and repair supplies
141.63
NICOR
Natural Gas Consumption
169.14
Petty Cash
Petty Cash 4/1/11 - S /2/11
20.00
Total: 052 - Parking System Revenue Fund
$ 621.29
060 - Vehicle Maintenance Fund
Addison Building Material Co.
Vehicle Maintenance Supplies
$ 16.67
Addison Building Material Co.
Vehicle Maintenance Supplies
46.41
Alpha Prime Communications
Equipment
132.00
American Messaging
Messaging Services
36.67
Arlington Heights Ford
Police car wheel & sensor
151.71
Arlington Heights Ford
P -8 mirror
124.00
Arlington Heights Ford
P -37 dr door hinges
79.16
Arlington Heights Ford
Passenger mirror assy
123.02
Arlington Heights Ford
Vehicle Maintenance Supplies
45.90
Arlington Heights Ford
Foglight bulbs
30.00
Arlington Power Equipment
Vehicle Maintenance Supplies
34.72
Arlington Power Equipment
Vehicle Maintenance Supplies
20.26
AT&T
Service 4/16/11 - 5/15/11
10.41
Barnes Group
Shop supplies -nuts, bolts, washers, ties, tire valves, hose clam
432.44
Bonnell Industries Inc.
Vehicle Maintenance Supplies
951.00
BP
Gas Purchased 4/20/11- Reference # 551977
36.60
Brad's Sales Company, Inc.
Shop rags
540.00
Dirtbusters Auto Detailing, Inc.
Equipment Maintenance
190.00
Grainger Inc.
Vehicle Maintenance Supplies
19.94
Hoskins Chevrolet, Inc.
Door hinge kits for GM pickups
146.25
Hoskins Chevrolet, Inc.
S-41 EVAP valve
24.05
Jackson - hirsh, Inc.
Vehicle Maintenance Supplies
61.04
Just Tires
Vehicle Maintenance Supplies
393.00
Page 6 of 7
VILLAGE OF MOUNT PROSPECT
List of Bills
April 28 - May 11, 2011
Fund Vendor
Mcmaster -Carr Supply Co.
Morton Grove Automotive
Municipal Fleet Managers Assoc
Napa- Heights Automotive Supply
Napa - Heights Automotive Supply
Napa - Heights Automotive Supply
Napa - Heights Automotive Supply
Nextel Communications
Parkside Auto Body Inc
Pomp's Tire Service, Inc.
Prairie International Truck Sales
Prairie International Truck Sales
Prairie International Truck Sales
Prairie International Truck Sales
Prairie International Truck Sales
Precision Service & Parts
Precision Service & Parts
Ronco Industrial Supply
Ronco Industrial Supply
Sauber Mfg. Co.
Solvent Systems Int'l. Inc.
Suburban Accents Inc
Vehicle Maintenance Program Inc.
West Side Tractor Sales
West Side Tractor Sales
Wholesale Direct Inc.
Zeigler Chevrolet - Schaumburg LLC
Total: 060 Vehicle Maintenance Fund
Vehicle Maintenance Supplies
Equipment Maintenance
Training
504 catalytic converter & gaskets.
Oil filters
S-41 rear sway bar links
Reflectors
Service 3/18/11 - 4/17/11
Equipment Maintenance
Vehicle Maintenance Supplies
Vehicle Maintenance Supplies
Vehicle Maintenance Supplies
Oil filters, 4558 coolant tank
Vehicle Maintenance Supplies
Led Brake lights
Vehicle Maintenance Supplies
Vehicle Maintenance Supplies
Vehicle Maintenance Supplies
Vehicle Maintenance Supplies
Equipment Maintenance
Equipment
Equipment Maintenance
Vehicle Maintenance Supplies
Vehicle Maintenance Supplies
Vehicle Maintenance Supplies
Vehicle Maintenance Supplies
Equipment Maintenance
Amount
50.38
125.00
40.00
233.93
47.52
48.76
98.00
242.24
263.20
1,752.80
214.50
136.76
453.94
159.84
340.92
87.78
660.06
191.30
191.82
623.00
300.00
16.00
151.90
40.88
333.05
253.33
559.50
063 - Risk Management Fund
Cannon Cochran Management Services, Inc.
High -Level Excess Liability Pool
Illinois Department of Employment Security
Total: 063 - Risk Management Fund
073 - Escrow Deposit Fund
Adam R.Panek
Capps Plumbing & Sewer Inc
Cox Decorative Concrete Inc
Design First Builders LLC
International Union of Operating Engineers
Lori L Schrolucke- Foster
NCPERS Group Life Ins.
NCPERS Group Life Ins.
Paul Bures
Rob Fabick
Sean Dorsey
Third District Circuit Court
Third District Circuit Court
Third District Circuit Court
Third District Circuit Court
Thomas A. Clinger
Total: 073 - Escrow Deposit Fund
Grand Total:
Liability Claims - April
May 2011 Contribution -1st Payment
Unemployment Benefits 1st Qtr 2011
Photography for Andler Retirement Party
Refund Escrow Permit # 11 -0397
Refund escrow Permit # 10 -0192
Refund Escrow Permit # 11 -0041
04/28/11 Payroll Checks
Refund Escrow Permit # 11 -0269
Premium for May 2011
Premium for May 2011
Andler Retirement Gift
Refund Escrow Permit # 10 -1090
Reimbursement for Andler Retirement Party
Bond Check 4/28/11
Bond Check 5/3/11
Bond Check 5/5/11
Bond Check 5/10/11
Videography Services for Andler Retirement
$ 11,261.66
$ 41,875.85
37,467.00
23,221.00
$ 102,563.85
$ 240.00
125.00
225.00
200.00
80.70
200.00
688.00
16.00
350.00
325.00
4,362.28
650.00
1,540.00
500.00
1,740.00
750.00
$ 11,991.98
$ 2,745,964.13
Page 7 of 7