Assignment on Product Manufacture:- Inventory Management System

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.

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.

WaterfallModel: he waterfall model is a sequential software development model in which development is seen as flowing steadily downwards (like a waterfall) through several phases.

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.