Elaboración e implementación de un sistema automatizado de gestión de inventarios y accesos del personal en las bodegas de almacenamiento de la empresa Vilema Imev en el cantón Guano.

Abstract

This work describes the process for the elaboration and implementation of an automated inventory and access management system in the storage warehouses in Vilema’s Metallic Industries. For the case study, there were eight cellars and taking into account a future expansion of two additional warehouses for the system’s design. We developed a software application mounted on a Raspberry PI3 with a user-friendly graphic interface on the Java free access platform linked to the SQL Server database management. For the design of the database, the relationship entity model was used where for the management of the inventory in the warehouses and access to them, the machinery, raw material, tools were codified and also to each company’s workers. The Netbeans application was used for the generation of a bar identifier printed on adhesive and magnetic cards. With a Honeywell reader, linked to the computer application, by means of serial communication, bar codes are read for the worker's attendance record and the access control to the warehouses, as well as to keep track of the input and machinery traffic in the working day. With the implementation of the system, it was possible to obtain better control of inventory management in the merchandise traffic for its supply and routine maintenance, optimal control of workers' registration at the entrance and exit of the company, as well as the areas of storage. The implementation of the system on the human element had a level of acceptance according to the Kuder-Richard method with a 0.86 reliability actor that is acceptable for the applied, obtaining the excellent administration of resources optimizing the production and time with the review of reports that exports the system.