|
2019 Water and Sewer Business Pro -Forma
<br />ACCOUNT
<br />DESCRIPTION
<br />2018 Estimated 2019
<br />12/3112018
<br />Notes
<br />Administrative Assistant
<br />$
<br />-
<br />$
<br />2,233.00
<br />$
<br />10,874.00
<br />25%of Pay Grade 4 Minimum (start 10/08/18)
<br />Compensated Absences
<br />$
<br />$
<br />-
<br />$
<br />1,000.00 .
<br />-- ..... .._....
<br />$
<br />67,231.00
<br />$
<br />68,760.00
<br />$
<br />84,252.00
<br />Fringe Benefits:
<br />(,era -City Administrator
<br />$
<br />2,647.00
<br />$
<br />2,790.00
<br />$
<br />3,067.00
<br />7.5%of Salary
<br />Pera - Billing Clerk
<br />$
<br />2,320.00
<br />$
<br />2,124.00
<br />$
<br />2,287.00
<br />7.5%of Salary
<br />Pera- AdministrativeAssistant
<br />$
<br />-
<br />$
<br />167.00
<br />$
<br />816.00
<br />7.5%of Salary
<br />Fica - City Administrator
<br />$
<br />1,972.00
<br />$
<br />1,990.00
<br />$
<br />2,050.00
<br />6.2%of Salary
<br />Fica - Billing Clerk
<br />$
<br />2,134.00
<br />$
<br />1,756.00
<br />$
<br />1,890.00
<br />6.2%of Salary
<br />Fica - AdministrativeAssistant
<br />$
<br />-
<br />$
<br />138.00
<br />$
<br />674.00
<br />6.2%of Salary
<br />Medicare - City Administrator
<br />$
<br />512.00
<br />$
<br />539.00
<br />$
<br />593.00
<br />1.45%of Salary
<br />Medicare - Billing Clerk
<br />$
<br />448.00
<br />$
<br />411.00
<br />$
<br />442.00
<br />1.45%of Salary
<br />Medicare - AdministrativeAssistant
<br />$
<br />-
<br />$
<br />32.00
<br />$
<br />158.00
<br />1.45%of5alary
<br />Health Insurance- Billing Clerk
<br />$
<br />9,632.00
<br />$
<br />9,817.00
<br />$
<br />11,802.00
<br />50%of Health Partners High -Deductible Plan
<br />Health Insurance-AdministrativeAssistant
<br />$
<br />-
<br />$
<br />328.00
<br />$
<br />1,356.00
<br />25% of HealthPartners High -Deductible Plan
<br />Dental Insurance - BillingClerk
<br />$
<br />520.00
<br />$
<br />517.00
<br />$
<br />517.00
<br />50% of Delta Dental Plan
<br />Dental Insurance-AdministrativeAssistant
<br />$
<br />-
<br />$
<br />33.00
<br />$
<br />134.00
<br />25% of Delta Dental Plan
<br />Worker's Compensation - Billing Clerk
<br />$
<br />177.00
<br />$
<br />137.00
<br />$
<br />220.00
<br />$30,489/100•$0.72
<br />Worker's Compensation - AdministrativeAssistant
<br />$
<br />-
<br />$
<br />-
<br />$
<br />78.00
<br />$10,874/100-$0.72
<br />$
<br />20,362.00
<br />$
<br />20,779.00
<br />$
<br />26,084.00
<br />Supplies:
<br />Office Supplies
<br />$
<br />3,000.00
<br />$
<br />3,000.00
<br />$
<br />3,000.00
<br />Utility bills and envelopes, standard supplies
<br />Utility Bill Printing & Mailing
<br />$
<br />-
<br />$
<br />950.00
<br />$
<br />1,000.00
<br />Outsourced to Graphic Resources Inc
<br />- Utility Rate Change Insert
<br />$
<br />-
<br />$
<br />126.00
<br />$
<br />126.00
<br />Special rate schedule printing and mailing
<br />Pervasive Software Upgrade
<br />$
<br />$
<br />140.00
<br />$
<br />140.00
<br />Needed to operate FunclBalance Software
<br />Admin Assistant Work Station
<br />$
<br />$
<br />1,545.00
<br />$
<br />-
<br />Prepare work station for PW Admin Asst
<br />Desktop Computer Systems
<br />$
<br />$
<br />1,000.00
<br />$
<br />1,300.00
<br />Prepare work station for PW Admin Asst
<br />Breakroom Supplies
<br />$
<br />750.00
<br />$
<br />750.00
<br />$
<br />750.00
<br />Includes supplies for Rice Lake Centre
<br />$
<br />3,750.00
<br />$
<br />7,511.00
<br />$
<br />6,316.00
<br />Professional Services:
<br />Audit
<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 />Employment Testing
<br />$
<br />$
<br />70.00
<br />$
<br />Admin Asst and PW Worker
<br />$
<br />9,500.00
<br />$
<br />9,703.00
<br />$
<br />10,000.00
<br />IT Support Services:
<br />Computer Technical Support- Metro Inet
<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 />3,975.00
<br />$
<br />4,193.00
<br />$
<br />4,313.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 />125.00
<br />$
<br />125.00
<br />Lift station alarm software
<br />Software Maintenance Agreements - Sensus
<br />$
<br />1,100.00
<br />$
<br />1,100.00
<br />$
<br />1,100.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 />Utility bills and rate schedule mailings
<br />$
<br />2,600.00
<br />$
<br />3,650.00
<br />$
<br />3,700.00
<br />Insurance:
<br />Liability
<br />$
<br />13,717.00
<br />$
<br />15,727.00
<br />$
<br />16,972.00
<br />Assumes no year-end dividends
<br />Property
<br />$
<br />3,989.00
<br />$
<br />10,158.00
<br />$
<br />12,357.00
<br />Assumes no year-end dividends
<br />Automobile
<br />$
<br />425.00
<br />$
<br />357.00
<br />$
<br />475.00
<br />Assumes no year-end dividends
<br />$
<br />18,131.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 />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 />37.00
<br />$
<br />-
<br />Every two years
<br />Discharge Permit - VactorTruck
<br />$
<br />-
<br />$
<br />425.00
<br />$
<br />425.00
<br />Another ridiculous fee
<br />$
<br />1,800.00
<br />$
<br />1,905.00
<br />$
<br />1,960.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 />2,800.00
<br />$
<br />2,727.00
<br />$
<br />2,960.00
<br />Depreciation
<br />Estimated Depreciation
<br />$
<br />60,253.00
<br />$
<br />78,768.00
<br />$
<br />89,247.00 Depreciation on city installed assets
<br />Estimated Contributed Depreciation
<br />$
<br />169,171.00
<br />$
<br />197,458.00
<br />$
<br />202,713.00 Depreciation on developer installed assets
<br />$
<br />229,424.00
<br />$
<br />276,226.00
<br />$
<br />291,960.00
<br />TOTAL SEWER EXPENSES
<br />$
<br />1,200,051.00
<br />$
<br />1,186,452.00
<br />$
<br />1,341,775.00
<br />NET INCOME - SEWER
<br />$
<br />53,780.00
<br />$
<br />109,586.00
<br />$
<br />54,314.00
<br />Sewer Fund Share of PW Facility Bonds
<br />$
<br />53,780.00
<br />$
<br />54,135.00
<br />$
<br />54,314.00
<br />$
<br />$
<br />55,451.00
<br />$
<br />SEWER NET INCOME
<br />Grant for Vactor Truck
<br />$ 268,013.00 $ 299,813.04 $ 197,327.00
<br />$ - $ 25,200.00 $ -
<br />Page 5
<br />
|