A supply planning data processing method and system
By creating a unique requirement table and an alternative requirement table, analyzing the product BOM-level components layer by layer, giving priority to the unique requirements and calculating the alternative material requirements through an optimization algorithm, the problem of unbalanced resource allocation in traditional solutions is solved and the supply chain is improved Stability and resource utilization efficiency.
Patent Information
- Application Number
- CN202411168509.7
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-23
- Publication Date
- 2024-11-15
- Estimated Expiration
- 2044-08-23
AI Technical Summary
Traditional supply planning solutions fail to intelligently optimize the impact of material components and other products or materials in the supply chain system, resulting in uneven resource allocation, increasing supply risks, and failing to achieve optimal resource utilization efficiency.
A supply plan data processing method is proposed. By creating a unique demand table and a substitute demand table, analyzing the product BOM hierarchical components layer by layer, giving priority to the unique demand, ensuring that they are supplied and then allocating resources to the substitute material demand, and using optimization algorithm to calculate The amount of alternative materials demand to maximize the utilization of resources.
It improves the stability and reliability of the supply chain, ensures the smooth progress of key business processes, reduces resource waste and production bottlenecks, and maximizes resource utilization efficiency.
Smart Images

Figure CN118674246B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the technical field of computer software data processing, and in particular to a supply plan data processing method and system. Background Art
[0002] In the supply planning data processing and management of the supply chain system, how material demand occupies supply and its corresponding allocation method will have different impacts on the production, operation and order delivery of the enterprise. In some enterprises, the production of core businesses or key products may rely on certain specific key materials. Since the exclusive demand is irreplaceable, its supply allocation may lead to production or operation interruption. Traditional supply planning schemes usually only analyze the material component attributes from the perspective of a single product or material, and then calculate and allocate resources according to the custom priority or time sorting of the demand. It does not perform overall system and intelligent optimization processing, and does not consider the impact of the current material component and the supply of other products or materials. In particular, when calculating and allocating the current material, other exclusive materials are not considered, resulting in the inability to achieve the best resource allocation results, thereby generating certain supply risks. To a certain extent, after a component is occupied based on the priority level, it will increase the supply risk of the exclusive materials that should belong to other products.
[0003] Therefore, how to intelligently and efficiently improve the stability and reliability of the supply chain, ensure the smooth progress of key business processes and the most effective use of limited resources, reduce resource waste and production bottlenecks, and maximize resource utilization efficiency has become a technical problem that the supply chain management system urgently needs to solve. Summary of the invention
[0004] Based on this, this application proposes a supply planning data processing solution to address the above problems, aiming to intelligently and efficiently improve the stability and reliability of the supply chain, ensure the smooth progress of key business processes, and maximize resource utilization efficiency.
[0005] On one hand, the present application provides a supply plan data processing method, the method comprising:
[0006] S10, creating a unique demand table and an alternative demand table;
[0007] S11, triggering product supply and demand matching according to a preset trigger event, taking all the gap products to be produced as the top layer, falling into a unique demand table, and taking all the gap products to be produced as the target objects;
[0008] S12, extracting all target components of the next layer of the BOM level of all the target objects;
[0009] S13, analyzing each target component one by one, and placing them into a corresponding exclusive requirement table or a replacement requirement table;
[0010] S14, generating configuration information of each first demand material at the target component level of the exclusive demand table;
[0011] S15. After the first demands of all the unique demand tables of the current entire level are supplied, supply the demand for alternative materials. According to the configuration information of the first demand materials in the unique demand table, update the information of the alternative second demand materials of each corresponding alternative group, and generate the configuration information of the second demand materials in each alternative group of the target component level of the alternative demand table;
[0012] S16, matching the supply and demand of the first demand material and the second demand material, extracting the missing material as the target object, and returning to S12 to execute in a loop until all levels are executed.
[0013] Furthermore, the method further comprises:
[0014] Determine whether the current target component to be parsed contains an alternative group;
[0015] If not, the target component is determined to be a unique demand component, and the relevant demand information and material level of the current target component are placed in the unique demand table;
[0016] If included, it is determined as an alternative demand component, and the relevant demand information and material level of the materials in the current target component replacement group are placed in the alternative demand table.
[0017] Furthermore, the method also includes: determining whether the target component is a virtual component; if so, parsing the next-level component of the current target component and occupying the supply of the next-level component.
[0018] Preferably, the step of generating the configuration information of each first demand material at the target component level of the exclusive demand table includes:
[0019] Sort the first demand materials in the exclusive demand table based on the planned date;
[0020] Parallel calculation is performed on the components of the first demand materials on the same planned date to determine the required configuration quantity and supply plan of each first demand material.
[0021] Preferably, the step of generating the configuration information of the second required material in each alternative group of the target component level of the alternative demand table includes:
[0022] Sort the second demand materials in the alternative demand table based on the planned date;
[0023] According to the first demand material configuration information of the exclusive demand table, update the alternative second demand material information of each corresponding alternative group;
[0024] Perform parallel calculations on the second demand materials in each alternative group on the same planning date to determine the required allocation quantity and supply plan for the second demand materials in each alternative group.
[0025] Preferably, the method further comprises:
[0026] Calculate the initial proportion p of each second demand material in the current substitution group ij ;
[0027] Construct the objective function:
[0028] ,
[0029] Among them, x ij is the allocation quantity of the second required material of the jth substitution group, c ij is the usage cost of the second required material of the i-th replacement group, n j is the number of the second required materials of the jth substitution group, λ and η are the corresponding weight coefficients respectively;
[0030] Set up constraints: , N is a natural number, s ij is the initial quantity of the second required material in the jth substitution group, u ij is the unit usage of the i-th second demand material in the j-th substitution group, ε ij is the corresponding loss rate;
[0031] Solve and optimize the objective function so that the value of the objective function is minimized: F=min(Z);
[0032] According to the optimization results, the required configuration quantity x of each second required material in each alternative group is determined ij .
[0033] Furthermore, the method also includes: matching supply and demand of the first demand material and the second demand material to determine the current level of gap demand material components; and generating supply plan information corresponding to the gap demand material components according to preset quota rules.
[0034] A second aspect of the present application provides a supply plan data processing system, the system comprising:
[0035] A demand table creation module is used to create a unique demand table and an alternative demand table;
[0036] The supply and demand matching module is used to match the supply and demand of products, taking all the gap products to be produced as the top layer, falling into the unique demand table, and taking all the gap products to be produced as the target objects;
[0037] The component parsing module is used to extract all the next-level target components of the BOM level of the target object of the gap, parse them one by one, and put them into the corresponding unique requirement table or alternative requirement table;
[0038] The demand configuration module is used to generate the configuration information of each first demand material at the target component level of the exclusive demand table; after the first demand materials of all the missing products in the exclusive demand table of the entire level are supplied, the supply of the demand in the replacement demand table is carried out, and according to the configuration information of the first demand materials in the exclusive demand table, the replacement second demand material information of each corresponding replacement group is updated, and the configuration information of the second demand material in each replacement group at the target component level of the replacement demand table is generated;
[0039] The component processing module is used to match the supply and demand of the first demand material and the second demand material, extract the missing material as the target object, and call the component parsing module to perform parsing processing in a loop until all levels are completed.
[0040] The third aspect of the present application provides a computer-readable storage medium storing a computer program, which, when executed by a processor, enables the processor to perform the steps of any one of the above methods.
[0041] A fourth aspect of the present application provides a computer terminal device, comprising a memory and a processor, wherein the memory stores a computer program, and when the computer program is executed by the processor, the processor executes the steps of any one of the above methods.
[0042] The supply plan data processing scheme provided in the present application matches supply and demand and analyzes the target components of the product BOM level layer by layer. After analyzing the components, it does not directly calculate and supply the current components, but puts all the first demands of the exclusive demands into the exclusive demand table, and all the second demands with alternative groups into the intermediate table of alternative material demands. The demands of each component are stored in separate tables, and the exclusive demands and alternative material demands are divided into independent demand pools for supply calculation. And by giving priority to the exclusive demands to occupy the supply, it breaks the limitation of the time dimension of the supply occupation of the alternative material demands. After the exclusive demands of all components of all the gap products in the entire level are occupied by the supply, the supply occupation of the alternative material demands is carried out, ensuring that the exclusive demands are given priority in the supply of resources before the remaining supply resources are allocated to the alternative material demands, and the number of alternative material demands is determined by the optimization algorithm to maximize resource utilization. The above-mentioned scheme of the present application covers the traditional scheme that emphasizes the balance and flexibility of resource allocation through a configurable supply allocation mechanism. The exclusive demand can compete with the demand for alternative materials for supply resources in parallel. It also extends the traditional allocation scheme to a scheme in which the exclusive demand takes precedence over the demand for alternative materials to occupy the supply, thereby maximizing the efficiency of the use of key resources and avoiding waste of resources. It greatly improves the stability and reliability of the supply chain, ensures the smooth progress of key business processes, and effectively reduces waste of resources and production bottlenecks.
[0043] Furthermore, the present application also provides an optimization scheme to optimize the calculation and configuration of the required materials within the alternative group. The optimization scheme performs balance and target optimization based on multiple dimensions such as material balance and diversity and the cost of required materials in current components, so that the supply of required materials within the alternative group can meet the order requirements while maintaining the balance of material usage, thereby effectively improving the efficiency, resilience and adaptability of the supply chain. BRIEF DESCRIPTION OF THE DRAWINGS
[0044] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.
[0045] in:
[0046] Figure 1 A flowchart of a supply plan data processing method in one embodiment;
[0047] Figure 2 is a structural block diagram of a supply plan data processing system in one embodiment;
[0048] Figure 3 FIG. 4 is a structural block diagram of a computer device in one embodiment. DETAILED DESCRIPTION
[0049] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.
[0050] The terms "include", "comprising" and "having" and any variations thereof in the specification and claims of the present application and the above-mentioned drawings are intended to cover non-exclusive inclusions. For example, a process, method, system, product or device comprising a series of steps or units is not limited to the listed steps or units, but may optionally include steps or units that are not listed, or may optionally include other steps or units that are inherent to these processes, methods, products or devices. In the claims, specification and drawings of the present application, relational terms such as "first" and "second" are merely used to distinguish one entity / operation / object from another entity / operation / object, and do not necessarily require or imply any such actual relationship or order between these entities / operations / objects.
[0051] Reference to "embodiments" herein means that a particular feature, structure, or characteristic described in conjunction with the embodiments may be included in at least one embodiment of the present application. The occurrence of the phrase at various locations in the specification does not necessarily refer to the same embodiment, nor is it an independent or alternative embodiment that is mutually exclusive with other embodiments. It is explicitly and implicitly understood by those skilled in the art that the embodiments described herein may be combined with other embodiments.
[0052] It should be noted that the steps shown in the flowcharts of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions, and that, although a logical order is shown in the flowcharts, in some cases, the steps shown or described can be executed in an order different from that shown here.
[0053] In one embodiment, if Figure 1 The flowchart of a supply plan data processing method of the present application is shown, and the method comprises the following steps:
[0054] Step S10: Create a unique demand table and a replacement demand table.
[0055] Specifically, in one embodiment, when executing the solution of the present application, the system creates an independent exclusive demand table and an alternative demand table, which are used to store information related to material components of exclusive demand and information related to material components containing alternative demand, respectively. In the present application, an exclusive demand material component is defined as a demand material that is irreplaceable and can only be satisfied by specific materials, equipment or suppliers, and cannot be replaced by other resources. An alternative material demand material component is defined as a demand material that is substitutable / universal and can be satisfied by a variety of general materials, equipment or suppliers, and is not limited to a specific resource.
[0056] Preferably, the created unique requirement table and alternative requirement table are preset to include but are not limited to one or more fields:
[0057] 1. Level: record the level of the object;
[0058] 2. ID: records the ID of the object. Each object includes a unique identification ID.
[0059] 3. Name: record the name identification information of the object;
[0060] 4. Demand information: record the name and / or ID of the required material, the required date, the required quantity, the required warehouse, etc. This field can be further divided into multiple subfields according to the required material information, among which the required quantity can be determined and updated according to the configured demand.
[0061] 5. Parent node ID: records the ID of the parent node of the previous level associated with the current object. This field is NULL for the top-level object.
[0062] Among them, the replacement demand table is pre-set to include one or more of the above fields, and can also include the following fields: Material information in the replacement group: record the materials in the current replacement group.
[0063] Step S11, triggering product supply and demand matching according to a preset trigger event, with all the gap products as the top layer, falling into the exclusive demand table, and taking all the gap products as the target objects.
[0064] Specifically, in one embodiment, the present application scheme sets a trigger event through an automated system, and automatically triggers the execution of product supply and demand matching when a preset specific trigger event occurs. The preset trigger event may include, but is not limited to: a preset time period, inventory levels below a threshold, a sudden increase in market demand, and other trigger events.
[0065] When a preset event is triggered, product demand and supply data are obtained, where demand data includes customer order demand, market forecast demand, etc., and supply data includes inventory, work orders, purchase orders, etc. Market forecast demand includes: collecting historical sales data, market trends, seasonal factors, economic indicators and other data that may affect demand; preprocessing the data: processing missing values and outliers, and converting data formats, such as date and time conversion; and then predicting market demand through pre-trained forecasting model types (such as time series models, regression models, machine learning models, etc.).
[0066] After determining the demand data and supply data, supply and demand are matched according to the demand data and supply data to determine which products have sufficient supply and which products have gaps. For the gap products, the gap target products for self-production are determined according to the preset quota rules, and the corresponding supply plan orders for the gap products for self-production are generated. Among them, the preset quota rules preset the supply method (production or procurement) of the material gap and the distribution of the supply ratio.
[0067] Preferably, in one embodiment of the present application, the produced gap products are taken as the top-level (such as X-layer) target objects, fall into the unique demand table, and relevant data are extracted and filled into the corresponding fields of the unique demand table, including ID, name, demand date, demand quantity and other information.
[0068] Step S12: extract the next layer component of the BOM level of the target object as the target component to be parsed.
[0069] Specifically, according to the BOM level corresponding to the current target object, the next layer (such as X-1 layer) is expanded in the BOM structure through the preset API, database query or other data integration tools, and all the next layer components are extracted, and the next layer components are used one by one as the current target components to be parsed, and then parsed later.
[0070] Step S13, analyzing each target component one by one, and placing it into the corresponding exclusive requirement table or replacement requirement table.
[0071] Preferably, in one embodiment of the present application, parsing the target component data includes:
[0072] S131, determining whether the current target component to be parsed contains an alternative group;
[0073] Specifically, it is possible to determine whether the target component contains an alternative group by extracting the alternative group identification information pre-set in the target component BOM, and / or to determine whether it is a specific material or whether the current inventory can be replaced by other resources based on the attribute information of the target component.
[0074] Furthermore, in one embodiment of the present application, materials that can be substituted for each other are pre-determined among the required materials corresponding to each product, and these materials are formed into corresponding substitution groups and named and identified. When establishing the BOM-level component information of each product, the corresponding components are identified and determined by the corresponding substitution group name or identifier.
[0075] S132. If not included, the target component is determined to be a unique demand component, and the relevant demand information and material level of the current target component are placed in the unique demand table.
[0076] Specifically, if the current target component does not contain an alternative group, the current target component is determined to be a single-use demand component, and the relevant demand information corresponding to the current target component is further determined based on the target object data associated with the current target component, such as the name and / or ID of the demand material, the demand date, the warehouse, etc., and then the demand quantity is updated based on the configuration demand. At the same time, the BOM level of the current target component is used as the material level, and the demand information related to the demand material and the corresponding level fall into the corresponding field of the corresponding single-use demand table.
[0077] S133. If included, it is determined as a replacement demand component, and the relevant demand information and material level of the materials in the current target component replacement group are placed in the replacement demand table.
[0078] If the current target component contains an alternative group, the current target component is determined to be an alternative demand component, and the relevant demand information of the materials in the alternative group corresponding to the current target component is further determined based on the target object data associated with the current target component, such as the name and / or ID of the required material, the required date, the warehouse, etc., and then the required quantity is determined and updated based on the configuration demand. At the same time, the BOM level of the current target component is used as the material level, and the relevant demand information of the required material and the corresponding level fall into the corresponding fields of the corresponding exclusive demand table.
[0079] Furthermore, the method further comprises:
[0080] Determine whether the target component is a virtual component. If so, parse the next-level component of the current target component and occupy the supply of the next-level component.
[0081] Specifically, virtual parts refer to materials or components that do not actually exist or occupy physical space during the manufacturing process, but are treated as special items in the enterprise's information management system (such as the ERP system) to better manage the company's production and inventory. In the ERP system, virtual parts can be used to represent a group, a series, a property, or a type of specification of materials, or as a transitional part in the product structure. For example, in the design process of some products, there may be some transitional components or assembly steps that do not exist separately in the actual manufacturing process. In this case, virtual parts can be used for design management. For example, in the manufacture of electrical products, virtual parts can be used to represent a group of electrical components with the same specifications.
[0082] Virtual parts are widely used in supply chain management and optimization. In supply chain management, by tracking the quantity, cost, and location of virtual parts, we can better understand the operation of the supply chain and adjust procurement, production, and sales plans in a timely manner. When a product contains multiple materials with exactly the same specifications, virtual parts can be used to represent this group of materials, thereby simplifying inventory management, reducing data redundancy, and improving the efficiency of bill of materials (BOM) maintenance.
[0083] In one embodiment of the present application, after the demand of the current level (such as the X-1 level) is matched and the supply is completed, the corresponding planned order will be generated only when there is a demand gap in the previous level (such as the X-1 level), and the next level (such as the X-2 level) will be expanded based on the planned order, and after the components of the current level (such as the X-1 level) are calculated, the components of the next level (such as the X-2 level) will be calculated. Since the target components of the current level are virtual parts, no specific supply plan is set for the virtual parts, and no planned orders will be generated. Therefore, an example scheme of the present application directly expands the X-2 level and occupies it directly when the current level is calculated to be a virtual part, that is, the components of the next level replace the virtual parts of the current level for calculation, and the current level (X-1 level) is used as the level of the material of the next level of the virtual parts.
[0084] S14. Generate configuration information of each first demand material at the target component level of the exclusive demand table.
[0085] Specifically, the present application solution configures the first demand material information in the exclusive demand table according to the level, first extracts all the first demand materials of the level where the target component in the exclusive demand table is located, and then performs the corresponding demand configuration. If the current target component is the X-1 level, first extract all the demand material components of the X-1 level in the exclusive demand table and then perform subsequent calculation and configuration.
[0086] Preferably, in one embodiment of the present application, the calculation configuration exclusively uses the first demand material component at the level where the target component of the demand table is located, including:
[0087] S141. Sort the components of the first demand material in the exclusive demand table based on the planned date.
[0088] Specifically, in order to determine the supply plan and / or production plan of the first demand material, the present application scheme sorts the first demand material components in the exclusive demand table in ascending order based on the planned date, and then configures the material information according to the sorting result. The planned date can be comprehensively determined based on the order date or actual production needs and the priority or urgency of the product / component, such as the earlier the order date, the higher the priority, and the more urgent the product / component, the earlier the corresponding planned date.
[0089] S142. Perform parallel calculation on the first demand material component of the same planned date to determine the required configuration quantity and supply plan of the first demand material component.
[0090] Specifically, according to the sorting results, multi-threaded parallel execution calculations are performed on the component-related requirements of the same organization or different organizations (producers) on the same planned date, and the calculation results are obtained. The demand quantity of each first demand material component is met, and the calculation results include and determine the supply plan of the first demand material component based on the calculation results. The supply plan includes matching the supply and demand of the first demand material, determining the corresponding supply plan, and the supply plan includes the existing supply warehouse, quantity, supply method (production or procurement) of the shortfall part and the corresponding supply ratio, and generates the corresponding supply plan result table and the current supply and demand occupancy allocation result table of the first demand material. Among them, the demand quantity of the first demand material component satisfies:
[0091] ,
[0092] Among them, y k Nf is the allocation quantity of the kth first demand material, k The required quantity of the parent-level component corresponding to the first required material, u k The unit usage corresponding to the production of the parent component for the first demand material, ε k is the corresponding loss rate.
[0093] Step S15: Generate configuration information of the second required material in each alternative group at the target component level of the alternative demand table.
[0094] Specifically, after the exclusive demand for all different gap products in the entire current level is occupied and supplied, the supply of alternative material demand is occupied, and the remaining supply resources are allocated to the alternative material demand after ensuring the exclusive demand supply resources. After configuring all the first demand material information in the current level exclusive demand table, the second demand material configuration information of the level where the target component in the alternative demand table is located is calculated in sequence. Similarly, the present application scheme also first extracts all the second demand materials of the level where the target component is located in the alternative demand table, and then performs the corresponding demand calculation and configuration.
[0095] Preferably, in one embodiment, generating the configuration information of the second required material in each alternative group of the target component level of the alternative demand table includes:
[0096] S151. Sort the second demand materials in the alternative demand table based on the planned date.
[0097] Specifically, similar to the first demand material configuration process, the present application scheme sorts the second demand material components in the alternative demand table in ascending order based on the planned date, and then configures the material information according to the sorting result.
[0098] Since the second required material includes an alternative group, the component materials in the alternative group can be replaced with each other, and the calculating and configuring the second required material includes: calculating the required configuration information based on the second required material of the corresponding alternative group.
[0099] S152. Update the alternative second demand material information of each corresponding alternative group according to the first demand material configuration information of the exclusive demand table.
[0100] Specifically, since the material objects in the alternative group corresponding to the second demand material may have been partially or fully occupied when the first demand material was configured, the corresponding quantity of some second demand materials may be reduced or exhausted. Therefore, when calculating and configuring the second demand material, the present application scheme first updates the information of the alternative materials in each alternative group of the second demand material according to the configuration information of the first demand material to ensure the accuracy of subsequent algorithm calculation optimization.
[0101] S153. Perform parallel calculation on the second demand materials in each alternative group on the same planned date to determine the required allocation quantity and supply plan of the second demand materials in each alternative group.
[0102] Specifically, according to the sorting results, multi-threaded parallel execution calculations are performed on the component-related requirements of the same organization or different organizations on the same planned date to obtain calculation results, and the material requirement configuration results and supply plan results in the second demand material substitution group are determined according to the calculation results. The supply plan includes matching the supply and demand of the materials in the second demand material substitution group, determining the corresponding supply plan, and the supply plan includes the existing supply warehouse, quantity, supply method (production or procurement) of the gap part and the corresponding supply ratio, and generating the corresponding supply plan result table and the supply and demand occupancy allocation result table of each demand material.
[0103] Preferably, in one embodiment, the present application determines the configuration of the second required material in each material substitution group, including:
[0104] S1531. Calculate the initial proportion p of each second demand material in the substitution group i:
[0105] ,
[0106] Among them, s ij is the initial quantity of the second required material in the jth substitution group, n j The second required material quantity in the jth substitution group.
[0107] S1532. Construct objective function based on multi-dimensional factors of cost and material diversity:
[0108] ,
[0109] Among them, x ij is the required allocation quantity of the second required material of the jth replacement group, c ij is the usage cost of the second required material of the i-th replacement group, n j is the number of the jth replacement group and the second required material, λ and η are the corresponding weight coefficients respectively, and the weight system can be adjusted and optimized as needed.
[0110] S1533. Set constraints: , N is a natural number, s ij is the initial quantity of the second required material in the jth substitution group, u ij is the unit usage of the i-th second demand material in the j-th substitution group, ε ij is the corresponding loss rate.
[0111] S1534. Solve and optimize the objective function so that the value of the objective function is minimized: F=min(Z).
[0112] S1535. According to the optimization result, determine the required configuration quantity x of each second demand material of each substitution group of the current second demand material ij .
[0113] Specifically, the objective function can be solved by using linear programming, integer programming or heuristic algorithms to solve the optimization model, and the objective function value can be minimized: F = min (Z). For example, a linear programming solver (such as CPLEX, Gurobi or open source GLPK, PuLP, etc.) is used to solve this objective function model. According to the result of minimizing the value of the objective function, the solver will return the optimal x i Value, that is, the quantity of each material in the alternative group that the current second demand material should use.
[0114] and / or,
[0115] In another preferred embodiment, the present application calculates the configuration information of the second demand material in each replacement group and further includes: recalculating the configuration ratio of each second demand material in the replacement group and determining the configuration amount of each second demand material:
[0116] ,
[0117] Where, nf is the required allocation quantity of the second required material of the jth substitution group, j is the number of parent-level components required for the j-th replacement group, w ij is the corresponding configuration ratio, u ij is the corresponding unit dosage, ε ij The recalculated configuration occupancy ratio can be determined according to the material priority and / or inventory status. In one embodiment, the configuration ratio of each material in the alternative group is recalculated based on the material priority. For example, the alternative group of the current second demand material contains material A and material B that can be replaced. The current demand quantity of the second demand material is N, the priority of A is greater than the priority of B, the inventory of A is N1, and the inventory of B is N2. Then the configuration A occupancy ratio is N1 / N, and the configuration B occupancy ratio is 1-N1 / N.
[0118] The above-mentioned scheme of the present application optimizes the calculation and configuration of the demand materials within the replacement group through the optimization scheme, and performs balance and target optimization based on multiple dimensions such as material balance and diversity and the cost of demand materials in current components, to ensure that the diversity of inventory materials is maximized and the cost is minimized. Maximizing material diversity is defined as optimizing by minimizing the difference between the actual allocation ratio and the original ratio, so that the supply of demand materials within the replacement group meets the order requirements while maintaining the balance of material use, and can effectively take into account the exclusive demand supply of different components at the next level, thereby effectively improving the efficiency, resilience and adaptability of the supply chain.
[0119] Step S16, match the supply and demand of the first demand material and the second demand material, extract the missing demand material components as the target objects, and return to step S12 to execute in a loop until all levels are completed.
[0120] Specifically, the supply and demand of each first and second demand material is matched, the gap demand material components of the current level are determined, and the supply plan order information of the corresponding gap components is generated according to the preset quota rules, such as the use of self-production and / or procurement to supply the gap, and the proportion of the corresponding supply method. Further, the gap demand components planned to be generated in the supply plan are extracted as the target object, and steps S12-S16 are executed repeatedly until all levels of supply and demand matching are completed (X=0 level completes supply and demand matching) and the supply plan calculation is completed. Finally, all supply plans and material configuration results are generated.
[0121] The above scheme of the present application breaks the limitation of the time dimension of the occupation of the supply of substitute material demand by giving priority to the occupation of supply by exclusive demand. After all exclusive demands of the entire level are occupied by supply, the supply of substitute material demand is occupied. It ensures that the exclusive demand is given priority in supply resources before the remaining supply resources are allocated to the substitute material demand, and the number of substitute material demands is determined by calculation through optimization algorithm to maximize resource utilization. The above scheme of the present application covers the traditional scheme that emphasizes the balance and flexibility of resource allocation through a configurable supply allocation mechanism. Exclusive demand can compete with substitute material demand for supply resources in parallel, and extends the scheme that exclusive demand takes priority over substitute material demand in occupying supply on the basis of the traditional allocation scheme, maximizing the utilization efficiency of key resources and avoiding waste of resources. It greatly improves the stability and reliability of the supply chain, ensures the smooth progress of key business processes, and effectively reduces waste of resources and production bottlenecks.
[0122] In one embodiment, Figure 2 The figure shows a structural block diagram of a supply plan data processing system provided by the present application, the system comprising:
[0123] A demand table creation module is used to create a unique demand table and an alternative demand table;
[0124] The supply and demand matching module is used to match the supply and demand of products, taking all the gap products to be produced as the top layer, falling into the unique demand table, and taking all the gap products to be produced as the target objects;
[0125] The component analysis module is used to extract all target components of the next layer of the BOM level of all the target objects with gaps to be produced, analyze them one by one, and determine the demand information of the target components, which fall into the corresponding exclusive demand table or alternative demand table.
[0126] The demand configuration module is used to generate the configuration information of each first demand material at the target component level of the exclusive demand table; after the first demand materials of all the missing products in the exclusive demand table of the entire level are supplied, the supply of the demand in the replacement demand table is carried out, and according to the configuration information of the first demand materials in the exclusive demand table, the replacement second demand material information of each corresponding replacement group is updated, and the configuration information of the second demand material in each replacement group at the target component level of the replacement demand table is generated;
[0127] The component processing module is used to match the supply and demand of the first demand material and the second demand material, extract the missing material as the target object, and call the component parsing module to perform parsing processing in a loop until all levels are completed.
[0128] In one embodiment, the present application further provides a computer-readable storage medium storing a computer program, wherein when the computer program is executed by a processor, the processor performs the following steps:
[0129] S10, creating a unique demand table and an alternative demand table;
[0130] S11, triggering product supply and demand matching according to a preset trigger event, taking all the gap products to be produced as the top layer, falling into a unique demand table, and taking all the gap products to be produced as the target objects;
[0131] S12, extracting all target components of the next layer of the BOM level of all the target objects;
[0132] S13, analyzing each target component one by one, and placing them into a corresponding exclusive requirement table or a replacement requirement table;
[0133] S14, generating configuration information of each first demand material at the target component level of the exclusive demand table;
[0134] S15. After the first demand materials of all the missing products in the current level-specific demand table are supplied, the demand in the replacement demand table is supplied. According to the configuration information of the first demand materials in the unique demand table, the replacement second demand material information of each corresponding replacement group is updated, and the configuration information of the second demand materials in each replacement group of the target component level of the replacement demand table is generated;
[0135] S16, matching the supply and demand of the first demand material and the second demand material, extracting the missing material as the target object, and returning to S12 to execute in a loop until all levels are executed.
[0136] In one embodiment, Figure 3 As shown, the present application also provides a computer device, including a memory and a processor, wherein the memory stores a computer program, and when the computer program is executed by the processor, the processor performs the following steps:
[0137] S10, creating a unique demand table and an alternative demand table;
[0138] S11, triggering product supply and demand matching according to a preset trigger event, taking all the gap products to be produced as the top layer, falling into a unique demand table, and taking all the gap products to be produced as the target objects;
[0139] S12, extracting all target components of the next layer of the BOM level of all the target objects;
[0140] S13, analyzing each target component one by one, and placing them into a corresponding exclusive requirement table or a replacement requirement table;
[0141] S14, generating configuration information of each first demand material at the target component level of the exclusive demand table;
[0142] S15. After the first demand materials of all the missing products in the current level-specific demand table are supplied, the demand in the replacement demand table is supplied. According to the configuration information of the first demand materials in the unique demand table, the replacement second demand material information of each corresponding replacement group is updated, and the configuration information of the second demand materials in each replacement group of the target component level of the replacement demand table is generated;
[0143] S16, matching the supply and demand of the first demand material and the second demand material, extracting the missing material as the target object, and returning to S12 to execute in a loop until all levels are executed.
[0144] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the program can be stored in a non-volatile computer-readable storage medium. When the program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to memory, storage, database or other media used in the embodiments provided in this application can include non-volatile and / or volatile memory. Non-volatile memory may include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM) or flash memory. Volatile memory may include random access memory (RAM) or external cache memory. As an illustration and not limitation, RAM is available in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
[0145] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.
[0146] The above-mentioned embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the present application. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the present application shall be subject to the attached claims.
Claims
1. A supply planning data processing method, characterized in that: The method comprises: S10, creating a unique demand table and an alternative demand table; S11, triggering product supply and demand matching according to a preset trigger event, taking all the gap products to be produced as the top layer, falling into a unique demand table, and taking all the gap products to be produced as the target objects; S12, extracting all target components of the next layer of the BOM level of all the target objects; S13, analyzing each target component one by one, and placing them into a corresponding exclusive requirement table or a replacement requirement table; S14, generating configuration information of each first demand material at the target component level of the exclusive demand table; S15. After the first demand materials of all the missing products in the current level-specific demand table are supplied, the demand in the replacement demand table is supplied. According to the configuration information of the first demand materials in the unique demand table, the replacement second demand material information of each corresponding replacement group is updated, and the configuration information of the second demand materials in each replacement group of the target component level of the replacement demand table is generated; S16, matching the supply and demand of the first demand material and the second demand material, extracting the missing material as the target object, and returning to S12 to execute in a loop until all levels are executed; The step of generating the configuration information of the second required material in each alternative group of the target component level of the alternative demand table includes: Sort the second demand materials in the alternative demand table based on the planned date; Perform parallel calculations on the second demand materials in each alternative group on the same planning date to determine the required allocation quantity and supply plan for the second demand materials in each alternative group.
2. The method according to claim 1, characterized in that The method further comprises: Determine whether the current target component to be parsed contains an alternative group; If not, the target component is determined to be a unique demand component, and the relevant demand information and material level of the current target component are placed in the unique demand table; If included, it is determined as an alternative demand component, and the relevant demand information and material level of the materials in the current target component replacement group are placed in the alternative demand table.
3. The method according to claim 2, characterized in that The method further comprises: Determine whether the target component is a virtual component; If so, resolve the next level component of the current target component and occupy the supply of the next level component.
4. The method according to claim 1, characterized in that: The configuration information of each first demand material at the target component level of the unique demand table is generated, including: Sort the first demand materials in the exclusive demand table based on the planned date; Parallel calculation is performed on the components of the first demand materials on the same planned date to determine the required configuration quantity and supply plan of each first demand material.
5. The method according to claim 1, characterized in that The method further comprises: Calculate the initial proportion p of each second demand material in the current substitution group ij ; Construct the objective function: , Among them, x ij is the allocation quantity of the second required material of the jth substitution group, c ij is the usage cost of the second required material of the i-th replacement group, n j is the number of the second required materials of the jth substitution group, λ and η are the corresponding weight coefficients respectively; Set up constraints: , N is a natural number, s ij is the initial quantity of the second required material in the jth substitution group, nf j is the required number of parent-level components of the j-th replacement group, u ij is the unit usage of the i-th second demand material in the j-th substitution group, ε ij is the corresponding loss rate; Solve and optimize the objective function so that the value of the objective function is minimized: F=min(Z); According to the optimization results, the required configuration quantity x of each second required material in each alternative group is determined ij ; and / or, According to the allocation ratio of each second demand material in the replacement group, determine the allocation quantity of each corresponding second demand material: , Among them, x ij is the required allocation quantity of the second required material of the j-th substitution group, nf j is the number of parent-level components required for the j-th replacement group, w ij is the corresponding configuration ratio, u ij is the unit usage of the i-th second demand material in the j-th substitution group, ε ij is the corresponding loss rate.
6. The method according to any one of claims 1 to 5, characterized in that: The method further comprises: Match the supply and demand of the first demand material and the second demand material at the current level to determine the material components of the current level of shortfall demand; Generate supply plan information for corresponding material components with gap requirements based on preset quota rules.
7. A supply planning data processing system, characterized in that: The system comprises: A demand table creation module is used to create a unique demand table and an alternative demand table; The supply and demand matching module is used to match the supply and demand of products, taking all the gap products to be produced as the top layer, falling into the unique demand table, and taking all the gap products to be produced as the target objects; The component parsing module is used to extract all target components of the next layer of the BOM level of all target objects that need to produce gaps, parse them one by one, and determine the demand information of the target components, and put them into the corresponding exclusive demand table or alternative demand table; The demand configuration module is used to generate the configuration information of each first demand material at the target component level of the exclusive demand table; after the first demand materials of all the missing products in the exclusive demand table of the entire level are supplied, the supply of the demand in the replacement demand table is carried out, and according to the configuration information of the first demand materials in the exclusive demand table, the replacement second demand material information of each corresponding replacement group is updated, and the configuration information of the second demand material in each replacement group at the target component level of the replacement demand table is generated; The component processing module is used to match the supply and demand of the first demand material and the second demand material, extract the missing material as the target object, and call the component parsing module to perform parsing processing in a loop until all levels are completed; The generating of the configuration information of the second demand materials in each alternative group of the target component level of the alternative demand table includes: sorting each second demand material in the alternative demand table based on the planned date; Perform parallel calculations on the second demand materials in each alternative group on the same planning date to determine the required allocation quantity and supply plan for the second demand materials in each alternative group.
8. A computer-readable storage medium storing a computer program, wherein when the computer program is executed by a processor, the processor is caused to perform the steps of the method according to any one of claims 1 to 6.
9. A computer device comprising a memory and a processor, wherein the memory stores a computer program, and when the computer program is executed by the processor, the processor executes the steps of the method according to any one of claims 1 to 6.
