HomeMy WebLinkAbout[04d] Treasurer Report
Council Agenda Item 4 \[d\]
MEETING DATE: July 16, 2018
AGENDA ITEM: Financial Report – 2nd Quarter 2018 & June 2018 Financial Reports
SUBMITTED BY: Finance
BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A
PREVIOUS COUNCIL ACTION: Council adopted the 2018 budget on December 4, 2017.
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, 2018.
CASH POSITION:
- The market rate of return (ROR) is approximately 1.55% with an average maturity of 14 months.
The federal markets improved since the first quarter of 2018. St. Joseph’s rate of return is slightly
less than the treasury markets. 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 over time. In addition, one of the goals is to invest locally. The City’s
more immediate cash flow needs are held at local financial institutions.
- In June, the Federal Open Market Committee \[FOMC\] increased the federal fund rates to 1.75 to
2.0% citing the labor market conditions continue to strengthen and the GDP appeared to be rising
at a solid rate in the first half of the year. CPI was 2% in April, longer run expects little change.
- Interest earnings for 2018 amounts to a negative $37,207. 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 fluctuations.
- Overall, the cash and investments balance decreased $10,948 from the beginning of the year. The
remaining 30% first half tax settlement was received in early July, and the first half state aid
th
payments will be received around July 20.
FUNDS REPORT:
- The General fund spent 49% of the 2018 expenditure budget and received 25% of the revenue
budget. Expenditures and revenues are mainly operational in nature.
- The Enterprise Funds represent 4 months utility billing revenue collected while expenses
represent six months of activity. Overall, 35% of expenses have been incurred (less
depreciation); 30% 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 WAC and trunk fees
received for the year total $64,600, including fees collected for a connection fee from two homeowners
that was sewer only (final partial payment). Water revenues represent 30%, expenses 46% of the budget
at the end of June.
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). Sewer SAC/Trunk fees totaled
$28,150 for the first half of 2018. Collections include fees for 11 single family homes and a partial
payment for 24 College North. Sewer expenses are at 25% of the budget, while revenues are at 31% of
the budget.
½ ¢ Sales Tax (fund 200): The sales tax fund has a cash balance of $894,170. The City anticipates
collecting $4,250,000 in sales tax revenue through 2018 ($3,372,754 original estimate); $3,919,582 was
collected to date. Collections have continually increased over the years, even during most of the
recession years. It is reasonable to estimate the 2018 collections will be approximately $425,000. The
anticipated remaining 2018 expenditures total $776,248 for the projects approved by Council.
CIP REPORTS:
- General capital equipment purchases include: Public Works truck replacements, mowers, and
computer replacements. Seal coating and crack filling began. The police department took
possession of the new squad 704 as part of the 4-year lease rotation. Administration is finishing
up the Comp Plan update, purchased forms software and updating some security features in the
computer programs.
- The Park Board began the East Park design with S.E.H. and approved Millstream Park play
equipment.
- The Fire Board approved lighting repairs and painting on the outside of the building. Uniforms
were purchased. The fire department accepted a donation from Kwik Trip East to purchase
defibulators.
BUDGET/FISCAL IMPACT: Information Only – Final audited 12/30/17 statements will be presented
in May 2018.
ATTACHMENTS: Request for Council Action – Quarterly and June Financial Reports
2nd Quarter Reports:
Cash Position as of 3/30/18
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
June Treasurer’s Reports:
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 Improvement Summary Reports:
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: Consider accepting the financial reports.
City of St. Joseph, Minnesota
Cash Position
As of 6/30/18
Sentry Bank Maturity Date Interest Current Balance #Securities %of Total
Checking Account(Reconciled) N/A 0.15% $ 356,871 N/A
Money Market Savings N/A 0.80% 1,496,663 N/A
Jacob Wetterling Rec Center Savings N/A 0.15% 2,633 N/A
Bank Certificates of Deposit 3 months 1.50% avg 1,000,000 1
averages 3 months 1.25%
Total SB $ 2,856,167 39%
Central MN Credit Union
Share Savings Account N/A 0.00% $ 20 N/A
Money Market Savings N/A 0.85% 476,189 N/A
Jumbo Bank Certificates of Deposit 1 month 1.75% avg 175,000 1
averages 1 month 1.33%
Total CMCU $ 651,209 9%
Total Deposits $ 3,507,376
Morgan Stanley
Brokered Money Market Savings N/A 1.38% $ 19,279 N/A
Government Securities/Notes 79 months 2.00% avg 295,464 1
Brokered Certificates of Deposit Tiered 1-64 months 2.07% avg_ 3,574,622 19
averages 38 months 2.06%
Total MS $ 3,889,365 53%
Total Investments $ 3,889,365
2018 YTD
Total Deposits and Investments $ 7,396,741 Interest Earned
Average Interest APY 14 months 1.55% _ -$37,207
Total Deposits&Investments $ 7,396,741 Cash and Investment Balance
Petty Cash
Administration N/A N/A $ 200
Police Department N/A N/A 75
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. %Securities Averages
Brokered Money Markets $ 19,279 0.26% N/A
Brokered Certificates of Deposit $ 3,574,622 48.33% 3.17 years
Government Bonds/Notes $ 295,464 3.99% N/A
Foreign Currency Risk: The City only invests in USA and USA territories.
Cash and Investment Holdings
1,975,505 , 27%
356,871, 5%
3,574,622 , 48%
■Checking
■Money Market Savings
Bank CDs
■Brokered Money Market
■Government Securities
■Brokered CDs
295,464, 4%
19,279 , 0% 1,175,000, 16%
General & Fire Budget to Actual Expenditures & Revenues
$3,500,000
53,000,000 52,969,350 52,975,850
52,500,000 4111
52,000,000
Y Exp Budget
•Exp Actual
51,500,000 51,448,187 Rev Budget
o Rev Actual
51,000,000
$749,064
$500,000 •
$346,465 $342,995
5167,022
546,835
5- 1, I ! a
General Fund Fire Fund
49%Spent 25%Received 14%Spent 49%Received
City of St. Joseph, Minnesota
Cash Balances by Fund/Remaining Budget
As of 6/30/18
FUND CASH BALANCE 18 EXP BUD 18 SPENT 18 LEFT 18 BUD REV 18 RECEIVED 18 LEFT
General Fund $ 1,161,808 $ 2,969,350 $ 1,448,187 $ 1,521,163 $ 2,975,850 $ 749,064 $ 2,226,786
Fire Fund 589,710 346,465 46,835 $ 299,630 342,995 167,022 $ 175,973
EDA Fund 24,678 119,025 38,864 $ 80,161 119,025 37,468 $ 81,557
TIF Funds 67,673 40,680 95 $ 40,585 - 39,001 $ (39,001)
State Collected Sales Tax 894,170 1,110,000 250,600 $ 859,400 425,000 98,582 $ 326,418
Park Dedication 118,875 143,190 9,721 $ 133,469 35,240 7,214 $ 28,026
Charitable Gambling 2,080 4,500 - $ 4,500 - (10) $ 10
Lodging Tax 21,011 - 4,000 $ (4,000) - 4,257 $ (4,257)
DEED CDAP Grant 17,437 - 1,834 $ (1,834) - 8,125 $ (8,125)
Revolving Loan Fund 207,003 - 35 $ (35) - 1,383 $ (1,383)
Debt Funds 1,945,716 1,586,010 233,537 $ 1,352,473 1,339,450 . 626,509 $ 712,942
Capital Project Funds 576,918 77,320 118,723 $ (41,403) 77,320 296,067 $ (218,747)
Water Access Fund 305,354 200,000 - $ 200,000 - 63,634 $ (63,634)
Sewer Access Fund 34,481 96,090 - $ 96,090 162,500 28,123 $ 134,377
Water Fund 644,062 1,612,550 467,417 $ 1,145,133 1,281,170 316,003 $ 965,167
Sewer Fund 237,576 1,812,260 349,179 $ 1,463,081 1,421,370 467,298 $ 954,072
Refuse/Compost Fund 250,372 293,185 145,200 $ 147,985 280,200 106,251 $ 173,949
Storm Sewer 264,115 256,405 62,515 $ 193,891 60,940 18,120 $ 42,820
Street Light Utility 33,699 80,975 28,724 $ 52,251 80,815 32,976 $ 47,839
TOTALS $ 7,396,741 $ 3,205,466 $ 3,067,087
12/31/17 Cash Balance $ 7,407,689 5 months of cash balance
2018 cash decrease (10,948)
Enterprise Funds Activity
Street Light gi $28,724
$32,976
$62,515
Storm Water
18,120
Refuse $145,200
$106,251 j •Expense
■Revenue
Sewer $349,179
$467,298
$467,417
Water
$316,003
$- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 $400,000 $450,000 $500,000
Storm Water Refuse Sewer Water Street Lights
% Revenue to Expenses 29% 73% 134% 68% 115%
Utilities represents 4 months revenue collected with 6 months expensed.
City of St.Joseph
Quarterly Water Fund Analysis
As of June 30,2018
Fund 601+501,Water/WAC Fund Balance as of December 31,2017(audited) $ 1,037,196.85
WAC fees collected for:
Year to Date Revenue: 2 sewer only SF home as required by Council
Interest Earnings (4,302.95) 13 single family homes(2 were prepaid hook up fees)
Ad Valorem Taxes 8,005.26 Partial 24 College North
Water Usage Charge 163,311.49
Water Fixed Charge 110,730.88
Penalties/Other Usage Fees 5,954.58
WAC/Trunk Fees 64,600.00
Antenna Lease Revenue 17,524.40
Water Meters 12,590.00
Bulk Water Sales 1,222.83
Transfers from other Funds -
Total Revenue 379,636.49 29.63%budget collected
2018 Revenue Budget 1,281,170.00 (includes fund 501)
Year to Date Expenses by Department:
Debt Payments (51,038.06)
Transfers to Other Funds (500.00)
Power and Pumping (841.15)
Water Treatment Plant 1 (235,390.80) WTP1 expenses include contract to refurbish
Water Treatment Plant 2 (38,425.47)
Distribution (7,778.40)
Wellhead Protection -
Water Tower (2,716.96)
Water Maintenance (108,419.36)
Water Administration (22,306.54)
Total Expenses (467,416.74) 46.16%budget expensed
2018 Expense Budget (1,012,550.00) (excludes depreciation,includes 501)
Fund Summary as of June 30,2018:
Water Fund Cash Balance-Fund 601+501 -unaudited $ 949,416.60
Fund 501 $ 305,354.27
Fund 601 $ 644,062.33
The balances represent the cash balance as of 6/30/18
City of St.Joseph
Quarterly Sewer Fund Analysis
As of June 30,2018
Fund 602+502,Sewer/SAC Fund Balance as of December 31,2017(audited) $ 125,815.93
SAC fees collected for:
Year to Date Revenue: 13 single family homes(2 were prepaid hook up fees)
Interest Earnings (6,822.85) Partial 24 College North
Sewer Usage Charge 285,093.35
Sewer Fixed Charge 185,285.44
Penalties/Other Usage Fees 3,507.02
SAC/Trunk Fees 28,150.00
RV Dump Donations 208.00
Transfers from other Funds -
Total Revenue 495,420.96 31.28% budget collected
2018 Revenue Budget 1,583,870.00 (includes fund 501)
Year to Date Expenses by Department:
Debt Payments 17,593.00
Transfers to Other Funds (500.00)
Sewer Maintenance (62,258.68)
Baker Street Lift Station (2,061.37)
Ridgewood Lift Station (765.34)
Northland Lift Station (490.26)
CR121 Lift Station (839.90)
Main Lift Station (270,854.13)
Sewer Administration (29,002.65)
Total Expenses (349,179.33) 24.79% budget expensed
2018 Expense Budget (1,408,350.00) (excludes depreciation,includes fund
Fund Summary as of June 30,2018:
Sewer Fund Cash Balance-Fund 602+502-unaudited S 272,057.56
Fund 502 $ 34,481.33
Fund 602 $ 237,576.23
The balances represent the cash balance as of 6/30/18.
Sales Tax Summary
Summary of Committed&Available Funds
As of June 30,2018
Sales Tax Receipts 3,919,581.91
Interest Earnings 89,718.67
Community Center Bond Proceeds 1,794,000.00
Transfer-Rec Funds(Facilities) 19,274.35
Transfer-General Fund 24,003.73
Transfer-Government Center Bonds 35,448.92
Transferred to the Water Fund(int.earnings) (86,436.20)
Donation,Misc. 40,110.00
5,835,701.38
State Bonding
Project Federal/APO/ Fund 200 YTD Balance to be
Pro'ect Name/T 'e Year Pro'ect Cost Other Fnndin' Ex,ended Funded
Sales Tax Committee 2007/2008 585.80 585.80 -
Park&Trail System Plan 2007 51,631.25 51,631.25 -
Centennial Park Swing set 2010 33,284.14 33,284.14 -
Community Center-Planning&Remodel 2010-2013 936,924.83 (54,723.27) 382,201.56 500,000.00 $54,723.27 transfer from other funds
CR 2/3 Trail Extension Phase I 2010-2013 446,513.37 446,513.37 -
Wobegon Trailhead Improvements 2013 13,886.18 13,886.18 -
CR 133/College Ave Sidewalk 2010-2013 192,729.82 192,729.82 -
Aquatics Design 2014 75,000.00 71,623.50 3,376.50
Wobegon Trail Extension to St.Cloud 2017 200,082.00 200,082.00 -
Trail Extension Phase II/111 2017 1,490,641.25 (677,000.00) 179,393.39 634,247.86 5500,000 MSAS advanced
Millstream Park Shelter 2015/2017 569,599.04 (40,000.00) 529,599.04 - $40,000 Lion's donation
Community Center-Colts purchase 2014 2,826,618 47 2,826,618.47 -
Jacob Wetterling Recreation Center 2018 10,000,000.00 (6.000,000.00) - 4,000,000.00 $4M donations est.;$2M state bonding request
Field Street-sales tax portion only 2017 420,000.00 - 420,000.00 cover bond payments due to deferred assessments
Pedestrian Bridge-Study 2016-2017 45,382.38 (32,000.00) 13,382.38 - $31KAPO funded
Totals 17,302,878.53 (6,749,000.00) 4,941,530.90 5,557,624.36
Less:Bonded Projects (4,000,000.00)
Committed-to be funded 1,557,624.36
Committed-to be funded-2018 776,247.86
Balance Fund 200 as of lune 30,2018,unaudited 894,170.48
anticipated remaining 2018 sales tax revenues to collect 326,417.67
Committed-to be funded (776,247.86)
Anticipated 2018 December Balance Including funding commitments 444,340.29
Average Annual Revenue(3 yr) 431,122.00
Average Bond Payment Field St(5 yr) (42,000.00)
Average Bond Payment Colts Academy(5 yr) (160,000.00)
uncommitted annually(5 yr Average) 229,122.00
MSAS/SA Bonds
Projects that have been discussed for Sales Project Donations/ YTD Balance to be
Tax Funding Year Project Cost State Bonding Expended Funded
Aquatics Center 6,500,000 (2,000,000) - 4,500,000 $2M donations est.
Pedestrian Crossing 3,000,000 1,500.000 - 4,500,000 SI SM State Bonding request
Amphitheater 150,000 (50,000) - 100,000 $SOK donations cut.
East Park Development 557,000 (300,000) - 257,000 $300K State Bonding request
10,207,000 (850,000) - 9,357,000
Maximum Funding Available
2006-2018 Legislation 4,250,000
2019-2038 Legislation 11,000,000
15,250,000
City of St. Joseph 07/06/18 8:59 AI
Page
Cash Balances Only
Current Period:June 2018
MTD MTD Current
FUND Descr Account Begin Yr Debit Credit Balance
Last Dim 10100
General G 101-10100 $1,835,385.36 $502,287.04 $224,579.74 $1,037,945.61
Employee Retirement Reserve G 102-10100 $115,843.34 $0.00 $0.00 $122,343.34
Fire Fund G 105-10100 $521,806.17 $23,840.28 $6,653.39 $589,710.17
Cable Access Fee G 108-10100 $33,717.49 $941.14 $0.00 $1,519.21
Economic Development G 150-10100 $27,549.20 $37,764.57 $3,302.01 $24,678.09
TIF 3-1 CMCU G 152-10100 $2,759.65 $15,145.83 $0.00 $17,896.16
TIF 4-1 Fortitude Senior Apts G 153-10100 $2,136.02 $12,274.89 $0.00 $14,404.81
TIF 2-1 Millstream G 157-10100 $23,356.90 $10,079.25 $0.00 $33,367.67
TIF 2-2 Meat Market G 158-10100 $332.52 $1,504.43 $0.00 $1,820.64
TIF 2-3 Bayou Blues/Alley Flat G 159-10100 $119.95 $104.13 $0.00 $183.79
State Collected Sales Tax G 200-10100 $961,315.04 $98,635.96 $50,286.78 $894,170.48
Park Dedication G 205-10100 $121,019.37 $6,698.33 $94.00 $118,875.12
Charitable Gambling G 215-10100 $2,084.77 $0.87 $0.00 $2,079.64
Lodging Tax G 220-10100 $20,177.02 $1,231.29 $0.00 $21,011.42
DEED CDAP Grant G 225-10100 $11,126.43 $8,171.16 $0.00 $17,436.56
Revolving Loan Fund G 250-10100 $205,554.66 $429.72 $0.00 $207,003.05
2016 CIP Bonds[govt center] G 301-10100 $17,890.40 $99,602.70 $0.00 $107,345.70
2017A CIP Bonds[Gov Center] G 303-10100 $55,005.64 $23.21 $0.00 $56,975.25
2016 Street Impr[Field St] G 304-10100 $190,459.50 $18,873.33 $546.50 $105,416.93
2017B Impr Bonds[CBD Alleys G 305-10100 $44,961.76 $8,531.73 $0.00 $52,111.16
2018 Equip Certificates G 306-10100 $0.00 $77.91 $0.00 $4,969.06
2010B Refundin[Hill/Clover] G 333-10100 $108,556.26 $26,030.74 $0.00 $131,280.54
2011A CO Refund[Interior St] G 338-10100 $100,177.59 $37,208.46 $0.00 $131,823.41
2009B GO CIP Bonds G 343-10100 $10,633.34 $21,117.86 $0.00 $30,665.12
2010B Street Impr[16th Ave] G 345-10100 $169,832.48 $8,493.52 $0.00 $171,441.71
2011A Pumper Truck Certificat G 346-10100 $27.97 $11,069.45 $0.00 $20,682.18
2011A GO CIP Bonds[roof/gar] G 347-10100 $3,319.92 $8,521.43 $0.00 $10,928.25
2013 Street Improve Bonds G 348-10100 $110,704.94 $6,890.06 $0.00 $113,317.15
2013 Equipment Certificates G 349-10100 $7,044.14 $21,103.39 $0.00 $27,576.34
2014 Street Impr[ParkTerrace G 350-10100 $249,175.21 $35,218.79 $0.00 $259,136.09
2015 Street[Clinton/Northland] G 351-10100 $146,996.79 $32,253.18 $0.00 $173,561.94
2015 Equipment Certificates G 352-10100 $1,527.89 $55,742.37 $0.00 $56,621.05
2015 Abatement Bonds[Kenne G 353-10100 $20,204.35 $27.77 $0.00 $159,041.03
Debt Service Relief G 390-10100 $392,280.94 $3,280.00 $0.00 $332,822.70
Community Center phase I G 402-10100 $1,884.67 $1.02 $0.00 $2,453.84
2017 CBD Alley Improve ph 1 G 405-10100 $62,955.96 $0.00 $3,199.78 $59,504.98
2018 Equip Certificates G 406-10100 $0.00 $5,000.00 $17,169.88 $155,279.74
Capital Outlay G 490-10100 $347,121.83 $25,539.62 $0.00 $359,679.93
WAC Fund G 501-10100 $241,291.01 $30,259.63 $0.00 $305,354.27
SAC Fund G 502-10100 $6,318.77 $16,655.53 $0.00 $34,481.33
Water Fund G 601-10100 $670,381.85 $115,957.28 $28,573.26 $644,062.33
Sewer Fund G 602-10100 $2,345.84 $174,119.45 $22,189.40 $237,576.23
Refuse Collection G 603-10100 $257,764.40 $36,279.88 $26,945.05 $250,372.13
Storm Water Utility G 651-10100 $280,964.44 $9,545.11 $4,056.36 $264,115.44
Street Light Utility G 652-10100 $23,576.76 $9,426.15 $4,323.98 $33,699.46
Last Dim 10100 $7,407,688.54 $1,535,958.46 $391,920.13 $7,396,741.05
Last Dim 10200
General G 101-10200 $275.00 $0.00 $0.00 $275.00
Last Dim 10200 $275.00 $0.00 $0.00 $275.00
City of St. Joseph 07/06/18 8:59 At
Page
Cash Balances Only
Current Period:June 2018
MTD MTD Current
FUND Descr Account Begin Yr Debit Credit Balance
$7,407,963.54 $1,535,958.46 $391,920.13 $7,397,016.05
City of St. Joseph 07/06/18 9:10 Al
Page
Council Month End Revenue Summary
Current Period:June 2018
2018 June 2018
FUND FUND Descr YTD Budget 2018 Amt YTD Amt
101 General $2,961,415.00 $501,392.51 $739,415.22
102 Employee Retirement Reserve $6,500.00 $0.00 $6,500.00
105 Fire Fund $342,995.00 $23,376.51 $167,021.54
108 Cable Access Fee $7,935.00 $941.14 $3,148.94
150 Economic Development $119,025.00 $37,763.17 $37,468.46
152 TIF 3-1 CMCU $0.00 $15,145.83 $15,132.55
153 TIF 4-1 Fortitude Senior Apts $0.00 $12,274.89 $12,266.25
157 TIF 2-1 Millstream $0.00 $10,079.25 $9,956.36
158 TIF 2-2 Meat Market $0.00 $1,504.43 $1,542.06
159 TIF 2-3 Bayou Blues/Alley Flat $0.00 $104.13 $103.75
200 State Collected Sales Tax $425,000.00 $98,635.96 $98,582.33
205 Park Dedication $35,240.00 $6,698.33 $7,214.46
215 Charitable Gambling $0.00 $0.87 -$10.26
220 Lodging Tax $0.00 $1,231.29 $4,257.00
225 DEED CDAP Grant $0.00 $8,171.16 $8,125.13
250 Revolving Loan Fund $0.00 $429.72 $1,383.39
301 2016 CIP Bonds[govt center] $270,005.00 $99,602.70 $135,240.24
303 2017A CIP Bonds[Gov Center] $55,500.00 $23.21 $9,837.88
304 2016 Street Impr[Field St] $55,290.00 $18,873.33 $16,582.84
305 2017B Impr Bonds[CBD Alleys] $48,085.00 $8,531.73 $14,250.22
306 2018 Equip Certificates $0.00 $77.91 $16,227.06
333 2010B Refundin[Hill/Clover] $178,360.00 $26,030.74 $26,993.31
338 2011A CO Refund[Interior St] $118,950.00 $37,208.46 $36,624.71
343 2009B GO CIP Bonds $57,050.00 $21,117.86 $21,051.81
345 2010B Street Impr[16th Ave] $41,120.00 $8,493.52 $7,538.13
346 2011A Pumper Truck Certificate $43,660.00 $11,069.45 $22,505.83
347 2011A GO CIP Bonds[roof/gar] $23,035.00 $8,521.43 $8,503.61
348 2013 Street Improve Bonds $20,585.00 $6,890.06 $6,258.89
349 2013 Equipment Certificates $57,065.00 $21,103.39 $21,045.30
350 2014 Street Impr[ParkTerrace] $101,395.00 $35,218.79 $33,685.92
351 2015 Street[Clinton/Northland] $44,160.00 $32,253.18 $31,313.95
352 2015 Equipment Certificates $37,005.00 $55,742.37 $55,682.36
353 2015 Abatement Bonds[Kennedy] $160,185.00 $27.77 $159,886.44
390 Debt Service Relief $28,000.00 $3,280.00 $3,280.00
402 Community Center phase I $0.00 $1.02 $567.35
406 2018 Equip Certificates $0.00 $5,000.00 $266,460.40
490 Capital Outlay $77,320.00 $25,539.62 $29,039.62
501 WAC Fund $0.00 $30,259.63 $63,633.52
502 SAC Fund $162,500.00 $16,655.53 $28,123.15
601 Water Fund $1,281,170.00 $114,498.31 $316,002.97
602 Sewer Fund $1,421,370.00 $173,911.83 $467,297.81
City of St. Joseph 07/06/18 9:10 Al
Page
Council Month End Revenue Summary
Current Period:June 2018
2018 June 2018
FUND FUND Descr YTD Budget 2018 Amt YTD Amt
603 Refuse Collection $280,200.00 $34,774.33 $106,250.62
651 Storm Water Utility $60,940.00 $9,539.11 $18,119.73
652 Street Light Utility $80,815.00 $9,417.95 $32,975.79
$8,601,875.00 $1,531,412.42 $3,067,086.64
City of St. Joseph 07/06/18 9:10 AI
Page
Council Month End Revenue -General Fund
Current Period:June 2018
2018 June 2018
FUND FUND Descr SOURCE Descr YTD Budget 2018 Amt YTD Amt
FUND 101 General
101 General Current Ad Valorem Taxes $1,282,660.00 $426,278.70 $426,278.70
101 General Special Levy-City St.Joe $0.00 $0.00 $0.00
101 General State Sales Tax $0.00 $3.77 $79.56
101 General Gas Franchise $31,210.00 $0.00 $8,256.87
101 General Electric Franchise $58,335.00 $1,914.20 $18,470.59
101 General Licenses&Permits $10,000.00 $0.00 $10,200.00
101 General Beer $1,950.00 $980.44 $3,205.44
101 General Liquor $29,135.00 $6,656.25 $24,166.25
101 General Outdoor Liquor Permit $1,775.00 $150.00 $1,900.00
101 General Gambling Permits $375.00 $0.00 $200.00
101 General Amusement/Hunt/Peddler/Golf $1,400.00 $0.00 $265.00
101 General Excavation Permit $500.00 $0.00 $350.00
101 General Cigarette License $675.00 $0.00 $62.50
101 General Cable Franchise Fee $34,000.00 $1,221.61 $10,772.26
101 General Building Permits $115,000.00 $39,132.31 $75,549.53
101 General Animal License $3,400.00 $90.00 $2,825.00
101 General Rental Housing Registration $30,305.00 $8,507.37 $15,192.37
101 General Federal Grants-Other $12,000.00 $0.00 $396.07
101 General State Grants and Aids $1,100.00 $0.00 $0.00
101 General Local Government Aid $989,464.00 $0.00 $0.00
101 General PERA Rate Increase Aid $1,541.00 $0.00 $0.00
101 General Police Training Reim $3,500.00 $0.00 $0.00
101 General State Municipal Funds Aid $50,000.00 $0.00 $28,049.00
101 General State Police Aid $62,000.00 $0.00 $0.00
101 General Other Grants/Aids $0.00 $0.00 $0.00
101 General Other Governmental Unit $10,000.00 $0.00 $5,000.00
101 General County Grants-Road Maint. $6,500.00 $0.00 $0.00
101 General Zoning and Subdivision Fee $5,000.00 $200.00 $6,610.00
101 General Land Use Deposit Fee $4,000.00 $0.00 $4,100.00
101 General Sale of Maps and Publications $50.00 $0.00 $9.75
101 General Assessments Search $4,000.00 $450.00 $2,910.00
101 General Special Hearing $5,500.00 $0.00 $0.00
101 General Administration Reimb $12,745.00 $3.60 $14.40
101 General Weed Cutting $500.00 $0.00 $0.00
101 General Admission Fee $1,000.00 $0.00 $0.00
101 General Shelter/Room Rental Fees $7,500.00 $1,185.00 $7,215.00
101 General Ball Field Donation $100.00 $0.00 $0.00
101 General Schneider Field Rental $1,500.00 $800.00 $800.00
101 General Rents and Royalties $53,450.00 $5,089.40 $30,536.40
101 General Kennel Fees $500.00 $0.00 $117.00
City of St. Joseph 07/06/18 9:10 AI
Page
Council Month End Revenue -General Fund
Current Period:June 2018
2018 June 2018
FUND FUND Descr SOURCE Descr YTD Budget 2018 Amt YTD Amt
101 General County Fines $40,000.00 $4,335.80 $15,211.08
101 General Policy Fines $15,000.00 $160.00 $13,083.20
101 General Accident Report Fee $1,200.00 $75.75 $983.25
101 General Seized Property $500.00 $0.00 $1,963.50
101 General Special Assessments $3,000.00 $1,280.50 $3,415.16
101 General Interest Earnings $20,000.00 $609.72 -$9,972.65
101 General Interest Charges $200.00 $0.00 $14.27
101 General Co-op Dividend-LMCIT $14,000.00 $0.00 $0.00
101 General Water Tower Antenna Lease $3,930.00 $342.60 $1,790.44
101 General Advertising $1,200.00 $0.00 $400.00
101 General Contributions-General $500.00 $0.00 $5,396.00
101 General Contributions-Parks $500.00 $0.49 $61.16
101 General Surplus Property $0.00 $0.00 $0.00
101 General Reimbursement $28,715.00 $0.00 $19,119.59
101 General Insurance Recovery $0.00 $1,925.00 $4,418.53
101 General Transfers from Other Funds $0.00 $0.00 $0.00
FUND 101 General $2,961,415.00 $501,392.51 $739,415.22
FUND 102 Employee Retirement Reserve
102 Employee Retirement Res Transfers from Other Funds $6,500.00 $0.00 $6,500.00
FUND 102 Employee Retirement Reserve $6,500.00 $0.00 $6,500.00
FUND 108 Cable Access Fee
108 Cable Access Fee Cable Franchise Fee $7,935.00 $941.14 $3,148.94
108 Cable Access Fee Transfers from Other Funds $0.00 $0.00 $0.00
FUND 108 Cable Access Fee $7,935.00 $941.14 $3,148.94
FUND 150 Economic Development
150 Economic Development Current Ad Valorem Taxes $114,325.00 $37,764.57 $37,764.57
150 Economic Development Federal Grants-Other $0.00 $0.00 $0.00
150 Economic Development TIF/MIF Deposit $3,600.00 $0.00 $0.00
150 Economic Development Interest Earnings $1,100.00 -$1.40 -$296.11
150 Economic Development Transfers from Other Funds $0.00 $0.00 $0.00
FUND 150 Economic Development $119,025.00 $37,763.17 $37,468.46
FUND 490 Capital Outlay
490 Capital Outlay Current Ad Valorem Taxes $77,320.00 $25,539.62 $25,539.62
490 Capital Outlay Federal Grants-Other $0.00 $0.00 $0.00
490 Capital Outlay Surplus Property $0.00 $0.00 $3,500.00
FUND 490 Capital Outlay $77,320.00 $25,539.62 $29,039.62
$3,172,195.00 $565,636.44 $815,572.24
City of St. Joseph 07/06/18 9:01 Ar
Page
Council Month End Revenue -Enterprise Funds
Current Period:June 2018
FUND 2018 June 2018
FUND Descr SOURCE Descr YTD Budget 2018 Amt YTD Amt
FUND 601 Water Fund
601 Water Fund Penalties and Forfeited Disc $8,110.00 $888.48 $3,187.72
601 Water Fund Current Ad Valorem Taxes $22,500.00 $8,331.78 $8,005.26
601 Water Fund General Oblig. Bond Proceeds $0.00 $0.00 $0.00
601 Water Fund Transfers from Other Funds $207,000.00 $0.00 $0.00
601 Water Fund Contributed Revenue $0.00 $0.00 $0.00
601 Water Fund MDS Test Fee $12,250.00 $1,291.77 $3,913.46
601 Water Fund Water Meter $5,000.00 $9,320.00 $12,590.00
601 Water Fund Connection/Reconnection fees $0.00 $0.00 $0.00
601 Water Fund Undesignated Funds $0.00 $3,449.41 $2,773.58
601 Water Fund Bulk Water $2,500.00 $265.35 $1,222.83
601 Water Fund Special Assessments $400.00 $31.94 -$704.08
601 Water Fund State Sales Tax $0.00 -$230.85 -$3,168.10
601 Water Fund Water Fixed Charge $319,230.00 $36,224.87 $110,730.88
601 Water Fund State Grants and Aids $0.00 $0.00 -$48.00
601 Water Fund Usage Rate $635,545.00 $51,563.83 $163,311.49
601 Water Fund Interest Earnings $33,250.00 $278.24 -$3,336.47
601 Water Fund Amortization of Bond Premium $0.00 $0.00 $0.00
601 Water Fund Water Tower Antenna Lease $35,385.00 $3,083.49 $17,524.40
601 Water Fund Surplus Property $0.00 $0.00 $0.00
601 Water Fund Reimbursement $0.00 $0.00 $0.00
FUND 601 Water Fund $1,281,170.00 $114,498.31 $316,002.97
FUND 602 Sewer Fund
602 Sewer Fund Contributed Revenue $0.00 $0.00 $0.00
602 Sewer Fund Sanitary Sewer Use Service $852,535.00 $105,730.32 $285,093.35
602 Sewer Fund Other Governmental Unit $0.00 $0.00 $0.00
602 Sewer Fund Special Assessments $400.00 $11.61 $56.92
602 Sewer Fund Interest Earnings $15,000.00 $581.71 -$6,796.00
602 Sewer Fund Amortization of Bond Premium $0.00 $0.00 $0.00
602 Sewer Fund Contributions-General $0.00 $120.00 $208.00
602 Sewer Fund Surplus Property $0.00 $0.00 $0.00
602 Sewer Fund State Grants and Aids $0.00 $0.00 -$39.00
602 Sewer Fund Penalties and Forfeited Disc $7,500.00 $1,018.87 $3,489.10
602 Sewer Fund Sewer Fixed Charge $541,935.00 $66,449.32 $185,285.44
602 Sewer Fund Transfers from Other Funds $0.00 $0.00 $0.00
602 Sewer Fund Reimbursement $4,000.00 $0.00 $0.00
FUND 602 Sewer Fund $1,421,370.00 $173,911.83 $467,297.81
FUND 603 Refuse Collection
603 Refuse Collect Refuse Collection Charges $269,450.00 $28,572.34 $84,179.58
603 Refuse Collect Reimbursement $1,850.00 $0.00 $643.32
603 Refuse Collect Contributions-General $0.00 $0.00 $0.00
603 Refuse Collect Interest Earnings $3,000.00 $103.69 -$1,246.00
603 Refuse Collect Penalties and Forfeifted Disc $5,700.00 $298.80 $1,810.52
603 Refuse Collect Contributed Revenue $0.00 $0.00 $0.00
603 Refuse Collect State Grants and Aids $0.00 $0.00 -$5.00
603 Refuse Collect Licenses&Permits $0.00 $4,260.00 $22,430.00
603 Refuse Collect State Sales Tax $0.00 $1,528.47 -$1,569.47
603 Refuse Collect Special Assessments $200.00 $11.03 $7.67
FUND 603 Refuse Collection $280,200.00 $34,774.33 $106,250.62
City of St. Joseph 07/06/18 9:01 At
Page
Council Month End Revenue -Enterprise Funds
Current Period:June 2018
FUND 2018 June 2018
FUND Descr SOURCE Descr YTD Budget 2018 Amt YTD Amt
FUND 651 Storm Water Utility
651 Storm Water Storm Water Develop Fee $4,000.00 $2,698.00 $2,698.00
651 Storm Water Penalties and Forfeifted Disc $2,120.00 $75.15 $404.74
651 Storm Water Storm Water Use Service $51,920.00 $5,664.37 $18,182.84
651 Storm Water Contributed Revenue $0.00 $0.00 $0.00
651 Storm Water Interest Earnings $2,500.00 $112.69 -$1,339.09
651 Storm Water State Grants and Aids $0.00 $0.00 -$10.00
651 Storm Water Special Assessments $400.00 $988.90 -$1,816.76
FUND 651 Storm Water Utility $60,940.00 $9,539.11 $18,119.73
FUND 652 Street Light Utility
652 Street Light U Other Grants/Aids $0.00 $0.00 $571.00
652 Street Light U State Grants and Aids $0.00 $0.00 -$2.00
652 Street Light U Special Assessments $50.00 $1.16 $1.52
652 Street Light U Interest Earnings $400.00 $10.24 -$118.53
652 Street Light U Contributions-General $0.00 $0.00 $7,000.00
652 Street Light U Reimbursement $3,000.00 $0.00 $0.00
652 Street Light U Usage Rate $76,365.00 $9,302.23 $25,216.97
652 Street Light U Penalties and Forfeited Disc $1,000.00 $104.32 $306.83
FUND 652 Street Light Utility $80,815.00 $9,417.95 $32,975.79
$3,124,495.00 $342,141.53 $940,646.92
City of St. Joseph 07/06/18 9.00 AI
Page
Council Month End Expenditure - Summary
Current Period:June 2018
2018 June 2018
Description YTD Budget 2018 Amt YTD Amt
General $2,961,415.00 $221,392.23 $1,412,187.21
Employee Retirement Reserve $0.00 $0.00 $0.00
Fire Fund $346,465.00 $6,189.62 $46,834.83
Cable Access Fee $7,935.00 $0.00 $36,000.00
Economic Development $119,025.00 $3,300.61 $38,863.67
TIF 3-1 CMCU $795.00 $0.00 $0.00
TIF 4-1 Fortitude Senior Apts $0.00 $0.00 $0.00
TIF 2-1 Millstream $34,545.00 $0.00 $0.00
TIF 2-2 Meat Market $4,545.00 $0.00 $55.30
TIF 2-3 Bayou Blues/Alley Flat $795.00 $0.00 $39.91
State Collected Sales Tax $1,110,000.00 $50,286.78 $250,600.13
Park Dedication $143,190.00 $94.00 $9,721.00
Charitable Gambling $4,500.00 $0.00 $0.00
Lodging Tax $0.00 $0.00 $4,000.00
DEED CDAP Grant $0.00 $0.00 $1,834.00
Revolving Loan Fund $0.00 $0.00 $35.00
2016 CIP Bonds[govt center] $273,345.00 $0.00 $46,621.25
2017A CIP Bonds[Gov Center] $55,070.00 $0.00 $7,761.77
2016 Street Impr[Field St] $63,950.00 $546.50 $20,797.27
2017B Impr Bonds[CBD Alleys] $46,745.00 $0.00 $7,136.88
2018 Equip Certificates $0.00 $0.00 $11,258.00
2010B Refundin[Hill/Clover] $144,350.00 $0.00 $4,624.00
2011A CO Refund[Interior St] $141,730.00 $0.00 $5,815.00
2009B GO CIP Bonds $62,745.00 $0.00 $1,125.00
2010B Street Impr[16th Ave] $62,755.00 $0.00 $6,327.50
2011A Pumper Truck Certificate $43,660.00 $0.00 $1,780.00
2011A GO CIP Bonds[roof/gar] $21,820.00 $0.00 $860.00
2013 Street Improve Bonds $42,870.00 $0.00 $3,885.00
2013 Equipment Certificates $61,300.00 $0.00 $600.00
2014 Street Impr[ParkTerrace] $164,535.00 $0.00 $24,717.50
2015 Street[Clinton/Northland] $71,050.00 $0.00 $5,475.00
2015 Equipment Certificates $36,850.00 $0.00 $875.00
2015 Abatement Bonds[Kenned $152,235.00 $0.00 $21,067.50
Debt Service Relief $141,000.00 $0.00 $62,809.93
Community Center phase I $0.00 $0.00 $0.00
2016 Imp Field St $0.00 $0.00 $0.00
2017 CBD Alley Improve ph 1 $0.00 $3,199.78 -$7,208.82
2018 Equip Certificates $0.00 $17,169.88 $111,180.66
Capital Outlay $77,320.00 $0.00 $14,751.31
WAC Fund $200,000.00 $0.00 $0.00
SAC Fund $96,090.00 $0.00 $0.00
City of St. Joseph 07/06/18 9:00 At
Page
Council Month End Expenditure - Summary
Current Period:June 2018
2018 June 2018
Description YTD Budget 2018 Amt YTD Amt
Water Fund $1,612,550.00 $27,114.29 $467,416.74
Sewer Fund $1,812,260.00 $21,981.78 $349,179.33
Refuse Collection $293,185.00 $25,439.50 $145,200.45
Storm Water Utility $256,345.00 $4,050.36 $62,514.50
Street Light Utility $80,975.00 $4,315.78 $28,723.77
$10,747,945.00 $385,081.11 $3,205,465.59
City of St. Joseph 07/06/18 8:59 Al
Page
Council Month End Expenditure - General Fund
Current Period:June 2018
2018 June 2018
Description DEPART Descr YTD Budget 2018 Amt YTD Amt
FUND 101 General
General Council $64,605.00 $2,016.67 $26,608.52
General Legislative Committees $5,945.00 $0.00 $630.00
General Ordinance&Proceedings $2,600.00 $340.98 $999.48
General Mayor $11,845.00 $1,031.34 $4,631.02
General Elections $2,500.00 $0.00 $0.00
General General Adminstration $269,605.00 $20,920.02 $136,011.17
General Finance $139,945.00 $10,835.96 $63,045.77
General Audit Service $30,000.00 $0.00 $27,750.00
General Assessing $24,000.00 $0.00 $24,579.83
General City Attorney $18,000.00 $2,592.50 $5,080.21
General Planning and Zoning $76,065.00 $5,475.21 $42,941.24
General General Government $38,960.00 $2,086.37 $19,089.09
General City Offices $38,510.00 $2,337.98 $29,871.00
General Cable Access $6,390.00 $422.95 $1,899.46
General Crime Control&Investigation $1,127,945.00 $101,672.37 $509,181.54
General Police Training $9,545.00 $980.00 $5,286.33
General Communication Service $12,780.00 $1,143.84 $5,428.98
General Automotive Services $57,360.00 $0.00 $17,549.24
General Building Inspec.Admistration $95,200.00 $7,500.00 $37,542.06
General Emergency Management $975.00 $7.11 $1,438.59
General Animal Control $815.00 $0.00 $403.99
General Street Maintanence $302,290.00 $13,270.66 $127,787.93
General Ice&Snow Removal $115,235.00 $905.03 $60,128.45
General Engineering Fee $35,000.00 $15,782.66 $25,298.00
General Street Cleaning $14,095.00 $1,338.54 $5,755.09
General Skate Park and Ice Rink $5,410.00 $45.25 $3,344.10
General Ball Park $1,750.00 $0.00 $3,445.00
General Maintenance Shop $26,475.00 $7,047.16 $16,143.15
General Park Areas $230,050.00 $22,158.28 $121,700.98
General Community Center $63,115.00 $1,481.35 $17,130.83
General Other Financing Uses $0.00 $0.00 $5,000.00
General Fire Protection $134,405.00 $0.00 $66,486.16
FUND 101 General $2,961,415.00 $221,39223 $1,412,187.21
FUND 102 Employee Retirement Reserve
Employee Retirement Resery General Adminstration $0.00 $0.00 $0.00
FUND 102 Employee Retirement Reserve $0.00 $0.00 $0.00
FUND 108 Cable Access Fee
Cable Access Fee Cable Access $7,935.00 $0.00 $0.00
Cable Access Fee Other Financing Uses $0.00 $0.00 $36,000.00
City of St. Joseph 07/06/18 8:59 Ar
Page
Council Month End Expenditure - General Fund
Current Period:June 2018
2018 June 2018
Description DEPART Descr YTD Budget 2018 Amt YTD Amt
FUND 108 Cable Access Fee $7,935.00 $0.00 $36,000.00
FUND 150 Economic Development
Economic Development Economic Development Authority $119,025.00 $3,300.61 $38,863.67
Economic Development Other Financing Uses $0.00 $0.00 $0.00
FUND 150 Economic Development $119,025.00 $3,300.61 $38,863.67
FUND 490 Capital Outlay
Capital Outlay General Adminstration $11,300.00 $0.00 $6,464.56
Capital Outlay Crime Control&Investigation $3,380.00 $0.00 $0.00
Capital Outlay Communication Service $4,875.00 $0.00 $0.00
Capital Outlay Automotive Services $13,595.00 $0.00 $416.75
Capital Outlay Emergency Management $1,500.00 $0.00 $0.00
Capital Outlay Street Maintanence $3,750.00 $0.00 $3,810.00
Capital Outlay Ice&Snow Removal $7,500.00 $0.00 $0.00
Capital Outlay Street Cleaning $2,750.00 $0.00 $0.00
Capital Outlay Maintenance Shop $5,000.00 $0.00 $0.00
Capital Outlay Park Areas $23,670.00 $0.00 $4,060.00
Capital Outlay Community Center $0.00 $0.00 $0.00
Capital Outlay Other Financing Uses $0.00 $0.00 $0.00
FUND 490 Capital Outlay $77,320.00 $0.00 $14,751.31
$3,165,695.00 $224,692.84 $1,501,802.19
City of St. Joseph 07/06/18 s:oo Ar
Page
Council Month End Expense - Enterprise Funds
Current Period:June 2018
2018 June 2018
Description DEPART Descr YTD Budget 2018 Amt YTD Amt
FUND 601 Water Fund
Water Fund Bond Payment(P&I) $706,535.00 $0.00 $51,038.06
Water Fund Other Financing Uses $41,500.00 $0.00 $500.00
Water Fund Power and Pumping $28,925.00 $189.29 $841.15
Water Fund Purification-Plant 1 $31,170.00 $4,610.65 $235,390.80
Water Fund Purification-Plant 2 $85,300.00 $5,017.67 $38,425.47
Water Fund Distribution $10,000.00 $0.00 $7,778.40
Water Fund Wellhead Protection $3,000.00 $0.00 $0.00
Water Fund Storage-Tower 1 $15,890.00 $468.99 $2,716.96
Water Fund Water Maintenance $262,325.00 $14,845.84 $108,419.36
Water Fund Administration and General $27,905.00 $1,981.85 $22,306.54
Water Fund Depreciation Expense $400,000.00 $0.00 $0.00
FUND 601 Water Fund $1,612,550.00 $27,114.29 $467,416.74
FUND 602 Sewer Fund
Sewer Fund Bond Payment(P&I) $230,360.00 $0.00 -$17,593.00
Sewer Fund Other Financing Uses $7,500.00 $0.00 $500.00
Sewer Fund Sanitary Sewer Maintenanc $209,845.00 $10,458.35 $62,258.68
Sewer Fund Lift Station-Baker Street $5,865.00 $190.53 $2,061.37
Sewer Fund Lift Station-Ridgewood/DBL $2,695.00 $147.40 $765.34
Sewer Fund Lift Station-Northland $4,665.00 $72.09 $490.26
Sewer Fund Lift Station-CR 121 $5,340.00 $97.05 $839.90
Sewer Fund Lift Station-Main $813,930.00 $8,917.94 $270,854.13
Sewer Fund Administration and General $32,060.00 $2,098.42 $29,002.65
Sewer Fund Depreciation Expense $500,000.00 $0.00 $0.00
FUND 602 Sewer Fund $1,812,260.00 $21,981.78 $349,179.33
FUND 603 Refuse Collection
Refuse Collectio Waste Collection $286,010.00 $25,439.50 $144,700.45
Refuse Collectio Other Financing Uses $500.00 $0.00 $500.00
Refuse Collectio Depreciation Expense $6,675.00 $0.00 $0.00
FUND 603 Refuse Collection $293,185.00 $25,439.50 $145,200.45
FUND 651 Storm Water Utility
Storm Water Uti Other Financing Uses $19,250.00 $0.00 $0.00
Storm Water Uti Administration and General $14,165.00 $930.20 $11,075.79
Storm Water Uti Storm Water Maintenance $107,930.00 $3,120.16 $51,438.71
Storm Water Uti Depreciation Expense $115,000.00 $0.00 $0.00
FUND 651 Storm Water Utility $256,345.00 $4,050.36 $62,514.50
FUND 652 Street Light Utility
Street Light Utili Street Lighting $80,975.00 $4,315.78 $28,723.77
FUND 652 Street Light Utility $80,975.00 $4,315.78 $28,723.77
City of St. Joseph 07/06/18 9:00 AI
Page
Council Month End Expense - Enterprise Funds
Current Period:June 2018
2018 June 2018
Description DEPART Descr YTD Budget 2018 Amt YTD Amt
$4,055,315.00 $82,901.71 $1,053,034.79
2018 Capital Expenditures
General Fund Capital Equipment Plan-Summary
Final adopted December 4,2017
As of June 30,2018
Available through 6/30 through 6/30
Project Budget Reserve Transferred/ Spent Budget Remaining
Department Account Code Equipment Balance Grant 2018 2018 2018 Balance
Election 101-41410-xxx Election Equipment 14,988.04 - - 2,500.00 17,488.04
Planning 101-41941-300 Comp Plan Update 4,915.04 - 325.50 2,500.00 7,089.54
Finance 101-41530-300 GASB Updates 5,200.00 - 1,800.00 2,600.00 6,000.00
Administration 490-41430-570 Administration Equipment 15,252.84 - - 3,050.00 18,302.84
Administration 490-41430-581 Computer Replacement 11,687.01 - 64.56 7,500.00 19,122.45
Administration 490-41430-582 Computer Software 6,174.68 - 6,400.00 750.00 524.68
Cable Access 108-41950-580 Cable Equipment 33,717.49 3,148.94 36,000.00 - 866.43
Total Administration CEP 91,935.10 3,148.94 44,590.06 18,900.00 69,393.98
Police-General 490-42120-580 Police Equipment 9,639.43 - - 3,380.00 13,019.43
Police-Communications 490-42151-580 Communication Equipment 26,743.28 - - 4,875.00 31,618.28
Police-Automotive 490-42152-550 Police Squads 21,709.36 - - 1,500.00 23,209.36
Police-Automotive 490-42152-580 Vehicle/Equipment 22,942.08 - 416.75 10,895.00 33,420.33
Police-Automotive 490-42152-581 Squad Laptops 0.95 - - 1,200.00 1,200.95
Emergency Services 490-42500-580 Emergency Services 9,912.61 - - 1,500.00 11,412.61
Total Police CEP 90,947.71 - 416.75 23,350.00 113,880.96
Streets 101-43120-530 Street Improvements 135,894.61 38,249.00 33,424.77 21,500.00 162,218.84
Streets 490-43120-550 Street Motor Vehicles 3,060.00 1,750.00 3,810.00 3,000.00 4,000.00
Streets 490-43120-580 Street Equipment 2,125.00 - - 500.00 2,625.00
Streets 490-43120-582 Street Software 3,440.00 - - 250.00 3,690.00
Streets 490-43120-530 Street Improvements 5,000.00 - - - 5,000.00
Street Sweeping 490-43220-580 Street Sweeping Equipment 11,250.00 - - 2,750.00 14,000.00
Snow Removal 490-43125-580 Snow Removal Equipment 25,177.68 - - 7,500.00 32,677.68
Maintenance 490-45201-520 Maintenance Cold Storage - - - - -
Maintenance 490-45201-580 Maintenance Shop Equipment 61,816.62 - - 5,000.00 66,816.62
Parks 490-45202-530 Parks Improvements 23,970.00 - - 3,400.00 27,370.00
Parks 490-45202-580 Parks Equipment 72,500.87 - - 17,270.00 89,770.87
Parks 490-45202-550 Parks Motor Vehicles 3,310.00 1,750.00 4,060.00 3,000.00 4,000.00
Total Public Works CEP 347,544.78 41,749.00 41,294.77 64,170.00 412,169.01
EDA Software 150-46500-582 Computer Software 1,898.58 - - 500.00 2,398.58
EDA Projects 250/150-46500-588 EDA Programs 136,713.66 (5,000.00) 15,049.81 56,100.00 202,863.47
Total EDA CIP 138,612.24 (5,000.00) 15,049.81 56,600.00 205,262.05
Total General Capital Improvements 669,039.83 39,897.94 101,351.39 163,020.00 800,706.00
St.Joseph Fire Department
Capital Equipment Plan-for Payable 2018
Adopted December 4,2017
12/31/2017 6/30
Available Grants/ 6/30 Available
Purchased Replace Reserve Budget Adjustments Spent Reserve
CIP# Account Code Department Object Year Year Description Funds 2018 2018 2018 Funds
FD-1401 105-42210-581/582 Fire Administration Computer Hardware/Software 2010-2011 2017-2018 3 Computers 3,332.79 1,300.00 4,632.79
Total Fire Administration Computer Hardware/Software 3,332.79 1,300.00 - - 4,632.79
FD-1402 105-42220-580 Fire Fighting Other Equipment annual annual Turnout Gear 7,755.66 5,000.00 3,983.95 8,771.71
Total Fire Fighting Other Equipment 7,755.66 5,000.00 - 3,983.95 8,771.71
FD-1404 105-42220-584 Fire Fighting 1996-2005 2019-2026 Extrication Equip 25,562.40 2,750.00 28,312.40
Total Fire Fighting Equipment Reserve 25,562.40 2,750.00 - - 28,312.40
FD-1403 105-42220-585 Fire Fighting Firefighter Equipment 2012 2024 6 Wheeler 1,203.95 750.00 1,953.95
FD-1405 105-42220-585 Fire Fighting Firefighter Equipment 2012 2022 Rescue Van 50,259.58 9,500.00 59,759.58
FD-1406 105-42220-585 Fire Fighting Firefighter Equipment 2012 2032 Pumper Truck 75,823.77 11,000.00 86,823.77
FD-1407 105-42220-585 Fire Fighting Firefighter Equipment 2001 2021 Ladder Truck#2 67,250.00 10,000.00 77,250.00
FD-1408 105-42220-585 Fire Fighting Firefighter Equipment 1997 2022 Grass Rig#3 71,000.00 1,500.00 72,500.00
FD-1409 105-42220-585 Fire Fighting Firefighter Equipment 1999 2028 Tanker#4 17,501.00 2,500.00 20,001.00
FD-1417 105-42220-585 Fire Fighting Firefighter Equipment 2013 2019 Air Packs 9,250.00 2,250.00 11,500.00
FD-1410 105-42220-585 Fire Fighting Firefighter Equipment on going on going Replacement 12,592.17 2,000.00 1,205.04 13,387.13
Total Fire Fighting Equipment 304,880.47 39,500.00 - 1,205.04 343,175.43
FD-1411 105-42250-580 Fire Communication Other Equipment 2007 2017 800 MHz Radios 70,908.25 10,000.00 80,908.25
FD-1412 105-42250-580 Fire Communication Other Equipment on going on going Replacement 5,376.62 3,000.00 8,376.62
Total Fire Communications Equipment 76,284.87 13,000.00 - - 89,284.87
FD-1413 105-42270-580 Medical Services Other Equipment on going on going Replacement _ 1,927.57 200.00 1,000.00 3,127.57
Total Medical Services Equipment 1,927.57 200.00 1,000.00 - 3,127.57
FD-1414 105-42280-530 Fire Station&Building Equipment Reserve on going on going Building Repairs 22,266.92 1,500.00 (18,000.00) 5,578.82 188.10
FD-1415 105-42280-530 Fire Station&Building Equipment Reserve 2011 2017-2022 Parking Lot (44,027.58 25,500.00 19,000.00 - 472.42
FD-1416 105-42280-530 Fire Station&Building Improvements other than Building 2008 2017-2024 Painting 10,450.00 1,000.00 (1,000.00) 10,450.00
Total Fire Station&Building Improvements other than Building (11,310.66 28,000.00 - 5,578.82 11,110.52
Total Capital Equipment-Fire Fund 408,433.10 89,750.00 1,000.00 10,767.81 488,415.29
Note: The fire department is funded by the City of St.Joseph,St.Joseph Township and St.Wendel Township.
Proposed Debts
FD-1405 105-42220-585 Fire Fighting Firefighter Equipment 2012 2022 Rescue Van-2022-pay cast
FD-1406 105-42220-585 Fire Fighting Firefighter Equipment 2012 2032 Pumper Truck-2032
FD-1407 105-42220-585 Fire Fighting Firefighter Equipment 2001 2021 Ladder Truck#2.2021 -10%down payment+trade in valu
FD-1409 105-42220-585 Fire Fighting Firefighter Equipment 1999 2028 Tanker#4-202o-may last longer with new tan
City of St. Joseph Park Board
2018 Capital Improvement Budget Summary
Council adopted December 4,2017
General Funds Balance
Park Dedication Cash June 30,2018 $ 118,875
(Unaudited)
Adjustments
Starting Balance $ 118,875
2018 General Levy-remaining $ 13,405
Other Revenues-remaining $ 14,620
Potential Projects: Potential Proposed
Millstream Cottages-phase 2 $ 23,400
Southview Heights(3 phases) $ 52,650
Sunset Ridge-phase 2-4 lots $ 2,000
Ending Balance for 2018 $ 146,901
Projects-Budget 2017 2018 2019 2020 2021 2022 Total 18-22
PTR-01 (Millstream) $ 540,000 $ 40,000 $ - $ - $ 100,000 $ - $ 140,000
PTR-02(Northland) $ - $ - $ - $ 180,000 $ - $ - $ 180,000
PTR-03(Klinefelter) $ - $ - $ - $ - $ - $ 250,200 $ 250,200
PTR-04(Wobegon) $ - $ - $ - $ - $ - $ - $ -
PTR-05(Memorial) $ - $ 5,200 $ - $ - $ - $ - $ 5,200
PTR-06(Centennial) $ - $ - $ - $ - $ - $ - $ -
PTR-07(Monument) $ 25,250 $ 35,250 $ 250 $ 250 $ 250 $ 250 $ 36,250
PTR-08(Hollow) $ - $ 1,000 $ - $ - $ - $ - $ 1,000
PTR-09(Cloverdale) $ - $ - $ - $ - $ - $ - $ -
PTR-10(East Park) $ 4,500 $ 24,620 $ 598,730 $ - $ - $ - $ 623,350
PTR-12(Trails) $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 50,000
PTR-13(Trees) $ 1,500 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 10,000
PTR-14(Dog Park) $ 20,000 $ 20,000 $ - $ - $ 10,000 $ - , $ 30,000
Total $ 601,250 $ 138,070 $ 610,980 $ 192,250 $ 122,250 $ 262,450 $ 1,296,000
Projects-Actual Spent 2017 2018 18 Snow Town Expenses: Avail.Rev
PTR-01(Millstream) $ 7,837 $ - Millstream Shelter $ - $ 905
PTR-02(Northland) $ - $ -
PTR-03(Klinefelter) $ - $ - Other 18 Expenses Budget: 2018 YTD
PTR-04(Wobegon) $ - $ - Real Estate Taxes $ 4,020 $ 3,862
PTR-05(Memorial) $ - $ - A-1 Toilets $ 1,600 $ 564
PTR-06(Centennial) $ - $ -
PTR-07(Monument) $ - $ - 2018 Revenue Bud•et: 2018 YTD
PTR-08(Hollow) $ - $ - Interest $ 1,000 $ (588)
PTR-09(Cloverdale) $ - $ - Round Up $ 120 $ 58
PTR-10(East Park) $ 435 $ 5,295 phase 1 design GF Levy $ 20,000 $ 6,595
PTR-11(West Park) $ - $ - Land Rent $ 2,120 $ 1,060
PTR-12(Trails) $ - $ - Transfer $ - $ -
PTR-13(Trees) $ - $ - Donations $ 10,000 $ 90
PTR-14(Dog Park) $ 15,504 $ - phase 1 dog park Park Dedic. $ 2,000 $ -
Total $ 23,776 $ 5,295_
18 Millstream bk Expenses: Avail.Rev
$ - $ 3,024
18 Doq Park Donation Budget: 2016/2017/2018
pavers/treats $ 1,149
cash $ 10,000 $ 5,536
thru 6/30/18
2018 Capital Expenditures
Enterprise Capital Equipment Plan-Public Works
Adopted December 4,2017
#########$ Grants/ as of 6/30 2018
Project Project Purchase Replace Reserve Budget Transfers Spent Available
Department Account Code Number Equipment Year Year Balance 2018 2018 2018 Balance
1984/1005
2006/2008 2018/2020
Water- 601-49440-55CPW-1403 Truck(1/4) 2013 /2021 4,750.00 3,000.00 (7,750.00) -
601-49440-58C WT-1804 Fuel Tank new 2020 - 500.00 500.00
601-49440-52CENG-1503 Klinefelter Bathrooms new 2022 - - -
601-49440-52C PW-1411 PW Building Expansion new 2022 - 20,000.00 20,000.00
601-49440-30C WT-1805 Water Supply Plan 2017 2027 - - -
601-49440-30C WT-1805 Water Distribution System Model Study 2006 2021 - - -
601-49434-30C WT-1805 Wellhead Protection Plan 2010 2020 - - -
601-49490-582 WT-1705 Printer-UB 2016 2021 60.00 60.00 120.00
601-49490-58C WT-1401 Handheld Meter Programmer 2008 2017 11,250.00 500.00 11,750.00
601-49490-30C WT-1803 Comprehensive Rate Study 2015 2020 - - -
601-49435-53C WT-1712 Water Tower Maintenance 2014 2022 - 10,000.00 10,000.00
601-49410-22C WT-1402 Well#4/5 Roof Replacement 1995 est.2020 5,250.00 1,000.00 6,250.00
601-49420-58C WT-1403 WTP 1 Repairs ongoing ongoing 9,150.00 5,000.00 14,150.00
601-49421-58C WT-1403 WTP 2 Repairs ongoing ongoing 17,500.00 5,000.00 22,500.00
47,960.00 45,060.00 - (7,750.00) 85,270.00
1984/2005
2006/2008 2018/2020
Sewer- 602-49450-55CPW-1403 Truck(1/4) 2013 /2021 7,560.00 3,000.00 (7,856.95) 2,703.05
602-49450-58CWW-1804 Fuel Tank new 2020 - 500.00 500.00
602-49450-53CWW-1401 Sewer Lining on going ongoing 25,848.50 15,000.00 40,848.50
602-49450-52C PW-1411 PW Building Expansion new 2022 - - -
602-49450-52CENG-1503 Klinefelter Bathrooms new 2022 - - -
602-49450-30CWW-1408 Sewer Televising/Root Foaming ongoing ongoing 17,000.00 10,000.00 27,000.00
602-49450-30CWW-1805 Comprehensive Sewer Plan 2008/2009 2022 - - -
602-49490-30CWW-1803 Comprehensive Rate Study 2015 2020 - - -
602-49490-58]WW-1705 Printer-UB 2016 2021 60.00 60.00 120.00
602-49480-58CWW-1402 Sewer Sampler 2016 2021 7,000.00 500.00 7,500.00
602-49480-58CWW-1403 Pump Replacement-Main LS 35,000.00 20,000.00 55,000.00
602-49471-53CWW-1403 Submersible pumps-Ridgewood LS 14,000.00 - 14,000.00
602-49470-53CWW-1403 Submersible pumps-Baker St LS 9,200.00 2,300.00 11,500.00
602-49472-53CWW-1403 Submersible pumps-Northland LS 9,200.00 2,300.00 11,500.00
602-49473-53CWW-1403 Submersible pumps-CR121 LS 11,800.00 2,200.00 14,000.00
########t 55,860.00 - (7,856.95) 184,671.55
2018 Capital Expenditures
Enterprise Capital Improvement Plan-Public Works
Adopted December 4,2017
########## Grants/ as of 6/30 2018
Project Project begin complete Reserve Budget Transfers Spent Available
Department Account Code Number Equipment Year Year Balance 2018 2018 2018 Balance
Stormwater- 651-49490-581 55-1705 Printer-UB 2016 2021 60.00 60.00 120.00
651-49900-302 SS-1712 Update MS4 SWPPP/Permit Compliance - 1,000.00 1,000.00
651-49900-302 SS-1805 Pond Maintenance Schedule - - -
651-49900-53C SS-1404 Aerial Mapping 13,550.00 500.00 14,050.00
651-49900-53C SS-1405 Water Quality Improvements ongoing on going 69,190.20 2,000.00 ######### 61,078.25
651-49900-58C PW-1407 Street Sweeper 1997 2020 42,000.00 11,000.00 53,000.00
651-49900-51C SS-1406 Property Easements/Acquire ongoing ongoing 77,902.24 1,000.00 78,902.24
######### 15,560.00 - ######### 208,150.49
Refuse- 603-43230-581 RF-1705 Printer-UB 2016 2021 60.00 60.00 120.00
603-43230-58C PW-1425 Front End Loader(1/4) 2002/2014 2023/2029 5,692.62 1,000.00 6,692.62
5,752.62 1,060.00 - - 6,812.62
St.Lighting- 652-43160-53C SL-1410 Street Lighting ongoing ongoing 17,000.00 7,000.00 _ 24,000.00
17,000.00 7,000.00 - - 24,000.00
2018 Capital Expenditures
General Fund Capital Equipment Plan-Summary
Final adopted December 4,2017
As of June 30,2018
Available through 6/30 through 6/30
Project Budget Reserve Transferred/ Spent Budget Remaining
Department Account Code Equipment Balance Grant 2018 2018 2018 Balance
Election 101-41410-xxx Election Equipment 14,988.04 - - 2,500.00 17,488.04
Planning 101-41941-300 Comp Plan Update 4,915.04 - 325.50 2,500.00 7,089.54
Finance 101-41530-300 GASB Updates 5,200.00 - 1,800.00 2,600.00 6,000.00
Administration 490-41430-570 Administration Equipment 15,252.84 - - 3,050.00 18,302.84
Administration 490-41430-581 Computer Replacement 11,687.01 - 64.56 7,500.00 19,122.45
Administration 490-41430-582 Computer Software 6,174.68 - 6,400.00 750.00 524.68
Cable Access 108-41950-580 Cable Equipment 33,717.49 3,148.94 36,000.00 - 866.43
Total Administration CEP 91,935.10 3,148.94 44,590.06 18,900.00 69,393.98
Police-General 490-42120-580 Police Equipment 9,639.43 - - 3,380.00 13,019.43
Police-Communications 490-42151-580 Communication Equipment 26,743.28 - - 4,875.00 31,618.28
Police-Automotive 490-42152-550 Police Squads 21,709.36 - - 1,500.00 23,209.36
Police-Automotive 490-42152-580 Vehicle/Equipment 22,942.08 - 416.75 10,895.00 33,420.33
Police-Automotive 490-42152-581 Squad Laptops 0.95 - - 1,200.00 1,200.95
Emergency Services 490-42500-580 Emergency Services 9,912.61 - - 1,500.00 11,412.61
Total Police CEP 90,947.71 - 416.75 23,350.00 113,880.96
Streets 101-43120-530 Street Improvements 135,894.61 38,249.00 33,424.77 21,500.00 162,218.84
Streets 490-43120-550 Street Motor Vehicles 3,060.00 1,750.00 3,810.00 3,000.00 4,000.00
Streets 490-43120-580 Street Equipment 2,125.00 - - 500.00 2,625.00
Streets 490-43120-582 Street Software 3,440.00 - - 250.00 3,690.00
Streets 490-43120-530 Street Improvements 5,000.00 - - - 5,000.00
Street Sweeping 490-43220-580 Street Sweeping Equipment 11,250.00 - - 2,750.00 14,000.00
Snow Removal 490-43125-580 Snow Removal Equipment 25,177.68 - - 7,500.00 32,677.68
Maintenance 490-45201-520 Maintenance Cold Storage - - - - -
Maintenance 490-45201-580 Maintenance Shop Equipment 61,816.62 - - 5,000.00 66,816.62
Parks 490-45202-530 Parks Improvements 23,970.00 - - 3,400.00 27,370.00
Parks 490-45202-580 Parks Equipment 72,500.87 - - 17,270.00 89,770.87
Parks 490-45202-550 Parks Motor Vehicles 3,310.00 1,750.00 4,060.00 3,000.00 4,000.00
Total Public Works CEP 347,544.78 41,749.00 41,294.77 64,170.00 412,169.01
EDA Software 150-46500-582 Computer Software 1,898.58 - - 500.00 2,398.58
EDA Projects 250/150-46500-588 EDA Programs 136,713.66 (5,000.00) 15,049.81 56,100.00 202,863.47
Total EDA CIP 138,612.24 (5,000.00) 15,049.81 56,600.00 205,262.05
Total General Capital Improvements 669,039.83 39,897.94 101,351.39 163,020.00 800,706.00