Optimization of throughput rate prediction in animal feed industry using crisp-dm and operational research approaches

Riri Indah Lestari; Luciana Andrawina; Ilma Mufidah

doi:10.12928/ijio.v6i1.11357

Authors

Riri Indah Lestari Telkom University
Luciana Andrawina Telkom University
Ilma Mufidah Telkom University

DOI:

https://doi.org/10.12928/ijio.v6i1.11357

Keywords:

Throughput rates, CRISP-DM, Data mining, Machine learning, Operation Research

Abstract

The competitive animal feed industry requires efficient production planning to meet market demand, maximize resource use, and sustain profitability. Various raw materials, tools, and techniques are utilized to create animal feed, which results in various variants that might influence throughput rates and thereby alter the accuracy of yield projections. Data mining is applied to train and validate different algorithms to ascertain the most effective model for predicting throughput rates through machine learning. This study uses CRISP-DM to construct an enhanced predictive model for production throughput rate. Due to the model's improved prediction accuracy, scheduling and operational decision-making will be more efficient and cost-effective. The CRISP-DM framework is used to examine historical production data and forecast production levels. Advanced machine learning techniques train and evaluate the model to make accurate predictions that can be mathematically simulated using possible constraints. The findings show that throughput rate predictions are effectively generated by the predictive model that was created using data mining processes. Metrics like Mean Absolute Error (MAE), Mean Squared Error (MSE), and Root Mean Squared Error (RMSE) are used to assess the model and identify the optimal model after attempting using different predictive machine learning techniques. With the linear regression algorithm and MAE values of 5,186, MSE of 1,585, and RMSE of 5,970.32, the best prediction model test results have been determined. An optimal scheduling simulation is conducted from the selected model, with the constraint of the customer's delivery requirements and the time capacity, specifically a maximum throughput rate prediction of 23.78 tons/hour. However, this study reveals how the data mining process is applied to the decision-making process with the use of operation research support so that the optimal production rate prediction is 22 tons/hour.

References

A. Nubahriati, D. Natalia, and A. Sutomo, “Manufacturing Cycle Effectiveness dalam Meningkatkan Kinerja Studi Kasus Pada Bengkel Sinar Las Di Kota Watampone,” Journal of Applied Management and Business Research, vol. 2, no. 1, pp. 83–90, 2022, doi: 10.38531/jambir.v2i1.48.

M. Gopalakrishnan, M. Subramaniyan, and A. Skoogh, “The Management of Operations Data-driven machine criticality assessment – maintenance decision support for increased productivity,” Production Planning & Control, vol. 33, no. 1, pp. 1–19, 2022, doi: 10.1080/09537287.2020.1817601.

M. Subramaniyan, A. Skoogh, J. Bokrantz, M. A. Sheikh, M. Thürer, and Q. Chang, “Artificial intelligence for throughput bottleneck analysis – State-of-the-art and future directions,” J Manuf Syst, vol. 60, no. August, pp. 734–751, 2021, doi: 10.1016/j.jmsy.2021.07.021.

W. Chen, H. Liu, and E. Qi, “Discrete event-driven model predictive control for real-time work-in-process optimization in serial production systems,” Journal of Manufacturing Systems, vol. 55, no. June 2019, pp. 132–142, 2020, doi: 10.1016/j.jmsy.2020.03.002.

T. Hiller, L. Deipenwisch, and P. Nyhuis, “Systemising Data-driven Methods for Predicting Throughput Time within Production Planning & Control,” IEEE International Conference on Industrial Engineering and Engineering Management, vol. 2022-Decem, pp. 716–721, 2022, doi: 10.1109/IEEM55944.2022.9989885.

Z. Kang, C. Catal, and B. Tekinerdogan, “Machine learning applications in production lines: A systematic literature review,” Comput Ind Eng, vol. 149, no. August, p. 106773, 2020, doi: 10.1016/j.cie.2020.106773.

H. Sun, "Optimizing manufacturing scheduling with genetic algorithm and LSTM neural networks," International Journal of Simulation Modelling, vol. 22, no. 3, pp. 508-519, 2023, doi: 10.2507/IJSIMM22-3-CO13.

A. S. Afolalu, O. M. Ikumapayi, and S. Ongbali, “Analysis of Production Scheduling Initiatives in the Manufacturing Systems,” International Journal of Mechanical and Production, vol. 10, no. 3, pp. 1301–1313, 2020.

Zainab Eldardiry, “A Conceptual Framework for Reducing Changeover Time in Batch Production Facilities,” International Journal of Engineering Research and, vol. V10, no. 01, pp. 236–240, 2021, doi: 10.17577/ijertv10is010102.

G. Schuh, G. Lukas, J. Schweins, J. Trisjono, and J. Frank, “Calculation of product service systems in single and small batch production,” Journal of Revenue and Pricing Management, no. 0123456789, 2024, doi: 10.1057/s41272-023-00455-5.

C. Gröger, F. Niedermann, and B. Mitschang, "Data mining-driven manufacturing process optimization," in Proceedings of the World Congress on Engineering, vol. 3, pp. 4-6, July 2012, available: https://www.iaeng.org/.

J. P. Usuga Cadavid, S. Lamouri, B. Grabot, R. Pellerin, and A. Fortin, “Machine learning applied in production planning and control: a state-of-the-art in the era of industry 4.0,” J Intell Manuf, vol. 31, no. 6, pp. 1531–1558, 2020, doi: 10.1007/s10845-019-01531-7.

Y. Ma, S. Li, F. Qiao, X. Lu, and J. Liu, “A data-driven scheduling knowledge management method for smart shop floor,” Int J Comput Integr Manuf, vol. 35, no. 7, pp. 780–793, 2022, doi: 10.1080/0951192X.2022.2025622.

H. Kim, D. E. Lim, and S. Lee, “Deep Learning-Based Dynamic Scheduling for Semiconductor Manufacturing with High Uncertainty of Automated Material Handling System Capability,” IEEE Transactions on Semiconductor Manufacturing, vol. 33, no. 1, pp. 13–22, 2020, doi: 10.1109/TSM.2020.2965293.

A. Zhao, P. Liu, X. Gao, G. Huang, X. Yang, Y. Ma, and Y. Li, "Data-mining-based real-time optimization of the job shop scheduling problem," Mathematics, vol. 10, no. 23, p. 4608, 2022, doi: 10.3390/math10234608.

S. K. Tripathi and R. Kumar, “A Short Literature on Linear Programming Problem,” EAI Endorsed Transactions on Energy Web, vol. 10, pp. 1–5, 2023, doi: 10.4108/ew.4516.

H. Jacobsen and K. H. Tan, “Improving food safety through data pattern discovery in a sensor-based monitoring system,” Production Planning and Control, vol. 33, no. 16, pp. 1548–1558, 2022, doi: 10.1080/09537287.2021.1882691.

O. J. Fisher et al., “Considerations, challenges and opportunities when developing data-driven models for process manufacturing systems,” Computers & Chemical Engineering, vol. 140, 2020, doi: 10.1016/j.compchemeng.2020.106881.

M. Faishal, et al., "Investigating factors of the purchase intention of slaughterhouses for Halal Certification in Yogyakarta, Indonesia," Multidisciplinary Science Journal, vol. 6, no. 12, p. 2024266, 2024, doi: 10.31893/multiscience.2024266.

R. Wirth and J. Hipp, “CRISP-DM: towards a standard process model for data mining,” Proceedings of the Fourth International Conference on the Practical Application of Knowledge Discovery and Data Mining, no. 24959, pp. 29–39, 2000, [Online]. Available: https://www.researchgate.net/.

J. Wegener, S. Vanputten, J. Neubeck, and A. Wagner, “Data Mining as an Enabler for Customer Data Driven Vehicle Development,” Tongji Daxue Xuebao/Journal of Tongji University, vol. 49, pp. 1–10, 2021.

S. Huber, H. Wiemer, D. Schneider, and S. Ihlenfeldt, “DMME: Data mining methodology for engineering applications - A holistic extension to the CRISP-DM model,” Procedia CIRP, vol. 79, pp. 403–408, 2019, doi: 10.1016/j.procir.2019.02.106.

E. Kesriklioğlu, E. Oktay, and A. Karaaslan, “Predicting total household energy expenditures using ensemble learning methods,” Energy, vol. 276, no. March, 2023, doi: 10.1016/j.energy.2023.127581.

C. K. Eng and H. M. Asih, "An Integrated Robust Optimization model of capacity planning under demand uncertainty in electronic industry," International Journal of Mechanical & Mechatronics Engineering, vol. 15, no. 3, pp. 88-96, 2015, Available: https://www.researchgate.net/.

E. Jumin, F. B. Basaruddin, Y. B. M. Yusoff, S. D. Latif, and A. N. Ahmed, “Solar radiation prediction using boosted decision tree regression model: A case study in Malaysia,” Environmental Science and Pollution Research, vol. 28, no. 21, pp. 26571–26583, 2021, doi: 10.1007/s11356-021-12435-6.

R. Devore, B. Hanin, and G. Petrova, “Neural network approximation,” Acta Numerica, vol. 30, pp. 327–444, 2021, doi: 10.1017/S0962492921000052.

J. J. Jui, M. M. Imran Molla, B. S. Bari, M. Rashid, and M. J. Hasan, “Flat Price Prediction Using Linear and Random Forest Regression Based on Machine Learning Techniques,” Lecture Notes in Electrical Engineering, vol. 678, no. March 2021, pp. 205–217, 2020, doi: 10.1007/978-981-15-6025-5_19.

T. Hiller, T. M. Demke, and P. Nyhuis, “Throughput Time Predictions Along the Order Fulfilment Process,” IEEE Access, vol. 12, pp. 9705–9718, 2024, doi: 10.1109/ACCESS.2024.3353029.

L. Briones, V. Morales, J. Iglesias, G. Morales, and J. M. Escola, “Application of the microsoft excel solver tool in the optimization of distillation sequences problems,” Computer Applications in Engineering Education, vol. 28, no. 2, pp. 304–313, 2020, doi: 10.1002/cae.22193.

R. A. C. Leuveano, H. M. Asih, M. I. Ridho, and D. A. Darmawan, "Balancing inventory management: Genetic algorithm optimization for a novel dynamic lot sizing model in perishable product manufacturing," Journal of Robotics and Control (JRC), vol. 4, no. 6, pp. 878-895, 2023, doi: 10.18196/jrc.v4i6.20667.

C. Wang and S. Zhou, “Approximate multivariate distribution of key performance indicators through ordered block model and pair-copula construction,” IISE Trans, vol. 51, no. 11, pp. 1265–1278, 2019, doi: 10.1080/24725854.2018.1550826.

S. Moon and J. Lee, “Research on Improving Fetal Health Prediction Model Using Optimal Fetal Feature Selection Technique,” Journal of Korean Institute of Communications and Information Sciences, vol. 49, no. 2, pp. 270–276, 2024, doi: 10.7840/kics.2024.49.2.270.

J. E. Fontecha, P. Agarwal, M. N. Torres, S. Mukherjee, J. L. Walteros, and J. P. Rodríguez, “A Two-Stage Data-Driven Spatiotemporal Analysis to Predict Failure Risk of Urban Sewer Systems Leveraging Machine Learning Algorithms,” Risk Analysis, vol. 41, no. 12, pp. 2356–2391, 2021, doi: 10.1111/risa.13742.

X. Tian, Y. Guan, and S. Wang, “Data Transformation in the Predict-Then-Optimize Framework: Enhancing Decision Making under Uncertainty,” Mathematics, vol. 11, no. 17, 2023, doi: 10.3390/math11173782.

H. M. Asih and C. K. Eng, "Cost-volume-profit analysis for uncertain capacity planning: A case study paper," in Proceedings of the Second Asia Pacific International Conference on Industrial Engineering and Operations Management, Surakarta, Indonesia, 2021, available: http://ieomsociety.org/.

A. Gleixner and D. E. Steffy, “Linear programming using limited-precision oracles,” Math Program, vol. 183, no. 1–2, pp. 525–554, 2020, doi: 10.1007/s10107-019-01444-6.

K. Sangngern and A. A. Boonperm, “A new initial basis for the simplex method combined with the nonfeasible basis method,” In Journal of Physics: Conference Series, vol. 1593, no. 1, 2020, doi: 10.1088/1742-6596/1593/1/012002.

H. Yamashiro and H. Nonaka, “Estimation of processing time using machine learning and real factory data for optimization of parallel machine scheduling problem,” Operations Research Perspectives, vol. 8, no. July, p. 100196, 2021, doi: 10.1016/j.orp.2021.100196.

D. Tremblet, S. Thevenin, and A. Dolgui, “Makespan estimation in a flexible job-shop scheduling environment using machine learning,” International Journal of Production Research, vol. 62, no. 10, pp. 3654–3670, 2024, doi: 10.1080/00207543.2023.2245918.

A. Oktafiani and M. N. Ardiansyah, “Scheduling Splitable Jobs on Identical Parallel Machines to Minimize Makespan using Mixed Integer Linear Programming,” International Journal of Innovation in Enterprise System, vol. 7, no. 01, pp. 41–54, 2023, doi: 10.25124/ijies.v7i01.190.