HomeMy WebLinkAbout3. Monthly Financial Report and Approve BillsVillage of Mount Prospect
Mount Prospect, Illinois
INTEROFFICE MEMORANDUM
TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES
FINANCE COMMISSION
FROM: FINANCE DIRECTOR
DATE: OCTOBER 16, 2015
SUBJECT: MONTHLY FINANCIAL REPORT — SEPTEMBER 2015
Attached hereto are the cash position and investment statements of the Village for the month
ended September 30, 2015. These statements provide a snapshot of the Village's cash position
as of the month end date noted and are intended to supplement the budget revenue and
expenditure summary and listing of bills you receive. The first statement presents the Village's
cash position broken down by governmental and enterprise funds and trust and agency funds.
The second statement presents the Village's cash position by fund type. The third statement
presents the list of investments again broken down by governmental and enterprise funds and
trust and agency funds. It is important to note that although we have included the trust and
agency funds in the cash position report, these funds are not accessible for Village operations.
They are restricted for pension and escrow funding only. Please read the summary that follows
for further detail on the cash position of the Village.
Cash and Investment Position Report —All Funds (page 1)
This report provides a detail summary of cash and investments for the Village broken out by
governmental and enterprise funds and trust and agency funds. Governmental funds include
the General Fund, Special Revenue Funds, Debt Service Funds, Capital Project Funds and
Internal Service Funds. The Enterprise Funds consist of the Water/Sewer Fund and two (2)
Parking Funds.
Trust funds include the Village's two public safety pensions (Police and Firefighters') while the
agency funds include the Escrow Deposit and Flexcomp 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.
Governmental and Enterprise Funds - Cash and cash equivalents at August 31 was $51.0
million. During September, cash receipts totaled $5,868,000. In addition investment income for
the month was $1,530, interfund activity was $50,755 and inflows due to investment activity
added $999,240 to the balance. Reductions in cash and cash equivalents during September
totaled $8,769,618. Of this amount, payments to vendors were $7,326,905, employee payroll
and related expenses were $1,439,396 and other disbursements were $3,317. Cash and cash
equivalents at September 30 were $49.1 million.
Monthly Financial Report — September 2015
October 16, 2015
Page 2
Investments in the Governmental and Enterprise Funds at August 31 were $1.6 million. $1.0
million worth of CD's matured during September. CD's in the Governmental and Enterprise
Funds reside in the Flood Control Fund and were purchased using proceeds from the Series
2013 bond issue. The maturity dates of the CD's are laddered to match the expected payout
schedule of the underlying flood control work. Total investments at September 30 were
$648,600.
Total cash and investments for Governmental and Enterprise Funds at August 31 was
$52,612,584. Cash and investments at September 30 totaled $49,765,091. This is a decrease
of $2,847,493 for the month.
Trust and Agency Funds - Cash and cash equivalents at August 31 was $4.0 million. During
September, cash receipts totaled $270,880. In addition investment income for the month was
$52,814. There was a net decrease in cash due to investment activities of $501,884 and
outflows due to interfund activity were $50,755. Reductions in cash and cash equivalents
during September totaled $798,177. Of this amount, payments to vendors were $155,509,
employee payroll and related expenses were $624,870, payments related to the flexible ending
program totaled $11,032. Other disbursements totaled $6,766. Cash and cash equivalents at
September 30 were $2.9 million.
Total investments at August 31 were $114,246,911. There were unrealized investment losses of
$2,243,100 and a net transfer from cash of $501,884. Total investments at September 30 were
$112,505,695.
Total cash and investments for Trust and Agency Funds at August 31 were $118,196,932. Cash
and investments at September 30 totaled $115,428,593. This is a decrease for the month of
$2,768,339.
Summary of Cash Activity by Fund Type (page 2)
This report provides a breakdown of the cash activity for the month broken down by fund type.
This breakdown is useful in identifying where the activity (receipts and disbursements) is
occurring. There are times during the year when activity in certain funds such as the capital
improvement and special revenue funds is higher than normal. This will distort the financial
picture of some of the other components of the governmental funds such as the General Fund
which tends to be more level and predictable in terms of spending and receipt of revenue. Each
month the report will provide detail explanation on activity of the General Fund, the Village's
primary operating fund.
General Fund — Cash and cash equivalents at August 31 totaled $14,350,659. During
September, cash receipts totaled $3,632,587 and investment income was $331. Significant
cash receipts included the state income tax and sales tax.
State income tax receipts for September totaled $899,097 consisting of two monthly
disbursements. Received during September were July receipts totaling $568,934 and
August receipts totaling $330,163.
H:WCCT\Treasurer's Report\2015\Monthly Cash Position Report - September 2015.docx
Monthly Financial Report — September 2015
October 16, 2015
Page 3
Sales tax revenues for the month totaled $1,479,533. Of this amount, $1,359,286 was
generated from the 1% state portion while $120,247 was generated from the .25% home
rule portion. Sales taxes received in September are for June sales as there is a three-
month lag in getting this distribution from the state.
Disbursements from the General Fund for September included payments to vendors of
$1,401,852, payments for employee wages and benefits of $1,280,761 and other disbursements
of $4,202. Interfund transfers of $662,313 were also made during September.
Cash and cash equivalents at September 30 was $14,634,449. There were no investments in
the General Fund at September 30.
Statement of Investments (page 3)
This report provides a breakdown of investments by governmental and enterprise funds and
trust and agency funds. The report also provides a fund -by fund breakdown of the investments.
Government and Enterprise Funds - The investments for the governmental and agency funds
are made up solely of certificates of deposit. Currently held certificates of deposit have
maturities of 314 days from purchase date and are currently placed with multiple banks through
our financial advisor, PMA.
Return on the portfolio of CD's range from 30 to 34 basis points. The portfolio return remains
low on all types of investments available to municipalities (typically certificate of deposits,
money market accounts and short-term treasuries). A detailed listing of the CD's currently held
can be found in the table below.
Maturity Purchase Financial
Date Date Institution
FLOOD CONTROL CONSTRUCTION FUND (024)
10/15/15 01105/15 United Texas Bank, TX
10/15/15 01105/15 Affiliated Bank_ TX
10/15/15 01/05/15 Royal Business Bank, CA
TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS
Investment
CUSIP/
Description
FDIC #
Net Yield
Purch Price
Certificate of Deposit
26626
0343%
249,300.00
Certificate of Deposit
34885
0343%
249,300.00
Certificate of Deposit
58816
0303%
150,000.00
648,600.00
$
648,600.00
Trust and Agency Funds — The investments for the trust and agency funds are made up of
certificate 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.
H:WCCT\Treasurer's Report\2015\Monthly Cash Position Report - September 2015.docx
Monthly Financial Report — September 2015
October 16, 2015
Page 4
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 funds also
invest a small amount in international stocks. Each year the investment mix is evaluated for
optimal diversification to meet pension fund investment policy goals and objectives. Equity
investments held by the Police Pension Fund are managed by Sawyer Falduto Asset
Management. Below is a breakdown of how the pension fund portfolios are invested.
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,805,198.42
Various
Various
Various
Mutual Fund Investments
Various
Various
32,526,41022
56,331,608.64
FIRE PENSION FUND (071)
Various
5/26/2015
Principal Life Insurance Company
Group Annuity Contract
8-10810
Variable
2,637,65331
Various
Various
Wells Fargo
Wells Fargo Investments
Various
Various
20,696,862.48
Various
Various
Various
Mutual Fund Investments
Various
Various
32,839,570.80
56,174,086.59
TOTAL TRUST AND AGENCY FUND INVESTMENTS
$112,505,69523
Investment of the Village's pension funds is governed by an Investment Policy adopted by each
Pension Board.
Conclusion
This cash position report is intended to provide a snapshot of the Village's cash position as of a
particular month end date. Maintaining strong cash balances allow the Village to weather
delays in receipt of revenues or cover unanticipated/unscheduled expenses. Please review the
information and contact me with any questions.
David O. Erb
Finance Director
H:WCCT\Treasurer's Report\2015\Monthly Cash Position Report - September 2015.docx
VILLAGE OF MOUNT PROSPECT
Preliminary Cash and Investment Position Report - All Funds
For the Month Ended September 30, 2015
GOVERNMENTAL AND ENTERPRISE FUNDS
Disbursements:
Accounts payable
Payroll
Other
Balance at September 30, 2015
(7,326,905.16)
(1,439,395.82)
(3,316.65)
(7,326,905.16)
(1,439,395.82)
(3,316.65)
$ 49,116,490.97 $ 648,600.00 $ 49,765,090.97
TRUST AND AGENCY FUNDS *
Cash and Cash Total Cash and
Equivalents Investments Investments
Balance at August 31, 2015 $ 3,950,020.98 $ 114,246,911.38 $ 118,196,932.36
Cash receipts 270,880.07
Investment income (loss) 52,813.78 (2,243,100.88)
Transfers from investments to cash 2,729,837.62 (2,729,837.62)
Transfers to investments from cash (3,231,722.35) 3,231,722.35
Interfund activity (50,755.32)
Disbursements:
Accounts payable
Payroll
Flex spending
Other
Balance at September 30, 2015
(155,509.25)
(624,870.08)
(11,031.92)
(6,766.21)
270,880.07
(2,190,287.10)
(50,755.32)
(155,509.25)
(624,870.08)
(11,031.92)
(6,766.21)
$ 2,922,897.32 $ 112,505,695.23 $ 115,428,592.55
* Assets are restricted in purpose and do not represent discretionary assets of the government.
1
Cash and Cash
Total Cash and
Equivalents
Investments
Investments
Balance at August 31, 2015
$ 50,966,583.68
$ 1,646,000.00
$ 52,612,583.68
Cash receipts
5,867,999.73
5,867,999.73
Investment income
1,529.86
1,840.01
3,369.87
Transfers from investments to cash
999,240.01
(999,240.01)
-
Transfers to investments from cash
-
-
-
Interfund activity
50,755.32
50,755.32
Disbursements:
Accounts payable
Payroll
Other
Balance at September 30, 2015
(7,326,905.16)
(1,439,395.82)
(3,316.65)
(7,326,905.16)
(1,439,395.82)
(3,316.65)
$ 49,116,490.97 $ 648,600.00 $ 49,765,090.97
TRUST AND AGENCY FUNDS *
Cash and Cash Total Cash and
Equivalents Investments Investments
Balance at August 31, 2015 $ 3,950,020.98 $ 114,246,911.38 $ 118,196,932.36
Cash receipts 270,880.07
Investment income (loss) 52,813.78 (2,243,100.88)
Transfers from investments to cash 2,729,837.62 (2,729,837.62)
Transfers to investments from cash (3,231,722.35) 3,231,722.35
Interfund activity (50,755.32)
Disbursements:
Accounts payable
Payroll
Flex spending
Other
Balance at September 30, 2015
(155,509.25)
(624,870.08)
(11,031.92)
(6,766.21)
270,880.07
(2,190,287.10)
(50,755.32)
(155,509.25)
(624,870.08)
(11,031.92)
(6,766.21)
$ 2,922,897.32 $ 112,505,695.23 $ 115,428,592.55
* Assets are restricted in purpose and do not represent discretionary assets of the government.
1
VILLAGE OF MOUNT PROSPECT
Summary of Cash Activity by Fund Type
iv For the Month Ended September 30, 2015
CASH & CASH EQUIVALENTS
Beginning balance
Cash receipts
Investment income
Transfers from investments
Transfers to investments
Interfund
Disbursements - other
Disbursements - flexible spending
Disbursements - payroll
Disbursements - accounts payable
Ending balance
INVESTMENTS
Certificates of deposit
Wells Fargo investments
Mutual fund investments
Total investments
GOVERNMENTAL AND ENTERPRISE FUNDS TRUST AND AGENCY FUNDS *
648,600.00
648,600.00
648,600.00
- 44,502,060.90
- 68,003,634.33
648,600.00 112,505,695.23
648,600.00
44,502,060.90
68,003,634.33
113,154,295.23
TOTAL CASH AND INVESTMENTS $ 14,634,449.03 $ 3,664,572.83 $ 2,061,795.59 $ 14,231,278.25 $ 3,874,737.63 $ 11,298,257.64 $ 49,765,090.97 $114,234,601.86 $ 1,193,990.69 $165,193,683.52
* 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
$ 14,350,658.53
$ 3,731,632.25
$ 1,942,422.81
$ 15,301,514.40
$ 4,540,301.96
$ 11,100,053.73
$ 50,966,583.68
$ 2,732,865.45
$ 1,217,155.53
$ 54,916,604.66
3,632,587.37
330,109.63
119,741.41
373,556.46
1,266,319.86
145,685.00
5,867,999.73
211,198.69
59,681.38
6,138,879.80
330.89
94.71
59.37
171.38
187.47
686.04
1,529.86
52,697.09
116.69
54,343.64
-
-
-
999,240.01
-
-
999,240.01
2,729,837.62
-
3,729,077.63
-
-
-
-
(3,231,722.35)
(3,231,722.35)
(662,312.70)
37,535.21
55.00
(177,557.98)
853,035.79
50,755.32
(40,294.21)
(10,461.11)
(0.00)
(4,201.65)
-
-
885.00
(3,316.65)
(6,766.21)
(10,082.86)
-
(11,031.92)
(11,031.92)
(1,280,761.12)
(15,320.63)
(99,203.59)
(44,110.48)
(1,439,395.82)
(624,870.08)
(2,064,265.90)
(1,401,852.29)
(419,478.34)
(428.00)
(3,091,859.00)
(1,655,310.09)
(757,977.44)
(7,326,905.16)
(100,805.58)
(54,703.67)
(7,482,414.41)
14,634,449.03
3,664,572.83
2,061,795.59
13,582,678.25
3,874,737.63
11,298,257.64
49,116,490.97
1,728,906.63
1,193,990.69
52,039,388.29
648,600.00
648,600.00
648,600.00
- 44,502,060.90
- 68,003,634.33
648,600.00 112,505,695.23
648,600.00
44,502,060.90
68,003,634.33
113,154,295.23
TOTAL CASH AND INVESTMENTS $ 14,634,449.03 $ 3,664,572.83 $ 2,061,795.59 $ 14,231,278.25 $ 3,874,737.63 $ 11,298,257.64 $ 49,765,090.97 $114,234,601.86 $ 1,193,990.69 $165,193,683.52
* Assets are restricted in purpose and do not represent discretionary assets of the government.
VILLAGE OF MOUNT PROSPECT
STATEMENT OF INVESTMENTS
As of September 30, 2015
TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS
Maturity
Purchase
GOVERNMENTAL AND ENTERPRISE FUNDS
Date
Maturity
Purchase
Financial
Investment
CUSIP/
Date
Date
Institution
Description
FDIC #
FLOOD CONTROL CONSTRUCTION FUND (024)
10/15/15
01/05/15
United Texas Bank, TX
Certificate of Deposit
26626
10/15/15
01/05/15
Affiliated Bank. TX
Certificate of Deposit
34885
10/15/15
01/05/15
Royal Business Bank, CA
Certificate of Deposit
58816
TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS
Maturity
Purchase
Financial
Date
Date
Institution
POLICE PENSION FUND (070)
Various
Various
Wells Fargo
Various
Various
Various
Investment
CUSIP/
Description
Acct #
Wells Fargo Investments
Various
Mutual Fund Investments
Various
FIRE PENSION FUND (071)
Various 5/26/2015 Principal Life Insurance Company Group Annuity Contract
Various Various Wells Fargo Wells Fargo Investments
Various Various Various Mutual Fund Investments
TOTAL TRUST AND AGENCY FUND INVESTMENTS
* Assets are restricted in purpose and do not represent discretionary assets of the government.
8-10810
Various
Various
Net Yield Purch Price
0.343% 249,300.00
0.343% 249,300.00
0.303% 150,000.00
648,600.00
$ 648,600.00
Interest Market
Rate % Value
Various
$ 23,805,198.42
Various
32,526,410.22
56,331,608.64
Variable
2,637,653.31
Various
20,696,862.48
Various
32,839,570.80
56,174,086.59
$ 112,505,695.23
3
VILLAGE OF MOUNT PROSPECT
BUDGET REVENUE
EXPENDITURE SUMMARIES
September 01— September 30, 2015
Revenue Budget by Account Classification
Report
Through 09/30/15
REVENUE TOTALS
Fund 001 - General Fund Totals
$46,818,407.00 $2,404.00 $46,820,811.00 $3,478,575.17 $0.00 $35,992,817.01 $10,827,993.99 77% $33,470,373.25
$46,818,407.00 $2,404.00 $46,820,811.00 $3,478,575.17 $0.00 $35,992,817.01 $10,827,993.99 $33,470,373.25
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 001- General Fund
REVENUE
Property Taxes
15,427,500.00
.00
15,427,500.00
298,754.43
.00
15,226,576.11
200,923.89
99
14,358,645.87
Other Taxes
7,457,566.00
.00
7,457,566.00
573,033.30
.00
5,063,563.77
2,394,002.23
68
4,807,368.04
Licenses, Permits & Fees
1,256,000.00
.00
1,256,000.00
143,199.50
.00
1,302,368.49
(46,368.49)
104
1,459,849.89
Intergovernmental Revenue
20,123,200.00
2,404.00
20,125,604.00
2,258,382.00
.00
12,483,505.12
7,642,098.88
62
10,831,872.33
Charges For Services
1,633,223.00
.00
1,633,223.00
139,520.11
.00
1,186,686.24
446,536.76
73
1,135,628.41
Fines & Forfeits
439,000.00
.00
439,000.00
48,662.31
.00
366,918.24
72,081.76
84
342,398.05
Investment Income
5,918.00
.00
5,918.00
447.34
.00
6,772.29
(854.29)
114
3,436.26
Reimbursements
220,000.00
.00
220,000.00
30,699.80
.00
151,497.12
68,502.88
69
289,992.38
Other Revenue
236,000.00
.00
236,000.00
16,978.52
.00
216,031.77
19,968.23
92
221,182.02
Other Financing Sources
20,000.00
.00
20,000.00
(31,102.14)
.00
(11,102.14)
31,102.14
-56
20,000.00
REVENUE TOTALS
Fund 001 - General Fund Totals
$46,818,407.00 $2,404.00 $46,820,811.00 $3,478,575.17 $0.00 $35,992,817.01 $10,827,993.99 77% $33,470,373.25
$46,818,407.00 $2,404.00 $46,820,811.00 $3,478,575.17 $0.00 $35,992,817.01 $10,827,993.99 $33,470,373.25
Revenue Budget by Account Classification
LP/
Report
Through 09/30/15
Prior Fiscal Year Activity Included
Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
Fund 002 - Debt Service Fund
REVENUE
Property Taxes
2,254,000.00
.00
2,254,000.00
31,399.19
.00
2,230,601.37
23,398.63
99
2,200,296.82
Other Taxes
988,508.00
.00
988,508.00
88,342.22
.00
461,456.77
527,051.23
47
497,240.62
Intergovernmental Revenue
42,773.00
1,568,856.00
1,611,629.00
.00
.00
228,960.35
1,382,668.65
14
21,927.64
Investment Income
100.00
.00
100.00
59.37
.00
141.35
(41.35)
141
51.70
Other Revenue
.00
.00
.00
.00
.00
.00
.00
+++
.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
+++
3,231.19
REVENUE TOTALS
$3,285,381.00
$1,568,856.00
$4,854,237.00
$119,800.78
$0.00
$2,921,159.84
$1,933,077.16
60%
$2,722,747.97
Fund 002 - Debt Service Fund Totals
$3,285,381.00
$1,568,856.00
$4,854,237.00
$119,800.78
$0.00
$2,921,159.84
$1,933,077.16
$2,722,747.97
N
m o m o 0 0
(71 7 M 00
0
� + zr + m +
7 + M + N +
+ + +
O a O
O ^ 0 O C> O
7
� 7 N
A N M O O O
O� 1l� M O O O
7 N M IA
o
000000
m O rn 0 0 0
M O m O O O
M
'-I
O O O O O O
CD 0 CD
O O O
t0 ti O
7 N
N
H
O O O O O O
CD CD CD
O CD
O O
0 ti O
7 N
N
H
v
c
�
v
L
u
0
E
O
O
VI
O
vc
E H
}
■_O
WN
U
a
CL
�
C L
O
9
O
a`
C
O O
ce
0
rL'
■
`� o
Q
p
c
N
O
H
V
U m
~
L.L
L p
C
O F
i
O
L
12
12
V
V
a�
0O
cnO
�
C
3
U
�
O
C
E
E
=
m
3
Q
p�
C
ce
m
-O
C
Q
m o m o 0 0
(71 7 M 00
0
� + zr + m +
7 + M + N +
+ + +
O a O
O ^ 0 O C> O
7
� 7 N
A N M O O O
O� 1l� M O O O
7 N M IA
o
000000
m O rn 0 0 0
M O m O O O
M
'-I
O O O O O O
CD 0 CD
O O O
t0 ti O
7 N
N
H
O O O O O O
CD CD CD
O CD
O O
0 ti O
7 N
N
H
J
O
O �
� 9
w =
p 6
Z LL
w a+
w _
w d
CC E
d
O
6
E
w
A
a
m
V
O
N
O
Il
3
v
c
�
v
u
0
E
O
y
VI
O
vc
E H
C
N
E
N
�
c
WN
y
v
N C
O
C L
O
9
O
S S
C
O O
J
O
O �
� 9
w =
p 6
Z LL
w a+
w _
w d
CC E
d
O
6
E
w
A
a
m
V
O
N
O
Il
3
Revenue Budget by Account Classification
ILP/
Report
Through 09/30/15
Prior Fiscal Year Activity Included
Adopted
Budget
Amended
Current Month
YTD
YTD Budget- YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions Transactions Rec'd Prior Year YTD
Fund 021 - Series 2009 Construction Fund
REVENUE
Intergovernmental Revenue
.00
.00
.00
.00
.00
.00 .00 +++ .00
Investment Income
.00
.00
.00
.00
.00
.00 .00 +++ .00
Other Revenue
.00
.00
.00
.00
.00
.00 .00 +++ .00
Other Financing Sources
.00
.00
.00
.00
.00
.00 .00 +++ .00
REVENUE TOTALS
Fund 021 - Series 2009 Construction Fund Totals
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 +++ $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Revenue Budget by Account Classification
REVENUE TOTALS $2,709,500.00 $0.00 $2,709,500.00 $25,191.14 $0.00 $2,303,061.51 $406,438.49 85% $2,268,465.67
Fund 022 -Downtown Redevelopment Construct Totals $2,709,500.00 $0.00 $2,709,500.00 $25,191.14 $0.00 $2,303,061.51 $406,438.49 $2,268,465.67
M
Report
LP/
Through 09/30/15
Prior Fiscal Year Activity Included
Adopted
Budget
Amended
Current Month
YTD
YTD Budget- YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions Transactions Rec'd Prior Year YTD
Fund 022 - Downtown Redevelopment Construct
REVENUE
Property Taxes
2,709,000.00
.00
2,709,000.00
25,116.81
.00
2,302,788.58 406,211.42 85 2,268,202.36
Investment Income
500.00
.00
500.00
74.33
.00
272.93 227.07 55 263.31
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,709,500.00 $0.00 $2,709,500.00 $25,191.14 $0.00 $2,303,061.51 $406,438.49 85% $2,268,465.67
Fund 022 -Downtown Redevelopment Construct Totals $2,709,500.00 $0.00 $2,709,500.00 $25,191.14 $0.00 $2,303,061.51 $406,438.49 $2,268,465.67
M
0
0
U
c
0
0
001�T IA
O
O
M
O
L
o
O
O
r<
o
}
■_
O
A
T
U
a
O
Il
CL
�
M
w'
O
O T
.--I T
a`
7 1
ce
c1
>
0
rL'
■
`� o
/w
a p
c
m
_
N
�
V
L.L
L p
C
O F
•i
O
L
O
a
12
12
V
V
W
a�
C
0
�
cnO
O
�
C
U
�
O
C
N
=
m
Q
pI
C
ce
O]
-O
C
Q
0
0
U
c
0
0
001�T IA
O
O
M
O
o
r<
o
10 10
M N
O
A
T
M
O
Il
M
T
O T
.--I T
7 1
N 7 + + 7 + 10 +
Lf1 01 + + Oti ++
+ + + co +
O O O O
0
O co
Qi O M
ol
O N O O 10 O O� O
T., 7 M 10
N O co
7 M
C 7 A
O 7
00000000,
��0000�o
co O M
IA M IA
1� N
O O O O O O O O
O O O O
O O O
O l!1
O O O O O O O O
O O O O
O O O
10 O 10
C 7
O Lf1
N '-I
O
7
0
O
O
O
O
O
N
O
tp
M
J N
O
O
6
Revenue Budget by Account Classification
LP/
Report
Through 09/30/15
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 024 - Flood Control Construction Fund
REVENUE
Other Taxes
357,000.00
.00
357,000.00
31,904.82
.00
166,655.26
190,344.74
47
136,233.68
Intergovernmental Revenue
.00
.00
.00
.00
.00
.00
.00
+++
.00
Charges For Services
.00
.00
.00
760.00
.00
26,757.00
(26,757.00)
+++
.00
Investment Income
1,100.00
.00
1,100.00
286.04
.00
10,155.96
(9,055.96)
923
9,616.00
Reimbursements
.00
.00
.00
.00
.00
.00
.00
+++
.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
+++
.00
REVENUE TOTALS
$358,100.00
$0.00
$358,100.00
$32,950.86
$0.00
$203,568.22
$154,531.78
57%
$145,849.68
Fund 024- Flood Control Construction Fund Totals
$358,100.00
$0.00
$358,100.00
$32,950.86
$0.00
$203,568.22
$154,531.78
$145,849.68
V
Revenue Budget by Account Classification
LP/
Report
Through 09/30/15
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 040 - Refuse Disposal Fund
REVENUE
Property Taxes
.00
.00
.00
.00
.00
.00
.00
+++
338,321.95
Charges For Services
3,549,000.00
.00
3,549,000.00
405,592.26
.00
2,641,561.88
907,438.12
74
2,180,386.20
Fines & Forfeits
24,000.00
.00
24,000.00
1,740.27
.00
25,542.98
(1,542.98)
106
20,125.17
Investment Income
500.00
.00
500.00
27.41
.00
165.81
334.19
33
489.87
Reimbursements
1,000.00
.00
1,000.00
150.43
.00
3,565.97
(2,565.97)
357
442.44
Other Revenue
371,500.00
.00
371,500.00
27,185.12
.00
296,637.22
74,862.78
80
265,399.34
REVENUE TOTALS
$3,946,000.00
$0.00
$3,946,000.00
$434,695.49
$0.00
$2,967,473.86
$978,526.14
75%
$2,805,164.97
Fund 040 - Refuse Disposal Fund Totals
$3,946,000.00
$0.00
$3,946,000.00
$434,695.49
$0.00
$2,967,473.86
$978,526.14
$2,805,164.97
00
Revenue Budget by Account Classification
ILP/
Report
Through 09/30/15
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,320,000.00
.00
1,320,000.00
.00
.00
596,472.32 723,527.68 45 1,348,577.94
Investment Income
200.00
.00
200.00
39.10
.00
204.22 (4.22) 102 27.38
Reimbursements
11,000.00
.00
11,000.00
1,219.80
.00
8,832.95 2,167.05 80 11,704.04
REVENUE TOTALS
Fund 041 - Motor Fuel Tax Fund Totals
$1,331,200.00 $0.00 $1,331,200.00 $1,258.90 $0.00 $605,509.49 $725,690.51 45% $1,360,309.36
$1,331,200.00 $0.00 $1,331,200.00 $1,258.90 $0.00 $605,509.49 $725,690.51 $1,360,309.36
Revenue Budget by Account Classification
ILP/
Report
Through 09/30/15
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 042 - CDBG
REVENUE
Intergovernmental Revenue
339,264.00
.00
339,264.00
.00
.00
.00 339,264.00 0 52,998.37
Investment Income
.00
.00
.00
.00
.00
.00 .00 +++ .00
Other Revenue
80,000.00
.00
80,000.00
.00
.00
59,693.50 20,306.50 75 152,817.12
REVENUE TOTALS
Fund 042 - CDBG Totals
0
$419,264.00 $0.00 $419,264.00 $0.00 $0.00 $59,693.50 $359,570.50 14% $205,815.49
$419,264.00 $0.00 $419,264.00 $0.00 $0.00 $59,693.50 $359,570.50 $205,815.49
Revenue Budget by Account Classification
REVENUE TOTALS
Fund 043 -Asset Seizure Fund Totals
$2,100.00 $0.00 $2,100.00 $2.77 $0.00 $10,196.54 ($8,096.54) 486% $43,332.23
$2,100.00 $0.00 $2,100.00 $2.77 $0.00 $10,196.54 ($8,096.54) $43,332.23
Report
LP/
Through 09/30/15
Prior Fiscal Year Activity Included
Adopted
Budget
Amended
Current Month
YTD
YTD Budget- YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions Transactions Rec'd Prior Year YTD
Fund 043 -Asset Seizure Fund
REVENUE
Fines & Forfeits
2,000.00
.00
2,000.00
.00
.00
10,182.09 (8,182.09) 509 43,321.06
Investment Income
100.00
.00
100.00
2.77
.00
14.45 85.55 14 11.17
REVENUE TOTALS
Fund 043 -Asset Seizure Fund Totals
$2,100.00 $0.00 $2,100.00 $2.77 $0.00 $10,196.54 ($8,096.54) 486% $43,332.23
$2,100.00 $0.00 $2,100.00 $2.77 $0.00 $10,196.54 ($8,096.54) $43,332.23
Revenue Budget by Account Classification
REVENUE TOTALS
Fund 044 - Federal Equitable Share Funds Totals
N
$200.00 $0.00 $200.00 $2,688.31 $0.00 $2,695.49 ($2,495.49) 1348% $24,653.00
$200.00 $0.00 $200.00 $2,688.31 $0.00 $2,695.49 ($2,495.49) $24,653.00
Report
LP/
Through 09/30/15
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 - Federal Equitable Share Funds
REVENUE
Fines & Forfeits
100.00
.00
100.00
2,687.50
.00
2,687.50 (2,587.50) 2688 24,637.80
Investment Income
100.00
.00
100.00
.81
.00
7.99 92.01 8 15.20
REVENUE TOTALS
Fund 044 - Federal Equitable Share Funds Totals
N
$200.00 $0.00 $200.00 $2,688.31 $0.00 $2,695.49 ($2,495.49) 1348% $24,653.00
$200.00 $0.00 $200.00 $2,688.31 $0.00 $2,695.49 ($2,495.49) $24,653.00
Revenue Budget by Account Classification
REVENUE TOTALS
Fund 045 - DUI Fine Fund Totals
w
$20,100.00 $0.00 $20,100.00 $5,305.87 $0.00 $26,530.09 ($6,430.09) 132% $22,254.01
$20,100.00 $0.00 $20,100.00 $5,305.87 $0.00 $26,530.09 ($6,430.09) $22,254.01
Report
LP/
Through 09/30/15
Prior Fiscal Year Activity Included
Adopted
Budget
Amended
Current Month
YTD
YTD Budget- YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions Transactions Rec'd Prior Year YTD
Fund 045 - DUI Fine Fund
REVENUE
Fines & Forfeits
20,000.00
.00
20,000.00
5,303.77
.00
26,507.92 (6,507.92) 133 22,224.22
Investment Income
100.00
.00
100.00
2.10
.00
22.17 77.83 22 29.79
REVENUE TOTALS
Fund 045 - DUI Fine Fund Totals
w
$20,100.00 $0.00 $20,100.00 $5,305.87 $0.00 $26,530.09 ($6,430.09) 132% $22,254.01
$20,100.00 $0.00 $20,100.00 $5,305.87 $0.00 $26,530.09 ($6,430.09) $22,254.01
Revenue Budget by Account Classification
ILP/
Report
Through 09/30/15
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 046 - Foreign Fire Tax Board Fund
REVENUE
Other Taxes
70,000.00
.00
70,000.00
5,602.69
.00
82,425.42 (12,425.42) 118 63,264.64
Investment Income
100.00
.00
100.00
9.79
.00
62.38 37.62 62 83.36
Other Revenue
.00
.00
.00
.00
.00
.00 .00 +++ .00
Other Financing Sources
.00
.00
.00
.00
.00
.00 .00 +++ .00
REVENUE TOTALS
Fund 046 - Foreign Fire Tax Board Fund Totals
$70,100.00 $0.00 $70,100.00 $5,612.48 $0.00 $82,487.80 ($12,387.80) 118% $63,348.00
$70,100.00 $0.00 $70,100.00 $5,612.48 $0.00 $82,487.80 ($12,387.80) $63,348.00
Revenue Budget by Account Classification
REVENUE TOTALS
Fund 047 - Justice Assistance Grant Fund Totals
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 +++ $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Report
LP/
Through 09/30/15
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 047 -Justice Assistance Grant Fund
REVENUE
Intergovernmental Revenue
.00
.00
.00
.00
.00
.00 .00 +++ .00
Investment Income
.00
.00
.00
.00
.00
.00 .00 +++ .00
REVENUE TOTALS
Fund 047 - Justice Assistance Grant Fund Totals
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 +++ $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Revenue Budget by Account Classification
ILI
Report
Through 09/30/15
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 048 - Business District Fund
REVENUE
Other Taxes
1,021,000.00
.00
1,021,000.00
90,280.19
.00
661,966.80 359,033.20 65 601,995.78
Investment Income
.00
.00
.00
12.73
.00
64.58 (64.58) +++ 23.76
Other Financing Sources
.00
.00
.00
.00
.00
.00 .00 +++ .00
REVENUE TOTALS
Fund 048 - Business District Fund Totals
8
$1,021,000.00 $0.00 $1,021,000.00 $90,292.92 $0.00 $662,031.38 $358,968.62 65% $602,019.54
$1,021,000.00 $0.00 $1,021,000.00 $90,292.92 $0.00 $662,031.38 $358,968.62 $602,019.54
V
"
Revenue
Budget
by Account Classification
Report
Through 09/30/15
Prior Fiscal Year Activity Included
Adopted
Budget
Amended
Current Month
YTD
YTD Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions Encumbrances
Transactions Transactions Rec'd Prior Year YTD
Fund 050 -Water and Sewer Fund
REVENUE
Property Taxes
1,530,000.00
.00
1,530,000.00
8,266.16
.00
2,709.05 1,527,290.95 0 1,493,886.04
Licenses, Permits & Fees
18,000.00
.00
18,000.00
2,830.00
.00
15,690.00 2,310.00 87 13,690.00
Charges For Services
13,789,000.00
.00
13,789,000.00
1,135,820.29
.00
9,301,116.54 4,487,883.46 67 8,842,183.07
Fines & Forfeits
118,000.00
.00
118,000.00
8,923.76
.00
89,180.83 28,819.17 76 82,996.41
Investment Income
2,100.00
.00
2,100.00
177.34
.00
1,264.16 835.84 60 1,264.75
Reimbursements
500.00
.00
500.00
.00
.00
.00 500.00 0 (131.00)
Other Revenue
72,000.00
.00
72,000.00
6,086.06
.00
58,017.10 13,982.90 81 48,803.80
Other Financing Sources
.00
.00
.00
.00
.00
.00 .00 +++ .00
REVENUE TOTALS
$15,529,600.00
$0.00
$15,529,600.00
$1,162,103.61
$0.00
$9,467,977.68 $6,061,622.32 61% $10,482,693.07
Fund 050 -Water and Sewer Fund Totals
$15,529,600.00
$0.00
$15,529,600.00
$1,162,103.61
$0.00
$9,467,977.68 $6,061,622.32 $10,482,693.07
Revenue Budget by Account Classification
REVENUE TOTALS $130,700.00 $0.00 $130,700.00 $13,476.58 $0.00 $108,128.12 $22,571.88 83% $106,798.25
Fund 051 - Village Parking System Fund Totals $130,700.00 $0.00 $130,700.00 $13,476.58 $0.00 $108,128.12 $22,571.88 $106,798.25
Report
LP/
Through 09/30/15
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
.00
.00
.00
.00
.00
.00 .00 +++ 4,706.35
Charges For Services
124,000.00
.00
124,000.00
12,366.45
.00
102,514.03 21,485.97 83 97,070.87
Investment Income
100.00
.00
100.00
10.13
.00
59.09 40.91 59 71.03
Other Revenue
6,600.00
.00
6,600.00
1,100.00
.00
5,555.00 1,045.00 84 4,950.00
Other Financing Sources
.00
.00
.00
.00
.00
.00 .00 +++ .00
REVENUE TOTALS $130,700.00 $0.00 $130,700.00 $13,476.58 $0.00 $108,128.12 $22,571.88 83% $106,798.25
Fund 051 - Village Parking System Fund Totals $130,700.00 $0.00 $130,700.00 $13,476.58 $0.00 $108,128.12 $22,571.88 $106,798.25
Revenue Budget by Account Classification
LP/
Report
Through 09/30/15
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
100,000.00
.00
100,000.00
8,933.66
.00
46,665.09
53,334.91
47
42,357.13
Intergovernmental Revenue
.00
.00
.00
.00
.00
.00
.00
+++
.00
Charges For Services
119,000.00
.00
119,000.00
10,848.05
.00
90,604.48
28,395.52
76
88,176.27
Investment Income
.00
.00
.00
.00
.00
.00
.00
+++
.00
Other Revenue
.00
.00
.00
.00
.00
.00
.00
+++
.00
Other Financing Sources
.00
.00
.00
.00
.00
.00
.00
+++
.00
REVENUE TOTALS
$219,000.00
$0.00
$219,000.00
$19,781.71
$0.00
$137,269.57
$81,730.43
63%
$130,533.40
Fund 052 - Parking System Revenue Fund Totals
$219,000.00
$0.00
$219,000.00
$19,781.71
$0.00
$137,269.57
$81,730.43
$130,533.40
Revenue Budget by Account Classification
ILI
Report
Through 09/30/15
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 060 - Vehicle Maintenance Fund
REVENUE
Charges For Services
2,157,889.00
.00
2,157,889.00
179,824.09
.00
1,618,416.81 539,472.19 75 1,603,737.63
Investment Income
600.00
.00
600.00
38.04
.00
275.64 324.36 46 420.33
Other Revenue
.00
.00
.00
.00
.00
1,123.70 (1,123.70) +++ 525.88
REVENUE TOTALS
Fund 060 - Vehicle Maintenance Fund Totals
N
O
$2,158,489.00 $0.00 $2,158,489.00 $179,862.13 $0.00 $1,619,816.15 $538,672.85 75% $1,604,683.84
$2,158,489.00 $0.00 $2,158,489.00 $179,862.13 $0.00 $1,619,816.15 $538,672.85 $1,604,683.84
Revenue Budget by Account Classification
1
Report
Through 09/30/15
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 061 - Vehicle Replacement Fund
REVENUE
Charges For Services
1,380,500.00
.00
1,380,500.00
115,041.68
.00
1,035,375.12 345,124.88 75 1,009,725.12
Fines & Forfeits
11,150.00
.00
11,150.00
1,400.00
.00
8,279.00 2,871.00 74 8,997.72
Investment Income
7,200.00
.00
7,200.00
473.36
.00
3,360.32 3,839.68 47 5,239.03
Other Revenue
.00
.00
.00
.00
.00
.00 .00 +++ .00
Other Financing Sources
.00
.00
.00
31,628.62
.00
40,630.62 (40,630.62) +++ 54,253.75
REVENUE TOTALS $1,398,850.00 $0.00 $1,398,850.00 $148,543.66 $0.00 $1,087,645.06 $311,204.94 78% $1,078,215.62
Fund 061 - Vehicle Replacement Fund Totals $1,398,850.00 $0.00 $1,398,850.00 $148,543.66 $0.00 $1,087,645.06 $311,204.94 $1,078,215.62
N
Revenue Budget by Account Classification
ILP/
Report
Through 09/30/15
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
REVENUE
Charges For Services
272,307.00
.00
272,307.00
22,692.25
.00
204,230.25 68,076.75 75 17,316.00
Investment Income
1,000.00
.00
1,000.00
46.75
.00
371.38 628.62 37 562.23
Other Financing Sources
.00
.00
.00
.00
.00
.00 .00 +++ .00
REVENUE TOTALS
Fund 062 - Computer Replacement Fund Totals
N
N
$273,307.00 $0.00 $273,307.00 $22,739.00 $0.00 $204,601.63 $68,705.37 75% $17,878.23
$273,307.00 $0.00 $273,307.00 $22,739.00 $0.00 $204,601.63 $68,705.37 $17,878.23
Revenue Budget by Account Classification
ILP/
Report
Through 09/30/15
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 063 - Risk Management Fund
REVENUE
Charges For Services
6,513,826.00
.00
6,513,826.00
546,921.44
.00
4,825,777.07 1,688,048.93 74 4,859,102.11
Investment Income
3,000.00
.00
3,000.00
127.89
.00
937.74 2,062.26 31 1,709.73
Reimbursements
1,000.00
.00
1,000.00
859.40
.00
859.40 140.60 86 .00
Other Revenue
1,463,700.00
.00
1,463,700.00
107,358.26
.00
977,093.59 486,606.41 67 983,335.62
REVENUE TOTALS
Fund 063 - Risk Management Fund Totals
N
W
$7,981,526.00 $0.00 $7,981,526.00 $655,266.99 $0.00 $5,804,667.80 $2,176,858.20 73% $5,844,147.46
$7,981,526.00 $0.00 $7,981,526.00 $655,266.99 $0.00 $5,804,667.80 $2,176,858.20 $5,844,147.46
Revenue Budget by Account Classification
ILP/
Report
Through 09/30/15
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
4,382,800.00
.00
4,382,800.00
(965,326.83)
.00
(1,234,693.88) 5,617,493.88 -28 2,083,364.88
Other Revenue
3,743,175.00
.00
3,743,175.00
116,444.60
.00
3,425,301.44 317,873.56 92 3,451,996.47
REVENUE TOTALS
Fund 070 - Police Pension Fund Totals
N
A
$8,125,975.00 $0.00 $8,125,975.00 ($848,882.23) $0.00 $2,190,607.56 $5,935,367.44 27% $5,535,361.35
$8,125,975.00 $0.00 $8,125,975.00 ($848,882.23) $0.00 $2,190,607.56 $5,935,367.44 $5,535,361.35
Revenue Budget by Account Classification
REVENUE TOTAL`;
Fund 071 - Fire Pension Fund Tot
$7,401,625.00 $0.00 $7,401,625.00 ($1,109,627.14) $0.00 $3,935,979.77 $3,465,645.23 53% $5,214,320.88
$7,401,625.00 $0.00 $7,401,625.00 ($1,109,627.14) $0.00 $3,935,979.77 $3,465,645.23 $5,214,320.88
Grand Tot $108,069,524.00 $1,571,260.00 $109,640,784.00 $4,755,257.92 $0.00 $73,644,801.12 $35,995,982.88 $83,313,088.41
N
N
Report
LP/
Through 09/30/15
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
4,250,500.00
.00
4,250,500.00
(1,204,381.23)
.00
1,022,884.37 3,227,615.63 24 2,346,127.70
Other Revenue
3,151,125.00
.00
3,151,125.00
94,754.09
.00
2,913,095.40 238,029.60 92 2,868,193.18
REVENUE TOTAL`;
Fund 071 - Fire Pension Fund Tot
$7,401,625.00 $0.00 $7,401,625.00 ($1,109,627.14) $0.00 $3,935,979.77 $3,465,645.23 53% $5,214,320.88
$7,401,625.00 $0.00 $7,401,625.00 ($1,109,627.14) $0.00 $3,935,979.77 $3,465,645.23 $5,214,320.88
Grand Tot $108,069,524.00 $1,571,260.00 $109,640,784.00 $4,755,257.92 $0.00 $73,644,801.12 $35,995,982.88 $83,313,088.41
N
N
Expense Budget by Account Classification
EXPENSE TOTALS
Fund 001 - General Fund Totals
$46,818,407.00 $37,816.00 $46,856,223.00 $3,404,672.62 $730,941.66 $34,247,399.52 $11,877,881.82 75% $34,964,467.70
$46,818,407.00 $37,816.00 $46,856,223.00 $3,404,672.62 $730,941.66 $34,247,399.52 $11,877,881.82 $34,964,467.70
Report
L
Through 09/30/15
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 001- General Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
24,232,037.00
1.00
24,232,038.00
1,920,733.04
.00
17,079,231.17
7,152,806.83
70 17,390,031.93
Employee Benefits
12,235,287.00
(1.00)
12,235,286.00
734,562.95
.00
10,511,931.39
1,723,354.61
86 10,697,028.06
Other Employee Costs
440,543.00
(5,860.00)
434,683.00
34,006.21
8,119.75
305,263.43
121,299.82
72 234,398.77
Pension Benefits
46,456.00
.00
46,456.00
3,871.28
.00
34,841.52
11,614.48
75 34,725.24
Contractual Services
7,528,869.00
(2,022.00)
7,526,847.00
513,132.82
440,470.58
5,114,356.86
1,972,019.56
74 5,400,847.31
Utilities
271,939.00
.00
271,939.00
15,083.67
.00
116,673.72
155,265.28
43 128,338.66
Insurance
415,398.00
.00
415,398.00
34,588.33
.00
311,345.28
104,052.72
75 262,901.76
Commodities & Supplies
641,996.00
15,883.00
657,879.00
48,444.27
25,292.28
368,432.41
264,154.31
60 390,229.98
Other Expenditures
11,140.00
.00
11,140.00
.00
.00
.00
11,140.00
0 53,696.48
Building Improvements
10,200.00
.00
10,200.00
600.20
.00
7,153.23
3,046.77
70 2,509.85
Office Equipment
33,520.00
19,000.00
52,520.00
105.18
7,095.56
5,066.08
40,358.36
23 7,606.36
Other Equipment
184,199.00
10,815.00
195,014.00
21,495.28
36,649.23
109,449.54
48,915.23
75 103,718.66
Distribution Systems
100,000.00
.00
100,000.00
11,243.59
34,145.65
65,853.90
.45
100 .00
Infrastructure
666,823.00
.00
666,823.00
66,805.80
179,168.61
217,800.99
269,853.40
60 258,434.64
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
+++ .00
EXPENSE TOTALS
Fund 001 - General Fund Totals
$46,818,407.00 $37,816.00 $46,856,223.00 $3,404,672.62 $730,941.66 $34,247,399.52 $11,877,881.82 75% $34,964,467.70
$46,818,407.00 $37,816.00 $46,856,223.00 $3,404,672.62 $730,941.66 $34,247,399.52 $11,877,881.82 $34,964,467.70
Expense Budget by Account Classification
1
Report
Through 09/30/15
Prior Fiscal Year Activity Included
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget- YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 002 - Debt Service Fund
EXPENSE
Contractual Services
.00
.00
.00
.00
.00
.00
.00 +++ .00
Other Expenditures
.00
.00
.00
.00
.00
.00
.00 +++ .00
Bond Principal
1,893,913.00
1,155,000.00
3,048,913.00
.00
.00
88,848.45
2,960,064.55 3 270,780.49
Interest Expense
1,382,571.00
413,356.00
1,795,927.00
.00
.00
898,571.26
897,355.74 50 766,300.74
Bank & Fiscal Fees
2,312.00
500.00
2,812.00
428.00
.00
3,715.14
(903.14) 132 1,686.20
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00 +++ .00
Other Financing Uses
.00
.00
.00
.00
.00
.00
.00 +++ .00
EXPENSE TOTALS
Fund 002 - Debt Service Fund Totals
N
$3,278,796.00 $1,568,856.00 $4,847,652.00 $428.00 $0.00 $991,134.85 $3,856,517.15 20% $1,038,767.43
$3,278,796.00 $1,568,856.00 $4,847,652.00 $428.00 $0.00 $991,134.85 $3,856,517.15 $1,038,767.43
Expense Budget by Account Classification
1
Report
Through 09/30/15
Prior Fiscal Year Activity Included
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget - YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 020 - Capital Improvement Fund
EXPENSE
Contractual Services
.00
.00
.00
.00
.00
.00
.00 +++ .00
Other Expenditures
.00
.00
.00
.00
.00
.00
.00 +++ .00
Land Improvements
350,000.00
236,250.00
586,250.00
5,704.02
399,836.72
41,537.41
144,875.87 75 .00
Building Improvements
896,000.00
502,440.00
1,398,440.00
75,220.00
433,707.77
656,518.33
308,213.90 78 266,876.54
Office Equipment
.00
.00
.00
.00
.00
.00
.00 +++ .00
Motor Equipment
.00
.00
.00
.00
.00
.00
.00 +++ .00
Other Equipment
486,747.00
52,118.00
538,865.00
13,485.25
72,610.85
155,319.97
310,934.18 42 182,404.15
Infrastructure
503,000.00
284,861.00
787,861.00
7,799.10
274,373.78
108,282.87
405,204.35 49 28,696.23
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00 +++ .00
w EXPENSE TOTALS $2,235,747.00 $1,075,669.00 $3,311,416.00 $102,208.37 $1,180,529.12 $961,658.58 $1,169,228.30 65% $477,976.92
Fund 020 - Capital Improvement Fund Totals $2,235,747.00 $1,075,669.00 $3,311,416.00 $102,208.37 $1,180,529.12 $961,658.58 $1,169,228.30 $477,976.92
Expense Budget by Account Classification
1
Report
Through 09/30/15
Prior Fiscal Year Activity Included
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget- YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 022 - Downtown Redevelopment Construct
EXPENSE
Contractual Services
109,201.00
.00
109,201.00
11,009.17
23,848.49
107,392.23
(22,039.72) 120 132,201.90
Utilities
.00
.00
.00
.00
.00
.00
.00 +++ .00
Other Expenditures
3,306,969.00
.00
3,306,969.00
200,150.00
.00
311,888.93
2,995,080.07 9 83,223.00
Infrastructure
342,285.00
3,675.00
345,960.00
.00
340,532.99
.00
5,427.01 98 16,775.75
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
Fund 022 -Downtown Redevelopment Construct Totals
a
$3,758,455.00 $3,675.00 $3,762,130.00 $211,159.17 $364,381.48 $419,281.16 $2,978,467.36 21% $232,200.65
$3,758,455.00 $3,675.00 $3,762,130.00 $211,159.17 $364,381.48 $419,281.16 $2,978,467.36 $232,200.65
Expense Budget by Account Classification
1
Report
Through 09/30/15
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 023 - Street Improvement Construc Fund
EXPENSE
Contractual Services
107,000.00
.00
107,000.00
.00
9,786.00
80,130.00 17,084.00 84 44,925.16
Other Expenditures
.00
.00
.00
.00
.00
.00 .00 +++ .00
Land Improvements
.00
.00
.00
.00
.00
.00 .00 +++ .00
Infrastructure
4,715,000.00
2,041,886.00
6,756,886.00
465,804.32
1,859,961.01
4,223,422.21 673,502.78 90 6,768,097.06
Interfund Transfers
.00
.00
.00
.00
.00
.00 .00 +++ .00
EXPENSE TOTALS $4,822,000.00 $2,041,886.00 $6,863,886.00 $465,804.32 $1,869,747.01 $4,303,552.21 $690,586.78 90% $6,813,022.22
Fund 023 - Street Improvement Construc Fund Totals $4,822,000.00 $2,041,886.00 $6,863,886.00 $465,804.32 $1,869,747.01 $4,303,552.21 $690,586.78 $6,813,022.22
M
Expense Budget by Account Classification
1
Report
Through 09/30/15
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 024 - Flood Control Construction Fund
EXPENSE
Contractual Services
12,000.00
.00
12,000.00
.00
.00
.00
12,000.00 0 .00
Utilities
2,300.00
.00
2,300.00
156.51
.00
1,670.08
629.92 73 915.87
Commodities & Supplies
5,000.00
.00
5,000.00
.00
.00
.00
5,000.00 0 .00
Other Expenditures
5,100.00
.00
5,100.00
.00
.00
.00
5,100.00 0 .00
Other Equipment
.00
.00
.00
.00
.00
.00
.00 +++ .00
Distribution Systems
.00
.00
.00
.00
.00
.00
.00 +++ .00
Infrastructure
9,779,960.00
868,591.00
10,648,551.00
1,544,488.22
5,588,576.16
3,974,665.93
1,085,308.91 90 377,319.01
EXPENSE TOTALS
Fund 024 - Flood Control Construction Fund Totals
M
$9,804,360.00 $868,591.00 $10,672,951.00 $1,544,644.73 $5,588,576.16 $3,976,336.01 $1,108,038.83 90% $378,234.88
$9,804,360.00 $868,591.00 $10,672,951.00 $1,544,644.73 $5,588,576.16 $3,976,336.01 $1,108,038.83 $378,234.88
Expense Budget by Account Classification
EXPENSE TOTALS
Fund 040 - Refuse Disposal Fund Totals
$4,713,964.00 $4,742.00 $4,718,706.00 $355,027.56 $12,177.07 $3,208,719.86 $1,497,809.07 68% $3,228,143.71
$4,713,964.00 $4,742.00 $4,718,706.00 $355,027.56 $12,177.07 $3,208,719.86 $1,497,809.07 $3,228,143.71
Report
L
Through 09/30/15
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 040 - Refuse Disposal Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
236,644.00
.00
236,644.00
18,251.87
.00
176,645.36
59,998.64 75 181,890.25
Employee Benefits
110,436.00
.00
110,436.00
12,750.90
.00
86,444.73
23,991.27 78 80,773.11
Other Employee Costs
1,248.00
.00
1,248.00
.00
.00
.00
1,248.00 0 1,224.00
Contractual Services
4,294,934.00
4,742.00
4,299,676.00
319,698.67
9,200.00
2,890,132.93
1,400,343.07 67 2,916,684.61
Utilities
447.00
.00
447.00
21.98
.00
189.16
257.84 42 212.79
Insurance
31,809.00
.00
31,809.00
2,650.75
.00
23,856.75
7,952.25 75 21,480.03
Commodities & Supplies
38,446.00
.00
38,446.00
1,653.39
2,977.07
31,450.93
4,018.00 90 25,878.92
EXPENSE TOTALS
Fund 040 - Refuse Disposal Fund Totals
$4,713,964.00 $4,742.00 $4,718,706.00 $355,027.56 $12,177.07 $3,208,719.86 $1,497,809.07 68% $3,228,143.71
$4,713,964.00 $4,742.00 $4,718,706.00 $355,027.56 $12,177.07 $3,208,719.86 $1,497,809.07 $3,228,143.71
Expense Budget by Account Classification
EXPENSE TOTALS $2,156,955.00 $0.00 $2,156,955.00 $20,688.92 $160,073.23 $493,474.80 $1,503,406.97 30% $570,869.55
Fund 041 - Motor Fuel Tax Fund Totals $2,156,955.00 $0.00 $2,156,955.00 $20,688.92 $160,073.23 $493,474.80 $1,503,406.97 $570,869.55
00
Report
L
Through 09/30/15
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
EXPENSE
Contractual Services
284,686.00
.00
284,686.00
9,752.07
13,444.35
168,243.21
102,998.44 64 194,432.42
Utilities
156,060.00
.00
156,060.00
9,496.85
.00
121,337.88
34,722.12 78 134,920.76
Commodities & Supplies
453,209.00
.00
453,209.00
.00
127,207.88
177,324.24
148,676.88 67 231,459.75
Building Improvements
600,000.00
.00
600,000.00
.00
.00
.00
600,000.00 0 .00
Infrastructure
663,000.00
.00
663,000.00
1,440.00
19,421.00
26,569.47
617,009.53 7 10,056.62
EXPENSE TOTALS $2,156,955.00 $0.00 $2,156,955.00 $20,688.92 $160,073.23 $493,474.80 $1,503,406.97 30% $570,869.55
Fund 041 - Motor Fuel Tax Fund Totals $2,156,955.00 $0.00 $2,156,955.00 $20,688.92 $160,073.23 $493,474.80 $1,503,406.97 $570,869.55
00
Expense Budget by Account Classification
EXPENSE TOTALS $419,264.00 $0.00 $419,264.00 $23,653.35 $202,208.45 $141,054.37 $76,001.18 82% $137,596.89
Fund 042 - CDBG Totals $419,264.00 $0.00 $419,264.00 $23,653.35 $202,208.45 $141,054.37 $76,001.18 $137,596.89
Report
L
Through 09/30/15
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 042 - CDBG
EXPENSE
Personal Services, Scheduled Salaries & Wages
48,783.00
.00
48,783.00
3,750.00
.00
37,699.24
11,083.76 77 35,062.53
Employee Benefits
25,491.00
.00
25,491.00
2,094.19
.00
19,140.29
6,350.71 75 19,239.09
Other Employee Costs
1,040.00
.00
1,040.00
.00
.00
133.32
906.68 13 178.32
Contractual Services
154,430.00
.00
154,430.00
3,409.16
2,208.45
61,564.02
90,657.53 41 70,272.95
Commodities & Supplies
520.00
.00
520.00
.00
.00
.00
520.00 0 .00
Other Expenditures
189,000.00
.00
189,000.00
14,400.00
.00
22,517.50
166,482.50 12 12,844.00
Land Improvements
.00
.00
.00
.00
.00
.00
.00 +++ .00
Building Improvements
.00
.00
.00
.00
.00
.00
.00 +++ .00
Infrastructure
.00
.00
.00
.00
200,000.00
.00
(200,000.00) +++ .00
EXPENSE TOTALS $419,264.00 $0.00 $419,264.00 $23,653.35 $202,208.45 $141,054.37 $76,001.18 82% $137,596.89
Fund 042 - CDBG Totals $419,264.00 $0.00 $419,264.00 $23,653.35 $202,208.45 $141,054.37 $76,001.18 $137,596.89
Expense Budget by Account Classification
1
Report
Through 09/30/15
Prior Fiscal Year Activity Included
Adopted
Budget
Amended
Current Month
YTD
YTD Budget- YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions Transactions Rec'd Prior Year YTD
Fund 043 -Asset Seizure Fund
EXPENSE
Other Employee Costs
1,000.00
.00
1,000.00
.00
.00
.00 1,000.00 0 .00
Contractual Services
3,000.00
.00
3,000.00
.00
.00
2,000.00 1,000.00 67 4,000.00
Other Equipment
15,000.00
.00
15,000.00
555.14
.00
7,043.89 7,956.11 47 1,642.29
EXPENSE TOTALS
Fund 043 -Asset Seizure Fund Totals
0
$19,000.00 $0.00 $19,000.00 $555.14 $0.00 $9,043.89 $9,956.11 48% $5,642.29
$19,000.00 $0.00 $19,000.00 $555.14 $0.00 $9,043.89 $9,956.11 $5,642.29
Expense Budget by Account Classification
1
Report
Through 09/30/15
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 - Federal Equitable Share Funds
EXPENSE
Contractual Services
1,000.00
.00
1,000.00
.00
.00
.00 1,000.00 0 .00
Building Improvements
.00
.00
.00
.00
.00
.00 .00 +++ .00
Other Equipment
1,000.00
.00
1,000.00
.00
.00
.00 1,000.00 0 .00
EXPENSE TOTALS
Fund 044 - Federal Equitable Share Funds Totals
$2,000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 0% $0.00
$2,000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 $0.00
Expense Budget by Account Classification
1
Report
Through 09/30/15
Prior Fiscal Year Activity Included
Adopted
Budget
Amended
Current Month
YTD
YTD Budget- YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions Transactions Rec'd Prior Year YTD
Fund 045 - DUI Fine Fund
EXPENSE
Other Employee Costs
1,000.00
.00
1,000.00
.00
.00
640.30 359.70 64 .00
Contractual Services
.00
.00
.00
.00
.00
.00 .00 +++ .00
Other Equipment
1,000.00
.00
1,000.00
.00
.00
3,932.50 (2,932.50) 393 2,767.30
Interfund Transfers
.00
.00
.00
.00
.00
.00 .00 +++ .00
EXPENSE TOTALS
Fund 045 - DUI Fine Fund Totah.
So
$2,000.00 $0.00 $2,000.00 $0.00 $0.00 $4,572.80 ($2,572.80) 229% $2,767.30
$2,000.00 $0.00 $2,000.00 $0.00 $0.00 $4,572.80 ($2,572.80) $2,767.30
Expense Budget by Account Classification
1
Report
Through 09/30/15
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 046 - Foreign Fire Tax Board Fund
EXPENSE
Contractual Services
10,000.00
.00
10,000.00
66.00
.00
7,488.88 2,511.12 75 3,967.27
Insurance
500.00
.00
500.00
.00
.00
.00 500.00 0 .00
Commodities & Supplies
5,000.00
.00
5,000.00
.00
.00
444.26 4,555.74 9 211.65
Other Equipment
15,000.00
.00
15,000.00
.00
.00
31,488.86 (16,488.86) 210 11,688.00
EXPENSE TOTALS
Fund 046 - Foreign Fire Tax Board Fund Totals
w
$30,500.00 $0.00 $30,500.00 $66.00 $0.00 $39,422.00 ($8,922.00) 129% $15,866.92
$30,500.00 $0.00 $30,500.00 $66.00 $0.00 $39,422.00 ($8,922.00) $15,866.92
Expense Budget
by Account
Classification
Report
Through 09/30/15
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 048 - Business District Fund
EXPENSE
Bond Principal
.00
.00 .00 .00
.00 .00
.00 +++ .00
Interest Expense
1,021,000.00
.00 1,021,000.00 200,730.38
.00 571,738.46
449,261.54 56 .00
EXPENSE TOTALS
$1,021,000.00
$0.00 $1,021,000.00 $200,730.38
$0.00 $571,738.46
$449,261.54 56% $0.00
Fund 048 - Business District Fund Totals
$1,021,000.00
$0.00 $1,021,000.00 $200,730.38
$0.00 $571,738.46
$449,261.54 $0.00
Expense Budget by Account Classification
EXPENSE TOTALS
Fund 050 -Water and Sewer Fund Totals
$15,564,787.00 $2,344,148.00 $17,908,935.00 $1,931,804.57 $2,082,546.47 $11,295,648.95 $4,530,739.58 75% $9,177,356.43
$15,564,787.00 $2,344,148.00 $17,908,935.00 $1,931,804.57 $2,082,546.47 $11,295,648.95 $4,530,739.58 $9,177,356.43
Report
L
Through 09/30/15
Prior Fiscal Year Activity Included
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget- YTD
% used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd Prior Year YTD
Fund 050 -Water and Sewer Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
2,006,058.00
.00
2,006,058.00
139,421.95
.00
1,428,446.55
577,611.45
71 1,490,174.03
Employee Benefits
772,177.00
.00
772,177.00
66,568.63
.00
583,239.96
188,937.04
76 575,555.58
Other Employee Costs
37,393.00
.00
37,393.00
948.95
211.75
17,380.53
19,800.72
47 25,104.01
Contractual Services
8,650,244.00
140,210.00
8,790,454.00
770,209.12
166,331.60
5,888,577.76
2,735,544.64
69 5,467,659.64
Utilities
160,913.00
.00
160,913.00
4,094.07
.00
78,009.36
82,903.64
48 89,537.79
Insurance
101,312.00
.00
101,312.00
8,442.67
.00
75,983.98
25,328.02
75 60,355.44
Commodities & Supplies
293,516.00
.00
293,516.00
21,810.27
37,162.09
172,940.72
83,413.19
72 125,724.67
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
+++ .00
Building Improvements
65,000.00
37,225.00
102,225.00
39,750.00
49,700.00
49,458.64
3,066.36
97 1,350.00
Office Equipment
3,930.00
.00
3,930.00
.00
.00
.00
3,930.00
0 .00
Other Equipment
1,173,744.00
1,546,434.00
2,720,178.00
453,659.53
473,866.24
2,113,030.31
133,281.45
95 1,051,255.02
Distribution Systems
2,300,500.00
620,279.00
2,920,779.00
426,899.38
1,355,274.79
888,581.14
676,923.07
77 290,640.25
Infrastructure
.00
.00
.00
.00
.00
.00
.00
+++ .00
Bond Principal
.00
.00
.00
.00
.00
.00
.00
+++ .00
Interest Expense
.00
.00
.00
.00
.00
.00
.00
+++ .00
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
+++ .00
EXPENSE TOTALS
Fund 050 -Water and Sewer Fund Totals
$15,564,787.00 $2,344,148.00 $17,908,935.00 $1,931,804.57 $2,082,546.47 $11,295,648.95 $4,530,739.58 75% $9,177,356.43
$15,564,787.00 $2,344,148.00 $17,908,935.00 $1,931,804.57 $2,082,546.47 $11,295,648.95 $4,530,739.58 $9,177,356.43
Expense Budget by Account Classification
Report
Through 09/30/15
%===f
Prior Fiscal Year Activity Included
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget- YTD
% used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions
Rec'd
Prior Year YTD
Fund 051 - Village Parking System Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
35,175.00
.00
35,175.00
2,711.21
.00
24,877.06
10,297.94
71
27,203.13
Employee Benefits
17,353.00
.00
17,353.00
1,345.17
.00
12,147.21
5,205.79
70
12,093.06
Contractual Services
94,382.00
.00
94,382.00
4,579.56
1,701.53
58,773.94
33,906.53
64
47,106.78
Insurance
2,156.00
.00
2,156.00
179.67
.00
1,617.03
538.97
75
881.28
Commodities & Supplies
520.00
.00
520.00
.00
.00
.00
520.00
0
170.00
Other Expenditures
.00
.00
.00
.00
.00
.00
.00
+++
.00
Building Improvements
7,074.00
.00
7,074.00
1,750.00
.00
3,500.00
3,574.00
49
2,103.47
Infrastructure
153,500.00
.00
153,500.00
.00
6,750.00
.00
146,750.00
4
36,121.53
Interfund Transfers
.00
.00
.00
.00
.00
.00
.00
+++
.00
EXPENSE TOTALS $310,160.00 $0.00 $310,160.00 $10,565.61 $8,451.53 $100,915.24 $200,793.23 35% $125,679.25
Fund 051 - Village Parking System Fund Totals $310,160.00 $0.00 $310,160.00 $10,565.61 $8,451.53 $100,915.24 $200,793.23 $125,679.25
v
Expense Budget by Account Classification
1
Report
Through 09/30/15
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
25,830.00
.00
25,830.00
1,996.25
.00
18,287.03
7,542.97 71 19,797.95
Employee Benefits
13,024.00
.00
13,024.00
997.84
.00
9,000.79
4,023.21 69 8,960.86
Contractual Services
114,325.00
.00
114,325.00
10,968.56
1,301.16
82,292.34
30,731.50 73 63,205.82
Utilities
10,733.00
.00
10,733.00
653.69
.00
3,975.71
6,757.29 37 5,094.39
Insurance
1,757.00
.00
1,757.00
146.42
.00
1,317.78
439.22 75 1,054.53
Commodities & Supplies
9,974.00
.00
9,974.00
1,337.63
.00
4,966.92
5,007.08 50 6,250.56
Other Expenditures
.00
.00
.00
.00
.00
.00
.00 +++ .00
Building Improvements
75,000.00
.00
75,000.00
.00
.00
.00
75,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
$250,643.00
$0.00
$250,643.00
$16,100.39
$1,301.16
$119,840.57
$129,501.27 48% $104,364.11
Fund 052 - Parking System Revenue Fund Totals
$250,643.00
$0.00
$250,643.00
$16,100.39
$1,301.16
$119,840.57
$129,501.27 $104,364.11
Expense Budget by Account Classification
ao EXPENSE TOTALS $2,194,898.00 $39,139.00 $2,234,037.00 $138,058.34 $219,839.28 $1,430,523.69 $583,674.03 74% $1,544,896.20
Fund 060 - Vehicle Maintenance Fund Totals $2,194,898.00 $39,139.00 $2,234,037.00 $138,058.34 $219,839.28 $1,430,523.69 $583,674.03 $1,544,896.20
Report
L
Through 09/30/15
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 060 - Vehicle Maintenance Fund
EXPENSE
Personal Services, Scheduled Salaries & Wages
951,226.00
.00
951,226.00
67,568.43
.00
686,283.96
264,942.04 72 701,144.83
Employee Benefits
379,364.00
.00
379,364.00
27,107.02
.00
261,617.80
117,746.20 69 269,841.68
Other Employee Costs
2,408.00
.00
2,408.00
.00
.00
1,596.33
811.67 66 2,136.28
Contractual Services
102,813.00
31,844.00
134,657.00
7,633.12
26,593.83
68,585.65
39,477.52 71 54,906.71
Utilities
3,132.00
.00
3,132.00
285.44
.00
2,675.99
456.01 85 1,792.33
Commodities & Supplies
735,223.00
7,295.00
742,518.00
34,870.33
193,245.45
392,443.57
156,828.98 79 498,582.21
Other Expenditures
.00
.00
.00
.00
.00
.00
.00 +++ .00
Office Equipment
567.00
.00
567.00
.00
.00
54.67
512.33 10 132.99
Other Equipment
20,165.00
.00
20,165.00
594.00
.00
17,265.72
2,899.28 86 16,359.17
ao EXPENSE TOTALS $2,194,898.00 $39,139.00 $2,234,037.00 $138,058.34 $219,839.28 $1,430,523.69 $583,674.03 74% $1,544,896.20
Fund 060 - Vehicle Maintenance Fund Totals $2,194,898.00 $39,139.00 $2,234,037.00 $138,058.34 $219,839.28 $1,430,523.69 $583,674.03 $1,544,896.20
Expense Budget by Account Classification
EXPENSE TOTALS
Fund 061 - Vehicle Replacement Fund Totals
8
$909,000.00 $273,406.00 $1,182,406.00 $80,299.76 $407,519.60 $255,860.14 $519,026.26 56% $808,951.17
$909,000.00 $273,406.00 $1,182,406.00 $80,299.76 $407,519.60 $255,860.14 $519,026.26 $808,951.17
Report
L
Through 09/30/15
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 061 - Vehicle Replacement Fund
EXPENSE
Other Expenditures
.00
.00
.00
.00
.00
.00 .00 +++ .00
Motor Equipment
909,000.00
273,406.00
1,182,406.00
80,299.76
407,519.60
255,860.14 519,026.26 56 808,951.17
Interfund Transfers
.00
.00
.00
.00
.00
.00 .00 +++ .00
EXPENSE TOTALS
Fund 061 - Vehicle Replacement Fund Totals
8
$909,000.00 $273,406.00 $1,182,406.00 $80,299.76 $407,519.60 $255,860.14 $519,026.26 56% $808,951.17
$909,000.00 $273,406.00 $1,182,406.00 $80,299.76 $407,519.60 $255,860.14 $519,026.26 $808,951.17
Expense Budget by Account Classification
1 Report
Through 09/30/15
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 429,380.00
.00
429,380.00
10,313.14
37,768.42
71,262.16
320,349.42 25
76,076.73
EXPENSE TOTALS $429,380.00
$0.00
$429,380.00
$10,313.14
$37,768.42
$71,262.16
$320,349.42 25%
$76,076.73
Fund 062 - Computer Replacement Fund Totals $429,380.00
$0.00
$429,380.00
$10,313.14
$37,768.42
$71,262.16
$320,349.42
$76,076.73
N
O
Expense Budget by Account Classification
1
Report
Through 09/30/15
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 063 - Risk Management Fund
EXPENSE
Contractual Services
25,000.00
.00
25,000.00
.00
.00
12,150.00 12,850.00 49 10,300.00
Insurance
7,889,896.00
.00
7,889,896.00
585,804.81
.00
6,096,666.21 1,793,229.79 77 6,294,808.66
Other Equipment
165,000.00
.00
165,000.00
199.05
.00
199.05 164,800.95 0 58.25
Infrastructure
.00
.00
.00
.00
.00
.00 .00 +++ .00
Interfund Transfers
.00
.00
.00
.00
.00
.00 .00 +++ .00
EXPENSE TOTALS $8,079,896.00 $0.00 $8,079,896.00 $586,003.86 $0.00 $6,109,015.26 $1,970,880.74 76% $6,305,166.91
Fund 063 - Risk Management Fund Totals $8,079,896.00 $0.00 $8,079,896.00 $586,003.86 $0.00 $6,109,015.26 $1,970,880.74 $6,305,166.91
N
N
N
Expense Budget
by Account
Classification
Report
Through 09/30/15
Prior Fiscal Year Activity Included
Adopted
Budget
Amended
Current Month
YTD
YTD
Budget- YTD % used/
Account Classification
Budget
Amendments
Budget
Transactions
Encumbrances
Transactions
Transactions Rec'd Prior Year YTD
Fund 070 - Police Pension Fund
EXPENSE
Pension Benefits
4,472,170.00
.00
4,472,170.00
372,867.00
.00
3,381,577.99
1,090,592.01 76 3,040,053.91
Contractual Services
154,100.00
.00
154,100.00
2,596.61
.00
72,824.92
81,275.08 47 74,150.88
Insurance
15,000.00
.00
15,000.00
.00
.00
12,558.00
2,442.00 84 11,960.00
Commodities & Supplies
100.00
.00
100.00
.00
.00
.00
100.00 0 .00
Other Expenditures
12,000.00
.00
12,000.00
.00
.00
9,368.42
2,631.58 78 8,555.00
Office Equipment
.00
.00
.00
.00
.00
.00
.00 +++ .00
EXPENSE TOTALS
$4,653,370.00
$0.00
$4,653,370.00
$375,463.61
$0.00
$3,476,329.33
$1,177,040.67 75% $3,134,719.79
Fund 070 - Police Pension Fund Totals
$4,653,370.00
$0.00
$4,653,370.00
$375,463.61
$0.00
$3,476,329.33
$1,177,040.67 $3,134,719.79
N
N
Expense Budget by Account Classification
1
Report
Through 09/30/15
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
EXPENSE
Pension Benefits
4,334,168.00
.00
4,334,168.00
386,831.19
.00
3,395,252.41 938,915.59 78 3,101,668.58
Contractual Services
136,100.00
.00
136,100.00
3,675.07
.00
81,137.52 54,962.48 60 70,931.03
Insurance
15,000.00
.00
15,000.00
.00
.00
13,493.00 1,507.00 90 13,100.00
Commodities & Supplies
1,000.00
.00
1,000.00
.00
.00
.00 1,000.00 0 .00
Other Expenditures
12,000.00
.00
12,000.00
.00
.00
8,000.00 4,000.00 67 8,450.00
EXPENSE TOTALS $4,498,268.00 $0.00 $4,498,268.00 $390,506.26 $0.00 $3,497,882.93 $1,000,385.07 78% $3,194,149.61
Fund 071 - Fire Pension Fund Totals $4,498,268.00 $0.00 $4,498,268.00 $390,506.26 $0.00 $3,497,882.93 $1,000,385.07 $3,194,149.61
Grand Totals $115,972,850.00 $8,257,928.00 $124,230,778.00 $9,868,754.10 $12,866,060.64 $75,724,666.78 $35,640,050.58 $72,336,916.66
N
W
VILLAGE OF MOUNT PROSPECT
List of Bills
October 1- October 14, 2015
Fund Vendor Name
Invoice Description
Amount
001 General Fund
Acs Government Systems, Inc.
Firehouse Software Support
$ 2,680.00
ACS State & Local Government Solutions
Illinois State Disbursement Unit
6,311.29
Active Alarm Company, Inc.
Equipment Maintenance
145.00
Addison Building Material Co.
Maintenance and repair supplies
28.99
Special Events Supplies
123.60
Air Comfort Corporation
HVAC Repairs
1,074.98
Replace the compressor and suction accumulator at HVAC unit @ PW
3,494.00
Airgas, Inc.
Oxygen Tank Supplies for 2015
333.54
American Landscaping Inc.
Grass cutting - 2 N. Main
254.00
Anderson Pest Solutions
Hornets Nest at 1816 Hopi
95.00
Hornets Nest at 14 N. Waverly
95.00
Hornets Nest at 1801 Pheasant
100.00
Hornets Nest at 1201 Greenwood
100.00
Professional Services
100.00
Professional Services
100.00
Professional Services
100.00
Professional Services
100.00
Wasp nest in stop sign
100.00
Professional Services
48.00
322 Helena -was in parkway tree
100.00
Andrade, Consuelo
New World Conference Reimbursement
62.92
Aramark Uniform Services, Inc.
Uniform Cleaning and Rental
96.74
Uniform rental and cleaning for Public works employees
98.72
Uniform Cleaning and Rental
98.72
ARC Document Solutions, LLC
Equipment Maintenance
62.00
Arrowhead Scientific Inc.
ET Supplies
200.50
Bald Eagle Window Cleaning
Window cleaning at the Police -Fire Staiton only for open house
225.00
Baldini, Carol
Reimbursement for diabetes class supplies
37.29
Reimbursement for supplies for diabetes class
87.96
Reimbursement for supplies for diabetes class
139.00
Reimbursement for supplies for diabetes class
203.98
Reimbursement for supplies for diabetes class
23.60
Reimbursment for senior/event supplies
39.99
Beckner, Nellie
IEDC Conf. Reimbursement
899.80
Bedco Mechanical
HVAC Repairs
104.00
Repairs to second floor AC unit at Police and Fire building
276.25
HVAC Repairs
237.80
Bran, Victoria A.
Reimbursement for gift cards for babysitters
495.00
Reimbursement for supplies for Ask Your Village/School Supplies
154.46
Reimbursement for school supplies
117.10
Bright Electrical Supply Co.
Light bulbs for stock
749.71
Maintenance and repair supplies
210.00
Brownells, Inc.
Magazines for weapons
244.47
Business Oriented Software Solutions, Inc.
Annual Maintenance/Support
3,360.00
Busse's Flowers & Gifts
Office Supplies
73.50
Office Supplies
70.00
Office Supplies
70.00
Gifts & Flowers
85.00
Capital One National Association
Costco Purchase 8/31/15 - 9/16/15
1,248.35
CBT Nuggets LLC
Online Training Renewal
1,499.00
CDW Government, Inc.
Websense Support
11,228.00
Central Continental Bakery
Other Employee Expenses
130.37
Century Cleaners
Uniform Cleaning
12.30
Uniform Cleaning
10.48
Uniform Cleaning
14.13
Uniform Cleaning
18.68
Uniform Cleaning
15.95
Uniform Cleaning
14.13
Page 1 of 8
VILLAGE OF MOUNT PROSPECT
List of Bills
October 1- October 14, 2015
Fund Vendor Name
Invoice Description
Amount
Uniform Cleaning
17.75
Uniform Cleaning
20.50
Uniform Cleaning
14.13
Uniform Cleaning
12.30
Chem -wise Ecological Pest Mgmt Inc
Monthly billing for pest control services at 7 buildings for Oct
215.00
CL Graphics, Inc.
Skip the Line Buckslip Rack Card Finance 2015
178.96
Village Board Citizens Guide 2015 Update
25.00
Comcast
Xfinity internet service 10/11-11/10/15
82.90
Cooney, William J.
Reimbursement for Registration
375.00
Costar Realty Information, Inc.
Costar
542.09
Crystal Court Shopping Center
November rent for the CCC
5,914.97
Crystal Maintenance Services Corp.
Janitoial service at 8 buildings for the month of October
7,187.24
D.J.'s Scuba Locker
Dive Equipment Maintenance 2015
2,861.14
Dave's Specialty Foods Inc.
Cassady meet & greet
367.00
de Wolfe Music USA Inc.
Music License for year 2015/16
1,300.00
Dennison Leafblad, Deborah
Freelance Camera
150.00
Dubin, Nicki
Translation services for Investigations
150.00
Elite Remodeling Group, Inc.
Garnishment
142.22
Emergency Medical Products
MRx cables, pads, combi carrier, eye protection, bandages
2,933.06
MRx cables, pads, combi carrier, eye protection, bandages
410.00
Blood Pressure Manometers
592.50
ESRI Inc.
GIS Annual Support
15,250.00
Evans, Tim
2015 Fire Uniform Allowance
139.00
Experian
Background checks- September, 2015
77.00
Fire Pension Fund
Fire Pension
22,181.52
Fonseca, Michael B.
2015 Fire Uniform Allowance
55.25
Forensic Psychology Associates
Fitness for duty evaluation: E. Szmergalski
3,146.25
Fox Valley Fire & Safety
Equipment maintenance and repair
205.15
Gambino Landscaping and Brick Paving, Inc.
Sprinkler maintenance
1,392.25
Gasparas, Rafaela
ICC Certification renewal
87.50
Government Finance Officers Assoc
Membership Renewal 12/1/15 - 11/30/16
595.00
Grainger Inc.
Pack -a -Cone 28" light up safety cones (2)
102.20
Maintenance and repair supplies
170.60
Maintenance and repair supplies
84.35
GreatAmerica Financial Services Corporation
Office equipment
149.47
Griffin, Timothy
Reimburse expenses: Meeting w/ FBI supervisor
58.84
Headco Industries, Inc.
Street Sweeping Supplies
61.01
Healy Asphalt Company,llc.
Streets Patching Materials
427.04
Hedman, Eric J.
Register C. Berg for training course 11/06/15
25.00
Herrera Landscape, Inc.
Grounds Maintenance
5,112.04
Grounds Maintenance
45.60
Homer Tree Care, Inc.
Tree Removals
1,665.60
Tree Removals
2,957.45
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
19,151.74
Illinois American Water Company
Private Fire Service 10/2/15 - 10/29/15
33.84
Illinois Assn. of Chiefs of Police
Course registration: Janowick, Griffin, McGuffin & Addante
396.00
Illinois Department of Revenue
IL State Withholding
27,018.14
IL State Withholding
21.49
Illinois GFOA
Job Post 9/29/15 (Accountant)
250.00
Illinois Paper Co.
Copy Paper
1,199.60
Internal Revenue Service
Federal Withholding
170,306.57
Federal Withholding
159.89
International Code Council, Inc.
ICC dues and memberships
55.00
International Union of Operating Engineers
IUOE PW Membership Dues
986.41
Joe Caputo and Sons AH, Inc.
Cassady meet & greet
435.50
Karlstedt Landscape Group, Inc.
Parkway Restoration
1,019.69
Kerstein, June
Reimbursement Food Exp - September 2015
25.65
Klein, Thorpe and Jenkins, Ltd.
August billing
43,107.54
Knoll, Joseph
2015 Fire Uniform Allowance
304.49
Kolasa, Scott
Transfer Stamp Rebate
780.00
Krupa, Frank M.
Seminar Reimbursent-Frank Krupa
239.26
Kuhar, James
2015 Fire Uniform Allowance
127.00
L & B Business Services Inc.
Maintenance and repair supplies
120.91
Lambel, Brian
Reimbursement to Lambel for IAFC Conference Airfare 8/25-8/29/15
646.30
Page 2 of 8
VILLAGE OF MOUNT PROSPECT
List of Bills
October 1- October 14, 2015
Fund Vendor Name
Invoice Description
Amount
Leeney, David J
Transfer Stamp Rebate
1,310.00
Lexisnexis Risk Data Management Inc.
Background checks - September, 2015
92.20
Life Assist
First Aid Kit Supplies, Glucometer Testing Solutions
229.48
Mcmaster-carr Supply Co.
Maintenance and repair supplies
174.26
Menard Inc.
Range supplies
28.92
Meridian It Inc.
Smartnet renewals
3,112.17
Metro Federal Credit Union
MP Fire Local 4119 Dues
2,239.38
Metropolitan Alliance - Police
MP Police Association Dues
1,349.50
Milieu Design LLC
Landscape Maintenance
2,616.65
Mobile Print Inc.
Apartment Safety Rack Cards
260.93
EDC Breakfast Invitations
1,038.05
OktoberfestTree Lighting Rackcards 2015
383.15
Apartment Safety Rack Cards
326.89
Cassady invitations
171.00
Business cards for Jill Heinking
50.92
UB Collection Labels
120.28
Memo pads
30.07
Memo pads: M. Bonner
47.53
Municipal Emergency Services, Inc.
Depty Chief & Battalion Chief Silver Leaf Shields
314.50
Murphy, John J.
Reimbursement - Traveling Expenses 8/19-8/20 & 8/31-9/1
1,516.76
Nabielec, Mark
2015 Fire Uniform Allowance
307.60
National Fire Sprinkler Assoc.
Online Training
450.00
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
11,971.01
NCPERS Group Life Ins.
IMRF Life Insurance
641.60
Neenah Foundry Company
Other Equipment
4,110.05
Neopost USA Inc.
Postage Machine Replenishment - 10/02/15
3,000.00
New World Systems Corporation
New World Conf. lodging
450.00
NICOR
Natural Gas Consumption
9.55
Natural Gas Consumption
17.24
Natural Gas Consumption
11.63
Natural Gas Consumption
241.43
Natural Gas Consumption
119.73
Natural Gas Consumption
1,307.11
Northeastern III. Pub. Safety Trng.
Slobe Leadership 11 9/14/15-9/18/15
300.00
Northern Illinois Police Alarm System
NIPAS uniform supplies
18.25
Northshore University Healthsystem
Vaccination: R. Smith
18.00
Medical exam: S. Sparr
453.00
Northwest Central Dispatch System
November 2015 - Member Assessment
55,795.54
Northwest Suburban United Way
United Way
106.36
Northwestern University
Register J. Brogan for training course
900.00
Office Depot
Office Supplies
300.81
Office Supplies - September 2015
114.28
Office Supplies
82.45
Office Supplies
7.67
Petty Cash
Petty Cash - Police Department 9/25/15
222.51
Police Pension Fund
Police Pension
29,806.12
Rayco Sign Supply
Sign Making Materials
112.50
Rebel's Trophies, Inc.
Mike Cassady Board Room Name Plate 2015
17.50
Red Wing Shoe Store
Safety Shoe Allowance
146.24
Reder, Abigail M
Refund Overpayment Police Ticket #P3940890
50.00
Rittle, John
Historical Building Maintenance
3,800.00
Rkon Inc.
Check Point VPN Licenses
4,478.00
Check Point Firewall Support Renewal
19,981.56
Rouske, Jonathan
Transfer Stamp Rebate
630.00
Rydin Sign and Decal
Real Estate Transfer Stamps
640.00
Schram, Jonathon
2015 Fire Uniform Allowance
100.00
Secretary of State
New Vehicle Registration - P-3
105.00
New Vehicle Registration - P-6
105.00
New Vehicle Registration - P-36
105.00
SHI International Corp.
Smartnet renewals
9,621.15
Shomette, Donald Thomas
Register S. Filipek for training class 10/15-16/15
245.00
Sill, Gregory
Reimburse expenses: CPS Recertification course 10/08/15
85.00
Spedale, Bob
Rebate Sidewalk Shared Program
375.00
Staples Contract & Commercial, Inc.
Copy Paper
1,795.20
State of Illinois
Monthly Internet Service
724.00
Page 3 of 8
VILLAGE OF MOUNT PROSPECT
List of Bills
October 1- October 14, 2015
Fund Vendor Name
Invoice Description
Amount
Stenzel, William W.
TSR analysis 01/01/15 - 06/30/15
5,000.00
SysAid Technologies, Ltd.
Maintnenance for MPPD IT Help Desk
90.00
T.P.1.
TPI Services
21,554.00
TPI Invoice
25,017.00
Task Force 1 Inc.
J. Reschke-Response to Active Shooter and Mass Violence 09/24/20
125.00
Slaasted_LMiller/Response to Active Shooter/9-24-15
250.00
Tennant Sales and Service Company
Station 14 Floor Scrubber Maintenance/Repair
401.80
Terrace Supply Company
Special Events Supplies
390.25
The Brickman Group Ltd., LLC
Grounds Maintenance
2,280.00
The Ups Store
Postage 9/17/15
23.80
Thompson Elevator Inspections
Elevator Inspections
37.00
Elevator Inspections
75.00
Elevator Inspections
75.00
Elevator Inspections
37.00
Elevator Inspections
185.00
Elevator Inspections
75.00
Holiday inn Elev.
75.00
Huntington Towers
37.00
TransUnion Risk and Alternative Data Solutions Inc
Background checks - September, 2015
126.75
Tri-state Electronic Corp
Maintenance and repair supplies
150.12
Urban Land Institute
Cassady membership
440.00
Village of Mount Prospect
Flex - Medical
9,245.50
Village of Romeoville
Laurinaitis/Trench Rescue Operations/8.26.15-8.28.15
430.00
Swat/Instructor 1/8.31.15-9.4.15
325.00
Warehouse Direct
computer supplies
145.01
Office Supplies
228.07
WISCTF
Garnishment
542.48
Wolf, Lisa
Sam's Place/Retro Bistro Interview/Scheduling
860.00
Blackfinn/Langostinos Interview
800.00
001 General Fund Total
$
620,374.71
020 Capital Improvement Fund
B & H Photo/video
Boardroom Upgrade Equipment
$
752.00
Business Office Systems, Inc.
Office Furniture
7,499.75
Ehlke Lonigro Architects, Ltd.
Other Public Building Improvements
2,242.00
Gewalt Hamilton Assoc.
Engineering Design services
5,660.84
Northwest Central 9-1-1 System
Motorola Subscriber Financing - October 2015
10,603.91
Shaw Industries, Inc.
Carpeting and glue for PW remodeling project
6,621.80
Public Building Improvements
350.37
020 Capital Improvement Fund Total
$
33,730.67
022 Downtown Redevelopment Construction Fund
Albrecht Enterprises Inc.
Demo of Central Plaza
$
96,350.00
2-40 Main St. project
2,200.00
Durabilt Fence
Fence around Central Plaza Demo
5,076.00
Milieu Design LLC
Landscape Maintenance
6,338.17
Northwest Properties Llc
NWE Sales Tax Rebate 6/1/15-8/31/15
26,358.64
Valerio Dewalt Train Associates, Inc.
Downtown Wayfinding signage
8,211.24
022 Downtown Redevelopment Construction Fund Total
$
144,534.05
023 Street Improvement Construction Fund
Arrow Road Construction
Edwin Hancock Engineering Co.
Quality Blacktop LLC
Ramaswamy, Subramanian
Wiase, Eugene
023 Street Improvement Construction Fund Total
024 Flood Control Construction Fund
Constellation NewEnergy, Inc.
Proforma Customized Graphics
Rubino Engineering, Inc.
024 Flood Control Construction Fund Total
Street Resurfacing $ 289,876.98
Engineering Services 53,027.00
Asphalt patching per contract for street restoration 1,347.84
Refund Vehicle License Fee 40.00
Rebate Sidewalk Shared Program 312.50
$ 344,604.32
Electrical Service Delivery $ 80.27
Isabella Drainage Project 2,015.47
Isabella Combined Sewer Project 1,540.00
$ 3,635.74
Page 4 of 8
VILLAGE OF MOUNT PROSPECT
List of Bills
October 1- October 14, 2015
Fund Vendor Name
Invoice Description
$
Amount
040 Refuse Disposal Fund
ICMA 457 (flat percent)
450.00
Groot Industries, Inc.
Refuse Disposal Program
$
558.90
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
66.54
Illinois Department of Revenue
IL State Withholding
299.36
Internal Revenue Service
Federal Withholding
2,575.42
International Union of Operating Engineers
IUOE PW Membership Dues
103.26
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
200.56
NCPERS Group Life Ins.
IMRF Life Insurance
$
17.60
Third Millennium Assoc.inc.
Sept. 30, 2015 Refuse Billing
706.45
Village of Mount Prospect
Flex - Medical
$
71.88
040 Refuse Disposal Fund Total
Parts for 1-63 seized Acura
$
4,599.97
041 Motor Fuel Tax Fund
Credit for parts for 1-63 seized Acura
(177.82)
A Lamp Concrete
Pavement Restoration
$
2,184.50
Constellation NewEnergy, Inc.
Electrical Service Delivery
64.79
CDS Office Systems, Inc.
Electrical Service Delivery
$
2,213.60
045 DUI Fine Fund Total
Electrical Service Delivery
$
104.71
046 Foreign Fire Tax Board Fund
Electrical Service Delivery
149.32
Tennant Sales and Service Company
Electrical Service Delivery
$
102.74
046 Foreign Fire Tax Board Fund Total
Electrical Service Delivery
$
77.05
050 Water and Sewer Fund
Electrical Service Delivery
124.94
A Lamp Concrete
Electrical Service Delivery
$
37.21
Addison Building Material Co.
Electrical Service Delivery
108.76
Advisicon, Inc.
Electrical Service Delivery
116.06
American Public Works Assoc.
Electrical Service Delivery
60.22
Aramark Uniform Services, Inc.
Electrical Service Delivery
206.85
Electrical Service Delivery
23.02
041 Motor Fuel Tax Fund Total
Uniform Cleaning and Rental
$
5,573.77
042 Community Development Block Grant
Children's Advocacy Center of Nw Cook County
CDBG- Sub recipient 4Qtr PY2014
$
450.00
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
450.00
Illinois Department of Revenue
IL State Withholding
46.09
Internal Revenue Service
Federal Withholding
439.11
Pads to Hope, Inc.
CDBG- 4th Qtr Sub recipient PY2014
3,750.00
Schroeder & Schroeder Inc
2015 CDBG Sidewalk Program
177,495.30
Suburban Primary Health Care Council
CDBG- Sub recipient 4Qtr PY2014
1,500.00
Village of Mount Prospect
Flex - Medical
31.25
042 Community Development Block Grant Total
$
184,161.75
043 Asset Seizure Fund
Dave & Jim's Auto Body, Inc.
Repairs to 1-63 seized Acura
$
276.96
General Parts Inc.
Parts for 1-63 seized Acura
456.00
Credit for parts for 1-63 seized Acura
(177.82)
043 Asset Seizure Fund Total
$
555.14
045 DUI Fine Fund
CDS Office Systems, Inc.
Panasonic Arbitrator annual maintenance agreement
$
7,900.00
045 DUI Fine Fund Total
$
7,900.00
046 Foreign Fire Tax Board Fund
Tennant Sales and Service Company
Furniture & Equipment
$
7,252.22
046 Foreign Fire Tax Board Fund Total
$
7,252.22
050 Water and Sewer Fund
A Lamp Concrete
Pavement Restoration
$
4,551.55
Addison Building Material Co.
Water Valves
11.98
Advisicon, Inc.
Professional Services
1,200.00
American Public Works Assoc.
Training Supplies
146.75
Aramark Uniform Services, Inc.
Uniform Cleaning and Rental
96.74
Uniform rental and cleaning for Public works employees
98.72
Uniform Cleaning and Rental
98.72
Baxter & Woodman, Inc.
Professional Services
3,052.29
Professional Services
7,900.00
Professional Services
4,032.50
Page 5 of 8
VILLAGE OF MOUNT PROSPECT
List of Bills
October 1- October 14, 2015
Fund Vendor Name
Invoice Description
Amount
Elite Remodeling Group, Inc.
Professional Services
4,018.75
ICMA Retirement Trust - 457
Professional Services
800.00
Illinois Department of Revenue
SCADA Wireless
408.75
Central Continental Bakery
Other Employee Expenses
0.81
Century Cleaners
Uniform Cleaning
12.30
Nationwide Mutual Insurance Company
Uniform Cleaning
10.47
NCPERS Group Life Ins.
Uniform Cleaning
14.12
Village of Mount Prospect
Uniform Cleaning
18.67
051 Village Parking System Fund Total
Uniform Cleaning
15.95
Uniform Cleaning
14.12
Uniform Cleaning
17.75
Uniform Cleaning
20.50
Uniform Cleaning
14.12
Uniform Cleaning
12.30
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
1,298.27
Illinois Department of Revenue
IL State Withholding
2,298.44
Internal Revenue Service
Federal Withholding
18,709.04
International Union of Operating Engineers
IUOE PW Membership Dues
1,035.56
John Kwiatkowski
Utility Refund - 215 S. Edward St.
9.03
Karlstedt Landscape Group, Inc.
Parkway Restoration
9,624.26
L & B Business Services Inc.
Repair Maintenance Supplies
73.44
Martam Construction
2015 Water Main Improvements
183,705.75
2015 Water Main Improvements
212,596.20
Milieu Design LLC
Landscape Maintenance
3,120.18
MUNIPLY LLC.
Water Meter Repair Supplies
4,250.00
Nationstar Mortgage LLC
Utility Refund - 107 Fairview Ave.
30.88
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
420.89
NCPERS Group Life Ins.
IMRF Life Insurance
36.80
Nick Nicholas
Utility Refund - 314 N. Prospect Manor Ave.
20.83
NICOR
Natural Gas Consumption
69.33
Natural Gas Consumption
79.40
Natural Gas Consumption
77.73
Northwest Suburban United Way
United Way
21.00
Red Wing Shoe Store
Safety Shoe Allowance
146.24
Safety Shoe Allowance
161.99
Salvation Army
Utility Refund - 1824 Locust Ln.
1,500.00
Suburban Laboratories, Inc.
Water Sample Testing
877.75
Third Millennium Assoc.inc.
New World Upgrade - UB Field Length
150.00
September 2015 Utility Billing
2,393.01
UPS Store #707
Shipping Expenses
13.23
Village of Mount Prospect
Flex - Medical
715.02
Warehouse Direct
Office Supplies
228.07
Xylem Water Solutions USA, Inc.
Equipment maintenance and repair
864.00
Ziebell Water Service Products
Repair Maintenance Supplies
447.30
Maintenance and repair supplies
1,554.34
Repair Maintenance Supplies
974.00
050 Water and Sewer Fund Total
$ 474,069.84
051 Village Parking System Fund
Crystal Maintenance Services Corp.
Janitoial service at 8 buildings for the month of October
$ 330.23
Elite Remodeling Group, Inc.
Garnishment
78.19
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
9.00
Illinois Department of Revenue
IL State Withholding
37.85
Internal Revenue Service
Federal Withholding
303.96
International Union of Operating Engineers
IUOE PW Membership Dues
15.94
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
9.96
NCPERS Group Life Ins.
IMRF Life Insurance
4.40
Village of Mount Prospect
Flex - Medical
34.64
051 Village Parking System Fund Total
$ 824.17
052 Parking System Revenue Fund
Constellation NewEnergy, Inc. Electrical Service Delivery $ 305.89
Electrical Service Delivery 110.08
Crystal Maintenance Services Corp. Janitoial service at 8 buildings for the month of October 252.53
Elite Remodeling Group, Inc. Garnishment 64.02
Page 6 of 8
VILLAGE OF MOUNT PROSPECT
List of Bills
October 1- October 14, 2015
Fund Vendor Name
Invoice Description
Amount
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
6.01
Illinois Department of Revenue
IL State Withholding
27.58
Internal Revenue Service
Federal Withholding
220.92
International Union of Operating Engineers
IUOE PW Membership Dues
10.64
Nationwide Mutual Insurance Company
Nationwide 457 (flat percent)
6.65
NCPERS Group Life Ins.
IMRF Life Insurance
3.60
Union Pacific Railroad
Metra Land Lease - August 2015
3,396.88
Village of Mount Prospect
Flex - Medical
27.44
052 Parking System Revenue Fund Total
$ 4,432.24
060 Vehicle Maintenance Fund
American Messaging
Professional Service
$ 79.67
Arlington Heights Ford
P-4 rear sway bar links
34.85
Equipment maintenance and repair
635.03
Arlington Power Equipment
Vehicle Maintenance Supplies
28.00
Vehicle Maintenance Supplies
7.34
Black Dog Chicago Corp
Vehicle Maintenance Supplies
479.44
Chicago Parts & Sound Llc
Vehicle Maintenance Supplies
295.00
P-8 EVAP purge valve
20.81
Repair Maintenance Supplies
100.00
Police utility front and rear brake rotors
343.16
Dave & Jim's Auto Body, Inc.
Repair Maintenance Supplies
60.00
Finishmaster, Inc.
Vehicle Maintenance Supplies
132.65
Vehicle Maintenance Supplies
246.10
General Parts Inc.
Fuel filters, valve stem valves and brake fluid
47.00
Global Emergency Products
530 Fuel tank & switch magnets
621.40
530 new fuel tank support
291.77
517 brake light switch
68.93
530 fuel tank sender
92.77
Vehicle Maintenance Supplies
2,097.40
530 PTO solenoid, 516 Turbo Hose
201.92
Vehicle Maintenance Supplies
445.79
530 radiator cap
76.15
Grainger Inc.
Vehicle Maintenance Supplies
66.43
Grossinger Chevrolet
S-41 drivers seat belt
168.20
ICMA Retirement Trust - 457
ICMA 457 (flat percent)
1,289.34
Illinois Department of Revenue
IL State Withholding
1,143.25
Internal Revenue Service
Federal Withholding
9,543.85
International Union of Operating Engineers
IUOE PW Membership Dues
494.53
L & B Business Services Inc.
Vehicle Maintenance Supplies
31.90
Lindco Equipment Sales, Inc.
Vehicle Maintenance Supplies
198.87
Mansfield Oil Company
6,000 gallons diesel fuel
12,046.83
Mcmaster-carr Supply Co.
Stainless bolts
17.40
Cover latches
51.50
Wash bay soap drum pumps
77.75
Small Tools
8.18
Small Tools
109.19
Morton Grove Automotive
Equipment Maintenance
185.00
Equipment Maintenance
295.00
Napa -Heights Automotive Supply
Chain saw spark plugs
7.96
CV Police pinion seals
37.70
516 front hose door support struts
65.36
516 Hose clamps
41.88
2734 steering stabilizer
42.68
NCPERS Group Life Ins.
IMRF Life Insurance
48.00
Northwest Suburban United Way
United Way
4.00
Pomp's Tire Service, Inc.
Vehicle Maintenance Supplies
347.99
Precision Service & Parts
S-41 front brake pads/rotors and tie rod ends
368.52
Ronco Industrial Supply
Vehicle Maintenance Supplies
164.65
Rush Truck Centers of Illinois, Inc.
Vehicle Maintenance Supplies
(598.50)
4557 Grab Pillar Handle
245.96
4528 Coolant expansion tank and cap
396.05
Sherrick Tools Inc.
Small Tools
13.02
Terrace Supply Company
Gas Tank Rental
33.42
Vehicle Maintenance Supplies
55.16
Page 7 of 8
VILLAGE OF MOUNT PROSPECT
List of Bills
October 1- October 14, 2015
Fund Vendor Name Invoice Description Amount
Welding gas 85.41
Village of Mount Prospect Flex - Medical 350.02
060 Vehicle Maintenance Fund Total $ 33,841.68
061 Vehicle Replacement Fund
Currie Motors
New Ford Police Utility Squad P-36
$ 28,313.00
Camp McDonald Animal Hospital
New Ford Police Utility Squad P-6
28,018.00
Campos, Angel
New Ford Police Utility Squad P-3
28,018.00
Finishmaster, Inc.
Equipment for Public Works Vehicles
351.90
Coval, Eric
Equipment for Public Works Vehicles
132.65
Lindco Equipment Sales, Inc.
New 2728 V -box spreader chain
1,126.00
Single Source, Inc.
Equipment for Public Works Vehicles
422.28
Ziebart of Illinois
Equipment for Police Dept. Vehicles
225.00
061 Vehicle Replacement Fund Total
Wrong Water Payment 10/7/15
$ 86,606.83
063 Risk Management Fund
Besse Medical Supply Alcohol Prep Steril Med & Glove (Flu Shot) $ 64.30
Intergovernmental Per.ben.coop IPBC- October 2015 487,892.78
Smithkline Beecham Corp. Vaccine & Supplies for Flue Shot 2015 2,293.98
063 Risk Management Fund Total $ 490,251.06
070 Police Pension Fund
Internal Revenue Service Refund of Police Pension Contributions - Nordin $ 839.49
Nordin, Ellen J. Refund of Police Pension Contributions 3,357.98
070 Police Pension Fund Total $ 4,197.47
071 Fire Pension Fund
Bogdahn Consulting, LLC Performance Evaluation 10/1/15 - 12/31/15 $ 9,000.00
Collins & Radja Quarterly Retainer Fee -July, August & Sept 2015 800.00
071 Fire Pension Fund Total $ 9,800.00
073 Escrow Deposit Fund
3D Brick Paving
Refund Escrow Permit # 15-1357 (814 Na Wa Ta Ave)
$ 200.00
Camp McDonald Animal Hospital
Refund Escrow Permit # 14-1807 (2010 E Camp McDonald Rd)
75.00
Campos, Angel
Refund Escrow Permit # 14-1556 (1724 W Verde Dr)
200.00
Refund Escrow Permit # 15-1073 (1724 W Verde Dr)
125.00
Coval, Eric
Refund Escrow Permit # 15-1574 (242 Hatlen Ave)
200.00
Fluder, Marjorie
Refund Escrow Permit # 15-1004 (1207 N Wheeling Rd)
200.00
Illinois State Treasurer
2015 Unclaimed Property Remittance
1,449.97
Kirby, Mary C
Refund Escrow Permit # 14-1621 (307 N Elmhurst Ave)
200.00
Link, John W
Wrong Water Payment 10/7/15
616.35
MJ Wheeling LLC
Refund Escrow Deposit @ 1120-30 Wheeling Road (3rd Release)
35,000.00
Moser, Leonard E
Refund Escrow Permit # 15-1559 (112 N Wille St)
200.00
Mount Prospect Public Library
2015 PPRT - 7th Allocation
9,106.00
Nicor Home Services
Refund Escrow Permit # 14-2517 (1917 E Wood Ln)
125.00
Northscape Enterprises Inc
Refund Escrow Permit # 15-1031 (106 South George St)
200.00
Panikulam, Paul
Refund Escrow Permit # 15-1879 (208 E Lonnquist Blvd)
125.00
Ramo-Gershenson Properties LP
Refund Escrow Permit # 14-1591 (990/1008 Mt. Prospect Plaza)
14,080.00
Spedale, Robert J
Refund Escrow Permit # 15-0940 (802 S Waverly Ave)
200.00
Stolton, Stephen
Refund Escrow Permit # 15-1608 (709 W Lams Ct)
125.00
Third District Circuit Court
Bond Check 10/1/15
1,325.00
Bond Check 10/6/15
1,275.00
Bond Check 10/8/15
500.00
Bond Check 10/13/15
2,750.00
Vincent IV, George A
Refund Escrow Permit # 15-1415 (501 W Lincoln St)
200.00
Wehrle, Emil
Refund Escrow Permit # 15-1390 (205 N Withorn Ln)
125.00
Weseloh, Roger & Donna
Refund Escrow Permit # 15-1614 (12 N Louis St)
125.00
073 Escrow Deposit Fund Total
$ 68,727.32
Grand Total
$ 2,529,672.95
Page 8 of 8