HomeMy WebLinkAbout1979-11-06; City Council; 6047; Consulting Firm Data Processing System........
I I
am.a-Mi. m:r..L No A .. (fJ...o J./ 7 _
cr•.r ~· 01-:-r:_r. RT,:.:. F,i\D
'-........ ~ .. -.. -... ___ ----
DATE:: November· 6, 1,_9_7;..;9;...... ______________ _
Finance
. ,,,__
Selection of i consulting firm to aid in the improvement of the
City's Data _Processing System.
-------------------· ---------------------------
On June 19, 1979 the City Coun-cil reviewed the Citizen's Committee
reroi:t on the City Datj,a Processing System. A:!:ter thi.s review~ the
council instrqcted the Manager to contact various COl).SUltants ·
w~o could aia in the review of city data processing needs and selection
of a suitable data processing equipment. During October a request ·
for proposal went out to.six consulting firms, four of which responde~.
Of the £our, tile staff is .recommending the City Council sel€ct Price
Waterhouse ~s thd· firm best suited to perform the necessary studies.
Exhibits
Memo from Finance Director to the Cit'y ilanager date.cl lv-29:-79
"Request for proposal for consulting Serv,ices. .
Prouos~ls from Price Waterhouse and Intregra%ed Research and
Information Systems. . .
Letter from Planning Research Corp and Ralph Andersen and Ass~ciates
Resolution No 0::9'73 ·
Recommendation
Adopt Res·olution No .~3..authori zing the Mayor on behalf of the City
to execute,. contract with Price Waterhduse for consulting services
no-t to .exceed $11,000.00 •.
.
Co·uncil Action:
ll-o-79 Council adopted Resolution 5973, authorizing execution of a
contract with Price Waterhouse for consulting servfces not to
exceed $11,000.00 to ~id i~ the improvement 6f theCity 1 s
Data Processing Center. · ·
lrnMORANDUM
DATE:
TO:
FROM:
October 29, 1979
City Manager
Finance Director
SUBJECT: SELECTION OF A CONSULTING FIRM TO AID IN THE
IMPROVEMENT OF THE CITY'S DATA PROCESSING CENTER
In June of 1979, the City Council receiv~d a report from the
Citizen's Committee formed to review the city's data processing
problems recommending that the city consider replacing its
present computer system with one offering greater flexibility
and growth potential. During the meeting, the council discussed
the problems with the committee members and directed the City
Manager to locate a suitable consultant to aid the city in
determining its data processing needs, selecting viable solutions
and obtaining proposals and costs from vendors.
In September the attached request for proposal went out to
six consulting firms who had shown some interest in serving
the city's needs. Proposals were due back to city hall by
the close of business October 12, 1979.
Four of the six firms responded to the RFP, two of which indicated
that they had decided not to propose. The remaining firms,
Integrated Research and Information Systems (IRIS) and Price
Waterhouse, submitted proposals which are attached for your
review.
The primary considerations in the staff review of the proposals
were 1) the company's experience and success with other similar
systems, 2) the company's experience in municipal government
in general, 3) the technical capabilities of the company and its
staff, 4) the cost of the proposal and S) the company's under-
standing of the work required. The Finance Director was primarily
responsible for the review of these proposals, although input
was requested from other staff members.
INTEGRATED RESEARCH AND INFO~\lATION SYSTEMS (IRIS)
The IRIS proposal included a list of five companies that have
received similar services from IRIS in the recent past. An
attempt was made to contact four of the five companies. Three of
these references were branches of the Navy Personnel Research
and Development Center where several different mini-computer
October 29, 1979
Page 2
systems have been installed with the assistance of Mr. Mark Underwood,
a key member of IRIS. These insertions ranged in complexity and
application, 1.owever, none were directly related to applications
the city will :equire~
The fourth refer~nce was an architectural firm who we have been
unable to reach tvr comment.
The following is an analysis of the IRIS proposal using the
five points outlined above:
1) The company's experience and success with other similar
systems: IRIS and particularly Mark Underwood have
considerable technical experience in the field of mimi-
computers. Contact with the various Navy references have
confirmed the technical qualifications of Mr. Underwood
2)
3)
4)
S)
are well established, The success with the Navy systems has
been proven over the past few years.
However, according to the references contacted and the
IRIS proposal, there have been no system installed that
concentrated on accounting and management reporting systems
similar to those we are requiring.
The company's experience in municipal government in general:
The IRIS proposal does not list any governmental experience
other than the Navy installations.
The technical capability of the company and it's staff:
As indicated above, Mr. Underwood's technical experience
has been well documented and confirmed. Since the IRIS
proposal indicates that Mr. Underwood would be in charge
of the city's account this is an important factor. All
references contacted1 and the indications from the proposal
itself reflect a high level of technical competance.
The cost of the Proposal: The IRIS propos:il imlicates that
the maximum price for the required study would be $3,140,
(or less if certain steps could be eliminated from the
process ). The first page of the p1·oposal states certain
assumptions upon which IRIS calculated the price of this
project. If these assumptions are incorrect (see section S
below) IRIS may be unwilling to enter into the study at
this time.
The company's understanding of the work required: In the
first section 0£ tho proposal, IRIS indicates that "the
following schedule of events is contingent upon a sufficiently
October 29, 1979
Page 3
high quality of documentation for the software on the Singer
computer system and support operations." This is a basically
false assumption. Cyberdata, the company responsible for
developing the present software packages did not provide any
software documentation other than a basic users manual. !lad
Cyberdata still been in existence this would not have been
a signficant problem. However, I believe IRIS will find the
lack of information increases the work required considerably.
The proposal also talks about the "Transportability" of systems.
That is the movement of a Singer software program to another
computer. It is my understanding that the Singer software
is totally non-transportable. This means any savings in time
or effort IRIS had counted upon due to directly shifting
Singer software to other hardware will be lost. *
The basic outline of the process for data gathering Step 4
through completion, Step 19, appears to be relatively thorough.
Aside from the problems mentioned above, the proposal presents
a workable process.
PRICE WATERHOUSE
The Price Waterhouse proposal is analyzed in the following section:
Price Waterhouse is a major accounting and consulting firm. The
attached proposal was received from the Newport Beach Office,
although there is an office located in San Diego.
1) The company's experience and success with other similar
systems: The Price Waterhouse proposal lists ten different
studies or projects which involved the review of data
processing systems, installation of data processing equipment
and the development of system software. Seven of the ten
references involved system development done for commercial
firms. Contact ,~ith three of these firms have indicated
that Price Waterhouse, and particularly Mr. Bailly and
Mr. Poppe, provided excellent assistance in the selection
of data processing system.
Three of the references listed were governmental in nature:
two transit districts and one city. One of the transit
districts, North County Transit, indicated that the Price
Waterhouse team had been particularly thorough and that
they were very pleased with the services performed to date.
* A discussion with the IRIS representatives on 10-29-79 indicate
that there were some misunderstandings with regard to the documentation
level of the Singer software and a reevaluation of their proposed
process and price would be in order.
October 29, 1979
Page 4
The overall suc:cf'...ss of the installations referred to in tho
Price Waterhouse proposal is diffuclt to judge, since many
are still in the implementation stages.
2) The company's experience in municipal government in general:
Price Waterhouse has long been one of the largest national
accounting firms. But more important than the size of the
firm is the experience and qualifications of the individuals
doing the work. The proposal includes a description of the
professional and business experience of the three individuals
who would be conducting the city's project.
3)
4)
As you can see from the background, all three have extensive
experience in commercial data processing and financial systems.
In the governmental area, Mr. Poppe has had several years
experience with a municipality as a iystems analyst and
programmer, in addition to his experience with transit districts
and other governments.
Mr. Bailly is presently a member of 'he California Society of
Municipal Finance Officers and has had the opportunity to
work with a diverse field of data processing studies. His
primary contact with governmental systems seems to have
come through the transit district study performed £or
North County Transit.
Although, Mr. Mc Nally would undoubtly be the least active
member of the team, his background in business and finance
indicates he has been involved in data processing and
computer systems for many years.
The technical capabilities of the company and its st~fr:
Contacts with several of the references listed in the proposal
have confirmed the technical capabilities of the Price Waterhouse
staff. The background description for each member of the
proposed team shows a wide rm,ge of technical expertise
As with the IRIS proposal, there is no question of the
technical qualifications.
The cost of the proposal: Tho Price Waterhouse proposal
includes a not to exceed price of $11,000. Judging from
conversations with other companies, this fee is in line with
the cost of similar studies performed by Price Waterhouse.
Also, conversations with two of the com~anies who have chosen
not to propose, indicated the cost for this type of study
should fall in the $10,000 to $12,000 range.
October 29, 1979
Page 5
5) The company's understanding of the work required: From the
information in the Price Waterhouse proposal, and conversations
with the team, the understanding of the problems and processes
required seems to be very good. This also has been the case
in several other studjes completed by Mr. Bailly and Mr. Poppe.
The Price Waterhouse proposal seems to lay out a very workable
plan and time table, and is based on a strong comprehension
of the problems.
SUMMARY
In summary, the following chart indicates the Finance Director's
evaluation of the two proposals on the five points outlined above:
IRIS PRICE WATERHOUSE
1) Experience in similar systems X
2) Experience in Municipal Government X
3) Technical capabilities X X
4) Price X
S) Understanding of the task X
IRIS offers the city excellent technical references in various data
processing situations and a very attractive price. However, there
has been little experience in similar financial oriented or munj.cipal
government sys terns and there may be a problem with the initial under-
standing of the task at hand.
Price Waterhouse can provide the city with considerable experience
in other financial/management systems and some experience in
municipal government. They arc also able to offer a high level of
technical capability as well as a good understanding of the necessary
tasks. The major problem is tho price tag.
RECOMMENDATION
I recommend the city accept the Price Waterhouse proposal based on
the more extensive experience in similar systems and municipal
government, as well as the technical ability and task understanding.
In conversations \\7i th other comf,anies and consul tan ts prior to the
RFP, a price in the $10,000 to Jl2,000 appeared to be relatively
acceptable for the service we were requesting.
ATTACH.
Request for proposal·~ the Preparation of bid .-..,ecifications -
com~uter system.
City of Inglewood
Jim Nyman, Management Services Director
P.O. Box 6500
Inglewoud, CA 90301
Planning Research Corp.
Glenn Davis, Vice President
5252 Balboa Avenue
San Diego, CA 92117
· ',. Integr.ated Research & Information System
! . Mark Underwood, President
'/ \ r P.O. Box 19385
r'' San Diego, CA 92119
' . ,.
, , Ralph Anderson & Associates
, '1446 Ethan Way
{,·.suite 101
1 Sacramento, CA 95825
Price Waterhouse
660 Newport Center Drive
Suite 600
Newport Beach, CA 92660
Tom Digre
955S Distribution Avenue
San Diego, CA 92121
'. .. ...
.::
I.•
~
Subject: Re4uest for proposal for the preparation of bid
specifications and selection of a replacement
computer system for the City of Carlsbad.
Gentlemen:
The City of Carlsbad is seeking professional services to aid
in the selection of a replacement computer system. These
services should consist of, but are not limited to, the
following:
1)
2)
3)
4)
5)
6)
7)
Preparation of specifications £or computer hardware
and so£tware to replace the existing Singer System 10.
These specifications will be the basis for a bid or
competitive negotiation process.
Preparation of review criteria including some system
of weighing system capabilities and cost.
Submission of specifications and review criteria to
the city council for approval.
Review of vendor's proposals using the established
criteria.
Negotiation as necessary with vendors.
Recommendation to the city council of a system capable
of meeting the itatedspecifications within the chosen
criteria.
Supervise the initial installation of equipment and
certify, through testing, the operational performance
of the equipment.
i
September 20, 1979
Page 2
The city staff will work closely with the consultant on all phases
of the selection process.
The response to this request for proposal should include the
following information:
1) An outline of the proposed process and a projected time
table, keeping in mind the above outline.
2) Total cost of the consulting services through completion.
3) Information on the company's background and experience
in this type of service.
4) A list of customers in Southern California for whom
similar services have been provided (preferably other
government or public agencies), including the name and
telephone number of an individual who may be contacted
at each location.
S) I£ the company is a vendor or is affiliated with a vendor
of computer hardware or software, please so state.
Responses to this request for proposal should be submitted to
the Finance Director, City of Carlsbad, 1200 Elm Avenue,
Carlsbad, CA 92008, prior to 5:00 P.M., October 12, 1979.
A sample contract for services is attached for your review. If
you need additional information, please call me at the above
number.
Sincerely,
JAMES F. ELLIOTT
Finance Director
JFE:lw
Attach.
THE SINGER SYSTEM 10 -
CITY OF CARLSBAD
BACKGROUND INFORMATION
The City of. Carlsbad is presently using a Singer System 10 -Mini
computer that was purchased in late 1975. Generally, the system
is comprised of the following components:
40K CPU -Model 21 (can support up to three terminals as
configured).
20 MB Disk Storage Capacity -2 model 40 drives (full 20 MB
is in use).
2 CRT Terminals -Model 82 -Used for data input and inquiry.
The applications pr~sently in use on the system are outlined in attach-
ment A.
Attachment Bis an outline of proposed applications. The first section
contains those applications that will be installed as soon as possible
on whatever computer system is selected. The second section lists
these applications that departments have requested, but have nnt yet
been sch~duled for implementation.
If addtional information is necessary, please contact Jim FlJiott~
Finance tiirector at (714) 729-1181, ext. 71.
ATTACHMENT A
CURRENT COMPUTER APPLICATIONS:
l. Utility Billing
. 2. Payroll
3. Accounts Payable
4. General Ledger
5. Fixed Asset Inventory
6. Housing Authority Accounting System
7. Report Generation System (Expenditure/Budget Reporting)
ATTACHMENT B
PROPOSED APPLICATIONS
1. Applications scheduled for implementation
a. Bi-monthly utility billing system.
b. Vacation and sick leave accounting system.
c. Personnel information system.
d. On line budget preparation system.
e. Business Licenses.
£. Vehicle maintenance system.
g. Purchase order processing system.
h. Payroll -retirement dnd workmen's com~ reporting systems.
2. Applications proposed, but not scheduled for implementation.
a. Capital Improvement program (budget) system.
b. Personnel -employee compensation forecasting system.
c. Vehicle parts inventory system.
d. Job cost system for Engineering and Public Works.
e. Land Use Inventory.
£. Class scheduling/instructor compensation system.
g. Water/sewer •.nventory system.
h. Investment system.
.--. ,,--.., -------·-------------------------------------
Integrated Ae1earch & Information Sy1tem1
James P. Elliott
Finance Director
City of Carlsbad
1200 Elm Ave.
Carlsbad, CA 92008
Dear Mr. Elliott:
October J.2, 1979
Please find attached our proposal to provide the City of Carlsbad
with services to aid in the replacement of your Singer system, by
developing 1.pecifications and selection crHeria. The proposal represents,
we believe, the best thinking available in terms of system procurement
practices, and shows a good balance between sensible, pragmatic aspects
of system implementation and ccnversion pitfalls, and solid technical
know-how.
The proposal contains several sections: (1) The Outline for the work;
(2) Proposed work timetable; (3) Cost proposal; (4) Qualifications and
references.
You will note, as I had discussed with you previously, that the key
to a successful procurement and impler~ent:ation is selection of an accredited
and experi~nced expert. I don't believe there are many in Southern California
with the equivalent background we offer the City. You will observe that
our procurement expertise covers systems that are small and large, and
includes multi-vendor systems. We've proven ourselves to the Navy in
these procurement matters, with several major .~cquisitions, and the development
of a performance evaluation plan which resulted in a multi-million dollar
R & D effort which began in FY79.
Further, our attention to the human factors aspects of such procurements
sets us aside. You will note several publicat:l.ons I've authored, documenting
our opinions on the importance of fitting systems to people and organizations.
The timetable we have proposed could be accelerated, of course, but we
feel at the risk of obtaining an incomplete picture of the City's long· t:eriu:
needs. Consi.dering the gravity or the selection process, it doesn't seem ·
sensible to rush the process of deciding what the Citi needs.
We appreciate the opportunity to bid on these rnuch-neede<l seri1ices.
P. Cl Box 19383 Sen Diego. Cahforn1e 92118 • 714/~ 233-4916 0
,r---.
PROPOSAL TO CITY OI, .\RLSBAD, ltr p. 2
?-IlJ/jb
enclosures
~7}+-1
Mark Underwood, CCP
Manager of Product Development
Integrated Ae,earch er Information Sy,tem,
Integrated Research & Information Systems: IRIS Corporation was formed to meet a need to integrate research
and development findings m the design and implementation of information systems. IRIS is composed of scientists
and t~chnicians whose goal is to make computer technology accessible to a wide range of sector• in our society.
Utilizing human engineered systems, I A IS products and services provide low,cost solutions to Government and
industry. The following services and R & D efforts are representative of the company•s capabilities.
Services
• Computer systems hardware/software integration
• Software deYelopment using structured design methodology
• Human factors in the use of computer systems
• Management Information systems design & implementation
• Medical/psychiatric information & accounting (inpatient/outpatient)
• SPSS-DBMS system implementation microcomputer use
• Microcomputttr•based buslnes, software -turnkey systems supplier
" Word processing -consulting, turnkey supplier
• Applications & systems programming (mini and micro systems specialization)
• Computer performance evaluation
Research & Development
• Acquisition & design of computer-based languages
• Machine parsing of natural language
• Computer repruentation & interpretation of semantic information
• Semantic representation & DBMS
• Experiment control systems for human information processing research
• Information systems design methodologies
• Coaxial cable-based digital networks
• P•rsonne! information systems
• Computer support for large-scale survey analysis
• Engineering for profess! ,nal word processing systems
• Office automation
• Computer applications for the handicapped and the elderly
• Organizational factors in the use of computer systems
• Methods for education In the use and programming of micro computers
0 0 11°1~
Integrated Ae1earch & Information Sy1tem1
OUTLINE FOR CARLSBAD CO~PUTER SELECTION PROCESS
(Note: The following schedule of events is contingent upon a sufficiently high
quality of documentation for the software on tl1e Singer computer system and
support operations)
1, Survey of the documentation and code for the Singer system software,
Each program will be rated on each of the following dimensions:
a, Transportability
b, Maintainability
c, Expandability
d. Efficiency/performance
Recommendations will be made to establish requirements for: (a) additional documenta-
tion); (b) further measurement efforts; (c) recommendations for disposition of the
software currently being used, To obtain this information, be~i1es direct inspection
of the software, interviews with key users will be made.
2, Development of validation and acceptance tests for each program. These will
actually be run on the Singer system to verify their correctness and appropriateness
for currently O?erating applications areas,
3, Performance measurell'ent for prototypical job mixes on the Singer system.
Additional data, essential to the development of appropriate hardware/software
specifications for an RFP, will be collected through c.onvcntional measures of system
performance, These findings will be ultimately incorporated into the final specifica-
tions as hardware or software requirements. These requirements will be of two
classes: mandatory (withot,t which vendors will be disqualified), and desirable
(on the basis of which remaining offerors will be ranked). In the latter category,
a benchl'Ulrk will be developed which will aid in the ranking of proposed confi.gur-
ations,
PO Bo>< 19..383 s~1n O,ego, c.:i,.torn,.:i 92119 • 0
CITY OF CARLSBAD
PAGE TWO
Integrated Ae1earch & Information Sy1tem1
4. Data collection phase. Key personnel 1n the City will be interviewed to
determine perceived needs and priorities. To aid in this process, I.R.I.S.
proposes to bring in, for a day, an additional consultant from the Irvine
Research Corporation, who wil:!. of::er ad\•i.ce particular to "'llnicipal computing
problems. This individual, Dr. J~:in Klng, has recently completed an intensive,
and extensive look at urb~n romputing systems under the a~gis of the University
of California, Irvine's Public Policy Research Organization (PPRO). In this manner,
the experience gained by officials in like organizations can be utilized.
The results of this phase will bu documented and recirculated to key City personne.l
to assure agreement regarding the priorities of the various proposed applications
and the preferred configurati<Jn/perfonnance alternatives.
5. Staffing survey will be l!onducted to determine the level of organizational
(City of Carlsbad) capabilil:ies and needs in each of the following areas:
a. In-house training (for continuity of trained personnel)
b. Inter-depa·ctmental exchange of data and systems/procedures
c. Resource sharing ar-cangements between departments within the City
d. Software systems support requirements
e, Operations support requiiements
f, Data quality control requirements
g, Data entry (including supervision and verification) capabilities
h. Conversion capabilities, to include:
(1) Data conversion if needed
(2) Software conversion as appropriate
(3) Personnel training/re-training
6. Hardware Maintenance requirements will be addressed, This aspect of the work
will entail determining the realistic up-time and reliability thresholds desired for
the city so that these features can be traded off, if needed, against cost alterna-
tivea.
PO Sox 19383 San O,ego. Coliforn,.:i 92119 • 0
0 0 11<?1~
CITY OF CARLSBAD
PAGE THREE
Integrated Ae1earch & :11formation Sy1tem1
7 • A facilities survey will be conducted to determine,, at the least:
a, Space availability for replacement system (target site}
b, Space availability for running systems in parallel
c. Review of airconditioning availability to establish temperature
and humidity specifications in RFP
d, Review of power requirements and aYail3bility to determine site
preparation information to be obtained from vendors
e, Determine data communications requirements for on-site circuits
f, Produce a systems security overview and recol!'lllend security
needs for the RFP specifications
g. Impact of installation process on ongoing work
8. Determine realistic budgetary constraints on the systeru, to include not only
hardware, software and maintenance costs--i,e., the direct costs-but also the
indirect costs, including:
a, Training
b. Conversion of data
c. Conversion of programs
d. Cost of running parallel systems if needed
e. Cost of producing additional software documentation as required
f. Cost for supplies and potential future configurational changes or
moves of equipment
9. Prepare first draft of performance specifications for new equipment and software
and submit for r2view. Will include benchmark recommendations, systems and procedures
for conducting the procurement-related activities, etc, A rationale for each
specification will be provided to guard against future vendor protests or questions.
10. Prepare a plan for conversion of software and data and personnel
from the Singer to the new system. In connection with City personnel, this plan
will be translated into probable milestones for the infotination of staff personnel;
thus the staff will be informed on the extent and nature of the procurement process
and the conversion effort.
P. 0. B0x 19383 San o,ego, Cahforn,a 92119 • 0
--·---------·----------------:--~-------------CITY OF CARLSBAD
PAGE FOUR
Integrated Ae1earch & Information Sy1tem1
11. Develop draft selection criteria for evaluating proposals received.
Submit, for internal use only, a selected bidders' list, showing possible
system alternatives. Final procurement will not be limited to those companies,
however. Draft RFP will be circulated to vendors for coroment only.
12. Hold pre-solicitation conference. Conference is anticipated to introduce
a few changes to the RFP before it is finally released.
The conference would be held at a site of the ~ity's choosing, and should take
no more than an hour and a half.
13. Finalize and issue the RFP.
14. Review proposals. Apply selection criteria. Request proposal clarifications
as needed. For offerers meeting all mandatory specifications, a benchmark
("live test demo") will be conducted. With this information in hand, a final
ranking of vendors will be produced, with a recommendation from I.R.I.S, for
an acquisition action. A prime consideration in the selection will be negotiation
with the prime offeror for the most desirable combination of features and services
of the longest period of time. In this vein, conversion costs and other factors will
be consd.dered, as well as the availability of "second-source" vendors for prime
items such as peripherals and certain supplies such as disk packs and ribbons for
printers.
15. Initiate conversion plan, after award. Monitor and require the development of
the vendor's plan for conversion if not fully documented in his offer. Arrange
for some details of the site preparation, in coordination with the vendor and the
City.
16. Rev:l.ew and approve when satisfactory the vendor training p~.
P O. Box ·\9383 San O,ego. Cahforn,a 92119 • 0
.--------------·--·--------------
CITY OF CARLSBAD
PAGE FIVE
Integrated Aetearch & Information Sy1tem1
17. After installation, oversee a~ceptance testing. Negotiate with vendor
to ensure compliance with the agreed-upon terms and conditions of the award.
In particular, attention will be paid the the documentation of software developed,
if any.
18. Submit data base quality and reliability assurance pl~~ to the City.
This plan, offered by I.R.I.S. will provide a vendor-specific plan for assuring
that City systems and procedures, when applied.in the context of the winning vendor's
configuration, will result in reliability of ddta and equipment, insomuch as a
consultant can influence such happenings.
19. Post-conversion debriefing. The City will be briefed on the vendor's success
or failure to me~t the terms of the agreement, and any problems which may influence
the City's future data processing needs. Any difficulties in the City's support
of the system, in terms of personnel or other procedural aspects, as reported to
I.R.I.S. by the vendor, will also be discussed, This will take place about six
months after the installation has begun,
p o. Box 19383 San □,ego. Cahforn,a 92119 • 0
.,--------------------------...,.,---:-------------
0 . 0
11°1~
Integrated Ae1earch & Information Sy1tem1
CITY OF CARLSBAD
PAGE SIX
PROPOSED WORK TIMETABLE
ITEM
1. Survey of documP.ntation
2. Validation &.acceptance test development
3. Perform..~nce measurement
4. Data collection phase
5. Staffing survey
6. Hardware maintenance
7. Facilities survey
8. Determination of budget constraints
9. Draft 1 of performance specifications
10. Converaion plan
11. Draft l of selection criteria
12. Pre-solicitation conference
13. Finalize & issue the RFP.
14. Review proposals.
15. Initiate conversion plan.
16. Review vendor training plan.
17. Acceptance testing/parallel op~ration
18. Data base quality assurance plan
19. Post-conversion briefing
Ru. Box 19383 San 01ego, California 921"19 •
WEEK
1-2
3
3
4
4
5
5
5
6
7
7
8
8
11
1 week after a~ard
Award;+ 1 week
Ins~allation + 3 days
Installation+ 4 weeks
Installation+ 3-6 months
0
CITY OF CARLSBAD
PAGE SEVEN
Integrated Ae1earch & Information Sy1temJ
COST PROPOSAL
I.R.I.S. Direct Labor
(31 days approx, Mr. Underwood)
Dr. John King (Irvine Research Corp.)
2 days; specializad urban computer
system consultant
Clerical and reproduction
Insurance as per Item 10 of contract
TOTAL
SPECIAL NOTE:
S2,340
$350
$200
$250
S3,140
The price quoted assumes that all the tasks cited in
the I.R.I.S. propos~l are deemed necessary by the City.
Should any of these items be deleted, a lower cost
due to a lesser labor investment by I.R.I.S., would result.
Regard fog item 7, "Time Completion" for the consulting effort,
we believe that a post-installation briefing is needed.
However, we will not explicitly bill for it, to allow for
termination of the contract at the time stated in the
draft contract.
PO Sox 19383 San Diego, Caflforn1a 92119 • 0
______________ ,,,.,...,,~---------------·~-----------
Q. '0 11°1~
Integrated Ae,eorch & Information Sy1tem1
CITY OF CARLSBAD
PAGE EIGHT
REFERENCES WORK PERFOR.'1ED
l. Daniel Rahil1y, Project ~.anager
Human Resources Management InfOl:mation Network, HRMIN
Navy Personnel R & D Center
Code P204
San Diego, CA 92152
Phone: 714-225-6452
2. Mark Brown, Vice President
Southwest Consultants, Ltd.
746 N. Stone Ave
Tucson, AZ 85705
602-624-2684
3. Marie McDowell, Technical Information Specialist
~echnical Library
Navy Pers~nnel R & D Center
Code P201L
San Diego,CA 92152
714-225-7971
4. Bernard Rafacz
Operations Researcher
Acquisition and Initial Service
Navy Personnel R & D Center
Code P310
San D:l,ego, CA 92152
714-225-2860
5. Janet D. Dodson, Vice President
Myron C. · Murset Co., Inc.
8725 Mulvaney Drive
San Diego, CA 92119
714-465-8894
Lg-scale mini
acquisition
Coi:isulting for
architectural firm
on software and
systems specifications
Development of speci-
fications for
Technical Library
computer system
Development of ·
ha~dware/software
specifications for
many micro and mini
acquisitions; co-auth-
ored research reports
Consulting in
performance evaluation
.__R_. _□_._s_o_x_19_3,_8_3_s_a_n_□_,e_g_o_. _c_a_1_1fo_r_n_,_a_s_2_11_s_• _________________ o __ J_)
MARK ALAN UIIDERWOOD, CCP
RELt'VANT SPECIFICATION-WRITING EXPERIENCE
1. Design of timesharing system for a Neighorhood Community Health Center
(El Rio Santa Cruz Center, Tucson, AZ), to include medical records, billing·_
and full Federal data collection capabilities.
2. Selection and specifications for procurement by Navy of two generations
of computer systems and software for the Technical Library of the Personnel
R & D Center,
3. Procurement of a dozen computer terminals and associated data communications
equipment for NPRDC.
4, Procurement, on competitive Jasis, of two generations of virtual
memory minicomputer systems for llPRDC's project NPAS.
5. Development of a research and developmf'nt plan to conduct performance
evaluations of a full spectrum of distributing computing alternatives for
the Navy's Broject NPAS, Resulted in 4-y~., multi-million collar prosram.
6. Development of specifications and procurement of a packet-switching
data communications network utilizing a host minicomputer located in San
Diego, for NPRDC,
7. Competitive selection of intelligent automatic computer switching system
for Navy Personnel R & D Center.
8. Competitive selection of "storp,ge module" type 300-million-byte disk
drives for use on a variety of minicomputers.
9. Development of specifications for a multi-vendor, multi-processor configur-
ation to perform Remote Terminal Emulation (RTE) for Nl'RDC's Project NPAS.
10. Hosting of the 1979 Conference of the Computer Performance Evaluation
User's Grcup, sponsored by National Bureau of Standards and the ~avy Personnel
R & D Center.
11. Technical ~ublications in the area of perfor.nance evaluation. See reference
in the Quarterly Bibliography of Data Processing.
12. Contract monitor for a system design to include the development of a
capability for presenting computerized adaptive tests. Included collaboration
with contt'actors is the development of hardware and software perfot:mance
and system selection parameters.
13. Requirements analysis for an architect & engineering firm in Tucson,
including recommendations for hardware alternative:,.,.,
14. Recommendations for software protection against computer crime for
a local business serving the financ:1.al community,
.-... .----------------------------~---
0 0
11°1~
CITY OF CARLSBAD
Integrated Re,earch & Information Sv1temr
PERSON.'.'EL QUALU'lCATIOirn
Mr. Mark Under.tiood will be responsible for all aspects of the contract negotiated
with the City of Carlsbad for consulting services. Currently M~. Underwood is
employed half-ti.toe by the Navy Personnel Research & Development Center and half-time
by I.R.I.S. Corporation. His duties at r.R.I.S. will ~llow him the time needed
for the proposed consulting under the schedule outlined on page 6. A~ stated there
modifications in the time schedule are possible,
A recognized expert in the area of computer procurement and computer perfon.1~nce
evaluation, I.R.I.S. believes that there is no one better qualified to assist you
in this important decision than Mr. Underwood. His qualifications are outlined
in the follo~>ing three documents:
• Specific relevant specification-writing e.xperience
• Standard resume
• Computer Skills Overview
If you have any questions regarding Mr, Underwood's participation on this project:,
please do not hesitate to call me.
Sincerely, -r~'4.x~~
Pamela L. Coker, Ph.D.
President
P 0. Box 19383 Sen Diego. California 92119 • 71<1/ 233-4916 0
0 0 11°1~
Integrated Ae1earch f, Information Sy1tem1
MARK ALAN UNDERWOOD, CCP
Employment History
1979 -present Manager of Product Development
Integrated Research & Information Systems
1972 -1979 President
Integrated Research & Information Systems
1977 -present Head, Systems Engineering Division
C0111puter Support Department
Navy Personnel Research & Development Center
Code P204, Bl, T330
1974 -1977 Computer Specialist, Navy Personnel Research & Development Center
1974 -Technical Writer, Informatics, Inc, MARK IV Systems Company
Technical Services Div, (Box 1452, Canoga Park, CA 91304)
1972 -1973 Research Technician, Tucson East Community Mental Health Center
(40 N, Tucson Blvd,, Tucson, AZ 85719)
1969 -1974 Research Technician, Center for Early Childhood Education,
Arizona Center for Ducation Rsch & Dev., University of AZ
(Tucson, AZ 85721)
1974 -Literary, music critic, Itmnedia (Box 272, Calabasas, CA 91302)
1976 -Consultant on Computer Fraud to American CO!llillerical Services,
San Diego, CA
Distinctions
Certificate in Dota Processing -Systems Programming by
Institute for Certification of Computer Professionals (1978)
Outstanding Performance Rating, Navy Personnel R & D Center (1977-8)
California Community College Teaching Certificate in Computer Science (1975)
Scholarships in Special Education (1971) and Behavioral Science (1967)
Co-founder, Integrated Research & Information Systems (1972)
PO Sox 18383 San o,ego, Ca1tforn1a 82119 • 714/ 233-4916 0
~KALAN UNDERWOOD, CCP
F.ducation
B.A. Psychology (Biology/Chemistry), University of Arizona, 1972, with honors
M.A. Cognitive Psychology, Claremont Graduate School, e;icpected 1979
UNIVAC 1110 Assembler (UNIVAC Fed. Sys. F.d.)
UNIVAC 1110 Hardware/Software (UNIVAC Fed. Sys. Ed.)
Computers, Output, Microfilm (Civil Service Co111111.)
Burroughs B1700, Systems Introduction
Burroughs B1700, DMS II
Burroughs B1700, Data Communications
Burroughs B1700, Reporter
Publications
"Human perrormance evaluation in the use of federal computer systems: recOIIDllendations."
ACM Sigmetrics, Fall-Winter 1979.
"Technical and managerial considerations in data base development.11
NPRDC Technical Report, 1979.
"Systems analysis for NPRDC technical library." NPRDC Technical Repott, 1979.
"Feasibility of a distributed computer network for Navy recrl•iting, 11
NPRDC Technical R~port, 1979.
"Compute::ized adaptive testing and personnel accessioning system design," In
D.J. Weiss (Ed.) Proc. of the 1977 Computerized Adaptive Testing Conference.
Minneapolis, Univ. of Minnesota, Dept. of Psychology Psychometric Methods
Program, July 1977.
"Selection of a DBMS-equipped minicomputer for network applications. 11 Proceedings
of the Computer Performance Evaluation Users Group, San Diego, California,
October 1976.
"The health opinion survey as a self-report epidemiological instrument. 11
Journal of Commuuity Psychology, Vol. 1, No. 3, 335-JJS, July 1973 (with
S, Mc Williams).
''Machine-implemented synthesis of intelligent communication.11 _Ongoing Work Abstracts
In Computers and the Humanities, 1972 (with D. Wallraff),
Conference and Invited Presentations
''Network control and computer systems accountability," To be presented at the 15th
meeting of Computer Performance Evaluations Users Group, San Diego, CA,
October 15-18, 1979 (with R.. Buckingham).
-
MARK ALAN UNDERWOOD. CCP
Conference and Invited Presentations, cont.
''Methodologies for human performance assesBt11ent on computer ayatems." To 'be presented
at 15th meeting of Co:nputer Performance Evaluation Users Group, San Diego, CA.
October 15-18. 1979 (with D. Halstead).
"Aspects of human information processing in computer programming. 11 ?aper presented
at Annual Meeting of American Psychological Association, Engineering
Psychology Division, New York, NY, August 1979.
"Technical evaluation factors in procurement of DBHS systems and services." Invited
presentation at the Computer Performance Evaluation Users Group, New Orleans,
LA, October 1977.
"Human and computer performance evaluation. 11 Paper presented at American Psychological
Association Annual Meeting, San Francisco, CA, August 1977.
"A functionally distributed computer network for Navy recruiting command: Design and
initial developme:1t. 11 ACM Cor.1puter Science Convention, Anaheim, CA, February•
1976.
"A multi-level information processing and retrieval system for 11:edial data."
Invited presentation Tenth Annual Meeting of the Drug Information
Association, Chicago, Ill., 1975.
"The DBMS and observation language in theoret1.cal aesthetics. 11 3rd International
Conference on C01Dputers & the Hwaanitiea, April 1975 (witb J. Gruenberger).
11 IATROS -A successful interdisciplinary approach to medical information processing. 11
Invited presentation Proceedings of the 1974 San Diego Biomedical Symposium,
(with D. Wallraff) •
Invited speaker, 1979 IBM SHARE meeting, NY, NY.
Associations
Association for Computing Machinery (1975 -)
IEEE Com?uter Society (1977 -)
American Teilhard Ass\lciativn for the Future of Man (1975 -)
Founder, President San Diego Chapter World Future Society (1978 -)
Philosophy of Science Association (1975 -)
Society for the History of Technology (1975 -)
Inst:f.t1i"~ of Technological Encounter with Science and Technology (!TEST) ( 1975 -)
Sciet>..:e Fiction Researh Association (1975 -)
Human Factors Society Special Interest Group on Computers (1977)
American Psychological Association (1979 -)
L-5 Society
American Mensa Society, Ltd.
Personal Data
Born 1950; Health excellent; Married; One child.
' i.
-, ,-, ,_------------' ---------------------......
CITY 01" CARLSBAD
Integrated Re,eorch & Information Sy,tem,
DECLARATION
I.R.I.S. has held contracts within the last t~o years which nave involved the
acquisition and resale of computer equipment. However, I.R.I.S. is not a
regular dealer for any line of computer equipment, lve purchase equipment through
regular dealers, integrate software and hardware components and then sell the
new system. I.R.I.S. in no way represents any dealers or any computer equipment
li.ne. Our policy is to shop around for the best possible combination of hardware/
software features and price, Since the hardwar~/software computer business
is undergoing rapid growth with new products appearing monthly, I.R.I.S. does not
have any dealers or manufacturers that we regular1y purchase from, Thus, I.R.I.S,
has no interest in which equipment and software that the City of Carlsbad will
ultimately purchase. Instead, we believe our interest in prudent shopping can
only be an asset to the City of Carlsbad, given the rapid development in the
computer industry.
R 0, Box 19383 San Diego. Cahfornta 98119 • 0
:~
, Planning Research C,urporation
City of Carlsbad
Attention: James F, Elliott, Finance Director
1200 Elm Avenue
Carlsbad, California 92008
Dear Mr. Elliott:
October 10, 1979
Ser: 79-60-1148
PRC is appreciative of the opportunity to review your RFP for a consultant
to prepare bid specifications for a replacement computer system.
After a careful evaluation, we have decided not to submit a proposal.
Thank you for the opportunity to review the RFP and please remember us
if further work is required.
R. Glenn Davis
Marketing, Western Operations
RGD:mag
PRC Data Services Company
5252 Balboa Avenue, San Diego, California 92117
Telephone (714) 278·3352
RESOLUTION NO. 5973
A RESOLUTION OF TIIE CITY COUNCIL OF THE
CITY OF CARLSBAD, CALIFORNIA, AUTliORIZING
THE EXECUTION OF AN AGREEMENT BETWBEN THE
CITY OF CARLSBAD AND PRICB WATERHOUSE AND
COMPANY FOR CONSULTING SERVICES RELATIVE
TO THE CITY DATA PROCESSING •:"..-,TEM.
WHEREAS, proposals have been received by the City of Carlsbad
7 for data processing consulting s€rvices; and
8 WHEREAS, the most responsive proposal has been submitted by
9 Price Waterhouse and Company in In amount not to exceed $11,000;
10 and
11 WHEREAS, the funds are avai able for this project in account
12 no. 22-170-3045;
13 NOW, THEREl;ORE, BE IT RESOLVED. by the City Council of the
14 City of Carlsbad as follows:
15
16
1. That the above recitaticns are true and correct.
2. That the proposal of Price Waterhouse is hereby accepted,
1'7 and the Mayor and City Clerk are hereby authorized to execute a
18 contract therefore.
19 PASSED, APPROVED AND ADOPTED, by the City Council of the City
20 of Carlsbad at a regular meeting held on the 6th day of November,
21 1979, by the following vote, to wit:
22
23
24
25
26
27
28
AYHS:
NOES:
ABSENT:
ATTEST:
~0'/4 l"IJ\ I,.
(SEAL)
Councilmen Packard, Skotnicki, Anear, Lewis and
Councilwoman Casler
None
None
RALPH ANDERSEN AND ASSOCIATES
Mr. James F. Elliott
Finance Director
City Hall
1200 Elm Avenue
Carlsbad, California 92008
Dear Mr. Elliorr:
October 3, 1979
Just a short note to thank you very much for sending us a copy of your Request
for Proposal regarding the preparation of bid specifications and selection of a
replacement computer system for the City of Carlsbad.
As you may know, we have completed a number of studies dealing with the feasi-
bility of using data processing, as well as how a city should organize a staff
for data processing purposes. However, while we are qualified to assist the
City in preparing specifications and review criteria, we are not staffed in a
way that would permit us to be available on a continuing basis to assist with
vendor negotiations and to supervise the installation of a computer system. As
a result, we must decline to submit a proposal.
We very much enjoy working for the City of Carlsbad, and hope you will provide
us with opportunities to be considered for additional assignments in the future.
Best regards.
s;g;;~
Ralph Andersen
RA:ma
1446 ETHAN WAY • SUITE 101 • SACRAMENTO, CALIFORNIA 95825 • (916) 929-5575
CITY OF CARLSBAD
PROPOSAL TO ASSIST IN SELECTION
AND IMPLEMENTATION OF
COMPUTER EQUIPMENT AND SOFTWARE
OCTOBER 9, 1979
ouse&:cco
Mr. James Elliott
Finance Director
City of Carlsbad
1200 Elm Avenue
Carlsbad, California 92008
Dear Mr. Elliott:
660 NEWPORT CENTER DRIVE
NEWPORT BEACH,CALIFORNIA 92660
714•640•9200
October 9, 1979
In response to your request of September 20, 1979, we are
pleased to submit our proposal to assist the City of Carlsbad in
selecting appropriate computer equipment and software and in pro-
viding project management assistance through the initial implemen-
tation of the equipment.
Project background and scope
Based on discussions with you, it is our understanding that
your existing systems and equipment are inadequate to satisfy cur-
rent and future needs and that therefore you would like to start
over with new equipment and software. Therefore, the primary objec-
tive of this project is to identify computer hardware and software
which will be capable of processing the City's current system require-
ments and be expandable to satisfy the growth capability needed for
future computer applications.
Approach
Our typical approach to completing this type of engagement is
to encourage the client to proceed through the exact seven steps
that you have outlined in your RFP. We have found that completing
these stops in a formal and documented manner fa an effective way
of minimizing the risk of an improper decision. A specific descrip-
tion of what we would do in each one of these steps is provided in
• Mr. James Elliott 2 October 9, 1979
the work proeram attached as Exhibit I. Listed below are some of
the "keys to success" that you should consider in procee<ling through
this process.
• You should start with a complete description of your
system requirements expressed in terms of system
features and outputs needed.
• Prior to issuance 0£ the RFP, all alternatives should
be considered, i.e., in-house versus service bureau.
• The requirements and specifications provided in the
RFP should be thorough and precise.
• City management should actively participate in the
final selection process.
• A thorough implementation plan should be developed
which gives proper consideration to the time phasing
of conversion and to user preparation.
Staffing
Overall responsibility for this assignment will rest with
Mr. James P. McNally, partner responsible for our Newport. Beach
and San Diego Management Advisory Services (MAS) practice.
Mr. Dieter M. Bailly, who has conducted a number of projects of a
similar nature, will be the project manager and he will be assisted
by Mr. Jeffery Poppe, a member of our data processing consulting
staff who has been involved in several similar engagements. The
detailed resumes of the project team are attached to this proposal.
qualifications
We believe we are well qualified to perform this work based
upon the fact that we have ass:!.sted numerous clients both in the
private and public sectors through this process in recent years.
We have attached as Exhibit III a summary of our qualifications in
the fonn of a list of clients for whom we have performed this type
of engagement. We have limited the project descriptions provided
• Mr. James Elliott -3 -October 9, 1979
to those projects carried out by members of the proposed project
team. Also, we have included the name and number of individuals
who may be contacted at a few of these clients. In addition to
our prior experience of this type, we would bring to the engage-
ment both our unqualified independence and our commitment to
provide the highest quality service.
For your information we have enclosed a copy of a document
entitled "Management Advisory Services to Local Government" which
describes the full range of consulting services that we offer to
state and local government clients.
Estimated timing and fees
A summary chart indicating the elapsed time for the comol~tion
of each major step is included as Exhibit II. Based upon prior
experience, we believe that the recommendations regarding the
equipment and software can be made to the City Council approximately
10 to 11 elapsed weeks after the start of the project. The addi-
tional effort required during the installation of the computer
hardware and software (Tasks 7 and 8) is expected to continue beyond
that date.
Our professional fees for this engagement
estimated time per task as shown in Exhibit I.
implies that our fees for the project will not
are based upon the
This level of effort
exceed $11.0DO. That
fee would cover the professional services as well as the directly
related out-of-pocket expenses such as typing, printing, and mailing
the request for proposals to the vendors Please note that we have
allocated 40 hours to providing implementation assistance (Task 8).
At this time, it is not possible for us to estimate the magnitude
of the implementation effort that you will incur. That effort will
be largely dependent upon the availability of application software
that meets your needs. Thus, the 40 hours that we have allocated
should be viewed as a project management commitment on our part and
in no way relates to the amount of effort that you may have to devote
to the implementation. If in the course of that implementation you
Mr. James Elliott -4 -October 9, 1979
would like us to participate in a larger role, we would be happy
to work with you in defining and estimating the level of effort
that you feel is appropriate,
* * * * *
We believe that we have the background, skills and tools
necessary to help you through this process in a successful manner
and we would appreciate the opportunity to work with you. Should
you have any questions concerning this proposal, please contact
Mr. James P. McNally or Mr. Dieter M. Bailly at (714) 640-9200.
Yours very truly,
.-..,
CITY OF CARLSBAD
WORK PLAN FOR COMPUTER RFP
AND EVALUATION
Task
1. Gather information on system feature
requirements, input documents, output
reports, scorage requirements, and
transaction volumes for each of the
seven current computer applications.
Our involvement will be primarily one
of guidance and direction to City staff
who will gather information and develop
schedules of system characteristics.
2.
3.
Write RFP utilizing the information and schedules
developed in Task 1. Review RFP with City Council
prior to issuance. We expect to distribute the
RFP to approximately 6 to 8 vendors.
Follow-up on vendor questions.
4. Develop a set of criteria for evaluating
the vendor responses to the RFP. The weighting
of the criteria will be reviewed with the
Finance Director and the City Council.
5. Evaluate vendor responses to the RFP. A
preliminary evaluation of all vendor reAponse~.
will be performed to reduce the number of
proposals evaluated in detail. We expect to
perform a detailed evaluation of approxi-
mately 3 to 4 vendor proposals. Our prelimi-
nary and detailed evaluations will be reviewed
with the Finance Director,
EXHIBIT I
Page l of 2
Estimated
hours
16
16
6
6
32
6.
Task
Write a report containing our evaluation
of the vendor responses to the City's
requirements. We will present our report
to the City Council for approval.
7. Assist the City in contract negotiation
with the selected vendor. Our assistance
will include identification of specific
factors which should be addressed in the
contract.
8. Develop an implementation plan that gives
proper consideration to the need for system
cesting/parallel activities, for time phas-
ing of the application conversions, and for
user preparation activities including user
procedures and training. Monitor the City's
activiti~w in carrying out the plan.
9. Project administration.
Total hours
EXHIBIT I
Page 2 of~
Estimated
hours
24
8
40
12
l§Q,
CITY OF CARLSB,\I!
TlMEl'ABLE FOR COMPUTER_RFP AND EVALUA'l'_ION
~
1. Gather information on system requirements
2. Write and distribute RFP
3. Follow-up on vendor questions
4. Develop evaluation criteria
5.
6.
Evaluate vendor proposals
Write a report and present to City Council
7. Assist in contr~ct negotiation
8. Provide implementation assistance
9. Project administration
A. RFP is distributed to computer vendors
B. Vendor responses received
C. Final ~eport is approved by City Council
l 2 3 4 5 6
A
Wel'ks
7 8 9 10 11
B-
---c
12 13 14 15
--------------
)
"d tr1
: @
II> H
tt1
I-'~
0
I-ti
H
1-'IH
DESCRIPTION OF RELEVANT
CLIENT EXPERIENCES OF
PROPOSED PROJECT TEAM MEMBERS
North County Transit District
EXHIBIT III
Performed a review of the District's total data processing
requirements. This project included the analysis and selection of
tasks which could most beneficially be processed on in-house com-
puter equipment.
In addition, we were engaged to: (1) establish a systems
development and implementation plan; (2) define the District's
current and anticipated information requirements reporting require-
ments; and (3) estimate computer processin8 requirements for the
potential data processing applications, and (4) develop a RFP for
EDP equipment and application systems, evaluate the proposals,
and present our findings to the board.
Reference: Hr. Sal Pandolfo
Uanager Administrative
Services
303 Via Del Norte
Oceanside, California 92054
(714) 758-9000
City of Anaheim
As the auditor of the City, we have performed a review of
the City's data processing uepartment including an evaluation of
the City's financial applications. The City operates a service
bureau which provides data processing services to approximately
fifteen cities belonging to tne Municipal Data Systems (}IDS)
group.
Hydro Conduit
PW & Co. provided extensive assistance to two divisions of a
national building materials manufacturer and construction firm in
the development aud implementation of on-line financial systems.
EXHIBIT III
-2 -
An analysis of the current systems and ~rocedures, conducted in
conjunction with client personnel, resulted in EDP requirements
which were the basis for a RFP for ED? hardware and applications,
which was produced jointly by PW & Co. and client staff.
PW & Co. then assisted the client in selecting EDP hardware
and application software packages and in successfully impl~menting
these systems over the past year.
Reference: William T. Lightcap
Vice President and Treasurer
Hydro Conduit Corporation
610 Newport Center Drive
Newport Beach, California 92660
(714) 644-4850
U.S. Rentals, Inc.
We have just completed the first phase of a multi-phased data
processing engagement. This first phase was intended to document
requirements and to identify and evaluate appropr5.ate computer
hardware, application software and communication equipment alterna-
tives which will satisfy U.S. Rentals' long-range EDP objectives.
The subsequent phases of the project include the following steps:
1. Preparation of a request for proposal for the
selection of the computer hardware and applica-
tion software
2. Evaluation of vendor responses and selection of
hardware/ software
3. Systems design and -programming
4. Installation
5. Post-implementation audit.
Reference: Mr. Neville Alexander
Vice President-Finance
U.S. Rentals, Inc.
17871 Mitchell Drive
Irvine, California 92714
(714) 556-4800
-3 -
EXHIBIT . III
V & W Castings
We are currently assisting management in selecting computer
hardware and software which would satisfy the need for accurate
and timely management information. To accomplish this objective,
our firm prepared a "request for information" (RFI) and distributed
the RFI to selected manufacturers of data processing equipment. In
addition, a fact analysis system was developed to evaluate the
responses.
Reference:
Proto Tool
Ron Collins
Controller
V & W Castings, Inc.
6032 Shull
Bell Gardens, California 90201
(714) 522-8762
We are in the final stages of completing an engagement at
Proto Tool which included the following tasks:
1. Conducted a requirements definition study
2. Prepared a request for proposal for the selection
of computer hardware and application sofn1are
3. Evaluated vendor responses and selected appropriate
data processing hardware and software
4. Assisted in the systems implementation.
Refereuce:
Racal-Dana
Mr. Donald R. Davis
Controller/Treasurer
Proto Tool Division
Ingersoll-Rand Company
2600 East Nutwood Avenue
Fullerton, California 92631
This engagement included the preparation of a long-range data
processing plan whi.ch comprised a summary of management's information
needs, various alternatives available to sa~isfy these needs, and the
preparation of a RFP for computer hardware and application systems
and its subsequent evaluation.
EXHIBIT III
-4 -
Datum, Inc.
We are currently providing project management guidance in the
selection process of a new computer for Datum, Inc.
Dynair, Inc.
Conducted an engagement that evaluated computer hardware and
application software to meet Dynair's data processing requirements.
The analysis outlined primary advantages and disadvantages of various
alternatives considering financing costs and the vendors' ability to
satisfy Dynair's requirements.
Orange County Transit District
In addition to being the District's independent auditors, we
currently are engaged in performing a system assurance review of
OCTD's EDP department. The applica:::ion systens included in the
review are the general ledger, accounts payable, payroll, and
fixed assets.
Additionally, we have completed a study of the Orange County
Transit District's accounting and financial reporting systems that
included:
• defining the District's current and anticipated manage-
ment information requirements;
• estimating computer processing requirements for the
potential data processing applications, including the
approximate computer configuration (equipment and
related services) needed, the characteristics of the
computer program required, and the estimated average
monthly computer processing cost.
* * * *
Position
Education
Range of
experience
Professional
and business
history
Professional
and business
experience
James P. McNally
Partner in charge of Management Advisory Services
(MAS) in the Newport Beach and San Diego offices.
University of California, Berkeley, B.S., Business
Administration, 1964; University of California at
Los Angeles (UCLA), M.S., Operations Research, 1968.
Project responsibility for consulting engagements
in a variety of industries, primarily in the
development of computer-based and manual systems
for planning, control, and decision-making with
emphasis on problem-solving using quantitative
analytical techniques.
Price Waterhouse & Co.: Admitted to partnership
in 1977, Los Angeles; transferred to Orange County
office in 1978; manager, 1970 to 1977; consultant,
1968 to 1970. Bank of America, Computer Systems
Analyst, 1965 to 1968.
Planning for computer-based information systems
Responsible for a study to define for a Fortune
500 di\rersified company corporate level informa-·
tion and planning requirements pertaining to
corporate budgeting and control, external report-
ing, tax reporting and compliance, key-iten1
reporting/early warning systems and long-range
financial and tax planning.
Project responsibility £or an "information systems
survey" of a bakery products manufacturing company.
The survey defined management requirements relating
to management control, financial control, sales
reporting and analysis, materials management, pro-
duction planning and control, and marketing plan-
ning and strategy. The objective was to identify
problem areas and to develop recommendations
describing the direction that should be taken in
reaching and implementing appropriate solutions.
Project manager responsible for the direction of
a combined team of Price Waterhouse & Co. and
client personnel in surveying the management in-
formation requirements of a bottled water manu-
facturer and distributor for the purpose of setting
direction for computerized system development.
Subsequen·ly, managed a feasibility study for a
system to 'echanize the major administrative and
reporting functions of the company -sales record-
ing, billing, customer reporting (300,000 customers),
and sales and marketing reporting.
.-,
James P. McNally
• Page two
Professional
and bus i.nes s
experience
(continued)
Professional
and business
affiliations
Speeches and
publications
Project responsibility for the development of re-
quire1n-ents relating to a pet product manufacturing
inventory control system. The requirements included
the definition of controls necessary to assure that
the perpetual records accurately reflected physical
balances and to assure that the accounting book
inventory could be reconciled to the perpetual
records.
Provided project management direction over a three-
year period to a SOO·•b1?d hospital in installing a
fully mechani.zed administration and communication
system. The project included definition of the
hospital's information and processing needs, a
survey of available hardware and software, selec-
tion of the approach (in-house vs. shared systems)
and the system best suited to the hospital's needs,
and implementation of a system providing on-line/
real-time communication capabilities between the
nursing stations, the ancillary departments, and
the business office.
The Institute of Management Science.
UCI Foundation, Board of Directors.
"Business Early Warning Systems Using Discriminant
Analysis" -Los Angeles Chapter of the Association
for Sys terns Management.
"Pitfalls of Computer Time-sharing" -California
Certified Public Accountants Foundation for
Education and Research.
"Profit Planning Using Financial Models" -National
Symposium of Federal Government Accountants
Association.
"Dynamics of Corporate Financial Planning" -
Fifty-Second National Convention, Financial
Executive Division, National Retail Merchants
Association.
"A Case Study -The Development of a Successful
Inventory Management System at Earle M. Jorgensen
Co." -1975 National Meeting of the Steel Service
Center Institute.
"A System for Predicting the Relative Financial
Strength and Loan Quality of Supervised Associ-
ations, as developed for the State of California,
Department of Savings and Loan" -Financial
Managers Society for Savings Institutions.
"How Management Science Can Save You Money"
Spring 1977 issue of Price Waterhouse Review.
Position
Education
Range of
Experience
Professional
and business
history
Professional
and business
experience
Dieter M. Bailly
Senior Manager, Management Advisory Services in
The Orange County Office.
B. S., Narketing, M. B.A., Marketing Mana3ement,
University of Southern California.
Over sixteen years of experience in the data
processing industry as manager (data processing,
systems and operations), consultant, and systems
analyst conducting EDP feasibility studies,
design and implementation of management informa-
tion systems, evaluation of data processing
equipment and software systems, development of
data processing system and operation require-
ments, and evaluation of the efficiency and
effectiveness of EDP operations and controls.
Price Waterhouse & Co. : Senior 11an,:tger, 1978 -
date; Hanager, 1975 -1978; Consultant 1973 -1975.
Teledyne Packard Bell: Data Processing Manager,
1971 -1973.
Unionamerica Computer: Data Procef;sing Special-
ist/Consultant, 1970 -1971.
Teledyne Systems Co.: Manager, Data Processing
Systems, 1967 -1970.
Rockwell International: Systems Analyst, 1965 -
1967.
Mattel Inc.: Supervisor, Order Processing, 1964 -
1965; Supervisor, Payroll/timekeeping, 1960 -
1964.
Developed long-range data processing plans for
numerous companies.
Defined data processing requirements and pre-
pared and evaluated proposals for the acquisition
of computer hardware and applicat:i.on software.
Performed a management review of a m,1jor project
design and implementation effort from a manage-
ment, control, and organization viewpoint.
Dieter M. BailL-,
Page Two
Professional
and business
experience
(continued)
Assisted in the development and installation of a
national on-line order entry, billing and inventory
control system (finish goods and replacement parts)
for a large distributor of photography equipment.
This included equipment evaluation.
Managed and assisted in the design of an automated
inventory system for a transit district. Defined 1 word processing requirements and prepared and eval-
uated proposals for the acquisition of word
processing equipment.
Designed and implemented numerous data processing
applications including payroll, labor, accounts
payable, accounts receivable, sales analysis,
forecasting, budgeting, inventory control, pur-
chasing, requirements planning, market research
analysis, general ledger, logistics and auditing.
Conducted organizational, procedural and effect-
iveness reviews of data processing installations.
Managed systems for a large aerospace company
including the scheduling, budgeting, control of
performance, development of systems and documen~
tation standards, and establishment of a training
program for new analysts.
11anager of data processing for five separate cor-
porate entities in the home entertainment industry,
with the primary responsibility to establish
controls, consolidate EDP requirements, reduce
costs, reorganize the data processing department
to practice "third generation" operation systems
and prograt11I11ing techniques, and design and imple-
ment systems in the financial sales and manu-
facturing area.
Proposed, presented, designed, and implemented
and directed the programming effort of a data
processing system for a large magazine and book
publisher/distributor.
Designed and implemented an automated magnetic
tape library system which included scheduling,
job setup and operator-run instruction.
Performed a continuing system assurance audit
of new on-line parts inventory system in its
development, testing and implementation phases
for a foreign distributor of automobiles and
replacement parts.
Dieter M. Bail{"'l
Page Three •
Professional
and business
experience
(continued)
Professional
and business
affiliations
Defined point-of-sale requirements for a fast
food operation and prepared and evaluated proposals
for the acquisition of point-of-sale equipment.
1 Member, Californ:i.a Society of Municipal Financial
Officers.
?1ember, Co~~crce Associates, University of Southern
California.
Certified Management Consultant
Nember, Institute for Management Consultants
Certified Data Processing Auditor
l1ember, EDP Auditors Foundation
Conducted numerous seminars on planning for and
acquiring a minicomputer. Speaker at numerous
data processing user organizations throughout
Southern California. The speech topics include:
"Data Processing Professionalism"
"Data Processing Security Fraud and Control"
11 Irnpact of Data Processing on the Organization"
"Selection and Evaluation of Minicomputers"
"Evaluating the Need for Point-of-Sale Devices
for the Restaurant and Fast Food Industry"
"A Potpourri of What I s Available Now: Mini ..
computer Hardware and Software".
"Evaluation and Selection of Application
Software".
Position
Education
Range of
experience
Professional
and business
histor.y
Jeffery L. Poppe
Consultant, Management Advisory Services in the
San Diego of!ice.
M.B.A. -Finance, San Diego State University.
B.S. -Industrial Management, Magna Cum Laude,
University of Cincinnati; member of Beta Gamma
Sigma business and Sigma Iota Epsilon manage-
ment honorary fraternities.
Experience includes consulting work for a variety
of clients on engagements including review of
accounting controls on manual and EDP systems,
development of chart of accounts and accounting
procedures manual, EDP feasibility study, require-
ments definition, RFP development, proposal
evaluation, systems analysis and programming
of on-line integrated financial systems.
Price Waterhouse & Co.: MAS Consultant, 1977 to
date.
Comsol Corp. : Project Leader and Systems Analyst,
1976; project leader and analyst for on-line
financial systems.
Independent Consultant: Systems Analyst and
Programmer, 1975 to 1976; analyst and programmer
for development, implementation and maintenance
of financial systems.
Dataware, Inc.: Project Leader and Systems
Analyst, 1973 to 1975; project leader and analyst
for development and implementation of on-line
financial systems.
City of Cincinnati, Ohio: Interned as systEims
analyst, 1970 to 1973; analyst and programmerr for
development and maintenance of financial and
criminal justice systems.
Professional Performed a detailed review of the accounting
and business controls associated with th~ on-line integrated
experience ~' payroll, accounts payable/purchase order, and
·~ general ledger systems for a municipality.
The procedures and controls associated with
Jeffery L. Poppe
Page 2
Professional
and business
experience
(continued)
each system were surveyed during conversion from
a service bureau to an in-house system. The
results included identification of specific con-
trol weaknesses and consultation with finance and
various user departments toward the correction
of weaknesses in the manual procedures and the
EDP systems.
Performed a detailed review of the accounting
controls associated with the payroll system of
X a government contractor. The study included a
survey of payroll procedures at three divisions
and resulted in specific recommendations to
improve the manual and EDP payroll procedures.
Developed the EDP requirements for the integrated
financial applications of a transit district. Y The requirements definition process considered
both the needs of management and the regulatory
requirements of UMrA level B reporting.
Provided extensive assistance to two divisions of
a national building materials manufacturer and
construction firm in the development and imple-
mentation of on-line integrated financial systems.
This effort included a survey of the current
financial systems, definition of EDP requirements,
writing a Request for Proposal for computer
hardware and financial applications, evaluation
of proposals, raview of client-developed system
designs, writing programming specifications for
modifications to vendor-supplied application
packages, and writing a user-oriented conversion
study and user documentation. The applications
are being implemented on two minicomputers, one
at each divisional office, which will process
transactions originating from several sites
throughout the ~estern United States.
Developed a financial model of a national moving
and storage firm which was an acquisition
candidate of a private investor. A timesharing
terminal was used to produce proforma financial
statements useful to the investor and the
investment banker in ev •. luating the target company.
Jeffery L. Poppe
Page 3
Professional
and business
experience
(continued)
Utilized EDP timesharing facilities under severa
time constraints to perform yield co:nputations
for a mu.~icipal bond refinancing
Conducted a feasj.bility rtudy for conversion from
a timesharing to an in-house ·minicomputer installa-
tion for a sports equipment manufacturer.
Designed, programned, and implemented an on-line
integrated order entry, billing, accounts
receivable, and route accounting system for a
dairy. An unusually flexible system was required
in order to handle billing of the firm's govern-
ment, institutional, and both employee and
independent route drivers.
Developed and implemented a system to convert an
electronic module manufacturer's batch order entry,
inventory, billing, and accounts receivable systems
from a service bureau to an on-line integrated
minicomputer.
Developed and implemented on-line integrated order
entry, inventory, routing, and purchasing systems
with links to future integrated point-of-.c;ale,
accounts payable, and general ledger systems for
a major department store lessee. Generalized file
management software was developed to ~rocess a
complex linked and multikeyed file structure. The
svstem was installed on a minicomputer which
replaced an accounting machine.
Provided system and program troubleshooting of
a standard cost system for an electronics components
manufacturer.
Designed an on-line billing and order· tracking
system integrated with a batch accomlts receivable
o.nd route accounting system ftir a photo develop-
ment lab.
Designed an on-lin~ order entry system and batch
bill of materials, shop floor control, and
inventory (with antomated forecasting) systems
for an electronics manufacturer.
Jeffery L. Poppe
Page 4
Professional
and business
experience
(continued)
Professional
Affiliations
Developed an inventory system for a regional
warehouse of & textile fabricator. The system
vas implemented on a minicomputer in the ware-
house with a communication link to a large scale
system in corporate headquarters.
Designed and implemented on-line integrated
vrder entry, inventory, billing, accounts
teceivable, sales reporting, accounts payable
payroll, and general ledger systems for a whole-
saler of plumbing and water well equipment.
Member of Alpha Kappa Psi business frate,rnity.
Member of Society of Advancement of Management.