Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
7.b. 2020 Utility Budgets
EXECUTIVE SUMMARY Utility Commission Meeting: August 19, 2019 AGENDA SECTION: AGENDA ITEM: 2020 Utility Budgets New Business PREPARED BY: Christine Watson, Public Works Coordinator AGENDA NO. 7.b. ATTACHMENTS: Proposed 2020 Utility Budgets APPROVED BY: BLE RECOMMENDED ACTION: Motion to Recommend City Council Approval of the 2020 Utility Budgets BACKGROUND Attached for the commission’s consideration are the proposed 2020 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 changes to the three enterprise funds. Table 1 Fund 2019 Budget 2020 Proposed Budget Increase Water Utility $2,481,600 $1,677,800 -32.4% Sewer Utility $2,531,400 $2,625,200 3.7% Storm Utility $1,093,700 $1,320,900 20.8% Total $6,106,700 $5,623,900 -7.9% The substantial decrease to the Water Utility budget is primarily due to the painting of the Chippendale water tower in 2019. This work was originally scheduled for and budgeted in 2018. Due to various delays, the project was rescheduled and budgeted in 2019. The 2020 budget is $745,000 less on this one line-item, which is the primary reason for the 32.4% overall decrease. Funding was added to the Sewer Utility budget to begin a sanitary manhole maintenance program in 2019. This will be a multi-year project costing an estimated $450,000. The 2020 budget also includes $200,000 for communication upgrades and new electrical/control cabinets at two lift stations. The increase to the Storm Utility budget is primarily due to adding $140,000 for communication upgrades and new electrical/control cabinets at two lift stations. There are no other significant changes to this budget. All three utility funds are proposed to share the cost of a new FTE position in 2020, estimated to be $120,000 for wages and benefits. If approved, the Utility Maintenance division will consist of six FTEs. The redline version of each budget is included for your review. Staff will be available at the meeting to answer any questions or concerns. C:\\Users\\jab\\AppData\\Local\\Temp\\7.b. 2020 Utility Budgets_563193\\7.b. 2020 Utility Budgets.docx SUMMARY Staff is requesting Utility Commission recommend the City Council approve the proposed 2020 Utility Budgets. 2 Page One 2020 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - May 3, 2019 2020 2019 Object 2020 2016 2017 2018 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 601 49400 101.00 Salaries & Benefits $562,000 Salary, Taxes, PERA & Benefits 601 49400 77 101.00 Administrative 153,689 129,584 205,824 148,200 155,700 ______________________________ 601 49400 78 101.00 Technical/Clerical 158,777 146,843 155,870 165,800 175,200 ______________________________ 601 49400 79 101.00 Maintenance 171,037 171,054 180,248 184,800 231,100 Add Utility FTE Split with 602, 603 601 49400 xx 101.00 Salary & Benefit Contingency 0 0 0 0 0 ______________________________ 601 49400 102.00 Full-Time Overtime 12,552 10,140 13,549 8,000 8,000 ______________________________ 601 49400 103.00 Part-Time Salaries & Benefits 8,081 5,779 6,916 7,700 8,700 ______________________________ 601 49400 99 103.xx Utility Commission Wages (1/3)700 ______________________________ 601 49400 99 103.xx Maintenance Labor 8,000 Seasonal Employees and Interns 601 49400 01 203.00 Printed Forms & Paper 1,067 504 1,092 100 100 Outsource Bill Printing (313.00) 601 49400 01 205.00 Plotter Ink & Paper 0 0 0 400 400 ______________________________ 601 49400 01 209.00 Other Office Supplies 61 114 362 200 200 ______________________________ 601 49400 01 212.00 Motor Fuels 0 5,600 5,100 3,900 3,900 2.5% Covered by Water Utility 601 49400 01 216.00 Chemicals & Chemical Products 48,355 55,588 43,035 75,000 75,000 Chlorine/Flouride/Poly 601 49400 01 219.00 Other Operating Supplies 957 415 2,053 500 500 Maintenance Supplies 601 49400 01 220.00 Water Meter Purchases 150,000 Meters, MIU's & CU Horns 601 49400 01 220.01 For Replacements 87,771 57,467 71,822 67,000 75,000 Match Rate Model (Incl. Recycling) 601 49400 01 220.02 For New Homes 58,843 42,572 47,296 57,200 75,000 Match Rate Model, Newland Dev 601 49400 01 224.00 Street Maintenance Materials 2,285 329 1,261 2,500 2,500 Patching for Breaks 601 49400 01 225.00 Landscaping Materials 1,103 323 360 1,000 1,000 Topsoil, Seed & Sod 601 49400 01 228.00 Meter Repair Materials 90 0 222 0 0 ______________________________ 601 49400 01 229.00 Other Maintenance Supplies 17,000 ______________________________ 601 49400 01 229.01 Supplies for Hydrants 5,840 8,968 8,476 10,000 10,000 ______________________________ 601 49400 01 229.02 Curb Shutoffs 135 0 855 1,000 1,000 ______________________________ 601 49400 01 229.03 GV Repair/Replacement 1,513 934 0 2,000 2,000 ______________________________ 601 49400 01 229.04 Miscellaneous Supplies 933 3,247 3,350 4,000 4,000 ______________________________ 601 49400 01 240.00 Safety Equipment & PPE 500 Vests, Glasses, Hardhats, Etc. 601 49400 01 241.00 Small Tools 1,432 1,099 2,140 2,000 2,500 Wrenches, Shovels, etc. 601 49400 01 242.00 Minor Equipment 3,543 11,622 8,371 5,000 17,000 2 MXU Readers in 2020 601 49400 01 303.00 Engineering Fees 26,000 ______________________________ 601 49400 01 303.01 WHPP 0 0 0 5,000 5,000 Groundwater Plan Implementation 601 49400 01 303.02 GIS 1,920 2,476 78 3,000 1,000 $5000 split 5 ways 601 49400 01 303.03 Rate Study 3,900 0 14,459 5,000 5,000 ______________________________ 601 49400 01 303.04 Miscellaneous Fees 32,177 17,602 2,574 30,000 15,000 Future Water Facility Study 601 49400 01 304.00 Legal Fees 0 105 0 1,000 1,000 ______________________________ 601 49400 01 310.00 Testing Services 83,500 ______________________________ 601 49400 01 310.01 Bacteria & Water Quality 1,516 2,269 2,625 3,000 3,500 Radon, Tri-Chl., Pesticides, Etc. 601 49400 01 310.03 MDH Service Connection Fee 45,167 45,928 47,381 47,000 80,000 ______________________________ 601 49400 01 312.00 Gopher State One-Call 1,602 1,683 1,436 2,500 2,500 $7,500 Split 3 Ways 601 49400 01 313.00 Outsource Bill Printing/Mailing 0 0 2,201 8,300 8,300 ______________________________ 601 49400 01 318.00 Contract Engineer 16,174 22,602 0 0 0 ______________________________ 601 49400 01 319.00 Other Professional Services 47,500 ______________________________ 601 49400 01 319.01 Thaw Pipes, Check Leaks, etc.0 0 0 1,500 1,500 ______________________________ 601 49400 01 319.02 Supervisory Controls 4,483 3,435 0 5,000 5,000 ______________________________ 601 49400 01 319.03 Hazardous Chemical Permits 725 725 700 1,000 1,000 MN Department of Public Safety 601 49400 01 319.06 Contracted Hydrant Painting 10,028 8,265 11,172 11,000 11,000 ______________________________ 601 49400 01 319.07 Antenna Expenses 7,621 3,577 9,209 20,000 20,000 Offset by Revenue 601-36220.00 601 49400 01 319.08 Buxton Project 0 0 9 0 0 ______________________________ 601 49400 01 319.09 HVAC Maintenance Contract 0 3,304 0 4,000 4,000 Annual Insp/Maint, All Wells 601 49400 01 319.10 Landscape Maintenance 0 0 0 4,000 4,000 ______________________________ 601 49400 01 319.11 Pest Control 0 0 0 1,000 1,000 ______________________________ 601 49400 01 320.00 Credit Card Activity Fees 6,097 6,299 7,767 7,000 8,500 1/3 Cost of C/C Pymt Processing 601 49400 01 321.00 Telephone Costs 3,451 3,230 4,734 3,500 5,000 Cell Phones, Modesm, GPS 601 49400 01 322.00 Postage Costs 4,315 3,767 2,920 100 400 Outsource Mailing (313.00) 601 49400 01 323.00 Radio Units 1,390 5,777 6,082 7,100 7,100 (24x$300)($28,000)(Split 5 Ways) 601 49400 01 352.00 General Notices & Public Info 30 0 0 0 0 ______________________________ 601 49400 01 365.00 Workers Comp Insurance 10,058 12,311 13,635 12,000 12,000 Water's Share of Premiums 601 49400 01 369.00 Other Insurance 6,382 6,507 6,793 7,000 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,117 2,177 2,159 2,200 2,200 Added to Utility Budgets in 2012 601 49400 01 391.02 Auto Read Software Support 613 631 650 700 700 Added to Utility Budgets in 2012 601 49400 01 392.00 P.C. Accessories & Supplies 0 108 0 200 200 ______________________________ 601 49400 01 393.00 P.C. Hardware Purchases 1,306 589 1,967 3,000 3,000 $1,100 Intern GPS ($3,300 Shared) 601 49400 01 394.00 P.C. Software Purchases 11,000 ______________________________ 601 49400 01 394.01 Licensing & Maintenance 4,629 10,129 8,954 10,000 10,500 ESRI, Cartegraph, DataLink 601 49400 01 394.02 Online Subscriptions 0 234 234 300 300 Pictometry 601 49400 01 394.03 New Software Purchases 0 46 0 200 200 ______________________________ ---------------------------------------------------------------------------------------------------------- PAGE TOTALS 883,765 815,958 905,941 951,900 1,075,200 Page Two 2020 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - May 3, 2019 2020 2019 Object 2020 2016 2017 2018 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 601 49400 01 403.00 Contracted R & M - Other Impr 59,309 24,873 82,681 60,000 80,000 Main Breaks, Gate Valves, Etc. 601 49400 01 433.00 Dues & Subscriptions 250 0 327 400 500 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,500 ______________________________ 601 49400 01 437.01 MDH Training (Water School)436 2,173 1,026 3,000 3,000 Operator Licensure 601 49400 01 437.02 AWWA Conference 0 0 1,899 1,200 2,000 Duluth, Send 2 Staff 601 49400 01 437.03 CarteGraph, ESRI, GIS 81 139 607 500 500 User Group, Conference, Training 601 49400 01 437.04 Miscellaneous Training 928 62 20 1,000 1,000 ______________________________ 601 49400 01 439.00 Other Miscellaneous Charges 16,057 15,328 12,674 20,000 20,000 DNR Annual Water Use 601 49400 01 450.00 Sales Tax on Purchases 0 0 0 0 0 ______________________________ 601 49400 01 521.00 Building & Structure Purchases 0 0 0 0 0 ______________________________ 601 49400 01 530.00 Improvements Other Than Bldgs 201,000 ______________________________ 601 49400 01 530.01 Well Inspections 800 0 800 600 1,000 ______________________________ 601 49400 01 530.02 Miscellaneous Improvements 63,720 75,280 81,548 80,000 50,000 Seal Wells 1 & 2 (2018) 601 49400 01 530.03 CRP of Watermain 0 0 0 50,000 50,000 PMP Water Imp. When Needed 601 49400 01 530.04 Inspection & Maintenance 49,361 85,845 12,835 845,000 100,000 From Long-Term Plan (Chip in '19) 601 49400 01 540.00 Heavy Machinery Purchases 0 0 0 0 0 Equipment Purchases - Match CIP 601 49400 01 548.00 Lease Program-P.W. Vehicles 0 0 16,984 0 0 ______________________________ 601 49400 01 550.00 Motor Vehicle Purchases 0 11,436 0 40,500 13,100 Vehicle Leases 601 49400 01 570.00 Office Equipment Purchases 0 0 0 500 500 ______________________________ 601 49400 01 580.00 Other Equipment Purchases 0 0 24,754 30,000 0 Portable Generator (Split 3 Ways) 601 49400 01 611.00 Interest on Lease Payments 1,362 930 476 0 0 P.W. Building Expansion(See 521) 601 49400 01 710.00 Transfers 181,450 0 0 0 0 Transfers for Other Improvements ---------------------------------------------------------------------------------------------------------- 601-49400-01 TOTALS 1,257,519 1,032,023 1,142,571 2,084,800 1,397,000 601 49406 01 221.00 Equipment Parts 0 0 0 200 200 SCADA Upgrades 601 49406 01 223.00 Building Repair Supplies 0 0 0 200 200 ______________________________ 601 49406 01 319.00 Other Professional Services 491 5,585 0 1,000 1,000 ______________________________ 601 49406 01 381.00 Electric Utilities 1,197 1,573 409 1,300 1,300 Pumping & Lighting ---------------------------------------------------------------------------------------------------------- TOTAL - PRV 1,688 7,158 409 2,700 2,700 601 49407 01 221.00 Equipment Parts 0 2,120 3,664 1,500 1,500 ______________________________ 601 49407 01 223.00 Building Repair Supplies 98 32 0 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 22,695 25,303 25,629 33,000 33,000 Pumping, Lighting, Tower Mixer 601 49407 01 409.00 Other Contracted Repairs & Maint 404 3,665 2,044 2,000 2,000 ______________________________ 601 49407 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49407 01 530.00 Improvements Other Than Bldgs 0 3,323 9,184 120,000 2,000 Standby Generator in 2019 ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #7 23,408 34,654 40,733 157,100 39,100 601 49408 01 221.00 Equipment Parts 0 1,662 1,139 1,500 1,500 ______________________________ 601 49408 01 223.00 Building Repair Supplies 0 5 0 200 200 ______________________________ 601 49408 01 319.00 Other Professional Services 0 0 0 0 0 ______________________________ 601 49408 01 381.00 Electric Utilities 22,293 19,484 21,238 25,000 25,000 Pumping & Lighting 601 49408 01 383.00 Gas Utilities 355 397 469 600 600 Heat Only 601 49408 01 409.00 Other Contracted Repairs & Maint 5,862 324 6,959 2,000 2,000 ______________________________ 601 49408 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #8 28,510 21,872 29,804 29,400 29,400 601 49409 01 221.00 Equipment Parts 0 10 29 1,500 1,500 ______________________________ 601 49409 01 223.00 Building Repair Supplies 84 0 0 200 200 ______________________________ 601 49409 01 319.00 Other Professional Services 0 0 0 0 0 ______________________________ 601 49409 01 381.00 Electric Utilities 32,519 31,776 29,288 32,000 32,000 Pumping & Lighting 601 49409 01 383.00 Gas Utilities 614 616 766 1,500 1,500 Heat Only 601 49409 01 409.00 Other Contracted Repairs & Maint 275 3,341 2,347 2,000 4,000 Paint generator in 2020 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 33,493 35,742 32,430 37,300 39,300 Page Three 2020 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - May 3, 2019 2020 2019 Object 2020 2016 2017 2018 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 364 1,926 1,576 1,000 1,000 ______________________________ 601 49410 01 223.00 Building Repair Supplies 0 0 18 200 200 ______________________________ 601 49410 01 321.00 Telephone Costs 765 765 765 0 0 ______________________________ 601 49410 01 381.00 Electric Utilities 23,806 19,551 15,985 17,000 17,000 Pumping & Lighting 601 49410 01 409.00 Other Contracted Repairs & Maint 6,474 67,275 24,817 2,000 2,000 ______________________________ 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 31,408 89,517 43,162 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 608 27 0 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 16,765 26,035 28,566 28,000 28,000 Pumping & Lighting 601 49412 01 409.00 Other Contracted Repairs & Maint 275 18,163 478 2,000 2,000 ______________________________ 601 49412 01 439.00 Other Miscellaneous Charges 13 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #12 17,661 44,225 29,044 31,800 31,800 601 49414 01 221.00 Equipment Parts 158 1,348 466 1,500 1,500 ______________________________ 601 49414 01 223.00 Building Repair Supplies 0 0 200 200 200 ______________________________ 601 49414 01 319.00 Other Professional Services 0 0 0 1,000 1,000 ______________________________ 601 49414 01 381.00 Electric Utilities 26,254 25,708 29,869 28,000 28,000 Pumping & Lighting 601 49414 01 409.00 Other Contracted Repairs & Maint 3,116 666 622 2,000 2,000 ______________________________ 601 49414 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #14 29,527 27,722 31,157 32,800 32,800 601 49425 01 221.00 Equipment Parts 0 0 564 1,500 1,500 ______________________________ 601 49425 01 223.00 Building Repair Supplies 0 0 200 200 200 ______________________________ 601 49425 01 319.00 Other Professional Services 0 0 0 500 500 ______________________________ 601 49425 01 381.00 Electric Utilities 22,884 35,410 28,224 30,000 30,000 Pumping & Lighting 601 49425 01 409.00 Other Contracted Repairs & Maint 1,697 0 7,333 2,000 2,000 ______________________________ 601 49425 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #15 24,581 35,410 36,321 34,300 34,300 601 49426 01 221.00 Equipment Parts 0 0 726 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 5,368 28,000 28,000 Pumping & Lighting 601 49426 01 383.00 Gas Utilities 0 0 0 0 0 ______________________________ 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 6,094 31,300 31,300 Page Four 2020 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - May 3, 2019 2020 2019 Object 2020 2016 2017 2018 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 601 49415 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 601 49415 01 319.00 Other Professional Services 0 0 0 0 0 ______________________________ 601 49415 01 409.00 Other Contracted Repairs & Maint 1,828 149 130 500 500 ______________________________ 601 49415 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WATER TOWER #1 1,828 149 130 1,200 1,200 (Chippendale Water Tower) 601 49416 01 221.00 Equipment Parts 0 0 114 500 500 ______________________________ 601 49416 01 319.00 Other Professional Services 0 0 0 0 0 ______________________________ 601 49416 01 381.00 Electric Utilities 2,249 2,274 1,770 4,500 4,500 ______________________________ 601 49416 01 409.00 Other Contracted Repairs & Maint 0 303 0 500 500 ______________________________ 601 49416 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WATER TOWER #2 2,249 2,577 1,884 5,700 5,700 (Connemara Water Tower) 601 49417 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 601 49417 01 319.00 Other Professional Services 0 0 0 0 0 ______________________________ 601 49417 01 381.00 Electric Utilities 2,136 2,999 2,822 6,000 6,000 ______________________________ 601 49417 01 409.00 Other Contracted Repairs & Maint 0 0 285 500 500 ______________________________ 601 49417 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WATER TOWER #4 2,136 2,999 3,107 7,200 7,200 (Bacardi Water Tower) 601 49418 01 221.00 Equipment Parts 0 103 164 500 500 ______________________________ 601 49418 01 319.00 Other Professional Services 0 2,800 0 0 0 ______________________________ 601 49418 01 381.00 Electric Utilities 3,181 2,496 1,989 4,000 4,000 ______________________________ 601 49418 01 409.00 Other Contracted Repairs & Maint 3,643 553 0 500 500 ______________________________ 601 49418 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WATER TOWER #3 6,824 5,952 2,153 5,200 5,200 (East Side Water Tower) GRAND TOTAL - ALL DEPTS.$1,460,832 $1,340,000 $1,398,998 $2,481,600 $1,677,800 ======================================================== -32.4% Page One 2020 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - May 3, 2019 2020 2019 Object 2020 2016 2017 2018 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 602 49450 101.00 Salaries & Benefits $556,300 Salary, Taxes, PERA & Benefits 602 49450 77 101.00 Administrative 153,926 129,578 202,742 142,900 150,000 ______________________________ 602 49450 78 101.00 Technical/Clerical 158,777 146,843 155,870 165,800 175,200 1 Additional Finance Position 602 49450 79 101.00 Maintenance 171,036 171,054 180,248 184,800 231,100 Add Utility FTE Split with 601, 603 602 49450 xx 101.00 Salary & Benefit Contingency 0 0 0 0 0 ______________________________ 602 49450 102.00 Full-Time Overtime 12,552 10,140 13,549 7,500 7,500 ______________________________ 602 49450 103.00 Part-Time Salaries & Benefits 7,558 7,346 7,803 7,700 8,700 ______________________________ 602 49450 99 103.xx Utility Commission Wages (1/3)700 ______________________________ 602 49450 99 103.xx Maintenance Labor 8,000 Seasonal Employees and Interns 602 49450 01 203.00 Printed Forms & Paper 1,067 504 1,092 100 100 Outsource Bill Printing (313.00) 602 49450 01 205.00 Plotter Ink & Paper 0 0 0 400 400 ______________________________ 602 49450 01 209.00 Other Office Supplies 0 114 198 200 200 ______________________________ 602 49450 01 212.00 Motor Fuels 0 5,200 5,100 3,100 3,100 2% Covered by Sewer Utility 602 49450 01 216.00 Chemicals & Chemical Products 0 0 98 500 500 Root Killer, Degreaser 602 49450 01 219.00 Other Operating Supplies 60 418 147 200 200 ______________________________ 602 49450 01 224.00 Street Maintenance Materials 0 1,743 2,010 2,500 2,500 Patching 602 49450 01 225.00 Landscaping Materials 285 0 0 400 400 Topsoil, Seed & Sod 602 49450 01 227.00 Utility System Maintenance Supplies 5,454 2,132 1,443 5,000 5,000 MH Castings Replacement Prog. 602 49450 01 240.00 Safety Equipment & PPE 500 Vests, Glasses, Hardhats, Etc. 602 49450 01 241.00 Small Tools 641 701 486 1,000 1,000 Wrenches, Shovels, etc. 602 49450 01 242.00 Minor Equipment 4,500 2,551 3,758 3,000 3,000 ______________________________ 602 49450 01 303.00 Engineering Fees 11,000 ______________________________ 602 49450 01 303.01 GIS 1,920 2,476 78 3,000 1,000 $5000 split 5 ways 602 49450 01 303.02 Rate Study 0 0 7,074 5,000 5,000 ______________________________ 602 49450 01 303.04 Miscellaneous 11,737 143 13,523 5,000 5,000 ______________________________ 602 49450 01 312.00 Gopher State One-Call 1,602 1,683 1,436 2,500 2,500 $7,500 Split 3 Ways 602 49450 01 313.00 Outsource Bill Printing/Mailing 0 0 2,201 8,300 8,300 ______________________________ 602 49450 01 318.00 Contract Engineer 16,174 22,602 0 0 0 ______________________________ 602 49450 01 319.00 Other Professional Services 61,500 ______________________________ 602 49450 01 319.01 Televising 0 0 51,859 53,000 53,000 3-Year 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 0 0 0 0 0 ______________________________ 602 49450 01 319.xx Landscape Maintenance 0 0 0 0 1,500 At Lift Stations 602 49450 01 320.00 Credit Card Activity Fees 6,097 6,064 7,767 7,000 8,500 1/3 Cost of C/C Pymt Processing 602 49450 01 321.00 Telephone Costs 3,376 3,085 3,540 3,500 5,000 Cell Phones, Modems, GPS 602 49450 01 322.00 Postage Costs 4,186 4,002 2,881 100 400 Outsource Mailing (313.00) 602 49450 01 323.00 Radio Units 1,390 5,777 6,082 7,100 7,100 (24x$300) ($28,000) (Split 5 Ways) 602 49450 01 365.00 Workers Comp Insurance 10,071 12,175 13,482 12,000 12,000 Sewer's Share of Premiums 602 49450 01 369.00 Other Insurance 14,971 13,858 12,322 17,000 17,000 Sewer's Share of Premiums 602 49450 01 391.00 P.C. Maintenance 2,900 ______________________________ 602 49450 01 391.01 U/B Software Maintenance 2,117 2,177 2,159 2,200 2,200 Added to Utility Budgets in 2012 602 49450 01 391.02 Auto Read Software Support 613 631 650 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,306 0 1,967 3,000 3,000 $1,100 Intern GPS ($3,300 shared) 602 49450 01 394.00 P.C. Software Purchases 11,000 ______________________________ 602 49450 01 394.01 Licensing & Maintenance 4,629 10,129 8,954 10,000 10,500 ESRI, Cartegraph, DataLink 602 49450 01 394.02 Online Subscriptions 0 234 234 300 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 0 ______________________________ 602 49450 01 403.00 Contracted R & M - Other Impr 10,016 28,476 32,014 70,000 70,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 1,428 400 2,000 2,000 ______________________________ 602 49450 01 433.00 Dues & Subscriptions 0 0 49 200 300 SUSA Split w/603 602 49450 01 435.00 Books & Pamphlets 0 0 0 300 300 Reference Materials 602 49450 01 437.00 Conferences & Seminars 4,000 ______________________________ 602 49450 01 437.01 MPCA Training (Sewer School)686 920 1,193 2,500 2,500 Operator Licensure $400 each (M) 602 49450 01 437.03 CarteGraph, ESRI, GIS 81 131 607 500 500 User Group, Conference, Training 602 49450 01 437.04 Miscellaneous Training 919 160 400 1,000 1,000 ______________________________ 602 49450 01 439.00 Other Miscellaneous Charges 86 106 85 300 300 Contingencies 602 49450 01 521.00 Building & Structure Purchases 0 0 0 0 0 Final Payment in 2018 602 49450 01 530.00 Improvements Other Than Bldgs 350,000 ______________________________ 602 49450 01 530.01 Miscellaneous Improvements 0 0 0 70,000 200,000 SCADA, PLC's, 2 LS Cabinets 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 0 0 0 132,500 0 Jetter (Split with 603) 602 49450 01 550.00 Motor Vehicle Purchases 0 11,436 0 31,500 4,700 Vehicle Leases 602 49450 01 560.00 Furniture & Fixture Purchases 0 0 0 500 500 ______________________________ 602 49450 01 570.00 Office Equipment Purchases 271 0 0 500 500 ______________________________ 602 49450 01 580.00 Other Equipment Purchases 0 0 24,754 30,000 0 Portable Generator (Split 3 Ways) ---------------------------------------------------------------------------------------------------- PAGE TOTALS 608,102 606,017 770,255 1,164,700 1,172,600 Page Two 2020 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - May 3, 2019 2020 2019 Object 2020 2016 2017 2018 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 602 49450 01 602.00 Sewer Service Charges 1,185,397 1,284,544 1,300,125 1,304,000 1,390,000 MWCC Chgs (Matches Rate Model) 602 49450 01 611.00 Interest on Lease Payments 1,362 930 476 0 0 P.W. Building Expansion(See 521) 602 49450 01 710.00 Transfers 0 0 65,000 0 0 Transfers for Other Improvements ---------------------------------------------------------------------------------------------------- 602-49450-01 TOTALS 1,794,861 1,891,491 2,135,856 2,468,700 2,562,600 602 49451 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49451 01 221.00 Equipment Parts 3,248 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 49 (0)1,500 3,000 3,000 ______________________________ 602 49451 01 403.00 Contracted R & M - Other Impr 1,931 53,524 0 2,000 2,000 ______________________________ 602 49451 01 439.00 Other Miscellaneous Charges 0 0 0 3,500 100 Radar Control for Pumps in 2019 ---------------------------------------------------------------------------------------------------- (City Hall)TOTAL - LIFT STATION #1 5,227 53,524 1,500 9,600 6,200 602 49452 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49452 01 221.00 Equipment Parts 585 2,024 0 800 800 ______________________________ 602 49452 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49452 01 381.00 Electric Utilities 674 508 540 700 700 ______________________________ 602 49452 01 403.00 Contracted R & M - Other Impr 0 0 412 2,000 2,000 ______________________________ 602 49452 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Bloomfield 5th)TOTAL - LIFT STATION #7 1,259 2,531 952 3,900 3,900 602 49453 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49453 01 221.00 Equipment Parts 585 2,439 0 800 800 ______________________________ 602 49453 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49453 01 381.00 Electric Utilities 4,165 3,464 3,393 4,000 4,000 ______________________________ 602 49453 01 403.00 Contracted R & M - Other Impr 7,951 0 13,482 2,000 2,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 12,701 5,903 16,874 7,200 7,200 602 49454 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49454 01 221.00 Equipment Parts 585 0 0 800 800 ______________________________ 602 49454 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49454 01 381.00 Electric Utilities 6,110 5,632 5,583 6,000 6,000 ______________________________ 602 49454 01 403.00 Contracted R & M - Other Impr 0 0 0 2,000 2,000 Submersible Pumps Paid 2019 602 49454 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Hawkins)TOTAL - LIFT STATION #4 6,695 5,632 5,583 9,200 9,200 602 49455 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49455 01 221.00 Equipment Parts 585 376 2,611 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,081 5,225 5,418 6,000 6,000 ______________________________ 602 49455 01 403.00 Contracted R & M - Other Impr 0 398 3,109 2,000 2,000 ______________________________ 602 49455 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Birger Pond)TOTAL - LIFT STATION #5 5,666 5,998 11,139 9,200 9,200 602 49456 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49456 01 221.00 Equipment Parts 585 0 0 800 800 ______________________________ 602 49456 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49456 01 381.00 Electric Utilities 3,829 6,170 4,710 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 4,414 6,170 4,710 9,200 9,200 Page Three 2020 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - May 3, 2019 2020 2019 Object 2020 2016 2017 2018 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 602 49457 01 219.00 Other Operating Supplies 0 0 3,170 100 100 Bubbler in 2018 602 49457 01 221.00 Equipment Parts 585 628 2,707 500 500 ______________________________ 602 49457 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49457 01 381.00 Electric Utilities 688 1,350 1,427 1,200 1,200 ______________________________ 602 49457 01 403.00 Contracted R & M - Other Impr 0 0 1,605 2,000 2,000 ______________________________ 602 49457 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Glendalough 5th)TOTAL - LIFT STATION #9 1,273 1,979 8,909 4,100 4,100 602 49458 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49458 01 221.00 Equipment Parts 585 1,395 0 500 500 ______________________________ 602 49458 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49458 01 381.00 Electric Utilities 519 460 461 800 800 ______________________________ 602 49458 01 403.00 Contracted R & M - Other Impr 0 1,414 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 1,105 3,270 461 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 585 0 0 500 500 ______________________________ 602 49460 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49460 01 381.00 Electric Utilities 257 266 325 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 843 266 325 3,300 3,300 602 49461 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49461 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 602 49461 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49461 01 381.00 Electric Utilities 0 0 0 400 400 ______________________________ 602 49461 01 403.00 Contracted R & M - Other Impr 0 0 0 2,000 2,000 ______________________________ 602 49461 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Meadow Ridge - Temp)TOTAL - LIFT STATION #11 0 0 0 3,300 3,300 602 49462 01 219.00 Other Operating Supplies 0 0 0 0 100 ______________________________ 603 49462 01 221.00 Equipment Parts 0 0 0 0 500 ______________________________ 604 49462 01 229.00 Other Maintenance Supplies 0 0 0 0 200 ______________________________ 605 49462 01 381.00 Electric Utilities 0 0 0 0 400 ______________________________ 606 49462 01 403.00 Contracted R & M - Other Impr 0 0 0 0 2,000 ______________________________ 607 49462 01 439.00 Other Miscellaneous Charges 0 0 0 0 100 Contingencies ---------------------------------------------------------------------------------------------------- (Bella Vista 6 - Temp)TOTAL - LIFT STATION #11 0 0 0 0 3,300 GRAND TOTAL - ALL DEPTS.$1,834,044 $1,976,766 $2,186,309 $2,531,400 $2,625,200 ===================================================== 3.7% Page One 2020 BUDGET WORKSHEETS STORM WATER UTILITY - EXPENDITURES - May 3, 2019 2020 2019 Object 2020 2016 2017 2018 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 603 49500 101.00 Salaries & Benefits $521,900 Salary, Taxes, PERA & Benefits 603 49500 77 101.00 Administrative 47,765 21,966 77,299 129,800 136,500 ______________________________ 603 49500 78 101.00 Technical/Clerical 78,418 84,524 89,040 122,900 227,600 1 Additional Finance Position 603 49500 79 101.00 Maintenance 85,519 98,552 107,093 112,700 157,800 Add Utility FTE Split with 601, 602 603 49500 78 101.00 Salary & Benefits 0 0 0 115,000 0 New Position for 2019 603 49500 xx 101.00 Salary & Benefit Contingency 0 0 0 0 0 ______________________________ 603 49500 102.00 Full-Time Overtime 6,300 5,114 7,705 6,000 6,000 ______________________________ 603 49500 99 103.00 Part-Time Salaries & Benefits 7,672 7,207 8,345 7,700 8,700 ______________________________ 603 49500 99 103.xx Utility Commission Wages (1/3)700 ______________________________ 603 49500 99 103.xx Maintenance Labor 8,000 Seasonal Employees and Interns 603 49500 01 203.00 Printed Forms & Paper 1,067 504 1,092 100 100 Outsource Bill Printint (313.00) 603 49500 01 205.00 Plotter Ink & Paper 0 0 0 400 400 ______________________________ 603 49500 01 208.00 Miscellaneous Supplies 143 350 86 500 500 Stakes, Ribbons, Level, etc. 603 49500 01 212.00 Motor Fuels 0 6,200 6,000 4,700 4,700 3% Covered by Storm Utility 603 49500 01 224.00 Street Maintenance Materials 0 2,140 5,241 2,500 3,000 Patching Material for Washouts 603 49500 01 225.00 Landscaping Materials 4,000 ______________________________ 603 49500 01 225.01 Rip-Rap, Matting, Rock, etc.9,076 1,553 973 3,000 3,000 ______________________________ 603 49500 01 225.02 Black Dirt, Seed, Sod, etc.5,376 900 945 1,000 1,000 ______________________________ 603 49500 01 226.00 Sign Repair Materials 0 257 160 500 3,000 Buffer Signs, Offset by Revenue 603 49500 01 230.00 Repair Materials & Supplies 3,489 1,359 1,418 3,000 3,000 Culverts, Catch Basins, Structures 603 49500 01 240.00 Safety Equipment & PPE 500 Vests, Glasses, Hardhats, Etc. 603 49500 01 241.00 Small Tools 373 176 1,211 1,000 1,500 ______________________________ 603 49500 01 242.00 Minor Equipment 5,687 2,238 1,286 2,500 7,500 2 Hose Docks in 2020 603 49500 01 303.00 Engineering Fees 23,000 ______________________________ 603 49500 01 303.01 Problem Area Investigations 0 0 0 5,000 5,000 ______________________________ 603 49500 01 303.02 NPDES Phase II 48,942 7,377 8,202 5,000 5,000 ______________________________ 603 49500 01 303.03 CSMP Update 5,055 0 69,832 2,000 2,000 ______________________________ 603 49500 01 303.04 Miscellaneous 54,291 10,921 34,730 10,000 10,000 ______________________________ 603 49500 01 303.05 GIS 1,280 1,651 52 2,000 1,000 $5000 split 5 ways 603 49500 01 304.00 Legal Fees 0 0 1,886 2,000 2,000 ______________________________ 603 49500 01 310.00 Testing Services 0 0 0 1,000 0 Water Quality Tests (M) 603 49500 01 312.00 Gopher State One-Call 1,602 1,684 1,436 2,500 2,500 $7,500 Split 3 Ways 603 49500 01 313.00 Outsource Bill Printing/Mailing 0 0 2,201 8,300 8,300 ______________________________ 603 49500 01 315.00 Special Programs 6,031 5,867 6,437 7,000 5,000 WHEP 603 49500 01 318.00 Contract Engineer 16,174 26,927 0 0 0 ______________________________ 603 49500 01 319.00 Other Professional Services 6,500 ______________________________ 603 49500 01 319.01 SCADA 0 0 0 5,000 5,000 ______________________________ 603 49500 01 319.02 Buxton Project 0 0 0 0 0 ______________________________ 603 49500 01 319.xx Landscape Maintenance 0 0 0 0 1,500 At Lift Stations 603 49500 01 320.00 Credit Card Activity Fees 6,097 6,064 7,767 7,000 8,500 1/3 Cost of C/C Pymt Processing 603 49500 01 321.00 Telephone Costs 3,376 3,086 3,541 3,500 5,000 Cell Phones, Modems, GPS 603 49500 01 322.00 Postage Costs 4,186 4,002 2,853 100 400 Outsource Mailing (313.00) 603 49500 01 323.00 Radio Units 1,390 5,777 6,082 7,100 7,100 (24x$300) ($28,000) (Split 5 Ways) 603 49500 01 352.00 General Notices & Public Info 0 35 0 1,000 1,000 ______________________________ 603 49500 01 365.00 Workers Comp Insurance 4,624 6,287 7,647 6,000 6,000 Storm Water's Share of Premiums 603 49500 01 369.00 Other Insurance 1,506 1,734 1,746 2,500 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,117 2,177 2,159 2,200 2,200 ______________________________ 603 49500 01 391.02 Auto Read Software Support 613 631 650 700 700 ______________________________ 603 49500 01 393.00 P.C. Hardware Purchases 1,306 0 1,967 3,000 3,000 $1,100 Intern GPS ($3,300 shared) 603 49500 01 394.00 P.C. Software Purchases 11,000 ______________________________ 603 49500 01 394.01 Licensing & Maintenance 4,628 10,119 8,954 10,000 10,500 ESRI, Cartegraph, DataLink 603 49500 01 394.02 Online Subscriptions 0 234 234 300 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 130,000 ______________________________ 603 49500 01 403.01 Ditching 0 12,609 1,008 10,000 10,000 ______________________________ 603 49500 01 403.02 Catch Basins, Manholes, Etc.62,221 111,199 43,322 80,000 120,000 Catch Basins, Manholes, Etc. 603 49500 01 403.03 Pond Inspection & Maintenance 20,000 0 0 0 0 ______________________________ 603 49500 01 405.00 MS4 Permit Compliance 110,000 ______________________________ 603 49500 01 405.01 Engineering Fees 0 38,365 31,594 45,000 45,000 Inspection, GIS, Guidance, Etc. 603 49500 01 405.02 Equipment Rental 0 7,149 0 20,000 20,000 Bulldozer, Large Equipment 603 49500 01 405.03 Dirt, Seed, Rip Rap, Etc.0 786 0 5,000 5,000 For Restoration 603 49500 01 405.04 Contracted Maintenance 0 3,973 3,030 40,000 40,000 Brush Clearing, Dredging 603 49500 01 416.00 Machinery Rental 11,359 2,416 0 2,500 2,500 Pumps 603 49500 01 433.00 Dues & Subscriptions 280 280 49 300 1,500 SUSA Split w/602, MN SW Coalition 603 49500 01 435.00 Books & Pamphlets 0 0 0 500 500 Utility Information 603 49500 01 437.00 Conferences & Seminars 3,700 ______________________________ 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 81 131 607 500 500 User Group, Conference, Training 603 49500 01 437.05 Miscellaneous Training 864 0 430 2,000 2,000 ______________________________ 603 49500 01 439.00 Other Miscellaneous Charges 159 106 360 300 300 ______________________________ ------------------------------------------------------------------------------------------------------ PAGE TOTALS 509,066 504,625 556,668 814,000 908,000 Page Two 2020 BUDGET WORKSHEETS STORM WATER UTILITY - EXPENDITURES - May 3, 2019 2020 2019 Object 2020 2016 2017 2018 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 603 49500 01 530.00 Improvements Other Than Bldgs 200,000 ______________________________ 603 49500 01 530.01 CRP of Storm Sewer 4,982 3,704 0 60,000 60,000 ______________________________ 603 49500 01 530.02 Stormwater System Improvements 0 0 0 0 140,000 ______________________________ 603 49500 01 540.00 Heavy Machinery Purchases 0 99,350 31,714 132,500 170,500 Side Flail Mower, Sweeper 603 49500 01 550.00 Motor Vehicle Purchases 0 20,226 0 31,500 4,700 Vehicle Leases 603 49500 01 560.00 Furniture & Fixture Purchases 0 0 0 500 500 ______________________________ 603 49500 01 580.00 Other Equipment Purchases 1,690 0 24,754 30,000 12,000 Hose Trailer in 2020 603 49500 01 586.00 Computer Equipment Purchases 0 0 81 500 500 ______________________________ 603 49500 01 710.00 Transfers 0 ______________________________ 603 49500 01 710.06 1/2 of 2018 P & I Payments(2010A)50,000 32,000 0 0 0 Final Payment 2/1/18 603 49500 01 710.10 Projects 537,101 381,317 43,887 0 0 ______________________________ ------------------------------------------------------------------------------------------------------ 603-49500-01 TOTALS 1,102,839 1,041,222 657,105 1,069,000 1,296,200 603 49511 01 221.00 Equipment Parts 0 477 0 500 500 ______________________________ 603 49511 01 381.00 Electric Utilities 291 252 270 500 500 ______________________________ 603 49511 01 403.00 Contracted Repair & Maintenance 0 202 0 1,000 1,000 ______________________________ ------------------------------------------------------------------------------------------------------ (Copper Pond)TOTAL - LIFT STATION #1 291 931 270 2,000 2,000 603 49512 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49512 01 381.00 Electric Utilities 0 0 0 500 500 ______________________________ 603 49512 01 403.00 Contracted Repair & Maintenance 0 0 1,868 1,000 1,000 ______________________________ ------------------------------------------------------------------------------------------------------ (Schwarz Pond)TOTAL - LIFT STATION #2 0 0 1,868 2,000 2,000 603 49513 01 221.00 Equipment Parts 0 0 49 500 500 ______________________________ 603 49513 01 381.00 Electric Utilities 7,106 5,786 6,577 7,200 7,200 ______________________________ 603 49513 01 403.00 Contracted Repair & Maintenance 0 0 0 1,000 1,000 ______________________________ ------------------------------------------------------------------------------------------------------ (Birger Pond)TOTAL - LIFT STATION #3 7,106 5,786 6,626 8,700 8,700 603 49514 01 221.00 Equipment Parts 0 0 65 500 500 ______________________________ 603 49514 01 381.00 Electric Utilities 957 1,542 1,178 2,500 2,500 ______________________________ 603 49514 01 403.00 Contracted Repair & Maintenance 0 0 488 1,000 1,000 ______________________________ ------------------------------------------------------------------------------------------------------ (Marcotte Pond)TOTAL - LIFT STATION #4 957 1,542 1,731 4,000 4,000 603 49515 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49515 01 381.00 Electric Utilities 0 0 0 500 500 ______________________________ 603 49515 01 403.00 Contracted Repair & Maintenance 0 0 0 1,000 1,000 ______________________________ ------------------------------------------------------------------------------------------------------ (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 388 511 416 500 500 ______________________________ 603 49516 01 403.00 Contracted Repair & Maintenance 0 0 0 1,000 1,000 ______________________________ ------------------------------------------------------------------------------------------------------ (Glendalough 7th)TOTAL - LIFT STATION #6 388 511 416 2,000 2,000 603 49517 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49517 01 381.00 Electric Utilities 635 753 551 500 500 ______________________________ 603 49517 01 403.00 Contracted Repair & Maintenance 0 0 0 1,000 1,000 ______________________________ ------------------------------------------------------------------------------------------------------ (Horseshoe Lake)TOTAL - LIFT STATION #7 635 753 551 2,000 2,000 603 49518 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49518 01 381.00 Electric Utilities 0 0 0 500 500 ______________________________ 603 49518 01 403.00 Contracted Repair & Maintenance 0 0 0 1,000 1,000 ______________________________ ------------------------------------------------------------------------------------------------------ (Dunmore)TOTAL - LIFT STATION #8 0 0 0 2,000 2,000 GRAND TOTAL - ALL DEPTS.$1,112,216 $1,050,746 $668,566 $1,093,700 $1,320,900 ====================================================== 20.8%