Stores Management System

 

Project Objective

            The Stores Management system will enable a chain of stores to coordinate with their supplier to facilitate on time supply and to maintain updated information about available stocks at each store.

            This Stores Management System can be hosted over either an intranet or over the internet. For stores owned by the manufacturer the system can be operated over a company wide network to enable transfer of information. In the case of various dealers selling shoes made by the manufacturer it may be easier to host the system over the internet.

            The system has two main functions, to inform the manufacturer of dealer requirement of stocks and to maintain records of all dealer transactions. It is desirable for the dealer to maintain only the required amount of stocks so as to reduce warehousing charges. The dealer can place orders to the manufacturer in two ways:

1. By explicitly ordering a specific quantity of stocks to be delivered on a particular day.
2. By setting a requirement that the manufacturer maintains a minimum amount of stock at the dealer warehouse. When the stock dips beyond a specific value an automatic buy order will be generated for the manufacturer to fulfil.

All records of these transactions will be maintained and cash payments can be made at a later date.

            The Stores Management System will keep track of the unique Stock Keeping Unit (SKU) of the products sent to each store. The Cost Price of the product will be set by the manufacturer and this is the amount the dealer will be required to pay the manufacturer. The Selling Price of the product can be set by the dealer based on their requirement. Whenever new stocks arrive at the dealer’s warehouse it will be updated in the system along with the SKU. When this product is sold at a store it will be deducted from the dealer’s inventory and the customer details along with the SKU of the product sold will be recorded.

            The system will be able to generate reports about daily, monthly sales and based on historical information predict the demand of coming months. This will help dealers and the manufacturer to prepare for upcoming festive seasons when shopping increases.

Stores Management System Snapshots

Existing System

The existing Stores Management System consists of maintenance of individual ledgers or excel sheets by both the manufacturer and the dealer. The manufacturer will have to resolve differences between both the records before cash settlements can be done. This task becomes daunting when the manufacturer has to deal with dealers spread out over the country. The dealer will have to manually go through ledgers on a daily basis to decide when it is time to place a new buy order. It is also difficult to spot trends in shopping patterns.

Proposed System

            The proposed Stores Management System will ensure that both the manufacturer and the dealer is working with just one version of records so as to avoid discrepancies. The manufacturer need not worry about working with different dealers in different parts of the country. The tracking of SKU will help identify changes in stock and in the unfortunate event of a product recall it will make it easier to identify the customers who bought a defective product. It is easy to spot spikes in shopping and plan accordingly for the same.

Modules

Manufacturer: The manufacturer will be able to create new login IDs for new dealers and set the Cost Price for different products. They will be able to track contract details and payment due on different contracts.

Dealer: The dealer will be able to initiate single or recurring buy orders. This module will alert the manufacturer about changes in stocks and expected shipments. The dealer will be able to observe historical sale data and use this to determine future demand and order accordingly. The dealer will also be able to set the Selling Price for each product.

Admin:  The admin will be able to control manufacturer login IDs and access.

Software Requirements

• Windows XP
• Apache Tomcat Web Server
• Oracle

Technology Used

• Java
• J2EE

Hardware Requirements

• Hard Disk – 2 GB
• RAM – 1 GB
• Processor – Dual Core or Above
• Mouse
• Keyboard
• Monitor
• Printer

Download Project

Abstract Download	Download Abstract
Stores Management System Code	Download Source Code