Loading...
HomeMy WebLinkAbout7.b. 2021 Utility Budgets Table 1 2021 Proposed Fund2020 BudgetChange Budget Water Utility$ 1,679,800.00$ 1,662,800.00-1.0% Sewer Utility$ 2,627,300.00$ 2,629,300.000.1% Storm Utility$ 1,322,700.00$ 1,433,400.008.4% Street Light Utility$ 220,000.00$ 220,000.000.0% TOTAL$ 5,849,800.00$ 5,945,500.001.6% EXECUTIVE SUMMARY Utility Commission Meeting: September 28, 2020 AGENDA SECTION: AGENDA ITEM: 2021 Utility Budgets New Business PREPARED BY: Brian Erickson, P.E. Director of Public AGENDA NO. 7.b. Works/City Engineer ATTACHMENTS: Proposed 2021 Utility Budgets APPROVED BY: BLE RECOMMENDED ACTION: Motion to Recommend City Council Approval of the 2021 Utility Budgets BACKGROUND Attached for the commission’s consideration are the proposed 2021 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. The Water Utility budget is primarily flat for 2021. 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. There was also a decrease in the proposed Metropolitan Council Environmental Services charges for 2021. 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 as well as the stormwater pond maintenance program. A final staff review is scheduled for the end of September and may result in some additional changes to the budgets. These changes are anticipated to be relatively small and as a result will likely not be returned to the Commission for review. Staff will be available at the meeting to answer any questions or concerns. SUMMARY Staff is requesting Utility Commission recommend the City Council approve the proposed 2021 Utility Budgets. C:\\Users\\jab\\AppData\\Local\\Temp\\7.b. 2021 Utility Budgets_614892\\7.b. 2021 Utility Budgets.docx Page One 2021 BUDGET WORKSHEETS WATER UTILITY - REVENUES - May 15, 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 601 33130.00 Federal Grants - CDBG $75,280 $24,956 $0 $0 $0 MCES Water Efficiency Grant 601 33425.00 Other State Grants & Aids 6,762 33,455 720 4,500 4,500 ______________________________ 601 33620.00 Other County Grants & Aids 2,000 0 0 0 0 ______________________________ 601 34107.00 Assessment Fees 0 1,280 21,497 0 0 ______________________________ 601 34108.00 Administrative Fees-Other Funds 5,069 11,796 9,327 6,300 6,300 5% of 5% Fees-Const Projects 601 34109.00 Other Gen'l Govt Chgs for Services 18,050 15,984 17,261 0 0 ______________________________ 601 36101.00 Principal - Special Assessments 55,401 77,288 53,808 55,000 55,000 ______________________________ 601 36102.00 Penalties & Interest - S/A 627 655 719 0 0 ______________________________ 601 36210.00 Interest Earnings - Investments 92,126 149,982 177,969 90,000 90,000 ______________________________ 601 36214.00 Net Change in FV-Investments (3,227)(12,063)39,042 0 0 Annual Market Value Changes 601 36215.00 Interest Earnings 787 1,244 3,358 500 500 ______________________________ 601 36220.00 Rents & Royalties 148,434 154,610 161,211 168,500 168,500 Antenna Leases 601 36260.00 Other Revenues 0 117 0 0 0 ______________________________ 601 36265.00 Use of Reserve Funds 0 0 0 0 0 ______________________________ 601 37110.00 Residential Water Revenues 1,363,923 1,426,360 1,274,288 1,500,000 1,500,000 ______________________________ 601 37120.00 Apartment Water Revenues 108,265 113,851 121,359 120,000 120,000 ______________________________ 601 37125.00 Institutional Water Revenues 84,046 66,183 83,160 70,000 70,000 ______________________________ 601 37130.00 Commercial Water Revenues 90,872 94,093 95,413 100,000 100,000 ______________________________ 601 37140.00 Industrial Water Revenues 139,554 122,071 135,704 130,000 130,000 ______________________________ 601 37160.00 Penalties - Water Revenues 12,286 12,848 12,012 10,000 10,000 ______________________________ 601 37165.00 Meter Maint Water Revenues 0 0 0 0 0 ______________________________ 601 37170.00 Other Water Revenues 0 0 (29,682)0 0 2nd Meter Refunds 601 37180.00 Water Meter Sales Revenue 58,045 87,294 96,658 80,000 80,000 ______________________________ 601 39103.00 Gain or Loss from F/A Disposal (9,885)(426)0 0 0 ______________________________ 601 39203.00 Transfer From______________0 0 0 0 0 ______________________________ ---------------------------------------------------------------------------------------------------------- FUND TOTALS $2,248,416 $2,381,577 $2,273,824 $2,334,800 $2,334,800 ======================================================== Page One 2021 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - May 15, 2020 2021 2020 Object 2021 2017 2018 2019 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 129,584 205,824 162,236 155,500 181,500 ______________________________ 601 49400 78 101.00 Technical/Clerical 146,843 155,870 169,268 177,900 192,000 ______________________________ 601 49400 79 101.00 Maintenance 171,054 180,248 183,174 230,600 188,500 ______________________________ 601 49400 xx 101.00 Salary & Benefit Contingency 0 0 0 0 0 ______________________________ 601 49400 102.00 Full-Time Overtime 10,140 13,549 16,444 8,000 8,000 ______________________________ 601 49400 103.00 Part-Time Salaries & Benefits 5,779 6,916 7,975 8,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 504 1,092 70 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 114 362 134 200 200 ______________________________ 601 49400 01 212.00 Motor Fuels 5,600 5,100 3,912 3,900 3,900 2.5% Covered by Water Utility 601 49400 01 216.00 Chemicals & Chemical Products 55,588 43,035 60,654 75,000 75,000 Chlorine/Flouride/Poly 601 49400 01 219.00 Other Operating Supplies 415 2,053 1,174 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 57,467 71,822 78,315 75,000 75,000 Match Rate Model (Incl. Recycling) 601 49400 01 220.02 For New Homes 42,572 47,296 52,209 75,000 75,000 Match Rate Model, Newland Dev. 601 49400 01 224.00 Street Maintenance Materials 329 1,261 4,769 2,500 2,500 Patching for Breaks 601 49400 01 225.00 Landscaping Materials 323 360 108 1,000 1,000 Topsoil, Seed & Sod 601 49400 01 228.00 Meter Repair Materials 0 222 105 0 0 ______________________________ 601 49400 01 229.00 Other Maintenance Supplies 17,000 ______________________________ 601 49400 01 229.01 Supplies for Hydrants 8,968 8,476 6,939 10,000 10,000 ______________________________ 601 49400 01 229.02 Curb Shutoffs 0 855 0 1,000 1,000 ______________________________ 601 49400 01 229.03 GV Repair/Replacement 934 0 13,526 2,000 2,000 ______________________________ 601 49400 01 229.04 Miscellaneous Supplies 3,247 3,350 685 4,000 4,000 ______________________________ 601 49400 01 240.00 Safety Equipment & PPE 0 0 0 500 500 Vests, Glasses, Hardhats, etc. 601 49400 01 241.00 Small Tools 1,099 2,140 1,782 2,500 2,500 Wrenches, Shovels, etc. 601 49400 01 242.00 Minor Equipment 11,622 8,371 6,052 17,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 21,302 5,000 5,000 Groundwater Plan Implementation 601 49400 01 303.02 GIS 2,476 78 0 1,000 1,000 $5,000 Split 5 Ways 601 49400 01 303.03 Rate Study 0 14,459 19,172 5,000 5,000 ______________________________ 601 49400 01 303.04 Miscellaneous Fees 17,602 2,574 2,745 15,000 15,000 Future Water Facility Study 601 49400 01 304.00 Legal Fees 105 0 1,226 1,000 1,000 ______________________________ 601 49400 01 310.00 Testing Services 83,500 ______________________________ 601 49400 01 310.01 Bacteria & Water Quality 2,269 2,625 3,572 3,500 3,500 Radon, Tri-Chl., Pesticides, Etc. 601 49400 01 310.03 MDH Service Connection Fee 45,928 47,381 49,186 80,000 80,000 53% Increase in Per Connection 601 49400 01 312.00 Gopher State One-Call 1,683 1,436 1,794 2,500 2,500 $7,500 Split 3 Ways 601 49400 01 313.00 Outsource Bill Printing/Mailing 0 2,201 6,618 8,300 8,300 ______________________________ 601 49400 01 318.00 Contract Engineer 22,602 0 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 3,435 0 2,053 5,000 5,000 ______________________________ 601 49400 01 319.03 Hazardous Chemical Permits 725 700 800 1,000 1,000 MN Department of Public Safety 601 49400 01 319.06 Contracted Hydrant Painting 8,265 11,172 9,212 11,000 11,000 ______________________________ 601 49400 01 319.07 Antenna Expenses 3,577 9,209 3,842 20,000 20,000 Offset by Revenue 601-36220.00 601 49400 01 319.08 Buxton Project 0 9 0 0 0 ______________________________ 601 49400 01 319.09 HVAC Maintenance Contract 3,304 0 1,702 4,000 4,000 Annual Insp/Maint, All Wells 601 49400 01 319.10 Landscape Maintenance 0 0 2,655 4,000 4,000 ______________________________ 601 49400 01 319.11 Pest Control 0 0 539 1,000 1,000 ______________________________ 601 49400 01 320.00 Credit Card Activity Fees 6,299 7,767 9,409 8,500 8,500 1/3 Cost of C/C Pymt Processing 601 49400 01 321.00 Telephone Costs 3,230 4,734 4,134 5,000 5,000 Cell Phones, Modesm, GPS 601 49400 01 322.00 Postage Costs 3,767 2,920 369 400 400 Outsource Mailing (313.00) 601 49400 01 323.00 Radio Units 5,777 6,082 6,282 7,100 7,100 (24x$300)($28,000)(Split 5 Ways) 601 49400 01 352.00 General Notices & Public Info 0 0 36 0 0 ______________________________ 601 49400 01 365.00 Workers Comp Insurance 12,311 13,635 13,863 12,000 12,000 Water's Share of Premiums 601 49400 01 369.00 Other Insurance 6,507 6,793 7,249 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,177 2,159 2,372 2,200 2,200 Added to Utility Budgets in 2012 601 49400 01 391.02 Auto Read Software Support 631 650 650 700 700 Added to Utility Budgets in 2012 601 49400 01 392.00 P.C. Accessories & Supplies 108 0 33 200 200 ______________________________ 601 49400 01 393.00 P.C. Hardware Purchases 589 1,967 361 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 10,129 8,954 9,715 10,500 10,500 ESRI, Cartegraph, DataLink 601 49400 01 394.02 Online Subscriptions 234 234 0 300 300 Pictometry 601 49400 01 394.03 New Software Purchases 46 0 983 200 200 ______________________________ ---------------------------------------------------------------------------------------------------------- PAGE TOTALS 815,958 905,941 951,406 1,077,200 1,075,200 Page Two 2021 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - May 15, 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 601 49400 01 403.00 Contracted R & M - Other Impr 24,873 82,681 52,829 80,000 80,000 Main Breaks, Gate Valves, Etc. 601 49400 01 433.00 Dues & Subscriptions 0 327 250 500 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)2,173 1,026 2,066 3,000 3,000 Operator Licensure 601 49400 01 437.02 AWWA Conference 0 1,899 0 2,000 2,000 Duluth, Send 2 Staff 601 49400 01 437.03 CarteGraph, ESRI, GIS 139 607 0 500 500 User Group, Conference, Training 601 49400 01 437.04 Miscellaneous Training 62 20 458 1,000 1,000 ______________________________ 601 49400 01 439.00 Other Miscellaneous Charges 15,328 12,674 11,878 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 0 800 0 1,000 1,000 ______________________________ 601 49400 01 530.02 Miscellaneous Improvements 75,280 81,548 13,156 50,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 85,845 12,835 601,050 100,000 100,000 From Long-Term Plan(Chip in 2019) 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 16,984 6,740 0 0 ______________________________ 601 49400 01 550.00 Motor Vehicle Purchases 11,436 0 43,080 13,100 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 24,754 0 0 0 ______________________________ 601 49400 01 611.00 Interest on Lease Payments 930 476 824 0 0 P.W. Building Expansion(See 521) 601 49400 01 710.00 Transfers 0 0 57,500 0 0 Transfers for Other Improvements ---------------------------------------------------------------------------------------------------------- 601-49400-01 TOTALS 1,032,023 1,142,571 1,741,235 1,399,000 1,397,000 601 49406 01 221.00 Equipment Parts 0 0 379 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 5,585 0 0 1,000 1,000 ______________________________ 601 49406 01 381.00 Electric Utilities 1,573 409 1,846 1,300 1,300 Pumping & Lighting ---------------------------------------------------------------------------------------------------------- TOTAL - PRV 7,158 409 2,225 2,700 2,700 601 49407 01 221.00 Equipment Parts 2,120 3,664 196 1,500 1,500 ______________________________ 601 49407 01 223.00 Building Repair Supplies 32 0 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 25,303 25,629 16,267 33,000 33,000 Pumping, Lighting, Tower Mixer 601 49407 01 409.00 Other Contracted Repairs & Maint 3,665 2,044 4,715 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 3,323 9,184 1,853 2,000 2,000 Standby Generator in 2019 ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #7 34,654 40,733 23,241 39,100 39,100 601 49408 01 221.00 Equipment Parts 1,662 1,139 0 1,500 1,500 ______________________________ 601 49408 01 223.00 Building Repair Supplies 5 0 0 200 200 ______________________________ 601 49408 01 319.00 Other Professional Services 0 0 0 0 0 ______________________________ 601 49408 01 381.00 Electric Utilities 19,484 21,238 19,796 25,000 25,000 Pumping & Lighting 601 49408 01 383.00 Gas Utilities 397 469 365 600 600 Heat Only 601 49408 01 409.00 Other Contracted Repairs & Maint 324 6,959 2,005 2,000 2,000 ______________________________ 601 49408 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #8 21,872 29,804 22,166 29,400 29,400 601 49409 01 221.00 Equipment Parts 10 29 196 1,500 1,500 ______________________________ 601 49409 01 223.00 Building Repair Supplies 0 0 0 200 200 ______________________________ 601 49409 01 319.00 Other Professional Services 0 0 0 0 0 ______________________________ 601 49409 01 381.00 Electric Utilities 31,776 29,288 28,305 32,000 32,000 Pumping & Lighting 601 49409 01 383.00 Gas Utilities 616 766 664 1,500 1,500 Heat Only 601 49409 01 409.00 Other Contracted Repairs & Maint 3,341 2,347 1,719 4,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 35,742 32,430 30,884 39,300 39,300 Page Three 2021 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - May 15, 2020 2021 2020 Object 2021 2017 2018 2019 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 1,926 1,576 6,557 1,000 1,000 ______________________________ 601 49410 01 223.00 Building Repair Supplies 0 18 0 200 200 ______________________________ 601 49410 01 321.00 Telephone Costs 765 765 765 0 0 ______________________________ 601 49410 01 381.00 Electric Utilities 19,551 15,985 14,345 17,000 17,000 Pumping & Lighting 601 49410 01 409.00 Other Contracted Repairs & Maint 67,275 24,817 403 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 89,517 43,162 22,069 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 27 0 434 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 26,035 28,566 24,403 28,000 28,000 Pumping & Lighting 601 49412 01 409.00 Other Contracted Repairs & Maint 18,163 478 8,680 2,000 2,000 ______________________________ 601 49412 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #12 44,225 29,044 33,516 31,800 31,800 601 49414 01 221.00 Equipment Parts 1,348 466 0 1,500 1,500 ______________________________ 601 49414 01 223.00 Building Repair Supplies 0 200 0 200 200 ______________________________ 601 49414 01 319.00 Other Professional Services 0 0 0 1,000 1,000 ______________________________ 601 49414 01 381.00 Electric Utilities 25,708 29,869 19,012 28,000 28,000 Pumping & Lighting 601 49414 01 409.00 Other Contracted Repairs & Maint 666 622 27,476 2,000 2,000 ______________________________ 601 49414 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #14 27,722 31,157 46,488 32,800 32,800 601 49425 01 221.00 Equipment Parts 0 564 559 1,500 1,500 ______________________________ 601 49425 01 223.00 Building Repair Supplies 0 200 28 200 200 ______________________________ 601 49425 01 319.00 Other Professional Services 0 0 0 500 500 ______________________________ 601 49425 01 381.00 Electric Utilities 35,410 28,224 17,999 30,000 30,000 Pumping & Lighting 601 49425 01 409.00 Other Contracted Repairs & Maint 0 7,333 1,742 2,000 2,000 ______________________________ 601 49425 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #15 35,410 36,321 20,327 34,300 34,300 601 49426 01 221.00 Equipment Parts 0 726 260 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 5,368 22,821 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 978 1,000 1,000 ______________________________ 601 49426 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #16 0 6,094 24,059 31,300 31,300 Page Four 2021 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - May 15, 2020 2021 2020 Object 2021 2017 2018 2019 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 149 130 7,390 500 500 ______________________________ 601 49415 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WATER TOWER #1 149 130 7,390 1,200 1,200 (Chippendale Water Tower) 601 49416 01 221.00 Equipment Parts 0 114 10 500 500 ______________________________ 601 49416 01 319.00 Other Professional Services 0 0 0 0 0 ______________________________ 601 49416 01 381.00 Electric Utilities 2,274 1,770 2,675 4,500 4,500 ______________________________ 601 49416 01 409.00 Other Contracted Repairs & Maint 303 0 4,884 500 500 ______________________________ 601 49416 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WATER TOWER #2 2,577 1,884 7,569 5,700 5,700 (Connemara Water Tower) 601 49417 01 221.00 Equipment Parts 0 0 10 500 500 ______________________________ 601 49417 01 319.00 Other Professional Services 0 0 0 0 0 ______________________________ 601 49417 01 381.00 Electric Utilities 2,999 2,822 1,881 6,000 6,000 ______________________________ 601 49417 01 409.00 Other Contracted Repairs & Maint 0 285 1,052 500 500 ______________________________ 601 49417 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WATER TOWER #4 2,999 3,107 2,943 7,200 7,200 (Bacardi Water Tower) 601 49418 01 221.00 Equipment Parts 103 164 0 500 500 ______________________________ 601 49418 01 319.00 Other Professional Services 2,800 0 0 0 0 ______________________________ 601 49418 01 381.00 Electric Utilities 2,496 1,989 1,867 4,000 4,000 ______________________________ 601 49418 01 409.00 Other Contracted Repairs & Maint 553 0 0 500 500 ______________________________ 601 49418 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WATER TOWER #3 5,952 2,153 1,867 5,200 5,200 (East Side Water Tower) GRAND TOTAL - ALL DEPTS.$1,340,000 $1,398,998 $1,985,978 $1,679,800 $1,677,800 ======================================================== Page One 2021 BUDGET WORKSHEETS SEWER UTILITY - REVENUES - August 4, 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------- ----------------------------------------------------------------- ----------------- ----------------- ----------------- --------------- ----------------- --------------------------------------------------- 602 33425.00 Other State Grants & Aids $0 $0 $712 $0 $0 ______________________________ 602 34108.00 Administrative Fees-Other Funds 5,069 11,796 9,327 6,300 6,300 5% of 5% Fees-Const Projects 602 36101.00 Principal - Special Assessments 75,330 75,927 74,262 80,000 75,000 ______________________________ 602 36102.00 Penalties & Interest - S/A 723 133 976 0 0 ______________________________ 602 36210.00 Interest Earnings - Investments 21,939 21,667 35,973 18,000 20,000 ______________________________ 602 36214.00 Net Change in FV-Investments (8,755) (2,081) 9,532 0 0 Annual Market Value Changes 602 36215.00 Interest Earnings 411 1,074 2,454 200 1,000 ______________________________ 602 36260.00 Other Revenues 0 58 0 0 0 ______________________________ 602 36265.00 Use of Reserve Funds 0 0 0 528,800 417,300 ______________________________ 602 37210.00 Residential Sewer Revenues 1,520,830 1,527,302 1,462,480 1,600,000 1,600,000 ______________________________ 602 37220.00 Apartment Sewer Revenues 134,668 145,502 185,515 150,000 190,000 ______________________________ 602 37225.00 Institutional Sewer Revenues 27,594 27,319 30,960 30,000 35,000 ______________________________ 602 37230.00 Commercial Sewer Revenues 76,385 86,942 104,954 90,000 110,000 ______________________________ 602 37240.00 Industrial Sewer Revenues 88,461 100,300 153,486 110,000 160,000 ______________________________ 602 37260.00 Penalties - Sewer Revenues 13,768 15,175 15,648 14,000 15,000 ______________________________ 602 39103.00 Gain or Loss from F/A Disposal (4,159) 0 0 0 0 ______________________________ 602 39203.00 Transfer From_______________0000 0______________________________ ----------------- ----------------- ----------------- ----------------- --------------- ----------------- FUND TOTALS $1,952,265 $2,011,115 $2,086,280 $2,627,300 $2,629,600 ========= ========= ========= ========= ======== ========= Page One 2021 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - August 4, 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------- ----------------------------------------------------------------- ----------------- ----------------- ----------------- --------------- ----------------- --------------------------------------------------- All Salary Costs Inclusive of 602 49450 101.00 Salaries & Benefits $541,500 Salary, Taxes, PERA & Benefits 602 49450 77 101.00 Administrative 129,578 202,742 154,976 149,900 175,400 ______________________________ 602 49450 78 101.00 Technical/Clerical 146,843 155,870 169,268 177,900 198,800 Added P/T GIS Technician 602 49450 79 101.00 Maintenance 171,054 180,248 183,175 230,600 167,300 ______________________________ 602 49450 xx 101.00 Salary & Benefit Contingency 0000 0______________________________ 602 49450 102.00 Full-Time Overtime 10,140 13,549 16,444 7,500 7,500 ______________________________ 602 49450 103.00 Part-Time Salaries & Benefits 7,346 7,803 8,479 8,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 504 1,092 0 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 114 198 25 200 200 ______________________________ 602 49450 01 212.00 Motor Fuels 5,200 5,100 3,100 3,100 3,100 2% Covered by Sewer Utility 602 49450 01 216.00 Chemicals & Chemical Products 0 98 0 500 500 Root Killer, Degreaser 602 49450 01 219.00 Other Operating Supplies 418 147 549 200 200 ______________________________ 602 49450 01 224.00 Street Maintenance Materials 1,743 2,010 2,113 2,500 2,500 Patching 602 49450 01 225.00 Landscaping Materials 0 0 0 400 400 Topsoil, Seed & Sod 602 49450 01 227.00 Utility System Maintenance Supplies 2,132 1,443 1,894 5,000 5,000 MH Castings Stock 602 49450 01 240.00 Safety Equipment & PPE 0 0 0 500 500 Vests, Glasses, Hardhats, etc. 602 49450 01 241.00 Small Tools 701 486 635 1,000 1,000 Wrenches, Shovels, etc. 602 49450 01 242.00 Minor Equipment 2,551 3,758 2,741 3,000 4,000 Locator in 2021 602 49450 01 303.00 Engineering Fees 6,000 ______________________________ 602 49450 01 303.01 GIS 2,476 78 0 1,000 1,000 $5,000 Split 5 Ways 602 49450 01 303.02 Rate Study 0 7,074 34,043 5,000 0 ______________________________ 602 49450 01 303.04 Miscellaneous 143 13,523 13,569 5,000 5,000 ______________________________ 602 49450 01 312.00 Gopher State One-Call 1,683 1,436 1,794 2,500 2,500 $7,500 Split 3 Ways 602 49450 01 313.00 Outsource Bill Printing/Mailing 0 2,201 6,618 8,300 8,300 ______________________________ 602 49450 01 318.00 Contract Engineer 22,602 0 0 0 0 ______________________________ 602 49450 01 319.00 Other Professional Services 65,000 ______________________________ 602 49450 01 319.01 Televising 0 51,859 56,634 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 818 5,000 5,000 SCADA System 602 49450 01 319.04 Lift Station Inspection 00003,500 Pump Inspection at All Lift Stations 602 49450 01 319.05 Landscape Maintenance 0 0 0 1,500 1,500 At Lift Stations 602 49450 01 320.00 Credit Card Activity Fees 6,064 7,767 9,409 8,500 9,500 1/3 Cost of C/C Pymt Processing 602 49450 01 321.00 Telephone Costs 3,085 3,540 3,819 5,000 5,000 Cell Phones, Modems, GPS 602 49450 01 322.00 Postage Costs 4,002 2,881 310 400 400 Outsource Mailing (313.00) 602 49450 01 323.00 Radio Units 5,777 6,082 6,282 7,100 1,000 ______________________________ 602 49450 01 365.00 Workers Comp Insurance 12,175 13,482 13,717 12,000 12,000 Sewer's Share of Premiums 602 49450 01 369.00 Other Insurance 13,858 12,322 11,006 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,177 2,159 2,372 2,200 2,200 Added to Utility Budgets in 2012 602 49450 01 391.02 Auto Read Software Support 631 650 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 0 1,967 361 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 10,129 8,954 9,715 10,500 10,500 ESRI, Cartegraph, DataLink 602 49450 01 394.02 Online Subscriptions 234 234 0 300 300 Pictometry 602 49450 01 394.03 New Software Purchases 0 0 983 200 200 ______________________________ 602 49450 01 395.00 P.C. Repairs 0000 0______________________________ 602 49450 01 403.00 Contracted R & M - Other Impr 28,476 32,014 11,769 70,000 70,000 MH Castings Replacement Program 602 49450 01 415.00 Other Equipment Rental 0 0 0 200 200 ______________________________ 602 49450 01 416.00 Machinery Rental 1,428 400 518 2,000 2,000 ______________________________ 602 49450 01 433.00 Dues & Subscriptions 0 49 127 300 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) 920 1,193 803 2,500 2,500 Operator Licensure $400 each (M) 602 49450 01 437.03 CarteGraph, ESRI, GIS 131 607 0 500 500 User Group, Conference, Training 602 49450 01 437.04 Miscellaneous Training 160 400 496 1,000 1,000 ______________________________ 602 49450 01 439.00 Other Miscellaneous Charges 106 85 126 300 300 Contingencies 602 49450 01 521.00 Building & Structure Purchases 0000 0 Final Payment in 2018 602 49450 01 530.00 Improvements Other Than Bldgs 450,000 ______________________________ 602 49450 01 530.01 Miscellaneous Improvements 0 0 7,695 200,000 300,000 SCADA, PCL's, 2 L/S Cabinets,Birge 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 4,538 0 0 Jetter (Split with 603) 602 49450 01 550.00 Motor Vehicle Purchases 11,436 0 43,090 4,700 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 0 0 0 500 500 ______________________________ 602 49450 01 580.00 Other Equipment Purchases 0 24,754 0 0 0 Portable Generator (Split 3 Ways) ----------------- ----------------- ----------------- ----------------- --------------- ----------------- PAGE TOTALS 606,017 770,255 784,663 1,174,700 1,252,200 Page Two 2021 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - August 4, 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------- ----------------------------------------------------------------- ----------------- ----------------- ----------------- --------------- ----------------- --------------------------------------------------- 602 49450 01 602.00 Sewer Service Charges 1,284,544 1,300,125 1,303,112 1,390,000 1,311,700 MWCC Chgs (Matches Rate Model) 602 49450 01 611.00 Interest on Lease Payments 930 476 0 0 0 P.W. Building Expansion(See 521) 602 49450 01 710.00 Transfers 0 65,000 0 0 0 Transfers for Other Improvements ----------------- ----------------- ----------------- ----------------- --------------- ----------------- 602-49450-01 TOTALS 1,891,491 2,135,856 2,087,775 2,564,700 2,563,900 602 49451 01 219.00 Other Operating Supplies 0 0 0 100 3,200 Second Bubbler 602 49451 01 221.00 Equipment Parts 0 0 760 800 800 ______________________________ 602 49451 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49451 01 303.00 Engineering Fees 0000 0______________________________ 602 49451 01 381.00 Electric Utilities (0) 1,500 2,750 3,000 3,000 ______________________________ 602 49451 01 403.00 Contracted R & M - Other Impr 53,524 0 0 2,000 2,000 ______________________________ 602 49451 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 ______________________________ ----------------- ----------------- ----------------- ----------------- --------------- ----------------- (City Hall) TOTAL - LIFT STATION #1 53,524 1,500 3,510 6,200 9,300 602 49452 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49452 01 221.00 Equipment Parts 2,024 0 3,361 800 800 ______________________________ 602 49452 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49452 01 381.00 Electric Utilities 508 540 417 700 700 ______________________________ 602 49452 01 403.00 Contracted R & M - Other Impr 0 412 471 2,000 2,000 ______________________________ 602 49452 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ----------------- ----------------- ----------------- ----------------- --------------- ----------------- (Bloomfield 5th) TOTAL - LIFT STATION #7 2,531 952 4,249 3,900 3,900 602 49453 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49453 01 221.00 Equipment Parts 2,439 0 3,694 800 800 ______________________________ 602 49453 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49453 01 381.00 Electric Utilities 3,464 3,393 3,572 4,000 4,000 ______________________________ 602 49453 01 403.00 Contracted R & M - Other Impr 0 13,482 27,983 2,000 2,000 Safety Improvements in 2018 602 49453 01 439.00 Other Miscellaneous Charges 0 0 568 100 100 Contingencies ----------------- ----------------- ----------------- ----------------- --------------- ----------------- (Shannon Pond) TOTAL - LIFT STATION #3 5,903 16,874 35,817 7,200 7,200 602 49454 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49454 01 221.00 Equipment Parts 0 0 0 800 800 ______________________________ 602 49454 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49454 01 381.00 Electric Utilities 5,632 5,583 5,612 6,000 6,000 ______________________________ 602 49454 01 403.00 Contracted R & M - Other Impr 0 0 142 2,000 2,000 ______________________________ 602 49454 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ----------------- ----------------- ----------------- ----------------- --------------- ----------------- (Hawkins) TOTAL - LIFT STATION #4 5,632 5,583 5,754 9,200 9,200 602 49455 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49455 01 221.00 Equipment Parts 376 2,611 0 800 800 ______________________________ 602 49455 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49455 01 303.00 Engineering Fees 0000 0______________________________ 602 49455 01 310.00 Testing Services 0000 0______________________________ 602 49455 01 381.00 Electric Utilities 5,225 5,418 5,062 6,000 6,000 ______________________________ 602 49455 01 403.00 Contracted R & M - Other Impr 398 3,109 2,658 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 5,998 11,139 7,720 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 0 800 800 ______________________________ 602 49456 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49456 01 381.00 Electric Utilities 6,170 4,710 6,360 6,000 6,000 ______________________________ 602 49456 01 403.00 Contracted R & M - Other Impr 0 0 415 2,000 2,000 ______________________________ 602 49456 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ----------------- ----------------- ----------------- ----------------- --------------- ----------------- (Drumcliffe) TOTAL - LIFT STATION #6 6,170 4,710 6,775 9,200 9,200 Page Three 2021 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - August 4, 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------- ----------------------------------------------------------------- ----------------- ----------------- ----------------- --------------- ----------------- --------------------------------------------------- 602 49457 01 219.00 Other Operating Supplies 0 3,170 0 100 100 Bubbler in 2018 602 49457 01 221.00 Equipment Parts 628 2,707 12 500 500 ______________________________ 602 49457 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49457 01 381.00 Electric Utilities 1,350 1,427 1,371 1,200 1,200 ______________________________ 602 49457 01 403.00 Contracted R & M - Other Impr 0 1,605 5,410 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,979 8,909 6,793 4,100 4,100 602 49458 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49458 01 221.00 Equipment Parts 1,395 0 0 500 500 ______________________________ 602 49458 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49458 01 381.00 Electric Utilities 460 461 421 800 800 ______________________________ 602 49458 01 403.00 Contracted R & M - Other Impr 1,414 0 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 3,270 461 421 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 0 500 500 ______________________________ 602 49460 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49460 01 381.00 Electric Utilities 266 325 339 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 266 325 339 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 100 100 ______________________________ 602 49462 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 602 49462 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49462 01 381.00 Electric Utilities 0 0 0 400 400 ______________________________ 602 49462 01 403.00 Contracted R & M - Other Impr 0 0 0 2,000 2,000 ______________________________ 602 49462 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ----------------- ----------------- ----------------- ----------------- --------------- ----------------- (Bella Vista 6th-Temp) TOTAL - LIFT STATION #12 0 0 0 3,300 3,300 GRAND TOTAL - ALL DEPTS. $1,976,766 $2,186,309 $2,159,154 $2,627,300 $2,629,600 ========= ========= ========= ========= ======== ========= Page One 2021 BUDGET WORKSHEETS STORM WATER UTILITY - REVENUES - May 15, 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------- --------------------------------------------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- --------------------------------------------------- 603 33400.00 State Grants & Aids $0 $0 $596 $0 $0 ______________________________ 603 33425.00 Other State Grants & Aids 0000 0______________________________ 603 33620.00 Other County Grants & Aids 0 0 125 0 0 ______________________________ 603 34108.00 Administrative Fees-Other Funds 5,069 11,796 9,327 6,300 6,300 5% of 5% Fees-Const Projects 603-34115.00 Buffer Monumentation 0 0 1,800 3,000 3,000 ______________________________ 603 36101.00 Principal - Special Assessments 28,871 25,339 23,418 25,000 25,000 ______________________________ 603 36102.00 Penalties & Interest - S/A 155 157 366 0 0 ______________________________ 603 36210.00 Interest Earnings - Investments 46,134 77,293 126,227 35,000 35,000 ______________________________ 603 36214.00 Net Change in FV-Investments (3,777) (2,708) (2,944) 0 0 Annual Market Value Changes 603 36215.00 Interest Earnings 309 857 3,826 300 300 ______________________________ 603 36260.00 Other Revenues 0 29 0 0 0 ______________________________ 603 36262.00 Special Settlements 0000 0______________________________ 603 36265.00 Use of Reserve Funds 0000 0______________________________ 603 37300.00 Storm Water Utility Revenues 1,289,374 1,267,924 1,295,790 1,500,000 1,500,000 4% Annual Rate Incr. (Rate Model) 603 37360.00 Penalties - Storm Water Utility 10,471 11,627 6,272 7,000 7,000 ______________________________ 603 39103.00 Gain or Loss from F/A Disposal 0000 0______________________________ 603 39203.00 Transfer From______________ 0 0 492,427 0 0 ______________________________ ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- FUND TOTALS $1,376,605 $1,392,314 $1,957,229 $1,576,600 $1,576,600 ========= ========= ========= ========= ========= ========= Page One 2021 BUDGET WORKSHEETS STORM WATER UTILITY - EXPENDITURES - May 15, 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------- --------------------------------------------------- ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- --------------------------------------------------- All Salary Costs Inclusive of 603 49500 101.00 Salaries & Benefits $518,300 Salary, Taxes, PERA & Benefits 603 49500 77 101.00 Administrative 21,966 77,299 153,628 136,400 174,900 ______________________________ 603 49500 78 101.00 Technical/Clerical 84,524 89,040 196,702 229,800 224,800 1 Additional Finance Position 603 49500 79 101.00 Maintenance 98,552 107,093 110,285 157,500 118,600 New Position for 2019 603 49500 xx 101.00 Salary & Benefit Contingency 0000 0______________________________ 603 49500 102.00 Full-Time Overtime 5,114 7,705 9,574 6,000 6,000 ______________________________ 603 49500 99 103.00 Part-Time Salaries & Benefits 7,207 8,345 7,596 8,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 504 1,092 0 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 350 86 0 500 500 Stakes, Ribbons, Level, etc. 603 49500 01 212.00 Motor Fuels 6,200 6,000 4,700 4,700 4,700 3% Covered by Storm Utility 603 49500 01 224.00 Street Maintenance Materials 2,140 5,241 1,775 3,000 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. 1,553 973 765 3,000 3,000 ______________________________ 603 49500 01 225.02 Black Dirt, Seed, Sod, etc. 900 945 240 1,000 1,000 ______________________________ 603 49500 01 226.00 Sign Repair Materials 257 160 4,443 3,000 3,000 Wetland Buffer Signs 603 49500 01 230.00 Repair Materials & Supplies 1,359 1,418 1,368 3,000 3,000 Culverts, Catch Basins, Structures 603 49500 01 240.00 Safety Equipment & PPE 0 0 0 500 500 Vests, Glasses, Hardhats, etc. 603 49500 01 241.00 Small Tools 176 1,211 923 1,500 1,500 ______________________________ 603 49500 01 242.00 Minor Equipment 2,238 1,286 2,972 7,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 7,377 8,202 14,197 5,000 5,000 ______________________________ 603 49500 01 303.03 CSMP Update 0 69,832 12,965 2,000 2,000 ______________________________ 603 49500 01 303.04 Miscellaneous 10,921 34,730 45,435 10,000 10,000 ______________________________ 603 49500 01 303.05 GIS 1,651 52 0 1,000 1,000 $5,000 Split 5 Ways 603 49500 01 304.00 Legal Fees 0 1,886 34 2,000 2,000 ______________________________ 603 49500 01 310.00 Testing Services 0000 0 Water Quality Tests (M) 603 49500 01 312.00 Gopher State One-Call 1,684 1,436 1,794 2,500 2,500 $7,500 Split 3 Ways 603 49500 01 313.00 Outsource Bill Printing/Mailing 0 2,201 6,618 8,300 8,300 ______________________________ 603 49500 01 315.00 Special Programs 5,867 6,437 4,500 5,000 5,000 WHEP 603 49500 01 318.00 Contract Engineer 26,927 0 0 0 0 ______________________________ 603 49500 01 319.00 Other Professional Services 6,500 ______________________________ 603 49500 01 319.01 SCADA 0 0 4,223 5,000 5,000 ______________________________ 603 49500 01 319.03 Landscape Maintenance 0 0 0 1,500 1,500 At Lift Stations At Lift Stations 603 49500 01 320.00 Credit Card Activity Fees 6,064 7,767 9,409 8,500 8,500 1/3 Cost of C/C Pymt Processing 603 49500 01 321.00 Telephone Costs 3,086 3,541 4,266 5,000 5,000 Cell Phones, Modems, GPS 603 49500 01 322.00 Postage Costs 4,002 2,853 310 400 400 Outsource Mailing (313.00) 603 49500 01 323.00 Radio Units 5,777 6,082 6,282 7,100 7,100 (24x$300) ($28,000) (Split 5 Ways) 603 49500 01 352.00 General Notices & Public Info 35 0 0 1,000 1,000 ______________________________ 603 49500 01 365.00 Workers Comp Insurance 6,287 7,647 10,255 6,000 6,000 Storm Water's Share of Premiums 603 49500 01 369.00 Other Insurance 1,734 1,746 1,814 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,177 2,159 2,372 2,200 2,200 ______________________________ 603 49500 01 391.02 Auto Read Software Support 631 650 650 700 700 ______________________________ 603 49500 01 393.00 P.C. Hardware Purchases 0 1,967 361 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 10,119 8,954 9,714 10,500 10,500 ESRI, Cartegraph, DataLink 603 49500 01 394.02 Online Subscriptions 234 234 0 300 300 Pictometry 603 49500 01 394.03 New Software Purchases 0 0 983 200 200 ______________________________ 603 49500 01 403.00 Contracted R & M - Other Impr 130,000 ______________________________ 603 49500 01 403.01 Ditching 12,609 1,008 0 10,000 10,000 ______________________________ 603 49500 01 403.02 Catch Basins, Manholes, Etc. 111,199 43,322 93,304 120,000 120,000 ______________________________ 603 49500 01 403.03 Pond Inspection & Maintenance 00000 ______________________________ 603 49500 01 405.00 MS4 Permit Compliance 110,000 ______________________________ 603 49500 01 405.01 Engineering Fees 38,365 31,594 43,408 45,000 45,000 Inspection, GIS, Guidance, Etc. 603 49500 01 405.02 Equipment Rental 7,149 0 72,789 20,000 20,000 Bulldozer, Large Equipment 603 49500 01 405.03 Dirt, Seed, Rip Rap, Etc. 786 0 607 5,000 5,000 For Restoration 603 49500 01 405.04 Contracted Maintenance 3,973 3,030 59,671 40,000 40,000 Brush Clearing, Dredging 603 49500 01 416.00 Machinery Rental 2,416 0 0 2,500 2,500 Pumps 603 49500 01 433.00 Dues & Subscriptions 280 49 994 1,500 1,500 SUSA Split w/602, MN SW Coalition 603 49500 01 435.00 Books & Pamphlets 0 0 81 500 500 Utility Information 603 49500 01 437.00 Conferences & Seminars 3,700 ______________________________ 603 49500 01 437.01 Storm Water Management 0 0 737 1,200 1,200 Stormwater Collab, Flygt Training 603 49500 01 437.04 Cartegraph, ESRI, GIS 131 607 0 500 500 User Group, Conference, Training 603 49500 01 437.05 Miscellaneous Training 0 430 583 2,000 2,000 ______________________________ 603 49500 01 439.00 Other Miscellaneous Charges 106 360 421 300 300 ______________________________ ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- PAGE TOTALS 504,625 556,668 903,747 909,800 904,400 Page Two 2021 BUDGET WORKSHEETS STORM WATER UTILITY - EXPENDITURES - May 15, 2020 2021 2020 Object 2021 2017 2018 2019 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 3,704 0 0 60,000 60,000 ______________________________ 603 49500 01 530.02 Stormwater System Improvements 0 0 0 140,000 140,000 ______________________________ 603 49500 01 540.00 Heavy Machinery Purchases 99,350 31,714 4,538 170,500 170,500 Side Flail Mower, Sweeper 603 49500 01 550.00 Motor Vehicle Purchases 20,226 0 43,070 4,700 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 0 24,754 0 12,000 12,000 Hose Trailer in 2020 603 49500 01 586.00 Computer Equipment Purchases 0 81 0 500 500 ______________________________ 603 49500 01 710.00 Transfers 0 ______________________________ 603 49500 01 710.06 1/2 of 2018 P & I Payments(2010A) 32,000 0 0 0 0 Final Payment 2/1/18 603 49500 01 710.10 Projects 381,317 43,887 296,254 0 0 ______________________________ ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- 603-49500-01 TOTALS 1,041,222 657,105 1,247,609 1,298,000 1,292,600 603 49511 01 221.00 Equipment Parts 477 0 0 500 500 ______________________________ 603 49511 01 381.00 Electric Utilities 252 270 312 500 500 ______________________________ 603 49511 01 403.00 Contracted Repair & Maintenance 202 0 1,197 1,000 1,000 ______________________________ ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- (Copper Pond) TOTAL - LIFT STATION #1 931 270 1,508 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,868 140 1,000 1,000 ______________________________ ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- (Schwarz Pond) TOTAL - LIFT STATION #2 0 1,868 140 2,000 2,000 603 49513 01 221.00 Equipment Parts 0 49 9 500 500 ______________________________ 603 49513 01 381.00 Electric Utilities 5,786 6,577 8,784 7,200 7,200 ______________________________ 603 49513 01 403.00 Contracted Repair & Maintenance 0 0 1,477 1,000 1,000 ______________________________ ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- (Birger Pond) TOTAL - LIFT STATION #3 5,786 6,626 10,269 8,700 8,700 603 49514 01 221.00 Equipment Parts 0 65 0 500 500 ______________________________ 603 49514 01 381.00 Electric Utilities 1,542 1,178 2,008 2,500 2,500 ______________________________ 603 49514 01 403.00 Contracted Repair & Maintenance 0 488 817 1,000 1,000 ______________________________ ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- (Marcotte Pond) TOTAL - LIFT STATION #4 1,542 1,731 2,824 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 144 500 500 ______________________________ 603 49516 01 381.00 Electric Utilities 511 416 468 500 500 ______________________________ 603 49516 01 403.00 Contracted Repair & Maintenance 0 0 507 1,000 1,000 ______________________________ ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- (Glendalough 7th) TOTAL - LIFT STATION #6 511 416 1,119 2,000 2,000 603 49517 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49517 01 381.00 Electric Utilities 753 551 992 500 500 ______________________________ 603 49517 01 403.00 Contracted Repair & Maintenance 0 0 160 1,000 1,000 ______________________________ ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- (Horseshoe Lake) TOTAL - LIFT STATION #7 753 551 1,152 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,050,746 $668,566 $1,264,622 $1,322,700 $1,317,300 ========= ========= ========= ========= ========= ========= Page One 2021 BUDGET WORKSHEETS STREET LIGHT UTILITY - REVENUES - August 4, 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------- ------------------------------------------------------------------- ----------------- ----------------- --------------- --------------- --------------- -------------------------------------------- 608-31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 __________________________ 608-31020.00 Tax Increments 0 0 0 0 0 __________________________ 608-34306.00 Other Highway & Street Revenue 0 0 0 0 0 __________________________ 608-36101.00 State Grants & Aids 0 0 0 0 0 __________________________ 608-36102.00 Other State Grants & Aids 0 0 0 0 0 __________________________ 608-36210.00 Interest Earnings - Investments 0 0 0 0 0 __________________________ 608-36215.00 Interest Earnings 0 0 0 0 0 __________________________ 608-36220.00 Rents & Royalties 0 0 0 0 0 __________________________ 608-36260.00 Other Revenue 0 0 0 0 0 __________________________ 608-36265.00 Use of Reserve Funds 0 0 0 0 0 __________________________ 608-36270.00 Capital Contributions 0 0 0 0 0 __________________________ 608-37400.00 Street Light Revenues 0 0 0 220,000 220,000 __________________________ 608-37460.00 Penalties - Street Light Revenues 0 0 0 0 0 __________________________ 608-37470.00 Other Street Light Revenues 0 0 0 0 0 __________________________ 608-39201.00 Transfer from General Fund 0 0 0 0 0 __________________________ 608-39202.00 Contribution from Enterprises 0 0 0 0 0 __________________________ 608-39203.00 Transfer from________________ 0 0 0 0 0 __________________________ ----------------- ----------------- ----------------- --------------- --------------- --------------- FUND TOTALS $0 $0 $0 $220,000 $220,000 ========= ========= ========= ======== ======== ======== - EXPENDITURES - 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------- ------------------------------------------------------------------- ----------------- ----------------- --------------- --------------- --------------- -------------------------------------------- 608 49508 01 219.00 Other Operating Supplies $0 $0 $0 $0 $0 __________________________ 608 49508 01 221.00 Equipment Parts 0 0 0 0 0 __________________________ 608 49508 01 304.00 Legal Fees 0 0 0 0 0 __________________________ 608 49508 01 317.00 General Fund Admin Fees 0 0 0 0 0 __________________________ 608 49508 01 319.00 Other Professional Services 0 0 0 0 0 __________________________ 608 49508 01 352.00 General Notices & Public Info 0 0 0 0 0 __________________________ 608 49508 01 381.00 Electric Utilities 0 0 0 185,000 185,000 __________________________ 608 49508 01 409.00 Other Contracted Repair & Maint. 0 0 0 15,000 15,000 __________________________ 608 49508 01 421.00 Depreciation Expense 0 0 0 0 0 __________________________ 608 49508 01 439.00 Other Miscellaneous Charges 0 0 0 0 0 __________________________ 608 49508 01 530.00 Improvements Other Than Buildings 0 0 0 20,000 20,000 __________________________ 608 49508 01 710.00 Transfers 0 0 0 0 0 __________________________ 608 49508 01 720.00 Transfers 0 0 0 0 0 __________________________ ----------------- ----------------- ----------------- --------------- --------------- --------------- FUND TOTALS $0 $0 $0 $220,000 $220,000 ========= ========= ========= ======== ======== ========