Developing Palm Oil Inventory Control System Using Ms Excel Macro

Authors

  • Siti Zubaidah Ismail Faculty of Manufacturing & Mechatronic EngineeringTechnology, College of Engineering Technology, Universiti Malaysia Pahang, 26600 Pahang, Malaysia
  • Abdulsalam Khaled Abdullah Al-Hadi Faculty of Manufacturing & Mechatronic EngineeringTechnology, College of Engineering Technology, Universiti Malaysia Pahang, 26600 Pahang, Malaysia

DOI:

https://doi.org/10.15282/jmmst.v5i1.6102

Keywords:

Palm oil inventory control, Palm oil plantation, MS Excel Macro

Abstract

The palm oil sector is just one of the popular sectors in Malaysia that offer one of the highest exports to Malaysia's economy. This study handles the research study of inventory control for Malaysian palm oil plantation. The existing inventory control cannot be running smoothly when the inventory are managed in different user interface systems which is by utilizing manual inventory control like Microsoft Excel and handwriting documents. Data collection was gathered with the targeted respondents, they are core members of the management team who have a great experience as well as understanding of their inventory system. In order to make PSS inventory control much easier as well as organized, an inventory application system is developed utilizing MS Excel Macro. The outcomes of this research study are a computerized supply control system that beneficial, crucial, and also much better substitute for a hand-operated administration system and quick handling.

References

Nambiappan, B., Ismail, A., Hashim, N., Ismail, N., Shahari, D. N., Idris, N. A. N., Omar, N., Salleh, K. M., Hassan, N. A. M., & Kushairi, A. (2018). Malaysia: 100 years of resilient palm oil economic performance. Journal of Oil Palm Research, 30(1), 13–25. https://doi.org/10.21894/jopr.2018.0014

Abdani, S. R., & Zulkifley, M. A. (2020). DenseNet with Spatial Pyramid Pooling for Industrial Oil Palm Plantation Detection. December, 134–138. https://doi.org/10.1109/morse48060.2019.8998735

Alias, M. S., Ismail Adnan, A. M., Jugah, K., Ishaq, I., & Fizree, Z. A. (2017). Detection of Basal Stem Rot (BSR) disease at oil palm plantation using hyperspectral imaging. Workshop on Hyperspectral Image and Signal Processing, Evolution in Remote Sensing, 2013-June, 1–4. https://doi.org/10.1109/WHISPERS.2013.8080700

Ahmad, N., Kasim, J., Mahmud, S. Z., Yamani, S. A. K., Mokhtar, A., & Yunus, N. Y. M. (2011). Manufacture and properties of oil palm particleboard. 3rd ISESEE 2011 -International Symposium and Exhibition in Sustainable Energy and Environment, June, 84–87. https://doi.org/10.1109/ISESEE.2011.5977115

Aubert, P., Chakib, A., & Laurans, Y. (2017). Implementation and effectiveness of sustainability initiativesin the palm oil sector : a review. October.

Efrilianda, D. A., Mustafid, & Isnanto, R. R. (2018). Inventory control systems with safety stock and reorder point approach.2018 International Conference on Information and Communications Technology, ICOIACT 2018, 2018-Janua, 844–847. https://doi.org/10.1109/ICOIACT.2018.8350766

Meilani, D., Andiningtias, A., & Fatrias, D. (2018). Decision support system forinventory control of raw material (Case study: PT Suwarni Agro Mandiri Plant Pariaman, Indonesia). 2018 5th International Conference on Industrial Engineering and Applications, ICIEA 2018, March 2017, 6–10. https://doi.org/10.1109/IEA.2018.8387063

Arifin, R., & Ismail, S. Z. (2019). Investigation of Inventory Record Accuracy in Product-Service System. In Journal of Modern Manufacturing Systems and Technology (Vol. 02).

Ravinder, H. V., & Misra, R. B. (2016). ABC Analysis For Inventory Management: Bridging The Gap Between Research And Classroom. American Journal of Business Education (AJBE), 9(1), 1. https://doi.org/10.19030/ajbe.v9i1.9578

Li, W. L., & Deng, M. R. (2011). Study on inventory decision under demand uncertainty based on evidence theory. 2011 IEEE 18th International Conference on Industrial Engineering and Engineering Management, IE and EM 2011, PART 1, 226–228. https://doi.org/10.1109/IEEM.2011.6035145

Downloads

Published

19-03-2021

How to Cite

Ismail, S. Z., & Abdullah Al-Hadi, A. K. (2021). Developing Palm Oil Inventory Control System Using Ms Excel Macro. Journal of Modern Manufacturing Systems and Technology, 5(1), 51–55. https://doi.org/10.15282/jmmst.v5i1.6102

Issue

Section

Articles

Most read articles by the same author(s)