HomeMy WebLinkAbout[07) 2nd Quarter Treasurer Report Crry op STr. JOSI Px Council Agenda Item
MEETING DATE: July 19, 2012
AGENDA ITEM: Financial Report — Requested Action: Accept the 2 Quarter 2012 and
June 2012 Financial Reports
SUBMITTED BY: Finance
BOARD / COMMISSION /COMMITTEE RECOMMENDATION: N/A
PREVIOUS COUNCIL ACTION: Council accepted the April and May 2012 Financial Reports.
BACKGROUND INFORMATION: Quarterly and monthly reconciled cash/investment and budget to
actual position are provided for Council review. The charts presented are to assist your visual
understanding of the last quarter's financial summaries. The numbers presented are the cash balances as
of June 30, 2012.
There are a couple points to highlight from the reports.
CASH POSITION:
- The market rates of return are still at some of the lowest levels in recent years; however, the
City's rate of return is approximately 2.5 %, higher than the 10 -year Treasury Notes.
- Overall, the cash and investments balance decreased $239,695 from the beginning of the year.
The decrease is attributable to spending down the 2011 working capital balance until 2012
property taxes and state aids are received. 70% of the first half property taxes were received in
June. The remaining 30% and LGA will be received in July.
- The cash position represents 4.2 months of the year's expenditures. The General fund cash is
approximately .5 months of expenditures at June 30
FUNDS REPORT:
- The General fund spent down 49% of the 2012 budget and received 27% of the revenue budget.
70% of the first half tax settlement was received in June. Other significant revenues include
permits and licensing, franchise fees, fines and miscellaneous revenues. Expenditures include
basic operating costs such as wages and benefits, supplies, repairs and professional services. A
few capital expenditures were also incurred the first half of the year.
- The Enterprise Funds show expenses more than revenues with exception of the storm water
fund. Debt interest payments were paid in the first half of 2012. St. Cloud sewer debt payments
are made monthly. The second half payments plus principal will be due by December 1 st. The
remaining funds are operational in nature with four months utilities billed while six months paid.
Water fund analysis (fund 601/501) — The enclosed spreadsheet shows an analysis of the Water fund for
2012. Included in the spreadsheet are the Water fund (601) and the Water Access fund (WAC -501). The
water connection activity for 2012 has been fair for the first six months considering the US economic
conditions. The City received $29,585 in WAC and Trunk fees so far this year. The connection fees
include completion of a River's Bend patio home deferred payment, four new homes, Laundromat
deferred monthly payments and Precise Refrigeration addition. The Millstream Villages close on their
property in July to begin development and the Church of St. Joseph is close to construction on the
fellowship hall.
'/2 ¢ Sales Tax (fund 200): The sales tax fund has a balance of $1,338,820 at the end of June. The City
anticipates collecting $3,000,000 in sales tax revenue through 2017; $1,555,339 collected to date. The
anticipated expenditures approved by Council total $1,168,219 leaving approximately $1,831,781
remaining for future projects.
CIP REPORTS:
- The 2012 CIP summary is included to show the capital expenditures through the June 30` A few
of the capital expenditures include a fire department 6- wheeler, police computer, sewer root
control, facilities study and EDA budgeted programs.
BUDGET/FISCAL IMPACT: Information Only
ATTACHMENTS: Request for Council Action
2 " Quarter Reports:
Cash Position as of 6/30/12
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
'/2 ¢ Sales Tax Fund Summary
June 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 fmancial reports as presented.
City of St. Joseph, Minnesota
Cash Position
As of 6/30/12
Sentry BankMaturity DateInterestCurrent Balance# Securities% of Total
Checking Account (Reconciled)N/A0.15%37,331$ N/A
Money Market SavingsN/A0.77%2,014,282 N/A
Bank Certificates of DepositTiered 6-28 months2.54% 72,750,123
avg
averages13 months2.44%
Total Sentry Bank$4,801,73654%
Central MN Credit Union
Share Savings AccountN/A0.78%25$ N/A
Money Market SavingsN/A0.95%246,082 N/A
Power Money Market CheckingN/A1.10%1,660,390 N/A
Jumbo Bank Certificates of Deposit18 months4.45% 1243,311
avg
averages18 months2.17%
Total CMCU$2,149,80824%
Total Deposits6,951,544$
Smith Barne
y
Brokered Money Market SavingsN/A0.01%37,787$ N/A
Government Securities/NotesN/A0.00% 0-
avg
Brokered Certificates of DepositTiered 7-51 months2.97% 151,911,744
avg
averages30 months2.97%
Total SB$ 22%1,949,531
Northland Securities
Brokered Money Market SavingsN/A0.00%1,832$ N/A
Brokered Certificates of DepositN/AN/A 0-
avg
averagesN/A0.00%
Total NS$ 0%1,832
Total Investments1,951,363$
Total Deosits and Investments$8902907
p,,
TotalDepositsandInvestments$8,902,907
Average Interest APY20 months2.56%
2012 YTD
Interest Earned
Cash Held With Fiscal Agent - Northland Securities
(2010B Crossover/2011A Crossover Refunding Bonds)
Brokered Money Market SavingsN/A0.39% 7,294,491$113,006
avg
Total Cash Held With Fiscal Agent$7,294,491
Total Deposits, Investments & Cash w/Fiscal Agent$ Cash and Investment Balance16,197,398
Petty Cash
AdministrationN/AN/A200$
Police DepartmentN/AN/A75
Total Petty Cash$275$16,197,673
Custodial Credit Risk: All deposits and investments insured by FDIC/SPIC/NCUA or secured by perfected pledged collateral.
: The City is not exposed to interest rate risk because the City does not invest in highly
Interest Rate Risk
sensitive, interest fluctuating investments. The City attempts to purchase longer termed investments
when the interest rates are favorable and depending on cash flow needs to lock into a favorable rate.
Credit Risk: There are no instruments exposed to credit risk.
Maturity
Concentration of Credit Risk: The City invests in various instruments and several financial institutions.
% SecuritiesAverages
Brokered Money Markets39,619$ 0%N/A
Brokered Certificates of Deposit1,911,744$ 21.47%2.5 years
Government Bonds/Notes-$ 0.00%N/A
State/Local Government Securities-$ 0%N/A
Foreign Currency Risk: The City only invests in USA and USA territories.
City of St. Joseph
Quarterly Water Fund Analysis
As of June 30, 2012
Fund 601+501, Water/WAC Fund Balance as of December 31, 2011(audited)$ 227,089.60
Year to Date Revenue (without bond proceeds):
Interest Earnings19,691.44
Water Usage Charge93,845.68 WAC fees collected for:
Water Line Charge47,465.80 4 homes +1 partial patio home
Penalties/Other Usage Fees(35.78) Laundromat (partial)
WAC/Trunk Fees29,585.00 Precise Refrigeration Addition
Antenna Lease Revenue15,173.16
Bulk Water Sales140.00
Transfers from other Funds-
Total Revenue205,865.30 12.94%budget collected
2012 Revenue Budget1,591,295.00 (includes fund 501)
Year to Date Expenses by Department (without bond financing):
Debt Payments(111,465.63)
Transfers to Other Funds-
Power and Pumping(2,316.86)
Water Treatment Plant 1(8,081.75)
Water Treatment Plant 2(37,792.10)
Distribution(24,811.89)
Wellhead Protection(97.56)
Water Tower(1,787.92)
Water Maintenance(44,367.71)
Water Administration(7,359.46)
Total Expenses(238,080.88)16.00%budget expensed
2012 Expense Budget(1,488,195.00) (includes depreciation)
Fund Summary as of June 30, 2012:
Water Fund Balance - Fund 601+501 - unaudited
$194,874.02
Fund 501$ 30,626.91
Fund 601$164,247.11
The balances represent the cash balance as of 6/30/12. Actual year-end balances will be adjusted with the audit.
07/12/12 11:15 AM
CITY OF ST JOSEPH
Page 1
Cash Balances Onl
y
Current Period: June 2012
MTDMTDCurrent
FUND DescrAccountBegin YrDebitCreditBalance
Last Dim 10100
GeneralG 101-10100$1,096,812.16$444,482.54$269,297.39$581,918.20
Fire FundG 105-10100$625,739.17$22,946.74$46,306.06$631,733.20
Cable Access FeeG 108-10100-$1,237.61$446.08$0.00$3,049.50
Economic DevelopmentG 150-10100$51,328.42$24,259.76$3,669.56$56,265.00
TIF 1-4 St. Joe DevelopmentG 156-10100$17.95$21,420.62$0.00$21,429.45
TIF 2-1 MillstreamG 157-10100$8,443.84$12,662.06$0.00$19,897.66
TIF 2-2 Meat MarketG 158-10100$3.26$0.00$0.00$3.26
State Collected Sales TaxG 200-10100$1,240,510.91$28,108.47$3,156.75$1,338,820.63
Park DedicationG 205-10100$72,835.88$106.59$193.26$73,154.21
Recreation CenterG 210-10100$52,273.94$40.65$0.00$52,146.35
Charitable GamblingG 215-10100$5,092.24$4.01$0.00$5,147.85
Revolving Loan FundG 250-10100$14,158.07$1,030.36$0.00$18,708.00
2009A CrossoverRefunding BonG 318-10100$489,013.10$88,965.62$0.00$556,569.05
2007 Refunding (98/99 St BonG 320-10100$269,082.34$21,815.67$0.00$291,745.65
City Hall Refunded, 2005G 322-10100$5,442.91$32,920.76$0.00$31,352.29
2011A Refunding Fire HallG 331-10100$126,537.01$11,078.33$0.00$153,176.47
2005 Improve (Hill/Clover)G 333-10100$452,837.96$17,676.74$0.00$453,777.86
2006 Interior St ImprovementsG 338-10100$276,886.58$41,498.79$0.00$317,492.88
2007 St Imprv-E Side/Jade/8 AG 341-10100$271,757.08$134,368.45$0.00$396,146.08
2008 Equipment CertificatesG 342-10100$8,944.04$23,455.24$0.00$30,515.75
2009B GO CIP BondsG 343-10100$3,825.31$23,375.55$0.00$21,343.61
2010 Equipment CertificatesG 344-10100$1,247.83$12,026.19$0.00$11,694.47
2010B Street Impr (16th Ave)G 345-10100$235,563.66$12,430.81$253.90$259,553.46
2011A Pumper Truck CertificatG 346-10100$4,196.58$6,051.19$0.00$25,517.34
2011A GO CIP BondsG 347-10100$5,603.83$8,331.15$0.00$17,345.61
Debt Service ReliefG 390-10100$339,854.04$1,671.18$0.00$348,739.96
Northland Heights/Trans CorridG 435-10100$274,071.30$1.36$432.25$257,312.25
2007 Street Impr (Jade Rd/EG 441-10100$365,338.49$0.00$0.00$367,995.11
2011A Pumper Truck CertificatG 446-10100$383,405.58$0.00$0.00$383,405.58
2011A GO CIP BondsG 447-10100$173,332.63$0.00$0.00$174,042.45
Capital OutlayG 490-10100$222,287.15$0.00$3,105.92$208,426.96
Water ExtensionG 501-10100$735.86$12,177.49$0.00$30,626.91
Sewer ExtensionG 502-10100$723,179.50$7,108.07$0.00$746,825.03
Water FundG 601-10100$237,621.48$49,811.49$30,632.12$164,247.11
Sewer FundG 602-10100$672,223.82$35,805.03$68,481.90$391,096.42
Refuse CollectionG 603-10100$258,434.00$29,127.08$26,566.23$268,226.06
Storm Water UtilityG 651-10100$175,200.83$8,764.00$4,141.74$193,458.68
Last Dim 10100$9,142,601.14$1,133,968.07$456,237.08$8,902,906.35
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
2005 Improve (Hill/Clover)G 333-10300$1,002,063.22$2,399.83$10,923.75$993,539.30
2006 Interior St ImprovementsG 338-10300$1,468,731.57$11,090.65$9,012.50$1,470,809.72
Water FundG 601-10300$0.00$0.00$25,191.14$4,830,141.89
Last Dim 10300$2,470,794.79$13,490.48$45,127.39$7,294,490.91
$11,613,670.93$1,147,458.55$501,364.47$16,197,672.26
07/12/12 11:15 AM
CITY OF ST JOSEPH
Page 1
Council Month End Revenue Summar
y
Current Period: June 2012
2012June2012
FUNDFUND DescrYTD Budget2012 AmtYTD Amt
101General$2,183,300.00$422,726.22$583,031.57
105Fire Fund$270,445.00$22,338.92$111,935.91
108Cable Access Fee$0.00$446.08$3,395.94
150Economic Development$70,725.00$24,259.76$24,668.36
156TIF 1-4 St. Joe Development$0.00$21,420.62$21,371.13
157TIF 2-1 Millstream$0.00$12,662.06$12,728.95
158TIF 2-2 Meat Market$0.00$0.00$0.00
200State Collected Sales Tax$0.00$28,108.47$64,233.34
205Park Dedication$0.00$66.09$761.01
210Recreation Center$0.00$40.65$483.86
215Charitable Gambling$0.00$4.01$47.59
250Revolving Loan Fund$8,380.00$1,030.36$4,515.98
3182009A CrossoverRefunding Bonds$308,525.00$88,965.62$92,983.38
3202007 Refunding (98/99 St Bond)$90,980.00$21,815.67$24,059.01
322City Hall Refunded, 2005$94,190.00$32,920.76$32,933.31
3312011A Refunding Fire Hall$67,390.00$11,078.33$30,255.46
3332005 Improve (Hill/Clover)$114,080.00$20,076.57$23,877.20
3382006 Interior St Improvements$180,425.00$52,589.44$54,699.33
3412007 St Imprv-E Side/Jade/8 Av$554,080.00$134,368.45$139,499.02
3422008 Equipment Certificates$67,165.00$23,455.24$23,508.53
3432009B GO CIP Bonds$66,800.00$23,375.55$23,388.11
3442010 Equipment Certificates$34,500.00$12,026.19$12,023.67
3452010B Street Impr (16th Ave)$59,005.00$12,430.81$14,475.52
3462011A Pumper Truck Certificate$32,455.00$6,051.19$24,881.90
3472011A GO CIP Bonds$60,350.00$8,331.15$13,511.23
390Debt Service Relief$0.00$1,671.18$7,862.18
4462011A Pumper Truck Certificate$0.00$0.00$0.00
4472011A GO CIP Bonds$0.00$0.00$0.00
490Capital Outlay$0.00$0.00$8,534.59
501Water Extension$567,535.00$12,177.49$29,820.15
502Sewer Extension$250,300.00$7,108.07$22,563.87
601Water Fund$1,023,760.00$46,500.59$5,089,157.80
602Sewer Fund$531,475.00$35,706.09$172,622.28
603Refuse Collection$303,150.00$27,088.26$100,386.80
651Storm Water Utility$109,875.00$8,754.47$32,229.31
$7,048,890.00$1,119,594.36$6,800,446.29
07/12/12 11:11 AM
CITY OF ST JOSEPH
Page 1
Council Month End Revenue -General Fund
Current Period: June 2012
2012June2012
FUNDFUND DescrSOURCE DescrYTD Budget2012 AmtYTD Amt
FUND 101 General
101GeneralCurrent Ad Valorem Taxes$1,092,685.00$384,212.58$384,212.58
101GeneralSpecial Levy- City St. Joe$0.00$247.29$247.29
101GeneralState Sales Tax$0.00-$28.94$45.41
101GeneralGas Franchise$32,500.00$0.00$7,897.53
101GeneralElectric Franchise$50,000.00$1,723.94$14,493.44
101GeneralBeer$450.00$0.00$0.00
101GeneralLiquor$19,760.00$2,125.00$14,834.99
101GeneralOutdoor Liquor Permit$2,500.00$0.00$1,500.00
101GeneralGambling Permits$100.00$0.00$120.00
101GeneralAmusement/Hunting Permit$840.00$0.00$0.00
101GeneralExcavation Permit$200.00$100.00$250.00
101GeneralCigarette License$525.00$0.00$0.00
101GeneralCable Franchise Fee$27,000.00$1,149.53$10,827.60
101GeneralBuilding Permits$40,000.00$5,552.87$20,978.93
101GeneralAnimal License$3,150.00$150.00$2,830.00
101GeneralRental Housing Registration$19,000.00$4,163.00$4,238.00
101GeneralFederal Grants - Other$5,000.00$279.29$279.29
101GeneralState Grants and Aids$965.00$0.00$915.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,200.00$0.00$3,090.00
101GeneralState Police Aid$50,000.00$0.00$0.00
101GeneralOther Grants/Aids$0.00$0.00$249.90
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$400.00
101GeneralLand Use Deposit Fee$4,000.00$750.00$4,750.00
101GeneralSale of Maps and Publications$75.00$0.00$14.65
101GeneralAssessments Search$2,500.00$330.00$1,650.00
101GeneralSpecial Hearing$4,500.00$1,150.00$3,565.00
101GeneralAdministration Reimb$11,350.00$0.00$4,985.93
101GeneralWeed Cutting$1,000.00$0.00$0.00
101GeneralPark Fees$4,750.00$720.00$5,050.00
101GeneralRecreation Donation$0.00$13,130.34$13,130.34
101GeneralSchneider Field Rental$0.00$1,620.00$1,620.00
101GeneralKennel Fees$500.00$67.00$218.00
101GeneralCounty Fines$30,000.00$2,594.39$10,335.80
101GeneralPolicy Fines$35,000.00$2,310.00$23,400.00
101GeneralAccident Report Fee$1,000.00$90.75$517.75
101GeneralSeized Property$500.00$0.00$3,565.00
101GeneralSpecial Assessments$2,000.00$1,827.43$1,976.96
07/12/12 11:11 AM
CITY OF ST JOSEPH
Page 2
Council Month End Revenue -General Fund
Current Period: June 2012
2012June2012
FUNDFUND DescrSOURCE DescrYTD Budget2012 AmtYTD Amt
101GeneralInterest Earnings$13,000.00$585.48$9,548.85
101GeneralInterest Charges$100.00$0.00-$44.97
101GeneralCo-op Dividend - LMCIT$6,000.00$0.00$9,178.48
101GeneralWater Tower Antenna Lease$3,325.00$426.79$1,685.88
101GeneralLand Rental$0.00$0.00$0.00
101GeneralAdvertising$7,000.00$0.00$600.00
101GeneralContributions - General$1,500.00$0.00$0.00
101GeneralContribution - Health Ins Div$10,485.00$9,083.71$9,083.71
101GeneralContributions-Holiday Lights$1,000.00$0.00$0.00
101GeneralContributions - Parks$800.00-$12,288.80$1,320.72
101GeneralSurplus Property$0.00$0.00$1,500.00
101GeneralReimbursement$23,100.00$654.57$2,969.51
101GeneralStreet Access Fee$0.00$0.00$0.00
101GeneralTransfers from Other Funds$0.00$0.00$0.00
FUND 101 General$2,183,300.00$422,726.22$583,031.57
FUND 108 Cable Access Fee
108Cable Access FeeCable Franchise Fee$0.00$446.08$3,395.94
FUND 108 Cable Access Fee$0.00$446.08$3,395.94
FUND 150 Economic Development
150Economic DevelopmentCurrent Ad Valorem Taxes$70,500.00$24,229.88$24,229.88
150Economic DevelopmentTIF/MIF Deposit$0.00$0.00$0.00
150Economic DevelopmentDEED Housing Reimbursement$0.00$0.00$0.00
150Economic DevelopmentInterest Earnings$225.00$29.88$438.48
150Economic DevelopmentTransfers from Other Funds$0.00$0.00$0.00
FUND 150 Economic Development$70,725.00$24,259.76$24,668.36
$2,254,025.00$447,432.06$611,095.87
07/12/12 11:13 AM
CITY OF ST JOSEPH
Page 1
Council Month End Revenue -Enterprise Funds
Current Period: June 2012
FUND2012June2012
FUNDDescrSOURCE DescrYTD Budget2012 AmtYTD Amt
FUND 601 Water Fund
601Water FundPenalties and Forfeited Disc$6,500.00$313.02$3,110.88
601Water FundBond Premium Proceeds$0.00$0.00$53,112.65
601Water FundGeneral Oblig. Bond Proceeds$0.00$0.00$4,860,000.00
601Water FundTransfers from Other Funds$381,000.00$0.00$0.00
601Water FundContributed Revenue$0.00$0.00$0.00
601Water FundMDS Test Fee$11,000.00$1,002.42$3,379.00
601Water FundWater Line Charge$151,000.00$13,816.67$47,465.80
601Water FundState Sales Tax$300.00-$93.95-$253.37
601Water FundWater Meter$5,000.00$700.00$2,860.00
601Water FundConnection/Reconnection fees$300.00$0.00$0.00
601Water FundUndesignated Funds$250.00$873.97$1,818.41
601Water FundBulk Water$1,500.00$0.00$140.00
601Water FundRate Class One$405,500.00$27,680.05$93,845.68
601Water FundReimbursement$0.00$0.00$0.00
601Water FundSurplus Property$0.00$0.00$15.00
601Water FundWater Tower Antenna Lease$30,310.00$3,841.15$15,173.16
601Water FundAmortization of Bond Premium$0.00$0.00$0.00
601Water FundInterest Earnings$30,000.00-$1,632.74$19,456.29
601Water FundSpecial Assessments$1,100.00$0.00-$10,965.70
601Water FundInspection Fees$0.00$0.00$0.00
FUND 601 Water Fund$1,023,760.00$46,500.59$5,089,157.80
FUND 602 Sewer Fund
602Sewer FundContributed Revenue$0.00$0.00$0.00
602Sewer FundFederal Grants - Other$0.00$0.00$0.00
602Sewer FundSpecial Assessments$500.00$0.00-$438.05
602Sewer FundInterest Earnings$8,500.00$347.68$5,444.26
602Sewer FundAmortization of Bond Premium$0.00$0.00$0.00
602Sewer FundSanitary Sewer Service$342,600.00$22,324.84$111,728.72
602Sewer FundSt. Benedict Sewer Charges$0.00$0.00-$0.01
602Sewer FundSt. Benedict s SCAWAC fees$0.00$0.00$0.01
602Sewer FundPenalties and Forfeited Disc$4,740.00$259.88$2,330.90
602Sewer FundSewer Line Charge$171,135.00$12,773.69$53,556.45
602Sewer FundSewer Inspection Fee$0.00$0.00$0.00
602Sewer FundTransfers from Other Funds$0.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 FundReimbursement$4,000.00$0.00$0.00
602Sewer FundSurplus Property$0.00$0.00$0.00
FUND 602 Sewer Fund$531,475.00$35,706.09$172,622.28
FUND 603 Refuse Collection
603Refuse CollectLicenses & Permits$17,600.00$770.00$14,050.00
603Refuse CollectContributions - General$250.00$0.00$945.00
603Refuse CollectInterest Earnings$3,500.00$206.00$2,392.52
603Refuse CollectSpecial Assessments$500.00$0.00-$862.32
603Refuse CollectRefuse Collection Charges$275,800.00$25,277.08$83,851.64
603Refuse CollectState Sales Tax$0.00$460.45-$2,953.42
603Refuse CollectPenalties and Forfeifted Disc$5,500.00$374.73$2,963.38
FUND 603 Refuse Collection$303,150.00$27,088.26$100,386.80
FUND 651 Storm Water Utility
651Storm Water Transfers from Other Funds$0.00$0.00$0.00
07/12/12 11:13 AM
CITY OF ST JOSEPH
Page 2
Council Month End Revenue -Enterprise Funds
Current Period: June 2012
FUND2012June2012
FUNDDescrSOURCE DescrYTD Budget2012 AmtYTD Amt
651Storm Water Special Assessments$200.00$0.00-$715.21
651Storm Water Interest Earnings$5,200.00$146.75$1,726.47
651Storm Water Reimbursement$0.00$0.00$0.00
651Storm Water Contributed Revenue$0.00$0.00$0.00
651Storm Water Development Fee$4,000.00$0.00$0.00
651Storm Water Rate Class One$98,750.00$8,507.98$30,398.89
651Storm Water Penalties and Forfeifted Disc$1,725.00$99.74$819.16
FUND 651 Storm Water Utility$109,875.00$8,754.47$32,229.31
$1,968,260.00$118,049.41$5,394,396.19
07/12/12 11:13 AM
CITY OF ST JOSEPH
Page 1
Council Month End Expenditure - Summar
y
Current Period: June 2012
2012June2012
DescriptionYTD Budget2012 Amt YTD Amt
General$2,183,300.00$233,888.08$1,060,895.39
Fire Fund$284,445.00$45,698.24$106,397.85
Cable Access Fee$0.00$0.00$0.00
Economic Development$70,725.00$3,669.56$15,685.85
TIF 1-4 St. Joe Development$0.00$0.00$0.00
TIF 2-1 Millstream$0.00$0.00$42.73
TIF 2-2 Meat Market$0.00$0.00$0.00
State Collected Sales Tax$0.00$3,156.75$23,025.35
Park Dedication$43,400.00$152.76$366.82
Recreation Center$0.00$0.00$75.40
Charitable Gambling$0.00$0.00$0.00
Revolving Loan Fund$0.00$0.00$0.00
2009A CrossoverRefunding Bon$363,790.00$0.00$26,893.75
2007 Refunding (98/99 St Bond$166,345.00$0.00$8,172.50
City Hall Refunded, 2005$98,645.00$0.00$7,246.25
2011A Refunding Fire Hall$79,885.00$0.00$3,583.33
2005 Improve (Hill/Clover)$150,195.00$10,923.75$33,521.25
2006 Interior St Improvements$216,770.00$9,012.50$44,896.88
2007 St Imprv-E Side/Jade/8 A$534,070.00$0.00$17,034.38
2008 Equipment Certificates$64,200.00$0.00$2,100.00
2009B GO CIP Bonds$66,185.00$0.00$6,017.50
2010 Equipment Certificates$33,300.00$0.00$1,650.00
2010B Street Impr (16th Ave)$63,455.00$253.90-$1,131.29
2011A Pumper Truck Certificate$44,960.00$0.00$3,358.33
2011A GO CIP Bonds$18,685.00$0.00$1,675.00
Debt Service Relief$0.00$0.00$0.00
Northland Heights/Trans Corrid$0.00$430.89$15,712.80
2007 Street Impr (Jade Rd/E$0.00$0.00$120.00
2010A Equip Certificates$0.00$0.00$0.00
2011A Pumper Truck Certificate$0.00$0.00$0.00
2011A GO CIP Bonds$0.00$0.00$0.00
Capital Outlay$168,250.00$3,105.92$21,436.85
Water Extension$0.00$0.00$0.00
Sewer Extension$0.00$0.00$0.00
Water Fund$1,488,195.00$52,512.36$323,635.88
Sewer Fund$1,223,735.00$68,382.96$260,675.52
Refuse Collection$316,875.00$24,527.41$116,218.51
Storm Water Utility$239,175.00$4,132.21$23,649.34
$7,918,585.00$459,847.29$2,122,956.17
07/12/12 11:14 AM
CITY OF ST JOSEPH
Page 1
Council Month End Expenditure - General Fund
Current Period: June 2012
2012June2012
DescriptionDEPART DescrYTD Budget2012 Amt YTD Amt
FUND 101 General
GeneralCouncil$42,040.00$4,887.59$17,335.70
GeneralLegislative Committees$10,065.00$439.15$5,694.78
GeneralOrdinance & Proceedings$2,700.00$13.50$298.95
GeneralMayor$10,595.00$787.43$4,228.78
GeneralElections$3,000.00$0.00$0.00
GeneralGeneral Adminstration$186,655.00$22,372.13$95,457.53
GeneralFinance$112,030.00$7,288.81$49,803.28
GeneralAudit Service$25,000.00$0.00$25,000.00
GeneralAssessing$19,500.00$0.00$0.00
GeneralCity Attorney$18,000.00$1,830.50$5,019.75
GeneralPlanning and Zoning$2,300.00$352.05$952.51
GeneralGeneral Government$22,455.00$804.04$12,789.90
GeneralCity Offices$28,065.00$2,003.98$21,290.16
GeneralFacilites and Planning$0.00$9,419.50$9,419.50
GeneralCable Access$11,320.00$1,169.40$4,891.80
GeneralCrime Control & Investigation$804,215.00$75,509.84$372,230.03
GeneralPolice Training$7,000.00$196.65$2,158.96
GeneralCommunication Service$12,015.00$789.79$4,798.59
GeneralAutomotive Services$64,870.00$5,904.44$23,155.01
GeneralBuilding Inspec. Admistration$90,000.00$7,500.00$37,962.26
GeneralEmergency Management$3,300.00$7.36$141.62
GeneralSignal Lights CSAH 75$2,000.00$131.07$762.52
GeneralAnimal Control$1,150.00$51.54$511.10
GeneralOrdinance/Easement Enforcement$0.00$0.00$0.00
GeneralStreet Maintanence$177,435.00$17,170.49$98,665.60
GeneralIce & Snow Removal$95,445.00$0.00$33,838.88
GeneralEngineering Fee$35,000.00$2,509.47$18,845.91
GeneralStreet Lighting$46,000.00$3,485.29$22,725.60
GeneralStreet Cleaning$17,255.00$254.24$8,207.47
GeneralSkate Park and Ice Rink$3,745.00$41.14$278.36
GeneralRecreation Association$0.00$20,781.74$20,781.74
GeneralMaintenance Shop$21,490.00$1,244.62$9,825.93
GeneralPark Areas$211,015.00$25,633.76$111,206.05
GeneralCommunity Support$12,515.00$0.00$0.00
GeneralOther Financing Uses$0.00$0.00$0.00
GeneralFire Protection$85,125.00$21,308.56$42,617.12
FUND 101 General$2,183,300.00$233,888.08$1,060,895.39
FUND 108 Cable Access Fee
Cable Access FeeCable Access$0.00$0.00$0.00
FUND 108 Cable Access Fee$0.00$0.00$0.00
FUND 150 Economic Development
07/12/12 11:14 AM
CITY OF ST JOSEPH
Page 2
Council Month End Expenditure - General Fund
Current Period: June 2012
2012June2012
DescriptionDEPART DescrYTD Budget2012 Amt YTD Amt
Economic DevelopmentEconomic Development Authority$70,725.00$3,669.56$15,685.85
FUND 150 Economic Development$70,725.00$3,669.56$15,685.85
FUND 490 Capital Outlay
Capital OutlayElections$0.00$0.00$0.00
Capital OutlayGeneral Adminstration$0.00$1,500.00$1,592.34
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$1,605.92$1,568.92
Capital OutlayCommunication Service$0.00$0.00$0.00
Capital OutlayAutomotive Services$0.00$0.00$0.00
Capital OutlayEmergency Management$0.00$0.00$1,133.75
Capital OutlayStreet Maintanence$31,200.00$0.00$11.45
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$12,500.00$0.00$1,969.54
Capital OutlayPark Areas$40,800.00$0.00$15,160.85
Capital OutlayOther Financing Uses$0.00$0.00$0.00
FUND 490 Capital Outlay$168,250.00$3,105.92$21,436.85
$2,422,275.00$240,663.56$1,098,018.09
07/12/12 11:15 AM
CITY OF ST JOSEPH
Page 1
Council Month End Expense - Enterprise Funds
Current Period: June 2012
2012June2012
DescriptionDEPART DescrYTD Budget2012 Amt YTD Amt
FUND 601 Water Fund
Water FundBond Payment (P & I)$665,730.00$22,375.00$197,020.63
Water FundOther Financing Uses$50,000.00$0.00$0.00
Water FundPower and Pumping$34,350.00$540.24$2,316.86
Water FundPurification-Plant 1$28,960.00$1,046.31$8,081.75
Water FundPurification-Plant 2$80,155.00$6,850.07$37,792.10
Water FundDistribution$22,000.00$3,482.53$24,811.89
Water FundWellhead Protection$2,000.00$0.00$97.56
Water FundStorage-Tower 1$5,500.00$165.70$1,787.92
Water FundStorage-Tower 2$0.00$0.00$0.00
Water FundWater Maintenance$200,355.00$15,491.25$44,367.71
Water FundAdministration and General$37,295.00$2,561.26$7,359.46
Water FundDepreciation Expense$360,000.00$0.00$0.00
FUND 601 Water Fund$1,486,345.00$52,512.36$323,635.88
FUND 602 Sewer Fund
Sewer FundBond Payment (P & I)$71,695.00$0.00-$37,971.50
Sewer FundOther Financing Uses$55,000.00$0.00$0.00
Sewer FundSanitary Sewer Maintenanc$203,515.00$14,351.02$24,827.63
Sewer FundLift Station-Baker Street$3,095.00$179.02$8,736.61
Sewer FundLift Station-DBL Labs Area$2,720.00$132.58$1,558.50
Sewer FundLift Station-Northland$2,575.00$112.21$3,292.60
Sewer FundLift Station-CR 121$2,725.00$129.70$890.97
Sewer FundLift Station-Main$623,050.00$50,090.30$249,912.92
Sewer FundAdministration and General$43,800.00$3,388.13$9,427.79
Sewer FundDepreciation Expense$215,000.00$0.00$0.00
FUND 602 Sewer Fund$1,223,175.00$68,382.96$260,675.52
FUND 603 Refuse Collection
Refuse CollectioWaste Collection$316,875.00$24,527.41$116,218.51
Refuse CollectioOther Financing Uses$0.00$0.00$0.00
FUND 603 Refuse Collection$316,875.00$24,527.41$116,218.51
FUND 651 Storm Water Utility
Storm Water UtiOther Financing Uses$57,325.00$0.00$0.00
Storm Water UtiAdministration and General$13,875.00$975.73$4,224.32
Storm Water UtiStorm Water Maintenance$72,975.00$3,156.48$19,425.02
Storm Water UtiDepreciation Expense$95,000.00$0.00$0.00
FUND 651 Storm Water Utility$239,175.00$4,132.21$23,649.34
$3,265,570.00$149,554.94$724,179.25
City of St. Joseph Park Board
Capital Improvement Budget Summary
2012 Proposed Capital Budget
as of June 30, 2012
General FundsBalance
Park Dedication Cash June 30, 201273,154$
(Unaudited)
Adjustments
Starting Balance73,154$
Monument Restoration Grant43,000$ -$
Potential Projects:PotentialProposed
Army Reserve Center
s$ 23,40023,400$
Collegeville Communities Cottage
Heid/Herges - 150 Acres348,750$
Feld Residential348,750$
St. Wendel Farm - 350 Acres813,750$
Ending Balance for 201296,554$
Projects - Budget
201120122013201420152016Total 12-16
PTR-01 (Millstream)5,000$ -$ -$ 25,000$ -$ -$ 25,000$
PTR-02 (Northland)-$ 25,000$ -$ -$ -$ -$ 25,000$
PTR-03 (Klinefelter)-$ -$ -$ -$ -$ -$ -$
PTR-04 (Wobegon)-$ -$ -$ -$ -$ -$ -$
PTR-05 (Memorial)-$ 7,500$ -$ -$ -$ -$ 7,500$
$ --$ -$ -$ -$ -$ -$
PTR-06 (Centennial)
$ 400300$ 400$ 400$ 400$ 400$ 2,000$
PTR-07 (Monument)
PTR-08 (Hollow)-$ -$ -$ -$ -$ -$ -$
$ 5005,000$ 25,000$ -$ -$ -$ 25,500$
PTR-09 (Cloverdale)
PTR-10 (East Park)-$ -$ -$ -$ -$ -$ -$
PTR-11 (West Park)-$ -$ -$ -$ -$ -$ -$
$ 10,000-$ 10,000$ 10,000$ 10,000$ 10,000$ 50,000$
PTR-12 (Trails)
Total10,300$ 43,400$ 35,400$ 35,400$ 10,400$ 10,400$ 135,000$
Projects - ActualSpent 20112012
PTR-01 (Millstream)-$
PTR-02 (Northland)-$ -$
Other 12 Expenses:2011 Actual
PTR-03 (Klinefelter)-$ -$
PTR-04 (Wobegon)-$ -$ A-1 Toilets367$ 1,786$
PTR-05 (Memorial)-$ -$
2012 Revenue:2011 Actua
PTR-06 (Centennial)-$ -$ l
PTR-07 (Monument)(139)$ -$ Interest725$ 749$
PTR-08 (Hollow)-$ -$ Round Up36$ -$
PTR-09 (Cloverdale)-$ -$ Park Dedic.-$ 39,046$
PTR-10 (East Park)-$ -$
PTR-11 (West Park)-$ -$
PTR-12 (Trails)-$ -$
Total(139)$ -$
Approved expenditure7,500$ Memorial Park Scoreboard - Park Dedication Fees
Approved expenditure25,700$ Northland Playground Equipment - Park Dedication Fees
v
Approved expenditure120,000$ College Ave/CR133 sidewalk - 1/2 Sales Tax
Grant Application Approved1,500$ Monument Restoration - S E H grant writer - General Fun
THIS PAGE INTENTIONALLY LEFT BLANK