HomeMy WebLinkAbout[04c] Treasurer's Report
Council Agenda Item 4c
MEETING DATE: April 15, 2019
AGENDA ITEM: Financial Report – 1st Quarter & March 2019 Financial Reports
SUBMITTED BY: Finance
BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A
PREVIOUS COUNCIL ACTION: Council adopted the 2019 budget on December 17, 2018.
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
March 31, 2019.
CASH POSITION:
- The market rate of return (ROR) is approximately 2.36% with an average maturity of 32 months.
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 March, the Federal Open Market Committee \[FOMC\] kept the federal fund rates to 2.25 to
2.5% citing inflation projections, and uncertainty and risks of economic outcomes of real GDP
growth, unemployment and inflation are more balanced.
- Interest earnings for 2019 amounts to a $66,228. 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. The beginning of the year
reflects higher interest earnings than reported in 2018.
- Overall, the cash and investments balance decreased $327,843 from the beginning of the year.
First half tax settlements and state aids will be received in June/July. The first half of the year is
anticipated to decrease in cash as the City spends down the working capital carried from 2018.
- In October, staff was notified Morgan Stanley is discontinuing their government client division.
All, but one CD was transferred from Morgan Stanley to RBC Wealth Management. The CD
would not mature until 2021. Staff, with the discussion of the financial advisors, decided to call
the CD early and move the proceeds to RBC. The CD interest rate was 1.6%, current market
rates are 2.5% for the same maturity. Over the life of the new CD with the higher interest rate,
the City will break even on the funds.
FUNDS REPORT:
- The General fund spent 19% of the 2019 expenditure budget and received 4% of the revenue
budget. Expenditures and revenues are mainly operational in nature. The larger revenue
accounts include the first half street municipal aid, garage rent, police fines and refuse hauler
permits. The expenditures include many of the membership dues, audit services and basic
operational costs.
- The Enterprise Funds represent two months utility billing revenue collected while expenses
represent three months. Overall, 6% of expenses have been incurred (less depreciation); 5% of
the revenue budget has been received. Revenues and expenses are general operations.
Water fund analysis (fund 601/501) – The enclosed spreadsheet shows an analysis of the water fund,
including the Water fund (601) and the Water Access fund (WAC-501). The City did not collect
nd
WAC/Trunk fees in the first quarter. Activity did pick up in the 2 quarter. Water revenues represent
6%, expenses 7% of the budget at the end of March and all are operational in nature.
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 expenses are at 4% of the
budget, while revenues are at 4% of the budget and all are operational in nature.
½ ¢ Sales Tax (fund 200): The sales tax fund has a cash balance of $929,198. The City anticipates
collecting $440,000 in sales tax revenue through 2019, the start of the State legislation sales tax
extension. The City of St. Joseph collected $4,263,671 in sales tax revenue for the original legislative
period. The budgeted amount was $3,372,754. The St. Cloud area collected $7.2M less than the original
budget. St. Joseph has benefited from increased sales tax collections since the law was passed in 2005.
The allocation formula is reviewed annually by the area Finance Directors to ensure sales credits are
given to the correct community.
The Sales Tax Summary report shows all revenues recorded and projects expensed from Fund 200. The
projects are split to show the projects completed, the projects in progress, and the projects reviewed, but
not moved forward at this time. After the anticipated revenue collections through 2038, $4.5M remains
uncommitted. The available annual sales tax revenue after bonded commitments is $257,013. The East
Park and CSAH 2 Trail projects will be paid for with cash out of the $929,198 reserved balance plus 2019
sales tax collections. The CSAH 2 Trail project will also receive $650,594 in federal funds to reimburse
construction costs in 2019.
CIP REPORTS:
- General capital equipment purchases include costs to upgrade cable access equipment.
- Engineering expenses incurred relating to the 2019 street improvement and Industrial Park
expansion projects.
BUDGET/FISCAL IMPACT: Information Only
ATTACHMENTS: Request for Council Action – Quarterly and March Financial Reports
1st Quarter Reports:
Cash Position as of 3/31/19
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
March 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
Enterprise Capital Improvement Plan – Public Works
Capital Improvement Budget Summary – Park Board
REQUESTED COUNCIL ACTION: Consider accepting the 1st quarter and March 2019 financial
reports.
Total SB
Total CMCU
avg
Total 4M
Total Deposits2,904,357$
avg
avg
Total RBC
Total Investments4,537,484$
ağƩƉĻƷ
{ğǝźƓŭƭ
{ĻĭǒƩźƷźĻƭ
aƚƓĻǤ/5ƭ
ağƩƉĻƷ
/5ƭ
ЊЎі
Ͳ
/ŷĻĭƉźƓŭaƚƓĻǤ.ğƓƉ.ƩƚƉĻƩĻķDƚǝĻƩƓƒĻƓƷ.ƩƚƉĻƩĻķ
ЊЏі
Ͳ
ЊͲЉВЏͲЌЉЉ
ЊͲЊВЉͲАЋЎ
Љі
Ͳ
ЊЊͲЏБЎ
IƚƌķźƓŭƭ
Бі
Ͳ
Ѝі
Ͳ
ЏЊАͲЌЌЊ
LƓǝĻƭƷƒĻƓƷ
ЋВВͲЉББ
ğƓķ
/ğƭŷ
ЎАі
Ͳ
ЍͲЋЋЏͲАЊЊ
BudgetActual
BudgetActual
ExpExpRevRev
$95,065
$332,180
Fund
$22,065
Revenues
&
$332,180
Expenditures
Actual
to
$144,134
Budget
FundFire
$3,248,925
Fire
&
General
$620,386
General
$3,192,220
$
$500,000
$3,500,000$3,000,000$2,500,000$2,000,000$1,500,000$1,000,000
9ǣƦĻƓƭĻwĻǝĻƓǒĻ
υБЉͲЉЉЉ
υАЊͲЏЋВ
υЏВͲВВЊ
υЏАͲЉЎА
υАЉͲЉЉЉ
υЎЏͲВЏЎ
υЏЉͲЉЉЉ
υЎЊͲААА
υЎЉͲЉЉЉ
Activity
Funds
υЍЉͲЉЉЉ
υЌЉͲЉЉЉ
Enterprise
υЊЏͲЉЎЌ
υЋЉͲЉЉЉ
υЊЍͲЉАЍ
υВͲЏЏЋ
υАͲААБ
υЊЉͲЉЉЉ
υЍͲЌБЉ
υ
Light
Sewer
WaterWater
Refuse
Street
Storm
2019 Revenue Budget1,301,300.00 (includes fund 501)
WTP1 expenses include contract to refurbish
2019 Expense Budget(946,300.00) (excludes depreciation, includes 501)
The balances represent the cash balance as of 3/31/19
2019 Revenue Budget1,723,255.00 (includes fund 501)
2019 Expense Budget(1,328,755.00) (excludes depreciation,includes fund 502)
The balances represent the cash balance as of 3/31/19.
As of March 31, 2019
$110 anonymous donation
$40,000 Lion's donation
transfers from other funds
$1.794M bond proceeds
plus $32K APO funded
Total Projects Completed
$300K State Bonding request
7,500,000$6M donations est.; $1.5M state bonding request
cover bond payments due to deferred assessments
$650,594 federal funding
Total Projects in Progress
Fund 200 Balance, December 31, 2018, unaudited
anticipated remaining 2019 sales tax revenues to collect
anticipated remaining 2020-2038 sales tax revenues to collect
Committed - to be funded
Anticipated remaining balance after commitments
uncommitted annually (5 yr Average)
Projects that have been discussed for
Sales Tax Funding, not approved
$2M donations est.
$1.5M State Bonding request
$50K donations est.
Total Projects Not Approved
04/09/19 3:02 PM
City of St. Joseph
Page 1
Cash Balances Only
Current Period: March 2019
MTDMTDCurrent
FUND DescrAccountBegin YrDebitCreditBalance
Last Dim 10100
GeneralG 101-10100$1,776,179.52$39,835.20$258,036.92$1,224,433.50
Employee Retirement ReserveG 102-10100$122,343.34$0.00$0.00$122,343.34
Fire FundG 105-10100$581,626.46$22,960.97$5,894.64$608,099.46
Cable Access FeeG 108-10100$5,119.57$790.92$0.00$5,655.37
Economic DevelopmentG 150-10100$58,897.49$65,134.60$37,742.96$33,834.43
TIF 3-1 CMCUG 152-10100$183.67$0.62$0.00$205.39
TIF 4-1 Fortitude Senior AptsG 153-10100$4,527.85$12.83$0.00$4,566.80
TIF 2-1 MillstreamG 157-10100$25,642.09$77.74$0.00$25,993.71
TIF 2-2 Meat MarketG 158-10100$495.50$1.50$0.00$501.27
TIF 2-3 Bayou Blues/Alley FlatG 159-10100$1,278.12$2.59$0.00$1,280.83
State Collected Sales TaxG 200-10100$827,524.42$4,921.66$225.10$929,197.81
Park DedicationG 205-10100$111,372.46$341.10$179.00$112,231.47
Charitable GamblingG 215-10100$2,096.31$6.35$0.00$2,123.24
Lodging TaxG 220-10100$30,334.72$981.87$0.00$32,637.84
DEED CDAP GrantG 225-10100$34,945.69$105.79$0.00$35,338.86
Revolving Loan FundG 250-10100$211,358.83$640.61$0.00$214,078.10
2016 CIP Bonds \[govt center\]G 301-10100$48,948.00$151.84$0.00$51,135.73
2017A CIP Bonds \[govt center\]G 303-10100$104,072.28$3,324.51$0.00$114,417.99
2016 Street Imp \[Field St\]G 304-10100$67,219.44$198.68$46.00$65,878.94
2017B Street Imp \[CBD Alleys\]G 305-10100$52,970.17$159.75$0.00$53,235.57
2018 Equipment CertificatesG 306-10100$50.07$198.17$0.00$906.44
2010B Refunding \[Hill/Clover\]G 333-10100$132,425.71$401.23$0.00$134,155.59
2011A CO Refund \[Interior St\]G 338-10100$81,909.29$243.76$0.00$78,565.42
2010B Street Imp \[16th Ave\]G 345-10100$150,570.60$455.89$0.00$152,417.16
2011A Pumper Truck CertificatG 346-10100$39.94$3,129.81$0.00$7,285.21
2013 Street Imp \[Overlays\]G 348-10100$86,921.38$263.26$0.00$88,023.14
2014 Street Imp \[ParkTerrace\]G 350-10100$205,032.07$648.59$0.00$221,224.74
2015 Street Imp\[Clinton/NorthG 351-10100$134,912.55$460.29$0.00$139,756.44
2015 Equipment CertificatesG 352-10100$1,044.81$120.78$0.00$2,885.21
2015 Abatement \[Comm CenteG 353-10100$28,351.01$87.00$0.00$28,912.73
Debt Service ReliefG 390-10100$539,508.46$0.00$1,400.00$538,670.32
Community Center phase IG 402-10100$2,468.78$507.51$0.00$3,011.49
2018 Equipment CertificatesG 406-10100$65,256.32$0.00$0.00$65,256.32
2019 Street OverlaysG 407-10100$0.00$0.00$23,842.50-$27,133.29
2019 Industrial Park ExpansionG 408-10100$0.00$0.00$63,225.04-$55,166.76
Capital OutlayG 490-10100$409,574.39$0.00$0.00$410,045.60
WAC FundG 501-10100$409,128.81$1,244.90$0.00$419,801.40
SAC FundG 502-10100$88,820.42$268.82$0.00$92,219.72
Water FundG 601-10100$602,018.79$68,181.92$36,765.11$699,768.13
Sewer FundG 602-10100$232,989.51$69,700.99$85,246.58$285,033.19
Refuse CollectionG 603-10100$244,488.14$18,358.23$28,151.77$230,010.20
Storm Water UtilityG 651-10100$251,993.02$6,219.91$7,266.45$251,451.00
Street Light UtilityG 652-10100$35,043.36$4,135.04$4,598.95$37,551.10
Last Dim 10100$7,769,683.36$314,275.23$552,621.02$7,441,840.15
Last Dim 10200
GeneralG 101-10200$225.00$0.00$0.00$225.00
Last Dim 10200$225.00$0.00$0.00$225.00
04/09/19 3:02 PM
City of St. Joseph
Page 2
Cash Balances Only
Current Period: March 2019
MTDMTDCurrent
FUND DescrAccountBegin YrDebitCreditBalance
$7,769,908.36$314,275.23$552,621.02$7,442,065.15
Council Month End Revenue Summary
Current Period: March 2019
2019March2019
FUNDFUND DescrYTD Budget2019 AmtYTD Amt
101General$3,184,310.00$36,387.79$143,069.26
102Employee Retirement Reserve$56,705.00$0.00$0.00
105Fire Fund$332,180.00$22,867.57$95,064.72
108Cable Access Fee$7,910.00$790.92$1,064.34
150Economic Development$290,715.00$104.18$277.62
152TIF 3-1 CMCU$0.00$0.62$6.74
153TIF 4-1 Fortitude Senior Apts$0.00$12.83$27.37
157TIF 2-1 Millstream$0.00$77.74$226.99
158TIF 2-2 Meat Market$0.00$1.50$3.98
159TIF 2-3 Bayou Blues/Alley Flat$0.00$2.59$2.46
200State Collected Sales Tax$540,000.00$4,921.66$11,562.99
205Park Dedication$29,715.00$341.10$832.74
215Charitable Gambling$10.00$6.35$19.16
220Lodging Tax$14,100.00$981.87$1,586.32
225DEED CDAP Grant$25.00$105.79$330.13
250Revolving Loan Fund$1,100.00$640.61$1,943.70
3012016 CIP Bonds \[govt center\]$270,300.00$151.84$249.20
3032017A CIP Bonds \[govt center\]$0.00$3,324.51$9,808.76
3042016 Street Imp \[Field St\]$49,155.00$198.68$466.23
3052017B Street Imp \[CBD Alleys\]$32,820.00$159.75$440.90
3062018 Equipment Certificates$57,005.00$198.17$512.80
3332010B Refunding \[Hill/Clover\]$73,800.00$401.23$1,166.35
3382011A CO Refund \[Interior St\]$120,405.00$243.76$353.17
3452010B Street Imp \[16th Ave\]$36,975.00$455.89$1,306.52
3462011A Pumper Truck Certificate$42,870.00$3,129.81$8,586.96
3482013 Street Imp \[Overlays\]$23,310.00$263.26$759.18
3502014 Street Imp \[ParkTerrace\]$110,010.00$648.59$7,190.57
3512015 Street Imp\[Clinton/North\]$43,545.00$460.29$2,622.71
3522015 Equipment Certificates$36,010.00$120.78$781.69
3532015 Abatement \[Comm Center\]$160,570.00$87.00$370.28
390Debt Service Relief$0.00$0.00-$76.99
402Community Center phase I$0.00$507.51$533.88
4062018 Equipment Certificates$0.00$0.00$0.00
4082019 Industrial Park Expansion$0.00$0.00$0.00
490Capital Outlay$139,425.00$0.00$0.00
501WAC Fund$0.00$1,244.90$4,372.45
502SAC Fund$162,500.00$268.82$943.66
601Water Fund$1,301,300.00$61,172.60$71,629.17
602Sewer Fund$1,560,755.00$69,660.52$67,056.78
603Refuse Collection$304,700.00$15,511.52$16,053.01
651Storm Water Utility$112,295.00$6,219.60$7,778.09
Council Month End Revenue Summary
Current Period: March 2019
2019March2019
FUNDFUND DescrYTD Budget2019 AmtYTD Amt
652Street Light Utility$82,240.00$4,134.61$4,379.68
$9,176,760.00$235,806.76$463,303.57
Council Month End Revenue -General Fund
Current Period: March 2019
2019March2019
FUNDFUND DescrSOURCE DescrYTD Budget2019 AmtYTD Amt
FUND 101 General
101GeneralCurrent Ad Valorem Taxes$1,424,710.00$0.00$0.00
101GeneralSpecial Levy- City St. Joe$0.00$0.00$143.22
101GeneralState Sales Tax$0.00$11.68$149.42
101GeneralGravel Tax$13,670.00$0.00$1,857.55
101GeneralSolar Production Tax$500.00$0.00$0.00
101GeneralGas Franchise$32,760.00$0.00$0.00
101GeneralElectric Franchise$62,185.00$2,290.57$4,547.72
101GeneralLicenses & Permits$12,450.00$0.00$10,000.00
101GeneralBeer$50.00$0.00$0.00
101GeneralLiquor$28,135.00$0.00$0.00
101GeneralOutdoor Liquor Permit$2,000.00$500.00$500.00
101GeneralGambling Permits$350.00$0.00$160.00
101GeneralAmusement/Hunt/Peddler/Golf$1,400.00$130.00$130.00
101GeneralExcavation Permit$500.00$0.00$0.00
101GeneralCigarette License$675.00$0.00$0.00
101GeneralCable Franchise Fee$34,870.00$1,234.63$2,475.45
101GeneralBuilding Permits$145,000.00$7,291.48$11,808.85
101GeneralAnimal License$3,100.00$730.00$770.00
101GeneralRental Housing Registration$30,180.00$0.00$0.00
101GeneralFederal Grants - Other$8,000.00$417.21$0.00
101GeneralState Grants and Aids$1,100.00$0.00$0.00
101GeneralLocal Government Aid$994,435.00$0.00$0.00
101GeneralPERA Rate Increase Aid$1,540.00$0.00$0.00
101GeneralPolice Training Reim$3,500.00$0.00$0.00
101GeneralState Municipal Funds Aid$55,800.00$0.00$29,994.50
101GeneralState Police Aid$65,000.00$0.00$0.00
101GeneralOther Governmental Unit$10,000.00$0.00$5,000.00
101GeneralCounty Grants - Road Maint.$16,300.00$0.00$0.00
101GeneralZoning and Subdivision Fee$7,000.00$1,300.00$1,300.00
101GeneralLand Use Deposit Fee$4,000.00-$1,279.02$5,750.00
101GeneralSale of Maps and Publications$25.00$0.00$2.00
101GeneralAssessments Search$4,000.00$750.00$1,230.00
101GeneralSpecial Hearing$2,000.00$400.00$1,925.00
101GeneralAdministration Reimb$13,000.00$53.29$33.28
101GeneralWeed Cutting$500.00$0.00$0.00
101GeneralAdmission Fee$1,000.00$202.00$632.00
101GeneralShelter/Room Rental Fees$10,000.00$1,640.00$5,850.00
101GeneralBall Field Donation$100.00$0.00$0.00
101GeneralSchneider Field Rental$1,500.00$0.00$0.00
101GeneralRents and Royalties$59,055.00$5,268.41$18,205.23
Council Month End Revenue -General Fund
Current Period: March 2019
2019March2019
FUNDFUND DescrSOURCE DescrYTD Budget2019 AmtYTD Amt
101GeneralKennel Fees$300.00$0.00$0.00
101GeneralCounty Fines$38,000.00$2,940.79$2,160.95
101GeneralPolicy Fines$20,000.00$4,038.00$12,939.24
101GeneralAccident Report Fee$1,300.00$53.25$132.25
101GeneralSeized Property$2,000.00$0.00$0.00
101GeneralSpecial Assessments$4,000.00$0.00$0.00
101GeneralInterest Earnings$20,000.00$6,784.10$21,572.75
101GeneralInterest Charges$100.00$0.00$0.00
101GeneralCo-op Dividend - LMCIT$10,000.00$0.00$0.00
101GeneralWater Tower Antenna Lease$4,170.00$694.90$1,042.35
101GeneralAdvertising$1,200.00$0.00$820.00
101GeneralContributions - General$2,000.00$0.00$1,000.00
101GeneralContributions - Parks$250.00$0.00$1.00
101GeneralSurplus Property$0.00$0.00$0.00
101GeneralReimbursement$28,600.00$105.00$105.00
101GeneralInsurance Recovery$2,000.00$831.50$831.50
101GeneralTransfers from Other Funds$0.00$0.00$0.00
FUND 101 General$3,184,310.00$36,387.79$143,069.26
FUND 102 Employee Retirement Reserve
102Employee Retirement ResTransfers from Other Funds$56,705.00$0.00$0.00
FUND 102 Employee Retirement Reserve$56,705.00$0.00$0.00
FUND 108 Cable Access Fee
108Cable Access FeeCable Franchise Fee$7,910.00$790.92$1,064.34
108Cable Access FeeTransfers from Other Funds$0.00$0.00$0.00
FUND 108 Cable Access Fee$7,910.00$790.92$1,064.34
FUND 150 Economic Development
150Economic DevelopmentCurrent Ad Valorem Taxes$111,240.00$0.00$0.00
150Economic DevelopmentFederal Grants - Other$178,625.00$0.00$0.00
150Economic DevelopmentTIF/MIF Deposit$0.00$0.00$0.00
150Economic DevelopmentTax Abatement Reimbursement$0.00$0.00$0.00
150Economic DevelopmentInterest Earnings$850.00$104.18$277.62
150Economic DevelopmentTransfers from Other Funds$0.00$0.00$0.00
FUND 150 Economic Development$290,715.00$104.18$277.62
FUND 490 Capital Outlay
490Capital OutlayCurrent Ad Valorem Taxes$138,925.00$0.00$0.00
490Capital OutlayFederal Grants - Other$0.00$0.00$0.00
490Capital OutlaySurplus Property$500.00$0.00$0.00
FUND 490 Capital Outlay$139,425.00$0.00$0.00
Council Month End Revenue -General Fund
Current Period: March 2019
2019March2019
FUNDFUND DescrSOURCE DescrYTD Budget2019 AmtYTD Amt
$3,679,065.00$37,282.89$144,411.22
Council Month End Revenue -Enterprise Funds
Current Period: March 2019
FUND2019March2019
FUNDDescrSOURCE DescrYTD Budget2019 AmtYTD Amt
FUND 601 Water Fund
601Water FundWater Fixed Charge$326,220.00$20,660.46$20,466.25
601Water FundCurrent Ad Valorem Taxes$22,500.00$0.00-$272.03
601Water FundTransfers from Other Funds$207,000.00$0.00$0.00
601Water FundMDS Test Fee$11,500.00$720.59$710.11
601Water FundWater Meter$5,510.00$415.00$1,155.00
601Water FundPenalties and Forfeited Disc$8,130.00$382.60$1,204.37
601Water FundUndesignated Funds$2,000.00-$2,532.64-$1,690.83
601Water FundBulk Water$3,500.00$54.50$54.50
601Water FundReimbursement$0.00$75.52$1,535.52
601Water FundWater Tower Antenna Lease$37,525.00$6,254.12$9,381.18
601Water FundAmortization of Bond Premium$0.00$0.00$0.00
601Water FundInterest Earnings$2,000.00$1,869.82$4,859.86
601Water FundState Sales Tax$0.00$32.59-$454.04
601Water FundSpecial Assessments$700.00$0.00-$859.59
601Water FundState Grants and Aids$0.00$0.00$0.00
601Water FundUsage Rate$674,715.00$33,240.04$35,538.87
601Water FundContributed Revenue$0.00$0.00$0.00
FUND 601 Water Fund$1,301,300.00$61,172.60$71,629.17
FUND 602 Sewer Fund
602Sewer FundState Grants and Aids$0.00$0.00$0.00
602Sewer FundSanitary Sewer Use Service$837,225.00$38,748.31$39,346.36
602Sewer FundContributed Revenue$0.00$0.00$0.00
602Sewer FundReimbursement$4,000.00$0.00$0.00
602Sewer FundSurplus Property$0.00$0.00$0.00
602Sewer FundContributions - General$750.00$0.00$14.00
602Sewer FundAmortization of Bond Premium$0.00$0.00$0.00
602Sewer FundInterest Earnings$16,160.00$1,759.71-$1,930.54
602Sewer FundOther Governmental Unit$0.00$0.00$0.00
602Sewer FundSewer Fixed Charge$532,750.00$28,690.98$28,401.64
602Sewer FundTransfers from Other Funds$162,000.00$0.00$0.00
602Sewer FundSpecial Assessments$250.00$0.00-$94.89
602Sewer FundGain on Disposal of Assets$0.00$0.00$0.00
602Sewer FundPenalties and Forfeited Disc$7,620.00$461.52$1,320.21
FUND 602 Sewer Fund$1,560,755.00$69,660.52$67,056.78
FUND 603 Refuse Collection
603Refuse CollecSpecial Assessments$200.00$0.00-$75.50
603Refuse CollecContributed Revenue$0.00$0.00$0.00
603Refuse CollecReimbursement$0.00$0.00$321.66
603Refuse CollecInterest Earnings$2,000.00$719.57$2,161.55
603Refuse CollecPenalties and Forfeifted Disc$5,500.00$194.76$589.70
603Refuse CollecRefuse Collection Charges$271,760.00$15,706.28$15,450.65
603Refuse CollecState Grants and Aids$0.00$0.00$0.00
603Refuse CollecLicenses & Permits$25,240.00$765.00$705.60
603Refuse CollecState Sales Tax$0.00-$1,874.09-$3,100.65
603Refuse CollecContributions - General$0.00$0.00$0.00
FUND 603 Refuse Collection$304,700.00$15,511.52$16,053.01
FUND 651 Storm Water Utility
651Storm Water Other Grants/Aids$20,000.00$0.00$0.00
Council Month End Revenue -Enterprise Funds
Current Period: March 2019
FUND2019March2019
FUNDDescrSOURCE DescrYTD Budget2019 AmtYTD Amt
651Storm Water Penalties and Forfeifted Disc$1,500.00$25.36$84.51
651Storm Water Storm Water Use Service$84,385.00$5,436.51$5,475.35
651Storm Water Storm Water Develop Fee$4,000.00$0.00$0.00
651Storm Water Contributed Revenue$0.00$0.00$0.00
651Storm Water Special Assessments$400.00$0.00-$7.37
651Storm Water State Grants and Aids$10.00$0.00$0.00
651Storm Water Interest Earnings$2,000.00$757.73$2,225.60
FUND 651 Storm Water Utility$112,295.00$6,219.60$7,778.09
FUND 652 Street Light Utility
652Street Light UPenalties and Forfeited Disc$1,000.00$32.87$100.85
652Street Light UState Grants and Aids$0.00$0.00$0.00
652Street Light UOther Grants/Aids$300.00$0.00$0.00
652Street Light USpecial Assessments$50.00$0.00-$10.32
652Street Light UInterest Earnings$335.00$107.08$323.67
652Street Light UContributions - General$0.00$0.00$0.00
652Street Light USurplus Property$0.00$36.00$36.00
652Street Light UReimbursement$0.00$0.00$0.00
652Street Light UUsage Rate$80,555.00$3,958.66$3,929.48
FUND 652 Street Light Utility$82,240.00$4,134.61$4,379.68
$3,361,290.00$156,698.85$166,896.73
Council Month End Expenditure - Summary
Current Period: March 2019
2019March2019
DescriptionYTD Budget2019 Amt YTD Amt
General$3,184,310.00$231,708.21$619,925.93
Employee Retirement Reserve$0.00$0.00$0.00
Fire Fund$332,180.00$5,801.24$22,065.45
Cable Access Fee$7,910.00$0.00$460.00
Economic Development$290,715.00-$27,287.46$16,534.24
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$0.00
TIF 2-3 Bayou Blues/Alley Flat$795.00$0.00$0.00
State Collected Sales Tax$1,130,000.00$225.10-$10,944.06
Park Dedication$311,610.00$179.00$358.00
Charitable Gambling$3,500.00$0.00$0.00
Lodging Tax$14,100.00$0.00$0.00
DEED CDAP Grant$12,500.00$0.00$0.00
Revolving Loan Fund$0.00$0.00$0.00
2016 CIP Bonds \[govt center\]$269,755.00$0.00$0.00
2017A CIP Bonds \[govt center\]$50,195.00$0.00$0.00
2016 Street Imp \[Field St\]$63,460.00$46.00$1,219.36
2017B Street Imp \[CBD Alleys\]$43,340.00$0.00$0.00
2018 Equipment Certificates$56,735.00$0.00$0.00
2010B Refunding \[Hill/Clover\]$141,525.00$0.00$0.00
2011A CO Refund \[Interior St\]$144,140.00$0.00$4,515.00
2010B Street Imp \[16th Ave\]$66,715.00$0.00$0.00
2011A Pumper Truck Certificate$42,870.00$0.00$1,380.00
2013 Street Imp \[Overlays\]$47,180.00$0.00$0.00
2014 Street Imp \[ParkTerrace\]$162,245.00$0.00$0.00
2015 Street Imp\[Clinton/North\]$70,160.00$0.00$0.00
2015 Equipment Certificates$36,335.00$0.00$0.00
2015 Abatement \[Comm Center$155,045.00$0.00$0.00
Debt Service Relief$141,000.00$1,400.00$1,400.00
Community Center phase I$0.00$0.00$0.00
2018 Equipment Certificates$0.00$0.00$0.00
2019 Street Overlays$0.00$23,842.50$27,133.29
2019 Industrial Park Expansion$0.00$63,225.04$55,166.76
Capital Outlay$139,425.00$0.00$0.00
WAC Fund$225,000.00$0.00$0.00
SAC Fund$162,000.00$0.00$0.00
Water Fund$1,571,300.00$29,755.79$69,991.44
Sewer Fund$1,990,755.00$85,206.11$56,964.74
Refuse Collection$330,265.00$25,305.06$51,776.57
Council Month End Expenditure - Summary
Current Period: March 2019
2019March2019
DescriptionYTD Budget2019 Amt YTD Amt
Storm Water Utility$287,880.00$7,266.14$14,074.49
Street Light Utility$82,240.00$4,598.52$9,661.81
$11,607,070.00$451,271.25$941,683.02
Council Month End Expenditure - General Fund
Current Period: March 2019
2019March2019
DescriptionDEPART DescrYTD Budget2019 Amt YTD Amt
FUND 101 General
GeneralCouncil$65,745.00$1,999.51$18,960.39
GeneralLegislative Committees$5,800.00$0.00$0.00
GeneralOrdinance & Proceedings$2,200.00$166.23$166.23
GeneralMayor$11,865.00$1,250.75$2,056.58
GeneralElections$4,200.00$0.00$0.00
GeneralGeneral Adminstration$304,265.00$22,097.85$49,142.27
GeneralFinance$217,245.00$10,661.80$31,189.90
GeneralAudit Service$28,450.00$16,000.00$19,500.00
GeneralAssessing$25,500.00$0.00$0.00
GeneralCity Attorney$22,000.00$2,402.88$4,311.63
GeneralPlanning and Zoning$85,390.00$5,096.76$17,208.40
GeneralGeneral Government$48,485.00$1,321.11$5,254.95
GeneralCity Offices$37,575.00$7,505.10$10,873.80
GeneralCable Access$5,705.00$161.48$322.96
GeneralCrime Control & Investigation$1,138,905.00$65,165.82$208,152.85
GeneralPolice Training$6,680.00$25.00$301.17
GeneralCommunication Service$15,265.00$941.67$2,346.41
GeneralAutomotive Services$48,430.00$1,436.04$5,772.24
GeneralBuilding Inspec. Admistration$95,200.00$15,000.00$15,017.20
GeneralEmergency Management$2,275.00$657.91$666.29
GeneralAnimal Control$815.00$0.00$282.50
GeneralStreet Maintanence$330,000.00$17,036.64$40,422.61
GeneralIce & Snow Removal$126,635.00$41,020.74$86,585.74
GeneralEngineering Fee$35,000.00$631.86$6,188.36
GeneralStreet Cleaning$14,610.00$128.24$128.24
GeneralSkate Park and Ice Rink$5,715.00$379.13$2,761.15
GeneralBall Park$3,600.00$0.00$0.00
GeneralMaintenance Shop$23,320.00$2,231.56$7,217.63
GeneralPark Areas$253,665.00$10,253.46$30,928.96
GeneralCommunity Center$91,770.00$8,136.67$21,596.08
GeneralOther Financing Uses$0.00$0.00$0.00
GeneralFire Protection$128,000.00$0.00$32,571.39
FUND 101 General$3,184,310.00$231,708.21$619,925.93
FUND 102 Employee Retirement Reserve
Employee Retirement ReservGeneral 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 FeeCable Access$7,910.00$0.00$460.00
Cable Access FeeOther Financing Uses$0.00$0.00$0.00
Council Month End Expenditure - General Fund
Current Period: March 2019
2019March2019
DescriptionDEPART DescrYTD Budget2019 Amt YTD Amt
FUND 108 Cable Access Fee$7,910.00$0.00$460.00
FUND 150 Economic Development
Economic DevelopmentEconomic Development Authority$290,715.00-$27,287.46$16,534.24
Economic DevelopmentOther Financing Uses$0.00$0.00$0.00
FUND 150 Economic Development$290,715.00-$27,287.46$16,534.24
FUND 490 Capital Outlay
Capital OutlayGeneral Adminstration$11,250.00$0.00$0.00
Capital OutlayCrime Control & Investigation$3,340.00$0.00$0.00
Capital OutlayCommunication Service$6,375.00$0.00$0.00
Capital OutlayAutomotive Services$16,445.00$0.00$0.00
Capital OutlayEmergency Management$1,500.00$0.00$0.00
Capital OutlayStreet Maintanence$2,750.00$0.00$0.00
Capital OutlayIce & Snow Removal$10,000.00$0.00$0.00
Capital OutlayStreet Cleaning$500.00$0.00$0.00
Capital OutlayMaintenance Shop$65,500.00$0.00$0.00
Capital OutlayPark Areas$21,765.00$0.00$0.00
Capital OutlayCommunity Center$0.00$0.00$0.00
Capital OutlayOther Financing Uses$0.00$0.00$0.00
FUND 490 Capital Outlay$139,425.00$0.00$0.00
$3,622,360.00$204,420.75$636,920.17
Council Month End Expense - Enterprise Funds
Current Period: March 2019
2019March2019
DescriptionDEPART DescrYTD Budget2019 Amt YTD Amt
FUND 601 Water Fund
Water FundBond Payment (P & I)$697,695.00$0.00-$8,926.00
Water FundOther Financing Uses$12,725.00$0.00$0.00
Water FundPower and Pumping$17,420.00$353.97$17,258.83
Water FundPurification-Plant 1$37,955.00$1,984.93$4,458.34
Water FundPurification-Plant 2$87,285.00$5,661.07$12,025.47
Water FundDistribution$10,000.00$0.00$0.00
Water FundWellhead Protection$5,500.00$0.00$0.00
Water FundStorage-Tower 1$18,295.00$490.96$2,833.07
Water FundWater Maintenance$252,640.00$17,923.37$34,216.33
Water FundAdministration and General$31,785.00$3,341.49$8,125.40
Water FundDepreciation Expense$400,000.00$0.00$0.00
FUND 601 Water Fund$1,571,300.00$29,755.79$69,991.44
FUND 602 Sewer Fund
Sewer FundBond Payment (P & I)$236,170.00$0.00-$43,411.00
Sewer FundOther Financing Uses$19,570.00$0.00$0.00
Sewer FundSanitary Sewer Maintenanc$219,075.00$7,611.39$15,008.03
Sewer FundLift Station-Baker Street$6,080.00$782.29$1,233.21
Sewer FundLift Station-Ridgewood/DBL$2,700.00$271.36$500.38
Sewer FundLift Station-Northland$4,600.00$107.01$219.95
Sewer FundLift Station-CR 121$15,150.00$158.36$342.91
Sewer FundLift Station-Main$951,605.00$72,887.29$74,636.59
Sewer FundAdministration and General$35,805.00$3,388.41$8,434.67
Sewer FundDepreciation Expense$500,000.00$0.00$0.00
FUND 602 Sewer Fund$1,990,755.00$85,206.11$56,964.74
FUND 603 Refuse Collection
Refuse CollectioWaste Collection$321,990.00$25,305.06$51,776.57
Refuse CollectioOther Financing Uses$1,600.00$0.00$0.00
Refuse CollectioDepreciation Expense$6,675.00$0.00$0.00
FUND 603 Refuse Collection$330,265.00$25,305.06$51,776.57
FUND 651 Storm Water Utility
Storm Water UtiOther Financing Uses$24,230.00$0.00$0.00
Storm Water UtiAdministration and General$15,880.00$2,265.58$5,290.58
Storm Water UtiStorm Water Maintenance$132,770.00$5,000.56$8,783.91
Storm Water UtiDepreciation Expense$115,000.00$0.00$0.00
FUND 651 Storm Water Utility$287,880.00$7,266.14$14,074.49
FUND 652 Street Light Utility
Street Light UtiliStreet Lighting$82,240.00$4,598.52$9,661.81
FUND 652 Street Light Utility$82,240.00$4,598.52$9,661.81
Council Month End Expense - Enterprise Funds
Current Period: March 2019
2019March2019
DescriptionDEPART DescrYTD Budget2019 Amt YTD Amt
$4,262,440.00$152,131.62$202,469.05
9,344.415,500.001,274.685,655.372,450.957,604.005,090.003,940.007,604.002,898.58
11,242.5428,802.8427,593.6689,413.5016,359.4337,993.2833,209.3638,572.8312,912.6114,500.0047,684.8260,000.0072,316.6231,270.00
141,498.46200,289.55101,756.52552,055.51211,913.66214,812.24
997,779.71
750.00250.00500.00500.00
4,200.003,000.001,500.005,500.005,000.003,340.006,375.008,000.007,195.001,250.001,500.001,500.002,465.005,500.003,900.001,500.00
19,950.0027,660.0026,500.0010,000.0060,000.0016,365.0044,100.0044,600.00
128,480.00
220,690.00
3/31
460.00460.00
460.00
3/31through
201920192019Balance
1,064.341,064.34
39,994.5039,994.50
41,058.84
Summary
2018
Plan
17,
2019
524.68
5,144.418,242.544,000.005,051.031,200.956,104.002,625.003,690.006,104.002,398.58
31,
23,302.8422,593.6668,859.1613,019.4331,618.2825,209.3631,377.8311,412.6114,000.0037,684.8266,816.6227,370.0085,391.52
Availablethrough 113,838.46133,795.05383,581.01167,813.66170,212.24
736,490.87
Expenditures
December
Equipment
March
of
Capital
Capital
As
adopted
2019
Fund
Final
General
CodeEquipmentBalanceGrant
ProjectBudgetReserveTransferred/SpentBudgetRemaining
DepartmentAccount
SoftwareProjects
EDAEDA
2,800.27 2,800.27 3,253.953,327.57 3,327.57 1,500.001,000.001,000.00 3,500.00
14,771.71 14,771.71 31,062.40 31,062.40 72,259.5899,323.7787,250.0074,000.0023,001.0014,000.0012,688.1390,908.2511,376.62
385,776.43102,284.87543,523.25
200.00 200.00
1,300.00 1,300.00 6,000.00 6,000.00 2,750.00 2,750.00 1,300.001,500.003,000.002,500.002,000.003,000.001,500.001,000.001,000.00 3,500.00
BudgetAdjustmentsSpentReserve
12,500.0012,500.0010,000.00 45,300.00 10,000.00 13,000.0072,050.00
er with new tan
g
1,500.27 8,771.71 8,771.713,127.57
last lon
28,312.40 28,312.40 11,500.00 89,284.87
y
AvailableGrants/3/31Available340,476.43471,473.25
12/31/20183/31
- ma
#277,250.00
#372,500.00
#420,001.00
Lot
Van59,759.58
Radios80,908.25
Truck86,823.77
Repairs
Rig
Truck
Wheeler1,953.95
MHz
Painting
Computers1,500.27
Tanker
6
Parking
RescueGrass
3
Replacement10,688.13Replacement8,376.62Replacement3,127.57
Pumper
Ladder800
Building
PurchasedReplaceReserve
Building
Building
than
than
other
other
ReserveReserve
Hardware/Software
EquipmentEquipmentEquipmentEquipmentEquipmentEquipmentEquipmentEquipmentEquipmentEquipmentEquipmentEquipment
2019 Hardware/Software
EquipmentEquipmentEquipmentEquipment
Reserve
Improvements
Equipment
Payable
Computer
Equipment
for
Equipment
Department
Building
OtherEquipmentEquipment
&
Plan
Fire
Services
BuildingEquipmentBuildingEquipmentBuildingImprovements
&&&
AdministrationFightingFightingFightingCommunicationsStation
CǒƓķ
ServicesOther
Joseph
Equipment
FireFireFireFireFireMedicalFire
CźƩĻ
AdministrationComputerFightingOtherFightingFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterComm
unicationOtherCommunicationOtherStationStationStationFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighter
St.
TotalTotalTotal FireFire TotalTotalTotalTotal Fire
Capital
580Fire584Fire585Fire585Fire585Fire585Fire585Fire585Fire580Fire580Fire580Medical530Fire530Fire530Fire585Fire585Fire585Fire
9ƨǒźƦƒĻƓƷ
581/582Fire
CodeDepartmentObjectYearYearDescriptionFunds201920192019Funds
4222042220422204222042220422204222042220422504225042270422804228042280422204222042220
/ğƦźƷğƌ
42210
Account
105105105105105105105105105105105105105105105105105
105
ƚƷğƌ
e
3,500.001,965.001,665.005,000.005,000.002,000.007,250.006,203.051,965.001,665.002,000.008,000.00
40,000.0012,250.0020,000.0017,274.1326,727.0055,848.5029,604.9461,900.0014,000.0013,800.0013,800.0016,200.00
142,631.13224,986.49
3/312019
of
as
/
500.00500.00
3,500.001,465.001,665.005,000.005,000.002,000.001,000.005,000.005,000.003,500.001,465.001,665.002,000.006,900.002,300.002,300.002,200.00
20,000.0010,000.0015,000.0010,000.00
60,130.0047,830.00
#
500.00500.00
6,250.002,703.057,500.00
########
20,000.0011,750.0010,000.0012,274.1321,727.0040,848.5019,604.94
82,501.13
12/31/2018Grants
2020
goinggoinggoinggoing
20212021
//
2018/20202018/2020
goingongoingongoingongoingon
new2020new2022new2022new2020new2022new2022
2017202720062021201020202008201720152020201420221995est.2015202020162021
20132013
onononon
2008/20092022
1984/20051984/2005
2006/20082006/2008
Study
LS14,000.00
LS11,500.00
LS11,500.00
LS14,000.00
St
s
LS55,000.00
Model
e
FoamingPlan
Work
RidgewoodBakerNorthlandCR121
Main
StudyStudy
Plan
System
Programmer
RateSewerRate
Replacement
Public
Planr
Maintenanc
pumpspumpspumpspumps
2018
ExpansionExpansion
BathroomsBathrooms
Roof
Meter
Protection
Plan 17,
RepairsRepairs
SupplyDistributionTower
LiningTelevising/RootSample
Replacement
(1/4)(1/4)
12
#4/5
TankTank
BuildingBuilding
Expenditures
TruckFuelKlinefelterPWWaterWaterWellheadHandheldComprehensiveWaterWellWTPWTPTruckFuelSewerPWKlinefelterSewerComprehensiveComprehensiveSewerPumpSubmersibleSubmersibleSubmersibleSubmersible
December
Equipment
Capital
18041401140818051803140214031403140314031403
15031503
1804180518051805140118031712140214031403
1403141114031411
2019
WTWTWTWTWTWTWTWTWTWT
Capital
PWPWPWPW
ENGWWWWENGWWWWWWWWWWWWWWWWWW
Adopted
000000000000000000000000000
555852523030305830532258585558535252303030585853535353
CodeNumberEquipmentYearYearBalance201920192019Balance
494404944049440494404944049440494344949049490494354941049420494214945049450494504945049450494504945049490494804948049471494704947249473
Enterprise
601601601601601601601601601601601601602602602602602602602602602602602602602602
601
ProjectProjectPurchaseReplaceReserveBudgetTransfersSpentAvailabl
DepartmentAccount WaterSewer
e
2,000.001,000.008,692.626,600.00
8,692.62
14,550.0058,553.8564,000.0079,902.2432,000.00
38,600.00
220,006.09
3/312019
of
as
/
500.00
1,000.001,000.002,000.001,000.002,000.006,600.008,000.00
2,000.00
11,000.00
16,500.0014,600.00
#
6,692.62
6,692.62
########
14,050.0056,553.8553,000.0078,902.2424,000.00
24,000.00
12/31/2018Grants
goinggoinggoing
goingongoingongoingon
n/a2021
19972020
ononon
2002/20142023/2029
s
Compliance1,000.00
Work
Lighting
Schedule
(1/4)
Public
Improvements
r
SWPPP/Permit
2018
Driveway
Plan
Loader
Easements/Acquire
17,
MS4
Quality
SweepeLighting
Mapping
End
Maintenance
Expenditures
UpdatePondAerialWaterStreetPropertyFrontMillstreamStreet
December
Improvement
Capital
14071425
1712180514041405140618011410
SLSL
2019SSSSSSSSSS
PWPW
Adopted
330000000
Capital
303053535851585353
CodeNumberEquipmentYearYearBalance201920192019Balance
499004990049900499004990049900432304316043160
Enterprise
651651651651651603652652
651
LightingLighting
ProjectProjectbegincompleteReserveBudgetTransfersSpentAvailabl
DepartmentAccount StormwaterRefuseSt.St.
thru 3/31/19