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. 2018 Utility Budgets
EXECUTIVE SUMMARY Utility Commission Meeting: August 14, 2017 AGENDA SECTION: AGENDA ITEM: 2018 Utility Budgets New Business PREPARED BY: Christine Watson, Public Works Coordinator AGENDA NO. 6.b. ATTACHMENTS: Proposed 2018 Utility Budgets APPROVED BY: LJM RECOMMENDED ACTION: Motion to Recommend City Council Approval of the 2018 Utility Budgets BACKGROUND Attached for your consideration are the proposed 2018 budgets for water, sanitary sewer, and storm water. Public Works staff has worked to develop a proposed budget that meets the goals of the City Council while maintaining the expected service levels of the Quality Standards. Table 1 provides an overview of the increases to the three enterprise funds. Table 1 Fund 2017 Budget 2018 Proposed Budget Increase Water Utility $1,653,400 $2,363,500 43.0% Sewer Utility $2,202,000 $2,528,900 14.9% Storm Utility $1,285,400 $1,184,400 -7.9% Total $5,140,800 $6,076,800 18.2% The substantial increase to the Water Utility fund is primarily due to the planned painting of the Chippendale water tower. Without that $650,000 in the budget, the increase to the Water Utility fund would be 3.63%. The substantial increase to the Sewer Utility fund is primarily due to the planned installation of submersible pumps at Lift Station 4. Without that $210,000 in the budget, the increase to the Sewer Utility fund would be 5.31%. The decrease to the Storm Utility fund is primarily due to a reduction in the amount needed for equipment purchases ($91,700 in 2018 down from $157,000 in 2017). The redline version of each budget is included for your review. Staff will be available at the meeting to answer any questions or concerns. SUMMARY Staff is requesting Utility Commission recommendation to the City Council to approve the proposed 2018 Utility Budgets. Page One 2018 BUDGET WORKSHEETS WATER UTILITY - REVENUES - April 17, 2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 601 33425.00 Other State Grants & Aids $9,901 $0 $24,248 $4,500 $4,500 MCES Water Efficiency Grant 601 34108.00 Administrative Fees-Other Funds 3,931 6,828 8,168 0 6,300 5% of 5% Fees-Const Projects 601 34109.00 Other Gen'l Govt Chgs for Services 15,820 5,850 9,045 0 0 ______________________________ 601 36101.00 Principal - Special Assessments 56,217 54,299 98,164 57,000 57,000 ______________________________ 601 36102.00 Penalties & Interest - S/A (847)57 690 0 0 ______________________________ 601 36210.00 Interest Earnings - Investments 105,027 97,236 113,846 60,000 60,000 ______________________________ 601 36214.00 Net Change in FV-Investments 96,607 (5,138)(51,252)0 0 Annual Market Value Changes 601 36215.00 Interest Earnings 65 280 1,033 200 200 ______________________________ 601 36220.00 Rents & Royalties 107,624 158,580 142,237 148,500 148,500 Antenna Leases 601 36260.00 Other Revenues 0 0 126 0 0 ______________________________ 601 36265.00 Use of Reserve Funds 0 0 0 0 412,500 ______________________________ 601 37110.00 Residential Water Revenues 1,100,286 1,090,820 1,234,904 1,200,000 1,200,000 Est $6K Lost Rev from Rebate Prog. 601 37120.00 Apartment Water Revenues 84,079 94,071 109,567 100,000 100,000 ______________________________ 601 37125.00 Institutional Water Revenues 61,957 69,187 78,051 75,000 75,000 ______________________________ 601 37130.00 Commercial Water Revenues 79,817 81,477 86,107 85,000 85,000 ______________________________ 601 37140.00 Industrial Water Revenues 113,947 164,347 158,310 150,000 150,000 ______________________________ 601 37160.00 Penalties - Water Revenues 9,280 10,506 10,810 9,500 9,500 ______________________________ 601 37165.00 Meter Maint Water Revenues 0 0 0 0 0 ______________________________ 601 37170.00 Other Water Revenues 2,800 592 0 0 0 ______________________________ 601 37180.00 Water Meter Sales Revenue 37,385 49,058 52,736 45,000 55,000 Should Match Line 220.02 601 39103.00 Gain or Loss from F/A Disposal 0 (494)(249)0 0 ______________________________ 601 39203.00 Transfer From______________0 89,101 0 0 0 ______________________________ ---------------------------------------------------------------------------------------------------------- FUND TOTALS $1,883,897 $1,966,658 $2,076,542 $1,934,700 $2,363,500 ======================================================== Page One 2018 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - April 17, 2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 601 49400 101.00 Salaries & Benefits $522,800 Salary, Taxes, PERA & Benefits 601 49400 77 101.00 Administrative 117,387 139,529 153,689 178,300 175,500 ______________________________ 601 49400 78 101.00 Technical/Clerical 151,671 151,280 158,777 159,800 167,200 ______________________________ 601 49400 79 101.00 Maintenance 163,437 165,527 171,037 174,800 180,100 ______________________________ 601 49400 xx 101.00 Salary & Benefit Contingency 0 0 0 0 0 ______________________________ 601 49400 102.00 Full-Time Overtime 13,810 9,705 12,552 8,000 8,000 ______________________________ 601 49400 103.00 Part-Time Salaries & Benefits 6,508 5,132 8,081 7,000 7,000 ______________________________ 601 49400 99 103.01 Utility Commission Wages (50%)1,000 50% - 601; 50% - 602 601 49400 99 103.02 Maintenance Labor 6,000 100% - 601 601 49400 01 203.00 Printed Forms & Paper 2,075 1,005 1,067 2,200 2,200 Inserts & Water Bill Statements 601 49400 01 205.00 Plotter Ink and Paper 400 601 49400 01 209.00 Other Office Supplies 186 168 61 200 200 ______________________________ 601 49400 01 212.00 Motor Fuels 0 0 0 5,600 5,100 3% Covered by Water Utility 601 49400 01 216.00 Chemicals & Chemical Products 51,562 48,581 48,355 75,000 75,000 Chlorine/Flouride/Poly(Add Well 16) 601 49400 01 219.00 Other Operating Supplies 250 50 957 300 300 Maintenance Supplies 601 49400 01 220.00 Water Meter Purchases 120,000 Meters, MIU's & CU Horns 601 49400 01 220.01 For Replacements 13,930 16,142 87,771 62,500 65,000 From Water Rate Model 601 49400 01 220.02 For New Homes 68,837 74,982 58,843 45,000 55,000 From Water Rate Model 601 49400 01 224.00 Street Maintenance Materials 0 640 2,285 2,500 2,500 Patching for Breaks 601 49400 01 225.00 Landscaping Materials 0 60 1,103 500 1,000 Topsoil, Seed & Sod 601 49400 01 228.00 Meter Repair Materials 490 0 90 0 0 ______________________________ 601 49400 01 229.00 Other Maintenance Supplies 15,000 ______________________________ 601 49400 01 229.01 Supplies for Hydrants 6,622 8,619 5,840 8,000 8,000 ______________________________ 601 49400 01 229.02 Curb Shutoffs 653 252 135 1,000 1,000 ______________________________ 601 49400 01 229.03 GV Repair/Replacement 11,973 303 1,513 12,000 2,000 Repairs Done By City Staff 601 49400 01 229.04 Miscellaneous Supplies 2,581 2,074 933 5,000 4,000 ______________________________ 601 49400 01 241.00 Small Tools 702 626 1,432 2,000 2,000 Wrenches, Shovels, etc. 601 49400 01 242.00 Minor Equipment 2,966 5,113 3,543 12,000 8,000 Hydrant tools 2017, trailer 2018 601 49400 01 303.00 Engineering Fees 78,000 ______________________________ 601 49400 01 303.01 WHPP 0 0 0 5,000 5,000 Groundwater Plan Implementation 601 49400 01 303.02 GIS 4,607 3,413 1,920 3,000 3,000 Reduce Due to In-House Engineer 601 49400 01 303.03 Rate Study 0 0 3,900 15,000 15,000 Part of Comp Plan Update 601 49400 01 303.04 Miscellaneous Fees 29,118 68,392 32,177 55,000 55,000 Water Facility Study in '17 ($50K) 601 49400 01 304.00 Legal Fees 0 0 0 1,000 1,000 ______________________________ 601 49400 01 310.00 Testing Services 48,000 ______________________________ 601 49400 01 310.01 Bacteria & Water Quality 1,560 1,966 1,516 2,000 2,000 Radon, Tri-Chl., Pesticides, Etc. 601 49400 01 310.03 MDH Service Connection Fee 43,552 44,475 45,167 45,000 46,000 $6.36/Connection -Annual Fee 601 49400 01 312.00 Gopher State One-Call 2,770 1,655 1,602 2,500 2,500 $7,500 Split 3 Ways 601 49400 01 318.00 Contract Engineer 12,000 6,250 16,174 0 0 ______________________________ 601 49400 01 319.00 Other Professional Services 27,500 ______________________________ 601 49400 01 319.01 Thaw Pipes, Check Leaks, etc.32,250 0 0 1,500 1,500 ______________________________ 601 49400 01 319.02 Supervisory Controls 6,562 3,575 4,483 12,500 5,000 SCADA, Loggers $7500 in 2017 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 10,120 10,028 10,028 11,000 11,000 110 Hydrants / Yr ($92 each) 601 49400 01 319.07 Antenna Expenses 19,904 15,458 7,621 0 0 ______________________________ 601 49400 01 319.08 Buxton Project 5,556 5,556 0 0 0 ______________________________ 601 49400 01 319.09 HVAC Maintenance Contract 0 0 0 4,000 4,000 Annual Insp/Maint, All Wells 601 49400 01 319.10 Landscape Maintenance 4,000 ______________________________ 601 49400 01 319.11 Pest Control 1,000 ______________________________ 601 49400 01 320.00 Credit Card Activity Fees 5,372 6,797 6,097 7,000 7,000 1/3 Cost of C/C Pymt Processing 601 49400 01 321.00 Telephone Costs 3,003 3,122 3,451 3,500 3,500 Cell Phones, Modesm, GPS 601 49400 01 322.00 Postage Costs 4,173 4,296 4,315 5,000 5,000 Billings with Inserts 601 49400 01 323.00 Radio Units 1,367 1,120 1,390 5,100 5,100 (24x$300)(12x$1500)(Split 5 Ways) 601 49400 01 352.00 General Notices & Public Info 0 0 30 0 0 ______________________________ 601 49400 01 365.00 Workers Comp Insurance 7,095 8,338 10,058 7,000 12,000 Water's Share of Premiums 601 49400 01 369.00 Other Insurance 6,048 6,132 6,382 6,500 7,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 2,074 2,074 2,117 2,200 2,200 Added to Utility Budgets in 2012 601 49400 01 391.02 Auto Read Software Support 578 595 613 700 700 Added to Utility Budgets in 2012 601 49400 01 392.00 P.C. Accessories & Supplies 0 40 0 200 200 ______________________________ 601 49400 01 393.00 P.C. Hardware Purchases 1,707 9,199 1,306 2,000 2,000 ______________________________ 601 49400 01 394.00 P.C. Software Purchases 8,900 ______________________________ 601 49400 01 394.01 Licensing & Maintenance 4,371 4,591 4,629 15,000 8,400 ESRI, Cartegraph 601 49400 01 394.02 Online Subscriptions 379 379 0 800 300 Pictometry 601 49400 01 394.03 New Software Purchases 0 0 0 200 200 ______________________________ ---------------------------------------------------------------------------------------------------------- PAGE TOTALS 820,530 837,962 883,765 975,400 980,100 Page Two 2018 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - April 17, 2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 601 49400 01 403.00 Contracted R & M - Other Impr 23,576 23,397 59,309 30,000 50,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 0 187 250 400 400 Suburban Utility Supt Assn, MRWA 601 49400 01 435.00 Books & Pamphlets 0 0 0 200 200 Reference Materials 601 49400 01 437.00 Conferences & Seminars 6,000 ______________________________ 601 49400 01 437.01 MDH Training (Water School)1,459 2,161 436 2,500 3,000 Operator Licensure 601 49400 01 437.02 AWWA Conference 0 0 0 1,200 1,200 Duluth, Send 2 Staff 601 49400 01 437.03 CarteGraph, ESRI, GIS 126 0 81 1,000 800 User Group, Conference, Training 601 49400 01 437.04 Miscellaneous Training 9 849 928 1,000 1,000 ______________________________ 601 49400 01 439.00 Other Miscellaneous Charges 13,460 13,459 16,057 45,000 45,000 DNR Annual Water Use 601 49400 01 450.00 Sales Tax on Purchases 0 2,699 0 0 0 ______________________________ 601 49400 01 521.00 Building & Structure Purchases 0 0 0 10,000 10,000 Pymt on P.W. Building (20 of 20) 601 49400 01 530.00 Improvements Other Than Bldgs 915,600 ______________________________ 601 49400 01 530.01 Well Inspections 560 0 800 600 600 ______________________________ 601 49400 01 530.02 Miscellaneous Improvements 0 405 63,720 5,000 150,000 Investigate and Seal Wells 1 & 2 601 49400 01 530.03 CRP of Watermain 0 0 0 150,000 50,000 PMP Water Imp When Needed 601 49400 01 530.04 Inspection & Maintenance 0 259,255 49,361 65,000 715,000 From Long-Term Plan 601 49400 01 540.00 Heavy Machinery Purchases 0 0 0 0 0 Equipment Purchases - Match CIP 601 49400 01 550.00 Motor Vehicle Purchases 0 0 0 10,000 52,000 Equipment Purchases - Match CIP 601 49400 01 570.00 Office Equipment Purchases 0 0 0 500 500 ______________________________ 601 49400 01 580.00 Other Equipment Purchases 0 0 0 7,000 16,600 Trash Pump (Split with 602, 603) 601 49400 01 611.00 Interest on Lease Payments 2,167 1,773 1,362 0 0 P.W. Building Expansion(See 521) 601 49400 01 710.00 Transfers 4,796 0 181,450 0 0 Transfers for Other Improvements ---------------------------------------------------------------------------------------------------------- 601-49400-01 TOTALS 866,683 1,142,148 1,257,519 1,304,800 2,076,400 601 49406 01 221.00 Equipment Parts 2,762 0 0 13,000 1,500 SCADA Upgrades 601 49406 01 223.00 Building Repair Supplies 7,250 0 0 200 200 ______________________________ 601 49406 01 319.00 Other Professional Services 2,352 5,862 491 1,000 1,000 ______________________________ 601 49406 01 381.00 Electric Utilities 1,083 1,147 1,197 1,300 1,300 Pumping & Lighting ---------------------------------------------------------------------------------------------------------- TOTAL - PRV 13,448 7,009 1,688 15,500 4,000 601 49407 01 221.00 Equipment Parts 0 409 0 1,500 1,500 ______________________________ 601 49407 01 223.00 Building Repair Supplies 8 0 98 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 23,142 20,778 22,695 33,000 33,000 Pumping, Lighting, Tower Mixer 601 49407 01 409.00 Other Contracted Repairs & Maint 11,781 1,429 404 2,000 2,000 $800 for Lights in 2015 601 49407 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49407 01 530.00 Improvements Other Than Bldgs 0 0 0 60,000 10,000 Controls in '17, Landscape in '18 ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #7 35,142 22,826 23,408 97,100 47,100 601 49408 01 221.00 Equipment Parts 242 25 0 1,500 1,500 ______________________________ 601 49408 01 223.00 Building Repair Supplies 106 19 0 200 200 ______________________________ 601 49408 01 319.00 Other Professional Services 0 0 0 0 0 ______________________________ 601 49408 01 381.00 Electric Utilities 21,542 20,456 22,293 25,000 25,000 Pumping & Lighting 601 49408 01 383.00 Gas Utilities 592 497 355 600 600 Heat Only 601 49408 01 409.00 Other Contracted Repairs & Maint 27,330 735 5,862 2,000 2,000 $800 for Lights in 2015 601 49408 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #8 49,812 21,732 28,510 29,400 29,400 601 49409 01 221.00 Equipment Parts 2,569 0 0 1,500 1,500 ______________________________ 601 49409 01 223.00 Building Repair Supplies 0 109 84 200 200 ______________________________ 601 49409 01 319.00 Other Professional Services 0 0 0 0 0 ______________________________ 601 49409 01 381.00 Electric Utilities 31,854 25,109 32,519 32,000 32,000 Pumping & Lighting 601 49409 01 383.00 Gas Utilities 901 627 614 1,500 1,500 Heat Only 601 49409 01 409.00 Other Contracted Repairs & Maint 335 1,838 275 2,000 2,000 $800 for Lights in 2015 601 49409 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49409 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 ______________________________ ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #9 35,659 27,683 33,493 37,300 37,300 Page Three 2018 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - April 17, 2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 601 49410 01 219.00 Other Operating Supplies 0 0 0 500 500 ______________________________ 601 49410 01 221.00 Equipment Parts 0 5,710 364 1,000 1,000 ______________________________ 601 49410 01 223.00 Building Repair Supplies 15 0 0 200 200 ______________________________ 601 49410 01 321.00 Telephone Costs 765 765 765 0 0 Removing Phone Line in 2013 601 49410 01 381.00 Electric Utilities 13,223 16,173 23,806 17,000 17,000 Pumping & Lighting 601 49410 01 409.00 Other Contracted Repairs & Maint 1,748 690 6,474 2,000 2,000 $800 for Lights in 2015 601 49410 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49410 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 ______________________________ ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #10 15,751 23,337 31,408 20,800 20,800 Rural Water System 601 49411 01 221.00 Equipment Parts 0 4 0 0 0 ______________________________ 601 49411 01 439.00 Other Miscellaneous Charges 0 0 0 0 0 ______________________________ ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #11 0 4 0 0 0 Rural Water System (#2) 601 49412 01 221.00 Equipment Parts 0 3,431 608 1,500 1,500 ______________________________ 601 49412 01 223.00 Building Repair Supplies 0 0 0 200 200 ______________________________ 601 49412 01 319.00 Other Professional Services 0 0 0 0 0 ______________________________ 601 49412 01 381.00 Electric Utilities 21,696 21,159 16,765 28,000 28,000 Pumping & Lighting 601 49412 01 409.00 Other Contracted Repairs & Maint 8,317 15,891 275 2,000 2,000 $800 for Lights in 2015 601 49412 01 439.00 Other Miscellaneous Charges 0 0 13 100 100 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #12 30,013 40,480 17,661 31,800 31,800 601 49414 01 221.00 Equipment Parts 161 0 158 1,500 1,500 ______________________________ 601 49414 01 223.00 Building Repair Supplies 408 0 0 200 200 ______________________________ 601 49414 01 319.00 Other Professional Services 384 0 0 1,000 1,000 ______________________________ 601 49414 01 381.00 Electric Utilities 23,382 26,674 26,254 28,000 28,000 Pumping & Lighting 601 49414 01 409.00 Other Contracted Repairs & Maint 0 6,850 3,116 2,000 2,000 $800 for Lights in 2015 601 49414 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #14 24,335 33,525 29,527 32,800 32,800 601 49425 01 221.00 Equipment Parts 830 0 0 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 24,817 24,641 22,884 28,000 28,000 Pumping & Lighting 601 49425 01 409.00 Other Contracted Repairs & Maint 430 3,944 1,697 2,000 2,000 $800 for Lights in 2015 601 49425 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #15 26,077 28,585 24,581 32,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 28,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 ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #16 0 0 0 32,300 32,300 Page Four 2018 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - April 17, 2017 2018 2017 Object 2018 2014 2015 2016 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 3,675 0 0 0 0 ______________________________ 601 49415 01 409.00 Other Contracted Repairs & Maint 1,050 617 1,828 500 500 ______________________________ 601 49415 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WATER TOWER #1 4,725 617 1,828 1,200 1,200 (Chippendale Water Tower) 601 49416 01 221.00 Equipment Parts 101 0 0 500 500 Touch-up Paint 601 49416 01 319.00 Other Professional Services 0 3,500 0 0 0 Tower Inspection 601 49416 01 381.00 Electric Utilities 1,261 2,195 2,249 4,500 4,500 New Water Mixers in 2014 601 49416 01 409.00 Other Contracted Repairs & Maint 8,210 3,027 0 500 500 ______________________________ 601 49416 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WATER TOWER #2 9,572 8,722 2,249 5,700 5,700 (Connemara Water Tower) 601 49417 01 221.00 Equipment Parts 206 8 0 500 500 ______________________________ 601 49417 01 319.00 Other Professional Services 0 3,500 0 0 0 ______________________________ 601 49417 01 381.00 Electric Utilities 4,760 2,994 2,136 6,000 6,000 ______________________________ 601 49417 01 409.00 Other Contracted Repairs & Maint 14,700 6,105 0 500 500 ______________________________ 601 49417 01 439.00 Other Miscellaneous Charges 0 156 0 200 200 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WATER TOWER #4 19,666 12,763 2,136 7,200 7,200 (Bacardi Water Tower) 601 49418 01 221.00 Equipment Parts 0 24 0 500 500 ______________________________ 601 49418 01 319.00 Other Professional Services 0 20,314 0 0 0 ______________________________ 601 49418 01 381.00 Electric Utilities 2,768 2,154 3,181 4,000 4,000 New Water Mixers in 2014 601 49418 01 409.00 Other Contracted Repairs & Maint 15,500 1,020 3,643 500 500 ______________________________ 601 49418 01 439.00 Other Miscellaneous Charges 0 20 0 200 200 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WATER TOWER #3 18,268 23,532 6,824 5,200 5,200 (East Side Water Tower) GRAND TOTAL - ALL DEPTS.$1,149,152 $1,392,963 $1,460,832 $1,653,400 $2,363,500 ======================================================== 42.95% 3.63%Without water tower painting Page One 2018 BUDGET WORKSHEETS SEWER UTILITY - REVENUES - April 17, 2017 2018 2017 Object 2018 2014 2015 2016 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 3,931 6,828 8,168 0 6,300 5% of 5% Fees-Const Projects 602 36101.00 Principal - Special Assessments 81,278 78,480 140,976 85,000 85,000 ______________________________ 602 36102.00 Penalties & Interest - S/A (1,366)(251)442 0 0 ______________________________ 602 36210.00 Interest Earnings - Investments 17,411 13,886 24,736 15,000 15,000 ______________________________ 602 36214.00 Net Change in FV-Investments 8,534 (4,100)(11,576)0 0 Annual Market Value Changes 602 36215.00 Interest Earnings 54 225 534 200 200 ______________________________ 602 36260.00 Other Revenues 0 1,972 0 0 0 ______________________________ 602 36265.00 Use of Reserve Funds 0 0 0 348,800 669,400 ______________________________ 602 37210.00 Residential Sewer Revenues 1,247,826 1,251,838 1,360,653 1,400,000 1,400,000 ______________________________ 602 37220.00 Apartment Sewer Revenues 111,519 117,405 139,095 125,000 125,000 ______________________________ 602 37225.00 Institutional Sewer Revenues 24,128 21,813 24,272 25,000 25,000 ______________________________ 602 37230.00 Commercial Sewer Revenues 74,855 78,823 78,842 80,000 80,000 ______________________________ 602 37240.00 Industrial Sewer Revenues 71,258 110,928 99,216 110,000 110,000 ______________________________ 602 37260.00 Penalties - Sewer Revenues 12,104 13,051 13,090 13,000 13,000 ______________________________ 602 39103.00 Gain or Loss from F/A Disposal 0 0 (249)0 0 ______________________________ 602 39203.00 Transfer From_______________0 0 0 0 0 ______________________________ ---------------------------------------------------------------------------------------------------- FUND TOTALS $1,651,532 $1,690,900 $1,878,199 $2,202,000 $2,528,900 ====================================================== Page One 2018 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - April 17, 2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 602 49450 101.00 Salaries & Benefits $516,600 Salary, Taxes, PERA & Benefits 602 49450 77 101.00 Administrative 117,386 139,515 153,926 172,300 169,300 ______________________________ 602 49450 78 101.00 Technical/Clerical 151,671 151,279 158,777 159,800 167,200 ______________________________ 602 49450 79 101.00 Maintenance 163,438 165,527 171,036 174,800 180,100 ______________________________ 602 49450 xx 101.00 Salary & Benefit Contingency 0 0 0 0 0 ______________________________ 602 49450 102.00 Full-Time Overtime 13,810 9,705 12,552 7,500 7,500 ______________________________ 602 49450 103.00 Part-Time Salaries & Benefits 5,707 3,548 7,558 7,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,416 1,005 1,067 1,500 1,500 Inserts & Water Bill Statements 602 49450 01 205.00 Plotter Ink and Paper 400 602 49450 01 209.00 Other Office Supplies 172 439 0 200 200 ______________________________ 602 49450 01 212.00 Motor Fuels 0 0 0 5,200 5,100 3% Covered by Sewer Utility 602 49450 01 216.00 Chemicals & Chemical Products 0 731 0 500 500 Root Killer, Degreaser 602 49450 01 219.00 Other Operating Supplies 100 9 60 200 200 ______________________________ 602 49450 01 224.00 Street Maintenance Materials 0 1,439 0 2,500 2,500 Patching 602 49450 01 225.00 Landscaping Materials 0 0 285 400 400 Topsoil, Seed & Sod 602 49450 01 227.00 Utility System Maintenance Supplies 797 1,378 5,454 5,000 5,000 MH Castings Replacement Prog. 602 49450 01 241.00 Small Tools 237 241 641 500 500 Wrenches, Shovels, etc. 602 49450 01 242.00 Minor Equipment 3,746 2,765 4,500 3,000 3,000 ______________________________ 602 49450 01 303.00 Engineering Fees 23,000 ______________________________ 602 49450 01 303.01 GIS 4,607 3,413 1,920 3,000 3,000 Reduce Due to In-House Engineer 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 2,846 9,471 11,737 5,000 5,000 Reduce Due to In-House Engineer 602 49450 01 304.00 Legal Fees 0 0 0 0 0 ______________________________ 602 49450 01 312.00 Gopher State One-Call 2,770 1,655 1,602 2,500 2,500 $7,500 Split 3 Ways 602 49450 01 318.00 Contract Engineer 12,000 6,250 16,174 0 0 ______________________________ 602 49450 01 319.00 Other Professional Services 60,000 ______________________________ 602 49450 01 319.01 Televising 0 0 0 3,000 53,000 3-Yr Citywide Televising Program 602 49450 01 319.02 Root Control 0 0 0 2,000 2,000 ______________________________ 602 49450 01 319.03 Supervisory Controls(Maint Cont)0 0 0 5,000 5,000 SCADA System 602 49450 01 319.04 Buxton Project 5,556 5,556 0 0 0 ______________________________ 602 49450 01 320.00 Credit Card Activity Fees 5,372 6,797 6,097 7,000 7,000 1/3 Cost of C/C Pymt Processing 602 49450 01 321.00 Telephone Costs 3,001 3,122 3,376 3,500 3,500 Cell Phones, Modems, GPS 602 49450 01 322.00 Postage Costs 4,173 4,296 4,186 5,000 5,000 Billings with Inserts 602 49450 01 323.00 Radio Units 1,367 1,120 1,390 5,100 5,100 (24x$300)(12x$1500)(Split 5 Ways) 602 49450 01 365.00 Workers Comp Insurance 7,117 8,361 10,071 7,000 12,000 Sewer's Share of Premiums 602 49450 01 369.00 Other Insurance 12,067 13,292 14,971 12,000 17,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,074 2,074 2,117 2,200 2,200 Added to Utility Budgets in 2012 602 49450 01 391.02 Auto Read Software Support 578 595 613 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,600 9,199 1,306 2,000 2,000 ______________________________ 602 49450 01 394.00 P.C. Software Purchases 8,900 ______________________________ 602 49450 01 394.01 Licensing & Maintenance 4,371 4,591 4,629 15,000 8,400 ESRI, Cartegraph 602 49450 01 394.02 Online Subscriptions 379 379 0 800 300 Pictometry 602 49450 01 394.03 New Software Purchases 0 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 63 24,454 10,016 30,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)669 600 686 1,500 2,000 Operator Licensure $300 each (M) 602 49450 01 437.03 CarteGraph, ESRI, GIS 126 0 81 1,300 800 User Group, Conference, Training 602 49450 01 437.04 Miscellaneous Training 0 814 919 1,000 1,000 ______________________________ 602 49450 01 439.00 Other Miscellaneous Charges 145 258 86 300 300 Contingencies 602 49450 01 521.00 Building & Structure Purchases 0 0 0 10,000 10,000 Pymt on P.W. Building (19 of 20) 602 49450 01 530.00 Improvements Other Than Bldgs 160,000 ______________________________ 602 49450 01 530.01 Miscellaneous Improvements 0 0 0 10,000 10,000 SCADA Reconfiguration, PCL's 602 49450 01 530.03 CRP of Sewermain 0 0 0 150,000 150,000 PMP Sewer Imp When Needed 602 49450 01 540.00 Heavy Machinery Purchases 189,190 63 0 0 0 Equipment Purchases - Match CIP 602 49450 01 550.00 Motor Vehicle Purchases 0 0 0 11,000 0 Equipment Purchases - Match CIP 602 49450 01 560.00 Furniture & Fixture Purchases 0 56 0 500 500 ______________________________ 602 49450 01 570.00 Office Equipment Purchases 0 0 271 500 500 ______________________________ 602 49450 01 580.00 Other Equipment Purchases 0 0 0 7,000 41,700 Dump Station (split with 603) ---------------------------------------------------------------------------------------------------- ^^ Trash Pump (split with 601, 603) PAGE TOTALS 718,548 583,995 608,102 862,900 949,500 Page Two 2018 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - April 17, 2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 602 49450 01 602.00 Sewer Service Charges 1,090,261 1,077,415 1,185,397 1,284,600 1,300,000 Matches Sewer Rate Model 602 49450 01 611.00 Interest on Lease Payments 2,165 1,773 1,362 0 0 P.W. Building Expansion(See 521) 602 49450 01 710.00 Transfers 2,405 0 0 Transfers for Other Improvements ---------------------------------------------------------------------------------------------------- 602-49450-01 TOTALS 1,813,379 1,663,183 1,794,861 2,147,500 2,249,500 602 49451 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49451 01 221.00 Equipment Parts 0 0 3,248 800 800 ______________________________ 602 49451 01 229.00 Other Maintenance Supplies 0 567 0 200 200 ______________________________ 602 49451 01 303.00 Engineering Fees 0 0 0 0 0 ______________________________ 602 49451 01 381.00 Electric Utilities 916 761 49 1,500 1,500 ______________________________ 602 49451 01 403.00 Contracted R & M - Other Impr 775 704 1,931 2,000 2,000 ______________________________ 602 49451 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (City Hall)TOTAL - LIFT STATION #1 1,691 2,032 5,227 4,700 4,700 602 49452 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49452 01 221.00 Equipment Parts 0 0 585 800 800 ______________________________ 602 49452 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49452 01 381.00 Electric Utilities 623 604 674 700 700 ______________________________ 602 49452 01 403.00 Contracted R & M - Other Impr 0 0 0 2,000 2,000 ______________________________ 602 49452 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Bloomfield 5th)TOTAL - LIFT STATION #7 623 604 1,259 3,900 3,900 602 49453 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49453 01 221.00 Equipment Parts 0 0 585 800 800 ______________________________ 602 49453 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49453 01 381.00 Electric Utilities 3,548 3,728 4,165 4,000 4,000 ______________________________ 602 49453 01 403.00 Contracted R & M - Other Impr 7,395 0 7,951 2,000 15,000 Safety Improvements in 2018 602 49453 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Shannon Pond)TOTAL - LIFT STATION #3 10,942 3,728 12,701 7,200 20,200 602 49454 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49454 01 221.00 Equipment Parts 6 0 585 800 800 ______________________________ 602 49454 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49454 01 381.00 Electric Utilities 4,821 5,539 6,110 6,000 6,000 ______________________________ 602 49454 01 403.00 Contracted R & M - Other Impr 0 0 0 2,000 210,000 Update to Submersible Pumps 602 49454 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Hawkins)TOTAL - LIFT STATION #4 4,827 5,539 6,695 9,200 217,200 602 49455 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49455 01 221.00 Equipment Parts 1,800 0 585 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,802 4,979 5,081 6,000 6,000 ______________________________ 602 49455 01 403.00 Contracted R & M - Other Impr 415 2,350 0 2,000 2,000 ______________________________ 602 49455 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (LeForet Add'n)TOTAL - LIFT STATION #5 8,016 7,329 5,666 9,200 9,200 602 49456 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49456 01 221.00 Equipment Parts 0 0 585 800 800 ______________________________ 602 49456 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49456 01 381.00 Electric Utilities 8,270 3,945 3,829 6,000 6,000 ______________________________ 602 49456 01 403.00 Contracted R & M - Other Impr 0 0 0 2,000 2,000 ______________________________ 602 49456 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Drumcliffe)TOTAL - LIFT STATION #6 8,270 3,945 4,414 9,200 9,200 Page Three 2018 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - April 17, 2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 602 49457 01 219.00 Other Operating Supplies 0 0 0 100 4,000 Bubbler in 2018 602 49457 01 221.00 Equipment Parts 0 0 585 500 500 ______________________________ 602 49457 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49457 01 381.00 Electric Utilities 857 216 688 1,200 1,200 ______________________________ 602 49457 01 403.00 Contracted R & M - Other Impr 0 1,533 0 2,000 2,000 ______________________________ 602 49457 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Glendalough 5th)TOTAL - LIFT STATION #9 857 1,749 1,273 4,100 8,000 602 49458 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49458 01 221.00 Equipment Parts 0 0 585 500 500 ______________________________ 602 49458 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49458 01 381.00 Electric Utilities 629 449 519 800 800 ______________________________ 602 49458 01 403.00 Contracted R & M - Other Impr 0 539 0 2,000 2,000 ______________________________ 602 49458 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Meadows of )TOTAL - LIFT STATION #8 629 987 1,105 3,700 3,700 (Bloomfield) 602 49460 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49460 01 221.00 Equipment Parts 0 0 585 500 500 ______________________________ 602 49460 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49460 01 381.00 Electric Utilities 261 233 257 400 400 ______________________________ 602 49460 01 403.00 Contracted R & M - Other Impr 0 0 0 2,000 2,000 ______________________________ 602 49460 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Glen Rose)TOTAL - LIFT STATION #10 261 233 843 3,300 3,300 GRAND TOTAL - ALL DEPTS.$1,849,496 $1,689,329 $1,834,044 $2,202,000 $2,528,900 ====================================================== 14.85% 5.31%without lift 4 submersible pumps Page One 2018 BUDGET WORKSHEETS STORM WATER UTILITY - REVENUES - April 17, 2017 2018 2017 Object 2018 2014 2015 2016 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 19,680 0 0 0 0 ______________________________ 603 34108.00 Administrative Fees-Other Funds 3,931 6,828 8,168 0 6,300 5% of 5% Fees-Const Projects 603 36101.00 Principal - Special Assessments 25,726 21,967 46,930 22,000 22,000 ______________________________ 603 36102.00 Penalties & Interest - S/A (362)(57)164 0 0 ______________________________ 603 36210.00 Interest Earnings - Investments 37,889 34,724 55,670 25,000 25,000 ______________________________ 603 36214.00 Net Change in FV-Investments 40,005 (8,127)(20,949)0 0 Annual Market Value Changes 603 36215.00 Interest Earnings 47 213 513 200 200 ______________________________ 603 36260.00 Other Revenues 35,615 0 0 0 0 ______________________________ 603 36262.00 Special Settlements 24,797 0 0 0 0 ______________________________ 603 36265.00 Use of Reserve Funds 0 0 0 17,200 0 ______________________________ 603 37300.00 Storm Water Utility Revenues 1,040,839 1,102,373 1,158,950 1,215,000 1,260,000 4% Annual Rate Incr (Per Model) 603 37360.00 Penalties - Storm Water Utility 6,577 9,300 7,880 6,000 6,000 ______________________________ 603 39103.00 Gain or Loss from F/A Disposal 0 0 (249)0 0 ______________________________ 603 39203.00 Transfer From______________14,260 24,000 0 0 0 ______________________________ ------------------------------------------------------------------------------------------------------ FUND TOTALS $1,249,004 $1,191,221 $1,257,077 $1,285,400 $1,319,500 ====================================================== Page One 2018 BUDGET WORKSHEETS STORM WATER UTILITY - EXPENDITURES - April 17, 2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 603 49500 101.00 Salaries & Benefits $284,200 Salary, Taxes, PERA & Benefits 603 49500 77 101.00 Administrative 10,932 26,693 47,765 79,500 82,300 ______________________________ 603 49500 78 101.00 Technical/Clerical 85,598 85,202 78,418 87,000 93,300 ______________________________ 603 49500 79 101.00 Maintenance 81,718 82,763 85,519 109,900 108,600 ______________________________ 603 49500 xx 101.00 Salary & Benefit Contingency 0 0 0 0 0 ______________________________ 603 49500 102.00 Full-Time Overtime 6,918 4,928 6,300 6,000 6,000 ______________________________ 603 49500 99 103.00 Part-Time Salaries & Benefits 4,323 6,506 7,672 8,000 8,000 ______________________________ 603 49500 01 203.00 Printed Forms & Paper 1,416 1,005 1,067 1,500 1,500 ______________________________ 603 49500 01 204.00 Envelopes & Letterhead 0 0 0 0 0 ______________________________ 603 49500 01 205.00 Plotter Ink and Paper 400 603 49500 01 208.00 Miscellaneous Supplies 0 397 143 500 500 Stakes, Ribbons, Level, etc. 603 49500 01 212.00 Motor Fuels 0 0 0 6,200 6,000 3.5% Covered by Storm Utility 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,505 39 0 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.1,868 1,162 9,076 1,000 1,000 ______________________________ 603 49500 01 225.02 Black Dirt, Seed, Sod, etc.150 0 5,376 1,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,018 482 3,489 1,000 1,000 ______________________________ 603 49500 01 241.00 Small Tools 627 260 373 1,000 1,000 ______________________________ 603 49500 01 242.00 Minor Equipment 1,567 943 5,687 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 0 0 0 5,000 5,000 Reduce Due to In-House Engineer 603 49500 01 303.02 NPDES Phase II 68,996 75,829 48,942 32,000 32,000 Reduce Due to In-House Engineer 603 49500 01 303.03 CSMP Update 2,535 25,026 5,055 50,000 50,000 Part of Comp Plan Update 603 49500 01 303.04 Miscellaneous 5,265 11,053 54,291 10,000 10,000 Reduce Due to In-House Engineer 603 49500 01 303.05 GIS 3,071 2,276 1,280 3,000 3,000 Reduce Due to In-House Engineer 603 49500 01 303.06 MS4 Services 0 0 0 0 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 169 2,012 1,602 2,500 2,500 $7,500 Split 3 Ways 603 49500 01 315.00 Special Programs 4,815 3,850 6,031 5,000 5,000 WHEP 603 49500 01 318.00 Contract Engineer 12,000 6,250 16,174 0 0 ______________________________ 603 49500 01 319.00 Other Professional Services 5,000 ______________________________ 603 49500 01 319.01 SCADA 0 0 0 5,000 5,000 ______________________________ 603 49500 01 319.02 Buxton Project 5,556 5,556 0 0 0 ______________________________ 603 49500 01 320.00 Credit Card Activity Fees 5,372 6,797 6,097 7,000 7,000 1/3 Cost of C/C Pymt Processing 603 49500 01 321.00 Telephone Costs 3,002 3,122 3,376 3,500 3,500 Cell Phones, Modems, GPS 603 49500 01 322.00 Postage Costs 4,173 4,296 4,186 5,000 5,000 Billings & Info Mailings 603 49500 01 323.00 Radio Units 1,367 1,120 1,390 5,100 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,992 3,541 4,624 3,500 6,000 Storm Water's Share of Premiums 603 49500 01 369.00 Other Insurance 1,316 1,203 1,506 4,000 2,500 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,074 2,074 2,117 2,200 2,200 Added to Utility Budgets in 2012 603 49500 01 391.02 Auto Read Software Support 578 595 613 700 700 Added to Utility Budgets in 2012 603 49500 01 393.00 P.C. Hardware Purchases 1,600 9,199 1,306 2,000 2,000 ______________________________ 603 49500 01 394.00 P.C. Software Purchases 8,900 ______________________________ 603 49500 01 394.01 Licensing & Maintenance 4,371 4,591 4,628 15,000 8,400 ESRI, Cartegraph 603 49500 01 394.02 Online Subscriptions 379 379 0 800 300 Pictometry 603 49500 01 394.03 New Software Purchases 0 0 0 200 200 ______________________________ 603 49500 01 403.00 Contracted R & M - Other Impr 68,000 ______________________________ 603 49500 01 403.01 Ditching 8,344 0 0 8,000 8,000 ______________________________ 603 49500 01 403.02 Miscellaneous Repairs 117,136 20,634 62,221 60,000 60,000 Catch Basins, Manholes, Etc. 603 49500 01 403.03 Pond Inspection & Maintenance 0 0 20,000 0 0 ______________________________ 603 49500 01 405.00 MS4 Permit Compliance 170,000 ______________________________ 603 49500 01 405.01 Engineering Fees 0 0 0 45,000 45,000 Inspection, GIS, Guidance, Etc. 603 49500 01 405.02 Equipment Rental 0 0 0 20,000 20,000 Bulldozer, Large Equipment 603 49500 01 405.03 Dirt, Seed, Rip Rap, Etc.0 0 0 5,000 5,000 For Restoration 603 49500 01 405.04 Contracted Maintenance 0 0 0 100,000 100,000 Brush Clearing, Dredging 603 49500 01 416.00 Machinery Rental 0 0 11,359 2,500 2,500 Pumps 603 49500 01 433.00 Dues & Subscriptions 140 140 280 200 200 SUSA(AJ, Dick) 50% Split w/Storm 603 49500 01 435.00 Books & Pamphlets 0 73 0 500 500 Utility Information 603 49500 01 437.00 Conferences & Seminars 3,000 ______________________________ 603 49500 01 437.01 Storm Water Management 0 0 0 1,200 1,200 Stormwater Collab, Flygt Training 603 49500 01 437.04 Cartegraph, ESRI, GIS 126 0 81 1,300 800 User Group, Conference, Training 603 49500 01 437.05 Miscellaneous Training 0 165 864 1,000 1,000 ______________________________ 603 49500 01 439.00 Other Miscellaneous Charges 145 265 159 300 300 ______________________________ ------------------------------------------------------------------------------------------------------ PAGE TOTALS 453,160 400,426 509,066 717,600 719,000 Page Two 2018 BUDGET WORKSHEETS STORM WATER UTILITY - EXPENDITURES - April 17, 2017 2018 2017 Object 2018 2014 2015 2016 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 603 49500 01 530.00 Improvements Other Than Bldgs 350,000 ______________________________ 603 49500 01 530.01 CRP of Storm Sewer 0 7,800 4,982 150,000 350,000 $300K for CSAH 38 Improvements 603 49500 01 530.02 Stormwater System Improvements 0 0 0 206,300 0 Keegan Lake Drainage in 2017 603 49500 01 540.00 Heavy Machinery Purchases 0 0 0 99,000 50,000 Skid Loader ($15K from Equip CIP) 603 49500 01 550.00 Motor Vehicle Purchases 0 0 0 10,000 0 Equipment Purchases - Match CIP 603 49500 01 560.00 Furniture & Fixture Purchases 189,190 0 0 500 500 ______________________________ 603 49500 01 580.00 Other Equipment Purchases 0 63 1,690 48,000 41,700 Dump Station (Split with 602) 603 49500 01 586.00 Computer Equipment Purchases 0 0 0 500 500 ^^ Trash Pump (split with 601, 602) 603 49500 01 710.00 Transfers 0 ______________________________ 603 49500 01 710.06 1/2 of 2011 P & I Payments(2010A)87,000 51,000 50,000 32,000 0 Refunding Issue 12/10 603 49500 01 710.10 Projects 123,395 384,695 537,101 0 0 ______________________________ ------------------------------------------------------------------------------------------------------ 603-49500-01 TOTALS 852,746 843,983 1,102,839 1,263,900 1,161,700 603 49511 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49511 01 381.00 Electric Utilities 360 277 291 500 500 ______________________________ 603 49511 01 403.00 Contracted Repair & Maintenance 278 1,455 0 1,000 1,000 ______________________________ ------------------------------------------------------------------------------------------------------ (Copper Pond)TOTAL - LIFT STATION #1 638 1,732 291 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 1,897 0 1,000 1,000 ______________________________ ------------------------------------------------------------------------------------------------------ (Schwarz Pond)TOTAL - LIFT STATION #2 0 1,897 0 2,000 2,000 603 49513 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49513 01 381.00 Electric Utilities 5,552 4,157 7,106 6,000 7,200 ______________________________ 603 49513 01 403.00 Contracted Repair & Maintenance 0 1,455 0 1,000 1,000 ______________________________ ------------------------------------------------------------------------------------------------------ (Birger Pond)TOTAL - LIFT STATION #3 5,552 5,612 7,106 7,500 8,700 603 49514 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49514 01 381.00 Electric Utilities 2,067 986 957 2,500 2,500 ______________________________ 603 49514 01 403.00 Contracted Repair & Maintenance 103 1,765 0 1,000 1,000 ______________________________ ------------------------------------------------------------------------------------------------------ (Marcotte Pond)TOTAL - LIFT STATION #4 2,170 2,751 957 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 1,455 0 1,000 1,000 Alarm Upgrades, SCADA, PLC ------------------------------------------------------------------------------------------------------ (Hawkins Pond)TOTAL - LIFT STATION #5 0 1,455 0 2,000 2,000 603 49516 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49516 01 381.00 Electric Utilities 473 352 388 500 500 ______________________________ 603 49516 01 403.00 Contracted Repair & Maintenance 145 1,455 0 1,000 1,000 ______________________________ ------------------------------------------------------------------------------------------------------ (Glendalough 7th)TOTAL - LIFT STATION #6 618 1,807 388 2,000 2,000 603 49517 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49517 01 381.00 Electric Utilities 0 0 635 500 500 ______________________________ 603 49517 01 403.00 Contracted Repair & Maintenance 0 0 0 1,000 1,000 ______________________________ ------------------------------------------------------------------------------------------------------ (Horseshoe Lake)TOTAL - LIFT STATION #7 0 0 635 2,000 2,000 GRAND TOTAL - ALL DEPTS.$861,724 $859,238 $1,112,216 $1,285,400 $1,184,400 ====================================================== -7.86%