Search Repository Universitas Baiturrahim

EFEKTIVITAS SISTEM INFORMASI DAN MANAJEMEN (SIM) PENYIMPANAN STOCK OPNAME BAHAN KERING BERBASIS SPREADSHEET
DI RSUD BAYUNG LENCIR

Siti Maria Ulfa
NPM 202432008

ABSTRAK

Rumah sakit merupakan institusi pelayanan kesehatan yang menyelenggarakan pelayanan kesehatan perorangan secara paripurna. Salah satu tahapan penting dalam penyelenggaraan makanan yaitu tahap penyimpanan bahan makanan. Penyimpanan bahan makanan merupakan suatu tata cara menata, menyimpan, memelihara keamanan bahan makanan baik kualitas maupun kuantitas di gudang penyimpanan bahan makanan disertai dengan pencatatan dan pelaporan stok bahan makanan. Penelitian dengan jenis deskriptif kuantitatif ini bertujuan untuk mengetahui Efektivitas Sistem Informasi Dan Manajemen (SIM) Penyimpanan Stock Opname Bahan Kering Berbasis Spreadsheet Di RSUD Bayung Lencir. Penelitian dilakukan pada bulan Maret s.d Agustus 2025 di ruang instalasi gizi khususnya pada tempat penyimpanan bahan makanan kering sebelum diolah menjadi makanan bagi para pasien Rumah Sakit, dimulai dari proses penyiapan proposal, pengumpulan data awal, melakukan studi kepustakaan, mendesain model penelitian. Selanjutnya menganalisis efektifitas berdasarkan waktu, informasi bahan makanan serta sumberdaya pelaksana dengan mengembangan Sistem Informasi Dan Manajemen (SIM) Penggunaan Stock Opname Bahan Kering Berbasis Spreadsheet. Analisis dari penelitian menggunakan perbandingan pencatatan stock bahan kering dalam Gudang kering antara Sistem Informasi Dan Manajemen (SIM) berbasis paper dengan berbasis spreadsheet. Hasil penelitian menunjukkan bahwa Sistem Informasi Dan Manajemen (SIM) Penyimpanan Stock Opname Bahan Kering Berbasis Spreadsheet efektif berdasarkan waktu (< 5 menit), informasi bahan makanan (> 5 informasi bahan makanan) dan SDM tenaga pelaksana (< 2 orang) Di RSUD Bayung Lencir. RSUD Bayung Lencir dapat terus mengembangkan dan memanfaatkan template spreadsheet yang terstruktur dan otomatisasi sederhana misalnya melalui formula dan validasi data serta mengembangkan sistem berbasis software manajemen stok bahan makanan lainnya, sehingga kegiatan akan lebih efektitif, efisiensi, dan akurasi secara real time.

The Effectiveness of The Spreadsheet-Based Stock Opname Storage Information
and Management System (IMS) For Dry Goods at Bayung Lencir Regional
General Hospital
Siti Maria Ulfa
Abstract
Hospitals are healthcare service institutions that provide comprehensive individual
health services. One of the critical stages in food service management is the storage of
food ingredients. Food storage involves a procedure for arranging, storing, and
maintaining the safety of food ingredients, both in terms of quality and quantity, in the
food storage warehouse, accompanied by recording and reporting of food stock. This
descriptive quantitative research aims to determine the Effectiveness of the
Spreadsheet-Based Stock Opname Storage Information and Management System
(IMS) for Dry Goods at Bayung Lencir Regional General Hospital (RSUD). The study
was conducted from March to August 2025 in the nutrition installation room,
specifically in the dry food storage area before processing it into patient meals. The
process started from proposal preparation, initial data collection, literature review, and
designing the research model. Furthermore, the effectiveness was analyzed based on
time, food ingredient information, and executor resources by developing the
Spreadsheet-Based Dry Goods Stock Opname Storage Information and Management
System (IMS). The analysis compared the recording of dry stock in the dry warehouse
between the paper-based Information and Management System (IMS) and the
spreadsheet-based system. The results showed that the Spreadsheet-Based Stock
Opname Storage Information and Management System (IMS) for Dry Goods was
effective based on time (less than 5 minutes), food ingredient information (more than
5 pieces of food ingredient information), and implementing personnel resources (less
than 2 people) at Bayung Lencir Regional General Hospital. It is suggested that Bayung
Lencir Regional General Hospital should continue to develop and utilize structured
spreadsheet templates and simple automation, for example, through formulas and data
validation, and develop other food stock management software-based systems, which
will lead to more effective, efficient, and real-time accurate activities.