HomeMy WebLinkAbout3. FINANCIAL REPORT AND BILLS 08/17/2010lk Mount Prospc
Village of Mount Prospect
Mount Prospect, Illinois
INTEROFFICE MEMORANDUM
TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES
FINANCE COMMISSION
FROM: FINANCE DIRECTOR
DATE: AUGUST 13, 2010
SUBJECT: MONTHLY FINANCIAL REPORT —JULY 2010
Attached hereto are the cash position and investment statements of the Village for the month ended
July 31, 2010. These statements provide a snapshot of the Village's cash position as of the month
end date noted and are intended to supplement the budget revenue and expenditure summary and
listing of bills you receive. The first statement presents the Village's cash position broken down by
governmental and enterprise funds and trust and agency funds. The second statement presents
the Village's cash position by fund type. The third statement presents the list of investments again
broken down by governmental and enterprise funds and trust and agency funds. It is important to
note that although we have included the trust and agency funds in the cash position report, these
funds are not accessible for Village operations. They are restricted for pension and escrow funding
only. Please read the summary that follows for further detail on the cash position of the Village.
Cash and Investment Position Report — All Funds (page 1)
This report provides a detail summary of cash and investments for the Village broken out by
governmental and enterprise funds and trust and agency funds. Governmental funds include the
General Fund, Special Revenue Funds, Debt Service Funds, Capital Project Funds and Internal
Service Funds. The Enterprise Funds consist of the Water /Sewer Fund and two (2) Parking Funds.
Trust funds include the Village's two public safety pensions (Police and Firefighters') while the
agency funds include the Escrow Deposit, Flexcomp Escrow, Special Service Area and Library
Bonds Escmw Funds The nianncit Fii inri Arrr intc fnr refi indahle rienn -,itg hP.1d by the?
Village to ensure completion of public improvements. The Flexcomp Escrow Fund accounts for
employee payroll deductions pursuant to a Section 125 flexible compensation plan. The Special
Service Area Fund and Library Bonds Escrow Fund accounts for the accumulation of monies for
debt service payments.
Governmental and Enterprise Funds - Cash and cash equivalents at June 30 were $27.9 million.
During July, cash receipts totaled $4,086,870.24. In addition investment income forthe month was
$5,678.72 and inflows due to Interfund activity generated $13,275.00. Reductions in cash and cash
equivalents during July totaled $6,928,503.47. Of this amount, payments to vendors were
$4,860,385.01, employee payroll and related expenses were $2,065,618.91 and other
disbursements were $2,499.55. Cash and cash equivalents at July 31 were $25.1 million.
There were no funds held in investments during the month of July. Funds were held in cash money
market accounts that currently earn competitive rates of interest.
Monthly Financial Report - August 2010
August 13, 2010
Page 2
Total cash and investments for Governmental and Enterprise Funds at June 30 were
$27,875,815.96. Cash and investments at July 31 totaled $25,053,136.36. This is a decrease of
$2,822,679.51.
Trust and Agency Funds - Cash and cash equivalents at June 30 were $4.9 million. During July,
cash receipts totaled $212,532.77. In addition investment income for the month was $106,774.87
and outflows due to interfund activity totaled $13,275.00. There was also a net decrease in cash
due to investment activities of $830,069.09. Reductions in cash and cash equivalents during July
totaled $638,774.82. Of this amount, payments to vendors were $167,378.53, employee payroll
and related expenses were $438,555.47, payments related to the flexible spending program totaled
$31,319.82. Other disbursements were $1,521.00. Cash and cash equivalents at July 31 were
$3,733,034.19 million.
Total investments at July 31 were $77,523,244.47, an increase of $930,847.19 from June 30, 2010.
There were unrealized investment gains of $100,778.10 and a transfer from cash of $1,312,169.06
that accounted for the change.
Total cash and investments for Trust and Agency Funds at June 30 were $81,488,242.74. Cash
and investments at July 31 totaled $81,256,278.66. This is a decrease for the month of
$231,964.08.
Summary of Cash Activity by Fund Type (page 2)
This report provides a breakdown of the cash activity for the month broken down by fund type. This
breakdown is useful in identifying where the activity (receipts and disbursements) is occurring.
There are times during the year when activity in certain funds such as the capital improvement and
special revenue funds is higher than normal. This will distort the financial picture of some of the
other components of the governmental funds such as the General Fund which tends to be more
level and predictable in terms of spending and receipt of revenue. Each month the report will
provide detail explanation on activity of the General Fund, the Village's primary operating fund. The
report will also provide additional information on fund types that experienced higher than normal
activity for the month. Each of these is highlighted below.
Gener _ -' r_.._ -� �__� __r _ _� e I a a I O(� +.+.I .J Tr_ 'I Al 010 Or,, n—i— li�w tench
General Fund – Cash and call I equivalents aL J une 30 totaled V j, i � i 1 vui n iy —Y, __
receipts totaled $2,463,854.76 and investment income was $3,222.53. Significant cash receipts
included sales taxes, state income tax and telecommunication tax.
Sales tax revenues for the month totaled $913,334. Of this amount, $823,455 was generated
from the 1 % state portion while $89,879 was generated from the .25% home rule portion. The
state portion showed an increase of 14.0% from last year same time. The home rule portion
also grew from the prior year by 13.2 %. The difference between the two sales tax sources in
their change from prior year is due to the tax being assessed on a different set of goods. Sales
taxes received in July are for April sales as there is a three -month lag in getting this distribution
from the state. For the months of February through August the increase from the prior year is
going to be skewed higher due to a large retailer being closed during this period for remodeling.
State income tax receipts for July totaled $712,673 and accounted for two months of receipts
(February and March). The state remains 4 months in arrears in remitting these taxes to the
Village. The total amount in arrears is $1.7 million.
H:WCCT \Treasurer's Report \2010 \Monthly Financial Report\Monthly Cash Position Report - July 2010.doc
Monthly Financial Report -August 2010
August 13, 2010
Page 3
Telecommunication tax receipts for July reflect April activity. Total receipts for the month were
$223,372. Year to date receipts are running 1.0% higher than 2009.
Disbursements from the General Fund for July included payments to vendors of $1,672,572.16 and
payments for employee wages and benefits of $1,662,581.65. Interfund transfers of $404,989.98
for health premiums and vehicle lease and maintenance payments were also made during July.
Cash and cash equivalents at July 31 were $3,865,370.82. There were no investments in the
General Fund at July 31.
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 July 31 there were no CD's placed at any bank.
This is due to the extremely low interest rates being offered. Money instead has been placed in
interest bearing money market accounts
Trust and Agency Funds - The investments for the trust and agency funds are made up of
certificates of deposits, fixed income investments and equity mutual funds. CD's (if any) held in the
Escrow Deposit Fund will generally have maturities of between 30 and 120 days. Most of the
reserves for this fund are invested in the more liquid money market account due to the nature of the
deposit. Escrow refunds are processed two times per month.
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
pvrtf^viiv ii 1 Ua8h tv i icip faiiiiiatc iiquidiiy ai Id tradii ig.
Investments in equities consist of mutual funds spread across various sectors (small, mid and large -
cap stocks) as well as investment philosophies (value, core and growth). The pension funds also
have a small portion of their portfolio invested in international stocks. Each year the investment mix
is evaluated for optimal diversification to meet the pension funds investment policy goals and
objectives. Below is a breakdown of how the pension fund portfolios are invested.
H:\ACCT \Treasurer's Report\2010 \Monthly Financial Report\Monthly Cash Position Report - July 2010.doc
Monthly Financial Report — August 2010
August 13, 2010
Page 4
Maturity Purchase Financial
Date Date Institution
POLICE PENSION FUND (710)
Various Various Wells Fargo
Various Various Various
Investment
Description
Wells Fargo Investments
Mutual Fund Investments
CUSIP/
Interest
Market
Acct #
Rate %
Value
Various
Various
21,130,924.79
Various
Various
17,185,687.56
38,316,612.35
FIRE PENSION FUND (720)
Various Various Wells Fargo
Various Various Various
Wells Fargo Investments
Mutual Fund Investments
TOTAL TRUST AND AGENCY FUND INVESTMENTS
Various Various 22,755,039.06
Various Various 16,451,593.06
39,206,632.12
S 77,523,244.47
Investment of the Village's pension funds is governed by an Investment Policy adopted by each
Pension Board.
Conclusion
As mentioned earlier, this cash position report is intended to provide a snapshot of the Village's
cash position as of a particular month end date. Over time, this report will be able to provide trend
information to help in cash management duties, maximizing investment earnings while ensuring
availability of funds to meet the Village's commitments. The cash position report will be provided to
the Village Board and Finance Commission on a monthly basis moving forward.
David O. Erb
Finance Director
H:\ACCT\Treasurer's Report\2010 \Monthly Financial Report \Monthly Cash Position Report - July 2010.doc
VILLAGE OF MOUNT PROSPECT
Preliminary Cash and Investment Position Report - All Funds
For the Month Ended July 31, 2010
GOVERNMENTAL AND ENTERPRISE FUNDS
Cash and Cash Total Cash and
Equivalents Investments Investments
Balance at June 30, 2010 $ 27,875,815.87 $ - $ 27,875,815.87
Cash receipts 4,086,870.24 4,086,870.24
Investment income 5,678.72 5,678.72
Transfers from investments to cash - - -
Transfers to investments from cash - - -
Interfund activity 13,275.00 13,275.00
Disbursements:
Accounts payable (4,860,385.01) (4,860,385.01)
Payroll (2,065,618.91) (2,065,618.91)
Other (2,499.55) (2,499.55)
Balance at July 31, 2010 $ 25,053,136.36 $ - $ 25,053,136.36
TR UST AND AGENCY FUNDS "
Cash and Cash
Equivalents
Balance at June 30, 2010 $ 4,895,845.46
Investments
Total Cash and
Investments
$ 76,592,397.28 $ 81,488,242.74
Cash receipts 212,532.77
Investment income (loss) 106,774.87 100,778.10
Transfers from investments to cash 482,099.97 (482,099.97)
Transfers to investments from cash (1,312,169.06) 1,312,169.06
Interf inr1 Mrtwihi ('i.S "97';; ('ji )
Disbursements:
Accounts payable
Payroll
Flex spending
Other
(167,378.53)
(438,555.47)
(31,319.82)
(1,521.00)
Balance at July 31, 2010
212,532.77
207,552.97
(167,378.53)
(438,555.47)
(31,319.82)
(1,521.00)
$ 3,733,034.19 $ 77,523,244.47 $ 81,256,278.66
* Assets are restricted in purpose and do not represent discretionary assets of the government.
1
F
U
W
IL
N
O
It
M
z
z
O
LL
O
W
a
J
J_
N
d
O
�o
cN
7
LL M
'- 0
U
Q W
L
(� L
U C
0
o �
m
L
E..
E O
(ten LL
M
Z
D
LL
}
U
Z
W
Q
Q
U)
U)
D
F
2
M rmr` [00En NC0 V
w
U)N
f
N
M O U) m O O U) M M M
M M m m 0 0 0 i V M
U)
O
co U)
M O
V
V
O
O
J4
U) O U) m U) `-' N M
co co
V
U) V V O O M t�
m N
N
Q
H
m�NN V r--
U)
U) PI-
co
m
O
n m m O N
...
c0
CO M
N
Q
H
n N r V M U) O
(-
00 (D
U)
M
co .�
N
V (
(�
O_
fR
W
CO }
^O -0 OOa O
c
ce
U
+ + +
to Ci
+
N p
NEgM O
W
V N
U)
U)
Z
W Q
0) r v O
to
CM
J
LL
E.N) ..�
r
�
O Q
6%
wil
CO N r 1- (D I- V
m
ED N
1-
(O
U)
I-(DOmO V C
6 N m 0) 0) , + + U)
M
LO
oO(D
+ no
V
ao
m c0 U) m (D U') M
m
U) c0
V
M
Q U O
M N h O r U) M
m N
N
P
L LI
co r
I-
LD f-
M
O
MOZ
U)r� V M va
v
ODD(D
0
O
U " LL Lu
M
N
r
LL
`-'
V El)
r.-
6-1
cn
I V N 00
c0
w
c")
Q w
wU)
mNh + OU) + Mo
U) O co U) m CD U)
Go
M 0 0 (q N V mM
M
0
+ +
cG
O
OD'
r a r ( (
N
O
U` W�
co O Ooc
O
LL
V v V
In
N
Q Z
N
N
0
w
U)
0
r O M U) m V
c0
c0
O
Z
Q�
r N N N M
r N N
O
r
zLL
0)) CC)
rmO : V 1�O
ao
w
cl) r
P.
W
00 N V _� O
r O
M
c' )
Z�
....m
O
O
O_
U)
d)
w
U) M V W W W
I.- L)O m 00 C>
CD
o
cn
O
O m + + 1-: N m M
V
+ +
V
m N N V C D O O
O
m
ap
V cON v_m rn
m
w Z
c ao M cl) m
r=
P.
WU-
Ow LO Lo cv U
m
w,
z LL
M v
V
al
w
O M U)
M
co
O)
M M CO V
r - ° v_
m
co
FUp u N D
W
�
W z
QO
V N c
M
M
U a L
L r
v
v
W
M N V N
n
M
U
Of m
r N V„ + . „ V
U) m M V
00 V r V
M
co
O
+ +
co
O
W o
E O N r m
O
O
Z
m t- m
�
M
W
oo
~ LL
!`
Lu
r- m EEDD co OLq
U
r
h
co mM
M
w
M
azo
0m�
V M f` O r
V
V
w Z
m
f V
W
W U-
O V M
�
6%
d�
co cm
Z
J
O 0 0 W
m V N m N N
co
O
+
r
LL
T C-4 Go Go
�iJ
M
cn
J
w
0) 00 mv_
p-
M O `-'
U)
m
V O O
UD (D
ED
cc
co
w
Z
V R
O N
co
M
W
O
U
N
y
F
EA
Z
U) v
c
Z N cc
I-
J C N
Q N. N— C
N N
W
>
> E a o o
r
N EE
Z
C7N N E r
c N O O_ N
N N ti
N
Z
o f
U) N 8 C 2 4 N .
U
F - A C C
N
Q O N N N N
(6
W
Q
N
cf p) C
N
v
go E2
'C N N N
F V LL
d E N m C E
= C y) 0 M2 7 D 7 7
CD
C
W
C
J
y O)N N C C �da�a
'O
Q N N> N lc +,,, N p) Mn N
C
N j
O
O
2
It
VILLAGE OF MOUNT PROSPECT
STATEMENT OF INVESTMENTS
As of July 31, 2010
GOVERNMENTAL AND ENTERPRISE FUNDS
Maturity Purchase Financial Investment CUSIP/ Interest Market Weighted
Date Date Institution Description Acct # Rate % Value Avg Yield
As of July 31, 2010, there were no certificates of deposit held by the Governmental and Enterprise Funds.
TRUST AND AGENCY FUNDS *
Maturity Purchase Financial
Investment
CUSIP/
Interest
Market
Weighted
Date Date Institution
Description
Acct #
Rate %
Value
Avg Yield
POLICE PENSION FUND (710)
Various Various Wells Fargo
Wells Fargo Investments
Various
Various
21,130,924.79
Various Various Various
Mutual Fund Investments
Various
Various
17,185,687.56
38,316,61235
FIRE PENSION FUND (720)
Various Various Wells Fargo
Wells Fargo Investments
Various
Various
22,755,039.06
Various Various Various
Mutual Fund Investments
Various
Various
16,451,593.06
39,206,632.12
TOTAL TRUST AND AGENCY FUND INVESTMENTS
$ 77,523,244.47
* Assets are restricted in purpose and do not represent discretionary assets of the government.
3
VILLAGE OF MOUNT PROSPECT
BUDGET REVENUE
EXPENDITURE SUMMARIES
January 1— July 31, 2010
08/12/2010 VILLAGE OF MOUNT PROSPECT 7 Months ( 58.3%- ) Completed
08:58:26 5 Months ( 41.6% ) Remaining
Budget Revenue Summary
01 /01 /10 - 07/31/10
1
Cur Mo
Y -T -D
2010
Unreceived Unreceived
Received
Received
Budget
Balance
Percent
REVENUE BY CLASSIFICATION
PROPERTY TAXES
47,436
7,768,806
14,999,000
7,230,194
48.2
OTHER TAXES
808,784
6,139,780
15,665,000
9,525,220
60.8
LICENSES, PERMITS & FEES
87,475
2,247,433
3,487,000
1,239,567
35.5
INTERGOVERMENT REV.
1,772,163
6,227,036
18,102,647
11,875,611
65.6
CHARGES FOR SERVICE
1,618,731
11,305,382
21,970,880
10,665,498
48.5
FINES AND FORFEITS
37,017
300,688
704,000
403,312
57.3
INVESTMENT INCOME
262,853
- 120,817
5,696,250
5,817,067
102.1
REIMBURSEMENTS
23,342
183,850
467,000
283,150
60.6
OTHER REVENUE
222,309
3,459,498
7,023,160
3,563,662
50.7
OTHER FINANCING SOURCES
443
1,526
1,023,505
1,021,979
99.9
Total All Funds
4,880,553
37,513,182
89,138,442
51,625,260
57.9
REVENUE BY FUND
GENERAL FUND
2,507,137
17,321,542
40,691,100
23,369,558
57.4
REFUSE DISPOSAL FUND
117,692
2,228,647
4,038,500
1,809,853
44.8
MOTOR FUEL TAX FUND
115,655
741,298
1,836,500
1,095,202
59.6
LAW ENFORCEMENT BLOCK GRANT
0
0
0
0
COMMUNITY DEVELPMNT BLOCK GRNT
600
204,921
565,447
360,526
63.8
ASSET SEIZURE FUND
3,001
6,625
6,000
-625
-10.4
DEA SHARED FUNDS FUND
6
27
1,500
1,473
98.2
DUI FINE FUND
1,027
6,515
20,500
13,985
68.2
FOREIGN FIRE TAX BOARD FUND
16,221
20,522
35,500
14,978
42.2
SERIES 1987A B &I, PW FACILITY
0
0
0
0
SERIES 2001 B &I, VILLAGE HALL
1
1
379,000
378,999
100.0
SERIES 2003 B &I, VILLAGE HALL
3,035
499,120
904,000
404,880
44.8
SERIES 2009 B &I, FD /PW
1,374
228,487
414,000
185,513
44.8
2009B B &I, FD /PW
358
55,068
0
- 55,068
2009C B &I, FD /PW
261
65,900
0
- 65,900
SERIES 1999 B &I, TIF
0
0
0
0
SERIES 1998A B &I, FLOOD
0
0
0
0
SERIES 1998C B &I, TIF
0
0
0
0
IEPA FLOOD CONTROL LOANS B &I
82,338
296,497
1,140,708
844,211
74.0
SERIES 2000 B &I, FLOOD CONTROL
0
0
C
SERIES 2002B B& I, FLOOD
0
0
0
0
CAPITAL IMPROVEMENT FUND
84,289
315,154
1,421,500
1,106,346
77.8
SERIES 2009 CONST FUND
0
24,644
1,124,505
1,099,861
97.8
DOWNTOWN REDEVLPMNT CONST
- 11,247
1,229,507
2,567,000
1,337,493
52.1
STREET IMPROVEMENT CONST FUND
118,371
889,307
1,717,600
828,293
48.2
FLOOD CONTROL CONST FUND
8,488
87,835
198,792
110,957
55.8
WATER AND SEWER FUND
753,901
5,775,096
12,225,500
6,450,404
52.8
VILLAGE PARKING SYSTEM FUND
11,312
66,580
152,000
85,420
56.2
PARKING SYSTEM REVENUE FUND
14,375
78,787
159,500
80,713
50.6
VEHICLE MAINTENANCE FUND
137,362
961,668
1,654,192
692,524
41.9
VEHICLE REPLACEMENT FUND
7,051
61,584
238,200
176,616
74.1
COMPUTER REPLACEMENT FUND
121
821
12,000
11,179
93.2
RISK MANAGEMENT FUND
536,367
3,899,730
6,865,098
2,965,368
43.2
POLICE PENSION FUND
201,184
1,206,548
5,585,500
4,378,952
78.4
FIRE PENSION FUND
170,273
1,240,749
5,184,300
3,943,551
76.1
SSA #6 GEORGE /ALBERT B &I
0
2
0
-2
GENERAL FIXED ASSETS ACCT GP
0
0
0
0
1
08/12/2010 VILLAGE OF MOUNT PROSPECT
7 Months
( 58.3% )
Completed
08:58:26
Budget Revenue Summary
5 Months
( 41.6g )
Remaining
01 /01 /10 - 07/31/10
Cur Mo Y -T -D
2010
Unreceived
Unreceived
Received Received
Budget
Balance
Percent
Total All Funds 4,880,553 37,513,182
89,138,442
51,625,260
57.9
2
08/12/2010
5,984,275
7 Months ( 58.3% )
Completed
08:58:55 VILLAGE OF MOUNT
PROSPECT 5 Months ( 41.6t )
Remaining
FRRBRR03
Budget Revenue by Category
within
Fund Summary
84,972
SUMO21
3,426,000
1,191,765
34.8
01 /01 /10 - 07/31/10
4,846,164
15,240,100
Cur Mo
Y -T -D
2010 Unreceived
Unreceived
Received
Received
Budget Balance
Percent
GENERAL FUND
40 PROPERTY TAXES
41 OTHER TAXES
42 LICENSES, PERMITS & FEES
43 INTERGOVERMENT REV.
44 CHARGES FOR SERVICE
45 FINES AND FORFEITS
46 INVESTMENT INCOME
47 REIMBURSEMENTS
48 OTHER REVENUE
49 OTHER FINANCING SOURCES
TOTAL GENERAL FUND
REFUSE DISPOSAL FUND
40 PROPERTY TAXES
44 CHARGES FOR SERVICE
46 INVESTMENT INCOME
48 OTHER REVENUE
TOTAL REFUSE DISPOSAL FUND
MOTOR FUEL TAX FUND
43 INTERGOVERMENT REV.
46 INVESTMENT INCOME
47 REIMBURSEMENTS
TOTAL MOTOR FUEL TAX FUND
LAW ENFORCEMENT BLOCK GRANT
43 INTERGOVERMENT REV.
46 INVESTMENT INCOME
TOTAL LAW ENFORCEMENT BLOCK GRANT
COMMUNITY DEVELPMNT BLOCK GRNT
43 INTERGOVERMENT REV.
46 INVESTMENT INCOME
48 OTHER REVENUE
TOTAL COMMUNITY DEVELPMNT BLOCK GRNT
ASSET SEIZURE FUND
45 FINES AND FORFEITS
46 INVESTMENT INCOME
TOTAL ASSET SEIZURE FUND
DEA SHARED FUNDS FUND
45 FINES AND FORFEITS
46 INVESTMENT INCOME
36,760
5,984,275
11,575,000
5,590,725
48.3
504,607
2,940,177
7,576,000
4,635,823
61.2
84,972
2,234,235
3,426,000
1,191,765
34.8
1,658,458
4,846,164
15,240,100
10,393,936
68.2
138,905
765,655
1,640,000
874,345
53.3
32,996
274,900
642,000
367,100
57.2
3,222
23,308
130,000
106,692
82.1
19,514
136,343
296,000
159,657
53.9
27,260
114,959
166,000
51,041
30.7
443
1,526
0
-1,526
2,507,137
17,321,542
40,691,100
23,369,558
57.4
5,711
957,183
1,731,000
773,817
44.7
100,228
1,213,673
2,151,000
937,327
43.6
128
741
22,500
21,759
96.7
11,625
57,050
134,000
76,950
57.4
117,692
2,228,647
4,038,500
1,809,853
44.8
111,605
707,603
1,675,000
967,397
57.8
222
926
1,500
574
38.3
3,828
32,769
160,000
127,231
79.5
115,655
741,298
1,836,500
1,095,202
59.6
0
0
0
0
0
0
0
0
0
0
0
0
600
154,411
515,447
361,036
70.0
0
0
0
0
0
50,510
50,000
-510
-1.0
600
204,921
565,447
360,526
63.8
2,995
6,591
5,000
-1,591
-31.8
6
34
1,000
966
96.6
3,001
6,625
6,000
-625
-10.4
0
0
1,000
1,000
100.0
6
27
500
473
94.6
1
08/12/2010
6,512
20,000
7 Months ( 58.3 ) Completed
08:58:55
VILLAGE OF MOUNT
PROSPECT
5 Months ( 41.6% ) Remaining
FRRBRR03
99.4
1,027
6,515
SUMO21 Budget
Revenue by Category
within
Fund Summary
20,514
01 /01 /10 - 07/31/10
14,486
41.4
Cur Mo
Y -T -D
2010 Unreceived Unreceived
492
Received
Received
Budget Balance Percent
TOTAL DEA SHARED FUNDS FUND
6
27
1,500 1,473 98.2
DUI FINE FUND
45 FINES AND FORFEITS
46 INVESTMENT INCOME
TOTAL DUI FINE FUND
FOREIGN FIRE TAX BOARD FUND
41 OTHER TAXES
46 INVESTMENT INCOME
TOTAL FOREIGN FIRE TAX BOARD FUND
SERIES 1987A B &I, PW FACILITY
40 PROPERTY TAXES
46 INVESTMENT INCOME
TOTAL SERIES 1987A B &I, PW FACILITY
SERIES 2001 B &I, VILLAGE HALL
40 PROPERTY TAXES
46 INVESTMENT INCOME
49 OTHER FINANCING SOURCES
TOTAL SERIES 2001 B &I, VILLAGE HALL
SERIES 2003 B &I, VILLAGE HALL
40 PROPERTY TAXES
46 INVESTMENT INCOME
49 OTHER FINANCING SOURCES
TOTAL SERIES 2003 B &I, VILLAGE HALL
SERIES 2009 B &I, FD /PW
40 PROPERTY TAXES
46 INVESTMENT INCOME
TOTAL SERIES 2009 B &I, FD /PW
2009B B &I, FD /PW
40 PROPERTY TAXES
46 INVESTMENT INCOME
49 OTHER FINANCING SOURCES
TOTAL 2009B B &I, FD /PW
2009C B &I, FD /PW
40 PROPERTY TAXES
43 INTERGOVERMENT REV.
46 INVESTMENT INCOME
1,026
6,512
20,000
13,488
67.4
1
3
500
497
99.4
1,027
6,515
20,500
13,985
68.2
16,218
20,514
35,000
14,486
41.4
3
8
500
492
98.4
16,221
20,522
35,500
14,978
42.2
0
0
0
0
0
0
0
0
0
0
0
0
0
0
378,000
378,000
100.0
1
1
1,000
999
99.9
0
0
0
0
1
1
379,000
378,999
100.0
2,976
498,855
902,000
403,145
44.7
59
265
2,000
1,735
86.8
0
0
0
0
3,035
499,120
904,000
404,880
44.8
1,372
228,434
413,000
184,566
44.7
2
53
1,000
947
94.7
1,374
228,487
414,000
185,513
44.8
357
55,049
0
- 55,049
1
19
0
-19
0
0
0
0
358
55,068
0
- 55,068
260
45,010
0
- 45,010
0
20,872
0
- 20,872
1
18
0
-18
2
08/12/2010
261
7 Months ( 58.3% )
Completed
08:58:55 VILLAGE OF MOUNT
PROSPECT 5 Months ( 41.60 >
Remaining
FRRBRR03
Budget Revenue by Category
within
Fund Summary
SUMO21
41 OTHER TAXES
0
0
01 /01 /10 - 07/31/10
0
Cur Mo
Y -T -D
2010 Unreceived
Unreceived
Received
Received
Budget Balance
Percent
TOTAL 2009C B &I, FD /PW
261
65,900
0
- 65,900
SERIES 1999 B &I, TIF
41 OTHER TAXES
0
0
0
0
46 INVESTMENT INCOME
0
0
0
0
TOTAL SERIES 1999 B &I, TIF
0
0
0
0
SERIES 1998A B &I, FLOOD
41 OTHER TAXES
0
0
0
0
46 INVESTMENT INCOME
0
0
0
0
TOTAL SERIES 1998A B &I, FLOOD
0
0
0
0
SERIES 1998C B &I, TIF
41 OTHER TAXES
0
0
0
0
46 INVESTMENT INCOME
0
0
0
0
TOTAL SERIES 1998C B &I, TIF
0
0
0
0
IEPA FLOOD CONTROL LOANS B &I
41 OTHER TAXES
82,284
296,285
1,140,708
844,423
74.0
46 INVESTMENT INCOME
54
212
0
-212
TOTAL IEPA FLOOD CONTROL LOANS B &I
82,338
296,497
1,140,708
844,211
74.0
SERIES 2000 B &I, FLOOD CONTROL
41 OTHER TAXES
0
0
0
0
46 INVESTMENT INCOME
0
0
0
0
TOTAL SERIES 2000 B &I, FLOOD CONTROL
0
0
0
0
SERIES 2002B B &I, FLOOD
41 OTHER TAXES
0
0
0
0
49 OTHER FINANCING SOURCES
0
0
0
0
TOTAL SERIES 2002B B &I, FLOOD
0
0
0
0
CAPITAL IMPROVEMENT FUND
41 OTHER TAXES
82,665
297,659
1,146,000
848,341
74.0
43 INTERGOVERMENT REV.
1,500
7,657
264,000
256,343
97.1
46 INVESTMENT INCOME
124
628
11,500
10,872
94.5
47 REIMBURSEMENTS
0
0
0
0
48 OTHER REVENUE
0
9,210
0
-9,210
49 OTHER FINANCING SOURCES
0
0
0
0
TOTAL CAPITAL IMPROVEMENT FUND
84,289
315,154
1,421,500
1,106,346
77.8
SERIES 2009 CONST FUND
43 INTERGOVERMENT REV.
0
20,000
150,000
130,000
86.7
46 INVESTMENT INCOME
0
4,644
1,000
-3,644
-364.4
48 OTHER REVENUE
0
0
0
0
3
08/12/2010 7 Months ( 58.3t ) Completed
08:58:55 VILLAGE OF MOUNT PROSPECT 5 Months ( 41.6% > Remaining
FRRBRR03
SUMO21 Budget Revenue by Category within Fund Summary
01 /01 /10 - 07/31/10
4
Cur Mo
Received
Y -T -D
Received
2010
Budget
Unreceived Unreceived
Balance Percent
49 OTHER FINANCING SOURCES
0
0
973,505
973,505
100.0
TOTAL SERIES 2009 CONST FUND
0
24,644
1,124,505
1,099,861
97.8
DOWNTOWN REDEVLPMNT CONST
41 OTHER TAXES
- 11,625
1,227,894
2,556,000
1,328,106
52.0
46 INVESTMENT INCOME
378
1,613
11,000
9,387
85.3
47 REIMBURSEMENTS
0
0
0
0
48 OTHER REVENUE
0
0
0
0
49 OTHER FINANCING SOURCES
0
0
0
0
TOTAL DOWNTOWN REDEVLPMNT CONST
- 11,247
1,229,507
2,567,000
1,337,493
52.1
STREET IMPROVEMENT CONST FUND
41 OTHER TAXES
115,776
470,100
1,506,000
1,035,900
68.8
43 INTERGOVERMENT REV.
0
413,250
210,600
- 202,650
-96.2
46 INVESTMENT INCOME
70
70
1,000
930
93.0
47 REIMBURSEMENTS
0
0
0
0
48 OTHER REVENUE
2,525
5,887
0
-5,887
TOTAL STREET IMPROVEMENT CONST FUND
118,371
889,307
1,717,600
828,293
48.2
FLOOD CONTROL CONST FUND
41 OTHER TAXES
7,595
27,348
105,292
77,944
74.0
42 LICENSES, PERMITS & FEES
893
3,408
45,000
41,592
92.4
43 INTERGOVERMENT REV.
0
57,079
47,500
-9,579
-20.2
46 INVESTMENT INCOME
0
0
1,000
1,000
100.0
TOTAL FLOOD CONTROL CONST FUND
8,488
87,835
198,792
110,957
55.8
WATER AND SEWER FUND
41 OTHER TAXES
4,051
833,829
1,500,000
666,171
44.4
42 LICENSES, PERMITS & FEES
1,610
9,790
16,000
6,210
38.8
44 CHARGES FOR SERVICE
747,111
4,910,662
10,596,000
5,685,338
53.7
46 INVESTMENT INCOME
204
664
92,500
91,836
99.3
47 REIMBURSEMENTS
0
9,450
1,000
-8,450
-845.0
48 OTHER REVENUE
925
10,701
20,000
9,299
46.5
49 OTHER FINANCING SOURCES
0
0
0
0
TOTAL WATER AND SEWER FUND
753,901
5,775,096
12,225,500
6,450,404
52.8
VILLAGE PARKING SYSTEM FUND
41 OTHER TAXES
3,246
11,688
45,000
33,312
74.0
42 LICENSES, PERMITS & FEES
0
0
0
0
44 CHARGES FOR SERVICE
8,051
54,850
106,000
51,150
48.3
46 INVESTMENT INCOME
15
42
1,000
958
95.8
TOTAL VILLAGE PARKING SYSTEM FUND
11,312
66,580
152,000
85,420
56.2
PARKING SYSTEM REVENUE FUND
41 OTHER TAXES
3,967
14,286
55,000
40,714
74.0
44 CHARGES FOR SERVICE
10,398
64,479
104,000
39,521
38.0
46 INVESTMENT INCOME
10
22
500
478
95.6
4
08/12/2010
3,290,896
7 Months ( 58.3a )
Completed
08:58:55 VILLAGE OF MOUNT
PROSPECT 5 Months ( 41.6W )
Remaining
FRRBRR03
29,707
94.3
0
Budget Revenue by Category
within
Fund Summary
47.1
SUMO21
601,753
1,172,860
571,107
01 /01 /10 - 07/31/10
536,367
3,899,730
Cur Mo
Y -T -D
2010 Unreceived
Unreceived
Received
Received
Budget Balance
Percent
TOTAL PARKING SYSTEM REVENUE FUND
VEHICLE MAINTENANCE FUND
44 CHARGES FOR SERVICE
46 INVESTMENT INCOME
48 OTHER REVENUE
TOTAL VEHICLE MAINTENANCE FUND
VEHICLE REPLACEMENT FUND
44 CHARGES FOR SERVICE
45 FINES AND FORFEITS
46 INVESTMENT INCOME
48 OTHER REVENUE
49 OTHER FINANCING SOURCES
TOTAL VEHICLE REPLACEMENT FUND
COMPUTER REPLACEMENT FUND
44 CHARGES FOR SERVICE
46 INVESTMENT INCOME
TOTAL COMPUTER REPLACEMENT FUND
RISK MANAGEMENT FUND
44 CHARGES FOR SERVICE
46 INVESTMENT INCOME
47 REIMBURSEMENTS
48 OTHER REVENUE
TOTAL RISK MANAGEMENT FUND
POLICE PENSION FUND
40' INVESTMENT INCOME
48 OTHER REVENUE
TOTAL POLICE PENSION FUND
FIRE PENSION FUND
46 INVESTMENT INCOME
48 OTHER REVENUE
TOTAL FIRE PENSION FUND
SSA #6 GEORGE /ALBERT B &I
46 INVESTMENT INCOME
TOTAL SSA #6 GEORGE /ALBERT B &I
GENERAL FIXED ASSETS ACCT GP
47 REIMBURSEMENTS
49 OTHER FINANCING SOURCES
14,375 78,787 159,500
137,288 961,009 1,647,442
74 534 6,750
0 125 0
137,362 961,668 1,654,192
6,308 44,158
0 12,685
743 4,741
0 0
0 0
7,051 61,584
0
121
0
821
821
75,700
36,000
76,500
0
50,000
238,200
0
12,000
12,000
80,713 50.6
686,433 41.7
6,216 92.1
-125
692,524 41.9
31,542 41.7
23,315 64.8
71,759 93.8
0
50,000 100.0
176,616 74.1
0
11,179 93.2
11,179 93.2
470,442
3,290,896
5,650,738
2,359,842
41.8
232
1,793
31,500
29,707
94.3
0
5,288
10,000
4,712
47.1
65,693
601,753
1,172,860
571,107
48.7
536,367
3,899,730
6,865,098
2,965,368
43.2
14
-135,310
2,63c 500
2,770,810
1
61,008
1,341,858
2,950,000
1,608,142
54.5
201,184
1,206,548
5,585,500
4,378,952
78.4
117,000
- 26,696
2,654,000
2,680,696
101.0
53,273
1,267,445
2,530,300
1,262,855
49.9
170,273
1,240,749
5,184,300
3,943,551
76.1
0
2
0
-2
0
2
0
-2
0
0
0
0
0
0
0
0
5
08 /12/2010 7 Months ( 58.3% ) Completed
08:58:55 VILLAGE OF MOUNT PROSPECT 5 Months ( 41.6% ) Remaining
FRRBRR03
SUMO21 Budget Revenue by Category within Fund Summary
01 /01 /10 - 07/31/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
TOTAL GENERAL FIXED ASSETS ACCT GP 0
MOUNT PROSPECT LIBRARY FUND
49 OTHER FINANCING SOURCES 0
TOTAL MOUNT PROSPECT LIBRARY FUND 0
0 0
0 9,715,689
0 9,715,689
0
9,715,689 100.0
9,715,689 100.0
6
08/12/2010 7 Months ( 58.3e ) Completed
VILLAGE OF MOUNT PROSPECT
08:57:23 5 Months ( 41.6t ) Remaining
Budget Expenditure Summary
01 /01 /10 - 07/31/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
Expended Expended Budget Balance Percent
EXPENDITURE BY CLASSIFICATION
PERSONAL SERVICES
3,052,540
15,181,091
27,253,599
12,072,508
44.3
EMPLOYEE BENEFITS
653,858
5,833,686
11,075,849
5,242,163
47.3
OTHER EMPLOYEE COSTS
23,005
162,020
461,274
299,254
64.9
PENSION BENEFITS
553,272
3,782,561
6,404,900
2,622,339
40.9
CONTRACTUAL SERVICES
1,390,024
8,228,778
16,981,174
8,752,396
51.5
UTILITIES
62,313
269,139
631,674
362,535
57.4
INSURANCE
697,821
3,977,403
7,175,232
3,197,829
44.6
COMMODITIES & SUPPLIES
95,082
859,597
1,727,411
867,814
50.2
OTHER EXPENDITURES
1,119,621
1,238,448
2,628,150
1,389,702
52.9
LAND IMPROVEMENTS
0
0
76,065
76,065
100.0
BUILDING IMPROVEMENTS
67,208
2,591,981
1,260,658
- 1,331,323
-105.6
OFFICE EQUIPMENT
2,346
126,006
488,343
362,337
74.2
MOBILE EQUIPMENT
75,688
414,884
810,000
395,116
48.8
OTHER EQUIPMENT
60,134
550,377
3,108,636
2,558,259
82.3
DISTRIBUTION SYSTEMS
82,571
230,553
2,870,346
2,639,793
92.0
INFRASTRUCTURE
84,930
1,458,937
3,509,015
2,050,078
58.4
BOND PRINCIPAL
17,482
273,553
1,271,204
997,651
78.5
INTEREST EXPENSE
2,162
558,701
1,053,076
494,375
46.9
BANK AND FISCAL FEES
300
1,178
1,600
422
26.4
INTERFUND TRANSFERS
0
0
0
0
OTHER FINANCING USES
0
0
0
0
Total All Funds
8,040,357
45,738,893
88,788,206
43,049,313
48.5
EXPENDITURE BY FUND
GENERAL FUND
3,785,974
22,133,203
41,145,530
19,012,327
46.2
REFUSE DISPOSAL FUND
348,072
2,194,757
4,240,941
2,046,184
48.2
MOTOR FUEL TAX FUND
29,425
1,205,333
1,736,302
530,969
30.6
LAW ENFORCEMENT BLOCK GRANT
0
0
0
0
COMMUNITY DEVELPMNT BLOCK GRNT
28,505
212,792
565,447
352,655
62.4
ASSET SEIZURE FUND
1,000
6,118
2,000
-4,118
-205.9
DEA SHARED FUNDS FUND
2,514
2,514
1,000
-1,514
-151.4
DUI FINE FUND
0
343
1,500
1,157
77.1
FOREIGN FIRE TAX BOARD FUND
9,480
28,946
15,500
- 13,446
-86.7
SERIES 1987A B &I, PW FACILITY
0
0
0
0
SERIES 2001 B &I, VILLAGE HALL
0
150
382,203
382,053
100.0
SERIES 2003 B &I, VILLAGE HALL
300
191,628
912,658
721,030
79.0
SERIES 2009 B &I, FD /PW
0
209,059
417,663
208,604
49.9
2009B B &I, FD /PW
0
46,640
0
- 46,640
2009C B &I, FD /PW
0
59,635
0
- 59,635
SERIES 1999 B &I, TIF
0
0
0
0
SERIES 1996A B &I, FLOOD
0
0
0
0
SERIES 1998A B &I, FLOOD
0
0
0
0
SERIES 1998C B &I, TIF
0
0
0
0
IEPA FLOOD CONTROL LOANS B &I
19,644
326,320
613,356
287,036
46.8
SERIES 2000 B &I, FLOOD CONTROL
0
0
0
0
CAPITAL IMPROVEMENT FUND
59,382
489,796
2,130,265
1,640,469
77.0
SERIES 2009 CONST FUND
82,364
2,918,393
2,183,633
- 734,760
-33.6
DOWNTOWN REDEVLPMNT CONST
1,136,241
1,269,151
2,736,500
1,467,349
53.6
STREET IMPROVEMENT CONST FUND
88,417
455,877
1,575,880
1,120,003
71.1
FLOOD CONTROL CONST FUND
0
5,266
161,425
156,159
96.7
WATER AND SEWER FUND
954,636
4,776,444
13,549,749
8,773,305
64.7
8
08/12/2010
VILLAGE OF MOUNT PROSPECT
7 Months
( 58.3% ) Completed
08 :57:23
5 Months
( 41.60 ) Remaining
Budget Expenditure
Summary
01/01/10 - 07/31/10
Cur Mo
Y -T -D
2010
Unexpended Unexpended
Expended
Expended
Budget
Balance Percent
VILLAGE PARKING SYSTEM FUND
7,066
52,080
175,098
123,018 70.3
PARKING SYSTEM REVENUE FUND
11,445
76,234
174,597
98,363 56.3
VEHICLE MAINTENANCE FUND
178,140
1,009,194
1,814,711
805,517 44.4
VEHICLE REPLACEMENT FUND
75,688
414,884
810,000
395,116 48.8
COMPUTER REPLACEMENT FUND
1,326
108,155
206,050
97,895 47.5
RISK MANAGEMENT FUND
670,851
3,788,617
6,872,398
3,083,781 44.9
POLICE PENSION FUND
289,128
1,945,034
3,242,300
1,297,266 40.0
FIRE PENSION FUND
260,759
1,812,330
3,121,500
1,309,170 41.9
SSA #6 GEORGE /ALBERT B &I
0
0
0
0
GENERAL FIXED ASSETS ACCT GP
0
0
0
0
GENERAL LONG -TERM DEBT ACCT
GP 0
0
0
0
Total All Funds
8,040,357
45,738,893
88,788,206
43,049,313 48.5
08/12/2010 7 Months ( 58.30 ) Completed
08:59:28 VILLAGE OF MOUNT PROSPECT 5 Months ( 41.6% ) Remaining
FRRDBR01
SUM 031 Department Budget Expenditure Summary
01 /01 /10 - 07/31/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
NON - DEPARTMENTAL Expended Expended Budget Balance Percent
PROGRAM TOTALS
00 ADMINISTRATION
0
0
0 0
Totals
0
0
0 0
EXPENDITURE CLASSIFICATION
72 INTEREST EXPENSE
0
0
0 0
Totals
0
0
0 0
SOURCE OF FUNDS
930 GENERAL LONG -TERM DEBT ACCT GP
0
0
0 0
Totals
0
0
0 0
1
08/12/2010
08:59:28
FRRDBR01
SUM031
PUBLIC
7 Months
VILLAGE OF MOUNT PROSPECT 5 Months
Department Budget Expenditure Summary
01 /01 /10 - 07/31/10
Cur Mo Y -T -D 2010
REPRESENTATION Expended Expended Budget
( 58.30 ) Completed
( 41.6t ) Remaining
Unexpended Unexpended
Balance Percent
PROGRAM TOTALS
02
MAYOR AND BOARD OF TRUSTEES
6,662
120,429
120,261
-168
-0.1
03
ADVISORY BOARDS & COMMISSIONS
534
2,766
6,149
3,383
55.0
Totals
7,196
123,195
126,410
3,215
2.5
EXPENDITURE CLASSIFICATION
50
PERSONAL SERVICES
3,164
19,888
34,311
14,423
42.0
51
EMPLOYEE BENEFITS
574
3,620
6,291
2,671
42.5
52
OTHER EMPLOYEE COSTS
1
113
4,400
4,287
97.4
54
CONTRACTUAL SERVICES
3,399
99,092
76,853
- 22,239
-28.9
55
UTILITIES
23
143
455
312
68.6
57
COMMODITIES & SUPPLIES
35
339
4,100
3,761
91.7
Totals
7,196
123,195
126,410
3,215
2.5
SOURCE OF FUNDS
001
GENERAL FUND
7,196
123,195
126,410
3,215
2.5
Totals
7,196
123,195
126,410
3,215
2.5
2
08/12/2010
01
7 Months
( 58.3% ) Completed
08:59:28
VILLAGE OF MOUNT PROSPECT 5 Months
( 41.6$ ) Remaining
FRRDBR01
INFORMATION TECHNOLOGY
05
PUBLIC INFORMATION
SUM 031
Department Budget Expenditure
Summary
50
PERSONAL SERVICES
01 /01 /10 - 07/31/10
EMPLOYEE BENEFITS
52
OTHER EMPLOYEE COSTS
Cur Mo Y -T -D
2010
Unexpended Unexpended
VILLAGE
MANAGER'S OFFICE Expended Expended
Budget
Balance Percent
PROGRAM TOTALS
01
VILLAGE MANAGER'S OFFICE
02
LEGAL SERVICES
03
HUMAN RESOURCES
04
INFORMATION TECHNOLOGY
05
PUBLIC INFORMATION
892,193
Totals
EXPENDITURE CLASSIFICATION
50
PERSONAL SERVICES
51
EMPLOYEE BENEFITS
52
OTHER EMPLOYEE COSTS
54
CONTRACTUAL SERVICES
55
UTILITIES
57
COMMODITIES & SUPPLIES
65
OFFICE EQUIPMENT
67
OTHER EQUIPMENT
Totals
SOURCE OF FUNDS
001 GENERAL FUND
Totals
60,819
327,029
575,229
95,401
291,554
538,250
25,663
140,694
265,181
62,161
422,541
892,193
35,471
131,196
248,098
279,515 1,313,014 2,518,951
113,887
574,250
31,911
186,507
434
9,990
131,965
518,809
559
3,581
131
4,763
628
15,114
0
0
1,011,435
321,215
28,200
1,115,200
8,601
15,200
19,100
279,515 1,313,014
279,515 1,313,014
279,515 1,313,014
3
2,518,951
248,200
43.1
246,696
45.8
124,487
46.9
469,652
52.6
116,902
47.1
1,205,937 47.9
437,185
43.2
134,708
41.9
18,210
64.6
596,391
53.5
5,020
58.4
10,437
68.7
3,986
20.9
0
1,205,937 47.9
2,518,951 1,205,937 47.9
2,518,951 1,205,937 47.9
08/12/2010 7 Months
08:59:28 VILLAGE OF MOUNT PROSPECT 5 Months
FRRDBR01
SUM031 Department Budget Expenditure Summary
01 /01 /10 - 07/31/10
Cur Mo Y -T -D 2010
TV SERVICES DIVISION Expended Expended Budget
( 58.30 ) Completed
( 41.60 ) Remaining
Unexpended Unexpended
Balance Percent
PROGRAM TOTALS
02
CABLE TV OPERATIONS
13,670
84,915
139,639
54,724
39.2
04
INTERGOVERNMENTAL PROGRAMMING
4,596
30,600
62,410
31,810
51.0
Totals
18,266
115,515
202,049
86,534
42.8
EXPENDITURE CLASSIFICATION
50
PERSONAL SERVICES
13,121
66,968
114,194
47,226
41.4
51
EMPLOYEE BENEFITS
4,261
25,676
44,177
18,501
41.9
52
OTHER EMPLOYEE COSTS
0
725
700
-25
-3.6
54
CONTRACTUAL SERVICES
410
10,986
27,378
16,392
59.9
55
UTILITIES
152
951
1,600
649
40.6
57
COMMODITIES & SUPPLIES
322
3,814
5,500
1,686
30.7
67
OTHER EQUIPMENT
0
6,395
8,500
2,105
24.8
Totals
18,266
115,515
202,049
86,534
42.8
SOURCE OF FUNDS
001
GENERAL FUND
18,266
115,515
202,049
86,534
42.8
Totals
18,266
115,515
202,049
86,534
42.8
4
08/12/2010
08:59:28
FRRDBR01
SUM031
VILLAGE
7 Months
VILLAGE OF MOUNT PROSPECT 5 Months
Department Budget Expenditure Summary
01/01/10 - 07/31/10
Cur Mo Y -T -D 2010
CLERK'S OFFICE Expended Expended Budget
( 58.3$ ) Completed
( 41.6$ ) Remaining
Unexpended Unexpended
Balance Percent
PROGRAM TOTALS
02
VILLAGE CLERK'S OFFICE
20,093
112,584
208,643
96,059
46.0
Totals
20,093
112,584
208,643
96,059
46.0
EXPENDITURE CLASSIFICATION
50
PERSONAL SERVICES
13,973
74,642
126,804
52,162
41.1
51
EMPLOYEE BENEFITS
4,535
27,662
47,646
19,984
41.9
52
OTHER EMPLOYEE COSTS
30
423
1,485
1,062
71.5
54
CONTRACTUAL SERVICES
1,440
8,860
29,679
20,819
70.1
55
UTILITIES
76
476
1,549
1,073
69.3
57
COMMODITIES & SUPPLIES
39
521
1,480
959
64.8
Totals
20,093
112,584
208,643
96,059
46.0
SOURCE OF FUNDS
001
GENERAL FUND
20,093
112,584
208,643
96,059
46.0
Totals
20,093
112,584
208,643
96,059
46.0
5
08/12/2010
08:59:28
FRRDBR01
SUM031
FINANCE
7 Months
VILLAGE OF MOUNT PROSPECT 5 Months
Department Budget Expenditure Summary
01 /01 /10 - 07/31/10
Cur Mo Y -T -D 2010
DEPARTMENT Expended Expended Budget
( 58.3% ) Completed
( 41.6W ) Remaining
Unexpended Unexpended
Balance Percent
PROGRAM TOTALS
01
FINANCE ADMINISTRATION
35,592
188,137
359,820
171,683
47.7
02
ACCOUNTING
53,310
278,054
491,793
213,739
43.5
05
INSURANCE PROGRAMS
28,211
181,247
311,872
130,625
41.9
06
CUSTOMER SERVICE
39,632
235,109
420,812
185,703
44.1
07
CASH MANAGEMENT
3,152
16,422
28,416
11,994
42.2
Totals
159,897
898,969
1,612,713
713,744
44.3
EXPENDITURE CLASSIFICATION
50
PERSONAL SERVICES
94,301
470,790
843,557
372,767
44.2
51
EMPLOYEE BENEFITS
30,004
177,347
312,122
134,775
43.2
52
OTHER EMPLOYEE COSTS
838
2,817
5,650
2,833
50.1
54
CONTRACTUAL SERVICES
13,211
101,587
181,213
79,626
43.9
55
UTILITIES
383
2,428
4,900
2,472
50.4
56
INSURANCE
19,393
135,748
232,711
96,963
41.7
57
COMMODITIES & SUPPLIES
1,767
8,252
32,160
23,908
74.3
65
OFFICE EQUIPMENT
0
0
400
400
100.0
Totals
159,897
898,969
1,612,713
713,744
44.3
SOURCE OF FUNDS
001
GENERAL FUND
159,897
898,969
1,612,713
713,744
44.3
Totals
159,897
898,969
1,612,713
713,744
44.3
6
08/12/2010
7 Months
( 58.3$ ) Completed
08:59:28
VILLAGE OF MOUNT
PROSPECT
5 Months
( 41.6$ ) Remaining
FRRDBR01
SUM031
Department Budget
Expenditure Summary
01 /01 /10
- 07/31/10
Cur Mo
Y -T -D
2010
Unexpended Unexpended
COMMUNITY DEVELOPMENT
Expended
Expended
Budget
Balance
Percent
PROGRAM TOTALS
01
COMMUNITY DEVELOPMENT ADMIN
37,556
154,140
261,596
107,456
41.1
02
PLANNING & ZONING
26,780
152,526
333,616
181,090
54.3
03
ECONOMIC DEVELOPMENT
12,315
53,686
95,383
41,697
43.7
05
BUILDING INSPECTIONS
97,345
492,534
940,912
448,378
47.7
06
HOUSING INSPECTIONS
58,891
293,887
529,946
236,059
44.5
07
HEALTH INSPECTIONS
13,190
71,515
128,093
56,578
44.2
Totals
246,077
1,218,288
2,289,546
1,071,258
46.8
EXPENDITURE CLASSIFICATION
50
PERSONAL SERVICES
163,817
791,953
1,402,026
610,073
43.5
51
EMPLOYEE BENEFITS
52,677
309,998
541,145
231,147
42.7
52
OTHER EMPLOYEE COSTS
4,095
12,103
31,246
19,143
61.3
54
CONTRACTUAL SERVICES
23,947
91,421
269,117
177,696
66.0
55
UTILITIES
1,029
6,061
17,671
11,610
65.7
57
COMMODITIES & SUPPLIES
512
6,752
24,141
17,389
72.0
65
OFFICE EQUIPMENT
0
0
4,200
4,200
100.0
Totals
246,077
1,218,288
2,289,546
1,071,258
46.8
SOURCE OF FUNDS
001
GENERAL FUND
244,577
1,216,788
2,288,046
1,071,258
46.8
550
DOWNTOWN REDEVLPMNT CONST
1,500
1,500
1,500
0
Totals
246,077
1,218,288
2,289,546
1,071,258
46.8
08/12/2010
7 Months
( 58.3 ) Completed
08:59:28
VILLAGE OF MOUNT PROSPECT 5 Months
( 41.6% ) Remaining
FRRDBROI
42,936
94,947
52,011
54.8
SUM 031
Department Budget
Expenditure
Summary
90,500
25,718
01 /01 /10
- 07/31/10
ACCESSIBLTY & NEIGHBRHD IMPRV
0
3,360
100,000
Cur Mo Y -T -D
2010
Unexpended Unexpended
COMMUNITY
DEVELOPMENT - CDBG
Expended Expended
Budget
Balance Percent
PROGRAM TOTALS
04
CDBG ADMINISTRATION
9,347
42,936
94,947
52,011
54.8
05
CDBG COMMUNITY PROGRAMS
18,000
64,782
90,500
25,718
28.4
06
ACCESSIBLTY & NEIGHBRHD IMPRV
0
3,360
100,000
96,640
96.6
07
CDBG RESIDENTIAL REHAB
246
37,789
280,000
242,211
86.5
08
CDBG RECOVERY ACT
912
63,925
0
- 63,925
Totals
28,505
212,792
565,447
352,655
62.4
EXPENDITURE CLASSIFICATION
50
PERSONAL SERVICES
6,676
32,765
62,569
29,804
47.6
51
EMPLOYEE BENEFITS
2,218
13,079
23,311
10,232
43.9
52
OTHER EMPLOYEE COSTS
0
25
1,965
1,940
98.7
54
CONTRACTUAL SERVICES
18,453
75,801
106,625
30,824
28.9
57
COMMODITIES & SUPPLIES
0
81
977
896
91.7
59
OTHER EXPENDITURES
1,158
87,681
200,000
112,319
56.2
62
LAND IMPROVEMENTS
0
0
50,000
50,000
100.0
69
INFRASTRUCTURE
0
3,360
120,000
116,640
97.2
Totals
28,505
212,792
565,447
352,655
62.4
SOURCE OF FUNDS
070
COMMUNITY DEVELPMNT BLOCK GRNT
28,505
212,792
565,447
352,655
62.4
Totals
28,505
212,792
565,447
352,655
62.4
08/12/2010 7 Months
08:59:28 VILLAGE OF MOUNT PROSPECT 5 Months
FRRDBR01
SUM031 Department Budget Expenditure Summary
01 /01 /10 - 07/31/10
Cur Mo Y -T -D 2010
HUMAN SERVICES Expended Expended Budget
( 58.3% ) Completed
( 41.6 ) Remaining
Unexpended Unexpended
Balance Percent
PROGRAM TOTALS
01
HUMAN SERVICES ADMINISTRATION
16,397
98,934
184,075
85,141
46.3
02
SOCIAL SERVICES
42,448
220,959
389,713
168,754
43.3
03
NURSING /HEALTH SERVICES
23,273
113,993
239,089
125,096
52.3
04
SENIOR CITIZEN LEIS ACTIVITIES
3,380
17,781
35,821
18,040
50.4
05
COMMUNITY CONNECTIONS CENTER
30,317
166,709
306,071
139,362
45.5
Totals
115,815
618,376
1,154,769
536,393
46.5
EXPENDITURE CLASSIFICATION
50
PERSONAL SERVICES
79,591
400,828
689,812
288,984
41.9
51
EMPLOYEE BENEFITS
23,960
140,490
241,687
101,197
41.9
52
OTHER EMPLOYEE COSTS
295
1,232
12,581
11,349
90.2
54
CONTRACTUAL SERVICES
10,860
63,608
154,168
90,560
58.7
55
UTILITIES
781
6,010
14,756
8,746
59.3
57
COMMODITIES & SUPPLIES
328
6,208
39,065
32,857
84.1
64
BUILDING IMPROVEMENTS
0
0
0
0
65
OFFICE EQUIPMENT
0
0
2,700
2,700
100.0
Totals
115,815
618,376
1,154,769
536,393
46.5
SOURCE OF FUNDS
001 GENERAL FUND
Totals
115,815 618,376 1,154,769 536,393 46.5
115,815 618,376 1,154,769 536,393 46.5
9
08/12/2010
7 Months
( 58.3% ) Completed
08:59:28
VILLAGE OF MOUNT
PROSPECT
5 Months
( 41.6t ) Remaining
FRRDBR01
SUM031
Department
Budget Expenditure Summary
01 /01 /10 - 07/31/10
Cur Mo
Y -T -D
2010
Unexpended Unexpended
POLICE
Expended
Expended
Budget
Balance
Percent
PROGRAM TOTALS
01
POLICE ADMINISTRATION
165,311
1,960,382
3,958,608
1,998,226
50.5
02
PATROL & TRAFFIC ENFORCEMENT
888,287
4,879,848
8,946,765
4,066,917
45.5
03
CRIME PREVTN & PUBLIC SERVICES
29,525
153,819
271,910
118,091
43.4
04
INVESTIGATIVE & JUVENILE PRGM
138,820
728,447
1,318,756
590,309
44.8
05
CROSSING GUARDS
100
17,757
31,480
13,723
43.6
06
EQUIPMENT MAINTENANCE
39,620
297,989
515,145
217,156
42.2
Totals
1,261,663
8,038,242
15,042,664
7,004,422
46.6
EXPENDITURE CLASSIFICATION
50
PERSONAL SERVICES
986,374
5,205,423
9,490,554
4,285,131
45.2
51
EMPLOYEE BENEFITS
175,876
2,059,926
4,146,442
2,086,516
50.3
52
OTHER EMPLOYEE COSTS
2,732
53,905
140,300
86,395
61.6
54
CONTRACTUAL SERVICES
83,311
647,875
1,080,543
432,668
40.0
55
UTILITIES
3,291
19,890
33,160
13,270
40.0
57
COMMODITIES & SUPPLIES
6,154
40,235
127,315
87,080
68.4
65
OFFICE EQUIPMENT
392
1,517
6,150
4,633
75.3
67
OTHER EQUIPMENT
3,533
9,471
18,200
8,729
48.0
80
INTERFUND TRANSFERS
0
0
0
0
Totals
1,261,663
8,038,242
15,042,664
7,004,422
46.6
SOURCE OF FUNDS
001
GENERAL FUND
1,258,149
8,029,267
15,038,164
7,008,897
46.6
060
LAW ENFORCEMENT BLOCK GRANT
0
0
0
0
080
ASSET SEIZURE FUND
1,000
6,118
2,000
-4,118
-205.9
085
DEA SHARED FUNDS FUND
2,514
2,514
1,000
-1,514
-151.4
086
DUI FINE FUND
0
343
1,500
1,157
77.1
Totals
1,261,663
8,038,242
15,042,664
7,004,422
46.6
10
08/12/2010
08:59:28
FRRDBR01
SUM 031
FIRE
7 Months
VILLAGE OF MOUNT PROSPECT 5 Months
Department Budget Expenditure Summary
01 /01 /10 - 07/31/10
Cur Mo Y -T -D 2010
Expended Expended Budget
( 58.3g ) Completed
( 41.60 ) Remaining
Unexpended Unexpended
Balance Percent
PROGRAM TOTALS
01
FIRE ADMINISTRATION
105,183
1,491,230
2,934,025
1,442,795
49.2
02
FIRE DEPARTMENT OPERATIONS
848,389
4,290,689
7,577,769
3,287,080
43.4
03
FIRE TRAINING ACADEMY
191
2,361
14,131
11,770
83.3
04
FIRE PREVENTION
50,239
288,187
603,725
315,538
52.3
05
FIRE COMMUNICATIONS
2,967
23,859
55,611
31,752
57.1
06
EQUIPMENT MAINTENANCE
16,475
115,325
197,950
82,625
41.7
07
EMERGENCY PREPAREDNESS PRGM
2,420
4,340
62,436
58,096
93.0
08
PAID -ON -CALL PROGRAM
3,164
17,315
33,180
15,865
47.8
10
FOREIGN FIRE INSURANCE
9,480
28,946
15,500
- 13,446
-86.7
Totals
1,038,508
6,262,252
11,494,327
5,232,075
45.5
EXPENDITURE CLASSIFICATION
50
PERSONAL SERVICES
855,695
4,178,364
7,402,167
3,223,803
43.6
51
EMPLOYEE BENEFITS
126,163
1,734,569
3,333,594
1,599,025
48.0
52
OTHER EMPLOYEE COSTS
11,072
41,686
140,880
99,194
70.4
53
PENSION BENEFITS
0
0
500
500
100.0
54
CONTRACTUAL SERVICES
28,778
242,009
413,665
171,656
41.5
55
UTILITIES
2,811
17,378
38,311
20,933
54.6
57
COMMODITIES & SUPPLIES
2,490
21,367
73,970
52,603
71.1
64
BUILDING IMPROVEMENTS
51
51
3,800
3,749
98.7
65
OFFICE EQUIPMENT
0
0
9,000
9,000
100.0
67
OTHER EQUIPMENT
11,448
26,828
78,440
51,612
65.8
Totals
1,038,508
6,262,252
11,494,327
5,232,075
45.5
SOURCE OF FUNDS
001
GENERAL FUND
1,029,028
6,233,306
11,478,827
5,245,521
45.7
095
FOREIGN FIRE TAX BOARD FUND
9,480
28,946
15,500
- 13,446
-86.7
Totals
1,038,508
6,262,252
11,494,327
5,232,075
45.5
11
08/12/2010
7 Months
( 58.3s ) Completed
08:59:28
VILLAGE OF MOUNT
PROSPECT
5 Months
( 41.60 ) Remaining
FRRDBR01
SUM031
Department Budget
Expenditure Summary
01 /01 /10
- 07/31/10
Cur Mo
Y -T -D
2010
Unexpended Unexpended
PUBLIC
WORKS - ADMINISTRATION
Expended
Expended
Budget
Balance
Percent
PROGRAM TOTALS
01
PUBLIC WORKS ADMINISTRATION
87,352
566,299
982,823
416,524
42.4
Totals
87,352
566,299
982,823
416,524
42.4
EXPENDITURE CLASSIFICATION
50
PERSONAL SERVICES
25,499
134,460
234,319
99,859
42.6
51
EMPLOYEE BENEFITS
13,568
87,232
149,319
62,087
41.6
52
OTHER EMPLOYEE COSTS
725
12,909
25,802
12,893
50.0
54
CONTRACTUAL SERVICES
44,249
311,015
538,489
227,474
42.2
55
UTILITIES
2,404
9,108
19,470
10,362
53.2
57
COMMODITIES & SUPPLIES
907
11,575
15,169
3,594
23.7
65
OFFICE EQUIPMENT
0
0
0
0
67
OTHER EQUIPMENT
0
0
255
255
100.0
Totals
87,352
566,299
982,823
416,524
42.4
SOURCE OF FUNDS
001
GENERAL FUND
87,352
566,299
982,823
416,524
42.4
Totals
87,352
566,299
982,823
416,524
42.4
12
08/12/2010 7 Months ( 58.30 ) Completed
08:59 :28 VILLAGE OF MOUNT PROSPECT 5 Months ( 41.6% ) Remaining
FRRDBR01
SUM031 Department Budget Expenditure Summary
01 /01 /10 - 07/31/10
13
Cur Mo
Y -T -D
2010
Unexpended Unexpended
PUBLIC
WORKS - STREETS /BLDGS
Expended
Expended
Budget
Balance
Percent
PROGRAM TOTALS
01
STREET DIVISION ADMINISTRATION
15,538
98,337
161,866
63,529
39.2
02
MAINTENANCE - PUBLIC BUILDINGS
89,184
505,951
1,010,405
504,454
49.9
04
STREET MAINTENANCE
37,412
134,980
418,912
283,932
67.8
05
SNOW REMOVAL
16,477
472,660
669,384
196,724
29.4
06
LEAF REMOVAL
0
0
0
0
07
STORM SEWER & BASIN MAINT
8,873
50,812
112,657
61,845
54.9
08
MAINTENANCE OF STATE HIGHWAYS
3,191
42,594
70,394
27,800
39.5
09
TRAFFIC SIGN MAINTENANCE
15,469
68,438
122,044
53,606
43.9
10
VILLAGE PARKING LOT MAINT
7,066
52,080
175,098
123,018
70.3
11
PARKING LOT MAINTENANCE
11,445
76,234
149,597
73,363
49.0
12
FLOOD CONTROL
0
0
0
0
13
STORM EVENT
0
0
0
0
Totals
204,655
1,502,086
2,890,357
1,388,271
48.0
EXPENDITURE CLASSIFICATION
50
PERSONAL SERVICES
126,527
709,787
1,246,055
536,268
43.0
51
EMPLOYEE BENEFITS
35,030
213,467
382,210
168,743
44.1
54
CONTRACTUAL SERVICES
33,620
305,449
726,159
420,710
57.9
55
UTILITIES
3,547
21,007
79,230
58,223
73.5
56
INSURANCE
158
1,104
1,894
790
41.7
57
COMMODITIES & SUPPLIES
4,948
244,049
394,954
150,905
38.2
59
OTHER EXPENDITURES
0
0
0
0
64
BUILDING IMPROVEMENTS
0
4,265
19,855
15,590
78.5
67
OTHER EQUIPMENT
0
0
0
0
69
INFRASTRUCTURE
825
2,958
40,000
37,042
92.6
Totals
204,655
1,502,086
2,890,357
1,388,271
48.0
SOURCE OF
FUNDS
001
GENERAL FUND
186,144
1,217,738
2,266,230
1,048,492
46.3
050
MOTOR FUEL TAX FUND
0
156,034
299,432
143,398
47.9
620
VILLAGE PARKING SYSTEM FUND
7,066
52,080
175,098
123,018
70.3
630
PARKING SYSTEM REVENUE FUND
11,445
76,234
149,597
73,363
49.0
Totals
204,655
1,502,066
2,890,357
1,388,271
48.0
13
08/12/2010
08:59:28
FRRDBR01
SUM031
PUBLIC
7 Months
VILLAGE OF MOUNT PROSPECT 5 Months
Department Budget Expenditure Summary
01 /01 /10 - 07/31/10
Cur Mo Y -T -D 2010
WORKS - FORESTRY /GRMS Expended Expended Budget
( 58.30 ) Completed
( 41.6t ) Remaining
Unexpended Unexpended
Balance Percent
PROGRAM TOTALS
01
FORESTRY DIVISION ADMIN
25,556
133,668
237,763
104,095
43.8
02
MAINTENANCE OF GROUNDS
57,748
224,931
473,321
248,390
52.5
03
FORESTRY PROGRAM
67,864
501,716
1,002,138
500,422
49.9
04
PUBLIC GROUNDS BEAUTIFICATION
7,742
45,397
68,010
22,613
33.2
Totals
158,910
905,712
1,781,232
875,520
49.2
EXPENDITURE CLASSIFICATION
50
PERSONAL SERVICES
97,411
419,765
761,579
341,814
44.9
51
EMPLOYEE BENEFITS
25,770
140,177
246,330
106,153
43.1
52
OTHER EMPLOYEE COSTS
0
3,662
3,662
0
54
CONTRACTUAL SERVICES
30,118
308,660
718,112
409,452
57.0
57
COMMODITIES & SUPPLIES
5,611
33,448
51,549
18,101
35.1
67
OTHER EQUIPMENT
0
0
0
0
Totals
158,910
905,712
1,781,232
875,520
49.2
SOURCE OF FUNDS
001
GENERAL FUND
158,910
905,712
1,762,432
856,720
48.6
690
RISK MANAGEMENT FUND
0
0
18,800
18,800
100.0
Totals
158,910
905,712
1,781,232
875,520
49.2
14
08/12/2010
01
7 Months
( 58.3% ) Completed
08:59:28
VILLAGE OF MOUNT PROSPECT 5 Months
( 41.6W ) Remaining
FRRDBR01
50
PERSONAL SERVICES
51
SUM031
Department Budget Expenditure
Summary
54
CONTRACTUAL SERVICES
01 /01 /10 - 07/31/10
UTILITIES
57
COMMODITIES & SUPPLIES
Cur Mo Y -T -D
2010
Unexpended Unexpended
PUBLIC WORKS
- ENGINEERING Expended Expended
Budget
Balance Percent
PROGRAM TOTALS
01
ENGINEERING SERVICES
05
TRAFFIC CNTRL & STREET LGHTNG
44,795
Totals
EXPENDITURE CLASSIFICATION
50
PERSONAL SERVICES
51
EMPLOYEE BENEFITS
52
OTHER EMPLOYEE COSTS
54
CONTRACTUAL SERVICES
55
UTILITIES
57
COMMODITIES & SUPPLIES
65
OFFICE EQUIPMENT
67
OTHER EQUIPMENT
69
INFRASTRUCTURE
2,265
Totals
SOURCE OF FUNDS
001 GENERAL FUND
050 MOTOR FUEL TAX FUND
Totals
94,351
461,544
831,493
369,949
44.5
44,795
213,812
756,494
542,682
71.7
139,146
675,356
1,587,987
912,631
57.5
86,077
398,079
701,400
303,321
43.2
21,649
120,504
211,200
90,696
42.9
175
2,265
3,552
1,287
36.2
4,900
40,886
131,796
90,910
69.0
25,984
103,062
225,000
121,938
54.2
361
10,560
32,855
22,295
67.9
0
0
546
546
100.0
0
0
1,638
1,638
100.0
0
0
280,000
280,000
100.0
139,146
675,356
1,587,987
912,631
57.5
109,721
546,057
1,071,117
525,060
49.0
29,425
129,299
516,870
387,571
75.0
139,146
675,356
1,587,987
912,631
57.5
15
08/12/2010
7 Months
( 58.3% ) Completed
08:59:28
VILLAGE OF MOUNT PROSPECT 5 Months
( 41.60 ) Remaining
FRRDBR01
119,081
774,594
1,415,111
SUM 031
Department Budget Expenditure
Summary
MAINTENANCE OF BUILDINGS
20,487
01 /01 /10 - 07/31/10
266,997
160,137
60.0
Cur Mo Y -T -D
2010
Unexpended Unexpended
PUBLIC WORKS
- WATER /SEWER Expended Expended
Budget
Balance Percent
PROGRAM TOTALS
01
WATER & SEWER DIVISION ADMIN
119,081
774,594
1,415,111
640,517
45.3
02
MAINTENANCE OF BUILDINGS
20,487
106,860
266,997
160,137
60.0
03
MAINTENANCE OF GROUNDS
17,719
66,449
136,428
69,979
51.3
04
WATER SUPPLY MAINT & REPAIR
90,516
397,258
1,585,848
1,188,590
74.9
05
WATER DISTRBT MAINT & REPAIR
45,669
347,411
868,982
521,571
60.0
06
WATER VALVE /HYDRNT MAINT & REP
40,490
197,308
413,162
215,854
52.2
07
WATER METER MAINT & REPL
36,761
152,543
963,266
810,723
84.2
08
EQUIPMENT MAINTENANCE
42,889
300,223
514,668
214,445
41.7
09
SANITARY SEWER MAINT & REPAIR
46,574
292,985
1,039,772
746,787
71.8
10
WATER & SEWER SYSTEM IMPROV
186,989
344,601
2,315,515
1,970,914
85.1
12
LAKE MICHIGAN WATER SUPPLY
307,461
1,796,212
4,030,000
2,233,788
55.4
Totals
954,636
4,776,444
13,549,749
8,773,305
64.7
EXPENDITURE CLASSIFICATION
50
PERSONAL SERVICES
211,376
1,033,885
1,900,352
866,467
45.6
51
EMPLOYEE BENEFITS
63,893
375,831
671,563
295,732
44.0
52
OTHER EMPLOYEE COSTS
2,608
18,267
57,336
39,069
68.1
54
CONTRACTUAL SERVICES
546,267
2,853,376
6,242,726
3,389,350
54.3
55
UTILITIES
21,167
78,378
185,406
107,028
57.7
56
INSURANCE
5,524
38,672
66,295
27,623
41.7
57
COMMODITIES & SUPPLIES
18,045
113,677
291,120
177,443
61.0
59
OTHER EXPENDITURES
0
0
0
0
65
OFFICE EQUIPMENT
0
220
7,652
7,432
97.1
67
OTHER EQUIPMENT
3,185
33,585
1,256,953
1,223,368
97.3
68
DISTRIBUTION SYSTEMS
82,571
230,553
2,870,346
2,639,793
92.0
Totals
954,636
4,776,444
13,549,749
8,773,305
64.7
SOURCE OF FUNDS
610 WATER AND SEWER FUND 954,636 4,776,444 13,549,749
Totals 954,636 4,776,444 13,549,749
16
8,773,305 64.7
8 ; 773,305 64.7
08/12/2010
08:59:28
FRRDBR01
SUM031
PUBLIC
7 Months
VILLAGE OF MOUNT PROSPECT 5 Months
Department Budget Expenditure Summary
01 /01 /10 - 07/31/10
Cur Mo Y -T -D 2010
WORKS — REFUSE DISPOSAL Expended Expended Budget
( 58.30 ) Completed
( 41.6a ) Remaining
Unexpended Unexpended
Balance Percent
PROGRAM TOTALS
01
REFUSE DISPOSAL PROGRAM
332,111
2,117,127
4,019,373
1,902,246
47.3
02
REFUSE LEAF REMOVAL PROGRAM
15,961
77,630
221,568
143,938
65.0
Totals
348,072
2,194,757
4,240,941
2,046,184
48.2
EXPENDITURE CLASSIFICATION
50
PERSONAL SERVICES
22,424
107,240
251,942
144,702
57.4
51
EMPLOYEE BENEFITS
6,613
38,307
77,148
38,841
50.3
52
OTHER EMPLOYEE COSTS
0
0
1,200
1,200
100.0
54
CONTRACTUAL SERVICES
316,900
2,027,742
3,853,608
1,825,866
47.4
55
UTILITIES
30
190
572
382
66.8
56
INSURANCE
1,895
13,262
22,734
9,472
41.7
57
COMMODITIES & SUPPLIES
210
8,016
33,737
25,721
76.2
Totals
348,072
2,194,757
4,240,941
2,046,184
48.2
SOURCE OF FUNDS
030
REFUSE DISPOSAL FUND
348,072
2,194,757
4,240,941
2,046,184
48.2
Totals
348,072
2,194,757
4,240,941
2,046,184
48.2
17
08/12/2010
7 Months
( 58.30 ) Completed
08:59:28
VILLAGE OF MOUNT
PROSPECT
5 Months
( 41.60 > Remaining
FRRDBR01
SUM031
Department Budget
Expenditure Summary
01/01/10
- 07/31/10
Cur Mo
Y -T -D
2010
Unexpended Unexpended
PUBLIC
WORKS - VEHICLE MAINT
Expended
Expended
Budget
Balance
Percent
PROGRAM TOTALS
01
VEHICLE MAINTENANCE ADMIN
16,984
106,399
180,836
74,437
41.2
02
VEHICLE MAINTENANCE PROGRAM
161,156
902,795
1,633,875
731,080
44.7
Totals
178,140
1,009,194
1,814,711
805,517
44.4
EXPENDITURE CLASSIFICATION
50
PERSONAL SERVICES
99,413
488,940
879,792
390,852
44.4
51
EMPLOYEE BENEFITS
28,903
169,057
301,789
132,732
44.0
52
OTHER EMPLOYEE COSTS
0
1,898
2,315
417
18.0
54
CONTRACTUAL SERVICES
7,095
37,234
95,738
58,504
61.1
55
UTILITIES
76
476
993
517
52.1
57
COMMODITIES & SUPPLIES
42,653
311,510
530,039
218,529
41.2
59
OTHER EXPENDITURES
0
0
0
0
65
OFFICE EQUIPMENT
0
0
545
545
100.0
67
OTHER EQUIPMENT
0
79
3,500
3,421
97.7
Totals
178,140
1,009,194
1,814,711
805,517
44.4
SOURCE OF FUNDS
660
VEHICLE MAINTENANCE FUND
178,140
1,009,194
1,814,711
805,517
44.4
Totals
178,140
1,009,194
1,814,711
805,517
44.4
18
08/12/2010
7 Months
( 58.30 ) Completed
08:59:28
VILLAGE OF MOUNT PROSPECT
5 Months
( 41.6t ) Remaining
FRRDBR01
136,400
62,079
45.5
SUM031
Department Budget Expenditure
Summary
167,252
49,196
01/01/10 - 07/31/10
04 HOLIDAY DECORATIONS
924
15,837
Cur Mc Y -T -D
2010
Unexpended Unexpended
COMMUNITY
SERVICE PROGRAMS Expended Expended
Budget
Balance Percent
PROGRAM TOTALS
02 COMMUNITY GROUPS & MISC
20,476
74,321
136,400
62,079
45.5
03 4TH OF JULY & CIVIC EVENTS,ETC
85,934
118,056
167,252
49,196
29.4
04 HOLIDAY DECORATIONS
924
15,837
81,330
65,493
80.5
05 BLOOD DONOR PROGRAM
166
1,496
2,774
1,278
46.1
Totals
107,500
209,710
387,756
178,046
45.9
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES
53,214
73,064
100,731
27,667
27.5
51 EMPLOYEE BENEFITS
6,253
10,237
18,660
8,423
45.1
54 CONTRACTUAL SERVICES
37,590
92,105
207,785
115,680
55.7
57 COMMODITIES & SUPPLIES
10,443
34,304
52,580
18,276
34.8
59 OTHER EXPENDITURES
0
0
8,000
8,000
100.0
Totals
107,500
209,710
387,756
178,046
45.9
SOURCE OF FUNDS
001 GENERAL FUND
107,500
209,710
387,756
178,046
45.9
Totals
107,500
209,710
387,756
178,046
45.9
19
08/12/2010
7 Months
( 58.3% ) Completed
08:59:28
VILLAGE OF MOUNT PROSPECT 5 Months
( 41.6% ) Remaining
FRRDBR01
416,460
1,829,500
1,413,040
77.2
SUM 031
Department Budget
Expenditure
Summary
155,765
128,141
01/01/10
- 07/31/10
DOWNTOWN REDEVELOPMENT CONST
1,134,741
1,267,651
2,735,000
Cur Mo Y -T -D
2010
Unexpended Unexpended
CAPITAL
IMPROVEMENT PROJECTS
Expended Expended
Budget
Balance Percent
PROGRAM TOTALS
01
VILLAGE IMPROVEMENTS & EQUIP
56,766
416,460
1,829,500
1,413,040
77.2
02
COMMUNITY IMPROVEMENT PROJECTS
2,872
27,624
155,765
128,141
82.3
03
DOWNTOWN REDEVELOPMENT CONST
1,134,741
1,267,651
2,735,000
1,467,349
53.7
04
FLOOD CONTROL PROJECTS
0
5,266
161,425
156,159
96.7
06
STREET IMPROVEMENT PROJECTS
88,417
1,421,875
2,665,880
1,244,005
46.7
09
MOTOR EQUIPMENT REPLACEMENT
75,688
414,884
810,000
395,116
48.8
10
COMPUTER REPLACEMENT
1,326
108,155
206,050
97,895
47.5
11
STATION 14
68,803
2,335,558
1,380,963
- 954,595
-69.1
12
EMERGENCY OPERATION CENTER
0
196,679
456,741
260,062
56.9
13
PUBLIC WORKS EXPANSION
13,305
385,870
345,929
- 39,941
-11.5
Totals
1,441,918
6,580,022
10,747,253
4,167,231
38.8
EXPENDITURE CLASSIFICATION
54
CONTRACTUAL SERVICES
53,211
390,913
1,005,820
614,907
61.1
59
OTHER EXPENDITURES
1,118,463
1,150,767
2,420,150
1,269,383
52.5
62
LAND IMPROVEMENTS
0
0
26,065
26,065
100.0
64
BUILDING IMPROVEMENTS
67,157
2,587,665
1,237,003
- 1,350,662
-109.2
65
OFFICE EQUIPMENT
1,326
109,155
438,050
328,895
75.1
66
MOBILE EQUIPMENT
75,688
414,884
810,000
395,116
48.8
67
OTHER EQUIPMENT
41,968
474,019
1,741,150
1,267,131
72.8
69
INFRASTRUCTURE
84,105
1,452,619
3,069,015
1,616,396
52.7
71
BOND PRINCIPAL
0
0
0
0
72
INTEREST EXPENSE
0
0
0
0
80
INTERFUND TRANSFERS
0
0
0
0
Totals
1,441,918
6,580,022
10,747,253
4,167,231
38.8
SOURCE OF FUNDS
050
MOTOR FUEL TAX FUND
0
920,000
920,000
0
510
CAPITAL IMPROVEMENT FUND
59,382
489,796
2,130,265
1,640,469
77.0
528
SERIES 2009 CONST FUND
82,364
2,918,393
2,183,633
- 734,760
-33.6
550
DOWNTOWN REDEVLPMNT CONST
1,134,741
1,267,651
2,735,000
1,467,349
53.7
560
STREET IMPROVEMENT CONST FUND
88,417
455,877
1,575,880
1,120,003
71.1
590
FLOOD CONTROL CONST FUND
0
5,266
161,425
156,159
96.7
630
PARKING SYSTEM REVENUE FUND
0
0
25,000
25,000
100.0
670
VEHICLE REPLACEMENT FUND
75,688
414,884
810,000
395,116
48.8
680
COMPUTER REPLACEMENT FUND
1,326
108,155
206,050
97,895
47.5
Totals
1,441,918
6,580,022
10,747,253
4,167,231
38.8
20
08/12/2010
08:59:28
FRRDBROI
SUM 031
DEBT SERVICE
7 Months ( 58.30 ) Completed
VILLAGE OF MOUNT PROSPECT 5 Months ( 41.61 > Remaining
Department Budget Expenditure Summary
01/01/10 - 07/31/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
Expended Expended Budget Balance Percent
PROGRAM TOTALS
02
DEBT SERVICE - PROPERTY TAXES
03
DEBT SERVICE - TAX INCREMENT
04
DEBT SERVICE - H/R SALES TAX 1
06
SPECIAL SERVICE AREA B & I
SERIES
Totals
EXPENDITURE CLASSIFICATION
54
CONTRACTUAL SERVICES
59
OTHER EXPENDITURES
71
BOND PRINCIPAL
72
INTEREST EXPENSE
73
BANK AND FISCAL FEES
80
INTERFUND TRANSFERS
81
OTHER FINANCING USES
1998A B &I, FLOOD
Totals
SOURCE OF FUNDS
507,112
140
SERIES
1987A B &I, PW FACILITY
180
SERIES
2001 B &I, VILLAGE HALL
190
SERIES
2003 B &I, VILLAGE HALL
195
SERIES
2009 B &I, FD /PW
196
2009B B &I, FD /PW
197
2009C B &I, FD /PW
290
SERIES
1999 B &I, TIF
340
SERIES
1996A B &I, FLOOD
350
SERIES
1998A B &I, FLOOD
360
SERIES
1998C B &I, TIP
380
IEPA FLOOD CONTROL LOANS B &I
390
SERIES
2000 B &I, FLOOD CONTROL
830
SSA #6
GEORGE /ALBERT B &I
997,651
78.5
Totals
300
507,112
1,712,524
1,205,412
70.4
0
0
0
0
19,644
326,320
613,356
287,036
46.8
0
0
0
0
19,944
833,432
2,325,880
1,492,448
64.2
0
0
0
0
0
0
0
0
17,482
273,553
1,271,204
997,651
78.5
2,162
558,701
1,053,076
494,375
46.9
300
1,178
1,600
422
26.4
0
0
0
0
0
0
0
0
19,944
833,432
2,325,880
1,492,448
64.2
0
0
0
0
0
150
382,203
382,053
100.0
300
191,628
912,658
721,030
79.0
0
209,059
417,663
208,604
49.9
0
46,640
0
- 46,640
0
59,635
0
- 59,635
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
19,644
326,320
613,356
287,036
46.8
0
0
0
0
0
0
0
0
19 ; 944
833
2.325.880
1,492,448
64.2
21
08/12/2010
08:59:28
FRRDBR01
SUM031
RETIREE
7 Months
VILLAGE OF MOUNT PROSPECT 5 Months
Department Budget Expenditure Summary
01 /01 /10 — 07/31/10
Cur Mo Y -T -D 2010
PENSIONS Expended Expended Budget
( 58.3t ) Completed
( 41.6t ) Remaining
Unexpended Unexpended
Balance Percent
PROGRAM TOTALS
01
MISCELLANEOUS PENSIONS
3,811
26,673
46,600
19,927
42.8
02
POLICE PENSIONS
289,128
1,945,034
3,242,300
1,297,266
40.0
03
FIRE PENSIONS
260,759
1,812,330
3,121,500
1,309,170
41.9
Totals
553,698
3,784,037
6,410,400
2,626,363
41.0
EXPENDITURE CLASSIFICATION
53
PENSION BENEFITS
553,272
3,782,561
6,404,400
2,621,839
40.9
54
CONTRACTUAL SERVICES
300
1,350
4,500
3,150
70.0
57
COMMODITIES & SUPPLIES
126
126
1,500
1,374
91.6
Totals
553,698
3,784,037
6,410,400
2,626,363
41.0
SOURCE OF FUNDS
001
GENERAL FUND
3,811
26,673
46,600
19,927
42.8
710
POLICE PENSION FUND
289,128
1,945,034
3,242,300
1,297,266
40.0
720
FIRE PENSION FUND
260,759
1,812,330
3,121,500
1,309,170
41.9
Totals
553,698
3,784,037
6,410,400
2,626,363
41.0
22
08/12/2010
7 Months
( 58.30 ) Completed
08:59:28 VILLAGE OF MOUNT
PROSPECT
5 Months
( 41.60 ) Remaining
FRRDBR01
SUM 031 Department Budget
Expenditure Summary
01 /01 /10
— 07/31/10
Cur Mo
Y -T -D
2010
Unexpended Unexpended
RISK MANAGEMENT
Expended
Expended
Budget
Balance
Percent
PROGRAM TOTALS
01 CASUALTY & PROPERTY INSURANCE
207,274
731,062
927,700
196,638
21.2
02 MEDICAL INSURANCE
463,577
3,057,555
5,925,898
2,868,343
48.4
Totals
670,851
3,788,617
6,853,598
3,064,981
44.7
EXPENDITURE CLASSIFICATION
54 CONTRACTUAL SERVICES
0
0
2,000
2,000
100.0
56 INSURANCE
670,851
3,788,617
6,851,598
3,062,981
44.7
67 OTHER EQUIPMENT
0
0
0
0
Totals
670,851
3,788,617
6,853,598
3,064,981
44.7
SOURCE OF FUNDS
690 RISK MANAGEMENT FUND
670,851
3,788,617
6,853,598
3,064,981
44.7
Totals
670,851
3,788,617
6,853,598
3,064,981
44.7
23
08/12/2010
7 Months
( 58.3% ) Completed
08:59:28
VILLAGE OF MOUNT PROSPECT 5 Months
( 41.6% ) Remaining
FRRDBR01
SUM 031 Department Budget Expenditure
Summary
01 /01 /10 — 07/31/10
Cur Mo Y -T -D
2010
Unexpended Unexpended
NON — DEPARTMENTAL
Expended Expended
Budget
Balance Percent
PROGRAM TOTALS
01 CONTINGENCIES
0 0
0
0
Totals
0 0
0
0
EXPENDITURE CLASSIFICATION
80 INTERFUND TRANSFERS
0 0
0
0
Totals
0 0
0
0
SOURCE OF FUNDS
001 GENERAL FUND
0 0
0
0
Totals
0 0
0
0
24
08/12/2010
7 Months
( 58.3% ) Completed
08:59:28
VILLAGE OF MOUNT PROSPECT
5 Months
( 41.6% ) Remaining
FRRDBR01
SUM 031
Department Budget
Expenditure Summary
01 /01 /10
- 07/31/10
Cur Mo Y -T -D
2010
Unexpended Unexpended
CAPITAL
FIXED ASSETS
Expended Expended
Budget
Balance Percent
PROGRAM TOTALS
00
CAPITAL FIXED ASSETS
0 0
0
0
Totals
0 0
0
0
EXPENDITURE
CLASSIFICATION
59
OTHER EXPENDITURES
0 0
0
0
Totals
0 0
0
0
SOURCE OF FUNDS
910
GENERAL FIXED ASSETS ACCT GP
0 0
0
0
Totals
0 0
0
0
25
08/12/2010
7 Months
( 58.3% ) Completed
08:59:28 VILLAGE OF MOUNT PROSPECT
5 Months
( 41.60 ) Remaining ,
FRRDBR01
SUM031 Department Budget
Expenditure Summary
01/01/10
- 07/31/10
Cur Mo Y -T -D
2010
Unexpended Unexpended
MOUNT PROSPECT LIBRARY
Expended Expended
Budget
Balance Percent
PROGRAM TOTALS
02 LIBRARY SERVICES
0 0
9,715,689
9,715,689 100.0
Totals
0 0
9,715,689
9,715,689 100.0
EXPENDITURE CLASSIFICATION
90 COMPONENT UNIT EXPENDITURES
0 0
9,715,689
9,715,689 100.0
Totals
0 0
9,715,689
9,715,689 100.0
SOURCE OF FUNDS
950 MOUNT PROSPECT LIBRARY FUND
0 0
9,715,689
9,715,689 100.0
Totals
0 0
9,715,689
9,715,689 100.0
26
REPORT: APBOARDRPT
GENERATED: 15 APR 09 11:42
RUN: TUESDAY AUG102010 15:22
PAGE 1
RELEASE ID
VILLAGE OF
MOUNT PROSPECT
LIST OF BILLS PRESENTED
TO THE BOARD OF TRUSTEES
FROM JULY 29 2010
TO AUGUST 11 2010
----------------------------------------------------------------------------------------------------------------------------------
DEPT VENDOR NBR
----------------------------------------------------------------------------------------------------------------------------------
VENDOR NAME
INVOICE DESCRIPTION
AMOUNT
001
07692
A & J SEWER SERVICE
CLEAN OUT SEWER AT STATION 12
305.00
CLEAN OUT SEWER AT STATION 13
305.00
610.00
11451
A STARS & STRIPES FLAG CORPORATION
BEADED RETAINER RING
210.70
12245
ACR REPORTING, LIP
INV #9685 -A
287.50
INV #9709 -R
196.60
OVER PYMT INV #9694 -E
0.40-
483.70
01071
ADDISON BUILDING MATERIAL CO.
LOUIS ST. IRRIGATION CONTROLLE
13.92
OUTLET FOR LOUIS ST. IRRIGATIO
2.33
7 WIRE TO 4 WIRE ADAPTERS
24.09
MISC. BUILDING SUPPLIES
39.23
VILLAGE HALL SOUND SYSTEM REPA
2.18
SPLINE SHANK BIT 1 -1/8 "X18"
58.90
140.65
09619
ALANIZ LANDSCAPING GROUP
TURF MOWING AT VARIOUS LOCATIO
3634.37
09676
AMERICAN MESSAGING
Monthly Pager Rental
870.12
12260
AMERICAN SOCCER COMPANY, INC
6 SOCCER GOALS
260.60
00372
ANDLER, GLEN
REIMB EXP 7/24/10
532.99
09544
ANDRES MEDICAL BILLING,LTD
JULY 2010 AMBULANCE BILLING
3528.08
12364
ARNIE SALERNO'S PIZZERIA
JOINT FINANCE WORKSHOP 8 /6/10
189.45
02270
AT &T
SERVICE 7/16/10 - 8/15/10
3.22
SERVICE 7/16/10 - 8/15/10
10.73
SERVICE 7/16/10 - 8/15/10
2.15
SERVICE 7/16/10- 8/15/10
3.22
SERVICE 7/16/10 - 8/15/10
21.45
SERVICE 7/16/10- 8/15/10
10.73
SERVICE 7/16/10 - 8/15/10
40.75
SERVICE 7/16/10 - 8/15/10
10.73
SERVICE 7/16/10 - 8/15/10
16.09
SERVICE 7/16/10- 8/15/10
27.89
SERVICE 7/16/10- 8/15/10
8.58
SERVICE 7/16/10 -8 /15/10
8.58
SERVICE 7/16/10 - 8/15/10
38.62
SERVICE 7/16/10 - 8/15/10
217.77
SERVICE 7/16/10- 8/15/10
213.48
SERVICE 7/16/10- 8/15/10
137.31
SERVICE 7/16/10 - 8/15/10
331.81
1103.11
10517
AVANTI CAFE & SANDWICH BAR,INC.
BLOCK PARTY 2010
405.00
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY AUG102010 15:22
RELEASE ID
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 29 2010 TO AUGUST 11 2010
----------------------------------------------------------------------------------------------------------
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION
--------------------------------------------
10540 BATTERIES PLUS
12363 BECCO, DAVID
06287 BEDCO MECHANICAL
12353
BEHUN, DAVID
09609
BONO,CSR,LTD., KATHLEEN
05339
BOUND TREE MEDICAL, LLC
01008
BUSSE'S FLOWERS 6 GIFTS
01014
CADE INDUSTRIES
05707
CASH
05005
CDS OFFICE TECHNOLOGIES
01049
CDW GOVERNMENT, INC
05375 CENTURY CLEANERS
12056 CHEM -WISE ECOLOGICAL PEST MGMT INC
01084 CHICAGO TRIBUNE
12360 CIESIELSKI, EDWARD
11408 CRYSTAL COURT SHOPPING CENTER
FLASHLIGHT BATTERY PACK
REIMB 6SQ SIDEWALK PUBLIC WAL
2010 MAINTENANCE CONTRACT FOR
2010 MAINTENANCE CONTRACT FOR
REIMB EXP 7/26/10
COURT REPORTER ATTENDANCE 6/23
3 Combi Carrier II
SYMPATHY ARRANGEMENT- D.MARIE
CUSTODIAL SUPPLIES
DONATION FOR P.WORKS PICNIC
DOCKING STATION W/ ANTENNA, PO
PRINTER RIBBONS FOR ID PRINTER
PHONE HOLSTERS
PHONE HOLSTERS
RIBBONS,CRUCIAL 2GB DDR2
ID CARDS
UNIFORM CLEANING7/1967/2267/26
UNIFORM CLEANING 7/24 6 7/31
UNIFORM CLEANING 7/28 6 8/2
UNIFORM CLEANING 1%3168%5
UNIFORM CLEANING 7/19 67/22
PEST CONTROL SERVICE PER MONTH
PEST CONTROL SERVICE PER MONTH
ADS - DOWNTOWN BLOCK PARTY 2010
ADS - DOWNTOWN BLOCK PARTY 2010
ADS - DOWNTOWN BLOCK PARTY 2010
REFUND PERMIT #2010-1484
AUGUST 2010 RENT 6 WATER
INSTALL NEW SIGNAGE AT CCC
PAGE 2
AMOUNT
15.61
330.00
382.50
586.80
969.30
83.20
573.40
2201.31
85.00
2375.20
500.00
682.00
56.59
14.68
14.68
336.65
92.73
515.33
41.32
56.55
37.47
24.57
23.92
183.83
460.00
230.00
690.00
676.66
676.66
676.66
2029.98
25.00
3358.00
550.00
3908.00
REPORT: APBOARDRPT
GENERATED: 15 APR 09 11:42
RUN: TUESDAY AUG102010 15:22
PAGE 3
RELEASE ID
VILLAGE OF
MOUNT PROSPECT
LIST OF BILLS PRESENTED
TO THE BOARD OF TRUSTEES
FROM JULY 29 2010
TO AUGUST 11 2010
----------------------------------------------------------------------------------------------------------------------------------
DEPT VENDOR NBR
----------------------------------------------------------------------------------------------------------------------------------
VENDOR NAME
INVOICE DESCRIPTION
AMOUNT
05503
CRYSTAL MAINTENANCE SERVICES CORP.
CUSTODIAL SERVICE AT VILLAGE
32.74
CCC SHARE OF MONTHLY CLEANING
590.00
CUSTODIAL SERVICE AT VILLAGE
7529.44
8152.18
12354
CVS FLAGS.COM
FLAG & FLAG MAGNET
386.00
08065
CVS - PHARMACY, INC.
PRISONER MEDICATION 7/7/10
10.99
10182
DASH MEDICAL GLOVES
1 CASE OF DISPOSABLE GLOVES
59.90
09052
DEFRANCO PLUMBING
PLUMBING REPAIRS AT FIRE HOUSE
1009.50
12357
DOUBLETREE COLLINSVILLE
M.JOLIE & A.LIETZOW 8/16 -19/10
319.20
09653
ETERNO, DAVID G.
PROFESSIONAL SERV 7/28 -7/29
312.00
12365
EVERBANK COMMERCIAL FINANCE, INC
SERVICE 7/24/10 - 8/23/10
467.29
SERVICE 7/24/10- 8/23/10
321.91
SERVICE 7/24/10 - 8/23/10
456.90
SERVICE 7/24/10 - 8/23/10
830.73
SERVICE 7/24/10- 8/23/10
16.80
SERVICE 7/24/10- 8/23/10
16.80
SERVICE 7/24/10- 8/23/10
16.80
SERVICE 7/24/10 - 8/23/10
16.80
SERVICE 7/25/10 - 8/24/10
372.46
2516.49
10393
EXPERTPAY
PAYROLL FOR - 072910
3115.21
11212
FDC DIGITAL IMAGING SOLUTIONS
36X150 PLOTTER BOND PAPER
184.16
ANNUAL MAINTENANCE FOR KIP PLO
59.00
243.16
01377
FEDERAL EXPRESS CORP
SHIPPING FOR BUILDING DIVISION
29.70
SHIPPING FOR ENVIRONMENTAL H D
54.96
SHIPPING CHARGES
92.86
SHIPPING CHARGES
10.64
DELIVERY CAHRGES JULY 2010
65.21
SHIPPING CHARGES
15.20
SHIPPING PLANNING DIVISION
5.13
273.70
00102
FIRE PENSION FUND
PAYROLL FOR - 072910
22516.40
05334
FIRST SECURITY SYSTEMS, INC.
REPAIR OF BAD SMOKE DETECTOR I
300.87
09683
FOX VALLEY FIRE & SAFETY
REPAIR TO FIRE ALARM PANEL AT
318.00
09198
GE CAPITAL
SERVICE 7/15/10 - 8/14/10
198.96
SERVICE 7/15/10 - 8/14/10
198.94
SERVICE 7/15/10-8/14/10
198.94
REPORT: APBOARDRPT
GENERATED: 15 APR 09 11:42
RUN: TUESDAY AUG102010 15:22
PAGE 4
RELEASE ID
VILLAGE OF
MOUNT PROSPECT
LIST OF BILLS PRESENTED
TO THE BOARD OF TRUSTEES
FROM JULY 29 2010
TO AUGUST 11 2010
----------------------------------------------------------------------------------------------------------------------------------
DEPT VENDOR NBR
VENDOR NAME
INVOICE DESCRIPTION
AMOUNT
----------------------------------------------------------------------------------------------------------------------------------
SERVICE 7/15/10- 8/14/10
198.94
795.78
01522
GRAINGER
CUSTODIAL SUPPLIES
348.40
01522
GRAINGER INC.
115V PEDESTAL FAN
81.09
09113
HEALY ASPHALT COMPANY,LLC.
2.19 TONS SURFACE ASPHALT MATE
120.45
4.04 TONS SURFACE ASPHALT MATE
222.20
3.65 TONS SURFACE ASPHALT MATE
200.75
543.40
08638
HELM, MARTHA
REIMB EXP 7/1/10
75.86
12355
HEREIDA, MARIA
REIMB EXP 7/26/10
56.40
11987
HOMER TREE CARE, INC
PARKWAY TREE REMOVAL CONTRACT
480.00
PARKWAY TREE REMOVAL CONTRACT
5394.00
5874.00
00107
ICMA RETIREMENT TRUST - 457
PAYROLL FOR - 072910
19094.26
06690
ILLINOIS AMERICAN WATER CO.
PRIVATE FIRE SERVICE
28.28
00108
ILLINOIS DEPARTMENT OF REVENUE
PAYROLL FOR - 072910
25756.21
01674
ILLINOIS DEPT.OF PUBLIC HEALTH
2 INITAL AMBULANCE LICENSING F
50.00
09562
IMRF
PAYROLL FOR - 072910
426.04
PAYROLL FOR - 072910
41892.68
PAYROLL FOR - 072910
19275.82
61594.54
09563
IRS
PAYROLL FOR - 072910
200068.76
00353
JANONIS, MICHAEL E.
REIMB EXP 7/26/10
42.04
02408
JOHN E. REID AND ASSOCIATES
PRE - EMPLOYMENT POLYGRAPH
200.00
01783
JOURNAL 6 TOPICS NEWSPAPERS
ADS -EXMP #136182 7/7/10
288.00
ADS -EXMP #136295 7/14/10
288.00
#136480 ADS -BLOCK PARTY 2010
735.00
#136487 ADS -BLOCK PARTY 2010
288.00
1599.00
01818
KERSTEIN, JUNE
REIMB JULY 6 AUGUST 2010
86.06
01827
KLEIN, THORPE AND JENKINS,LTD.
GENERAL LEGAL SERVICES JUNE 10
56934.09
01838
KRAMER TREE SPECIALISTS
SPRAY TREATMENTS TO CONTROL GY
66.00
01861
LANDS' END BUSINESS OUTFITTERS
BUILDING DEPT 6/11/10
141.45
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY AUG102010 15:22
RELEASE ID
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 29 2010 TO AUGUST 11 2010
----------------------------------------------------------------------------------------------------------
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION
----------------------------------------------------------------------------------------------------------
08631 LECHNER AND SONS PW UNIFORM RENTAL AND CLEANING
PW UNIFORM RENTAL AND CLEANING
12253 LELLO, SUZANNE
09584 LOGSDON OFFICE SUPPLY
01918 LUNDSTROM'S NURSERY, INC.
01960 MAROUS 6 COMPANY
05021 MENARDS
00116 METRO FEDERAL CREDIT UNION
01058 MEYER LABORATORY,INC.
02826 MICHAEL WAGNER 6 SONS, INC.
02010 MICHAELS STORE INC. 0107
02046 MOBILE PRINT INC.
11331 MOORE LANDSCAPES, INC
12362 MORATH, BEVERLY
08025 MORTON SUGGESTION CO.
02087 MUNICIPAL CLERKS OF ILLINOIS
02089 MUNICIPAL FLEET MANAGERS ASSOCIATION
11534 NAGURSKI KIDDIE RIDES, INC
CDL REIMBURSEMENT
OFFICE SUPPLIES
OFFICE SUPPLIES
LANDSCAPE MAINTENANCE AT VARIO
SERVICE MAY 2010
2 FANS FOR FRONT DESK
TAPCON SCREWS; 4 SLICE TOASTER
2 LAUNDRY SOAP
SUPPLIES
2 WAY BRASS SHUT OFF
PAYROLL FOR - 072910
CUSTODIAL SUPPLIES
CUSTODIAL SUPPLIES
CUSTODIAL SUPPLIES
COLD WATER TAP B45 -010
FRAME FOR PICTURE
#101347 BLOCK PARTY POSTERS
#101351 BLOCK PARTY POSTERS
NEWEST MEMBER POSTER
D/T HANGING BASKET MAINTENANCE
REIMB 2SQ SIDEWALK PUBLIC WALK
#245350 110 T- SHIRTS
#245331 100 PENS
ANNUAL MEMBERSHIP 2010 -2011
REGISTRATION 8/17/10
DEPOSIT OCTOBERFEST 2010
PAGE 5
AMOUNT
116.43
116.43
232.86
30.00
63.89
20.44
84.33
3111.78
3835.00
30.00
60.22
17.76
6.85
8.97
123.80
2493.48
156.87
156.87
156.89
470.63
33.26
166.48
188.18
155.20
47.20
390.58
855.00
110.00
602.69
255.73
858.42
85.00
50.00
550.00
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY AUG102010 15:22
RELEASE ID
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 29 2010 TO AUGUST 11 2010
----------------------------------------------------------------------------------------------------------
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION
----------------------------------------------------------
00123 NATIONWIDE MUTUAL INSURANCE COMPANY
02148 NEOPOST INC.
09502 NERADT ACE HARDWARE CORP.
02155 NEXTEL COMMUNICATIONS
11999 NEXUS OFFICE SYSTEMS, INC
05256 NICOR
02189 NORTHWEST CENTRAL DISPATCH SYS
02193 NORTHWEST ELECTRICAL SUPPLY
PAYROLL FOR - 072910
MONEY ENTERED INTO POSTAGE M
LIGHT BULBS
SERVICE 6/18/10 - 7/17/10
SERVICE 6/18/10- 7/17/10
SERVICE 6/18/10 - 7/17/10
SERVICE 6/18/10- 7/17/10
SERVICE 6/18/10 - 7/17/10
SERVICE 6/18/10-7/17/10
SERVICE 6/18/10- 7/17/10
SERVICE 6/18/10 - 7/17/10
SERVICE 6/18/10- 7/17/10
SERVICE 6/18/10 - 7/17/10
SERVICE 6/18/10- 1/11/10
1 -12 CURVE 8350I HANDSET KIT
SERVICE 4/14/10- 10 /14 /10
SERVICE 4/14/10 - 10/14/10
SERVICE 4/14/10- 10/14/10
SERVICE 4/14/10- 10 /14 /10
SERVICE 4/14/10- 10/14/10
SERVICE 4/14/10- 10/14/10
SERVICE 4/14/10- 10/14/10
NATURAL GAS CONSUMPTION AT 160
NATURAL GAS CONSUMPTION AT 112
NATURAL GAS CONSUMPTION AT 50
SERVICE 6/21/10 - 7/21/10
SERVICE 6%21%10 - 1/2410
SEPT 2010 MEMBER ASSESSMENT
SEPT 2010 MEMBER ASSESSMENT
54W 4FT FLUORESCENT LAMP
50 -13W CFL LAMP; 15-120W LAMP
10 - FLUORESCENT LIGHT BULBS F
PAGE 6
AMOUNT
15997.46
3000.00
23.26
655.93
102.29
94.96
518.45
183.04
27.98
1279.52
219.38
304.40
29.53
333.26
99.99
3848.73
128.20
583.28
230.76
642.52
274.71
32.97
394.94
2287.38
144.23
155.91
1555.92
31.92
31.92
110110,,
36767.60
9191.90
45959.50
81.60
168.93
144.05
394.58
05124 NORTHWESTERN UNIVERSITY CTR FOR PUBLIC SAFETY REGISTRATION 2/14/11 2100.00
10162 OVERHEAD GARAGE DOOR,INC. REPLACE 1/" KEY STOCK AT DOOR 192.95
07863 PACON CORPORATION SHIPPING CHARGE 83.10
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY AUG102010 15:22
RELEASE ID
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 29 2010 TO AUGUST 11 2010
----------------------------------------------------------------------------------------------------------
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION
----------------------------------------------------------------------------------------------------------
10366 PARK RIDGE TAXI SENIOR TAXI PROG JULY 2010
02303 PETTY CASH - FIRE DEPT. MEETING /SUPPLIES /TRAINING 7/6
MEETING /SUPPLIES /TRAINING 7/1
MEETING /SUPPLIES /TRAINING 7/20
MEETING /SUPPLIES /TRAINING 7/15
04896
PETTY CASH - MANAGER'S OFFICE
00124
POLICE PENSION FOND
04921
POPE, ELIZABETH A.
11374
PR NEWSWIRE ASSOCIATION, LLC
02536
PROFORMA CUSTOMIZED GRAPHICS
02358
PROSAFETY, INC
04359
PUBLIC AGENCY TRAINING COUNCIL
02379
QUILL CORPORATION
02390
RAMIREZ COMPOST SERVICE INC
02399
REBEL'S TROPHIES, INC.
02401
RED WING SHOE STORE
02429
RIC MAR INDUSTRIES, INC
11102 ROTARY CLUB OF MT. PROSPECT - PROSPECT HEIGHTS
12119
SCHULTZ, WALTER
02525
SECRETARY OF STATE
00429
SEMKIU, MICHAEL J.
07127
SERVICE SANITATION,INC.
04682
SERVICEMASTER
05975
SIGNS BY TOMORROW
BUDGET WORKING MEETING
PAYROLL FOR - 072910
PAYROLL FOR - 072910
WELCOME HOME LEE DEWYZE
BALLONS FOR BLOCK PARTY 2010
BALLONS FOR BLOCK PARTY 2010
288 - REPLACEMENT T- SHIRTS WIT
REGISTRATION - M.BONNER
OFFICE SUPPLIES
HAULING WOODCHIPS FROM PW YARD
RETIREMENT PLAQUE- A.FELSKC
SAFETY SHOES - MIKE HOFFMANN
5 DOZEN URINAL WAVE SCREENS; S
1 CASE OF SOY BASED GRAFFITI
ROTARY MAGAZINE
2ND QUARTER APRIL2010- JUNE2010
MEMBERSHIP- FIGOLAH 1/10 -3/10
MEMBERSHIP- FIOGOLAH 4/10 -6/10
REIMB EXP 7/26 - 7/27/10
DUPLICATE TITLE #523
REIMB EX? 7/25/10
RENTAL BLOCK PARTY 2010
PAINTING ITEMS
POSTER -LEE DEWYZE
PAGE 7
--------------- --
AMOUNT
--------------- --
122.50
30.30
34.16
40.00
22.45
126.91
137.84
26301.20
923.08
545.00
394.82
161.48
556.30
906.00
295.00
82.70
300.00
35.00
160.00
386.54
98.91
485.45
3.00
177.00
185.00
185.00
550.00
40.00
125.00
112.31
823.00
2611.20
1326.00
REPORT: APBOARDRPT
GENERATED: 15 APR 09 11:42
RUN: TUESDAY AUG102010 15:22
RELEASE ID
VILLAGE OF
MOUNT PROSPECT
LIST OF BILLS PRESENTED
TO THE BOARD OF TRUSTEES
----------------------------------------------------------------------------------------------------------
FROM JULY 29 2010
TO AUGUST 11 2010
DEPT VENDOR NBR
----------------------------------------------------------------------------------------------------------
VENDOR NAME
INVOICE DESCRIPTION
11925
SOUTHEASTERN EMERGENCY EQUIPMENT, INC
6- Boxes Tape
FREIGHT
02155
SPRINT
SERVICE 6/24/10- 7/23/10
02610
STANDARD EQUIPMENT COMPANY
(8) OEM SIDE BROOMS SWEEPERS
09165
STAPLES BUSINESS ADVANTAGE
SUPPLIES
MCAT UNIT SUPPLIES
02627
STEINER ELECTRIC CO.
EMERGENCY REPAIR SUPPLIES FOR
02660
SUBURBAN PRINTING
30 CPU POSTERS
09903
SYMBOLARTS,LLC
BADGES
04532
TAYLOR RENTAL CENTER
REPLACE DAMAGED EASY UP 10X10
02684
TERRACE SUPPLY COMPANY
BLOCK PARTY 2010
02691
THOMPSON ELEVATOR INSPECTIONS
SEMI - ANNUAL RE- INSPECTION
10011
TRIPLE CROWN SUPPLY
REPAIR OF LENDING CLOSET EQUIP
02756
UNITED STATES POSTAL SERVICE
EMS CARDS JULY 2010
00127
UNITED WAY
PAYROLL FOR - 072910
04025
UNIVERSITY OF ILLINOIS - GAR
Registration /Ricker, Jeff July
12001
US BANK
8/20/10 USAGE
8%20/10 USAGE
8/20/10 USAGE
8/20/10 USAGE
8/20/10 USAGE
8/20/10 USAGE
8/20/10 USAGE
00128 VILLAGE OF MOUNT PROSPECT
04314 VILLAGE OF MOUNT PROSPECT - PAYROLL WIRES
02835 WAREHOUSE DIRECT
02876 WILKS, IRVANA
05746 WISCTF
PAYROLL FOR - 071810
PAYROLL FOR - 072910
PAYROLL FOR - 071810
PRINTER REPAIR:PARTS&LABOR
BLACKBERRY SER 7/16/10- 8/15/10
PAYROLL FOR - 072910
PAGE 8
AMOUNT
57.50
3.61
61.11
39.99
947.12
59.51
300.00
359.51
176.23
45.00
917.50
445.00
332.88
112.00
323.50
13.42
363.79
725.00
195.00
265.00
275.00
195.00
156.00
138.78
137.50
1362.28
414.47
207.00
621.47
462.61
496.25
45.00
542.48
REPORT:
APBOARDRPT
GENERATED: 15 APR 09 11:42
RUN: TUESDAY AUG102010 15:22
PAGE 9
RELEASE ID
VILLAGE OF
MOUNT PROSPECT
LIST OF BILLS PRESENTED
TO THE BOARD OF TRUSTEES
FROM JULY 29 2010
TO AUGUST 11 2010
-----------------------------------------------------------------------------------------------------------------------------------
DEPT
-----------------------------------------------------------------------------------------------------------------------------------
VENDOR NBR
VENDOR NAME
INVOICE DESCRIPTION
AMOUNT
07562
WITHER PUBLIC SAFETY GROUP, INC
8 Smoke Machine Fluid, Pro Bea
343.92
FREIGHT
20.99
364.91
12283
Z SEARCH RECRUITING, INC
BLOCK PARTY 2010
250.00
TOTAL
574964.17
030
02270
AT &T
SERVICE 7/16/10 - 8/15/10
4.29
02107
NAPA - HEIGHTS AUTOMOTIVE SUPPLY
FORD -LEAF MACHINES AIR FILTERS
281.45
TOTAL
285.74
050
01147
COMMONWEALTH EDISON
STREETLIGHT CHARGES FROM 05/14
3646.33
04355
COOK COUNTY TREASURER
2010 TRAFFIC SIGNAL MAINTENANC
2740.50
TOTAL
6386.83
070
09381
ARCO CONSTRUCTION
SINGLE F. REHAB -319 FAIRVIEW
18610.00
12365
EVERBANK COMMERCIAL FINANCE, INC
SERVICE 7/24/10 - 8/23/10
16.80
01377
FEDERAL EXPRESS CORP
SHIPPING FOR CDBG PROG
15.80
09198
GE CAPITAL
SERVICE 7/15/10 - 8/14/10
198.94
TOTAL
18841.54
510
122242
ADVANCED LIGH'T'ING SYS'T'EMS, LLC
21 -HTS -9 LARGE FULL CUT OFF
12705.00
09380
AMERICAN BUILDING SERVICES
PROXIMITY CARD READER FOR MECH
1701.00
01049
COW GOVERNMENT, INC
EQUIPMENT FOR FRONT DESK
146.11
12359
CLEMENCY, JOHN
WEATHERIZATION REBATE FROG
1500.00
11970
NEW WORLD SYSTEMS CORPORATION
ERP SOFTWARE APPLICATIONS - VB
5460.00
ERP SOFTWARE APPLICATIONS - VB
807.88
#003911 JOAN MIDDLETON
945.00
#003912 DAVID ERB
945.00
#003913 JOAN BOKINA
945.00
9102.88
04682
SERVICEMASTER
REFINISH PUBLIC WORKS
13183.14
11241
ULTRA STROBE COMMUNICATIONS, INC
EQUIPMENT FRONT DESK REMODEL
1325.00
TOTAL
39663.13
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY AUG102010 15:22 PAGE 10
RELEASE ID
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 29 2010 TO AUGUST 11 2010
-----------------------------------------------------------------------------------------------------------------------------------
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
-----------------------------------------------------------------------------------------------------------------------------------
52 B
01049
CDW GOVERNMENT, INC
SPEAKER - STATION #14
36.82
02303
PETTY CASH - FIRE DEPT.
MEETING /SUPPLIES /TRAINING 6/15
19.53
12099
THE CDC GROUP, INC
Window Shades for Fire Station
17409.00
Window Shades for The EOC
26630.00
44039.00
02550
THE SIGN PALACE INC.
CLEANING STATION #14
950.00
TOTAL
45045.35
550
07730
ADVANCED PAVEMENT TECHNOLOGIES
BRICK PAVER SEALING CONTRACT F
20396.81
BRICK PAVER SEALING CONTRACT F
7178.60
27575.41
10729
AUTUMN LANDSCAPING INC
INSTALL COMPLETE UNDERGROUND
7760.00
INSTALL UNDERGROUND IRRIGATION
7000.00
14760.00
01827
KLEIN, THORPE AND JENKINS,LTD.
LEGAL SERVICES TIF JUNE 2010
21403.26
01918
LUNDSTROM'S NURSERY, INC.
LANDSCAPE MAINTENANCE AT VARIO
7441.22
TOTAL
71179.89
560
02343
PREFORM TRAFFIC CONTR SYS,LTD.
PAVEMENT STRIPPING.
3909.20
TOTAL
3909.20
610
01071
ADDISON BUILDING MATERIAL CO.
HYDRANT PAINTING SUPPLIES
144.78
WOOD STAKE RESTOCK
13.92
GALVANIZED HEX REDUCER BUSHING
14.85
173.55
09619
ALANIZ LANDSCAPING GROUP
TURF MOWING AT VARIOUS LOCATIO
1057.07
09380
AMERICAN BUILDING SERVICES
THREE CARD READERS FOR PW POMP
6483.00
CARD READER AND APPURTENANCES
2616.00
RELEASE OF RETAINAGE FOR
27795.00
36894.00
01620
AMERICAN LANDSCAPING INC.
SOD RESTORATION AT VARIOUS SIT
229.69
SOD RESTORATION AT VARIOUS SIT
137.61
367.50
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY AUG102010 15:22
RELEASE ID
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 29 2010 TO AUGUST 11 2010
----------------------------------------------------------------------------------------------------------
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION
00372 ANDLER, GLEN REIMB EXP 7/22/10
02270 AT &T SERVICE 7/16/10- 8/15/10
12361 B.G. CONCRETE INC REPLACE DRIVEWAY APRON -SW REP
05773 BAXTER & WOODMAN, INC. SANITARY SEWER EVALUATION STUD
PROFESSIONAL SERVICES FOR 2010
PROFESSIONAL SERVICES FOR 2010
05375 CENTURY CLEANERS
UNIFORM CLEANING7/19 &7/22 &1/26
UNIFORM CLEANING 7/24 & 7/31
UNIFORM CLEANING 7/28 & 8/2
UNIFORM CLEANING 1/31 &8 /5
UNIFORM CLEANING 7/19 0/22
12356 CHUNAG, HELEN
01323 EAST JORDAN IRONWORKS
08829 ENGLEWOOD ELECTRICAL SUPPLY
01544 HBK WATER METER SERVICE
01783 JOURNAL & TOPICS NEWSPAPERS
12330 K -PLUS ENGINEERING, LLC
10602 KRAMER DATAPOWER, INC
08631 LECHNER AND SONS
06994 LEE JENSEN SALES CO. INC.
REFUND FINAL UTILITY BILL
8' VALVE KEY FOR ROUNDED OPERA
8' VALVE KEY FOR MISSING OPERA
ROBBER VALVE BOX STABILIZER
ALLEN BRADLEY PATCH CABLES FOR
WATER METER
BUILDING INSPECTION SERVICES.
BUILDING INSPECTION SERVICES.
WATER METER
WATER METER
BUILDING INSPECTION SERVICES.
WA'T'ER ME'T'ER
BUILDING INSPECTION SERVICES.
SUBSCRIPTION RENEWAL 2010 -2011
CONTAMINATED SOIL HAULING CHAR
POWERWARE 9120 / 700VA UPS SYS
SHIPPING CHARGE PO #SO11326
PW UNIFORM RENTAL AND CLEANING
PW UNIFORM RENTAL AND CLEANING
633 F4 POWER GRIT CHAIN SAW FO
POWER GRITT CHAIN FOR CUTTING
PAGE 11
AMOUNT
50.00
286.42
2304.00
1080.00
11255.10
7503.40
19838.50
41.33
56.55
37.48
24.58
23.93
183.87
86.98
500.00
250.00
240.00
990.00
298.00
821.85
273.95
329.90
989.70
644.70
214.90
1303.38
389.85
4968.23
28.00
341.25
1440.00
39.27
1479.27
116.41
116.41
232.82
1900.00
340.00
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY AUG102010 15:22 PAGE 12
RELEASE ID
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 29 2010 TO AUGUST 11 2010
-----------------------------------------------------------------------------------------------------------------------------------
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
-----------------------------------------------------------------------------------------------------------------------------------
16" GUIDER BAR FOR CUTTING SAW 26.00
16" GUIDER BAR FOR CUTTING SAW 169.00
35 GALLONG WATER TANK WITH 295.00
2730.00
01965 MARTAM CONSTRUCTION HAULING, DISPOSAL AND BACKFILL 4292.77
05021 MENARDS 4X8X3/4 B.C. GRADE PLYWOOD 1636.11
8' 2X4 63.68
CORRECTION MADE ON INVOICE DUE 2.55 -
CONSTRUCTION LUMBER 48.25
1745.49
04661 NATIONAL POWER BUDDING CORP. HUNTINGTON LIFT STATION CLEANI 3100.00
FAIRVIEW LIFT STATION CLEANING
2813.75
FAIRVIEW LIFT STATION CLEANING
686.25
6600.00
02155
NEXTEL COMMUNICATIONS
SERVICE 6/18/10 - 7/17/10
495.06
SERVICE 6/18/10 - 7/17/10
52.70
547.76
11999
NEXUS OFFICE SYSTEMS, INC
SERVICE 4/14/10- 10/14/10
394.92
05256
NICOR
NATURAL GAS CONSUMPTION AT SS
82.59
NATURAL GAS CONSUMPTION AT 112
82.59
NATURAL GAS CONSUMPTION AT 117
82.68
247.86
02358
PROSAFETY, INC
288 - REPLACEMENT T-SHIRTS WIT
906.00
0833 -1 1
RICK'S SEWER AND DRAINAGE
FOO'T'ING 'PILE DISCONNECT s OH S
13350.00
FOOTING TILE DISCONNECT & OH S
15025.00
28375.00
02655
SUBURBAN LABORATORIES, INC.
ANNUAL IEPA-REQUIRED WATER SAM
341.77
ANNUAL IEPA - REQUIRED WATER SAM
128.23
470.00
04838
THIRD MILLENNIUM ASSOC.INC.
JULY 2010 UTILITY BILLING
1227.99
02722
TRI -STATE ELECTRONIC CORP
STATION 5 VFD TROUBLE SHOOTING
27.32
02756
UNITED STATES POSTAL SERVICE
PERMIT 699 -WATER JULY 2010
2206.02
12001
US BANK
8120110 USAGE
137.50
02914
ZIEBELL WATER SERVICE PRODUCTS
2 - 12" MUELLER HYDRANT EXTENS
782.00
2 - 18" MUELLER HYDRANT EXTENS
860.00
20 - MJ GLANDS
279.00
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY AUG102010 15:22
DEPT VENDOR NBR
-------------- - - - - --
RELEASE ID
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 29 2010 TO AUGUST 11 2010
--------------------------------------------------------------------------------
VENDOR NAME INVOICE DESCRIPTION
--------------------------------------------------------------------------------
20 - MJ GASKETS
120 - 3/4" MJ T -HEADS BOLTS
TOTAL
620
630
660
PAGE 13
--------------- -- --
AMOUNT
--------------- - - --
70.00
126.00
2117.00
121605.09
05503
CRYSTAL MAINTENANCE SERVICES CORP.
CUSTODIAL SERVICE AT VILLAGE
6.44
CUSTODIAL SERVICE AT VILLAGE
1481.40
1487.84
TOTAL :
1487.84
05503
CRYSTAL MAINTENANCE SERVICES CORP.
CUSTODIAL SERVICE AT VILLAGE
0.82
CUSTODIAL SERVICE AT VILLAGE
189.16
189.98
05256
NICOR
SERVICE 6/23/10 - 7/22/10
30.74
TOTAL
220.72
07423
ALEXANDER EQUIP.CO.,INC.
CHIPPER BLADES
278.30
02796
ALPHA PRIME COMMUNICATIONS
CELL PHONE HOLSTERS
164.15
09676
AMERICAN MESSAGING
MESSAGING SERVICES FROM
46.20
02070
ARLINGTON HEIGHTS FORD
A/C VALVE FOR 2729
8.16
615 & STOCK AIR BAG LIGHT ASSY
67.08
OEM AC COMPRESSOR & ORFICE TUB
532.57
HEADLIGHT
72.87
FUEL INJEC'T'OR FOR 'TRUCK #4542
31.12
712.40
02108
ARLINGTON POWER EQUIPMENT
TUBE BREATHER FOR #AT-67
5.85
GROMMET FOR AT -67 TAMPER
2.94
GROMMET FOR AT -67 TAMPER
3.09
SIDE ENGINE GASKETS FIR #4555
5.22
17.10
02270
AT &T
SERVICE 7/16/10 - 8/15/10
10.73
02938
BOWMAN DISTRIBUTION CENTER
SHOP SUPPLIES
480.79
10632
CHICAGO PARTS & SOUND LLC
COOLING FAN ASSY & RELAY FOR C
377.85
01236
DAVE & JIM'S AUTO BODY, INC.
FRONT END ALIGNMENT FOR TRUCK
50.00
FRONT END ALIGNMENT FOR P -55
95.04
145.04
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY AUG102010 15:22
RELEASE ID
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 29 2010 TO AUGUST 11 2010
---------------------------------------------------------------------------------------------------------------
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION
08154 GLOBAL EMERGENCY PRODUCTS OEM A/C COMPRESSOR FOR FIRE TR 715.13
01914 LUND INDUSTRIES, INC. BULBS FOR LIGHT BAR FOR P -17 30.50
12200 MARTIN IMPLEMENT SALES, INC LOWER SEAT CUSHION FOR VEHICLE 226.70
01990 MCMASTER -CARR SUPPLY CO. A/C TANK FOR NEW R134A RECYCLE 89.83
05021 MENARDS SHOP SUPPLIES 83.41
05941 MOBILE CONCEPTS BY SCOTTY F.D. SAFETY HOUSE TRAILER CANO 187.00
11367 NAPA OF DES PLAINES RADIUS ARM BUSHING FOR FIRE TR 13.49
02107 NAPA-HEIGHTS AUTOMOTIVE SUPPLY NAPAGOLD OIL FILTERS FOR CHEVY 55.44
NAPAGOLD OIL FILTERS FOR CHEVY 55.44
LOWER BALL JOINT P -55 69.14
SS HOLD DOWN NUTS FOR NEW AMBU 33.80
A/C HIGH PRESSURE CUT -OUT SWIT 27.06
LEFT SIDE BALL JOINTS FOR #273 108.98
LED MARKER LIGHTS FOR FIRE TRU 26.94
SHOP SUPPLIES 13.68
TRAILER ADAPTERS 53.24
WEATHERSTRIP ADHESIVE FOR FIRE 15.36
459.08
240.12
18.97
438.21
7.07
109.76
177.35
21.31
300.00
149.95
90.96
24.92
153.93
269.81
258.84
6029.09
02155
NEXTEL COMMUNICATIONS
SERVICE 6/18/10- 7/17/10
02195
NORTHWEST FORD TRUCK CENTER
FUEL FILTER ; SIDE GASKET & OR
02327
POMP'S TIRE SERVICE, INC.
REPAIR 6 REPLACE 2 INT. DUMP T
07663
PRAIRIE INTERNATIONAL TRUCK SALES
FUEL PIPE FOR TRUCK #4527A
07882
PRECISION SERVICE & PAR'I'S
FUEL FILTERS FOR STRUCK 6 FIRE
01191
R.L. CORTY d COMPANY
WASH BAY POMP (SOAP)
09423
RONCO INDUSTRIAL SUPPLY
GRINDING BELTS
02581
SOLVENT SYSTEMS INT'L. INC.
PARTS WASHER RENTAL
02601
SPRING ALIGN OF PALATINE, INC
FRONT END ALIGNMENT FOR TRUCK
02684
TERRACE SUPPLY COMPANY
GAS FOR WELDER
GAS TANK RENTAL
6" DA DISCS
02791 VEHICLE MAINTENANCE PROGRAM INC. 6 - SNOW PLOW LIGHT KITS FOR S
TOTAL
PAGE 14
--------------- -
AMOUNT
---------- - - - - --
X1
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY AUG102010 15:22
RELEASE ID
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 29 2010 TO AUGUST 11 2010
-----------------------------------------------------------------------------------------------------------
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION
-----------------------------------------------------------------------------------------------------------
02070 ARLINGTON HEIGHTS FORD 2 NEW AMBULANCE IGNITION KEYS
01522 GRAINGER INC. SECURITY SAFE AMBULANCE #525 -26
06403 LINDCO EQUIPMENT SALES, INC. 3- PRE -WET MOTOR ENCLOSURE.
3- PRE-WET PLUMBING KIT.
2 - ROOT FS 10' UNDERBODY SCRA
FREIGHT - NEW TRUCKS #2755; #2
02064 MOTOROLA, INC.
11241 ULTRA STROBE COMMUNICATIONS, INC
680
02791 VEHICLE MAINTENANCE PROGRAM INC
05005 CDS OFFICE TECHNOLOGIES
4 - Vehicle Radio Chargers for
#6107 REMOVAL &REINSTALL #P -19
#6150 REMOVAL &REINSTALL #P -20
#6141 REMOVAL &REINSTALL #P -7
16108 REMOVAL &REINSTALL #P -3
#6263 REMOVAL &REINSTALL #P -6
#6140 REMOVAL &REINSTALL #P -7
#6149 REMOVAL &REINSTALL #P -7
#6266 REMOVAL &REINSTALL #P -11
#6185 REMOVAL &REINSTALL #P -14
#6190 REMOVAL &REINSTALL #P -18
6 - SNOW PLOW LIGHT KITS FOR S
TOTAL
PANASONIC TOUGHBOOK 31 W/ i5 -5
DOCKING STATION W/ ANTENNA, PO
TOTAL
690
01335 ALEXIAN BROTHERS CORPORATE HEALTH SERVICES
INV #369141 W.SCHULTZ- DOI:6 /21
INV #369833 W.SCHULTZ- DOI:6 /21
10051 CCMSI
05943 IL DEPT. OF EMPLOYMENT SECURITY
12158 THE CIMA COMPANIES, INC
W/C REIMBURSEMENT 8/4/10
UNEMPLOYMENT BENEFITS -2ND QTR
INV #261488 8 /l /10- 1/1/11
INV #261512 8/1/10- 7/1/11
INV #261522 8 /1/10 - 7/1/11
INV #261487 8/1/10- 7 /1 /11
TOTAL
PAGE 15
AMOUNT
21.06
421.20
3675.00
204.11
5748.76
450.00
10077.87
1076.40
1275.00
1452.69
41.10
1275.00
1345.45
1295.55
89.99
1345.45
1338.50
1352.40
10811.13
517.68
22925.34
12216.00
2046.00
14262.00
14262.00
140.13
364.33
504.46
27302.00
4620.00
754.87
359.23
1259.85
135.00
2508.95
34935.41
REPORT:
APBOARDRPT
GENERATED: 15 APR 09 11:42
RUN: TUESDAY AUG102010 15:22
PAGE 16
RELEASE ID
VILLAGE OF
MOUNT PROSPECT
LIST OF BILLS PRESENTED
TO THE BOARD OF TRUSTEES
-----------------------------------------------------------------------------------------------------------------------------------
FROM JULY 29 2010
TO AUGUST 11 2010
DEPT
VENDOR NBR
VENDOR NAME
INVOICE DESCRIPTION
AMOUNT
-----------------------------------------------------------------------------------------------------------------------------------
110
01460
ARTHUR J. GALLAGHER RMS,INC.
#499716 8/1/10 - 8/1/11
9061.00
12000
MESIROW FINANCIAL INVESTMENT MANAGEMENT, INC SERV PERIOD 4/1/10- 6/30/10
4753.58
07263
RICHARD REINER 6 ASSOC.,LLC.
LEGAL SERVICES JUNE 2010
1293.70
04890
SEGALL BRYANT 6 HAMILL
POLICE PENSION APR- JUNE2010
7733.56
00128
VILLAGE OF MOUNT PROSPECT
PAYROLL FOR - 071710
18695.51
04314
VILLAGE OF MOUNT PROSPECT - PAYROLL WIRES
PAYROLL FOR - 071710
30758.48
TOTAL
72295.83
720
01460
ARTHUR J. GALLAGHER RMS,INC.
#499719 8/1/10 - 8/1/11
10378.00
04890
SEGALL BRYANT 6 HAMILL
FIRE PENSION APR2010- JUNE2010
7861.04
00128
VILLAGE OF MOUNT PROSPECT
PAYROLL FOR - 071610
11513.51
04314
VILLAGE OF MOUNT PROSPECT - PAYROLL WIRES
PAYROLL FOR - 071610
23770.66
TOTAL
53523.21
770
08178
GUARDIAN
EMP DENTAL PLAN AUGUST 2010
8092.69
TOTAL
8092.69
790
01719
NCPERS GROUP LIFE INS.
PREMIUM AUGUST 2010
752.00
PREMIUM AUGUST 2010
16.00
768.00
02689
THIRD DISTRICT CIRCUIT COURT
BOND MONEY 7/29/10
200.00
BOND MONEY 8/3/10
1150.00
BOND MONEY 8/5/10
650.00
BOND MONEY 8/10/10
2450.00
4450.00
02886
WISCONSIN DEPARTMENT OF REVENUE
WISC. INCOME TAX JULY 2010
524.75
TOTAL
5742.75
GRAND TOTAL
1101395.82
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY AUG102O1O 15:22 PAGE 17
RELEASE ID
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM JULY 29 2010 TO AUGUST 11 2010
----------------------------------------------------------------------------------------------------------------------------------
SUMMARY BY FOND
-----------------------------------------------------------------------------------------------------------------------------
001
GENERAL FOND
574964.17
030
REFUSE DISPOSAL FOND
285.74
050
MOTOR FUEL TAX FOND
6386.83
070
COMMUNITY DEVELPMNT BLOCK GRNT
18841.54
510
CAPITAL IMPROVEMENT FUND
39663.13
528
SERIES 2009 CONST FOND
45045.35
550
DOWNTOWN REDEVLPMNT CONST
71179.89
560
STREET IMPROVEMENT CONST FUND
3909.20
610
WATER AND SEWER FOND
121605.09
620
VILLAGE PARKING SYSTEM FUND
1487.84
630
PARKING SYSTEM REVENUE FOND
220.72
660
VEHICLE MAINTENANCE FUND
6029.09
670
VEHICLE REPLACEMENT FOND
22925.34
680
COMPUTER REPLACEMENT FOND
14262.00
690
RISK MANAGEMENT FUND
34935.41
710
POLICE PENSION FOND
72295.83
720
FIRE PENSION FOND
53523.21
770
FLEXCOMP ESCROW FUND
8092.69
790
ESCROW DEPOSIT FOND
5742.75
TOTAL : 1101395.82
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RON: TUESDAY AUG102010 15:22 PAGE 1
REPORT PARAMETERS
- - - - -- ---- - - - - --
------ ---- - - - - --
ORGANIZATION NO. 001
STARTING CHECK DATE : 01/29/10
ENDING CHECK DATE 08/11/10
STARTING BANK 1
ENDING BANK 1
SEGMENT NUMBER TO SORT BY : 01
STARTING ACCOUNT SEGMENT NUMBER: ALL
ENDING ACCOUNT SEGMENT NUMBER ALL
RELEASE LEVEL
08/10/ ;0 a o
Villa f Mount Prospect
EMR025 g p
List of Escrow Checks Presented to the Board of Trustees
08111 /10 To 08/11 /10
Paid to
Permit #
Check #
Amount
ALL TEMP HEATING & A/C
101040
13023796
75.00
ALLIED AC & HEATING CORP
091033
13023797
125.00
100014
13023798
75.00
101248
13023799
125.00
325.00
ALTOBELLI, VINCENT
101403
13023800
125.00
ANGEL'S CEMENT
101386
13023801
200.00
BERKLEY, ROBERT
100794
13023802
200.00
BETTER SIGN SERVICE
100984
13023803
125.00
C & K ENGINEERING
101295
13023804
75.00
CHASE, RICHARD
100668
13023805
150.00
CHIVINI, CARMEN J
101172
13023806
200.00
CIESIELSKI, EDWARD
101484
13023807
200.00
DIZON, MANUEL B
101046
13023808
125.00
FARRER, EDWARD M
101476
13023809
125.00
FLUSH SEWER & DRAINAGE
101113
13023810
125.00
101339
13023811
125.00
250.00
FOUR SEASONS
101427
13023812
75.00
FOUR SEASONS INC
091464
13023813
75.00
FRANCE, EDWARD E
101065
13023814
125.00
H &K HEATING & A/C
101304
13023815
125.00
HAJ- AHMAD, MOHD
101443
13023816
125.00
HERKERT JR, EDWARD
101461
13023817
125.00
HIRZ, TIMOTHY
082330
13023818
100.00
IBBOTSON HEATING CO
100318
13023819
75.00
101328
13023820
125.00
101428
13023821
125.00
325.00
JOSEPH LANDSCAPE & BRICK PAVING
100822
13023822
200.00
KLEES ELECTRIC
101365
13023823
125.00
LASKER, SIDDIQUR
101456
13023824
125.00
LUONGO, FRANK
101264
13023825
100.00
M LOPEZ CONCRETE INC
101316
13023826
200.00
MILEWSKI, JANUSZ
101418
13023827
125.00
PARVIN CLAUSS SIGN COMPANY
100179
13023828
75.00
PELLICORE, RAY
092207
13023829
100.00
PENCO ELECTRIC INC
101286
13023830
75.00
R &D CONSTRUCTION
101322
13023831
200.00
ROSEAN, ANNE J
100017
13023832
125.00
SCHIRO, CATHLEEN
100690
13023833
150.00
SHREE SAI RAM INC
100241
13023834
650.00
SNEEDEN, KIRK
101251
13023835
75.00
TOPPEL, JOAN
101021
13023836
200.00
VIKING PLUMBING
090879
13023837
125.00
Page 1
Village of Mount Prospect Page
EM R025
EMO25
List of Escrow Checks Presented to the Board of Trustees
08/11/10 To 08/11110
Paid to Permit #
Check #
Amount
101424
13023838
125.00
250.00
WALDRON, LINDA 100757
13023839
125.00
* ** TOTAL NUMBER OF CHECKS 44 6,150.00