Perancangan sistem informasi compliance schedule mesin extruder berbasis VBA (Visual Basic for Application) Excel = Design of a compliance schedule information system for extruder machines on VBA (Visual Basic for Application) in Excel

Firmansyah, Daffa Aji (2025) Perancangan sistem informasi compliance schedule mesin extruder berbasis VBA (Visual Basic for Application) Excel = Design of a compliance schedule information system for extruder machines on VBA (Visual Basic for Application) in Excel. Bachelor thesis, Universitas Pelita Harapan.

[thumbnail of Title] Text (Title)
Title.pdf.pdf
Restricted to Registered users only
Available under License Creative Commons Attribution Non-commercial Share Alike.

Download (180kB)
[thumbnail of Abstract] Text (Abstract)
Abstract.pdf.pdf
Restricted to Registered users only
Available under License Creative Commons Attribution Non-commercial Share Alike.

Download (442kB)
[thumbnail of ToC] Text (ToC)
ToC.pdf.pdf
Restricted to Registered users only
Available under License Creative Commons Attribution Non-commercial Share Alike.

Download (478kB)
[thumbnail of Chapter1] Text (Chapter1)
Chapter1.pdf.pdf
Restricted to Registered users only
Available under License Creative Commons Attribution Non-commercial Share Alike.

Download (612kB)
[thumbnail of Chapter2] Text (Chapter2)
Chapter2.pdf.pdf
Restricted to Registered users only
Available under License Creative Commons Attribution Non-commercial Share Alike.

Download (858kB)
[thumbnail of Chapter3] Text (Chapter3)
Chapter3.pdf.pdf
Restricted to Registered users only
Available under License Creative Commons Attribution Non-commercial Share Alike.

Download (602kB)
[thumbnail of Chapter4] Text (Chapter4)
Chapter4.pdf.pdf
Restricted to Registered users only
Available under License Creative Commons Attribution Non-commercial Share Alike.

Download (4MB)
[thumbnail of Chapter5] Text (Chapter5)
Chapter5.pdf.pdf
Restricted to Registered users only
Available under License Creative Commons Attribution Non-commercial Share Alike.

Download (434kB)
[thumbnail of Bibliography] Text (Bibliography)
Bibliography.pdf
Restricted to Registered users only
Available under License Creative Commons Attribution Non-commercial Share Alike.

Download (420kB)
[thumbnail of Appendices] Text (Appendices)
Appendices.pdf
Restricted to Repository staff only
Available under License Creative Commons Attribution Non-commercial Share Alike.

Download (5MB)

Abstract

Variasi produk material sidewall di PT GTR menuntut tingkat fleksibilitas yang tinggi dalam penjadwalan produksi, sehingga compliance schedule menjadi faktor paling krusial untuk menjamin kelancaran operasional proses produksi. Analisis data mengungkapkan adanya korelasi negatif antara compliance schedule dan shortage, yang mengindikasikan kebutuhan mendesak akan sistem informasi monitoring real-time guna meningkatkan kepatuhan jadwal serta mengoptimalkan urutan penjadwalan produksi. Sistem informasi ini dikembangkan dengan menggunakan metode Rapid Application Development (RAD) yang terintegrasi dengan algoritma schedule sequencing, meliputi Shortest Processing Time (SPT), Longest Processing Time (LPT), Least Slack Time (LST), dan Earliest Due Date (EDD). Pendekatan ini dirancang untuk memberikan rekomendasi urutan jadwal produksi yang optimal berdasarkan perhitungan potensi keterlambatan. Hasil evaluasi menunjukkan peningkatan compliance schedule dari rata-rata 84,27% menjadi 92,65% dan penurunan shortage dari rata-rata 0,75% menjadi 0,39%, yang mencerminkan perbaikan pada pengelolaan sumber daya dan perencanaan produksi. Selain itu, implementasi sistem menghasilkan peningkatan efisiensi waktu pembuatan laporan sebanyak 98,43% serta efisiensi biaya tenaga kerja hingga 98,42%, sehingga mengakselerasi pengambilan keputusan operasional. Secara keseluruhan, sistem informasi ini telah terbukti sebagai solusi berbasis data yang efektif dalam meningkatkan kepatuhan jadwal, mengoptimalkan manajemen shortage, dan mempercepat proses pelaporan, sehingga mendongkrak efisiensi operasional PT GTR. / The variation in sidewall material products at PT GTR requires a high degree of flexibility in production scheduling, making the compliance schedule a critical factor in ensuring smooth operational processes. Data analysis reveals a negative correlation between the compliance schedule and shortage, highlighting the urgent need for a real-time monitoring system to improve schedule adherence and optimize production sequencing. This information system was developed using the Rapid Application Development (RAD) method, integrating schedule sequencing algorithms, including Shortest Processing Time (SPT), Longest Processing Time (LPT), Least Slack Time (LST), and Earliest Due Date (EDD). This approach is designed to provide optimal production sequencing recommendations based on delay calculations. Evaluation results indicate an improvement in the compliance schedule from an average of 84.27% to 92.65% and a shortage reduction from an average of 0.75% to 0.39%, reflecting enhanced resource management and production planning. Furthermore, system implementation has resulted in a 98.43% increase in reporting efficiency and a 98.42% reduction in labor costs, accelerating operational decision-making. Overall, this information system has proven to be an effective data-driven solution for enhancing schedule adherence, optimizing shortage management, and accelerating reporting processes, thereby improving operational efficiency at PT GTR.
Item Type: Thesis (Bachelor)
Creators:
Creators
NIM
Email
ORCID
Firmansyah, Daffa Aji
NIM01039230021
daffa.aji1512@gmail.com
UNSPECIFIED
Contributors:
Contribution
Contributors
NIDN/NIDK
Email
Thesis advisor
Rahayu, Priskila Christine
NIDN0317097404
priskila.christine@uph.edu
Uncontrolled Keywords: compliance schedule; shortage; monitoring; rapid application development; schedule sequencing algorithms
Subjects: T Technology > T Technology (General) > T55.4-60.8 Industrial engineering. Management engineering
Divisions: University Subject > Current > Faculty/School - UPH Karawaci > Faculty of Science and Technology > Industrial Engineering
Current > Faculty/School - UPH Karawaci > Faculty of Science and Technology > Industrial Engineering
Depositing User: DAFFA AJI FIRMANSYAH
Date Deposited: 23 Jul 2025 06:20
Last Modified: 23 Jul 2025 06:20
URI: http://repository.uph.edu/id/eprint/69832

Actions (login required)

View Item
View Item