Inventory Planning for XYZ Mart using EOQ and Monte Carlo

Muhammad Fadhil, Erma Suryani

Abstract


XYZ Mart is a convenience store in Tulungagung regency. Founded in 2012, this store is designed to serve the daily needs of surrounding residents. In addition, this store also caters for the needs of families visiting patients at the hospital in front of XYZ Mart. Along with the store growth, there are more and more customers, and so the more demand. To handle the increasing demand, the store has to increase its inventory of goods. Problems arise when the number of goods keep increasing while the store inventory space does not. Therefore, in order to avoid overstocking or understocking, a research and planning are conducted to determine the optimal number of an order. The method used for inventory optimization is Economic Order Quantity (EOQ) to calculate the most optimal number of goods ordered. To anticipate the uncertainty of demand, Safety Stock (SS) is also used. To determine the average demand per year based on historical data, as a basis for EOQ and SS calculations, a Monte Carlo simulation is used. The expected outcome of this research is to provide recommendations of when and how much goods must be ordered so that the store can optimally use its limited space of inventory.

Keywords


Economic Order Quantity; Reorder Points; Safety Stocks; Monte Carlo Simulation

Full Text:

PDF

References


World Bank, “GDP growth (annual %) - Indonesia,” World Bank. [Online]. Available: https://data.worldbank.org/indicator/NY.GDP.MKTP.KD.ZG?locations=ID. [Accessed: 10-Jun-2020].

S. Sudirman, and M. Alhudhori, “Pengaruh Konsumsi Rumah Tangga, Investasi Terhadap Pertumbuhan Ekonomi Di Provinsi Jambi,” EKONOMIS: Journal of Economics and Business, vol. 2, no. 1, pp. 81–91, Mar. 2018.

B.D.N. Respati, Untung Ratusan Juta Modal 10 Juta dari Minimarket Rumahan, 1st ed. Yogyakarta: Galang Press, 2012.

M. Lusiani, “Optimasi Alokasi Produk pada Ruang Rak Displai Gerai Minimarket berdasarkan Harga Produk Menggunakan Multilevel Association Rules,” JIEMS (Journal of Industrial Engineering and Management Systems), vol. 4, no. 2, Mar. 2016.

L.E. Cárdenas-Barrón, A.A. Shaikh, S. Tiwari, G. Treviño-Garza, “An EOQ inventory model with nonlinear stock dependent holding cost, nonlinear stock dependent demand and trade credit,” Computers and Industrial Engineering, vol. 139, Jan. 2020.

D.R. Kiran, Seven Traditional Tools of TQM, 1st ed. Hyderabad: BSP Books Pvt. Ltd, 2017.

B. Sugiharto, “Aplikasi Simulasi untuk Peramalan Permintaan dan Pengelolaan Persediaan yang Bersifat Probabilistik,” INASEA, vol. 8,

no. 2, pp. 112–120, 2007.

R.E. Melchers, and M. Ahammed, “A fast approximate method for parameter sensitivity estimation in Monte Carlo structural reliability,” Computers and Structures, vol. 82, no. 1, pp. 55–61, 2004.

I.N. Pujawan and Mahendrawathi, Supply Chain Management, 2nd ed. Surabaya: Guna Widya, 2010.

[10] D. Waters, Inventory Control and Management, 2nd ed. Chichester: Wiley, 2003

D. Robinson, “How to use the Safety Stock Formula: A Step-By-Step Guide”, Sky Vault. [Online]. Available: https://www.skuvault.com/blog/safety-stock-formula. [Accessed: 30-Jun-2020]

S. Smock, “Missing Sales? Use the Reorder Point Formula,” Skuvault. [Online]. Available: https://www.skuvault.com/blog/reorder-pointformula. [Accessed: 30-Jun-2020].




DOI: http://dx.doi.org/10.12962/j23546026.y2020i3.11217

Refbacks

  • There are currently no refbacks.


View my Stat: Click Here

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