Bibliographic citations
Neris, S., Luna, B. (2024). Optimización del Proceso de Compras y Stock de Almacén en una Empresa Mercantil a través del Desarrollo de una Macro VBA de MS Excel 365 [Trabajo de Suficiencia Profesional, Universidad Peruana de Ciencias Aplicadas (UPC)]. http://hdl.handle.net/10757/674452
Neris, S., Luna, B. Optimización del Proceso de Compras y Stock de Almacén en una Empresa Mercantil a través del Desarrollo de una Macro VBA de MS Excel 365 [Trabajo de Suficiencia Profesional]. PE: Universidad Peruana de Ciencias Aplicadas (UPC); 2024. http://hdl.handle.net/10757/674452
@misc{renati/419071,
title = "Optimización del Proceso de Compras y Stock de Almacén en una Empresa Mercantil a través del Desarrollo de una Macro VBA de MS Excel 365",
author = "Luna Rios, Brenda Nicole",
publisher = "Universidad Peruana de Ciencias Aplicadas (UPC)",
year = "2024"
}
The present work of professional sufficiency aims to identify the problematic situation presented by the trading company. This challenge will be addressed through an analysis of three alternative solutions, such as a Microsoft Excel 365 VBA macro, an ERP system and the Power BI tool, thus determining the most appropriate to help optimize the supply chain. The applied methodology was qualitative, where by means of in-depth interviews, it was possible to show the inconveniences that they present in the purchases and stock control, demanding time and damaging their main activity of sales, since this guarantees the achievement and prosperity of the company. Likewise, the SWOT analysis was used to evaluate the strengths, opportunities, address weaknesses and reduce threats. Also, in the ¿5 why? to find the root of the problem and to be able to solve them. On the other hand, in the information obtained through the background, the technological solution options are supported, which lead us to choose the alternative of developing a Microsoft Excel 365 VBA Macro for its main advantage of optimizing processes through the automation of tasks. Finally, after a comparative analysis using a benchmarking chart, the choice was confirmed, since its advantages and features meet the needs and adapt to the resources. This will help improve operational efficiency, increase sales and have a positive financial impact by migrating from manual processes to digitalization.
This item is licensed under a Creative Commons License