HomeMy WebLinkAboutAgenda Report - September 16, 1992 (68)CITY OF LODI
AGENDA TITLE: AS/400 Computer Upgrade
MEETING DATE: September 16, 1992
PREPARED BY: Finance Director
RECOMMENDED ACTION: That the City Council authorize an upgrade to
the existing AS/400 Computer in Lodi City Hall
from a Model B45 to a Model E45 to provide the
necessary computer resource to allow for the
ongoing operations of computerized functions.
BACIGROUND INFORMATION: The AS/400 Computer was originally
purchased with a configuration known to
have limited growth potential, This was
done as a temporary cost saving measure
with the full knowledge of Management and City Council,
At the time of purchase, an upgrade of the AS/400 was expected when
the Police/Fire System was moved from the old System/36 to the
AS/400. It was the intention of all the involved parties that the
necessary upgrade would be determined when the Police/Fire system
was added.
The Police/Fire System is now on-line and operating efficiently
with the planned computer configuration. It is now necessary to
upgrade the AS/400 to allow for future growth as well as provide
the processing power currently needed.
The current disk capacity of the AS/400 is running at 75% to 85% of
the total capacity --or one occasion, we exceeded 90% capacity, and
the computer issued a very blunt warning to take action (reduce
disk content or risk failure). With the projected growth of the
Police/Fire System and the expected growth of financial and other
applications (including histories, etc.), the AS/400 must be
upgraded.
PROJECT WORK COMPLETED
The upgrade will be done by IBM under the direction of the Data
Processing Section. The task can be completed within thirty to
sixty days of placing the order with IBM.
APPROVED
THOMAS A PETERSON _ yriet daps
sm
AS/400 Computer Upgrade
September 16, 1992
Page Two
SCHEDULE AND PROJECT COSTS
Basic €45 Computer Upgrade
$33,725.00
E45
Software Upgrade
61639.00
E45
Controllers and Additions
12,965.00
Add
Tape Backup Cartridge
5,254.00
Add
Memory Upgrade
2,970.00
Add
Local Work Station Controller
1.640.00
Total
$63,193.00
Tax @ 7.75%
4.898.00
Total Cost
568.091.00
The total cost will be reduced by an expected recovery of $2,000.00
to $4,000.00 for the sale of our existing work station controllers.
The existing controllers must be replaced by E45 capable
controllers and will become expendable.
ALTERNATIVES
Revise the previous plan to store five years of records data for
the Police/Fire System and curtail plans to upgrade existing
software with the expected history and required storage space,
PROJECT EFFECT ON OPERATING BUDGET
No effect is expected on the Operating Budget as a result of the
upgrade. However, if the AS/400 were not upgraded, the cost of
maintaining the computer would increase. If disk storage were
allowed to become completely filled, management of the disk would
become a daily job.
FUNDING: Asset Seizure 50 percent
Utility Outlay Reserve 25 percent
Sewer Capital 16 2/3 percent
Water Capital 8 1/3 percent
H. D. F1 n
Y
Finance Director
HDF: RT: ss
Attachment
Prepared by Roy Todd, Data Processing Manager
M E M O R A N D U M
TO: Finance Director
FROM: Assistant City Manager
DATE: August 31, 1992
SUBJ: Funding of Computer Upgrade
The funding for the computer upgrade should be as follows:
Asset Seizure 50%
Utility Outlay Reserve 25%
Sewer Capital 16 2139
Water Capital 8 1/3V
?erry L. Glenn
Assistant City Manager
JLG hr
CCCOM591/TXTA.07A
Exhibit A
SEP 2 1992
4
CITY OF LODI
SPECIAL ALLOCATION REQUEST
J
To: Finance Director DATE: September 16, 1992
FROM: City Clerk PRO:,ECT NUMBER: /0 - �- - oSo • o6 -,goo
Request is made for funds to accomplish the following project which was not
included in the current budget:
Description of Proiect Estimated Cost
Allocation of funds for upgrade to the existing AS/400 Computer in Lodi
City Hall from a Model B4S to a Model E45 to provide the necessary computer
resource to allow for the ongoing operations of computerized functions
$68,091.00
Funding: Asset Seizure 50V, Utility Outlay Reserve 25%, Sewer Capital
16 2/3ir and Water Capital 8 1/39
(If you need more space, use additional sheet and attach to this form)
Date of Approval - September 16, 1992 Amount Approved - $68,091.00
Council XXXXX
City Manager
FUND OR ACCOUNT TO BE CHARGED
Current Budget S Prior Year Reserve $
contingent Fund $_
General Fund Surplus $
Capital Outlay Reserve $ Gas Tax Fund $
Utility Outlay Reserve S Other (Election)S
Hotel/Motel Tax Reserve - $
General Fun Operating Reserve $
Z Dixon Flynn, Alice M. Reimche
Finance Director City Clerk
Submit this form in duplicate to the Finance Director. Distribution after
approval will be as follows: 1) Originating Department 2) Finance
Department