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 />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 />Supplies:
<br />Cleaning Supplies
<br />$
<br />1,940.00
<br />$
<br />1,940.00
<br />$
<br />1,940.00
<br />Chemicals
<br />$
<br />50,000.00
<br />_ $
<br />32,440.00
<br />$
<br />40,000.00
<br />- Hazardous Waste Generators License
<br />$
<br />260.00
<br />$
<br />114.00
<br />$
<br />120.00
<br />Motor Fuels
<br />$
<br />2,000.00
<br />_'
<br />_ $
<br />2,145.00
<br />$
<br />2,656.00
<br />Small Tools & Equipment
<br />$
<br />10,000.00
<br />$
<br />6,620.00
<br />$
<br />10,000.00
<br />Uniforms
<br />$
<br />2,000.00
<br />_ $
<br />1,170.00
<br />$
<br />2,040.00
<br />Smart Controllers (for irrigation systems)
<br />$
<br />-
<br />$
<br />-
<br />$
<br />10,000.00
<br />Water Meters
<br />$
<br />100,000.00
<br />$
<br />100,000.00
<br />$
<br />100,000.00
<br />$
<br />166,200.00
<br />_'
<br />$
<br />144,429.00
<br />$
<br />166,756.00
<br />Repairs & Maintenance:
<br />T
<br />Repairs & Maintenance
<br />$
<br />39,600.00
<br />$
<br />30,000.00
<br />$
<br />30,000.00
<br />- Watermain Breaks
<br />$
<br />15,000.00
<br />$
<br />30,814.00
<br />$
<br />32,000.00
<br />- Well Pump Repairs
<br />$
<br />25,000.00
<br />$
<br />25,000.00
<br />$
<br />25,000.00
<br />Building Repair & Maintenance
<br />$
<br />8,000.00
<br />$
<br />3,100.00
<br />$
<br />5,000.00
<br />- Reroof well houses
<br />$
<br />-
<br />$
<br />24,434.00
<br />$
<br />-
<br />- Septic System Pumping
<br />$
<br />2,780.00
<br />$
<br />2,930.00
<br />$
<br />3,000.00
<br />- Weed Control
<br />$
<br />-
<br />$
<br />841.96
<br />$
<br />850.00
<br />- HVAC Repairs
<br />$
<br />4,400.00
<br />$
<br />4,400.00
<br />$
<br />4,400.00
<br />$
<br />94,780.00
<br />$
<br />121,519.96
<br />$
<br />100,250.00
<br />Professional Services:
<br />Water Bacteria Testing
<br />$
<br />1,300.00
<br />$
<br />1,200.00
<br />$
<br />1,500.00
<br />Building Cleaning Services (contract)
<br />$
<br />2,500.00
<br />$
<br />2,000.00
<br />$
<br />2,100.00
<br />Scada System Troubleshooting
<br />$
<br />650.00
<br />$
<br />650.00
<br />$
<br />650.00
<br />Safety Training
<br />$
<br />1,500.00
<br />$
<br />1,485.00
<br />$
<br />1,515.00
<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 />Engineering - Well Head Protection Plan
<br />$
<br />5,985.00
<br />$
<br />1,003.00
<br />$
<br />-
<br />Engineering - Implement Well Head Prot. Plan
<br />$ - j
<br />m $
<br />4,982.00
<br />$
<br />5,000.00
<br />$
<br />18,485.00
<br />$
<br />18,485.00
<br />$
<br />17,500.00
<br />Utilities:
<br />Electricity:
<br />_
<br />- Xcel - Public Works Facility
<br />$
<br />4,000.00
<br />_ $
<br />4,137.00
<br />$
<br />4,220.00
<br />- Xcel - Well No. 2 & Tower No. 2
<br />$
<br />4,292.00
<br />_ $
<br />4,395.00
<br />$
<br />4,485.00
<br />- Xcel - Well No. 3
<br />$
<br />7,339.00
<br />$
<br />7,370.00
<br />$
<br />7,520.00
<br />- Xcel -Tower No. 3
<br />$
<br />4,317.00
<br />$
<br />3,216.00
<br />$
<br />3,280.00
<br />- Xcel - Well No. 4
<br />$
<br />8,264.00
<br />$
<br />6,157.00
<br />$
<br />6,280.00
<br />- Xcel - Well No. 5
<br />$
<br />6,585.00
<br />$
<br />5,975.00
<br />$
<br />6,095.00
<br />- Xcel - Well No. 6
<br />$
<br />5,324.00
<br />$
<br />3,967.00
<br />_ $
<br />4,046.00
<br />- BHE -Well No. 2 (solar garden contract)
<br />$
<br />9,203.00
<br />$
<br />7,480.00
<br />$
<br />7,630.00
<br />- BHE -Well No. 3 (solar garden contract)
<br />$
<br />17,620.00
<br />$
<br />14,210.00
<br />$
<br />14,495.00
<br />- BHE -Well No. 4 (solar garden contract)
<br />$
<br />21,226.00
<br />$
<br />17,100.00
<br />$
<br />17,445.00
<br />- BHE -Well No. 5 (solar garden contract)
<br />$
<br />16,043.00
<br />$
<br />12,895.00
<br />$
<br />13,155.00
<br />- BHE - Well No. 6 (solar garden contract)
<br />$
<br />13,567.00
<br />$
<br />10,985.00
<br />$
<br />11,205.00
<br />Page 2
<br />
|