Diseño de un sistema de control de inventario para joyería “Su Joya” de Samborondón, Ecuador
Archivos
Fecha
2020
Título de la revista
ISSN de la revista
Título del volumen
Editor
Universidad de Guayaquil Facultad de Ciencias Administración
Resumen
Joyería “Su Joya” presenta dificultades en el control y administración de todos sus tipos de inventario.
Se desarrollaron guías de observación para identificar los procesos y procedimientos que se siguen con
el manejo del inventario y una entrevista con el representante del negocio para identificar mejor los
efectos que tiene sobre la rentabilidad del negocio. Dentro de los procesos se identificó los puntos
clave que carecen de control. Se propone un sistema de control para el inventario basado en el
programa MS Excel, la utilización de códigos de barra y la nube digital de MS OneDrive. El sistema
utiliza plantillas de Excel para el control de las ordenes de trabajo que van al taller y varios formatos
para el control del inventario en la joyería. Estos formatos deben ser ingresados a Excel de manera
diaria y el inventario de la mercancía en exhibición debe ser realizado cada semana. La propuesta
presenta una rentabilidad de 52%, un VAN $6330 y se recuperaría la inversión en 1 año con 8 meses.
Jewelry store "Su Joya" presents difficulties in the control and management of all types of its inventory. Observation guides were developed to identify the processes and procedures related with its inventory management and an interview with the business representative was used to identify the effects it has on the profitability of the business. Within the processes, the key points that lack control were identified. An inventory control system based on the MS Excel program, the use of barcodes and the digital cloud of MS OneDrive is proposed. The system uses Excel templates for the control of work orders that go to the workshop and various formats for inventory control in jewelry. These formats must be entered into Excel on a daily basis and the inventory of the merchandise for sale must be carried out every week. The proposal presents a return of 52%, a NPV of $ 6330 and the investment would be recovered in 1 year with 8 months.
Jewelry store "Su Joya" presents difficulties in the control and management of all types of its inventory. Observation guides were developed to identify the processes and procedures related with its inventory management and an interview with the business representative was used to identify the effects it has on the profitability of the business. Within the processes, the key points that lack control were identified. An inventory control system based on the MS Excel program, the use of barcodes and the digital cloud of MS OneDrive is proposed. The system uses Excel templates for the control of work orders that go to the workshop and various formats for inventory control in jewelry. These formats must be entered into Excel on a daily basis and the inventory of the merchandise for sale must be carried out every week. The proposal presents a return of 52%, a NPV of $ 6330 and the investment would be recovered in 1 year with 8 months.
Descripción
Palabras clave
CONTROL DE INVENTARIO, SISTEMA, MERCANCÍA