Pemanfaatan Google Spreadsheet dan Google Studio Sebagai Dashboard Pengelolaan Gudang dengan Metode Economic Order Quantity (EOQ) di Perusahaan Pengolah Makanan Laut
DOI:
https://doi.org/10.22441/10.22441/2441/pasti.2025.v19i2.005Keywords:
Economic Order Quantity, Google Spreadsheet, Google StudioAbstract
Objek Penelitian adalah sebuah perusahaan pengolah makanan laut yang melayani konsumen domestik dan internasional. Saat ini pengelolaan data stok barang masih menggunakan proses manual, sehingga sering menimbulkan kesalahan data dan human error. Berdasarkan data penjualan bulan Juni 2023, setidaknya terdapat delapan kali kesalahan input data sehingga merugikan perusahaan. Penelitian ini bertujuan untuk mengeliminasi kesalahan input data dengan mengaplikasikan Google Spreadsheet dan Google Studio sebagai dashboard pengelolaan gudang dengan metode Economic Order Quantity (EOQ). Hasil penelitian menunjukkan bahwa penggunaan EOQ dan implementasi dashboard visualisasi data dapat mengurangi kesalahan dalam pengelolaan stok dan meningkatkan efisiensi operasional.
Downloads
References
Azis, N., Wahidin, A. J., Cakranegara, P. A., Muditomo, A., & Efendi, E. (2022). Visualization Of Tourist Visit Time Series Data Using Google Data Studio. Jurnal Mantik, 6(2), 2153–2159. http://www.iocscience.org/ejournal/index.php/mantik/article/view/2731
Damayanti, S., & Rusliyawati, R. (2023). Analisis Pemanfaatan Google Spreetsheed Untuk Pengendalian Surat (Study Kasus: Dinas Perindustrian Bandar Lampung). Jurnal Teknologi Dan Sistem …, 4(2), 179–184.
Gonçalves, J. N. C., Sameiro Carvalho, M., & Cortez, P. (2020). Operations research models and methods for safety stock determination: A review. Operations Research Perspectives, 7(April), 100164. https://doi.org/10.1016/j.orp.2020.100164
Guntara, D., Nasution, M. I. P., & Nasution, A. B. (2020). Implementasi Metode Economic Order Quantity Pada Aplikasi Pengendalian Bahan Produksi Sandal Mirado. Jurnal Teknik Informatika, 13(1), 31–42. https://doi.org/10.15408/jti.v13i1.15732
Hadi Wijaya, A., Ipriadi, & Fitri, W. (2024). Dasboard dan Visualisasi Reservasi Buka Puasa di Hotel XYZ Menggunakan Looker Studio & Google Form. Journal Of Informatics And Busisnes, 01(04), 354–359.
Hanif, A. (2019). Sistem Informasi Sederhana Menggunakan Spreadsheet dan Macro Untuk Usaha Mikro Informal. Seminar Nasional Teknologi Komputer & Sains (SAINTEKS), 1(1), 851–855. https://www.prosiding.seminar-id.com/index.php/sainteks/article/view/241
Haydar, R., & Nurrahman, A. A. (2022). Aplikasi Dashboard Pengendalian Persediaan Bahan Baku Menggunakan EOQ Probabilistik pada Pabrik Beras. Jurnal Riset Teknik Industri, 151–160. https://doi.org/10.29313/jrti.v2i2.1329
Jariyah, A., Indrabulan, T., Ilyas Syarif, M., & Krisna Astuti Sakir, R. (2022). Pemanfaatan Looker Studio untuk Visualisasi Kinerja Program Studi D4 Teknik Multimedia dan Jaringan. Jurnal Multidisiplin Ilmu, 1(4), 2828–6863.
Laoli, S., Zai, K. S., & Lase, N. K. (2022). Penerapan Metode Economic Order Quantity (EOQ), Reorder Point (ROP), dan Safety Stock (SS) dalam Mengelola Manajemen Persediaan di Grand Kartika GunungSitoli. Jurnal EMBA: Jurnal Riset Ekonomi, Manajemen, Bisnis Dan Akuntansi, 10(4), 1269–1279.
Nisa, F., Suharman, H., & Abdul Hasyir, D. (2020). Ketidakpastian Permintaan Pelanggan Sebagai Pemicu Manajemen Persediaan Dengan Pendekatan Analisis FSN. Syntax Literate ; Jurnal Ilmiah Indonesia, 5(4), 56. https://doi.org/10.36418/syntax-literate.v5i4.1067
Senthilnathan, S. (2019). Economic Order Quantity. In SSRN Electronic Journal (Vol. 45). SSRN Electronic Journal. https://doi.org/10.1007/1-4020-0611-x_268
Setiawan, R., Budiharto, W., Kartowisastro, I. H., & Prabowo, H. (2020). Finding model through latent semantic approach to reveal the topic of discussion in discussion forum. Education and Information Technologies, 25(1), 31–50. https://doi.org/10.1007/s10639-019-09901-7
Downloads
Published
How to Cite
Issue
Section
License
The copyright to this article is transferred to Universitas Mercu Buana (UMB) if and when the article is accepted for publication. The undersigned hereby transfers any and all rights in and to the paper including without limitation all copyrights to UMB. The undersigned hereby represents and warrants that the paper is original and that he/she is the author of the paper, except for material that is clearly identified as to its original source, with permission notices from the copyright owners where required. The undersigned represents that he/she has the power and authority to make and execute this assignment.
We declare that:
1. This paper has not been published in the same form elsewhere.
2. It will not be submitted anywhere else for publication prior to acceptance/rejection by this Journal.
3. A copyright permission is obtained for materials published elsewhere and which require this permission for reproduction.
Furthermore, I/We hereby transfer the unlimited rights of publication of the above mentioned paper in whole to UMB. The copyright transfer covers the exclusive right to reproduce and distribute the article, including reprints, translations, photographic reproductions, microform, electronic form (offline, online) or any other reproductions of similar nature.
The corresponding author signs for and accepts responsibility for releasing this material on behalf of any and all co-authors. This agreement is to be signed by at least one of the authors who have obtained the assent of the co-author(s) where applicable. After submission of this agreement signed by the corresponding author, changes of authorship or in the order of the authors listed will not be accepted.
Retained Rights/Terms and Conditions
1. Authors retain all proprietary rights in any process, procedure, or article of manufacture described in the Work.
2. Authors may reproduce or authorize others to reproduce the Work or derivative works for the authors personal use or for company use, provided that the source and the UMB copyright notice are indicated, the copies are not used in any way that implies UMB endorsement of a product or service of any employer, and the copies themselves are not offered for sale.
3. Although authors are permitted to re-use all or portions of the Work in other works, this does not include granting third-party requests for reprinting, republishing, or other types of re-use.
