Stock-warning system and method

• US 20040019537A1
• Filed: 12/27/2002
• Published: 01/29/2004
• Est. Priority Date: 07/26/2002
• Status: Abandoned Application

• Current Assignee: Hon Hai Precision Industry Co., Ltd.
• Original Assignee: Hon Hai Precision Industry Co., Ltd.
• Inventors: Zhang, Wei, Luo, Sheng Chi, Chen, Qiong-Shuai
• Application Number:
  US10/330,587
• Publication Number:
  US 20040019537A1
• Time in Patent Office: Days
• US Class Current: 705/28
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders

Abstract

A stock-warning system includes an order processor (3), a database server (1) including a database (10), and a programmable apparatus (2). The order processor receives forecasted requirements from customers and stores them in the database. The programmable apparatus includes an order-parsing module (22), a stock analysis module (24), a warning module (26), and a mail service module (28). The order-parsing module calculates requirements of each material based on the forecasted requirements. The stock analysis module calculates a maximum stock and a minimum stock of each material based on the calculated requirements of the material and on standard stock rules, determines whether a current stock of the material falls between the maximum stock and the minimum stock, and thereby creates a stock analysis result. The warning module creates warnings based on stock analysis results. The mail service module sends e-mail warnings to relevant users.

Claims

1. A stock-warning system comprising:

an order processor for receiving and processing forecasted requirements from at least one customer;

a database server for receiving and accessing the forecasted requirements, the database server comprising a database for storing the forecasted requirements, e-mail addresses and bills of materials; and

a programmable apparatus comprising;

an order-parsing module for calculating requirements of individual materials based on the forecasted requirements and the bills of materials;

a stock analysis module for calculating a maximum stock and a minimum stock of each material based on one or more requirements of the material, determining whether a current stock of the material falls between the maximum stock and the minimum stock, and creating an analysis result;

a warning module for creating warnings based on analysis results; and

a mail service module for sending e-mail warnings to relevant users.

2. The stock-warning system as claimed in claim 1, wherein the order processor converts the forecasted requirements from an original format into another predetermined format that can be recognized by a relational database.

3. The stock-warning system as claimed in claim 2, wherein the original format is electronic data interchange format.

4. The stock-warning system as claimed in claim 1, further comprising at least one warehouse computer located at at least one site, wherein the at least one warehouse computer stores current inventory information on each material.

5. The stock-warning system as claimed in claim 4, wherein the database server is interconnected with the at least one warehouse computer through an electronic communications network and periodically accesses the at least one warehouse computer to obtain current inventory information.

6. The stock-warning system as claimed in claim 1, wherein the requirements of individual materials indicate a daily requirement of each material.

7. The stock-warning system as claimed in claim 1, wherein the database is further for storing standard stock rules defining rules for calculating the maximum stock and minimum stock of each material.

8. The stock-warning system as claimed in claim 7, wherein the stock analysis module is for calculating a maximum stock and a minimum stock of each material based further on the standard stock rules.

9. The stock-warning system as claimed in claim 1, wherein the analysis result includes an abnormal rate of each material determined by comparing the current stock of the material with the maximum stock and the minimum stock of the material.

10. The stock-warning system as claimed in claim 1, further comprising a plurality of client computers for receiving the e-mail warnings.

11. A stock-warning method, the method comprising:

providing an order processor for receiving and processing forecasted requirements from at least one customer;

providing a database server for receiving and accessing the forecasted requirements, the database server comprising a database for storing the forecasted requirements, e-mail addresses and bills of materials; and

providing a programmable apparatus comprising;

an order-parsing module for calculating requirements of individual materials based on the forecasted requirements and the bills of materials;

a stock analysis module for calculating a maximum stock and a minimum stock of each material based on one or more requirements of the material, determining whether a current stock of the material falls between the maximum stock and the minimum stock, and creating an analysis result;

a warning module for creating warnings based on analysis results; and

a mail service module for sending e-mail warnings to relevant users.

12. The stock-warning method as claimed in claim 11, further comprising the step of providing at least one warehouse computer located at at least one site for accessing current inventory information.

13. The stock-warning method as claimed in claim 11, further comprising the step of providing a plurality of client computers for receiving the e-mail warnings.

14. A stock-warning method, the method comprising:

(a) receiving at least one forecasted requirement from at least one customer and storing the at least one forecasted requirement in a database;

(b) calculating a requirement of a material according to the at least one forecasted requirement;

(c) calculating at least a minimum stock of the material, determining whether a current stock of the material is beyond the minimum stock, and creating an analysis result;

(d) creating a warning based on the analysis result; and

(e) accessing the database for an e-mail address of a relevant user, and sending an e-mail warning to the relevant user.

15. The stock-warning method as claimed in claim 14, wherein step (a) further comprises converting the at least one forecasted requirement from an original format into a predetermined format which can be recognized by a relational database.

16. The stock-warning method as claimed in claim 14, further comprising the step of periodically accessing at least one warehouse computer located at at least one site to obtain current inventory information of the material.

17. The stock-warning method as claimed in claim 14, in step (c), further including calculating a maximum stock and determining whether said the current stock is below said maximum stock.

18. The stock-warning method as claimed in claim 17, wherein in step (c), the calculation of a maximum stock and a minimum stock of the material is based on standard stock rules.

19. The stock-warning method as claimed in claim 14, further comprising the step of receiving the e-mail warning through a client computer.