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