Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
6.b. 2021 Utility Budgets
Table 1 2022 Proposed Fund2021 BudgetChange Budget Water Utility$ 1,663,000.00$ 1,698,700.002.1% Sewer Utility$ 2,630,000.00$ 2,896,545.0010.1% Storm Utility$ 1,428,700.00$ 1,468,900.002.8% Street Light Utility$ 220,000.00$ 231,550.005.3% TOTAL$ 5,941,700.00$ 6,295,695.006.0% EXECUTIVE SUMMARY Utility Commission Meeting: October 25, 2021 AGENDA SECTION: AGENDA ITEM: 2022 Utility Budgets Old Business PREPARED BY: Brian Erickson, P.E. City Engineer AGENDA NO. 6.b. ATTACHMENTS: Proposed 2022 Utility Budgets APPROVED BY: BLE RECOMMENDED ACTION: Motion to Recommend City Council Approval of the 2022 Utility Budgets BACKGROUND Attached for the commission’s consideration are the proposed 2022 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 has an 2.1% increase to account for increased meter purchases for both replacement and new homes. A small amount was added for additional contracted repair and maintenance as needed. The Sewer Utility budget increase is due to an increase in the Metropolitan Council service charges for 2022. That increase amounts to $235,245 for 2022. As discussed during the rate model discussion previously, this increase is due to Rosemount’s flows accounting for a larger proportion of regional flows (a growth indicator) as well as an increase in the MCES 2022 budget amount. The increase to the Storm Utility budget is primarily due to salaries. The increase to the Street Light Utility budget based on an estimated electric utility increase as well as additional street lights being added to the system. Some minor adjustments to the budgets may occur prior to adoption in December. SUMMARY Staff is requesting Utility Commission recommend the City Council approve the proposed 2022 Utility Budgets. C:\\Users\\jab\\AppData\\Local\\Temp\\6.b. 2021 Utility Budgets_691052\\6.b. 2021 Utility Budgets.docx Page One 2022 BUDGET WORKSHEETS WATER UTILITY - REVENUES - April 30, 2021 2022 2021 Object 2022 2018 2019 2020 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments --------------------- ----------------------------------------------------------- ----------------- ----------------- ----------------- ----------------- ------------------- ------------------- ---------------------------------------------------- 601 33130.00 Federal Grants - CDBG $24,956 $0 $0 $0 $0 MCES Water Efficiency Grant 601 33425.00 Other State Grants & Aids 33,455 720 6,302 1,000 1,000 ______________________________ 601 33620.00 Other County Grants & Aids 0000 0______________________________ 601 34107.00 Assessment Fees 1,280 21,497 22,519 20,000 20,000 ______________________________ 601 34108.00 Administrative Fees-Other Funds 11,796 9,327 11,753 6,300 6,300 5% of 5% Fees-Const Projects 601 34109.00 Other Gen'l Govt Chgs for Services 15,984 17,261 21,709 0 0 ______________________________ 601 36101.00 Principal - Special Assessments 77,288 53,808 49,369 55,000 55,000 ______________________________ 601 36102.00 Penalties & Interest - S/A 655 719 1,222 0 0 ______________________________ 601 36210.00 Interest Earnings - Investments 149,982 177,969 146,937 90,000 90,000 ______________________________ 601 36214.00 Net Change in FV-Investments (12,063) 39,042 94,366 0 0 Annual Market Value Changes 601 36215.00 Interest Earnings 1,244 3,358 2,623 1,000 1,000 ______________________________ 601 36220.00 Rents & Royalties 154,610 161,211 163,151 170,000 170,000 Antenna Leases 601 36260.00 Other Revenues 117 0 0 0 0 ______________________________ 601 36265.00 Use of Reserve Funds 0000 0______________________________ 601 37110.00 Residential Water Revenues 1,426,360 1,274,288 1,686,424 1,400,000 1,600,000 ______________________________ 601 37120.00 Apartment Water Revenues 113,851 121,359 128,711 120,000 130,000 ______________________________ 601 37125.00 Institutional Water Revenues 66,183 83,160 75,527 75,000 75,000 ______________________________ 601 37130.00 Commercial Water Revenues 94,093 95,413 103,899 100,000 100,000 ______________________________ 601 37140.00 Industrial Water Revenues 122,071 135,704 143,753 140,000 150,000 ______________________________ 601 37160.00 Penalties - Water Revenues 12,848 12,012 8,235 12,000 12,000 ______________________________ 601 37165.00 Meter Maint Water Revenues 0000 0______________________________ 601 37170.00 Other Water Revenues 0 (29,682) (350) 0 0 2nd Meter Refunds 601 37180.00 Water Meter Sales Revenue 87,294 96,658 117,612 90,000 90,000 ______________________________ 601 39103.00 Gain or Loss from F/A Disposal (426) 0 (378) 0 0 ______________________________ 601 39203.00 Transfer From______________0000 0______________________________ ----------------- ----------------- ----------------- ----------------- ------------------- ------------------- FUND TOTALS $2,381,577 $2,273,824 $2,783,383 $2,280,300 $2,500,300 ========= ========= ========= ========= =========== =========== Page One 2022 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - April 30, 2021 2022 2021 Object 2022 2018 2019 2020 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments --------------------- ----------------------------------------------------------- ----------------- ----------------- ----------------- ----------------- ------------------- ------------------- ---------------------------------------------------- All Salary Costs Inclusive of 601 49400 101.00 Salaries & Benefits $573,200 Salary, Taxes, PERA & Benefits 601 49400 77 101.00 Administrative 205,824 162,236 162,556 182,800 196,400 ______________________________ 601 49400 78 101.00 Technical/Clerical 155,870 169,268 179,462 196,300 200,400 ______________________________ 601 49400 79 101.00 Maintenance 180,248 183,174 151,204 168,700 176,400 ______________________________ 601 49400 xx 101.00 Salary & Benefit Contingency 0000 0______________________________ 601 49400 102.00 Full-Time Overtime 13,549 16,444 10,766 8,000 8,000 ______________________________ 601 49400 103.00 Part-Time Salaries & Benefits 6,916 7,975 10,305 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 1,092 70 0 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 362 134 592 200 200 ______________________________ 601 49400 01 212.00 Motor Fuels 5,100 3,912 3,900 3,900 3,900 2.5% Covered by Water Utility 601 49400 01 216.00 Chemicals & Chemical Products 43,035 60,654 62,672 75,000 75,000 Chlorine/Flouride/Poly 601 49400 01 219.00 Other Operating Supplies 2,053 1,174 487 500 500 Maintenance Supplies 601 49400 01 220.00 Water Meter Purchases 155,300 Meters, MIU's & CU Horns 601 49400 01 220.01 For Replacements 71,822 78,315 67,073 75,000 77,300 Match Rate Model (Incl. Recycling) 601 49400 01 220.02 For New Homes 47,296 52,209 44,716 75,000 78,000 Match Rate Model, Newland Dev. 601 49400 01 224.00 Street Maintenance Materials 1,261 4,769 1,414 2,500 2,500 Patching for Breaks 601 49400 01 225.00 Landscaping Materials 360 108 707 1,000 1,000 Topsoil, Seed & Sod 601 49400 01 228.00 Meter Repair Materials 222 105 79 0 0 ______________________________ 601 49400 01 229.00 Other Maintenance Supplies 21,000 ______________________________ 601 49400 01 229.01 Supplies for Hydrants 8,476 6,939 2,946 10,000 10,000 ______________________________ 601 49400 01 229.02 Curb Shutoffs 855 0 196 1,000 1,000 ______________________________ 601 49400 01 229.03 GV Repair/Replacement 0 13,526 767 6,000 6,000 Valve Maintenance 601 49400 01 229.04 Miscellaneous Supplies 3,350 685 2,810 4,000 4,000 ______________________________ 601 49400 01 240.00 Safety Equipment & PPE 0 0 509 500 500 Vests, Glasses, Hardhats, etc. 601 49400 01 241.00 Small Tools 2,140 1,782 2,254 2,500 2,500 Wrenches, Shovels, etc. 601 49400 01 242.00 Minor Equipment 8,371 6,052 13,400 16,000 16,000 Hyd. Buddy & Locator in 2021 601 49400 01 303.00 Engineering Fees 26,000 ______________________________ 601 49400 01 303.01 WHPP 0 21,302 0 5,000 5,000 Groundwater Plan Implementation 601 49400 01 303.02 GIS 78 0 0 1,000 1,000 $5,000 Split 5 Ways 601 49400 01 303.03 Rate Study 14,459 19,172 0 5,000 5,000 ______________________________ 601 49400 01 303.04 Miscellaneous Fees 2,574 2,745 30,635 15,000 15,000 Future Water Facility Study 601 49400 01 304.00 Legal Fees 0 1,226 242 1,000 1,000 ______________________________ 601 49400 01 310.00 Testing Services 85,000 ______________________________ 601 49400 01 310.01 Bacteria & Water Quality 2,625 3,572 2,776 5,000 5,000 MN, Radon, Tri-Chl., Pesticides, Etc. 601 49400 01 310.03 MDH Service Connection Fee 47,381 49,186 77,030 80,000 80,000 ______________________________ 601 49400 01 312.00 Gopher State One-Call 1,436 1,794 1,824 2,500 2,500 $7,500 Split 3 Ways 601 49400 01 313.00 Outsource Bill Printing/Mailing 2,201 6,618 6,221 8,300 8,300 ______________________________ 601 49400 01 318.00 Contract Engineer 0000 0______________________________ 601 49400 01 319.00 Other Professional Services 47,500 ______________________________ 601 49400 01 319.01 Thaw Pipes, Check Leaks, etc. 0 0 615 1,500 1,500 ______________________________ 601 49400 01 319.02 Supervisory Controls 0 2,053 2,705 5,000 5,000 ______________________________ 601 49400 01 319.03 Hazardous Chemical Permits 700 800 800 1,000 1,000 MN Department of Public Safety 601 49400 01 319.06 Contracted Hydrant Painting 11,172 9,212 0 11,000 11,000 ______________________________ 601 49400 01 319.07 Antenna Expenses 9,209 3,842 49,645 20,000 20,000 Offset by Revenue 601-36220.00 601 49400 01 319.08 Buxton Project 9000 0 ______________________________ 601 49400 01 319.09 HVAC Maintenance Contract 0 1,702 1,788 4,000 4,000 Annual Insp/Maint, All Wells 601 49400 01 319.10 Landscape Maintenance 0 2,655 0 4,000 4,000 ______________________________ 601 49400 01 319.11 Pest Control 0 539 574 1,000 1,000 ______________________________ 601 49400 01 320.00 Credit Card Activity Fees 7,767 9,409 11,248 9,500 9,500 1/3 Cost of C/C Pymt Processing 601 49400 01 321.00 Telephone Costs 4,734 4,134 4,163 5,000 5,000 Cell Phones, Modesm, GPS 601 49400 01 322.00 Postage Costs 2,920 369 270 400 400 Outsource Mailing (313.00) 601 49400 01 323.00 Radio Units 6,082 6,282 5,255 1,000 1,000 ______________________________ 601 49400 01 352.00 General Notices & Public Info 0 36 79 0 0 ______________________________ 601 49400 01 365.00 Workers Comp Insurance 13,635 13,863 15,088 12,000 12,000 Water's Share of Premiums 601 49400 01 369.00 Other Insurance 6,793 7,249 7,741 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,159 2,372 2,203 2,200 2,200 Added to Utility Budgets in 2012 601 49400 01 391.02 Auto Read Software Support 650 650 808 700 700 Added to Utility Budgets in 2012 601 49400 01 392.00 P.C. Accessories & Supplies 0 33 251 200 200 ______________________________ 601 49400 01 393.00 P.C. Hardware Purchases 1,967 361 383 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 8,954 9,715 10,633 10,500 10,500 ESRI, Cartegraph, DataLink 601 49400 01 394.02 Online Subscriptions 234 0 0 300 300 Pictometry 601 49400 01 394.03 New Software Purchases 0 983 0 200 200 ______________________________ ----------------- ----------------- ----------------- ----------------- ------------------- ------------------- PAGE TOTALS 905,941 951,406 951,792 1,060,400 1,091,100 Page Two 2022 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - April 30, 2021 2022 2021 Object 2022 2018 2019 2020 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments --------------------- ----------------------------------------------------------- ----------------- ----------------- ----------------- ----------------- ------------------- ------------------- ---------------------------------------------------- 601 49400 01 403.00 Contracted R & M - Other Impr 82,681 52,829 44,985 80,000 85,000 Main Breaks, Gate Valves, Etc. 601 49400 01 433.00 Dues & Subscriptions 327 250 300 500 500 Suburban Utility Supt Assn, MRWA 601 49400 01 435.00 Books & Pamphlets 0 0 217 200 200 Reference Materials 601 49400 01 437.00 Conferences & Seminars 6,500 ______________________________ 601 49400 01 437.01 MDH Training (Water School) 1,026 2,066 624 3,000 3,000 Operator Licensure 601 49400 01 437.02 AWWA Conference 1,899 0 58 2,000 2,000 Duluth, Send 2 Staff 601 49400 01 437.03 CarteGraph, ESRI, GIS 607 0 491 500 500 User Group, Conference, Training 601 49400 01 437.04 Miscellaneous Training 20 458 135 1,000 1,000 ______________________________ 601 49400 01 439.00 Other Miscellaneous Charges 12,674 11,878 16,087 20,000 20,000 DNR Annual Water Use 601 49400 01 450.00 Sales Tax on Purchases 0000 0______________________________ 601 49400 01 521.00 Building & Structure Purchases 0000 0______________________________ 601 49400 01 530.00 Improvements Other Than Bldgs 201,000 ______________________________ 601 49400 01 530.01 Well Inspections 800 0 800 1,000 1,000 ______________________________ 601 49400 01 530.02 Miscellaneous Improvements 81,548 13,156 4,046 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 12,835 601,050 141,920 100,000 100,000 From Long-Term Plan(Chip in 2019) 601 49400 01 540.00 Heavy Machinery Purchases 0000 0 Equipment Purchases - Match CIP 601 49400 01 548.00 Lease Program-P.W. Vehicles 16,984 6,740 8,145 13,100 13,100 Vehicle Leases 601 49400 01 550.00 Motor Vehicle Purchases 0 43,080 0 0 0 ______________________________ 601 49400 01 570.00 Office Equipment Purchases 0 0 0 500 500 ______________________________ 601 49400 01 580.00 Other Equipment Purchases 24,754 0 0 0 0 ______________________________ 601 49400 01 611.00 Interest on Lease Payments 476 824 1,211 0 0 P.W. Building Expansion(See 521) 601 49400 01 710.00 Transfers 0 57,500 39,338 0 0 Transfers for Other Improvements ----------------- ----------------- ----------------- ----------------- ------------------- ------------------- 601-49400-01 TOTALS 1,142,571 1,741,235 1,210,149 1,382,200 1,417,900 601 49406 01 221.00 Equipment Parts 0 379 278 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 0 0 560 1,000 1,000 ______________________________ 601 49406 01 381.00 Electric Utilities 409 1,846 2,442 1,300 1,300 Pumping & Lighting ----------------- ----------------- ----------------- ----------------- ------------------- ------------------- TOTAL - PRV 409 2,225 3,279 2,700 2,700 601 49407 01 221.00 Equipment Parts 3,664 196 0 1,500 1,500 ______________________________ 601 49407 01 223.00 Building Repair Supplies 0 0 0 200 200 ______________________________ 601 49407 01 319.00 Other Professional Services 0000 0______________________________ 601 49407 01 321.00 Telephone Costs 211 211 211 300 300 ______________________________ 601 49407 01 381.00 Electric Utilities 25,629 16,267 1,906 33,000 33,000 Pumping, Lighting, Tower Mixer 601 49407 01 409.00 Other Contracted Repairs & Maint 2,044 4,715 19,042 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 9,184 1,853 0 2,000 2,000 Standby Generator in 2019 ----------------- ----------------- ----------------- ----------------- ------------------- ------------------- TOTAL - WELL #7 40,733 23,241 21,158 39,100 39,100 601 49408 01 221.00 Equipment Parts 1,139 0 3,995 1,500 1,500 ______________________________ 601 49408 01 223.00 Building Repair Supplies 0 0 0 200 200 ______________________________ 601 49408 01 319.00 Other Professional Services 0000 0______________________________ 601 49408 01 381.00 Electric Utilities 21,238 19,796 20,340 25,000 25,000 Pumping & Lighting 601 49408 01 383.00 Gas Utilities 469 365 383 600 600 Heat Only 601 49408 01 409.00 Other Contracted Repairs & Maint 6,959 2,005 350 2,000 2,000 ______________________________ 601 49408 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ----------------- ----------------- ----------------- ----------------- ------------------- ------------------- TOTAL - WELL #8 29,804 22,166 25,068 29,400 29,400 601 49409 01 221.00 Equipment Parts 29 196 0 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 0000 0______________________________ 601 49409 01 381.00 Electric Utilities 29,288 28,305 28,820 32,000 32,000 Pumping & Lighting 601 49409 01 383.00 Gas Utilities 766 664 561 1,500 1,500 Heat Only 601 49409 01 409.00 Other Contracted Repairs & Maint 2,347 1,719 1,664 4,000 4,000 Paint Generator in 2020 601 49409 01 439.00 Other Miscellaneous Charges 0 0 34 100 100 Contingencies 601 49409 01 530.00 Improvements Other Than Bldgs 0000 0______________________________ ----------------- ----------------- ----------------- ----------------- ------------------- ------------------- TOTAL - WELL #9 32,430 30,884 31,079 39,300 39,300 Page Three 2022 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - April 30, 2021 2022 2021 Object 2022 2018 2019 2020 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,576 6,557 75 1,000 1,000 ______________________________ 601 49410 01 223.00 Building Repair Supplies 18 0 0 200 200 ______________________________ 601 49410 01 321.00 Telephone Costs 765 765 765 0 0 ______________________________ 601 49410 01 381.00 Electric Utilities 15,985 14,345 15,886 17,000 17,000 Pumping & Lighting 601 49410 01 409.00 Other Contracted Repairs & Maint 24,817 403 5,827 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 0000 0______________________________ ----------------- ----------------- ----------------- ----------------- ------------------- ------------------- TOTAL - WELL #10 43,162 22,069 22,552 20,800 20,800 Rural Water System 601 49411 01 221.00 Equipment Parts 0000 0______________________________ 601 49411 01 439.00 Other Miscellaneous Charges 0000 0______________________________ ----------------- ----------------- ----------------- ----------------- ------------------- ------------------- TOTAL - WELL #11 0000 0 Rural Water System (#2) 601 49412 01 221.00 Equipment Parts 0 434 7,157 1,500 1,500 ______________________________ 601 49412 01 223.00 Building Repair Supplies 0 0 723 200 200 ______________________________ 601 49412 01 319.00 Other Professional Services 0000 0______________________________ 601 49412 01 381.00 Electric Utilities 28,566 24,403 34,825 28,000 28,000 Pumping & Lighting 601 49412 01 409.00 Other Contracted Repairs & Maint 478 8,680 874 2,000 2,000 ______________________________ 601 49412 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ----------------- ----------------- ----------------- ----------------- ------------------- ------------------- TOTAL - WELL #12 29,044 33,516 43,579 31,800 31,800 601 49414 01 221.00 Equipment Parts 466 0 9,832 1,500 1,500 ______________________________ 601 49414 01 223.00 Building Repair Supplies 200 0 225 200 200 ______________________________ 601 49414 01 319.00 Other Professional Services 0 0 0 1,000 1,000 ______________________________ 601 49414 01 381.00 Electric Utilities 29,869 19,012 36,253 28,000 28,000 Pumping & Lighting 601 49414 01 409.00 Other Contracted Repairs & Maint 622 27,476 2,216 2,000 2,000 ______________________________ 601 49414 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ----------------- ----------------- ----------------- ----------------- ------------------- ------------------- TOTAL - WELL #14 31,157 46,488 48,526 32,800 32,800 601 49425 01 221.00 Equipment Parts 564 559 361 1,500 1,500 ______________________________ 601 49425 01 223.00 Building Repair Supplies 200 28 723 200 200 ______________________________ 601 49425 01 319.00 Other Professional Services 0 0 0 500 500 ______________________________ 601 49425 01 381.00 Electric Utilities 28,224 17,999 30,971 30,000 30,000 Pumping & Lighting 601 49425 01 409.00 Other Contracted Repairs & Maint 7,333 1,742 14,898 2,000 2,000 ______________________________ 601 49425 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ----------------- ----------------- ----------------- ----------------- ------------------- ------------------- TOTAL - WELL #15 36,321 20,327 46,952 34,300 34,300 601 49426 01 221.00 Equipment Parts 726 260 409 1,500 1,500 ______________________________ 601 49426 01 223.00 Building Repair Supplies 0 0 22 200 200 ______________________________ 601 49426 01 319.00 Other Professional Services 0 0 0 500 500 ______________________________ 601 49426 01 381.00 Electric Utilities 5,368 22,821 27,748 28,000 28,000 Pumping & Lighting 601 49426 01 383.00 Gas Utilities 0000 0______________________________ 601 49426 01 409.00 Other Contracted Repairs & Maint 0 978 0 1,000 1,000 ______________________________ 601 49426 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ----------------- ----------------- ----------------- ----------------- ------------------- ------------------- TOTAL - WELL #16 6,094 24,059 28,179 31,300 31,300 Page Four 2022 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - April 30, 2021 2022 2021 Object 2022 2018 2019 2020 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments --------------------- ----------------------------------------------------------- ----------------- ----------------- ----------------- ----------------- ------------------- ------------------- ---------------------------------------------------- 601 49415 01 221.00 Equipment Parts 0 0 60 500 500 ______________________________ 601 49415 01 319.00 Other Professional Services 0000 0______________________________ 601 49415 01 409.00 Other Contracted Repairs & Maint 130 7,390 0 500 500 ______________________________ 601 49415 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies ----------------- ----------------- ----------------- ----------------- ------------------- ------------------- TOTAL - WATER TOWER #1 130 7,390 60 1,200 1,200 (Chippendale Water Tower) 601 49416 01 221.00 Equipment Parts 114 10 0 500 500 ______________________________ 601 49416 01 319.00 Other Professional Services 0000 0______________________________ 601 49416 01 381.00 Electric Utilities 1,770 2,675 2,898 4,500 4,500 ______________________________ 601 49416 01 409.00 Other Contracted Repairs & Maint 0 4,884 16,890 500 500 ______________________________ 601 49416 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies ----------------- ----------------- ----------------- ----------------- ------------------- ------------------- TOTAL - WATER TOWER #2 1,884 7,569 19,788 5,700 5,700 (Connemara Water Tower) 601 49417 01 221.00 Equipment Parts 0 10 1,920 500 500 ______________________________ 601 49417 01 319.00 Other Professional Services 0000 0______________________________ 601 49417 01 381.00 Electric Utilities 2,822 1,881 1,560 6,000 6,000 ______________________________ 601 49417 01 409.00 Other Contracted Repairs & Maint 285 1,052 746 500 500 ______________________________ 601 49417 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies ----------------- ----------------- ----------------- ----------------- ------------------- ------------------- TOTAL - WATER TOWER #4 3,107 2,943 4,225 7,200 7,200 (Bacardi Water Tower) 601 49418 01 221.00 Equipment Parts 164 0 0 500 500 ______________________________ 601 49418 01 319.00 Other Professional Services 0000 0______________________________ 601 49418 01 381.00 Electric Utilities 1,989 1,867 1,566 4,000 4,000 ______________________________ 601 49418 01 409.00 Other Contracted Repairs & Maint 0 0 1,927 500 500 ______________________________ 601 49418 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies ----------------- ----------------- ----------------- ----------------- ------------------- ------------------- TOTAL - WATER TOWER #3 2,153 1,867 3,493 5,200 5,200 (East Side Water Tower) GRAND TOTAL - ALL DEPTS. $1,398,998 $1,985,978 $1,508,088 $1,663,000 $1,698,700 ========= ========= ========= ========= =========== =========== Page One 2022 BUDGET WORKSHEETS SEWER UTILITY - REVENUES - April 30, 2021 2022 2021 Object 2022 2018 2019 2020 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments --------------------- ----------------------------------------------------------- ----------------- ----------------- ----------------- ----------------- --------------------------------- ---------------------------------------------------- 602 33425.00 Other State Grants & Aids $0 $712 $926 $0 $0 ______________________________ 602 34108.00 Administrative Fees-Other Funds 11,796 9,327 11,753 6,300 6,300 5% of 5% Fees-Const Projects 602 36101.00 Principal - Special Assessments 75,927 74,262 78,437 80,000 75,000 ______________________________ 602 36102.00 Penalties & Interest - S/A 133 976 1,241 0 0 ______________________________ 602 36210.00 Interest Earnings - Investments 21,667 35,973 17,929 18,000 20,000 ______________________________ 602 36214.00 Net Change in FV-Investments (2,081) 9,532 0 0 0 Annual Market Value Changes 602 36215.00 Interest Earnings 1,074 2,454 1,182 200 1,000 ______________________________ 602 36260.00 Other Revenues 58 0 0 0 0 ______________________________ 602 36265.00 Use of Reserve Funds 0 0 0 528,800 417,700 ______________________________ 602 37210.00 Residential Sewer Revenues 1,527,302 1,462,480 1,708,988 1,600,000 1,720,000 ______________________________ 602 37220.00 Apartment Sewer Revenues 145,502 185,515 322,401 150,000 230,000 ______________________________ 602 37225.00 Institutional Sewer Revenues 27,319 30,960 36,465 30,000 38,000 ______________________________ 602 37230.00 Commercial Sewer Revenues 86,942 104,954 153,611 90,000 110,000 ______________________________ 602 37240.00 Industrial Sewer Revenues 100,300 153,486 217,021 110,000 190,000 ______________________________ 602 37260.00 Penalties - Sewer Revenues 15,175 15,648 7,703 14,000 15,000 ______________________________ 602 39103.00 Gain or Loss from F/A Disposal 0000 0______________________________ 602 39203.00 Transfer From_______________0000 0______________________________ ----------------- ----------------- ----------------- ----------------- --------------------------------- FUND TOTALS $2,011,115 $2,086,280 $2,557,656 $2,627,300 $2,823,000 ========== ========== ========== ========== ========= ========== Page One 2022 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - April 30, 2021 2022 2021 Object 2022 2018 2019 2020 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments --------------------- ----------------------------------------------------------- ----------------- ----------------- ----------------- ----------------- --------------------------------- ---------------------------------------------------- All Salary Costs Inclusive of 602 49450 101.00 Salaries & Benefits $573,200 Salary, Taxes, PERA & Benefits 602 49450 77 101.00 Administrative 202,742 154,976 156,249 176,900 196,400 ______________________________ 602 49450 78 101.00 Technical/Clerical 155,870 169,268 179,462 196,300 200,400 Added P/T GIS Technician 602 49450 79 101.00 Maintenance 180,248 183,175 151,204 168,700 176,400 ______________________________ 602 49450 xx 101.00 Salary & Benefit Contingency 0000 0______________________________ 602 49450 102.00 Full-Time Overtime 13,549 16,444 10,766 7,500 7,500 ______________________________ 602 49450 103.00 Part-Time Salaries & Benefits 7,803 8,479 4,011 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 1,092 0 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 198 25 386 200 200 ______________________________ 602 49450 01 212.00 Motor Fuels 5,100 3,100 3,100 3,100 3,100 2% Covered by Sewer Utility 602 49450 01 216.00 Chemicals & Chemical Products 98 0 0 500 500 Root Killer, Degreaser 602 49450 01 219.00 Other Operating Supplies 147 549 0 200 200 ______________________________ 602 49450 01 224.00 Street Maintenance Materials 2,010 2,113 3,486 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 1,443 1,894 682 5,000 5,000 MH Castings Stock 602 49450 01 240.00 Safety Equipment & PPE 0 0 539 500 500 Vests, Glasses, Hardhats, etc. 602 49450 01 241.00 Small Tools 486 635 653 1,000 1,000 Wrenches, Shovels, etc. 602 49450 01 242.00 Minor Equipment 3,758 2,741 1,588 4,000 4,000 Locator in 2021 602 49450 01 303.00 Engineering Fees 6,000 ______________________________ 602 49450 01 303.01 GIS 78 0 0 1,000 1,000 $5,000 Split 5 Ways 602 49450 01 303.02 Rate Study 7,074 34,043 300 0 0 ______________________________ 602 49450 01 303.04 Miscellaneous 13,523 13,569 508 5,000 5,000 ______________________________ 602 49450 01 312.00 Gopher State One-Call 1,436 1,794 1,824 2,500 2,500 $7,500 Split 3 Ways 602 49450 01 313.00 Outsource Bill Printing/Mailing 2,201 6,618 6,221 8,300 8,300 ______________________________ 602 49450 01 318.00 Contract Engineer 0000 0______________________________ 602 49450 01 319.00 Other Professional Services 65,000 ______________________________ 602 49450 01 319.01 Televising 51,859 56,634 58,697 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 818 1,265 5,000 5,000 SCADA System 602 49450 01 319.04 Lift Station Inspection 0 0 0 3,500 3,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 7,767 9,409 11,248 9,500 9,500 1/3 Cost of C/C Pymt Processing 602 49450 01 321.00 Telephone Costs 3,540 3,819 3,826 5,000 5,000 Cell Phones, Modems, GPS 602 49450 01 322.00 Postage Costs 2,881 310 265 400 400 Outsource Mailing (313.00) 602 49450 01 323.00 Radio Units 6,082 6,282 5,255 1,000 1,000 ______________________________ 602 49450 01 365.00 Workers Comp Insurance 13,482 13,717 14,931 12,000 12,000 Sewer's Share of Premiums 602 49450 01 369.00 Other Insurance 12,322 11,006 10,056 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,159 2,372 2,203 2,200 2,200 Added to Utility Budgets in 2012 602 49450 01 391.02 Auto Read Software Support 650 650 808 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,967 361 696 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 8,954 9,715 10,420 10,500 10,500 ESRI, Cartegraph, DataLink 602 49450 01 394.02 Online Subscriptions 234 0 0 300 300 Pictometry 602 49450 01 394.03 New Software Purchases 0 983 1,650 200 200 ______________________________ 602 49450 01 395.00 P.C. Repairs 0000 0______________________________ 602 49450 01 403.00 Contracted R & M - Other Impr 32,014 11,769 (71) 70,000 70,000 MH Castings Replacement Program 602 49450 01 415.00 Other Equipment Rental 0 0 1,078 200 200 ______________________________ 602 49450 01 416.00 Machinery Rental 400 518 0 2,000 2,000 ______________________________ 602 49450 01 433.00 Dues & Subscriptions 49 127 0 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) 1,193 803 23 2,500 2,500 Operator Licensure $400 each (M) 602 49450 01 437.03 CarteGraph, ESRI, GIS 607 0 491 500 500 User Group, Conference, Training 602 49450 01 437.04 Miscellaneous Training 400 496 215 1,000 1,000 ______________________________ 602 49450 01 439.00 Other Miscellaneous Charges 85 126 317 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 7,695 3,484 300,000 300,000 SCADA, PCL's, 2 L/S Cabinets,Birger 602 49450 01 530.03 CRP of Sewermain 0 0 30,600 150,000 150,000 PMP Sewer Imp. When Needed 602 49450 01 540.00 Heavy Machinery Purchases 0 4,538 1,366 0 0 Jetter (Split with 603) 602 49450 01 548.00 Lease Program-P.W. Vehicles 0 0 0 4,700 4,700 Vehicle Leases 602 49450 01 550.00 Motor Vehicle Purchases 0 43,090 0 0 0 ______________________________ 602 49450 01 560.00 Furniture & Fixture Purchases 0 0 0 500 500 ______________________________ 602 49450 01 570.00 Office Equipment Purchases 0 0 0 500 500 ______________________________ 602 49450 01 580.00 Other Equipment Purchases 24,754 0 0 0 0 Portable Generator (Split 3 Ways) ----------------- ----------------- ----------------- ----------------- --------------------------------- PAGE TOTALS 770,255 784,663 679,803 1,252,600 1,283,900 Page Two 2022 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - April 30, 2021 2022 2021 Object 2022 2018 2019 2020 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments --------------------- ----------------------------------------------------------- ----------------- ----------------- ----------------- ----------------- --------------------------------- ---------------------------------------------------- 602 49450 01 602.00 Sewer Service Charges 1,300,125 1,303,112 1,386,562 1,311,700 1,546,945 MWCC Chgs (Matches Rate Model) 602 49450 01 611.00 Interest on Lease Payments 476 0 117 0 0 P.W. Building Expansion(See 521) 602 49450 01 710.00 Transfers 65,000 0 38,025 0 0 Transfers for Other Improvements ----------------- ----------------- ----------------- ----------------- --------------------------------- 602-49450-01 TOTALS 2,135,856 2,087,775 2,104,507 2,564,300 2,830,845 602 49451 01 219.00 Other Operating Supplies 0 0 3,310 3,200 3,200 Second Bubbler 602 49451 01 221.00 Equipment Parts 0 760 0 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 1,500 2,750 2,925 3,000 3,000 ______________________________ 602 49451 01 403.00 Contracted R & M - Other Impr 0 0 347 2,000 2,000 ______________________________ 602 49451 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 ______________________________ ----------------- ----------------- ----------------- ----------------- --------------------------------- (City Hall) TOTAL - LIFT STATION #1 1,500 3,510 6,582 9,300 9,300 602 49452 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49452 01 221.00 Equipment Parts 0 3,361 0 800 800 ______________________________ 602 49452 01 229.00 Other Maintenance Supplies 0 0 31 200 200 ______________________________ 602 49452 01 381.00 Electric Utilities 540 417 518 700 700 ______________________________ 602 49452 01 403.00 Contracted R & M - Other Impr 412 471 1,323 2,000 2,000 ______________________________ 602 49452 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ----------------- ----------------- ----------------- ----------------- --------------------------------- (Bloomfield 5th) TOTAL - LIFT STATION #7 952 4,249 1,872 3,900 3,900 602 49453 01 219.00 Other Operating Supplies 0 0 3,310 100 100 ______________________________ 602 49453 01 221.00 Equipment Parts 0 3,694 0 800 800 ______________________________ 602 49453 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49453 01 381.00 Electric Utilities 3,393 3,572 4,330 4,000 4,000 ______________________________ 602 49453 01 403.00 Contracted R & M - Other Impr 13,482 27,983 118,426 2,000 2,000 Safety Improvements in 2018 602 49453 01 439.00 Other Miscellaneous Charges 0 568 0 100 100 Contingencies ----------------- ----------------- ----------------- ----------------- --------------------------------- (Shannon Pond) TOTAL - LIFT STATION #3 16,874 35,817 126,066 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,583 5,612 4,610 6,000 6,000 ______________________________ 602 49454 01 403.00 Contracted R & M - Other Impr 0 142 41,931 2,000 2,000 ______________________________ 602 49454 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ----------------- ----------------- ----------------- ----------------- --------------------------------- (Hawkins) TOTAL - LIFT STATION #4 5,583 5,754 46,541 9,200 9,200 602 49455 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49455 01 221.00 Equipment Parts 2,611 0 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,418 5,062 5,822 6,000 6,000 ______________________________ 602 49455 01 403.00 Contracted R & M - Other Impr 3,109 2,658 74,926 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 11,139 7,720 80,747 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 4,710 6,360 3,557 6,000 6,000 ______________________________ 602 49456 01 403.00 Contracted R & M - Other Impr 0 415 347 2,000 2,000 ______________________________ 602 49456 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ----------------- ----------------- ----------------- ----------------- --------------------------------- (Drumcliffe) TOTAL - LIFT STATION #6 4,710 6,775 3,904 9,200 9,200 Page Three 2022 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - April 30, 2021 2022 2021 Object 2022 2018 2019 2020 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments --------------------- ----------------------------------------------------------- ----------------- ----------------- ----------------- ----------------- --------------------------------- ---------------------------------------------------- 602 49457 01 219.00 Other Operating Supplies 3,170 0 0 100 100 Bubbler in 2018 602 49457 01 221.00 Equipment Parts 2,707 12 0 500 500 ______________________________ 602 49457 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49457 01 381.00 Electric Utilities 1,427 1,371 1,539 1,200 1,200 ______________________________ 602 49457 01 403.00 Contracted R & M - Other Impr 1,605 5,410 1,053 2,000 2,000 ______________________________ 602 49457 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ----------------- ----------------- ----------------- ----------------- --------------------------------- (Glendalough 5th) TOTAL - LIFT STATION #9 8,909 6,793 2,593 4,100 4,100 602 49458 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49458 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 602 49458 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49458 01 381.00 Electric Utilities 461 421 448 800 800 ______________________________ 602 49458 01 403.00 Contracted R & M - Other Impr 0 0 347 2,000 2,000 ______________________________ 602 49458 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ----------------- ----------------- ----------------- ----------------- --------------------------------- (Meadows of ) TOTAL - LIFT STATION #8 461 421 796 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 500 500 500 ______________________________ 602 49460 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49460 01 381.00 Electric Utilities 325 339 304 400 400 ______________________________ 602 49460 01 403.00 Contracted R & M - Other Impr 0 0 22,583 2,000 2,000 ______________________________ 602 49460 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ----------------- ----------------- ----------------- ----------------- --------------------------------- (Glen Rose) TOTAL - LIFT STATION #10 325 339 23,387 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 2,102 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 2,102 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 363 400 400 ______________________________ 602 49462 01 403.00 Contracted R & M - Other Impr 0 0 347 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 711 3,300 3,300 GRAND TOTAL - ALL DEPTS. $2,186,309 $2,159,154 $2,399,809 $2,630,000 $2,896,545 ========== ========== ========== ========== ========= ========== Page One 2022 BUDGET WORKSHEETS STORM WATER UTILITY - REVENUES - April 30, 2021 2022 2021 Object 2022 2018 2019 2020 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------- ---------- ------------------------------------------------ ---------------- ---------------- ---------------- ---------------- ---------------- ---------------- ------------------------------------------------ 603 33400.00 State Grants & Aids $0 $596 $839 $0 $0 ______________________________ 603 33425.00 Other State Grants & Aids 0000 0______________________________ 603 33620.00 Other County Grants & Aids 0 125 0 0 0 ______________________________ 603 34108.00 Administrative Fees-Other Funds 11,796 9,327 11,753 6,300 6,300 5% of 5% Fees-Const Projects 603-34115.00 Buffer Monumentation 0 1,800 2,450 3,000 2,000 ______________________________ 603 36101.00 Principal - Special Assessments 25,339 23,418 24,414 25,000 25,000 ______________________________ 603 36102.00 Penalties & Interest - S/A 157 366 417 0 0 ______________________________ 603 36210.00 Interest Earnings - Investments 77,293 126,227 83,834 35,000 40,000 ______________________________ 603 36214.00 Net Change in FV-Investments (2,708) (2,944) 78,746 0 0 Annual Market Value Changes 603 36215.00 Interest Earnings 857 3,826 2,076 300 1,000 ______________________________ 603 36260.00 Other Revenues 29 0 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,267,924 1,295,790 1,422,689 1,500,000 1,539,554 0% Annual Rate Incr. (Rate Model) 603 37360.00 Penalties - Storm Water Utility 11,627 6,272 3,118 7,000 7,000 ______________________________ 603 39103.00 Gain or Loss from F/A Disposal 0000 0______________________________ 603 39203.00 Transfer From______________ 0 492,427 81,291 0 0 ______________________________ ---------------- ---------------- ---------------- ---------------- ---------------- ---------------- FUND TOTALS $1,392,314 $1,957,229 $1,711,626 $1,576,600 $1,620,854 ========= ========= ========= ========= ========= ========= Page One 2022 BUDGET WORKSHEETS STORM WATER UTILITY - EXPENDITURES - April 30, 2021 2022 2021 Object 2022 2018 2019 2020 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------- ---------- ------------------------------------------------ ---------------- ---------------- ---------------- ---------------- ---------------- ---------------- ------------------------------------------------ All Salary Costs Inclusive of 603 49500 101.00 Salaries & Benefits $553,800 Salary, Taxes, PERA & Benefits 603 49500 77 101.00 Administrative 77,299 153,628 230,897 175,700 176,900 ______________________________ 603 49500 78 101.00 Technical/Clerical 89,040 196,702 230,385 228,900 263,200 Added P/T GIS Technician 603 49500 79 101.00 Maintenance 107,093 110,285 96,455 109,000 113,700 ______________________________ 603 49500 xx 101.00 Salary & Benefit Contingency 0000 0______________________________ 603 49500 102.00 Full-Time Overtime 7,705 9,574 7,134 6,000 6,000 ______________________________ 603 49500 99 103.00 Part-Time Salaries & Benefits 8,345 7,596 3,713 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 1,092 0 75 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 86 0 704 500 500 Stakes, Ribbons, Level, etc. 603 49500 01 212.00 Motor Fuels 6,000 4,700 4,700 4,700 4,700 3% Covered by Storm Utility 603 49500 01 224.00 Street Maintenance Materials 5,241 1,775 3,046 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. 973 765 703 3,000 3,000 ______________________________ 603 49500 01 225.02 Black Dirt, Seed, Sod, etc. 945 240 1,217 1,000 1,000 ______________________________ 603 49500 01 226.00 Sign Repair Materials 160 4,443 0 3,000 3,000 Wetland Buffer Signs 603 49500 01 230.00 Repair Materials & Supplies 1,418 1,368 2,598 3,000 3,000 Culverts, Catch Basins, Structures 603 49500 01 240.00 Safety Equipment & PPE 0 0 509 500 500 Vests, Glasses, Hardhats, etc. 603 49500 01 241.00 Small Tools 1,211 923 309 1,500 1,500 ______________________________ 603 49500 01 242.00 Minor Equipment 1,286 2,972 7,508 3,500 3,500 Locator in 2021 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 8,202 14,197 5,866 5,000 5,000 ______________________________ 603 49500 01 303.03 CSMP Update 69,832 12,965 0 2,000 2,000 ______________________________ 603 49500 01 303.04 Miscellaneous 34,730 45,435 99,045 10,000 10,000 ______________________________ 603 49500 01 303.05 GIS 52 0 0 1,000 1,000 $5,000 Split 5 Ways 603 49500 01 304.00 Legal Fees 1,886 34 425 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,436 1,794 1,824 2,500 2,500 $7,500 Split 3 Ways 603 49500 01 313.00 Outsource Bill Printing/Mailing 2,201 6,618 6,221 8,300 8,300 ______________________________ 603 49500 01 315.00 Special Programs 6,437 4,500 2,700 5,000 5,000 WHEP 603 49500 01 318.00 Contract Engineer 0000 0______________________________ 603 49500 01 319.00 Other Professional Services 10,000 ______________________________ 603 49500 01 319.01 SCADA 0 4,223 1,265 5,000 5,000 ______________________________ 603 49500 01 319.02 Lift Station Inspection 0 0 0 3,500 3,500 Pump Inspection at All Lift Stations 603 49500 01 319.03 Landscape Maintenance 0 0 0 1,500 1,500 At Lift Stations 603 49500 01 320.00 Credit Card Activity Fees 7,767 9,409 11,248 9,500 9,500 1/3 Cost of C/C Pymt Processing 603 49500 01 321.00 Telephone Costs 3,541 4,266 4,857 5,000 5,000 Cell Phones, Modems, GPS 603 49500 01 322.00 Postage Costs 2,853 310 265 400 400 Outsource Mailing (313.00) 603 49500 01 323.00 Radio Units 6,082 6,282 5,255 1,000 1,000 ______________________________ 603 49500 01 352.00 General Notices & Public Info 0 0 1,234 1,000 1,000 ______________________________ 603 49500 01 365.00 Workers Comp Insurance 7,647 10,255 11,658 6,000 6,000 Storm Water's Share of Premiums 603 49500 01 369.00 Other Insurance 1,746 1,814 1,935 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,159 2,372 2,203 2,200 2,200 ______________________________ 603 49500 01 391.02 Auto Read Software Support 650 650 808 700 700 ______________________________ 603 49500 01 393.00 P.C. Hardware Purchases 1,967 361 1,487 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 8,954 9,714 10,420 10,500 10,500 ESRI, Cartegraph, DataLink 603 49500 01 394.02 Online Subscriptions 234 0 0 300 300 Pictometry 603 49500 01 394.03 New Software Purchases 0 983 0 200 200 ______________________________ 603 49500 01 403.00 Contracted R & M - Other Impr 160,000 ______________________________ 603 49500 01 403.01 Ditching 1,008 0 1,325 10,000 10,000 ______________________________ 603 49500 01 403.02 Catch Basins, Manholes, Etc. 43,322 93,304 33,076 150,000 150,000 MH Repairs 603 49500 01 403.03 Pond Inspection & Maintenance 0 0 57,384 0 0 ______________________________ 603 49500 01 405.00 MS4 Permit Compliance 140,000 ______________________________ 603 49500 01 405.01 Engineering Fees 31,594 43,408 30,282 45,000 45,000 Inspection, GIS, Guidance, Etc. 603 49500 01 405.02 Equipment Rental 0 72,789 18,514 20,000 20,000 Bulldozer, Large Equipment 603 49500 01 405.03 Dirt, Seed, Rip Rap, Etc. 0 607 0 5,000 5,000 For Restoration 603 49500 01 405.04 Contracted Maintenance 3,030 59,671 45,200 70,000 70,000 Brush Clearing, Dredging 603 49500 01 416.00 Machinery Rental 0 0 373 2,500 2,500 Pumps 603 49500 01 433.00 Dues & Subscriptions 49 994 2,600 3,200 3,200 SUSA w/602, MN SW Coal, WS Part 603 49500 01 435.00 Books & Pamphlets 0 81 0 500 500 Utility Information 603 49500 01 437.00 Conferences & Seminars 3,700 ______________________________ 603 49500 01 437.01 Storm Water Management 0 737 360 1,200 1,200 Stormwater Collab, Flygt Training 603 49500 01 437.04 Cartegraph, ESRI, GIS 607 0 491 500 500 User Group, Conference, Training 603 49500 01 437.05 Miscellaneous Training 430 583 250 2,000 2,000 ______________________________ 603 49500 01 439.00 Other Miscellaneous Charges 360 421 392 300 300 ______________________________ ---------------- ---------------- ---------------- ---------------- ---------------- ---------------- PAGE TOTALS 556,668 903,747 948,918 955,800 996,000 Page Two 2022 BUDGET WORKSHEETS STORM WATER UTILITY - EXPENDITURES - April 30, 2021 2022 2021 Object 2022 2018 2019 2020 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------- ---------- ------------------------------------------------ ---------------- ---------------- ---------------- ---------------- ---------------- ---------------- ------------------------------------------------ 603 49500 01 530.00 Improvements Other Than Bldgs 260,000 ______________________________ 603 49500 01 530.01 CRP of Storm Sewer 0 0 0 60,000 60,000 ______________________________ 603 49500 01 530.02 Stormwater System Improvements 0 0 197,227 200,000 200,000 ______________________________ 603 49500 01 540.00 Heavy Machinery Purchases 31,714 4,538 26,327 170,500 170,500 Side Flail Mower, Sweeper 603 49500 01 548.00 Lease Program-P.W. Vehicles 0 0 1,366 4,700 4,700 Vehicle Leases 603 49500 01 550.00 Motor Vehicle Purchases 0 43,070 0 0 0 ______________________________ 603 49500 01 560.00 Furniture & Fixture Purchases 0 0 0 500 500 ______________________________ 603 49500 01 580.00 Other Equipment Purchases 24,754 0 2,886 12,000 12,000 Hose Trailer in 2020 603 49500 01 586.00 Computer Equipment Purchases 81 0 0 500 500 ______________________________ 603 49500 01 611.00 Interest on Lease Payment 0 0 117 0 0 ______________________________ 603 49500 01 710.00 Transfers 0 ______________________________ 603 49500 01 710.06 1/2 of 2018 P & I Payments(2010A)00000 Final Payment 2/1/18 603 49500 01 710.10 Projects 43,887 296,254 243,765 0 0 ______________________________ ---------------- ---------------- ---------------- ---------------- ---------------- ---------------- 603-49500-01 TOTALS 657,105 1,247,609 1,420,608 1,404,000 1,444,200 603 49511 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49511 01 381.00 Electric Utilities 270 312 289 500 500 ______________________________ 603 49511 01 403.00 Contracted Repair & Maintenance 0 1,197 347 1,000 1,000 ______________________________ ---------------- ---------------- ---------------- ---------------- ---------------- ---------------- (Copper Pond) TOTAL - LIFT STATION #1 270 1,508 637 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 1,868 140 80,211 1,000 1,000 ______________________________ ---------------- ---------------- ---------------- ---------------- ---------------- ---------------- (Schwarz Pond) TOTAL - LIFT STATION #2 1,868 140 80,211 2,000 2,000 603 49513 01 221.00 Equipment Parts 49 9 0 500 500 ______________________________ 603 49513 01 381.00 Electric Utilities 6,577 8,784 8,342 7,200 7,200 ______________________________ 603 49513 01 403.00 Contracted Repair & Maintenance 0 1,477 347 1,000 1,000 ______________________________ ---------------- ---------------- ---------------- ---------------- ---------------- ---------------- (Birger Pond) TOTAL - LIFT STATION #3 6,626 10,269 8,689 8,700 8,700 603 49514 01 221.00 Equipment Parts 65 0 0 500 500 ______________________________ 603 49514 01 381.00 Electric Utilities 1,178 2,008 889 2,500 2,500 ______________________________ 603 49514 01 403.00 Contracted Repair & Maintenance 488 817 747 1,000 1,000 ______________________________ ---------------- ---------------- ---------------- ---------------- ---------------- ---------------- (Marcotte Pond) TOTAL - LIFT STATION #4 1,731 2,824 1,637 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 347 1,000 1,000 ______________________________ ---------------- ---------------- ---------------- ---------------- ---------------- ---------------- (Hawkins Pond) TOTAL - LIFT STATION #5 0 0 347 2,000 2,000 603 49516 01 221.00 Equipment Parts 0 144 0 500 500 ______________________________ 603 49516 01 381.00 Electric Utilities 416 468 465 500 500 ______________________________ 603 49516 01 403.00 Contracted Repair & Maintenance 0 507 1,467 1,000 1,000 ______________________________ ---------------- ---------------- ---------------- ---------------- ---------------- ---------------- (Glendalough 7th) TOTAL - LIFT STATION #6 416 1,119 1,932 2,000 2,000 603 49517 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49517 01 381.00 Electric Utilities 551 992 720 500 500 ______________________________ 603 49517 01 403.00 Contracted Repair & Maintenance 0 160 1,251 1,000 1,000 ______________________________ ---------------- ---------------- ---------------- ---------------- ---------------- ---------------- (Horseshoe Lake) TOTAL - LIFT STATION #7 551 1,152 1,971 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 224 500 500 ______________________________ 603 49518 01 403.00 Contracted Repair & Maintenance 0 0 2,102 1,000 1,000 ______________________________ ---------------- ---------------- ---------------- ---------------- ---------------- ---------------- (Dunmore) TOTAL - LIFT STATION #8 0 0 2,326 2,000 2,000 GRAND TOTAL - ALL DEPTS. $668,566 $1,264,622 $1,518,357 $1,428,700 $1,468,900 ========= ========= ========= ========= ========= ========= Page One 2022 BUDGET WORKSHEETS STREET LIGHT UTILITY - REVENUES - April 30, 2021 2022 2021 Object 2022 2018 2019 2020 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 19,008 0 0 __________________________ 608-36101.00 Principal - Special Assessments 0 0 3,620 0 0 __________________________ 608-36102.00 Penalties & Interest - S/A 0 0 0 0 0 __________________________ 608-36210.00 Interest Earnings - Investments 0 0 0 0 0 __________________________ 608-36215.00 Interest Earnings 0 0 9 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 226,771 220,000 238,738 __________________________ 608-37460.00 Penalties - Street Light Revenues 0 0 775 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 $250,183 $220,000 $238,738 ========== ========== ========== ========= ========= ========= - EXPENDITURES - 2022 2021 Object 2022 2018 2019 2020 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 1,602 0 2,050 __________________________ 608 49508 01 304.00 Legal Fees 0 0 0 0 0 __________________________ 608 49508 01 313.00 Outsource Bill Print/Mail 0 0 1,715 0 3,075 __________________________ 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 322.00 Postage Costs 0 0 39 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 183,624 185,000 190,550 __________________________ 608 49508 01 394.00 P.C. Software Purchases 0 0 750 0 0 __________________________ 608 49508 01 409.00 Other Contracted Repair & Maint. 0 0 5,384 15,000 15,375 __________________________ 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,500 __________________________ 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 $193,113 $220,000 $231,550 ========== ========== ========== ========= ========= =========