HomeMy WebLinkAboutAgenda Report - October 7, 1998 (75)CITY OF LODI COUNCII, COMMUNICATION
AGENDA TITLE: Purchase of Personal Computers and PC Memory Upgrades for
the Finance Department ($19,940)
MEETING DATE: October 7, 1998
PREPARED BY: Finance Director
RECOMMENDED ACTION: That the City Council adopt the attached resolution authorizing the
purchase of 13 personal computers, and the purchase of memory
upgrades for an additional 11 PCs in the Finance Department, at a cost
not to exceed $19,940.
BACKGROUND INFORMATION: In October, 1997, and April, 1998, the City Council adopted Resolutions
97-157 and 98-61 (respectively) authorizing the purchase of JD
Edwards financial software and Orcom Systems customer information
systems software.
Under the City's long-range plan, these software programs will migrate to the graphical user interface (GUI)
versions to allow connectivity by other City departments. The GUI versions are designed to run on personal
computers in a windows -like environment, enabling other departments' PC users access (with restrictions) to
data in the JDE and Orcom programs.
However, many of the Finance Department staff have been using AS/400 monitors, also known as "dumb
terminals' (since they only provide access to the mainframe and contain no memory or hard drive), or older
Windows 3.1 -based PCs to connect to the department's AS/400. These terminals and older PCs must be
replaced with newer Windows 95 or Windows NT -based computers to fully utilize the GUI versions of the
software.
An intensive study of existing equipment and the realized need for new equipment in Finance resulted in a
Phased Implementation Plan, attached as Exhibit A. This study was designed to identify the areas of most
critical need, to make the most of existing equipment, and to determine the extent to which new and
replacement PCs could be purchased within the limit of funding already reserved in the Finance Department's
operating budget.
The City Council has approved the use of CMAS contracts with Micron Electronics and Dell Computers for PC
purchases up to $15,000 (Res. 97-108). It is staff's recommendation that use of CMAS contract with Micron
be authorized for the purchase of 13 desktop computers, and for memory upgrades for 11 other PCs in the
Finance Department, at a cost not to exceed $19,940.
FUNDING: Finance Department's 1998/99 Operating Fund
Vicky McAthie, Finance Director
System Review - Stan Helmle, I.S. Manager
APPROVED: Q/r
H. Dixon Flynn -- City Manager
FIN PC98.CC1 09/18/98
. RESOLUTION NO. 98-145
A RESOLUTION OF THE LODI CITY COUNCIL
AUTHORIZING THE PURCHASE OF THIRTEEN
PERSONAL COMPUTERS AND MEMORY UPGRADES
------------------------------------------------------
------------------------------------------------------
WHEREAS, Lodi Municipal Code, §3.20.070, authorizes dispensing with bids for
purchases of supplies, services or equipment when it is in the best interests of the City
to do so; and
WHEREAS, in October 1997 and April 1998, the Council authorized the Finance
Department to purchase JD Edwards Financial Software and Orcom Systems Customer
Information Systems Software; and
WHEREAS, under the City's long-range plan, these software programs will
migrate to the graphical user interface (GUI) versions to allow connectivity by other City
Department Departments, and the GUI versions are designed to run on personal
computers; and
WHEREAS, many of the Finance Department staff have been using AS/400
monitors or "dumb terminals" that allow them to access the mainframe and contain no
memory or hard drive, and older Windows 3.1 based PCs to connect to the
Department's AS/4001; and
WHEREAS, a study of existing equipment and the need for new equipment in the
Finance Department has resulted in a Phased Implementation Plan attached hereto
marked Exhibit A; and
WHEREAS, the Plan identifies the areas with the most critical need, to make the
most of existing equipment and to determine the extent to which new and replacement
PC's could be purchased within the limit of funding already reserved in the Finance
Department's operating budget; and
WHEREAS, the City Council has approved the use of CMAS contracts with
Micron Electronics and Dell Computers for PC purchases up to $15,000; and
WHEREAS, staff recommends use of the CMAS contract with Micron be
authorized for the purchase of thirteen desktop computers and memory upgrades for 11
other PC's in the Finance Department, at a cost not to exceed $19,940.00.
NOW, THEREFORE, BE IT RESOLVED that the City Council of the City of Lodi
does hereby approve the purchase of thirteen desktop computers and memory upgrades
for 11 other PC's in the Finance Department, at a cost not to exceed $19,940.00.
Dated: October 7, 1998
I hereby certify that -the foregoing is a true and correct copy of Resolution No.
98-145, which was duly and regularly passed and adopted by the City Council of the City
of Lodi in a regular meeting held October 7, 1998 by the following vote:
AYES:
Council Members — Johnson, Land, Mann, Pennino and Sieglock
(Mayor)
NOES:
Council Members — None
ABSENT:
Council Members — None
ABSTAIN:
Council Members — None
ALICE M. RE MCHE
City Clerk
98-145
-� --ILAH1811 A
August 4, 1998
Implementation Plan
r'
1. Buy new PCs for Bob & Cory
Cost: $1500 x 2 =
$3000
• Move Bob's PC to Train02
• Move CON'S PC to TrainOI
• Add 16Mb memory to TrainOI
Cost:
5 140
• Add 16Mb memory to Train03
Cost:
$ 140
• Add 16Mb memory to Train04
Cost:
$ 140
• Add 16Mb memory to DP Training
Cost:
$ 140
2. Buy new PCs for Gail, Myrna, Kevin, and Tammie(3 w/Monitors)
Cost: $1400 x 4 =
$5600
• Add 16Mb memory to Gail's, Myrna's, & Kevin's PCs
Cost:
$ 420
• Move Gail's PC to Christine (use Memorex monitor)
• Move Kevin's PC to Melinda (use Memorex monitor)
• Move Myrna's PC to Merry (use Memorex monitor)
3. Buy a new PC for Sandy (w/Monitor)
Cost:
$1400
• Dispose of Sandy's PC
4. Buy new PCs for 1?gLn, Jamie, Ronnie, and Chris (2 w/Monitors)
Cost: $1400 x 4 =
$5600
l • Add 16 Mb memory to Pam's and Jamie's PCs
Cost: $140 x 2 =
5 280
• Add 16Mb memory to Maxine's old PC
Cost:
S 140
• Add 16Mb memory to Janette's PC
Cost:
S 140
• Move Pam's PC to Cash PT (W126 - use Chris' Memorex)
• Move Jamie's PC to Cash PT (C2 - use Irma's Memorex)
• Use 2 new Monitors for Chris and Irma
• Move Maxine's old PC to Customer desk 43 (W206 -Maxine's old monitor)
• Move TrainOl PC to Irma
5. Buy 2 new PCs for the Customer desks (new monitors) Cost: $1400 x 2 = $2800
6. Not included: Itron PC and Software - considered part of the Orcom System. Implementation -- 71 1
7. Not provided: could be "phase two": q
• No change at counter Windows - remains with (2) dumb terminals
• PC for Glenn (may be Laptop from Elec Util) C''S j g'� �! O 0
• No change at Kathy's workstation - workflow analysis bould determine need 1
• Nothing for PT cube (beside Kathy) - remains with a dumb terminal
• Nothing for PT cube behind Irma (Shirley's desk) - remains with a dumb terminal
• Neither Meter Reader stations changed - remains with (2) dumb terminals
3