|
2026 Water and Sanitary Sewer Operations
<br />Pro Forma Financial Guide
<br />ACCOUNT ACCOUNT 2025 2026
<br />NUMBER DESCRIPTION Budget Budget Notes
<br />601-494.900-401.122 Fica - Administrative Assistant 979.00$ 1,068.00$ 6.2% of Salary
<br />601-494.900-401.122 Fica - Part-Time Billing Clerk 901.00$ 937.00$ 6.2% of Salary
<br />601-494.900-401.123 Medicare - City Administrator 848.00$ 886.00$ 1.45% of Salary
<br />601-494.900-401.123 Medicare - Billing Clerk -$ -$ 1.45% of Salary
<br />601-494.900-401.123 Medicare - Administrative Assistant 229.00$ 250.00$ 1.45% of Salary
<br />601-494.900-401.123 Medicare - Part-Time Billing Clerk 211.00$ 220.00$ 1.45% of Salary
<br />601-494.900-401.131 Health Insurance - Billing Clerk -$ -$ 50% of HealthPartners High-Deductible Plan
<br />601-494.900-401.131 Health Insurance - Administrative Assistant -$ 2,055.00$ 25% of HealthPartners High-Deductible Plan
<br />601-494.900-401.131 Contributions to Employee Health Savings Accounts -$ -$ Offset Higher Deductible
<br />601-494.900-401.132 Dental Insurance - Billing Clerk -$ -$ 50% of Delta Dental Plan
<br />601-494.900-401.132 Dental Insurance - Administrative Assistant 313.00$ 313.00$ 25% of Delta Dental Plan
<br />601-494.900-401.137 Vision Insurance - Administrative Assistant -$ 18.00$ 25% of Vision Plan
<br />601-494.900-401.136 Minnesota Paid Leave Premiums -$ 411.00$ Premiums to start in 2026 (mandated employer share 0.44% of 0.88%)
<br />601-494.900-401.151 Worker's Compensation - Billing Clerk -$ -$ $0.00/100*$1.12 (March - March)
<br />601-494.900-401.151 Worker's Compensation - Administrative Assistant 180.00$ 201.00$ $17,216/100*$1.12 (March - March)
<br />601-494.900-401.151 Worker's Compensation - Part-Time Billing Clerk 163.00$ 176.00$ $15,113/100*$1.12 (March - March)
<br />14,109.00$ 17,329.00$
<br />Supplies:
<br />601-494.900-402.200 Office Supplies 8,400.00$ 8,500.00$ Utility bills and envelopes, standard supplies
<br />601-494.900-402.200 - Utility Bill Printing & Mailing (outsourced) 3,000.00$ 3,500.00$ Outsourced to Graphic Resources Inc
<br />601-494.900-402.200 - Utility Rate Change Sheet 600.00$ 700.00$ Print rate change sheets
<br />601-494.900-402.200 - Pervasive Software Upgrade 350.00$ 400.00$ Needed to operate FundBalance Software
<br />601-494.900-402.200 - Netmotion Services/Remote 350.00$ 350.00$ Remote Connection
<br />12,700.00$ 13,450.00$
<br />601-494.900-402.201 Breakroom Supplies 1,800.00$ 2,000.00$ RLC moved to Gen Govt Bldgs
<br />14,500.00$ 15,450.00$
<br />Professional Services:
<br />601-494.900-403.301 Audit 11,275.00$ 12,403.00$ Annual audit fees
<br />601-494.900-403.301 Accounting Services 44,510.00$ 46,736.00$ Implement GASB pronouncements
<br />55,785.00$ 59,139.00$
<br />IT Support Services:
<br />601-494.900-403.350 Computer Technical & Telephone Support - Metro Inet 12,580.00$ 14,638.00$ IT services from Metro Inet
<br />601-494.900-403.350 - Facility Wi-Fi 2,567.00$ 2,867.00$ Wi-Fi Access Points & Switches (1/3)
<br />15,147.00$ 17,505.00$
<br />Contractual Maintenance:
<br />601-494.900-409.404 Software Maintenance Agreements - Fund Balance 1,825.00$ 1,850.00$ Software upgrades & troubleshooting
<br />601-494.900-409.404 - Pervasive User Increase - UB -$ -$ Individual User License Increase
<br />601-494.900-409.404 New Software Annual Support -$ 10,000.00$ New software annual support
<br />601-494.900-409.404 Software Maintenance Agreements - UB Scan 325.00$ 350.00$ Software upgrades & troubleshooting
<br />601-494.400-409.404 Annual Maintenance - Credit Cards 3,000.00$ 3,000.00$ Software upgrades & troubleshooting
<br />601-494.900-409.404 Software Maintenance Agreements - Scada 1,350.00$ 1,400.00$ Water level alarm system - towers and wells
<br />601-494.900-409.404 Software Maintenance Agreements - Sensus 2,500.00$ 3,000.00$ Meter reading software upgrades
<br />9,000.00$ 19,600.00$
<br />Communications:
<br />601-494.900-404.322 Postage 8,000.00$ 8,500.00$ Mail utility bills, rate schedules, water samples…
<br />8,000.00$ 8,500.00$
<br />Insurance:
<br />601-494.900-407.361 Liability 47,380.00$ 50,697.00$ Assumes no year-end dividends
<br />601-494.900-407.362 Property 8,500.00$ 8,925.00$ Assumes no year-end dividends
<br />601-494.900-407.362 - New PW Facility 10,080.00$ 11,008.00$ New PW Facility & Salt Storage Building
<br />601-494.900-407.363 Automobile 2,650.00$ 3,050.00$ Assumes no year-end dividends
<br />68,610.00$ 73,680.00$
<br />Rentals:
<br />601-494.900-410.413 Copier Lease Payments 1,260.00$ 1,320.00$ Ricoh USA copier
<br />601-494.900-410.413 Copier Overage Charges 650.00$ 675.00$ Copies in excess of allowed amount
<br />1,910.00$ 1,995.00$
<br />Miscellaneous:
<br />601-494.900-412.430 Gopher State Service Charges 3,500.00$ 3,750.00$ Centralized locate reporting service (required)
<br />601-494.500-412.430 Truck License Tabs 175.00$ 200.00$ Tax exempt plates
<br />601-494.900-412.430 Discharge Permit - Vactor Truck 525.00$ 550.00$ Discharge Permit
<br />601-494.500-412.430 Pressure Vessel Registration Fees 20.00$ 20.00$ Pressure Vessel Registration Fees
<br />4,220.00$ 4,520.00$
<br />601-494.900-412.443 Assessment Collection Fees 1,400.00$ 1,600.00$ Charged by Washington County
<br />5,620.00$ 6,120.00$
<br />Software:
<br />601-494.900-413.514 New Software Implementation -$ 25,000.00$ Implementation - current software end of life 12/31/2026
<br />601-494.900-413.514 New Software Testing -$ 6,250.00$ Testing - current software end of life 12/31/2026
<br />-$ 31,250.00$
<br />Depreciation
<br />601-499.700-411.421 Estimated Depreciation 135,000.00$ 148,500.00$ Depreciation on city installed assets
<br />601-499.700-411.421 Estimated Contributed Depreciation 430,000.00$ 473,000.00$ Depreciation on developer installed assets
<br />565,000.00$ 621,500.00$
<br />TOTAL SEWER EXPENSES 2,446,389.00$ 2,676,669.00$
<br />NET INCOME - SEWER -$ -$
<br />Page 5
|