CN102542364B - Method and system for balancing substitute materials in material requirement planning - Google Patents

Method and system for balancing substitute materials in material requirement planning Download PDF

Info

Publication number
CN102542364B
CN102542364B CN201010578459.1A CN201010578459A CN102542364B CN 102542364 B CN102542364 B CN 102542364B CN 201010578459 A CN201010578459 A CN 201010578459A CN 102542364 B CN102542364 B CN 102542364B
Authority
CN
China
Prior art keywords
demand
supply
substitution
node
balancing
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.)
Active
Application number
CN201010578459.1A
Other languages
Chinese (zh)
Other versions
CN102542364A (en
Inventor
李小平
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Kingdee Software China Co Ltd
Original Assignee
Kingdee Software China Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Kingdee Software China Co Ltd filed Critical Kingdee Software China Co Ltd
Priority to CN201010578459.1A priority Critical patent/CN102542364B/en
Publication of CN102542364A publication Critical patent/CN102542364A/en
Application granted granted Critical
Publication of CN102542364B publication Critical patent/CN102542364B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Landscapes

  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • General Factory Administration (AREA)

Abstract

The invention relates to a method for balancing substitute materials in material requirement planning. The method for balancing the substitute materials in the material requirement planning comprises the following steps of: forming a material substitution tree according to a material substitution relationship such that each material is taken as a node of the material substitution tree, a substituted material is taken as a child node of the substitute material, and a substitute material is taken as a father node of the substituted material; computing a supply and demand condition of the nodes in each production sub-stage according to the material supply and demand information of a lowest layer of child node of the material substitution tree so as to obtain substitution demand data; and computing the supply and demand condition of the nodes according to the material supply and demand information of all levels of father nodes and the substitution demand of the corresponding child nodes so as to obtain the substitution demand data. In addition, the invention further relates to a system for balancing the substitute materials in the material requirement planning. According to the material substitution relationship and the supply and demand information of the materials with the substitution relationship, the method and the system can organize the materials with the substitution relationship into the material substitution tree to substitute and manage, and a layer-by-layer computation method is adopted, so that the substitutions of all materials can be computed and completed in one step to improve the management efficiency.

Description

The method and system of balancing substitute materials in material requirement planning
[technical field]
The present invention relates to handling of goods and materials, especially relate to a kind of method and system of balancing substitute materials in material requirement planning.
[background technology]
Adopt area of computer aided enterprise production management, first computing machine will be enable to read product slate manufactured by enterprise and all materials that will relate to, for the ease of computer recognizing, the product structure of expressing by diagram must be changed into certain data layout, this file describing product structure is in data format exactly Bill of Material (BOM), namely be BOM (Bill Of Material, Bill of Material (BOM)).It is the technological document defining product structure, and therefore, it is also called product structure table or product tree.
Due to the requirement difference to product quality, adopting plastics on new materials or change in the work etc. to reduce costs, often needing the material of existing use to replace to new material.In original product structure, required material, for taking time, supplying requirement etc. to be all changeless, when managing material, can manage according to the program of setting in advance easily.
But when relating to material and replacing, material supply and demand originally certainly will change, need to recalculate to make the material equilibrium of supply and demand.In traditional replacement management, replace material B for material A, replace in the following way:
1. calculate the equilibrium of supply and demand of material A during certain;
2. the equilibrium of supply and demand of calculate material B phase at the same time, replace if there is material in this period, then can be inserted in material A by the substitutive demand of material B, cause the equilibrium of supply and demand of material A to be broken, material A needs to recalculate.
As can be seen from above, there is material replacement each time and the equilibrium of supply and demand of material A all can be caused to be destroyed, and need to recalculate.Namely material A needs the number of times of reruning to be exactly decided by the number of times of the substitutive demand of material B.This makes the efficiency of management greatly reduce, and especially when relating to various materials and replacing, calculates and will become very frequent.
[summary of the invention]
Based on this, be necessary to provide a kind of method improving the balancing substitute materials in material requirement planning of the efficiency of management.
A method for balancing substitute materials in material requirement planning, comprises the steps: the process of production to be divided into multiple production sub according to Production requirement; At each production sub, obtain the supply and demand information with the material of substitutional relation that described production sub relates to; The supply/demand of often kind of material is calculated according to described supply and demand information; Wherein, to every two connected production subs, the next son stage calculates after a upper sub.
Preferably, the described step calculating the supply/demand of often kind of material according to supply and demand information specifically comprises: form material substitution tree according to material substitution relation, make the node that each material is set as described material substitution, the child node of replaced material material as an alternative, substitute materials is as the father node of replaced material; According to the material supply and demand information of the bottom child node that described material substitution is set, the supply/demand of computing node, obtains substitutive demand data; According to the material supply and demand information of father node at different levels and the substitutive demand of corresponding child node, the supply/demand of step-by-step calculation node, obtains substitutive demand data.
In addition, a kind of system of balancing substitute materials in material requirement planning is also provided.
A kind of system of balancing substitute materials in material requirement planning, comprise server and be connected at least one client of carrying out data interaction with server, described server comprises receiver module and processing module, and described client comprises acquisition module: described acquisition module is used at each production sub collection material supply and demand document and material substitution relation and is sent to receiver module; Described receiver module receives described material supply and demand document and material substitution relation; Described processing module calculates the supply/demand of often kind of material according to described supply and demand information.
Preferably, described processing module specifically forms material substitution tree according to material substitution relation, makes the node that each material is set as described material substitution, the child node of replaced material material as an alternative, and substitute materials is as the father node of replaced material; According to the material supply and demand information of the bottom child node that described material substitution is set, the supply/demand of computing node, obtains substitutive demand data; According to the substitutive demand of father node material supply and demand information at different levels and corresponding child node, the supply/demand of step-by-step calculation node, obtains substitutive demand data.
Said method and this management method of system and system manage by production sub, carry out carrying out one-time calculation to material supply/demand at each sub, can reduce unpredictable substituting as far as possible.
Further, according to material substitution relation and the supply and demand information of material with substitutional relation, be organized into material substitution tree by there being the material of substitutional relation and carry out substituting management, and adopt the method successively calculated, substituting of all materials is once calculated, improves the efficiency of management.
[accompanying drawing explanation]
Fig. 1 is the process flow diagram of the balancing substitute materials in material requirement planning of an embodiment;
Fig. 2 is the material substitution tree schematic diagram of an embodiment;
Fig. 3 is the system construction drawing of the balancing substitute materials in material requirement planning of an embodiment.
[embodiment]
Be further described below in conjunction with the method and system of specific embodiment to balancing substitute materials in material requirement planning.
First the process of production is divided into multiple production sub according to Production requirement by the method for the balancing substitute materials in material requirement planning of the present embodiment.Produce some time periods that sub is the whole production run of product, multiple continuous print produces the whole production run that sub forms product jointly.Produce sub mainly to divide according to Production requirement, Production requirement is the various Regulatory requirements in process of producing product, such as divides according to operation.
Secondly, to each generation sub, all supply and demand information with the material of substitutional relation is obtained.At each generation sub, the material related to may be different, has again a lot of substitutional relation between various material.Obtain that this production sub relates to and there is the supply and demand information of the material of substitutional relation, for calculating the supply/demand of often kind of material.All materials with substitutional relation are organized together, and obtains material supply and demand information in advance, can disposable often kind of material supply/demand be calculated, there will not be because the interim alternative problem causing repeatedly calculating.And because the division of sub, the material supply/demand in each stage is easy to control, reduce the interim alternative possibility occurred.
Between each sub above-mentioned, generally there is obvious sequencing.Therefore account form is the supply/demand first calculating the inner often kind of material of each sub, is then that sub calculates one by one.Namely to every two connected production subs, the next son stage calculates after a upper sub.
Wherein, in the present embodiment, the step calculating the supply/demand of often kind of material according to described supply and demand information is concrete as shown in Figure 1, comprises the steps:
S10: form material substitution tree according to material substitution relation, make the node that each material is set as described material substitution, the child node of replaced material material as an alternative, substitute materials is as the father node of replaced material.
In the production run of a product, relate to the alternative use of material.Material substitution has a variety of causes and mode, as deficiencies of stores, uses the lower material of price, produces products etc. by different quality requirements.Be generally used for producing the main material of product and be called principal goods material, being used for the material of alternative principal goods material is called and substitutes material.According to production object and the difference in the period of production, alternative material may have a variety of, and according to priority forms substitutional relation step by step.Such as produce a sub, principal goods material is A, B, preferential spent material C substitute, material C so again can spent material D substitute.Therefore for embodying this substitutional relation, material is organized into material substitution tree.As shown in Figure 2, for the material substitution of the present embodiment is set.Wherein main material A, B all can be substituted by material C, and therefore main material A, B are the child nodes of material C, and material C is the father node of main material A, B, and in like manner, material C is the child node of material D, and material D is the father node of material C.
S20: at each production sub, get the bottom child node of described material substitution tree, according to material supply and demand information, the supply/demand of computing node, obtains substitutive demand data.Production sub is the some time periods in producing, and arranges according to Production requirement.General production run all comprises plural production sub.The material of material substitution tree bottom child node is the principal goods material in production run, and in the present embodiment, bottom child node is material A, B.
Production sub starts, and can list the demand for principal goods material, and namely the storage situation of each principal goods material is the supply of this material.Supply is deducted demand, obtains the supply/demand of material, when difference is not less than zero, represent in liberal supply, do not need to use substitute materials; When difference is less than zero, represent under-supply, need to use substitute materials, now the absolute value of this difference is exactly the substitutive demand data of principal goods material for substitute materials.The first stage of such as producing, main material A demand 1000, principal goods material B demand 800, if main material A, B respectively need 900, then the supply and demand difference of A is the supply and demand difference of 1000-900=100, B is 800-900=-100.For this reason, material B produces substitutive demand 100 at the father node place of its substitute materials C.
After bottom child node has calculated, just can the supply/demand of step-by-step calculation father node at different levels.
S30: father node at different levels is according to the substitutive demand of material supply and demand information and corresponding child node, and the supply/demand of computing node, obtains substitutive demand data.In the present embodiment, first the supply/demand of material C is calculated, now, except the demand of material C not only comprises projected demand to itself (if phase is at the same time as the principal goods material of other production phases), also have the substitutive demand of material B, if material C supply 800, projected demand is also 800, the substitutive demand of material B is 100, then the supply and demand difference of material C is 800-800-100=-100.Secondly, the supply/demand of the father node D of material C is calculated.Computing method are identical with the method for the supply/demand calculating material C.
As shown in Figure 3, be the system construction drawing of balancing substitute materials in material requirement planning of an embodiment.This system comprises server 10 and is connected at least one client 20 of carrying out data interaction with server 10.Server 10 comprises receiver module 12 and processing module 14, and client 20 comprises acquisition module 22.
Acquisition module 22 is for gathering material supply and demand document and material substitution relation and being sent to receiver module 12 at each production sub.Receiver module 12 receives described material supply and demand document and material substitution relation.
Processing module 14 is for calculating the supply/demand of often kind of material according to described supply and demand information.Be specially: form material substitution tree according to material substitution relation, make the node that each material is set as described material substitution, the child node of replaced material material as an alternative, substitute materials is as the father node of replaced material; According to the material supply and demand information of the bottom child node that described material substitution is set, the supply/demand of computing node, obtains substitutive demand data; According to the substitutive demand of father node material supply and demand information at different levels and corresponding child node, the supply/demand of computing node, obtains substitutive demand data.
The above embodiment only have expressed several embodiment of the present invention, and it describes comparatively concrete and detailed, but therefore can not be interpreted as the restriction to the scope of the claims of the present invention.It should be pointed out that for the person of ordinary skill of the art, without departing from the inventive concept of the premise, can also make some distortion and improvement, these all belong to protection scope of the present invention.Therefore, the protection domain of patent of the present invention should be as the criterion with claims.

Claims (4)

1. a method for balancing substitute materials in material requirement planning, is characterized in that, comprises the steps:
The process of production is divided into multiple production sub according to Production requirement;
At each production sub, obtain the supply and demand information with the material of substitutional relation that described production sub relates to;
The supply/demand of often kind of material is calculated according to described supply and demand information, comprise: form material substitution tree according to material substitution relation, make the node that each material is set as described material substitution, the child node of replaced material material as an alternative, substitute materials is as the father node of replaced material;
Wherein, to every two connected production subs, the next son stage calculates after a upper sub.
2. the method for balancing substitute materials in material requirement planning as claimed in claim 1, is characterized in that, the described step calculating the supply/demand of often kind of material according to supply and demand information specifically comprises:
According to the material supply and demand information of the bottom child node that described material substitution is set, the supply/demand of computing node, obtains substitutive demand data;
According to the material supply and demand information of father node at different levels and the substitutive demand of corresponding child node, the supply/demand of step-by-step calculation node, obtains substitutive demand data.
3. a system for balancing substitute materials in material requirement planning, comprise server and be connected at least one client of carrying out data interaction with server, described server comprises receiver module and processing module, and described client comprises acquisition module:
Described acquisition module is used at each production sub collection material supply and demand document and material substitution relation and is sent to receiver module;
Described receiver module receives described material supply and demand document and material substitution relation;
Described processing module calculates the supply/demand of often kind of material according to described supply and demand information; Wherein, described processing module forms material substitution tree according to material substitution relation, makes the node that each material is set as described material substitution, and the child node of replaced material material as an alternative, substitute materials is as the father node of replaced material.
4. the system of balancing substitute materials in material requirement planning as claimed in claim 3, it is characterized in that, the material supply and demand information of the bottom child node that described processing module is specifically set according to described material substitution, the supply/demand of computing node, obtains substitutive demand data; According to the substitutive demand of father node material supply and demand information at different levels and corresponding child node, the supply/demand of step-by-step calculation node, obtains substitutive demand data.
CN201010578459.1A 2010-12-08 2010-12-08 Method and system for balancing substitute materials in material requirement planning Active CN102542364B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201010578459.1A CN102542364B (en) 2010-12-08 2010-12-08 Method and system for balancing substitute materials in material requirement planning

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201010578459.1A CN102542364B (en) 2010-12-08 2010-12-08 Method and system for balancing substitute materials in material requirement planning

Publications (2)

Publication Number Publication Date
CN102542364A CN102542364A (en) 2012-07-04
CN102542364B true CN102542364B (en) 2015-05-20

Family

ID=46349209

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201010578459.1A Active CN102542364B (en) 2010-12-08 2010-12-08 Method and system for balancing substitute materials in material requirement planning

Country Status (1)

Country Link
CN (1) CN102542364B (en)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104766179A (en) * 2015-04-23 2015-07-08 广州视源电子科技股份有限公司 Maintenance method and system for substitute materials
CN111209765B (en) * 2018-11-21 2023-05-30 Oppo(重庆)智能科技有限公司 Method and device for identifying material bar code and terminal equipment
CN111105134A (en) * 2019-11-11 2020-05-05 华勤通讯技术有限公司 Material demand plan calculation method and platform, electronic device and storage medium

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101650802A (en) * 2009-08-17 2010-02-17 金蝶软件(中国)有限公司 Material information modifying method and material information modifying device in material demand plan system

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
FI109436B (en) * 1999-04-16 2002-07-31 Ericsson Telefon Ab L M Data processing in an access node
CN1444161A (en) * 2002-03-11 2003-09-24 联想(北京)有限公司 Resolution method of material detailed list (BOM) data
CN100534042C (en) * 2007-07-06 2009-08-26 中国人民解放军国防科学技术大学 Two-stage distributed application layer multicasting method facing to MSVMT problem
CN101458786A (en) * 2007-12-14 2009-06-17 英业达股份有限公司 Material bracket altering method and system of material manifest

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101650802A (en) * 2009-08-17 2010-02-17 金蝶软件(中国)有限公司 Material information modifying method and material information modifying device in material demand plan system

Also Published As

Publication number Publication date
CN102542364A (en) 2012-07-04

Similar Documents

Publication Publication Date Title
CN103440364B (en) Based on the method and system of BIM auto-building model WBS node
CN102446303B (en) Distribution method and device of process route assembly
CN102289743A (en) Computer simulation system and method in product production process
CN102542364B (en) Method and system for balancing substitute materials in material requirement planning
CN103246549B (en) A kind of method and system of data conversion storage
CN111736994B (en) Resource arranging method, system, storage medium and electronic equipment
CN109359907A (en) A kind of storekeeper bar code management system
CN104899257A (en) Data updating method and device in distributed data warehouse
CN102024209A (en) Method for automatically replacing materials by replacement tree technology
CN104199955B (en) information management system and method
CN105279269A (en) SQL generating method and system for supporting table free association
CN103257638B (en) Reentrant process patch modeling method for complex manufacturing process
EP2881903A1 (en) Managing design updates in a manufacturing execution system
CN102467697A (en) Material demand generation method and system
CN103530134A (en) Configurable software platform structure
CN105335813A (en) Material kitting acquisition method and system
CN101145227A (en) Operation data processing method and processor
CN105426601A (en) Diversity design scheme reporting method and system based on BIM (Building Information Modeling)
CN116401325A (en) Data processing method and device based on data warehouse model
CN102750353B (en) Method for analyzing distributed data in key value library
CN115564204A (en) Parallel processing method for demand resource allocation in supply chain
JP2012221124A (en) Production plan creation system
JP6397657B2 (en) Requirements calculation system, requirements calculation method and program
US9443215B2 (en) Next generation sequencing management
US7624043B2 (en) Inventory control system and method in recycle-oriented society

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant