Loading...
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