|
2023 Water and Sewer Business Pro‐Forma
<br />ACCOUNT ACCOUNT 2022 2023
<br />NUMBER DESCRIPTION Budget Budget Notes
<br />WATER REVENUES: Budget Budget
<br />601-371.000-371.100 Water Billings:
<br /> - Residential 1,000,990.00$ 1,110,991.00$ Based on 2022 Actual Usage
<br /> - Multi Family 130,717.00$ 138,917.00$ Based on 2022 Actual Usage
<br /> - Irrigation 228,237.00$ 325,661.00$ Based on 2022 Actual Usage
<br /> - Less City Irrigation Accounts (25,559.00)$ (25,406.00)$ Based on 2022 Actual Usage
<br /> - Commercial 29,966.00$ 32,872.00$ Based on 2022 Actual Usage
<br /> - Industrial 15,774.00$ 15,102.00$ Based on 2022 Actual Usage
<br /> - Educational 3,914.00$ 2,161.00$ Based on 2022 Actual Usage
<br />601-371.000-371.100 Water Billings 1,384,039.00$ 1,600,298.00$
<br />601-371.000-371.100 Account Adjustments -$ -$ Small adjustments to accounts receivable
<br />601-371.000-371.100 Hydrant Water Sales 1,800.00$ 1,800.00$ Truck loads of unmetered hydrant water
<br />601-371.000-371.600 Water Penalties 19,972.00$ 19,600.00$ Based on 2022 Actual
<br />601-371.000-371.700 Water Meters 17,600.00$ 21,500.00$ $430 x 50 new homes
<br />601-371.000-371.800 Smart Irrigation Controllers -$ -$ Only a few left….grant program over
<br />TOTAL WATER REVENUES 1,423,411.00$ 1,643,198.00$
<br />WATER EXPENSES: Budget Budget
<br />Operation & Maintenance
<br />Wages:
<br />601-494.300-401.101 Public Works Director 43,716.00$ 47,740.00$ 33% of Pay Grade 11 Step 5
<br />601-494.300-401.101 Compensated Absences - PW Director 2,185.00$ 2,387.00$ 33% of increase in PTO Bank
<br />601-494.300-401.101 Public Works Superintendent 28,520.00$ 32,084.00$ 33% of Pay Grade 8 Step 4
<br />601-494.300-401.101 Compensated Absences - Superintendent 1,000.00$ 1,000.00$ 33% of increase in PTO Bank
<br />601-494.300-401.101 Lead Worker Differential 1,053.00$ 2,813.00$ 50% of Pay Grade 6 Step 5
<br />601-494.300-401.101 Maintenance Worker 35,335.00$ 36,926.00$ 50% of Pay Grade 5 Maximum
<br />601-494.300-401.101 Compensated Absences - Maintenance Worker 1,000.00$ 1,000.00$ 50% of increase in PTO Bank
<br />601-494.300-401.101 Maintenance Worker 33,801.00$ 36,926.00$ 50% of Pay Grade 5 Maximum
<br />601-494.300-401.101 Compensated Absences - Maintenance Worker 1,000.00$ 1,000.00$ 50% of increase in PTO Bank
<br />601-494.300-401.106 In Lieu of Health Insurance - Maintenance Worker 3,000.00$ 3,000.00$ $250/month for waived coverage
<br />601-494.300-401.111 Standby Pay 8,840.00$ 9,360.00$ 50% of $360/week
<br />601-494.300-401.113 Overtime - Superintendent 4,278.00$ 4,814.00$ 33% of 208 hours (10%) @ overtime rate
<br />601-494.300-401.113 Overtime - Lead Worker 160.00$ 422.00$ 104 hours (10%) @ overtime rate
<br />601-494.300-401.113 Overtime - Maint Worker 5,301.00$ 5,540.00$ 104 hours (10%) @ overtime rate
<br />601-494.300-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.300-401.121 Pera - Director 3,279.00$ 3,581.00$ 7.5% of Salary
<br />601-494.300-401.121 Pera - Superintendent 2,460.00$ 2,768.00$ 7.5% of Salary & Overtime
<br />601-494.300-401.121 Pera - Lead Worker Differential 90.00$ 243.00$ 7.5% of Salary & Overtime
<br />601-494.300-401.121 Pera - Maint Worker 3,048.00$ 3,185.00$ 7.5% of Salary & Overtime
<br />601-494.300-401.121 Pera - Maint Worker 2,916.00$ 3,185.00$ 7.5% of Salary & Overtime
<br />601-494.300-401.121 Pera - Standby Pay 663.00$ 702.00$ 7.5% of Standby Pay
<br />601-494.300-401.122 Fica - Director 2,711.00$ 2,960.00$ 6.2% of Salary
<br />601-494.300-401.121 Fica - Superintendent 2,034.00$ 2,288.00$ 6.2% of Salary & Overtime
<br />601-494.300-401.121 Fica - Lead Worker Differential 75.00$ 201.00$ 6.2% of Salary & Overtime
<br />601-494.300-401.122 Fica - Maint Worker 2,520.00$ 2,633.00$ 6.2% of Salary & Overtime
<br />601-494.300-401.122 Fica - Maint Worker 2,410.00$ 2,633.00$ 6.2% of Salary & Overtime
<br />601-494.300-401.122 Fica - Standby Pay 549.00$ 581.00$ 6.2% of Standby Pay
<br />601-494.300-401.123 Medicare - Director 634.00$ 693.00$ 1.45% of Salary
<br />601-494.300-401.123 Medicare - Superintendent 476.00$ 535.00$ 1.45% of Salary & Overtime
<br />601-494.300-401.123 Medicare - Lead Worker Differential 17.00$ 47.00$ 1.45% of Salary & Overtime
<br />601-494.300-401.123 Medicare - Maint Worker 590.00$ 616.00$ 1.45% of Salary & Overtime
<br />601-494.300-401.123 Medicare - Maint Worker 564.00$ 616.00$ 1.45% of Salary & Overtime
<br />601-494.300-401.123 Medicare - Standby Pay 129.00$ 136.00$ 1.45% of Standby Pay
<br />601-494.300-401.131 Health Insurance - Director 10,000.00$ 10,369.00$ 33% of HealthPartners High-Deductible Plan
<br />601-494.300-401.131 Health Insurance - Superintendent 10,000.00$ 4,305.00$ 33% of HealthPartners High-Deductible Plan
<br />601-494.300-401.131 Health Insurance - Maint Worker 6,082.00$ 6,319.00$ 50% of HealthPartners High-Deductible Plan
<br />601-494.300-401.131 Contributions to Employee Health Savings Accounts 467.00$ -$ Offset Higher Deductible
<br />601-494.300-401.132 Dental Insurance - Director 470.00$ 587.00$ 33% of Delta Dental Plan (no increase in premium)
<br />601-494.300-401.132 Dental Insurance - Superintendent 470.00$ 205.00$ 33% of Delta Dental Plan (no increase in premium)
<br />601-494.300-401.132 Dental Insurance - Maint Worker 705.00$ 880.00$ 50% of Delta Dental Plan (no increase in premium)
<br />601-494.300-401.132 Dental Insurance - Maint Worker 267.00$ 308.00$ 50% of Delta Dental Plan (no increase in premium)
<br />601-494.300-401.151 Worker's Compensation - Director 4,097.00$ 5,147.00$ $47,740/100*$10.78
<br />601-494.300-401.151 Worker's Compensation - Superintendent 3,074.00$ 3,978.00$ $36,898/100*$10.78
<br />601-494.300-401.151 Worker's Compensation - Lead Worker Differential 113.00$ 349.00$ $3,235/100*$10.78
<br />601-494.300-401.151 Worker's Compensation - Maint Worker 3,808.00$ 4,578.00$ $42,466/100*$10.78
<br />601-494.300-401.151 Worker's Compensation - Maint Worker 3,643.00$ 4,578.00$ $42,466/100*$10.78
<br />601-494.300-401.151 Worker's Compensation - Standby Pay -$ -$ Exempt from work comp
<br />68,361.00$ 69,206.00$
<br />Supplies:
<br />601-494.300-402.211 Cleaning Supplies 2,500.00$ 2,750.00$ Floor mats, restroom supplies, first aid supplies….
<br />601-494.300-402.213 Chemicals 30,000.00$ 32,500.00$ Added at 5 wells (chlorine, fluoride…)
<br />601-494.300-402.213 - Hazardous Waste Generators License 117.00$ 325.00$ Hazardous Waste Generators License
<br />601-494.300-402.212 Motor Fuels 3,200.00$ 6,605.00$ Water Department's share of bulk fuel purchases
<br />601-494.300-402.240 Small Tools & Equipment 12,000.00$ 14,000.00$ Shop tools, shelving, cold-weather gear…
<br />601-494.300-403.317 Uniforms 1,900.00$ 2,400.00$ $200/month
<br />601-494.300-402.232 Smart Controllers (for irrigation systems) 900.00$ 245.00$ Sales taxes on 20 controllers (20 x $165 x 7.375%)
<br />601-494.300-402.214 Water Meters 75,000.00$ 66,700.00$ Radio Meters
<br />125,617.00$ 125,525.00$
<br />Repairs & Maintenance:
<br />601-494.300-402.220 Repairs & Maintenance 35,000.00$ 38,000.00$ Lubricants, shop supplies, vehicle maint…
<br />601-494.300-402.220 - Watermain Breaks 24,000.00$ 27,000.00$ 3 watermain breaks @ $9,000
<br />601-494.300-402.220 - Well Tech Labor & VFD 36,000.00$ 45,000.00$ Contingency budget if any well pump fails
<br />601-494.300-402.220 - Well Pump Repairs 20,000.00$ 30,000.00$ Contingency budget if any well pump fails
<br />601-494.300-402.220 - Motor Efficiency Rebate (Xcel Energy) -$ -$ One-time rebate
<br />601-494.300-402.220 - Fire Hydrant Painting 40,000.00$ 40,000.00$ 400 hydrants @ $100 - contractual services
<br />601-494.300-402.223 Building Repair & Maintenance 6,400.00$ 7,000.00$ Non-specific building repairs
<br />601-494.300-402.223 - Well Electrical Work 2,575.00$ 7,000.00$ In conjunction with pump repairs
<br />601-494.300-402.223 - Septic System Pumping 3,000.00$ 5,000.00$ Septic System Pumping (1/3)
<br />601-494.300-402.223 - Weed Control 1,000.00$ 2,250.00$ Public works site and water towers
<br />601-494.300-402.223 - HVAC Repairs 3,400.00$ 9,500.00$ Performed by NAC Mechanical
<br />601-494.300-402.223 - Security System Annual Support -$ 1,375.00$ PW Bldg - Camera, Card & Fob Software Upgrades (1/3)
<br />601-494.300-402.223 - Security System Annual Support -$ 700.00$ Water Tower No. 4 Card & Fob Software Upgrades
<br />Page 1
|