Ingeniería en Sistemas, Electrónica e Industrial

URI permanente para esta comunidadhttp://repositorio.uta.edu.ec/handle/123456789/1

Examinar

Resultados de la búsqueda

Mostrando 1 - 10 de 15

Gestión avanzada de inventarios de productos terminados mediante Business Intelligence con power BI en la microempresa productos lácteos Marlen
(Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas Electrónica e Industrial. Carrera de Ingeniería Industrial., 2026-07-01)
Vargas Salinas, Edwin Francesco
;
Aldas Salazar, Darwin Santiago
;
Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas Electrónica e Industrial. Carrera de Ingeniería Industrial.
This degree project was developed with the purpose of designing an advanced inventory management model for finished products through the use of Business Intelligence tools in Power BI, applied to the microenterprise Productos Lácteos Marlen. The research began with an analysis of the current inventory management process, which revealed weaknesses in the manual recording of product inflows and outflows, limited traceability of information, and the absence of indicators to support operational decision-making. In addition, the ABC classification was applied to identify the products with the highest relevance for inventory control. To build the proposed model, the inventory data were first structured in Excel and then processed in Power Query to clean, organize, and standardize the information. After this stage, the data were connected to Power BI through a relational model that allowed the calculation of inventory control parameters using DAX formulas. These parameters included minimum stock, safety stock, reorder point, and maximum stock. Likewise, performance indicators were defined to evaluate inventory level, stock duration, turnover, the relationship between outputs and inputs, and compliance with established control parameters. The developed control panels allowed a clearer interpretation of inventory behavior by showing the condition of each product according to its availability level. This made it possible to distinguish products that required immediate attention, timely replenishment, regular monitoring, or adjustments due to excess stock. Based on these results, operational actions were proposed to support production planning, replenishment, and dispatch activities. Therefore, the proposed model contributes to improving inventory control, reducing dependence on empirical decisions, and promoting a more organized, preventive, and data-oriented management system.
Modelo de gestión de inventarios en la empresa Importadora Paredes
(Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas Electrónica e Industrial. Carrera de Ingeniería Industrial., 2026-06-29)
Miranda Villafuerte, Esteban Paul
;
Ortiz Guerrero, Daysi Margarita
;
Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas Electrónica e Industrial. Carrera de Ingeniería Industrial.
This document details the development of an inventory management model for the company “Importadora Paredes,” in which the current state of the logistics department was assessed through data collection using process forms, which evaluated the company’s operational activities and identified various opportunities for improvement, such as decision-making based on empirical knowledge, poor control of physical and digital inventory, the absence of ordering and replenishment parameters, disorganization of products, and a lack of performance indicators hindering the control of items in the company’s portfolio. The identified problems were considered to develop a model tailored to the company’s needs. For this reason, the company’s inventory was classified using the multi-criteria ABC methodology, considering the economic impact and operational effort associated with each SKU, which allowed for the establishment of priorities to categorize the inventory technically into five different priority levels. Subsequently, the demand behavior of all items was analyzed to select the forecasting method that most accurately aligns with actual demand. Based on the results, technical parameters and indicators for inventory control were established. Additionally, a proposal for warehouse reorganization was developed, considering the priority.
Gestión de inventarios a través de un modelo de optimización en la Industria Carrocera Varma S.A.
(Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas Electrónica e Industrial. Carrera de Ingeniería Industrial., 2026-01)
Alvarado Mayorga, Eddy Alexander
;
Aldás Salazar, Darwin Santiago
;
Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas Electrónica e Industrial. Carrera de Ingeniería Industrial.
This research project analyzed inventory management at VARMA S.A., a company dedicated to manufacturing vehicle bodies, with the aim of optimizing the management of materials used in the production of the Urbano City Bus model. To achieve this objective, a mixed methodological approach combining qualitative and quantitative methods was adopted. As a first step in the research, the current process of procurement and management of supplies was analyzed, identifying limitations related to the lack of formal policies, absence of defined replenishment levels, and inconsistent records. Subsequently, the factors that influence inventory management were evaluated, such as production capacity, labor, machinery, and storage space. To evaluate critical materials, an ABC analysis was applied, from which ten representative materials were selected. Based on these materials, a mathematical model based on the (Q, r) policy was implemented and integrated into Python, which allowed for the accurate calculation of the economic order quantity, safety stock, reorder point, and average investment. The multi-item EOQ model optimizes costs, takes advantage of available warehouse space, and therefore reduces the total cost of inventory. The total cost of inventory obtained by the model was USD 1,231.84, while the volume occupied (20.27 m³) was within the available capacity and average investment. In conclusion, the proposed model is an effective tool for improving inventory planning and strengthening operational continuity.
Sistema de gestión de inventarios en la empresa Bull´s Jean de la ciudad de Pelileo
(2026-01)
Martínez Hidalgo Jean Pierre
;
Rosero Mantilla César Aníbal
The objective of this research project was to propose the implementation of an inventory management system at Bull's Jean, a clothing manufacturer located in the city of Pelileo. Based on an assessment of the current situation, using methodological tools such as SWOT analysis, time studies, and Ishikawa diagrams, among others, it was determined that no technical criteria are applied in the company's inventory-related processes. Instead, these processes are carried out empirically, resulting in inadequate product classification and high costs. It was established that technical criteria are not applied in its inventory-related processes; on the contrary, these are executed empirically, which results in inadequate classification of its products, high storage costs, and a lack of control over the units stored in the warehouse. Faced with this problem, the proposal for the new system had three phases: first, an ABC classification of products was developed in order to identify which ones are most important economically for the organization. The second phase consisted of reducing the costs associated with preparation and storage by applying the POQ model to category A products, which are the most essential. Categories B and C were not considered, as the effort involved in conducting a detailed analysis for them could be time-consuming and more costly than the benefit. The final savings for the organization after applying the model were $7708,53 per year, demonstrating the efficiency of the methodology. Finally, the third phase complemented the entire system by developing an automated program in Microsoft Excel for the proper control of its products, adapting to the company's requirements with versatility and intuitiveness.
Diseño de un plan de gestión para manejo y disposición final de residuos sólidos generados en parques, plazas y plazoletas del cantón Baños
(Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas Electrónica e Industrial. Carrera de Tecnologías de la Información., 2026-01)
Jiménez López, David Sebastián
;
Naranjo Avalos, Hernán Fabricio
;
Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas Electrónica e Industrial. Carrera de Tecnologías de la Información.
Healthcare systems require effective management of medical supplies, as this ensures availability, minimizes waste, and improves care times. In the field of veterinary medicine, this management is even more necessary due to the variety of supplies to be managed and the need to control stock and expiration dates. At the Veterinary Teaching Hospital of the Technical University of Ambato (HDV-UTA), supplies were managed manually. This led to inconsistencies in records, the risk of supplies expiring, a lack of traceability in records, and time spent recording and controlling supplies. In response to this situation, a technological tool was implemented that reduces operation times and improves the accuracy of the data managed. In this project, a web application was developed to digitize and automate the management of veterinary medical supplies. This project was carried out using the hybrid agile methodology of Scrum and Extreme Programming (XP) to enable continuous validation with staff. The system was developed in Blazor WebAssembly and ASP.NET Core 9 with SQL Server 2022 as the database management system. The solution integrated modules for recording supplies and batches, managing incoming and outgoing movements, real-time alerts, reports, and dashboards. Its implementation reduced the time required to enter and control supplies; the process took an average of 180 minutes and now takes a maximum of 5 minutes.
Aplicación web para la gestión de insumos médicos en el Hospital Docente Veterinario de la Universidad Técnica de Ambato (HDV-UTA)
(Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas Electrónica e Industrial. Carrera de Tecnologías de la Información., 2026-01)
Gaona Barreno, Paulina Andreina
;
Naranjo Avalos, Hernán Fabricio
;
Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas Electrónica e Industrial. Carrera de Tecnologías de la Información.
Healthcare systems require effective management of medical supplies, as this ensures availability, minimizes waste, and improves care times. In the field of veterinary medicine, this management is even more necessary due to the variety of supplies to be managed and the need to control stock and expiration dates. At the Veterinary Teaching Hospital of the Technical University of Ambato (HDV-UTA), supplies were managed manually. This led to inconsistencies in records, the risk of supplies expiring, a lack of traceability in records, and time spent recording and controlling supplies. In response to this situation, a technological tool was implemented that reduces operation times and improves the accuracy of the data managed. In this project, a web application was developed to digitize and automate the management of veterinary medical supplies. This project was carried out using the hybrid agile methodology of Scrum and Extreme Programming (XP) to enable continuous validation with staff. The system was developed in Blazor WebAssembly and ASP.NET Core 9 with SQL Server 2022 as the database management system. The solution integrated modules for recording supplies and batches, managing incoming and outgoing movements, real-time alerts, reports, and dashboards. Its implementation reduced the time required to enter and control supplies; the process took an average of 180 minutes and now takes a maximum of 5 minutes.
Sistema informático aplicando python para la gestión de productos con series de tiempo en la panadería y pastelería “Flor de Cebada"
(2025-02)
Freire Valencia Jean Carlo
;
Aldas Flores Clay Fernando
;
Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas, Electrónica e Industrial. Carrera de Tecnologías de la Información
The present project focuses on the development of a software system aimed at improving product management processes in the bakery and pastry shop "Flor de Cebada." Leveraging Python, the Flask framework for the backend, and React for the frontend, alongside the application of machine learning, the system integrates time series forecasting to enhance trend detection and demand prediction. The goal is to optimize sales operations, minimize product waste, and support data-driven decision-making in a small business environment. The system includes an inventory management mechanism, enabling the registration, updating, and tracking of products, including essential details such as quantities, expiration dates, and prices. Additionally, sales processes are streamlined through barcode scanning, automatic calculations, and totals. A key feature is the generation of reports required by the business. The predictive analysis implemented in the system development provides accurate demand forecasts, helping align production with market needs. The system also generates electronic receipts for transactions, improving operational efficiency and user experience. The project was developed using the Extreme Programming methodology, emphasizing iterative design, stakeholder collaboration, and adaptability to changing requirements. The system delivers tangible benefits for business operations, enabling the bakery to achieve greater accuracy in inventory planning, enhance customer satisfaction, and establish a foundation for sustainable growth. This initiative highlights the potential of technology-driven solutions to address real-world challenges faced by small and medium-sized enterprises
Gestión de inventarios en la empresa distribuidora de confitería y productos de consumo masivo “Dulceza”
(Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas, Electrónica e Industrial. Carrera de Ingeniería Industrial, 2024-02)
Pérez Cando, Alex Paul
;
Ortiz Sailema, Christian Ismael
The following document outlines the development of an inventory management model for the company "Dulceza," where the current situation of the logistics area was identified through the use of interviews based on a specialized methodology called IPISI. Various parameters of the company were evaluated, identifying several areas for improvement, including limited storage capacity, lack of action in inventory management, and the absence of established policies and standards to aid in replenishment decision-making. Lastly, the absence of documented manuals detailing the activities and controls necessary for management was noted. All of this was taken into account to develop a model tailored to their needs. The company's inventory was classified using an analytical hierarchical model, considering the criteria of individuals involved in inventory management, allowing for the establishment of robust hierarchies agreed upon by all parties involved. This facilitated adequate stratification to focus measures on products deemed most relevant or in category A. The demand behavior of these items was analyzed to establish a management model based on fixed review periods. Despite a 43.44% increase in demand during the studied period, inventory acquisition costs increased by only 1.02%. This minimal increase is due to higher-cost items experiencing decreased demand, while lower-cost items see increased demand according to forecasts.
Gestión de inventarios en la empresa Sueldas del Valle
(Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas, Electrónica e Industrial. Carrera de Ingeniería Industrial, 2024-02)
Vega Ilaquiche, Ana Lucía
;
Guachimbosa Villalba, Víctor Hugo
The primary purpose of this project is to conduct a thorough study on the effective inventory management at Sueldas del Valle, a company specializing in the distribution of hardware products with two warehouses and a main storage facility in the cities of Ambato and Latacunga. The main issue is the lack of effective inventory management in the company, as it lacks precise information about product quantities in stock, procurement needs, and the presence of obsolete items. This leads to problems such as product shortages resulting in customer loss. Additionally, an excess of inventory for certain items is observed, increasing storage costs and the risk of obsolescence. For the research, direct observation was employed to determine the initial situation of the company using the IPISI methodology (Infrastructure, Processes, Inventories, Safety and Health, Indicators). An unstructured interview was conducted, revealing deficiencies in all areas, with a particular focus on the inventory phase. Also, the ABC analysis was conducted to identify products that generate the most utility for the company and the best-selling products over the course of a year. For research purposes, sales data from the year 2022 were utilized to perform calculations for optimal inventory management. These calculations include order quantity, number of orders, and safety stock for the 558 products owned by the company. Additionally, logistics and aging indicators were proposed to ensure proper inventory management, preventing stockouts or obsolete products and improving the supply chain. Finally, the activities of each company process are detailed, and improvements in the infrastructure and safety phase are proposed. Relevant regulations related to the design and maintenance of flooring, loading and unloading docks, installation safety, and worker safety were consulted for this purpose.
Gestión de inventarios para la optimización de recursos en una empresa comercializadora de material eléctrico
(Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas, Electrónica e Industrial. Maestría en Producción y Operaciones Industriales, 2023)
Galarza Chacón, Carlos Alberto
;
López Arboleda, Jéssica Paola
En el presente trabajo de investigación se estableció un sistema de gestión de inventarios basado en políticas de revisión de existencias para la empresa MATELEC ELECTRICIDAD S. A. para lo cual, mediante fichas de observación se identificaron las falencias que conllevan a un incorrecto manejo del inventario, siendo los factores más críticos: la falta de personal encargado de la gestión de bodegas, lo cual genera deficiencias en el manejo de los inventarios y la inexistencia de un modelo de gestión, además se levantaron los procesos de compra, almacenamiento y venta a clientes, donde se evidenció la falta de asignación de roles y responsabilidades dentro de cada puesto de trabajo, en base a esto se planteó el uso de la política de revisión periódica con demanda variable, manteniendo el periodo de reabastecimiento manejado por la empresa y proveedores y se aplicó a 55 familias de productos, las mismas que contaban con un historial de ventas de 3 años, como punto de partida, mediante un análisis ABC se determinó que 8 familias de productos que generan el 80,22% de la rentabilidad de la empresa, de estos productos se analizó la normalidad de los datos de un histórico de ventas de un periodo de 36 meses, mediante la prueba gráfica de Ryan-Joiner en el software Minitab se determinó que los datos de ventas se ajustan a una distribución normal con un p-valor >0,1. Comprobada la normalidad de la información se estableció la política de revisión con la cual se logró un ahorro de $ 813,72 anuales en la mantención del inventario de ciclo y de seguridad a comparación con el método actual. Se definieron los indicadores logísticos de gestión de inventarios, donde se muestra la rotación del inventario, el valor económico y el nivel de servicio, con el fin de no generar un exceso de stock en bodega con un nivel de servicio propuesto del 95%. En cuanto a los proveedores, se tuvo un total de 13, de los cuales todos superan la calificación de 6/10 y serán considerados para suministrar a la empresa. Se establecieron los procesos de revisión de stock, generación de orden de compra y almacenamiento, definiendo los responsables de cada actividad, para la gestión de bodega se propone la aplicación de las 5 “S” para el orden y mantenimiento de bodega según una distribución lógica de los artículos tras conocer las familias de clase A, B y C y su rotación.

Ingeniería en Sistemas, Electrónica e Industrial

Examinar

Filtros

Ajustes

Ordenar por

resultados por página

Resultados de la búsqueda