IS226 Systems Analysis and Design
Project Case Study 3
Stock Management System
Pacifica Computer Solutions (PCS) is in the business of selling complete
... [Show More] computer
systems (desktop PC) at much reasonable prices compared to their competitors. First PCS
purchases computer parts from various local and overseas suppliers. The technicians at
PCS then use these parts to assemble computer systems. In addition to selling the
assembled computer systems to its customers, PCS also sells the computer parts as well.
Currently there is no computerized information system and all records of company
transaction and stock list of parts are kept manually. The inefficiency in the manual
system is creating a lot of problems for PCS. In particular the list of parts at hand does
not get updated promptly whenever parts are sold to customers. Thus if supply of a part
runs low there is no early warning system and in the worst case if the supply of any part
runs out it is impossible to assemble the computer system.
The manager of PCS has approached InfoTech, an information system development firm
where you are employed as a systems analyst. PCS wishes to acquire an information
system to computerize its operations. During interview the manager describes the current
operations of PCS as well as the features he would like to see in the new system. The
following outlines results of the interview.
All items (parts or computer systems) sold by PCS come with one year warranty.
Customers can buy items only on cash. At the counter the salesperson enters the
following details about new customers for warranty purposes: customer ID, customer
name, phone number, postal address. For the items sold the salesperson records the
following for each item: Item number and quantity sold. The proposed system should
print invoice which provides the customer details, item details (Item number, name,
description, quantity sold, and unit price), date of sale and total amount payable by the
customer. After the sale is finalized the system should update the quantity of each item at
hand. [Show Less]