Inventory Management EWIS Project Report

Inventory Management
A Database Project Report
SUBMITTED TO:
PROF. S. K. BAURAI
SUBMITTED BY:
NAME: SARTHAK GUPTA ROLL NO.: 11BSP0889 SECTION: A
Acknowledgement
It gives me a great sense of pleasure to present the report undertaken during the second semester. I express my sincere thanks to Prof. S. K. Baurai, my Project guide to have given us the opportunity to work on such a challenging project. I also thank our institute I.B.S. Gurgaon for providing us all the necessary resources required in our study.
I am also highly grateful to all the concerned for providing us with the required information which helped us in carrying out our research work.
On the onset, we would like to take this opportunity to express our gratitude to all those great minds and hearts that have touched this project in the path of its success.
Sarthak Gupta (11BSP0889)
Abstract
Inventory management systems are the rule for such enterprises, but smaller businesses and vendors use them, too. The systems ensure customers always have enough of what they want and balance that goal against a retailer's financial need to maintain as little stock as possible. Mismanaged inventory means disappointed customers, too much cash tied up in warehouses and slower sales. Factors such as quicker production cycles, a proliferation of products, multi-national production contracts and the nature of the big-box store make them a necessity.
To achieve this, inventory management systems pull together several technologies into one cohesive approach. Read on to learn about the history of inventory management systems and how modern systems work.
Table of Contents
1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14.
Acknowledgement Abstract Introduction Disadvantages of Old System Advantages of New System Process Flow Diagram Data Flow Diagram (DFD) Normalization Entity - Relationship Diagram (ERD) Tables Physical Translation into MS-Access Forms Design Queries Data Reports
Introduction
Inventory means a list compiled for some formal purpose, such as the details of an estate going to probate, or the contents of a house let furnished. This remains the prime meaning in British English.
Inventory Management
Inventory management is primarily about specifying the shape and percentage of stocked goods. It is required at different locations within a facility or within many locations of a supply network to proceed the regular and planned course of production and stock of materials.
The scope of inventory management concerns the fine lines between replenishment lead time, carrying costs of inventory, asset management, inventory forecasting, inventory valuation, inventory visibility, future inventory price forecasting, physical inventory, available physical space for inventory, quality management, replenishment, returns and defective goods and demand forecasting. Balancing these competing requirements leads to optimal inventory levels, which is an on-going process as the business needs shift and react to the wider environment.
Inventory management involves a retailer seeking to acquire and maintain a proper merchandise assortment while ordering, shipping, handling, and related costs are kept in check. It also involves systems and processes that identify inventory requirements, set targets, provide replenishment techniques, report actual and projected inventory status and handles all functions related to the
tracking and management of material. This would include the monitoring of material moved into and out of stockroom locations and the reconciling of the inventory balances. Also may include ABC analysis, lot tracking, cycle counting support etc. Management of the inventories, with the primary objective of determining/controlling stock levels within the physical distribution function to balance the need for product availability against the need for minimizing stock holding and handling costs.
Disadvantages of Old System
As we know the manual processing is quite tedious, time consuming, less accurate in comparison to computerized processing. Obviously the present system is not is exception consultant encountering all the above problems.
1. Time consuming. 2. It is very tedious. 3. All information is not placed separately. 4. Lot of paper work. 5. Slow data processing. 6. Not user-friendly environment. 7. It is difficult to found records due file management system.
Advantages of New System
In new computerized system I tried to give these facilities. 1. Manually system changes into computerized system. 2. Friendly user interface. 3. Time saving. 4. Save paper work. 5. Connecting to database so we use different type of queries, data report. 6. Give facility of different type of inquiry. 7. Formatted data. 8. Datas are easily approachable.
Process Flow Diagram
Data Flow Diagram
It is a graphical representation of the data. It identifies the path the data will take, what process will take place to it from one from to another.
1 Level Data Flow Diagram
2nd Level Data Flow Diagram
Normalization
An Initial Data Schema for Order (Zero Order)
An Order Data Schema (First Order)
An Order Data Schema (Second Order)
An Order Data Schema (Third Order)
Here: PK-> Primary Key FK-> Foreign Key
Entity Relationship Diagram after 3rd NF
Tables
Term Used in TABLES Item number: - It represents the code to identify an item. It helps to search the item in the stock according to requirement. Item name: - This field shows the name of item. Max quantity: - This field shows max quantity in stock. Reorder status: - This field shows reorder status when quantity goes below to minimum quantity in stock. Order code :-It determines the code of the order that has been ordered by the customer. Supplier address: - This field helps to know the address of the supplier. Order date: - This field shows the date of the order. Item Id: - It determines the code of the item. Item name: - It contains the name of the item. Quantity: - It specifies the quantity of the order. Delivery time: - It shows the time of the deliver. Customer name: - This field determines the name of the customer. Customer address: - It determines the address of the customer. Unit price: - It shows the price per item. Amount: - it determines the amount per item. Total Amount: - This field shows the total amount of the item that has been purchase by the customer. Etc...
ContactInformation
Item
Order
PaymentType
OrderPayment
OrderItem
Physical Translation into MS-Access
Forms
Customer Form
Order
OrderItem
Item
OrderPayment
PaymentType
Query
ContactInformation Query
Item Query
ContactInformation Query
Reports
Quarterly Sales Report
Q4 2010
Product Balaji Chai Balaji Boysenberry Spread Balaji Walnuts Balaji Fruit Cocktail Balaji Marmalade Balaji Crab Meat Balaji Coffee Nutrella Chocolate Balaji Almonds Chinese Chicken Soup Oct $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Nov $0.00 $0.00 $232.50 $0.00 $405.00 $147.20 $230.00 $0.00 $100.00 $0.00 $1,114.70 Dec $75.00 $125.00 $0.00 $390.00 $0.00 $276.00 $0.00 $191.25 $200.00 $97.50 Total $75.00 $125.00 $232.50 $390.00 $405.00 $423.20 $230.00 $191.25 $300.00 $97.50 08 January 2012 02:35:32 PM
$1,354.75 $2,469.45
Customer Address Book Report

Customer Name A Elizabeth Andersen Catherine Autier Miconi Thomas Axen
08 January 2012 Address 123 8th Street Portland, OR 98052 USA 456 18th Street Boston, MA 99999 USA 123 3rd Street Los Angeles, CA 98052 USA 456 17th Street Seattle, WA 99999 USA 123 1st Street Seattle, WA 98052 USA 123 12th Street Las Vegas, NV 99999 USA
B Jean Philippe Bagel Anna Bedecs E John Edwards

Inventory Management EWIS Project Report

Uploaded by

Copyright:

Available Formats

Inventory Management EWIS Project Report

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 EWIS Project Report

Uploaded by

Copyright:

Available Formats

Inventory Management

A Database Project Report

Sarthak Gupta (11BSP0889)

1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14.

Disadvantages of Old System

Advantages of New System

Process Flow Diagram

Data Flow Diagram

1 Level Data Flow Diagram

2nd Level Data Flow Diagram

An Order Data Schema (First Order)

An Order Data Schema (Second Order)

An Order Data Schema (Third Order)

Here: PK-> Primary Key FK-> Foreign Key

Entity Relationship Diagram after 3rd NF

Physical Translation into MS-Access

Customer Address Book Report

B Jean Philippe Bagel Anna Bedecs E John Edwards

You might also like