HomeMy WebLinkAbout[09] Treasurers Report
9
Council Agenda Item
MEETING DATE:
May 2, 2013
st
AGENDA ITEM:
Financial Report – Requested Action: Accept the 1 Quarter 2013 and
March 2013 Financial Reports
SUBMITTED BY:
Finance
BOARD/COMMISSION/COMMITTEE RECOMMENDATION:
N/A
PREVIOUS COUNCIL ACTION:
Council accepted the January and February Financial Reports.
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, 2013. Audit reversals were reversed. The final 2012 year-end audit report will be presented at
th
the May 16 council meeting.
There are a couple points to highlight from the reports.
CASH POSITION
:
- The market rate of return is approximately 1.75%, slightly higher than the 10-year Treasury
Notes. The City’s rate of return is on par with other Minnesota cities, even marginally ahead of
some of the larger cities. It will likely be a couple years with lower rates yet. St. Joseph if
fortunate to have local financial institutions paying a higher rate of return on money market
funds. The bulk of the City’s cash is held locally. This is also positive for our financial
institutions. On the other hand, bond rates remain at historically lows as the City gets ready to
issue a couple debts this year.
- Overall, the cash and investments balance decreased $432,992 from the beginning of the year.
The cash decrease is expected for the first quarter as the City waits for the first half property tax
and state aid payments.
FUNDS REPORT
:
General fund
- The spent 23% of the 2013 budget and received 2% of the revenue budget.
Revenues will remain low until late June and July when taxes and state aids are received.
Expenditures are operational in nature. Snow removal is higher than anticipated for 2013. Staff
is monitoring the budget to ensure funds are available for the end of the year snow and ice events.
The capital budget was transferred to the General Capital Reserve account and Park Dedication
account for annually budgeted capital outlay. An additional transfer was made to the Street Light
Utility to begin operating the first four months of the year.
Enterprise Funds
- The show expenses more than revenues with exception of the water fund. The
reports show 3 months of expenses and approximately 1.5 months utility revenue received.
January/February utilities were billed, but will not be received until March and April. The street
light utility will begin billing with the May utility bills. The water fund shows the surplus as a
result of reversing audit entries. The expenses will change in the second quarter.
Water fund analysis (fund 601/501)
– The enclosed spreadsheet shows an analysis of the water fund for
2013. Included in the spreadsheet are the Water fund (601) and the Water Access fund (WAC-501). The
City has not received WAC and Trunk fees this year yet. The late winter has delayed some projects.
The water fund does show a cash surplus of $42,646 at the end of March. The first quarter shows
operational activity only. The second quarter will have first half interest payments. The City has the
funds to cover the June interest payments.
½ ¢ Sales Tax (fund 200):
The sales tax fund has a balance of $1,272,574 at the end of March. The City
anticipates collecting $3,000,000 in sales tax revenue through 2017; $1,829,756 collected to date. The
anticipated expenditures approved by Council totals $851,900 leaving approximately $2,148,100
remaining for future projects. I added lines of $1,500,000 for the community center and $500,000 for
phase 2 of the CR2 trail extension. This is just a representation that the Council is still looking at options
for a community center and phase 2 trail extension, but nothing is decided right now. The numbers are
just a place holder in the report.
CIP REPORTS:
st
- The 2013 CIP summary is included to show the capital expenditures through March 31. The
capital expenditures include storm water community training, police squad and EDA programs.
The expenditures have been budgeted for.
BUDGET/FISCAL IMPACT:
Information Only
ATTACHMENTS:
Request for Council Action – Quarterly and December Financial Reports
st
1 Quarter Reports:
Cash Position as of 3/31/13
Cash and Investment Holdings Chart
Cash Balances by Fund/Remaining Budget
General Budget to Actual Revenue Graph
General Budget to Actual Expenditures Graph
Enterprise Funds Activity Graph
Quarterly Water Fund Analysis
½ ¢ 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 Summary Reports:
General Fund Capital Improvement Plan – Summary
Fire Fund Capital Improvement Plan
Park Board Capital Improvement Plan – Summary
Capital Improvement Plan – Enterprise
REQUESTED COUNCIL ACTION:
Accept the financial reports as presented.
04/26/13 1:12 PM
CITY OF ST JOSEPH
Page 1
Cash Balances Onl
y
Current Period: March 2013
MTDMTDCurrent
FUND DescrAccountBegin YrDebitCreditBalance
Last Dim 10100
GeneralG 101-10100$1,144,450.61$44,339.36$196,490.69$660,514.41
Fire FundG 105-10100$504,034.02$893.01$8,568.90$529,058.66
Cable Access FeeG 108-10100$8,577.58$724.26$0.00$9,999.24
Economic DevelopmentG 150-10100$79,525.68$101.60$3,312.93$70,693.41
TIF 2-1 MillstreamG 157-10100$10,832.25$14.37$0.00$10,857.93
TIF 2-2 Meat MarketG 158-10100$30.02$0.00$0.00$30.02
State Collected Sales TaxG 200-10100$1,215,122.64$1,254.47$4,958.28$1,272,574.49
Park DedicationG 205-10100$70,749.08$113.09$237.18$73,517.52
Recreation CenterG 210-10100$27,308.67$36.21$0.00$27,348.61
Charitable GamblingG 215-10100$5,232.23$7.12$408.05$4,836.80
Revolving Loan FundG 250-10100$22,746.98$704.61$0.00$24,822.73
2009A CrossoverRefunding BonG 318-10100$434,664.74$577.50$0.00$436,962.41
2007 Refunding (98/99 St BonG 320-10100$197,678.52$262.01$0.00$198,000.88
City Hall Refunded, 2005G 322-10100$849.45$1.37$0.00$1,129.59
2011A Refunding Fire HallG 331-10100$119,430.28$164.76$3,600.00$123,358.48
2010B Refundin (Hill/Clover)G 333-10100$376,176.86$499.79$0.00$378,170.09
2011A CO Refund (Interior Sts)G 338-10100$244,075.81$324.36$0.00$245,450.72
2007 St Imprv-E Side/Jade/8 AG 341-10100$140,707.28$673.04$0.00$141,730.12
2008 Equipment CertificatesG 342-10100$12,215.54$16.33$0.00$12,387.85
2009B GO CIP BondsG 343-10100$4,271.68$5.79$0.00$4,424.10
2010 Equipment CertificatesG 344-10100$2,396.76$3.15$0.00$2,383.54
2010B Street Impr (16th Ave)G 345-10100$245,516.01$320.79$116.67$235,269.05
2011A Pumper Truck CertificatG 346-10100$1,102.54$19.25$3,680.00$3,057.39
2011A GO CIP BondsG 347-10100$14,173.45$749.12$1,860.00$13,586.62
2013 Street Improve BondsG 348-10100$0.00$0.00$0.00$0.00
2013 Equipment CertificatesG 349-10100$0.00$0.00$0.00$0.00
Debt Service ReliefG 390-10100$508,858.85$0.00$465.10$508,393.75
2007 Street Impr (Jade Rd/EG 441-10100$366,958.57$0.00$0.00$366,958.57
2011A GO CIP BondsG 447-10100$174,042.45$0.00$0.00$174,042.45
2013 Imp Cedar/Baker/RidgewG 448-10100$0.00$0.00$0.00$0.00
2013 Equipment CertificatesG 449-10100$0.00$0.00$0.00$0.00
Capital OutlayG 490-10100$219,824.55$0.00$6,000.00$236,484.55
Water ExtensionG 501-10100$27.37$18.33$0.00$20,758.95
Sewer ExtensionG 502-10100$565,381.43$759.09$0.00$577,321.62
Water FundG 601-10100$952.39$47,440.00$46,923.57$21,887.42
Sewer FundG 602-10100$275,956.66$33,464.99$74,299.77$189,289.32
Refuse CollectionG 603-10100$267,112.09$24,733.57$38,976.87$244,649.74
Storm Water UtilityG 651-10100$189,817.22$8,187.71$7,727.13$198,796.08
Street Light UtilityG 652-10100$0.00$3.39$4,671.57-$938.92
Last Dim 10100$7,450,800.26$166,412.44$402,296.71$7,017,808.19
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
Last Dim 10300
2011A CO Refund (Interior Sts)G 338-10300$1,452,878.26$0.00$0.00$1,442,063.26
Water FundG 601-10300$4,770,732.87$0.00$0.00$4,770,732.87
Last Dim 10300$6,223,611.13$0.00$0.00$6,212,796.13
$13,674,686.39$166,412.44$402,296.71$13,230,879.32
04/04/13 3:20 PM
CITY OF ST JOSEPH
Page 1
Council Month End Revenue Summar
y
Current Period: March 2013
2013March2013
FUNDFUND DescrYTD Budget2013 AmtYTD Amt
101General$2,274,225.00$24,196.94$22,694.08
105Fire Fund$258,675.00-$877.99$48,282.55
108Cable Access Fee$7,450.00$724.26$1,450.62
150Economic Development$126,595.00$101.60$108.20
157TIF 2-1 Millstream$0.00$14.37$13.25
158TIF 2-2 Meat Market$0.00$0.00$0.00
200State Collected Sales Tax$0.00$1,254.47$0.00
205Park Dedication$0.00$109.82$3,085.74
210Recreation Center$0.00$36.21$5.43
215Charitable Gambling$0.00$6.95$5.68
250Revolving Loan Fund$8,380.00$704.61$2,051.50
3182009A CrossoverRefunding Bonds$0.00$577.50$362.29
3202007 Refunding (98/99 St Bond)$0.00$262.01$116.27
322City Hall Refunded, 2005$0.00$1.37-$17.44
3312011A Refunding Fire Hall$55,050.00$164.76$7,388.73
3332010B Refundin (Hill/Clover)$0.00$499.79$315.52
3382011A CO Refund (Interior Sts)$0.00$324.36$186.72
3412007 St Imprv-E Side/Jade/8 Av$0.00$673.04$335.07
3422008 Equipment Certificates$0.00$16.33$5.14
3432009B GO CIP Bonds$0.00$5.79-$3.99
3442010 Equipment Certificates$0.00$3.15-$1.80
3452010B Street Impr (16th Ave)$0.00$320.79$244.78
3462011A Pumper Truck Certificate$42,980.00$19.25$5,462.47
3472011A GO CIP Bonds$0.00$749.12$1,105.72
390Debt Service Relief$0.00$0.00$0.00
4472011A GO CIP Bonds$0.00$0.00$0.00
490Capital Outlay$0.00$0.00$22,660.00
501Water Extension$0.00$18.33$4.78
502Sewer Extension$0.00$759.09$421.98
601Water Fund$1,381,790.00$40,311.91$24,254.03
602Sewer Fund$992,305.00$29,217.50$14,486.83
603Refuse Collection$303,710.00$17,746.26$9,012.71
651Storm Water Utility$124,645.00$7,039.79$4,454.42
652Street Light Utility$42,500.00$1.97$8,503.39
$5,618,305.00$124,983.35$176,994.67
04/04/13 3:16 PM
CITY OF ST JOSEPH
Page 1
Council Month End Expenditure - General Fund
Current Period: March 2013
2013March2013
DescriptionDEPART DescrYTD Budget2013 Amt YTD Amt
FUND 101 General
GeneralCouncil$47,165.00$6,889.81$12,396.62
GeneralLegislative Committees$6,195.00$16.94$151.79
GeneralOrdinance & Proceedings$1,350.00$502.17$1,897.13
GeneralMayor$10,960.00$826.85$1,722.71
GeneralElections$3,000.00$1,162.50$1,162.50
GeneralGeneral Adminstration$210,045.00$16,355.24$42,571.40
GeneralFinance$115,035.00$8,445.78$21,461.53
GeneralAudit Service$25,450.00$18,000.00$18,000.00
GeneralAssessing$20,000.00$0.00$0.00
GeneralCity Attorney$17,000.00-$27.00$1,746.50
GeneralPlanning and Zoning$1,850.00$289.75$289.75
GeneralGeneral Government$24,480.00$603.06$5,938.55
GeneralCity Offices$28,880.00$2,536.57$7,933.89
GeneralFacilites and Planning$0.00$0.00$0.00
GeneralCable Access$11,660.00$830.60$2,061.20
GeneralCrime Control & Investigation$860,935.00$55,339.90$174,414.51
GeneralPolice Training$7,000.00$4,028.06$4,805.81
GeneralCommunication Service$12,080.00$951.49$2,174.73
GeneralAutomotive Services$60,000.00$8,692.74$10,440.19
GeneralBuilding Inspec. Admistration$92,000.00$7,500.00$15,000.00
GeneralEmergency Management$1,300.00$207.70$315.95
GeneralSignal Lights CSAH 75$2,000.00$176.08$378.31
GeneralAnimal Control$1,150.00$23.51$193.06
GeneralOrdinance/Easement Enforcement$0.00$0.00$0.00
GeneralStreet Maintanence$217,195.00$13,895.74$50,508.58
GeneralIce & Snow Removal$91,700.00$17,620.19$52,651.13
GeneralEngineering Fee$35,000.00-$6,528.30$7,285.17
GeneralStreet Lighting$0.00$0.00$0.00
GeneralStreet Cleaning$14,255.00$68.29$130.86
GeneralSkate Park and Ice Rink$3,435.00$720.21$1,755.51
GeneralBall Park$1,800.00$0.00$0.00
GeneralMaintenance Shop$19,820.00$2,972.50$5,691.95
GeneralPark Areas$208,950.00$7,021.79$44,584.34
GeneralCommunity Support$0.00$0.00$0.00
GeneralOther Financing Uses$0.00$0.00$34,160.00
GeneralFire Protection$88,375.00$0.00$21,534.31
FUND 101 General$2,240,065.00$169,122.17$543,357.98
FUND 108 Cable Access Fee
Cable Access FeeCable Access$0.00$0.00$530.10
FUND 108 Cable Access Fee$0.00$0.00$530.10
FUND 150 Economic Development
04/04/13 3:16 PM
CITY OF ST JOSEPH
Page 2
Council Month End Expenditure - General Fund
Current Period: March 2013
2013March2013
DescriptionDEPART DescrYTD Budget2013 Amt YTD Amt
Economic DevelopmentEconomic Development Authority$126,595.00$3,312.93$6,566.36
Economic DevelopmentOther Financing Uses$0.00$0.00$0.00
FUND 150 Economic Development$126,595.00$3,312.93$6,566.36
FUND 490 Capital Outlay
Capital OutlayElections$0.00$0.00$0.00
Capital OutlayGeneral Adminstration$3,250.00$0.00$0.00
Capital OutlayGeneral Government$35,000.00$0.00$0.00
Capital OutlayCity Offices$35,000.00$0.00$0.00
Capital OutlayCable Access$0.00$0.00$0.00
Capital OutlayCrime Control & Investigation$0.00$0.00$0.00
Capital OutlayCommunication Service$1,150.00$0.00$0.00
Capital OutlayAutomotive Services$3,695.00$6,000.00$6,000.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$8,750.00$0.00$0.00
Capital OutlayStreet Lighting$5,000.00$0.00$0.00
Capital OutlayStreet Cleaning$0.00$0.00$0.00
Capital OutlaySkate Park and Ice Rink$0.00$0.00$0.00
Capital OutlayMaintenance Shop$2,190.00$0.00$0.00
Capital OutlayPark Areas$6,375.00$0.00$0.00
Capital OutlayOther Financing Uses$0.00$0.00$0.00
FUND 490 Capital Outlay$105,410.00$6,000.00$6,000.00
$2,472,070.00$178,435.10$556,454.44
04/04/13 3:19 PM
CITY OF ST JOSEPH
Page 1
Council Month End Revenue -General Fund
Current Period: March 2013
2013March2013
FUNDFUND DescrSOURCE DescrYTD Budget2013 AmtYTD Amt
FUND 101 General
101GeneralCurrent Ad Valorem Taxes$1,154,645.00$0.00$0.00
101GeneralSpecial Levy- City St. Joe$0.00$0.00$0.00
101GeneralState Sales Tax$0.00-$37.78$64.80
101GeneralGas Franchise$31,500.00$0.00$0.00
101GeneralElectric Franchise$51,300.00$1,742.28$3,486.17
101GeneralBeer$375.00$15.00$165.00
101GeneralLiquor$22,635.00$3,450.00-$5,750.00
101GeneralOutdoor Liquor Permit$2,500.00$1,500.00$1,500.00
101GeneralGambling Permits$120.00$80.00$160.00
101GeneralAmusement/Hunting Permit$1,000.00$0.00$0.00
101GeneralExcavation Permit$300.00$150.00$200.00
101GeneralCigarette License$525.00$0.00$0.00
101GeneralCable Franchise Fee$32,000.00$961.69$1,945.03
101GeneralBuilding Permits$40,000.00$2,445.17$3,660.25
101GeneralAnimal License$3,150.00$1,330.00$1,350.00
101GeneralRental Housing Registration$20,000.00$0.00$0.00
101GeneralFederal Grants - Other$5,000.00$0.00$0.00
101GeneralState Grants and Aids$965.00$0.00$0.00
101GeneralLocal Government Aid$645,150.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$6,180.00$0.00$3,772.50
101GeneralState Police Aid$45,000.00$0.00$0.00
101GeneralOther Grants/Aids$250.00$0.00$0.00
101GeneralOther Governmental Unit$10,000.00$0.00$5,000.00
101GeneralCounty Grants - Road Maint.$7,750.00$0.00$0.00
101GeneralZoning and Subdivision Fee$1,000.00$0.00$0.00
101GeneralLand Use Deposit Fee$4,000.00-$5,000.00$15,350.00
101GeneralSale of Maps and Publications$50.00$2.00$7.10
101GeneralAssessments Search$2,500.00$270.00$690.00
101GeneralSpecial Hearing$4,500.00$0.00$1,600.00
101GeneralAdministration Reimb$11,600.00$92.00-$35,092.00
101GeneralWeed Cutting$1,000.00$660.00$660.00
101GeneralPark Fees$5,500.00$340.00$2,100.00
101GeneralBall Field Donation$500.00$0.00$0.00
101GeneralSchneider Field Rental$2,700.00$0.00$0.00
101GeneralKennel Fees$700.00$50.00$175.00
101GeneralCounty Fines$27,000.00$2,665.98$3,986.78
101GeneralPolicy Fines$35,000.00$1,105.00$3,905.00
101GeneralAccident Report Fee$1,000.00$15.00$155.50
101GeneralSeized Property$500.00$370.75$813.50
101GeneralSpecial Assessments$1,500.00$0.00$0.00
04/04/13 3:19 PM
CITY OF ST JOSEPH
Page 2
Council Month End Revenue -General Fund
Current Period: March 2013
2013March2013
FUNDFUND DescrSOURCE DescrYTD Budget2013 AmtYTD Amt
101GeneralInterest Earnings$18,000.00$1,625.78$1,737.71
101GeneralInterest Charges$100.00$94.34-$7.88
101GeneralCo-op Dividend - LMCIT$10,000.00$0.00$0.00
101GeneralWater Tower Antenna Lease$3,550.00$430.85$855.12
101GeneralLand Rental$0.00$0.00$0.00
101GeneralAdvertising$2,000.00$200.00$450.00
101GeneralContributions - General$1,500.00$0.00$1.00
101GeneralContribution - Health Ins Div$19,090.00$0.00$0.00
101GeneralContributions - Parks$1,000.00$0.00$5.00
101GeneralSurplus Property$0.00$0.00$0.00
101GeneralReimbursement$32,550.00$9,638.88$9,748.50
101GeneralStreet Access Fee$0.00$0.00$0.00
101GeneralTransfers from Other Funds$2,000.00$0.00$0.00
FUND 101 General$2,274,225.00$24,196.94$22,694.08
FUND 108 Cable Access Fee
108Cable Access FeeCable Franchise Fee$7,450.00$724.26$1,450.62
108Cable Access FeeTransfers from Other Funds$0.00$0.00$0.00
FUND 108 Cable Access Fee$7,450.00$724.26$1,450.62
FUND 150 Economic Development
150Economic DevelopmentCurrent Ad Valorem Taxes$126,095.00$0.00$0.00
150Economic DevelopmentTIF/MIF Deposit$0.00$0.00$0.00
150Economic DevelopmentInterest Earnings$500.00$101.60$108.20
150Economic DevelopmentTransfers from Other Funds$0.00$0.00$0.00
FUND 150 Economic Development$126,595.00$101.60$108.20
$2,408,270.00$25,022.80$24,252.90
04/04/13 3:19 PM
CITY OF ST JOSEPH
Page 1
Council Month End Revenue -Enterprise Funds
Current Period: March 2013
FUND2013March2013
FUNDDescrSOURCE DescrYTD Budget2013 AmtYTD Amt
FUND 601 Water Fund
601Water FundWater Meter$5,000.00$0.00$0.00
601Water FundBond Premium Proceeds$0.00$0.00$0.00
601Water FundGeneral Oblig. Bond Proceeds$0.00$0.00$0.00
601Water FundTransfers from Other Funds$584,000.00$0.00$0.00
601Water FundContributed Revenue$0.00$0.00$0.00
601Water FundMDS Test Fee$11,570.00$734.17$459.81
601Water FundState Sales Tax$425.00$203.90-$188.21
601Water FundInspection Fees$0.00$0.00$0.00
601Water FundPenalties and Forfeited Disc$5,680.00$646.78$2,346.80
601Water FundConnection/Reconnection fees$500.00$0.00$0.00
601Water FundAmortization of Bond Premium$0.00$0.00$0.00
601Water FundWater Line Charge$223,495.00$13,492.72$9,210.96
601Water FundInterest Earnings$44,370.00$2,334.66$1,419.22
601Water FundUndesignated Funds$0.00-$1,199.35-$1,187.51
601Water FundWater Tower Antenna Lease$31,950.00$3,877.64$7,696.05
601Water FundSurplus Property$0.00$0.00$0.00
601Water FundReimbursement$0.00$0.00$0.00
601Water FundRate Class One$473,000.00$20,221.39$14,584.49
601Water FundBulk Water$1,000.00$0.00$770.00
601Water FundSpecial Assessments$800.00$0.00-$10,857.58
FUND 601 Water Fund$1,381,790.00$40,311.91$24,254.03
FUND 602 Sewer Fund
602Sewer FundSt. Benedict Sewer Charges$0.00$0.00$0.00
602Sewer FundFederal Grants - Other$0.00$0.00$0.00
602Sewer FundSpecial Assessments$800.00$0.00-$584.53
602Sewer FundInterest Earnings$19,250.00$328.21$82.32
602Sewer FundAmortization of Bond Premium$0.00$0.00$0.00
602Sewer FundSurplus Property$0.00$0.00$0.00
602Sewer FundReimbursement$3,255.00$0.00$0.00
602Sewer FundContributed Revenue$0.00$0.00$0.00
602Sewer FundSt. Benedict s SCAWAC fees$0.00$0.00$0.00
602Sewer FundPenalties and Forfeited Disc$4,085.00$396.41$1,373.82
602Sewer FundSewer Line Charge$237,840.00$11,686.30$7,149.47
602Sewer FundSewer Inspection Fee$0.00$0.00$0.00
602Sewer FundTransfers from Other Funds$302,000.00$0.00$0.00
602Sewer FundGeneral Oblig. Bond Proceeds$0.00$0.00$0.00
602Sewer FundBond Premium Proceeds$0.00$0.00$0.00
602Sewer FundSanitary Sewer Service$425,075.00$16,806.58$6,465.75
FUND 602 Sewer Fund$992,305.00$29,217.50$14,486.83
FUND 603 Refuse Collection
603Refuse CollectSpecial Assessments$850.00$0.00-$592.98
603Refuse CollectInterest Earnings$5,000.00$343.93$274.08
603Refuse CollectPenalties and Forfeifted Disc$5,500.00$525.33$1,716.51
603Refuse CollectLicenses & Permits$18,875.00$0.00$0.00
603Refuse CollectState Sales Tax$0.00-$930.00-$3,426.22
603Refuse CollectContributions - General$1,350.00$0.00$0.00
603Refuse CollectRefuse Collection Charges$272,135.00$17,807.00$11,041.32
FUND 603 Refuse Collection$303,710.00$17,746.26$9,012.71
FUND 651 Storm Water Utility
651Storm Water Contributed Revenue$0.00$0.00$0.00
04/04/13 3:19 PM
CITY OF ST JOSEPH
Page 2
Council Month End Revenue -Enterprise Funds
Current Period: March 2013
FUND2013March2013
FUNDDescrSOURCE DescrYTD Budget2013 AmtYTD Amt
651Storm Water Transfers from Other Funds$0.00$0.00$0.00
651Storm Water Penalties and Forfeifted Disc$2,000.00$122.28$442.60
651Storm Water Development Fee$4,000.00$0.00$0.00
651Storm Water Reimbursement$0.00$0.00$0.00
651Storm Water Interest Earnings$3,450.00$256.22$205.94
651Storm Water Special Assessments$400.00$0.00-$332.30
651Storm Water Rate Class One$114,795.00$6,661.29$4,138.18
FUND 651 Storm Water Utility$124,645.00$7,039.79$4,454.42
FUND 652 Street Light Utility
652Street Light UTransfers from Other Funds$0.00$0.00$8,500.00
652Street Light UInterest Earnings$0.00$1.97$1.97
652Street Light URate Class One$42,500.00$0.00$1.42
652Street Light UPenalties and Forfeited Disc$0.00$0.00$0.00
FUND 652 Street Light Utility$42,500.00$1.97$8,503.39
$2,844,950.00$94,317.43$60,711.38
04/04/13 3:17 PM
CITY OF ST JOSEPH
Page 1
Council Month End Expenditure - Summar
y
Current Period: March 2013
2013March2013
DescriptionYTD Budget2013 Amt YTD Amt
General$2,240,065.00$169,122.17$543,357.98
Fire Fund$287,175.00$6,797.90$21,854.36
Cable Access Fee$0.00$0.00$530.10
Economic Development$126,595.00$3,312.93$6,566.36
TIF 2-1 Millstream$0.00$0.00$0.00
TIF 2-2 Meat Market$0.00$0.00$0.00
State Collected Sales Tax$0.00$4,958.28-$7,750.10
Park Dedication$46,400.00$233.91$378.87
Recreation Center$0.00$0.00$25.00
Charitable Gambling$0.00$407.88$407.88
Revolving Loan Fund$0.00$0.00$0.00
2009A CrossoverRefunding Bon$363,365.00$0.00$190.84
2007 Refunding (98/99 St Bond$166,345.00$0.00$190.84
City Hall Refunded, 2005$90,455.00$0.00$190.83
2011A Refunding Fire Hall$77,650.00$3,600.00$3,790.83
2010B Refundin (Hill/Clover)$146,850.00$0.00$190.84
2011A CO Refund (Interior Sts)$1,672,600.00$0.00$11,005.84
2007 St Imprv-E Side/Jade/8 A$79,070.00$0.00$190.84
2008 Equipment Certificates$62,100.00$0.00$190.83
2009B GO CIP Bonds$65,250.00$0.00$190.83
2010 Equipment Certificates$32,475.00$0.00$190.83
2010B Street Impr (16th Ave)$62,555.00$116.67$307.51
2011A Pumper Truck Certificate$42,360.00$3,680.00$3,870.83
2011A GO CIP Bonds$23,720.00$1,860.00$2,050.83
Debt Service Relief$0.00$465.10$465.10
2007 Street Impr (Jade Rd/E$0.00$0.00$0.00
2011A GO CIP Bonds$0.00$0.00$0.00
Capital Outlay$105,410.00$6,000.00$6,000.00
Water Extension$0.00$0.00$0.00
Sewer Extension$0.00$0.00$0.00
Water Fund$1,377,100.00$39,875.48$8,012.50
Sewer Fund$1,241,600.00$70,052.28$55,794.88
Refuse Collection$328,175.00$31,989.56$58,421.18
Storm Water Utility$214,485.00$6,579.21$6,322.46
Street Light Utility$51,000.00$4,670.15$9,442.31
$8,902,800.00$353,721.52$732,381.40
04/04/13 3:18 PM
CITY OF ST JOSEPH
Page 1
Council Month End Expense - Enterprise Funds
Current Period: March 2013
2013March2013
DescriptionDEPART DescrYTD Budget2013 Amt YTD Amt
FUND 601 Water Fund
Water FundBond Payment (P & I)$588,975.00$0.00-$29,505.51
Water FundOther Financing Uses$48,000.00$0.00$0.00
Water FundPower and Pumping$26,600.00$1,398.85$1,954.44
Water FundPurification-Plant 1$31,800.00$1,817.18$5,448.97
Water FundPurification-Plant 2$79,130.00$17,963.44$23,854.09
Water FundDistribution$10,000.00$0.00$0.00
Water FundWellhead Protection$2,000.00$0.00$0.00
Water FundStorage-Tower 1$5,000.00$316.10$648.85
Water FundStorage-Tower 2$0.00$0.00$0.00
Water FundWater Maintenance$189,770.00$14,808.34$4,850.45
Water FundAdministration and General$35,825.00$3,571.57$761.21
Water FundDepreciation Expense$360,000.00$0.00$0.00
FUND 601 Water Fund$1,377,100.00$39,875.48$8,012.50
FUND 602 Sewer Fund
Sewer FundBond Payment (P & I)$75,885.00$2,125.00-$33,869.34
Sewer FundOther Financing Uses$48,000.00$0.00$0.00
Sewer FundSanitary Sewer Maintenanc$204,480.00$9,971.13-$4,574.88
Sewer FundLift Station-Baker Street$6,305.00$229.92$661.60
Sewer FundLift Station-DBL Labs Area$2,765.00$161.42$471.58
Sewer FundLift Station-Northland$5,410.00$124.44$407.17
Sewer FundLift Station-CR 121$5,675.00$2,041.28$2,443.76
Sewer FundLift Station-Main$638,780.00$49,981.88$87,845.10
Sewer FundAdministration and General$39,300.00$5,417.21$2,409.89
Sewer FundDepreciation Expense$215,000.00$0.00$0.00
FUND 602 Sewer Fund$1,241,600.00$70,052.28$55,794.88
FUND 603 Refuse Collection
Refuse CollectioWaste Collection$328,175.00$31,989.56$58,421.18
Refuse CollectioOther Financing Uses$0.00$0.00$0.00
FUND 603 Refuse Collection$328,175.00$31,989.56$58,421.18
FUND 651 Storm Water Utility
Storm Water UtiOther Financing Uses$21,250.00$0.00$0.00
Storm Water UtiAdministration and General$13,095.00$2,269.31$1,783.00
Storm Water UtiStorm Water Maintenance$80,140.00$4,309.90$4,539.46
Storm Water UtiDepreciation Expense$100,000.00$0.00$0.00
FUND 651 Storm Water Utility$214,485.00$6,579.21$6,322.46
FUND 652 Street Light Utility
Street Light UtiliStreet Lighting$51,000.00$4,670.15$9,442.31
FUND 652 Street Light Utility$51,000.00$4,670.15$9,442.31
$3,212,360.00$153,166.68$137,993.33
This page intentionally left blank