Analysis and Design of a Stock and Sales Management System Using the FIFO Method at Pakis Medika Utama Pharmacy
DOI:
https://doi.org/10.35870/ijsecs.v6i2.7341Keywords:
Information System, FIFO, Drug Stock Management, Drug Sales, PrototypingAbstract
Apotek Pakis Medika Utama still uses manual methods for managing drug inventory and recording sales, resulting in several problems, including recording errors, difficulties in monitoring stock levels in real time, delays in preparing reports, and the absence of notifications for drugs approaching their expiration dates. In addition, the pharmacy frequently receives drug supplies from Pharmaceutical Wholesalers (PBF) with relatively short expiration periods, requiring more structured inventory management to minimize the risk of stock accumulation and losses caused by expired drugs. This study aims to analyze and design a drug inventory and sales management system using the FIFO (First In, First Out) method by considering drug batch numbers and expiration dates. The system development method used is Prototyping, which includes requirements gathering through observation, interviews, and documentation, followed by system design. The proposed system is designed using the Laravel framework and MySQL database. The design results indicate that the proposed system is designed to manage drug data, support sales transactions based on the FIFO method, monitor drug stock and expiration dates, provide notifications for minimum stock levels and drugs approaching expiration through the dashboard and email, and generate inventory and sales reports automatically. This system design is expected to support more effective, integrated, and structured inventory and sales management at Apotek Pakis Medika Utama.
Downloads
References
Devega, M., Yuhelmi, Y., & Darmayunata, Y. (2024). Pembangunan sistem inventori apotek menggunakan metode FIFO dan FEFO. ZONAsi: Jurnal Sistem Informasi, 6(1), 159–172. https://doi.org/10.31849/zn.v6i1.17318
Evykasari, N. P., Darmanto, E., & Muzid, S. (2025). Sistem informasi manajemen persediaan obat di Apotek Jekulo menggunakan metode FEFO dan ROP. JEKIN: Jurnal Teknik Informatika, 5(2), 936–949. https://doi.org/10.58794/jekin.v5i2.1618
Fachrurrazi, S., Muthmainnah, & Maulana, M. F. (2023). Application of the FIFO model in the drug inventory information system at the Asyfa Krueng Mane Pharmacy. Multica Science and Technology, 3(1), 142–146. https://doi.org/10.47002/mst.v3i1.427
Fadillah, N. S., & Sutopo, J. (2024). Implementasi metode FIFO pada sistem informasi dalam mengelola persediaan barang berbasis web. Jurnal Riset dan Aplikasi Mahasiswa Informatika, 5(2), 357–366.
Hamidy, F., Surahman, A., & Famelia, R. H. (2022). Perancangan sistem informasi akuntansi apotek menggunakan metode MPKP (FIFO). Jurnal Tekno Kompak, 16(2), 188–199.
Natsir, F., Nastiti, T. I., & Acep. (2025). Desain sistem informasi manajemen stok obat berbasis metode FIFO pada Apotek Ban Cun Kramat Jaya. JUTEK: Jurnal Teknologi, 2(1), 1–7.
Ogbewele, E., Mbata, A. O., & Nwosu, N. T. (2024). Optimizing pharmaceutical inventory management: A global framework for efficiency and cost reduction. International Journal of Management & Entrepreneurship Research, 6(10), 3357–3371. https://doi.org/10.51594/ijmer.v6i10.1638
Prasetyo, M. A. P., et al. (2023). Perancangan sistem informasi persediaan obat menggunakan metode FIFO berbasis web pada Apotek Risma. JIFORTY: Jurnal Informatika Fortuity, 4(1), 25–34.
Rezeki, D. S., Silaen, M., Girsang, E., & Nasution, S. R. (2022). Evaluation of drug storage using FIFO/FEFO methods in Royal Prima Medan Hospital Pharmacy Installation. International Journal of Health and Pharmaceutical, 2(1), 45–53.
Wulanndari, G., et al. (2026). Penerapan metode FIFO FEFO sistem informasi penjualan obat berbasis website pada Apotek Mitra Ummat Mandiraja. Jurnal Sistematis, 5(1), 23–38.
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Annisa Zalzabilla Rahmawati, Eko Purwanto, Sundari Sundari
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
1. Copyright Retention and Open Access License
Authors retain copyright of their work and grant the journal non-exclusive right of first publication under the Creative Commons Attribution 4.0 International License (CC BY 4.0).
This license allows unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
2. Rights Granted Under CC BY 4.0
Under this license, readers are free to:
- Share — copy and redistribute the material in any medium or format
- Adapt — remix, transform, and build upon the material for any purpose, including commercial use
- No additional restrictions — the licensor cannot revoke these freedoms as long as license terms are followed
3. Attribution Requirements
All uses must include:
- Proper citation of the original work
- Link to the Creative Commons license
- Indication if changes were made to the original work
- No suggestion that the licensor endorses the user or their use
4. Additional Distribution Rights
Authors may:
- Deposit the published version in institutional repositories
- Share through academic social networks
- Include in books, monographs, or other publications
- Post on personal or institutional websites
Requirement: All additional distributions must maintain the CC BY 4.0 license and proper attribution.
5. Self-Archiving and Pre-Print Sharing
Authors are encouraged to:
- Share pre-prints and post-prints online
- Deposit in subject-specific repositories (e.g., arXiv, bioRxiv)
- Engage in scholarly communication throughout the publication process
6. Open Access Commitment
This journal provides immediate open access to all content, supporting the global exchange of knowledge without financial, legal, or technical barriers.
