HomeMy WebLinkAbout[04c] Treasurer Report i4rAtiv Council Agenda Item
crrr OF s7:josrstt g T )
MEETING DATE: July 5, 2012
•
AGENDA ITEM: Treasurer's Report — Requested Action: Accept the May 2012
Treasurer's Report
SUBMITTED BY: Finance
BOARD /COMNIISSION /COMMITTER RECOMMENDATION: N/A
PREVIOUS COUNCIL ACTION: None
BACKGROUND INFORMATION:
May 2012 reconciled cash/investment and budget to actual position for Council review.
The cash and investment balance decreased $917,426 since the beginning of the year. The first few
months of the year will be operational in nature. The cash coming in are typically permit, sales tax,
franchise fees and utility revenues. The expenditures are the monthly operational expenses and the first
half debt interest expense payments. Cash will increase in June and July when the first half property tax
settlement and state aid payments come in.
The General fund spent 35% of the expenditure budget and received 7% of the revenue budget at the end
of April. Expenses include regular operating expenses, general liability insurance and membership dues.
The Enterprise funds spent 22% (without depreciation) and received 21 %(without the advanced
refunding proceeds) of the revenue budget. The revenue includes utility billing receipts from
January/February and part March/April usage. March - April usage was billed in May, due June 20
Expenses are regular monthly operating expenses and the first half debt interest payments..
BUDGET/FISCAL IMPACT: None — Information Only
ATTACHMENTS: Request for Council Action — Treasurer's Report
May 2012 Treasurer's Reports:
Cash Balances
Month End Revenue Summary
Month End Revenue Summary — General Fund
Month End Revenue Summary — Enterprise Funds
Month End Expenditure summary
Month End Expenditure Summary — General Fund
Month End Expense Summary - Enterprise Funds
REQUESTED COUNCIL ACTION: Accept the Treasurer's Report as presented.
This page intentionally left blank
r' CITY OF ST JOSEPH
,`d h A� Cash Balances Only
Current Period: May 2012
MTD MTD Current
FUND Descr Account Begin Yr Debit Credit Balance
Last Dim 10100
General G 101 -10100 $1,096,812.16 $61,607.91 $196,337.56 $406,733.05
Fire Fund G 105 -10100 $625,739.17 $6,590.69 $5,339.03 $655,092.52
Cable Access Fee G 108 -10100 41,237.61 $1,611.19 $0.00 $2,603.42
Economic Development G 150 -10100 $51,328.42 $95.96 $2,577.06 $35,674.80
TIF 1 -4 St. Joe Development G 156 -10100 $17.95 $0.02 $0.00 $8.83
TIF 2 -1 Millstream G 157 -10100 $8,443.84 $16.91 $0.00 $7,235.60
TIF 2 -2 Meat Market G 158 -10100 $3.26 $0.00 $0.00 $3.26
State Collected Sales Tax G 200 -10100 $1,240,510.91 $28,299.77 $6,189.55 $1,313,868.91
Park Dedication G 205 -10100 $72,835.88 $180.34 $121.04 $73,240.88
Recreation Center G 210 -10100 $52,273.94 $121.68 $27.40 $52,105.70
Charitable Gambling G 215 -10100 $5,092.24 $12.00 $0.00 $5,143.84
Revolving Loan Fund G 250 -10100 $14,158.07 $711.65 $0.00 $17,677.64
2009A CrossoverRefunding Bon G 318 -10100 $489,013.10 $1,153.47 $26,893.75 $467,603.43
2007 Refunding (98/99 St Bon G 320 -10100 $269,082.34 $648.72 $8,172.50 $269,929.98
City Hall Refunded, 2005 G 322 -10100 $5,442.91 $13.25 $7,246.25 - $1,568.47
2011A Refunding Fire Hall G 331 -10100 $126,537.01 $317.42 $0.00 $142,098.14
2005 Improve (Hill /Clover) G 333 -10100 $452,837.96 $1,069.97 $22,597.50 $436,101.12
2006 Interior St Improvements G 338 -10100 $276,886.58 $727.53 $35,884.38 $275,994.09
2007 St Imprv-E Side/Jade /8 A G 341 -10100 $271,757.08 $1,508.76 $17,034.38 $261,777.63
2008 Equipment Certificates G 342 -10100 $8,944.04 $21.37 $2,100.00
$7,060.51
20096 GO CIP Bonds G 343- 10100 $3,825.31 $9.30 $6,017.50 - $2,031.94
2010 Equipment Certificates G 344-10100 $1,247.83 $3.08 $1,650.00 4331.72
2010B Street Impr (16th Ave) G 345 -10100 $235,563.66 $598.59 $9,227.50 $247,376.55
2011A Pumper Truck Certificat G 346 -10100 $4,196.58 $2,776.60 $0.00 $19,466.15
2011A GO CIP Bonds G 347 - 10100 $5,603.83 $1,269.60 $0.00 $9,014.46
Debt Service Relief G 390 -10100 $339,854.04 $1,429.42 $0.00 $347,068.78
Northland Heights/Trans Corrid G 435 -10100 $274,071.30 $0.00 $3,298.55 $257,743.14
2007 Street Impr (Jade Rd /E G 441 -10100 $365,338.49 $0.00 $0.00 $367,995.11
2011A Pumper Truck Certificat G 446 -10100 $383,405.58 $0.00 $0.00 $383,405.58
2011A GO CIP Bonds G 447 -10100 $173,332.63 $0.00 $0.00 $174,042.45
Capital Outlay G 490 -10100 $222,287.15 $8,534.59 $17,130.39 $211,532.88
Water Extension G 501 -10100 $735.86 $5,240.73 $0.00 $18,449.42
Sewer Extension G 502 -10100 $723,179.50 $4,385.62 $0.00 $739,716.96
Water Fund G 601 -10100 $237,621.48 $44,069.77 $170,740.96 $145,067.74
Sewer Fund G 602 -10100 $672,223.82 $58,695.96 $73,675.32 $423,773.29
Refuse Collection G 603 -10100 $258,434.00 $25,812.23 $28,150.18 $265,665.21
Storm Water Utility G 651 -10100 $175,200.83 $8,764.18 $8,950.69 $188,836.42
Last Dim 10100 $9,142,601.14 $266,298.28 $649,361.49 $8,225,175.36
Last Dim 10200
General G 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 $1,002,063.22
2006 Interior St Improvements G 338 -10300 $1,468,731.57 $0.00 $0.00 $1,468,731.57
Water Fund G 601 -10300 $0.00 $0.00 $0.00 $4,855,333.03
Last Dim 10300 $2,470,794.79 $0.00 $0.00 $7,326,127.82
$11,613,670.93 $266,298.28 $649,361.49 $15,551,578.18
,�,�1 CITY OF ST JOSEPH
Council Month End Revenue Summary
Current Period: May 2012
2012 May 2012
FUND FUND Descr YTD Budget 2012 Amt YTD Amt
101 General $2,183,300.00 $60,172.43 $160,305.35
105 Fire Fund $270,445.00 $6,568.89 $89,596.99
108 Cable Access Fee $0.00 $1,611.19 $2,949.86
150 Economic Development $70,725.00 $95.96 $408.60
156 TIF 1 -4 St. Joe Development $0.00 $0.02 - $49.49
157 TIF 2 -1 Millstream $0.00 $16.91 $66.89
158 TIF 2 -2 Meat Market $0.00 $0.00 $0.00
200 State Collected Sales Tax $0.00 $28,299.77 $36,124.87
205 Park Dedication $0.00 $180.34 $694.92
210 Recreation Center $0.00 $121.68 $443.21
215 Charitable Gambling $0.00 $12.00 $43.58
250 Revolving Loan Fund $8,380.00 $711.65 $3,485.62
318 2009A CrossoverRefunding Bonds $308,525.00 $1,153.47 $4,017.76
320 2007 Refunding (98/99 St Bond) $90,980.00 $648.72 $2,243.34
322 City Hall Refunded, 2005 $94,190.00 $13.25 $12.55
331 2011A Refunding Fire Hall $67,390.00 $317.42 $19,177.13
333 2005 Improve (Hill /Clover) $114,080.00 $1,069.97 $3,800.63
338 2006 Interior St Improvements $180,425.00 $727.53 $2,109.89
341 2007 St Imprv-E Side /Jade /8 Av $554,080.00 $1,508.76 $5,130.57
342 2008 Equipment Certificates $67,165.00 $21.37 $53.29
343 20098 GO CIP Bonds $66,800.00 $9.30 $12.56
344 2010 Equipment Certificates $34,500.00 $3.08 -$2.52
345 2010B Street Impr (16th Ave) $59,005.00 $598.59 $2,044.71
346 2011A Pumper Truck Certificate $32,455.00 $2,776.60 $18,830.71
347 2011A GO QP Bonds $60,350.00 $1,269.60 $5,180.08
390 Debt Service Relief $0.00 $1,429.42 $6,191.00
446 2011A Pumper Truck Certificate $0.00 $0.00 $0.00
447 2011A GO CIP Bonds $0.00 $0.00 $0.00
490 Capital Outlay $0.00 $8,534.59 $8,534.59
501 Water Extension $567,535.00 $5,240.73 $17,642.66
502 Sewer Extension $250,300.00 $4,385.62 $15,455.80
601 Water Fund $1,023,760.00 $42,597.41 $5,042,657.21
602 Sewer Fund $531,475.00 $58,671.20 $136,916.19
603 Refuse Collection $303,150.00 $23,322.74 $73,298.54
651 Storm Water Utility $109,875.00 $8,764.18 $23,474.84
$7,048,890.00 $260,854.39 $5,680,851.93
r CITY OF ST JOSEPH
`il A Council Month End Revenue - General Fund
Current Period: May 2012
2012 May 2012
FUND FUND Descr SOURCE Descr YTD Budget 2012 Amt YTD Amt
FUND 101 General
101 General Current Ad Valorem Taxes $1,092,685.00 $0.00 $0.00
101 General Special Levy- City St. Joe $0.00 $0.00 $0.00
101 General State Sales Tax $0.00 $45.74 $74.35
101 General Gas Franchise $32,500.00 $7,897.53 $7,897.53
101 General Electric Franchise $50,000.00 $9,424.61 $12,769.50
101 General Beer $450.00 - $75.00 $0.00
101 General Liquor $19,760.00 $11,510.00 $12,709.99
101 General Outdoor Liquor Permit $2,500.00 $0.00 $1,500.00
101 General Gambling Permits $100.00 $0.00 $120.00
101 General Amusement/Hunting Permit $840.00 $0.00 $0.00
101 General Excavation Permit $200.00 $4.84 $150.00
101 General Cigarette License $525.00 $0.00 $0.00
101 General Cable Franchise Fee $27,000.00 $0.00 $9,678.07
101 General Building Permits $40,000.00 $3,678.23 $15,426.06
101 General Animal License $3,150.00 $250.00 $2,680.00
101 General Rental Housing Registration $19,000.00 $0.00 $75.00
101 General Federal Grants - Other $5,000.00 $0.00 $0.00
101 General State Grants and Aids $965.00 $0.00 $915.00
101 General Local Govemment Aid $645,150.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 $50,000.00 $0.00 $0.00
101 General Other Grants /Aids $0.00 $0.00 $249.90
101 General Other Governmental Unit $10,000.00 -$100.00 $5,000.00
101 General County Grants - Road Maint. $7,750.00 $0.00 $0.00
101 General Zoning and Subdivision Fee $1,000.00 $400.00 $400.00
101 General Land Use Deposit Fee $4,000.00 $0.00 $4,000.00
101 General Sale of Maps and Publications $75.00 $7.50 $14.65
101 General Assessments Search $2,500.00 $270.00 $1,320.00
101 General Special Hearing $4,500.00 $0.00 $2,415.00
101 General Administration Reimb $11,350.00 $0.00 $4,985.93
101 General Weed Cutting $1,000.00 $0.00 $0.00
101 General Park Fees $4,750.00 $950.00 $4,330.00
101 General Winter Recreation Donation $0.00 $0.00 $0.00
101 General Kennel Fees $500.00 $84.00 $151.00
101 General County Fines $30,000.00 $2,279.64 $7,741.41
101 General Policy Fines $35,000.00 $6,410.00 $21,090.00
101 General Accident Report Fee $1,000.00 $95.75 $427.00
101 General Seized Property $500.00 $0.00 $3,565.00
101 General Special Assessments $2,000.00 $0.00 $149.53
101 General Interest Earnings $13,000.00 $2,104.83 $8,963.37
,,,11 111) k".. ' � � A ` CI u OF ST JOSEPH _
Council Month End Revenue -General Fund
Current Period: May 2012
2012 May 2012
FUND FUND Descr SOURCE Descr YTD Budget 2012 Amt YTD Amt
101 General Interest Charges $100.00 $0.00 - $44.97
101 General Co -op Dividend - LMCIT $6,000.00 $0.00 $9,178.48
101 General Water Tower Antenna Lease $3,325.00 $135.17 $1,259.09
101 General Land Rental $0.00 $0.00 $0.00
101 General Advertising $7,000.00 $200.00 $600.00
101 General Contributions - General $1,500,00 $0.00 $0.00
101 General Contribution - Health Ins Div $10,485.00 $0.00 $0.00
101 General Contributions - Hdiday Lights $1,000.00 $0.00 $0.00
101 General Contributions - Parks $800.00 $12,611.42 $13,609.52
101 General Surplus Property $0.00 $1,500.00 $1,500.00
101 General Reimbursement $23,100.00 $488.17 $2,314.94
101 General Street Access Fee $0.00 $0.00 $0.00
101 General Transfers from Other Funds $0.00 $0.00 $0.00
FUND 101 General $2,183,300.00 $60,172.43
$160,305.35
FUND 108 Cable Access Fee
108 Cable Access Fee Cable Franchise Fee $0.00 $1,611.19 $2,949.86
FUND 108 Cable Access Fee $0.00 $1,611.19
$2,949.86
FUND 150 Economic Development
150 Economic Development Current Ad Valorem Taxes $70,500.00 $0.00 $0.00
150 Economic Development TIF /MIF Deposit $0.00 $0.00 $0.00
150 Economic Development DEED Housing Reimbursement $0.00 $0.00 $0.00
150 Economic Development Interest Earnings $225.00 $95.96 $408.60
150 Economic Development Transfers from Other Funds $0.00 $0.00 $0.00
FUND 150 Economic Development $70,725.00 $95.96 $408.60
$2,254,025.00 $61,879.58 $163,663.81
,,,olI � CITY OF ST JOSEPH
Council Month End Revenue - Enterprise Funds
Current Period: May 2012
FUND 2012 May 2012
FUND Descr SOURCE Descr YTD Budget 2012 Amt YTD Amt
FUND 601 Water Fund
601 Water Fund Penalties and Forfeited Disc $6,500.00 $729.82 $2,797.86
601 Water Fund Bond Premium Proceeds $0.00 $0.00 $53,112.65
601 Water Fund General Oblig. Bond Proceeds $0.00 $0.00 $4,860,000.00
601 Water Fund Transfers from Other Funds $381,000.00 $0.00 $0.00
601 Water Fund Contributed Revenue $0.00 $0.00 $0.00
601 Water Fund MDS Test Fee $11,000.00 $848.25 $2,376.58
601 Water Fund Water Line Charge $151,000.00 $12,230.08
;33,649.13
601 Water Fund State Sales Tax $300.00 $68.37 - $159.42
601 Water Fund Water Meter $5,000.00 $350.00 $2,160.00
601 Water Fund Connection /Reconnection fees $300.00 $0.00 $0.00
601 Water Fund Undesignated Funds $250.00 - $427.46 $944.44
601 Water Fund Bulk Water $1,500.00 $85.00 $140.00
601 Water Fund Rate Class One $405,500.00 $23,894.65 $66,165.63
601 Water Fund Reimbursement $0.00 $0.00 $0.00
601 Water Fund Surplus Property $0.00 $0.00 $15.00
601 Water Fund Water Tower Antenna Lease $30,310.00 $1,216.57 $11,332.01
601 Water Fund Amortization of Bond Premium $0.00 $0.00 $0.00
601 Water Fund Interest Earnings $30,000.00 $3,602.13 $21,089.03
601 Water Fund Special Assessments $1,100.00 $0.00 - $10,965.70
601 Water Fund Inspection Fees $0.00 $0.00 $0.00
FUND 601 Water Fund $1,023,760.00 $42,597.41 $5,042,657.21
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 - $438.05
602 Sewer Fund Interest Earnings $8,500.00 $1,099.72 $5,096.58
602 Sewer Fund Amortization of Bond Premium $0.00 $0.00 $0.00
602 Sewer Fund Sanitary Sewer Service $342,600.00 $40,144.69 $89,403.88
602 Sewer Fund St. Benedict Sewer Charges $0.00 $0.00 -$0.01
602 Sewer Fund St. Benedict s SCAWAC fees $0.00 $0.00 $0.01
602 Sewer Fund Penalties and Forfeited Disc $4,740.00 $590.17 $2,071.02
602 Sewer Fund Sewer Line Charge $171,135.00 $16,836.62 $40,782.76
602 Sewer Fund Sewer Inspection Fee $0.00 $0.00 $0.00
602 Sewer Fund Transfers from Other Funds $0.00 $0.00 $0.00
602 Sewer Fund General Oblig. Bond Proceeds $0.00 $0.00 $0.00
602 Sewer Fund Bond Premium Proceeds $0.00 $0.00 $0.00
602 Sewer Fund Reimbursement $4,000.00 $0.00 $0.00
602 Sewer Fund Surplus Property $0.00 $0.00 $0.00
FUND 602 Sewer Fund $531,475.00 $58,671.20 $136,916.19
FUND 603 Refuse Collection
603 Refuse Collect Licenses & Permits $17,600.00 $2,130.00 $13,280.00
603 Refuse Collect Contributions - General $250.00 $0.00 $945.00
603 Refuse Collect Interest Earnings $3,500.00 $609.01 $2,186.52
603 Refuse Collect Special Assessments $500.00 $0.00 - $862.32
603 Refuse Collect Refuse Collection Charges $275,800.00 $20,514.47 $58,574.56
603 Refuse Collect State Sales Tax $0.00 - $492.23 - $3,413.87
603 Refuse Collect Penalties and Forfeifted Disc $5,500.00 $561.49 $2,588.65
FUND 603 Refuse Collection $303,150.00 $23,322.74 $73,298.54
FUND 651 Storm Water Utility
651 Storm Water Transfers from Other Funds $0.00 $0.00 $0.00
,fl CITY OF ST JOSEPH
,++`i ' Council Month End Revenue - Enterprise Funds
Current Period: May 2012
FUND 2012 May 2012
FUND Descr SOURCE Descr YTD Budget 2012 Amt YTD Amt
651 Storm Water Special Assessments $200.00 $0.00 - $715.21
651 Storm Water Interest Earnings $5,200.00 $433.09 $1,579.72
651 Storm Water Reimbursement $0.00 $0.00 $0.00
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 $98,750.00 $8,141.17 $21,890.91
651 Storm Water Penalties and Forfeifted. Disc $1,725.00 $189.92 $719.42
FUND 651 Storm Water Utility $109,875.00 $8,764.18 $23,474.84
$1,968,260.00 $133,355.53 $5,276,346.78
r CITY OF ST JOSEPH
'd 1A' Council Month End Expenditure - Summary
Current Period: May 2012
2012 2012
Description YTD Budget May 2012 Amt YTD Amt
General $2,183,300.00 $196,027.68 $827,007.31
Fire Fund $284,445.00 $5,317.23
$60,699.61
Cable Access Fee $0.00 $0.00 $0.00
Economic Development $70,725.00 $2,577.06 $12,016.29
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 $6,189.55 $19,868.60
Park Dedication $43,400.00 $121.04 $214.06
Recreation Center $0.00 $27.40 $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 $26,893.75 $26,893.75
2007 Refunding (98/99 St Bond $166,345.00 $8,172.50 $8,172.50
City Hall Refunded, 2005 $98,645.00 $7,246.25 $7,246.25
2011A Refunding Fire Hall $79,885.00 $0.00 $3,583.33
2005 Improve (Hill/Clover) $150,195.00 $22,597.50 $22,597.50
2006 Interior St Improvements $216,770.00 $35,884.38 $35,884.38
2007 St Imprv-E Side /Jade/8 A $534,070.00 $17,034.38 $17,034.38
2008 Equipment Certificates $64,200.00 $2,100.00 $2,100.00
20096 GO CIP Bonds $66,185.00 $6,017.50 $6,017.50
2010 Equipment Certificates $33,300.00 $1,650.00 $1,650.00
'2010B Street Impr (16th Ave) $63,455.00 $9,227.50 - $1,385.19
2011A Pumper Truck Certificate $44,960.00 $0.00 $3,358.33
2011A GO OP Bonds $18,685.00 $0.00 $1,675.00
Debt Service Relief $0.00 $0.00 $0.00
Northland Heights/Trans Corrid $0.00 $3,298.55 $15,281.91
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 OP Bonds $0.00 $0.00 $0.00
Capital Outlay $168,250.00 $17,130.39 $18,330.93
Water Extension $0.00 $0.00 $0.00
Sewer Extension $0.00 $0.00 $0.00
Water Fund $1,488,195.00 $169,268.60
$271,123.52
Sewer Fund $1,223,735.00 $73,650.56
$192,292.56
Refuse Collection $316,875.00 $25,660.69 $91,691.10
Storm Water Utility $239,175.00 $8,950.69 $19,517.13
$7,918,585.00 $645,043.20 $1,663,108.88
CITY OF ST JOSEPH
��r1 , , Council Month End Expenditure - General Fund
Current Period: May 2012
2012 May 2012
Description DEPART Descr YTD Budget 2012 Amt YTD Amt
FUND 101 General
General Council $42,040.00 $2,098.34 $12,448.11
General Legislative Committees $10,065.00 $4,310.63 $5,255.63
General Ordinance & Proceedings $2,700.00 $115.95 $285.45
General Mayor $10,595.00 $826.85 $3,441.35
General Elections $3,000.00 $0.00 $0.00
General General Adminstration $186,655.00 $17,732.95 $73,085.40
General Finance $112,030.00 $11,478.19 $42,514.47
General Audit Service $25,000.00 $3,000.00 $25,000.00
General Assessing $19,500.00 $0.00 $0.00
General City Attorney $18,000.00 $1,225.50 $3,189.25
General Planning and Zoning $2,300.00 $47.25 $600.46
General General Govemment $22,455.00 $1,116.69 $11,985.86
General City Offices $28,065.00 $3,735.47 $19,286.18
General Facilites and Planning $0.00 $0.00 $0.00
General Cable Access $11,320.00 $830.60 $3,722.40
General Crime Control & Investigation $804,215.00 $75,647.73 $296,720.19
General Police Training $7,000.00 $175.00 $1,962.31
General Communication Service $12,015.00 $801.95 $4,008.80
General Automotive Services $64,870.00 $4,496.49 $17,250.57
General Building Inspec. Admistration $90,000.00 $7,521.46 $30,462.26
General Emergency Management $3,300.00 $7.36 $134.26
General Signal Lights CSAH 75 $2,000.00 $139.31 $631.45
General Animal Control $1,150.00 $51.94 $459.56
General Ordinance /Easement Enforcement $0.00 $0.00 $0.00
General Street Maintanence $177,435.00 $12,522.37 $81,495.11
General Ice & Snow Removal $95,445.00 $0.00 $33,838.88
General Engineering Fee $35,000.00 $5,683.99 $16,336.44
General Street Lighting $46,000.00 $7,173.13 $19,240.31
General Street Cleaning $17,255.00 $2,554.40 $7,953.23
General Skate Park and Ice Rink $3,745.00 $42.47 $237.22
General Maintenance Shop $21,490.00 $2,390.92 $8,581.31
General Park Areas $211,015.00 $30,300.74 $85,572.29
General Community Support $12,515.00 $0.00 $0.00
General Other Financing Uses $0.00 $0.00 $0.00
General Fire Protection $85,125.00 $0.00
$21,308.56
FUND 101 General $2,183,300.00 $196,027.68 $827,007.31
FUND 108 Cable Access Fee
Cable Access Fee Cable Access $0.00 $0.00 $0.00
FUND 108 Cable Access Fee $0.00 $0.00 $0.00
FUND 150 Economic Development
Economic Development Economic Development Authority $70,725.00 $2,577.06 $12,016.29
/ CITY OF ST JOSEPH
Council Month End Expenditure - General Fund
Current Period: May 2012
2012 May 2012
Description DEPART Descr YTD Budget 2012 Amt YTD Amt
FUND 150 Economic Development $70,725.00 $2,577.06 $12,016.29
FUND 490 Capital Outlay
Capital Outlay Elections $0.00 $0.00
$0.00
Capital Outlay General Adminstration $0.00 $0.00 $92.34
Capital Outlay General Govemment $35,000.00 $0.00 $0.00
Capital Outlay City Offices $35,000.00 $0.00 $0.00
Capital Outlay Cable Access $0.00 $0.00 $0.00
Capital Outlay Crime Control & Investigation $0.00 $0.00 - $37.00
Capital Outlay Communication Service $0.00 $0.00 $0.00
Capital Outlay Automotive Services $0.00 $0.00 $0.00
Capital Outlay Emergency Management $0.00 $0.00 $1,133.75
Capital Outlay Street Maintanence $31,200.00 $0.00 $11.45
Capital Outlay Ice & Snow Removal $8,750.00 $0.00 $0.00
Capital Outlay Street Lighting $5,000.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 Maintenance Shop $12,500.00 $1,969.54 $1,969.54
Capital Outlay Park Areas $40,800.00 $15,160.85 $15,160.85
Capital Outlay Other Financing Uses $0.00 $0.00 $0.00
FUND 490 Capital Outlay $168,250.00 $17,130.39 $18,330.93
$2,422,275.00 $215,735.13 $857,354.53
( CITY OF ST JOSEPH
, fil l 1 A r - Council Month End Expense - Enterprise Funds
Current Period: May 2012
2012 May 2012
Description DEPART Descr YTD Budget 2012 Amt YTD Amt
FUND 601 Water Fund
Water Fund Bond Payment (P & I) $665,730.00 $133,715.63 $174,645.63
Water Fund Other Financing Uses $50,000.00 $0.00 $0.00
Water Fund Power and Pumping $34,350.00 $448.64 $1,776.62
Water Fund Purification -Plant 1 $28,960.00 $2,314.44 $7,035.44
Water Fund Purification -Plant 2 $80,155.00 $7,802.68 $30,942.03
Water Fund Distribution $22,000.00 $3,022.00 $21,329.36
Water Fund Wellhead Protection $2,000.00 $0.00 $97.56
Water Fund Storage -Tower 1 $5,500.00 $612.06 $1,622.22
Water Fund Storage -Tower 2 $0.00 $0.00 $0.00
Water Fund Water Maintenance $200,355.00 $17,807.23 $28,876.46
Water Fund Administration and General $37,295.00 $3,545.92 $4,798.20
Water Fund Depreciation Expense $360,000.00 $0.00 $0.00
FUND 601 Water Fund $1,486,345.00 $169,268.60 $271,123.52
FUND 602 Sewer Fund
Sewer Fund Bond Payment (P & I) $71,695.00 $6,215.00 - $37,971.50
Sewer Fund Other Financing Uses $55,000.00 $0.00 $0.00
Sewer Fund Sanitary Sewer Maintenanc $203,515.00 $11,324.17 $10,476.61
Sewer Fund Lift Station -Baker Street $3,095.00 $233.18 $8,557.59
Sewer Fund Lift Station -DBL Labs Area $2,720.00 $831.61 $1,425.92
Sewer Fund Lift Station - Northland $2,575.00 $107.20 $3,180.39
Sewer Fund Uft Station -CR 121 $2,725.00 $140.42 $761.27
Sewer Fund Uft Station -Main $623,050.00 $51,418.33 $199,822.62
Sewer Fund Administration and General $43,800.00 $3,380.65 $6,039.66
Sewer Fund Depreciation Expense $215,000.00 $0.00 $0.00
FUND 602 Sewer Fund $1,223,175.00 $73,650.56 $192,292.56
FUND 603 Refuse Collection
Refuse Collectio Waste Collection $316,875.00 $25,660.69 $91,691.10
Refuse Collectio Other Rnancing Uses $0.00 $0.00 $0.00
FUND 603 Refuse Collection $316,875.00 $25,660.69 $91,691.10
FUND 651 Storm Water Utility
Storm Water Uti Other Financing Uses $57,325.00 $0.00 $0.00
Storm Water Uti Administration and General $13,875.00 $1,249.03 $3,248.59
Storm Water Uti Storm Water Maintenance $72,975.00 $7,701.66 $16,268.54
Storm Water Uti Depreciation Expense $95,000.00 $0.00 $0.00
FUND 651 Storm Water Utility $239,175.00 $8,950.69 $19,517.13
$3,265,570.00 $277,530.54 $574,624.31