HomeMy WebLinkAbout3. Monthly Financial Report & Bills 04/16/2013Village of Mount Prospect
Mount Prospect, Illinois
INTEROFFICE MEMORANDUM
TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES
FINANCE COMMISSION
FROM: FINANCE DIRECTOR
DATE: APRIL 12, 2013
SUBJECT: MONTHLY FINANCIAL REPORT — MARCH 2013
Attached hereto are the cash position and investment statements of the Village for the month
ended March 31, 2013. These statements provide a snapshot of the Village's cash position as
of the month end date noted and are intended to supplement the budget revenue and
expenditure summary and listing of bills you receive. The first statement presents the Village's
cash position broken down by governmental and enterprise funds and trust and agency funds.
The second statement presents the Village's cash position by fund type. The third statement
presents the list of investments again broken down by governmental and enterprise funds and
trust and agency funds. It is important to note that although we have included the trust and
agency funds in the cash position report, these are not funds accessible for Village operations.
They are restricted for pension and escrow funding only. Please read the summary that follows
for further detail on the cash position of the Village.
Cash and Investment Position Report — All Funds (page 1)
This report provides a detailed summary of cash and investments for the Village broken out by
governmental and enterprise funds and trust and agency funds. Governmental funds include
the General Fund, Special Revenue Funds, Debt Service Funds, Capital Project Funds and
Internal Service Funds. The Enterprise Funds consist of the Water and Sewer Fund and two (2)
Parking Funds.
Trust funds include the Village's two public safety pensions (Police and Firefighters') while the
agency funds include the Escrow Deposit, Flexcomp Escrow, Special Service Area and Library
Bonds Escrow Funds. The Escrow Deposit Fund accounts for refundable deposits held by the
Village to ensure completion of public improvements. The Flexcomp Escrow Fund accounts for
employee payroll deductions pursuant to a Section 125 flexible compensation plan. The Special
Service Area Fund and Library Bonds Escrow Fund account for the accumulation of monies for
debt service payments.
Governmental and Enterprise Funds - Cash and cash equivalents at February 28 were $31.9
million. During March, cash receipts totaled $10,489,955. In addition investment income for the
month was $2,930. Reductions to cash and cash equivalents during March totaled $4,518,472.
Of this amount, payments to vendors were $3,147,410 and employee payroll related expenses
were $1,371,062. There was a net increase to cash from other disbursements totaling $6,857
due to voided checks. There was also a net increase in cash due to interfund activity of
$15,337. Cash and cash equivalents at March 31 increased to $37.9 million.
Monthly Financial Report — March 2013
April 12, 2013
Page 2
There were no funds held in investments during the month of March. 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 February 28 were
$31,873,688. Cash and investments at March 31 totaled $37,870,295. This is an increase of
$5,996,607 for the month. The increase is primarily due to the receipt of the first installment of
2012 property taxes.
Trust and Agency Funds - Cash and cash equivalents at February 28 were $5.3 million.
During March, cash receipts totaled $2,041,607. In addition investment income for the month
was $67,104. There was a net decrease in cash due to investment activities of $262,494, and a
net decrease in cash due to interfund activity of $15,337. Reductions to cash and cash
equivalents during March totaled $873,394. Of this amount, payments to vendors were
$315,997, employee payroll and related expenses were $527,014, and payments related to the
flexible spending program totaled $30,383. There were also other adjustments totaling $474.
Cash and cash equivalents at March 31 were $6.3 million.
Total investments at March 31 were $96,504,319, an increase of $3,370,569 from February 28.
There were investment income of $3,108,075 and a net transfer -in totaling $262,494 that
accounted for the change.
Total cash and investments for Trust and Agency Funds at February 28 were $98,460,819.
Cash and investments at March 31 totaled $102,788,402. This is an increase of $4,327,583
from the prior month.
Summary of Cash Activity by Fund Type (page 2)
This report provides a breakdown of the cash activity for the month broken down by fund type.
This breakdown is useful in identifying where the activity (receipts and disbursements) is
occurring. There are times during the year when activity in certain funds such as the capital
improvement and special revenue funds is higher than normal. This will distort the financial
picture of some of the other components of the governmental funds such as the General Fund
which tends to be more level and predictable in terms of spending and receipt of revenue. Each
month the report will provide further explanation on the activity of the General Fund, the
Village's primary operating fund. The report will also provide additional information on fund
types that experienced higher than normal activity for the month. Activity for the General Fund
is highlighted below.
General Fund — Cash and cash equivalents at February 28 totaled $6,568,850. During March,
cash receipts totaled $5,631,341 and investment income was $1,525. Significant cash receipts
include property taxes, sales and income taxes and vehicle stickers.
Receipts of Property taxes related to the 2012 levy continued coming in during March. A
total of $4,649,507 was received in the General Fund during the month. Approximately 49%
of the total budget for property taxes has been received during February and March.
H:WCCTUreasurer's Report\20131Monthly Cash Position Report - March 2013.docx
Monthly Financial Report — March 2013
April 12, 2013
Page 3
Sales tax revenues for the month totaled $1,084,067. Of this amount, $965,425 was
generated from the 1% state portion while $118,642 was generated from the .25% home
rule portion. Sales taxes received in March are for December sales. There is a normal
three -month lag in getting this distribution from the state.
Vehicle Stickers went on sale February 1 for the 2013 -2014 license period. Total receipts
for March were $264,611. The total budget for this line item is $1,385,000. As of the end of
we are at $544,115 or 39.3% of the total budget. A majority of the sticker sales will occur in
April with the April 30 deadline required.
Disbursements from the General Fund for March included payments to vendors of $1,252,429,
payments for employee wages and benefits of $1,201,797 and other disbursements of $39,555.
There was also a net decrease in cash due to interfund transactions totaling $677,357.
Cash and cash equivalents at March 31 were $9,030,578. There were no investments in the
General Fund at March 31.
Statement of Investments (page 3)
This report provides a breakdown of investments by governmental and enterprise funds and
trust and agency funds. The report also provides a fund -by fund breakdown of the investments.
Government and Enterprise Funds - Investments for the governmental and agency funds are
typically made up of Certificates of Deposit. At February 28 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. Equity investments are managed by Sawyer Falduto Asset
Management. Below is a breakdown of how the pension fund portfolios are invested.
H:\ACCT\Treasurer's Report\2013 \Monthly Cash Position Report - March 2013.docx
Monthly Financial Report — March 2013
April 12, 2013
Page 4
Maturity Purchase Financial Investment CUSIP/ Interest
Date Date Institution Description Acct # Rate %
POLICE PENSION FUND (070)
Various Various Wells Fargo
Various Various Various
FIRE PENSION FUND (071)
Various Various Wells Fargo
Various Various Various
Wells Fargo Investments
Mutual Fund Investments
Wells Fargo Investments
Mutual Fund Investments
TOTAL TRUST AND AGENCY FUND INVESTMENTS
Various
Various
Various
Various
Various
Various
Various
Various
Market
Value
23,566,685.44
25,450,986.44
49,017,671.88
21,300,526.21
26,186,120.82
47,486,647.03
$ 96,504,318.91
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.
David O. Erb
Finance Director
H:\ACCT\Treasurer's Report\2013 \Monthly Cash Position Report - March 2013.docx
VILLAGE OF MOUNT PROSPECT
Preliminary Cash and Investment Position Report - All Funds
For the Month Ended March 31, 2013
GOVERNMENTAL AND ENTERPRISE FUNDS
Balance at February 28, 2013
Cash receipts
Investment income
Transfers from investments to cash
Transfers to investments from cash
Interfund activity
Disbursements:
Accounts payable
Payroll
Other
Balance at March 31, 2013
Cash and Cash Total Cash and
Equivalents Investments Investments
$ 31,873,687.57 $ - $ 31,873,687.57
10,489,955.28 10,489,955.28
2,930.35 2,930.35
15,336.99 15,336.99
(3,147,409.91) (3,147,409.91)
(1,371,062.68) (1,371,062.68)
6,857.22 6,857.22
$ 37,870,294.82 $ - $ 37,870,294.82
TRUST AND AGENCY FUNDS *
Disbursements:
Accounts payable
Payroll
Flex spending
Other
(315,997.01)
(527,014.01)
(30,382.75)
(473.96)
Balance at March 31, 2013
Total Cash and
Investments
$ 98,460,819.42
2,041,607.18
3,175,180.13
(15,336.99)
(315,997.01)
(527,014.01)
(30,382.75)
(473.96)
$ 6,284,083.10 $ 96,504,318.91 $ 102,788,402.01
* Assets are restricted in purpose and do not represent discretionary assets of the government.
1
Cash and Cash
Equivalents
Investments
Balance at February 28, 2013
$ 5,327,069.61
$ 93,133,749.81
Cash receipts
2,041,607.18
Investment income (loss)
67,104.81
3,108,075.32
Transfers from investments to cash
2,696,830.05
(2,696,830.05)
Transfers to investments from cash
(2,959,323.83)
2,959,323.83
Interfund activity
(15,336.99)
Disbursements:
Accounts payable
Payroll
Flex spending
Other
(315,997.01)
(527,014.01)
(30,382.75)
(473.96)
Balance at March 31, 2013
Total Cash and
Investments
$ 98,460,819.42
2,041,607.18
3,175,180.13
(15,336.99)
(315,997.01)
(527,014.01)
(30,382.75)
(473.96)
$ 6,284,083.10 $ 96,504,318.91 $ 102,788,402.01
* 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 March 31, 2013
GOVERNMENTAL AND ENTERPRISE FUNDS TRUST AND AGENCY FUNDS *
* 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
$ 6,568,850.14
$ 3,326,501.71
$ 265,739.98
$ 7,825,649.35
$ 4,436,777.90
$ 9,450,168.49
$ 31,873,687.57
$ 3,684,889.24
$ 1,642,180.37
$ 37,200,757.18
Cash receipts
5,631,341.45
1,023,148.29
713,148.50
1,196,624.23
1,757,444.23
168,248.58
10,489,955.28
1,928,023.99
113,583.19
12,531,562.46
Investment income
1,525.36
73.08
5.34
495.57
82.43
748.57
2,930.35
66,952.16
152.63
70,035.16
Transfers from investments
-
-
-
-
-
-
-
2,696,830.05
-
2,696,830.05
Transfers to investments
-
-
-
-
-
-
-
(2,959,323.83)
-
(2,959,323.83)
Interfund
(677,357.07)
29,495.34
-
46,043.00
(167,452.53)
784,608.25
15,336.99
6,632.59
(21,969.58)
(0.00)
Disbursements - other
(39,555.45)
-
-
-
137.67
46,275.00
6,857.22
-
(473.96)
6,383.26
Disbursements - flexible spending
-
-
-
-
-
-
(30,382.75)
(30,382.75)
Disbursements - payroll
(1,201,797.40)
(14,393.45)
-
(103,065.11)
(51,806.72)
(1,371,062.68)
(527,014.01)
-
(1,898,076.69)
Disbursements - accounts payable
(1,252,429.03)
(501,244.89)
-
(102,322.76)
(540,652.73)
(750,760.50)
(3,147,409.91)
(96,420.51)
(219,576.50)
(3,463,406.92)
Ending balance
9,030,578.00
3,863,580.08
978,893.82
8,966,489.39
5,383,271.86
9,647,481.67
37,870,294.82
4,800,569.70
1,483,513.40
44,154,377.92
INVESTMENTS
Certificates of deposit
-
-
Wells Fargo investments
-
-
-
-
44,867,211.65
-
44,867,211.65
Mutual fund investments
-
51,637,107.26
51,637,107.26
Total investments
-
-
-
96,504,318.91
96,504,318.91
TOTAL CASH AND INVESTMENTS
$ 9,030,578.00
$ 3,863,580.08
$ 978,893.82
$ 8,966,489.39
$ 5,383,271.88
$ 9,647,481.67
$ 37,870,294.82
$101,304,888.61
$ 1,483,513.40
$140,658,896.83
* Assets are restricted in purpose and do not represent discretionary assets of the government
VILLAGE OF MOUNT PROSPECT
STATEMENT OF INVESTMENTS
As of March 31, 2013
GOVERNMENTAL AND ENTERPRISE FUNDS
Maturity Purchase Financial Investment CUSIP/ Interest Market
Date Date Institution Description Acct # Rate % Value
As of March 31, 2013, there were no certificates of deposit held by the Governmental and Enterprise Funds.
TRUST AND AGENCY FUNDS *
Maturity Purchase Financial
Investment
CUSIP/
Interest
Market
Date Date Institution
Description
Acct #
Rate %
Value
POLICE PENSION FUND (070)
Various Various Wells Fargo
Wells Fargo Investments
Various
Various
23,566,685.44
Various Various Various
Mutual Fund Investments
Various
Various
25,450,986.44
49,017,671.88
FIRE PENSION FUND (071)
Various Various Wells Fargo
Wells Fargo Investments
Various
Various
21,300,526.21
Various Various Various
Mutual Fund Investments
Various
Various
26,186,120.82
47,486,647.03
TOTAL TRUST AND AGENCY FUND INVESTMENTS
$96,504,318.91
* Assets are restricted in purpose and do not represent discretionary assets of the government.
3
VILLAGE OF MOUNT PROSPECT
BUDGET REVENUE
EXPENDITURE SUMMARIES
March 01— March 31, 2013
Revenue Budget by Account Classification
Account Classification
Adopted Budget Amended Current Month YTD
Budget Amendments Budget Transactions En
Through 03/31/13
Prior Fiscal Year Activity Included
YTD Budget - YTD % used/
Transactions Transactions Rec'd Prior Year YTD
Fund 001- General Fund
REVENUE
Property Taxes
12,853,668.00
.00
12,853,668.00
4,649,506.85
.00
6,301,416.33
6,552,251.67
49
6,004,567.09
Other Taxes
8,043,000.00
.00
8,043,000.00
304,463.06
.00
588,678.60
7,454,321.40
7
587,562.05
Licenses, Permits & Fees
2,704,000.00
.00
2,704,000.00
448,566.32
.00
978,068.12
1,725,931.88
36
843,174.28
Intergovernmental Revenue
17,690,630.00
.00
17,690,630.00
122,755.11
.00
255,149.07
17,435,480.93
1
230,754.72
Charges For Services
1,493,000.00
.00
1,493,000.00
5,200.96
.00
295,747.68
1,197,252.32
20
263,622.33
Fines & Forfeits
480,000.00
.00
480,000.00
13,729.03
.00
131,581.38
348,418.62
27
55,379.01
Investment Income
35,000.00
.00
35,000.00
1,675.40
.00
4,562.51
30,437.49
13
5,886.56
Reimbursements
230,500.00
.00
230,500.00
28,996.16
.00
49,815.98
180,684.02
22
63,110.19
Other Revenue
792,200.00
.00
792,200.00
16,311.30
.00
74,849.00
717,351.00
9
89,909.26
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
REVENUE TOTALS $44,321,998.00
$0.00
$44,321,998.00
$5,591,204.19
$0.00
$8,679,868.67
$35,642,129.33
20%
$8,143,965.49
Fund 001- General Fund Totals $44,321,998.00
$0.00
$44,321,998.00
$5,591,204.19
$0.00
$8,679,868.67
$35,642,129.33
$8,143,965.49
r
N
Revenue Budget by Account Classification
Report
Account Classificati
Adopted Budget Amended Current Month YTD
Budget Amendments Budget Transactions En
Through 03/31/13
Prior Fiscal Year Activity Included
YTD Budget - YTD % used/
Transactions Transactions Rec'd Prior Year YTD
Fund 002 - Debt Service Fund
REVENUE
Property Taxes
Other Taxes
Intergovernmental Revenue
Investment Income
Other Financing Sources
1,745,400.00
.00
1,745,400.00
642,397.09
.00
870,796.58
874,603.42
50
845,754.12
613,356.00
.00
613,356.00
.00
.00
.00
613,356.00
0
.00
47,258.00
.00
47,258.00
.00
.00
.00
47,258.00
0
.00
600.00
.00
600.00
5.34
.00
6.93
593.07
1
.00
.00
.00
.00
.00
.00
.00
.
+ ++
8,210.00
REVENUE TOTALS $2,406,614.00
$0.00
$2,406,614.00
$642,402.43
$0.00
$870,803.51
$1, 535,810.49
36%
$853,964.12
Fund 002 - Debt Service Fund Totals $2,406,614.00
$0.00
$2,406,614.00
$642,402.43
$0.00
$870,803.51
$1,535,810.49
$853,964.12
Revenue Budget by Account Classification
w
Report
Through 03/31/13
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 020 - Capital Improvement Fund
REVENUE
Other Taxes
1,135,000.00
.00
1,135,000.00
.00
.00
.00
1,135,000.00 0 .00
Intergovernmental Revenue
.00
.00
.00
.00
.00
.00
.00 + ++ 11,941.00
Investment Income
500.00
.00
500.00
82.32
.00
147.98
352.02 30 .00
Reimbursements
.00
.00
.00
.00
.00
.00
.00 + ++ .00
Other Revenue
5,000.00
.00
5,000.00
1,450.00
.00
191,890.00
(186,890.00) 3838 .00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00 + ++ .00
REVENUE TOTALS
$1,140,500.00
$0.00
$1,140,500.00
$1,532.32
$0.00
$192,037.98
$948,462.02 17% $11,941.00
Fund 020 - Capital Improvement Fund Totals
$1,140,500.00
$0.00
$1,140,500.00
$1,532.32
$0.00
$192,037.98
$948,462.02 $11,941.00
w
,p
Account Classification
Fund 021 - Series 2009 Construction Fund
REVENUE
Revenue Budget by Account Classification
Report
Through 03/31/13
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
Intergovernmental Revenue
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Investment Income
.00
.00
.00
1.40
.00
2.64
(2.64)
+ ++
.00
Other Revenue
.00
.00
.00
.00
.00
.00
.00
...
.00
Other Financing Sources
. 00
.00
.00
.00
.00
.00
.00
+ ++
.00
REVENUE TOTALS
$0.00
$0.00
$0.00
$1.40
$0.00
$2.64
($2.64)
+ ++
$0.0
Fund 021 - Series 2009 Construction Fund Totals
$0.00
$0.00
$0.00
$1.40
$0.00
$2.64
($2.64)
$0.00
Account Classification
Fund 022 - Downtown Redevelopment Construct
REVENUE
Revenue Budget by Account Classification
Report
Through 03/31/13
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
Property Taxes
2,681,000.00
.00
2,681,000.00
878,970.47
.00
1,304,858.78
1,376,141.22
49
1,339,391.93
Investment Income
1,000.00
.00
1,000.00
55.71
.00
102.68
897.32
10
.00
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
.00
+ ++
.00
REVENUE TOTALS
$2,682,000.00
$0.00
$2,682,000.00
$879,026.18
$0.00
$1,304,961.46
$1,377,038.54
49%
$1,339,391.93
Fund 022 - Downtown Redevelopment Construct Totals
$2,682,000.00
$0.00
$2,682,000.00
$879,026.18
$0.00
$1,304,961.46
$1,377,038.54
$1,339,391.93
L"
ON
Revenue Budget by Account Classification
Report
Through 03/31/13
Prior Fiscal Year Activity Included
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % 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,545,000.00
.00
1,545,000.00
27,773.74
.00
58,251.96
1,486,748.04 4 50,630.53
Licenses, Permits & Fees
.00
.00
.00
.00
.00
.00
.00 + ++ .00
Intergovernmental Revenue
.00
.00
.00
3,611.52
.00
3,611.52
(3,611.52) ... .00
Investment Income
500.00
.00
500.00
7.22
.00
9.86
490.14 2 .00
Reimbursements
.00
.00
.00
.00
.00
.00
.00 + ++ .00
Other Revenue
5,000.00
.00
5,000.00
.00
.00
20.00
4,980.00 0 .00
Other Financing Sources
.00
.00
.00
.00
.00
.00
. + ++ .00
REVENUE TOTALS
$1,550,500.00
$0.00
$1,550,500.00
$31,392.48
$0.00
$61,893.34
$1,488,606.6 4% $ 50,630.53
Fund 023 - Street Improvement Construc Fund Totals
$1,550,500.00
$0.00
$1,550,500.00
$31,392.48
$0.00
$61,893.34
$1,488,606.66 $50,630.53
Revenue Budget by Account Classification
v
Report
Through 03/31/13
Prior Fiscal Year Activity Included
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account C l as sifi c ation
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Recd Prior Year YTD
Fund 024 - Flood Control Construction Fund
REVENUE
Other Taxes
621,644.00
.00
621,644.00
.00
.00
.00
621,644.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 .00
Investment Income
.00
.00
.00
348.92
.00
980.70
(980.70) + ++ .00
Reimbursements
56,500.00
.00
56,500.00
.00
.00
.00
56,500.00 0 56,521.31
Other Financing Sources
. 00
.00
.00
.00
.00
.00
.00 +++ .00
REVENUE TOTALS
$ 685,644.00
$0.00
$685,644.00
$348.92
$0.00
$980.70
$684,663.30 0% $56,521.31
Fund 024 - Flood Control Construction Fund Totals
$685,644.00
$0.00
$685,644.00
$348.92
$0.00
$980.70
$684,663.30 $56,521.31
v
.
Revenue Budget by Account Classification
Report
Account Classification
Fund 040 - Refuse Disposal Fund
REVENUE
Through 03/31/13
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
Property Taxes
1,857,000.00
.00
1,857,000.00
684,147.71
.00
927,349.08
929,650.92
50
872,408.89
Charges For Services
2,190,000.00
.00
2,190,000.00
242,179.79
.00
512,489.85
1,677,510.15
23
478,401.27
Fines & Forfeits
45,000.00
.00
45,000.00
1,732.50
.00
3,012.67
41,987.33
7
10,617.99
Investment Income
500.00
.00
500.00
39.59
.00
79.15
420.85
16
.00
Reimbursements
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Revenue
366,000.00
.00
366,000.00
15,490.20
.00
29,364.99
336,635.01
8
30,751.11
REVENUE TOTALS $4,458,500.00
$0.00
$4,458,500.00
$943,589.79
$0.00
$1,472,295.74
$2,986,204.26
33%
$1,392,179.2
Fund 040 - Refuse Disposal Fund Totals $4,458,500.00
$0.00
$4,458,500.00
$943,589.79
$0.00
$1,472,295.74
$2,986,204.26
$1,392,179.26
Revenue Budget by Account
Classification
Report
Through 03/31/13
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
92,470.71
.00
201,294.11
1,488,705.89 12 221,211.06
Investment Income
100.00
.00
100.00
19.64
.00
34.16
65.84 34 .00
Reimbursements
15,000.00
.00
15,000.00
.00
.00
.00
15,000.00 0 .00
REVENUE TOTALS
$1,705,100.00
$0.00
$1,705,100.00
$92,490.35
$0.00
$201,328.27
$1,503,771.73 12% $221,211.06
Fund 041- Motor Fuel Tax Fund Totals
$1,705,100.00
$0.00
$1,705,100.00
$92,490.35
$0.00
$201,328.27
$1,503,771.73 $221,211.06
r
0
Revenue Budget by Account Classification
Report
Account Classification
Adopted Budget Amended Current Month YTD
Budget Amendments Budget Transactions Encumbrances
Through 03/31/13
Prior Fiscal Year Activity Included
YTD Budget - YTD % used/
Transactions Transactions Rec'd Prior Year YTD
un - CMMty Development Block ran
--
REVENUE
Intergovernmental Revenue
230,203.00
170,206.00
400,409.00
.00
.00
.00
400,409.00 0
15,994.79
Investment Income
.00
.00
.00
.00
.00
.00
.00 + ++
.00
Other Revenue
60,000.00
.00
60,000.00
.00
.00
7,16
52,832.00 12
.00
REVENUE TOTALS
$290,203.00
$170,206.00
$460,409.00
$0.00
$0.00
$7,168.00
$453,241.00 2%
$1 5,994.79
Fund 042 - Cmmty Development Block Grant Totals
$290,203.00
$170,206.00
$460,409.00
$0.00
$0.00
$7,168.00
$453,241.00
$15,994.79
Account Classification
Fund 043 - Asset Seizure Fund
REVENUE
Fines & Forfeits
Investment Income
r
r
Revenue Budget by Account Classification
Report
Through 03/31/13
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
3,000.00
.00
3,000.00
1,711.13
.00
4,238.27
(1,238.27) 141
414.47
100.00
.00
100.00
1.40
.00
2.64
97.36 3
.00
REVENUE TOTALS $3,100.00
$0.00
$3,100.00
$1,712.53
$0.00
$4,240.91
($1,140.91) 137%
$414.47
Fund 043 - Asset Seizure Fund Totals $3,100.00
$0.00
$3,100.00
$1,712.53
$0.00
$4,240.91
($1,140.91)
$414.47
N
Revenue Budget by Account Classification
i
Report
Through 03/31/13
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
1,000.00
.00
1,000.00
.00
.00
.00 1,000.00 0 .00
Investment Income
100.00
.00
100.00
.87
.
2.52 97.48 3 2.57
REVENUE TOTALS
$1,100.00
$0.00
$1,100.00
$0.87
$0.00
$2.52 $1,097.48 0% $2.57
Fund 044 - DEA Shared Funds Fund Totals
$1,100.00
$0.00
$1,100.00
$0.87
$0.00
$2.52 $1,097.48 $2.57
Revenue Budget by Account Classification
Report
Account Classification
Through 03/31/13
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 045 - DUI Fine Fund
REVENUE
Fines & Forfeits
20,000.00
.00
20,000.00
.00
.00
.00
20,000.00 0
.00
Investment Income
100.00
.00
100.00
.00
.00
.00
100.00 0
.00
REVENUE TOTALS $20,100.00
$0.00
$20,100.00
$0.00
$0.00
$0.00
$20,100.00 0%
$0.00
Fund 045 - DUI Fine Fund Totals $20,100.00
$0.00
$20,100.00
$0.00
$0.00
$0.00
$20,100.00
$0.00
r-�
w
r
Revenue Budget by Account Classification
Report
Through 03/31/13
Prior Fiscal Year Activity Included
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classlflcation
Budget
Amendments
Budget
Transa
E ncu m brances
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
.00
.00
.00
.00
.00
.00
.00 + ++ .00
Other Revenue
.00
.00
.00
.00
.00
45.00
(45.00) + ++ .00
Other Financing Sources
.00
.00
.00
.00
.
. 00
.00 ... .00
REVENUE TOTALS
$55,000.00
$ 0.00
$55,000.00
$0.00
$0.00
$45.00
$54,955.00 0% $0.00
Fund 046 - Foreign Fire Tax Board Fund Totals
$55,000.00
$0.00
$55,000.00
$0.00
$0.00
$45.00
$54,955.00 $0.00
Account Classification
Fund 047 - Justice Assistance Grant Fund
Revenue Budget by Account Classification
Report
Through 03/31/13
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
REVENUE
Intergovernmental Revenue .00
.00
.00
.00
.00
.00
.00 + ++
.00
Investment Income .00
.00
.00
.00
.00
.00
.00 ...
.00
REVENUE TOTALS $0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00 + ++
$0.00
Fund 047 - Justice Assistance Grant Fund Totals $0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
r
U1
r
rn
Revenue Budget by Account Classification
Account Classification
Adopted Budget Amended Current Month YTD
Budget Amendments Budget Transactions Encumbrances
Through 03/31/13
Prior Fiscal Year Activity Included
YTD Budget - YTD % used/
Transactions Transactions Recd Prior Year YTD
Fund 048 - Business District Fund
REVENUE
Other Taxes
671,000.00
.00
671,000.00
30,143.90
.00
70,764.25
600,235.75 11
17,586.25
Investment Income
.00
.00
.00
11.58
.00
20.61
( + ++
.
REVENUE TOTALS
$671,000.00
$0.00
$671,000.00
$30,155.48
$0.00
$70,784.86
$600,215.14 11%
$17,586.25
Fund 048 - Business District Fund Totals
$671,000.00
$0.00
$671,000.00
$30,155.48
$0.00
$70,784.86
$600,215.14
$17,586.25
Revenue Budget by Account Classification
Report
Account Classification
Fund 050 - Water and Sewer Fund
REVENUE
Through 03/31/13
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
Property Taxes
1,516,000.00
.00 1,516,000.00
587,152.22
.00
785,223.97
730,776.03
52
776,955.43
Licenses, Permits & Fees
16,000.00
.00 16,000.00
1,560.00
.00
4,640.00
11,360.00
29
3,230.00
Charges For Services
10,534,000.00
.00 10,534,000.00
845,005.24
.00
3,066,663.90
7,467,336.10
29
2,174,746.00
Fines & Forfeits
125,000.00
.00 125,000.00
10,869.03
.00
28,488.64
96,511.36
23
26,748.19
Investment Income
3,000.00
.00 3,000.00
77.51
.00
167.28
2,832.72
6
6.14
Reimbursements
1,000.00
.00 1,000.00
3,656.26
.00
5,571.68
(4,571.68)
557
.00
Other Revenue
25,000.00
.00 25,000.00
(666.00)
.00
392.48
24,607.52
2
.00
Other Financing Sources
.00
.00 .00
.00
.00
.00
.00
+ ++
.00
REVENUE TOTALS $12,220,000.00
$0.00 $12,220,000.00
$1,447,654.26
$0.00
$3,891,147.95
$8,328,852.05
32%
$2,981,685.76
Fund 050 - Water and Sewer Fund Totals $12,220,000.00
$0.00 $12,220,000.00
$1,447,654.26
$0.00
$3,891,147.95
$8,328,852.05
$2,981,685.76
r
r
OD
Revenue Budget by Account Classification
Report
Through 03/31/13
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
REVENUE
Other Taxes
10,000.00
.00
10,000.00
.00
.00
.00
10,000.00
0
.00
Charges For Services
109,000.00
.00
109,000.00
12,528.60
.00
34,021.00
74,979.00
31
32,921.30
Investment Income
500.00
.00
500.00
3.30
.00
6.40
493.60
1
.00
Other Revenue
6,600.00
.00
6,600.00
550.00
.00
1,650.00
4,950.00
25
.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.
...
.
REVENUE TOTALS
$126,100.00
$0.00
$126,100.00
$13,081.90
$0.00
$
$ 90, 42 2.60
28%
$ 3 2, 921.30
Fund 051- Village Parking System Fund Totals
$126,100.00
$0.00
$126,100.00
$13,081.90
$0.00
$35,677.40
$90,422.60
$32,921.30
Revenue Budget by Account Classification
�.'
Report
Through 03/31/13
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 052 - Parking System Revenue Fund
REVENUE
Other Taxes
90,000.00
.00
90,000.00
.00
.00
.00 90,000.00 0 .00
Intergovernmental Revenue
.00
.00
.00
.00
.00
.00 .00 ... .00
Charges For Services
110,000.00
.00
110,000.00
8,657.95
.00
26,391.28 83,608.72 24 26,358.60
Investment Income
500.00
.00
500.00
1.62
.00
1.62 498.38 0 .00
Other Revenue
.00
.00
.00
.00
.00
.00 .00 + ++ .00
Other Financing Sources
.00
.00
.00
.00
.00
.00 .00 + ++ .00
REVENUE TOTALS $200,500.00 $0.00 $200,500.00 $8,659.57 $0.00 $26,392.90 $174,107.10 13% $26,358.60
Fund 052 - Parking System Revenue Fund Totals $200,500.00 $0.00 $200,500.00 $8,659.57 $0.00 $26,392.90 $174,107.10 $26,358.60
r
N
O
Revenue Budget by Account Classification
Report
Account Classification
Adopted Budget Amended Current Month YTD
Budget Amendments Budget Transactions Encumbrances
Through 03/31/13
Prior Fiscal Year Activity Included
YTD Budget - YTD % used/
Transactions Transactions Recd Prior Year YTO
Fund 060 - Vehicle Maintenance Fund
REVENUE
Charges For Services
2,193,313.00
.00
2,193,313.00
182,776.10
.00
548,328.30
1,644,984.70
25 502,551.21
Investment Income
.00
.00
.00
47.14
.00
121.82
(121.82)
+ ++ 82.15
Other Revenue
.00
.00
.00
138.40
.00
13
(138.40)
+ ++ 797.96
REVENUE TOTALS
$2,193,313.00
$0.00
$2,193,313.00
$182,961.64
$0.00
$548,
$1,644,724.
25% $ 503,431.32
Fund 060 - Vehicle Maintenance Fund Totals
$2,193,313.00
$0.00
$2,193,313.00
$182,961.64
$0.00
$548,588.52
$1,644,724.48
$503,431.32
Revenue Budget by Account Classification
Report
A Classification
Fund 061 - Vehicle Replacement Fund
REVENUE
Through 03/31/13
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
Charges For Services
1,396,600.00
.00
1,396,600.00
116,383.34
.00
349,150.02
1,047,449.98
25
295,949.97
Fines & Forfeits
12,750.00
.00
12,750.00
.00
.00
.00
12,750.00
0
.00
Investment Income
3,500.00
.00
3,500.00
502.37
.00
1,337.44
2,162.56
38
821.85
Other Revenue
.00
.00
.00
.00
.00
.00
.00
...
.00
Other Financing Sources
50,000.00
.00
50,000.00
2,688.57
.00
7,925.97
42,074.03
16
.00
REVENUE TOTALS
$1,462,850.00
$0.00
$1,462,850.00
$119,574.28
$0.00
$358,413.43
$1,104,436.57
25%
$296,771.82
Fund 061- Vehicle Replacement Fund Totals
$1,462,850.00
$0.00
$1,462,850.00
$119,574.28
$0.00
$358,413.43
$1,104,436.57
$296,771.82
N
r
N
N
Revenue Budget by Account Classification
Report
Account Classiflcation
Adopted Budget Amended Current Month YTD
Budget Amendments Budget Transactions Encumbrances
Through 03/31/13
Prior Fiscal Year Activity Included
YTD Budget - YTD % used/
Transactions Transactions Rec'd Prior Year YTD
Fund 062 - Computer Replacement Fund
REVENUE
Charges For Services
.00
.00
.00
.00
.00
.00
.00 + ++
.00
Investment Income
1,000.00
.00
1,000.00
61.94
.00
175.12
824.88 18
123.32
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00 + ++
.00
REVENUE TOTALS
$1,000.00
$0.00
$1,000.00
$61.94
$0.00
$175.12
$824.88 18%
$123.32
Fund 062 - Computer Replacement Fund Totals
$1,000.00
$0.00
$1,000.00
$61.94
$0.00
$175.12
$824.88
$123.32
Revenue Budget by Account Classification
Report
Account Classification
Fund 063 - Risk Management Fund
REVENUE
Through 03/31/13
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
Charges For Services
6,213,501.00
.00
6,213,501.00
490,208.62
.00
1,534,826.64
4,678,674.36
25
1,305,836.62
Investment Income
2,000.00
.00
2,000.00
137.12
.00
411.22
1,588.78
21
328.73
Reimbursements
2,000.00
.00
2,000.00
.00
.00
.00
2,000.00
0
.00
Other Revenue
1
.00
1,452,000.00
127,032.16
.00
336,773.81
1,115,226.19
23
282,612.19
REVENUE TOTALS $7,669,501.00
$0.00
$7,669,501.00
$617,377.90
$0.00
$1,872,011.67
$5,797,489.33
24%
$1,588,777.54
Fund 063 - Risk Management Fund Totals $7,669,501.00
$0.00
$7,669,501.00
$617,377.90
$0.00
$1,872,011.67
$5,797,489.33
$1,588,777.54
N
W
N
dP
Revenue Budget by Account Classification
V Report
Through 03/31/13
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
REVENUE
Charges For Services .00
.00
.00
.00
.00
.00
.00
+ ++ .00
Investment Income 2,274,500.00
.00
2,274,500.00
955,270.90
.00
2,367,008.03
(92,508.03)
104 3,056,863.23
Other Revenue 3,416,221.00
.00
3,416,221.00
1,041,675.69
.00
1,
1, 9 1 5,828.92
44 1,474,801.74
REVENUE TOTALS $5,690,721.00
$0.00
$5,690,721.00
$1,996,946.59
$0.00
$3,8
$1, 823,320.89
6 8% $ 4,531,664.97
Fund 070 - Police Pension Fund Totals $5,690,721.00
$0.00
$5,690,721.00
$1,996,946.59
$0.00
$3,867,400.11
$1,823,320.89
$4,531,664.97
Revenue Budget by Account Classification
Report
Through 03/31/13
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 071 - Fire Pension Fund
REVENUE
Investment Income
2,255,000.00
.00
2,255,000.00
2,242,069.56
.00
2,247,727.92
7,272.08
100
3,064,370.65
Other Revenue
2,932,247.00
.00
2,932,247.00
929,992.06
.00
1,319,996.62
1,612,250.38
45
1,267,505.93
REVENUE TOTALS
$5,187,247.00
$0.00
$5,187,247.00
$3,172,061.62
$0.00
$3,567,724.54
$1,619,522.46
69%
$4,331,876.58
Fund 071- Fire Pension Fund Totals
$5,187,247.00
$0.00
$5,187,247.00
$3,172,061.62
$0.00
$3,567,724.54
$1,619,522.46
$4,331,876.58
Grand Totals $94,742,591.00 070,206.00 $94,912,797.00 $15,772,236.64 $0.00 $27,033,945.24 $67,878,851.76 $26,397,413.99
N
Ln
Expense Budget by Account Classification
r
Report
Through 03/31/13
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 001- General Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
23,392,721.00
.00
23,392,721.00
1,729,273.15
.00
5,114,951.14
18,277,769.86
22 5,147,911.88
Employee Benefits
11,668,453.00
.00
11,668,453.00
2,448,109.13
.00
4,207,439.38
7,461,013.62
36 3,966,784.29
Other Employee Costs
370,429.00
.00
370,429.00
25,362.71
10,415.75
69,650.22
290,363.03
22 64,254.83
Pension Benefits
46,151.00
.00
46,151.00
3,845.81
.00
11,537.43
34,613.57
25 11,500.89
Contractual Services
6,820,106.00
12,000.00
6,832,106.00
548,531.60
652,788.86
1,501,610.38
4,677,706.76
32 1,329,920.17
Utilities
254,847.00
850.00
255,697.00
16,818.49
.00
33,217.77
222,479.23
13 23,092.45
Insurance
344,875.00
.00
344,875.00
28,751.85
.00
86,257.80
258,617.20
25 40,738.14
Commodities & Supplies
608,056.00
.00
608,056.00
45,660.23
46,811.06
100,283.91
460,961.03
24 101,458.58
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
9.94
2,573.93
3,166.54
4,259.53
57 3,153.65
Office Equipment
40,356.00
.00
40,356.00
1,119.96
.00
1,119.96
39,236.04
3 .00
Other Equipment
153,614.00
(2,000.00)
151,614.00
4,456.38
5,899.09
6,864.95
138,849.96
8 13,236.35
Distribution Systems
95,000.00
.00
95,000.00
.00
.00
.00
95,000.00
0 .00
Infrastructure
506,390.00
.00
506,390.00
57,217.60
158,162.35
83,263.65
264,964.00
48 440.00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
... .00
EXPENSE TOTALS
$44,321,998.00
$10,850.00
$44,332,848.00
$4,909,156.85
$876,651.04 $11,219,363.13
$32,236,833.83
27% $10,702,491.23
Fund 001 - General Fund Totals
$44,321,998.00
$10,850.00
$44,332,848.00
$4,909,156.85
$876,651.04 $11,219,363.13
$32,236,833.83
$10,702,491.23
r
N
Expense Budget by Account Classification
Report
Account Classification
Fund 002 - Debt Service Fund
EXPENSE
Contractual Services
Other Expenditures
Bond Principal
Interest Expense
Bank & Fiscal Fees
Interfund Transfers
Other Financing Uses
Through 03/31/13
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 Y E
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
.00
.00
.00
.00
.00
.00
.00
...
.00
1,512,311.00
.00
1,512,311.00
(48,532.68)
.00
19,000.64
1,493,310.36
1
18,377.95
891,882.00
.00
891,882.00
(9,720.11)
.00
643.78
891,238.22
0
1,266.47
1,284.00
.00
1,284.00
.00
.00
428.00
856.00
33
1,837.22
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
.00
.00
.00
.00
.00
.00
.0
+ ++
.
EXPENSE TOTALS $2,405,477.00
$0.00
$2,405,477.00
($58,252.79)
$0.00
$20,072.42
$2,38
1%
$21, 481.64
Fund 002 - Debt Service Fund Totals $2,405,477.00
($0.00)
$2,405,477.00
($58,252.79)
($0.00)
$20,072.42
$2,385,404.58
$21,481.64
Expense Budget by Account Classification
Report
Account Classification
Adopted Budget Amended Current Month YTD
Budget Amendments Bu Transactions Encumbrances
Through 03/31/13
Prior Fiscal Year Activity Included
YTD Budget - YTD % used/
Transactions Transactions Recd Prior Year YTD
Fund 020 - Capital Improvement Fund
EXPENSE
Contractual Services
.00
.00
.00
130.00
(347.01)
19,132.60
(18,785.59)
+ ++
29,177.61
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
...
.00
Land Improvements
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Building Improvements
915,500.00
455,500.00
1,371,000.00
35,090.05
618,292.45
54,000.64
698,706.91
49
31,796.56
Office Equipment
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Motor Equipment
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Other Equipment
389,247.00
14,455.00
403,702.00
10,603.91
13,010.75
31,811.73
358,879.52
11
.00
Infrastructure
370,000.00
166,000.00
536,000.00
977.50
22,702.01
1,558.75
511,739.24
5
8,699.76
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
...
.00
EXPENSE TOTALS
$1,674,747.00
$635,955.00
$2,310,702.00
$46,801.46
$653,658.20
$106,503.72
$1,550,540.08
33%
$69,673.93
Fund 020 - Capital Improvement Fund Totals
$1,674,747.00
$635,955.00
$2,310,702.00
$46,801.46
$653,658.20
$106,503.72
$1,550,540.08
$69,673.93
W
Account Classification
Fund 021 - Series 2009 Construction Fund
EXPENSE
Expense Budget by Account Classification
Report
Through 03/31/13
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
Contractual Services
.00
.00
.00
.00
.00
.00
.00 + ++
.00
Building Improvements
.00
.00
.00
.00
.00
.00
.00 + ++
.00
Office Equipment
.00
.00
.00
.00
.00
.00
.00 ...
.00
Other Equipment
.00
.00
.00
.00
.00
.00
.00 + ++
.
EXPENSE TOTALS
$0.00
$0.00
$0.00
$0.
$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)
Account Classification
Expense Budget by Account Classification
Report
Through 03/31/13
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 022 - Downtown Redevelopment Construct
EXPENSE
Contractual Services
202,990.00
.00
202,990.00
.00
56,950.00
.00
146,040.00
28
.00
Utilities
.00
.00
.00
.00
.00
.00
.00
...
.00
Other Expenditures
2,741,531.00
.00
2,741,531.00
.00
.00
3,642.20
2,737,888.80
0
7,000.00
Infrastructure
348,000.00
.00
348,000.00
.00
.00
.00
348,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
$3,292,521.00
$0.00
$3,292,521.00
$0.00
$56,950.00
$3,642.20
$3,231,928.80
2%
$7,000.00
Fund 022 - Downtown Redevelopment Construct Totals
$3,292,521.00
($0.00)
$3,292,521.00
($0.00)
$56,950.00
$3,642.20
$3,231,928.80
$7,000.00
cn
t•
Account Classification
Fund 023 - Street Improvement Construc
EXPENSE
Expense Budget by Account Classification
Report
Through 03/31/13
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
Contractual Services 30,000.00
.00
30,000.00
.00
19,779.00
.00
10,221.00 66
.00
Infrastructure 1,465,500.00
70,350.00
1,535,850.00
9,107.68
11,835.94
9,107.68
1,514,906.38 1
.00
Interfund Transfers .00
.00
.00
.00
.00
.00
. + ++
.00
EXPENSE TOTALS $1,495,500.00
$70,350.00
$1,565,850.00
$9,107.68
$31,614.94
$9,107.68
$1,525,127.38 3%
$ 0.00
Fund 023 - Street Improvement Construc Fund Totals $1,495,500.00
$70,350.00
$1,565,850.00
$9,107.68
$31,614.94
$9,107.68
$1,525,127.38
($0.00)
Expense Budget by Account Classification
Report
Account Classification
Fund 024 - Flood Control Construction Fund
EXPENSE
Through 03/31/13
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
Contractual Services
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Utilities
2,000.00
.00
2,000.00
.00
.00
.00
2,000.00
0
.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
750,000.00
2,598,800.00
3,348,800.00
55,831.35
53,444.27
55,914.65
3,239,441.08
3
252.52
EXPENSE TOTALS
$757,150.00
$2,598,800.00
$3,355,950.00
$55,831.35
$53,444.27
$55,914.65
$3,246,591.08
3%
$252.52
Fund 024 - Flood Control Construction Fund Totals
$757,150.00
$2,598,800.00
$3,355,950.00
$55,831.35
$53,444.27
$55,914.65
$3,246,591.08
$252.52
J
Expense Budget by Account Classification
Report
Account Classification
Fund 040 - Refuse Disposal Fund
EXPENSE
Through 03/31/13
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
Personal Services, Scheduled Salaries & Wages
230,728.00
.00
230,728.00
19,212.23
.00
53,447.16
177,280.84
23
52,857.33
Employee Benefits
91,728.00
.00
91,728.00
8,027.38
.00
22,609.58
69,118.42
25
21,410.89
Other Employee Costs
1,200.00
.00
1,200.00
.00
.00
.00
1,200.00
0
.00
Contractual Services
4,092,058.00
.00
4,092,058.00
327,715.51
.00
872,974.61
3,219,083.39
21
852,979.85
Utilities
429.00
.00
429.00
35.81
.00
63.28
365.72
15
78.73
Insurance
28,239.00
.00
28,239.00
2,353.25
.00
7,059.75
21,179.25
25
6,832.74
Commodities & Supplies
30,387.00
.00
30,387.00
.00
3,504.80
63 1.70
26,25
14
8,4 96.83
EXPENSE TOTALS
$4,474,769.00
$0.00
$4,474,769.00
$357,344.18
$3,504.80
$956,786.08
$3,514,
21%
$ 9 42, 656.37
Fund 040 - Refuse Disposal Fund Totals
$4,474,769.00
($0.00)
$4,474,769.00
$357,344.18
$3,504.80
$956,786.08
$3,514,478.12
$942,656.37
Expense Budget by Account Classification
Report
Account Classification
Fund 041 - Motor Fuel Tax Fund
EXPENSE
Through 03/31/13
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
Contractual Services
186,302.00
.00
186,302.00
1,254.52
60,925.48
2,868.52
122,508.00
34
3,229.88
Utilities
150,000.00
.00
150,000.00
15,902.42
.00
27,369.01
122,630.99
18
31,940.72
Commodities & Supplies
263,064.00
.00
263,064.00
31,246.82
56,335.55
145,533.35
61,195.10
77
131,577.43
Infrastructure
1,165,000.00
66,000.00
1,231,000.00
.00
.00
.00
1,231,000.00
0
444.00
EXPENSE TOTALS $1,764,366.00
$66,000.00
$1,830,366.00
$48,403.76
$117,261.03
$175,770.88
$1,537,334.09
16%
$167,192.03
Fund 041- Motor Fuel Tax Fund Totals $1,764,366.00
$66,000.00
$1,830,366.00
$48,403.76
$117,261.03
$175,770.88
$1,537,334.09
$167,192.03
0
F-
0
Expense Budget by Account Classification
Account Classification
Fund 042 - Cmmty Development Block Grant
EXPENSE
Through 03/31/13
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
Personal Services, Scheduled Salaries & Wages
47,094.00
.00
47,094.00
3,214.93
.00
9,323.33
37,770.67
20
13,336.72
Employee Benefits
25,198.00
.00
25,198.00
1,987.33
.00
5,907.24
19,290.76
23
7,029.65
Other Employee Costs
1,000.00
.00
1,000.00
342.50
.00
342.50
657.50
34
.00
Contractual Services
92,411.00
10,206.00
102,617.00
267.38
.00
1,467.09
101,149.91
1
22,678.83
Commodities & Supplies
500.00
.00
500.00
52.38
.00
111.37
388.63
22
9.26
Other Expenditures
94,000.00
160,000.00
254,000.00
33,449.60
.00
33,529.60
220,470.40
13
13,255.40
Land Improvements
.00
.00
.00
.00
.00
.00
.00
...
.00
Building Improvements
.00
.00
.00
.00
.00
.00
.00
...
.00
Infrastructure
30,000.00
.00
30,000.00
.00
.00
.00
30,000.00
0
.00
EXPENSE TOTALS
$290,203.00
$170,206.00
$460,409.00
$39,314.12
$0.00
$50,681.13
$409,727.87
11%
$5 6,309.86
Fund 042 - Cmmty Development Block Grant Totals
$290,203.00
$170,206.00
$460,409.00
$39,314.12
($0.00)
$50,681.13
$409,727.87
$56,309.86
Expense Budget by Account Classification
Report
Account Classification
Fund 043 - Asset Seizure Fund
EXPENSE
Other Employee Costs
Contractual Services
Other Equipment
Through 03/31/13
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
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00 0
.00
1,500.00
.00
1,500.00
.00
.00
.00
1,500.00 0
500.00
15,000.00
.00
15,000.00
.00
.00
3,915.00
11,085.00 26
4,139.35
EXPENSE TOTALS $17,500.00
$0.00
$17,500.00
$0.00
$0.00
$3,915.00
$13,585.00 22%
$4,639.35
Fund 043 - Asset Seizure Fund Totals $17,500.00
($0.00)
$17,500.00
($0.00)
($0.00)
$3,915.00
$13,585.00
$4,639.35
F-
r
N
Account Classification
Fund 044 - DEA Shared
EXPENSE
Contractual Services
Building improvements
Other Equipment
Fund
Expense Budget by Account Classification
Report
Through 03/31/13
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
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00 0
.00
.00
.00
.00
.00
.00
.00
.00 + ++
.00
4,000.00
.00
4,000.00
.
. 00
.00
4,000.00 0
.00
EXPENSE TOTALS $5,000.00
$0.00
$5,000.00
$0.00
$0.
$ 0.00
$5,000.00 0%
$0.00
Fund 044 - DEA Shared Funds Fund Totals $5,000.00
($0.00)
$5,000.00
($0.00)
($0.00)
($0.00)
$5,000.00
($0.00)
Expense Budget by Account Classification
M
Account Classification
Adopted Budget Amended Current Month YTD
Budget Amendments Budget Transactions Encumbrances
Through 03/31/13
Prior Fiscal Year Activity Included
YTD Budget - YTD % used/
Transactions Transactions Rec'd Prior Year YTD
Fund 045 - DUI Fine Fund
EXPENSE
Other Employee Costs
Contractual Services
Other Equipment
Interfund Transfers
1,000.00
.00
1,000.00
.00
.00
.00
1,000.00
0
.00
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
10,000.00
.00
10,000.00
1,585.00
.00
1,585.00
8,415.00
16
4,163.65
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
EXPENSE TOTALS $11,000.00
$0.00
$11,000.00
$1,585.00
$0.00
$1,585.00
$9,415.00
14%
$4,163.65
Fund 045 - DUI Fine Fund Totals $11,000.00
($0.00)
$11,000.00
$1,585.00
($0.00)
$1,585.00
$9,415.00
$4,163.65
r
w
r
Expense Budget by Account Classification
Report
Through 03/31/13
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classlflcation Budget Amendments Budget Transactions Encumbrances Transactions Transactions Redd Prior Year YTD
Fund 046 - Foreign Fire Tax Board Fund
EXPENSE
Contractual Services
10,000.00
.00
10,000.00
.00
.00
2,938.44
7,061.56
29
1,974.26
Insurance
500.00
.00
500.00
.00
.00
.00
500.00
0
417.54
Commodities & Supplies
3,000.00
.00
3,000.00
904.50
.00
904.50
2,095.50
30
.00
Other Equipment
15,000.00
.00
15,000.00
187.00
.00
187.00
14,81
1
.
EXPENSE TOTALS
$28,500.00
$0.00
$28,500.00
$1,091.50
$0.00
$4,029.94
$24,47
14%
$2,39
Fund 046 - Foreign Fire Tax Board Fund Totals
$28,500.00
($0.00)
$28,500.00
$1,091.50
($0.00)
$4,029.94
$24,470.06
$2,391.80
Expense Budget by Account Classification
Report
Account Classification
Fund 047 - Justice Assistance Grant Fund
EXPENSE
Through 03/31/13
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
Commodities & Supplies
.00
.00
.00
.00
.00
.00
.00
...
.00
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Office Equipment
.00
836.00
836.00
.00
.00
.00
836.00
0
.00
Other Equipment
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Interfund Transfers
. 00
.00
.00
.00
.00
.00
.00
+ ++
.00
EXPENSE TOTALS
$0.
$ 836.00
$836.00
$0.00
$0.00
$0.00
$836.00
0%
$0.00
Fund 047 - Justice Assistance Grant Fund Totals
($0.00)
$836.00
$836.00
($0.00)
($0,00)
($0.00)
$836.00
($0.00)
r
to
F-
0)
Expense Budget by Account Classification
Report
Through 03/31/13
L iw � l j 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 048 - Business District Fund
EXPENSE
Bond Principal .00
.00
.00
.00
.00
.00
.00 ...
.00
Interest Expense 496,521.00
.00
496,521.00
.00
.00
.00
496,521.00 0
.00
EXPENSE TOTALS $496,521.00
$0.00
$496,521.00
$0.00
$0.00
$0.00
$496,521.00 0%
$0.00
Fund 048 - Business District Fund Totals $496,521.00
($0.00)
$496,521.00
($0.00)
($0.00)
($0.00)
$496,521.00
($0.00)
Expense Budget by Account Classification
Report
Account Classification
Fund 050 -Water and Sewer Fund
EXPENSE
Through 03/31/13
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
Personal Services, Scheduled Salaries & Wages
1,864,275.00
.00
1,864,275.00
152,373.31
.00
457,869.23
1,406,405.77
25
414,350.16
Employee Benefits
734,286.00
.00
734,286.00
65,690.92
.00
190,067.49
544,218.51
26
182,873.49
Other Employee Costs
35,941.00
.00
35,941.00
1,173.35
2,913.75
3,777.70
29,249.55
19
8,151.11
Contractual Services
7,331,906.00
.00
7,331,906.00
516,259.85
390,518.33
1,195,945.63
5,745,442.04
22
966,405.09
Utilities
168,560.00
.00
168,560.00
14,151.50
.00
19,109.11
149,450.89
11
24,133.44
Insurance
79,383.00
.00
79,383.00
6,615.25
.00
19,845.75
59,537.25
25
17,524.50
Commodities & Supplies
297,963.00
.00
297,963.00
5,345.08
60,921.14
19,544.04
217,497.82
27
26,825.53
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
+ ++
.00
Office Equipment
7,104.00
.00
7,104.00
.00
.00
.00
7,104.00
0
.00
Other Equipment
464,503.00
1,370,720.00
1,835,223.00
2,775.00
247,110.02
5,979.19
1,582,133.79
14
58,281.00
Distribution Systems
1,825,000.00
585,685.00
2,410,685.00
17,705.98
411,174.59
19,860.19
1,979,650.22
18
5,699.00
Infrastructure
34,000.00
.00
34,000.00
.00
.00
.00
34,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,8 42, 9 21. 0 0
$1,956,405.00
$14,799,326.00
$782,090.24
$1,112,637.83
$1,931,998.33
$11,754,689.84
21%
$1,704,243.32
Fund 050 -Water and Sewer Fund Totals
$12,842,921.00
$1,956,405.00
$14,799,326.00
$782,090.24
$1,112,637.83
$1,931,998.33
$11,754,689.84
$1,704,243.32
r
r
OD
Expense Budget by Account Classification
1
Report
Through 03/31/13
Prior Fiscal Year Activity Included
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classifica
Budget
Amendments
Budget
Transactions
E n c u m b r ances
Transactions
Transactions Recd Prior Year YTD
Fund 051- Village Parking System Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
21,875.00
.00
21,875.00
1,814.20
.00
5,643.17
16,231.83 26 4,999.45
Employee Benefits
9,860.00
.00
9,860.00
741.98
.00
2,259.53
7,600.47 23 1,532.65
Contractual Services
92,657.00
.00
92,657.00
7,947.05
16,857.41
23,489.35
52,310.24 44 23,513.20
Insurance
1,158.00
.00
1,158.00
96.50
.00
289.50
868.50 25 203.01
Commodities & Supplies
500.00
.00
500.00
.00
.00
.00
500.00 0 .00
Other Expenditures
.00
.00
.00
.00
.00
.00
.00 + ++ .00
Building Improvements
6,800.00
.00
6,800.00
.00
.00
.00
6,800.00 0 .00
Infrastructure
163,500.00
.00
163,500.00
.00
6,750.00
.00
156,750.00 4 .00
Interfund Transfers
.00
.00
.00
.00
.00
.00
. ... .00
EXPENSE TOTALS
$296,350.00
$0.00
$296,350.00
$10,599.73
$23,607.41
$31,681.55
$2 19% $30,248.31
Fund 051- Village Parking System Fund Totals
$296,350.00
($0.00)
$296,350.00
$10,599.73
$23,607.41
$31,681.55
$241,061.04 $30,248.31
Expense Budget by Account Classification
IVIL
Report
Through 03/31/13
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 052 - Parking System Revenue Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
41,661.00
.00
41,661.00
3,234.68
.00
9,787.15
31,873.85 23 9,339.13
Employee Benefits
21,357.00
.00
21,357.00
1,625.46
.00
4,897.50
16,459.50 23 4,166.25
Contractual Services
110,944.00
.00
110,944.00
6,348.81
2,406.93
18,569.81
89,967.26 19 18,560.25
Utilities
10,317.00
.00
10,317.00
1,075.04
.00
1,459.41
8,857.59 14 857.82
Insurance
1,387.00
.00
1,387.00
115.58
.00
346.74
1,040.26 25 284.49
Commodities & Supplies
9,586.00
.00
9,586.00
80.00
.00
1,780.00
7,806.00 19 1,856.60
Other Expenditures
.00
.00
.00
.00
.00
.00
.00 + ++ .00
Building Improvements
100,000.00
.00
100,000.00
.00
.00
.00
100,000.00 0 .00
Infrastructure
.00
.00
.00
.00
.00
.00
.00 + ++ .00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00 + ++ .00
EXPENSE TOTALS
$295,252.00
$0.00
$295,252.00
$12,479.57
$2,406.93
$36,840.61
$256,004.46 13% $35,064.54
Fund 052 - Parking System Revenue Fund Totals
$295,252.00
($0.00)
$295,252.00
$12,479.57
$2,406.93
$36,840.61
$256,004.46 $35,064.54
r
�o
N
O
Account Classification
Fund 060 - Vehicle Maintenance Fund
EXPENSE
Expense Budget by Account Classification
Report
Through 03/31/13
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
Personal Services, Scheduled Salaries & Wages
954,042.00
.00
954,042.00
75,518.82
.00
210,543.66
743,498.34
22
222,847.44
Employee Benefits
392,115.00
.00
392,115.00
32,068.36
.00
90,362.21
301,752.79
23
88,769.64
Other Employee Costs
2,315.00
.00
2,315.00
.00
.00
120.00
2,195.00
5
120.00
Contractual Services
95,738.00
.00
95,738.00
8,069.77
25,416.24
13,875.39
56,446.37
41
13,937.99
Utilities
3,010.00
.00
3,010.00
322.28
.00
785.81
2,224.19
26
196.78
Commodities & Supplies
687,039.00
.00
687,039.00
48,618.44
249,852.61
164,496.33
272,690.06
60
150,091.45
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
18,500.00
.00
18,500.00
.00
.00
.00
18,500.00
0
483.50
EXPENSE TOTALS
$2,153,304.00
$0.00
$2,153,304.00
$164,597.67
$275,2
$
$1,397,851.75
35%
$476,446.80
Fund 060 - Vehicle Maintenance Fund Totals
$2,153,304.00
($0.00)
$2,153,304.00
$164,597.67
$275,268.85
$480,183.40
$1,397,851.75
$476,446.80
Expense Budget by Account Classification
Report
Account Classification
Fund 061 - Vehicle Replacement Fund
EXPENSE
Through 03/31/13
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
Other Expenditures .00
.00
.00
.00
.00
.00
.00 + ++
.00
Motor Equipment 664,000.00
360,900.00
1,024,900.00
630.77
328,171.44
14,446.05
682,282.51 33
6,335.89
Interfund Transfers .00
.00
.00
.00
.00
.00
.00 + ++
.00
EXPENSE TOTALS $664,000.00
$360,900.00
$1,024,900.00
$630.77
$328,171.44
$14,446.05
$682,282.51 33%
$6,335.89
Fund 061- Vehicle Replacement Fund Totals $664,000.00
$360,900.00
$1,024,900.00
$630.77
$328,171.44
$14,446.05
$682,282.51
$6,335.89
N
r
N
N
Expense Budget by Account Classification
Report
Through 03/31/13
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 062 - Computer Replacement Fund
EXPENSE
Other Expenditures .00
.00
.00
.00
.00
.00
.00 + ++
.00
Office Equipment 246,200.00
.00
246,200.00
22,497.57
13,734.65
23,232.22
209,233.13 15
19,982.48
EXPENSE TOTALS $246,200.00
$0.00
$246,200.00
$22,497
$1 3, 7 34.65
$ 23,232.22
$209,233.13 15%
$19,982.48
Fund 062 - Computer Replacement Fund Totals $246,200.00
($0.00)
$246,200.00
$22,497.57
$13,734.65
$23,232.22
$209,233.13
$19,982.48
Expense Budget by Account Classification
Report
Account Classification
Fund 063 - Risk Management Fund
EXPENSE
Through 03/31/13
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
Contractual Services
22,500.00
.00
22,500.00
.00
.00
3,950.00
18,550.00
18
11,000.00
Insurance
7,641,862.00
.00
7,641,862.00
472,641.33
1,393.36
1,963,004.97
5,677,463.67
26
1,892,793.95
Other Equipment
2,000.00
.00
2,000.00
.00
.00
.00
2,000.00
0
.00
Infrastructure
.00
.00
.00
.00
.00
.00
.00
...
.00
EXPENSE TOTALS $7,666,362.00
$0.00
$7,666,362.00
$472,641.33
$1,393.36
$1,966,954.97
$5,698,013.67
26%
$1,903,793.95
Fund 063 - Risk Management Fund Totals $7,666,362.00
($0.00)
$7,666,362.00
$472,641.33
$1,393.36
$1,966,954.97
$5,698,013.67
$1,903,793.95
N
W
N
Expense Budget by Account Classification
Report
Account Classification
Fund 070 - Police Pension
EXPENSE
Pension Benefits
Contractual Services
Insurance
Commodities & Supplies
Other Expenditures
Office Equipment
Through 03/31/13
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 YTC
3,847,666.00
100
3,847,666.00
318,061.46
.00
956,212.02
2,891,453.98
25
907,152.97
121,250.00
.00
121,250.00
1,121.63
.00
3,025.39
118,224.61
2
11,442.25
12,000.00
.00
12,000.00
.00
.00
.00
12,000.00
0
.00
500.00
.00
500.00
.00
.00
.00
500.00
0
.00
12,000.00
.00
12,000.00
.00
.00
520.00
11,480.00
4
902.12
.00
.00
.00
.00
.00
. 00
.00
+ ++
.00
EXPENSE TOTALS $3,993,416.00
$0.00
$3,993,416.00
$319,18
$ 0.00
$959,757.41
$3,033,658.59
24%
$919,497.34
Fund 070 - Police Pension Fund Totals $3,993,416.00
($0.00)
$3,993,416.00
$319,183.09
($0.00)
$959,757.41
$3,033,658.59
$919,497.34
Expense Budget by Account Classification
Report
Account Classification
Fund 071- Fire Pension Fund
EXPENSE
Pension Benefits
Contractual Services
Insurance
Commodities & Suppiles
Other Expenditures
Through 03/31/13
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
3,799,991.00
.00
3,799,991.00
320,336.48
.00
961,034.80
2,838,956.20
25
910,758.87
124,500.00
.00
124,500.00
19,787.36
.00
21,693.13
102,806.87
17
12,423.04
11,500.00
.00
11,500.00
.00
.00
.00
11,500.00
0
.00
1,000.00
.00
1,000.00
.00
.00
32.22
967.78
3
.00
12,000.00
.00
12,000.00
.00
.00
295.00
11,705.00
2
875.00
EXPENSE TOTALS $3,9 4 8,9 91.00
$0.00
$3,948,991.00
$340,123.84
$0.00
$983,055.15
$2,965,935.85
25%
$924,056.91
Fund 071- Fire Pension Fund Totals $3,948,991.00
($0.00)
$3,948,991.00
$340,123.84
($0.00)
$983,055.15
$2,965,935.85
$924,056.91
Grand Totals $93,142,048.00 $5,870,302.00 $99,012,350.00 $7,535,226.92 $3,550,304.75 $19,035,521.52 $76,426,523.73 $17,997,921.92
N
U1
VILLAGE OF MOUNT PROSPECT
List of Bills
March 28 - April 10, 2013
Fund Vendor Name
Invoice Description
Amount
001 General Fund
A & 1 Sewer Service
Triple basin cleaning at Village Hall
$ 330.00
Equipment Maintenance and Repair
305.00
Cleaning of sewer triple basins at Fire Station 14
305.00
Cleaning of sewer triple basins at Police & Fire Building
305.00
Cleaning of sewer triple basins at Public Works
505.00
ACS State & Local Government Solutions
Illinois State Disbursement Unit
3,379.60
ADT Security Services, Inc.
Quarterly billing for fire alarm system monitoring at 10 S. Pine
90.00
Qtrly billing for fire alarm system monitoring at 1015. Maple
90.00
Qtrly billing fire alarm system monitoring @ 1591 S Algonquin Rd
90.00
Aladtec Inc.
Web -based FD Personnel Management Subscription
2,495.00
Alexian Brothers Medical Center
OSHA Required Review of Respirator Questionnaire
24.00
Amer Reprographics Co LIc
Equipment Maintenance
62.00
Anderson Pest Solutions
Payment for pest control training
120.00
Professional Services
48.00
Andres Medical Billing, Ltd.
Ambulance Billing- March 2013
4,924.63
Aramark Uniform Services, Inc.
Uniform cleaning and rental for all public works employees
108.89
Uniform cleaning and rental for all public works employees
111.54
Uniform rental and cleaning for all public works employees
112.87
ARC Disposal Company
Debris Disposal
1,354.76
Armor Systems Corporation
Commission - February, 2013
13.33
AT&T
Service 2/16/13 - 4/15/13
1,533.23
Service 3/16/13 - 4/15/13
341.04
Bald Eagle Window Cleaning
Equipment Maintenance and Repair
1,705.00
Bedco Mechanical
Bi- monthly service to all HVAC units per the HVAC Maintenance Co
2,033.32
BMK Veterinary Associates
Fees for stray dogs - February/March, 2013
301.10
Bonnell Industries Inc.
Snow Plow Blades
304.00
Bright Electrical Supply Co.
Maintenance and repair supplies
121.50
Maintenance and repair supplies
165.69
Maintenance and repair supplies
398.40
Busse's Flowers & Gifts
Kathy Janonis
60.00
Capital One National Association
Costco Purchase 2/26/13 - 3/22/13
709.97
Case Lots, Inc.
Custodial Supplies
250.80
Maintenance and repair supplies
372.00
Custodial supplies used at all buildings
1,982.35
CDW Government, Inc.
Equipment maintenance supplies
25.28
MS Access for PW
122.77
Add'I Websense Lics
537.50
Office Supplies
52.00
Office Supplies
37.66
Central Service Center
Equipment maintenance: radar repair
118.30
Equipment maintenance: radar repair
114.30
Equipment maintenance: radar repair
154.45
Equipment maintenance: radar repair
123.25
Century Cleaners
Uniform Cleaning
6.73
Uniform Cleaning
6.68
Uniform Cleaning
11.18
Uniform Cleaning
20.13
Uniform Cleaning
7.18
Uniform Cleaning
18.63
Uniform Cleaning
16.40
Uniform Cleaning
26.70
Uniform Cleaning
32.53
Uniform Cleaning
14.90
Uniform Cleaning
22.25
Chem -wise Ecological Pest Mgmt Inc
Equipment Maintenance and Repair
215.00
Pest control applied at Public Works
185.01
Equipment Maintenance and Repair
185.01
Chicago Comm. Service, Inc.
Radio maintenance - May, 2013
641.10
Chicago Metro Chapter Apwa
Meeting Expense
60.00
Chicago Office Technology Group
Color Copier Overage 09/12 -12/12
43.05
Overage Usage 06/12 -12/12
1,357.19
Child Care Resource and Referral Network
Course registration for C. Huizar
25.00
Clark, Sandra M.
Meeting Expenses
65.00
Clifford -Wald & Co., Inc. -A KIP Company
Engineering Supplies
181.20
Commonwealth Edison
Electrical Service Delivery
25.78
Electrical Service Delivery
15.75
Electrical Service Delivery
25.78
Electrical Service Delivery
25.78
Crystal Maintenance Services Corp.
Monthly bill for janitorial services at 10 buildings
6,657.01
D.1.'s Scuba Locker
Quarry Dive Fees for Schmitt & Wnek (4/2/13 Dive Class)
60.00
Scuba Tank Rentals for Wnek & Schmitt (ERDI Class)
56.00
Page 1 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
March 28 - April 10, 2013
Fund
Vendor Name
Invoice Description
Amount
Dahm, Patricia
Refund 2013 Spring Planting Program
150.00
De Lage Landen Financial Services, Inc.
3/1/13 - 3/31/13 Lease
1,311.00
4/1/13 - 4/31/13 Lease
1,311.00
Discount Media Products, LLC
Disc Duplicator & Printer
1,925.00
Dreisilker Electric Motors, Inc.
Maintenance and repair supplies
153.12
Eisen, Barry
Safety Shoes Reimbursement
174.39
El Metennani, Maura
Professional Services
3,120.00
Elgin Community College
Fire Prev Principles Registration for L. Miller (3/18- 22/13)
275.00
ERC Wiping Products Inc.
Drying towels for rigs
158.00
Eterno, David G.
Legal
601.50
Everbank Commercial Finance, Inc.
Copy Machine Usage 4/24/13
451.02
Experian
Background checks - Feb /March, 2013
78.68
Federal Express Corp
Fidelity 3/8;3/11;3/12;3 /13;3/14
45.70
Shipping Charges (1 Package to Sensit Technologies)
23.87
Fidelity 3/15;3/18;3/19;3 /20;3/21
47.76
Fidelity shipments 3/22;3/25;3/26;3 /27;3/28/13
33.10
Fire Pension Fund
Fire Pension
21,335.46
Frank, Anthony
Refund Overpayment Police Ticket # P3924002
50.00
Garelli Wong & Associates, Inc.
Julie DeMaria wk. end 1/27/13
617.40
Julie DeMaria & Linda Fry wk. end 2/17/13
1,598.63
Julie DeMaria & Linda Fry wk. ending 3/17/13
1,659.27
Garvey's Office Products
Office Supplies
129.52
GE Capital
Period 3/15/13 - 4/14/13
853.11
Gliner, Joseph
Reimburse training expenses
24.00
Grainger Inc.
Equipment Maintenance and Repair
30.65
Great Lakes Snow Systems, Inc.
Monthly bill for 2013 Snow Removal Contract
6,625.00
Final monthly bill for snow removal
6,625.00
Guardian
Emp. Dental Plan April 2013
8,749.68
Healy Asphalt Company,llc.
Asphalt patching material used for street patching
1,021.44
Asphalt patching material used for street patching
1,041.92
Homer Tree Care, Inc.
Tree Removal
12,294.05
Tree Removal
608.00
Tree Removals
1,543.00
IACE
Qtrly. Mtg. Registration - Garcia, Scherbaum, Hernandez, Panek
140.00
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
17,364.28
ILEETA
Conference registration & membership: J. Garris
407.00
Illinois American Water Company
Private Fire Service April 12013
33.84
Illinois Department of Revenue
IL State Withholding
34,931.55
Illinois Fire Chiefs Educ. & Research Foundation
IFCA Annual Symposium Reg. for J. Malcolm (May 22 -24, 2013)
125.00
IMRF
IMRF
195,724.45
Industrial Systems, Ltd
Liquid de -icer used for snow and ice control
3,916.00
Liquid de -icer used for snow and ice control
1,168.00
Internal Revenue Service
Federal Withholding
162,734.58
International Association of Fire Chiefs
FRI Registration for J. Malcolm (August 13 -17, 2013)
615.00
International Council of Shopping Centers
Membership Dues - WJC
270.00
International Union of Operating Engineers
IUOE PW Membership Dues
578.24
J and N Enterprises, Inc.
Sensit Meter Repair
130.19
Jackson- hirsh,Inc.
Office Supplies
125.88
Janonis, Michael E.
YOTI trial prep
183.99
Jarquin, Carlos Lopez
Refund Overpayment Police Ticket #C58357
5.00
Journal & Topics Newspapers
Legal notice
144.48
Journal of Light Construction
1 Yr. Subscription
14.99
Kerstein, June
Reimburse Food Expense March 2013
23.56
Kidd, Daniel
Reissue Reimbursement AP Check #774211
80.00
Konica Minolta Business Solutions USA Inc
Annual maintenance agreement for Records' microfilm reader
820.00
Kramer Tree Specialists
Tree Trimming
3,920.00
Tree Trimming
9,324.00
L & B Business Services Inc.
Maintenance and repair supplies
17.97
Lands' End Business Outfitters
2012 Invoice - Credit
(23.50)
Laner Muchin
Legal
3,504.00
Lexisnexis Risk Data Management Inc.
Background checks - March, 2013
107.00
Linda S. Pieczynski, Attorney At Law, P.C.
Subscription renewal: Roll Call News
70.00
Lindco Equipment Sales, Inc.
Plow blade hinges, bolts and nots for Flink plows
447.74
2753 Plow controller
1,343.91
Maev, Nevelina
Refund Vehicle License Fee
36.00
Martam Construction
Contractual Hauling
6,382.56
Mazursky, Shelby
Printing Expenses
89.50
Printing Expense
195.00
McDonald's Corporation
Prisoner meals - February, 2013
340.88
Menards
Maintenance and repair supplies
34.98
Shelves for Investigations
55.98
Page 2 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
March 28 - April 10, 2013
Fund
Vendor Name
Invoice Description
Amount
Metro Federal Credit Union
MP Fire Local 4119 Dues
2,278.82
Metropolitan Alliance - Police
MP Police Association Dues
1,321.00
Metropolitan Fire Chiefs Assoc
Spring Symposium Registration for D. Wisniewski (3/13/13)
60.00
Meyer Laboratory, Inc.
Cleaning supplies to be used in all buildings
407.14
Michael Wagner & Sons, Inc.
Maintenance and repair supplies
53.89
Michalik, Joel
COL Reimbursement
30.00
Engineering Equipment
30.45
Microsystems Inc.
Records Mgmt (Off -Site Storage of Incident Reports)
155.00
Mobile Print Inc.
Kast pads
17.95
Note Sheets - Moder
17.94
Memo Pads - Nell
17.94
Office Supplies
33.56
Printing Expense
33.56
Business Cards - Moder
33.56
Nell cards
33.57
Moore Landscapes, Inc.
Landscaping Maintenance
2,523.12
Morgan, Dean
Safety Shoe Reimbursement
156.97
Morton Suggestion Co.
CPU public relations supplies
469.00
Mount Prospect Paint, Inc.
Maintenance and repair supplies
247.72
Maintenance and repair supplies
89.90
Mount Prospect Public Library
Fiber Optic For Village Hall 1/6/13- 4/15/13
1,759.89
Fiber Optic For CC Center 1/16/13- 4/15/13
768.18
National Notary Assoc.
Membership - Claire Wheatley
52.00
Nationwide Mutual Insurance Company
Nationwide 457 (flat amount)
12,987.95
NCPERS Group Life Ins.
IMRF Life Insurance
667.20
Neopost USA Inc.
Postage Machine Replenishment 03/29
3,000.00
NICOR
Natural Gas Consumption
423.42
Natural Gas Consumption
67.37
Natural Gas Consumption
82.01
Natural Gas Consumption
101.96
North East Multi Regional Trng
Annual training membership
7,650.00
Course registration for S. Burrell
50.00
Northshore University Healthsystem
Medical exam: J. Kanupke
96.00
Pre - employment physical: M. Witkowska
860.00
Northwest Central Dispatch System
May 2013 - Member Assessment
55,401.84
Northwest Suburban United Way
United Way
252.10
Overhead Garage Door, Inc.
Repair Overhead Door
314.00
Pacific Telemanagement Services
Service 4/1/13 - 4/30/13
78.00
Paddock Publications, Inc.
Bid Notice
48.60
Petty Cash
Petty Cash
132.75
Petty Cash - Public Works
129.21
Pitney Bowes
E -Z Seal Solution for Folding/Stuffing Machine
71.99
Police Pension Fund
Police Pension
29,512.15
Quill Corporation
Office Supplies
26.96
Reliance Standard Life Insurance Co.
Short Term Disability
597.72
Secretary of State
H352208 - 526 - 2013 License Plate Sticker Renewal
101.00
6329272 - S32 - 2013 License Plate Sticker Renewal
101.00
Signs By Tomorrow
Special Events Supplies
285.10
Sill, Gregory
Reimburse expenses: Dry cleaning
60.00
Simmons, Brian
Reimbursement for training
880.00
Southern WI Northern IL Fire Rescue Association
Annual Membership (April 1, 2013 -April 30, 2014)
25.00
Standard Equipment Company
4504 Drain plug
56.46
State of Illinois
Internet Service
1,175.00
Steiner Electric Company
Street light supplies
247.12
Stephen A. Laser Assoc.,p.c.
Pre - employment testing: M. Witkowska
550.00
T.P.I.
Building Inspections
18,624.50
The Betty Mills Company, Inc.
Floor Squeegees
226.02
The File Mart
2012 Expense - Tabs
83.58
The Ups Store
Legal mailing
22.89
TLO, LLC
Background checks - March, 2013
111.50
Traffic Control & Protection Inc
Sign stock supplies to make new signs throughout the year
8,399.25
U.S. Bank Equipment Finance, Inc.
Usage 4/16/2013 -1700 W Central Road
167.50
Copy Machines - Usage 4/20/13
1,362.28
Usage 4/22/13 -1601 West Golf Road
138.78
Page 3 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
March 28 - April 10, 2013
Fund Vendor Name
Invoice Description
Amount
University of Wisconsin System
Course Fee - WMS
1,195.00
VCG Uniform
Uniform supplies
164.80
Verizon Wireless Services LLC
Verizon Wireless Feb 20 - Mar 19
6,388.35
Veterans of Foreign Wars Post 1337
Memorial Day Parade
1,100.00
Village of Mount Prospect
Flex - Parking
9,201.18
Warehouse Direct
Office Supplies
259.82
Office Supplies
232.90
Office Supplies
8.96
Office Supplies
477.44
Office Supplies
192.80
Office Supplies
75.41
Toner cartridge
170.56
Office Supplies
100.83
Office Supplies
49.46
Admin. office equipment
135.00
Office equipment
8.73
Office Supplies
(75.01)
Wisconsin Department of Revenue
WI State Withholding
391.43
WISCTF
Garnishment
542.48
Zaerzadeh, Ali
White Cotton Gloves
206.35
001 General Fund Total
$
732,978.68
020 Capital Improvement Fund
Business Office Systems, Inc.
Building Improvements
$
310.05
Flooring Resources Corp.
Building Improvements
2,076.47
Frostline, Inc.
New Projector screens for Board Room
2,005.00
Northwest Central 9 -1 -1 System
Motorola Subscriber Financing - April 2013
10,603.91
020 Capital Improvement Fund Total
$
14,995.43
022 Downtown Redevelopment Construction Fund
Moore Landscapes, Inc.
Landscaping Maintenance
$
6,261.08
022 Downtown Redevelopment Construction Fund Total
$
6,261.08
023 Street Improvement Construction Fund
Illinois State Treasurer
Traffic Improvements
$
9,107.68
023 Street Improvement Construction Fund Total
$
9,107.68
024 Flood Control Construction Fund
Constellation NewEnergy, Inc.
Electrical Service Delivery
$
116.01
Electrical Service Delivery
50.78
024 Flood Control Construction Fund Total
$
166.79
040 Refuse Disposal Fund
AT&T
Service 2/16/13 - 4/15/13
$
8.53
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
17.57
Illinois Department of Revenue
IL State Withholding
374.78
IMRF
IMRF
3,428.81
Internal Revenue Service
Federal Withholding
2,499.00
International Union of Operating Engineers
IUOE PW Membership Dues
61.98
Nationwide Mutual Insurance Company
Nationwide 457 (flat amount)
44.99
NCPERS Group Life Ins.
IMRF Life Insurance
8.00
Northwest Suburban United Way
United Way
3.85
Reliance Standard Life Insurance Co.
Short Term Disability
23.66
Village of Mount Prospect
Flex - Parking
34.16
040 Refuse Disposal Fund Total
$
6,505.33
041 Motor Fuel Tax Fund
Commonwealth Edison
Electrical Service Delivery
$
45.56
Constellation NewEnergy, Inc.
Electrical Service Delivery
2,622.52
Vehicle Maintenance Supplies
96.38
Electrical Service Delivery
132.88
Electrical Service Delivery
37.99
Electrical Service Delivery
189.20
Electrical Service Delivery
78.10
Electrical Service Delivery
86.86
Electrical Service Delivery
121.41
Electrical Service Delivery
131.81
Electrical Service Delivery
280.41
Electrical Service Delivery
145.20
Electrical Service Delivery
137.14
Electrical Service Delivery
157.71
Page 4 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
March 28 - April 10, 2013
Fund Vendor Name Invoice Description Amount
Industrial Systems, Ltd Liquid de -icer used for snow and ice control 790.00
Morton Salt, Inc Road salt for snow and ice control 1,196.67
Road salt used for snow and ice control 13,034.16
041 Motor Fuel Tax Fund Total $ 19,284.00
042 Community Development Block Grant
GE Capital
Period 3/15/13 - 4/14/13
$ 213.27
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
112.51
Illinois Department of Revenue
IL State Withholding
65.63
IMRF
IMRF
553.30
Internal Revenue Service
Federal Withholding
423.92
Reliance Standard Life Insurance Co.
Short Term Disability
34.76
Saewert, Janet
CDBG CAPER printing expense
186.18
Village of Mount Prospect
Flex - Parking
56.25
042 Community Development Block Grant Total
$ 1,645.82
050 Water and Sewer Fund
Addison Building Material Co.
Supply Maintenance and Repair
$ 37.21
Supply Maintenance and Repair
54.42
Supply Maintenance and Repair
117.99
Supply Maintenance and Repair
(51.09)
American Building Services
Equipment Maintenance
841.50
American Water Works Assoc.
Equipment maintenance supplies
317.00
Training Supplies
368.00
American Waterworks Assoc.
Training Expense
200.00
Training Expense
50.00
Aramark Uniform Services, Inc.
Uniform cleaning and rental for all public works employees
108.90
Uniform cleaning and rental for all public works employees
111.55
Uniform rental and cleaning for all public works employees
112.87
AT&T
Service 2/16/13 - 4/15/13
569.36
Breitzman, lames
Cellular Telephone Supplies
127.51
Burns & Mcdonnell Engineering Co.
Sewer Contractual Services
4,446.00
Century Cleaners
Uniform Cleaning
6.72
Uniform Cleaning
6.67
Uniform Cleaning
11.17
Uniform Cleaning
20.12
Uniform Cleaning
7.17
Uniform Cleaning
18.62
Uniform Cleaning
16.40
Uniform Cleaning
26.70
Uniform Cleaning
32.52
Uniform Cleaning
14.90
Uniform Cleaning
22.25
Edward Graham
Utility Refund -18 N Lancaster St
2.20
Errol Oztekin
Utility Refund -108 N Kenilworth Ave
137.67
Federal Express Corp
Shipping Charges
56.29
Fed'I Home Loan Mort Corp
Utility Refund - 925 Country Ln
1.80
Fed'I Home Loan Mortgage
Utility Refund - 311 Eastwood Ave
19.46
Garvey's Office Products
Office Supplies
129.52
HBK Water Meter Service
Water Meter and Building Inspection Services
131.00
Water Meter and Building Inspection Services
131.00
Water Meter and Building Inspection Services
167.00
Water Meter and Building Inspection Services
131.00
Water Meter and Building Inspection Services
131.00
Water Meter and Building Inspection Services
123.00
Water Meter and Building Inspection Services
165.00
Water Meter and Building Inspection Services
131.00
Water Meter and Building Inspection Services
131.00
Highway Technologies, Inc.
Purchase of emergency barricades with lights
1,124.50
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
1,202.71
Illinois Department of Revenue
IL State Withholding
2,910.21
IMRF
IMRF
26,507.73
Internal Revenue Service
Federal Withholding
17,913.06
International Union of Operating Engineers
IUOE PW Membership Dues
493.36
J.F. New & Associates, Inc.
Professional Services
1,695.00
Jennie Dornseifer
Utility Refund -1436 Picadilly Cir
43.39
Jjs Global Ventures Inc
Equipment Maintenance and Repair
126.45
Lands' End Business Outfitters
Replacement Shirts for PW Staff
763.75
Lee Jensen Sales Co. Inc.
Repair Maintenance Supplies
1,885.00
Lindco Equipment Sales, Inc.
Plow blade hinges, bolts and nots for Flink plows
465.26
Martam Construction
Contractual Hauling
2,279.98
Metrics AMI Consulting Group, Inc.
Professional Services
2,000.00
Microsystems Inc.
Records Management
6,322.22
Moore Landscapes, Inc.
Landscaping Maintenance
560.69
Page 5 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
March 28 - April 10, 2013
Fund Vendor Name
Invoice Description
Amount
Nationwide Mutual Insurance Company
Nationwide 457 (flat amount)
American Messaging
358.89
NCPERS Group Life Ins.
IMRF Life Insurance
526 Mirror cover
57.60
NICOR
Natural Gas Consumption
10.86
122.20
Vehicle Maintenance Supplies
Natural Gas Consumption
105.72
22.86
Natural Gas Consumption
Equipment Maintenance and Repair
209.56
Northwest Suburban United Way
United Way
323.00
8.00
Paddock Publications, Inc.
Bid Notice
Atlas Bobcat Inc.
89.10
Reliance Standard Life Insurance Co.
Short Term Disability
Equipment Maintenance and Repair
16.52
Salvatore Bartolini
Utility Refund - 1406 Linneman Rd
8.00
Sarah Olszewski
Utility Refund - 117 Stevenson Ln
5.33
Steve Tziforos
Utility Refund - 218 S Wille St
60.25
Steve Welter
Utility Refund - 503 N Main St
42.52
Suburban Laboratories, Inc.
Annual IEPA- Required Water Sample Testing
153.50
Annual IEPA- Required Water Sample Testing
108.50
Third Millennium Assoc.inc.
March 2013 Utility Billing
2,383.23
March 2013 Utility Billing (Refuse Only)
786.15
U.S. Bank Equipment Finance, Inc.
Usage 4/16/2013 -1700 W Central Road
167.50
Copy Machines - Usage 4/20/13
137.50
Verizon Wireless Services LLC
Verizon Wireless Feb 20 - Mar 19
579.57
Village of Mount Prospect
Flex - Parking
633.77
Warehouse Direct
Office Supplies
477.44
Ziebell Water Service Products
Hydrant Maintenance and Repair
54.00
Repair Maintenance Supplies
975.00
050 Water and Sewer Fund Total
$
83,015.56
051 Village Parking System Fund
Chem -wise Ecological Pest Mgmt Inc
Pest control applied at Public Works
$
29.99
Equipment Maintenance and Repair
29.99
Crystal Maintenance Services Corp.
Monthly bill for janitorial services at 10 buildings
1,844.16
Illinois Department of Revenue
IL State Withholding
29.50
IMRF
IMRF
314.27
Internal Revenue Service
Federal Withholding
182.49
International Union of Operating Engineers
IUOE PW Membership Dues
9.92
Nationwide Mutual Insurance Company
Nationwide 457 (flat amount)
21.95
NCPERS Group Life Ins.
IMRF Life Insurance
1.92
Village of Mount Prospect
Flex - Parking
13.50
051 Village Parking System Fund Total
$
2,477.69
052 Parking System Revenue Fund
Constellation NewEnergy, Inc.
Electrical Service Delivery
$
235.97
Electrical Service Delivery
105.44
Crystal Maintenance Services Corp.
Monthly bill for janitorial services at 30 buildings
263.83
Illinois Department of Revenue
IL State Withholding
54.94
IMRF
IMRF
558.22
Internal Revenue Service
Federal Withholding
327.74
International Union of Operating Engineers
IUOE PW Membership Dues
6.61
Nationwide Mutual Insurance Company
Nationwide 457 (flat amount)
14.67
NCPERS Group Life Ins.
IMRF Life Insurance
1.28
NICOR
Natural Gas Consumption
250.22
Union Pacific Railroad
Add'I Land Lease for Dec. 2012
181.82
February Land Lease
3,015.38
Village of Mount Prospect
Flex - Parking
61.10
052 Parking System Revenue Fund Total
$
5,077.22
060 Vehicle Maintenance Fund
Acme Truck Brake & Supply Co.
Vehicle Maintenance Supplies
$ 34.70
American Messaging
Pager rental
69.81
Arlington Heights Ford
526 Mirror cover
12.98
P -5 trim plate
10.86
Vehicle Maintenance Supplies
(12.98)
Amb rear axle gaskets
22.86
Equipment Maintenance and Repair
49.71
Arlington Power Equipment
Vehicle Maintenance Supplies
323.00
AT & T
Service 2/16/13 - 4/15/13
21.33
Atlas Bobcat Inc.
Vehicle Maintenance Supplies
117.52
Bridgestone Retail Operations, LLC.
Equipment Maintenance and Repair
66.00
Page 6 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
March 28 - April 10, 2013
Fund Vendor Name
Invoice Description
Amount
Chicago International Truck
4513 Turn signal switch
105.53
Turn signal switch
102.53
Fuel Filters
29.96
4512 Turn signal lights
108.54
544 air compressor
350.84
4512 air seat valve
69.39
4512 air valve
31.41
4522 fuel and oil filters
47.69
Vehicle Maintenance Supplies
(465.50)
Chicago Parts & Sound Llc
Vehicle Maintenance Supplies
(144.00)
3 Squad batteries
291.48
Squad headlight connectors
38.32
Squad brake rotors and pads
230.94
P -1 window motor
131.83
Fleetpride, Inc.
Vehicle Maintenance Supplies
39.50
Foster Coach Sales Inc.
526 Drivers mirror panel
88.15
Garvey's Office Products
Office Supplies
111.18
Getz Fire Equipment Co.
Vehicle Maintenance Supplies
499.20
Global Emergency Products
530 passenger mirror
136.45
530 Rear marker light
67.09
515 Latch
42.40
518 Replace both steering gear boxes with new ones
5,358.00
Equipment Maintenance and Repair
87.24
Grossinger Chevrolet
P -42 coolant hoses
31.88
ICMA Retirement Trust -457
ICMA 457 (flat percent)
523.58
Illinois Department of Revenue
IL State Withholding
1,536.32
IMRF
IMRF
13,475.63
Inland Power Group Inc.
Vehicle Maintenance Supplies
(16.13)
Allison OEM transmission filters
327.32
Internal Revenue Service
Federal Withholding
9,260.25
International Union of Operating Engineers
IUOE PW Membership Dues
261.22
Interstate Battery
Truck Batteries
423.80
Just Tires
Vehicle Maintenance Supplies
223.00
Vehicle Maintenance Supplies
97.92
Leach Enterprises, Inc.
Vehicle Maintenance Supplies
185.70
Vehicle Maintenance Supplies
171.70
Lindco Equipment Sales, Inc.
Vehicle Maintenance Supplies
328.75
Vehicle Maintenance Supplies
345.78
Lund Industries, Inc.
Vehicle Maintenance Supplies
256.00
Vehicle Maintenance Supplies
192.00
Vehicle Maintenance Supplies
155.36
Vehicle Maintenance Supplies
155.36
Mazursky, Shelby
Vehicle Maintenance Supplies
420.00
Mcmaster -carr Supply Co.
Sandblaster Media
71.46
Morton Grove Automotive
Fire Safety Trailer - Rebuild jack motor
125.00
Police alternator rebuild
185.00
Napa- Heights Automotive Supply
Vehicle Maintenance Supplies
207.48
Vehicle Maintenance Supplies
(207.48)
526 wiper blades
33.08
Oil filters
12.48
Fuel Filters
21.24
Fuel Filters
21.24
2720 Door shocks
120.13
2720 Door support
29.88
Amb axle seals
90.68
Nationwide Mutual Insurance Company
Nationwide 457 (flat amount)
70.00
NCPERS Group Life Ins.
IMRF Life Insurance
48.00
Northwest Suburban United Way
United Way
3.85
Pomp's Tire Service, Inc.
Vehicle Maintenance Supplies
643.51
4516 tire repair
142.00
Vehicle Maintenance Supplies
294.88
Prairie International Truck Sales
OEM Oil and fuel filters
368.40
OEM oil filters
221.92
OEM fuel filters and gaskets
161.03
Page 7 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
March 28 - April 10, 2013
Fund Vendor Name
Invoice Description
Amount
Precision Service & Parts
Amb brake pads
57.73
P -5 front brake pads
59.95
1 -30 brake pads and rotors
342.73
1 -30 and stock -brake pads and rotors
207.55
2707 Rear wiper motor
177.37
Squad brake pads and rotors
241.40
Vehicle Maintenance Supplies
(3S.00)
P -1 window motor
102.27
Oil filters and brake pads
158.44
2749 Headlight switch
97.30
T -39 belt tensioner
37.75
T -39 AC condenser
251.53
T -39 seal kit
41.60
Quill Corporation
Office Supplies
107.82
R.A. Adams Enterprises
Vehicle Maintenance Supplies
39.40
Runnion Equipment Co
4558 annual OSHA inspection and repairs needed
1,251.18
Terrace Supply Company
Torch and welding gas
263.14
Vehicle Maintenance Supplies
39.15
Vehicle Maintenance Supplies
463.23
Vehicle Maintenance Supplies
122.65
The Standard Companies
Vehicle Maintenance Supplies
382.10
Vehicle Maintenance Program Inc.
Vehicle Maintenance Supplies
272.50
Vehicle Service Profits, LLC
Vehicle Gas
188.26
Verizon Wireless Services LLC
Verizon Wireless Feb 20 - Mar 19
348.61
Village of Mount Prospect
Flex - Parking
271.67
Warehouse Direct
Office Supplies
238.72
West Side Tractor Sales
Loader bucket skid shoes
499.17
Williams, Harvey
Vehicle Maintenance Supplies
38.78
Winter Equipment Company Inc
Vehicle Maintenance Supplies
369.52
060 Vehicle Maintenance Fund Total
$
45,729.70
061 Vehicle Replacement Fund
Bonnell Industries Inc.
Equipment Public Works Vehicles
$
345.00
Liebovich Bros, Inc.
Equipment for Public Works Vehicles
486.14
Ziebart
Equipment for Public Works Vehicles
450.00
061 Vehicle Replacement Fund Total
$
1,281.14
063 Risk Management Fund
International Union of Operating Engineers
PW Insurance - June 2013
$
42,750.00
The Cima Companies, Inc.
Volunteer Insurance Renewal 7/1/13 - 7/1/14
2,245.00
063 Risk Management Fund Total
$
44,995.00
070 Police Pension Fund
Reimer & Karlson LLC
Quarterly Retainer Fee April -June 2013
$
750.00
William C. Malik, M.d.
Medical Examinations - Joseph Favia
650.00
070 Police Pension Fund Total
$
1,400.00
071 Fire Pension Fund
Werderitch, Randall C.
2013 15t Quarter Admin Assistance Fee
$
300.00
071 Fire Pension Fund Total
$
300.00
073 Escrow Deposit Fund
Adams Roofing
Refund Escrow Permit # 12 -1927
$
125.00
American Deck Builders Inc
Refund Escrow Permit # 12 -2203
125.00
Bradford and Kent Builders
Refund Escrow Permit # 12 -2004
150.00
Caldrone, Robert F
Refund Escrow Permit # 13 -0226
125.00
Capps Plumbing and Sewer Inc
Refund Escrow Permit # 12 -1924
75.00
Refund Escrow Permit # 13 -0216
12S.00
Refund Escrow Permit # 13 -0287
125.00
Refund Escrow Permit # 13 -0304
125.00
Chicagoland Total Basement Finishing
Refund Escrow Permit # 12 -0313
100.00
Chitulescu, Constantin
Refund Escrow Permit # 12 -2211
125.00
Clover Signs
Refund Escrow Permit # 13 -0045
125.00
Dower, John L
Refund Escrow Permit # 12 -2244
125.00
Doyle Signs Inc
Refund Escrow Permit # 12 -2271
125.00
Dreammaker Bath & Kitchen
Refund Escrow Permit# 13 -0043
250.00
Fernandez, Jorge
Refund Escrow Permit # 13 -0310
125.00
Feze Roofing
Refund Escrow Permit # 12 -0094
125.00
Flush Sewer & Drainage
Refund Escrow Permit # 13 -0194
125.00
Fricke, Mark
Refund Escrow Permit # 12 -0403
200.00
Friestedt, Julie L
Refund Escrow Permit # 13 -0180
125.00
Great Degrees
Refund Escrow Permit # 13 -0217
125.00
Guigova, Dessislava
Refund Escrow Permit # 13 -0168
125.00
Harney, Roger James
Refund Escrow Permit # 13 -0227
125.00
Page 8 of 9
VILLAGE OF MOUNT PROSPECT
List of Bills
March 28 - April 10, 2013
Fund Vendor Name
Invoice Description
Amount
Hofert, Daniel C
Refund Escrow Permit # 11 -2203
75.00
Hyundai Plumbing
Refund Escrow Permit # 13 -0224
75.00
Ibbotson Heating Company
Refund Escrow Permit # 13 -0178
125.00
IC Signs & Graphics
Refund Escrow Permit # 12 -1805
125.00
Illinois State Police
Seized Assets I.S.P #122053
4,460.00
Insurance Services Construction Inc
Refund Escrow Permit # 11 -1468
250.00
K & D Market Leaders
Refund Escrow Permit # 12 -0704
175.00
Larson, John
Refund Escrow Permit # 13 -0230
125.00
Michael's Roofing & Exteriors LLC
Refund Escrow Permit # 12 -0294
125.00
Miro, Douglas
Refund Escrow Permit # 13 -0297
125.00
Mr Mighty Electric
Refund Escrow Permit # 11 -1239
75.00
Mugnaini, John
Refund Escrow Permit # 13 -0239
125.00
North Shore Electric Inc
Refund Escrow Permit # 13 -0242
75.00
Rays Heating & A/C
Refund Escrow Permit # 13 -0295
125.00
Regal Roofing Service
Refund Escrow Permit # 13 -0221
125.00
Refund Escrow Permit # 13 -0271
125.00
Ro Pro Electric Inc
Refund Escrow Permit # 12 -0221
125.00
SB Signs & Apparel
Refund Escrow Permit # 13 -0002
125.00
Solar Services Inc
Refund Escrow Permit # 12 -0243
150.00
Splinter, Brian
Refund Escrow Permit # 12 -0908
25.00
Starlight Home Improvement Inc
Re -issue Refund Escrow Check #772008
125.00
The Home Depot
Refund Escrow Permit # 12 -0142
125.00
The Sign Palace Inc
Refund Escrow Permit # 12 -0631
125.00
Third District Circuit Court
Bond Check 3/28/13
610.00
Bond Check 4/2/13
760.00
Bond Check 4/4/13
1,475.00
Bond Check 4/9/13
1,890.00
US Water Proofing Inc
Refund Escrow Permit # 12 -0291
125.00
Village Sewer & Plumbing
Refund Escrow Permit # 13 -0252
125.00
Watertight Exteriors
Refund Escrow Permit # 12 -0198
125.00
073 Escrow Deposit Fund Total
$ 15,120.00
Grand Total
$ 990,341.12
Page 9 of 9