The URL can be used to link to this page

Water Department Fiscal Year 2016 Budget PresentationCity of Dubuque Public Hearings # 1. ITEM TITLE: SUMMARY: SUGGESTED DISPOSITION: Copyright 2014 Water Department Fiscal Year 2016 Budget Presentation ATTACHMENTS : Description ❑ Water Department FY16 Recommended Budget Type Supporting Documentation Water Department -8- WATER DEPARTMENT Budget Highlights Employee Expense Supplies and Services Machinery and Equipment Total Administrative Overhead Recharges/Finance Utility Billing/Payment in Lieu of Taxes Payment to Construction Fund Debt Service Total Requirements Operating Revenue Net Operating Surplus (Deficit) Personnel - Authorized FTE FY 2013/14 Actual 2,311,965 2,158,189 62,020 4,532,174 FY 2014/15 Adopted 2,352,337 2,129, 678 199,503 4,681,518 FY 2014/15 Amended 2,344,930 2,166, 090 199,503 4,710,523 FY 2015/16 Recomm'd 2,266,019 2,212,805 785,207 5,264,031 % Change from Adopted FY 2014/15 -3.7% 3.9% 293.6% 12.4% 1,185, 691 1,326,674 1,326,403 300,325 -77.4% 940,000 595,000 595,000 24,100 -95.9% 1,263,145 1,569,467 1,371,589 1,627,792 3.7% 7,921,010 8,172,659 8,003,515 7,216,248 -11.7% 7,727,159 8,092,703 7,874,339 8,642,689 6.8% (193,851) (79,956) (129,176) 1,426,441 1,506,397 26.07 26.07 25.57 25.57 * Revenues include a 10% rate increase, generating $558,128 for the Operating Budget and $139,532 for the Capital Budget (each 1% generates $69,766). Improvement Package Summary 1 of 1 This improvement package would add a full-time Utility Engineer (GE38) and would increase the efficiency and quantity of the operation and capital improvement data and projects being completed with the Water Department. This position would be responsible for assisting the Water Department Manager and/or designee with the operating, maintaining and construction of the water treatment plant, pump stations, tanks, towers, wells and the water distribution network. This person would act as the liaison with the city engineering department and to outside consulting firms. As the city continues to grow and the water system becomes of age creates a demand on staff's 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. Related Cost: $ 108,549 Water User Fees — Recurring Water User Fee Impact: +1.55% Activity: Water Administration Significant Line Items at Maintenance Level (Without Recommended Improvement Packages) -9- Recommend -No Employee Expense 1. The City wage plan for non -bargaining unit employees will not increase and bargaining unit employees will receive a 2.25% wage increase in FY 2016. 2. The Iowa Public Employee Retirement System (IPERS) City contribution remains at 8.93% and the employee contribution remains at 6.18% in FY 2016. 3. The City portion of health insurance expense decreased from $1,190 in FY 2015 to $1,040 in FY 2016 per month per contract, resulting is a savings of $45,000 (-12.61 %). 4. Employee Physicals decreased from $2,561 in FY 2015 to $872 in FY 2016 based on FY 2014 actual of $854. 5. Safety Equipment increased from $10,822 in FY 2015 to $13,208 in FY 2016. This line item represents hard hats, safety glasses, gloves and high visibility vests. 6. FY 2016 is the fourth year that eligible retirees with at least twenty years of continuous service in a full-time position or retired as a result of a disability and are eligible for pension payments from the pension system can receive payment of their sick leave balance with a maximum payment of one -hundred twenty sick days payable bi-weekly over a five year period. The sick leave payout included in Water's budget is $7,577 (for one employee) in FY 2016. 7. During FY 2015, the Water Distribution Supervisor was upgraded from GE -33 to GE -37. This is an increase of $16,008 in FY 2016. In addition, the full-time secretary was changed to part-time (-0.50 FTE). Supplies & Services 8. Safety Related Supplies increased from $3,549 in FY 2015 to $7,661 in FY 2016 based on FY 2014 actual $7,510 plus 2%. 9. Plumbing Materials increased from $7,848 in FY 2015 to $12,125 in FY 2016 based on FY 2014 actual $11,887 plus 2%. 10. Dues and Memberships increased from $3,954 in FY 2015 to $5,128 in FY 2016 due to increasing Plant Operations and Maintenance by $992. 11. Property Insurance increased from $75,541 in FY 2015 to $90,041 in FY 2016 based on FY 2015 actual of $84,150 plus 7%. 12. Damage Claims increased from $0 in FY 2015 to $2,867 in FY 2016 based on FY 2014 actual $2,811 plus 2%. 13. Electricity Utility Expense increased from $491,828 in FY 2015 to $549,045 in FY 2016 based on FY 2014 actual of $549,045. 14. Gas Utility Expense increased from $37,835 in FY 2015 to $43,344 in FY 2016 based on FY 2014 actual of $41,210 plus 5%. -10- 15. Property Maintenance decreased from $49,430 in FY 2015 to $43,137 in FY 2016 based on FY 2014 actual $42,291 plus 2%. 16. Custodial Services decreased from $2,000 in FY 2015 to $689 in FY 2016 based on FY 2014 actual $675 plus 2%. 17. Motor Vehicle Fuel increased from $27,792 in FY 2015 to $34,814 in FY 2016 based on FY 2014 actual $41,446 minus 20%. 18. Machinery and Equipment Maintenance increased from $61,322 in FY 2015 to $77,897 in FY 2016 based on FY 2014 actual $76,370 plus 2%. 19. Costs for Fluoride, Phosphate, Chlorine, Lime, Polymer, and Liquid Co2 expense (water processing materials) are projected to increase from $405,079 in FY 2015 to $406,052 in FY 2016 based on FY 2014 actual $398,089 plus 2%. 20. Programming decreased from $4,500 in FY 2015 to $562 in FY 2016 based on FY 2014 actual $551 plus 2%. This line item represents System Control and Data Acquisition (SCADA) programming. 21. Consultant Services remains at $125,000 in FY 2016 for the Smarter Sustainable Dubuque Project Manager. 22. Environmental Testing decreased from $50,000 in FY 2015 to $26,803 in FY 2016 based on FY 2014 actual $26,278 plus 2%. This line item represents the lab services provided by the environmental lab at Water and Resource Recovery Center. 23. Administrative overhead charges have decreased from $1,072,719 in FY 2015 to $142,884 in FY 2016. Machinery & Equipment 24. Equipment replacement items at the maintenance level include ($107,181): Meters Cell Phones (3) $ 360 Software $ 1,000 Large Water Meters $ 15,000 Plant Operation & Maintenance Software $ 6,000 Laboratory Equipment $ 3,500 Shop Equipment $ 1,000 Pumps $ 1,000 Cell Phones (3) $ 360 Water Distribution System Tapping Machine (2) $ 13,700 Hydrants $ 62,441 Barricades $ 1,000 Cell Phones (8) $ 1,320 -11- Software $ 500 In addition, maintenance related items that have historically been budgeted in the capital improvement program have been moved to the operating budget to more accurately reflect the cost of operations. These items budgeted in equipment line items are as follows ($678,026): Automatic Meter Reading System Maintenance $15,000 Filter Maintenance Program $25,000 Water Main Break Replacements $504,000 Water Meter Exchange $68,500 Water Valve Box Maintenance $15,000 Water Meter Testing $25,000 Well Maintenance Program $25,526 Debt Service 25. Debt service reflects repayment to ($1,627,792): 2008 SRF Clear Well $62,288 (last payment 2028) 2009 Revenue Bonds Water Projects $115,750 (last payment 2023) 2010 SRF Meter Change -Out $218,425 (last payment 2031) 2011 Revenue Bonds Water Projects $380,075 (last payment 2030) 2012 GO Bond Water Tower & Line on Northwest Arterial $199,400 (last payment FY 2017) 2012 GO Bond Water Projects $111,447(last payment 2032) 2013 GO Bond Water Projects $42,771 (last payment 2033) 2013 GO Bond Water Projects $132,050 (last payment 2032) 2014 GO Bond Water Projects $295,131 (last payment 2033) 2016 GO Bond Water Projects $70,455 (last payment 2035) 26. Payments to the Depreciation Fund are adjusted when debt service either increases or decreases in order to avoid significant fluctuations related to debt. Revenue 27. Flat Rates increased from $16,000 in FY 2015 to $17,371 in FY 2016. FY 2014 actual was $35,532. 28. Fire Protection Rates increased from $116,262 in FY 2015 to $130,500 in FY 2016 based on FY 2014 actual $130,444. 29. Connection Charge Front Footage increased from $32,750 in FY 2015 to $45,657 in FY 2016 based on a three year average of FY 2012, 2013 and 2014. 30. Penalties increased from $63,940 in FY 2015 to $70,683 in FY 2016 based on a three year average of FY 2012, 2013 and 2014. 31. Monthly Rental increased from $88,679 in FY 2015 to $91,936 in FY 2016 based on FY 2014 actual of $91,636. 32. Water fees have been projected based on a ten percent (10%) rate increase effective July 1, 2015. -12- (1) Equipment Mechanic City Of Dubuque Water Department Organizational Chart (1) Water Department Manager (1) Water Plant Manager (8) Plant Operators (0.50) Secretary (1) Electronic Technician (1) GIS Specialist -13- (1) Water Distribution Supervisor (1) Water Engineering Assistant r- (1) Water Distribution Foreman (3) Meter Repairworker I (2) Equipment Operator II (4) Truck Drivers WATER DEPARTMENT The Water Department ensures our community has high quality, safe, reliable and affordable drinking water. Water Department 1 Administration / 1 Plant Operations and Maintenance Water Distribution Expenditures and Resources by Department and Category Water Meters % Change 201 FY 2014115 FY 2014115 FY 2015116 from Adopted Budget Highlights Actu Adopted Amended Recomm'd FY 2014115 Employee Expense 2,311,965 2,352,337 2,344,930 2,266,019 -3.7% Supplies and Services 2,158,189 2,129,678 2,166,090 2,212,805 3.9% Machinery and Equipment 62,020 199,503 199,503 785,207 293.6% Total 4,532,174 4,681,518 4,710,523 5,264,031 12.4% Administrative Overhead Recharges/Finance Utility Billing/Payment in Lieu of Taxes 1,185,691 1,326,674 1,326,403 300,325 -77.4% Payment to Construction Fund 940,000 595,000 595,000 24,100 -95.9% Debt Service 1,263,145 1,569,467 1,371,589 1,627,792 3.7% Total Requirements 7,921,010 8,172,659 8,003,515 7,216,248 -11.7% Operating Revenue 7,727,159 8,092,703 7,874,339 8,642,689 6.8% Net Operating Surplus (Deficit) Personnel - Authorized FTE (193,851) (79,956) (129,176) 1,426,441 1,506,397 26.07 26.07 25.57 25.57 " Revenues include a 10% rate increase, generating $558,128 for the Operating Budget and $139,532 for the Capital Budget (each 1 % generates $69,766). -14- WATER DEPARTMENT SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES PEOPLE Employees of the Water Department are provided training to ensure the maintenance of the appropriate licenses required by the Iowa Department of Natural Resources. Other job-related educational training is provided to broaden employee skills and increase productivity. PLANNING The Water Department is engaged in conscientious, strategic planning which allows for maintaining compliance with the state and federal regulatory agencies in order to provide the highest quality, safe and cost effective drinking water possible. 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. -15- WATER DEPARTMENT Supporting City and Community Goals Planned and Managed Growth ■ Annexation plans and developments ■ Water main replacement program Partnering for a Better Dubuque ■ Coordinating with other city departments ■ Working with local Contractors ■ Consulting with local Engineers ■ Participating in senior design programs with local universities Financially Responsible City Government and High Performance Organization ■ Managing construction and maintenance costs ■ Fair and equitable rate structure Economic Prosperity ■ Annexation plans ■ Support through infrastructure Social/Cultural Vibrancy ■ Staff education and training ■ Promote healthy community by providing clean, safe drinking water Environmental Integrity ■ Remote meter reading and leak detection ■ Smarter Water Program ■ Efficient use of treatment chemicals ■ Land application of lime sludge from softening process ■ Reuse of filter backwash water -16- WATER DEPARTMENT Detail by Activity Activity: 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. Funding Summary FY 2013/14 Actual FY 2014/15 Adopted FY 2015/16 Recommended Expenditures $2,049,070 $2,412,231 $2,267,547 Resources $7 $0 $0 Position Summary FY 2015/16 FTE's Water Department Manager 1.00 Secretary 0.50 GIS Specialist 1.00 Total FTE's 2.50 Performance Measures Administration — Activity Statement Provides evaluation and coordination of daily operations and long term planning of the department and interacts with state and federal regulatory agencies to maintain regulatory compliance. Goals Maintain efficient and effective delivery of potable water and fire protection to domestic, commercial and industrial customers. Operate the Water Department as a self-supporting, sustainable utility. J -17- WATER DEPARTMEN!T objective: 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. objective: 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 -18- 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 J -19- WATER DEPARTMENT Detail by Activity Activity: 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 analyses 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. Funding Summary FY 2013/14 Actual FY 2014/15 Adopted FY 2015/16 Recommended Expenditures $2,348,377 $2,437,399 $2,402,006 Resources $411 $200 $400 Position Summary FY 2015/16 FTE's 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 FTE's 11.00 -20- WATER DEPARTMENT Performance Measures rPlPlant 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. Goals Ensure water used for domestic, commercial and industrial purposes is safe for drinking Provide an adequate and safe supply of water to customers in order to meet consumer demand and fire suppression requirements Provide excellent customer service Objective: 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 miction 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. THE CITY OF DUB E FINISHED WATER TAP REPORT MCL/AL MOO COMPLIANCE SAMPLEANALYTE DATE am... TYNOU. SOURCE TYPE VALUE MN MAX Barium Fluoride4 Nitrate Sodium 22 10 NIA 4 10 N/A SGL MCL SGL SGL 0.0201 0.69 0.6 14 N/A 0.23 0.5 N/A N/A 1.55 0.6 NA 09/04/2012 3013 2013 09/01/2013 NO NO NO NO Erosion of n. al deposits Erosion of natural deposits; Added to water during treetmem poceu , Runoff from fertilizer use; leeching from septic tanks, sewage; evoslmr of natural deposes of natural deposits; Added to water during treatment process 1 Masterpiece ort the Mississippi 2014 }eErosion Water Quality Report 6 frS 3e - lr - f4 tlr " DISTRIBUTION SYSTEM REPORT .OJIL Ma.symmt n 60a11EfANCE Lamm Et.Tg ANALYTE TYEvlfpRM ma VAIN MN Total Chlorine (ppm) Total Coliform Bacteria Total Haloacetic Acids (ppb) Total Trihalomethanes (ppb) 4.0 PreSeMe in ol mo5nthly samples co 80 4.0 Presence in >5` of monthly samples N/A NIA RM TCR LRM LRM 1.0 1 positive Sample 14.00 45.00 0.3 0 10.00 32.00 .MAX 1.63 1 19.00 54.00 2013 7/31/2013 2013 2013 NO No NO NO Water additive d le tomtit microbus Naturally present in the environment Oy.oroducts of drinking water disinfection ay -products of drinking water chlorination ANALYSE AL MQ RNs DETE MPmax DATE I.,.IYPItAt 5OMIR I IYIl VALDE sow arm Copper (ppm) Lead (ppb) 1.3 15 1.3 0 90th 00256 90th 8.70 NO NO 0.0423 18 68 66 0 1 7013 2013 NO NO Corrosion of twusclsokl Plumbing systems; Erosion of natural deposits; leaching from wood Preservatives Corrosion ofhousenoldplumbing sritems;Erosion of natural deposits The 2014 Water Quality Report can be downloaded at h ttp://citvofdubuque. orq/DocumentCenter/View/20373 -21- WATER DEPARTMENT PROJECTS COMPLETED Bunker Hill Pump Station Renovations Arc Flash Study Well Maintenance Well Field Electrical Upgrades J Objective: Produce high quality water at the required pressures and volumes Maintaining the proper pressures and volumes ensures adequate fire suppression abilities and consumer demand 3,000 2,900 2,800 2,700 2,600 2,500 2,400 2,300 veer 7a/d 2,941 2,902 FY'05 FY'06 FY'07 FY'08 FY'09 FY'10 FY'11 FY'12 FY'13 -22- DID YOU KNOW? Dubuque gets its drinking water from wells. There are five shallow wells located at the A.Y. McDonald Park and four deep wells located around the Eagle Point Water Treatment Plant on Hawthorne Street. WATER DEPARTMENT 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 -23- WATER DEPARTMENT Detail by Activity Activity: Water 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. Funding Summary FY 2013/14 Actual FY 2014/15 Adopted FY 2015/16 Recommended Expenditures $3,223,904 $2,992,079 $2,255,587 Resources $7,614,621 $8,012,253 $8,559,706 Position Summary FY 2015/16 FTE's 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 I 0.07 Total FTE's 9.07 Performance Measures Water Distribution — Activity Statement Water Operate and maintain a water distribution system consistent with established procedures recognized by the American Water Works Association for efficient management practices. Goals Ensure water used for domestic, commercial and industrial purposes is safe for drinking Provide an adequate and safe supply of water to customers in order to meet consumer demand and fire suppression requirements Provide excellent customer service -24- WATER DEPARTMENT Objective: Ensure the integrity of the distribution system Maintains the safety of our drinking water tuuS11H1u11nsB117111[Ilf11EMILMealte._ wir !/ ?-!7 PROJECTS r-- COMPLETED Phase 4 of the Fire Hydrant Painting Program Street Reconstructions /Engineering Projects Objective: Addressing customer and system issues in a timely manner Minimizes the time customers are without water DID YOU KNOW? The distribution system is composed of 321 miles of water mains ranging in diameter from 4" up to 30", 8,017 control valves; and 2,330 fire hydrants FY'05 FY136 FY' 07 FY'08 FY' 09 FY'10 FY' 11 FY' 12 FY' 13 FY' 14 -25- WATER DEPARTMENT 350 300 250 200 150 100 50 Juice 7;tr 271. 301 270 187 181. FY'05 FY'06 FY'07 FY'08 FY'09 FY'10 FY'11 FY'12 FY'13 FY'14 Fire Hydrant Painting Project Phase 4 To date there have been 2,282 hydrants repainted out of approximately 2,330 public and private fire hydrants in the distribution system -26- 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. -27- WATER DEPARTMENT Detail by Activity Activity: 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. Funding Summary FY 2013/14 Actual FY 2014/15 Adopted FY 2015/16 Recommended Expenditures $299,659 $330,950 $291,108 Resources $112,120 $80,250 $82,583 Position Summary FY 2015/16 FTE's Water Meter Repair Worker I 3.00 Total FTE's 3.00 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. Goals Provide a water meter reading and backflow prevention system which will reflect accurate charges to the consumer. Provide dependable meter repair, backflow and installation services. Provide excellent customer service -28- WATER DEPARTMENT Objective: Provide accurate meter readings Ensures that customers pay for the appropriate amount of water used DID YOU KNOW? Since the adoption by the Dubuque City Council of the Backflow Prevention Program, we have established over 1,778 accounts having Backflow Protection and we also monitor over 2,524 Control Devices. These accounts are a combination of various Industrial and Commercial facilities. Annually we receive $25.00 per device as the administration fee. It is expected an additional 50 accounts will be established before the end of the fiscal year 2015. Objective: Backflow protection Minimizes the possibility of contamination of the distribution system by preventing back siphonage -29- WATER DEPARTMENT Objective: Responding to customer inquiries in a timely manner Maintains consumer confidence in the water utility FUTURE INITIATIVES Continue to educate the public of the importance of adhering to all State and Federal mandates conceming Backflow Control Devices, which protect public water supplies from potential contamination Continue to provide excellent customer Qervice &,*e Cad; 1,200 -7 1,000 -7 800 600 400 200 -V 1,005 869 800 713 681 714 433 591 o 1 FY'06 FY'07 FY'08 FY'09 FY'10 FY'11 FY'12 FY'13 FY'14 -30- 1 Recommended Operating Revenue Budget - Department Total 42 - WATER Fund Account Account Title FY13 Actual FY14 Actual FY15 Adopted FY16 Recomm'd Revenue Revenue Budget Budget 640 43110 INVESTMENT EARNINGS 640 43232 LEASE, FINLEY HOSIPTAL 23,347 0 22,924 0 8,000 0 21,000 1 43 - USE OF MONEY AND PROPERTY 23,347 22,924 8,000 21,001 640 51105 METER RATES 640 51110 FLAT RATES 640 51115 FIRE PROTECTION RATES 640 51125 TAPS -3/4 & 1 INCH 640 51130 CONNECT CHG LARGE SERVICE 640 51135 CONNECT CHG FRONT FOOTAGE 640 51145 SALE OF METERS 640 51146 SALE OF UFR DEVICES 640 51160 BOX -LID -PART SALES 640 51165 MAINTENANCE CHARGES 640 51170 REPAIR OF METERS 640 51175 SHUT OFF PENALTIES 640 51176 METER TAMPERING FEE 640 51177 CALL OUT CHARGE 640 51178 CREDIT CARD FEE 640 51180 CROSS CON. CNTL ADMIN FEE 640 51215 PENALTIES 640 51310 MONTHLY RENTAL 640 51981 COPY SERVICE CHARGES 51 - CHARGES FOR SERVICES 1 640 640 640 640 53610 53615 53620 53630 INSURANCE CLAIMS DAMAGE CLAIMS REIMBURSEMENTS -GENERAL SALES TAX COLLECTION 6,351,740 6,649,493 7,200,332 7,695,211 21,002 35,532 16,000 17,371 116,262 130,444 116,262 130,500 37,444 22,052 36,500 32,546 10,722 26,082 23,250 23,801 34,311 63,015 32,750 45,657 20,626 21,225 16,500 18,530 1,483 11,889 1,200 1,300 9 0 0 0 9,584 11,416 7,500 9,575 3,247 16,415 3,800 3,326 12,879 12,551 10,000 12,500 2,111 2,719 1,000 2,500 2,395 2,010 1,000 1,500 0 2 0 0 58,540 61,133 57,700 58,907 71,335 79,882 63,940 70,683 101,044 91,636 88,679 91,636 0 7 0 0 6,854,736 7,237,504 7,676,413 8,215,543 0 597 0 0 5,177 47,081 6,950 5,195 107 1,583 660 50 376,216 397,048 400,000 400,000 53- MISCELLANEOUS 381,500 446,309 407,610 405,2451 640 54106 EQUIPMENT SALES 640 54109 SALVAGE SALES 640 54210 GO BOND PROCEEDS 640 54220 BOND DISCOUNT 18,750 17,500 0 0 504 2,922 680 900 950,000 0 0 0 11,686 0 0 0 54 - OTHER FINANCING SOURCES 980,941 20,422 680 900 42 - WATER TOTAL 8,240,523 7,727,159 8,092,703 8,642,689 -31- Recommended Operating Expenditure Budget - Department Total 42 - WATER Fund Account Account Title FY13 Actual FY14 Actual FY15 Adopted FY 16 Recomm'd Expense Expense Budget Budget 640 640 640 640 640 640 640 640 640 640 640 640 640 640 640 640 61010 61020 61050 61071 61072 61091 61092 61099 61310 61320 61410 61415 61416 61640 61650 61660 FULL-TIME EMPLOYEES PART-TIME EMPLOYEES OVERTIME PAY HOLIDAY PAY -OVERTIME TANK CLIMBING PAY SICK LEAVE PAYOFF VACATION PAYOFF WAGE ADJUSTMENT IPERS SOCIAL SECURITY HEALTH INSURANCE WORKMENS' COMPENSATION LIFE INSURANCE SAFETY EQUIPMENT MEAL ALLOWANCE EMPLOYEE PHYSICALS 1,363,160 4,068 95,492 14,608 1,275 229 4,841 0 128,190 109,075 277,500 62,006 1,149 8,375 409 2,511 1,464,936 4,178 100,919 17,284 540 0 0 0 141,796 116,434 375,456 75,382 1,204 11,986 996 854 1,465,456 2,862 105,040 14,000 1,200 0 0 30,049 141,857 121,525 371,280 82,099 3,169 10,822 417 2,561 1,468,638 3,066 105,040 14,000 1,200 7,039 0 0 138,316 119,031 312,000 80,174 2,935 13,208 500 872 61 - WAGES AND BENEFITS 2,072,889 2,311,964 2,352,337 2,266,019 640 62010 OFFICE SUPPLIES 5,192 4,610 5,295 4,703 640 62011 UNIFORM PURCHASES 13,146 13,547 13,408 13,817 640 62030 POSTAGE AND SHIPPING 2,552 1,532 2,604 1,608 640 62033 HAND TOOLS/EQUIPMENT 0 1,674 2,500 3,207 640 62034 REPAIR PARTS/SUPPLIES 0 6,714 8,000 9,669 640 62036 CONSTRUCTION SUPPLIES 0 786 4,000 2,802 640 62061 DP EQUIP. MAINT CONTRACTS 11,659 13,440 15,975 16,956 640 62062 JANITORIAL SUPPLIES 7,336 5,171 7,984 5,775 640 62063 SAFETY RELATED SUPPLIES 2,780 7,510 3,549 7,661 640 62064 ELECTRICAL SUPPLIES 14,519 16,115 15,410 16,937 640 62065 LAB SUPPLIES 14,510 15,549 14,801 15,860 640 62066 PLUMBING MATERIALS 7,694 11,887 7,848 12,125 640 62090 PRINTING & BINDING 443 345 562 352 640 62110 COPYING/REPRODUCTION 2,863 2,246 2,889 2,291 640 62130 LEGAL NOTICES &ADS 558 3,137 1,361 1,273 640 62170 SUBSCRIPTIONS -BOOKS -MAPS 819 722 1,293 936 640 62190 DUES & MEMBERSHIPS 3,078 3,740 3,954 5,128 640 62206 PROPERTY INSURANCE 46,494 72,003 75,541 90,041 640 62207 BOILER INSURANCE 1,427 1,400 1,400 1,454 640 62208 GENERAL LIABILITY INSURAN 21,790 22,016 22,460 22,071 640 62210 SALES TAX 376,485 392,726 400,000 400,000 640 62221 DAMAGE CLAIMS 0 2,811 0 2,867 640 62310 TRAVEL -CONFERENCES 5,042 4,383 6,736 4,575 640 62320 TRAVEL -CITY BUSINESS 6 0 500 200 640 62340 MILEAGE/LOCALTRANSP 5,635 6,361 5,747 6,488 640 62360 EDUCATION &TRAINING 4,066 5,457 4,600 6,026 640 62411 UTILITY EXP -ELECTRICITY 491,828 549,045 491,828 549,045 -32- Recommended Operating Expenditure Budget - Department Total 42 - WATER Fund Account Account Title FY13 Actual FY14 Actual FY15 Adopted FY 16 Recomm'd Expense Expense Budget Budget 640 62412 UTILITY EXP -GAS 640 62414 UTILITY EXP -FUEL OIL 640 62415 UTILITY EXPENSE STORMWATR 640 62421 TELEPHONE 640 62423 TELECOMMUNICATION CG 640 62431 PROPERTY MAINTENANCE 640 62433 CUSTODIAL SERVICES 640 62435 ELEVATOR MAINTENANCE 640 62436 RENTAL OF SPACE 640 62437 BARRICADE RENTAL 640 62511 FUEL, MOTOR VEHICLE 640 62521 MOTOR VEHICLE MAINT. 640 62528 MOTOR VEH. MAINT. OUTSOUR 640 62611 MACH/EQUIP MAINTENANCE 640 62613 METER MAINTENANCE 640 62614 EQUIP MAINT CONTRACT 640 62630 FLUORIDE 640 62631 LIME 640 62632 PHOSPHATE 640 62633 CHLORINE 640 62638 POLYMER 640 62639 LIQUID CO2/02 640 62663 SOFTWARE LICENSE EXP 640 62664 LICENSE/PERMIT FEES 640 62665 FALSE ALARM CHARGES 640 62669 PROGRAMMING 640 62671 MISC. OPERATING SUPPLIES 640 62675 VALVES 640 62676 PIPE -SPECIAL FITTINGS 640 62692 LANDFILL FEES 640 62696 OUTSIDE COLLECTOR EXPENSE 640 62710 CONTRACTOR SERVICES 640 62713 LEGAL SERVICES 640 62716 CONSULTANT SERVICES 640 62721 FINANCIAL CONSULTANT 640 62726 AUDIT SERVICES 640 62731 MISCELLANEOUS SERVICES 640 62746 ONE CALL OPERATION 640 62767 ENVIRON. TESTING/MON. 640 62780 HAULING SERVICES 640 62811 ENG. DIVISION SERVICES 36,733 12,103 0 16,278 7,419 24,164 0 0 1,670 0 34,715 18,093 2,925 60,120 5,975 695 25,798 244,155 57,615 36,885 8,616 24,066 0 7,776 305 472 10,486 10,771 24,081 51 6,117 20 4,113 90,889 770 3,200 29,665 3,983 31,496 116,102 0 41,210 3,977 0 14,106 8,012 42,291 675 1,998 1,670 0 41,446 26,121 13,665 76,370 9,331 0 14,040 262,037 66,007 30,276 6,829 18,900 0 6,790 0 551 262 9,957 25,980 5,179 5,235 124 0 102,400 0 3,325 0 3,877 26,278 124,344 0 37,835 12,103 1,400 14,786 7,133 49,430 2,000 1,000 1,704 300 27,792 18,455 2,983 61,322 6,094 709 26,314 249,038 58,768 37,623 8,789 24,547 0 7,932 311 4,500 0 10,000 25,000 52 6,239 20 0 125,000 785 3,500 0 4,062 50,000 121,907 0 34,675 12,103 1,400 14,284 8,173 68,137 689 2,038 1,704 0 34,814 19,534 3,439 77,897 9,517 0 14,321 267,278 67,327 30,882 6,966 19,278 15,000 6,926 0 562 409 10,157 26,500 5,283 6,545 126 0 0 785 3,600 25,000 3,955 26,803 126,831 56,000 62 - SUPPLIES AND SERVICES 1,998,245 2,158,189 2,129,678 2,212,805 640 63314 PAYROLL OVERHEAD 3,785 0 0 0 63 - ADMIN/OVERHEAD/STORES GAR 3,785 0 0 0 -33- Recommended Operating Expenditure Budget - Department Total 42 - WATER Fund Account Account Title FY13 Actual FY14 Actual FY15 Adopted FY 16 Recomm'd Expense Expense Budget Budget 640 640 640 640 640 640 640 640 640 640 640 640 640 640 71123 71312 71314 71410 71413 71414 71415 71419 71510 71511 71516 71550 71619 72418 SOFTWARE VAN/PICKUP/WAG REPL TRUCK -REPLACEMENT SHOP EQUIPMENT LABORATORY EQUIPMENT AIR HAMMER/DRILL SAWS TAPPING MACHINE HYDRANTS PUMPS LARGE WATER METERS MISCELLANEOUS EQUIPMENT OTHER MAINT. EQUIPMENT TELEPHONE RELATED 8,269 0 28,127 3,142 0 0 1,195 2,260 19,467 675 7,504 956 0 0 6,598 0 0 4,557 3,323 1,421 0 0 17,050 520 28,196 0 0 0 9,648 42,000 0 4,114 3,500 0 1,800 0 20,441 6,500 15,000 2,300 92,000 1,200 7,500 0 0 1,000 3,500 0 0 13,700 62,441 1,000 83,500 0 0 2,040 71 - EQUIPMENT 71,595 61,666 198,503 174,681 640 72115 BARRICADES/WARN SIGNALS 508 355 1,000 1,000 72 - EQUIPMENT 508 355 1,000 1,000 640 73211 CONST.CONTR-NOT BLDG 0 0 0 609,526 73 - CIP EXPENDITURES 0 0 0 609,526 640 74111 PRINCIPAL PAYMENT 640 74112 INTEREST PAYMENT 1,670,804 789,975 945,473 826,193 537,586 473,170 623,994 801,599 74 - DEBT SERVICE 2,208,389 1,263,145 1,569,467 1,627,792 640 91100 TO GENERAL 174,884 960,389 1,072,719 142,985 640 91250 TO ROAD USE TAX FUND 0 80,000 80,000 0 640 91740 TO WATER CONSTRUCTION 765,000 940,000 595,000 24,100 91 - TRANSFER TO 939,884 1,980,389 1,747,719 167,085 42- WATER TOTAL 7,295,296 7,775,708 7,998,704 7,058,9081 -34- Recommended Expenditure Budget Report by Activity & Funding Sounce 42 - WATER UNDISTRIBUTED - 10640 FUNDING SOURCE: WATER UTILITY OPERATION Account FY13 Actual Expense FY14 Actual Expense FY15 Adopted Budget FY16 Recomm'd Budget SUPPLIES AND SERVICES 40,665 5,235 7,024 7,330 TRANSFER TO 939,884 1,980,389 1,747,719 167,085 UNDISTRIBUTED 980,549 1,985,624 1,754,743 174,415 WATER ADMINSTRATION - 42100 FUNDING SOURCE: WATER UTILITY OPERATION Account FY13 Actual Expense FY14 Actual Expense FY15 Adopted Budget FY16 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 3,785 0 0 0 DEBT SERVICE 2,208,389 1,263,145 1,569,467 1,627,792 SUPPLIES AND SERVICES 489,432 512,858 551,098 420,407 WAGES AND BENEFITS 266,307 273,067 291,666 219,348 WATER ADMINSTRATION 2,967,913 2,049,070 2,412,231 2,267,547 METERS - 42300 FUNDING SOURCE: WATER UTILITY OPERATION Account FY13 Actual Expense FY14 Actual Expense FY15 Adopted Budget FY16 Recomm'd Budget EQUIPM ENT 11,080 28,986 60,648 16,360 SUPPLIES AND SERVICES 21,297 25,998 25,025 28,217 WAGES AND BENEFITS 222,478 244,675 245,277 246,531 METERS 254,855 299,659 330,950 291,108 PLANT OPER. & MAINT - 42400 FUNDING SOURCE: WATER UTILITY OPERATION Account FY13 Actual Expense FY14 Actual Expense FY15 Adopted Budget FY16 Recomm'd Budget EQUIPM ENT 4,869 9,890 105,300 11,860 SUPPLIES AND SERVICES 1,272,097 1,397,150 1,365,435 1,429,858 WAGES AND BENEFITS 797,860 941,338 966,664 960,288 PLANT OPER. & MAINT 2,074,826 2,348,377 2,437,399 2,402,006 WATER DISTR. SYSTEM - 42700 FUNDING SOURCE: WATER UTILITY OPERATION Account FY13 Actual Expense FY14 Actual Expense FY15 Adopted Budget FY16 Recomm'd Budget EQUIPMENT 56,154 23,144 33,555 78,961 SUPPLIES AND SERVICES 174,755 216,949 181,096 205,993 WAGES AND BENEFITS 786,245 852,885 848,730 839,852 WATER DISTR. SYSTEM 1,017,153 1,092,978 1,063,381 1,124,806 AUTO MTR RD SYS MNT PROG - 42710 FUNDING SOURCE: WATER UTILITY OPERATION Account FY13 Actual FY14 Actual FY15 Adopted Expense Expense Budget FY16 Recomm'd Budget CIP EXPENDITURES AUTO MTR RD SYS MNT PROG 0 0 0 15,000 0 0 0 15,000 FILTER MAINT PROGRAM - 42715 -35- Recommended Expenditure Budget Report by Activity & Funding Sounce 42 - WATER FUNDING SOURCE: WATER UTILITY OPERATION Account FY13 Actual Expense FY14 Actual Expense FY15 Adopted Budget FY16 Recomm'd Budget CIP EXPENDITURES FILTER MAINT PROGRAM 1 0 0 0 25,000 O 0 0 25,000 FIRE HYDRANT PAINTING - 42720 FUNDING SOURCE: WATER UTILITY OPERATION Account FY13 Actual Expense FY14 Actual Expense FY15 Adopted Budget FY16 Recomm'd Budget SUPPLIES AND SERVICES FIRE HYDRANT PAINTING 0 0 0 10,000 O 0 0 10,000 GIS MAINT/UPDATES - 42730 FUNDING SOURCE: WATER UTILITY OPERATION Account FY13 Actual Expense FY14 Actual Expense FY15 Adopted Budget FY16 Recomm'd Budget SUPPLIES AND SERVICES GIS MAINT/UPDATES 0 0 0 15,000 0 0 0 15,000 SERVICE LINE ASSIST - 42735 FUNDING SOURCE: WATER UTILITY OPERATION Account FY13 Actual Expense FY14 Actual Expense FY15 Adopted Budget FY16 Recomm'd Budget SUPPLIES AND SERVICES SERVICE LINE ASSIST 0 0 0 15,000 0 0 0 15,000 VALVE EXERCISE PROGRAM - 42740 FUNDING SOURCE: WATER UTILITY OPERATION Account FY13 Actual Expense FY14 Actual Expense FY15 Adopted Budget FY16 Recomm'd Budget SUPPLIES AND SERVICES VALVE EXERCISE PROGRAM 0 0 0 25,000 O 0 0 25,000 WATER MAIN REPLACEMENTS - 42755 FUNDING SOURCE: WATER UTILITY OPERATION Account FY13 Actual FY14 Actual FY15 Adopted Expense Expense Budget FY16 Recomm'd Budget CIP EXPENDITURES 0 0 0 504,000 SUPPLIES AND SERVICES 0 0 0 56,000 WATER MAIN REPLACEMENTS 0 0 0 560,000 WATER METER EXCHANGE - 42760 FUNDING SOURCE: WATER UTILITY OPERATION Account FY13 Actual Expense FY14 Actual Expense FY15 Adopted Budget FY16 Recomm'd Budget EQUIPMENT WATER METER EXCHANGE 0 0 0 68,500 O 0 0 68,500 WATER VALVE BOX MAINT - 42770 FUNDING SOURCE: WATER UTILITY OPERATION Account FY13 Actual Expense FY14 Actual Expense FY15 Adopted Budget FY16 Recomm'd Budget CIP EXPENDITURES 0 0 0 15,000 WATER VALVE BOX MAINT 0 0 0 15,000 -36- Recommended Expenditure Budget Report by Activity & Funding Sounce 42 - WATER WATER METER TESTING - 42790 FUNDING SOURCE: WATER UTILITY OPERATION Account FY13 Actual Expense FY14 Actual Expense FY15 Adopted Budget FY16 Recomm'd Budget CIP EXPENDITURES WATER METER TESTING 0 0 0 25,000 o o 0 25,000 WELL MAINT PROGRAM - 42795 FUNDING SOURCE: WATER UTILITY OPERATION Account FY13 Actual Expense FY14 Actual Expense FY15 Adopted Budget FY16 Recomm'd Budget CIP EXPENDITURES 0 0 0 25,526 WELL MAINT PROGRAM 0 0 0 25,526 WATER TOTAL $7,295,295.96 $7,775,707.83 $7,998,704.00 $7,058,908.00 -37- CITY OF DUBUQUE, IOWA DEPARTMENT DETAIL - PERSONNEL COMPLEMENT 42 WATER DEPARTMENT FD JC WP -GR JOB CLASS 61010 Full Time Employee Expense FY 2014 FY 2015 FY 2016 FTE BUDGET FTE BUDGET FTE BUDGET 640 3275 GE -40 WATER DEPARTMENT MANAGER 1.00 99,101 1.00 103,098 1.00 103,453 640 2775 GE -37 WATER PLANT MGR. 1.00 82,470 1.00 86,155 1.00 86,436 640 3200 GE -37 WATER DISTRIBUTION SUPERVISOR 1.00 76,964 1.00 80,378 1.00 69,063 640 2950 GE -33 WATER ENGINEERING ASSISTANT 1.00 67,492 1.00 70,212 1.00 70,444 640 2650 GE -31 FOREMAN- WATER DISTR. 1.00 61,801 1.00 64,911 1.00 65,144 640 2610 GE -30 GIS SPECIALIST 1.00 56,313 1.00 59,163 1.00 59,339 640 0225 GE -25 SECRETARY 1.00 44,389 1.00 46,638 0.00 0 640 OE -09 PLANT OPERATOR 1.00 44,788 0.00 0 0.00 0 640 2400 OE -16 ELECTRONIC TECHNICIAN 1.00 55,616 1.00 57,869 1.00 59,412 640 2800 OE -14 EQUIPMENT MECHANIC 1.00 51,170 1.00 55,512 1.00 56,997 640 2550 OE -13 WATER PLANT OPR CERT GR III/IV 3.00 157,556 3.00 163,914 3.00 168,263 640 2475 OE -12 WATER PLANT OPERATOR CRT GR II 4.00 199,506 5.00 248,039 5.00 262,629 640 2305 OE -10 EQUIPMENT OPERATOR II 2.00 100,204 2.00 104,270 2.00 107,032 640 1775 OE -09 WATER METER REPAIRWORKER I 3.00 142,321 3.00 149,146 3.00 154,871 640 1476 OE -09 WATER DISTR MAINTENANCE WORKE 4.00 187,537 4.00 198,132 4.00 205,555 TOTAL FULL TIME EMPLOYEES 26.00 1,427,228 26.00 1,487,438 25.00 1,468,638 61020 Part -Time Employee Expense 640 0225 GE -25 SECRETARY 640 2050 OE -06 CUSTODIAN I TOTAL PART TIME EMPLOYEES TOTAL WATER DEPARTMENT 0.00 0 0.00 0.07 2,788 0.07 0.07 2,788 0.07 0 0.50 2,905 0.07 2,905 0.57 0 3,066 3,066 26.07 1,430,016 26.07 1,490,343 25.57 1,471,704 -38- ACCT FD JC WP -GR Water Administration -FT 64042100 61010 640 0225 GE -25 64042100 61010 640 GE -30 64042100 61010 640 3275 GE -40 Water Administration -PT 64042100 61020 640 0225 GE -25 Water Meters -FT 64042300 61010 640 1775 OE -09 Water Plant Operation -FT 64042400 61010 640 2475 OE -12 64042400 61010 640 OE -09 64042400 61010 640 2550 OE -13 64042400 61010 640 2775 GE -37 64042400 61010 640 2800 OE -16 64042400 61010 640 3015 OE -14 Water Distribution -FT 64042700 61010 640 1476 OE -09 64042700 61010 640 2305 OE -10 64042700 61010 64042700 61010 64042700 61010 640 2650 GE -31 640 2950 GE -33 640 3200 GE -37 Water Distribution - PT CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY POSITION CLASS Run Date: 01/22/15 FY 2014 FY 2015 FY 2016 FTE BUDGET FTE BUDGET FTE BUDGET SECRETARY GIS SPECIALIST WATER DEPARTMENT MANAGER Total SECRETARY Total WATER METER REPAIRWORKER I Total 1.00 44,389 1.00 46,638 0.00 0 1.00 56,313 1.00 59,163 1.00 59,339 1.00 99,101 1.00 103,098 1.00 103,453 3.00 199,803 3.00 208,899 2.00 162,792 0.00 0 0.00 0 0.50 0 0.00 0 0.00 0 0.50 0 3.00 142,321 3.00 149,146 3.00 154,871 3.00 142,321 3.00 149,146 3.00 154,871 WATER PLANT OPER. CRT GR II 4.00 199,506 5.00 248,039 5.00 262,629 PLANT OPERATOR 1.00 44,788 0.00 0 0.00 0 WATER PLANT OPR CERT GR III/I\ 3.00 157,556 3.00 163,914 3.00 168,263 WATER PLANT MGR. 1.00 82,470 1.00 86,155 1.00 86,436 ELECTRONIC TECHNICIAN 1.00 55,616 1.00 57,869 1.00 59,412 EQUIPMENT MECHANIC 1.00 51,170 1.00 55,512 1.00 56,997 Total 11.00 591,106 11.00 611,490 11.00 633,737 WATER DIST MAINTENANCEWOR EQUIPMENT OPERATOR II FOREMAN - WATER DISTR. WATER ENGINEERING ASSISTAN1 WATER DISTRIBUTION SUPERVIS1 Total 64042700 61020 640 2050 GD -03 CUSTODIAN I Total 4.00 187,537 4.00 198,132 4.00 205,555 2.00 100,204 2.00 104,270 2.00 107,032 1.00 61,801 1.00 64,911 1.00 65,144 1.00 67,492 1.00 70,212 1.00 70,444 1.00 76,964 1.00 80,378 1.00 69,063 9.00 493,998 9.00 517,903 9.00 517,238 0.07 0.07 2,788 0.07 2,788 0.07 2,905 2,905 0.07 3,066 0.07 3,066 TOTAL WATER DEPARTMENT 26.07 1,430,016 26.07 1,490,343 25.57 1,471,704 -39- Capital Improvement Projects by Department/Division WATER CIP Capital Improvement Project FY 13 Actual FY 14 Actual FY 15 Adopted FY 16 Recomm'd Number Title Expense Expense Budget Budget 3602594 SW ARTERIAL MAIN EXT 0 0 0 253,000 7401389 GIS MAINTENANCE/UPGRADE 2,015 10,735 15,000 0 7401390 SERVICE LINE ASSISTANCE 20,600 2,223 30,000 0 7401397 EP OFFICE/LAB PUMP ROOM W 0 6,251 0 0 7401398 WATER INTERNAL LINES -LOAN 0 0 0 0 7401399 WATER MAIN EXTENSIONS AND 3,011 0 0 0 7401400 WATER METER EXCHANGE 113,247 64,469 68,500 0 7401402 ADA IMPROVEMENTS WATER PL 430 0 0 0 7401405 WATER MAIN REPLACEMENTS 1,098,531 1,968,132 1,490,650 442,050 7401409 FIRE HYDRANT REPLACMENTS 41,661 40,875 42,000 0 7401410 VALVE REPLACEMENT 4,559 51,303 0 0 7401411 MAIN EXT ANNEXATION REL. 52,664 37,810 760,200 0 7401412 ANNUAL TANK INSPECTION 0 0 0 0 7401415 SHALLOW WELL REHAB 56,622 50,630 24,310 0 7401422 BUNKER HILL PUMP STATION 653,465 603,503 0 0 7401672 ROOSEVELT RD MAIN EXT. 9,950 26,150 430,000 0 7401826 PAINT PUMP ROOM PIPES 0 0 30,000 50,000 7402044 GREEN ALLEY PILOT PROJECT 143,079 0 0 0 7402145 MILLWORK DIST-WATER MAIN 103,904 0 0 0 7402147 DRINKING WATER STUDY 5,300 106 0 0 7402200 WATER SVC REPAIR GRANT 13,233 10,630 0 0 7402201 FIRE HYDRANT PAINTING 201,693 96,936 0 0 7402202 WATER CIRC SYS POTABLE 72,541 0 0 0 7402203 WATER VALVE BOX MAINT 39,312 26,406 30,000 0 7402204 ASBURY TANK PAINTING 720,877 381,469 0 0 7402205 PUMP REPLC VACUUM FILTER 14,885 0 0 0 7402207 PARK HILL PUMPING ROOF 12,439 0 0 0 7402209 WEST 3RD RENOVATION 0 0 0 0 7402225 MOBILE GIS SYSTEM 39,542 165 0 0 7402261 RAMP UTILITY RELOCATION 205,569 153,509 0 0 7402309 EAGLE PT PLNT DR & PARK 0 0 0 0 7402310 WELL FIELD ELECT UPGRADES 218,170 10,353 0 0 7402311 FILTER MAINTENANCE PRG 0 707 0 0 7402314 AUTO MTR RD SYST MNT PRG 16,340 12,937 15,000 0 7402394 GENERATOR MAINT PROGRAM 53,532 16,242 0 0 7402395 WATER EXT - AIRPORT 166,194 110,415 0 0 7402396 NORTH SOFTENING BASIN REN 457 13,289 0 0 7402397 MCALEECE WATER IMPROV 347 0 0 0 7402398 EP - TREATMENT PPR WIN RP 323 0 0 0 7402399 WTR USGE AND SYS ACCT AUD 191 0 0 0 7402400 BRK BLD - REPAIR - EPP PS 0 15,392 0 0 7402401 N PLNT MTR CTRL CNTR UPGR 16,517 0 0 0 7402402 OFFICES/CTRL RM/LAB REMOD 2,835 860 0 0 -40- Capital Improvement Projects by Department/Division CIP Capital Improvement Project FY 13 Actual FY 14 Actual FY 15 Adopted FY 16 Recomm'd Number Title Expense Expense Budget Budget 7402472 WATER COMP LEAK SURVEY 0 0 100,000 0 7402473 WATER ARC FLASH ANALYSIS 0 21,300 0 0 7402524 ONLINE PROCESS ANALYZER 0 0 15,000 15,000 7402525 N CASCADE WATER MAIN 0 0 877,750 0 7402526 SRF GREEN ALLEY 0 0 250,000 0 7402527 GENERATOR 0 0 225,000 0 7402528 RAW H2O TRANSMISSION LINE 0 0 5,000 50,000 7402594 SW ARTERIAL MAIN EXT 0 0 0 847,388 7402595 CREEK CROSSING RESTORE 0 0 0 46,730 7402596 MAIN RELOC SEWER MANHOLE 0 0 0 20,000 WATER TOTAL 4,104,036 3,732,798 4,408,410 1,724,168 -41- City of Dubuque Recommended Capital Improvement Program Summary Fiscal Year 2016-2020 PROGRAM/DEPT PROJECT DESCRIPTION SOURCE OF FUNDS FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 TOTAL PAGE WATER DEPARTMENT Business Type Southwest Arterial Water Main Extension Water Main Replacements Raw Water Transmission Lines Paint Pipes S Eagle Point Water N Cascade Housing TIF/GO Borrowing GO Borrowing GO Borrowing Plant GO Borrowing Creek Crossing Restoration Water Main Relocation for Sanitary Sewer Manhole Replacement/Rehabilitation Project Online Process Analyzer Replacement Program Water Storage Tank Coating Program Private Water System Purchase Lime Slaker Replacement Study 20" Transmission Main, 12 and 8" Water Main Relocation/Replacement/Extension Bulk CO2 Tank Replacement Vacuum Filter Plant Process Upgrade Source Water Protection Program Annexation Study and Implementation West End Annexation Study and Implementation Phase I Total - Water Department GO Borrowing GO Borrowing GO Borrowing GO Borrowing Water Construction Fund GO Borrowing GO Borrowing GO Borrowing GO Borrowing Water Construction Fund GO Borrowing GO Borrowing 1,100,388 442,050 50,000 50,000 46,730 $ 20,000 $ 15,000 $ 822,000 $ 1,111,875 102,800 $ $ $ 46,730 $ 20,000 $ 15,000 $ 522,550 $ 100,000 $ 10,000 $ $ 1,724,168 $ 1,639,080 $ -42- $ 480,000 $ $ $ 46,730 $ 20,000 $ $ 748,225 150,000 75,000 $ 30,000 $ $ $ $ 2,661,830 $ $ 20,000 $ 46,730 $ 20,000 $ 474,400 250,000 200,000 15,000 1,026,130 $ - $ 3,034,263 106 606,500 75,000 75,000 $ 1,651,350 107 $ 125,000 109 $ 125,000 110 46,730 $ 233,650 111 20,000 $ 100,000 112 - $ 30,000 113 $ $ $ $ 15,000 200,000 70,000 1,745,175 114 100,000 115 10,000 116 400,000 117 $ 75,000 118 $ 230,000 119 $ 30,000 120 $ 200,000 121 $ 70,000 122 1,108,230 $ 8,159,438 1 X'a/erX2ar/menf )bitm5w Yyfthr rtwidani.mietwvaier (2i»foi 2,500 2,000 1,500 1,000 - 500 FY'08 FY'09 FY'10 FY'11 FY'12 FY'13 FY'14 o 40% —V 30% 30.89% nierEarr FY'08 FY'09 FYFY'11 FY'12 FY'13 FY'14 7bkinfer Metered Water 75.1490 Ofilvidereinfer 7acforrConf4aftnyfo %kifrZ'acr Water Loss —7186% Fire Fighting 12.50% Flushin€ 12.50% r" L Main Breaks 25.00% Plant Meter 8.33% Distribution Meters 8.33% Water Leaks 33.33% 350 300 250 200 150 100 50 0 &t*e */,s FY'05 FY' 06 FY'07 FY'08 FY'09 FY'10 FY'11 FY'12 FY'13 FY'14 2to.);O:res4 140 120 - 100 --V 80 -V 60 40 78 136 20 - 0 `r FY'05 FY'06 FY'07 FY108 FY'09 FY'10 FY'11 FY'12 FY'13 FY'14 70 -V ❑ FY' 10 ❑ FY' 11 60 -7 ❑ FY' 12 ❑ FY' 13 50 -V ❑ FY'14 40 -" 30 20 10 -� 0 -V- Hydrants Replaced Hydrants Installed f 10 Valves Replaced Valves Installed FY'06 FY'07 FY'08 FY'09 FY' 10 FY' 11 FY' 12 FY' 13 FY' 14 Xthr rnafmenfP4nf Xecompiiiimeth Veff Adokfrowee PPf�IPam Xthr r,d»fP4d Xecompiiiimeth A DANGER APP,c.P,,itv PPE R..44.1ir.d Flash Protection latldtnt Entres (ca[ •) Bask fhoteetkn Houudan 1 -i1,H Exceeds %las_ PPF_.irc Rstl' Equmment ttcrisec Equip,uuI % .e C 011 1: Hep I akrrel •111.r.revoremab-I.r►.n aa.aa.a 1.1) 11 Short Protection 290Vdc Shock Hazard %tits coven noosed Ltntutd Aptmoa;h lluundry IS.rlfl Rr lncx<tApproachBoundary 1.0 111 Arc Flash and Shock Hazard Present Appropriate PPE Required .it F1:a.h Pr..ereli..n \Im. PPE All". Elft Rating Inatlent Enerp• 2.12:x1 .'.n Rash Boundary An: ILIA Analysis hole *1 :Inxl}xix Expii Dei un Dote 111 Equipment drlfuxl tar dera Loon a -as ikula!ad Mud .W1ni.um ST..Rr! in equipment set values and PFF. mmircenenni. whams. ComIanc# AWARNING Arc Flash and Shock Hazard Present Appropriate PPE Required Asx- L•lanh ProlecOun �I..wlr l'i' li li.Ni \lin. PPE ATM' I ur Raring 2,54 wa1 an= limited .Ippoxich Boundary 3,5 fl Incident Friars 2.12 cal awl a IS on Restricted Approach Boundary 1.11110 %O Lig Ili un:c Prohihitcd Approach Boundary 0,1 f1 1,1441 Boundary 211 .in 17anh .iltxlytas Date 01.19.2012 SMwit; Hazard F.vrroturc 125 V de Arsalsblx ExptaarMli Dare 1015.2014 Ilt4danng tik.+c Clam 09 Fqugrtrls 11 dr&a l ta.,dear E let(ty Min c.lsv{ued baud on equptimit operated land etmut.u. d in peat MER intr..{Yi.rn amp nin equiprrwnt artlinpaar n stern runEruratia.n ri1I isnali.late ts� calaulasnl r alumand PPI. reyuiremnns M h.:h Huy remelt ill t.u.rS.vts mnd.00n uogViqt��; u�tgaiqijo; /'TdfPW q(i8u5q'4&000, At47d/tattpvii..Z ivi/lL X4/er 067h,627,2 X000mfluIm8th am2v� *fh70f1 ?>,m,�er�rrfru.6iri�uisin EySi�ie,ftdekision ilfetreAkelfriVeeder Jw//*m8Pf R04449 4'rtftGiRad X4/er 067h,627,2 X000mfluIm8th X4/er 067h,627,2 �1��am�,llm�end >te 71#.4i1 Pan6i1�' Prf,qram %W8P r Xecom,,Mmeth &c4o' P,wwn&w Xthr r,d»fP4d 9nitia * WeffAiN,0#,Avee PPffP4P» * 7rhtt .214>nfemarlce Projram * Row YdaI» 7rnimLo2w z», * %kfrp &'rqp 7rn1(CoaInj Projram * J4aam, ��Stil* t&r,4•4 glare.��eteie J,f40/ 067h,627,2 $,j2Z,6r * Reeri,id-rtithamr/Enyineeriny Pyth * A4:469%Recamlarclim/rroJecf *.Phref.?l`ikifl7uerlii� Pvjmm/PJ6' X'O4 Pyct * 5>r 7,-ifiioniPathky Pvj'rm *CffenPvjmm X4/er 067h,627,2 $,j2Z,6r 5/4Jnr fo Ju��orfC7rs�Wili SOUTH TECHNOLOGY PARK Xib, O/Jz»h�2w 9n/fiAfives North Cascade Road Urban Renewal Arra Future Public Im movements IfT1 Gazafe hal X.1$ l(j)d M 11:: QRIIPQI.j' 1110c'110a0'P.'1CGL0'PJ; ww. JS ,b../IL 11C14 1e•:.IPNJ'EIptM1 iwlnD4 4.F: SRMP1:MR TP BOK VMII.s G P 11a[11:0% less $Rd1,11 Vne551:4 I )0%®1 :m[ 11111 •7<.p uaY*UISV DX nP[5izL 522117.5150c5vit LOAM,* t rem :IF 510/5) Lrho Cm- ISOLLp i»NNJ7.:e Nsa ^u.a.JJRnx 11 emILLf.fI.'Mr S .ls LFwdTman GMNii Pamq i MN lil' 1knC 11 bel dm. ve • P •d)R RP 34.• P19..1 !L JIC..sa ai01 :DM mil-I>9.N IP. S5...0u[....1•1141 JYMi0 5 PAWN: s c 1-E lI 1 511111 .IUC.G15050 RNLI 'JIa.V.w1 L-1 (XT les[ Let. 4p M1nYLYM'LR 'JMnmM nP d '•('N n9.133109 $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 afrre,*04414ifieffiet FY12 Actual FY13 Actual FY14 Actual FY15 Budget FY16 Requested Budget Amount Expense Expense Expense $2,400,nnn $2,300,000 — $2,200,000 $2,100,000 $2,000,000 $1,900,000 - $1,800,000 -` $1,700,000 -7 $2,344,930 FY12 Actual Expense FY13 Actual FY14 Actual FY15 Budget Expense Expense FY16 Requested Budget Amount $2,250,000 $2,200,000 $2,150,000 $2,100,000 $2,050,000 $2,000,000 $1,950,000 $1,900,000 $1,850,000 $1,800,000 $1,750,000 Xtp,ieraniseyvkes $2,212,805 y _z i FY12 Actual FY13 Actual FY14 Actual FY15 Budget FY16 Expense Expense Expense Requested Budget Amount $800,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 $0 21Arkoy*Eftipmed $199,503 $785,207 X65,255 $72,103 $62,020 74mionlamfiv FY12 Actual FY13 Actual FY14 Actual FY15 Budget FY16 Expense Expense Expense Requested Budget Amount $1,400,000 $1,200,000 $1,000,000 $800,000 )Z�»/3z'r4& 0u8r18a/ $600,000 =' $400,000 -` ■ $174,844 Z $698,197 $1,326,403 $200,000 $0 -7 FY12 Actual FY13 Actual FY14 Actual Expense Expense Expense FY15 Budget $300,325 FY16 Requested Budget Amount $1,000,000 $900,000 $800,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 $0 ro,aiii,kgcjzw _z FY12 Actual Expense FY13 Actual Expense FY14 Actual FY15 Budget FY16 Requested Budget Amount Expense aliVeroCie $2,500,000 -V $2,000,000 - $1,000,000 $500,000 $0 ./ $2,208,389 $1,348,305 $1,627,792 FY12 Actual FY13 Actual FY14 Actual FY15 Budget FY16 Expense Expense Expense Requested Budget Amount 10) $35 $30 - $25 - $20 - $15 - $10 - niter ab Comflathozr $30.22 $25.48 $25.71 $26.79 $27.18 $28.22 Cedar Des Dubuque Council Ames Iowa City West Des Ankeny Rapids Moines Bluffs Moines — FY' 12 ❑ FY' 13 FY' 15 ❑ FY' 16 Proposed Ckrfom8r.Jmhacf dor V./Z4aft5 fire *if rqm6/ cilfr (Akiyy $32.32J by 9flrqthnaf417% 41#rfifas �dayas 7asrq#!e war h/I�428.47 �r q��irr�ja�6% afatirla rk ',rare/ 10% »*v, wfimracf fI aury# reiiithWterer qn �iGanal$2.44`ier manf!