|
2020 Water and Sewer Business Pro -Forma
<br />ACCOUNT
<br />2019
<br />2019
<br />2020
<br />DESCRIPTION
<br />Adopted
<br />Projected
<br />Proposed
<br />Notes
<br />$ 84,252.00
<br />$ 84,252.00
<br />$ 89,905.00
<br />Fringe Benefits:
<br />Pera - City Administrator
<br />$ 3,067.00
<br />$ 3,067.00
<br />$ 3,253.00
<br />$ 2,462.00
<br />$ 878.00
<br />$ 2,689.00
<br />$ 2,035.00
<br />$ 726.00
<br />$ 629.00
<br />7.5%of Salary
<br />7.5%of Salary
<br />7.5%of Salary
<br />6.2%of5alary
<br />6.2%%of Salary
<br />6.2%ofSalary
<br />1.45%of Salary
<br />Pera - Billing Clerk
<br />$ 2,287.00
<br />$ 2,287.00
<br />Pera - Administrative Assistant
<br />$ 816.00
<br />$ 816.00
<br />$ 2,050.00
<br />$ 1,890.00
<br />I
<br />Fica-CityAdministrator
<br />$ 2,050.00
<br />Fica - Billing Clerk
<br />$ 1,890.00
<br />Fica-Administrative Assistant
<br />$ 674.00
<br />$ 674.00
<br />Medicare-CityAdministrator
<br />$ 593.00
<br />$ 593.00
<br />Medicare - Billing Clerk
<br />$ 442.00
<br />$ 442.00
<br />$ 476.00
<br />$ 170.00
<br />I $ 13,113.00
<br />1.45% of Salary
<br />1.45%ofSalary
<br />50%of HealthPartners High -Deductible Plan
<br />Medicare -Administrative Assistant
<br />$ 158.00
<br />$ 158.00
<br />Health Insurance- Billing Clerk
<br />$ 11,802.00
<br />$ 11,655.00
<br />Health Insurance- Administrative Assistant
<br />$ 1,356.00
<br />$ 1,334.00
<br />$ 1,459.00
<br />25% of HealthPartners High -Deductible Plan
<br />Dental Insurance - Billing Clerk
<br />$ 517.00
<br />$ 117.10
<br />$ 517.00
<br />$ 134.00
<br />$ 236.00 _
<br />$ 84.00
<br />$ 28,861.00
<br />_
<br />$ 4,000.00
<br />50%of Delta Dental Plan
<br />25% of Delta Dental Plan
<br />$32,829/100-$0.72
<br />$11,704/100*$0.72 _
<br />_
<br />Utility bills and envelopes, standard supplies
<br />Dental Insurance-AdministrativeAssistant
<br />$ 134.00_
<br />$ 134.00
<br />Worker's Compensation - Billing Clerk
<br />$ 220.00
<br />$ 1- 4.00
<br />Worker'sCompensation- AdministrativeAssistant
<br />$ 78.00
<br />$ 81.00
<br />.$ 26,084.00
<br />I
<br />_ $ 25,862.00
<br />Supplies:
<br />Office Supplies
<br />$ 3,976.00
<br />$ 3,976.00
<br />- Utility Bill Printing & Mailing (outsourced)
<br />$ 975.00
<br />$ 975.00
<br />$ 1,000.00
<br />Outsourced to Graphic Resources Inc
<br />Pervasive Software Upgrade
<br />$ 140.00
<br />$ 140.00
<br />$ 150.00
<br />Needed to operate FunclBalance Software
<br />Desktop Computer Systems
<br />�$ 1,000.00
<br />$ 1,000.00
<br />$ 1,000.00
<br />equipment replacement
<br />$ 6,091.00
<br />$ 6,091.00
<br />_Electronic
<br />$ 6,150.00
<br />Breakroom Supplies
<br />$ 750.00
<br />$ 750.00
<br />$ 750.00
<br />Includes supplies for Rice lake Centre
<br />$ 6,841.00
<br />$ 6,841.00
<br />$ 6,900.00
<br />_
<br />_
<br />Professional Services:
<br />Audit
<br />$ 7,100.00
<br />$ 7,108.00
<br />_
<br />$ 7,300.00
<br />Annual audit fees f
<br />Accounting Services
<br />$ 2,9Do.00
<br />$ 2,867.00
<br />$ 3,100.00
<br />Implement GASB pronouncements
<br />$ _10_,00_0.00_
<br />_
<br />-$ 9,975.00
<br />$ 10,400.00
<br />IT Support Services:
<br />Computer Technical Support- Metro Inet
<br />$ 3,950.00
<br />$ 3,589.00
<br />$ 3,950.00
<br />IT services from City of Roseville
<br />Replace WiFi Access Points (PW Facility)
<br />$ -
<br />$ 191.00
<br />$ 200.00
<br />Replace WiFi Access Points (PW facility)
<br />Telephone Support - City of Roseville
<br />$ 363.00
<br />$ 357.00
<br />$ 363.00
<br />IT services from City of Roseville
<br />$ 4,313.00
<br />$ 4,137.00
<br />$ 4,513.00
<br />_
<br />Contractual Maintenance:
<br />_
<br />_
<br />Software Maintenance Agreements - Fund Balance
<br />$ 736.00
<br />$ 737.00
<br />$ 750.00
<br />Software upgrades & troubleshooting
<br />Software Maintenance Agreements - US Scan
<br />$ 736.00
<br />$ 125.00
<br />$ 150.01)
<br />Software upgrades & troubleshooting
<br />Software Maintenance Agreements - Scada
<br />$ 125.00
<br />$ 125.00
<br />$ 125.00
<br />Water level alarm system -towers and wells
<br />Software Maintenance Agreements - Sensus
<br />$ 1,100.00
<br />$ 1,150.00
<br />$ 1,200.00
<br />Meter reading software upgrades
<br />$ 2,697.00
<br />$ 2,137.00
<br />$ 2,225.00
<br />Communications:
<br />Postage
<br />$ 3,700.00
<br />1
<br />$ 3,950.00
<br />$ 4,100.00 .
<br />Mail utility bills, rate schedules, water samples...
<br />$ 3,700.00
<br />$ 3,950.00
<br />_$ 4,100.00
<br />Insurance:
<br />Liability
<br />$ 16,972.00
<br />_
<br />$ 16,527.00
<br />$ 18,000.00
<br />Assumes no year-end dividends
<br />Property _
<br />$ 12,357.00
<br />$ 5,253.00
<br />_ _
<br />$ 5,821.00 . _Assumes
<br />no year-end dividends
<br />Automobile
<br />$ 475.00
<br />$ 1,151.00
<br />$ 1,694.00
<br />Assumes no year-end dividends
<br />$ 29,804.00
<br />$ 22,931.00
<br />5,15 00
<br />-
<br />Rentals:
<br />I
<br />Copier Lease Payments
<br />$ 493.00
<br />$ 493.00
<br />$ 493.00
<br />Ricoh USA copier
<br />Copier Overage Charges
<br />$ 50.00
<br />$ 143.00
<br />$ 150.00
<br />Copies in excess of allowed amount
<br />$ 543.00
<br />$ 636.00
<br />$ 643.00
<br />Miscellaneous:
<br />T�
<br />Gopher State Service Charges
<br />$ 1,535.00
<br />_
<br />$ 1,800.00
<br />.
<br />$ 1,850.00 _Centralized
<br />locate reporting service (required)
<br />Truck Ucense Tabs
<br />$ -
<br />$ -
<br />$ 100.00
<br />Every two years
<br />Discharge Permit - VactorTruck
<br />$ 425.00
<br />$ 425.00
<br />$ 425.00
<br />Another ridiculous fee
<br />$ 1,960.00
<br />$ 2,225.00
<br />$ 2,375.00
<br />_
<br />Assessment Collection Fees
<br />$ 1,o0o.00
<br />$ 818.00
<br />!
<br />$ 1,000.00
<br />_
<br />Charged by Washington County
<br />$ 2,960.00
<br />$ 3,043.00
<br />$ 3,375.00
<br />Depreciation
<br />_
<br />Estimated Depreciation _ _ _
<br />$ 89,247.00
<br />$ 89,247.00
<br />$ 89,247.00 _Depreciation
<br />on city installed assets
<br />Estimated Contributed Depreciation
<br />$ 202,713.00
<br />$ 202,713.00
<br />$ 202,713.00 _
<br />Depreciation on developer installed assets
<br />$ 291,960.00
<br />$ 291,960.00
<br />$ 291,960.00
<br />TOTAL SEWER EXPENSES
<br />$ 1,368,526.00
<br />$ 1,261,084.00
<br />$ 1,425,206.00
<br />NETINCOME-SEWER
<br />$ 53,653.00
<br />$ 185,315.13
<br />$ 51,646.32
<br />Sewer Fund Share of PW Facility Bonds
<br />$ 54,314.00
<br />$ 54,314.00
<br />$ 55,000.00
<br />$ (661.00)
<br />$ 131,001.13.
<br />$ (3,353.68)
<br />WATER & SEWER NET INCOME
<br />$ 189,971.00
<br />$ 269,181.28
<br />$ 52,728.58 _
<br />Wellhead Protection Grant (State of Minnesota)
<br />$ -
<br />$ 9,056.00
<br />$ -
<br />One-time grant
<br />Returned Check Fees
<br />$ 540.00
<br />$ 540.00
<br />$ 540.00
<br />18fees @ $30
<br />5 ecial Assessments
<br />$ 825.00
<br />$ 825.00
<br />I
<br />$ 825.00
<br />$5 fee p er sp ecial assessment 165 accounts)
<br />Page 5
<br />
|