HomeMy WebLinkAbout[04c] Treasurer's Report
Council Agenda Item 4c
MEETING DATE: May 15, 2017
AGENDA ITEM: Treasurer’s Report – April 2017
SUBMITTED BY: Finance
BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A
PREVIOUS COUNCIL ACTION: None
BACKGROUND INFORMATION:
Cash/investment reconciled through April 30, 2017. Budget to actual reports attached for Council review.
The cash and investment balance decreased $1,903,070 since the beginning of the year. The first few
months will show a spend-down of cash as we wait for state aids and tax settlements. Also, we continue
to spend down bond funds for the government center. Some TIF funds show deficits. This is normal
until increments start flowing in. The EDA fund is covering the deficits until TIF is received. The EDA
fund will be paid back. The CBD Alley project fund deficit will be recovered when bonds are issued if
the project moves forward.
The General fund spent 31% of the expenditure budget and received 4% of the revenue budget at the end
of April.
The Enterprise funds spent 17% (without depreciation) and received 13% of the revenue budget. The
utility bills represent the Jan/Feb usage. Expenses represent four months.
BUDGET/FISCAL IMPACT: None – Information Only
ATTACHMENTS: Request for Council Action – Treasurer’s Report
April 2017 Treasurer’s Reports:
Cash Balances
Month End Revenue Summary
Month End Revenue Summary – General Fund
Month End Revenue Summary – Enterprise Funds
Month End Expenditure summary
Month End Expenditure Summary – General Fund
Month End Expense Summary – Enterprise Funds
REQUESTED COUNCIL ACTION: Accept the Treasurer’s Report as presented.
Cash Balances Only
Current Period: April 2017
MTDMTDCurrent
FUND DescrAccountBegin YrDebitCreditBalance
Last Dim 10100
GeneralG 101-10100$1,766,671.46$25,982.60$238,721.62$945,273.59
Employee Retirement ReserveG 102-10100$99,763.34$0.00$0.00$115,843.34
Fire FundG 105-10100$563,122.18$66,203.81$11,048.78$605,371.55
Cable Access FeeG 108-10100$25,893.55$325.86$0.00$28,219.69
Economic DevelopmentG 150-10100$123,620.69$42.04$8,008.23$103,294.96
TIF 3-1 CMCUG 152-10100$154.37$0.00$0.00$154.37
TIF 4-1 Fortitude Senior AptsG 153-10100$1.38$0.00$0.00$2,279.50
TIF 2-1 MillstreamG 157-10100$20,737.15$7.67$0.00$20,851.25
TIF 2-2 Meat MarketG 158-10100$316.33$0.13$48.97$268.09
TIF 2-3 Bayou Blues/Alley FlatG 159-10100$30.97$0.00$0.00-$669.03
State Collected Sales TaxG 200-10100$1,481,459.54$0.00$26,232.82$1,517,511.80
Park DedicationG 205-10100$120,162.18$1,904.90$5,068.03$111,474.51
Charitable GamblingG 215-10100$2,067.07$0.79$0.00$2,071.85
Lodging TaxG 220-10100$7,675.51$1,101.08$0.00$9,158.09
DEED CDAP GrantG 225-10100$0.00$11,077.71$0.00$11,077.71
Revolving Loan FundG 250-10100$25,212.38$368.15$0.00$35,155.53
2016 CIP Bonds \[govt center\]G 301-10100$56,584.50$127.58$48,371.25$11,059.79
2016 Street Impr \[Field St\]G 304-10100$1,376.01$485.40$8,617.78-$5,881.93
GO Improve Bonds \[CBD AlleysG 305-10100$0.00$0.00$0.00$0.00
2009A CrossoverRefunding BoG 318-10100$159,645.38$61.19$5,075.00$155,402.39
2011A Refunding Fire HallG 331-10100$22,252.66$4,959.35$0.00$31,513.54
2010B Refundin \[Hill/Clover\]G 333-10100$157,765.71$60.34$5,923.75$152,369.04
2011A CO Refund\[Interior St\]G 338-10100$116,941.10$44.66$0.00$112,350.27
2009B GO CIP BondsG 343-10100$5,746.75$2.32$2,595.00$3,481.42
2010B Street Impr \[16th Ave\]G 345-10100$195,202.21$74.89$6,827.50$189,602.00
2011A Pumper Truck CertificatG 346-10100$3,525.84$3,234.71$0.00$7,866.91
2011A GO CIP Bonds\[roof/gar\]G 347-10100$59.72$0.03$0.00-$910.69
2013 Street Improve BondsG 348-10100$130,929.47$50.05$4,235.00$127,089.28
2013 Equipment CertificatesG 349-10100$7,430.98$2.95$1,150.00$6,564.07
2014 Street Impr \[ParkTerraceG 350-10100$182,088.00$137.67$25,817.50$157,606.00
2015 Street\[Clinton/Northland\]G 351-10100$31,684.84$90.65$5,805.00$27,121.72
2015 Equipment CertificatesG 352-10100$1,243.62$3.15$1,055.00$837.62
2015 Abatement Bonds\[KenneG 353-10100$12,168.01$4.65$22,167.50-$9,963.73
Debt Service ReliefG 390-10100$220,080.03$0.00$0.00$220,107.11
2016 Government CenterG 401-10100$663,617.86$0.00$5,413.45-$297,041.20
2016 Imp Field StG 404-10100$1,292,725.42$0.00$67,281.22$1,184,349.44
CBD Alley Improvements ph 1G 405-10100$0.00$0.00$15,359.09-$28,463.69
2014 Imp Park TerraceG 450-10100$174,269.28$0.00$0.00$174,269.28
2015 Street\[Clinton/Northland\]G 451-10100$208,291.12$0.00$0.00$207,502.18
2015 Equipment CertificatesG 452-10100$9,075.06$0.00$0.00$0.00
Capital OutlayG 490-10100$263,036.29$13,400.00$0.00$270,963.50
WAC FundG 501-10100$51,304.65$12.61$0.00$42,661.36
SAC FundG 502-10100$11,182.25$0.00$10.85-$24,973.80
Water FundG 601-10100$60,868.49$81,330.01$83,452.52$166,581.48
Sewer FundG 602-10100$5,777.56$159,774.55$104,089.28-$20,946.11
Refuse CollectionG 603-10100$247,661.61$36,325.00$29,236.04$251,639.92
Storm Water UtilityG 651-10100$241,498.11$9,000.93$6,223.20$249,865.64
Street Light UtilityG 652-10100$22,772.31$4,428.29$4,751.16$20,663.09
Last Dim 10100$8,793,692.94$420,625.72$742,585.54$6,890,622.70
Cash Balances Only
Current Period: April 2017
MTDMTDCurrent
FUND DescrAccountBegin YrDebitCreditBalance
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
$8,793,967.94$420,625.72$742,585.54$6,890,897.70
Council Month End Revenue Summary
Current Period: April 2017
2017April2017
FUNDFUND DescrYTD Budget2017 AmtYTD Amt
101General$2,742,755.00$22,884.67$104,669.27
102Employee Retirement Reserve$0.00$0.00$16,080.00
105Fire Fund$323,020.00$66,203.81$138,108.01
108Cable Access Fee$6,700.00$325.86$1,652.54
150Economic Development$95,320.00$42.04$69.33
152TIF 3-1 CMCU$0.00$0.00$0.00
153TIF 4-1 Fortitude Senior Apts$0.00$0.00$0.00
157TIF 2-1 Millstream$275.00$7.67$9.51
158TIF 2-2 Meat Market$5.00$0.13-$0.17
159TIF 2-3 Bayou Blues/Alley Flat$0.00$0.00$0.00
200State Collected Sales Tax$408,000.00$0.00$0.00
205Park Dedication$583,520.00$1,904.90$2,455.65
215Charitable Gambling$4,540.00$0.79$0.23
220Lodging Tax$0.00$1,101.08$1,104.05
225DEED CDAP Grant$0.00$11,077.71$11,077.71
250Revolving Loan Fund$10,500.00$368.15$1,293.90
3012016 CIP Bonds \[govt center\]$230,955.00$127.58$1,243.66
3042016 Street Impr \[Field St\]$63,585.00$485.40$1,188.00
305GO Improve Bonds \[CBD Alleys\]$0.00$0.00$0.00
3182009A CrossoverRefunding Bonds$199,480.00$61.19-$66.54
3312011A Refunding Fire Hall$56,700.00$4,959.35$9,845.61
3332010B Refundin \[Hill/Clover\]$65,560.00$60.34$65.05
3382011A CO Refund\[Interior St\]$124,670.00$44.66-$28.46
3432009B GO CIP Bonds$65,000.00$2.32-$12.81
3452010B Street Impr \[16th Ave\]$42,285.00$74.89$64.13
3462011A Pumper Truck Certificate$45,365.00$3,234.71$6,442.39
3472011A GO CIP Bonds\[roof/gar\]$26,000.00$0.03-$105.75
3482013 Street Improve Bonds$21,460.00$50.05$133.35
3492013 Equipment Certificates$57,075.00$2.95-$9.98
3502014 Street Impr \[ParkTerrace\]$108,230.00$137.67$74.74
3512015 Street\[Clinton/Northland\]$61,305.00$90.65$34.43
3522015 Equipment Certificates$32,005.00$3.15-$97.10
3532015 Abatement Bonds\[Kennedy\]$162,300.00$4.65-$11.33
390Debt Service Relief$0.00$0.00$0.00
4012016 Government Center$0.00$0.00$14,016.84
4042016 Imp Field St$0.00$0.00$0.00
405CBD Alley Improvements ph 1$0.00$0.00$0.00
4502014 Imp Park Terrace$0.00$0.00$0.00
4512015 Street\[Clinton/Northland\]$0.00$0.00$0.00
4522015 Equipment Certificates$0.00$0.00$0.00
490Capital Outlay$87,080.00$13,400.00$13,400.00
Council Month End Revenue Summary
Current Period: April 2017
2017April2017
FUNDFUND DescrYTD Budget2017 AmtYTD Amt
501WAC Fund$291,490.00$12.61$1,562.38
502SAC Fund$96,590.00-$10.85-$17.01
601Water Fund$1,408,355.00$79,755.78$146,016.47
602Sewer Fund$1,398,215.00$159,559.56$213,308.33
603Refuse Collection$294,170.00$34,240.39$51,042.95
651Storm Water Utility$110,125.00$8,983.65$9,357.93
652Street Light Utility$64,240.00$4,409.42$7,022.61
$9,286,875.00$413,606.96$750,989.92
Council Month End Revenue -General Fund
Current Period: April 2017
2017April2017
FUNDFUND DescrSOURCE DescrYTD Budget2017 AmtYTD Amt
FUND 101 General
101GeneralCurrent Ad Valorem Taxes$1,122,485.00$0.00$0.00
101GeneralSpecial Levy- City St. Joe$0.00$0.00$0.00
101GeneralState Sales Tax$0.00-$22.08$64.73
101GeneralGas Franchise$30,500.00$0.00$0.00
101GeneralElectric Franchise$55,800.00$1,856.19$5,576.00
101GeneralLicenses & Permits$0.00$0.00$4,500.00
101GeneralBeer$1,625.00$5.00$203.33
101GeneralLiquor$21,860.00$0.00$197.28
101GeneralOutdoor Liquor Permit$2,500.00$0.00$750.00
101GeneralGambling Permits$250.00$155.00$315.00
101GeneralAmusement/Hunt/Peddler/Golf$1,300.00$50.00$375.00
101GeneralExcavation Permit$500.00$0.00$150.00
101GeneralCigarette License$600.00$0.00$62.50
101GeneralCable Franchise Fee$33,300.00$1,287.95$3,889.29
101GeneralBuilding Permits$99,000.00$4,383.29$8,763.77
101GeneralAnimal License$3,400.00$240.00$250.00
101GeneralRental Housing Registration$26,000.00$333.28$333.28
101GeneralFederal Grants - Other$60,800.00$0.00$0.00
101GeneralState Grants and Aids$950.00$0.00$0.00
101GeneralLocal Government Aid$919,430.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$50,000.00$0.00$24,980.50
101GeneralState Police Aid$60,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.$4,500.00$0.00$0.00
101GeneralZoning and Subdivision Fee$5,000.00$0.00$800.00
101GeneralLand Use Deposit Fee$4,000.00$1,000.00$1,000.00
101GeneralSale of Maps and Publications$50.00$0.00$1.00
101GeneralAssessments Search$2,750.00$420.00$1,770.00
101GeneralSpecial Hearing$5,000.00$750.00$3,100.00
101GeneralAdministration Reimb$12,635.00$4.12$15.36
101GeneralWeed Cutting$500.00$0.00$0.00
101GeneralAdmission Fee$0.00$0.00$0.00
101GeneralShelter/Room Rental Fees$8,200.00$255.00$2,965.00
101GeneralBall Field Donation$250.00$0.00$0.00
101GeneralSchneider Field Rental$1,500.00$0.00$0.00
101GeneralRents and Royalties$53,450.00$4,324.42$15,037.39
101GeneralKennel Fees$700.00$0.00$0.00
Council Month End Revenue -General Fund
Current Period: April 2017
2017April2017
FUNDFUND DescrSOURCE DescrYTD Budget2017 AmtYTD Amt
101GeneralCounty Fines$28,000.00$5,362.40$9,464.12
101GeneralPolicy Fines$14,000.00$1,515.00$7,730.00
101GeneralAccident Report Fee$1,200.00$45.00$350.00
101GeneralSeized Property$1,000.00$0.00$157.25
101GeneralSpecial Assessments$3,000.00$0.00$152.38
101GeneralInterest Earnings$28,000.00$641.25$952.47
101GeneralInterest Charges$100.00$0.00$0.00
101GeneralCo-op Dividend - LMCIT$12,000.00$0.00$0.00
101GeneralWater Tower Antenna Lease$3,830.00$156.70$947.34
101GeneralAdvertising$1,700.00$0.00$200.00
101GeneralContributions - General$600.00$0.00$900.00
101GeneralContributions - Parks$1,200.00$42.07$60.13
101GeneralSurplus Property$12,000.00$0.00$0.00
101GeneralReimbursement$32,250.00$80.08$3,656.15
101GeneralTransfers from Other Funds$0.00$0.00$0.00
FUND 101 General$2,742,755.00$22,884.67$104,669.27
FUND 102 Employee Retirement Reserve
102Employee Retirement ResTransfers from Other Funds$0.00$0.00$16,080.00
FUND 102 Employee Retirement Reserve$0.00$0.00$16,080.00
FUND 108 Cable Access Fee
108Cable Access FeeCable Franchise Fee$6,700.00$325.86$1,652.54
108Cable Access FeeTransfers from Other Funds$0.00$0.00$0.00
FUND 108 Cable Access Fee$6,700.00$325.86$1,652.54
FUND 150 Economic Development
150Economic DevelopmentCurrent Ad Valorem Taxes$93,920.00$0.00$0.00
150Economic DevelopmentFederal Grants - Other$0.00$0.00$0.00
150Economic DevelopmentTIF/MIF Deposit$0.00$0.00$0.00
150Economic DevelopmentDEED Housing Reimbursement$0.00$0.00$0.00
150Economic DevelopmentInterest Earnings$1,400.00$42.04$69.33
150Economic DevelopmentTransfers from Other Funds$0.00$0.00$0.00
FUND 150 Economic Development$95,320.00$42.04$69.33
FUND 490 Capital Outlay
490Capital OutlayCurrent Ad Valorem Taxes$77,080.00$0.00$0.00
490Capital OutlayFederal Grants - Other$0.00$0.00$0.00
490Capital OutlayContributions - Parks$0.00$0.00$0.00
490Capital OutlaySurplus Property$10,000.00$13,400.00$13,400.00
490Capital OutlayReimbursement$0.00$0.00$0.00
490Capital OutlayTransfers from Other Funds$0.00$0.00$0.00
FUND 490 Capital Outlay$87,080.00$13,400.00$13,400.00
Council Month End Revenue -General Fund
Current Period: April 2017
2017April2017
FUNDFUND DescrSOURCE DescrYTD Budget2017 AmtYTD Amt
$2,931,855.00$36,652.57$135,871.14
Council Month End Revenue -Enterprise Funds
Current Period: April 2017
FUND2017April2017
FUNDDescrSOURCE DescrYTD Budget2017 AmtYTD Amt
FUND 601 Water Fund
601Water FundPenalties and Forfeited Disc$8,000.00$372.41$3,136.29
601Water FundCurrent Ad Valorem Taxes$23,500.00$0.00-$392.56
601Water FundTransfers from Other Funds$290,990.00$0.00$0.00
601Water FundContributed Revenue$0.00$0.00$0.00
601Water FundMDS Test Fee$12,085.00$1,097.51$1,760.24
601Water FundWater Meter$5,000.00$0.00$1,110.00
601Water FundConnection/Reconnection fees$200.00$0.00$0.00
601Water FundUndesignated Funds$0.00$10,116.96$19,075.15
601Water FundBulk Water$2,500.00$73.00$73.00
601Water FundSpecial Assessments$400.00$0.00-$604.53
601Water FundReimbursement$0.00$0.00$0.00
601Water FundSurplus Property$0.00$0.00$0.00
601Water FundState Sales Tax$0.00$274.80-$127.63
601Water FundWater Tower Antenna Lease$34,480.00$1,410.33$8,526.08
601Water FundAmortization of Bond Premium$0.00$0.00$0.00
601Water FundInterest Earnings$31,500.00$279.57-$286.04
601Water FundRate Class One$705,100.00$39,923.05$70,575.02
601Water FundWater Line Charge$294,600.00$26,208.15$43,171.45
FUND 601 Water Fund$1,408,355.00$79,755.78$146,016.47
FUND 602 Sewer Fund
602Sewer FundSurplus Property$0.00$0.00$0.00
602Sewer FundContributions - General$0.00$16.00$16.00
602Sewer FundAmortization of Bond Premium$0.00$0.00$0.00
602Sewer FundInterest Earnings$500.00$433.83$1,325.99
602Sewer FundSpecial Assessments$300.00$0.00$0.00
602Sewer FundOther Grants/Aids$0.00$0.00$0.00
602Sewer FundContributed Revenue$0.00$0.00$0.00
602Sewer FundSanitary Sewer Service$799,645.00$102,413.54$129,121.70
602Sewer FundOther Governmental Unit$1,500.00$0.00$0.00
602Sewer FundPenalties and Forfeited Disc$7,075.00$382.49$2,848.59
602Sewer FundSewer Line Charge$493,105.00$56,313.70$79,996.05
602Sewer FundTransfers from Other Funds$96,090.00$0.00$0.00
602Sewer FundReimbursement$0.00$0.00$0.00
FUND 602 Sewer Fund$1,398,215.00$159,559.56$213,308.33
FUND 603 Refuse Collection
603Refuse CollecPenalties and Forfeifted Disc$5,700.00$230.09$1,964.08
603Refuse CollecReimbursement$2,515.00$629.10$1,467.90
603Refuse CollecContributions - General$0.00$0.00$0.00
603Refuse CollecSpecial Assessments$400.00$0.00$0.00
603Refuse CollecContributed Revenue$0.00$0.00$0.00
603Refuse CollecRefuse Collection Charges$263,205.00$25,484.25$41,073.72
603Refuse CollecLicenses & Permits$18,350.00$7,325.00$8,725.00
603Refuse CollecState Sales Tax$0.00$478.38-$2,310.46
603Refuse CollecInterest Earnings$4,000.00$93.57$122.71
FUND 603 Refuse Collection$294,170.00$34,240.39$51,042.95
FUND 651 Storm Water Utility
651Storm Water Development Fee$5,000.00$0.00$0.00
651Storm Water Transfers from Other Funds$0.00$0.00$0.00
Council Month End Revenue -Enterprise Funds
Current Period: April 2017
FUND2017April2017
FUNDDescrSOURCE DescrYTD Budget2017 AmtYTD Amt
651Storm Water Penalties and Forfeifted Disc$2,090.00$66.43$512.41
651Storm Water Rate Class One$98,675.00$8,823.09$14,343.64
651Storm Water Contributed Revenue$0.00$0.00$0.00
651Storm Water Reimbursement$0.00$0.00$0.00
651Storm Water Special Assessments$360.00$0.00-$5,612.15
651Storm Water Interest Earnings$4,000.00$94.13$114.03
FUND 651 Storm Water Utility$110,125.00$8,983.65$9,357.93
FUND 652 Street Light Utility
652Street Light UTransfers from Other Funds$0.00$0.00$0.00
652Street Light USpecial Assessments$50.00$0.00$0.00
652Street Light UInterest Earnings$400.00$9.19$9.17
652Street Light UReimbursement$3,000.00$0.00$0.00
652Street Light URate Class One$60,190.00$4,369.04$6,771.15
652Street Light UPenalties and Forfeited Disc$600.00$31.19$242.29
FUND 652 Street Light Utility$64,240.00$4,409.42$7,022.61
$3,275,105.00$286,948.80$426,748.29
Council Month End Expenditure - Summary
Current Period: April 2017
2017April2017
DescriptionYTD Budget2017 Amt YTD Amt
General$2,792,755.00$234,125.80$857,976.28
Employee Retirement Reserve$0.00$0.00$0.00
Fire Fund$367,020.00$11,048.78$45,270.76
Cable Access Fee$2,010.00$0.00$0.00
Economic Development$95,320.00$8,008.23$18,505.03
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$48.97$48.97
TIF 2-3 Bayou Blues/Alley Flat$795.00$0.00$0.00
State Collected Sales Tax$1,187,050.00$26,232.82$52,076.87
Park Dedication$653,350.00$5,068.03$11,282.15
Charitable Gambling$4,500.00$0.00$0.00
Lodging Tax$0.00$0.00$0.00
DEED CDAP Grant$0.00$0.00$0.00
Revolving Loan Fund$0.00$0.00$0.00
2016 CIP Bonds \[govt center\]$271,945.00$48,371.25$48,371.25
2016 Street Impr \[Field St\]$28,855.00$8,617.78$8,617.78
GO Improve Bonds \[CBD Alleys$0.00$0.00$0.00
2009A CrossoverRefunding Bon$360,350.00$5,075.00$5,075.00
2011A Refunding Fire Hall$76,700.00$0.00$750.00
2010B Refundin \[Hill/Clover\]$142,050.00$5,923.75$5,923.75
2011A CO Refund\[Interior St\]$144,830.00$0.00$7,115.00
2009B GO CIP Bonds$64,800.00$2,595.00$2,595.00
2010B Street Impr \[16th Ave\]$63,855.00$6,827.50$6,827.50
2011A Pumper Truck Certificate$44,560.00$0.00$2,180.00
2011A GO CIP Bonds\[roof/gar\]$22,320.00$0.00$1,060.00
2013 Street Improve Bonds$43,670.00$4,235.00$4,235.00
2013 Equipment Certificates$57,500.00$1,150.00$1,150.00
2014 Street Impr \[ParkTerrace\]$161,835.00$25,817.50$25,817.50
2015 Street\[Clinton/Northland\]$66,810.00$5,805.00$5,805.00
2015 Equipment Certificates$32,310.00$1,055.00$1,055.00
2015 Abatement Bonds\[Kenned$154,835.00$22,167.50$22,167.49
Debt Service Relief$141,000.00$0.00$0.00
2016 Government Center$0.00$5,413.45$779,295.68
2016 Imp Field St$0.00$67,281.22$49,139.45
CBD Alley Improvements ph 1$0.00$15,359.09$28,463.69
2014 Imp Park Terrace$0.00$0.00$0.00
2015 Street\[Clinton/Northland\]$0.00$0.00-$77,555.00
2015 Equipment Certificates$0.00$0.00$9,075.06
Capital Outlay$87,080.00$0.00$6,795.00
Council Month End Expenditure - Summary
Current Period: April 2017
2017April2017
DescriptionYTD Budget2017 Amt YTD Amt
WAC Fund$290,990.00$0.00$0.00
SAC Fund$96,090.00$0.00$0.00
Water Fund$1,808,355.00$81,878.29$162,892.43
Sewer Fund$1,848,215.00$103,874.29$297,090.83
Refuse Collection$298,675.00$27,151.43$78,640.06
Storm Water Utility$260,740.00$6,205.92$21,929.93
Street Light Utility$71,970.00$4,732.29$15,564.67
$11,783,025.00$734,068.89$2,505,237.13
Council Month End Expenditure - General Fund
Current Period: April 2017
2017April2017
DescriptionDEPART DescrYTD Budget2017 Amt YTD Amt
FUND 101 General
GeneralCouncil$64,010.00$2,372.09$18,528.41
GeneralLegislative Committees$7,485.00$0.00$735.00
GeneralOrdinance & Proceedings$2,400.00$0.00$102.90
GeneralMayor$11,930.00$744.09$2,169.07
GeneralElections$750.00$0.00$1,291.19
GeneralGeneral Adminstration$249,295.00$20,257.79$82,201.82
GeneralFinance$130,230.00$9,151.13$36,229.57
GeneralAudit Service$28,000.00$7,950.00$27,450.00
GeneralAssessing$23,500.00$0.00$0.00
GeneralCity Attorney$18,000.00$0.00$245.00
GeneralPlanning and Zoning$71,925.00$27,327.72$47,362.05
GeneralGeneral Government$21,850.00$3,349.14$17,218.61
GeneralCity Offices$22,600.00$3,484.06$18,992.18
GeneralCable Access$10,950.00$675.89$1,981.06
GeneralCrime Control & Investigation$1,063,225.00$73,071.42$295,481.54
GeneralPolice Training$9,545.00$20.00$2,309.44
GeneralCommunication Service$12,390.00$915.02$3,451.16
GeneralAutomotive Services$54,050.00$134.85$6,195.84
GeneralBuilding Inspec. Admistration$94,000.00$7,500.00$22,500.00
GeneralEmergency Management$995.00$7.65$674.20
GeneralAnimal Control$815.00$0.00$275.50
GeneralStreet Maintanence$309,240.00$13,778.18$70,241.22
GeneralIce & Snow Removal$113,465.00$195.00$29,532.41
GeneralEngineering Fee$35,000.00-$516.14$4,113.54
GeneralStreet Cleaning$13,800.00$3,525.73$5,366.44
GeneralSkate Park and Ice Rink$5,590.00$40.58$2,254.33
GeneralBall Park$1,750.00$96.57$96.57
GeneralMaintenance Shop$21,315.00$1,531.94$7,198.99
GeneralPark Areas$224,015.00$14,641.73$59,641.64
GeneralCommunity Center$68,115.00$12,906.26$19,206.40
GeneralOther Financing Uses$0.00$0.00$13,000.00
GeneralFire Protection$102,520.00$30,965.10$61,930.20
FUND 101 General$2,792,755.00$234,125.80$857,976.28
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$2,010.00$0.00$0.00
FUND 108 Cable Access Fee$2,010.00$0.00$0.00
Council Month End Expenditure - General Fund
Current Period: April 2017
2017April2017
DescriptionDEPART DescrYTD Budget2017 Amt YTD Amt
FUND 150 Economic Development
Economic DevelopmentEconomic Development Authority$95,320.00$8,008.23$18,505.03
Economic DevelopmentOther Financing Uses$0.00$0.00$0.00
FUND 150 Economic Development$95,320.00$8,008.23$18,505.03
FUND 490 Capital Outlay
Capital OutlayGeneral Adminstration$9,350.00$0.00$0.00
Capital OutlayCrime Control & Investigation$3,450.00$0.00$0.00
Capital OutlayCommunication Service$7,350.00$0.00$0.00
Capital OutlayAutomotive Services$16,930.00$0.00$6,795.00
Capital OutlayEmergency Management$2,000.00$0.00$0.00
Capital OutlayStreet Maintanence$3,000.00$0.00$0.00
Capital OutlayIce & Snow Removal$7,800.00$0.00$0.00
Capital OutlayStreet Cleaning$6,000.00$0.00$0.00
Capital OutlayMaintenance Shop$7,000.00$0.00$0.00
Capital OutlayPark Areas$24,200.00$0.00$0.00
Capital OutlayOther Financing Uses$0.00$0.00$0.00
FUND 490 Capital Outlay$87,080.00$0.00$6,795.00
$2,977,165.00$242,134.03$883,276.31
Council Month End Expense - Enterprise Funds
Current Period: April 2017
2017April2017
DescriptionDEPART DescrYTD Budget2017 Amt YTD Amt
FUND 601 Water Fund
Water FundBond Payment (P & I)$618,775.00$61,811.25$51,509.25
Water FundOther Financing Uses$36,770.00$0.00$770.00
Water FundPower and Pumping$18,690.00$45.18$774.94
Water FundPurification-Plant 1$348,985.00$1,239.15$8,303.96
Water FundPurification-Plant 2$86,210.00$4,991.42$16,696.15
Water FundDistribution$10,000.00$0.00$8,388.76
Water FundWellhead Protection$3,000.00$0.00$0.00
Water FundStorage-Tower 1$15,630.00$342.00$2,706.85
Water FundWater Maintenance$238,235.00$10,997.66$61,584.97
Water FundAdministration and General$32,060.00$2,451.63$12,157.55
Water FundDepreciation Expense$400,000.00$0.00$0.00
FUND 601 Water Fund$1,808,355.00$81,878.29$162,892.43
FUND 602 Sewer Fund
Sewer FundBond Payment (P & I)$234,320.00$25,683.75$22,058.75
Sewer FundOther Financing Uses$37,540.00$0.00$1,540.00
Sewer FundSanitary Sewer Maintenanc$216,790.00$13,768.22$50,991.49
Sewer FundLift Station-Baker Street$92,390.00$237.06$868.19
Sewer FundLift Station-Ridgewood/DBL$2,810.00$148.48$554.96
Sewer FundLift Station-Northland$4,425.00$125.31$550.79
Sewer FundLift Station-CR 121$4,650.00$203.13$641.06
Sewer FundLift Station-Main$769,100.00$61,052.81$207,797.03
Sewer FundAdministration and General$36,190.00$2,655.53$12,088.56
Sewer FundDepreciation Expense$450,000.00$0.00$0.00
FUND 602 Sewer Fund$1,848,215.00$103,874.29$297,090.83
FUND 603 Refuse Collection
Refuse CollectioWaste Collection$291,230.00$27,151.43$77,870.06
Refuse CollectioOther Financing Uses$770.00$0.00$770.00
Refuse CollectioDepreciation Expense$6,675.00$0.00$0.00
FUND 603 Refuse Collection$298,675.00$27,151.43$78,640.06
FUND 651 Storm Water Utility
Storm Water UtiOther Financing Uses$19,250.00$0.00$0.00
Storm Water UtiAdministration and General$16,580.00$1,012.61$7,267.88
Storm Water UtiStorm Water Maintenance$109,910.00$5,193.31$14,662.05
Storm Water UtiDepreciation Expense$115,000.00$0.00$0.00
FUND 651 Storm Water Utility$260,740.00$6,205.92$21,929.93
FUND 652 Street Light Utility
Street Light UtiliStreet Lighting$71,970.00$4,732.29$15,564.67
FUND 652 Street Light Utility$71,970.00$4,732.29$15,564.67
Council Month End Expense - Enterprise Funds
Current Period: April 2017
2017April2017
DescriptionDEPART DescrYTD Budget2017 Amt YTD Amt
$4,287,955.00$223,842.22$576,117.92