Loading...
HomeMy WebLinkAbout6.a. 2016 Utility Budgets SROSEMOUNT EXECUTIVE SUMMARY UTILITY COMMISSION Utility Commission Meeting: October 19, 2015 AGENDA ITEM: 2016 Utility Budgets AGENDA SECTION: PREPARED BY: Patrick Wrase, PE, Director of Public Works / City Engineer and Christine AGENDA NO.(,, a Watson, Public Works Coordinator �U ATTACHMENTS: Proposed 2016 Utility Budgets APPROVED BY: RECOMMENDED ACTION: Motion to Recommend City Council Approval of the 2016 Utility Budgets BACKGROUND Attached for your consideration are the proposed 2016 Utility Budgets for water, sanitary sewer, and storm sewer. Public Works staff has worked to develop a proposed budget that meets the goals of Council while maintaining service levels. Following is an overview of the notable proposed changes. Water Utility Fund Annual budget decreasing from$1,686,300 to $1,579,300 (6.3%decrease) 601-49400-XX-101.00 Increasing from$449,100 to $491,600. Addition of Public Salaries &Benefits Works Director/City Engineer position (shared among several budgets). 601-49400-01-220.01 Increasing from $45,000 to $60,000. This line item and the one below are consistent with our water rate model. More meters Water Meter Replacements are purchased for replacements than for new homes. 601-49400-01-220.02 Decreasing from $68,000 to $45,000. See above explanation. Water Meter New Homes 601-49400-01-229.03 Increasing from $2,200 to $12,000. Enhanced program for GV Repair/Replacement maintenance and repair of gate valves. 601-49400-01-303.03 Increasing from$0 to $15,000. A rate study will be performed Engineering Fees—Rate Study as part of the Comprehensive Plan update. 601-49400-01-318.00 Decreasing from $25,000 to $0. No longer needed with full- Contract Engineer time Engineer on staff. G:A2U16 Budget\20151019 UC utility budgets.docx 601-49400-01-320.00 Increasing from$3,000 to $6,000. Cost of processing credit Credit Card Activity Fees card payments (split 3 ways between Water, Sewer, Storm) 601-49400-01-530.04 Decreasing from$320,000 to $190,000. Proposed Improvement Other Than improvements for 2016 include a pump recondition for Well 8, Buildings - Inspection& and Chippendale Tower reconditioning (power wash exterior, Maintenance paint interior). Sanitary Sewer Utility Fund Annual budget increasing from $1,883,800 to $2,060,000 (9.4% increase) 602-49450-XX-101.00 Increasing from$449,600 to $492,100. Addition of Public Works Salaries&Benefits Director/City Engineer position (shared among several budgets). 602-49450-01-303.02 Increasing from$0 to $15,000. A rate study will be performed as Engineering Fees—Rate Study part of the Comprehensive Plan update. 602-494500-01-318.00 Decreasing from$25,000 to $0. No longer needed with full-time Contract Engineer Engineer on staff. 602-49450-01-320.00 Increasing from$3,000 to$6,000. Cost of processing credit card Credit Card Activity Fees payments (split 3 ways between Water, Sewer, Storm) 602-49450-01-602.00 Increasing from$1,080,000 to$1,185,400. This 9.6%increase is Sewer Service Charges due to a combination of both a rate and a flow increase. 602-49451-01-403.00 Increasing from$200 to $45,000. New electronics and cabinet Contracted R&M—Other upgrades for Lift Station 1. 2 Storm Sewer Utility Fund Annual budget increasing from $663,900 to $743,700 (12.0% increase) 603-49500-XX-101.00 Increasing from$193,700 to $228,800. Addition of Public Works Salaries &Benefits Director/City Engineer position (shared among several budgets). 603-49500-01-303.02 Increasing from$30,000 to $40,000. Increasing scope of Engineering Fees - NPDES contracted services. 603-49500-01-303.03 Increasing from$0 to $50,000. A rate study will be performed as Engineering Fees—Rate part of the Comprehensive Plan update. Study 603-49500-01-303.06 Increasing from$0 to $10,000. New line item; cost for contracted Engineering Fees—MS4 services with WSB &Associates. 603-49500-01-318.00 Decreasing from$25,000 to $0. No longer needed with full-time Contract Engineer Engineer on staff. 603-49500-01-320.00 Increasing from$3,000 to $6,000. Cost of processing credit card Credit Card Activity Fees payments (split 3 ways between Water,Sewer,Storm) 603-49500-01-403.02 Increasing from$50,000 to $60,000. Increasing cost and Contracted R&M—Misc. enhanced effort towards maintenance and repair of catch basins, manholes, etc. SUMMARY Staff is requesting Utility Commission recommendation to the City Council to approve the proposed 2016 Utility Budgets. 3 Page One 2016 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES- April 14,2015 2016 2015 Object 2016 2012 2013 2014 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 601 49400 101.00 Salaries&Benefits $475,600 Salary,Taxes,PERA&Benefits 601 49400 77 101.00 Administrative 120,763 117,500 117,387 115,100 144,300 601 49400 78 101.00 Technical/Clerical 144,153 142,778 151,671 153,100 160.800 601 49400 79 101.00 Maintenance 146,589 157,164 163,437 164,900 170,500 601 49400 xx 101.00 Salary&Benefit Contingency 0 0 0 0 0 601 49400 102.00 Full-Time Overtime 7,794 15,629 13,810 8,000 8,000 601 49400 103.00 Part-Time Salaries&Benefits 6,112 5,697 6,508 8,000 8,000 601 49400 99 103.01 Utility Commission Wages(50%) 1,000 50%-601; 50%-602 601 49400 99 103.02 Maintenance Labor 7,000 100%-601 601 49400 01 203.00 Printed Forms&Paper 2,260 1,742 2,075 2,000 2,200 Inserts&Water Bill Statements 601 49400 01 209.00 Other Office Supplies 749 1,459 186 200 200 601 49400 01 216.00 Chemicals&Chemical Products 66,610 58,454 51,562 70,000 70,000 Chlorine,Flouride,Polyphos 601 49400 01 219.00 Other Operating Supplies 97 331 250 200 300 Maintenance Supplies 601 49400 01 220.00 Water Meter Purchases 105,000 Meters,MIU's&CU Horns 601 49400 01 220.01 For Replacements 0 43,441 13,930 45,000 60,000 New Meter Standards 601 49400 01 220.02 For New Homes 46,600 61,704 68,837 68,000 45,000 From Water Rate Model 601 49400 01 224.00 Street Maintenance Materials 637 0 0 2,500 2,500 Patching for Breaks 601 49400 01 225.00 Landscaping Materials 208 845 0 500 500 Topsoil,Seed&Sod 601 49400 01 228.00 Meter Repair Materials 0 29 490 0 0 601 49400 01 229.00 Other Maintenance Supplies 24,000 601 49400 01 229.01 Supplies for Hydrants 4,599 3,332 6,622 6,000 6,000 601 49400 01 229.02 Curb Shutoffs 1,097 565 653 1,000 1,000 601 49400 01 229.03 GV Repair/Replacement 2,574 0 11,973 2,200 12,000 Repairs Done By City Staff 601 49400 01 229.04 Miscellaneous Supplies 4,438 3,355 2,581 5,000 5,000 601 49400 01 241.00 Small Tools 1,792 614 702 2,000 2,000 Wrenches,Shovels,etc. 601 49400 01 242.00 Minor Equipment 609 2,860 2,966 3,000 3,000 601 49400 01 303.00 Engineering Fees 45.000 601 49400 01 303.01 WHPP 474 0 0 5,000 5,000 Groundwater Plan Implementation 601 49400 01 303.02 GIS 2,539 516 4,607 5,000 5,000 601 49400 01 303.03 Rate Study 0 0 0 0 15,000 Part of Comp Plan Update 601 49400 01 303.04 Miscellaneous Fees 28,450 20,093 29,118 20,000 20,000 601 49400 01 304.00 Legal Fees 1,269 0 0 1,000 1,000 601 49400 01 310.00 Testing Services 47.000 601 49400 01 310.01 Bacteria&Water Quality 1,560 1,585 1,560 2,500 2.000 Radon,Tri-Chl.,Pesticides,Etc. 601 49400 01 310.02 V.O.C.,Pesticides,etc. 0 0 0 0 0 601 49400 01 310.03 MOH Service Connection Fee 41,623 43,149 43,552 44,000 45,000 $6.36/Connection-Annual Fee 601 49400 01 312.00 Gopher State One-Call 2,559 2,303 2,770 2,500 2,500 $7500 split 3 ways 601 49400 01 313.00 Temporary Service Fees 6,190 0 0 0 0 601 49400 01 318.00 Contract Engineer 8,000 10,000 12,000 25,000 0 601 49400 01 319.00 Other Professional Services 23,100 601 49400 01 319.01 Thaw Pipes,Check Leaks,etc. 311 0 32,250 1,500 1,500 601 49400 01 319.02 Supervisory Controls 910 15,648 6,562 5,000 5,000 SCADA 601 49400 01 319.03 Hazardous Chemical Permits 725 725 725 1,000 1,000 MN Department of Public Safety 601 49400 01 319.06 Contracted Hydrant Painting 9,922 10,004 10,120 10,000 10,000 120 Hydrants/Yr($82 each) 601 49400 01 319.07 Antenna Expenses 0 12,563 19,904 0 0 601 49400 01 319.08 Buxton Project 0 0 5,556 5,600 5,600 601 49400 01 320.00 Credit Card Activity Fees 0 3,324 5,372 3,000 6,000 1/3 Cost of C/C Pymt Processing 601 49400 01 321.00 Telephone Costs 2,646 2,745 3,003 3,000 3,500 Cell Phones,Modesm,GPS 601 49400 01 322.00 Postage Costs 4,678 4,556 4,173 5,000 5,000 Billings with Inserts 601 49400 01 323.00 Radio Units 1,116 1,045 1,367 1,500 1,500 24 Units'$300(Split 5 Ways) -601-49400-81 252-00 78 0 0 0 0 601 49400 01 365.00 Workers Comp Insurance 6,807 6,990 7,095 7,000 7,000 Water's Share of Premiums 601 49400 01 369.00 Other Insurance 10,746 6,181 6,048 12,000 12,000 Water's Share of Premiums 601 49400 01 391.00 P.C.Maintenance 2,900 601 49400 01 391.01 U/B Software Maintenance 1,827 2,081 2,074 2,000 2,200 Added to Utility Budgets in 2012 601 49400 01 391.02 Auto Read Software Support 585 585 578 700 700 Added to Utility Budgets in 2012 601 49400 01 392.00 P.C.Accessories&Supplies 0 0 0 200 200 601 49400 01 393.00 P.C.Hardware Purchases 1,637 4,093 1,707 12,000 2.000 601 49400 01 394.00 P.C.Software Purchases 7,200 601 49400 01 394.01 Licensing&Maintenance 4,843 4,279 4,371 6,200 6,200 Cartegraph,GIS 601 49400 01 394.02 Online Subscriptions 308 286 379 800 800 Pictometry 601 49400 01 394.03 New Software Purchases 7,868 2,271 0 200 200 601 49400 01 395.00 P.C.Repairs 0 0 0 0 0 PAGE TOTALS 705,356 772,524 820,530 838,400 867,200 Page Two 2016 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES- April 14,2015 2016 2015 Object 2016 2012 2013 2014 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 49400 01 403.00 Contracted R&M-Other lmpr 22,113 30,845 23,576 30,000 30,000 Main Breaks,Gate Valves,Etc. 601 49400 01 416.00 Machinery Rental 0 0 0 0 0 601 49400 01 433.00 Dues&Subscriptions 73 25 0 200 400 Suburban Utility Supt Assn,MRWA 601 49400 01 435.00 Books&Pamphlets 23 0 0 200 200 Reference Materials 601 49400 01 437.00 Conferences&Seminars 4,300 601 49400 01 437.01 MDH Training(Water School) 755 816 1,459 1,500 2,000 Operator Licensure 601 49400 01 437.02 AWWA Conference 0 0 0 0 0 601 49400 01 437.03 CarteGraph,ESRI,GIS 270 370 126 1,300 1,300 User Group,Conference,Training 601 49400 01 437.04 Miscellaneous Training 0 0 9 1,000 1,000 601 49400 01 439.00 Other Miscellaneous Charges 16,646 14,627 13,460 45,000 45,000 DNR Annual Water Use 601 49400 01 521.00 Building&Structure Purchases 0 0 0 10,000 10,000 Pymt on P.W.Building(17 of 20) 601 49400 01 530.00 Improvements Other Than Bldgs 345,600 601 49400 01 530.01 Well Inspections 560 490 560 600 600 601 49400 01 530.02 Miscellaneous Improvements 1,050 0 0 5,000 5,000 601 49400 01 530.03 CRP of Watermain 0 0 0 150,000 150,000 Annual Pavement Management 601 49400 01 530.04 Inspection&Maintenance 20,000 0 0 320,000 190.000 From Long-Term Project Schedule 601 49400 01 570.00 Office Equipment Purchases 58 107 0 1,000 500 601 49400 01 611.00 Interest on Lease Payments 2,893 2,538 2,167 0 0 P.W.Building Expansion(See 521) 601 49400 01 710.00 Transfers 200,000 139,194 4,796 0 0 Transfers for Other Improvements 601-49400-01 TOTALS 969,797 961,537 866,683 1,404,200 1,303,200 601 49406 01 221.00 Equipment Parts 0 0 2,762 500 500 601 49406 01 223.00 Building Repair Supplies 0 0 7,250 200 200 601 49406 01 319.00 Other Professional Services 0 0 2,352 1,000 1,000 601 49406 01 381.00 Electric Utilities 995 1,045 1,083 1,300 1,300 Pumping&Lighting TOTAL-PRV 995 1,045 13,448 3,000 3,000 601 49407 01 221.00 Equipment Parts 5,968 1,401 0 1,500 1,500 601 49407 01 223.00 Building Repair Supplies 0 0 8 200 200 601 49407 01 319.00 Other Professional Services 0 0 0 0 0 601 49407 01 321.00 Telephone Costs 211 211 211 300 300 601 49407 01 381.00 Electric Utilities 21,934 23,667 23,142 33,000 33,000 Pumping,Lighting,Tower Mixer 601 49407 01 409.00 Other Contracted Repairs&Maint 0 6,000 11,781 2,000 2,000 $800 for Lights in 2015 601 49407 01 439.00 Other Miscellaneous Charges 0 37 0 100 100 Contingencies -604-49407-04 534.00 101 0 0 0 0 TOTAL-WELL#7 28,213 31,316 35,142 37,100 37,100 601 49408 01 221.00 Equipment Parts 2,024 1,342 242 1,500 1,500 601 49408 01 223.00 Building Repair Supplies 15 0 106 200 200 601 49408 01 319.00 Other Professional Services 0 0 0 0 0 601 49408 01 381.00 Electric Utilities 21,917 23,841 21,542 25,000 25,000 Pumping&Lighting 601 49408 01 383.00 Gas Utilities 428 470 592 600 600 Heat Only 601 49408 01 409.00 Other Contracted Repairs&Maint 0 5,952 27,330 2,000 2,000 $800 for Lights in 2015 601 49408 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49408 01 530-00 T#an-Bldgs 0 0 0 0 0 - - TOTAL-WELL#8 24,385 31,605 49,812 29,400 29,400 601 49409 01 221.00 Equipment Parts 3,955 2,831 2,569 1,500 1,500 601 49409 01 223.00 Building Repair Supplies 0 0 0 200 200 601 49409 01 319.00 Other Professional Services 0 0 0 0 0 601 49409 01 381.00 Electric Utilities 25,692 16,618 31,854 30,000 32,000 Pumping&Lighting 601 49409 01 383.00 Gas Utilities 627 795 901 1,500 1,500 Heat Only 601 49409 01 409.00 Other Contracted Repairs&Maint 0 837 335 2,000 2,000 $800 for Lights in 2015 601 49409 01 439.00 Other Miscellaneous Charges 259 0 0 100 100 Contingencies 601 49409 01 530-00 lmprovement6 Other Than Bld ge 1-04 21,907 0 0 0 TOTAL-WELL#9 30,633 42,988 35,659 35,300 37,300 Page Three 2016 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES- April 14,2015 2016 2015 Object 2016 2012 2013 2014 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 49410 01 219.00 Other Operating Supplies 1 0 0 500 500 601 49410 01 221.00 Equipment Parts 1,062 4,434 0 1,000 1,000 601 49410 01 223.00 Building Repair Supplies 0 213 15 200 200 601 19110 01 3.a140 Tele stns 765 765 765 0 0 Removed Phone Line in 2013 601 49410 01 381.00 Electric Utilities 13,189 16,623 13,223 17,000 17,000 Pumping&Lighting 601 49410 01 409.00 Other Contracted Repairs&Maint 1,703 9,957 1,748 2,000 2,000 $800 for Lights in 2015 601 49410 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 19110 01 53040 Improvements Other Than 1414gs 0 10,014 0 0 0 - TOTAL-WELL#10 16,720 42,005 15,751 20,800 20,800 Rural Water System 601 49411 01 221.00 Equipment Parts 0 0 0 0 0 601 49411 01 439.00 Other Miscellaneous Charges 0 0 0 0 0 TOTAL-WELL#11 0 0 0 0 0 Rural Water System(#2) 601 49412 01 221.00 Equipment Parts 1,847 0 0 1,500 1,500 601 49412 01 223.00 Building Repair Supplies 10 0 0 200 200 601 49412 01 319.00 Other Professional Services 0 0 0 0 0 601 49412 01 381.00 Electric Utilities 22,444 23,242 21,696 30,000 28.000 Pumping&Lighting 601 49412 01 409.00 Other Contracted Repairs&Maint 278 1,495 8,317 2,000 2,000 $800 for Lights in 2015 601 49412 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies TOTAL-WELL#12 24,578 24,737 30,013 33,800 31,800 601 49414 01 221.00 Equipment Parts 1,063 0 161 1,500 1,500 601 49414 01 223.00 Building Repair Supplies 0 0 408 200 200 601 49414 01 319.00 Other Professional Services 1,097 0 384 1,000 1,000 601 49414 01 381.00 Electric Utilities 24,193 27,051 23,382 30,000 28,000 Pumping&Lighting 601 49414 01 409.00 Other Contracted Repairs&Maint 0 883 0 2,000 2,000 $800 for Lights in 2015 601 49414 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies £04 49a�a-01 500-00 ' •• _ 0 0 0 0 0 TOTAL-WELL#14 26,353 27,934 24,335 34,800 32,800 601 49425 01 221.00 Equipment Parts 3,629 575 830 1,500 1,500 601 49425 01 223.00 Building Repair Supplies 0 0 0 200 200 601 49425 01 319.00 Other Professional Services 0 0 0 500 500 601 49425 01 381.00 Electric Utilities 23,461 26,071 24,817 30,000 28,000 Pumping&Lighting 601 49425 01 409.00 Other Contracted Repairs&Maint 0 1,526 430 2,000 2,000 $800 for Lights in 2015 601 49425 01 439.00 Other Miscellaneous Charges 185 0 0 100 100 Contingencies 601 19125 01 530-10 Improvements Other Than Q1dgs 0 0 0 0 0 TOTAL-WELL#15 27,276 28,172 26,077 34,300 32,300 601 49426 01 221.00 Equipment Parts 0 0 0 1,500 1,500 601 49426 01 223.00 Building Repair Supplies 0 0 0 200 200 601 49426 01 319.00 Other Professional Services 0 0 0 500 500 601 49426 01 381.00 Electric Utilities 0 0 0 30,000 28,000 Pumping&Lighting 601 49426 01 383.00 Gas Utilities 0 0 0 1,000 1,000 May Be Electric Only(TBD) 601 49426 01 409.00 Other Contracted Repairs&Maint 0 0 0 1,000 1,000 601 49426 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies -601-49426-94 530-00 - _ -.. - e . -• _ --- 0 0 0 0 0 - TOTAL-WELL#16 0 0 0 34,300 32,300 Page Four 2016 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES- April 14,2015 2016 2015 Object 2016 2012 2013 2014 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 49415 01 221.00 Equipment Parts 0 0 0 500 500 Touch-up Paint 601 49415 01 319.00 Other Professional Services 0 0 3,675 0 0 601 49415 01 409.00 Other Contracted Repairs&Maint 0 0 1,050 500 500 601 49415 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies 601 49115 01 530-00 -- - • • - e • _• _ --_ 0 0 0 0 0 TOTAL-WATER TOWER#1 0 0 4,725 1,200 1,200 (Chippendale Water Tower) 601 49416 01 221.00 Equipment Parts 0 12 101 500 500 Touch-up Paint 601 49416 01 319.00 Other Professional Services 0 0 0 0 0 Tower Inspection 601 49416 01 381.00 Electric Utilities 429 1,338 1,261 4,500 4,500 New Water Mixers in 2014 601 49416 01 409.00 Other Contracted Repairs&Maint 0 0 8,210 500 500 601 49416 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies 601 4941601 539-00 • - e -••-• - e •- -• _ --- 9 0 0 0 0 TOTAL-WATER TOWER#2 429 1,350 9,572 5,700 5,700 (Connemara Water Tower) 601 49417 01 221.00 Equipment Parts 0 0 206 500 500 601 49417 01 319.00 Other Professional Services 0 0 0 0 0 601 49417 01 381.00 Electric Utilities 5,345 5,374 4,760 6,000 6,000 601 49417 01 409.00 Other Contracted Repairs&Maint 0 0 14,700 500 500 601 49417 01 439.00 Other Miscellaneous Charges 0 96 0 200 200 Contingencies 601 49417 01 530--00 • - - -••-• - • • _ --- 9 0 0 0 0 TOTAL-WATER TOWER#4 5,345 5,470 19,666 7,200 7,200 (Bacardi Water Tower) 601 49418 01 221.00 Equipment Parts 0 0 0 500 500 601 49418 01 319.00 Other Professional Services 3,800 0 0 0 0 601 49418 01 381.00 Electric Utilities 1,885 3,359 2,768 4,000 4,000 New Water Mixers in 2014 601 49418 01 409.00 Other Contracted Repairs&Maint 792 519 15,500 500 500 601 49418 01 439.00 Other Miscellaneous Charges 28 0 0 200 200 Contingencies 601 49418 01 530-00 • - - -• • e •- _ --_ 0 0 0 0 0 TOTAL-WATER TOWER#3 6,505 3,878 18,268 5,200 5,200 (East Side Water Tower) GRAND TOTAL-ALL DEPTS. $1,161,229 $1,202,036 $1,149,152 $1,686,300 $1,579,300 -6.3% overall decrease 9.5% increase in salaries and benefits -12.1% decrease in operating budget Page One 2016 BUDGET WORKSHEETS SEWER UTILITY -EXPENDITURES- April 14,2015 2016 2015 Object 2016 2012 2013 2014 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 602 49450 101.00 Salaries&Benefits $475,600 Salary,Taxes,PERA&Benefits 602 49450 77 101.00 Administrative 120,762 117,498 117,386 115,100 144.300 602 49450 78 101.00 Technical/Clerical 144,154 142,778 151,671 153,100 160,800 602 49450 79 101.00 Maintenance 146,589 157,163 163,438 164,900 170,500 602 49450 xx 101.00 Salary&Benefit Contingency 0 0 0 0 0 602 49450 102.00 Full-Time Overtime 7,794 15,629 13,810 7,500 7,500 602 49450 103.00 Part-Time Salaries&Benefits 8,025 5,531 5,707 9,000 9,000 602 49450 99 103.01 Utility Commission Wages(50%) 1,000 50%-602; 50%-601 602 49450 99 103.02 Maintenance Labor 8,000 100%-602 602 49450 01 203.00 Printed Forms&Paper 1,499 1,613 1,416 1,500 1,500 Inserts&Water Bill Statements 602 49450 01 209.00 Other Office Supplies 227 899 172 200 200 602 49450 01 216.00 Chemicals&Chemical Products 0 0 0 500 500 Root Killer,Degreaser 602 49450 01 219.00 Other Operating Supplies 0 304 100 200 200 602 49450 01 224.00 Street Maintenance Materials 0 0 0 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 3,292 211 797 5,000 5,000 MH Castings Replacement Prog. 602 49450 01 241.00 Small Tools 802 165 237 500 500 Wrenches,Shovels,etc. 602 49450 01 242.00 Minor Equipment 414 2,990 3,746 3,000 3,000 602 49450 01 303.00 Engineering Fees 35,000 602 49450 01 303.01 GIS 2,539 516 4,607 5,000 5,000 602 49450 01 303.02 Rate Study 0 0 0 0 15.000 Part of Comp Plan Update 602 49450 01 303.04 Miscellaneous 2,395 7,402 2,846 15,000 15,000 Sewer System O&M Review 602 49450 01 304.00 Legal Fees 286 0 0 500 500 602 49450 01 312.00 Gopher State One-Call 2,559 2,303 2,770 2,500 2,500 $7500 split 3 ways 602 49450 01 313.00 Temporary Service Fees 0 0 0 0 0 602 49450 01 318.00 Contract Engineer 8,000 10,000 12,000 25,000 0 602 49450 01 319.00 Other Professional Services 15,600 602 49450 01 319.01 Televising 531 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) 0 6,802 0 5,000 5,000 SCADA System 602 49450 01 319.04 Buxton Project 0 0 5,556 5,600 5,600 602 49450 01 320.00 Credit Card Activity Fees 0 3,324 5,372 3,000 6,000 1/3 Cost of C/C Pymt Processing 602 49450 01 321.00 Telephone Costs 2,646 2,745 3,001 3,000 3,500 Cell Phones,Modems,GPS 602 49450 01 322.00 Postage Costs 4,678 4,556 4,173 5,000 5,000 Billings with Inserts 602 49450 01 323.00 Radio Units 1,116 1,045 1,367 1,500 1,500 24 Units*$300(Split 5 Ways) 602 49450 01 365.00 Workers Comp Insurance 6,828 7,011 7,117 7,000 7,000 Sewer's Share of Premiums 602 49450 01 369.00 Other Insurance 6,443 10,777 12,067 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 1,827 2,081 2,074 2,000 2,200 Added to Utility Budgets in 2012 602 49450 01 391.02 Auto Read Software Support 585 585 578 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 1,362 4,093 1,600 12,000 2,000 !• -_ _ _ 602 49450 01 394.00 P.C.Software Purchases 7,200 602 49450 01 394.01 Licensing&Maintenance 4,779 4,279 4,371 6,200 6,200 Cartegraph,GIS 602 49450 01 394.02 Online Subscriptions 308 286 379 800 800 Pictometry 602 49450 01 394.03 New Software Purchases 7,772 2,271 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 3,533 2,581 63 5,000 5,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 50 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) 90 1,646 669 1,500 1,500 Operator Licensure$300 each(M) 602 49450 01 437.02 Collection System Conference 1,310 0 0 0 0 Duplicate of Sewer School 437.01 602 49450 01 437.03 CarteGraph,ESRI,GIS 270 120 126 1,300 1,300 User Group,Conference,Training 602 49450 01 437.04 Miscellaneous Training 0 0 0 1,000 1,000 602 49450 01 439.00 Other Miscellaneous Charges 153 148 145 100 100 Contingencies 602 49450 01 521.00 Building&Structure Purchases 0 0 0 10,000 10,000 Pymt on P.W.Building(16 of 20) 602 49450 01 530.00 Improvements Other Than Bldgs 160,000 602 49450 01 530.01 Miscellaneous Improvements 0 31 0 10,000 10,000 SCADA Reconfiguration,PCL's -602-49450-9 F 63Q 02 9 9 9 A 9 602 49450 01 530.03 CRP of Sewermain 0 0 0 150,000 150,000 Annual Pavement Management 602 19150 01639-A4 0 0 0 0 0 602 49450 01 540.00 Heavy Machinery Purchases 0 0 189,190 0 0 602 49450 01 560.00 Furniture&Fixture Purchases 0 0 0 500 500 602 49450 01 570.00 Office Equipment Purchases 0 0 0 500 500 PAGE TOTALS 493,620 519,385 718,548 763,700 789,900 Page Two 2016 BUDGET WORKSHEETS SEWER UTILITY -EXPENDITURES- April 14,2015 2016 2015 Object 2016 2012 2013 2014 Adopted Detail Proposed Account* Description Actual Actual Actual Budget Amount Budget Comments 602 49450 01 602.00 Sewer Service Charges 940,900 1,007,195 1,090,261 1,080,000 1,185,400 MWCC Charges 602 49450 01 611.00 Interest on Lease Payments 2,893 2,538 2,165 0 0 P.W.Building Expansion(See 521) 602 49450 01 710.00 Transfers 10,493 116,948 2,405 0 0 Transfers for Other Improvements 602-49450-01 TOTALS 1,447,906 1,646,066 1,813,379 1,843,700 1,975,300 602 49451 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49451 01 221.00 Equipment Parts 21 0 0 800 800 602 49451 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49451 01 303.00 Engineering Fees 0 0 0 0 0 602 49451 01 381.00 Electric Utilities 925 915 916 1,500 1,500 602 49451 01 403.00 Contracted R&M-Other Impr 0 0 775 200 45.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 947 915 '1,691 2,900 47,700 602 49452 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49452 01 221.00 Equipment Parts 59 1,060 0 800 800 602 49452 01 229.00 Other Maintenance Supplies 0 0 0 200 200 -602-49452-94 321,00 Telephene-Casts 105 0 0 0 0 602 49452 01 381.00 Electric Utilities 554 630 623 700 700 602 49452 01 403.00 Contracted R&M-Other Impr 0 0 0 200 200 602 49452 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Bloomfield 5th) TOTAL-LIFT STATION#7 719 1,691 623 2,100 2,100 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,578 3,753 3,548 4,000 4,000 602 49453 01 403.00 Contracted R&M-Other Impr 230 0 7,395 200 200 602 49453 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Shannon Pond) TOTAL-LIFT STATION#3 3,808 3,753 10,942 5,400 5,400 602 49454 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49454 01 221.00 Equipment Parts 2,001 167 6 800 800 602 49454 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49454 01 381.00 Electric Utilities 5,377 4,602 4,821 6,000 6,000 602 49454 01 403.00 Contracted R&M-Other Impr 0 1,582 0 2,000 2,000 602 49454 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Hawkins) TOTAL-LIFT STATION#4 7,377 6,351 4,827 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 0 1,800 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,879 5,569 5,802 6,000 6,000 602 49455 01 403.00 Contracted R&M-Other Impr 0 0 415 200 200 602 49455 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (LeForet Add'n) TOTAL-LIFT STATION#5 5,879 5,569 8,016 7,400 7,400 602 49456 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49456 01 221.00 Equipment Parts 4,247 2,385 0 800 800 602 49456 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49456 01 381.00 Electric Utilities 3,788 6,001 8,270 6,000 6,000 602 49456 01 403.00 Contracted R&M-Other Impr 0 0 0 200 200 wades 602 49456 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Drumcliffe) TOTAL-LIFT STATION#6 8,035 8,385 8,270 7,400 7,400 Page Three 2016 BUDGET WORKSHEETS SEWER UTILITY -EXPENDITURES- April 14,2015 2016 2015 Object 2016 2012 2013 2014 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,176 1,278 857 1,200 1,200 602 49457 01 403.00 Contracted R&M-Other Impr 0 0 0 200 200 602 49457 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Glendalough 5th) TOTAL-LIFT STATION#9 1,176 1,278 857 2,300 2,300 602 49458 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49458 01 221.00 Equipment Parts 353 1,269 0 500 500 602 49458 01 229.00 Other Maintenance Supplies 0 0 0 200 200 - 602 49458 01 381.00 Electric Utilities 522 633 629 800 800 602 49458 01 403.00 Contracted R&M-Other Impr 0 0 0 200 200 602 49458 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Meadows of) TOTAL-LIFT STATION#8 875 1,902 629 1,900 1,900 (Bloomfield) 602 49460 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49460 01 221.00 Equipment Parts 294 725 0 500 500 602 49460 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49460 01 381.00 Electric Utilities 251 252 261 400 400 602 49460 01 403.00 Contracted R&M-Other Impr 0 0 0 200 200 602 49460 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Glen Rose) TOTAL-LIFT STATION#10 545 977 261 1,500 1,500 GRAND TOTAL-ALLDEPTS. $1,477,266 $1,676,886 $1,849,496 $1,883,800 $2,060,200 9.4% overall increase 9.5% increase in salaries and benefits 9.3% increase in operating budget Page One 2016 BUDGET WORKSHEETS STORM WATER UTILITY -EXPENDITURES- April 14,2015 2016 2015 Object 2016 2012 2013 2014 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 603 49500 101.00 Salaries&Benefits $214,800 Salary,Taxes,PERA&Benefits 603 49500 77 101.00 Administrative 4,036 10,586 10,932 11,200 39,400 603 49500 78 101.00 Technical/Clerical 88,359 80,607 85,598 84,300 88,400 603 49500 79 101.00 Maintenance 73,294 78,581 81,718 84,200 87,000 603 49500 xx 101.00 Salary&Benefit Contingency 0 0 0 0 0 603 49500 102.00 Full-Time Overtime 3,958 7,836 6,918 6,000 6,000 603 49500 99 103.00 Part-Time Salaries&Benefits 6,824 5,157 4,323 8,000 8,000 603 49500 01 203.00 Printed Forms&Paper 1,726 1,613 1,416 1,500 1,500 603 49500 01 204.00 Envelopes&Letterhead 0 0 0 0 0 603 49500 01 208.00 Miscellaneous Supplies 352 1,090 0 500 500 Stakes,Ribbons,Level,etc. 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 1,199 515 1,505 2,000 2,000 Patching Material for Washouts 603 49500 01 225.00 Landscaping Materials 4,000 603 49500 01 225.01 Rip-Rap,Matting,Rock,etc. 1,386 898 1,868 2,000 2,000 603 49500 01 225.02 Black Dirt,Seed,Sod,etc. 1,370 150 150 2,000 2,000 603 49500 01 226.00 Sign Repair Materials 0 0 0 500 500 603 49500 01 230.00 Equipment Repair Material 881 1,754 1,018 1,000 1,000 603 49500 01 241.00 Small Tools 87 349 627 1,000 1,000 603 49500 01 242.00 Minor Equipment 221 2,659 1,567 2,000 2,000 Misc.Nozzles for Vac Truck 603 49500 01 303.00 Engineering Fees 135,000 603 49500 01 303.01 Problem Area Investigations 3,501 79 0 10,000 10,000 603 49500 01 303.02 NPDES Phase II 29,749 14,115 68,996 30,000 40,000 603 49500 01 303.03 CSMP Update 36 4,850 2,535 0 50,000 Part of Comp Plan Update 603 49500 01 303.04 Miscellaneous 4,186 14,108 5,265 30,000 20,000 603 49500 01 303.05 GIS 1,672 344 3,071 5,000 5,000 603 49500 01 303.06 MS4 Services 10,000 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 0 169 2,500 2,500 $7500 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) 3,850 4,815 4,815 5,000 5,000 Wetland Health&Evaluation Proj 603 49500 01 318.00 Contract Engineer 8,000 10,000 12,000 25,000 0 603 49500 01 319.00 Other Professional Services 0 6,802 10,600 603 49500 01 319.01 SCADA 0 0 0 5,000 5,000 603 49500 01 319.02 Buxton Project 0 0 5,556 5,600 5,600 603 49500 01 320.00 Credit Card Activity Fees 0 3,324 5,372 3,000 6,000 1/3 Cost of C/C Pymt Processing 603 49500 01 321.00 Telephone Costs 2,647 2,745 3,002 3,000 3.500 Cell Phones,Modems,GPS 603 49500 01 322.00 Postage Costs 4,678 4,556 4,173 5,000 5,000 Billings&Info Mailings 603 49500 01 323.00 Radio Units 1,116 1,045 1,367 1,500 1,500 24 Units*$300(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,654 2,925 2,992 3,500 3,500 Storm Water's Share of Premiums 603 49500 01 369.00 Other Insurance 2,362 1,278 1,316 4,000 4,000 Storm Water's Share of Premiums -693-49599-04 38409 Refuse-Disposal 0 0 0 0 0 40349400-04 38999 9 0 0 9 9 603 49500 01 391.00 P.C.Maintenance 2,900 603 49500 01 391.01 U/B Software Maintenance 1,827 2,081 2,074 2,000 2,200 Added to Utility Budgets in 2012 603 49500 01 391.02 Auto Read Software Support 585 585 578 700 700 Added to Utility Budgets in 2012 603 49500 01 393.00 P.C.Hardware Purchases 1,362 4,093 1,600 12,000 2,000 !• -_ _ 603 49500 01 394.00 P.C.Software Purchases 7,200 603 49500 01 394.01 Licensing&Maintenance 4,779 4,279 4,371 6,200 6,200 Cartegraph,GIS 603 49500 01 394.02 Online Subscriptions 308 286 379 800 800 Pictometry 603 49500 01 394.03 New Software Purchases 7,772 2,271 0 200 200 603 49500 01 403.00 Contracted R&M-Other lmpr 78,000 603 49500 01 403.01 Ditching 0 4,330 8,344 5,000 8,000 603 49500 01 403.02 Miscellaneous Repairs 17,830 32,838 117,136 50,000 60,000 Catch Basins,Manholes,Etc. 603 49500 01 403.03 Pond Inspection&Maintenance 0 0 0 10,000 10,000 603 49500 01 416.00 Machinery Rental 0 64 0 4,000 4,000 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 0 500 500 Utility Information 603 49500 01 437.00 Conferences&Seminars 3,500 603 49500 01 437.01 Storm Water Management 965 112 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 270 120 126 1,300 1,300 User Group,Conference,Training 603 49500 01 437.05 Miscellaneous Training 0 0 0 1,000 1,000 603 49500 01 439.00 Other Miscellaneous Charges 153 908 145 0 0 603 49500 01 530.00 Improvements Other Than Bldgs 150,000 603 49500 01 530.01 CRP of Storm Sewer 597 6,523 0 150,000 150,000 Annual Pavement Management 603 49500 01 560.00 Furniture&Fixture Purchases 0 0 189,190 500 500 603 49500 01 580.00 Other Equipment Purchases 0 0 0 2,000 2,000 603 49500 01 586.00 Computer Equipment Purchases 0 0 0 500 500 PAGE TOTALS 284,731 321,410 642,351 596,400 673,200 Page Two 2016 BUDGET WORKSHEETS STORM WATER UTILITY -EXPENDITURES- April 14,2015 2016 2015 Object 2016 2012 2013 2014 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 603 49500 01 710.00 Transfers 51,000 603 49500 01 710.01 1/2 of 2011 P&I Payments(1996B) 0 0 0 0 0 Bonds Called 2/1/08 603 49500 01 710.02 1/2 of 2011 P&I Payments(1999C) 0 0 0 0 0 Bonds Called 2/1/08 603 49500 01 710.03 1/2 of 2011 P&I Payments(2001B) 0 0 0 0 0 Bonds Called 2/1/11 603 49500 01 710.04 1/2 of 2011 P&I Payments(2001D) 0 0 0 0 0 Bonds Paid off 2/1/08 603 49500 01 710.05 1/2 of 2011 P&I Payments(2002B) 0 0 0 0 0 Bonds Called 2/1/11 603 49500 01 710.06 1/2 of 2011 P&I Payments(2010A) 84,000 89,000 87,000 50,000 51,000 New Refunding Issue 12/10 603 49500 01 710.07 1/2 of 2011 P&I Payments(2003A) 0 0 0 0 0 Bonds Called 12/1/11 603 49500 01 710.10 Projects 68,296 81,225 123,395 0 0 603-49500-01 TOTALS 437,027 491,635 852,746 646,400 724,200 603 49511 01 221.00 Equipment Parts 0 410 0 500 500 603 49511 01 381.00 Electric Utilities 258 312 360 500 500 603 49511 01 403.00 Contracted Repair&Maintenance 0 0 278 1,000 1,000 (Copper Pond) TOTAL-LIFT STATION#1 258 722 638 2,000 2,000 603 49512 01 221.00 Equipment Parts 390 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 0 1,000 1,000 (Schwarz Pond) TOTAL-LIFT STATION#2 390 0 0 2,000 2,000 603 49513 01 221.00 Equipment Parts 0 0 0 500 500 603 49513 01 381.00 Electric Utilities 2,698 5,176 5,552 4,500 6,000 603 49513 01 403.00 Contracted Repair&Maintenance 0 0 0 1,000 1,000 (Birger Pond) TOTAL-LIFT STATION#3 2,698 5,176 5,552 6,000 7,500 603 49514 01 221.00 Equipment Parts 0 0 0 500 500 603 49514 01 381.00 Electric Utilities 947 1,500 2,067 2,000 2,500 603 49514 01 403.00 Contracted Repair&Maintenance 0 0 103 1,000 1,000 Alarm Upgrades (Marcotte Pond) TOTAL-LIFT STATION#4 947 1,500 2,170 3,500 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 0 1,000 1,000 Alarm Upgrades,SCADA,PLC (Hawkins Pond) TOTAL-LIFT STATION#5 0 0 0 2,000 2,000 603 49516 01 221.00 Equipment Parts 0 0 0 500 500 603 49516 01 381.00 Electric Utilities 460 449 473 500 500 603 49516 01 403.00 Contracted Repair&Maintenance 0 0 145 1,000 1,000 (Glendalough 7th) TOTAL-LIFT STATION#6 460 449 618 2,000 2,000 GRAND TOTAL-ALL DEPTS. $441,779 $499,484 $861,724 $663,900 $743,700 12.0% overall increase 18.1% increase in salaries and benefits 9.5% decrease in operating budget