This project was done in the year 2018, in the 5th sem of Computer Science Engineering.

The WAREHOUSE SUPPLY CHAIN is a web based system, designed for a production sector, which gives information related to the customers and the product details they ordered. This product develops a system that can be used by the company management to keep track of all the sales, vendors and its customers. It automates the communication between all these 3 sectors.

This project has been developed to override the problems prevailing in the practicing manual system. This software is supported to eliminate and in some cases reduce the hardships faced by the existing system. Moreover this system is designed for the particular need of the company to carry out operations in a smooth and effective manner.

The main objective of the project is to find out the supply chain management system. Supply chain is a lengthy process. Basically their supply chain is totally ware-house based. In supply chain, at first they store the entire product from different manufacturer in their warehouse. The transportation cost is totally taken care by the warehouse company. Then the stored products are distributed through their own vehicles to its several outlets. There is no intermediary between warehouse and manufacturing company. No product directly comes to the outlet without the hands of warehouse.

The other objectives include:

• To gather practical knowledge of supply chain management.

• Reduce manpower and manual paper works for maintaining the records offline.

• Maintain the accuracy, integrity and consistency of the data.

• To maintain all the products, customers, employees, vendors and orders details in one database.

DATABASE ASSUMPTIONS

A warehouse basically has 4 important elements: products, transporters, orders and suppliers. Each element must be tracked based on its location and quantity. The product on hand is updated by tracking incoming shipments and outgoing orders. Order alerts can be set to trigger when inventory levels fall below custom-defined minimum levels.

It is listed as below:

A warehouse has goods that are either supplied by some supplier or can be delivered to the customers.
Every good has a unique article id, description of the good, denomination of quantity (DOQ), cost per piece and total cost (cost per piece*quantity).
One good can belong to maximum two transactions (one of the supplier to the warehouse and other one to the customer from warehouse) and one transaction can involve one or many goods.
Transaction has details like order number, consignee name, date, quantity and transaction value.
Goods are sent to warehouse by one or many suppliers and a supplier or indent can send one or many goods to the warehouse.
Every indent has a unique supplier id, name, DOQ, quantity, cost per piece and amount.
A customer has a unique customer id, mobile no., address, DOQ, quantity and amount.
Goods can be sent to customers from the warehouse with its transaction information (ternary).
A vehicle has a unique vehicle no., driver name, date of registration, date of incorporation, insurance and expiry date.
A vehicle has a unique vehicle no., driver name, date of registration, date of incorporation, insurance and expiry date.
A transporter can have one or many vehicles but each vehicle belongs to only one transporter.

SCHEMA OF THE DATABASE

SYSTEM ANALYSIS

The system runs on apache server. So it’s needed that the server must have an apache server version 2.0 available.
MySQL database has been used for storing the data of the website.
HTML has been used for creating the layout of the web application.
CSS has been used for creating and designing of the webpage.