HomeMy WebLinkAbout900379.tiff RESOLUTION
RE: APPROVE AGREEMENT FOR COMPUTER SERVICES WITH TOWN OF MILLIKEN
AND AUTHORIZE CHAIRMAN TO SIGN
WHEREAS, the Board of County Commissioners of Weld County,
Colorado, pursuant to Colorado statute and the Weld County Home
Rule Charter, is vested with the authority of administering the
affairs of Weld County, Colorado, and
WHEREAS , the Board has been presented with an Agreement for
Computer Services with the Town of Milliken, and
WHEREAS, said Agreement shall be effective through December
31, 1990, with the further terms and conditions being as stated in
the Agreement, and
WHEREAS, after study and review, the Board deems it advisable
to approve said Agreement, a copy of which is attached hereto and
incorporated herein by reference.
NOW, THEREFORE, BE IT RESOLVED by the Board of County
Commissioners of Weld County, Colorado, that the Agreement for
Computer Services with the Town of Milliken be, and hereby is,
approved.
BE IT FURTHER RESOLVED by the Board that the Chairman be, and
hereby is , authorized to sign said Agreement.
The above and foregoing Resolution was, on motion duly made
and seconded, adopted by the following vote on the 2nd day of May,
A.D. , 1990 .
f" �14-4"1"114
- ;¢- ' BOARD OF COUNTY COMMISSIONERS
ATTEST: I v" w 'J WEL OUNTY, COLORADO
Weld County Clerk and Recorder
and Clerk to the Board ene R. Brantner, C airman
(Th
, EXCUSED
BY:__ De
-2� iyc _- K ��i Geo ge Kennedy, Pro-Tem
Deputy County daerk
APPROVED AS FORM: C s"ta ce L. Herb r
�� EXCUSED
G W.oKir y
County Attorneyo ��
,'" ` `r /9 7',7'-} / , / %/f 900379
AGREEMENT FOR COMPUTER SERVICES
014
THIS AGREEMENT, made this r2 day of IV/9- y , 1990, by and
between the TOWN OF MILLIKEN, COLORADO, with its principal place of business at
1109 Broad Street, Milliken, Colorado 80543, hereinafter referred to as
"Milliken, " and the COUNTY OF WELD, STATE OF COLORADO, a county government with
its principal place of business being the Centennial Center, 915 Tenth Street,
Greeley, Colorado 80631, hereinafter referred to as "Weld County, " is subject
to the following agreed statement of facts:
A. This Agreement shall be effective immediately and shall continue
through December 31, 1990, and to be renewed automatically on a year
to year basis, except as provided in paragraph 5 hereof.
B. Milliken has contracted for access to selected application systems
currently running on the Weld County Mainframe computer.
C. For each application system the Milliken Police Department wishes
to access, a written memo will be sent to that Weld County
department's elected official or department head requesting
authorization for access and the type of access requested, e.g.
INQUIRY, ADD, UPDATE, or DELETE. The signed document(s) will be
forwarded to the Director of Information Services of Weld County.
D. Weld County agrees to make available the requested application
systems when and if documentation of authorization has been
received.
NOW THEREFORE, in consideration of the forgoing recitals and provisions,
terms, and conditions set forth below, the parties agree as follows:
1. Acquisition of Data.
a. Weld County agrees to provide access to the authorized systems
through the use of its dialup access facilities on the
mainframe computer.
2. Charges and Fees.
a. Weld County shall provide Milliken Police Department with a
schedule of fees and charges for services and products which
shall be the standard rates charged to all users of the Weld
County Computer Center. Exhibit "A. " Rates shall have a
minimum revision of once annually, with this revision being
effective January 1st of the new year.
Page 1 of 4 Pages
9C0379
b. Weld County shall provide Milliken Police Department with an
estimate of initial startup costs and on-going maintenance
costs of use of Weld County resources.
c. Milliken agrees to pay on a monthly basis for all services and
data at the rates established by Weld County as provided in
paragraph "a. " above, upon receipt of an itemized bill
identifying such services, data, and rates.
d. Milliken agrees to pay for any staff resource time required
to modify the authorized system(s) in order to accommodate
their request for data from Weld County, but an estimate of
such cost shall be provided Milliken in advance of any such
expenditure of staff resource time.
e. Milliken agrees to pay, at the going rate, all telephone
company costs charged to Weld County that are related to the
dialup connection, upon receipt of a bill identifying such
costs, which are estimated to be (See Exhibit "B" , Section
II) .
3. Method of Delivery.
a. Weld County agrees to provide access through a dialup
connection with the Milliken Police Department and to provide
the necessary access codes and passwords.
b. Milliken agrees that all hardware and software used by them
to access Weld County's systems will be compatible with Weld
County's computer environment. Weld County does not, however,
guarantee that future upgrades to the existing Weld County
computer system will remain compatible with Milliken Police
Department hardware or software.
c. Weld County will provide Milliken with one copy of the
necessary reference manuals for each of the authorized
systems.
d. Milliken will provide the necessary telephone line(s) to
establish the requested dialup access with Weld County. In
addition, the line provided will be a direct line to their
personal computer that is used for the dialup access. The
telephone line(s) will not go through a switchboard or
operator.
e. Milliken agrees that services requested in this Agreement can
be discontinued without notice and without further cost to
Page 2 of 4 Pages
9C0379
Milliken if Weld County determines problems with the Weld
County computer network are related to hardware or software
used by the Milliken Police Department. Service would only
be reestablished at the point in time the problem hardware or
software is demonstrated to work without problems on the Weld
County computer network.
4. Representations.
a. Weld County represents that it will use its best efforts to
provide accurate data to Milliken Police Department pursuant
to the terms of this Agreement. Weld County does not,
however, guarantee the accuracy of the data provided.
b. Weld County represents that, except when the system is down
for normal maintenance, it will use its best efforts to
provide dialup access at all times. Weld County does not,
however, guarantee dialup access availability at all times.
c. Milliken represents that it will not, under any circumstances,
resell or republish for a fee the raw data provided by Weld
County to any third party. The data obtained from Weld County
shall be for the sole use of the Milliken Police Department.
d. Milliken represents that it will follow all federal and state
statutes, rules, and regulations for the dissemination and
disposal of confidential or limited access type information.
5. Miscellaneous.
a. This Agreement shall be binding and inure to the benefit of
Weld County and Milliken.
b. No alteration or variation of the terms of this Agreement
shall be valid unless made in writing and signed by the
parties hereto.
c. Milliken may not assign or transfer this Agreement, any
interest therein, or claim thereunder without the prior
written approval of Weld County.
d. Weld County or Milliken may terminate this Agreement at any
time by giving the other a ten-day written notice of
termination and may terminate this Agreement at any time
without notice upon a material breach of the terms of this
Agreement by the other party.
Page 3 of 4 Pages
900379
e. The relative liabilities of Milliken and Weld County for any
action brought as a result of an injury to a person or
property shall be determined in accordance with C.R.S. ,
Section 13-21-111.5 (1987 Repl. Vol. ) . Milliken and Weld
County shall provide necessary workmen's compensation
insurance at their own cost for their own personnel.
f. No portion of this Contract shall be construed to confer a
benefit or the right of a cause of action lying in tort,
contract, or otherwise upon any person or entity not a party
to this Contract. Furthermore, no portion of this Contract
shall be deemed to constitute a waiver of any governmental or
personal immunities held by the parties or their officers,
agents, or employees.
g. All notices required to be given under the terms of this
Agreement shall be effective upon the dispatch of a copy of
the notice, first class mail, postage prepaid, certified or
registered mail, return receipt requested. Notice to Milliken
shall be given to the Mayor of the Town of Milliken, 1109
Broad Street, P. 0. Box 290, Milliken, Colorado 80543. All
notices to Weld County shall be sent to Board of County
Commissioners of the County of Weld, P. 0. Box 758, Greeley,
Colorado 80632, with a courtesy copy to the Director of
Information Services, P. 0. Box 758, Greeley, Colorado 80632.
IN WITNESS WHEREOF, the parties hereto have caused this Agreement to be
executed by their duly authorized officers or representatives.
t) ca f! • _ BOARD OF COUNTY COMMISSIONERS
ATTEST: (/J-jf alit rex '." WE COUNTY, COLORADO
Weld County Clerk and Recorder
and Clerk to the Bn By: "keg
Gene R. antner
BY: \/cilL—f)f—c4 ..' c t,,cec
Deputy County Clerk
/
ATTEST: TOWN OF MILLIKEN, COLORADO
By: By: ,,. '�/
:4 "U ikiG lfus +r0 %
o Clerk Mayor
Page 4 of 4 Pages
900379
DESCRIPTION OF PROBLEM/COST ESTIMATE
I . SYSTEM OVERVIEW
A. Problem Definition
Being an entity within Weld County, Milliken Police personnel come into
contact with the same people as the Sheriff's Office. In addition, the
Weld County Jail is the holding facility for people who are arrested within
Weld County. Each time someone is booked at the Weld County Jail, the
Sheriff's Office records detailed information to identify the individual
and records the specific arrest information. All this information, which
covers all Weld County, is stored in Weld County's mainframe computer.
On April 17th, 1989, the Milliken Police Department was given access to
Weld County' s mainframe computer, which accommodates the Weld County
Sheriff' s criminal justice information. The Milliken Police Department
accesses the County's mainframe computer by use of their own personal
computer and modem, which utilizes a regular telephone line to communicate
with the host computer. Milliken currently has inquiry only access into
the TEN-FOUR, CARS (Emergency Dispatch) , PLI (Property Location and
Identification) , and WMV (Weld County Motor Vehicles) systems. In
addition, they have full capabilities on Weld County's Electronic Mail
Network.
Having access to the Sheriff' s information, provides additional information
on involvements that in the past, they may not have known about. Accessing
Weld County's criminal justice information helps improve Milliken's
investigation and information retrieval capabilities. Having access to
the Electronic Mail network, enhances the Milliken Police Department' s
communication capabilities with the Weld County Sheriff's Office and other
departments on the Email network.
B. Objectives of the project
1. Provide continued dialup access to Weld County's mainframe computer.
2. Facilitate the sharing of criminal justice information with other
law enforcement agencies.
3. Maintain the integrity of each agency's records through system
security.
4. Provide the user with system training as needed.
5. Give on-call technical assistance for the automated systems.
6. Provide maintenance support to correct program malfunctions, rerun
jobs, consult with the user, and make state, county, or city mandated
changes.
900379
C. System Narrative
Millikens's personal computer and modem are currently configured with the
necessary software to access the Weld County computer network using dialup
access.
Authorization has been given to the Milliken Police Department for inquiry-
only access to TEN-FOUR, Property Location and Identification, Emergency
Dispatch, and Weld County Motor Vehicles . These systems allow the on-
line storing and retrieval of criminal justice information, thereby, making
the information available to other law enforcement agencies in the network.
Having access to the mainframe computer also provides access to the
County's Electronic Mail Network, providing the capability to create, send,
or retrieve messages or whole documents to anyone else in the network,
including the Sheriff's Office and the District Attorney's Office.
All the systems accessible to Milliken have security built into them that
allow only authorized activity within a system.
D. System Interfaces
The Milliken Police Department has inquiry-only access to the authorized
systems on the Weld County mainframe computer.
E. Statement of Feasibility
The continued support of this project is feasible.
F. Special Considerations
This estimate, as requested by the Milliken Police Department, is provided
under the agreement that only "Inquiry" access is requested at this time
and the Milliken Police Department will use the Weld County systems as is.
If at a later date the Milliken Police Department requests ADD, UPDATE,
or DELETE access, program modifications would then be required. The
estimated cost for the additional security access modifications would be
billed in addition to what is already quoted in this estimate. If special
enhancements or new reports are requested by the Milliken Police
Department, the cost for the actual amount of resources used would be in
addition to what is stated in this estimate.
The installation of an additional telephone line or telephone wiring
requirements within the Milliken Police building are the responsibility
of the Milliken Police Department and are not included in this estimate.
Any line that is installed or an existing line that is used must be direct
to the personal computer. The line cannot go through a switchboard or
operator and it should have an RJ11 type connector on it for the modem to
plug into.
Currently all equipment accessing the Weld County network is IBM and the
900379
network and systems within it have been designed for use in that
environment. If network or systems problems are found to be related to
non-IBM equipment or software, Weld County Information Services Department
reserves the right to disconnect the problem equipment or software until
the problem is corrected.
Additionally, Weld County Information Services cannot guarantee that future
upgrades by IBM will remain compatible with non-IBM equipment or software.
900379
II . ESTIMATED COSTS
Maintenance costs, which are billed monthly, consist of costs for time in
accessing the mainframe computer and costs related to keeping the system
functioning. Maintenance costs may include personnel time to correct
system errors, modifications required by the Milliken Police Department,
computer time, equipment rental and maintenance, telephone line charges,
and data storage costs.
All costs are billed only for the amount of resources used.
A. Maintenance System Costs (recurring monthly)
1. On-line System Costs (MPXX Terminal Usage)
a) Computer Usage (machine time) @ $5/mo. $ 5
b) Dial-Up Port Charge @ $0.04/minute--
(Estimated at 2 hrs./month) $ 5
Telephone Line Charge @ $0.10/call--
(Using existing Greeley Line at an
estimated 60 calls/month) $ 6
Lines/Modems Subtotal $ 11
TOTAL MPXX TERMINAL USAGE COSTS/MONTH $ 16
2. Application System Costs
a. Computer Usage (Machine Time) @ $0/mo $ 0
b. .1 Analysts Days @ $226.72/day $ 23
.2 Programmer Days @ $159.12/day $ 32
.3 Personnel Days for Software Subtotal $ 55
TOTAL APPLICATON SYSTEM COSTS/MONTH $ 55
B. Cost Summary for Dial-up connection
MPXX TERMINAL USAGE COSTS/MONTH $ 16
APPLICATON SYSTEM COSTS/MONTH $ 55
TOTAL MILLIKEN POLICE DEPARTMENT MAINTENANCE COSTS/MONTH $ 71
900379
2/ 1/90 (Revised)
1989 1990 PERCENT
RATE RATE INCR/DECR
COMPUTER USAGE
PROCESS TIME/HOUR PRIME TIME $638.3332 $510.4595 -20.03%
PROCESS TIME/HOUR NIGHT $319.1666 $255.2297 -20.03%
DISK ACCESSES/1000 PRIME TIME $0.9078 $0.7260 -20.03%
DISK ACCESSES/1000 NIGHT $0.4539 $0. 3630 -20.03%
TAPE ACCESSES/1000 PRIME TIME $0.7431 $0.5942 -20.04%
TAPE ACCESSES/1000 NIGHT $0.3716 $0.2971 -20.04%
TEMP STORAGE/1000 PRIME TIME $0.7431
TEMP STORAGE/1000 NIGHT $0.3716 $0.2971 -20.04%
TRANSIENT DATA/1000 PRIME TIME $ 0078
TRANSIENT DATA/1000 NIGHT $0.9 $0.3630 -20.03%
DIALUP CONNECT TIME PER MINUTE $0.0400 $0.0400 0.00%
PRINT CHARGE PER PAGE:
1 PART PAPER $0.0400 $0.0400 0.00%
2 PART PAPER $0.0500 $0.0500 0.00%
3 PART PAPER $0.0600 $0.0600 0.00%
4 PART PAPER $0.0700 $0.0700 0.00%
SPECIAL FORMS $0.0400 $0.0400 0.00%
PRINTER SETUPS $0.5000 $0.5000 0.00%
DATA STORAGE:
DISK/1000 CHARACTERS PER YEAR $0.0400 $0.0350 -12. 50%
TAPE REELS PER REEL $12.5000 $12 . 5000 0,00%
TAPE MOUNTS PER MOUNT $0.0500 $0.0500 0.00%
PROCRAMMER AND ANALYST (PER HOUR) :
ANALYST/SYSTEMS PROGRAMMER I/II $26.24 $28. 34 8.00%
PROGRAMMER $18.41 $19 . 89 8.04%
MICROFICHE/MICROFILM:
MICROFICHE ORIGINAL $0. 1500 $0. 1500 0.00%
MICROFICHE DUPLICATE $0.1200 $0. 1200 0.00%
MICROFICHE FRAME $0.0100 $0.0100 0.00%
MICROFILM ORIGINAL $0.1500 $0. 1500 0.00%
MICROFILM FRAME $0.0100 $0.0100 0.00%
OUTSIDE REPORTS:
GENERATED REPORTS-NORMAL COMPUTER CHARGE ($50.00 MINIMUM)
DUPLICATION OF EXISTING FICHE-$1.00/FICHE($10.00 MINIMUM)
TERMINAL EQUIPMENT (PER MONTH) :
IBM 3178 (WITH/WITHOUT IOKEY) $25.22 $25.22 0.00%
IBM 3278 W/0 10KEY $39.83 $39 .83 0.00%
e IBM 3278 W/JOKEY $41.54 $41.54 0.00%
IBM 3276 W/O 10KEY $39.83 $39.83 0.00%
IBM 3276 W/10KEY $41.54 $41.54 0.00%
IBM 3287 MODEL 1 PRINTER $92.29 $92.29 0.00%
IBM 3287 MODEL 2 PRINTER $105.57 $105.57 0.00%
IBM 3287 MODEL 2 PRINTER WITH $108.62 $108.62 0.00%
SPECIAL CARTRIDGE RIBBON
9(10379
Hello