Computer – based Drug Sales and Inventory Control System and its Applications in Pharmaceutical Stores

Full Text (PDF, 553KB), PP.30-39

Views: 0 Downloads: 0

Author(s)

Ogwo Eme 1,* Uchenna Ugboaja C. A. 1 Faustina Odinakachi Uwazuruike 1 Chukwu Uka Ukpai 2

1. Akanu Ibiam Federal Polytechnic, Unwana, Nigeria

2. Computer Unit, Birnin Kebbi Local Government Secretariat,Kebbi, Nigeria

* Corresponding author.

DOI: https://doi.org/10.5815/ijeme.2018.01.04

Received: 1 Mar. 2017 / Revised: 10 Jun. 2017 / Accepted: 11 Sep. 2017 / Published: 8 Jan. 2018

Index Terms

Computer-based, Control, Drugs, Inventory, Pharmacy, Sales, Stock

Abstract

This paper presents a careful study and analysis of an existing manual sales and inventory control system of a pharmaceutical store and aimed at designing and developing a computer-based system in order to increase the efficiency and accuracy of the business operations of the pharmaceutical store. The study was carried out to reduce the problems of inconsistency and inaccuracy of sales and drug data inherent in the existing manual system of the pharmacy. An analysis of the current manual system was done to get a better understanding of the system. The Rapid Application Development (RAD) methodology was used in this work to implement an iterative program which is suitable for stand-alone applications that can be updated from time to time as may be required by the computer -based system. Testing was done in every phase of the development life cycle to ensure that the new system works properly. The software was developed and implemented using Visual Basic 6.0 programming language and Microsoft Access for the database platform. The software developed provides alert of every expired drug and minimum quantity of each drug available in stock. Other activities such as product sales, drugs and users registration, and periodic reports generation can also be carried out with the new system.

Cite This Paper

Ogwo Eme, Uchenna Ugboaja C. A., Faustina Odinakachi Uwazuruike, Chukwu Uka Ukpai,"Computer – based Drug Sales and Inventory Control System and its Applications in Pharmaceutical Stores", International Journal of Education and Management Engineering(IJEME), Vol.8, No.1, pp.30-39, 2018. DOI: 10.5815/ijeme.2018.01.04

Reference

[1] Web Finance, "The Business Dictionary", 2016.

[2] Surabhi, R. and Suen, O, “Inventory Management: A tool of identifying Items that Need Greater Attention for Control”. A Journal of Inventory Control and Management, Toronto. Vol. 1. pp. 45-51, 2012.

[3] Mugo, R. “Effectiveness of Electronic Inventory Systems on Customer Service Delivery in selected Supermarkets in Kenya.”European Journal of Business and Management.25(2), 32-38,2014.

[4] Ellis, D, “The Uses of Computer in Inventory Control” .New York University: Elsevier Inc, 2012.

[5] National Community Pharmacists Association (Managing the Pharmacy Inventor: .An annual Report, 2010.

[6] Fasanghari, M., Farzard H.R., and Kamal,S.C, “Assessing the Impact of Information Technology on Supply Chain Management, Word Applied Science Journal 4(1): 87 – 93,2008.

[7] Grover, V., Teng, J and Fiddler,K,” Investigating the Role of Information Technology in Building Buyer-Supper Relationships, J. Association Information Systems 3: 217 -245, 2002.

[8] Sweeney, E, “Managing the Supply Chain: The Role of Communication and Information Technonolgy (ICT) as a Key Enabler of the Process”, Business Ireland, Summer Issue pp 105 -109, June, 2005.

[9] Sauders, S, “Impacts of ICT in Inventory Control” Nairobi: Acts Press, pp. 73-81, 1997.

[10] Blackburn, J, “Fundamentals of Purchasing and Inventory Control for Certified Pharmacy Technicians”: A Knowledge Based Course. New York: Greenwood, (2010).

[11] Dunning, W. D, “Service Management, Operations, Strategy and Information Technology, 2nd Edition (pp. 262 – 295).New York, NY: Irwin McGraw-Hill, (2007).

[12] Draper, L, "Computerized Dispensing System", The New York Times, (2010).

[13] Damle, K., and Puri, K., “The Right Pharmacy Management System” .E- Journal of Pharmacy Management, 28(2), 6-9, (2010).

[14] Chopra, S, “Supply Chain Management”, 2(2).pp 33- 41, 2004.

[15] Waters, D, “Operations Management, 2nd Edition” Harlow: Pearson Education, (pp. 48-52). 2002.

[16] Keong, C., Ahmad, M., Sulaiman, N. and Ismail, M, ”Proposing a Non-traditional Ordering Methodology in Achieving Optimal Flexibility with Minimal Inventory Risk” .Journal of Marketing and Logistics Vol.17 pp. 31-4, 2005.

[17] Paul, D. and Ravichandran, K., “Best Practice Management in Inventory Control” London: D.P Publications Ltd, (pp. 192 – 214),2010

[18] Dilip Kumar Choubey, Sanchita Paul, "GA_MLP NN: A Hybrid Intelligent System for Diabetes Disease Diagnosis", International Journal of Intelligent Systems and Applications (IJISA), Vol.8, No.1, pp.49-59, 2016. DOI: 10.5815/ijisa.2016.01.06

[19] D. Asir Antony Gnana Singh, E. Jebamalar Leavline, R. Priyanka, P. Padma Priya,"Dimensionality Reduction using Genetic Algorithm for Improving Accuracy in Medical Diagnosis", International Journal of Intelligent Systems and Applications(IJISA), Vol.8, No.1, pp.67-73, 2016. DOI: 10.5815/ijisa.2016.01.08