Ochoa Guerra, Jairo DanielOsorio Barrera, Jesús CamiloNoriega Molina, Laura Camila2022-03-032022-03-032022-03-03https://repositorio.unicordoba.edu.co/handle/ucordoba/4880This project is derived from the business practice that was carried out under the position of industrial engineering intern, more precisely in the maintenance area, providing support in the inventory management of the Arrocera Formosa spare parts and materials warehouse. The company has a way to store and buy, but they do not implement a specific inventory management system, since they decide when and how much to order according to what the stockist considers necessary. For Arrocera Formosa SAS it is important to achieve a restructuring in the spare parts and materials warehouse, which is a fundamental part of maintenance management, this process always requires answers, in addition to being tied to a significant amount of financial resources that merit adequate administration. thereof. In favor of improving the area, an inventory management system was developed under the EOQ model, where an economic order quantity, reorder point and a safety inventory for the items with the highest turnover are established, determined with the data . An Excel application was created to record the entries and exits of the articles; likewise, a user manual was prepared to understand it.1 INTRODUCCIÓN ..................................................................................................................... 82 PLATAFORMA ESTRATÉGICA DE LA EMPRESA ....................................................... 102.1 Misión ............................................................................................................................... 102.2 Visión ................................................................................................................................ 102.3 Política empresarial......................................................................................................... 103 MARCO TEÓRICO ............................................................................................................... 113.1 Gestión de inventarios ..................................................................................................... 113.1.1 Inventario para mantenimiento y gestión de operaciones ................................... 113.1.2 Política de inventario: ............................................................................................. 113.2 Método ABC gestión de inventarios: ............................................................................. 113.3 Sistemas de modelos de inventarios: .............................................................................. 123.3.1 Sistema de revisión continúa: ................................................................................. 133.3.2 Sistema de revisión periódica: ................................................................................ 133.3.3 Cantidad económica de pedido (EOQ): ................................................................. 133.3.4 Inventario de seguridad: ......................................................................................... 143.3.5 Punto de re orden: ................................................................................................... 153.4 Costos asociados a la gestión de inventarios ................................................................. 153.4.1 Costos de almacenamiento ...................................................................................... 153.5 Costo de hacer un pedido: .............................................................................................. 164 DESCRIPCIÓN DEL ÁREA DE TRABAJO ....................................................................... 175 DIAGNOSTICO ...................................................................................................................... 186 OBJETIVOS ............................................................................................................................ 206.1 Objetivo general .............................................................................................................. 206.2 Objetivos específicos ....................................................................................................... 207 ACTIVIDADES PROGRAMADAS ...................................................................................... 218 ACTIVIDADES DESARROLLADAS .................................................................................. 248.1 Diagnóstico del manejo actual del sistema de inventarios ........................................... 248.2 Definición del sistema de inventarios a utilizar ............................................................ 298.2.1 Método ABC ............................................................................................................ 298.2.2 Política de inventarios ............................................................................................. 338.3 Diseño de un aplicativo para la gestión del inventario ................................................. 548.4 Manuales de usuario ....................................................................................................... 638.4.1 Manual de usuario para la Macro Excel ............................................................... 638.4.2 Manual de instrucciones para la gestión de inventarios ...................................... 639 PROPUESTAS DE MEJORAMIENTO ............................................................................... 6510 APORTES DEL ESTUDIANTE ............................................................................................ 6611 CONCLUSIONES ................................................................................................................... 6712 RECOMENDACIONES ......................................................................................................... 6913 BIBLIOGRAFÍA ..................................................................................................................... 7114 ANEXOS .................................................................................................................................. 76application/pdfspaCopyright Universidad de Córdoba, 2022Implementación de un sistema de gestión de inventarios utilizando macros en Excel para el almacén de repuestos de Arrocera Formosa S.A.S. en reestructuraciónTrabajo de grado - Pregradoinfo:eu-repo/semantics/openAccessAtribución-NoComercial-SinDerivadas 4.0 Internacional (CC BY-NC-ND 4.0)AlmacénAplicativoCantidad económica de pedidoCosto de almacenamientoCosto de hacer un pedidoGestión de inventariosMetodología ABCModelo EOQWarehouseApplicationEconomic order quantityHolding costsCosts of plating orderInventory managementAbc methodologyEOQ model