A Computer‐based Inventory Management System for Spare Parts

Describes the design and analysis of a computer‐based information system for inventory management in a computer service company and identifies the requirements of the users and the components of the system.

Abstract

Describes the design and analysis of a computer‐based information system for inventory management in a computer service company. Studies the existing manual system for possible adaptation and necessary modifications and identifies the requirements of the users and the components of the system. To facilitate control, the parts are classified into four categories. Various quantitative models for demand forecast, economic order quantity, and safety stock are considered, and for each part type, an appropriate set of models is used depending on the relative importance of its category. The information system so designed is implemented in a modular form. The database for this application is implemented in dBASE III PLUS while the control programs are written in CLIPPER tools. Extensive user interface is provided for user‐friendliness.