|
2020 Water and Sewer Business Pro -Forma
<br />ACCOUNT
<br />DESCRIPTION
<br />Pera -Anderson
<br />Pera -Smith
<br />Pera - Pettee
<br />2019
<br />Adopted
<br />$ 2,872.00 i
<br />2019
<br />Projected L
<br />$ 2,872.00 1^.
<br />2020
<br />-Proposed
<br />$ 2,958.00
<br />$ 2,831.00
<br />$ 2,480.00
<br />$ 624.00
<br />$ 2,445.00
<br />$ 2,341.00
<br />$ 2,050.00
<br />Notes
<br />7.5%of Salary
<br />7.5%%of Salary & Overtime
<br />7.5%of Salary & Overtime _
<br />7.5% of Standby Pay
<br />6.2%of Salary
<br />6.2%of Salary & Overtime
<br />6.2% of Salary & Overtime
<br />$ 2,749.00
<br />$ 2,749.00
<br />$ 2,304.00
<br />] $ 605.00
<br />$ 2,374.00
<br />$ 2,273.00
<br />$ 1,905.00
<br />$ 2,304.001
<br />Pera - Standby Pay
<br />f $ 605.00
<br />$ 2,374.00
<br />$ 2,273.O0
<br />I $ 1,905.00
<br />Fica- Anderson
<br />Fica - Smith
<br />Fica - Pettee
<br />Fica-Standby Pay
<br />$ 500.00
<br />$
<br />500.00
<br />$ 516,00.
<br />L6.2%of Standby Pay
<br />Medicare -Anderson
<br />$ 555.00
<br />$
<br />$
<br />555.00
<br />531.00
<br />$ 572.00
<br />1.45%of Salary
<br />Medicare - Smith
<br />Medicare -Pettee
<br />Medicare -Standby Pay
<br />Health Insurance -Anderson
<br />Health Insurance -Pettee
<br />$ 531.00
<br />$ 547.00
<br />1.45%of Salary & Overtime
<br />$ 446.00
<br />$ 446.00
<br />$ 480.00
<br />1.4591of Salary & Overtime
<br />1.45%of Standby Pay
<br />33% of HealthPartners High -Deductible Plan
<br />150%ofHealthPartnersHigh-Deductible Plan
<br />$ 117.00
<br />$ 117.O0
<br />$ 121.00
<br />$ 9,198.00
<br />$ 5,077.00
<br />$ 8,480.00
<br />$ 8,347.O0
<br />$ 4,717.00
<br />$ 5,077.00
<br />Dental Insurance -Anderson
<br />$ 470.00
<br />$
<br />470.00
<br />$ 470.00
<br />33%of Delta Dental Plan
<br />Dental Insurance -Smith
<br />$ 705.00
<br />$
<br />705.00
<br />$ 705.00
<br />50%of Delta Dental Plan
<br />Dental Insurance- Pettee
<br />$ 267.00
<br />$ 3,703.00
<br />$
<br />$
<br />267.00
<br />2,481.00
<br />$ 267.00
<br />50%of Delta Dental Plan
<br />Worker's Compensation - Anderson
<br />Worker's Compensation - Smith
<br />$ 3,814.00
<br />$39,439/100*$9.67
<br />$ 3,544.00
<br />$ 2,241.00
<br />$ 3,651.00
<br />$ 3,198.00
<br />$
<br />_$37,753/100*$9.67
<br />$33,071/100*$9.67
<br />Exemptfrom work comp
<br />Worker's Compensation - Pettee
<br />$ 2,971.00
<br />$ 2,248.00
<br />Worker's Compensation - StandbyPay
<br />Supplies:
<br />$ $
<br />$ 42,448.00 $ 38,707.00
<br />$ 44,345.00
<br />Cleaning Supplies
<br />$ 1,940.00
<br />$ 2,656.00
<br />$ 10,000.00
<br />$ 2,040.00
<br />$ 2,200.00
<br />$ _ 2,565.00
<br />$ 10,000.00
<br />$ 1,140.00
<br />li
<br />j _
<br />$ 2,460.00
<br />$ 3,200.00
<br />$ 10,000.00
<br />$ 1,200.00
<br />$ 16,860.00
<br />$ 30,000.00
<br />$ 22,000.00
<br />$ 40,ODO.00
<br />$ 5:000.00
<br />$ 3,000.00
<br />$ 300.00
<br />$ 4,400.00
<br />_ $ 104,700.00
<br />$ 5,000.00
<br />Catchall account for rags, first aid supplies....
<br />Water Department's share of bulk fuel purchases
<br />Shop tools, shelving, cold -weather gear...
<br />$100/month _
<br />_
<br />Lubricants, shop supplies, vactor maint....
<br />j Budget one pump replacement per year
<br />. Budget for one rebuild per year
<br />Non-specific building repairs
<br />$250/month
<br />Public works site and lift stations
<br />Performed by NAC Mechanical Inc
<br />Annual costs ofsoftware module
<br />Motor Fuels
<br />Small Tools & Equipment
<br />Uniforms
<br />Repairs & Maintenance:
<br />$ 16,636.00 $ 15,905.00
<br />_
<br />$ 57,890.00 $ 25,000.00
<br />Repairs & Maintenance
<br />Submersible Pumps for Lift Stations
<br />- Lift Station Rebuilds
<br />$ 22,000.00
<br />$
<br />$ 40,000.00.E
<br />$
<br />Building Repair & Maintenance
<br />$ 5,OOD.00 .
<br />$ 3,000.00 I
<br />$ 300.00
<br />$ 4,400.00
<br />$ 5,000.00
<br />$ 3,OOO.00
<br />Septic System Pumping
<br />Weed Control
<br />$ 236.00
<br />$ 4,400.00
<br />- HVAC Repairs _ _ _
<br />Professional Services:
<br />Data Collection & Maintenance Tracking (WSB)
<br />Building Cleaning Services (contract)
<br />$ 132,590.00 _
<br />$ -
<br />$ 37,636.00
<br />$ 5,000.00
<br />$ 2,100.00 I
<br />$ 2,004.00
<br />$ 2,100.00
<br />$175/month
<br />Random Personnel Testing
<br />$ -
<br />$ 100.00
<br />$ 100.00
<br />New personnel policy provision
<br />Scada System Troubleshooting
<br />$ 650.00
<br />$ 1,515.00
<br />$ 4,265.00
<br />$ 650.00
<br />$ 1,544.00
<br />$ 9,298.00
<br />$ 650.00
<br />$ 1,575.00
<br />Contingency budget
<br />Safety Training
<br />OSHA required safety training
<br />_
<br />$ 9,425.00
<br />Sewage Treatment:
<br />Increase of $71,749 or 12.79%
<br />Metro Council Environmental Services
<br />Utilities:
<br />$ 558,801.00
<br />$ 558,801.00
<br />$ 630,280.00
<br />$ 558,801.00
<br />$ 558,801.00
<br />$ 630,280.00
<br />Electricity:
<br />5% Increase above projected _
<br />5% Increase above projected
<br />-Lift Stations
<br />$ 9,415.00 5,159.00
<br />$ 5,236.00
<br />PWFacility
<br />$ 4,220.00
<br />$ 13,635.00
<br />$ 2,823.00
<br />$ 4,220.00. I
<br />_$
<br />$ 4,055.00
<br />$ 9,214.00
<br />$ 3,033.00
<br />$ 3,680.00
<br />$ 4,260.00
<br />_ $ 9,496.00
<br />$ 3,185.00
<br />$ 4,200.00
<br />Gas for Public Works Facility
<br />Refuse Disposal
<br />Communications:
<br />Cellular Phone Charges
<br />Business Internet - Comcast (upgraded speed)
<br />Line 651 653-1154 583 Scads
<br />5% Increase above projected
<br />Gene's Disposal _
<br />$180/month ~
<br />300mb service (up from tomb service)
<br />$30/month
<br />_
<br />Sewer school, exams, and certificate renewals
<br />American Public Works Assn
<br />Minnesota Rural Water Assn _
<br />$ 20,678.00
<br />$ 15,927.00
<br />$ 16,881.00
<br />$ 2,142.00
<br />$ 1,950.00
<br />$ 360.00
<br />$ 3,600.00
<br />.$ 2,160.00
<br />_ _$ 2,100.00
<br />$ 360.00
<br />$ 2,000.00
<br />_
<br />$ 360.00
<br />$ 5,960.00
<br />$ 4,452.00
<br />$ 4,620.00
<br />Travel & Training:
<br />$ 4,300.00 _.
<br />$ 4,300.00
<br />I_
<br />$ 85.00
<br />$ -
<br />$ 4,802.00
<br />$ 4,802.00
<br />1 $ 85.00
<br />$ 138138 00
<br />_
<br />$ 5,000.00
<br />$ 5,000.00
<br />$ 85.00
<br />Training Classes
<br />_
<br />Professional Memberships:
<br />Dues
<br />Dues
<br />$ 150.00
<br />Administration
<br />Wages: - - -
<br />$ 85.00
<br />-
<br />$ 40,889.00
<br />$ 30,489.00
<br />$ 1,000.00
<br />$ 10,874.00
<br />$ 1,000.00
<br />$ 223.00
<br />$ 40,889.00
<br />$ 30,489.00
<br />$ 1,000.00
<br />$ 10,874.00
<br />$ 1,000.00
<br />$ 235.00
<br />- -
<br />$ 43,372.00
<br />$ 32,829.00
<br />$ 1,000.00
<br />$_ 11,704.00
<br />$ 1,000.00
<br />City Administrator
<br />25%of Pay Grade 14 Step 4
<br />Billing Clerk
<br />50%of Pay Grade 5 Maximum
<br />Compensated Absences
<br />I
<br />5_0%of increase in PTO Bank
<br />25%of Pay Grade 4 Minimum Step 1
<br />25%of increase in PTO Bank
<br />Administrative Assistant
<br />Com: ensated Absences
<br />Page 4
<br />
|