HomeMy WebLinkAbout[04c] Financial Report
Council Agenda Item 4
MEETING DATE: April 16, 2018
AGENDA ITEM: Financial Report – 1st Quarter 2018 & March 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
March 31, 2018.
CASH POSITION:
- The market rate of return (ROR) is approximately 1.35% with an average maturity of 14 months.
The federal markets improved significantly in 2017 with some retraction 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 March, the Federal Open Market Committee \[FOMC\] increased the federal fund rates to 1.5 to
1.75% citing strong labor market conditions and sustained return to 2% inflation. The FOMC
expects that economic conditions will evolve in a manner that will warrant further gradual
increases in the federal funds rate, depending upon informed data on the economic outlook.
- Interest earnings for 2018 amounts to a negative $25,825. 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. Part of the
deficit is the result is due to entering reversing audit entries from 2017.
- Overall, the cash and investments balance decreased $534,693 from the beginning of the year.
Water plant 1 improvements bond proceeds will be spent in 2018. The first half of the year will
show a cash spend-down of working capital. Largest cash increases will come from tax
settlements and state aids later in the year. The 2017 audit ended with six months working capital
available to fund the first part of 2018 until the larger cash proceeds are received..
FUNDS REPORT:
- The General fund spent 23% of the 2018 expenditure budget and received 3% of the revenue
budget. Expenditures and revenues are mainly operational in nature.
- The Enterprise Funds represent 1 month utility billing revenue collected while expenses
represent three months of activity. Overall, 13% of expenses have been incurred (less
depreciation); 4% 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 $4,700, including fees collected for a connection fee from a homeowner that
was sewer only (final partial payment). Water revenues represent 4%, expenses 14% of the budget at the
end of March.
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 $0
for the first quarter. Sewer connections will pick up as the weather warms. A couple projects are going
through plan review currently. Sewer expenses are at 10% of the budget, while revenues are at 4% of the
budget.
½ ¢ Sales Tax (fund 200): The sales tax fund has a cash balance of $1,017,777. The City anticipates
collecting $4,250,000 in sales tax revenue through 2018 ($3,372,754 original estimate); $3,820,946 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 expenditures total $1,182,594 for the projects approved by Council.
CIP REPORTS:
- General capital equipment purchases include: Public Works truck replacement and computer
replacements.
- The Park Board began the East Park design with S.E.H..
BUDGET/FISCAL IMPACT: Information Only – Final audited 12/31/17 statements will be presented
in May 2018.
ATTACHMENTS: Request for Council Action – Quarterly and March Financial Reports
1st Quarter Reports:
Cash Position as of 3/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
Quarterly Sewer 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 financial reports.
avg
Total SB
avg
Total CMCU
Total Deposits2,966,887$
avg
avg
Total MS
Total Investments3,906,109$
ağƩƉĻƷ
{ğǝźƓŭƭ
{ĻĭǒƩźƷźĻƭ
aƚƓĻǤ/5ƭ/5ƭ
ağƩƉĻƷ
/5ƭ
/ŷĻĭƉźƓŭaƚƓĻǤ.ğƓƉ.ƩƚƉĻƩĻķDƚǝĻƩƓƒĻƓƷ.ƩƚƉĻƩĻķ.ƩƚƉĻƩĻķ
ЍЊі
Ͳ
Ќі
ЋͲБАЉͲЋБЊ
Ͳ
ЊАЎͲЉЉЉ
Њі
Љі
Ͳ
IƚƌķźƓŭƭ
ЏͲЌЋБ
ΛАБͲЌВЍΜͲ
ЍіЍі
ͲͲ
ЋВЎͲБЋЍЋВЎͲБЋЍ
LƓǝĻƭƷƒĻƓƷ
ğƓķ
/ğƭŷ
ЎЊі
Ͳ
ЌͲЏЉЌͲВЎА
BudgetActual
Budget
BudgetActual
ExpExpRevRevRev
227
,
$92,227$92
$342,995
Fund
$22,999$22,999
Revenues
&
$346,465
Expenditures
Actual
to
$101,734
Budget
FundFire
$2,975,850
Fire
&
General
$696,315
General
$2,969,350
$$
000
,
500
,
$500,000
$3,500,000$3,000,000$2,500,000$2,000,000$1500000$1$1,000,000
9ǣƦĻƓƭĻwĻǝĻƓǒĻ
υЊЏЉͲЉЉЉυͲ
υЊЍЍͲЏЌВ
υЊЍЋͲЌЏЌ
υЊЍЉͲЉЉЉυͲ
υЊЋЉͲЉЉЉυͲ
υЊЉЉͲЉЉЉυͲ
Activity
Funds
υБЉͲЉЉЉυͲ
υЎЏͲАЌВ
υЎЎͲАВЍ
υЏЉͲЉЉЉυͲ
Enterprise
υЍЋͲАЋБ
υЌЌͲВАЉ
υЍЉͲЉЉЉυͲ
ЊЊЊ
Ͳ
υЊВͲЏАЎ
υЊЋͲЋВВ
υЊЉЊЊЊυЊЉ
υЋЉͲЉЉЉυͲ
υЊЊЌ
υυ
er
t
a
Light
Sewer
WaterWtW
Refuse
Street
Storm
2018 Revenue Budget1,583,870.00 (includes fund 501)
2018 Expense Budget(1,408,350.00) (excludes depreciation,includes fund 5
The balances represent the cash balance as of 3/31/18.
2018 Revenue Budget1,281,170.00 (includes fund 501)
WTP1 expenses include contract to refurbish
2018 Expense Budget(1,012,550.00) (excludes depreciation, includes 501)
The balances represent the cash balance as of 3/31/18
$500,000 MSAS advanced$40,000 Lion's donation$4M donations estimated
(2,000,000.00)
Less: Bonded ProjectsCommitted - to be funded
As of March 31, 2018
Totals
Maximum Funding Available
Sales Tax Funding
uncommitted annually (5 yr Average)
Anticipated 2018 December Balance including funding commitments
Projects that have been discussed for
anticipated remaining 2018 sales tax revenues to collect425,000.00Committed - to be funded
1
Cash Balances Only
Current Period: March 2018
MTDMTDCurrent
FUND DescrAccountBegin YrDebitCreditBalance
Last Dim 10100
GeneralG 101-10100$1,835,385.36$33,538.33$336,751.77$1,165,172.30
Employee Retirement ReserveG 102-10100$115,843.34$0.00$0.00$115,843.34
Fire FundG 105-10100$521,806.17$22,705.98$15,476.67$538,752.35
Cable Access FeeG 108-10100$33,717.49$974.01$0.00$35,654.69
Economic DevelopmentG 150-10100$27,549.20$5.65$10,282.28$1,456.89
TIF 3-1 CMCUG 152-10100$2,759.65$0.85$1.71$2,755.81
TIF 4-1 Fortitude Senior AptsG 153-10100$2,136.02$0.65$1.33$2,134.16
TIF 2-1 MillstreamG 157-10100$23,356.90$7.20$14.52$23,334.84
TIF 2-2 Meat MarketG 158-10100$332.52$0.11$0.21$332.25
TIF 2-3 Bayou Blues/Alley FlatG 159-10100$119.95$0.04$0.07$119.80
State Collected Sales TaxG 200-10100$961,315.04$1,946.37$2,323.13$1,017,777.17
Park DedicationG 205-10100$121,019.37$47.80$2,816.68$118,068.25
Charitable GamblingG 215-10100$2,084.77$0.64$1.30$2,082.91
Lodging TaxG 220-10100$20,177.02$840.17$12.79$22,108.67
DEED CDAP GrantG 225-10100$11,126.43$3.05$6.16$9,283.86
Revolving Loan FundG 250-10100$205,554.66$63.35$162.71$205,264.47
2016 CIP Bonds \[govt center\]G 301-10100$17,890.40$5.62$11.34$18,400.86
2017A CIP Bonds \[Gov Center\]G 303-10100$55,005.64$16.93$34.12$54,822.88
2016 Street Impr \[Field St\]G 304-10100$190,459.50$50.47$7,383.38$104,671.95
2017B Impr Bonds \[CBD AlleysG 305-10100$44,961.76$33.24$67.02$44,753.21
2018 Equip CertificatesG 306-10100$0.00$25.37$5,626.15$5,255.82
2010B Refundin \[Hill/Clover\]G 333-10100$108,556.26$33.47$67.46$108,438.39
2011A CO Refund\[Interior St\]G 338-10100$100,177.59$30.99$5,877.48$94,809.17
2009B GO CIP BondsG 343-10100$10,633.34$3.29$6.64$10,693.53
2010B Street Impr \[16th Ave\]G 345-10100$169,832.48$52.34$105.52$169,613.14
2011A Pumper Truck CertificatG 346-10100$27.97$3,382.21$1,782.36$7,271.52
2011A GO CIP Bonds\[roof/gar\]G 347-10100$3,319.92$1.01$862.04$2,412.43
2013 Street Improve BondsG 348-10100$110,704.94$34.12$68.77$110,532.00
2013 Equipment CertificatesG 349-10100$7,044.14$2.18$4.40$7,087.05
2014 Street Impr \[ParkTerraceG 350-10100$249,175.21$76.86$154.93$249,130.47
2015 Street\[Clinton/Northland\]G 351-10100$146,996.79$45.36$91.45$147,076.38
2015 Equipment CertificatesG 352-10100$1,527.89$0.52$1.05$1,757.18
2015 Abatement Bonds\[KenneG 353-10100$20,204.35$6.22$12.53$20,120.78
Debt Service ReliefG 390-10100$392,280.94$0.00$60,857.71$329,725.92
Community Center phase IG 402-10100$1,884.67$25.64$1.29$2,457.52
2017 CBD Alley Improve ph 1G 405-10100$62,955.96$0.00$176.70$62,779.26
2018 Equip CertificatesG 406-10100$0.00$8,000.00$48,287.55$195,776.85
Capital OutlayG 490-10100$347,121.83$0.00$64.56$345,327.06
WAC FundG 501-10100$241,291.01$4,774.39$149.98$245,836.50
SAC FundG 502-10100$6,318.77$1.96$3.94$6,341.78
Water FundG 601-10100$670,381.85$52,064.95$55,140.31$693,564.53
Sewer FundG 602-10100$2,345.84$58,335.63$147,513.42$33,833.53
Refuse CollectionG 603-10100$257,764.40$15,937.69$27,795.20$245,826.95
Storm Water UtilityG 651-10100$280,964.44$3,442.91$14,945.31$274,653.64
Street Light UtilityG 652-10100$23,576.76$3,005.68$10,657.12$19,884.07
Last Dim 10100$7,407,688.54$209,523.25$755,601.06$6,872,996.13
Last Dim 10200
GeneralG 101-10200$275.00$0.00$0.00$275.00
Last Dim 10200$275.00$0.00$0.00$275.00
Cash Balances Only
Current Period: March 2018
MTDMTDCurrent
FUND DescrAccountBegin YrDebitCreditBalance
$7,407,963.54$209,523.25$755,601.06$6,873,271.13
Council Month End Revenue Summary
Current Period: March 2018
2018March2018
FUNDFUND DescrYTD Budget2018 AmtYTD Amt
101General$2,961,415.00$28,052.57$100,449.58
102Employee Retirement Reserve$6,500.00$0.00$0.00
105Fire Fund$342,995.00$22,342.66$92,227.47
108Cable Access Fee$7,935.00$974.01$1,284.42
150Economic Development$119,025.00-$5.74-$281.89
152TIF 3-1 CMCU$0.00-$0.86-$7.80
153TIF 4-1 Fortitude Senior Apts$0.00-$0.68-$4.40
157TIF 2-1 Millstream$0.00-$7.32-$76.47
158TIF 2-2 Meat Market$0.00-$0.10-$1.63
159TIF 2-3 Bayou Blues/Alley Flat$0.00-$0.03-$0.15
200State Collected Sales Tax$425,000.00$1,946.37-$53.63
205Park Dedication$35,240.00-$27.38-$383.91
215Charitable Gambling$0.00-$0.66-$6.99
220Lodging Tax$0.00$827.38$1,354.25
225DEED CDAP Grant$0.00-$3.11-$27.57
250Revolving Loan Fund$0.00-$64.36-$355.19
3012016 CIP Bonds \[govt center\]$270,005.00-$5.72-$325.85
3032017A CIP Bonds \[Gov Center\]$55,500.00-$17.19-$76.26
3042016 Street Impr \[Field St\]$55,290.00-$51.28-$2,053.28
3052017B Impr Bonds \[CBD Alleys\]$48,085.00-$33.78-$244.61
3062018 Equip Certificates$0.00-$25.78$16,513.82
3332010B Refundin \[Hill/Clover\]$178,360.00-$33.99-$472.84
3382011A CO Refund\[Interior St\]$118,950.00-$31.49-$389.53
3432009B GO CIP Bonds$57,050.00-$3.35-$44.78
3452010B Street Impr \[16th Ave\]$41,120.00-$53.18-$617.94
3462011A Pumper Truck Certificate$43,660.00$3,379.85$9,095.17
3472011A GO CIP Bonds\[roof/gar\]$23,035.00-$1.03-$12.21
3482013 Street Improve Bonds$20,585.00-$34.65-$411.26
3492013 Equipment Certificates$57,065.00-$2.22-$43.99
3502014 Street Impr \[ParkTerrace\]$101,395.00-$78.07-$1,037.20
3512015 Street\[Clinton/Northland\]$44,160.00-$46.09-$646.61
3522015 Equipment Certificates$37,005.00-$0.53-$56.51
3532015 Abatement Bonds\[Kennedy\]$160,185.00-$6.31-$101.31
390Debt Service Relief$28,000.00$0.00$0.00
402Community Center phase I$0.00$24.35$571.03
4052017 CBD Alley Improve ph 1$0.00$0.00$0.00
4062018 Equip Certificates$0.00$8,000.00$256,460.40
490Capital Outlay$77,320.00$0.00$0.00
501WAC Fund$0.00$4,624.41$4,115.75
502SAC Fund$162,500.00-$1.98-$16.40
601Water Fund$1,281,170.00$47,586.49$42,727.88
Council Month End Revenue Summary
Current Period: March 2018
2018March2018
FUNDFUND DescrYTD Budget2018 AmtYTD Amt
602Sewer Fund$1,421,370.00$57,296.01$56,739.14
603Refuse Collection$280,200.00$12,870.32$12,299.16
651Storm Water Utility$60,940.00$3,261.49$113.49
652Street Light Utility$80,815.00$2,985.99$10,111.41
$8,601,875.00$193,635.02$596,312.76
Council Month End Revenue -General Fund
Current Period: March 2018
2018March2018
FUNDFUND DescrSOURCE DescrYTD Budget2018 AmtYTD Amt
FUND 101 General
101GeneralCurrent Ad Valorem Taxes$1,282,660.00$0.00$0.00
101GeneralSpecial Levy- City St. Joe$0.00$0.00$0.00
101GeneralState Sales Tax$0.00-$1,076.39-$1,043.32
101GeneralGas Franchise$31,210.00$0.00$0.00
101GeneralElectric Franchise$58,335.00$1,930.78$3,841.10
101GeneralLicenses & Permits$10,000.00$0.00$10,200.00
101GeneralBeer$1,950.00$0.00$125.00
101GeneralLiquor$29,135.00$250.00$250.00
101GeneralOutdoor Liquor Permit$1,775.00$1,250.00$1,750.00
101GeneralGambling Permits$375.00$80.00$160.00
101GeneralAmusement/Hunt/Peddler/Golf$1,400.00$0.00$160.00
101GeneralExcavation Permit$500.00$50.00$200.00
101GeneralCigarette License$675.00$0.00$62.50
101GeneralCable Franchise Fee$34,000.00$1,245.27$2,499.13
101GeneralBuilding Permits$115,000.00$699.65$2,164.47
101GeneralAnimal License$3,400.00$1,500.00$1,570.00
101GeneralRental Housing Registration$30,305.00$0.00$0.00
101GeneralFederal Grants - Other$12,000.00$0.00$0.00
101GeneralState Grants and Aids$1,100.00$0.00$0.00
101GeneralLocal Government Aid$989,464.00$0.00$0.00
101GeneralPERA Rate Increase Aid$1,541.00$0.00$0.00
101GeneralPolice Training Reim$3,500.00$0.00$0.00
101GeneralState Municipal Funds Aid$50,000.00$0.00$28,049.00
101GeneralState Police Aid$62,000.00$0.00$0.00
101GeneralOther Grants/Aids$0.00$0.00$0.00
101GeneralOther Governmental Unit$10,000.00$0.00$5,000.00
101GeneralCounty Grants - Road Maint.$6,500.00$0.00$0.00
101GeneralZoning and Subdivision Fee$5,000.00$1,110.00$3,910.00
101GeneralLand Use Deposit Fee$4,000.00$3,750.00$4,100.00
101GeneralSale of Maps and Publications$50.00$0.00$6.60
101GeneralAssessments Search$4,000.00$390.00$1,170.00
101GeneralSpecial Hearing$5,500.00$0.00$0.00
101GeneralAdministration Reimb$12,745.00$0.00$7.20
101GeneralWeed Cutting$500.00$0.00$0.00
101GeneralAdmission Fee$1,000.00$0.00$0.00
101GeneralShelter/Room Rental Fees$7,500.00$455.00$3,865.00
101GeneralBall Field Donation$100.00$0.00$0.00
101GeneralSchneider Field Rental$1,500.00$0.00$0.00
101GeneralRents and Royalties$53,450.00$5,089.40$15,268.20
101GeneralKennel Fees$500.00$0.00$80.00
Council Month End Revenue -General Fund
Current Period: March 2018
2018March2018
FUNDFUND DescrSOURCE DescrYTD Budget2018 AmtYTD Amt
101GeneralCounty Fines$40,000.00$2,082.50$4,733.98
101GeneralPolicy Fines$15,000.00$6,460.00$9,443.20
101GeneralAccident Report Fee$1,200.00$167.25$410.00
101GeneralSeized Property$500.00$1,378.00$1,523.00
101GeneralSpecial Assessments$3,000.00$0.00$0.00
101GeneralInterest Earnings$20,000.00-$665.84-$7,011.24
101GeneralInterest Charges$200.00$0.00$0.00
101GeneralCo-op Dividend - LMCIT$14,000.00$0.00$0.00
101GeneralWater Tower Antenna Lease$3,930.00$323.95$810.45
101GeneralAdvertising$1,200.00$0.00$200.00
101GeneralContributions - General$500.00$100.00$5,396.00
101GeneralContributions - Parks$500.00$10.00$22.67
101GeneralSurplus Property$0.00$0.00$0.00
101GeneralReimbursement$28,715.00$1,473.00$1,526.64
101GeneralTransfers from Other Funds$0.00$0.00$0.00
FUND 101 General$2,961,415.00$28,052.57$100,449.58
FUND 102 Employee Retirement Reserve
102Employee Retirement ResTransfers from Other Funds$6,500.00$0.00$0.00
FUND 102 Employee Retirement Reserve$6,500.00$0.00$0.00
FUND 108 Cable Access Fee
108Cable Access FeeCable Franchise Fee$7,935.00$974.01$1,284.42
108Cable Access FeeTransfers from Other Funds$0.00$0.00$0.00
FUND 108 Cable Access Fee$7,935.00$974.01$1,284.42
FUND 150 Economic Development
150Economic DevelopmentCurrent Ad Valorem Taxes$114,325.00$0.00$0.00
150Economic DevelopmentFederal Grants - Other$0.00$0.00$0.00
150Economic DevelopmentTIF/MIF Deposit$3,600.00$0.00$0.00
150Economic DevelopmentInterest Earnings$1,100.00-$5.74-$281.89
150Economic DevelopmentTransfers from Other Funds$0.00$0.00$0.00
FUND 150 Economic Development$119,025.00-$5.74-$281.89
FUND 490 Capital Outlay
490Capital OutlayCurrent Ad Valorem Taxes$77,320.00$0.00$0.00
490Capital OutlayFederal Grants - Other$0.00$0.00$0.00
490Capital OutlaySurplus Property$0.00$0.00$0.00
FUND 490 Capital Outlay$77,320.00$0.00$0.00
$3,172,195.00$29,020.84$101,452.11
Council Month End Revenue -Enterprise Funds
Current Period: March 2018
FUND2018March2018
FUNDDescrSOURCE DescrYTD Budget2018 AmtYTD Amt
FUND 601 Water Fund
601Water FundPenalties and Forfeited Disc$8,110.00$365.93$1,535.61
601Water FundGeneral Oblig. Bond Proceeds$0.00$0.00$0.00
601Water FundTransfers from Other Funds$207,000.00$0.00$0.00
601Water FundContributed Revenue$0.00$0.00$0.00
601Water FundMDS Test Fee$12,250.00$654.32$695.14
601Water FundCurrent Ad Valorem Taxes$22,500.00$0.00-$326.52
601Water FundWater Meter$5,000.00$0.00$0.00
601Water FundConnection/Reconnection fees$0.00$0.00$0.00
601Water FundUndesignated Funds$0.00-$2,403.84-$1,381.51
601Water FundBulk Water$2,500.00$364.25$147.25
601Water FundState Grants and Aids$0.00$0.00-$48.00
601Water FundWater Line Charge$319,230.00$17,095.46$17,992.95
601Water FundState Sales Tax$0.00$80.31-$3,203.27
601Water FundRate Class One$635,545.00$28,727.46$21,666.14
601Water FundSpecial Assessments$400.00$0.00-$834.23
601Water FundInterest Earnings$33,250.00-$212.96-$2,220.05
601Water FundAmortization of Bond Premium$0.00$0.00$0.00
601Water FundWater Tower Antenna Lease$35,385.00$2,915.56$8,704.37
601Water FundSurplus Property$0.00$0.00$0.00
601Water FundReimbursement$0.00$0.00$0.00
FUND 601 Water Fund$1,281,170.00$47,586.49$42,727.88
FUND 602 Sewer Fund
602Sewer FundSanitary Sewer Service$852,535.00$33,609.62$34,755.68
602Sewer FundOther Governmental Unit$0.00$0.00$0.00
602Sewer FundSpecial Assessments$400.00$0.00-$83.74
602Sewer FundInterest Earnings$15,000.00-$451.41-$4,459.17
602Sewer FundAmortization of Bond Premium$0.00$0.00$0.00
602Sewer FundContributions - General$0.00$0.00$0.00
602Sewer FundSurplus Property$0.00$0.00$0.00
602Sewer FundState Grants and Aids$0.00$0.00-$39.00
602Sewer FundReimbursement$4,000.00$0.00$0.00
602Sewer FundPenalties and Forfeited Disc$7,500.00$347.83$1,579.10
602Sewer FundSewer Line Charge$541,935.00$23,789.97$24,986.27
602Sewer FundTransfers from Other Funds$0.00$0.00$0.00
602Sewer FundContributed Revenue$0.00$0.00$0.00
FUND 602 Sewer Fund$1,421,370.00$57,296.01$56,739.14
FUND 603 Refuse Collection
603Refuse CollecReimbursement$1,850.00$0.00$0.00
603Refuse CollecContributed Revenue$0.00$0.00$0.00
603Refuse CollecContributions - General$0.00$0.00$0.00
603Refuse CollecInterest Earnings$3,000.00-$79.96-$847.30
603Refuse CollecSpecial Assessments$200.00$0.00-$79.78
603Refuse CollecRefuse Collection Charges$269,450.00$13,475.58$14,471.45
603Refuse CollecState Grants and Aids$0.00$0.00-$5.00
603Refuse CollecLicenses & Permits$0.00$845.00$845.00
603Refuse CollecState Sales Tax$0.00-$1,574.05-$3,037.83
603Refuse CollecPenalties and Forfeifted Disc$5,700.00$203.75$952.62
FUND 603 Refuse Collection$280,200.00$12,870.32$12,299.16
Council Month End Revenue -Enterprise Funds
Current Period: March 2018
FUND2018March2018
FUNDDescrSOURCE DescrYTD Budget2018 AmtYTD Amt
FUND 651 Storm Water Utility
651Storm Water Contributed Revenue$0.00$0.00$0.00
651Storm Water Penalties and Forfeifted Disc$2,120.00$54.62$255.49
651Storm Water State Grants and Aids$0.00$0.00-$10.00
651Storm Water Development Fee$4,000.00$0.00$0.00
651Storm Water Interest Earnings$2,500.00-$88.75-$895.12
651Storm Water Special Assessments$400.00$0.00-$2,814.34
651Storm Water Rate Class One$51,920.00$3,295.62$3,577.46
FUND 651 Storm Water Utility$60,940.00$3,261.49$113.49
FUND 652 Street Light Utility
652Street Light UPenalties and Forfeited Disc$1,000.00$25.36$118.98
652Street Light UState Grants and Aids$0.00$0.00-$2.00
652Street Light USpecial Assessments$50.00$0.00-$16.90
652Street Light UInterest Earnings$400.00-$8.21-$80.02
652Street Light UContributions - General$0.00$0.00$7,000.00
652Street Light UReimbursement$3,000.00$0.00$0.00
652Street Light URate Class One$76,365.00$2,968.84$3,091.35
FUND 652 Street Light Utility$80,815.00$2,985.99$10,111.41
$3,124,495.00$124,000.30$121,991.08
Council Month End Expenditure - Summary
Current Period: March 2018
2018March2018
DescriptionYTD Budget2018 Amt YTD Amt
General$2,961,415.00$331,642.49$696,314.73
Employee Retirement Reserve$0.00$0.00$0.00
Fire Fund$346,465.00$15,113.35$22,998.58
Cable Access Fee$7,935.00$0.00$0.00
Economic Development$119,025.00$10,270.89$24,334.52
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,110,000.00$2,323.13$28,357.48
Park Dedication$143,190.00$2,741.50$2,929.50
Charitable Gambling$4,500.00$0.00$0.00
Lodging Tax$0.00$0.00$0.00
DEED CDAP Grant$0.00$0.00$1,834.00
Revolving Loan Fund$0.00$35.00$35.00
2016 CIP Bonds \[govt center\]$273,345.00$0.00$0.00
2017A CIP Bonds \[Gov Center\]$55,070.00$0.00$0.00
2016 Street Impr \[Field St\]$63,950.00$7,281.63$2,906.13
2017B Impr Bonds \[CBD Alleys\]$46,745.00$0.00$0.00
2018 Equip Certificates$0.00$5,575.00$11,258.00
2010B Refundin \[Hill/Clover\]$144,350.00$0.00$0.00
2011A CO Refund\[Interior St\]$141,730.00$5,815.00$5,815.00
2009B GO CIP Bonds$62,745.00$0.00$0.00
2010B Street Impr \[16th Ave\]$62,755.00$0.00$0.00
2011A Pumper Truck Certificate$43,660.00$1,780.00$1,780.00
2011A GO CIP Bonds\[roof/gar\]$21,820.00$860.00$860.00
2013 Street Improve Bonds$42,870.00$0.00$0.00
2013 Equipment Certificates$61,300.00$0.00$0.00
2014 Street Impr \[ParkTerrace\]$164,535.00$0.00$0.00
2015 Street\[Clinton/Northland\]$71,050.00$0.00$0.00
2015 Equipment Certificates$36,850.00$0.00$0.00
2015 Abatement Bonds\[Kenned$152,235.00$0.00$0.00
Debt Service Relief$141,000.00$60,857.71$62,626.71
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$176.70-$10,483.10
2018 Equip Certificates$0.00$48,287.55$60,683.55
Capital Outlay$77,320.00$64.56$64.56
WAC Fund$200,000.00$0.00$0.00
SAC Fund$96,090.00$0.00$0.00
Council Month End Expenditure - Summary
Current Period: March 2018
2018March2018
DescriptionYTD Budget2018 Amt YTD Amt
Water Fund$1,612,550.00$50,661.85$144,639.45
Sewer Fund$1,812,260.00$146,473.80$142,363.36
Refuse Collection$293,185.00$24,727.83$55,794.17
Storm Water Utility$256,405.00$14,763.89$33,970.06
Street Light Utility$80,975.00$10,637.43$19,674.78
$10,748,005.00$740,089.31$1,308,756.48
Council Month End Expenditure - General Fund
Current Period: March 2018
2018March2018
DescriptionDEPART DescrYTD Budget2018 Amt YTD Amt
FUND 101 General
GeneralCouncil$64,605.00$3,485.31$18,491.90
GeneralLegislative Committees$5,945.00$455.00$455.00
GeneralOrdinance & Proceedings$2,600.00$558.75$658.50
GeneralMayor$11,845.00$806.55$1,643.38
GeneralElections$2,500.00$0.00$0.00
GeneralGeneral Adminstration$269,605.00$30,565.59$70,655.71
GeneralFinance$139,945.00$9,936.69$31,495.86
GeneralAudit Service$30,000.00$22,000.00$22,000.00
GeneralAssessing$24,000.00$0.00$0.00
GeneralCity Attorney$18,000.00-$651.88-$151.88
GeneralPlanning and Zoning$76,065.00$13,398.35$23,389.75
GeneralGeneral Government$38,960.00$5,731.73$11,741.39
GeneralCity Offices$38,510.00$11,528.93$19,405.00
GeneralCable Access$6,390.00$261.48$892.08
GeneralCrime Control & Investigation$1,127,945.00$109,774.45$250,188.74
GeneralPolice Training$9,545.00$1,694.34$4,117.58
GeneralCommunication Service$12,780.00$480.64$1,443.73
GeneralAutomotive Services$57,360.00$7,411.03$8,974.84
GeneralBuilding Inspec. Admistration$95,200.00$0.00$7,500.00
GeneralEmergency Management$975.00$1,278.03$1,416.28
GeneralAnimal Control$815.00$125.49$403.99
GeneralStreet Maintanence$302,290.00$25,698.89$51,006.12
GeneralIce & Snow Removal$115,235.00$23,249.17$40,811.53
GeneralEngineering Fee$35,000.00$7,732.31$9,003.01
GeneralStreet Cleaning$14,095.00$25.64$140.37
GeneralSkate Park and Ice Rink$5,410.00$409.68$3,169.61
GeneralBall Park$1,750.00$0.00$0.00
GeneralMaintenance Shop$26,475.00$2,429.68$5,103.26
GeneralPark Areas$230,050.00$46,568.12$72,002.07
GeneralCommunity Center$63,115.00$6,688.52$7,113.83
GeneralOther Financing Uses$0.00$0.00$0.00
GeneralFire Protection$134,405.00$0.00$33,243.08
FUND 101 General$2,961,415.00$331,642.49$696,314.73
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,935.00$0.00$0.00
FUND 108 Cable Access Fee$7,935.00$0.00$0.00
Council Month End Expenditure - General Fund
Current Period: March 2018
2018March2018
DescriptionDEPART DescrYTD Budget2018 Amt YTD Amt
FUND 150 Economic Development
Economic DevelopmentEconomic Development Authority$119,025.00$10,270.89$24,334.52
Economic DevelopmentOther Financing Uses$0.00$0.00$0.00
FUND 150 Economic Development$119,025.00$10,270.89$24,334.52
FUND 490 Capital Outlay
Capital OutlayGeneral Adminstration$11,300.00$64.56$64.56
Capital OutlayCrime Control & Investigation$3,380.00$0.00$0.00
Capital OutlayCommunication Service$4,875.00$0.00$0.00
Capital OutlayAutomotive Services$13,595.00$0.00$0.00
Capital OutlayEmergency Management$1,500.00$0.00$0.00
Capital OutlayStreet Maintanence$3,750.00$0.00$0.00
Capital OutlayIce & Snow Removal$7,500.00$0.00$0.00
Capital OutlayStreet Cleaning$2,750.00$0.00$0.00
Capital OutlayMaintenance Shop$5,000.00$0.00$0.00
Capital OutlayPark Areas$23,670.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$77,320.00$64.56$64.56
$3,165,695.00$341,977.94$720,713.81
Council Month End Expense - Enterprise Funds
Current Period: March 2018
2018March2018
DescriptionDEPART DescrYTD Budget2018 Amt YTD Amt
FUND 601 Water Fund
Water FundBond Payment (P & I)$706,535.00$0.00-$12,161.00
Water FundOther Financing Uses$41,500.00$0.00$0.00
Water FundPower and Pumping$28,925.00$218.65$587.44
Water FundPurification-Plant 1$31,170.00$13,242.26$60,702.33
Water FundPurification-Plant 2$85,300.00$6,790.70$18,350.29
Water FundDistribution$10,000.00$0.00$5,843.97
Water FundWellhead Protection$3,000.00$0.00$0.00
Water FundStorage-Tower 1$15,890.00$521.79$1,284.68
Water FundWater Maintenance$262,325.00$26,412.71$54,424.22
Water FundAdministration and General$27,905.00$3,475.74$15,607.52
Water FundDepreciation Expense$400,000.00$0.00$0.00
FUND 601 Water Fund$1,612,550.00$50,661.85$144,639.45
FUND 602 Sewer Fund
Sewer FundBond Payment (P & I)$230,360.00$1,075.00-$41,547.00
Sewer FundOther Financing Uses$7,500.00$0.00$0.00
Sewer FundSanitary Sewer Maintenanc$209,845.00$16,095.22$26,129.00
Sewer FundLift Station-Baker Street$5,865.00$303.08$512.95
Sewer FundLift Station-Ridgewood/DBL$2,695.00$182.51$316.05
Sewer FundLift Station-Northland$4,665.00$156.40$249.44
Sewer FundLift Station-CR 121$5,340.00$297.28$460.47
Sewer FundLift Station-Main$813,930.00$124,858.57$135,383.40
Sewer FundAdministration and General$32,060.00$3,505.74$20,859.05
Sewer FundDepreciation Expense$500,000.00$0.00$0.00
FUND 602 Sewer Fund$1,812,260.00$146,473.80$142,363.36
FUND 603 Refuse Collection
Refuse CollectioWaste Collection$286,010.00$24,727.83$55,794.17
Refuse CollectioOther Financing Uses$500.00$0.00$0.00
Refuse CollectioDepreciation Expense$6,675.00$0.00$0.00
FUND 603 Refuse Collection$293,185.00$24,727.83$55,794.17
FUND 651 Storm Water Utility
Storm Water UtiOther Financing Uses$19,250.00$0.00$0.00
Storm Water UtiAdministration and General$14,165.00$2,609.39$7,984.70
Storm Water UtiStorm Water Maintenance$107,990.00$12,154.50$25,985.36
Storm Water UtiDepreciation Expense$115,000.00$0.00$0.00
FUND 651 Storm Water Utility$256,405.00$14,763.89$33,970.06
FUND 652 Street Light Utility
Street Light UtiliStreet Lighting$80,975.00$10,637.43$19,674.78
FUND 652 Street Light Utility$80,975.00$10,637.43$19,674.78
Council Month End Expense - Enterprise Funds
Current Period: March 2018
2018March2018
DescriptionDEPART DescrYTD Budget2018 Amt YTD Amt
$4,055,375.00$247,264.80$396,441.82
7,415.047,800.006,924.681,200.956,060.002,625.003,690.005,000.006,310.002,398.58
17,488.0418,302.8419,122.4535,001.9113,019.4331,618.2823,209.3633,837.0811,412.6114,000.0032,677.6866,816.6227,370.0089,770.87
112,054.96114,297.71186,667.31440,987.48199,533.17201,931.75
869,271.90
750.00500.00250.00500.00
2,500.002,500.002,600.003,050.007,500.003,380.004,875.001,500.001,200.001,500.003,000.002,750.007,500.005,000.003,400.003,000.00
18,900.0010,895.0023,350.0021,500.0017,270.0064,170.0056,100.0056,600.00
163,020.00
3/31
64.5664.56
207.80207.80
6,719.516,719.51
6,991.87
y
3/31through
201820182018Balance
1,284.421,284.42
29,480.5029,480.50
30,764.92
Summar
7
201
Plan
4,
0.95
2018
4,915.04
5,200.006,174.689,639.439,912.613,060.002,125.003,440.005,000.003,310.001,898.58
31,
14,988.0415,252.8411,687.0133,717.4991,935.1026,743.2821,709.3622,942.0890,947.7111,250.0025,177.6861,816.6223,970.0072,500.87
Availablethrough
135,894.61347,544.78136,713.66138,612.24
669,039.83
Expenditures
December
Equipment
March
of
Capital
Capital
As
adopted
2018
Fund
Final
General
CodeEquipmentBalanceGrant
ProjectBudgetReserveTransferred/SpentBudgetRemaining
DepartmentAccount
SoftwareProjects
EDAEDA
4,632.79 4,632.79 1,953.958,376.622,127.57 2,127.57
12,228.58 12,228.58 28,312.40 28,312.40 59,759.5886,823.7777,250.0072,500.0020,001.0011,500.0014,592.1780,908.25 89,284.87 23,766.9211,450.00 16,689.34
(18,527.58)
344,380.47497,656.02
527.08 527.08527.08
750.00200.00 200.00
1,300.00 1,300.00 5,000.00 5,000.00 2,750.00 2,750.00 9,500.001,500.002,500.002,250.002,000.003,000.001,500.001,000.00
BudgetAdjustmentsSpentReserve
11,000.0010,000.00 39,500.00 10,000.00 13,000.00 25,500.00 28,000.0089,750.00
er with new tan
g
3,332.79 7,755.66 7,755.66 9,250.00 1,927.57
last lon
25,562.40 25,562.4076,284.87
y
(44,027.58)(11,310.66)
AvailableGrants/3/31Available304,880.47408,433.10
12/31/20173/31
- ma
#267,250.00
#371,000.00
#417,501.00
Van50,259.58
Radios70,908.25
Truck75,823.77
Repairs22,266.92
Rig
Truck
Wheeler1,203.95
MHz
Painting10,450.00
Computers3,332.79
Tanker
6
RescueGrass
3
Replacement12,592.17Replacement5,376.62Replacement1,927.57
Pumper
Ladder800
Building
PurchasedReplaceReserve
Building
Building
than
than
other
other
ReserveReserve
Hardware/Software
EquipmentEquipmentEquipmentEquipmentEquipmentEquipmentEquipmentEquipmentEquipmentEquipmentEquipmentEquipment
2018 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
CodeDepartmentObjectYearYearDescriptionFunds201820182018Funds
4222042220422204222042220422204222042220422504225042270422804228042280422204222042220
/ğƦźƷğƌ
42210
Account
105105105105105105105105105105105105105105105105105
105
ƚƷğƌ
e
500.00120.00500.00120.00
7,750.006,250.007,500.00
20,000.0011,750.0010,000.0014,150.0022,500.0010,560.0040,848.5027,000.0055,000.0014,000.0011,500.0011,500.0014,000.00
93,020.00
192,528.50
3/312018
of
as
/
Grants
60.0060.00
500.00500.00500.00500.00
3,000.001,000.005,000.005,000.003,000.002,300.002,300.002,200.00
20,000.0010,000.0015,000.0010,000.0020,000.00
45,060.0055,860.00
#
#
60.0060.00
4,750.005,250.009,150.007,560.007,000.00
########
11,250.0017,500.0025,848.5017,000.00
47,960.00
#########
2020
goinggoinggoinggoing
20212021
//
2018/20202018/2020
goingongoingongoingongoingon
new2020new2022new2022new2020new2022new2022
201720272006202120102020201620212008201720152020201420221995est.201520202016202120162021
20132013
onononon
2008/20092022
1984/20051984/2005
2006/20082006/2008
Study
LS14,000.00
LS9,200.00
LS9,200.00
LS11,800.00
St
s
LS35,000.00
Model
e
FoamingPlan
Work
RidgewoodBakerNorthlandCR121
Main
StudyStudy
Plan
System
Programmer
RateSewerRate
Replacement
Public
Planr
Maintenanc
pumpspumpspumpspumps
ExpansionExpansion
2017
BathroomsBathrooms
Roof
Meter
Protection
4,
Plan
UBUB
RepairsRepairs
SupplyDistributionTower
LiningTelevising/RootSample
Replacement
(1/4)(1/4)
12
#4/5
TankTank
BuildingBuilding
Expenditures
TruckFuelKlinefelterPWWaterWaterWellheadPrinterHandheldComprehensiveWaterWellWTPWTPTruckFuelSewerPWKlinefelterSewerComprehensiveComprehensivePrinterSewerPumpSubmersibleSubmersibleSubmersibleSubmersib
le
December
Equipment
Capital
180414011408180518031705140214031403140314031403
15031503
18041805180518051705140118031712140214031403
1403141114031411
2018
Adopted WTWTWTWTWTWTWTWTWTWTWT
Capital
PWPWPWPW
ENGWWWWENGWWWWWWWWWWWWWWWWWWWW
00000002000000000000001000000
5558525230303058583053225858555853525230303058585853535353
CodeNumberEquipmentYearYearBalance201820182018Balance
4944049440494404944049440494404943449490494904949049435494104942049421494504945049450494504945049450494504949049490494804948049471494704947249473
Enterprise
601601601601601601602602602602602602602602
601601601601601601601601602602602602602602602
ProjectProjectPurchaseReplaceReserveBudgetTransfersSpentAvailabl
DepartmentAccount WaterSewer
e
120.00120.00
1,000.006,692.62
6,812.62
14,050.0064,864.0053,000.0078,902.2424,000.00
24,000.00
211,936.24
3/312018
of
(6,326.20)
(6,326.20)
as
/
Grants
60.0060.00
500.00
1,000.002,000.001,000.001,000.007,000.00
1,060.007,000.00
11,000.00
15,560.00
#
#
60.0060.00
5,692.62
5,752.62
########
13,550.0069,190.2042,000.0077,902.2417,000.00
17,000.00
#########
goinggoinggoing
goingongoingongoingon
201620211997202020162021 202320252024202620302032
ononon
2002/20142023/2029
Cloud
St.
2
s
Compliance
Phase
Cloud
Cloud
Work
Lift
St.
St.
Schedule
(1/4)
#5
Public
Main
Improvements
r
&
SWPPP/Permit
2017
Train
#3
Plan
Loader
4,
Easements/Acquire
UBUB
Treatment
MS4
Quality
SweepeLighting
Mapping
End
Maintenance
Expenditures
PrinterUpdatePondAerialWaterStreetPropertyPrinterFrontStreetTreatmentTertiaryForcemain
December
Improvement
Capital
14071425
1705
1705171218051404140514061410
n/an/an/a
SL
2018SSSSSSSSSSSS
RF
Adopted
PWPW
1330000100888
Capital
58303053535851585853414141
CodeNumberEquipmentYearYearBalance201820182018Balance
49490499004990049900499004990049900432304323043160494804948049480
Enterprise
651651651651603603602
651651651652602602
Lighting
ProjectProjectbegincompleteReserveBudgetTransfersSpentAvailabl
DepartmentAccount StormwaterRefuseSt.Sewer
Millstream Shelter
phase 1 design
phase 1 dog park
thru 3/31/18
Thispageintentionally leftblank