2019 Water and Sewer Business Pro -Forma
<br />ACCOUNT 2018 Estimated 2019
<br />DESCRIPTION Adopted 12/31/2018 Adopted
<br />$ 117,780.00 $ 97,887.00 $ 99,856.00
<br />Gas for Public Works Facility $ 2,500.00 $ 2,768.00 _� $ 2,823.00
<br />Refuse Disposal $ 3,000.00 $ 3,610.00 _� $ 4,220.00
<br />$ 123,280.00 $ 104,265.00_ $ 106,899.00
<br />Communications:
<br />Cellular Phone Charges $ 3,600.00 $ 3,265.00 $ 3,600.00
<br />Business Internet - Comcast (prior to upgrade) $ 18.00 $ 18.00 $ -
<br />Business Internet - Comcast (upgraded speed) $ 732.00 $ 2,086.00 $ 2,100.00
<br />Line 651653-1154 583 Scada $ 345.00 $ 353.00 _ $ 360.00
<br />$ 4,695.00 $ 5,722.00 $ 6,060.00
<br />Travel & Training:
<br />Training Classes $ 1,500.00 $ 1,635.00 $ 1,650.00
<br />$ 1,500.00 $ 1,635.00 $ 1,650.00
<br />Professional Memberships:
<br />......... -- ............ _........ .. .. ...................... ....
<br />Dues $ 80.00 _ $ 82.00 $ 85.00
<br />$ 80.00 $ 82.00 $ 85.00
<br />Administration
<br />Wages:
<br />City Administrator $ 35,287.00 $ 37,201.00 $ 40,889.00
<br />Billing Clerk $ 30,944.00 $ 28,326.00 _ $ 30,489.00
<br />Compensated Absences $ 1,000.00 $ 1,000.00 $ 1,000.00
<br />Administrative Assistant $ - $ 2,233.00 $ 10,874.00
<br />Compensated Absences $ - $ - $ 1,000.00
<br />$ 67,231.00 $ 68,760.00 $ 84,252.00
<br />Fringe Benefits:
<br />Pera - City Administrator $ 2,647.00 $ 2,790.00 _' $ 3,067.00
<br />Pera - Billing Clerk $ 2,320.00 $ 2,124.00 $ 2,287.00
<br />Pera - Administrative Assistant $ - $ 167.00 _ $ 816.00
<br />Fica - City Administrator $ 1,972.00 $ 1,990.00 $ 2,050.00
<br />Fica - Billing Clerk $ 2,134.00 $ 1,756.00 $ 1,890.00
<br />Fica - Administrative Assistant $ - $ 138.00 _ $ 674.00
<br />Medicare - City Administrator $ 512.00 $ 539.00 j $ 593.00
<br />Medicare - Billing Clerk $ 448.00 $ 411.00 $ 442.00
<br />Medicare - Administrative Assistant $ - $ 32.00 $ 158.00
<br />Health Insurance - Billing Clerk $ 9,632.00 $ 9,817.00 $ 11,802.00
<br />Health Insurance - Administrative Assistant $ - $ 328.00 ! $ 1,356.00
<br />Dental Insurance - Billing Clerk $ 520.00 $ 517.00 $ 517.00
<br />Dental Insurance - Administrative Assistant $ - $ 33.00$ 134.00
<br />Worker's Compensation - Billing Clerk $ 177.00 $ 137.00 _ $ 220.00
<br />Worker's Compensation - Administrative Assistant $ - $ - $ 78.00
<br />$ 20,362.00 $ 20,779.00 _ $ 26,084.00
<br />Supplies: _
<br />Office Supplies $ 3,000.00 $ 3,000.00 $ 3,000.00
<br />- Utility Bill Printing & Mailing (outsourced) $ - $ 950.00 $ 975.00
<br />- Utility Rate Change Insert $ _ - $ 126.00 $ 126.00
<br />- Irrigation Usage Postcards $ - $ 850.00 L $ 850.00
<br />- Pervasive Software Upgrade $ - $ 140.00 $ 140.00
<br />- Admin Assistant Work Station $ - $ 1,545.00 T $ -
<br />- Desktop Computer Systems $ - $ 1,000.00 $ 1,000.00
<br />Page 3
<br />
|