CN1619554A - Storage prewarning system and method - Google Patents
Storage prewarning system and method Download PDFInfo
- Publication number
- CN1619554A CN1619554A CN 200310112318 CN200310112318A CN1619554A CN 1619554 A CN1619554 A CN 1619554A CN 200310112318 CN200310112318 CN 200310112318 CN 200310112318 A CN200310112318 A CN 200310112318A CN 1619554 A CN1619554 A CN 1619554A
- Authority
- CN
- China
- Prior art keywords
- stock
- early warning
- inventory
- warehouse
- mentioned
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- General Factory Administration (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention provides a stock early-warning system and its method. Said system includes a stock early-warning server, several subdate bases, a data base, and several user machines, in which the stock early-warning server includes several software function modules. Said invention also provides the action of every software function module, and also provides the method for utilizing said early-warning system.
Description
[technical field]
The present invention relates to a kind of stock's early warning system and method, particularly relate to a kind of order of can be actual period and estimating and production capacity data and regulate the stock and produce a stock's early warning system and a method that has an inventory status table of early warning sign according to certain.
[background technology]
For manufacturing enterprise, inventory cost is occupied quite great proportion in the total cost of enterprise, how effectively to control the stock, reducing inventory cost is that an enterprise reduces total cost and the key factor that improves profit, so stock control becomes the important task of manufacturing enterprise.Industry is long-standing and comparatively active to the research of stock control, and (Enterprise Resource Planning, ERP), stock control always is the emphasis of research to the reordering points method Enterprise Resources Planning till now from the forties in 20th century.
The tradition stock control focus on the tank farm stock of how formulating standard, and carry out stock's adjunctive program according to standard stock and actual inventory, the common trait of these methods does not consider to influence stock's external factor, production scene situation, order situation, material procurement ability etc. as change constantly, only study best stock as the independent variable of research with reserved copy, therefore static often, the theoretic best stock of the best stock who adopts said method to calculate, best stock has deviation with reality.As U.S. trademark patent office in No. 20030101107 open application case of on May 29th, 2003, this application case name is called " inventory management system and method (Inventory Management System and Method) " this application case and discloses a kind of method that can calculate Optimal Inventory and replenish the stock on this basis according to the on-hand inventory data, comprise the steps: to determine inventory requirements, determine Optimal Inventory according to above-mentioned inventory requirements, judge whether present inventory level is Optimal Inventory, if not Optimal Inventory, the method for determining is adjusted the stock makes it reach the Optimal Inventory level.
Though above-mentioned application case discloses the technology of utilizing computing machine and network calculations Optimal Inventory, but above-mentioned application case only discloses method how to utilize available data to calculate Optimal Inventory, do not relate to and how to calculate inventory requirements and to adjust the stock with this according to order and production capacity, generate the inventory status table that certain period has the early warning sign simultaneously, and these technology are crucial for reducing inventory cost in demand that satisfies order timely and the maximum magnitude.
[summary of the invention]
Fundamental purpose of the present invention is to provide a kind of stock's early warning system and method, can be actual according to certain period and the order estimated and production capacity data generate an inventory status table that has an early warning sign automatically.
Another purpose of the present invention is to provide a kind of stock's early warning system and method, can regulate material between adjacent warehouse.
For achieving the above object, the invention provides a kind of stock's early warning system, it includes: a plurality of subdata bases are used to store the order data of marketing system and the production capacity data of production scene; One stock's early warning server, be used to receive the production capacity data and the adjacent warehouse stock material table of order data, production scene, calculate the material requirement amount of certain period production scene, inquire about the material inventory in corresponding warehouse, judge the material requirement amount that satisfies that can above-mentioned corresponding warehouse material inventory optimum, and generate a some time phase library that has the early warning sign and deposit state table; One database is used to store order data and production capacity data, material requirement table, corresponding warehouse stock material table, adjacent warehouse stock material table, inventory status table.
Wherein stock's early warning server includes: a data receiver module is used to receive the production capacity data and the adjacent warehouse stock material table of order data, production scene; One material requirement computing module is used for calculating the material requirement amount of certain period production scene according to the above order data and production capacity data; One inquiring stock module is used to inquire about the material inventory in corresponding warehouse; One tank farm stock judge module is used to judge that can corresponding warehouse material inventory the optimum material requirement amount that satisfies; One adjacent warehouse supply and demand judge module, be used for according to above-mentioned adjacent warehouse stock material table judge can and adjacent warehouse between mutually regulate material; One material is transferred module, is used for regulating between the warehouse material; One early warning sign generation module is used to generate the early warning sign; And a report generation module, be used to generate an inventory status table that has an early warning sign.
The present invention also provides a kind of stock's method for early warning, and it includes following steps: (a) receive order data, production capacity data and adjacent warehouse stock material table; (b) calculate the material requirement amount of certain period production scene according to the above order data and production capacity data; (c) material inventory in inquiry and corresponding warehouse, above-mentioned production scene; (d) judge that can above-mentioned corresponding warehouse material inventory the optimum material requirement amount that satisfies; (e), then judge and to regulate material mutually with adjacent warehouse if material inventory is greater than or less than optimum material requirement amount; (f) if can regulate material mutually, then call in or access material from adjacent warehouse with adjacent warehouse; (g) if can not regulate material mutually, then generate the early warning sign automatically with adjacent warehouse; And (h) generate a some time phase library that has the early warning sign and deposit state table.
By stock's early warning system provided by the invention and method, not only can between adjacent warehouse, regulate material, and can have the inventory status table of early warning sign, thereby remind the stock control personnel to prepare to adjust the demand that satisfies order and production scene that the stock makes its optimum constantly according to certain period order and the automatic generation one of production capacity data.
[description of drawings]
Fig. 1 is the hardware structure figure of stock's early warning system of the present invention.
Fig. 2 is the main software functional block diagram of stock's early warning server of stock's early warning system of the present invention.
Fig. 3 is stock's method for early warning process flow diagram of the present invention.
[embodiment]
As shown in Figure 1, be the hardware structure figure of stock's early warning system of the present invention.This stock's early warning system includes a plurality of subdata base 10, one stock's early warning servers 11, and connects 12, one databases, 13, one networks 14 and a plurality of subscriber computer 15.Wherein subdata base 10 is used for each marketing system storage order data and production scene storage production capacity data, the above order comprises that promptly actual order also comprises the order of the period of estimating in future, and above-mentioned production capacity comprises that promptly actual production capacity also comprises the production capacity of the period of estimating in future.Stock's early warning server 11 includes a plurality of software function modules, be used to receive the production capacity data and the adjacent warehouse stock material table of order data, production scene, calculate required inventory according to the above order data and production scene production capacity data, the inquiry and the material inventory in corresponding warehouse, production scene, and judge corresponding warehouse material inventory whether optimum satisfy material requirement etc.Above-mentioned material inventory comprises actual inventory and transportation inventory amount.Above-mentioned transportation inventory amount is meant purchasing department's inventory that placed an order and that can put in storage in the above-mentioned period.
Described subscriber computer 15 links to each other with stock's early warning server 11 by network 14.Network 14 can be intranet (Intranet), also can be the communication network of internet (Internet) or other type.Stock's early warning server 11 links to each other with database 13 by connecting 12.Connecting 12 is that a database connects, as the open type data storehouse connect (Open DatabaseConnectivity, ODBC), or the Java database connect (Java Database Connectivity, JDBC).
As shown in Figure 2, be the main software functional block diagram of stock's early warning server of stock's early warning system of the present invention.This stock's early warning server 11 includes a data receiver module 20, one material requirement computing module 21, one inquiring stock module 22, one tank farm stock judge module 23, one adjacent warehouse supply and demand judge module 24, one material is transferred module 25, one early warning sign generation modules 26, and a report generation module 27.
Described data receiver module 20 is used to receive the order data of certain period marketing system, the production capacity data and the adjacent warehouse stock material table of production scene, stores above-mentioned data simultaneously in database 13.Material requirement computing module 21 is used for the material requirement amount of calculating certain each production scene of period according to the order that receives and production capacity data, and generates the material demand schedule, is stored in simultaneously in the database 13.Inquiring stock module 22 is used for inquiring about according to above-mentioned material requirement table the material inventory in corresponding warehouse.
Tank farm stock judge module 23 is used for judging that according to predefined criterion can above-mentioned material inventory the optimum material requirement amount that satisfies.Above-mentioned criterion is formulated by the stock control personnel, for example, optimal inventory can be to satisfy the material inventory of producing field demand in three days, for another example, optimal inventory can also be with certain function as basis for estimation, and the inventory that satisfies this function is exactly optimum material inventory.The concrete geographic distribution of adopting the production scene which kind of criterion will serve according to warehouse and warehouse, warehouse capacity, purchasing power etc. and decide.
Adjacent warehouse supply and demand judge module 24 can according to be stored in adjacent warehouse stock material table in the database 13 judge can and adjacent warehouse between regulate material mutually.Material is transferred module 25 and is used for regulating material between the warehouse, is about to unnecessary material and accesses to adjacent warehouse, or call in material to cover the shortage from adjacent warehouse.One early warning sign generation module 26 is used to generate the early warning sign, comprises the excessive sign of shortage of stock sign and stock.Report generation module 27 can be regulated the result according to above-mentioned material supply and demand judgement and material and be generated one automatically and have the inventory status table of early warning sign and it is passed to the associated external system and is stored in the database 13.Above-mentioned associated external system such as production scene management system, procurement management system etc.
As shown in Figure 3, be stock's method for early warning process flow diagram of the present invention.At first, data receiver module 20 receives the order data of certain period marketing system, the production capacity data and the adjacent warehouse stock material table of production scene, and with above-mentioned data storage (step S301) in database 13.The material requirement amount that material requirement computing module 21 calculates certain each production scene of period according to the order and the production capacity data of reception, and generate the material demand schedule, be stored in simultaneously (step S302) in the database 13.Inquiring stock module 22 is inquired about the material inventory (step S303) in corresponding warehouse according to above-mentioned material requirement table.Tank farm stock judge module 23 according to above-mentioned material Query Result and predefined criterion judge material inventory greater than, less than still just in time satisfying material requirement amount (step S304).If the result who judges shows that material inventory satisfies the material requirement amount, then directly enter step S311.
If judged result shows material inventory greater than the material requirement amount, can adjacent warehouse supply and demand judge module 24 can be judged according to above-mentioned adjacent warehouse stock material table transfer to excessive material adjacent warehouse (step S305).If excessive materials can be transferred to adjacent warehouse, material is transferred module 25 excessive materials is transferred to adjacent warehouse (step S306).If the result who judges shows that adjacent warehouse does not need above-mentioned excessive materials, then early warning sign generation module 26 generates " excessive " early warning sign (step S307) automatically.
If tank farm stock judge module 23 is judged material inventory less than the material requirement amount according to above-mentioned material Query Result and predefined criterion, can adjacent warehouse supply and demand judge module 24 can be judged and call in material (step S308) from adjacent warehouse according to being stored in adjacent warehouse stock material table in the database 13.If can call in material from adjacent warehouse, material is transferred module 25 will call in not enough material (step S309) from adjacent warehouse.If the result who judges shows that adjacent warehouse does not have ability that the material of above-mentioned deficiency is provided, then early warning sign generation module 26 generates " deficiency " early warning sign (step S310) automatically.Report generation module 27 has the inventory status table (step S311) of early warning sign according to above-mentioned material supply and demand judgement and the automatic generation one of adjusting situation.Report generation module 27 transmits above-mentioned inventory status table to the associated external system, stores above-mentioned inventory status table (step S312) in database 13 simultaneously.
Claims (10)
1. stock's early warning system is characterized in that, comprising:
A plurality of subdata bases are used for storing respectively the data of production scene and marketing system;
One stock's early warning server comprises:
One data receiver module is used to receive actual and order data, the reality of estimating and production capacity data of estimating and adjacent warehouse stock material table of certain period;
One material requirement computing module is used for calculating the material requirement amount of certain period production scene according to the above order data and production capacity data;
One inquiring stock module is used to inquire about the material inventory with corresponding warehouse, above-mentioned production scene;
One tank farm stock judge module is used to the above-mentioned material requirement amount that satisfies of judging that can above-mentioned corresponding warehouse material inventory optimum; And
One report generation module is used to generate an inventory status table that has an early warning sign; And
One database is used to store order data, production capacity data, material requirement table, corresponding warehouse stock material table, adjacent warehouse stock material table, reaches the inventory status table.
2. stock's early warning system as claimed in claim 1 is characterized in that, wherein material inventory comprises actual inventory and purchasing department inventory that placed an order and that can put in storage in the above-mentioned period.
3. stock's early warning system as claimed in claim 2 is characterized in that, also comprise an adjacent warehouse supply and demand judge module be used for according to above-mentioned adjacent warehouse stock material table judge can and adjacent warehouse between regulate material mutually.
4. stock's early warning system as claimed in claim 3 is characterized in that, comprises that also material transfer module is used for regulating between the warehouse material.
5. stock's early warning system as claimed in claim 3 is characterized in that, comprises that also an early warning sign generation module is used to generate the early warning sign.
6. stock's method for early warning is characterized in that, includes following steps:
Receive certain period reality and the order data of estimating, the production capacity data and the adjacent warehouse stock material table of production scene;
Calculate the material inventory in the material requirement amount inquiry of certain the period production scene warehouse corresponding with above-mentioned production scene according to the above order data and production capacity data;
Judge the material requirement amount that satisfies that can above-mentioned corresponding warehouse material inventory optimum; And
The inventory status table that has the early warning sign according to judged result generation one.
7. stock's method for early warning as claimed in claim 6 is characterized in that, wherein material inventory comprises actual inventory and purchasing department inventory that placed an order and that can put in storage in the above-mentioned period.
8. stock's method for early warning as claimed in claim 6, it is characterized in that, judge that wherein can corresponding warehouse material inventory the optimum step that satisfies the material requirement amount comprise also that then can judgement regulate material mutually with adjacent warehouse if the result who judges shows that material inventory can not the optimum material requirement amount that satisfies.
9. can stock's method for early warning as claimed in claim 8 is characterized in that, wherein judge also to comprise if can regulate material mutually with adjacent warehouse with the step that material is regulated in adjacent warehouse mutually, then and regulate material between the adjacent warehouse mutually.
10. can stock's method for early warning as claimed in claim 8 is characterized in that, wherein judge also to comprise if can not regulate material mutually with adjacent warehouse with the step that material is regulated in adjacent warehouse mutually, then generates the early warning sign automatically.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200310112318 CN1619554A (en) | 2003-11-20 | 2003-11-20 | Storage prewarning system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200310112318 CN1619554A (en) | 2003-11-20 | 2003-11-20 | Storage prewarning system and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN1619554A true CN1619554A (en) | 2005-05-25 |
Family
ID=34759707
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 200310112318 Pending CN1619554A (en) | 2003-11-20 | 2003-11-20 | Storage prewarning system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1619554A (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101360130B (en) * | 2008-09-27 | 2011-09-21 | 北大方正集团有限公司 | Manuscript processing method and system |
| CN103903119A (en) * | 2014-03-26 | 2014-07-02 | 青岛宝井钢材加工配送有限公司 | Self-adaption inventory early warning device for BOM materials in material control park |
| CN106991543A (en) * | 2016-01-20 | 2017-07-28 | 阿里巴巴集团控股有限公司 | Allot system and allot method |
| CN107169140A (en) * | 2017-06-14 | 2017-09-15 | 广州御融通电子设备开发有限公司 | A kind of Parts Inventory early warning system monitored based on automatic mixing |
| CN108022068A (en) * | 2016-11-04 | 2018-05-11 | 豪夫迈·罗氏有限公司 | Laboratory stock's warning system |
| CN110378514A (en) * | 2019-06-04 | 2019-10-25 | 石化盈科信息技术有限责任公司 | A kind of material balance early warning system and method |
| CN110599057A (en) * | 2019-09-19 | 2019-12-20 | 珠海格力电器股份有限公司 | Order business processing method, centralized scheduling platform and computer readable storage medium |
| CN110910060A (en) * | 2019-11-06 | 2020-03-24 | 青岛大学 | Automatic control management system of dye consumption model |
| CN110956352A (en) * | 2019-05-14 | 2020-04-03 | 宏图物流股份有限公司 | Detection method for warehouse shelving and shelving strategy efficiency |
| CN112053171A (en) * | 2020-09-01 | 2020-12-08 | 珠海随变科技有限公司 | Production progress feedback method, equipment, system and server |
| CN113034116A (en) * | 2021-04-15 | 2021-06-25 | 武汉源铭盛网络科技有限公司 | Industrial production material cooperative management system based on Internet and artificial intelligence |
| CN113240360A (en) * | 2021-03-31 | 2021-08-10 | 江苏经贸职业技术学院 | Space-saving inventory replenishment method and device for unmanned intelligent retail terminal |
-
2003
- 2003-11-20 CN CN 200310112318 patent/CN1619554A/en active Pending
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101360130B (en) * | 2008-09-27 | 2011-09-21 | 北大方正集团有限公司 | Manuscript processing method and system |
| CN103903119A (en) * | 2014-03-26 | 2014-07-02 | 青岛宝井钢材加工配送有限公司 | Self-adaption inventory early warning device for BOM materials in material control park |
| CN103903119B (en) * | 2014-03-26 | 2018-02-09 | 青岛宝井钢材加工配送有限公司 | Adaptive stock's prior-warning device of BOM materials in a kind of material logistics garden |
| CN106991543B (en) * | 2016-01-20 | 2021-08-27 | 菜鸟智能物流控股有限公司 | Allocation system and allocation method |
| CN106991543A (en) * | 2016-01-20 | 2017-07-28 | 阿里巴巴集团控股有限公司 | Allot system and allot method |
| CN108022068A (en) * | 2016-11-04 | 2018-05-11 | 豪夫迈·罗氏有限公司 | Laboratory stock's warning system |
| CN107169140A (en) * | 2017-06-14 | 2017-09-15 | 广州御融通电子设备开发有限公司 | A kind of Parts Inventory early warning system monitored based on automatic mixing |
| CN110956352A (en) * | 2019-05-14 | 2020-04-03 | 宏图物流股份有限公司 | Detection method for warehouse shelving and shelving strategy efficiency |
| CN110378514A (en) * | 2019-06-04 | 2019-10-25 | 石化盈科信息技术有限责任公司 | A kind of material balance early warning system and method |
| CN110378514B (en) * | 2019-06-04 | 2023-08-29 | 石化盈科信息技术有限责任公司 | Material balance early warning system and method |
| CN110599057A (en) * | 2019-09-19 | 2019-12-20 | 珠海格力电器股份有限公司 | Order business processing method, centralized scheduling platform and computer readable storage medium |
| CN110910060A (en) * | 2019-11-06 | 2020-03-24 | 青岛大学 | Automatic control management system of dye consumption model |
| CN110910060B (en) * | 2019-11-06 | 2024-02-23 | 青岛大学 | Automatic control management system of dyeing material consumption model |
| CN112053171A (en) * | 2020-09-01 | 2020-12-08 | 珠海随变科技有限公司 | Production progress feedback method, equipment, system and server |
| CN113240360A (en) * | 2021-03-31 | 2021-08-10 | 江苏经贸职业技术学院 | Space-saving inventory replenishment method and device for unmanned intelligent retail terminal |
| CN113240360B (en) * | 2021-03-31 | 2023-08-22 | 江苏经贸职业技术学院 | Space-saving inventory replenishment method and device for unmanned intelligent retail terminal |
| CN113034116A (en) * | 2021-04-15 | 2021-06-25 | 武汉源铭盛网络科技有限公司 | Industrial production material cooperative management system based on Internet and artificial intelligence |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Yu et al. | Benefits of information sharing with supply chain partnerships | |
| CN107256443B (en) | Line loss real-time computing technique based on business and data integration | |
| EP0752134B1 (en) | Factory network having a plurality of factories and method of coordinating same | |
| US6889106B2 (en) | Master production scheduling management system and method | |
| Ettl et al. | A supply network model with base-stock control and service requirements | |
| Gaonkar et al. | Collaboration and information sharing in global contract manufacturing networks | |
| Krajewski et al. | The value of production schedule integration in supply chains | |
| JPH08123535A (en) | Factory network having plurality of factories and method forcoordinating plurality of factories with one factory network | |
| CN111260194B (en) | Block chain-based accurate supply method and system for materials | |
| CN1619554A (en) | Storage prewarning system and method | |
| US7493184B2 (en) | Available to promise allocation optimization tool | |
| US7580766B1 (en) | Manufacturing resource planning by entity | |
| US20040117227A1 (en) | Production capability simulating system and method | |
| Álvarez et al. | A web-based approach for exceptions management in the supply chain | |
| JP4739656B2 (en) | Parts supply management system with remaining number management | |
| US20030046193A1 (en) | Method and system for decentralized logistic management of supply chain networks | |
| Váncza et al. | Coordinating Supply Networks in Customized Mass Production:–A Contract-Based Approach | |
| EP1843232A1 (en) | Production scheduling system | |
| CN1620665A (en) | Parts ordering system for improving efficiency of parts delivery | |
| Toh et al. | The future role of DNC in metalworking SMEs | |
| CN1591435A (en) | Digital nerve stock management system and method thereof | |
| JP2001100829A (en) | Method and device for processing product delivery answer and information recording medium | |
| CN1614604A (en) | Stock inquiring system and method | |
| CN1661608A (en) | System and method for controlling shipment | |
| Ni et al. | An inventory control policy for maintenance networks |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Open date: 20050525 |