Adesta, Fricilia Natalee (2026) DESIGN OF WAREHOUSE LAYOUT, INVENTORY SYSTEM, AND INFORMATION SYSTEM TO LOWER THE RISK OF OVERSTOCK IN A CIGARETTE DISTRIBUTION COMPANY. S1 thesis, UNIVERSITAS ATMA JAYA YOGYAKARTA.

Text (COVER)
221412149_Chap 0.pdf

File Pdf (474kB)
Text (BAB I)
221412149_Chap 1.pdf

File Pdf (464kB)
Text (BAB II)
221412149_Chap 2.pdf

File Pdf (405kB)
Text (BAB III)
221412149_Chap 3.pdf
Restricted to Registered users only

File Pdf (431kB)
Text (BAB IV)
221412149_Chap 4.pdf
Restricted to Registered users only

File Pdf (459kB)
Text (BAB V)
221412149_Chap 5.pdf
Restricted to Registered users only

File Pdf (4MB)
Text (BAB VI)
221412149_Chap 6.pdf
Restricted to Registered users only

File Pdf (1MB)
Text (BAB VII)
221412149_Chap 7.pdf

File Pdf (733kB)

Abstract

CV Andita Swarga Mahakarya is a spice-flavoured cigarette processing company located
in Magelang, Central Java, which produces four cigarette variants: Assikha Gold,
Assikha Habbat, CK, and Tani Madjoe. However, the company faces a primary issue
regarding a buildup of work-in-process inventory ranging from 25 to 75 cartons per week,
which exceeds the actual storage capacity of the warehouse. This issue is triggered by
three interrelated root causes: limited warehouse storage capacity, uncertainty in the
timing and quantity of orders from the Malang factory, and a manual inventory system
for tracking incoming and outgoing goods flow. To address these issues, an integrated
solution was designed consisting of three proposed solution designs: a redesign of the
fermentation warehouse layout with the addition of storage racks, a simulation-based
inventory control system, and a digital inventory management information system based
on Visual Basic for Applications (VBA) in Microsoft Excel.
The solution design process was conducted using the Design Thinking methodology,
which consists of five stages: empathizing, defining, ideating, prototyping, and testing. In
the inventory control system design solution, a continuous review system (Q-System)
with a probabilistic inventory model and Monte Carlo simulation was applied to determine
the optimal economic order quantity (Q) and reorder point (ROP). In the warehouse re-
layout design solution, the fast, slow, non-moving (FSN) classification method and the
dedicated storage policy are used to establish fixed storage areas based on product
turnover rates. Meanwhile, the information system solution utilized the system
development life cycle (SDLC) method to construct automation code for the Microsoft
Excel Visual Basic for Applications (VBA)-based inventory tracking system.
The design results demonstrate that integrating all three proposed solution designs
successfully met the designated Critical Success Factor (CSF) target, achieving a
reduction in excess inventory of at least 15 cartons per week. For the inventory control
solution, pre-simulation conditions showed an average overstock level of 28,20 bales
with a total daily inventory cost of Rp 1.989.000, whereas post-simulation implementation
significantly reduced average overstock to 9,97 bales and lowered the total daily
inventory cost to Rp 1.800.025, yielding a daily cost saving of Rp 188.975 or 9.50%. For
the re-layout solutions, pre-implementation capacity was limited to 200 cartons (800
bales) with random stockpiling outside the warehouse, whereas post-implementation
with multi-tiered racks worth Rp 3.809.000 increased storage capacity to 260 cartons
(1.385 bales) alongside a more organized material flow. For the information system
solution, pre-implementation relied on manual ledgers prone to errors and data loss,
whereas post-implementation produced an Excel VBA-based information system
equipped with Role-Based Access Control, a real-time stock monitoring dashboard, ROP
notifications, and automated sales invoice printing.

Item Type: Thesis (S1)
Uncontrolled Keywords: Overstock, Continuous Review System, Monte Carlo Simulation, Dedicated Storage, Visual Basic for Applications (VBA)
Subjects: Industrial Engineering > Logistics and Supply Chain Management
Divisions: Fakultas Teknologi Industri > Teknik Industri Internasional
Date Deposited: 12 Nov 2026 02:31
Last Modified: 12 Nov 2026 02:31
URI: https://repository.uajy.ac.id/id/eprint/38138

Actions (login required)

View Item
View Item