JURTEKSI (Jurnal Teknologi dan Sistem Informas.
ISSN 2407-1811 (Prin.
Vol XII No 3.
June 2026, hlm.
423 Ae 428 ISSN 2550-0201 (Onlin.
DOI: https://doi.
org/10.
33330/jurteksi.
Available online at https://jurnal.
id/index.
php/jurteksi OPTIMIZATION OF FAST-MOVING DRUG INVENTORY USING THE WEIGHTED PRODUCT METHOD
AT ANNISA DRUGSTORE
Rafika Dayanti1*.
Neni Mulyani1.
Ahmad Muhazir1 Information System.
Universitas Royal email: *rafikadayanti796@gmail.
Abstract: Managing fast-moving drug inventory requires accurate supplier selection to ensure product availability and minimize the risk of overstock and out-of-stock conditions.
At Annisa Pharmacy, the supplier selection process has traditionally relied on experience and subjective judgment, which may lead to less optimal decisions.
This study aims to design and implement a Decision Support System (DSS) for selecting fast-moving drug suppliers using the Weighted Product (WP) method.
The WP method is applied because it is capable of processing multiple criteria simultaneously through structured weighting, including demand frequency, delivery lead time, remaining shelf life, purchase price, and profit margin.
The system is developed as a webbased application using PHP and MySQL.
The results show that the implementation of the Weighted Product method successfully produces preference values and accurate supplier rankings, enabling the system to correctly determine the most optimal fast-moving drug supplier based on the defined criteria.
Therefore, the developed system can assist the owner of Annisa Pharmacy in making more precise, objective, and structured inventory procurement decisions.
Keywords: decision support system.
drug inventory.
supplier selection.
weighted product Abstrak: Pengelolaan stok obat fast moving di Toko Obat Annisa memerlukan ketepatan dalam menentukan supplier agar ketersediaan obat tetap terjaga dan risiko overstock maupun out of stock dapat diminimalkan.
Selama ini, proses pemilihan supplier masih dilakukan secara konvensional berdasarkan pengalaman, sehingga berpotensi menghasilkan keputusan yang kurang Penelitian ini bertujuan untuk merancang dan mengimplementasikan Sistem Pendukung Keputusan (SPK) pemilihan supplier obat fast moving menggunakan metode Weighted Product (WP).
Metode WP digunakan karena mampu mengolah beberapa kriteria secara simultan melalui pembobotan yang terstruktur, meliputi frekuensi permintaan, lead time, sisa masa kedaluwarsa, harga beli, dan margin keuntungan.
Sistem dikembangkan berbasis web menggunakan bahasa pemrograman PHP dan basis data MySQL.
Hasil penelitian menunjukkan bahwa penerapan metode Weighted Product mampu menghasilkan nilai preferensi dan perankingan supplier secara objektif, sehingga sistem berhasil menentukan supplier obat fast moving yang paling optimal sesuai dengan kriteria yang telah ditetapkan.
Dengan demikian, sistem yang dibangun dapat membantu pemilik Toko Obat Annisa dalam mengambil keputusan pengadaan stok obat secara lebih tepat, objektif, dan terstruktur.
Kata kunci: sistem pendukung keputusan.
toko obat.
pemilihan pemasok.
weighted product JURTEKSI (Jurnal Teknologi dan Sistem Informas.
ISSN 2407-1811 (Prin.
Vol XII No 3.
June 2026, hlm.
423 Ae 428 ISSN 2550-0201 (Onlin.
DOI: https://doi.
org/10.
33330/jurteksi.
Available online at https://jurnal.
id/index.
php/jurteksi Building upon these previous findings, this study not only applies the Weighted Product (WP) method within a Decision Support System framework but also strengthens the validity of the results through statistical comparison.
The outcomes generated from the WP calculation are subsequently aligned with computations performed using SPSS based on the value of each criterion and the V vector to determine the best alternative ranking as the final decision.
The integration of the Weighted Product method into a Decision Support System enables a more objective and consistent drug inventory procurement process.
The Weighted Product (WP) method applies a multiplicative calculation approach and differs from the Simple Additive Weighting (SAW) method in the initial treatment of the decision attribute evaluation results, which allows the WP method to provide a more proportional assessment in multicriteria decision-making processes.
A research gap exists in the limited integration of supplier evaluation and fast-moving drug inventory indicators within a unified decision framework, especially at the community drugstore level.
Therefore, this research develops a web-based Decision Support System using the Weighted Product method based on five criteria: demand frequency, lead time, remaining shelf life, purchase price, and profit margin to optimize supplier selection for fast-moving drugs at Annisa Drugstore.
INTRODUCTION
The rapid development of information technology has made digital transformation a fundamental requirement in strategic business decisionmaking, including in the healthcare sector.
Inventory management of pharmaceutical products requires accurate and data-driven decisions to ensure product availability while improving operational This process involves a careful evaluation of various factors, including quality, price, suitability to organizational needs, brand reputation, and customer reviews .
Several previous studies have applied MCDM methods in various contexts.
Renaldo et al.
emphasized the importance of integrating data-driven systems to enhance organizational decision quality, yet their study did not specifically address pharmaceutical inventory management.
Putro et al.
several MCDM methods and demonstrated differences in ranking sensitivity.
however, their focus was limited to methodological comparison rather than practical implementation.
Rafiqi et al.
validated the effectiveness of the Weighted Product (WP) method in vendor selection, although the application was restricted to the IT sector .
Nasution et al.
combined WP with a fuzzy approach to increase flexibility in decision-making but did not integrate it into inventory sustainability strategies.
Meanwhile.
Komputer et al.
applied the SAW method for determining drug stock quantities, yet did not incorporate supplier performance evaluation into procurement optimization.
Decision Support System is required to assist in solving semi-structured problems by simultaneously considering multiple criteria.
METHOD
This framework represents the steps that will be carried out to solve the problems discussed in this study.
The research framework is illustrated in the figure below.
JURTEKSI (Jurnal Teknologi dan Sistem Informas.
ISSN 2407-1811 (Prin.
Vol XII No 3.
June 2026, hlm.
423 Ae 428 ISSN 2550-0201 (Onlin.
DOI: https://doi.
org/10.
33330/jurteksi.
Available online at https://jurnal.
id/index.
php/jurteksi easy to understand, making it suitable for decision-making involving single and criteria.
RESULT AND DISCUSSION
The objects of this study are suppliers that provide fast-moving drug inventory, which include the following:
Tabel 1.
Alternative Alternative PT Kalbe Farma Tbk PT Kimia Farma Tbk PT Industri Jamu dan Farmasi Sido Muncul Tbk PT Bio Farma (Perser.
PT Dexa Medica PT Phapros Tbk PT Sanbe Farma PT Tempo Scan Pacific Tbk PT Bernofarm Pharmaceutical PT Soho Global Health Tbk Image 1.
Research Framework The research methodology is structured into several sequential stages to ensure that the problem-solving process is carried out systematically.
The initial stage begins with the identification of problems related to the management of fast-moving drug inventory at Annisa Drugstore.
Subsequently, relevant data are collected, including operational data and supporting data required in the decision-making process.
In this context, proper data management is essential, as one of the standards of data management involves the administration of database systems related to maintenance and development, which aims to manage and monitor data availability during its use .
These data are then processed in the system analysis stage to identify system requirements and formulate appropriate solutions.
A Decision Support System is designed and implemented by integrating the Weighted Product method to determine the best alternative.
The final stage involves system testing to evaluate performance and ensure the recommendations align with the research objectives.
The Weighted Product (WP) method is chosen because its concept is simple and Code
A10
Tabel 2.
Criteria Criteria Demand Frequency (C.
Lead Time (C.
Remaining Shelf Life (C.
Average Purchase Price (C.
Profit Margin (C.
Cost/Benefit Benefit Cost Benefit Cost Benefit The criteria weights in this study were determined through interviews with the pharmacy as the decision-maker in pharmaceutical inventory management.
The obtained weights were then normal425 JURTEKSI (Jurnal Teknologi dan Sistem Informas.
ISSN 2407-1811 (Prin.
Vol XII No 3.
June 2026, hlm.
423 Ae 428 ISSN 2550-0201 (Onlin.
DOI: https://doi.
org/10.
33330/jurteksi.
Available online at https://jurnal.
id/index.
php/jurteksi ized so that the total equals 1, according to the requirements of the Weighted Product (WP) method.
These normalized weights are used to calculate the preference values of each alternative.
The normalization process is performed using the following formula:
Tabel 4.
Alternative Values Alternative Wj = The results are presented as fol-
A10
W1 =
= 0,25
W2 =
The calculation of the S vector value is:
Tabel 5.
Result of S Vector
= 0,20
W3 =
Alternatif
2,669634
2,966767
2,626576
2,108820
2,492077
2,005827
2,563448
2,566330
2,418395
A10
2,232691
Result = 24,650565 = 0,20 W4 = = 0,15 W5 = = 0,20 After obtaining the S value for each alternative, next step calculate vector value Tabel 3.
Weight Normalization Table 6 Vector Result
Weight
Result
0,25
Alternative Rangking 0,108299 0,120353 0,15 0,106552 0,085549 0,101096 Result = 0,081370 0,103991 0,104108 0,098107 A10
0,090574
Next, a score is assigned to each alternative for every criterion.
JURTEKSI (Jurnal Teknologi dan Sistem Informas.
ISSN 2407-1811 (Prin.
Vol XII No 3.
June 2026, hlm.
423 Ae 428 ISSN 2550-0201 (Onlin.
DOI: https://doi.
org/10.
33330/jurteksi.
Available online at https://jurnal.
id/index.
php/jurteksi Based on the results the ranking can be performed using the V values, with the highest value obtained as shown tion scores for criteria C1AeC5, forming the decision matrix for the subsequent WP computation.
Image 4.
Assessment matrix input The WP computation page presents the processing stage, including weight normalization .
ith cost-type criteria treated using negative exponent.
Svector calculation, and V-vector computation to obtain the final preference values and supplier ranking.
Image 2.
Chart of Result From the ranking results obtained using the Weighted Product method, the highest value is 0.
120353, which corresponds to alternative A2, namely PT Kimia Farma Tbk.
To support the reported results, the following figures present the system information view of the developed webbased decision support system.
The interface demonstrates how supplier assessment data are entered and how the WP method is executed to generate the ranking and recommendation.
The dashboard view summarizes the number of suppliers and criteria and displays the final recommendation generated by the WP results.
Image 5.
Weighted Product (WP) computation results.
CONCLUSION
The findings of this study demonstrate that PT Kimia Farma achieves the highest preference value based on the Weighted Product (WP) method, indicating its suitability as the most favorable supplier among the evaluated alternatives.
This result is influenced by its consistent performance across key decision Image 3.
Dashboard Analysis The assessment matrix interface is used to input each supplierAos evalua427 JURTEKSI (Jurnal Teknologi dan Sistem Informas.
ISSN 2407-1811 (Prin.
Vol XII No 3.
June 2026, hlm.
423 Ae 428 ISSN 2550-0201 (Onlin.
DOI: https://doi.
org/10.
33330/jurteksi.
Available online at https://jurnal.
id/index.
php/jurteksi criteria, such as demand frequency, delivery lead time, purchase price, remaining shelf life, and profit margin.
From a practical perspective, these results suggest that the pharmacy owner should prioritize PT Kimia Farma as the primary supplier for fast-moving pharmaceutical At the same time, suppliers with relatively competitive preference values can be utilized as secondary options to ensure supply reliability and reduce the risk of dependency on a single The integration of the WP method into a Decision Support System facilitates an objective and systematic evaluation process by consolidating multiple criteria into a single assessment framework.
Consequently, the resulting supplier ranking serves as a data-driven reference that can support more effective procurement decisions, enhance operational efficiency, and promote sustainable inventory management at Annisa Drugstore.
BIBLIOGRAPHY