CR 97-25 Award Bid SCADA Purchase
February 14, 1997
\ 1 Y 0
m
., "
o P K \ t'-
Council Report: 97-25
AWARD OF BID
THE PURCHASE OF A SUPERVISOR
CONTROL AND DATA AQUISSITION
(SCADA) SYSTEM
PROJECT #95-14
Proposed Action.
Staff recommends adoption of the following motion: "Move that council adopt resolution 96- I 64.
resolution for award of bid. the purchase of a Supervisor Control and Data Acquisition (SCADA)
System. "
Overview.
Bids were opened on February 13, 1997 for the above referenced project.
Three bids were received and are tabulated below. The low bidder was Twin City Electric Company,
Bloomington, Mn.
BIDDER
TOTAL BID
Twin City Electric Company
Instrument Control Systems, Inc.
Dynamic Systems, Inc.
$367,650
393,000
442, 750
Engineer's Estimate
$362,000
The city's engineer, RCM Inc. has checked the bids and has reviewed the quaIifications of the low bidder,
Twin City Electric. Their review of the contractors qualifications and past experience meets their criteria,
and they are recommending that the city award the contract to Twin City Electric.
PrimarY Issues to Consider
o Is the project within budget?
o How will the project be funded?
o What is the construction schedule?
Supporting Information
o Analysis of issues
o Consult Recommendations
o Bid form
o Resolution 96-164
Council Report: 97-25
Page 2
Analysis ofIssues
o Is the project within budget?
The budgeted amount that is in the current budget is $56,500 from the water fund and $60,000 from the
sewer fund. This amount was to get the project started and the rest of the funds were spread out
through the rest of the future upgrades to the utility facilities. The control system is in need of
replacement now because of its age, and the unavailability of replacement parts.
o How will the project be funded?
The project will be funded from water and sewer revenues as identified in the 1997- 2001 CWo
o What is the tentative project Schedule?
Council award construction February 18,1997.
Notice of award February 20, 1997
Receive agreements before March 3 1997
Notice to proceed before March 24, 1997
Substantial completion (operational system) 220 days after NTP October 30, 1997 approx.
Final completion (clean-up, Etc.) 245 days after NTP Nov. 24, 1997 approx.
.
...." .&."lI:f~'
1.Clll
rieke
carroll
muller
associates, inc.
engineers
arChnects
land surveyors
equal opportunity
employer
.........v':t
UU.L4 ~vv QQ.L't
I'v.lU 4~~V"~4~.c~
Ie:lUU"::;/UU.J
February 14, 1997
Honorable Mayor and City Council
City of Hopkins
1010 1st Street
Hopkins, MN 55343-7:i73
RE: Bids for Supet"\lising Control and Data Acquisition (SCADA) System
Dear Honorable Mayor and City Council:
We have reviewed the b:id forms received on February 13, 1997 for the Supervisory Control
and Data Acquisition (SCADA) System. A total of three bids were received and reviewed.
The attached tabulation shows the various bidders and their respective bid amounts.
The three bids ranged from $367,650 to $442,750, with the lowest bid from Twin City
Electric Company. Twin City's bid of $367,650 is within two percent of the engineer's
estimate of $362,000. Twin City's bid is based on instrumentation and controls as
manufactured by Automatic Systems Company, which is one of the named manufacturers
in the specification.
Based upon the above, it is our recommendation that the City of Hopkins make a contract
award for the SCADA System to Twin City Electric Company for the lump sum price of
three hundred sixty-seven thousand, six hundred fifty and no/I 00 dollars ($367,650.00) as
the apparent low bidder.
Upon your award, we will forward to you copies of the Notice of Award and Agreement for
your review and approval. The bid also includes adjustments to the bid for replacing the
existing two wood pole lllld two galvanized rigid steel conduit antennas with aluminum pole
antennas. We recommend that the City review the costs and any lllljustments will be made
after award of contract.
We continue to look f(.rward to working with you on the successful completion of this
project. [fyou have any questions, please contact me.
Sincerely,
RIEKE CARROLL MlILLER ASSOCIATES, INC.
~1J---
Dale A. Falen, P.E.
Project Manager
DAFibam
10901 red circle drive Attachment
box 130
minnetonka, minnesota 55343-0130
(612) 935-6901
fax (612) 935-8814
V...' "'':1:1;;1'
~
-
~
-<
s
~
~
~
S
0..
8
M
m~
-;;.....
.... .
CI:l"'-
-0
-<d 1:''';
Sl .. VI
,,8:2
.... .0 .....
CI:l <U .
I::.. 0
Z
~ .. 'd
.rf.~
~ [~
c.O~
o:EU
=l'Q1O':
e:;
u
a
~
..\.J..V't
... VJ.4 ~~.., QQ"\''t
~vJI1 i\.~~VV.Li\..L.C~
I&IVV.,JI UU,J
1:; 8
- ~
to 8
j <U
- ~ ~
CI:l CI:l
0 '" .....
i .:;:
'"
8
~ B
:::l
<(
'tl 0 0 8
.. VI VI
= ... \0 o.
.. ! ,..: '"
~ '-0 0\
'" '"
l'Q "" ~
l;-
's l#< ~ l#<
al
CI:l VI VI VI
'tl
..
l'Q
~
~ if
'"
8' ~
~ '"
0 ~
U
.. .~ g
.s ur
u e w
~
os '" '" "
... ~ '" 0
g P:l U
CI:l .~ ~
U '" c
.~ u e
.S 8
c ~ ]
>.
0
; ;..if'::'"
"':~:;q.,1 '- :'.'~"
-...- -- -,.~",
"-'~,- .~.~~'-\~ '. :'-"<;:.,""- . .:..
October: ~~';". '~996
.",f.
, Y
\
o
,,'
...'- .' "-" ....
.~:: ;:" ;'~;J:';~~':._~t[~:::~:: ~r'"
, '-" .
..
o P K \ ~
council Report: 96-~64
APPROVAL OF PLANS FROM RCM, INC.
AND ORDER BIDS FOR THE PURCHASE OF A
SUPERVISOR CONTROL AND DATA ACQUISITION (SCADA)
PROJECT NO. '
,
FOLDER NO.
INITIAlS
SYSTEM '
95 -If
...J77
Proposed Action~
Staff reco~ends adoption of the following motion: "Move that the
Council approve plans and order bids as thev relate to the purchase
and construction of a Supervisor Control and Data Acauisition Svstem
(SCADAl."
Overview. -
A SCADA system is a computer-based monitoring and control system.
This project will upgrade our existing water and sewer control system.
The current system relies on phone company lines for transmission of
control data from the city Public Works Facility to the .various sites
in the city that it controls.' The' phone lines have "in the past been
unreliable and are very costly to rent. The current controls were
installed in ~977-~978 and repairs to the system' are very, difficult
due to the unavailability of parts. ' ", ' '"
<"
The new system will use '~omputergenerated command;; transmitted over a
new radio system which should, be more reliable and easier "to ',service
than ,the present system. 'With this purchase the city will\l:iring our
control system up to speed with the new technology of the futw::e;,'
I ..~"'.
:", .~
" -,
"
primarv Issues to Consider
."' '...
o Summary of Proposal
o Project Funding and 'Schedule
Supportinq Information
o
o
Analysis 'of Issues
Kaeding'and Associates letter
".'
~_ e._._ .
, ..
"''S'
util ty Superintendent
" ". -'-~.
~ ~.'"
, ".
"
" "
"
. " ~. "
" ~ "
c'
,,'
, ~,' J~~/~:'
,;;:. ~'~~TJy..
:):;.;;,:~tff~ _
.0
'-" .
",-,:,
;:r; -
.-"...
".:'-
~i,
" :';'"
" ,!
-.~-,,~~~).~
. "-':-' .
-' '.'.
, .:;....'
council Report: 96-164
Page 2
,,;;'u _,
- .'
".
,: "
Analvsis'of Issues
'. ,,' -
,;'C~<" .
.Summi3..ry of Proposal
Kaeding and Associates, Inc. letter outlines the scope of what
.'. ...the"'project involves and its estimated costs. Those costs are
estimated at approximately $400,000.
,- ,~>,,)":, :<.~'
..',h.
'." -
.'
The project budget in 1994 was $141,500. The original scope of
the project has remained the same. The difference is that with a -
completed set of plans we were able to submit them to the _
contractors that install these systems and get a more accurate
cost.
"
" .'
: "','
The cost for the progranuning and the software that supports the '. .' ..
system have increased 9ramatically in the last two yea~s which
are reflected in some of the increased costs. Also included are.
higher installation prices that we didn't factor in to the '" .....'
original estimated costs.
Benefits and savings from this project are as follows:.
o Increased reliability of the radio communication, and the
cost savings from not having to pay for the expensive phone.
lines .' ,', '.:
o The ability to use the ground storage portion ofthe'w~b~r~
town at the Well #1 site on a daily basis. .: ,.. .
o The cost savings of using the new efficient .pumps..at. Well '#1.
to lower ourNSP costs.
o The ability'to monitor the system on a lap top computer from__{.
the 'operators home, and be able .to' correct some of the '.: ~< .~.: '" '
. __ problems without having to come in
o The ability to put more of our facilities on the'cost saving
"time of day~' program that NSP offers.
o
Project Funding a~d Schedule
The project is waiting to receive the radio frequency assignment
and as soon as that arrives the project will be bid. The
projected time table is to bid this project this year and install
it in the first part of 1997. The funding of this project is as
follows: . .
, WATER FUND:
SEWER FUND:
$220,000
$180,000
The project is included in the current CIP as a 1996/1997.
project.
'"
"
,to ,t,'
-.-,.,,\.'
'''';. .
..!- '
',. "
" , :~, '",
.r~~, .
,; ;'
\f~ ':"~. ,:,'
': .
.\ :_>;,';'~~:"~
. " ,- ',<.'.'.
'. ;./;\;~~~~i~~~~~tL
. ..
. ".; -' -~:
'p"
- .~.:,
"'".
".,A
Kaeding and Associates, Inc.
7300 France Avenue South
Suite 330
Minneapolis, Minnesota 55435
(612) 831-0317
(612) 831-2179 Fax
September 30, 1996
City of Hopkins
Attn: Mr. Steve Stadler
160 I Second Street South
Hopkins, Minnesota 55343
Re: Hopkins, Minnesota
Water I Wastewater SCAlJA System
Dear Mr. Stadler:
This letter serves as an overview of the water SCADA system designed for the City, and answers several
questions presented at our recent meeting. This design effort supports RCM's continuing work in the City.
The term "SCADA" stands for system control and data acquisition. The term accurately describes what the '
system will do. The system will use a unit at City Hall as the master, but the two workstations that serve as
the ~.~window" into the system are located at the Public Works building. The following elements are included
in the system:
Wastewater Lift Station Monitorin!!:
Th'e system will monitor the five existing lift stations for high wetwelllevel, low temperature, and
intrusion, and will monitor the pumps to accumulate pump running time. Pump running time is a key
element. Pump wear or a plugged pump will significantly increase the operating time. Running time
will be conveyed back to the Public Works building where it can be monitored. Panels will also be
included for lift stations #5 and #6. When these stations are rehabilitated, the panels can be insta'lIed.
The system will also monitor for signal loss, which will indicate a power or equipment failure. Because
radio signal strength from stations #1 and #2 is marginal, telephone telemetry is a candidate at these
stations.
Blake Tower I Moline Plant:
Telemetry panels will be installed at Blake Tower and the Moline Plant. The level in the Blake Tower
will be telemetered to the master and on to the Public Works building. Operation of the Moline Plant
and standpipe can be monitored and controlled from the workstations. Low temperature, flooding and
intrusion alarms are being added at these locations.
Water Plant #4:
Water Plant #4 will have a new control system. Backwashing of the filters at this plant has never been
automated, but wiIJ be. The existing control system for the wells and high service pumps is old. The
reliability of the system is decreasing and the manufacturer no longer supports the equipment. This
entire control system will be replaced. As a result, well pump control, "chemical control, chlorine
.... ~
City of Hopkins
Attn: Mr. Steve Stadler
September 30, 1996
Page 2
addition, high service pump control, and backwash control will be automated. All of these parameters
and processes can be monitored and controlled from the workstations. Low temperature, intrusion,
flooding, and valve misoperation are being monitored. These functions have not been controlled in the
past. To control cost, the existing valves, actuators, and feedback transmitters are being retained. It is
believed that all' are operational. However, when the valves are taken out of service and examined
during construction, some of these components may need to be replaced. Similarly, high service pump
controlled check valves, solenoid valves, and related components are being reused. Most pressure
transmitters are being replaced and new current-to-pneumatic converters are being installed.
Workstations:
The project includes two personal computer based workstations at the Public Works building with
printers. The printers include two alann printers and one report printer. In addition, one laptop
computer is being furnished. This laptop will allow an on-call operator to access the system from home.
In the event of an alarm, the instrumentation system will notifY the operator via a City procured paging
system. When the operator receives the page, he/she can access the system via the laptop using a
telephone circuit. The operator can then detennine where the problem is and its nature. Appropriate
action can then be initiated.
The system is estimated to cost approximately $400,000. This is an engineering estimate that will depend
on several variables including the construction schedule, how busy the potential bidders are, how busy the
equ,ipment suppliers are, and other factors. In order to keep the project "moving", but not establish such an
aggressive schedule that the cost will suffer, an eight month construction schedule is recommended.
We, along with our associates at RCM, appreciate your patience and look forward to implementing the
bidding and construction of this significant improvement to the City's infrastructure.
We trust this answers your questions. If you have additional questions, please contact me, Mr. Folen, or Mr.
Roskopf at your convenience.
a . aeding.
aeding and Associates, Inc.
PFK:mj
cc:
Mr. Dale Folen I Rieke Carroll Muller Associates, Inc.
Mr. Mike Lauseng I City of Hopkins
Mr. Robert Roskopf I Rieke Carroll Muller Associates, Inc.
.:" .:
,
Kaeding and Associates, Inc.
7300 France Avenue South
Suite 330
Minneapolis, Minnesota 55435
(612) 831-0317
(612) 831-2179 Fax
October 10, 1996
City of Hopkins
Attn: Mr. Mike Lauseng
1010 South First Street
Hopkins, Minnesota 55343
Re: Hopkins, Minnesota
SCADA System
Dear Mr. Lauseng:
In response to your telephone conversation, the cost estimate presented in our letter to Mr. Stadler
dated September 30 was developed from three sources. Two of the sources were instrumentation
system integrators to whom we forwarded progress drawings and asked for estimated costs ofthe
system. One integrator reported a cost of approximately $405,000, installed, and the second
integrator estimated the equipment cost would be approximately $285,000, excluding installation.
We also estimated the cost and determined the following:
Five lift station panels $ 50,000
Two lift station panels - not installed 14,000
Blake remote 12,000
Well remotes 23,000
Public Works remote plus two workstations, software 40,000
City Hall master 23,000
Moline remote 15,000
Water plant remote 75,000
Water plant installation 50,000
Fiber cable 10,000
Software, startup, miscellaneous services 50,000
I Total
$
362,000
.
,
City of Hopkins
Attn: Mr. Mike Lauseng
October 10, 1996
Page 2
This estimate is an earlier "reality check" estimate that we performed when we were at about the
85% point in the design. The estimates that we received were in the same general area.
These figures should be used with some caution. There are many variables that can affect bidding,
including some that we have little control over. They include how busy the equipment vendors and
contractors are, or expect to be. However, within the limitations of any estimate, we think these
figures are realistic.
If you need additional information, please contact me at your convenience.
F. Kaeoing
Kaeding and Associates, Inc.
PFK:mj
cc: Mr. Dale Fo1en / Rieke Carroll Muller Associates, Inc.