|
2025 Water and Sanitary Sewer Operations
<br />Pro Forma Financial Guide
<br />ACCOUNT ACCOUNT 2024 2025
<br />NUMBER DESCRIPTION Budget Budget Notes
<br />11,150.00$ 12,700.00$
<br />601-494.400-402.201 Breakroom Supplies 1,300.00$ 1,800.00$ RLC moved to Gen Govt Bldgs
<br />601-494.400-402.205 Water Brochures 100.00$ 125.00$ Department of Health requirement
<br />12,550.00$ 14,625.00$
<br />Professional Services:
<br />601-494.400-403.301 Audit 10,250.00$ 11,275.00$ Annual audit fees
<br />601-494.400-403.301 Accounting Services 42,390.00$ 44,510.00$ Implement GASB pronouncements
<br />601-494.400-403.304 Legal Fees - General Legal 2,500.00$ 3,000.00$ General Legal Fees
<br />601-494.400-403.304 Legal Fees - DNR Appeal & WBL Restoration Litigation 32,400.00$ 35,000.00$ DNR Administrative Appeal & WBL Restoration Litigation
<br />601-494.400-403.304 Legal Fees - Tower No. 4 -$ -$ Miscellaneous Water Issues
<br />87,540.00$ 93,785.00$
<br />Contractual Maintenance:
<br />601-494.400-409.404 Software Maintenance Agreements - Fund Balance 1,775.00$ 1,825.00$ Software upgrades & troubleshooting
<br />601-494.400-409.404 - Pervasive User Increase - UB -$ -$ Individual User License Increase
<br />601-494.400-409.404 Software Maintenance Agreements - UB Scan 300.00$ 325.00$ Software upgrades & troubleshooting
<br />601-494.400-409.404 Annual Maintenance - Credit Cards 2,500.00$ 3,000.00$ Software upgrades & troubleshooting
<br />601-494.400-409.404 Software Maintenance Agreements - Scada 1,300.00$ 1,350.00$ Water level alarm system - towers and wells
<br />601-494.400-409.404 Software Maintenance Agreements - Sensus 1,500.00$ 2,500.00$ Meter reading software upgrades
<br />7,375.00$ 9,000.00$
<br />Communications:
<br />601-494.400-404.322 Postage 7,000.00$ 8,000.00$ Mail utility bills, rate schedules, water samples…
<br />7,000.00$ 8,000.00$
<br />IT Support Services:
<br />601-494.400-403.350 Computer Technical & Telephone Support - Metro Inet 12,013.00$ 12,580.00$ IT services from Metro Inet
<br />601-494.400-403.350 - Facility Wi-Fi 2,567.00$ 2,567.00$ Wi-Fi Access Points & Switches (1/3)
<br />14,580.00$ 15,147.00$
<br />Insurance:
<br />601-494.400-407.361 Liability 33,345.00$ 47,380.00$ Assumes no year-end dividends
<br />601-494.400-407.362 Property 25,737.00$ 30,885.00$ Assumes no year-end dividends
<br />601-494.400-407.362 - New PW Facility 8,400.00$ 10,080.00$ New PW Facility & Salt Storage Building
<br />601-494.400-407.363 Automobile 1,100.00$ 1,375.00$ Assumes no year-end dividends
<br />68,582.00$ 89,720.00$
<br />Rentals:
<br />601-494.400-410.413 Copier Lease Payments 1,140.00$ 1,260.00$ Ricoh USA copier
<br />601-494.400-410.413 Copier Overage Charges 625.00$ 650.00$ Copies in excess of allowed amount
<br />1,765.00$ 1,910.00$
<br />Miscellaneous:
<br />601-494.400-412.430 Water Appropriation Fees (DNR) 13,000.00$ 18,000.00$ Water appropriation permit fees
<br />601-494.400-412.430 Gopher State Service Charges 3,150.00$ 3,500.00$ Centralized locate reporting service (required)
<br />601-494.400-412.430 Truck License Tabs 125.00$ 175.00$ Tax-Exempt Plates
<br />601-494.400-412.430 Pressure Vessel Registration Fees 15.00$ 20.00$ Pressure Vessel Registration Fees
<br />16,290.00$ 21,695.00$
<br />601-494.400-412.443 Assessment Collection Fees 1,200.00$ 1,400.00$ Charged by Washington County
<br />17,490.00$ 23,095.00$
<br />Depreciation
<br />601-499.700-411.420 Estimated Depreciation 350,000.00$ 385,000.00$ Depreciation on city installed assets
<br />601-499.700-411.420 Estimated Contributed Depreciation 340,000.00$ 375,000.00$ Depreciation on developer installed assets
<br />690,000.00$ 760,000.00$
<br />TOTAL WATER EXPENSES 1,997,934.00$ 2,195,315.00$
<br />NET INCOME - WATER -$ -$
<br />SEWER REVENUES:
<br />601-372.000-372.100 Sewer Billings:
<br /> - Residential 1,536,495.00$ 1,602,639.00$ Based on 2024 Actual Usage
<br /> - Multi Family 577,500.00$ 690,500.00$ Based on 2024 Actual Usage
<br /> - Commercial 61,950.00$ 67,750.00$ Based on 2024 Actual Usage
<br /> - Industrial 37,800.00$ 43,000.00$ Based on 2024 Actual Usage
<br /> - Educational 22,050.00$ 24,500.00$ Based on 2024 Actual Usage
<br /> - Minor Account Adjustments -$ -$
<br />Sewer Billings 2,235,795.00$ 2,428,389.00$
<br />601-372.000-372.600 Sewer Penalties 15,000.00$ 18,000.00$ Based on 2024 Actual
<br />TOTAL SEWER REVENUES 2,250,795.00$ 2,446,389.00$
<br />SEWER EXPENSES:
<br />Operation & Maintenance
<br />Wages:
<br />601-494.500-401.101 Public Works Director 52,152.00$ 54,759.00$ 33% of Pay Grade 11 Max
<br />601-494.500-401.101 - 27 Pay Periods in 2024 1,837.00$ -$ 27 Pay Periods in 2024
<br />601-494.500-401.101 Compensated Absences - PW Director 2,000.00$ 2,000.00$ 33% of increase in PTO Bank
<br />601-494.500-401.101 Public Works Superintendent 35,037.00$ 38,459.00$ 33% of Pay Grade 8 Max
<br />601-494.500-401.101 - 27 Pay Periods in 2024 1,235.00$ -$ 27 Pay Periods in 2024
<br />601-494.500-401.101 Compensated Absences - Superintendent 1,000.00$ 2,000.00$ 33% of increase in PTO Bank
<br />601-494.500-401.101 Lead Worker 38,027.00$ 41,724.00$ 50% of Pay Grade 6 Step 4
<br />601-494.500-401.101 - 27 Pay Periods in 2024 1,400.00$ -$ 27 Pay Periods in 2024
<br />601-494.500-401.106 In Lieu of Health Insurance - Lead Worker 3,000.00$ 3,000.00$ $250/month for waived coverage
<br />601-494.500-401.101 Compensated Absences - Lead Worker 1,000.00$ 1,000.00$ 50% of increase in PTO Bank
<br />601-494.500-401.101 Maintenance Worker 38,587.00$ 40,517.00$ 50% of Pay Grade 5 Maximum
<br />601-494.500-401.101 - 27 Pay Periods in 2024 1,421.00$ -$ 27 Pay Periods in 2024
<br />601-494.500-401.101 Compensated Absences - Maintenance Worker 1,000.00$ 1,000.00$ 50% of increase in PTO Bank
<br />601-494.500-401.111 Standby Pay 10,240.00$ 10,400.00$ 50% of $400/week
<br />601-494.500-401.113 Overtime - Superintendent 5,255.00$ 5,770.00$ 33% of 208 hours (10%) @ overtime rate
<br />601-494.500-401.113 Overtime - Lead Worker 5,704.00$ 6,259.00$ 104 hours (10%) @ overtime rate
<br />601-494.500-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.500-401.121 Pera - Director 4,050.00$ 4,107.00$ 7.5% of Salary
<br />601-494.500-401.121 Pera - Superintendent 3,115.00$ 3,317.00$ 7.5% of Salary & Overtime
<br />601-494.500-401.121 Pera - Lead Worker 3,385.00$ 3,599.00$ 7.5% of Salary & Overtime
<br />601-494.500-401.121 Pera - Maint Worker 3,435.00$ 3,495.00$ 7.5% of Salary & Overtime
<br />601-494.500-401.121 Pera - Standby Pay 768.00$ 780.00$ 7.5% of Standby Pay
<br />601-494.500-401.122 Fica - Director 3,348.00$ 3,396.00$ 6.2% of Salary
<br />601-494.500-401.122 Fica - Superintendent 2,575.00$ 2,743.00$ 6.2% of Salary & Overtime
<br />601-494.500-401.122 Fica - Lead Worker 2,798.00$ 2,975.00$ 6.2% of Salary & Overtime
<br />601-494.500-401.122 Fica - Maint Worker 2,840.00$ 2,889.00$ 6.2% of Salary & Overtime
<br />601-494.500-401.122 Fica - Standby Pay 635.00$ 645.00$ 6.2% of Standby Pay
<br />601-494.500-401.123 Medicare - Director 783.00$ 794.00$ 1.45% of Salary
<br />601-494.500-401.123 Medicare - Superintendent 602.00$ 642.00$ 1.45% of Salary & Overtime
<br />601-494.500-401.123 Medicare - Lead Worker 654.00$ 696.00$ 1.45% of Salary & Overtime
<br />601-494.500-401.123 Medicare - Maint Worker 664.00$ 676.00$ 1.45% of Salary & Overtime
<br />Page 3
|