|
2026 Water and Sanitary Sewer Operations
<br />Pro Forma Financial Guide
<br />ACCOUNT ACCOUNT 2025 2026
<br />NUMBER DESCRIPTION Budget Budget Notes
<br />WATER REVENUES: Budget Budget
<br />601-371.000-371.100 Water Billings:
<br /> - Residential 1,459,565.00$ 1,607,715.00$ Based on 2025 Actual Usage
<br /> - Multi Family 182,500.00$ 200,000.00$ Based on 2025 Actual Usage
<br /> - Irrigation 470,500.00$ 520,000.00$ Based on 2025 Actual Usage
<br /> - Less City Irrigation Accounts (35,000.00)$ (35,000.00)$ Based on 2025 Actual Usage
<br /> - Commercial 43,500.00$ 47,500.00$ Based on 2025 Actual Usage
<br /> - Industrial 23,750.00$ 25,750.00$ Based on 2025 Actual Usage
<br /> - Educational 4,500.00$ 5,000.00$ Based on 2025 Actual Usage
<br />601-371.000-371.100 Water Billings 2,149,315.00$ 2,370,965.00$
<br />601-371.000-371.100 Account Adjustments -$ -$ Small adjustments to accounts receivable
<br />601-371.000-371.100 Hydrant Water Sales 2,500.00$ 2,750.00$ Truck loads of unmetered hydrant water
<br />601-371.000-371.600 Water Penalties 20,000.00$ 20,000.00$ Based on 2025 Actual
<br />601-371.000-371.700 Water Meters 23,500.00$ 23,850.00$ $477 x 50 new homes
<br />TOTAL WATER REVENUES 2,195,315.00$ 2,417,565.00$
<br />WATER EXPENSES: Budget Budget
<br />Operation & Maintenance
<br />Wages:
<br />601-494.300-401.101 Public Works Director 54,759.00$ 57,190.00$ 33% of Pay Grade 11 Max
<br />601-494.300-401.101 Compensated Absences - PW Director 2,000.00$ 2,000.00$ 33% of increase in PTO Bank
<br />601-494.300-401.101 Public Works Superintendent 38,459.00$ 40,166.00$ 33% of Pay Grade 8 Max
<br />601-494.300-401.101 Compensated Absences - Superintendent 2,000.00$ 2,000.00$ 33% of increase in PTO Bank
<br />601-494.300-401.101 Lead Worker 41,724.00$ 47,604.00$ 50% of Pay Grade 6 Max
<br />601-494.300-401.106 In Lieu of Health Insurance - Lead Worker 3,000.00$ -$ $250/month for waived coverage
<br />601-494.300-401.101 Compensated Absences - Lead Worker 1,000.00$ 1,000.00$ 50% of increase in PTO Bank
<br />601-494.300-401.101 Maintenance Worker 40,517.00$ 42,315.00$ 50% of Pay Grade 5 Maximum
<br />601-494.300-401.101 Compensated Absences - Maintenance Worker 1,000.00$ 1,000.00$ 50% of increase in PTO Bank
<br />601-494.300-401.111 Standby Pay 10,400.00$ 10,920.00$ 50% of $420/week
<br />601-494.300-401.113 Overtime - Superintendent 5,770.00$ 6,025.00$ 33% of 208 hours (10%) @ overtime rate
<br />601-494.300-401.113 Overtime - Lead Worker 6,259.00$ 7,141.00$ 104 hours (10%) @ overtime rate
<br />601-494.300-401.113 Overtime - Maint Worker 6,078.00$ 6,348.00$ 104 hours (10%) @ overtime rate
<br />212,966.00$ 223,709.00$
<br />Fringe Benefits:
<br />601-494.300-401.121 Pera - Director 4,107.00$ 4,290.00$ 7.5% of Salary
<br />601-494.300-401.121 Pera - Superintendent 3,317.00$ 3,465.00$ 7.5% of Salary & Overtime
<br />601-494.300-401.121 Pera - Lead Worker 3,599.00$ 4,106.00$ 7.5% of Salary & Overtime
<br />601-494.300-401.121 Pera - Maint Worker 3,495.00$ 3,650.00$ 7.5% of Salary & Overtime
<br />601-494.300-401.121 Pera - Standby Pay 780.00$ 819.00$ 7.5% of Standby Pay
<br />601-494.300-401.122 Fica - Director 3,396.00$ 3,546.00$ 6.2% of Salary
<br />601-494.300-401.121 Fica - Superintendent 2,743.00$ 2,864.00$ 6.2% of Salary & Overtime
<br />601-494.300-401.122 Fica - Lead Worker 2,975.00$ 3,395.00$ 6.2% of Salary & Overtime
<br />601-494.300-401.122 Fica - Maint Worker 2,889.00$ 3,018.00$ 6.2% of Salary & Overtime
<br />601-494.300-401.122 Fica - Standby Pay 645.00$ 678.00$ 6.2% of Standby Pay
<br />601-494.300-401.123 Medicare - Director 794.00$ 830.00$ 1.45% of Salary
<br />601-494.300-401.123 Medicare - Superintendent 642.00$ 670.00$ 1.45% of Salary & Overtime
<br />601-494.300-401.123 Medicare - Lead Worker 696.00$ 794.00$ 1.45% of Salary & Overtime
<br />601-494.300-401.123 Medicare - Maint Worker 676.00$ 706.00$ 1.45% of Salary & Overtime
<br />601-494.300-401.123 Medicare - Standby Pay 151.00$ 159.00$ 1.45% of Standby Pay
<br />601-494.300-401.131 Health Insurance - Director 12,642.00$ 14,746.00$ 33% of HealthPartners High-Deductible Plan
<br />601-494.300-401.131 Health Insurance - Superintendent 5,386.00$ 6,157.00$ 33% of HealthPartners High-Deductible Plan
<br />601-494.300-401.131 Health Insurance - Lead Worker -$ 23,010.00$ 50% of HealthPartners High-Deductible Plan
<br />601-494.300-401.131 Health Insurance - Maint Worker 7,806.00$ 9,036.00$ 50% of HealthPartners High-Deductible Plan
<br />601-494.300-401.131 Contributions to Employee Health Savings Accounts -$ -$ Offset Higher Deductible
<br />601-494.300-401.132 Dental Insurance - Director 604.00$ 604.00$ 33% of Delta Dental Plan
<br />601-494.300-401.132 Dental Insurance - Superintendent 209.00$ 209.00$ 33% of Delta Dental Plan
<br />601-494.300-401.132 Dental Insurance - Lead Worker -$ 905.00$ 50% of Delta Dental Plan
<br />601-494.300-401.132 Dental Insurance - Maint Worker 313.00$ 313.00$ 50% of Delta Dental Plan
<br />601-494.300-401.137 Vision Insurance - Director -$ 68.00$ 33% of Vision Plan
<br />601-494.300-401.137 Vision Insurance - Superintendent -$ 24.00$ 33% of Vision Plan
<br />601-494.300-401.137 Vision Insurance - Lead Worker -$ 102.00$ 50% of Vision Plan
<br />601-494.300-401.137 Vision Insurance - Maint Worker -$ 36.00$ 50% of Vision Plan
<br />601-494.300-401.136 Minnesota Paid Leave Premiums -$ 958.00$ Premiums to start in 2026 (mandated employer share 0.44% of 0.88%)
<br />601-494.300-401.151 Worker's Compensation - Director 7,777.00$ 8,113.00$ $57,190/100*$13.64 (March - March)
<br />601-494.300-401.151 Worker's Compensation - Superintendent 6,281.00$ 6,553.00$ $46,191/100*$13.64 (March - March)
<br />601-494.300-401.151 Worker's Compensation - Lead Worker 6,815.00$ 7,766.00$ $54,745/100*$13.64 (March - March)
<br />601-494.300-401.151 Worker's Compensation - Maint Worker 6,618.00$ 6,903.00$ $48,663/100*$13.64 (March - March)
<br />601-494.300-401.151 Worker's Compensation - Standby Pay -$ -$ Exempt from work comp
<br />85,356.00$ 118,493.00$
<br />Supplies:
<br />601-494.300-402.211 Cleaning Supplies 3,750.00$ 4,000.00$ Floor mats, restroom supplies, first aid supplies….
<br />601-494.300-402.213 Chemicals 60,000.00$ 62,500.00$ Added at 5 wells (chlorine, fluoride…)
<br />601-494.300-402.213 - Hazardous Waste Generators License 375.00$ 400.00$ Hazardous Waste Generators License
<br />601-494.300-402.212 Motor Fuels 7,945.00$ 8,345.00$ Water Department's share of bulk fuel purchases
<br />601-494.300-402.240 Small Tools & Equipment 18,000.00$ 22,000.00$ Shop tools, shelving, cold-weather gear…
<br />601-494.300-403.317 Uniforms 2,700.00$ 3,000.00$ $250/month
<br />601-494.300-402.214 Water Meters 85,000.00$ 90,000.00$ Radio Meters
<br />177,770.00$ 190,245.00$
<br />Repairs & Maintenance:
<br />601-494.300-402.220 Repairs & Maintenance 43,000.00$ 46,000.00$ Lubricants, shop supplies, vehicle maint…
<br />601-494.300-402.220 - Hydrant Repairs 35,000.00$ 35,000.00$ Materials to repair hydrants
<br />601-494.300-402.220 - Watermain Breaks 36,000.00$ 39,000.00$ 3 watermain breaks @ $13,000
<br />601-494.300-402.220 - Well Tech Labor & VFD 50,000.00$ 55,000.00$ Contingency budget for repairs and upgrades
<br />601-494.300-402.220 - Well Pump Repairs 50,000.00$ 50,000.00$ Contingency budget if any well pump fails
<br />601-494.300-402.220 - Motor Efficiency Rebate (Xcel Energy) -$ -$ One-time rebate
<br />601-494.300-402.220 - Fire Hydrant Painting 10,000.00$ 6,250.00$ 50 hydrants @ $125 - contractual services
<br />601-494.300-402.220 - Air Compressor Maintenance & Repairs 1,500.00$ 1,500.00$ Repairs to air compressor unit (1/3)
<br />601-494.300-402.223 Building Repair & Maintenance 8,000.00$ 8,500.00$ Non-specific building repairs
<br />601-494.300-402.223 - Septic System Pumping 6,000.00$ 6,000.00$ Septic System Pumping (1/3)
<br />601-494.300-402.223 - Well Electrical Work 8,000.00$ 8,500.00$ In conjunction with pump repairs
<br />601-494.300-402.223 - Weed Control 2,250.00$ 2,250.00$ Public works site and water towers
<br />601-494.300-402.223 - HVAC Repairs 21,500.00$ 21,500.00$ Performed by Davis Mechanical
<br />601-494.300-402.223 - Generator Maintenance & Repairs 755.00$ 1,755.00$ Repairs to generator (1/3)
<br />601-494.300-402.223 - Security System Annual Support 1,375.00$ 1,375.00$ Tower No. 4 & PW Bldg - Camera, Card & Fob Software Upgrades (1/3)
<br />601-494.300-402.223 - Security System Mobile Access Subscription 150.00$ 164.00$ Mobile Access (1/3)
<br />601-494.300-402.223 - Pest Control 780.00$ 800.00$ $200/month (1/3)
<br />601-494.300-402.223 - Holiday Lighting 334.00$ 334.00$ Holiday Lighting Installation (1/3)
<br />274,644.00$ 283,928.00$
<br />Page 1
|