2019.11.04 CC Packet - Laserfiche WebLink

Home

2020 Water and Sewer Business Pro -Forma ACCOUNT DESCRIPTION Professional Services: Water Bacteria Testing Random Personnel Testing Building Cleaning Services (contract) Scada System Troubleshooting Safety Training Engineering - Non-specific engineering fees Engineering- Implement Well Head Prot. Plan 2019 2019 2020_ Adopted 1 Projected Proposed J$ - I !$ 100.00j $ $ 2,100.00 r $ _ 2,004.00 . $ $ 650.00 $ 650.00 $ _ $ 1,515.00 $ 1,544.00 $ $ 5,765.00 $ 5,798.00 . $ $ 12,500.00 $_ 1,669.00 $ $ 5,000.00 _ $ 7,820.00 $ $ 17,500.00 $ 9,489.00 $ _ �. Electricity: I Xcel - Public Works Facility $ 4,220.00 $ 4,055.00 Xcel - Well No. 2 & Tower No. 2 $ 4,485.00 $ 5,360.00 - Xcel - Well No. 3 Xcel - Tower No. 3 $ 7,520.00 $ 6,586.00 __ $ 3,280.D0 $ 3,353.00 Xcel - Well No. 4 $ 6,280.00 $ 7,840.00 Xcel - Well No. 5 $ 6,095.00 $ 4,353.00 - Xcel - Well No. 6 $ 4,046.00 $ 4,413.00 BHE - Well No. 2 (solar garden contract) $ _ 7,630.00 $ 6,608.00 - BHE - Well No. 3 (solar garden contract) $ 14,495.00 $ 12,529.OD BHE - Well No. 4 (solar garden contract) BHE - Well No. 5 (solar garden contract) BHE - Well No. 6 (solar garden contract) Gas for Public Works Facility Refuse Disposal Communications: ` Cellular Phone Charges $ $ $ $ $ $ $ $ 17,445.00 $ _ 14,693.00 13,255.00 $ 11,937.00 11,205.00 $ 9,845.00 99,856.00 $ 91,572.00 2,823.00 $ 3,033.00 4,220.00 $ 3,680.00 106,899.00 1 $ 98,285.0D 3,600.00 $ 2,142.00 Business Internet- Comcast (upgraded speed) $ 2,100.00 $ 1,950.00 $ 360.00 Line 651653-1154 583 Scada-360.00 Notes 500.00 $125/month _ 100.00 I New personnel policy provision 100.00 $175/month 650.00 1 Contingency budget $ 4,260.00 15% Increase above projected $ 5,630.00 5% Increase above projected $ 6,915.00 5% Increase above projected $ 3,520.00 15% Increase above projected 5% Increase above projected_ $ 8,235.00 $ 4,570.00 15% Increase above projected $ 4,635.00 5% Increase above projected $ 6,940.00 5% Increase above projected $ 13,155.00 5% Increase above projected $ 15,430.00 5% Increase above projected $ 12,535.00 5% Increase above projected $ 10,340.00 5% Increase above projected $ 96,165.00 _ $ 3,185.00 5% Increase above projected $ 4,200.00 1 Gene's Disposal $ 103,550.00 360.00 100mb service (up from 20mb $ 6,060.00 $ 4,452.00 $ 4,620.00 Travel & Training: Training Classes $ 1,650.00 $ 2,200.00 $ 2,200.00 Water school, exams, and certificate renewals $ 1,650.00 $ 2,200.00 $ 2,200.00 Professional Memberships: Dues $ 85.00 $ 85.00 1 $ 85.00 American Public Works Assn Dues $ $ 137.00 $ 150.00 Minnesota Rural Water Assn Dues $ - $ 315.00 $ 315.00. �American Waterworks Assn $ 85.00_ $ 537.00 $ 550.00 Administration _ _. _ . CityAdministrator ] $ 40,889.00 $ 40,889.00 43,372.0 $ 32,829.00 el4Step4 50%of Pay Grade 5 Maximum Billing Clerk $ 30,489.00 $ 30,489.00 Compensated Absences _ $ 1,000.00 $ 1,000.00 $ 1,000.00 _ 50% of increase in PTO Bank $ 10,874.00 $ 10,874.00 Administrative Assistant $ 11,704.00 25%of Pay Grade 4 Minimum Step 1 $ 1,000.00 $ 500.00 Compensated Absences - $ 500.00 25% ofincrease PTO Bank $ 84,252.00 $ 83,752.00 $ 89,405.00: _in Fringe Benefits: $ 3,253.00 7.5%of Salary Para - City Administrator $ 3,067.00 $ 3,067.00 Pera - Billing Clerk $ 2,287.00 $ 2,287.00 ( $ 2,462.00 7.5%of Salary Pera- AdministrativeAssistant $ 816.00 $ 816.00 - $ 878.00 _ 7.5%of Salary Fica-CityAdministrator $ 2,050.00 $ 2,050.00 $ 2,689.00 6.2%of Salary Fica - Billing Clerk _ l $ 1,890.00 $ 1,890.00 $ 2,035.00 6.2%of Salary Fica-Administrative Assistant $ 674.00 $ 674.00 $ 726.00 6.2%of Salary Medicare-CityAdministrator $ 593.00 $ 593.00 $ 629.00 1.45% of Salary Medicare - Billing Clerk $ 442.00 $ 442.D0 $ 476.00 1.45%of Salary Medicare -Administrative Assistant $ 158.00 $ 158.00 $ 170.00 1.45%of Salary iealth Insurance- Billing Clerk $ 11,802.00 $ 11,655.00 $ 13,113.00 50%of HealthPartners High -Deductible Plan Health Insurance -Administrative Assistant $ 1,356.00 $ 1,334.00 $ 1,459.00 25%of Health Partners High -Deductible Plan Dental Insurance - Billing Clerk _ Dental Insurance -Administrative Assistant $ 517.00 1 $ 134.60 t $ 517.00 $ 134.00 $ 517.00 $ 134.00 - $ 236.00 $ 84.00 $ 28,861.00 $ 4,000.00 $ 1,000.00 $ 150.00 $ 1,000.00 6,0.00 $15 50% of Delta Dental Plan 25%of Delta Dental Plan $32,829/100"$0.72 $11,704/100•$0.72 Utility bills and envelopes, standard supplie Outsourced to Graphic Resources Inc Needed to operate FundBalance Software Electronic equipment replacement Worker's Compensation - Billing Clerk $ 220.00 $ 164.00 . Worker's Compensation - Administrative Assistant $ 78.00 $ 81.00 $ 26,084.00 $ 25,862.00 Supplies: _ Office Supplies $ 3,976.00 $ 3,976.00 Utility Bill Printing & Mailing (outsourced) $ 975.00 $ 975.00 Pervasive Software Upgrade $ 140.00 i} $140.00 - Desktop Computer Systems 1_ $ 1,000 00 $ 1,000.00 $ 6,091.00 $ 750.00 _ $ 6,091.00 $ 750.00 Breakroom Supplies _ _ $ 750.00 1 Includes supplies for Rice lake Centre Page 2