2019.11.04 RESO 2019-47 Sewer and Water Rates for 2020

Home

2020 Water and Sewer Business Pro -Forma ACCOUNT 2019 2019 2020 DESCRIPTION Adopted Projected L- Proposed Notes Professional Services: Water Bacteria Testing $ 1,500.00 $ 1,500.00 $ 1,500.00 $125/month Random Personnel Testing .$ $ 100.00 _$ 100.00 New personnel policy provision $ 2,100.00 $175/month Building Cleaning Services (contract) $ 2,100.00 $ 2,004.00 $ 650.00 $ 1,515.00 $ 650.00 $ 1,544.00 _ Scada System Troubleshooting $ 650.00 Contingency budget $ 1,575.00 OSHA required safety training $ 5,925.00 $ 10,000.00 Contingency budget Safety Training $ 5,765.00 $ 5,798.00 Engineering: Engineering - Non-specific engineering fees $ 12,500.00 $ 1,669.00 $ 5,000.00 $ 7,820.00 $ 9,489.00 Engineering - Implement Well Head Prot. Plan $ Implementation complete? $ 10,000.00 _ $ 17,500.00I Utilities: ILLL $ 4,260.00 5% Increase above projected $ 5,630.00 5% Increase above projected $ 6,915.00 5% Increase above projected $ 3,520.00 5% Increase above projected $ 8,235.00 5% Increase above projected $ 4,570.00 5% Increase above projected $ 4,635.00 5% Increase above projected - Electricity: Xcel - Public Works Facility $ 4,220.00 _ $ 4,055.00 $ 5,360.00 $ 6,586.00 Xcel - Well No. 2 & Tower No. 2 $ 4,485.00 Xcel - Well No. 3 $ 7,520.00 Xcel -Tower No. 3 $ 3,280.00 $ 3,353.00 Xcel - Well No. 4 $ 6,280.00 _$ 6,095.00 $ 4,046.00 $ 7,840.00 $ 4,353.00 $ 4,413.00 . - Xcel - Well No. 5 - Xcel - Well No. 6 BHE - Well No. 2 (solar garden contract) $ 7,630.00 $ 6,608.00 $ 6,940.00 . 5% Increase above projected BHE - Well No. 3 (solar garden contract) $ 14,495.00 $ 12,529.00 $ 13,155.00 5% Increase above projected BHE - Well No. 4 (solar garden contract) $ 17,445.00 $ 14,693.00 $ 15,430.00 5% Increase above projected BHE - Well No. 5 (solar garden contract) $ 13,155.00 $ 11,937.00 $ 12,535.00 5% Increase above projected - BHE -Well No. 6 (solar garden contract) $ 11,205.00 $ 9,845.00 . $ 10,340.00 _ .5% Increase above projected $ 99,856.00 $ 91,572.00 $ 96,165.00 _ Gas for Public Works Facility $ 2,823.00 $ 3,033.00 $ 3,185.00 15% Increase above projected Refuse Disposal $ 4,220.00 $ 3,680.00 $ 4,200.00 f Gene's Disposal i $ 106,899.00 $ 98,285.00 $ 103,550.00 Communications: Cellular Phone Charges $ 3,600.00 $ 2,142.00 _$ 2,160.00 $180/month Business Internet- Comcast (upgraded speed) $ 2,100.00 $ 1,950.00 $ 2,100.00 1DOmb service (up from 20mb service) Line 651653-1154 583 Scada $ 360.00 $ 360.00 $ 360.00 1 J$30/month $ 6,060.00 _$ 4,452.00 J $ 4,620.00 Travel & Training: 1 [ Training Classes $ 1,650.00 $ 2,200.OD $ 2,200.00 Water school, exams, and certificate renewals $ 1,650.00 $ 2,2.0.00 $ 2,200.00 _Professional Memberships: _ f Dues .$ 85.00 ,,- $ 85.00 $ _ 85.00 American Public Works Assn Dues $ $ 137.00 $ 150.00 Minnesota Rural Water Assn Dues $ $ 315.00 $ 315.00 American Waterworks Assn $ 85.00) I $ 537.00 $ 550.00 Administration Wages: _ City Administrator_ _ $ 40,889.00 $ 40,889.00 $ 43,372.00 25%of Pay Grade 14 Step 4 Billing Clerk .$ 30,489.00 J .$ 30,489.00 _ $ 32,829.00 50%of Pay Grade 5 Maximum Compensated Absences $ 1,000.00 $ 1,000.00 $ 1,000.00 50%of increase in PTO Bank Administrative Assistant $ 10,874.00 $ 10,874.00 $ 11,704.00 25%ofPay Grade 4Minimum Step 1 Compensated Absences $ 1,000.00 .$ 500.00 $ 500.00 25% of increase in PTO Bank $ 84,252.00 $ 83,752.00 $ 89,405.00 Fringe Benefits: Pera - City Administrator $ 3,067.00 [ $ 3,067.01) $ 3,253.00 7.5%of Salary Pera - Billing Clerk $ 2,287.00 $ 21287.00 $ 816.00 . ^ $ 2,462.09 $ 878.00 17.5%of Salary Pera- AdministrativeAssistant $ 816.00 7.5%of Salary Pica - City Administrator $ 2,050.00 $ 2,050.00 $ 2,689.00 16.2%of Salary $ 1,890.00 $ 2,035.00 16.2%ofSalary .$ 674.00. __$ 726.00 6.2%of Salary $ 593.00 _ $ 629.00 T 1.45%ofSala ry $ 442.00 $ 476.00 1.45%of5alary $ 158.00 $ 170.00 11.45%of5alary Fica - Billing Clerk $ 1,890.00 Fica -Administrative Assistant $ 674.001 "Iedicare- CityAdministrator $ 593.00 f.'edicare- Billing Clerk $ 442.00 f.'edicare- AdministrativeAssistant $ 158.00 _ Health Insurance - Billing Clerk _ $ 11,655.00 $ 13,113.00 50%of Health Partners High -Deductible Plan $ 1,334.00 $ 1,459.00 25%of Health Partners High -Deductible Plan $ 517.00 $ 517.00 SO%of Delta Dental Plan $ 134.00 $ 134.00 25%of Delta Dental Plan $ 164.00 $ 236.00 $32,829/100*$0.72 $ 11,802.00 Health Insurance -Administrative Assistant $ 1,356.00 Dental Insurance - Billing Clerk $ 517.00 Dental Insurance -Administrative Assistant $ 134.00 Worker's Compensation - Billing Clerk $ 220.00 Worker'sCompensation- AdministrativeAssistant _ $ 81.00 $ 84.00 $11,704/100*$0.72 $ 78.00 _ $ 25,862.00 _ $ 28,861.00 $ 26,084.00 - I Supplies: $ 3,976.00 $ 4,000.00 Utility bills and envelopes, standard supplies $ 975.00 $ 1,000.00 Outsourced to Graphic Resources Inc Office Supplies $ 3,976.00 - Utility Bill Printing & Mailing (outsourced) $ 975.00 $ 140.001 Pervasive Software Upgrade _ $ 140.00 $ 150.00 Needed to operate FunclBalance Software $ 1,000.00 Desktop Computer Systems $ 1,000.00 $ 1,000.00 Electronic equipment replacement $ 6,091.00 $ 6,091.00 $ 6,150.00 $ 750.00 $ 750.00 Includes supplies for Rice Lake Centre Breakroom Supplies $ 750.00 Page 2