City Wide Water Meter Replacement_Project AcceptanceMasterpiece on the Mississippi
TO: The Honorable Mayor and City Council Members
FROM: Michael C. Van Milligen, City Manager
Dubuque
bierd
All-America City
1
2007
SUBJECT: Final Acceptance of the City Wide Water Meter Replacement and
Unmeasured Flow Reducer (UFR) Installation Project. CIP #740 -2052
Estimated Cost $8,676,700, Final Cost $7,324,285, Less American
Recovery and Reinvestment Act (ARRA) $1,000,000 Forgivable Loan,
Final Borrowed Cost $6,324,285
DATE: May 16, 2012
Water Department Manager Bob Green is recommending acceptance of the City Wide
Water Meter Replacement and Unmeasured Flow Reducer (UFR) Installation Project,
as completed by Northern Water Works Supply, in the final contract amount of
$7,324,285.
With the original total projected project cost estimate of $8,676,700 and the final project
cost of $7,324,285, the project was completed at an estimated $1,352,415 or 15.6%
below the projected budgeted amount. Including the unanticipated $1,000,000
forgiveable loan component from Federal Stimulus funds, the project was $2,352,415 or
27.1% under expected City funded costs. The original Northern Waterworks Supply
contract price in providing services for this project was $5,493,293. The final cost for
the original services provided is $5,290,864.67. Change orders increased the final
expense to $6,016,022.79.
At the end of September, 2011, each of the 22,168 water meters in the City of Dubuque
had been replaced with new meters. These new meters feature automated meter
readings (AMR) capabilities, which have eliminated the need to manually read each
meter every month, which will save the city more than $144,000 each year.
The last time these water meters were replaced was in the early 1980s. In 30 years,
not only did the technology change, so did environmental awareness. There needed to
be a greater need to conserve resources such as water and the old meters were
replaced due to their age and inability to accurately measure flows.
The new water meters are equipped with a radio frequency meter interface unit (MIU),
which collects meter usage data and remotely transmits the information to data
collectors. The MIU and water meter work as a unit to detect intermittent leaks,
continuous leaks, reverse flow, and zero usage situations. The system will
automatically transmit meter usage data over radio frequency waves each hour to data
collectors placed in 14 locations throughout the community and with the IBM portal, will
allow customers to see their own meter readings. During the project, the city changed
the measurement of water consumption from cubic feet to gallons to allow customers to
be more aware of how much water they are using.
The new water meters, manufactured in the U.S. by Neptune Technology Group, are
also fitted with the Unmeasured Flow Reducer (UFR), manufactured locally by the A.Y.
McDonald Manufacturing Corporation. The UFR allows measurement of flows below 1/4
gallon per minute — such as leaks and drips — that have been previously immeasurable
by aged meters and customers can easily read the water meter display to see if they
have an intermittent leak. A small water faucet icon displayed continuously on the
meter shows the customer there is a continuous flow of water.
This new system is an example of the City's ongoing sustainability initiative and allows
water customers to identify waste and consider corrective measures which will translate
into "Smarter" water use and increased energy savings. More efficient water use will
also reduce the use of both energy and chemicals in the treating and delivering water.
According to national research, 30 percent of households have water leaks. As part of
this project, the City created a grant program for financial assistance on costs of repairs
of leaks identified through this project. The City will pay 50 percent of the replacement
cost, not to exceed $100, for repairs made to devices inside the home. To date, there
have been 401 homeowners who have filed for assistance in the total amount of
$16,828 being paid back to the customer for repairs completed.
Prior to the beginning of the city wide meter replacement program, volunteers were
solicited for Dubuque's "Smarter" Water Project, as a pilot study of volunteer
households and were provided with advanced water meter technology, or "Smart
Meters ". The twelve month study was part of the City of Dubuque's Smarter City
Partnership with IBM Research. IBM Technology has interfaced with the City's system
to process water consumption data and provide near real time visibility into the overall
city water consumption. The project will help citizens become more aware of their
habits and how they can change them in order to save money as well improve the
environment. A critical objective of the Smarter Sustainable Dubuque Initiative with IBM
is to provide Dubuque citizens with information that will be directly helpful in reducing
their costs and conserving resources.
As part of this project, IBM Research is developing a new service system integration,
data management, and analytic technologies that will create new insights for our
customers which will translate into better water utilization and energy savings.
The vendor, Northern Water Works Supply, Inc., who was selected for this project, hired
twelve local citizens as part of their installation team and used two local major plumbing
2
firms as needed with the project. Those being Jaeger Plumbing and Modern Piping,
Inc., both of Dubuque.
Northern Waterworks subcontracted the sixteen collector antennas that were installed to
RACOM Communications of Dubuque.
Use of the Unmeasured Flow Reducer (UFR) Device with this project has had the
following impact:
• The UFR manufactured by the A.Y. McDonald Company directly supports ten
positions and indirectly supports a team of 200 manufacturing local employees.
• It has assisted consumers in identifying inefficiencies in their water system.
• Local plumbers and others in this field have experience significant increases in
business.
The citizens of Dubuque have been exceptionally cooperative in supporting this project,
which is now complete.
I concur with the recommendation and respectfully request Mayor and City Council
approval.
Michael C. Van Milligen
MCVM:jh
Attachment
cc: Barry Lindahl, City Attorney
Cindy Steinhauser, Assistant City Manager
Bob Green, Water Department Manager
3
Masterpiece on the Mississippi
TO: Michael C. Van Milligen, City Manager
FROM: Bob Green, Water Department Manager
Dubuque
bierd
All-America City
1
2007
SUBJECT: Final Acceptance of the City Wide Water Meter Replacement and
Unmeasured Flow Reducer (UFR) Installation Project.
CIP #740 -2052 Estimated Cost $8,676,700, Final Cost $7,324,285, Less
American Recovery and Reinvestment Act (ARRA) $1,000,000 Forgivable
Loan, Final Borrowed Cost $6,324,285
DATE: April 19, 2012
INTRODUCTION:
The enclosed Resolution and Certificate of Completion are provided for the acceptance
of the replacement of 22,168 city water meters, the installation of 18,053 Unmeasured
Flow Reducers (UFRs) and purchase of the remaining stock material for inventory. The
final cost of the project was $7,324,285.
DISCUSSION:
On December 7, 2009, the city -wide meter change out project was awarded to Northern
Water Works Supply of Blaine, Minnesota. Neptune meters were installed, capable of
radio transmission of data through 14 collector antennas. In addition, Unmeasured
Flow Reducer Devices (UFR) from A.Y. McDonald Corporation of Dubuque, Iowa were
installed where applicable.
The functionality of the UFR device compliments the new metering system by
increasing the ability to detect and measure low -flow usage. This will enable us to more
accurately bill our customers for their actual usage and will assist in identifying
household leaks. This allows our customers to identify waste and consider corrective
measures, which translates into "Smarter" water use and increased energy savings.
The original contract price in providing services for this project was $5,493,293. The
final cost for the original services provided is $5,290,864.67. Change orders increased
the final expense to $6,016,022.79. The difference in cost of $725,158 is as follows:
1
Northern Water Works Expense Summary:
Description
NWWS Contract
NWWS Contract Adj — IBM Pilot
NWWS Contract Adj — Inventory
Purchases
NWWS Contract Adj —
Large Meter Plumbing Modif.
NWWS Final Project Total Costs
Bid Award
$5,493,293
- 0-
137,000
- 0-
The following is a summary of the costs associated with this project:
Postage & Shipping
Printing & Binding
Miscellaneous
Mileage /Local Transp.
Telephone
Tellecommunication CG
Misc. Operating Expenses
Audit Services
Consulting Engineers
Legal Services
Software
Micro - Computer
Northern Water Works
J & R Supply UFR Devices
62030 $ 7,829.74
62090 10,987.05
62240 1,620.07
62340 599.00
62421 4,444.65
62423 305.45
62671 1,164.83
62726 5,100.00
62712 366,273.62
62713 8,538.97
71123 16,582.70
71124 5,600.28
73211 6,016,022.79
73211 870,796.21
$ 7,324,285.90
Final Expense
$5,290,864.67
367,052.17
290,032.63
68,073.32
$6,016,022.79
FINAL BUDGET IMPACT:
The final budget impact cost summary for the City's Water Meter Replacement Project
is as follows:
DESCRIPTION
Construction Contract
*Miscellaneous Services
Contingency
Unmeasured Flow Reducers
Engineering & Inspection
Total
EST. PROJECT COST
$ 5,640,293
-0-
1,098,659
$ 1,500,000
$ 356,019
$ 8,594,971
FINAL COST
$6,016,022.79
74,447.70
-0-
870, 796.21
363, 019.37
$ 7,324,285.90
*Miscellaneous purchases and services provided are identified in the attached Exhibits
I -IV on Page 9 -12.
2
Project Funding — CIP #740 -2052
Estimated Project Cost $ 8,676,700
Final Project Cost 7,324,285
American Recovery Reinvestment Act
(ARRA) Forgivable Loan 1,000,000
Final Borrowed Cost $6,324,285
The project funding summary is as follows:
CIP No. Funding Description
740 -2052 Water Meter Replacement Project
Fund Amount
$ 8,775,709
The original budget for the SRF loan on this project was $8,675,700. The final cost is
$7,324,285 with $1,000,000 as a forgivable loan that was awarded to the city. This
brings the project debt to $6,324,285.
With the original total projected project cost estimate of $8,676,700 and the final project
cost of $7,324,285, the project was completed at an estimated $1,352,415 or 15.6%
below the projected budgeted amount. Including the unanticipated $1,000,000
forgiveable loan component from Federal Stimulus funds, the project was $2,352,415 or
27.1% under expected City funded costs.
CHANGE ORDERS:
The following summary will focus on the justification with other vendors who had
additional costs to this project. They are as follows:
1. HDR Engineering: An increase in the amount of $38,267 was for additional
services requested during the project, which provided information concerning
water conservation techniques. This delayed the project closure date by six
months.
2. Unmeasured Flow Reducer (UFR) No Lead: There were specification changes
to the UFR device unit cost. Reduced lead UFR devices were specified after the
start of the project. This was to comply with new lead rules mandated by the
EPA which will be enforced in 2014. This impacted the project by $43,836. Even
with the increased cost of the reduced lead UFR, the overall cost for the device
and installation, were below the original projected expense. This was the result
of fewer units being installed. The projected number of units was 22,168 and the
total units installed were 18,053. The reduction was due to the devices not being
able to be installed on lines where the water pressure would be below 35 PSI
and where pressure reducing valves were present.
(Note: Current standards for lead is 8.0 %, 2014 new standard 0.25 %)
3
3. Water Conservation Pilot Project: An additional expense of $367,052.17 was
added to the project to accommodate a pilot study as part of the City's
Sustainability Program. In the beginning of the project, 509 Neptune R -900
Hybrid series water meters with Gateway transmitters were installed as part of
the City's Sustainability Initiative Pilot Program in part with IBM. These 509
meters were later replaced with the R -450 meter system.
SMART WATER METER PROJECT:
At the end of September, 2011, each of the 22,168 water meters in the City of Dubuque
had been replaced with new meters. These new meters feature automated meter
readings (AMR) capabilities, which have eliminated the need to manually read each
meter every month, which will save the city more than $144,000 each year.
The last time these water meters were replaced was in the early 1980s. In 30 years,
not only did the technology change, so did our environmental awareness. There
needed to be a greater need to conserve resources such as water and the old meters
were replaced due to their age and inability to accurately measure flows.
The new water meters are equipped with a radio frequency meter interface unit (MIU),
which collects meter usage data and remotely transmits the information to data
collectors. The MIU and water meter work as a unit to detect intermittent leaks,
continuous leaks, reverse flow, and zero usage situations. The system will
automatically transmit meter usage data over radio frequency waves each hour to data
collectors placed in 14 locations throughout the community and with the IBM portal, will
allow customers to see their own meter readings. During the project, the city changed
the measurement of water consumption from cubic feet to gallons to allow customers to
be more aware of how much water they are using.
The new water meters, manufactured in the U.S. by Neptune Technology Group, are
also fitted with the Unmeasured Flow Reducer (UFR), manufactured locally by the A.Y.
McDonald Manufacturing Corporation. The UFR allows measurement of flows below 1/4
gallon per minute — such as leaks and drips — that have been previously immeasurable
by aged meters and customers can easily read the water meter display to see if they
have an intermittent leak. A small water faucet icon displayed continuously on the
meter shows the customer there is a continuous flow of water.
This new system is an example of the City's ongoing sustainability initiative and allows
water customers to identify waste and consider corrective measures which will translate
into "Smarter" water use and increased energy savings. More efficient water use will
also reduce the use of both energy and chemicals in the treating and delivering water.
According to national research, 30 percent of households have water leaks. As part of
this project, through a separate CIP, the City created a grant program for financial
assistance on costs of repairs of leaks identified through this project. The City will pay
50 percent of the replacement cost, not to exceed $100, for repairs made to devices
4
inside the home. To date, there have been 401 homeowners who have filed for
assistance in the total amount of $16,828 being paid back to the customer for repairs
completed.
The project was accomplished with new meters being installed by geographic "zones"
over a 21 month period. Customers received a notification letter when it was time for
them to schedule their installation appointment. The City contracted this project with
Northern Water Works Supply (NWWS) to install the new meters and UFR devices. A
NWWS representative arrived during the scheduled timeframe and with required access
to the water meter inside the home or business. Each installation took approximately an
hour. Water service was interrupted at each location while the water meter was
replaced, but customers were able to use the water as soon as the installation was
completed. All NWWS installers were properly trained and background checks were
conducted. NWWS employees had identification badges, wore identifiable uniforms
and drove properly marked vehicles.
Prior to the beginning of the city wide meter replacement program, volunteers were
solicited for Dubuque's "Smarter" Water Project, as a pilot study of volunteer
households and were provided with advanced (R -900) water meter technology, or
"Smart Meters ". The twelve month study was part of the City of Dubuque's Smarter City
Partnership with IBM Research. IBM Technology has interfaced with the City's system
to process water consumption data and provide near real time visibility into the overall
city water consumption. The project will help citizens become more aware of their
habits and how they can change them in order to save money as well improve the
environment. A critical objective of the Smarter Sustainable Dubuque Initiative with IBM
is to provide Dubuque citizens with information that will be directly helpful in reducing
their costs and conserving resources.
As part of this project, IBM Research is developing a new service system integration,
data management, and analytic technologies that will create new insights for our
customers which will translate into better water utilization and energy savings.
COMMUNITY IMPACT JOBS:
The vendor, Northern Water Works Supply, Inc., who was selected for this project, hired
twelve local citizens as part of their installation team and used two local major plumbing
firms as needed with the project. Those being Jaeger Plumbing and Modern Piping,
Inc., both of Dubuque.
Northern Waterworks subcontracted the sixteen collector antennas that were installed to
RACOM Communications of Dubuque.
During the project and its completion, one employee working for Northern Water Works
(a Dubuque citizen) became a full -time employee with the City of Dubuque Water
Department.
A.Y. MCDONALD MANUFACTURING:
5
Use of the Unmeasured Flow Reducer (UFR) Device with this project has had the
following impact:
• The UFR manufactured by the A.Y. McDonald Company directly supports ten
positions and indirectly supports a team of 200 manufacturing local employees.
• It has assisted consumers in identifying inefficiencies in their water system.
• Local plumbers and others in this field have experience significant increases in
business.
The citizens of Dubuque have been exceptionally cooperative in supporting this project,
which is now complete.
ACTION:
It is with the City's Consultant Engineers and staff's recommendation that the City
Council adopt the attached Resolution and Certificates of Completion (Exhibits V and
VI) in accepting the improvement for the City's Water Meter Change Out Project at the
final cost of $7,324,285.
I have attached for your review a copy of expenses associated to this project (Exhibits I
— IV)
Staff and I are available to discuss and answer any questions you may have.
BG:ve
Attachments
cc: Ken TeKippe, Finance Director
Chris Kohlmann, Information Services Director
Mike Brekke, Water Distribution Supervisor
Jackie Rodriguez, Water Plant Manager
Jenny Larson, Budget Director
File
6
EXHIBIT 1
City of Dubuque
Water Meter Changeout Project
FINAL
CIP# 7402052
# 2119 HDR En- ineering =- :.:.;: :.
ObjectCode
;. : Original PQ.:.
Payments • ::
.: Add'l Services /Products
PO# 49578 - Engineering /Consultant
62712
356,019,00
324 752.30
38,267.07
PO# 53937 - UFR devices
73211
2,169.50
2,169.50
4,663.00
PO# 53939 -UFR devices
73211
1,084.75
1,084.75
PO# 54680 -UFR devices
73211
2,169.50
2,169.50
208,454.25
PO# 55991- Couplings & Gaskets
73211
Total for HDR
$ 324,752.30
$ 38,267.07
#2394 J&R u l Co an
..5 pp.Y .......!:gip. Y.
Object Code :
J
Ori final P® .:.::.
..,.. g .......
:::::.:::::.: Payments ::.:. °:::
... Y
> i.. ; : Additional Products
PO# 53810 - UFR's FY10 partial
73211
654,198.99
654,198.99
73211
PO# 53937 - UFR devices
73211
2,169.50
2,169.50
4,663.00
PO# 53939 -UFR devices
73211
1,084.75
1,084.75
PO# 54680 -UFR devices
73211
2,169.50
2,169.50
208,454.25
PO# 55991- Couplings & Gaskets
73211
1,330.00
1,330.00
2,748.55
PO# 56692 - 5/8 UFR for Meter Change
62712
3,254.25
3,254.25
975.91
PO# 56908 - UFR devices
73211
4,339.00
4,339.00
PO# 57418 - UFR devices
73211
1,084.75
1,084.75
PO# 57680 - UFR devices
73211
2,169.50
2,169.50
PO# 55530 - Meters and Decoders 73211
PQ# 58171- UFR devices 5/8
73211
44,257.80
44,257.80
16,224.00
PO# 58430 - UFR Re- setting
73211
1,421.00
1,421.00
16,224.00
PQ# 58433 - UFR devices
73211
18,527.53
18,527.53
PO# 58502 - UFR devices
73211
3,037.30
3,037.30
PO# 58432 - Meter wire 73211
PO # 65952 - Meter Adapters
73211
965.00
965.00
556.82
PO # 67549 - Lead Free UFR's
73211
150,000.00
140,618.88
615.76
Credit for Defective UFR
73211
36,605.52
(71.05)
PO # 73771 - 3/4" UFR meter setter
73211
675.89
675.89
PO # 62568 - Pit Meters 73211
Credit for UFR's
73211
(10,436.38)
73211
1,593.56
1,593.56
PO # 62160 - Meters
73211
7,634.76
7,634.76
Total for AR Supply
$ 870,796.21
$ -
#8862 Northern Water Works Supply
Object Code
:: >:: `` Ori inai PO
Payments .: Additional Products '.
PO# 53824 - Contract
73211
5,500,000.00
5,290,864.67
PO# 55000 - Meter gallon ecoder
73211
5,434.08
5,434.08
PO# 55001- Equinox -Mr Host software Is
actually part of PO# 56148
73211
4,663.00
4,663.00
PO# 56148 - IBM Pilot Project - see also
PO# 55001
73211
208,454.25
208,454.25
PO# 55002 - Meters & strainers
73211
2,748.55
2,748.55
PO# 54900 - "DUBUQUE" labels
73211
975.91
975.91
Direct Pay - Meter gaskets
73211
-
22.37
PO# 55293 - Flag, ecoder, strainer
73211
1,756.40
1,756.40
PO# 55294 - Meters 73211
628.92
628.92
PO# 55530 - Meters and Decoders 73211
4,203.90
4,203.90
PO# 56901- Connectors /Pig Tail 73211
16,224.00
16,224.00
PO# 57496 - MIU Assemby /Pigtail 73211
16,224.00
16,224.00
PO# 58002 - 3" Meter & Supplies 73211
1,632.43
1,632.43
PO# 58294 - MIU / Register adapter J 73211
325.00
331.00
PO# 58432 - Meter wire 73211
1,500.00
1,539.79
PO # 62846 - 1 1/2" Meters 73211
556.82
556.82
PO # 62843 - B &G Set 73211
615.76
615.76
PO # 62841- Meters 73211
36,605.52
36,605.52
PO # 62605 - Seal Pins & 3/4 Meters 73211
1,867.76
1,867.76
h
PO # 62568 - Pit Meters 73211
1,440.04
1,440.04
PO # 62350 - Meters
73211
1,593.56
1,593.56
PO # 62160 - Meters
73211
7,634.76
7,634.76
PO # 57477 - Handhelds 73211
.............
15,740.00
13,790.00
PO # 61354 - MIU`s 73211
720.00
720.00
PO # 61541 Phase C2 Misc Equip. 73211
326,964.61
117,629.67
PO # 58530 Meter Part & Acc. 73211
2,913.98
2,913.98
PO # 63518 Meters 73211
9,148.54
9,148.54
EXHIBIT 11
PO # 63517 1 1/2" Meters
PO # 63708 - MIU's
PO # 63520 - 2" Meters
PO # 63521 - Strainers
PO # 63522 - 2" Meters
73211 1,113.64
73211 16,224.00
73211 1,097.67
111=M1 924.00
73211 2,195.34
1,113.64
16,224.00
1,097.67
924.00
2,195.34
-PO # 63519 - 2" Meters
73211 1,097.67
1,097.67
PO # 65550 - Pit Miu assy, Register E -Code
73211 2,473.68
2,473.68
{
PO # 65918 - Lead Meter Seal
73211 2,600.00
2,600.00
PO # 66221 - Ancillary Op. Support
73211 10,625.00
9,375.00
PO # 66220 - Large Meter Install Add
73211 9,312.76
9,312.73
PO # 66222 - MIU Labels
73211 1,465.00
1,465.09
PO # 66495 - Fastener Screws
73211 220.00
220.00
PO # 66497 - Misc. Suples
73211 4,166.60
4,166.60
PO # 67462 - MIU's
73211 8,112.00
8,112.00
PO # 67126 - Meters, Strainers
73211 6,447.88
6,447.88
PO # 67127 - Pit Register
73211 600.02
600.02
PO # 67128 - G &N sets, Gaskets
73211 994.00
994.00
PO # 67624 - Cmpd meters, strainers
73211 1,632.43
1,632.43
PO # 67763 - Cmpd meters, strainers
73211 7,331.12
7,331.12
PO # 67764 - MIU's
73211 8,112,00
8,112.00
PO # 67765 - Domes, B &N Sets
73211 223.08
223.08
PO # 67766 - Registers
73211 1,000.04
1,000.04
PO # 67767 - Domes, B &N Sets
73211 1,112.90
1,112.90
PO # 67950 - Registers
73211 900.09
900.09
.P0 # 68074 - Large Meters
73211 17,755.52
17,755.52
MMIIIIIIIIIIIIMIM
PO # 68125 - Registers
73211 2,500.00
2,500.00
PO # 68475 - Tricon E3 Reg
1,000.04
1,000.04
PO # 68891 - Large Meter Add -On
16,468.70
16,468.70
PO # 69464 - B &N Set, gaskets, brz mtr flg
73211 838.98
838.98
PO # 70022 - Brz mtr flg fipt, B &N
73211 966.42
966.42
PO # 70249 - City stock MIU's, meters, strai
73211 10,398.54
10,398.54
PO # 70231- Large meter add -ons
73211 11,595.00
11,595.23
PO # 70953 - Couplings
73211 709.50
709.50
PO # 70995 - Misc Supplies
73211 140.02
140.02
PO # 70022 - Brz mtr flg fipt, B &N -CR
IIMEREI (966.42)
(966.42)
PO # 71724 - Spud Plugs
73211 313.00
313.00
PO # 72509 - MIU Labels
73211 1,250.00
1,250.00
PO # 73376 - MIU's
2,400.00
2,400.00
PO # 73495 - Large Meters
11,230.00
11,230.98
PO # 73768 - Registers, meters
545.01
545.01
PO # 73769 - 5/8 meters
73211 708.78
708.78
•
PO # 73970 - Eclipse 100.008 Scothclok
.1=11W‘
73211 88.68
88.68
PO # 74349 - 3 RR Full Face FIg gasket
73211 2.92
2.92
PO # 74349 - 2-+3 304 SS FLG B &N SET
73211 101.26
101.26
PO # 74531 - 3 Hydrant Meter w /NST CLP
73211 4,692.00
4,692.00
PO # 74451 - Register 3 F/H TUR D/R
MBE 420.00
...................... ........ ...............................
420.00
PO # 74836 - R450 Wall MIU Hi Power
MEM 1,071.60
1,071.60
PO # 74760 - Stock
73211 7,386.71
7,386.71
PO # 75249 - Misc. Supplies
73211 5,164.71
5,164.71
PO # 75251 - Supplies
73211 1,045.52
1,045.52
PO # 77351 - Supplies
73211
471.40
471.40
{
PO # 77389 - Large Meter Install
982.16
982.16
IIIMBEI
PO # 78643 Stock Acquisition
73211
56,981.62
56,981.62
PO # 78560 IBM Pilot
73211
20,081.25
20,081.25
PO # 78561 Large Meter Install
73211
728.00
728.00
Total for NWWS
$ 6,016,022.79
IIIIIIIIIIIII
EXHIBIT 111
Other ::. :.::
.: Object Code
Description Payments
Check Date
City of Dubuque / Five Flags
62240
10/27/09 beverages 96.76
11/10/09
City of Dubuque / Five Flags
62240
11/17 -18/09 beverages 81.42
12/08/09
Fedex
62030
Ship loan application 24.52:
01/05/10
City of Dubuque / Five Flags
62240
1/5 -6/10 beverages 103.85
01/19/10
First Supply PO #54663
73211
Fittings 813.67
01/26/10
O'Toole Office Supply
62240
Folders 60.00
02/16/10
O'Toole Office Supply
62240
Folders 75.00
02/16/10
Outgoing Postage (City Hall Meter)
62030
Postage - special mailing 2,071.17 '
03/02/10
Welu Printing
62090
#10 Envelopes - NWWS
use
1,830.00
101.67
03/02/10
Welu Printing
62090
UB Window Envelopes -
special mailing
345.00
• 04/07/10
03/02/10
Scott Printing
62090
Flyers - special mailing
1,029.10
Dell Computer
71124
Mississippi Valley Sales
62090
Computer
Toner cartridge
replacement - due to
special mailings
1,880.96
169.00
Electronic Communication Systems
71124 LDC projector & case
778.41
03/16/10
Midwest Printing
62090 Brochures
656.00
03/24/10
Hotel Julien
62240 3/10/10 room, breakfast
288.00
03/24/10
O'Toole Office Supply
62240
Clipboards
29.85:
03/24/10
AT &T Mobility
62423
Data Lines
22.10
03/24/10
Dell Computer
Laptop Water Distribut
2,097.91
03/24/10
Dubuque Area Chamber of Commerce
62240 Caramels • participants
35.10
03/31/10
Ella M. La hey
62240 Stop watches
90.93
03/31/10
Outgoing Postage (City Hall Meter)
62030 Postage
5,734.05
04/07/10
City of Dubuque - Stores
62090 Copy Paper
101.67
04/07/10
Kenneth J. TeKippe
62340
Mileage
197.00
• 04/07/10
Ahlers & Cooney
62713 Legal services
8,538.97:
04/07/10
Sungard Pentamation - PO# 55406
71123 Meter import project
5,250.00 :
04/07/10
Sungard Pentamation - PO# 55560
71123 Equinox Meter Reading
4,500.00.
04/07/10
Sungard Pentamation - PO# 55406
71123 Meter import project
(5,250.00)
04/07/10
Sungard Pentamation - PO# 55560
71123 Equinox Meter Reading
(4,500.00)
04/07/10
Scott Printing
62090 Disconnect door hangars
133.00 i
04/21/10
AT &T Mobility
62421 Data Lines
283.35
04/21/10
Sungard Pentamation - PO# 55406
O'Toole Office Supply
Dora M. Serna
71123
71124
62240
Scott Printing
AT &T Mobility
Meter import project
Screen & Laser Pointer
Translate documents
62090 Leak Repair Grant Policy
1,312.00
05/12/10
843.00
05/12/10
124,95
05/19/10
288.86
05/26/10
Sungard Pentamation - PO# 55560
Journal Entry to City of Dubuque
Holy Family Catholic
Dubuque Community School Dist
J Dubuque County Hospital Board
1St Joseph Key West Parish
IAT &T Mobility
62421 Data Lines
71123
62340
62240
62240
62240
62240
62423
Balance of Meter Import
283.35
3,938.00
05/26/10
05/26/10
4 parking meter cards
License Agreements
License Agreements
License Agreements
License Agreements
140.00
41.00
82.00
41.00
Data Lines
41.00
283.35
06/10/10
06/15/10
06/15/10
06/15/10
06/15/10
06/22/10
Scott Printing
62090 739.20
06/25/10
i AT &T Corporation
62421 Data Lines 283.35
07/28/10
AT &T Mobility
62421 Data Lines
283.35
08/25/10
Midwest Printing (8985) -PO 4 62847
62090 Printing
1,316.27
08/31/10
AT &T Mobility
62421 Data Lines
283.35
09/28/10
City Treasurer /PC
62340 Meter Money
57.00
10/12/2010
AT &T Mobility
62421 Data Lines 276.35
10/26/2010:
Menards - PO# 64105
62671 Misc. Supplies 105.97
10/12/2010!
Sisters
62240 License Agreements 21.00
11/23/2010
AT &T Mobility
62421 Data Lines 276.35
11/23/2010
Parking
62340 Parking Meter Cards 105.00
10/29/2010
City Treasurer /PC
62340 Parking Meter Money 50.00
11/24/2010
Lowes
62671 Supplies 363.49
11/30/2010
Midwest Printing - po # 65362
62090 Printing of water mtr reps. f
1,316.27
12/7/2010
Welu Printing
62090 #10 Envelopes - NWWS use
947.85
12/14/2010
Parking
62340 Refill Cards
50.00
12/9/201011
EXHIBIT IV
AT &T Mobility
62421
Data Lines
276.55
12/21/2010:
Miller Electric - PO 00065919
73211
BJ 1 1/2 to 1 ground clamp
422.54
12/14/2010
Comm.Engineering Co - PO 61029
73211
Magnum Edge Switch Jump
5,870.50
12/21/2011.
Comm.Engineering Co - PO 665297
73211
Table Mound Collector
998.38
1/4/2011
Midwest Printing - po # 67555
62090
Printing of water mtr repl.
1,316.27
2/22/2011
_ UPS - po # 66950
62240
Shipping of Sim Card
10.05
2/1/2011
AT &T Mobility
62421
Data Lines
276.75
2/1/2011
Lowes
62671
Misc. Supplies
133.22
2/1/2011
Sungard Public Sector
71123
Meter reading interface
3,200.00
2/8/2011
Comm. Engineering Co - PO 67435
73211
Table Mound Collector
Data Lines
1,275.00
2/15/2011
AT &T Mobility
276.55
3/1/2011
AT &T Mobility
62421
Data Lines
276.55
3/22/2011
Lowes
62671
Misc. Supplies
183.91
3/8/2011
Eide Bailley - JE 1108 -71
AT &T Mobility
62726
62421
Audit
2,600.00
3/3/2011
Data Lines
276.35
4/19/2011
Lowes
62671
Misc. Supplies
133.02
4/5/2011
Scott Printing PO# 69081
Comm. Co • 67327
62671
71123
Notice of Disc. Door Hange
139.00
4/18/2011.
witch for Marian Hall
Data Lines
1,380.20
273.10
4/19/2011
5/24/2011;
AT&T
�
• - • • 70860
62090
Brochures
798.56
6/21/2011
AT&T Mobility
Data Lines
273.10
6/21/2011;
True Value
62671
1" Copper Adapter
22.47
- 6/30/2011
Mobility
6242Data
Lines
273.10
7/26/2011:
AT&T • • • • 73528
62421
Data Lines
273.15
8/30/2011
First . • • • 71598
73211
Supplies
1,089.59
8/9/2011
Racom ; • 73529
73211
Col lector Removal
1,056.00
8/23/2011
First . • • • 73770
62240
Supplies
223.18
8/30/2011
Miller
Butt Splices
19.26
9/7/2011`
KW - Value
62240
Copper Tees &Couplings
59.41
9/7/2011
Sungard Public Sector • • 67104
Meter read import
1,125.00
9/13/2011
Miller -
Welter • .: - Supplies
Butt Splices
96.31
83.75
1,582.50
2,075.00
10/11/2011
10/11/2011
A/25/2011
10/25/2011.
62671
71123
Totes for Meter Program
Maintenance
Sungard Public Sector - po 76186
Sungard • - • po 67104
71123
Meter Reading Software
Comm. - Co •
-
71123
IT Service
1,970.00
10/25/2011
Jaeger Plumbing • • 80428
Eide Bailley - JE 1209 -42
73211
Plumbing Repairs
149.11
2,500.00
2/22/2012.
3/12/2012
62726
Audit
Total for Other
$ 74,447.53
Total Project Costs To Date
Excludes $50,000 for meter testing in FY'09
Excludes 1% origination fee of $76,757
Summary by Account It
Postage & Shipping 62030 7,829.74
Printing & Binding 62090 10,987.05
Miscellaneous 62240 1,620.07
Mileage /Local Trans. 62340 599.00
Telephone 62421 4,444.65
Tellecornmunication CG 62423 305.45
Misc. Operating Supplies 62671 1,164.83
Audit Services 62726 5,100.00
Consulting Engineers 62712. 366,273.62
Legal Services 62713 8,538.97
Software 71123 16,582.70
Micro - Computer 71124 5,600.28
Const. Contr -Not Bldg 73211 6,895,239.54
$ 7,324,285.90
7,324,285.90
EXHIBIT V
Masterpiece the Mississippi.
TO: Bob Green, Water Department Manager
� //
FFROM: KenTeN]ppe�Finono�Dineotor /(10,, �/
SUBJECT: City Wide Water Meter Replacement P 'ect
DATE: April 18, 2012
On behalf of Finance and Utility Billing 1 would like to provide the following information
relative to the City Wide Water Meter Replacement Project:
Dubuque
2007
O Transition to eliminate outside meter reading contract went well (saved City
$144,000 annually)
O New meter reading software is working great
O Reports relative to high consurnption helpful to staif
O Minimal misreads for customers, increased bill accuracy and limited estimated
bilis to customers
O Overall improved customer service
O Coordinated payments for leases to a number of entities for placement of
collectors on their properties
O Recap of expenses incurred for the project provided regularly to HDR and others
as needed, very few expenses not reimbursable with State Revolving Loan
Funds
O Regu|ardravvdow/no with Iowa Finance Authority (IFA) for State Revolving Loan
Funds (SRF) 'ivent wet!, IFA withholding $5,000 until project ject is completely
finalized
The m jor p 'eotresultedinsignKicantcoord/noLkonand000peratonbetweenthe
Water, Information Services and Finance/Utility Billing areas. The City should be in a
good position for the next 2030 years relative to meters. It is always good when p 'eot
costs come in fess than initial budget. I concur with the City accepting completion of the
project.
if you have any questions on this information or would like additional data please feel
free to contact me.
KT/em|
cc: Rose Hoerner, Utility Billing Supervisor
EXHIBIT VI
T
iaiMVKVtrzfttgM*yg,-**,..--,
April 24, 2012
City of Dubuque
50 West 13th Street
Dubuque, -Iowa 52001
Attn: Mr. Bob Green and Mr. Ken Tekippe
Re: City of Dubuque Water Meter Replacement Program
Project Closeout
Dear Mr. Green and Mr. Tekippe:
This letter is to inform you that Ferguson / Northern Water Works Supply has
completed all bid-item work on the above referenced project as is considered
substantially complete as of April 24, 2012.
To the best of our knowledge, information, and belief, and on the basis of our
observations and inspections, the Work for the above referenced project has been
completed in accordance with the terms and conditions of the Contract
Documents, State Revolving Loan Fund (SRF), and American Recovery and
Reinvestment Act (ARRA). The project was completed within budget with a
final project cost of approximately $7,317,000 compared to the original budgeted
estimate of $8,610,000. TM wishes to acknowledge the contributions of the
City of Dubuque staff for their valuable assistance and participation from the
initial planning through the completion of the project. We look forward to
opportunities to work together in the future.
Very truly yours,
HDR ENGINEERING, INC.
Patrick Brown, PE
Project Engineer
VIDE Engineering, inc.
Thomas Jakubowski
Senior Consultant
300 East Locust Street
Suite it 210
Des Moines, Iowa 50309-1823
Phone (515) 280-4940
Fax (515) 280-4955
www.hdrinc,com
RESOLUTION NO. 152 -12
ACCEPTING THE CITY OF DUBUQUE, IOWA • WATER METER
REPLACEMENT PROJECT
Whereas, the Public Improvement Contract for the City Water Meter
Replacement Project (the Project) has been completed and HDR Engineering of
Omaha, NE, the City's Consulting Engineering Firm, has examined the work and filed a
certificate stating that the Project has been completed according to the terms of the
Public Improvement Contract and has recommended that the Project be accepted; and
NOW THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY
OF DUBUQUE, IOWA:
Section 1. The recommendation of the City's Engineering Consultants is
approved and the Project is hereby accepted.
Passed, approved and adopted this 4th day of June , 2012.
Attest:
Kevin irnstahl, City Clerk
c�-
Roy D. Buol, Mayor