Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
[04c] Treasurer Report, September
4(c) Council Agenda Item MEETING DATE: October 18, 2012 rd AGENDA ITEM: Financial Report – Requested Action: Accept the 3 Quarter 2012 and September 2012 Financial Reports SUBMITTED BY: Finance BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A PREVIOUS COUNCIL ACTION: Council accepted the July and August 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 September 30, 2012. There are a couple points to highlight from the reports. CASH POSITION : - The market rates of return is approximately 2.55%, higher than the 10-year Treasury Notes. - Overall, the cash and investments balance decreased $491,408 from the beginning of the year. The beginning of the year cash balance is generally the highest cash balance due to receiving the nd 2 half state aids and property tax settlements in December. - The cash position represents .3 months of the year’s expenditures. The General fund cash is th approximately 5.5 months of expenditures at September 30. FUNDS REPORT : General fund - The spent down 74% of the 2012 budget and received 57% of the revenue budget. The State Police and Fire Aid came in at the end of September. Building permit revenues are close to budget before McDonald’s and the Church expansion were issued in October. Interest revenue will be slightly above budget this year and permitting fees are at or above budget. Expenditures include basic operating costs such as wages and benefits, supplies, repairs and professional services. A few capital expenditures were also incurred the first part of the year including seal coating and crack filling streets. Enterprise Funds - The 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 st are made monthly. The second half payments plus principal will be due by December 1. The remaining funds are operational in nature with eight months utilities billed while nine months of operations were 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 nine 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, five new homes, Laundromat deferred monthly payments and Precise Refrigeration addition. The reports do not reflect connection fees received in October for McDonalds and the Church of St. Joseph totaling $19,273.44. ½ ¢ Sales Tax (fund 200): The sales tax fund has a balance of $1,403,429 at the end of September. The City anticipates collecting $3,000,000 in sales tax revenue through 2017; $1,672,129 collected to date. The anticipated expenditures approved by Council totals $968,418 leaving approximately $2,031,582 remaining for future projects. CIP REPORTS: th - The 2012 CIP summary is included to show the capital expenditures through the September 30. A few of the capital expenditures include a fire department 6-wheeler and pumper truck, police computer, sewer root control, seal coating, facilities study, Northland Park phase III playground equipment, a mower, scoreboard, and EDA budgeted programs. The fire department also purchased a water softener and turnout gear. BUDGET/FISCAL IMPACT: Information Only ATTACHMENTS: Request for Council Action rd 3 Quarter Reports: Cash Position as of 9/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 ½ ¢ Sales Tax Fund Summary September 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. City of St. Joseph, Minnesota Cash Position As of 9/30/12 Sentry BankMaturity DateInterestCurrent Balance# Securities% of Total Checking Account (Reconciled)N/A0.15%306,016$ N/A Money Market SavingsN/A0.65%1,448,181 N/A Bank Certificates of DepositTiered 3-25 months3.13%avg 72,778,508 averages8 months2.52% $4,532,705 Total Sentry Bank 52% Central MN Credit Union Share Savings AccountN/A0.78%25$ N/A Money Market SavingsN/A0.95%246,672 N/A Power Money Market CheckingN/A1.10%1,665,947 N/A Jumbo Bank Certificates of Deposit15 months4.45%avg 1245,995 averages15 months2.17% $2,158,639 Total CMCU 25% Total Deposits6,691,344$ Smith Barne y Brokered Money Market SavingsN/A0.01%48,377$ N/A Government Securities/NotesN/A0.00%avg 0- Brokered Certificates of DepositTiered 4-48 months2.97%avg 151,909,641 averages27 months2.97% Total SB $ 23%1,958,018 Northland Securities Brokered Money Market SavingsN/A0.00%1,832$ N/A Brokered Certificates of DepositN/AN/Aavg 0- averages0.00% N/A Total NS $ 0%1,832 Total Investments1,959,850$ Total Deposits and Investments$8,651,194 Average Interest APY17 months2.55% 2012 YTD Cash Held With Fiscal Agent - Northland SecuritiesInterest Earned (2010B /2011A/2012A Crossover Refunding Bonds) $166,753 Brokered Money Market SavingsN/A0.39%avg 7,294,491 Total Cash Held With Fiscal Agent$7,294,491 Total Deposits, Investments & Cash w/Fiscal Agent $ Cash and Investment Balance15,945,685 Petty Cash AdministrationN/AN/A200$ Police DepartmentN/AN/A75 Total Petty Cash$275 Custodial Credit Risk: All deposits and investments insured by FDIC/SPIC/NCUA or secured by perfected pledged collateral. Interest Rate Risk: The City is not exposed to interest rate risk because the City does not invest in highly 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 Markets50,209$ 1%N/A Brokered Certificates of Deposit1,909,641$ 22.07%2.25 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. Y W 00 Y O0 L- W C f0 j7, cc c N 0) 0) a) C Ln 0 Y O a.+ m 2 v 00 2 N E N o C U W U c Y Y 0) Y 0.1 C > m U 2 m m 0 m Lt-) • • • • • • N 00 O LID m m VT N 4A C 13 2 CI' ■r m o E O m H a) c C CU N cc o V 0 N N e lD e-i 01 4 l0 m O1 O O m O e-i t? 4. N O M i/) 0 co O O1 O N O V1 N 10/08/12 1:14 PM CITY OF ST JOSEPH Page 1 Cash Balances Only Current Period: September 2012 MTDMTDCurrent FUND DescrAccountBegin YrDebitCreditBalance Last Dim 10100 GeneralG 101-10100$1,096,812.16$79,983.63$139,673.60$707,535.59 Fire FundG 105-10100$625,739.17$52,550.35$44,509.60$562,869.05 Cable Access FeeG 108-10100-$1,237.61$430.80$0.00$4,352.70 Economic DevelopmentG 150-10100$51,328.42$151.67$4,886.47$53,120.79 TIF 1-4 St. Joe DevelopmentG 156-10100$17.95$23.07$0.00$2,823.35 TIF 2-1 MillstreamG 157-10100$8,443.84$32.46$0.00$9,381.68 TIF 2-2 Meat MarketG 158-10100$3.26$0.00$0.00-$169.98 State Collected Sales TaxG 200-10100$1,240,510.91$37,211.89$5,561.15$1,403,429.33 Park DedicationG 205-10100$72,835.88$196.63$296.16$69,077.24 Recreation CenterG 210-10100$52,273.94$126.59$2,172.15$42,320.45 Charitable GamblingG 215-10100$5,092.24$13.19$0.00$5,176.49 Revolving Loan FundG 250-10100$14,158.07$722.93$0.00$20,488.65 2009A CrossoverRefunding BonG 318-10100$489,013.10$4,879.76$0.00$601,481.51 2007 Refunding (98/99 St BonG 320-10100$269,082.34$763.80$0.00$302,807.09 City Hall Refunded, 2005G 322-10100$5,442.91$104.34$0.00$45,611.69 2011A Refunding Fire HallG 331-10100$126,537.01$5,769.98$74,300.00$98,828.77 2005 Improve (Hill/Clover)G 333-10100$452,837.96$1,175.65$0.00$463,730.02 2006 Interior St ImprovementsG 338-10100$276,886.58$854.02$0.00$342,929.62 2007 St Imprv-E Side/Jade/8 AG 341-10100$271,757.08$2,057.81$0.00$458,741.61 2008 Equipment CertificatesG 342-10100$8,944.04$95.30$0.00$40,716.56 2009B GO CIP BondsG 343-10100$3,825.31$71.74$0.00$31,464.19 2010 Equipment CertificatesG 344-10100$1,247.83$38.73$0.00$16,905.22 2010B Street Impr (16th Ave)G 345-10100$235,563.66$674.15$0.00$266,237.87 2011A Pumper Truck CertificatG 346-10100$4,196.58$3,480.05$39,030.00-$711.44 2011A GO CIP BondsG 347-10100$5,603.83$1,493.70$17,010.00$6,901.54 Debt Service ReliefG 390-10100$339,854.04$1,548.98$0.00$352,622.64 Northland Heights/Trans CorridG 435-10100$274,071.30$0.00$0.00$253,416.60 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$0.00 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$0.00$207,049.58 Water ExtensionG 501-10100$735.86$78.46$0.00$30,772.92 Sewer ExtensionG 502-10100$723,179.50$1,914.05$0.00$750,969.12 Water FundG 601-10100$237,621.48$83,409.87$34,827.74$278,349.95 Sewer FundG 602-10100$672,223.82$31,638.41$91,068.84$209,096.88 Refuse CollectionG 603-10100$258,434.00$22,019.01$27,199.50$262,789.63 Storm Water UtilityG 651-10100$175,200.83$8,372.19$3,717.42$208,038.86 Last Dim 10100$9,142,601.14$341,883.21$484,252.63$8,651,193.33 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$0.00$0.00$993,539.30 2006 Interior St ImprovementsG 338-10300$1,468,731.57$0.00$0.00$1,470,809.72 Water FundG 601-10300$0.00$0.00$0.00$4,830,141.89 Last Dim 10300$2,470,794.79$0.00$0.00$7,294,490.91 $11,613,670.93$341,883.21$484,252.63$15,945,959.24 City of St. Joseph, Minnesota Cash Balances by Fund/Remaining Budget As of 9/30/12 FUNDCASH BALANC12 EXP BUD12 SPENT12 LEFT12 BUD RE12 RECEIVED12 LEFT EV General Fund $ 2,183,300918,938$ 1,611,680$ 571,620$ 2,183,300$ 1,234,077$ 949,223$ Fire Fund 284,445562,869 275,630 8,815$ 270,445 212,304 58,141$ EDA Fund 70,72553,121 29,504 41,221$ 70,725 35,342 35,383$ TIF Funds -12,035 49,829 (49,829)$ - 54,591 (54,591)$ State Collected Sales Tax -1,403,429 51,203 (51,203)$ - 157,019 (157,019)$ Park Dedication 10,30069,077 28,279 (17,979)$ - 24,596 (24,596)$ Recreation Center -42,320 10,184 (10,184)$ - 767 (767)$ Charitable Gambling -5,176 - -$ - 76 (76)$ Revolving Loan Fund 8,38020,489 - 8,380$ 8,380 6,297 2,083$ Debt Funds 1,900,4853,028,267 285,358 1,615,127$ 1,729,945 761,594 968,351$ Capital Project Funds 168,250795,454 403,134 (234,884)$ - - -$ Water Access Fund -30,773 - -$ 567,535 29,966 537,569$ Sewer Access Fund -750,969 - -$ 250,300 26,708 223,592$ Water Fund 1,488,195278,350 395,793 1,092,402$ 1,023,760 5,275,418 (4,251,658)$ Sewer Fund 1,223,735209,097 479,971 743,764$ 531,475 209,918 321,557$ Refuse/Compost Fund 316,875262,790 188,548 128,327$ 303,150 167,280 135,870$ Storm Sewer 243,175208,039 34,853 208,322$ 109,875 58,013 51,862$ TOTALS $ 3,843,9668,651,193$ 8,253,967$ 5.3 months of cash balance 12/31/11 Cash Balance9,142,601$ 2012 cash decrease(491,408) General Budget to Actual Expenditures $2,500,000 • $2,183,300 $2,000,000 $1,611,680,74%spent $1,500,000 •Budget ■Actual $1,000,000 $500,000 $284,445 $275,630,97%spent $70,725 $29,504,42%spent, $- General Fund Fire Fund EDA 74%Spent 97%Spent 42%Spent General Budget to Actual Revenue $2,700,000 $2,400,000 $2,183,300 $2,100,000 $1,800,000 --- $1,500,000 $1,234,077,57%received ■Budget $1,200,000 --- - - - ■Actual $900,000 $600,000 $300,000 $270,445 $212,304,79%received $70,725 $35,342,50%received General Fund Fire Fund EDA 57%Received 79%Received 50%Received • Q, N 3 C C) a) Q) O_ > X Q) W CL Ell 3 O O O O O v) in- .--1 Cr) Cri n O 0 tn. 0 O 0 tf1 m Ql t\ If) 0 Cr) m >4 M N O / -_.. __....— __.. _ O to V a) Q d 0 N a L o to N O O = O 0) o C) d c a) vT Q W M x c in 00•_ CPI d ° D) m s- v 0 3 o _C 0 w Q. 00 U) E o a) `�' LID 1 o o N c v} p _c O W '''''z L N 7 ° Q to a) CO !Qua) r N a)t m r ++ e-1 O O o = N in O co N V1 E CO d 0 O m ` O v) v). U) y ,«+ oo - V d c ill 1 u) N O o in V C.) ti y a X c L .� w y aD v vi a`, v o C c at co v°i m• m m E > cn C4 o > a) ) a) (.1 _ 5 City of St. Joseph Quarterly Water Fund Analysis As of September 30, 2012 Fund 601+501, Water/WAC Fund Balance as of December 31, 2011(audited) $ 229,673.84 Year to Date Revenue (without bond proceeds): Interest Earnings25,709.81 Water Usage Charge225,830.17WAC fees collected for: Water Line Charge83,393.25 5 homes +1 partial patio home Penalties/Other Usage Fees1,790.32 Laundromat (partial) WAC/Trunk Fees29,585.00 Precise Refrigeration Addition Antenna Lease Revenue22,759.74 Bulk Water Sales618.50 Transfers from other Funds- Total Revenue389,686.79 24.49%budget collected 2012 Revenue Budget1,591,295.00 (includes fund 501) (Without bond refunding) Year to Date Expenses by Department (without bond financing): Debt Payments(114,365.63)(Without bond refunding) Transfers to Other Funds- Power and Pumping(3,162.83) Water Treatment Plant 1(16,578.60) Water Treatment Plant 2(50,286.37) Distribution(24,811.89) Wellhead Protection(97.56) Water Tower(2,353.63) Water Maintenance(84,216.30) Water Administration(14,364.95) Total Expenses(310,237.76)20.85%budget expensed 2012 Expense Budget(1,488,195.00) (includes depreciation) Fund Summary as of September 30, 2012: Water Fund Balance - Fund 601+501 - unaudited $309,122.87 $ 30,772.92 Fund 501 $278,349.95 Fund 601 St. Joseph 1/2 Cent Sales Tax Committee Summary Treasurer's Report - Fund 200 As of September 30, 2012 Opening Fund 2006- 2006 Interest Earnings2,696.64 2006 Sales Tax Receipts Collected190,471.22 1,672,128.67 Sales Tax Collected Balance as of December 31, 2006 (audited)193,167.86 Sales Tax Spent(358,418.01) 2007 Interest Earnings12,081.68 2007 Sales Tax Receipts Collected237,927.00 3,000,000.00 Projected Sales Tax 2007 Transfer from the General Fund24,003.73 (1,672,128.67) Sales Tax received Balance as of December 31, 2007 (audited)467,180.27 1,327,871.33 Remaining Sales Tax through 2017 2008 Interest Earnings21,468.30 3,000,000.00 Projected Sales Tax 2008 Sales Tax Receipts Collected251,015.22 (358,418.01) Spent as of September 30, 2012 2008 Meeting Stipends(420.00) (485,000.00) Projected CR2/3 Trail 2008 Parks and Recreation Survey(1,279.26) (125,000.00) Projected CR133/College Ave Trail Remaining Unallocated Sales Tax through 20172,031,581.99 2008 Park and Trail System Plan(42,079.24) 2008 Parks Boundary Survey(8,272.75) Balance as of December 31, 2008 (audited)687,612.54 2009 Interest Earnings33,184.40 2009 Sales Tax Receipts Collected242,011.63 2009 Meeting Stipends(165.80) Balance as of December 31, 2009 (audited)962,642.77 2010 Sales Tax Receipts Collected270,108.80 2010 Interest Earnings20,287.65 2010 Transfer Interest Earnings to Water F (86,436.20) 2010 Centennial Park Swingset(33,284.14) Balance as of December 31, 2010 (audited)1,133,318.88 2011 Sales Tax Receipts Collected299,571.59 2011 CMCU Building Purchase(110,935.71) 2011 CR 2/3 trail extension(21,463.82) 2011 CR133/College Ave trail extension(2,878.30) Balance as of December 31, 2011 (audited)1,297,612.64 2012 Sales Tax Receipts Collected157,019.48 2012 CR 2/3 trail extension(34,681.87) 2012CR133/College Ave trail extension(16,520.92) Fund Summaries as of September 30, 2012 (Unaudited)1,403,429.33 10/05/12 3:49 PM CITY OF ST JOSEPH Page 1 Council Month End Revenue Summary Current Period: September 2012 2012September2012 FUNDFUND DescrYTD Budget2012 AmtYTD Amt 101General$2,183,300.00$66,554.42$1,220,843.43 105Fire Fund$247,445.00$52,180.56$212,303.71 108Cable Access Fee$0.00$430.80$4,699.14 150Economic Development$70,725.00$151.67$35,342.22 156TIF 1-4 St. Joe Development$0.00$23.07$30,596.75 157TIF 2-1 Millstream$0.00$32.46$23,994.49 158TIF 2-2 Meat Market$0.00$0.00$0.00 200State Collected Sales Tax$0.00$37,211.89$157,019.48 205Park Dedication$0.00$195.43$24,596.35 210Recreation Center$0.00$126.59$766.99 215Charitable Gambling$0.00$13.19$76.23 250Revolving Loan Fund$8,380.00$722.93$6,296.63 3182009A CrossoverRefunding Bonds$308,525.00$4,879.76$137,895.84 3202007 Refunding (98/99 St Bond)$90,980.00$763.80$35,120.45 322City Hall Refunded, 2005$94,190.00$104.34$47,192.71 3312011A Refunding Fire Hall$67,390.00$5,769.98$50,207.76 3332005 Improve (Hill/Clover)$114,080.00$1,175.65$33,829.36 3382006 Interior St Improvements$180,425.00$854.02$80,136.07 3412007 St Imprv-E Side/Jade/8 Av$554,080.00$2,057.81$202,094.55 3422008 Equipment Certificates$67,165.00$95.30$33,709.34 3432009B GO CIP Bonds$66,800.00$71.74$33,508.69 3442010 Equipment Certificates$34,500.00$38.73$17,234.42 3452010B Street Impr (16th Ave)$59,005.00$674.15$21,159.93 3462011A Pumper Truck Certificate$32,455.00$3,480.05$37,683.12 3472011A GO CIP Bonds$60,350.00$1,493.70$20,077.16 390Debt Service Relief$0.00$1,548.98$11,744.86 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$78.46$29,966.16 502Sewer Extension$250,300.00$1,914.05$26,707.96 601Water Fund$1,023,760.00$66,847.92$5,275,417.52 602Sewer Fund$531,475.00$29,656.65$209,917.91 603Refuse Collection$303,150.00$18,709.97$167,280.23 651Storm Water Utility$109,875.00$8,106.84$58,013.31 $7,025,890.00$305,964.91$8,253,967.36 10/05/12 3:49 PM CITY OF ST JOSEPH Page 1 Council Month End Revenue -General Fund Current Period: September 2012 2012September2012 FUNDFUND DescrSOURCE DescrYTD Budget2012 AmtYTD Amt FUND 101 General 101GeneralCurrent Ad Valorem Taxes$1,092,685.00$0.00$549,227.71 101GeneralSpecial Levy- City St. Joe$0.00$0.00$353.26 101GeneralState Sales Tax$0.00-$68.22$0.11 101GeneralGas Franchise$32,500.00$0.00$14,131.76 101GeneralElectric Franchise$50,000.00$1,864.50$27,298.42 101GeneralBeer$450.00$0.00$0.00 101GeneralLiquor$19,760.00$0.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$0.00$300.00 101GeneralCigarette License$525.00$0.00$0.00 101GeneralCable Franchise Fee$27,000.00$1,129.16$18,871.61 101GeneralBuilding Permits$40,000.00$2,564.13$31,940.57 101GeneralAnimal License$3,150.00-$17.00$3,025.00 101GeneralRental Housing Registration$19,000.00$3,105.50$19,872.00 101GeneralFederal Grants - Other$5,000.00$0.00$4,933.82 101GeneralState Grants and Aids$965.00$0.00$915.00 101GeneralLocal Government Aid$645,150.00$0.00$322,575.50 101GeneralPERA Rate Increase Aid$1,540.00$0.00$770.50 101GeneralPolice Training Reim$3,500.00$0.00$2,656.72 101GeneralState Municipal Funds Aid$6,200.00$0.00$6,180.00 101GeneralState Police Aid$50,000.00$45,308.00$45,308.00 101GeneralOther Grants/Aids$0.00$0.00$249.90 101GeneralOther Governmental Unit$10,000.00$0.00$10,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$14,750.00 101GeneralSale of Maps and Publications$75.00$0.50$26.65 101GeneralAssessments Search$2,500.00$180.00$2,250.00 101GeneralSpecial Hearing$4,500.00$0.00$3,965.00 101GeneralAdministration Reimb$11,350.00$0.00$4,985.93 101GeneralWeed Cutting$1,000.00$0.00$100.00 101GeneralPark Fees$4,750.00$80.00$6,522.98 101GeneralBall Field Donation$0.00$0.00$13,630.34 101GeneralSchneider Field Rental$0.00$0.00$1,620.00 101GeneralKennel Fees$500.00$42.00$361.00 101GeneralCounty Fines$30,000.00$3,389.38$17,298.13 101GeneralPolicy Fines$35,000.00$3,705.00$28,185.00 101GeneralAccident Report Fee$1,000.00$47.00$762.75 101GeneralSeized Property$500.00$0.00$3,565.00 101GeneralSpecial Assessments$2,000.00$0.00$298.79 10/05/12 3:49 PM CITY OF ST JOSEPH Page 2 Council Month End Revenue -General Fund Current Period: September 2012 2012September2012 FUNDFUND DescrSOURCE DescrYTD Budget2012 AmtYTD Amt 101GeneralInterest Earnings$13,000.00$2,502.14$14,349.87 101GeneralInterest Charges$100.00$5.10-$39.87 101GeneralCo-op Dividend - LMCIT$6,000.00$0.00$9,324.64 101GeneralWater Tower Antenna Lease$3,325.00$280.98$2,528.82 101GeneralLand Rental$0.00$0.00$0.00 101GeneralAdvertising$7,000.00$200.00$1,000.00 101GeneralContributions - General$1,500.00$870.09$870.09 101GeneralContribution - Health Ins Div$10,485.00$0.00$9,083.71 101GeneralContributions-Holiday Lights$1,000.00$1,000.00$1,000.00 101GeneralContributions - Parks$800.00$175.00$1,995.92 101GeneralSurplus Property$0.00$0.00$1,500.00 101GeneralReimbursement$23,100.00$941.16$5,443.81 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$66,554.42$1,220,843.43 FUND 108 Cable Access Fee 108Cable Access FeeCable Franchise Fee$0.00$430.80$4,699.14 FUND 108 Cable Access Fee$0.00$430.80$4,699.14 FUND 150 Economic Development 150Economic DevelopmentCurrent Ad Valorem Taxes$70,500.00$0.00$34,614.13 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$151.67$728.09 150Economic DevelopmentTransfers from Other Funds$0.00$0.00$0.00 FUND 150 Economic Development$70,725.00$151.67$35,342.22 $2,254,025.00$67,136.89$1,260,884.79 10/05/12 3:48 PM CITY OF ST JOSEPH Page 1 Council Month End Revenue -Enterprise Funds Current Period: September 2012 FUND2012September2012 FUNDDescrSOURCE DescrYTD Budget2012 AmtYTD Amt FUND 601 Water Fund 601Water FundPenalties and Forfeited Disc$6,500.00$532.52$4,563.62 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$759.81$5,958.70 601Water FundWater Line Charge$151,000.00$10,427.77$83,393.25 601Water FundState Sales Tax$300.00$205.50-$171.34 601Water FundWater Meter$5,000.00$0.00$2,860.00 601Water FundConnection/Reconnection fees$300.00$30.00$60.00 601Water FundUndesignated Funds$250.00-$1,176.00-$1,196.42 601Water FundBulk Water$1,500.00$368.50$618.50 601Water FundRate Class One$405,500.00$49,233.51$225,830.17 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$2,528.86$22,759.74 601Water FundAmortization of Bond Premium$0.00$0.00$0.00 601Water FundInterest Earnings$30,000.00$3,937.45$27,912.89 601Water FundSpecial Assessments$1,100.00$0.00-$10,299.24 601Water FundInspection Fees$0.00$0.00$0.00 FUND 601 Water Fund$1,023,760.00$66,847.92$5,275,417.52 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-$161.25 602Sewer FundInterest Earnings$8,500.00$815.96$7,474.51 602Sewer FundAmortization of Bond Premium$0.00$0.00$0.00 602Sewer FundSanitary Sewer Service$342,600.00$18,874.04$186,725.83 602Sewer FundSt. Benedict Sewer Charges$0.00$0.00-$77,984.70 602Sewer FundSt. Benedict s SCAWAC fees$0.00$0.00$0.01 602Sewer FundPenalties and Forfeited Disc$4,740.00$336.90$3,360.87 602Sewer FundSewer Line Charge$171,135.00$9,629.75$90,502.64 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$29,656.65$209,917.91 FUND 603 Refuse Collection 603Refuse CollectLicenses & Permits$17,600.00$210.00$14,900.00 603Refuse CollectContributions - General$250.00$0.00$945.00 603Refuse CollectInterest Earnings$3,500.00$682.98$3,877.96 603Refuse CollectSpecial Assessments$500.00$0.00-$284.71 603Refuse CollectRefuse Collection Charges$275,800.00$18,107.72$147,057.31 603Refuse CollectState Sales Tax$0.00-$772.17-$3,650.28 603Refuse CollectPenalties and Forfeifted Disc$5,500.00$481.44$4,434.95 FUND 603 Refuse Collection$303,150.00$18,709.97$167,280.23 FUND 651 Storm Water Utility 651Storm Water Transfers from Other Funds$0.00$0.00$0.00 10/05/12 3:48 PM CITY OF ST JOSEPH Page 2 Council Month End Revenue -Enterprise Funds Current Period: September 2012 FUND2012September2012 FUNDDescrSOURCE DescrYTD Budget2012 AmtYTD Amt 651Storm Water Special Assessments$200.00$0.00-$334.85 651Storm Water Interest Earnings$5,200.00$507.28$2,808.81 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$7,483.75$54,366.24 651Storm Water Penalties and Forfeifted Disc$1,725.00$115.81$1,173.11 FUND 651 Storm Water Utility$109,875.00$8,106.84$58,013.31 $1,968,260.00$123,321.38$5,710,628.97 10/05/12 3:48 PM CITY OF ST JOSEPH Page 1 Council Month End Expenditure - Summary Current Period: September 2012 2012September2012 DescriptionYTD Budget2012 Amt YTD Amt General$2,183,500.00$129,705.74$1,588,865.34 Fire Fund$284,445.00$44,139.81$275,629.80 Cable Access Fee$0.00$0.00$0.00 Economic Development$70,725.00$4,886.47$29,503.92 TIF 1-4 St. Joe Development$0.00$0.00$27,831.72 TIF 2-1 Millstream$0.00$0.00$21,824.25 TIF 2-2 Meat Market$0.00$0.00$173.24 State Collected Sales Tax$0.00$5,561.15$51,202.79 Park Dedication$43,400.00$294.96$28,279.13 Recreation Center$0.00$2,172.15$10,184.43 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$74,300.00$77,883.33 2005 Improve (Hill/Clover)$150,195.00$0.00$33,521.25 2006 Interior St Improvements$216,770.00$0.00$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$0.00-$1,131.29 2011A Pumper Truck Certificate$44,960.00$39,030.00$42,388.33 2011A GO CIP Bonds$18,685.00$17,010.00$18,685.00 Debt Service Relief$0.00$0.00$0.00 Northland Heights/Trans Corrid$0.00$0.00$19,608.45 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$383,405.58 2011A GO CIP Bonds$0.00$0.00$0.00 Capital Outlay$168,250.00$0.00$22,814.23 Water Extension$0.00$0.00$0.00 Sewer Extension$0.00$0.00$0.00 Water Fund$1,488,195.00$18,265.79$395,792.76 Sewer Fund$1,223,735.00$89,087.08$479,970.69 Refuse Collection$316,875.00$23,890.46$188,548.37 Storm Water Utility$239,175.00$3,452.07$34,853.16 $7,918,785.00$451,795.68$3,843,965.74 10/05/12 3:46 PM CITY OF ST JOSEPH Page 1 Council Month End Expenditure - General Fund Current Period: September 2012 2012September2012 DescriptionDEPART DescrYTD Budget2012 Amt YTD Amt FUND 101 General GeneralCouncil$42,040.00$2,423.31$24,858.69 GeneralLegislative Committees$10,065.00$140.00$6,790.73 GeneralOrdinance & Proceedings$2,700.00$48.00$827.80 GeneralMayor$10,595.00$945.14$6,728.02 GeneralElections$3,000.00-$47.20$1,727.05 GeneralGeneral Adminstration$186,855.00$12,674.65$134,933.40 GeneralFinance$112,030.00$6,906.53$70,596.23 GeneralAudit Service$25,000.00$0.00$25,000.00 GeneralAssessing$19,500.00$0.00$19,755.70 GeneralCity Attorney$18,000.00$792.25$8,986.66 GeneralPlanning and Zoning$2,300.00$3,970.70$5,540.86 GeneralGeneral Government$22,455.00$889.78$16,856.14 GeneralCity Offices$28,065.00$6,218.07$31,609.92 GeneralFacilites and Planning$0.00$556.80$10,559.13 GeneralCable Access$11,320.00$830.60$7,562.93 GeneralCrime Control & Investigation$804,215.00$54,526.84$564,644.82 GeneralPolice Training$7,000.00$0.00$2,326.02 GeneralCommunication Service$12,015.00$787.15$7,406.80 GeneralAutomotive Services$64,870.00$2,155.32$35,493.59 GeneralBuilding Inspec. Admistration$90,000.00$7,500.00$61,231.79 GeneralEmergency Management$3,300.00-$123.28$163.14 GeneralSignal Lights CSAH 75$2,000.00$150.89$1,210.25 GeneralAnimal Control$1,150.00$19.33$825.85 GeneralOrdinance/Easement Enforcement$0.00$0.00$0.00 GeneralStreet Maintanence$177,435.00$7,289.93$184,344.41 GeneralIce & Snow Removal$95,445.00$0.00$33,838.88 GeneralEngineering Fee$35,000.00$3,251.20$28,166.56 GeneralStreet Lighting$46,000.00$3,920.73$33,755.14 GeneralStreet Cleaning$17,255.00$0.00$9,140.52 GeneralSkate Park and Ice Rink$3,745.00$42.89$470.01 GeneralBall Park$0.00$0.00$14,281.74 GeneralMaintenance Shop$21,490.00$1,408.33$13,597.33 GeneralPark Areas$211,015.00$12,427.78$161,709.55 GeneralCommunity Support$12,515.00$0.00$0.00 GeneralOther Financing Uses$0.00$0.00$0.00 GeneralFire Protection$85,125.00$0.00$63,925.68 FUND 101 General$2,183,500.00$129,705.74$1,588,865.34 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 10/05/12 3:46 PM CITY OF ST JOSEPH Page 2 Council Month End Expenditure - General Fund Current Period: September 2012 2012September2012 DescriptionDEPART DescrYTD Budget2012 Amt YTD Amt Economic DevelopmentEconomic Development Authority$70,725.00$4,886.47$29,503.92 FUND 150 Economic Development$70,725.00$4,886.47$29,503.92 FUND 490 Capital Outlay Capital OutlayElections$0.00$0.00$0.00 Capital OutlayGeneral Adminstration$0.00$0.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$0.00$2,946.30 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$0.00$22,814.23 $2,422,475.00$134,592.21$1,641,183.49 10/05/12 3:48 PM CITY OF ST JOSEPH Page 1 Council Month End Expense - Enterprise Funds Current Period: September 2012 2012September2012 DescriptionDEPART DescrYTD Budget2012 Amt YTD Amt FUND 601 Water Fund Water FundBond Payment (P & I)$665,730.00$0.00$199,920.63 Water FundOther Financing Uses$50,000.00$0.00$0.00 Water FundPower and Pumping$35,400.00-$492.82$3,162.83 Water FundPurification-Plant 1$29,310.00$3,290.70$16,578.60 Water FundPurification-Plant 2$80,155.00-$809.61$50,286.37 Water FundDistribution$22,000.00$0.00$24,811.89 Water FundWellhead Protection$2,000.00$0.00$97.56 Water FundStorage-Tower 1$5,950.00$199.71$2,353.63 Water FundStorage-Tower 2$0.00$0.00$0.00 Water FundWater Maintenance$200,355.00$13,867.20$84,216.30 Water FundAdministration and General$37,295.00$2,210.61$14,364.95 Water FundDepreciation Expense$360,000.00$0.00$0.00 FUND 601 Water Fund$1,488,195.00$18,265.79$395,792.76 FUND 602 Sewer Fund Sewer FundBond Payment (P & I)$71,695.00$22,325.00-$15,646.50 Sewer FundOther Financing Uses$55,000.00$0.00$0.00 Sewer FundSanitary Sewer Maintenanc$204,075.00$13,363.11$62,635.15 Sewer FundLift Station-Baker Street$3,095.00$205.19$9,651.93 Sewer FundLift Station-DBL Labs Area$2,720.00$1,056.25$2,903.31 Sewer FundLift Station-Northland$2,575.00$115.13$3,637.65 Sewer FundLift Station-CR 121$2,725.00$521.77$2,298.53 Sewer FundLift Station-Main$623,050.00$49,076.71$397,144.93 Sewer FundAdministration and General$43,800.00$2,423.92$17,345.69 Sewer FundDepreciation Expense$215,000.00$0.00$0.00 FUND 602 Sewer Fund$1,223,735.00$89,087.08$479,970.69 FUND 603 Refuse Collection Refuse CollectioWaste Collection$316,875.00$23,890.46$188,548.37 Refuse CollectioOther Financing Uses$0.00$0.00$0.00 FUND 603 Refuse Collection$316,875.00$23,890.46$188,548.37 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$632.16$6,448.56 Storm Water UtiStorm Water Maintenance$72,975.00$2,819.91$28,404.60 Storm Water UtiDepreciation Expense$95,000.00$0.00$0.00 FUND 651 Storm Water Utility$239,175.00$3,452.07$34,853.16 $3,267,980.00$134,695.40$1,099,164.98 / ¦z· 9ã¦;7z·Ò©; D;;© CÒ7/ ¦z· L¦©Ý;;·t {Ò ©ä /Lt.Ò7m;·Cz 7¦·;75;-;,;© !E{;¦·;,;© r !Ý z ,;·w©Òmw ·w©Òmw t©;-·.Ò7m;·w;;©Ý;© E;©©;7{¦;·.Ò7m;·w; zzm 5;¦ ©·;·!--Ò·/7;9¨Òz¦;·. -;D© · . -; r r u r u Election101-41410-530Election Equipment r r u Administration490-41430-570Administration Equipment u r u r u 490-41430-581Computer Replacement r ur u 490-41430-582Computer Software r u Finance490-41430-300GASB Updates r u Facilities101-41943-300Facility Study r u r u r u Total Administration CIP r u r u u Police - General490-42120-300Police Professional Services r r u ru Police - General490-42120-580Police Equipment ru Police-Communications490-42151-580Communication Equipment r r u r u Police - Automotive490-42152-550Vehicle/Equipment u r r u u Emergency Services490-42500-580Emergency Services r u r u r u r u Total Police CIP r u r r u Streets101-43120-530Street Improvements r u r u Streets490-43120-580Street Equipment/Improvements r u r u Snow Removal490-43125-580Snow Removal Equipment r u r u Maintenance490-45201-580Maintenance Shop Equipment r u r r u Parks490-45202-580Parks Equipment r u r ur u r u Total Public Works CIP r u EDA Software150-46500-582Computer Software r u r u r u r u EDA Projects150-46500-588EDA Programs r u r u r u r u Total EDA CIP r r u r u r u r u Total General Capital Improvements ADM-1 {·uW;¦wCz©;5;¦ ©·;· / ¦z· L¦©Ý;;·t E©t ä ,; Cz©;. ©7Ez / ¦z· .Ò7m;·!7¦·;75;-;,;© As of September 30, 2012 E !Ý z ,;D© · E !Ý z ,; tÒ©-w ;7w;;©Ý;.Ò7m;·!7Ò·;·{¦;·w;;©Ý; !--Ò·/7;5;¦ ©·;·h,;-·; ©5;-©z¦·zCÒ7 CÒ7 CIP # u u u FD-1201 105-42210-581/582Fire AdministrationComputer Hardware/Software2010/20113 Computers · Cz©;!7zz·© ·z/¦Ò·;©I ©7Þ ©;{E·Þ © u u u ; r u u r ru FD-1202 105-42220-580Fire FightingOther Equipmentn/aReplacement · Cz©;Czmw·zmh·w;©9¨Òz¦;· r u u r ru r u r u FD-1203 105-42220-584Fire FightingEquipment Reserve19996 Wheeler r u r u r u FD-1204 105-42220-584Fire FightingEquipment Reserve1996/2005Extracation Equip r u FD-1205 105-42220-584Fire FightingEquipment Reserve1997Rescue Van · Cz©;Czmw·zm9¨Òz¦;·w;;©Ý; r u r u r u ru r u r u FD-1206 105-42220-585Fire FightingFirefighter Equipment1995Pumper Truck r u FD-1207 105-42220-585Fire FightingFirefighter Equipment2001Ladder Truck #2 r u r u FD-1208 105-42220-585Fire FightingFirefighter Equipment1997Grass Rig #3 r u FD-1209 105-42220-585Fire FightingFirefighter Equipment1999Tanker #4 r u r u r u FD-1210 105-42220-585Fire FightingFirefighter Equipmentn/aReplacement · Cz©;Czmw·zm9¨Òz¦;· r u r ru r u r u FD-1211 105-42250-580Fire CommunicationOther Equipment2007800 MHz Radios r u u r u FD-1212 105-42250-580Fire CommunicationOther Equipmentn/aReplacement · Cz©;/Òz- ·z9¨Òz¦; r ur u r u · u u u FD-1213 105-42270-580Medical ServicesOther Equipmentn/aReplacement · a;7z- {;©Ýz-;9¨Òz¦; u u u · r u r u FD-1214 105-42280-530Fire Station & BuildingEquipment Reserven/aBuilding Repairs r u r u FD-1215 105-42280-530Fire Station & BuildingEquipment Reserve2011Sealcoating r u r u FD-1216 105-42280-530Fire Station & BuildingImprovements other than Buildin2008Painting · Cz©;{· ·zµ.Òz7zmL¦©Ý;;··w;©·w .Òz7z r r u r u r u m · / ¦z· L¦©Ý;;·Cz©;CÒ r u r r u r u ru 7 Note: The fire department is funded by the City of St. Joseph, St. Joseph Township and St. Wendel Township. This page intentionally left blank