Loading...
HomeMy WebLinkAbout[04d] Treasurer's Report11,�� crry OF ST. d()SW PH MEETING DATE: AGENDA ITEM: SUBMITTED BY: Finance Council Agenda Item 4 d June 17, 2010 Treasurer's Report — Requested Action: Accept the May 2010 Treasurer's Report BOARD /COMMISSION /COMMITTEE RECOMMENDATION: N/A PREVIOUS COUNCIL ACTION: None BACKGROUND INFORMATION: For 2010 the monthly Treasurer's Reports will be submitted via the consent agenda. The quarterly Financial Reports will be listed as a separate Council agenda item under the department head reports. This has been the practice for the past couple years. May 2010 reconciled cash /investment and budget to actual position for Council review. The 2009 accruals were reversed out. In some cases the receipts have not been received nor bills paid. This creates a negative balance in some accounts in the revenues or expenditures. Some of the negative balances are the result of a difference between the estimate of the audit accrual and the actual receipt /expenditure. The cash and investment balance at the end of May decreased by approximately $784,000 as compared to the beginning of the year. The City issued $150,000 equipment certificates in April. Of the proceeds $82,000 has been spent. A decrease in cash is expected at this time of the year as we wait for the June /July tax settlements and first half state aid payments. The General fund spent 36% of the expenditure budget and received 4% of the revenue budget. This trend is reflective of previous years. The other expenditures are reflective of the normal day -to -day operations of the City for the first five months of the year. The Enterprise funds spent 37% (without depreciation and debt principal payments) and received 12% of the budget. The revenue includes utility billing receipts for the January/February and approximately half of the March /April usage. The expenses reflect the normal day -to -day operational expenses for the first five months of the year. The expenses will fluctuate during the year depending on temperatures and water usage. The chemicals for water and sewer treatment typically increase over the summer months. BUDGET /FISCAL IMPACT: None — Information Only 4(d):1 ATTACHMENTS: Request for Council Action Cash & Investment Report Month End Revenue Summary Month End Revenue —General Fund Month End Revenue — Enterprise Funds Month End Expenditure Summary Month End Expenditure — General Fund Month End Expenditure — Enterprise Funds REQUESTED COUNCIL ACTION: Accept the Treasurer's Report as presented. 4(d):1 -2 4(d):3 4(d):4 4(d):5 -6 4(d):7 -8 4(d):9 4(d):10 -11 4(d):12 4(d):2 r' CITY OF ST JOSEPH Cash and Investment- Council Report Current Period: May 2010 4(d):3 Current FUND FUND Descr Begin Yr YTD Debit YTD Credit Balance 101 General $1,085,164.43 $453,252.43 $1,264,771.04 $273,645.82 105 Fire Fund $549,441.65 $111,198.95 $48,175.80 $612,464.80 108 Cable Access Fee $26,310.56 $4,877.36 $0.00 $31,187.92 150 Economic Development $7,069.59 $21,066.33 $23,964.56 $4,171.36 156 TIF 1-4 St. Joe Development $34,057.31 $322.57 $24.72 $34,355.16 157 TIF 2 -1 Millstream $463.40 $1.20 $0.34 $464.26 200 State Collected Sales Tax $909,582.10 $94,537.56 $33,571.54 $970,548.12 205 Park Dedication $45,499.59 $1,434.73 $10,804.75 $36,129.57 210 Recreation Center $50,071.72 $481.55 $36.35 $50,516.92 215 Charitable Gambling $5,620.43 $50.06 $753.90 $4,916.59 232 City Beautification - College Av $59.11 $500.00 $0.00 $559.11 250 Revolving Loan Fund $30,457.19 $2,309.17 $986.36 $31,780.00 318 2009A CrossoverRefunding Bonds $578,355.70 $15,660.90 $40,060.50 $553,956.10 320 2007 Refunding (98/99 St Bond) $345,643.30 $140,826.27 $82,668.85 $403,800.72 322 City Hall Refunded, 2005 $508.68 $4,480.04 $12,221.41 - $7,232.69 331 2003 Refunding Fire Hall $136,404.33 $20,827.43 $11,391.34 $145,840.42 332 2003 Cross Over (93 Streets) $104,404.79 $1,943.43 $2,631.63 $103,716.59 333 2005 Improve (Hill/Clover) $551,248.96 $7,778.54 $27,782.95 $531,244.55 335 Northland Heights/Trans Corrid $943,001.14 $31,901.39 $25,138.61 $949,763.92 337 2006 Equipment Certificate $7,887.43 $2,879.94 $2,708.17 $8,059.20 338 2006 Interior St Improvements $777,579.18 $47,059.64 $61,738.75 $762,900.07 341 2007 St Imprv-E Side /Jade/8 Av $486,637.14 $16,212.43 $42,150.31 $460,699.26 342 2008 Equipment Certificates $8,176.79 $2,488.60 $5,344.83 $5,320.56 343 2009B GO CIP Bonds $6,306.29 $2,871.28 $11,208.47 - $2,030.90 344 2010 Equipment Certificates $0.00 $5,203.68 $0.00 $5,203.68 390 Debt Service Relief $136,294.41 $2,466.69 $987.10 $137,774.00 435 Northland Heights/Trans Corrid $344,077.06 $0.00 $43,807.48 $300,269.58 441 2007 Street Impr (Jade Rd/E $413,047.88 $5,455.94 $5,513.94 $412,989.88 444 2010 Equip Certificates $0.00 $225,244.33 $162,172.40 $63,071.93 490 Capital Outlay $192,459.23 $40,947.00 $56,711.37 $176,694.86 501 Water Extension $391,424.39 $24,766.68 $287.21 $415,903.86 502 Sewer Extension $676,497.92 $18,047.95 $492.84 $694,053.03 601 Water Fund $568,938.65 $186,421.68 $349,959.09 $405,401.24 602 Sewer Fund $592,581.49 $315,502.92 $293,904.61 $614,179.80 603 Refuse Collection $263,500.09 $139,331.57 $133,520.76 $269,310.90 651 Storm Water Utility $273,151.41 $47,073.26 $23,820.67 $296,404.00 $10,541,923.34 $1,995,423.50 $2,779,312.65 $9,758,034.19 4(d):3 VA CITY OF ST JOSEPH Council Month End Revenue Summary Current Period: May 2010 4(d):4 2010 May 2010 FUND FUND Descr YTD Budget 2010 Amt YTD Amt 101 General $2,406,075.00 $48,447.38 $92,291.90 105 Fire Fund $270,850.00 $1,760.89 $101,461.19 108 Cable Access Fee $0.00 $1,484.40 $2,920.80 150 Economic Development $42,510.00 $16.22 $20,886.85 156 TIF 1-4 St. Joe Development $0.00 $50.35 $25.73 157 TIF 2 -1 Millstream $0.00 $0.67 -$7.49 200 State Collected Sales Tax $0.00 $25,765.76 $40,786.57 205 Park Dedication $0.00 $1,064.79 $5.47 210 Recreation Center $0.00 $74.03 $83.29 215 Charitable Gambling $0.00 $7.57 $21.18 232 City Beautification - College Av $0.00 $0.00 $0.00 250 Revolving Loan Fund $0.00 $375.61 $1,621.28 318 2009A CrossoverRefunding Bonds $69,000.00 $856.32 $522.85 320 2007 Refunding (98/99 St Bond) $8,500.00 $611.69 $437.45 322 City Hall Refunded, 2005 $105,000.00 $3.86 - $21.69 331 2003 Refunding Fire Hall $71,200.00 $222.91 $18,182.63 332 2003 Cross Over (93 Streets) $10,000.00 $154.88 $21.39 333 2005 Improve (Hill/Clover) $16,000.00 $816.63 $545.34 335 Northland Heights/Trans Corrid $0.00 $1,879.98 $1,001.06 337 2006 Equipment Certificate $69,000.00 $13.53 - $57.17 338 2006 Interior St Improvements $61,000.00 $1,178.51 $1,116.92 341 2007 St Impry -E Side/Jade/8 Av $38,000.00 $1,329.87 $912.24 342 2008 Equipment Certificates $66,000.00 $13.66 - $142.67 343 2009B GO CIP Bonds $61,000.00 $11.29 $125.11 344 2010 Equipment Certificates $0.00 $47.43 $5,203.68 390 Debt Service Relief $0.00 $201.91 - $233.58 444 2010 Equip Certificates $0.00 $0.00 $145,084.38 490 Capital Outlay $0.00 $0.00 $14,647.00 501 Water Extension $0.00 $4,793.09 $20,884.79 502 Sewer Extension $0.00 $3,308.11 $12,792.62 601 Water Fund $1,066,910.00 $41,297.47 $102,475.07 602 Sewer Fund $653,980.00 $29,283.45 $76,571.99 603 Refuse Collection $309,675.00 $22,748.56 $66,219.46 651 Storm Water Utility $168,605.00 $8,824.60 $21,894.92 $5,493,305.00 $196,645.42 $748,280.56 4(d):4 rl CITY OF ST JOSEPH Council Month End Revenue - General Fund Current Period: May 2010 4(d):5 2010 May 2010 FUND FUND Descr SOURCE Descr YTD Budget 2010 Amt YTD Amt FUND 101 General 101 General Current Ad Valorem Taxes $1,232,779.00 $0.00 $0.00 101 General Special Levy- City St. Joe $44,856.00 $0.00 $0.00 101 General State Sales Tax $125.00 - $27.67 $55.24 101 General Gas Franchise $32,000.00 $8,043.61 $8,043.61 101 General Electric Franchise $45,500.00 $9,192.78 $13,595.70 101 General Beer $2,000.00 $0.00 $0.00 101 General Liquor $22,200.00 $2,700.00 $2,700.00 101 General Outdoor Liquor Permit $2,000.00 $0.00 $2,750.00 101 General Gambling Permits $200.00 $0.00 $25.00 101 General AmusemenUHunting Permit $1,500.00 $0.00 $0.00 101 General Contractors License $100.00 $0.00 $0.00 101 General Excavation Permit $450.00 $0.00 $0.00 101 General Cigarette License $500.00 $0.00 $0.00 101 General Cable Franchise Fee $24,000.00 $6,421.37 $6,421.37 101 General Building Permits $102,500.00 $3,438.63 $15,297.93 101 General Animal License $3,000.00 $95.00 $2,635.00 101 General Rental Housing Registration $17,000.00 $694.00 $844.00 101 General Federal Grants - Other $3,000.00 $0.00 $0.00 101 General Local Government Aid $645,150.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 $40,000.00 $0.00 $0.00 101 General Other Grants /Aids $0.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 $600.00 101 General Land Use Deposit Fee $4,000.00 $5,000.00 $5,000.00 101 General Sale of Maps and Publications $100.00 $4.25 $21.00 101 General Assessments Search $4,000.00 $100.00 $550.00 101 General Special Hearing $4,000.00 $400.00 $3,100.00 101 General Administration Reimb $13,800.00 $0.00 $0.00 101 General Weed Cutting $1,000.00 $0.00 - $1,503.27 101 General Park Fees $4,500.00 $750.00 $4,375.00 101 General Winter Recreation Donation $0.00 $0.00 $0.00 101 General Kennel Fees $500.00 $0.00 $155.00 101 General County Fines $42,000.00 $1,747.05 $7,411.99 101 General Policy Fines $35,000.00 $6,175.00 $22,041.00 101 General Accident Report Fee $1,000.00 $30.25 $417.50 101 General Seized Property $1,500.00 $0.00 $0.00 101 General Special Assessments $1,500.00 $0.00 $0.00 101 General Interest Earnings $20,000.00 $1,090.49 $2,337.93 101 General Interest Charges $150.00 $78.96 $78.96 101 General . Co -op Dividend -MN League of C $8,000.00 $0.00 $0.00 101 General Water Tower Antenna Lease $2,775.00 $273.22 $1,366.10 101 General Land Rental $2,400.00 $0.00 $0.00 101 General Contributions from Private Sou $0.00 $0.00 $0.00 101 General Contribution - Health Ins Div $0.00 $0.00 - $15,000.00 101 General Contributions -Pvte Christmas $2,000.00 $1,000.00 $1,000.00 101 General Contributions - Parks $600.00 $80.44 $116.39 101 General Surplus Property $250.00 $1,100.00 $1,100.00 101 General Reimbursement $3,900.00 $60.00 $3,666.45 101 General Transfers from Other Funds $14,000.00 $0.00 $0.00 FUND 101 General $2,406,075.00 $48,447.38 $92,291.90 FUND 108 Cable Access Fee 108 Cable Access Fee Cable Franchise Fee $0.00 $1,484.40 $2,920.80 4(d):5 rl CITY OF ST JOSEPH Council Month End Revenue - General Fund Current Period: May 2010 FUND FUND Descr SOURCE Descr FUND 150 Economic Development 150 Economic Development TIF /MIF Deposit 150 Economic Development Interest Earnings 150 Economic Development Transfers from Other Funds FUND 150 Economic Development 2010 May 2010 YTD Budget 2010 Amt YTD Amt $0.00 $0.00 $0.00 $500.00 $16.22 - $118.15 $42,010.00 $0.00 $21,005.00 $42,510.00 $16.22 $20,886.85 $2,448,585.00 $49,948.00 $116,099.55 4(d):6 r' CITY OF ST JOSEPH Council Month End Revenue - Enterprise Funds Current Period: May 2010 4(d):7 FUND 2010 May 2010 FUND Descr SOURCE Descr YTD Budget 2010 Amt YTD Amt FUND 601 Water Fund 601 Water Fund Penalties and Forfeited Disc $6,670.00 $935.29 $3,291.96 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 $481,500.00 $0.00 $0.00 601 Water Fund Contributed Revenue $0.00 $0.00 $0.00 601 Water Fund Wellhead Protection Fee $4,905.00 $0.00 $0.00 601 Water Fund MDS Test Fee $10,975.00 $825.43 $2,283.28 601 Water Fund Water Line Charge $131,285.00 $9,103.25 $25,773.56 601 Water Fund State Sales Tax $425.00 - $48.68 - $181.71 601 Water Fund Water Meter $4,000.00 $3,715.00 $5,115.00 601 Water Fund Connection/Reconnection fees $250.00 $0.00 $45.00 601 Water Fund Undesignated Funds $500.00 - $272.51 - $2,454.29 601 Water Fund Bulk Water $3,500.00 $0.00 $90.00 601 Water Fund Rate Class One $356,500.00 $23,744.26 $56,176.83 601 Water Fund Reimbursement $0.00 $0.00 $60.40 601 Water Fund Surplus Property $0.00 $0.00 $0.00 601 Water Fund Water Tower Antenna Lease $29,000.00 $2,459.02 $12,295.10 601 Water Fund Amortization of Bond Premium $0.00 $0.00 $0.00 601 Water Fund Interest Earnings $35,850.00 $836.41 $1,131.70 601 Water Fund Special Assessments $1,550.00 $0.00 - $1,151.76 601 Water Fund Inspection Fees $0.00 $0.00 $0.00 FUND 601 Water Fund $1,066,910.00 $41,297.47 $102,475.07 FUND 602 Sewer Fund 602 Sewer Fund Contributed Revenue $0.00 $0.00 $0.00 602 Sewer Fund Special Assessments $500.00 $0.00 - $524.29 602 Sewer Fund Interest Earnings $33,315.00 $853.37 $1,177.88 602 Sewer Fund Amortization of Bond Premium $0.00 $0.00 $0.00 602 Sewer Fund Sanitary Sewer Service $247,335.00 $17,685.90 $46,053.57 602 Sewer Fund St. Benedict Sewer Charges $168,000.00 $0.00 - $1,285.62 602 Sewer Fund St. Benedict's SCAWAC fees $61,670.00 $0.00 $0.00 602 Sewer Fund Penalties and Forfeited Disc $4,375.00 $582.63 $2,204.44 602 Sewer Fund Sewer Line Charge $138,785.00 $10,161.55 $28,946.01 602 Sewer Fund Sewer Inspection Fee $0.00 $0.00 $0.00 602 Sewer Fund Sewer Surcharge - (Monthly) $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 Reimbursement $0.00 $0.00 $0.00 602 Sewer Fund Surplus Property $0.00 $0.00 $0.00 FUND 602 Sewer Fund $653,980.00 $29,283.45 $76,571.99 FUND 603 Refuse Collection 603 Refuse Collect Licenses & Permits $11,125.00 $1,630.00 $9,255.00 603 Refuse Collect Contributions from Private Sou $0.00 $0.00 $250.00 603 Refuse Collect Interest Earnings $11,710.00 $390.47 $323.24 603 Refuse Collect Special Assessments $2,765.00 $0.00 - $403.30 603 Refuse Collect Refuse Collection Charges $278,450.00 $20,552.18 $57,172.12 603 Refuse Collect State Sales Tax $0.00 - $585.90 - $3,368.57 603 Refuse Collect Penalties and Forfeifted Disc $5,625.00 $761.81 $2,990.97 FUND 603 Refuse Collection $309,675.00 $22,748.56 $66,219.46 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 - $618.97 651 Storm Water Interest Earnings $14,205.00 $422.99 $1,099.25 651 Storm Water Reimbursement $0.00 $0.00 $0.00 4(d):7 i CITY OF ST JOSEPH Council Month End Revenue - Enterprise Funds Current Period: May 2010 4(d):8 FUND 2010 May 2010 FUND Descr SOURCE Descr YTD Budget 2010 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 $8,111.54 $20,566.86 651 Storm Water Penalties and Forfeifted Disc $1,725.00 $290.07 $847.78 FUND 651 Storm Water Utility $168,605.00 $8,824.60 $21,894.92 $2,199,170.00 $102,154.08 $267,161.44 4(d):8 ri CITY OF ST JOSEPH Council Month End Expenditure Summary Current Period: May 2010 4(d):9 May MTH 2010 FUND Description 2010 Amt Bud 1 CurYr YTD Amt 101 General $144,142.72 $2,235,055.00 $863,766.53 105 Fire Fund $7,611.85 $103,500.00 $38,848.44 150 Economic Development $3,995.10 $58,200.00 $20,342.80 200 State Collected Sales Tax $2,248.99 $0.00 $32,881.22 205 Park Dedication $6,083.80 $22,400.00 $10,696.66 318 2009A CrossoverRefunding B $31,062.50 $0.00 $31,183.68 320 2007 Refunding (98199 St Bon $13,573.75 $0.00 $13,694.93 322 City Hall Refunded, 2005 $9,865.00 $0.00 $9,986.18 331 2003 Refunding Fire Hall $10,428.75 $0.00 $10,549.93 332 2003 Cross Over (93 Streets) $1,968.75 $0.00 $2,089.93 333 2005 Improve (Hill/Clover) $26,012.50 $0.00 $26,133.68 335 Northland Heights/Trans Corri $14,175.00 $0.00 $14,296.18 337 2006 Equipment Certificate $1,170.00 $0.00 $1,291.17 338 2006 Interior St Improvements $41,284.38 $0.00 $41,405.56 341 2007 St Imprv-E Side/Jade18 $37,434.38 $0.00 $37,555.56 342 2008 Equipment Certificates $4,002.50 $0.00 $4,123.67 343 2009B GO CIP Bonds $9,732.50 $0.00 $9,853.67 390 Debt Service Relief $0.00 $0.00 $242.36 435 Northland Heights/Trans Coni $3,601.31 $0.00 $10,734.67 444 2010 Equip Certificates $28,579.85 $0.00 $82,012.45 490 Capital Outlay $3,050.43 $0.00 $30,216.37 601 Water Fund $179,706.92 $1,101,515.00 $304,974.94 602 Sewer Fund $64,019.46 $583,645.00 $256,154.62 603 Refuse Collection $24,836.61 $302,275.00 $99,018.82 651 Storm Water Utility $4,990.02 $45,700.00 $23,102.66 $673,577.07 $4,452,290.00 $1,975,156.68 4(d):9 r' CITY OF ST JOSEPH Council Month End Expenditure - General Fund Current Period: May 2010 FUND 150 Economic Development Economic Development Economic Development Authority 2010 May 2010 Description DEPART Descr YTD Budget 2010 Amt YTD Amt FUND 101 General General Council $48,295.00 $2,840.50 $13,360.49 General Legislative Commities $9,930.00 $358.40 $743.40 General Ordinance & Proceedings $3,000.00 $0.00 $164.02 General Mayor $12,380.00 $840.65 $3,452.54 General Elections $1,000.00 $0.00 $871.89 General Salaries & Adminstrative $220,535.00 $15,064.97 $79,888.36 General Accounting $104,525.00 $8,443.04 $40,334.24 General Audit Service $26,000.00 $0.00 $24,780.00 General Assessing $19,000.00 $0.00 $0.00 General City Attorney $20,000.00 $858.50 $5,487.25 General Planning and Zoning $1,800.00 $85.15 $1,886.75 General General Government $24,405.00 $1,403.77 $13,044.24 General City Offices $26,200.00 $3,809.43 $11,571.25 General Facilites and Planning $0.00 $0.00 $0.00 General Cable Access $14,630.00 $1,593.23 $5,129.33 General Crime Control & Investigation $846,815.00 $58,219.67 $298,636.31 General Police Training $10,000.00 $1,464.00 $2,024.00 General Communication Service $18,700.00 $765.66 $4,801.80 General Automotive Services $72,665.00 $5,839.22 $17,673.13 General Building Inspec. Admistration $102,500.00 $7,550.00 $31,871.79 General Emergency Management $2,950.00 $5.33 $3,146.57 General Signal Lights $800.00 $45.04 $250.62 General Animal Control $1,275.00 $0.00 $939.79 General Ordinance/Easement Enforcement $300.00 $0.00 $0.00 General Street Maintenance $247,645.00 $6,573.49 $70,259.81 General Ice & Snow Removal $73,660.00 $0.00 $48,684.77 General Engineering Fee $37,000.00 $5,098.36 $15,603.09 General Street Lighting $42,500.00 $2,524.34 $13,749.29 General Street Cleaning $25,850.00 $744.92 $7,431.44 General Ball Park and Skating Rink $5,080.00 $29.59 $2,982.46 General Maint Shop $23,750.00 $1,211.53 $8,201.16 General Park Areas $196,565.00 $18,773.93 $69,882.28 General Community Support $6,000.00 $0.00 $0.00 General Other Financing Uses $42,010.00 $0.00 $21,005.00 General Fire Protection $92,670.00 $0.00 $45,909.46 FUND 101 General $2,380,435.00 $144,142.72 $863,766.53 FUND 108 Cable Access Fee Cable Access Fee Cable Access $0.00 $0.00 $0.00 FUND 150 Economic Development Economic Development Economic Development Authority $63,540.00 $3,995.10 $20,342.80 FUND 150 Economic Development $63,540.00 $3,995.10 $20,342.80 FUND 490 Capital Outlay Capital Outlay Elections $0.00 $0.00 $0.00 Capital Outlay Salaries & Adminstrative $0.00 $1,551.45 $1,551.45 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 Capital Outlay Automotive Services $0.00 $1,498.98 $2,364.92 Capital Outlay Emergency Management $0.00 $0.00 $0.00 Capital Outlay Street Maintanence $0.00 $0.00 $0.00 Capital Outlay Ice & Snow Removal $0.00 $0.00 $17,500.00 4(d):10 r' Description Capital Outlay Capital Outlay Capital Outlay Capital Outlay Capital Outlay FUND 490 Capital Outlay CITY OF ST JOSEPH Council Month End Expenditure - General Fund Current Period: May 2010 DEPART Descr Street Lighting Ball Park and Skating Rink Maint Shop Park Areas Other Financing Uses 2010 YTD Budget $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,443,975.00 May 2010 2010 Amt YTD Amt $0.00 $0.00 $0.00 $0.00 $0.00 $8,800.00 $0.00 $0.00 $0.00 $0.00 $3,050.43 $30,216.37 $151,188.25 $914,325.70 4(d):11 11 CITY OF ST JOSEPH Council Month End Expenditure - Enterprise Funds Description DEPART Descr FUND 601 Water Water Fund Water Fund Water Fund Water Fund Water Fund Water Fund Water Fund Water Fund Water Fund Water Fund Water Fund Water Fund Water Fund Fund Bond Payment (P & 1) Other Financing Uses Power and Pumping Purification -Plant 1 Purification -Plant 2 Distribution CIP- Treatment Plant 2 Wellhead Protection Storage -Tower 1 CIP -Meter Installation Water Maintenance Administration and general Depreciation Expense FUND 601 Water Fund FUND 602 Sewer Fund Sewer Fund Bond Payment (P & 1) Sewer Fund Other Financing Uses Sewer Fund Sanitary Sewer Maintenanc Sewer Fund Lift Station -Baker Street Sewer Fund Lift Station -DBL Labs Area Sewer Fund Lift Station - Northland Sewer Fund Lift Station -CR 121 Sewer Fund Lift Station -Main Sewer Fund Administration and general Sewer Fund Depreciation Expense FUND 602 Sewer Fund FUND 603 Refuse Collection Refuse Collectio Waste Collection Refuse Collectio Other Financing Uses FUND 603 Refuse Collection FUND 651 Storm Water Utility Current Period: May 2010 $6,705.00 2010 May 2010 YTD Budget 2010 Amt YTD Amt $761,760.00 $147,415.62 $166,942.13 $45,000.00 $0.00 $0.00 $23,150.00 $1,185.28 $3,023.10 $16,810.00 $3,221.17 $7,238.94 $60,450.00 $6,248.93 $21,867.66 $17,000.00 $2,077.76 $5,677.81 $0.00 $0.00 $0.00 $2,000.00 $0.00 $0.00 $2,850.00 $145.79 $2,619.49 $0.00 $0.00 $0.00 $215,185.00 $15,600.88 $79,443.03 $34,260.00 $3,811.49 $18,162.78 $360,000.00 $0.00 $0.00 $1,538,465.00 $179,706.92 $304,974.94 $0.00 $6,705.00 $4,038.00 $66,000.00 $0.00 $0.00 $317,565.00 $7,104.20 $48,183.02 $3,675.00 $137.60 $860.56 $3,000.00 $133.27 $729.83 $2,875.00 $112.49 $668.47 $5,950.00 $112.49 $773.92 $396,800.00 $45,692.36 $180,298.91 $43,460.00 $4,022.05 $20,601.91 $211,000.00 $0.00 $0.00 $1,050,325.00 $64,019.46 $256,154.62 $302,775.00 $24,836.61 $99,018.82 $6,900.00 $0.00 $0.00 $309,675.00 $24,836.61 $99,018.82 Storm Water Util Other Financing Uses $44,075.00 $0.00 $0.00 Storm Water Util Administration and general $14,430.00 $1,151.59 $8,788.72 Storm Water Util Storm Water Maintenance $105,600.00 $3,838.43 $14,313.94 Storm Water Util Depreciation Expense $81,000.00 $0.00 $0.00 FUND 651 Storm Water Utility $245,105.00 $4,990.02 $23,102.66 $3,143,570.00 $273,553.01 $683,251.04 4(d):12