|
2023 Water and Sewer Business Pro‐Forma
<br />ACCOUNT ACCOUNT 2022 2023
<br />NUMBER DESCRIPTION Budget Budget Notes
<br />601-494.300-402.223 - Pest Control -$ 700.00$ $175/month (1/3)
<br />171,375.00$ 213,525.00$
<br />Professional Services:
<br />601-494.300-402.213 Water Bacteria Testing 1,500.00$ 2,040.00$ $170 month
<br />601-494.300-403.306 Random Personnel Testing 100.00$ 180.00$ New personnel policy provision
<br />601-494.300-403.330 Building Cleaning Services (contract) 3,600.00$ 4,200.00$ $350/month
<br />601-494.300-403.330 - Window & Exterior Washing -$ 800.00$ Additional services above cleaning contract
<br />601-494.300-403.350 Scada System Troubleshooting 650.00$ 1,500.00$ Contingency budget
<br />601-494.300-403.390 Safety Training 1,666.00$ 1,795.00$ OSHA required safety training
<br />7,516.00$ 10,515.00$
<br /> Engineering:
<br />601-494.300-403.303 Engineering - Non-specific engineering fees 10,000.00$ 10,000.00$ Contingency budget
<br />10,000.00$ 10,000.00$
<br />Utilities:
<br />601-494.100-408.381 Electricity:
<br /> - Xcel - Public Works Facility 10,751.00$ 16,560.00$ 15% Increase (+ increase for new facility)
<br /> - Xcel - Well No. 2 4,645.00$ 7,025.00$ 15% Increase above 2022 actual
<br /> - Xcel - Well No. 3 10,984.00$ 18,400.00$ 15% Increase above 2022 actual
<br /> - Xcel - Tower No. 3 5,155.00$ 8,700.00$ 15% Increase above 2022 actual
<br /> - Xcel - Tower No. 4 5,155.00$ 8,700.00$ 15% Increase above 2022 actual
<br /> - Xcel - Well No. 4 10,580.00$ 18,400.00$ Same as Well No. 3
<br /> - Xcel - Well No. 5 10,580.00$ 18,400.00$ Same as Well No. 3
<br /> - Xcel - Well No. 6 10,580.00$ 25,453.00$ Larger Well
<br /> - BHE - Well No. 2 (solar garden contract) 8,272.00$ 9,500.00$ 15% Increase above 2022 actual
<br /> - BHE - Well No. 3 (solar garden contract) 15,640.00$ 18,000.00$ 15% Increase above 2022 actual
<br /> - BHE - Well No. 4 (solar garden contract) 18,406.00$ 21,175.00$ 15% Increase above 2022 actual
<br /> - BHE - Well No. 5 (solar garden contract) 14,153.00$ 16,275.00$ 15% Increase above 2022 actual
<br /> - BHE - Well No. 6 (solar garden contract) 12,126.00$ 13,950.00$ 15% Increase above 2022 actual
<br />137,027.00$ 200,538.00$
<br />601-494.100-408.383 Gas for Public Works Facility 11,400.00$ 18,630.00$ 49% Increase (+ increase for new facility)
<br />601-494.300-408.384 Refuse Disposal 7,200.00$ 7,800.00$ Gene's Disposal
<br />155,627.00$ 226,968.00$
<br />Communications:
<br />601-494.300-404.321 Cellular Phone Charges 3,200.00$ 4,200.00$ $225/month plus $1,500 equipment & accessories
<br />601-494.300-404.321 Business Internet - Comcast (upgraded speed) 2,200.00$ 3,000.00$ 100mb service (up from 20mb service)
<br />601-494.300-404.321 Line 651 653-1154 583 Scada 420.00$ 600.00$ $50/month - Century Link
<br />601-494.300-404.321 Data Plan for Cradle Point at Tower No. 4/Well No. 6 -$ 600.00$ Allows for keycard access ($50/month - Verizon)
<br />601-494.300-404.321 Scada Dialer -$ 300.00$ $50/month - Verizon (1/2)
<br />601-494.300-404.321 Scada Wireless Communication -$ 4,400.00$ 5 Wells, 2 Towers & 1/3 PW Bldg ($50/month each)
<br />5,820.00$ 13,100.00$
<br />Travel & Training:
<br />601-494.300-405.331 Training Classes 2,200.00$ 2,750.00$ Water school, exams, and certificate renewals
<br />2,200.00$ 2,750.00$
<br />Professional Memberships:
<br />601-494.300-412.433 Dues 100.00$ 125.00$ American Public Works Assn
<br />601-494.300-412.433 Dues 170.00$ 225.00$ Minnesota Rural Water Assn
<br />601-494.300-412.433 Dues 375.00$ 400.00$ American Waterworks Assn
<br />645.00$ 750.00$
<br />Administration
<br />Wages:
<br />601-494.400-401.109 City Administrator 46,189.00$ 49,745.00$ 25% of maximum allowed by statute
<br />601-494.400-401.101 Billing Clerk 35,335.00$ 36,926.00$ 50% of Pay Grade 5 Maximum
<br />601-494.400-401.101 Compensated Absences 4,000.00$ 4,000.00$ 50% of increase in PTO Bank
<br />601-494.400-401.101 Administrative Assistant 12,055.00$ 13,165.00$ 25% of Pay Grade 4 Step 1
<br />601-494.400-401.101 Compensated Absences 1,000.00$ 1,000.00$ 25% of increase in PTO Bank
<br />601-494.400-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.400-401.121 Pera - City Administrator 3,465.00$ 3,731.00$ 7.5% of Salary
<br />601-494.400-401.121 Pera - Billing Clerk 2,651.00$ 2,770.00$ 7.5% of Salary
<br />601-494.400-401.121 Pera - Administrative Assistant 905.00$ 988.00$ 7.5% of Salary
<br />601-494.400-401.122 Fica - City Administrator 2,864.00$ 3,085.00$ 6.2% of Salary
<br />601-494.400-401.122 Fica - Billing Clerk 2,191.00$ 2,290.00$ 6.2% of Salary
<br />601-494.400-401.122 Fica - Administrative Assistant 748.00$ 817.00$ 6.2% of Salary
<br />601-494.400-401.123 Medicare - City Administrator 670.00$ 722.00$ 1.45% of Salary
<br />601-494.400-401.123 Medicare - Billing Clerk 513.00$ 536.00$ 1.45% of Salary
<br />601-494.400-401.123 Medicare - Administrative Assistant 175.00$ 191.00$ 1.45% of Salary
<br />601-494.400-401.131 Health Insurance - Billing Clerk 14,339.00$ 14,641.00$ 50% of HealthPartners High-Deductible Plan
<br />601-494.400-401.131 Health Insurance - Administrative Assistant 7,789.00$ -$ Coverage through Spouse
<br />601-494.400-401.131 Contributions to Employee Health Savings Accounts 400.00$ -$ Offset Higher Deductible
<br />601-494.400-401.132 Dental Insurance - Billing Clerk 517.00$ 615.00$ 50% of Delta Dental Plan
<br />601-494.400-401.132 Dental Insurance - Administrative Assistant 353.00$ 308.00$ 25% of Delta Dental Plan
<br />601-494.400-401.151 Worker's Compensation - Billing Clerk 262.00$ 314.00$ $36,926/100*$0.85
<br />601-494.400-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.400-402.200 Office Supplies 4,500.00$ 6,000.00$ Utility bills and envelopes, standard supplies
<br />601-494.400-402.200 - Utility Bill Printing & Mailing (outsourced) 1,250.00$ 2,000.00$ Outsourced to Graphic Resources Inc
<br />601-494.400-402.200 - Pervasive Software Upgrade 150.00$ 250.00$ Needed to operate FundBalance Software
<br />601-494.400-402.200 - Netmotion Services/Remote 175.00$ 350.00$ Remote Connection
<br />6,075.00$ 8,600.00$
<br />601-494.400-402.201 Breakroom Supplies 750.00$ 950.00$ RLC moved to Gen Govt Bldgs
<br />601-494.400-402.205 Water Brochures 50.00$ 75.00$ Department of Health requirement
<br />6,875.00$ 9,625.00$
<br />Professional Services:
<br />601-494.400-403.301 Audit 8,470.00$ 9,317.00$ Annual audit fees
<br />601-494.400-403.301 Accounting Services 38,450.00$ 38,450.00$ Implement GASB pronouncements
<br />601-494.400-403.304 Legal Fees - WBL Restoration Litigation 2,000.00$ 5,000.00$ WBL Restoration Litigation
<br />601-494.400-403.304 Legal Fees - DNR Administrative Appeal -$ 14,500.00$ DNR Administrative Appeal
<br />601-494.400-403.304 Legal Fees - Tower No. 4 2,500.00$ 2,500.00$ Miscellaneous Water Issues
<br />51,420.00$ 69,767.00$
<br />Contractual Maintenance:
<br />601-494.400-409.404 Software Maintenance Agreements - Fund Balance 1,225.00$ 1,725.00$ Software upgrades & troubleshooting
<br />601-494.400-409.404 Software Maintenance Agreements - UB Scan 175.00$ 275.00$ Software upgrades & troubleshooting
<br />601-494.400-409.404 Annual Maintenance - Credit Cards -$ 2,500.00$ Software upgrades & troubleshooting
<br />601-494.400-409.404 Software Maintenance Agreements - Scada 250.00$ 1,250.00$ Water level alarm system - towers and wells
<br />Page 2
|