|
2026 Water and Sanitary Sewer Operations
<br />Pro Forma Financial Guide
<br />ACCOUNT ACCOUNT 2025 2026
<br />NUMBER DESCRIPTION Budget Budget Notes
<br />Professional Services:
<br />601-494.300-402.213 Water Bacteria Testing 3,000.00$ 3,300.00$ $275 month
<br />601-494.300-403.306 Random Personnel Testing 220.00$ 225.00$ New personnel policy provision
<br />601-494.300-403.330 Building Cleaning Services (contract) 5,040.00$ 5,160.00$ $430/month (1/3)
<br />601-494.300-403.330 - Window & Exterior Washing 1,008.00$ 1,033.00$ Additional services above cleaning contract
<br />601-494.300-403.350 Scada System Troubleshooting 2,000.00$ 2,500.00$ Contingency budget
<br />601-494.300-403.390 Safety Training 2,100.00$ 2,166.00$ OSHA required safety training (1/3)
<br />13,368.00$ 14,384.00$
<br /> Engineering:
<br />601-494.300-403.303 Engineering - Non-specific engineering fees 15,000.00$ 15,000.00$ Contingency budget
<br />15,000.00$ 15,000.00$
<br />Utilities:
<br />601-494.100-408.381 Electricity:
<br /> - Xcel - Public Works Facility 20,811.00$ 21,643.00$ 4% Increase (+ increase for new facility)
<br /> - Xcel - Well No. 2 8,485.00$ 8,825.00$ 4% Increase above 2025 actual
<br /> - Xcel - Well No. 3 22,220.00$ 23,110.00$ 4% Increase above 2025 actual
<br /> - Xcel - Tower No. 3 10,505.00$ 10,925.00$ 4% Increase above 2025 actual
<br /> - Xcel - Tower No. 4 10,505.00$ 10,925.00$ 4% Increase above 2025 actual
<br /> - Xcel - Well No. 4 22,220.00$ 23,109.00$ Same as Well No. 3
<br /> - Xcel - Well No. 5 22,220.00$ 23,109.00$ Same as Well No. 3
<br /> - Xcel - Well No. 6 30,735.00$ 31,965.00$ Larger Well
<br /> - BHE - Well No. 2 (solar garden contract) 11,475.00$ 11,935.00$ 4% Increase above 2025 actual
<br /> - BHE - Well No. 3 (solar garden contract) 21,735.00$ 22,605.00$ 4% Increase above 2025 actual
<br /> - BHE - Well No. 4 (solar garden contract) 25,575.00$ 26,600.00$ 4% Increase above 2025 actual
<br /> - BHE - Well No. 5 (solar garden contract) 19,655.00$ 20,445.00$ 4% Increase above 2025 actual
<br /> - BHE - Well No. 6 (solar garden contract) 16,845.00$ 17,520.00$ 4% Increase above 2025 actual
<br />242,986.00$ 252,716.00$
<br />601-494.100-408.383 Gas for Public Works Facility 22,692.00$ 22,805.00$ 8.2% Increase (+ increase for new facility)
<br />601-494.300-408.384 Refuse Disposal 9,000.00$ 9,300.00$ Gene's Disposal (1/3)
<br />274,678.00$ 284,821.00$
<br />Communications:
<br />601-494.300-404.321 Cellular Phone Charges 4,800.00$ 5,100.00$ $300/month plus $1,500 equipment & accessories
<br />601-494.300-404.321 Business Internet - Comcast (upgraded speed) 3,000.00$ 3,100.00$ 100mb service (up from 20mb service)
<br />601-494.300-404.321 Data Plan for Cradle Point at Tower No. 4/Well No. 6 600.00$ 600.00$ Allows for keycard access ($50/month - Verizon)
<br />601-494.300-404.321 Scada Dialer 360.00$ 360.00$ $60/month - Verizon (1/2)
<br />601-494.300-404.321 Scada Wireless Communication 5,275.00$ 5,720.00$ 5 Wells, 2 Towers & 1/3 PW Bldg ($65/month each)
<br />14,035.00$ 14,880.00$
<br />Travel & Training:
<br />601-494.300-405.331 Training Classes 3,500.00$ 4,250.00$ Water school, exams, and certificate renewals, SCADA Training
<br />3,500.00$ 4,250.00$
<br />Contractual Maintenance:
<br />601-494.400-409.404 Alarm System Maintenance Agreement 1,440.00$ 1,512.00$ Annual Testing (1/3)
<br />601-494.400-409.404 - Alarm System Monitoring 397.00$ 457.00$ Nardini Alarm System Monitoring (1/3)
<br />601-494.400-409.404 Fleet Maintenance Software Annual Support 187.00$ 206.00$ Software Annual Support (1/3)
<br />601-494.400-409.404 Scan Tool Software Annual Support 405.00$ 486.00$ Yearly updates to vehicle diagnostic scan tool (1/3)
<br />2,429.00$ 2,661.00$
<br />Professional Memberships:
<br />601-494.300-412.433 Dues 175.00$ 200.00$ American Public Works Assn
<br />601-494.300-412.433 Dues 275.00$ 300.00$ Minnesota Rural Water Assn
<br />601-494.300-412.433 Dues 450.00$ 475.00$ American Waterworks Assn
<br />900.00$ 975.00$
<br />Software:
<br />601-494.300-413.514 Fleet Maintenance Software -$ -$ Purchased new in 2024
<br />-$ -$
<br />Administration
<br />Wages:
<br />601-494.400-401.109 City Administrator 58,475.00$ 61,072.00$ 25% of Pay Grade 14 Maximum
<br />601-494.400-401.101 Billing Clerk -$ -$ 50% of Pay Grade 4 Minimum
<br />601-494.400-401.101 Compensated Absences -$ -$ 50% of increase in PTO Bank
<br />601-494.400-401.101 Administrative Assistant 15,775.00$ 17,216.00$ 25% of Pay Grade 4 Step 4
<br />601-494.400-401.101 Compensated Absences 1,000.00$ 1,000.00$ 25% of increase in PTO Bank
<br />601-494.400-401.106 In Lieu of Health Insurance - Assistant 1,500.00$ -$ $125/month for waived coverage
<br />601-494.400-401.113 Part-Time Billing Clerk 14,528.00$ 15,113.00$ 50% of 780 hours at $38.75
<br />91,278.00$ 94,401.00$
<br />Fringe Benefits:
<br />601-494.400-401.121 Pera - City Administrator 4,386.00$ 4,581.00$ 7.5% of Salary
<br />601-494.400-401.121 Pera - Billing Clerk -$ -$ 7.5% of Salary
<br />601-494.400-401.121 Pera - Administrative Assistant 1,183.00$ 1,292.00$ 7.5% of Salary
<br />601-494.400-401.121 Pera - Part-Time Billing Clerk 1,090.00$ 1,134.00$ 7.5% of Salary
<br />601-494.400-401.122 Fica - City Administrator 3,626.00$ 3,787.00$ 6.2% of Salary
<br />601-494.400-401.122 Fica - Billing Clerk -$ -$ 6.2% of Salary
<br />601-494.400-401.122 Fica - Administrative Assistant 979.00$ 1,068.00$ 6.2% of Salary
<br />601-494.400-401.122 Fica - Part-Time Billing Clerk 901.00$ 937.00$ 6.2% of Salary
<br />601-494.400-401.123 Medicare - City Administrator 848.00$ 886.00$ 1.45% of Salary
<br />601-494.400-401.123 Medicare - Billing Clerk -$ -$ 1.45% of Salary
<br />601-494.400-401.123 Medicare - Administrative Assistant 229.00$ 250.00$ 1.45% of Salary
<br />601-494.400-401.123 Medicare - Part-Time Billing Clerk 211.00$ 220.00$ 1.45% of Salary
<br />601-494.400-401.131 Health Insurance - Billing Clerk -$ -$ 50% of HealthPartners High-Deductible Plan
<br />601-494.400-401.131 Health Insurance - Administrative Assistant -$ 2,055.00$ 25% of HealthPartners High-Deductible Plan
<br />601-494.400-401.131 Contributions to Employee Health Savings Accounts -$ -$ Offset Higher Deductible
<br />601-494.400-401.132 Dental Insurance - Billing Clerk -$ -$ 50% of Delta Dental Plan
<br />601-494.400-401.132 Dental Insurance - Administrative Assistant 313.00$ 313.00$ 25% of Delta Dental Plan
<br />601-494.400-401.137 Vision Insurance - Administrative Assistant -$ 18.00$ 25% of Vision Plan
<br />601-494.400-401.136 Minnesota Paid Leave Premiums -$ 411.00$ Premiums to start in 2026 (mandated employer share 0.44% of 0.88%)
<br />601-494.400-401.151 Worker's Compensation - Billing Clerk -$ -$ $0.00/100*$1.12 (March - March)
<br />601-494.400-401.151 Worker's Compensation - Administrative Assistant 180.00$ 201.00$ $17,216/100*$1.12 (March - March)
<br />601-494.400-401.151 Worker's Compensation - Part-Time Billing Clerk 163.00$ 176.00$ $15,113/100*$1.12 (March - March)
<br />14,109.00$ 17,329.00$
<br />Supplies:
<br />601-494.400-402.200 Office Supplies 8,400.00$ 8,500.00$ Utility bills and envelopes, standard supplies
<br />601-494.400-402.200 - Utility Bill Printing & Mailing (outsourced) 3,000.00$ 3,500.00$ Outsourced to Graphic Resources Inc
<br />601-494.400-402.200 - Utility Rate Change Sheets 600.00$ 700.00$ Print rate change sheets
<br />601-494.400-402.200 - Pervasive Software Upgrade 350.00$ 400.00$ Needed to operate FundBalance Software
<br />601-494.400-402.200 - Netmotion Services/Remote 350.00$ 350.00$ Remote Connection
<br />12,700.00$ 13,450.00$
<br />601-494.400-402.201 Breakroom Supplies 1,800.00$ 2,000.00$ RLC moved to Gen Govt Bldgs
<br />601-494.400-402.205 Water Brochures 125.00$ 125.00$ Department of Health requirement
<br />Page 2
|