|
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.900-401.122 Fica - Billing Clerk 1,633.00$ -$ 6.2% of Salary
<br />601-494.900-401.122 Fica - Administrative Assistant 923.00$ 979.00$ 6.2% of Salary
<br />601-494.900-401.122 Fica - Part-Time Billing Clerk 859.00$ 901.00$ 6.2% of Salary
<br />601-494.900-401.123 Medicare - City Administrator 801.00$ 848.00$ 1.45% of Salary
<br />601-494.900-401.123 Medicare - Billing Clerk 382.00$ -$ 1.45% of Salary
<br />601-494.900-401.123 Medicare - Administrative Assistant 216.00$ 229.00$ 1.45% of Salary
<br />601-494.900-401.123 Medicare - Part-Time Billing Clerk 201.00$ 211.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 -$ -$ Coverage through Spouse
<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 308.00$ 313.00$ 25% of Delta Dental Plan
<br />601-494.900-401.151 Worker's Compensation - Billing Clerk 409.00$ -$ $27,645/100*$1.07 (March - March)
<br />601-494.900-401.151 Worker's Compensation - Administrative Assistant 151.00$ 180.00$ $15,775/100*$1.07 (March - March)
<br />601-494.900-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.900-402.200 Office Supplies 7,500.00$ 8,400.00$ Utility bills and envelopes, standard supplies
<br />601-494.900-402.200 - Utility Bill Printing & Mailing (outsourced) 2,500.00$ 3,000.00$ Outsourced to Graphic Resources Inc
<br />601-494.900-402.200 - Utility Rate Change Sheet 500.00$ 600.00$ Print rate change sheets
<br />601-494.900-402.200 - Pervasive Software Upgrade 300.00$ 350.00$ Needed to operate FundBalance Software
<br />601-494.900-402.200 - Netmotion Services/Remote 350.00$ 350.00$ Remote Connection
<br />11,150.00$ 12,700.00$
<br />601-494.900-402.201 Breakroom Supplies 1,300.00$ 1,800.00$ RLC moved to Gen Govt Bldgs
<br />12,450.00$ 14,500.00$
<br />Professional Services:
<br />601-494.900-403.301 Audit 10,250.00$ 11,275.00$ Annual audit fees
<br />601-494.900-403.301 Accounting Services 42,390.00$ 44,510.00$ Implement GASB pronouncements
<br />52,640.00$ 55,785.00$
<br />IT Support Services:
<br />601-494.900-403.350 Computer Technical & Telephone Support - Metro Inet 12,013.00$ 12,580.00$ IT services from Metro Inet
<br />601-494.900-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 />Contractual Maintenance:
<br />601-494.900-409.404 Software Maintenance Agreements - Fund Balance 1,775.00$ 1,825.00$ Software upgrades & troubleshooting
<br />601-494.900-409.404 - Pervasive User Increase - UB -$ -$ Individual User License Increase
<br />601-494.900-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.900-409.404 Software Maintenance Agreements - Scada 1,300.00$ 1,350.00$ Water level alarm system - towers and wells
<br />601-494.900-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.900-404.322 Postage 7,000.00$ 8,000.00$ Mail utility bills, rate schedules, water samples…
<br />7,000.00$ 8,000.00$
<br />Insurance:
<br />601-494.900-407.361 Liability 33,345.00$ 47,380.00$ Assumes no year-end dividends
<br />601-494.900-407.362 Property 7,130.00$ 8,500.00$ Assumes no year-end dividends
<br />601-494.900-407.362 - New PW Facility 8,400.00$ 10,080.00$ New PW Facility & Salt Storage Building
<br />601-494.900-407.363 Automobile 2,200.00$ 2,650.00$ Assumes no year-end dividends
<br />51,075.00$ 68,610.00$
<br />Rentals:
<br />601-494.900-410.413 Copier Lease Payments 1,140.00$ 1,260.00$ Ricoh USA copier
<br />601-494.900-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.900-412.430 Gopher State Service Charges 3,150.00$ 3,500.00$ Centralized locate reporting service (required)
<br />601-494.500-412.430 Truck License Tabs 125.00$ 175.00$ Tax exempt plates
<br />601-494.500-412.430 Discharge Permit - Vactor Truck 475.00$ 525.00$ Discharge Permit
<br />601-494.500-412.430 Pressure Vessel Registration Fees 15.00$ 20.00$ Pressure Vessel Registration Fees
<br />3,765.00$ 4,220.00$
<br />601-494.900-412.443 Assessment Collection Fees 1,200.00$ 1,400.00$ Charged by Washington County
<br />4,965.00$ 5,620.00$
<br />Depreciation
<br />601-499.700-411.421 Estimated Depreciation 120,000.00$ 135,000.00$ Depreciation on city installed assets
<br />601-499.700-411.421 Estimated Contributed Depreciation 390,000.00$ 430,000.00$ Depreciation on developer installed assets
<br />510,000.00$ 565,000.00$
<br />TOTAL SEWER EXPENSES 2,250,795.00$ 2,446,389.00$
<br />NET INCOME - SEWER -$ -$
<br />Page 5
|