|
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 />SEWER REVENUES:
<br />Sewer Billings:
<br />- Residential
<br />$
<br />789,195.00
<br />$
<br />820,319.00
<br />$
<br />908,399.00
<br />- Multi Family
<br />$
<br />389,324.00
<br />$
<br />393,157.00
<br />$
<br />427,628.00
<br />- Commercial
<br />$
<br />39,588.00
<br />$
<br />40,597.00
<br />$
<br />41,484.00
<br />- Industrial
<br />$
<br />19,568.00
<br />$
<br />22,358.00
<br />$
<br />23,662.00
<br />- Educational
<br />$
<br />4,736.00
<br />$
<br />6,876.00
<br />$
<br />8,012.00
<br />- Account Adjustments
<br />$
<br />-
<br />$
<br />-
<br />$
<br />-
<br />Sewer Billings (Revenue Requirement)
<br />$
<br />1,242,411.00
<br />$
<br />1,283,307.00
<br />$
<br />1,409,185.00
<br />Sewer Penalties
<br />$
<br />11,420.00
<br />$
<br />12,731.00
<br />$
<br />12,994.00
<br />TOTAL SEWER REVENUES
<br />$
<br />1,253,831.00
<br />$
<br />1,296,038.00
<br />$
<br />1,422,179.00
<br />SEWER EXPENSES:
<br />Operation & Maintenance
<br />Wages:
<br />Public Works Director - Anderson
<br />$
<br />37,175.00
<br />$
<br />37,175.00
<br />$
<br />38,290.00
<br />Compensated Absences - Anderson
<br />$
<br />1,000.00
<br />$
<br />1,000.00
<br />$
<br />1,000.00
<br />Maintenance Worker - Smith
<br />$
<br />30,944.00
<br />$
<br />30,944.00
<br />$
<br />31,873.00
<br />Compensated Absences - Smith
<br />$
<br />1,000.00
<br />$
<br />1,000.00
<br />$
<br />1,000.00
<br />Maintenance Worker - Pettee
<br />$
<br />30,944.00
<br />$
<br />5,986.00
<br />$
<br />26,717.00
<br />Compensated Absences - Pettee
<br />$
<br />1,000.00
<br />$
<br />-
<br />$
<br />1,000.00
<br />In Lieu of Health Insurance
<br />$
<br />2,550.00
<br />$
<br />2,550.00
<br />$
<br />2,880.00
<br />Standby Pay
<br />$
<br />7,800.00
<br />_ $
<br />7,800.00
<br />$
<br />8,060.00
<br />Overtime (104 hours at overtime rate) - Smith
<br />$
<br />4,642.00
<br />_ $
<br />4,642.00
<br />$
<br />4,781.00
<br />Overtime (104 hours at overtime rate) - Pettee
<br />$
<br />4,642.00
<br />$
<br />-
<br />$
<br />4,008.00
<br />$
<br />121,697.00
<br />$
<br />91,097.00
<br />$
<br />119,609.00
<br />Fringe Benefits:
<br />Pera - Anderson
<br />$
<br />2,788.00_
<br />2,788.00
<br />$
<br />2,872.00
<br />Pera - Smith
<br />$
<br />2,669.00
<br />$
<br />2,669.00
<br />$
<br />2,749.00
<br />Pera - Pettee
<br />$
<br />2,669.00
<br />$
<br />449.00
<br />$
<br />2,304.00
<br />Pera - Standby Pay
<br />$
<br />585.00
<br />_i
<br />_ $
<br />585.00
<br />$
<br />605.00
<br />Fica - Anderson
<br />$
<br />2,305.00
<br />is
<br />2,305.00
<br />$
<br />2,374.00
<br />Fica - Smith
<br />$
<br />2,206.00
<br />_ $
<br />2,206.00
<br />$
<br />2,273.00
<br />Fica - Pettee
<br />$
<br />2,206.00
<br />$
<br />371.00
<br />$
<br />1,905.00
<br />Fica - Standby Pay
<br />$
<br />484.00
<br />$
<br />484.00
<br />$
<br />500.00
<br />Medicare - Anderson
<br />$
<br />539.00
<br />$
<br />539.00
<br />$
<br />555.00
<br />Medicare - Smith
<br />$
<br />516.00
<br />$
<br />516.00
<br />$
<br />531.00
<br />Medicare - Pettee
<br />$
<br />516.00
<br />$
<br />87.00
<br />$
<br />446.00
<br />Medicare - Standby Pay
<br />$
<br />113.00
<br />$
<br />113.00
<br />$
<br />117.00
<br />Health Insurance -Anderson
<br />$
<br />6,909.00
<br />$
<br />7,074.00
<br />$
<br />8,480.00
<br />Health Insurance - Pettee
<br />$
<br />10,791.00
<br />$
<br />815.00
<br />$
<br />5,077.00
<br />Dental Insurance - Anderson
<br />$
<br />413.00
<br />$
<br />470.00
<br />$
<br />470.00
<br />Dental Insurance - Smith
<br />$
<br />470.00
<br />$
<br />705.00
<br />$
<br />705.00
<br />Dental Insurance - Pettee
<br />$
<br />705.00
<br />$
<br />45.00
<br />$
<br />267.00
<br />Worker's Compensation - Anderson
<br />$
<br />4,140.00
<br />$
<br />2,424.00
<br />$
<br />3,703.00
<br />Worker's Compensation - Smith
<br />$
<br />3,305.00
<br />$
<br />2,485.00
<br />$
<br />3,544.00
<br />Worker's Compensation - Pettee
<br />$
<br />3,305.00
<br />$
<br />-
<br />$
<br />2,971.00
<br />Worker's Compensation - Standby Pay
<br />$
<br />-
<br />$
<br />(342.00)
<br />$
<br />-
<br />$
<br />47,634.00
<br />$
<br />26,788.00
<br />$
<br />42,448.00
<br />Page 5
<br />
|