NATIONAL INSTITUTE OF
INDUSTRIAL ENGINEERING
PGDIE-42
Industrial Engineering
Assignment on Product Manufacture:-
Inventory Management System
Presented by:
Rahul Sen(Roll no:72)
Raunak Goyal(Rollno:76)
Introduction:
An inventory control system is an integrated package of software and
hardware used in warehouse operations, and elsewhere, to monitor the quantity,
location and status of inventory as well as the related shipping, receiving,
picking and putaway processes. In common usage, the term may also refer to just
the software components.
An inventory control system may be used to automate a sales order fulfillment process. Such a system contains a list of order to be filled, and then prompts workers to pick the necessary items, and provides them with packaging and shipping information.
An inventory control system may be used to automate a sales order fulfillment process. Such a system contains a list of order to be filled, and then prompts workers to pick the necessary items, and provides them with packaging and shipping information.
Software Specification:
MS ACESS ,Visual basic
Minimum Requirements:
Windows Xp and above operating
system,Microsoft office -2007.
SDLC(Software development life
cycle : Model used is Iterative waterfall model.
In 1970
Royce proposed what is now popularly referred to as the waterfall model as an
initial concept, a model which he argued was flawed (Royce 1970). His paper
then explored how the initial model could be developed into an iterative model,
with feedback from each phase influencing previous phases, similar to many
methods used widely and highly regarded by many today.
Despite
Royce's intentions for the waterfall model to be modified into an iterative
model, use of the "waterfall model" as a purely sequential process is
still popular, and, for some, the phrase "waterfall model" has since
come to refer to any approach to software creation which is seen as inflexible
and non-iterative.
Usage of the waterfall model
In
Royce's original waterfall model, the following phases are followed perfectly
in sequential order:
- Requirements specification
- Requirements are captured
and set in stone.
- Design
- A "blueprint" is
drawn up for the developers to implement.
- Implementation
- Integration
- Testing
- Installation
- Maintenance
Advantages of a Waterfall Model:
l A waterfall model helps find problems earlier on which can cost a
business less than if it was found later on.
l Requirements will be set and these wouldn't be changed.
l As everything is documented a new
team member can easily understand what's to be done.
l Implementers have to follow the design accurately
ITERATIVE WATERFALL MODEL
Design process: Below is the design of basic form implemented
using Vb tools and connected a db (Ms Access) using queries.
Design structure of Inventory
Management Software
How to_Generate_Sanction Notes
Hence, before generating a Sanction
Note containing a particular Note Number, you have to follow
certain steps. The steps are as under
:
The Command button in the Form is
linked to under Reports which
in turn call the information/data from
the answer extracted by Query. You can
include as many number of items as
possible of a particular branch in each Office Note. For an item
or a set of items under single Office
Note number, only one Office Note will have to be generated.
Sanction Note
Sanction Note
Sanction Not e
1. Minimise the Form being used for
entering the information on individual item
2. Then you will find a small window
titled the leftside of it appears
portion. Below the objects, Ensure
that (object) is highlighted and right-side of it you can see
number of Queries. Out of these
queries, you will find a Query by name Right-click on
this query and choose from the PopUp
Menu. Now you will actually see the Sanction-
Note (Query)window. In this query, in
the column and row, please type the
branch code number (e.g.141, 303,
2071, 2077, 809 etc.) and under Criteria row of "AMC Sanction
Note Ref', mention the Office Note
number for which you are going to generate the sanction Note. For
Sanction Note number, please give the
numbers like '141/999' or "2071/999", first three digit is for
Branch/EC code and last three digit is
actual Note Number (started from 001, 002.... ). For each and
every branch and for different Office
Note numbers, you have to generate the separate Office Note
Reports.
Asset
AMC0203 :
Database Objects
Queries
Sanction Note.
Design View
Branch Code
Criteria
3. Save the Query and
close the Query Window
4. Maximise the Form
Window. Click on the Sanction Notes Butten. You will get preview
of the Office Note of
a specific Note Number selected by you in the Query. You can take
the print out.
How to_Generate_Monthly AMC
Register
On completion of each month, the
Register has to be generated and sent to H.O. Hence, before generating
a Monthly AMC Sanction Register, you
have to follow certain steps. The steps are as under :
The Command button in the Form is
linked to
under Reports which in turn call the
information/data from the answer extracted by
Query.
AMC Sanction
Register AMC Sanction Register
Monthly AMC
Registe
1. Minimise the Form being used for
entering the information on individual item;
2. Then you will find a small window
titled the leftside of it appears
portion. Below the objects, Ensure
that (object) is highlighted and right-side of it you can see
number of Queries. Out of these
queries, you will find a Query by name Rightclick
on this query and choose from the
PopUp Menu. Now you will actually see the
"Monthly-AMC-Register"
(Query)window. In this query, in the column
and row, please type the date range to
get the data of the particular month. The date range
for extracting data for the month of
June can be like this : For
each month for extracting the data,
only the month digits has to be changed.
Asset
AMC0203 :
Database Objects
Queries
Monthly-AMC-Register.
Design View
Sanction Note
Signed on
Criteria
3. Save the Query and
close the Query Window;
4. Maximise the Form
Window. Click on the AMC Sanction Register Butten. You will get preview
of the AMC Sanction
Register of a specific month. The Register will contain details of all the
items against which
Sanction has been accorded during the particular month selected by you in
the Query. You can
take the print out in two sets - one has to be despatched to I.T.Division, H.O.
duly assigning a OR
number, and other to be kept in the "2002-03 AMC" file.
>=#01.06.2002#
and <=#30.06.2002#.
Rahul Sen
How to_Generate_Sanction Letters
Hence, before generating Sanction
Letters, you have to follow certain steps. The steps are as under :
The Command button in the Form is
linked to under Reports which in turn call the
information/data from the answer
extracted by Query. For each Sanction Note, there will be only
one Sanction Letter. The Sanction
Letters have to be generated with reference to a particular Office Note and
particular Branch Code.
Sanction Letters
Sanction-Letters
Sanction-Letters
1. Minimise the Form being used for
entering the information on each item
2. Then you will find a small window
titled the leftside of it appears portion.
Below the objects, Ensure that
(object) is highlighted and right-side of it you can see number of
Queries. Out of these queries, you
will find a Query by name Right-click on this query and
choose from the PopUp Menu. Now you
will actually see the Sanction-Letters (Query)window. In
this query, in the column and row
please type the branch code (e.g.205, 2071, 638,
809 etc.) and under Criteria row of
"Sanction Note Signed on" , it is already mentioned "Is not
Null" and in the
column "AMC Sanction Note
Ref" under criteria row, mention the Office Note number (for eg. 141/999
or
2071/999, first three or four digits
for Br/EC Code and last three digits for OFFICE NOTE NUMBER) for which
the Sanction Letter has to be
generated.
Asset
AMC0203 :
Database Objects
Queries
Sanction-Letters.
Design View
Branch Code
Criteria
3. Save the Query and
close the Query Window and maximise the Form Window;
5. Now you can see/preview the
sanction letter you needed. As mentioned herein above, for each Office Note
signed on a particular date, there
will be only one sanction letter covering all the items sanctioned under the
said Office Note.. Only the outward
number for this sanction letter has to be filled in duly mentioned the
particulars of the sanction in the OR
Register.
Generation of Sanction Letters
should be only after ensuring that the Office Note is returned back
from the Sanctioning Authority
duly signed. After getting back the Note, please enter the Date in
the column "Sanctioned
on" in the Form Asset. Please note that Date should be entered for all the
items covered under the
particular Office Note received back duly signed
4. Click the Button "Sanction
Letters" on the Form.
6. Take two copies of "Sanction
Letter" - one to despatch to the Branch and other stapple along with the
Sanction Note duly marking as "Office Copy" and
file in the "2002-03 AMC" Box File, Office Note number-wise.