DEVELOPMENT AND EVALUATION OF A WEB-BASED CONSUMABLE INVENTORY MANAGEMENT SYSTEM USING THE SDLC FRAMEWORK: A CASE STUDY OF FORT PICHAIDAPHAK HOSPITAL
Article Sidebar
Main Article Content
Abstract
The objective of this study is to develop and evaluate the effectiveness of an information system for managing consumable inventory in the Information Technology Department of Pichai Dabhak Hospital. The existing system, which relies on Microsoft Excel, presents limitations in terms of accuracy, search delays, and inefficiencies in historical data retrieval. The development process followed all seven phases of the System Development Life Cycle (SDLC). The system was implemented as a web-based application using PHP programming language and MySQL as the database management system. The system includes key functions such as equipment registration, stock issuance, report generation, and automated alerts. It also supports data export in CSV and JSON formats and offers potential integration with ERP systems via API. System performance was evaluated using a five-point Likert-scale questionnaire and semi-structured interviews with five purposively selected users from the department.
The results showed a high level of user satisfaction (Mean = 4.49, S.D. = 0.51), particularly regarding ease of use, data accuracy, and processing speed. The developed system significantly improved operational efficiency, reduced processing time, and enhanced traceability. These findings suggest that the system is practical and scalable for use in other government agencies with similar inventory management needs, promoting systematic and sustainable resource administration.
Article Details
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
References
บุญชม ศรีสะอาด. (2560). การวิจัยเบื้องต้น (พิมพ์ครั้งที่ 10 ฉบับปรับปรุงใหม่). กรุงเทพฯ: สุวีริยาสาส์น.
พรนภัส เขียวอิ่ม และอภิสิทธิ์ แสงใส. (2566). การพัฒนาระบบจัดการคลังสินค้าโดยใช้สถาปัตยกรรม RESTful API. วารสารวิชาการวิทยาศาสตร์และเทคโนโลยี มหาวิทยาลัยราชภัฏธนบุรี, 1(1), 77-88.
โรงพยาบาลค่ายพิชัยดาบหัก. (2567). ประวัติโรงพยาบาล. สืบค้นเมื่อ 5 มิถุนายน 2567, จาก https://www.fpcdh-hospital.com/fpcdh
วรพล อารีย์, วัชริยา แช่มเมืองปัก, ภคพล แซ่ลิ่ม, และนันทวัฒน์ สาวิสิทธิ์. (2565). การประยุกต์ใช้เทคนิค ABC classification analysis เพื่อการจัดสินค้าคงคลังกลุ่มเครื่องปรุงรสและอาหารแห้ง: กรณีศึกษาห้างสรรพสินค้า XYZ. วารสารวิชาการ มทร.สุวรรณภูมิ (มนุษยศาสตร์และสังคมศาสตร์), 5(2), 153-166.
แสนยานุภาพ นามวงศ์ และจารี ทองคำ. (2565). การพัฒนาระบบจัดการคลังสินค้าออนไลน์ กรณีศึกษาห้างหุ้นส่วนจำกัดโปรฟาร์ม. วารสารวิทยาการสารสนเทศและเทคโนโลยีประยุกต์, 4(1), 62-70.
Adirektawon, S., Theeraroungchaisri, A., and Sakulbumrungsil, R. C. (2024). Efficiency of inventory in Thai hospitals: Comparing traditional and vendor-managed inventory systems. Logistics, 8(3), 89.
Al-Assaf, K., Alzahmi, W., Alshaikh, R., Bahroun, Z., & Ahmed, V. (2024). The relative importance of key factors for integrating Enterprise Resource Planning (ERP) systems and performance management practices in the UAE healthcare sector. Big Data and Cognitive Computing, 8(9), 122. https://doi.org/10.3390/bdcc8090122
Albassam, M., & Aslam, M. (2021). Testing internal quality control of clinical laboratory data using paired t-test under uncertainty. BioMed Research International, 2021, 5527845. https://doi.org/10.1155/2021/5527845
Ali, M. F. M. (2023). Build hospital management system using PHP framework. Iraqi Journal of Intelligent Computing and Informatics (IJICI), 2(2), 101-112. https://doi.org/10.52940/ijici.v2i2.35
Al-Jabri, I. M., & Roztocki, N. (2015). Adoption of ERP systems: Does information transparency matter?. Telematics and Informatics, 32(2), 300-310.
Bouncken, R. B., Czakon, W., & Schmitt, F. (2025). Purposeful sampling and saturation in qualitative research methodologies: Recommendations and review. Review of Managerial Science, 2025, 1-37. https://doi.org/10.1007/s11846-025-00881-2
Canon, J. G. F., dos Santos, R. J. R., de Carvalho, V. D. H., Monte, M. B. d. S., & de Barros, T. L. (2025). Integrated Logistics Management Through ERP System: A Case Study in an Emerging Regional Market. Logistics, 9(2), 59. https://doi.org/10.3390/logistics9020059
Engelmann, C., & Ametowobla, D. (2017). Advancing the integration of hospital IT : Pitfalls and perspectives when replacing specialized software for high-risk environments with enterprise system extensions. Applied Clinical Informatics, 8(2), 515-528.
Gao, Y., Guo, Y., Zheng, M., He, L., Guo, M., Jin, Z., and Fan, P. (2023). A refined management system focusing on medication dispensing errors: A 14-year retrospective study of a hospital outpatient pharmacy. Saudi Pharmaceutical Journal, 31(12), 101845.
Girsang, H. P., & Aldisa, R. T. (2024). Application of the system development life cycle (SDLC) method for mobile based academic information system design. International Journal of Society Reviews (INJOSER), 2(5), 1166-1171.
Grossi, A., Hoxhaj, I., Gabutti, I., Specchia, M. L., Cicchetti, A., Boccia, S., & de Waure, C. (2021). Hospital contextual factors affecting the implementation of health technologies: A systematic review. BMC Health Services Research, 21, 407.
Hajesmaeel-Gohari, S., Khordastan, F., Fatehi, F., Samzadeh, H., and Bahaadinbeigy, K. (2022). The most used questionnaires for evaluating satisfaction, usability, acceptance, and quality outcomes of mobile health. BMC Medical Informatics and Decision Making, 22(1), 22. https://doi.org/10.1186/s12911-022-01764-2
Hauschild, A. C., Martin, R., Holst, S. C., Wienbeck, J., & Heider, D. (2022). Guideline for software life cycle in health informatics. iScience, 25(12), 105534.
Khanna, R., Patel, K. A., and Rajnikant, P. N. (2023). Review presentation of different Economic Order Quantity (EOQ) models and their application. Journal of Advanced Zoology, 44(S-5), 1284-1288. https://doi.org/10.17762/jaz.v44iS-5.1210
Lin, Y. J., Cesana, G. V., Proistosescu, C., Zelinka, M. D., & Armour, K. C. (2025). The relative importance of forced and unforced temperature patterns in driving the time variation of low-cloud feedback. Journal of Climate, 38(2), 513-529. https://doi.org/10.1175/JCLI-D-24-0014.1
Malladi, S., Ramakrishna, G., Rao, K. R., & Babu, E. S. (2016). Analysis of legacy system in software application development: A comparative survey. International Journal of Electrical and Computer Engineering, 6(1), 292-297.
Micah, E. E. M., Adekunle, M. K., & Adeboye, A. (2019). Assessment of electronic inventory management systems and utilisation in the healthcare system in Abuja, FCT Nigeria. European Journal of Business and Innovation Research, 7(8), 1-17.
Rabiei, R., & Almasi, S. (2022). Requirements and challenges of hospital dashboards: A systematic literature review. BMC Medical Informatics and Decision Making, 22, 287. https://doi.org/10.1186/s12911-022-02037-8
Renjith, V., Yesodharan, R., Noronha, J. A., Ladd, E., & George, A. (2021). Qualitative methods in health care research. International Journal of Preventive Medicine, 12, 20. https://doi.org/10.4103/ijpvm.IJPVM_321_19
The Economic and Social Commission for Asia and the Pacific (ESCAP). (2022). Shaping our digital future : Asia-Pacific digital transformation report 2022. English: United Nations publication.
Utami, F. D., Puspitasari, W., & Saputra, M. (2020). Design of planning model for ERP system in warehouse management: An empirical study of public hospital in Indonesia. In IOP Conference Series: Materials Science and Engineering, 909(1), 012061.
