HomeMy WebLinkAbout[04f] Financial Reports Council Agenda Item 4 ff1
crry(w S-1,:osEl"'0t►
MEETING DATE: July 18, 2016
AGENDA ITEM: Financial Report—2nd Quarter 2016 &June 2016 Financial Reports
Budget—Continue discussion on Project Priorities
SUBMITTED BY: Finance
BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A
PREVIOUS COUNCIL ACTION: Council adopted the 2016 budget on December 7, 2015.
BACKGROUND INFORMATION: Quarterly and monthly reconciled cash/investment and budget to
actual position are provided for Council review. The numbers presented are the cash balances as of June
30, 2016.
CASH POSITION:
- The market rate of return(ROR)is approximately 1.13%with an average maturity of just under
two years. The federal markets increased some the end of December; however, have decreased
significantly since the beginning of 2016. At June 30"', the 10-year reported 1.47%, 5-year
reported 1.00% and 2-year at 0.58%. St. Joseph has a better rate of return using the local
institutions and broker. The City tiers the maturity dates within the boundaries of the Investment
Policy. The tiered maturity dates has helped the City maintain a higher rate of return than the
current market. Sentry Bank and the Central MN Credit Union have given the City favorable
rates on the money market and CD accounts.
- In December the Federal Open Market Committee [FOMC] decided to increase the federal fund
rates to 0.25% citing expanding economic activity. This spurred positive activity in the markets
the end of December. The global economy, labor markets, manufacturing,presidential election
and oil prices have put pressure on the US markets causing the decreased valuations in the first
half of 2016. The recent decision by Great Britain to leave the European Union [Brexit] put
additional pressure on the federal economy. Current economic reports suggest 2016 may
continue with rates staying lower based on all these factors mentioned. Markets are indicating the
FOMC will not consider the next rate increase until 2017 or 2018. The FOMC meets every six
weeks to discuss current economic conditions.
- Interest earnings for 2016 amounts to $79,230, 80% of the budget. The City's policy is to hold
investments until maturity. GASB 31 requires the City to mark investments at the current market
value as of the close of each month. In doing so, earnings will show great fluctuations. The year
is starting strong for investment earnings.
- While the market rate of return remains low, debt interest rates are also at all-time lows. The
funds borrowed for the government center were very favorable and the Field Street project should
realize excellent bond rates also.
- Overall, the cash and investments balance decreased $598,001 from the beginning of the year.
Cash was planned to spend down to cover costs of the government center before bond proceeds
were received. Bond proceeds were deposited on July 7th
FUNDS REPORT:
- The General fund spent 46% of the 2016 expenditure budget and received 31% of the revenue
budget. Expenditures are mainly operational in nature. Revenues for building permit activity are
over budget by $28,000 and the City received $15,000 from CSB/SOSB in the general fund.
These revenues can be used to update the comp plan and cover the cost of the Park Board
electrical/mechanical plans for the Millstream park shelter. Interest earnings are also ahead of
schedule for the start of year. Tax revenues from the May collections were partially recorded in
June. The balance is received in July along with the first half Local Government Aid.
The Enterprise Funds represent four months utility billing revenue collected while expenses
represent six months of activity. Water revenue is showing higher than expenses due to the rate
increase in spring. The larger portion of the debt payment will be paid in Nov. The additional
revenues will go towards the debt payments. The St. Cloud sewer debts are paid monthly. There
are also St. Cloud charges for the design costs of their main lift station upgrade paid in the spring.
Overall, 26% of expenses have been incurred(less depreciation); 21% of the revenue budget has
been received.
Water fund analysis (fund 601/501)—The enclosed spreadsheet shows an analysis of the water fund,
including the Water fund(601) and the Water Access fund(WAC-501). The City has received $111,768
in WAC fees for the first half of the year. Connection fees include nine new homes, Kwik Trip and
government center so far in 2016. Water utility revenue is a little behind budget. Water usage is typically
lower in the early months of the year. Summer tends to see higher water usage—depends on heat and
rainfall. Water revenues represent 27% of the budget.
Sewer fund analysis (fund 602/502)—The enclosed spreadsheet shows an analysis of the sewer fund,
including the Sewer fund(602) and the Sewer Access fund(SAC-502). The City has received $51,536 in
SAC fees during the year. Connection fees include nine new homes, Kwik Trip and government center so
far in 2016. Single family maximum sewer usage is set from the Nov/Dec water usage. Sewer revenues
are fairly consistent throughout the year. Sewer expenses are at 27% of the budget, while revenues are at
21% of the budget. The City's sewer debts will be paid in November. The St. Cloud share of the debts
are paid monthly(recorded under the Main Lift Station expenses). The Sewer fund shows a deficit of
$66,097 at June 30"'. Additional SAC fees are expected from the two senior housing projects. Once these
are determined, staff recommends the Council to review the sewer rates in the fall.
V2 ¢ Sales Tax(fund 200): The sales tax fund has a balance of 51,204,193. The City anticipates
collecting $4,000,000 in sales tax revenue through 2018 ($3,372,754 original estimate); $3,054,560 was
collected to date (through April 2016 collections). Collections are spent on the area regional projects for
the first$900,000 in sales tax revenues collected each year. Collections have continually increased over
the years, even during most of the recession years with St. Joseph topping $400,000 in 2015. The
anticipated expenditures total$3,576,440 (less bond proceeds) leaving approximately $466,838 remaining
for the sales tax funding through 2018. The sales tax extension approved in Nov. 2014 is expected to
generate an additional$11,000,000. The second exhibit for the local option sales tax shows the current
balance less projected and approved costs over the life of the sales tax law. The balances represent the
anticipated cash flow through 2039 to provide Council an outlook for local option sales tax usage.
DEBT LEVY: Finance prepared a summary of the current debt levies with a list of projects in the 5-year
CIP plan. The project listing shows a potential debt levy next to the project if a debt levy in anticipated to
be used. The current anticipated 2017 debt levy will increase $212,950 from the 2016 debt levy. With
other portions of the levy remaining unchanged, the overall tax rate may increase 2.4% ($43 per year for a
$200,000 home). We anticipate growth in market values based on current building permits and home
sales. Staff is working with the County Assessor to get an idea of the potential market value increase
before the September preliminary levy certification.
CIP REPORTS:
- Equipment capital outlay in 2016 has been minimal. The Park Board completed the footgolf
course; the fire department purchased some gear for new firefighters; Public Works completed
the install of a garage door at the old PW building (using project residual funds); Admin
purchased scanners and an iPad; and the Police department began purchasing equipment needed
for the 2016 squad replacement(including radar and camera), replaced squad laptops and portable
radios.
BUDGET/FISCAL IMPACT: Information Only
ATTACHMENTS: Request for Council Action—Quarterly and June Financial Reports
2nd Quarter Reports:
Cash Position as of 4/30/16
Cash and Investment Holdings Chart
Cash Balances by Fund/Remaining Budget
General& Fire Budget to Actual Expenditures & Revenues
Enterprise Funds Activity Graph
Quarterly Water Fund Analysis
Half Cent Sales Tax Fund Summary
Sewer Fund Analysis
June Treasurer's ReTorts:
Cash and Investment—Council Report
Council Month End Revenue Summary
Council Month End Revenue—General Fund
Council Month End Revenue—Enterprise Funds
Council Month End Expenditure Summary
Council Month End Expenditure—General Fund
Council Month End Expenses - Enterprise Funds
Capital bnprovement Summary ReTorts:
General Fund Capital Improvement Plan- Summary
General Fund Capital Improvement Plan- Fire
General Fund Capital Improvement Plan- EDA
Enterprise Capital Improvement Plan—Public Works
Capital Improvement Budget Summary—Park Board
REQUESTED COUNCIL ACTION: Accept the financial reports as presented. Discuss budget
project priorities.
City of St. Joseph, Minnesota
Cash Position
As of 6/30/16
Sentry BankMaturity DateInterestCurrent Balance# Securities% of Total
Checking Account (Reconciled)N/A0.15%31,122$ N/A
Money Market SavingsN/A0.43%985,974 N/A
Bank Certificates of Deposit1-6 months0.98%avg 21,000,000
averages4 months0.64%
Total Sentry Bank$2,017,09635%
Central MN Credit Union
Share Savings AccountN/A0.00%5$ N/A
Money Market SavingsN/A0.65%739,834 N/A
Power Money Market CheckingN/A0.30%123,424 N/A
Jumbo Bank Certificates of Deposit19 months1.29%avg 1418,016
averages19 months0.81%
Total CMCU$1,281,27922%
Total Deposits3,298,375$
Morgan Stanley
Brokered Money Market SavingsN/A0.00%1,147$ N/A
Government Securities/NotesN/AN/Aavg 0-
Brokered Certificates of DepositTiered 3-83 months1.93%avg 142,481,818
averages41 months1.93%
Total MS$ 43%2,482,965
Total Investments2,482,965$
2016 YTD
Total Deposits and Investments$ Interest Earned5,781,340
Average Interest APY21 months1.13%$79,230
Total Deposits & Investments$ Cash and Investment Balance5,781,340
Petty Cash
AdministrationN/AN/A200$
Police DepartmentN/AN/A75
Total Petty Cash$275
Custodial Credit Risk: All deposits and investments insured by FDIC/SPIC/NCUA or secured by perfected pledged collateral.
Interest Rate Risk: The City is not exposed to interest rate risk because the City does not invest in highly
sensitive, interest fluctuating investments. The City attempts to purchase longer termed investments
when the interest rates are favorable and depending on cash flow needs to lock into a favorable rate.
Credit Risk: There are no instruments exposed to credit risk.
Maturity
Concentration of Credit Risk: The City invests in various instruments and several financial institutions.
% SecuritiesAverages
Brokered Money Markets1,147$ 0.02%N/A
Brokered Certificates of Deposit2,481,818$ 42.93%3.4 years
Government Bonds/Notes-$ 0.00%N/A
Foreign Currency Risk: The City only invests in USA and USA territories.
v
N v
uU
Y u
v aj v
U C Y Y Y
O O O O
00 U m m m
N
N
O N �
N �
O
}1 rl
M 0
l �
\ c-I
E
N
Z
N
V
� o
ri
0
m
00
i
r
00
N
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
16 RECEIVED16 LEFT
$ 1,798,874 142,374 33,893 8,067 133,594 292,778 495 5,600 476,309 (127,634)
321,297 71,379 1,263,771 1,292,895 181,629 93,170 41,635$
V
$ 803,626 143,136 89,722 33,213 101,926 62,822 4,030 7,255 710,411 187,634
112,103 51,121 310,654 286,875 103,171 27,115 19,400
e
$ 2,602,500$ 285,510$ 123,615$ 41,280$ 235,520$ 355,600$ 4,525$ 12,855$ 1,186,720$ 60,000$ 433,400$
122,500$ 1,574,425$ 1,579,770$ 284,800$ 120,285$ 61,035
As of 6/30/16
$ 1,415,643 266,939 72,406 30,887 2,709,491 390,888 (2,350) - 1,274,181
(1,124,325) 416,500 46,000 1,347,307 1,389,157 160,484 191,096 44,572$
3,054,21419 months of cash balanc
City of St. Joseph, Minnesota
Cash Balances by Fund/Remaining Budget
16 EXP BUD16 SPENT16 LEFT16 BUD RE
$ 1,190,712 45,586 51,209 9,793 164,509 2,812 2,350 - 140,839 1,184,325
- - 227,118 369,583 125,976 23,279 25,018
E
4,080
42,13519,30551,76021,206
582,223112,677119,737112,298151,806244,637256,599
(124,699)(117,857)
1,106,2081,204,1931,995,0295,781,337
$ 2,606,355 312,525 123,615 40,680 2,874,000 393,700 - 1,415,020
60,000 1,574,425 1,758,740 286,460 69,590$ 3,563,109$
- 416,500 46,000 214,375
x
d
d
d
r
FUNDCASH BALANC
TOTALS
2016 cash decrease(598,001)
12/31/15 Cash Balance6,379,338
General FundFire FundEDA FundTIF FundsState Collected Sales TaPark DedicationCharitable GamblingRevolving Loan FunDebt FundsCapital Project FundsWater Access FunSewer Access FunWater
FundSewer FundRefuse/Compost FundStorm SeweStreet Light Utility
WO WO
] \] \
\ \
J
LO
00
g LL
�
c E
g LL.
>
g
� a
06
/
� a [
�
c
g
CL
x
LU
�
�
v
Q j
4-0 \ _
� )
°
J
7
g m LL
n
L
06
�
�
g
c 2
g f
� \ @
a ■
v v
v v
x m
LLJ 00
Lr
O
O
m 0
O
O
O
O
O
� m
Ln �
ui
r- O
� m
00 (' O
v 0
0
O
m
0
` O
•= N 00
V -tn
O
Q rf)
N
O
O
O
LL 0
N
A -tn
WN lD
L �
Lf1
CL cN-I O
L O
O
Ln
4-0
W
m
O O
0
0
O
00 rn Lr)
r- r-I
O N I
m ^ O
N N N O
.cn to O
O O0
0 t/�
c-I
L}
t G1 v0i 41 41
Gl
G1 �
G1 E
L L
++ 0
N +,
N
City of St. Joseph
Quarterly Water Fund Analysis
As of June 30, 2016
Fund 601+501, Water/WAC Fund Balance as of December 31, 2015(audited)$ 68,464.65
WAC fees collected for:
Year to Date Revenue:Government Center
Interest Earnings18,905.38 9 New Homes
Ad Valorem Taxes27,047.51 Kwik Trip
Water Usage Charge135,868.40
Water Line Charge88,693.42
Penalties/Other Usage Fees20,700.41
WAC/Trunk Fees111,768.00
Antenna Lease Revenue16,953.14
Bulk Water Sales2,821.38
Transfers from other Funds-
Total Revenue422,757.64 26.57%budget collected
2016 Revenue Budget1,591,325.00 (includes fund 501)
Year to Date Expenses by Department:
Debt Payments(59,247.25)
Transfers to Other Funds(715.00)
Power and Pumping(12,813.81)
Water Treatment Plant 1(9,895.61)
Water Treatment Plant 2(32,635.66)
Distribution(6,702.21)
Wellhead Protection-
Water Tower(1,647.94)
Water Maintenance(87,165.50)
Water Administration(16,295.36)
Total Expenses(227,118.34) 14.43%budget expensed
2016 Expense Budget(1,574,425.00) (excludes depreciation)
Fund Summary as of June 30, 2016:
Water Fund Cash Balance - Fund 601+501 - unaudited
$264,103.95
Fund 501$ 112,298.00
Fund 601$151,806.00
The balances represent the cash balance as of 6/30/16.
4,000,000
11,000,00015,000,000
)
5,984,257.525,984,257.52
$
$
Other585.80
Facilities3,802,050.56
Transportation-
Parks and Trails2,181,621.16
original est.$3,372,754
Estimated sales tax for projects
Sales Tax CollectedSales Tax receivedSales Tax Extension approved Nov. 2014Anticipated revenue 2019-2038:Anticipated revenue 2006-2018:
945,440.29
(661,000.00)(500,000.00)
1,796,806.673,054,559.711,204,192.77
(3,690,451.69)(3,054,559.71)
General Fund/Rec Center Fund Transfer Other earnings/transferred/expensed/bond issue Sales Tax/Other Sources Spent Fund Balance as of December 31, 2016 Projected Sales
Tax ( Remaining Sales Tax through 2018 Projected Sales Tax Other Revenues Spent as of June 30, 2016 2017-2018 Community Center Bond Payments Est. Remaining CR 2 Trail,
Phase II/III Est. Remaining Wobegon Trail Extension Est. Remaining Community Center remodel cash funded Remaining Unallocated Sales Tax through 2018
Projects funded (includes estimated remaining):Board Stipends585.80Parks Boundary Survey8,272.75Wobegon Trail Extension200,000.00CR2/3 Trail Extension Phase I446,513.37Community Center
\[includes upgrades & interest pmts\]3,437,544.00Facility Planning364,506.56
-
1,297,612.64
466,838.06
190,471.22237,927.00251,015.22242,011.63270,108.80299,571.59314,646.75360,909.00380,113.12405,859.25101,926.13
43,278.08 4,000,000.00 4,000,000.00 1,840,084.75 (3,690,451.69) (321,795.00) (200,000.00)
Parks and Rec survey/system plan43,358.50 Centennial Park Swingset33,284.14 Millstream Park Shelter Planning7,500.00
Aquatics Facility Design71,000.00 CR2 Trail Extension Phase II/III665,076.40 CR133/College Ave Sidewalk Project692,729.82 Wobegon Center Upgrades13,886.18
As of June 30, 2016
)
St. Joseph 1/2 Cent Sales Tax
audited
(
Summary Treasurer's Report - Fund 200
2006 Interest Earnings2,696.642006 Sales Tax Receipts Collected2007 Interest Earnings12,081.682007 Sales Tax Receipts Collected2007 Transfer from the General Fund24,003.732008 Interest
Earnings21,468.302008 Sales Tax Receipts Collected2008 Meeting Stipends(420.00)2008 Parks and Recreation Survey(1,279.26)2008 Park and Trail System Plan(42,079.24)2008 Parks Boundary
Survey(8,272.75)2009 Interest Earnings33,184.402009 Sales Tax Receipts Collected2009 Meeting Stipends(165.80)2010 Sales Tax Receipts Collected2010 Interest Earnings20,287.652010 Transfer
Interest Earnings to Water Fund(86,436.20)2010 Centennial Park Swingset(33,284.14)2011 Sales Tax Receipts Collected2011 CMCU Building Purchase(110,935.71)2011 CR 2/3 trail extension(21,463.82)2011
CR 133/College Ave trail extension(2,878.30)2012 Sales Tax Receipts Collected2012 CR 2/3 trail extension(330,603.68)2012 CR 133/College Ave trail extension(16,831.32)2013 Sales Tax
Receipts Collected2013 Transfer from Rec Center Fund - Facilities19,274.352013 CR 2/3 trail extension-Phase I(80,237.25)2013 CR 2 Trail Extension - Phase II(1,538.15)2013 CR 2 Trail
Extension - Phase III(566.10)2013 Wobegon Center Upgrades(13,886.18)2013 Facility Planning(104,427.23)2013 CR 133/College Ave Sidewalk(171,585.40)2014 Sales Tax Receipts Collected2014
CR 2/3 trail extension-Phase I(14,208.62)2014 CR 2 Trail Extension - Phase II/III(1,813.15)2014 CR 133/College Ave Sidewalks(1,434.80)2014 Facility Planning(149,143.62)2015 Sales Tax
Receipts Collected2015 Contributions/Donations110.002015 Abatement Bond Proceeds1,794,000.002015 CR 2 Trail Extension - Phase II/III(159.00)2015 Millstream Park Shelter Plan(7,500.00)2015
Wobegon Trail Extension(82.00)2015 Aquatics Design(71,623.50)2015 Community Center(2,340,109.27)2016 Sales Tax Receipts Collected2016 Abatement Bonds Payment(164,480.00)2016 CR 2 Trail
Extension - Phase II/III-2016 Wobegon Trail Extension-2016 Aquatics Design-2016 Community Center(29.20)
Opening Fund 2006Balance as of December 31, 2006 (audited)193,167.86Balance as of December 31, 2007 (audited)467,180.27Balance as of December 31, 2008 (audited)687,612.54Balance as of
December 31, 2009 (audited)962,642.77Balance as of December 31, 2010 (audited)1,133,318.88Balance as of December 31, 2011 Balance as of December 31, 2012 (audited)1,264,824.39Balance
as of December 31, 2013 (audited)1,272,767.43Balance as of December 31, 2014 (audited)1,486,280.36Balance as of December 31, 2015 (audited)1,266,775.84Balance as of June 30, 2016 (unaudited)1,204,19
2.77
City of St. Joseph
Quarterly Sewer Fund Analysis
As of June 30, 2016
Fund 602+502, Sewer/SAC Fund Balance as of December 31, 201(audited)$ (34,509.52)
SAC fees collected for
Year to Date Revenue:Government Center
Interest Earnings(1,187.01) 9 New Homes
Sewer Usage Charge152,658.12 Kwik Trip
Sewer Line Charge132,657.83
Penalties/Other Usage Fees2,330.70
SAC/Trunk Fees51,536.00
Transfers from other Funds-
Total Revenue337,995.64 20.94%budget collect
2016 Revenue Budget1,614,303.36 (includes fund 501)
Year to Date Expenses by Department:
Debt Payments(23,511.75)
Transfers to Other Funds (1,435.00)
Sewer Maintenance(69,856.02)
Baker Street Lift Station(1,409.53)
Ridgewood Lift Station(1,286.28)
Northland Lift Station(791.56)
CR121 Lift Station(1,190.72)
Main Lift Station(253,251.33)
Sewer Administration(16,851.00)
Total Expenses(369,583.19) 26.71%budget expen
2016 Expense Budget(1,383,740.00) (excludes depreciation)
Fund Summary as of June 30, 2016:
Sewer Fund Cash Balance - Fund 602+502 - unaudited$ (66,097.07)
Fund 502$ 51,760.00
Fund 602$ (117,857.00)
The balances represent the cash balance as of 6/30/16.
Cash Balances Only
Current Period: June 2016
MTDMTDCurrent
FUND DescrAccountBegin YrDebitCreditBalance
Last Dim 10100
GeneralG 101-10100$1,441,304.52$393,333.84$219,618.83$956,016.71
Employee Retirement ReserveG 102-10100$92,558.84$0.00$0.00$126,923.84
Fire FundG 105-10100$533,097.17$23,047.40$4,490.98$582,223.06
Cable Access FeeG 108-10100$19,692.08$667.42$0.00$23,267.09
Economic DevelopmentG 150-10100$73,708.56$53,251.83$34,709.90$112,676.56
TIF 3-1 CMCUG 152-10100$403.49$8,969.25$9,042.31$234.38
TIF 4-1 Fortitude Senior AptsG 153-10100$0.00$15,000.00$8,969.25$6,030.75
TIF 2-1 MillstreamG 157-10100$17,162.21$15,092.49$0.00$32,342.77
TIF 2-2 Meat MarketG 158-10100$242.94$2,917.21$0.00$3,103.18
TIF 2-3 Bayou Blues/Alley FlatG 159-10100$737.30$0.00$217.45$423.80
State Collected Sales TaxG 200-10100$1,212,523.90$38,659.25$0.00$1,204,192.77
Park DedicationG 205-10100$59,507.60$4,006.18$270.11$119,736.78
Charitable GamblingG 215-10100$2,391.38$4,002.95$2,349.94$4,080.14
Revolving Loan FundG 250-10100$11,993.70$861.41$0.00$19,305.11
2016 CIP Bonds \[govt center\]G 301-10100$0.00$72.89$0.00$90,135.23
2016 Street Impr \[Field St\]G 304-10100$0.00$0.00$0.00$0.00
2009A CrossoverRefunding BoG 318-10100$264,400.44$83,084.03$0.00$341,893.44
2011A Refunding Fire HallG 331-10100$49,619.06$12,844.03$0.00$74,715.06
2010B Refundin \[Hill/Clover\]G 333-10100$200,060.87$23,377.08$0.00$219,380.35
2011A CO Refund\[Interior St\]G 338-10100$116,548.60$40,698.24$0.00$152,405.09
2009B GO CIP BondsG 343-10100$1,481.44$24,200.50$0.00$22,601.54
2010B Street Impr \[16th Ave\]G 345-10100$215,398.03$8,661.31$0.00$225,294.08
2011A Pumper Truck CertificatG 346-10100$2,751.90$11,731.18$0.00$23,920.82
2011A GO CIP Bonds\[roof/gar\]G 347-10100$102.09$10,250.95$0.00$11,473.84
2013 Street Improve BondsG 348-10100$148,036.77$7,248.04$0.00$153,266.24
2013 Equipment CertificatesG 349-10100$3,338.72$21,196.68$0.00$23,246.98
2014 Street Impr \[ParkTerraceG 350-10100$199,690.61$46,233.86$0.00$226,244.40
2015 Street\[Clinton/Northland\]G 351-10100$23,410.53$50,881.13$0.00$81,013.57
2015 Equipment CertificatesG 352-10100$2,219.85$44,266.18$0.00$46,603.72
2015 Abatement Bonds\[KenneG 353-10100$3,391.12$55.09$0.00$129,389.60
Debt Service ReliefG 390-10100$184,349.41$8,269.89$0.00$173,445.35
2016 Government CenterG 401-10100$0.00$43.72$582,476.80-$807,040.26
2016 Imp Field StG 404-10100$0.00$0.00$12,376.74-$63,406.67
2011CIP Bonds\[Roof/PD garagG 447-10100$174,042.45$0.00$0.00$0.00
2014 Imp Park TerraceG 450-10100$322,466.94$0.00$1,534.10$186,009.69
2015 Street\[Clinton/Northland\]G 451-10100$166,457.50$75,000.00$3,651.40$237,119.70
2015 Equipment CertificatesG 452-10100$93,173.99$0.00$5,070.00$70,533.21
Capital OutlayG 490-10100$258,027.64$26,626.71$2,822.91$252,085.25
WAC FundG 501-10100$99.04$9,893.06$0.00$112,298.08
SAC FundG 502-10100$123.41$4,641.97$0.00$51,760.24
Water FundG 601-10100$2,353.94$108,480.91$27,507.21$151,805.87
Sewer FundG 602-10100$750.35$107,863.03$132,536.92-$117,857.31
Refuse CollectionG 603-10100$231,905.94$31,837.97$29,027.24$244,637.49
Storm Water UtilityG 651-10100$229,795.98$11,136.00$3,898.52$256,598.81
Street Light UtilityG 652-10100$19,742.20$6,890.29$6,385.19$21,205.51
Last Dim 10100$6,379,062.51$1,335,293.97$1,086,955.80$5,781,335.86
Last Dim 10200
GeneralG 101-10200$275.00$0.00$0.00$275.00
Last Dim 10200$275.00$0.00$0.00$275.00
Cash Balances Only
Current Period: June 2016
MTDMTDCurrent
FUND DescrAccountBegin YrDebitCreditBalance
$6,379,337.51$1,335,293.97$1,086,955.80$5,781,610.86
Council Month End Revenue Summary
Current Period: June 2016
2016June2016
FUNDFUND DescrYTD Budget2016 AmtYTD Amt
101General$2,559,980.00$382,392.78$765,904.88
102Employee Retirement Reserve$34,365.00$0.00$34,365.00
105Fire Fund$285,510.00$22,952.80$143,135.86
108Cable Access Fee$8,155.00$667.42$3,355.50
150Economic Development$123,615.00$38,251.83$89,721.61
152TIF 3-1 CMCU$0.00$0.00$0.00
153TIF 4-1 Fortitude Senior Apts$0.00$15,000.00$15,000.00
157TIF 2-1 Millstream$37,275.00$15,092.49$15,293.32
158TIF 2-2 Meat Market$4,005.00$2,917.21$2,919.63
159TIF 2-3 Bayou Blues/Alley Flat$0.00$0.00$0.00
200State Collected Sales Tax$235,520.00$38,659.25$101,926.13
205Park Dedication$355,600.00$4,006.18$62,821.62
215Charitable Gambling$4,525.00$4,002.95$4,029.86
250Revolving Loan Fund$12,855.00$861.41$7,254.73
3012016 CIP Bonds \[govt center\]$0.00$72.89$90,135.23
3042016 Street Impr \[Field St\]$0.00$0.00$0.00
3182009A CrossoverRefunding Bonds$262,380.00$83,084.03$86,178.64
3312011A Refunding Fire Hall$49,750.00$12,844.03$26,298.11
3332010B Refundin \[Hill/Clover\]$101,400.00$23,377.08$25,782.36
3382011A CO Refund\[Interior St\]$123,670.00$40,698.24$41,798.63
3432009B GO CIP Bonds$65,100.00$24,200.50$24,172.32
3452010B Street Impr \[16th Ave\]$44,570.00$8,661.31$16,601.55
3462011A Pumper Truck Certificate$45,360.00$11,731.18$23,639.81
3472011A GO CIP Bonds\[roof/gar\]$27,740.00$10,250.95$12,192.59
3482013 Street Improve Bonds$21,335.00$7,248.04$9,023.05
3492013 Equipment Certificates$57,300.00$21,196.68$21,208.60
3502014 Street Impr \[ParkTerrace\]$129,645.00$46,233.86$51,720.53
3512015 Street\[Clinton/Northland\]$61,940.00$50,881.13$63,415.27
3522015 Equipment Certificates$32,030.00$44,266.18$45,580.13
3532015 Abatement Bonds\[Kennedy\]$164,500.00$55.09$164,207.96
390Debt Service Relief$0.00$8,269.89$8,454.85
4012016 Government Center$0.00$0.00$84,042.45
4042016 Imp Field St$0.00$0.00$0.00
4502014 Imp Park Terrace$0.00$0.00$0.00
4512015 Street\[Clinton/Northland\]$0.00$75,000.00$75,000.00
4522015 Equipment Certificates$0.00$0.00$0.00
490Capital Outlay$60,000.00$26,592.30$28,592.30
501WAC Fund$433,400.00$9,893.06$112,103.32
502SAC Fund$122,500.00$4,641.97$51,120.86
601Water Fund$1,574,425.00$107,297.22$310,654.32
602Sewer Fund$1,579,770.00$107,640.77$286,874.78
603Refuse Collection$284,800.00$30,174.47$103,170.79
651Storm Water Utility$120,285.00$11,136.00$27,115.46
Council Month End Revenue Summary
Current Period: June 2016
2016June2016
FUNDFUND DescrYTD Budget2016 AmtYTD Amt
652Street Light Utility$61,035.00$6,890.29$19,399.69
$9,084,340.00$1,297,141.48$3,054,211.74
Council Month End Revenue -General Fund
Current Period: June 2016
2016June2016
FUNDFUND DescrSOURCE DescrYTD Budget2016 AmtYTD Amt
FUND 101 General
101GeneralCurrent Ad Valorem Taxes$1,062,065.00$347,567.65$347,567.65
101GeneralSpecial Levy- City St. Joe$0.00$0.00$0.00
101GeneralState Sales Tax$0.00-$18.81$43.89
101GeneralGas Franchise$31,070.00$0.00$8,010.55
101GeneralElectric Franchise$54,570.00$1,800.92$17,499.14
101GeneralBeer$1,525.00$62.50$1,187.50
101GeneralLiquor$19,760.00$225.00$22,669.17
101GeneralOutdoor Liquor Permit$2,500.00$0.00$1,750.00
101GeneralGambling Permits$200.00$0.00$235.00
101GeneralAmusement/Hunt/Peddler/Golf$1,395.00$75.00$402.13
101GeneralExcavation Permit$500.00$50.00$500.00
101GeneralCigarette License$600.00$31.25$31.25
101GeneralCable Franchise Fee$33,385.00$1,342.41$10,983.04
101GeneralBuilding Permits$90,000.00$6,575.32$117,266.93
101GeneralAnimal License$3,390.00$230.00$3,045.00
101GeneralRental Housing Registration$23,000.00$2,830.00$5,345.00
101GeneralFederal Grants - Other$5,000.00-$7,234.00$0.00
101GeneralState Grants and Aids$950.00$0.00$0.00
101GeneralLocal Government Aid$913,700.00$0.00$0.00
101GeneralPERA Rate Increase Aid$1,540.00$0.00$0.00
101GeneralPolice Training Reim$3,500.00$0.00$0.00
101GeneralState Municipal Funds Aid$48,175.00$0.00$24,798.00
101GeneralState Police Aid$55,000.00$0.00$0.00
101GeneralOther Grants/Aids$250.00$0.00$0.00
101GeneralOther Governmental Unit$10,000.00$0.00$5,000.00
101GeneralCounty Grants - Road Maint.$7,745.00$0.00$95,000.00
101GeneralZoning and Subdivision Fee$1,000.00$560.00$4,999.00
101GeneralLand Use Deposit Fee$4,000.00$1,500.00$7,500.00
101GeneralSale of Maps and Publications$50.00$4.00$11.75
101GeneralAssessments Search$2,750.00$360.00$1,830.00
101GeneralSpecial Hearing$5,000.00$250.00$4,000.00
101GeneralAdministration Reimb$14,085.00$3.60$131.44
101GeneralWeed Cutting$500.00$0.00$0.00
101GeneralPark Fees$5,500.00$680.00$4,805.00
101GeneralBall Field Donation$250.00$0.00$0.00
101GeneralSchneider Field Rental$1,500.00$770.00$770.00
101GeneralRents and Royalties$40,000.00$3,466.98$20,801.88
101GeneralKennel Fees$700.00$0.00$320.00
101GeneralCounty Fines$26,000.00$3,434.66$13,534.22
101GeneralPolicy Fines$14,000.00$0.00$4,824.00
101GeneralAccident Report Fee$1,200.00$0.00$461.75
101GeneralSeized Property$1,000.00$0.00$544.00
Council Month End Revenue -General Fund
Current Period: June 2016
2016June2016
FUNDFUND DescrSOURCE DescrYTD Budget2016 AmtYTD Amt
101GeneralSpecial Assessments$3,000.00$637.09$637.09
101GeneralInterest Earnings$22,500.00$1,259.92$18,824.55
101GeneralInterest Charges$200.00$0.00$0.00
101GeneralCo-op Dividend - LMCIT$12,000.00$0.00$0.00
101GeneralWater Tower Antenna Lease$3,770.00$162.55$1,883.71
101GeneralAdvertising$1,500.00$400.00$1,030.00
101GeneralContributions - General$500.00$15,100.00$15,100.00
101GeneralContributions - Parks$1,200.00-$133.26$902.89
101GeneralSurplus Property$0.00$0.00$0.00
101GeneralReimbursement$27,955.00$400.00$1,659.35
101GeneralTransfers from Other Funds$0.00$0.00$0.00
FUND 101 General$2,559,980.00$382,392.78$765,904.88
FUND 102 Employee Retirement Reserve
102Employee Retirement ResTransfers from Other Funds$34,365.00$0.00$34,365.00
FUND 102 Employee Retirement Reserve$34,365.00$0.00$34,365.00
FUND 108 Cable Access Fee
108Cable Access FeeCable Franchise Fee$8,155.00$667.42$3,355.50
108Cable Access FeeTransfers from Other Funds$0.00$0.00$0.00
FUND 108 Cable Access Fee$8,155.00$667.42$3,355.50
FUND 150 Economic Development
150Economic DevelopmentCurrent Ad Valorem Taxes$122,365.00$39,585.33$39,585.33
150Economic DevelopmentLodging Tax$0.00$0.00$0.00
150Economic DevelopmentFederal Grants - Other$0.00$13,565.00$36,622.00
150Economic DevelopmentTIF/MIF Deposit$0.00-$15,000.00$12,500.00
150Economic DevelopmentDEED Housing Reimbursement$0.00$0.00$0.00
150Economic DevelopmentInterest Earnings$1,250.00$101.50$1,014.28
150Economic DevelopmentTransfers from Other Funds$0.00$0.00$0.00
FUND 150 Economic Development$123,615.00$38,251.83$89,721.61
FUND 152 TIF 3-1 CMCU
152TIF 3-1 CMCUTax Increment$0.00$0.00$0.00
152TIF 3-1 CMCUInterest Earnings$0.00$0.00$0.00
152TIF 3-1 CMCUTransfers from Other Funds$0.00$0.00$0.00
FUND 152 TIF 3-1 CMCU$0.00$0.00$0.00
FUND 153 TIF 4-1 Fortitude Senior Apts
153TIF 4-1 Fortitude Senior ATax Increment$0.00$0.00$0.00
153TIF 4-1 Fortitude Senior ATIF/MIF Deposit$0.00$15,000.00$15,000.00
153TIF 4-1 Fortitude Senior AInterest Earnings$0.00$0.00$0.00
153TIF 4-1 Fortitude Senior ATransfers from Other Funds$0.00$0.00$0.00
FUND 153 TIF 4-1 Fortitude Senior Apts$0.00$15,000.00$15,000.00
FUND 159 TIF 2-3 Bayou Blues/Alley Flat
159TIF 2-3 Bayou Blues/Alley Tax Increment$0.00$0.00$0.00
159TIF 2-3 Bayou Blues/Alley Interest Earnings$0.00$0.00$0.00
Council Month End Revenue -General Fund
Current Period: June 2016
2016June2016
FUNDFUND DescrSOURCE DescrYTD Budget2016 AmtYTD Amt
159TIF 2-3 Bayou Blues/Alley Transfers from Other Funds$0.00$0.00$0.00
FUND 159 TIF 2-3 Bayou Blues/Alley Flat$0.00$0.00$0.00
$2,726,115.00$436,312.03$908,346.99
Council Month End Revenue -Enterprise Funds
Current Period: June 2016
FUND2016June2016
FUNDDescrSOURCE DescrYTD Budget2016 AmtYTD Amt
FUND 601 Water Fund
601Water FundPenalties and Forfeited Disc$8,000.00$572.62$3,557.40
601Water FundCurrent Ad Valorem Taxes$73,500.00$27,346.98$27,047.51
601Water FundTransfers from Other Funds$416,500.00$0.00$0.00
601Water FundContributed Revenue$0.00$0.00$0.00
601Water FundMDS Test Fee$11,880.00$1,111.83$3,575.03
601Water FundWater Meter$5,000.00$1,830.00$13,290.00
601Water FundConnection/Reconnection fees$200.00$0.00$112.00
601Water FundUndesignated Funds$0.00$2,161.28$1,247.83
601Water FundBulk Water$1,500.00$1,245.50$2,821.38
601Water FundInterest Earnings$34,140.00$1,800.49$18,570.06
601Water FundState Sales Tax$0.00-$347.20-$422.90
601Water FundWater Line Charge$294,535.00$26,952.40$88,693.42
601Water FundSpecial Assessments$200.00$0.00-$823.95
601Water FundRate Class One$694,985.00$43,160.40$135,868.40
601Water FundAmortization of Bond Premium$0.00$0.00$0.00
601Water FundWater Tower Antenna Lease$33,985.00$1,462.92$16,953.14
601Water FundSurplus Property$0.00$0.00$0.00
601Water FundReimbursement$0.00$0.00$165.00
FUND 601 Water Fund$1,574,425.00$107,297.22$310,654.32
FUND 602 Sewer Fund
602Sewer FundReimbursement$200.00$0.00$0.00
602Sewer FundContributed Revenue$0.00$0.00$0.00
602Sewer FundOther Governmental Unit$1,500.00$0.00$0.00
602Sewer FundSpecial Assessments$200.00$51.26-$37.97
602Sewer FundInterest Earnings$3,925.00-$130.47-$771.87
602Sewer FundAmortization of Bond Premium$0.00$0.00$0.00
602Sewer FundContributions - General$8,000.00$0.00$0.00
602Sewer FundOther Grants/Aids$0.00$0.00$0.00
602Sewer FundSanitary Sewer Service$1,063,345.00$60,880.51$152,658.12
602Sewer FundPenalties and Forfeited Disc$11,750.00$404.52$2,368.67
602Sewer FundSewer Line Charge$347,650.00$46,434.95$132,657.83
602Sewer FundTransfers from Other Funds$143,200.00$0.00$0.00
602Sewer FundSurplus Property$0.00$0.00$0.00
FUND 602 Sewer Fund$1,579,770.00$107,640.77$286,874.78
FUND 603 Refuse Collection
603Refuse CollecRefuse Collection Charges$258,260.00$26,355.47$82,686.01
603Refuse CollecContributions - General$0.00$0.00$0.00
603Refuse CollecInterest Earnings$2,500.00$290.14$3,120.08
603Refuse CollecPenalties and Forfeifted Disc$5,700.00$433.14$2,949.40
603Refuse CollecContributed Revenue$0.00$0.00$0.00
603Refuse CollecLicenses & Permits$18,140.00$2,090.00$16,750.00
603Refuse CollecState Sales Tax$0.00$894.75-$2,267.09
603Refuse CollecSpecial Assessments$200.00$110.97-$67.61
FUND 603 Refuse Collection$284,800.00$30,174.47$103,170.79
FUND 651 Storm Water Utility
651Storm Water Development Fee$10,000.00$0.00$0.00
651Storm Water Transfers from Other Funds$0.00$0.00$0.00
651Storm Water Penalties and Forfeifted Disc$2,060.00$101.42$681.50
651Storm Water Rate Class One$101,180.00$9,397.90$30,445.07
651Storm Water Contributed Revenue$0.00$0.00$0.00
Council Month End Revenue -Enterprise Funds
Current Period: June 2016
FUND2016June2016
FUNDDescrSOURCE DescrYTD Budget2016 AmtYTD Amt
651Storm Water Reimbursement$0.00$0.00$0.00
651Storm Water Special Assessments$4,795.00$1,339.77-$7,115.81
651Storm Water Interest Earnings$2,250.00$296.91$3,104.70
FUND 651 Storm Water Utility$120,285.00$11,136.00$27,115.46
FUND 652 Street Light Utility
652Street Light UTransfers from Other Funds$0.00$0.00$0.00
652Street Light USpecial Assessments$50.00$10.17-$6.41
652Street Light UInterest Earnings$250.00$25.28$277.83
652Street Light URate Class One$60,535.00$6,803.63$18,786.24
652Street Light UPenalties and Forfeited Disc$200.00$51.21$342.03
FUND 652 Street Light Utility$61,035.00$6,890.29$19,399.69
$3,620,315.00$263,138.75$747,215.04
Council Month End Expenditure - Summary
Current Period: June 2016
2016June2016
DescriptionYTD Budget2016 Amt YTD Amt
General$2,569,980.00$209,659.19$1,190,256.92
Employee Retirement Reserve$34,365.00$0.00$0.00
Fire Fund$312,525.00$4,396.38$45,585.78
Cable Access Fee$2,010.00$0.00$454.75
Economic Development$123,615.00$19,709.90$51,208.90
TIF 3-1 CMCU$795.00$73.06$169.11
TIF 4-1 Fortitude Senior Apts$0.00$8,969.25$8,969.25
TIF 2-1 Millstream$34,545.00$0.00$281.23
TIF 2-2 Meat Market$4,545.00$0.00$60.01
TIF 2-3 Bayou Blues/Alley Flat$795.00$217.45$313.50
State Collected Sales Tax$2,874,000.00$0.00$164,509.20
Park Dedication$393,700.00$270.11$2,811.51
Charitable Gambling$0.00$2,349.94$2,349.94
Revolving Loan Fund$0.00$0.00$0.00
2016 CIP Bonds \[govt center\]$0.00$0.00$0.00
2016 Street Impr \[Field St\]$0.00$0.00$0.00
2009A CrossoverRefunding Bon$360,625.00$0.00$10,175.00
2011A Refunding Fire Hall$74,750.00$0.00$1,500.00
2010B Refundin \[Hill/Clover\]$144,750.00$0.00$7,223.75
2011A CO Refund\[Interior St\]$142,130.00$0.00$8,365.00
2009B GO CIP Bonds$61,450.00$0.00$3,420.00
2010B Street Impr \[16th Ave\]$64,855.00$0.00$7,327.50
2011A Pumper Truck Certificate$45,360.00$0.00$2,580.00
2011A GO CIP Bonds\[roof/gar\]$22,720.00$0.00$1,260.00
2013 Street Improve Bonds$39,270.00$0.00$4,535.00
2013 Equipment Certificates$53,500.00$0.00$1,650.00
2014 Street Impr \[ParkTerrace\]$164,035.00$0.00$26,917.50
2015 Street\[Clinton/Northland\]$67,470.00$0.00$6,120.00
2015 Equipment Certificates$32,670.00$0.00$1,235.00
2015 Abatement Bonds\[Kenned$141,435.00$0.00$38,529.15
Debt Service Relief$0.00$0.00$20,000.00
2016 Government Center$0.00$582,433.08$891,082.71
2016 Imp Field St$0.00$12,376.74$63,406.67
2011CIP Bonds\[Roof/PD garag$0.00$0.00$174,042.45
2014 Imp Park Terrace$0.00$1,534.10$10,010.87
2015 Street\[Clinton/Northland\]$0.00$3,651.40-$11,754.31
2015 Equipment Certificates$0.00$5,070.00$22,640.78
Capital Outlay$60,000.00$2,788.50$34,894.95
WAC Fund$416,500.00$0.00$0.00
SAC Fund$46,000.00$0.00$0.00
Water Fund$1,574,425.00$26,323.52$227,118.34
Sewer Fund$1,758,740.00$132,314.66$369,583.19
Refuse Collection$286,460.00$27,363.74$125,975.69
Council Month End Expenditure - Summary
Current Period: June 2016
2016June2016
DescriptionYTD Budget2016 Amt YTD Amt
Storm Water Utility$214,375.00$3,898.52$23,279.36
Street Light Utility$69,590.00$6,385.19$25,018.09
$12,191,985.00$1,049,784.73$3,563,106.79
Council Month End Expenditure - General Fund
Current Period: June 2016
2016June2016
DescriptionDEPART DescrYTD Budget2016 Amt YTD Amt
FUND 101 General
GeneralCouncil$60,725.00$1,711.29$24,346.61
GeneralLegislative Committees$5,565.00$1,389.70$1,914.70
GeneralOrdinance & Proceedings$1,600.00$232.75$1,260.93
GeneralMayor$10,985.00$781.34$4,045.77
GeneralElections$750.00$0.00$1,540.50
GeneralGeneral Adminstration$236,595.00$16,074.56$104,081.27
GeneralFinance$127,685.00$9,348.31$53,860.01
GeneralAudit Service$27,450.00$950.00$26,950.00
GeneralAssessing$23,500.00$0.00$0.00
GeneralCity Attorney$16,000.00$789.75$4,549.50
GeneralPlanning and Zoning$54,385.00$4,018.93$14,329.42
GeneralGeneral Government$20,675.00$1,523.11$10,443.31
GeneralCity Offices$33,575.00$2,302.74$16,879.78
GeneralFacilites and Planning$0.00$0.00-$3,300.00
GeneralCable Access$11,065.00$830.60$4,678.00
GeneralCrime Control & Investigation$952,830.00$92,065.17$435,415.83
GeneralPolice Training$9,545.00$2,404.98$4,850.36
GeneralCommunication Service$10,870.00$1,066.77$5,043.40
GeneralAutomotive Services$52,200.00$6,144.66$16,894.44
GeneralBuilding Inspec. Admistration$92,000.00$7,500.00$40,905.96
GeneralEmergency Management$960.00$360.78$1,461.84
GeneralAnimal Control$965.00$0.00$274.50
GeneralStreet Maintanence$274,350.00$13,058.51$87,837.08
GeneralIce & Snow Removal$112,710.00$0.00$39,094.08
GeneralEngineering Fee$30,000.00$10,800.83$13,850.28
GeneralStreet Cleaning$13,665.00$83.25$4,753.44
GeneralSkate Park and Ice Rink$5,240.00$587.80$2,714.15
GeneralBall Park$1,750.00$209.27$604.65
GeneralMaintenance Shop$27,365.00$1,513.14$12,335.60
GeneralPark Areas$218,995.00$31,242.67$137,986.06
GeneralCommunity Center$30,920.00$2,668.28$37,895.35
GeneralOther Financing Uses$0.00$0.00$31,500.00
GeneralFire Protection$105,060.00$0.00$51,260.10
FUND 101 General$2,569,980.00$209,659.19$1,190,256.92
FUND 102 Employee Retirement Reserve
Employee Retirement ReservGeneral Adminstration$34,365.00$0.00$0.00
FUND 102 Employee Retirement Reserve$34,365.00$0.00$0.00
FUND 108 Cable Access Fee
Cable Access FeeCable Access$2,010.00$0.00$454.75
FUND 108 Cable Access Fee$2,010.00$0.00$454.75
FUND 150 Economic Development
Council Month End Expenditure - General Fund
Current Period: June 2016
2016June2016
DescriptionDEPART DescrYTD Budget2016 Amt YTD Amt
Economic DevelopmentEconomic Development Authority$123,615.00$19,709.90$51,208.90
Economic DevelopmentOther Financing Uses$0.00$0.00$0.00
FUND 150 Economic Development$123,615.00$19,709.90$51,208.90
FUND 152 TIF 3-1 CMCU
TIF 3-1 CMCUEconomic Development Authority$795.00$73.06$169.11
TIF 3-1 CMCUOther Financing Uses$0.00$0.00$0.00
FUND 152 TIF 3-1 CMCU$795.00$73.06$169.11
FUND 153 TIF 4-1 Fortitude Senior Apts
TIF 4-1 Fortitude Senior AptsEconomic Development Authority$0.00$8,969.25$8,969.25
FUND 153 TIF 4-1 Fortitude Senior Apts$0.00$8,969.25$8,969.25
FUND 159 TIF 2-3 Bayou Blues/Alley Flat
TIF 2-3 Bayou Blues/Alley FlEconomic Development Authority$795.00$217.45$313.50
TIF 2-3 Bayou Blues/Alley FlOther Financing Uses$0.00$0.00$0.00
FUND 159 TIF 2-3 Bayou Blues/Alley Flat$795.00$217.45$313.50
FUND 401 2016 Government Center
2016 Government CenterCity Offices$0.00$582,433.08$891,082.71
FUND 401 2016 Government Center$0.00$582,433.08$891,082.71
FUND 404 2016 Imp Field St
2016 Imp Field StStreet Maintanence$0.00$12,376.74$63,406.67
FUND 404 2016 Imp Field St$0.00$12,376.74$63,406.67
FUND 490 Capital Outlay
Capital OutlayGeneral Adminstration$8,145.00$1,680.00$13,225.62
Capital OutlayCrime Control & Investigation$1,185.00$720.00$720.00
Capital OutlayCommunication Service$5,170.00$0.00$2,509.40
Capital OutlayAutomotive Services$14,045.00$388.50$18,439.93
Capital OutlayEmergency Management$1,500.00$0.00$0.00
Capital OutlayStreet Maintanence$1,625.00$0.00$0.00
Capital OutlayIce & Snow Removal$5,375.00$0.00$0.00
Capital OutlayStreet Cleaning$3,750.00$0.00$0.00
Capital OutlayMaintenance Shop$4,125.00$0.00$0.00
Capital OutlayPark Areas$15,080.00$0.00$0.00
Capital OutlayOther Financing Uses$0.00$0.00$0.00
FUND 490 Capital Outlay$60,000.00$2,788.50$34,894.95
$2,791,560.00$836,227.17$2,240,756.76
Council Month End Expense - Enterprise Funds
Current Period: June 2016
2016June2016
DescriptionDEPART DescrYTD Budget2016 Amt YTD Amt
FUND 601 Water Fund
Water FundBond Payment (P & I)$692,345.00$0.00$59,247.25
Water FundOther Financing Uses$38,215.00$0.00$715.00
Water FundPower and Pumping$21,105.00$322.71$12,813.81
Water FundPurification-Plant 1$43,935.00$2,524.28$9,895.61
Water FundPurification-Plant 2$80,275.00$4,344.50$32,635.66
Water FundDistribution$10,000.00$3,597.59$6,702.21
Water FundWellhead Protection$3,000.00$0.00$0.00
Water FundStorage-Tower 1$16,145.00$560.72$1,647.94
Water FundWater Maintenance$232,210.00$12,400.74$87,165.50
Water FundAdministration and General$37,195.00$2,572.98$16,295.36
Water FundDepreciation Expense$400,000.00$0.00$0.00
FUND 601 Water Fund$1,574,425.00$26,323.52$227,118.34
FUND 602 Sewer Fund
Sewer FundBond Payment (P & I)$222,970.00$0.00$23,511.75
Sewer FundOther Financing Uses$45,935.00$0.00$1,435.00
Sewer FundSanitary Sewer Maintenanc$198,560.00$15,931.26$69,856.02
Sewer FundLift Station-Baker Street$5,885.00$257.77$1,409.53
Sewer FundLift Station-Ridgewood/DBL$2,980.00$351.88$1,286.28
Sewer FundLift Station-Northland$4,365.00$113.53$791.56
Sewer FundLift Station-CR 121$4,610.00$141.63$1,190.72
Sewer FundLift Station-Main$862,390.00$112,564.33$253,251.33
Sewer FundAdministration and General$36,045.00$2,954.26$16,851.00
Sewer FundDepreciation Expense$375,000.00$0.00$0.00
FUND 602 Sewer Fund$1,758,740.00$132,314.66$369,583.19
FUND 603 Refuse Collection
Refuse CollectioWaste Collection$278,525.00$27,363.74$125,260.69
Refuse CollectioOther Financing Uses$1,435.00$0.00$715.00
Refuse CollectioDepreciation Expense$6,500.00$0.00$0.00
FUND 603 Refuse Collection$286,460.00$27,363.74$125,975.69
FUND 651 Storm Water Utility
Storm Water UtiOther Financing Uses$18,965.00$0.00$0.00
Storm Water UtiAdministration and General$16,375.00$1,370.35$9,454.76
Storm Water UtiStorm Water Maintenance$79,035.00$2,528.17$13,824.60
Storm Water UtiDepreciation Expense$100,000.00$0.00$0.00
FUND 651 Storm Water Utility$214,375.00$3,898.52$23,279.36
FUND 652 Street Light Utility
Street Light UtiliStreet Lighting$69,590.00$6,385.19$25,018.09
FUND 652 Street Light Utility$69,590.00$6,385.19$25,018.09
$3,903,590.00$196,285.63$770,974.67
8,142.165,424.688,056.735,295.957,912.611,060.001,375.003,190.005,250.001,310.002,001.42
23,162.5414,152.8422,592.8373,475.0521,989.9812,005.0017,450.8672,711.1310,000.0026,625.0057,156.6220,370.0062,002.8799,433.31
187,393.32375,732.81101,434.73
623,353.72
750.00565.00375.00190.00
1,875.005,705.008,895.001,185.005,170.003,375.008,645.002,025.001,500.001,060.003,750.005,375.004,125.001,470.001,310.00
21,900.0063,625.0012,300.0093,580.0033,500.0033,500.00
157,875.00
6/30
454.75720.00240.24240.24301.42
1,540.501,550.612,509.402,455.735,049.505,350.92
12,075.6215,621.4814,468.0020,153.13
41,365.77
6/30through
34.41
201620162016Balance
2,000.003,355.505,389.917,234.007,234.00
(1,300.00)
Summary
96,300.0095,000.00
107,623.91
2015
Plan
7,
2016
3,953.364,859.687,591.738,630.006,412.611,000.003,000.001,500.001,700.00
23,953.0422,353.4619,692.0874,811.6219,329.3811,261.5910,504.9563,730.2627,708.5610,000.0021,250.0054,331.6218,900.0049,702.8760,883.8162,583.81
Availablethrough 187,393.05
30,388,518.74
Expenditures
December
June
Improvement
of
Capital
As
adopted
Capital
2016
Final
Total EDA CIP
Fund
Total Police CIP
Total Public Works CIP
General
Total Administration CIP
CodeEquipmentBalanceGrant
150-46500-582Computer Software150-46500-588EDA ProgramsTotal General Capital Improvements
ProjectBudgetReserveTransferred/SpentBudgetRemaining
DepartmentAccount
SoftwareProjects
Election101-41410-xxxElection EquipmentAdministration490-41430-570Administration EquipmentAdministration490-41430-581Computer ReplacementAdministration490-41430-582Computer SoftwareCable
Access108-41950-580Cable EquipmentPolice - General490-42120-580Police EquipmentPolice-Communications490-42151-580Communication EquipmentPolice - Automotive490-42152-550Police SquadsPolice
- Automotive490-42152-580Vehicle/EquipmentPolice - Automotive490-42152-581Squad LaptopsEmergency Services490-42500-580Emergency ServicesStreets101-43120-530/230Street ImprovementsStreets490-43120-55
0Street Motor VehiclesStreets490-43120-580Street EquipmentStreets490-43120-582Street SoftwareStreets490-43120-530Street ImprovementsStreet Sweeping490-43220-580Street Sweeping EquipmentSnow
Removal490-43125-580Snow Removal EquipmentMaintenance490-45201-580Maintenance Shop EquipmentParks490-45202-530Parks ImprovementsParks490-45202-580Parks EquipmentParks490-45202-550Parks
Motor Vehicles EDAEDA
21
004
997
453.95
2,032.79 2,032.7 7,417.89 7,417.8 7,000.009,812.123,165.151,727.57 1,727.5 9,450.00
Funds
21,562.40 21,562.4 41,759.5865,823.7757,250.0059,000.0015,001.0054,208.25 57,373.4 20,766.9219,991.92 50,208.8
Available256,100.4396,423.3
53
8
0
6
6/3
794.38 794.3
of
201 5,357.95 5,357.96,152.3
as
77
/
6
6/30
2,452.97 2,452.92,452.9
of
201
000
0000
0
6
750.00500.00200.00 200.0 500.00
1,300.00 1,300.0 4,500.00 4,500.0 4,000.00 4,000.0 7,500.009,000.002,500.003,000.001,900.001,500.001,000.00 3,000.0
BudgetAdjustmentsSpentReserve
10,000.0011,000.00 45,650.0 12,000.00 12,500.071,150.0
07
004
77
9
732.7
5,822.87 5,822.81,527.5
17,562.40 17,562.444,873.4 19,491.92 47,208.8
AvailableGrants211,244.8328,972.6
12/31/2015as
#247,250.00
#348,000.00
#412,501.00
Van34,259.58
Radios42,208.25
Truck56,823.77
Repairs19,266.92
Rig
Truck
Packs4,000.00
Wheeler(296.05)
MHz
Computers732.79
Rescue
Parking Lot
3
Replacement8,706.50Replacement2,665.15Replacement1,527.57
Building
n/aTurnout Gearn/an/an/an/a
2012
g
PurchasedReserve
2010/20111996/2005Extrication Equip
Buildin
e
Building2008Painting8,450.00
than
than
other
other
ObjectYearDescriptionFunds201
t
2016
e
ReserveReserveReserve2011
Hardware/Softwar
Equipment20126EquipmentEquipment2012PumperEquipment2001LadderEquipment1997GrassEquipment1999TankerEquipment2013AirEquipment
Hardware/Software
t
t
EquipmentEquipment2007800EquipmentEquipment
Reserv
PayabletImprovements
Equipmen
Computer
for
Equipmen
Equipmen
Department
Building
Plan
OtherEquipmentEquipmen
&
t
Fire ķ
Services
BuildingImprovements
BuildingEquipmentBuildingEquipment
CǒƓ
&&&
AdministrationFightingFightingFightingCommunicationsStation
ServicesOther
CźƩĻ
Joseph
Departmen
FireFireFireFireFireMedicalFire
Adopted December 7, 2015
Improvement
AdministrationComputerFightingOtherFightingEquipmentFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefi
ghterCommunicationOtherCommunicationOtherStationStationStation
St.
TotalTotalTotal FireFire TotalTotalTotalTotal
Capital
e
580Fire584Fire585Fire585Fire585Fire585Fire585Fire585Fire580Fire580Fire580Medical530Fire530Fire530Fire
LƒƦƩƚǝĻƒĻƓƷ
581/582Fire
Cod
4222042220422204222042220422204222042220422504225042270422804228042280
/ğƦźƷğƌ
42210
Account
105105105105105105105105105105105105105105
105-42220-585105-42220-585
105
ƚƷğƌ
#
CIP
FD-1401FD-1402FD-1404FD-1403FD-1405FD-1406FD-1407FD-1408FD-1409FD-1417FD-1410FD-1411FD-1412FD-1413FD-1414FD-1415FD-1416
e
2,750.005,948.635,560.006,500.006,900.006,900.009,600.004,692.623,206.00
4,692.62
10,750.0017,500.0035,000.0014,266.4421,571.5326,416.5285,000.0014,000.0032,637.8113,050.0075,080.0030,000.0076,902.2411,000.0030,000.00
86,215.0711,000.0033,206.00
119,102.18
301,550.23227,670.05
6/302016
(97.76)
of
(144.31)
(1,606.00)(8,794.00)
(1,848.07)(8,794.00)
as
/
500.00
2,750.005,750.005,000.007,500.005,000.002,750.007,000.002,300.002,300.002,200.002,000.001,000.001,000.005,000.00
1,000.005,000.00
42,500.0010,000.00
s26,000.0059,050.0013,500.00
Work
Public
6,500.00
3,692.626,000.00
12,550.0020,000.00
60,215.0742,000.00
2015
242,500.23216,018.12
12/31/2015Grants
Plan
7,
Expenditures
December
LS14,000.00
Improvement LS4,600.00
Capital
Terrace)30,000.00
LS4,600.00
Terrace)12,000.00
LS7,400.00
St
Plan32,782.12
LS42,500.00
2016
Adopted
(1/2)21,571.53(Park
Capital
(Park
Foaming19,416.52
Replacement27,500.00
RidgewoodBakerNorthlandCR121
Main
(1/4)3,692.62
SystemSystem
Funding
Programmer5,000.00
Replacement5,948.63
Media
Improvements74,686.00
r
r
Enterprise
Management
pumpspumpspumpspumps
RoofLoader
Meter
Door/Fencing
Easements/Acquire76,000.00
Filter Project
UBUBUBUB
Repairs12,500.00Repairs9,266.44
Quality
Lining119,102.18Televising/RootSample
WaterSweepeLighting6,000.00
ReplacementMapping
(1/4)(1/4)2,810.00
End
11/22
#4/5
Shop
TruckPrinterHandheldWellWTPWTPWTPTruckCommunicationsPrinterSewerSewerSewerPumpSubmersibleSubmersibleSubmersibleSubmersibleStormPrinterAerialWaterStreetPropertyPrinterFrontStreet Residual
CommunicationsOld
140714011408140214031403140314031403
140114021403140414031407
1403140314071425
14011404140514061410
n/an/an/an/an/a
SL
SSSSSSSS
WTWTWTWTWTWT
PWPWPWPW
WWWWWWWWWWWWWWWWWW
02000000010000000002000010000
5558582258585855585853305858535353533058535358515858535858
CodeNumberEquipmentBalance201620162016Balance
4944049490494904941049420494204942149450494504949049450494504948049480494714947049472494734990049490499004990049900499004323043230431604312043120
601601601601601602602602602602602602602602602651651651603450450
601601602651651651603
Lighting652
ProjectProjectReserveBudgetTransfersSpentAvailabl
DepartmentAccount WaterSewerStormwaterRefuseSt.StreetsStreets
City of St. Joseph Park Board
2016 Capital Improvement Budget Summary
Adopted December 7, 2015
General FundsBalance
Park Dedication Cash June 30, 2016119,737$
(Unaudited)
Adjustments
Starting Balance119,737$
2016 General Levy-remaining1,600$
Other Revenues-remaining54$
Potential Projects:PotentialProposed
Millstream Cottages-phase 223,400$
Sunset Ridge-phase 2 - 4 lots2,000$
CLC Development - 16 lots8,000$
Ending Balance for 2016121,391$
Projects - Budget201520162017201820192020Total 16-20
PTR-01 (Millstream)25,000$ $ 350,000$ --$ -$ -$ 350,000$
PTR-02 (Northland)-$ $ -$ -200,000$ -$ -$ 200,000$
PTR-03 (Klinefelter)150,000$$ -$ 150,000-$ -$ -$ 150,000$
PTR-04 (Wobegon)-$ $ -$ --$ -$ -$ -$
PTR-05 (Memorial)-$ $ -$ --$ -$ -$ -$
PTR-06 (Centennial)-$ $ -$ --$ -$ -$ -$
PTR-07 (Monument)30,400$$ 400$ 400400$ 400$ 400$ 2,000$
PTR-08 (Hollow)-$ $ -$ --$ -$ -$ -$
PTR-09 (Cloverdale)-$ $ -$ --$ -$ -$ -$
PTR-10 (East Park)25,000$$ -$ --$ -$ -$ -$
PTR-11 (West Park)25,000$$ -$ --$ -$ TBD-$
PTR-12 (Trails)10,000$ $ 10,000$ 10,00010,000$ 10,000$ 10,000$ 50,000$
PTR-13 (Trees)1,500$ $ 1,500$ 1,5001,500$ 1,500$ 1,500$ 7,500$
PTR-14 (Dog Park)-$ $ -$ --$ -$ -$ -$
Total266,900$ $ 361,900$ 161,900211,900$ 11,900$ 11,900$ 759,500$
Projects - ActualSpent 2015201616 Snow Town Expenses:Avail. Rev
PTR-01 (Millstream)-$ -$ Shelter/Master Park Plan$ 905-$
PTR-02 (Northland)-$ 2,351$ Footgolf
PTR-03 (Klinefelter)-$ -$ Prairie RestorationOther 16 Expense Budget:2016 YTD
PTR-04 (Wobegon)-$ -$ Dog Baggies200$ -$
PTR-05 (Memorial)-$ -$ A-1 Toilets1,600$ 461$
PTR-06 (Centennial)-$ -$
PTR-07 (Monument)-$ -$ 2016 Revenue Budget:2016 YTD
PTR-08 (Hollow)-$ -$ Interest500$ 896$
PTR-09 (Cloverdale)-$ -$ Round Up100$ 46$
PTR-10 (East Park)-$ -$ GF Levy3,000$ 1,400$
PTR-11 (West Park)-$ -$ Land Rent-$ 2,700$
PTR-12 (Trails)-$ -$ Transfer350,000$ -$
PTR-13 (Trees)-$ -$ Donations-$ 200$
PTR-14 (Dog Park)-$ -$ Park Dedic.2,000$ 58,000$
Total-$ 2,351$
Other Projects:16 Millstream 5k Expenses:Avail. Rev
Millstream Shelter7,500$ $ 3,024-$
Park Plan Update-$ 11,500$
In 2015, the Park Board requested updating the Master Park Plan last completed in 2008.
Donations for Aquatics Facility being received.
Community Center - Park Board suggests adding $40,000 to the 2017 budget for programming.
Millstream Shelter - Council approved using $7,500 half cent sales tax funding in 2015
Millstream Shelter - Council approved using $2,500 excess bldg permit revenue in 2016
�
�
�
�
�
��
�. .