Kaunia: Integration and Interconnection of Islam and Science Journal
Vol. 9 No. 1 (2013)

PENGENDALIAN PERSEDIAAN MENGGUNAKAN SIMULASI BERBASIS SPREADSHEET (Studi Kasus: Jaringan Toko Sepatu Olahraga)

Syaeful Arief (Teknik Industri, Fakultas Sains dan Teknologi, UIN Sunan Kalijaga)
Taufiq Aji (Teknik Industri, Fakultas Sains dan Teknologi, UIN Sunan Kalijaga)



Article Info

Publish Date
01 May 2013

Abstract

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.

Copyrights © 2013






Journal Info

Abbrev

kaunia

Publisher

Subject

Religion Biochemistry, Genetics & Molecular Biology Chemistry Mathematics Physics

Description

The aim of KAUNIA journal is to publish high-quality articles dedicated to all aspects of the latest outstanding developments in the field of Science, Mathematics, Education, Technology, and Religious Perspective Interconnect-Integration. The journal publishes articles, reviews, and research notes ...