HomeMy WebLinkAbout3. FINANCIAL REPORT & BILLS 09/21/2010 Mount t Pr spec t
Village of Mount Prospect
Mount Prospect, Illinois
INTEROFFICE MEMORANDUM
TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES
FINANCE COMMISSION
FROM: FINANCE DIRECTOR
DATE: SEPTEMBER 16, 2010
SUBJECT: MONTHLY FINANCIAL REPORT — AUGUST 2010
Attached hereto are the cash position and investment statements of the Village for the month ended
August 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 Escrow Funds. The Escrow Deposit Fund accounts for refundable deposits held by the
Village to ensure completion of public improvements. The Flexcomp Escrow Fund accounts for
employee payroll deductions pursuant to a Section 125 flexible compensation plan. The Special
Service Area Fund and Library Bonds Escrow Fund accounts for the accumulation of monies for
debt service payments.
Governmental and Enterprise Funds - Cash and cash equivalents at July 31 were $25.1 million.
During August, cash receipts totaled $4,153,262.23. In addition investment income for the month
was $5,894.17 and outflows due to Interfund activity removed $266,638.44 from the balance.
Additional reductions in cash and cash equivalents during August totaled $4,126,980.84. Of this
amount, payments to vendors were $3,129,854.69, employee payroll and related expenses were
$998,299.56 and other receipts were $1,173.41. Cash and cash equivalents at August 31 were
$24.8 million.
Monthly Financial Report — August 2010
September 16, 2010
Page 2
There were no funds held in investments during the month of August. Funds were held in cash
money market accounts that currently earn competitive rates of interest.
Total cash and investments for Governmental and Enterprise Funds at July 31 were
$25,053,136.36. Cash and investments at August 31 totaled $24,818,673.48. This is a decrease of
$234,462.88.
Trust and Agency Funds - Cash and cash equivalents at July 31 were $3.7 million. During August,
cash receipts totaled $184,423.35. In addition investment income for the month was $389,502.39
and inflows due to Interfund activity totaled $266,638.44. There was also a net increase in cash due
to investment activities of $1,200,347.29. Reductions in cash and cash equivalents during August
totaled $697,035.75. Of this amount, payments to vendors were $185,002.90, employee payroll and
related expenses were $488,721.80, payments related to the flexible spending program totaled
$21,525.66. Other disbursements were $1,785.39. Cash and cash equivalents at August 31 were
$5,076,909.91 million.
Total investments at August 31 were $76,763,711.31, a decrease of $759,533.16 from July 31,
2010. There were unrealized investment gains of $440,814.13 and a transfer to cash of
$1,200,347.29 that accounted for the change.
Total cash and investments for Trust and Agency Funds at July 31 were $81,256,278.66. Cash and
investments at August 31 totaled $81,840,621.22. This is an increase for the month of $584,342.56.
Summary of Cash Activity by Fund Type (page 2)
This report provides a breakdown of the cash activity for the month broken down by fund type. This
breakdown is useful in identifying where the activity (receipts and disbursements) is occurring.
There are times during the year when activity in certain funds such as the capital improvement and
special revenue funds is higher than normal. This will distort the financial picture of some of the
other components of the governmental funds such as the General Fund which tends to be more
level and predictable in terms of spending and receipt of revenue. Each month the report will
provide detail explanation on activity of the General Fund, the Village's primary operating fund. The
report will also provide additional information on fund types that experienced higher than normal
activity for the month. Each of these is highlighted below.
General Fund — Cash and cash equivalents at July 31 totaled $3,865,370.82. During August, cash
receipts totaled $2,581,515.27 and investment income was $3,710.03. Significant cash receipts
included sales taxes, state income tax and telecommunication tax.
Sales tax revenues for the month totaled $939,005. Of this amount, $846,179 was generated
from the 1% state portion while $92,826 was generated from the .25% home rule portion. The
state portion showed an increase of 18.9% from last year same time. The home rule portion
also grew from the prior year by 9.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 August are for May 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.
H:\ACCT\Treasurer's Report\2010 \Monthly Financial Report\Monthly Cash Position Report - August 2010.doc
Monthly Financial Report — August 2010
September 16, 2010
Page 3
State income tax receipts for August totaled $424,994 and were for the month of April. The
state remains 4 months in arrears in remitting these taxes to the Village. The total amount in
arrears is approximately $1.7 million.
Telecommunication tax receipts for August reflect May activity. Total receipts for the month
were $247,304. Year to date receipts are running 1.5% higher than 2009.
Disbursements from the General Fund for August included payments to vendors of $950,238.60 and
payments for employee wages and benefits of $800,278.44. Interfund transfers of $686,369.75 for
health premiums and vehicle lease and maintenance payments were also made during August.
Cash and cash equivalents at August 31 were $4,012,215.54. There were no investments in the
General Fund at August 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 August 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, Sega!!
Bryant and Mesirow Financial. Sega!! Bryant holds approximately half of the fixed income
investments for the two pension funds while Capital Gains and Mesirow manage the balance of
fixed income investments for these two funds. Each manager maintains a small portion of their
portfolio in cash to help facilitate liquidity and trading.
Investments in equities consist of mutual funds spread across various sectors (small, mid and large -
cap stocks) as well as investment philosophies (value, core and growth). The pension funds also
have a small portion of their portfolio invested in international stocks. Each year the investment mix
is evaluated for optimal diversification to meet the pension funds investment policy goals and
objectives. Below is a breakdown of how the pension fund portfolios are invested.
H:\ACCT\Treasurer's Report\2010 \Monthly Financial Report \Monthly Cash Position Report - August 2010.doc
Monthly Financial Report — August 2010
September 16, 2010
Page 4
Maturity Purchase Financial Investment CUSIP/ Interest Market Weighted
Date Date Institution Description Acct # Rate % Value Avg Yield
POLICE PENSION FUND (7101
Various Various Wells Fargo Wells Fargo Investments Various Various 20,760,099.71
Various Various Various Mutual Fund Investments Various Various 17,185,687.56
37,945,787.27
FIRE PENSION FUND (720)
Various Various Wells Fargo Wells Fargo Investments Various Various 22,366,330.98
Various Various Various Mutual Fund Investments Various Various 16,451,593.06
38,817,924.04
TOTAL TRUST AND AGENCY FUND INVESTMENTS $ 76,763,711.31
Investment of the Village's pension funds is governed by an Investment Policy adopted by each
Pension Board.
Conclusion
As mentioned earlier, this cash position report is intended to provide a snapshot of the Village's
cash position as of a particular month end date. Over time, this report will be able to provide trend
information to help in cash management duties, maximizing investment earnings while ensuring
availability of funds to meet the Village's commitments. The cash position report will be provided to
the Village Board and Finance Commission on a monthly basis moving forward.
)
H:\ACCT\Treasurer's Report\2010 \Monthly Financial Report\Monthly Cash Position Report - August 2010.doc
VILLAGE OF MOUNT PROSPECT
Preliminary Cash and Investment Position Report - All Funds
For the Month Ended August 31, 2010
GOVERNMENTAL AND ENTERPRISE FUNDS
Cash and Cash Total Cash and
Equivalents Investments Investments
Balance at July 31, 2010 $ 25,053,136.36 $ - $ 25,053,136.36
Cash receipts 4,153,262.23 4,153,262.23
Investment income 5,894.17 5,894.17
Transfers from investments to cash - - -
Transfers to investments from cash - - -
Interfund activity (266,638.44) (266,638.44)
Disbursements:
Accounts payable (3,129,854.69) (3,129,854.69)
Payroll (998,299.56) (998,299.56)
Other 1,173.41 1,173.41
Balance at August 31, 2010 $ 24,818,673.48 $ - $ 24,818,673.48
TRUST AND AGENCY FUNDS *
Cash and Cash Total Cash and
Equivalents Investments Investments
Balance at July 31, 2010 $ 3,733,034.19 $ 77,523,244.47 $ 81,256,278.66
Cash receipts 184,423.35 184,423.35
Investment income (loss) 389,502.39 440,814.13 830,316.52
Transfers from investments to cash 5,403,552.37 (5,403,552.37) -
Transfers to investments from cash (4,203,205.08) 4,203,205.08 -
Interfund activity 266,638.44 266,638.44
Disbursements:
Accounts payable (185,002.90) (185,002.90)
Payroll (488,721.80) (488,721.80)
Flex spending (21,525.66) (21,525.66)
Other (1,785.39) (1,785.39)
Balance at August 31, 2010 $ 5,076,909.91 $ 76,763,711.31 $ 81,840,621.22
* Assets are restricted in purpose and do not represent discretionary assets of the government.
1
•
I(1 C)
0uO C) 0 0 00 C C ( C N D c` 0
• 0 ui CO CV ui 0 _ 0 r - Ci ' 0 0 It
J 0 0) u) 0 `-- N N u) CO CO CO •— 0)
< CD C) u) N CCD u) O co to V• N 1 N
V
1- 0 N. 1. C) l) I. • t!) (O N- C) O)
0 co 0 0 0 N CO 0) NI co CO ID
F - I` c`) co V' N V: CO CO CO N. (D
0 V• u) V' o 0 c7 (0 0 c0
N — N . 0 CO � 0
N N
co > - 0 0 0 0 0 ) CV 0 C CO CO 6- T. a-
co 0 Z M 0 0 ' N CO 0 N I 16 N. n
Z cc IL LO V: N. LO u) CO CO
0 C . U' Z N c m `- 0.1 .. (4) 0 D)
u_ W Q C) co C)
Z • 0 Q EA vs
W
Q 0) n 10 n c0 V' 0 0 V' 0) CV u)
O C) Ch r C) O •• 00 •- I` CO CO CO O
Z O CO ui o-- co N to C) I- 4 ' 0 0 co
< Q U Z 0 Ni- 0 0) u) 0 CO N 0 co co 0 V
CO H 0 V• Ill N 0 I V' 0 •• N I'- P
y w" 0 a co : NCO CO N
0 d' 0 Z V C)V'N v f` Co I u)
cc l.L O W N CO V C) c ' 4' (0 00
es 01
W CD 5 co (0 ( '4 -• v v u v V.
• CO N V" CO C) CO V" C) {',
0— 0) � Nco C NCO C CO
w 0 1 u) CO 0 N 00 al JZ Z O.- N 0) 6- 0 10
O w LL N N N
F-
Z
Q C» yr
0 CD O co t0 0 6 V
J 0 0 I'- N N CV N- u) N
Q 0 n V" � 0 CO ' co LO 0) 0)
Zu_ 00N V CD NN CO CO
W W co o { R Ij V O 0
F- U O N 10 CO
Z > o 0 0
w u3 CA
a) m
0
O 4-- 0
w C c - w 1 CO 0 t 0) 0 0 0 10 ID
� vuiao 0 0 0
0) u (n m (4) o co v ` O In LO ID
o
0' N c' N N N
0' S 7 Z etZ N:' O O u) U) n 1`
d Z` U 4'- L W 00 N 1 W co
1- . 5 Q W Z u_ v V- of
M i) N c0 w
CC CA f9
W w 0
0 U - w 0 N.- co 0) co c)
c O) O 0 N 6 -
W O o Z - -4 N N � ^ O CO 4 4 4
Q Z w F U p CO co N n co c"
ma) o w
5 Ew Z Q <0 c v t) 0) m
5 7 _I 0d LL V' C') C1
m Q
F- 69- 110
Z
W CO
Z IL rA .7 CO r r
U
CO U y j c o`oo n n c
F 4" o o
m o
w a)
1 I w
CO In V' r 0 o 0
I-- 10
u) O N N C CV C) M N
Jw III ' ' ' 6) V 0 W N
N
0Z0 V"NC) CO v0) N 1" N
2
,_ co v co 0) 0) N
m w u_ co
69 N N
V
N
0 ' '
Z O N O N O 0. F.) R C '4) er d
• 0110 ' ' ' 0 co La of N
J C) u) I. CO V` N N N N a)
< • C0 10 CO ' 0 1 0 0 N N Q.
N
CU 0 u) CO CO 0)) 0 O
Z 0 (Ni V' ? o
W C
0 U3 C9
L
W es
o I-
C0 •0 T W 0
4- z Q h D.
W nN
J c ° w
2 fA a) _ C 0 N „
E c a o z v
N N Q c c Z E 4) d
co o a) a) > '' o 3 Q 2 O_ S. Z
W 0 h CO Z
C o - > m m y >> C Q
I N U C N N .. co w U F- c c a) _
Q 0 n ° o a N N a m w u o i W C E Q m
N
• d w m C co co N N aJ a > 0 w 2
x , 0 f a) N N ,2 3 7 7 7 c W� I — ° 3 C a W
Qm ca > 2,m) m' n N � c > 0 CD 0 0 <
OmO51- I -Eoo00 w ?0 2 1- I_ .
VILLAGE OF MOUNT PROSPECT
STATEMENT OF INVESTMENTS
As of August 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 August 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 20,760,099.71
Various Various Various Mutual Fund Investments Various Various 17,185,687.56
37,945,787.27
FIRE PENSION FUND (720)
Various Various Wells Fargo Wells Fargo Investments Various Various 22,366,330.98
Various Various Various Mutual Fund Investments Various Various 16,451,593.06
38,817,924.04
TOTAL TRUST AND AGENCY FUND INVESTMENTS $76,763,711.31
* 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— August 31, 2010
09/16/2010 VILLAGE OF MOUNT PROSPECT 8 Months ( 66.6% ) Completed
10:15:22 4 Months ( 33.3% ) Remaining
Budget Revenue Summary
01/01/10 - 08/31/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
REVENUE BY CLASSIFICATION
PROPERTY TAXES 159 7,768,966 14,999,000 7,230,034 48.2
OTHER TAXES 920,932 7,060,707 15,665,000 8,604,293 54.9
LICENSES, PERMITS & FEES 479,650 2,727,084 3,487,000 759,916 21.8
INTERGOVERMENT REV. 1,469,146 7,696,181 18,102,647 10,406,466 57.5
CHARGES FOR SERVICE 1,821,959 13,127,341 21,970,880 8,843,539 40.3
FINES AND FORFEITS 94,428 395,117 704,000 308,883 43.9
INVESTMENT INCOME 741,496 620,687 5,696,250 5,075,563 89.1
REIMBURSEMENTS 16,888 200,738 467,000 266,262 57.0
OTHER REVENUE 256,692 3,716,191 7,023,160 3,306,969 47.1
OTHER FINANCING SOURCES 1,024 2,551 1,023,505 1,020,954 99.8
Total A11 Funds 5,802,374 43,315,563 89,138,442 45,822,879 51.4
REVENUE BY FUND
GENERAL FUND 2,644,842 19,966,387 40,691,100 20,724,713 50.9
REFUSE DISPOSAL FUND 251,623 2,480,271 4,038,500 1,558,229 38.6
MOTOR FUEL TAX FUND 122,338 863,635 1,836,500 972,865 53.0
LAW ENFORCEMENT BLOCK GRANT 0 0 0 0
COMMUNITY DEVELPMNT BLOCK GRNT 0 204,921 565,447 360,526 63.8
ASSET SEIZURE FUND 9,282 15,906 6,000 -9,906 -165.1
DEA SHARED FUNDS FUND 6 33 1,500 1,467 97.8
DUI FINE FUND 1,307 7,822 20,500 12,678 61.8
FOREIGN FIRE TAX BOARD FUND 9,694 30,216 35,500 5,284 14.9
SERIES 1987A B &I, PW FACILITY 0 0 0 0
SERIES 2001 B &I, VILLAGE HALL 1 2 379,000 378,998 100.0
SERIES 2003 B &I, VILLAGE HALL -39 499,082 904,000 404,918 44.8
SERIES 2009 B &I, FD /PW -211 228,276 414,000 185,724 44.9
2009B B &I, FD /PW -536 54,533 0 - 54,533
2009C B &I, FD /PW 146 66,046 0 - 66,046
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 85,053 381,550 1,140,708 759,158 66.6
SERIES 2000 B &I, FLOOD CONTROL 0 0 0 0
SERIES 2002B B &I, FLOOD 0 0 0 0
CAPITAL IMPROVEMENT FUND 85,517 400,671 1,421,500 1,020,829 71.8
SERIES 2009 CONST FUND 0 24,644 1,124,505 1,099,861 97.8
DOWNTOWN REDEVLPMNT CONST 4,783 1,234,288 2,567,000 1,332,712 51.9
STREET IMPROVEMENT CONST FUND 119,027 1,008,332 1,717,600 709,268 41.3
FLOOD CONTROL CONST FUND 8,927 96,762 198,792 102,030 51.3
WATER AND SEWER FUND 825,868 6,600,965 12,225,500 5,624,535 46.0
VILLAGE PARKING SYSTEM FUND 10,303 76,884 152,000 75,116 49.4
PARKING SYSTEM REVENUE FUND 12,638 91,426 159,500 68,074 42.7
VEHICLE MAINTENANCE FUND 137,369 1,099,036 1,654,192 555,156 33.6
VEHICLE REPLACEMENT FUND 14,585 76,170 238,200 162,030 68.0
COMPUTER REPLACEMENT FUND 130 951 12,000 11,049 92.1
RISK MANAGEMENT FUND 625,278 4,525,006 6,865,098 2,340,092 34.1
POLICE PENSION FUND 422,332 1,628,883 5,585,500 3,956,617 70.8
FIRE PENSION FUND 412,111 1,652,862 5,184,300 3,531,438 68.1
SSA #6 GEORGE /ALBERT B &I 0 3 0 -3
GENERAL FIXED ASSETS ACCT GP 0 0 0 0
1
09/16/2010 VILLAGE OF MOUNT PROSPECT 8 Months ( 66.6t ) Completed
10:15:22 4 Months ( 33.3$ ) Remaining
Budget Revenue Summary
01 /01 /10 - 08/31/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
Total All Funds 5,802,374 43,315,563 89,138,442 45,822,879 51.4
2
09/16/2010 8 Months ( 66.61 ) Completed
oe VILLAGE OF MOUNT PROSPECT 4 Months ( 33.31 ) Remaining
FR
FRRB RR03
SUMo21 Budget Revenue by Category within Fund Summary
01 /01 /10 - 08/31/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
GENERAL FUND
40 PROPERTY TAXES 1,074 5,985,348 11,575,000 5,589,652 48.3
41 OTHER TAXES 601,917 3,542,091 7,576,000 4,033,909 53.2
42 LICENSES, PERMITS & FEES 476,487 2,710,723 3,426,000 715,277 20.9
43 INTERGOVERMENT REV. 1,348,176 6,194,340 15,240,100 9,045,760 59.4
44 CHARGES FOR SERVICE 95,171 860,826 1,640,000 779,174 47.5
45 FINES AND FORFEITS 77,422 352,324 642,000 289,676 45.1
46 INVESTMENT INCOME 3,710 27,020 130,000 102,980 79.2
47 REIMBURSEMENTS 15,757 152,100 296,000 143,900 48.6
48 OTHER REVENUE 25,104 140,064 166,000 25,936 15.6
49 OTHER FINANCING SOURCES 24 1,551 0 -1,551
TOTAL GENERAL FUND 2,644,842 19,966,387 40,691,100 20,724,713 50.9
REFUSE DISPOSAL FUND
40 PROPERTY TAXES -206 956,978 1,731,000 774,022 44.7
44 CHARGES FOR SERVICE 228,911 1,442,584 2,151,000 708,416 32.9
46 INVESTMENT INCOME 87 828 22,500 21,672 96.3
48 OTHER REVENUE 22,831 79,881 134,000 54,119 40.4
TOTAL REFUSE DISPOSAL FUND 251,623 2,480,271 4,038,500 1,558,229 38.6
MOTOR FUEL TAX FUND
43 INTERGOVERMENT REV. 120,970 828,572 1,675,000 846,428 50.5
46 INVESTMENT INCOME 237 1,163 1,500 337 22.5
47 REIMBURSEMENTS 1,131 33,900 160,000 126,100 78.8
TOTAL MOTOR FUEL TAX FUND 122,338 863,635 1,836,500 972,865 53.0
LAW ENFORCEMENT BLOCK GRANT
43 INTERGOVERMENT REV. 0 0 0 0
46 INVESTMENT INCOME 0 0 0 0
TOTAL LAW ENFORCEMENT BLOCK GRANT 0 0 0 0
COMMUNITY DEVELPMNT BLOCK GRNT
43 INTERGOVERMENT REV. 0 154,411 515,447 361,036 70.0
46 INVESTMENT INCOME 0 0 0 0
48 OTHER REVENUE 0 50,510 50,000 -510 -1.0
TOTAL COMMUNITY DEVELPMNT BLOCK GRNT 0 204,921 565,447 360,526 63.8
ASSET SEIZURE FUND
45 FINES AND FORFEITS 9,275 15,865 5,000 - 10,865 -217.3
46 INVESTMENT INCOME 7 41 1,000 959 95.9
TOTAL ASSET SEIZURE FUND 9,282 15,906 6,000 - 9,906 - 165.1
DEA SHARED FUNDS FUND
45 FINES AND FORFEITS 0 0 1,000 1,000 100.0
46 INVESTMENT INCOME 6 33 500 467 93.4
1
09/16/2010 8 Months ( 66.6% ) Completed
10:16:08 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3 ) Remaining
FRRBRR03
SUMo21 Budget Revenue by Category within Fund Summary
01/01/10 - 08/31/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
TOTAL DEA SHARED FUNDS FUND 6 33 1,500 1,467 97.8
DUI FINE FUND
45 FINES AND FORFEITS 1,306 7,818 20,000 12,182 60.9
46 INVESTMENT INCOME 1 4 500 496 99.2
TOTAL DUI FINE FUND 1,307 7,822 20,500 12,678 61.8
FOREIGN FIRE TAX BOARD FUND
41 OTHER TAXES 9,691 30,205 35,000 4,795 13.7
46 INVESTMENT INCOME 3 11 500 489 97.8
TOTAL FOREIGN FIRE TAX BOARD FUND 9,694 30,216 35,500 5,284 14.9
SERIES 1987A B &I, PW FACILITY
40 PROPERTY TAXES 0 0 0 0
46 INVESTMENT INCOME 0 0 0 0
TOTAL SERIES 1987A B &I, PW FACILITY 0 0 0 0
SERIES 2001 B &I, VILLAGE HALL
40 PROPERTY TAXES 0 0 378,000 378,000 100.0
46 INVESTMENT INCOME 1 2 1,000 998 99.8
49 OTHER FINANCING SOURCES 0 0 0 0
TOTAL SERIES 2001 B &I, VILLAGE HALL 1 2 379,000 378,998 100.0
SERIES 2003 B &I, VILLAGE HALL
40 PROPERTY TAXES -103 498,753 902,000 403,247 44.7
46 INVESTMENT INCOME 64 329 2,000 1,671 83.6
49 OTHER FINANCING SOURCES 0 0 0 0
TOTAL SERIES 2003 B &I, VILLAGE HALL - 39 499,082 904,000 404,918 44.8
SERIES 2009 B &I, FD /PW
40 PROPERTY TAXES -214 228,220 413,000 184,780 44.7
46 INVESTMENT INCOME 3 56 1,000 944 94.4
TOTAL SERIES 2009 B &I, FD /PW - 211 228,276 414,000 185,724 44.9
2009B B &I, FD /PW
40 PROPERTY TAXES -537 54,512 0 - 54,512
46 INVESTMENT INCOME 1 21 0 -21
49 OTHER FINANCING SOURCES 0 0 0 0
TOTAL 2009B B &I, FD /PW - 536 54,533 0 - 54,533
2009C B &I, FD /PW
40 PROPERTY TAXES 145 45,155 0 - 45,155
43 INTERGOVERMENT REV. 0 20,872 0 - 20,872
46 INVESTMENT INCOME 1 19 0 -19
2
09/16/2010 8 Months ( 66.6$ ) Completed
10:16:08 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3 ) Remaining
FR
SUMO21 Budget Revenue by Category within Fund Summary
01 /01 /10 - 08/31/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
TOTAL 2009C B &I, FD /PW 146 66,046 0 - 66,046
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 84,981 381,266 1,140,708 759,442 66.6
46 INVESTMENT INCOME 72 284 0 -284
TOTAL IEPA FLOOD CONTROL LOANS B &I 85,053 381,550 1,140,708 759,158 66.6
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 85,376 383,035 1,146,000 762,965 66.6
43 INTERGOVERMENT REV. 0 7,657 264,000 256,343 97.1
46 INVESTMENT INCOME 141 769 11,500 10,731 93.3
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 85,517 400,671 1,421,500 1,020,829 71.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
09/16/2010 8 Months ( 66.6' ) Completed
10:16:08 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3 ) Remaining
FRRBRR03
SIR4021 Budget Revenue by Category within Fund Summary
01 /01 /10 - 08/31/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
49 OTHER FINANCING SOURCES 0 0 973,505 973,505 100.0
TOTAL SERIES 2009 CONST FUND 0 24,644 1,124,505 1,099,861 97.8
DOWNTOWN REDEVLPMNT CONST
41 OTHER TAXES 4,640 1,232,533 2,556,000 1,323,467 51.8
46 INVESTMENT INCOME 143 1,755 11,000 9,245 84.0
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 4,783 1,234,288 2,567,000 1,332,712 51.9
STREET IMPROVEMENT CONST FUND
41 OTHER TAXES 119,027 589,125 1,506,000 916,875 60.9
43 INTERGOVERMENT REV. 0 413,250 210,600 - 202,650 -96.2
46 INVESTMENT INCOME 0 70 1,000 930 93.0
47 REIMBURSEMENTS 0 0 0 0
48 OTHER REVENUE 0 5,887 0 -5,887
TOTAL STREET IMPROVEMENT CONST FUND 119,027 1,008,332 1,717,600 709,268 41.3
FLOOD CONTROL CONST FUND
41 OTHER TAXES 7,844 35,192 105,292 70,100 66.6
42 LICENSES, PERMITS & FEES 1,083 4,491 45,000 40,509 90.0
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,927 96,762 198,792 102,030 51.3
WATER AND SEWER FUND
41 OTHER TAXES 7 833,836 1,500,000 666,164 44.4
42 LICENSES, PERMITS & FEES 2,080 11,870 16,000 4,130 25.8
44 CHARGES FOR SERVICE 812,597 5,723,259 10,596,000 4,872,741 46.0
46 INVESTMENT INCOME 112 777 92,500 91,723 99.2
47 REIMBURSEMENTS 0 9,450 1,000 -8,450 -845.0
48 OTHER REVENUE 11,072 21,773 20,000 -1,773 -8.9
49 OTHER FINANCING SOURCES 0 0 0 0
TOTAL WATER AND SEWER FUND 825,868 6,600,965 12,225,500 5,624,535 46.0
VILLAGE PARKING SYSTEM FUND
41 OTHER TAXES 3,352 15,041 45,000 29,959 66.6
42 LICENSES, PERMITS & FEES 0 0 0 0
44 CHARGES FOR SERVICE 6,935 61,785 106,000 44,215 41.7
46 INVESTMENT INCOME 16 58 1,000 942 94.2
TOTAL VILLAGE PARKING SYSTEM FUND 10,303 76,884 152,000 75,116 49.4
PARKING SYSTEM REVENUE FUND
41 OTHER TAXES 4,097 18,383 55,000 36,617 66.6
44 CHARGES FOR SERVICE 8,531 73,011 104,000 30,989 29.8
46 INVESTMENT INCOME 10 32 500 468 93.6
4
09/16/2010 8 Months ( 66.6% ) Completed
10:16:08 4 Months ( 33.3% ) Remaining
FRRBRR03 VILLAGE OF MOUNT PROSPECT
SIIMO21 Budget Revenue by Category within Fund Summary
01 /01 /10 - 08/31/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
TOTAL PARKING SYSTEM REVENUE FUND 12,638 91,426 159,500 68,074 42.7
VEHICLE MAINTENANCE FUND
44 CHARGES FOR SERVICE 137,288 1,098,297 1,647,442 549,145 33.3
46 INVESTMENT INCOME 81 614 6,750 6,136 90.9
48 OTHER REVENUE 0 125 0 -125
TOTAL VEHICLE MAINTENANCE FUND 137,369 1,099,036 1,654,192 555,156 33.6
VEHICLE REPLACEMENT FUND
44 CHARGES FOR SERVICE 6,308 50,467 75,700 25,233 33.3
45 FINES AND FORFEITS 6,425 19,110 36,000 16,890 46.9
46 INVESTMENT INCOME 852 5,593 76,500 70,907 92.7
48 OTHER REVENUE 0 0 0 0
49 OTHER FINANCING SOURCES 1,000 1,000 50,000 49,000 98.0
TOTAL VEHICLE REPLACEMENT FUND 14,585 76,170 238,200 162,030 68.0
COMPUTER REPLACEMENT FUND
44 CHARGES FOR SERVICE 0 0 0 0
46 INVESTMENT INCOME 130 951 12,000 11,049 92.1
TOTAL COMPUTER REPLACEMENT FUND 130 951 12,000 11,049 92.1
RISK MANAGEMENT FUND
44 CHARGES FOR SERVICE 526,218 3,817,112 5,650,738 1,833,626 32.4
46 INVESTMENT INCOME 217 2,010 31,500 29,490 93.6
47 REIMBURSEMENTS 0 5,288 10,000 4,712 47.1
48 OTHER REVENUE 98,843 700,596 1,172,860 472,264 40.3
TOTAL RISK MANAGEMENT FUND 625,278 4,525,006 6,865,098 2,340,092 34.1
POLICE PENSION FUND
46 INVESTMENT INCOME 368,517 233,211 2,635,500 2,402,289 91.2
48 OTHER REVENUE 53,815 1,395,672 2,950,000 1,554,328 52.7
TOTAL POLICE PENSION FUND 422,332 1,628,883 5,585,500 3,956,617 70.8
FIRE PENSION FUND
46 INVESTMENT INCOME 367,084 340,389 2,654,000 2,313,611 87.2
48 OTHER REVENUE 45,027 1,312,473 2,530,300 1,217,827 48.1
TOTAL FIRE PENSION FUND 412,111 1,652,862 5,184,300 3,531,438 68.1
SSA #6 GEORGE /ALBERT B &I
46 INVESTMENT INCOME 0 3 0 -3
TOTAL SSA #6 GEORGE /ALBERT B &I 0 3 0 -
GENERAL FIXED ASSETS ACCT GP
47 REIMBURSEMENTS 0 0 0 0
49 OTHER FINANCING SOURCES 0 0 0 0
5
•
09/16/2010 8 Months ( 66.6% ) Completed
10:16:08 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3 ) Remaining
FRRBRR03
SUMO21 Budget Revenue by Category within Fund Summary
01 /01 /10 - 08/31/10
Cur Mo Y -T -D 2010 Unreceived Unreceived
Received Received Budget Balance Percent
TOTAL GENERAL FIXED ASSETS ACCT GP 0 0 0 0
MOUNT PROSPECT LIBRARY FUND
49 OTHER FINANCING SOURCES 0 0 9,715,689 9,715,689 100.0
TOTAL MOUNT PROSPECT LIBRARY FUND 0 0 9,715,689 9,715,689 100.0
6
09/16/2010 VILLAGE OF MOUNT PROSPECT 8 Months ( 66.6% ) Completed
10:13:22 4 Months ( 33.3% ) Remaining
Budget Expenditure Summary
01 /01 /10 - 08/31/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
Expended Expended Budget Balance Percent
EXPENDITURE BY CLASSIFICATION
PERSONAL SERVICES 1,437,054 16,618,143 27,253,599 10,635,456 39.0
EMPLOYEE BENEFITS 506,332 6,339,995 11,075,849 4,735,854 42.8
OTHER EMPLOYEE COSTS 30,219 192,239 461,274 269,035 58.3
PENSION BENEFITS 623,019 4,405,579 6,404,900 1,999,321 31.2
CONTRACTUAL SERVICES 1,283,189 9,511,963 16,981,174 7,469,211 44.0
UTILITIES 63,607 332,739 631,674 298,935 47.3
INSURANCE 528,259 4,505,662 7,175,232 2,669,570 37.2
COMMODITIES & SUPPLIES 110,605 970,206 1,727,411 757,205 43.8
OTHER EXPENDITURES 20,650 1,259,098 2,628,150 1,369,052 52.1
LAND IMPROVEMENTS 0 0 76,065 76,065 100.0
BUILDING IMPROVEMENTS 69,007 2,660,988 1,260,658 - 1,400,330 -111.1
OFFICE EQUIPMENT 137,303 263,309 488,343 225,034 46.1
MOBILE EQUIPMENT 300,836 715,720 810,000 94,280 11.6
OTHER EQUIPMENT 91,443 641,819 3,108,636 2,466,817 79.4
DISTRIBUTION SYSTEMS 63,173 293,725 2,870,346 2,576,621 89.8
INFRASTRUCTURE 329,346 1,788,283 3,509,015 1,720,732 49.0
BOND PRINCIPAL 0 273,553 1,271,204 997,651 78.5
INTEREST EXPENSE 0 558,701 1,053,076 494,375 46.9
BANK AND FISCAL FEES 0 1,178 1,600 422 26.4
INTERFUND TRANSFERS 0 0 0 0
OTHER FINANCING USES 0 0 0 0
Total All Funds 5,594,042 51,332,900 88,788,206 37,455,306 42.2
EXPENDITURE BY FUND
GENERAL FUND 2,219,116 24,352,297 41,145,530 16,793,233 40.8
REFUSE DISPOSAL FUND 321,780 2,516,538 4,240,941 1,724,403 40.7
MOTOR FUEL TAX FUND 27,066 1,232,399 1,736,302 503,903 29.0
LAW ENFORCEMENT BLOCK GRANT 0 0 0 0
COMMUNITY DEVELPMNT BLOCK GRNT 25,155 237,945 565,447 327,502 57.9
ASSET SEIZURE FUND 0 6,118 2,000 -4,118 -205.9
DEA SHARED FUNDS FUND 0 2,514 1,000 -1,514 -151.4
DUI FINE FUND 0 343 1,500 1,157 77.1
FOREIGN FIRE TAX BOARD FUND 0 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 0 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 0 326,320 613,356 287,036 46.8
SERIES 2000 B &I, FLOOD CONTROL 0 0 0 0
CAPITAL IMPROVEMENT FUND 185,261 675,057 2,130,265 1,455,208 68.3
SERIES 2009 CONST FUND 45,545 2,963,937 2,183,633 - 780,304 -35.7
DOWNTOWN REDEVLPMNT CONST 74,067 1,343,220 2,736,500 1,393,280 50.9
STREET IMPROVEMENT CONST FUND 263,040 718,917 1,575,880 856,963 54.4
FLOOD CONTROL CONST FUND 3,250 8,516 161,425 152,909 94.7
WATER AND SEWER FUND 818,033 5,594,469 13,549,749 7,955,280 58.7
1
09/16/2010 VILLAGE OF MOUNT PROSPECT 8 Months ( 66.6t ) Completed
10:13:22 4 Months ( 33.3% ) Remaining
Budget Expenditure Summary
01/01/10 - 08/31/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
Expended Expended Budget Balance Percent
VILLAGE PARKING SYSTEM FUND 5,952 58,030 175,098 117,068 66.9
PARKING SYSTEM REVENUE FUND 8,551 84,782 174,597 89,815 51.4
VEHICLE MAINTENANCE FUND 116,102 1,125,294 1,814,711 689,417 38.0
VEHICLE REPLACEMENT FUND 300,836 715,720 810,000 94,280 11.6
COMPUTER REPLACEMENT FUND 59,791 167,946 206,050 38,104 18.5
RISK MANAGEMENT FUND 501,289 4,289,907 6,872,398 2,582,491 37.6
POLICE PENSION FUND 318,651 2,263,686 3,242,300 978,614 30.2
FIRE PENSION FUND 300,557 2,112,887 3,121,500 1,008,613 32.3
SSA #6 GEORGE /ALBERT B &I 0 0 0 0
GENERAL FIXED ASSETS ACCT GP 0 0 0 0
GENERAL LONG -TERM DEBT ACCT GP 0 0 0 0
Total All Funds 5,594,042 51,332,900 88,788,206 37,455,306 42.2
2
09/16/2010 8 Months ( 66.6t ) Completed
10:16:35 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3% ) Remaining
FRRDBRO1
SUM 031 Department Budget Expenditure Summary
01/01/10 - 08/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
•
09/16/2010 8 Months ( 66.6t ) Completed
10:16:35 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3t ) Remaining
FRRDBR01
SUM 031 Department Budget Expenditure Summary
01/01/10 - 08/31/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
PUBLIC REPRESENTATION Expended Expended Budget Balance Percent
PROGRAM TOTALS
02 MAYOR AND BOARD OF TRUSTEES 3,721 124,149 120,261 -3,888 -3.2
03 ADVISORY BOARDS & COMMISSIONS 291 3,054 6,149 3,095 50.3
Totals 4,012 127,203 126,410 -793 -0.6
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 2,630 22,518 34,311 11,793 34.4
51 EMPLOYEE BENEFITS 483 4,100 6,291 2,191 34.8
52 OTHER EMPLOYEE COSTS 439 552 4,400 3,848 87.5
54 CONTRACTUAL SERVICES 435 99,526 76,853 - 22,673 -29.5
55 UTILITIES 25 168 455 287 63.1
57 COMMODITIES & SUPPLIES 0 339 4,100 3,761 91.7
Totals 4,012 127,203 126,410 -793 -0.6
SOURCE OF FUNDS
001 GENERAL FUND 4,012 127,203 126,410 - 793 - 0.6
Totals 4,012 127,203 126,410 - 793 - 0.6
2
09/16/2010 8 Months ( 66.6' ) Completed
10:16:35 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3% ) Remaining
FRRDBR01
SUM031 Department Budget Expenditure Summary
01/01/10 - 08/31/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
VILLAGE MANAGER' S OFFICE Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 VILLAGE MANAGER'S OFFICE 32,240 359,268 575,229 215,961 37.5
02 LEGAL SERVICES 63,431 354,985 538,250 183,265 34.0
03 HUMAN RESOURCES 13,373 154,065 265,181 111,116 41.9
04 INFORMATION TECHNOLOGY 80,170 502,713 892,193 389,480 43.7
05 PUBLIC INFORMATION 18,510 149,705 248,098 98,393 39.7
Totals 207,724 1,520,736 2,518,951 998,215 39.6
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 51,293 625,542 1,011,435 385,893 38.2
51 EMPLOYEE BENEFITS 20,828 207,333 321,215 113,882 35.5
52 OTHER EMPLOYEE COSTS 1,238 11,228 28,200 16,972 60.2
54 CONTRACTUAL SERVICES 132,240 651,050 1,115,200 464,150 41.6
55 UTILITIES 890 4,471 8,601 4,130 48.0
57 COMMODITIES & SUPPLIES 1,069 5,832 15,200 9,368 61.6
65 OFFICE EQUIPMENT 166 15,280 19,100 3,820 20.0
67 OTHER EQUIPMENT 0 0 0 0
Totals 207,724 1,520,736 2,518,951 998,215 39.6
SOURCE OF FUNDS
001 GENERAL FUND 207,724 1,520,736 2,518,951 998,215 39.6
Totals 207,724 1,520,736 2,518,951 998,215 39.6
3
09/16/2010 8 Months ( 66.6% ) Completed
10:16:35 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3t ) Remaining
FRRDBR01
SUM 031 Department Budget Expenditure Summary
01 /01 /10 - 08/31/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
TV SERVICES DIVISION Expended Expended Budget Balance Percent
PROGRAM TOTALS
02 CABLE TV OPERATIONS 7,589 92,507 139,639 47,132 33.8
04 INTERGOVERNMENTAL PROGRAMMING 3,429 34,030 62,410 28,380 45.5
Totals 11,018 126,537 202,049 75,512 37.4
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 6,264 73,234 114,194 40,960 35.9
51 EMPLOYEE BENEFITS 3,130 28,806 44,177 15,371 34.8
52 OTHER EMPLOYEE COSTS 0 725 700 -25 -3.6
54 CONTRACTUAL SERVICES 950 11,936 27,378 15,442 56.4
55 UTILITIES 167 1,119 1,600 481 30.1
57 COMMODITIES & SUPPLIES 507 4,322 5,500 1,178 21.4
67 OTHER EQUIPMENT 0 6,395 8,500 2,105 24.8
Totals 11,018 126,537 202,049 75,512 37.4
SOURCE OF FUNDS
001 GENERAL FUND 11,018 126,537 202,049 75,512 37.4
Totals 11,018 126,537 202,049 75,512 37.4
4
09/16/2010 8 Months ( 66.6% ) Completed
10:16:35 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3% ) Remaining
FRRDBR01
SUM on. Department Budget Expenditure Summary
01/01/10 - 08/31/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
VILLAGE CLERK' S OFFICE Expended Expended Budget Balance Percent
PROGRAM TOTALS
02 VILLAGE CLERK'S OFFICE 11,443 124,025 208,643 84,618 40.6
Totals 11,443 124,025 208,643 84,618 40.6
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 7,014 81,656 126,804 45,148 35.6
51 EMPLOYEE BENEFITS 3,336 30,997 47,646 16,649 34.9
52 OTHER EMPLOYEE COSTS 85 508 1,485 977 65.8
54 CONTRACTUAL SERVICES 924 9,784 29,679 19,895 67.0
55 UTILITIES 84 559 1,549 990 63.9
57 COMMODITIES & SUPPLIES 0 521 1,480 959 64.8
Totals 11,443 124,025 208,643 84,618 40.6
SOURCE OF FUNDS
001 GENERAL FUND 11,443 124,025 208,643 84,618 40.6
Totals 11,443 124,025 208,643 84,618 40.6
5
09/16/2010 8 Months ( 66.6% ) Completed
10:16:35 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3% ) Remaining
FRRDBR01
Survo31 Department Budget Expenditure Summary
01 /01 /10 - 08/31/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
FINANCE DEPARTMENT Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 FINANCE ADMINISTRATION 20,433 208,568 359,820 151,252 42.0
02 ACCOUNTING 25,447 303,498 491,793 188,295 38.3
05 INSURANCE PROGRAMS 24,222 205,468 311,872 106,404 34.1
06 CUSTOMER SERVICE 20,500 255,608 420,812 165,204 39.3
07 CASH MANAGEMENT 1,226 17,648 28,416 10,768 37.9
Totals 91,828 990,790 1,612,713 621,923 38.6
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 40,032 510,823 843,557 332,734 39.4
51 EMPLOYEE BENEFITS 20,690 198,032 312,122 114,090 36.6
52 OTHER EMPLOYEE COSTS 219 3,036 5,650 2,614 46.3
54 CONTRACTUAL SERVICES 9,665 111,252 181,213 69,961 38.6
55 UTILITIES 510 2,937 4,900 1,963 40.1
56 INSURANCE 19,393 155,141 232,711 77,570 33.3
57 COMMODITIES & SUPPLIES 1,319 9,569 32,160 22,591 70.2
65 OFFICE EQUIPMENT 0 0 400 400 100.0
Totals 91,828 990,790 1,612,713 621,923 38.6
SOURCE OF FUNDS
001 GENERAL FUND 91,828 990,790 1,612,713 621,923 38.6
Totals 91,828 990,790 1,612,713 621,923 38.6
09/16/2010 8 Months ( 66.61 ) Completed
10:16:35 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.31 ) Remaining
FRRDBR01
SUM031 Department Budget Expenditure Summary
01 /01 /10 - 08/31/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
COMMUNITY DEVELOPMENT Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 COMMUNITY DEVELOPMENT ADMIN 15,986 170,124 261,596 91,472 35.0
02 PLANNING & ZONING 12,488 165,012 333,616 168,604 50.5
03 ECONOMIC DEVELOPMENT 8,322 62,009 95,383 33,374 35.0
05 BUILDING INSPECTIONS 49,859 542,393 940,912 398,519 42.4
06 HOUSING INSPECTIONS 29,760 323,647 529,946 206,299 38.9
07 HEALTH INSPECTIONS 6,495 78,009 128,093 50,084 39.1
Totals 122,910 1,341,194 2,289,546 948,352 41.4
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 72,625 864,577 1,402,026 537,449 38.3
51 EMPLOYEE BENEFITS 37,201 347,200 541,145 193,945 35.8
52 OTHER EMPLOYEE COSTS 69 12,172 31,246 19,074 61.0
54 CONTRACTUAL SERVICES 10,974 102,393 269,117 166,724 62.0
55 UTILITIES 1,769 7,827 17,671 9,844 55.7
57 COMMODITIES & SUPPLIES 272 7,025 24,141 17,116 70.9
65 OFFICE EQUIPMENT 0 0 4,200 4,200 100.0
Totals 122,910 1,341,194 2,289,546 948,352 41.4
SOURCE OF FUNDS
001 GENERAL FUND 122,910 1,339,694 2,288,046 948,352 41.4
550 DOWNTOWN REDEVLPMNT CONST 0 1,500 1,500 0
Totals 122,910 1,341,194 2,289,546 948,352 41.4
7
09/16/2010 8 Months ( 66.6% ) Completed
10:16:36 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3% ) Remaining
FRRDBR01
SUM031 Department Budget Expenditure Summary
01 /01 /10 - 08/31/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
COMMUNITY DEVELOPMENT - CDBG Expended Expended Budget Balance Percent
PROGRAM TOTALS
04 CDBG ADMINISTRATION 4,130 47,064 94,947 47,883 50.4
05 CDBG COMMUNITY PROGRAMS 1,125 65,907 90,500 24,593 27.2
06 ACCESSIBLTY & NEIGHBRHD IMPRV 0 3,360 100,000 96,640 96.6
07 CDBG RESIDENTIAL REHAB 1,290 39,079 280,000 240,921 86.0
08 CDBG RECOVERY ACT 18,610 82,535 0 - 82,535
Totals 25,155 237,945 565,447 327,502 57.9
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 2,248 35,013 62,569 27,556 44.0
51 EMPLOYEE BENEFITS 1,457 14,534 23,311 8,777 37.7
52 OTHER EMPLOYEE COSTS 60 85 1,965 1,880 95.7
54 CONTRACTUAL SERVICES 2,727 78,528 106,625 28,097 26.4
57 COMMODITIES & SUPPLIES 13 94 977 883 90.4
59 OTHER EXPENDITURES 18,650 106,331 200,000 93,669 46.8
62 LAND IMPROVEMENTS 0 0 50,000 50,000 100.0
69 INFRASTRUCTURE 0 3,360 120,000 116,640 97.2
Totals 25,155 237,945 565,447 327,502 57.9
SOURCE OF FUNDS
070 COMMUNITY DEVELPMNT BLOCK GRNT 25,155 237,945 565,447 327,502 57.9
Totals 25,155 237,945 565,447 327,502 57.9
09/16/2010 8 Months ( 66.6t ) Completed
• 10:16:36 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3t ) Remaining
FRRDBR01
SUM on Department Budget Expenditure Summary
01/01/10 - 08/31/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
HUMAN SERVICES Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 HUMAN SERVICES ADMINISTRATION 7,995 106,928 184,075 77,147 41.9
02 SOCIAL SERVICES 18,793 239,754 389,713 149,959 38.5
03 NURSING /HEALTH SERVICES 9,998 123,990 239,089 115,099 48.1
04 SENIOR CITIZEN LEIS ACTIVITIES 1,646 19,426 35,821 16,395 45.8
05 COMMUNITY CONNECTIONS CENTER 18,838 185,546 306,071 120,525 39.4
Totals 57,270 675,644 1,154,769 479,125 41.5
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 31,052 431,878 689,812 257,934 37.4
51 EMPLOYEE BENEFITS 15,611 156,101 241,687 85,586 35.4
52 OTHER EMPLOYEE COSTS 220 1,452 12,581 11,129 88.5
54 CONTRACTUAL SERVICES 8,890 72,498 154,168 81,670 53.0
55 UTILITIES 1,082 7,092 14,756 7,664 51.9
57 COMMODITIES & SUPPLIES 415 6,623 39,065 32,442 83.0
64 BUILDING IMPROVEMENTS 0 0 0 0
65 OFFICE EQUIPMENT 0 0 2,700 2,700 100.0
Totals 57,270 675,644 1,154,769 479,125 41.5
SOURCE OF FUNDS
001 GENERAL FUND 57,270 675,644 1,154,769 479,125 41.5
Totals 57,270 675,644 1,154,769 479,125 41.5
9
09/16/2010 8 Months ( 66.6W ) Completed
10:16:36 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3W ) Remaining
FRRDBR01
SUM 031 Department Budget Expenditure Summary
01/01/10 - 08/31/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
POLICE Expended Expended Budget
Balance Percent
PROGRAM TOTALS
01 POLICE ADMINISTRATION 98,499 2,058,877 3,958,608 1,899,731 48.0
02 PATROL & TRAFFIC ENFORCEMENT 485,110 5,364,958 8,946,765 3,581,807 40.0
03 CRIME PREVTN & PUBLIC SERVICES 16,829 170,650 271,910 101,260 37.2
04 INVESTIGATIVE & JUVENILE PRGM 90,311 818,757 1,318,756 499,999 37.9
05 CROSSING GUARDS 0 17,757 31,480 13,723 43.6
06 EQUIPMENT MAINTENANCE 42,052 340,041 515,145 175,104 34.0
Totals 732,801 8,771,040 15,042,664 6,271,624 41.7
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 476,289 5,681,713 9,490,554 3,808,841 40.1
51 EMPLOYEE BENEFITS 152,896 2,212,823 4,146,442 1,933,619 46.6
52 OTHER EMPLOYEE COSTS 3,462 57,367 140,300 82,933 59.1
54 CONTRACTUAL SERVICES 78,765 726,636 1,080,543 353,907 32.8
55 UTILITIES 4,236 24,125 33,160 9,035 27.2
57 COMMODITIES & SUPPLIES 14,968 55,203 127,315 72,112 56.6
65 OFFICE EQUIPMENT 0 1,517 6,150 4,633 75.3
67 OTHER EQUIPMENT 2,185 11,656 18,200 6,544 36.0
80 INTERFUND TRANSFERS 0 0 0 0
Totals 732,801 8,771,040 15,042,664 6,271,624 41.7
SOURCE OF FUNDS
001 GENERAL FUND 732,801 8,762,065 15,038,164 6,276,099 41.7
060 LAW ENFORCEMENT BLOCK GRANT 0 0 0 0
080 ASSET SEIZURE FUND 0 6,118 2,000 -4,118 -205.9
085 DEA SHARED FUNDS FUND 0 2,514 1,000 -1,514 -151.4
086 DUI FINE FUND 0 343 1,500 1,157 77.1
Totals 732,801 8,771,040 15,042,664 6,271,624 41.7
09/16/2010 8 Months ( 66.6$ ) Completed
10:16:36 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3% ) Remaining
FRRDBR01
SUM 031 Department Budget Expenditure Summary
01 /01 /10 - 08/31/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
FIRE Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 FIRE ADMINISTRATION 104,743 1,595,974 2,934,025 1,338,051 45.6
02 FIRE DEPARTMENT OPERATIONS 432,943 4,723,633 7,577,769 2,854,136 37.7
03 FIRE TRAINING ACADEMY 0 2,361 14,131 11,770 83.3
04 FIRE PREVENTION 27,749 315,937 603,725 287,788 47.7
05 FIRE COMMUNICATIONS 5,128 28,986 55,611 26,625 47.9
06 EQUIPMENT MAINTENANCE 16,600 131,925 197,950 66,025 33.4
07 EMERGENCY PREPAREDNESS PRGM 278 4,618 62,436 57,818 92.6
08 PAID -ON -CALL PROGRAM 1,045 18,359 33,180 14,821 44.7
10 FOREIGN FIRE INSURANCE 0 28,946 15,500 - 13,446 -86.7
Totals 588,486 6,850,739 11,494,327 4,643,588 40.4
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 413,228 4,591,592 7,402,167 2,810,575 38.0
51 EMPLOYEE BENEFITS 110,642 1,845,210 3,333,594 1,488,384 44.6
52 OTHER EMPLOYEE COSTS 20,023 61,710 140,880 79,170 56.2
53 PENSION BENEFITS 0 0 500 500 100.0
54 CONTRACTUAL SERVICES 28,075 270,084 413,665 143,581 34.7
55 UTILITIES 3,576 20,953 38,311 17,358 45.3
57 COMMODITIES & SUPPLIES 4,275 25,644 73,970 48,326 65.3
64 BUILDING IMPROVEMENTS 0 51 3,800 3,749 98.7
65 OFFICE EQUIPMENT 0 0 9,000 9,000 100.0
67 OTHER EQUIPMENT 8,667 35,495 78,440 42,945 54.7
Totals 588,486 6,850,739 11,494,327 4,643,588 40.4
SOURCE OF FUNDS
001 GENERAL FUND 588,486 6,821,793 11,478,827 4,657,034 40.6
095 FOREIGN FIRE TAX BOARD FUND 0 28,946 15,500 - 13,446 -86.7
Totals 588,486 6,850,739 11,494,327 4,643,588 40.4
11
09/16/2010 8 Months ( 66.6t ) Completed
10:16:36 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3% ) Remaining
FRRDBR01
SLIM 031 Department Budget Expenditure Summary
01/01/10 - 08/31/10
Cur Mo PUBLIC WORKS - ADMINISTRATION Expended Expended zog ed Budg Unexpended unexpended
Budget xpendet Balance Percent
PROGRAM TOTALS
01 PUBLIC WORKS ADMINISTRATION 71,284 637,582 982,823 345,241 35.1
Totals 71,284 637,582 982,823 345,241 35.1
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 11,512 145,972 234,319 88,347 37.7
51 EMPLOYEE BENEFITS 11,148 98,378 149,319 50,941 34.1
52 OTHER EMPLOYEE COSTS 1,230 14,139 25,802 11,663 45.2
54 CONTRACTUAL SERVICES 44,830 355,845 538,489 182,644 33.9
55 UTILITIES 1,697 10,805 19,470 8,665 44.5
57 COMMODITIES & SUPPLIES 867 12,443 15,169 2,726 18.0
65 OFFICE EQUIPMENT 0 0 0 0
67 OTHER EQUIPMENT 0 0 255 255 100.0
Totals 71,284 637,582 982,823 345,241 35.1
SOURCE OF FUNDS
001 GENERAL FUND 71,284 637,582 982,823 345,241 35.1
Totals 71,284 637,582 982,823 345,241 35.1
12
09/16/2010 8 Months ( 66.6% ) Completed
' 10:16:36 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3% ) Remaining
FRRDBROI
SUM031 Department Budget Expenditure Summary
01/01/10 - 08/31/10
Cur Mo Y - - 2010 Unexpended Unexpended
PUBLIC WORKS - STREETS /BLDGS Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 STREET DIVISION ADMINISTRATION 8,062 106,400 161,866 55,466 34.3
02 MAINTENANCE - PUBLIC BUILDINGS 64,593 570,545 1,010,405 439,860 43.5
04 STREET MAINTENANCE 40,734 175,715 418,912 243,197 58.1
05 SNOW REMOVAL 8,562 481,222 669,384 188,162 28.1
06 LEAF REMOVAL 0 0 0 0
07 STORM SEWER & BASIN MAINT 7,797 58,608 112,657 54,049 48.0
08 MAINTENANCE OF STATE HIGHWAYS 2,884 45,480 70,394 24,914 35.4
09 TRAFFIC SIGN MAINTENANCE 7,633 76,072 122,044 45,972 37.7
10 VILLAGE PARKING LOT MAINT 5,952 58,030 175,098 117,068 66.9
11 PARKING LOT MAINTENANCE 8,551 84,782 149,597 64,815 43.3
12 FLOOD CONTROL 0 0 0 0
13 STORM EVENT 0 0 0 0
Totals 154,768 1,656,854 2,890,357 1,233,503 42.7
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 62,571 772,359 1,246,055 473,696 38.0
51 EMPLOYEE BENEFITS 24,307 237,774 382,210 144,436 37.8
54 CONTRACTUAL SERVICES 30,428 335,878 726,159 390,281 53.7
55 UTILITIES 3,047 24,053 79,230 55,177 69.6
56 INSURANCE 158 1,262 1,894 632 33.4
57 COMMODITIES & SUPPLIES 12,790 256,838 394,954 138,116 35.0
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 21,467 24,425 40,000 15,575 38.9
Totals 154,768 1,656,854 2,890,357 1,233,503 42.7
SOURCE OF FUNDS
001 GENERAL FUND 140,265 1,358,008 2,266,230 908,222 40.1
050 MOTOR FUEL TAX FUND 0 156,034 299,432 143,398 47.9
620 VILLAGE PARKING SYSTEM FUND 5,952 58,030 175,098 117,068 66.9
630 PARKING SYSTEM REVENUE FUND 8,551 84,782 149,597 64,815 43.3
Totals 154,768 1,656,854 2,890,357 1,233,503 42.7
13
09/16/2010 8 Months ( 66.6$ ) Completed
10:16:36 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3t ) Remaining
FRRDBR01
SUM 031 Department Budget Expenditure Summary
01 /01 /10 - 08/31/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
PUBLIC WORKS - FORESTRY /GRNDS Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 FORESTRY DIVISION ADMIN 11,452 145,118 237,763 92,645 39.0
02 MAINTENANCE OF GROUNDS 31,248 256,179 473,321 217,142 45.9
03 FORESTRY PROGRAM 46,789 548,506 1,002,138 453,632 45.3
04 PUBLIC GROUNDS BEAUTIFICATION 2,000 47,397 68,010 20,613 30.3
Totals 91,489 997,200 1,781,232 784,032 44.0
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 43,431 463,196 761,579 298,383 39.2
51 EMPLOYEE BENEFITS 16,851 157,027 246,330 89,303 36.3
52 OTHER EMPLOYEE COSTS 0 3,662 3,662 0
54 CONTRACTUAL SERVICES 30,947 339,607 718,112 378,505 52.7
57 COMMODITIES & SUPPLIES 260 33,708 51,549 17,841 34.6
67 OTHER EQUIPMENT 0 0 0 0
Totals 91,489 997,200 1,781,232 784,032 44.0
SOURCE OF FUNDS
001 GENERAL FUND 91,489 997,200 1,762,432 765,232 43.4
690 RISK MANAGEMENT FUND 0 0 18,800 18,800 100.0
Totals 91,489 997,200 1,781,232 784,032 44.0
09/16/2010 8 Months ( 66.6% ) Completed
10:16:36 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3W ) Remaining
FRRDBR01
SUNO31 Department Budget Expenditure Summary
01 /01 /10 - 08/31/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
PUBLIC WORKS - ENGINEERING Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 ENGINEERING SERVICES 45,766 507,309 831,493 324,184 39.0
05 TRAFFIC CNTRL & STREET LGHTNG 36,032 249,843 756,494 506,651 67.0
Totals 81,798 757,152 1,587,987 830,835 52.3
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 35,135 433,214 701,400 268,186 38.2
51 EMPLOYEE BENEFITS 13,238 133,740 211,200 77,460 36.7
52 OTHER EMPLOYEE COSTS 724 2,989 3,552 563 15.9
54 CONTRACTUAL SERVICES 12,058 52,944 131,796 78,852 59.8
55 UTILITIES 17,134 120,196 225,000 104,804 46.6
57 COMMODITIES & SUPPLIES 3,509 14,069 32,855 18,786 57.2
65 OFFICE EQUIPMENT 0 0 546 546 100.0
67 OTHER EQUIPMENT 0 0 1,638 1,638 100.0
69 INFRASTRUCTURE 0 0 280,000 280,000 100.0
Totals 81,798 757,152 1,587,987 830,835 52.3
SOURCE OF FUNDS
001 GENERAL FUND 54,732 600,787 1,071,117 470,330 43.9
050 MOTOR FUEL TAX FUND 27,066 156,365 516,870 360,505 69.7
Totals 81,798 757,152 1,587,987 830,835 52.3
15
09/16/2010 8 Months ( 66.6% ) Completed
10:16:36 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3t ) Remaining
FRRDBR01
SUM031 Department Budget Expenditure Summary
01 /01 /10 - 08/31/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
PUBLIC WORKS - WATER /SEWER Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 WATER & SEWER DIVISION ADMIN 96,312 870,903 1,415,111 544,208 38.5
02 MAINTENANCE OF BUILDINGS 51,509 158,367 266,997 108,630 40.7
03 MAINTENANCE OF GROUNDS 9,413 75,862 136,428 60,566 44.4
04 WATER SUPPLY MAINT & REPAIR 50,419 447,673 1,585,848 1,138,175 71.8
05 WATER DISTRBT MAINT & REPAIR 31,978 379,388 868,982 489,594 56.3
06 WATER VALVE /HYDRNT MAINT & REP 29,177 226,485 413,162 186,677 45.2
07 WATER METER MAINT & REPL 19,172 171,716 963,266 791,550 82.2
08 EQUIPMENT MAINTENANCE 42,889 343,112 514,668 171,556 33.3
09 SANITARY SEWER MAINT & REPAIR 46,922 339,908 1,039,772 699,864 67.3
10 WATER & SEWER SYSTEM IMPROV 73,459 418,060 2,315,515 1,897,455 81.9
12 LAKE MICHIGAN WATER SUPPLY 366,783 2,162,995 4,030,000 1,867,005 46.3
Totals 818,033 5,594,469 13,549,749 7,955,280 58.7
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 104,591 1,138,473 1,900,352 761,879 40.1
51 EMPLOYEE BENEFITS 46,171 422,000 671,563 249,563 37.2
52 OTHER EMPLOYEE COSTS 2,214 20,480 57,336 36,856 64.3
54 CONTRACTUAL SERVICES 529,506 3,382,880 6,242,726 2,859,846 45.8
55 UTILITIES 29,273 107,651 185,406 77,755 41.9
56 INSURANCE 5,524 44,196 66,295 22,099 33.3
57 COMMODITIES & SUPPLIES 24,367 138,045 291,120 153,075 52.6
59 OTHER EXPENDITURES 0 0 0 0
65 OFFICE EQUIPMENT 0 220 7,652 7,432 97.1
67 OTHER EQUIPMENT 13,214 46,799 1,256,953 1,210,154 96.3
68 DISTRIBUTION SYSTEMS 63,173 293,725 2,870,346 2,576,621 89.8
Totals 818,033 5,594,469 13,549,749 7,955,280 58.7
SOURCE OF FUNDS
610 WATER AND SEWER FUND 818,033 5,594,469 13,549,749 7,955,280 58.7
Totals 818,033 5,594,469 13,549,749 7,955,280 58.7
,c
09/16/2010 8 Months ( 66.6' ) Completed
10:16 :36 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3% ) Remaining
FRRDBRO1
SID4031 Department Budget Expenditure Summary
01 /01 /10 - 08/31/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
PUBLIC WORKS - REFUSE DISPOSAL Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 REFUSE DISPOSAL PROGRAM 313,257 2,430,385 4,019,373 1,588,988 39.5
02 REFUSE LEAF REMOVAL PROGRAM 8,523 86,153 221,568 135,415 61.1
Totals 321,780 2,516,538 4,240,941 1,724,403 40.7
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 10,987 118,228 251,942 133,714 53.1
51 EMPLOYEE BENEFITS 4,650 42,955 77,148 34,193 44.3
52 OTHER EMPLOYEE COSTS 0 0 1,200 1,200 100.0
54 CONTRACTUAL SERVICES 303,924 2,331,668 3,853,608 1,521,940 39.5
55 UTILITIES 33 224 572 348 60.8
56 INSURANCE 1,895 15,156 22,734 7,578 33.3
57 COMMODITIES & SUPPLIES 291 8,307 33,737 25,430 75.4
Totals 321,780 2,516,538 4,240,941 1,724,403 40.7
SOURCE OF FUNDS
030 REFUSE DISPOSAL FUND 321,780 2,516,538 4,240,941 1,724,403 40.7
Totals 321,780 2,516,538 4,240,941 1,724,403 40.7
17
09/16/2010 8 Months ( 66.6% ) Completed
10:16:36 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3% ) Remaining
FRRDBR01
SUM031 Department Budget Expenditure Summary
01 /01 /10 - 08/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 10,874 117,271 180,836 63,565 35.2
02 VEHICLE MAINTENANCE PROGRAM 105,228 1,008,023 1,633,875 625,852 38.3
Totals 116,102 1,125,294 1,814,711 689,417 38.0
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 49,096 538,035 879,792 341,757 38.8
51 EMPLOYEE BENEFITS 20,653 189,710 301,789 112,079 37.1
52 OTHER EMPLOYEE COSTS 236 2,134 2,315 181 7.8
54 CONTRACTUAL SERVICES 3,825 41,058 95,738 54,680 57.1
55 UTILITIES 84 559 993 434 43.7
57 COMMODITIES & SUPPLIES 42,208 353,719 530,039 176,320 33.3
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 116,102 1,125,294 1,814,711 689,417 38.0
SOURCE OF FUNDS
660 VEHICLE MAINTENANCE FUND 116,102 1,125,294 1,814,711 689,417 38.0
Totals 116,102 1,125,294 1,814,711 689,417 38.0
18
09/16/2010 8 Months ( 66.6 ) Completed
10:16:36 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3 ) Remaining
FRRDBR01
SUM on Department Budget Expenditure Summary
01 /01 /10 - 08/31/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
COMMUNITY SERVICE PROGRAMS Expended Expended Budget Balance Percent
PROGRAM TOTALS
02 COMMUNITY GROUPS & MISC 6,389 80,710 136,400 55,690 40.8
03 4TH OF JULY & CIVIC EVENTS,ETC 22,887 140,943 167,252 26,309 15.7
04 HOLIDAY DECORATIONS 515 16,351 81,330 64,979 79.9
05 BLOOD DONOR PROGRAM 252 1,747 2,774 1,027 37.0
Totals 30,043 239,751 387,756 148,005 38.2
EXPENDITURE CLASSIFICATION
50 PERSONAL SERVICES 17,056 90,120 100,731 10,611 10.5
51 EMPLOYEE BENEFITS 3,040 13,275 18,660 5,385 28.9
54 CONTRACTUAL SERVICES 6,472 98,577 207,785 109,208 52.6
57 COMMODITIES & SUPPLIES 3,475 37,779 52,580 14,801 28.1
59 OTHER EXPENDITURES 0 0 8,000 8,000 100.0
Totals 30,043 239,751 387,756 148,005 38.2
SOURCE OF FUNDS
001 GENERAL FUND 30,043 239,751 387,756 148,005 38.2
Totals 30,043 239,751 387,756 148,005 38.2
19
09/16/2010 8 Months ( 66.6' ) Completed
10:16:36 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3% ) Remaining
FRRDBR01
SUM 031 Department Budget Expenditure Summary
01 /01 /10 - 08/31/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
CAPITAL IMPROVEMENT PROJECTS Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 VILLAGE IMPROVEMENTS & EQUIP 185,261 601,721 1,829,500 1,227,779 67.1
02 COMMUNITY IMPROVEMENT PROJECTS 0 27,624 155,765 128,141 82.3
03 DOWNTOWN REDEVELOPMENT CONST 74,067 1,341,720 2,735,000 1,393,280 50.9
04 FLOOD CONTROL PROJECTS 3,250 8,516 161,425 152,909 94.7
06 STREET IMPROVEMENT PROJECTS 263,040 1,684,915 2,665,880 980,965 36.8
09 MOTOR EQUIPMENT REPLACEMENT 300,836 715,720 810,000 94,280 11.6
10 COMPUTER REPLACEMENT 59,791 167,946 206,050 38,104 18.5
11 STATION 14 18,915 2,354,472 1,380,963 - 973,509 -70.5
12 EMERGENCY OPERATION CENTER 26,630 223,309 456,741 233,432 51.1
13 PUBLIC WORKS EXPANSION 0 385,870 345,929 - 39,941 -11.5
Totals 931,790 7,511,813 10,747,253 3,235,440 30.1
EXPENDITURE CLASSIFICATION
54 CONTRACTUAL SERVICES 47,554 438,469 1,005,820 567,351 56.4
59 OTHER EXPENDITURES 2,000 1,152,767 2,420,150 1,267,383 52.4
62 LAND IMPROVEMENTS 0 0 26,065 26,065 100.0
64 BUILDING IMPROVEMENTS 69,007 2,656,672 1,237,003 - 1,419,669 -114.8
65 OFFICE EQUIPMENT 137,137 246,292 438,050 191,758 43.8
66 MOBILE EQUIPMENT 300,836 715,720 810,000 94,280 11.6
67 OTHER EQUIPMENT 67,377 541,395 1,741,150 1,199,755 68.9
69 INFRASTRUCTURE 307,879 1,760,498 3,069,015 1,308,517 42.6
71 BOND PRINCIPAL 0 0 0 0
72 INTEREST EXPENSE 0 0 0 0
80 INTERFUND TRANSFERS 0 0 0 0
Totals 931,790 7,511,813 10,747,253 3,235,440 30.1
SOURCE OF FUNDS
050 MOTOR FUEL TAX FUND 0 920,000 920,000 0
510 CAPITAL IMPROVEMENT FUND 185,261 675,057 2,130,265 1,455,208 68.3
528 SERIES 2009 CONST FUND 45,545 2,963,937 2,183,633 - 780,304 -35.7
550 DOWNTOWN REDEVLPMNT CONST 74,067 1,341,720 2,735,000 1,393,280 50.9
560 STREET IMPROVEMENT CONST FUND 263,040 718,917 1,575,880 856,963 54.4
590 FLOOD CONTROL CONST FUND 3,250 8,516 161,425 152,909 94.7
630 PARKING SYSTEM REVENUE FUND 0 0 25,000 25,000 100.0
670 VEHICLE REPLACEMENT FUND 300,836 715,720 810,000 94,280 11.6
680 COMPUTER REPLACEMENT FUND 59,791 167,946 206,050 38,104 18.5
Totals 931,790 7,511,813 10,747,253 3,235,440 30.1
09/16/2010 8 Months ( 66.6$ ) Completed
10:16:36 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3t ) Remaining
FRRDBR01
SUMo31 Department Budget Expenditure Summary
01 /01 /10 - 08/31/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
DEBT SERVICE Expended Expended Budget Balance Percent
PROGRAM TOTALS
02 DEBT SERVICE - PROPERTY TAXES 0 507,112 1,712,524 .1,205,412 70.4
03 DEBT SERVICE - TAX INCREMENT 0 0 0 0
04 DEBT SERVICE - H/R SALES TAX 1 0 326,320 613,356 287,036 46.8
06 SPECIAL SERVICE AREA B & I 0 0 0 0
Totals 0 833,432 2,325,880 1,492,448 64.2
EXPENDITURE CLASSIFICATION
54 CONTRACTUAL SERVICES 0 0 0 0
59 OTHER EXPENDITURES 0 0 0 0
71 BOND PRINCIPAL 0 273,553 1,271,204 997,651 78.5
72 INTEREST EXPENSE 0 558,701 1,053,076 494,375 46.9
73 BANK AND FISCAL FEES 0 1,178 1,600 422 26.4
80 INTERFUND TRANSFERS 0 0 0 0
81 OTHER FINANCING USES 0 0 0 0
Totals 0 833,432 2,325,880 1,492,448 64.2
SOURCE OF FUNDS
140 SERIES 1987A B &I, PW FACILITY 0 0 0 0
180 SERIES 2001 B &I, VILLAGE HALL 0 150 382,203 382,053 100.0
190 SERIES 2003 B &I, VILLAGE HALL 0 191,628 912,658 721,030 79.0
195 SERIES 2009 B &I, FD /PW 0 209,059 417,663 208,604 49.9
196 2009B B &I, FD /PW 0 46,640 0 - 46,640
197 2009C B &I, FD /PW 0 59,635 0 - 59,635
290 SERIES 1999 B &I, TIF 0 0 0 0
340 SERIES 1996A B &I, FLOOD 0 0 0 0
350 SERIES 1998A B &I, FLOOD 0 0 0 0
360 SERIES 1998C B &I, TIF 0 0 0 0
380 IEPA FLOOD CONTROL LOANS B &I 0 326,320 613,356 287,036 46.8
390 SERIES 2000 B &I, FLOOD CONTROL 0 0 0 0
830 SSA #6 GEORGE /ALBERT B &I 0 0 0 0
Totals 0 833,432 2,325,880 1,492,448 64.2
21
09/16/2010 8 Months ( 66.61 ) Completed
10:16:36 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.31 ) Remaining
FRRDBR01
SUM 031 Department Budget Expenditure Summary
01 /01 /10 - 08/31/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
RETIREE PENSIONS Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 MISCELLANEOUS PENSIONS 3,811 30,482 46,600 16,118 34.6
02 POLICE PENSIONS 318,651 2,263,686 3,242,300 978,614 30.2
03 FIRE PENSIONS 300,557 2,112,887 3,121,500 1,008,613 32.3
Totals 623,019 4,407,055 6,410,400 2,003,345 31.3
EXPENDITURE CLASSIFICATION
53 PENSION BENEFITS 623,019 4,405,579 6,404,400 1,998,821 31.2
54 CONTRACTUAL SERVICES 0 1,350 4,500 3,150 70.0
57 COMMODITIES & SUPPLIES 0 126 1,500 1,374 91.6
Totals 623,019 4,407,055 6,410,400 2,003,345 31.3
SOURCE OF FUNDS
001 GENERAL FUND 3,811 30,482 46,600 16,118 34.6
710 POLICE PENSION FUND 318,651 2,263,686 3,242,300 978,614 30.2
720 FIRE PENSION FUND 300,557 2,112,887 3,121,500 1,008,613 32.3
Totals 623,019 4,407,055 6,410,400 2,003,345 31.3
09/16/2010 8 Months ( 66.6% ) Completed
' 10:16:36 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3% ) Remaining
FRRDBRO1
SUr4o31 Department Budget Expenditure Summary
01/01/10 - 08/31/10
Cur Mo Y -T -D 2010 Unexpended Unexpended
RISK MANAGEMENT Expended Expended Budget Balance Percent
PROGRAM TOTALS
01 CASUALTY & PROPERTY INSURANCE 37,712 768,774 927,700 158,926 17.1
02 MEDICAL INSURANCE 463,577 3,521,133 5,925,898 2,404,765 40.6
Totals 501,289 4,289,907 6,853,598 2,563,691 37.4
EXPENDITURE CLASSIFICATION
54 CONTRACTUAL SERVICES 0 0 2,000 2,000 100.0
56 INSURANCE 501,289 4,289,907 6,851,598 2,561,691 37.4
67 OTHER EQUIPMENT 0 0 0 0
Totals 501,289 4,289,907 6,853,598 2,563,691 37.4
SOURCE OF FUNDS
690 RISK MANAGEMENT FUND 501,289 4,289,907 6,853,598 2,563,691 37.4
Totals 501,289 4,289,907 6,853,598 2,563,691 37.4
23
09/16/2010 8 Months ( 66.6W ) Completed
10:16:36 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3% ) Remaining
FRRDBRO1
SUM031 Department Budget Expenditure Summary
01 /01 /10 - 08/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
la
09/16/2010 8 Months ( 66.61 ) Completed
10:16:36 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.31 ) Remaining
FRRDBRO1
SUM on Department Budget Expenditure Summary
01 /01 /10 - 08/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
09/16/2010 8 Months ( 66.61 ) Completed
10:16:36 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.31 ) Remaining
FRRDBR01
SUM On Department Budget Expenditure Summary
01/01/10 - 08/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 SEP142010 11:19 PAGE 1
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM SEPTEMBER 01 2010 TO SEPTEMBER 15 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
001
10730 A &D CONCRETE CUTTING SCEW CUT CONCRETE FLOOR FOR SE 325.00
01071 ADDISON BUILDING MATERIAL CO. LINE MARKING FLUORESCENT ORANG 60.37
STRAINER REPLACEMENT CUP; 21.94
82.31
12417 AGOLLI, MAKSIM REFUND DUPLICATE PYMT 63.00
01227 AIR ONE EQUIPMENT, INC. FILTER & OTHER SUPPLIES ST #13 463.90
THERMAL IMAGING CAMERA REPAIR 605.00
1068.90
12426 AMCAD DIGITAL CONVERSION BUILDING MICROFILM CONVERSION 1158.83
01561 AMERICAN CHARGE SERVICE SENIOR TAXI PROG AUGUST 2010 30.00
01840 ANDERSON PEST SOLUTIONS PEST MANAGEMENT SERV -SEPT 2010 48.00
09544 ANDRES MEDICAL BILLING,LTD AUGUST 2010 AMBULANCE BILLING 5026.05
02270 AT &T SERVICE 8/16/10 - 9/15/10 3.19
SERVICE 8/16/10 - 9/15/10 10.63
SERVICE 8/16/10 - 9/15/10 2.13
SERVICE 8/16/10- 9/15/10 3.19
SERVICE 8/16/10 - 9/15/10 21.26
SERVICE 8/16/10 - 9/15/10 10.63
SERVICE 8/16/10 - 9/15/10 40.40
SERVICE 8/16/10 - 9/15/10 10.63
SERVICE 8/16/10 - 9/15/10 15.95
SERVICE 8/16/10 - 9/15/10 27.64
SERVICE 8/16/10- 9/15/10 8.50
SERVICE 8/16/10- 9/15/10 8.50
SERVICE 8/16/10 - 9/15/10 38.27
SERVICE 8/16/10- 9/15/10 215.81
SERVICE 8/16/10 - 9/15/10 211.56
SERVICE 8/16/10 - 9/15/10 136.08
764.37
10128 BALDINI, CAROL REIMB EXP 8/20/10 & 8/25/10 145.48
REIMB EXP 9/8/10- 9/9/10 80.96
226.44
02566 BASIC FIRE PROTECTION INC. GAS CYLINDER 26.25
06287 BEDCO MECHANICAL 2010 MAINTENANCE CONTRACT FOR 1583.95
2010 MAINTENANCE CONTRACT FOR 282.50
1866.45
02757 BESSE MEDICAL SUPPLY HEALTH SCREENING SUPPLIES 349.92
FLU SHOT SUPPLIES 340.20
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY SEP142010 11:19 PAGE 2
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM SEPTEMBER 01 2010 TO SEPTEMBER 15 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
690.12
04631 BIRC ANNUAL MEMBERSHIP FEE - SANDY 85.00
01008 BUSSE'S FLOWERS & GIFTS DAWSON, JAIMIE 8/19/10 63.50
01049 CDW GOVERNMENT, INC 1 CAMERA & 3 MEMORY CARDS 167.69
10- 2GB SD CARDS 68.63
TONER FOR HP LJ 9040 - CDW # 2 506.00
SHIPPING 14.75
ANNUAL RENEWAL - SYMANTEC GHOS 597.00
1354.07
05375 CENTURY CLEANERS UNIFORM CLEANING 8/24 & /26 &/28 47.85
UNIFORM CLEANING 8/31- 9/10/10 41.32
89.17
01077 CHICAGO COMMUNICATIONS LLC REPAIR MCS 2000 RA14 RADIO 128.75
08975 CHICAGO OFFICE TECHNOLOGY GROUP ADDITIONAL COPIES 53.16
10855 CINTAS FIRE 16 - 10# ABC DRY FIRE EXTINGUI 1066.63
03800 CLARK, SANDRA M. REIMBURSEMENT FOR PURCHASE OF 30.00
11403 COSTAR REALTY INFORMATION, INC ED SITE SOFTWARE 435.00
05503 CRYSTAL MAINTENANCE SERVICES CORP. CCC SHARE OF MONTHLY CLEANING 590.00
CUSTODIAL SERVICE AT VILLAGE 7529.44
8119.44
09115 D.J.'S SCUBA LOCKER Registration /Redlin April 26,2 415.00
01218 DAHLBERG, JOHN REIMB EXP 8/24 & 8/31 & 9/2/10 91.94
08146 DELL MARKETING L.P. REPLACEMENT LAPTOP BATTERY 129.47
12432 DURHAM SCHOOL SERVICES BUS TRANSPORTATION 8/20/10 425.00
11272 ENTERSECT CORPORATION POLICE ONLINE SERVICE JULY2010 88.95
09653 ETERNO, DAVID G. SERVICES 8/25- 8/26/10 862.50
12365 EVERBANK COMMERCIAL FINANCE, INC SERVICE 8/24/10- 9/23/10 467.29
SERVICE 8/24/10- 9/23/10 321.91
SERVICE 8/24/10- 9/23/10 456.90
SERVICE 8/24/10- 9/23/10 830.73
SERVICE 8/24/10- 9/23/10 16.80
SERVICE 8/24/10- 9/23/10 16.80
SERVICE 8/24/10- 9/23/10 16.80
SERVICE 8/24/10- 9/23/10 16.80
SERVICE 8/25/10- 9/24/10 372.46
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY SEP142010 11:19 PAGE 3
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM SEPTEMBER 01 2010 TO SEPTEMBER 15 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
2516.49
01366 EXPERIAN BACKGROUND CHECKS - AUGUST 2010 77.00
10393 EXPERTPAY PAYROLL FOR - 090210 3115.21
11212 FDC DIGITAL IMAGING SOLUTIONS ANNUAL MAINTENANCE FOR KIP PLO 59.00
01377 FEDERAL EXPRESS CORP SHIPPING CHARGES 42.89
PORTABLE RADIOS REPAIR &BATTERY 70.89
SHIPPING - PLANNING DIVISION 35.98
149.76
07176 FIRE DEPARTMENT TRAINING NETWORK,INC. MEMBERSHIP - TRUTY, CHRIS 240.00
00102 FIRE PENSION FOND PAYROLL FOR - 090210 22292.64
07762 FORR, BRYAN REIMB EXP 8/24 - 8/26/10 24.00
01461 GALLS, AN ARMARK COMPANY CROSSING GUARD EQUIP 68.24
CROSSING GUARD EQUIP 79.68
GLOVES 26.58
174.50
09198 GE CAPITAL SERVICE 8/15/10 - 9/14/10 198.96
SERVICE 8/15/10- 9/14/10 198.94
SERVICE 8/15/10- 9/14/10 198,94
SERVICE 8/15/10- 9/14/10 198.94
795.78
09113 HEALY ASPHALT COMPANY,LLC. 9.71 TONS SURFACE ASPHALT MATE 534.05
6.83 TONS SURFACE ASPHALT MATE 375.65
0.51 TONS SURFACE ASPHALT MATE 28.05
1.07 TONS SURFACE ASPHALT MATE 58.85
996.60
01610 HOME DEPOT CREDIT SERVICES #1154498 PORTABLE HEATER #545 21.30
11987 HOMER TREE CARE, INC PARKWAY TREE REMOVAL CONTRACT 1892.00
PARKWAY TREE REMOVAL CONTRACT 724.00
2616.00
09425 HSBC BUSINESS SOLUTIONS TELEVISION 329.99
TELEVISION 329.99
BOARD MEETING SUPPLIES 24.68
OFFICE SUPPLIES 63.95
INSP SUPPLIES 21.98
VILLAGE EMPLOYEE PICNIC 260.82
CAKE /SALAND INTERNS 25.58
OFFICE SUPPLIES 32.44
REFRESHMENTS 102.10
PHOTOS OF P 1/2 5.84
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY SEP142010 11:19 PAGE 4
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM SEPTEMBER 01 2010 TO SEPTEMBER 15 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
MOVING BLANKETS 17.99
1215.36
01636 IACE 9/8/10 BOB ROELS 30.00
9/8/10 CHERYL SCHERBAUM 30.00
9/8/10 FRANK KRUPA 30.00
9/8/10 J. HERNANDEZ 30.00
9/8/10 R. GARCIA 30.00
150.00
01648 IBBOTSON HEATING CO. INSPECTION BOND REFUND 125.00
00107 ICMA RETIREMENT TRUST - 457 PAYROLL FOR - 090210 17501.35
06690 ILLINOIS AMERICAN WATER CO. SERVICE 8/2/10- 9/1/10 218.95
PRIVATE FIRE SERVICE 28.28
247.23
00108 ILLINOIS DEPARTMENT OF REVENUE PAYROLL FOR - 090210 24478.67
12430 ILLINOIS HOMICIDE INVESTIGATORS ASSOCIATION REGISTRATION 10/12 - 10/13/10 350.00
09562 IMRF PAYROLL FOR - 090210 467.82
PAYROLL FOR - 090210 41225.95
PAYROLL FOR - 090210 18969.00
60662.77
09832 INTERNATIONAL UNION OF OPERATING ENGINEERS PAYROLL FOR - 090210 986.88
PAYROLL FOR - 090210 284.13
1271.01
01753 IPELRA 2010 REGISTRATION - D.STRAHL 375.00
09563 IRS PAYROLL FOR - 090210 187233.41
12419 JANG, HYUNJOO REFUND VEHICLE LICENSE FEE 63.00
00353 JANONIS, MICHAEL E. REIMB EXP 8/27/10 118.28
01818 KERSTEIN, JUNE REIMB SEPTEMBER 2010 95.31
09766 LANER MUCHIN SERVICES AUGUST 2010 52.50
09918 LAUBE CONSULTING GROUP LLC SERVICE MAY 2010 580.00
08631 LECHNER AND SONS PW UNIFORM RENTAL AND CLEANING 232.86
PW UNIFORM RENTAL AND CLEANING 116.43
349.29
10450 LEXISNEXIS RISK DATA MANAGEMENT INC BACKGROUND CHECKS- AUGUST 2010 68.20
•
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY SEP142010 11:19 PAGE 5
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM SEPTEMBER 01 2010 TO SEPTEMBER 15 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
09606 LIETZOW, ANTHONY REIMB EXP 8/16 - 8/19/10 127.00
01897 LIFE ASSIST Paramedic Equipment - BP Cuffs 1108.82
07267 LPS PAVEMENT CO. BRICK PAVER REPAIRS AT VARIOUS 4987.50
01918 LUNDSTROM'S NURSERY, INC. AERATION FOR FOUNDERS PLAZA ON 40.00
LANDSCAPE MAINTENANCE AT VARIO 3111.78
3151.78
12420 MAGNA -MATIC CORPORATION RIFLE CLEANING SUPPLIES 151.20
05021 MENARDS (2) 24" DIAMOND PATTERN PAVERS 15.98
00116 METRO FEDERAL CREDIT UNION PAYROLL FOR - 090210 5146.99
00117 METROPOLITAN ALLIANCE - POLICE PAYROLL FOR - 090210 1010.50
02826 MICHAEL WAGNER & SONS, INC. (4) CLOBBER 1 /2GAL 20-211 105.92
(1) CLEANOUT GRIP 3.5" 10.89
PVC PIPE 4 "; PVC CEMENT' PURPL 115.99
232.80
09523 MICRO TECH SYSTEMS,INC. REPAIRS TO HP LASERJET #P3005D 128.95
02046 MOBILE PRINT INC. PRINTING /LOCKOUT RELEASE 263.84
2500 EA ENVELOPES 461.72
725.56
08153 MOISE, BRIAN REIMB EXP 8/23 - 8/25/10 24.00
02064 MOTOROLA, INC. LABOR & REPAIR 393.00
02068 MOUNT PROSPECT LIONS CLUB, INC FIREWORKS JULY 2010 3500.00
02085 MUNICIPAL CLERKS ASSOCIATION DINNER MEETING 9/15/10 25.00
02085 MUNICIPAL CLERKS NORTH & NORTHWEST SUBURBS MEMBERSHIP 10 -11 ANGELL &DEWIS 40.00
02109 NATIONAL ARBOR DAY FOUNDATION ANNUAL MEMBERSHIP - SANDY CLAR 15.00
00123 NATIONWIDE MUTUAL INSURANCE COMPANY PAYROLL FOR - 090210 15994.73
02148 NEOPOST INC. MONEY ENTERED INTO POSTAGE M 3000.00
05256 NICOR SERVICE 7/21/10 - 8/20/10 31.01
SERVICE 7/21/10 - 8/20/10 31.01
NATURAL GAS CONSUMPTION AT 50 1667.71
NATURAL GAS CONSUMPTION AT 160 148.12
NATURAL GAS CONSUMPTION AT 11 30.02
NATURAL GAS CONSUMPTION AT 200 203.63
2111.50
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY SEP142010 11:19 PAGE 6
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM SEPTEMBER 01 2010 TO SEPTEMBER 15 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
02165 NIPSTA Registration /Hayes Michael 150.00
Registration/ Peterson Instruc 300.00
450.00
09228 NIU GMIS CONFERENCE 11 /1 /10 250.00
12429 NORTH TOWN MECHANICAL SERVICES REFUND BUILDING PERMIT #10 -1643 895.00
02189 NORTHWEST CENTRAL DISPATCH SYS OCT 2010 MEMBER ASSESSMENT 36767.60
OCT 2010 MEMBER ASSESSMENT 9191.90
45959.50
02193 NORTHWEST ELECTRICAL SUPPLY (60) FLUORESCENT LAMPS; (6) CF 100.30
02228 OAKTON PAVILLION HEALTHCARE 615HOME DELIVERED MEALS -AUG 10 2460.00
578HOME DELIVERED MEALS JULY10 2312.00
4772.00
10162 OVERHEAD GARAGE DOOR,INC. TEMPORARY REPAIRS TO BROKEN 215.00
REPLACE TWO SPRINGS AND BEARIN 1195.00
1410.00
10444 PANEK, ADAM REIMB CLOTHING ALLOWANCE 9/10 150.00
12415 PETTY CASH - FINANCE DEPARTMENT MISCELLANEOUS AUGUST 2010 150.77
MISCELLANEOUS AUGUST 2010 5.77
MISCELLANEOUS AUGUST 2010 40.00
MISCELLANEOUS AUGUST 2010 23.75
MISCELLANEOUS AUGUST 2010 12.00
MISCELLANEOUS AUGUST 2010 11.20
MISCELLANEOUS AUGUST 2010 201.12
444.61
12415 PETTY CASH - MANAGER'S OFFICE EARLY CLOSED SESSION 9/7/10 78.65
WELLNESS COMMITTEE 9/7/10 27.50
CHICKEN FOR BLOCK PARTY 6/19 79.93
SUPPLIES FOR MEETING 6/19 26.14
CAB FOR MAYOR 8/11 10.00
10 RIDE METRA TICKET 7/1 32.30
NOTARY REGISTRATION- DOREEN6 /28 5.00
REGISTRATION - C.O'SHEA 8 /11 10.00
269.52
09021 PITNEY BOWES,INC. ANNUAL MAINT AGREEMENT 1587.00
00124 POLICE PENSION FUND PAYROLL FOR - 090210 26818.69
04921 POPE, ELIZABETH A. PAYROLL FOR - 090210 923.08
02333 PORTER LEE CORPORATION SUPPLIES- BEAST 376.00
•
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY SEP142010 11:19 PAGE 1
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM SEPTEMBER 01 2010 TO SEPTEMBER 15 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
02379 QUILL CORPORATION OFFICE SUPPLIES 162.98
12422 READY PRESS LLC 1500 ARREST JACKETS 495.00
07964 RMS TECHNOLOGY SOLUTIONS ROUTING CHANGES NWCDS 1202.50
10715 SIMMONS, BRIAN REIMB EXP 9/22/10- 9/24/10 310.00
10316 SOS TECHNOLOGIES 8 - MRX Batteries 2860.95
02155 SPRINT SERVICE 7/24/10 - 8/23/10 39.99
04139 STANARD & ASSOCIATES, INC PUBLIC SAFETY EVALUATION 7/22 375.00
09165 STAPLES ADVANTAGE TONER 166.99
SUPPLIES 49.50
SUPPLIES 32.99
249.48
12436 STEINWEG, DELANIE REIMB EXP 9/1/10 68.51
00441 STRAHL, DAVID ADVANCE 10/24- 10/27/10 40.00
11971 TAPCO 36 "X36" NO LEFT TURN; 36 "X36" 79.28
11992 TELVENT DTN, INC WEATHER FORECASTING EQUIPMENTA 155.94
WEATHER FORECASTING EQUIPMENTA 268.46
424.40
04838 THIRD MILLENNIUM ASSOC.INC. VEHICLE MAILING 8/13/10 3450.00
02691 THOMPSON ELEVATOR INSPECTIONS 2 ELEVATOR PLAN REVIEWS 150.00
2 NEW CONST. ELEVATOR INSPEC 150.00
300.00
04276 TRUGREEN CONTRACT FOR SPRAYING 290.00
11261 TUCKER, TOM REIMB EXP SUPPLIES AUG 2010 63.17
07488 OIDL, RANDY REIMB EXP 8/24- 8/28/10 76.00
05686 ULINE INC. 4PKS OF DVD -R PHOTO /VIDEO EVID 80.24
11241 ULTRA STROBE COMMUNICATIONS, INC 1 INTERSTATE BATTERY FOR P 1/2 130.00
02756 UNITED STATES POSTAL SERVICE EMS CARDS- AUGUST 2010 9.34
VEHICLE STICKERS- AUGUST 2010 1520.49
1529.83
00127 UNITED WAY PAYROLL FOR - 090210 373.91
12001 OS BANK USAGE 9/20/10 195.00
USAGE 9/20/10 265.00
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY SEP142010 11:19 PAGE 8
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM SEPTEMBER 01 2010 TO SEPTEMBER 15 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
USAGE 9/20/10 275.00
USAGE 9/20/10 195.00
USAGE 9/20/10 156.00
USAGE 9/20/10 138.78
USAGE 9/20/10 137.50
1362.28
00128 VILLAGE OF MOUNT PROSPECT PAYROLL FOR - 090210 24236.62
PAYROLL FOR - 090210 12700.42
36937.04
09580 VILLAGE OF ROMEOVILLE FIRE ACADEMY Registration/ Woleben Matt Tre 420.00
12423 WARD, BERNICE REFUND OVER PYMT 42.00
02835 WAREHOUSE DIRECT SUPPLIES 373.86
07440 WIDE OPEN WEST SERVICE 8/7/10- 9/6/10 72.99
02876 WILKS, IRVANA SERVICE 8/16/10 - 9/15/10 45.00
02878 WILLIAM RAINEY HARPER COLLEGE INTERMEDIATE EXCEL TRAINING 1100.00
05746 WISCTF PAYROLL FOR - 090210 542.48
05269 WORLDPOINT ECC, INC. 3 -Pack 80 -1203 AHA HS AED Card 330.00
TOTAL : 532950.86
030
02270 AT &T SERVICE 8/16/10 - 9/15/10 4.25
12424 EQUITY VENTURES REALTY REFUND UTILITY BILL 12.50
09663 LANCASTER TRACTOR & EQUIPMENT,INC. TIRE DEFLECTORS AND OIL PAN 616.36
02610 STANDARD EQUIPMENT COMPANY 16 - SWEEPSTER BROOMS 01 -0621C 2450.00
16 - SWEEPSTER BROOMS 01 -0621C 1225.00
3675.00
TOTAL : 4308.11
050
05709 MEADE ELECTRIC CO. INC. 2010 EMERGENCY & PREVENTATIVE 1976.00
02343 PREFORM TRAFFIC CONTR SYS,LTD. 2010 PAVEMENT MARKING CONTRACT 45776.12
TOTAL : 47752.12
070
12365 EVERBANK COMMERCIAL FINANCE, INC SERVICE 8/24/10- 9/23/10 16.80
01377 FEDERAL EXPRESS CORP SHIPPING -CDGB 28.17
•
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY SEP142010 11:19 PAGE 9
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM SEPTEMBER 01 2010 TO SEPTEMBER 15 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
09198 GE CAPITAL SERVICE 8/15/10- 9/14/10 198.94
01796 K.A.M. CONSTRUCTION SINGLE F. REHAB -1760 CORKTREE 12897.52
SINGLE F. REHAB -1760 CORKTREE 11458.68
24356.20
02256 PADDOCK PUBLICATIONS ACTION PLAN LEGAL NOTICE 8/23 62.10
TOTAL : 24662.21
095
04336 FOEHRING, WILLIAM REIMB EXP 8/16/10 44.00
TOTAL : 44.00
510
12427 FARRADAY, SUNNA RREIMB WEATHERIZATION REBATE 1500.00
04434 GEWALT HAMILTON ASSOCIATES, INC. KENSINGTON ROAD IMPROVEMENTS 1302.54
09567 ID NETWORKS,INC. LIVESCAN SYSTEM W/ ACCESSORIES 19810.00
07964 RMS TECHNOLOGY SOLUTIONS INSTALLATION 1711.25
CONFIGURATION STATION #14 277.50
INSTALLATION P2P WIRELESS 13120.00
15108.75
10432 STERNBERG LIGHTING INC. STERNBERG PED POLE W /DECORATIV 1807.06
12428 WESTGOR, MELAINE REIMB WEATHERIZATION REBATE 775.00
TOTAL : 40303.35
528
12371 ACCESSIBLE DESIGN & CONSULTING, INC 3 - Brown 3 Foot Collapsible W 143.50
12425 ADVANCED COMMUNICATIONS, INC DEVLOP WRITEEN SPECIFICATION 2000.00
01610 HOME DEPOT CREDIT SERVICES #3077160 NEW STATION #14 149.72
12280 TRUCK DIAGNOSTICS INC FIRE TRUCK DIAGNOSTIC SCANNER 3346.91
ALLISON DOC 8.0 WORLD TECH 849.42
DETROIT DIESEL SOFTWARE FOR AL 2700.00
MERITOR WABCO 7.0 SOFTWARE & 312.06
7208.39
TOTAL : 9501.61
550
07267 LPS PAVEMENT CO. BRICK PAVER REPAIRS AT VARIOUS 4987.50
01918 LUNDSTROM'S NURSERY, INC. LANDSCAPE MAINTENANCE AT VARIO 7441.22
TOTAL : 12428.72
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY SEP142010 11:19 PAGE 10
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM SEPTEMBER 01 2010 TO SEPTEMBER 15 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
560
12122 MDS TECHNOLOGIES, INC 2010 PAVEMENT CONDITION EVALOA 5706.00
TOTAL : 5706.00
590
02927 BOESCHE, JAMES REPAIR OF 2 BRIDGE WALLS ON 6800.00
TOTAL : 6800.00
610
01833 ANDERSON LOCK COMPANY SCHLAGE PRIMUS PADLOCKS - 3120.92
SCHLAGE PRIMUS PADLOCKS - 761.20
SHIPPING 43.51
OVERAGE PO #S011056 SHIPPING 3.49
3929.12
02270 AT&T SERVICE 8/16/10 - 9/15/10 283.85
11810 BAGINSKI, MARIA REFUND UTILITY BILL 149.51
05773 BAXTER & WOODMAN, INC. PROFESSIONAL SERVICES FOR 2010 7926.90
PROFESSIONAL SERVICES FOR 2010 5284.60
13211.50
12418 BROWN, MARY REFUND FINAL UTILITY BILL 17.49
05375 CENTURY CLEANERS UNIFORM CLEANING 8/24&/26 & /28 47.85
UNIFORM CLEANING 8/31 - 9/10/10 41.33
89.18
01323 EAST JORDAN IRONWORKS 6' BURY DEPTH CD 250 EJIW FIRE 3940.00
20 - WATER MANHOLE LIDS 1700.00
5640.00
08829 ENGLEWOOD ELECTRICAL SUPPLY SCADA COMPONENTS NEEDED TO ALL 1746.93
FREIGHT 17.43
1764.36
12424 EQUITY VENTURES REALTY REFUND UTILITY BILL 10.00
12251 EXELON ENERGY COMPANY ELECTRICAL SERVICE DELIVERY AT 1348.83
08425 FARNSWORTH GROUP TROUBLE SHOOTING OF VFD #3 AT 1140.00
PROGRAM PLC TO CONTROL AND MON 2585.40
3725.40
09487 FELLOW, MICHAEL REIMB EXP 8/27/10 79.99
12062 FRAZIER CONCRETE, INC CONCRETE RESTORATION CONTRACT 2670.11
•
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY SEP142010 11:19 PAGE 11
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM SEPTEMBER 01 2010 TO SEPTEMBER 15 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
CONCRETE RESTORATION CONTRACT 3639.32
CONCRETE RESTORATION CONTRACT 1237.75
CONCRETE RESTORATION CONTRACT 708.34
8255.52
01522 GRAINGER INC. 1 DEWALT COMBINATION ROTARY 695.10
01544 HBK WATER METER SERVICE WATER METER 542.55
BUILDING INSPECTION SERVICES. 180.85
WATER METER 829.05
BUILDING INSPECTION SERVICES. 276.35
WATER METER 512.55
BUILDING INSPECTION SERVICES. 170.85
2512.20
09883 HD SUPPLY WATERWORKS, LTD. 20 - 6" HYMAX COUPLINGS 3483.40
10 - 6X10 REPAIR CLAMP 686.60
4 - 6X15 REPAIR CLAMP 358.20
6 - 6X20 REPAIR CLAMP 844.08
1 - 6X30 REPAIR CLAMP 201.09
1 - 10X10 REPAIR CLAMP 101.51
1 - 10X15 REPAIR CLAMP 140.32
1 - 10X20 REPAIR CLAMP 192.85
1 - 12X15 REPAIR CLAMP 166.51
6174.56
11987 HOMER TREE CARE, INC REMOVE 40" WILLOW TREE FOR LIF 1245.00
09425 HSBC BUSINESS SOLUTIONS SUPPLIES 180.03
08631 LECHNER AND SONS PW UNIFORM RENTAL AND CLEANING 232.82
PW UNIFORM RENTAL AND CLEANING 116.41
349.23
06994 LEE JENSEN SALES CO. INC. 1 - POWER GRIT CHAIN FOR 340.00
24 - 25:1 OIL MIX FOR POWER GR 43.20
383.20
01965 MARTAM CONSTRUCTION INSERT 16" VALVE & 72" VALVE 9442.03
05021 MENARDS DH ABS GRAIN SCOOP; (5) ALUMIN 177.77
(3) BAGS OF SAKRETE CONCRETE M 8.22
185.99
02826 MICHAEL WAGNER & SONS, INC. REPAIR HYDRANT METER 210.81
05256 NICOR NATURAL GAS CONSUMPTION AT 117 81.87
NATURAL GAS CONSUMPTION AT 112 83.60
NATURAL GAS CONSUMPTION AT SS 96.49
261.96
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY SEP142010 11:19 PAGE 12
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM SEPTEMBER 01 2010 TO SEPTEMBER 15 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
12421 PUNJABI, SHIVKUMAR REFUND FINAL UTILITY BILL 109.20
08337 RICK'S SEWER AND DRAINAGE FOOTING TILE DISCONNECT & OH S 12750.00
FOOTING TILE DISCONNECT & OH S 12750.00
ELECTRICAL UPGRADE FOR FOOTING 1800.00
27300.00
02568 SMITH ECOLOGICAL SYSTEMS, INC. (12) SCREEN VENT ASSY. & SHIPP 114.55
02654 SUBURBAN GENERAL CONST. INC. 2010 SEWER LINE SPOT RELAYS 44955.00
02655 SUBURBAN LABORATORIES, INC. ANNUAL IEPA- REQUIRED WATER SAM 693.35
ANNUAL IEPA - REQUIRED WATER SAM 260.15
953.50
02756 UNITED STATES POSTAL SERVICE PERMIT 699 -WATER AUGUST 2010 2052.54
12001 US BANK USAGE 9/20/10 137.50
02775 USA BLUEBOOK 4 - CRUSH PROOF SUCTION HOSES 744.84
TOTAL : 136511.99
620
05503 CRYSTAL MAINTENANCE SERVICES CORP. CUSTODIAL SERVICE AT VILLAGE 1481.40
12415 PETTY CASH - FINANCE DEPARTMENT MISCELLANEOUS AUGUST 2010 8.00
02343 PREFORM TRAFFIC CONTR SYS,LTD. 2010 PAVEMENT MARKING CONTRACT 3381.77
TOTAL : 4871.17
630
05503 CRYSTAL MAINTENANCE SERVICES CORP. CUSTODIAL SERVICE AT VILLAGE 189.16
12415 PETTY CASH - FINANCE DEPARTMENT MISCELLANEOUS AUGUST 2010 6.00
MISCELLANEOUS AUGUST 2010 4.00
10.00
02343 PREFORM TRAFFIC CONTR SYS,LTD. 2010 PAVEMENT MARKING CONTRACT 2258.40
02754 ONION PACIFIC RAILROAD LAND LEASE FOR AUGUST 2010 2843.67
TOTAL : 5301.23
660
01071 ADDISON BUILDING MATERIAL CO. 17.500 WASP SPRAY 23.88
02070 ARLINGTON HEIGHTS FORD OEM - REAR BRAKE PARTS FOR 407.84
02108 ARLINGTON POWER EQUIPMENT ENGINE PARTS #4555 87.21
ENGINE CONTROL #4555 29.10
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY SEP142010 11:19 PAGE 13
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM SEPTEMBER 01 2010 TO SEPTEMBER 15 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
116.31
02270 AT &T SERVICE 8/16/10- 9/15/10 10.65
02938 BOWMAN DISTRIBUTION CENTER SHOP SUPPLIES 466.60
ELECTRICAL CONNECTORS FOR NEW 124.46
591.06
12412 BRAD'S SALES COMPANY, INC SHOP RAGS (STATE CONTRACT) 540.00
01045 CATCHING FLUIDPOWER (2) COUPLERS 16.64
03958 CHICAGO INTERNATIONAL TRUCK WATER POMP FOR 4558 110.31
01236 DAVE & JIM'S AUTO BODY, INC. FRONT END ALIGNMENT FOR P -5 50.00
01352 ENGINEMASTERS, INC. STOCK FILTERS FOR #2765 56.10
06691 JUST TIRES 72 SCRAP TIRES 180.00
01914 LUND INDUSTRIES, INC. E- LIGHTS FOR P -11 169.00
01990 MCMASTER -CARR SUPPLY CO. LOW - VOLTAGE LIGHT CONTROL WITH 81.16
25FT BATTERY CABLE FOR #2756 38.75
(2) PUSH -IN FLEXIBLE RUBBER 20.85
AMBULANCE LIGHT SENSORS 58.96
199.72
02058 MORTON GROVE AUTOMOTIVE EMERGENCY REPAIR TO THE ALTERN 2600.00
REBUILD ALTERNATOR - TRUCK #31 135.00
2735.00
02107 NAPA - HEIGHTS AUTOMOTIVE SUPPLY REAR AXLE SEAL FOR AMBULANCE # 12.49
FUSES 11.96
STEERING PARTS FOR P -5 162.36
186.81
07663 PRAIRIE INTERNATIONAL TRUCK SALES (10) TERMINALS 17.40
PASSENGER VISOR FOR #4513 (STA 58.57
INTERNATIONAL TRUCK FUEL STRAI 98.10
NEWER INTERNATIONAL TRUCK WATE 53.15
227.22
07882 PRECISION SERVICE & PARTS A/C ACC. CUPI #N -51 & STOCK 101.82
(12) AIR FILTERS FOR FORD TRUC 192.00
AIR & FUEL FILTERS FOR P -1 & P 162.18
FORD GAS ENGINE OIL 566.36
REAR CALIPER SLIDES FOR AMBULA 32.90
1055.26
02601 SPRING ALIGN OF PALATINE, INC REMOVE & INSTALL NEW REAR SPRI 1199.90
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY SEP142010 11:19 PAGE 14
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM SEPTEMBER 01 2010 TO SEPTEMBER 15 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
04472 TEXOR PETROLEUM CO FUEL PURCHASE 8/26/10 17453.10
09217 WAYTEK, INC. RED /BLACK BATTERY CABLE FOR NE 216.49
11836 WICKSTROM FORD LINCOLN MERCURY REPLACE TRANSMISSION WITH FORD 2375.64
TOTAL : 27920.93
670
01227 AIR ONE EQUIPMENT, INC. CHARGER FOR AMBULANCE #525 633.00
01431 FOSTER COACH SALES INC. 9.75 NUMBER'S WITH SHADING FOR 169.29
06403 LINDCO EQUIPMENT SALES, INC. HYD. TANK & VALVES 6352.30
3 STICK ELECTRIC CONSOLE 5571.65
ACS WIRE HARNESSING 929.45
12853.40
11643 PARKSIDE AUTO BODY INC 2 - PAINT P -6 & P -18 ALL WHITE 995.80
TOTAL : 14651.49
680
01049 CDW GOVERNMENT, INC HP LJ 90401N - CDW # 947354 3109.00
HP 128MB RAM FOR 9040DN - CDW 31.00
HP LJ P4515N - CDW # 1436073 1550.00
SHIPPING 81.77
4771.77
TOTAL : 4771.77
690
01335 ALEXIAN BROTHERS CORPORATE HEALTH SERVICES TIM BRIGGS- 10I:7/20/10 696.88
TIM BRIGGS -DOI:7 /20/10 140.13
KRYSTAL HANSON- D0I:8 /11 /10 316.25
1153.26
10010 BURKHARDT, GAIL REIMB EXP 8/18/10 99.25
01102 GAB ROBINS N.A., INC - CITIBANK PAYMENT OF INS CLAIMS 8/18/10 35.00
09097 ILLINOIS STATE TREASURER W/C RATE ASSESSMENT1 /1- 6/30/10 2918.81
TOTAL : 4206.32
710
02637 BECKER, BURKE ASSOCIATES INC ADJUSTMENT QUARTERLY REPORTS 1500.00
07263 RICHARD REIMER & ASSOC.,LLC. LEGAL SERVICES JULY 2010 3008.29
09635 WELLS FARGO BANK, N.A. POLICE BANK CHARGES 8/1 -10/31 1003.71
TOTAL : 5512.00
•
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY SEP142010 11:19 PAGE 15
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM SEPTEMBER 01 2010 TO SEPTEMBER 15 2010
DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT
720
02637 BECKER, BURKE ASSOCIATES INC ADJUSTMENT QUARTERLY REPORTS 1500.00
12431 ILLINOIS PUBLIC PENSION ADVISORY COMMITTEE SEMINAR 2010 636.00
09635 WELLS FARGO BANK, N.A. FIRE BANK CHARGES 8/1 -10/31 1080.86
TOTAL : 3216.86
770
08178 GUARDIAN EMP DENTAL PLAN SEPTEMBER 2010 8063.32
TOTAL : 8063.32
790
01719 NCPERS GROUP LIFE INS. PREMIUM SEPTEMBER 2010 736.00
PREMIUM SEPTEMBER 2010 16.00
752.00
02689 THIRD DISTRICT CIRCUIT COURT BOND MONEY 9/2/10 1063.00
BOND MONEY 9/7/10 2600.00
BOND MONEY 9/9/10 1275.00
BOND MONEY 9/14/10 4375.00
9313.00
02886 WISCONSIN DEPARTMENT OF REVENUE WISC. INCOME TAX AUGUST 2010 257.44
TOTAL : 10322.44
GRAND TOTAL : 909806.50
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY SEP142010 11:19 PAGE 16
RELEASE ID :
VILLAGE OF MOUNT PROSPECT
LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES
FROM SEPTEMBER 01 2010 TO SEPTEMBER 15 2010
SUMMARY BY FUND
001 GENERAL FUND 532950.86
030 REFUSE DISPOSAL FUND 4308.11
050 MOTOR FUEL TAX FUND 47752.12
070 COMMUNITY DEVELPMNT BLOCK GRNT 24662.21
095 FOREIGN FIRE TAX BOARD FUND 44.00
510 CAPITAL IMPROVEMENT FUND 40303.35
528 SERIES 2009 CONST FUND 9501.61
550 DOWNTOWN REDEVLPMNT CONST 12428.72
560 STREET IMPROVEMENT CONST FUND 5706.00
590 FLOOD CONTROL CONST FUND 6800.00
610 WATER AND SEWER FUND 136511.99
620 VILLAGE PARKING SYSTEM FUND 4871.17
630 PARKING SYSTEM REVENUE FUND 5301.23
660 VEHICLE MAINTENANCE FUND 27920.93
670 VEHICLE REPLACEMENT FUND 14651.49
680 COMPUTER REPLACEMENT FUND 4771.77
690 RISK MANAGEMENT FUND 4206.32
710 POLICE PENSION FUND 5512.00
720 FIRE PENSION FUND 3216.86
770 FLEXCOMP ESCROW FUND 8063.32
790 ESCROW DEPOSIT FUND 10322.44
TOTAL : 909806.50
•
REPORT: APBOARDRPT GENERATED: 15 APR 09 11:42 RUN: TUESDAY SEP142010 11:19 PAGE 1
REPORT PARAMETERS
ORGANIZATION NO. : 001
STARTING CHECK DATE : 09/01/10
ENDING CHECK DATE : 09/15/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 .
09/14/10 Village of Mount Prospect Page 1
EMR025
List of Escrow Checks Presented to the Board of Trustees
09/15/10 To 09/15110
Paid to Permit # Check # Amount
ADMINA CORP 100462 13024445 25.00
GEISER - BERNER PLBG 091426 13024446 125.00
IBBOTSON HEATING CO 100260 13024447 125.00
JNL CLIMATE CONTROL INC 101686 13024448 75.00
NORTH TOWN MECHANICAL SERVICES 101643 13024449 375.00
PATEL, KALPESH K 091488 13024450 125.00
SCARAVALLE CONSTRUCTION 101236 13024451 375.00
* ** TOTAL NUMBER OF CHECKS 7 1,225.00