1 / 13

Automated Inventory Management Chao Li CS491 Spring 2006

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.

Audrey
Download Presentation

Automated Inventory Management Chao Li CS491 Spring 2006

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Automated Inventory Management Chao Li CS491 Spring 2006 AIM

  2. 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

  3. 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

  4. Users • Regular users: waiter/waitress • Place orders • Check inventory levels • View past order information AIM

  5. Users • Managers • Order inventory from liquor vendors • Delete certain orders • Check sales in the past • Re-stock inventory • All functions as regular users AIM

  6. 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

  7. Technology • Some useful JTable class • setValueAt(row, col) • getValueAt(row, col) • Print() • setRowSelectionInterval(index0, index1), inclusive AIM

  8. Architecture • Client Tier • User Interface • Displaying menu, sales summary, inventory, orders information, ect. AIM

  9. 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

  10. Architecture • Business Tier • Methods to retrieve or store data from or to database • Methods to support all the functionality, verify user’s input AIM

  11. 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

  12. 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

  13. Thank You – Any Questions? • Demo AIM

More Related