Computer-implemented method and apparatus, and computer program product

Abstract

A computer-implemented method and apparatus, and a computer program product. The computer-implemented method comprises: by means of a first input interface, receiving a material query instruction inputted by a user; in response to the material query instruction, acquiring, from a data source, data of a plurality of materials for manufacturing one or more product components, wherein the data of the plurality of materials comprises the available inventory of the plurality of materials; calculating the maximum consumption of the plurality of materials with respect to at least one of the one or more product components; and according to 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, determining whether the amount of one or more materials for manufacturing the one or more product components is insufficient.

Description

Computer-implemented method, apparatus, and computer program product

[0001] This application claims priority to PCT international application No. PCT / CN2022 / 141880, filed on December 26, 2022, with application number PCT / CN2022 / 141880 and invention name “Computer-implemented method, apparatus and computer program product for managing the production of one or more products”, and priority to Chinese patent application No. 202310789914.X, filed on June 29, 2023, with invention name “A computer-implemented method, apparatus and computer program product”. The contents of the above PCT international application and Chinese patent application should be understood as incorporated into this application by reference. Technical Field

[0002] The embodiments of the present disclosure relate to, but are not limited to, the field of display technology, and in particular to a computer-implemented method, apparatus, and computer program product. Background Art

[0003] Managing production is a complex process, especially when large quantities of products and starting materials are involved, and when demand for products and manufacturing process requirements change rapidly within a short period of time. Traditional material management or simple programming is insufficient to manage production, making material management difficult and often leading to material shortages, overstock, and waste.

[0004] Summary of the Invention

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

[0006] In a first aspect, an embodiment of the present disclosure further provides a computer-implemented method, comprising:

[0007] Receiving a material query instruction input by a user through a first input interface;

[0008] In response to the material query instruction, obtaining data on a plurality of materials for manufacturing one or more product components from a data source, wherein the data on the plurality of materials includes available inventory quantities of the plurality of materials;

[0009] calculating a maximum consumption of the plurality of materials relative to at least one product component among the one or more product components;

[0010] It is determined whether there is a shortage of one or more materials for manufacturing one or more product components according to the maximum consumption of corresponding materials of the multiple materials and the available inventory of corresponding materials of the multiple materials.

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

[0012] When determining that multiple materials used to manufacture one or more product components are missing, determine whether the missing materials exist in the next level of materials;

[0013] When it is determined that the missing material has next-level materials, data of multiple next-level materials of the one or more missing materials for manufacturing one or more product components are obtained, wherein the data of multiple next-level materials of the one or more missing materials include available inventory quantities of the multiple next-level materials;

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

[0015] It is determined whether there is a shortage of the multiple next-level materials based on the maximum consumption and available inventory of corresponding materials of the multiple next-level 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 also includes substitution relationship information between next-level materials;

[0017] Before obtaining data on multiple next-level materials of the one or more materials with shortages in manufacturing one or more product components, the method further includes: identifying one or more materials with shortages in a second group from the one or more materials with shortages based on substitution relationship information between the multiple materials; wherein the one or more materials with shortages in the second group are irreplaceable materials for at least one of the one or more product components;

[0018] Before calculating the maximum consumption of the multiple next-level materials relative to at least one of the one or more materials with shortages, the method also includes: based on the substitution relationship information between the next-level materials, judging 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 shortages in the second group, wherein the one or more next-level materials in the third group are replaceable materials relative to at least one of the one or more materials with shortages in the second group, and the one or more next-level materials in the fourth group are irreplaceable materials relative to at least one of the one or more materials with shortages in the second group.

[0019] In an exemplary embodiment, the 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 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;

[0020] The determining whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of corresponding materials of the multiple materials and the available inventory of corresponding materials of the multiple 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, the calculation of 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 the one or more product components, to obtain the maximum consumption of one or more materials in the second group relative to the one or more product components.

[0022] In an exemplary embodiment, when determining that one or more materials in the second group are in short supply, the method further includes: calculating the short supply quantity of the 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, the calculating the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with a shortage includes: calculating the maximum consumption of one or more next-level materials in the fourth group relative to the one or more materials with a shortage in the second group;

[0024] The determining whether there is a shortage of the multiple next-level materials based on the maximum consumption and available inventory of the corresponding materials of the multiple next-level materials includes: using the available inventory of one or more next-level materials in the fourth group to subtract the maximum consumption 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, the calculation of the maximum consumption of one or more next-level materials in the fourth group relative to one or more materials in short supply in the second group includes: multiplying the short supply of one or more materials in short supply 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 short supply in the second group, to obtain the maximum consumption of one or more next-level materials in the fourth group relative to one or more materials in short supply in the second group.

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

[0027] When it is determined that one or more next-level materials in the fourth group are in short supply, the short supply quantity of the one or more next-level materials in the fourth group is obtained according to the remaining quantity of the one or more next-level materials in the fourth group, and the short supply quantity and short supply status of the one or more next-level materials in the fourth group are displayed on the first output interface;

[0028] 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 the one or more next-level materials in the fourth group are displayed through the first output interface;

[0029] 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 greater than 0, based on the substitution relationship information between the next-level materials, it is determined whether the one or more next-level materials in the fourth group are replaceable materials relative to at least one material of the one or more materials in the first group that have shortages; when it is determined that the one or more next-level materials in the fourth group are not replaceable materials relative to the one or more materials in the first group that have shortages, it is determined that there is stagnation in one or more next-level materials in the fourth group, and the stagnation status and remaining quantity of the 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 a shortage includes: calculating the maximum consumption of one or more semi-finished components in the third group relative to the one or more materials with a shortage in the second group using a third linear programming model;

[0031] The determining whether there is a shortage of the multiple next-level materials based on the maximum consumption and available inventory of the corresponding materials of the multiple next-level materials includes: using the available inventory of one or more next-level materials in the third group to subtract the maximum consumption 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 comprises:

[0033] When it is determined that one or more next-level materials in the third group are in short supply, the short supply quantity of the one or more next-level materials in the third group is obtained based on the remaining quantity of the one or more next-level materials in the third group, and the short supply quantity and short supply status of the one or more next-level materials in the third group are displayed on the first output interface;

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

[0035] When it is determined that there is no shortage of one or more next-level materials in the third group and the remaining quantity is greater than 0, based on the substitution relationship information between the next-level materials, it is determined whether the one or more next-level materials in the third group are replaceable materials relative to at least one material in the one or more materials in the first group that have shortages; when it is determined that one or more materials in the third group are not replaceable materials relative to the one or more materials in the first group that have shortages, it is determined that there is stagnation in one or more next-level materials in the third group, and the stagnation status and remaining quantity of the 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] Among them, x i Represents the amount of corresponding materials in the third group that can be used to prepare the corresponding materials in the second group that are in short supply; d i The value representing the unit consumption of the corresponding next-level materials in the third group relative to one or more corresponding materials in the second group that are missing; N is a positive integer, N≥1.

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

[0039] Among them, Q lRepresents the missing quantity of the first missing material in the second group; (Q l ,G j ) represents a set of variables (which can be a set of variables) of the jth group of next-level materials relative to the lth missing material. Multiple next-level materials in the jth group can replace each other in the production of the lth missing material; 0≤x i ≤Q l ; 1≤j≤J, where J represents the total number of groups of next-level materials that can replace each other when producing the lth material with a shortage.

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

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

[0042] In an exemplary embodiment, the data of the plurality of materials includes substitution relationship information between the plurality of materials and demand quantity of one or more product components;

[0043] Before acquiring data of multiple next-level materials of the one or more materials with shortages in manufacturing the one or more product components, the method further includes: determining, based on substitution relationship information between the multiple materials, one or more materials in a first group from the multiple materials, the one or more materials in the first group being substitutable materials for at least one of the one or more product components;

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

[0045] The method of judging whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of corresponding materials of the multiple materials and the available inventory of corresponding materials of the multiple materials includes: obtaining the satisfying quantity of one or more alternative 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 judging whether there is a shortage of one or more alternative material groups in the first group relative to the corresponding product components based on the satisfying quantity of one or more alternative material groups in the first group relative to one or more product components and the demand of one or more product components.

[0046] In an exemplary embodiment, when determining that multiple materials for manufacturing one or more product components are missing, determining whether the missing materials have next-level materials includes: when determining that one or more alternative material groups in the first group are missing relative to the corresponding product components, determining whether the missing material group in the first group has next-level materials;

[0047] When determining that the material with the shortage exists a next-level material, obtaining data of multiple next-level materials of the one or more materials with the shortage in manufacturing the one or more product components includes: when determining that the material group with the shortage in the first group exists a next-level material, obtaining material data of one or more next-level materials of the one or more material groups with the shortage in the first group;

[0048] Calculating the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with deficiencies includes: using the plurality of next-level materials of the one or more material groups with deficiencies in the first group as one or more next-level materials in the fifth group, and calculating, based on the material data of the one or more next-level materials in the fifth group, the maximum consumption of the one or more next-level materials in the fifth group relative to the product components corresponding to the one or more material groups with deficiencies in the first group;

[0049] The determining whether there is a shortage of the multiple next-level materials based on the maximum consumption and available inventory of the corresponding materials of the multiple 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 one or more next-level materials in the fifth group relative to the product components corresponding to one or more corresponding material groups with 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.

[0050] In an exemplary embodiment, when determining that one or more alternative material groups in the first group are short of corresponding product components, the method further includes: calculating the shortfall amount of the one or more alternative material groups in the first group relative to the corresponding product components based on the satiable amount of the one or more alternative material groups in the first group relative to the corresponding product components and the demand amount of the shortfall material in the first group;

[0051] When it is determined that one or more lower-level materials in the fifth group are in short supply, the method further includes: calculating a sixth short supply value based on the available quantity of the corresponding material in the first group with a short supply prepared by the one or more lower-level materials in the fifth group and the short supply quantity of the corresponding material group in the first group with a short supply, and updating the short supply quantity of the corresponding material group in the first group with a short supply using the sixth short supply value;

[0052] Obtain configuration parameters, reallocate the shortage quantities of the missing materials in the corresponding material groups with shortages in the first group according to the configuration parameters, use the allocated shortage quantities to update the shortage quantities of the corresponding materials in the first group, and display the shortage quantities and shortage status of the corresponding materials in the first group through the first output interface.

[0053] In an exemplary embodiment, the method further comprises:

[0054] When it is determined that one or more next-level materials in the fifth group are in short supply, the short supply quantity of the one or more next-level materials in the fifth group is obtained based on the remaining quantity of the one or more next-level materials in the fifth group, and the short supply quantity and short supply status of the one or more next-level materials in the fifth group are displayed on the first output interface;

[0055] When it is determined that there is no shortage of 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 the one or more next-level materials in the fifth group are output through the first display interface;

[0056] When it is determined that there is no shortage of 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.

[0057] In an exemplary embodiment, the method further comprises:

[0058] When it is determined that one or more next-level materials in the fifth group have shortages, the configuration parameters of the next-level materials are obtained, and the shortage quantities of the shortage materials in the corresponding next-level material groups in the fifth group with shortages are reallocated according to the configuration parameters of the next-level materials. The shortage quantities of the corresponding next-level materials in the fifth group are updated using the reallocated shortage quantities, and the updated shortage quantities and shortage status of the corresponding next-level materials in the fifth group are displayed through the first output interface.

[0059] In an exemplary embodiment, the method further includes: when it is determined that one or more next-level materials in the fifth group are in short supply, obtaining configuration parameters of the next-level materials, reallocating the short supply quantities of the corresponding next-level materials in the fifth group that are in short supply according to the configuration parameters of the next-level materials, and using the reallocated short supply quantities to update the short supply quantities of the corresponding next-level materials in the fifth group.

[0060] In an exemplary embodiment, the method further includes: when it is determined that the material in shortage does not have a next-level material, displaying the shortage status of the material in shortage through the first output interface;

[0061] When it is determined that there is no shortage of one or more materials for manufacturing one or more product components, material information of the one or more materials for manufacturing the one or more product components is displayed through the first output interface.

[0062] In an exemplary embodiment, the method further includes: when it is determined that one or more of the materials with shortages are stagnant or in shortage based on the maximum consumption and available inventory of the corresponding materials of the multiple next-level materials, adjusting the demand for the one or more product components to minimize the stagnation or shortage 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.

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

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

[0065] 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 of a plurality of materials;

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

[0067] The one or more conditions include at least one of a stagnant state of stagnant materials and a shortage state of shortage materials;

[0068] The one or more user interfaces further include a second output interface configured to display the one or more slow-moving materials or missing materials as a result of querying the database.

[0069] 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 corresponding material in the first group;

[0070] 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 priorities of the corresponding materials in the first group.

[0071] 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;

[0072] Wherein, the computer-implemented method further comprises: calculating an adjusted maximum consumption of the corresponding material in the first group based on the adjusted demand for the one or more product components;

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

[0074] Re-determine whether the corresponding materials in the first group are stagnant or short of each other.

[0075] In an exemplary embodiment, the method further comprises:

[0076] Receiving a material status query instruction input by a user through the first input interface;

[0077] In response to the material status query instruction, at least one of the remaining quantity, stagnant status, shortage status, and shortage quantity of multiple materials used to manufacture one or more product components and multiple next-level materials of the multiple materials is obtained from a data source.

[0078] In a second aspect, an embodiment of the present disclosure provides a computer-implemented method, comprising:

[0079] Obtaining data on multiple next-level materials of one or more materials with shortages for manufacturing one or more product components; the data on multiple next-level materials of one or more materials with shortages includes available inventory quantities of the multiple next-level materials;

[0080] Calculating the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with shortages;

[0081] It is determined whether the one or more materials with shortages are in shortage based on the maximum consumption and available inventory of the corresponding materials of the multiple next-level materials.

[0082] In an exemplary embodiment, before obtaining data of multiple next-level materials for one or more materials with deficiencies in manufacturing one or more product components, the method further includes:

[0083] Obtaining data regarding a plurality of materials used to manufacture one or more product components, the data regarding the plurality of materials including available inventory quantities of the plurality of materials;

[0084] calculating a maximum consumption of the plurality of materials relative to at least one product component among the one or more product components;

[0085] It is determined whether there is a shortage of one or more materials for manufacturing one or more product components according to the maximum consumption of corresponding materials of the multiple materials and the available inventory of corresponding materials of the multiple materials.

[0086] In an exemplary embodiment, the method further comprises:

[0087] When determining that multiple materials used to manufacture one or more product components are missing, determine whether the missing materials exist in the next level of materials;

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

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

[0090] Before obtaining the data of multiple next-level materials of the one or more materials with shortages in the manufacturing of the one or more product components, it also includes: judging one or more materials with shortages in the second group from the one or more materials with shortages based on the substitution relationship information between the multiple materials; wherein the one or more materials with shortages in the second group are irreplaceable materials relative to at least one product component of the one or more product components.

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

[0092] Before calculating the maximum consumption of the multiple next-level materials relative to at least one of the one or more materials with shortages, the method also includes: based on the substitution relationship information between the next-level materials, judging 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 shortages in the second group, wherein the one or more next-level materials in the third group are replaceable materials relative to at least one of the one or more materials with shortages in the second group, and the one or more next-level materials in the fourth group are irreplaceable materials relative to at least one of the one or more materials with shortages in the second group.

[0093] In an exemplary embodiment, the 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 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;

[0094] The determining whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of corresponding materials of the multiple materials and the available inventory of corresponding materials of the multiple materials includes: calculating the remaining quantity of one or more materials with shortages 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.

[0095] In an exemplary embodiment, when determining that one or more materials in the second group are in short supply, the method further includes: calculating the short supply quantity of the 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.

[0096] In an exemplary embodiment, the 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 the one or more materials in short supply in the second group relative to at least one of the one or more product components;

[0097] The determining whether one or more materials for manufacturing one or more product components are in short supply based on the maximum consumption of corresponding materials of the plurality of materials and the available inventory of corresponding materials of the plurality of materials includes: calculating the remaining quantity of the one or more materials in the second group that are in short supply based on the available inventory of the one or more materials in the second group that are in short supply and the maximum consumption of the one or more materials in the second group that are in short supply, and determining whether the one or more materials in the second group that are in short supply are in short supply based on the remaining quantity of the one or more materials in the second group that are in short supply;

[0098] When it is determined that one or more materials in the second group are missing, the method further includes: obtaining the missing quantity of the one or more materials in the second group based on the remaining quantity of the one or more materials in the second group.

[0099] In an exemplary embodiment, the data of the next-level materials further includes unit consumption values ​​of the multiple next-level materials for manufacturing one or more materials in short supply in the second group;

[0100] Calculating the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with a shortage includes: multiplying the shortage of the one or more materials with a shortage in the second group that require the one or more next-level materials in the fourth group as irreplaceable materials by the sum of the unit consumption of the corresponding next-level materials in the fourth group for manufacturing the one or more corresponding materials with a shortage in the second group, to obtain the maximum consumption of the one or more next-level materials in the fourth group relative to the one or more materials with a shortage in the second group;

[0101] The determining whether there is a shortage of one or more materials according to the maximum consumption and available inventory of the corresponding materials of the multiple next-level materials includes: using the available inventory of one or more next-level materials in the fourth group to subtract the maximum consumption 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, determining that there is a shortage of one or more materials in the fourth group.

[0102] 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:

[0103] According to 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 materials relative to at least one of the one or more materials in short supply in the first group.

[0104] In an exemplary embodiment, when it is determined that one or more next-level materials in the fourth group are not substitutable materials relative to the one or more materials in the first group that are in short supply, it is determined that one or more materials in the fourth group are stagnant.

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

[0106] Updates the available inventory of the corresponding lower-level items in the fourth group using the remaining quantity of one or more lower-level items in the fourth group.

[0107] 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 a shortage includes: calculating the maximum consumption of one or more next-level materials in the third group relative to the one or more materials with a shortage in the second group using a third linear programming model;

[0108] The determining whether there is a shortage of one or more materials according to the maximum consumption and available inventory of the corresponding materials of the multiple next-level materials includes: using the available inventory of one or more next-level materials in the third group to subtract the maximum consumption 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, determining that there is a shortage of one or more next-level materials in the third group.

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

[0110] Among them, x i Represents the amount of corresponding materials in the third group that can be used to prepare the corresponding materials in the second group that are in short supply; d i The value representing the unit consumption of the corresponding next-level materials in the third group relative to one or more corresponding materials in the second group that are missing; N is a positive integer, N≥1.

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

[0112] Among them, Q l Represents the missing quantity of the first missing material in the second group; (Q l ,G j) represents a set of variables (which can be a set of variables) of the jth group of next-level materials relative to the lth missing material. Multiple next-level materials in the jth group can replace each other in the production of the lth missing material; 0≤x i ≤Q l ; 1≤j≤J, where J represents the total number of groups of next-level materials that can replace each other when producing the lth material with a shortage.

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

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

[0115] In an exemplary embodiment, the data of the plurality of materials includes substitution relationship information between the plurality of materials and demand quantity of one or more product components;

[0116] Before acquiring data of multiple next-level materials of the one or more materials with shortages in manufacturing the one or more product components, the method further includes: determining, based on substitution relationship information between the multiple materials, one or more materials in a first group from the multiple materials, the one or more materials in the first group being substitutable materials for at least one of the one or more product components;

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

[0118] The method of judging whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of corresponding materials of the multiple materials and the available inventory of corresponding materials of the multiple materials includes: obtaining the satiable quantity of one or more alternative 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 judging whether there is a shortage of one or more alternative material groups in the first group relative to the corresponding product components based on the satiable quantity of one or more alternative material groups in the first group relative to the corresponding product components and the demand for one or more product components in the first group.

[0119] In an exemplary embodiment, when determining that multiple materials for manufacturing one or more product components are missing, determining whether the missing materials have next-level materials includes: when determining that one or more alternative material groups in the first group are missing relative to the corresponding product components, determining whether the missing material group in the first group has next-level materials;

[0120] When it is determined that the material with a shortage exists a next-level material, data of multiple next-level materials of the one or more materials with a shortage in manufacturing one or more product components are obtained, including: when it is determined that the material group with a shortage in the first group exists a next-level material, material data of one or more next-level materials of the one or more material groups with a shortage in the first group are obtained.

[0121] 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 deficiencies includes: using the plurality of next-level materials of the one or more material groups with deficiencies in the first group as one or more next-level materials in a fifth group, and calculating, based on material data of the one or more next-level materials in the fifth group, the maximum consumption of the one or more next-level materials in the fifth group relative to the product components corresponding to the one or more material groups with deficiencies in the first group;

[0122] The determining whether the one or more materials with shortages are in short supply based on the maximum consumption and available inventory of the corresponding materials of the multiple 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 one or more next-level materials in the fifth group relative to the product components corresponding to one or more corresponding material groups with shortages in the first group, and determining whether the one or more next-level materials in the fifth group are in short supply based on the remaining quantity of one or more next-level materials in the fifth group.

[0123] In an exemplary embodiment, when determining that one or more alternative material groups in the first group are short of corresponding product components, the method further includes: calculating the shortfall amount of the one or more alternative material groups in the first group relative to the corresponding product components based on the satiable amount of the one or more alternative material groups in the first group relative to the corresponding product components and the demand amount of the shortfall material in the first group;

[0124] When it is determined that one or more lower-level materials in the fifth group are in short supply, the method further includes: calculating a sixth short supply value based on the available quantity of the corresponding material in the first group with a short supply prepared by the one or more lower-level materials in the fifth group and the short supply quantity of the corresponding material group in the first group with a short supply, and updating the short supply quantity of the corresponding material group in the first group with a short supply using the sixth short supply value;

[0125] Acquire configuration parameters, reallocate missing quantities of missing materials in corresponding material groups with missing materials in the first group according to the configuration parameters, and update the missing quantities of corresponding materials in the first group using the reallocated missing quantities.

[0126] In an exemplary embodiment, the method further includes: when it is determined that one or more next-level materials in the fifth group are in short supply, obtaining configuration parameters of the next-level materials, reallocating the short supply quantities of the corresponding next-level materials in the fifth group that are in short supply according to the configuration parameters of the next-level materials, and using the reallocated short supply quantities to update the short supply quantities of the corresponding next-level materials in the fifth group.

[0127] In an exemplary embodiment, the method further includes: when it is determined that one or more of the materials with shortages are stagnant or in shortage based on the maximum consumption and available inventory of the corresponding materials of the multiple next-level materials, adjusting the demand for the one or more product components to minimize the stagnation or shortage 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.

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

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

[0130] 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 of a plurality of materials;

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

[0132] The one or more conditions include at least one of a stagnant state of stagnant materials and a shortage state of shortage materials;

[0133] The one or more user interfaces further include a second output interface configured to display the one or more slow-moving materials or missing materials as a result of querying the database.

[0134] 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 corresponding material in the first group;

[0135] 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 priorities of the corresponding materials in the first group.

[0136] 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;

[0137] Wherein, the computer-implemented method further comprises: calculating an adjusted maximum consumption of the corresponding material in the first group based on the adjusted demand for the one or more product components;

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

[0139] Re-determine whether the corresponding materials in the first group are stagnant or short of each other.

[0140] In a third aspect, an embodiment of the present disclosure further provides an apparatus for managing the production of one or more products, including:

[0141] Memory;

[0142] one or more processors;

[0143] 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:

[0144] Obtaining data on multiple downstream materials of one or more materials with shortages for manufacturing one or more product components; the data on the multiple downstream materials of the one or more materials with shortages includes available inventory quantities of the multiple downstream materials;

[0145] Calculating the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with shortages;

[0146] It is determined whether the one or more materials with shortages are in shortage based on the maximum consumption and available inventory of the corresponding materials of the multiple next-level materials.

[0147] In a fourth aspect, an embodiment of the present disclosure further provides a computer program product, comprising a non-transitory tangible computer-readable medium having computer-readable instructions thereon, wherein the computer-readable instructions are executable by a processor to cause the processor to perform:

[0148] Obtaining data on multiple next-level materials of one or more materials with shortages for manufacturing one or more product components; the data on multiple next-level materials of one or more materials with shortages includes available inventory quantities of the multiple next-level materials;

[0149] Calculating the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with shortages;

[0150] It is determined whether the one or more materials with shortages are in shortage based on the maximum consumption and available inventory of the corresponding materials of the multiple next-level materials.

[0151] In a fifth aspect, an embodiment of the present disclosure further provides an apparatus for managing the production of one or more products, including:

[0152] Memory;

[0153] one or more processors;

[0154] 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:

[0155] Receiving a material query instruction input by a user through a first input interface;

[0156] In response to the material query instruction, obtaining data about a plurality of materials used to manufacture one or more product components from a data source, the data about the plurality of materials including available inventory quantities of the plurality of materials;

[0157] calculating a maximum consumption of the plurality of materials relative to at least one product component among the one or more product components;

[0158] It is determined whether there is a shortage of one or more materials for manufacturing one or more product components according to the maximum consumption of corresponding materials of the multiple materials and the available inventory of corresponding materials of the multiple materials.

[0159] In a sixth aspect, an embodiment of the present disclosure further provides a computer program product, comprising a non-transitory tangible computer-readable medium having computer-readable instructions thereon, wherein the computer-readable instructions can be executed by a processor to cause the processor to perform:

[0160] Receiving a material query instruction input by a user through a first input interface;

[0161] In response to the material query instruction, obtaining data on a plurality of materials for manufacturing one or more product components from a data source, wherein the data on the plurality of materials includes available inventory quantities of the plurality of materials;

[0162] calculating a maximum consumption of the plurality of materials relative to at least one product component among the one or more product components;

[0163] It is determined whether there is a shortage of one or more materials for manufacturing one or more product components according to the maximum consumption of corresponding materials of the multiple materials and the available inventory of corresponding materials of the multiple materials.

[0164] Still other aspects will become apparent upon reading and understanding the accompanying drawings and detailed description. BRIEF DESCRIPTION OF THE DRAWINGS

[0165] The accompanying drawings are used to provide an understanding of the technical solutions of the embodiments of the present disclosure and constitute a part of the specification. Together with the embodiments of the present disclosure, they are used to explain the technical solutions of the embodiments of the present disclosure and do not constitute a limitation on the technical solutions of the present disclosure.

[0166] FIG1 is a flowchart of a computer-implemented method according to an embodiment of the present disclosure;

[0167] FIG2 is a flowchart of a computer-implemented method provided by an exemplary embodiment of the present disclosure;

[0168] FIG3a and FIG3b are flowcharts of a computer-implemented method provided by an exemplary embodiment of the present disclosure;

[0169] FIG4 is a schematic diagram showing one or more interfaces provided by an exemplary embodiment of the present disclosure;

[0170] FIG5 is a schematic diagram showing a third output interface provided by an exemplary embodiment of the present disclosure;

[0171] FIG6 is a schematic diagram of a module of an apparatus for managing the production of one or more products according to an embodiment of the present disclosure;

[0172] FIG7 is a schematic structural diagram of an apparatus for managing the production of one or more products provided by an exemplary embodiment of the present disclosure. DETAILED DESCRIPTION

[0173] The embodiments of the present disclosure will be described in detail below with reference to the accompanying drawings. It should be noted that, unless there is a conflict, the embodiments and features in the embodiments of the present disclosure can be combined with each other in any manner.

[0174] Unless otherwise defined, the technical or scientific terms used in the embodiments of the present disclosure should have the ordinary meaning understood by a person of ordinary skill in the field to which the present invention belongs. The words "first", "second" and similar terms used in the embodiments of the present disclosure do not indicate any order, quantity or importance, but are only used to distinguish different components. The words "include" or "comprising" and similar words always include the elements or objects listed after the word and their equivalents, without excluding other elements or objects.

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

[0176] The present disclosure provides a computer-implemented method that may include:

[0177] Receiving a material query instruction input by a user through a first input interface;

[0178] In response to the material query instruction, obtaining data on a plurality of materials for manufacturing one or more product components from a data source, wherein the data on the plurality of materials includes available inventory quantities of the plurality of materials;

[0179] calculating a maximum consumption of the plurality of materials relative to at least one product component among the one or more product components;

[0180] It is determined whether there is a shortage of one or more materials for manufacturing one or more product components according to the maximum consumption of corresponding materials of the multiple materials and the available inventory of corresponding materials of the multiple materials.

[0181] The computer-implemented method provided by the embodiment of the present disclosure receives a material query instruction input by a user through a first input interface; in response to the material query instruction, obtains data about 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; calculates the maximum consumption of the multiple materials relative to at least one product component of the one or more product components; 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 the multiple materials and the available inventory of the corresponding materials of the multiple materials; the technical solution provided by the embodiment of the present disclosure can solve the problem of stagnant or scarce materials in the material management process.

[0182] As shown in FIG1 , the computer-implemented method provided by an embodiment of the present disclosure may include steps 21 to 24:

[0183] Step 21: receiving a material query instruction input by the user through the first input interface;

[0184] Step 22: In response to the material query instruction, obtain data about a plurality of materials for manufacturing one or more product components from a data source, the data about the plurality of materials including available inventory quantities of the plurality of materials;

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

[0186] 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 of the multiple materials and the available inventory of the corresponding materials of the multiple materials.

[0187] In an exemplary embodiment, the data source may be a database, or the data source may be a link address (or database address), and a corresponding database is accessed according to the link address.

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

[0189] The computer-implemented method provided by the embodiment of the present disclosure can, when there is a material shortage during the production of one or more product components, consume the next-level material of the material with the shortage to replenish the shortage material, and judge whether there is a shortage for the replenished material with the shortage. On the one hand, it can maximize the consumption of the next-level material to avoid stagnation of the next-level material, and on the other hand, it can replenish the shortage material in time, which to a large extent solves the problem of material stagnation or shortage in the material management process.

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

[0191] If it is determined in step 24 that there are shortages of multiple materials required to manufacture one or more product components, then steps 241 to 244 are executed:

[0192] Step 241: Determine whether the material with the shortage exists in the next level of material;

[0193] Step 242: When it is determined that the missing material has next-level materials, data of multiple next-level materials of the missing material(s) for manufacturing one or more product components is obtained. The data of multiple next-level materials of the missing material(s) includes available inventory quantities of the multiple next-level materials.

[0194] Step 243: Calculate the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with shortages;

[0195] Step 244: Determine whether there are any shortages of the multiple next-level materials based on the maximum consumption and available inventory of the corresponding materials of the multiple next-level materials.

[0196] 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 also includes substitution relationship information between next-level materials;

[0197] Before obtaining data of multiple next-level materials of the one or more materials with shortages in manufacturing the one or more product components in step 242, the method may further include: identifying one or more materials with shortages in a second group from the one or more materials with shortages based on substitution relationship information between the multiple materials; wherein the one or more materials with shortages in the second group are irreplaceable materials for at least one of the one or more product components;

[0198] Before calculating the maximum consumption of multiple next-level materials relative to at least one material in the one or more materials with shortages in step 243, the method may also include: based on the substitution relationship information between the next-level materials, judging 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 shortages in the second group, wherein the one or more next-level materials in the third group are replaceable materials relative to at least one material in the one or more materials with shortages in the second group, and the one or more next-level materials in the fourth group are irreplaceable materials relative to at least one material in the one or more materials with shortages in the second group.

[0199] In an exemplary embodiment, in step 23, calculating the maximum consumption of the plurality of materials relative to at least one of the one or more product components may include: 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;

[0200] In step 24, judging whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of corresponding materials of the multiple materials and the available inventory of 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 judging 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.

[0201] 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 the one or more product components.

[0202] 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 short supply quantity of the 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.

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

[0204] 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 a shortage in step 243 may include: step 231: calculating the maximum consumption of one or more next-level materials in the fourth group relative to the one or more materials with a shortage in the second group;

[0205] In step 244, determining whether there is a shortage of multiple next-level materials based on the maximum consumption and available inventory of corresponding materials of the multiple next-level materials may include: using the available inventory of one or more next-level materials in the fourth group minus the maximum consumption 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.

[0206] 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 short supply in the second group includes: multiplying the short supply of one or more materials in short supply 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 short supply in the second group, to obtain the maximum consumption of one or more next-level materials in the fourth group relative to one or more materials in short supply in the second group.

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

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

[0209] When it is determined that one or more next-level materials in the fourth group are in short supply, the short supply quantity of the one or more next-level materials in the fourth group is obtained according to the remaining quantity of the one or more next-level materials in the fourth group, and the short supply quantity and short supply status of the one or more next-level materials in the fourth group are displayed through the first output interface;

[0210] 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 the one or more next-level materials in the fourth group are displayed through the first output interface (the material status may include a state where the material just meets the production demand);

[0211] 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 greater than 0, based on the substitution relationship information between the next-level materials, it is determined whether the one or more next-level materials in the fourth group are replaceable materials relative to at least one material in the one or more materials in the first group that have shortages; when it is determined that one or more next-level materials in the fourth group are not replaceable materials relative to the one or more materials in the first group that have shortages, it is determined that there is stagnation in one or more next-level materials in the fourth group, and the stagnation status and remaining quantity of the one or more next-level materials in the fourth group are displayed through the first output interface.

[0212] 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 a shortage in step 243 may include: calculating the maximum consumption of the one or more semi-finished components in the third group relative to the one or more materials with a shortage in the second group using a third linear programming model;

[0213] In step 244, determining whether there is a shortage of multiple next-level materials based on the maximum consumption and available inventory of corresponding materials of the multiple next-level materials may include: using the available inventory of one or more next-level materials in the third group minus the maximum consumption 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.

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

[0215] When it is determined that one or more next-level materials in the third group are in short supply, the short supply quantity of the one or more next-level materials in the third group is obtained based on the remaining quantity of the one or more next-level materials in the third group, and the short supply quantity and short supply status of the one or more next-level materials in the third 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 third group and the remaining quantity is 0, the remaining quantity and material status of the one or more next-level materials in the third group are displayed through the first output interface;

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

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

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

[0220] Among them, x i Represents the amount of corresponding materials in the third group that can be used to prepare the corresponding materials in the second group that are in short supply; d i The value representing the unit consumption of the corresponding next-level materials in the third group relative to one or more corresponding materials in the second group that are missing; N is a positive integer, N≥1.

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

[0222] Among them, Q l Represents the missing quantity of the first missing material in the second group; (Q l ,G j ) represents a set of variables (which can be a set of variables) of the jth group of next-level materials relative to the lth missing material. Multiple next-level materials in the jth group can replace each other in the production of the lth missing material; 0≤x i ≤Q l ; 1≤j≤J, where J represents the total number of groups of next-level materials that can replace each other when producing the lth material with a shortage.

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

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

[0225] In an exemplary embodiment, the data of the plurality of materials may include substitution relationship information between the plurality of materials and demand quantities of one or more product components;

[0226] Before obtaining data of multiple next-level materials for one or more materials with shortages in manufacturing one or more product components in step 242, the method may further include: determining, based on substitution relationship information between the multiple materials, one or more materials in a first group from the multiple materials, the one or more materials in the first group being substitutable materials for at least one of the one or more product components;

[0227] Calculating the maximum consumption of the plurality of materials relative to at least one of the one or more product components in step 23 may include: calculating the maximum consumption of the one or more materials in the first group relative to the one or more product components based on data of the one or more materials in the first group;

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

[0229] In an exemplary embodiment, when determining in step 24 that one or more materials for manufacturing one or more product components are missing, determining whether the missing materials have a next-level material may include: when determining that one or more alternative material groups in the first group are missing relative to the corresponding product components, determining whether the missing material group in the first group has a next-level material;

[0230] In step 242, when it is determined that the missing material has a next-level material, obtaining data of multiple next-level materials of the one or more missing materials for manufacturing one or more product components may include: when it is determined that the missing material group in the first group has a next-level material, obtaining material data of one or more next-level materials of the one or more missing material groups in the first group;

[0231] Calculating the maximum consumption of the plurality of lower-level materials relative to at least one of the one or more materials with shortages in step 243 may include: using the plurality of lower-level materials of the one or more material groups with shortages in the first group as one or more lower-level materials in the fifth group, and calculating, based on the material data of the one or more lower-level materials in the fifth group, the maximum consumption of the one or more lower-level materials in the fifth group relative to the product components corresponding to the one or more material groups with shortages in the first group;

[0232] In step 244, determining whether there are shortages of multiple next-level materials based on the maximum consumption and available inventory of the corresponding materials of the 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 one or more next-level materials in the fifth group relative to the product components corresponding to one or more corresponding material groups with shortages in the first group, and determining whether there are shortages 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.

[0233] In an exemplary embodiment, when determining that one or more alternative material groups in the first group are short of corresponding product components, the method may further include: calculating the shortfall of the one or more alternative material groups in the first group relative to the corresponding product components based on the satiable quantity of the one or more alternative material groups in the first group relative to the corresponding product components and the demand quantity of the shortfall material in the first group;

[0234] When determining that one or more lower-level materials in the fifth group are missing, the following may also be included:

[0235] Step H1: Calculate a sixth deficiency value based on the available quantity of the corresponding material with a deficiency in the first group prepared by one or more lower-level materials in the fifth group and the deficiency quantity of the corresponding material group with a deficiency in the first group, and use the sixth deficiency value to update the deficiency quantity of the corresponding material group with a deficiency in the first group;

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

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

[0238] When it is determined that one or more next-level materials in the fifth group are in short supply, the short supply quantity of the one or more next-level materials in the fifth group is obtained based on the remaining quantity of the one or more next-level materials in the fifth group, and the short supply quantity and short supply status of the one or more next-level materials in the fifth group are displayed through the first output interface;

[0239] When it is determined that there is no shortage of 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 the one or more next-level materials in the fifth group are output through the first display interface;

[0240] When it is determined that there is no shortage of 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.

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

[0242] When it is determined that one or more next-level materials in the fifth group have shortages, the configuration parameters of the next-level materials are obtained, and the shortage quantities of the shortage materials in the corresponding next-level material groups with shortages in the fifth group are reallocated according to the configuration parameters of the next-level materials. The shortage quantities of the corresponding next-level materials in the fifth group are updated using the reallocated shortage quantities, and the updated shortage quantities and shortage status of the corresponding next-level materials in the fifth group are displayed through the first output interface.

[0243] In an exemplary embodiment, the method may further include: when it is determined that one or more next-level materials in the fifth group are in short supply, obtaining the configuration parameters of the next-level materials, reallocating the short supply quantities of the corresponding next-level materials in the fifth group that are in short supply according to the configuration parameters of the next-level materials, and using the reallocated short supply quantities to update the short supply quantities of the corresponding next-level materials in the fifth group.

[0244] In an exemplary embodiment, the method may further include: when it is determined that the missing material does not have a next-level material, displaying the missing status of the missing material (or the missing quantity of the missing material, or the missing status and the missing quantity of the missing material) through the first output interface;

[0245] When it is determined that there is no shortage of one or more materials for manufacturing one or more product components, the material information of one or more materials for manufacturing 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).

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

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

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

[0249] In an exemplary embodiment, the 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 on a plurality of materials;

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

[0251] The one or more conditions include at least one of a stagnant state of stagnant materials and a shortage state of shortage materials;

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

[0253] In an exemplary embodiment, the 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 the corresponding material in the first group;

[0254] 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 priorities of the corresponding materials in the first group.

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

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

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

[0258] Re-determine whether there is any slow-moving or missing corresponding materials in the first group.

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

[0260] Receiving a material status query instruction input by a user through a first input interface;

[0261] In response to the instruction to query the material status, at least one of the remaining quantity, stagnant status, shortage status and shortage quantity of multiple materials used to manufacture one or more product components and multiple next-level materials of the multiple materials is obtained from the database.

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

[0263] In an exemplary embodiment, the above-mentioned material query instruction can be understood as querying the material status after the production of the product components with corresponding requirements. After receiving the material query instruction input by the user, the processor can perform data processing based on the materials for preparing the product components and the next-level materials of the materials to obtain the stagnant or missing status and the stagnant or missing quantity of the corresponding materials; the above-mentioned material query status instruction can be understood as querying the material information of the materials for preparing one or more product components and the next-level materials (such as including the stagnant or missing status, the stagnant or missing quantity). The queried material information can be the stagnant or missing status and the stagnant or missing quantity of the corresponding materials obtained after the processor responds to the above-mentioned material query instruction (there is no need to process the material data again, and simply querying the processed material data can improve the query efficiency), or it can be the material-related information before responding to the above-mentioned 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).

[0264] The present disclosure also provides a computer-implemented method, which may include:

[0265] Obtaining data on multiple downstream materials of one or more materials with shortages for manufacturing one or more product components; the data on multiple downstream materials of one or more materials with shortages includes available inventory quantities of the multiple downstream materials;

[0266] Calculate the maximum consumption of multiple lower-level materials relative to at least one of the one or more materials with shortages;

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

[0268] The computer-implemented method provided by the embodiment of the present disclosure obtains data of multiple next-level materials of one or more materials with shortages in manufacturing one or more product components, calculates the maximum consumption of the multiple next-level materials relative to at least one material of the one or more materials with shortages, and determines whether the one or more materials with shortages are shortages based on the maximum consumption of the corresponding materials of the multiple next-level materials and the available inventory. When there is a material shortage in the process of producing one or more product components, the next-level materials of the materials with shortages are consumed to replenish the shortage materials, and the replenished materials with shortages are determined whether there is a shortage. On the one hand, the consumption of the next-level materials can be maximized to avoid stagnation of the next-level materials. On the other hand, the shortage materials can be replenished in time, which largely solves the problem of stagnation or shortage of materials in the material management process.

[0269] In an exemplary embodiment, a product component may be any product produced from a plurality of materials. Examples of product components may include semiconductor products, electronic products, chemical products, mechanical assembly products, etc. In an exemplary embodiment, a product component is not limited to a finished product and may include a finished product or a semi-finished product.

[0270] As shown in FIG2 , a flowchart of a computer-implemented method provided in an embodiment of the present disclosure may include steps 11 to 13:

[0271] Step 11: Obtain data on multiple downstream materials of one or more materials with shortages for manufacturing one or more product components; the data on multiple downstream materials of one or more materials with shortages includes available inventory quantities of the multiple downstream materials;

[0272] Step 12: Calculate the maximum consumption of multiple lower-level materials relative to at least one of the one or more materials with shortages;

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

[0274] In an exemplary embodiment, before obtaining data of multiple next-level materials for one or more materials with deficiencies in manufacturing one or more product components in step 11, the following steps may also be included:

[0275] Step 01: Obtain data on multiple materials used to manufacture one or more product components, where the data on the multiple materials includes available inventory quantities of the multiple materials;

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

[0277] 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 of the multiple materials and the available inventory of the corresponding materials of the multiple materials.

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

[0279] When it is determined in step 03 that multiple materials for manufacturing one or more product components are missing, determine whether the missing materials have the next level of materials.

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

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

[0282] In step 11, before obtaining data on multiple next-level materials of one or more materials with shortages in manufacturing one or more product components, it can also include: judging one or more materials with shortages in the second group from the one or more materials with shortages based on the substitution relationship information between the multiple materials; wherein the one or more materials with shortages in the second group are irreplaceable materials with respect to at least one product component in the one or more product components.

[0283] In an exemplary embodiment, the data of the plurality of next-level materials may further include substitution relationship information between the next-level materials;

[0284] Before calculating the maximum consumption of multiple next-level materials relative to at least one material in the one or more materials with shortages in step 12, the method may also include: based on the substitution relationship information between the next-level materials, judging 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 shortages in the second group, wherein the one or more next-level materials in the third group are replaceable materials relative to at least one material in the one or more materials with shortages in the second group, and the one or more next-level materials in the fourth group are irreplaceable materials relative to at least one material in the one or more materials with shortages in the second group.

[0285] In an exemplary embodiment, in step 02, calculating the maximum consumption of multiple materials relative to at least one product component in 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; in step 03, judging whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of corresponding materials of the multiple materials and the available inventory of 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 judging 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.

[0286] 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 short supply quantity of the 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.

[0287] In an exemplary embodiment, in step 02, calculating the maximum consumption of the plurality of materials relative to at least one of the one or more product components may include: calculating the maximum consumption of the one or more materials in short supply in the second group relative to at least one of the one or more product components;

[0288] In step 03, determining whether one or more materials for manufacturing one or more product components are in short supply based on the maximum consumption of corresponding materials among the multiple materials and the available inventory of corresponding materials among the multiple materials may include: calculating the remaining quantity of the one or more materials in the second group that are in short supply based on the available inventory of the one or more materials in the second group that are in short supply and the maximum consumption of the one or more materials in the second group that are in short supply, and determining whether the one or more materials in the second group that are in short supply are in short supply based on the remaining quantity of the one or more materials in the second group that are in short supply;

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

[0290] In an exemplary embodiment, the data of the next-level materials may further include values ​​of unit consumption of the multiple next-level materials for manufacturing the one or more materials in short supply in the second group;

[0291] In step 12, calculating the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with a shortage may include: multiplying the shortage of the one or more materials with a shortage in the second group that require the one or more next-level materials in the fourth group as irreplaceable materials by the sum of the unit consumption of the corresponding next-level materials in the fourth group for manufacturing the one or more materials with a shortage in the second group, to obtain the maximum consumption of the one or more next-level materials in the fourth group relative to the one or more materials with a shortage in the second group;

[0292] In step 13, judging whether one or more materials with shortages are in short supply based on the maximum consumption and available inventory of corresponding materials of multiple next-level materials may include: using the available inventory of one or more next-level materials in the fourth group minus the maximum consumption 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, determining that one or more materials in the fourth group are in short supply.

[0293] 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: judging, based on the substitution relationship information between the next-level materials, whether one or more next-level materials in the fourth group are substitutable materials relative to at least one of the one or more materials in short supply in the first group.

[0294] In an exemplary embodiment, when it is determined that one or more next-level materials in the fourth group are not alternative materials relative to one or more materials in short supply in the first group, it is determined that one or more next-level materials in the fourth group are stagnant.

[0295] 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: using the remaining quantity of one or more next-level materials in the fourth group to update the available inventory of the corresponding next-level materials in the fourth group.

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

[0297] In step 13, judging whether one or more materials with shortages are in short supply based on the maximum consumption and available inventory of corresponding materials of multiple next-level materials may include: using the available inventory of one or more next-level materials in the third group minus the maximum consumption 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, determining that one or more next-level materials in the third group are in short supply.

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

[0299] Among them, x i Represents the amount of corresponding materials in the third group that can be used to prepare the corresponding materials in the second group that are in short supply; d i The value representing the unit consumption of the corresponding next-level materials in the third group relative to one or more corresponding materials in the second group that are missing; N is a positive integer, N≥1.

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

[0301] Among them, Q l Represents the missing quantity of the first missing material in the second group; (Q l ,G j ) represents a set of variables (which can be a set of variables) of the jth group of next-level materials relative to the lth missing material. Multiple next-level materials in the jth group can replace each other in the production of the lth missing material; 0≤x i ≤Q l ; 1≤j≤J, where J represents the total number of groups of next-level materials that can replace each other when producing the lth material with a shortage.

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

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

[0304] In an exemplary embodiment, the data of the plurality of materials includes substitution relationship information between the plurality of materials and demand quantities of one or more product components;

[0305] In step 11, before obtaining data of multiple next-level materials of one or more materials with shortages in manufacturing one or more product components, the method may further include: determining, based on substitution relationship information between the multiple materials, one or more materials in a first group from the multiple materials, the one or more materials in the first group being substitutable materials for at least one of the one or more product components;

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

[0307] In step 03, judging whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of corresponding materials of the multiple materials and the available inventory of corresponding materials of the multiple materials can include: obtaining the satiable quantity of one or more alternative material groups in the first group relative to the one or more product components when the consumption of one or more materials in the first group relative to the one or more product components is the maximum consumption, and judging whether there is a shortage of one or more alternative material groups in the first group relative to the corresponding product components based on the satiable quantity of one or more alternative 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.

[0308] In an exemplary embodiment, when determining that multiple materials for manufacturing one or more product components are missing, determining whether the missing materials have next-level materials may include: when determining that one or more alternative material groups in the first group are missing relative to the corresponding product components, determining whether the missing material group in the first group has next-level materials;

[0309] When it is determined that the next-level material exists for the material with a shortage, obtaining data on multiple next-level materials of one or more materials with a shortage in manufacturing one or more product components may include: when it is determined that the next-level material exists for the material group with a shortage in the first group, obtaining material data on one or more next-level materials of the one or more material groups with a shortage in the first group.

[0310] In an exemplary embodiment, in step 12, calculating the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with a shortage may include: using the plurality of next-level materials of the one or more material groups with a shortage in the first group as one or more next-level materials in the fifth group, and calculating, based on the material data of the one or more next-level materials in the fifth group, the maximum consumption of the one or more next-level materials in the fifth group relative to the product components corresponding to the one or more material groups with a shortage in the first group;

[0311] In step 13, judging whether one or more materials with shortages are in short supply based on the maximum consumption and available inventory of 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 one or more next-level materials in the fifth group relative to the product components corresponding to one or more corresponding material groups with shortages in the first group, and judging whether one or more next-level materials in the fifth group are in short supply based on the remaining quantity of one or more next-level materials in the fifth group.

[0312] In an exemplary embodiment, when determining that one or more alternative material groups in the first group are short of corresponding product components, the method may further include: calculating the shortfall of the one or more alternative material groups in the first group relative to the corresponding product components based on the satiable quantity of the one or more alternative material groups in the first group relative to the corresponding product components and the demand quantity of the shortfall material in the first group;

[0313] When it is determined that one or more next-level materials in the fifth group are in short supply, the method may further include: calculating a sixth short supply value based on the available quantity of the corresponding materials in the first group that are in short supply prepared by the one or more next-level materials in the fifth group and the short supply quantity of the corresponding material group in the first group that is in short supply, and updating the short supply quantity of the corresponding material group in the first group that is in short supply using the sixth short supply value;

[0314] Get the configuration parameters, reallocate the missing quantities of the missing materials in the corresponding material groups with shortages in the first group according to the configuration parameters, and use the reallocated missing quantities to update the missing quantities of the corresponding materials in the first group.

[0315] In an exemplary embodiment, the method may also include: when determining that one or more next-level materials in the fifth group are short of, obtaining the configuration parameters of the next-level materials, reallocating the short quantity of the corresponding next-level materials in the fifth group that are short of according to the configuration parameters of the next-level materials, and using the reallocated short quantity to update the short quantity of the corresponding next-level materials in the fifth group.

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

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

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

[0319] In an exemplary embodiment, the 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 on a plurality of materials;

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

[0321] The one or more conditions may include at least one of a stagnant state of stagnant materials and a shortage state of shortage materials;

[0322] The one or more user interfaces may further include a second output interface configured to display one or more slow-moving materials or missing materials as a result of querying the database.

[0323] In an exemplary embodiment, the 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 the corresponding material in the first group;

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

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

[0326] Among them, the computer-implemented method may also 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 sluggish or shortage of the corresponding materials in the first group.

[0327] In an exemplary embodiment, the computer-implemented method may further include: adjusting demand for one or more product components to minimize the obsolete or shortage of the next-level materials when one or more materials that are in short supply are determined to be obsolete or shortage based on the maximum consumption and available inventory of the corresponding materials of multiple next-level materials; and producing the one or more product components based on the adjusted demand for the one or more product components. By adjusting demand for the one or more product components, the amount of materials required to produce the product components and the amount of shortage or obsolete materials of the next-level materials of the materials used to produce the product components can be reduced.

[0328] In an exemplary embodiment, when the maximum consumption of corresponding materials of multiple next-level materials is greater than the available inventory, it is determined that one or more materials with shortages are still short after the shortages are replenished using the next-level materials; when the maximum consumption of corresponding materials of multiple next-level materials is equal to the available inventory, it is determined that one or more materials with shortages just meet the demand of product components after the shortages are replenished using the next-level materials; when the maximum consumption of corresponding materials of multiple next-level materials is less than the available inventory, it is determined that one or more materials with shortages are stagnant after the shortages are replenished using the next-level materials.

[0329] The following is an exemplary description of the computer-implemented method provided by an embodiment of the present disclosure. A computer-implemented method provided by an embodiment of the present disclosure can be applied to material management in a product production process. In an exemplary embodiment, as shown in FIG3a and FIG3b , the computer-implemented method provided by an embodiment of the present disclosure can include steps 101 to 125:

[0330] Step 101: Obtain data of a plurality of materials used to manufacture one or more product components.

[0331] In an exemplary embodiment, before manufacturing (or producing) one or more product components, data for all materials used to manufacture the one or more product components may be input into a storage device. For example, data for all materials may be input into the storage device by scanning using a scanning device connected to the storage device, or a user may manually input data for all materials into the storage device, or a portion of the material data may be manually input into the storage device by the user and a portion of the material data may be scanned into the storage device using a scanning device. In an embodiment of the present disclosure, data for multiple materials input into the storage device may be displayed via a graphical user interface.

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

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

[0334] Table 1

[0335] 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 manufacture 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 the one or more product components. The same material may have different unit consumptions for different product components. For example, product components with product numbers PRO-1 and PRO-2 can both use material A as an ingredient in production (an ingredient in production can be understood as a material used to manufacture the product component). The unit consumption of material A relative to product component PRO-1 is 1, while the unit consumption of material A relative to product component PRO-2 is 2. In an exemplary embodiment, the unit consumption may be the ratio of the amount of material (measured by weight, moles, or number of pieces) required to produce a certain amount of the product component to the amount of the product component.

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

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

[0338] In an exemplary embodiment, the same alternative group may include multiple materials of different priorities. For example, the same alternative group may include a first material and a second material. The first material may have a higher priority than the second material, and when producing the corresponding product, the first material will be used in preference to the second material with a lower priority within the same alternative group. For example, when producing a component for product number PRO-1, if material A has a priority of 1 and material B has a priority of 2, material A will be used as the first material and material B as the second material, with material A being used in preference to material B. In Table 1, within the same alternative group, a lower priority number indicates a higher priority.

[0339] In an exemplary embodiment, as shown in Table 1, data on multiple materials used to manufacture one or more products may also 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 by stage, such as by month, or the demand quantity for each of the multiple product components may be listed at the current stage. For example, the demand quantity for the product component with product number PRO-1 is 20,000, the demand quantity for the product component with product number PRO-2 is 3,000, the demand quantity for the product component with product number PRO-3 is 1,000, and the demand quantity for the 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.

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

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

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

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

[0344] In an exemplary embodiment, the same material may be in the first group for one product component but in the second group for another product component. Thus, the first and second groups may intersect. For example, material A may be in the first group for product PRO-1 but in the second group for product PRO-2.

[0345] In an exemplary embodiment, referring to Table 4, each material in the second group may be assigned a "null" value for the alternative group (ie, the alternative group identifier of the material in the second group is set to a null value) and may be assigned "0" for the priority.

[0346] Step 103: extracting data of materials in the second group from a plurality of material data for manufacturing one or more product components according to the substitution relationship information between the plurality of materials.

[0347] In an exemplary embodiment, data of materials in the second group (ie, data of necessary materials or data of irreplaceable materials) are extracted from the data of multiple materials for manufacturing one or more product components in Table 1 as shown in Table 2:

[0348] Table 2

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

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

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

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

[0353] In an exemplary embodiment, the maximum consumption of a material 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 PRO-1 (20,000) multiplied by the unit consumption of material E relative to PRO-1 (4). This yields a consumption of material E relative to product PRO-1 of 20,000*4. Products PRO-2 and PRO-3 in the second group do not consume material E, meaning that the consumption of material E relative to these products is zero. 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: 20,000*4+0+0=80,000. By analogy, 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.

[0354] Step 105: Calculate the remaining quantity of the one or more materials in the second group according to the available inventory quantity and the maximum consumption quantity of the one or more materials in the second group.

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

[0356] In an exemplary embodiment, if the remaining quantity of one or more materials in the second group is greater than 0, it means that the material still has surplus after meeting the product production demand; 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 demand; 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 demand, that is, there is a shortage of the material.

[0357] In an exemplary embodiment, the available inventory of one or more materials in the second group can be used as the inventory of the materials in Table 2. As shown in Table 2, the maximum consumption of material E is 20,000*4, and the inventory of material E is 2,500. Subtracting the maximum consumption of material E (20,000*4) from the inventory of material E (2,500) yields the remaining quantity of material E in the second group: 2,500 - 20,000*4 = -77,500. Similarly, the remaining quantity of material A is 5,000 - 3,000*2 = -1,000, the remaining quantity of material F is 2,000 - 3,000*2 = -4,000, and the remaining quantity of material G is 2,000 - 1,000*3 = -1,000. In Table 2, the remaining quantities of materials A, E, F, and G in the second group are less than 0, indicating that there are shortages of materials A, E, F, and G, with the shortages being 1,000, 77,500, 4,000, and 1,000, respectively.

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

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

[0360] In an exemplary embodiment, 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 may include: obtaining the satiable quantity of one or more materials in the second group relative to one or more product components 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 satiable quantity of one or more materials in the second group relative to the one or more product components and the demand for one or more product components.

[0361] Step 107: Determine whether there are semi-finished components for the missing material in the second group. If so, execute step 108; otherwise, use the remaining quantity of the missing material in the second group to update the inventory quantity of the corresponding missing material in the second group.

[0362] In an exemplary embodiment, the semi-finished component may be a next-level material for which there is a shortage of material.

[0363] In an exemplary embodiment, it can be seen from Table 2 that materials A, E, F, and G all have shortages, among which materials A and E do not have semi-finished product components, while materials F and G have semi-finished product components. Then, the shortages of materials A and E are used, and the shortage quantities are 1000 and 77500 respectively. The remaining quantity of material A is -1000 to update the inventory quantity of material A (after the update, the inventory quantity of material A becomes -1000), and the remaining quantity of material E is -77500 to update the inventory quantity of material E (after the update, the inventory quantity of material E becomes -77500).

[0364] Step 108: Obtain material data of the semi-finished components of one or more materials that are missing in the second group.

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

[0366] Table 3

[0367] As shown in Table 3, semi-finished components PCB-1 and PCB-2 are in the same substitution group D4. When preparing material F, semi-finished components PCB-1 and PCB-2 can replace each other. Semi-finished components PCB-2 and PCB-5 are in the same substitution group D5. When preparing material G, semi-finished components PCB-2 and PCB-5 can replace each other. The substitution group of semi-finished component PCB-10 is empty and its priority is 0. Therefore, semi-finished component PCB-10 is a required material for material F. Semi-finished component PCB-2 can be used to prepare materials F and G. Therefore, semi-finished component PCB-2 is a common material for spare materials F and G.

[0368] Step 109: Obtain substitution relationship information between semi-finished components from the material data of the semi-finished components of one or more materials that are missing in the second group, and determine one or more semi-finished components of the third group and one or more semi-finished components of the fourth group from the multiple semi-finished components of the one or more materials that are missing in the second group based on the substitution relationship information of the semi-finished components.

[0369] In an exemplary embodiment, determining one or more semi-finished components in a third group and one or more semi-finished components in a fourth group from the plurality of semi-finished components of the missing material in the second group based on the substitution relationship information of the semi-finished components may include: obtaining substitution group identifiers of the plurality of semi-finished components of the missing material in the second group from the material substitution relationship information between the plurality of semi-finished components; and determining one or more semi-finished components in the third group and one or more semi-finished components in the fourth group from the plurality of semi-finished components based on the substitution group identifiers of the plurality of semi-finished components. In the exemplary embodiment, the one or more semi-finished components in the third group are substitutable for at least one of the one or more missing materials in the second group, and the one or more semi-finished components in the fourth group are non-substitutable for at least one of the one or more missing materials in the second group. As shown in Table 3, the substitution group for semi-finished component PCB-10 is empty and has a priority of 0. During the preparation of material F, semi-finished component PCB-10 is a non-substitutable material and is therefore 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, while the substitution group for PCB-2 and PCB-5 is D5. Therefore, PCB-1, PCB-2, and PCB-5 are substitutable materials and are classified as semi-finished components in the fourth group of materials with shortages in the second group. For example, PCB-1 and PCB-2 are substitutable materials for the preparation of material F, while PCB-2 and PCB-5 are substitutable materials for the preparation of material G.

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

[0371] 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 that are missing in the second group based on the material data of one or more semi-finished components in the fourth group can include: multiplying the missing quantities 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 that are missing in the second group, to obtain the maximum consumption of one or more product components in the fourth group relative to one or more materials that are missing in the second group.

[0372] As shown in Table 3, material data for the semi-finished component PCB-10 in the second group of missing materials is obtained from the material data for multiple semi-finished components in the second group of missing materials. This data includes the missing quantity of the missing material F in the second group for which the semi-finished component PCB-10 is required as an irreplaceable material, the unit consumption of the semi-finished component PCB-10 relative to the missing material F in the second group, and the inventory level of the semi-finished component PCB-10. The missing quantity of the missing material F in the second group for which the semi-finished component PCB-10 is required as an irreplaceable material (4000) multiplied by the unit consumption of the semi-finished component PCB-10 relative to the missing material F in the second group (1) yields the consumption of the semi-finished component PCB-10 relative to the missing material F in the second group of 4000. Since material F in Table 3 does not share the semi-finished component PCB-10 with other materials, the maximum consumption of the semi-finished component PCB-10 in the second group of missing materials is 4000.

[0373] Step 111: Use the inventory of one or more semi-finished components in the fourth group minus the maximum consumption of one or more semi-finished components in the fourth group relative to one or more materials with shortages in the second group to obtain the remaining quantity of one or more semi-finished components in the fourth group, and use the remaining quantity of one or more semi-finished components in the fourth group to update the inventory of one or more semi-finished components in the fourth group.

[0374] In an exemplary embodiment, as shown in Table 3, the remaining quantity of semi-finished components PCB-10 in the fourth group (-3000) is calculated by subtracting the maximum consumption of semi-finished components PCB-10 in the fourth group (-1000) for the missing material F in the second 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 a surplus of these semi-finished components after they have been used to fill the missing quantity of the material F in the second group. If the remaining quantity of semi-finished components in the fourth group is equal to 0, it means that these semi-finished components are just enough to fill the missing quantity of the material F in the second group. If the remaining quantity of semi-finished components in the fourth group is less than 0, it means that these semi-finished components are just insufficient to fill the missing quantity of the material F in the second group. If the remaining quantity of semi-finished components PCB-10 in the fourth group (-3000) is less than 0, it means that there is a shortage of 3000 semi-finished components PCB-10.

[0375] 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 components have no shortages and can make up for 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 components have shortages and cannot make up for the corresponding materials with shortages in the second group.

[0376] In an exemplary embodiment, when multiple materials with shortages in the second group 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 of the semi-finished component.

[0377] 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 less than 0, determining that one or more materials in the fourth group are short. In an exemplary embodiment, when determining that one or more materials in the fourth group are short, the process may further include: displaying the shortfall status and shortfall quantity of the one or more materials in the fourth group via the first output interface. In an exemplary embodiment, the shortfall quantity may be a negative number of the remaining quantity, in which case a positive number indicates a shortfall; or the shortfall quantity may be equal to the remaining quantity, in which case a negative number indicates a shortfall.

[0378] 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 whether the one or more next-level materials in the fourth group are substitutable for at least one of the one or more materials in the first group that are in short supply, based on the substitution relationship information between the next-level materials; and when it is determined that the one or more next-level materials in the fourth group are not substitutable for the one or more materials in the first group that are in short supply, determining that the one or more next-level materials in the fourth group are stagnant. In an exemplary embodiment, when it is determined that the one or more next-level materials in the fourth group are stagnant, the process may further include: displaying the stagnant status and remaining quantity of the one or more next-level materials in the fourth group via the first output interface.

[0379] Step 112: Obtain the material data of one or more semi-finished components of the third group from the material data of the semi-finished components of the one or more materials with shortages in the third group based on the substitution relationship information between the multiple semi-finished components of the one or more materials with shortages in the third group, and calculate the maximum consumption of one or more semi-finished components in the third group relative to one or more materials with shortages in the second group based on the material data of the one or more semi-finished components in the third group.

[0380] In an exemplary embodiment, calculating the maximum consumption of one or more semi-finished components in the third group relative to one or more missing materials in the second group based on the data of the materials 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 missing materials in the second group.

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

[0382] Among them, x i Represents the amount of the corresponding material in short supply in the second group that can be produced using the corresponding semi-finished components in the third group (i.e., the amount that can be satisfied by one or more semi-finished components in the third group to produce the corresponding material in short supply in the second group); d i The value representing the unit consumption of the corresponding semi-finished components in the third group relative to one or more corresponding materials with deficiencies in the second group; N is a positive integer representing the total number of corresponding semi-finished components in the third group, N≥1.

[0383] 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 the corresponding materials in short supply in the second group from one or more semi-finished components in the third group are set as follows: the available quantity of material F from the semi-finished component PCB-1 is set to x1, the available quantity of material F from the semi-finished component PCB-2 is set to x2, the available quantity of material G from the semi-finished component PCB-2 is set to x3, and the available quantity of material G from the semi-finished component PCB-5 is set to x4; the unit consumption of the semi-finished component PCB-1 relative to material F is 2, and the unit consumption of the semi-finished component PCB-2 relative to material F is x2. The unit consumption of the semi-finished component PCB-2 relative to the material G is 2, and the unit consumption of the semi-finished component PCB-5 relative to the material G is 1. The linear programming model is used to calculate the maximum consumption of one or more semi-finished components in the third group: the maximum consumption of the semi-finished component PCB-1 relative to the material F is 2*x1, the maximum consumption of the semi-finished component PCB-2 relative to the material F is 2*x2, the maximum consumption of the semi-finished component PCB-2 relative to the material G is 1*x3, and the maximum consumption of the semi-finished component PCB-5 relative to the 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.

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

[0385] Among them, Q l represents the shortage quantity (i.e. demand quantity) of the first shortage material in the second group; (Q l ,G j ) represents a set of variables (which can be a set of variables) of the jth group of semi-finished components relative to the lth missing material. Multiple semi-finished components in the jth group can replace each other in the production of the lth missing material; 0≤x i ≤Q l ; 1≤j≤J, where J represents the total number of groups of semi-finished components that can replace each other when producing the lth material with a defect.

[0386] In an exemplary embodiment, the first constraint function of the third objective function can be understood as a constraint on the shortage quantity of the corresponding materials in the second group that are in shortage (i.e., the demand quantity of the corresponding materials in the second group that are in shortage). As shown in Table 3, there is a shortage of materials F and G (i.e., the value of l is 2), the shortage quantity Q1 of material F is 4000, the shortage quantity 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 components PCB-1 and semi-finished components PCB-2), and 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 components PCB-2 and semi-finished components PCB-5). The constraint on the shortage quantity of the corresponding materials in the second group that are in shortage is as follows:

[0387] The constraint for the missing material F in the second group is: x1+x2≤4000;

[0388] The constraint on the missing material G in the second group is: x3+x4≤1000.

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

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

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

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

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

[0394] The inventory constraint on the semi-finished component PCB-5 is: x4≤300.

[0395] In an exemplary embodiment, the third linear programming model is used to calculate the maximum consumption of one or more semi-finished components in the third group relative to one or more materials in short supply in the second group. 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 total maximum consumption (Max3) of one or more semi-finished components in the third group are obtained. This can minimize the inventory of semi-finished components and make up for the short supply 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.

[0396] Step 113: Calculate 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 of one or more semi-finished components in the third group relative to one or more corresponding materials in short supply in the second group, and use the remaining quantity of one or more semi-finished components in the third group to update the inventory quantity of one or more semi-finished components in the third group.

[0397] In an exemplary embodiment, in step 113, 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 third group and the maximum consumption of one or more semi-finished components in the third group relative to one or more corresponding materials with shortages in the second group may include: using the inventory of one or more semi-finished components in the third group, subtracting the maximum consumption of one or more semi-finished components in the third group relative to one or more corresponding materials with shortages in the second group, to obtain the remaining quantity of one or more semi-finished components in the third group.

[0398] In an exemplary embodiment, step 113 may also 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 the one or more semi-finished components in the third group can make up for the shortfall of one or more missing materials in the second group; otherwise, determining that the one or more semi-finished components in the third group cannot make up for the shortfall of one or more missing materials in the second group.

[0399] Take the consumption of semi-finished components PCB-1 and semi-finished components PCB-2 for replenishing the shortage of material F in Table 3 as an example: the priority of semi-finished component PCB-1 is 1, and the priority of semi-finished component PCB-2 is 2, then the semi-finished component PCB-1 is used first to replenish the shortage of material F, and the inventory of semi-finished component PCB-1 is 1000 minus the maximum consumption of the material with shortage of semi-finished component PCB-1 relative to material F, 2x1, and the remaining quantity of semi-finished component PCB-1 is 1000-2x1. When 1000-2x1 is greater than or equal to 0, it means that the semi-finished component PCB-1 can make up for the shortage of material F, and the shortage of material F can be made up without consuming semi-finished component PCB-2; when 1000-2x1 is less than 0, it means that the semi-finished component PCB-1 cannot make up for the shortage of material F, and the semi-finished component PCB-2 is used to replenish the shortage of material F, and the semi-finished component PCB-2 is used to replenish the shortage of material F. The available quantity (x2) of material F prepared in B-2 is equal to the shortage quantity of material F (4000) minus the available quantity (x1) of material F prepared by the semi-finished component PCB-1. The inventory quantity of the semi-finished component PCB-2, 1000, is subtracted from the maximum consumption quantity 2x2 of the semi-finished component PCB-2 for the material F that is in shortage. The remaining quantity of the semi-finished component PCB-2 is 1000-2x2=1000-2(4000-x1). If the remaining quantity of the semi-finished component PCB-2, 1000-2x2, is greater than or equal to 0, it means that the semi-finished component PCB-2 and the semi-finished component PCB-1 can make up for the shortage of material F, and there is no shortage of the semi-finished components in the third group of prepared material F. If the remaining quantity of the semi-finished component PCB-2 is 1000-2x2, which is less than 0, it means that the semi-finished component PCB-2 and the semi-finished component PCB-1 cannot make up for the shortage of material F, and there is a shortage of the semi-finished components in the third group of prepared material F.

[0400] 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 the corresponding semi-finished components in the third group have shortages when preparing the corresponding materials with shortages in the second group. If the updated inventory quantity is greater than or equal to 0, it indicates that there are no shortages of the corresponding semi-finished components in the third group. If the updated inventory quantity is less than 0, it indicates that there are shortages of the corresponding semi-finished components in the third group. When there are shortages, the inventory quantity is a negative number, and the absolute value of the inventory quantity is the shortage quantity.

[0401] In an exemplary embodiment, the consumption of the semi-finished component PCB-1 when preparing material F is used as an example: after the semi-finished component PCB-1 is used to make up for the shortage of material F, the remaining quantity of the semi-finished component PCB-1 is 1000-2x1. The inventory quantity of the semi-finished component PCB-1 can be updated from 1000 to 1000-2x1 to avoid the inventory quantity of the semi-finished component (PCB-1) being higher than the actual inventory quantity, thereby effectively managing the materials of the semi-finished component.

[0402] Step 114: Calculate a third deficiency value based on the available quantity of the corresponding material with shortage in the second group prepared by one or more semi-finished components in the third group and the shortage quantity of the corresponding material with shortage in the second group; calculate a fourth deficiency value based on the available quantity of the corresponding material with shortage in the second group prepared by one or more semi-finished components in the fourth group and the shortage quantity of the corresponding material with shortage in the second group; determine a second deficiency value of the corresponding material in the second group based on the third deficiency value and the fourth deficiency value; and use the second deficiency value to update the shortage quantity of the corresponding material with shortage in the second group.

[0403] In an exemplary embodiment, calculating a third shortfall value based on the available quantity of one or more semi-finished components in the third group for preparing the corresponding material with a shortage in the second group and the shortage quantity of the corresponding material with a shortage in the second group, and calculating a fourth shortfall value based on the available quantity of one or more semi-finished components in the fourth group for preparing the corresponding material with a shortage in the second group and the shortage quantity of the corresponding material with a shortage in the second group may include: subtracting the available quantity of one or more semi-finished components in the third group for preparing the corresponding material with a shortage in the second group from the shortage quantity of the corresponding material with a shortage in the second group, to obtain the third shortfall value of the corresponding material in the second group; and subtracting the available quantity of one or more semi-finished components in the fourth group for preparing the corresponding material with a shortage in the second group from the shortage quantity of the corresponding material with a shortage in the second group, to obtain the fourth shortfall value of the corresponding material in the second group.

[0404] Among them, the quantity that can be satisfied by one or more semi-finished components in the third group for preparing the corresponding materials with shortages in the second group is equal to the ratio of the inventory of one or more semi-finished components in the third group to the unit consumption of one or more semi-finished components in the third and fourth groups relative to the corresponding materials with shortages in the second group, which is rounded down to an integer data; the quantity that can be satisfied by one or more semi-finished components in the fourth group for preparing the corresponding materials with shortages in the second group is equal to the ratio of the inventory of one or more semi-finished components in the fourth group to the unit consumption of one or more semi-finished components in the fourth group relative to the corresponding materials with shortages in the second group, which is rounded down to an integer data.

[0405] In an exemplary embodiment, determining the second deficiency value of the corresponding material in the second group based on the third deficiency value and the fourth deficiency value may include: when the third deficiency value and the fourth deficiency value of the same material with a deficiency in the second group are the same, using the third deficiency value and the fourth deficiency value as the second deficiency value; when the third deficiency value and the fourth deficiency value of the same material with a deficiency in the second group are different, using the larger of the third deficiency value and the fourth deficiency value as the second deficiency value. As shown in Table 3, taking the use of the semi-finished component PCB-10 in the fourth group, the semi-finished component PCB-1 in the third group, and the semi-finished component PCB-2 in the third group to replenish material F as an example, the available quantity of material F prepared by the semi-finished component PCB-10 is equal to the ratio between the inventory of the semi-finished component PCB-10, 1000, and the value of the unit consumption of the semi-finished component PCB-10 relative to material F, 1, rounded down to an integer (1000 divided by 1, rounded down to an integer is 1000), that is, the available quantity of material F prepared by the semi-finished component PCB-10 is 1000; the fourth shortfall value of material F is 3000, which is obtained by subtracting the available quantity of material F prepared by the semi-finished component PCB-10, 1000, from the shortfall of material F, 4000. The sufficient quantity of material F prepared by the semi-finished components PCB-1 and the semi-finished components PCB-2 is x1+x2. The sufficient quantity of material F prepared by the semi-finished components PCB-1 and the semi-finished components PCB-1 is x1+x2. The shortage quantity of material F, 1000, is subtracted from the sufficient quantity of material F, x1+x2, to obtain a third shortage value of material F, which is 1000-(x1+x2). If the third shortage value 1000-(x1+x2) is equal to the fourth shortage value 3000, the third shortage value and the fourth shortage value 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, 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, the fourth shortage value 3000 is used as the second shortage value of material F.

[0406] In an exemplary embodiment, when the fourth deficiency value is less than or equal to 0, it indicates that one or more semi-finished components in the fourth group can meet the corresponding materials with deficiencies in the second group, and then one or more semi-finished components in the fourth group do not have deficiencies; when the fourth deficiency value is greater than 0, it indicates that one or more semi-finished components in the fourth group cannot meet the corresponding materials with deficiencies in the second group, and then one or more semi-finished components in the fourth group have deficiencies. In an exemplary embodiment, subject to the restriction of the first constraint function, when semi-finished components in the third group are used to supplement materials with shortages in the second group, the available quantity of one or more semi-finished components in the third group to prepare corresponding materials with shortages in the second group will not exceed the shortage quantity of the corresponding materials with shortages in the second group. For example, when semi-finished components PCB-1 and semi-finished components PCB-2 are used to supplement material F, the available quantity x1+x2 of material F prepared by semi-finished components PCB-1 and semi-finished components PCB-2 will not exceed 1000 of the shortage quantity of material F. Therefore, the third shortage value will generally not be less than 0. When the third shortage value is greater than 0, it indicates that one or more semi-finished product groups in the third group have shortages. When the third shortage value is equal to 0, it indicates that one or more semi-finished product groups in the third group do not have shortages.

[0407] In an exemplary embodiment, the larger of the third and fourth deficiency values ​​is used as the second deficiency value for one or more materials in the second group that are deficient. This avoids the situation where the larger deficiency value still exists when the smaller deficiency value is used as the deficiency value, resulting in the actual deficiency not being met. Step 115: Calculate the deficiency 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 corresponding semi-finished components in the third group; and calculate the deficiency quantity of one or more semi-finished components in the fourth group based on the inventory quantity of one or more semi-finished components in the fourth group and the maximum consumption quantity of one or more corresponding semi-finished components in the fourth group.

[0408] In an exemplary embodiment, the missing amount of one or more materials in the second group may be converted into the missing amount of one or more semi-finished components in the third and fourth groups and the fourth group.

[0409] 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 that are in short supply in the second group and there are no alternative materials, the short supply 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.

[0410] In an exemplary embodiment, because one or more semi-finished components in the third group are alternative materials for preparing one or more corresponding materials in short supply in the second group, the short supply quantity within the same alternative group can be set based on configuration parameters. In an exemplary embodiment, the configuration parameters can include one or more of priority, likelihood of use, low cost of the semi-finished component, and proportional allocation as parameters for setting the short supply quantity of the semi-finished component, thereby facilitating business strategy adjustments. For example, within the same alternative group, semi-finished components with higher priorities (lower priority values) can be prioritized, or semi-finished components with greater likelihood of use can be prioritized, or semi-finished components with lower production costs can be prioritized, or the short supply quantity can be proportionally allocated to multiple semi-finished components within the same alternative group.

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

[0412] In an exemplary embodiment, data of materials in the first group (ie, data of substitutable 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:

[0413] Table 4

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

[0415] 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 satiable quantity of one or more alternative 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.

[0416] 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 satisfying 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 satisfying quantity of one or more alternative material groups in the first group relative to the corresponding product components based on the satisfying quantity of one or more materials in the first group relative to the corresponding product components.

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

[0418] Among them, y i represents the amount of the corresponding product component that can be produced using the corresponding material in the first group (i.e., the amount that can be satisfied by one or more materials in the first group to prepare the corresponding product component); i Represents the value of the unit consumption 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.

[0419] 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 one or more materials in the first group for preparing corresponding materials with deficiencies in the second group are set as follows: the available quantity of material A for preparing product component PRO-1 is set as y1, the available quantity of material B for preparing product component PRO-1 is set as y2, the available quantity of material C for preparing product component PRO-1 is set as y3, the available quantity of material D for preparing product component PRO-1 is set as y4, the available quantity of material C for preparing product component PRO-4 is set as y5, and the available quantity of material H for preparing 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 relative to product component PRO-1 is y7. The unit consumption value 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; the maximum consumption of one or more materials in the first group is calculated using the linear programming model: 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 product components in the first group is: Max1=y1+y2+2y3+2y4+2y5+2y6.

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

[0421] Among them, Q l represents the demand for the lth product component in the first group; (Q l ,G j) represents a set of variables (which can be a set of variables) for the jth group of materials relative to the lth product component. Multiple materials in the jth group can replace each other in the production of the lth product component; 0≤y i ≤Q l ; 1≤j≤J, where J represents the total number of groups of materials that can replace each other when producing the lth product component.

[0422] In an exemplary embodiment, the first constraint function of the first objective function can be understood as a constraint on the demand for corresponding product components. As shown in Table 4, the product components to be prepared include product components PRO-1 and product components PRO-4 (i.e., the value of l is 2), the demand Q1 of product component PRO-1 is 20,000, the demand Q2 of product component PRO-4 is 1,300, the total number J of groups of materials 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 the other material group includes material C and material D), and the total number J of groups of materials that can be substituted for each other when preparing product component PRO-4 is 1 (this material group includes material C and material H). The constraints on the demand for corresponding materials in the first group are as follows:

[0423] The demand constraints for product component PRO-1 are: y1+y2≤20000; y3+y4≤20000;

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

[0425] In an exemplary embodiment, the first objective function may also be constrained by a second constraint function, which is expressed as:

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

[0427] In an exemplary embodiment, the second constraint function of the first objective function can be understood as a constraint on the inventory 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, H), the available inventory of material A is 5000, the available inventory of material B is 2000, the available inventory of material C is 3000, the available inventory of material D is 1000, and the available inventory of material H is 1000. The constraints on the inventory of the corresponding materials in the first group are as follows:

[0428] The inventory constraint for material A is: 0≤y1≤5000;

[0429] The inventory constraint for material B is: 0≤y2≤2000;

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

[0431] The inventory constraint for material D is: 0≤2y4≤1000;

[0432] The constraint on the inventory quantity of material H is: 0≤2y6≤1000.

[0433] In an exemplary embodiment, the above-mentioned 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 can achieve the maximum total consumption (Max1) of one or more materials in the first group are obtained, which can minimize the inventory of materials and the demand for product components, thereby reducing the stagnation of materials and reducing the shortage of product components.

[0434] In an exemplary embodiment, 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 the 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, in which all variables are integers. In another example, the linear programming model is a mixed integer linear programming model, in which some variables are integers and some are non-integers.

[0435] Various suitable methods can be implemented in a linear programming model. In one example, a branch and bound method can be used, which is based on the principle that the total set of feasible solutions can be divided into smaller subsets of solutions. The smaller subsets can then be systematically evaluated until the optimal solution is found. The branch and bound method can be implemented in a pure integer linear programming model, or it can be implemented in a mixed integer linear programming model. In another example, a cutting plane method can be used, which iteratively points to a feasible set or objective function by means of linear inequalities, called cutting. The cutting plane method can be implemented in a pure integer linear programming model or a mixed integer linear programming model.

[0436] In an exemplary embodiment, the satiable quantities of one or more materials in the first group relative to the corresponding product components, calculated using the linear programming model in step 117, are the satiable quantities of the one or more materials in the first group required to prepare the corresponding product components when the maximum consumption of the one or more product components is met. In an exemplary embodiment, calculating the satiable quantities of one or more alternative material groups in the first group relative to the corresponding product components based on the satiable quantities of the one or more materials in the first group relative to the corresponding product components may include summing the satiable quantities of the corresponding product components prepared by multiple materials in the first group that are in the same alternative group, to obtain the satiable quantities of the one or more alternative material groups in the first group relative to the corresponding product components.

[0437] As shown in Table 4, during the preparation of product component PRO-1, materials A and B are in the same substitution group. The sum of material A's satiable quantity y1 and material B's satiable quantity y2 relative to product component PRO-1 is calculated as y1 + y2 for materials A and B in the same substitution group relative to product component PRO-1. Similarly, the sum of the satiable 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 satiable quantities of materials C and H in the same substitution group relative to product component PRO-4 is y5 + y6.

[0438] Step 118: Based on the satiable quantity of one or more alternative material groups in the first group relative to the corresponding product components and the demand quantity of one or more product components in the first group, determine whether there is a shortage of one or more alternative material groups in the first group relative to the corresponding product components. If so, execute step 119; otherwise, based on the inventory quantity of one or more materials in the first group and the maximum consumption 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 use the remaining quantity of one or more materials in the first group to update the inventory quantity of one or more materials in the first group.

[0439] In an exemplary embodiment, in step 118, determining whether there is a shortage 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 alternative material groups in the first group relative to the corresponding product components and the demand quantity of one or more product components in the first group may include:

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

[0441] When the available quantity of one or more alternative material groups in the first group relative to the corresponding product components is equal to the demand quantity of one or more product components in the first group, it is determined that the one or more alternative material groups in the first group are not in short supply relative to the corresponding product components, and the materials in the first group can just meet the demand quantity of the corresponding product components;

[0442] When the satiable quantity of one or more alternative material groups in the first group relative to the corresponding product components 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 alternative material groups in the first group relative to the corresponding product components.

[0443] In an exemplary embodiment, in 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: using the inventory quantity of one or more materials in the first group, 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, to obtain the remaining quantity of one or more materials in the first group.

[0444] Take the consumption of material C and material H in the preparation of product component PRO-4 in Table 4 as an example: the priority of material H is 1 and the priority of material C is 2, so material H is used first to prepare product component PRO-4. The inventory of material H is 1000 minus the maximum consumption of material H relative to product component PRO-4, 2y6, to obtain the remaining amount of material H, which is 1000-2y6. When 1000-2y6 is greater than or equal to 0, it means that material H can meet the demand of product component PRO-4, and the demand of product component PRO-4 can be met without consuming material C; when 1000-2y6 is less than 0, it means that material H cannot meet the demand of product component PRO-4, and material C is used to supplement the demand of product component PRO-4. The remaining amount of material C in the preparation of product component PRO-4 is 1000-2y6. The available quantity (y5) is equal to the demand quantity (1300) of product component PRO-4 minus the available quantity (y6) of material H for preparing product component PRO-4. The inventory quantity of material C, 3000, is subtracted from the maximum consumption quantity 2y5 of material C relative to product component PRO-4, and the remaining quantity of material C is 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 demand 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 demand quantity of product component PRO-4, and there is a shortage of materials in the first group for preparing product component PRO-4.

[0445] 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 a negative number, and the absolute value of the inventory quantity is the shortage amount.

[0446] In an exemplary embodiment, the consumption of material H when preparing product component PRO-4 is taken as an example: after using material H to prepare product component PRO-4, 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, so that materials can be managed effectively.

[0447] Step 119: Determine whether there are semi-finished product components in the material group with shortages in the first group. If so, execute step 120; otherwise, use the remaining quantity of the material with shortages in the first group to update the inventory of the corresponding material, and calculate the shortage quantity of one or more alternative material groups relative to the product components based on the available quantity of one or more alternative material groups in the first group relative to the corresponding product components and the demand quantity of one or more product components in the first group.

[0448] In an exemplary embodiment, subject to the constraints of the second constraint function of the first objective function, the remaining quantity of the missing materials in the first group is a number greater than or equal to 0.

[0449] In an exemplary embodiment, calculating the shortage of one or more alternative material groups relative to the product components based on the satisfyable quantities of one or more alternative material groups in the first group relative to the corresponding product components and the demand quantities of one or more product components in the first group may include: subtracting the satisfyable quantities of one or more alternative material groups in the first group relative to the corresponding product components from the demand quantities 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 components.

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

[0451] In an exemplary embodiment, the material data of the multiple semi-finished components of the missing material group 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 missing material, the material number of the semi-finished component, the unit consumption of the product component for the semi-finished component (i.e., the unit consumption of the semi-finished component relative to the alternative material), the inventory of the semi-finished component, the alternative group of the semi-finished component, and the missing quantity of the product component (which can be understood as the demand for the product component that the semi-finished component needs to meet). The material data of the semi-finished components of the missing material group in the first group may be shown in Table 6:

[0452] Table 6

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

[0454] Step 121: Calculate the maximum consumption of the one or more semi-finished components in the fifth group relative to the product components corresponding to the one or more material groups with deficiencies in the first group based on the material data of the one or more semi-finished components in the fifth group.

[0455] 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 deficiencies in the first group based on the material data of one or more semi-finished components in the fifth group may include: using 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 material groups with deficiencies in the first group.

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

[0457] Among them, p i Represents the quantity of product components corresponding to the corresponding materials with deficiencies in the first group that can be produced using the corresponding semi-finished components in the fifth group (i.e., the quantity that can be satisfied by using one or more semi-finished components in the fifth group to produce the product components corresponding to the corresponding materials with deficiencies in the first group); d iRepresents the unit consumption value of the corresponding semi-finished product components in the fifth group relative to the product components corresponding to one or more corresponding materials with deficiencies in the first group; N is a positive integer representing the total number of corresponding semi-finished product components in the fifth group, N≥1.

[0458] 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 corresponding materials with deficiencies in the first group prepared by one or more semi-finished components in the fifth group are set as follows: the available quantity of the product component PRO-1 corresponding to the material C with deficiencies in the semi-finished component PCB-3 is set as p1, the available quantity of the product component PRO-1 corresponding to the material C with deficiencies in the semi-finished component PCB-4 is set as p2, the available quantity of the product component PRO-1 corresponding to the material D with deficiencies in the semi-finished component PCB-6 is set as p3, and the available quantity of the product component PRO-1 corresponding to the material D with deficiencies in the semi-finished component PCB-7 is set as p4. The quantity that can be satisfied for the product component PRO-1 corresponding to the material D with a defect is set to p4, the quantity that can be satisfied for the product component PRO-4 corresponding to the material C with a defect in the semi-finished component PCB-3 is set to p5, and the quantity that can be satisfied for the product component PRO-4 corresponding to the material C with a defect in the semi-finished component PCB-4 is set to p6; the unit consumption of the semi-finished component PCB-3 relative to the product component PRO-1 corresponding to the material C with a defect is 4, the unit consumption of the semi-finished component PCB-4 relative to the product component PRO-1 corresponding to the material C with a defect is 4, and the unit consumption of the semi-finished component PCB-6 relative to the product component PRO-1 corresponding to the material D with a defect is 4. The unit consumption value of the semi-finished component PCB-7 relative to the product component PRO-1 corresponding to the missing material D is 4, the unit consumption value of the semi-finished component PCB-3 relative to the product component PRO-4 corresponding to the missing material C is 4, and the unit consumption value of the semi-finished component PCB-4 relative to the product component PRO-4 corresponding to the missing material C is 4; the linear programming model is used to calculate the maximum consumption of one or more semi-finished components in the fifth group: the maximum consumption of the semi-finished component PCB-3 relative to the product component PRO-1 corresponding to the missing material C is 4*p1, the semi-finished component PCB-4 relative to the product component PRO-4 corresponding to the missing material C is 4*p1. The maximum consumption of item PRO-1 is 4*p2, the maximum consumption of semi-finished component PCB-6 relative to the product component PRO-1 corresponding to the defective material D is 4*p3, the maximum consumption of semi-finished component PCB-7 relative to the product component PRO-1 corresponding to the defective material D is 4*p4, the maximum consumption of semi-finished component PCB-3 relative to the product component PRO-4 corresponding to the defective material C is 4*p5, and the maximum consumption of semi-finished component PCB-4 relative to the product component PRO-4 corresponding to the defective material C 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.

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

[0460] Among them, Q l Represents the missing quantity (i.e., demand) of the product component corresponding to the lth missing material in the first group; (Q l ,G j ) represents a set of variables (which can be a set of variables) of the jth group of semi-finished components relative to the lth missing material. Multiple semi-finished components in the jth group can replace each other in the production of the lth missing material; 0≤p i ≤Q l ; 1≤j≤J, where J represents the total number of groups of semi-finished components that can replace each other when producing the lth material with a defect.

[0461] In an exemplary embodiment, the first constraint function of the fifth objective function can be understood as a constraint on the shortage quantity of the product components corresponding to the corresponding materials with shortages in the first group (that is, the demand quantity of the product components corresponding to the corresponding materials with shortages in the first group). As shown in Table 6, the product components PRO-1 corresponding to materials C and D are shortages, and the product component PRO-4 corresponding to material C is shortages (that is, the value of l is 3). The shortage quantity Q1 of the product component PRO-1 corresponding to material C is 20,000-y1-y2, the shortage quantity Q2 of the product component PRO-1 corresponding to material D is 20,000-y1-y2, and the shortage quantity Q3 of the product component PRO-4 corresponding to material C is 1,300-y5-y6. , the total number J of groups of semi-finished components that can be substituted for each other when preparing the product component PRO-1 corresponding to material C is 1 (this group of semi-finished components includes: semi-finished components PCB-3 and semi-finished components PCB-4). The total number J of groups of semi-finished components that can be substituted for each other when preparing the product component PRO-1 corresponding to material D is 1 (this group of semi-finished components includes: semi-finished components PCB-6 and semi-finished components PCB-7). The total number J of groups of semi-finished components that can be substituted for each other when preparing the product component PRO-4 corresponding to material C is 1 (this group of semi-finished components includes: semi-finished components PCB-3 and semi-finished components PCB-4). The constraints on the shortage amount of the product components corresponding to the corresponding materials with shortages in the second group are as follows:

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

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

[0464] In an exemplary embodiment, the fifth objective function may also be constrained by a second constraint function, which is expressed as:

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

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

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

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

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

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

[0471] In an exemplary embodiment, the fifth linear programming model is used 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 shortage materials in the first group. Under the premise of satisfying the first constraint function and the second constraint function of the fifth objective function, the values ​​of p1, p2, p3, and p4 are obtained when the total maximum consumption (Max5) of one or more semi-finished components in the fifth group is maximized. This can minimize the inventory of semi-finished components and make up for the shortage of materials 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.

[0472] Step 122: Calculate the remaining quantity of one or more semi-finished components in the fifth group based on the inventory quantity of one or more semi-finished components in the fifth group and the maximum consumption of one or more semi-finished components in the fifth group relative to the product components corresponding to one or more corresponding materials with shortages in the first group, and use the remaining quantity of one or more semi-finished components in the fifth group to update the inventory quantity of one or more semi-finished components in the fifth group.

[0473] In an exemplary embodiment, in 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 one or more semi-finished components in the fifth group relative to the product components corresponding to one or more corresponding materials with shortages in the first group may include: using the inventory of one or more semi-finished components in the fifth group, subtracting the maximum consumption of one or more semi-finished components in the fifth group relative to the product components corresponding to one or more corresponding materials with shortages in the first group, to obtain the remaining quantity of one or more semi-finished components in the fifth group.

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

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

[0476] Step 123: Calculate a fifth deficiency value based on the available quantity of the product components corresponding to the corresponding material group with deficiencies in the first group for preparing one or more semi-finished product components in the fifth group and the deficiency quantity of the product components corresponding to the corresponding material group with deficiencies in the first group, and use the fifth deficiency value to update the deficiency quantity of the product components corresponding to the corresponding material with deficiencies in the first group.

[0477] In an exemplary embodiment, calculating the fifth shortfall value based on the available quantity of one or more semi-finished components in the fifth group for preparing product components corresponding to the corresponding material group with deficiencies in the first group and the shortfall quantity of the product components corresponding to the corresponding material group with deficiencies in the first group may include: subtracting the available quantity of one or more semi-finished components in the fifth group for preparing product components corresponding to the corresponding material group with deficiencies in the first group from the shortfall quantity of the product components corresponding to the corresponding material group with deficiencies in the first group to obtain the fifth shortfall value of the product components corresponding to the corresponding material group in the first group;

[0478] The available quantity of one or more semi-finished components in the fifth group for preparing the product components corresponding to the corresponding material groups with deficiencies in the first group is equal to the sum of the ratios of the inventory of the one or more semi-finished components in the fifth group to the unit consumption of the one or more semi-finished components in the fifth group relative to the product components corresponding to the corresponding material groups with deficiencies in the first group, rounded down to the nearest integer. In an exemplary embodiment, the available quantity of one or more semi-finished components in the fifth group for preparing the product components corresponding to the corresponding material groups with deficiencies in the first group is obtained by calculating the maximum consumption of one or more semi-finished components in the fifth group relative to the product components corresponding to the one or more material groups with deficiencies 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 alternative material groups C and D prepared by semi-finished components PCB-3, PCB-4, PCB-6, and PCB-7 is p1+p2+p3+p4.

[0479] In an exemplary embodiment, the shortage quantity of the product component corresponding to the corresponding material group with shortage in the first group=the demand quantity of the corresponding product component-the satisfyable quantity of the alternative group relative to the corresponding product component;

[0480] The satisfying quantity of the alternative group relative to the corresponding product components = the satisfying quantity of the first group of materials relative to the corresponding product components + the satisfying quantity of the fifth group of semi-finished product components relative to the corresponding product components.

[0481] As shown in Tables 4 and 6, using the example of PRO-1 produced using alternative materials C and D, the available quantities of alternative materials C and D relative to PRO-1 are y3 + y4. The available quantities of semi-finished components PCB-3, PCB-4, PCB-6, and PCB-7 in the fifth group relative to PRO-1 are p1 + p2 + p3 + p4. The demand for PRO-1 is 20,000, and the shortfall for PRO-1 is 20,000 - y3 - y4. The final shortfall for PRO-1 is 20,000 - y3 - y4 - (p1 + p2 + p3 + p4). The fifth shortfall value can be p1 + p2 + p3 + p4 - (20,000 - y3 - y4).

[0482] Step 124: Calculate a sixth deficiency value based on the available quantity of the corresponding material with shortage in the first group for preparing one or more semi-finished components in the fifth group and the shortage quantity of the corresponding material group with shortage in the first group, and use the sixth deficiency value to update the shortage quantity of the corresponding material group with shortage in the first group.

[0483] In an exemplary embodiment, calculating the sixth deficiency value based on the available quantity of one or more semi-finished components in the fifth group for preparing the corresponding material with a deficiency in the first group and the deficiency quantity of the corresponding material with a deficiency in the first group may include: subtracting the available quantity of one or more semi-finished components in the fifth group for preparing the corresponding material with a deficiency in the first group from the deficiency quantity of the corresponding material with a deficiency in the first group to obtain the sixth deficiency value of the corresponding material in the first group;

[0484] The available quantity of one or more semi-finished components in the fifth group for preparing the corresponding materials missing in the first group is equal to the ratio between the inventory of the one or more semi-finished components in the fifth group and the unit consumption of the one or more semi-finished components in the fifth group relative to the corresponding materials missing in the first group, rounded down to an integer. In an exemplary embodiment, the available quantity of one or more semi-finished components in the fifth group for preparing the corresponding materials missing in the first group can be calculated by multiplying the available quantity of one or more semi-finished components in the fifth group for preparing the product components corresponding to the corresponding materials missing in the first group by the unit consumption of the corresponding materials missing in the first group relative to the corresponding product components. 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 deficiency value of material C can be obtained by using the deficiency amount (1300-y5-y6) / 2 when preparing product component PRO-4 from material groups C and H, minus the satisfying amount of semi-finished components PCB-3 and PCB-4 relative to material C, which is 2p5+2p6, that is, the sixth deficiency value of material C = (1300-y5-y6) / 2-(2p5+2p6).

[0485] Step 125: Acquire configuration parameters, allocate the missing quantities of the missing materials in the corresponding material groups with missing materials in the first group according to the configuration parameters, and use the allocated missing quantities to update the missing quantities of the corresponding materials in the first group.

[0486] In an exemplary embodiment, the configuration parameters may include the priority of the corresponding missing materials in the first group. Step 125 may include allocating the missing quantities of the corresponding missing materials in the first group according to the priority number of the materials. In an exemplary embodiment, the missing quantities are allocated first to materials with higher priorities.

[0487] Table 7 shows an example of allocating the shortage quantity for the materials in the first group according to their priority:

[0488] Table 7

[0489] In an exemplary embodiment, the configuration parameters are not limited to the priority of alternative materials and can be set according to actual business needs. For example, the shortage quantity can be allocated according to the size of the shared quantity of alternative materials and the possibility of using alternative materials.

[0490] In an exemplary embodiment, in the process of preparing one or more product components, the consumption of materials (essential materials or irreplaceable materials) in the first group is first calculated. When there is a shortage of materials in the first group, semi-finished components of the corresponding materials are obtained, and the semi-finished components are converted into the corresponding materials in the first group to obtain the shortage or stagnation status of the materials in the first group. After calculating the material consumption of the first group and the corresponding semi-finished components, the consumption of materials (replaceable materials) in the second group is calculated. When there is a shortage of materials in the second group, when there are semi-finished components, the materials of the semi-finished components are converted into the corresponding materials in the second group. Finally, the stagnation quantity or shortage quantity of the first group and the second group and the corresponding semi-finished components are obtained. When the remaining quantity of the material is greater than 0, it is called the stagnation quantity, and when the remaining quantity of the material is less than 0, it is called the shortage quantity (or the shortage quantity is calculated based on the remaining quantity).

[0491] In an exemplary embodiment, step 122 may further include step M0: when it is determined that one or more next-level materials in the fifth group have shortages based on the remaining quantities of one or more next-level materials in the fifth group, the configuration parameters of the next-level materials are obtained, the shortage quantities of the shortage materials in the corresponding next-level material groups in the fifth group with shortages are reallocated based on the configuration parameters of the next-level materials, the shortage quantities of the corresponding next-level materials in the fifth group are updated using the reallocated shortage quantities, and the updated shortage quantities and shortage status of the corresponding next-level materials in the fifth group are displayed through the first output interface; when it is determined that one or more next-level materials in the fifth group do not have shortages based on the remaining quantities of one or more next-level materials in the fifth group, and the remaining quantities are greater than 0, the remaining quantities and stagnation status of the one or more next-level materials in the fifth group are output through the first display interface; when it is determined that one or more next-level materials in the fifth group do not have shortages and the remaining quantities are equal to 0, the remaining quantities and material status of the one or more next-level materials in the fifth group are output through the first display interface.

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

[0493] In an exemplary embodiment, after step 123 and before step 124 , the method may further include: outputting the missing quantity of the product components corresponding to the corresponding missing materials in the first group through the first display interface.

[0494] In an exemplary embodiment, after step 124 and before step 125 , the method may further include: outputting the missing quantity of the corresponding missing materials in the first group through the first display interface.

[0495] In an exemplary embodiment, step 125 may further include: outputting the updated missing quantity of the corresponding missing materials in the first group through the first display interface.

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

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

[0498] In an exemplary embodiment, after obtaining the remaining quantity of one or more semi-finished components in the fourth group in step 111, the following may also be included: when the remaining quantity of one or more semi-finished components in the fourth group is greater than 0, based on the substitution relationship information between the semi-finished components in the fourth group, determining whether one or more materials in the fourth group are substitutable materials relative to at least one of the one or more materials in short supply in the first and third groups; when it is determined that one or more materials in the fourth group are not substitutable materials relative to the one or more materials in short supply in the first and third groups, determining that the one or more materials in the fourth group are stagnant. When it is determined that one or more materials in the fourth group are substitutable materials relative to the one or more materials in short supply in the first and third groups, it is necessary to determine whether the one or more materials in the fourth group are stagnant or in short supply based on the consumption of the one or more materials in the fourth group by the first and third groups.

[0499] In an exemplary embodiment, the semi-finished product components described above may be used as next-level materials for preparing product components.

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

[0501] In an exemplary embodiment, as shown in FIG4 , the computer-implemented method may further include: generating one or more user interfaces;

[0502] The one or more user interfaces may include a first output interface OI1 configured to display the material status of corresponding materials in at least one of the first to fourth groups.

[0503] In an exemplary embodiment, the material status may include: material shortage, material stagnation, and material just sufficient.

[0504] In an exemplary embodiment, as shown in FIG4 , the one or more user interfaces may further include a first input interface II1 configured to receive one or more user inputs for querying a database; the database stores data of a plurality of materials;

[0505] 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 status associated with the one or more conditions; and, in response to the user selection, querying a database to determine one or more material statuses associated with the one or more conditions; the one or more conditions may include at least one of a stagnant status for a stagnant material or a shortage status for a shortage material; the one or more user interfaces may further include a second output interface OI2 configured to display the one or more stagnant or shortage materials as a result of the database query. In an exemplary embodiment, the one or more conditions further include at least one of a manufacturing location identification number, a material identification number, or a date range.

[0506] In an exemplary embodiment, the second output interface OI2 may also be configured to display the identification numbers of one or more products produced from one or more obsolete materials. In an exemplary embodiment, the second output interface OI2 may also be configured to display the demand for obsolete materials used to manufacture the corresponding product components. Users may analyze the relationship between demand and obsolete status.

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

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

[0509] 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;

[0510] The computer-implemented method may further include: re-determining whether the corresponding next-level materials in the third group are stagnant or in short supply based on the adjusted priorities of the corresponding next-level materials in the second group.

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

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

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

[0514] Re-determine whether the corresponding materials in the first group are stagnant or in short supply. In an exemplary embodiment, the 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 the demand for one or more products. The memory also stores computer-executable instructions for controlling one or more processors: based on the adjusted demand for one or more products, calculate the adjusted maximum consumption of the corresponding materials in the first group within the cycle; 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-determine whether the corresponding materials in the first group are stagnant. By adjusting the demand for one or more products, material stagnation can be reduced, manufacturers can better cater to the market, and products can be supplied faster.

[0515] The one or more user interfaces may further include a third output interface OI3 configured to display an estimated surplus of obsolete materials at the first manufacturing site and an estimated deficit of obsolete materials at the second manufacturing site. Optionally, the third output interface OI3 is configured to display a table including the identification number of the obsolete material, the identification number of the manufacturing site, the estimated surplus, and the estimated deficit.

[0516] Figure 5 illustrates a third output interface OI3 in some embodiments of the present disclosure. Referring to Figure 5 , the third output interface OI3 is configured to display that material Mat-1 is idle at manufacturing site A with a surplus of 5,000 g, is in short supply at manufacturing site B with a shortage of 1,000 g, and is in short supply at manufacturing site C with a shortage of 3,000 g. In some embodiments, a user can allocate idle materials between manufacturing sites based on factors such as shipping costs and the urgency of the need for the idle materials at the second manufacturing site.

[0517] In some embodiments, the computer-implemented method may further include: upon determining that a corresponding material in the first group has sluggishness, adjusting demand for one or more product components to minimize material sluggishness; and producing the one or more product components based on the adjusted demand for the one or more products. By adjusting demand for the one or more product components, material sluggishness can be reduced, allowing manufacturers to better cater to the market and supply products more quickly.

[0518] In this exemplary embodiment, a remaining quantity of a material greater than 0 indicates that the material is stagnant and can be used to update the stagnant quantity. A remaining quantity less than 0 indicates that the material is in short supply and can be used to update the short supply quantity. Both available inventory and inventory represent the quantity of material available before preparing the corresponding product component or semi-finished product component. The remaining quantity is typically calculated by subtracting the consumed quantity 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.

[0519] The present disclosure also provides an apparatus for managing the production of one or more products. In an exemplary embodiment, as shown in FIG6 , the apparatus for managing the production of one or more products may include:

[0520] Memory;

[0521] one or more processors;

[0522] The memory and 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:

[0523] Acquiring data on multiple next-level materials of one or more materials with shortages for manufacturing one or more product components; the data on multiple next-level materials of one or more materials with shortages includes available inventory quantities of the multiple next-level materials;

[0524] Calculate the maximum consumption of multiple lower-level materials relative to at least one of the one or more materials with shortages;

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

[0526] In an exemplary embodiment, FIG7 is a schematic diagram of the structure of an apparatus according to some embodiments of the present disclosure. Referring to FIG7, in some embodiments, the apparatus includes a central processing unit (CPU) configured to perform actions according to computer-executable instructions stored in ROM or RAM. In an exemplary embodiment, the 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, the input / output interface is electrically connected to the bus.

[0527] In an exemplary embodiment, a device 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 be a subsequent material for preparing a product component.

[0528] The present disclosure also provides a computer program product including a non-transitory tangible computer-readable medium having computer-readable instructions thereon, wherein the computer-readable instructions are executable by a processor to cause the processor to perform:

[0529] Obtaining data on multiple next-level materials of one or more materials with shortages for manufacturing one or more product components; the data on multiple next-level materials of one or more materials with shortages includes available inventory quantities of the multiple next-level materials;

[0530] Calculating the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with shortages;

[0531] It is determined whether the one or more materials with shortages are in shortage based on the maximum consumption and available inventory of the corresponding materials of the multiple next-level materials.

[0532] The present disclosure also provides an apparatus for managing the production of one or more products. Referring to FIG. 6 , the apparatus for managing the production of one or more products may include:

[0533] Memory;

[0534] one or more processors;

[0535] 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:

[0536] Receiving a material query instruction input by a user through a first input interface;

[0537] In response to the material query instruction, obtaining data about a plurality of materials used to manufacture one or more product components from a data source, the data about the plurality of materials including available inventory quantities of the plurality of materials;

[0538] calculating a maximum consumption of the plurality of materials relative to at least one product component among the one or more product components;

[0539] It is determined whether there is a shortage of one or more materials for manufacturing one or more product components according to the maximum consumption of corresponding materials of the multiple materials and the available inventory of corresponding materials of the multiple materials.

[0540] The present disclosure also provides a computer program product including a non-transitory tangible computer-readable medium having computer-readable instructions thereon, wherein the computer-readable instructions are executable by a processor to cause the processor to perform:

[0541] Receiving a material query instruction input by a user through a first input interface;

[0542] In response to the material query instruction, obtaining data on a plurality of materials for manufacturing one or more product components from a data source, wherein the data on the plurality of materials includes available inventory quantities of the plurality of materials;

[0543] calculating a maximum consumption of the plurality of materials relative to at least one product component among the one or more product components;

[0544] It is determined whether there is a shortage of one or more materials for manufacturing one or more product components according to the maximum consumption of corresponding materials of the multiple materials and the available inventory of corresponding materials of the multiple materials.

[0545] The embodiments of the present disclosure provide 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 material query instruction input by a user through a first input interface; in response to the material query instruction, obtaining data about multiple materials for manufacturing one or more product components from a data source, the data on the multiple materials including the available inventory of the multiple materials; calculating the maximum consumption of the multiple materials relative to at least one product component in the one or more product components; judging 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; the technical solution provided by the embodiments of the present disclosure can solve the problem of stagnant or scarce materials in the material management process.

[0546] It will be appreciated by those skilled in the art that all or some of the steps, systems, and functional modules / units in the methods disclosed above may be implemented as software, firmware, hardware, and appropriate combinations thereof. In hardware implementations, the division between the functional modules / units mentioned in the above description 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 by several physical components in cooperation. Some or all components may be implemented as software executed by a processor, such as a digital signal processor or a microprocessor, or implemented as hardware, or implemented as an integrated circuit, such as an application-specific integrated circuit. Such software may be distributed on a computer-readable medium, which may include a computer storage medium (or non-transitory medium) and a communication medium (or temporary medium). As is well known to those skilled in the art, the term computer storage medium 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 technology, CD-ROM, digital versatile disks (DVD) or other optical disk storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium that can be used to store the desired information and can be accessed by a computer. In addition, it is well known to those skilled in the art that communication media generally embodies computer-readable instructions, data structures, program modules, or other data in a modulated data signal such as a carrier wave or other transport mechanism, and may include any information delivery media.

[0547] In the absence of conflict, the embodiments of the present invention, that is, the features in the embodiments, can be combined with each other to form new embodiments.

[0548] Although the embodiments disclosed in this disclosure are as described above, the contents are merely embodiments adopted to facilitate understanding of the disclosure and are not intended to limit the disclosure. Any person skilled in the art of the disclosure may make any modifications and changes in the form and details of the implementation without departing from the spirit and scope of the disclosure. However, the scope of patent protection of the disclosure shall still be based on the scope defined by the attached claims.

Claims

1. A computer-implemented method comprising: Receiving a material query instruction input by a user through a first input interface; In response to the material query instruction, obtaining data on a plurality of materials for manufacturing one or more product components from a data source, wherein the data on the plurality of materials includes available inventory quantities of the plurality of materials; calculating a maximum consumption of the plurality of materials relative to at least one product component of the one or more product components; It is determined whether there is a shortage of one or more materials for manufacturing one or more product components according to the maximum consumption of corresponding materials of the multiple materials and the available inventory of corresponding materials of the multiple materials.

2. The computer-implemented method of claim 1 , further comprising: When determining that multiple materials used to manufacture one or more product components are missing, determine whether the missing materials have next-level materials; When it is determined that the missing material has a next-level material, data of multiple next-level materials of the one or more missing materials for manufacturing one or more product components are obtained, wherein the data of multiple next-level materials of the one or more missing materials include available inventory quantities of the multiple next-level materials; Calculating the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with shortages; It is determined whether there is a shortage of the multiple next-level materials based on the maximum consumption and available inventory of the corresponding materials of the multiple next-level materials.

3. The computer-implemented method of claim 2, wherein: 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 also includes substitution relationship information between next-level materials; Before acquiring data of multiple next-level materials of one or more materials with shortages in manufacturing one or more product components, the method further includes: judging one or more materials with shortages in a second group from the one or more materials with shortages according to substitution relationship information between the multiple materials; wherein the one or more materials with shortages in the second group are irreplaceable materials for at least one product component of the one or more product components; The calculating of the plurality of next-level materials relative to at least one of the one or more materials having a difference Before the maximum consumption of the material, it also includes: according to the substitution relationship information between the next-level materials, judging 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 in short supply in the second group, wherein the one or more next-level materials in the third group are replaceable materials relative to at least one material in the one or more materials in short supply in the second group, and the one or more next-level materials in the fourth group are irreplaceable materials relative to at least one material in the one or more materials in short supply in the second group.

4. The computer-implemented method of claim 3, wherein: The calculating the maximum consumption of the plurality of materials relative to at least one of the one or more product components comprises: calculating the maximum consumption of the one or more materials in the second group relative to the one or more product components based on the data of the one or more materials in the second group; The method of judging whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of corresponding materials of the multiple materials and the available inventory of corresponding materials of the multiple 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 judging 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.

5. The computer-implemented method of claim 4, wherein: The method 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 values ​​of the corresponding unit consumption of the corresponding materials in the second group relative to the manufacture of the one or more product components, to obtain the maximum consumption of one or more materials in the second group relative to the one or more product components.

6. The computer-implemented method of claim 4, wherein: When determining that there is a shortage of one or more materials in the second group, it also includes: calculating the shortage quantity 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.

7. The computer-implemented method of claim 6, wherein: The calculating the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with a shortage includes: calculating the maximum consumption of one or more next-level materials in the fourth group relative to one or more materials with a shortage in the second group; The plurality of next-level materials are determined according to the maximum consumption and available inventory of the corresponding materials of the plurality of next-level materials. Whether there is a shortage of the next-level materials includes: using the available inventory of one or more next-level materials in the fourth group minus the maximum consumption 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 judging whether there is a shortage of one or more next-level materials in the fourth group according to the remaining quantity of one or more next-level materials in the fourth group.

8. The computer-implemented method of claim 7, wherein: The calculation of the maximum consumption of one or more next-level materials in the fourth group relative to one or more materials in short supply in the second group includes: multiplying the short supply of one or more materials in short supply 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 short supply in the second group, to obtain the maximum consumption of one or more next-level materials in the fourth group relative to one or more materials in short supply in the second group.

9. The computer-implemented method of claim 7, further comprising: When it is determined that one or more next-level materials in the fourth group are short of each other, the short of one or more next-level materials in the fourth group is obtained according to the remaining amount of the one or more next-level materials in the fourth group, and the short of one or more next-level materials in the fourth group and the short of one or more next-level materials in the fourth group are displayed through the first output interface; 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; 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 greater than 0, determine whether one or more next-level materials in the fourth group are replaceable materials relative to at least one material of the one or more materials in the first group that have shortages, based on the substitution relationship information between the next-level materials; when it is determined that one or more next-level materials in the fourth group are not replaceable materials relative to one or more materials in the first group that have shortages, 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.

10. The computer-implemented method of claim 2, wherein: The calculating the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with a difference comprises: 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 a difference in the second group; The step of determining whether there is a shortage of the plurality of next-level materials according to the maximum consumption and available inventory of the corresponding materials of the plurality of next-level materials comprises: using the available inventory of one or more next-level materials in the third group minus The maximum consumption of one or more next-level materials in the third group is obtained to obtain the remaining amount of one or more next-level materials in the third group, and whether there is a shortage of one or more next-level materials in the third group is determined according to the remaining amount of one or more next-level materials in the third group.

11. The computer-implemented method of claim 10, further comprising: When it is determined that one or more next-level materials in the third group are short of each other, the short of one or more next-level materials in the third group is obtained according to the remaining amount of the one or more next-level materials in the third group, and the short of one or more next-level materials in the third group and the short of one or more next-level materials in the third group are displayed through the first output interface; When it is determined that there is no shortage of 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 there is no shortage of one or more next-level materials in the third group and the remaining quantity is greater than 0, determine whether one or more next-level materials in the third group are replaceable materials relative to at least one material of the one or more materials in the first group with shortages based on the substitution relationship information between the next-level materials; when it is determined that one or more materials in the third group are not replaceable materials relative to one or more materials in the first group with shortages, 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.

12. The computer-implemented method of claim 10, wherein: The third objective function of the third linear programming model is expressed as: Among them, x i Represents the amount of corresponding materials in the third group that can be used to prepare the corresponding materials in the second group that are in short supply; d i Represents the value of the unit consumption of the corresponding next-level materials in the third group relative to one or more corresponding materials in the second group that are missing; N is a positive integer, N≥1.

13. The computer-implemented method of claim 12, wherein: The third objective function is limited by the first constraint function, which is expressed as: Among them, Q l represents the missing quantity of the first missing material in the second group; (Q l ,G j ) represents a set of variables of the jth group of next-level materials relative to the lth missing material. Multiple next-level materials in the jth group can replace each other in the production of the lth missing material; 0≤x i ≤Q l ; 1≤j≤J, where J represents the total number of groups of next-level materials that can replace each other when producing the lth material with a shortage.

14. The computer-implemented method of claim 12, wherein: The third objective function is constrained by the second constraint function, which is expressed as: Among them, C m Represents the available inventory of the mth next-level material in the third group; X m A set of variables representing the mth next-level material; 1≤m≤M, where M represents the total number of next-level material types in the third group.

15. The computer-implemented method of claim 2, wherein: The data of the plurality of materials include substitution relationship information between the plurality of materials and demand quantity of one or more product components; Before acquiring data of multiple next-level materials of one or more materials with shortages in manufacturing one or more product components, the method further includes: according to substitution relationship information between the multiple materials, determining one or more materials in a first group from the multiple materials, wherein the one or more materials in the first group are substitutable materials for at least one product component in the one or more product components; The calculating the maximum consumption of the plurality of materials relative to at least one of the one or more product components comprises: calculating the maximum consumption of the one or more materials in the first group relative to the one or more product components based on the data of the one or more materials in the first group; The method of judging whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption of corresponding materials of the multiple materials and the available inventory of corresponding materials of the multiple materials includes: obtaining the satisfying quantity of one or more alternative material groups in the first group relative to the one or more product components when the consumption of one or more materials in the first group relative to the one or more product components is the maximum consumption, and judging whether there is a shortage of one or more alternative material groups in the first group relative to the corresponding product components based on the satisfying quantity of one or more alternative material groups in the first group relative to the one or more product components and the demand for one or more product components.

16. The computer-implemented method of claim 15, wherein: The determining whether the missing materials have next-level materials when there are shortages in multiple materials for manufacturing one or more product components includes: determining whether the missing materials have next-level materials when there are shortages in one or more alternative material groups in the first group relative to the corresponding product components; When it is determined that the missing material has a next-level material, obtaining data of multiple next-level materials of the one or more materials with a missing in manufacturing one or more product components includes: when it is determined that the missing material group in the first group has a next-level material, obtaining material data of one or more next-level materials of the one or more missing material groups in the first group; The calculating the maximum consumption of the plurality of next-level materials relative to at least one of the one or more materials with deficiencies includes: using the plurality of next-level materials of the one or more material groups with deficiencies in the first group as one or more next-level materials in the fifth group, and calculating the maximum consumption of the one or more next-level materials in the fifth group relative to the product components corresponding to the one or more material groups with deficiencies in the first group according to the material data of the one or more next-level materials in the fifth group; The determining whether there is a shortage of the multiple next-level materials based on the maximum consumption and available inventory of the corresponding materials of the multiple 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 one or more next-level materials in the fifth group relative to the product components corresponding to one or more corresponding material groups with 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.

17. The computer-implemented method of claim 16, wherein: When determining that one or more alternative material groups in the first group are short of corresponding product components, the method further includes: calculating the shortfall of one or more alternative material groups in the first group relative to the corresponding product components according to the satiable quantity of one or more alternative material groups in the first group relative to the corresponding product components and the demand quantity of the shortfall material in the first group; When it is determined that one or more next-level materials in the fifth group are missing, the method further includes: calculating a sixth missing value according to the available quantity of the corresponding materials in the first group that are missing prepared by the one or more next-level materials in the fifth group and the missing quantity of the corresponding material group in the first group, and updating the missing quantity of the corresponding material group in the first group using the sixth missing value; Obtain configuration parameters, reallocate the missing quantities of the missing materials in the corresponding material groups with shortages in the first group according to the configuration parameters, use the allocated missing quantities to update the missing quantities of the corresponding materials in the first group, and display the missing quantities and shortage status of the corresponding materials in the first group through the first output interface.

18. The computer-implemented method of claim 16, further comprising: When it is determined that one or more next-level materials in the fifth group are short of each other, the short of one or more next-level materials in the fifth group is obtained according to the remaining quantity of the one or more next-level materials in the fifth group, and the short of one or more next-level materials in the fifth group and the short of one or more next-level materials in the fifth group are displayed through the first output interface; When it is determined that there is no shortage of 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 is no shortage of 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.

19. The computer-implemented method of claim 16, further comprising: When it is determined that one or more next-level materials in the fifth group have shortages, the configuration parameters of the next-level materials are obtained, and the shortage quantities of the missing materials in the corresponding next-level material groups in the fifth group with shortages are reallocated according to the configuration parameters of the next-level materials. The shortage quantities of the corresponding next-level materials in the fifth group are updated with the reallocated shortage quantities, and the updated shortage quantities and shortage status of the corresponding next-level materials in the fifth group are displayed through the first output interface.

20. The computer-implemented method of claim 16, further comprising: When it is determined that one or more next-level materials in the fifth group have shortages, the configuration parameters of the next-level materials are obtained, and the shortage quantities of the corresponding next-level materials in the fifth group with shortages are reallocated according to the configuration parameters of the next-level materials, and the shortage quantities of the corresponding next-level materials in the fifth group are updated using the reallocated shortage quantities.

21. The computer-implemented method of claim 2, further comprising: When it is determined that the material with a shortage does not have a next-level material, the shortage status of the material with a shortage is displayed through the first output interface; When it is determined that there is no shortage of one or more materials for manufacturing one or more product components, material information of the one or more materials for manufacturing one or more product components is displayed through the first output interface.

22. The computer-implemented method of claim 2, further comprising: When it is determined that one or more of the materials with shortages are stagnant or in shortage based on the maximum consumption and available inventory of the corresponding materials of the multiple next-level materials, the demand for the one or more product components is adjusted to minimize the stagnation or shortage of the next-level materials; and the one or more product components are produced based on the adjusted demand for the one or more product components.

23. The computer-implemented method of claim 2, further comprising: generating one or more user interfaces; The one or more user interfaces include the first output interface, and the first output interface is further configured to display the material status of corresponding materials in at least one of the first to fifth groups.

24. The computer-implemented method of claim 23, wherein: 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 of multiple materials; The computer-implemented method further comprises: receiving a user selection of one or more conditions from the first input interface, the user selection being used to select a material state associated with the one or more conditions; and responding to the A user selects to query the database to determine one or more material states in the database that are associated with the one or more conditions; The one or more conditions include at least one of a stagnant state of stagnant materials and a shortage state of shortage materials; The one or more user interfaces further include a second output interface configured to display the one or more slow-moving materials or missing materials as a result of querying the database.

25. The computer-implemented method of claim 23, wherein: 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 corresponding material in the first group; Wherein, the computer-implemented method further 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.

26. The computer-implemented method of claim 23, wherein: 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; Wherein, the computer-implemented method further comprises: calculating an adjusted maximum consumption of the corresponding material in the first group based on the adjusted demand for the one or more product components; comparing the adjusted maximum consumption of the corresponding material in the first group with the available inventory of the corresponding material in the first group; Re-determine whether the corresponding materials in the first group are sluggish or short.

27. The computer-implemented method of claim 2, further comprising: Receiving a material status query instruction input by a user through the first input interface; In response to the instruction to query the material status, at least one of the remaining quantity, stagnant 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 is obtained from the data source.

28. An apparatus for managing the production of one or more products, comprising: Memory; one or more processors; wherein the memory and the one or more processors are connected to each other; The memory stores a or multiple processors to perform the following computer-executable instructions: Receiving a material query instruction input by a user through a first input interface; In response to the material query instruction, obtaining data about a plurality of materials for manufacturing one or more product components from a data source, wherein the data about the plurality of materials includes available inventory quantities of the plurality of materials; calculating a maximum consumption of the plurality of materials relative to at least one product component of the one or more product components; It is determined whether there is a shortage of one or more materials for manufacturing one or more product components according to the maximum consumption of corresponding materials of the multiple materials and the available inventory of corresponding materials of the multiple materials.

29. A computer program product comprising a non-transitory tangible computer readable medium having computer readable instructions thereon, the computer readable instructions executable by a processor to cause the processor to: Receiving a material query instruction input by a user through a first input interface; In response to the material query instruction, obtaining data on a plurality of materials for manufacturing one or more product components from a data source, wherein the data on the plurality of materials includes available inventory quantities of the plurality of materials; calculating a maximum consumption of the plurality of materials relative to at least one product component of the one or more product components; It is determined whether there is a shortage of one or more materials for manufacturing one or more product components according to the maximum consumption of corresponding materials of the multiple materials and the available inventory of corresponding materials of the multiple materials.