Automated Inventory Management
Download
1 / 13

Automated Inventory Management Chao Li CS491 Spring 2006 - PowerPoint PPT Presentation


  • 121 Views
  • Uploaded on

Automated Inventory Management Chao Li CS491 Spring 2006. Background. Traditional method of managing inventory Inaccuracy and inefficiency Wasting time and human efforts to check inventory weekly. Prone to human errors Hard to maintain inventory levels. Introduction.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Automated Inventory Management Chao Li CS491 Spring 2006' - Audrey


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Automated inventory management chao li cs491 spring 2006

Automated Inventory Management

Chao Li

CS491 Spring 2006

AIM


Background
Background

  • Traditional method of managing inventory

  • Inaccuracy and inefficiency

    • Wasting time and human efforts to check inventory weekly.

    • Prone to human errors

    • Hard to maintain inventory levels.

AIM


Introduction
Introduction

  • An stand alone program that automatically manages restaurant’s liquor inventory

    • Orders, sales, etc.

  • Improve efficiency and accuracy

    • Up-to-date inventory info

  • Reduced errors due to human factors

  • However, still exists inevitable human errors in using it.

AIM


Users
Users

  • Regular users: waiter/waitress

    • Place orders

    • Check inventory levels

    • View past order information

AIM


Users1
Users

  • Managers

    • Order inventory from liquor vendors

    • Delete certain orders

    • Check sales in the past

    • Re-stock inventory

    • All functions as regular users

AIM


Technology and development
Technology and Development

  • J2SE: Swing and awt

  • MySQL and JDBC

    • CS server

    • Auto_increment of mysql and Serial type of postgreSql.

  • netBeans 5.0

AIM


Technology
Technology

  • Some useful JTable class

    • setValueAt(row, col)

    • getValueAt(row, col)

    • Print()

    • setRowSelectionInterval(index0, index1), inclusive

AIM


Architecture
Architecture

  • Client Tier

    • User Interface

    • Displaying menu, sales summary, inventory, orders information, ect.

AIM


Architecture1
Architecture

  • Client Tier

    • Summary: sales summary in the past periods

    • Inventory: current inventory levels

    • Orders: orders information in time fashion

    • Restock: out going orders that send to vendors

AIM


Architecture2
Architecture

  • Business Tier

    • Methods to retrieve or store data from or to database

    • Methods to support all the functionality, verify user’s input

AIM


Architecture3
Architecture

  • Data Tier

    • Actual data stored in database

    • Inventory: inventory’s info such as id, name, vendor’s email, total

    • order detail: id, item, total, order time

    • outgoing orders: orders that send to vendors

AIM


Summary
Summary

  • Automated Inventory System that manages inventory accurately, provide inventory level up-to-date, store orders information

  • Improved efficiency of inventory management and accuracy

  • A lot to do in the future

AIM