Inventory Management System PHP

System Introduction
For optimal sales and inventory management processes, you need robust
functionality for managing your logistics facilities. Support for inventory
management helps you record and track materials on the basis of both quantity
and value.
Using this software, we can reduce costs for warehousing, transportation,
order fulfillment, and material handling while improving customer service.
You can significantly improve inventory turns, optimize the flow of goods, and
shorten routes within your warehouse or distribution center. Additional
benefits of inventory management include improved cash flow, visibility, and
decision making.
This software is user friendly and hence easy to use.
Employees can plan, enter, and document warehouse and internal stock
movements by managing goods receipts, goods issues, storage, picking and
packing, physical stock transfers, and transfer postings.
Problems In existing system
As we know manual system are quite tedious, time consuming and less efficient
and accurate in comparison to the computerized system.
So, following are some disadvantages of the old system:
Time consuming
Less accurate
Less efficient
Lot of paper work
Slow data processing
Not user-friendly environment
Difficult to keep old records
Scope of Proposed System
The scope of this system is to provide user efficient working environment and
more output can be generated through this. This system provides user friendly
interface resulting in knowing each and every usability features of the system.
This system helps in tracking records so that past records can be verified
through them and one can make decisions based on the past records. This
system completes the work in a very less time resulting in less time
consumption and high level of efficiency.
This system is developed in such a way that even a nave user can also operate
the system easily. The calculations are made very quickly and the records are
directly saved into databases and the databases can be maintained for a longer
period of time. Each record can be retrieved and can be verified for the future
transactions.
Also, this system provides high level of security for data leaking as only admin
people can access the database no changes can be made in it until it verifies the
user login id and password.
We also have operator login through which operator can take orders but cant
make changes in the database. Limited access is available to the operator.
Operating Environment Hardware and Software
HARDWARE REQUIREMENTS
Processor: Pentium 4 or more for optimum performance

RAM: Recommended 256MB
Hard Disk: Minimum 20GB
Mouse & Keyboard: - Compatible with Windows OS
Monitor: - 15.6 Color
SOFTWARE REQUIREMENTS
Language Used : Developed in PHP

Database : My SQL
User Interface Design : HTML, AJAX,JQUERY,JAVASCRIPT
Web Browser : Mozilla, Google Chrome, IE8,OPERA
Software : XAMPP Server
OBJECTIVES OF INVENTORY MANAGEMENT
The basic managerial objectives of inventory control are two-fold; first, the
avoidance over-investment or under-investment in inventories; and second, to
provide the right quantity of standard raw material to the production
department at the right time. In brief, the objectives of inventory control may
be summarized as follows:
Operating Objectives:
Ensuring Availability of Materials: There should be a continuous availability

of all types of raw materials in the factory so that the production may not be
help up wants of any material. A minimum quantity of each material should be
held in store to permit production to move on schedule.
Avoidance of Abnormal Wastage: There should be minimum possible wastage

of materials while these are being stored in the godowns or used in the factory
by the workers. Wastage should be allowed up to a certain level known as
normal wastage. To avoid any abnormal wastage, strict control over the
inventory should be exercised. Leakage, theft, embezzlements of raw material
and spoilage of material due to rust, bust should be avoided.
Promotion of Manufacturing Efficiency: If the right type of raw material is

available to the manufacturing departments at the right time, their
manufacturing efficiency is also increased. Their motivation level rises and
morale is improved.
Avoidance of Out of Stock Danger:
Information about availability of materials should be made continuously
available to the management so that they can do planning for procurement of
raw material. It maintains the inventories at the optimum level keeping in view
the operational requirements. It also avoids the out of stock danger.
Better Service to Customers:

Sufficient stock of finished goods must be maintained to match reasonable
demand of the customers for prompt execution of their orders. Highlighting
slow moving and obsolete items of materials.
Financial Objectives:
(1) Economy in purchasing: A proper inventory control brings certain

advantages and economies in purchasing also. Every attempt has to
make to effect economy in purchasing through quantity and taking
advantage to favorable markets.
(2) Reasonable Price: While purchasing materials, it is to be seen that
right quality of material is purchased at reasonably low price. Quality is
not to be sacrificed at the cost of lower price. The material purchased
should be of the quality alone which is needed.
(3) Optimum Investing and Efficient Use of capital: The basic aim of
inventory control from the financial point of view is the optimum level
of investment in inventories. There should be no excessive investment
in stock, etc. Investment in inventories must not tie up funds that could
be used in other activities. The determination of maximum and
minimum level of stock attempt in this direction.
FUNCTIONAL REQUIREMENTS
A. INPUT/OUTPUT
System shall have a form to accept the customer details.

System shall have a form to accept the Plant details.
System shall display transaction details.
System shall provide search facility on customer name, Order Placed,
date of order, date of order dispatch, date of transaction, transaction
amount, credit card no etc.
System should provide facility for change in address/name.
System should maintain the details about placing order/dispatch or
order i.e., order status.
B. PROCESSING
System should automatically generate the bill.
System should inform the pending order and make changes if the
order is dispatched.
C. ERROR HANDLING
Should report any errors on duplicate primary keys.
Should report any Out of Range values on numeric fields
Should report any data type mismatches any field on the forms
Should report on any Invalid dates
Should report any violation of authorization of rights
Should report any Invalid Login errors
NON-FUNCTIONAL REQUIREMENTS
All user manuals should be provided in the necessary format

Application should support 5 simultaneous users.
Transaction should be completed within 1/5th of second
There will be backup procedure to maintain records.
Conclusion
The system was mainly designed to reduce the manual work of updating
and tracking and also make it easier for the user.
It also provides flexible and powerful reports regarding customer details,
issue details and stock details.
Future Enhancement
There is always a room for improvement in any software package
however good and efficient it may be
But the improvement thing it that the system should be flexible enough
for further modifications.
Considering this important factor , the system is designed in such a way
that provisions can be given for further enhancement without affecting
the system presently developed.

Inventory Management System PHP

Uploaded by

Copyright:

Available Formats

Inventory Management System PHP

Uploaded by

Document Information

Original Description:

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Inventory Management System PHP

Uploaded by

Copyright:

Available Formats

System Introduction

Processor: Pentium 4 or more for optimum performance

Language Used : Developed in PHP

Ensuring Availability of Materials: There should be a continuous availability

Avoidance of Abnormal Wastage: There should be minimum possible wastage

Promotion of Manufacturing Efficiency: If the right type of raw material is

Better Service to Customers:

(1) Economy in purchasing: A proper inventory control brings certain

System shall have a form to accept the customer details.

All user manuals should be provided in the necessary format

You might also like