Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2018.12.17 RESO 2018-49 Water and Sewer Rates
RESOLUTION 2018 — 49 CITY OF HUGO RESOLUTION ADOPTING A PRO FORMA FINANCIAL GUIDE FOR WATER AND SANITARY SEWER OPERATIONS FOR THE 2019 FISCAL YEAR AND ESTABLISHING SERVICE RATES WHEREAS, the Finance Department has developed a pro forma financial guide for water and sanitary sewer operations for the 2019 fiscal year; and WHEREAS, it is necessary to provide adequate revenue for water and sanitary sewer operations as contained in the pro forma financial guide; and WHEREAS, the water and sanitary sewer service rates recommended herein reflect the true and actual expenses incurred by the city for the services being provided. NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of Hugo, Minnesota, as follows: 1. The pro forma financial guide for water and sanitary sewer operations for the 2019 fiscal year, attached hereto and made a part of this resolution, is hereby approved. 2. The water and sanitary sewer service rates for the 2019 fiscal year, attached hereto and made a part of this resolution, are hereby approved and shall remain in effect until altered by resolution of the City Council or until otherwise altered by law. 3. The Finance Department is hereby directed to provide notice to all municipal utility customers advising them of the water and sanitary sewer service rates approved herein. 4. The Finance Department is hereby directed to develop a pro forma financial guide and recommended service rates on an annual basis going forward. Upon roll call, the following Members voting AYE: Klein, Miron, Petryk, Weidt Upon roll call, the following Members voting NAY: None Whereupon said resolution was declared passed and adop d this 17'h d. f December, 2018. ,_ 4 11 �' Tom Weidt, Mayor ATTEST: Michele Lindau, City Clerk 2019 Water and Sewer Business Pro -Forma ACCOUNT 2018 Estimated 2019 DESCRIPTION Adopted 12/31/2018 Adopted WATER REVENUES: Budget Projected Budget Water Billings: - Residential $ 846,651.00 $ 813,693.00 $ 848,484.00 - Multi Family $ 120,990.00 $ 125,678.00 $ 124,980.00 - Irrigation $ 300,441.00 $ 280,753.00 $ 280,753.00 - Less City Irrigation Accounts $ (31,603.00) $ (31,295.00) $ (31,295.00) - Commercial $ 27,606.00 $ 27,624.00 $ 28,457.00 - Industrial $ 13,486.00 $ 12,939.00 $ 13,138.00 - Educational $ 3,203.00 $ 2,632.00 $ 2,656.00 - Account Adjustments $ - $ - $ - Water Billings (Revenue Requirement) $ 1,280,774.00 $ 1,232,024.00 $ 1,267,173.00 Hydrant Water Sales $ 300.00 $ 744.00 $ 600.00 Water Penalties $ 11,875.00 $ 15,598.00 $ 15,598.00 Water Meters $ 25,000.00 $ 38,040.00 $ 25,000.00 TOTAL WATER REVENUES $ 1,317,949.00 $ 1,286,406.00 $ 1,308,371.00 WATER EXPENSES: Budget Projected Budget Operation & Maintenance Wages: Public Works Director -Anderson $ 37,175.00 $ 37,175.00 $ 38,290.00 Compensated Absences - Anderson $ 1,000.00 $ 1,000.00 $ 1,000.00 Maintenance Worker - Smith $ 30,944.00 $ 30,944.00 $ 31,873.00 Compensated Absences - Smith $ 1,000.00 $ 1,000.00 $ 1,000.00 Maintenance Worker - Pettee $ 30,944.00 $ 5,986.00 $ 26,717.00 Compensated Absences - Pettee $ 1,000.00 $ - $ 1,000.00 In Lieu of Health Insurance $ 2,550.00 $ 2,550.00 $ 2,880.00 Standby Pay $ 7,800.00 $ 7,800.00 $ 8,060.00 Overtime (104 hours at overtime rate) - Smith $ 4,642.00 $ 4,642.00 $ 4,781.00 Overtime (104 hours at overtime rate) - Pettee $ 4,642.00 $ - $ 4,008.00 $ 121,697.00 $ 91,097.00 $ 119,609.00 Fringe Benefits: Pera - Anderson $ 2,788.00 $ 2,788.00 $ 2,872.00 Pera - Smith $ 2,669.00 $ 2,669.00 $ 2,749.00 Pera - Pettee $ 2,669.00 $ 449.00 $ 2,304.00 Pera - Standby Pay $ 585.00 $ 585.00 $ 605.00 Fica - Anderson $ 2,305.00 $ 2,305.00 $ 2,374.00 Fica - Smith $ 2,206.00 $ 2,206.00 $ 2,273.00 Fica - Pettee $ 2,206.00 $ 371.00 $ 1,905.00 Fica - Standby Pay $ 484.00 $ 484.00 $ 500.00 Medicare - Anderson $ 539.00 $ 539.00 $ 555.00 Medicare - Smith $ 516.00 $ 516.00 $ 531.00 Medicare - Pettee $ 516.00 $ 87.00 $ 446.00 Medicare - Standby Pay $ 113.00 $ 113.00 $ 117.00 Health Insurance - Anderson $ 6,909.00 $ 7,074.00 $ 8,480.00 Health Insurance - Pettee $ 10,791.00 $ 815.00 $ 5,077.00 Dental Insurance - Anderson $ 413.00 $ 470.00 $ 470.00 Dental Insurance - Smith $ 470.00 $ 705.00 $ 705.00 Dental Insurance - Pettee $ 705.00 $ 45.00 $ 267.00 Worker's Compensation -Anderson $ 4,140.00 $ 2,424.00 $ 3,703.00 Page 1 2019 Water and Sewer Business Pro -Forma ACCOUNT 2018 Estimated 2019 DESCRIPTION Adopted 12/31/2018 Adopted Worker's Compensation - Smith $ 3,305.00 $ 2,485.00 $ 3,544.00 Worker's Compensation - Pettee $ 3,305.00 $ - $ 2,971.00 Worker's Compensation - Standby Pay $ - _' $ (342.00) $ - $ 47,634.00 _' $ 26,788.00 $ 42,448.00 Supplies: Cleaning Supplies $ 1,940.00 $ 1,940.00 $ 1,940.00 Chemicals $ 50,000.00 _ $ 32,440.00 $ 40,000.00 - Hazardous Waste Generators License $ 260.00 $ 114.00 $ 120.00 Motor Fuels $ 2,000.00 _' _ $ 2,145.00 $ 2,656.00 Small Tools & Equipment $ 10,000.00 $ 6,620.00 $ 10,000.00 Uniforms $ 2,000.00 _ $ 1,170.00 $ 2,040.00 Smart Controllers (for irrigation systems) $ - $ - $ 10,000.00 Water Meters $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 166,200.00 _' $ 144,429.00 $ 166,756.00 Repairs & Maintenance: T Repairs & Maintenance $ 39,600.00 $ 30,000.00 $ 30,000.00 - Watermain Breaks $ 15,000.00 $ 30,814.00 $ 32,000.00 - Well Pump Repairs $ 25,000.00 $ 25,000.00 $ 25,000.00 Building Repair & Maintenance $ 8,000.00 $ 3,100.00 $ 5,000.00 - Reroof well houses $ - $ 24,434.00 $ - - Septic System Pumping $ 2,780.00 $ 2,930.00 $ 3,000.00 - Weed Control $ - $ 841.96 $ 850.00 - HVAC Repairs $ 4,400.00 $ 4,400.00 $ 4,400.00 $ 94,780.00 $ 121,519.96 $ 100,250.00 Professional Services: Water Bacteria Testing $ 1,300.00 $ 1,200.00 $ 1,500.00 Building Cleaning Services (contract) $ 2,500.00 $ 2,000.00 $ 2,100.00 Scada System Troubleshooting $ 650.00 $ 650.00 $ 650.00 Safety Training $ 1,500.00 $ 1,485.00 $ 1,515.00 $ 5,950.00 $ 5,335.00 $ 5,765.00 Engineering: Engineering - Non-specific engineering fees $ 12,500.00 $ 12,500.00 $ 12,500.00 Engineering - Well Head Protection Plan $ 5,985.00 $ 1,003.00 $ - Engineering - Implement Well Head Prot. Plan $ - j m $ 4,982.00 $ 5,000.00 $ 18,485.00 $ 18,485.00 $ 17,500.00 Utilities: Electricity: _ - Xcel - Public Works Facility $ 4,000.00 _ $ 4,137.00 $ 4,220.00 - Xcel - Well No. 2 & Tower No. 2 $ 4,292.00 _ $ 4,395.00 $ 4,485.00 - Xcel - Well No. 3 $ 7,339.00 $ 7,370.00 $ 7,520.00 - Xcel -Tower No. 3 $ 4,317.00 $ 3,216.00 $ 3,280.00 - Xcel - Well No. 4 $ 8,264.00 $ 6,157.00 $ 6,280.00 - Xcel - Well No. 5 $ 6,585.00 $ 5,975.00 $ 6,095.00 - Xcel - Well No. 6 $ 5,324.00 $ 3,967.00 _ $ 4,046.00 - BHE -Well No. 2 (solar garden contract) $ 9,203.00 $ 7,480.00 $ 7,630.00 - BHE -Well No. 3 (solar garden contract) $ 17,620.00 $ 14,210.00 $ 14,495.00 - BHE -Well No. 4 (solar garden contract) $ 21,226.00 $ 17,100.00 $ 17,445.00 - BHE -Well No. 5 (solar garden contract) $ 16,043.00 $ 12,895.00 $ 13,155.00 - BHE - Well No. 6 (solar garden contract) $ 13,567.00 $ 10,985.00 $ 11,205.00 Page 2 2019 Water and Sewer Business Pro -Forma ACCOUNT 2018 Estimated 2019 DESCRIPTION Adopted 12/31/2018 Adopted $ 117,780.00 $ 97,887.00 $ 99,856.00 Gas for Public Works Facility $ 2,500.00 $ 2,768.00 _� $ 2,823.00 Refuse Disposal $ 3,000.00 $ 3,610.00 _� $ 4,220.00 $ 123,280.00 $ 104,265.00_ $ 106,899.00 Communications: Cellular Phone Charges $ 3,600.00 $ 3,265.00 $ 3,600.00 Business Internet - Comcast (prior to upgrade) $ 18.00 $ 18.00 $ - Business Internet - Comcast (upgraded speed) $ 732.00 $ 2,086.00 $ 2,100.00 Line 651653-1154 583 Scada $ 345.00 $ 353.00 _ $ 360.00 $ 4,695.00 $ 5,722.00 $ 6,060.00 Travel & Training: Training Classes $ 1,500.00 $ 1,635.00 $ 1,650.00 $ 1,500.00 $ 1,635.00 $ 1,650.00 Professional Memberships: ......... -- ............ _........ .. .. ...................... .... Dues $ 80.00 _ $ 82.00 $ 85.00 $ 80.00 $ 82.00 $ 85.00 Administration Wages: City Administrator $ 35,287.00 $ 37,201.00 $ 40,889.00 Billing Clerk $ 30,944.00 $ 28,326.00 _ $ 30,489.00 Compensated Absences $ 1,000.00 $ 1,000.00 $ 1,000.00 Administrative Assistant $ - $ 2,233.00 $ 10,874.00 Compensated Absences $ - $ - $ 1,000.00 $ 67,231.00 $ 68,760.00 $ 84,252.00 Fringe Benefits: Pera - City Administrator $ 2,647.00 $ 2,790.00 _' $ 3,067.00 Pera - Billing Clerk $ 2,320.00 $ 2,124.00 $ 2,287.00 Pera - Administrative Assistant $ - $ 167.00 _ $ 816.00 Fica - City Administrator $ 1,972.00 $ 1,990.00 $ 2,050.00 Fica - Billing Clerk $ 2,134.00 $ 1,756.00 $ 1,890.00 Fica - Administrative Assistant $ - $ 138.00 _ $ 674.00 Medicare - City Administrator $ 512.00 $ 539.00 j $ 593.00 Medicare - Billing Clerk $ 448.00 $ 411.00 $ 442.00 Medicare - Administrative Assistant $ - $ 32.00 $ 158.00 Health Insurance - Billing Clerk $ 9,632.00 $ 9,817.00 $ 11,802.00 Health Insurance - Administrative Assistant $ - $ 328.00 ! $ 1,356.00 Dental Insurance - Billing Clerk $ 520.00 $ 517.00 $ 517.00 Dental Insurance - Administrative Assistant $ - $ 33.00$ 134.00 Worker's Compensation - Billing Clerk $ 177.00 $ 137.00 _ $ 220.00 Worker's Compensation - Administrative Assistant $ - $ - $ 78.00 $ 20,362.00 $ 20,779.00 _ $ 26,084.00 Supplies: _ Office Supplies $ 3,000.00 $ 3,000.00 $ 3,000.00 - Utility Bill Printing & Mailing (outsourced) $ - $ 950.00 $ 975.00 - Utility Rate Change Insert $ _ - $ 126.00 $ 126.00 - Irrigation Usage Postcards $ - $ 850.00 L $ 850.00 - Pervasive Software Upgrade $ - $ 140.00 $ 140.00 - Admin Assistant Work Station $ - $ 1,545.00 T $ - - Desktop Computer Systems $ - $ 1,000.00 $ 1,000.00 Page 3 ACCOUNT DESCRIPTION Breakroom Supplies Water Brochures 2019 Water and Sewer Business Pro -Forma Professional Services: Audit Accounting Services Legal Fees - WBL Restoration Litigation Legal Fees - DNR Permit Requirements Employment Testing Contractual Maintenance: Software Maintenance Agreements - Fund Balance Software Maintenance Agreements - Scada Software Maintenance Agreements - Sensus Communications: Postage IT Support Services: Computer Technical Support - Metro Inet Telephone Support - City of Roseville Insurance: Liability Property Automobile Rentals: Copier Lease Payments Copier Overage Charges Miscellaneous: Water Appropriation Fees (DNR) Gopher State Service Charges Truck License Tabs Pressure Vessel Registration Fees Assessment Collection Fees Depreciation Estimated Depreciation Estimated Contributed Depreciation WATER EXPENSES NET INCOME - WATER Water Fund Share of PW Facility Bonds 2018 Estimated 2019 Adopted 12/31/2018 Adopted $ 3,000.00 $ 7,611.00 $ 6,091.00 $ 750.00 $ 750.00 _ ! $ 750.00 $ 50.00 $ 27.00 —. j $ 50.00 $ 3,800.00 $ 8,388.00 j $ i 6,891.00 $ 6,900.00 $ 6,900.00 j $ 7,100.00 $ 2,600.00 $ 2,733.00 j $ 2,900.00 $ 2,000.00 $ 18,000.00 _ $ 6,000.00 $ - $ 1,000.00 $ 1,000.00 $ - $ 70.00 $ - $ 11,500.00 $ 28,703.00 j $ 17,000.00 $ 669.00 $ 702.00 $ 736.00 $ - $ 125.00 $ 125.00 $ 1,100.00 $ 1,100.00 $ 1,100.00 $ 1,769.00 $ 1,927.00 $ 1,961.00 $ 2,600.00 _ $ 3,650.00 $ 3,700.00 $ 2,600.00 j $ 3,650.00 $ 3,700.00 I $ 3,615.00 � $ 3,840.00 $ 3,950.00 $ 360.00 _ $ 353.00_ $ 363.00 $ 3,975.00 $ 4,193.00 $ 4,313.00 $ 13,717.00 $ 15,717.00 $ 16,972.00 $ 7,959.00 _ $ 10,158.00 $ 12,357.00 $ 239.00 $ 357.00 $ 475.00 $ 21,915.00 _ $ 26,232.00 $ 29,804.00 $ 500.00 $ 493.00 $ 493.00 $ 50.00 $ 50.00 $ 50.00 $ 550.00 $ 543.00 $ 543.00 $ 5,758.00 $ 5,962.00 $ 6,166.00 $ 1,800.00 $ 1,443.00 $ 1,535.00 $ - $ 21.00 $ - $ 7,558.00 $ 7,426.00 $ 7,701.00 $ 1,000.00 $ 822.00 $ 1,000.00 $ 8,558.00 $ 8,248.00 $ 8,701.00 $ 230,070.00 $ 231,835.00 $ 242,314.00 $ 147,085.00 $ 173,563.00 $ 179,468.00 $ 377,155.00 $ 405,398.00 $ 421,782.00 $ 1,103,716.00 $ 1,096,178.96 $ 1,172,053.00 $ 214,233.00 $ 190,227.04 $ 136,318.00 $ 53,780.00 $ 54,135.00 $ 54,314.00 $ 160,453.00 $ 136,092.04 $ 82,004.00 Page 4 2019 Water and Sewer Business Pro -Forma ACCOUNT 2018 Estimated 2019 DESCRIPTION Adopted 12/31/2018 Adopted SEWER REVENUES: Sewer Billings: - Residential $ 789,195.00 $ 820,319.00 $ 908,399.00 - Multi Family $ 389,324.00 $ 393,157.00 $ 427,628.00 - Commercial $ 39,588.00 $ 40,597.00 $ 41,484.00 - Industrial $ 19,568.00 $ 22,358.00 $ 23,662.00 - Educational $ 4,736.00 $ 6,876.00 $ 8,012.00 - Account Adjustments $ - $ - $ - Sewer Billings (Revenue Requirement) $ 1,242,411.00 $ 1,283,307.00 $ 1,409,185.00 Sewer Penalties $ 11,420.00 $ 12,731.00 $ 12,994.00 TOTAL SEWER REVENUES $ 1,253,831.00 $ 1,296,038.00 $ 1,422,179.00 SEWER EXPENSES: Operation & Maintenance Wages: Public Works Director - Anderson $ 37,175.00 $ 37,175.00 $ 38,290.00 Compensated Absences - Anderson $ 1,000.00 $ 1,000.00 $ 1,000.00 Maintenance Worker - Smith $ 30,944.00 $ 30,944.00 $ 31,873.00 Compensated Absences - Smith $ 1,000.00 $ 1,000.00 $ 1,000.00 Maintenance Worker - Pettee $ 30,944.00 $ 5,986.00 $ 26,717.00 Compensated Absences - Pettee $ 1,000.00 $ - $ 1,000.00 In Lieu of Health Insurance $ 2,550.00 $ 2,550.00 $ 2,880.00 Standby Pay $ 7,800.00 _ $ 7,800.00 $ 8,060.00 Overtime (104 hours at overtime rate) - Smith $ 4,642.00 _ $ 4,642.00 $ 4,781.00 Overtime (104 hours at overtime rate) - Pettee $ 4,642.00 $ - $ 4,008.00 $ 121,697.00 $ 91,097.00 $ 119,609.00 Fringe Benefits: Pera - Anderson $ 2,788.00_ 2,788.00 $ 2,872.00 Pera - Smith $ 2,669.00 $ 2,669.00 $ 2,749.00 Pera - Pettee $ 2,669.00 $ 449.00 $ 2,304.00 Pera - Standby Pay $ 585.00 _i _ $ 585.00 $ 605.00 Fica - Anderson $ 2,305.00 is 2,305.00 $ 2,374.00 Fica - Smith $ 2,206.00 _ $ 2,206.00 $ 2,273.00 Fica - Pettee $ 2,206.00 $ 371.00 $ 1,905.00 Fica - Standby Pay $ 484.00 $ 484.00 $ 500.00 Medicare - Anderson $ 539.00 $ 539.00 $ 555.00 Medicare - Smith $ 516.00 $ 516.00 $ 531.00 Medicare - Pettee $ 516.00 $ 87.00 $ 446.00 Medicare - Standby Pay $ 113.00 $ 113.00 $ 117.00 Health Insurance -Anderson $ 6,909.00 $ 7,074.00 $ 8,480.00 Health Insurance - Pettee $ 10,791.00 $ 815.00 $ 5,077.00 Dental Insurance - Anderson $ 413.00 $ 470.00 $ 470.00 Dental Insurance - Smith $ 470.00 $ 705.00 $ 705.00 Dental Insurance - Pettee $ 705.00 $ 45.00 $ 267.00 Worker's Compensation - Anderson $ 4,140.00 $ 2,424.00 $ 3,703.00 Worker's Compensation - Smith $ 3,305.00 $ 2,485.00 $ 3,544.00 Worker's Compensation - Pettee $ 3,305.00 $ - $ 2,971.00 Worker's Compensation - Standby Pay $ - $ (342.00) $ - $ 47,634.00 $ 26,788.00 $ 42,448.00 Page 5 2019 Water and Sewer Business Pro -Forma ACCOUNT DESCRIPTION Supplies: Cleaning Supplies Motor Fuels Small Tools & Equipment - Communications Headset & Hub Uniforms Repairs & Maintenance: Repairs & Maintenance - Submersible Pumps for Lift Stations - Lift Station Rebuilds Building Repair & Maintenance - Septic System Pumping - Weed Control - HVAC Repairs Professional Services: Building Cleaning Services (contract) Scada System Troubleshooting Safety Training Sewage Treatment: Metro Council Environmental Services Utilities: Electricity: - Lift Stations - PW Facility Gas for Public Works Facility Refuse Disposal Communications: Cellular Phone Charges Business Internet - Comcast (prior to upgrade) Business Internet - Comcast (upgraded speed) Line 651653-1154 583 Scada Travel & Training: Training Classes - Vactor Truck Training Trip to California to Inspect Vactor Truck Professional Memberships: Dues Administration Wages: City Administrator 2018 9,100.00 Estimated 2019 Adopted $ 12/31/2018 Adopted if $ 2,500.00 $ 1,940.00 $ 1,940.00 _ $ 1,940.00 $ 2,000.00 _ $ 2,145.00 _ $ 2,656.00 $ 10,000.00 $ 7,600.00 $ 10,000.00 $ - $ 4,916.00 $ - $ 2,000.00 _ $ 1,170.00 $ 2,040.00 $ 15,940.00 $ 17,771.00 $ 16,636.00 $ 20,000.00 _�$ 34,800.00 $ 57,890.00 $ 20,000.00 _ $ 21,000.00 $ 22,000.00 $ 40,000.00 $ - $ 40,000.00 $ 8,000.00 _ $ 2,500.00 $ 5,000.00 $ 2,780.00 _ $ 2,930.00 $ 3,000.00 $ - $ 229.00 $ 300.00 $ 4,400.00 _ $ 2,140.00 $ 4,400.00 $ 95,180.00 $ 63,599.00 $ 132,590.00 $ 2,500.00_ _ 2,000.00 $ 2,100.00 $ 650.00 $ 650.00 $ 650.00 $ 1,500.00 _ $ 1,485.00 $ 1,515.00 $ 4,650.00 $ 4,135.00 $ 4,265.00 $ 528,283.00 $ 528,283.00 $ 558,801.00 $ 528,283.00 _i. $ 528,283.00 $ 558,801.00 $ 9,100.00 $ $ 4,000.00 $ $ 13,100.00 $ $ 2,500.00 $ $ 3,000.00 $ $ 18,600.00 $ 3,600.00 $ 18.00 $ 732.00 $ 345.00 $ 4,695.00 $ $ 3,200.00 $ $ 3,200.00 $ $ 80.00 $ $ 80.00 $ $ 35,287.00 $ Page 6 9,230.00 $ 4,137.00 $ 13,367.00 $ 2,768.00 $ 3,610.00 $ 19,745.00 $ 3,265.00 $ 18.00 $ 2,086.00 $ 353.00 $ 5,722.00 $ 4,300.00 $ 590.00 $ 2,089.00 $ 6,979.00 1 $ 82.00 $ 82.00 _ $ 37,201.00 $ 9,415.00 4,220.00 13,635.00 2,823.00 4,220.00 20, 678.00 3,600.00 2,000.00 360.00 5,960.00 4,300.00 600.00 85.001 2019 Water and Sewer Business Pro -Forma ACCOUNT 2018 Estimated 2019 DESCRIPTION Adopted 12/31/2018 Adopted Billing Clerk $ 30,944.00 $ 28,326.00 $ 30,489.00 Compensated Absences $ 1,000.00 $ 1,000.00 $ 1,000.00 Administrative Assistant $ - $ 2,233.00 $ 10,874.00 Compensated Absences $ - $ - _ $ 1,000.00 $ 67,231.00 $ 68,760.00 $ 84,252.00 Fringe Benefits: _ Pera - City Administrator $ 2,647.00 $ 2,790.00 $ 3,067.00 Pera - Billing Clerk $ 2,320.00 $ 2,124.00 _ $ 2,287.00 Pera - Administrative Assistant $ - $ 167.00 $ 816.00 Fica - City Administrator $ 1,972.00 $ 1,990.00 $ 2,050.00 Fica - Billing Clerk $ 2,134.00 $ 1,756.00 $ 1,890.00 Fica - Administrative Assistant $ - $ 138.00 $ 674.00 Medicare - City Administrator $ 512.00 $ 539.00 $ 593.00 Medicare - Billing Clerk $ 448.00 $ 411.00 $ 442.00 Medicare - Administrative Assistant $ - $ 32.00 $ 158.00 Health Insurance - Billing Clerk $ 9,632.00 $ 9,817.00 _ $ 11,802.00 Health Insurance - Administrative Assistant $ - $ 328.00 _ $ 1,356.00 Dental Insurance - Billing Clerk $ 520.00 $ 517.00 $ 517.00 Dental Insurance - Administrative Assistant $ - $ 33.00 $ 134.00 Worker's Compensation - Billing Clerk $ 177.00 $ 137.00 $ 220.00 Worker's Compensation - Administrative Assistant $ - $ - _ $ 78.00 $ 20,362.00 $ 20,779.00 _ _ $ 26,084.00 Supplies: _ Office Supplies $ 3,000.00 $ 3,000.00 j $ 3,000.00 - Utility Bill Printing & Mailing $ - $ 950.00 $ 1,000.00 - Utility Rate Change Insert $ - $ 126.00 $ 126.00 - Pervasive Software Upgrade $ - $ 140.00 _ $ 140.00 - Admin Assistant Work Station $ - $ 1,545.00 _ _ $ - - Desktop Computer Systems $ - $ 1,000.00 $ 1,300.00 Breakroom Supplies $ 750.00 $ 750.00 $ 750.00 $ 3,750.00 $ 7,511.00 $ 6,316.00 Professional Services: Audit $ 6,900.00 $ 6,900.00 $ 7,100.00 Accounting Services $ 2,600.00 $ 2,733.00 $ 2,900.00 Employment Testing $ - $ 70.00 $ - $ 9,500.00 $ 9,703.00 $ 10,000.00 IT Support Services: Computer Technical Support - Metro Inet $ 3,615.00 $ 3,840.00 $ 3,950.00 Telephone Support - City of Roseville $ 360.00 $ 353.00 $ 363.00 $ 3,975.00 $ 4,193.00 $ 4,313.00 Contractual Maintenance: Software Maintenance Agreements - Fund Balance $ 669.00 $ 702.00 $ 736.00 Software Maintenance Agreements - Scada $ - $ 125.00 $ 125.00 Software Maintenance Agreements - Sensus $ 1,100.00 $ 1,100.00 $ 1,100.00 $ 1,769.00 $ 1,927.00 $ 1,961.00 Communications: Postage $ 2,600.00 $ 3,650.00 $ 3,700.00 $ 2,600.00 $ 3,650.00 $ 3,700.00 Insurance: Page 7 2019 Water and Sewer Business Pro -Forma ACCOUNT 2018 Estimated 2019 DESCRIPTION Adopted 12/31/2018 Adopted Liability $ 13,717.00 $ 15,717.00 $ 16,972.00 Property $ 3,989.00 $ 10,158.00 $ 12,357.00 Automobile $ 425.00 $ 357.00 $ 475.00 $ 18,131.00 $ 26,232.00 $ 29,804.00 Rentals: Copier Lease Payments $ 500.00 $ 493.00 $ 493.00 Copier Overage Charges $ 50.00 $ 50.00 $ 50.00 $ 550.00 $ 543.00 $ 543.00 Miscellaneous: Gopher State Service Charges $ 1,800.00 $ 1,443.00 $ 1,535.00 Truck License Tabs $ - $ 37.00 $ - Discharge Permit - Vactor Truck $ - $ 425.00 $ 425.00 $ 1,800.00 $ 1,905.00 $ 1,960.00 Assessment Collection Fees $ 1,000.00 $ 822.00 $ 1,000.00 $ 2,800.00 $ 2,727.00 $ 2,960.00 Depreciation Estimated Depreciation $ 60,253.00 $ 78,768.00 $ 89,247.00 Estimated Contributed Depreciation $ 169,171.00 $ 197,458.00 $ 202,713.00 $ 229,424.00 $ 276,226.00 $ 291,960.00 TOTAL SEWER EXPENSES $ 1,200,051.00 $ 1,186,452.00 $ 1,367,865.00 NET INCOME - SEWER $ 53,780.00 $ 109,586.00 $ 54,314.00 Sewer Fund Share of PW Facility Bonds $ 53,780.00 $ 54,135.00 $ 54,314.00 $ - $ 55,451.00 $ - WATER & SEWER NET INCOME $ 268,013.00 $ 299,813.04 $ 190,632.00 Rice Creek Grant for Vactor Truck $ - $ 25,200.00 $ - Returned Check Fees $ 540.00 $ 540.00 $ 540.00 Special Assessments $ 825.00 $ 825.00 $ 825.00 Investment Earnings: - Interest Income $ 33,200.00 $ 89,635.00 $ 50,000.00 - Change in Value of Investments Rents & Royalties: - T Mobile Base Rent $ 32,418.00 $ 34,039.00 $ 35,740.00 - Connexus Energy Annual Tower Lease $ 3,408.00 $ 3,510.00 $ 3,510.00 Transfer to PW Facility Bond Sinking Fund $ (107,560.00) $ (108,269.00) $ (108,628.00) CHANGE IN RETAINED EARNINGS $ 230,844.00 $ 345,293.04 $ 172,619.00 Contributed Depreciation $ 316,256.00 $ 371,021.00 $ 382,181.00 TOTAL CHANGE IN RETAINED EARNINGS $ 547,100.00 $ 716,314.04 $ 554,800.00 Page 8 City of Hugo Utility Rates Effective January 1, 2019 2018 Rates 2019 Rates 2018 Single -Family Residential Water Gallons/Qtr. Rate Base Rate: Volume Rate: 1-11,000 $1.00 per thousand 11,001- 20,000 $2.00 per thousand 20,001- 29,000 $3.00 per thousand 29,000+ $4.88 per thousand Base Rate: Volume Rate: 2019 Single -Family Residential Water Gallons/Qtr. Rate 1-11,000 $1.00 per thousand 11,001- 20,000 $2.00 per thousand 20,001- 29,000 $3.00 per thousand 29,000+ $4.88 per thousand 2018 Multi -Family Residential Water 2019 Multi -Family Residential Water Gallons/Qtr. Rate Gallons/Qtr. Rate Base Rate: Base Rate: $31.00 per quarter Volume Rate: Volume Rate: All Gallons $2.00 per thousand All Gallons $2.00 per thousand 2018 Commercial, Industrial and Institutional Water 2019 Commercial, Industrial and Institutional Water Gallons/Qtr. Rate Gallons/Qtr. Rate Base Rate: $28.00 per quarter Base Rate: Volume Rate: Volume Rate: 1-5,000 $1.00 per thousand 5,001+ $1.65 per thousand 2018 Irrigation (Metered Separately) Gallons/Qtr. Rate Volume Rate: All Gallons $4.88 per thousand 2018 Residential Sewer_ Gallons/Qtr. Rate Charge for Each SAC Unit Single Family =1 SAC Unit Multi -Family =1 SAC Unit per Dwelling Volume Rate: 1-5,000 $1.00 per thousand 5,001+ $1.65 per thousand 2019 Irrigation (Metered Separately) Gallons/Qtr. Rate Volume Rate: All Gallons $4.88 per thousand 2019 Residential Sewer Gallons/Qtr. Rate Charge for Each SAC Unit $60.00 per quarter Single Family =1 SAC Unit Multi -Family =1 SAC Unit per Dwelling Volume Rate: 1-9,000 No Charge 1-9,000 No Charge 9,001+ $1.85 per thousand 9,001+ $1.85 per thousand The number of gallons charged for residential sewer service shall be the same for all quarters and shall be determined by the amount of water used during the winter quarter (January, February and March) 2018 Commercial, Industrial and Institutional Sewer Gallons/Qtr. Rate Charge for Each SAC Unit $16.00 per quarter SAC Units Vary by Building Volume Rate: 1-3,000 No Charge 3,000+ $1.85 per thousand 2018 rates were used to calculate the bill you received in January, 2019 (for the October, November and December Quarter) 2019 Commercial, Industrial and Institutional Sewer Gallons/Qtr. Rate Charge for Each SAC Unit $18.00 per quarter SAC Units Vary by Building Volume Rate: 1-3,000 No Charge 3,000+ $1.85 per thousand 2019 rates will first apply to the bill you receive in April, 2019 (for the January, February and March Quarter)