Implementation of Improved Apriori Algorithm for Drug Planograms in XYZ Pharmacies and Analysis of Medicinal Procurement Planning Using ABC Critical Index Methods

Abstract

Abstract In conducting transactions in the present era where people no longer carry out transactions manually, where now there is modern technology, so that it can make it easier to conduct transactions, such as pharmacies. Pharmacy owners can now put their medicines in a position that matches the combination of goods sold and can also conduct an analysis of drug procurement planning. Improved Apriori Algorithm Method is one of the methods to assist in finding the combination of goods most often purchased by transforming data into a matrix and then cutting columns and rows according to the minimum amount of support specified and the iteration values that are ongoing, then displaying the results of the combination that is in accordance with the specified minimum confidence and the ABC Critical Index Method to analyze the critical stock procurement planning using the use value, investment value and VEN value to calculate the critical index value for each drug, after which each drug will be included in each class vary based on the level of drug sales. The results of testing manual calculations and programs obtained on 101 drug data and 64 transaction data in the Improved Apriori method are 4 drugs that can be combined with a predetermined minimum confidence value of 100%. Then in the Critical Index ABC method there is a percentage of drugs that go to group A is 17.82%, Group B is 66.34% and Group C is 15.84%.