Material demand planning method and system, electronic equipment and storage medium

Abstract

The invention relates to the technical field of material demand planning, and particularly discloses a material demand planning method and system, electronic equipment and a storage medium, and the method specifically comprises the steps: building a bill of materials, and obtaining the net demand of each material based on the bill of materials in the same demand day; in response to the condition that the substitution relation of the materials is incomplete substitution, splitting initial rough demands of the substitution materials from the bill of materials, and determining net demand of the substitution materials based on available stock of the substitution materials; the materials with the minimum net demand quantity are selected, the materials are split according to the minimum value in the gross demand and the available stock, and the net demand quantity of the materials is zero; the residual wool demand of the demand item corresponding to the material is supplemented by a replaceable material of the material; updating the bill of materials; the process is repeated until all the substitute materials are split; finally, the final net demand quantity is generated according to the original demand materials. According to the method, the available amount of the alternative materials can be accurately calculated, and stockpiling of unnecessary stock is avoided.

Description

Technical Field

[0001] The present invention relates to the technical field of material requirement planning, and in particular to a material requirement planning method, system, electronic equipment and storage medium. Background Art

[0002] The statements in this section merely provide background information related to the present invention and do not necessarily constitute prior art.

[0003] Material Requirements Planning (MRP) is an algorithm for inventory management and production planning systems for manufacturing companies; material substitution is very common in modern manufacturing. For example, the same specification of memory sticks in laptops can be replaced by multiple brands of products. As a highly modular electronic product, mobile phones may have different batches and multiple suppliers for parts such as screens, camera lenses, and flash memory chips. Depending on the type of substitute materials used, substitute material scenarios are mainly divided into several main types: complete substitution, incomplete substitution, and non-substitution; for example, demand 2 can consume material A or B, and demand 3 can consume material A or C, so materials A, B, and C constitute an incomplete substitution relationship.

[0004] For material requirement planning, most existing technologies only perform material deductions based on preset priority rules without considering the substitutability between materials; this may cause the system to give priority to a certain material, causing the material to be quickly exhausted, while other substitutable materials are idle, affecting subsequent production.

[0005] If the incomplete substitution relationship of materials is taken into account, the inventory calculation can be made more accurate. The existing technology takes global coordination into consideration, takes the minimum overall procurement volume or the minimum total redundant inventory volume as the goal, enumerates all possible allocation situations, constructs the objective function, and obtains the final material requirement plan by solving the objective function; however, in this scenario of incomplete substitution materials, compared with the strategy of material consumption based on preset rules, the global coordination material consumption strategy will make the calculation difficulty of MRP increase sharply, and due to the insufficient computing power of the MRP system, it is easy to fail to output a truly reasonable material requirement plan. Summary of the invention

[0006] In order to solve the above problems, the present invention proposes a material requirement planning method, system, electronic device and storage medium, which can support the coexistence of three scenarios: no substitution, incomplete substitution and complete substitution. The implementation logic is simple and the requirement for computing power is not high, but at the same time a relatively reasonable material requirement plan can be obtained.

[0007] In some embodiments, the following technical solutions are adopted: A method for material requirements planning, comprising: Create a bill of materials, which includes gross material requirements, available inventory, and demand item information; at the same time, determine the substitution relationship and group number of each material; Based on the bill of materials on the same demand day, obtain the gross demand and available inventory of each material required for each demand, and obtain the net demand for each material; In response to the incomplete substitution relationship of the material, the initial gross demand of the substitute material is split out in the bill of materials, and the net demand of the substitute material is determined based on the available inventory of the substitute material; Select the material with the smallest net demand, split the material according to the minimum value of gross demand and available inventory to make its net demand zero; make up the remaining gross demand of the demand item corresponding to the material through the alternative materials of the material; update the bill of materials; repeat the process until all alternative materials are split; finally, generate the final net demand according to the original demand material.

[0008] As a further solution, based on the substitution relationship of the material, the substitution relationship group number of the material is identified; each material has a unique substitution relationship group number identification.

[0009] As a further solution, modify the materials in the same generation relationship group to have the same low-level code. As a further solution, the available inventory of materials is matched in the priority order of irreplaceable, incompletely replaceable and completely replaceable, so as to calculate the net demand in the bill of materials.

[0010] As a further option, it also includes: In response to the substitution relationship of the material being non-substitutable, a net demand for the material is obtained based on a difference between a gross demand for the material and available inventory; Alternatively, in response to the substitution relationship of the material being complete substitution, the available inventory is matched for each material in the substitution relationship group, and the sum of all available inventories is calculated; based on the difference between the gross demand of the material and the sum of the available inventories, the net demand for the material is obtained.

[0011] As a further solution, the initial gross demand for the substitute material is split out in the bill of materials, and the initial gross demand for the substitute material is the gross demand for the corresponding original demand material.

[0012] As a further solution, the materials are split according to the minimum of gross demand and available inventory, specifically: For the material with the smallest net demand, determine the minimum value of its gross demand and available inventory, and use the minimum value as the gross demand and available inventory of the material, so that the net demand of the material is zero; The remaining gross demand of the demand item corresponding to the material is used as the gross demand of the alternative material of the material. If the available inventory of the alternative material is greater than the remaining gross demand, the available inventory of the alternative material in the demand item is set to the remaining gross demand, and the remaining available inventory is transferred to other demand items of the alternative material. If the available inventory of the alternative material is less than the remaining gross demand and all alternative materials have been split, the net demand is calculated based on the remaining gross demand and the available inventory as the gross demand and net demand of the original demand material.

[0013] In other embodiments, the following technical solutions are adopted: A system for material requirement planning, comprising: The BOM building module is used to build the BOM, which includes the gross material demand, available inventory, and demand item information; at the same time, it determines the substitution relationship and group number of each material; The net demand calculation module is used to obtain the gross demand and available inventory of each material required for each demand based on the bill of materials on the same demand day, and obtain the net demand of each material; A net demand update module is used to split the initial gross demand of the substitute material in the bill of materials in response to the substitution relationship of the material being incomplete substitution, and determine the net demand of the substitute material based on the available inventory of the substitute material; Select the material with the smallest net demand, split the material according to the minimum value of gross demand and available inventory to make its net demand zero; make up the remaining gross demand of the demand item corresponding to the material through the alternative materials of the material; update the bill of materials; repeat the process until all alternative materials are split; finally, generate the final net demand according to the original demand material.

[0014] In other embodiments, the following technical solutions are adopted: A terminal device comprises a processor and a memory, wherein the processor is used to implement instructions; the memory is used to store a plurality of instructions, wherein the instructions are suitable for being loaded by the processor and executing the above-mentioned material requirement planning method.

[0015] In other embodiments, the following technical solutions are adopted: A computer-readable storage medium stores a plurality of instructions, wherein the instructions are suitable for being loaded by a processor of a terminal device and executing the above-mentioned material requirement planning method.

[0016] Compared with the prior art, the present invention has the following beneficial effects: (1) The material requirement planning method of the present invention does not need to enumerate all allocation situations, simplifies the calculation logic in the scenario of incomplete material substitution, reduces the calculation difficulty and the requirements for calculation performance; the calculation results can fully meet the material requirements of each demand item, can accurately calculate the available quantity of the substitute material, and avoid the stockpiling of unnecessary inventory, so that the calculation of safety stock is more in line with actual needs and reduces capital occupation.

[0017] (2) The method of the present invention can be directly deployed in the original material requirement planning (MRP) algorithm without changing the framework of the original algorithm. It has the characteristics of low implementation cost, high practicality, novelty, generality and ease of use.

[0018] Other features and advantages of additional aspects of the present invention will be given in part in the following description, and in part will become obvious from the following description, or will be learned through the practice of the present invention. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] Figure 1 A flow chart of a method for material requirement planning in an embodiment of the present invention; Figure 2 This is a workflow diagram for an incomplete replacement scenario in an embodiment of the present invention; Figure 3 Schematic diagram of the system architecture of material requirement planning in an embodiment of the present invention. DETAILED DESCRIPTION

[0020] It should be noted that the following detailed descriptions are illustrative and are intended to provide further explanation of the present application. Unless otherwise specified, all technical and scientific terms used in the present invention have the same meanings as those commonly understood by those skilled in the art to which the present application belongs.

[0021] It should be noted that the terms used herein are only for describing specific embodiments and are not intended to limit the exemplary embodiments according to the present application. As used herein, unless the context clearly indicates otherwise, the singular form is also intended to include the plural form. In addition, it should be understood that when the terms "comprise" and / or "include" are used in this specification, it indicates the presence of features, steps, operations, devices, components and / or combinations thereof.

[0022] Embodiment 1 In one or more embodiments, a material requirements planning method is disclosed, combining Figure 1 , specifically including the following process: S101: Create a bill of materials, which includes gross material demand, available inventory, and demand item information; at the same time, determine the substitution relationship and group number of each material; In this embodiment, the substitution relationship of materials may include three types: irreplaceable, incomplete substitution and complete substitution; among which: ① Irreplaceable means that the material cannot be replaced by other materials, that is, the available inventory of substitute materials is not considered during MRP calculations.

[0023] ② Complete substitution means that all materials in the material substitution relationship can be replaced. For example, material A, material B and material C are in a complete substitution relationship, which means that material A, material B and material C can be mixed.

[0024] ③ Incomplete substitution refers to selecting substitutable subsets from the material substitution relationship and defining [substitutable materials]; for example: material A or material B can be consumed in demand item 2, and material A or material C can be consumed in demand item 3, then material A, material B and material C constitute an incomplete substitution relationship, and material B and material C are the substitutable subsets of material A in different demand items respectively.

[0025] Based on the substitution relationship of materials, a substitution relationship group number is identified for each material; each material has a unique substitution relationship group number identification; in this way, when matching materials, the substitutable materials can be directly matched in the corresponding substitution relationship group according to the substitution relationship.

[0026] As an optional implementation, an editable material substitution relationship table can be constructed, and the required material substitution relationship and group number can be obtained from the table; the specific data structure of the material substitution relationship table is shown in Table 1.

[0027] Table 1 Material substitution relationship table

[0028] At the same time, an association relationship between the bill of materials and the material substitution relationship table is established, so that the substitution relationship and group number of each material in the bill of materials can be obtained; the association relationship structure between the bill of materials and the material substitution relationship table is shown in Table 2.

[0029] Table 2 Bill of Materials - Material Substitution Relationship Table

[0030] In this embodiment, the gross demand and available inventory of materials can be taken from the demand list and the inventory list. The demand list includes the quantity of each material required for different demand items as the gross demand of the material; the inventory list includes the existing inventory and purchase orders of each material, and the sum of the two is the available inventory of the material.

[0031] It should also be noted that the Low-Level Code (LLC) is used to indicate the hierarchical position of a material in the product structure (BOM). In this embodiment, the maximum low-level code in the same material substitution relationship group is used as the low-level code of all materials in the group, thereby ensuring that all materials in the same material substitution relationship group are at the same level, ensuring the correct order of material requirement calculation, and ensuring the accuracy of material requirement calculation.

[0032] S102: Based on the bill of materials on the same demand day, the gross demand and available inventory of each material required for each demand are obtained to obtain the net demand of each material.

[0033] In this embodiment, the net demand for the material = the gross demand for the material - the available inventory of the material.

[0034] Finally, the bill of materials shown in Table 3 can be obtained.

[0035] Table 3 Bill of Materials

[0036] S103: Match the available inventory of each material in the order of priority of irreplaceable, incompletely replaceable and completely replaceable, and then calculate the net demand in the bill of materials.

[0037] In this embodiment, the substitution relationship of each material under different requirements is determined by associating the material substitution relationship table; the non-substitutable materials are processed first, then the incompletely substituted materials are processed, and finally the completely substituted materials are processed; the specific processing process is as follows: ① In response to the substitution relationship of a certain material being non-substitutable, the material cannot be replaced by other materials. The net demand for the material is obtained directly based on the difference between the gross demand and the available inventory of the material.

[0038] ② In response to the incomplete substitution relationship of the material, combined with Figure 2 , the specific process is as follows: S1031: Split out the initial gross demand for substitute materials in the bill of materials, and determine the net demand for substitute materials based on the available inventory of substitute materials; S1032: Select the material with the smallest net demand, and split the material according to the minimum value of the gross demand and the available inventory so that the net demand is zero; S1033: The remaining gross demand of the demand item corresponding to the material is supplemented by the alternative materials of the material; S1034: Update the bill of materials; S1035: Repeat the process until all substitute materials are separated; S1036: Finally, the final net demand is generated based on the original demand materials.

[0039] As a specific implementation method, based on the available inventory of materials in Table 3 and the gross demand for materials under different demands, first, the initial gross demand for alternative materials is split out in the bill of materials. In this embodiment, the initial gross demand for alternative materials is set as the gross demand for the original demand materials, and then the net demand for alternative materials is determined based on the available inventory of alternative materials. This allows the original demand materials and alternative materials to have equal opportunities to participate in subsequent allocation operations, so that materials with large inventory can be allocated first, avoiding unnecessary inventory redundancy.

[0040] The details are shown in Table 4.

[0041] Table 4 Alternative material matching table

[0042] Then, select the material with the smallest net demand. In Table 4, the net demand of material A is 250, the net demand of material B is 10, and the net demand of material C is 260. It can be seen that the net demand of material B in demand item 2 is the smallest, so material B is split. The specific splitting principle is: set the gross demand and available inventory of material B to the minimum of 110, so that its net demand is zero, and remove material B from the materials that can continue to be allocated. At this time, the remaining gross demand of demand 2 becomes 10, and material A is used to make up. Since the available inventory of the material is greater than the remaining gross demand, the available inventory of material A in demand item 2 is set to the remaining gross demand. After the replenishment, the remaining available inventory of material A is used for other demands (such as demand 3). The updated bill of materials is shown in Table 5.

[0043] Table 5 Updated Bill of Materials

[0044] Furthermore, continue to select materials with the smallest net demand. In Table 5, material A has the smallest net demand. Material a is split according to the same principles as above. Then remove material A from the materials that can continue to be allocated alternatively. The updated material list is shown in Table 6.

[0045] Table 6 Updated bill of materials

[0046] Furthermore, we continue to select the material with the smallest net demand, which is material C, and split it; since the available inventory of material C is less than the remaining gross demand at this time, and all alternative materials have been split, the net demand is calculated based on the remaining gross demand and available inventory at this time, and the net demand is 100. The net demand is generated according to the original demand material, that is, the net demand of material A is determined to be 100; as shown in Table 7.

[0047] Table 7 Net requirement list of bill of materials

[0048] ③ In response to the material substitution relationship being complete substitution, all materials in the material substitution relationship group are substitutable. The available inventory is matched for each material in the material substitution relationship group, and the sum of the available inventory of all materials is calculated. The net demand for the material is obtained based on the difference between the gross demand for the material and the sum of all available inventory.

[0049] In this embodiment, the material planning method under the incomplete substitution scenario is considered, which does not require a complicated calculation process and can accurately calculate the available quantity of the substitute material, while avoiding the stockpiling of unnecessary inventory, reducing the requirements for the calculation performance of the MRP system and improving the calculation efficiency.

[0050] The material planning method in the prior art that does not consider substitution relationships and performs material deductions based on preset priority rules is taken as Example 1, the material planning method in the prior art that performs material deductions in a global coordination manner is taken as Example 2, and the material planning method of this embodiment is taken as Example 3. The material inventory and demand of the three examples are exactly the same. Tables 8-10 respectively give the demand planning orders calculated for different examples.

[0051] Table 8 Calculation results of Example 1

[0052] Table 9 Calculation results of Example 2

[0053] Table 10 Calculation results of Example 3

[0054] It can be seen from the results of Tables 8 to 10 that according to the method of Example 1, 260 copies of material A need to be purchased, and 60 copies of material B are redundant; according to the method of Example 2, 200 copies of material A need to be purchased, and there are no other redundant materials; according to the method of Example 3, only 100 copies of material A need to be purchased, and there are no other redundant materials; therefore, the method of this embodiment makes the procurement plan more reasonable, makes full use of existing inventory materials, and does not generate waste of procurement and inventory.

[0055] Embodiment 2 In one or more embodiments, a system for material requirement planning is disclosed, combining Figure 3 ,include: The BOM building module is used to build the BOM, which includes the gross material demand, available inventory, and demand item information; at the same time, it determines the substitution relationship and group number of each material; The net demand calculation module is used to obtain the gross demand and available inventory of each material required for each demand based on the bill of materials on the same demand day, and obtain the net demand of each material; A net demand update module is used to split the initial gross demand of the substitute material in the bill of materials in response to the substitution relationship of the material being incomplete substitution, and determine the net demand of the substitute material based on the available inventory of the substitute material; Select the material with the smallest net demand, split the material according to the minimum value of gross demand and available inventory to make its net demand zero; make up the remaining gross demand of the demand item corresponding to the material through the alternative materials of the material; update the bill of materials; repeat the process until all alternative materials are split; finally, generate the final net demand according to the original demand material.

[0056] It should be noted that the specific implementation methods of the above modules are completely consistent with those in Example 1 and will not be described in detail.

[0057] Embodiment 3 In one or more embodiments, a terminal device is disclosed, which includes a processor and a memory, wherein the processor is used to implement instructions; the memory is used to store multiple instructions, and the instructions are suitable for being loaded by the processor and executing the material requirement planning method described in Example 1.

[0058] It should be understood that in this embodiment, the processor may be a central processing unit CPU, and the processor may also be other general-purpose processors, digital signal processors DSP, application-specific integrated circuits ASIC, off-the-shelf programmable gate arrays FPGA or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The general-purpose processor may be a microprocessor or the processor may also be any conventional processor, etc.

[0059] The memory may include a read-only memory and a random access memory, and provide instructions and data to the processor. A portion of the memory may also include a non-volatile random access memory. For example, the memory may also store information about the device type.

[0060] In the implementation process, each step of the above method can be completed by an integrated logic circuit of hardware in a processor or an instruction in the form of software.

[0061] Embodiment 4 In one or more embodiments, a computer-readable storage medium is disclosed, in which a plurality of instructions are stored, wherein the instructions are suitable for being loaded by a processor of a terminal device and executing the material requirement planning method described in the first embodiment.

[0062] Although the above describes the specific implementation mode of the present invention in conjunction with the accompanying drawings, it is not intended to limit the scope of protection of the present invention. Those skilled in the art should understand that various modifications or variations that can be made by those skilled in the art on the basis of the technical solution of the present invention without creative work are still within the scope of protection of the present invention.

Claims

1. A method for material requirement planning, characterized in that: include: Create a bill of materials, which includes gross material requirements, available inventory, and demand item information; At the same time, determine the substitution relationship and group number of each material; Based on the bill of materials on the same demand day, obtain the gross demand and available inventory of each material required for each demand, and obtain the net demand for each material; In response to the incomplete substitution relationship of the material, the initial gross demand of the substitute material is split out in the bill of materials, and the net demand of the substitute material is determined based on the available inventory of the substitute material; Select the material with the smallest net demand, split the material according to the minimum value of gross demand and available inventory, so that its net demand is zero; the remaining gross demand of the demand item corresponding to the material is supplemented by the alternative material of the material; update the bill of materials; Repeat this process until all substitute materials have been split; finally, the final net demand is generated according to the original demand materials.

2. A material requirement planning method as claimed in claim 1, characterized in that: Based on the material's substitution relationship, identify the material's substitution relationship group number; each material has a unique substitution relationship group number identifier.

3. A material requirement planning method as claimed in claim 1 or 2, characterized in that: Modify the materials in the same generation relationship group to have the same lower-level code.

4. A material requirement planning method as claimed in claim 1, characterized in that: Match the available inventory of materials in the order of priority of irreplaceable, incompletely replaceable and completely replaceable, thereby calculating the net demand in the bill of materials.

5. A material requirement planning method as claimed in claim 1 or 4, characterized in that: Also includes: In response to the substitution relationship of the material being non-substitutable, a net demand for the material is obtained based on a difference between a gross demand for the material and available inventory; Alternatively, in response to the substitution relationship of the material being a complete substitution, the available inventory is matched for each material in the substitution relationship group, and the sum of all available inventories is calculated; Based on the difference between the gross demand for the material and the sum of the available inventory, the net demand for the material is obtained.

6. A material requirement planning method as claimed in claim 1, characterized in that: The initial gross demand for the substitute material is split out in the bill of materials, where the initial gross demand for the substitute material is the gross demand for the corresponding original demand material.

7. A material requirement planning method as claimed in claim 1, characterized in that: The materials are split according to the minimum of gross demand and available inventory, specifically: For the material with the smallest net demand, determine the minimum value of its gross demand and available inventory, and use the minimum value as the gross demand and available inventory of the material, so that the net demand of the material is zero; The remaining gross demand of the demand item corresponding to the material is used as the gross demand of the alternative material of the material. If the available inventory of the alternative material is greater than the remaining gross demand, the available inventory of the alternative material in the demand item is set to the remaining gross demand, and the remaining available inventory is transferred to other demand items of the alternative material. If the available inventory of the alternative material is less than the remaining gross demand and all alternative materials have been split, the net demand is calculated based on the remaining gross demand and the available inventory as the gross demand and net demand of the original demand material.

8. A system for material requirement planning, characterized in that: include: The BOM building module is used to build the BOM, which includes the gross material requirements, available inventory, and demand item information; At the same time, determine the substitution relationship and group number of each material; The net demand calculation module is used to obtain the gross demand and available inventory of each material required for each demand based on the bill of materials on the same demand day, and obtain the net demand of each material; A net demand update module is used to split the initial gross demand of the substitute material in the bill of materials in response to the substitution relationship of the material being incomplete substitution, and determine the net demand of the substitute material based on the available inventory of the substitute material; Select the material with the smallest net demand, split the material according to the minimum value of gross demand and available inventory, so that its net demand is zero; the remaining gross demand of the demand item corresponding to the material is supplemented by the alternative material of the material; update the bill of materials; Repeat this process until all substitute materials have been split; finally, the final net demand is generated according to the original demand materials.

9. A terminal device, comprising a processor and a memory, wherein the processor is used to implement instructions; and the memory is used to store multiple instructions, characterized in that: The instructions are suitable for being loaded by a processor and executing the material requirement planning method described in any one of claims 1-7.

10. A computer-readable storage medium storing a plurality of instructions, characterized in that: The instructions are suitable for being loaded by a processor of a terminal device and executing the material requirement planning method described in any one of claims 1-7.

Images