The URL can be used to link to this page

Home My WebLink About5. 2011/2012 Utility Funds SANITARY SEWER FUND 2011- 2012 BUDGET ACTIVITY: Activity in this enterprise fund reflects the operations of the Municipal Sanitary Sewer System. MEASUREMENT OF GOALS: Actual Requested Requested Requested 2009 2010 2011 2012 Televised (LF) Planned 39,847 50,000 70,000 70,000 Televised (LF) Other 10,050 8,000 8,000 3,000 Jetted (LF) 224,850 230,000 230,000 230,000 Jetted Root Control (LF) 8,482 7,500 7,500 7,500 Jetted (LF) Other Than Planned 10,250 8,000 3,000 3,000 Piped Relined (LF) 10,250 8,000 7,500 8,000 Construction Inspections 145 75 75 75 New Service Connections 188 75 100 100 Staff 2009 2010 2011 2012 maintenance operator 2 2 3 3 OBJECT DESCRIPTION: Description of lines items: Salaries: Share of Public Works staff /Engineering staff. Supplies and Services: Repair and maintain current sewer lines including; manhole rehabilitation or replacement, repairing lines, GIS /GPS hardware, motor fuels, safety equipment, GPS unit for vehicle. Professional Services: Attorney, engineering consultant for projects $40,000, televising $35,000, foaming $25,000, lining of sewer mains, Lift Station Maintenance, Gopher State One Call $5,000, GIS /CMMS consultant, emergency call center service. Rentals: Software IT charges and Cartegraph Building rent and equipment rent. Utility Service: 5 -1 Lift stations, payment to Savage for Whispering Oaks sewer. MCES Treatment Cost: Metro Council Environmental Services. Depreciation: Includes equipment and infrastructure. Capital Expenditures: Projects per CIP, Jetter Vac, $250,000 (2012) Equipment in Sewer Fund: 1993 Ford high pres. Jetter $ S4,S27 2000 Ford 1.5 T P/U w /Hoist 52,860 2002 Versa -Vac 60,300 2006 Ford F350 W /Plow 26,369 2007 Sterling Acterra — Jetter 127,612 5 -2 R5509BUD SH001PV CITY OF SHAKOPEE 8/12/2010 16:09:16 By Company (pb), Object (2 Yr Bdgt) - Portrait Budget Report Page - 1 Fiscal Period: 7 / 10 Level Of Rollup 6 2008 2009 7/31/2010 2010 2011 2012 Actual Actual YTD Final Proposed Proposed Object Code / Description Amount Amount Actual Budget Budget Budget 07100 SEWER FUND 4000 REVENUES AND EXPENDITURES 4001 REVENUES 4005 TAXES 4100 SPECIAL ASSESSMENT 4111 SPEC ASSESSMENT INTEREST 22,579- 19,358- 15,000- 10,000- 8,000 4120 SA PREPAY 4,622- 4100 SPECIAL ASSESSMENT 22,579- 19,358- 4,622- 15,000- 10,000- 8,000 4200 LICENSES AND PERMITS 4400 INTERGOVERNMENTAL 4500 CHARGES FOR SERVICE 4720 SEWER CHARGES 2,556,259- 3,466,524 1,608,931- 2,716,000- 2,809,000- 3,000,000- 4500 CHARGES FOR SERVICE 2,556,259- 3,466,524- 1,608,931- 2,716,000- 2,809,000- 3,000,000- 4830 MISCELLANEOUS 4832 INVESTMENT INCOME 777,230- 544,252- 187,365 600,000- 500,000- 500,000- 4830 MISCELLANEOUS 777,230- 544,252- 187,365 600,000- 500,000- 500,000- 4970 CAPITAL CONTRIBUTIONS 4971 CAPITAL CONTRIBUTIONS 603,716- 176,647- 4970 CAPITAL CONTRIBUTIONS 603,716- 176,647- 4001 REVENUES 3,959,785- 4,206,781- 1,426,188- 3,331,000- 3,319,000- 3,492,000- 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 169,379 184,325 114,293 189,280 194,780 209,540 6100 BENEFITS 62,829 75,345 43,020 83,450 79,630 83,010 6001 WAGES & BENEFITS 232,208 259,670 157,314 272,730 274,410 292,550 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 24,594 31,104 13,369 55,500 55,500 57,000 6300 PROFESSIONAL SERVICES 120,001 149,477 104,605 155,000 147,000 157,000 6330 COMMUNICATIONS 1,949 2,478 1,796 2,400 3,250 3,250 6350 INSURANCE 30,245 21,175 7,862 26,000 26,000 26,000 6360 UTILITY SERVICE 2,167,407 2,177,818 1,377,588 2,383,450 2,639,345 2,770,050 6400 RENTALS 10,872 19,847 15,498 23,720 43,410 44,190 6470 DUES/TRAINING/TRAVEL 2,256 2,401 1,837 6,800 6,800 6,300 6498 EXPENSE CHARGED BACK 7,837 10,923 17,000 23,670 6200 SUPPLIES AND SERVICES 2,365,161 2,415,223 1,522,556 2,669,870 2,944,975 3,063,790 6500 DEPRECIATION 6501 DEPRECIATION EXPENSE 707,395 718,027 750,000 750,000 750,000 6500 DEPRECIATION 707,395 718,027 750,000 750,000 750,000 6600 MISCELLANEOUS 6610 AWARDS & DAMAGES 5,200 2,500 6600 MISCELLANEOUS 5,200 2,500 6700 CAPITAL OUTLAY 55,000 250,000 6740 EQUIPMENT 55,000 250,000 6700 CAPITAL OUTLAY 5 -3 R5509BUD SH001PV CITY OF SHAKOPEE 811212010 16:09:16 By Company (pb), Object (2 Yr Bdgt) - Portrait Budget Report Page - 2 Fiscal Period: 7 / 10 Level Of Rollup 6 2008 2009 7/31/2010 2010 2011 2012 Actual Actual YTD Final Proposed Proposed Object Code / Description Amount Amount Actual Budget Budget Budget 6800 DEBT SERVICE 6000 EXPENDITURES 3,304,764 3,398,120 1,682,370 3,747,600 3,969,385 4,356,340 8005 TOTAL TRANSFERS IN 8010 OPERATING TRANSFERS IN 8050 TOTAL TRANSFERS OUT 8052 TRANSFERS OUT 8053 TRANSFERS OUT 25,000 50,000 50,000 50,000 50,000 8056 OPERATING TRANSFER /CAPITAL FD 14,819 154,782 8052 TRANSFERS OUT 39,819 204,782 50,000 50,000 50,000 8050 TOTALTRANSFERS OUT 39,819 204,782 50,000 50,000 50,000 4000 REVENUES AND EXPENDITURES 615,202- 603,878- 256,182 466,600 700,385 914,340 07100 SEWER FUND 615,202- 603,878- 256,182 466,600 700,385 914,340 5 -4 SURFACE WATER FUND 2011- 2012 BUDGET ACTIVITY: Activity in this enterprise fund reflects the operations of the Municipal Storm Drainage System. MEASUREMENT OF GOALS: Actual Actual ivt 2009 2010 Televised (LF) Planned 50 100 Drainage Complaints 27 15 15 15 Construction Inspections 650 1 375 375 375 Ponds Inspected 9 15 30 30 Control Structures Checked 5 5 5 5 Staff 2009 2010 2011 2012 Maintenance Operator 2 2 3 3 OBJECT DESCRIPTION: Description of lines items: Salaries: Share of Public Works staff /Engineering staff. Supplies and Services: Materials for maintaining /repairing storm sewer facilities, GIS /GPS hardware, GPS unit for vehicle, motor fuels. Professional Services: Engineering consultant to update storm water plans, storm water model, review of storm water utility policy and procedures and rate study, water quality monitoring study in infiltration areas and downtown area, GIS /CMMS consultant service, Gopher State One Call, contract work for manhole /catch basin repair Rentals: Software IT charges and Cartegraph Building Rental ($15,000) and equipment rental. Utility Service: ($1,000). Depreciation: Includes equipment and infrastructure. 5 -5 Capital Expenditures: Projects per CIP, Slope mower $120,000 (2011) Equipment in Surface Water Fund; 2002 Leaf collection sys $ 30,507 2003 Street Sweeper 127,653 2005 Tanker truck 109,139 2005 Terratrac TT75 mower 90,268 2008 Bobcat S185 24,280 2008 JD 6430 /mower 94,167 2009 Regenerative sweeper 175,000 Pickup 5 -6 R5509BUD SH001PV CITY OF SHAKOPEE 8/12/2010 16:04:05 By Company (pb), Object (2 Yr Bdgt) - Portrait Budget Report Page - 3 Fiscal Period: 7 / 10 Level Of Rollup 6 2008 2009 7/31/2010 2010 2011 2012 Actual Actual YTD Final Proposed Proposed Object Code / Description Amount Amount Actual Budget Budget Budget 07300 SURFACE WATER FUND 4000 REVENUES AND EXPENDITURES 4001 REVENUES 4005 TAXES 4100 SPECIAL ASSESSMENT 4200 LICENSES AND PERMITS 4400 INTERGOVERNMENTAL 4500 CHARGES FOR SERVICE 4740 STORM DRAINAGE 1,379,821- 1,405,560- 589,405- 1,239,000- 1,141,000- 1,141,000- 4500 CHARGES FOR SERVICE 1,379,821- 1,405,560- 589,405- 1,239,000- 1,141,000- 1,141,000- 4830 MISCELLANEOUS 537,239- 218,439 600,000- 580,000- 550,000- 4832 INVESTMENT INCOME 820,293- 4830 MISCELLANEOUS 820,293- 537,239- 218,439 600,000- 580,000- 550,000- 4970 CAPITAL CONTRIBUTIONS 4971 CAPITAL CONTRIBUTIONS 13,800- 144,420- 4970 CAPITAL CONTRIBUTIONS 13,800- 144,420- 4001 REVENUES 2,213,915- 2,087,220- 370,966- 1,839,000- 1,721,000- 1,691,000- 6000 EXPENDITURES 6001 WAGES & BENEFITS 228,211 264,353 122,015 239,150 249,150 270,880 6002 WAGES 6100 BENEFITS 80,590 98,769 38,063 103,700 87,370 93,040 6001 WAGES & BENEFITS 308,800 363,122 160,078 342,850 336,520 363,920 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 42,144 47,544 20,011 74,900 69,900 70,000 6300 PROFESSIONAL SERVICES 406,919 151,550 282,208 230,000 265,000 265,000 6330 COMMUNICATIONS 1,796 1,733 1,754 2,500 2,500 2,500 6350 INSURANCE 5,968 12,277 9,276 12,200 13,500 14,600 6360 UTILITY SERVICE 1,015 867 203 1,000 1,000 1,000 6400 RENTALS 12,371 22,330 14,746 21,220 43,410 44,190 6470 DUES/TRAINING/TRAVEL 888 875 831 4,400 4,400 4,400 6498 EXPENSE CHARGED BACK 7,837 10,923 15,000 23,670 15,000 6200 SUPPLIES AND SERVICES 478,939 248,099 329,030 361,220 423,380 416,690 6500 DEPRECIATION 6501 DEPRECIATION EXPENSE 647,637 653,041 680,000 680,000 680,000 6500 DEPRECIATION 647,637 653,041 680,000 680,000 680,000 6600 MISCELLANEOUS 6620 PROPERTY TAX/SPECIAL ASSESS 80 6600 MISCELLANEOUS 80 6700 CAPITAL OUTLAY 6740 EQUIPMENT 120,000 6700 CAPITAL OUTLAY 120,000 6800 DEBT SERVICE 6000 EXPENDITURES 1,435,376 5 164,263 489,188 1,384,070 1,559,900 1,460,610 R55098UD SH001PV CITY OF SHAKOPEE 8/12/2010 16:04:05 By Company (pb), Object (2 Yr Bdgt) - Portrait Budget Report Page - 4 Fiscal Period: 7 / 10 Level Of Rollup 6 2008 2009 7/31/2010 2010 2011 2012 Actual Actual YTD Final Proposed Proposed Object Code / Description Amount Amount Actual Budget Budget Budget 8005 TOTAL TRANSFERS IN 8010 OPERATING TRANSFERS IN 8050 TOTAL TRANSFERS OUT 8052 TRANSFERS OUT 48,040 50,000 50,000 50,000 50,000 8053 TRANSFERS OUT 8056 OPERATING TRANSFER /CAPITAL FD 24,293 99,340 8052 TRANSFERS OUT 72,333 149,340 50,000 50,000 50,000 8050 TOTALTRANSFERS OUT 72,333 149,340 50,000 50,000 50,000 4000 REVENUES AND EXPENDITURES 706,205- 673,617- 118,222 404,930- 911,100- 180,39o- 07300 SURFACE WATER FUND 706,205- 673,617- 118,222 404,930- 111,100- 180,390- 5 -8