Designing Delivery Entry Ticket System For Optimizing Transport Logistic Data Recording And Report At Pharmaceutical Company, Cikarang, West Java
DOI:
https://doi.org/10.33021/jie.v10i01.69Keywords:
Information System, Transportation, Inbound, Outbound, SDLCAbstract
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.
Keywords: System Analysis, Development, Data, Input, Output, Transport, Inbound, Outbound, Report.
References
Aramouni, N. A. K., Steiner-Browne, M., & Mouras, R. (2023). Application of process analytical technology (PAT) in real-time monitoring of pharmaceutical cleaning process: Unveiling the cleaning mechanisms governing the cleaning-in-place (CIP). Process Safety and Environmental Protection, 177(June), 212–222. https://doi.org/10.1016/j.psep.2023.07.010
Berghman, L., Kergosien, Y., & Billaut, J. C. (2023). A review on integrated scheduling and outbound vehicle routing problems. European Journal of Operational Research, 311(1), 1–23. https://doi.org/10.1016/j.ejor.2022.12.036
Breschi, V., Formentin, S., Todeschini, D., Cologni, A. L., & Savaresi, S. M. (2020). Data-driven on-line load monitoring in garbage trucks. IFAC-PapersOnline, 53(2), 14300–14305. https://doi.org/10.1016/j.ifacol.2020.12.1370
Casola, V., De Benedictis, A., Mazzocca, C., & Orbinato, V. (2024). Secure software development and testing: A model-based methodology. Computers and Security, 137, 103639. https://doi.org/10.1016/j.cose.2023.103639
Dintén, R., García, S., & Zorrilla, M. (2022). Fleet management systems in Logistics 4.0 era: a real time distributed and scalable architectural proposal. Procedia Computer Science, 217(2022), 806–815. https://doi.org/10.1016/j.procs.2022.12.277
Fleur, D. S., van den Bos, W., & Bredeweg, B. (2023). Social comparison in learning analytics dashboard supporting motivation and academic achievement. Computers and Education Open, 4(February), 100130. https://doi.org/10.1016/j.caeo.2023.100130
Gershon, P., Seaman, S., Mehler, B., Reimer, B., & Coughlin, J. (2021). Driver behavior and the use of automation in real-world driving. Accident Analysis and Prevention, 158, 106217. https://doi.org/10.1016/j.aap.2021.106217
Hoffenson, S., Philippe, C., Chen, Z., Barrientos, C., Yu, Z., Chell, B., & Blackburn, M. (2023). Graphical features of interactive dashboards have little influence on engineering students performing a design task. International Journal of Human Computer Studies, 180(November 2022), 103121. https://doi.org/10.1016/j.ijhcs.2023.103121
Manoj, R., Ranganayaki, M. C., & Varthan, V. (2024). Customer Satisfaction on Inbound and Outbound Logistics of VL Appliances India Pvt Ltd. Rabindra Bharati University Journal of Economics, 28(32), 49-54. https://www.researchgate.net/publication/381774733
Marbella, H. N., Akbar, I. A., & Setiawan, B. (2024). Design and development of a web-based patient management information system. Procedia Computer Science, 234, 1799–1806. https://doi.org/10.1016/j.procs.2024.03.188
Muehlbauer, K., Wuennenberg, M., Meissner, S., & Fottner, J. (2022). Data driven logistics-oriented value stream mapping 4.0: A guideline for practitioners. IFAC-PapersOnline, 55(16), 364–369. https://doi.org/10.1016/j.ifacol.2022.09.051
Padoa-Schioppa, C. (2022). Logistic analysis of choice data: A primer. Neuron, 110(10), 1615–1630. https://doi.org/10.1016/j.neuron.2022.03.002
Parhi, S., Joshi, K., Gunasekaran, A., & Sethuraman, K. (2022). Reflecting on an empirical study of the digitalization initiatives for sustainability on logistics: The concept of sustainable logistics 4.0. Cleaner Logistics and Supply Chain, 4(January), 100058. https://doi.org/10.1016/j.clscn.2022.100058
Sampaio, Á. M., Lima, A., Silva, C., Carneiro, V. H., Fernandes, F., Fernandes, A., & Pontes, A. J. (2023). Design and development of an Automatic Optical Inspection (AOI) system support based on digital manufacturing. Procedia CIRP, 119, 15–20. https://doi.org/10.1016/j.procir.2023.03.080
Soni, P., de Runz, C., Bouali, F., & Venturini, G. (2024). A survey on automatic dashboard recommendation systems. Visual Informatics, 8(1), 67–79. https://doi.org/10.1016/j.visinf.2024.01.002
Sun, X., Durkin, A., & Guo, M. (2023). Life cycle optimisation tool development for process systems and centralised supply chain design. RSC Sustainability, 1(9), 2224–2240. https://doi.org/10.1039/d3su00251a
Tissen, D., Wiederkehr, I., Koldewey, C., & Dumitrescu, R. (2024). Data from start to finish: A System Life Cycle Data Map. Procedia CIRP, 122, 413–418. https://doi.org/10.1016/j.procir.2024.01.060
Torbali, B., & Alpan, G. (2023). A multi-agent-based real-time truck scheduling model for cross-docking problems with single inbound and outbound doors. Supply Chain Analytics, 3(February), 100028. https://doi.org/10.1016/j.sca.2023.100028
Wei, B., Çetinkaya, S., & Cline, D. B. H. (2023). Inbound replenishment and outbound dispatch decisions under hybrid shipment consolidation policies: An analytical model and comparison. Transportation Research Part E: Logistics and Transportation Review, 175(December 2022), 103135. https://doi.org/10.1016/j.tre.2023.103135
Zhou, Z. (2023). Discussion on the integrated design and innovation of enterprise information systems based on supply chain. Procedia Computer Science, 228, 952–956. https://doi.org/10.1016/j.procs.2023.11.125
Downloads
Published
Issue
Section
License
Copyright (c) 2025 Hery Hamdi Azwir, Nicko Fernando, Herwan Yusmira
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
