|
2023 Water and Sewer Business Pro‐Forma
<br />ACCOUNT ACCOUNT 2022 2023
<br />NUMBER DESCRIPTION Budget Budget Notes
<br />601-494.400-409.404 Software Maintenance Agreements - Sensus 1,200.00$ 1,350.00$ Meter reading software upgrades
<br />601-494.400-409.404 Alarm System Maintenance Agreement 1,500.00$ 1,000.00$ Annual Testing (1/3)
<br />601-494.400-409.404 - Alarm System Monitoring -$ 300.00$ Nardini Alarm System Monitoring (1/3)
<br />4,350.00$ 8,400.00$
<br />Communications:
<br />601-494.400-404.322 Postage 4,225.00$ 6,000.00$ Mail utility bills, rate schedules, water samples…
<br />4,225.00$ 6,000.00$
<br />IT Support Services:
<br />601-494.400-403.350 Computer Technical & Telephone Support - Metro Inet 5,500.00$ 7,761.00$ IT services from Metro Inet
<br />5,500.00$ 7,761.00$
<br />Insurance:
<br />601-494.400-407.361 Liability 19,764.00$ 25,650.00$ Assumes no year-end dividends
<br />601-494.400-407.362 Property 13,356.00$ 22,980.00$ Assumes no year-end dividends
<br />601-494.400-407.362 - New PW Facility -$ 8,000.00$ New PW Facility & Salt Storage Building
<br />601-494.400-407.363 Automobile 560.00$ 750.00$ Assumes no year-end dividends
<br />33,680.00$ 57,380.00$
<br />Rentals:
<br />601-494.400-410.413 Copier Lease Payments 675.00$ 1,020.00$ Ricoh USA copier
<br />601-494.400-410.413 Copier Overage Charges 275.00$ 600.00$ Copies in excess of allowed amount
<br />950.00$ 1,620.00$
<br />Miscellaneous:
<br />601-494.400-412.430 Water Appropriation Fees (DNR) 7,600.00$ 8,000.00$ Water appropriation permit fees
<br />601-494.400-412.430 Gopher State Service Charges 2,500.00$ 3,000.00$ Centralized locate reporting service (required)
<br />601-494.400-412.430 Truck License Tabs 100.00$ 125.00$ Tax-Exempt Plates
<br />601-494.400-412.430 Pressure Vessel Registration Fees 10.00$ 15.00$ Pressure Vessel Registration Fees
<br />10,210.00$ 11,140.00$
<br />601-494.400-412.443 Assessment Collection Fees 500.00$ 1,000.00$ Charged by Washington County
<br />10,710.00$ 12,140.00$
<br />Depreciation
<br />601-499.700-411.420 Estimated Depreciation 230,224.00$ 241,735.00$ Depreciation on city installed assets
<br />601-499.700-411.420 Estimated Contributed Depreciation 217,546.00$ 228,423.00$ Depreciation on developer installed assets
<br />447,770.00$ 470,158.00$
<br />TOTAL WATER EXPENSES 1,423,411.00$ 1,643,198.00$
<br />NET INCOME - WATER -$ -$
<br />SEWER REVENUES:
<br />601-372.000-372.100 Sewer Billings:
<br /> - Residential 1,096,331.00$ 1,294,298.00$ Based on 2022 Actual Usage
<br /> - Multi Family 498,442.00$ 538,295.00$ Based on 2022 Actual Usage
<br /> - Commercial 47,124.00$ 54,651.00$ Based on 2022 Actual Usage
<br /> - Industrial 33,900.00$ 30,583.00$ Based on 2022 Actual Usage
<br /> - Educational 7,789.00$ 9,497.00$ Based on 2022 Actual Usage
<br /> - Minor Account Adjustments -$ -$
<br />Sewer Billings 1,683,586.00$ 1,927,324.00$
<br />601-372.000-372.600 Sewer Penalties 19,844.00$ 14,512.00$ Based on 2022 Actual
<br />TOTAL SEWER REVENUES 1,703,430.00$ 1,941,836.00$
<br />SEWER EXPENSES:
<br />Operation & Maintenance
<br />Wages:
<br />601-494.500-401.101 Public Works Director 43,716.00$ 47,740.00$ 33% of Pay Grade 11 Step 5
<br />601-494.500-401.101 Compensated Absences - PW Director 2,185.00$ 2,387.00$ 33% of increase in PTO Bank
<br />601-494.500-401.101 Public Works Superintendent 28,520.00$ 32,084.00$ 33% of Pay Grade 8 Step 4
<br />601-494.500-401.101 Compensated Absences - Superintendent 1,000.00$ 1,000.00$ 33% of increase in PTO Bank
<br />601-494.500-401.101 Lead Worker Differential 1,053.00$ 2,813.00$ 50% of Pay Grade 6 Step 5
<br />601-494.500-401.101 Maintenance Worker 35,335.00$ 36,926.00$ 50% of Pay Grade 5 Maximum
<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.101 Maintenance Worker 33,801.00$ 36,926.00$ 50% of Pay Grade 5 Maximum
<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.106 In Lieu of Health Insurance - Maintenance Worker 3,000.00$ 3,000.00$ $250/month for waived coverage
<br />601-494.500-401.111 Standby Pay 8,840.00$ 9,360.00$ 50% of $360/week
<br />601-494.500-401.113 Overtime - Superintendent 4,278.00$ 4,814.00$ 33% of 208 hours (10%) @ overtime rate
<br />601-494.500-401.113 Overtime - Lead Worker 160.00$ 422.00$ 104 hours (10%) @ overtime rate
<br />601-494.500-401.113 Overtime - Maint Worker 5,301.00$ 5,540.00$ 104 hours (10%) @ overtime rate
<br />601-494.500-401.113 Overtime - Maint Worker 5,070.00$ 5,540.00$ 104 hours (10%) @ overtime rate
<br />174,259.00$ 190,552.00$
<br />Fringe Benefits:
<br />601-494.500-401.121 Pera - Director 3,279.00$ 3,581.00$ 7.5% of Salary
<br />601-494.500-401.121 Pera - Superintendent 2,460.00$ 2,768.00$ 7.5% of Salary & Overtime
<br />601-494.500-401.121 Pera - Lead Worker Differential 90.00$ 243.00$ 7.5% of Salary & Overtime
<br />601-494.500-401.121 Pera - Maint Worker 3,048.00$ 3,185.00$ 7.5% of Salary & Overtime
<br />601-494.500-401.121 Pera - Maint Worker 2,916.00$ 3,185.00$ 7.5% of Salary & Overtime
<br />601-494.500-401.121 Pera - Standby Pay 663.00$ 702.00$ 7.5% of Standby Pay
<br />601-494.500-401.122 Fica - Director 2,711.00$ 2,960.00$ 6.2% of Salary
<br />601-494.500-401.122 Fica - Superintendent 2,034.00$ 2,288.00$ 6.2% of Salary & Overtime
<br />601-494.500-401.122 Fica - Lead Worker Differential 75.00$ 201.00$ 6.2% of Salary & Overtime
<br />601-494.500-401.122 Fica - Maint Worker 2,520.00$ 2,633.00$ 6.2% of Salary & Overtime
<br />601-494.500-401.122 Fica - Maint Worker 2,410.00$ 2,633.00$ 6.2% of Salary & Overtime
<br />601-494.500-401.122 Fica - Standby Pay 549.00$ 581.00$ 6.2% of Standby Pay
<br />601-494.500-401.123 Medicare - Director 634.00$ 693.00$ 1.45% of Salary
<br />601-494.500-401.123 Medicare - Superintendent 476.00$ 535.00$ 1.45% of Salary & Overtime
<br />601-494.500-401.123 Medicare - Lead Worker Differential 17.00$ 47.00$ 1.45% of Salary & Overtime
<br />601-494.500-401.123 Medicare - Maint Worker 590.00$ 616.00$ 1.45% of Salary & Overtime
<br />601-494.500-401.123 Medicare - Maint Worker 564.00$ 616.00$ 1.45% of Salary & Overtime
<br />601-494.500-401.123 Medicare - Standby Pay 129.00$ 136.00$ 1.45% of Standby Pay
<br />601-494.500-401.131 Health Insurance - Director 10,000.00$ 10,369.00$ 33% of HealthPartners High-Deductible Plan
<br />601-494.500-401.131 Health Insurance - Superintendent 10,000.00$ 4,305.00$ 33% of HealthPartners High-Deductible Plan
<br />601-494.500-401.131 Health Insurance - Maint Worker 6,082.00$ 6,319.00$ 50% of HealthPartners High-Deductible Plan
<br />601-494.500-401.131 Contributions to Employee Health Savings Accounts 467.00$ -$ Offset Higher Deductible
<br />601-494.500-401.132 Dental Insurance - Director 470.00$ 587.00$ 33% of Delta Dental Plan (no increase in premium)
<br />601-494.500-401.132 Dental Insurance - Superintendent 470.00$ 205.00$ 33% of Delta Dental Plan (no increase in premium)
<br />601-494.500-401.132 Dental Insurance - Maint Worker 705.00$ 880.00$ 50% of Delta Dental Plan (no increase in premium)
<br />601-494.500-401.132 Dental Insurance - Maint Worker 267.00$ 308.00$ 50% of Delta Dental Plan (no increase in premium)
<br />601-494.500-401.151 Worker's Compensation - Director 4,097.00$ 5,147.00$ $47,740/100*$10.78
<br />601-494.500-401.151 Worker's Compensation - Superintendent 3,074.00$ 3,978.00$ $36,898/100*$10.78
<br />Page 3
|