COMPLETE SCHOOL PROJECT TOPICS & MATERIALS :
CHAPTERS: Chapter 1-5 | DOC FORMAT: MS WORD/PDF | PRICE: ₦5,000

GET COMPLETE WORK

ABSTRACT

This sales and inventory management system has realized the transmission and control of large goods, so as to facilitate the management and decision of sales, and reduce a big burden for supermarkets and supermarket managers. It also can help to improve the work efficiency of supermarket. Its objective is to provide the basic information maintenance function of employees, memberships and products so that managers can through the function to add, delete, and modify the basic information of employees and the employees can through it to add, modify and delete the basic information of memberships and goods. Sales and inventory management system is very convenient for manage, input, output, and find the data so as to make the messy supermarket data to specific, visualizations, rationalization. In the aspect of software. In the cause of writing this project, HTML, CSS, JS and Sublime text were used to design the system (front end) and Wamp Server and PHP was used to store the database (middle end). The website has a large memory of storing all the goods in the store and also keeping record, it is highly effective and accurate. The study recommended that if there is going to be any modification the new writer should endeavor to improve on the limitations such as inclusion of payment processor to further increase the system architecture and to satisfy users need more for writing of the source code, latest PHP version should be used and MySQL for the database, which is the back end. In the aspect of software, various configurations in computer including input and output capacity, internal memory and external memory capacity can meet the requirements of users. The methodology used in this project is the Object-Oriented Analysis and Design methodology (OOAD).

 

CHAPTER ONE

INTRODUCTION

1.0     BACKGROUND OF THE STUDY

Sales and inventory management is one of the basic problems of business organizations that need to effectively manage their financial information and stock records. It may cause a lot of paper work, if there is no automated system available. Inventory management is the process of efficiently overseeing the constant flow of units into and out of an existing stock of goods. This process usually involves controlling the transfer units in order to prevent the inventory from becoming too high or dwindling to levels that could put the operation of the company into jeopardy.

Inventory management is primarily about specifying the size and placement of stocked goods. It is an activity specifying the shape and percentage of stocked goods. Inventory management is required at different locations within a facility or within multiple supply network to protect the regular and planned course of production against the random disturbance of running out of materials or goods. The scope of inventory management also concerns the fine lines between replenishment and lead time, carrying cost of inventory, asset management, inventory forecasting, inventory valuation, inventory visibility, future inventory price forecasting, physical inventory, available physical space for inventory, quality management, replenishment, returns, defective goods and demand forecasting [1].

The essence of a sales and inventory management system is for an effective automation of the management of a supermarket. The Sales and inventory management system is a project that deals with supermarket automation and it includes both purchasing and selling of items. Sales and inventory management system is the system where all the aspects related to the proper management of supermarket is done. These aspects involve managing information about the various products, staff, managers, customers, billing etc. This system provides an efficient way of managing the supermarket information. Also allows the customer to purchase and pay for the items purchased. This study is based on the sales transaction and billing of items in a supermarket.

This study is to produce software which manages the sales activity done in a supermarket, maintaining the stock details, maintaining the records of the sales done for a particular month/year. The users will consume less time in calculation and the sales activity will be completed within a fraction of seconds whereas manual system will make the user to write it down which is a long procedure and so paper work will be reduced and the user can spend more time monitoring the supermarket. The program will be user friendly and easy to use.

The system will display all the items whose name start with the letter selected by the user. He can select out of those displayed. Finally a separate bill will be generated for each customer. This will be saved in the database. Any periodic records can be viewed at any time. If the stock is not available, the supermarket orders and buys from a prescribed vendor. The amount will be paid by deducting the total amount acquired in the sales activity. Admin provides a unique username and password for each employee through which he can login.

 

 

1.1     STATEMENT OF THE PROBLEM

The manual management of a supermarket is besieged with numerous problems. Among these problems are the following:

1. Time Consumption: Manual systems are time consuming, as the business owner must keep track of Supermarket sales on a daily basis, while updating the system manually at the end of the day.
2. Poor Communication: A manual Supermarket system requires employees and managers to write down each time an item is removed from the Supermarket. If one employee forgets to mention that the last coffee product has been removed from the Supermarket, a manager expects the item to still be available for a customer during a sale. Compared with a technical Supermarket system, a manual Supermarket system does not help the communication in the workplace.
3. Physical Counts: A manual Supermarket system does not provide any number, as all numbers from the Supermarket are gained through physical Supermarket counts. One of the difficulties of running a manual Supermarket system is that physical Supermarket counts must be performed frequently to control the items in the Supermarket. This is time consuming and can cost the business money, if employees must come in to help out outside of business hours.
4. Daily Purchases: Keeping track of daily purchases is another difficult controlling measure with manual Supermarket systems. A manual Supermarket system requires the employees to write down the items sold during a single work day. This can be a difficult task, as one employee may lose the list of items sold or another may forget to write down a sale.
5. Ordering Supplies: A manual Supermarket system does not update at the end of the day with updated Supermarket.

 

 

1.2     OBJECTIVES OF THE STUDY

The main objective of this project is to design a Computerized Sales and inventory management system to

1. ascertain stock level of a supermarket,
2. To know when to order for more goods, keep status and updates of transactions, thereby helping progress level,

• To determine stock taking and managerial decisions.

.

1.3     SIGNIFICANCE OF THE STUDY

For every new thing developed there must be an advantage, a disadvantage and a significance it will have in the world. Just like cars they are built to reduce stress of moving from one place to another especially when it’s over a long distance, but every car is prone to fail at some point and that’s one of the biggest disadvantages, but the researcher won’t be writing about advantages and disadvantages of a car, the researcher will be writing on the significance of an sales and inventory management of supermarket. The researcher said before, everything developed has significance to the world and sales and inventory management of supermarket is significant to humanity in the following ways:

1. The management system will be of great benefit to supermarkets and it will improve the managerial cum administrative strength of the business and move the business forward to meet the demand of times and globalization in this era of technology.
2. To explore the challenge being faced by the manual system.
3. For easy record of goods and proper identification.
4. This piece of work will add to the already existing literature review and act as a reference work for future researchers.

 

 

SCOPE OF THE STUDY

This project work covers stock control, management and tends to correct anomalies in Supermarket business. It analyses opening of new stocks, stock updates and ability to view existing ones. It provides quick way of operation by capturing the manual process and automating them. This project is helpful to computerize the item transaction, sales activity record keeping which is a very huge task and maintaining the stock

 

LIMITATION OF STUDY

Due to time and basic factors like unstable electricity, poor networks, unavailability of concrete business idea and many more this research has been limited to certain areas in supermarket management we only looked more into the supermarket inventory management area using Microsoft access and Visual basic.