|
2019 Water and Sewer Business Pro -Forma
<br />ACCOUNT
<br />2018
<br />Estimated
<br />2019
<br />DESCRIPTION
<br />Adopted
<br />12/31/2018
<br />Adopted
<br />Billing Clerk
<br />$
<br />30,944.00
<br />$
<br />28,326.00
<br />$
<br />30,489.00
<br />Compensated Absences
<br />$
<br />1,000.00
<br />$
<br />1,000.00
<br />$
<br />1,000.00
<br />Administrative Assistant
<br />$
<br />-
<br />$
<br />2,233.00
<br />$
<br />10,874.00
<br />Compensated Absences
<br />$
<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 />_
<br />Pera - City Administrator
<br />$
<br />2,647.00
<br />$
<br />2,790.00
<br />$
<br />3,067.00
<br />Pera - Billing Clerk
<br />$
<br />2,320.00
<br />$
<br />2,124.00
<br />_ $
<br />2,287.00
<br />Pera - Administrative Assistant
<br />$
<br />-
<br />$
<br />167.00
<br />$
<br />816.00
<br />Fica - City Administrator
<br />$
<br />1,972.00
<br />$
<br />1,990.00
<br />$
<br />2,050.00
<br />Fica - Billing Clerk
<br />$
<br />2,134.00
<br />$
<br />1,756.00
<br />$
<br />1,890.00
<br />Fica - Administrative Assistant
<br />$
<br />-
<br />$
<br />138.00
<br />$
<br />674.00
<br />Medicare - City Administrator
<br />$
<br />512.00
<br />$
<br />539.00
<br />$
<br />593.00
<br />Medicare - Billing Clerk
<br />$
<br />448.00
<br />$
<br />411.00
<br />$
<br />442.00
<br />Medicare - Administrative Assistant
<br />$
<br />-
<br />$
<br />32.00
<br />$
<br />158.00
<br />Health Insurance - Billing Clerk
<br />$
<br />9,632.00
<br />$
<br />9,817.00
<br />_ $
<br />11,802.00
<br />Health Insurance - Administrative Assistant
<br />$
<br />-
<br />$
<br />328.00
<br />_ $
<br />1,356.00
<br />Dental Insurance - Billing Clerk
<br />$
<br />520.00
<br />$
<br />517.00
<br />$
<br />517.00
<br />Dental Insurance - Administrative Assistant
<br />$
<br />-
<br />$
<br />33.00
<br />$
<br />134.00
<br />Worker's Compensation - Billing Clerk
<br />$
<br />177.00
<br />$
<br />137.00
<br />$
<br />220.00
<br />Worker's Compensation - Administrative Assistant
<br />$
<br />-
<br />$
<br />-
<br />_
<br />$
<br />78.00
<br />$
<br />20,362.00
<br />$
<br />20,779.00
<br />_
<br />_ $
<br />26,084.00
<br />Supplies:
<br />_
<br />Office Supplies
<br />$
<br />3,000.00
<br />$
<br />3,000.00
<br />j $
<br />3,000.00
<br />- Utility Bill Printing & Mailing
<br />$
<br />-
<br />$
<br />950.00
<br />$
<br />1,000.00
<br />- Utility Rate Change Insert
<br />$
<br />-
<br />$
<br />126.00
<br />$
<br />126.00
<br />- Pervasive Software Upgrade
<br />$
<br />-
<br />$
<br />140.00
<br />_
<br />$
<br />140.00
<br />- Admin Assistant Work Station
<br />$
<br />-
<br />$
<br />1,545.00
<br />_
<br />_ $
<br />-
<br />- Desktop Computer Systems
<br />$
<br />-
<br />$
<br />1,000.00
<br />$
<br />1,300.00
<br />Breakroom Supplies
<br />$
<br />750.00
<br />$
<br />750.00
<br />$
<br />750.00
<br />$
<br />3,750.00
<br />$
<br />7,511.00
<br />$
<br />6,316.00
<br />Professional Services:
<br />Audit
<br />$
<br />6,900.00
<br />$
<br />6,900.00
<br />$
<br />7,100.00
<br />Accounting Services
<br />$
<br />2,600.00
<br />$
<br />2,733.00
<br />$
<br />2,900.00
<br />Employment Testing
<br />$
<br />-
<br />$
<br />70.00
<br />$
<br />-
<br />$
<br />9,500.00
<br />$
<br />9,703.00
<br />$
<br />10,000.00
<br />IT Support Services:
<br />Computer Technical Support - Metro Inet
<br />$
<br />3,615.00
<br />$
<br />3,840.00
<br />$
<br />3,950.00
<br />Telephone Support - City of Roseville
<br />$
<br />360.00
<br />$
<br />353.00
<br />$
<br />363.00
<br />$
<br />3,975.00
<br />$
<br />4,193.00
<br />$
<br />4,313.00
<br />Contractual Maintenance:
<br />Software Maintenance Agreements - Fund Balance
<br />$
<br />669.00
<br />$
<br />702.00
<br />$
<br />736.00
<br />Software Maintenance Agreements - Scada
<br />$
<br />-
<br />$
<br />125.00
<br />$
<br />125.00
<br />Software Maintenance Agreements - Sensus
<br />$
<br />1,100.00
<br />$
<br />1,100.00
<br />$
<br />1,100.00
<br />$
<br />1,769.00
<br />$
<br />1,927.00
<br />$
<br />1,961.00
<br />Communications:
<br />Postage
<br />$
<br />2,600.00
<br />$
<br />3,650.00
<br />$
<br />3,700.00
<br />$
<br />2,600.00
<br />$
<br />3,650.00
<br />$
<br />3,700.00
<br />Insurance:
<br />Page 7
<br />
|