HomeMy WebLinkAbout[04c] Financial Report 1111
Council Agenda Item 4 lc'
CITY OF ST.JOSH PH
•
MEETING DATE: January 16,2019
AGENDA ITEM: Financial Report—4th Quarter 2018 &December 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
December 31, 2018.
CASH POSITION:
- The market rate of return(ROR)is approximately 2.26%with an average maturity of 34 months.
The federal markets dipped the last quarter of 2018 after increases the first three quarters. 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 have 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 December,the Federal Open Market Committee [FOMC] increased the federal fund rates to
2.25 to 2.5%citing the labor market conditions continue to strengthen and the economic activity
has been rising at a strong rate.
- Interest earnings for 2018 amounts to a$24,773. 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 increased$361,994 over the year. The tax settlements
and state aids were received. Development fees such as building permit revenue are well above
budget.
- In October, staff was notified Morgan Stanley is discontinuing their government client division.
Our financial advisor,Rich Knowlton,took a new position at RBC Wealth Management. All,but
one CD was transferred from Morgan Stanley to RBC. The remaining CD cannot be transferred.
FUNDS REPORT:
- The General fund spent 96%of the 2018 expenditure budget and received 101%of the revenue
budget. Expenditures and revenues are mainly operational in nature. To note,building permit
revenue has exceeded budget by$146,238 the end of December.
- The Enterprise Funds represent ten months utility billing revenue collected while expenses
represent 12 months of activity. Overall, 97%of expenses have been incurred(less depreciation);
88%of the revenue budget has been received. Water expenses include final construction
payments for the water treatment plant 1 improvements.
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$364,697,including fees collected for a connection fee from three homeowners
that were sewer only(final partial payment),22 new homes and Oaks on 20th apartments. Also included
are partial WAC fees for the 24 College North and Country Manor projects.Water revenues represent
118%,expenses 154%of the budget at the end of December. The excess expenses are due to the
remaining construction costs for the water treatment plant 1.
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
$134,572 in 2018. Collections include fees for 22 single family homes, Oaks on 20th apartments, and a
partial payment for 24 College North. Sewer expenses are at 82%of the budget,while revenues are at
85%of the budget.
'/ t Sales Tax(fund 200): The sales tax fund has a cash balance of$821,311. The City anticipates
collecting$4,250,000 in sales tax revenue through 2018 ($3,372,754 original estimate); $4,171,200 was
collected to date(does not include receivable for Nov/Dec that will be received in early 2019).
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$575,078 for the projects approved by Council.
The Supreme court ruled on the case between the State of North Dakota and Wayfair, Inc. The court
stated states have the right to collect sales tax across state lines from online sales. This will have a
positive impact on sales tax collections. However, significant increases are not anticipated for our area
due to the bulk of the online sales come from companies with buildings in Minnesota. If they have
property in Minnesota,the companies are already collecting and submitting sales taxes in Minnesota.
CIP REPORTS:
- General capital equipment purchases include: Public Works truck replacements,mowers, skid
loader,used plow and computer replacements. Also, seal coating,crack filling and sewer main
televising maintenance has been completed. The police department took possession of the new
squad 704 as part of the 4-year lease rotation. The Comp Plan update was accepted by council on
Oct. 1St. Administration purchased forms software and updating some security features in the
computer programs. Administration also updated iPads also. The community center saw some
upgrades to open the gym to the public. Election equipment contracts with Stearns County were
paid for along with some election administration expenses.
- The Park Board completed the East Park master park plan 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.
- The EDA has been working with interested parties and the State to fund the Parkway Industrial
Park expansion.The City was awarded a$1.2M BDPI grant for infrastructure expenses.The
EDA recommended amendments to the TIF agreement for Bayou Blues to help construction get
on the way. In addition,the EDA completed a hotel study and heard inquiries for development
along the west of CSAH 2.
BUDGET/FISCAL IMPACT: Information Only
ATTACHMENTS: Request for Council Action—Quarterly and December Financial Reports
4th Quarter Reports:
Cash Position as of 12/31/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
December 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 4th quarter and December financial
reports.
City of St. Joseph 01/11/19 9:54 AM
Page 1
Cash Balances Only
Current Period:December 2018
MTD MTD Current
FUND Descr Account Begin Yr Debit Credit Balance
Last Dim 10100
General G 101-10100 $1,835,385.36 $1,119,227.44 $241,270.11 $1,892,116.55
Employee Retirement Reserve G 102-10100 $115,843.34 $0.00 $0.00 $122,343.34
Fire Fund G 105-10100 $521,806.17 $5,216.30 $17,956.49 $595,901.85
Cable Access Fee G 108-10100 $33,717.49 $586.94 $0.00 $5,119.57
Economic Development G 150-10100 $27,549.20 $52,917.07 $11,514.41 $47,722.73
TIF 3-1 CMCU G 152-10100 $2,759.65 $21,643.32 $24,971.71 $214.86
TIF 4-1 Fortitude Senior Apts G 153-10100 $2,136.02 $17,538.73 $15,780.91 $3,679.20
TIF 2-1 Millstream G 157-10100 $23,356.90 $21,421.45 $19,231.04 $25,672.98
TIF 2-2 Meat Market G 158-10100 $332.52 $2,149.84 $2,041.50 $497.76
TIF 2-3 Bayou Blues/Alley Flat G 159-10100 $119.95 $2,623.59 $21.23 $27.50
State Collected Sales Tax G 200-10100 $961,315.04 $41,909.97 $37,701.79 $821,311.31
Park Dedication G 205-10100 $121,019.37 $35,815.49 $3,528.09 $109,195.24
Charitable Gambling G 215-10100 $2,084.77 $4.77 $0.00 $2,097.44
Lodging Tax G 220-10100 $20,177.02 $844.44 $0.00 $30,385.84
DEED CDAP Grant G 225-10100 $11,126.43 $9,908.72 $0.00 $34,999.59
Revolving Loan Fund G 250-10100 $205,554.66 $482.59 $0.00 $211,822.18
2016 CIP Bonds[govt center] G 301-10100 $17,890.40 $125,411.61 $0.00 $49,310.56
2017A CIP Bonds[Gov Center] G 303-10100 $55,005.64 $3,301.90 $0.00 $104,369.77
2016 Street Impr[Field St] G 304-10100 $190,459.50 $22,517.98 $3,116.25 $65,441.82
2017B Impr Bonds[CBD Alleys G 305-10100 $44,961.76 $36,214.74 $0.00 $53,123.85
2018 Equip Certificates G 306-10100 $0.00 $249.13 $0.00 $450.07
2010B Refundin[Hill/Clover] G 333-10100 $108,556.26 $32,995.65 $0.00 $132,491.30
2011A CO Refund[Interior St] G 338-10100 $100,177.59 $60,230.67 $0.00 $81,830.19
2010B Street Impr[16th Ave] G 345-10100 $169,832.48 $24,404.31 $0.00 $150,583.82
2011A Pumper Truck Certificat G 346-10100 $27.97 $9,650.66 $23.77 $6.32
2013 Street Improve Bonds G 348-10100 $110,704.94 $8,883.38 $0.00 $86,949.16
2014 Street Impr[ParkTerrace G 350-10100 $249,175.21 $45,201.72 $0.00 $205,455.62
2015 Street[Clinton/Northland] G 351-10100 $146,996.79 $41,459.67 $0.00 $180,358.30
2015 Equipment Certificates G 352-10100 $1,527.89 $70,138.47 $0.00 $115,021.16
2015 Abatement Bonds[Kenne G 353-10100 $20,204.35 $265.29 $0.00 $29,085.34
Debt Service Relief G 390-10100 $392,280.94 $15,422.59 $0.00 $289,679.17
Community Center phase I G 402-10100 $1,884.67 $5.63 $0.00 $2,474.85
2018 Equip Certificates G 406-10100 $0.00 $0.00 $10,486.78 $71,469.43
Capital Outlay G 490-10100 $347,121.83 $38,035.39 $0.00 $401,246.16
WAC Fund G 501-10100 $241,291.01 $128,581.86 $200,000.00 $409,128.81
SAC Fund G 502-10100 $6,318.77 $58,257.52 $55,000.00 $86,405.42
Water Fund G 601-10100 $670,381.85 $356,154.53 $43,410.87 $583,017.31
Sewer Fund G 602-10100 $2,345.84 $252,564.03 $27,416.43 $236,280.45
Refuse Collection G 603-10100 $257,764.40 $35,005.16 $23,469.29 $244,993.93
Storm Water Utility G 651-10100 $280,964.44 $32,204.03 $22,506.53 $251,988.29
Street Light Utility G 652-10100 $23,576.76 $10,265.40 $5,176.21 $35,414.32
Last Dim 10100 $7,323,735.18 $2,739,711.98 $764,623.41 $7,769,683.36
Last Dim 10200
General G 101-10200 $275.00 $0.00 $50.00 $225.00
Last Dim 10200 $275.00 $0.00 $50.00 $225.00
$7,324,010.18 $2,739,711.98 $764,673.41 $7,769,908.36
Cash and Investment Holdings
877,230, 11%
4,117,163, 53%_\
1,878,386, 24%
■Checking
■Money Market Savings
Bank CDs
■ Brokered Money Market
■Government Securities
Brokered CDs
596,300, 8%
3,099 , 0%
297,504,4%
City of St.Joseph, Minnesota
Cash Balances by Fund/Remaining Budget
As of 12/31/18
FUND CASH BALANCE 18 EXP BUD 18 SPENT 18 LEFT 18 BUD REV 18 RECEIVED 18 LEFT
General Fund $ 2,019,579 $ 2,969,350 $ 2,847,337 $ 122,013 $ 2,975,850 $ 3,002,895 $ (27,045)
Fire Fund 595,902 346,465 224,015 $ 122,450 342,995 350,393 $ (7,398)
EDA Fund 47,723 119,025 85,819 $ 33,206 119,025 104,568 $ 14,457
TIF Funds 30,092 40,680 114,563 $ (73,883) - 118,788 $ (118,788)
State Collected Sales Tax 821,311 1,110,000 575,078 $ 534,922 425,000 350,201 $ 74,799
Park Dedication 109,195 143,190 59,949 $ 83,241 35,240 47,762 $ (12,522)
Charitable Gambling 2,097 4,500 - $ 4,500 - 8 $ (8)
Lodging Tax 30,386 - 5,800 $ (5,800) - 15,431 $ (15,431)
DEED CDAP Grant 35,000 - 1,834 $ (1,834) - 25,688 $ (25,688)
Revolving Loan Fund 211,822 - 35 $ (35) - 6,203 $ (6,203)
Debt Funds 1,544,156 1,586,010 1,688,257 $ (102,247) 1,339,450 1,483,394 $ (143,944)
Capital Project Funds 475,190 77,320 274,453 $ (197,133) 77,320 350,069 $ (272,749)
Water Access Fund 409,129 200,000 200,000 $ - - 367,408 $ (367,408)
Sewer Access Fund 86,405 96,090 55,000 $ 41,090 162,500 135,047 $ 27,453
Water Fund 583,017 1,612,550 1,362,665 $ 249,885 1,281,170 1,150,206 $ 130,964
Sewer Fund 236,280 1,812,260 1,094,459 $ 717,801 1,421,370 1,211,282 $ 210,088
Refuse/Compost Fund 244,994 293,185 284,902 $ 8,283 280,200 240,574 $ 39,626
Storm Sewer 251,988 256,345 129,174 $ 127,171 60,940 72,652 $ (11,712)
Street Light Utility 35,414 80,975 66,161 $ 14,814 80,815 72,128 $ 8,688
TOTALS $ 7,769,683 $ 9,069,501 $ 9,104,697
12/31/17 Cash Balance $ 7,407,689 10.25 months of cash balance
2018 cash increase 361,994
General & Fire Budget to Actual Expenditures & Revenues
$3,500,000
$3,002,895
$3,000,000 $2,969,350 $2,975,850
$2,847,337
$2,500,000
$2,000,000 ._
Exp Budget
Exp Actual
$1,500,000 - ______ J Rev Budget
Id Rev Actual
$1,000,000
$500,000
$346,465 $342,995 $350,393
$130,936
5
General Fund Fire Fund
96%Spent 101%Received 65%Spent 102%Received
Enterprise Funds Activity
$66,161
Street Light
$72,128
Storm Water $82,642
$31,749
Refuse =1111
$216,642
$162,852 o Expense
Y Revenue
Sewer $734,480
$741,568
Water $620,258
$598,976
$- $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 $1,600,000
Storm Water Refuse Sewer Water Street Lights
%Revenue to Expenses 56% 84% 111% 84% 109%
Utilities represents 10 months revenue collected with 12 months expensed.
City of St.Joseph
Quarterly Water Fund Analysis
As of December 31,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: 3 sewer only SF home as required by Council
Interest Earnings 4,873.32 24 single family homes(2 were prepaid hook up fees)
Ad Valorem Taxes 22,110.00 Partial 24 College North
Water Usage Charge 569,741.19 Partial Country Manor
Water Fixed Charge 278,926.86 Oaks on 20th Apartments
Penalties/Other Usage Fees 6,424.42
WAC/Trunk Fees 364,696.90
Antenna Lease Revenue 37,620.36
Water Meters 22,345.00
Bulk Water Sales 3,876.29
Transfers from other Funds 207,000.00
Total Revenue 1,517,614.34 118.46% budget collected
2018 Revenue Budget 1,281,170.00 (includes fund 501)
Year to Date Expenses by Department:
Debt Payments (694,215.56)
Transfers to Other Funds (206,500.00)
Power and Pumping (6,230.99)
Water Treatment Plant 1 (279,323.14) WTP1 expenses include contract to refurbish
Water Treatment Plant 2 (80,345.85)
Distribution (18,872.06)
Wellhead Protection -
Water Tower (6,092.32)
Water Maintenance (233,100.47)
Water Administration (37,984.68)
Total Expenses (1,562,665.07) 154.33% budget expensed
2018 Expense Budget (1,012,550.00) (excludes depreciation,includes 501)
Fund Summary as of December 31,2018:
Water Fund Cash Balance-Fund 601+501-unaudited $ 992,146.12
Fund 501 $ 409,128.81
Fund 601 $ 583,017.31
The balances represent the cash balance as of 12/31/18
City of St.Joseph
Quarterly Sewer Fund Analysis
As of December 31,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: 24 single family homes(2 were prepaid hook up fees)
Interest Earnings 5,167.00 Partial 24 College North
Sewer Usage Charge 689,070.81 Oaks on 20th Apartments
Sewer Fixed Charge 454,033.66
Penalties/Other Usage Fees 7,755.68
SAC/Trunk Fees 134,571.90
RV Dump Donations 729.75
Transfers from other Funds 55,000.00
Total Revenue 1,346,328.80 85.00% budget collected
2018 Revenue Budget 1,583,870.00 (includes fund 501)
Year to Date Expenses by Department:
Debt Payments (187,436.00)
Transfers to Other Funds (68,500.00)
Sewer Maintenance (140,676.46)
Baker Street Lift Station (3,728.19)
Ridgewood Lift Station (2,240.77)
Northland Lift Station (1,109.64)
CR121 Lift Station (44,068.83)
Main Lift Station (659,203.77)
Sewer Administration (42,495.20)
Total Expenses (1,149,458.86) 81.62% budget expensed
2018 Expense Budget (1,408,350.00) (excludes depreciation,includes fund
Fund Summary as of December 31,2018:
Sewer Fund Cash Balance-Fund 602+502-unaudited $ 322,685.87
Fund 502 $ 86,405.42
Fund 602 $ 236,280.45
The balances represent the cash balance as of 12/31/18.
Sales Tax Summary
Summary of Committed&Available Funds
As of December 31,2018
Sales Tax Receipts (4,171,200.44)
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
(2,255,080.97)
State Bonding
Project Federal/APO/ Fund 200 YTD Balance to be
Project Name/Type Year Project Cost Other Funding Expended 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 T'i 2010.2013 446;513.37 . 446,51337 -
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
W.. .. ... . ..
obegon Trail Extension to St.Cloud 2017 : 200,082.00' '' 200,082.00
Trail Extension Phase 11/11I 2017 1,713,400.00 (650,59400) 466,360.48 596,445 52 $650,594 federalfunding
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 WetterlingRecreation Center 2018 10,000,000.00
(6,000,000.00) 17,510.61 3,982,489.39 $4Mdanrt6onsest.;$2M stare bonding request
Field Street-sales tax portion only 2017 420,00000 20,000.00 400,000.00 cover bond payments due to deferred assessments
Pedestrian Bridge-Study 2016-2017 45,382.38 (32,000.00) 13,382.38 $32KAPO ftnded
Totals 17,525,637.28 (6,722,594.00) 5,266,008.60 5,482,311.41
Less:Bonded Projects (3,982,489 39)
Committed-to be funded 1,499,822.02
Committed-to be funded-2018 886,445.52
Balance Fund 200 as of December 31,2018,unaudited (7,521,089 57)
anticipated remaining 2018 sales tax revenues to collect 74,799.14
Committed-to be funded (886,445.52):
Anticipated 2018 December Balance including funding commitments (8,332,735.95)
Average Annual Revenue(3 yr) 431,122.00
Average Bond Payment Field St(5 yr) (20,000.00)
Average Bond Payment Colts Academy(5 yr) (160,000.00)
uncommitted annually(5 yr Average) 251,122.00
MSAS/SA Bonds
Projects that have been discussed for Soles Project Donations/ YTD Balance to be
Tax Funding ear Project Cost State Bonding Expended Funded
Aquatics Center 6,500,000 (2,000,110) 71,623.50 4,428,267 $2M donations est.
Pedestrian Crossing 1,000,000 (1,500,000) - 1,500,000 $1.5M State Bonding request
Amphitheater 150,000 (50,000) - 100,000 $50K donations est.
East Park Development' 557,000 300,000) - 257,000 $300K State Bonding request
10,207,000 (3,850,110) 71,624 6,285,267
Maximum Funding Available
2006-2018 Legislation 4,250,000
2019-2038 Legislation 11,000,000
15,250,000
City of St.Joseph,Minnesota
Cash Position
As of 12/31/18
Sentry Bank Maturity Date Interest Current Balance #Securities %of Total
Checking Account(Reconciled) N/A 0.15% $ 221,675 N/A
Money Market Savings N/A 1.00% 823,982 N/A
Jacob Wetterling Rec Center Savings N/A 0.15% 2,647 N/A
Bank Certificates of Deposit N/A - 0
averages N/A 1.00%
Total SB $ 1,048,305 13%
Central MN Credit Union
Share Savings Account N/A 0.00% $ 5 N/A
Business Advantage Checking N/A 1.41% 655,555 N/A
Money Market Savings N/A 0.40% 59 N/A
averages N/A 1.41%
Total CMCU $ 655,619 8%
PMA 4M-US Bank
4M Money Market Savings N/A 2.09% $ 455 N/A
4MP Money Market Savings N/A 2.15% $ 1,051,238 N/A
Bank Certificates of Deposit Tiered 7-13 months 2.44% avg 596,300 3
averages 9 months 2.23%
Total 4M $ 1,647,993 21%
Total Deposits $ 3,351,917
Morgan Stanley
Brokered Money Market Savings N/A 0.30% $ - N/A
Brokered Certificates of Deposit 34 months 1.65% avg 189,901 1
averages 34 months 1.65%
Total MS $ 189,901 2%
RBC Wealth Management
Brokered Money Market Savings N/A 1.32% $ 3,099 N/A
Government Securities/Notes 73 months 2.00% avg 297,504 1
Brokered Certificates of Deposit Tiered 3-58 months 2.30% avg 3,927,263 20
averages 34 months 2.29%
Total RBC $ 4,227,866 54%
Total Investments $ 4,417,767
2018 YTD
Total Deposits and Investments $ 7,769,683 Interest Earned
Average Interest APY 34 months 2.26% $24,773
Petty Cash
Administration N/A N/A $ 200
Community Center N/A N/A 25
Total Petty Cash $ 225
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 $ 3,099 0.04% NIA
Brokered Certificates of Deposit 5 4,117,163 52.99% 2.75 years
Government Bonds/Notes $ 297,504 3.83% N/A
Foreign Currency Risk: The City only invests in USA and USA territories.
City of St. Joseph 01/11/19 9:58 AM
Page 1
Council Month End Revenue Summary
Current Period:December 2018
2018 December 2018
FUND FUND Descr YTD Budget 2018 Amt YTD Amt
101 General $2,961,415.00 $1,118,473.45 $2,989,646.01
102 Employee Retirement Reserve $6,500.00 $0.00 $6,500.00
105 Fire Fund $342,995.00 $5,195.58 $350,393.44
108 Cable Access Fee $7,935.00 $586.94 $6,749.30
150 Economic Development $119,025.00 $47,417.07 $104,568.35
152 TIF 3-1 CMCU $0.00 $21,643.32 $43,314.01
153 TIF 4-1 Fortitude Senior Apts $0.00 $17,538.73 $35,101.79
157 TIF 2-1 Millstream $0.00 $21,421.45 $35,858.55
158 TIF 2-2 Meat Market $0.00 $2,149.84 $4,341.54
159 TIF 2-3 Bayou Blues/Alley Flat $0.00 $23.59 $171.84
200 State Collected Sales Tax $425,000.00 $41,909.97 $350,200.86
205 Park Dedication $35,240.00 $35,815.49 $47,762.17
215 Charitable Gambling $0.00 $4.77 $7.54
220 Lodging Tax $0.00 $844.44 $15,431.42
225 DEED CDAP Grant $0.00 $9,908.72 $25,688.16
250 Revolving Loan Fund $0.00 $482.59 $6,202.52
301 2016 CIP Bonds[govt center] $270,005.00 $125,411.61 $303,826.35
303 2017A CIP Bonds[Gov Center] $55,500.00 $3,301.90 $108,942.08
304 2016 Street Impr[Field St] $55,290.00 $22,517.98 $47,806.42
305 20176 Impr Bonds[CBD Alleys] $48,085.00 $36,214.74 $54,770.41
306 2018 Equip Certificates $0.00 $249.13 $17,484.67
333 2010B Refundin[Hill/Clover] $178,360.00 $32,995.65 $167,828.07
338 2011A CO Refund[Interior St] $118,950.00 $60,230.67 $122,941.49
345 2010B Street Impr[16th Ave] $41,120.00 $24,404.31 $43,007.74
346 2011A Pumper Truck Certificate $43,660.00 $9,626.89 $43,609.97
348 2013 Street Improve Bonds $20,585.00 $8,883.38 $18,775.90
350 2014 Street Impr[ParkTerrace] $101,395.00 $45,201.72 $119,722.95
351 2015 Street[Clinton/Northland] $44,160.00 $41,459.67 $103,585.31
352 2015 Equipment Certificates $37,005.00 $70,138.47 $149,957.47
353 2015 Abatement Bonds[Kennedy] $160,185.00 $265.29 $160,998.25
390 Debt Service Relief $28,000.00 $15,422.59 $20,136.47
402 Community Center phase I $0.00 $5.63 $588.36
406 2018 Equip Certificates $0.00 $0.00 $271,460.40
490 Capital Outlay $77,320.00 $38,035.39 $78,020.56
501 WAC Fund $0.00 $128,581.86 $367,408.06
502 SAC Fund $162,500.00 $58,257.52 $135,047.24
601 Water Fund $1,281,170.00 $346,753.73 $1,150,206.28
602 Sewer Fund $1,421,370.00 $252,546.09 $1,211,281.56
603 Refuse Collection $280,200.00 $33,975.34 $240,574.12
651 Storm Water Utility $60,940.00 $32,204.03 $72,652.36
652 Street Light Utility $80,815.00 $10,263.70 $72,127.50
City of St. Joseph 01/11/19 9:58 AM
Page 2
Council Month End Revenue Summary
Current Period:December 2018
2018 December 2018
FUND FUND Descr YTD Budget 2018 Amt YTD Amt
$8,464,725.00 $2,720,363.24 $9,104,697.49
City of St. Joseph 01/11/19 9:57 AM
Page 1
Council Month End Revenue -General Fund
Current Period:December 2018
2018 December 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 $536,070.43 $1,145,464.65
101 General Special Levy-City St.Joe $0.00 $0.00 $0.00
101 General State Sales Tax $0.00 -$12.80 $26.70
101 General Gravel Tax $0.00 $0.00 $0.00
101 General Solar Production Tax $0.00 $0.00 $0.00
101 General Gas Franchise $31,210.00 $0.00 $21,868.62
101 General Electric Franchise $58,335.00 $1,957.40 $50,035.33
101 General Licenses&Permits $10,000.00 $0.00 $10,200.00
101 General Beer $1,950.00 $0.00 $3,205.44
101 General Liquor $29,135.00 $100.00 $28,166.24
101 General Outdoor Liquor Permit $1,775.00 $0.00 $3,130.00
101 General Gambling Permits $375.00 $0.00 $470.00
101 General Amusement/Hunt/Peddler/Golf $1,400.00 $0.00 $1,375.00
101 General Excavation Permit $500.00 $0.00 $550.00
101 General Cigarette License $675.00 $0.00 $662.50
101 General Cable Franchise Fee $34,000.00 $1,205.77 $27,470.30
101 General Building Permits $115,000.00 $24,824.05 $261,237.56
101 General Animal License $3,400.00 $30.00 $3,065.00
101 General Rental Housing Registration $30,305.00 $1,804.20 $34,565.03
101 General Federal Grants-Other $12,000.00 $4,143.76 $6,017.41
101 General State Grants and Aids $1,100.00 $1,073.70 $1,153.40
101 General Local Government Aid $989,464.00 $494,732.00 $989,464.00
101 General PERA Rate Increase Aid $1,541.00 $770.50 $1,541.00
101 General Police Training Reim $3,500.00 $0.00 $11,224.02
101 General State Municipal Funds Aid $50,000.00 $0.00 $56,098.00
101 General State Police Aid $62,000.00 $0.00 $74,527.32
101 General Other Governmental Unit $10,000.00 $0.00 $10,000.00
101 General County Grants-Road Maint. $6,500.00 $16,424.37 $16,424.37
101 General Zoning and Subdivision Fee $5,000.00 $0.00 $7,175.00
101 General Land Use Deposit Fee $4,000.00 $10,000.00 $17,850.00
101 General Sale of Maps and Publications $50.00 $1.50 $26.95
101 General Assessments Search $4,000.00 $630.00 $6,750.00
101 General Special Hearing $5,500.00 $450.00 $3,050.00
101 General Administration Reimb $12,745.00 $0.00 $248.00
101 General Weed Cutting $500.00 $0.00 $400.00
101 General Admission Fee $1,000.00 $9.00 $33.00
101 General Shelter/Room Rental Fees $7,500.00 $350.00 $9,880.00
101 General Ball Field Donation $100.00 $0.00 $0.00
101 General Schneider Field Rental $1,500.00 $0.00 $1,325.00
101 General Rents and Royalties $53,450.00 $5,089.40 $61,072.80
City of St. Joseph 01/11/19 9:58 AM
Page 2
Council Month End Revenue -General Fund
Current Period:December 2018
2018 December 2018
FUND FUND Descr SOURCE Descr YTD Budget 2018 Amt YTD Amt
101 General Kennel Fees $500.00 $0.00 $117.00
101 General County Fines $40,000.00 $2,288.54 $27,061.12
101 General Policy Fines $15,000.00 $3,136.68 $26,308.78
101 General Accident Report Fee $1,200.00 $133.50 $1,699.25
101 General Seized Property $500.00 $0.00 $2,268.05
101 General Special Assessments $3,000.00 $1,829.28 $5,793.23
101 General Interest Earnings $20,000.00 $3,824.36 $3,459.80
101 General Interest Charges $200.00 $0.00 $21.33
101 General Co-op Dividend-LMCIT $14,000.00 $3,828.00 $4,022.18
101 General Water Tower Antenna Lease $3,930.00 $1,169.42 $9,007.47
101 General Advertising $1,200.00 $0.00 $1,000.00
101 General Contributions-General $500.00 $0.00 $5,896.00
101 General Contributions-Parks $500.00 $0.00 $411.74
101 General Surplus Property $0.00 $0.00 $0.00
101 General Reimbursement $28,715.00 $0.00 $29,798.50
101 General Insurance Recovery $0.00 $0.00 $4,418.53
101 General Transfers from Other Funds $0.00 $2,610.39 $2,610.39
FUND 101 General $2,961,415.00 $1,118,473.45 $2,989,646.01
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 $586.94 $6,749.30
108 Cable Access Fee Transfers from Other Funds $0.00 $0.00 $0.00
FUND 108 Cable Access Fee $7,935.00 $586.94 $6,749.30
FUND 150 Economic Development
150 Economic Development Current Ad Valorem Taxes $114,325.00 $47,391.24 $101,257.39
150 Economic Development Federal Grants-Other $0.00 $0.00 $0.00
150 Economic Development TIF/MIF Deposit $3,600.00 $0.00 $1,500.00
150 Economic Development Tax Abatement Reimbursement $0.00 $0.00 $2,017.00
150 Economic Development Interest Earnings $1,100.00 $25.83 -$206.04
150 Economic Development Transfers from Other Funds $0.00 $0.00 $0.00
FUND 150 Economic Development $119,025.00 $47,417.07 $104,568.35
FUND 490 Capital Outlay
490 Capital Outlay Current Ad Valorem Taxes $77,320.00 $32,035.39 $68,520.56
490 Capital Outlay Federal Grants-Other $0.00 $0.00 $0.00
490 Capital Outlay Surplus Property $0.00 $6,000.00 $9,500.00
FUND 490 Capital Outlay $77,320.00 $38,035.39 $78,020.56
City of St. Joseph 01/11/19 9:58 AM
Page 3
Council Month End Revenue -General Fund
Current Period:December 2018
2018 December 2018
FUND FUND Descr SOURCE Descr YTD Budget 2018 Amt YTD Amt
$3,172,195.00 $1,204,512.85 $3,185,484.22
City of St. Joseph 01/11/19 9:57 AM
Page 1
Council Month End Revenue -Enterprise Funds
Current Period:December 2018
FUND 2018 December 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 $553.91 $8,008.78
601 Water Fund General Oblig. Bond Proceeds $0.00 $0.00 $0.00
601 Water Fund Transfers from Other Funds $207,000.00 $207,000.00 $207,000.00
601 Water Fund Contributed Revenue $0.00 $0.00 $0.00
601 Water Fund MDS Test Fee $12,250.00 $1,442.18 $9,845.97
601 Water Fund Current Ad Valorem Taxes $22,500.00 $10,447.08 $22,110.00
601 Water Fund Water Meter $5,000.00 $4,745.00 $22,345.00
601 Water Fund Connection/Reconnection fees $0.00 $0.00 $0.00
601 Water Fund Undesignated Funds $0.00 -$6,603.54 -$8,662.50
601 Water Fund Bulk Water $2,500.00 $64.50 $3,876.29
601 Water Fund State Grants and Aids $0.00 $0.00 -$48.00
601 Water Fund Water Fixed Charge $319,230.00 $40,971.37 $278,926.86
601 Water Fund State Sales Tax $0.00 $480.48 -$2,341.70
601 Water Fund Usage Rate $635,545.00 $75,458.40 $569,741.19
601 Water Fund Special Assessments $400.00 $187.95 -$516.13
601 Water Fund Interest Earnings $33,250.00 $1,481.52 $2,162.16
601 Water Fund Amortization of Bond Premium $0.00 $0.00 $0.00
601 Water Fund Water Tower Antenna Lease $35,385.00 $10,524.88 $37,620.36
601 Water Fund Surplus Property $0.00 $0.00 $0.00
601 Water Fund Reimbursement $0.00 $0.00 $138.00
FUND 601 Water Fund $1,281,170.00 $346,753.73 $1,150,206.28
FUND 602 Sewer Fund
602 Sewer Fund Penalties and Forfeited Disc $7,500.00 $525.60 $7,664.44
602 Sewer Fund Other Governmental Unit $0.00 $0.00 $0.00
602 Sewer Fund Special Assessments $400.00 $68.34 $130.24
602 Sewer Fund Interest Earnings $15,000.00 $3,147.00 $4,691.66
602 Sewer Fund Amortization of Bond Premium $0.00 $0.00 $0.00
602 Sewer Fund Contributions-General $0.00 $0.00 $729.75
602 Sewer Fund Surplus Property $0.00 $0.00 $0.00
602 Sewer Fund Reimbursement $4,000.00 $0.00 $0.00
602 Sewer Fund State Grants and Aids $0.00 $0.00 -$39.00
602 Sewer Fund Contributed Revenue $0.00 $0.00 $0.00
602 Sewer Fund Sewer Fixed Charge $541,935.00 $74,287.21 $454,033.66
602 Sewer Fund Transfers from Other Funds $0.00 $55,000.00 $55,000.00
602 Sewer Fund Sanitary Sewer Use Service $852,535.00 $119,517.94 $689,070.81
FUND 602 Sewer Fund $1,421,370.00 $252,546.09 $1,211,281.56
FUND 603 Refuse Collection
603 Refuse Collect Penalties and Forfeifted Disc $5,700.00 $315.04 $3,467.10
603 Refuse Collect Contributed Revenue $0.00 $0.00 $0.00
603 Refuse Collect Reimbursement $1,850.00 $0.00 $1,608.29
603 Refuse Collect Contributions-General $0.00 $0.00 $0.00
603 Refuse Collect Special Assessments $200.00 $64.93 $77.33
603 Refuse Collect Refuse Collection Charges $269,450.00 $31,065.14 $210,962.17
603 Refuse Collect State Grants and Aids $0.00 $0.00 -$5.00
603 Refuse Collect Licenses&Permits $0.00 $0.00 $24,880.60
603 Refuse Collect State Sales Tax $0.00 $1,984.35 -$1,332.23
603 Refuse Collect Interest Earnings $3,000.00 $545.88 $915.86
FUND 603 Refuse Collection $280,200.00 $33,975.34 $240,574.12
City of St. Joseph 01/11/19 9:57 AM
Page 2
Council Month End Revenue -Enterprise Funds
Current Period:December 2018
FUND 2018 December 2018
FUND Descr SOURCE Descr YTD Budget 2018 Amt YTD Amt
FUND 651 Storm Water Utility
651 Storm Water State Grants and Aids $0.00 $0.00 -$10.00
651 Storm Water Storm Water Develop Fee $4,000.00 $23,346.20 $26,044.20
651 Storm Water Storm Water Use Service $51,920.00 $6,809.02 $45,157.17
651 Storm Water Penalties and Forfeifted Disc $2,120.00 $48.66 $648.34
651 Storm Water Contributed Revenue $0.00 $0.00 $0.00
651 Storm Water Interest Earnings $2,500.00 $577.10 $782.55
651 Storm Water Other Grants/Aids $0.00 $0.00 $0.00
651 Storm Water Special Assessments $400.00 $1,423.05 $30.10
FUND 651 Storm Water Utility $60,940.00 $32,204.03 $72,652.36
FUND 652 Street Light Utility
652 Street Light U Penalties and Forfeited Disc $1,000.00 $53.81 $632.09
652 Street Light U State Grants and Aids $0.00 $0.00 -$2.00
652 Street Light U Other Grants/Aids $0.00 $0.00 $571.00
652 Street Light U Special Assessments $50.00 $6.84 $8.86
652 Street Light U Interest Earnings $400.00 $67.55 $448.83
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 $10,135.50 $63,468.72
FUND 652 Street Light Utility $80,815.00 $10,263.70 $72,127.50
$3,124,495.00 $675,742.89 $2,746,841.82
City of St. Joseph 01/11/19 9:56 AM
Page 1
Council Month End Expenditure -Summary
Current Period:December 2018
2018 December 2018
Description YTD Budget 2018 Amt YTD Amt
General $2,961,415.00 $219,575.22 $2,811,337.26
Employee Retirement Reserve $0.00 $0.00 $0.00
Fire Fund $346,465.00 $17,935.77 $224,015.05
Cable Access Fee $7,935.00 $0.00 $36,000.00
Economic Development $119,025.00 $8,914.41 $85,818.92
TIF 3-1 CMCU $795.00 $19,471.71 $40,362.76
TIF 4-1 Fortitude Senior Apts $0.00 $15,780.91 $33,561.15
TIF 2-1 Millstream $34,545.00 $19,231.04 $33,596.88
TIF 2-2 Meat Market $4,545.00 $2,041.50 $4,177.66
TIF 2-3 Bayou Blues/Alley Flat $795.00 $21.23 $2,864.29
State Collected Sales Tax $1,110,000.00 $37,701.79 $575,077.83
Park Dedication $143,190.00 $3,528.09 $59,948.59
Charitable Gambling $4,500.00 $0.00 $0.00
Lodging Tax $0.00 $0.00 $5,800.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 $273,242.50
2017A CIP Bonds[Gov Center] $55,070.00 $0.00 $59,471.45
2016 Street Impr[Field St] $63,950.00 $3,116.25 $91,995.96
2017B Impr Bonds[CBD Alleys] $46,745.00 $0.00 $46,644.38
2018 Equip Certificates $0.00 $0.00 $17,034.60
2010B Refundin[Hill/Clover] $144,350.00 $0.00 $144,248.00
2011A CO Refund[Interior St] $141,730.00 $0.00 $142,125.00
2009B GO CIP Bonds $62,745.00 $5,212.66 $67,462.66
2010B Street Impr[16th Ave] $62,755.00 $0.00 $62,655.00
2011A Pumper Truck Certificate $43,660.00 $0.00 $43,560.00
2011A GO CIP Bonds[roof/gar] $21,820.00 $3,687.57 $86,157.57
2013 Street Improve Bonds $42,870.00 $0.00 $42,770.00
2013 Equipment Certificates $61,300.00 $2,610.39 $63,810.39
2014 Street Impr[ParkTerrace] $164,535.00 $0.00 $164,435.00
2015 Street[Clinton/Northland] $71,050.00 $0.00 $70,950.00
2015 Equipment Certificates $36,850.00 $0.00 $36,750.00
2015 Abatement Bonds[Kenned $152,235.00 $0.00 $152,135.00
Debt Service Relief $141,000.00 $0.00 $122,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 $40,168.73 $52,296.16
2018 Equip Certificates $0.00 $10,486.78 $199,990.97
Capital Outlay $77,320.00 $0.00 $22,166.02
WAC Fund $200,000.00 $200,000.00 $200,000.00
SAC Fund $96,090.00 $55,000.00 $55,000.00
City of St. Joseph 01/11/19 9:56 AM
Page 2
Council Month End Expenditure -Summary
Current Period:December 2018
2018 December 2018
Description YTD Budget 2018 Amt YTD Amt
Water Fund $1,612,550.00 $34,010.07 $1,362,665.07
Sewer Fund $1,812,260.00 $27,398.49 $1,094,458.86
Refuse Collection $293,185.00 $22,439.47 $284,902.15
Storm Water Utility $256,345.00 $22,506.53 $129,174.28
Street Light Utility $80,975.00 $5,174.51 $66,160.62
$10,747,945.00 $776,013.12 $9,069,500.96
City of St. Joseph 01/11/19 9:55 AM
Page 1
Council Month End Expenditure -General Fund
Current Period:December 2018
2018 December 2018
Description DEPART Descr YTD Budget 2018 Amt YTD Amt
FUND 101 General
General Council $64,605.00 $3,307.38 $57,462.80
General Legislative Committees $5,945.00 $420.00 $3,648.93
General Ordinance&Proceedings $2,600.00 $191.41 $2,327.78
General Mayor $11,845.00 $1,569.62 $10,329.63
General Elections $2,500.00 $4,009.60 $12,188.29
General General Adminstration $269,605.00 $22,092.90 $252,236.68
General Finance $139,945.00 $9,619.54 $127,690.71
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 $288.75 $19,523.12
General Planning and Zoning $76,065.00 $6,166.55 $92,006.04
General General Government $38,960.00 $2,871.81 $36,116.21
General City Offices $38,510.00 $2,060.30 $44,779.03
General Cable Access $6,390.00 $693.40 $4,926.43
General Crime Control&Investigation $1,127,945.00 $97,400.53 $994,288.45
General Police Training $9,545.00 $0.00 $7,968.11
General Communication Service $12,780.00 $942.29 $18,037.13
General Automotive Services $57,360.00 $2,796.64 $46,594.96
General Building Inspec.Admistration $95,200.00 $7,500.00 $86,667.79
General Emergency Management $975.00 $7.78 $1,708.98
General Animal Control $815.00 $50.00 $453.99
General Street Maintanence $297,290.00 $16,827.68 $283,278.81
General Ice&Snow Removal $120,235.00 $3,343.99 $84,735.58
General Engineering Fee $35,000.00 $5,082.83 $75,648.94
General Street Cleaning $14,095.00 $0.00 $8,438.18
General Skate Park and Ice Rink $5,410.00 $141.32 $4,632.23
General Ball Park $1,750.00 $0.00 $3,878.60
General Maintenance Shop $26,475.00 $1,539.26 $32,185.48
General Park Areas $230,050.00 $16,670.51 $234,835.05
General Community Center $63,115.00 $13,981.13 $66,883.74
General Other Financing Uses $0.00 $0.00 $12,563.44
General Fire Protection $134,405.00 $0.00 $132,972.32
FUND 101 General $2,961,415.00 $219,575.22 $2,811,337.26
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 01/11/19 9:55 AM
Page 2
Council Month End Expenditure -General Fund
Current Period:December 2018
2018 December 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 $8,914.41 $85,818.92
Economic Development Other Financing Uses $0.00 $0.00 $0.00
FUND 150 Economic Development $119,025.00 $8,914.41 $85,818.92
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 $2,459.25
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 $992.86
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 $8,439.35
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 $22,166.02
$3,165,695.00 $228,489.63 $2,955,322.20
City of St. Joseph 01/11/19 9:56 AM
Page 1
Council Month End Expense - Enterprise Funds
Current Period:December 2018
2018 December 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 $694,215.56
Water Fund Other Financing Uses $41,500.00 $6,000.00 $6,500.00
Water Fund Power and Pumping $28,925.00 $436.73 $6,230.99
Water Fund Purification-Plant 1 $31,170.00 $1,794.22 $279,323.14
Water Fund Purification-Plant 2 $85,300.00 $5,331.77 $80,345.85
Water Fund Distribution $10,000.00 $0.00 $18,872.06
Water Fund Wellhead Protection $3,000.00 $0.00 $0.00
Water Fund Storage-Tower 1 $15,890.00 $520.11 $6,092.32
Water Fund Water Maintenance $262,325.00 $17,984.11 $233,100.47
Water Fund Administration and General $27,905.00 $1,943.13 $37,984.68
Water Fund Depreciation Expense $400,000.00 $0.00 $0.00
FUND 601 Water Fund $1,612,550.00 $34,010.07 $1,362,665.07
FUND 602 Sewer Fund
Sewer Fund Bond Payment(P&I) $230,360.00 $0.00 $187,436.00
Sewer Fund Other Financing Uses $7,500.00 $13,000.00 $13,500.00
Sewer Fund Sanitary Sewer Maintenanc $209,845.00 $9,666.14 $140,676.46
Sewer Fund Lift Station-Baker Street $5,865.00 $339.36 $3,728.19
Sewer Fund Lift Station-Ridgewood/DBL $2,695.00 $822.19 $2,240.77
Sewer Fund Lift Station-Northland $4,665.00 $98.04 $1,109.64
Sewer Fund Lift Station-CR 121 $5,340.00 $163.07 $44,068.83
Sewer Fund Lift Station-Main $813,930.00 $1,371.01 $659,203.77
Sewer Fund Administration and General $32,060.00 $1,938.68 $42,495.20
Sewer Fund Depreciation Expense $500,000.00 $0.00 $0.00
FUND 602 Sewer Fund $1,812,260.00 $27,398.49 $1,094,458.86
FUND 603 Refuse Collection
Refuse Collectio Waste Collection $286,010.00 $22,439.47 $284,402.15
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 $22,439.47 $284,902.15
FUND 651 Storm Water Utility
Storm Water Uti Other Financing Uses $19,250.00 $19,250.00 $19,250.00
Storm Water Uti Administration and General $14,165.00 $1,144.80 $18,128.96
Storm Water Uti Storm Water Maintenance $107,930.00 $2,111.73 $91,795.32
Storm Water Uti Depreciation Expense $115,000.00 $0.00 $0.00
FUND 651 Storm Water Utility $256,345.00 $22,506.53 $129,174.28
FUND 652 Street Light Utility
Street Light Utili Street Lighting $80,975.00 $5,174.51 $66,160.62
FUND 652 Street Light Utility $80,975.00 $5,174.51 $66,160.62
City of St. Joseph 01/11/19 9:56 AM
Page 2
Council Month End Expense - Enterprise Funds
Current Period:December 2018
2018 December 2018
Description DEPART Descr YTD Budget 2018 Amt YTD Amt
$4,055,315.00 $111,529.07 $2,937,360.98
2018 Capital Expenditures
General Fund Capital Equipment Plan-Summary
Final adopted December 4,2017
As of December 31,2018
Available through 12/31 through 12/31
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 - 12,188.29 2,500.00 5,299.75
Planning 101-41941-300 Comp Plan Update 4,915.04 - 1,172.50 2,500.00 6,242.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 20,252.84 - - 3,050.00 23,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 6,749.30 36,000.00 - 4,466.79
Total Administration CEP 96,935.10 6,749.30 57,625.35 18,900.00 64,959.05
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 - 2,459.25 10,895.00 31,377.83
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 - 2,459.25 23,350.00 111,838.46
Streets 101-43120-530 Street Improvements 135,894.61 38,249.00 62,385.33 21,500.00 133,258.28
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
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 6,000.00 992.86 7,500.00 37,684.82
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 - 4,379.35 17,270.00 85,391.52
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 342,544.78 47,749.00 75,627.54 64,170.00 378,836.24
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) 31,488.66 56,100.00 219,302.32
Total EDA CIP 138,612.24 (5,000.00) 31,488.66 56,600.00 221,700.90
Total General Capital Improvements 669,039.83 49,498.30 167,200.80 163,020.00 777,334.65
St.Joseph Fire Department
Capital Equipment Plan-for Payable 2018
Adopted December 4,2017
12/31/2017 12/31
Available Grants/ 12/31 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 3,132.52 1,500.27
Total Fire Administration Computer Hardware/Software 3,332.79 1;300.00 - 3,132.52 4500.27
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 25562.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 9500.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 4,177.35 10,414.82
Total Fire Fighting Equipment 304,880.47 39,500:00 4,177.35 340,203.12
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 5376.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 1527.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 (15,077.58) 8,916.03 (226.69)
FD-1415 105-42280-530 Fire Station&Building Equipment Reserve 2011 2017-2022 Parking Lot (44,027.58 25,500.00 18,527.58 - -
FD-1416 105-42280-530 Fire Station&Building Improvements other than Building 2008 2017-2024 Painting 10,450.00 1,000.00 (3,450.00) 8,000.00 -
Total Fire Station&Building Improvements other than Building (11,310.66 28,000.00 - 16,916.03 (226.69)
Total Capital Equipment-Fire Fund 408,433.10 89,750.00 1,000.00 28,209.85 470,973.25
Note: The fire department is funded by the City of St.Joseph,St.Joseph Township and St.Wendel Township.
-r a,,1
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 -`0%down oayment+trade in valu
FD-1409 105-42220-585 Fire Fighting Firefighter Equipment 1999 2028 Tanker#4.2028-may last longer with new tan
2018 Capital Expenditures
Enterprise Capital Equipment Plan-Public Works
Adopted December 4,2017
12/31/2017 Grants/ as of 12/31 2018
Project Project Purchase Replace Reserve Budget Transfers Spent Available
Department Account Code Number Equipment Year Year Balance 2018 2018 2018 Balance
1984/[005
2006/2008 2018/2020
Water- 601-49440-55C PW-1403 Truck(1/4) 2013 /2021 4,750.00 3,000.00 (7,750.00) -
601-49440-58C WT-1804Fuel 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-17i2 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 (1,875.87) 12,274.13
601-49421-58C WT-1403 WTP 2 Repairs ongoing on going 17,500.00 5,000.00 (773.00) 21,727.00
47,960.00 45,060.00 - (10,398.87) 82,621.13
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-580WW-1804 Fuel Tank new 2020 - 500.00 500.00
602-49450-53CWW-1401 Sewer Lining on going on going 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 on going on going 17,000.00 10,000.00 (7,395.06) 19,604.94
602-49450-30CWW-1805 Comprehensive Sewer Plan 2008/2009 2022 - - -
602-49490-30CWW-1803 Comprehensive Rate Study 2015 2020 - - -
602-49490-581WW-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 L5 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
########i 55,860.00 - (15,252.01) 177,276.49
2018 Capital Expenditures
Enterprise Capital Improvement Plan-Public Works
Adopted December 4,2017
12/31/2017 Grants/ as of 12/31 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 SS-1705 Printer-UB 2016 2021 60.00 60.00 120.00
651-49900-303 SS-1712 Update MS4 SWPPP/Permit Compliance - 1,000.00; 1,000.00
651-49900-303 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 ongoing 69,190.20 2,000.00 (14,636.35) 56,553.85
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 on going on going 77,902.24 1,000.00 78,902.24
########I 15,560.00` - (14,636.35) 203,626.09
Refuse- 603-43230-581 RF-1705Printer-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 SI-1410 Street Lighting ongoing on going 17,000.00 7,000.00 24,000.00
17,000.00 7,000.00 - - 24,000.00
City of St.Joseph Park Board
2018 Capital Improvement Budget Summary
Council adopted December 4,2017
General Funds Balance
Park Dedication Cash December 31,2018 $ 83,527
(Unaudited)
Adiustments
Starting Balance $ 83,527
2018 General Levy-remaining $ 2,294
Other Revenues-remaining $ 12,484
Potential Proiects: Potential Proposed
Millstream Cottages-phase 2 $ 23,400
The Oaks on 20th phase 1 [2018] $ 27,300
The Oaks on 20th phase 1 [2019] $ 11,700
Industrial Park[2019+] $ 8,580
Sunset Ridge-phase 2-4 lots $ 2,000
Ending Balance for 2018 $ 134,185
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 $ 31,550 Millstream play equip $ - _$ 905
PTR-02(Northland) $ - $ -
PTR-03(Klinefelter) $ - $ - Other 18 Expenses B 2018 YTD
PTR-04(Wobegon) $ - $ - Real Estate Taxes $ 4,020 $ 3,862
PTR-05(Memorial) $ - $ - A-1 Toilets $ 1,600 $ 1,543
PTR-06(Centennial) $ - $ -
PTR-07(Monument) $ - $ - 2018 RevenMp Budget: 2018 YTD
PTR-08(Hollow) $ - $ - Interest $ 1,000 $ 336
PTR-09(Cloverdale) $ - $ - Round Up $ 120 $ 145
PTR-10(East Park) $ 435 $ 21,994 phase 1 design GF Levy $ 20,000 $ 17,706
PTR-11(West Park) $ - $ - Land Rent $ 2,120 $ 2,120
PTR-12(Trails) $ - $ - Transfer $ - $ -
PTR-13(Trees) $ - $ 1,000 Donations $ 10,000 $ 155
PTR-14(Dog Park) $ 15,504 $ - phase 1 dog park Park Dedic. $ 2,000 $ -
Total $ 23,776 $ 54,544
18 Millstream 5k Expenses: Avail.Rev
$ - $ 3,024
18 Dog Park Donation Budget: 2016/2017/2018
pavers/treats $ 1,149
cash $ 10,000 $ 5,601
thru 12/31/18