HomeMy WebLinkAboutAgenda Report - November 15, 1989 (69)TROM`, City Manager
MEETING'DATE: November 15, 1989
JY;;..
,;AGENDA TITLE• Purchase. a Wastewater correction �t yszem rtanagemenz,;;:::.; •�- ;. • "�,�-q:.
...Software
x.
5•'
d•5
RECOMMENDED: ACTION:.. That .the City Council approver the',, purchase::of
Hansen•• Software, Inc., Wastewater Collection System Management:.:.' ....;:k-7.0
.::
;Software.
�%V,
6, 9, ty.,Co appr..,.,i.A. ,.
ACRGROUND INFORMATION: On August...l 198 the ,Ci uncia: ;'� ovAtt".:,�
°' ;a'::R `est"; for::Pro orals (RFP for °.the WA Ate
on; S t
:..
Y,
:':. • ...:Nana einent The program. is.... ��be:;
.. • , ,: ; . �: Sof tware: (WCSM) _
• � ul
• :mu
:Yl,'
,used=for scl% -
trackin and generating work orders. for both';:preventativ
ana�,: •_
} o -scheduled: maintenance work and for.general..,;,.wastewater-.:. system< -
n nw.
z...
ent< The RFP...was for a turnke Sys,
ncludin' .°en
,manager
system was: simyTe :and;;understandableto;'`':=`x
data.,:..,The y s :to: •. be p
a! -users, :as it: is tc be ::used by maintenance<<and° cl'er cal.;;,,,::,. .
_ ....
staff; at the Municipal Service Canter.
w
r.
Four vendors responded. Their proposr.ls.. were generally..,:contplPte: and:.k;
responsive to the oints raised iv. the RFP. The following.is a n }
summa of: the costs:
summary .
Vendor _Software Data Entry* Training TOTAL*
RJN Computer
Services, Inc.
.Wheaton; IL
Hansen Software,
Inc.
Sacramento, CA
CH2M Hill
Emeryville, CA
Public Works
Software, Inc.
Port Hueneme, CA
$ 8,500.00 $'8 010.00 $4,500.00 $211010 00��,
$ 4,200.00
$10,000.00
$11,130.00
$19,550.00
$27,500.00
$25,500.00
$1,050.00
Included
$1,600.00
*Data �;ntry includes an amount for estimated number of existing
reports, as stated in the RFP, at the unit price prcposed.
APPROVED: /_1111 /-) m t FILE NO.
. PEIERSON, City Manager
1089w.13 October 30, 1989
WCouncil Communica`on ��
astewater Collec•u on System Management Soft�.,�re
Page 2
Due to the high cost of the CKtq Hill and Public Works Software, those
packages were reviewed relatively quickly. We noted that the CH2M
Hill software would be custom written for the City's application.
This would be fine if the wastewater staff could concisely and
completely express what was needed, however, staff's feeling has been
that we are better off working with a commercial package that has gone
through this process many times. In addition, future enchancements
would be custom made and therefore relatively costly, whereas
commercial packages are regularly updated, with the cost shared among
many users who purchase the upgrade.
The RJN and Hansen packages were investigated closely and other users
contacted. Staff prefers the Hansen package for the following
reasons=
1) Site License - The Hansen price is Cor the City of Lodi as one
site. We will be able to run copies on other computers, such as
engineering or administration to do analysis and review or for
training purpcses. The RJN proposal is for one computer. •-:A-site
license from RJN for the modules proposed would cost approximately
$3, 000. If this cost were added to provide a equal basis of''"r'
comparison, the cost difference between the two proposals is less than " `.
$1, 000.
2) Proximity of Company - The Hansen company is located in Sacramento',.
meaning on-site help is very close at hand. While RJN, located in
Illinois, is willing to be present at start-up and training time and '•<::
occasionally has a representative in the area, there is no doubt that
eventually on-site help will be more available and less expensive
through Hansen. This is evident in the training prices.
3) User Group - The Hansen package has over 12 users within 100 miles,
while RJN has none. Based on the Department's experience with other
software (mainly the computer-aided drafting system), a local users'
group 1s a tremendous asset. We have found that ideas exchanged at
user group meetings are often more helpful than vendors' instructions.
Also, we can visit other users and learn from their experiences how to
make the most of the software.
4) Future Enhacements/Software Features - RJN is an engineering
company with a number of different packages using different database
systems and/or query languages. The package proposed for Lodi is one
combination of their various systems. Hansen is a software company
with one basic wastewater package that is upgraded periodically, based
upon user requests and other marketing or programming considerations.
(Both companies have software for other applications.) It is staff's
feeling that the Hansen package will have better product support and
enhancements over the long run. This is evident now in the various
1089w. 13 October- 10. ' 98R
- w;'°d.5•Y'�r"t�`.?y�81.�'�k"?�4i±g.'!'t'Z.°iti:'""�h;„�'�;`.l.^'�j`czi �ih�ts.'S'.ri�+n.... ..........A.,r.,_..._.....,. _ ......
.:ew+...�xw.M'ar�F�06..+'89:1Av:'u.'4av�a�ttraxre.•..a.r.:.�.,.....r..r.+a�6+.kv�Y4+... .,.. .., .... ., .._....-. ... -.•...:... . ......:.:....:.r.. .
Y
,ro.y.
:.'
•
1089w.13 October 30, 1989
F&
RESOLUTION NO. 89-163
A RESOLUTIOR OF THE LODI CITY CbLNIL
APPIZMM THE PURCHSE OF WASTEWATER UOLLBC"MO SYSTEM MANAGEMENT
WHEREAS,
on August 16, 19C9, the City Council approved
a Request for
Proposals (RFP) for
the Wastewater Collection System Management Software (WCSM) for
use.at the Municipal
Service Center; and
WHEREAS,
four vendors responded to the RFP as follows:
Vendor
Software Data Entry * Training
TOTAL
RJN Computer
Services; Inc.
Wheaton';' IL
$ 8,500.00 $ 8,010.00 $" 4;500:00
$21,010 OO
Hansen Software,
_
Sacramento, CA
$ 4,200.00 $19,550.00 $ 1,050.00.
$24;800 00
CH2M Hill
Emeryville, CA
$10,000.00 $27,500.00 Included
$37,509.00
PublicWorks
Software; Inc.
Port Hueneme, CA
$11,130.00 $25,500.00 $ 1,600:00
$38,230 00
*Data Entry includes
an amount for estimated number of existing reports, as stated 'in
the RFP, at the unit
price proposed.
WHEREAS,
staff has reviewed and eliminated thea two .highest
proposals,
and has closely investigated
and reviewed the lowest and second lowest
proposals, and
WHEREAS, based
purchase the second lowest
System Management Program;
on that investigation and review recommends that the City
proposal, the Hansen Software, Inc. Wastewater Collection
NOW, THEREFORE, BE IT RESOLVED, that the City Council hereby approves
the purchase of the second lowest proposal, the Hansen Software, Inc. Wastewater
Collection System Management i n the amount o f $24,800.00.
============--=-===-=================================================_== _____============
Dated: November 15, 1989
.' „ . .v;ia+>li5 - p:3Ay'` rr".Cws •w,',:. ""' .. ,. ��na�.-.�.�.i5a4ha,.ww: � ..
:.:.w�.n...•eza,++!:'YF+�';4?sn_4iK. mxs, ma•..�.-.,.......__..._._.,....r.Mxfi-r.>Sti•Y.:. t1^" n••!8. i'ih:.it';.W�ia�r, .. .'::� ... ... :...... ..
.', � • Yt YV, YGt Y■t� VttV V't\GJV ■MVtV•• ••V• Vr MVV •••V r•• rV.•..�••�. ���r..���.. ��:, ',. ..•-, ,-.., ,,. .,
I'YCouncil of the City of Lodi in a regular me ti held November::,-"
I... Wing vote:
rte'
Ayes::Counci.l:Members.-
Hinchma n Olson Pinkerton,Rei.d.'and:';_
_ -
Snider or
-
-'
Noes CouncZl Membe
• rs�
None
.......... ..
Absent: Council Members.
- None
.::...:.':::: '•. .�. tom'... .:
- - '•y:5�5;�"•
...qtr �:....:. ... ............ ...
.... ., .. ..
- _
.•.t ...... .....
. ..
ice M Refmche
F..
l
Cit erk'
89-163
RFS89163/TXTA.02J