CN102034162A - Material requirement planning (MRP) operation method and device - Google Patents

Material requirement planning (MRP) operation method and device Download PDF

Info

Publication number
CN102034162A
CN102034162A CN2010105998957A CN201010599895A CN102034162A CN 102034162 A CN102034162 A CN 102034162A CN 2010105998957 A CN2010105998957 A CN 2010105998957A CN 201010599895 A CN201010599895 A CN 201010599895A CN 102034162 A CN102034162 A CN 102034162A
Authority
CN
China
Prior art keywords
bom
substitution group
computing
substitution
group
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
Application number
CN2010105998957A
Other languages
Chinese (zh)
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.)
Guangzhou Shiyuan Electronics Thecnology Co Ltd
Original Assignee
Guangzhou Shiyuan Electronics Thecnology 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 Guangzhou Shiyuan Electronics Thecnology Co Ltd filed Critical Guangzhou Shiyuan Electronics Thecnology Co Ltd
Priority to CN2010105998957A priority Critical patent/CN102034162A/en
Publication of CN102034162A publication Critical patent/CN102034162A/en
Pending legal-status Critical Current

Links

Images

Landscapes

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

Abstract

The embodiment of the invention discloses a material requirement planning (MRP) operation method. The method comprises the following steps: sequentially searching whether materials in a bill of material (BOM) are in a preset material substitution group or not, wherein the material substitution group comprises mutually substitutable material information; directly performing material deducting operation on the materials if the search result is that the materials are not in the material substitution group; and searching a material substitution group corresponding to the materials if the search result is that the materials are in the material substitution group, performing material deducting operation on the materials according to a preset substitution rule in the material substitution group, and circularly executing until the material deducting operation of all materials in the BOM of a product is completed. By the method, the restriction of 'one-way material substitution representation method' in the prior art can be broken through, the possibility of dead circulation which often occurs in the 'one-way material substitution representation method' is prevented, the problem of low MRP operation efficiency in the prior art is solved, one-way, two-way or multi-way material substitution can be realized, and the efficiency of MRP operation is greatly improved; and the MRP operation on the materials can be performed according to the priority, and the flexibility of material substitution can be improved.

Description

A kind of MRP operational method and device
Technical field
The present invention relates to electronic applications, relate in particular to a kind of MRP operational method and device.
Background technology
Product can be managed out all component materials of formation product and subordinate relation thereof, quantity required by product structure.Can adopt structure tree, structural table etc. to have the structure of certain product of representation of file of authority data form, mandatory declaration constitutes each material of product and quantity required thereof, composition structural relation each other hereof, this class file is called Bill of Material (BOM) (BOM, Bill of Material).
MRP (MRP, Material Requirement Planning) is meant subordinate and quantitative relation according to each level material of product structure, with every product is the plan object, with completion period be the time reference back scheduling, by the time in advance length distinguish the assign plans sequencing of time of each material, be plan management of materials and quipment pattern in a kind of industrial manufacturing enterprise.Generally, MRP is the production plan of elder generation according to the market demand forecast and the formulation of client's order, then based on production schedule, product structure and Inventory Performance, by demand and the required time that calculates required material, thereby determine the processing progress of product and a kind of technology of order schedule.
Existing enterprise generally manages the product of its production and required material etc. by MRP, after finishing the MRP computing, find to need produce or the material of buying not enough and can't satisfy the production demand time, enterprise is in order to reduce material cost, and the material that will lack substitutes with unclassified stores usually.Yet, current material substitution relation often is unidirectional substitutional relation, i.e. " unidirectional material substitution representation ", the endless loop of material substitution can appear when causing carrying out the MRP computing, can safeguard by single nested inspection of BOM and Low Level Code in the prior art to prevent endless loop, but greatly reduce the efficient of MRP computing; Publication number is that the disclosed alternative material form method for building up of the patented claim document of CN101369325A is a problem how to seek suitable alternative material in order to solve, and alternative material form is in layer down to set up, also be unidirectional substitutional relation, can not solve the low problem of MRP operation efficiency.
Summary of the invention
Embodiment of the invention technical matters to be solved is, a kind of MRP operational method and a kind of MRP arithmetic unit are provided, by improving the data structure of material substitution, avoid occurring endless loop, solve the low problem of MRP operation efficiency in the prior art, improved the efficient and the dirigibility of MRP computing greatly.
In order to solve the problems of the technologies described above, the embodiment of the invention provides a kind of MRP operational method, comprising:
Search material among the Bill of Material (BOM) BOM successively whether in default material substitution group; But the material information that comprises the phase trans-substitution in the described material substitution group;
When lookup result for not the time, directly described material is detained the material computing; When lookup result when being, find out the material substitution group of described material correspondence, and described material detained the material computing, to finish button material computing all materials among the described BOM according to alternative rule default in the described material substitution group.
Wherein, whether the described material of searching successively among the BOM also comprises before the step in default material substitution group:
The data structure of described material substitution group is set, is specially: but the material of phase trans-substitution is divided into same material substitution group, and the group id of each material substitution group is set.
Wherein, the step that the data structure of described material substitution group is set also comprises: the alternative precedence information that each material in the described material substitution group is set;
The step of described material being detained the material computing according to alternative rule default in the described material substitution group comprises:
Low order substitutes material from the priority height to priority according to substituting precedence information described in the described material substitution group, to finish the button material computing of described material.
Wherein, the step that the data structure of described material substitution group is set also comprises: the material substitution condition in the described material substitution group is set;
The step of described material being detained the material computing according to alternative rule default in the described material substitution group also comprises:
According to described material substitution condition, control the material substitution in the described material substitution group.
Wherein, whether the described material of searching successively among the BOM also comprises before the step in default material substitution group: the data structure of described BOM is set, is specially: the appointment that at least one material is set in described BOM substitutes material information; Or in described BOM, be provided with and all materials do not substituted.
Wherein, when setting does not substitute all materials in described BOM, do not carry out the described material step in default material substitution group whether of searching successively among the BOM, directly detain the material computing, to finish button material computing to all materials among the described BOM according to the material among the described BOM;
When the appointment that at least one material is set in described BOM substitutes material information, described search successively among the BOM material whether the step in default material substitution group comprise:
Do not search described at least one material among the described BOM whether in default material substitution group, directly substitute and specify the unidirectional alternative rule of substitute material that described at least one material is detained the material computing in the material information according to described appointment.
Wherein, also comprise after the described step of finishing the button material computing of all materials among the described BOM:
Generate the procurement information table according to button material operation result, described procurement information table comprises the material procurement information of material substitution group.
Correspondingly, the embodiment of the invention also discloses a kind of MRP arithmetic unit, comprising:
Alternate sets is searched module, and whether the material that is used for searching successively Bill of Material (BOM) BOM is in default material substitution group; But the material information that comprises the phase trans-substitution in the described material substitution group;
Computing module, be used for when the lookup result of searching module in described alternate sets for not the time, directly described material is carried out the computing of MRP button material; The lookup result of searching module when described alternate sets is when being, find out the material substitution group of described material correspondence, and described material is detained the material computing according to alternative rule default in the described material substitution group, to finish button material computing to all materials among the described BOM.
Wherein, described MRP arithmetic unit also comprises:
The alternate sets data structure is provided with module, is used to be provided with the data structure of described material substitution group, is specially: but the material of phase trans-substitution is divided into same material substitution group, and the group id of each material substitution group is set.
Wherein, described alternate sets data structure is provided with module and also comprises:
Priority is provided with the unit, is used for being provided with the alternative precedence information of described each material of material substitution group;
Described computing module comprises material substitution unit and operator unit, wherein
The lookup result that described material substitution unit is used for searching module when described alternate sets is when being, find out the material substitution group of described material correspondence, and low order substitutes to material from the priority height to priority according to priority described in the described material substitution group the alternative precedence information of unit setting to be set;
Described operator unit is used for the alternate orders according to described material substitution unit, finishes the button material computing of described material.
Wherein, described MRP arithmetic unit also comprises:
Substitute the condition setting module, be used for being provided with the material substitution condition of the described material substitution group of control;
Described material substitution unit also comprises alternative condition control module, is used for the material substitution condition according to described alternative condition setting module setting, controls the material substitution in the described material substitution group.
Wherein, described MRP arithmetic unit also comprises:
The BOM data structure is provided with module, is used to be provided with the data structure of described BOM, is specially: the appointment that at least one material is set in described BOM substitutes material information; Or in described BOM, be provided with and all materials do not substituted.
Wherein, be provided with in described BOM when all materials not being substituted when described BOM data structure is provided with module, described alternate sets is searched module and is not carried out the material searched successively among the BOM whether in default material substitution group; Described computing module is directly detained the material computing according to the material among the described BOM, to finish the MRP computing to all materials among the described BOM;
When described BOM data structure is provided with module is provided with at least one material in described BOM appointment and substitutes material information, described alternate sets is searched module and is not searched described at least one material among the described BOM whether in default material substitution group, and described computing module directly substitutes according to described appointment specifies the unidirectional alternative rule of substitute material that described at least one material is detained the material computing in the material information.
Wherein, described MRP arithmetic unit also comprises:
The procurement information table generates module, is used for generating the procurement information table according to the button material operation result of described computing module, and described procurement information table comprises the material procurement information of material substitution group.
Implement the embodiment of the invention, have following beneficial effect:
By improving the data structure of material substitution, but the material of phase trans-substitution is divided into same material substitution group, search material among the Bill of Material (BOM) BOM when carrying out the MRP computing successively whether in default material substitution group, and described material is detained the material computing according to alternative rule default in the material substitution group that finds out, broken the constraint of " unidirectional material substitution representation " in the prior art, stopped often to occur in " unidirectional material substitution representation " possibility of endless loop, solved the low problem of MRP operation efficiency in the prior art, can realize unidirectional, any material substitution such as two-way or multidirectional has improved the efficient of MRP computing greatly; Can detain the material computing according to this priority level to material by the priority level of material substitution in the material substitution group is set; The material substitution condition is set,, has increased the dirigibility of material substitution greatly to control the material substitution in the described material substitution group; The data structure of BOM can also be set, the constraint condition of unidirectional material substitution is arranged in the BOM attribute, and the alternative rule of material substitution is arranged in the attribute of material substitution group arbitrarily, realize the function distinguishing of unidirectional material substitution and any material substitution, further improved the efficient of MRP computing; Generate and show and material procurement information in each material substitution group make material information present to the user at a glance, make that the user is convenient to carry out the material inquiry quickly and easily.
Description of drawings
In order to be illustrated more clearly in the embodiment of the invention or technical scheme of the prior art, to do to introduce simply to the accompanying drawing of required use in embodiment or the description of the Prior Art below, apparently, accompanying drawing in describing below only is some embodiments of the present invention, for those of ordinary skills, under the prerequisite of not paying creative work, can also obtain other accompanying drawing according to these accompanying drawings.
Fig. 1 is the schematic flow sheet of first embodiment of MRP operational method of the present invention;
Fig. 2 is the schematic flow sheet of second embodiment of MRP operational method of the present invention;
Fig. 3 is the structural representation of first embodiment of MRP arithmetic unit of the present invention;
Fig. 4 is the structural representation of second embodiment of MRP arithmetic unit of the present invention;
Fig. 5 is the structural representation of the 3rd embodiment of MRP arithmetic unit of the present invention;
Fig. 6 is the structural representation of the 4th embodiment of MRP arithmetic unit of the present invention;
Fig. 7 is the structural representation of the 5th embodiment of MRP arithmetic unit of the present invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the invention, the technical scheme in the embodiment of the invention is clearly and completely described, obviously, described embodiment only is the present invention's part embodiment, rather than whole embodiment.Based on the embodiment among the present invention, those of ordinary skills belong to the scope of protection of the invention not making the every other embodiment that is obtained under the creative work prerequisite.
The schematic flow sheet of first embodiment of MRP operational method of the present invention as shown in Figure 1 comprises:
Step S101: search material among the BOM successively whether in default material substitution group;
Particularly, the data structure of material substitution group as described in custom system (as Enterprise Resources Plan ERP system etc.) sets in advance, the material that can substitute mutually is divided into same material substitution group, and the group id of each material substitution group is set; Custom system is provided with a plurality of material substitution groups, shown in example of following table:
Numbering The material substitution group Name of material Stock number
1 The 3rd group Integrated circuit-LDO A
2 The 3rd group Integrated circuit-LDO B
3 The 3rd group Integrated circuit C
Material A, B and C belong to same material substitution group, and group id was 3 (promptly belonging to the 3rd group), but material A, B and C trans-substitution mutually.Need to prove that the material substitution group that is provided with in the embodiment of the invention is not limited to the form in the above-mentioned table, can also comprise the projects such as tank farm stock, demand or material supply merchant of each material, last table is one of them embodiment just.
Custom system is searched material among the BOM whether in default material substitution group successively when carrying out the MRP computing; When lookup result for not the time, execution in step S102 then, when lookup result when being, execution in step S103 then; Particularly, for example when calculating material A successively, custom system will be searched material A whether in default material substitution group, find material A and exist in the default material substitution group (the 3rd group), and promptly lookup result is for being, then execution in step S103; And for example when calculating material P successively, custom system will be searched material P whether in default material substitution group, if when searching less than material P in default material substitution group, and execution in step S102 then.
Need to prove that custom system can be by the material among the traversal BOM in the material substitution group that is provided with, search material whether in default material substitution group; Custom system perhaps can whether carry group id, search material, as long as can be searched material among the BOM successively whether in default material substitution group whether at the default medium multiple lookup method of material substitution group by the material of searching among the BOM.
Step S102: directly described material is detained the material computing;
Step S103: find out the material substitution group of described material correspondence, and described material is detained the material computing, to finish button material computing to all materials among the described BOM according to alternative rule default in the described material substitution group.
Particularly, as current calculating material A, custom system finds out the 3rd group of material substitution group so, and according to alternative rule default in the 3rd group of material substitution group material A is detained the material computing;
For example, should default alternative rule be alternate orders from A to B again to C, custom system will be detained the material computing to material A earlier so, when the material A shortage of stock, detain the material computing from employing the alternative material A of material B, when the material B shortage of stock, employ the alternative material B of material C certainly and detain the material computing;
And for example, should default alternative rule be alternate orders from B to A again to C, though active user's system-computed material A so, but custom system will substitute material A with material B earlier automatically and detain the material computing, when the material B shortage of stock, detain the material computing from employing the alternative material B of material A, when the material A shortage of stock, employ the alternative material A of material C certainly and detain the material computing.
Need to prove that this default alternative rule can be the alternate orders of custom system acquiescence, also alternate orders that can be provided with or the like for needs adjustment according to the user.
Further, the above embodiment of the present invention also comprises: revise or newly-built described material substitution group.Be specially:
When the user need import a kind of material to system, the material information of input can carry group id, automatically described material information is inserted in the corresponding material substitution group according to described group id with the indication custom system; For example, the user imports material D, the material D of input carries the 3rd group group id, perhaps the user can directly import material D in the 3rd group, be equivalent to the group id that material D that custom system gets access to input carries the 3rd group, custom system is inserted material D in the 3rd group of material substitution group automatically so, and as above Biao example is formed the 3rd group with material A, B and C; And for example, the user imports material D, and the material D of input carries the 10th group group id, and the active user system does not have the 10th group, and custom system is newly-built the 10th group of material substitution group so, and material D is inserted in the 10th group of material substitution group.
Again further, the schematic flow sheet of second embodiment of MRP operational method of the present invention as shown in Figure 2 comprises:
Step S201: the alternative precedence information that each material in the described material substitution group is set;
Particularly, custom system can be provided with the alternative precedence information of each material in the material substitution group according to user's needs, as following table:
Numbering The material substitution group Name of material Stock number Priority
1 The 3rd group Integrated circuit-LDO A 0
2 The 3rd group Integrated circuit-LDO B 1
3 The 3rd group Integrated circuit C 2
The priority-level that material A is set in the 3rd group of material substitution group is a highest level 0, and the priority-level of material B is second high-level 1, and the priority-level of material C is the 3rd high-level 2.
Need to prove, the precedence information of each material is not limited to the form in the above-mentioned table in the material substitution group that is provided with in the embodiment of the invention, be not limited to wait and represent priority-level with 0,1 and 2, as long as can indicate the priority-level of dividing material, last table can also comprise the projects such as tank farm stock, demand or material supply merchant of each material.
Step S202: search material among the BOM successively whether in default material substitution group;
Particularly, when lookup result for not the time, execution in step S203 then; When lookup result when being, execution in step S204 then; Step S101 as above-mentioned embodiment repeats no more here.
Step S203: directly described material is detained the material computing;
Step S204: find out the material substitution group of described material correspondence, and low order substitutes to material from the priority height to priority according to substituting precedence information described in the described material substitution group, to finish the button material computing of described material.
Particularly, as current calculating material C, custom system finds out the 3rd group of material substitution group so, and low order substitutes material from the priority height to priority according to substituting precedence information in the 3rd group of material substitution group, to finish the button material computing of described material; That is, as above shown in the table, custom system will be detained the material computing to material A earlier, when the material A shortage of stock, employ the alternative material A of material B certainly and will detain the material computing, when the material B shortage of stock, employ the alternative material B of material C certainly and will detain the material computing.
Need to prove, the user can be according to the needs of self, as adjusting the alternative precedence information of material in the material substitution group at any time according to the storage situation of current each material library or material supply merchant's situation etc., and the alternative precedence information of when the user adds a kind of material of input in certain material alternate sets, adjusting material.
Again further, the step of the data structure that described material substitution group is set of the embodiment of the invention also comprises: the material substitution condition in the described material substitution group is set;
Particularly, custom system can set in advance the material substitution condition of material substitution group according to user's needs, for example be provided with by the SQL conditional statement, certain material is set can not be substituted in certain specific product, specific certain product perhaps is set substitutes or the like the additional condition that substitutes by certain material, so when custom system is calculated certain material, with the SQL conditional statement (being the material substitution condition) that calls automatically and carry out about this material, with the material substitution in the control material substitution group; Data structure example as a material substitution group of following table:
Figure BDA0000039852650000081
When custom system is calculated the A material, will call and carry out the SOL conditional statement of FModel LIKE ' %triend% ' automatically so, can only in the triend scheme, substitute with the control material A; Perhaps when custom system is calculated the C material, will call and carry out the SOL conditional statement of FModel LIKE ' %triend% ' automatically, C can only substitute in the triend scheme with the control material.
Again further, whether the material of searching successively among the BOM of the embodiment of the invention can also comprise before the step in default material substitution group: the data structure of described BOM is set, is specially: the appointment that at least one material is set in described BOM substitutes material information; Or in described BOM, be provided with and all materials do not substituted.
The step of MRP operational method so of the present invention is specially:
When setting does not substitute all materials in described BOM, do not carry out the described material step in default material substitution group whether of searching successively among the BOM, directly detain the material computing, to finish button material computing to each material among the described BOM according to the material among the described BOM;
When the appointment that at least one material is set in described BOM substitutes material information, described search successively among the BOM material whether the step in default material substitution group comprise: do not search described at least one material among the described BOM whether in default material substitution group, directly substitute and specify the unidirectional alternative rule of substitute material that described at least one material is carried out the MRP computing in the material information according to described appointment.Particularly, as the data structure example of a BOM of following table:
Sequence number The thing item number Consumption Specify and substitute material Other attribute ……
1 A 1 A2 …… ……
2 B 1 …… ……
3 C2 2 C1 …… ……
4 F 1 …… ……
5 G 1 …… ……
6 H 2 …… ……
7 J 3 …… ……
8 K 1 …… ……
9 L 1 …… ……
10 M 2 …… ……
11 Q 3 …… ……
…… …… ……
The appointment that is provided with materials such as material A and material C2 in BOM substitutes material information, show that material A can only be carried out unidirectional substituting by A2 in described BOM, material C2 can only carry out unidirectional substituting by C1, so, when carrying out the MRP computing of material A, to not search material A among the BOM whether in default material substitution group, directly can specify and carry out unidirectional alternative unidirectional alternative rule by material A 2 material A is detained the material computing according to material A, promptly, when the material A shortage of stock, can only specify with material A 2 alternative material A and detain the material computing.
Again further, after the step of embodiment of the invention button material computing of all materials in finishing described BOM, can also comprise: generate the procurement information table according to button material operation result, described procurement information table comprises the material procurement information of material substitution group.
Particularly, the embodiment of the invention can generate following procurement information table:
Figure BDA0000039852650000101
This procurement information table comprises stock, in transit, the procurement demand of buying, total stock, add up to that buying is in transit, total demand, group stock, group demand or the like, need to prove, the procurement information table that generates in the embodiment of the invention is not limited to the form in the above-mentioned table, and last table can also comprise projects such as the group buying is in transit, suggestion buying total amount.The procurement information table that the embodiment of the invention generates shows the buying situation of each material by the form with the material substitution group, the material that will belong to same material substitution group is shown to the user gathering together, make material information present to the user at a glance, realized the function that a lot of former data structures can't realize, as organize stock, group demand, the group buying is in transit and suggestion buying total amount or the like, makes that the user is convenient to carry out the material inquiry quickly and easily.
Implement the embodiment of the invention, by improving the data structure of material substitution, but the material of phase trans-substitution is divided into same material substitution group, search material among the Bill of Material (BOM) BOM when carrying out the MRP computing successively whether in default material substitution group, and described material is detained the material computing according to alternative rule default in the material substitution group that finds out, broken the constraint of " unidirectional material substitution representation " in the prior art, stopped often to occur in " unidirectional material substitution representation " possibility of endless loop, solved the low problem of MRP operation efficiency in the prior art, can realize unidirectional, any material substitution such as two-way or multidirectional has improved the efficient of MRP computing greatly; Can detain the material computing according to this priority level to material by the priority level of material substitution in the material substitution group is set; The material substitution condition is set,, has increased the dirigibility of material substitution greatly to control the material substitution in the described material substitution group; The data structure of BOM can also be set, the constraint condition of unidirectional material substitution is arranged in the BOM attribute, and the alternative rule of material substitution is arranged in the attribute of material substitution group arbitrarily, realize the function distinguishing of unidirectional material substitution and any material substitution, further improved the efficient of MRP computing; Generate and show and material procurement information in each material substitution group make material information present to the user at a glance, make that the user is convenient to carry out the material inquiry quickly and easily.
Describe the MRP operational method of the embodiment of the invention above in detail, below accordingly, describe the MRP arithmetic unit of the embodiment of the invention in detail.
The structural representation of first embodiment of MRP arithmetic unit of the present invention as shown in Figure 3, MRP arithmetic unit 3 comprises: alternate sets is searched module 31 and computing module 32, wherein
Alternate sets is searched material that module 31 is used for searching successively BOM whether in default material substitution group; But the material information that comprises the phase trans-substitution in the described material substitution group;
Computing module 32 be used for when the lookup result of searching module 31 in alternate sets for not the time, directly described material is detained the material computing; The lookup result of searching module 31 when alternate sets is when being, find out the material substitution group of described material correspondence, and described material is detained the material computing according to alternative rule default in the described material substitution group, to finish button material computing to each material among the described BOM.
Particularly, MRP arithmetic unit 3 comprises that also the alternate sets data structure is provided with module 33, be used to set in advance the data structure of described material substitution group, be specially: but the material of phase trans-substitution is divided into same material substitution group, and the group id of each material substitution group is set; MRP arithmetic unit 3 is when carrying out the MRP computing, and whether alternate sets is searched the material that module 31 searches among the BOM successively and be provided with in the default material substitution group of module 33 in the alternate sets data structure; When lookup result for not the time, computing module 32 is directly detained the material computing to described material; When lookup result when being, computing module 32 finds out the material substitution group of described material correspondence, and according to alternative rule default in the described material substitution group described material is detained the material computing, to finish the button material computing to each material among the described BOM.Particularly,
The alternate sets data structure is provided with module 33 and is provided with a plurality of material substitution groups, shown in example of following table:
Numbering The material substitution group Name of material Stock number
1 The 3rd group Integrated circuit-LDO A
2 The 3rd group Integrated circuit-LDO B
3 The 3rd group Integrated circuit C
Material A, B and C belong to same material substitution group, and group id was 3 (promptly belonging to the 3rd group), but material A, B and C trans-substitution mutually.Need to prove that the material substitution group that is provided with in the embodiment of the invention is not limited to the form in the above-mentioned table, can also comprise the projects such as tank farm stock, demand or material supply merchant of each material, last table is one of them embodiment just.
For example when MRP arithmetic unit 3 calculates material A successively, whether alternate sets is searched module 31 and will be searched material A and be provided with in the default material substitution group of module 33 in the alternate sets data structure, finding material A exists in the default material substitution group (the 3rd group), be that lookup result is for being, then computing module 32 finds out the material substitution group of described material correspondence, and described material is detained the material computing according to alternative rule default in the described material substitution group, to finish button material computing to each material among the described BOM; And for example when MRP arithmetic unit 3 calculates material P successively, whether alternate sets is searched module 31 and will be searched material P and be provided with in the default material substitution group of module 33 in the alternate sets data structure, if when searching less than material P in default material substitution group, then computing module 32 is directly detained the material computing to material P.
Need to prove that alternate sets is searched module 31 can be by the material among the traversal BOM in the material substitution group that is provided with, search material and whether be provided with in the default material substitution group of module 33 in the alternate sets data structure; Perhaps can whether carry group id by the material of searching among the BOM, search material and whether the default medium multiple lookup method of material substitution group of module 33 is set, can search material among the BOM successively whether in default material substitution group as long as alternate sets is searched module 31 in the alternate sets data structure.
The lookup result of searching module 31 when alternate sets is when being, computing module 32 finds out the material substitution group of described material correspondence, and described material is detained the material computing according to alternative rule default in the described material substitution group, to finish button material computing to all materials among the described BOM; Particularly,
For example, should default alternative rule be alternate orders from A to B again to C, computing module 32 will be detained the material computing to material A earlier so, when the material A shortage of stock, detain the material computing from employing the alternative material A of material B, when the material B shortage of stock, employ the alternative material B of material C certainly and detain the material computing;
And for example, should default alternative rule be alternate orders from B to A again to C, though so current computing module 32 calculates material A, but computing module 32 will substitute material A with material B earlier automatically and detain the material computing, when the material B shortage of stock, detain the material computing from employing the alternative material B of material A, when the material A shortage of stock, employ the alternative material A of material C certainly and detain the material computing.
Need to prove that this default alternative rule can be the alternate orders of MRP arithmetic unit 3 acquiescences, also alternate orders that can be provided with or the like for needs adjustment according to the user.
Need to prove that also the alternate sets data structure is provided with that module 33 can also be revised or newly-built described material substitution group.Be specially:
When the user need import a kind of material to system, the material information of input can carry group id, with indication alternate sets data structure module 33 is set and automatically described material information is inserted in the corresponding material substitution group according to described group id; For example, the user imports material D, the material D of input carries the 3rd group group id, perhaps the user can directly import material D in the 3rd group, be equivalent to the alternate sets data structure group id that material D that module 33 gets access to input carries the 3rd group is set, the alternate sets data structure is provided with module 33 and automatically material D is inserted in the 3rd group of material substitution group so, and as above Biao example is formed the 3rd group with material A, B and C; And for example, the user imports material D, and the material D of input carries the 10th group group id, does not have the 10th group and current alternate sets data structure is provided with module 33, the alternate sets data structure is provided with module 33 with newly-built the 10th group of material substitution group so, and material D is inserted in the 10th group of material substitution group.
Further, the structural representation of second embodiment of MRP arithmetic unit of the present invention as shown in Figure 4, MRP arithmetic unit 3 comprises that alternate sets searches module 31, computing module 32 and alternate sets data structure module 33 is set, and wherein the alternate sets data structure is provided with module 33 and comprises that priority is provided with unit 331; Computing module 32 comprises material substitution unit 321 and operator unit 322, wherein
Priority is provided with the alternative precedence information that unit 331 is used for being provided with described each material of material substitution group;
Particularly, priority is provided with the alternative precedence information that unit 331 can be provided with each material in the material substitution group according to user's needs, as following table:
Numbering The material substitution group Name of material Stock number Priority
1 The 3rd group Integrated circuit-LDO A 0
2 The 3rd group Integrated circuit-LDO B 1
3 The 3rd group Integrated circuit C 2
The priority-level that material A is set in the 3rd group of material substitution group is a highest level 0, and the priority-level of material B is second high-level 1, and the priority-level of material C is the 3rd high-level 2.
Need to prove, the precedence information of each material is not limited to the form in the above-mentioned table in the material substitution group that is provided with in the embodiment of the invention, be not limited to wait and represent priority-level with 0,1 and 2, as long as can indicate the priority-level of dividing material, last table can also comprise the projects such as tank farm stock, demand or material supply merchant of each material.
The lookup result that material substitution unit 321 is used for searching module 31 when alternate sets is when being, find out the material substitution group of described material correspondence, and low order substitutes to material from the priority height to priority according to described material substitution group medium priority the alternative precedence information that unit 331 is provided with to be set;
Operator unit 322 is used for the alternate orders according to material substitution unit 321, finishes the button material computing of described material.
Particularly, as current calculating material C, alternate sets is searched after module 31 finds out the 3rd group of material substitution group so, low order substitutes material from the priority height to priority according to substituting precedence information in the 3rd group of material substitution group in material substitution unit 321, and the button material computing of described material is finished in operator unit 322 according to the alternate orders of material substitution unit 321; That is, as above shown in the table, the material computing will be detained to material A earlier in operator unit 322, when the material A shortage of stock, employ the alternative material A of material B certainly and will detain the material computing, when the material B shortage of stock, employ the alternative material B of material C certainly and will detain the material computing.
Need to prove, the user can be according to the needs of self, as adjusting the alternative precedence information of material in the material substitution group at any time according to the storage situation of current each material library or material supply merchant's situation etc., and the alternative precedence information of when the user adds a kind of material of input in certain material alternate sets, adjusting material.
Again further, the structural representation of the 3rd embodiment of MRP arithmetic unit of the present invention as shown in Figure 5, MRP arithmetic unit 3 comprises that alternate sets searches module 31, computing module 32 and alternate sets data structure and be provided with outside the module 33, can also comprise and substitute condition setting module 34, material substitution unit 321 also comprises alternative condition control module 3211, wherein
Substitute the material substitution condition that condition setting module 34 is used for being provided with the described material substitution group of control;
Material substitution unit 321 also comprises alternative condition control module 3211, is used for controlling the material substitution in the described material substitution group according to substituting the material substitution condition that condition setting module 34 is provided with.
Particularly, substitute the material substitution condition that condition setting module 34 can set in advance the material substitution group according to user's needs, for example be provided with by the SQL conditional statement, certain material is set can not be substituted in certain specific product, specific certain product perhaps is set substitutes or the like the additional condition that substitutes by certain material, so when custom system is calculated certain material, with the SQL conditional statement (being the material substitution condition) that calls automatically and carry out about this material, with the material substitution in the control material substitution group; Data structure example as a material substitution group of following table:
Figure BDA0000039852650000151
When computing module 32 calculates the A material, substitute the SOL conditional statement that condition control module 3211 will call and carry out FModel LIKE ' %triend% ' automatically so, can only in the triend scheme, substitute with the control material A; Perhaps when computing module 32 calculates the C material, substitute the SOL conditional statement that condition control module 3211 will call and carry out FModel LIKE ' %triend% ' automatically, C can only substitute in the triend scheme with the control material.
Again further, the structural representation of the 4th embodiment of MRP arithmetic unit of the present invention as shown in Figure 6, MRP arithmetic unit 3 comprises that alternate sets searches module 31, computing module 32, alternate sets data structure and be provided with outside module 33 and the alternative condition setting module 34, can also comprise that the BOM data structure is provided with module 35, be used to be provided with the data structure of described BOM, be specially: the appointment that at least one material is set in described BOM substitutes material information; Or in described BOM, be provided with and all materials do not substituted.Particularly, so
Be provided with in described BOM when all materials not being substituted when the BOM data structure is provided with module 35, alternate sets is searched module 31 and is not carried out the material searched successively among the BOM whether in default material substitution group; Computing module 32 is directly detained the material computing according to the material among the described BOM, to finish the button material computing to all materials among the described BOM;
When the BOM data structure is provided with module 35 is provided with at least one material in described BOM appointment and substitutes material information, alternate sets is searched module 31 and is not searched described at least one material among the described BOM whether in default material substitution group, and computing module 32 directly substitutes according to described appointment specifies the unidirectional alternative rule of substitute material that described at least one material is detained the material computing in the material information.Particularly, as the data structure example of a BOM of following table:
Sequence number The thing item number Consumption Specify and substitute material Other attribute ……
1 A 1 A2 …… ……
2 B 1 …… ……
3 C2 2 C1 …… ……
4 F 1 …… ……
5 G 1 …… ……
6 H 2 …… ……
7 J 3 …… ……
8 K 1 …… ……
9 L 1 …… ……
10 M 2 …… ……
11 Q 3 …… ……
…… …… ……
The appointment that is provided with materials such as material A and material C2 in BOM substitutes material information, show that material A can only be carried out unidirectional substituting by A2 in described BOM, material C2 can only carry out unidirectional substituting by C1, so, when computing module 32 is carried out the MRP computing of material A, to not search material A among the BOM whether in default material substitution group, directly can specify and carry out unidirectional alternative unidirectional alternative rule by material A 2 material A is detained the material computing according to material A, promptly, when the material A shortage of stock, can only specify with material A 2 alternative material A and detain the material computing.
Again further, the structural representation of the 5th embodiment of MRP arithmetic unit of the present invention as shown in Figure 7, MRP arithmetic unit 3 comprises that alternate sets searches module 31, computing module 32, alternate sets data structure and module 33 is set, substitutes condition setting module 34 and the BOM data structure is provided with outside the module 35, can also comprise that the procurement information table generates module 36, be used for generating the procurement information table according to the button material operation result of described computing module, described procurement information table comprises the material procurement information of material substitution group.
Particularly, the embodiment of the invention can generate following procurement information table:
Figure BDA0000039852650000171
This procurement information table comprises stock, in transit, the procurement demand of buying, total stock, add up to that buying is in transit, total demand, group stock, group demand or the like, need to prove, the procurement information table that procurement information table generation module 36 generates in the embodiment of the invention is not limited to the form in the above-mentioned table, and last table can also comprise that the group buying is in transit, projects such as total amount are purchased in suggestion.The procurement information table that the procurement information table generation module 36 of the embodiment of the invention generates shows the buying situation of each material by the form with the material substitution group, the material that will belong to same material substitution group is shown to the user gathering together, make material information present to the user at a glance, realized the function that a lot of former data structures can't realize, as organize stock, group demand, the group buying is in transit and suggestion buying total amount or the like, makes that the user is convenient to carry out the material inquiry quickly and easily.
Need to prove that the MRP arithmetic unit 3 in the embodiment of the invention can be the part of custom system (as Enterprise Resources Plan ERP system etc.), this custom system may operate on the general electronic equipment.
In sum, by improving the data structure of material substitution, but the material of phase trans-substitution is divided into same material substitution group, search material among the Bill of Material (BOM) BOM when carrying out the MRP computing successively whether in default material substitution group, and described material is detained the material computing according to alternative rule default in the material substitution group that finds out, broken the constraint of " unidirectional material substitution representation " in the prior art, stopped often to occur in " unidirectional material substitution representation " possibility of endless loop, solved the low problem of MRP operation efficiency in the prior art, can realize unidirectional, any material substitution such as two-way or multidirectional has improved the efficient of MRP computing greatly; Can detain the material computing according to this priority level to material by the priority level of material substitution in the material substitution group is set; The material substitution condition is set,, has increased the dirigibility of material substitution greatly to control the material substitution in the described material substitution group; The data structure of BOM can also be set, the constraint condition of unidirectional material substitution is arranged in the BOM attribute, and the alternative rule of material substitution is arranged in the attribute of material substitution group arbitrarily, realize the function distinguishing of unidirectional material substitution and any material substitution, further improved the efficient of MRP computing; Generate and show and material procurement information in each material substitution group make material information present to the user at a glance, make that the user is convenient to carry out the material inquiry quickly and easily.
One of ordinary skill in the art will appreciate that all or part of flow process that realizes in the foregoing description method, be to instruct relevant hardware to finish by computer program, described program can be stored in the computer read/write memory medium, this program can comprise the flow process as the embodiment of above-mentioned each side method when carrying out.Wherein, described storage medium can be magnetic disc, CD, read-only storage memory body (Read-Only Memory, ROM) or at random store memory body (Random Access Memory, RAM) etc.
Above disclosed is a kind of preferred embodiment of the present invention only, can not limit the present invention's interest field certainly with this, and therefore the equivalent variations of doing according to claim of the present invention still belongs to the scope that the present invention is contained.

Claims (14)

1. a MRP operational method is characterized in that, comprises the steps:
Search material among the Bill of Material (BOM) BOM successively whether in default material substitution group; But the material information that comprises the phase trans-substitution in the described material substitution group;
When lookup result for not the time, directly described material is detained the material computing; When lookup result when being, find out the material substitution group of described material correspondence, and described material detained the material computing, to finish button material computing all materials among the described BOM according to alternative rule default in the described material substitution group.
2. the method for claim 1 is characterized in that, whether the described material of searching successively among the BOM also comprises before the step in default material substitution group:
The data structure of described material substitution group is set, is specially: but the material of phase trans-substitution is divided into same material substitution group, and the group id of each material substitution group is set.
3. method as claimed in claim 2 is characterized in that, the step that the data structure of described material substitution group is set also comprises: the alternative precedence information that each material in the described material substitution group is set;
The step of described material being detained the material computing according to alternative rule default in the described material substitution group comprises:
Low order substitutes material from the priority height to priority according to substituting precedence information described in the described material substitution group, to finish the button material computing of described material.
4. method as claimed in claim 3 is characterized in that, the step that the data structure of described material substitution group is set also comprises: the material substitution condition in the described material substitution group is set;
The step of described material being detained the material computing according to alternative rule default in the described material substitution group also comprises:
According to described material substitution condition, control the material substitution in the described material substitution group.
5. as each described method of claim 1-4, it is characterized in that, whether the described material of searching successively among the BOM also comprises before the step in default material substitution group: the data structure of described BOM is set, is specially: the appointment that at least one material is set in described BOM substitutes material information; Or in described BOM, be provided with and all materials do not substituted.
6. method as claimed in claim 5, it is characterized in that, when setting does not substitute all materials in described BOM, do not carry out the described material step in default material substitution group whether of searching successively among the BOM, directly detain the material computing, to finish button material computing to all materials among the described BOM according to the material among the described BOM;
When the appointment that at least one material is set in described BOM substitutes material information, described search successively among the BOM material whether the step in default material substitution group comprise:
Do not search described at least one material among the described BOM whether in default material substitution group, directly substitute and specify the unidirectional alternative rule of substitute material that described at least one material is detained the material computing in the material information according to described appointment.
7. method as claimed in claim 6 is characterized in that, also comprises after the described step of finishing the button material computing of all materials among the described BOM:
Generate the procurement information table according to button material operation result, described procurement information table comprises the material procurement information of material substitution group.
8. a MRP arithmetic unit is characterized in that, comprising:
Alternate sets is searched module, and whether the material that is used for searching successively Bill of Material (BOM) BOM is in default material substitution group; But the material information that comprises the phase trans-substitution in the described material substitution group;
Computing module, be used for when the lookup result of searching module in described alternate sets for not the time, directly described material is carried out the computing of MRP button material; The lookup result of searching module when described alternate sets is when being, find out the material substitution group of described material correspondence, and described material is detained the material computing according to alternative rule default in the described material substitution group, to finish button material computing to all materials among the described BOM.
9. MRP arithmetic unit as claimed in claim 8 is characterized in that, also comprises:
The alternate sets data structure is provided with module, is used to be provided with the data structure of described material substitution group, is specially: but the material of phase trans-substitution is divided into same material substitution group, and the group id of each material substitution group is set.
10. MRP arithmetic unit as claimed in claim 9 is characterized in that, described alternate sets data structure is provided with module and also comprises:
Priority is provided with the unit, is used for being provided with the alternative precedence information of described each material of material substitution group;
Described computing module comprises material substitution unit and operator unit, wherein
The lookup result that described material substitution unit is used for searching module when described alternate sets is when being, find out the material substitution group of described material correspondence, and low order substitutes to material from the priority height to priority according to priority described in the described material substitution group the alternative precedence information of unit setting to be set;
Described operator unit is used for the alternate orders according to described material substitution unit, finishes the button material computing of described material.
11. MRP arithmetic unit as claimed in claim 10 is characterized in that, also comprises:
Substitute the condition setting module, be used for being provided with the material substitution condition of the described material substitution group of control;
Described material substitution unit also comprises alternative condition control module, is used for the material substitution condition according to described alternative condition setting module setting, controls the material substitution in the described material substitution group.
12. as each described MRP arithmetic unit of claim 8-11, it is characterized in that, also comprise:
The BOM data structure is provided with module, is used to be provided with the data structure of described BOM, is specially: the appointment that at least one material is set in described BOM substitutes material information; Or in described BOM, be provided with and all materials do not substituted.
13. MRP arithmetic unit as claimed in claim 12, it is characterized in that, be provided with in described BOM when all materials not being substituted when described BOM data structure is provided with module, described alternate sets is searched module and is not carried out the material searched successively among the BOM whether in default material substitution group; Described computing module is directly detained the material computing according to the material among the described BOM, to finish the MRP computing to all materials among the described BOM;
When described BOM data structure is provided with module is provided with at least one material in described BOM appointment and substitutes material information, described alternate sets is searched module and is not searched described at least one material among the described BOM whether in default material substitution group, and described computing module directly substitutes according to described appointment specifies the unidirectional alternative rule of substitute material that described at least one material is detained the material computing in the material information.
14. MRP arithmetic unit as claimed in claim 13 is characterized in that, also comprises:
The procurement information table generates module, is used for generating the procurement information table according to the button material operation result of described computing module, and described procurement information table comprises the material procurement information of material substitution group.
CN2010105998957A 2010-12-22 2010-12-22 Material requirement planning (MRP) operation method and device Pending CN102034162A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN2010105998957A CN102034162A (en) 2010-12-22 2010-12-22 Material requirement planning (MRP) operation method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN2010105998957A CN102034162A (en) 2010-12-22 2010-12-22 Material requirement planning (MRP) operation method and device

Publications (1)

Publication Number Publication Date
CN102034162A true CN102034162A (en) 2011-04-27

Family

ID=43887019

Family Applications (1)

Application Number Title Priority Date Filing Date
CN2010105998957A Pending CN102034162A (en) 2010-12-22 2010-12-22 Material requirement planning (MRP) operation method and device

Country Status (1)

Country Link
CN (1) CN102034162A (en)

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102254240A (en) * 2011-06-03 2011-11-23 用友软件股份有限公司 Data object substitution device and data object substitution method
CN103559558A (en) * 2013-11-07 2014-02-05 金蝶软件(中国)有限公司 Material reserved supply and demand matching method and device
CN104392325A (en) * 2014-11-28 2015-03-04 东北大学 System and method of fused magnesium production energy management based on BOM and MRP algorithms
CN104766179A (en) * 2015-04-23 2015-07-08 广州视源电子科技股份有限公司 Maintenance method and maintenance system for substitute material
CN104866991A (en) * 2015-05-26 2015-08-26 广州视源电子科技股份有限公司 MRP selection method and device
CN105303359A (en) * 2015-12-09 2016-02-03 金蝶软件(中国)有限公司 Method and device of determining material requirement planning
CN108320116A (en) * 2017-05-19 2018-07-24 郑州云海信息技术有限公司 A method of based on SAP system adjust automatically material priority
CN110969379A (en) * 2018-09-28 2020-04-07 北京国双科技有限公司 Alternative material screening method and related device

Non-Patent Citations (6)

* Cited by examiner, † Cited by third party
Title
任荣升 等: "制造业中BOM建模及算法解决方案", 《PLC技术应用200例》 *
李爱平 等: "一种产品BOM展开及生成改进循环算法的实现", 《机电一体化》 *
李目海: "MRPII中BOM模型的分析与算法实现", 《山东师范大学学报(自然科学版)》 *
郭洪禹 等: "MRPII***中MRP分析与实践", 《燕山大学学报》 *
郭洪禹 等: "制造资源计划中的物料清单***", 《计算机辅助工程》 *
黄学文 等: "基于搜索技术的BOM数据死锁检验算法研究", 《计算机应用研究》 *

Cited By (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102254240A (en) * 2011-06-03 2011-11-23 用友软件股份有限公司 Data object substitution device and data object substitution method
CN103559558A (en) * 2013-11-07 2014-02-05 金蝶软件(中国)有限公司 Material reserved supply and demand matching method and device
CN104392325A (en) * 2014-11-28 2015-03-04 东北大学 System and method of fused magnesium production energy management based on BOM and MRP algorithms
CN104766179A (en) * 2015-04-23 2015-07-08 广州视源电子科技股份有限公司 Maintenance method and maintenance system for substitute material
CN104866991A (en) * 2015-05-26 2015-08-26 广州视源电子科技股份有限公司 MRP selection method and device
CN105303359A (en) * 2015-12-09 2016-02-03 金蝶软件(中国)有限公司 Method and device of determining material requirement planning
CN108320116A (en) * 2017-05-19 2018-07-24 郑州云海信息技术有限公司 A method of based on SAP system adjust automatically material priority
CN110969379A (en) * 2018-09-28 2020-04-07 北京国双科技有限公司 Alternative material screening method and related device
CN110969379B (en) * 2018-09-28 2024-04-30 北京国双科技有限公司 Screening method of substitute materials and related device

Similar Documents

Publication Publication Date Title
CN102034162A (en) Material requirement planning (MRP) operation method and device
Henn et al. Tabu search heuristics for the order batching problem in manual order picking systems
Mendoza et al. A serial inventory system with supplier selection and order quantity allocation
US8027860B2 (en) Systems and methods for planning demand for configurable products
CN101650802A (en) Material information modifying method and material information modifying device in material demand plan system
Accorsi et al. A hierarchical procedure for storage allocation and assignment within an order-picking system. A case study
CN105389653A (en) Adaptive material requirement plan (MRP) calculation method
Mustafa Tanrikulu et al. A joint replenishment policy with individual control and constant size orders
Abedini et al. A metric-based framework for sustainable production scheduling
CN101604418A (en) Chemical enterprise intelligent production plan control system based on quanta particle swarm optimization
de Athayde Prata et al. An integer linear programming model for the multiperiod production planning of precast concrete beams
CN102521056A (en) Task allocation device and task allocation method
JP2007072924A (en) Production planning method and production planning system when order reception and market production are mixed
Wutthisirisart et al. The two-warehouse material location selection problem
Yang et al. An available-to-promise decision support system for a multi-site make-to-order production system
CN102222285B (en) Multi-dimensional data linkage computing device and multi-dimensional data linkage computing method
D’Avino et al. Revised MRP for reducing inventory level and smoothing order releases: a case in manufacturing industry
Dai et al. An acquisition policy for a multi-supplier system with a finite-time horizon
Sawik A lexicographic approach to bi-objective scheduling of single-period orders in make-to-order manufacturing
CN104866912A (en) Bulk cargo material yard material pile management method
Barkalov et al. Designing systems of group stimulation in the management of energy complex objects
Wang et al. Hybrid rescheduling optimization model under disruptions in precast production considering real-world environment
Lappas et al. Theoretical and computational comparison of continuous‐time process scheduling models for adjustable robust optimization
Liang et al. Hybrid Algorithm Based on Genetic Simulated Annealing Algorithm for Complex Multiproduct Scheduling Problem with Zero‐Wait Constraint
JP2006120010A (en) Inventory control system and method

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C53 Correction of patent of invention or patent application
CB02 Change of applicant information

Address after: Xue Cheng Ke Zhu Road Guangzhou City, Guangdong province 510663 science No. 192

Applicant after: Guangzhou Shiyuan Electronic Technology Company Limited

Address before: Xue Cheng Ke Zhu Road Guangzhou City, Guangdong province 510663 science No. 192

Applicant before: Guangzhou Shiyuan Electronic Technology Co.,Ltd.

C12 Rejection of a patent application after its publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20110427