|
2020 Water and Sewer Business Pro -Forma
<br />ACCOUNT
<br />DESCRIPTION
<br />Water Brochures
<br />Professional Services:
<br />Audit
<br />Accounting 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 />IT Support Services:
<br />Computer Technical Support- Metro Inet
<br />Replace WiFi Access Points (PW facility)
<br />Telephone Support - City of Roseville
<br />Insurance:
<br />Liability
<br />Property _
<br />Automobile
<br />Lease
<br />Miscellaneous:
<br />Water Appropriation Fees (DNR)
<br />Gopher State Service Charges
<br />Truck License Tabs
<br />Assessment Collection Fees
<br />Depreciation
<br />Estimated Depreciation
<br />Estimated Contributed Depreciation
<br />TOTAL WATER EXPENSES
<br />NET INCOME - WATER
<br />Water Fund Share of PW Facility Bonds
<br />SEWER REVENUES:
<br />Sewer Billings
<br />Residential
<br />Multi Famili
<br />Commercial
<br />Industrial
<br />- Educational
<br />Penalties
<br />SEWER REVENUES
<br />SEWER EXPENSES:
<br />Operation & Maintenance
<br />Wages:
<br />Public Works Director - Anderson
<br />Compensated Absences - Anderson
<br />Maintenance Worker - Smith
<br />Compensated Absences - Smith
<br />Maintenance Worker- Pettee
<br />Compensated Absences - Pettee
<br />In Lieu of Health Insurance
<br />Standby Pay
<br />Overtime (104 hours at overtime rate) - Smith
<br />Overtime (104 hours at overtime rate) - Pettee
<br />Fringe Benefits:
<br />2019 2019 2020
<br />Adopted Projected _ Proposed Notes
<br />�,$
<br />$ 50.00 : 34.00 $ 50.00 Department of Health requirement
<br />$ 6,891.00 $ 6,875.00 $ 6,950.00
<br />$ 7,100.00 $ 7,108.00 $ 7,300.00 Annual auditfees
<br />$ 2,900.00 $ 2,867.00 $ 3,100.00 Implement GASB pronouncements
<br />$ 6,000.00 $ 1,000.OD _} $ 11,000.00 WBL Restoration Litigation
<br />$ 1,000.00 . $ 1,000.00 $ 1,000.00 . Miscellaneous Water Issues
<br />$ 17,000.00
<br />$ 11,975.00
<br />_�
<br />$ 12,400.00
<br />$ 736.00
<br />1
<br />$ 737.00
<br />$ 750.00
<br />$ 150.00
<br />Software upgrades & troubleshooting
<br />Software upgrades & troubleshooting
<br />$
<br />$ 125.00
<br />$ 125.00
<br />$ 125.00
<br />Water level alarm system -towers and wells
<br />$ 125.00
<br />$ 1,300.00
<br />$ 1,150.00
<br />$ 1,200.00
<br />reading software upgrades
<br />_Meter
<br />$ 1,961.00 $ 2,137.00 $ 2,225.00
<br />1
<br />$ 3,7DO.00 $ 3,950.00 $ 4,100.00 Mail utility bills, rate schedules, watersamples...
<br />$ 3,7DO.00 $ 3,950.00 $ 4,100.00
<br />$ 3,950.00 $ 3,589.00 $ 3,950.00 IT services from City of Roseville
<br />$ - $ 191.001 1 $ 200.00 Replace WiFi Access Points (PW facility)
<br />$ 363.00 $ 357.00 $ 363.00 IT services from City of Roseville
<br />$ 4,313.00
<br />$ 4,137.00 $ 4,513.00
<br />$ 16,527.00 l $ 18,000.00 Assumes no year-end dividends
<br />$ 16,972.00
<br />$ 12,357.00
<br />$ 10,834.00
<br />$ 12,357.00 Assumes no year-end dividends
<br />$ 475.00 Assumes no year-end dividends
<br />$ 30,832.00
<br />$ 493.00 Ricoh USA copier
<br />$ 150.00 Copies in excess of allowed amount
<br />$ 643.00
<br />$ 475.00
<br />$ 207.00
<br />$ 29,804.00
<br />$ 27,568.00
<br />$ 493.00
<br />$ 493.00
<br />$ 50.00
<br />$ 143.00
<br />$ 543.00 $ 636.00
<br />$ 6,166.00 $ 5,257.00
<br />$ 6,166.00 Water appropriation permit fees _
<br />$ 1,535.00 $ 1,900.00
<br />$ 1,950.00 Centralized locate reporting service (required)
<br />$ - $ -
<br />$ 100.00.1 Every two years
<br />$ 8,216.00
<br />$ 7,701.00 $ 7,157.00
<br />$ 1,000.00 $ 818.00
<br />$ 1,000.00 J
<br />Charged by Washington County
<br />$ 8,701.00 $ 7,975.00 $ 9,216.00
<br />$ 242,314.00 $ 232,341.00 $ 317,780.00_ Depreciation on city installed assets
<br />$ 179,468.00 $ 179,468.00 $ 179,468.00 Depreciation on developer installed assets
<br />$ 421,782.00 $ 411,809.00 $ 497,248.001 1
<br />$ 1,172,053.00 $ 1,068,469.00 $ 1,189,055.00.
<br />$
<br />136,318.00
<br />$
<br />83,866.15
<br />$
<br />1,082.
<br />$
<br />54,314.00
<br />$
<br />54,314.00
<br />$
<br />55,000.
<br />$
<br />82,004.00
<br />$
<br />29,552.15
<br />$
<br />(53,917.
<br />$
<br />908,399.00
<br />$
<br />928,452.13
<br />1 $
<br />950,638.
<br />$
<br />427,628.00
<br />$
<br />429,707.89
<br />$
<br />435,423.
<br />$
<br />41,484.00
<br />$
<br />40,755.29
<br />$
<br />42,033.
<br />$
<br />23,662.00 .
<br />$
<br />25,610.25
<br />! j $
<br />26,286.
<br />bonds and new issue in 2020
<br />__$
<br />8,012.00 :
<br />$
<br />7,842.15 ;
<br />1$
<br />13,138.151
<br />�Base Fees = $1,233,612
<br />FlowFees = $ 228,907
<br />$
<br />1,409,185.00
<br />$
<br />1,432,367.71
<br />$
<br />1,462,519.32
<br />Total Fees = $1,462,519
<br />$
<br />12,994.00
<br />$
<br />14,031.42
<br />$
<br />14,333.00
<br />Approximately 0.98% of sewer billings
<br />$
<br />1,422,179.00
<br />$
<br />1,446,399.13
<br />$
<br />1,476,852.32
<br />I_
<br />$ 38,290.00
<br />$ 38,290.00
<br />$ 39,439.00
<br />33% of Pay G rade 10 Maximum
<br />$ 1,000.00
<br />$ 1,000.00
<br />$ 1,000.00 1
<br />133%of increase in PTO Bank
<br />$ 31,873.00
<br />$ 31,873.00
<br />$ 32,829.00
<br />50%of Pay Grade 5 Maximum
<br />$ 1,000.00
<br />$ 26,717.00
<br />$ 1,000.00
<br />$ 2,880.00
<br />$ 1,060.00
<br />$ 1,0DD.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 />50%of increase in PTO Bank
<br />50%of Pay Grade 5 Step 3
<br />5D%of increase in PTO Bank
<br />$240/month for waived coverage
<br />50% of $320/week
<br />i 104 hours (10%) @ overtime rate
<br />11D4 hours (10%) @ overtime rate
<br />_
<br />$ 26,717.00
<br />$ 1,000.00
<br />$ 2,880.00
<br />$ 8,060.00
<br />$ 8,060.00
<br />$ 4,781.00
<br />$ 4,781.00
<br />$ 4,008.00
<br />$ 119,609.00
<br />$ 4,008.00
<br />$ 119,609.00
<br />$ 124,463.00
<br />Page 3
<br />
|