|
2020 Water and Sewer Business Pro -Forma
<br />ACCOUNT 2019 2019 2020
<br />DESCRIPTION Adopted Projected Proposed Notes
<br />Pera-Anderson _ $ 2,872.00 $ 2,872.00 $ 2,958.001 7.5%of Salary
<br />Pera -Smith $ 2,749.00 $ 2,749.00 $ 2,831.00 7.5%of Salary & Overtime
<br />Pera - Pettee $ 2,304.00 f $ 2,304.00 $ 2,480.00 7.5%of Salary & Overtime
<br />Pera -Standby Pay $ 605.00 $ 605.00 $ 624.00 7.5%of Standby Pay
<br />F'ica - Anderson
<br />$ 2,374.00
<br />$ 2,374.00
<br />$ 2,445.00 6.2%of Salary
<br />Pica - Smith _ _
<br />Fica - Pettee
<br />$ 2,273.00
<br />$ 2,273.00
<br />$ 2,341.00 6.2%of Salary & Overtime
<br />$ 1,905.00
<br />$ 1,905.00
<br />$ 2,050.00 6.2%of Salary & Overtime
<br />- Standby Pay
<br />$ 500.00
<br />$ 500.00
<br />$ 516.00 6.2%of Standby Pay
<br />_Pica
<br />Medicare -Anderson
<br />j $ 555.00
<br />$ 555.00
<br />$ 572.00 1.45%of Salary
<br />$ 547.00 1.45%of Salary & Overtime
<br />$ 480.00 .1.45%ofSalary &Overtime
<br />Medicare - Smith
<br />$ 531.00
<br />$ 531.00
<br />Medicare -Pettee
<br />$ 446.00
<br />$ 446.00
<br />Medicare -Standby Pay
<br />$ 117.00
<br />$ 117.00
<br />$ 121.00
<br />1.4591.of Standby Pay
<br />Health Insurance - Anderson
<br />$ 8,480.00
<br />$ 8,347.00
<br />$ 9,198.00
<br />33%of Health Partners High -Deductible Plan
<br />Health Insurance - Pettee
<br />$ 5,077.00
<br />$ 4,717.00
<br />]
<br />$ 5,077.00
<br />50%of HealthPartners High-DeductibqPlan
<br />Dental Insurance - Anderson
<br />$ 470.00
<br />$ 470.00
<br />$ 470.00
<br />33% of Delta Dental Plan
<br />Dental Insurance -Smith
<br />$ 705.00
<br />$ 267.00
<br />$ 3,703.00
<br />$ 3,544.00
<br />$ 705.00
<br />$ 705.00
<br />50%of Delta Dental Plan
<br />Dental Insurance- Pettee
<br />$ 267.00
<br />J
<br />$ 267.00
<br />5094of Delta Dental Plan
<br />Worker's Compensation -Anderson
<br />Worker's Compensation -Smith
<br />Worker's Compensation - Pettee
<br />Worker's Compensation - Standby Pay
<br />$ 2,481.00
<br />$ 3,814.00
<br />$39,439/100*$9.67
<br />$ 2,242.00
<br />$ 2,248.00 1_
<br />$
<br />1
<br />$ 3,651.00
<br />$ 3,198.00
<br />$
<br />'$37,753/100*$9.67
<br />$33,071/100*$9.67
<br />Exempt from work comp
<br />$ 2,971.00
<br />$ -
<br />$ 42,448.00
<br />$ 38,707.00
<br />$ 44,345.00
<br />Supplies:
<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 />Cleaning Supplies
<br />$ 1,940.001
<br />1 $ 2,200.00
<br />$ 2,460.00
<br />Motor Fuels
<br />$ 2,656.00 1
<br />$ 2,565.00
<br />$ 3,200.00
<br />Small Tools & Equipment $ 10,OD0.00 I $ 10,000.00 $ 10,000.00
<br />Uniforms $ 2,040.00 $ 1,140.00 ^ $ 1,200.00
<br />$ 16,636.00 $ 15,905.00 $ 16,860.00
<br />Repairs & Maintenance:
<br />Repairs & Maintenance $ 57,890.00 $ 25,000.00 $ 30,000.00
<br />-Submersible Pumps for Lift Stations $ 22,000.00 l J_ $ - $ 22,000.00
<br />- Lift Station Rebuilds $ 40,000.00 $ - $ 40,000.00
<br />Building Repair & Maintenance $ 5,000.00 $ 5,000.00 $ 5,000.00
<br />-Septic System Pumping $ 3,000.00 $ 3,000.00 $ 3,000.00
<br />Weed Control $ 300.00 $ 236.00 $ 300.00
<br />- HVAC Repairs $ 4,400.00 $ 4,400.00 . $ 4,400.00
<br />$ 132,590.00 $ 37,636.00 $ 104,700.00
<br />Professional Services:
<br />Data Collection & Maintenance Tracking (WSB) . $ - $ 5,000.00 _. $ 5,000.00
<br />Lubricants, shop supplies, vactor maint....
<br />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 />_
<br />_
<br />Annual costs of software module
<br />_
<br />Building Cleaning Services (contract) $ 2,100.00
<br />$ 2,0D4.00 $ 2,100.00
<br />$175/month
<br />New personnel policy provision
<br />budget
<br />equired safety training
<br />Increase of $71,749 or 12,79%
<br />Random Personnel Testing $ -
<br />$ 100.00 $ 100.00
<br />$ 650.00 $ 650.00
<br />$ 1,544.00 $ 1,575.00
<br />$ 9,298.00 $ 9,425.00
<br />$ 558,801.00 $ 630,280.00
<br />$ 558,801.00 $ 630,280.00
<br />Scada System Troubleshooting $ 650.00
<br />Safety Training $ 1,515.00
<br />$ 4,265.00
<br />Sewage Treatment:
<br />Metro Council Environmental Services $ 558,801.00
<br />$ 558,801.00
<br />Utilities:
<br />Electricity:
<br />JFContinr8en,y
<br />_
<br />Lift Stations
<br />$ 9,415.00
<br />$ 5,159.00
<br />$ 51236.00
<br />5% Increase above projected
<br />- PW Facility
<br />$ 4,220.00
<br />_
<br />$ 4,055.00
<br />$ 4,260.00
<br />5% Increase above projected
<br />_
<br />5% Increase above projected
<br />Gene's Disposal
<br />$180/month
<br />$ 13,635.00
<br />$ 2,823.00
<br />$ 9,214.00
<br />$ 3,033.00
<br />$ 9,496.00
<br />Gas for Public Works Facility
<br />$ 3,185.00
<br />$ 4,200.00
<br />Refuse Disposal
<br />$ 4,220.00
<br />$ 3,680.00
<br />$ 20,678.00
<br />$ 15,927.00
<br />_
<br />$ 2,142.00
<br />$ 1,950.00
<br />$ 16,881.DD
<br />Communications:
<br />_
<br />$ 3,600.00
<br />$ 2,000.00
<br />_
<br />$ 2,160.DD
<br />Cellular Phone Charges
<br />Business Internet- Comcast (upgraded speed)
<br />Line 651653-1154 583 Scada
<br />$ 2,100,00
<br />100mb service (up from 20mb service)
<br />$30/month
<br />$ 360.00
<br />$ 360.00
<br />$ 360.00
<br />$ 5,960.00
<br />$ 4,452.00
<br />$ 4,802.00
<br />$ 4,620.00
<br />$ 5,000.00
<br />Travel & Training:
<br />$ 4,300.00
<br />$ 4,300.00
<br />Training Classes
<br />Professional Memberships:
<br />Dues
<br />Sewer school, exams, and certificate renewals
<br />$ 4,802.00
<br />$ 5,o0D.00
<br />$ 85.00
<br />$ 85.00
<br />_ $ 85.00
<br />$ 150.00
<br />$ 235.00
<br />American Public Works Assn
<br />Dues
<br />$
<br />$ 138.00
<br />$ 223.00
<br />Minnesota Rural Water Assn
<br />$ 85.00
<br />25% of Pay Grade 14 Step 4
<br />50%of Pay Grade 5 Maximum
<br />Administration
<br />Wages:
<br />City Administrator
<br />$ 40,889.00
<br />$ 40,889.00
<br />43,372.00
<br />Billing Clerk
<br />$ 30,489.00
<br />$ 30,489.00
<br />_$
<br />$ 32,829.00
<br />Compensated Absences
<br />$ 1,000.00 _
<br />$ 10,874.00
<br />$ 1,000.00
<br />$ 1,000.00
<br />$ 1,000.00
<br />50% of increase in PTO Bank
<br />Administrative Assistant
<br />Compensated Absences
<br />$ 10,874.00
<br />$ 11,704.00
<br />1 125%of Pay Grade 4 Minimum Step 1
<br />1 125% of increase in PTO Bank
<br />$ 1,000.00
<br />$ 1,000.00
<br />Page 4
<br />
|