HomeMy WebLinkAboutMINUTES - 04271993 - 1.37 AUDITOR-CO PTR6LLER USE ONLY
CONTRA COSTA COUNTY FINf.L APPROVAL NEEDED BY:
` APPROPRIATION ADJUSTMENT ® BOARD of SUPERVISORS
T/C 27
ElCOUNTY ADMINISTRATOR
ACCOUNT CODING BUDGET UNIT:
Various
ORGANIZATION EXPENDITURE EXPENDITURE ACCOUNT DESCRIPTION <DECREAS>E INCREASE
SUB-ACCOUNT
100 100
I 1
4235- 2251 Computer Software Costs 1 55,000100
I
2205 2251 I 30,000 :00
I �
o.2y3 2251 I 24,000 100
1 I
I
0990 6301 Appropriable Revenue I 109,000 '00
I
I I
0990 6301 Appropriation for Contingencies 109,000100
I
I '
I
1300 2315 Data Processing Services 19,332100
I I
1300 2251 Computer Software Costs 1 19,332.00
I I
1 I
I � i
I '
I I
I I
I
l I
I I
I I
I I
I
I
I I
TOTALS
128,332! 00 237,33Z' 06
APPROVED EXPLANATION OF REQUEST
AUDITOR-CONTROLLER This adjustment is necessary to rebudget money this
By; Date ' - 4 fiscal year due to cancellation of prior year approved
D.P. projects. The funds will be used to purchase
COUNTY rlxA NISTRATOR mainframe software per the attached memo.
By: E"�_Date —
(
BOARD OF SUPERVISORS
SUPERVISORS POWERS,S171RK
YES: BISHOP.MCPEAK,TORLAKSON
N 0:
Phil Batchelor, Clerk of the Board of
Supervisors and County Administrator
2�'�/ SIGNATURE TITLE ` DATE
By: // /!''�I(�(Tjf/_ Dattee /) APPROPRIATION A POO �I✓�
CONTRA COSTA COUNTY
ESTIMATED REVENUE ADJUSTMENT
T/C 24
ACCOUNT CODING BUDGET UNIT:
Various
ORGANIZATION ACCOUIT REVENUE DESCRIPTION INCREASE <DECREASE>
100 IOC
I 1
0005 8981 Fund Balance Available 109,000100 I
I '
I
I ,
I '
I i
1 I
l
I 1
I
I
I I
I I
I I
I I
I I
I I
I I
I
I I
I
I
TOTALS109- 00001
' I
APPROVED EXPLANATION OF REQUEST ' '
AUDITOR-CONTROLLER Fund balance made available due to the reduction or
�. ��-+ cancellation of Data Processing projects per the
By: Date - attached memo.
COUNTY AD IyI4ATOR Dept. Memo/Project Amounts
By: f Dote y 0235 Memo 6 55,000.00
0220 Memo 7 30,000.00
BOARD OF SUPERVISORS 0243 4102 24 ,000.00
SUPERVISORS POWERS,SMITN,
YES. BIBtIOP,NICPEAK.TORIAKSON
NO: 6or-W
Phil Batcbelor, CIPrk of th- Piard of SIGNATURE ^� TITLE DATE
Supervisors andel Cou; ;y i,�c,:•,istrator
By; ;!�/ ` DateREVENUE ADS. RA00
JOURNAL 10.
(M 8134 Rev. 2/84
\ D �� n✓�� `�'F 7� /I('; /i /7.t5 /:1 i^{..
OFFICE OF THE COUNTY ADMINISTRATOR
CONTRA COSTA COUNTY
DATA PROCESSING SERVICES
February 2 , 1993
TO: Tony Enea
Deputy County Administrato
FROM: Marinelle G. Thompson
Director of Data Processing Services /Jd
SUBJECT: FOCUS Software Purchas4p
The purchase of the FOCUS software for the mainframe and LAN will
enable DPS to provide services in numerous areas requested by
departments in addition to providing a replacement for the
non-supported ADRS package . Graphs currently available under GGDM
would be recommended for PCs , although there is a graph capability
available from FOCUS at additional cost if desired.
FOCUS is a 4th generation language for the development of ad hoc
reporting capabilities and smaller applications and reports. The
proposal outlined in this report will provide a four-user PC LAN j
version, a standalone version and a mainframe version for accessing Y
the big databases and VSAM files . T e LAN---Version will perm tJ
development on PCs and the runtime version will be used to actually
run ad hoc reports from a file downloaded to a server. This FOCUS
software positions us to produce mandated statistical reports that are
presently very labor-intensive, manual operations for departments . We
can also develop reports and systems to be run on a variety of
hardware platforms , not just the central mainframe and PCs .
Examples of detail uses for FOCUS :
- Develop ad hoc reporting capabilities for the LJIS systems group,
Muni Courts, Public Defender, Personnel, LIS and other systems .
- Provide a fast, easier method of implementing some of the mandated
Court coordination reports .
- Provide a replacement for the currently unsupported ADRS product .
- Provide a product that will handle large file requests like those
for the Assessor' s parcel file. Currently we are unable to meet
the monthly ad hoc reporting requests in a cost effective way.
Tony Enea - 2 -
February 2 , 1993
- Provide a four-user PC development function for the DPS LAN,
reducing development costs to requesting departments .
- Provide customers the capabilities of ad hoc reporting from their
own LAN, with downloaded FOCUS files .
The total cost for the capabilities outlined here are :
$ 128 , 080 . 00 for the main FOCUS product, training and 1st year
maintenance
$ 4 , 663 . 00 for the four-user PC LAN version.
$ 1 , 378 .00 for a runtime version.
$ 134 , 121 .00
We have reviewed a variety of products and find this one to be the
most versatile and best suited to the types of needs we are asked to
meet. The cost cited is list price but we expect to be able to
negotiate some discounts which will take some time to arrange , so we
have given worst case cost.
Funding for the project would be divided between the following
customers and would come from currently available 2315 funds .
Offsetting savings will be realized in development and in production
run on departmental platforms . These departments and others are eager
for us to provide this type of service which is often prohibitively
expensive and time-consuming without this kind of software tool .
LJIS . . . . . . . . . . . . . . . .$ 57 , 209 . 00
Municipal Courts . . . . $ 30 ,000 . 00
Public Defender . . . . .$ 25 , 912 .00
Personnel . . . . . . . . . . . $ 21 , 000 . 00
Total . . . . . . . . . . . . . . $ 134 , 121 . 00
MGT/pch
cc: Linda Bulkeley
ice- :i a