DESIGN AND IMPLEMENTATION OF A PRODUCT EXPIRY ALERT MANAGEMENT SYSTEM (A CASE STUDY OF SHOPRITE, ENUGU). A RESEARCH PROJECT MATERIAL ON COMPUTER SCIENCE EDUCATION
ABSTRACT
This project is aimed at developing an alert system which notifies shop owners and managers of products/inventory which are about to expire. Faced with the challenges shop owners face with loses and health hazards brought about by expired products, the researcher aimed at developing a product/Inventory Expiration system that manages product expiration in a computerized manner.
The Product expiration management system notifies/alerts the store manager on products expiring soon for prompt attention and decision. The system was built with PHP, MYSQL and Bootstrap Technologies.
CHAPTER ONE
1.1 INTRODUCTION
Products are considered as the business resources for the organization. This includes managing the product with appropriate way to review any time as per the requirement. Therefore, it is important to have a web-based Product Expiration System which has the ability to generate reports, report products expiry dates, maintain the balance of the stock, details about the purchase and sales in the organization, which helps to minimize loses to the business or negative health hazards to consumers. These web application can be used by large or small business organization for the management of their stock in the production houses. After analyzing the other Product Expiration systems, we decided to include some of common and key features that should be included in every Product Expiration system. The Product Expiration System is a complete web-based application designed with HTML, CSS and PHP technology. The main aim of the project is to develop Product Expiration System Model software in which all the information regarding the stock of the organization will be presented. It is an internet based application which has admin component to manage the inventory and maintenance of the inventory system. This application is based on the management of stock of an organization. The application contains general organization profile, sales details, Purchase details and expiration dates presented in the organization. There is a provision of updating the inventory also.
1.2 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.
SCREEN SHOTS OF THE APPLICATION/SOFTWARE
1.3 STATEMENT OF THE PROBLEMS
Health hazards to consumers and huge loss to businesses have been the major challenges posed by expired products. Manually taking stock of products by small scale/medium scale business owners are still prone to human errors. When consumers are exposed to expired products, they may have various health challenges ranging from stomach upsets to food poisoning (which may result to death).