|
2025 Water and Sanitary Sewer Operations
<br />Pro Forma Financial Guide
<br />ACCOUNT ACCOUNT 2024 2025
<br />NUMBER DESCRIPTION Budget Budget Notes
<br />233,173.00$ 274,644.00$
<br />Professional Services:
<br />601-494.300-402.213 Water Bacteria Testing 2,280.00$ 3,000.00$ $250 month
<br />601-494.300-403.306 Random Personnel Testing 200.00$ 220.00$ New personnel policy provision
<br />601-494.300-403.330 Building Cleaning Services (contract) 4,800.00$ 5,040.00$ $420/month (1/3)
<br />601-494.300-403.330 - Window & Exterior Washing 960.00$ 1,008.00$ Additional services above cleaning contract
<br />601-494.300-403.350 Scada System Troubleshooting 1,500.00$ 2,000.00$ Contingency budget
<br />601-494.300-403.390 Safety Training 1,917.00$ 2,100.00$ OSHA required safety training (1/3)
<br />11,657.00$ 13,368.00$
<br /> Engineering:
<br />601-494.300-403.303 Engineering - Non-specific engineering fees 10,000.00$ 15,000.00$ Contingency budget
<br />10,000.00$ 15,000.00$
<br />Utilities:
<br />601-494.100-408.381 Electricity:
<br /> - Xcel - Public Works Facility 19,541.00$ 20,811.00$ 6.5% Increase (+ increase for new facility)
<br /> - Xcel - Well No. 2 7,375.00$ 8,485.00$ 15% Increase above 2024 actual
<br /> - Xcel - Well No. 3 19,320.00$ 22,220.00$ 15% Increase above 2024 actual
<br /> - Xcel - Tower No. 3 9,135.00$ 10,505.00$ 15% Increase above 2024 actual
<br /> - Xcel - Tower No. 4 9,135.00$ 10,505.00$ 15% Increase above 2024 actual
<br /> - Xcel - Well No. 4 19,320.00$ 22,220.00$ Same as Well No. 3
<br /> - Xcel - Well No. 5 19,320.00$ 22,220.00$ Same as Well No. 3
<br /> - Xcel - Well No. 6 26,725.00$ 30,735.00$ Larger Well
<br /> - BHE - Well No. 2 (solar garden contract) 9,975.00$ 11,475.00$ 15% Increase above 2024 actual
<br /> - BHE - Well No. 3 (solar garden contract) 18,900.00$ 21,735.00$ 15% Increase above 2024 actual
<br /> - BHE - Well No. 4 (solar garden contract) 22,235.00$ 25,575.00$ 15% Increase above 2024 actual
<br /> - BHE - Well No. 5 (solar garden contract) 17,088.00$ 19,655.00$ 15% Increase above 2024 actual
<br /> - BHE - Well No. 6 (solar garden contract) 14,647.00$ 16,845.00$ 15% Increase above 2024 actual
<br />212,716.00$ 242,986.00$
<br />601-494.100-408.383 Gas for Public Works Facility 21,610.00$ 22,692.00$ 8.5% Increase (+ increase for new facility)
<br />601-494.300-408.384 Refuse Disposal 8,400.00$ 9,000.00$ Gene's Disposal (1/3)
<br />242,726.00$ 274,678.00$
<br />Communications:
<br />601-494.300-404.321 Cellular Phone Charges 4,200.00$ 4,800.00$ $275/month plus $1,500 equipment & accessories
<br />601-494.300-404.321 Business Internet - Comcast (upgraded speed) 3,000.00$ 3,000.00$ 100mb service (up from 20mb service)
<br />601-494.300-404.321 Line 651 653-1154 583 Scada -$ -$ No longer in use - $50/month - Century Link
<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 325.00$ 360.00$ $60/month - Verizon (1/2)
<br />601-494.300-404.321 Scada Wireless Communication 4,600.00$ 5,275.00$ 5 Wells, 2 Towers & 1/3 PW Bldg ($60/month each)
<br />12,725.00$ 14,035.00$
<br />Travel & Training:
<br />601-494.300-405.331 Training Classes 3,025.00$ 3,500.00$ Water school, exams, and certificate renewals
<br />3,025.00$ 3,500.00$
<br />Contractual Maintenance:
<br />601-494.400-409.404 Alarm System Maintenance Agreement 1,200.00$ 1,440.00$ Annual Testing (1/3)
<br />601-494.400-409.404 - Alarm System Monitoring 345.00$ 397.00$ Nardini Alarm System Monitoring (1/3)
<br />601-494.400-409.404 Fleet Maintenance Software Annual Support 170.00$ 187.00$ Software Annual Support (1/3)
<br />601-494.400-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.300-412.433 Dues 150.00$ 175.00$ American Public Works Assn
<br />601-494.300-412.433 Dues 250.00$ 275.00$ Minnesota Rural Water Assn
<br />601-494.300-412.433 Dues 425.00$ 450.00$ American Waterworks Assn
<br />825.00$ 900.00$
<br />Software:
<br />601-494.300-413.514 Fleet Maintenance Software 835.00$ -$ Purchased in 2024
<br />835.00$ -$
<br />Administration
<br />Wages:
<br />601-494.400-401.109 City Administrator 53,274.00$ 58,475.00$ 25% of Pay Grade 14 Maximum
<br />601-494.400-401.101 - 27 Pay Periods in 2024 1,914.00$ -$ 27 Pay Periods in 2024
<br />601-494.400-401.101 Billing Clerk 26,329.00$ -$ 50% of Pay Grade 4 Minimum
<br />601-494.400-401.101 - 27 Pay Periods in 2024 -$ -$ 27 Pay Periods in 2024
<br />601-494.400-401.101 Compensated Absences -$ -$ 50% of increase in PTO Bank
<br />601-494.400-401.101 Administrative Assistant 14,377.00$ 15,775.00$ 25% of Pay Grade 4 Step 2
<br />601-494.400-401.109 - 27 Pay Periods in 2024 507.00$ -$ 27 Pay Periods in 2024
<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$ 1,500.00$ $125/month for waived coverage
<br />601-494.400-401.113 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.400-401.121 Pera - City Administrator 4,139.00$ 4,386.00$ 7.5% of Salary
<br />601-494.400-401.121 Pera - Billing Clerk 1,975.00$ -$ 7.5% of Salary
<br />601-494.400-401.121 Pera - Administrative Assistant 1,117.00$ 1,183.00$ 7.5% of Salary
<br />601-494.400-401.121 Pera - Part-Time Billing Clerk 1,039.00$ 1,090.00$ 7.5% of Salary
<br />601-494.400-401.122 Fica - City Administrator 3,422.00$ 3,626.00$ 6.2% of Salary
<br />601-494.400-401.122 Fica - Billing Clerk 1,633.00$ -$ 6.2% of Salary
<br />601-494.400-401.122 Fica - Administrative Assistant 923.00$ 979.00$ 6.2% of Salary
<br />601-494.400-401.122 Fica - Part-Time Billing Clerk 859.00$ 901.00$ 6.2% of Salary
<br />601-494.400-401.123 Medicare - City Administrator 801.00$ 848.00$ 1.45% of Salary
<br />601-494.400-401.123 Medicare - Billing Clerk 382.00$ -$ 1.45% of Salary
<br />601-494.400-401.123 Medicare - Administrative Assistant 216.00$ 229.00$ 1.45% of Salary
<br />601-494.400-401.123 Medicare - Part-Time Billing Clerk 201.00$ 211.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 -$ -$ Coverage through Spouse
<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 308.00$ 313.00$ 25% of Delta Dental Plan
<br />601-494.400-401.151 Worker's Compensation - Billing Clerk 409.00$ -$ $27,645/100*$1.07 (March - March)
<br />601-494.400-401.151 Worker's Compensation - Administrative Assistant 151.00$ 180.00$ $15,775/100*$1.07 (March - March)
<br />601-494.400-401.151 Worker's Compensation - Part-Time Billing Clerk -$ 163.00$ $14,528/100*$1.07 (March - March)
<br />17,575.00$ 14,109.00$
<br />Supplies:
<br />601-494.400-402.200 Office Supplies 7,500.00$ 8,400.00$ Utility bills and envelopes, standard supplies
<br />601-494.400-402.200 - Utility Bill Printing & Mailing (outsourced) 2,500.00$ 3,000.00$ Outsourced to Graphic Resources Inc
<br />601-494.400-402.200 - Utility Rate Change Sheets 500.00$ 600.00$ Print rate change sheets
<br />601-494.400-402.200 - Pervasive Software Upgrade 300.00$ 350.00$ Needed to operate FundBalance Software
<br />601-494.400-402.200 - Netmotion Services/Remote 350.00$ 350.00$ Remote Connection
<br />Page 2
|