PENGENDALIAN PERSEDIAAN MENGGUNAKAN SIMULASI BERBASIS SPREADSHEET (Studi Kasus: Jaringan Toko Sepatu Olahraga)
DOI:
https://doi.org/10.14421/kaunia.1044Keywords:
inventory, probabilistic, monte carlo simulations, spreadsheetsAbstract
A sports shoe store retail business whose sales are closely related to the ongoing trend when it. On the other hand, intense market competition and meet the market's appetite to add complexity and uncertainty that led to inventory planning are probabilistic. Demand variability, lead time is uncertain, and suppliers who require the purchase of serially into the challenges faced by retail sports shoes. To make decisions in situations such supplies can be used simulation approach. This study presents a spreadsheet-based simulation approach to resolve montecarlo inventory decisions. Spreadsheet application aids chosen because commonly used in a variety of companies. Simulation model was built by using Visual Basic for Application to perform computational mode. Simulation aims to (1) determine the time and the number of reservations that a minimum total inventory cost, (2) to decrease inventory costs against corporation existing condition. Computational results are executed to achieve steady state is able to provide a reduction in total inventory costs significantly.
Downloads
Published
How to Cite
Issue
Section
License
All articles published in Kaunia are licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International license, with the copyright to these articles held by the journal. Anyone is free to read, download, copy, distribute, print, search, link to full text articles, or transform an article, in any medium or format, provided they do so non-commercially, give appropriate credit to Kaunia, and distribute any derivative work under the same (or equivalent) terms.
By submitting to Kaunia, authors agree to both the terms of the CC BY-NC-SA license and the automatic transfer of the copyright to their article if it is accepted.