Material supply and demand matching method, system and storage medium

Abstract

The present application discloses a material supply and demand matching method, system and storage medium, including: traversing the material demand situation in the material supply and demand work order, performing the 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; performing the second stage material supply and demand matching level by level based on the low-order code level and the preliminary matching result, and obtaining the supply and demand matching result corresponding to each level; when the supply and demand matching result shows that there is excess supply material, removing the excess supply material from the material supply and demand work order, and obtaining 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, and obtaining the target supply and demand matching result. The solution provided by this embodiment can perform accurate inventory allocation and cancellation of excess work orders, thereby improving the accuracy of the overall supply and demand matching.

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 plans 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 is often determined based on the bill of materials. Furthermore, the LLC (Low Level Code) is used in MRP calculations to expand the data layer by layer from top to bottom. When encountering a group of alternative materials, supply and demand matching is achieved based on the current supply quantity of each material in the current alternative material group.

[0004] Patent publication number CN118411006A discloses a material requirements planning method, which includes a supply and demand adjustment step: The method obtains demand information and supply quantities for each demand site corresponding to each material level in the product BOM, sequentially from top to bottom. The method then adjusts the purchase plan by determining whether the short-supply material exists in the next material level.

[0005] However, in the solutions provided by related 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 substitution material group, and the supply and demand situation of each material in the lower layer is not considered. In complex substitution scenarios, it is often impossible to ensure 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 the combination of 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, the second-stage material supply and demand matching is performed layer by layer based on the low-order code level and the preliminary matching result 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 to determine the demand to be matched and the supply to be matched corresponding to the material of the i-th level; for the n-th demand to be matched, determining the required material for the n-th demand to be matched, and querying the candidate material supply corresponding to the required material from the supply to be matched, and different candidate material supplies correspond to different supply types; based on the priority of the supply type, determining the material supply that matches 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: when 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, and obtaining 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 demand for the material to be matched corresponding to the sub-demand material is an alternative material demand, the supply and demand matching is performed based on the demand for the material to be matched corresponding to the sub-demand material and the supply of the material 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 matched by the alternative material demand; matching the target material supply with the demand for the material 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-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 second material supply and demand work order, and the supply and demand matching result at the i+x-th level is determined based on the updated first material supply and demand work order, where x is a positive integer.

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

[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 mth material, determining at least one candidate low-order code level corresponding to the mth material; and determining the highest level among the candidate low-order code levels as the low-order code level corresponding to the mth 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: determining the candidate material supply corresponding to the first material demand in the material supply and demand work order based on the material supply and demand work order and the low-order code structure; and determining the first material supply that matches the first material demand based on the supply type priority of each of the candidate material supplies.

[0015] As a further improvement of the present application, when there is at least a first candidate material supply and a second candidate material supply with the same supply type priority, 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 the supply characteristics of the first supply material and the second supply material, and the supply characteristic is 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 runnable 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 embodiment of the present application, in a work order management scenario with multi-level BOM (Bill of Materials) alternative branches, flexible material management can be achieved 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, thereby achieving accurate supply and demand allocation while canceling excess work orders, avoiding the limitation of traditional MRP calculations where excess output is discovered but an alternative branch cannot be re-selected, 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 by 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 illustrating alternative branches 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 with reference to 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 those 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 variant thereof is intended to cover non-exclusive inclusion, so that a process, method, article, or apparatus that includes a list of elements includes not only those elements but also other elements not explicitly listed, or elements inherent to such process, method, article, or apparatus. In addition, the terms "first," "second," etc. are used for descriptive purposes only and should not 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 the material supply and demand work order, the multi-level BOM structure of the enterprise MRP can be combined to perform deep traversal and hierarchical traversal, wherein the deep traversal is to traverse all material requirements in the material supply and demand work order, and then perform the first stage of material supply and demand matching based on all material requirements and material supply conditions.

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

[0031] During the first phase of material supply and demand matching, the supply and demand matching system performs a preliminary comparison of the demand and supply for each material, initially determining the correspondence between each supply item and each demand item. For example, if the demand for chips is 1,000 and the inventory supply is 1,200, then during the first phase of material supply and demand matching, the inventory supply of 1,200 chips will be matched with the demand of 1,000 chips.

[0032] Step 102: Determine the low-level code level corresponding to each material in the material supply and demand work order.

[0033] The system determines the low-level code (LOC) for each material in the BOM (Bill of Materials). The LCO level indicates the material's depth within the product structure, providing a basis for subsequent level-by-level matching, ensuring that lower-level materials are matched before higher-level materials. For example, in a material supply and demand work order for automobile manufacturing, the engine might be a LCO level 1 material because it is assembled from multiple components (such as pistons and crankshafts), while the piston and crankshaft might be LCO level 2 materials.

[0034] 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.

[0035] By traversing the low-order code structure, the hierarchy of each material is determined and matched layer by layer in the second stage. In the second stage matching process, 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.

[0036] 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.

[0037] After the second phase of matching, the supply of some materials may exceed the demand. For example, at a certain level, the supply of Part A may exceed the actual demand. To optimize material management and avoid resource waste, these excess supplies need to be removed from the work order. The updated material supply and demand work order excludes this unnecessary supply information, making the work order more aligned with actual production needs.

[0038] During the second-stage matching process, after completing the material supply and demand matching at a certain level, if the material matching result at that level indicates that there is an oversupply of materials at that level, the material supply and demand matching at the next level will be stopped. The oversupply 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 material supply and demand matching at the first and second stages will be carried out again.

[0039] 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.

[0040] Using the updated work order, material supply and demand matching is repeated from the first stage. Since excess supply materials have been removed, the rematching is based on more accurate supply and demand information. After re-matching in the first and second stages, the target supply and demand matching result is more reasonable. This result can better guide production, ensure a balance between material supply and demand, improve production efficiency, and reduce inventory costs.

[0041] In summary, in the embodiment of the present application, in a multi-level BOM (Bill of Materials) alternative branch work order management scenario, flexible material management can be achieved 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, thereby achieving accurate supply and demand allocation while canceling the excess work order, avoiding the limitation of traditional MRP calculations in which excess output is discovered but an alternative branch cannot be re-selected, greatly reducing production waste, and effectively improving the efficiency and accuracy of the overall supply and demand matching.

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

[0043] 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.

[0044] Wherein, i is a positive integer.

[0045] In the second phase of supply and demand matching based on the low-level code structure, supply and demand matching starts with the first-level materials. After the first-level material matching is completed, material matching is performed layer by layer according to the low-level code hierarchy of the BOM expansion.

[0046] Within a hierarchy, there may be multiple materials, and different materials may correspond to demand items and multiple supply items. For example, within the first hierarchy, there is a demand item for Mobile Phone 1, a supply item for Mobile Phone 1 - Work Order Output, and a supply item for Mobile Phone 1 - Inventory Supply. During the second stage of material demand matching, the corresponding unmatched demand and supply items at each hierarchy level are first determined to prepare for subsequent matching.

[0047] 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.

[0048] Different candidate material supplies correspond to different supply types, and n is a positive integer.

[0049] The nth demand to be matched is any one of the demands to be matched corresponding to the i-th level material determined in step 201 above. For example, the nth demand to be matched is the fifth batch of 20 mobile phone units required for the production line. The required material corresponding to this demand is determined to be mobile phone units. Subsequently, candidate material supplies corresponding to mobile phone units are searched from the supply to be matched. Candidate material supplies refer to all possible supply options that can meet the demand for 20 mobile phone units, such as a portion of the 30 mobile phone units promised by Supplier A or a portion of the 25 mobile phone units already in inventory.

[0050] Step 203 : 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.

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

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

[0053] First, query the demand for materials at that level in the work order at level i and the available candidate material supply. If there is inventory supply, the inventory is used first to reduce unnecessary work order output; when the inventory cannot meet the demand, the work order output supply is considered.

[0054] In step 204 , when there is no candidate material supply corresponding to the demand material in the to-be-matched supplies corresponding to the materials in the i-th level, a sub-demand material corresponding to the demand material in the i+1-th level is determined based on the low-order code structure.

[0055] When the required material supply cannot be matched at the current level, the sub-demand material can be searched downward along the low-level code structure to achieve a deeper match. On the one hand, it can effectively deal with complex scenarios of wrong-level 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.

[0056] For example, if no candidate material supply that can meet the demand is found among the matching supplies at level i, for example, all supply items for mobile phone complete devices have been allocated, leaving no remaining supply to meet the new complete device demand, the system then searches downwards to level i+1 based on the low-level code structure. Assuming the complete mobile phone is assembled from sub-materials such as PCBA1 and PCBA2, which are at low-level code level 2, the sub-materials corresponding to the mobile phone demand, such as PCBA1, are identified from these sub-materials.

[0057] 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.

[0058] As an example, the material supply and demand subsystem queries the material supply and demand work order and finds the matching material demand and supply corresponding to PCBA1. The matching material demand indicates that 50 PCBA1s are needed on the production line to assemble the mobile phone. The matching material supply may be the existing supply of PCBA1s in inventory, for example, 80 PCBA1s are still in inventory.

[0059] 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 a supply and demand matching result of the i+1th level.

[0060] In one possible implementation, the material requirement to be matched corresponding to the sub-requirement material is a substitutable 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 also not in stock, 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 be replaced by different materials; 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.

[0061] 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.

[0062] 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 will be the target material supply.

[0063] 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 with the sub-demand material in the second supply and demand matching stage.

[0064] In the embodiment of the present application, this hierarchical matching method can further improve the flexibility and accuracy of supply and demand allocation. For multiple demand materials in the same level, the corresponding inventory supply can be used separately, and the work order output supply is only started 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, if there is no candidate material supply corresponding to the demand material in the supply to be matched corresponding to the materials at this level, 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.

[0065] In some implementations, the supply and demand matching results for some levels may indicate that there is no excess supply of materials at that level, and the process can then proceed directly to the second stage of the supply and demand matching process at the next level. However, if the supply and demand matching results for some levels indicate that there is no excess supply of materials at that level, these excess supplies need to be removed from the work order.

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

[0067] 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 material, and the supply and demand matching result of 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.

[0068] During the level-by-level supply and demand matching process, starting from level 1 and continuing through level i-1, there is no excess supply of materials, indicating that supply and demand are balanced or slightly less than demand at these levels. When matching reaches level i, excess supply is detected. For example, at level i, the supply of a certain material exceeds the demand. These excess materials are removed from the material supply and demand work order, optimizing material management and avoiding unnecessary inventory backlogs.

[0069] For example, if excess production of complete mobile phones or PCBA1s is found in the second or deeper round of calculations, the corresponding excess work orders and associated demands can be immediately removed, 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.

[0070] After removing the excess supply material, the 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 level i.

[0071] Subsequently, when the supply and demand matching result of 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.

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

[0073] After obtaining the first material supply and demand work order, the first stage of material supply and demand matching is re-performed based on the first material supply and demand work order, followed by the second stage of material supply and demand matching, layer by layer, until reaching the i+xth level. Since excess supply materials in the i-th level have already been removed, the supply and demand matching results from the first through i-th levels should all indicate that there are no excess supply materials. If excess supply materials are found in the supply and demand matching results for the i+xth level, the excess supply materials are again removed from the first material supply and demand work order, resulting in the second material supply and demand work order. This matching process is repeated until there are no excess supply materials.

[0074] The material supply and demand matching system performs material supply and demand matching 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.

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

[0076] Optionally, first, 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.

[0077] For illustration, please refer to Figure 4 , which shows a BOM expansion and low-order code diagram provided by an exemplary embodiment of the present application. Among them, the materials with LLC=1 include after-sales components, mobile phone 1, and mobile phone 2, and the materials with LLC=2 include complete device 1 and complete device 2. The materials with LLC=3 include board 1. For resistor 1, its corresponding candidate low-order code levels include LLC=3 and LLC=4. The highest level is taken, and 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.

[0078] 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.

[0079] 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.

[0080] In the present embodiment, this process is repeated repeatedly until there is no excess supply at any level, achieving a globally optimal match for complete machines, multi-level semi-finished products, and their substitutes. This significantly reduces waste caused by supply-demand imbalances and improves resource utilization. Furthermore, when inventory and work order output have been allocated according to the optimal plan, the satisfaction of all demands can be confirmed, resulting in the final target supply-demand matching result, ensuring overall optimization of production and procurement.

[0081] Because the supply items for the same material in a supply and demand work order may have different supply types, such as inventory and work order output, it is necessary to select the most appropriate supply item for the material demand during both the first-stage material supply and demand matching and the second-stage supply and demand matching.

[0082] During the first stage of material supply and demand matching, the candidate material supplies corresponding to the first material demand in the material supply and demand work order are first determined based on the material supply and demand work order and its low-level code structure. Subsequently, based on the supply type priority of each candidate material supply, the first material supply that matches the first material demand is determined.

[0083] Through the first stage of 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.

[0084] In some embodiments, the supply type priorities 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 the supply material b corresponding to material supply B, then material supply A can be selected first.

[0085] 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.

[0086] 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.

[0087] In this embodiment, by prioritizing high-priority supplies such as inventory, the complexity of subsequent replacement branches can be effectively reduced, and reliance on work order output can be reduced during the initial matching phase. Prioritizing matching with available inventory ensures that demand is met quickly, reduces subsequent cancellation and backtracking operations, and helps improve the stability and efficiency of global supply and demand allocation.

[0088] The following will describe the steps in the material supply and demand matching method provided in this application with reference to a specific embodiment.

[0089] 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.

[0090]

[0091] Table 1

[0092] Based on the above Figure 5 The structure shown and the supply and demand data provided in Table 1 can be used to perform supply and demand matching by referring to the following steps.

[0093] Step A: Traverse all material requirements in the supply and demand work order and perform the first stage material supply and demand matching.

[0094] a. Mobile phone 1-MDS-100 is matched with Mobile phone 1-Inventory-100 to meet the material requirements.

[0095] b. PCBA1-Work Order Requirement Line-100, generated by Mobile Phone 1-Work Order Output, is matched with PCBA1-Inventory-100 to obtain the Work Order Requirement Line.

[0096] c. Mobile Phone 2-MDS-100 is a replaceable requirement. When selecting a replacement branch, since PCBA1 is no longer available but PCBA2 still has output, PCBA2-Work Order Output-100 is used to match the requirement and meet the material demand.

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

[0098] In 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.

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

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

[0101] Mobile phone 2, total demand: MDS-100, total supply: 0, there is no supply to be consumed, so the BOM is expanded 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, PCBA2-work order output-100 with LLC=2 is determined to be matched.

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

[0103]

[0104] Table 2

[0105] Step D: After canceling some work orders, the first stage of supply and demand matching is repeated.

[0106] f. Mobile phone 1-MDS-100 is matched with Mobile phone 1-Inventory-100 to meet the demand.

[0107] g. For mobile phone unit 2-MDS-100, when selecting an alternative branch, since PCBA1 has 100 in stock and PCBA2 is a work order output, the branch PCBA1-Inventory-100 is selected for matching to meet the demand.

[0108] h. The work order output for PCBA2 generates work order demand for PCB2 and IC2. However, there is no supply to consume them, resulting in a procurement recommendation.

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

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

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

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

[0113] j. LLC = 2-tier supply and demand matching.

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

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

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

[0117]

[0118] Table 3

[0119] In step G, after canceling some work orders, the first stage of supply and demand matching is repeated.

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

[0121] For mobile phone unit 2-MDS-100, when selecting an alternative branch, PCBA1-Inventory-100 is selected because PCBA1 has 100 units in stock.

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

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

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

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

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

[0127] Step I, end.

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

[0129] 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.

[0130] Optionally, the processor 610 executes the steps of 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.

[0131] In addition, the processor can also execute various system functions and process data. Optionally, processor 610 can be implemented in hardware using at least one of the following: a digital signal processing (DSP), a field-programmable gate array (FPGA), or a programmable logic array (PLA). Processor 610 may integrate one or a combination of a central processing unit (CPU), a graphics processing unit (GPU), a neural network processing unit (NPU), and a modem. The CPU primarily handles the operating system, user interface, and applications; the GPU is responsible for rendering and drawing content displayed on the touchscreen display; the NPU is used to implement artificial intelligence (AI) functions; and the modem is used to handle wireless communications. It is understood that the modem can also be implemented independently of the processor 610 on a separate chip.

[0132] Memory 620 may include random access memory (RAM) or read-only memory (ROM). Optionally, memory 620 includes non-transitory computer-readable storage medium. Memory 620 may be used to store instructions, programs, code, code sets, or instruction sets. Memory 620 may include a program storage area and a data storage area. 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.), and instructions for implementing the various method embodiments described below. The data storage area may store data created based on system usage (such as audio data and a phone book).

[0133] 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, or the like, and is configured to communicate with an external device (server or other device) via a wired or wireless network; the display component 640 is configured to display a graphical user interface and / or receive user interaction.

[0134] 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 as described in any of the above embodiments.

[0135] 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, apparatus, or device. 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, apparatus, or device, or any suitable combination of the foregoing. More specific examples of machine-readable storage media may include an electrical connection based on one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), optical fibers, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, 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 a 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 layer by layer to obtain the supply and demand matching results corresponding to each layer, wherein, if the supply and demand matching results of the first to i-1 levels all indicate that there is no excess supply material, and the supply and demand matching result of 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; if the supply and demand matching result of the i+x-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 second material supply and demand work order, wherein the supply and demand matching result of the i+x-th level is determined based on the updated first material supply and demand work order, and i and x are positive integers; 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 performed again until the supply and demand matching results at all levels indicate that there is no excess supply material, and the supply and demand matching is completed 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 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, including: Based on the low-level code structure, query the material supply and demand work order to determine the matching demand and matching supply 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, determining a 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; Wherein, i and n are positive integers.

3. The method according to claim 2, characterized in that The method further comprises: If 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, determine the sub-demand material corresponding to the demand material at the i+1-th level based on the low-order code structure; Query the material supply and demand work order to determine the material demand and 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 that the material demand to be matched corresponding to the sub-demand material is a substitutable material demand, 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: Querying the preliminary matching results 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 1, wherein 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.

6. The method according to claim 1, characterized in that The material demand conditions in the material supply and demand work order are traversed, and a 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: Determine, based on the material supply and demand work order and the low-order code structure, a 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, a first material supply matching the first material demand is determined.

7. The method according to claim 6, characterized in that In the case that at least the first and second candidate material supplies have the same supply type priority, The method further comprises: Determining 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 a feature priority of 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.

8. 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 according to any one of claims 1 to 7.

9. 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 according to any one of claims 1 to 7.

Images