HomeMy WebLinkAbout3. Financial Report 04/03/2012Village of Mount Prospect
Mount Prospect, Illinois
INTEROFFICE MEMORANDUM
TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES
FINANCE COMMISSION
FROM: FINANCE DIRECTOR
DATE: MARCH 19, 2012
SUBJECT: MONTHLY FINANCIAL REPORT — FEBRUARY 2012
Attached hereto are the cash position and investment statements of the Village for the month
ended February 29, 2012. These statements provide a snapshot of the Village's cash position
as of the month end date noted and are intended to supplement the budget revenue and
expenditure summary and listing of bills you receive. The first statement presents the Village's
cash position broken down by governmental and enterprise funds and trust and agency funds.
The second statement presents the Village's cash position by fund type. The third statement
presents the list of investments again broken down by governmental and enterprise funds and
trust and agency funds. It is important to note that although we have included the trust and
agency funds in the cash position report, these funds are not accessible for Village operations.
They are restricted for pension and escrow funding only. Please read the summary that follows
for further detail on the cash position of the Village.
Cash and Investment Position Report — All Funds (page 1)
This report provides a detail summary of cash and investments for the Village broken out by
governmental and enterprise funds and trust and agency funds. Governmental funds include
the General Fund, Special Revenue Funds, Debt Service Funds, Capital Project Funds and
Internal Service Funds. The Enterprise Funds consist of the Water /Sewer Fund and two (2)
Parking Funds.
Trust funds include the Village's two public safety pensions (Police and Firefighters') while the
agency funds include the Escrow Deposit, Flexcomp Escrow, Special Service Area and Library
Bonds Escrow Funds. The Escrow Deposit Fund accounts for refundable deposits held by the
Village to ensure completion of public improvements. The Flexcomp Escrow Fund accounts for
employee payroll deductions pursuant to a Section 125 flexible compensation plan. The Special
Service Area Fund and Library Bonds Escrow Fund accounts for the accumulation of monies for
debt service payments.
Governmental and Enterprise Funds - Cash and cash equivalents at January 31 were $23.6
million. During February, cash receipts totaled $6,063,038.06. In addition investment income for
the month was $2,050.31. Reductions in cash and cash equivalents during February totaled
$4,899,341.31. Of this amount, payments to vendors were $3,546,073.87, employee payroll
and related expenses were $1,350,166.06 and other disbursements totaled $3,101.39. There
was also a net increase in cash due to interfund activity of $39,080.56. Cash and cash
equivalents at February 29 were $24.9 million.
Monthly Financial Report — February 2012
March 19, 2012
Page 2
There were no funds held in investments during the month of February. 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 January 31 were
$23,647,433.62. Cash and investments at February 29 totaled $24,852,261.24. This is an
increase of $1,204,827.62.
Trust and Agency Funds - Cash and cash equivalents at January 31 were $7.2 million. During
February, cash receipts totaled $854,855.36. Investment income for the month was
$228,446.14. There was also a net increase in cash due to investment activities of
$766,538.75. Reductions in cash and cash equivalents during February totaled $665,264.07.
Of this amount, payments to vendors were $121,573.80, employee payroll related expenses
were $500,299.78 and payments related to the flexible spending program totaled $43,221.24.
Other expenses totaled $169.25. There was also a net decrease in cash due to interfund
activity of $39,080.56. Cash and cash equivalents at February 29 were $8.4 million.
Total investments at February 29 were $81.298,112.98, a decrease of $953,096.33 from
January 31. There were unrealized investment losses of $186,557.58 and a transfer to cash of
$766,538.75 that accounted for the change.
Total cash and investments for Trust and Agency Funds at January 31 were $89,496,287.32.
Cash and investments at February 29 totaled $89,688,686.61. This is an increase for the month
of $192,399.29.
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 January 31 totaled $5,427,334.89. During
February, cash receipts totaled $3,427,446.63 and investment income was $1,614.98.
Significant cash receipts included sales and income taxes, and telecommunication taxes.
The initial receipts of the first installment of 2011 Property taxes were seen during
February. A total of $1,592,523 was received in the General Fund during the month. This
represents roughly 13.5% of the total budget. For comparison, the Village did not begin
receiving the 2010 first installment property tax until March.
Sales tax revenues for the month totaled $1,011,611. Of this amount, $907,301 was
generated from the 1% state portion while $104,310 was generated from the .25% home
rule portion. Sales taxes received in February are for November sales as there is a normal
three -month lag in getting this distribution from the state.
H xACCT1Treasurer's Repo t\20121Monthly Cash Position Report - February 2012.docx
Monthly Financial Report — February 2012
March 19, 2012
Page 3
Vehicle Stickers went on sale February 7 for the 2012 -2013 license period. Total receipts
for February were $267,752. The total budget for this line item is $1,405,000. We are at
19.1 % of the total budget. A majority of the sticker sales will occur in March and April with
the April 30 deadline required.
Disbursements from the General Fund for February included payments to vendors of
$1,168,042.81 and payments for employee wages and benefits of $1,178,073.53. Other
disbursements totaled $3,411.97.
Cash and cash equivalents at February 29 were $6,004,648.6. There were no investments in
the General Fund at February 29.
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 February 29 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,
Galliard, Segall Bryant and Mesirow Financial. Segall Bryant holds approximately half of the
fixed income investments for the two pension funds while Galliard 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.
HAACURTreasurer's Report\2012\Monthly Cash Position Report - February 2012.docx
Monthly Financial Report — February 2012
March 19, 2012
Page 4
Maturity Purchase Financial Investment
Date Date Institution Description
POLICE PENSION FUND (070)
Various Various Wells Fargo
Various Various Various
Wells Fargo Investments
Mutual Fund Investments
FIRE PENSION FUND (071)
Various Various Wells Fargo
Various Various Various
Wells Fargo Investments
Mutual Fund Investments
TOTAL TRUST AND AGENCY FUND INVESTMENTS
CUSIP/
Interest
Market
Acct #
Rate %
Value
Various
Various
22,154,917.66
Various
Various
19,594,330.50
41,749,248.16
Various Various 19,507,868.98
Various Various 20,040,995.84
39,548,864.82
$ 81,298,112.98
investment of the Village's pension funds is governed by an Investment Policy adopted by each
Pension Board.
Conclusion
As mentioned earlier, this cash position report is intended to provide a snapshot of the Village's
cash position as of a particular month end date. Over time, this report will be able to provide
trend information to help in cash management duties, maximizing investment earnings while
ensuring availability of funds to meet the Village's commitments. The cash position report will
continue to be provided to the Village Board and Finance Commission on a monthly basis.
David O. Erb
Finance Director
HAACC RTreasurer's Report\20121Monthly Cash Position Report - February 2012.docx
VILLAGE OF MOUNT PROSPECT
Preliminary Cash and Investment Position Report - All Funds
For the Month Ended February 29, 2012
GOVERNMENTAL AND EN TERPRISE FUNDS
Balance at January 31, 2012
Cash receipts
Investment income
Transfers from investments to cash
Transfers to investments from cash
Interfund activity
Disbursements:
Accounts payable
Payroll
Other
Balance at February 29, 2012
Cash and Cash
Equivalents Investments
$ 23,647,433.62 $ -
6,063,038.06
2,050.31
39,080.56
(3,546,073.87)
(1,350,166.05)
(3,101.39)
Total Cash and
Investments
$ 23,647,433.62
6,063,038.06
2,050.31
39,080.56
(3,546,073.87)
(1,350,166.05)
(3,101.39)
$ 24,852,261.24 $ - $ 24,852,261.24
TRUST AND AGENCY FUNDS *
Disbursements:
Accounts payable (121,573.80) (121,573.80)
Payroll (500,299.78) (500,299.78)
Flex spending (43,221.24) (43,221.24)
Other (169.25) (169.25)
Balance at February 29, 2012 $ 8,390,573.63 $ 81,298,112.98 $ 89,688,686.61
* Assets are restricted in purpose and do not represent discretionary assets of the government.
1
Cash and Cash
Total Cash and
Equivalents
Investments
Investments
Balance at January 31, 2012
$ 7,245,078.01
$ 82,251,209.31
$ 89,496,287.32
Cash receipts
854,855.36
854,855.36
Investment income (loss)
228,446.14
(186,557.58)
41,888.56
Transfers from investments to cash
4,019,052.40
(4,019,052.40)
-
Transfers to investments from cash
(3,252,513.65)
3,252,513.65
-
Interfund activity
(39,080.56)
(39,080.56)
Disbursements:
Accounts payable (121,573.80) (121,573.80)
Payroll (500,299.78) (500,299.78)
Flex spending (43,221.24) (43,221.24)
Other (169.25) (169.25)
Balance at February 29, 2012 $ 8,390,573.63 $ 81,298,112.98 $ 89,688,686.61
* Assets are restricted in purpose and do not represent discretionary assets of the government.
1
N VILLAGE OF MOUNT PROSPECT
Summary of Cash Activity by Fund Type
For the Month Ended February 29, 2012
GOVERN AND ENTERPRISE FUNDS TRUST AND AGENCY FUNDS'
INVESTMENTS
Certificates of deposit -
Wells Fargo investments - 41,662,786.64 41,662,786.64
Mutual fund investments - 39,635,326.34 - 39,635,326.34
Total investments - _ - - - 81,298,112.98 - 81,298,112.98
TOTAL CASH AND INVESTMENTS $ 6,004,648.60 $ 2,420,842.30 $ 272,910.98 $ 3,767,979.61 $ 2,613,024.14 $ 9 ,772,855.61 $ 24,852,261.24 $ 88,415,806.00 $ 1,272,880.61 $114,540,947.85
Assets are restricted in purpose and do not represent discretionary assets of the government.
SPECIAL
CAPITAL
TOTAL GOVT.
FIRE AND
OTHER TRUST
REVENUE
DEBT SERVICE
PROJECTS
ENTERPRISE
INTERNAL
AND ENTERPRISE
POLICE
AND AGENCY
GENERAL FUND
FUNDS
FUNDS
FUNDS
FUNDS
SERVICE FUNDS
FUNDS
PENSIONS
FUNDS
TOTAL
CASH &CASH EQUIVALENTS
Beginning balance
$ 5,427,334.89
$ 2,671,521.63
$ (21,899.00)
$ 3,312,625.29
$ 2,463,481.81
$ 9,794,369.00
$ 23,647,433.62
$ 5,946,101.36
$ 1,298,976.65
$ 30,892,511.63
Cash receipts
3,427,446.63
405,134.37
295,537.98
851,804.85
937,915.25
145,198.98
6,063,038.06
796,394.03
58,461.33
6,917,893.42
Investment income
1,614.98
0.82
-
-
1.96
432.55
2,050.31
228,338.19
107.95
230,496.45
Transfers from investments
-
-
-
-
-
4,019,052.40
-
4,019,052.40
Transfers to investments
-
-
-
(3,252,513.65)
(3,252,513.65)
Interfund
(502,219.59)
7,989.16
-
-
(163,317.22)
696,628.21
39,080.56
(34,250.73)
(4,829.83)
(0.00)
Disbursements - other
(3,411.97)
-
310.58
(3,101.39)
-
(169.25)
(3,270.64)
Disbursements - flexible spending
-
-
-
-
(43,221.24)
(43,221.24)
Disbursements - payroll
(1,178,073.53)
(15,378.82)
(103,263.32)
(53,450.38)
(1,350,166.05)
(500,299.78)
(1,850,465.83)
Disbursements - accounts payable
(1,168,042.81)
_ (648,424.86)
(728.00)
(396,450.53)
(521,794.34)
_ (810,633.33)
(3,546,073.87)
(85,128.80)
(36,445.00)
(3,667,647.67)
Ending balance
6,004,648.60
_ 2,420,842.30
272,910.98
3,767,979.61
2,613,024.14
&i ,772,855.61
24,852,261.24
7,117,693.02
1,272,880.61
33,242,834.87
INVESTMENTS
Certificates of deposit -
Wells Fargo investments - 41,662,786.64 41,662,786.64
Mutual fund investments - 39,635,326.34 - 39,635,326.34
Total investments - _ - - - 81,298,112.98 - 81,298,112.98
TOTAL CASH AND INVESTMENTS $ 6,004,648.60 $ 2,420,842.30 $ 272,910.98 $ 3,767,979.61 $ 2,613,024.14 $ 9 ,772,855.61 $ 24,852,261.24 $ 88,415,806.00 $ 1,272,880.61 $114,540,947.85
Assets are restricted in purpose and do not represent discretionary assets of the government.
VILLAGE OF MOUNT PROSPECT
STATEMENT OF INVESTMENTS
As of February 29, 2012
GOVERNMENTAL AND ENTERPRISE FUNDS
Maturity Purchase Financial Investment CUSIP/ Interest Market Weighted
Date Date Institution Description Acct # Rate % Value Avg Yield
As of February 29, 2012, there were no certificates of deposit held by the Governmental and Enterprise Funds.
TRUST AND AGENCY FUNDS *
Maturity Purchase Financial
Investment
CUSIP/
Interest
Market Weighted
Date Date Institution
Description
Acct #
Rate %
Value Avg Yield
POLICE PENSION FUND (070)
Various Various Wells Fargo
Wells Fargo Investments
Various
Various
22,154,917.66
Various Various Various
Mutual Fund Investments
Various
Various
19,594,330.50
41,749,248.16
FIRE PENSION FUND (071)
Various Various Wells Fargo
Wells Fargo Investments
Various
Various
19,507,868.98
Various Various Various
Mutual Fund Investments
Various
Various
20,040,995.84
39,548,864.82
TOTAL TRUST AND AGENCY FUND INVESTMENTS
$81,298,112.98
* Assets are restricted in purpose and do not represent discretionary assets of the government.
3
VILLAGE OF MOUNT PROSPECT
BUDGET REVENUE
EXPENDITURE SUMMARIES
February 01— February 29, 2012
Account Classification
Revenue Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 001- General Fund
REVENUE
Property Taxes
12,206,500.00
.00
12,206,500.00
1,592,522.93
.00
1,592,522.93
10,613,977.07
13
136,165.54
Other Taxes
7,603,000.00
.00
7,603,000.00
205,721.72
.00
305,502.61
7,297,497.39
4
733,154.03
Licenses, Permits & Fees
2,495,000.00
.00
2,495,000.00
450,175.00
.00
514,753.56
1,980,246.44
21
390,896.76
Intergovernmental Revenue
16,731,619.00
.00
16,731,619.00
64,380.57
.00
116,870.44
16,614,748.56
1
87,523.34
Charges For Services
1,518,125.00
.00
1,518,125.00
100,578.38
.00
156,178.93
1,361,946.07
10
241,441.61
Fines & Forfeits
507,000.00
.00
507,000.00
15,905.00
.00
37,209.56
469,790.44
7
64,342.49
Investment Income
25,000.00
.00
25,000.00
1,719.81
.00
3,582.03
21,417.97
14
6,025.84
Reimbursements
169,500.00
.00
169,500.00
13,972.28
.00
26,654.74
142,845.26
16
20,659.53
Other Revenue
290,738.00
.00
290,738.00
42,260.68
.00
103,380.10
187,357.90
36
68,082.41
Other Financing Sources
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
REVENUE TOTALS $ 41,547,482.00
$0.00
$41,547,482.00
$2,487,236.37
$0.00
$2,856,654.90
$38,690,827.10
7%
$1,748,291.55
Fund 001- General Fund Totals $41,547,482.00
$0.00
$41,547,482.00
$2,487,236.37
$0.00
$2,856,654.90
$38,690,827.10
$1,748,291.55
r
M
Revenue Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
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 002 - Debt Service Fund
REVENUE
Property Taxes
1,749,000.00
.00
1,749,000.00
224,456.40
.00
224,456.40
1,524,543.60
13
23,078.94
Other Taxes
613,354.00
.00
613,354.00
.00
.00
.00
613,354.00
0
.00
Intergovernmental Revenue
47,258.00
.00
47,258.00
.00
.00
.00
47,258.00
0
OA
Investment Income
600.00
.00
600.00
.00
.00
.00
600.00
0
.00
Other Financing Sources
.00
.00
.00
.00
.00
8,210.00
(8,210.00)
+ ++
.00
REVENUE TOTALS
$2,410,212.00
$0.00
$2,410,212.00
$224,456.40
$0.00
$232,666.40
$2,177,545.60
10%
$23,076.94
Fund 002 - Debt Service Fund Totals
$2,410,212.00
$0.00
$2,410,212.00
$224,456.40
$0.00
$232,666.40
$2,177,545.60
$23,078.94
Revenue Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Fund 020 - Capital Improvement Fund
REVENUE
Other Taxes
1,115,000.00
.00
1,115,000.00
.00
.00
.00
1,115,000.00
0
.00
Intergovernmental Revenue
.00
.00
.00
.00
.00
.00
.00
+ ++
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
15,000.00
.00
15,000.00
.00
.00
.00
15,000.00
0
.00
Other Financing Sources
937,000.00
.00
937,000.00
.00
.00
.00
937,000.00
0
.00
REVENUE TOTALS
$2,068,000.00
$0.00
$2,068,000.00
$0.00
$0.00
$0.00
$2,068,000.00
0%
$0.00
Fund 020 - Capital Improvement Fund Totals
$2,068,000.00
$0.00
$2,068,000.00
$0.00
$0.00
$0.00
$2,068,000.00
$0.00
w
0.
Revenue Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Recd
Prior Year YTD
Fund 021- Series 2009 Construction Fund
REVENUE
Intergovernmental Revenue
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Investment Income
.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
+ +
.00
REVENUE TOTALS
$0.00
$0.00
$0.00
$0.00
$0.
$ 0.00
$
...
$ 0.00
Fund 021 - Series 2009 Construction Fund Totals
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Revenue Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
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 022 - Downtown Redevelopment Construct
REVENUE
2,604,000.00
.00
2,604,000.00
460,213.23
.00
460,213.23
2,143,786.77
18
51,554.80
Property Taxes
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
Investment Income
.00
.00
.00
.00
.00
.00
...
.00
Reimbursements
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Revenue
.00
.00
.00
.00
.00
.00
.00
...
.00
Other Financing Sources
REVENUE TOTALS
.00
$2,605,000.00
$0.00
$2,605,000.00
$460,213.23
$0.00
$460,213.23
$2,144,786.77
18%
$51,554.80
Fund 022 -Downtown Redevelopment Construct Totals
$2,605,000.00
$0.00
$2,605,000.00
$460,213.23
$0.00
$460,213.23
$2,144,786.77
$51,554.80
cn
all
Revenue Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - Yl'D % used/
Account Classiflcatlon
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund 023 - Street Improvement Construc Fund
REVENUE
Other Taxes
1,550,000.00
.00
1,550,000.00
25,323.17
.00
25,323.17
1,524,676.83
2
55,036.28
Licenses, Permits & Fees
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Intergovernmental Revenue
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Investment Income
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
Reimbursements
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Revenue
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00
0
.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
...
.00
REVENUE TOTALS
$1,555,500.00
$0.00
$1,555,500.00
$25,323.17
$
$
$ 1,530,176.83
2%
$55,036.28
Fund 023 - Street Improvement: Construc Fund Totals
$1,555,500.00
$0.00
$1,555,500.00
$25,323.17
$0.00
$25,323.17
$1,530,176.83
$55,036.28
Revenue Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD °/a used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Fund 024 - Flood Control Construction Fund
REVENUE
Other Taxes
601,646.00
.00
601,646.00
.00
.00
.00
601,646.00
0
.00
Intergovernmental Revenue
.00
.00
.00
.00
.00
.00
.00
...
.00
Charges For Services
7,500.00
.00
7,500.00
.00
.00
.00
7,500.00
0
571.00
Investment Income
.00
.00
.00
.00
.00
.00
.00
...
.00
Reimbursements
56,500.00
.00
56,500.00
.00
.00
56,521.31
(21.31)
100
.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
REVENUE TOTALS
$665,646.00
$0.00
$665,646.00
$0.00
$0.00
$56,521.31
$609,124.69
8%
$571.00
Fund 024 - Flood Control Construction Fund Totals
$665,646.00
$0.00
$665,646.00
$0.00
$0.00
$56,521.31
$609,124.69
$571.00
v
Revenue Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
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 040 - Refuse Disposal Fund
REVENUE
Property Taxes
1,807,,000.00
.00
1,807,000.00
231,547.48
.00
231,547,48
1,575,452.52
13
23,024,54
Charges For Services
2,258,,000.00
.00
2,258,000.00
257,566.53
.00
312,136,94
1,945,863.06
14
362,984.64
Fines & Forfeits
21,500.00
.00
21,500.00
3,276.51
.00
6,162.99
15,337.01
29
4,652.48
Investment Income
1 000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
Other Revenue
381,,650.00
.00
381,650.00
12,423.98
.00
12,448.98
369,201,02
3
11.25
REVENUE TOTALS
$4,469,,150.00
$0.00
$4,469,150.00
$504,814.50
$0.
$ 562,2 9 6.39
$3,906,853.61
13%
$390,672.91
Fund 040 - Refuse Disposal Fund Totals
$4,469
$0.00
$4,469,150.00
$504,814.50
$0.00
$562,296.39
$3,906,853.61
$390,672.91
Revenue Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
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,690,000.00
.00
1,690,000.00
109,555.84
.00
109,555.84
1,580,444.16
6 131,087.77
Investment Income
500.00
.00
500.00
.00
.00
.00
500.00
0 .00
Reimbursements
20,500.00
.00
20,500.00
.00
.00
4,932.51
15,567.49
24 4,959.51
REVENUE TOTALS
$1,711,000.00
$0.00
$1,711,000.00
$109,555.84
$0.00
$114,488.35
$1,596,511.65
7% $136,047.28
Fund 041 - Motor Fuel Tax Fund Totals
$1,711,000.00
$0.00
$1,711,000.00
$109,555.84
$0.00
$114,488.35
$1,596,511.65
$136,047.28
w
0
Revenue Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YfD YfD Budget - YfD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund 042 - Cmmty Development Block Grant
REVENUE
Intergovernmental Revenue
353,543.00
.00
353,543.00
.00
.00
.00
353,543.00
0
.00
Investment Income
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Revenue
60,000.00
.00
60,000.00
.00
.00
.00
60,000.0
0
22,20
REVENUE TOTALS
$413,543.00
$0.00
$413,543.00
$0.00
$0.
$0.0
$
0%
$ 2 2, 206.50
Fund 042 - Cmmty Development Block Grant Totals
$413,543.00
$0.00
$413,543.00
$0.00
$0.00
$0.00
$413,543.00
$22,206.50
Revenue Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
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 043 - Asset Seizure Fund
REVENUE
Fines & Forfeits
3
.00
3,000.00
.00
.00
.00
3,000.00 0
453.76
Investment Income
500.00
.00
500.00
.00
.00
.00
500.00 0
.00
REVENUE TOTALS
$3,500.00
$0.00
$3,500.00
$0.00
$0.00
$0.00
$3,500.00 0%
$453.76
Fund 043 - Asset Seizure Fund Totals
$3,500.00
$0.00
$3,500.00
$0.00
$0.00
$0.00
$3,500.00
$453.76
r
r
r
N
Revenue Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
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
2,500.00
.00
2,500.00
.00
.00
.00
2,500.00
0
.00
Investment Income
500.00
.00
500.00
.82
.00
1.72
498.28
0
9.46
REVENUE TOTALS
$3,000.00
$0.00
$3,000.00
$0.82
$0.
$1.72
$2, 998.28
0
0
$9,46
Fund 044 - DEA Sheared Funds Fund Totals
$3,000.00
$0.00
$3,000.00
$0.82
$0.00
$1.72
$2,998.28
$9.46
Revenue Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
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 045 - DUI Fine Fund
REVENUE
Fines & Forfeits
9,000.00
.00
9,000.00
.00
.00
.00
9,000.00 0
963.79
Investment Income
500.00
.0 0
500.00
.00
.00
.00
500.00 0
.00
REVENUE TOTALS
$9,500.00
$ 0. 0 0
$9,500.00
$0.00
$0.00
$0.00
$9,500.00 0%
$963.79
Fund 045 - DUI Fine Fund Totals
$9,500.00
$0.00
$9,500.00
$0.00
$0.00
$0.00
$9,500.00
$963.79
r
w
r
Revenue Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
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 046 - Foreign Fire Tax Board Fund
REVENUE
Other Taxes
55,000.00
.00
55,000.00
.00
.00
.00
55,000.00
0
.00
Investment Income
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
+ ++
.
REVENUE TOTALS
$55,,500.00
$0.00
$55,500.00
$0.00
$0.00
$0.00
$55,500.00
0%
$0.00
Fund 046 - Foreign Fire Tax Board Fund Totals
$55,,500.00
$0.00
$55,500.00
$0.00
$0.00
$0.00
$55,500.00
$0.00
Revenue Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classificatlon Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prlor Year YTD
Fund 048 - Business District Fund
REVENUE
Other Taxes .00 .00 .0 0 9,105.25 .00 9,105.25 (9,105.25) + ++ .00
REVENUE TOTALS $0.00 $ 0.00 $0.00 $9,105.25 $0.00 $9,105.25 ($9,105.25) + ++ $0.00
Fund 048 - Business District Fund Totals $0.00 $0.00 $0.00 $9,105.25 $0.00 $9,105.25 ($9,105.25) $0.00
r
N
r
0)
Revenue Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
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 050 - Water and Sewer Fund
REVENUE
Property Taxes
1,516,,000.00
.00
1,516,000.00
203,049.80
.00
203,049.80
1,312,950.20
13
17,937.13
Licenses, Permits & Fees
15,000.00
.00
15,000.00
1,000.00
.00
1,550.00
13,450.00
10
2,910.00
Charges For Services
9,937,,000.00
.00
9,937,000.00
746,869.47
.00
1,450,951.28
8,486,048.72
15
1,407,664.56
Fines & Forfeits
120,000.00
.00
120,000.00
9,396.51
.00
17,891.32
102,108.68
15
21,161.15
Investment Income
3,000.00
.00
3,000.00
1.96
.00
4.05
2,995.95
0
4.88
Reimbursements
1,1000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
Other Revenue
35,,000.00
.00
35,000.00
.00
.00
324.05
34,675.95
1
23,085.52
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
++•+
00
REVENUE TOTALS
$11,627,,000.00
$0.00
$11,627,000.00
$960,317.74
$0.00
$1,673,770.50
$9,953,229.50
14%
$1,472,763.24
Fund 050 - Water and Sewer Fund Totals
$11,627,000.00
$0.00
$11,627,000.00
$960,317.74
$0.00
$1,673,770.50
$9,953,229.50
$1,472,763.24
Revenue Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Fund 051 - Village Parking System Fund
REVENUE
Other Taxes
45,000.00
.00
45,000.00
.00
.00
.00
45,000.00
0
.00
Charges For Services
105,000.00
.00
105,000.00
10,195.45
.00
25,063.05
79,936.95
24
18,309.95
Investment Income
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
Other Revenue
6,600.00
.00
6,600.00
.00
.00
.00
6,600.00
0
.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
REVENUE TOTALS
$157,100.00
$0.00
$157,100.00
$10,195.45
$0.00
$25,063.05
$132,036.95
16%
$18,309.95
Fund 051 - Village Parking System Fund Totals
$157,100.00
$0.00
$157,100.00
$10,195.45
$0.00
$25,063.05
$132,036.95
$18,309.95
F1
J
Revenue Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget- YTD % used/
Account Classlflcatlon
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
.00
.00
.00
55,000.00
0
.00
Intergovernmental Revenue
.00
.00
.00
.00
.00
.00
.00
...
.00
Charges For Services
108,,000.00
.00
108,000.00
10,524.35
.00
18,070.35
89,929.65
17
15,214.45
Investment Income
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
Other Revenue
,00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Financing Sources
.00
.00
.00
.00
.0
.
.00
+ ++
.
REVENUE TOTALS
$163,,500.00
$0.00
$163,500.00
$10,524.35
$0.00
$18,070.35
$145,429.65
11%
$15,214.
Fund 052 - Parking System Revenue Fund Totals
$163,,500.00
$0.00
$163,500.00
$10,524.35
$0.00
$18,070.35
$145,429.65
$15,214.45
Revenue Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
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
REVENUE
Charges For Services
2,010,205.00
.00
2,010,205.00
167,517.07
.00
335,034.14
1,675,170.86
17 317,133.68
Investment Income
500.00
.00
500.00
26.24
.00
54.14
445.86
11 64.25
Other Revenue
500.00
.00
500.00
797.96
.00
797.96
(297.96)
160 158.75
REVENUE TOTALS
$2,011,205.00
$0.00
$2,011,205.00
$168,341.27
$0.00
$335,886.24
$1,675,318.76
17% $317,356.68
Fund 060 - Vehicle Maintenance Fund Totals
$2,011,205.00
$0.00
$2,011,205.00
$168,341.27
$0.00
$335,886.24
$1,675,318.76
$317,356.68
r
kD
N
O
Revenue Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YfD YTD Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund 061 - Vehicle Replacement Fund
REVENUE
Charges For Services
1,183,.800.00
.00
1,183,800.00
98,649.99
.00
197,299.98
986,500.02
17
116,266.68
Flnes & Forfeits
24,000.00
.00
24,000.00
.00
.00
.00
24,000.00
0
.00
Investment Income
50,000.00
.00
10,000.00
262.16
.00
542.14
9,457.86
5
642.62
Other Revenue
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Financing Sources
50,000.00
.00
50,000.00
.00
.
. 00
5
0
1
REVENUE TOTALS
$1,267,800.00
$0.00
$1,267,800.00
$98,912.15
$0.00
$197,
$1, 069,957. 88
16%
$1 2 9, 859.30
Fund 061 - Vehicle Replacement Fund Totals
$1,267,.800.00
$0.00
$1,267,800.00
$98,912.15
$0.00
$197,842.12
$1,069,957.88
$129,859.30
Revenue Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Fund 062 - Computer Replacement Fund
REVENUE
Charges For Services
.00
.00
.00
.00
.00
.00
.00 + ++
38,653.50
Investment Income
1,000.00
.00
1,000.00
39.32
.00
81.34
918.66 8
96.42
REVENUE TOTALS
$1,000.00
$0.00
$1,000.00
$39.32
$0.00
$81.34
$918.66 8%
$38,749.92
Fund 062 -Computer Replacement Fund Totals
$1,000.00
$0.00
$1,000.00
$39.32
$0.00
$81.34
$918.66
$38,749.92
N
r
N
N
Revenue Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
rransactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund 063 - Risk Management Fund
REVENUE
Charges For Services
5,271,967.00
.00
5,271,967.00
494,710.77
.00
933,585.98
4,338,381.02
18
869,138.73
Investment Income
2,000.00
.00
2,000.00
104.83
.00
216.86
1,783.14
11
257.03
Reimbursements
6,000.00
.00
6,000.00
.00
.00
.00
6,000.00
0
.00
Other Revenue
1,160,392.00
.00
1,160,392.00
92,810.22
.00
179,546.40
9 80,845.60
1 5
14 8,96 8. 69
REVENUE TOTALS
$6,440,359.00
$0.00
$6,440,359.00
$587,625.82
$0.00
$1,113 ,
$5,327,009.7
17%
$1,
Fund 063 - Risk Management Fund Totals
$6,440,359.00
$0.00
$6,440,359.00
$587,625.82
$0.00
$1,113,349.24
$5,327,009.76
$1,018,364.45
Revenue Budget by Account Classification
Report
Account Classification
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Fund 070 - Police Pension Fund
REVENUE
Charges For Services
.00
.00
.00
.00
.00
.00
.00
... .00
Investment Income
2,622,500.00
.00
2,622,500.00
9,906.84
.00
230,629.17
2,391,870.83
9 37,532.22
Other Revenue
3,24
.00
3,244,500.00
395,096.30
.00
475,365.15
2,769,134.85
15 154,379.84
REVENUE TOTALS
$5,867,000.00
$0.00
$5,867,000.
$405,003.14
$0.00
$705,994.32
$5,161,005.68
12% $191,912.06
Fund 070 - Police Pension Fund Totals
$5,867,000.00
$0.00
$5,867,000.00
$405,003.14
$0.00
$705,994.32
$5,161,005.68
$191,912.06
N
W
N
�P
Revenue Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget rransactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 071 - Fire Pension Fund
REVENUE
Investment Income
2,531,000.00
.00
2,531,000.00
23,547.14
.00
209,195.14
2,321,804.86
8 6,327.19
Other Revenue
2,841,300.00
.00
2,841,300.00
334,956.51
.00
410,243.76
2,431,056.24
14 131,923.66
REVENUE TOTALS
$5,372,300.00
$0.00
$5,372,300.00
$35 8,503.65
$0.00
$619,438.90
$4,752,861.10
12% $138,250.85
Fund 071- Fire Pension Fund Totals
$5,372,300.00
$0.00
$5,372,300.00
$358,503.65
$0.00
$619,438.90
$4,752,861.10
$138,250.85
Grand Totals $90,424,297.00 $0.00 $90,424,297.00 $6,420,168.47 $0.00 $9,006,766.78 $81,417,530.22 $5,769,667.17
Expense Budget by Account Classification
Report
Account Classification
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Fund 001- General Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
22,938,376.00
(2,800.00)
22,935,576.00
1,625,995.48
.00
2,563,403.27
20,372,172.73
11
2,710,276.85
Employee Benefits
10,472,944.00
.00
10,472,944.00
1,181,056.47
.00
1,601,216.87
8,871,727.13
15
964,289.51
Other Employee Costs
379,154.00
866.00
380,020.00
18,686.40
7,777.17
47,835.86
324,406.97
15
44,854.70
Pension Benefits
46,005.00
.00
46,005.00
3,833.63
.00
7,667.26
38,337.74
17
7,643.60
Contractual Services
6,372,180.00
3,005.00
6,375,185.00
393,535.95
681,469.04
885,827.45
4,807,888.51
25
860,942.34
Utilities
263,151.00
.00
263,151.00
4,914.24
.00
9,900.17
253,250.83
4
7,123.35
Insurance
159,712.00
.00
159,712.00
13,332.60
.00
27,312.02
132,399.98
17
53,078.02
Commodities & Supplies
628,472.00
(1,071.00)
627,401.00
35,038.79
53,336.11
48,316.13
525,748.76
16
53,006.37
Other Expenditures
11,000.00
.00
11,000.00
.00
.00
.00
11,000.00
0
.00
Building Improvements
10,000.00
.00
10,000.00
1,168.00
1,119.65
1,168.00
7,712.35
23
.00
Office Equipment
51,612.00
.00
51,612.00
.00
.00
.00
51,612.00
0
.00
Other Equipment
140,493.00
.00
140,493.00
2,433.95
7,644.00
4,686.28
128,162.72
9
7,046.49
Distribution Systems
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Infrastructure
74,383.00
.00
74,383.00
.00
.00
440.00
73,943.00
1
.00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
...
00
EXPENSE TOTALS
$41,547,482.00
$0.00
$41,547,482.00
$3,279,995.51
$751,345.97
$5,197,773.31
$35,598,362.72
14%
$4,708,261.23
Fund 001- General Fund Totals
$41,547,482.00
$0.00
$41,547,482.00
$3,279,995.51
$751,345.97
$5,197,773.31
$35,598,362.72
$4,708,261.23
r
M
Expense Budget by Account Classification
Report
- Through 02/29/12
Prior Fiscal Year Activity Included
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 002 - Debt Service Fund
EXPENSE
Contractual Services
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Expenditures
.00
.00
.00
.00
.00
,00
.00
+ ++
.00
Bond Principal
1,479,,732.00
.00
1,479,732.00
.00
.00
18,377.95
1,461,354.05
1
.00
Interest Expense
928,,179.00
.00
928,179.00
.00
.00
1,266.47
926,912.53
0
.00
Bank & Fiscal Fees
1,,284.00
.00
1,284.00
428.00
,00
1,837.22
(553.22)
143
1,584.00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
+ ++
00
Other Financing Uses
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
EXPENSE TOTALS
$2,409,1
$0.00
$2,409,195.00
$428.00
$0.00
$21,481.64
$2,387,713.36
1%
$1,584.00
Fund 002 - Debt Service Fund Totals
$2,409,195.00
$0.00
$2,409,195.00
$428.00
$0.00
$21,481.64
$2,387,713.36
$1,584.00
Expense Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
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 020 - Capital Improvement Fund
EXPENSE
Contractual Services
218,000.00
.00
218,000.00
14,427.61
212,068.17
17,677.61
(11,745.78)
105
6,861.95
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Land Inprovements
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Building Improvements
387,500.00
.00
387,500.00
500.00
51,993.35
83,145.00
252,361.65
35
115.00
Office Equipment
.00
.00
.00
.00
.00
.00
.00
...
.00
Motor Equipment
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Equipment
1,210,500.00
.00
1,210,500.00
.00
.00
.00
1,210,500.00
0
.00
Infrastructure
360,000.00
.00
360,000.00
.00
118,927.44
.00
241,072.56
33
.00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
EXPENSE TOTALS
$2,176,000.00
$ 0.00
$2,176,000.00
$14,927.61
$382,988.96
$100,822.61
$1,692,188.43
22%
$6,976.95
Fund 020 - Capital Improvement Fund Totals
$2,176,000.00
$0.00
$2,176,000.00
$14,927.61
$382,988.96
$100,822.61
$1,692,188.43
$6,976.95
w
Expense Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
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
.00
.00
.00
.00
.00
.00
+ ++
00
Building Improvements
.00
.00
.00
.00
.00
.00
100
+ ++
.00
Office Equipment
.00
.00
.00
.00
.00
.00
,00
+ ++
00
Other Equipment
.00
.00
.00
.00
00
.00
.0
+ ++
747.00
EXPENSE TOTALS
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
+ ++
$ 747.00
Fund 021- Series 2009 Construction Fund Totals
$0.00
$0.00
$0,00
$0.00
$0.00
$0.00
$0.00
$747.00
Expense Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
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 022 - Downtown Redevelopment Construct
EXPENSE
Contractual Services
88,000.00
.00
88,000.00
.00
56,995.60
.00
31,004.40
65
.00
Utilities
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Expenditures
2,660,000.00
.00
2,660,000.00
7,000.00
.00
7,000.00
2,653,000.00
0
00
Infrastructure
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
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
$2,748,000.00
$0.00
$2,748,000.00
$7,000.00
$56,995.60
$7,000.00
$2,684,004.40
2%
$0.00
Fund 022 -Downtown Redevelopment Construct Totals
$2,748,000.00
$0.00
$2,748,000.00
$7,000.00
$56,995.60
$7,000.00
$2,684,004.40
$0.00
cn
R
Expense Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Fund 023 -Street Improvement Construc Fund
EXPENSE
Contractual Services
20,000.00
.00
20,000.00
.00
.00
.00
20,000.00 0
.00
Infrastructure
1,197,000.00
.00
1,197,000.00
.00
125,225.21
.00
1,071,774.79 10
35,004.58
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00 + ++
.00
EXPENSE TOTALS
$1,217,000.00
$0.00
$1,217,000.00
$0.00
$125,225.21
$0.00
$1,091,774.79 10%
$35,004.58
Fund 023 - Street Improvement Construc Fund Totals
$1,217,000.00
$0.00
$1,217,000.00
$0.00
$125,225.21
$0.00
$1,091,774.79
$35,004.58
Expense Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd 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
.00
Other Equipment
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Infrastructure
675,000.00
.00
675,000.00
252.52
.00
252.52
674,747.48
0
.00
EXPENSE TOTALS
$680,150.00
$0.00
$680,150.00
$252.52
$0.00
$252.52
$679,897.48
0%
$0.00
Fund 024 - Flood Control Construction Fund Totals
$680,150.00
$0.00
$680,150.00
$252.52
$0.00
$252.52
$679,897.48
$0.00
A
w
Expense Budget by Account Classification
Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 040 - Refuse Disposal Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
237,856.00
.00
237,856.00
19,033.58
.00
27,431.64
210,424.36
12
22,720.90
Employee Benefits
86,851.00
.00
86,851.00
6,789.49
.00
11,401.77
75,449.23
13
11,453.12
Other Employee Costs
1,200.00
.00
1,200.00
.00
.00
.00
1,200.00
0
.00
Contractual Services
4,022,673.00
.00
4,022,673.00
320,607.99
.00
515,889.65
3,506,783.35
13
446,491.50
Utilities
572.00
.00
572.00
16.25
.00
36.55
535.45
6
23.01
Insurance
27,331.00
.00
27,331.00
2,277.58
.00
4,555.16
22,775.84
17
4,195.84
Commodities & Supplies
33,737.00
.00
33,737.00
7,628.59
.00
7,927.59
25,809.41
23
.0
EXPENSE TOTALS
$4,410,220.00
$0.00
$4,410,220.00
:356,353.48
$0.00
$567,242.36
$3,842,977.64
13%
$484,884.37
Fund 040 - Refuse Disposal Fund Totals
$4,410,220.00
$0.00
$4,410,220.00
$356,353.48
$0.00
$567,242.36
$3,842,977.64
$484,884.37
Expense Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Fund 041- Motor Fuel Tax Fund
EXPENSE
Contractual Services
186,302.00
.00
186,302.00
3,229.88
75,752.08
3,229.88
107,320.04
42
1,976.00
Utilities
150,000.00
.00
150,000.00
13,862.29
.00
13,862.29
136,137.71
9
22,671.15
Commodities & Supplies
200,000.00
.00
200,000.00
78,938.57
85,550.43
114,173.31
276.26
100
171,259.65
Infrastructure
1,044,000.00
.00
1,044,000.00
444.00
16,716.48
444.00
1,026,839.52
2
.00
EXPENSE TOTALS
$1,580,302.00
$0.00
$1,580,302.00
$96,474.74
$178,018.99
$131,709.48
$1,270,573.53
20%
$195,906.80
Fund 041- Motor Fuel Tax Fund Totals
$1,580,302.00
$0.00
$1,580,302.00
$96,474.74
$178,018.99
$131,709.48
$1,270,573.53
$195,906.80
w
F1
0
Expense Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
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 042 - Cmmty Development Block Grant
EXPENSE
Personal Services, Scheduled Salaries & Wages
65,019.00
.00
65,019.00
4,361.14
25.00
6,649.62
58,344.38
10
6,744.09
Employee Benefits
29,838.00
.00
29,838.00
2,335.65
.00
4,249.90
25,588.10
14
3,524.21
Other Employee Costs
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
253.56
Contractual Services
107,186.00
.00
107,186.00
282.56
.00
2,159.73
105,026.27
2
1,075.05
Commodities & Supplies
500.00
.00
500.00
.00
.00
.00
500.00
0
56.99
Other Expenditures
160,000.00
.00
160,000.00
12,890.00
.00
12,890.00
147,110.00
8
19,535.00
Land Inprovements
.00
.00
.00
.00
.00
.00
.00
...
.00
Building Improvements
00
.00
.00
.00
.00
.00
.00
+ ++
.00
Infrastructure
50,000.00
.00
50,000.00
.00
.00
.00
50,00
0
.
EXPENSE TOTALS
$413,543.00
$0.00
$413,543.00
$19,869.35
$25.00
$25,949.25
$387,568.75
6%
$31,18
Fund 042 - Cmmty Development Block Grant Totals
$413,543.00
$0.00
$413,543.00
$19,869.35
$25.00
$25,949.25
$387,568.75
$31,188.90
Expense Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Fund 043 - Asset Seizure Fund
EXPENSE
Other Employee Casts
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
79.75
.00
4,139.35
(3,139.35) 414
.00
EXPENSE TOTALS
$3,500.00
$0.00
$3,500.00
$79.75
$0.00
$4,139.35
($639.35) 118%
$0.00
Fund 043 - Asset Seizure Fund Totals
$3,500.00
$0.00
$3,500.00
$79.75
$0.00
$4,139.35
($639.35)
$0.00
r
r
N
Expense Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
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
.00
.00
.00
1,000.00
0
.00
Building Improvements
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
Other Equipment
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
EXPENSE TOTALS
$3,000.00
$0.00
$3,000.00
$0.00
$0.00
$0.00
$3,000.00
0%
$0.00
Fund 044 - DEA Shared Funds Fund Totals
$3,000.00
$0.00
$3,000.00
$0.00
$0.00
$0.00
$3,000.00
$0.00
Expense Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Fund 045 - DUI Fine Fund
EXPENSE
Other Employee Costs
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00 0
.00
Other Equipment
7,500.00
.00
7,500.00
136.65
.00
1,880.65
5,619.35 25
.00
Interfund Transfers
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00 0
.00
EXPENSE TOTALS
$ 9,500.00
$0.00
$9,500.00
$136.65
$0.00
$1,880.65
$7,619.35 20%
$0.00
Fund 045 - DUI Fine Fund Totals
$9,500.00
$0.00
$9,500.00
$136.65
$0.00
$1,880.65
$7,619.35
$0.00
r
w
r
Expense Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Fund 046 - Foreign Fire Tax Board Fund
EXPENSE
Contractual Services
10,000.00
.00
10,000.00
.00
.00
1,974.26
8,025.74
20
2
Insurance
500.00
.00
500.00
.00
.00
.00
500.00
0
41721
Commodities & Supplies
3,000.00
.00
3,000.00
.00
.00
.00
3,000.00
0
.00
Other Equipment
15,000.00
.00
15,000.00
.00
.00
.00
15,000.00
0
.0
EXPENSE TOTALS
$28,500.00
$0.00
$28,500.00
$0.00
$0.00
$1,974.26
$26,525.74
7%
$2,949.74
Fund 046 - Foreign Fire Tax Board Fund Totals
$28,500.00
$0.00
$28,500.00
$0.00
$0.00
$1,974.26
$26,525.74
$2,949.74
Expense Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
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,856,769.00
.00
1,856,769.00
142,441.07
.00
210,927.76
1,645,841.24
11
204,935.68
Employee Benefits
684,136.00
.00
684,136.00
58,562.15
.00
116,151.77
567,984.23
17
100,057.51
Other Employee Costs
35,941.00
.00
35,941.00
1,371.66
509.50
6,471.66
28,959.84
19
3,927.50
Contractual Services
5,924,961.00
.00
5,924,961.00
428,291.06
210,636.36
542,020.70
5,172,303.94
13
486,298.02
Utilities
198,006.00
.00
198,006.00
8,366.89
.00
11,121.28
186,884.72
6
13,089.33
Insurance
70,098.00
.00
70,098.00
5,841.50
.00
11,683.00
58,415.00
17
12,806.32
Commodities & Supplies
312,616.00
.00
312,616.00
6,646.09
40,192.43
7,954.57
264,469.00
15
18,878.57
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
+ ++
00
Office Equipment
6,544.00
.00
6,544.00
.00
.00
.00
6,544.00
0
.00
Other Equipment
1,004,503.00
.00
1,004,503.00
57,090.00
37,883.60
57,090.00
909,529.40
9
7,812.68
Distribution Systems
1,883,600.00
.00
1,883,600.00
3,474.00
67,081.12
3,474.00
1,813,044.88
4
10,565.76
Infrastructure
30,000.00
.00
30,000.00
.00
.00
.00
30,000.00
0
.00
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
$12,007,174.00
$0.00
$12,007,174.00
$712,084.42
$356,303.01
$966,894.74
$10,683,976.25
11%
$858,371.37
Fund 050 - Water and Sewer Fund Totals
$12,007,174.00
$0.00
$12,007,174.00
$712,084.42
$356,303.01
$966,894.74
$10,683,976.25
$858,371.37
F-
Ul
rn
Expense Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
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
21,729.00
.00
21,729.00
1,717.71
.00
2,526.50
19,202.50
12
1,834.56
Employee Benefits
6,265.00
.00
6,265.00
507.78
.00
879.34
5,385.66
14
1,294.66
Contractual Services
94,796.00
.00
94,796.00
9,568.10
24,784.63
13,945.10
56,066.27
41
13,677.19
Insurance
812.00
.00
812.00
67.67
.00
135.34
676.66
17
125.84
Commodities & Supplies
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
Other Expenditures
.00
.00
.00
.00
.00
.00
100
+ ++
.00
Building Improvements
6,800.00
.00
6,800.00
.00
.00
.00
6,800.00
0
1,955.00
Infrastructure
50,000.00
.00
50,000.00
.00
5,000.00
.00
45,000.00
10
.00
Interfund Transfers
.00
.00
.00
.00
.0
.00
.00
+ ++
.
EXPENSE TOTALS
$180,902.00
$0.00
$180,902.00
$11,861.26
$29,784.63
$17,486.28
$133,631.09
26%
$18,887.25
Fund 051- Village Parking System Fund Totals
$180,902.00
$0.00
$180,902.00
$11,861.26
$29,784.63
$17,486.28
$133,631.09
$18,887.25
Expense Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
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
EXPENSE
Personal Services, Scheduled Salaries & Wages
41,031.00
.00
41,031.00
3,033.35
.00
4,712.26
36,318.74
11
4,142.96
Employee Benefits
17,443.00
.00
17,443.00
1,363.79
.00
2,496.94
14,946.06
14
1,586.15
Contractual Services
112,063.00
.00
112,063.00
7,274.40
6,380.97
10,293.06
95,388.97
15
8,971.65
Utilities
10,317.00
.00
10,317.00
313.08
.00
313.08
10,003.92
3
1,350.73
Insurance
1,138.00
.00
1,138.00
94.83
.00
189.66
948.34
17
168.50
Commodities & Supplies
9,586.00
.00
9,586.00
1,700.00
.00
1,856.60
7,729.40
19
64.66
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Building Improvements
25,000.00
.00
25,000.00
.00
.00
.00
25,000.00
0
.00
Infrastructure
.00
.00
.00
.00
34,062.22
.00
(34,062.22)
...
.00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
...
.00
EXPENSE TOTALS
$216,578.00
$0.00
$216,578.00
$13,779.45
$40,443.19
$19,861.60
$156,273.21
28%
$16,284.65
Fund 052 - Parking System Revenue Fund Totals
$216,578.00
$0.00
$216,578.00
$13,779.45
$40,443.19
$19,861.60
$156,273.21
$16,284.65
00
Expense Budget by Account Classification
Report
- Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month WD WD Budget - WD % 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
936,,976.00
.00
936,976.00
77,884.09
.00
113,504.52
823,471.48
12
113,664.67
Employee Beneflts
367,,789.00
.00
367,789.00
30,639.81
.00
51,646.50
316,142.50
14
48,435.42
Other Employee Costs
2,,315.00
.00
2,315.00
120.00
.00
120.00
2,195.00
5
.00
Contractual Services
95,738.00
.00
95,738.00
4,795.00
.00
5,895.63
89,842.37
6
13,649.70
Utilities
993.00
.00
993.00
40.62
.00
91.36
901.64
9
57.55
Commodities & Supplies
603,,349.00
.00
603,349.00
85,016.35
203,575.38
130,789.98
268,983,64
55
118,769.74
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Office Equipment
545.00
.00
545.00
.00
.00
.00
545.00
0
.00
Other Equipment
3, ,500.00
.00
3,500.00
.00
00
483.50
3,016.50
14
2,600.70
EXPENSE TOTALS
$2,011,205.00
$0.00
$2,011,205.00
$198,495.87
$203,575.
$302,
$ 1,505,098. 1 3
25%
$297,177.78
Fund 060 - Vehicle Maintenance Fund Totals
$2,011,,205.00
$0.00
$2,011,205.00
$198,495.87
$203,575.38
$302,531.49
$1,505,098.13
$297,177.78
Expense Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fun 1- Vehicle Replacement Fund
EXPENSE
Other Expenditures
.00
.00
.00
.00
.00
.00
.00 ...
.00
Motor Equipment
1,321,800.00
.00
1,321,800.00
2,896.00
171,237.88
4,367.00
1,146,195.12 13
2,741.46
Interfund Transfers
.00
.00
.00
.00
.00
.00
100 ...
.
EXPENSE TOTALS
$1,321,
$0.00
$1,
$2, 896.00
$171,237.88
$4, 367.00
$1,1 13%
$2,741.46
Fund 061 - Vehicle Replacement Fund Totals
$1,321,800.00
$0.00
$1,321,800.00
$2,896.00
$171,237.88
$4,367.00
$1,146,195.12
$2,741.46
N
O
Expense Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget 'Fransactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 062 - Computer Replacement Fund
EXPENSE
Office Equlpment 233,300.00 .00 233,900.00 19,982.48 .00 19,982.48 213,917.52 9 5,498.59
EXPENSE TOTALS $233, $0.00 $233,900.00 $19,982.48 $0.00 $19,982.48 $213,917.52 9% $5,498.59
Fund 062 - Computer Replacement Fund Totals $233,900.00 $0.00 $233,900.00 $19,982.48 $0.00 $19,982.48 $213,917.52 $5,498.59
Expense Budget by Account Classification
Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
f una 063 - Risk Management Fund
EXPENSE
Contractual Services
13,500.00
.00
13,500.00
3,300.00
.00
3,300.00
10,200.00
24
500.00
Insurance
6,831,455.00
.00
6,831,455.00
666,217.34
4,881.55
1,347,762.07
5,478,811.38
20
1,222,362.19
Other Equipment
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Infrastructure
.00
.00
. 00
.00
.
. 00
.00
+ ++
.00
EXPENSE TOTALS
$
$ 0. 0 0
$6,844,955.00
$6 69,517. 3 4
$ 4,881.55
$
$5,489,011.38
20%
$1,222,862.19
Fund 063 - Risk Management Fund Totals
$6,844,955.00
$0.00
$6,844,955.00
$669,517.34
$4,881.55
$1,351,062.07
$5,489,011.38
$1,222,862.19
N
r
N
N
Expense Budget by Account Classification
Report
Through 02/29/12
Prior Fiscal Year Activity Included
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
EXPENSE
Pension Benefits
3,646,470.00
.00
3,646,470.00
301,716.81
.00
605,436.16
3,041,033.84
17
594,019.36
Contractual Services
125,500.00
.00
125,500.00
.00
.00
10,363.15
115,136.85
8
10,610.16
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
.00
500.00
0
.00
Other Expenditures
12,000.00
.00
12,000.00
27.12
.00
777.12
11,222.88
6
275.00
Office Equipment
.00
.00
.00
.00
. 00
.00
.00
+ ++
.00
EXPENSE TOTALS
$3,794,470.00
$0.00
$3,794,470.00
$301,743.93
$0.00
$616,576.43
$3,177,893.57
16%
$604,904.52
Fund 070 - Police Pension Fund Totals
$3,794,470.00
$0.00
$3,794,470.00
$301,743.93
$0.00
$616,576.43
$3,177,893.57
$604,904.52
Expense Budget by Account Classification
Report
Account Classification
Through 02/29/12
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 071 - Fire Pension Fund
EXPENSE
Pension Benefits
3,647,069.00
.00
3,647,069.00
303,586.29
.00
607,172.58
3,039,896.42
17
590,580.40
Contractual Services
124,000.00
.00
124,000.00
1,116.25
.00
11,177.88
112,822.12
9
14,785.55
Insurance
11,000.00
.00
11,000.00
.00
.00
.00
11,000.00
0
.00
Commodities & Supplies
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
Other Expenditures
12,000.00
.00
12,000.00
.00
.00
.00
12,000.00
0
.00
EXPENSE TOTALS
$3,795,069.00
$0.00
$3,795,069.00
$304,702.54
$0.00
$618,350.46
$3,176,718.54
16%
$605,365.95
Fund 071- Fire Pension Fund Totals
$3,795,069.00
$0.00
$3,795,069.00
$304,702.54
$0.00
$618,350.46
$3,176,718.54
$605,365.95
Grand Totals $87,632,445.00 $0.00 $87,632,445.00 $6,010,580.90 $2,300,825.37 $9,977,337.98 $75,354,281.65 $9,099,597.33
N
W
VILLAGE OF MOUNT PROSPECT
List of Bills
March 15 - March 28, 2012
Fund Vendor Name
Invoice Description
Amount
001 General Fund
ACS State & Local Government Solutions
Illinois State Disbursement Unit
$ 2,899.36
Active Alarm Company, Inc.
Monitoring of alarms for Fire Station 12 - first quarter
300.00
Monitoring of alarms for 10 S. Pine -first quarter
79.50
Monitoring of alarms for storage shed at 1591 W. Algonquin Rd
85.50
2nd qtr alarm monitoring at the CCC - Invoice 80960
73.50
Addison Building Material Co.
Forestry Equipment and Supplies
38.42
ADT Security Services, Inc.
Equipment Maintenance and Repair
3,161.88
Airgas North Central
Oxygen & Cylinder Rental
255.47
Oxygen & Cylinder Rental
110.27
Aramark Uniform Services, Inc.
Cleaning and rental of Public Works empolyee uniforms
59.24
Armstrong Medical Industries Inc.
Infant Disposable Mask and Other Supplies
190.30
AT & T
Long Distance Service 2/1/12 - 2/29/12
1,179.69
Service 3/10/12 - 4/9/12
2,981.30
Service 3/7/12 - 4/6/12
731.44
B & H Photo /video
Video Equipment
1,593.95
Bedco Mechanical
Bi- monthly services to all HVAC equipment in all buildings
2,033.32
Besse Medical Supply
Invoice 12010449088 - Medical Supplies
250.78
Boivin, Michael
Reimbursement Youth Commission Meeting 2/1/12
21.94
Bright Electrical Supply Co.
Maintenance and repair supplies
432.11
Brzostowski, Jerry
CDL Reimbursement
30.00
Case Lots, Inc.
Custodial supplies to be used in all buildings
1,153.30
Replace trash receptacles for Public Works and cleaning supplies
305.00
CDW Government, Inc.
Equipment maintenance supplies
67.14
Equipment maintenance supplies
197.96
Equipment maintenance supplies
78.02
Equipment maintenance supplies
196.85
Backup Tapes
588.55
Equipment maintenance supplies
21.80
Century Cleaners
Uniform Cleaning
22.62
Uniform Cleaning
18.63
Uniform Cleaning
22.25
Uniform Cleaning
11.90
Uniform Cleaning
33.53
Uniform Cleaning
6.50
Uniform Cleaning
18.63
Uniform Cleaning
17.80
Chicago Office Technology Group
Copier overage - Invoice 099880
46.06
CL Graphics, Inc.
Printing - entrepreneur postcard plain
178.43
Reprints of Emergency Preparedness Newsletter Inserts
637.00
Shipping for Emergency Preparedness Inserts
17.92
Clark, Sandra M.
Travel and Meeting Expenses
60.00
Travel and Meeting Expenses
5.00
Commonwealth Edison
Electrical Service Delivery
239.16
Electrical Service Delivery
26.52
Electrical Service Delivery
100.21
Crystal Maintenance Services Corp.
Cleaning services for all buildings in January
6,163.62
Cleaning services at all buildings for April
6,163.62
CVS Pharmacy, Inc.
Prisoner supplies
8.18
Dorsey, Sean
Travel and Meeting Expenses
101.58
Drawing Board Printing Inc.
Mayor's sympathy cards
115.43
Eterno, David G.
Legal billing
213.00
Federal Express Corp
Shipping Services
28.10
Fire Pension Fund
Fire Pension
21,462.17
Flory, James M
Shelf & Brackets
88.85
Folgers Flag & Decorating, Inc.
Flag/banner parts
667.40
Garcia, Rafaela
$150 Yearly Clothing Allowance
150.00
Gary J. Klein
Celestial celebration music 2012
1,400.00
Gawlik, Nora
Food Purchase for the Youth Commission Meeting 3/7/12
32.91
Glenn Stearns Chapter 13 Trustee
Garnishment
200.00
Government Mangement Information Sciences
GMIS Conference
425.00
Graybar Electric Co.
Streetlight Supplies
295.91
Home Depot U.S.A., Inc.
Maintenance Repair and Supplies
697.41
Homer Tree Care, Inc.
Tree Removal
1,113.00
Tree Removal
9,700.40
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
17,413.02
IL Chapter, American Planning Association
Illinois APA 2012 Planning Intership Ad
25.00
Page 1 of 7
Fund
Vendor Name
ILGISA
Illinois American Water Company
Illinois Department of Revenue
Illinois Dept.of Agriculture
Illinois Environmental Health Assc.
Illinois Fire Service Admin. Professionals
Internal Revenue Service
International Association of Fire Chiefs
International Union of Operating Engineers
Interstate Battery
J.G. Uniforms, Inc.
Journal & Topics Newspapers
Kane, Julie K
Kapuscinski, Christopher
Kathleen W. Bono,csr,ltd.
Kerstein, June
Kidd, Daniel
Kone, Inc.
Landscape Forms, Inc.
Laner Muchin
Leib, Jason
Lindco Equipment Sales, Inc.
Lorman Education Services
McDonald's Corporation
Meade Electric Co. Inc.
Menards
Metro Federal Credit Union
Metropolitan Alliance - Police
Metropolitan Ind., Inc.
Michael Wagner & Sons, Inc.
Micro Tech Systems, Inc.
Miller, Ruth
Mobile Print Inc.
Morgan, Nancy
Mount Prospect Historical Soc.
Mount Prospect Public Library
Municipal Emergency Services, Inc.
Nationwide Mutual Insurance Company
Nextel Communications
Nexus Office Systems, Inc.
North Suburban Association of Chiefs of Police
Northwest Electrical Supply
Northwest Police Academy
Northwest Suburban United Way
Novak & Parker Inc.
VILLAGE OF MOUNT PROSPECT
List of Bills
March 15 - March 28, 2012
Invoice Description
Long Range Planner Job Advertisement
ILGISA Membership
Service 2/9/12 - 3/9/10
IL State Withholding
Truck scales certification
2012 North Chapter Annual Educational Conference
2012 North Chapter Annual Educational Conference
2012 North Chapter Annual Educational Conference
2012 North Chapter Annual Educational Conference
2012 North Chapter Annual Educational Conference
2012 Membership -1. Hernandez
Membership/ Heredia IFSAP 2012
Annual Membership
Federal Withholding
OPFED - Federal Withholding
Registration/ Malcolm Fire Rescue International 2012 Aug 1-4
IUOE PW Membership Dues
Equipment Maintenance and Repair
Body armor: F. Cornejo
Body armor: T. Janowick
Legal Notices for Planning Division
Legal Notices for Planning Division
Reimburse J. Kane for registering notary commission with County
Rebate TransReal Estate Tax
Legal billing
Reimb Phone March 2012
Reimburse training expenses
Elevator maintenance for Fire Station 14
Other Equipment
Legal Service February
CDL Reimbursement
Snow Plow Blades
Education Services
Prisoner meals - February, 2012
Traffic Signal Maintenance
Speaker Wire, Wall Plate and Surge Protector
Electronic Surge Protector
Maintenance and repair supplies
Maintenance and repair supplies
MP Fire Local 4119 Dues
MP Police Association Dues
Inspection and repair to ejector pump at teh Village Hall
Maintenance and repair supplies
Maintenance and repair supplies
Equipment Maintenance and Repair
Equipment maintenance supplies
Refund Vehicle License Fee
Mailing labels
Printing - Sister Cities - potluck postcard
Printed Envelopes
Mailing labels
Printing- Irish posters & rackcards
Reimburse N. Morgan for Advisory dinner & Calendar for C. Lively
April 2012 Budget Allocation
Fiber Optic Charges for Village Hall 10/16/11- 1/15/12
Fiber Optic Charges for CC Center 10/16/11- 1/15/12
TNT Tool
Nationwide 457 (flat percent)
Air cards
Wireless cards for 2/7 thru 3/8/12
PW - Staples 2/29/12
2012 Membership: M. Semkiu
2012 Membership: J. Dahlberg
Street light supplies
Seminar registration
United Way
Bosch Evolution Dishwasher
Page 2 of 7
Amount
100.00
50.00
292.10
39,713.08
400.00
50.00
50.00
50.00
80.00
80.00
40.00
55.00
55.00
190,443.25
481.26
595.00
564.63
399.80
677.00
760.00
126.96
126.96
10.00
750.00
596.00
39.95
100.00
289.00
6,280.00
1,207.50
30.00
135.53
149.00
208.54
223.46
31.85
11.97
13.76
52.17
2,357.40
1,198.50
6,871.00
197.26
99.82
203.70
311.85
36.00
70.81
38.80
498.58
66.92
220.40
41.84
3,333.33
1,759.14
830.50
256.78
13,241.47
159.96
239.94
23.50
50.00
50.00
1,128.55
100.00
249.75
848.00
VILLAGE OF MOUNT PROSPECT
List of Bills
March 15 - March 28, 2012
Fund Vendor Name
Invoice Description
Amount
Overhead Garage Door, Inc.
Overhead door repair
2,078.29
Parent Petroleum, Inc.
Street Sweeper Supplies
742.63
Petty Cash
Petty Cash
166.74
EWS Consultants, Inc.
Petty Cash 1/14/12 - 3/14/12
502.52
Gewalt Hamilton Assoc.
PETTY - CASH FIRE DEPARTMENT
99.50
Police Pension Fund
Police Pension
28,296.48
Pope, Elizabeth A.
Garnishment
92308
Proforma Customized Graphics
Open House Supplies
49.07
Open House Supplies
279.14
Sign Making Materials
117.60
Prosafety, Inc.
Replacement hard hats for all PW employees
434.50
Randolph, Daniel
Travel and Meeting Expenses
256.85
Red Wing Shoe Store
Safety Shoe Allowance
152.99
Rossbach, John
CDL Reimbursement
30.00
Secretary of State
2012 License Plate Sticker Renewal - S -27 - G516401
99.00
Shred First Inc.
Shredder bags
172.50
Signs By Tomorrow
Banners (3) - irish fest (1- garage, 2 train fence)
661.00
Sound Incorporated
Phone Support
828.83
April Maint. contract for ip phones, switches & servers
72.00
Standard Equipment Company
4502 sweeper OEM hyd filters and breather filters
426.39
Street Sweeper Supplies
1.42
Street Sweeper Supplies
607.61
State of Illinois
Internet Access
1,182.70
Steinweg, Delanie
Food Purchase for the Youth Commission Meeting 1/4/12
30.32
Suburban Accents Inc
Decals for PW hard hats
75.00
15" We Care Decal
30.00
Systems Forms, Inc.
Building Inspection Forms
419.54
T.P.I.
Building Inspections
12,803.50
Building Inspections
794.50
Building Inspections
13,210.00
Building Inspection
11,400.00
The Dearborn Inn
Lodging for training course: Medicolegal Investigation of Death
441.18
Thompson Elevator Inspections
Elevator Inspections
111.00
Elevator Inspections
225.00
Elevator Inspections
37.00
Elevator Inspections
37.00
Traffic Control & Protection Inc
Sign Making Material
5,742.50
Trees R Us Inc
Parkway Tree Trimming
4,388.90
Trezise, Robert
Refund Escrow Permit # 11 -2612
50.00
United States Alliance Fire Protection, Inc.
Building Maintenance and Repair
606.00
UPS Store #707
Shipping Services
10.48
VCG Uniform
Uniform supplies
224.70
Village of Mount Prospect
Flex - Parking
12,028.44
Service 1/31/12 - 2/29/12
5.00
Warehouse Direct
Office Supplies
987.87
Clock
22.91
Coffee & Coffee Cups for Meetings
55.90
Coffee Maker
239.00
Office Supplies - Magic Markers
6.26
Office Supplies
180.18
West Publishing Corporation
Subscription renewals
442.08
Wide Open West
WOW Internet Service
59.50
Wilks, Irvana
2012 Springfield NWMC
534.16
W ISCTF
Garnishment
542.48
Wisniewski, Donald
Reimbursement for camera purchase
76.27
Worldpoint Ecc, Inc.
Training CPR Cards
432.96
Wulbecker, Jeffrey
Clothing Allowance
34.94
001 General Fund Total
$ 471,311.33
020 Capital Improvement Fund
American Building Services
Improvements to Public Buildings
$ 3,202.60
Bright Electrical Supply Co.
Dimming ballast for stock
1,216.25
Business Office Systems, Inc.
Replacement Furniture
9,872.02
Combined Roofing Services LLC
Building Maintenance Repair
7,410.00
EWS Consultants, Inc.
Design /Consultation Services
1,000.00
Gewalt Hamilton Assoc.
Kensington Road Phase II Reconstruction
6,139.28
Kensington Road Phase II Reconstruction
2,560.48
Page 3 of 7
VILLAGE OF MOUNT PROSPECT
List of Bills
March 15 - March 28, 2012
Fund Vendor Name Invoice Description Amount
Ronco Industrial Supply Clothing lockers for all PW employees 12,948.00
020 Capital Improvement Fund Total $ 44,348.63
040 Refuse Disposal Fund
AT&T
Long Distance Service 2/1/12 - 2/29/12
$
6.56
Service 3/10/12 - 4/9/12
16.29
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
18.30
Illinois Department of Revenue
IL State Withholding
447.64
Internal Revenue Service
Federal Withholding
2,939.03
International Union of Operating Engineers
IUOE PW Membership Dues
60.52
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
44.99
Northwest Suburban United Way
United Way
3.00
Proforma Customized Graphics
Open House Supplies
12.02
Open House Supplies
68.41
Standard Equipment Company
Street Sweeper Brooms
488.81
Village of Mount Prospect
Flex - Parking
67.49
040 Refuse Disposal Fund Total
$
4,173.06
041 Motor Fuel Tax Fund
Commonwealth Edison
Electrical Service Delivery
$
11,166.68
Electrical Service Delivery
52.59
Morton Salt, Inc
Road salt for snow and ice control stock
2,560.18
Road salt for ice and snow control
2,565.61
041 Motor Fuel Tax Fund Total
$
16,345.06
042 Community Development Block Grant
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
$
112.50
Illinois Department of Revenue
IL State Withholding
94.00
Internal Revenue Service
Federal Withholding
557.07
Village of Mount Prospect
Flex - Parking
126.04
042 Community Development Block Grant Total
$
889.61
043 Asset Seizure Fund
Cash
Operations
$
500.00
043 Asset Seizure Fund Total
$
500.00
045 DUI Fine Fund
I Got HIt LLC
Crash data retrieval system
$
2,283.00
045 DUI Fine Fund Total
$
2,283.00
050 Water and Sewer Fund
Addison Building Material Co.
Building Maintenance and Repair
$
11.29
Aramark Uniform Services, Inc.
Cleaning and rental of Public Works empolyee uniforms
59.24
AT&T
Long Distance Service 2/1/12 - 2/29/12
437.79
Service 3/10/12 - 4/9/12
617.47
Service 3/10/12 - 4/9/12
1,087.22
Service 3/10/12 - 4/9/12
484.07
Atlas Reality
Refund Final Utility Bill
25.82
Badger Meter Inc
Water Meters
773.10
Water Meter Repair Parts
193.28
Bank of New York Mellon
JAWA March 2012
299,122.00
Burkhard, Daniel G
Refund Final Utility Bill Acct #896002
57.58
Century Cleaners
Uniform Cleaning
22.63
Uniform Cleaning
18.62
Uniform Cleaning
22.25
Uniform Cleaning
11.90
Uniform Cleaning
33.52
Uniform Cleaning
6.50
Uniform Cleaning
18.62
Uniform Cleaning
17.80
Chicago Title Insurance
Professional Service
750.00
Exelon Corporation
Electrical Service Delivery
1,769.83
Electrical Service Delivery
774.14
Electrical Service Delivery
213.61
Electrical Service Delivery
66.48
Electrical Service Delivery
89.38
Electrical Service Delivery
156.25
Page 4 of 7
VILLAGE OF MOUNT PROSPECT
List of Bills
March 15 - March 28, 2012
Fund Vendor Name
Invoice Description
Amount
Federal Express Corp
Shipping Expenses
163.37
Fluid Conservation Systems, Inc.
Repair Maintenance and Supplies
690.00
Repair Maintenance Supplies
1,065.00
HD Supply Waterworks, Ltd.
Repair Maintenance & Supplies
1,679.70
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
1,120.20
Illinois Department of Revenue
IL State Withholding
3,321.68
Internal Revenue Service
Federal Withholding
19,922.40
International Union of Operating Engineers
IUOE PW Membership Dues
486.08
Kaminski, Robert
Refund Final Water Bill Acct#974902
22.48
L & B Business Services Inc.
Repair Maintenance and Supplies
67.90
Mount Prospect Paint, Inc.
Building Maintenance and Repair
110.98
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
258.88
Nexus Office Systems, Inc.
PW - Staples 2/29/12
23.50
Northwest Suburban United Way
United Way
23.00
Proforma Customized Graphics
Open House Supplies
36.91
Open House Supplies
209.95
Prosafety, Inc.
Replacement hard hats for all PW employees
434.50
Ronco Industrial Supply
Supply Maintenance and Repair
40.91
Suburban Accents Inc
Decals for PW hard hats
75.00
Suburban Laboratories, Inc.
Annual IEPA- Required Water Sample Testing
262.00
Annual IEPA- Required Water Sample Testing
228.50
USA Bluebook
Repair Maintenance Supplies
80.94
Village of Mount Prospect
Flex - Parking
754.56
Water Environment Federation
Membership Dues
103.00
Ziebell Water Service Products
Hydrant Maintenance and Repair
170.00
Repair Maintenance and Supplies
2,747.60
050 Water and Sewer Fund Total
$
340,939.43
051 Village Parking System Fund
Crystal Maintenance Services Corp.
Cleaning services for all buildings in January
$
2,015.86
Cleaning services at all buildings for April
2,015.86
Illinois Department of Revenue
IL State Withholding
35.95
Internal Revenue Service
Federal Withholding
215.68
International Union of Operating Engineers
IUOE PW Membership Dues
9.68
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
21.95
Petty Cash
Petty Cash 1/14/12 - 3/14/12
5.00
Village of Mount Prospect
Flex - Parking
23.50
051 Village Parking System Fund Total
$
4,343.48
052 Parking System Revenue Fund
Crystal Maintenance Services Corp.
Cleaning services for all buildings in January
$
290.52
Cleaning services at all buildings for April
290.52
Illinois Department of Revenue
IL State Withholding
58.44
Internal Revenue Service
Federal Withholding
326.23
International Union of Operating Engineers
IUOE PW Membership Dues
6.47
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
14.69
Petty Cash
Petty Cash 1/14/12 - 3/14/12
2.00
Village of Mount Prospect
Flex - Parking
78.21
Service 2/1/12 - 2/29/12
19.04
052 Parking System Revenue Fund Total
$
1,086.12
060 Vehicle Maintenance Fund
ACS State & Local Government Solutions
Illinois State Disbursement Unit
$
480.24
Addison Building Material Co.
Vehicle Maintenance Supplies
93.27
Vehicle Maintenance Supplies
35.72
Airgas North Central
Equipment Maintenance & Repair
102.91
Alpha Prime Communications
Professional Services
149.90
Arlington Heights Ford
Squad trans seal
15.55
P -10 Trunk lock cylinder
61.35
Equipment Maintenance and Repair
128.65
Equipment Maintenance and Repair
116.95
AT&T
Long Distance Service 2/1/12 - 2/29/12
16.37
Service 3/10/12 - 4/9/12
40.72
Atlas Bobcat Inc.
Vehicle Maintenance Supplies
776.42
Chicago International Truck
Equipment Maintenance and Repair
243.87
Vehicle Maintenance Supplies
165.67
Chicago Parts & Sound Llc
Vehicle Maintenance Supplies
(278.91)
Pace 5 of 7
Fund
Vendor Name
Cylinders, Inc.
EJ Equipment
Grainger Inc.
Grossinger Chevrolet
ICMA Retirement Trust - 457
Illinois Department of Revenue
Internal Revenue Service
International Union of Operating Engineers
Jeffrey S. Siegmund
Just Tires
Mcmaster -carr Supply Co.
MPC Communications & Lighting
MSC Industrial Supply Co.
Napa- Heights Automotive Supply
Nationwide Mutual Insurance Company
Northwest Suburban United Way
Petroliance, LLC.
Pomp's Tire Service, Inc.
Precision Service & Parts
Pro Finish
Ronco Industrial Supply
Solvent Systems Int'I. Inc.
Standard Equipment Company
Tri -state Electronic Corp
Village of Mount Prospect
World Fuel Services, Inc.
060 Vehicle Maintenance Fund Total
061 Vehicle Replacement Fund
Lindco Equipment Sales, Inc.
Napco Steel, Inc.
Ultra Strobe Communications, Inc.
061 Vehicle Replacement Fund Total
VILLAGE OF MOUNT PROSPECT
List of Bills
March 15 - March 28, 2012
Invoice
525 Transmission filter
Air, oil and fuel filters for Ambulances
Air, oil and fuel filters for Ambulances
Squad oil filters, front brake pads /rotors
4542 Brake rotors & fuel filters
Squad A/C electric blend door motor
Equipment Maintenance and Repair
Vehicle Maintenance Supplies
Vehicle Maintenance Supplies
Vehicle Maintenance Supplies
2751 Drivers lower cushion seat cover
2715 Lug nuts
2715 Lug nuts
2715 Lower seat pad and cover for drivers seat
2715 Oil cooler lines and connectors
4526 am /fm speaker
2715 Door hinge kit
ICMA 457 (flat percent)
IL State Withholding
Federal Withholding
IUOE PW Membership Dues
Equipment Maintenance and Repair
Equipment Maintenance & Repair
Vehicle Maintenance Supplies
Equipment Maintenance & Repair
Vehicle Maintenance Supplies
Vehicle Maintenance Supplies
Vehicle Maintenance Supplies
2750 Rear door lift cylinders
Sway bar links
Small eq spark plugs
2715 Lug nuts
2 Light connectors for 2738, 2750
303 Pinion seal
4542 Brake pads
4542 Front wheel seals
Spotlight Bulb
R -53 Rototiller belt
Anti -seize
Nationwide 457 (flat percent)
United Way
Vehicle Maintenance Supplies
Dismount & mount 5 truck tires
4564 Dismount & mount 3 new tires
P -37 OEM Cooling fan & module, oil filters, air filters
Wiper blades
Squad spark plugs, boots
GM coolant
Squad Belt
Vehicle Maintenance Steam Cleaner
Vehicle Maintenance Supplies
Vehicle Maintenance Supplies
Vehicle Maintenance Supplies
Parts washer rental
Vehicle Maintenance Supplies
Vehicle Maintenance Supplies
Flex - Parking
8,500 gallon UL fuel
6002 gallon diesel fuel
Motor Equipment for Public Works Vehicle
New trucks 4517, 4522 quick link plow hitches
New trucks 4517, 4522 steel to build plow frames
P -5 conversion
Amount
37.46
500.00
51.33
311.36
420.98
49.12
585.00
162.23
137.08
66.78
259.95
23.10
10.50
375.26
115.57
26.96
99.94
661.50
1,707.29
10,014.32
294.57
485.00
3,178.31
812.00
162.50
19.51
310.00
38.22
60.98
62.98
15.92
19.20
9.98
16.94
105.76
22.98
48.99
10.97
45.36
210.00
12.69
228.20
124.00
116.00
507.49
29.26
113.90
67.74
18.48
473.50
237.05
111.67
14.45
185.64
127.29
14.26
531.66
29,479.79
21,514.18
$ 77,601.83
$ (485.19)
1,300.00
716.20
2,097.21
$ 3,628.22
Dear F of 7
VILLAGE OF MOUNT PROSPECT
List of Bills
March 15 - March 28, 2012
Fund Vendor Name Invoice Description Amount
063 Risk Management Fund
Cannon Cochran Management Services, Inc. Claims & Administration Fee 1St Quarter 2012 $ 3,375.00
063 Risk Management Fund Total $ 3,375.00
070 Police Pension Fund
Internal Revenue Service
Federal Withholding
$
36,007.14
070 Police Pension Fund Total
$
36,007.14
071 Fire Pension Fund
Internal Revenue Service
Federal Withholding
$
34,795.45
071 Fire Pension Fund Total
$
34,795.45
073 Escrow Deposit Fund
All State Roofing Inc
Refund Escrow Permit # 12 -0011
$
125.00
American Landscaping Inc.
Return Donation Block Party 2012
1,000.00
American Sign Factory LLC
Refund Escrow Permit # 12 -0133
125.00
Anderson, Gail
Refund Escrow Permit # 11 -2296
125.00
Better Built Lumber & Supply Inc
Refund Escrow Permit # 11 -1292
275.00
Blue Water Plumbing
Refund Escrow Permit # 11 -1487
25.00
Casto Lifestyle Randhurst Shopping Center LLC
Refund Escrow Permit # 12 -0037
225.00
Hebenstreit, Calvin
Refund Escrow Permit # 12 -0192
125.00
Ibbotson Heating Co
Refund Escrow Permit # 12 -0163
75.00
JIRSA Construction
Refund Escrow Permit # 11 -2623
250.00
Kessler, Thomas 1
Refund Escrow Permit # 12 -0103
350.00
Langbehn, Steven A
Refund Escrow Permit # 11 -0129
75.00
Norb & Sons Electric
Refund Escrow Permit # 12 -0162
125.00
Penner, Arnie
Refund Escrow Permit # 12 -0183
75.00
Rainbow Signs Inc
Refund Escrow Permit # 10 -0857
75.00
Randhurst Crossing LLC
Refund Escrow Permit # 11 -2672
75.00
Rick's Sewer & Drainage
Refund Escrow Permit # 12 -0172
125.00
Smejkal, Mark
Refund Escrow Permit # 12 -0196
125.00
Third District Circuit Court
Bond Check 3/15/12
1,340.00
Bond Check 3/20/12
2,810.00
Bond Check 3/22/12
1,600.00
Bond Check 3/27/12
2,710.00
Windsor Sign System
Refund Escrow Permit # 12 -0161
125.00
073 Escrow Deposit Fund Total
$
11,960.00
Grand Total
$
1,053,587.36
D- 7 of 7