HomeMy WebLinkAbout1994-02-14 94-107 ORDER^OUNCH, ACTION
Date: February 14, 1994 Item No. 94-107
Item/Subject Negotiation ofAppliwtion Software, Service and Computer Hardware Contracts with
Penmmation Enterprises, Lr., of Bethlehem, PA.
Responible Department: Purchesing&dormation Services
Conwemary:
The Information Services Department initially reviewed five companies for the replacemerit of most of
the Cuts software systems road ell related computer hardware. Of the five companies three Puma were
invited to present and demonstrate their software packages to a number of staff members who will be
using the software applications. A request for proposal was then sent to four firma and three proposals
were received:
Gemini Systems -Portland, Maine
Monis, The Compute Center - Falmouth, Maine
Pentamation- Government Systems Division -Bethlehem, PA
After a complete review of the proposals and checking four references of each company, Peatametion
Enterprises, Lou. of Bethlehem, PA was selected and recommeaded to the Finance Committee on January
31, 1994 - am attached memo by William LePm tabulations of proposed software road hardware costs,
and configuration diagrams.
The attached council order authorizes the negotiation of final hardware, software and support service
was and the execution of commas covering Phases I & IT
Mangers Commems:-/X"9 9Unur%r
aQ FZ- Csam�.A- Q,Q 4m uuua 1a
a+v lx :std City Manger
Associated Information. Bid tabulation, Memorandum and Diagrams
Budget Approval.
mance Donator
Legal Approval: { have rwiVeal eyje$ d rd
pra®oYd Con{rn rf !,(ero,nA'.enh
Jeew ifw S
l hag¢ aK!✓rfen{j un.ee� eIn nt ftq City Solicitor
introduced For Wgygy�
Passage ❑ First Reading ❑ Referral
94-10]
Assigned to Councilor 3lanchet to February 14, 1994
CITY OF BANGOR
(JITIF.) Mrbff,_Audinjfiegptiation and Execution f Yarrows„Contracts with
Pentamation Enterprises, Inc. for Application Software Systems and Related
By tha My Connell of W My OI Da ..
ORDERED[
TUT she City Manages is hereby authorized to negotiate and execute
various contracts with Pentamation Enterprises, Inc. for application software,
related computer hardware, and necessary support services in an amount not to
exceed $369.560.00. This order is subject to appropriation and transfer of all
necessary funding.
94-107
IN CITY COUNCIL i'` O R D E R
February 14, 1994 h
Pass Title, Authorizing Negotiation and Execution
of Various Contracts with Pentemation Enterprises,
Inc. for Application Software Systems and Related
CLEM 'O'• -C• v Nerdvaze.....................
omputer
.......//..........�.........9...................
Awipud to
Cnnnnilman
a�
1�
r dtlOtlMV tl®18®FN�3tll i]i10.tli! l
I I FNY iztlna I alma
LNo nal®o ,
mm
&u5
ltlsm.scvatl®I
Iin3LinYeaa l
3tlmtltam
j
eeo
m1Ya
FUYa
rletoa
Fns
V NdtYix
FosoF
OLO
Ong I
]1FYa I
arF I
I I
I I
I I
I I
I
I
I
I au G,.I
I 44
I 44
I 44
I 44
I 44
w
I
I
I N
I r
—I
L'4
__
'4
r dtlOtlMV tl®18®FN�3tll i]i10.tli! l
I I FNY iztlna I alma
LNo nal®o ,
mm
&u5
MEMORANDUM
January 31,19W
TO: Edward A Bernard, City Manger
FROM: William D. Lem Information Services Supervisor
IUI: Computer Systems Acquisition Summary
94-10]
Only one ofthe three finalists, (of the five vendors reviewed) for computer software and hardware
acquisition, is qualified m meet all of the City of Imagers needs now and in the future.
PENTAMATION is the best alterative long-range and offal the mon complete Product line of
software applications" elusively for municipalities. More importantly, PENTAMATION is the only vendor
that has all software applications designed, developed and implemented as atonally integrated computer system
entirely in 4GL (Fourth Generation Language) Relations] Data Bax Management System running under a
UNIX Operating System All application are "truly portable" to over 400 different hardware pletfmras.
All software applications have been reviewed and each module has most ofthe functionality required by
the CityofBangor. The application functions rues on-line transaction posting and batch processing options;
detailed auditing in accordance with established procedures, including sound audit [talk; internal balance of all
funds and transactions; on-line inquiries from summary to detail level; easy mechanism for backup and
restoration of data; complete user documentation on-line and ability to integrate with personal computer based
software. The system mountains error logs within each applicationto record errors and help the user report
problems. Them is versatility and flexibility throughout mon of the applications.
PENTAMATION, is also a value added repackager (VAR) for the Digital Equipment Corporation
(DEC), Compaq, Hewlett Packard and IBM. We recommend that the system software be installed on a DEC
plazfonn. A DEC plam is located in Augusta, red thus are numerous herdvmre installations throughout
Maine. We are also comfortable with DEC's financial strength and we feel assured that support services will be
available when neded.
Other reasons for recommending PENTAMATION:
Customer references for service.
Training Programs conducted by professional personnel.
Remote diagnostics to fix computer software problems.
'Rim line" services to answer customer questions.
Strong support fiom hmdware vendon
peaammion's history to cemimally improve its products.
Active user group.
4TH GENERATION LANGUAGE'
SOFTWARE APPLICATIONS REVIEW
General Ledger
Accounts Payable
Project Management
Accounts Receivables
Cash Receipts
Purchasing
Budget Preparation & Analysis
Payroll
Human Resource Management
Inventory Management
Tax Billing & Collections
Public Services Management
Parks & Recreation
Permits & Code Enforcement
Fleet Management
Utility Billing
Fixed Assets
Violations:Ticket Management
Geo -Base Management
SUMMARY
94-107
PENTAMRTION
GEMINI
MONIS
Yes
No
Mix
Yes
No
Mix
Yes
No
Mix
Yes
Yes
No
Yes
Yes
No
Yes
No
Yes
Yes
No
Mix
Yes
No
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes
No
No
Yes
Yes
N/A
Yes
Yes
N/A
Yes
Yes
Yes
Yes
Yes
N/A
Yes
Yes
No
Yes
Yes
No
Yes
Yes
N/A
Yes
N/A
N/A
19-4GL
9-4GL
5-4GL
3 -COBOL
5 -COBOL
2 -N/A
4-MI%EB
5 -N/A
94-107
CITY OF BANGOR
SYSTEMS BARDWARE
CONFIGURATION REVIEW
DEC3000 UNISY86000
Basic Configuration 6005 300
Processing Speed (Mhz) 175 60
Cache Memory(h4byte) 2 256(KB)
Main Memory Required 64 64
Memory-Upemdable 512 128
Memory Type (H cr Correcting) ECC SIMM
Disk Storage(Gybte) 3.15 3.0
System Software Licenses(Usm) Unlhnited Untimited
DEC3000 UMSYS6000
a This compmison in only on items which have been quoted by "both" vmidora
6005
300
HARDWARE & COMMUMCATIONS
BASIC CONFIGURATION"
28,438
33,W0
Printer Server :2Par Merial
1,390
995
(1)80016001P lmatrix Printer
8,443
7,742
(1)6250 BPI 9 -Track Tape Drive
10,040
10,000
System Software Installation
29,000
21,800
(1)400/300 LPM Matrix Printer
7,844
4,595
(17)Pmonal Computers+
30,109
32,198
(2) Persomf Computers Upgraded
1,230
1,488
(10)Tennuals
10,437
10,374
(10)Pointm
14,V5
10,950
Network ServerPons
8,001
8,195
(20) 14AK Dial-up Modems
10,811
17,900
(20)MWNpleaors
26,640
26,990
• TOTAL
187.158
186.227
a This compmison in only on items which have been quoted by "both" vmidora
ESTIMATED
TOTAL PROJECT COSTS
94-10)
January 30, 1994
IST YEAR 2ND YEAR
ITEM COSTS MAINTENANCE MAMENANCE
SOFTWARE
128,316
14,250
21,523
HARDWARE
149,153
18,396
18,396
COMMUNICATIONS
53,588
11,444
11,444
EDUCATIONRRADJWG
64,102
CONVERSIOWN7PLEMENTATION
48,330
TOTAL $
443,489
44,090
51,363
CITY OF BANGOR 94-101 - -
FUND
ACCOUNTING
PURCHASING' I GENERAL
LEDGER
ENC JIANCE
ACCOUNTING
ACCOUNTS
PAYABLE
FINANCL
REPORTING
COST/PROJECT
ACCOUNTING
EST ATED
PROJECT COSTS
PRASE I
Jum 30,19N
ESMATED
PROJECT COSTS
PHASE R
1ST YEAR
2ND YEAR
ITEM
COSTS
SOFTWARE
44,316
7,948
8,923
HARDWARE
102,689
10,296
10,296
COMMUNICATIONS
21,239
2,764
2,764
EDUCATI MRAI G
17,082
CONVERSION/OWIHMEE AnON
20,350
TOTAL $
205,702
21,008
21,983
ESMATED
PROJECT COSTS
PHASE R
1STYEAR
2ND YEAR
ITEM
COSTS
SOFTWARE
25,%0
1,912
3,825
HARDWARE
32,639
6,300
6,300
COMMUNICATIONS
30,249
8,680
8,680
EDUCATION?RAINING
26,670
CONVERSION/MiPLEMENTATION
9,900
TOTAL $
12,958
16,892
18,805
94-107
PHASE
ESTIMATED COSTS
Jermary 30, 1994
LICHNSE
IST YEAR
2W YEAR
9OFTW RCATION9
FEE MAINTENANCE
MAINTENANCH
Funtl Accounting.
9,000
675
1,350
General Ledger
Encumbrance Accounting
Accounts Payable
Financial Reporting
Coet/Project Accounting
Purchasing
4,000
300
600
System Oparating Licerue
11,026
3,984
3,984
Infornux RDBMS&4GL License
14,690
2,179
2,179
IQ Report Writer (12)
540
810
810
SU6TOTAL
44,316
7,948
8,923
HARDWARE
(1)DEC3000Modd600S
29,828
4,044
4,044
175 Mhz Pm sing Spee!
2 Mbyte Cache Memory
64 Mbyte ECC Main Memory
(3)1.05 Gbyte Disk Storage
(1)800/600 LPM MsMx Primer
8,443
1,920
1,920
(1)6250 HPI 9 -Track Tape Drive
10,040
9%
9%
System Software Installation
20,000
System OS/F Network
9,000
(1) 400/300 LPM Matrix Printer
7,844
1,8%
1,896
UPS 6KVA Unit 15 Mn Benery
7,447
(5) Personal Computers+
8,857
1,200
1,200
(2) Personal Compnhrs Upgraded
1230
240
210
SUBTOTAL
102,689
10,296
10,296
COMMUNICATIONS NETWORK
(2) Temunal Server Pons (56)
8,001
1,140
1,140
(3) Stackable H006 Ports
2,732
504
504
(2) 4-Chamel Multiplexors
2,700
360
360
(2)6 -Port Feature
2,340
120
120
(4)14.4K Dial-up Modems
2,162
480
480
(22) Cabbng/Comsectors/ abor
3,080
(4)Dial-Up Lines
�2N
160
X60
SUB -TOTAL
21,239
2,764
2,764
PHASE I(conl) 94-107.
LICENSE IST YEAR 2ND YEAR
ffx MAINTENANCE MAINTENANCE
(20) Days HardwmelONraNng Syu 9,660
(9)E" Appfimfion Software 7,422
SUB -TOTAL 17,082
(10) Days Appficafion Software 8,180
(15) Interface Progams 12170
SUB -TOTAL 20,350
ESTIMATED COSTS
PHASE ITOTAL $205,676 21,008 21,983
PHASE II
� � BUDGET
�YAG� PREPARATION
PAYROLL
PERSONNEL
POSITION
CONTROL
APPLICATION EMPLOYEE
TMCKING BENEFM
ADMINISTRATION
94-10]
ACCOUNTS
RECEIVABLE
CASH
BELEIPTS
94-107
PHASE H
ES'T'IMATED COSTS
Jammy 30, 1994
LICENSE
IST YEAR
2ND YEAR
SOFTWARE APPLICATIONS
FEE MAICO'ENANCE
MAINTENANCE
Accounts Receivable
4,500
338
675
Cash Receipts
3,500
262
525
Budget Preparation&Analysis
3,500
262
525
Human Resources:
payroll
8,000
600
1,200
Povfion Control
2,000
150
300
Application Tmcb'ng
2,000
150
300
Employee Benefits Admin.
2000
150
300
SUBTOTAL
25,500
1,912
3,825
HARDWARE
(7) Pmsonal Computers+
12,397 -
1,680
1,680
(11)Terminels
5,467
660
660
(10) 400/133cps LQ Printers
14,275
3%0
3.%0
SUB-TOTAL
32,639
6,300
6,300
COM CATIONS NETWORK
(16)4-ChannelMWtlpluma
21,600
5,760
5,760
(16)144K Dial-up Modems
8(A
1920
1920
SUB-TOTAL
30,249
8,680
9,680
EDUCATIONRRAIN
'
(15) Days Apphcatiion Software
12,170
(30) Drys Infom'nrProgmmmirig
14500
SUB-TOTAL
26,670
CONVERSION/NPLEMENTATION
(12) Drys Application Software
9900
SUB-TOTAL
9,900
ESTLMATED COSTS
PHASE UTOTAL
$124,958
16,892
18,805
94-}0]
T'�`
PCBLIC
BILLING
SERVICE
A
MANAGF.N�NT
COLLECflONS
PARR9
DiVF.NTORY AND
tea' RECREATION
CODE
ENFOACEM1ffiVT'
vEfECLE
MANAGEMENT
GEO-BASE
MANAGEMENT
PHASE IV
FISEB
ASSETS
MANAGEMENT
VIOLATION
MANAGER
94-10)
ESTUM TED
PROJECT COSTS
PRASE ID
94-107
January 30, 1994
ESTIMATED
PROJECT COSTS
Pe SE ry
ISTVEAR
2NDY
ITEM
COSTS
MAINTENANCE
MAINTENANCE
SOFTWARE
29,500
2,214
4,425
HARDWARE
13,825
1,800
1,800
COMMUNICATIONS
2,100
EDUCAIIONITRAR4ING
8,180
CONVERSION/�J.EMENTATION
9,900
TOTAL $
63,505
4,014
6,225
ESTIMATED
PROJECT COSTS
Pe SE ry
HARDWARE
CON "CATIONS
BRAINING 12,170
NMIl'LEMENTATION S,I80
TOTAL S 49,350 2,176 4,350
ISTY
2NDY
ITEM
COST
ANCE
ANCE
SOFTWARE
29,000
2,176
4,350
HARDWARE
CON "CATIONS
BRAINING 12,170
NMIl'LEMENTATION S,I80
TOTAL S 49,350 2,176 4,350
(15) CabWg/Com'wtoM,abor 2.100
SUBTOTAL 2,100
(10) Days Application Software 8180
SUBTOTAL .8,180
(12) Days Application Software 9900
SUBTOTAL 9,900
ESTMATED COSTS
PHASE IU TOTAL $63,505 4,014 6,225
94-107
PHASE BI
ESTIMATED COSTS
Ianuary 30, 1994
LICENSE
ISTYEAR
2ND YEAS
SOFTWARE APPLICATIONS
PEE
MAINTENANCE
MAINTENANCE
Tax Billing&Collections
9,000
675
1,350
Public Service Management
4,500
338
675
Parks &Rwreation
1,000
525
1,050
Tvemory Control
4,500
338
675
Code ENbrcement
4.500
338
675
SIZE -TOTAL
29,500
2,214
4,425
HARDWARE
(10)Taminals
4,970
600
600
(5) Personal ComPmera
R 855
1.200
L200
SUBTOTAL
13,825
1,800
1,800
(15) CabWg/Com'wtoM,abor 2.100
SUBTOTAL 2,100
(10) Days Application Software 8180
SUBTOTAL .8,180
(12) Days Application Software 9900
SUBTOTAL 9,900
ESTMATED COSTS
PHASE IU TOTAL $63,505 4,014 6,225
94-107
(15) Days Anlicmion Software 12,170
Filly,] MPUMMIKOR
ESTIMATED COSTS
PHASE WTOTAL $49,350 2,176 4,350
PB SE IV
ESTU TED COSTS
3mmary 30,19N
LICENSE
IST YEAR
2ND YEAR
SOFTWARE APPLICATIONS
FEE MAWTENANCE MAINTENANCE
FIM M agemca
4,500
338
675
Utility Bi g
7,000
525
1,050
Fired Assets
3,500
263
525
Violations Mmg t
7,000
525
1,050
Geo -Base Management
7000
525
1.050
SDB-TOTAL
29,000
2,176
4,350
(15) Days Anlicmion Software 12,170
Filly,] MPUMMIKOR
ESTIMATED COSTS
PHASE WTOTAL $49,350 2,176 4,350