|
2025 Water and Sanitary Sewer Operations
<br />Pro Forma Financial Guide
<br />ACCOUNT ACCOUNT 2024 2025
<br />NUMBER DESCRIPTION Budget Budget Notes
<br />WATER REVENUES: Budget Budget
<br />601-371.000-371.100 Water Billings:
<br /> - Residential 1,312,334.00$ 1,459,565.00$ Based on 2024 Actual Usage
<br /> - Multi Family 140,000.00$ 182,500.00$ Based on 2024 Actual Usage
<br /> - Irrigation 475,000.00$ 470,500.00$ Based on 2024 Actual Usage
<br /> - Less City Irrigation Accounts (35,000.00)$ (35,000.00)$ Based on 2024 Actual Usage
<br /> - Commercial 35,000.00$ 43,500.00$ Based on 2024 Actual Usage
<br /> - Industrial 20,000.00$ 23,750.00$ Based on 2024 Actual Usage
<br /> - Educational 3,600.00$ 4,500.00$ Based on 2024 Actual Usage
<br />601-371.000-371.100 Water Billings 1,950,934.00$ 2,149,315.00$
<br />601-371.000-371.100 Account Adjustments -$ -$ Small adjustments to accounts receivable
<br />601-371.000-371.100 Hydrant Water Sales 2,000.00$ 2,500.00$ Truck loads of unmetered hydrant water
<br />601-371.000-371.600 Water Penalties 20,000.00$ 20,000.00$ Based on 2024 Actual
<br />601-371.000-371.700 Water Meters 25,000.00$ 23,500.00$ $470 x 50 new homes
<br />601-371.000-371.800 Smart Irrigation Controllers -$ -$ Only a few left….grant program over
<br />TOTAL WATER REVENUES 1,997,934.00$ 2,195,315.00$
<br />WATER EXPENSES: Budget Budget
<br />Operation & Maintenance
<br />Wages:
<br />601-494.300-401.101 Public Works Director 52,152.00$ 54,759.00$ 33% of Pay Grade 11 Max
<br />601-494.300-401.101 - 27 Pay Periods in 2024 1,837.00$ -$ 27 Pay Periods in 2024
<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 35,037.00$ 38,459.00$ 33% of Pay Grade 8 Max
<br />601-494.300-401.101 - 27 Pay Periods in 2024 1,235.00$ -$ 27 Pay Periods in 2024
<br />601-494.300-401.101 Compensated Absences - Superintendent 1,000.00$ 2,000.00$ 33% of increase in PTO Bank
<br />601-494.300-401.101 Lead Worker 38,027.00$ 41,724.00$ 50% of Pay Grade 6 Step 4
<br />601-494.300-401.101 - 27 Pay Periods in 2024 1,400.00$ -$ 27 Pay Periods in 2024
<br />601-494.300-401.106 In Lieu of Health Insurance - Lead Worker 3,000.00$ 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 38,587.00$ 40,517.00$ 50% of Pay Grade 5 Maximum
<br />601-494.300-401.101 - 27 Pay Periods in 2024 1,421.00$ -$ 27 Pay Periods in 2024
<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,240.00$ 10,400.00$ 50% of $400/week
<br />601-494.300-401.113 Overtime - Superintendent 5,255.00$ 5,770.00$ 33% of 208 hours (10%) @ overtime rate
<br />601-494.300-401.113 Overtime - Lead Worker 5,704.00$ 6,259.00$ 104 hours (10%) @ overtime rate
<br />601-494.300-401.113 Overtime - Maint Worker 5,788.00$ 6,078.00$ 104 hours (10%) @ overtime rate
<br />204,683.00$ 212,966.00$
<br />Fringe Benefits:
<br />601-494.300-401.121 Pera - Director 4,050.00$ 4,107.00$ 7.5% of Salary
<br />601-494.300-401.121 Pera - Superintendent 3,115.00$ 3,317.00$ 7.5% of Salary & Overtime
<br />601-494.300-401.121 Pera - Lead Worker 3,385.00$ 3,599.00$ 7.5% of Salary & Overtime
<br />601-494.300-401.121 Pera - Maint Worker 3,435.00$ 3,495.00$ 7.5% of Salary & Overtime
<br />601-494.300-401.121 Pera - Standby Pay 768.00$ 780.00$ 7.5% of Standby Pay
<br />601-494.300-401.122 Fica - Director 3,348.00$ 3,396.00$ 6.2% of Salary
<br />601-494.300-401.121 Fica - Superintendent 2,575.00$ 2,743.00$ 6.2% of Salary & Overtime
<br />601-494.300-401.122 Fica - Lead Worker 2,798.00$ 2,975.00$ 6.2% of Salary & Overtime
<br />601-494.300-401.122 Fica - Maint Worker 2,840.00$ 2,889.00$ 6.2% of Salary & Overtime
<br />601-494.300-401.122 Fica - Standby Pay 635.00$ 645.00$ 6.2% of Standby Pay
<br />601-494.300-401.123 Medicare - Director 783.00$ 794.00$ 1.45% of Salary
<br />601-494.300-401.123 Medicare - Superintendent 602.00$ 642.00$ 1.45% of Salary & Overtime
<br />601-494.300-401.123 Medicare - Lead Worker 654.00$ 696.00$ 1.45% of Salary & Overtime
<br />601-494.300-401.123 Medicare - Maint Worker 664.00$ 676.00$ 1.45% of Salary & Overtime
<br />601-494.300-401.123 Medicare - Standby Pay 149.00$ 151.00$ 1.45% of Standby Pay
<br />601-494.300-401.131 Health Insurance - Director 11,163.00$ 12,642.00$ 33% of HealthPartners High-Deductible Plan
<br />601-494.300-401.131 Health Insurance - Superintendent 4,711.00$ 5,386.00$ 33% of HealthPartners High-Deductible Plan
<br />601-494.300-401.131 Health Insurance - Maint Worker 6,782.00$ 7,806.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 587.00$ 604.00$ 33% of Delta Dental Plan
<br />601-494.300-401.132 Dental Insurance - Superintendent 205.00$ 209.00$ 33% of Delta Dental Plan
<br />601-494.300-401.132 Dental Insurance - Maint Worker -$ -$ 50% of Delta Dental Plan
<br />601-494.300-401.132 Dental Insurance - Maint Worker 308.00$ 313.00$ 50% of Delta Dental Plan
<br />601-494.300-401.151 Worker's Compensation - Director 6,986.00$ 7,777.00$ $54,759/100*$13.59 (March - March)
<br />601-494.300-401.151 Worker's Compensation - Superintendent 5,373.00$ 6,281.00$ $44,229/100*$13.59 (March - March)
<br />601-494.300-401.151 Worker's Compensation - Lead Worker 5,840.00$ 6,815.00$ $47,983/100*$13.59 (March - March)
<br />601-494.300-401.151 Worker's Compensation - Maint Worker 5,926.00$ 6,618.00$ $46,595/100*$13.59 (March - March)
<br />601-494.300-401.151 Worker's Compensation - Standby Pay -$ -$ Exempt from work comp
<br />77,682.00$ 85,356.00$
<br />Supplies:
<br />601-494.300-402.211 Cleaning Supplies 3,250.00$ 3,750.00$ Floor mats, restroom supplies, first aid supplies….
<br />601-494.300-402.213 Chemicals 50,000.00$ 60,000.00$ Added at 5 wells (chlorine, fluoride…)
<br />601-494.300-402.213 - Hazardous Waste Generators License 350.00$ 375.00$ Hazardous Waste Generators License
<br />601-494.300-402.212 Motor Fuels 7,565.00$ 7,945.00$ Water Department's share of bulk fuel purchases
<br />601-494.300-402.240 Small Tools & Equipment 16,000.00$ 18,000.00$ Shop tools, shelving, cold-weather gear…
<br />601-494.300-402.240 - Tire Balancer (1/3) 2,000.00$ -$ Purchased in 2024
<br />601-494.300-403.317 Uniforms 2,520.00$ 2,700.00$ $225/month
<br />601-494.300-402.232 Smart Controllers (for irrigation systems) -$ -$ Program Over - Sales tax on 20 controllers
<br />601-494.300-402.214 Water Meters 80,000.00$ 85,000.00$ Radio Meters
<br />161,685.00$ 177,770.00$
<br />Repairs & Maintenance:
<br />601-494.300-402.220 Repairs & Maintenance 40,500.00$ 43,000.00$ Lubricants, shop supplies, vehicle maint…
<br />601-494.300-402.220 - Hydrant Repairs 30,000.00$ 35,000.00$ Materials to repair hydrants
<br />601-494.300-402.220 - Watermain Breaks 30,000.00$ 36,000.00$ 3 watermain breaks @ $12,000
<br />601-494.300-402.220 - Well Tech Labor & VFD 45,000.00$ 50,000.00$ Contingency budget for repairs and upgrades
<br />601-494.300-402.220 - Well Pump Repairs 40,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$ 10,000.00$ 100 hydrants @ $100 - contractual services
<br />601-494.300-402.220 - Air Compressor Maintenance & Repairs 833.00$ 1,500.00$ Repairs to air compressor unit (1/3)
<br />601-494.300-402.223 Building Repair & Maintenance 7,500.00$ 8,000.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 7,500.00$ 8,000.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 9,500.00$ 21,500.00$ Performed by Davis Mechanical
<br />601-494.300-402.223 - Generator Maintenance & Repairs 589.00$ 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 136.00$ 150.00$ Mobile Access (1/3)
<br />601-494.300-402.223 - Pest Control 740.00$ 780.00$ $195/month (1/3)
<br />601-494.300-402.223 - Holiday Lighting 1,250.00$ 334.00$ Holiday Lighting Installation (1/3)
<br />Page 1
|