|
2020 Water and Sewer Business Pro -Forma
<br />ACCOUNT
<br />DESCRIPTION
<br />Water Brochures
<br />Professional Services:
<br />Audit
<br />Accou nti ng Services
<br />Legal Fees - WBL Restoration Litigation
<br />Legal Fees - Miscellaneous Issue
<br />Contractual Maintenance:
<br />Software Maintenance Agreements - Fund Balance
<br />Software Maintenance Agreements - UB Scan
<br />Software Maintenance Agreements - Scada
<br />Software Maintenance Agreements - Sensus
<br />Communications:
<br />Postage _ _
<br />IT Support Services:
<br />2019
<br />Adopted
<br />$ 50.00
<br />$ 6,891.00
<br />1
<br />$ 7,100.00
<br />$ 2,900.00
<br />$_ 6,000.00
<br />$ 1,000.00
<br />$ 17,000.00
<br />_
<br />$ 736.00
<br />$ -
<br />$ 125.00
<br />$ 1,100.00
<br />$ 1,961.00.
<br />$ 3,700.00
<br />$ 3,700.00.
<br />.
<br />2019
<br />Projected
<br />$ 34.00
<br />$ 6,875.00
<br />$ 7,108.00
<br />$ 2,867.00
<br />$ 1,000.00
<br />$ 1,000.00
<br />$ 11,975.00
<br />$ 737.00
<br />$ 125.00
<br />$ 125.00
<br />$ 1,150.00
<br />$ 2,137.00
<br />_ $ 3,950.00
<br />( $ 3,950.00
<br />_
<br />_
<br />2020
<br />Proposed Notes
<br />$ 50.00 Department of Health requirement
<br />$ 6,950.00_
<br />$ 7,300.00 ,_ iAnnual audit fees
<br />$ 3,100.00 'Implement GASB pronouncements
<br />$ 1,000.00 WBL Restoration Litigation
<br />$ 1,000.00 Miscellaneous Water Issues
<br />$ 12,400.00
<br />$ 750.00 Software upgrades & troubleshooting _
<br />$ 150.00 Software upgrades & troubleshooting
<br />$ 125.00 Water level alarm system - towers and wells
<br />$ 1,200.00 Meter reading software upgrades
<br />$ 2,225.00I
<br />$ 4,100.00 Mail utility bills, rate schedules, water samples...
<br />$ 4,100.00 ,
<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 />Replace Win Access Points (PW facility)
<br />Telephone Support - City of Roseville
<br />$ -
<br />$ 191.00
<br />$ 200.00
<br />363.00
<br />_
<br />. $ 363.00
<br />_
<br />$ 357.00_
<br />IT services from City of Roseville
<br />$ 4,313.00
<br />$ 4,137.00
<br />$ 4,513.00
<br />Insurance:
<br />Liability
<br />$ 16,972.001
<br />$ 16,527.00
<br />$ 18,000.00
<br />$ 12,357.00
<br />$ 475.00
<br />f $ 30,832.00
<br />—+I
<br />$ 493.00
<br />$ 150.00
<br />Assumes no year-end dividends
<br />Assumes no year-end dividends
<br />Assumes no year-end dividends _
<br />Ricoh USA copier
<br />Property
<br />$ 12,357.00
<br />$ 10,834.00
<br />Automobile
<br />$ 475.00
<br />$ 207.00
<br />$ 29,804.00 $ 27,568.00
<br />$ 493.00 $ 493.00
<br />$ 50.00 $ 143.00
<br />Rentals:
<br />Copier Lease Payments
<br />Copier Overage Charges
<br />Copies in excess of allowed amount
<br />$ 543.00
<br />$ 636.00
<br />$ 643.00
<br />_$ 6,166.00_
<br />$ 1,950.00
<br />$ 100.00
<br />$ 8,216.00
<br />$ 1,000.00
<br />$ 9,216.00
<br />$ 317,780.00
<br />$ 179,468.00
<br />Water appropriation permit fees
<br />Centralized locate reporting service (required)
<br />_ Every two years
<br />Charged by Washington County
<br />Depreciation on city installed assets
<br />Depreciation on developer installed assets
<br />Miscellaneous:
<br />$ 6,166.00 $ _ 5,257.00
<br />$ 1,535.00 $ 1,900.00
<br />Water Appropriation Fees (DNR)
<br />Gopher State Service Charges _
<br />Truck License Tabs
<br />Assessment Collection Fees
<br />Depreciation
<br />$ - $
<br />$ 7,701.00 $ 7,157.00
<br />$ 1,000.00 $ 818.00
<br />$ 8,701.00 $ 7,975.00
<br />Estimated Depreciation -
<br />Estimated Contributed Depreciation
<br />_
<br />TOTAL WATER EXPENSES
<br />$ 242,314.00
<br />$ 179,468.00
<br />$ 421,782.00
<br />_
<br />$ 232,341.00
<br />$ 179,468.00
<br />$ 4�
<br />f $ 497,248.00 ]
<br />$ 1,172,053.00 $ 1,068,469.00
<br />$ 1,189,055.00
<br />NET INCOME - WATER
<br />Water Fund Share of PW Facility Bonds
<br />SEWER REVENUES:
<br />$ 136,318.D0
<br />$ 54,314.00
<br />$ 82,004.00
<br />$ 83,866.15
<br />$ 54,314.00
<br />r
<br />$_ 1,082.261
<br />$ 55,000.00
<br />$ (53,917.74)
<br />_
<br />Existing bonds and new issue in 2020
<br />$ 29,552.15
<br />_
<br />_
<br />Sewer Billings: ]
<br />- Residential
<br />$ 908,399.DO
<br />$ 928,452.13
<br />$ 950,638.30
<br />Multi Family
<br />$ 427,628.00
<br />$ 429,707.89
<br />$ 40,755.29:
<br />$ 435,423.24
<br />$ 42,033.38
<br />Commercial $ 41,484.00
<br />Base Fees = $1,233,612
<br />(Flow Fees = $ 228,907
<br />(Total Fees = $1,462,519
<br />Approximately 0.98% of sewer billings
<br />_
<br />Industrial [ $ 23,662.00
<br />$ 25,610.25
<br />$ 7,842.15
<br />$ 1,432,367.71
<br />$ 14,031.42
<br />$ 1,446,399.13
<br />$ 26,286.25
<br />$ 8,138.15
<br />$ 1,462,519.32
<br />$ 14,333.00
<br />$ 1,476,852.32
<br />- Educational — — _ $ 8,012.00
<br />Sewer Billings (Revenue Requirement) $ 1,409,185.00
<br />_ewer Penalties $ 12,994.001
<br />TOTAL SEWER REVENUES $ 1,422,179.00
<br />_
<br />33%of Pay Grade 10 Maximum
<br />.33%of increase in PTO Bank
<br />SEWER EXPENSES:
<br />Operation & Maintenance
<br />Wages:
<br />Public Works Director - Anderson
<br />$ 38,290.00
<br />$ 38,290.00
<br />$ 39,439.00
<br />Compensated Absences - Anderson
<br />$ 1,000.00
<br />$ 1,000.00
<br />.
<br />$ 1,000.00
<br />Maintenance Worker - Smith
<br />Compensated Absences - Smith
<br />Maintenance Worker- Pettee
<br />Compensated Absences - Pettee
<br />$ 31,873.00
<br />$ 31,873.00
<br />$ 32,829.00
<br />$ 1,000.00
<br />$ 28,757.00
<br />$ 1,000.00
<br />$ 2,880.00
<br />$ 8,320.00
<br />$ 4,924.00
<br />$ 4,314.00
<br />$ 1,463.00
<br />24
<br />50% of Pay Grade 5 Maximum
<br />50%of increase in PTO Bank
<br />50%of Pay Grade 5 Step 3
<br />50%of increase in PTO Bank
<br />$240/month for waived coverage
<br />50%of $320/week
<br />104 hours (10%) @ overtime rate
<br />104 hours (10%) @ overtime rate
<br />$ 1,000.00
<br />$ 1,000.00
<br />$ 26,717.00
<br />$ 1,000.00
<br />$ 26,717.00
<br />$ 1,000.00
<br />In Ueu of Health Insurance
<br />$ 2,880.00
<br />$ 2,880.00
<br />Standby Pay _
<br />Overtime (104 hours at overtime rate) - Smith
<br />Overtime (104 hours at overtime rate) - Pettee
<br />$ 8,060.00 _$_ 8,060.00 _
<br />$ 4,781.00 $ 4,781.00
<br />$ 4,008.00 $ 4,OD8.00
<br />$ 119,609.00 $ 119,609.00
<br />,Fringe Benefits:
<br />_
<br />Page 3
<br />
|