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.iii. Budget Worksheet- Storm
Page One 2017 BUDGET WORKSHEETS STORM WATER UTILITY - REVENUES - April 12, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 603 33400.00 State Grants & Aids $0 $0 $0 $0 $0 ______________________________ 603 33425.00 Other State Grants & Aids 0 0 0 0 0 ______________________________ 603 33620.00 Other County Grants & Aids 0 19,680 0 0 0 ______________________________ 603 34108.00 Administrative Fees-Other Funds 2,497 3,931 6,828 0 0 5% of 5% Fees-Const Projects 603 36101.00 Principal - Special Assessments 19,925 25,726 21,967 22,000 22,000 ______________________________ 603 36102.00 Penalties & Interest - S/A 76 (362)(57)0 0 ______________________________ 603 36210.00 Interest Earnings - Investments 21,458 37,889 34,724 25,000 25,000 ______________________________ 603 36214.00 Net Change in FV-Investments (48,916)40,005 (8,127)0 0 Annual Market Value Changes 603 36215.00 Interest Earnings 60 47 213 200 200 ______________________________ 603 36260.00 Other Revenues 188,004 35,615 0 0 0 ______________________________ 603 36262.00 Special Settlements 0 24,797 0 0 0 ______________________________ 603 36265.00 Use of Reserve Funds 0 0 0 0 0 ______________________________ 603 37300.00 Storm Water Utility Revenues 980,819 1,040,839 1,102,373 1,000,000 1,215,000 5% Rate Increase Per Year 603 37360.00 Penalties - Storm Water Utility 5,956 6,577 9,300 6,000 6,000 ______________________________ 603 39203.00 Transfer From______________0 14,260 24,000 0 0 ______________________________ ------------------------------------------------------------------------------------------------------ FUND TOTALS $1,169,878 $1,249,004 $1,191,221 $1,053,200 $1,268,200 ====================================================== Page One 2017 BUDGET WORKSHEETS STORM WATER 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 603 49500 101.00 Salaries & Benefits $277,800 Salary, Taxes, PERA & Benefits 603 49500 77 101.00 Administrative 10,586 10,932 26,693 39,400 79,900 Add $36K for Asst City Engineer 603 49500 78 101.00 Technical/Clerical 80,607 85,598 85,202 86,800 87,300 ______________________________ 603 49500 79 101.00 Maintenance 78,581 81,718 82,763 87,900 110,600 ______________________________ 603 49500 xx 101.00 Salary & Benefit Contingency 0 0 0 0 0 ______________________________ 603 49500 102.00 Full-Time Overtime 7,836 6,918 4,928 6,000 6,000 ______________________________ 603 49500 99 103.00 Part-Time Salaries & Benefits 5,157 4,323 6,506 8,000 8,000 ______________________________ 603 49500 01 203.00 Printed Forms & Paper 1,613 1,416 1,005 1,500 1,500 ______________________________ 603 49500 01 204.00 Envelopes & Letterhead 0 0 0 0 0 ______________________________ 603 49500 01 208.00 Miscellaneous Supplies 1,090 0 397 500 500 Stakes, Ribbons, Level, etc. 603 49500 01 212.00 Motor Fuels 6,200 603 49500 01 215.00 Shop Materials 0 0 0 0 0 ______________________________ 603 49500 01 219.00 Other Operating Supplies 0 0 0 0 0 ______________________________ 603 49500 01 221.00 Equipment Parts 0 0 0 0 0 ______________________________ 603 49500 01 224.00 Street Maintenance Materials 515 1,505 39 2,000 2,000 Patching Material for Washouts 603 49500 01 225.00 Landscaping Materials 2,000 ______________________________ 603 49500 01 225.01 Rip-Rap, Matting, Rock, etc.898 1,868 1,162 2,000 1,000 ______________________________ 603 49500 01 225.02 Black Dirt, Seed, Sod, etc.150 150 0 2,000 1,000 ______________________________ 603 49500 01 226.00 Sign Repair Materials 0 0 0 500 500 ______________________________ 603 49500 01 230.00 Equipment Repair Material 1,754 1,018 482 1,000 1,000 ______________________________ 603 49500 01 241.00 Small Tools 349 627 260 1,000 1,000 ______________________________ 603 49500 01 242.00 Minor Equipment 2,659 1,567 943 2,000 2,000 Misc. Nozzles for Vac Truck 603 49500 01 303.00 Engineering Fees 100,000 ______________________________ 603 49500 01 303.01 Problem Area Investigations 79 0 0 10,000 5,000 Reduce Due to In-House Eng 603 49500 01 303.02 NPDES Phase II 14,115 68,996 75,829 40,000 32,000 Reduce Due to In-House Eng 603 49500 01 303.03 CSMP Update 4,850 2,535 25,026 50,000 50,000 Part of Comp Plan Update 603 49500 01 303.04 Miscellaneous 14,108 5,265 11,053 20,000 10,000 Reduce Due to In-House Eng 603 49500 01 303.05 GIS 344 3,071 2,276 5,000 3,000 Reduce Due to In-House Eng 603 49500 01 303.06 MS4 Services 0 0 0 10,000 0 ______________________________ 603 49500 01 304.00 Legal Fees 0 0 0 2,000 2,000 ______________________________ 603 49500 01 310.00 Testing Services 0 0 0 1,000 1,000 Water Quality Tests (M) 603 49500 01 312.00 Gopher State One-Call 0 169 2,012 2,500 2,500 $7,500 Split 3 Ways 603 49500 01 313.00 Temporary Service Fees 0 0 0 0 0 ______________________________ 603 49500 01 315.00 Special Programs (County Program)4,815 4,815 3,850 5,000 5,000 WHEP 603 49500 01 318.00 Contract Engineer 10,000 12,000 6,250 0 0 ______________________________ 603 49500 01 319.00 Other Professional Services 6,802 5,000 ______________________________ 603 49500 01 319.01 SCADA 0 0 0 5,000 5,000 ______________________________ 603 49500 01 319.02 Buxton Project 0 5,556 5,556 5,600 0 ______________________________ 603 49500 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 603 49500 01 321.00 Telephone Costs 2,745 3,002 3,122 3,500 3,500 Cell Phones, Modems, GPS 603 49500 01 322.00 Postage Costs 4,556 4,173 4,296 5,000 5,000 Billings & Info Mailings 603 49500 01 323.00 Radio Units 1,045 1,367 1,120 1,500 5,100 (24x$300) (12x$1500) (split 5 ways) 603 49500 01 352.00 General Notices & Public Info 0 0 0 1,000 1,000 Public Info Brochure 603 49500 01 365.00 Workers Comp Insurance 2,925 2,992 3,541 3,500 3,500 Storm Water's Share of Premiums 603 49500 01 369.00 Other Insurance 1,278 1,316 1,203 4,000 4,000 Storm Water's Share of Premiums 603 49500 01 391.00 P.C. Maintenance 2,900 ______________________________ 603 49500 01 391.01 U/B Software Maintenance 2,081 2,074 2,074 2,200 2,200 Added to Utility Budgets in 2012 603 49500 01 391.02 Auto Read Software Support 585 578 595 700 700 Added to Utility Budgets in 2012 603 49500 01 393.00 P.C. Hardware Purchases 4,093 1,600 9,199 2,000 2,000 ______________________________ 603 49500 01 394.00 P.C. Software Purchases 16,000 ______________________________ 603 49500 01 394.01 Licensing & Maintenance 4,279 4,371 4,591 6,200 15,000 ESRI, Cartegraph OMS $10,700 603 49500 01 394.02 Online Subscriptions 286 379 379 800 800 Pictometry 603 49500 01 394.03 New Software Purchases 2,271 0 0 200 200 ______________________________ 603 49500 01 403.00 Contracted R & M - Other Impr 68,000 ______________________________ 603 49500 01 403.01 Ditching 4,330 8,344 0 8,000 8,000 ______________________________ 603 49500 01 403.02 Miscellaneous Repairs 32,838 117,136 20,634 60,000 60,000 Catch Basins, Manholes, Etc. 603 49500 01 403.03 Pond Inspection & Maintenance 0 0 0 10,000 0 ______________________________ 603 49500 01 405.00 MS4 Permit Compliance 170,000 603 49500 01 405.01 Engineering Fees 45,000 Inspection, GIS, Guidance, Etc. 603 49500 01 405.02 Equipment Rental 20,000 Bulldozer, Large Equipment 603 49500 01 405.03 Dirt, Seed, Rip Rap, Etc.5,000 For Restoration 603 49500 01 405.04 Contracted Maintenace 100,000 Brush Clearing, Dredging ($40k) 603 49500 01 416.00 Machinery Rental 64 0 0 4,000 2,500 Pumps 603 49500 01 433.00 Dues & Subscriptions 140 140 140 200 200 SUSA(AJ, Dick) 50% Split w/Storm 603 49500 01 435.00 Books & Pamphlets 0 0 73 500 500 Utility Information 603 49500 01 437.00 Conferences & Seminars 3,500 ______________________________ 603 49500 01 437.01 Storm Water Management 112 0 0 1,200 1,200 Stormwater Collab, Flygt Training 603 49500 01 437.03 Wetlands Training 0 0 0 0 0 ______________________________ 603 49500 01 437.04 Cartegraph, ESRI, GIS 120 126 0 1,300 1,300 User Group, Conference, Training 603 49500 01 437.05 Miscellaneous Training 0 0 165 1,000 1,000 ______________________________ 603 49500 01 439.00 Other Miscellaneous Charges 908 145 265 0 300 ______________________________ 603 49500 01 530.00 Improvements Other Than Bldgs 356,300 ______________________________ 603 49500 01 530.01 CRP of Storm Sewer 6,523 0 7,800 150,000 150,000 Keegan Lake Drainage in 2017 603 49500 01 530.02 Stormwater System Improvements 206,300 Keegan Lake Drainage in 2017 603 49500 01 540.00 Heavy Machinery Purchases 99,000 Sweeper (Split w/Equipment CIP) 603 49500 01 550.00 Motor Vehicle Purchases 0 0 0 0 10,000 Truck 8333 (Split w 601, 602) 603 49500 01 560.00 Furniture & Fixture Purchases 0 189,190 0 500 500 ______________________________ 603 49500 01 580.00 Other Equipment Purchases 0 0 63 2,000 48,000 Pump (Split w 601, 602), Dump Stn 603 49500 01 586.00 Computer Equipment Purchases 0 0 0 500 500 ______________________________ ------------------------------------------------------------------------------------------------------ PAGE TOTALS 321,410 642,351 408,288 672,500 1,233,300 Page Two 2017 BUDGET WORKSHEETS STORM WATER UTILITY - EXPENDITURES - April 12, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 603 49500 01 710.00 Transfers 32,000 ______________________________ 603 49500 01 710.06 1/2 of 2011 P & I Payments(2010A)89,000 87,000 51,000 51,000 32,000 Refunding Issue 12/10 603 49500 01 710.10 Projects 81,225 123,395 384,695 0 0 ------------------------------------------------------------------------------------------------------ 603-49500-01 TOTALS 491,635 852,746 843,983 723,500 1,265,300 603 49511 01 221.00 Equipment Parts 410 0 0 500 500 ______________________________ 603 49511 01 381.00 Electric Utilities 312 360 277 500 500 ______________________________ 603 49511 01 403.00 Contracted Repair & Maintenance 0 278 1,455 1,000 1,000 ______________________________ ------------------------------------------------------------------------------------------------------ (Copper Pond)TOTAL - LIFT STATION #1 722 638 1,732 2,000 2,000 603 49512 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49512 01 381.00 Electric Utilities 0 0 0 500 500 ______________________________ 603 49512 01 403.00 Contracted Repair & Maintenance 0 0 1,897 1,000 1,000 ______________________________ ------------------------------------------------------------------------------------------------------ (Schwarz Pond)TOTAL - LIFT STATION #2 0 0 1,897 2,000 2,000 603 49513 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49513 01 381.00 Electric Utilities 5,176 5,552 4,157 6,000 6,000 ______________________________ 603 49513 01 403.00 Contracted Repair & Maintenance 0 0 1,455 1,000 1,000 ______________________________ ------------------------------------------------------------------------------------------------------ (Birger Pond)TOTAL - LIFT STATION #3 5,176 5,552 5,612 7,500 7,500 603 49514 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49514 01 381.00 Electric Utilities 1,500 2,067 986 2,500 2,500 ______________________________ 603 49514 01 403.00 Contracted Repair & Maintenance 0 103 1,765 1,000 1,000 Alarm Upgrades ------------------------------------------------------------------------------------------------------ (Marcotte Pond)TOTAL - LIFT STATION #4 1,500 2,170 2,751 4,000 4,000 603 49515 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49515 01 381.00 Electric Utilities 0 0 0 500 500 ______________________________ 603 49515 01 403.00 Contracted Repair & Maintenance 0 0 1,455 1,000 1,000 Alarm Upgrades, SCADA, PLC ------------------------------------------------------------------------------------------------------ (Hawkins Pond)TOTAL - LIFT STATION #5 0 0 1,455 2,000 2,000 603 49516 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49516 01 381.00 Electric Utilities 449 473 352 500 500 ______________________________ 603 49516 01 403.00 Contracted Repair & Maintenance 0 145 1,455 1,000 1,000 ______________________________ ------------------------------------------------------------------------------------------------------ (Glendalough 7th)TOTAL - LIFT STATION #6 449 618 1,807 2,000 2,000 603 49517 01 221.00 Equipment Parts 0 0 0 0 500 ______________________________ 603 49517 01 381.00 Electric Utilities 0 0 0 0 500 ______________________________ 603 49517 01 403.00 Contracted Repair & Maintenance 0 0 0 0 1,000 ______________________________ ------------------------------------------------------------------------------------------------------ (Horseshoe Lake)TOTAL - LIFT STATION #7 0 0 0 0 2,000 GRAND TOTAL - ALL DEPTS.$499,484 $861,724 $859,238 $743,000 $1,286,800 ====================================================== 73.19%