A computer-implemented method, apparatus, and computer program product

Abstract

The embodiment of the present disclosure provides a computer-implemented method, device and computer program product. The computer-implemented method comprises: receiving a query material instruction input by a user through a first input interface; in response to the query material instruction, obtaining data about a plurality of materials for manufacturing one or more product components from a data source, the data about the plurality of materials comprising available inventory quantities of the plurality of materials; calculating maximum consumptions of the plurality of materials with respect to at least one product component of the one or more product components; and determining whether there is a shortage of one or more materials for manufacturing the one or more product components according to the maximum consumptions of the respective materials of the plurality of materials and the available inventory quantities of the respective materials of the plurality of materials. The technical solution provided by the embodiment of the present disclosure solves the problem of material stagnation or shortage in the material management process to a great extent.

Description

[0001] This application claims priority to PCT International Application No. PCT / CN2022 / 141880, filed on December 26, 2022, entitled “Computer-implemented method, apparatus for managing the production of one or more products and computer program product”, the contents of which shall be construed as incorporated herein by reference. Technical Field

[0002] This disclosure relates to, but is not limited to, the field of display technology, and in particular to a computer-implemented method, apparatus, and computer program product. Background Technology

[0003] Product manufacturing management is a complex process. When dealing with large quantities of products and starting materials, and when product requirements and manufacturing processes change rapidly within a short period, material management becomes even more challenging. Traditional material management or simple programming is insufficient for managing production; material management is difficult and frequently results in material shortages, overstocking, and waste. Summary of the Invention

[0004] The problem to be solved by the embodiments of this disclosure is to provide a computer-implemented method, an apparatus for managing the production of one or more products, and a computer program product to solve the problem of material stagnation or shortage in the material management process.

[0005] The following is an overview of the subject matter described in detail herein. This overview is not intended to limit the scope of the claims.

[0006] To address the aforementioned technical problems, in a first aspect, embodiments of this disclosure also provide a computer-implemented method, comprising:

[0007] The system receives user-input material query commands through the first input interface.

[0008] In response to the material query instruction, data on multiple materials for manufacturing one or more product components is obtained from a data source, the data on multiple materials including the available inventory of multiple materials;

[0009] Calculate the maximum consumption of the plurality of materials relative to at least one of the one or more product components;

[0010] Determine whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials and the available inventory of the corresponding materials.

[0011] In an exemplary embodiment, the method further includes:

[0012] When it is determined that there are defects in multiple materials used to manufacture one or more product components, it is determined whether there are any next-level materials for the materials with defects.

[0013] When it is determined that there are downstream materials for the defective material, data of multiple downstream materials for the one or more defective materials used to manufacture one or more product components are obtained, and the data of multiple downstream materials for the one or more defective materials includes the available inventory of the multiple downstream materials.

[0014] Calculate the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with defects;

[0015] Determine whether there is a shortage of the multiple next-level materials based on the maximum consumption and available inventory of the corresponding materials.

[0016] In an exemplary embodiment, the data of the plurality of materials includes substitution relationship information between the plurality of materials, and the data of the plurality of next-level materials further includes substitution relationship information between the next-level materials;

[0017] Before acquiring data on multiple next-level materials of one or more materials that have defects in manufacturing one or more product components, the method further includes: identifying one or more materials with defects in a second group from the one or more materials with defects based on the substitution relationship information between the multiple materials; wherein the one or more materials with defects in the second group are non-substitutable materials relative to at least one of the one or more product components.

[0018] Before calculating the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with defects, the method further includes: based on the substitution relationship information between the next-level materials, determining the data of one or more next-level materials in a third group and the data of one or more next-level materials in a fourth group from the data of one or more materials with defects in the second group, wherein the one or more next-level materials in the third group are substitutable relative to at least one of the one or more materials with defects in the second group, and the one or more next-level materials in the fourth group are non-substitutable relative to at least one of the one or more materials with defects in the second group.

[0019] In an exemplary embodiment, calculating the maximum consumption of the plurality of materials relative to at least one of the one or more product components includes: calculating the maximum consumption of one or more materials in the second group relative to one or more product components based on data of one or more materials in the second group;

[0020] The step of determining whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials of the plurality of materials and the available inventory of the corresponding materials of the plurality of materials includes: calculating the remaining quantity of one or more materials in the second group based on the available inventory of one or more materials in the second group and the maximum consumption of one or more materials in the second group, and determining whether there is a shortage of one or more materials in the second group based on the remaining quantity of one or more materials in the second group.

[0021] In an exemplary embodiment, calculating the maximum consumption of one or more materials in the second group relative to one or more product components based on the data of one or more materials in the second group includes: multiplying the demand for one or more product components that require one or more materials in the second group as irreplaceable materials by the sum of the values ​​of the corresponding unit consumption of the corresponding materials in the second group relative to the manufacture of one or more product components, to obtain the maximum consumption of one or more materials in the second group relative to one or more product components.

[0022] In an exemplary embodiment, when it is determined that one or more materials in the second group are in short supply, the method further includes: calculating the shortage amount of one or more materials in the second group based on the available inventory of the one or more materials in the second group and the maximum consumption of the one or more materials in the second group.

[0023] In an exemplary embodiment, calculating the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with defects includes: calculating the maximum consumption of one or more next-level materials in the fourth group relative to one or more materials with defects in the second group;

[0024] The step of determining whether there is a shortage of the multiple next-level materials based on the maximum consumption and available inventory of the corresponding materials includes: subtracting the maximum consumption of one or more next-level materials in the fourth group from the available inventory of one or more next-level materials in the fourth group to obtain the remaining quantity of one or more next-level materials in the fourth group, and determining whether there is a shortage of one or more next-level materials in the fourth group based on the remaining quantity of one or more next-level materials in the fourth group.

[0025] In an exemplary embodiment, calculating the maximum consumption of one or more next-level materials in the fourth group relative to one or more materials in the second group that have defects includes: multiplying the defect amount of one or more materials in the second group that require one or more next-level materials in the fourth group as irreplaceable materials by the sum of the unit consumption values ​​of the corresponding next-level materials in the fourth group for manufacturing one or more corresponding materials in the second group that have defects, to obtain the maximum consumption of one or more next-level materials in the fourth group relative to one or more materials in the second group that have defects.

[0026] In an exemplary embodiment, the method further includes:

[0027] When it is determined that there is a shortage of one or more next-level materials in the fourth group, the shortage amount of one or more next-level materials in the fourth group is obtained based on the remaining amount of one or more next-level materials in the fourth group, and the shortage amount and shortage status of one or more next-level materials in the fourth group are displayed through the first output interface.

[0028] When it is determined that there are no defects in one or more next-level materials in the fourth group and the remaining quantity is 0, the remaining quantity and material status of one or more next-level materials in the fourth group are displayed through the first output interface.

[0029] When it is determined that one or more next-level materials in the fourth group have no defects and the remaining quantity is greater than 0, based on the substitution relationship information between the next-level materials, it is determined whether one or more next-level materials in the fourth group are substitutable relative to at least one of the one or more materials in the first group that have defects; when it is determined that one or more next-level materials in the fourth group are not substitutable relative to the one or more materials in the first group that have defects, it is determined that one or more next-level materials in the fourth group are stagnant, and the stagnant status and remaining quantity of one or more next-level materials in the fourth group are displayed through the first output interface.

[0030] In an exemplary embodiment, calculating the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with defects includes: using a third linear programming model to calculate the maximum consumption of one or more semi-finished components in the third group relative to one or more materials with defects in the second group;

[0031] The step of determining whether there is a shortage of the multiple next-level materials based on the maximum consumption and available inventory of the corresponding materials includes: subtracting the maximum consumption of one or more next-level materials in the third group from the available inventory of one or more next-level materials in the third group to obtain the remaining quantity of one or more next-level materials in the third group, and determining whether there is a shortage of one or more next-level materials in the third group based on the remaining quantity of one or more next-level materials in the third group.

[0032] In an exemplary embodiment, the method further includes:

[0033] When it is determined that there is a shortage of one or more next-level materials in the third group, the shortage amount of one or more next-level materials in the third group is obtained based on the remaining amount of one or more next-level materials in the third group, and the shortage amount and shortage status of one or more next-level materials in the third group are displayed through the first output interface.

[0034] When it is determined that there are no defects in one or more next-level materials in the third group and the remaining quantity is 0, the remaining quantity and material status of one or more next-level materials in the third group are displayed through the first output interface.

[0035] When it is determined that one or more next-level materials in the third group have no defects and the remaining quantity is greater than 0, based on the substitution relationship information between the next-level materials, it is determined whether one or more next-level materials in the third group are substitutable relative to at least one of the one or more materials in the first group that have defects; when it is determined that one or more materials in the third group are not substitutable relative to the one or more materials in the first group that have defects, it is determined that one or more next-level materials in the third group are stagnant, and the stagnant status and remaining quantity of one or more next-level materials in the third group are displayed through the first output interface.

[0036] In an exemplary embodiment, the third objective function of the third linear programming model is expressed as:

[0037]

[0038] Where, x i This represents the available quantity of the corresponding material in the second group that is lacking in the preparation of the next-level material in the third group; d i N represents the unit consumption value of the corresponding next-level material in the third group relative to one or more corresponding materials in the second group that have defects; N is a positive integer, N≥1.

[0039] In an exemplary embodiment, the third objective function is constrained by a first constraint function, which is expressed as:

[0040]

[0041] Among them, Q l This represents the defect amount of the l-th material in the second group that has a defect; (Q) l G j Let x represent a set of variables (which can be a variable set) of the next-level materials in the j-th group relative to the l-th material with a defect. Multiple next-level materials in the j-th group can substitute for each other when producing the l-th material with a defect; 0 ≤ x i ≤Q l ; 1≤j≤J, where J represents the total number of groups of next-level materials that can be substituted for each other when producing the l-th material with a defect.

[0042] In an exemplary embodiment, the third objective function is constrained by a second constraint function, which is expressed as:

[0043]

[0044] Among them, C m X represents the available inventory of the m-th sub-level material in the third group; m A set of variables (which can be a set of variables) representing the m-th next-level material; 1≤m≤M, where M represents the total number of next-level material types in the third group.

[0045] In an exemplary embodiment, the data for the plurality of materials includes information on the substitution relationships between the plurality of materials and the demand for one or more product components;

[0046] Before acquiring data on multiple next-level materials of one or more materials for manufacturing one or more product components that have defects, the method further includes: identifying one or more materials in a first group from the multiple materials based on substitution relationship information between the multiple materials, wherein one or more materials in the first group are substitute materials relative to at least one product component of the one or more product components;

[0047] The calculation of the maximum consumption of the plurality of materials relative to at least one of the one or more product components includes: calculating the maximum consumption of the one or more materials in the first group relative to one or more product components based on data of the one or more materials in the first group;

[0048] The step of determining whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials of the plurality of materials and the available inventory of the corresponding materials of the plurality of materials includes: obtaining the available quantity of one or more substitute material groups in the first group relative to one or more product components when the consumption of one or more materials in the first group relative to one or more product components is the maximum consumption; and determining whether there is a shortage of one or more substitute material groups in the first group relative to the corresponding product components based on the available quantity of one or more substitute material groups in the first group relative to one or more product components and the demand of one or more product components.

[0049] In an exemplary embodiment, when it is determined that there are defects in multiple materials used to manufacture one or more product components, determining whether there are next-level materials for the defective materials includes: when it is determined that there are defects in one or more alternative material groups in the first group relative to the corresponding product component, determining whether there are next-level materials for the material groups in the first group that have defects.

[0050] When it is determined that there are defective materials in the next level of materials, data of multiple next level materials of the one or more materials in the manufacturing of one or more product components with defects are obtained, including: when it is determined that there are defective material groups in the first group with next level materials, material data of one or more next level materials of the one or more material groups with defects in the first group are obtained.

[0051] The calculation of the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with defects includes: taking the plurality of next-level materials of the one or more material groups with defects in the first group as one or more next-level materials in the fifth group, and calculating the maximum consumption of the product components corresponding to the one or more next-level materials in the fifth group relative to the one or more material groups with defects in the first group based on the material data of the one or more next-level materials in the fifth group.

[0052] The step of determining whether there is a shortage of the multiple next-level materials based on the maximum consumption and available inventory of the corresponding materials includes: calculating the remaining quantity of one or more next-level materials in the fifth group based on the available inventory of one or more next-level materials in the fifth group and the maximum consumption of the product components corresponding to one or more next-level materials in the first group that have shortages, relative to the maximum consumption of the corresponding material groups that have shortages in the first group; and determining whether there is a shortage of one or more next-level materials in the fifth group based on the remaining quantity of one or more next-level materials in the fifth group.

[0053] In an exemplary embodiment, when it is determined that there is a shortage of one or more substitute material groups in the first group relative to the corresponding product component, the method further includes: calculating the shortage amount of one or more substitute material groups in the first group relative to the corresponding product component based on the available quantity of one or more substitute material groups in the first group relative to the corresponding product component and the demand amount of the material in the first group that is in short supply.

[0054] When it is determined that there is a shortage of one or more next-level materials in the fifth group, the method further includes: calculating a sixth shortage value based on the available quantity of the corresponding material in the first group that has a shortage and the shortage amount of the corresponding material group in the first group that has a shortage, based on the one or more next-level materials in the fifth group; and updating the shortage amount of the corresponding material group in the first group that has a shortage using the sixth shortage value.

[0055] Obtain configuration parameters, reallocate the shortage amount of the missing materials in the corresponding material groups in the first group according to the configuration parameters, update the shortage amount of the corresponding materials in the first group using the allocated shortage amount, and display the shortage amount and shortage status of the corresponding materials in the first group through the first output interface.

[0056] In an exemplary embodiment, the method further includes:

[0057] When it is determined that there is a shortage of one or more next-level materials in the fifth group, the shortage amount of one or more next-level materials in the fifth group is obtained based on the remaining amount of one or more next-level materials in the fifth group, and the shortage amount and shortage status of one or more next-level materials in the fifth group are displayed through the first output interface.

[0058] When it is determined that there are no defects in one or more next-level materials in the fifth group and the remaining quantity is greater than 0, the remaining quantity and stagnation status of one or more next-level materials in the fifth group are output through the first display interface.

[0059] When it is determined that there are no defects in one or more next-level materials in the fifth group and the remaining quantity is equal to 0, the remaining quantity and material status of one or more next-level materials in the fifth group are output through the first display interface.

[0060] In an exemplary embodiment, the method further includes:

[0061] When it is determined that one or more next-level materials in the fifth group are in short supply, the configuration parameters of the next-level materials are obtained. Based on the configuration parameters of the next-level materials, the shortage amount of the missing materials in the corresponding next-level material group in the fifth group is reallocated. The shortage amount of the corresponding next-level materials in the fifth group is updated using the reallocated shortage amount. The updated shortage amount and shortage status of the corresponding next-level materials in the fifth group are displayed through the first output interface.

[0062] In an exemplary embodiment, the method further includes: when it is determined that one or more next-level materials in the fifth group have a shortage, obtaining the configuration parameters of the next-level materials, reallocating the shortage amount of the corresponding next-level materials in the fifth group that have a shortage according to the configuration parameters of the next-level materials, and updating the shortage amount of the corresponding next-level materials in the fifth group with the reallocated shortage amount.

[0063] In an exemplary embodiment, the method further includes: when it is determined that there is no next-level material for the material with defects, displaying the defect status of the material with defects through a first output interface;

[0064] When it is determined that there are no defects in one or more materials used to manufacture one or more product components, the material information of one or more materials used to manufacture one or more product components is displayed through the first output interface.

[0065] In an exemplary embodiment, the method further includes: when it is determined that one or more materials with shortages are stagnant or in short supply based on the maximum consumption and available inventory of the corresponding materials of the plurality of next-level materials, adjusting the demand for the one or more product components to minimize the stagnant or in short supply of the next-level materials; and producing the one or more product components based on the adjusted demand for the one or more product components.

[0066] In an exemplary embodiment, the method further includes: generating one or more user interfaces;

[0067] The one or more user interfaces include the first output interface, which is further configured to display the material status of the corresponding material in at least one of the first to fifth groups.

[0068] In an exemplary embodiment, the one or more user interfaces further include a first input interface configured to receive one or more user inputs for querying a database; the database stores data on a plurality of materials.

[0069] The computer-implemented method further includes: receiving a user selection of one or more conditions from the first input interface, the user selection being used to select a material state related to the one or more conditions; and in response to the user selection, querying the database to determine one or more material states in the database related to the one or more conditions.

[0070] The one or more conditions include at least one of the following: the stagnation state of stagnant materials and the shortage state of defective materials;

[0071] The one or more user interfaces also include a second output interface configured to display the one or more stagnant or missing materials as a result of querying the database.

[0072] In an exemplary embodiment, the one or more user interfaces further include a second input interface configured to receive one or more user inputs for adjusting the priority of the respective materials in the first group;

[0073] The computer-implemented method further includes: re-determining whether the corresponding materials in the first group are stagnant or in short supply based on the adjusted priority of the corresponding materials in the first group.

[0074] In an exemplary embodiment, the one or more user interfaces further include a third input interface configured to receive one or more user inputs for adjusting the requirements of the one or more product components;

[0075] The computer-implemented method further includes: calculating the adjusted maximum consumption of the corresponding materials in the first group based on the adjusted demand for the one or more product components;

[0076] Compare the adjusted maximum consumption of the corresponding material in the first group with the available inventory of the corresponding material in the first group;

[0077] Reassess whether the corresponding materials in the first group are stagnant or in short supply.

[0078] In an exemplary embodiment, the method further includes:

[0079] The system receives user input commands to query material status via the first input interface.

[0080] In response to the query material status command, at least one of the following is obtained from the data source regarding the remaining quantity, stagnation status, shortage status, and shortage quantity of multiple materials for manufacturing one or more product components and multiple next-level materials of the multiple materials.

[0081] In a second aspect, embodiments of this disclosure provide a computer-implemented method, including:

[0082] Data on multiple next-level materials of one or more materials for manufacturing one or more product components that have defects is obtained; the data on multiple next-level materials of one or more materials with defects includes the available inventory of the multiple next-level materials;

[0083] Calculate the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with defects;

[0084] Based on the maximum consumption and available inventory of the corresponding materials of the plurality of next-level materials, it is determined whether one or more materials with defects exist.

[0085] In an exemplary embodiment, before acquiring data on multiple next-level materials of one or more materials for manufacturing one or more product components that have defects, the method further includes:

[0086] Obtain data on multiple materials for manufacturing one or more product components, the data on multiple materials including the available inventory of multiple materials;

[0087] Calculate the maximum consumption of the plurality of materials relative to at least one of the one or more product components;

[0088] Determine whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials and the available inventory of the corresponding materials.

[0089] In an exemplary embodiment, the method further includes:

[0090] When it is determined that there are defects in multiple materials used to manufacture one or more product components, it is determined whether there are any next-level materials for the materials with defects.

[0091] When it is determined that there is a next-level material for the material with defects, data of multiple next-level materials for the one or more materials with defects in the manufacturing of one or more product components are obtained.

[0092] In an exemplary embodiment, the data of the plurality of materials includes substitution relationship information between the plurality of materials;

[0093] Before acquiring data on multiple next-level materials of the one or more materials that have defects in the manufacture of one or more product components, the method further includes: identifying one or more materials with defects in a second group from the one or more materials with defects based on the substitution relationship information between the multiple materials; wherein the one or more materials with defects in the second group are irreplaceable materials relative to at least one of the one or more product components.

[0094] In an exemplary embodiment, the data of the plurality of next-level materials also includes substitution relationship information between the next-level materials;

[0095] Before calculating the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with defects, the method further includes: based on the substitution relationship information between the next-level materials, determining the data of one or more next-level materials in a third group and the data of one or more next-level materials in a fourth group from the data of one or more materials with defects in the second group, wherein the one or more next-level materials in the third group are substitutable relative to at least one of the one or more materials with defects in the second group, and the one or more next-level materials in the fourth group are non-substitutable relative to at least one of the one or more materials with defects in the second group.

[0096] In an exemplary embodiment, calculating the maximum consumption of the plurality of materials relative to at least one of the one or more product components includes: calculating the maximum consumption of one or more materials in the second group relative to one or more product components based on data of one or more materials in the second group;

[0097] The step of determining whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials of the plurality of materials and the available inventory of the corresponding materials of the plurality of materials includes: calculating the remaining quantity of one or more materials in the second group that have a shortage based on the available inventory of one or more materials in the second group and the maximum consumption of one or more materials in the second group, and determining whether there is a shortage of one or more materials in the second group based on the remaining quantity of one or more materials in the second group.

[0098] In an exemplary embodiment, when it is determined that one or more materials in the second group are in short supply, the method further includes: calculating the shortage amount of one or more materials in the second group based on the available inventory of the one or more materials in the second group and the maximum consumption of the one or more materials in the second group.

[0099] In an exemplary embodiment, calculating the maximum consumption of the plurality of materials relative to at least one of the one or more product components includes: calculating the maximum consumption of one or more materials in the second group that have defects relative to at least one of the one or more product components.

[0100] The step of determining whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials of the plurality of materials and the available inventory of the corresponding materials of the plurality of materials includes: calculating the remaining quantity of one or more materials in the second group that have a shortage based on the available inventory of one or more materials in the second group that have a shortage and the maximum consumption of one or more materials in the second group that have a shortage; and determining whether there is a shortage of one or more materials in the second group based on the remaining quantity of one or more materials in the second group that have a shortage.

[0101] When it is determined that one or more materials in the second group have defects, the method further includes: obtaining the defect amount of one or more materials in the second group based on the remaining amount of the defective materials in the second group.

[0102] In an exemplary embodiment, the data for the next-level material also includes the unit consumption values ​​of multiple next-level materials for manufacturing one or more materials in the second group that have defects;

[0103] The calculation of the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with defects includes: multiplying the defect amount of the one or more materials in the second group that require one or more next-level materials in the fourth group as irreplaceable materials by the sum of the unit consumption values ​​of the corresponding next-level materials in the fourth group for manufacturing the corresponding one or more materials in the second group with defects, to obtain the maximum consumption of the one or more next-level materials in the fourth group relative to the one or more materials in the second group with defects;

[0104] The step of determining whether one or more materials with a shortage exist based on the maximum consumption and available inventory of the corresponding materials of the plurality of next-level materials includes: subtracting the maximum consumption of one or more next-level materials in the fourth group from the available inventory of one or more next-level materials in the fourth group to obtain the remaining quantity of one or more next-level materials in the fourth group; when the remaining quantity of one or more next-level materials in the fourth group is less than 0, it is determined that one or more materials in the fourth group have a shortage.

[0105] In an exemplary embodiment, when the remaining amount of one or more next-level materials in the fourth group is greater than 0, the method further includes:

[0106] Based on the substitution relationship information between the next-level materials, determine whether at least one of the next-level materials in the fourth group is a substitute material relative to one or more materials in the first group that have a deficiency.

[0107] In an exemplary embodiment, when it is determined that one or more next-level materials in the fourth group are not substitutes for one or more materials in the first group that have a deficiency, it is determined that one or more materials in the fourth group are stagnant.

[0108] In an exemplary embodiment, after obtaining the remaining amount of one or more next-level materials in the fourth group, the method further includes:

[0109] Update the available inventory of the corresponding next-level material in the fourth group using the remaining quantity of one or more next-level materials in the fourth group.

[0110] In an exemplary embodiment, calculating the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with defects includes: using a third linear programming model to calculate the maximum consumption of one or more next-level materials in the third group relative to one or more materials with defects in the second group;

[0111] The step of determining whether one or more materials with a shortage exist based on the maximum consumption and available inventory of the corresponding materials of the plurality of next-level materials includes: subtracting the maximum consumption of one or more next-level materials in the third group from the available inventory of one or more next-level materials in the third group to obtain the remaining quantity of one or more next-level materials in the third group; when the remaining quantity of one or more next-level materials in the third group is less than 0, it is determined that one or more next-level materials in the third group have a shortage.

[0112] In an exemplary embodiment, the third objective function of the third linear programming model is expressed as:

[0113]

[0114] Where, x i This represents the available quantity of the corresponding material in the second group that is lacking in the preparation of the next-level material in the third group; d i N represents the unit consumption value of the corresponding next-level material in the third group relative to one or more corresponding materials in the second group that have defects; N is a positive integer, N≥1.

[0115] In an exemplary embodiment, the third objective function is constrained by a first constraint function, which is expressed as:

[0116]

[0117] Among them, Q l This represents the defect amount of the l-th material in the second group that has a defect; (Q) l G jLet x represent a set of variables (which can be a variable set) of the next-level materials in the j-th group relative to the l-th material with a defect. Multiple next-level materials in the j-th group can substitute for each other when producing the l-th material with a defect; 0 ≤ x i ≤Q l ; 1≤j≤J, where J represents the total number of groups of next-level materials that can be substituted for each other when producing the l-th material with a defect.

[0118] In an exemplary embodiment, the third objective function is constrained by a second constraint function, which is expressed as:

[0119]

[0120] Among them, C m X represents the available inventory of the m-th sub-level material in the third group; m A set of variables (which can be a set of variables) representing the m-th next-level material; 1≤m≤M, where M represents the total number of next-level material types in the third group.

[0121] In an exemplary embodiment, the data for the plurality of materials includes information on the substitution relationships between the plurality of materials and the demand for one or more product components;

[0122] Before acquiring data on multiple next-level materials of one or more materials for manufacturing one or more product components that have defects, the method further includes: identifying one or more materials in a first group from the multiple materials based on substitution relationship information between the multiple materials, wherein one or more materials in the first group are substitute materials relative to at least one product component of the one or more product components;

[0123] The calculation of the maximum consumption of the plurality of materials relative to at least one of the one or more product components includes: calculating the maximum consumption of the one or more materials in the first group relative to one or more product components based on data of the one or more materials in the first group;

[0124] The step of determining whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials of the plurality of materials and the available inventory of the corresponding materials of the plurality of materials includes: obtaining the available quantity of one or more substitute material groups in the first group relative to one or more product components when the consumption of one or more materials in the first group relative to one or more product components is the maximum consumption; and determining whether there is a shortage of one or more substitute material groups in the first group relative to the corresponding product components based on the available quantity of one or more substitute material groups in the first group relative to the corresponding product components and the demand of one or more product components in the first group.

[0125] In an exemplary embodiment, when it is determined that there are defects in multiple materials used to manufacture one or more product components, determining whether there are next-level materials for the defective materials includes: when it is determined that there are defects in one or more alternative material groups in the first group relative to the corresponding product component, determining whether there are next-level materials for the material groups in the first group that have defects.

[0126] When it is determined that there are sub-level materials for the defective material, data of multiple sub-level materials of the one or more defective materials used to manufacture one or more product components are obtained, including: when it is determined that there are sub-level materials for the defective material group in the first group, material data of one or more sub-level materials of the one or more defective material groups in the first group are obtained.

[0127] In an exemplary embodiment, calculating the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with defects includes: taking the plurality of next-level materials of the one or more material groups with defects in the first group as one or more next-level materials in the fifth group, and calculating the maximum consumption of the product components corresponding to the one or more next-level materials in the fifth group relative to the one or more material groups with defects in the first group based on the material data of the one or more next-level materials in the fifth group.

[0128] The step of determining whether one or more materials with defects exist based on the maximum consumption and available inventory of the corresponding materials of the plurality of next-level materials includes: calculating the remaining quantity of one or more next-level materials in the fifth group based on the available inventory of one or more next-level materials in the fifth group and the maximum consumption of the product components corresponding to one or more next-level materials in the fifth group relative to the corresponding material groups with defects in the first group; and determining whether one or more next-level materials in the fifth group have defects based on the remaining quantity of one or more next-level materials in the fifth group.

[0129] In an exemplary embodiment, when it is determined that there is a shortage of one or more substitute material groups in the first group relative to the corresponding product component, the method further includes: calculating the shortage amount of one or more substitute material groups in the first group relative to the corresponding product component based on the available quantity of one or more substitute material groups in the first group relative to the corresponding product component and the demand amount of the material in the first group that is in short supply.

[0130] When it is determined that there is a shortage of one or more next-level materials in the fifth group, the method further includes: calculating a sixth shortage value based on the available quantity of the corresponding material in the first group that has a shortage and the shortage amount of the corresponding material group in the first group that has a shortage, based on the one or more next-level materials in the fifth group; and updating the shortage amount of the corresponding material group in the first group that has a shortage using the sixth shortage value.

[0131] Obtain the configuration parameters, and reallocate the shortage amount of the missing materials in the corresponding material groups in the first group according to the configuration parameters. Update the shortage amount of the corresponding materials in the first group with the reallocated shortage amount.

[0132] In an exemplary embodiment, the method further includes: when it is determined that one or more next-level materials in the fifth group have a shortage, obtaining the configuration parameters of the next-level materials, reallocating the shortage amount of the corresponding next-level materials in the fifth group that have a shortage according to the configuration parameters of the next-level materials, and updating the shortage amount of the corresponding next-level materials in the fifth group with the reallocated shortage amount.

[0133] In an exemplary embodiment, the method further includes: when it is determined that one or more materials with shortages are stagnant or in short supply based on the maximum consumption and available inventory of the corresponding materials of the plurality of next-level materials, adjusting the demand for the one or more product components to minimize the stagnant or in short supply of the next-level materials; and producing the one or more product components based on the adjusted demand for the one or more product components.

[0134] In an exemplary embodiment, the method further includes: generating one or more user interfaces;

[0135] The one or more user interfaces include a first output interface configured to display the material status of the corresponding material in at least one of the first to fifth groups.

[0136] In an exemplary embodiment, the one or more user interfaces further include a first input interface configured to receive one or more user inputs for querying a database; the database stores data on a plurality of materials.

[0137] The computer-implemented method further includes: receiving a user selection of one or more conditions from the first input interface, the user selection being used to select a material state related to the one or more conditions; and in response to the user selection, querying the database to determine one or more material states in the database related to the one or more conditions.

[0138] The one or more conditions include at least one of the following: the stagnation state of stagnant materials and the shortage state of defective materials;

[0139] The one or more user interfaces also include a second output interface configured to display the one or more stagnant or missing materials as a result of querying the database.

[0140] In an exemplary embodiment, the one or more user interfaces further include a second input interface configured to receive one or more user inputs for adjusting the priority of the respective materials in the first group;

[0141] The computer-implemented method further includes: re-determining whether the corresponding materials in the first group are stagnant or in short supply based on the adjusted priority of the corresponding materials in the first group.

[0142] In an exemplary embodiment, the one or more user interfaces further include a third input interface configured to receive one or more user inputs for adjusting the requirements of the one or more product components;

[0143] The computer-implemented method further includes: calculating the adjusted maximum consumption of the corresponding materials in the first group based on the adjusted demand for the one or more product components;

[0144] Compare the adjusted maximum consumption of the corresponding material in the first group with the available inventory of the corresponding material in the first group;

[0145] Reassess whether the corresponding materials in the first group are stagnant or in short supply.

[0146] Thirdly, embodiments of this disclosure also provide an apparatus for managing the production of one or more products, comprising:

[0147] Memory;

[0148] One or more processors;

[0149] The memory and the one or more processors are connected to each other; the memory stores computer-executable instructions for controlling the one or more processors to perform the following operations:

[0150] Data on multiple next-level materials of one or more materials for manufacturing one or more product components that have defects is obtained; the data on multiple next-level materials of one or more materials with defects includes the available inventory of the multiple next-level materials;

[0151] Calculate the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with defects;

[0152] Based on the maximum consumption and available inventory of the corresponding materials of the plurality of next-level materials, it is determined whether one or more materials with defects exist.

[0153] Fourthly, embodiments of this disclosure also provide a computer program product, including a non-transitory tangible computer-readable medium having computer-readable instructions thereon, the computer-readable instructions being executable by a processor to cause the processor to perform:

[0154] Data on multiple next-level materials of one or more materials for manufacturing one or more product components that have defects is obtained; the data on multiple next-level materials of one or more materials with defects includes the available inventory of the multiple next-level materials;

[0155] Calculate the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with defects;

[0156] Based on the maximum consumption and available inventory of the corresponding materials of the plurality of next-level materials, it is determined whether one or more materials with defects exist.

[0157] Fifthly, embodiments of this disclosure also provide an apparatus for managing the production of one or more products, comprising:

[0158] Memory;

[0159] One or more processors;

[0160] The memory and the one or more processors are connected to each other; the memory stores computer-executable instructions for controlling the one or more processors to perform the following operations:

[0161] The system receives user-input material query commands through the first input interface.

[0162] In response to the material query instruction, data on multiple materials for manufacturing one or more product components is obtained from a data source, the data on multiple materials including the available inventory of multiple materials;

[0163] Calculate the maximum consumption of the plurality of materials relative to at least one of the one or more product components;

[0164] Determine whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials and the available inventory of the corresponding materials.

[0165] Sixthly, embodiments of this disclosure also provide a computer program product, including a non-transitory tangible computer-readable medium having computer-readable instructions thereon, the computer-readable instructions being executable by a processor to cause the processor to perform:

[0166] The system receives user-input material query commands through the first input interface.

[0167] In response to the material query instruction, data on multiple materials for manufacturing one or more product components is obtained from a data source, the data on multiple materials including the available inventory of multiple materials;

[0168] Calculate the maximum consumption of the plurality of materials relative to at least one of the one or more product components;

[0169] Determine whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials and the available inventory of the corresponding materials.

[0170] This disclosure provides a computer-implemented method, an apparatus for managing the production of one or more products, and a computer program product. The computer-implemented method includes: receiving a user-inputted material query instruction through a first input interface; responding to the material query instruction, obtaining data from a data source regarding multiple materials for manufacturing one or more product components, the data including available inventory levels of the multiple materials; calculating the maximum consumption of the multiple materials relative to at least one of the one or more product components; and determining whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials and the available inventory levels of the corresponding materials. The technical solution provided by this disclosure can solve the problem of material stagnation or shortages in the material management process.

[0171] After reading and understanding the accompanying diagrams and detailed descriptions, the other aspects can be understood. Attached Figure Description

[0172] The accompanying drawings are used to provide an understanding of the technical solutions of the embodiments of this disclosure and constitute a part of the specification. They are used together with the embodiments of this disclosure to explain the technical solutions of the embodiments of this disclosure and do not constitute a limitation on the technical solutions of this disclosure.

[0173] Figure 1 The diagram shown is a flowchart of a computer-implemented method provided in an embodiment of this disclosure;

[0174] Figure 2 The diagram shown is a flowchart of a computer-implemented method provided by an exemplary embodiment of this disclosure;

[0175] Figure 3a and Figure 3b The diagram shown is a flowchart of a computer-implemented method provided by an exemplary embodiment of this disclosure;

[0176] Figure 4 The diagram shown is a schematic representation of one or more interfaces provided in an exemplary embodiment of this disclosure;

[0177] Figure 5 The diagram shown is a schematic representation of a third output interface provided in an exemplary embodiment of this disclosure;

[0178] Figure 6 The diagram shown is a schematic of a device module for managing the production of one or more products according to an embodiment of this disclosure;

[0179] Figure 7 The diagram shown is a structural schematic of an apparatus for managing the production of one or more products, provided by an exemplary embodiment of this disclosure. Detailed Implementation

[0180] To make the objectives, technical solutions, and advantages of this invention clearer, the embodiments of this disclosure will be described in detail below with reference to the accompanying drawings. It should be noted that, unless otherwise specified, the embodiments and features described in these embodiments can be arbitrarily combined with each other.

[0181] Unless otherwise defined, the technical or scientific terms used in this disclosure should be understood in their ordinary sense by one of ordinary skill in the art to which this invention pertains. The terms "first," "second," and similar terms used in this disclosure do not indicate any order, quantity, or importance, but are merely used to distinguish different components. Terms such as "comprising" or "including" encompass the elements or objects listed preceding the term or their equivalents appearing after the term, without excluding other elements or objects.

[0182] In the process of product production management, when there are many types of products and complex material sharing and substitution relationships involved, the control and management of shared and substitute materials is quite difficult. Material waste often occurs due to stagnant materials, and production cycles are extended (or even product delivery time is delayed) due to material shortages, resulting in increased material management costs. When product demand and manufacturing processes change rapidly in a short period of time, material management becomes even more difficult, and the phenomenon of material stagnation or shortages becomes more serious.

[0183] To address the issues of material stagnation or shortage during material management, this disclosure provides a computer-implemented method that receives a user-inputted material query command through a first input interface.

[0184] In response to the material query instruction, data on multiple materials for manufacturing one or more product components is obtained from a data source, the data on multiple materials including the available inventory of multiple materials;

[0185] Calculate the maximum consumption of the plurality of materials relative to at least one of the one or more product components;

[0186] Determine whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials and the available inventory of the corresponding materials.

[0187] The computer-implemented method provided in this disclosure receives a material query command input by a user through a first input interface; in response to the material query command, it obtains data on multiple materials for manufacturing one or more product components from a data source, the data of the multiple materials including the available inventory of the multiple materials; it calculates the maximum consumption of the multiple materials relative to at least one of the one or more product components; and it determines whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials and the available inventory of the corresponding materials. The technical solution provided in this disclosure can solve the problem of material stagnation or shortage in the material management process.

[0188] like Figure 1 As shown, the computer-implemented method provided in this embodiment may include steps 21 to 24:

[0189] Step 21: Receive the user's material query command through the first input interface;

[0190] Step 22: In response to a material query instruction, retrieve data from the data source regarding multiple materials for manufacturing one or more product components. The data for the multiple materials includes the available inventory levels of the multiple materials.

[0191] Step 23: Calculate the maximum consumption of multiple materials relative to at least one of the one or more product components;

[0192] Step 24: Determine whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials and the available inventory of the corresponding materials for multiple materials.

[0193] In an exemplary implementation, the data source can be a database, or the data source can be a link address (or database address), and the corresponding database can be accessed based on the link address.

[0194] In an exemplary embodiment, the maximum consumption of multiple materials relative to at least one of one or more product components can be understood as the target demand of multiple materials when preparing one or more product components.

[0195] The computer-implemented method provided in this disclosure, when there is a material shortage during the production of one or more product components, can consume the next-level material of the material with the shortage to replenish the material with the shortage. After replenishment, it is determined whether there is still a shortage of the material with the shortage. On the one hand, it can maximize the consumption of the next-level material and avoid the stagnation of the next-level material. On the other hand, it can replenish the material with the shortage in a timely manner, which largely solves the problem of material stagnation or shortage in the material management process.

[0196] In an exemplary embodiment, the above method may further include:

[0197] If, in step 24, it is determined that there are defects in multiple materials used to manufacture one or more product components, steps 241 to 244 are executed:

[0198] Step 241: Determine whether the material with defects has a next-level material;

[0199] Step 242: When it is determined that there are downstream materials for the defective material, obtain the data of multiple downstream materials for the one or more materials that are defective in the manufacture of one or more product components. The data of multiple downstream materials for the one or more materials that are defective include the available inventory of multiple downstream materials.

[0200] Step 243: Calculate the maximum consumption of multiple next-level materials relative to at least one of the one or more materials with defects;

[0201] Step 244: Determine whether there is a shortage of multiple lower-level materials based on the maximum consumption and available inventory of the corresponding materials.

[0202] In an exemplary embodiment, the data of multiple materials includes substitution relationship information between multiple materials, and the data of multiple next-level materials also includes substitution relationship information between next-level materials;

[0203] Before obtaining data on multiple next-level materials of one or more materials that have defects in manufacturing one or more product components in step 242, the method may further include: identifying one or more materials with defects in a second group from the one or more materials with defects based on substitution relationship information between multiple materials; wherein the one or more materials with defects in the second group are non-substitutable materials relative to at least one of the one or more product components.

[0204] Before calculating the maximum consumption of multiple next-level materials relative to at least one of the one or more materials with defects in step 243, the method may further include: based on the substitution relationship information between the next-level materials, identifying the data of one or more next-level materials in the third group and the data of one or more next-level materials in the fourth group from the data of one or more materials with defects in the second group, wherein one or more next-level materials in the third group are substitutable relative to at least one of the one or more materials with defects in the second group, and one or more next-level materials in the fourth group are non-substitutable relative to at least one of the one or more materials with defects in the second group.

[0205] In an exemplary embodiment, step 23, calculating the maximum consumption of multiple materials relative to at least one of one or more product components, may include: calculating the maximum consumption of one or more materials in the second group relative to one or more product components based on data of one or more materials in the second group.

[0206] In step 24, determining whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials and the available inventory of the corresponding materials can include: calculating the remaining quantity of one or more materials in the second group based on the available inventory of one or more materials in the second group and the maximum consumption of one or more materials in the second group, and determining whether there is a shortage of one or more materials in the second group based on the remaining quantity of one or more materials in the second group.

[0207] In an exemplary embodiment, calculating the maximum consumption of one or more materials in the second group relative to one or more product components based on data of one or more materials in the second group may include: multiplying the demand for one or more product components that require one or more materials in the second group as irreplaceable materials by the sum of the values ​​of the corresponding unit consumption of the corresponding materials in the second group relative to the manufacture of one or more product components, to obtain the maximum consumption of one or more materials in the second group relative to one or more product components.

[0208] In an exemplary embodiment, when it is determined that one or more materials in the second group are in short supply, the method may further include: calculating the shortage amount of one or more materials in the second group based on the available inventory of one or more materials in the second group and the maximum consumption of one or more materials in the second group.

[0209] In an exemplary embodiment, the remaining quantity of one or more materials in the second group that are in short supply can be calculated based on the available inventory of one or more materials in the second group that are in short supply and the maximum consumption of one or more materials in the second group that are in short supply. For example, the remaining quantity of one or more materials in the second group that are in short supply can be obtained by subtracting the maximum consumption of one or more materials in the second group that are in short supply from the available inventory of one or more materials in the second group that are in short supply. When the remaining quantity of one or more materials in the second group that are in short supply is less than 0, it is determined that one or more materials in the second group are in short supply. The shortage amount can be a negative number of the remaining quantity (if the remaining quantity is less than 0, the value of the shortage amount can be greater than 0).

[0210] In an exemplary embodiment, calculating the maximum consumption of a plurality of next-level materials relative to at least one of the materials with defects in one or more of the materials may include: Step 231: Calculating the maximum consumption of one or more next-level materials in the fourth group relative to one or more materials with defects in the second group.

[0211] Step 244, which determines whether there is a shortage of multiple lower-level materials based on the maximum consumption and available inventory of the corresponding materials, may include: subtracting the maximum consumption of one or more lower-level materials in the fourth group from the available inventory of one or more lower-level materials in the fourth group to obtain the remaining quantity of one or more lower-level materials in the fourth group, and determining whether there is a shortage of one or more lower-level materials in the fourth group based on the remaining quantity of one or more lower-level materials in the fourth group.

[0212] In an exemplary embodiment, calculating the maximum consumption of one or more next-level materials in the fourth group relative to one or more materials in the second group that have defects includes: multiplying the defect amount of one or more materials in the second group that require one or more next-level materials in the fourth group as irreplaceable materials by the sum of the unit consumption values ​​of the corresponding next-level materials in the fourth group for manufacturing one or more corresponding materials in the second group that have defects, to obtain the maximum consumption of one or more next-level materials in the fourth group relative to one or more materials in the second group that have defects.

[0213] In an exemplary embodiment, when the remaining amount of one or more next-level materials in the fourth group is less than 0, it is determined that there is a shortage of one or more next-level materials in the fourth group.

[0214] In an exemplary embodiment, the method may further include:

[0215] When it is determined that there is a shortage of one or more next-level materials in the fourth group, the shortage amount of one or more next-level materials in the fourth group is obtained based on the remaining amount of one or more next-level materials in the fourth group, and the shortage amount and shortage status of one or more next-level materials in the fourth group are displayed through the first output interface.

[0216] When it is determined that there is no shortage of one or more next-level materials in the fourth group and the remaining quantity is 0, the remaining quantity and material status of one or more next-level materials in the fourth group are displayed through the first output interface (the material status may include the status that the material just meets the production requirements).

[0217] When it is determined that one or more next-level materials in the fourth group have no defects and the remaining quantity is greater than 0, based on the substitution relationship information between the next-level materials, it is determined whether one or more next-level materials in the fourth group are substitutable relative to at least one of the one or more materials in the first group that have defects; when it is determined that one or more next-level materials in the fourth group are not substitutable relative to one or more materials in the first group that have defects, it is determined that one or more next-level materials in the fourth group are stagnant, and the stagnant status and remaining quantity of one or more next-level materials in the fourth group are displayed through the first output interface.

[0218] In an exemplary embodiment, calculating the maximum consumption of multiple next-level materials relative to at least one of the materials with defects in one or more of the materials may include: using a third linear programming model to calculate the maximum consumption of one or more semi-finished components in the third group relative to one or more materials with defects in the second group.

[0219] Step 244, which determines whether there is a shortage of multiple lower-level materials based on the maximum consumption and available inventory of the corresponding materials, may include: subtracting the maximum consumption of one or more lower-level materials in the third group from the available inventory of one or more lower-level materials in the third group to obtain the remaining quantity of one or more lower-level materials in the third group, and determining whether there is a shortage of one or more lower-level materials in the third group based on the remaining quantity of one or more lower-level materials in the third group.

[0220] In an exemplary embodiment, the method may further include:

[0221] When it is determined that there is a shortage of one or more next-level materials in the third group, the shortage amount of one or more next-level materials in the third group is obtained based on the remaining amount of one or more next-level materials in the third group, and the shortage amount and shortage status of one or more next-level materials in the third group are displayed through the first output interface.

[0222] When it is determined that there are no defects in one or more next-level materials in the third group and the remaining quantity is 0, the remaining quantity and material status of one or more next-level materials in the third group are displayed through the first output interface.

[0223] When it is determined that one or more next-level materials in the third group have no defects and the remaining quantity is greater than 0, based on the substitution relationship information between the next-level materials, it is determined whether one or more next-level materials in the third group are substituteable materials relative to at least one of the one or more materials in the first group that have defects; when it is determined that one or more materials in the third group are not substituteable materials relative to one or more materials in the first group that have defects, it is determined that one or more next-level materials in the third group are stagnant, and the stagnant status and remaining quantity of one or more next-level materials in the third group are displayed through the first output interface.

[0224] In an exemplary embodiment, when it is determined that one or more lower-level materials in the third group are in short supply, after obtaining the shortage amount of one or more lower-level materials in the third group based on the remaining quantity of the materials in the third group, the process may further include: obtaining configuration parameters; reallocating the shortage amount of the missing materials in the corresponding material groups of the third group with shortages according to the configuration parameters; and updating the shortage amount of the corresponding materials in the third group using the reallocated shortage amount. In an exemplary embodiment, the configuration parameters may include, but are not limited to, material priorities, and can be set according to actual business needs. For example, the shortage amount can be allocated according to the size of the shared quantity of substitute materials or the probability of using substitute materials. In an exemplary embodiment, obtaining the configuration parameters may include: receiving configuration parameter data input by the user through a first input interface; reallocating the shortage amount of the missing materials in the corresponding material groups of the third group with shortages according to the configuration parameter data input by the user, which allows for more flexible material management and minimizes material stagnation and shortages.

[0225] In an exemplary implementation, the third objective function of the third linear programming model is expressed as:

[0226]

[0227] Where, x i This represents the available quantity of the corresponding material in the second group that is lacking in the preparation of the next-level material in the third group; d i N represents the unit consumption value of the corresponding next-level material in the third group relative to one or more corresponding materials in the second group that have defects; N is a positive integer, N≥1.

[0228] In an exemplary implementation, the third objective function is constrained by a first constraint function, which is expressed as:

[0229]

[0230] Among them, Q l This represents the defect amount of the l-th material in the second group that has a defect; (Q) l G j Let x represent a set of variables (which can be a variable set) of the next-level materials in the j-th group relative to the l-th material with a defect. Multiple next-level materials in the j-th group can substitute for each other when producing the l-th material with a defect; 0 ≤ x i ≤Q l ; 1≤j≤J, where J represents the total number of groups of next-level materials that can be substituted for each other when producing the l-th material with a defect.

[0231] In an exemplary embodiment, the third objective function is constrained by a second constraint function, which is expressed as:

[0232]

[0233] Among them, C m X represents the available inventory of the m-th sub-level material in the third group; m A set of variables (which can be a set of variables) representing the m-th next-level material; 1≤m≤M, where M represents the total number of next-level material types in the third group.

[0234] In an exemplary embodiment, the data for multiple materials may include information on the substitution relationships between the multiple materials and the demand for one or more product components;

[0235] Before obtaining data on multiple next-level materials of one or more materials that have defects in manufacturing one or more product components in step 242, the method may further include: identifying one or more materials in a first group from the multiple materials based on substitution relationship information between the multiple materials, wherein one or more materials in the first group are substitute materials relative to at least one product component in one or more product components;

[0236] Step 23, which calculates the maximum consumption of multiple materials relative to at least one of the one or more product components, may include: calculating the maximum consumption of one or more materials in the first group relative to one or more product components based on data of one or more materials in the first group;

[0237] Step 24, which determines whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials of multiple materials and the available inventory of the corresponding materials of multiple materials, may include: obtaining the available quantity of one or more substitute material groups in the first group relative to one or more product components when the consumption of one or more materials in the first group relative to one or more product components is the maximum consumption; and determining whether there is a shortage of one or more substitute material groups in the first group relative to the corresponding product components based on the available quantity of one or more substitute material groups in the first group relative to one or more product components and the demand of one or more product components.

[0238] In an exemplary embodiment, when it is determined in step 24 that there is a defect in one or more materials used to manufacture one or more product components, determining whether there is a next-level material for the defective material may include: when it is determined that there is a defect in one or more alternative material groups in the first group relative to the corresponding product component, determining whether there is a next-level material for the material group in the first group that has a defect.

[0239] In step 242, when it is determined that there are next-level materials for the defective material, data of multiple next-level materials for the one or more defective materials used to manufacture one or more product components can be obtained. This may include: when it is determined that there are next-level materials for the defective material group in the first group, material data of one or more next-level materials for the one or more defective material groups in the first group can be obtained.

[0240] Step 243, which calculates the maximum consumption of multiple next-level materials relative to at least one of the materials with defects, may include: taking multiple next-level materials of the one or more material groups with defects in the first group as one or more next-level materials in the fifth group, and calculating the maximum consumption of the product components corresponding to the one or more next-level materials in the fifth group relative to the one or more material groups with defects in the first group based on the material data of the one or more next-level materials in the fifth group.

[0241] Step 244, which determines whether there is a shortage of multiple next-level materials based on the maximum consumption and available inventory of the corresponding materials, may include: calculating the remaining quantity of one or more next-level materials in the fifth group based on the available inventory of one or more next-level materials in the fifth group and the maximum consumption of the corresponding product components of one or more next-level materials in the fifth group relative to the one or more next-level material groups in the first group that have shortages; and determining whether there is a shortage of one or more next-level materials in the fifth group based on the remaining quantity of one or more next-level materials in the fifth group.

[0242] In an exemplary embodiment, when it is determined that there is a shortage of one or more substitute material groups in the first group relative to the corresponding product component, it may further include: calculating the shortage amount of one or more substitute material groups in the first group relative to the corresponding product component based on the available quantity of one or more substitute material groups in the first group relative to the corresponding product component and the demand amount of the material in the first group that is in short supply.

[0243] When determining that one or more of the next-level materials in the fifth group have defects, it may also include:

[0244] Step H1: Calculate the sixth defect value based on the available quantity of the corresponding material in the first group that has a defect, which is prepared from one or more next-level materials in the fifth group, and the defect amount of the corresponding material group in the first group that has a defect. Update the defect amount of the corresponding material group in the first group that has a defect using the sixth defect value.

[0245] Step H2: Obtain the configuration parameters, reallocate the shortage amount of the missing materials in the corresponding material groups in the first group according to the configuration parameters, update the shortage amount of the corresponding materials in the first group using the allocated shortage amount, and display the shortage amount and shortage status of the corresponding materials in the first group through the first output interface.

[0246] In an exemplary embodiment, the method may further include:

[0247] When it is determined that there is a shortage of one or more next-level materials in the fifth group, the shortage amount of one or more next-level materials in the fifth group is obtained based on the remaining amount of one or more next-level materials in the fifth group, and the shortage amount and shortage status of one or more next-level materials in the fifth group are displayed through the first output interface.

[0248] When it is determined that there are no defects in one or more next-level materials in the fifth group and the remaining quantity is greater than 0, the remaining quantity and stagnation status of one or more next-level materials in the fifth group are output through the first display interface.

[0249] When it is determined that there are no defects in one or more next-level materials in the fifth group and the remaining quantity is equal to 0, the remaining quantity and material status of one or more next-level materials in the fifth group are output through the first display interface.

[0250] In an exemplary embodiment, the method may further include:

[0251] When it is determined that one or more next-level materials in the fifth group have a shortage, the configuration parameters of the next-level materials are obtained. Based on the configuration parameters of the next-level materials, the shortage amount of the missing materials in the corresponding next-level material group in the fifth group is reallocated. The shortage amount of the corresponding next-level materials in the fifth group is updated with the reallocated shortage amount. The updated shortage amount and shortage status of the corresponding next-level materials in the fifth group are displayed through the first output interface.

[0252] In an exemplary embodiment, the method may further include: when it is determined that one or more next-level materials in the fifth group have a shortage, obtaining the configuration parameters of the next-level materials, reallocating the shortage amount of the corresponding next-level materials in the fifth group that have a shortage according to the configuration parameters of the next-level materials, and updating the shortage amount of the corresponding next-level materials in the fifth group with the reallocated shortage amount.

[0253] In an exemplary embodiment, the method may further include: when it is determined that there is no next-level material for the material with a defect, displaying the defect status of the material with a defect through a first output interface (or displaying the defect amount of the material with a defect, or displaying the defect status and defect amount of the material with a defect).

[0254] When it is determined that there is no shortage of one or more materials used to manufacture one or more product components, the material information of one or more materials used to manufacture one or more product components is displayed through the first output interface (the material information may include at least one of the remaining quantity and stagnant status).

[0255] In an exemplary embodiment, the method may further include: when it is determined that one or more materials with shortages are stagnant or in short supply based on the maximum consumption and available inventory of the corresponding materials of multiple next-level materials, adjusting the demand for one or more product components to minimize the stagnant or in short supply of the next-level materials; and producing one or more product components based on the adjusted demand for one or more product components.

[0256] In an exemplary embodiment, the method may further include: generating one or more user interfaces;

[0257] One or more user interfaces include a first output interface, which is further configured to display the material status of the corresponding material in at least one of the first to fifth groups.

[0258] In an exemplary embodiment, one or more user interfaces may further include a first input interface configured to receive one or more user inputs for querying a database; the database stores data for multiple materials.

[0259] The computer-implemented method further includes: receiving a user selection of one or more conditions from a first input interface, the user selection being used to select a material state related to one or more conditions; and in response to the user selection, querying a database to determine one or more material states in the database related to one or more conditions.

[0260] One or more conditions include at least one of the following: the stagnation state of stagnant materials and the shortage state of defective materials;

[0261] One or more user interfaces also include a second output interface configured to display one or more stagnant or missing materials as a result of querying a database.

[0262] In an exemplary embodiment, one or more user interfaces may further include a second input interface configured to receive one or more user inputs for adjusting the priority of corresponding materials in the first group;

[0263] The computer-implemented method also includes: based on the adjusted priority of the corresponding materials in the first group, re-determining whether the corresponding materials in the first group are stagnant or in short supply.

[0264] In an exemplary embodiment, one or more user interfaces may further include a third input interface configured to receive one or more user inputs for adjusting one or more product components.

[0265] The computer-implemented method further includes: calculating the adjusted maximum consumption of the corresponding materials in the first group based on the adjusted demand for one or more product components;

[0266] Compare the adjusted maximum consumption of the corresponding material in the first group with the available inventory of the corresponding material in the first group;

[0267] Reassess whether there are any stagnation or shortages in the corresponding materials in the first group.

[0268] In an exemplary embodiment, the method may further include:

[0269] The system receives user input commands to query material status via the first input interface.

[0270] In response to a material status query command, retrieve from the database at least one of the following: remaining quantity, stagnation status, shortage status, and shortage quantity for multiple materials used to manufacture one or more product components and multiple next-level materials of the multiple materials.

[0271] In an exemplary embodiment, the material status query instruction is to query the current material information of the corresponding material. For example, the current material can be at least one material in at least one of the first to fifth groups mentioned above, and the current material information can be at least one of the remaining quantity or shortage quantity, stagnation or shortage status of the queried material.

[0272] In an exemplary embodiment, the aforementioned material query instruction can be understood as querying the material status after producing the corresponding product components. Upon receiving the user's input material query instruction, the processor can perform data processing based on the materials used to prepare the product components and the next-level materials to obtain the stagnation or shortage status and quantity of the corresponding materials. The aforementioned material status query instruction can be understood as querying the material information (such as stagnation or shortage status and quantity) of the materials used to prepare one or more product components and the next-level materials. The queried material information can be the stagnation or shortage status and quantity of the corresponding materials obtained after the processor responds to the aforementioned material query instruction (without needing to process the material data again, simply querying the already processed material data can improve query efficiency), or it can be material-related information before responding to the aforementioned material query instruction (simply displaying the corresponding material information without complex data processing can meet the user's need to simply understand the relevant material information).

[0273] This disclosure also provides a computer-implemented method, which may include:

[0274] Obtain data on multiple next-level materials of one or more materials for manufacturing one or more product components that have defects; the data on multiple next-level materials of one or more materials with defects includes the available inventory of multiple next-level materials;

[0275] Calculate the maximum consumption of multiple next-level materials relative to at least one of one or more materials with defects;

[0276] Determine whether one or more materials with defects exist based on the maximum consumption and available inventory of the corresponding materials at multiple next-level materials.

[0277] The computer-implemented method provided in this disclosure acquires data on multiple lower-level materials of one or more materials that are deficient in the manufacture of one or more product components. It calculates the maximum consumption of these multiple lower-level materials relative to at least one of the deficient materials. Based on the maximum consumption of the corresponding materials of the multiple lower-level materials and the available inventory, it determines whether the deficient materials are indeed deficient. During the production of one or more product components, when a material deficiency exists, the method consumes the lower-level materials of the deficient material to replenish the deficient material. After replenishment, it determines whether the deficient material is still deficient. On the one hand, this method maximizes the consumption of lower-level materials, avoiding stagnation of lower-level materials. On the other hand, it allows for timely replenishment of deficient materials, largely solving the problem of material stagnation or deficiency in the material management process.

[0278] In an exemplary embodiment, the product component can be any product manufactured from multiple materials. Examples of product components may include semiconductor products, electronic products, chemical products, mechanically assembled products, etc. In an exemplary embodiment, the product component is not limited to a finished product, but may include finished or semi-finished products.

[0279] like Figure 2 The flowchart shown is a computer-implemented method provided in an embodiment of this disclosure, which may include steps 11 to 13:

[0280] Step 11: Obtain data for multiple next-level materials of one or more materials that are defective in the manufacture of one or more product components; the data for multiple next-level materials of one or more materials that are defective includes the available inventory of multiple next-level materials;

[0281] Step 12: Calculate the maximum consumption of multiple next-level materials relative to at least one of the one or more materials with defects;

[0282] Step 13: Determine whether one or more materials with shortages exist based on the maximum consumption and available inventory of the corresponding materials of multiple next-level materials.

[0283] In an exemplary embodiment, before obtaining data on multiple next-level materials of one or more materials for manufacturing one or more product components that have defects in step 11, the method may further include:

[0284] Step 01: Obtain data on multiple materials used to manufacture one or more product components. The data for these multiple materials includes the available inventory levels of each material.

[0285] Step 02: Calculate the maximum consumption of multiple materials relative to at least one of the one or more product components;

[0286] Step 03: Determine whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials and the available inventory of the corresponding materials.

[0287] In an exemplary embodiment, the computer-implemented method may further include:

[0288] In step 03, when it is determined that there are defects in multiple materials used to manufacture one or more product components, it is determined whether there are any next-level materials for the materials with defects.

[0289] When it is determined that there are sub-materials for materials with defects, data of multiple sub-materials for materials with defects in manufacturing one or more product components are obtained.

[0290] In an exemplary embodiment, the data for multiple materials includes substitution relationship information between the multiple materials;

[0291] Before obtaining data on multiple next-level materials of one or more materials that are defective in manufacturing one or more product components in step 11, the method may further include: identifying one or more materials with defects in a second group from the one or more materials with defects based on substitution relationship information between multiple materials; wherein the one or more materials with defects in the second group are non-substitutable materials relative to at least one of the one or more product components.

[0292] In an exemplary embodiment, the data for multiple next-level materials may further include substitution relationship information between the next-level materials;

[0293] Before calculating the maximum consumption of multiple next-level materials relative to at least one of the one or more materials with defects in step 12, the method may further include: based on the substitution relationship information between the next-level materials, identifying the data of one or more next-level materials in the third group and the data of one or more next-level materials in the fourth group from the data of one or more materials with defects in the second group, wherein the one or more next-level materials in the third group are substitutable relative to at least one of the one or more materials with defects in the second group, and the one or more next-level materials in the fourth group are non-substitutable relative to at least one of the one or more materials with defects in the second group.

[0294] In an exemplary embodiment, step 02, calculating the maximum consumption of multiple materials relative to at least one of the product components, may include: calculating the maximum consumption of one or more materials in the second group relative to one or more product components based on data of one or more materials in the second group; step 03, determining whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials of the multiple materials and the available inventory of the corresponding materials of the multiple materials may include: calculating the remaining quantity of one or more materials in the second group based on the available inventory of one or more materials in the second group and the maximum consumption of one or more materials in the second group, and determining whether there is a shortage of one or more materials in the second group based on the remaining quantity of one or more materials in the second group.

[0295] In an exemplary embodiment, when it is determined that one or more materials in the second group are in short supply, the method may further include: calculating the shortage amount of one or more materials in the second group based on the available inventory of the one or more materials in the second group and the maximum consumption of the one or more materials in the second group.

[0296] In an exemplary embodiment, step 02, calculating the maximum consumption of multiple materials relative to at least one of the one or more product components, may include: calculating the maximum consumption of one or more materials in the second group that have defects relative to at least one of the one or more product components.

[0297] In step 03, determining whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials of multiple materials and the available inventory of the corresponding materials of multiple materials may include: calculating the remaining quantity of one or more materials in the second group that have a shortage based on the available inventory of one or more materials in the second group that have a shortage and the maximum consumption of one or more materials in the second group that have a shortage; and determining whether there is a shortage of one or more materials in the second group based on the remaining quantity of one or more materials in the second group that have a shortage.

[0298] When it is determined that one or more materials in the second group are defective, the method may further include: obtaining the defect amount of one or more materials in the second group based on the remaining amount of the defective materials in the second group.

[0299] In an exemplary embodiment, the data for the next-level material may further include the unit consumption values ​​of multiple next-level materials for manufacturing one or more materials in the second group that have defects;

[0300] In step 12, calculating the maximum consumption of multiple next-level materials relative to at least one of the one or more materials with defects may include: multiplying the defect amount of one or more materials in the second group that require one or more next-level materials in the fourth group as irreplaceable materials by the sum of the unit consumption values ​​of the corresponding next-level materials in the fourth group for manufacturing the corresponding one or more materials in the second group with defects, to obtain the maximum consumption of one or more next-level materials in the fourth group relative to the one or more materials in the second group with defects;

[0301] In step 13, determining whether one or more materials with a shortage exist based on the maximum consumption and available inventory of the corresponding materials of multiple next-level materials may include: subtracting the maximum consumption of one or more next-level materials in the fourth group from the available inventory of one or more next-level materials in the fourth group to obtain the remaining quantity of one or more next-level materials in the fourth group; when the remaining quantity of one or more next-level materials in the fourth group is less than 0, it is determined that one or more materials in the fourth group have a shortage.

[0302] In an exemplary embodiment, when the remaining quantity of one or more next-level materials in the fourth group is greater than 0, the method may further include: determining, based on the substitution relationship information between the next-level materials, whether at least one of the next-level materials in the fourth group that has a deficiency relative to one or more materials in the first group is a substitute material.

[0303] In an exemplary embodiment, when it is determined that one or more next-level materials in the fourth group are not substitutes for one or more materials in the first group that have a deficiency, it is determined that one or more next-level materials in the fourth group are stagnant.

[0304] In an exemplary embodiment, after obtaining the remaining quantity of one or more next-level materials in the fourth group, the method may further include: updating the available inventory of the corresponding next-level material in the fourth group using the remaining quantity of one or more next-level materials in the fourth group.

[0305] In an exemplary embodiment, calculating the maximum consumption of a plurality of next-level materials relative to at least one of one or more materials with defects includes: using a third linear programming model to calculate the maximum consumption of one or more next-level materials in a third group relative to one or more materials with defects in a second group.

[0306] In step 13, determining whether one or more materials with a shortage exist based on the maximum consumption and available inventory of the corresponding materials of multiple next-level materials may include: subtracting the maximum consumption of one or more next-level materials in the third group from the available inventory of one or more next-level materials in the third group to obtain the remaining quantity of one or more next-level materials in the third group; when the remaining quantity of one or more next-level materials in the third group is less than 0, it is determined that one or more next-level materials in the third group have a shortage.

[0307] In an exemplary implementation, the third objective function of the third linear programming model is expressed as:

[0308]

[0309] Where, x i This represents the available quantity of the corresponding material in the second group that is lacking in the preparation of the next-level material in the third group; d i N represents the unit consumption value of the corresponding next-level material in the third group relative to one or more corresponding materials in the second group that have defects; N is a positive integer, N≥1.

[0310] In an exemplary implementation, the third objective function is constrained by a first constraint function, which is expressed as:

[0311]

[0312] Among them, Q l This represents the defect amount of the l-th material in the second group that has a defect; (Q) l G j Let x represent a set of variables (which can be a variable set) of the next-level materials in the j-th group relative to the l-th material with a defect. Multiple next-level materials in the j-th group can substitute for each other when producing the l-th material with a defect; 0 ≤ x i ≤Q l ; 1≤j≤J, where J represents the total number of groups of next-level materials that can be substituted for each other when producing the l-th material with a defect.

[0313] In an exemplary embodiment, the third objective function is constrained by a second constraint function, which is expressed as:

[0314]

[0315] Among them, C m X represents the available inventory of the m-th sub-level material in the third group; m A set of variables (which can be a set of variables) representing the m-th next-level material; 1≤m≤M, where M represents the total number of next-level material types in the third group.

[0316] In an exemplary embodiment, the data for the multiple materials includes information on the substitution relationships between the multiple materials and the demand for one or more product components;

[0317] In step 11, before obtaining data on multiple next-level materials of one or more materials that have defects in manufacturing one or more product components, the process may further include: identifying one or more materials in a first group from the multiple materials based on substitution relationship information between the multiple materials, wherein one or more materials in the first group are substitute materials relative to at least one product component in one or more product components;

[0318] In step 02, calculating the maximum consumption of multiple materials relative to at least one of the one or more product components may include: calculating the maximum consumption of one or more materials in the first group relative to one or more product components based on the data of one or more materials in the first group;

[0319] In step 03, determining whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials of multiple materials and the available inventory of the corresponding materials of multiple materials may include: obtaining the available quantity of one or more substitute material groups in the first group relative to one or more product components when the consumption of one or more materials in the first group relative to one or more product components is the maximum consumption; and determining whether there is a shortage of one or more substitute material groups in the first group relative to the corresponding product components based on the available quantity of one or more substitute material groups in the first group relative to the corresponding product components and the demand of one or more product components in the first group.

[0320] In an exemplary embodiment, when it is determined that there are defects in multiple materials used to manufacture one or more product components, determining whether there are next-level materials for the defective materials may include: when it is determined that there are defects in one or more alternative material groups in the first group relative to the corresponding product component, determining whether there are next-level materials for the material groups in the first group that have defects.

[0321] When it is determined that there are defective materials in the above-mentioned material, the acquisition of data of multiple next-level materials of one or more defective materials in the manufacture of one or more product components may include: when it is determined that there are defective material groups in the first group, the acquisition of material data of one or more next-level materials of one or more defective material groups in the first group.

[0322] In an exemplary embodiment, step 12, calculating the maximum consumption of multiple next-level materials relative to at least one of the one or more materials with defects, may include: taking multiple next-level materials of the one or more material groups with defects in the first group as one or more next-level materials in the fifth group, and calculating the maximum consumption of the product components corresponding to the one or more next-level materials in the fifth group relative to the one or more material groups with defects in the first group based on the material data of the one or more next-level materials in the fifth group.

[0323] In step 13, determining whether one or more materials with shortages exist based on the maximum consumption and available inventory of the corresponding materials of multiple next-level materials may include: calculating the remaining quantity of one or more next-level materials in the fifth group based on the available inventory of one or more next-level materials in the fifth group and the maximum consumption of the product components corresponding to one or more next-level materials in the fifth group relative to the corresponding material groups with shortages in the first group, and determining whether one or more next-level materials in the fifth group have shortages based on the remaining quantity of one or more next-level materials in the fifth group.

[0324] In an exemplary embodiment, when it is determined that there is a shortage of one or more substitute material groups in the first group relative to the corresponding product component, the method may further include: calculating the shortage amount of one or more substitute material groups in the first group relative to the corresponding product component based on the available quantity of one or more substitute material groups in the first group relative to the corresponding product component and the demand amount of the material in the first group that is in short supply.

[0325] When it is determined that there is a shortage in one or more next-level materials in the fifth group, the method may further include: calculating a sixth shortage value based on the available quantity of the corresponding material in the first group that has a shortage and the shortage amount of the corresponding material group in the first group that has a shortage, based on the one or more next-level materials in the fifth group; and updating the shortage amount of the corresponding material group in the first group that has a shortage using the sixth shortage value.

[0326] Obtain the configuration parameters, reallocate the shortage amount of the missing materials in the corresponding material groups in the first group according to the configuration parameters, and update the shortage amount of the corresponding materials in the first group with the reallocated shortage amount.

[0327] In an exemplary embodiment, the step may further include: when it is determined that one or more next-level materials in the fifth group have a shortage, obtaining the configuration parameters of the next-level materials, reallocating the shortage amount of the corresponding next-level materials in the fifth group that have a shortage according to the configuration parameters of the next-level materials, and updating the shortage amount of the corresponding next-level materials in the fifth group with the reallocated shortage amount.

[0328] In an exemplary embodiment, the method may further include: when it is determined that one or more materials with shortages are stagnant or in short supply based on the maximum consumption and available inventory of the corresponding materials of multiple next-level materials, adjusting the demand for one or more product components to minimize the stagnant or in short supply of the next-level materials; and producing one or more product components based on the adjusted demand for one or more product components.

[0329] In an exemplary embodiment, the method may further include: generating one or more user interfaces;

[0330] One or more user interfaces include a first output interface configured to display the material status of a corresponding material in at least one of the first to fifth groups.

[0331] In an exemplary embodiment, one or more user interfaces may further include a first input interface configured to receive one or more user inputs for querying a database; the database stores data for multiple materials.

[0332] The computer-implemented method further includes: receiving a user selection of one or more conditions from a first input interface, the user selection being used to select a material state related to one or more conditions; and in response to the user selection, querying a database to determine one or more material states in the database related to one or more conditions.

[0333] One or more conditions may include at least one of the following: the stagnation state of stagnant materials and the shortage state of defective materials;

[0334] One or more user interfaces may also include a second output interface configured to display one or more stagnant or missing materials as a result of querying a database.

[0335] In an exemplary embodiment, one or more user interfaces may further include a second input interface configured to receive one or more user inputs for adjusting the priority of corresponding materials in the first group;

[0336] The computer-implemented method may further include: redetermining whether the corresponding materials in the first group are stagnant or in short supply based on the adjusted priority of the corresponding materials in the first group.

[0337] In an exemplary embodiment, one or more user interfaces may further include a third input interface configured to receive one or more user inputs for adjusting one or more product components.

[0338] The computer-implemented method may further include: calculating the adjusted maximum consumption of the corresponding materials in the first group based on the adjusted demand for one or more product components; comparing the adjusted maximum consumption of the corresponding materials in the first group with the available inventory of the corresponding materials in the first group; and re-determining whether there is any stagnation or shortage of the corresponding materials in the first group.

[0339] In an exemplary embodiment, the computer-implemented method may further include: when it is determined, based on the maximum consumption and available inventory of the corresponding materials of a plurality of next-level materials, that one or more materials with shortages are stagnant or in short supply, adjusting the demand for one or more product components to minimize the stagnant or in short supply of the next-level materials; and producing one or more product components based on the adjusted demand for the one or more product components. By adjusting the demand for one or more product components, the shortage or stagnant amount of materials used to prepare the product components, as well as the next-level materials of the materials used to prepare the product components, can be reduced.

[0340] In an exemplary embodiment, when the maximum consumption of the corresponding materials of multiple lower-level materials is greater than the available inventory, it is determined that one or more materials with a shortage still have a shortage after using lower-level materials to replenish the shortage; when the maximum consumption of the corresponding materials of multiple lower-level materials is equal to the available inventory, it is determined that one or more materials with a shortage just meet the needs of the product component after using lower-level materials to replenish the shortage; when the maximum consumption of the corresponding materials of multiple lower-level materials is less than the available inventory, it is determined that one or more materials with a shortage are stagnant after using lower-level materials to replenish the shortage.

[0341] The following provides an exemplary description of a computer-implemented method provided in an embodiment of this disclosure. This computer-implemented method can be applied to material management during product manufacturing. In the exemplary embodiment, such as... Figure 3a and Figure 3b As shown, the computer-implemented method provided in this embodiment of the disclosure can be implemented in steps 101 to 125:

[0342] Step 101: Obtain data on multiple materials used to manufacture one or more product components.

[0343] In an exemplary embodiment, data on all materials used to manufacture one or more product components can be input into a storage device before manufacturing (or producing) them. For example, the data can be input to the storage device via a scanning device connected to the storage device, or a user can manually input the data, or a portion of the material data can be manually input by the user and a portion input via a scanning device. In embodiments of this disclosure, the data on multiple materials input to the storage device can be displayed through a graphical user interface.

[0344] In an exemplary embodiment, step 101 may include: the processor obtaining material data for manufacturing one or more product components from a storage device.

[0345] In an exemplary embodiment, the material data for manufacturing one or more product components may include at least two of the following: the product component's product number, the required quantity of the product component, the material number of the materials required to prepare the product component, the material consumption per unit of the product component, the material substitution group, the material priority, and the material inventory. Table 1 below shows data for multiple materials used to manufacture one or more product components:

[0346] Table 1

[0347]

[0348] In an exemplary embodiment, as shown in Table 1, data on multiple materials used to manufacture one or more product components may include: a list of product components represented by product numbers (e.g., PRO-1, PRO-2, PRO-3, PRO-4), and a list of materials required to prepare the product components, represented by material numbers (e.g., A, B, C, D, E, F, G, H). In an exemplary embodiment, the multiple material data may also include the unit consumption of multiple materials relative to one or more product components. The same material may have different unit consumptions relative to different product components. For example, product components with product numbers PRO-1 and PRO-2 may both use material A as a component in production (a component in production can be understood as a material used to prepare the product component). The unit consumption of material A relative to product component PRO-1 is 1, and the unit consumption of material A relative to product component PRO-2 is 2. In an exemplary embodiment, unit consumption may be the ratio of the amount of material (in terms of weight, moles, or number of pieces) required to produce a certain quantity of product components to the quantity of product components.

[0349] In an exemplary embodiment, the multiple material data may further include substitution relationship information between multiple materials, which may include substitution group identifiers and priorities. The unit consumption of materials for product components in Table 1 can be understood as the unit consumption of materials relative to product components.

[0350] In an exemplary embodiment, the same substitution group includes materials that are substituted for each other when producing the same product component, and materials in the same substitution group have the same substitution group identifier (e.g., materials A and B used to produce product component with product number PRO-1 have the same substitution group identifier D1). For example, when preparing (i.e., producing) product component with product number PRO-1, materials A and B are substituted for each other, and materials A and B are in the same substitution group D1. When producing product component with product number PRO-1, materials C and D are substituted for each other, and materials C and D are in the same substitution group D2. Product component with product number PRO-1 can be produced by four different combinations of materials, including (A, D, E), (A, C, E), (B, D, E), and (B, C, E).

[0351] In an exemplary embodiment, the same substitution group may include multiple materials with different priorities. For example, the same substitution group may include a first material and a second material, where the first material may have a higher priority than the second material. When producing the corresponding product, the first material is used preferentially over the second material, which has a lower priority in the same substitution group. For instance, when producing a product component with product number PRO-1, if material A has a priority of 1 and material B has a priority of 2, then material A is used as the first material and material B as the second material, with material A being used preferentially over material B. In Table 1, within the same substitution group, a smaller priority number indicates a higher priority.

[0352] In an exemplary embodiment, as shown in Table 1, the data for multiple materials used to manufacture one or more products may further include the inventory quantity of each of the multiple materials and the demand quantity of multiple product components. The demand for each of the multiple product components may be listed in stages, such as by month, or the demand quantity for each of the multiple product components in the current stage may be listed. For example, the demand quantity for product component with product number PRO-1 is 20,000, the demand quantity for product component with product number PRO-2 is 3,000, the demand quantity for product component with product number PRO-3 is 1,000, and the demand quantity for product component with product number PRO-4 is 1,300; the inventory quantity of material A is 5,000, the inventory quantity of material B is 2,000, the inventory quantity of material C is 3,000, and the inventory quantity of material D is 1,000.

[0353] Step 102: Obtain the substitution relationship information between multiple materials from the data of multiple materials, and identify one or more materials in the first group and one or more materials in the second group from the multiple materials based on the substitution relationship information between multiple materials.

[0354] In an exemplary embodiment, identifying one or more materials in a first group and one or more materials in a second group from multiple materials based on material substitution relationship information may include: obtaining substitution group identifiers for the multiple materials from the material substitution relationship information, and identifying one or more materials in the first group and one or more materials in the second group from the multiple materials based on the substitution group identifiers. In an exemplary embodiment, one or more materials in the first group are substitutable materials relative to at least one of the one or more product components, and one or more materials in the second group are non-substitutable materials relative to at least one of the one or more product components.

[0355] In an exemplary embodiment, materials that can be identified as materials in the first group relative to a specific product are represented by a non-null value in the "Substitute Group" column, meaning the substitute group identifier for the materials in the first group is not null. In an exemplary embodiment, as shown in Table 1, a non-null value for the substitute group identifier can be represented as Dn, where n represents the substitute group number. A non-null value for the substitute group identifier can include substitute group 1 ("D1"), substitute group 2 ("D2"), and substitute group 3 ("D3"). Relative to product PRO-1, substitute group 1 ("D1") includes materials A and B. Relative to product PRO-1, substitute group 2 ("D2") includes materials C and D. Relative to product PRO-4, substitute group 3 ("D3") includes materials C and H. As shown in Table 4, materials A, B, C, D, and H can be identified as materials in the first group, where each of materials A, B, C, D, and H can be substitutable relative to at least one of one or more products. For example, relative to product PRO-1, material A can be replaced by material B; relative to product PRO-2, material C can be replaced by material D; relative to product PRO-4, material C can be replaced by material H.

[0356] In an exemplary embodiment, materials that can be identified as materials in the second group relative to a specific product are indicated by a "null value" in the "Substitute Group" column; that is, the substitute group identifier for materials in the second group is null. As shown in Table 4, materials A, E, F, and G can be identified as materials in the second group, wherein each of materials A, E, F, and G is non-substitutable relative to at least one of one or more products. For example, material A is non-substitutable relative to product PRO-2; material E is non-substitutable relative to product PRO-1; material F is non-substitutable relative to product PRO-2; and material G is non-substitutable relative to product PRO-3.

[0357] In an exemplary embodiment, the same material may be in a first group relative to one product component, but in a second group relative to another product component. Therefore, the first and second groups may have overlap. For example, material A may be in the first group relative to product PRO-1, but in the second group relative to product PRO-2.

[0358] In an exemplary implementation, referring to Table 4, each material in the second group can be assigned a "null" value for the substitute group (i.e., the substitute group identifier of the material in the second group is set to null), and can be assigned "0" for priority.

[0359] Step 103: Extract the material data from the second group of material data from multiple material data for manufacturing one or more product components based on the substitution relationship information between multiple materials.

[0360] In an exemplary embodiment, data for materials in the second group (i.e., data for essential materials or data for irreplaceable materials) are extracted from the data of multiple materials used to manufacture one or more product components in Table 1, as shown in Table 2:

[0361] Table 2

[0362]

[0363] In an exemplary embodiment, extracting data of materials in a second group from data of multiple materials used to manufacture one or more product components based on substitution relationship information between multiple materials includes: extracting data of materials whose field values ​​in the substitution group are null.

[0364] Step 104: Calculate the maximum consumption of one or more materials in the second group relative to one or more product components based on the data of one or more materials in the second group.

[0365] In an exemplary embodiment, step 104 may include: multiplying the demand for one or more product components that require one or more materials in the second group as irreplaceable materials by the sum of the values ​​of the corresponding unit consumption of the corresponding materials in the second group relative to the manufacture of one or more product components, to obtain the maximum consumption of one or more materials in the second group relative to one or more product components.

[0366] In an exemplary embodiment, the maximum consumption of one or more materials in the second group relative to one or more product components can be understood as the theoretical consumption of one or more materials in the second group relative to one or more product components.

[0367] In an exemplary embodiment, the maximum consumption of one of the materials in the second group can be calculated by summing the consumption of that material relative to all product components in the second group. As shown in Table 2, the consumption of material E relative to product PRO-1 is equal to the demand for product PRO-1 (20000) multiplied by the unit consumption of material E relative to PRO-1 (4), resulting in a consumption of material E relative to product PRO-1 of 20000 * 4. Products PRO-2 and PRO-3 in the second group do not consume material E, meaning the consumption of material E relative to products PRO-2 and PRO-3 in the second group is 0. Therefore, the maximum consumption of material E is the sum of the consumption of material E relative to products PRO-1, PRO-2, and PRO-3, which is 20000 * 4 + 0 + 0 = 80000. Following this logic, the maximum consumption of material A in the second group is 0 + 3000 * 2 + 0 = 6000, the maximum consumption of material F in the second group is 0 + 3000 * 2 + 0 = 6000, and the maximum consumption of material G in the second group is 0 + 0 + 1000 * 3 = 3000.

[0368] Step 105: Calculate the remaining quantity of one or more materials in the second group based on the available inventory and maximum consumption of one or more materials in the second group.

[0369] In an exemplary embodiment, step 105 may include: subtracting the maximum consumption of the corresponding material from the available inventory of one or more materials in the second group to obtain the remaining quantity of one or more materials in the second group.

[0370] In an exemplary embodiment, if the remaining quantity of one or more materials in the second group is greater than 0, it means that there is still a surplus of the material after meeting the product production requirements; if the remaining quantity of one or more materials in the second group is equal to 0, it means that the material can just meet the product production requirements; if the remaining quantity of one or more materials in the second group is less than 0, it means that the material cannot meet the product production requirements, that is, the material is in short supply.

[0371] In an exemplary embodiment, the available inventory of one or more materials in the second group can be represented by the inventory of the materials in Table 2. As shown in Table 2, the maximum consumption of material E is 20000*4, and the inventory of material E is 2500. Subtracting the maximum consumption of material E, 20000*4, from the inventory of material E, 2500, yields the remaining quantity of material E in the second group: 2500 - 20000*4 = -77500. Similarly, the remaining quantity of material A is 5000 - 3000*2 = -1000, the remaining quantity of material F is 2000 - 3000*2 = -4000, and the remaining quantity of material G is 2000 - 1000*3 = -1000. The remaining quantities of materials A, E, F, and G in the second group in Table 2 are less than 0, indicating that there is a shortage of materials A, E, F, and G, with shortage amounts of 1000, 77500, 4000, and 1000, respectively.

[0372] Step 106: Determine whether there is a shortage of one or more materials in the second group based on the remaining quantity of one or more materials in the second group. If yes, proceed to step 107; otherwise, update the inventory of the corresponding materials in the second group using the remaining quantity of one or more materials in the second group.

[0373] In an exemplary embodiment, as shown in Table 2, if the remaining amount of materials A, E, F, and G is less than 0, it is determined that there is a shortage of materials A, E, F, and G in the second group.

[0374] In an exemplary embodiment, determining whether there is a shortage of one or more materials in the second group based on the remaining amount of one or more materials in the second group may include: obtaining the amount of one or more materials in the second group relative to one or more product components that can be satisfied when the consumption of one or more materials in the second group relative to one or more product components is the maximum consumption; and determining whether there is a shortage of one or more materials in the second group relative to the corresponding product components based on the amount of one or more materials in the second group relative to one or more product components and the demand of one or more product components.

[0375] Step 107: Determine whether there are any semi-finished components among the materials in the second group that are in short supply. If yes, proceed to step 108. Otherwise, update the inventory of the corresponding materials in the second group that are in short supply using the remaining quantity of the materials in the second group that are in short supply.

[0376] In an exemplary embodiment, the semi-finished component can be a next-level material that has missing materials.

[0377] In an exemplary embodiment, as shown in Table 2, materials A, E, F, and G all have shortages. Among them, materials A and E do not have semi-finished components, while materials F and G do have semi-finished components. Therefore, the shortages of materials A and E are used, with shortage amounts of 1000 and 77500 respectively. The remaining quantity of material A is used to update the inventory of material A by -1000 (after the update, the inventory of material A becomes -1000). The remaining quantity of material E is used to update the inventory of material E by -77500 (after the update, the inventory of material E becomes -77500).

[0378] Step 108: Obtain material data for semi-finished components that have one or more missing materials in the second group.

[0379] In an exemplary embodiment, the material data for the semi-finished components with shortages in the second group may include: the material number of the material with shortages, the material number of the semi-finished component, the unit consumption of the required material relative to the required material (i.e., the unit consumption of the semi-finished component relative to the required material), the substitute group for the semi-finished component, the inventory of the semi-finished component, and the shortage amount of the material (which can be understood as the demand that the semi-finished component needs to meet). The material data for the semi-finished components with shortages in the second group can be shown in Table 3:

[0380] Table 3

[0381]

[0382] As shown in Table 3, semi-finished component PCB-1 and semi-finished component PCB-2 are located in the same substitution group D4. When preparing material F, semi-finished component PCB-1 and semi-finished component PCB-2 can substitute for each other. Semi-finished component PCB-2 and semi-finished component PCB-5 are located in the same substitution group D5. When preparing material G, semi-finished component PCB-2 and semi-finished component PCB-5 can substitute for each other. The substitution group for semi-finished component PCB-10 is empty, and its priority is 0. Therefore, semi-finished component PCB-10 is a necessary material relative to material F. Semi-finished component PCB-2 can be used to prepare materials F and G. Therefore, semi-finished component PCB-2 belongs to the shared material for preparing materials F and G.

[0383] Step 109: Obtain the substitution relationship information between semi-finished components from the material data of one or more materials with defects in the second group, and identify one or more semi-finished components in the third group and one or more semi-finished components in the fourth group from the multiple semi-finished components of one or more materials with defects in the second group based on the substitution relationship information.

[0384] In an exemplary embodiment, determining one or more semi-finished components of a third group and one or more semi-finished components of a fourth group from among the multiple semi-finished components of materials with defects in the second group based on the substitution relationship information of the semi-finished components may include: obtaining substitution group identifiers of the multiple semi-finished components of materials with defects in the second group from the material substitution relationship information between the multiple semi-finished components; and determining one or more semi-finished components of the third group and one or more semi-finished components of the fourth group from among the multiple semi-finished components based on the substitution group identifiers of the multiple semi-finished components. In an exemplary embodiment, one or more semi-finished components in the third group are substitutable materials relative to at least one of the one or more materials with defects in the second group, and one or more semi-finished components in the fourth group are non-substitutable materials relative to at least one of the one or more materials with defects in the second group. As shown in Table 3, the substitution group for semi-finished component PCB-10 is empty, with a priority of 0. During the preparation of material F, semi-finished component PCB-10 is an irreplaceable material and is classified as a semi-finished component in the third group of materials with shortages in the second group. The substitution group for semi-finished components PCB-1 and PCB-2 is D4, and the substitution group for semi-finished components PCB-2 and PCB-5 is D5. Therefore, semi-finished components PCB-1, PCB-2, and PCB-5 are replaceable materials and are classified as semi-finished components in the fourth group of materials with shortages in the second group. For example, semi-finished components PCB-1 and PCB-2 are replaceable materials for preparing material F, and semi-finished components PCB-2 and PCB-5 are replaceable materials for preparing material G.

[0385] Step 110: Based on the substitution relationship information between multiple semi-finished components of materials with defects in the second group, obtain the material data of one or more semi-finished components of the fourth group from the material data of one or more semi-finished components of materials with defects in the second group, and calculate the maximum consumption of one or more semi-finished components of the fourth group relative to one or more materials with defects in the second group based on the material data of one or more semi-finished components of the fourth group.

[0386] In an exemplary embodiment, calculating the maximum consumption of one or more semi-finished components in the fourth group relative to one or more materials in the second group that have defects based on the material data of one or more semi-finished components in the fourth group may include: multiplying the defect amount of one or more materials in the second group that require one or more semi-finished components in the fourth group as irreplaceable materials by the sum of the unit consumption values ​​of the corresponding semi-finished components in the fourth group for manufacturing one or more corresponding materials in the second group that have defects, to obtain the maximum consumption of one or more product components in the fourth group relative to one or more materials in the second group that have defects.

[0387] As shown in Table 3, data on the semi-finished component PCB-10 in the second group with defects is obtained from the material data of multiple semi-finished components in the second group. This includes the defect quantity of material F in the second group that requires semi-finished component PCB-10 as an irreplaceable material, the unit consumption of semi-finished component PCB-10 relative to material F in the second group, and the inventory of semi-finished component PCB-10. Multiplying the defect quantity of material F in the second group (4000) which requires semi-finished component PCB-10 as an irreplaceable material by the unit consumption value of semi-finished component PCB-10 relative to material F in the second group (1), we obtain the consumption quantity of semi-finished component PCB-10 relative to material F in the second group as 4000. Since material F in Table 3 does not share semi-finished component PCB-10 with other materials, the maximum consumption quantity of semi-finished component PCB-10 in the second group with defects is 4000.

[0388] Step 111: Subtract the maximum consumption of one or more semi-finished components in the fourth group relative to one or more materials in the second group that have shortages from the inventory of one or more semi-finished components in the fourth group to obtain the remaining quantity of one or more semi-finished components in the fourth group. Update the inventory of one or more semi-finished components in the fourth group using the remaining quantity of one or more semi-finished components in the fourth group.

[0389] In an exemplary embodiment, as shown in Table 3, the remaining quantity of semi-finished component PCB-10 in the fourth group is calculated as -3000 by subtracting the maximum consumption of semi-finished component PCB-10 in the fourth group relative to the material F in the second group that has a shortage from the inventory quantity of 1000 in the fourth group (4000). In this embodiment, if the remaining quantity of semi-finished components in the fourth group is greater than 0, it means that there is still some remaining after the semi-finished components have replenished the material in the second group that has a shortage; if the remaining quantity of semi-finished components in the fourth group is equal to 0, it means that the semi-finished components can just replenish the material in the second group that has a shortage; if the remaining quantity of semi-finished components in the fourth group is less than 0, it means that the semi-finished components just cannot replenish the material in the second group that has a shortage. If the remaining quantity of semi-finished component PCB-10 in the fourth group -3000 is less than 0, it means that there is a shortage of semi-finished component PCB-10, and the shortage is 3000.

[0390] In an exemplary embodiment, one or more materials with shortages in the second group can be converted into the inventory of corresponding semi-finished components in the fourth group. When the inventory of the corresponding semi-finished components in the fourth group is greater than or equal to 0, it means that the semi-finished component has no shortage and can replenish the corresponding materials with shortages in the second group; when the inventory of the corresponding semi-finished components in the fourth group is less than 0, it means that the semi-finished component has a shortage and cannot replenish the corresponding materials with shortages in the second group.

[0391] In an exemplary embodiment, when multiple materials in the second group that are in short supply share a semi-finished component in the fourth group, the remaining quantity of the semi-finished component can be obtained by subtracting the sum of the maximum consumption of the semi-finished component by the materials sharing the semi-finished component from the inventory quantity of the semi-finished component.

[0392] In an exemplary embodiment, step 111 may further include: determining that one or more materials in the fourth group are in short supply when the remaining quantity of one or more next-level materials in the fourth group is less than 0. In an exemplary embodiment, determining that one or more materials in the fourth group are in short supply may further include: displaying the short supply status and amount of one or more materials in the fourth group through a first output interface. In an exemplary embodiment, the short supply amount can be a negative number of the remaining quantity, in which case a positive short supply amount indicates the existence of a short supply; or the short supply amount can be equal to the remaining quantity, in which case a negative short supply amount indicates the existence of a short supply.

[0393] In an exemplary embodiment, step 111 may further include: when the remaining quantity of one or more next-level materials in the fourth group is greater than 0, determining, based on the substitution relationship information between the next-level materials, whether at least one of the one or more next-level materials in the fourth group that has a deficiency relative to one or more materials in the first group is a substitutable material; when it is determined that the one or more next-level materials in the fourth group that has a deficiency relative to one or more materials in the first group are not substitutable materials, determining that the one or more next-level materials in the fourth group are stagnant. In an exemplary embodiment, determining that the one or more next-level materials in the fourth group are stagnant may further include: displaying the stagnant status and remaining quantity of the one or more next-level materials in the fourth group through a first output interface.

[0394] Step 112: Based on the substitution relationship information between multiple semi-finished components of one or more materials in the third group that have defects, obtain the material data of one or more semi-finished components in the third group from the material data of the semi-finished components of the materials in the second group that have defects. Calculate the maximum consumption of one or more semi-finished components in the third group relative to one or more materials in the second group that have defects based on the material data of one or more semi-finished components in the third group.

[0395] In an exemplary embodiment, calculating the maximum consumption of one or more semi-finished components in the third group relative to one or more materials in the second group that have defects based on the material data of one or more semi-finished components in the third group may include: using a third linear programming model to calculate the maximum consumption of one or more semi-finished components in the third group relative to one or more materials in the second group that have defects.

[0396] In an exemplary implementation, the third objective function of the third linear programming model is expressed as:

[0397]

[0398] Where, x i This represents the amount of the corresponding material in the second group that is in short supply, which can be produced using the corresponding semi-finished components in the third group (i.e., the amount of the corresponding material in the second group that is in short supply that can be prepared using one or more semi-finished components in the third group); d i This represents the unit consumption value of the corresponding semi-finished component in the third group relative to one or more corresponding materials in the second group that have defects; N is a positive integer representing the total number of corresponding semi-finished components in the third group, N≥1.

[0399] In an exemplary embodiment, the third objective function is used to calculate the maximum total consumption of one or more semi-finished components in the third group. As shown in Table 3, the available quantities of materials for preparing the corresponding materials in the second group that have defects from one or more semi-finished components in the third group are set as follows: the available quantity of material F for preparing semi-finished component PCB-1 is set to x1, the available quantity of material F for preparing semi-finished component PCB-2 is set to x2, the available quantity of material G for preparing semi-finished component PCB-2 is set to x3, and the available quantity of material G for preparing semi-finished component PCB-5 is set to x4; the unit consumption of semi-finished component PCB-1 relative to material F is 2, and the unit consumption of semi-finished component PCB-2 relative to material F is... The unit consumption of semi-finished component PCB-2 relative to material G is 1, and the unit consumption of semi-finished component PCB-5 relative to material G is 1. Using a linear programming model, the maximum consumption of one or more semi-finished components in the third group is calculated as follows: the maximum consumption of semi-finished component PCB-1 relative to material F is 2*x1, the maximum consumption of semi-finished component PCB-2 relative to material F is 2*x2, the maximum consumption of semi-finished component PCB-2 relative to material G is 1*x3, and the maximum consumption of semi-finished component PCB-5 relative to material G is 1*x4. The total maximum consumption of one or more semi-finished components in the third group is: Max3 = 2x1 + 2x2 + x3 + x4.

[0400] In an exemplary implementation, the third objective function is constrained by a first constraint function, which is expressed as:

[0401]

[0402] Among them, Q l This represents the shortage quantity (i.e., demand) of the l-th material in the second group that has a shortage; (Q) l G j Let x represent a set of variables (which can be a variable set) of the j-th group of semi-finished components relative to the l-th defective material. Multiple semi-finished components in the j-th group can be substituted for each other when producing the l-th defective material; 0 ≤ x i ≤Q l ; 1≤j≤J, where J represents the total number of groups of semi-finished components that can be substituted for each other when producing the l-th material with defects.

[0403] In an exemplary embodiment, the first constraint function of the third objective function can be understood as a constraint on the shortage amount of the corresponding materials in the second group that have shortages (i.e., the demand amount of the corresponding materials in the second group that have shortages). According to Table 3, materials F and G have shortages (i.e., the value of l is 2). The shortage amount Q1 of material F is 4000, and the shortage amount Q2 of material G is 1000. The total number J of groups of semi-finished components that can be substituted for each other when preparing material F is 1 (this group of semi-finished components includes: semi-finished component PCB-1 and semi-finished component PCB-2). The total number J of groups of two semi-finished components that can be substituted for each other when preparing material G is 1 (this group of semi-finished components includes: semi-finished component PCB-2 and semi-finished component PCB-5). The constraint on the shortage amount of the corresponding materials in the second group that have shortages is as follows:

[0404] The constraint for material F in the second group that has defects is: x1+x2≤4000;

[0405] The constraint for material G in the second group that has defects is: x3+x4≤1000.

[0406] In an exemplary embodiment, the third objective function may also be subject to a second constraint function, which is expressed as:

[0407]

[0408] Among them, C m X represents the available inventory of the m-th type of semi-finished component in the third group; m Let M be a set of variables (which can be a set of variables) representing the m-th semi-finished component; 1≤m≤M, where M represents the total number of types of semi-finished components in the third group.

[0409] In an exemplary embodiment, the second constraint function of the third objective function can be understood as a constraint on the inventory quantity of the corresponding semi-finished components in the third group. As shown in Table 3, the total number M of semi-finished component types in the third group is 3 (including: semi-finished component PCB-1, semi-finished component PCB-2, and semi-finished component PCB-5). The available inventory quantity of semi-finished component PCB-1 is 1000, the available inventory quantity of semi-finished component PCB-2 is 1000, and the available inventory quantity of semi-finished component PCB-5 is 300. The constraints on the inventory quantity of the corresponding semi-finished components in the third group are as follows:

[0410] The inventory constraint for semi-finished component PCB-1 is: 2x1≤1000;

[0411] The inventory constraint for semi-finished component PCB-2 is: 2x2+x3≤1000;

[0412] The inventory constraint for semi-finished component PCB-5 is: x4≤300.

[0413] In an exemplary embodiment, the above-mentioned use of a third linear programming model to calculate the maximum consumption of one or more semi-finished components in the third group relative to one or more materials in the second group that have shortages is used. Under the premise of satisfying the first constraint function and the second constraint function, the values ​​of x1, x2, x3, and x4 that can maximize the sum of the maximum consumption of one or more semi-finished components in the third group (Max3) can be obtained. This can minimize the inventory of semi-finished components and replenish the shortage of materials in the second group as much as possible, thereby reducing the stagnation of semi-finished components and reducing the shortage of materials in the second group.

[0414] Step 113: Based on the inventory of one or more semi-finished components in the third group and the maximum consumption of one or more semi-finished components in the third group relative to the corresponding materials in one or more of the second group that have shortages, calculate the remaining quantity of one or more semi-finished components in the third group, and update the inventory of one or more semi-finished components in the third group using the remaining quantity of one or more semi-finished components in the third group.

[0415] In an exemplary embodiment, step 113, calculating the remaining quantity of one or more semi-finished components in the third group based on the inventory quantity of one or more semi-finished components in the third group and the maximum consumption quantity of one or more semi-finished components in the third group relative to the corresponding materials in the second group that have defects, may include: using the inventory quantity of one or more semi-finished components in the third group, subtracting the maximum consumption quantity of one or more semi-finished components in the third group relative to the corresponding materials in the second group that have defects, to obtain the remaining quantity of one or more semi-finished components in the third group.

[0416] In an exemplary embodiment, step 113 may further include: determining whether the remaining quantity of one or more semi-finished components in the third group is greater than or equal to 0; if so, determining that one or more semi-finished components in the third group can make up for the shortage of one or more materials in the second group that have a shortage; otherwise, determining that one or more semi-finished components in the third group cannot make up for the shortage of one or more materials in the second group that have a shortage.

[0417] Taking the consumption of semi-finished component PCB-1 and semi-finished component PCB-2 based on the shortage of material F in Table 3 as an example: Semi-finished component PCB-1 has a priority of 1, and semi-finished component PCB-2 has a priority of 2. Therefore, semi-finished component PCB-1 is used first to replenish the shortage of material F. The remaining quantity of semi-finished component PCB-1 is calculated by subtracting the maximum consumption of material F (2x1) from the inventory quantity of semi-finished component PCB-1 (1000). When 1000-2x1 is greater than or equal to 0, it means that semi-finished component PCB-1 can replenish the shortage of material F, and in this case, it is not necessary to consume semi-finished component PCB-2. When 1000-2x1 is less than 0, it means that semi-finished component PCB-1 cannot replenish the shortage of material F, and in this case, semi-finished component PCB-2 is used to replenish the shortage of material F. The available quantity (x2) of material F prepared by B-2 is equal to the shortage quantity (4000) of material F minus the available quantity (x1) of material F prepared by semi-finished component PCB-1. Using the inventory quantity of semi-finished component PCB-2 of 1000 minus the maximum consumption quantity 2x2 of material with shortage relative to material F, the remaining quantity of semi-finished component PCB-2 is 1000-2x2=1000-2(4000-x1). If the remaining quantity of semi-finished component PCB-2 1000-2x2 is greater than or equal to 0, it means that semi-finished component PCB-2 and semi-finished component PCB-1 can make up for the shortage quantity of material F, and there is no shortage of semi-finished components in the third group of material F. If the remaining quantity of semi-finished component PCB-2 1000-2x2 is less than 0, it means that semi-finished component PCB-2 and semi-finished component PCB-1 cannot make up for the shortage quantity of material F, and there is a shortage of semi-finished components in the third group of material F.

[0418] In an exemplary embodiment, the remaining quantity of one or more semi-finished components in the third group is used to update the inventory quantity of one or more semi-finished components in the third group. The updated inventory quantity can be used to determine whether there is a defect in the corresponding semi-finished component in the third group when preparing the corresponding material in the second group that has a defect. If the updated inventory quantity is greater than or equal to 0, it indicates that there is no defect in the corresponding semi-finished component in the third group. If the updated inventory quantity is less than 0, it indicates that there is a defect in the corresponding semi-finished component in the third group. When there is a defect, the inventory quantity is negative, and the absolute value of the inventory quantity is the defect amount.

[0419] In an exemplary embodiment, taking the consumption of semi-finished component PCB-1 during the preparation of material F as an example: After using semi-finished component PCB-1 to replenish the shortage of material F, the remaining quantity of semi-finished component PCB-1 is 1000-2x1. The inventory of semi-finished component PCB-1 can be updated from 1000 to 1000-2x1 to avoid the inventory of semi-finished component (PCB-1) being higher than the actual inventory, thereby effectively managing the material of semi-finished component.

[0420] Step 114: Calculate the third defect value based on the available quantity of the corresponding material in the second group that has defects, prepared from one or more semi-finished components in the third group, and the defect amount of the corresponding material in the second group that has defects. Calculate the fourth defect value based on the available quantity of the corresponding material in the second group that has defects, prepared from one or more semi-finished components in the fourth group, and the defect amount of the corresponding material in the second group that has defects. Determine the second defect value of the corresponding material in the second group based on the third and fourth defect values. Update the defect amount of the corresponding material in the second group that has defects using the second defect value.

[0421] In an exemplary embodiment, calculating a third defect value based on the available quantity of the corresponding material in the second group that has defects, prepared from one or more semi-finished components in the third group, and the defect amount of the corresponding material in the second group that has defects, and calculating a fourth defect value based on the available quantity of the corresponding material in the second group that has defects, prepared from one or more semi-finished components in the fourth group, and the defect amount of the corresponding material in the second group that has defects, may include: subtracting the available quantity of the corresponding material in the second group that has defects from the defect amount of the corresponding material in the second group prepared from one or more semi-finished components in the third group to obtain the third defect value of the corresponding material in the second group; and subtracting the available quantity of the corresponding material in the second group that has defects from one or more semi-finished components in the fourth group to obtain the fourth defect value of the corresponding material in the second group.

[0422] Specifically, the amount of material that can be prepared from one or more semi-finished components in the third group to meet the corresponding material shortage in the second group is equal to the integer value obtained by rounding down the ratio between the inventory of one or more semi-finished components in the third group and the unit consumption of one or more semi-finished components in the third and fourth groups relative to the corresponding material shortage in the second group; the amount of material that can be prepared from one or more semi-finished components in the fourth group to meet the corresponding material shortage in the second group is equal to the integer value obtained by rounding down the ratio between the inventory of one or more semi-finished components in the fourth group and the unit consumption of one or more semi-finished components in the fourth group relative to the corresponding material shortage in the second group.

[0423] In an exemplary embodiment, determining the second defect value of the corresponding material in the second group based on the third defect value and the fourth defect value may include: when the third defect value and the fourth defect value of the same material with a defect in the second group are the same, the third defect value and the fourth defect value are used as the second defect value; when the third defect value and the fourth defect value of the same material with a defect in the second group are not the same, the larger of the third defect value and the fourth defect value is used as the second defect value. As shown in Table 3, taking the supplementary material F using semi-finished component PCB-10 from the fourth group, semi-finished component PCB-1 from the third group, and semi-finished component PCB-2 from the third group as an example: The available quantity of material F prepared by semi-finished component PCB-10 is equal to the integer value obtained by rounding down the ratio between the inventory of semi-finished component PCB-10 (1000) and the unit consumption value of semi-finished component PCB-10 relative to material F (1). That is, the available quantity of material F prepared by semi-finished component PCB-10 is 1000. The fourth shortage value of material F is 3000, which is obtained by subtracting the available quantity of material F prepared by semi-finished component PCB-10 (1000) from the shortage quantity of material F (4000). The available quantity of material F for preparing semi-finished components PCB-1 and PCB-2 is x1 + x2. Subtracting the available quantity of material F for preparing semi-finished components PCB-1 and PCB-2 from the shortage quantity of material F (1000) yields the third shortage value of material F as 1000 - (x1 + x2). If the third shortage value 1000 - (x1 + x2) equals the fourth shortage value 3000, then the third and fourth shortage values ​​3000 are used as the second shortage value of material F. If the third shortage value 1000 - (x1 + x2) is greater than the fourth shortage value 3000, then the third shortage value 1000 - (x1 + x2) is used as the second shortage value of material F. If the third shortage value 1000 - (x1 + x2) is less than the fourth shortage value 3000, then the fourth shortage value 3000 is used as the second shortage value of material F.

[0424] In an exemplary embodiment, when the fourth defect value is less than or equal to 0, it means that one or more semi-finished components in the fourth group can meet the corresponding materials in the second group that have defects, and therefore one or more semi-finished components in the fourth group do not have defects; when the fourth defect value is greater than 0, it means that one or more semi-finished components in the fourth group cannot meet the corresponding materials in the second group that have defects, and therefore one or more semi-finished components in the fourth group have defects. In an exemplary embodiment, subject to the constraint of the first constraint function, when using semi-finished components from the third group to supplement materials in the second group that are in short supply, the amount of materials that can be prepared by one or more semi-finished components from the third group to supplement the corresponding materials in the second group that are in short supply will not exceed the amount of materials in the second group that are in short supply. For example, when using semi-finished components PCB-1 and PCB-2 to supplement material F, the amount of material F that can be prepared by semi-finished components PCB-1 and PCB-2 to supplement the corresponding materials will not exceed the amount of materials in the second group that are in short supply, x1+x2. Therefore, the third short supply value is usually not less than 0. When the third short supply value is greater than 0, it indicates that one or more semi-finished components in the third group are in short supply. When the third short supply value is equal to 0, it indicates that one or more semi-finished components in the third group are not in short supply.

[0425] In an exemplary embodiment, using the larger of the third and fourth defect values ​​as the second defect value for one or more materials in the second group that have defects can avoid the situation where the smaller value is used as the defect value, and the larger defect value still has a gap, thus failing to meet the actual defect. Step 115: Calculate the defect amount of one or more semi-finished components in the third group based on the inventory of one or more semi-finished components in the third group and the maximum consumption of one or more corresponding semi-finished components in the third group; calculate the defect amount of one or more semi-finished components in the fourth group based on the inventory of one or more semi-finished components in the fourth group and the maximum consumption of one or more corresponding semi-finished components in the fourth group.

[0426] In an exemplary embodiment, the defect amount of one or more materials in the second group that are defective can be converted into the defect amount of one or more semi-finished components in the third and fourth groups and the fourth group.

[0427] In an exemplary embodiment, since one or more semi-finished components in the fourth group are necessary materials for preparing one or more corresponding materials in the second group that are in short supply, and there are no substitute materials, the shortage amount of one or more semi-finished components in the fourth group can be obtained by subtracting the maximum consumption of one or more corresponding semi-finished components in the fourth group from the inventory of one or more semi-finished components in the fourth group.

[0428] In an exemplary embodiment, since one or more semi-finished components in the third group are substitutes for one or more corresponding materials in the second group that are in short supply, the shortage amount in the same substitution group can be set according to configuration parameters. In an exemplary embodiment, the configuration parameters may include one or more of the following: priority, likelihood of use, low cost of semi-finished components, and proportional allocation, to set the shortage amount of semi-finished components, thereby facilitating business strategy adjustments. For example, in the same substitution group, semi-finished components with higher priority (lower priority value) can be used preferentially, or semi-finished components with a higher likelihood of use can be selected preferentially, or semi-finished components with lower preparation costs can be used preferentially, or the shortage amount can be allocated to multiple semi-finished components in the same substitution group according to a ratio.

[0429] Step 116: Extract the data of the materials in the first group from the multiple material data for manufacturing one or more product components based on the substitution relationship information between multiple materials.

[0430] In an exemplary embodiment, data of materials in the first group (i.e., data of replaceable materials) are extracted from the data of multiple materials used to manufacture one or more product components in Table 1, as shown in Table 4:

[0431] Table 4

[0432]

[0433] In an exemplary embodiment, extracting data of materials in a first group from multiple material data for manufacturing one or more product components based on substitution relationship information between multiple materials may include: extracting data of product components whose field values ​​in the substitution group are not null.

[0434] Step 117: Calculate the maximum consumption of one or more materials in the first group relative to one or more product components based on the data of one or more materials in the first group, and obtain the available quantity of one or more substitute material groups in the first group relative to the corresponding product components when the consumption of one or more materials in the first group is the maximum consumption.

[0435] In an exemplary embodiment, step 117 may include: using a first linear programming model to calculate the maximum consumption of one or more materials in the first group relative to one or more product components in the first group and the available quantity of one or more materials in the first group relative to the corresponding product components based on the data of one or more materials in the first group; and calculating the available quantity of one or more alternative material groups in the first group relative to the corresponding product components based on the available quantity of one or more materials in the first group relative to the corresponding product components.

[0436] In an exemplary implementation, the first objective function of the first linear programming model is expressed as:

[0437]

[0438] Among them, y i This represents the quantity of the corresponding product component that can be produced using the corresponding materials in the first group (i.e., the satisfactory quantity of the corresponding product component that can be prepared using one or more materials in the first group); d i This represents the unit consumption value of the corresponding material in the first group relative to the corresponding product component; N is a positive integer representing the total number of corresponding materials in the first group, N≥1.

[0439] In an exemplary embodiment, the first objective function is used to calculate the maximum total consumption of one or more materials in the first group. As shown in Table 4, the available quantities of materials in the first group that produce the corresponding materials in the second group with defects are set as follows: the available quantity of material A to produce product component PRO-1 is set as y1, the available quantity of material B to produce product component PRO-1 is set as y2, the available quantity of material C to produce product component PRO-1 is set as y3, the available quantity of material D to produce product component PRO-1 is set as y4, the available quantity of material C to produce product component PRO-4 is set as y5, and the available quantity of material H to produce product component PRO-4 is set as y6; the unit consumption value of material A relative to product component PRO-1 is 1, the unit consumption value of material B relative to product component PRO-1 is 1, the unit consumption value of material C relative to product component PRO-1 is 2, and the unit consumption value of material D is 2. The unit consumption value of material C relative to product component PRO-1 is 2, the unit consumption value of material C relative to product component PRO-4 is 2, and the unit consumption value of material H relative to product component PRO-4 is 2. Using a linear programming model, the maximum consumption of one or more materials in the first group is calculated as follows: the maximum consumption of material A relative to product component PRO-1 is y1, the maximum consumption of material B relative to product component PRO-1 is y2, the maximum consumption of material C relative to product component PRO-1 is 2*y3, the maximum consumption of material D relative to product component PRO-1 is 2*y4, the maximum consumption of material C relative to product component PRO-4 is 2*y5, and the maximum consumption of material H relative to product component PRO-4 is 2*y6. The total maximum consumption of one or more semi-finished components in the first group is: Max1 = y1 + y2 + 2y3 + 2y4 + 2y5 + 2y6.

[0440] In an exemplary embodiment, the first objective function is constrained by a first constraint function, which is expressed as:

[0441]

[0442] Among them, Q l This represents the demand for the l-th product component in the first group; (Q) l G j ) represents a set of variables (which can be a set of variables) relative to the j-th group of materials in the l-th product component, where multiple materials in the j-th group can be substituted for each other when producing the l-th product component; 0 ≤ y i ≤Q l ; 1≤j≤J, where J represents the total number of groups of materials that can be substituted for each other when producing the l-th product component.

[0443] In an exemplary embodiment, the first constraint function of the first objective function can be understood as a constraint on the demand of the corresponding product components. According to Table 4, the product components to be prepared include product component PRO-1 and product component PRO-4 (i.e., the value of l is 2). The demand Q1 of product component PRO-1 is 20000, and the demand Q2 of product component PRO-4 is 1300. The total number J of material groups that can be substituted for each other when preparing product component PRO-1 is 2 (one material group includes material A and material B, and another material group includes material C and material D). The total number J of material groups that can be substituted for each other when preparing product component PRO-4 is 1 (this group of materials includes material C and material H). The constraint on the demand of the corresponding materials in the first group is as follows:

[0444] The requirements for product component PRO-1 are constrained as follows: y1+y2≤20000; y3+y4≤20000;

[0445] The constraint on product component PRO-4 is: y5+y6≤1300;

[0446] In an exemplary embodiment, the first objective function may also be subject to a second constraint function, which is expressed as:

[0447]

[0448] Among them, C m X represents the available inventory of the m-th product component in the first group; m Let M be a set of variables (which can be a set of variables) representing the m-th product component; 1 ≤ m ≤ M, where M represents the total number of product component types in the first group.

[0449] In an exemplary embodiment, the second constraint function of the first objective function can be understood as a constraint on the inventory quantity of the corresponding materials in the first group. As shown in Table 4, the total number M of material types in the first group is 5 (including: materials A, B, C, D, and H). The available inventory quantity of material A is 5000, the available inventory quantity of material B is 2000, the available inventory quantity of material C is 3000, the available inventory quantity of material D is 1000, and the available inventory quantity of material H is 1000. The constraints on the inventory quantity of the corresponding materials in the first group are as follows:

[0450] The constraint on the inventory level of material A is: 0 ≤ y1 ≤ 5000;

[0451] The constraint on the inventory level of material B is: 0 ≤ y2 ≤ 2000;

[0452] The inventory constraint for material C is: 0 ≤ 2y3 + 2y5 ≤ 1300;

[0453] The inventory constraints for material D are: 0 ≤ 2y4 ≤ 1000;

[0454] The inventory constraints for material H are: 0 ≤ 2y6 ≤ 1000.

[0455] In an exemplary embodiment, the linear programming model is used to calculate the maximum consumption of one or more materials in the first group relative to one or more product components. Under the premise of satisfying the first constraint function and the second constraint function of the first objective function, the values ​​of y1, y2, y3, y4, y5, and y6 that maximize the sum of the maximum consumption of one or more materials in the first group (Max1) can be obtained. This can minimize the inventory of materials and the demand for product components, thereby reducing the stagnation of materials and the shortage of product components.

[0456] In an exemplary implementation, a linear programming model can be used to calculate the maximum consumption of each material in the first group relative to at least one of one or more products. In some embodiments, the linear programming model is an integer linear programming model. In one example, the linear programming model is a pure integer linear programming model, where all variables are integers. In another example, the linear programming model is a mixed integer linear programming model, where some variables are integers and some are non-integers.

[0457] Various suitable methods can be implemented in linear programming models. In one example, branch and bound can be used, based on the principle that the total set of feasible solutions can be divided into smaller subsets. These smaller subsets can then be systematically evaluated until the optimal solution is found. Branch and bound can be implemented in pure integer linear programming models or mixed integer linear programming models. In another example, cutting plane methods can be used, which iteratively point to feasible sets or objective functions using linear inequalities, called cuts. Cutting plane methods can be implemented in pure integer linear programming models or mixed integer linear programming models.

[0458] In an exemplary embodiment, the satisfiability of one or more materials in the first group relative to the corresponding product component, calculated by the linear programming model in step 117, is the satisfiability of preparing the corresponding product component when the one or more materials in the first group satisfy the maximum consumption of the one or more product components. In an exemplary embodiment, calculating the satisfiability of one or more alternative material groups in the first group relative to the corresponding product component based on the satisfiability of one or more materials in the first group relative to the corresponding product component may include: summing the satisfiability of preparing the corresponding product component from multiple materials located in the same alternative group in the first group to obtain the satisfiability of one or more alternative material groups in the first group relative to the corresponding product component.

[0459] As shown in Table 4, during the preparation of product component PRO-1, materials A and B are in the same substitution group. The satisfyable quantity y1 of material A relative to product component PRO-1 is added to the satisfyable quantity y2 of material B relative to product component PRO-1, yielding the satisfyable quantity y1+y2 of materials A and B in the same substitution group relative to product component PRO-1. Similarly, the sum of the satisfyable quantities of materials C and D in the same substitution group relative to product component PRO-1 is y3+y4, and the sum of the satisfyable quantities of materials C and H in the same substitution group relative to product component PRO-4 is y5+y6.

[0460] Step 118: Based on the available quantity of one or more substitute material groups in the first group relative to the corresponding product component and the demand quantity of one or more product components in the first group, determine whether there is a shortage of one or more substitute material groups in the first group relative to the corresponding product component. If yes, proceed to step 119. Otherwise, based on the inventory quantity of one or more materials in the first group and the maximum consumption quantity of one or more materials in the first group relative to one or more product components, calculate the remaining quantity of one or more materials in the first group, and update the inventory quantity of one or more materials in the first group using the remaining quantity of one or more materials in the first group.

[0461] In an exemplary embodiment, step 118, determining whether there is a shortage of one or more substitute material groups in the first group relative to the corresponding product component based on the available quantity of one or more substitute material groups in the first group relative to the corresponding product component and the demand quantity of one or more product components in the first group, may include:

[0462] When the available quantity of one or more substitute material groups in the first group relative to the corresponding product component is greater than the demand of one or more product components in the first group, it is determined that there is no shortage of one or more substitute material groups in the first group relative to the corresponding product component, and there is a surplus of materials in the first group.

[0463] When the available quantity of one or more substitute material groups in the first group relative to the corresponding product component is equal to the demand of one or more product components in the first group, it is determined that there is no shortage of one or more substitute material groups in the first group relative to the corresponding product component, and the materials in the first group can just meet the demand of the corresponding product component.

[0464] When the available quantity of one or more substitute material groups in the first group relative to the corresponding product component is less than the demand quantity of one or more product components in the first group, it is determined that there is a shortage of one or more substitute material groups in the first group relative to the corresponding product component.

[0465] In an exemplary embodiment, step 118, calculating the remaining quantity of one or more materials in the first group based on the inventory quantity of one or more materials in the first group and the maximum consumption quantity of one or more materials in the first group relative to one or more product components, may include: subtracting the maximum consumption quantity of one or more materials in the first group relative to one or more product components in the second group from the inventory quantity of one or more materials in the first group to obtain the remaining quantity of one or more materials in the first group.

[0466] Taking the consumption of materials C and H for preparing product component PRO-4 in Table 4 as an example: Material H has a priority of 1, and material C has a priority of 2. Therefore, material H is used first to prepare product component PRO-4. The remaining quantity of material H is 1000 minus the maximum consumption of material H relative to product component PRO-4, 2y6, to obtain the remaining quantity of material H: 1000 - 2y6. When 1000 - 2y6 is greater than or equal to 0, it means that material H can meet the demand for product component PRO-4, and material C can be used to meet the demand. When 1000 - 2y6 is less than 0, it means that material H cannot meet the demand for product component PRO-4, and material C is used to supplement the demand for product component PRO-4. The available quantity (y5) equals the required quantity of product component PRO-4 (1300) minus the available quantity (y6) of material H used to prepare product component PRO-4. Using the inventory quantity of material C 3000 minus the maximum consumption of material C relative to product component PRO-4 2y5, the remaining quantity of material C is obtained as 3000-2y5=3000-2(1300-y6). If the remaining quantity of material H 3000-2y5 is greater than or equal to 0, it means that material C and material H can meet the required quantity of product component PRO-4, and there is no shortage of materials in the first group for preparing product component PRO-4; if the remaining quantity of material C 3000-2y5 is less than 0, it means that material H and material C cannot meet the required quantity of product component PRO-4, and there is a shortage of materials in the first group for preparing product component PRO-4.

[0467] In an exemplary embodiment, the remaining quantity of one or more materials in the first group is used to update the inventory quantity of one or more materials in the first group. The updated inventory quantity can be used to determine whether there is a shortage of the corresponding materials in the first group when preparing the corresponding product components. If the updated inventory quantity is greater than or equal to 0, it indicates that there is no shortage of the corresponding materials in the first group. If the updated inventory quantity is less than 0, it indicates that there is a shortage of the corresponding materials in the first group. When there is a shortage, the inventory quantity is negative, and the absolute value of the inventory quantity is the shortage amount.

[0468] In an exemplary embodiment, the material H consumed in the preparation of product component PRO-4 is used as an example for illustration: After the product component PRO-4 is prepared using material H, the remaining amount of material H is 1000-2y6. The inventory of material H can be updated from 1000 to 1000-2y6 to avoid the inventory of material (H) being higher than the actual inventory, thereby effectively managing the material.

[0469] Step 119: Determine whether there are any semi-finished components in the material group with shortages in the first group. If yes, proceed to step 120. Otherwise, update the inventory of the corresponding material using the remaining quantity of the material with shortages in the first group. Calculate the shortage quantity of one or more substitute material groups relative to the product component based on the available quantity of one or more substitute material groups relative to the corresponding product component and the demand quantity of one or more product components in the first group.

[0470] In an exemplary embodiment, subject to the constraint function of the second constraint function of the first objective function, the remaining quantity of the material with defects in the first group is a number greater than or equal to 0.

[0471] In an exemplary embodiment, calculating the shortage of one or more alternative material groups relative to the product component based on the available quantity of one or more alternative material groups in the first group relative to the corresponding product component and the demand quantity of one or more product components in the first group may include: subtracting the available quantity of one or more alternative material groups in the first group relative to the corresponding product component from the demand quantity of one or more product components in the first group to obtain the shortage of one or more alternative material groups relative to the product component.

[0472] Step 120: Obtain material data for one or more semi-finished components from one or more material groups with defects in the first group, and use one or more semi-finished components from one or more material groups with defects in the first group as the fifth group of semi-finished components.

[0473] In an exemplary embodiment, the material data of multiple semi-finished components in the material group with shortages in the first group (i.e., the material data of the fifth group of semi-finished components) may include: the product number of the product component, the material number of the material with shortages, the material number of the semi-finished component, the unit consumption of the product component relative to the semi-finished component (i.e., the unit consumption of the semi-finished component relative to the substitute material), the inventory of the semi-finished component, the substitute group of the semi-finished component, and the shortage amount of the product component (which can be understood as the demand of the product component that the semi-finished component needs to meet). The material data of the semi-finished components in the material group with shortages in the first group can be shown in Table 6:

[0474] Table 6

[0475]

[0476] As shown in Table 6, semi-finished components PCB-3 and PCB-4 are located in the same substitution group D6. When preparing material C, semi-finished components PCB-1 and PCB-2 can be substituted for each other. Semi-finished components PCB-6 and PCB-7 are located in the same substitution group D7. When preparing material D, semi-finished components PCB-6 and PCB-7 can be substituted for each other. Material C can be used to prepare product components PRO-1 and PRO-4. Therefore, material C is a common material for preparing product components PRO-1 and PRO-4.

[0477] Step 121: Calculate the maximum consumption of the product components corresponding to one or more semi-finished components in the fifth group relative to one or more material groups in the first group that have defects, based on the material data of one or more semi-finished components in the fifth group.

[0478] In an exemplary embodiment, calculating the maximum consumption of one or more semi-finished components in the fifth group relative to the product components corresponding to one or more material groups with defects in the first group based on the material data of one or more semi-finished components in the fifth group may include: using a fifth linear programming model to calculate the maximum consumption of one or more semi-finished components in the fifth group relative to the product components corresponding to one or more material groups with defects in the first group.

[0479] In an exemplary implementation, the fifth objective function of the fifth linear programming model is expressed as:

[0480]

[0481] Where, p i This represents the quantity of product components corresponding to the defective materials in the first group that can be produced using the corresponding semi-finished components in the fifth group (i.e., the quantity of product components that can be produced from one or more semi-finished components in the fifth group that correspond to the defective materials in the first group); d i The value represents the unit consumption of the corresponding semi-finished component in the fifth group relative to the product component corresponding to one or more defective materials in the first group; N is a positive integer representing the total number of corresponding semi-finished components in the fifth group, N≥1.

[0482] In an exemplary embodiment, the fifth objective function is used to calculate the maximum total consumption of one or more semi-finished components in the fifth group. As shown in Table 6, the available quantities of the product components corresponding to the materials with defects in the first group prepared by one or more semi-finished components in the fifth group are set as follows: the available quantity of product component PRO-1 corresponding to material C with defects in semi-finished component PCB-3 is set as p1; the available quantity of product component PRO-1 corresponding to material C with defects in semi-finished component PCB-4 is set as p2; the available quantity of product component PRO-1 corresponding to material D with defects in semi-finished component PCB-6 is set as p3; and the available quantity of product component PRO-1 corresponding to material D with defects in semi-finished component PCB-7 is set as p3. The available quantity of product component PRO-1 corresponding to material D with defects is set to p4. The available quantity of product component PRO-4 corresponding to material C with defects in semi-finished component PCB-3 is set to p5. The available quantity of product component PRO-4 corresponding to material C with defects in semi-finished component PCB-4 is set to p6. The unit consumption value of semi-finished component PCB-3 relative to product component PRO-1 corresponding to material C with defects is 4. The unit consumption value of semi-finished component PCB-4 relative to product component PRO-1 corresponding to material C with defects is 4. The unit consumption value of semi-finished component PCB-6 relative to product component PRO-1 corresponding to material D with defects is p6. The consumption value is 4. The unit consumption value of semi-finished component PCB-7 relative to product component PRO-1 corresponding to material D with defects is 4. The unit consumption value of semi-finished component PCB-3 relative to product component PRO-4 corresponding to material C with defects is 4. The unit consumption value of semi-finished component PCB-4 relative to product component PRO-4 corresponding to product component PRO-4 with defects is 4. Using a linear programming model, the maximum consumption of one or more semi-finished components in the fifth group is calculated as follows: the maximum consumption of semi-finished component PCB-3 relative to product component PRO-1 corresponding to material C with defects is 4*p1. The maximum consumption of semi-finished component PCB-4 relative to product component PRO-4 corresponding to material C with defects is 4*p1. The maximum consumption of component PRO-1 is 4*p2. The maximum consumption of semi-finished component PCB-6 relative to the product component PRO-1 corresponding to material D with defects is 4*p3. The maximum consumption of semi-finished component PCB-7 relative to the product component PRO-1 corresponding to material D with defects is 4*p4. The maximum consumption of semi-finished component PCB-3 relative to the product component PRO-4 corresponding to material C with defects is 4*p5. The maximum consumption of semi-finished component PCB-4 relative to the product component PRO-4 corresponding to material C with defects is 4*p6. The total maximum consumption of one or more semi-finished components in the fifth group is: Max5 = 4p1 + 4p2 + 4p3 + 4p4 + 4p5 + 4p6.

[0483] In an exemplary implementation, the fifth objective function is constrained by a first constraint function, which is expressed as:

[0484]

[0485] Among them, Q l This represents the shortage quantity (i.e., demand) of the product component corresponding to the l-th material in the first group that has a shortage; (Q) l G j Let represent a set of variables (which can be a set of variables) of the j-th group of semi-finished components relative to the l-th defective material. Multiple semi-finished components in the j-th group can be substituted for each other when producing the l-th defective material; 0 ≤ p i ≤Q l ; 1≤j≤J, where J represents the total number of groups of semi-finished components that can be substituted for each other when producing the l-th material with defects.

[0486] In an exemplary embodiment, the first constraint function of the fifth objective function can be understood as a constraint on the shortage amount of the product components corresponding to the corresponding materials in the first group that have shortages (i.e., the demand amount of the product components corresponding to the corresponding materials in the first group that have shortages). According to Table 6, product components PRO-1 corresponding to materials C and D have shortages, and product components PRO-4 corresponding to material C have shortages (i.e., the value of l is 3). The shortage amount Q1 of product components PRO-1 corresponding to material C is 20000-y1-y2, the shortage amount Q2 of product components PRO-1 corresponding to material D is 20000-y1-y2, and the shortage amount Q3 of product components PRO-4 corresponding to material C is 1300-y5-y6. When preparing product component PRO-1 corresponding to material C, the total number J of substitutable semi-finished component groups is 1 (this group of semi-finished components includes: semi-finished component PCB-3 and semi-finished component PCB-4). When preparing product component PRO-1 corresponding to material D, the total number J of substitutable semi-finished component groups is 1 (this group of semi-finished component groups includes: semi-finished component PCB-6 and semi-finished component PCB-7). When preparing product component PRO-4 corresponding to material C, the total number J of substitutable semi-finished component groups is 1 (this group of semi-finished component groups includes: semi-finished component PCB-3 and semi-finished component PCB-4). The constraint on the defect amount of the product component corresponding to the material with defects in the second group is as follows:

[0487] The constraint on the defect amount of product component PCB-1 corresponding to materials C and D in the first group is: p1+p2+p3+p4≤20000–y3-y4;

[0488] The constraint on the defect amount of the product component PCB-4 corresponding to material C in the first group is: p5+p6≤1300–y5-y6.

[0489] In an exemplary embodiment, the fifth objective function may also be subject to a second constraint function, which is expressed as:

[0490]

[0491] Among them, C m X represents the available inventory of the m-th type of semi-finished component in the fifth group; m Let M be a set of variables (which can be a set of variables) representing the m-th semi-finished component; 1 ≤ m ≤ M, where M represents the total number of types of semi-finished components in the fifth group.

[0492] In an exemplary embodiment, the second constraint function of the fifth objective function can be understood as a constraint on the inventory quantity of the corresponding semi-finished components in the fifth group. As shown in Table 6, the total number M of semi-finished component types in the fifth group is 4 (including: semi-finished component PCB-13, semi-finished component PCB-4, semi-finished component PCB-6, and semi-finished component PCB-7). The available inventory quantity of semi-finished component PCB-3 is 2000, the available inventory quantity of semi-finished component PCB-4 is 1500, the available inventory quantity of semi-finished component PCB-6 is 400, and the available inventory quantity of semi-finished component PCB-7 is 2000. The constraints on the inventory quantity of the corresponding semi-finished components in the fifth group are as follows:

[0493] The inventory constraint for semi-finished component PCB-3 is: 4p1+4p5≤1000;

[0494] The inventory constraint for semi-finished component PCB-4 is: 4p2+4p6≤1500;

[0495] The inventory constraint for semi-finished component PCB-6 is: 4p3≤400;

[0496] The inventory constraint for semi-finished component PCB-7 is: 4p4≤2000.

[0497] In an exemplary embodiment, the above-mentioned use of the fifth linear programming model to calculate the maximum consumption of one or more semi-finished components in the fifth group relative to the product components corresponding to one or more materials with defects in the first group, under the premise of satisfying the first and second constraint functions of the fifth objective function, obtains the values ​​of p1, p2, p3, and p4 that can maximize the sum of the maximum consumption of one or more semi-finished components in the fifth group (Max5). This can minimize the inventory of semi-finished components and replenish the shortage of materials with defects in the first group as much as possible, thereby reducing the stagnation of semi-finished components and reducing the shortage of materials in the first group.

[0498] Step 122: Based on the inventory of one or more semi-finished components in the fifth group and the maximum consumption of the product components corresponding to one or more semi-finished components in the fifth group relative to the corresponding materials in the first group that have shortages, calculate the remaining quantity of one or more semi-finished components in the fifth group, and update the inventory of one or more semi-finished components in the fifth group using the remaining quantity of one or more semi-finished components in the fifth group.

[0499] In an exemplary embodiment, step 125, calculating the remaining quantity of one or more semi-finished components in the third group based on the inventory of one or more semi-finished components in the fifth group and the maximum consumption of the product components corresponding to one or more defective materials in the first group relative to the inventory of one or more semi-finished components in the fifth group, may include: subtracting the maximum consumption of the product components corresponding to one or more semi-finished components in the fifth group relative to the inventory of one or more semi-finished components in the first group from the inventory of one or more semi-finished components in the fifth group to obtain the remaining quantity of one or more semi-finished components in the fifth group.

[0500] In an exemplary embodiment, subject to the second constraint function of the fifth objective function, the remaining amount of material of one or more semi-finished components in the fifth group is a number greater than or equal to 0.

[0501] In an exemplary embodiment, taking the consumption of semi-finished component PCB-6 when preparing product component PRO-1 corresponding to material D as an example: After using semi-finished component PCB-6 to replenish the shortage of product component PRO-1 corresponding to material D, the remaining quantity of semi-finished component PCB-6 is 400-4p3. The inventory of semi-finished component PCB-6 can be updated from 400 to 400-4p3 to avoid the inventory of semi-finished component (PCB-6) being higher than the actual inventory, thereby effectively managing the material of semi-finished components.

[0502] Step 123: Calculate the fifth defect value based on the available quantity of the product component corresponding to the material group with defects in the first group prepared from one or more semi-finished components in the fifth group and the defect amount of the product component corresponding to the material group with defects in the first group. Update the defect amount of the product component corresponding to the material group with defects in the first group using the fifth defect value.

[0503] In an exemplary embodiment, calculating the fifth defect value based on the amount of product components corresponding to the material group with defects in the first group prepared from one or more semi-finished components in the fifth group and the amount of defects in the product components corresponding to the material group with defects in the first group may include: subtracting the amount of defects in the product components corresponding to the material group with defects in the first group from the amount of defects in the product components corresponding to the material group with defects in the first group to obtain the fifth defect value of the product components corresponding to the material group with defects in the first group;

[0504] The available quantity of product components corresponding to the material groups with defects in the first group, prepared from one or more semi-finished components in the fifth group, is equal to the sum of the integer values ​​of the ratio between the inventory of one or more semi-finished components in the fifth group and the unit consumption of one or more semi-finished components in the fifth group relative to the product components corresponding to the material groups with defects in the first group, rounded down. In an exemplary embodiment, the available quantity of product components corresponding to the material groups with defects in the first group, prepared from one or more semi-finished components in the fifth group, is obtained when calculating the maximum consumption of one or more semi-finished components in the fifth group relative to the product components corresponding to one or more material groups with defects in the first group using the fifth linear programming model. As shown in Table 6, the available quantity of product component PRO-1 corresponding to the substitute material groups C and D prepared from semi-finished components PCB-3, PCB-4, PCB-6, and PCB-7 is p1+p2+p3+p4.

[0505] In an exemplary embodiment, the shortage amount of the product component corresponding to the corresponding material group in the first group is equal to the demand amount of the corresponding product component minus the available amount of the substitute group relative to the corresponding product component.

[0506] The availability of the alternative group relative to the corresponding product component = the availability of the first group of materials relative to the corresponding product component + the availability of the fifth group of semi-finished components relative to the corresponding product component.

[0507] As shown in Tables 4 and 6, taking the preparation of product component PRO-1 using substitute materials C and D as an example: the available quantity of substitute materials C and D relative to the corresponding product component PRO-1 is y3+y4. The available quantity of semi-finished components PCB-3, PCB-4, PCB-6, and PCB-7 in the fifth group relative to the corresponding product component PRO-1 is p1+p2+p3+p4. The demand for product component PRO-1 is 20000, and the shortage of product component PRO-1 = 20000-y3-y4; the final shortage of product component PRO-1 = 20000-y3-y4-(p1+p2+p3+p4). The fifth shortage value can be p1+p2+p3+p4-(20000-y3-y4).

[0508] Step 124: Calculate the sixth defect value based on the available quantity of the corresponding material in the first group that has defects, which is prepared from one or more semi-finished components in the fifth group, and the defect quantity of the corresponding material group in the first group that has defects. Update the defect quantity of the corresponding material group in the first group with defects using the sixth defect value.

[0509] In an exemplary embodiment, calculating the sixth defect value based on the available quantity of the corresponding material in the first group that has defects, prepared from one or more semi-finished components in the fifth group, and the defect amount of the corresponding material in the first group that has defects, may include: subtracting the available quantity of the corresponding material in the first group that has defects from the defect amount of the corresponding material in the first group that has defects from the defect amount of the corresponding material in the first group to obtain the sixth defect value of the corresponding material in the first group.

[0510] The available quantity of materials in the fifth group that are deficient in the first group can be prepared from one or more semi-finished components in the fifth group is equal to the integer value obtained by rounding down the ratio between the inventory of one or more semi-finished components in the fifth group and the unit consumption value of one or more semi-finished components in the fifth group relative to the deficient materials in the first group. In an exemplary embodiment, the available quantity of materials in the fifth group that are deficient in the first group can be obtained by multiplying the available quantity of the product component corresponding to the deficient material in the first group by one or more semi-finished components in the fifth group by the unit consumption value of the deficient material in the first group relative to the corresponding product component. As shown in Table 6, when using semi-finished components PCB-3 and PCB-4 to prepare product group PRO-4 corresponding to material C, the available quantity of semi-finished components PCB-3 and PCB-4 relative to material C is 2p5 + 2p6. The sixth defect value of material C can be obtained by subtracting the defect amount (1300-y5-y6) / 2 when preparing product component PRO-4 from the defect amount of material group C and H, which is 2p5+2p6 relative to material C. That is, the sixth defect value of material C = (1300-y5-y6) / 2-(2p5+2p6).

[0511] Step 125: Obtain the configuration parameters, allocate the shortage amount of the missing materials in the corresponding material group in the first group according to the configuration parameters, and update the shortage amount of the corresponding materials in the first group using the allocated shortage amount.

[0512] In an exemplary embodiment, the configuration parameters may include the priority of the corresponding materials in the first group that have defects. Step 125 may include: allocating the defect amount to the corresponding materials in the first group that have defects according to the material priority number. In an exemplary embodiment, materials with higher priority are allocated defect amounts first.

[0513] As shown in Table 7, this is an example of allocating the shortage amount of materials with defects in the first group according to material priority:

[0514] Table 7

[0515]

[0516] In an exemplary implementation, the configuration parameters are not limited to the priority of alternative materials. They can be set according to actual business needs. For example, the shortage quantity can be allocated according to the size of the common quantity of alternative materials and the likelihood of using alternative materials.

[0517] In an exemplary embodiment, during the preparation of one or more product components, the consumption of materials (necessary or irreplaceable materials) in the first group is first calculated. When there is a shortage of materials in the first group, a semi-finished component of the corresponding material is obtained. The semi-finished component is used to convert the corresponding material in the first group to obtain the shortage or stagnation status of materials in the first group. Based on the calculation of the material consumption of the first group and the corresponding semi-finished component, the consumption of materials (replaceable materials) in the second group is calculated. When there is a shortage of materials in the second group, if there is a semi-finished component, the material of the semi-finished component is used to convert the corresponding material in the second group. Finally, the stagnation quantity or shortage quantity of the first and second groups and the corresponding semi-finished component is obtained. When the remaining quantity of materials is greater than 0, it is called the stagnation quantity. When the remaining quantity of materials is less than 0, it is called the shortage quantity (or the shortage quantity is calculated based on the remaining quantity).

[0518] In an exemplary embodiment, step M0 may be included after step 122: If, based on the remaining quantity of one or more next-level materials in the fifth group, a shortage exists in one or more next-level materials in the fifth group, configuration parameters of the next-level materials are obtained; the shortage quantity of the missing materials in the corresponding next-level material group in the fifth group is reallocated according to the configuration parameters of the next-level materials; the shortage quantity of the corresponding next-level materials in the fifth group is updated using the reallocated shortage quantity; and the updated shortage quantity and shortage status of the corresponding next-level materials in the fifth group are displayed through a first output interface. If, based on the remaining quantity of one or more next-level materials in the fifth group, no shortage exists and the remaining quantity is greater than 0, the remaining quantity and stagnation status of one or more next-level materials in the fifth group are output through a first display interface. If, based on the remaining quantity of one or more next-level materials in the fifth group, no shortage exists and the remaining quantity is equal to 0, the remaining quantity and material status of one or more next-level materials in the fifth group are output through a first display interface.

[0519] In an exemplary embodiment, steps 123 to 125 may be replaced by step M0, or both steps M0 and steps 123 to 125 may be performed.

[0520] In an exemplary embodiment, after step 123 and before step 124, the method may further include: outputting the defect amount of the product component corresponding to the corresponding material in the first group that has a defect through the first display interface.

[0521] In an exemplary embodiment, after step 124 and before step 125, the method may further include: outputting the defect amount of the corresponding material in the first group that has a defect through the first display interface.

[0522] In an exemplary embodiment, step 125 may be followed by: outputting the updated quantity of the corresponding material in the first group that is in short supply through a first display interface.

[0523] In an exemplary embodiment, the shortage amount of the corresponding material in the first group obtained in step 125, the shortage amount of the product component corresponding to the material with shortage in the first group obtained in step 123, the inventory amount of the semi-finished component in the fifth group obtained in step 122, the shortage amount of the alternative material group relative to the product component obtained in step 119, the inventory amount (i.e., remaining amount) of one or more materials in the first group in step 118, the inventory amount of the corresponding material with shortage in the second group in step 107, and the inventory amount of the corresponding material in the second group in step 106 can be used as reference data for whether the corresponding material is stagnant or in short supply.

[0524] In an exemplary embodiment, the inventory of semi-finished components in the third group is obtained in step 113, the shortage amount of corresponding materials in the second group with shortages is obtained in step 114, and the shortage amount of semi-finished components in the third group and the fourth group are obtained in step 115. When the subsequent calculation of the substitute materials consumed in the second group does not involve the materials of the corresponding semi-finished components in the third and fourth groups, the data can be used as reference data for whether the materials of the corresponding semi-finished components are stagnant or in short supply. When the subsequent calculation of the substitute materials consumed in the second group involves the materials of the corresponding semi-finished components in the third and fourth groups, the data of the semi-finished components involved is not the final data, and the final data obtained from calculating the consumption amount of the second group is used as the reference data for whether the materials are stagnant or in short supply.

[0525] In an exemplary embodiment, after obtaining the remaining quantity of one or more semi-finished components in the fourth group in step 111, the method may further include: when the remaining quantity of one or more semi-finished components in the fourth group is greater than 0, determining, based on the substitution relationship information between the semi-finished components in the fourth group, whether at least one material in the fourth group is a substitute material relative to one or more materials in the first and third groups that are deficient; when it is determined that one or more materials in the fourth group are not substitute materials relative to one or more materials in the first and third groups that are deficient, determining that one or more materials in the fourth group are stagnant. When it is determined that one or more materials in the fourth group are substitute materials relative to one or more materials in the first and third groups that are deficient, it is necessary to determine the stagnant or deficient state of one or more materials in the fourth group based on the consumption of one or more materials in the fourth group in the first and third groups.

[0526] In an exemplary embodiment, the aforementioned semi-finished components can be used as the next level of materials for preparing product components.

[0527] In an exemplary embodiment, the computer-implemented method described above can be executed by a processor executing executable instructions stored in memory.

[0528] In an exemplary implementation, such as Figure 4 As shown, the computer-implemented method may also include: generating one or more user interfaces;

[0529] One or more user interfaces may include a first output interface OI1, which is configured to display the material status of the corresponding material in at least one of the first to fourth groups.

[0530] In an exemplary embodiment, the material status may include: material shortage, material stagnation, and material just meeting the requirements.

[0531] In an exemplary implementation, such as Figure 4 As shown, one or more user interfaces may further include a first input interface II1, which is configured to receive one or more user inputs for querying a database; the database stores data for multiple materials;

[0532] The computer-implemented method may further include: receiving a user selection of one or more conditions from a first input interface II1, the user selection being used to select a material state related to the one or more conditions; and, in response to the user selection, querying a database to determine one or more material states in the database related to the one or more conditions; the one or more conditions may include at least one of an stagnant state of stagnant material and a shortage state of defective material; the one or more user interfaces may further include a second output interface II2, configured to display one or more stagnant or defective materials as a result of querying the database. In an exemplary embodiment, the one or more conditions may also include at least one of a manufacturing location identifier, a material identifier, or a date range.

[0533] In an exemplary embodiment, the second output interface OI2 can also be configured to display the identification number of one or more products manufactured from one or more stagnant materials. In an exemplary embodiment, the second output interface OI2 can also be configured to display the demand for stagnant materials used to manufacture the corresponding product components. Users can analyze the relationship between demand and stagnant status.

[0534] In an exemplary embodiment, one or more user interfaces may further include a second input interface II2, which is configured to receive one or more user inputs for adjusting the priority of corresponding materials in the first group;

[0535] The computer-implemented method may further include: redetermining whether the corresponding materials in the first group are stagnant or in short supply based on the adjusted priority of the corresponding materials in the first group.

[0536] In an exemplary embodiment, the second input interface II2 may also be configured to receive one or more user inputs for adjusting the priority of the corresponding next-level material in the third group;

[0537] The computer-implemented method may further include: based on the adjusted priority of the corresponding next-level material in the second group, re-determining whether the corresponding next-level material in the third group is stagnant or in short supply.

[0538] In an exemplary embodiment, one or more user interfaces may further include a third input interface II3, which is configured to receive one or more user inputs for adjusting one or more product components;

[0539] The computer-implemented method may further include: calculating the adjusted maximum consumption of the corresponding materials in the first group based on the adjusted demand for one or more product components;

[0540] Compare the adjusted maximum consumption of the corresponding material in the first group with the available inventory of the corresponding material in the first group;

[0541] The system re-evaluates whether the corresponding materials in the first group are stagnant or in short supply. In an exemplary embodiment, one or more user interfaces may further include a third input interface II3, configured to receive one or more user inputs for adjusting the demand for one or more products. The memory also stores computer-executable instructions for controlling one or more processors to: calculate the adjusted maximum consumption of the corresponding materials in the first group within a cycle based on the adjusted demand for one or more products; compare the adjusted maximum consumption of the corresponding materials in the first group with the available inventory of the corresponding materials in the first group; and re-evaluate whether the corresponding materials in the first group are stagnant. By adjusting the demand for one or more products, material stagnancy can be reduced, manufacturers can better cater to the market, and products can be supplied more quickly.

[0542] One or more user interfaces may further include a third output interface OI3, configured to display the estimated surplus relative to obsolete materials at the first manufacturing location and the estimated deficit relative to obsolete materials at the second manufacturing location. Optionally, the third output interface OI3 is configured to display a table including the identifier of the obsolete material, the identifier of the manufacturing location, the estimated surplus, and the estimated deficit.

[0543] Figure 5 A third output interface OI3 according to some embodiments of this disclosure is shown. (Refer to...) Figure 5The third output interface OI3 is configured to display the surplus of material Mat-1 at manufacturing site A (5000g), the deficit at manufacturing site B (1000g), and the deficit at manufacturing site C (3000g). In some embodiments, the user can allocate the stagnant material among the manufacturing sites based on several factors, including transportation costs and the urgency of needing the stagnant material at the second manufacturing site.

[0544] In some embodiments, the computer-implemented method may further include: when it is determined that there is stagnation in a corresponding material in the first group, adjusting the demand for one or more product components to minimize material stagnation; and producing one or more product components based on the adjusted demand for one or more products. By adjusting the demand for one or more product components, material stagnation can be reduced, manufacturers can better cater to the market, and products can be supplied more quickly.

[0545] In an exemplary embodiment, a remaining quantity of material greater than 0 indicates that the material is stagnant and can be updated using the remaining quantity; a remaining quantity less than 0 indicates that the material is in short supply and can be updated using the remaining quantity. Available inventory and inventory both represent the quantity of material that can be used before the preparation of the corresponding product component or a semi-finished component of the product component. The remaining quantity is typically obtained by subtracting the consumption from the inventory (or available inventory). After the corresponding product component is prepared, the remaining quantity of the corresponding material can be used to update the inventory of the corresponding material.

[0546] This disclosure also provides an apparatus for managing the production of one or more products. In exemplary embodiments, such as... Figure 6 As shown, an apparatus for managing the production of one or more products may include:

[0547] Memory;

[0548] One or more processors;

[0549] The memory and one or more processors are connected to each other; the memory stores computer-executable instructions for controlling one or more processors to perform the following operations:

[0550] Obtain data on multiple next-level materials of one or more materials for manufacturing one or more product components that have defects; the data on multiple next-level materials of one or more materials with defects includes the available inventory of multiple next-level materials;

[0551] Calculate the maximum consumption of multiple next-level materials relative to at least one of one or more materials with defects;

[0552] Determine whether one or more materials with defects exist based on the maximum consumption and available inventory of the corresponding materials at multiple lower-level materials.

[0553] In an exemplary embodiment Figure 7 This is a schematic diagram of the structure of a device according to some embodiments of the present disclosure. (Refer to...) Figure 7 In some embodiments, the device includes a central processing unit (CPU) configured to perform actions according to computer-executable instructions stored in ROM or RAM. In an exemplary embodiment, data and programs required by the computer system are stored in RAM. In an exemplary embodiment, the CPU, ROM, and RAM are electrically connected to each other via a bus. In an exemplary embodiment, an input / output interface is electrically connected to the bus.

[0554] In an exemplary embodiment, the apparatus for managing the production of one or more products can be used to manage the production of one or more final products, or to manage the production of one or more semi-finished components. In an exemplary embodiment, a product can be a final product or product component, or it can be a semi-finished component, which can serve as a next-level material in the preparation of the product component.

[0555] This disclosure also provides a computer program product, including a non-transitory tangible computer-readable medium having computer-readable instructions thereon, the computer-readable instructions being executable by a processor to cause the processor to perform:

[0556] Data on multiple next-level materials of one or more materials for manufacturing one or more product components that have defects is obtained; the data on multiple next-level materials of one or more materials with defects includes the available inventory of the multiple next-level materials;

[0557] Calculate the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with defects;

[0558] Based on the maximum consumption and available inventory of the corresponding materials of the plurality of next-level materials, it is determined whether one or more materials with defects exist.

[0559] This disclosure also provides an apparatus for managing the production of one or more products, which can be referred to... Figure 6 An apparatus for managing the production of one or more products may include:

[0560] Memory;

[0561] One or more processors;

[0562] The memory and the one or more processors are connected to each other; the memory stores computer-executable instructions for controlling the one or more processors to perform the following operations:

[0563] The system receives user-input material query commands through the first input interface.

[0564] In response to the material query instruction, data on multiple materials for manufacturing one or more product components is obtained from a data source, the data on multiple materials including the available inventory of multiple materials;

[0565] Calculate the maximum consumption of the plurality of materials relative to at least one of the one or more product components;

[0566] Determine whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials and the available inventory of the corresponding materials.

[0567] This disclosure also provides a computer program product, including a non-transitory tangible computer-readable medium having computer-readable instructions thereon, the computer-readable instructions being executable by a processor to cause the processor to perform:

[0568] The system receives user-input material query commands through the first input interface.

[0569] In response to the material query instruction, data on multiple materials for manufacturing one or more product components is obtained from a data source, the data on multiple materials including the available inventory of multiple materials;

[0570] Calculate the maximum consumption of the plurality of materials relative to at least one of the one or more product components;

[0571] Determine whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials and the available inventory of the corresponding materials.

[0572] This disclosure provides a computer-implemented method, an apparatus for managing the production of one or more products, and a computer program product. The computer-implemented method includes: receiving a user-inputted material query instruction through a first input interface; responding to the material query instruction, obtaining data from a data source regarding multiple materials for manufacturing one or more product components, the data including available inventory levels of the multiple materials; calculating the maximum consumption of the multiple materials relative to at least one of the one or more product components; and determining whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials and the available inventory levels of the corresponding materials. The technical solution provided by this disclosure can solve the problem of material stagnation or shortages in the material management process.

[0573] It will be understood by those skilled in the art that all or some of the steps, systems, or apparatuses disclosed above, and their functional modules / units, can be implemented as software, firmware, hardware, or suitable combinations thereof. In hardware implementations, the division between functional modules / units mentioned above does not necessarily correspond to the division of physical components; for example, a physical component may have multiple functions, or a function or step may be performed collaboratively by several physical components. Some or all components may be implemented as software executed by a processor, such as a digital signal processor or microprocessor, or as hardware, or as an integrated circuit, such as an application-specific integrated circuit (ASIC). Such software may be distributed on a computer-readable medium, which may include computer storage media (or non-transitory media) and communication media (or transient media). As is known to those skilled in the art, the term computer storage media includes volatile and non-volatile, removable and non-removable media implemented in any method or technology for storing information (such as computer-readable instructions, data structures, program modules, or other data). Computer storage media include, but are not limited to, RAM, ROM, EEPROM, flash memory or other memory technologies, CD-ROM, digital versatile disc (DVD) or other optical disc storage, magnetic cartridges, magnetic tape, disk storage or other magnetic storage devices, or any other medium that can be used to store desired information and can be accessed by a computer. Furthermore, it is well known to those skilled in the art that communication media typically contain computer-readable instructions, data structures, program modules, or other data in modulated data signals such as carrier waves or other transmission mechanisms, and may include any information delivery medium.

[0574] Where there is no conflict, the embodiments of the present invention, i.e. the features in the embodiments, can be combined with each other to obtain new embodiments.

[0575] While the embodiments disclosed herein are as described above, they are merely illustrative of implementations to facilitate understanding and are not intended to limit the scope of this disclosure. Any person skilled in the art may make any modifications and variations in the form and details of the implementation without departing from the spirit and scope of this disclosure; however, the scope of patent protection of this disclosure shall be determined by the appended claims.

Claims

1. A computer-implemented method, characterized in that, include: The system receives user-input material query commands through the first input interface. In response to the material query instruction, data on multiple materials for manufacturing one or more product components is obtained from a data source, the data on multiple materials including the available inventory of multiple materials and substitution relationship information between multiple materials; Calculate the maximum consumption of the plurality of materials relative to at least one of the one or more product components; Determine whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials and the available inventory of the corresponding materials of the multiple materials. The method further includes: when it is determined that there are defects in multiple materials used to manufacture one or more product components, determining whether there are any next-level materials for the defective materials; when it is determined that there are next-level materials for the defective materials, acquiring data on multiple next-level materials for the one or more materials used to manufacture one or more product components, wherein the data on multiple next-level materials for the one or more materials used to manufacture one or more product components includes the available inventory of the multiple next-level materials and substitution relationship information between the next-level materials; calculating the maximum consumption of the multiple next-level materials relative to at least one of the one or more materials used to manufacture one or more product components; and determining whether there are defects in the multiple next-level materials based on the maximum consumption and available inventory of the corresponding materials of the multiple next-level materials. Before acquiring data on multiple next-level materials of one or more materials that have defects in manufacturing one or more product components, the method further includes: identifying one or more materials with defects in a second group from the one or more materials with defects based on the substitution relationship information between the multiple materials; wherein the one or more materials with defects in the second group are non-substitutable materials relative to at least one of the one or more product components. Before calculating the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with defects, the method further includes: based on the substitution relationship information between the next-level materials, determining the data of one or more next-level materials in a third group and the data of one or more next-level materials in a fourth group from the data of one or more materials with defects in the second group, wherein the one or more next-level materials in the third group are substitutable relative to at least one of the one or more materials with defects in the second group, and the one or more next-level materials in the fourth group are non-substitutable relative to at least one of the one or more materials with defects in the second group.

2. The computer-implemented method according to claim 1, characterized in that, The calculation of the maximum consumption of the plurality of materials relative to at least one of the one or more product components includes: calculating the maximum consumption of the one or more materials in the second group relative to the one or more product components based on data of the one or more materials in the second group; The step of determining whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials of the plurality of materials and the available inventory of the corresponding materials of the plurality of materials includes: calculating the remaining quantity of one or more materials in the second group based on the available inventory of one or more materials in the second group and the maximum consumption of one or more materials in the second group, and determining whether there is a shortage of one or more materials in the second group based on the remaining quantity of one or more materials in the second group.

3. The computer-implemented method according to claim 2, characterized in that, The step of calculating the maximum consumption of one or more materials in the second group relative to one or more product components based on the data of one or more materials in the second group includes: multiplying the demand for one or more product components that require one or more materials in the second group as irreplaceable materials by the sum of the corresponding unit consumption values ​​of the corresponding materials in the second group relative to the manufacture of one or more product components, to obtain the maximum consumption of one or more materials in the second group relative to one or more product components.

4. The computer-implemented method according to claim 2, characterized in that, When determining that one or more materials in the second group are in short supply, the method further includes: calculating the shortage amount of one or more materials in the second group based on the available inventory of the one or more materials in the second group and the maximum consumption of the one or more materials in the second group.

5. The computer-implemented method according to claim 4, characterized in that, The calculation of the maximum consumption of the plurality of next-level materials relative to at least one of the materials with defects includes: calculating the maximum consumption of one or more next-level materials in the fourth group relative to one or more materials with defects in the second group; The step of determining whether there is a shortage of the multiple next-level materials based on the maximum consumption and available inventory of the corresponding materials includes: subtracting the maximum consumption of one or more next-level materials in the fourth group from the available inventory of one or more next-level materials in the fourth group to obtain the remaining quantity of one or more next-level materials in the fourth group, and determining whether there is a shortage of one or more next-level materials in the fourth group based on the remaining quantity of one or more next-level materials in the fourth group.

6. The computer-implemented method according to claim 5, characterized in that, The calculation of the maximum consumption of one or more next-level materials in the fourth group relative to one or more materials in the second group that have defects includes: multiplying the defect amount of one or more materials in the second group that require one or more next-level materials in the fourth group as irreplaceable materials by the sum of the unit consumption values ​​of the corresponding next-level materials in the fourth group for manufacturing one or more corresponding materials in the second group that have defects, to obtain the maximum consumption of one or more next-level materials in the fourth group relative to one or more materials in the second group that have defects.

7. The computer-implemented method according to claim 5, characterized in that, Also includes: When it is determined that there is a shortage of one or more next-level materials in the fourth group, the shortage amount of one or more next-level materials in the fourth group is obtained based on the remaining amount of one or more next-level materials in the fourth group, and the shortage amount and shortage status of one or more next-level materials in the fourth group are displayed through the first output interface. When it is determined that there are no defects in one or more next-level materials in the fourth group and the remaining quantity is 0, the remaining quantity and material status of one or more next-level materials in the fourth group are displayed through the first output interface. When it is determined that one or more next-level materials in the fourth group have no defects and the remaining quantity is greater than 0, based on the substitution relationship information between the next-level materials, it is determined whether one or more next-level materials in the fourth group are substitutable relative to at least one of the one or more materials in the first group that have defects; when it is determined that one or more next-level materials in the fourth group are not substitutable relative to one or more materials in the first group that have defects, it is determined that one or more next-level materials in the fourth group are stagnant, and the stagnant status and remaining quantity of one or more next-level materials in the fourth group are displayed through the first output interface.

8. The computer-implemented method according to claim 1, characterized in that, The calculation of the maximum consumption of the plurality of next-level materials relative to at least one of the materials with defects includes: using a third linear programming model to calculate the maximum consumption of one or more semi-finished components in the third group relative to one or more materials with defects in the second group; The step of determining whether there is a shortage of the multiple next-level materials based on the maximum consumption and available inventory of the corresponding materials includes: subtracting the maximum consumption of one or more next-level materials in the third group from the available inventory of one or more next-level materials in the third group to obtain the remaining quantity of one or more next-level materials in the third group, and determining whether there is a shortage of one or more next-level materials in the third group based on the remaining quantity of one or more next-level materials in the third group.

9. The computer-implemented method according to claim 8, characterized in that, Also includes: When it is determined that there is a shortage of one or more next-level materials in the third group, the shortage amount of one or more next-level materials in the third group is obtained based on the remaining amount of one or more next-level materials in the third group, and the shortage amount and shortage status of one or more next-level materials in the third group are displayed through the first output interface. When it is determined that there are no defects in one or more next-level materials in the third group and the remaining quantity is 0, the remaining quantity and material status of one or more next-level materials in the third group are displayed through the first output interface. When it is determined that one or more next-level materials in the third group have no defects and the remaining quantity is greater than 0, based on the substitution relationship information between the next-level materials, it is determined whether one or more next-level materials in the third group are substitutable relative to at least one of the one or more materials in the first group that have defects; when it is determined that one or more materials in the third group are not substitutable relative to one or more materials in the first group that have defects, it is determined that one or more next-level materials in the third group are stagnant, and the stagnant status and remaining quantity of one or more next-level materials in the third group are displayed through the first output interface.

10. The computer-implemented method according to claim 8, characterized in that, The third objective function of the third linear programming model is expressed as: ; in, This represents the amount of the corresponding material in the second group that is in short supply, which is the next level of material preparation in the third group; N represents the unit consumption value of the corresponding next-level material in the third group relative to one or more corresponding materials in the second group that have defects; N is a positive integer, N≥1.

11. The computer-implemented method according to claim 10, characterized in that, The third objective function is constrained by the first constraint function, which is expressed as: ; in, Representing the second group The quantity of defective material; Represents relative to the first A set of variables for the next-level materials in the j-th group of materials with defects, where multiple next-level materials in the j-th group are produced in the production stage. Materials with defects can be substituted for each other; 0≤ ≤ ; 1≤j≤J, where J represents the number of products produced. The total number of groups of next-level materials that can be substituted for each other when there is a shortage of materials.

12. The computer-implemented method according to claim 10, characterized in that, The third objective function is constrained by the second constraint function, which is expressed as: ; in, This represents the available inventory of the m-th next-level material in the third group; Let M be a set of variables representing the m-th next-level material; 1 ≤ m ≤ M, where M represents the total number of next-level material types in the third group.

13. The computer-implemented method according to claim 1, characterized in that, The data for the multiple materials includes information on the substitution relationships between the multiple materials and the demand for one or more product components; Before acquiring data on multiple next-level materials of one or more materials that have defects in manufacturing one or more product components, the method further includes: identifying one or more materials in a first group from the multiple materials based on substitution relationship information between the multiple materials, wherein one or more materials in the first group are substitute materials relative to at least one of the one or more product components; The calculation of the maximum consumption of the plurality of materials relative to at least one of the one or more product components includes: calculating the maximum consumption of the one or more materials in the first group relative to one or more product components based on data of the one or more materials in the first group; The step of determining whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials of the plurality of materials and the available inventory of the corresponding materials of the plurality of materials includes: obtaining the available quantity of one or more substitute material groups in the first group relative to one or more product components when the consumption of one or more materials in the first group relative to one or more product components is the maximum consumption; and determining whether there is a shortage of one or more substitute material groups in the first group relative to the corresponding product components based on the available quantity of one or more substitute material groups in the first group relative to one or more product components and the demand of one or more product components.

14. The computer-implemented method according to claim 13, characterized in that, When it is determined that there are defects in multiple materials used to manufacture one or more product components, determining whether there are any next-level materials for the defective materials includes: when it is determined that there are defects in one or more substitute material groups in the first group relative to the corresponding product component, determining whether there are any next-level materials for the material groups in the first group that have defects. When it is determined that there are defective materials in the next level of materials, data of multiple next level materials of one or more materials that are defective in manufacturing one or more product components are obtained, including: when it is determined that there are defective material groups in the first group, material data of one or more next level materials of one or more material groups that are defective in the first group are obtained. The calculation of the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with defects includes: taking the plurality of next-level materials of the one or more material groups with defects in the first group as one or more next-level materials in the fifth group, and calculating the maximum consumption of the product components corresponding to the one or more next-level materials in the fifth group relative to the one or more material groups with defects in the first group based on the material data of the one or more next-level materials in the fifth group. The step of determining whether there is a shortage of the multiple next-level materials based on the maximum consumption and available inventory of the corresponding materials includes: calculating the remaining quantity of one or more next-level materials in the fifth group based on the available inventory of one or more next-level materials in the fifth group and the maximum consumption of the product components corresponding to one or more next-level materials in the first group that have shortages, relative to the maximum consumption of the corresponding material groups that have shortages in the first group; and determining whether there is a shortage of one or more next-level materials in the fifth group based on the remaining quantity of one or more next-level materials in the fifth group.

15. The computer-implemented method according to claim 14, characterized in that, When it is determined that there is a shortage of one or more substitute material groups in the first group relative to the corresponding product component, the method further includes: calculating the shortage amount of one or more substitute material groups in the first group relative to the corresponding product component based on the available quantity of one or more substitute material groups in the first group relative to the corresponding product component and the demand amount of the material in the first group that is in short supply. When it is determined that there is a shortage of one or more next-level materials in the fifth group, the method further includes: calculating a sixth shortage value based on the available quantity of the corresponding material in the first group that has a shortage and the shortage amount of the corresponding material group in the first group that has a shortage, based on the one or more next-level materials in the fifth group; and updating the shortage amount of the corresponding material group in the first group that has a shortage using the sixth shortage value. Obtain configuration parameters, reallocate the shortage amount of the missing materials in the corresponding material groups in the first group according to the configuration parameters, update the shortage amount of the corresponding materials in the first group using the allocated shortage amount, and display the shortage amount and shortage status of the corresponding materials in the first group through the first output interface.

16. The computer-implemented method according to claim 14, characterized in that, Also includes: When it is determined that there is a shortage of one or more next-level materials in the fifth group, the shortage amount of one or more next-level materials in the fifth group is obtained based on the remaining amount of one or more next-level materials in the fifth group, and the shortage amount and shortage status of one or more next-level materials in the fifth group are displayed through the first output interface. When it is determined that there are no defects in one or more next-level materials in the fifth group and the remaining quantity is greater than 0, the remaining quantity and stagnation status of one or more next-level materials in the fifth group are output through the first display interface. When it is determined that there are no defects in one or more next-level materials in the fifth group and the remaining quantity is equal to 0, the remaining quantity and material status of one or more next-level materials in the fifth group are output through the first display interface.

17. The computer-implemented method according to claim 14, characterized in that, Also includes: When it is determined that one or more next-level materials in the fifth group are in short supply, the configuration parameters of the next-level materials are obtained. Based on the configuration parameters of the next-level materials, the shortage amount of the missing materials in the corresponding next-level material group in the fifth group is reallocated. The shortage amount of the corresponding next-level materials in the fifth group is updated using the reallocated shortage amount. The updated shortage amount and shortage status of the corresponding next-level materials in the fifth group are displayed through the first output interface.

18. The computer-implemented method according to claim 14, characterized in that, Also includes: When it is determined that one or more next-level materials in the fifth group have a shortage, the configuration parameters of the next-level materials are obtained, and the shortage amount of the corresponding next-level materials in the fifth group that have a shortage is reallocated according to the configuration parameters of the next-level materials. The shortage amount of the corresponding next-level materials in the fifth group is updated with the reallocated shortage amount.

19. The computer-implemented method according to claim 1, characterized in that, Also includes: When it is determined that there is no next-level material for a material with a defect, the defect status of the material with a defect is displayed on the first output interface; When it is determined that there are no defects in one or more materials used to manufacture one or more product components, the material information of one or more materials used to manufacture one or more product components is displayed through the first output interface.

20. The computer-implemented method according to claim 1, characterized in that, The method further includes: when determining that one or more materials with shortages are stagnant or in short supply based on the maximum consumption and available inventory of the corresponding materials of the plurality of next-level materials, adjusting the demand for the one or more product components to minimize the stagnant or in short supply of the next-level materials; and producing the one or more product components based on the adjusted demand for the one or more product components.

21. The computer-implemented method according to claim 1, characterized in that, The method further includes: generating one or more user interfaces; The one or more user interfaces include a first output interface, which is further configured to display the material status of the corresponding material in at least one of the first to fifth groups.

22. The computer-implemented method according to claim 21, characterized in that, The one or more user interfaces also include a first input interface configured to receive one or more user inputs for querying the database; The database stores data for multiple materials; The computer-implemented method further includes: receiving a user selection of one or more conditions from the first input interface, the user selection being used to select a material state related to the one or more conditions; and in response to the user selection, querying the database to determine one or more material states in the database related to the one or more conditions. The one or more conditions include at least one of the following: the stagnation state of stagnant materials and the shortage state of defective materials; The one or more user interfaces also include a second output interface configured to display the one or more stagnant or missing materials as a result of querying the database.

23. The computer-implemented method according to claim 21, characterized in that, The one or more user interfaces also include a second input interface configured to receive one or more user inputs for adjusting the priority of the corresponding materials in the first group; The computer-implemented method further includes: re-determining whether the corresponding materials in the first group are stagnant or in short supply based on the adjusted priority of the corresponding materials in the first group.

24. The computer-implemented method according to claim 21, characterized in that, The one or more user interfaces also include a third input interface configured to receive one or more user inputs for adjusting the one or more product components; The computer-implemented method further includes: calculating the adjusted maximum consumption of the corresponding materials in the first group based on the adjusted demand for the one or more product components; Compare the adjusted maximum consumption of the corresponding material in the first group with the available inventory of the corresponding material in the first group; Reassess whether the corresponding materials in the first group are stagnant or in short supply.

25. The computer-implemented method according to claim 1, characterized in that, Also includes: The system receives user input commands to query material status via the first input interface. In response to the query material status command, at least one of the following is obtained from the data source regarding the remaining quantity, stagnation status, shortage status, and shortage quantity of multiple materials for manufacturing one or more product components and multiple next-level materials of the multiple materials.

26. An apparatus for managing the production of one or more products, characterized in that, include: Memory; One or more processors; The memory and the one or more processors are connected to each other; the memory stores computer-executable instructions for controlling the one or more processors to perform the following operations: The system receives user-input material query commands through the first input interface. In response to the material query instruction, data on multiple materials for manufacturing one or more product components is obtained from a data source, the data on multiple materials including the available inventory of multiple materials and substitution relationship information between multiple materials; Calculate the maximum consumption of the plurality of materials relative to at least one of the one or more product components; Determine whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials and the available inventory of the corresponding materials of the multiple materials. When it is determined that there are deficiencies in multiple materials used to manufacture one or more product components, it is determined whether there are any next-level materials for the deficient materials. If it is determined that there are next-level materials for the deficient materials, data on multiple next-level materials for the one or more materials used to manufacture one or more product components are obtained. The data on multiple next-level materials for the one or more materials used to manufacture one or more product components includes the available inventory of the multiple next-level materials and substitution relationship information between the next-level materials. The maximum consumption of the multiple next-level materials relative to at least one of the one or more materials used to manufacture one or more product components is calculated. Based on the maximum consumption and available inventory of the corresponding materials of the multiple next-level materials, it is determined whether there are deficiencies in the multiple next-level materials. Before acquiring data on multiple next-level materials of one or more materials that have defects in manufacturing one or more product components, the method further includes: identifying one or more materials with defects in a second group from the one or more materials with defects based on the substitution relationship information between the multiple materials; wherein the one or more materials with defects in the second group are non-substitutable materials relative to at least one of the one or more product components. Before calculating the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with defects, the method further includes: based on the substitution relationship information between the next-level materials, determining the data of one or more next-level materials in a third group and the data of one or more next-level materials in a fourth group from the data of one or more materials with defects in the second group, wherein the one or more next-level materials in the third group are substitutable relative to at least one of the one or more materials with defects in the second group, and the one or more next-level materials in the fourth group are non-substitutable relative to at least one of the one or more materials with defects in the second group.

27. A computer program product, characterized in that, Including a non-transitory tangible computer-readable medium having computer-readable instructions thereon, the computer-readable instructions being executable by a processor to cause the processor to perform: The system receives user-input material query commands through the first input interface. In response to the material query instruction, data on multiple materials for manufacturing one or more product components is obtained from a data source, the data on multiple materials including the available inventory of multiple materials and substitution relationship information between multiple materials; Calculate the maximum consumption of the plurality of materials relative to at least one of the one or more product components; Determine whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of the corresponding materials and the available inventory of the corresponding materials of the multiple materials. When it is determined that there are deficiencies in multiple materials used to manufacture one or more product components, it is determined whether there are any next-level materials for the deficient materials; when it is determined that there are next-level materials for the deficient materials, data of multiple next-level materials for the one or more materials used to manufacture one or more product components is obtained, wherein the data of multiple next-level materials for the one or more materials used to manufacture one or more product components includes the available inventory of the multiple next-level materials and substitution relationship information between the next-level materials; the maximum consumption of the multiple next-level materials relative to at least one of the one or more materials used to manufacture one or more product components is calculated; Determine whether there is a shortage of the multiple next-level materials based on the maximum consumption and available inventory of the corresponding materials; Before acquiring data on multiple next-level materials of one or more materials that have defects in manufacturing one or more product components, the method further includes: identifying one or more materials with defects in a second group from the one or more materials with defects based on the substitution relationship information between the multiple materials; wherein the one or more materials with defects in the second group are non-substitutable materials relative to at least one of the one or more product components. Before calculating the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with defects, the method further includes: based on the substitution relationship information between the next-level materials, determining the data of one or more next-level materials in a third group and the data of one or more next-level materials in a fourth group from the data of one or more materials with defects in the second group, wherein the one or more next-level materials in the third group are substitutable relative to at least one of the one or more materials with defects in the second group, and the one or more next-level materials in the fourth group are non-substitutable relative to at least one of the one or more materials with defects in the second group.

Images