The URL can be used to link to this page

Water Department Fiscal Year 2018 Budget Presentation Copyright 2014 City of Dubuque Public Hearings # 1. ITEM TITLE: Water Department Fiscal Year 2018 Budget Presentation SUMMARY: SUGGESTED DISPOSITION: ATTACHMENTS: Description Type Recommended FY18 Water CIP Supporting Documentation Recommended FY18 Water OP Supporting Documentation DEPARTMENT: STATE PROGRAM: PROJECT TITLE: PROGRAM: 8C Water Department Business Type Water Storage Tank Coating Program DEPARTMENT: 42 TOTAL PROJECT FD/CIP NO: 740-2656 COST $ 333,500 2016 2017 ACTUAL AMENDED BEYOND EXP BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 2022 A. EXPENDITURE ITEMS $ 88,500 Consultant Services $ 45,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ — $ 88,500 TOTAL $ 45,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 B. PROJECT FINANCING $ 88,500 Water Construction Fund $ 45,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 88 $ — $ ,500 TOTAL $ 45,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 PROJECT DESCRIPTION This project provides the funding to clean, spot prime and paint the interior and exterior of the Water Storage Tanks. Painting of water tanks is a cyclical program, coatings can last 20-25 years. A study was conducted in 2010 by KLM Engineering. the results from this study supports the need to proceed with this program as identified. Tanks to be addressed are: Pennsylvania (2018 - 2019), Park Hill (2020 - 2021), College (2022 -2023) and Eagle Point (2024- 2025). JUSTIFICATION Painting of the tanks is required to maintain the tank structure as well as add to the aesthetics of the tank. RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal One: To provide, maintain and improve a cost-effective, functional and self-supporting water utility system, objectives 1.1) Support an adequate water supply, 1.2) Support cost-effective delivery of water and 1.3) Support a safe water supply that meets all local, state, and federal water quality standards and Goal Ten: To provide, maintain, and improve City-owned buildings, structures, facilities, and properties, objective 10.1) Support maintaining and improving the energy efficiency and aesthetic qualities of City-owned buildings, structures, facilities, and properties. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principles of Clean Water, Smart Resource Use and Community Health &Safety. 136 DEPARTMENT: STATE PROGRAM: PROJECT TITLE: PROGRAM: 8C Water Department Business Type Water Main Relocation for Sanitary Sewer DEPARTMENT: 42 TOTAL Manhole Replacement/Rehabilitation PROJECT Project FD/CIP NO: 740-2596 COST $ 175,512 2016 2017 ACTUAL AMENDED BEYOND EXP BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 2022 A. EXPENDITURE ITEMS $ 418 $ 70,094 Construction $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 25,000 $ 25,000 $ 418 $ 70,094 TOTAL $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 25,000 $ 25,000 B. PROJECT FINANCING $ 418 $ 70,094 Water Construction Fund $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 25,000 $ 25,000 $ 418 $ 70,094 TOTAL $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 25,000 $ 25,000 PROJECT DESCRIPTION This project provides for the scheduled replacement/rehabilitation of old sanitary sewer manholes to relocate water mains. This fund covers the cost of material and labor for the relocation of water mains currently located with in sewer manholes. JUSTIFICATION Under the City's current Engineering program of sanitary sewer inspection and maintenance, manholes that are in need of repair or replacement are noted. This project provides the funding for such repair/replacement of water mains as these manholes are located. RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal One: To provide, maintain and improve a cost-effective, functional and self-supporting water utility system, objectives 1.1) Support an adequate water supply and 1.2) Support cost-effective delivery of water. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principles of Regional Economy, Smart Resource Use, Clean Water and Community Health &Safety. 137 DEPARTMENT: STATE PROGRAM: PROJECT TITLE: PROGRAM: 8C Water Department Business Type Creek Crossing Restoration DEPARTMENT: 42 TOTAL PROJECT FD/CIP NO: 740-2595 COST $ 319,656 2016 2017 ACTUAL AMENDED BEYOND EXP BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 2022 A. EXPENDITURE ITEMS $ 978 $ 22,764 Design & Engineering $ 11,000 $ 11,000 $ 11,000 $ 11,000 $ 11,000 $ 70,914 Construction $ 34,000 $ 34,000 $ 34,000 $ 34,000 $ 34,000 $ 978 $ 93,678 TOTAL $ 45,000 $ 45,000 $ 45,000 $ 45,000 $ 45,000 $ B. PROJECT FINANCING $ 978 $ 93,678 Water Construction Fund $ 45,000 $ 45,000 $ 45,000 $ 45,000 $ 45,000 $ 978 $ 93,678 TOTAL $ 45,000 $ 45,000 $ 45,000 $ 45,000 $ 45,000 $ - PROJECT DESCRIPTION This project provides the funding for the repairs of various water main crossings of drainage ways in the city's water distribution system. JUSTIFICATION During the past several years with normal and heavy rains, the systems water way crossing covers have deteriorated. This project is a proactive maintenance approach to restore these crossings back to functional levels for future protection. Cost Estimate Project Name Cost Estimate Project Name Cost Estimate Project Name $ 2,330 Pennsylvania Ave $ 13,200 Northwest Arterial (East) $ 5,300 Samantha Dr. to Holiday Dr. $ 4,500 Seipple Rd. $ 15,900 Fremont Ave. $ 6,500 Carter Rd. 950' south of 32nd St. $ 33,120 Cousins Rd. $ 19,000 Old Mill Rd. $ 26,900 Carter Rd. at 32nd $ 9,500 Radford Rd. $ 9,680 Southern Ave. $ 1,875 32nd at Ski Slope $ 22,324 Northwest Arterial (West) $ 2,290 Rockdale at Brian $ 1,875 Louella Lane RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal One: To provide, maintain and improve a cost-effective, functional and self-supporting water utility system, objectives 1.1) Support an adequate water supply and 1.2) Support cost-effective delivery of water. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principles of Regional Economy, Smart Resource Use, Clean Water and Community Health &Safety. 138 DEPARTMENT: STATE PROGRAM: PROJECT TITLE: PROGRAM: 8C Water Department Business Type Water Main Upgrades during Street DEPARTMENT: 42 TOTAL General Repairs PROJECT FD/CIP NO: 740-2657 COST $ 175,000 2016 2017 ACTUAL AMENDED BEYOND EXP BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 2022 A. EXPENDITURE ITEMS $ 2,500 Design & Engineering $ 2,500 $ 3,500 $ 3,500 $ 4,000 $ 4,000 $ 5,000 $ 17,500 Construction $ 22,500 $ 26,500 $ 26,500 $ 31,000 $ 31,000 $ 35,000 $ - $ 20,000 TOTAL $ 25,000 $ 30,000 $ 30,000 $ 35,000 $ 35,000 $ 40,000 B. PROJECT FINANCING $ 20,000 Water Construction Fund $ 25,000 $ 30,000 $ 30,000 $ 35,000 $ 35,000 $ 40,000 $ - $ 20,000 TOTAL $ 25,000 $ 30,000 $ 30,000 $ 35,000 $ 35,000 $ 40,000 PROJECT DESCRIPTION This project provides funding to support City Engineering's program of design and construction for general street construction related improvements. JUSTIFICATION In prior years, the City had an annual capital improvement budget that would collectively fund all construction related improvements and the 5-Year Annual Street Construction Program. This policy has been changed and now the Annual Street Construction Program is budgeted as individual CIP's. As a result, an annual program is needed to provide a funding mechanism to allow for the design and construction for general street construction repairs and related improvements as miscellaneous projects develop that may include water main related goods to be upgraded or adjusted. The Engineering Department routinely work on miscellaneous repair projects that occur, require a quick response and that are both unexpected and not budgeted. This annual program will provide a funding source to cover design and construction costs for those unanticipated small repair projects. RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal Four: To provide, maintain, and improve a cost-effective, safe and functional surface transportation system, objective 4.1) Support the ongoing street reconstruction, rehabilitation, and maintenance overlay programs, ensuring the timely maintenance, repair and reconstruction of the city's streets and bridges and Transportation Goal One: To provide, maintain and improve safe and efficient movement on the City's street system, objectives 1.1) Support continuing the ongoing street construction program, providing for timely maintenance, repair and reconstruction of the City street system and 1.2) Encourage implementation of sound safety engineering principles and practices in the area of street lighting, street layout, speed limits, street signage, street pavement striping, and traffic signals. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Reasonable Mobility 139 DEPARTMENT: STATE PROGRAM: PROJECT TITLE: PROGRAM: 8C Water Department Business Type Maintenance of Public Water Mains during DEPARTMENT: 42 TOTAL Stone Retaining Wall Repair PROJECT FD/CIP NO: 740-2655 COST $ 120,000 2016 2017 ACTUAL AMENDED BEYOND EXP BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 2022 A. EXPENDITURE ITEMS $ 2,000 Design & Engineering $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 18,000 Construction $ 18,000 $ 18,000 $ 18,000 $ 18,000 $ 18,000 $ 18,000 $ - $ 20,000 TOTAL $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 B. PROJECT FINANCING $ 20,000 Water Construction Fund $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ - $ 20,000 TOTAL $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 PROJECT DESCRIPTION This annual funding provides for maintenance and repair of existing water utilities behind retaining walls that are owned by or are the responsibility of the City of Dubuque in various locations throughout the City. Many times the public utilities behind these retaining walls need to be replaced or supported during the retaining wall repair. This annual program will allow for maintenance, repair and reconstruction of city owned retaining walls as needed. Based on the recommendation of the City's Legal Department, there are a significant number of private property owner retaining walls which are adjacent to City right-of-way in which a mutual benefit could be establish through litigation, as a result, the annual funding for retaining wall maintenance, repair and reconstruction of water utilities has been increased to address this potential liable cost to the City. JUSTIFICATION This annual program would provide for proactive maintenance, reconstruction and emergency repairs to city owned retaining walls that included public water main (s). RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal Four: To provide, maintain, and improve a cost-effective, safe and functional surface transportation system, objective 4.4) Support maintaining and improving city alleys, guardrails, street lights, traffic control lights, street pavement markings, traffic signs, street name signs, walls and other related facilities and Transportation Goal One: To provide, maintain and improve safe and efficient movement on the City's street system, objective 1.1) Support continuing the ongoing street construction program, providing for timely maintenance, repair and reconstruction of the City street system. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Community Design and Clean Water. 140 DEPARTMENT: STATE PROGRAM: PROJECT TITLE: PROGRAM: 8C Water Department Business Type Fire Hydrant Assembly Relocation/ DEPARTMENT: 42 TOTAL Replacement for the Sidewalk Program PROJECT FD/CIP NO: 740-2654 COST $ 96,000 2016 2017 ACTUAL AMENDED BEYOND EXP BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 2022 A. EXPENDITURE ITEMS $ 12,000 Construction $ 12,000 $ 12,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ — $ 12,000 TOTAL $ 12,000 $ 12,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 B. PROJECT FINANCING $ 12,000 Water Construction Fund $ 12,000 $ 12,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ — $ 12,000 TOTAL $ 12,000 $ 12,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 PROJECT DESCRIPTION This project provides for two (2) fire hydrant assemblies to be relocated/replaced per year in support of City Engineering's replacement of curbs and catch basins related to the sidewalk inspection and replacement program JUSTIFICATION Replacement of sidewalks, particularly those abutting the curb line or an intersection, frequently requires replacement of curbs and catch basins. It is anticipated in future years this program will increase with the installation of curb ramps with detectable warnings required by the Americans with Disabilities Act (ADA). Without funding for replacement of the curbs and catch basins, the program is restricted or delayed until funding can be secured. With funding earmarked for curb and catch basin replacement, the program can move forward on an established schedule. With an increase in curb and catch basin inspections at time of sidewalk inspections, additional curb and catch basins are identified for replacement, especially if the street is to be overlaid in the near future. The anticipated cost for curb and catch basin repairs has been increasing over the past few years and is anticipated to continue when the ramps needing walls, foundations, railings, and special designs are addressed. RELATIONSHIP TO OTHER PROJECTS This project is tied to the City's annual sidewalk inspection program. Curb replacements are also funded in the operating and capital budgets of the Operations and Maintenance Department. This project implements the Comprehensive Plan's Infrastructure Goal Four: To provide, maintain, and improve a cost-effective, safe and functional surface transportation system, objective 4.1) Support the ongoing street reconstruction, rehabilitation, and maintenance overlay programs, ensuring the timely maintenance, repair and reconstruction of the city's streets and bridges and Goal Five: To provide for, maintain and improve safe, accessible public sidewalks and steps throughout the community, where possible, objective 5.1) Support maintaining and improving the condition of public sidewalks, steps, walks, and handrails. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Reasonable Mobility and Clean Water. 141 DEPARTMENT: STATE PROGRAM: PROJECT TITLE: PROGRAM: 8C Water Department Business Type Water Main Replacements - Streets DEPARTMENT: 42 TOTAL PROJECT FD/CIP NO: 740-1405 COST $ 5,022,677 2016 2017 ACTUAL AMENDED BEYOND EXP BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 2022 A. EXPENDITURE ITEMS $ 9,248 $ 63,900 Design & Engineering $ 20,000 $ 386,300 $ 2,079 $ 497,500 Construction $ 180,000 $ 3,863,650 $ 11,327 $ 561,400 TOTAL $ — $ — $ 200,000 $ — $ — $ 4,249,950 B. PROJECT FINANCING $ 11,327 $ 561,400 Water Construction Fund $ 200,000 $ 4,249,950 $ 11,327 $ 561,400 TOTAL $ — $ — $ 200,000 $ — $ — $ 4,249,950 PROJECT DESCRIPTION This project provides for an ongoing annual water main replacement associated with the city street improvement program. JUSTIFICATION We have evaluated the integrity of water mains for the street improvement programs. Many sections of water mains, valves and hydrants have lost their integrity due to corrosion and weathering process. We will replace and repair these sections as part of the Street Improvement Program. This will ensure that the water system functions properly under the new concrete pavement and streets rescheduled to have an asphalt overlay. Funding for future water main replacement projects will be evaluated annually and in conjunction with street improvement projects city-wide. When the Street Improvement Program enters into the Keyway area behind ARC (formally Econofoods), we will need to replace many of the water mains due to the hot soil conditions in this area. 142 DEPARTMENT: STATE PROGRAM: PROJECT TITLE: PROGRAM: 8C TOTAL Water Department Business Type Water Main Replacements- Streets DEPARTMENT: 42 PROJECT FD/CIP NO: 740-1405 COST $ 5,022,677 BEYOND 2017-18 2018-19 2019-20 2020-21 2021-22 2022 Custer to Auburn (Sanitary Pro ect $ 165,000 8th Street Central -Washington) Cummins Street Loras College Wall $ 72 000 14th Street(Maple- Sycamore) $ 75,000 5th Street(White- Blu $ 265 000 11th Street Resurf White-Alley) $ 50,000 Central Ave Resurf 9th -21 st $ 200,000 Cedar Cross Road Reconstruction $ 285,000 16th Street(Bridge- Sycamore) $ 125,000 Chavenelle Rehab NWA- Radford $ 100,000 Bennet Algona to N Grandview $ 170,000 Bies (Pennsylvania- Century) $ 150,000 Sylvan (Pennsylvania-Century) $ 195,000 14th Street(White- Elm $ 98,000 7th St at Hill St Intersection $ 65,000 Asbury /Clarke Dr to JFK $ 675,000 Asbury/St. Ambrose to Clarke Dr $ 200 000 Asbury/University Intersection $ 40,000 Asbury/University to St. Ambrose $ 150,000 Century Drive $ 110,000 Century, Bies to End $ 180,000 E 7th St Central to Peavee $ 305 650 E 7th St Peavee to RR Bride $ 170,000 Hill St Mix Master $ 88,000 W 17th Cox to Clark 130,000 $ — $ — $ 200,0001$ — $ — $ 3,863,650 RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal One: To provide, maintain and improve a cost-effective, functional and self-supporting water utility system, objectives 1.1) Support an adequate water supply and 1.2) Support cost-effective delivery of water. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principles of Regional Economy, Smart Resource Use, Clean Water and Community Health & Safety. 143 DEPARTMENT: STATE PROGRAM: PROJECT TITLE: PROGRAM: 8C Water Department Business Type Southwest Arterial Water Main Extension DEPARTMENT: 42 TOTAL PROJECT FD/CIP NO: 740-2594 COST 360-2594 $ 6,805,880 2016 2017 ACTUAL AMENDED BEYOND EXP BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 2022 A. EXPENDITURE ITEMS $ 431,561 $ 354,947 Design & Engineering $ 120,000 $ 110,000 $ 1,100,580 $ 50,000 Land and R.O.W. $ 250,000 $ 27,357 $ 4,182,015 Construction $ 650,000 $ 630,000 $ 9,674,420 $ 458,918 $ 4,586,962 TOTAL $ 250,000 $ — $ 770,000 $ 740,000 $ — $10,775,000 B. PROJECT FINANCING $ 458,918 $ 3,833,962 Water Construction Fund $ 250,000 $ 770,000 $ 740,000 $10,775,000 $ 753,000 Housing TIF $ 458,918 1 7 4,586,962 TOTAL r-250,000 $ — $ 770,000 $ 740,000 $ — $10,775,000 PROJECT DESCRIPTION This project provides for the funding to provide water service to the Southwest Arterial corridor. JUSTIFICATION Water service is necessary to promote growth along the Southwest Arterial corridor. 144 DEPARTMENT: STATE PROGRAM: PROJECT TITLE: PROGRAM: 8C Water Department Business Type Southwest Arterial Water Main DEPARTMENT: 42 TOTAL Extension PROJECT FD/CIP NO: 740-2594 COST 360-2594 $ 6,805,880 BEYOND 2017-18 2018-19 2019-20 2020-21 2021-22 2022 South West Arterial Utility Easement $ 250,000 From N.Cascade Road to English Mill pump station $ 1,305,000 South West Arterial 12"water main (4th pressure zone)from $ 978,750 South West Arterial 16"water main (4th pressure zone)from $ 740,000 Lake Eleanor Road Water Main Loop Connection $ 115,000 Military Road 16"water main (from Key West Drive to S.W.Arterial) $ 345,000 HWY 151/61 off ramp to Olde Davenport Road 12"water main $ 295,000 South West Arterial 16"water main (from N.Cascade Road to HWY 151/61) $ 3,375,000 Key West Water Tower- 1.5 million gallons(3rd pressure zone) $ 4,300,000 Hwy 20 to Southwest Arterial Roundabout $ 770,000 English Mill Pump Station $ 1,200,000 English Mill Road 16"WP from S.W.Arterial to Crescent Ridge $ 1,900,000 $ 250,000 $ — $ 770,000 $ 740,000 $ — $ 13,813,750 RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal One: To provide, maintain and improve a cost-effective, functional and self-supporting water utility system, objectives 1.1) Support an adequate water supply and 1.2) Support cost-effective delivery of water. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principles of Regional Economy, Smart Resource Use, Clean Water and Community Health &Safety. 145 DEPARTMENT: STATE PROGRAM: PROJECT TITLE: PROGRAM: 8C Water Department Business Type Vacuum Filter Plant Process Upgrade DEPARTMENT: 42 TOTAL PROJECT FD/CIP NO: 740-2030 COST $ 230,000 2016 2017 ACTUAL AMENDED BEYOND EXP BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 2022 A. EXPENDITURE ITEMS Design & Engineering $ 30,000 Construction $ — $ 200,000 $ — $ — TOTAL $ 30,000 $ — $ 200,000 $ — $ — $ B. PROJECT FINANCING Water Construction Fund $ 30,000 $ 200,000 $ — $ — TOTAL $ 30,000 $ — $ 200,000 $ — $ — $ — PROJECT DESCRIPTION This project provides funding for the upgrade of the Vacuum Filter Plant Process. JUSTIFICATION The Vacuum Filter Plant is in need of process upgrades. An engineering study should be done to determine scope cost of this project. RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal One: To provide, maintain and improve a cost-effective, functional and self-supporting water utility system, objectives 1.2) Support cost-effective delivery of water, 1.3) Support a safe water supply that meets all local, state, and federal water quality standards and 1.4) Support ongoing improvements to the water plant and facilities and Environmental Quality Goal Two: To promote conservation practices that result in responsible use of non-renewable natural resources, objectives 2.2) Promote awareness and use of alternate, renewable resources, 2.3) Encourage green building principles and 2.4) Promote programs to improve energy efficiency, Goal Four: To protect and preserve existing water supplies and air quality and ensure that future water and air quality is safeguarded, objective 4.6) Promote ground water protection and adequate water quality and quantity of our streams and rivers by expanded infiltration, and Goal Five: To assure appropriate control, collection, disposal, and per capita reduction of stormwater, wastewater, solid wastes, and household hazardous wastes, objective 5.4) Promote a sanitary environment through the implementation of best management practices in the collection and disposal of stormwater and wastewater. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principles of Clean Water and Community Health &Safety. 146 DEPARTMENT: STATE PROGRAM: PROJECT TITLE: PROGRAM: 8C Water Department Business Type Bridge Repairs/Maintenance of the Water DEPARTMENT: 42 TOTAL Main Supply Line to City Island PROJECT FD/CIP NO: 740-2713 COST $ 30,000 2016 2017 ACTUAL AMENDED BEYOND EXP BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 2022 A. EXPENDITURE ITEMS Design & Engineering $ 10,000 Construction $ 20,000 $ — $ — TOTAL $ 30,000 $ — $ — $ — $ — $ B. PROJECT FINANCING Water Construction Fund $ 30,000 $ — $ — TOTAL $ 30,000 $ — $ — $ — $ — $ — PROJECT DESCRIPTION The City currently has 18 bridge structures under it's jurisdiction. This annual program provides for the biannual bridge inspection (a new Federal requirement), bridge program management and periodic preventative maintenance and repairs to the various bridges throughout the City. The Bridge Repair and Maintenance program includes painting, repair of spalled areas in the concrete deck, piers, wingwalls and barrier rail. Program funding is also used for the sealing of hairline cracks to prevent deterioration of reinforcing steel, maintain and repair expansion joints, and the repairs to armoring stone at abutments, inlet and outlet structures to prevent scour and undermining. During the inspection/repair work of the 16th Street bridge to City Island, we plan to have the 12"water main inspected and maintenance work performed. This water main is currently supported from under the bridge deck with protected insulation and is the only water main that supplies domestic and fire protection water to the Island. JUSTIFICATION The City's bridges are inspected every two years. The last inspection, dated August 2013, indicated that several of the City's bridges require minor repairs. As a result of the new federal bridge inspection standards, the annual Bridge Repair and Maintenance program funding has been increased to allow for the preventative maintenance and repairs to the various bridge structures throughout the City, as needed. RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal Four: To provide, maintain, and improve a cost-effective, safe and functional surface transportation system, objectives 4.1) Support the ongoing street reconstruction, rehabilitation, and maintenance overlay programs, ensuring the timely maintenance, repair and reconstruction of the city's streets and bridges and 4.5) Support extending the life and improve the quality of the city street system through preventative maintenance programs and Transportation Goal One: To provide, maintain and improve safe and efficient movement on the City's street system, objective 1.1) Support continuing the ongoing street construction program, providing for timely maintenance, repair and reconstruction of the City street system. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Reasonable Mobility 147 DEPARTMENT: STATE PROGRAM: PROJECT TITLE: PROGRAM: 8C Water Department Business Type Bulk CO2 Tank Replacement DEPARTMENT: 42 TOTAL PROJECT FD/CIP NO: 740-2714 COST $ 75,000 2016 2017 ACTUAL AMENDED BEYOND EXP BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 2022 A. EXPENDITURE ITEMS Equipment $ 75,000 $ — $ — TOTAL $ 75,000 $ — $ — $ — $ — $ B. PROJECT FINANCING Water Construction Fund $ 75,000 $ — $ — TOTAL $ 75,000 $ PROJECT DESCRIPTION This project provides the funding to replace the bulk carbon dioxide tank and associated equipment JUSTIFICATION The carbon dioxide bulk tank and associated equipment is aged and is in need of replacement. The current tank is the original which dates back to the 1950s. RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal One: To provide, maintain and improve a cost-effective, functional and self-supporting water utility system, objectives 1.1) Support an adequate water supply, 1.2) Support cost-effective delivery of water and 1.3) Support a safe water supply that meets all local, state, and federal water quality standards. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Clean Water and Community Health &Safety. 148 DEPARTMENT: STATE PROGRAM: PROJECT TITLE: PROGRAM: 8C Water Department Business Type South end water main loop DEPARTMENT: 42 TOTAL Rockdale Road - Manson Road PROJECT FD/CIP NO: 740-2349 COST $ 155,000 2016 2017 ACTUAL AMENDED BEYOND EXP BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 2022 A. EXPENDITURE ITEMS Design & Engineering $ 15,500 Construction $ 139,500 $ — $ — TOTAL $ 155,000 $ — $ — $ — $ — $ B. PROJECT FINANCING Water Construction Fund $ 155,000 $ — $ — TOTAL $ 155,000 $ — $ — $ — $ — $ — PROJECT DESCRIPTION Project consist of providing approx. 875 feet of 8" PVC water main from existing 8" water main located near Manson Road to the rear of the proposed South Pointe subdivision. This water main will be installed with-in a public utility easement adjacent to proposed public sanitary sewer. JUSTIFICATION This project will create a second water main loop to the south end of town (Keywest area -Airport [6th] pressure zone) along with the development of the South Pointe subdivision on Rockdale Road. Creating a water main loop from Mason Road to Rockdale Road through the South Pointe Subdivision. RELATIONSHIP TO OTHER PROJECTS This project supports the Comprehensive Plan's Infrastructure Goal One: To provide, maintain and improve a cost-effective, functional and self-supporting water utility system, objectives 1.1) Support an adequate water supply and 1.2) Support cost-effective delivery of water. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principles of Regional Economy, Smart Resource Use, Principles of Clean Water and Community Health and Safety. 149 DEPARTMENT: STATE PROGRAM: PROJECT TITLE: PROGRAM: 8C Water Department Business Type West Side Water System Connection to DEPARTMENT: 42 TOTAL New Water Tower PROJECT FD/CIP NO: 740-2703 COST $ 4,396,500 2016 2017 ACTUAL AMENDED BEYOND EXP BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 2022 A. EXPENDITURE ITEMS Construction $ 4,045,000 Design & Engineering $ 351,500 $ — $ — TOTAL $ 4,396,500 $ — $ — $ — $ — $ B. PROJECT FINANCING State Revolving Fund Loan $ 4,396,500 $ — $ — TOTAL $ 4,396,500 $ — $ — $ — $ — $ — PROJECT DESCRIPTION Project consists of one pump station located at the corner of Stone Valley Drive and English Mill Road. Pump station will have the capabilities of converting 4th pressure zone water into the new 7th pressure zone (West Side Water System) and future 3rd pressure zone to 4th pressure zone system. Approx. 5,600 feet of 12"water main along English Mill Road, Approx. 5,500 feet of 12"water main along North Cascade Road connecting too the West Side Water System and 5,600 feet of 12"water main along Highway 20 from North Cascade Road to near the existing ground storage reservoir. Pump Station $ 1,050,000 English Mill Road water main $ 705,000 North Cascade Road water main $ 615,000 Water meter conversion $ 202,000 Fire hydrant installation $ 100,000 Well abandonment (1-deep) $ 30,000 SCADA system $ 35,000 Tower Gridbee Mixer $ 10,000 Building modification $ 8,000 Rock excavation $ 35,000 Engineering $ 241,600 Contingency $ 60,000 English Mill Road connection $ 40,000 Highway 20 water main $ 750,000 Water meter conversion $ 170,000 Fire hydrant installation $ 30,000 Well abandonment (2) $ 30,000 Ground storage tank demo $ 35,000 150 Utility easement(s) $ 20,000 Rock excavation $ 55,000 Engineering $ 109,900 Contingency $ 65,000 Sub-total $ 4,396,500 JUSTIFICATION This project will support the agreement to supply water to the West Side Water System through a proposed pump station and distribution water mains. Expanding the City water customer base in addition to providing a third water source from the 3rd pressure zone to the 4th pressure zone. Provides much benefit to the southern end (West Industrial Park) of the 4th pressure zone as this pump station is adjacent too the West Industrial Park with the JFK Water Tower being over six miles away. RELATIONSHIP TO OTHER PROJECTS This project supports the Comprehensive Plan's Infrastructure Goal One: To provide, maintain and improve a cost-effective, functional and self-supporting water utility system, objectives 1.1) Support an adequate water supply and 1.2) Support cost-effective delivery of water. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principles of Regional Economy, Smart resource Use, Clean Water and Community Health and Safety. 151 DEPARTMENT: STATE PROGRAM: PROJECT TITLE: PROGRAM: 8C Water Department Business Type Water Main Replacements - Sewer DEPARTMENT: 42 TOTAL Consent Decree PROJECT FD/CIP NO: 740-2658 COST $ 362,150 2016 2017 ACTUAL AMENDED BEYOND EXP BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 2022 A. EXPENDITURE ITEMS $ 31,350 Design & Engineering $ 5,800 $ 76,200 $ 209,000 Construction $ 116,000 $ 825,000 $ — $ 240,350 TOTAL $ 121,800 $ — $ — $ — $ — $ 901,200 B. PROJECT FINANCING $ 240,350 Water Construction Fund $ 121,800 $ 901,200 $ — $ 240,350 TOTAL $ 121,800 $ — $ — $ — $ — $ 901,200 PROJECT DESCRIPTION This project provides for an ongoing annual water main replacement associated with the City sanitary sewer improvement and consent decree program JUSTIFICATION We have evaluated the integrity of water mains for the sanitary sewer and consent decree programs. Many sections of water mains, valves and hydrants have lost their integrity due to corrosion and weathering process. We will replace and repair these sections as part of the sanitary sewer and consent decree Program. This will ensure that the water system functions properly under the new concrete pavement and streets rescheduled to have an asphalt project overlay (not City public works overlay program). 2017-18 2018-19 2019-20 2020-21 BEYOND 2021 BEYOND 2022 Heeb Street(Sanitary Pro ect $ 102,000 Loras Blvd. (Walnut to Prairie St. $ 45,000 Monroe Street S.S. Extension $ 65,000 Brunswick Street S.S. pro ect $ 65 000 Fairway Drive S.S. pro ect Bunkerhill $ 150,000 Southgate S.S. pro ect easement $ 78,000 King Street S.S. pro ect $ 105,000 Washington St. S.S. 24th to 25th pro ect $ 12,000 Hempstead St. S.S. pro ect $ 120,000 Grove Terrace S.S. pro ect $ 95 000 Marquette Place $ 104,000 Kauffmann Ave Elm to Kane St Custer&Auburn 165,000 Total $ 116 000 $ — $ — $ — $ — $ 825,000 152 RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal One: To provide, maintain and improve a cost-effective, functional and self-supporting water utility system, objectives 1.1) Support an adequate water supply and 1.2) Support cost-effective delivery of water. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Community Design, Regional Economy, Smart Resource Use, Clean Water and Community Health & Safety 153 DEPARTMENT: STATE PROGRAM: PROJECT TITLE: PROGRAM: 8C Water Department Business Type City Water Department Public Lead Line DEPARTMENT: 42 TOTAL water main replacement PROJECT FD/CIP NO: 740- COST $ 234,000 2016 2017 ACTUAL AMENDED BEYOND EXP BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 2022 A. EXPENDITURE ITEMS Design & Engineering $ 4,600 $ 10,200 $ 6,500 $ 7,300 Construction $ 41,400 $ 39,800 $ 58,500 $ 65,700 $ — $ — TOTAL $ — $ 46,000 $ 50,000 $ 65,000 $ 73,000 $ B. PROJECT FINANCING Water Construction Fund $ 46,000 $ 50,000 $ 65,000 $ 73,000 $ — $ — TOTAL $ — $ 46,000 $ 50,000 $ 65,000 $ 73,000 $ — PROJECT DESCRIPTION This project provides funding for the removal and replacement of the Water Departments existing public lead water mains. Scheduled in phases, Union Street FY 17-18, Austin Street FY 18-19, May Place FY 19-20 and Washington Street FY 20-21. JUSTIFICATION This project will eliminate the Water Department's public lead line water mains that were installed in the early 1920's. A phased proactive approach to upgrade the water distribution system. RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal One: To provide, maintain and improve a cost-effective, functional and self-supporting water utility system, objectives 1.1) Support an adequate water supply, 1.2) Support cost-effective delivery of water, 1.3) Support a safe water supply that meets all local, state and federal water quality standards, 1.4) Support ongoing improvements to the water distribution system. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Clean Water and Community Health and Safety. 154 DEPARTMENT: STATE PROGRAM: PROJECT TITLE: PROGRAM: 8C Water Department Business Type Tamarack Park Drive/Wood Gate Drive DEPARTMENT: 42 TOTAL Frontage Road Water Main Extension PROJECT FD/CIP NO: 740- COST $ 550,000 2016 2017 ACTUAL AMENDED BEYOND EXP BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 2022 A. EXPENDITURE ITEMS Design & Engineering $ 79,000 Construction $ 321,000 $ 150,000 $ 515,000 $ — $ — TOTAL $ — $ — $ 400,000 $ 150,000 $ — $ 515,000 B. PROJECT FINANCING Water Construction Fund $ 400,000 $ 150,000 $ 515,000 $ — $ — TOTAL $ — $ — $ 400,000 $ 150,000 $ — $ 515,000 PROJECT DESCRIPTION Phase one (FY 17-18) includes the installation of a 16" diameter water main from near Elmwood Drive and Highway 151/61 intersection to north property line (Tamarack Park Drive) for future connection with the South West Arterial water main and continuing south to the intersection of Tamarack Park Drive and Highway 151/61. Phase two (FY18-19) includes continuing the 12"diameter water main installation from the end of Phase one (Tamarack Park Drive and Highway 151/61) to Wood Gate Drive.Installation of a 12"water main from Highway intersection to the south property line for future loop to support future growth and Airport pressure zone. JUSTIFICATION This project will support the pre-annexation agreement of Tamarack Park development. Per agreement, water main is planned to be installed with in a two year period of request or maximum of seven years from approved agreement and future development growth along the west side of Highway 151/61. RELATIONSHIP TO OTHER PROJECTS This water main project will support the South West Arterial water main in helping to create a water main loop distribution system from North Cascade Road to the Key West Area with future support of a second feed to the Airport pressure zone. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Community Design, Regional Economy, Smart Resource use and Community Health &Safety. 155 DEPARTMENT: STATE PROGRAM: PROJECT TITLE: PROGRAM: 8C Water Department Business Type 20"Transmission Main, 12" and 8"Water DEPARTMENT: 42 TOTAL Main Relocation/Replacement/Extension PROJECT FD/CIP NO: 740-2261 COST $ 400,000 2016 2017 ACTUAL AMENDED BEYOND EXP BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 2022 A. EXPENDITURE ITEMS Design & Engineering $ 100,000 Construction $ 300,000 $ — $ — TOTAL $ — $ 400,000 $ — $ — $ — $ B. PROJECT FINANCING Water Construction Fund $ 400,000 $ — $ — TOTAL $ — $ 400,000 $ — $ — $ — $ — PROJECT DESCRIPTION This project provides for the installation of a 20" main transmission line from 8th to 9th and 10th to 12th Streets. Improvements have been completed from 9th to 10th street, leaving 8th to 9th street and 10th to 12th to be completed. Valves and fire hydrants along with lead water service lines will be updated. Central Avenue street improvements from 9th to 21 st are currently scheduled in FY 2018-29. JUSTIFICATION The existing city 20" main transmission line was installed in the 1880's and is currently located in the alley between Central Ave. and Iowa St. This main is the single large transmission line providing service to the south and west ends of our city. With upcoming street repairs planned by the Department of Transportation (DOT) for Central Ave., the best location and optimum flow design capacity will be on Central Ave. from 12th St. to 8th St. RELATIONSHIP TO OTHER PROJECTS This project supports the Comprehensive Plan's Infrastructure Goal One: To provide, maintain and improve a cost-effective, functional and self-supporting water utility system, objectives 1.1) Support an adequate water supply and 1.2) Support cost-effective delivery of water. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principles of Clean Water and Community Health &Safety. 156 DEPARTMENT: STATE PROGRAM: PROJECT TITLE: PROGRAM: 8C Water Department Business Type Raw Water Transmission Lines DEPARTMENT: 42 TOTAL PROJECT FD/CIP NO: 740-2528 COST $ 75,000 2016 2017 ACTUAL AMENDED BEYOND EXP BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 2022 A. EXPENDITURE ITEMS Construction $ 75,000 $ — $ — TOTAL $ — $ — $ 75,000 $ — $ — $ B. PROJECT FINANCING Water Construction Fund $ 75,000 $ — $ — TOTAL $ — $ — $ 75,000 $ — $ — $ — PROJECT DESCRIPTION Raw water transmission lines accumulate iron and sediment and over time will become restricted and not allow water to flow freely. The raw water transmission lines need to be cleaned or pigged to remove mineral accumulation and remove sediment. This project provides for an engineering study and services required to clean the transmission lines from the shallow wellfield to the treatment plant. JUSTIFICATION A proactive raw water transmission line maintenance program will optimize well efficiency and improve water quality, lower daily, peak and lifetime power use. RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal One: To provide, maintain and improve a cost-effective, functional and self-supporting water utility system, objectives 1.1) Support an adequate water supply, 1.2) Support cost-effective delivery of water, 1.3) Support a safe water supply that meets all local, state, and federal water quality standards, 1.4) Support ongoing improvements to the water plant and facilities and 1.5) Support ongoing improvements to the water distribution system. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principles of Smart Energy Use, Smart Resource Use, Clean Water and Community Health &Safety 157 DEPARTMENT: STATE PROGRAM: PROJECT TITLE: PROGRAM: 8C Water Department Business Type English Ridge Water Main DEPARTMENT: 42 TOTAL PROJECT FD/CIP NO: 360- COST $ 330,000 2016 2017 ACTUAL AMENDED BEYOND EXP BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 2022 A. EXPENDITURE ITEMS Design & Engineering $ 82,500 Construction $ 247,500 $ — $ — TOTAL $ — $ — $ — $ — $ 330,000 $ B. PROJECT FINANCING English Ridge Housing TIF $ 330,000 $ — $ — TOTAL $ — $ — $ — $ — $ 330,000 $ — PROJECT DESCRIPTION Project provides 12"diameter water main on the proposed frontage road from South West Arterial (round-about) to Stone Valley Drive.. JUSTIFICATION English Mill Road TIFF project supports the creation of a water distribution looped system of domestic and fire protection water between the 3rd and 4th pressure zones in support of the English Ridge Subdivision and South West Arterial development. RELATIONSHIP TO OTHER PROJECTS English Mill Road TIFF project will be phased with the construction of South West Arterial project. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Community Design, Regional Economy, Smart Resource Use, Clean Water and Community Health &Safety 158 Water Department -1- This page intentionally left blank. _2_ WATER DEPARTMENT FY 2016 FY 2017 FY 2018 % Change From Budget Highlights Actual Budget Requested FY 2017 Budget Expenses Employee Expense 2,295,218 2,409,275 2,302,821 (4.4)% Supplies and Services 2,217,827 2,467,222 2,466,500 — % Machinery and Equipment 258,988 1,155,395 875,824 (24.2)% Administrative Overhead Recharges 101 — 264,667 — % Finance Utility Billing 156,437 174,607 170,662 (2.3)% Payment in Lieu of Taxes 142,884 142,884 142,884 — % Payment to Construction Fund 354,466 1,012,000 1,157,000 14.3 % Debt Service 1,565,437 1,647,089 1,653,146 0.4 % Total Expenses 6,991,358 9,008,472 9,033,504 0.3 % Resources Operating Revenue 8,906,782 9,009,007 9,296,823 3.2 % Total Resources 8,906,782 9,009,007 9,296,823 3.2 % Net Operating Surplus (Deficit) 1,915,424 535 263,319 262,784 Personnel -Authorized FTE 25.57 25.57 25.57 Water User Fee Rate Increase 10% 3% 3% Revenue 1% Rate Increase Generates $ 76,776 Improvement Package Summary 1 of 4 This improvement package would provide funding for a full-time Water Distribution Field Inspector (GE-2913) to increase the efficiency and quantity of the operation, documentation of water distribution piping system from the field and projects being completed within the City. This position would be responsible for assisting the Water Distribution Engineering Assistant, GIS Specialist and other staff with the documentation of the City's operation, maintenance and construction of the water treatment plant, pump stations, tanks, towers, wells and the water distribution network. This person would field inspect all water field activities both public and private in accordance with Federal, State and local codes and ordinances. Produce as-built drawings of new or replaced water assets in addition to the collection of GPS coordinates for input into the City's Geographic Information System. As the city continues to grow and the water system becomes of age creates a demand on staff time to focus on its growth and maintenance. This position will support the proactive sustainable approach of being as effective and efficient with the operation in providing uninterrupted service to the citizens, contractors, developers and engineering firms that are served. Non- Recurring includes a smart phone ($375) and computer ($2,100). Related Cost: $ 71,081 Water User Fees Recurring Recommend - No Related Cost: $ 2,475 Water User Fees Non-Recurring Total Cost: $ 73,556 Water Rate Impact: 0.96% Activity: Water Distribution -3- 2 of 4 This improvement package would provide funding for one additional mobile GIS laptop for the recently purchased Water Meter Truck. Currently Water Distribution has five mobile GIS laptops permanently mounted in the five Distribution work vehicles and NO mobile GIS laptops in both of our Water Meter vehicles. This improvement package is a request for one additional mobile GIS laptop for the recently purchased Water Meter Truck. This will provide the Meter staff with the same level of City computer data and access as our Distribution staff. This will provide efficiency for staff to retrieve and enter data in the City's geographic Information System (GIS), view water distribution maps, meter records and enter various information into operations database, including Work Orders, Daily Activities and other activities. This is a proactive sustainable approach of being as effective and efficient with the operation in providing uninterrupted service to the citizens, contractors, developers and engineering firms that are served. Related Cost: $ 5,500 Water User Fees Non-Recurring Recommend -Yes Water Rate Impact: 0.07% Activity: Water Meters 3 of 4 This improvement package would provide funding for the purchase of two tablets which will help Distribution and Meter staff collect and enter data in to the City's Geographical Information System (GIS) directly from the field. The tablets will assist in capturing GPS points of new and existing water fixtures, view water distribution maps and enter various information into operations database, including Work Orders, Daily Activities and other activities while in the field. In addition, the tablets allow office staff a access to the City network while in the field. This is a proactive sustainable approach of being as effective and efficient with the operation in providing uninterrupted service to the citizens, contractors, developers and engineering firms that are served. Related Cost: $ 2,080 Water User Fees Non-Recurring Recommend -Yes Related Cost: $ 960 Water User Fees Recurring Total Cost: $ 3,040 Water Rate Impact: 0.04% Activity: Water Distribution 4 of 4 This improvement package would provide funding for the purchase of one new GPS unit with an external antenna. This GPS unit will work wirelessly with the tablets for real time placement of water features in the field while infrastructure is being installed. City Engineering has had much success with this exact same unit over the last couple of years. This is a proactive sustainable approach of being as effective and efficient with the operation in providing uninterrupted service to the citizens, contractors, developers and engineering firms that are served. Related Cost: $ 2,644 Water User Fees Non-Recurring Recommend -Yes Water Rate Impact: 0.03% Activity: Water Distribution -4- Significant Line Items Employee Expense 1. FY 2018 employee expense reflects a 2.0% wage package increase. 2. The Iowa Public Employee Retirement System (I PERS) City contribution is unchanged at 8.93% and the employee contribution is unchanged at 6.18% in FY 2018. 3. The City portion of health insurance expense is unchanged from $1,325 in FY 2017 to $1,325 in FY 2018 per month per contract. 4. Overtime unchanged from $90,040 in FY 2017 to $90,040 in FY 2018. FY 2016 Actual was $63,023. 5. Sick Leave Payout is increased from $7,039 in FY 2017 to $16,474 in FY 2018. 6. The Water Plant Manager position is frozen until June 30, 2018 with cost savings of$125,359 in FY 2018. Supplies & Services 7. Property Insurance decreased from $87,871 in FY FY 2017 to $73,764 in FY 2018.A new insurance contract was negotiated which decreased -16%. 8. Electricity Utility Expense increased from $563,243 in FY 2017 to $603,738 in FY 2018 based on FY 2016 Actual $580,517 and the addition of the Airport pump stations. 9. Sales Tax expense increased from$445,000 in FY 2017 to $476,890 in FY 2018 based on unchanged water rates in FY 2018. This expense is directly offset by Sales Tax Revenue. 10. Machinery and Equipment Maintenance decreased from $132,368 in FY 2017 to $128,233 in FY 2018 based on FY 2017 less -3%. 11. Costs for Fluoride, Phosphate, Chlorine, Lime, and Polymer expense (water processing materials) are projected to increased from $389,428 in FY 2017 to $396,900 in FY 2018 based on FY 2016 Actual $379,783 plus 5%. 12. Hauling Services increased from $139,699 in FY 2017 to $148,250 in FY 2018 based on FY 2016 Actual of$141,199 plus 5%. It is anticipated that the hauling contract for lime sludge will change. 13. Property Maintenance increased from $57,951 in FY 2017 to $73,088 in FY 2018. FY 2016 Actual was $43,615. This line item has been increased to reflect the additional pump station buildings constructed and other property that will require property maintenance. 14. Pipe Special Fittings increased from $50,000 in FY 2017 to $70,000 in FY 2018. In previous fiscal years, the majority of pipe special fittings were coded to the water main replacement line item; however in FY 2018 these expenses are now being recorded to the proper line item. 15. Valves is decreased from $66,000 in FY 2017 to $10,000 in FY 2018. FY 2016 Actual was $967. 16. Engineering Division Services decreased from $61,000 in FY 2017 to $0 in FY 2018 due to all engineering charges being directly charged to Water capital projects. -5- 17. Environment Testing/Monitoring increased from $30,811 in FY 2017 to $45,000 in FY 2018. FY 2016 Actual was $33,685. It is expected that there will be increased samples due to boil advisories and chlorine monitoring Machinery & Equipment 18. Equipment replacement items at the maintenance level include ($875,824): Meters Software $ 1,500 Large Water Meters $ 15,000 Plant Operation & Maintenance 3/4 Ton Extended Cab 4x4 Truck $ 42,000 Laboratory Equipment $ 3,500 Shop Equipment $ 1,000 Pumps $ 1,000 Smart Phone (3) $ 1,125 Water Distribution System Hydrants $ 70,000 Emergency Radios $ 46,175 Shop Equipment $ 1,200 Barricades $ 1,000 Test Equipment $ 1,000 Smart Phone $ 800 One Ton Dump Truck $ 70,000 Software $ 500 Annual Maintenance Projects Automatic Meter Reading System Maintenance $ 15,000 Pump Replace Vacuum Filter $ 20,000 Filter Maintenance Program $ 25,000 Generator Maintenance Program $ 18,000 Large Valve Replacement (2) $ 25,000 Internal Lines Loan $ 45,000 Water Main Replacements (Repair of 70 mains) $ 321,500 Large Water Meters $ 68,500 Water Valve Box Maintenance (Public Works) $ 20,000 Water Meter Testing $ 25,000 Well Maintenance Program $ 26,800 Recommended Improvement Packages $ 10,224 Total $ 875,824 -6- Debt Service 19. Debt service reflects repayment to ($1,653,146): Final Call Amount Debt Series Source Purpose Payment Date $ 62,558 SRF 2007A Water Fees Clear Wells 2028 $ 118,528 Revenue 2008D Water Fees Water Improvements 2023 2016 $ 218,280 SRF Series 2009 Water Fees Meter Change-Out 2031 $ 379,700 Revenue 2010D Water Fees Water Improvements 2030 2017 $ 111,119 G.O. 2011A Water Fees Water Improvements 2031 2018 $ 42,794 G.O. 2012E Water Fees Water Improvements 2032 2018 $ 127,250 G.O. 2012D Water Fees Water Improvements 2033 2019 $ 295,131 G.O. 20148 Water Fees Water Improvements 2032 2021 $ 45,888 G.O. 2016C Water Fees Water Improvements 2033 2024 $ 251,898 Planned SRF Water Fees CIWA Purchase/Imp 2036 $1,653,146 Total Water Debt Service Revenue 20. Water User Fees increased from $8,023,216 in FY 2017 to $8,149,680 in FY 2018. Increase is based on FY 2016 Actual of$7,677,554 plus the FY 2017 rate increase of 3% and the FY 2018 projected rate increase of 3%. 21. Flat Rates decreased from $23,581 in FY 2017 to $20,000 in FY 2018 based on FY 2016 Actual of $20,685. 22. Fire Protection Rates increased from $134,101 in FY 2017 to $150,000 in FY 2018 based on FY 2016 Actual of$155,143. 23. Taps increased from $30,344 in FY 2017 to $33,000 in FY 2018. FY 2016 Actual was $42,056. 24. Tap Service increased from $17,221 in FY 2017 to $22,500 in FY 2018 based on FY 2016 Actual of $36,260. 25. Connection Charge Front Footage is increased from $35,570 in FY 2017 to $49,435 in FY 2018. FY 2016 Actual was $75,905. 26. Backflow Prevention Administrative Fees increased from$61,026 in FY 2017 to $66,038 in FY 2018 based on FY 2016 Actual of$66,038. This is the $25 annual fee charged to all customers with a backflow device. 27. Penalties increased from $80,109 in FY 2017 to $81,092 in FY 2018 based on FY 2016 Actual of $81,581. 28. Tower Monthly Rental decreased from $91,621 in FY 2017 to $80,183 in FY 2018 based on FY 2016 Actual of$80,183. 29. Sales Tax Collected increased from $445,000 in FY 2017 to $476,890 in FY 2018 based on the rate increase for water fees. This line item off-sets the sales tax expense. -7- This page intentionally left blank. _g_ WATER DEPARTMENT The Water Department ensures our community has high quality, safe, reliable and affordable drinking water. Water Department Plant Water Administration Operations and Distribution Water Meters Maintenance SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES PLANNING The Water Department is engaged in PEOPLE conscientious, strategic planning which allows for maintaining compliance with the Employees of the Water state and federal regulatory agencies in Department are provided training order to provide the highest quality, safe to ensure the maintenance of the and cost effective drinking water possible. appropriate licenses required by the Iowa Department of Natural Resources. Other job-related educational training is provided to broaden employee skills and increase productivity. PARTNERSHIPS The Water Department is involved in Community Activities/Partnerships/ Outreach programs such as Water Conservation Educational Program and the Smarter City Initiative. The Water Department provides tours of its Eagle Point Treatment Plant to local schools and organizations. -9- WATER DEPARTMENT Resources and Property Tax Support $8,906,782 $9,009,007 $9,296,823 $9,000,000 $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 $0 Operating Revenue FY 2016 FY 2017 111 FY 2018 The Water Department is supported by 25.57 full-time equivalent employees, which accounts for 25.49% of the department expense as seen below. Overall, the department's expenses are expected to increase by 0.28% in FY 2018 compared to FY 2017. Expenditures by Category by Fiscal Year $3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 $0 m cn m D c n o 3C: -0 Q _ F o m o _0 c 3 O N 0- o C/) CD F 3 O 00 2 m r EDO �. Q S 3 (D (p N N C (3p Q N �. (D Cn FY 2016 FY 2017 FY 2018 -10- WATER DEPARTMENT Administration Overview The Dubuque Water Department is dedicated to producing and delivering drinking water that is in compliance with all state and federal drinking water standards. We continually strive to adopt new and better methods of delivering the best quality drinking water to the citizens of Dubuque in the most cost-effective manner. Water Department Administration is responsible for the preparation of operating and capital budgets, analysis of rate structure, interacting with the state and federal regulatory agencies, evaluation and coordination of treatment facility operations and the water distribution system functions. Water Administration Funding Summary FY 2016 Actual FY 2017 Budget FY 2018 Requested Expenditures $2,282,583 $2,426,667 $2,417,082 Resources $— $— $— Water Administration Position Summary FY 2018 Water Department Manager 1.00 Secretary 0.50 GIS Specialist 1.00 Total FT Equivalent Employees 2.50 Highlights of Fiscal Year 2016 j. Airport Water Main Extension- 19,981 feet(3.8 miles)of varying sizes of water main pipe including fire hydrants, valves, two pump stations and a 500,000 gallon reservoir -11- WATER DEPARTMENT Future Initiatives • Maintain appropriate staffing levels to ensure proper functioning of utility • Provide industry related training to maintain licensing and expand the skill set of Water Department employees • Utility extensions to support areas of future growth verrormance Measures Code Compliance -Activity Statement Provide management, administrative and public information services to internal and external customers while ensuring the efficient daily operation of the Dubuque Fire Department. ""Goal: Financially Responsible & High Performance Organization 11t Outcome #1: Maintain a financially viable water utility Financial viability allows the Water Department to achieve its operating objectives and allows the department to fulfill its mission over the long term. Outcome #2: Strategic planning of Water Department activities Strategic planning enables the Water Department to focus the energy, resources, and time of everyone in the organization in the same direction to become more efficient and cost-effective Plant Operations and Maintenance Overview Plant Operations and Maintenance ensures that water used for domestic, commercial and industrial purposes is safe for drinking and is supplied at sufficient volumes to meet the needs of our community as well as provide for fire protection. Responsible for the management of equipment and chemicals used to treat and disinfect groundwater for human consumption and to maintain compliance with all Federal, State and Local water quality standards. Over two hundred tests a day are performed by water treatment plant operators. In addition to these tests, the Dubuque Water & Resource Recovery Laboratory performs over 60 bacteriological analysis of our drinking water on a monthly basis. Other compliance related testing is performed by the University of Iowa Hygienic Laboratory and Keystone Laboratories. All of these analytical measures ensure that the water reaching your home is safe to drink. -12- WATER DEPARTMENT Plant Operations and Maintenance Funding Summary FV 2016 FV 2017 Actual Budget FV 2018 Requested Expenditures $2,457,487 $2,525,856 $2,525,835 Resources $489 $200 $250 Plant Operations and Maintenance Position Summary FV 2018 Water Plant Manager 1.00 Electronic Technician 1.00 Equipment Mechanic 1.00 Plant Operator 11 5.00 Plant Operator III &IV 3.00 Total FT Equivalent Employees 11.00 Future Initiatives • Maintain the operations and maintenance of the Eagle Point Water Plant and all associated storage, pumping and well facilities in the most environmentally conscious manner • Ensure continued compliance with all regulatory agencies Performance Measures Plant Operations and Maintenance -Activity Statement Protect, preserve and promote the public health and welfare of the residents of the city of Dubuque by effectively and efficiently managing, maintaining and operating the Eagle Point Water Treatment Plant. (P�Goal: Environmental Integrity 1 Outcome#1: Ensure proper treatment of drinking water that meets or exceeds drinking water regulations Drinking water is one of our most vital resources and is essential to human health. The Eagle Point Water Treatment Plant delivers an average of 7 million gallons of clean water each day to our homes, schools and businesses which is then used for cooking, drinking, cleaning, bathing, watering our lawns and so forth. -13- WATER DEPARTMENT I�Ellll. FINISHED WATER TAP REPORT COMPLIANCE IN MALE K e ANAlY1E MCL/AL Mf16 TYPE VALUE MIN MOAIE xaunon ICAI SOURCE . Erosion of natural Barium Z Z SGL 0.0201 NIA N/A 09/04/2012 NO deposits Erosion of natural r r r vadeposits:Added to Fluoride a d MCL 0.69 036 1.62 2014 NO water duringtrcatmerrc process _ Runofffrom fertilizer use;leaching from Nitrate 10 10 SGL 0.6 0.5 0.6 2014 NO septic tanks,sewage; erosion of natural deposits Erosion of natural - I Sodium N/A N/A SGL 14 N/A N/A 09/04/2012 NO deposits;Added to W water duringtrcatment II process DISTRIBUTION O• ANALYZE Mo./AL MELG/MRIX COMPLUNQ SAMPLE DATE xoumx TYPICAL SOURCE G TYPE VALUE MIN MAX Total Chlorine(ppm) 4A 4.0 RAA 1.0 038 116 2014 NO Water additive used:o .. control microbes Presence in Presence in >5%of >5%of Naturally present in the Total Coliform Bacteria monthly monthly TCR 1.0 NO 1 10/31/2o1a No environment samples samples Total Haloacetic Acids By-products of drinking 60 N/A LRAA 11.00 NO 22.00 2(114 NO water disinfection (Ppb) Total Trihalomethanes 80 N/A LRAA 42.00 21.00 54.00 2014 NO By-productsofdrinking (ppb) water chlorination ANALYTE COMPLIANCE TYPICAL SOURCE ,Yre4f42N_ dd TYPE I WA Corrosion of household COPppr plumbing systems; 1.3 1.3 90th 0.0100 NO 0.0100 30 0 2014 NO Erosion of natural (PPM) deposits;Leaching from wood preservatives / f / Corrosion of household Lead(ppb) 15 0 90th 4.00 NO 13 30 0 2014 NO plumbing systems; Erosion of natural deposits The 2015 Water Quality Report can be downloaded at http://cityofdubupue.orp/DocumentCenter/View/24076 Outcome #2: Produce high quality water at the required pressures and volumes Maintaining the proper pressures and volumes ensures adequate fire suppression abilities and consumer demand ?�ajfer ?MfIr 1. ANIF C3aAri 3.000 941 2,902 2.900 2,859 2.863 2,8115 2,797 2,800 2,700 2,638 2,641 2,600 2,538 2,539 2,500 MOO 2,300 FIro6 rV'07 ErOg 1`11`09 rIr10 rV'll 1`11'12 rV73 Er14 FV'15 -14- WATER DEPARTMENT DID • Dubuque's , water comes from wells. There are five locatedshallow wells at - A.Y McDonald Park and four .--. wells located around Treatment PLant on Hawthorne Street. Distribution Overview The function of the Water Distribution Division is to safely transport potable water from the source to point of use. Distribution is also responsible for the machinery, equipment, materials and personnel required to repair main breaks; install water mains, control valves and fire hydrants and assist other sections of the Water Department. It is our goal to operate and maintain a water distribution system consistent with established procedures recognized by the American Water Works Association for efficient management practices and to meet Federal, State and local rules and regulations Water Distribution Funding Summary FY 2016 Actual FY 2017 Budget FY 2018 Requested Expenditures $1,568,310 $2,586,311 $2,895,453 Resources $8,786,038 $8,914,756 $9,137,641 Water Distribution Position Summary FY 2018 Equipment Operator II 2.00 Water Distribution Maintenance Worker 4.00 Water Distribution Foreman 1.00 Water Distribution Supervisor 1.00 Water Engineering Assistant 1.00 Custodian 1 0.07 Total FT Equivalent Employees 9.07 Highlights of the Year • Street Reconstruction/Engineering Projects • Purchase of the Central Iowa Water Association -15- WATER DEPARTMENT Future Initiatives • The Water Distribution Division is prepared to replace; as needed, the aged, existing water main, fire hydrants, control valves and lead service lines on construction projects in partnership with the Engineering and Public Works Departments. Performance Measures Water Distribution -ActivityStatement Operate and maintain a water distribution system consistent with established procedures recognized by the American Water Works Association for efficient management practices. JGoal: Planned and Managed Growth J Outcome #1: Ensure the integrity of the distribution system piping system Maintains the safety of our drinking water through flushing, replacing aged piping, valves and fire hydrants M1 R, i.� " r B-Branch project- Rhomberg Ave., 20"& 8" water main replacement. 2,965 feet(0.56 miles) of varying sizes of water main pipe Outcome #2: Addressing customer and system issues in a timely manner Minimizes the time customers are without water -16- WATER DEPARTMENT DIDYOU 1,. composedThe system is Um of 321 miles of water so - �2 �o 81 mains . . diameter 69 . . 60 8,017 control 40 valves-, and 2,330 fire hydrants 20 o - Fro6 Fro7 Fros Frog Fr10 Fru Fru Frl3 Fr14 Fr LS xelyoe-e ralhr 350 301 301 288 300 270 250 206 zoo 287 M 179 us 1� 1W so - T � FY06 FY'07 FT08 FY'09 FY'10 FY'll FY'12 FY'13 FY'14 FY']5 Service taps are new connections to the public water mains Water Meters Overview The Water Meter Division provides dependable meter repair consisting of testing, dismantling, cleaning, repairing, and reassembling meters as required. The Meter Division performs installation services, addresses pressure complaints, investigates illegal use of water, installs outside registers, and performs special reading of meters upon request and performs backflow administration to comply with state and federal mandates while ensuring accurate charges to the customer. -17- WATER DEPARTMENT Water Meters Funding Summary FV 2018 FV 2016 Actual FV 2017 Budget Requestetl Expenditures 1 $301,469 $368,936 $332,035 Resources 1 $116,569 $94,051 $158,932 Water Meters Position Summary FV 2018 Water Meter Repair Worker l 3.00 Total Full-Time Equivalent Employee's 3.00 Future Initiatives • Continue to educate the public of the importance of adhering to all State and Federal mandates concerning Backflow Control Devices, which protect public water supplies from potential contamination • Continue to provide excellent customer service Performance Measures Water Meters -Activity Statement Provide dependable meter repair, installation services and backflow administration to comply with state and federal mandates to ensure accurate charges to customers. / (p4Goal: Environmental Integrity�1A Outcome#1: Provide accurate meter readings Ensures that customers pay for the appropriate amount of water used by tracking private water service line leaks (internal and external). Repair reimbursement and service line assistance. Outcome#2: Backflow protection Minimizes the possibility of contamination of the distribution system by preventing back siphonage. A backflow prevention device prevents contamination of the water system from industrial and commercial water services by using equipment that stops the backward flow of water through a pipe or cross connection between potable water and contaminants. -18- WATER DEPARTMENT � J DID YOU KNOW? 4l 4 L�i=` . ' Since the adoption by "�- ` ' Council of the Backflow _ �" - Prevention Program, we - have established over � �— ; I' C 1,851 accounts having ��" � �� (' Backflow Protection and we also monitor -'i over 2,624 Control � - - - Devices. TheseTypical Meter/Fire Sprinkler Room accounts are a Meter combination of various Industrial and Commercial facilities. Annually we receive �r $25.00 per device as the administration fee. It ,,," is expected an additional 75 accounts � will be established ' !� before the end of the fiscal year WATER DEPARTMENT Outcome #3: Responding to customer inquiries in a timely manner Maintains consumer confidence in the water utility Ser�rceC�� 869 s00 713 681 714 600 q33 420 400 200 LO MO6 M07 MOs M09 M10 M11 M12 M13 M14 Mss -20- Recommended Operating Revenue Budget - Department Total 42 -WATER FY15 Actual FY16 Actual FY17 Adopted FY IS Recomm'd Fund Account Account Title Revenue Revenue Budget Budget 640 43110 INVESTMENT EARNINGS 21,947 27,640 0 27,461 43-USE OF MONEY AND PROPERTY 21,947 27,640 0 27,461 640 51105 METER RATES 6,873,347 7,677,554 8,023,216 8,149,680 640 51106 UB REFUND CLEARING ACCT (6,992) (6) 0 0 640 51110 FLATRATES 14,209 20,685 23,581 20,000 640 51111 FLAT RATE KEY WEST 0 29,871 0 0 640 51115 FIRE PROTECTION RATES 137,758 155,143 134,101 150,000 640 51125 TAPS-3/4&1 INCH 31,536 42,056 30,344 33,000 640 51130 CONNECT CHG LARGE SERVICE 14,860 36,260 17,221 22,500 640 51135 CONNECT CHG FRONT FOOTAGE 9,385 75,905 35,570 49,435 640 51140 METER SALES-REMOTES 0 456 0 456 640 51145 SALE OF METERS 28,930 32,987 18,530 75,350 640 51146 SALE OF UFR DEVICES 7,295 5,973 3,338 5,973 640 51165 MAINTENANCE CHARGES 8,196 7,327 9,732 7,327 640 51170 REPAIR OF METERS 11,453 10,493 10,371 10,493 640 51175 SHUT OFF PENALTIES 15,329 22,923 13,586 22,923 640 51176 METER TAMPERING FEE 3,222 1,789 2,684 1,789 640 51177 CALL OUT CHARGE 2,494 1,618 2,300 1,618 640 51180 CROSS CON.CNTL ADMIN FEE 63,407 66,038 61,026 66,038 640 51215 PENALTIES 89,212 81,581 80,109 81,092 640 51310 MONTHLY RENTAL 82,184 80,183 91,621 80,183 640 51720 UB-WTR RPR TEMP HOLDING 0 1,285 0 0 51-CHARGES FOR SERVICES 7,385,825 8,350,121 8,557,330 8,777,857 640 53201 REFUNDS 20 119 0 0 640 53610 INSURANCE CLAIMS 1,715 0 0 0 640 53615 DAMAGE CLAIMS 7,100 14,241 5,087 14,241 640 53620 REIMBURSEMENTS-GENERAL 8,593 2,467 690 124 640 53630 SALES TAX COLLECTION 405,147 450,414 445,000 476,890 53-MISCELLANEOUS 422,575 467,241 450,777 491,255 640 54109 SALVAGE SALES 1,051 250 900 250 54-OTHER FINANCING SOURCES 1,051 250 900 250 640 59100 FR GENERAL 0 60,944 0 0 640 59500 TRF TO PEONY TRUST 0 584 0 0 59-TRANSFER IN AND INTERNAL 0 584 0 0 42-WATER TOTAL 7,831,398 8,845,836 9,009,007 9,296,823 -21- Recommended Operating Expenditure Budget - Department Total 42 -WATER FY15 Actual FY16 Actual FY17 Adopted FY IS Recomm'd Fund Account Account Title Expense Expense Budget Budget 640 61010 FULL-TIME EMPLOYEES 1,408,801 1,459,520 1,511,988 1,411,566 640 61020 PART-TIME EMPLOYEES 4,460 4,707 21,741 22,091 640 61050 OVERTIME PAY 71,486 63,023 90,040 90,040 640 61071 HOLIDAYPAY-OVERTIME15,331 17,562 14,000 17,000 640 61072 TANK CLIMBING PAY 0 90 1,200 1,200 640 61091 SICK LEAVE PAYOFF 4,606 7,044 7,039 16,474 640 61310 IPERS 133,957 137,960 146,364 137,690 640 61320 SOCIAL SECURITY 109,966 113,605 125,923 119,219 640 61410 HEALTHINSURANCE 371,280 403,427 397,500 381,600 640 61415 WORKMENS'COMPENSATION 82,099 80,174 82,465 94,589 640 61416 LIFE INSURANCE 1,102 1,106 3,023 2,656 640 61417 UNEMPLOYMENT INSURANCE 6,585 0 0 0 640 61620 UNIFORM ALLOWANCE 1,737 762 0 0 640 61640 SAFETYEQUIPMENT 3,449 2,814 6,000 6,000 640 61650 MEAL ALLOWANCE 646 584 500 500 640 61660 EMPLOYEE PHYSICALS 1,512 2,841 1,492 2,196 61-WAGES AND BENEFITS 2,217,017 2,295,219 2,409,275 2,302,821 640 62010 OFFICE SUPPLIES 4,411 3,426 4,464 3,850 640 62011 UNIFORM PURCHASES 13,725 14,093 14,000 14,550 640 62030 POSTAGE AND SHIPPING 5,207 1,354 2,262 2,445 640 62033 HAND TOOLS/EQUIPMENT 6,162 5,020 6,285 5,120 640 62034 REPAIR PARTS/SUPPLIES 8,050 10,690 8,210 13,595 640 62036 CONSTRUCTION SUPPLIES 2,985 1,528 3,467 2,900 640 62061 DP EQUIP.MAINT CONTRACTS 15,975 16,955 17,453 17,608 640 62062 JANITORIAL SUPPLIES 4,569 4,746 4,708 4,650 640 62063 SAFETY RELATED SUPPLIES 2,551 2,858 2,763 2,930 640 62064 ELECTRICAL SUPPLIES 13,198 9,254 13,711 9,650 640 62065 LAB SUPPLIES 12,822 12,202 13,078 12,260 640 62066 PLUMBING MATERIALS 3,933 12,128 4,408 12,370 640 62090 PRINTING&BINDING 1,640 1,371 1,157 1,400 640 62110 COPYING/REPRODUCTION 1,044 2,080 1,043 2,069 640 62130 LEGAL NOTICES&ADS 3,021 472 1,040 4,540 640 62170 SUBSCRIPTIONS-BOOKS-MAPS 1,020 716 1,359 1,380 640 62190 DUES&MEMBERSHIPS 4,007 3,543 4,487 4,485 640 62204 REFUNDS 0 9,623 0 9,815 640 62206 PROPERTY INSURANCE 84,149 84,655 87,871 73,764 640 62207 BOILERINSURANCE 1,400 6,730 6,730 0 640 62208 GENERAL LIABILITY INSURAN 21,679 20,926 21,334 21,942 640 62210 SALES TAX 408,269 445,192 445,000 476,890 640 62216 REFUND LEAK ALLLOWANCE 0 3,017 0 3,077 640 62310 TRAVEL-CONFERENCES 4,110 2,532 4,196 6,800 640 62320 TRAVEL-CITY BUSINESS 577 0 200 200 640 62340 MILEAGE/LOCAL TRANSP 3,401 4,169 4,368 4,512 640 62360 EDUCATION&TRAINING 7,302 4,955 6,742 17,350 640 62411 UTILITYEXP-ELECTRICITY521,521 580,517 563,243 603,738 640 62412 UTILITYEXP-GAS40,633 28,210 38,406 31,031 640 62414 UTILITY EXP-FUELOIL 482 3,375 5,500 3,442 640 62415 UTILITY EXPENSE STORMWATR 45 169 1,400 173 -22- Recommended Operating Expenditure Budget - Department Total 42 -WATER FY15 Actual FY16 Actual FY17 Adopted FY IS Recomm'd Fund Account Account Title Expense Expense Budget Budget 640 62416 UTILITY EXP-WATER 9 0 0 0 640 62421 TELEPHONE 11,974 7,783 7,850 12,710 640 62423 TELECOMMUNICATION CG 7,742 7,939 7,896 8,098 640 62424 RADIO/PAGERFEE 0 0 2,500 2,500 640 62431 PROPERTY MAINTENANCE 31,119 43,615 57,951 73,088 640 62433 CUSTODIAL SERVICES 0 0 700 700 640 62435 ELEVATOR MAINTENANCE 0 175 2,200 2,000 640 62436 RENTAL OF SPACE 1,680 1,764 1,714 1,799 640 62437 BARRICADERENTAL 2,978 5,364 3,038 5,471 640 62511 FUEL,MOTOR VEHICLE 29,144 20,007 26,229 20,007 640 62521 MOTOR VEHICLE MAINT. 36,271 20,701 37,963 21,783 640 62528 MOTOR VEH.MAINT.OUTSOUR 11,465 5,601 11,616 5,713 640 62611 MACH/EQUIP MAINTENANCE 129,772 89,832 132,368 128,233 640 62613 METER MAINTENANCE 1,601 1,930 1,600 14,000 640 62614 EQUIP MAINT CONTRACT 210 0 0 0 640 62615 MACH/EQUIP MAINT.OUTSOUR 1,798 266 0 500 640 62630 FLUORIDE 14,270 0 14,555 14,700 640 62631 LIME 258,686 282,155 263,859 266,500 640 62632 PHOSPHATE 63,294 59,191 64,560 67,000 640 62633 CHLORINE 37,066 31,655 37,807 40,000 640 62638 POLYMER 8,477 6,783 8,647 8,700 640 62639 LIQUID CO2/02 15,228 13,353 18,000 18,000 640 62663 SOFTWARE LICENSE EXP 135 992 16,000 15,586 640 62664 LICENSE/PERMIT FEES 6,837 7,027 7,000 7,167 640 62667 INTERNET SERVICES 0 1,506 1,351 2,466 640 62669 PROGRAMMING 24,344 7,037 5,117 25,000 640 62671 MISC.OPERATING SUPPLIES 0 15 0 0 640 62675 VALVES 33,866 967 66,000 10,000 640 62676 PIPE-SPECIAL FITTINGS 67,672 56,886 50,000 70,000 640 62692 LANDFILL FEES 199 15 202 200 640 62696 OUTSIDE COLLECTOR EXPENSE 7,687 8,024 404 8,319 640 62710 CONTRACTOR SERVICES 606 0 500 500 640 62713 LEGAL SERVICES 60,944 32,451 60,000 0 640 62716 CONSULTANT SERVICES 100,000 13,860 2,000 14,137 640 62726 AUDIT SERVICES 3,500 2,500 3,700 3,700 640 62731 MISCELLANEOUS SERVICES 0 4,150 20,000 20,000 640 62746 ONE CALL OPERATION 4,514 5,568 5,000 5,679 640 62765 GRANTS 0 5,409 8,500 8,500 640 62767 ENVIRON.TESTING/MON. 30,207 33,685 30,811 45,000 640 62780 HAULING SERVICES 133,046 141,199 139,699 148,250 640 62811 ENG.DIVISION SERVICES 0 0 61,000 0 640 62820 STREET DIVISION SERVICES 0 1,920 0 1,958 62-SUPPLIES AND SERVICES 2,334,229 2,217,831 2,467,222 2,466,500 640 71120 PERIPHERALS,COMPUTER 0 200 0 7,580 640 71123 SOFTWARE 2,316 883 2,000 2,000 640 71312 VAN/PICKUP/WAGREPL 0 0 70,000 42,000 640 71314 TRUCK-REPLACEMENT 0 0 70,000 70,000 640 71315 TRUCK-ADDITIONAL 9 0 0 0 -23- Recommended Operating Expenditure Budget - Department Total 42 -WATER FY15 Actual FY16 Actual FY17 Adopted FY IS Recomm'd Fund Account Account Title Expense Expense Budget Budget 640 71318 HEAVYEQUIP-REPLACEMENT0 0 95,000 0 640 71328 TRAILERS 0 0 8,000 0 640 71410 SHOP EQUIPMENT 224 266 1,300 2,200 640 71413 LABORATORY EQUIPMENT 0 481 3,500 3,500 640 71414 AIR HAMMER/DRILL 227 0 0 0 640 71419 TAPPING MACHINE 1,950 17,770 0 0 640 71510 HYDRANTS 59,206 14,785 70,000 70,000 640 71511 PUMPS 30 3,487 21,000 21,000 640 71516 LARGE WATER METERS 2,901 81,356 83,522 83,500 640 71550 MISCELLANEOUS EQUIPMENT 82 0 0 0 640 71619 OTHER MAINT.EQUIPMENT 260 1,399 22,300 0 640 72410 PAGER/RADIO EQUIPMENT 0 0 0 46,175 640 72415 ELECTRONIC DATA COLLECTOR 0 0 0 2,644 640 72418 TELEPHONE RELATED 847 36 1,200 1,925 640 72515 TEST EQUIPMENT,OTHER 2,777 318 1,000 1,000 71-EQUIPMENT 70,829 120,981 448,822 353,524 640 72115 BARRICADES/WARN SIGNALS 4,840 89 500 1,000 72-EQUIPMENT 4,840 89 500 1,000 640 73211 CONST.CONTR-NOTBLDG 765 137,919 688,583 503,300 640 73410 EQUIP ACQUISITION 0 0 17,490 18,000 73-CIP EXPENDITURES 765 137,919 706,073 521,300 640 74111 PRINCIPAL PAYMENT 812,975 833,193 879,595 709,290 640 74112 INTERESTPAYMENT 597,107 732,244 767,494 943,856 74-DEBT SERVICE 1,410,082 1,565,437 1,647,089 1,653,146 640 91100 TO GENERAL 862,719 142,985 142,884 407,551 640 91740 TO WATER CONSTRUCTION 595,000 354,466 1,012,000 1,157,000 91-TRANSFER TO 1,457,719 497,451 1,154,884 1,564,551 42-WATER TOTAL 7,495,481 6,834,927 8,833,865 8,862,842 -24- Recommended Expenditure Budget Report by Activity & Funding Source 42 -WATER UNDIST - 10640 FUNDING SOURCE:WATER UTILITY OPERATION Account FY16 Actual Expense FY17 Adopted Budget FY1S Recomm'd Budget SUPPLIES AND SERVICES 20,129 0 20,531 TRANSFER TO 497,451 1,154,884 1,564,551 OWUNDISTRIBUTED 517,580 1,154,884 y 1,585,082 WATER ADMINSTRATION -42100 FUNDING SOURCE:WATER UTILITY OPERATION Account FY16 Actual Expense FY17 Adopted Budget FY1S Recomm'd Budget DEBT SERVICE 1,565,437 1,647,089 1,653,146 SUPPLIES AND SERVICES 493,809 526,609 501,994 WAGES AND BENEFITS 223,336 252,969 261,942 MERADMINSTRATION Z 2,28 , METERS FUNDING SOURCE:WATER UTILITY OPERATION Account FY16 Actual Expense FY17 Adopted Budget FY1S Recomm'd Budget EQUIPMENT 22,194 86,500 22,000 SUPPLIES AND SERVICES 28,208 22,293 50,716 WAGES AND BENEFITS 251,067 260,143 259,319 w METERS 301,469 368,936 PLANT OPER. &MAINT -42400 FUNDING SOURCE:WATER UTILITY OPERATION Account FY16 Actual Expense FY17 Adopted Budget FY1S Recomm'd Budget EQUIPMENT 2,463 6,300 48,625 SUPPLIES AND SERVICES 1,440,929 1,490,900 1,557,801 WAGES AND BENEFITS 1,014,095 1,028,656 919,409 T ErPLANT OPER.&MAINT 2,457,487 2,525,856 2,525,835 WATER DISTR. SYSTEM -42700 FUNDING SOURCE:WATER UTILITY OPERATION Account FY16 Actual Expense FY17 Adopted Budget FY1S Recomm'd Budget CIP EXPENDITURES 0 0 0 EQUIPMENT 33,422 268,000 195,399 SUPPLIES AND SERVICES 210,588 295,920 252,821 WAGES AND BENEFITS 806,720 867,507 862,151 NEEPW WATER DISTR.SYSTEM MW30 1,4315427 STORAGE TANK INSPECTIMON-42705 FUNDING SOURCE:WATER UTILITY OPERATION Account FY16 Actual Expense FY17 Adopted Budget FY1S Recomm'd Budget SUPPLIES AND SERVICES 13,860 2,000 14,137 -25- Recommended Expenditure Budget Report by Activity & Funding Source 42 -WATER STORAGE TANK INSPECT/MON 13,860 21 000 14,137 AUTO MTR RD SYS MNT PROG-42710 FUNDING SOURCE:WATER UTILITY OPERATION Account FY16 Actual Expense FY17 Adopted Budget FY18 Recomm'd Budget CIP EXPENDITURES 6,670 15,000 15,000 NTPROG 6,670 15,000 PUMP REPLC VACUUM FILTER-42713 FUNDING SOURCE:WATER UTILITY OPERATION Account FY16 Actual Expense FY17 Adopted Budget FY18 Recomm'd Budget EQUIPMENT 3,038 20,000 20,000 F!!PMREPLC VACUUM FILTER 3,038 20,000 FILTER MAINT PROGRAM -42715 FUNDING SOURCE:WATER UTILITY OPERATION Account FY16 Actual Expense FY17 Adopted Budget FY18 Recomm'd Budget CIP EXPENDITURES 21,752 25,000 25,000 WFILTER MAINT PROGRAM FIRE HYD NTING -42720 FUNDING SOURCE:WATER UTILITY OPERATION Account FY16 Actual Expense FY17 Adopted Budget FY18 Recomm'd Budget SUPPLIES AND SERVICES 4,136 5,000 5,000 LIRE HYDRANT PAINTING GENERATOR MAIN PROGRAM -42725 FUNDING SOURCE:WATER UTILITY OPERATION Account FY16 Actual Expense FY17 Adopted Budget FY18 Recomm'd Budget CIP EXPENDITURES 0 17,490 18,000 MNERATOR MAIN PROGRAM 0 17,49 GIS MAINT/UPDATES -42730 FUNDING SOURCE:WATER UTILITY OPERATION Account FY16 Actual Expense FY17 Adopted Budget FY18 Recomm'd Budget SUPPLIES AND SERVICES 747 15,000 15,000 ErGISMAINT/UPDATES 747 SERVICE LINE ASSIST -42735 FUNDING SOURCE:WATER UTILITY OPERATION Account FY16 Actual Expense FY17 Adopted Budget FY18 Recomm'd Budget SUPPLIES AND SERVICES 11 15,000 15,000 -26- Recommended Expenditure Budget Report by Activity & Funding Source 42 -WATER ERVICE LINE ASSIST 11 15,000 VALVE EXERCISE PROGRAM - 42740 FUNDING SOURCE:WATER UTILITY OPERATION Account FY16 Actual Expense FY17 Adopted Budget FY1S Recomm'd Budget SUPPLIES AND SERVICES 0 25,000 25,000 MMM ERCISEPR M VALVER CEMENT 42745 25,000 FUNDING SOURCE:WATER UTILITY OPERATION Account FY16 Actual Expense FY17 Adopted Budget FY1S Recomm'd Budget CIP EXPENDITURES 2,150 0 25,000 EPLACEMENT 2,150 INTERNAL LINES LOAN -42750 FUNDING SOURCE:WATER UTILITY OPERATION Account FY16 Actual Expense FY17 Adopted Budget FY1S Recomm'd Budget CIP EXPENDITURES 5,000 45,000 45,000 SUPPLIES AND SERVICES 0 5,000 0 INTERNAL LINES LOAN 5,000 50,000 45,000 WATER MAIN REPLACEMENTS - 42755 J FUNDING SOURCE:WATER UTILITY OPERATION Account FY16 Actual Expense FY17 Adopted Budget FY1S Recomm'd Budget CIP EXPENDITURES 81,287 536,781 321,500 SUPPLIES AND SERVICES 0 56,000 0 EWAINREPLAC.EjMENTS 81,287 592,781 321,500 WATER METER EXCHANGE -4 FUNDING SOURCE:WATER UTILITY OPERATION Account FY16 Actual Expense FY17 Adopted Budget FY1S Recomm'd Budget EQUIPMENT 59,952 68,522 68,500 WATER MET ER EXCHANGE 59,952 68,522 WATER LEAK REPAIR GRANT - 42765 FUNDING SOURCE:WATER UTILITY OPERATION Account FY16 Actual Expense FY17 Adopted Budget FY1S Recomm'd Budget SUPPLIES AND SERVICES 5,409 8,500 7,000 E WATER LEAK REPAIR GRANT 5,409 8,500 COUNTY WATER ASSISTANCE -42766 FUNDING SOURCE:WATER UTILITY OPERATION -27- Recommended Expenditure Budget Report by Activity & Funding Source 42 -WATER Account FY16 Actual Expense FY17 Adopted Budget FY1S Recomm'd Budget SUPPLIES AND SERVICES 0 0 1,500 1 COUNTY WATER ASSISTANCE 0 0 1,500 R VALVE BOX MAINT - 42770 FUNDING SOURCE:WATER UTILITY OPERATION Account FY16 Actual Expense FY17 Adopted Budget FY1S Recomm'd Budget CIP EXPENDITURES 20,200 15,000 20,000 OrAMTERWLVE BOX MAINT 20,200 15,000 WATER METER TESTING -42790 FUNDING SOURCE:WATER UTILITY OPERATION Account FY16 Actual Expense FY17 Adopted Budget FY1S Recomm'd Budget CIP EXPENDITURES 0 25,000 25,000 "WATER TESTING 0 25,000 WELL MAINT PROGRAM -42795 FUNDING SOURCE:WATER UTILITY OPERATION Account FY16 Actual Expense FY17 Adopted Budget FY1S Recomm'd Budget CIP EXPENDITURES 861 26,802 26,800 -L MAINT PROGRAM ,800 WATER TOTAL ,842.00 -28- CITY OF DUBUQUE , IOWA DEPARTMENT DETAIL-PERSONNEL COMPLEMENT 42 WATER DEPARTMENT FY 2016 FY 2017 FY 2018 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET 61010 Full Time Employee Expense 640 3275 GE-40 WATER DEPARTMENT MANAGER 1.00 $ 103,453 1.00 $ 106,708 1.00 $ 84,185 640 2775 GE-37 WATER PLANT MGR. 1.00 $ 86,436 1.00 $ 88,299 1.00 $ - 640 3200 GE-37 WATER DISTRIBUTION SUPERVISOR 1.00 $ 69,063 1.00 $ 85,338 1.00 $ 86,711 640 2950 GE-33 WATER ENGINEERING ASSISTANT 1.00 $ 70,444 1.00 $ 63,371 1.00 $ 67,933 640 2650 GE-31 FOREMAN -WATER DISTR. 1.00 $ 65,144 1.00 $ 66,540 1.00 $ 52,000 640 2610 GE-30 GIS SPECIALIST 1.00 $ 59,339 1.00 $ 60,630 1.00 $ 61,606 640 2400 OE-16 ELECTRONIC TECHNICIAN 1.00 $ 59,412 1.00 $ 60,669 1.00 $ 62,244 640 2800 OE-14 EQUIPMENT MECHANIC 1.00 $ 56,997 1.00 $ 58,206 1.00 $ 59,143 640 2550 OE-13 WATER PLANT OPR CERT GR III/IV 3.00 $ 168,263 3.00 $ 171,813 3.00 $ 166,238 640 2475 OE-12 WATER PLANT OPERATOR CRT GR II 5.00 $ 262,629 5.00 $ 271,998 5.00 $ 277,038 640 2305 OE-10 EQUIPMENT OPERATOR II 2.00 $ 107,032 2.00 $ 109,279 2.00 $ 106,554 640 1775 OE-09 WATER METER REPAIRWORKER 1 3.00 $ 154,871 3.00 $ 158,303 3.00 $ 156,289 640 1476 OE-09 WATER DISTR MAINTENANCE WORKER 4.00 $ 205,555 4.00 $ 210,834 4.00 $ 211,555 TOTAL FULL TIME EMPLOYEES 25.00 $ 1,468,638 25.00 $1,511,988 25.00 $1,391,496 61020 Part-Time Employee Expense 640 225 GE-25 SECRETARY 0.50 $ - 0.50 $ 18,552 0.50 $ 18,850 640 2050 OE-06 CUSTODIAN 1 0.07 $ 3,066 0.07 $ 3,189 0.07 $ 3,241 TOTAL PART TIME EMPLOYEES 0.57 $ 3,066 0.57 $ 21,741 0.57 $ 22,091 TOTAL WATER DEPARTMENT 25.57 $ 1,471,704 25.57 $1,533,729 25.57 $1,413,587 -29- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2016 FY 2017 FY 2018 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET Water Administration-FT 64042100 61010 640 2610 GE-30 GIS SPECIALIST 1.00 $ 59,339 1.00 $ 60,630 1.00 $ 61,606 64042100 61010 640 3275 GE-40 WATER DEPARTMENT MANAGER 1.00 $ 103,453 1.00 $ 106,708 1.00 $ 84,185 Total 2.00 $ 162,792 2.00 $ 167,338 2.00 $ 145,791 Water Administration-PT 64042100 61020 640 225 GE-25 SECRETARY 0.50 $ - 0.50 $ 18,552 0.50 $ 18,850 Total 0.50 $ - 0.50 $ 18,552 0.50 $ 18,850 Water Meters-FT 64042300 61010 640 1775 OE-09 WATER METER REPAIRWORKER I 3.00 $ 154,871 3.00 $ 158,303 3.00 $ 156,289 Total 3.00 $ 154,871 3.00 $ 158,303 3.00 $ 156,289 Water Plant Operation-FT 64042400 61010 640 2475 OE-12 WATER PLANT OPER.CRT GR II 5.00 $ 262,629 5.00 $ 271,998 5.00 $ 277,038 64042400 61010 640 2550 OE-13 WATER PLANT OPR CERT GR III/IV 3.00 $ 168,263 3.00 $ 171,813 3.00 $ 166,238 64042400 61010 640 2775 GE-37 WATER PLANT MGR. 1.00 $ 86,436 1.00 $ 88,299 1.00 $ - 64042400 61010 640 2800 OE-16 ELECTRONIC TECHNICIAN 1.00 $ 59,412 1.00 $ 60,669 1.00 $ 62,244 64042400 61010 640 3015 OE-14 EQUIPMENT MECHANIC 1.00 $ 56,997 1.00 $ 58,206 1.00 $ 59,143 Total 11.00 $ 633,737 11.00 $ 650,985 11.00 $ 564,663 Water Distribution-FT 64042700 61010 640 1476 OE-09 WATER DIST MAINTENANCEWOR 4.00 $ 205,555 4.00 $ 210,834 4.00 $ 211,555 64042700 61010 640 2305 OE-10 EQUIPMENT OPERATOR II 2.00 $ 107,032 2.00 $ 109,279 2.00 $ 106,554 64042700 61010 640 2650 GE-31 FOREMAN-WATER DISTR. 1.00 $ 65,144 1.00 $ 66,540 1.00 $ 52,000 64042700 61010 640 2950 GE-33 WATER ENGINEERING ASSISTANT 1.00 $ 70,444 1.00 $ 63,371 1.00 $ 67,933 64042700 61010 640 3200 GE-37 WATER DISTRIBUTION SUPV 1.00 $ 69,063 1.00 $ 85,338 1.00 $ 86,711 Total 9.00 $ 517,238 9.00 $ 535,362 9.00 $ 524,753 Water Distribution-PT 64042700 61020 640 2050 GD-03 CUSTODIAN 1 0.07 $ 3,066 0.07 $ 3,189 0.07 $ 3,241 Total 0.07 $ 3,066 0.07 $ 3,189 0.07 $ 3,241 TOTAL WATER DEPARTMENT 25.57 $ 1,471,704 25.57 $1,533,729 25.57 $ 1,413,587 -30- Capital Improvement Projects by Department/Division WATER FY 15 Actual FY 16 Actual FY 17 Adopted FY 18 Recomm'd CIP Number Capital Improvement Project Title Expense Expense Budget Budget 3602594 SW ARTERIAL MAIN EXT 0 0 500,000 0 7401389 GIS MAINTENANCE/UPGRADE 2,741 0 0 0 7401390 SERVICE LINE ASSISTANCE 20,394 0 0 0 7401400 WATER METER EXCHANGE 62,605 0 0 0 7401405 WATER MAIN REPLACEMENTS 626,118 4,192 489,900 0 7401409 FIRE HYDRANT REPLACMENTS 68,150 0 0 0 7401410 VALVE REPLACEMENT 13,825 0 0 0 7401411 MAIN EXT ANNEXATION REL. 101,628 206,286 0 0 7401672 ROOSEVELT RD MAIN EXT. 86,566 2,950 150,000 0 7401826 PAINT PUMP ROOM PIPES 0 0 0 0 7402030 VACUUM FILTER BACK-UP 0 0 0 30,000 7402200 WATER SVC REPAIR GRANT 7,888 0 0 0 7402201 FIRE HYDRANT PAINTING 74,343 0 0 0 7402203 WATER VALVE BOX MAINT 14,824 0 0 0 7402261 RAMP UTILITY RELOCATION 2,944 0 0 0 7402314 AUTO MTR RD SYST MET PRG 10,037 0 0 0 7402349 MANSON ROAD WATER MAIN 0 0 0 155,000 7402395 WATER EXT-AIRPORT 334,263 5,491,202 0 0 7402396 NORTH SOFTENING BASIN REN 185,803 8,948 0 0 7402400 BRK BLD-REPAIR-EPP PS 984 0 0 0 7402472 WATER COMP LEAK SURVEY 26,050 0 0 0 7402504 ENGLISH MILL WATER MAIN E 169,482 924 0 0 7402524 ONLINE PROCESS ANALYZER 453 0 15,000 0 7402526 SRF GREEN ALLEY 6,832 0 0 0 7402527 GENERATOR 6,898 0 0 0 7402528 RAW H2O TRANSMISSION LINE 0 0 0 0 7402594 SW ARTERIAL MAIN EXT 0 439,315 2,942,000 250,000 7402595 CREEK CROSSING RESTORE 0 0 46,730 45,000 7402596 MAIN RELOC SEWER MANHOLE 0 0 50,000 20,000 7402653 LIME SLAKER REPLACE STUDY 0 0 10,000 0 7402654 FIRE HYDRNT ASSMBLY SW PG 0 0 12,000 12,000 7402655 MAINTWTRMN-RETAINWAL 0 0 20,000 20,000 7402656 WATER STORAGE TANK COATIN 0 0 88,500 45,000 7402657 WTR MN UPGRADES-STREET 0 0 20,000 25,000 7402658 WTR MN REPLACE-SWR CONS 0 0 240,350 121,800 7402703 WEST RURAL WATER PURCHASE 0 0 0 4,396,500 7402713 RPIUMAINT WATER LINE ISLA 0 0 0 30,000 7402714 BULK CO2 TANK REPLACEMENT 0 0 0 75,000 -31- PROGRAM/ DEPT PROJECT DESCRIPTION FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 TOTAL PAGE WATER DEPARTMENT Business Type Water Storage Tank Coating Program $ 45,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 245,000 136 Manhole Replacement Rehab $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 25,000 $ 105,000 137 Creek Crossing Restoration $ 45,000 $ 45,000 $ 45,000 $ 45,000 $ 45,000 $ 225,000 138 Water Main Upgrades during Street General Repairs $ 25,000 $ 30,000 $ 30,000 $ 35,000 $ 35,000 $ 155,000 139 Maintenance of Public Water Mains during Stone Retaining Wall Repair $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 100,000 140 Fire Hydrant Assembly Relocation/ Replacement for the Sidewalk Program $ 12,000 $ 12,000 $ 20,000 $ 20,000 $ 20,000 $ 84,000 141 Water Main Replacements- Streets $ - $ - $ 200,000 $ - $ - $ 200,000 142 Southwest Arterial Water Main Extension $ 250,000 $ - $ 770,000 $ 740,000 $ - $1,760,000 144 Vacuum Filter Plant Process Upgrade $ 30,000 $ - $ 200,000 $ - $ - $ 230,000 146 Bridge Repairs/Maintenance of the Water Main Supply Line to City Island $ 30,000 $ - $ - $ - $ - $ 30,000 147 Bulk CO2 Tank Replacement $ 75,000 $ - $ - $ - $ - $ 75,000 148 South End Water Main Loop $ 155,000 $ - $ - $ - $ - $ 155,000 149 West Side Water System $4,396,500 $ - $ - $ - $ - $4,396,500 150 Water Main Replacements-Sewer Consent Decree $ 121,800 $ - $ - $ - $ - $ 121,800 152 Public Lead Line Water Replacement $ - $ 46,000 $ 50,000 $ 65,000 $ 73,000 $ 234,000 154 Tamarak Park Frontage Road Water Main $ - $ - $ 400,000 $ 150,000 $ - $ 550,000 155 20"Transmission Main, 12"and 8" Water Main Relocation/ Replacement/Extension $ - $400,000 $ - $ - $ - $ 400,000 156 Raw Water Transmission Lines $ - $ - $ 75,000 $ - $ - $ 75,000 157 English Ridge Water Main $ - $ - $ - $ - $330,000 $ 330,000 158 Total -Water Department $5,225,300 $623,000 $1,880,000 $1,145,000 $598,000 $9,471,300 -32- City of Dubuque Water Department BUDGET PRESENTATION FISCAL YEAR 2018 Water Department The City of Dubuque’s Water Department is dedicated to producing and delivering clean and safe drinking water that is in compliance with all state and federal drinking water standards. We continually strive to adopt new and better methods of delivering the best quality drinking water to the citizens of Dubuque in the most cost-effective manner. FY17/FY18 Water Department Organization 25.5 FTE (1) Water Department Manager (1) Water Plant Manager (1) Equipment Mechanic (8) Plant Operators (1) Electronic Technician (0.5) Secretary (1) Water Distribution Supervisor (1) Water Engineering Assistant (1) Water Distribution Foreman (3) Meter Repairworker I (1) Distribution Equipment Operator (1) Equipment Operator II (4) Distribution Maintenance Workers (1) GIS Specialist •Human Resources •Training •Safety •Regulatory Compliance •Budget and Financial Management •Capital Improvements •Data Management (GIS) Training Provided specialized training to eligible Grade 3 and 4 Water Operators Provided Backflow Prevention Training to Distribution staff members Backflow Prevention Training Regulatory Compliance & Capital Improvements Completion of the booster pump Stations Nos.1 & 2 and 500,000 gallon ground storage reservoir to the Airport property Initiated engineering contract for design of English Mill Pump Station and Water Main Extension to Vernon and Barrington Lakes Water Systems Airport site Booster No.2 and 0.5 MG Storage Tank Phased Improvements: Economic growth and Development Acquisition of the Vernon Water Tower and Vernon and Barrington Lakes Water Systems resulted in the City’s ability to phase in necessary improvements at a later date to serve the area on and around the SW Arterial Project. The SW Arterial Project included capital improvements such the English Mill Pump station and water main extension that will now be covered in the West Side Water System improvements. The Vernon Water Tower enables the City to provide pressure and supply to Dubuque’s Industrial Center West promoting a phased approach and response to improvements. •Regulatory Compliance •Water Production & Treatment •Wells & Well Field Maintenance •Pumping to the Distribution System •Water Storage Facilities •SCADA Communications 2,863 2,805 2,787 2,638 2,538 2,641 2,539 2,580 1,893 1,888 1,975 2,061 2,098 2,011 2,025 2,079 - 500 1,000 1,500 2,000 2,500 3,000 3,500 FY'09 FY'10 FY'11 FY'12 FY'13 FY'14 FY'15 FY'16 Water Produced, Treated, and Metered (Million Gallons) Treated Metered 33.88%32.69% 29.14% 21.87% 17.34% 23.85% 20.24%19.42% 0.00% 5.00% 10.00% 15.00% 20.00% 25.00% 30.00% 35.00% 40.00% FY'09 FY'10 FY'11 FY'12 FY'13 FY'14 FY'15 FY'16 Water Loss, Percentage Operation of the Vernon and Barrington Water Systems Installation of SCADA Communications to the Airport and Vernon and Barrington Water Systems Well No. 8 Emergency Maintenance and Repairs Well No. 8 Pump and Motor Revised Permit: Lead and Copper Rule Water Quality Report Well No. 6 Maintenance and Repairs W. 3 rd Street Pump Station Generator Final Design and Bid Analyze and provide a solution for Roosevelt Road area water pressure issues W. 3rd Street Pump Station •Operation and Maintenance •Emergency Response •Inspection •General Construction •Service Line Main Taps •Water Main Installation •Meter Management •Backflow Prevention •Development Review Mueller TM Fire Hydrant Emergency Response & General Construction 45* main breaks 113* New Service Tap installations *current through February 2017 11St and Main St. Main Break *FY 2017 to date: 45 Water Main Breaks Main Breaks can result from conditions such as freezing and thawing conditions of the ground, water hammer, or aging. 70 69 137 81 58 45 0 20 40 60 80 100 120 140 160 FY'12 FY'13 FY'14 FY'15 FY'16 FY'17* Water Main Break Response 301 206 109 179 278 113 0 50 100 150 200 250 300 350 FY'12 FY'13 FY'14 FY'15 FY'16 FY'17* New Service Taps *FY 2017 to date: 113 Service Taps New Connections result from community growth such as new housing, businesses, and industry. Inspection Services Inspection and Assistance with Bee Branch 20 inch water main replacement Airport Utility Extension Project Key West/Lake Eleanor Water Main Project (Twin Ridge) Century Circle Water Main Project Bee Branch 20 inch water main Back flow Prevention Program In 2017: 2,800 installed devices; in 2005 only 260 devices Administrative fee $25 per device (City devices not billed) Addition of 50 new devices in FY2017 Backflow Prevention Training Residential, Business, and Commercial Meter Program Management *FY2017 to date: 333 service calls 433 714 591 420 673 333 0 100 200 300 400 500 600 700 800 FY'12 FY'13 FY'14 FY'15 FY'16 FY'17* Meter Service Calls FY 2018 RATES,REVENUE, EXPENSES, CAPITAL IMPROVEMENTS AND IMPROVEMENT PACKETS WATER DEPARTMENT ADMINISTRATION, PLANT OPERATIONS, AND DISTRIBUTION $33.55 $30.25 $30.24 $28.82 $28.43 $28.22 $27.27 $0.00 $5.00 $10.00 $15.00 $20.00 $25.00 $30.00 $35.00 $40.00 West Des Moines Des Moines Iowa City Council Bluffs Dubuque Ames Cedar Rapids FY18 Water Rate Comparison* Average Household Use: 6,000 gallons *Largest Iowa Cities with Lime Softening Rate Summary Proposed 3% increase in Water Rates FY18 rate will be $.004738 per gallon up from FY17 rate of $0.0046 per gallon Using the Average Household water use: FY2017 cost for 6,000 gallons -$27.60 FY2018 cost for 6,000 gallons -$28.43 Comparing Iowa’s Largest Cities with Lime Softened Water: Average cost for 6,000 gallons, not including Dubuque -$29.73 Dubuque’s cost is 4.3% less than the Average Top 6 Largest Cities' rate with lime softening Overall the City of Dubuque has the 3rd Lowest Proposed Water Rate FY'14 Actual FY'15 Actual FY'16 Actual FY'17 Budget FY'18 Requested Revenue $7,727,159 $7,829,512 $8,906,782 $9,009,007 $9,296,823 Expenses $7,921,010 $7,568,224 $6,991,358 $9,008,472 $9,033,504 $- $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 $8,000,000 $9,000,000 $10,000,000 Water Department Revenue & Expense Summary Revenue Expenses Lead and Copper Rule Permit Compliance Operator Certification Training Well Maintenance Program –Well No. 10 West 3 rd Generator Completion Provide City water to the Vernon Water Tower and the Vernon and Barrington Lakes water systems Water Quality Testing Capital Improvements Water Storage Tank Coating Program Vacuum Filter Plant Process Upgrade Bulk CO2 Tank Replacement Sludge Plant Vacuum Filter Project Description Funding Source Budget Cost Estimate Water Storage Tank Coating Program Water Construction Fund $45,000.00 Bulk CO2 Tank Replacement Water Construction Fund $75,000.00 Vacuum Filter Plant Process Upgrade Water Construction Fund $30,000.00 Estimated Total $150,000.00 Water Main Creek Crossing Restoration Old Mill Rd Before Old Mill Rd After Provide Clean, Safe and Reliable City Water and Fire Protection Installation of over 320 water meters and MIUs in Vernon and Barrington Lakes in preparation for connection to the City’s water supply. Installation of approximately 7,000 lineal feet of 12 inch water main along John F Kennedy Road to serve two new subdivisions. Provide Clean, Safe and Reliable City Water and Fire Protection Installation and Completion of the English Mill Pump Station and WestsideWater Main Extension to the Vernon Water Tower, serving the Vernon and Barrington Lake Water Systems. Project Description Funding Source Budget Cost Estimate Water Main Relocation -Sanitary Sewer Water Construction Fund $20,000.00 Creek Crossing Restoration Water Construction Fund $45,000.00 Water Main Upgrades -Street General Repairs Water Construction Fund $25,000.00 Maintenance of Water Main During Retaining Wall Repair Water Construction Fund $20,000.00 Fire Hyd Relocation -Sidewalk Program Water Construction Fund $12,000.00 SW Arterial Water Main Extension Water Construction Fund $250,000.00 Southend Water Main Loop -Rockdale Rd to Manson Rd Water Construction Fund $155,000.00 Water Main assoc. with Bridge Repairs Water Construction Fund $30,000.00 Westside Water Connection to Vernon Water Tower State Revolving Loan Fund $4,396,500.00 Estimated Total $4,953,500.00 Improvement Packet Description Supporting Information Est. Cost One Mobile GIS Laptop. Improved efficiency. Ability for distribution staff in the field to access the same level of GIS information for water mains, hydrants, valves, and meter records available in the department offices. These units are fixed in the work vehicles to prevent theft. $ 5,500.00 Two electronic tablets Used for capturing GIS information in the field during inspection for live data entry into the mapping system.$ 3,040.00 One GPS unit Used for field data collection of water main appurtenances such as valves, bend, and hydrants for accurate GIS location data entry. Reduces the need for further surveying. $ 2,644.00 Estimated Total $ 11,184.00 Thank you & Questions