|
2023 Water and Sewer Business Pro‐Forma
<br />ACCOUNT ACCOUNT 2022 2023
<br />NUMBER DESCRIPTION Budget Budget Notes
<br />601-494.500-401.151 Worker's Compensation - Lead Worker Differential 113.00$ 349.00$ $3,235/100*$10.78
<br />601-494.500-401.151 Worker's Compensation - Maint Worker 3,808.00$ 4,578.00$ $42,466/100*$10.78
<br />601-494.500-401.151 Worker's Compensation - Maint Worker 3,643.00$ 4,578.00$ $42,466/100*$10.78
<br />601-494.500-401.151 Worker's Compensation - Standby Pay -$ -$ Exempt from work comp
<br />68,361.00$ 69,206.00$
<br />Supplies:
<br />601-494.500-402.211 Cleaning Supplies 2,500.00$ 2,750.00$ Floor mats, restroom supplies, first aid supplies….
<br />601-494.500-402.212 Motor Fuels 3,200.00$ 6,605.00$ Sewer Department's share of bulk fuel purchases
<br />601-494.500-402.240 Small Tools & Equipment 12,000.00$ 14,000.00$ Shop tools, shelving, cold-weather gear…
<br />601-494.500-403.317 Uniforms 1,900.00$ 2,400.00$ $200/month
<br />19,600.00$ 25,755.00$
<br />Repairs & Maintenance:
<br />601-494.500-402.220 Repairs & Maintenance 44,000.00$ 44,000.00$ Lubricants, shop supplies, vactor maint….
<br />601-494.500-402.220 - Televise Sewer Line -$ -$ City-owned property - nonrecurring expense
<br />601-494.500-402.220 - Lift Station Rebuilds 43,000.00$ 43,000.00$ Budget for one rebuild per year
<br />601-494.500-402.223 Building Repair & Maintenance 3,000.00$ 4,000.00$ Non-specific building repairs
<br />601-494.500-402.223 - Septic System Pumping 3,000.00$ 5,000.00$ Septic System Pumping (1/3)
<br />601-494.500-402.223 - Weed Control 300.00$ 500.00$ Public works site and lift stations
<br />601-494.500-402.223 - HVAC Repairs 3,400.00$ 9,500.00$ Performed by NAC Mechanical
<br />601-494.500-402.223 - Security System Annual Support -$ 1,375.00$ PW Bldg - Camera, Card & Fob Software Upgrades (1/3)
<br />601-494.500-402.223 - Pest Control -$ 700.00$ 175/month (1/3)
<br />96,700.00$ 108,075.00$
<br />Professional Services:
<br />601-494.500-403.303 Data Collection & Maintenance Tracking (WSB) -$ -$ Annual costs of software module
<br />601-494.500-403.330 Building Cleaning Services (contract) 3,600.00$ 4,200.00$ $350/month
<br />601-494.500-403.330 - Window & Exterior Washing -$ 800.00$ Additional services above cleaning contract
<br />601-494.500-403.306 Random Personnel Testing 100.00$ 180.00$ New personnel policy provision
<br />601-494.500-403.350 Scada System Troubleshooting 650.00$ 1,500.00$ Contingency budget
<br />601-494.500-403.390 Safety Training 1,666.00$ 1,795.00$ OSHA required safety training
<br />6,016.00$ 8,475.00$
<br /> Sewage Treatment:
<br />601-494.800-408.385 Metro Council Environmental Services 718,000.00$ 848,100.00$ Increase of $130,177 or 18.13%
<br />718,000.00$ 848,100.00$
<br />Utilities:
<br />601-494.700-408.381 Electricity:
<br /> - Lift Stations 6,541.00$ 8,350.00$ 15% Increase above 2022 actual
<br /> - PW Facility 10,751.00$ 16,560.00$ 15% Increase (+ increase for new facility)
<br />17,292.00$ 24,910.00$
<br />601-494.700-408.383 Gas for Public Works Facility 11,400.00$ 18,630.00$ 49% Increase (+ increase for new facility)
<br />601-494.500-408.384 Refuse Disposal 7,200.00$ 7,800.00$ Gene's Disposal
<br />35,892.00$ 51,340.00$
<br />Communications:
<br />601-494.500-404.321 Cellular Phone Charges 3,200.00$ 4,200.00$ $225/month plus $1,500 equipment & accessories
<br />601-494.500-404.321 Business Internet - Comcast (upgraded speed) 2,200.00$ 3,000.00$ 100mb service (up from 20mb service)
<br />601-494.500-404.321 Line 651 653-1154 583 Scada 420.00$ 600.00$ $50/month - Century Link
<br />601-494.500-404.321 Scada Dialer -$ 300.00$ $50/month - Verizon (1/2)
<br />601-494.500-404.321 Scada Wireless Communication -$ 6,800.00$ 11 Lifts & 1/3 PW Bldg ($50/month each)
<br />5,820.00$ 14,900.00$
<br />Travel & Training:
<br />601-494.500-405.331 Training Classes 3,500.00$ 4,000.00$ Sewer school, exams, and certificate renewals
<br />3,500.00$ 4,000.00$
<br />Professional Memberships:
<br />601-494.500-412.433 Dues 100.00$ 125.00$ American Public Works Assn
<br />601-494.500-412.433 Dues 170.00$ 225.00$ Minnesota Rural Water Assn
<br />270.00$ 350.00$
<br />Administration
<br />Wages:
<br />601-494.900-401.109 City Administrator 46,189.00$ 49,745.00$ 25% of maximum allowed by statute
<br />601-494.900-401.101 Billing Clerk 35,335.00$ 36,926.00$ 50% of Pay Grade 5 Maximum
<br />601-494.900-401.101 Compensated Absences 4,000.00$ 4,000.00$ 50% of increase in PTO Bank
<br />601-494.900-401.101 Administrative Assistant 12,055.00$ 13,165.00$ 25% of Pay Grade 4 Step 1
<br />601-494.900-401.101 Compensated Absences 1,000.00$ 1,000.00$ 25% of increase in PTO Bank
<br />601-494.900-401.106 In Lieu of Health Insurance - Assistant -$ 1,500.00$ $125/month for waived coverage
<br />98,579.00$ 106,336.00$
<br />Fringe Benefits:
<br />601-494.900-401.121 Pera - City Administrator 3,465.00$ 3,731.00$ 7.5% of Salary
<br />601-494.900-401.121 Pera - Billing Clerk 2,651.00$ 2,770.00$ 7.5% of Salary
<br />601-494.900-401.121 Pera - Administrative Assistant 905.00$ 988.00$ 7.5% of Salary
<br />601-494.900-401.122 Fica - City Administrator 2,864.00$ 3,085.00$ 6.2% of Salary
<br />601-494.900-401.122 Fica - Billing Clerk 2,191.00$ 2,290.00$ 6.2% of Salary
<br />601-494.900-401.122 Fica - Administrative Assistant 748.00$ 817.00$ 6.2% of Salary
<br />601-494.900-401.123 Medicare - City Administrator 670.00$ 722.00$ 1.45% of Salary
<br />601-494.900-401.123 Medicare - Billing Clerk 513.00$ 536.00$ 1.45% of Salary
<br />601-494.900-401.123 Medicare - Administrative Assistant 175.00$ 191.00$ 1.45% of Salary
<br />601-494.900-401.131 Health Insurance - Billing Clerk 14,339.00$ 14,641.00$ 50% of HealthPartners High-Deductible Plan
<br />601-494.900-401.131 Health Insurance - Administrative Assistant 7,789.00$ -$ Coverage through Spouse
<br />601-494.900-401.131 Contributions to Employee Health Savings Accounts 400.00$ -$ Offset Higher Deductible
<br />601-494.900-401.132 Dental Insurance - Billing Clerk 517.00$ 615.00$ 50% of Delta Dental Plan
<br />601-494.900-401.132 Dental Insurance - Administrative Assistant 353.00$ 308.00$ 25% of Delta Dental Plan
<br />601-494.900-401.151 Worker's Compensation - Billing Clerk 262.00$ 314.00$ $36,926/100*$0.85
<br />601-494.900-401.151 Worker's Compensation - Administrative Assistant 90.00$ 112.00$ $13,165/100*$0.85
<br />37,932.00$ 31,120.00$
<br />Supplies:
<br />601-494.900-402.200 Office Supplies 4,500.00$ 6,000.00$ Utility bills and envelopes, standard supplies
<br />601-494.900-402.200 - Utility Bill Printing & Mailing (outsourced) 1,250.00$ 2,000.00$ Outsourced to Graphic Resources Inc
<br />601-494.900-402.200 - Pervasive Software Upgrade 150.00$ 250.00$ Needed to operate FundBalance Software
<br />601-494.900-402.200 - Netmotion Services/Remote 175.00$ 350.00$ Remote Connection
<br />6,075.00$ 8,600.00$
<br />601-494.900-402.201 Breakroom Supplies 750.00$ 950.00$ RLC moved to Gen Govt Bldgs
<br />6,825.00$ 9,550.00$
<br />Professional Services:
<br />601-494.900-403.301 Audit 8,470.00$ 9,317.00$ Annual audit fees
<br />601-494.900-403.301 Accounting Services 38,450.00$ 38,450.00$ Implement GASB pronouncements
<br />46,920.00$ 47,767.00$
<br />IT Support Services:
<br />601-494.900-403.350 Computer Technical & Telephone Support - Metro Inet 5,500.00$ 7,761.00$ IT services from Metro Inet
<br />Page 4
|