Sample

DLSU Engineering e-Journal Vol. 1 No. 1, March 2007, pp. 138-150

Automated Inventory System Using Portable Data Acquisition Module for Bell Electronics Corporation

Zarina Ira V. Bernabe Monchie C. Dela Cruz Karen K. Jao Department of Electronics and Communications Engineering De La Salle University, Manila email: ira.bernabe@yahoo.com, chie08_elx@yahoo.com,

karenjao@yahoo.com,

Jingel A. Tio, Antonio S. Gonzales Jr. Department of Electronics and Communications Engineering De La Salle University, Manila Email: tioj@dlsu.edu.ph, gonzalesa@dlsu.edu.ph

Bell Electronics Lab Corporation situated in Calamba, Laguna is engaged in test and assembly of optoelectronics and sensor devices. The company is concentrating on its resources in metal can packaging. The second phase of the company's program is towards the development of other types of optoelectronics and sensors device packaging to support their customer requirements. In this paper, the proponents will present an Automated Inventory System using Portable Data Acquisition (PDA) module to help the company’s growing business. The PDA module is composed of barcode scanner to scan issued and received items, and a Z8F6423 Zilog microcontroller to store the information. A Product Inventory System (PIS) application program is also discussed to show how the PDA module can be interfaced with the PIS. Test results presented in this paper will show apparent improvement of company’s inventory system.

1.0 INTRODUCTION Inventory system is an effective way for monitoring and tracking different materials that are transferred in and out of a company’s warehouse or establishment usually for accounting purposes. It is also important for a company to monitor all the transactions and

140

Bernabe, Dela Cruz, Jao, Tio and Gonzales

movement of goods in order to keep an account of all their stocks. However in some establishments, the inventory of materials is done manually in such a way that an employee writes down the...