Design and implementation of a computerized stock control and replenishment system

Project Abstract

The design and implementation of a computerized stock control and replenishment system is crucial for modern businesses to efficiently manage their inventory. This project aims to develop a system that automates the stock control process, providing real-time monitoring of inventory levels, tracking of stock movements, and generating replenishment orders when stock levels reach specified thresholds. The system will be designed to streamline the stock management process, reduce human errors, and optimize inventory levels to meet customer demands while minimizing costs. The proposed system will consist of several modules including a user interface for data input, a database for storing product information and stock levels, algorithms for monitoring inventory levels, and generating replenishment orders. The system will be user-friendly, allowing employees to easily input data such as incoming shipments, sales, and returns. The database will be designed to efficiently store and retrieve information, ensuring accurate and up-to-date stock levels. The stock monitoring algorithm will continuously track inventory levels and compare them to predefined thresholds. When stock levels fall below the minimum threshold, the system will automatically generate a replenishment order to restock the products. The system will take into account factors such as lead time, order quantities, and supplier information to optimize the replenishment process and ensure timely delivery of stock. By implementing a computerized stock control and replenishment system, businesses can benefit from improved inventory accuracy, reduced stockouts, and lower carrying costs. The system will enable businesses to make informed decisions based on real-time data, leading to better inventory management and increased operational efficiency. Additionally, the system will provide detailed reports and analytics to help businesses identify trends, forecast demand, and optimize stock levels. Overall, the design and implementation of a computerized stock control and replenishment system offer numerous advantages for businesses looking to enhance their inventory management processes. By automating stock control and replenishment tasks, businesses can improve efficiency, reduce costs, and ensure optimal stock levels to meet customer demands. This project aims to develop a comprehensive system that will revolutionize the way businesses manage their inventory, leading to improved performance and competitiveness in the market.

Project Overview

<p> </p><div><p><strong>INTRODUCTION</strong></p><p><strong>1.1 &nbsp; &nbsp; Background Of The Study</strong></p><p>Stock control is an important area of activity which is often neglected and underrated in many organizations both private and public sectors.</p><p>Stock control can be defined as a means by which materials of the correct quantity and quality are made available as and when required by taken due regard to economy in storage and the ordering cost purchasing prices and the working capital.</p><p>Stock control therefore involves the process of:</p><p>Assessing the items to be held in stock</p><ul><li>Deciding the extent the stock holding of such items either individually or collectively</li><li>Regulating the input of stock into the storehouses and</li><li>Regulating the issue of stock from the storehouses.</li></ul><p>To enable the stock controller to assess items to be held in the stock, it is necessary that he considers what items that are being used and produced by the particular company or organization, and from this, he can decide which of those items he should stock. Stock is principally held for the purpose of providing a reservoir of material to absorb the effect of variation in both the delivery and consumption and also for the maintenance of read availability of supplies within the organization concerned. Naturally, it is necessary for held stocks of materials which are regularly used and also those items which may be required at short notice in the event of plant. We can define or describe stock control as a means by which materials or items of correct quantity and quality are made available when required and with due regards to economy in storage and cost of ordering, purchase price and working capital. Stock control can also be described as the function of planning and maintaining the right quantity of items for a given product or sales programmed with the minimum of investment.</p><p>Stock control has the following objectives</p><p>i &nbsp; &nbsp; &nbsp; &nbsp; To eliminate producing or sales delay by supplying the materials or items in a manner and quantity need at the specified time.</p><ol><li>To reduce the number of items which need to be carried etc. in order to achieve those objectives, the stock control involves two methods which can be controlled by quantity and be value. It is desirable to control in value.</li></ol><p>Stock control in quantity is only bound to give an accurate result of every item that is kept at the proper level.</p><p></p></div><div><p><strong>1.2 &nbsp; &nbsp; Statement Of The Problem</strong></p><p>Certain conditions or factors can pave way for effective or ineffective stocking and verification. The problem of this study intends to get rid of are as follows:</p><ol><li>Lack of proper application of inventory control which indicates the physical balance of items in the supermarket</li><li>Lack of proper application of stock level and documentation of items in the supermarket which indicate when replenishment.</li></ol><p>iii. &nbsp; &nbsp; Items are strongly located in the store which exposes the items to deterioration and portage. This constitutes waste which drastically affects the supermarket’s profit maximization.</p><p>Despite all the importance and benefits of stocktaking it has from time to time record some drawbacks.</p><p></p><p>This study is therefore designed to identify such factors militating against effective and efficient stock control for better performance.</p><p><strong>1.3 &nbsp; Objective Of The Study</strong></p><p>It is necessary to have a look at the past in order to appreciate what we are trying to do in the present so as to do better in the future. Stock control has long time been in existence without full realization by the individuals. The question is that to what extent it is implied in the social in order to achieve individual or co-operative goal. Subsequently, research work has been carried out based on the effective application of the stock control principles, techniques and practice in various organizations for the purpose of achieving a healthy economy in the organization.</p><p>In order to achieve effectiveness and efficiency in an organization of any scale or scope, this research work, therefore has the objective of revealing the neglected but important contribution of effective stock in an organization.</p><p>The following objectives to review are:</p><ol><li>To implement a stock control system.</li><li>To determine through the analysis, the degree of the application of effective stock control in the farm product and materials.</li></ol><p>iii. &nbsp; &nbsp; That the space utilization is achieved.</p><ol><li>Examine how optimum safety stock level is determined and maintained.</li></ol><p><strong>1.4 &nbsp; Scope Of The Study</strong></p><p>This study is designed to give an insight into ways of solving the research problems. The problems of improper application of stock control in Sungai farm and for the research to study all of them. It will be impossible within the time given to the research. Therefore the researcher decided to use Sungai farm as a case study so as to carry out an in-depth study of the stock control in that agriculture sector.</p><p><strong>1.5 &nbsp; &nbsp; Significance Of The Study</strong></p><p>This study will be of benefit to the following person or group of persons.</p><p><strong>The Government:</strong>&nbsp;The government will be able to know how resources are being effectively managed and controlled in the public sector.</p><p></p><p><strong>The Public Sector:</strong>&nbsp; &nbsp; &nbsp; &nbsp; This study will help the public sector to know the need for proper stock control in an organization.</p><p><strong>The Farm Managers:</strong>&nbsp;This group of persons will be able to identify areas to intensify inventory management and control measures.</p><p><strong>The Researchers:</strong>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Another significance of this study is that of the conditional degree in computer science. With its successful completion, the researcher will be qualified for the award of B.sc degree in computer science which enable the researcher to practice his profession.</p><p><strong>Other students:</strong>&nbsp;This study will also help other students who may want to carry out further research on this topic or related topics.</p><p><strong>1.6 &nbsp; &nbsp; Limitation Of The Study</strong></p><p>This study is limited to an extent. In the first place, the researcher was done alongside with my intensive lecture as regard to the researcher’s preparation for the final examination being a final year student. It became difficult to combine both the research work and other school activities.</p><p>Other limitations of this study include time, finance, non-response and distance.</p><p><strong>TIME:</strong>&nbsp; &nbsp; &nbsp; &nbsp; Knowing full well that the researcher is still a study with much academic work load contend with as this project work has not been given any specific period in the researcher’s class timetable, the researcher has constrained to limit his areas of coverage so as to fall within the little time allowed and available.</p><p><strong>FINANCE:</strong>&nbsp;Taken congestion of the unhealthy economic situation of the country and would not expect the researcher who is still tied to the aprons strings of his parents to successfully carry out his research which involves huge financially outlay. This lack of fund also affected the research area as the distance was not track able.</p><p><strong>NON-RESPONSE:</strong>&nbsp; &nbsp; &nbsp; This was about the greatest limiting factors to this study. The research which was conducted in Best stores supermarket has relatively few employees, majority of them are new employee that lack adequate information to give while others were not prepared to compromise their job devotion with the information required by the researcher.</p><p><strong>DISTANCE:</strong>&nbsp;The area of the research is far away from the school and this created a lot of problems in the researcher’s effort. With all these constraints, the researcher tries to accomplish this project work successfully.</p><p><strong>1.7 &nbsp; &nbsp; Definition Of Terms:</strong></p><ol><li><strong>STOCK CONTROL: </strong>Stock control can be defined as the means by which materials of the correct quantity and quality are made available as regard to economy in storage and the ordering cost, purchasing prices and the working capital.</li><li><strong>REPLENISHMENT: </strong>This could be defined as the ability of making something fully again by replacing what he has used</li><li><strong>DETERIORATION:</strong>&nbsp;Can be defined as something to be worse in quality or condition.</li><li><strong>INVENTORY:</strong>&nbsp;This can be defined as the total number goods or materials available in a storehouse in a given period of time.</li><li><strong>MATERIAL CONTROL:</strong>&nbsp;Material control section of the stores organization that is directly involved with the control of the flow of production material (in most cases) from the supplier to production centers.</li><li><strong>INTERFERENCE:</strong>&nbsp;Can be defined as to get involved in and try to influence a situation that doesn’t concern you in a way that annoys other people.</li><li><strong>STOCK OUT COST:</strong>&nbsp;These are costs associated with running out of cost. The evidence of this cost is the basic reason why stock are held in the first place or instance. Those costs includes cost contribution through the lost sales caused by labor frustration over stoppages, extra cost associated with urgent, often small quantity replenishment purchase etc.</li><li><strong>ORDERING COST:</strong>&nbsp;It is used in cases of raw material (suppliers) and includes the entire cost of acquiring in activities such as requisition, purchase ordering, transporting, receiving, inspecting, and storing (store placement) ordering cost increase in proportion to the number order placed.</li><li><strong>STOCK:</strong>&nbsp;Can be defined as the supplies or commodities necessary for the conduct of the business</li></ol></div><h3></h3><br> <br><p></p>