Material supply and demand matching method and system and storage medium

Abstract

The invention discloses a material supply and demand matching method and system and a storage medium, and the method comprises the steps: traversing a material demand condition in a material supply and demand work order, carrying out the first-stage material supply and demand matching based on the material supply condition in the material supply and demand work order, and obtaining a preliminary matching result; determining a low-order code level corresponding to each material in the material supply and demand work order; performing second-stage material supply and demand matching layer by layer based on the low-order code hierarchy and the preliminary matching result to obtain a supply and demand matching result corresponding to each hierarchy; under the condition that the supply and demand matching result shows that the excessive supply materials exist, the excessive supply materials are removed from the material supply and demand work order, and an updated material supply and demand work order is obtained; and based on the updated material supply and demand work order, carrying out first-stage material supply and demand matching and second-stage material supply and demand matching again to obtain a target supply and demand matching result. By adopting the scheme provided by the embodiment of the invention, accurate inventory distribution and excessive work order cancellation can be carried out, and the accuracy of overall supply and demand matching is improved.

Description

Technical Field

[0001] The present invention relates to the technical field of manufacturing production management, and in particular to a material supply and demand matching method, system and storage medium. Background Art

[0002] The MRP system determines the types and quantities of required materials by analyzing production orders, inventory levels, and bills of materials (BOMs), and generates procurement and production plans to ensure timely supply of materials and smooth production.

[0003] In related technologies, when calculating material demand and supply matching, the supply and demand of different materials are often determined based on the bill of materials, and LLC (Low Level Code) is used to expand layer by layer from top to bottom when performing MRP calculations. When encountering a substitutable material group, supply and demand matching is achieved based on the current supply quantity of each material in the current layer of the substitutable material group.

[0004] The patent with publication number CN118411006A discloses a material requirement planning method, which discloses the steps of supply and demand adjustment: obtaining the demand information of each demand site corresponding to the materials in each material level in the product BOM and the supply quantity of each demand site in order from top to bottom of the material level. And by judging whether there are materials in the next material level for the shortage material, the purchase plan is adjusted.

[0005] However, in the solutions provided by the relevant technologies, when using product BOM to adjust supply and demand and perform MRP calculations, supply and demand matching is only based on the current supply quantity of each material in the current layer of substitution material group, and the supply and demand situation of each material in the lower level is not considered. In complex substitution scenarios, it is often impossible to guarantee a good match between supply and demand, which will cause a lot of production waste. Summary of the invention

[0006] The purpose of the present invention is to provide a material supply and demand matching method, system and storage medium, which realizes dynamic management of complex substitution relationships and excess work order output through multiple rounds of iterative deep traversal and hierarchical traversal, fully utilizes existing inventory and cancels excess work order output in a timely manner, thereby minimizing production and procurement waste.

[0007] To achieve the above-mentioned purpose, on the one hand, the present application provides a material supply and demand matching method, which includes: traversing the material demand situation in the material supply and demand work order, performing a first-stage material supply and demand matching based on the material supply situation in the material supply and demand work order, and obtaining a preliminary matching result; determining the low-order code level corresponding to each material in the material supply and demand work order; based on the low-order code level and the preliminary matching result, performing a second-stage material supply and demand matching level by level, and obtaining a supply and demand matching result corresponding to each level; when the supply and demand matching result indicates that there is excess supply material, removing the excess supply material from the material supply and demand work order to obtain an updated material supply and demand work order; based on the updated material supply and demand work order, re-performing the first-stage material supply and demand matching and the second-stage material supply and demand matching to obtain a target supply and demand matching result.

[0008] As a further improvement of the present application, based on the low-order code level and the preliminary matching result, the second-stage material supply and demand matching is performed level by level to obtain the supply and demand matching results corresponding to each level, including: based on the low-order code structure, querying the material supply and demand work order, determining the demand to be matched and the supply to be matched corresponding to the i-th level material; for the n-th demand to be matched, determining the required material of the n-th demand to be matched, and querying the candidate material supply corresponding to the required material from the supply to be matched, different candidate material supplies correspond to different supply types; based on the priority of the supply type, determining the material supply matching the n-th demand to be matched from the candidate material supply, and the priority of the inventory supply type is higher than the priority of the work order output supply type; wherein i and n are positive integers.

[0009] As a further improvement of the present application, the method also includes: in the case that there is no candidate material supply corresponding to the demand material in the supply to be matched corresponding to the material of the i-th level, determining the sub-demand material corresponding to the demand material in the i+1-th level based on the low-order code structure; querying the material supply and demand work order to determine the material demand to be matched and the material supply to be matched corresponding to the sub-demand material; performing supply and demand matching based on the material demand to be matched and the material supply to be matched corresponding to the sub-demand material, to obtain the supply and demand matching result of the i+1-th level.

[0010] As a further improvement of the present application, in the case that the material demand to be matched corresponding to the sub-demand material is an alternative material demand, the supply and demand matching is performed based on the material demand to be matched corresponding to the sub-demand material and the material supply to be matched to obtain the supply and demand matching result of the i+1th level, including: querying the preliminary matching result to determine the target material supply that matches the alternative material demand; matching the target material supply with the material demand to be matched corresponding to the sub-demand material to obtain the supply and demand matching result of the i+1th level.

[0011] As a further improvement of the present application, when the supply and demand matching result indicates that there is excess supply material, the excess supply material is removed from the material supply and demand work order to obtain an updated material supply and demand work order, including: when the supply and demand matching results at the first level to the i-1 level all indicate that there is no excess supply material, and the supply and demand matching result at the i-th level indicates that there is excess supply material, the excess supply material is removed from the material supply and demand work order to obtain an updated first material supply and demand work order; when the supply and demand matching result at the i+x level indicates that there is excess supply material, the excess supply material is removed from the material supply and demand work order to obtain an updated second material supply and demand work order, and the supply and demand matching result at the i+x level is determined based on the updated first material supply and demand work order, and x is a positive integer.

[0012] As a further improvement of the present application, the method further includes: when the supply and demand matching results at all levels do not contain the excess supply material, completing the supply and demand matching to obtain the target supply and demand matching result.

[0013] As a further improvement of the present application, determining the low-order code level corresponding to each material in the material supply and demand work order includes: traversing the low-order code structure based on the m-th material, determining at least one candidate low-order code level corresponding to the m-th material; and determining the highest level among the candidate low-order code levels as the low-order code level corresponding to the m-th material.

[0014] As a further improvement of the present application, the material demand situation in the material supply and demand work order is traversed, and the first stage of material supply and demand matching is performed based on the material supply situation in the material supply and demand work order to obtain a preliminary matching result, including: based on the material supply and demand work order and the low-order code structure, determining the candidate material supply corresponding to the first material demand in the material supply and demand work order; based on the supply type priority of each of the candidate material supplies, determining the first material supply that matches the first material demand.

[0015] As a further improvement of the present application, in the case where there is at least a first candidate material supply and a second candidate material supply whose supply type priority is consistent, the method also includes: determining a first supply material corresponding to the first candidate material supply, and a second supply material corresponding to the second candidate material supply; determining the first material supply based on the feature priority of supply characteristics of the first supply material and the second supply material, the supply characteristic being at least one of material versatility, material price, supply time and supply quantity.

[0016] On the other hand, the present application provides a material supply and demand matching system, comprising a processor, a memory, and a computer program stored in the memory and executable on the processor, characterized in that the computer program is loaded and executed by the processor to implement the steps of the material supply and demand matching method as described in any of the above aspects.

[0017] On the other hand, the present application provides a computer-readable storage medium, which stores a computer program, characterized in that when the computer program is executed by a processor, it is used to implement the steps in the material supply and demand matching method provided in any of the above aspects.

[0018] Compared with the solutions provided by related technologies, the beneficial effects of the present application are as follows: In the embodiments of the present application, in the work order management scenario of multi-level BOM (Bill Of Materials) alternative branches, flexible material management can be performed through two-stage material supply and demand matching. Moreover, in the case where there is excess supply material in the material supply and demand work order, the excess supply material is removed from the work order, and the two-stage supply and demand matching is re-performed, so that the excess work order can be cancelled while achieving accurate supply and demand allocation, avoiding the limitation of finding excess output after traditional MRP calculation but being unable to reselect alternative branches, greatly reducing production waste, and effectively improving the efficiency and accuracy of overall supply and demand matching. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] Figure 1 A flow chart of a material supply and demand matching method provided in an exemplary embodiment of the present application is shown.

[0020] Figure 2 A flow chart of a second-stage material requirement matching process provided by an exemplary embodiment of the present application is shown.

[0021] Figure 3 A schematic diagram showing an alternative branch provided by an exemplary embodiment of the present application.

[0022] Figure 4 A schematic diagram of BOM expansion and low-order code provided by an exemplary embodiment of the present application is shown.

[0023] Figure 5 A schematic diagram of a low-order code structure provided by an exemplary embodiment of the present application is shown.

[0024] Figure 6 A schematic diagram of the architecture of a material supply and demand matching system provided by an exemplary embodiment of the present application is shown. DETAILED DESCRIPTION

[0025] The present invention will be described in detail below in conjunction with the specific embodiments shown in the accompanying drawings. However, these embodiments do not limit the present invention, and any structural, methodological, or functional changes made by a person skilled in the art based on these embodiments are all within the scope of protection of the present invention.

[0026] It should be noted that the term "comprises" or any other variation thereof is intended to cover non-exclusive inclusion, so that a process, method, article or device that includes a series of elements includes not only those elements, but also includes other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In addition, the terms "first", "second", etc. are used for descriptive purposes only and cannot be understood as indicating or implying relative importance.

[0027] Please refer to Figure 1 , which shows a flow chart of a material supply and demand matching method provided by an exemplary embodiment of the present application, the method includes the following steps.

[0028] Step 101, traverse the material demand conditions in the material supply and demand work order, perform the first stage material supply and demand matching based on the material supply conditions in the material supply and demand work order, and obtain a preliminary matching result.

[0029] In one possible implementation, when traversing material supply and demand work orders, deep traversal and hierarchical traversal can be performed in combination with the multi-level BOM structure of the enterprise MRP, wherein deep traversal is to traverse all material requirements in the material supply and demand work order, and then the first stage of material supply and demand matching is performed based on all material requirements and material supply conditions.

[0030] The material supply and demand work order will include information such as the name, specification, quantity, demand time, production time, material supply type, etc. of each material.

[0031] In the first stage of material supply and demand matching, the supply and demand matching system will make a preliminary comparison between the demand and supply of each material, and preliminarily determine the correspondence between each supply item and each demand item. For example, if the demand for chips is 1,000 pieces, and the inventory supply is 1,200 pieces, then in the first stage of material supply and demand matching, the inventory supply item of 1,200 chips will match the demand item of 1,000 chips. Step 102, determine the low-level code level corresponding to each material in the material supply and demand work order.

[0032] The system determines the low-level code level of each material in the BOM (Bill of Materials). The low-level code level indicates the depth of the material in the product structure, thus providing a basis for subsequent level-by-level matching to ensure that low-level materials are matched first, and then high-level materials. For example, in a material supply and demand work order for automobile manufacturing, the engine may be a material with a low-level code level of 1 because it is assembled from multiple parts (such as pistons, crankshafts, etc.), while the piston and crankshaft may be materials with a low-level code level of 2.

[0033] Step 103, based on the low-order code level and the preliminary matching results, the second stage material supply and demand matching is performed level by level to obtain the supply and demand matching results corresponding to each level.

[0034] The level of each material is determined by traversing the low-order code structure and matching is carried out level by level in the second stage. During the matching process of the second stage, if there are alternative branches, it is necessary to refer to the preliminary matching results obtained by the material matching in the first stage to determine the corresponding supply and demand matching results at each level.

[0035] Step 104: When the supply and demand matching result indicates that there is excess supply material, the excess supply material is removed from the material supply and demand work order to obtain an updated material supply and demand work order.

[0036] After the second stage of matching, the supply of some materials may exceed the demand. For example, at a certain level, the supply of component A exceeds the actual demand. In order to optimize material management and avoid resource waste, these excess supply materials need to be removed from the work order. The updated material supply and demand work order excludes these unnecessary supply information, making the work order more in line with actual production needs.

[0037] During the second-stage matching process, after completing the material supply and demand matching of a certain level, if the material matching result of this level indicates that there is an oversupply of materials at this level, the material supply and demand matching of the next level will be stopped, and the excess supply materials at this level will be removed from the material supply and demand work order first, and then the material supply and demand matching situation will be restored, and then the first and second stage material supply and demand matching will be carried out again.

[0038] Step 105: Based on the updated material supply and demand work order, re-perform the first-stage material supply and demand matching and the second-stage material supply and demand matching to obtain the target supply and demand matching result.

[0039] Use the updated work order to start material supply and demand matching again from the first stage. Since the excess supply materials have been removed, the re-matching will be based on more accurate supply and demand information. After the re-matching of the first and second stages, the target supply and demand matching results will be more reasonable. This result can better guide production, ensure the balance between material supply and demand, improve production efficiency, and reduce inventory costs.

[0040] In summary, in the embodiment of the present application, in the work order management scenario of the multi-level BOM (Bill Of Materials) alternative branch, flexible material management can be performed through two-stage material supply and demand matching. Moreover, in the case where there is excess supply material in the material supply and demand work order, the excess supply material is removed from the work order, and the two-stage supply and demand matching is performed again, so that the excess work order can be cancelled while achieving accurate supply and demand allocation, avoiding the limitation of finding excess output after traditional MRP calculation but being unable to reselect alternative branches, greatly reducing production waste, and effectively improving the efficiency and accuracy of overall supply and demand matching.

[0041] Please refer to Figure 2 , which shows a flow chart of the second stage material requirement matching process provided by an exemplary embodiment of the present application, and the process is shown in the following steps.

[0042] Step 201, based on the low-level code structure, query the material supply and demand work order to determine the demand to be matched and the supply to be matched corresponding to the i-th level material.

[0043] Wherein, i is a positive integer.

[0044] In the case of the second-stage supply and demand matching based on the low-order code structure, the supply and demand matching starts from the first-level materials. After the first-level material matching is completed, the material matching is carried out layer by layer in the order of the low-order code levels of the BOM expansion.

[0045] In one level, there may be multiple materials, and different materials may correspond to demand items and multiple supply items. For example, in the first level, there is a demand item for mobile phone 1, and a supply item for mobile phone 1-work order output and a supply item for mobile phone 1-inventory supply. When performing the second-stage material demand matching, first determine the corresponding demand and supply to be matched at each level in preparation for subsequent matching.

[0046] Step 202 , for the nth demand to be matched, determine the required material of the nth demand to be matched, and query candidate material supplies corresponding to the required material from the supplies to be matched.

[0047] Among them, different candidate material supplies correspond to different supply types, and n is a positive integer.

[0048] The nth demand to be matched is any one of the demands to be matched corresponding to the i-th level material determined in the above step 201. For example, the nth demand to be matched is the fifth batch of mobile phone complete machines required on the production line, with a quantity of 20. It is determined that the required material corresponding to this demand is the mobile phone complete machine. Subsequently, the candidate material supply corresponding to the mobile phone complete machine is searched from the supply to be matched. The candidate material supply refers to all the supply options that may meet the demand for these 20 mobile phone complete machines, such as a part of the 30 mobile phone complete machines promised to be supplied by supplier A, or a part of the 25 mobile phone complete machines already in stock.

[0049] Step 203: Based on the priority of the supply type, determine the material supply that matches the nth demand to be matched from the candidate material supplies.

[0050] Among them, the priority of inventory supply type is higher than that of work order output supply type.

[0051] Different supply types may have different priorities. For example, inventory type supply has the highest priority, followed by work order output supply, and finally the supply plan promised by the supplier. The material supply and demand matching system selects the most suitable supply from the candidate material supplies to meet the nth matching demand based on these priorities.

[0052] First, query the demand for materials at this level and the available candidate material supply in the work order at the i-th level. If there is inventory supply, the inventory is used first to reduce unnecessary work order output; when the inventory cannot be met, the work order output supply is considered.

[0053] Step 204, when there is no candidate material supply corresponding to the demand material in the to-be-matched supply corresponding to the material in the i-th level, determine the sub-demand material corresponding to the demand material in the i+1-th level based on the low-order code structure.

[0054] When the required material supply cannot be matched at the current level, the sub-demand material can be searched downward along the low-order code structure to achieve a deeper match. On the one hand, it can effectively deal with complex scenarios of wrong-order substitution or cross-level substitution. On the other hand, at the sub-demand material level, it can still be accurately matched in combination with the alternative branch records recorded in the preliminary matching results, thereby avoiding the problem of demand not being met or being eliminated by mistake.

[0055] Indicatively, if no candidate material supply that can meet the demand material is found in the supply to be matched at the i-th level. For example, all supply items of mobile phone complete machines have been allocated, and there is no remaining supply to meet the new complete machine demand. Then search down to the i+1th level according to the low-order code structure. Assume that the mobile phone complete machine is assembled from sub-materials such as PCBA1 and PCBA2, and these sub-materials are at the low-order code level 2. From these sub-materials, determine the sub-demand materials corresponding to the mobile phone complete machine demand, such as PCBA1.

[0056] Step 205, query the material supply and demand work order to determine the to-be-matched material demand and to-be-matched material supply corresponding to the sub-demand material.

[0057] Indicatively, the material supply and demand subsystem queries the material supply and demand work order and finds the unmatched material demand and unmatched material supply corresponding to PCBA1. The unmatched material demand is that 50 PCBA1 are needed on the production line to assemble the mobile phone. The unmatched material supply may be the supply of PCBA1 in the inventory, such as 80 PCBA1 in the inventory.

[0058] Step 206 , performing supply and demand matching based on the to-be-matched material demand and the to-be-matched material supply corresponding to the sub-demand material, and obtaining the supply and demand matching result of the i+1th level.

[0059] In a possible implementation, the material requirement to be matched corresponding to the sub-requirement material is a replaceable material requirement. Figure 3 , which shows a schematic diagram of substitution branches provided by an illustrative embodiment of the present application, including combined substitution, ordinary substitution, staggered substitution and incomplete substitution. Combined substitution is a many-to-many substitution method; ordinary substitution of raw materials means that there may be multiple substitution relationships. For example, when material A is not in stock, it is replaced by material B first. When material B is not in stock either, it can be replaced by material C; staggered substitution means that the substitution relationship may occur in more than one layer, and substitution can occur in multiple layers; incomplete substitution means that the same material A in different BOMs can use different materials for replacement; for example, material A in product Y can be replaced by B or C, but material A in product X can only be replaced by B.

[0060] In this case, the material supply and demand matching system first queries the preliminary matching results to determine the target material supply that matches the alternative material demand.

[0061] If in the preliminary matching results, the matching result corresponding to the u-th material to be matched corresponding to the sub-demand material is the u-th material supply, then when selecting the alternative branch, select the u-th material supply and the u-th material demand for supply and demand matching, and the u-th material supply is the target material supply.

[0062] Subsequently, the target material supply is matched with the material demand to be matched corresponding to the sub-demand material to obtain the supply and demand matching result of the i+1th level. That is, after determining the target material supply, the uth material supply is still selected to match the sub-demand material in the second supply and demand matching stage.

[0063] In the embodiment of the present application, through this level-by-level matching method, the flexibility and accuracy of supply and demand allocation can be further improved. For multiple demand materials in the same level, the corresponding inventory supply can be used respectively, and the work order output supply is started only when the inventory is insufficient, thereby complementing the first-stage material supply and demand matching process, effectively reducing redundant production in complex substitution scenarios. Moreover, in the supply to be matched corresponding to the materials at this level, if there is no candidate material supply corresponding to the demand material, by searching and matching at a deeper level, the optional range of supply and demand is further expanded, which helps to improve the flexibility and accuracy of the overall supply and demand matching, and reduce stagnation or repeated work order output caused by insufficient supply at the upper level.

[0064] In some implementations, there may be some levels where the supply and demand matching results indicate that there is no excess supply of materials in the materials at that level, and the second stage supply and demand matching process of the next level may be directly entered. If there are some levels where the supply and demand matching results indicate that there is no excess supply of materials in the materials at that level, then it is necessary to remove these excess supply materials from the work order.

[0065] Optionally, the possible judgment logic of the material supply and demand matching system can refer to the following steps.

[0066] First, when the supply and demand matching results of the first level to the i-1 level all indicate that there is no excess supply of materials, and the supply and demand matching results of the i-th level indicate that there is excess supply of materials, the excess supply of materials is removed from the material supply and demand work order to obtain an updated first material supply and demand work order.

[0067] In the process of level-by-level supply and demand matching, there is no excess supply material from the first level to the i-1th level, indicating that in these levels, supply and demand are balanced, or supply is slightly less than demand. When matching to the i-th level, it is found that there is excess supply material, for example, at the i-th level, the supply of a certain material exceeds the demand. Then remove these excess supply materials from the material supply and demand work order to optimize material management and avoid unnecessary inventory backlogs.

[0068] For example, if excess production of mobile phone complete units or PCBA1 is found in the second or deeper round of calculations, the corresponding excess work orders and associated demands can be removed immediately, so that the released inventory can be re-matched with other demands in subsequent iterations, preventing the subsequent use of low-priority or inappropriate work order output supply.

[0069] After removing the excess supply materials, an updated first material supply and demand work order is obtained. This work order reflects the latest supply and demand situation after removing the excess supply at the i-th level.

[0070] Subsequently, when the supply and demand matching result at the i+xth level indicates that there is excess supply material, the excess supply material is removed from the material supply and demand work order to obtain an updated second material supply and demand work order.

[0071] The supply and demand matching result of the i+xth level is determined based on the updated first material supply and demand work order, and x is a positive integer.

[0072] After obtaining the first material supply and demand work order, the first stage material supply and demand matching is re-performed based on the first material supply and demand work order, as well as the second stage material supply and demand matching layer by layer, until the i+xth level is reached. Since the excess supply materials in the i-th level have been removed, the supply and demand matching results from the first level to the i-th level should all indicate that there is no excess supply material. If excess supply materials are found in the supply and demand matching results of the i+x-th level, the excess supply materials are removed from the first material supply and demand work order again to obtain the second material supply and demand work order. The matching is repeated according to this process until there is no excess supply material.

[0073] The material supply and demand matching system matches material supply and demand at each level, and cancels excess supply materials, until there is no excess supply material at all levels. That is, when there is no excess supply material in the supply and demand matching results at all levels, the supply and demand matching is completed and the target supply and demand matching result is obtained.

[0074] Before carrying out the second stage of supply and demand matching level by level, it is necessary to first determine the low-level code levels corresponding to different materials.

[0075] Optionally, firstly, based on the mth material, the low-order code structure is traversed to determine at least one candidate low-order code level corresponding to the mth material, and the highest level among the candidate low-order code levels is determined as the low-order code level corresponding to the mth material.

[0076] For illustration, please refer to Figure 4 , which shows a BOM expansion and low-order code schematic diagram provided by an illustrative embodiment of the present application. Among them, the materials of LLC=1 include after-sales components, mobile phone 1, and mobile phone 2, and the materials of LLC=2 include complete machine 1 and complete machine 2. The materials of LLC=3 include board 1. For resistor 1, its corresponding candidate low-order code levels include LLC=3 and LLC=4, then take the highest level, the low-order code level of resistor 1 is 4, similarly, the low-order code level of resistor 2 is 4, and the low-order code level of board 1 is 3.

[0077] Optionally, the affiliation of each material in different BOM levels can be collected by traversing the low-level code structure, and the highest level can be selected from the candidate levels to ensure that the level of the material can be correctly located during subsequent supply and demand matching, thereby avoiding multiple definitions or level conflicts.

[0078] This process can provide an accurate BOM hierarchical basis for multiple rounds of iterative material supply and demand matching, further ensuring data consistency and matching effectiveness during deep traversal and level-by-level traversal.

[0079] In the embodiment of the present application, the process is repeated many times until there is no excess supply at each level, so as to achieve the global optimal matching of the whole machine, multi-level semi-finished products and their substitute materials, significantly reduce the waste caused by the imbalance between supply and demand and improve resource utilization. In addition, when the inventory and work order output have been allocated according to the optimal solution, the satisfaction of all demands can be confirmed, and the final target supply and demand matching result can be obtained, ensuring the overall optimization of production and procurement.

[0080] Since there may be different supply types in the supply items of the same material in the supply and demand work order, for example, the supply type may include inventory and work order output, etc., it is necessary to select a more appropriate supply item for the material demand during the first stage material supply and demand matching and the second stage supply and demand matching.

[0081] In the process of matching the supply and demand of the first stage, first, based on the material supply and demand work order and the low-order code structure, the candidate material supply corresponding to the first material demand in the material supply and demand work order is determined. Then, based on the supply type priority of each candidate material supply, the first material supply matching the first material demand is determined.

[0082] Through the first-stage material supply and demand matching, available inventory or work order output supply can be quickly identified to meet the first material demand. When there are multiple optional supplies, inventory supply can be matched first based on priority rules, thereby reducing unnecessary work order initiation.

[0083] In some embodiments, the supply type priority of the first candidate material supply and the second candidate material supply may be consistent, for example, material supply A, material supply B, and material supply C, where material supply A and material supply B are both inventory supply types, and material supply A and material supply B are alternative branches of material demand 1. In this case, the material characteristics of the supply materials corresponding to material supply A and material supply B can be considered. For example, when other conditions are the same, the price of supply material a corresponding to material supply A is lower than that of supply material b corresponding to material supply B, then material supply A can be selected first.

[0084] First, a first supply material corresponding to the first candidate material supply and a second supply material corresponding to the second candidate material supply are determined.

[0085] Subsequently, the supply of the first material is determined based on the feature priority of the supply features of the first supply material and the second supply material, where the supply feature is at least one of material versatility, material price, supply time, and supply quantity.

[0086] In the embodiment of the present application, by giving priority to the use of high-priority supplies such as inventory, the complexity of subsequent replacement branches can be effectively compressed, and the dependence on work order output can be reduced in the initial matching stage. Prioritizing matching with available inventory can not only ensure that demand is met quickly, but also reduce subsequent cancellation and backtracking operations, which helps to improve the stability and efficiency of global supply and demand allocation.

[0087] The steps in the material supply and demand matching method provided in this application will be described below in conjunction with a specific embodiment.

[0088] Please refer to Figure 5 , which shows a low-order code structure provided by an exemplary embodiment of the present application. Please refer to Table 1, which shows an example of a supply and demand work order provided by an exemplary embodiment of the present application.

[0089]

[0090] Table 1 Based on the above Figure 5 The structure shown and the supply and demand data provided in Table 1, the process of matching supply and demand can refer to the following steps.

[0091] Step A, traverse all material requirements in the supply and demand work order, and perform the first stage material supply and demand matching.

[0092] a. Mobile phone complete machine 1-MDS-100 is matched with mobile phone complete machine 1-inventory-100 to meet the material requirements.

[0093] b. PCBA1-work order demand line-100 brought by mobile phone complete machine 1-work order output is matched with PCBA1-inventory-100, the work order demand line.

[0094] c. Mobile phone complete machine 2-MDS-100 is a replaceable demand. When selecting the replacement branch, since PCBA1 is out of supply and PCBA2 is still available, PCBA2-work order output-100 is used to match and meet the material demand.

[0095] d. The work order demand lines for PCB2 and IC2 generated by the work order output of PCBA2 have no supply to consume, so a purchase suggestion is generated.

[0096] Step B: After determining the LLC corresponding to each required material, the second stage of supply and demand matching is carried out step by step.

[0097] e. LLC=1 level to match supply and demand.

[0098] Mobile phone 1, total demand: MDS-100, total supply: inventory-100 and work order output 100, then inventory-100 is used for matching to meet the material demand.

[0099] Mobile phone 2, total demand: MDS-100, total supply: 0, there is no supply to consume, so expand the BOM downward, there are two branches to choose from, PCBA1 and PCBA2, according to the alternative branch selection record of the first stage material supply and demand matching in step A above, determine to select LLC=2 PCBA2-work order output-100 for matching.

[0100] In step C, at the current level LLC=1, it can be determined that the output of mobile phone 1 work order is -100 in excess, so the work order output and the PCBA1 work order demand line brought by the work order output are cancelled, and the updated material supply and demand list is shown in Table 2 below.

[0101]

[0102] Table 2 Step D: After canceling some work orders, re-perform the first stage of supply and demand matching.

[0103] f. Mobile phone complete machine 1-MDS-100, use mobile phone complete machine 1-inventory-100 for matching to meet the demand.

[0104] g. Mobile phone complete machine 2-MDS-100, when selecting the replacement branch, since PCBA1 has 100 in stock and PCBA2 is the output of the work order, the branch PCBA1-inventory-100 will be selected for matching to meet the demand.

[0105] h. The work order demand for PCB2 and IC2 caused by the work order output of PCBA2 has no supply to consume, so a purchase suggestion is generated.

[0106] Step E: perform supply and demand matching based on the low-order code level.

[0107] i. LLC=1 level to match supply and demand.

[0108] Mobile phone 1, total demand: MDS-100, total supply: inventory-100, then use inventory-100 to meet the demand.

[0109] Mobile phone 2, total demand: MDS-100, total supply: 0, no supply to be consumed, then expand the BOM downward, select the alternative branch record of the first stage material supply and demand matching in step D, and select PCBA1-Related Demand-100 with LLC=2.

[0110] j. LLC=2 levels to match supply and demand.

[0111] PCBA1, total demand: related demand - 100, total supply: inventory - 100, then use inventory - 100 to meet the demand.

[0112] PCBA2, total demand: 0, total supply: work order output - 100, it can be determined that the work order output is in excess.

[0113] In step F, at the current LLC=2 level, it is determined that there is an oversupply of PCBA2-work order output, and PCBA2-work order output, as well as PCB1-work order demand line-100 and IC2-work order demand line-100 brought by PCBA2-work order output are cancelled from the material supply and demand work order. The updated material supply and demand list is shown in Table 3 below.

[0114]

[0115] Table 3 Step G: After canceling some work orders, re-perform the first phase of supply and demand matching.

[0116] k. Mobile phone complete machine 1-MDS-100, use mobile phone complete machine 1-inventory-100 to meet the demand.

[0117] l. Mobile phone 2-MDS-100, when selecting the replacement branch, since PCBA1 has 100 in stock, the branch PCBA1-Stock-100 will be selected.

[0118] Step H, performing supply and demand matching based on the low-order code level.

[0119] m. LLC=1 level to match supply and demand.

[0120] Mobile phone 1, total demand: MDS-100, total supply: inventory-100, then use inventory-100 to meet the demand.

[0121] Mobile phone 2, total demand: MDS-100, total supply: 0, no supply to be consumed, then expand the BOM downward, select the record according to the alternative branch of the first stage material supply and demand matching in step G, and get PCBA1-related demand-100 with LLC=2.

[0122] n. PCBA1, total demand: related demand - 100, total supply: inventory - 100, then use inventory - 100 to meet the demand.

[0123] Step I, end.

[0124] This enables material supply and demand matching and the cancellation of excess material in supply and demand work orders.

[0125] Please refer to Figure 6 , which shows a schematic diagram of the architecture of a material supply and demand matching system provided by an exemplary embodiment of the present application, and may include one or more of the following components: a processor 610 and a memory 620.

[0126] Optionally, the processor 610 executes the steps in the material supply and demand matching method provided in any of the above embodiments by running or executing instructions, programs, code sets or instruction sets stored in the memory 620, and calling data stored in the memory 620.

[0127] In addition, the processor can also perform various functions of the system and process data. Optionally, the processor 610 can be implemented in at least one hardware form of digital signal processing (DSP), field-programmable gate array (FPGA), and programmable logic array (PLA). The processor 610 can integrate one or a combination of a central processing unit (CPU), a graphics processing unit (GPU), a neural network processor (NPU), and a modem. Among them, the CPU mainly processes the operating system, user interface, and application programs; the GPU is responsible for rendering and drawing the content to be displayed on the touch display; the NPU is used to implement artificial intelligence (AI) functions; and the modem is used to process wireless communications. It can be understood that the above-mentioned modem may not be integrated into the processor 610, but may be implemented separately through a chip.

[0128] The memory 620 may include a random access memory (RAM) or a read-only memory (ROM). Optionally, the memory 620 includes a non-transitory computer-readable storage medium. The memory 620 may be used to store instructions, programs, codes, code sets, or instruction sets. The memory 620 may include a program storage area and a data storage area, wherein the program storage area may store instructions for implementing an operating system, instructions for at least one function (such as a touch function, a sound playback function, an image playback function, etc.), instructions for implementing the following various method embodiments, etc.; the data storage area may store data created according to the use of the system (such as audio data, a phone book), etc.

[0129] The system in the embodiment of the present application further includes a communication component 630 and a display component 640. The communication component 630 may be a Bluetooth component, a WiFi component, an NFC (Near Field Communication) component, etc., for communicating with an external device (server or other device) via a wired or wireless network; the display component 640 is used to display a graphical user interface and / or receive user interaction operations.

[0130] An embodiment of the present application also provides a non-transitory computer-readable storage medium storing computer instructions, wherein the storage medium stores at least one program code, and the program code is loaded and executed by a processor to implement the material supply and demand matching method of any of the above embodiments.

[0131] In the context of the present disclosure, a computer-readable medium may be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, device, or apparatus. A computer-readable medium may be a computer-readable signal medium or a computer-readable storage medium. A computer-readable storage medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or device, or any suitable combination of the foregoing. More specific examples of machine-readable storage media may include electrical connections based on one or more lines, portable computer disks, hard disks, random access memories (RAM), read-only memories (ROM), erasable programmable read-only memories (EPROM or flash memory), optical fibers, portable compact disk read-only memories (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing.

Claims

1. A material supply and demand matching method, characterized in that: The method comprises: Traversing the material demand conditions in the material supply and demand work order, performing the first-stage material supply and demand matching based on the material supply conditions in the material supply and demand work order, and obtaining a preliminary matching result; Determine the low-level code level corresponding to each material in the material supply and demand work order; Based on the low-order code level and the preliminary matching result, the second-stage material supply and demand matching is performed level by level to obtain the supply and demand matching results corresponding to each level; If the supply and demand matching result indicates that there is excess supply material, removing the excess supply material from the material supply and demand work order to obtain an updated material supply and demand work order; Based on the updated material supply and demand work order, the first-stage material supply and demand matching and the second-stage material supply and demand matching are re-performed to obtain the target supply and demand matching result.

2. The method according to claim 1, characterized in that Based on the low-order code level and the preliminary matching result, the second-stage material supply and demand matching is performed level by level to obtain the supply and demand matching results corresponding to each level, including: Based on the low-order code structure, query the material supply and demand work order to determine the demand to be matched and the supply to be matched corresponding to the i-th level material; For the nth demand to be matched, determine the required material of the nth demand to be matched, and query the candidate material supply corresponding to the required material from the supplies to be matched, where different candidate material supplies correspond to different supply types; Based on the priority of the supply type, determine the material supply that matches the nth to-be-matched demand from the candidate material supplies, wherein the priority of the inventory supply type is higher than the priority of the work order output supply type; Among them, i and n are positive integers.

3. The method according to claim 2, characterized in that The method further comprises: In the case that there is no candidate material supply corresponding to the demand material in the to-be-matched supply corresponding to the material at the i-th level, determining the sub-demand material corresponding to the demand material at the i+1th level based on the low-order code structure; Query the material supply and demand work order to determine the material demand to be matched and the material supply to be matched corresponding to the sub-demand material; Supply and demand matching is performed based on the to-be-matched material demand corresponding to the sub-demand material and the to-be-matched material supply to obtain the supply and demand matching result of the i+1th level.

4. The method according to claim 3, characterized in that In the case where the to-be-matched material requirement corresponding to the sub-requirement material is a replaceable material requirement, The performing supply and demand matching based on the to-be-matched material demand corresponding to the sub-demand material and the to-be-matched material supply to obtain the supply and demand matching result of the i+1th level includes: Query the preliminary matching result to determine the target material supply that matches the alternative material demand; The target material supply is matched with the to-be-matched material demand corresponding to the sub-demand material to obtain the supply-demand matching result of the i+1th level.

5. The method according to claim 2, characterized in that: When the supply and demand matching result indicates that there is excess supply material, removing the excess supply material from the material supply and demand work order to obtain an updated material supply and demand work order includes: When the supply and demand matching results of the first level to the i-1 level all indicate that the excess supply material does not exist, and the supply and demand matching result of the i-th level indicates that the excess supply material exists, the excess supply material is removed from the material supply and demand work order to obtain an updated first material supply and demand work order; When the supply and demand matching result at the i+xth level indicates that there is excess supply material, the excess supply material is removed from the material supply and demand work order to obtain an updated second material supply and demand work order, wherein the supply and demand matching result at the i+xth level is determined based on the updated first material supply and demand work order, and x is a positive integer.

6. The method according to claim 5, characterized in that The method further comprises: When the supply and demand matching results at all levels indicate that there is no excess supply material, the supply and demand matching is completed to obtain the target supply and demand matching result.

7. The method according to claim 1, characterized in that The step of determining the low-level code level corresponding to each material in the material supply and demand work order includes: Traversing the low-order code structure based on the m-th material, determining at least one candidate low-order code level corresponding to the m-th material; The highest level among the candidate low-order code levels is determined as the low-order code level corresponding to the m-th material.

8. The method according to claim 1, characterized in that The material demand conditions in the material supply and demand work order are traversed, and the first-stage material supply and demand matching is performed based on the material supply conditions in the material supply and demand work order to obtain a preliminary matching result, including: Based on the material supply and demand work order and the low-order code structure, determine the candidate material supply corresponding to the first material demand in the material supply and demand work order; Based on the supply type priorities of the various material supplies to be selected, a first material supply matching the first material demand is determined.

9. The method according to claim 8, characterized in that In the case where at least the first material supply to be selected and the second material supply to be selected have the same supply type priority, The method further comprises: Determine a first supply material corresponding to the first candidate material supply, and a second supply material corresponding to the second candidate material supply; The supply of the first material is determined based on the feature priority of supply features of the first supply material and the second supply material, and the supply feature is at least one of material versatility, material price, supply time and supply quantity.

10. A material supply and demand matching system, comprising a processor, a memory, and a computer program stored in the memory and executable on the processor, characterized in that: The computer program is loaded and executed by the processor to implement the steps of the material supply and demand matching method as claimed in any one of claims 1 to 9.

11. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, it is used to implement the steps of the material supply and demand matching method as claimed in any one of claims 1 to 9.

Images