|
2019 Water and Sewer Business Pro -Forma
<br />ACCOUNT
<br />2018
<br />Estimated
<br />2019
<br />DESCRIPTION
<br />12/3112018
<br />_
<br />Notes
<br />Breakroom Supplies
<br />$
<br />750.00
<br />$
<br />750.00
<br />$
<br />750.00
<br />Includes supplies for Rice Lake Centre
<br />Water Brochures
<br />$
<br />50.00
<br />$
<br />27.00
<br />$
<br />50.00
<br />Department of Health requirement
<br />$
<br />3,800.00
<br />$
<br />8,388.06
<br />$
<br />6,891.00
<br />Professional Services:
<br />..^.udit
<br />$
<br />6,900.00
<br />$
<br />6,900.00
<br />$
<br />7,100.00
<br />Annual audit fees
<br />Accounting Services
<br />$
<br />2,600.00
<br />$
<br />2,733.00
<br />$
<br />2,900.00
<br />Implement GASB pronouncements
<br />Legal Fees - WBLRestorationLitigation
<br />$
<br />2,000.00
<br />$
<br />18,000.00
<br />$
<br />6,000.00
<br />Prepareamicusbrief- appealdistrictcourtorder
<br />Legal Fees - DNR Permit Requirements
<br />$
<br />$
<br />1,000.00
<br />$
<br />1,000.00
<br />Appeal DNR permit requirements
<br />Employment Testing
<br />$
<br />$
<br />70.00
<br />$
<br />AdminAsstand PW Worker
<br />$
<br />11,500.00
<br />$
<br />28,703.00
<br />$
<br />17,000.00
<br />Contractual Maintenance:
<br />Software Maintenance Agreements - Fund Balance
<br />$
<br />669.00
<br />$
<br />702.00
<br />$
<br />736.00
<br />Software upgrades & troubleshooting
<br />Software Maintenance Agreements - Scada
<br />$
<br />-
<br />$
<br />125.00
<br />$
<br />125.00
<br />Water level alarm system - towers and wells
<br />Software Maintenance Agreements - Sensus
<br />$
<br />1,100.00
<br />$
<br />1,100.00
<br />$
<br />1400.00_
<br />Meter reading software upgrades
<br />$
<br />1,769.00
<br />$
<br />1,927.00
<br />$
<br />1,961.00
<br />Communications:
<br />Postage _
<br />$
<br />2,600.00
<br />$
<br />3,650.00
<br />$
<br />3,700.00
<br />Mail utility bills, rate schedules, water samples...
<br />. $
<br />2,600.00
<br />$
<br />3,650.00
<br />$
<br />3,700.00
<br />IT Support Services:
<br />Computer Technical Support - Metrolnet
<br />$
<br />3,615.00
<br />$
<br />3,840.00
<br />$
<br />3,950.00
<br />IT services from City of Roseville
<br />Telephone Support - City of Roseville
<br />$
<br />360.00
<br />$
<br />353.00
<br />$
<br />363.00
<br />IT services from City of Roseville
<br />_
<br />$
<br />3,975.00
<br />$
<br />4,193.00
<br />$
<br />4,313.00
<br />Insurance:
<br />Liability
<br />$
<br />13,717.00
<br />$
<br />15,717.00
<br />$
<br />16,972.00
<br />Assumes no year-end dividends
<br />Property
<br />$
<br />7,959.00
<br />$
<br />10,158.00
<br />$
<br />12,357.00
<br />Assumes no year-end dividends
<br />Automobile
<br />$
<br />239.00
<br />$
<br />357.00
<br />$
<br />475.00
<br />Assumes no year-end dividends
<br />$
<br />21,915.00
<br />$
<br />26,232.00
<br />$
<br />29,804.00
<br />Rentals:
<br />Copier Lease Payments
<br />$
<br />500.00
<br />$
<br />493.00
<br />$
<br />493.00
<br />Ricoh USA copier
<br />Copier Overage Charges
<br />$
<br />50.00
<br />$
<br />50.00
<br />$
<br />50.00
<br />Copies in excess of allowed amount
<br />$
<br />550.00
<br />$
<br />543.00
<br />$
<br />543.00
<br />Miscellaneous:
<br />Water Appropriation Fees (DNR)
<br />$
<br />5,758.00
<br />$
<br />5,962.00
<br />$
<br />6,166.O0
<br />Water appropriation permit fees
<br />Gopher State Service Charges
<br />$
<br />1,800.00
<br />$
<br />1,443.00
<br />$
<br />1,535.00
<br />Centralized locate reporting service (required)
<br />Truck License Tabs
<br />$
<br />-
<br />$
<br />21.01)
<br />$
<br />-
<br />Every two years
<br />Pressure Vessel Registration Fees
<br />$
<br />$
<br />-
<br />$
<br />$
<br />7,558.00
<br />$
<br />7,426.00
<br />$
<br />7,701.00
<br />Assessment Collection Fees
<br />$
<br />1,000.00
<br />$
<br />822.00
<br />$
<br />1,000.00
<br />Charged by Washington County
<br />$
<br />8,558.00
<br />$
<br />8,248.00
<br />$
<br />8,701.00
<br />Depreciation
<br />Estimated Depreciation
<br />$
<br />230,070.00
<br />$
<br />231,835.00
<br />$
<br />242,314.00
<br />Depreciation on city installed assets
<br />Estimated Contributed Depreciation
<br />$
<br />147,085.00
<br />$
<br />173,563.00
<br />$
<br />179,468.00
<br />Depreciation on developer installed assets
<br />$
<br />377,155.00
<br />$
<br />405,398.00
<br />$
<br />421,782.00
<br />TOTAL WATER EXPENSES
<br />$
<br />1,103,716.00
<br />$
<br />1,096,178.96
<br />$
<br />1,172,053.00
<br />NET INCOME -WATER
<br />$
<br />214,233.00
<br />$
<br />190,227.04
<br />$
<br />143,013.00
<br />Water Fund Share of PW Facility Bonds
<br />$
<br />53,780.00
<br />$
<br />54,135.00
<br />$
<br />54,314.00
<br />$
<br />160,453.00
<br />$
<br />136,092.04
<br />$
<br />88,699.00
<br />SEWER REVENUES:
<br />Sewer Billings:
<br />-Residential _ _ _
<br />$
<br />789,195.00
<br />$
<br />820,319.00
<br />$
<br />886,839.00
<br />Multi Family
<br />$
<br />389,324.00
<br />$
<br />393,157.00
<br />$
<br />421,857.00
<br />Commercial
<br />$
<br />39,588.00
<br />$
<br />40,597.00
<br />$
<br />42,813.00
<br />- Industrial
<br />$
<br />19,568.00
<br />$
<br />22,358.00
<br />$
<br />23,534.00
<br />- Educational
<br />$
<br />4,736.00
<br />$
<br />6,876.00
<br />$
<br />8,052.00
<br />Base Fees = $1,178,496
<br />- Account Adjustments
<br />$
<br />-
<br />$
<br />$
<br />Flow Fees = $ 204,599
<br />Sewer Billings (Revenue Requirement)
<br />$
<br />1,242,411.00
<br />$
<br />1,283,307.00
<br />$
<br />1,383,095.00
<br />Total Fees = $1,383,095
<br />5 ewer Penalties
<br />$
<br />11,420.00
<br />$
<br />12,731.00
<br />$
<br />12,994.00
<br />TOTAL SEWER REVENUES
<br />$
<br />1,253,831.00
<br />$
<br />1,296,038.00
<br />$
<br />1,396,089.00
<br />SEWER EXPENSES:
<br />Operation & Maintenance
<br />Wages:
<br />Public Works Director -Anderson
<br />$
<br />37,175.00
<br />$
<br />37,175.00
<br />$
<br />38,290.00
<br />33%of Pay Grade 10 Maximum
<br />Compensated Absences - Anderson
<br />$
<br />1,000.00
<br />$
<br />1,000.00
<br />$
<br />1,000.00
<br />Maintenance Worker - Smith
<br />$
<br />30,944.00
<br />$
<br />30,944.00
<br />$
<br />31,873.00
<br />50%of Pay Grade 5 Maximum
<br />Compensated Absences - Smith
<br />$
<br />1,000.00
<br />$
<br />1,000.00
<br />$
<br />1,000.00
<br />Maintenance Worker - Pettee
<br />$
<br />30,944.00
<br />$
<br />5,986.00
<br />$
<br />26,717.00
<br />50%of Pay Grade 5 Step 2 (start 11/12/18)
<br />Compensated Absences - Pettee
<br />$
<br />1,000.00
<br />$
<br />$
<br />1,000.00
<br />In Lieu of Health Insurance
<br />$
<br />2,550.00
<br />$
<br />2,550.00
<br />$
<br />2,880.00
<br />$240/month for waived coverage
<br />Standby Pay
<br />$
<br />7,800.00
<br />$
<br />7,800.00
<br />$
<br />8,060.00
<br />50%of $310/week
<br />Overtime (104 hours at overtime rate) - Smith
<br />$
<br />4,642.00
<br />$
<br />4,642.00
<br />$
<br />4,781.00
<br />104 hours (10%) @ overtime rate
<br />Overtime (104 hours at overtime rate) - Pettee
<br />$
<br />4,642.00
<br />$
<br />-
<br />$
<br />4,008.00
<br />104 hours (10%) @ overtime rate
<br />$
<br />121697.00
<br />$
<br />91,097.00
<br />$
<br />119 609.00
<br />Page 3
<br />
|