Inventory Mangement System
Prepared By: Solanki jaydip chandrakantbhai
Roll No.: 22BIT027
Exam No: TYIT023
Guided By: Mrs. Kinjal shah
Submitted as: Partial Fulfilment of B.sc-CA&IT
Degree
Submitted To: Shri D.N.Institute of Computer
Applications, Anand Sardar Patel University, V. V.
Nagar
Tools
Front End: Python
Back End: MY SQL
Component Minimum Recommended
processor 2.5 gigahertz(GHZ) Dual processor that are each 3
GHz or faster
RAM 1 GB 2 GB
Disk NTFS file system-formatted NTFS file system-formatted
System
partition with a minimum of 3 partition with 3 GB of free
GB of free space space plus adequate free space
for your Web Sites
Drive DVD Drive DVD drive or the source
Configuration
copied to a local or network-
accessible drive
Display 1440 x 900 1440 x 900 or higher
Scope
Inventory management helps to manage
the stock of the company. it provides
proper details of the products what kind of
raw material, what are the sizes we require
and etc. to the purchasing department.
When the inventory management provides
proper information to management, they
buy according to them which helps the
company to store fewer products.
The system is very fast and user friendly.
The scope of the proposed system is bright.
This system will prove the best solution for
the problems of current system
Existing System
➤ In the existing system the details about the Inventory System
like material details, customer details are maintained in FoxPro
➤ Consumes more time and effort for updating
➤ Reports are not in attractive manner
➤ Efficiency and accuracy cannot be expected
➤ Quick and timely services are not provided
➤ Slow processing speed
➤ Readymade data retrieval is difficult
Need Of Propose System
Streamline inventory tracking and order processing to
reduce manual tasks.
Maintain accurate stock levels with automated updates,
reducing human error.
Implement automated reordering based on demand
forecasts to prevent overstock and stockouts.
Utilize detailed reports and dashboards to analyze sales
trends, turnover rates, and inventory performance.
nhance collaboration with suppliers for better order
management and lead time tracking.
System
Features
Automated Order Processing:
Create, track, and manage
purchase and sales orders with
minimal manual input.
Automatically track and fulfill
backorders as stock becomes
available.
Seamlessly connect with
existing enterprise resource
planning (ERP) and customer
relationship management
(CRM) systems.
Data Flow Diagram
Context Level of DFD:-
Zero Level
DFD for
Admin
First level DFD
for functional
process login
system(1.0)
First Level
DFD for
Employee
(2.0)
First Level
DFD for
Supplier
(3.0)
First Level
DFD for
product
system(5.0)
First Level
DFD for
SssSales_mst Employee
First Level DFD
for Employee
login(1.0)
Database layout
1.Admin (for login)
2. employe (for login)
2. Emp_mst(for Employee info)
3.supp_mst(for supplier information)
4.category_mst (for category information)
5. product_mst (for product information)
4. Supp_mst(for genrate bill and view bill)
1.Login
page
2.Home
page
3.Employee
details
4.Supplier
detail
5.Category
Detail
6.Product
Detail
7.View
customer
bill
8. Bill
generation
page
Limitations
The cost of software, hardware, and
training can be significant.
Regular updates and maintenance may
incur additional costs.
Employees may resist adopting new
technology, leading to reduced
efficiency during the transition.
Human errors during data entry can lead
to inaccuracies in inventory records.
Off-the-shelf systems may not fully meet
specific business needs or industry
requirements.
Conclusion
In conclusion, an effective Inventory Management
System (IMS) is essential for modern businesses
seeking to optimize their inventory processes.
By automating tracking, order management, and
reporting, an IMS enhances operational efficiency
and accuracy while reducing costs and improving
customer satisfaction. Despite some limitations, such
as initial setup costs and potential integration
challenges, the benefits far outweigh these
drawbacks.
Implementing a robust IMS enables businesses to
gain real-time visibility into their inventory, make
data-driven decisions, and adapt to changing
market demands.
Investing in a comprehensive inventory
management solution is a strategic move that can
lead to significant improvements in operational
effectiveness and business profitability.
References
System analysis and design By Elias Award
System analysis and design by James A. Senn by
TataMacGrow Hill
Software Engineering By Pankaj jalote published by
pressman
Visual Basic - The complete references
