EUVIMEDEUVIMED entdecken
Open Access · CC BY-NC-SA 4.0

Designing Delivery Entry Ticket System for Optimizing Transport Logistic Data Recording and Report At Pharmaceutical Company, Cikarang, West Java

Hery Hamdi Azwir, Nicko Fernando, Herwan Yusmira

JIE Scientific Journal on Research and Application of Industrial System · 22.04.2025 · 10 (1) · 17-28

DOI: 10.33021/jie.v10i1.6734 ↗

Kurz gefasst

Fachartikel in der Zeitschrift JIE Scientific Journal on Research and Application of Industrial System, online erschienen am 22.04.2025. Verfasst von Hery Hamdi Azwir und 2 weiteren Autor:innen. Der Volltext ist frei zugänglich (Open Access, CC BY-NC-SA 4.0).

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

This study details the planning, development until deployment phase of a system designed to enhance the efficiency and practicality of data recording, monitoring, and monthly report generation within a pharmaceutical company. The current problem faced by the company is the inefficiency in monthly report creation process. The existing method required over five working days to complete all monthly reports due to the reliance on manual report compilation. There are 34 gates spanning across the warehouse side allowing for 34 simultaneous product movement process. It is very challenging to find out which process is happening at which gate without a single interface showing the information. The root cause analysis finds that the source problem is individual document storage and the data input method causes many incomplete and inconsistent data records resulting in a long time needed to check or validate data that will be reported. This research aims to make improvements in process efficiency and data completeness using System Development Life Cycle (SDLC) method, from planning, analysis, design to development, testing, deployment, and maintenance As a result, this new system which utilizes Microsoft Excel VBA for automation and data manipulation has succeeded in optimizing loading and unloading data recording, resulting in more complete and consistent data records. This allows the user to create monthly report more efficiently which needs less time and recheck. Also, the creation of a truck activity dashboard, allows warehouse personnels and the transport manager to monitor all the truck and gate activity practically and even remotely.

Zitieren

APA

Azwir, H. H., Fernando, N., & Yusmira, H. (2025). Designing Delivery Entry Ticket System for Optimizing Transport Logistic Data Recording and Report At Pharmaceutical Company, Cikarang, West Java. JIE Scientific Journal on Research and Application of Industrial System, 10(1), 17-28. https://doi.org/10.33021/jie.v10i1.6734

Vancouver

Azwir HH, Fernando N, Yusmira H. Designing Delivery Entry Ticket System for Optimizing Transport Logistic Data Recording and Report At Pharmaceutical Company, Cikarang, West Java. JIE Scientific Journal on Research and Application of Industrial System. 2025;10(1):17-28. doi:10.33021/jie.v10i1.6734

BibTeX
@article{Azwir2025,
  author = {Azwir, Hery Hamdi and Fernando, Nicko and Yusmira, Herwan},
  title = {Designing Delivery Entry Ticket System for Optimizing Transport Logistic Data Recording and Report At Pharmaceutical Company, Cikarang, West Java},
  journal = {JIE Scientific Journal on Research and Application of Industrial System},
  year = {2025},
  volume = {10},
  number = {1},
  pages = {17--28},
  doi = {10.33021/jie.v10i1.6734}
}
Kostenlos starten →