OPERASI BERKELANJUTAN BERBASIS NILAI YANG DIDORONG OLEH ALAT OTOMATISASI DIGITAL TERINTEGRASI DAN ANALITIK DATA

Jerry Tirta; Akbar Adhi Utama

doi:10.31539/kn2fyx74

Authors

Jerry Tirta Institut Teknologi Bandung
Akbar Adhi Utama Institut Teknologi Bandung

DOI:

https://doi.org/10.31539/kn2fyx74

Keywords:

Current Reality Tree; Analytical Hierarchy Process; Statistical Process Control; Automation; Visual Basic For Application

Abstract

Di era yang berpusat pada pelanggan ini dan sebagai perusahaan kimia, proses yang stabil dan kualitas produk yang konsisten menjadi penting dan perlu dipastikan untuk kepuasan pelanggan. Jaminan kualitas adalah pintu gerbang di mana pelanggan dapat terhubung dan merasa puas bahkan mendapatkan pengalaman terbaik. Pada saat yang sama, keunggulan kompetitif dibandingkan pesaing dapat diperoleh dengan peningkatan dan pengurangan aktifitas yang tidak menambah nilai. Dengan mempertimbangkan berbagai hambatan yang muncul dalam peningkatan kinerja perusahaan, banyaknya pemborosan, meningkatnya keluhan pelanggan, dan tingkat ketidaksesuaian spesifikasi, yang berdampak negatif pada profitabilitas perusahaan, penelitian ini berfokus pada studi pengurangan pemborosan, memahami kontribusi sistem yang dipilih, dan mengeksplorasi pengembangan perangkat lunak aplikasi sebagai bagian dari sistem yang hemat biaya. Metode campuran antara kualitatif dan kuantitatif digunakan dalam penelitian ini dan Six Sigma DMAIC digunakan sebagai metodologi penelitian. CRT dilakukan untuk menemukan akar permasalahan. Dasbor SPC otomatis untuk pengendalian mutu sebagai solusi terbaik di antara tiga solusi alternatif diidentifikasi menggunakan Proses Hirarki Analitik. Dengan menerapkan "dasbor SPC otomatis", yang dikembangkan dengan menggabungkan otomatisasi dengan inisiatif Pengendalian Proses Statistik menggunakan Visual Basic for Application, pengurangan pemborosan yang signifikan dapat dicapai. Hal ini memicu pengurangan biaya dan memberikan kontribusi positif pada profitabilitas perusahaan.

References

Abugabah, A., & Sanzogni, L. (2010). Enterprise resource planning (ERP) system in higher education: A literature review and implications. International Journal of Social, Behavioral, Educational, Economic, Business and Industrial Engineering, 5, 2120-2124. https://www.waset.org/journal/Social

Alessandro, A., & Sepadyati, N. (2019). Perancangan Dashboard SPC Excel Sebagai Alat Analisis Kinerja Mesin Filling Pada PT SMART Tbk. Jurnal Titra, 7(2), 161-166.

Angelovska, N. (2021). UNDERSTANDING CUSTOMER COMPLAINT BEHAVIOR FOR EFFECTIVE RESOLUTION. UTMS Journal of Economics, 12(1).

Antony, J., Gupta, S., Sunder, M. V., & Gijo, E. V. (2018). Ten commandments of Lean Six Sigma: A practitioner’s perspective. International Journal of Productivity and Performance Management, 67(6), 1033-1044. https://doi.org/10.1108/IJPPM-072017-0170

Arora, S. D., & Chakraborty, A. (2021). Consumer complaining behavior: a paradigmatic review. Philosophy of Management, 20(2), 113-134.

Arora, S. D., & Chakraborty, A. (2021). Intellectual structure of consumer complaining behavior (CCB) research: A bibliometric analysis. Journal of business research, 122, 60-74.

Arora, S. D., & Chakraborty, A. (2020). Legitimate and illegitimate consumer complaining behavior: a review and taxonomy. Journal of Services Marketing. Arora, S. D., & Chakraborty, A. (2021).

Awaj, Y. M., Singh, A. P., & Amedie, W. Y. (2013). QUALITY IMPROVEMENT USING STATISTICAL PROCESS CONTROL TOOLS IN GLASS BOTTLES MANUFACTURING COMPANY. International journal for quality research, 7(1).

Azzahra, A., Rohaeti, E. E., & Nurjaman, A. (2024). Media Visual Basic for Application (VBA) Excel dalam meningkatkan kemampuan penalaran dan keaktifan belajar melalui penerapan model problem based learning. JPMI (Jurnal Pembelajaran Matematika Inovatif), 7(4), 665-674.

Bahar, I. (2019). PENENTUAN SOLID CONTENT PADA PRODUK DISPERSI. SAINTI: Majalah Ilmiah Teknologi Industri, 16 (2), 89-95

Balakrishnan, J. and Oh, Sherry L. (Published on May 01, 2005). An Interactive VBA Tool for Teaching Statistical Process Control (SPC) and Process Management Issues

Bernard, M., & Senjayawati, E. (2019). Developing the students’ Ability in understanding mathematics and self-confidence with VBA for excel. JRAMathEdu (Journal of Research and Advances in Mathematics Education), 4(1), 45–56. https://doi.org/10.23917/jramathedu.v4i1.6349

Bissell, A.F. (1990). How Reliable is your capability index. Published in the Journal of the Royal Statistical Society Series C.

Boyer, D. (2001). ERP implementation; Managing the final preparation and go-live stages. Government Finance Review, 17(6), 41-44.

Beady, S. (2005). “War on waste”: a Study of the application of six sigma DMAIC process improvement methodology.

Brandelik, A. (2009). CALCMIN–an EXCEL™ Visual Basic application for calculating mineral structural formulae from electron microprobe analyses. Computers & Geosciences, 35(7), 1540-1551.

Cai, X., Zhang, J., & Shou, W. Z. (2013). Sample reduction strategies in discovery bioanalysis. Bioanalysis, 5(13), 1691-1701.

Chatham, D. M. (1999). SUGGESTIONS FOR REDUCTION OF ANALYTICAL COSTS BY ELIMINATION OF UNNECESSARY QUALITY CONTROL (QC) SAMPLES. WTQA ‘99, 11.

Chovancová, M., & Stopka, O. (2017). MODELING THE" CURRENT REALITY TREE" DIAGRAM IN THE CONTEXT OF INDUSTRIAL LOGISTICS FOR DETERMINATION OF SYSTEM CONSTRAINTS. Mladá Veda, 5(4), 94.

Christobek, Mark Anthony (2001). A comparison of the effectiveness of statistical process control charts.

Chuku, Innocent N. (May 2003). Breakthrough approach to continuous process improvement.

C,J. (2023). Root Cause Analysis Workbook - 5 Why Fishbone

da Costa, J. M. H., Amaral, C. S. T., Fernandes, S. D. C., & Rozenfeld, H. (2019). A new way to diagnose the new product development process based on recurring current reality trees. Business Process Management Journal, 25(4), 667-687.

Chapke, D., & Chandankhede, P. (2024). Maximizing Data Management Efficiency: Utilizing VBA Macros and VLOOKUP Automation in Excel. Grenze International Journal of Engineering & Technology (GIJET), 10.

Ding, J., Baumers, M., Clark, E. A., & Wildman, R. D. (2021). The economics of additive manufacturing: Towards a general cost model including process failure. International Journal of Production Economics, 237, 108087.

Goecks, L. S., Habekost, A. F., Coruzzolo, A. M., & Sellitto, M. A. (2024). Industry 4.0 and smart systems in manufacturing: Guidelines for the implementation of a smart statistical process control. Applied System Innovation, 7(2), 24.

GOJE, G. (2020). APPLICATION OF STATISTICAL PROCESS CONTROL TOOLS IN MANUFACTURING INDUSTRIES: THE CASE OF TIKUR ABBAY SHOE FACTORY (Doctoral dissertation, ST. MARY’S UNIVERSITY).

Gijo, E. V. (2005). Improving process capability of manufacturing process by application of statistical techniques. Quality Engineering, 17(2), 309-315.

Gupta, P. (2006). The Six Sigma performance handbook: A statistical guide to optimizing results. McGraw-Hill.

Handoyo, S., Suharman, H., Ghani, E. K., & Soedarsono, S. (2023). A business strategy, operational efficiency, ownership structure, and manufacturing performance: The moderating role of market uncertainty and competition intensity and its implication on open innovation. Journal of Open Innovation: Technology, Market, and Complexity, 9(2), 100039.

Hrehova, S. (2014). SPC SUCH A OBJECT OF TEACHING BASIC OF PROGRAMMING. Mathematics, Information Technologies and Applied Sciences, 53.

Hudnurkar, M., Ambekar, S., & Bhattacharya, S. (2019). Empirical analysis of Six Sigma project capability deficiency and its impact on project success. TQM Journal, 31(3), 340-358. https://doi.org/10.1108/TQM-06-2018-0078

Hung, H. C., & Sung, M. H., " Applying Six Sigma to Manufacturing Processes in the Food Industry to Reduce Quality Cost," Journal of Scientific Research and Essays, vol. 6, no. 3, 2011.

Hyde, K. M., & Maier, H. R. (2006). Distance-based and stochastic uncertainty analysis for multi-criteria decision analysis in Excel using Visual Basic for Applications. Environmental Modelling & Software, 21(12), 1695-1710.

Iyede, R., Fallon, E. F., & Donnellan, P. (2018). An exploration of the extent of Lean Six Sigma implementation in the West of Ireland. International Journal of LEAN SIX SIGMA, 9(3), 444-462. https://doi.org/10.1108/IJLSS-02-2017-0018

Jacobs, F. Robert and Chase, Richard B. (2008). Operation and Supply Management: The Core. . McGraw-Hill/Irwin Series. Chapter 6 Six-Sigma Quality.

Jacobs, F. Robert and Chase, Richard B. (2018). Operation and Supply Management. Fifteenth edition. McGraw-Hill/Irwin Series. Chapter 13 Statistical Quality Control.

Jeon, H and Choi, B. (July 2012). The relationship between employee satisfaction and customer satisfaction.

Jung, Hyo S. and Yoon, Hye H. (Sept. 2013). Do employees’ satisfied customers respond with an satisfactory relationship? The effects of employees’ satisfaction on customers’ satisfaction and loyalty in a family restaurant.

Kaswan, M. S., & Rathi, R. (2020). Green lean Six Sigma for sustainable development: Integration and framework. Environmental Impact Assessment Review, 83, 1-9. https://doi.org/10.1016/j.eiar.2020.106396

Kozhanov, R. V., Kozhanova, E. R., & Sorokina, L. A. (2019). Comparative analysis of software for the study of statistical methods of control of product quality. RUDN Journal of Engineering Research, 20(4), 293-301.

Kroupa, M., Vonka, M., & Kosek, J. (2014). Modeling the mechanism of coagulum formation in dispersions. Journal of Colloid and Interface Science, 424, 43-51. https://doi.org/10.1016/j.jcis.2014.02.024

Lanham, G. (2007). The role of rework in high volume controlled manufacturing operations. A thesis presented to the Faculty of California State University Dominguez Hills.

Liker, Jeffrey K. (2004). The Toyota way - 14 management principles.

Lim, S. A. H., Priyono, A., & Mohamad, S. F. (2019, April). Introducing a Six Sigma Process Control Technique in a Food Production Line: Step-by-step Guideline and Critical Elements of the Implementation. In 2019 IEEE 6th International Conference on Industrial Engineering and Applications (ICIEA) (pp. 338-342). IEEE.

Martina, Hlatká, and Korec Karel. "Design of evaluation tool used to improve the production process." Open Engineering 9.1 (2019): 641-649.

Matveenko V.N. & Kirsanov E. A. (August 2011). The Viscosity and Structure of Dispersed Systems. Moscow University Chemistry Bulletin 66(4):199-228. DOI:10.3103/S0027131411040079

Max Ammerman (Publisher: Productivity Press; 1st edition (Jan. 01st, 1998)). The Root Cause Analysis Handbook: A Simplified Approach to Identifying, Correcting, and Reporting Workplace Errors;

Montgomery, Douglas C. (August 2019). Introduction to Statistical Process Control, 08th;

Montgomery, Douglas C., and Runger, George C. 2020. Applied Statistics and Probability for Engineers. 7th ed. Hoboken, NJ: Wiley.

Muhammad Ahmed Kalwar, Muhammad Ali Khan, Asif Nawaz Wassan, Zuhaib Phul, Shakeel Ahmed Shaikh, Hussain Bux Marri (Recibido on Nov. 03, 2022 & Aceptado on June 24, 2023). Automation of Post-Order Costing Analysis By Using Visual Basic For Application in Microsoft Excel.: A Case Study

McComb, M.A., (2001). STATISTICAL APPROACHES TO PROCESS MANAGEMENT: SHEWHART AND THE IDEA OF PROCESS CONTROL

Meeuwse, M. (2018). The use of Lean Six Sigma methodology in increasing capacity of a chemical production facility at DSM. CHIMIA International Journal for Chemistry, 72(3), 133-138. https://doi.org/10.2533/chimia.2018.133

Pérez-Fernández, L., Sebastián, M. A., & González-Gaya, C. (2022). Methodology to optimize quality costs in manufacturing based on multi-criteria analysis and lean strategies. Applied Sciences, 12(7), 3295.

Perry, G. L. (2004). SpPack: spatial point pattern analysis in Excel using Visual Basic for Applications (VBA). Environmental Modelling & Software, 19(6), 559-569.

Phuong Ha-Lien Tran, et al. (2010). Dissolution-modulating mechanism of pH modifiers in solid dispersion containing weakly acidic or basic drugs with poor water solubility. Journal of Pharmaceutical Sciences, 99(3), 1465-1472.

Pongboonchai, T., Antony, J., Garza, J.A., Komkowski, T., Tortorella, G. L. (2023). Integration of Industry 4.0 technologies into Lean Six Sigma DMAIC: a systematic review

Prashar, A. (2020). Adopting Six Sigma DMAIC for environmental considerations in process industry environment. TQM Journal, 32(6), 1241-1261. https://doi.org/10.1108/TQM-09-2019-0226

Ramirez, E. (2022). Statistical Process Control in Aerospace Manufacturing Industry. California State University, Long Beach.

Ramana, E. V., & Reddy, P. R. (2012). Integration of control charts and data mining for process control and quality improvement. International Journal of Advances in Engineering & Technology, 2(1), 640.

Revansyah, M. A. et al. (2023). TDS, pH, and COD Analysis to Determine Water Quality in Cilayung Village,” Indonesian Journal of Materials and Energy, 12(02). doi: 10.24198/jme.v12i02.41305.

Riberio, M.M Laura, (1999). The use and misuse of statistical tools, Journal of Material Processing technology, Vol 93, pp 288-292. Available online at: http://www.sciencedirect.com/science/article/pii/S0924013699 001788

Roderich, O. (2021). 5 Whys: The Effective Root Cause Analysis;

Rogalewicz, M., Kujawińska, A., & Feledziak, A. (2023). Ensuring the reliability and reduction of quality control costs by minimizing process variability. Eksploatacja i Niezawodność, 25(2).

Ruqoyyah, S., Murni, S., & Linda, L. (2020). Kemampuan pemahaman konsep dan resiliensi matematika dengan VBA microsoft excel. Purwakarta: CV. Tre Alea Jacta Pedagogie.

Rust, Rolf Soeren (Published on July 12, 2024). Investigation on the Formation of Fouling in Continuously Operated Polymerizations (Page 14). Universitaet Hamburg, Department of Chemistry

Saaty, T. L. (2008). Decision making with the analytic hierarchy process. International journal of services sciences, 1(1), 83-98.

Eshraghi, S. (2020). DMAIC Approach to Improving Production Planning Processes. Southern Illinois University at Edwardsville.

Seppanen, M. S. (2000, December). Developing industrial strength simulation models using visual basic for applications (VBA). In 2000 Winter Simulation Conference Proceedings (Cat. No. 00CH37165) (Vol. 1, pp. 77-82). IEEE.

Skalli, D., Charkaoui, A., Cherrafi, A., Shokri, A., Garza, J.A., Antony, J. (2023). Analysis of factors influencing Circular-Lean-Six Sigma 4.0 implementation considering sustainability implications: an exploratory study.

Son, Jung H., Kim, Jae H. and Kim Gi J. (April 2021). Does employee satisfaction influence customer satisfaction? Assessing coffee shops through the service profit chain model.

Soundararajan, K., & Janardhan, R. K. (2019). Cost-reduction and quality improvement using DMAIC in the SMEs. International Journal of Productivity and Performance Management, 68(8), 1528-1540. http://www.emeraldinsight.com/doi/10.1108/IJPPM-10-2018-0360

Sharma, H., & Suri, N. M. (2017). Implementation of quality control tools and techniques in manufacturing industry for process improvement. International Research Journal of Engineering and Technology (IRJET), 4(05).

Schippers, A.J. Werner, 1998, Applicability of statistical process control techniques, International Journal of Production Economics, Vol 56-57, pp 525-535. Available online at: http://www.sciencedirect.com/science/article/pii/S0925527398 000541

Statisti, U. P. O. R. A. B. O., & Tehnike, N. (2009). Improving the process capability of a turning operation by the application of statistical techniques. Materiali in tehnologije, 43(1), 55-59.

Urban, D. & Takamura, K. (2002). Polymer Dispersions and their Industrial Applications, pp.1-40. Weinheim: Wiley-VCH Verlag GmbH.

Wolniak, R., & Grebski, W. (2023). The usage of Statistical Process Control (SPC) in Industry 4.0 conditions. Zeszyty Naukowe Politechniki Śląskiej. Organizacja i Zarządzanie, 190, 259-268.

Xia, P. (2006). “Computer-aided SPC and cybernatic view on quality control. International Journal of Quality & Reliability Management. 23 (9). 1192 – 1203.

Zantek, P.F. (December 1998). Statistical Process Control of Manufacturing Systems with Correlated Stages".

Zhang, S.; Zhang, Q.; Shang, J.; Mao, Z. sha; Yang, C. (2021). Measurement Methods of Particle Size Distribution in Emulsion Polymerization. Chinese J. Chem. Eng. 2021, 39, 1–15. https://doi.org/10.1016/j.cjche.2021.03.007.

Zhang, Y., Huo, M., Zhou, J., & Xie, S. (2010). PKSolver: An add-in program for pharmacokinetic and pharmacodynamic data analysis in Microsoft Excel. Computer methods and programs in biomedicine, 99(3), 306-314.