Loading...
HomeMy WebLinkAbout[06] Treasurer's Reportc[T ' OF ST. jom PH MEETING DATE: April 21, 2011 Council Agenda Item 6 AGENDA ITEM: Financial Report — Requested Action: Accept the 1st Quarter 2011 and March 2011 Financial Reports SUBMITTED BY: Finance BOARD /COMMISSION /COMMITTEE RECOMMENDATION: N/A PREVIOUS COUNCIL ACTION: Council accepted the January and February 2011 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 March 31, 2011. The 2010 year -end accruals have been reversed are reflected in the reports. Some of the accruals create a "negative" balance in 2011 until the receipts are received and expenses are paid. One large "negative" balance that will stick out on the reports is for St. Benedict's 2010 sewer usage. St. Benedict's was not billed for their 2010 usage until February of this year. They have not made payment for their 2010 usage yet. There are a couple points I would like to highlight from the reports. CASH POSITION: - The City has investments in money markets, bank CDs, brokered CDs and government securities. The City has reviewed other investment options, but the rates of return are less favorable and more volatile in the current market. The market rates are not expected to increase much over the next year or two as the market is still trying to stabilize from the recent recession. The City invested in three step -up FNMA securities (government backed securities) with maturities either eight or ten years. The interest rates start lower, 2 -3%, and step -up at different time increments until maturity. The step -ups held by the City will increase interest rates each step up until they reach 4.5 -6 %. The step -ups are callable in either 6 month or 1 year increments. Overall, the cash and investments balance decreased $330,756 from the beginning of the year. The decrease is attributable to spending down the working capital until the first half state aids and property taxes are received. Utilities only reflect 1 month of receipts also. The cash position represents 15.5 months of the year's expenditures. The General fund 6.4 months of expenditures. FUNDS REPORT: - The General fund spent down 18% of the 2011 budget and received 1% of the revenue budget. The General fund receives much of its revenue budget from state aids and property taxes; therefore, will show only a small amount received for the first quarter. Expenditures represent general operation funding for the first quarter. One department close to budget is the ice and 6:1 snow removal (department 43125). The City experienced more snow events this past winter than the previous several winters causing more staff time, motor fuel and salt /sand to clear the streets. The Enterprise Funds show expenses greater than revenues (with exception of the water fund). This is due to 3 months worth of expenses incurred, but only lmonth of utility usage has been billed as of March 31St. Reversing the 2010 audit accruals caused water to show negative expenses for the 1" quarter. This will change for the second quarter reports. Further, the sewer fund revenue shows negative revenue until St. Benedicts pays their 2010 sewer usage. Additional Comment — Water fund (fund 601) — I created a spreadsheet to show how the Water fund is doing through the year. Included in the spreadsheet are the Water fund (601) and the Water Access fund (WAC - 501). 1 included the WAC fund since this fund assists in paying for the water debt. The first quarter does not have much activity other than normal operational costs. The first debt interest payments are due June 1St to show activity other than operations. There were no WAC fees collected in the first quarter; however, finance just billed Coborn's their WAC /SAC bill that is due June 1' according to the developer's agreement. A couple of the pending projects presented by the EDA may also have WAC /SAC fees associated with their projects. CIP REPORTS: - The 2011 CIP summary is included to show the capital expenditures for the year. There have been a few capital expenditures to cover projects Council approved in 2010. The projects, such as the Millstream pond dredging, could not be completed until March. The EDA capital expenditures follow the EDA CIP to promote development in St. Joseph. BUDGET /FISCAL IMPACT: Information Only ATTACHMENTS: Request for Council Action 6:1 -2 1St Quarter Reports: Cash Position as of 3/31/11 6:3 Cash and Investment Holdings Chart 6:4 Cash Balances by Fund /Remaining Budget 6:5 Budget to Actual Revenue Graph 6:6 Budget to Actual Expenditures Graph 6:7 Enterprise Funds Activity Graph 6:8 Quarterly Water Fund Analysis 6:9 March Treasurer's Reports: Cash and Investment —Council Report 6:10 Council Month End Revenue Summary 6:11 Council Month End Revenue — General Fund 6:12 -13 Council Month End Revenue — Enterprise Funds 6:14 -15 Council Month End Expenditure Summary 6:16 Council Month End Expenditure —General Fund 6:17 -18 Council Month End Expenses - Enterprise Funds 6:19 Capitai Summary Reports: General Fund Capital Improvement Plan — Summary 6:20 REQUESTED COUNCIL ACTION: Accept the financial reports as presented. 6:2 Sentry Bank Checking Account (Reconciled) Money Market Savings Bank Certificates of Deposit averages Total Sentry Bank Central MN Credit Union Share Savings Account Money Market Savings Power Money Market Checking Jumbo Bank Certificates of Deposit averages Total CMCU Total Deposits City of St. Joseph, Minnesota Cash Position As of 3'31,11 Maturity Date Interest Current Balance # Securities % of Total N/A 0.20% $ 105,818 N/A N/A 1.36% Tiered 93 -114 months 1,256,025 N/A Tiered 1-43 months 2.75% avg 3,649,247 10 21 months 2.42% 56 months 3.51% Total SB $ 5,011,090 56% N/A 0.78% $ 20 N/A N/A 1.25% N/A 242,844 N/A N/A 1.35% N/A 2,029,292 N/A 33 months 4.45% avg 230,380 1 33 months 2.35% $ 1,832 Total Investments $ 2,502,536 28% S 7,513,626 Smith Barney Brokered Money Market Savings N/A 0.01% $ 113,497 Government Securities /Notes Tiered 93 -114 months 2.42% avg 632,301 Brokered Certificates of Deposit Tiered 22-44 months 4.47% avg 712,046 averages 56 months 3.51% Total SB $ 1,457,844 Northland Securities Brokered Money Market Savings N/A 0.00% $ 1,832 Brokered Certificates of Deposit N/A N/A avg - averages N/A 0.001/1, Total NS $ 1,832 Total Investments $ 1,459,676 Total Deposits and Investments $ 8,973,302 Average Interest APY 2.76% Cash Held With Fiscal Agent - Northland Securities (2010B Crossover Refunding Bonds) Brokered Money Market Savings N/A 0.48% 1,023,692 Total Cash Held With Fiscal Agent $ 1,023,692 N/A 3 7 N/A 0 16% 0% Total Deposits, Investments & Cash w /Fiscal Agent $ 9,996,994 Cash and Investment Balance Petty Cash Administration N/A N/A Police Department N/A N/A Total Petty Cash $ 200 $ 275 Custodial Credit Risk: All deposits and investments insured by FDIC /SPIC /NCUSIF 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. % Securities Averages Brokered Money Markets $ 115,329 1% N/A (over 5% of investment portfolio) Brokered Certificates of Deposit $ 712,046 7.94% 2.92 years (over 5% of investment portfolio) Government Bonds /Notes $ 632,301 43.32% 8.92 years State /Local Government Securities $ 0% N/A Foreign Currency Risk: The City only invests in USA and USA territories. 6:3 A Y Oq ^~ i • Y d C O T m N Ovl Y ^L' C N O ^rw i C OD N E C CJ `W V C Y o t r-I O U M co r-I Ln L!1 0 O m s N o m 00 V 0 N ei n 0 O t rl W rl 00 N Lf1 M LMD r-I N M Ln e-4 a--1 0 M n N lD cn r- ol M N 6:4 Y Oq Y d C f0 'y m N Ovl Y C N O C OD N E C CJ C V C Y y N t O U M co O m (7 0 O t rl W rl 00 N Lf1 M LMD r-I N M Ln e-4 a--1 0 M n N lD cn r- ol M N 6:4 6:5 .,t 0)N p ^p co O rn OD O - — N O) LL O v cNi 000 000 .r.� 0) J V N O) r- � N r cfl to cA d+! EA 64 to E9 69 LU M N M � > Ln pN S O r c0 O t�0 r 0 C UM r r N tr) co W v r > 000 W O OD 1fi p M .17 N OMD N w 0 N W r r EA F- M Q V7 ' W) IA N C ' 00 O) O N OD N M a) U LL LU Ij t- CO N N O it J O Op Ily O -N N is y., N r r .a O CD L Cl) m EA 69 fA fA 69 to U) in co d3 c» m fA V) U C (0 w O aa)) co ~ 0 to O 6 I M h m aD O (D V m N t 0 O t N Z (L pN) O M M c00 Cl) r v U) � 000 O E d V7 LL M r (A O Q N 60, to ++ a) a U ,,- r O m D m rn r, co .M m M Cl ' I ' ' In In C? O m m N M O LO r- U m L OODD In o c*) N U X �i r W CC) Cl) Cl) LIh LU (14 M � O O LO A (M (fl r� O M r- M O 0O Z r LO h 0 0 O IA N M V O IA Cl) 00 O V N (O M 00 N 1- M O Cl) Cl) Cl) JM c0 to Cl) N Q r 00 O m 3 U) a U U N x as a) U m � y p M r o 0 la N 7 LL C M J rn t () Z a ate+ LL u a c9 U v 7 2 4) p U ,� y � F- _ ) LL C 7 U d V C J tll 'd N O d V a C N 3 O F- O LL QI y V 3 d M N N 6 LL U W 'j 7 d (<( a LL 7a; (n d c a at V v O > w .fl " a p' d i a) 3 O 3 Yt E o LU CD 6:5 v m m' a v ■ a m a CD CD o 0 0 m d j N LL a) LL d > � V C y L LL 0 is 0 N � C a) 6:6 N L CL X W f0 U Q 0 a-+ aA m m � u aG Q v ■ C Q C C Q C O O O O O O O C Lr C Ln rn N N N -4 N N lf� in In a 0 W v c LL LL N LL c LL L 6:7 a� C d a 0 w C m CL N 0 c d a cn 0 00 O � � N M � � M � v � v� � tD ,tn C v C N v v v°1, v v CL U w > v e: � o o o v D 7 v► tp N C O O O O O a--I O O O O Ln jLn .� V Q O 0 0 H Ln C O LL o w' W O O L Q L o Q) o 0 o }+ Ln i W i 0 O O 0 O N O O 0 0 Ln N O O O 0 0 M O � � N M � � M � � v� � tD ,tn v v v°1, v v E � o o o v v► tp N C 0 L p 3° d � d w co � N Ul L M 0 E CO L v/ N CD N C d Q x W O d 3 C d d 0 r r M M O m U U m 0 c a U a . N G/ L C > Q N X C) a� � t C O U W M r t � 3 Z, d � V � � U O u- 0 C d � 7 N L r w N C L O O r � L U) N � 3 Q' U L U) N d � m 6:8 City of St. Joseph Quarterly Water Fund Analysis As of March, 31, 2011 Fund 601 +501, Water/WAC Fund Balance as of December 31, 2010 (unaudited) Year to Date Revenue: Interest Earnings Water Usage Charge Water Line Charge Penalties/Other Usage Fees WAC/Trunk Fees Antenna Lease Revenue Bulk Water Sales Transfers from other Funds Total Revenue 2011 Revenue Budget Year to Date Expenses by Department: Debt Payments 24,157.00 Transfers to Other Funds - Power and Pumping (1,067.20) Water Treatment Plant 1 (3,618.71) Water Treatment Plant 2 (10,704.10) Distribution (426.08) Wellhead Protection (96.00) Water Tower (590.62) Water Maintenance 4,353.84 Water Administration (1,597.00) Total Expenses 2011 Expense Budget Fund Summary as of March 31, 2011: 2,486.45 10,780.48 5,639.69 (10,761.51) 7,480.26 499,904.11 15,625.37 1.05% budget collected 1,492,305.00 (includes fund 501) 10,411.13 - 0.69% budget expensed (1,502,575.00) (includes depreciation) EDA Fund Balance - Fund 601 +501 - unaudited $ 525,940.61 Fund 501 $ 1,768.62 Fund 601 $ 524,171.99 Negative revenueslexpenses are the result of reversing audit accruals in January. The balances will be positive as the year goes on. 6:9 r` .j/���.. FUND Descr Last Dim 10100 General Fire Fund Cable Access Fee Economic Development TIF 1-4 St. Joe Development TIF 2 -1 Millstream TIF 2 -2 Meat Market State Collected Sales Tax Park Dedication Recreation Center Charitable Gambling City Beautification - College Av Revolving Loan Fund 2009A CrossoverRefunding Bo 2007 Refunding (98/99 St Bond City Hall Refunded, 2005 2003 Refunding Fire Hall 2003 Cross Over (93 Streets) 2005 Improve (Hill /Clover) 2006 Interior St Improvements 2007 St Imprv-E Side /Jade /8 A 2008 Equipment Certificates 20098 GO CIP Bonds 2010 Equipment Certificates 2010B Street Impr (16th Ave) Debt Service Relief Northland Heights/Trans Corrid 2007 Street Impr (Jade Rd /E 16th Ave Improvements Capital Outlay Water Extension Sewer Extension Water Fund Sewer Fund Refuse Collection Storm Water Utility Last Dim 10100 Last Dim 10200 General Last Dim 10300 2009A CrossoverRefunding Bo 2005 Improve (Hill /Clover) Sewer Fund Last Dim 10300 Account G 101 -10100 G 105 -10100 G 108 -10100 G 150 -10100 G 156 -10100 G 157 -10100 G 158 -10100 G 200 -10100 G 205 -10100 G 210 -10100 G 215 -10100 G 232 -10100 G 250 -10100 G 318 -10100 G 320 -10100 G 322 -10100 G 331 -10100 G 332 -10100 G 333 -10100 G 338 -10100 G 341 -10100 G 342 -10100 G 343 -10100 G 344 -10100 G 345 -10100 G 390 -10100 G 435 -10100 G 441 -10100 G 445 -10100 G 490 -10100 G 501 -10100 G 502 -10100 G 601 -10100 G 602 -10100 G 603 -10100 G 651 -10100 G 101 -10200 G 318 -10300 G 333 -10300 G 602 -10300 CITY OF ST JOSEPH Cash Balances Only Current Period: March 2011 MTD MTD Current Begin Yr Debit Credit Balance $1,018,014.65 $596,051.29 $36,470.32 $8,841.22 $41,593.09 $4,020.96 $0.00 $1,073,053.91 $34,860.89 $51,260.56 $4,988.96 $559.11 $34,565.78 $535,730.38 $339,417.50 $8,360.93 $131,781.20 $67,858.27 $522,709.27 $752,266.94 $380,513.72 $8,781.71 $13.36 $3,037.66 $97,327.14 $288,058.62 $287,130.35 $411,831.23 $225,165.96 $264,610.71 $714.23 $642,716.30 $492,964.93 $405,237.23 $259,158.32 $274,392.68 $9,304,059.38 $275.00 $16,016.54 $5,284.47 $0.00 $12.70 $104.67 $8.70 $0.00 $7,805.64 $87.53 $129.00 $12.56 $0.00 $417.82 $1,356.45 $854.14 $21.71 $347.17 $170.65 $1,323.03 $1,910.94 $1,998.27 $22.40 $0.34 $10.90 $799.26 $1,444.51 $0.00 $0.00 $0.00 $0.00 $925.97 $1,617.56 $33,651.81 $23,459.15 $22,114.59 $8,016.44 $129,924.92 $0.00 $139,417.93 $7,054.04 $0.00 $2,694.46 $0.00 $0.00 $0.00 $0.00 $78.38 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12,000.00 $0.00 $0.00 $19,710.36 $70,808.22 $26,079.52 $2,856.74 $280,699.65 $0.00 $0.00 $0.00 $0.00 $1,023,691.96 $0.00 $0.00 $0.00 $0.00 $0.00 $1,023,691.96 $0.00 $0.00 $605,403.68 $623,094.58 $38,373.50 - $921.29 $41,790.14 $4,037.04 $0.00 $1,134,320.96 $34,791.51 $51,504.65 $5,012.71 $559.11 $35,721.27 $543,173.28 $340,988.59 $8,796.73 $141,687.06 $68,105.54 $529,694.82 $766,439.73 $386,792.15 $8,999.77 $192.53 $2,931.21 $98,764.30 1290,910.22 $283,432.39 $411,831.23 $211,412.46 $234,760.52 $1,768.62 $645,796.53 $524,171.99 $360,903.03 $255,353.53 $282,708.95 $8,973,303.04 $275.00 $0.00 $1,023,691.96 $0.00 $1,023,691.96 $10,328,026.34 $129,924.92 $280,699.65 $9,997,270.00 6:10 r' CITY OF ST JOSEPH Council Month End Revenue Summary Current Period: March 2011 6:11 2011 March 2011 FUND FUND Descr YTD Budget 2011 Amt YTD Amt 101 General $2,524,385.00 $13,597.02 $37,060.81 105 Fire Fund $262,195.00 $4,268.04 $55,102.43 108 Cable Access Fee $0.00 $0.00 $476.40 150 Economic Development $83,990.00 $12.70 $1.42 156 TIF 1 -4 St. Joe Development $0.00 $104.67 $91.38 157 TIF 2 -1 Millstream $0.00 $8.70 $11.26 158 TIF 2 -2 Meat Market $0.00 $0.00 $0.00 200 State Collected Sales Tax $0.00 $7,805.64 $1,002.08 205 Park Dedication $0.00 $87.53 $58.80 210 Recreation Center $0.00 $129.00 $103.48 215 Charitable Gambling $0.00 $12.56 $9.59 232 City Beautification - College Av $0.00 $0.00 $0.00 250 Revolving Loan Fund $0.00 $417.82 $1,065.98 318 2009A CrossoverRefunding Bonds $71,000.00 $1,356.45 $929.32 320 2007 Refunding (98/99 St Bond) $8,500.00 $854.14 $516.88 322 City Hall Refunded, 2005 $95,000.00 $21.71 $7.19 331 2003 Refunding Fire Hall $71,080.00 $347.17 $9,440.51 332 2003 Cross Over (93 Streets) $0.00 $170.65 $34.67 333 2005 Improve (Hill /Clover) $17,000.00 $1,323.03 $973.36 338 2006 Interior St Improvements $61,000.00 $1,910.94 $1,417.61 341 2007 St Imprv-E Side /Jade/8 Av $20,000.00 $1,998.27 $1,237.87 342 2008 Equipment Certificates $67,000.00 $22.40 $0.53 343 2009B GO CIP Bonds $66,800.00 $0.34 - $24.56 344 2010 Equipment Certificates $33,000.00 $10.90 - $37.53 345 2010B Street Impr (16th Ave) $12,000.00 $799.26 $1,103.94 390 Debt Service Relief $0.00 $1,444.51 - $633.55 445 16th Ave Improvements $0.00 $0.00 $0.00 490 Capital Outlay $0.00 $0.00 $0.00 501 Water Extension $372,500.00 $925.97 $0.00 502 Sewer Extension $192,750.00 $1,617.56 $1,166.62 601 Water Fund $1,125,350.00 $29,543.83 $15,625.37 602 Sewer Fund $714,820.00 $23,416.11 - $243,426.13 603 Refuse Collection $303,150.00 $19,767.91 $12,123.47 651 Storm Water Utility $168,605.00 $8,014.67 $5,613.02 $6,270,125.00 $119,989.50 - $98,947.78 6:11 r' CITY OF ST JOSEPH Council Month End Revenue - General Fund Current Period: March 2011 FUND 108 Cable Access Fee 6:12 2011 March 2011 FUND FUND Descr SOURCE Descr YTD Budget 2011 Amt YTD Amt FUND 101 General 101 General Current Ad Valorem Taxes $1,262,695.00 $0.00 $0.00 101 General Special Levy- City St. Joe $38,835.00 $0.00 $0.00 101 General State Sales Tax $0.00 $16.80 - $202.39 101 General Gas Franchise $32,000.00 $0.00 $0.00 101 General Electric Franchise $49,000.00 $1,647.53 $3,190.64 101 General Beer $600.00 $0.00 $0.00 101 General Liquor $16,520.00 $0.00 $0.00 101 General Outdoor Liquor Permit $2,500.00 $0.00 $1,750.00 101 General Gambling Permits $150.00 $0.00 $25.00 101 General Amusement/Hunting Permit $1,200.00 $0.00 $0.00 101 General Contractors License $0.00 $0.00 $0.00 101 General Excavation Permit $200.00 $0.00 $0.00 101 General Cigarette License $500.00 $0.00 $0.00 101 General Cable Franchise Fee $25,000.00 $0.00 $0.00 101 General Building Permits $50,000.00 $1,511.94 $4,122.99 101 General Animal License $3,000.00 $1,149.00 $1,273.00 101 General Rental Housing Registration $19,000.00 $75.00 $225.00 101 General Federal Grants - Other $3,000.00 $0.00 $0.00 101 General Local Government Aid $807,470.00 $0.00 $0.00 101 General Market Value Credit $0.00 $0.00 $0.00 101 General PERA Rate Increase Aid $1,540.00 $0.00 $0.00 101 General Police Training Reim $3,500.00 $0.00 $0.00 101 General State Municipal Funds Aid $6,200.00 $0.00 $3,090.00 101 General State Police Aid $45,000.00 $0.00 $0.00 101 General Other Grants /Aids $0.00 $0.00 $0.00 101 General Other Governmental Unit $10,000.00 $0.00 $0.00 101 General County Grants - Road Maintena $7,750.00 $0.00 $0.00 101 General Zoning and Subdivision Fee $1,250.00 $0.00 $0.00 101 General Land Use Deposit Fee $4,000.00 $0.00 $0.00 101 General Sale of Maps and Publications $75.00 $22.00 $27.75 101 General Assessments Search $2,500.00 $210.00 $565.00 101 General Special Hearing $4,500.00 $200.00 $200.00 101 General Administration Reimb $11,600.00 $0.00 $0.00 101 General Weed Cutting $1,000.00 $0.00 $0.00 101 General Park Fees $4,500.00 $480.00 $2,075.00 101 General Winter Recreation Donation $0.00 $0.00 $0.00 101 General Kennel Fees $500.00 $0.00 $0.00 101 General County Fines $30,000.00 $2,982.49 $4,962.27 101 General Policy Fines $35,000.00 $2,080.00 $6,210.00 101 General Accident Report Fee $1,000.00 $60.00 $185.00 101 General Seized Property $500.00 $0.00 $0.00 101 General Special Assessments $2,000.00 $0.00 $0.00 101 General Interest Earnings $7,500.00 $2,872.11 $3,130.34 101 General Interest Charges $150.00 $13.10 $43.10 101 General Co -op Dividend -MN League of C $8,000.00 $0.00 $0.00 101 General Water Tower Antenna Lease $3,500.00 $277.05 $831.15 101 General Land Rental $2,400.00 $0.00 $0.00 101 General Contributions from Private Sou $0.00 $0.00 $100.00 101 General Contribution - Health Ins Div $0.00 $0.00 $0.00 101 General Contributions -Pvte Holiday Lts $0.00 $0.00 $0.00 101 General Contributions - Parks $600.00 $0.00 $0.00 101 General Surplus Property $250.00 $0.00 $0.00 101 General Reimbursement $3,900.00 $0.00 $5,256.96 101 General Transfers from Other Funds $14,000.00 $0.00 $0.00 FUND 101 General $2,524,385.00 $13,597.02 $37,060.81 FUND 108 Cable Access Fee 6:12 r' CITY OF ST JOSEPH Council Month End Revenue - General Fund Current Period: March 2011 $2,608,375.00 $13,609.72 $37,538.63 6:13 2011 March 2011 FUND FUND Descr SOURCE Descr YTD Budget 2011 Amt YTD Amt 108 Cable Access Fee Cable Franchise Fee $0.00 $0.00 $476.40 FUND 150 Economic Development 150 Economic Development TIF /MIF Deposit $0.00 $0.00 $0.00 150 Economic Development Interest Earnings $150.00 $12.70 $1.42 150 Economic Development Transfers from Other Funds $83,840.00 $0.00 $0.00 FUND 150 Economic Development $83,990.00 $12.70 $1.42 FUND 158 TIF 2 -2 Meat Market 158 TIF 2 -2 Meat Market Tax Increment $0.00 $0.00 $0.00 158 TIF 2 -2 Meat Market TIF/MIF Deposit $0.00 $0.00 $0.00 158 TIF 2 -2 Meat Market Interest Earnings $0.00 $0.00 $0.00 FUND 158 TIF 2 -2 Meat Market $0.00 $0.00 $0.00 $2,608,375.00 $13,609.72 $37,538.63 6:13 r' CITY OF ST JOSEPH Council Month End Revenue - Enterprise Funds Current Period: March 2011 FUND 2011 March 2011 FUND Descr SOURCE Descr YTD Budget 2011 Amt YTD Amt FUND 601 Water Fund 601 Water Fund Penalties and Forfeited Disc $6,670.00 $523.88 $1,429.03 601 Water Fund Bond Premium Proceeds $0.00 $0.00 $0.00 601 Water Fund General Oblig. Bond Proceeds $0.00 $0.00 $0.00 601 Water Fund Transfers from Other Funds $536,300.00 $0.00 $0.00 601 Water Fund Contributed Revenue $0.00 $0.00 $0.00 601 Water Fund MDS Test Fee $10,975.00 $755.62 $523.23 601 Water Fund Water Line Charge $130,835.00 $8,246.79 $5,639.69 601 Water Fund State Sales Tax $425.00 - $18.29 - $2,364.36 601 Water Fund Water Meter $4,000.00 $1,050.00 $1,050.00 601 Water Fund Connection /Reconnection fees $250.00 $0.00 $0.00 601 Water Fund Undesignated Funds $500.00 $36.25 - $45.42 601 Water Fund Bulk Water $3,500.00 $0.00 $0.00 601 Water Fund Rate Class One $362,495.00 $15,166.91 $10,780.48 601 Water Fund Reimbursement $0.00 $0.00 $0.00 601 Water Fund Surplus Property $0.00 $0.00 $0.00 601 Water Fund Water Tower Antenna Lease $32,000.00 $2,493.42 $7,480.26 601 Water Fund Amortization of Bond Premium $0.00 $0.00 $0.00 601 Water Fund Interest Earnings $35,850.00 $1,289.25 $2,486.45 601 Water Fund Special Assessments $1,550.00 $0.00 - $11,353.99 601 Water Fund Inspection Fees $0.00 $0.00 $0.00 FUND 601 Water Fund $1,125,350.00 $29,543.83 $15,625.37 FUND 602 Sewer Fund 602 Sewer Fund Contributed Revenue $0.00 $0.00 $0.00 602 Sewer Fund Federal Grants - Other $0.00 $0.00 $0.00 602 Sewer Fund Special Assessments $500.00 $0.00 - $431.04 602 Sewer Fund Interest Earnings $33,315.00 $1,007.59 $427.62 602 Sewer Fund Amortization of Bond Premium $0.00 $0.00 $0.00 602 Sewer Fund Sewer Inspection Fee $0.00 $0.00 $0.00 602 Sewer Fund Surplus Property $0.00 $0.00 $0.00 602 Sewer Fund Reimbursement $0.00 $0.00 $62.00 602 Sewer Fund Bond Premium Proceeds $0.00 $0.00 $0.00 602 Sewer Fund General Oblig. Bond Proceeds $0.00 $0.00 $0.00 602 Sewer Fund Sewer Surcharge - (Monthly) $0.00 $0.00 $0.00 602 Sewer Fund Sewer Line Charge $141,035.00 $8,779.07 $5,847.72 602 Sewer Fund Penalties and Forfeited Disc $4,375.00 $405.26 $1,034.67 602 Sewer Fund St. Benedict's SCAWAC fees $80,835.00 $0.00 - $111,577.08 602 Sewer Fund St. Benedict Sewer Charges $108,625.00 $0.00 - $145,831.34 602 Sewer Fund Sanitary Sewer Service $247,335.00 $13,224.19 $7,041.32 602 Sewer Fund Transfers from Other Funds $98,800.00 $0.00 $0.00 FUND 602 Sewer Fund $714,820.00 $23,416.11 $243,426.13 FUND 603 Refuse Collection 603 Refuse Collect State Sales Tax $0.00 - $492.74 - $1,361.51 603 Refuse Collect Special Assessments $500.00 $0.00 - $1,288.43 603 Refuse Collect Interest Earnings $3,500.00 $648.20 $492.90 603 Refuse Collect Contributions from Private Sou $250.00 $0.00 $0.00 603 Refuse Collect Penalties and Forfeifted Disc $5,500.00 $653.01 $1,605.85 603 Refuse Collect Licenses & Permits $17,600.00 $0.00 $0.00 603 Refuse Collect Refuse Collection Charges $275,800.00 $18,959.44 $12,674.66 FUND 603 Refuse Collection $303,150.00 $19,767.91 $12,123.47 FUND 651 Storm Water Utility 651 Storm Water Transfers from Other Funds $0.00 $0.00 $0.00 651 Storm Water Special Assessments $675.00 $0.00 - $192.80 651 Storm Water Interest Earnings $14,205.00 $691.37 $496.76 6'14 r' CITY OF ST JOSEPH Council Month End Revenue - Enterprise Funds Current Period: March 2011 $2,311,925.00 $80,742.52 - $210,064.27 6:15 FUND 2011 March 2011 FUND Descr SOURCE Descr YTD Budget 2011 Amt YTD Amt 651 Storm Water Contributed Revenue $0.00 $0.00 $0.00 651 Storm Water Development Fee $4,000.00 $0.00 $0.00 651 Storm Water Rate Class One $148,000.00 $7,162.94 $4,897.09 651 Storm Water Penalties and Forfeifted Disc $1,725.00 $160.36 $411.97 FUND 651 Storm Water Utility $168,605.00 $8,014.67 $5,613.02 $2,311,925.00 $80,742.52 - $210,064.27 6:15 r' CITY OF ST JOSEPH Council Month End Expenditure - Summary Current Period: March 2011 6:16 2011 March 2011 Description YTD Budget 2011 Amt YTD Amt General $2,524,385.00 $138,004.81 $448,156.08 Fire Fund $280,965.00 $6,037.61 $24,613.66 Cable Access Fee $0.00 $0.00 $0.00 Economic Development $83,990.00 $2,694.46 $6,085.28 TIF 1 -4 St. Joe Development $0.00 $0.00 $0.00 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 $0.00 $0.00 Park Dedication $10,300.00 $78.38 $156.76 Charitable Gambling $0.00 $0.00 $0.00 Revolving Loan Fund $0.00 $0.00 $0.00 2009A CrossoverRefunding Bon $358,440.00 $0.00 $0.00 2007 Refunding (98/99 St Bond) $166,780.00 $0.00 $0.00 City Hall Refunded, 2005 $104,440.00 $0.00 $0.00 2003 Refunding Fire Hall $79,125.00 $0.00 $0.00 2003 Cross Over (93 Streets) $67,050.00 $0.00 $0.00 2005 Improve (Hill /Clover) $148,795.00 $0.00 $0.00 2006 Interior St Improvements $212,170.00 $0.00 $0.00 2007 St Impry -E Side /Jade /8 Av $564,470.00 $0.00 $0.00 2008 Equipment Certificates $66,300.00 $0.00 $0.00 2009B GO CIP Bonds $61,860.00 $0.00 $0.00 2010 Equipment Certificates $34,125.00 $0.00 $0.00 2010B Street Impr (16th Ave) $0.00 $0.00 $0.00 Debt Service Relief $0.00 $0.00 $0.00 Northland Heights/Trans Corrid $0.00 $0.00 $1,204.39 2007 Street Impr (Jade Rd /E $0.00 $0.00 $0.00 2010A Equip Certificates $0.00 $0.00 $0.00 16th Ave Improvements $0.00 $0.00 - $14,127.70 Capital Outlay $0.00 $12,000.00 $18,359.54 Water Extension $0.00 $0.00 $0.00 Sewer Extension $0.00 $0.00 $0.00 Water Fund $1,502,575.00 $15,602.38 - $10,411.13 Sewer Fund $1,059,565.00 $70,765.18 $55,356.54 Refuse Collection $317,385.00 $23,732.84 $42,580.87 Storm Water Utility $273,010.00 $2,854.97 $8,689.69 $7,915,730.00 $271,770.63 $580,663.98 6:16 r' CITY OF ST JOSEPH Council Month End Expenditure - General Fund Current Period: March 2011 FUND 101 General FUND 108 Cable Access Fee Cable Access Fee Cable Access FUND 150 Economic Development Economic Development Economic Development Authority FUND 150 Economic Development FUND 158 TIF 2 -2 Meat Market TIF 2 -2 Meat Market FUND 158 TIF 2 -2 Meat Market FUND 490 Capital Outlay Economic Development Authority $2,524,385.00 $138,004.81 $0.00 $0.00 $448,156.08 $0.00 $83,990.00 $2,694.46 $6,085.28 $83,990.00 $2,694.46 $6,085.28 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Capital Outlay Elections 2011 March 2011 Description DEPART Descr YTD Budget 2011 Amt YTD Amt FUND 101 General City Offices $0.00 $0.00 $0.00 General Council $48,750.00 $2,268.37 $7,857.58 General Legislative Committees $8,980.00 $31.16 $66.16 General Ordinance & Proceedings $3,000.00 $372.56 $1,531.76 General Mayor $14,110.00 $590.29 $1,465.58 General Elections $3,000.00 $0.00 $0.00 General Salaries & Adminstrative $227,230.00 $15,237.76 $47,923.30 General Accounting $107,060.00 $7,490.35 $25,321.13 General Audit Service $25,900.00 $4,500.00 $4,500.00 General Assessing $19,000.00 $0.00 $0.00 General City Attorney $20,000.00 $1,282.50 $2,470.50 General Planning and Zoning $2,450.00 $2,014.19 $283.50 General General Government $31,380.00 $1,776.32 $4,316.73 General City Offices $26,525.00 $2,102.68 $5,271.71 General Facilites and Planning $0.00 $0.00 $0.00 General Cable Access $8,355.00 $907.77 $2,402.11 General Crime Control & Investigation $819,660.00 $52,135.65 $159,940.44 General Police Training $10,000.00 $3,427.28 $3,792.28 General Communication Service $18,700.00 $806.46 $2,181.57 General Automotive Services $68,675.00 $4,068.04 $8,295.57 General Building Inspec. Admistration $82,550.00 $71500.00 $15,000.00 General Emergency Management $5,800.00 $307.77 $415.20 General Signal Lights $800.00 $175.55 $365.85 General Animal Control $1,150.00 $150.32 $404.00 General Ordinance/Easement Enforcement $300.00 $0.00 $0.00 General Street Maintanence $255,430.00 $11,717.19 $39,400.85 General Ice & Snow Removal $76,285.00 $9,208.44 $48,408.26 General Engineering Fee $37,000.00 $0.00 $1,322.94 General Street Lighting $42,500.00 $3,552.06 $7,743.32 General Street Cleaning $26,010.00 $0.00 $0.00 General Skate Park and Ice Rink $4,280.00 $134.25 $1,682.36 General Maint Shop $25,200.00 $1,810.53 $7,829.84 General Park Areas $208,200.00 $5,437.32 $20,494.52 General Community Support $14,220.00 - $1,000.00 $4,200.00 General Other Financing Uses $188,965.00 $0.00 $0.00 General Fire Protection $92,920.00 $0.00 $23,269.02 FUND 101 General FUND 108 Cable Access Fee Cable Access Fee Cable Access FUND 150 Economic Development Economic Development Economic Development Authority FUND 150 Economic Development FUND 158 TIF 2 -2 Meat Market TIF 2 -2 Meat Market FUND 158 TIF 2 -2 Meat Market FUND 490 Capital Outlay Economic Development Authority $2,524,385.00 $138,004.81 $0.00 $0.00 $448,156.08 $0.00 $83,990.00 $2,694.46 $6,085.28 $83,990.00 $2,694.46 $6,085.28 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Capital Outlay Elections $0.00 $0.00 $0.00 Capital Outlay Salaries & Adminstrative $0.00 $0.00 $0.00 Capital Outlay City Offices $0.00 $0.00 $0.00 Capital Outlay Cable Access $0.00 $0.00 $0.00 Capital Outlay Crime Control & Investigation $0.00 $0.00 $0.00 Capital Outlay Communication Service $0.00 $0.00 $0.00 6:17 ,I CITY OF ST JOSEPH Council Month End Expenditure - General Fund Current Period: March 2011 $2,608,375.00 $152,699.27 $472,600.90 6:18 2011 March 2011 Description DEPART Descr YTD Budget 2011 Amt YTD Amt Capital Outlay Automotive Services $0.00 $0.00 $1,028.14 Capital Outlay Emergency Management $0.00 $0.00 $0.00 Capital Outlay Street Maintanence $0.00 $0.00 $5,331.40 Capital Outlay Ice & Snow Removal $0.00 $0.00 $0.00 Capital Outlay Street Lighting $0.00 $0.00 $0.00 Capital Outlay Street Cleaning $0.00 $0.00 $0.00 Capital Outlay Skate Park and Ice Rink $0.00 $0.00 $0.00 Capital Outlay Maint Shop $0.00 $0.00 $0.00 Capital Outlay Park Areas $0.00 $12,000.00 $12,000.00 Capital Outlay Other Financing Uses $0.00 $0.00 $0.00 FUND 490 Capital Outlay $0.00 $12,000.00 $18,359.54 $2,608,375.00 $152,699.27 $472,600.90 6:18 r' CITY OF ST JOSEPH Council Month End Expense - Enterprise Funds Current Period: March 2011 11-API 2011 March 2011 Description DEPART Descr YTD Budget 2011 Amt YTD Amt FUND 601 Water Fund Water Fund Bond Payment (P & 1) $658,280.00 $0.00 - $24,157.00 Water Fund Other Financing Uses $55,000.00 $0.00 $0.00 Water Fund Power and Pumping $29,150.00 $546.64 $1,067.20 Water Fund Purification -Plant 1 $19,810.00 $1,303.22 $3,618.71 Water Fund Purification -Plant 2 $68,305.00 $274.05 $10,704.10 Water Fund Distribution $47,000.00 $0.00 $426.08 Water Fund Wellhead Protection $2,000.00 $0.00 $96.00 Water Fund Storage -Tower 1 $3,250.00 $283.95 $590.62 Water Fund Storage -Tower 2 $0.00 $0.00 $0.00 Water Fund Water Maintenance $222,545.00 $10,550.08 - $4,353.84 Water Fund Administration and general $37,235.00 $2,644.44 $1,597.00 Water Fund Depreciation Expense $360,000.00 $0.00 $0.00 FUND 601 Water Fund $1,502,575.00 $15,602.38 $10,411.13 FUND 602 Sewer Fund Sewer Fund Bond Payment (P & 1) $47,975.00 $0.00 - $2,580.00 Sewer Fund Other Financing Uses $55,000.00 $0.00 $0.00 Sewer Fund Sanitary Sewer Maintenanc $195,170.00 $9,567.04 - $11,324.04 Sewer Fund Lift Station -Baker Street $3,470.00 $221.19 $494.81 Sewer Fund Lift Station -DBL Labs Area $2,975.00 $185.23 $418.13 Sewer Fund Lift Station - Northland $2,775.00 $157.55 $361.40 Sewer Fund Lift Station -CR 121 $3,775.00 $192.77 $1,132.14 Sewer Fund Lift Station -Main $489,460.00 $57,075.77 $63,734.59 Sewer Fund Administration and general $43,965.00 $3,365.63 $3,119.51 Sewer Fund Depreciation Expense $215,000.00 $0.00 $0.00 FUND 602 Sewer Fund $1,059,565.00 $70,765.18 $55,356.54 FUND 603 Refuse Collection Refuse Collectio Waste Collection $312,595.00 $23,732.84 $42,580.87 Refuse Collectio Other Financing Uses $4,790.00 $0.00 $0.00 FUND 603 Refuse Collection $317,385.00 $23,732.84 $42,580.87 FUND 651 Storm Water Utility Storm Water Util Other Financing Uses $57,330.00 $0.00 $0.00 Storm Water Util Administration and general $15,210.00 $825.54 $2,845.51 Storm Water Util Storm Water Maintenance $115,470.00 $2,029.43 $5,844.18 Storm Water Util Depreciation Expense $85,000.00 $0.00 $0.00 FUND 651 Storm Water Utility $273,010.00 $2,854.97 $8,689.69 $3,152,535.00 $112,955.37 $96,215.97 11-API L O m -1 E O E N 3 N LA L 0 0 0 C) Ln m N 00 O LD O O 00 .1 O m O O O LD O O 00 -It O m Ol N C r 00 m LD O 1, -1 O m1:t O 0 1\ 0 0 1\ N O O 00 00 o Ql Ol n C r- r N M o" Ln ri o M 00 o n o 6 r, 0 o m W r-4 o Sri Ln ri C Ln N 00 0) 0 00 LD O 1, Ln O m Ln m it o o N LD m o r-I �--� N jp Lp N LD LD m Ln 00 m N n V ll 00 LD lzz 00 O O N m Lr1 N N V - E f0 O M N LD r-I 00 M -11, m n m O Ln LD LD r-I 00 N LD LD ri D1 O 1� (� m .1 e-i N Lr N Q1 11 r-I N rl 00 z3- r-1 Ln LD O m -zl- N U) a I > U 1-i y E C 3 E a) .r-I-I a) .� p t O E O U) O Cl) a) m 1. 0 0 0 C) O O O O O O O O O O O O O O O O O O O O W O V O O O O O O O O O O O O O O O O O O O O L N W O d r 4 0 0 0 0 0 0 0 Ln O Ln 0 0 0 0 0 0 0 0 0 0 m ui a-1 0 0 0 0 O O Ln n O N O O Ln O O O Ln 0 0 0 0� 1l 'O o O Ln O Ln O O N O o m O O N O O m 0 m O m N N w 3 N m m r'n N a-i 0 m LD r--I - N 6 m 00 -; Lr 00 m N � r-I lfl O — — — N CV N > 3 3 m O m N N N N — M M M Cl) U*) Lr) O O V 00 -1 .m-1 .^-I -1 Lr) O O O O m N Lr T Ln m 0 0 0 0 0 0 0 "t r "t 'IT 'It ',I- L() Lr) U) a I > U 1-i 0 0 0 C) c .1 LA M E O .4 n o Ln N o 00 o6 o6 te) N t 7 N LD W O 00 V to X W > a m d a! r_ LC � Q. r0 E U L ate+ 1 a — c 1- \ M d L o M M L.L w O L L N W p Q N j 4J N C !'I O m U OD Q o L C L N -a 'p w � rH C 3 00 M O N 0 0 0 C) O .1 0 m O m o Ln N 6 00 o6 o6 m O O O O O .1 0 m O m o Ln N O 00 Ln 1'�oc� v Ln Ln m m o �I�i7 Ei, 3 a_ Ln m N 00 O LD o O 00 Ln O m O O O LD O O 00 V O 1, 1\ Ll d a! r_ a a) EC V 00 m LD O 1- .-1 o m Ln o C 1 O O -1 N o 0 W N O Ur Lrl a (, °- 2> .E a) o a O a) O a � rH N M O N .1 O m '1 0 0 O m m-t 3 a) O m w V O N N m w 3 c U) m m rp O E E EU) '� N 1, N 00 m 0� 'O O O Q Lp N o r-4 r-I o KT Ln m n Ln O N LD .1 o LD LD WO0 O o0 00 LC) a0 Lp N N a-I lD lD O 00 Ln .-•I' m 00 V N Ln � � Ln lD � V �1 N N O � N O 00 m N � r-I lfl O — — — N CV N > 3 3 m O m N N N N — M M M Cl) U*) Lr) O O V 00 -1 .m-1 .^-I -1 Lr) O O O O m ct O O T Ln m 0 0 0 0 0 0 0 "t r "t 'IT 'It ',I- L() Lr) U) > U y E C 3 E a) all 00 co LnM C71 O M N d m O a E �a CL m U a) C a) lC O H 6:20 a_ a_ U U C: U U C d E C Q) Q C a a� C Y > aci E .a 0 E W c Y a nz o f 3: m r_ a a) EC °_ O 3 r _a O 0 a° . :3 w V 0 al CLa) Q U Lp w • V _ 3 Q cn O C w w O N •c Q O E a A > a E E W � U) °- 2> .E a) o a O a) O a fO n E w@ m L ° u o • w mE e > a E .H (T 3 m o W (1) wcr U) cw F. ° 3 a) L 3 s a am E °' m w 3 c U) m m a O E E EU) '� N E s a a� m O N L E Q 'O O O Q Lp O O a) E O L C +L N O D wQUUC�LL_ wU >w T-65 A(n2m Uw 0 0 N O O O O O O 0 0 0 0 0 0 0 N M M h 00 00 O O o0 00 LC) a0 N M w w m m 00 00 00 O Lf) L(') Lr) In M M L Lf) Lf) Lf) Lf) N In LL) lfj l!) l!) lf) 1 1 L0 L0 L y 0 0 0 o 0 0 M O— N O N O O L!) O— N O O � Cl) Cl) M Cl) N Lr) L) O -,;1- N N N N O O O O C— IZt lzt It It L() O — — L) O — — — N CV N Li) Ln 3 3 m O -- r- - -- N N N N — M M M Cl) U*) Lr) O O V It It It It It It d V V It 't a 0 0 0 0 O O O O O — 6 0 0 0 6 O O 0 O) O O O r 'Ct r OCY) Cn 0 `ct V 'IT 0 0 0 0 0 0 0 "t r "t 'IT 'It ',I- L() Lr) U) > U y E C 3 E a) a) .� p t O E O U) O Cl) a) m 1. o 3 o c v_, m CD Q c U —_ aE) m M U c o o L • °- E C T m a) a) m U) a- N O" •� Y Q Q N 'a N O O O E wwww wQ LL LL aaaw C) U) nin�� all 00 co LnM C71 O M N d m O a E �a CL m U a) C a) lC O H 6:20