|
2025 Water and Sanitary Sewer Operations
<br />Pro Forma Financial Guide
<br />ACCOUNT ACCOUNT 2024 2025
<br />NUMBER DESCRIPTION Budget Budget Notes
<br />601-494.500-401.123 Medicare - Standby Pay 149.00$ 151.00$ 1.45% of Standby Pay
<br />601-494.500-401.131 Health Insurance - Director 11,163.00$ 12,642.00$ 33% of HealthPartners High-Deductible Plan
<br />601-494.500-401.131 Health Insurance - Superintendent 4,711.00$ 5,386.00$ 33% of HealthPartners High-Deductible Plan
<br />601-494.500-401.131 Health Insurance - Maint Worker 6,782.00$ 7,806.00$ 50% of HealthPartners High-Deductible Plan
<br />601-494.500-401.131 Contributions to Employee Health Savings Accounts -$ -$ Offset Higher Deductible
<br />601-494.500-401.132 Dental Insurance - Director 587.00$ 604.00$ 33% of Delta Dental Plan
<br />601-494.500-401.132 Dental Insurance - Superintendent 205.00$ 209.00$ 33% of Delta Dental Plan
<br />601-494.500-401.132 Dental Insurance - Maint Worker -$ -$ 50% of Delta Dental Plan
<br />601-494.500-401.132 Dental Insurance - Maint Worker 308.00$ 313.00$ 50% of Delta Dental Plan
<br />601-494.500-401.151 Worker's Compensation - Director 6,986.00$ 7,777.00$ $54,759/100*$13.59 (March - March)
<br />601-494.500-401.151 Worker's Compensation - Superintendent 5,373.00$ 6,281.00$ $44,229/100*$13.59 (March - March)
<br />601-494.500-401.151 Worker's Compensation - Lead Worker 5,840.00$ 6,815.00$ $47,983/100*$13.59 (March - March)
<br />601-494.500-401.151 Worker's Compensation - Maint Worker 5,926.00$ 6,618.00$ $46,595/100*$13.59 (March - March)
<br />601-494.500-401.151 Worker's Compensation - Standby Pay -$ -$ Exempt from work comp
<br />77,682.00$ 85,356.00$
<br />Supplies:
<br />601-494.500-402.211 Cleaning Supplies 3,250.00$ 3,750.00$ Floor mats, restroom supplies, first aid supplies….
<br />601-494.500-402.212 Motor Fuels 7,565.00$ 7,945.00$ Sewer Department's share of bulk fuel purchases
<br />601-494.500-402.240 Small Tools & Equipment 16,000.00$ 18,000.00$ Shop tools, shelving, cold-weather gear…
<br />601-494.500-402.240 - Tire Balancer (1/3) 2,000.00$ -$ Purchased in 2024
<br />601-494.500-403.317 Uniforms 2,520.00$ 2,700.00$ $225/month
<br />31,335.00$ 32,395.00$
<br />Repairs & Maintenance:
<br />601-494.500-402.220 Repairs & Maintenance 44,000.00$ 50,000.00$ Lubricants, shop supplies, vactor maint….
<br />601-494.500-402.220 - Televise Sewer Line -$ -$ City-owned property - nonrecurring expense
<br />601-494.500-402.220 - Lift Station Rebuilds & Repairs 43,000.00$ 50,000.00$ Repairs along with VFD Drives & Control Panel Upgrades
<br />601-494.500-402.220 - Submersible Pump Repairs (Lift Stations) -$ 60,000.00$ Repair and replacement of submersible pumps
<br />601-494.500-402.220 - Air Compressor Maintenance & Repairs 833.00$ 1,500.00$ Repairs to air compressor unit (1/3)
<br />601-494.500-402.223 Building Repair & Maintenance 4,000.00$ 5,000.00$ Non-specific building repairs
<br />601-494.500-402.223 - Septic System Pumping 6,000.00$ 6,000.00$ Septic System Pumping (1/3)
<br />601-494.500-402.223 - Weed Control 500.00$ 500.00$ Public works site and lift stations
<br />601-494.500-402.223 - HVAC Repairs 9,500.00$ 16,500.00$ Performed by Davis Mechanical
<br />601-494.500-402.223 - Generator Maintenance & Repairs 589.00$ 755.00$ Repairs to generator (1/3)
<br />601-494.500-402.223 - Security System Annual Support 1,375.00$ 1,375.00$ PW Bldg - Camera, Card & Fob Software Upgrades (1/3)
<br />601-494.500-402.223 - Security System Mobile Access Subscription 136.00$ 150.00$ Mobile Access (1/3)
<br />601-494.500-402.223 - Pest Control 740.00$ 780.00$ $195/month (1/3)
<br />601-494.500-402.223 - Holiday Lighting 1,250.00$ 334.00$ Holiday Lighting Installation (1/3)
<br />111,923.00$ 192,894.00$
<br />Professional Services:
<br />601-494.500-403.303 Data Collection & Maintenance Tracking (WSB) -$ -$ Annual costs of software module
<br />601-494.500-403.330 Building Cleaning Services (contract) 4,800.00$ 5,040.00$ $420/month (1/3)
<br />601-494.500-403.330 - Window & Exterior Washing 960.00$ 1,008.00$ Additional services above cleaning contract
<br />601-494.500-403.306 Random Personnel Testing 200.00$ 220.00$ New personnel policy provision
<br />601-494.500-403.350 Scada System Troubleshooting 1,500.00$ 2,000.00$ Contingency budget
<br />601-494.500-403.390 Safety Training 1,917.00$ 2,100.00$ OSHA required safety training
<br />9,377.00$ 10,368.00$
<br /> Sewage Treatment:
<br />601-494.800-408.385 Metro Council Environmental Services 943,318.00$ 974,559.00$ Increase of $31,241 or 3.31%
<br />943,318.00$ 974,559.00$
<br />Utilities:
<br />601-494.700-408.381 Electricity:
<br /> - Lift Stations 8,780.00$ 10,975.00$ 25% Increase above 2024 actual (+new lift station)
<br /> - Xcel - Public Works Facility 19,541.00$ 20,811.00$ 6.5% Increase (+ increase for new facility)
<br />28,321.00$ 31,786.00$
<br />601-494.700-408.383 Gas for Public Works Facility 21,610.00$ 22,692.00$ 8.5% Increase (+ increase for new facility)
<br />601-494.500-408.384 Refuse Disposal 8,400.00$ 9,000.00$ Gene's Disposal (1/3)
<br />58,331.00$ 63,478.00$
<br />Communications:
<br />601-494.500-404.321 Cellular Phone Charges 4,200.00$ 4,800.00$ $275/month plus $1,500 equipment & accessories
<br />601-494.500-404.321 Business Internet - Comcast (upgraded speed) 3,000.00$ 3,000.00$ 100mb service (up from 20mb service)
<br />601-494.500-404.321 Line 651 653-1154 583 Scada -$ -$ No longer in use - $50/month - Century Link
<br />601-494.500-404.321 Scada Dialer 325.00$ 360.00$ $60/month - Verizon (1/2)
<br />601-494.500-404.321 Scada Wireless Communication 7,000.00$ 8,875.00$ 12 Lifts & 1/3 PW Bldg ($60/month each)
<br />14,525.00$ 17,035.00$
<br />Travel & Training:
<br />601-494.500-405.331 Training Classes 4,500.00$ 5,500.00$ Sewer school, exams, and certificate renewals
<br />4,500.00$ 5,500.00$
<br />Contractual Maintenance:
<br />601-494.500-409.404 Alarm System Maintenance Agreement 1,200.00$ 1,440.00$ Annual Testing (1/3)
<br />601-494.500-409.404 - Alarm System Monitoring 345.00$ 397.00$ Nardini Alarm System Monitoring (1/3)
<br />601-494.500-409.404 Fleet Maintenance Software Annual Support 170.00$ 187.00$ Software Annual Support (1/3)
<br />601-494.500-409.404 Scan Tool Software Annual Support -$ 405.00$ Yearly updates to vehicle diagnostic scan tool (1/3)
<br />1,715.00$ 2,429.00$
<br />Professional Memberships:
<br />601-494.500-412.433 Dues 150.00$ 175.00$ American Public Works Assn
<br />601-494.500-412.433 Dues 250.00$ 275.00$ Minnesota Rural Water Assn
<br />400.00$ 450.00$
<br />Software:
<br />601-494.500-413.514 Fleet Maintenance Software 835.00$ -$ Purchased in 2024
<br />835.00$ -$
<br />Administration
<br />Wages:
<br />601-494.900-401.109 City Administrator 53,274.00$ 58,475.00$ 25% of Pay Grade 14 Maximum
<br />601-494.900-401.109 - 27 Pay Periods in 2024 1,914.00$ -$ 27 Pay Periods in 2024
<br />601-494.900-401.101 Billing Clerk 26,329.00$ -$ 50% of Pay Grade 4 Minimum
<br />601-494.900-401.101 - 27 Pay Periods in 2024 -$ -$ 27 Pay Periods in 2024
<br />601-494.900-401.101 Compensated Absences -$ -$ 50% of increase in PTO Bank
<br />601-494.900-401.101 Administrative Assistant 14,377.00$ 15,775.00$ 25% of Pay Grade 4 Step 2
<br />601-494.900-401.101 - 27 Pay Periods in 2024 507.00$ -$ 27 Pay Periods in 2024
<br />601-494.900-401.101 Compensated Absences 1,000.00$ 1,000.00$ 25% of increase in PTO Bank
<br />601-494.900-401.106 In Lieu of Health Insurance - Assistant 1,500.00$ 1,500.00$ $125/month for waived coverage
<br />601-494.900-401.101 Part-Time Billing Clerk 13,845.00$ 14,528.00$ 50% of 780 hours at $37.25
<br />112,746.00$ 91,278.00$
<br />Fringe Benefits:
<br />601-494.900-401.121 Pera - City Administrator 4,139.00$ 4,386.00$ 7.5% of Salary
<br />601-494.900-401.121 Pera - Billing Clerk 1,975.00$ -$ 7.5% of Salary
<br />601-494.900-401.121 Pera - Administrative Assistant 1,117.00$ 1,183.00$ 7.5% of Salary
<br />601-494.900-401.121 Pera - Part-Time Billing Clerk 1,039.00$ 1,090.00$ 7.5% of Salary
<br />601-494.900-401.122 Fica - City Administrator 3,422.00$ 3,626.00$ 6.2% of Salary
<br />Page 4
|