|
2019 Water and Sewer Business Pro -Forma
<br />ACCOUNT
<br />DESCRIPTION
<br />2018 Estimated 2019
<br />12131/2018 Notes
<br />Fringe Benefits:
<br />Pera- Anderson
<br />$
<br />2,788.00
<br />$
<br />2,788.O0
<br />$
<br />2,872.00
<br />7.5%of Salary
<br />Pera - Smith
<br />$
<br />2,669.00
<br />$
<br />2,669.00
<br />$
<br />2,749.00
<br />7.5%of Salary & Overtime
<br />Para - Pettee
<br />$
<br />2,669.00
<br />$
<br />449.00
<br />$
<br />2,304.00
<br />7.5%of Salary & Overtime
<br />Pera - Standby Pay
<br />$
<br />585.00
<br />$
<br />585.00
<br />$
<br />605.00
<br />7.5%of Standby Pay
<br />Fica- Anderson
<br />$
<br />2,305.00
<br />$
<br />2,305.00
<br />$
<br />2,374.00
<br />6.2%of5alary
<br />Fica - Smith
<br />$
<br />2,206.00
<br />$
<br />2,206.00
<br />$
<br />2,273.00
<br />6.2%of Salary&Overtime
<br />Fica - Pettee
<br />$
<br />2,206.00
<br />$
<br />371.00
<br />$
<br />1,905.00
<br />6.2%of Salary & Overtime
<br />Fica-Standby Pay
<br />$
<br />484.00
<br />$
<br />484.00
<br />$
<br />500.00
<br />6.2%of Standby Pay
<br />Medicare -Anderson
<br />$
<br />539.00
<br />$
<br />539.00
<br />$
<br />555.00
<br />1.45%of Salary
<br />Medicare -Smith
<br />$
<br />516.00
<br />$
<br />516.00
<br />$
<br />531.00
<br />1.45%of Salary & Overtime
<br />Medicare -Pettee
<br />$
<br />516.00
<br />$
<br />87.00
<br />$
<br />446.00
<br />1.45%of Salary & Overtime
<br />Medicare -Standby Pay
<br />$
<br />113.00
<br />$
<br />113.00
<br />$
<br />117.00
<br />1.45% of Standby Pay
<br />Health Insurance -Anderson
<br />$
<br />6,909.00
<br />$
<br />7,074.00
<br />$
<br />8,480.00
<br />33%of Health Partners High -Deductible Plan
<br />Health Insurance - Pettee
<br />$
<br />10,791.00
<br />$
<br />815.00
<br />$
<br />5,077.00
<br />50%of Health Partners High -Deductible Plan
<br />Dental Insurance -Anderson
<br />$
<br />413.00
<br />$
<br />470.00
<br />$
<br />470.00
<br />33% of Delta Dental Plan
<br />Dental Insurance -Smith
<br />$
<br />470.00
<br />$
<br />705.00
<br />$
<br />705.00
<br />50%of Delta Dental Plan
<br />Dental Insurance -Pettee
<br />$
<br />705.00
<br />$
<br />45.00
<br />$
<br />267.00
<br />50% of Delta Denta I Plan
<br />Worker's Compensation - Anderson
<br />$
<br />4,140.00
<br />$
<br />2,424.00
<br />$
<br />3,703.00
<br />$38,290/100*$9.67
<br />Worker's Compensation - Smith
<br />$
<br />3,305.00
<br />$
<br />2,485.00
<br />$
<br />3,544.00
<br />$36,654/100*$9.67
<br />Worker's Compensation - Pettee
<br />$
<br />3,305.00
<br />$
<br />-
<br />$
<br />2,971.00
<br />$30,725/100*$9.67
<br />Worker's Compensation - Standby Pay
<br />$
<br />-
<br />$
<br />(342.00)
<br />$
<br />-
<br />Exempt from work comp
<br />$
<br />47,634.00
<br />$
<br />26,788.00
<br />$
<br />42,448.00
<br />Cleaning Supplies
<br />$
<br />1,940.00
<br />5
<br />1,940.00
<br />$
<br />1,940.00
<br />Catchall account for rags, first aid supplies....
<br />Motor Fuels
<br />$
<br />2,000.00
<br />$
<br />2,145.00
<br />$
<br />2,656.00
<br />Sewer Department's share of bulk fuel purchases
<br />Small Tools & Equipment
<br />$
<br />10,000.00
<br />$
<br />7,600.00
<br />$
<br />10,000.00
<br />Shop tools, shelving, cold -weather gear...
<br />-CommunicationsHeadset&Hub
<br />$
<br />$
<br />4,916.00
<br />$
<br />-
<br />Operating the Vactor Truck
<br />Uniforms
<br />_$
<br />2,000.00 _
<br />$
<br />1,170.00
<br />$
<br />2,040.00
<br />$170/month
<br />$
<br />15,940.00
<br />$
<br />17,771.00
<br />$
<br />16,636.00
<br />Repairs & Maintenance:
<br />Repairs & Maintenance
<br />$
<br />20,000.00
<br />$
<br />34,800.00
<br />$
<br />34,800.00
<br />Lubricants, shop supplies, vactor maint....
<br />Submersible Pumps for Lift Stations
<br />$
<br />20,000.00
<br />$
<br />21,000.00
<br />$
<br />22,000.00
<br />Lift Station No. 3 in 2018 - Budget one per year
<br />Lift Station Rebuilds
<br />$
<br />40,000.00
<br />$
<br />-
<br />$
<br />37,000.00
<br />Budget for one rebuild per year
<br />Building Repair & Maintenance
<br />$
<br />8,000.00
<br />$
<br />2,500.00
<br />$
<br />5,000.00
<br />Non-specific building repairs
<br />- Septic System Pumping
<br />$
<br />2,780.00
<br />$
<br />2,930.00
<br />$
<br />3,000.00
<br />$250/month
<br />- Weed Control
<br />$
<br />-
<br />$
<br />229.00
<br />$
<br />300.00
<br />Public works site
<br />HVAC Repairs
<br />$
<br />4,400.00
<br />$
<br />2,140.00
<br />$
<br />4,400.00
<br />NAC Mechanical Inc
<br />$
<br />95,180.00
<br />$
<br />63,599.00
<br />$
<br />106,500.00
<br />Professional Services:
<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.O0
<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 />4,650.00
<br />$
<br />4,135.00
<br />$
<br />4,265.00
<br />Sewage Treatment:
<br />Metro Council Environmental Services
<br />$
<br />528,283.00
<br />$
<br />528,283.00
<br />$
<br />558,801.00
<br />$18,490 due to flow - $12,028 due to rate increase
<br />$
<br />528,283.00
<br />$
<br />528,283.00
<br />$
<br />558,801.00
<br />Utilities:
<br />Electricity:
<br />- Lift Stations
<br />$
<br />9,100.00
<br />$
<br />9,230.00
<br />$
<br />9,415.00
<br />2% Increase
<br />- PWFacility
<br />$
<br />4,000.00
<br />$
<br />4,137.00
<br />$
<br />4,220.00
<br />2%Increase
<br />$
<br />13,100.00
<br />$
<br />13,367.00
<br />$
<br />13,635.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 />18,600.00
<br />$
<br />19,745.00
<br />$
<br />20,679.00
<br />Communications:
<br />Cellular Phone Charges
<br />$
<br />3,600.00
<br />$
<br />3,265.00
<br />$
<br />3,600.00
<br />Includes phonefor 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 />e usiness Internet - Comcast (upgraded speed)
<br />$
<br />732.00
<br />$
<br />2,086.00
<br />$
<br />2,000.00
<br />300mb 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 />5,960.00
<br />Travel & Training:
<br />Training Classes
<br />$
<br />3,200.00
<br />$
<br />4,300.00
<br />$
<br />4,300.00
<br />Sewer school, exams, and certificate renewals
<br />-VactorTruckTraining
<br />$
<br />-
<br />$
<br />590.00
<br />$
<br />600.00
<br />Specialized equipment training
<br />Trip to California to Inspect Vactor Truck
<br />$
<br />$
<br />2,089.00
<br />$
<br />One-time event (I hope)
<br />$
<br />3,200.00
<br />$
<br />6,979.00
<br />$
<br />4,900.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 />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,OOD.00
<br />$
<br />1,000.00
<br />Page 4
<br />
|