|
2019 Water and Sewer Business Pro -Forma
<br />ACCOUNT
<br />2018
<br />Estimated
<br />2019
<br />DESCRIPTION
<br />12131/2018
<br />Notes
<br />Water Bacteria Testing
<br />$
<br />1,300.00
<br />$
<br />1,200.00
<br />$
<br />1,500.00
<br />$125/month
<br />Building Cleaning Services (contract)
<br />$
<br />2,500.00
<br />$
<br />2,000.00
<br />$
<br />2,100.00
<br />$175/month
<br />Scada System Troubleshooting
<br />$
<br />650.00
<br />$
<br />650.00
<br />$
<br />650.00
<br />Contingency budget
<br />Safety Training
<br />$
<br />1,500.00
<br />$
<br />1,485.00
<br />$
<br />1,515.00
<br />OSHA required safety training
<br />$
<br />5,950.00
<br />$
<br />5,335.00
<br />$
<br />5,765.00
<br />Engineering:
<br />Engineering - Non-specific engineering fees
<br />$
<br />12,500.00
<br />$
<br />12,500.00
<br />$
<br />12,500.00
<br />Contingency budget
<br />Engineering -Well Head Protection Plan
<br />$
<br />5,985.00
<br />$
<br />1,003.00
<br />$
<br />This took 41 months to complete
<br />Engineering- Implement Well Head Prot. Plan
<br />$
<br />-
<br />$
<br />4,982.00
<br />$
<br />5,000.00
<br />Itjust never ends!
<br />$
<br />18,485.00
<br />$
<br />18,485.00
<br />$
<br />17,500.00
<br />Utilities:
<br />Electricity:
<br />Xcel - Public Works Facility
<br />$
<br />4,000.00
<br />$
<br />4,137.00
<br />$
<br />4,220.00
<br />2% Increase
<br />- Xcel - Well No. 2 & Tower No. 2
<br />$
<br />4,292.00
<br />$
<br />4,395.00
<br />$
<br />4,485.01)
<br />2% Increase
<br />- Xcel - Well No. 3
<br />$
<br />7,339.00
<br />$
<br />7,370.00
<br />$
<br />7,520.00
<br />2% Increase
<br />Xcel - Tower No. 3
<br />$
<br />4,317.00
<br />$
<br />3,216.00
<br />$
<br />3,280.00
<br />2% Increase
<br />Xcel - Well No. 4
<br />$
<br />8,264.00
<br />$
<br />6,157.00
<br />$
<br />6,280.00
<br />2% Increase
<br />Xcel - Well No. 5
<br />$
<br />6,585.00
<br />$
<br />5,975.00
<br />$
<br />6,095.00
<br />2% Increase
<br />- Xcel - Well No. 6
<br />$
<br />5,324.00
<br />$
<br />3,967.00
<br />$
<br />4,046.00
<br />2% Increase
<br />BHE - Well No. 2 (solar garden contract)
<br />$
<br />9,203.00
<br />$
<br />7,480.00
<br />$
<br />7,630.00
<br />2% Increase
<br />- BHE - Well No. 3 (solar garden contract)
<br />$
<br />17,620.00
<br />$
<br />14,210.00
<br />$
<br />14,495.00
<br />2% Increase
<br />BHE- Well No.4 (solar garden contract)
<br />$
<br />21,226.00
<br />$
<br />17,100.00
<br />$
<br />17,445.00
<br />2% Increase
<br />BHE- Well No. 5 (solar garden contract)
<br />$
<br />16,043.00
<br />$
<br />12,895.00
<br />$
<br />13,155.00
<br />2% Increase
<br />BHE- Well No. 6 (solar garden contract)
<br />$
<br />13,567.00
<br />$
<br />10,985.00
<br />$
<br />11,205.00
<br />2% Increase
<br />$
<br />117,780.00
<br />$
<br />97,887.00
<br />$
<br />99,856.00
<br />Gas for Public Works Facility
<br />$
<br />2,500.00
<br />$
<br />2,768.00
<br />$
<br />2,823.00
<br />2% Increase
<br />Refuse Disposal
<br />$
<br />3,000.00
<br />$
<br />3,610.00
<br />$
<br />4,220.00
<br />Gene's Disposal
<br />$
<br />123,280.00
<br />$
<br />104,265.00
<br />$
<br />106,899.00
<br />Cellular Phone Charges
<br />$
<br />3,600.00
<br />$
<br />3,265.00
<br />$
<br />3,600.00
<br />Includes phone for new employee
<br />Business Internet - Comcast (prior to upgrade)
<br />$
<br />18.00
<br />$
<br />18.00
<br />$
<br />Upgraded to higher speed (see below)
<br />Business Internet - Comcast (upgraded speed)
<br />$
<br />732.00
<br />$
<br />2,086.00
<br />$
<br />2,100.00
<br />100mb service (up from 20mb service)
<br />Line 651653-1154 583 Scada
<br />$
<br />345.00
<br />$
<br />353.00
<br />$
<br />360.00
<br />$30/month
<br />$
<br />4,695.00
<br />$
<br />5,722.00
<br />$
<br />6,060.00
<br />Travel & Training:
<br />Training Classes
<br />$
<br />1,500.00
<br />$
<br />1,635.00
<br />$
<br />1,650.00
<br />Water school, exams, and certificate renewals
<br />$
<br />1,500.00
<br />$
<br />1,635.00
<br />$
<br />1,650.00
<br />Professional Memberships:
<br />Dues
<br />$
<br />80.00
<br />$
<br />82.00
<br />$
<br />85.00
<br />American Public Works Assn
<br />$
<br />_
<br />80.00
<br />$
<br />82.00
<br />$
<br />85.00
<br />Administration
<br />Wages:
<br />City Administrator
<br />$
<br />35,287.00
<br />$
<br />37,201.00
<br />$
<br />40,889.00
<br />25%of Pay Grade 13 Maximum
<br />Billing Clerk
<br />$
<br />30,944.00
<br />$
<br />28,326.00
<br />$
<br />30,489.00
<br />50%of Pay Grade 5 Step 5
<br />Compensated Absences
<br />$
<br />1,000.00
<br />$
<br />1,000.00
<br />$
<br />1,000.00
<br />Administrative Assistant
<br />$
<br />$
<br />2,233.00
<br />$
<br />10,874.00
<br />25%of Pay Grade 4 Minimum (start 10/08/18)
<br />Compensated Absences
<br />$
<br />-
<br />$
<br />$
<br />1,000.00
<br />$
<br />67,231.00
<br />$
<br />68,760.00
<br />$
<br />84,252.00
<br />Fringe Benefits:
<br />Pera-CityAdministrator
<br />$
<br />2,647.00
<br />$
<br />2,790.00
<br />$
<br />3,067.00
<br />7.5%of Salary
<br />Pera-Billing Clerk
<br />$
<br />2,320.00
<br />$
<br />2,124.00
<br />$
<br />2,287.00
<br />7.5%of Salary
<br />Pera -AdministrativeAssistant
<br />$
<br />-
<br />$
<br />167.00
<br />$
<br />816.00
<br />7.5%of Salary
<br />Fica- CityAdministrator
<br />$
<br />1,972.00
<br />$
<br />1,990.00
<br />$
<br />2,050.00
<br />6.2%of5alary
<br />Fica-Billing Clerk
<br />$
<br />2,134.00
<br />$
<br />1,756.00
<br />$
<br />1,890.00
<br />6.2%of Salary
<br />Ffca- AdministrativeAssistant
<br />$
<br />$
<br />138.00
<br />$
<br />674.00
<br />6.2%of Salary
<br />r.'edicare- CityAdministrator
<br />$
<br />512.00
<br />$
<br />539.00
<br />$
<br />593.00
<br />1.45% ofSalary
<br />Medicare -Billing Clerk
<br />$
<br />448.00
<br />$
<br />411.00
<br />$
<br />442.00
<br />1.45% ofSalary
<br />Medicare - AdministrativeAssistant
<br />$
<br />-
<br />$
<br />32.00
<br />$
<br />158.00
<br />1.45% ofSalary
<br />IfealthInsurance- BillingClerk
<br />$
<br />9,632.00
<br />$
<br />9,817.00
<br />$
<br />11,802.00
<br />50% of HealthPartners High -Deductible Plan
<br />I lealth Insurance - AdministrativeAssistant
<br />$
<br />-
<br />$
<br />328.00
<br />$
<br />1,356.00
<br />25%of Health Partners High -Deductible Plan
<br />Dental Insurance - Billing Clerk
<br />$
<br />520.00
<br />$
<br />517.00
<br />$
<br />517.00
<br />50%of Delta Dental Plan
<br />9ental Insurance -Administrative Assistant
<br />$
<br />$
<br />33.00
<br />$
<br />134.00
<br />25% of Delta Dental Plan
<br />Worker's Compensation - Billing Clerk
<br />$
<br />177.00
<br />$
<br />137.00
<br />$
<br />220.00
<br />$30,489/100*$0.72
<br />Worker's Compensation - Administrative Assistant
<br />$
<br />-
<br />$
<br />-
<br />$
<br />78.00
<br />$10,874/100'$0.72
<br />$
<br />20,362.00
<br />$
<br />20,779.00
<br />$
<br />26,084.00
<br />Supplies:
<br />_
<br />Office Supplies
<br />$
<br />3,000.00
<br />$
<br />3,000.00
<br />$
<br />3,000.00
<br />Utility bills and envelopes, standard supplies
<br />Utility Bill Printing & Mailing (outsourced)
<br />$
<br />$
<br />950.00
<br />$
<br />975.00
<br />Outsourced to Graphic Resources Inc
<br />- Utility Rate Change Insert
<br />$
<br />$
<br />126.00
<br />$
<br />126.00
<br />Special rate schedule printing and mailing
<br />- Irrigation Usage Postcards
<br />$
<br />$
<br />850.00
<br />$
<br />850.00
<br />Reminder of increase in irrigation rates
<br />- Pervasive Software Upgrade
<br />$
<br />$
<br />140.00
<br />$
<br />140.00
<br />Needed to operate Fund Balance Software
<br />- Admin Assistant Work Station
<br />$
<br />$
<br />1,545.00
<br />$
<br />-
<br />Prepare work station for PW Admin Asst
<br />Desktop Computer Systems
<br />$
<br />$
<br />1,000.00
<br />$
<br />1,000.00
<br />Prepare work station for PW Admin Asst
<br />$
<br />3,000.00
<br />$
<br />7,611.00
<br />$
<br />6,091.00
<br />Page 2
<br />
|