Design and Implementation of a Product Expiry Alert Management System (a Case Study of Shoprite, Enugu)
Chapter One
OBJECTIVE OF THE STUDY
- To develop the easy management of the inventory.
- To handle the inventory details like purchase details, manufacturer details and expiration dates of Products.
- To maintain a record of batches of product brought to the store.
- To keep a record of product brought to the store.
- To detect about to expire and expired products in the store.
- To calculate the loss on expired products.
CHAPTER TWO
LITERATURE REVIEW
DRUGS EXPIRATION AND CONSUMER PERCEPTION OF EXPIRY DATE
Product expiration is a problem which commonly affects Manufacturing Industries in Nigeria. According to Farrugia (2005), expiry date is defined as an assurance that a drug product should meet applicable standards of identity, strength, quality and purity at the time of use. Farrugia (2005) further indicated that the definition is only applicable under storage conditions specified by the manufacturer on the labeling and packaging. Nakyanzi et al. (2010) maintained that the medicinal supply chain process needs to be managed to avoid wastage, pilferage, misuse, and expiry in developing countries where budgets are tight. According to Thron et al. (2007) higher inventory add to the average age of the product and that lead to more expired products. Tumwine et al. (2010) reported that expired Product stock is a waste of resources, which cannot be afforded in a resource-constrained nation. Poor quantification practices and donors ordering large quantities of Product without the departmental inputs contributed to large quantities of expired Product in Uganda (Tumwine et al., 2010). Patients usually perceive the expiration date as an important indicator of the drug’s quality, short-dated drug products lessen patients’ interest which indicates that demand is related to the remainder of shelf life (Hug et al., 2005). Antai and Mutshinda (2010) supported the view that pharmaceutical chains continuously have to move drug products back and forth between pharmacies and manufacturers because of the expiry dates attached to the delivered Product. Antai and Mutshinda (2010) further indicated that expiration of Product randomly occur in pharmaceutical inventory.
CONTROL AND MANAGEMENT OF MEDICALS SUPPLY
Mustaffa and Potter (2009) reported that awareness of the supply chain management within hospitals is low and managers are not properly equipped to control the supply of medication. Due to the severity of using expired or ineffective Product, it is critical that pharmaceutical outlets get the reverse logistics right from the start and the most common causes of returns in pharmaceutical outlets are expired Product and recalls (Kumar et al., 2009). Since most clinical decisions involve products management and medical supplies, supply chain activities have an important role in effective and efficient service delivery in hospitals (Bendavid et al., 2010). Bhakoo and Chan (2011) indicated that pharmaceutical products have long development cycles and this presents a challenge for supply chain managers in hospitals who have to manage their internal relationships with medical practitioners while simultaneously managing their external relationships with pharmaceutical manufacturers, wholesalers and distributors. Huq et al. (2004) maintained that organization may experience a partial loss of revenues when their inventory gets close to expiration date and customers become less likely to purchase products with short expiry date. Vries and Huijsman (2011) stated that in healthcare sector, the basic rationale of a supply chain management approach is founded in the belief that intensive co-ordination and integration between pharmaceuticals, medical devices and patient flow might lead to a better health supply chain performances.
MANAGEMENT OF PRODUCT INVENTORY
Thron et al (2007) indicated that owing to the age of products held in inventory, product issuing and replenishment strategies are completely crucial and need to be considered more comprehensively. The unique nature of the supply chain for pharmaceuticals makes managing complex information for supply chain effectiveness challenging, and lack of proper information mechanisms may lead to poor inventory control methods (Asamoah et al., 2011). According to the study conducted by Thron et al. (2007), the frequency and place of expiration control such as storage, distribution center or retailer-shelf determine the timelines of expiry or product flow information. Burt et al (2003) maintained that in order to develop ideas of how to reduce waste throughout supply chain cycle, one has to know and understand where that waste has been generated. Burt et al (2003) further indicated that any warehouse accumulates salvageable or waste material from breakage, deterioration and errors in record keeping regardless of how properly the warehouse is managed. In a book written by Magad and Amos (1995), it was stated that ‘some materials are more susceptible to spoilage than others; material handling systems were designed to consider the shelf-life of stored items’.
PRODUCTS ISSUES AND DEMANDS
According to Thron et al. (2007), it should be fairly obvious that a FIFO approach is most advisable within a frame-work of products that have a short life span. Dobler and David (1996) agreed that reduction of outdated products costs could be realized by developing systems to detect slow moving and in-active materials. Hugos (2006) indicated that ‘the aim of inventory management is to reduce costs of inventory as much as possible while still maintaining the service levels that the customers require’. Dobler and Burt (1996) maintained that deterioration, damage and pilferage of products are controllable to a great extent by managers.
CHAPTER THREE
METHODOLOGY AND ANALYSIS OF THE EXISTING
GENERAL DESCRIPTION OF THE EXISTING SYSTEM
The existing system is used in stores, supermarket and pharmacies, the existing involve recording each product brought to store in an inventory log book in which the store keeper will constantly check to know which product is about to expire and which product has already expired. These process which very tedious and error prone, the store keeper might not really detect all products that are about to expire or already expired.
FACT FINDING METHODS USED
There are two main sources of data collection in carrying out this study, information was basically obtained from the two sources which are:
(a) Primary source and
(b) Secondary source
Primary Source
Primary source refers to the sources of collecting original data in which the researcher makes use of empirical approach such as personal interview, questionnaires or observation.
In my research, I used a method of observation were I was attentive to how contact are being operated and saved using a manual method.
Secondary Source
The need of the secondary sources of data for this kind of project cannot be over emphasized. The secondary data were obtained by me from the library source and most of the information from the library research has been covered in my literature review in the previous chapter of this project.
CHAPTER FOUR
DESIGN AND IMPLEMENTATION OF THE NEW SYSTEM
DESIGN STANDARD
The system comprises of two forms add batch and add product form, two database table where are batches and products table. The batch form is used to collect data about each batch of product brought to store and stored in the batch table in the database. The product form is used to collect data about each product and stored in the products tables
CHAPTER FIVE
SUMMARY, CONCLUSION AND RECOMMENDATIONS
SUMMARY
In summary, this Academic Work project has done a great deal of giving a broad knowledge of what Product Expiration system is all about and how it can be operated.
CONCLUSION
From this Academic Work, I have been able to show the application of database management system(Product Expiration system) and how it can be used, it has achieve the full aim of letting the public know what computer system is all about.
RECOMMENDATION
I hereby recommend this Academic work to be used by staff and management of ……. and indeed, any other Institution with similar structure and organizational framework for the following reasons:
- The academic work has been able to solve the problem related to easy access of contact information.
- It has helped the user on how to use the Product Expiration system easily.
REFERENCES
- Antai, I. and Mutshinda C.M. 2010. Health status assessement using reverse supply chain data. Management Research Review. 33 (2) : 111-122.
- Asamoah, D., Abor, P., and Opare, M. 2011. An examination of pharmaceutical supply chain for artemisinin-based combination therapies in Ghana. Management Research Review. 34 (7) : 790-809.
- Bendavid, L., Boeck, H., and Phillipe, R. 2010. Redesigning the replenishment process of medical supplies in hospitals with radio-frequency identification technology.Business Process Management Journal. 16 (6) : 991-1013.
- Bhakoo, V., and Chan, C. 2011. Collaborative implementation of e-business process within the health-care supply cahin: the Monash Pharmacy Project. Supply Chain Management: An International Journal. 16 (3) : 184-193.
- Bjorkman, I.K., Schmidt, I.K., Holstrom, I., and Bernsten, C.B. 2007. Developing the role of the drug and therapeutics committees: perceptions of chairs. International Journal of Health Care Quality Assurance. 20(2) : 161-178.
