Improvement in Inventory and Production Optimization: Prospectiveness and 'Material Coverage' Methodology Integrating Information Technologies
DOI:
https://doi.org/10.29105/mdi.v13i22.351Keywords:
Material Control, Power BI, Production Control, Line Stoppage, Inventory Optimization, Information Technologies, ManufacturingAbstract
This research addresses the critical challenge faced by the Production Control area of a manufacturing plant, where the lack of daily visibility regarding coverage of manufactured and purchased materials caused recurrent line stoppages and shipment delays. The objective was to implement the 'Material Coverage' methodology to solve this operational problem and optimize inventories. The investigation used a systematic and structured approach, combining qualitative methods and quantitative techniques to quantify historical material information and analyze operational stoppages over a three-month period. The methodology was based on the use of Information Technologies (IT), linking Excel databases (automatically fed via macros/Visual Basic using the Daily Production Report) to the data analysis software Power BI. This system was designed to generate a 30-day inventory forecast at the simple part level. The results showed that the new methodology was functional and effective, achieving an evident reduction in the impact on production metrics and preventing abrupt line suspension. The initial hypothesis was accepted, concluding that the implementation of this automated control system optimizes resource management and is potentially replicable. However, it was noted that some aspects of control still require manual intervention.
References
Bolaños Carbajal, A. B. (s.f.). Mejora en el control de los materiales manufacturados y comprados para evitar un paro de línea de producción haciendo uso de Power BI [Tesis de Ingeniero en Mecatrónica]. Universidad Autónoma de Nuevo León, Facultad de Ingeniería Mecánica y Eléctrica.
Chiu, W. K., & Wetherill, G. B. (1975). Quality control practices. International Journal of Production Research, 13(2), 175-182.
Deming, W. E. (1989). Calidad, productividad y competitividad. La salida de la crisis. Díaz de Santos.
Hall, B., & Fletcher, K. (1990). Quality assurance. Batiment International, Building Research and Practice, 18(1), 61-64.
K. Palm, J. L. (2014). The challenge of integrating innovation and quality management practice. Total Quality Management & Business Excellence.
Kosturiak, J., & Gregor, M. (1995). Total production control. Production Planning & Control, 6(5), 490-499.
M.-S. HAN, J.-T. L.-J. (16 de Mayo de 1998). Performance analysis of serial production lines with quality. International Journal of Systems Science, 29(8), 939-951.
MK, O., & SC, T. (2007). Planificación y programación jerárquica de la producción en un entorno de proceso por lotes y. Revista internacional de investigación de producción.
Monden, Y. (1998). Toyota production system (3rd ed.). Engineering & Management Press.
Okamura, K., & Yamashina, H. (1979). Optimization of a mixed-model assembly line using a branch-and-bound technique. International Journal of Production Research, 17(5), 503-512.
Palm, K., Lilja, J., & Wiklund, H. (2014). The challenge of integrating innovation and quality management practice. Total Quality Management & Business Excellence.
Sampieri, R. H. (2016). Metodología de la Investigación. McGraw Hill.
Simchi-Levi, D. (2008). Designing and managing the supply chain: concepts, strategies, and case (3rd ed.). McGraw-Hill Irwin.
Tamura, T., Okumura, T., Dhakar, T. S., & Ohno, K. (2011). Optimal production sequencing problem to minimise line stoppage time in a mixed-model assembly line. International Journal of Production Research, 49(14), 4299-4315.
Tarig, E. (1979). The effect of inequality of interstage buffer capacities and operation time variability on the efficiency of production line systems. International Journal of Production Research, 17(1), 77-89.
Tsai, K. H. (1995). An optimal sequence for a mixed-model assembly line. International Journal of Production Research, 33(7), 1885-1896.
Xiaobo, Z., & Ohno, K. (1994). A heuristic approach to solve the mixed-model assembly line sequencing problem. Computers & Industrial Engineering, 26(4), 743-752.
Xiaobo, Z., & Ohno, K. (1997). Optimal production sequence for a mixed-model assembly line. European Journal of Operational Research, 96(3), 441-450.
Xiaobo, Z., & Ohno, K. (2000). A mixed-integer programming model for the mixed-model assembly line sequencing problem. International Journal of Production Research, 38(10), 2245-2258.
Yang, C.-C. (2006). Establishment of a Quality-Management System for Service Industries. Total Quality Management & Business, 17(9), 1129-1154.
Downloads
Published
How to Cite
Issue
Section
License
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
