Project on dealer supplier management system is a web portal which is useful for manufacturing companies for handling stock and sales.
Analysis of each Use Case
Logging into the System:
The User (either the Staff, or the Dealer or the Supplier) logs into the System by entering their Usernames & Passwords. The Usernames & Passwords are authenticated, by checking the database. Once an authorized User enters the System, the options available to him are shown in a Menu. He has to choose the required options.
Enter Sales Figures by the Dealers:
The Dealer has an option to enter the sales figures for a given period of time. It is assumed that the figures are entered weekly. The Dealer has to enter the Product code & the quantity that has been sold during the week. Once these are entered he is taken to the Place Orders option.
Placing Orders for Products by the Dealers:
At the outset there is an option to Place the Order, which is equal to the Sales figure entered. If this is not chosen, then an option to enter the Orders will be shown. The Dealer has to place the Orders required. Then the sales figures are used to update the Stocks of Products of the dealers & Orders placed are added to the Orders Table.
Update Received Stocks of Products from Production Dept.:
The staff have an option to update the Stocks of the Products held by the Company when they receive finished Products from the Production Department. They enter the figures of the Products received from the Production Dept..
Dispatch Stocks to Dealers:
The staff have an option to update the Stock held with the company & the Dealers Stocks whenever any Dispatch of the Products is made. The stock held with the company is updated by removing the figures of Products dispatched to a Dealer & the same figures are added to the Dealers stock quantities.
Generate Production Schedule Report:
Generate the Production Schedule Report from the Products System. This is made available to the Parts System. This report generates the list of Products to be ordered based on the current stocks of Products held with the company.
Generate Parts Indent:
Generate the Parts Indent or Requirements Report from the Production Schedule. This report is generated, by taking into consideration the currently available Stocks of Parts already held with the company.
Send requests to Suppliers for Quotations:
The above Report is used to send Requests for Quotations to the Suppliers. If there is a Parts Indent whose status is “required”, then the Suppliers will be intimated to Quote their rates.
Suppliers Submit Quotations:
The Suppliers then login and are shown the list of requirements for the parts. They can quote the rates online. These rates are then stored in the database.
Staff confirm order for Supply of Parts:
The Staff can then confirm the orders for the parts. If the rates are not quoted, the latest quoted rates for all suppliers whose Status is active is retrieved. The staff send intimation that an Order was confirmed with the Suppliers. If the rates quoted are not for the lowest bids, an event is generated which intimates the Higher-authority like the Admin is intimated about the Parts ordered.
Update Part stocks received from Suppliers:
The staff has an option to update the Stocks of the Parts held by the Company when, they are delivered by the Suppliers. This option is available to the Company Staff only.
Update Part stocks delivered to Production Department:
The Company staff have an option to update the Stock of Parts held with the company whenever any Issue of the Parts is made to the Production Department. The stock held with the company is updated by removing the figures of Parts issued to the Production Department.
Add / Modify / Delete Dealers
The Company staff have an option to add or modify or delete Dealers details. Whenever a new Dealer is added to the company network, he is assigned a unique dealer id & details like Dealer Name, Address, Credit limit, Status are stored in the system. An option is provided to modify or delete any Dealer’s details.
Add / Modify / Delete Products
Whenever the manufacture of a new Product is taken up by the company, it is assigned a unique Product id. Details like the Name, Description, Price & Status of the Product are stored. The company staff have an option to modify or delete the details of any Product thus entered into the system.
Add / Modify / Delete Parts
Whenever a new Part is required for the manufacture of a Product, it is assigned a unique Part id. Details like the Name, Description, Quantity & Status of the Part are stored. The company staff have an option to modify or delete the details of any Part thus entered into the system.
Add / Modify / Delete Bill-of-Materials
Whenever a new Product is taken up for Production, a Bill-of-Materials is created for it. The Bill-of-Materials contains the details for the Product Id & every Part id & the number of Parts that are required for the manufacture of one Product. This table is used to calculate the total type & quantity of Parts required for the manufacture of each product. The Company Staff have an option to add / modify / delete a Bill-of-Materials for every Product.
Add / Modify / Delete Suppliers
The Company staff have an option to add or modify or delete Suppliers details. Whenever a new Supplier is added to the company network, he is assigned a unique Supplier id & details like Supplier Name, Address, & Status are stored in the system. An option is provided to modify or delete any Supplier’s details.
Add / Modify / Delete Users
The Company staff have an option to add or modify or delete Dealers/Suppliers staff as Users of the system. Whenever a new User is added to the company network, he is assigned a unique User Login Name & details like Dealer Id/Supplier id, password, & login type are stored in the system. An option is provided to modify or delete any User’s details.