Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
6.b.ii. Budget Worksheet - Sewer
Page One 2017 BUDGET WORKSHEETS SEWER UTILITY - REVENUES - April 12, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 602 33425.00 Other State Grants & Aids $0 $0 $0 $0 $0 ______________________________ 602 34108.00 Administrative Fees-Other Funds 2,497 3,931 6,828 0 0 5% of 5% Fees-Const Projects 602 36101.00 Principal - Special Assessments 98,077 81,278 78,480 90,000 85,000 ______________________________ 602 36102.00 Penalties & Interest - S/A 327 (1,366)(251)0 0 ______________________________ 602 36210.00 Interest Earnings - Investments 17,042 17,411 13,886 17,000 15,000 ______________________________ 602 36214.00 Net Change in FV-Investments (8,621)8,534 (4,100)0 0 Annual Market Value Changes 602 36215.00 Interest Earnings 76 54 225 200 200 ______________________________ 602 36260.00 Other Revenues 0 0 1,972 0 0 ______________________________ 602 36265.00 Use of Reserve Funds 0 0 0 103,400 351,000 ______________________________ 602 37210.00 Residential Sewer Revenues 1,278,008 1,247,826 1,251,838 1,500,000 1,400,000 ______________________________ 602 37220.00 Apartment Sewer Revenues 114,024 111,519 117,405 134,000 125,000 ______________________________ 602 37225.00 Institutional Sewer Revenues 24,238 24,128 21,813 29,000 25,000 ______________________________ 602 37230.00 Commercial Sewer Revenues 72,645 74,855 78,823 90,000 80,000 ______________________________ 602 37240.00 Industrial Sewer Revenues 86,042 71,258 110,928 85,000 110,000 ______________________________ 602 37260.00 Penalties - Sewer Revenues 12,567 12,104 13,051 12,000 13,000 ______________________________ 602 39103.00 Gain or Loss from F/A Disposal 0 0 0 0 0 ______________________________ 602 39203.00 Transfer From_______________10,806 0 0 0 0 ______________________________ ---------------------------------------------------------------------------------------------------- FUND TOTALS $1,707,729 $1,651,532 $1,690,900 $2,060,600 $2,204,200 ====================================================== Page One 2017 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - April 12, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ All Salary Costs Inclusive of 602 49450 101.00 Salaries & Benefits $509,100 Salary, Taxes, PERA & Benefits 602 49450 77 101.00 Administrative 117,498 117,386 139,515 144,900 172,900 Add $18K for Asst City Engineer 602 49450 78 101.00 Technical/Clerical 142,778 151,671 151,279 158,800 160,500 ______________________________ 602 49450 79 101.00 Maintenance 157,163 163,438 165,527 172,300 175,700 ______________________________ 602 49450 xx 101.00 Salary & Benefit Contingency 0 0 0 0 0 ______________________________ 602 49450 102.00 Full-Time Overtime 15,629 13,810 9,705 7,500 7,500 ______________________________ 602 49450 103.00 Part-Time Salaries & Benefits 5,531 5,707 3,548 9,000 7,000 ______________________________ 602 49450 99 103.01 Utility Commission Wages (50%)1,000 50% - 602; 50% - 601 602 49450 99 103.02 Maintenance Labor 6,000 100% - 602 602 49450 01 203.00 Printed Forms & Paper 1,613 1,416 1,005 1,500 1,500 Inserts & Water Bill Statements 602 49450 01 209.00 Other Office Supplies 899 172 439 200 200 ______________________________ 602 49450 01 212.00 Motor Fuels 5,200 602 49450 01 216.00 Chemicals & Chemical Products 0 0 731 500 500 Root Killer, Degreaser 602 49450 01 219.00 Other Operating Supplies 304 100 9 200 200 ______________________________ 602 49450 01 224.00 Street Maintenance Materials 0 0 1,439 2,500 2,500 Patching 602 49450 01 225.00 Landscaping Materials 0 0 0 400 400 Topsoil, Seed & Sod 602 49450 01 227.00 Utility System Maintenance Supplies 211 797 1,378 5,000 5,000 MH Castings Replacement Prog. 602 49450 01 241.00 Small Tools 165 237 241 500 500 Wrenches, Shovels, etc. 602 49450 01 242.00 Minor Equipment 2,990 3,746 2,765 3,000 3,000 ______________________________ 602 49450 01 303.00 Engineering Fees 23,000 ______________________________ 602 49450 01 303.01 GIS 516 4,607 3,413 5,000 3,000 Reduce Due to In-House Eng 602 49450 01 303.02 Rate Study 0 0 0 15,000 15,000 Part of Comp Plan Update 602 49450 01 303.04 Miscellaneous 7,402 2,846 9,471 15,000 5,000 Reduce Due to In-House Eng 602 49450 01 304.00 Legal Fees 0 0 0 500 0 ______________________________ 602 49450 01 312.00 Gopher State One-Call 2,303 2,770 1,655 2,500 2,500 $7,500 Split 3 Ways 602 49450 01 313.00 Temporary Service Fees 0 0 0 0 0 ______________________________ 602 49450 01 318.00 Contract Engineer 10,000 12,000 6,250 0 0 ______________________________ 602 49450 01 319.00 Other Professional Services 10,000 ______________________________ 602 49450 01 319.01 Televising 0 0 0 3,000 3,000 ______________________________ 602 49450 01 319.02 Root Control 0 0 0 2,000 2,000 ______________________________ 602 49450 01 319.03 Supervisory Controls(Maint Cont)6,802 0 0 5,000 5,000 SCADA System 602 49450 01 319.04 Buxton Project 0 5,556 5,556 5,600 0 ______________________________ 602 49450 01 320.00 Credit Card Activity Fees 3,324 5,372 6,797 6,000 7,000 1/3 Cost of C/C Pymt Processing 602 49450 01 321.00 Telephone Costs 2,745 3,001 3,122 3,500 3,500 Cell Phones, Modems, GPS 602 49450 01 322.00 Postage Costs 4,556 4,173 4,296 5,000 5,000 Billings with Inserts 602 49450 01 323.00 Radio Units 1,045 1,367 1,120 1,500 5,100 (24x$300) (12x$1500) (split 5 ways) 602 49450 01 365.00 Workers Comp Insurance 7,011 7,117 8,361 7,000 7,000 Sewer's Share of Premiums 602 49450 01 369.00 Other Insurance 10,777 12,067 13,292 12,000 12,000 Sewer's Share of Premiums 602 49450 01 391.00 P.C. Maintenance 0 0 0 2,900 ______________________________ 602 49450 01 391.01 U/B Software Maintenance 2,081 2,074 2,074 2,200 2,200 Added to Utility Budgets in 2012 602 49450 01 391.02 Auto Read Software Support 585 578 595 700 700 Added to Utility Budgets in 2012 602 49450 01 392.00 P.C. Accessories & Supplies 0 0 0 200 200 ______________________________ 602 49450 01 393.00 P.C. Hardware Purchases 4,093 1,600 9,199 2,000 2,000 ______________________________ 602 49450 01 394.00 P.C. Software Purchases 16,000 ______________________________ 602 49450 01 394.01 Licensing & Maintenance 4,279 4,371 4,591 6,200 15,000 ESRI, Cartegraph OMS $10,700 602 49450 01 394.02 Online Subscriptions 286 379 379 800 800 Pictometry 602 49450 01 394.03 New Software Purchases 2,271 0 0 200 200 ______________________________ 602 49450 01 395.00 P.C. Repairs 0 0 0 500 500 ______________________________ 602 49450 01 403.00 Contracted R & M - Other Impr 2,581 63 24,454 5,000 30,000 MH Castings Replacement Prog. 602 49450 01 415.00 Other Equipment Rental 0 0 0 200 200 ______________________________ 602 49450 01 416.00 Machinery Rental 0 0 0 2,000 2,000 ______________________________ 602 49450 01 433.00 Dues & Subscriptions 0 0 0 200 200 SUSA (AJ, Dick) 50% Split w/Storm 602 49450 01 435.00 Books & Pamphlets 0 0 0 300 300 Reference Materials 602 49450 01 437.00 Conferences & Seminars 3,800 ______________________________ 602 49450 01 437.01 MPCA Training (Sewer School)1,646 669 600 1,500 1,500 Operator Licensure $300 each (M) 602 49450 01 437.02 Collection System Conference 0 0 0 0 0 Duplicate of Sewer School 437.01 602 49450 01 437.03 CarteGraph, ESRI, GIS 120 126 0 1,300 1,300 User Group, Conference, Training 602 49450 01 437.04 Miscellaneous Training 0 0 814 1,000 1,000 ______________________________ 602 49450 01 439.00 Other Miscellaneous Charges 148 145 258 100 300 Contingencies 602 49450 01 521.00 Building & Structure Purchases 0 0 0 10,000 10,000 Pymt on P.W. Building (18 of 20) 602 49450 01 530.00 Improvements Other Than Bldgs 160,000 ______________________________ 602 49450 01 530.01 Miscellaneous Improvements 31 0 0 10,000 10,000 SCADA Reconfiguration, PLC's 602 49450 01 530.03 CRP of Sewermain 0 0 0 150,000 150,000 Annual Pavement Management 602 49450 01 540.00 Heavy Machinery Purchases 0 189,190 63 0 0 Equipment Purchases - Match CIP 602 49450 01 560.00 Furniture & Fixture Purchases 0 0 56 500 500 ______________________________ 602 49450 01 570.00 Office Equipment Purchases 0 0 0 500 500 ______________________________ 602 49450 01 580.00 Other Equipment Purchases 18,000 Pump, Truck 8333 (Split w 601, 603) ---------------------------------------------------------------------------------------------------- PAGE TOTALS 519,385 718,548 583,995 790,300 865,100 Page Two 2017 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - April 12, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 602 49450 01 602.00 Sewer Service Charges 1,007,195 1,090,261 1,077,415 1,185,400 1,284,600 MWCC Charges (10% Increase) 602 49450 01 611.00 Interest on Lease Payments 2,538 2,165 1,773 0 0 P.W. Building Expansion(See 521) 602 49450 01 710.00 Transfers 116,948 2,405 0 0 Transfers for Other Improvements ---------------------------------------------------------------------------------------------------- 602-49450-01 TOTALS 1,646,066 1,813,379 1,663,183 1,975,700 2,149,700 602 49451 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49451 01 221.00 Equipment Parts 0 0 0 800 800 ______________________________ 602 49451 01 229.00 Other Maintenance Supplies 0 0 567 200 200 ______________________________ 602 49451 01 303.00 Engineering Fees 0 0 0 0 0 ______________________________ 602 49451 01 381.00 Electric Utilities 915 916 761 1,500 1,500 ______________________________ 602 49451 01 403.00 Contracted R & M - Other Impr 0 775 704 45,000 2,000 New Electronics and Cabinet 602 49451 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (City Hall)TOTAL - LIFT STATION #1 915 1,691 2,032 47,700 4,700 602 49452 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49452 01 221.00 Equipment Parts 1,060 0 0 800 800 ______________________________ 602 49452 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49452 01 321.00 Telephone Costs 0 0 0 0 0 ______________________________ 602 49452 01 381.00 Electric Utilities 630 623 604 700 700 ______________________________ 602 49452 01 403.00 Contracted R & M - Other Impr 0 0 0 200 2,000 ______________________________ 602 49452 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Bloomfield 5th)TOTAL - LIFT STATION #7 1,691 623 604 2,100 3,900 602 49453 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49453 01 221.00 Equipment Parts 0 0 0 800 800 ______________________________ 602 49453 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49453 01 381.00 Electric Utilities 3,753 3,548 3,728 4,000 4,000 ______________________________ 602 49453 01 403.00 Contracted R & M - Other Impr 0 7,395 0 200 2,000 ______________________________ 602 49453 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Shannon Pond)TOTAL - LIFT STATION #3 3,753 10,942 3,728 5,400 7,200 602 49454 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49454 01 221.00 Equipment Parts 167 6 0 800 800 ______________________________ 602 49454 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49454 01 381.00 Electric Utilities 4,602 4,821 5,539 6,000 6,000 ______________________________ 602 49454 01 403.00 Contracted R & M - Other Impr 1,582 0 0 2,000 2,000 ______________________________ 602 49454 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Hawkins)TOTAL - LIFT STATION #4 6,351 4,827 5,539 9,200 9,200 602 49455 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49455 01 221.00 Equipment Parts 0 1,800 0 800 800 ______________________________ 602 49455 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49455 01 303.00 Engineering Fees 0 0 0 0 0 ______________________________ 602 49455 01 310.00 Testing Services 0 0 0 0 0 ______________________________ 602 49455 01 381.00 Electric Utilities 5,569 5,802 4,979 6,000 6,000 ______________________________ 602 49455 01 403.00 Contracted R & M - Other Impr 0 415 2,350 200 2,000 ______________________________ 602 49455 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (LeForet Add'n)TOTAL - LIFT STATION #5 5,569 8,016 7,329 7,400 9,200 602 49456 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49456 01 221.00 Equipment Parts 2,385 0 0 800 800 ______________________________ 602 49456 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49456 01 381.00 Electric Utilities 6,001 8,270 3,945 6,000 6,000 ______________________________ 602 49456 01 403.00 Contracted R & M - Other Impr 0 0 0 200 2,000 ______________________________ 602 49456 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Drumcliffe)TOTAL - LIFT STATION #6 8,385 8,270 3,945 7,400 9,200 Page Three 2017 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - April 12, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 602 49457 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49457 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 602 49457 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49457 01 381.00 Electric Utilities 1,278 857 216 1,200 1,200 ______________________________ 602 49457 01 403.00 Contracted R & M - Other Impr 0 0 1,533 200 2,000 ______________________________ 602 49457 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Glendalough 5th)TOTAL - LIFT STATION #9 1,278 857 1,749 2,300 4,100 602 49458 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49458 01 221.00 Equipment Parts 1,269 0 0 500 500 ______________________________ 602 49458 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49458 01 381.00 Electric Utilities 633 629 449 800 800 ______________________________ 602 49458 01 403.00 Contracted R & M - Other Impr 0 0 539 200 2,000 ______________________________ 602 49458 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Meadows of )TOTAL - LIFT STATION #8 1,902 629 987 1,900 3,700 (Bloomfield) 602 49460 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49460 01 221.00 Equipment Parts 725 0 0 500 500 ______________________________ 602 49460 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49460 01 381.00 Electric Utilities 252 261 233 400 400 ______________________________ 602 49460 01 403.00 Contracted R & M - Other Impr 0 0 0 200 2,000 ______________________________ 602 49460 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Glen Rose)TOTAL - LIFT STATION #10 977 261 233 1,500 3,300 GRAND TOTAL - ALL DEPTS.$1,676,886 $1,849,496 $1,689,329 $2,060,600 $2,204,200 ====================================================== 6.97%