HomeMy WebLinkAbout3. Financial Report and Bills 07/19/2011Ilk Mount Pmspc
Village of Mount Prospect
Mount Prospect, Illinois
INTEROFFICE MEMORANDUM
TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES
FINANCE COMMISSION
FROM: FINANCE DIRECTOR
DATE: JULY 14, 2011
SUBJECT: MONTHLY FINANCIAL REPORT — JUNE 2011
Attached hereto are the cash position and investment statements of the Village for the month
ended June 30, 2011. These statements provide a snapshot of the Village's cash position as of
the month end date noted and are intended to supplement the budget revenue and expenditure
summary and listing of bills you receive. The first statement presents the Village's cash position
broken down by governmental and enterprise funds and trust and agency funds. The second
statement presents the Village's cash position by fund type. The third statement presents the
list of investments again broken down by governmental and enterprise funds and trust and
agency funds. It is important to note that although we have included the trust and agency funds
in the cash position report, these are not funds accessible for Village operations. They are
restricted for pension and escrow funding only. Please read the summary that follows for further
detail on the cash position of the Village.
Cash and Investment Position Report — All Funds (page 1)
This report provides a detail summary of cash and investments for the Village broken out by
governmental and enterprise funds and trust and agency funds. Governmental funds include
the General Fund, Special Revenue Funds, Debt Service Funds, Capital Project Funds and
Internal Service Funds. The Enterprise Funds consist of the Water /Sewer Fund and two (2)
Parking Funds.
Trust funds include the Village's two public safety pensions (Police and Firefighters') while the
agency funds include the Escrow Deposit, Flexcomp Escrow, Special Service Area and Library
Bonds Escrow Funds. The Escrow Deposit Fund accounts for refundable deposits held by the
Village to ensure completion of public improvements. The Flexcomp Escrow Fund accounts for
employee payroll deductions pursuant to a Section 125 flexible compensation plan. The Special
Service Area Fund and Library Bonds Escrow Fund accounts for the accumulation of monies for
debt service payments.
Governmental and Enterprise Funds - Cash and cash equivalents at May 31 were $27.4
million. During June, cash receipts totaled $4,054,738.39. In addition investment income for
the month was $1,899.32 and outflows due to Interfund activity totaled $245,679.10.
Reductions in cash and cash equivalents during May totaled $5,725,905.84. Of this amount,
payments to vendors were $4,411,928.55, employee payroll and related expenses were
$1,309,887.21 and other disbursements were $4,090.08. Cash and cash equivalents at June
30 were $25.5 million.
Monthly Financial Report — June 2011
July 14, 2011
Page 2
There were no funds held in investments during the month of June. Funds were held in cash
money market accounts that currently earn competitive rates of interest.
Total cash and investments for Governmental and Enterprise Funds at May 31 were
$27,413,132.22. Cash and investments at June 30 totaled $25,498,184.99. This is a decrease
of $1,914,947.32.
Trust and Agency Funds - Cash and cash equivalents at May 31 were $6.9 million. During
June, cash receipts totaled $210,934.24. In addition investment income for the month was
$213,927.51 and inflows due to Interfund activity totaled $245,679.10. There was also a net
decrease in cash due to investment activities of $104,512.48. Reductions in cash and cash
equivalents during June totaled $661,822.87. Of this amount, payments to vendors were
$173,012.36 and employee payroll and related expenses were $487,726.60. Other
disbursements were $1,083.91. Cash and cash equivalents at June 30 were $6.8 million.
Total investments at June 30 were $85,310,351.81, a decrease of $36,621.46 from May 31,
2011. There were unrealized investment losses of $141,133.94 and a transfer from cash of
$104,512.48 that accounted for the change.
Total cash and investments for Trust and Agency Funds at May 31 were $92.2 million. Cash
and investments at June 30 totaled $92.1 million. This is a decrease for the month of
$132,415.96.
Summary of Cash Activity by Fund Type (page 2)
This report provides a breakdown of the cash activity for the month broken down by fund type.
This breakdown is useful in identifying where the activity (receipts and disbursements) is
occurring. There are times during the year when activity in certain funds such as the capital
improvement and special revenue funds is higher than normal. This will distort the financial
picture of some of the other components of the governmental funds such as the General Fund
which tends to be more level and predictable in terms of spending and receipt of revenue. Each
month the report will provide detail explanation on activity of the General Fund, the Village's
primary operating fund. The report will also provide additional information on fund types that
experienced higher than normal activity for the month. Each of these is highlighted below.
General Fund — Cash and cash equivalents at May 31 totaled $8,956,095.55. During June,
cash receipts totaled $2,511,133.04 and investment income was $1,400.49. Significant cash
receipts included sales taxes, state income tax and telecommunication tax.
Sales tax revenues for the month totaled $1,056,035. Of this amount, $963,295 was
generated from the 1 % state portion while $92,740 was generated from the .25% home rule
portion. The state portion showed an increase of 11.2% from last year same time. The
home rule portion also grew from the prior year by 3.2 %. The difference between the two
sales tax sources in their change from prior year is due to the tax being assessed on a
different set of goods. Sales taxes received in June are for March sales as there is a three -
month lag in getting this distribution from the state.
H:WCC'Ureasurer's Report\2011 \Monthly Financial Report\Monthly Cash Position Report -June 2011.docx
Monthly Financial Report — June 2011
July 14, 2011
Page 3
State income tax receipts for June totaled $477,475. These monies were actually to be
received by the Village in January. The state is 120+ days delinquent in making these
remittances to the Village. The state is currently $1.5 million in arrears in remitting income
taxes to the Village.
Telecommunication tax receipts for June reflect March activity. Total receipts during June
were $179,995 and fell short of prior year receipts by 17.1 % for the month and 11.8% below
year -to -date. We may need to make a year -end adjustment if this trend continues.
Disbursements from the General Fund for June included payments to vendors of $1,450,908.58
and payments for employee wages and benefits of $1,113,728.00. Interfund transfers of $2.9
million for health premiums and vehicle lease and maintenance payments were also made
during June.
Cash and cash equivalents at June 30 were $5,923,287.09. There were no investments in the
General Fund at June 30.
Statement of Investments (page 3)
This report provides a breakdown of investments by governmental and enterprise funds and
trust and agency funds. The report also provides a fund -by fund breakdown of the investments.
Government and Enterprise Funds - Investments for the governmental and agency funds are
typically made up of Certificates of Deposit. At June 30 there were no CD's placed at any bank.
This is due to the extremely low interest rates being offered. Money instead has been placed in
interest bearing money market accounts
Trust and Agency Funds — The investments for the trust and agency funds are made up of
certificates of deposits, fixed income investments and equity mutual funds. CD's (if any) held in
the Escrow Deposit Fund will generally have maturities of between 30 and 120 days. Most of
the reserves for this fund are invested in the more liquid money market account due to the
nature of the deposit. Escrow refunds are processed two times per month.
Investments for the Police and Firefighter Pension Funds consist of various fixed income
securities as well as equity mutual fund accounts. Wells Fargo is the third -party holder of the
fixed income securities. The funds are managed by three investment management firms,
Capital Gains, Segall Bryant and Mesirow Financial. Segall Bryant holds approximately half of
the fixed income investments for the two pension funds while Capital Gains and Mesirow
manage the balance of fixed income investments for these two funds. Each manager maintains
a small portion of their portfolio in cash to help facilitate liquidity and trading.
Investments in equities consist of mutual funds spread across various sectors (small, mid and
large -cap stocks) as well as investment philosophies (value, core and growth). The pension
funds also have a small portion of their portfolio invested in international stocks. Each year the
investment mix is evaluated for optimal diversification to meet the pension funds investment
policy goals and objectives. Below is a breakdown of how the pension fund portfolios are
invested.
H:\ACCT\Treasurer's Report\2011 \Monthly Financial Report \Monthly Cash Position Report - June 2011.docx
Monthly Financial Report — June 2011
July 14, 2011
Page 4
Maturity Purchase Financial Investment CUSIP/
Date Date Institution Description Acct #
POLICE PENSION FUND (070)
Various Various Wells Fargo
Various Various Various
Wells Fargo Investments
Mutual Fund Investments
Various
Various
FIRE PENSION FUND (071)
Various Various Wells Fargo
Various Various Various
Wells Fargo Investments
Mutual Fund Investments
TOTAL TRUST AND AGENCY FUND INVESTMENTS
Various
Various
Interest Market
Rate % Value
Various 21,869,776.82
Various 22,082,677.53
43,952,454.35
Various 21,355,023.96
Various 20,002,873.50
41,357,897.46
$ 85,310,351.81
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 ongoing commitments.
David O. Erb
Finance Director
H:WCCT\Treasurer's Report\2011 \Monthly Financial Report\Monthly Cash Position Report - June 2011.docx
VILLAGE OF MOUNT PROSPECT
Preliminary Cash and Investment Position Report - All Funds
For the Month Ended June 30, 2011
GOVERNMENTAL AND ENTERPRISE FUNDS
Cash and Cash Total Cash and
Equivalents Investments Investments
Balance at May 31, 2011 $ 27,413,132.22 $ - $ 27,413,132.22
Cash receipts 4,054,738.39 4,054,738.39
Investment income 1,899.32 1,899.32
Transfers from investments to cash - - -
Transfers to investments from cash - - -
Interfund activity (245,679.10) (245,679.10)
Disbursements
Accounts payable (4,411,928.55) (4,411,928.55)
Payroll (1,309,887.21) (1,309,887.21)
Other (4,090.08) (4,090.08)
Balance at June 30, 2011 $ 25,498,184.99 $ - $ 25,498,184.99
TRUST AND AGENCY FUNDS
Cash and Cash
Equivalents Investments
Balance at May 31, 2011 $ 6,861,343.97 $ 85,346,973.27
Cash receipts 210,934.24
Investment income (loss) 213,927.51 (141,133.94)
Transfers from investments to cash 2,762,153.61 (2,762,153.61)
Transfers to investments from cash (2,866,666.09) 2,866,666.09
Interfund activity 245,679.10
Disbursements
Total Cash and
Investments
$ 92,208,317.24
210,934.24
72, 793.57
245,679.10
Accounts payable (173,012.36) (173,012.36)
Payroll (487,726.60) (487,726.60)
Flex spending - -
2010 Adjustments (1,083.91) (1,083.91)
Balance at June 30, 2011 $ 6,765,549.47 $ 85,310,351.81 $ 92,075,901.28
Assets are restricted in purpose and do not represent discretionary assets of the government
1
VILLAGE OF MOUNT PROSPECT
Summary of Cash Activity by Fund Type
For the Month Ended June 30, 2011
Ending balance 5,923,287.09 2,215,074.63 1,287,817.42 3,048,627.25 3,709,356.60 9,314,022.00 25,498,184.99 5,405,586.61 1,359,962.86 32,263,734.46
INVESTMENTS
Certificates of deposit
Wells Fargo investments 43,224,800.78 43,224,800.78
Mutual fund investments 42,085,551.03 42,085,551.03
Total investments 85,310,351.81 85,310,351.81
TOTAL CASH AND INVESTMENTS $ 5,923,287.09 $ 2,215,074.63 $ 1,287,817.42 $ 3,048,627.25 $ 3,709,356.60 $ 9,314,022.00 $ 25,498,184.99 $ 90,71 5,938.42 $ 1,359,962.86 $117,574,086.27
' Assets are restricted in purpose and do not represent discretionary assets of the government
N
GOVERNMENTAL AND ENTERPRISE FUNDS
TRUST AND AGENCY FUNDS "
SPECIAL
CAPITAL
TOTAL GOVT.
FIRE AND
OTHER TRUST
REVENUE
DEBT SERVICE
PROJECTS
ENTERPRISE
INTERNAL
AND ENTERPRISE
POLICE
AND AGENCY
GENERALFUND
FUNDS
FUNDS
FUNDS
FUNDS
SERVICE FUNDS
FUNDS
PENSIONS
FUNDS
TOTAL
CASH 8, CASH EQUIVALENTS
Beginning balance
$ 8,956,095.55
$ 2,774,192.10
$ 1,327,240.46
$ 2,685,785.95
$ 4,792,905.43
$ 6,876,912.73
$ 27,413,132.22
$ 5,542,497.22
$ 1,318,846.75
$ 34,274,476.19
Cash receipts
2,511,133.04
243,005.52
78,980.48
278,325.82
816,964.79
126,328.74
4,054,738.39
155,800.09
55,134.15
4,265,672.63
Investment income
1,400.49
2.77
-
-
2.25
493.81
1,899.32
213,807.79
119.72
215,826.83
Transfers from investments
-
-
-
-
-
2,762,153.61
-
2,762,153.61
Transfers to investments
-
-
(2,866,666.09)
-
(2,866,666.09)
Interfund
(2,976,615.33)
456,155.51
425,113.93
(1,160,728.67)
3,010,395.46
(245,679.10)
186,986.00
58,69310
0.00
2010 Adjustments
(4,090.08)
-
(4,090.08)
-
(1,083.91)
(5,173.99)
Disbursements - flexible spending
Disbursements - payroll
(1,113,728.00)
(19,003.12)
(117,316.22)
(59,839.87)
(1,309,887.21)
(487,726.60)
(1,797,613.81)
Disbursements - accounts payable
(1,450,908.58)
(1,239,278.15)
(118,403.52)
(340,598.45)
(622,470.98)
(640,268.87)
(4,411,928.55)
(101,265.41)
(71,746.95)
(4,584,940.91)
Ending balance 5,923,287.09 2,215,074.63 1,287,817.42 3,048,627.25 3,709,356.60 9,314,022.00 25,498,184.99 5,405,586.61 1,359,962.86 32,263,734.46
INVESTMENTS
Certificates of deposit
Wells Fargo investments 43,224,800.78 43,224,800.78
Mutual fund investments 42,085,551.03 42,085,551.03
Total investments 85,310,351.81 85,310,351.81
TOTAL CASH AND INVESTMENTS $ 5,923,287.09 $ 2,215,074.63 $ 1,287,817.42 $ 3,048,627.25 $ 3,709,356.60 $ 9,314,022.00 $ 25,498,184.99 $ 90,71 5,938.42 $ 1,359,962.86 $117,574,086.27
' Assets are restricted in purpose and do not represent discretionary assets of the government
N
VILLAGE OF MOUNT PROSPECT
STATEMENT OF INVESTMENTS
As of June 30, 2011
GOVERNMENTAL AND ENTERPRISE FUNDS
Maturity Purchase Financial Investment CUSIP/ Interest Market Weighted
Date Date Institution Description Acct # Rate % Value Avg Yield
As of June 30, 2011, there were no certificates of deposit held by the Governmental and Enterprise Funds.
Maturity
Purchase
Financial
Date
Date
Institution
POLICE PENSION FUND (070)
Various
Various
Wells Fargo
Various
Various
Various
FIRE PENSION FUND (071)
Various Various Wells Fargo
Various Various Various
TRUST AND AGENCY FUNDS
Investment
CUSIP/
Description
Acct #
Wells Fargo Investments
Various
Mutual Fund Investments
Various
Wells Fargo Investments Various
Mutual Fund Investments Various
TOTAL TRUST AND AGENCY FUND INVESTMENTS
* Assets are restricted in purpose and do not represent discretionary assets of the government.
Interest Market Weighted
Rate % Value Avg Yield
Various
Various
Various
Various
21,869,776.82
22,082,677.53
43,952,454.35
21,355,023.96
20,002,873.50
41,357,897.46
$85,310,351.81
3
VILLAGE OF MOUNT PROSPECT
BUDGET REVENUE
EXPENDITURE SUMMARIES
January 1— June 30, 2011
rI""mr>"" t Summary of Revenue by Fund and Category
N Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions T Recd Prior Year YTD
Fund 001 - General Fund
REVENUE
Property Taxes
11,514,500.00
.00
11,514,500.00
8,845.76
.00
6,064,910.47
5,449,589.53
53%
6,000,458.94
Other Taxes
7,703,000.00
.00
7,703,000.00
527,328.04
.00
2,383,458.86
5,319,541.14
31%
2,510,693.63
Licenses, Permits & Fees
2,704,000.00
.00
2,704,000.00
119,704.30
.00
1,819,996,99
884,003.01
67%
1,972,133.53
Intergovernmental Revenue
15,879,000.00
30,000.00
15,909,000.00
1,510,696.35
.00
3,826,621.98
12,082,378,02
24%
3,215,406.86
Charges For Services
1,455,390.00
.00
1,455,390.00
152,649.98
.00
650,752.88
804,637.12
45%
556,200.15
Fines & Forfeits
601,000.00
.00
601,000.00
64,038.55
.00
234,551.59
366,448.41
39%
247,404.89
Investment Income
97,500.00
.00
97,500.00
1,520.21
.00
14,989.04
82,510.96
15%
20,086.74
Reimbursements
282,200.00
.00
282,200.00
5,058.90
.00
37,645.42
244,554.58
13%
122,268.44
Other Revenue
331,840.00
.00
331,840.00
13,783.90
.00
153,711.99
178,128.01
46%
168,666.42
Other Financing Sources
2,000.00
.00
2,000.00
375.00
.00
659.14
1,340.86
33%
1,083.00
REVENUE TOTALS
$40,570,430.00
$30,000.00
$40,600,430.00
$2,404,000.99
$0.00
$15,187,298,36
$25,413,131.64
37%
$14,814,402.60
Fund 001 - General Fund Totals
$40,570,430.00
$30,000.00
$40,600,430.00
$2,404,000.99
$0.00
$15,187,298.36
$25,413,131.64
$14,814,402.60
r
N Summary of Revenue by Fund and Category
bkxuu Pccapixx
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD
% used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
R
Prior Year YTD
Fund 002 - Debt Service Fund
REVENUE
Property Taxes
1,754,000.00
.00
1,754,000.00
(5,478.97)
.00
1,013,483.85
740,516.15
58%
822,383.63
Other Taxes
682,000,00
.00
682,000.00
56,763.85
00
152,809,38
529,190.62
22%
214,000.96
Intergovernmental Revenue
47,258,00
.00
47,258.00
.00
.00
23,628.93
23,629.07
50%
20,872.23
Investment Income
2,500,00
.00
2,500.00
.00
DO
.00
2,500,00
0%
452.39
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
REVENUE TOTALS
$2,485,758.00
$0.00
$2,485,758.00
$51,284.88
$0,00
$1,189,922.16
$1,295,835.84
48%
$1,057,709.21
Fund 002 - Debt Service Fund Totals
$2,485,758.00
$0.00
$2,485,758.00
$51,284.88
$0.00
$1,189,922.16
$1,295,835.84
$1,057,709.21
h a- " P",Z„���: Summary of Revenue by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classif Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 020 - Capital Improvement Fund
REVENUE
Other Taxes
1,011,000.00
.00
1,011,000.00
84,147.00
.00
226,525.34
784,474.66
22%
214,993.77
Intergovernmental Revenue
100,000.00
.00
100,000.00
.00
.00
40,185.79
59,814.21
40%
4,657.00
Investment Income
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0%
503.97
Reimbursements
.00
.00
.00
.00
.00
.00
.00
+++
.00
Other Revenue
5,000.00
.00
5,000.00
.00
.00
14,494.00
(9,494.00)
290%
9,210.00
Other Financing Sources
.0 0
.00
.00
.00
.00
.00
.00
+++
.00
REVENUE TOTALS
$1,121,0
$0.00
$1,121,000.00
$84,147.00
$0.00
$281,205.13
$839,794.87
25%
$229,364.74
Fund 020 - Capital Improv Fund Totals
$1,121,000.00
$0.00
$1,121,000.00
$84,147.00
$0.00
$281,205.13
$839,794.87
$229,364.74
W
MamI §iaxct Summary of Revenue by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD
% used/
Account Classiflcation
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund 021 - Series 2009 Construction Fund
REVENUE
Intergovernmental Revenue
,00
00
.00
.00
,00
,00
.00
...
20,000.00
Investment Income
.00
.00
,00
,00
.00
.88
(.88)
...
4,644,37
Other Revenue
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Financing Sources
.00
.00
.00
.00
,00
,00
100
...
.00
REVENUE TOTALS
$0.00
$0.00
$0.00
$0.00
$0.00
$0,88
($0.88)
+ ++
$24,644,37
Fund 021- Series 2009 Const Fund Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$0.88
($0.88)
$24,64477
Summary of Revenue by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transaction Transactions Recd Prior Year YTD
Fund 022 - Downtown Redevelopment Construct
REVENUE
Property Taxes
2,665,000.00
.00
2,665,000.00
272,658.43
.00
1,423,849.33
1,241,150.67
53%
1,239,519.07
Investment Income
2,500.00
.00
2,500.00
.00
.00
.00
2,500.00
0%
1,234.30
Reimbursements
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Revenue
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.0 0
+ ++
.00
REVENUE TOTALS
$2,667,500.00
$0.00
$2,667,500.00
$272,658.43
$0.00
$1,423,849.33
$1,243,650.67
53%
$1,240,7
Fund 022 - Downtown Redevel Const Totals
$2,667,500.00
$0.00
$2,667,500.00
$272,658.43
$0.00
$1,423,849.33
$1,243,650.67
$1,240,753.37
Lr
Summary of Revenue by Fund and Category
Macau Pcoupix:t
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD
% used/
Account ClasslFlcatlon
Budget
Amendments
Budget
Transactions
Encumbrances
Transa
Tr
R ec'd
P Year YTD
Fund 023 - Street Improvement Construc Fund
REVENUE
Other Taxes
1,371,000.00
.00
1,371,000.00
120,676.28
.00
381,917.85
989,082.15
28%
354,323.74
Licenses, Permits & Fees
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Intergovernmental Revenue
.00
.00
.00
.00
.00
.00
.00
+++
413,250.00
Investment Income
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0%
.00
Reimbursements
.00
.00
.00
.00
.00
.00
.00
+++
.00
Other Revenue
.00
.00
.00
386.40
.00
4,171.37
(4,171.37)
+++
3,361.65
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
REVENUE TOTALS
$1,372,000.00
$0.00
$1,372,000.00
$121,062.68
$0.00
$386,089.22
$985,910.78
28%
$770,935.39
Fund 023 - Street Improv Const Fund Totals
$1,372,000.00
$0.00
$1,372,000.00
$121,062.68
$0.00
$386,089.22
$985,910.78
$770,935.39
Summary of Revenue by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
a
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD
% used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund 024 - Flood Control Construction Fund
REVENUE
Other Taxes
429,000.00
.00
429,000.00
35,706.30
.00
96,122.04
332,877.96
22%
19,753.16
Intergovernmental Revenue
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Charges For Services
50,000.00
.00
50,000.00
255.00
.00
3,695.00
46,305.00
7%
2,515.00
Investment Income
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Reimbursements
57,079.00
.00
57,079.00
.00
.00
56,744.17
334.83
99%
57,078.75
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
...
.00
REVENUE TOTALS
$536,079.00
$0.00
$536,079.00
$35,961.30
$0.00
$156,561.21
$379,517.79
29%
$79,346.91
Fund 024 - Flood Control Const Fund Totals
$536,079.00
$0.00
$536,079.00
$35,961.30
$0.00
$156,561.21
$379,517.79
$79,346.91
a
00
M- aP«.�..°
;Summary
of Revenue
by Fund and
Category
Through 06/30/11
Prior Fiscal Year
Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD Budget - YTD
% used/
Account Classification
Budget
Amendments
Budget
Tr a n sactions
Encumbrance
Transactions Transactions
Rec'd Prior Year YTD
Fund 040 - Refuse Disposal Fund
REVENUE
Property Taxes
1,751,000.00
.00
1,751,000.00
(7,925.74)
.00
1,012,060.15 738,939.85
58% 951,471.59
Charges For Services
1,938,782.00
.00
1,938,782.00
203,962.05
.00
980,910.58 957,871.42
51% 991,682.45
Fines & Forfeits
35,500.00
.00
35,500.00
2,669.98
.00
11,552.53 23,947.47
33% 17,365.69
Investment Income
1,200.00
.00
1,200.00
.00
.00
.00 1,200.00
0% 613.11
Other Revenue
364,150.00
.00
364,150.00
33,019.10
.00
147,232.13 216,917.87
40% 149,822.45
REVENUE TOTALS
$4,090,632.00
$0.00
$4,090,632.00
$231,725.39
$0.00
$2,151,755.39 $1,938,876.61
53% $2,110,955.29
Fund 040 - Refuse Disposal Fund Totals
$4,090,632.00
$0.00
$4,090,632.00
$231,725.39
$0.00
$2,151,755.39 $1,938,876.61
$2,110,955.29
171"'."'�' -77 Summary of Revenue by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 041 - Motor Fuel Tax Fund
REVENUE
Intergovernmental Revenue
1,432,500.00
.00
1,432,500.00
113,924.33
.00
586,579.73
845,920.27
41%
595,998.02
Investment Income
1,200.00
.00
1,200.00
.00
.00
.00
1,200.00
0%
703.31
Reimbursements
52,000.00
.00
52,000.00
.00
.00
4,932.51
47,067.49
9%
28,940.30
REVENUE TOTALS
$1,485,700.00
$0.00
$1,485,700.00
$113,924.33
$0.00
$591,512.24
$894,187.76
40%
$625,641.63
Fund 041 - Motor Fuel Tax Fund Totals
$1,485,700.00
$0.00
$1,485,700.00
$113,924.33
$0.00
$591,512.24
$894,187.76
$625,641.63
w
r
° �kxu�rn�,��� Summary of Revenue by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD
% used/
Account Classlflcatlon
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactlons
Rec'd
Prlor Year YTD
Fund 042 - Cmmty Development Block Grant
REVENUE
Intergovernmental Revenue
395,219.00
.00
395,219.00
65,155.63
.00
114,913.47
280,305.53
29%
153,811.34
Investment Income
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Revenue
60,000.00
.00
60,000.00
.00
.00
22,206.50
37,793.50
37%
50,509.78
REVENUE TOTALS
$455,219.00
$0.00
$455,219.00
$65,155.63
$0.00
$137,119.97
$318,099.03
30%
$204,321.12
Fund 042 - Cmmty Devel Block Grant Totals
$455,219.00
$0.00
$455,219.00
$65,155.63
$0.00
$137,119.97
$318,099.03
$204,321.12
r10-1-,A«.,, 7
Summary
of Revenue
by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget Amended
Current Month YTD
YTD Budget - YTD % used/
Account Classification
Budget
Amendments Budget
Transactions Encumbrances
Transactions Transactions Re P rio r Y YTD
Fund 043 -Asset Seizure Fund
REVENUE
Fines & Forfeits
1,000.00
.00 1,000.00
.00 .00
3,120.62 (2,120.62) 312% 3,595.73
Investment Income
2,500.00
.00 2,500.00
.00 .00
.00 2,500.00 0% 27.95
REVENUE TOTALS
$3,500.00
$0.00 $3,500.00
$0.00 $0.00
$3,120.62 $379.38 89% $3,623.68
Fund 043 - Asset Seizure Fund Totals
$3,500.00
$0.00 $3,500.00
$0.00 $0.00
$3,120.62 $379.38 $3,623.68
r
r
r
N rtK.�,��,«,��w
Summary
of Revenue
by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget Amended
Current Month YTD
YTD Budget - YTD % used/
Account Classification
Budget
Amendments Budget
Transactions Encumbrances
Transactions Transactions Rec'd Prior Year YTD
Fund 044 - DEA Shared Funds Fund
REVENUE
Fines & Forfeits
1,500.00
.00 1,500.00
.00 .00
.00 1,500.00 0% .00
Investment Income
500.00
.00 500.00
2.77 .00
26.99 473.01 5% 20.45
REVENUE TOTALS
$2,000.00
$0.00 $2,000.00
$2.77 $0.40
$26.99 $1,973.01 1% $20.45
Fund 044 - DEA Shared Funds Fund Totals
$2,000.00
$0.00 $2,000.00
$2.77 $0.00
$26.99 $1,973.01 $20.45
n =-ap ".1-
Summary
of Revenue
by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget Amended
Current Month
YTD
YTD Budget - YTD % used/
Account Classification
Budge
Amendments Budget
Transactions
Encumbrances
Transactions Transactions Rec'd Prior Year YTD
Fund 045 - DUI Fine Fund
REVENUE
Fines & Forfeits
1,000.00
.00 1,000.00
1,078.00
.00
2,672.00 (1,672.00) 267% 5,486.00
Investment Income
500.00
.00 500.00
.00
.00
.00 500.00 0% 2.84
REVENUE TOTALS
$1,500.00
$0.00 $1,500.00
$1,078.00
$0.00
$2,672.00 ($1,172.00) 178% $5,488.84
Fund 045 - DUI Fine Fund Totals
$1,500.00
$0.00 $1,500.00
$1,078.00
$0.00
$2,672.00 ($1,172.00) $5,488.84
r
w
F1
Summary of Revenue by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD
% used/
Account ClasslFlcatlon
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund 051- Village Parking System Fund
REVENUE
Other Taxes
45,000.00
.00
45,000.00
3,745.42
.00
10,082.73
34,917.27
22%
8,442.17
Charges For Services
102,000.00
.00
102,000.00
9,326.62
.00
55,584.33
46,415.67
54%
46,799.21
Investment Income
500.00
.00
500.00
.00
.00
.00
500.00
0%
26.99
Other Revenue
3,300.00
.00
3,300.00
.00
.00
1,650.00
1,650.00
50%
.00
Other Financing Sources
.00
.00
.00
.0
.00
.00
.
+ ++
.00
REVENUE TOTALS
$150,800.00
$0.00
$150,800.00
$13,072.04
$0.00
$67,317.06
$83,482.94
45%
$55,26
Fund 051 - Village Park System Fund Totals
$150,800.00
$0.00
$150,800.00
$13,072.04
$0.00
$67,317.06
$83,482.94
$55,268.37
Summary of Revenue by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget -YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Fund 052 - Parking System Revenue Fund
REVENUE
Other Taxes
55,000.00
.00
55,000.00
4,577.73
.00
12,323.34
42,676.66
22%
10,318.21
Intergovernmental Revenue
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Charges For Services
111,000.00
.00
111,000.00
9,995.35
.00
54,734.12
56,265.88
49%
54,081.37
Investment Income
500.00
.00
500.00
.00
.00
.00
500.00
0%
11.70
Other Revenue
.00
.00
.00
.00
.00
.00
.00
...
.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
REVENUE TOTALS
$166,500.00
$0.00
$166,500.00
$14,573.08
$0.00
$67,057.46
$99,442.54
40%
$64,411.28
Fund 052 - Parking System Rev Fund Totals
$166,500.00
$0.00
$166,500.00
$14,573.08
$0.00
$67,057.46
$99,442.54
$64,411.28
r
J
Tla.lx't ,Summary of Revenue by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD
% used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumb
Transactions
Transactions
Rec'd
Prior Year YTD
Fund 060 - Vehicle Maintenance Fund
REVENUE
Charges For Services
1,902,802.00
.00
1,902,802.00
158,566.84
.00
951,401.04
951,400.96
50%
823,720.92
Investment Income
1,000.00
.00
1,000.00
29.87
.00
192.29
807.71
19%
459.45
Other Revenue
.00
.00
.00
116.25
.00
275.00
(275.00)
...
125.00
REVENUE TOTALS
$1,903,802.00
$0.00
$1,903,802.00
$158,712.96
$0.()0
$951,868.33
$9
50%
$ 824,305.37
Fund 060 - Vehicle Maint Fund Totals
$1,903,802.00
$0.00
$1,903,802.00
$158,712.96
$0.00
$951,868.33
$951,933.67
$824,305.37
Summary of Revenue by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments B Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 061 - Vehicle Replacement Fund
REVENUE
Charges For Services
697,600.00
.00
697,600.00
58,133.34
.00
348,800.04
348,799.96
50%
37,849.98
Fines & Forfeits
26,000.00
.00
26,000.00
4,031.42
.00
10,223.86
15,776.14
39%
12,684.99
Investment Income
10,000.00
.00
10,000.00
299.30
.00
1,922.76
8,077.24
19%
3,998.02
Other Revenue
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Financing Sources
5 0,000.00
.00
50,000.00
15,495.50
.00
44,703.00
5,297.00
89%
.00
REVENUE TOTALS
$783,600.00
$ 0.00
$783,600.00
$77,959.56
$0.00
$405,649.66
$377,950.34
52%
$54,532.99
Fund 061 - Vehicle Repl Fund Totals
$783,600.00
$0.00
$783,600.00
$77,959.56
$0.00
$405,649.66
$377,950.34
$54,532.99
r
�o
N Summary of Revenue, by Fund and Category
° Nuorn rccwkxwt 1
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD
% used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transaction
Transacti
R ec'd
Prior Ye YTD
Fund 062 - Computer Replacement Fund
REVENUE
Charges For Services
231,921.00
.00
231,921.00
19,326.75
.00
115,960.50
115,960.50
50%
.00
Investment Income
5,000.00
.00
5,000.00
44.92
.00
288.53
4,711.47
6%
69
REVENUE TOTALS
$236,921.00
$0.00
$236,921.00
$19,371.67
$0.00
$116,249.03
$120,671.97
49%
$6
Fund 062 -Computer Repl Fund Totals
$236,921.00
$0.00
$236,921.00
$19,371.67
$0.00
$116,249.03
$120,671.97
$699.77
Ni mp".1—tj Summary of Revenue by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amen Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 063 - Risk Management Fund
REVENUE
Charges For Services 5,206,224.00
Investment Income 5,000.00
Reimbursements 11,000.00
Other Revenue 1,321,500.00
REVENUE TOTALS $6,543,724.00
Fund 063 - Risk Management Fund Totals $6,543,724.00
N
r
.00
5,206,224.00
446,846.07
.00
2,623,598.62
2,582,625.38
50%
2,820,454.84
.00
5,000.00
119.72
.00
769.01
4,230.99
15%
1,561.72
.00
11,000.00
.00
.00
727.10
10,272.90
7%
5,288.09
.00
1,321,500.00
90,501.91
.00
547,544.86
773,955.14
41%
536,059.32
$0.00
$6,543,724.00
$537,467.70
$0.00
$3,172,639.59
$3,371,084.41
48%
$3,363,363.97
$0.00
$6,543,724.00
$537,467.70
$0.00
$3,172,639.59
$3,371,084.41
$3,363,363.97
N
N Summary of RevenuE: by Fund and Category
- through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 070 - Police Pension Fund
REVENUE
Charges For Services
.00
.00
.00
.00
.00
.00
.00
+ ++ .00
Investment Income
2,637,000.00
.00
2,637,000.00
104,137.15
.00
1,904,152.00
732,848.00
72% (275,483.06)
Other Revenue
3,115,500.00
.00
3,115,500.00
85,883.61
.00
1,495,981.38
1,619,518.62
48% 1,280,849.39
REVENUE TOTALS
$5,752,500.00
$0.00
$5,752,500.00
$190,020.76
$0.00
$3,400,133.38
$2,352,366.62
59% $1,005,366.33
Fund 070 - Police Pension Fund Totals
$5,752,500.00
$0.00
$5,752,500.00
$190,020.76
$0.00
$3,400,133.38
$2,352,366.62
$1,005,366.33
t1,...t1 7 7 Summary of Revenue by Fund and Category
VN�7 Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactio Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 071 - Fire Pension Fund
REVENUE
Investment Income 2,544,500.00
.00
2,544,500.00
(101,745.18)
.00
1,646,622.26
897,877.74 65%
(143,697.51)
Other Revenue 2,695,300.00
.00
2,695,300.00
69,916.48
.00
1,276,256.71
1,419,043.29 47%
1,214,172.08
REVENUE TOTALS $5,239,800.00
$ 0.00
$5,239,800.00
($31,828.70)
$0.00
$2,922,878.97
$2,316,921.03 56%
$1,070,474.57
Fund 071 - Fire Pension Fund Totals $5,239,800.00
$0.00
$5,239,800.00
($31,828.70)
$0.00
$2,922,878.97
$2,316,921.03
$1,070,474.57
Grand Totals $86,471,465.00 $30,000.00 $86,501,465.00 $5,134,353.40 $0.00 $37,736,164.06 $48,765,300.94 44% $32,631,126.70
N
W
11
�lx,uh�n"
Summary of
Expenses
by Fund and
Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended Current Month
YTD
YTD
Budget - YTD
% used/
Account Classification
Budget
Amendments
Budget Transactions
Encumbrances
Transactions
Transactions
Rec'd Prior Year YTD
Fund 001 - General Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
21,164,041.00
.00
21,164,041.00
1,691,314.33
.00
9,696,790.67
11,467,250.33
46% 10,014,892.63
Personal Services, Unscheduled Salaries & Wages
1,334,549.18
107,000.00
1,441,549.18
70,182.78
.00
541,811.99
899,737.19
38% 457,532.53
Employee Benefits
10,125,347.78
.00
10,125,347.78
528,244.00
.00
4,909,891.16
5,215,456.62
48% 4,986,469.07
Other Employee Costs
381,675.00
10,006.42
391,681.42
17,085.33
22,577.54
133,622.04
235,481.84
40% 123,933.19
Pension Benefits
45,863.00
.00
45,863.00
3,821.80
.00
22,930.80
22,932.20
50% 22,861.92
Contractual Services
6,016,947.00
253,161.00
6,270,108.00
522,053.67
384,957.11
2,803,351.82
3,081,799.07
51% 2,295,566.23
Utilities
284,227.00
.00
284,227.00
10,644.56
.00
49,754.83
234,472.17
18% 68,468.75
Insurance
318,468.00
.00
318,468.00
27,042.57
.00
159,737.62
158,730.38
50% 116,355.48
Commodities & Supplies
661,150.00
4,450.00
665,600.00
41,264.02
31,022.44
209,160.72
425,416.84
36% 231,130.90
Other Expenditures
12,000.00
.00
12,000.00
.00
.00
.00
12,000.00
0% .00
Building Improvements
3,933.00
5,834.52
9,767.52
8,634.54
2,834.52
10,125.31
(3,192.31)
133% .00
Office Equipment
48,696.00
(2,834.52)
45,861.48
.00
11,078.00
.00
34,783.48
24% 15,611.13
Other Equipment
156,533.00
(3,500.00)
153,033.00
15,095.67
13,993.76
53,417.86
85,621.38
44% 12,273.55
Infrastructure
17,000.00
.00
17,000.00
165.00
.00
1,100.00
15,900.00
6% 2,133.00
EXPENSE TOTALS
$40,570,429.96
$374,117.42
$40,944,547.38
$2,935,548.27
$466,463.37
$18,591,694.82
$21,886,389.19
47% $18,347,228.38
Fund 001 - General Fund Totals
$40,570,429.96
$374,117.42
$40,944,547.38
$2,935,548.27
$466,463.37
$18,591,694.82
$21,886,389.19
$18,347,228.38
r
N
A-kxuu 1'nxt�xw-1
Summary of
Expenses;
by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget Amended Current
Month
YTD
YTD Budget - YTD % used/
Account Classification
B
Amendm Budget Tr an s act i ons
Encumbrances
Transaction Transactions R Pr Year YTD
Fund 002 - Debt Service Fund
EXPENSE
Bond Principal
1,312,701.00
.00 1,312,701.00
99,315.72
.00
264,255.42 1,048,445.58 20% 256,071.55
Interest Expense
1,102,047.00
.00 1,102,047.00
19,087.80
.00
553,117.33 548,929.67 50% 556,539.97
Bank & Fiscal Fees
1,800.00
.00 1,800.00
.00
.00
1,584.00 216.00 88% 878.00
EXPENSE TOTALS
$2,416,548.00
$0.00 $2,416,548.00
$118,403.52
$0.00
$818,956.75 $1,597,591.25 34% $813,489.52
Fund 002 - Debt Service Fund Totals
$2,416,548.00
($0.00) $2,416,548.00
$118,403.52
($0.00)
$818,956.75 $1,597,591.25 $813,489.52
ml-nW.,j- Summary of Expenses by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Bu dget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 020 - Capital Improvement Fund
EXPENSE
Contractual Services
200,000.00
342,700.00
542,700.00
19,707.30
337,190.76
73,532.50
131,976.74
76%
145,560.44
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Land Inprovements
.00
26,065.00
26,065.00
.00
3,854.85
4,034.00
18,176.15
30%
.00
Building Improvements
371,000.00
32,000.00
403,000.00
4,824.05
102,065.02
26,338.38
274,596.60
32%
147,214.40
Office Equipment
108,000.00
.00
108,000.00
.00
.00
.00
108,000.00
0%
.00
Motor Equipment
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Equipment
32,500.00
256,089.00
288,589.00
.00
.00
48,749.83
239,839.17
17%
65,390.97
Infrastructure
264,000.00
231,086.00
495,086.00
7,233.00
42,652.58
14,547.00
437,886.42
12%
70,749.76
Interfund Transfers
. 00
.00
.00
.00
.00
.00
.00
+ ++
.00
EXPENSE TOTALS
$975,
$887,940.00
$1,863,440.00
$31,764.35
$485,763.21
$167,201.71
$1,210,475.08
35%
$428,915.57
Fund 020 - Capital Improvement Fund Totals
$975,500.00
$887,940.00
$1,863,440.00
$31,764.35
$485,763.21
$167,201.71
$1,210,475.08
$428,915.57
W
Summary of Expenses by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD
% used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund 021 - Series 2009 Construction Fund
EXPENSE
Contractual Services
.00
750.00
750.00
.00
.00
350.13
399.87
47%
95,074.43
Building Improvements
.00
.00
.00
.00
.00
.00
.00
+ ++
2,373,293.33
Office Equipment
.00
2,200.00
2,200.00
.00
232.35
2,123.61
(155.96)
107%
1,000.00
Other Equipment
.00
145,200.00
145,200.00
.00
49,765.00
95,900.00
(465.00)
100%
366,660.28
EXPENSE TOTALS
$0.00
$148,150.00
$148,150.00
$0.00
$49,997.35
$98,373.74
($221.09)
100%
$2,836,028.04
Fund 021 - Series 2009 Const Fund Totals
($0.00)
$148,150.00
$148,150.00
($0.00)
$49,997.35
$98,373.74
($221.09)
$2,836,028.04
nl° ° ta�� summary of Expenses by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amen Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 022 - Downtown Redevelopment Construct
EXPENSE
Contractual Services
88,500.00
.00
88,500.00
10,680.00
24,960.00
100,705.47
(37,165.47)
142%
51,396.31
Utilities
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Expenditures
2,590,155.00
.00
2,590,155.00
20,690.61
.00
2,461,739.47
128,415.53
95%
31,303.07
Infrastructure
210,002.00
68,134.00
278,136.00
3,066.00
39.00
201,547.50
76,549.50
72%
50,209.94
Bond Principal
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Interest Expense
.00
.00
.00
.00
.00
.00
.00
...
.00
EXPENSE TOTALS
$2,888,657.00
$68,134.00
$2,956,791.00
$34,436.61
$24,999.00
$2,763,992.44
$167,799.56
94%
$132,909.32
Fund 022 - Downtown Redevel Const Totals
$2,888,657.00
$68,134.00
$2,956,791.00
$34,436.61
$24,999.00
$2,763,992.44
$167,799.56
$132,909.32
l
ON
MwntP�j Summary of Expenses by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD
% used/
Account Classiflcatlon
Budg
Ame
Budget
Transactions
En c u m b ran c es
Transactions
Transactions
Rec'd
Prior Year YTD
Fund 023 - Street Improvement Construc Fund
EXPENSE
Contractual Services
142,000.00
12,708.00
154,708.00
.00
50,708.00
.00
104,000.00
33%
44,171.86
Infrastructure
1,605,000.00
812,932.00
2,417,932.00
211,517.52
1,641,991.10
464,117.25
311,823.65
87%
323,288.01
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
EXPENSE TOTALS
$1,747,000.00
$825,640.00
$2,572,640.00
$211,517.52
$1,692,699.10
$464,117.25
$415,823.65
84%
$367,459.87
Fund 023 - Street Imp Construc Fund Totals
$1,747,000.00
$825,640.00
$2,572,640.00
$211,517.52
$1,692,699.10
$464,117.25
$415,823.65
$367,459.87
NU-UP-1-t Summary of Expenses by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 024 - Flood Control Construction Fund
EXPENSE
Contractual Services
.00
.00
.00
.00
.00
.00
.00
...
.00
Other Expenditures
5,150.00
.00
5,150.00
.00
.00
.00
5,150.00
0%
1,000.00
Other Equipment
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Infrastructure
400,000.00
50,000.00
450,000.00
.00
17,300.00
.00
432,700.00
4%
4,266.00
EXPENSE TOTALS
$405,
$ 50,000.00
$455,150.00
$0.00
$17,300.00
$0.00
$437,850.00
4%
$5,266.00
Fund 024 - Flood Control Const Fund Totals
$405,150.00
$50,000.00
$455,150.00
($0.00)
$17,300.00
($0.00)
$437,850.00
$5,266.00
v
00
Summary of Expenses by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD
% used/
Account Classlflcatlon
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund 040 - Refuse Disposal Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
197,495.00
.00
197,495.00
14,988.09
.00
88,607.39
108,887.61
45%
82,851.36
Personal Services, Unscheduled Salaries & Wages
61,832.00
.00
61,832.00
264.94
.00
1,488.49
60,343.51
2%
853.28
Employee Benefits
90,328.00
.00
90,328.00
6,390.82
.00
39,617.46
50,710.54
44%
32,804.88
Other Employee Costs
1,200.00
.00
1,200.00
.00
.00
.00
1,200.00
0%
.00
Contractual Services
3,968,555.00
.00
3,968,555.00
373,694.11
.00
1,760,223.96
2,208,331.04
44%
1,710,841.92
Utilities
572.00
.00
572.00
20.60
.00
104.00
468.00
18%
159.96
Insurance
25,175.00
.00
25,175.00
2,097.92
.00
12,587.52
12,587.48
50%
11,367.00
Commodities & Supplies
33,737.00
.00
33,737.00
361.65
35.00
14,402.64
19,299.36
43%
7,806.25
EXPENSE TOTALS
$4,378,894.00
$0.00
$4,378,894.00
$397,818.13
$35.00
$1,917,031.46
$2,461,827.54
44%
$1,846,684.65
Fund 040 -Refuse Disposal Fund Totals
$4,378,894.00
($0.00)
$4,378,894.00
$397,818.13
$35.00
$1,917,031.46
$2,461,827.54
$1,846,684.65
,7 �.aILLlj—t Summary of Expenses by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budg Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 041 - Motor Fuel Tax Fund
EXPENSE
Contractual Services
186,302.00
.00
186,302.00
7,951.30
143,137.24
25,161.72
18,003.04
90%
22,795.69
Utilities
150,000.00
.00
150,000.00
7,378.16
.00
80,995.30
69,004.70
54%
77,078.11
Commodities & Supplies
200,000.00
.00
200,000.00
.00
141.91
212,551.69
(12,693.60)
106%
156,033.81
Infrastructure
550,000.00
60,000.00
610,000.00
125,934.40
26,572.10
570,863.90
12,564.00
98%
920,000.00
EXPENSE TOTALS
$ 1, 0 8 6,3 02.00
$60,000.00
$1,146,302.00
$141,263.86
$169,851.25
$889,572.61
$86,878.14
92%
$1,175,907.61
Fund 041 - Motor Fuel Tax Fund Totals
$1,086,302.00
$60,000.00
$1,146,302.00
$141,263.86
$169,851.25
$889,572.61
$86,878.14
$1,175,907.61
w
° �u1���nY summary of Expenses by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD
% used/
Account Classification
Budget
Amendments
Budget
Transaction
Encumbrances
Transactions
Transactions
Rec'd
Prio Ye YTD
Fund 042 - Cmmty Development Block Grant
EXPENSE
Personal Services, Scheduled Salaries & Wages
63,550.00
.00
63,550.00
5,846.03
.00
29,808.40
33,741.60
47%
26,089.19
Personal Services, Unscheduled Salaries & Wages
00
.00
.00
.00
.00
.00
100
+ ++
.00
Employee Benefits
25,162.00
.00
25,162.00
2,176.15
.00
12,232.09
12,929.91
49%
10,861.26
Other Employee Costs
1,850.00
.00
1,850.00
.00
.00
253.56
1,596.44
14%
25.00
Contractual Services
183,680.00
.00
183,680.00
350.34
.00
15,148.67
168,531.33
8%
57,348.57
Commodities & Supplies
977.00
.00
977.00
.00
.00
56.99
920.01
6%
81.26
Other Expenditures
180,000.00
.00
180,000.00
.00
1,925.00
90,368.75
87,706.25
51%
86,523.20
Land Inprovements
.00
.00
.00
.00
.00
.00
.00
...
.00
Building Improvements
.00
.00
.00
.00
.00
.00
.00
...
.00
Infrastructure
.00
.00
.00
.00
.00
.00
.00
+ ++
3,360.00
EXPENSE TOTALS
$455,219.00
$0.00
$455,219.00
$8,372.52
$1,925.00
$147,868.46
$305,425.54
33%
$184,288.48
Fund 042 - Cmmty Devel Block Grant Totals
$455,219.00
($0.00)
$455,219.00
$8,372.52
$1,925.00
$147,868.46
$305,425.54
$184,288.48
I N Summary of Expenses by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendm Bu Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 043 -Asset Seizure Fund
EXPENSE
Other Employee Costs
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00 0
.00
Contractual Services
1,500.00
.00
1,500.00
.00
.00
.00
1,500.00 0
.00
Other Equipment
1,000.00
.00
1,000.00
.00
9,753.80
.00
(8,753.80) 975%
5,118.00
EXPENSE TOTALS
$ 3,500.00
$0.00
$3,500.00
$0.00
$9,753.80
$0.00
($6,253.80) 279%
$5,118.00
Fund 043 - Asset Seizure Fund Totals
$3,500.00
($0.00)
$3,500.00
($0.00)
$9,753.80
($0.00)
($6,253.80)
$5,118.00
r
r
N ��
Summary of
Expenses
by Fund and Category
Through 06/30/11
1
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget Amended Current Month
YTD
YTD Budget - YTD % used/
Account Classification
Budget
Amendments Budget Transactions
Encumbrances
Transactions Transactions Rec'd Prior Year YTD
Fund 044 - DEA Shared Funds Fund
EXPENSE
Contractual Services
1,000.00
.00 1,000.00
375.00
.00
375.00 625.00 38% .00
Building Improvements
.00
.00 .00
.00
.00
5,423.00 (5,423.00) + ++ .00
Other Equipment
1,000.00
.00 1,000.00
.00
.00
6,076.78 (5,076.78) 608% .00
EXPENSE TOTALS
$2,000.00
$0.00 $2,000.00
$375.00
$0.00
$11,874.78 ($9,874.78) 594% $0.00
Fund 044 - DEA Shared Funds Fund Totals
$2,000.00
($0.00) $2,000.00
$375.00
($0.0())
$11,874.78 ($9,874.78) ($0.00)
Summary of Expenses by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Bud Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 045 - DUI Fine Fund
EXPENSE
Other Employee Costs
.00
.00
.00
.00
.00
.00
.00 + ++
.00
Other Equipment
1,500.00
.00
1,500.00
.00
15,600.00
.00
(14,100.00) 1040%
343.00
Inte rfund Transfers
. 00
.00
.00
.00
.00
.00
.00 + + +
.00
EXPENSE TOTALS
$ 1, 5 00.00
$0.00
$1,500.00
$0.00
$15,600.00
$0.00
($14,100.00) 1040%
$343.00
Fund 045 - DUI Fine Fund Totals
$1,500.00
($0.00)
$1,500.00
($0.00)
$15,600.00
($0.00)
($14,100.00)
$343.00
r
w
r
u, Summary of Expenses by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD
% used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund 046 - Foreign Fire Tax Board Fund
EXPENSE
Contractual Services
10,000.00
.00
10,000.00
.00
.00
2,532.53
7,467.47
25%
8,984.76
Insurance
550.00
.00
550.00
.00
.00
417.21
132.79
76%
.00
Commodities & Supplies
3,000.00
.00
3,000.00
.00
.00
822.92
2,177.08
27%
500.52
Other Equipment
15,000.00
.00
15,000.00
.00
.00
.00
15,000.00
0%
9,979.99
EXPENSE TOTALS
$28,550.00
$0.00
$28,550.00
$0.00
$0.00
$3,772.66
$24,777.34
13%
$19,465.27
Fund 046 - For Fire Tax Board Fund 'Totals
$28,550.00
($0.00)
$28,550.00
($0,00)
($0.00)
$3,772.66
$24,777.34
$19,465.27
Summary of Expenses by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Fund 050 - Water and Sewer Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
1,790,680.00
.00
1,790,680.00
112,219.86
.00
665,650.26
1,125,029.74
37%
743,275.71
Personal Services, Unscheduled Salaries & Wages
180,295.00
.00
180,295.00
11,088.41
.00
80,664.54
99,630.46
45%
51,115.77
Employee Benefits
726,681.00
.00
726,681.00
48,275.66
.00
320,066.44
406,614.56
44%
340,054.27
Other Employee Costs
35,941.00
25,285.00
61,226.00
2,826.99
251.41
18,558.72
42,415.87
31%
15,660.41
Contractual Services
5,571,684.00
170,737.00
5,742,421.00
491,143.24
310,296.29
2,291,664.80
3,140,459.91
45%
2,307,106.31
Utilities
198,006.00
.00
198,006.00
10,393.69
.00
49,903.72
148,102.28
25%
57,210.87
Insurance
76,838.00
.00
76,838.00
6,403.16
.00
38,418.96
38,419.04
50 0 /0
33,147.54
Commodities & Supplies
302,620.00
.00
302,620.00
7,837.12
22,752.34
97,221.53
182,646.13
40%
95,632.07
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
...
.00
Office Equipment
1,344.00
6,088.00
7,432.00
.00
.00
.00
7,432.00
0%
219.90
Other Equipment
288,345.00
690,418.00
978,763.00
48,379.76
48,224.70
73,318.09
857,220.21
12%
30,400.06
Distribution Systems
1,658,000.00
1,453,210.00
3,111,210.00
57,926.61
1,951,309.89
979,129.17
180,770.94
94%
147,981.25
Bond Principal
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Interest Expense
.00
.00
.00
.00
.00
.00
.00
...
.00
Interfund Transfers
. 00
.00
.00
.00
.00
.00
.00
+ ++
.00
EXPENSE TOTALS
$10,830,434.00
$2,345,738.00
$13,176,172.00
$796,494.50
$2,332,834.63
$4,614,596.23
$6,228,741.14
53%
$3,821,804.16
Fund 050 - Water and Sewer Fund Totals
$10,830,434.00
$2,345,738.00
$13,176,172.00
$796,494.50
$2,332,834.63
$4,614,596.23
$6,228,741.14
$3,821,804.16
H
Ul
r,u Summary of Expenses by Fund and Category
V 114 Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD
% used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund 051- Village Parking System Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
29,176.00
.00
29,176.00
1,283.31
.00
7,367.45
21,808.55
25%
6,597.46
Personal Services, Unscheduled Salaries & Wages
.00
.00
.00
92.00
.00
92.00
(92.00)
+++
.00
Employee Benefits
11,146.00
.00
11,146.00
563.42
.00
4,069.34
7,076.66
37%
4,608.50
Contractual Services
81,640.00
.00
81,640.00
3,280.67
16,725.53
34,043.28
30,871.19
62%
28,860.11
Insurance
755.00
.00
755.00
62.92
.00
377.52
377.48
50%
473.52
Commodities & Supplies
500.00
.00
500.00
.00
.00
.00
500.00
0%
207.53
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Building Improvements
6,800.00
.00
6,800.00
.00
.00
5,000.00
1,800.00
74%
4,264.76
Infrastructure
80,000.00
.00
80,000.00
.00
6,500.00
.00
73,500.00
8%
.00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
+++
.00
EXPENSE TOTALS
$210,017.00
$0.00
$210,017.00
$5,282.32
$23,225.53
$50,949.59
$135,841.88
35%
$45,011.88
Fund 051- Village Parking System Fund Totals
$210,017.00
($0.00)
$210,017.00
$5,282.32
$23,225.53
$50,949.59
$135,841.88
$45,011.88
Mx„rnx,k Summary of Expenses by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactlons Rec'd Prior Year YTD
Fund 052 - Parking System Revenue Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
23,866.00
.00
23,866.00
2,802.13
.00
16,493.97
7,372.03
69%
15,682.87
Personal Services, Unscheduled Salaries & Wages
.00
.00
.00
61.33
.00
61.33
(61.33)
+ ++
.00
Employee Benefits
9,488.00
.00
9,488.00
1,095.97
.00
5,659.16
3,828.84
60%
5,001.97
Contractual Services
103,027.00
.00
103,027.00
6,272.79
5,852.86
36,745.01
60,429.13
41%
35,851.50
Utilities
10,317.00
.00
10,317.00
661.43
.00
3,906.30
6,410.70
38%
3,508.80
Insurance
1,011.00
.00
1,011.00
84.25
.00
505.50
505.50
50%
47152
Commodities & Supplies
9,586.00
.00
9,586.00
.00
.00
239.67
9,346.33
3%
4,269.43
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Building Improvements
25,000.00
25,000.00
50,000.00
.00
.00
.00
50,000.00
0%
.00
Infrastructure
80,000.00
.00
80,000.00
.00
.00
.00
80,000.00
0 0 /0
.00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
...
.00
EXPENSE TOTALS
$262,295.00
$25,000.00
$287,295.00
$10,977.90
$5,852.86
$63,610.94
$217,831.20
24%
$64,788.09
Fund 052 - Parking System Rev Fund Totals
$262,295.00
$25,000.00
$287,295.00
$10,977.90
$5,852.86
$63,610.94
$217,831.20
$64,788.09
r
J
NMEE-r --77,Y Summary of Expenses by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD
% used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Recd
Prior Year YTD
Fund 060 - Vehicle Maintenance Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
793,652.00
.00
793,652.00
63,855.66
.00
369,032.21
424,619.79
46%
347,107.36
Personal Services, Unscheduled Salaries & Wages
68,250.00
.00
68,250.00
1,427.27
.00
38,253.58
29,996.42
56%
30,964.75
Employee Benefits
332,734.00
.00
332,734.00
24,663.82
.00
154,782.68
177,951.32
47%
151,608.80
Other Employee Costs
2,315.00
.00
2,315.00
.00
.00
320.00
1,995.00
14%
1,897.70
Contractual Services
98,464.00
.00
98,464.00
9,067.75
837.60
43,780.45
53,845.95
45%
30,138.59
Utllltles
993.00
.00
993.00
51.51
.00
260.23
732.77
26%
399.88
Commodities & Supplies
603,349.00
.00
603,349.00
78,068.57
196,084.28
330,304.20
76,960.52
87%
268,858.44
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
...
.00
Offlce Equipment
545.00
.00
545.00
.00
.00
.00
545.00
0%
.00
Other Equipment
3,500.00
.00
3,500.00
248.00
.00
3,054.67
445.33
87%
79.00
EXPENSE TOTALS
$1,903,802.00
$0.00
$1,903,802.00
$177,382.58
$196,921.88
$939,788.02
$767,092.10
60%
$831,054.52
Fund 060 -Vehicle Maint Fund Totals
$1,903,802.00
($0.00)
$1,903,802.00
$177,382.58
$196,921.88
$939,788.02
$767,092.10
$831,054.52
N
�O
Summary of
Expenses
by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget Amended Current
Month YTD
YTD Budget - YTD % used/
Account ClasslFlcatlon
Budget
Amendments Budget Transactions Encumbrances
Transactions Transactions Rec'd Prior Year YTD
Fund 061- Vehicle Replacement Fund
EXPENSE
Other Expenditures
00
.00 .00
.00 .00
.00 .00 + ++ .00
Motor Equipment
613,650.00
57,000.00 670,650.00
33,136.45 159,491.57
52,996.30 458,162.13 32% 339,195.83
Interfund Transfers
.00
.00 .00
.00 .00
.00 .0 ... .00
EXPENSE TOTALS
$613,650.00
$57,000.00 $670,650.00
$33,136.45 $159,491.57
$52,996.30 $458,162.13 32% $ 339,195.83
Fund 061- Vehicle Repl Fund Totals
$613,650.00
$57,000.00 $670,650.00
$33,136.45 $159,491.57
$52,996.30 $458,162.13 $339,195.83
N
�O
N
� M<xnn Prue;pcva
Account Classification
Summary of Expenses by Fund and Category
- through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Fund 062 - Computer Replacement Fund
EXPENSE
Office Equipment 194,950.00 .00 194,950.00 5,420.56 13,874.78 24,414.35
EXPENSE TOTALS $194,950.00 $0.()0 $194,950.00 $5,420.56 $13,874.78 $24,414.35
Fund 062 - Computer Repl Fund Totals $194,950.00 ($0.00) $194,950.00 $5,420.56 $13,87438 $24,414.35
156,660.87 20% 106,829.27
$156,660.87 20% $106,829.27
$156,660.87 $106,829.27
tv[ „ > rYMi >a Summary of Expenses by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amen dments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 063 - Risk Management Fund
EXPENSE
Contractual Services
13,500.00
.00
13,500.00
.00
.00
500.00
13,000.00
4%
.00
Insurance
6,785,343.00
.00
6,785,343.00
468,339.91
1,996.29
3,287,569.56
3,495,777,15
48%
3,117,768.03
Other Equipment
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Infrastructure
.00
.00
.00
.00
.00
.00
.00
+ ++
,00
EXPENSE TOTALS
$6, 7 9 8,843.00
$0.00
$6,798,843.00
$468,339.91
$1,996.29
$3,288,069.56
$3,508,777.15
48%
$3,117,768.03
Fund 063 - Risk Management Fund Totals
$6,798,843.00
($0,00)
$6,798,843.00
$468,339.91
$1,996.29
$3,288,069.56
$3,508,777.15
$3,117,768.03
N
r
N summary of Expenses by Fund and Category
Through 06/30/11
1 Prior Fiscal Year Activity Included
Summary Listing
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD
% used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Recd
Prior Year YTD
Fund 070 - Police Pension Fund
EXPENSE
Pension Benefits
3,431,110.00
.00
3,431,110.00
297,009.68
.00
1,782,058.08
1,649,051.92
52%
1,612,362.60
Contractual Services
123,500.00
.00
123,500.00
23,186.72
.00
50,761.58
72,738.42
41%
35,438.23
Insurance
10,000.00
.00
10,000.00
.00
.00
.00
10,000.00
0%
.00
Commodities & Supplies
500.00
.00
500.00
.00
.00
61.11
438.89
12%
.00
Other Expenditures
12,000.00
.00
12,000.00
.00
.00
8,319.88
3,680.12
69%
8,105.46
Office Equipment
.00
.00
.00
. 00
.00
.00
.00
..
.00
EXPENSE TOTALS
$3,577,110.00
$0.00
$3,577,110.00
$320,196.40
$0.00
$1,841,200.65
$1,735,909.
51%
$1,655,
Fund 070 - Police Pension Fund Totals
$3,577,110.00
($0,00)
$3,577,110.00
$320,196.40
($0.00)
$1,841,200.65
$1,735,909.35
$1,655,906.29
rw
Adopted
Account Classification Budget
Summary of Expenses by Fund and Category
Through 06/30/11
Prior Fiscal Year Activity Included
Summary Listing
Budget Amended Current Month YTD YTD Budget - YTD % used/
Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 071 - Fire Pension Fund
EXPENSE
Pension Benefits
3,112,073.00
.00
3,112,073.00
295,298.03
.00
1,771,764.69
1,340,308.31
57%
1,502,477.17
Contractual Services
132,000.00
1,000.00
133,000.00
436.36
.00
53,916.63
79,083.37
41%
41,756.13
Insurance
12,000.00
(1,000.00)
11,000.00
.00
.00
.00
11,000.00
0%
.00
Commodities & Supplies
1,000.00
.00
1,000.00
.00
.00
2.00
998.00
0%
.00
Other Expenditures
12,000.00
. 00
12,000.00
.00
.00
8,120.00
3,880.00
68%
7,337.90
EXPENSE TOTALS
$3,269,073.00
$0.00
$3,269,073.00
$295,734.39
$0.00
$1,833,803.32
$1,435,269.68
56%
$1,551,571.20
Fund 071 - Fire Pension Fund Totals
$3,269,073.00
($0.00)
$3,269,073.00
$295,734.39
($0.00)
$1,833,803.32
$1,435,269.68
$1,551,571.20
Grand Totals $82,619,423.96 $4,841,719.42 $87,461,143.38 $5,992,464.79 $5,668,584.62 $38,583,885.64 $43,208,673.12 51% 37,697,032.98
N
W
VILLAGE OF MOUNT PROSPECT
List of Bills
June 16 - June 29, 2011
Fund Vendor Name Invoice Description Amount
001 General Fund
ACS State & Local Government Solutions
Illinois State Disbursement Unit
$ 3,115.21
Active Alarm Company, Inc.
Alarm service for Fire Station 12 - 3 months.
300.00
Fire alarm service for 3 months at 10 S. Pine.
79.50
Fire alarm service at CCC for 3 months.
85.50
Addison Building Material Co.
Grounds Maintenance Materials and Supplies
58.21
ADT Security Services, Inc.
Equipment Maintenance
3,084.68
Advanced Communications, Inc.
Programming of EOC A/V Units
500.00
Aerex Pest Control Services, Inc.
Annual Pest Control
30.00
Annual Pest Control
35.00
Annual Pest Control
40.00
Annual Pest Control
30.00
Annual Pest Control
30.00
Annual Pest Control
30.00
Alexian Brothers Medical Center
Pre - Employment Testing For K. Johnson, K. Kinser, and D. Murphy
207.00
Pre -Emp Testing Barr, Busse, Junius, Martin, Sepulveda, Snyder
414.00
Pre - Employment Testing for L Eldei
69.00
Pre - Employment Testing for Leazer, Lello, Mulcahy, Rusk
276.00
Pre - Employment Testing for Doug Petro
158.00
Alpha Prime Communications
Engineering Supplies
238.04
Amer Reprographics Co Llc
Equipment Maintenance
59.00
American Cadastre, U.C.
Record Destruction (Planning & Building Files)
974.91
American Landscaping Inc.
Shrub /Flower Replacement
755.00
Restoration at Melas Park
4,510.00
Anderson Lock Company
Maintenance and repair supplies
97.27
Andrade, Consuelo
Spring 2011 Tuition Reimbursement
1,200.00
Applied Controls, Inc.
Equipment Maintenance
1,980.00
Aramark Uniform Services, Inc.
Uniform Rental & Cleaning
104.76
PW Uniform Rental and Cleaning for 2011
104.76
ARC Disposal Company
Refuse Disposal Program
1,847.18
AT & T
AT & T Long Distance 5/1/11- 5/31/11
780.94
Service 6/10/11- 7/9/11
2,976.97
Service 6/7/11- 7/6/11
652.61
Service 6/16/11- 7/15/11
332.14
Autumn Landscaping Inc
Streetscape Program
11,534.00
Sprinkler Systems
1,190.00
B & H Photo /video
Video Accessories
152.85
Video Accessories
241.35
Baldini, Carol
ID holders for Medical Reserve Corp Volunteers
207.90
Lanyards for MRC Volunteers
230.00
Barnes Group
Small Tools
242.78
Bedco Mechanical
Replace defective control on rooftop unit at Public Works
441.60
Change out two defective Carrier condenser fan motors at the VH
2,510.20
Cleaning of AC coils at Police /Fire Headquarters.
174.40
Repairs to roof top unit #1 at Police /Fire.
300.00
Replace defective compressor in RTU #1 at Police /Fire.
3,140.25
Repairs to HVAC econimzer at P/F headquarters.
1,093.30
Clean condenser coil
43.60
Besse Medical Supply
Invoice 12010194471- Cholesterol Strips
47.73
Accutrend Choi Strips - 12010195948
94.05
Big Picture Productions Inc.
Downtown Block Party
3,920.00
Bio -iron Inc
Preventative Maintenance/ Phiips Monitor PM
300.00
Bonestroo, Inc.
Professional Services
891.25
Professional Services
193.75
Bound Tree Medical, LLC.
Paramedic Supplies
556.09
Bright Electrical Supply Co.
Building Maintenance & Supplies
379.00
Maintenance and repair supplies
469.50
Maintenance and repair supplies
71.10
Bures, Paul
Clothing Allowance
159.76
Burrell, Steve
Reimburse expenses
48.30
C.B.M.T., Inc.
Purchase of Various Annual Flowers
5,374.30
Grounds Beautification
1,750.00
Case Lots, Inc.
Custodial Supplies
1,180.65
Custodial Supplies
837.00
Custodial Supplies
209.30
Castillo, Carlos
Refund Vehicle License Fee
36.00
CDW Government, Inc.
19" LED Monitor for EOC A/V Monitor
114.99
Century Cleaners
Uniform Cleaning
11.12
Uniform Cleaning
17.80
Page 1 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
June 16 - June 29, 2011
Fund Vendor Name
Invoice Description
Amount
Uniform Cleaning
15.57
Uniform Cleaning
15.57
Uniform Cleaning
15.57
Uniform Cleaning
22.25
Uniform Cleaning
24.47
Uniform Cleaning
15.57
Uniform Cleaning
15.57
Uniform Cleaning
17.80
Uniform Cleaning
24.47
Uniform Cleaning
22.25
Uniform Cleaning
15.57
Uniform Cleaning
17.80
Charalab, Margaret Ann
Downtown Block Party
350.00
Chicago Title Insurance - mt.pro
Research Property -1125 North Boxwood Drive
650.00
Chicago Tribune
Chicago Tribune Subscription 6 -17 -11 thru 6 -14 -2012
299.00
Chlumsky, Donna M.
Downtown Block Party
350.00
Clark, Sandra M.
Reimbursement
60.00
Clothing Allowance
13.14
Commonwealth Edison
Electrical Service Delivery
208.59
Electrical Service Delivery
23.54
Electrical Service Delivery
23.72
Electrical Service Delivery
23.72
Costar Realty Information, Inc.
ED Site Software
454.58
Crystal Court Shopping Center
July 2011 Rental
3,408.00
Dahlberg, John
Reimburse expenses: 4215. Main Drug Lab clean -up
220.18
Reimburse expenses
107.73
Data Media Products, Inc.
Video Tapes & CDs
242.10
Dell Marketing L.P.
Parts replacement for out of warranty computers
403.99
Parts replacement for out of warranty computers
287.98
Double D Booking
Downtown Block Party
8,500.00
Environmental Safety Group, Inc.
Toxi RAE III Monitors
360.00
Evident Crime Scene Products
Evidence collection supplies
174.00
F.J. Kerrigan Plumbing Co.
Building Maintenance
750.00
Federal Express Corp
Shipping Charges - FOIA Request
123.76
Fifth Third Bank
Credit Card
399.00
Fire Pension Fund
Fire Pension
21,303.75
Fsas, LLC.
CIP Meeting - Dinner
224.00
Fulton Technologies, Inc.
Annual Fee - Warning Sirens Monitoring
414.00
Gall's, Inc.
Squad emergency supplies
567.47
Garvey's Office Products
Office Supplies
102.87
Grainger Inc.
Maintenance and repair supplies
702.97
Custodial & Maintenance Supplies
309.92
Graybar Electric Co.
Streetlight Supplies
26.58
Green, Libby
Downtown Block Party
425.00
Hansen, Donald E.
CDL Reimbursement
30.00
Health Endeavors
Return to Work Evaluation/ Schwegler
75.00
Healy Asphalt Company,llc.
Hot mix asphalt
44.20
Hot mix asphalt
25.48
Home Depot U.S.A., Inc.
Maintenance and repair supplies
241.29
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
18,339.52
Illinois American Water Company
Service 5/10/11- 6/9/11
271.12
Illinois Department of Revenue
IL State Withholding
34,085.78
Illinois EPA
Annual NPDES Permit Fee
1,000.00
Illinois Fire Safety Alliance
2011- FPB Week Luncheon Oct 13, 2011
350.00
Illinois Paper Co.
Copy Paper
1,180.00
Illinois Public Employer Labor Relations Assn
IPELRA Seminar Registration
160.00
Inlander Brothers Inc
Custodial Supplies
811.03
Custodial Supplies
305.62
Insty- prints of Palatine, Inc.
70 Pocket SOP's
185.50
Internal Revenue Service
Federal Withholding
490.22
Federal Withholding
153,961.09
International Union of Operating Engineers
IUOE PW Membership Dues
564.63
Janonis, Michael E.
Lunch meeting
134.05
Jones, Daniel G.
Reimbursement
10.00
Journal & Topics Newspapers
Classified Advertising for Part-time Clerk in Finance
455.00
Legal Notices for Planning & Zoning
110.40
Legal Notices for Planning & Zoning
99.36
Treasurer's Report Display Advertising- WEDNESDAY
1,071.00
Jung, Yoo
Refund Duplicate Vehicle License Fee
36.00
Page 2 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
June 16 -June 29, 2011
Fund Vendor Name
Invoice Description
Amount
K & K America Corp
Office equipment
201.50
Karlstedt Landscape, Inc.
Shrub Planting
604.27
Kerstein, June
Reimb May 2011 Food Exp & June 2011 Phone Bill
63.75
Klein, Thorpe and Jenkins, Ltd.
KTLJ Billing
35,974.41
Kone, Inc.
Elevator Maintenance
289.00
Kramer Tree Specialists
Grounds Maintenance
520.00
Krebs, Jennifer
Safety Shoes
125.55
L -3 Communications
Equipment Replacement
54.95
Lands' End Business Outfitters
Uniforms
463.82
Lukas, Rhonda
Refund Vehicle License Fee
72.00
Lundstrom's Nursery, Inc.
Grounds Maintenance
1,162.99
Grounds Maintenance
1,162.99
Grounds Maintenance
1,162.99
Mazursky, Shelby
Office Supplies
181.50
McDonald's Corporation
Prisoner meals - May, 2011
193.31
Menards
Engineering Equipment & Supplies
14.93
Training Supplies
17.32
Construction Wood and Small Tools
52.64
Supplies for traffic trailer
136.71
Metro Federal Credit Union
MP Fire Local 4119 Dues
2,357.40
Metropolitan Alliance - Police
MP Police Association Dues
1,206.50
Mid American Water of Wauconda, Inc.
Inlet & Catch Basin Supplies
229.50
Mobile Print Inc.
Printing
64.99
Morgan, Nancy
Reimburse N. Morgan for Seminar
179.99
Mount Prospect Historical Soc.
2011 Budget Allocation July 2011
3,333.33
Nagurski Kiddie Rides, Inc.
Downtown Block Party
1,550.00
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
13,207.00
Nextel Communications
[4] air cards
159.96
Cell phones - Invoice 984298104 -042
239.94
NICOR
Natural Gas Consumption
183.19
Natural Gas Consumption
172.03
None
Refund Duplicate Payment for Vehicle License
81.00
North East Multi Regional Trng
In House Course fee
609.00
Course Registration
50.00
Northeastern III. Pub. Safety Trng.
Training
150.00
9 Fire Depts - MABAS DIV III 2011 SPRING TRAINING
2,700.00
Northern Illinois Police Alarm System
Language line - May, 2011
77.50
Northwest Assoc. of Provider Ems Coordinators
Membership/ Seleen Wendy Northwest Asss of Provider EMS Cord.
50.00
Northwest Suburban United Way
United Way
232.78
Northwestern University
Course registrations for T. Hoskinson
2,200.00
Novak & Parker Inc.
Equipment Maintenance
191.45
Novak, Todd
Kitchen Supplies
72.35
Office Depot
Office Depot 5/1/11- 5/31/11
618.13
Office Depot Supplies
273.38
Office Supplies - May 2011
451.29
Office Supplies
14.49
Old Town School of Folk Music
Downtown Block Party
750.00
On Time Inc.
Uniform supplies
14.00
Otis Elevator Company
Elevator Maintenance
350.00
Pacific Telemanagement Services
Service 7 /1/11- 7/31/11
78.00
Paddock Publications, Inc.
Bid Notice
48.60
Legal notice
46.50
Petty Cash
Petty Cash - Finance Dept 5/5/11- 6/13/11
162.92
Petty Cash - Finance Dept 6 /22/11- 6/24/11
326.00
Police Pension Fund
Police Pension
27,718.43
Pope, Elizabeth A.
Garnishment
923.08
Postmaster
Postage Stamps
440.00
Powell Tree Care, Inc.
Tree Trimming
11,326.76
Tree Trimming
4,852.70
Prosafety, Inc.
Uniforms
265.47
Red Wing Shoe Store
Safety Shoes
114.74
San Filippo Landscape Inc.
Spring 2011 Tree Plantings
8,092.96
Tree Replacement
275.00
Sgrignoli, Carol & Gary
Refund Duplicate Payment for Vehicle License
108.00
Sheridan, Brian
Friday Concert - Performance Fee
700.00
Sirchie Finger Print Laboratory
Evidence collection supplies
490.40
Sound Incorporated
Voice Mail Annual Support
2,231.60
Monthly Fee for Telephone Support
828.83
Maintenance Contract for phone, servers, switches
72.00
Page 3 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
June 16 - June 29, 2011
Fund Vendor Name
Invoice Description
Amount
Staples Contract & Commercial, Inc.
USB Flash Drives
107.88
Systems Forms, Inc.
CAFR Binding Combs
221.00
CAFR Covers & Backs
195.40
Taylor Rental Center
Table Cloths
131.76
Taylor, Joel
Downtown Block Party
425.00
The Ups Store
Shipping Charges from UPS Store 5/27/11
8.67
U.S. Bancorp Equipment Finance, Inc.
7/16/11 Usage -1700 W Central Rd
167.50
Uline Inc.
Photo /video evidence supplies
133.71
United States Fire Protection
Sprinkler System Maintenance
565.00
Sprinkler System Maintenance
275.00
Sprinkler System Maintenance
750.00
United States Postal Service
Postage -May CAPS
2.63
VCG Uniform
Embroidery for Jacket/ Truty
5.00
Dress Cap/ Wisniewski, Dress Shirt/ Malcolm
265.95
MPFD/ Emblems (Future Orders)
975.00
Village of Mount Prospect
Flex - Parking
11,614.46
Water & Sewer Service 4/27/11- 5/31/11
11.69
Village of Romeoville
Registration/ Miller Uoyd- April 8, 2011 Vehicle Ops
455.00
Warehouse Direct
Office Supplies
217.55
West Publishing Corporation
Publication
198.00
Wide Open West
WOW Internet Service
72.99
W ISCTF
Garnishment
542.48
Worth, Lottie
Rebate Real Estate Tax Transfer Stamp
492.00
Wulbecker, Jeffrey
Clothing Allowance
69.60
001 General Fund Total
$
470,317.03
020 Capital Improvement Fund
Business Office Systems, Inc.
Office Furniture
$
2,336.00
Hecker and Company Inc.
Prospect Avenue Lighting Project
7,233.00
New World Systems Corporation
ERP - Project Management Services
16,500.00
Plante & Moran, Pllc
ERP - Consulting Services
647.50
ERP - Consulting Services
85.00
SRBL Architechts, Ltd.
Fire Station #14 Signage Design - Invoice #2
1,464.00
020 Capital Improvement Fund Total
$
28,265.50
022 Downtown Redevelopment Construction
Autumn Landscaping Inc
Streetscape Program
$
3,066.00
022 Downtown Redevelopment Construction Total
$
3,066.00
023 Street Improvement Construction Fund
Christopher B. Burke Engineering Ltd
Construction Engineering Services
$
6,451.00
Desman, Inc.
Parking Lot Improvements
1,550.00
Hecker and Company Inc.
Prospect Avenue Lighting Project
131,596.12
023 Street Improvement Construction Fund Total
$
139,597.12
040 Refuse Disposal Fund
ARC Disposal Company
Refuse Disposal Program
$
239,400.89
AT&T
AT & T Long Distance 5/1/11- 5/31/11
4.34
Service 6/10/11- 7/9/11
16.26
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
41.88
Illinois Department of Revenue
IL State Withholding
333.24
Internal Revenue Service
Federal Withholding
2,052.88
International Union of Operating Engineers
IUOE PW Membership Dues
60.53
Menards
Leaf Truck Boxes
361.65
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
31.00
Northwest Suburban United Way
United Way
3.00
Peterson, Betty
Refund Final Refuse Acct#1427001
25.00
United States Postal Service
Postage -May CAPS
1,104.69
Village of Mount Prospect
Flex - Parking
270.83
Wells Fargo Bank
SWANCC - July 2011
97,618.63
040 Refuse Disposal Fund Total
$
341,324.82
041 Motor Fuel Tax Fund
Exelon Corporation
Electrical Service Delivery
$
76.26
Electrical Service Delivery
56.95
Electrical Service Delivery
208.03
Electrical Service Delivery
77.33
Electrical Service Delivery
78.72
Electrical Service Delivery
96.12
Page 4 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
June 16 - June 29, 2011
Fund Vendor Name
Invoice Description
Amount
112.50
Electrical Service Delivery
53.51
Electrical Service Delivery
127.34
Federal Withholding
Electrical Service Delivery
37.56
Paddock Publications, Inc.
Electrical Service Delivery
105.03
256.50
Electrical Service Delivery
93.04
Electrical Service Delivery
166.77
Flex - Parking
Electrical Service Delivery
107.04
Gewalt Hamilton Assoc.
Pedestrian Signal Improvement Project
1,809.40
Illinois State Treasurer
Traffic Signal Maintenance
5,298.54
Meade Electric Co. Inc.
2011 Traffic Signal Maintenance
338.38
041 Motor Fuel Tax Fund Total
$
$ 8,730.02
042 Community Development Block Grant
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
$
112.50
Illinois Department of Revenue
IL State Withholding
128.24
Internal Revenue Service
Federal Withholding
699.07
Paddock Publications, Inc.
CDGB Legal Notice - Published 6/1/11
256.50
CDGB Legal Notice - Published 6/3/11
64.80
Village of Mount Prospect
Flex - Parking
127.60
042 Community Development Block Grant Total
$
1,388.71
050 Water and Sewer Fund
Addison Building Material Co.
Grounds Maintenance Materials and Supplies
$
9.29
Alexian Brothers Medical Center
DOT Drug/Acohol Screen
490.00
American Landscaping Inc.
Landscape Restoration
7,056.00
Landscape Restoration
6,228.00
Landscape Restoration
4,815.00
American Waterworks Assoc.
Training
45.00
Aramark Uniform Services, Inc.
Uniform Rental & Cleaning
104.76
PW Uniform Rental and Cleaning for 2011
104.76
AT & T
AT & T Long Distance 5/1/11- 5/31/11
289.76
Service 6/10/11- 7/9/11
544.21
Service 6/10/11- 7/9/11
1,085.61
Service 06/10/11 - 7/9/11
430.82
Baxter & Woodman, Inc.
Professional Engineering
4,689.14
Professional Engineering
1,620.00
Engineering Services
2,737.98
Blake, Dale
Refund Final Utility Bill Acct#548404
173.94
Burns & Mcdonnell Engineering Co.
Professional Services
1,485.00
Professional Services
825.00
Cardinal Fence & Supply Inc.
Fence Maintenance
4,645.00
Caudill, Samantha
Refund Overpayment Water #36705
29.19
Refund Overpayment Water #36704
83.04
Century Cleaners
Uniform Cleaning
11.13
Uniform Cleaning
17.80
Uniform Cleaning
15.58
Uniform Cleaning
15.58
Uniform Cleaning
15.58
Uniform Cleaning
22.25
Uniform Cleaning
24.48
Uniform Cleaning
15.58
Uniform Cleaning
15.58
Uniform Cleaning
17.80
Uniform Cleaning
24.48
Uniform Cleaning
22.25
Uniform Cleaning
15.58
Uniform Cleaning
17.80
Djomlija, Mike
Refund Final Utility Bill Acct # 1152506
103.03
Exelon Corporation
Electrical Service Delivery
2,462.16
Electrical Service Delivery
1,809.81
Electrical Service Delivery
495.47
Federal Express Corp
Shipping Charges
156.69
Frazier Concrete, Inc.
Concrete Restoration Contract for 2011
19,109.80
Gomez, Jay
Reimbursement
40.00
Grainger Inc.
Maintenance and repair supplies
778.66
HBK Water Meter Service
Water Meter Installation /Building Inspection /Meter Testing
357.00
Water Meter Installation /Building Inspection /Meter Testing
1,544.00
Water Meter Installation /Building Inspection /Meter Testing
151.00
Water Meter Installation /Building Inspection /Meter Testing
181.00
Page 5 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
June 16 - June 29, 2011
Fund Vendor Name
Invoice Description
Amount
Water Meter Installation /Building Inspection /Meter Testing
300.00
Water Meter Installation /Building Inspection /Meter Testing
2,494.00
Water Meter Installation /Building Inspection /Meter Testing
52.68
Water Meter Installation /Building Inspection /Meter Testing
119.00
Water Meter Installation /Building Inspection /Meter Testing
151.00
Water Meter Installation /Building Inspection /Meter Testing
1,634.20
Homer Tree Care, Inc.
Tree Removal
384,00
Tree Removal
192.00
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
1,011.02
Illinois Department of Revenue
IL State Withholding
2,806.61
Internal Revenue Service
Federal Withholding
15,887.54
International Union of Operating Engineers
IUOE PW Membership Dues
416.30
Jjs Global Ventures Inc
Equipment Repair
225.63
Kieft Brothers Inc.
Maintenance and repair supplies
144.00
Lands' End Business Outfitters
Uniforms
463.83
Mara, Noel F
Water Meter Repairs Parts and Supplies
484.02
Mazursky, Shelby
Water Meter Reading Door Hangers
321.00
Office Supplies
181.50
Meere, John
Refund Final Utility Bill Acct# 214001
46.83
Menards
Hydrant Painting Supplies
180.57
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
271.99
Nextel Communications
Cellular Phone Purchased 5/17/11- 6/16/11
219.98
NICOR
Natural Gas Consumption
82.50
Natural Gas Consumption
124.89
Northeastern III. Pub. Safety Trng.
Training
75.00
Northwest Landscape Services, Inc.
Restoration planting around generators
3,809.76
Planting Mugho Pine at 505 E. Berkshire
110.00
Northwest Suburban United Way
United Way
21.00
Patten Industries, Inc.
Vehicle Maintenance Supplies
80.00
Petty Cash
Petty Cash - Finance Dept 6/22/11- 6/24/11
49.26
Prosafety, Inc.
Uniforms
183.41
Quality Blacktop Inc.
Asphalt Restoration Contract for 2011
26,613.69
San Filippo Landscape Inc.
Spring 2011 Tree Plantings
186.29
Sewer Equipment Co. of America
Maintenance and repair supplies
308.15
U.S. Bancorp Equipment Finance, Inc.
7/16/11 Usage -1700 W Central Rd
167.50
United States Postal Service
Postage -May CAPS
2,245.01
Village of Mount Prospect
Flex - Parking
592.06
Wal -Mart Community
PW Supply - Rubbing Alcohol
11.84
World Fuel Services, Inc.
1200 gal off road diesel fuel for st #5 gen set
4,106.88
050 Water and Sewer Fund Total
$
131,686.53
051 Village Parking System Fund
Illinois Department of Revenue
IL State Withholding
$
32,34
Internal Revenue Service
Federal Withholding
190.18
International Union of Operating Engineers
IUOE PW Membership Dues
9.68
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
13.80
Petty Cash
Petty Cash - Finance Dept 5/5/11- 6/13/11
22.00
Village of Mount Prospect
Flex - Parking
23.50
051 Village Parking System Fund Total
$
291.50
052 Parking System Revenue Fund
Illinois Department of Revenue
IL State Withholding
$
55.45
Internal Revenue Service
Federal Withholding
275.70
International Union of Operating Engineers
IUOE PW Membership Dues
6.46
Karlstedt Landscape, Inc.
Shrub Planting
588.28
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
9.21
Petty Cash
Petty Cash - Finance Dept 5/5/11- 6/13/11
81.00
Union Pacific Railroad
Land Lease for May 2011
3,418.84
Village of Mount Prospect
Flex - Parking
69.85
Water & Sewer Service 4/27/11- 5/31/11
25.07
052 Parking System Revenue Fund Total
$
4,529.86
060 Vehicle Maintenance Fund
ACS State & Local Government Solutions
Illinois State Disbursement Unit
$
48014
Aetna Truck Parts
Vehicle Maintenance Supplies
209.66
Vehicle Maintenance Supplies
660.00
Alexander Equip.co., Inc.
Vehicle Maintenance Supplies
76.40
Arlington Heights Ford
Vehicle Maintenance Supplies
70.40
Vehicle Maintenance Supplies
426.73
Page 6 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
June 16 - June 29, 2011
Fund Vendor Name
Invoice Description
Amount
Vehicle Maintenance Supplies
274.61
Equipment Maintenance
138.90
AT&T
AT & T Long Distance 5/1/11- 5/31/11
10.85
Service 6/10/11 - 7/9/11
40.66
Barnes Group
Vehicle Maintenance Supplies
456.23
Busse Car Wash, Inc.
Car washes
1,118.00
Certified Fleet Services, Inc.
Vehicle Maintenance Supplies
373.43
Computerized Fleet Analysis
Equipment Maintenance
695.00
DJK Contractors, Inc.
Fuel System Maintenance
4,420.00
Ehrhardt's Trailer Sales Inc
Vehicle Maintenance Supplies
9.99
Vehicle Maintenance Supplies
17.99
Finishmaster, Inc.
Vehicle Maintenance Supplies
13.40
Fleetpride, Inc.
Vehicle Maintenance Supplies
9.16
Vehicle Maintenance Supplies
57.20
Global Emergency Products
517 air step plunger and bushing
95.34
Vehicle Maintenance Supplies
758.08
Grainger Inc.
Vehicle Maintenance Supplies
9.78
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
508.19
Illinois Department of Revenue
IL State Withholding
1,411.76
Internal Revenue Service
Federal Withholding
7,879.65
International Union of Operating Engineers
IUOE PW Membership Dues
294.57
Interstate Battery
V -56 battery
79.95
Just Tires
Vehicle Maintenance Supplies
763.38
Vehicle Maintenance Supplies
508.92
Leach Enterprises, Inc.
Vehicle Maintenance Supplies
66.87
Vehicle Maintenance Supplies
61.00
Napa - Heights Automotive Supply
2710 blower motor resistor
36.45
2732 starter
174.46
Credit for wrong part
(26.48)
2761 oil filters
28.98
2761 hyd filters
36.42
Vehicle Maintenance Supplies
11.18
530 bulbs
45.52
530 bulbs
45.52
Credit for core and wrong parts
(151.47)
V -56 bulbs
12.84
P -54 front brake calipers
75.00
P -54 front grease seals
18.54
P -54 front brake pads
14.68
Bearing grease
25.74
P -54 brake booster check valve
21.49
Grease
26.94
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
210.00
Northwest Suburban United Way
United Way
5.00
Patten Industries, Inc.
Vehicle Maintenance Supplies
50.05
Pomp's Tire Service, Inc.
Equipment Maintenance
35.00
Vehicle Maintenance Supplies
2,920.60
Vehicle Maintenance Supplies
771.03
Prairie International Truck Sales
2754 oil pan
346.31
Vehicle Maintenance Supplies
569.60
Precision Service & Parts
P -35 fuel pump
282.57
Squad transmission filters
96.60
Ronco Industrial Supply
Small Tools
39.24
Vehicle Maintenance Supplies
143.11
Terrace Supply Company
Equipment Maintenance
25.94
Equipment
333.62
Vehicle Maintenance Program Inc.
Vehicle Maintenance Supplies
470.80
Village of Mount Prospect
Flex - Parking
395.40
West Side Tractor Sales
Vehicle Maintenance Supplies
73.26
Vehicle Maintenance Supplies
41.14
World Fuel Services, Inc.
8498 gallons unleaded fuel under SPC contract
28,325.61
060 Vehicle Maintenance Fund Total
$ 57,527.03
061 Vehicle Replacement Fund
Astroblast, Inc.
New Vehicles
$ 525.00
New Vehicles
495.00
El Equipment
New Vehicles
18,670.00
New Vehicles
2,962.00
Finishmaster, Inc.
Replacement Vehicles
(202.88)
Page 7 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
June 16 - June 29, 2011
Fund Vendor Name Invoice Description Amount
Replacement Vehicles 1,005.64
New Vehicles 890.72
061 Vehicle Replacement Fund Total $ 24,345.48
063 Risk Management Fund
Cannon Cochran Management Services, Inc. Claims & Administration Fee - 3rd Quarter 2011
Global Emergency Products Accident Repair to Pass Mirror of Fire Engine 517
Hoskins Chevrolet, Inc. S -31 Accidental Damage to Drivers Mirror
063 Risk Management Fund Total
070 Police Pension Fund
Internal Revenue Service
Richard Reimer & Assoc., LLC.
070 Police Pension Fund Total
PPFED - Federal Withholding
Legal Services 4/1/11- 4/26/11
071 Fire Pension Fund
Capital Gains Inc.
Cary J. Collins, P.C.
Internal Revenue Service
071 Fire Pension Fund Total
072 Flexcomp Escrow Fund
Guardian
072 Flexcomp Escrow Fund Total
073 Escrow Deposit Fund
AG VanGundy Landscape
American Thermal
Balazs, Judith
Bennett, James
Bosch Tool
Campbell, Kevin
Churchill, Robert
CMPactor
Corona, Maria
Danley Garage
Dermatoian, Vincent
Drainmaster Sewer
Duropave Construction
Expert Concrete Solution
Fortis Concrete
Golding, Rich /Ann
Goss, lames
Gratz, Andrea
Ibbotson Heating Co.
Ivy Landscaping Inc.
Jay Sainath Sales Inc.
Joseph Landscape & Brick Paving
Kakavetsis, Harry
Kemp, Brian / Mary
Kennebeck, Dave & Cynthia
Kent, Leslie
Krueger's Concrete & Excavating
Lamantia Construction
Lay, Lucille
Lutz, Erwin
Malko, Olexander
Maziarka, Donald
Meske, Paul
Moughamian, Henry
Nicholas & Associates, Inc.
Padol, Katarzyna
Paradowicz, Gregory
Parker, Doris
Person, Tiffany / Erik
Poznanski, Francis
Investment Management -June
Legal Services July 2011- September 2011
FPFED - Federal Withholding
Emp Dental Plan July 2011
Refund Escrow Permit # 11 -0558
Refund Escrow Permit # 11-0464
Refund Escrow Permit # 11 -0859
Refund Escrow Permit # 11 -0195
Refund Escrow Permit # 11 -0913
Refund Escrow Permit # 11 -0743
Refund Escrow Permit # 11 -0804
Refund Escrow Permit # 11 -0360
Refund Escrow Permit # 11 -0850
Refund Escrow Permit# 11 -0178
Refund Escrow Permit # 10 -1326
Refund Escrow Permit # 08 -0094
Refund Escrow Permit # 11 -0556
Refund Escrow Permit # 11 -0593
Refund Escrow Permit # 11 -0789
Refund Escrow Permit # 11 -0589
Refund Escrow Permit # 11 -0590
Refund Escrow Permit # 11 -0666
Refund Escrow Permit # 11 -0719
Refund Escrow Permit # 10 -0038
Refund Escrow Permit # 11 -0616
Refund Escrow Permit # 11 -0671
Refund Escrow Permit# 11 -0016
Refund Escrow Permit # 11 -0682
Refund Escrow Permit # 11 -0830
Refund Escrow Permit # 10 -1829
Refund Escrow Permit # 10 -1829
Refund Escrow Permit # 09 -0271
Refund Escrow Permit # 11 -0779
Refund Escrow Permit # 11 -0703
Refund Escrow Permit # 11 -0099
Refund Escrow Permit # 11 -0890
Refund Escrow Permit # 11 -0888
Refund Escrow Permit # 10 -0870
Refund Escrow Permit # 11 -0720
Refund Escrow Permit # 11 -0835
Refund Escrow Permit # 11 -0813
Refund Escrow Permit # 09 -2208
Refund Escrow Permit# 11 -0074
Refund Escrow Permit # 11 -0825
Refund Escrow Permit # 11-0448
Refund Escrow Permit # 10 -0232
Refund Escrow Permit # 11 -0889
$ 3,375.00
371.24
54.70
$ 3,800.94
$ 36,228.76
562.50
$ 36,791.26
$ 2,197.00
800.00
34,580.87
$ 37,577.87
$ 7,777.25
$ 7,777.25
75.00
125.00
125.00
500.00
125.00
150.00
200.00
200.00
125.00
225.00
575.00
125.00
150.00
200.00
150.00
200.00
200.00
150.00
200.00
1,100.00
125.00
150.00
25.00
150.00
150.00
75.00
1,500.00
1,250.00
150.00
200.00
200.00
200.00
200.00
125.00
200.00
125.00
200.00
950.00
75.00
200.00
125.00
1,200.00
200.00
Page 8 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
June 16 - June 29, 2011
Fund Vendor Name
Invoice Description
Amount
Quality Blacktop Inc.
Refund Escrow Permit # 11 -0928
150.00
Reese, John
Refund Escrow Permit # 10 -2160
450.00
Reliance Plumbing Sewer
Refund Escrow Permit # 10 -2599
75.00
Reliance Plumbing Sewer
Refund Escrow Permit # 10 -2757
125.00
Rich, John / Loretta
Refund Escrow Permit # 10 -2538
150.00
Rick's Sewer & Drainage
Refund Escrow Permit # 11 -0849
125.00
Scaravalle Construction Inc.
Refund Escrow Permit # 11 -0361
200.00
Smerge, Antoinette
Refund Escrow Permit # 11 -0379
125.00
Solt, Mimi
Refund Escrow Permit # 10 -2355
200.00
TAC Partnership
Refund Escrow Permit # 10 -2921
200.00
Third District Circuit Court
Bond Money 6/14/11
1,572.00
Bond Check 6/21/11
1,520.00
Bond Money 6/23/11
540.00
Bond Check 6/28/11
520.00
Wiese, Danuta & John
Refund Escrow Permit # 11 -0583
200.00
Wolak, Joseph
Refund Escrow Permit # 11 -0668
200.00
073 Escrow Deposit Fund Total
$ 19,027.00
Grand Total
$ 1,316,043.92
Page 9 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
June 30 - July 13, 2011
Fund Vendor Name Invoice Description Amount
nnl General Fund
3CMA
Membership Dues
$ 375.00
ACS State & Local Government Solutions
Illinois State Disbursement Unit
3.298.28
Active Alarm Company, Inc.
Alarm monitoring at the Center for 3rd quarter
73.50
Addison Building Material Co.
Maintenance and repair supplies
35.72
Maintenance and repair supplies
33.07
Maintenance and repair supplies
17.49
Maintenance and repair supplies
10.15
Forestry Equipment and Supplies
121.62
Parade Supplies
124.82
Return
(3.11)
Parade Supplies
9.86
Airgas North Central
Oxygen and Cylinder Rental
296.27
Alexander Communications Group, Inc.
Downtown Idea Exchange subscription
236.50
Downtown Promotion Reporter Subscription
206.50
Alexander Equip.co., Inc.
Equipment Rental
810.00
Alexian Brothers Medical Center
Pre - employment drug testing Jennifer Krebs
69.00
Amer Reprographics Co Llc
Equipment Maintenance
59.00
American Landscaping Inc.
Shrub Planting
1,883.97
Abatement - 1405 Sauk Lane
286.00
Grass Cutting - 216 S.Owen
286.00
Grass Cutting - 316 Rand
400.00
Grass Cutting -1005 Pendleton
286.00
Flower /Shrub Replacement
42.60
Anderlik, Robert J.
Friday on the Green 072911- Performance Fee
500.00
Anderson Pest Solutions
Pest Control at the Center for July
48.00
Andres Medical Billing, Ltd.
Ambulance Billing -June 2011
4,691.99
Aramark Uniform Services, Inc.
PW Uniform Rental and Cleaning for 2011
110.07
PW Uniform Rental and Cleaning for 2011
110.07
Arlington Power Equipment
MS460 Stihl Chainsaw
107.87
2011 June Storm - Chainsaws
620.36
2011 June Storm - Chainsaws
89.14
2011 June Storm - Chainsaws
202.30
AT & T
Service 6/16/11- 7/15/11
747.50
B & H Industries
Copy Bond Paper (2436)
103.14
B & H Photo /video
Camera Light Mount
37.90
Portable Icd tv
234.95
Barnes Group
Marking Paint
129.47
Bechtold, Mark
Reimburse expenses for training
32.00
Bedco Mechanical
Repairs to HVAC at Village Hall, add refrigerant 22
382.25
Building Maintenance HVAC Repairs
431.60
Hvac repairs at the Police /Fire Headquarters
200.00
Repairs to blower assembly at the PD /FD headquarters
331.35
Blue Saints Drum & Bugle Corps
4th of July Parade 2011
1,500.00
Bound Tree Medical, LLC.
Paramedic Supplies
601.26
Ambulance Supplies
91.02
Ambulance Supplies
79.74
Busse's Flowers & Gifts
Sympathy Randolf
85.00
Get Well Janonis
75.00
C.B.M.T., Inc.
Purchase of Various Annual Flowers
5,374.30
Grounds Beautification
1,750.00
CBS Awards
Training Supplies
3738
CDW Government, Inc.
Photo supplies
353.52
Photo supplies
141.96
Smartnet Renewals
1,465.00
Plotter Ink
134.35
Crossover Cables
41.13
Anti -Virus Renewal
7,350.00
Backup Exec Renewals
2,185.00
Central Service Center
Radar repair
193.86
Century Cleaners
Uniform Cleaning
13.35
Uniform Cleaning
17.80
Uniform Cleaning
44.50
Uniform Cleaning
35.60
Uniform Cleaning
32.15
Uniform Cleaning
13.35
Uniform Cleaning
10.05
Uniform Cleaning
24.47
Uniform Cleaning
17.80
Uniform Cleaning
24.47
Uniform Cleaning
15.57
Chicago Comm. Service, Inc.
Radio Maintenance agreement for Aug - Oct 2011
1,923.30
Chicago Tribune
Ads - Trib Local - Summer Fun
790.00
CL Graphics, Inc.
Mailing Services
350.00
Summer Newsletter
10,950.00
Page 1 of 8
VILLAGE OF MOUNT PROSPECT
List of Bills
June 30 - July 13, 2011
Fund
Vendor Name
Invoice Description
Amount
Classic Cavaliers DBC
4th of July Parade 2011
2,000.00
Comcast
Investigations Internet service
59.00
Cooney, William J.
Reimbursement - ICSC National Conference
695.72
Costco Wholesale
Purchased 5/31/11- 6/23/11
657.49
Crystal Maintenance Services Corp.
Custodial Services
6,163.62
Dahlberg, John
Reimburse expenses
218.61
Delk, Matthew & Linda
Rebate Real Estate Tax
850.00
Discount Media Products, LLC
DVDs
250.00
Enterprise Rent -a -car
Car rental for SIU surveillance
364.26
Entersect Corporation
Entersect Police Online service
88.95
Eterno, David G.
Legal
462.00
Eterno, Michael
Reimburse expenses for training
264.40
Everbank Commercial Finance, Inc.
Rental 7 /23/2011
2,252.07
CC Center Copy Machine - 7/24/2011 Rental
396.90
Federal Express Corp
Shipping Charges
45.34
Shipping for Building Division
26.91
Shipping Charges
11.01
FedEx Pick up k 871276581013
29.47
Shipping Charges
38.58
Fire Pension Fund
Fire Pension
21,284.84
Garvey's Office Products
Office Supplies
171.58
GE Capital
Service 6/15/11- 7/14/11
823.08
Glenwood Tree Experts
Emergency Contractual Tree Service
4,600.00
Grainger Inc.
2011 June Storm Yellow Barrier Tape
106.60
Maintenance and repair supplies
156.10
Maintenance and repair supplies
165.38
Hard Hats for Village Board "Go Kits"
62.95
Guziel, Fran
marketing services
960.00
Healy Asphalt Company,llc.
1.07 tons of Surface Material
55.64
0.90 tons of Surface Material
46.80
067 tons of surface material
34.84
Patching & Paving Materials
83.72
Homer Tree Care, Inc.
Emergency Contractual Tree Service
23,360.00
Emergency Contractual Tree Service
20,655.00
Emergency Contractual Tree Service
8,050.00
Horigan Urban Forest Products, Inc.
Emergency Contractual Tree Service
5,450.00
IACE
Quarterly Meeting - 7/13/11
175.00
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
19,008.20
Illinois American Water Company
Private Fire Service 7/1/11
28.28
Illinois Assoc of Technical Accident Investigators
2011 membership dues
45.00
Illinois Department of Revenue
STATE - IL - IL State Withholding
37,998.90
Illinois State Police
Pre -emp background check Interns and Contract Inspectors
753.50
I M RF
IM RF
151,852.87
Initial Tropical Plants Inc.
Annual Service /Maintenance
1,225.80
Inlander Brothers Inc
Custodial Supplies
505.00
Custodial Supplies
754.24
Custodial Supplies
20.50
Internal Revenue Service
Federal Withholding
181,198.03
International Union of Operating Engineers
IUOE PW Membership Dues
874.34
Inventory Trading Co
4- Tactical Gear Bags
124.00
J.G. Uniforms, Inc.
Uniform supplies: CSO Huizar
235.73
Uniform supplies: Officer S. Filipek
110.50
Jackson- hirsh, Inc.
Office Supplies
204.34
lanonis, Michael E.
Lunch meeting
47.58
Jarog, Lynn M.
Reimburse Travel Expense for Annual Logos Conference
75238
Kenney Machinery Corporation
Irrigation System
1,454.00
Kramer Tree Specialists
Grounds Maintenance
260.00
Lakeside Lutheran High School Marching Band
4th of July Parade 2011
1,000.00
Laner Muchin
Legal
389.59
Lee, Richard
Refund Vehicle License Fee
36.00
Lexisnexis Risk Data Management Inc.
Background checks - June, 2011
77.25
Lundstrom's Nursery, Inc.
Grounds Maintenance
1,162.99
Grounds Maintenance
1,162.99
Lurvey Landscape Supply
Flower Replacement
472.50
Lynxpm, LLC.
Annual maintenance agreement
930.00
Maclin, Wendell
4th of July Parade 2011
1,500.00
Malcolm, John
Malcolm/ 2011 June Storm Supplies
138.88
McVeigh- Cushing, Cathleen A.
Edit Library Life for June 2011
350.00
Menards
Forestry Equipment and Supplies
79.70
Grounds Maintenance Materials and Supplies
51.84
Equipment supplies
32.96
Metro Federal Credit Union
MP Fire Local 4119 Dues
2,357.40
Metropolitan Alliance - Police
MP Police Association Dues
1,206.50
Micro Tech Systems, Inc.
Printer Repair
148.95
Middleton, Joan
Reimbursement
35.28
Page 2 of 8
VILLAGE OF MOUNT PROSPECT
List of Bills
June 30 -July 13, 2011
Fund Vendor Name
Invoice Description
Amount
Mobile Print Inc.
Printing - Friday on the Green
145.50
Printing
246.38
Moore Landscapes, Inc.
Grounds Maintenance
1,600.00
Mount Prospect Paint, Inc.
Maintenance and repair supplies
15.55
Mount Prospect Public Library
Fiber Optic Charges for Village Hall 4/16/11 - 7/15/11
1,760.67
Fiber Optic Charges for CC Center 4/16/11 - 7/15/11 & Donor Wall
874.54
Mulcahy, Robert
CDL Reimbursement
30.00
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
12,988.57
Neenah Foundry Company
Inlet /Catch Basin Supplies
1,700.00
New Generation Fancy Drill Team
4th of July Parade 2011
2,000.00
New World Systems Corporation
Logos 2011 Customer Conference - Farkas
445.00
Logos 2011 Customer Conference - Jarog
445.00
Nextel Communications
Service 5/18/11- 6/17/11
3,815.16
Porject Shield service
39.99
Nexus Office Systems, Inc.
Staples
64.00
NICOR
Natural Gas Consumption
71.96
Natural Gas Consumption
109.97
Natural Gas Consumption
451.42
Natural Gas Consumption
263.97
Natural Gas Consumption
143.32
Natural Gas Consumption
62.15
Natural Gas Consumption
168.26
Natural Gas Consumption
1,309.38
Natural Gas Consumption
81.19
Blue Cross Blue Shield
Refund Over payment by Blue Cross
238.79
North East Multi Regional Trng
Course registration for 1. Juhl
350.00
Northeastern III. Pub. Safety Trng.
Training
150.00
Northern Illinois University
Registration/ Malcolm IPPFA (MEMBER) 2011- Conference Oct 4 -7
275.00
Northwest Central Dispatch System
August 2011- Member Assessment
44,914.36
Northwest Electrical Supply
Streetlight Supplies
1,278.02
Maintenance and repair supplies
37.01
Northwest Landscape Services, Inc.
Shrub Planting
4,410.27
Northwest Suburban United Way
United Way
217.02
Novak & Parker Inc.
Parts & Labor
233.26
Dishwasher Basket
34.76
Office Depot
Office Supplies
319.20
Office Supplies - June
140.13
Pacon Corporation
Parade Supplies
632.68
Parade Supplies
178.D0
Paddock Publications, Inc.
Bid Notice
103.95
Bid Notice
85.05
Paul Hall Community Center
4th of July Parade 2011
900.00
Penton Business Media, Inc.
Subscription/ Malcolm, John (1) Year
68.00
Peterson Roofing
Building Maintenance
2,950.00
Petty Cash
Petty Cash 2011
31.07
Police Pension Fund
Police Pension
27,769.76
Pope, Elizabeth A.
Garnishment
923.08
Powell Tree Care, Inc.
Emergency Contractual Tree Service
5,352.50
Emergency Contractual Tree Service
3,972.50
Emergency Contractual Tree Service
2,535.00
Emergency Contractual Tree Service
6,220.00
Emergency Contractual Tree Service
6,738.75
Emergency Contractual Tree Service
3,978.75
Emergency Contractual Tree Service
2,725.00
Emergency Contractual Tree Service
1,980.00
Emergency Contractual Tree Service
1,601.25
Tree Trimming
3,262.63
Prairie Brass Band
4th of July Parade 2011
2,000.00
Prosafety, Inc.
Other supplies
539.70
Prospect Marching Knights
4th of July Parade 2011
2,000.00
Proviso West High School Marching Band
4th of July Parade 2011
800.00
Red Wing Shoe Store
Safety Shoes
165.74
Ristow, David
CDL Reimbursement
30.00
RMS Technology Solutions
Switch replacement - Hardware only
11,078.00
Labor for switch replacement
1,110.00
Set Environmental, Inc.
Emergency clean -up of 421 Main St.
2,469.50
Shaffer, Jessica
CDL Reimbursement
30.00
Signs By Tomorrow
Signs
1,027.30
Sill, Gregory
Reimburse expenses for training
32.00
Sister Cities International
Annual Dues
680.00
Sound Incorporated
Monthly Fee for Telephone Support
828.83
South Shore Drill Team &performing Arts
4th of July Parade 2011
3,500.00
Spill 911, Inc.
Firefighting Equipment- Plug & Dike Granular
39.45
Stanard & Associates, Inc.
2011 Recruit test
10,721.05
Standard Fuse Corporation
Flares
2,392.20
Page 3 of 8
VILLAGE OF MOUNT PROSPECT
List of Bills
June 30 - July 13, 2011
Fund Vendor Name
Invoice Description
Amount
Staples Contract & Commercial, Inc.
Office Supplies
811.59
State of Illinois
Monthly Internet Access Fee
1,182.70
Systems Forms, Inc.
#9 Return Envelopes
877.18
T.P.I.
Building Inspections
13,773.00
Building Inspections
18,240.00
Building Inspections
11,580.00
Terry, Irma
Consulting Services
400.00
Thompson Elevator Inspections
Elevator Inspections
1,814.00
Elevator Inspections
592.00
Elevator Inspections
703.00
Elevator Inspections
778.00
Elevator Inspections
593.00
Trugreen Limited Partnership
Herbicide Application
5,305.28
Truty, Chris J.
Reimbursement/ Truty Cell Phone Car Charger
32.24
U.S. Bancorp Equipment Finance, Inc.
7/20/11 Usage
1,362.28
7/22/11 Usage -1601 W Golf Rd
138.78
Uline Inc.
Evidence storage
102.01
Evidence collection supplies
146.26
United Parcel Service
Miscellaneous shipping charges
23.58
United States Postal Service
Postage report subscription
80.00
CAPS postage -June
3,413.40
University of Illinois
Training
4,489.00
Training
150.00
Training
125.00
Training
288.00
Village of Mount Prospect
Flex - Parking
11,840.16
Village Profile
MP Chamber Ad
2,995.00
Walega, Joseph A
4th of July Parade 2011
800.00
Warehouse Direct
Office Supplies
152.32
Office Supplies - (Stock) Supply Cabinet
413.69
Office Supplies
193.50
Label Maker and Cartridges FPB
282.87
Office Supplies - (Stock) Supply Cabinet
466.17
Westberg, Seth
CDL Reimbursement
30.00
WGN Flag & Decorating Co.
Parade Supplies
1,691.20
Wilks, Irvana
Mayors cellular bill
45.00
W ISCTF
Garnishment
542.48
Worldpoint Ecc, Inc.
CPR Supplies
214.99
DVD/ CPR Class
28.50
Z Search Recruiting, Inc.
Photography Services - DT Block Party 072311
450.00
photography services - 072911- Concert on the Green
100.00
Photography Services - Village Board Portraits 062111
100.00
001 General Fund Total
$
843,719.13
002 Debt Service Fund
Illinois EPA
L17 -0856 Principal & Interest
$
19,644.42
002 Debt Service Fund Total
$
19,644,42
020 Capital Improvement Fund
Active Transportation Alliance, NFP
April Expenses
$
1,010.80
American Building Services
Public Buildings
677.10
Business Office Systems, Inc.
Office Furniture
551.90
Hutchinson Design Group,ltd.
Professional Services
7,750.00
New World Systems Corporation
Logos 2011 Customer Conference - Farkas
500.00
Logos 2011 Customer Conference -Jarog
500.00
Northwest Landscape Services, Inc.
Shrub Planting
3,854.85
020 Capital Improvement Fund Total
$
14,844.65
022 Downtown Redevelopment Construction Fund
Bonestroo,Inc.
7/1/11 - 6/30/12 Membership
$
375.00
Lundstrom's Nursery, Inc.
Landscape Maintenance
10,680.00
022 Downtown Redevelopment Construction Fund Total
$
11,055.00
023 Street Improvement Construction Fund
Electrical Resource Management, Inc.
Streetlight Improvements
$
1,848.00
Streetlight Improvements
21,468.00
023 Street Improvement Construction Fund Total
$
23,316.00
024 Flood Control Construction Fund
Northwest Landscape Services, Inc.
Creek Cleaning
$
2,409.00
Creek Cleaning
412.50
024 Flood Control Construction Fund Total
$
2,821.50
040 Refuse Disposal Fund
AT & T
Service 6/16/11- 7/15/11
$
4.16
Page 4 of 8
VILLAGE OF MOUNT PROSPECT
List of Bills
June 30 - July 13, 2011
Fund Vendor Name
Invoice Description
Amount
Groot Industries, Inc.
Refuse Disposal
149.99
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
56.76
Illinois Department of Revenue
STATE - IL - IL State Withholding
393.12
IMRF
IMRF
1,000.93
Internal Revenue Service
Federal Withholding
2,618.67
International Union of Operating Engineers
IUOE PW Membership Dues
39.13
Liebovich Bros, Inc.
Leaf Truck Boxes
602.44
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
18.91
Northwest Suburban United Way
United Way
1 - 99
Village of Mount Prospect
Flex - Parking
24628
040 Refuse Disposal Fund Total
$
5,132.38
041 Motor Fuel Tax Fund
Exelon Corporation
Electrical Service Delivery
$
3.59
Electrical Service Delivery
2,511.92
Illinois State Treasurer
Traffic Signal Maintenance
180.03
Meade Electric Co. Inc.
2011 Traffic Signal Maintenance
1,976.00
041 Motor Fuel Tax Fund Total
$
4,671.54
042 Community Development Block Grant
Everbank Commercial Finance, Inc.
Rental 7 /23/2011
$
16.80
GE Capital
Service 6/15/11- 7/14/11
205.76
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
112.50
Illinois Department of Revenue
IL State Withholding
131.03
IMRF
IMRF
295.39
Internal Revenue Service
Federal Withholding
720.30
Village of Mount Prospect
Flex - Parking
127.60
042 Community Development Block Grant Total
$
1,609.38
050 Water and Sewer Fund
American Landscaping Inc.
Restoration planting around generators
$
596.40
American Public Works Assoc.
Training
175.00
Aramark Uniform Services, Inc.
PW Uniform Rental and Cleaning for 2011
110.07
PW Uniform Rental and Cleaning for 2011
110.07
AT & T
Service 6/16/11- 7/15/11
277.58
Busse's Flowers & Gifts
Sympathy Arrangement
70.00
Century Cleaners
Uniform Cleaning
13.35
Uniform Cleaning
17.80
Uniform Cleaning
44.50
Uniform Cleaning
35.60
Uniform Cleaning
32.15
Uniform Cleaning
13.35
Uniform Cleaning
10.05
Uniform Cleaning
24.48
Uniform Cleaning
17.80
Uniform Cleaning
24.48
Uniform Cleaning
15.58
Consery F /5, Inc.
Grounds Maintenance Supplies
698.80
EESCO, A Division of WESCO Distribution, Inc
Maintenance and repair supplies
286.93
Garvey's Office Products
Office Supplies
171.59
HBK Water Meter Service
Water Meter Installation /Building Inspection /Meter Testing
119.00
Water Meter Installation /Building Inspection /Meter Testing
119.00
Water Meter Installation /Building Inspection /Meter Testing
238.00
Water Meter Installation /Building Inspection /Meter Testing
119.00
Water Meter Installation /Building Inspection /Meter Testing
1,355.60
Water Meter Installation /Building Inspection /Meter Testing
775.40
Highway Technologies, Inc.
Traffic Control
1,000.00
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
655.41
Illinois Department of Revenue
IL State Withholding
2,783.38
IMRF
IMRF
8,004.90
Internal Revenue Service
Federal Withholding
17,018.66
International Union of Operating Engineers
IUOE PW Membership Dues
339.34
Jjs Global Ventures Inc
Equipment Repair
90.56
L & B Business Services Inc.
Maintenance and repair supplies
287.82
Mount Prospect Paint, Inc.
Hydrant Painting Supplies
124.14
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
189.00
Neenah Foundry Company
Manhole Frame Supplies
6,675.00
Nextel Communications
Service 5/18/11- 6/17/11
690.67
None
Refund Final Utility Bill Acctft1578101
102.10
Northeastern Ill. Pub. Safety Trng.
Training
75.00
Northwest Suburban United Way
United Way
14.27
Stephen A. Laser Assoc.,p.c.
Employment testing
6,100.00
Employment testing
2,050.00
Suburban Laboratories, Inc.
Annual IEPA - Required Water Sample Testing
104.50
Annual IEPA- Required Water Sample Testing
332.75
Page 5 of 8
VILLAGE OF MOUNT PROSPECT
List of Bills
June 30 - July 13, 2011
Fund Vendor Name
Invoice Description
Amount
Third Millennium Assoc.inc.
June 2011 Utility Billing
1,260.11
U.S. Bancorp Equipment Finance, Inc.
7/20/11 Usage
137.50
United States Postal Service
CAPS postage -June
2,455.50
Village of Mount Prospect
Flex - Parking
462.37
Walker Engineering, Inc
Maintenance and repair supplies
461.94
050 Water and Sewer Fund Total
$
56,986.50
051 Village Parking System Fund
Brink, Holger & Danielle
Refund 1/2 Year Space 1 in Wille Street Lot
$
180.00
Crystal Maintenance Services Corp.
Custodial Services
2,015.86
Illinois Department of Revenue
IL State Withholding
31.61
IMRF
IMRF
96.21
Internal Revenue Service
Federal Withholding
203.57
International Union of Operating Engineers
IUOE PW Membership Dues
619
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
8.89
Village of Mount Prospect
Flex - Parking
14.79
051 Village Parking System Fund Total
$
2,557.22
052 Parking System Revenue Fund
American Landscaping Inc.
Shrub Planting
$
632.35
Commonwealth Edison
Electrical Service Delivery
399.24
Electrical Service Delivery
131.94
Crystal Maintenance Services Corp.
Custodial Services
290.52
Illinois Department of Revenue
IL State Withholding
55.03
IMRF
IMRF
201.61
Internal Revenue Service
Federal Withholding
285.00
International Union of Operating Engineers
IUOE PW Membership Dues
4.21
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
5.94
Village of Mount Prospect
Flex - Parking
64.06
052 Parking system Revenue Fund Total
$
2,069.90
060 Vehicle Maintenance Fund
ACS State & Local Government Solutions
Illinois State Disbursement Unit
$
297.17
Allstar Auto Glass
Equipment Maintenance
269.89
American Messaging
Pager rental
81.56
Arlington Heights Ford
317 fuel injector & O -ring kit
132.27
Vehicle Maintenance Supplies
82
Vehicle Maintenance Supplies
35.78
Vehicle Maintenance Supplies
115.78
AT & T
Service 6/16/11- 7/15/11
10.40
Barnes Group
Drill bits, tire valve stems and fittings
145.72
Catching Fluidpower
Vehicle Maintenance Supplies
60.45
Chicago International Truck
Equipment Maintenance
3,858.77
-
Vehicle Maintenance Supplies
20.80
Vehicle Maintenance Supplies
30.99
Credit for overcharged invoice
(50.00)
Equipment Depot of Illinois
Vehicle Maintenance Supplies
151.23
Foster Coach Sales Inc.
Vehicle Maintenance Supplies
37.66
Global Emergency Products
518 factory OEM air compressor
448
530 roll -up door seal
94.75
530 switch for right rear gortite door
114.16
Grainger Inc.
Vehicle Maintenance Supplies
12.12
Vehicle Maintenance Supplies
55.62
Hoskins Chevrolet, Inc.
P -5 rear door latch
244.65
Vehicle Maintenance Supplies
6.14
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
460.28
Illinois Department of Revenue
IL State Withholding
1,409.75
IMRF
IMRF
4,313.30
Internal Revenue Service
Federal Withholding
8,545.15
International Union of Operating Engineers
IUOE PW Membership Dues
198.99
Interstate Battery
Vehicle Maintenance Supplies
586.70
Just Tires
Vehicle Maintenance Supplies
812,00
Lund Industries, Inc.
Vehicle Maintenance Supplies
185.60
Morton Grove Automotive
Equipment Maintenance
175.00
4509 alternator
185.00
Napa - Heights Automotive Supply
Credit for wrong grease
(25.74)
4539 power steering pump and belt
126.47
P -5 rear hatch lift arms
37
Credit
(100.60)
Vehicle drying towels /chamois
56.69
Squad headlight bulbs
127.68
Vehicle Maintenance Supplies
44
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
146.24
Nextel Communications
Service 5/18/11- 6/17/11
242.41
Northwest Suburban United Way
United Way
5
Page 6 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
June 30 - July 13, 2011
Fund Vendor Name
Invoice Description
Amount
Petty Cash
Petty Cash 2011
8.02
Pomp's Tire Service, Inc.
Vehicle Maintenance Supplies
85.16
Prairie International Truck Sales
Int truck air filters and oil pan bars
310.38
Precision Service & Parts
Squad A/C accumulators
162.96
Vehicle Maintenance Supplies
39.11
A/C condensor for squads
221.36
302 brake light switch and wiring
45.78
Vehicle Maintenance Supplies
652.80
GM coolant
111.60
Vehicle Maintenance Supplies
14.38
P -10 blower motor
41.12
Pro Finish
Vehicle Maintenance Supplies
484.00
Vehicle Maintenance Supplies
192.00
Sauber Mfg. Co.
Vehicle Maintenance Supplies
58.78
Spring Align of Palatine, Inc.
Equipment Maintenance
2,123.26
Standard Industrial Auto Equip
Oil Pump Replacement
248.00
Triangle Radiator Service Inc
Equipment Maintenance
135.00
Vehicle Maintenance Supplies
189.00
Village of Mount Prospect
Flex - Parking
313.44
West Side Tractor Sales
Vehicle Maintenance Supplies
253.05
Wholesale Direct Inc.
Vehicle Maintenance Supplies
350.06
Vehicle Maintenance Supplies
135.12
Wickstrom Ford Lincoln Mercury
Equipment Maintenance
3,661.05
Vehicle Maintenance Supplies
27.56
Wisconsin Air Filter Co., Inc.
Equipment Maintenance
150.00
060 Vehicle Maintenance Fund Total
$
33,802.43
061 Vehicle Replacement Fund
Finishmaster, Inc.
New Vehicles
$
4,683.28
New Vehicles
1,135.60
New Vehicles
379.32
MPC Communications & Lighting
Replace Fire Dept. Vehicles
1,999.30
Napa- Heights Automotive Supply
New tow truck 2712 front bumper winch
2,434.65
New truck 2712 winch freight
46.50
Northwest Electrical Supply
New Vehicles
7.60
Terrace Supply Company
New Vehicles
40.82
061 Vehicle Replacement Fund Total
$
10,727.07
062 Computer Replacement Fund
CDW Government, Inc.
Replacement printer for MJohnson
$
909.99
062 Computer Replacement Fund Total
$
909.99
063 Risk Management Fund
Electrical Resource Management, Inc.
Streetlight Knockdown
$
984.00
Streetlight Knockdown Report 11 -02167
984.00
Intergovernmental Per.ben.coop
IPBC - July 2011
517,572.52
063 Risk Management Fund Total
$
519,540.52
070 Police Pension Fund
Becker, Burke Associates Inc
Consulting Services 7/1/2011- 9/30/11
$
9,000.00
070 Police Pension Fund Total
$
9,000.00
071 Fire Pension Fund
Becker, Burke Associates Inc
Consulting Services 7/1/2011- 9/30/11
$
9,000.00
071 Fire Pension Fund Total
$
9,000
073 Escrow Deposit Fund
Casto Lifestyle Properties
Refund Escrow Permit # 10 -2858
$
500.00
Cravents, Robert
Refund Escrow Permit # 11 -0463
125.00
First American Title Insurance Company
Refund Overpayment Real Estate Transfer Stamp
3.00
Gaynor, Timothy
Refund Escrow Permit # 09 -1781
450.00
Izvor, Alina
Refund Escrow Permit # 11 -0294
375.00
JNL Climate Control, Inc
Refund Escrow Permit # 11 -0929
125.00
Krueger's Concrete & Excavating
Refund Escrow Permit # 11 -0702
200.00
Mario Gambino & Sons Landscaping
Refund Escrow Permit # 11 -0739
200.00
McGarry, Michael / Linda
Refund Escrow Permit # 10 -1098
100.00
NCPERS Group Life Ins.
Premium for July 2011
688.00
Premium for July 2011
16.00
Paps Cafe
Refund Escrow Permit # 11 -0112
25.00
Perfect Temperature Control Inc
Refund Escrow Permit # 11 -0680
125.00
Rainbow Hospice & Palliative Care
Refund Escrow Permit # 11 -0746
125.00
Rick's Sewer & Drainage
Refund Escrow Permit # 11 -0767
125.00
Russel 1 Lokun Landscape
Refund Escrow Permit # 11 -0955
200.00
Sign A Rama
Refund Escrow Permit # 11 -0807
125.00
Steinbach, Frederick
Refund Escrow Permit # 11 -0735
200.00
Page 7 of 8
VILLAGE OF MOUNT PROSPECT
List of Bills
June 30 - July 13, 2011
Fund Vendor Name
Invoice Description
Amount
Third District Circuit Court
Bond Check 6/30/11
570.00
Bond Check 7/5/11
1,262.00
Bond Check 7/7/11
1,540.00
Bond Check 7/12/11
1,470.00
Thompson, Curtis
Refund Escrow Permit # 11 -0272
125.00
Weinberg, Kelli
Refund Escrow Permit # 11 -0291
125.00
William Horvath Carpentry Inc
Refund Escrow Permit # 30 -2905
300.00
YS Health
Refund Escrow Permit # 11 -0925
200.00
073 Escrow Deposit Fund Total
y,Zyy.uo
Grand Total
$ 1,580,606.63