International Journal Software Engineering and Computer Science (IJSECS)
Vol. 6 No. 2 (2026): AUGUST 2026

Analysis and Design of a Stock and Sales Management System Using the FIFO Method at Pakis Medika Utama Pharmacy

Annisa Zalzabilla Rahmawati (Universitas Duta Bangsa)
Eko Purwanto (Universitas Duta Bangsa)
Sundari Sundari (Universitas Duta Bangsa)



Article Info

Publish Date
01 Aug 2026

Abstract

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.

Copyrights © 2026






Journal Info

Abbrev

ijsecs

Publisher

Subject

Computer Science & IT

Description

IJSECS is committed to bridge the theory and practice of information technology and computer science. From innovative ideas to specific algorithms and full system implementations, IJSECS publishes original, peer-reviewed, and high quality articles in the areas of information technology and computer ...