Engine Oil Inventory Management: Comparative Study of Lot-Sizing Methods and Managerial Decision Framework under Cashflow Constraints
DOI:
https://doi.org/10.12695/jmt.2026.25.1.3Keywords:
Inventory control, lot-sizing model, total inventory cost, cashflow constraint, linear programmingAbstract
Abstract. Small and medium-sized enterprises often need to maintain product availability while operating under limited working capital. In this context, a lot-sizing method that minimizes inventory-related costs may still generate purchasing expenditures that are concentrated in particular months and difficult to finance. This study evaluates five established lot-sizing methods namely Wagner-Whitin (WW), Lot-for-Lot (L4L), Economic Order Quantity (EOQ), Periodic Order Quantity (POQ), and Part-Period Balancing (PPB) using data from 13 high-turnover engine-oil SKUs and develops a liquidity-aware policy-selection framework. Order schedules and Total Inventory Cost (TIC) were generated using POM-QM, while cost differences were tested through repeated-measures analysis with Greenhouse-Geisser and Bonferroni adjustments. Monthly purchasing expenditures were then evaluated through violation frequency and cumulative excess under ceilings of IDR 40 million, IDR 50 million, and IDR 60 million. The lot-sizing method significantly affected TIC (p < 0.001). WW generated the lowest aggregate TIC, whereas L4L generated the highest TIC but the lowest cumulative excess across all scenarios. The cost-first and cash-first policies consistently selected WW and L4L, respectively. The balanced policy selected no feasible method at IDR 40 million, EOQ at IDR 50 million, and WW at IDR 60 million. These findings show that inventory-cost efficiency and purchasing-liquidity exposure require separate but integrated evaluation.
Keywords: Inventory planning, lot-sizing methods, total inventory cost, liquidity exposure, policy selection
References
Adipradana, F., & Muharni, Y. (2021). Penentuan Lot Size Dengan Model Dinamis Algoritma Wagner Within Di Pt Xyz. Journal Industrial Servicess, 6(2), 147–154. doi: 10.36055/62010
Anil Kumar, S., & Suresh, S. (2008). Production And Operations Management : With Skill Development, Caselets And Cases.
Anis, M., Nandiroh, S., & Utami, A. D. (2007). Optimasi Perencanaan Produksi Dengan Metode Goal Programming. Jurnal Ilmiah Teknik Industri, 5 No. 3, 133–143.
Arif, Z. Z. Y., & Sukarno, I. (2021). Evaluasi Kebijakan Persediaan Bahan Baku Kantong Semen Untuk Mengurangi Biaya Persediaan (studi Kasus: Pt. Solusi Bangun Indonesia Tbk). Jurnal Manajemen Industri Dan Logistik, 4(2), 138–145. doi: 10.30988/jmil.v4i2.510
Asmal, S., Kurniawan, D., Indah, A. B. R., Anshar, A. M., & Suradi, S. (2023). Inventory Planning Of Raw Material Using Silver Meal And Wagner Whitin Algorithm. Acta Logistica, 10(4), 589–596. doi: 10.22306/al.v10i4.437
Baroroh, I., Febrianto Tarigan, E., Sumantri, S. H., Azhar, A., Hardianto, D., & Kristiyono, T. A. (2024). Implementation Of Material Control In Tugboat Ship Building Using The Lot For Lot (lfl) Method Case Study : (pt.pmp). In International Journal Of Marine Engineering Innovation And Research (vol. 9, Issue 3).
Blanca, M. J., Arnau, J., García-castro, F. J., Alarcón, R., & Bono, R. (2023). Non-normal Data In Repeated Measures Anova: Impact On Type I Error And Power. Psicothema, 35(1), 21–29. doi: 10.7334/psicothema2022.292
Boardman, A. E., Greeberg, D. H., Vinning, A. R., & Weimer, D. L. (2018). Cost-benefit Analysis: Concepts And Practice (5th Ed.). Cambridge University Press.
Chen, Z., & Rossi, R. (2021). A Dynamic Ordering Policy For A Stochastic Inventory Problem With Cash Constraints. Omega, 102, 102378. doi: 10.1016/j.omega.2020.102378
Chen, Z., & Zhang, R.-q. (2024). A Multi-period Multi-product Stochastic Inventory Problem With Order-based Loan. International Journal Of Production Research, 62(22), 8129–8142. doi: 10.1080/00207543.2021.2006818
Drakeley, P., & Perera, T. (2022). Inventory Optimisation Adoption Amongst Smes. Advances In Transdisciplinary Engineering, 25, 200–206. doi: 10.3233/atde220591
Fithri, P., Hasan, A., & Asri, F. M. (2019). Analysis Of Inventory Control By Using Economic Order Quantity Model – A Case Study In Pt Semen Padang. Jurnal Optimasi Sistem Industri, 18(2), 116–124. doi: 10.25077/josi.v18.n2.p116-124.2019
Florim, W., Dias, P., Santos, A. S., Varela, L. R., Madureira, A. M., & Putnik, G. D. (2019). Analysis Of Lot-sizing Methods' Suitability For Different Manufacturing Application Scenarios Oriented To Mrp And Jit/kanban Environments. Brazilian Journal Of Operations And Production Management, 16(4), 638–649. doi: 10.14488/bjopm.2019.v16.n4.a9
Garside, A. K., & Kristiandy, M. J. (2013). Integrasi Analytic Hierarchy Process Dan Goal Programming Dalam Pemilihan Pemasok. Jurnal Teknik Industri, 14, 190–199.
Hakim, B. P., & Ardiansyah, M. N. (2025). Optimal Lot-sizing Decisions In Production Systems Using The Wagner-whitin Algorithm For Data-driven Inventory Control. 15(3).
Heizer, Jay., Render, Barry., & Munson, Chuck. (2017). Operations Management : Sustainability And Supply Chain Management. Pearson.
Ho, R. (2006). Handbook Of Univariate And Multivariate Data Analysis And Interpretation With Spss. Crc Press.
Indarwanto, M., Puro, S., & Manurung, E. H. (2019). The Effect Of Competitive Strategies On The Performance Of Construction Organizations In Indonesia. Sinergi, 23(3), 213. doi: 10.22441/sinergi.2019.3.005
Katehakis, M. N., Melamed, B., & Shi, J. J. (2016). Cash-flow Based Dynamic Inventory Management. Production And Operations Management, 25(9), 1558–1575. doi: 10.1111/poms.12571
Khamai, N., & Sopadang, A. (2023, June 20). Reduction Of Raw Materials Inventory Costs: A Case Study Of Auto Parts Company. doi: 10.46254/an13.20230168
Kittisak, A. (2023). Challenges And Strategies For Inventory Management In Small And Medium-sized Cosmetic Enterprises: A Review. International Journal Of Information Technology And Computer Science Applications, 1(2), 71–77.
Kurniawan, S., & Raphaeli, S. S. (2018). Optimizing Production Process Through Production Planning And Inventory Management In Motorcycle Chains Manufacturer. Comtech: Computer, Mathematics And Engineering Applications, 9(2), 43. doi: 10.21512/comtech.v9i2.4723
Maharani, A. D. U., Winarno, S. T., & Widayanti, S. (2025). Analysis Of Raw Material Inventory Control In Robusta Ground Coffee Production. Jurnal Teknik Pertanian Lampung, 14, 1212–1221. doi: 10.23960/jtep-l.v14i4.1212-1221
Mor, R. S., Bhardwaj, A., Kharka, V., & Kharub, M. (2021). Spare Parts Inventory Management In The Warehouse: A Lean Approach. International Journal Of Industrial Engineering & Production Research, 32(2), 1–11. doi: 10.22068/ijiepr.32.2.1
Nurprihatin, F., Rembulan, G. D., & Pratama, Y. D. (2022). Comparing Probabilistic Economic Order Quantity And Periodic Order Quantity Model Performance Under Lumpy Demand Environment. Management And Production Engineering Review, 13(4), 16–25. doi: 10.24425/mper.2022.142391
Panigrahi, R. R., Shrivastava, A. K., & Nudurupati, S. S. (2024). Impact Of Inventory Management On Sme Performance: A Systematic Review. International Journal Of Productivity And Performance Management. doi: 10.1108/ijppm-08-2023-0428
Pituch, K. A. ., & Stevens, James. (2016). Applied Multivariate Statistics For The Social Sciences: Analyses With Sas And Ibm's Spss. Routledge/taylor & Francis Group.
Rafsanjana, S. R., Prihardianto, R. D., & Arismawati, P. (2024). Evaluation Of Raw Material Inventory Policies Using Material Requirement Planning (mrp) And Lot Sizing Methods: Case Study Of Xyz Msmes. Dinasti International Journal Of Economics, Finance & Accounting (dijefa), 5. doi: 10.38035/dijefa.v5i3
Riskadayanti, O., Hisjam, M., & Yuniaristanto, Y. (2020). Mixed-integer Linear Programming Model For Production Planning: A Case Study At Sawn Timber Production. Jurnal Teknik Industri, 21(2), 163–173. doi: 10.22219/jtiumm.vol21.no2.163-173
Rompotis, G. (2024). Cash Flow Management, Performance And Risk: Evidence From Greece. Euromed Journal Of Business. doi: 10.1108/emjb-09-2023-0245
Saddikuti, V., Prakash, S., Siddharth, V., Jain, K., & Satpathy, S. (2024). A Prescription For Efficiency: Optimizing The Surgical Item Inventory Management Practices In A Healthcare Facility. Journal Of Advances In Management Research, 21(3), 478–506. doi: 10.1108/jamr-11-2023-0342
Downloads
Submitted
Accepted
Published
How to Cite
Issue
Section
License
Copyright (c) 2026 Jurnal Manajemen Teknologi
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License. Copyright @2023. This is an open-access article distributed under the terms of the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License (http://creativecommons.org/licenses/by-nc-sa/4.0/) which permits unrestricted non-commercial used, distribution and reproduction in any medium.
