PENGEMBANG TOOLKIT SUPPLY CHAIN MANAGEMENT DENGAN PENDEKATAN HOUSE OF RISK (HOR) (CASE STUDY: SAINT CINNAMON PEKANBARU)

Adhytia Pratama Putra, Angraini Angraini, Febi Nur Salisah, Muhammad Jazman

Abstract


Penelitian ini mengembangkan perangkat Supply Chain Manage-ment (SCM) dengan menggunakan pendekatan House of Risk (HOR), Excel dan Visual Basic for Applications (VBA) untuk mengatasi tan-tangan manajemen risiko di Saint Cinnamon Pekanbaru. Metode House of Risk (HOR) memakan waktu dan rentan terhadap kesala-han, sehingga membutuhkan waktu s. Perangkat lunak ini men-gotomatiskan analisis risiko, mendukung pengambilan keputusan yang lebih cepat dan akurat. Metodologi ini menggunakan model SCOR untuk mengidentifikasi risiko di seluruh rantai pasokan (Plan, Source, Make, Deliver, Return). Model House of Risk (HOR) kemudian diterapkan untuk memprioritaskan agen risiko berdasarkan Aggregate Risk Potential (ARP). Strategi mitigasi diformu-lasikan dan diurutkan berdasarkan rasio Efektivitas terhadap Tingkat Kesulitan.Perangkat ini mengotomatiskan analisis HOR, menghasilkan diagram Pareto dan matriks ETD. Toolkit berbasis Visual Basic for Applications (VBA) yang dikembangkan memung-kinkan manajemen risiko yang proaktif, mengurangi gangguan operasional, dan meningkatkan layanan pelanggan.

Keywords


Supply Chain Management (SCM); House of Risk (HOR); Excel; Visual Basic for Appli-cations (VBA); Aggregate Risk Potential (ARP).

Full Text:

PDF

References


R. Sadeghi Asl, M. Bagherzadeh Khajeh, M. Pasban, and R. Rostamzadeh, A systematic literature review on supply chain approaches, vol. 18, no. 2. 2023. doi: 10.1108/JM2-04-2021-0089.

E. N. Hayati, “Supply Chain Management (SCM) Dan Logistic Management,” J. Din. Tek., vol. 8, no. 1, pp. 25–34, 2014.

M. Ulfah, M. Syamsul Maarif, and S. Raharja, “Analisis Dan Perbaikan Manajemen Risiko Rantai Pasok Gula Rafinasi Dengan Pendekatan House of Risk Analysis and Improvement of Supply Chain Risk Management of Refined Sugar Using House of Risk Approach,” J. Tek. Ind. Pertan., vol. 26, no. 1, pp. 87–103, 2016.

M. A. Z. DEWI MARDIAWATI, SITI HANDAM DEWI, “PERANCANGAN PELAPORAN PASIEN RAWAT JALAN MENGUNAKAN APLIKASI DATABASE BERBASIS VISUAL BASIC FOR APPLICATION (VBA) MICROSOFT EXCEL DI RUMAH SAKIT,” vol. 6, no. 4, pp. 1–23, 2016.

Lestari, “Designing_Supply_Chain_Tool_usign_SCOR_M.pdf.” 2018.

B. Prasetyo, W. E. Y. Retnani, and N. L. M. Ifadah, “Analisis Strategi Mitigasi Risiko Supply Chain Management Menggunakan House of Risk (HOR),” J. Tekno Kompak, vol. 16, no. 2, p. 72, 2022, doi: 10.33365/jtk.v16i2.1878.

J. Zhang, A. Brintrup, A. Calinescu, E. Kosasih, and A. Sharma, “Supply Chain Digital Twin Framework Design: An Approach of Supply Chain Operations Reference Model and System of Systems,” pp. 1–23, 2021, [Online]. Available: http://arxiv.org/abs/2107.09485

D. Sinoimeri and J. Teta, “Systematic Literature Review of Supply Chain Management,” Proc. Int. Conf. Business, Manag. Econ., vol. 1, no. 1, pp. 16–21, 2024, doi: 10.33422/icbmeconf.v1i1.195.

Markomah and M. Siladjaja, “Pengaruh supply chain management terhadap kinerja operasional perusahaan : kajian singkat industri manufacturing,” Semin. Nas. Call Pap. Forum Manaj. Indones., vol. 7, no. 2, pp. 1–16, 2020.

R. Oktarina and S. Gunawan, “House of Risk (HOR) Analysis as a Supply Chain Risk Mitigation Method at CV. XYZ,” pp. 1203–1213, 2023, doi: 10.46254/sa03.20220253.

D. L. Trenggonowati, Y. Muharni, A. Ridwan, and A. M. Wardhani, “House of Risk (HoR) Analysis Application for Supply Chain Risk Management (SCRM) in Micro Small and Medium – Sized Enterprises (MSMSs),” Proc. Conf. Broad Expo. to Sci. Technol. 2021 (BEST 2021), vol. 210, no. February, 2022, doi: 10.2991/aer.k.220131.044.

T. Immawan and D. K. Putri, “House of risk approach for assessing supply chain risk management strategies: A case study in Crumb Rubber Company Ltd,” MATEC Web Conf., vol. 154, pp. 1–4, 2018, doi: 10.1051/matecconf/201815401097.

Rini Oktavera, M. R. Kurniawan, R. Saraswati, and B. Sutejo, “Risk Management Analysis in Tobacco Supply Chain Using the House of Risk Method,” J. Appl. Sci. Eng. Technol. Educ., vol. 4, no. 2, pp. 167–175, 2022, doi: 10.35877/454ri.asci844.

R. Magdalena, “Analisis Risiko Supply Chain Dengan Model House of Risk (Hor) Pada Pt Tatalogam Lestari,” J. Tek. Ind., vol. 14, no. 2, p. 53, 2019.

Y. Fadhillah, N. Aswan, M. N. H. Siregar, and F. A. Hasibuan, “Peningkatan Kemampuan dan Keterampilan Penggunaan Microsoft Excel Dalam Pembelajaran Matematika Pada Siswa YPKS Padangsidimpuan,” J. Pengabdi. Kpd. Masy. Radisi, vol. 1, no. 3, pp. 259–265, 2021, [Online]. Available: https://jurnal.radisi.or.id/index.php/PKMRADISI/article/view/71

D. A. S. Olivya Balqis Axshelby1), “IMPLEMENTASI PENGGUNAAN MICROSOFT EXCEL VBA UNTUK MEMBUAT LAPORAN KEUANGAN SEDERHANA UMKM XYZ STUDIO,” vol. 25, no. 02, pp. 1–10, 2024.

M. A. Kalwar, M. A. Khan, A. N. Wassan, Z. Phul, S. A. Shaikh, and H. B. Marri, “Automation of Post-Order Costing Analysis By Using Visual Basic For Applications In Microsoft Excel: A Case Study,” WPOM-Working Pap. Oper. Manag., vol. 14, no. 2, pp. 101–136, 2023, doi: 10.4995/wpom.18697.

D. Divisi, G. di Leonardo, G. Zaccagna, and R. Crisci, “Basic statistics with Microsoft Excel: A review,” J. Thorac. Dis., vol. 9, no. 6, pp. 1734–1740, 2017, doi: 10.21037/jtd.2017.05.81.

T. Muneer and S. Ivanova, “Excel-VBA: From Solving Mathematical Puzzles to Analysing Complex Engineering Problems,” Excel. From Solving Math. Puzzles to Anal. Complex Eng. Probl., pp. 1–170, 2022, doi: 10.1007/978-3-030-94085-0.

S. Ruqoyyah, S. Murni, and T. T. Wijaya, “The Effect of VBA for Microsoft Excel as Teaching Material to Improve Prospective Elementary School Teachers’ Mathematical Conceptual Understanding,” Mimb. Sekol. Dasar, vol. 7, no. 2, pp. 251–268, 2020, doi: 10.17509/mimbar-sd.v7i2.26494.




DOI: https://doi.org/10.29100/jipi.v11i1.7812

Refbacks

  • There are currently no refbacks.


Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

JIPI (Jurnal Ilmiah Penelitian dan Pembelajaran Informatika)
ISSN 2540-8984
Published by
Prodi Pendidikan Teknologi Informasi
Universitas Bhinneka PGRI

Website :https://jurnal.stkippgritulungagung.ac.id/index.php/jipi/index
Email: jipistkippti@gmail.com

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.