Enhancing process parameter definition in a coil coating paint line

The improvement of industrial processes is essential to ensure operational efficiency and product quality, particularly in continuous manufacturing environments such as coil coating, where process parameter definition is critical. This study proposes and validates a structured methodological framework for the definition and automation of process parameters in continuous industrial processes. The research was conducted in a coil coating production line, focusing on a procedure that had previously been performed manually, making it time-consuming and prone to human error. An action research approach was adopted, involving data collection, analysis of the existing workflow, and the development of a computational decisionsupport solution using Microsoft Excel and Visual Basic for Applications (VBA) integrated with SAP Script. The proposed method was evaluated through a before-and-after comparative analysis, using execution time and operational efficiency as key performance indicators. The results show a reduction of approximately 98% in execution time, decreasing from up to 15 hours to about 12 minutes, achieved by eliminating interdepartmental dependencies and automating parameter calculation and system loading. The main scientific contribution lies in the formalization of a replicable framework that transforms a tacit, experience-based activity into a structured decision-support methodology applicable to continuous industrial processes.

Show more Show less

References:

Ali, S., & Jaqin, C. (2024). Improvement and reduce risk of failure part-casting by multi-domain matrix-process failure modes and effects analysis based verband der automobilindustrie and design of experiment. International Journal of System Assurance Engineering and Management, 15, 3437–3450. https://doi.org/10.1007/s13198-024-02351-6

Alves, C. G. M. de F., & Ribeiro, G. C. D. S. (2021). Aplicação das ferramentas da qualidade como melhoria da produção: um estudo de caso em uma empresa do ramo alimentício. Qualitas revista eletrônica, 22(2), 128. http://dx.doi.org/10.18391/req.v22i2.5207

Arno, P., & Gabryelczyk, R. (2025). From theory to practice: Empirical insights on BPM lifecycle adoption and low-code utilization in SMEs. IEEE Access, 13, 117385–117403. https://doi.org/10.1109/ACCESS.2025.3585261

Bolduan, R., Silva, D. A. K., & Borba, M. L. de. (2024). Psychometric analysis of the scale of barriers to sharing knowledge in the Kaizen of a company. Gestão & produção, 31. https://doi.org/10.1590/1806-9649-2024v31e4523

Braglia, M., Castellano, D., Gabbrielli, R., & Marrazzini, L. (2021). A revised PFMEA approach for reliable design of assembly activities. Designs, 5(1), 12. https://doi.org/10.3390/designs5010012

Caussé, N., Bonin, P., Thierry, D., Le Bozec, N., Roggero, A., & Pébère, N. (2023). Ageing processes of coil-coated materials: Temperature-controlled electrochemical impedance analysis. Progress in organic coatings, 183. https://doi.org/10.1016/j.porgcoat.2023.107682

Coughlan, P., & Coghlan, D. (2002). Action research for operations management. International Journal of Operations & Production Management, 22(2), 220–240. https://doi.org/10.1108/01443570210417515

European Coil Coating Association. (2025). Benefits of coil coating. Available: https://www.prepaintedmetal.eu/en/benefitsof-coil-coating. Accessed: Apr. 24, 2025.

Ferrari, C., et al. (2022). Instrumentação e controle de processos (1st ed.). Porto Alegre: SAGAH.

Ferreira, B. (2020). Métodos ágeis e melhoria de processos (1st ed.). São Paulo: Contentus.

Fertuzinhos, E. (2024). Otimizar processos – Maximizar a eficiência e reduzir os custos (1st ed.). Portugal: Conjuntura Actual Editora.

Garcia, C. (2017). Controle de processos industriais: estratégias convencionais (1st ed.). São Paulo: Editora Blucher.

Gayer, A. (2020). Gestão da qualidade total e melhoria contínua de processos (1st ed.). São Paulo: Contentus.

Gonjari, M., & Banpurkar, R. (2023). A review on process parameters of additive manufacturing. International journal of innovative engineering and sciences, 8(2). https://doi.org/10.46335/IJIES.2023.8.2.2

Haugen, R. A., Skeie, N. O., & Muller, G. (2024). Automation Processes for Efficient Verification of Complex Systems: an Empirical Case Study. Systems, 13(1), 17. https://doi.org/10.3390/systems13010017

Hicham, R., Abdallah, L., & Mohamed, M. (2024). Risk management and assessment hybrid framework for business process reengineering projects: Application in automotive sector. Eng, 5(3), 1360–1381. https://doi.org/10.3390/eng5030071

Hout, A. (2022). Sterile manufacturing – Regulations, process and guidelines (1st ed.). United States: CRC Press. https://doi.org/10.1201/9781003162506-1

Leidlmair, D., Duchoslav, J., Mayr, G., Gsaller, H., Strauß, B., Groiss, H., & Stifter, D. (2025). Depth profiling of wrinkled coil coatings – new insights into gradient structures and coating degradation. Progress in organic coatings, 206. https://doi.org/10.1016/j.porgcoat.2025.109325

Lima, R., & Gomes, R. (2020). Conceitos e tecnologias da Indústria 4.0: Uma análise bibliométrica. Revista brasileira de inovação, 19. https://doi.org/10.20396/rbi.v19i0.8658766

Liu, P., Wu, Y., Li, Y., & Wu, X. (2024). An improved FMEA method based on the expert trust network for maritime transportation risk management. Expert systems with applications, 238. https://doi.org/10.1016/j.eswa.2023.121705

Lobo, N. (2020). Gestão da qualidade (2nd ed.). Rio de Janeiro: Érica.

Lv, C., Zhou, X., Hu, G., Li, S., & Liu, S. (2026). Multifrequency Decoupling Network With Dual-Stage Shift Segmental Modeling for Long-Term Prediction of Industrial Parameters. IEEE Transactions on Industrial Informatics. https://doi.org/10.1109/TII.2025.3650225

Menezes, M. (2020). FMEA de processo na indústria automotiva: uma análise sobre a aplicação do Número de Prioridade de Risco (RPN). M.Sc. dissertation, Engenharia de Produção, Faculdade de Engenharia de Guaratinguetá, Universidade Estadual Paulista, Guaratinguetá.

National Coil Coating Association. (2025). Process. Available: https://www.coilcoating.org/process. Accessed: Apr. 22, 2025.

Normey-Rico, E., & Morato, M. M. (2021). Introdução ao controle de processos. SãoPaulo:Blucher.https://doi.org/10.5151/9786555061581

Pervaz, J., Sremcev, N., Stevanov, B., & Gusel, L. (2024). Simulation-based algorithm for continuous improvement of enterprises performance. International Journal of Simulation Modelling, 23(2), 215–226. https://doi.org/10.2507/IJSIMM23-2-670

Pimenta, R. (2022). FMEA – Análise dos modos de falha e seus efeitos (1st ed.). São José dos Pinhais: Brazilian Journals Editora. https://doi.org/10.35587/brj.ed.0001365

Rosa, P. R. da, Schardosin, F. Z., Alperstedt, G. D., & Feuerschütte, S. G. (2024). Estudo de caso e pesquisaação: semelhanças e distinções entre os métodos. Revista Ciência da Administração, 25(65), 1–17. https://doi.org/10.5007/2175-8077.2023.e80766

Silva, A., & Pansonato, R. C. (2020). Custos, riscos e indicadores da qualidade (1st ed.). São Paulo: Contentus.

Slack, N., Brandon-Jones, A., & Johnston, R. (2018). Administração da produção (8th ed.). São Paulo: Atlas.

Yang, H., & Zhao, H. (2024). Reliability engineering of BeiDou navigation satellite (2024th ed.). Singapore: Springer.https://doi.org/10.1007/978-981-99-9130-3

Show more Show less