Reassessing EOQ-Based Brown Clay Inventory Control for NPK Fertilizer Production: Model Validation and Scenario Analysis
Keywords:
economic order quantity, fertilizer manufacturing, inventory analytics, model validation, raw material controlAbstract
This study reassesses brown clay inventory control for NPK fertilizer production at PT Pupuk Kujang by replacing a purely formula-driven EOQ application with a retrospective quantitative case-study design that integrates descriptive inventory analytics, arithmetic and semantic data auditing, EOQ identity validation, and scenario-based replenishment analysis. The dataset contains twelve monthly observations for 2023 covering procurement volume, replenishment frequency, and reported cost components. Recalculation from monthly entries yields 13,714.42 tons of annual procurement distributed across 594 reported order events. Monthly procurement is highly variable (coefficient of variation = 0.699), while order frequency is similarly dispersed (coefficient of variation = 0.682). January, February, and November alone account for 49.44% of annual procurement. The audit identifies a critical cost-classification problem: the reported "ordering cost" is almost exactly proportional to purchased tonnage at approximately Rp16,000 per ton, indicating a variable procurement expenditure rather than the fixed per-order setup cost required by the classical EOQ model. The reported EOQ of 3,509.87 tons also implies approximately 3.91 replenishments per year, not seven; seven annual orders would imply 1,959.20 tons per order. Consequently, the previously reported 98.4% cost reduction cannot be interpreted as validated EOQ savings because unlike cost bases were compared. Scenario analysis shows that four to twelve annual replenishments would imply average lot sizes of 3,428.61 to 1,142.87 tons, respectively, but economic ranking requires verified ordering cost, holding cost, lead time, storage capacity, and consumption data. The study contributes a reproducible validation framework for industrial EOQ studies and demonstrates that data semantics must be audited before optimization claims are accepted.
References
Alkahtani, M. (2022). Mathematical modelling of inventory and process outsourcing for optimization of supply chain management. Mathematics, 10(7), 1142. https://doi.org/10.3390/math10071142
Chinello, E., Herbert-Hansen, Z. N. L., & Khalid, W. (2020). Assessment of the impact of inventory optimization drivers in a multi-echelon supply chain: Case of a toy manufacturer. Computers & Industrial Engineering, 141, 106232. https://doi.org/10.1016/j.cie.2019.106232
Daryanto, Y., & Setyanto, D. (2023). Production inventory optimization considering direct and indirect carbon emissions under a cap-and-trade regulation. Logistics, 7(1), 16. https://doi.org/10.3390/logistics7010016
Gu, M., Yang, L., & Huo, B. (2021). The impact of information technology usage on supply chain resilience and performance: An ambidexterous view. International Journal of Production Economics, 232, 107956. https://doi.org/10.1016/j.ijpe.2020.107956
Ivanov, D. (2020). Predicting the impacts of epidemic outbreaks on global supply chains: A simulation-based analysis on the coronavirus outbreak (COVID-19/SARS-CoV-2) case. Transportation Research Part E: Logistics and Transportation Review, 136, 101922. https://doi.org/10.1016/j.tre.2020.101922
Ivanov, D. (2022). Viable supply chain model: Integrating agility, resilience and sustainability perspectives, lessons from and thinking beyond the COVID-19 pandemic. Annals of Operations Research, 319, 1411-1431. https://doi.org/10.1007/s10479-020-03640-6
Ivanov, D., & Dolgui, A. (2021). A digital supply chain twin for managing the disruption risks and resilience in the era of Industry 4.0. Production Planning & Control, 32(9), 775-788. https://doi.org/10.1080/09537287.2020.1768450
Kamalahmadi, M., Shekarian, M., & Mellat Parast, M. (2022). The impact of flexibility and redundancy on improving supply chain resilience to disruptions. International Journal of Production Research, 60(6), 1992-2020. https://doi.org/10.1080/00207543.2021.1883759
Konstantaras, I., Skouri, K., & Benkherouf, L. (2021). Optimizing inventory decisions for a closed-loop supply chain model under a carbon tax regulatory mechanism. International Journal of Production Economics, 239, 108185. https://doi.org/10.1016/j.ijpe.2021.108185
Maheshwari, P., & Kamble, S. (2022). The application of supply chain digital twin to measure optimal inventory policy. IFAC-PapersOnLine, 55(10), 2324-2329. https://doi.org/10.1016/j.ifacol.2022.10.055
Nobil, E., Cárdenas-Barrón, L. E., Loera-Hernández, I. J., Smith, N. R., Treviño-Garza, G., Céspedes-Mota, A., & Nobil, A. H. (2023). Sustainability economic production quantity with warm-up function for a defective production system. Sustainability, 15(2), 1397. https://doi.org/10.3390/su15021397
Perez, H. D., Hubbs, C. D., Li, C., & Grossmann, I. E. (2021). Algorithmic approaches to inventory management optimization. Processes, 9(1), 102. https://doi.org/10.3390/pr9010102
Preil, D., & Krapp, M. (2022). Artificial intelligence-based inventory management: A Monte Carlo tree search approach. Annals of Operations Research, 308, 415-439. https://doi.org/10.1007/s10479-021-03935-2
Ralfs, J., & Kiesmüller, G. P. (2022). Inventory management with advance demand information and flexible shipment consolidation. OR Spectrum, 44(4), 1009-1044. https://doi.org/10.1007/s00291-022-00686-9
San-José, L. A., Sicilia, J., González-de-la-Rosa, M., & Febles-Acosta, J. (2022). Profit maximization in an inventory system with time-varying demand, partial backordering and discrete inventory cycle. Annals of Operations Research, 316, 763-783. https://doi.org/10.1007/s10479-021-04161-6
Shi, Y., Zheng, X., Venkatesh, V. G., Humdan, E. A., & Paul, S. K. (2023). The impact of digitalization on supply chain resilience: An empirical study of the Chinese manufacturing industry. Journal of Business & Industrial Marketing, 38(1), 1-11. https://doi.org/10.1108/JBIM-09-2021-0456
Shofariah, W., & Herdian, F. (2024). Analysis of raw material inventory control with a tabular approach and formula approach Economic Order Quantity (EOQ) to optimize the cost of soybean raw material inventory. Jurnal Indonesia Sosial Sains, 5(6), 1318-1331. https://doi.org/10.59141/jiss.v5i06.1137
Zhang, Y., Chai, Y., & Ma, L. (2021). Research on multi-echelon inventory optimization for fresh products in supply chains. Sustainability, 13(11), 6309. https://doi.org/10.3390/su13116309
Zhao, N., Hong, J., & Lau, K. H. (2023). Impact of supply chain digitalization on supply chain resilience and performance: A multi-mediation model. International Journal of Production Economics, 259, 108817. https://doi.org/10.1016/j.ijpe.2023.108817
Zouari, D., Ruel, S., & Viale, L. (2021). Does digitalising the supply chain contribute to its resilience? International Journal of Physical Distribution & Logistics Management, 51(2), 149-180. https://doi.org/10.1108/IJPDLM-01-2020-0038
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2026 Rizky Pratama, Agung Widarman, Haris Sandi Yudha

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

