Computer-implemented methods, apparatus and computer program products

Abstract

A computer-implemented method, apparatus, and computer program product includes: receiving a material query command input by a user via a first input interface; responsive to the material query command, obtaining data related to a plurality of materials for manufacturing one or more product components from a data source, the data of the plurality of materials including available inventory amounts of the plurality of materials; calculating a maximum consumption amount of the plurality of materials for at least one of the one or more product components; and determining whether there is a shortage of the one or more materials for manufacturing the one or more product components based on the maximum consumption amount of corresponding materials of the plurality of materials and the available inventory amounts of corresponding materials of the plurality of materials.

Description

[Technical Field]

[0001] This application claims priority to a PCT international application filed on December 26, 2022, bearing application number PCT / CN2022 / 141880, entitled "Computer-implemented method, apparatus and computer program product for controlling the manufacturing of one or more products," and to a Chinese patent application filed on June 29, 2023, bearing application number 202310789914.X, entitled "Computer-implemented method, apparatus and computer program product," the contents of which are hereby incorporated by reference.

[0002] TECHNICAL FIELD Embodiments of the present disclosure relate to the field of display technology, and in particular, but not exclusively, to computer-implemented methods, apparatus and computer program products. [Background technology]

[0003] Managing product manufacturing is a complex process, and when it involves large quantities of products and starting materials, material management becomes difficult when product demand and manufacturing process engineering change rapidly within a short period of time. Traditional material management and simple programming are not enough to manage manufacturing, and material management is difficult, resulting in material shortages, overstock, and waste. Summary of the Invention

[0004] The following is a general overview of the subject matter detailed in this disclosure, which is not intended to limit the scope of protection of the claims.

[0005] In a first aspect, embodiments of the present disclosure further provide a computer-implemented method, comprising: receiving a material query command input by a user via a first input interface; retrieving, in response to the material query instruction, data from a data source regarding a plurality of materials for manufacturing one or more product components, the data regarding the plurality of materials including available inventory amounts of the plurality of materials; calculating a maximum consumption amount of the plurality of materials for at least one product component of the one or more product components; and determining whether there is a shortage of one or more materials for manufacturing one or more product components based on a maximum consumption amount of corresponding materials of the plurality of materials and an available inventory amount of corresponding materials of the plurality of materials.

[0006] In an exemplary embodiment, the method comprises: determining if a next level of material exists for the material having a shortage when determining that there is a shortage of a plurality of materials for manufacturing one or more product components; When determining that next-level materials exist for the material having a shortage, acquiring data of a plurality of next-level materials for the one or more materials having a shortage for manufacturing one or more product components, wherein the data of the plurality of next-level materials for the one or more materials having a shortage includes available inventory amounts of the plurality of next-level materials; calculating a maximum consumption amount of the plurality of next-level materials for at least one material of the one or more materials having a shortage; The method further includes determining whether there is a shortage of the plurality of next-level materials based on the maximum consumption amount and available inventory amount of corresponding materials of the plurality of next-level materials.

[0007] In an exemplary embodiment, the data on the plurality of materials includes substitution relationship information between the plurality of materials, and the data on the plurality of next-level materials further includes substitution relationship information between the next-level materials; Before acquiring data of a plurality of next-level materials of the one or more materials having a shortage for manufacturing the one or more product components, the method further includes determining one or more materials having a shortage in a second group from the one or more materials having a shortage based on substitution relationship information among the plurality of materials, wherein the one or more materials having a shortage in the second group are materials that are not substitutable for at least one product component of the one or more product components; Before calculating the maximum consumption amount of the plurality of next-level materials for at least one of the one or more materials having a shortage, the method further includes determining data of one or more next-level materials in a third group and data of one or more next-level materials in a fourth group from data of the one or more materials having a shortage in the second group based on substitution relationship information between the next-level materials, wherein the one or more next-level materials in the third group are materials that can be substituted for at least one of the one or more materials having a shortage in the second group, and the one or more next-level materials in the fourth group are materials that cannot be substituted for at least one of the one or more materials having a shortage in the second group.

[0008] In an exemplary embodiment, calculating a maximum consumption amount of the plurality of materials for at least one product component of the one or more product components includes calculating a maximum consumption amount of one or more materials in the second group for the one or more product components based on data of the one or more materials in the second group; Determining whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption amounts of corresponding materials of the plurality of materials and the available inventory amounts of corresponding materials of the plurality of materials includes calculating a remaining amount of one or more materials in the second group based on the available inventory amounts of the one or more materials in the second group and the maximum consumption amounts of the 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 amount of the one or more materials in the second group.

[0009] In an exemplary embodiment, calculating the maximum consumption amount of the one or more materials in the second group for one or more product components based on the data of the one or more materials in the second group includes obtaining the maximum consumption amount of the one or more materials in the second group for the one or more product components by summing values ​​obtained by multiplying the demand amount of the one or more product components that require the one or more materials in the second group as non-substitutable materials by the corresponding unit consumption values ​​of the corresponding materials in the second group for the production of the one or more product components.

[0010] In an exemplary embodiment, if it is determined that there is a shortage of one or more materials in the second group, the method further includes calculating a shortage amount of the one or more materials in the second group that is in shortage based on an available inventory amount of the one or more materials in the second group that is in shortage and a maximum consumption amount of the one or more materials in the second group that is in shortage.

[0011] In an exemplary embodiment, calculating a maximum consumption amount of the plurality of next-level materials for at least one material among the one or more materials having a shortage includes calculating a maximum consumption amount of one or more next-level materials in a fourth group for one or more materials having a shortage in a second group; Determining whether there is a shortage of the plurality of next-level materials based on the maximum consumption and available inventory of corresponding materials of the plurality of next-level materials includes: subtracting the maximum consumption of one or more next-level materials in the fourth group from the available inventory of the one or more next-level materials in the fourth group to obtain a remaining amount of the 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 amount of the one or more next-level materials in the fourth group.

[0012] In an exemplary embodiment, calculating the maximum consumption of one or more next-level materials in the fourth group for one or more materials in the second group that are in short supply includes using the sum of values ​​obtained by multiplying the shortage amounts of one or more materials in the second group that require one or more next-level materials in the fourth group as non-substitutable materials by the unit consumption values ​​of the corresponding materials in the fourth group for the production of the one or more corresponding materials in the second group that are in short supply.

[0013] In an exemplary embodiment, the method comprises: When determining that there is a shortage of one or more next-level materials in the fourth group, obtain a shortage amount of the one or more next-level materials in the fourth group based on the remaining amount of the one or more next-level materials in the fourth group, and display the shortage amount and shortage status of the one or more next-level materials in the fourth group through a 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 amount is 0, displaying the remaining amount and material status of the one or more next-level materials in the fourth group via 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 that the remaining amount is greater than 0, it determines 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 shortage 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 shortage, it determines that there is an overstock of one or more next-level materials in the fourth group, and displays the overstock status and remaining amount of the one or more next-level materials in the fourth group via a first output interface.

[0014] In an exemplary embodiment, calculating a maximum consumption amount of the plurality of next-level materials for at least one material among the one or more materials having a shortage includes calculating, using a third linear programming model, a maximum consumption amount of one or more semi-finished product components in a third group for one or more materials having a shortage in a second group; Determining whether there is a shortage of the plurality of next-level materials based on the maximum consumption and available inventory of corresponding materials of the plurality of next-level materials includes: subtracting the maximum consumption of one or more next-level materials in the third group from the available inventory of the one or more next-level materials in the third group to obtain a remaining amount of the 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 amount of the one or more next-level materials in the third group.

[0015] In an exemplary embodiment, the method comprises: When determining that there is a shortage of one or more next-level materials in the third group, obtain a shortage amount of the one or more next-level materials in the third group based on the remaining amount of the one or more next-level materials in the third group, and display the shortage amount and shortage status of the one or more next-level materials in the third group through a 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 amount is 0, displaying the remaining amount and material status of the one or more next-level materials in the third group via 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 that the remaining amount is greater than 0, it determines whether the one or more next-level materials in the third group are substitutable for at least one of the one or more materials in the first group that are in shortage based on the substitution relationship information between the next-level materials; when it is determined that the one or more materials in the third group are not substitutable for the one or more materials in the first group that are in shortage, it determines that there is an overstock of one or more next-level materials in the third group, and displays the overstock status and remaining amount of the one or more next-level materials in the third group via a first output interface.

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

number

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

number

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

number

[0019] In an exemplary embodiment, the data on the plurality of materials includes substitution relationship information among the plurality of materials and demand quantities of one or more product components; Before acquiring data of a plurality of next-level materials of one or more materials that are in short supply for manufacturing the one or more product components, determining one or more materials in a first group from the plurality of materials based on substitution relationship information among the plurality of materials, wherein the one or more materials in the first group are substitutable materials for at least one product component of the one or more product components; Calculating a maximum consumption amount of the plurality of materials for at least one product component of the one or more product components includes calculating a maximum consumption amount of one or more materials in the first group for the one or more product components based on data of the one or more materials in the first group; Determining whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption amount of corresponding materials of the plurality of materials and the available inventory amount of corresponding materials of the plurality of materials includes: obtaining a satisfactory amount of one or more substitutable material groups in the first group for the one or more product components when the consumption amount of the one or more materials in the first group for the one or more product components is at the maximum consumption amount; and determining whether there is a shortage of one or more substitutable material groups in the first group for the corresponding product components based on the satisfactory amount of the one or more substitutable material groups in the first group for the one or more product components and the demand amount of the one or more product components.

[0020] In an exemplary embodiment, when determining that there is a shortage in a plurality of materials for manufacturing the one or more product components, determining whether a next-level material exists for the material with the shortage includes, when determining that there is a shortage in one or more substitutable material groups in a first group for the corresponding product component, determining whether a next-level material exists for the material group with the shortage in the first group; When it is determined that a next-level material exists for the material having a shortage, acquiring data on a plurality of next-level materials for the one or more materials having a shortage for manufacturing the one or more product components includes, when it is determined that a next-level material exists for a material group having a shortage in the first group, acquiring material data on one or more next-level materials for the one or more material groups having a shortage in the first group; Calculating the maximum consumption amount of the plurality of next-level materials for at least one material of the one or more materials having a shortage includes: determining the plurality of next-level materials of the one or more material groups having a shortage 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 amount of the one or more next-level materials in the fifth group for the product component corresponding to the one or more material groups having a shortage in the first group; Determining whether there is a shortage of the plurality of next-level materials based on the maximum consumption and available inventory of the corresponding materials of the plurality of next-level materials includes calculating a remaining amount 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 a maximum consumption amount of one or more next-level materials in the fifth group for product components corresponding to the corresponding material groups in the first group having one or more shortages, and determining whether there is a shortage of one or more next-level materials in the fifth group based on the remaining amount of one or more next-level materials in the fifth group.

[0021] In an exemplary embodiment, when determining that there is a shortage of one or more substitutable material groups in the first group for the corresponding product component, the method further includes: calculating a shortage amount of the one or more substitutable material groups in the first group for the corresponding product component based on the satisfyable amount of the one or more substitutable material groups in the first group for the corresponding product component and the demand amount of the material in the first group that is in shortage; When determining that one or more next-level materials in the fifth group are in short supply, calculate a sixth shortage value based on the sufficient quantity of one or more next-level materials in the fifth group for producing the corresponding materials in the first group that are in short supply and the shortage amount of the corresponding material group in the first group that is in short supply, and update the shortage amount of the corresponding material group in the first group that is in short supply using the sixth shortage value; The method further includes obtaining the configuration parameters, reallocating the shortage amount of the shortage material in the corresponding material group that has a shortage in the first group based on the configuration parameters, updating the shortage amount of the corresponding material in the first group using the allocated shortage amount, and displaying the shortage amount and shortage status of the corresponding material in the first group through a first output interface.

[0022] In an exemplary embodiment, the method comprises: When it is determined that there is a shortage of one or more next-level materials in the fifth group, obtain the shortage amount of the one or more next-level materials in the fifth group based on the remaining amount of the one or more next-level materials in the fifth group, and display the shortage amount and shortage status of the one or more next-level materials in the fifth group 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 amount is greater than 0, outputting the remaining amount and overstock status of the one or more next-level materials in the fifth group via the first display interface; The method further includes outputting the remaining amount and material status of one or more next-level materials in the fifth group via the first display interface when it is determined that there is no shortage of the one or more next-level materials in the fifth group and that the remaining amount is 0.

[0023] In an exemplary embodiment, the method comprises: When it is determined that one or more next-level materials in the fifth group are in short supply, the method further includes obtaining configuration parameters of the next-level materials, reallocating the shortage quantities of the shortage materials in the corresponding next-level material groups in the fifth group that have shortages based on the configuration parameters of the next-level materials, updating the shortage quantities of the corresponding next-level materials in the fifth group with the reallocated shortage quantities, and displaying the updated shortage quantities and shortage status of the corresponding next-level materials in the fifth group through the first output interface.

[0024] In an exemplary embodiment, if the method determines that there is a shortage of one or more next-level materials in the fifth group, it further includes obtaining configuration parameters of the next-level materials, reallocating the shortage quantities of the corresponding next-level materials in the fifth group that have a shortage based on the configuration parameters of the next-level materials, and updating the shortage quantities of the corresponding next-level materials in the fifth group with the reallocated shortage quantities.

[0025] In an exemplary embodiment, the method includes, if determining that no next-level material exists for the material having a shortage, displaying a shortage status of the material having a shortage via a first output interface; When it is determined that there is no shortage of one or more materials used to manufacture the one or more product components, the method further includes displaying material information of the one or more materials used to manufacture the one or more product components via the first output interface.

[0026] In an exemplary embodiment, the method further includes, if it is determined that there is an overstock or shortage of one or more materials having a shortage based on the maximum consumption and available inventory of corresponding materials of the plurality of next-level materials, adjusting demand for the one or more product components to minimize the overstock or shortage of next-level materials, and manufacturing the one or more product components based on the adjusted demand for the one or more product components.

[0027] In an exemplary embodiment, the method further includes generating one or more user interfaces; The one or more user interfaces include the first output interface, which is further configured to display the material status of the corresponding materials in at least one of the first to fifth groups.

[0028] In an exemplary embodiment, the one or more user interfaces further include a first input interface, the first input interface configured to receive one or more user inputs for querying a database, the database storing data for a plurality of materials; The computer-implemented method further includes receiving a user selection of one or more conditions from the first input interface, the user selection being used to select a material condition associated with the one or more conditions; and querying the database in response to the user selection to determine one or more material conditions associated with the one or more conditions in the database; the one or more conditions include at least one of an overstock condition for an overstocked material and a shortage condition for a shortage material; The one or more user interfaces further include a second output interface configured to display the one or more overstocked or understocked materials as a result of querying the database.

[0029] In an exemplary embodiment, the one or more user interfaces further include a second input interface, the second input interface configured to receive one or more user inputs for adjusting the priorities of the corresponding materials in the first group; The computer-implemented method further includes re-determining whether the corresponding materials in the first group are overstocked or understocked based on the adjusted priorities of the corresponding materials in the first group.

[0030] In an exemplary embodiment, the one or more user interfaces further include a third input interface, the third input interface configured to receive one or more user inputs for adjusting the demand for the one or more product components; The computer-implemented method includes calculating an adjusted maximum consumption amount 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 amount of the corresponding material in the first group with the available inventory amount of the corresponding material in the first group; and redetermining whether there is an overstock or shortage of the corresponding materials in the first group.

[0031] In an exemplary embodiment, the method comprises: receiving a material status inquiry command input by a user via the first input interface; The method further includes, in response to the material status query command, obtaining from a data source at least one of remaining quantities, overstock status, shortage status, and shortage quantities for a plurality of materials and a plurality of next-level materials for manufacturing the one or more product components.

[0032] In a second aspect, embodiments of the present disclosure provide a computer-implemented method, comprising: acquiring data on a plurality of next-level materials for one or more materials having a shortage for manufacturing one or more product components, the data on the plurality of next-level materials for the one or more materials having a shortage including available inventory amounts of the plurality of next-level materials; calculating a maximum consumption amount of the plurality of next-level materials for at least one material of the one or more materials having a shortage; and determining whether there is a shortage of one or more of the materials having a shortage based on the maximum consumption amounts and available inventory amounts of corresponding materials of the plurality of next-level materials.

[0033] In an exemplary embodiment, prior to obtaining data on the plurality of next-level materials for one or more materials that have a shortage for manufacturing the one or more product components, acquiring data regarding a plurality of materials for manufacturing one or more product components, the data regarding the plurality of materials including available inventory amounts of the plurality of materials; calculating a maximum consumption amount of the plurality of materials for at least one product component of the one or more product components; The method further includes determining whether there is a shortage of one or more materials for manufacturing one or more product components based on a maximum consumption amount of corresponding materials of the plurality of materials and an available inventory amount of corresponding materials of the plurality of materials.

[0034] In an exemplary embodiment, the method comprises: determining if a next level of material exists for the material having a shortage when determining that there is a shortage of a plurality of materials for manufacturing one or more product components; When it is determined that there is a next-level material for the material having a shortage, the method further includes obtaining data on a plurality of next-level materials for the one or more materials having a shortage for manufacturing the one or more product components.

[0035] In an exemplary embodiment, the data for the plurality of materials includes substitution relationship information between the plurality of materials; Before acquiring data on multiple next-level materials of the one or more materials that are in short supply for manufacturing the one or more product components, the method further includes determining one or more materials that are in short supply in a second group from the one or more materials that are in short supply based on substitution relationship information between the multiple materials, wherein the one or more materials that are in short supply in the second group are materials that are not substitutable for at least one product component of the one or more product components.

[0036] In an exemplary embodiment, the data of the plurality of next-level materials further includes substitution relationship information between the next-level materials; Before calculating the maximum consumption amount of the plurality of next-level materials for at least one of the one or more materials having a shortage, the method further includes determining data of one or more next-level materials in a third group and data of one or more next-level materials in a fourth group from data of the one or more materials having a shortage in the second group based on substitution relationship information between the next-level materials, wherein the one or more next-level materials in the third group are materials that can be substituted for at least one of the one or more materials having a shortage in the second group, and the one or more next-level materials in the fourth group are materials that cannot be substituted for at least one of the one or more materials having a shortage in the second group.

[0037] In an exemplary embodiment, calculating a maximum consumption amount of the plurality of materials for at least one product component of the one or more product components includes calculating a maximum consumption amount of one or more materials in the second group for the one or more product components based on data of the one or more materials in the second group; Determining whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption amounts of corresponding materials of the plurality of materials and the available inventory amounts of corresponding materials of the plurality of materials includes calculating a remaining amount of one or more materials in the second group that has a shortage based on the available inventory amounts of the one or more materials in the second group and the maximum consumption amounts of the 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 amount of the one or more materials in the second group.

[0038] In an exemplary embodiment, if it is determined that there is a shortage of one or more materials in the second group, the method further includes calculating a shortage amount of the one or more materials in the second group that is in shortage based on an available inventory amount of the one or more materials in the second group that is in shortage and a maximum consumption amount of the one or more materials in the second group that is in shortage.

[0039] In an exemplary embodiment, calculating a maximum consumption amount of the plurality of materials for at least one product component of the one or more product components includes calculating a maximum consumption amount of one or more materials in the second group that have a shortage for at least one product component of the one or more product components; determining whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption amounts of corresponding materials of the plurality of materials and the available stock amounts of corresponding materials of the plurality of materials includes: calculating a remaining amount of one or more materials in the second group that is in a shortage based on the available stock amounts of one or more materials in the second group that is in a shortage and the maximum consumption amounts of one or more materials in the second group that is in a shortage; and determining whether there is a shortage of one or more materials in the second group that is in a shortage based on the remaining amount of one or more materials in the second group that is in a shortage; If it is determined that there is a shortage of one or more materials in the second group, the method further includes obtaining a shortage amount of the one or more materials in the second group that are in shortage based on a remaining amount of the one or more materials in the second group that are in shortage.

[0040] In an exemplary embodiment, the next-level material data further includes unit consumption values ​​of a plurality of next-level materials for manufacturing one or more materials in the second group that have shortages; calculating the maximum consumption amount of the plurality of next-level materials for at least one of the one or more materials having shortages includes: obtaining the maximum consumption amount of the one or more next-level materials in the fourth group for the one or more materials having shortages in the second group by using a sum of values ​​obtained by multiplying the shortage amount of the one or more materials having shortages in the second group that require the one or more next-level materials in the fourth group as non-substitutable materials by the unit consumption value of the corresponding next-level materials in the fourth group for the production of the one or more corresponding materials having shortages in the second group; Determining whether there is a shortage of one or more materials having a shortage based on the maximum consumption and available inventory of corresponding materials of the plurality of next-level materials includes: subtracting the maximum consumption of one or more next-level materials in the fourth group from the available inventory of the one or more next-level materials in the fourth group to obtain a remaining amount of the one or more next-level materials in the fourth group; and determining that there is a shortage of one or more materials in the fourth group if the remaining amount of the one or more next-level materials in the fourth group is less than 0.

[0041] In an exemplary embodiment, if the remaining amount of one or more next-level materials in the fourth group is greater than zero, the method includes: and determining whether 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 substitution relationship information between the next-level materials.

[0042] In an exemplary embodiment, if it is determined that one or more next-level materials in the fourth group are not substitutable materials for one or more materials in the first group that have a shortage, it is determined that there is an overstock of one or more materials in the fourth group.

[0043] In an exemplary embodiment, after obtaining the remaining amount of one or more next-level materials in the fourth group, The method further includes using the remaining amount of one or more next-level materials in the fourth group to update the available inventory amount of the corresponding next-level materials in the fourth group.

[0044] In an exemplary embodiment, calculating a maximum consumption amount of the plurality of next-level materials for at least one material of the one or more materials having a shortage includes calculating, using a third linear programming model, a maximum consumption amount of one or more next-level materials in a third group for one or more materials having a shortage in a second group; Determining whether there is a shortage of one or more materials having a shortage based on the maximum consumption and available inventory of corresponding materials of the plurality of next-level materials includes: subtracting the maximum consumption of one or more next-level materials in the third group from the available inventory of the one or more next-level materials in the third group to obtain a remaining amount of the one or more next-level materials in the third group; and determining that there is a shortage of one or more next-level materials in the third group if the remaining amount of the one or more next-level materials in the third group is less than 0.

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

number

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

number

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

number

[0048] In an exemplary embodiment, the data on the plurality of materials includes substitution relationship information among the plurality of materials and demand quantities of one or more product components; Before acquiring data of a plurality of next-level materials of one or more materials that are in short supply for manufacturing the one or more product components, determining one or more materials in a first group from the plurality of materials based on substitution relationship information among the plurality of materials, wherein the one or more materials in the first group are substitutable materials for at least one product component of the one or more product components; Calculating a maximum consumption amount of the plurality of materials for at least one product component of the one or more product components includes calculating a maximum consumption amount of one or more materials in the first group for the one or more product components based on data of the one or more materials in the first group; Determining whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption amount of corresponding materials of the plurality of materials and the available inventory amount of corresponding materials of the plurality of materials includes: obtaining a satisfactory amount of one or more substitutable material groups in the first group for the one or more product components when the consumption amount of the one or more materials in the first group for the one or more product components is at the maximum consumption amount; and determining whether there is a shortage of one or more substitutable material groups in the first group for the corresponding product components based on the satisfactory amount of the one or more substitutable material groups in the first group for the corresponding product components and the demand amount of the one or more product components in the first group.

[0049] In an exemplary embodiment, when determining that there is a shortage in a plurality of materials for manufacturing the one or more product components, determining whether a next-level material exists for the material with the shortage includes, when determining that there is a shortage in one or more substitutable material groups in a first group for the corresponding product component, determining whether a next-level material exists for the material group with the shortage in the first group; When it is determined that next-level materials exist for the material having a shortage, acquiring data on multiple next-level materials for the one or more materials having a shortage for manufacturing the one or more product components includes acquiring material data on one or more next-level materials for the one or more material groups having a shortage in the first group when it is determined that next-level materials exist for the material group having a shortage in the first group.

[0050] In an exemplary embodiment, calculating the maximum consumption amount of the plurality of next-level materials for at least one material of the one or more materials having a shortage includes: determining the plurality of next-level materials of the one or more material groups having a shortage 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 amount of the one or more next-level materials in the fifth group for a product component corresponding to the one or more material groups having a shortage in the first group; Determining whether there is a shortage of one or more materials having a shortage based on the maximum consumption and available inventory of the corresponding materials of the plurality of next-level materials includes calculating a remaining amount 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 a maximum consumption amount of one or more next-level materials in the fifth group for product components corresponding to the one or more corresponding material groups having a shortage 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 amount of one or more next-level materials in the fifth group.

[0051] In an exemplary embodiment, when determining that there is a shortage of one or more substitutable material groups in the first group for the corresponding product component, the method further includes: calculating a shortage amount of the one or more substitutable material groups in the first group for the corresponding product component based on the satisfyable amount of the one or more substitutable material groups in the first group for the corresponding product component and the demand amount of the material in the first group that is in shortage; When determining that one or more next-level materials in the fifth group are in short supply, calculate a sixth shortage value based on the sufficient quantity of one or more next-level materials in the fifth group for producing the corresponding materials in the first group that are in short supply and the shortage amount of the corresponding material group in the first group that is in short supply, and update the shortage amount of the corresponding material group in the first group that is in short supply using the sixth shortage value; The method further includes obtaining the configuration parameters, reallocating the shortage amount of the shortage material in the corresponding material group having a shortage in the first group based on the configuration parameters, and updating the shortage amount of the corresponding material in the first group using the reallocated shortage amount.

[0052] In an exemplary embodiment, if the method determines that there is a shortage of one or more next-level materials in the fifth group, it further includes obtaining configuration parameters of the next-level materials, reallocating the shortage quantities of the corresponding next-level materials in the fifth group that have a shortage based on the configuration parameters of the next-level materials, and updating the shortage quantities of the corresponding next-level materials in the fifth group with the reallocated shortage quantities.

[0053] In an exemplary embodiment, the method further includes, if it is determined that there is an overstock or shortage of one or more materials having a shortage based on the maximum consumption and available inventory of corresponding materials of the plurality of next-level materials, adjusting demand for the one or more product components to minimize the overstock or shortage of next-level materials, and manufacturing the one or more product components based on the adjusted demand for the one or more product components.

[0054] In an exemplary embodiment, the method further includes generating one or more user interfaces; The one or more user interfaces include a first output interface, which is configured to display the material status of the corresponding materials in at least one of the first to fifth groups.

[0055] In an exemplary embodiment, the one or more user interfaces further include a first input interface, the first input interface configured to receive one or more user inputs for querying a database, the database storing data for a plurality of materials; The computer-implemented method further includes receiving a user selection of one or more conditions from the first input interface, the user selection being used to select a material condition associated with the one or more conditions; and querying the database in response to the user selection to determine one or more material conditions associated with the one or more conditions in the database; the one or more conditions include at least one of an overstock condition for an overstocked material and a shortage condition for a shortage material; The one or more user interfaces further include a second output interface configured to display the one or more overstocked or understocked materials as a result of querying the database.

[0056] In an exemplary embodiment, the one or more user interfaces further include a second input interface, the second input interface configured to receive one or more user inputs for adjusting the priorities of the corresponding materials in the first group; The computer-implemented method further includes re-determining whether the corresponding materials in the first group are overstocked or understocked based on the adjusted priorities of the corresponding materials in the first group.

[0057] In an exemplary embodiment, the one or more user interfaces further include a third input interface, the third input interface configured to receive one or more user inputs for adjusting the demand for the one or more product components; The computer-implemented method includes calculating an adjusted maximum consumption amount 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 amount of the corresponding material in the first group with the available inventory amount of the corresponding material in the first group; and redetermining whether there is an overstock or shortage of the corresponding materials in the first group.

[0058] In a third aspect, embodiments of the present disclosure further provide an apparatus for managing production of one or more products, comprising: Memory and one or more processors; The memory and the one or more processors are connected to each other, and the memory is connected to the one or more processors. acquiring data on a plurality of next-level materials for one or more materials having a shortage for manufacturing one or more product components, the data on the plurality of next-level materials for the one or more materials having a shortage including available inventory amounts of the plurality of next-level materials; calculating a maximum consumption amount of the plurality of next-level materials for at least one material of the one or more materials having a shortage; and determining whether there is a shortage of one or more of the materials having a shortage based on maximum consumption amounts and available inventory amounts of corresponding materials of the plurality of next-level materials.

[0059] In a fourth aspect, embodiments of the present disclosure further provide a computer program product, comprising a computer-readable non-transitory tangible medium having computer-readable instructions, the computer-readable instructions being executable by a processor to cause the processor to: acquiring data on a plurality of next-level materials for one or more materials having a shortage for manufacturing one or more product components, the data on the plurality of next-level materials for the one or more materials having a shortage including available inventory amounts of the plurality of next-level materials; calculating a maximum consumption amount of the plurality of next-level materials for at least one material of the one or more materials having a shortage; and determining whether there is a shortage of one or more of the materials that have a shortage based on the maximum consumption amounts and available stock amounts of corresponding materials of the plurality of next-level materials.

[0060] In a fifth aspect, embodiments of the present disclosure further provide an apparatus for managing production of one or more products, comprising: Memory and one or more processors; The memory and the one or more processors are connected to each other, and the memory is connected to the one or more processors. receiving a material query command input by a user via a first input interface; retrieving, in response to the material query instruction, data from a data source regarding a plurality of materials for manufacturing one or more product components, the data regarding the plurality of materials including available inventory amounts of the plurality of materials; calculating a maximum consumption amount of the plurality of materials for at least one product component of the one or more product components; and determining whether there is a shortage of one or more materials for manufacturing one or more product components based on a maximum consumption amount of corresponding materials of the plurality of materials and an available inventory amount of corresponding materials of the plurality of materials.

[0061] In a sixth aspect, embodiments of the present disclosure further provide a computer program product, comprising a computer-readable non-transitory tangible medium having computer-readable instructions, the computer-readable instructions being executable by a processor to cause the processor to: receiving a material query command input by a user via a first input interface; retrieving, in response to the material query instruction, data from a data source regarding a plurality of materials for manufacturing one or more product components, the data regarding the plurality of materials including available inventory amounts of the plurality of materials; calculating a maximum consumption amount of the plurality of materials for at least one product component of the one or more product components; and determining whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption amount of corresponding materials of the plurality of materials and the available inventory amount of corresponding materials of the plurality of materials.

[0062] Other aspects may be understood after reading and understanding the accompanying drawings and detailed description.

[0063] The drawings are intended to provide a better understanding of the technical solutions of the present disclosure, constitute a part of the specification, and are used to explain the technical solutions of the embodiments of the present disclosure together with the embodiments of the present disclosure, but are not intended to limit the technical solutions of the present disclosure. [Brief explanation of the drawings]

[0064] [Figure 1] 1 is a flowchart of a computer-implemented method according to an embodiment of the present disclosure. [Figure 2] 1 is a flowchart of a computer-implemented method according to an exemplary embodiment of the present disclosure. [Figure 3a] 1 is a flowchart of a computer-implemented method according to an exemplary embodiment of the present disclosure. [Figure 3b] 1 is a flowchart of a computer-implemented method according to an exemplary embodiment of the present disclosure. [Figure 4] FIG. 2 is a schematic diagram of one or more interfaces according to an exemplary embodiment of the present disclosure. [Figure 5] FIG. 10 is a schematic diagram of a third output interface according to an exemplary embodiment of the present disclosure. [Figure 6] FIG. 1 is a schematic diagram of a manufacturing control device module for one or more products according to an exemplary embodiment of the present disclosure. [Figure 7] 1 is a structural schematic diagram of a manufacturing control device for one or more products according to an exemplary embodiment of the present disclosure; DETAILED DESCRIPTION OF THE INVENTION

[0065] Hereinafter, embodiments of the present disclosure will be described in detail with reference to the drawings. Note that the embodiments and features of the embodiments of the present disclosure may be arbitrarily combined as long as they do not conflict with each other.

[0066] Unless otherwise defined, technical or scientific terms disclosed and used in the embodiments of the present disclosure should have the ordinary meaning understood by those skilled in the art. The terms "first," "second," and similar terms used in the embodiments of the present disclosure do not represent order, quantity, or importance, but are only used to distinguish different components. Similar terms such as "comprise" or "contain" mean that the element or entity before the term includes the elements or entities listed after the term and their equivalents, and do not exclude other elements or entities.

[0067] In the product manufacturing management process, when there are many types of products to be manufactured and the shared and substitutable relationships of related materials are complex, the control and management of shared and substitutable materials is relatively difficult, and material overstocks often result in material waste, and material shortages often result in extended production cycles (even product shipping delays), leading to 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 material overstocks or shortages become more serious.

[0068] An embodiment of the present disclosure provides a computer-implemented method, receiving a material query command input by a user via a first input interface; retrieving, in response to the material query instruction, data from a data source regarding a plurality of materials for manufacturing one or more product components, the data regarding the plurality of materials including available inventory amounts of the plurality of materials; calculating a maximum consumption amount of the plurality of materials for at least one product component of the one or more product components; and determining whether there is a shortage of one or more materials for manufacturing one or more product components based on a maximum consumption amount of corresponding materials of the plurality of materials and an available inventory amount of corresponding materials of the plurality of materials.

[0069] A computer-implemented method according to an embodiment of the present disclosure includes receiving a material query command input by a user via a first input interface, and in response to the material query command, obtaining data on a plurality of materials used to manufacture one or more product components from a data source, the data on the plurality of materials including available inventory amounts of the plurality of materials, calculating a maximum consumption amount of the plurality of materials for at least one of the one or more product components, and determining whether there is a shortage of one or more materials used to manufacture the one or more product components based on the maximum consumption amount of corresponding materials of the plurality of materials and the available inventory amounts of corresponding materials of the plurality of materials. The technical solution according to an embodiment of the present disclosure can solve the problem of overstock or shortage of materials in a materials management process.

[0070] As shown in FIG. 1, the computer-implemented method provided by the embodiment of the present disclosure may include steps 21 to 24.

[0071] Step 21: receiving a material inquiry command input by a user through a first input interface;

[0072] Step 22, in response to the material query command, retrieve data from a data source regarding a plurality of materials for manufacturing one or more product components, the data for the plurality of materials including available inventory amounts of the plurality of materials.

[0073] Step 23, calculating maximum consumption amounts of the plurality of materials for at least one product component of the one or more product components.

[0074] 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 amount of the corresponding materials of the plurality of materials and the available inventory amount of the corresponding materials of the plurality of materials.

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

[0076] In an exemplary embodiment, the maximum consumption amount of the plurality of materials for at least one product component of the one or more product components may be understood as a target demand amount of the plurality of materials in manufacturing the one or more product components.

[0077] A computer-implemented method according to an embodiment of the present disclosure can, when there is a shortage of materials in the manufacturing process of one or more product components, consume materials of the next level to the materials that are in short supply to replenish the materials that are in short supply, and determine whether there is a shortage of the materials after replenishment. This can, on the one hand, maximize the consumption of materials of the next level and avoid overstock of materials of the next level, and, on the other hand, replenish materials that are in short supply in a timely manner, thereby significantly solving the problem of overstock or shortage of materials in the material management process.

[0078] In an exemplary embodiment, the method comprises: If it is determined in step 24 that there is a shortage of a plurality of materials for manufacturing one or more product components, steps 241 to 244 may be further performed.

[0079] Step 241: Determine whether or not there is a next level of material for the material that is in short supply.

[0080] Step 242, if it is determined that next-level materials exist for the material having a shortage, obtain data for multiple next-level materials for the one or more materials having a shortage for manufacturing the one or more product components, and the data for the multiple next-level materials for the one or more materials having a shortage includes available inventory amounts of the multiple next-level materials.

[0081] Step 243 calculates maximum consumption amounts of multiple next-level materials for at least one of the one or more materials having a shortage.

[0082] Step 244: Determine whether there is a shortage of the plurality of next-level materials based on the maximum consumption amount and available inventory amount of the corresponding materials of the plurality of next-level materials.

[0083] In an exemplary embodiment, the data for the plurality of materials includes substitution relationship information between the plurality of materials, and the data for the plurality of next-level materials further includes substitution relationship information between the next-level materials. In step 242, before obtaining data of multiple next-level materials of the one or more materials having a shortage for manufacturing the one or more product components, the method may further include determining one or more materials having a shortage in a second group from the one or more materials having a shortage based on substitution relationship information between the multiple materials, where the one or more materials having a shortage in the second group are materials that are non-substitutable for at least one product component of the one or more product components. In step 243, before calculating the maximum consumption amount of the plurality of next-level materials for at least one of the one or more materials having a shortage, the method may further include determining data of one or more next-level materials in the third group and data of one or more next-level materials in the fourth group from data of the one or more materials having a shortage in the second group based on substitution relationship information between the next-level materials, wherein the one or more next-level materials in the third group are substitutable for at least one of the one or more materials having a shortage in the second group, and the one or more next-level materials in the fourth group are non-substitutable for at least one of the one or more materials having a shortage in the second group.

[0084] In an exemplary embodiment, in step 23, calculating a maximum consumption amount of the plurality of materials for at least one product component of the one or more product components may include calculating a maximum consumption amount of the one or more materials in the second group for the one or more product components based on data of the one or more materials in the second group; In step 24, determining whether there is a shortage of one or more materials for manufacturing the one or more product components based on the maximum consumption amounts of corresponding materials of the plurality of materials and the available inventory amounts of corresponding materials of the plurality of materials may include calculating a remaining amount of one or more materials in the second group based on the available inventory amounts of the one or more materials in the second group and the maximum consumption amounts of the 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 amount of the one or more materials in the second group.

[0085] In an exemplary embodiment, calculating the maximum consumption amount of the one or more materials in the second group for the one or more product components based on the data of the one or more materials in the second group may include obtaining the maximum consumption amount of the one or more materials in the second group for the one or more product components by summing values ​​obtained by multiplying the demand amount of the one or more product components that require the one or more materials in the second group as non-substitutable materials by the corresponding unit consumption values ​​of the corresponding materials in the second group for the production of the one or more product components.

[0086] In an exemplary embodiment, if it is determined that there is a shortage of one or more materials in the second group, the method may further include calculating a shortage amount of the one or more materials in the second group that is in a shortage based on an available inventory amount of the one or more materials in the second group that is in a shortage and a maximum consumption amount of the one or more materials in the second group that is in a shortage.

[0087] In an exemplary embodiment, the remaining amount of one or more materials in the second group that have a shortage can be calculated based on the available inventory amount of the one or more materials in the second group that have a shortage and the maximum consumption amount of the one or more materials in the second group that have a shortage; for example, the remaining amount of one or more materials in the second group that have a shortage is obtained by subtracting the maximum consumption amount of the one or more materials in the second group that have a shortage from the available inventory amount of the one or more materials in the second group that have a shortage; if the remaining amount of one or more materials in the second group that have a shortage is less than 0, it is determined that there is a shortage in one or more materials in the second group, and the shortage amount may be a negative number of the remaining amount (if the remaining amount is less than 0, the shortage amount may be a numerical value greater than 0).

[0088] In an exemplary embodiment, calculating the maximum consumption amounts of the plurality of next-level materials for at least one of the one or more materials having a shortage in step 243 may include calculating, in step 231, the maximum consumption amounts of one or more next-level materials in the fourth group for the one or more materials having a shortage in the second group. In step 244, determining whether there is a shortage of the plurality of next-level materials based on the maximum consumption and available inventory of the corresponding materials of the plurality of next-level materials may include subtracting the maximum consumption of the one or more next-level materials in the fourth group from the available inventory of the one or more next-level materials in the fourth group to obtain a remaining amount of the one or more next-level materials in the fourth group, and determining whether there is a shortage of the one or more next-level materials in the fourth group based on the remaining amount of the one or more next-level materials in the fourth group.

[0089] In an exemplary embodiment, calculating the maximum consumption of the one or more next-level materials in the fourth group for the one or more materials in the second group that are in short supply includes using a sum of values ​​obtained by multiplying the shortage amounts of the one or more next-level materials in the second group that require the one or more next-level materials in the fourth group as non-substitutable materials by the unit consumption values ​​of the corresponding next-level materials in the fourth group for the production of the one or more corresponding materials in short supply in the second group.

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

[0091] In an exemplary embodiment, the method comprises: when determining that there is a shortage of one or more next-level materials in the fourth group, obtain a shortage amount of the one or more next-level materials in the fourth group based on the remaining amount of the one or more next-level materials in the fourth group, and display the shortage amount and shortage status of the one or more next-level materials in the fourth group through a 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 amount is 0, displaying the remaining amount and material status of the one or more next-level materials in the fourth group through the first output interface (the material status may include a state in which the materials just meet the production demand); When it is determined that there is no shortage of one or more next-level materials in the fourth group and that the remaining amount is greater than 0, it determines 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 shortage 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 shortage, it determines that there is an overstock of one or more next-level materials in the fourth group, and displays the overstock status and remaining amount of the one or more next-level materials in the fourth group via the first output interface.

[0092] In an example embodiment, calculating the maximum consumption amounts of the plurality of next-level materials for at least one of the one or more materials having a shortage in Step 243 may include calculating, using a third linear programming model, the maximum consumption amounts of the one or more semi-finished product components in the third group for the one or more materials having a shortage in the second group.

[0093] In step 244, determining whether there is a shortage of the plurality of next-level materials based on the maximum consumption and available inventory of the corresponding materials of the plurality of next-level materials may include subtracting the maximum consumption of the one or more next-level materials in the third group from the available inventory of the one or more next-level materials in the third group to obtain a remaining amount of the one or more next-level materials in the third group, and determining whether there is a shortage of the one or more next-level materials in the third group based on the remaining amount of the one or more next-level materials in the third group.

[0094] In an exemplary embodiment, the method comprises: when determining that there is a shortage of one or more next-level materials in the third group, obtain a shortage amount of the one or more next-level materials in the third group based on the remaining amount of the one or more next-level materials in the third group, and display the shortage amount and shortage status of the one or more next-level materials in the third group through a 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 amount is 0, displaying the remaining amount and material status of the one or more next-level materials in the third group via 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 that the remaining amount is greater than 0, it may further include determining, based on the substitution relationship information between the next-level materials, whether the one or more next-level materials in the third group are substitutable for at least one of the one or more materials in the first group that are in shortage; when it is determined that the one or more materials in the third group are not substitutable for the one or more materials in the first group that are in shortage, it may further include determining that there is an overstock of one or more next-level materials in the third group, and displaying the overstock status and remaining amount of the one or more next-level materials in the third group via the first output interface.

[0095] In an exemplary embodiment, if it is determined that one or more next-level materials in the third group are in short supply, the method may further include: obtaining shortage amounts of one or more next-level materials in the third group based on the remaining amounts of the one or more next-level materials in the third group; then obtaining configuration parameters; reallocating the shortage amounts of the shortage materials in the corresponding material groups in the third group that have shortages based on the configuration parameters; and updating the shortage amounts of the corresponding materials in the third group using the reallocated shortage amounts. In an exemplary embodiment, the configuration parameters may be set according to actual business needs, including but not limited to material priority. For example, the shortage amount may be allocated according to the size of the shared quantity of the substitutable material or the availability of the substitutable material. In an exemplary embodiment, obtaining the configuration parameters may include receiving configuration parameter data entered by a user through a first input interface; and reallocating the shortage amounts of the shortage materials in the corresponding material groups in the third group that have shortages based on the configuration parameter data entered by the user, thereby enabling more flexible material management and minimizing overstocking and shortages of materials.

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

number

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

number

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

number

[0099] In an exemplary embodiment, the data for the plurality of materials may include substitution relationship information between the plurality of materials and demand quantities for one or more product components. In step 242, before obtaining data on multiple next-level materials for the one or more materials that are in short supply for manufacturing the one or more product components, the method may further include determining one or more materials in a first group from the multiple materials based on substitution relationship information between the multiple materials, and the one or more materials in the first group being substitutable materials for at least one product component of the one or more product components. In step 23, calculating a maximum consumption amount of the plurality of materials for at least one product component of the one or more product components may include calculating a maximum consumption amount of the one or more materials in the first group for the one or more product components based on data of the one or more materials in the first group. In step 24, determining whether there is a shortage of one or more materials for manufacturing the one or more product components based on the maximum consumption amount of corresponding materials of the plurality of materials and the available inventory amount of corresponding materials of the plurality of materials may include obtaining a satisfactory amount of one or more substitutable material groups in the first group for the one or more product components when the consumption amount of the one or more materials in the first group for the one or more product components is at the maximum consumption amount, and determining whether there is a shortage of one or more substitutable material groups in the first group for the corresponding product components based on the satisfactory amount of the one or more substitutable material groups in the first group for the one or more product components and the demand amount of the one or more product components.

[0100] In an exemplary embodiment, in step 24, if it is determined that there is a shortage of one or more materials used to manufacture one or more product components, determining whether a next-level material exists for the material with the shortage may include, if it is determined that there is a shortage of one or more substitutable material groups in the first group for the corresponding product components, determining whether a next-level material exists for the material group with the shortage in the first group. In step 242, if it is determined that next-level materials exist for the material having a shortage, obtaining data on multiple next-level materials for the one or more materials having a shortage for manufacturing the one or more product components may include obtaining material data on one or more next-level materials for the one or more material groups having a shortage in the first group if it is determined that next-level materials exist for the material group having a shortage in the first group. In step 243, calculating maximum consumption amounts of the multiple next-level materials for at least one material of the one or more materials having a shortage may include: setting the multiple next-level materials of the one or more material groups having a shortage 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, maximum consumption amounts of the one or more next-level materials in the fifth group for product components corresponding to the one or more material groups having a shortage in the first group. In step 244, 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 may include calculating a remaining amount of the one or more next-level materials in the fifth group based on the available inventory of the one or more next-level materials in the fifth group and a maximum consumption amount of the one or more next-level materials in the fifth group for the product components corresponding to the corresponding material groups in the first group that have one or more shortages, and determining whether there is a shortage of the one or more next-level materials in the fifth group based on the remaining amount of the one or more next-level materials in the fifth group.

[0101] In an exemplary embodiment, if it is determined that there is a shortage of one or more substitutable material groups in the first group for the corresponding product component, the exemplary embodiment may further include calculating a shortage amount of the one or more substitutable material groups in the first group for the corresponding product component based on the satisfactory amount of the one or more substitutable material groups in the first group for the corresponding product component and the demand amount of the material in the first group that is in shortage. If it is determined that there is a shortage of one or more next level materials in Group 5, Step H1: calculating a sixth shortage value based on the sufficient quantity of one or more next-level materials in the fifth group for manufacturing the corresponding materials in the first group that have a shortage and the shortage amount of the corresponding material group in the first group that has a shortage, and updating the shortage amount of the corresponding material group in the first group that has a shortage using the sixth shortage value; Step H2 may further include: obtaining the configuration parameters; reallocating the shortage amount of the shortage material in the corresponding material group that has a shortage in the first group based on the configuration parameters; updating the shortage amount of the corresponding material in the first group using the allocated shortage amount; and displaying the shortage amount and shortage status of the corresponding material in the first group through a first output interface.

[0102] In an exemplary embodiment, the method comprises: when determining that there is a shortage of one or more next-level materials in the fifth group, obtain the shortage amount of the one or more next-level materials in the fifth group based on the remaining amount of the one or more next-level materials in the fifth group, and display the shortage amount and shortage status of the one or more next-level materials in the fifth group 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 amount is greater than 0, outputting the remaining amount and overstock status of the one or more next-level materials in the fifth group via the first display interface; The method may further include outputting the remaining amount and material status of one or more next-level materials in the fifth group via 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 that the remaining amount is 0.

[0103] In an exemplary embodiment, the method comprises: If it is determined that one or more next-level materials in the fifth group are in short supply, the method may further include obtaining configuration parameters of the next-level materials, reallocating the shortage quantities of the missing materials in the corresponding next-level material groups in the fifth group that have shortages based on the configuration parameters of the next-level materials, updating the shortage quantities of the corresponding next-level materials in the fifth group with the reallocated shortage quantities, and displaying the updated shortage quantities and shortage status of the corresponding next-level materials in the fifth group via the first output interface.

[0104] In an exemplary embodiment, the method may further include, if it determines that there is a shortage of one or more next-level materials in the fifth group, obtaining configuration parameters of the next-level materials, reallocating the shortage quantities of the corresponding next-level materials in the fifth group that have a shortage based on the configuration parameters of the next-level materials, and updating the shortage quantities of the corresponding next-level materials in the fifth group with the reallocated shortage quantities.

[0105] In an exemplary embodiment, the method includes, when it is determined that no next-level material exists for the material having a shortage, displaying a shortage status of the material having a shortage via a first output interface (or displaying a shortage amount of the material having a shortage, or displaying a shortage status and a shortage amount of the material having a shortage); If it is determined that there is no shortage of one or more materials used to manufacture the one or more product components, the method may further include displaying material information of the one or more materials used to manufacture the one or more product components via the first output interface (the material information may include at least one of a remaining quantity and an overstock status).

[0106] In an exemplary embodiment, the method may further include, if it determines that there is an overstock or shortage of one or more materials having a shortage based on the maximum consumption amounts and available inventory amounts of corresponding materials of the plurality of next-level materials, adjusting demand for the one or more product components to minimize the overstock or shortage of the next-level materials, and manufacturing the one or more product components based on the adjusted demand for the one or more product components.

[0107] In an exemplary embodiment, the method may further include generating one or more user interfaces; The one or more user interfaces include a first output interface, which is further configured to display the material status of the corresponding materials in at least one of the first group to the fifth group.

[0108] In an exemplary embodiment, the one or more user interfaces may further include a first input interface, the first input interface configured to receive one or more user inputs for querying a database, the database storing data for a plurality of materials; The computer-implemented method further includes receiving a user selection of one or more conditions from the first input interface, the user selection being used to select a material condition associated with the one or more conditions; and querying the database in response to the user selection to determine one or more material conditions associated with the one or more conditions in the database; the one or more conditions include at least one of an overstock condition for an overstocked material and a shortage condition for a shortage material; The one or more user interfaces further include a second output interface configured to display the one or more overstocked or understocked materials as a result of querying the database.

[0109] In an exemplary embodiment, the one or more user interfaces may further include a second input interface, the second input interface configured to receive one or more user inputs for adjusting the priority of the corresponding materials in the first group; The computer-implemented method further includes redetermining whether the corresponding materials in the first group are overstocked or understocked based on the adjusted priorities of the corresponding materials in the first group.

[0110] In an exemplary embodiment, the one or more user interfaces may further include a third input interface, the third input interface configured to receive one or more user inputs for adjusting demand for the one or more product components; The computer-implemented method includes calculating an adjusted maximum consumption amount 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 materials in the first group with the available inventory of the corresponding materials in the first group; and redetermining whether there is an overstock or shortage of the corresponding materials in the first group.

[0111] In an exemplary embodiment, the method comprises: receiving a material status inquiry command input by a user via a first input interface; The method may further include, in response to the material status query command, obtaining from the database at least one of remaining quantities, overstock status, shortage status, and shortage quantities for a plurality of materials and a plurality of next-level materials for manufacturing the one or more product components.

[0112] In an exemplary embodiment, the material status query command is to query current material information of the corresponding material, for example, the current material may be at least one material in at least one of the above-mentioned first to fifth groups, and the current material information may be at least one of the remaining or shortage amount, overstock or shortage status of the queried material.

[0113] In an exemplary embodiment, the above material query command can be understood as inquiring about the material status after manufacturing the corresponding demand product component. After receiving the material query command input by the user, the processor may perform data processing based on the materials used to manufacture the product component and the next-level materials to obtain the overstock or shortage status and the overstock or shortage quantity of the corresponding materials. The above material status query command can be understood as inquiring about material information (e.g., including the overstock or shortage status and the overstock or shortage quantity) of the materials used to manufacture one or more product components and the next-level materials. The queried material information may be the overstock or shortage status and the overstock or shortage quantity of the corresponding materials obtained after the processor responds to the above material query command (no need to process the material data again, the processed material data can be simply queried, and query efficiency can be improved), or it may be material-related information before responding to the above material query command (no need to process complex data, the corresponding material information can be simply displayed, and the user's needs for simply understanding related material information can be met).

[0114] An embodiment of the present disclosure further provides a computer-implemented method, obtaining data on a plurality of next-level materials for one or more materials having a shortage for manufacturing one or more product components, the data on the plurality of next-level materials for the one or more materials having a shortage including available inventory amounts of the plurality of next-level materials; calculating maximum consumption amounts of a plurality of next-level materials for at least one of the one or more materials having a shortage; and determining whether there is a shortage for one or more of the materials that have a shortage based on the maximum consumption amount and available inventory of corresponding materials for the plurality of next-level materials.

[0115] A computer-implemented method according to an embodiment of the present disclosure includes: obtaining data on a plurality of next-level materials for one or more materials that are in short supply for producing one or more product components; the data on the plurality of next-level materials for the one or more materials that are in short supply includes available inventory quantities of the plurality of next-level materials; calculating a maximum consumption amount of the plurality of next-level materials for at least one of the one or more materials that are in short supply; determining whether there is a shortage of the one or more materials that are in short supply based on the maximum consumption amount and available inventory quantities of the corresponding materials of the plurality of next-level materials; if there is a shortage of materials during the production of the one or more product components, consuming materials from the next level for the materials that are in short supply to replenish the shortage; and determining whether there is a shortage of the replenished materials after replenishment, thereby maximizing the consumption of next-level materials and avoiding overstock of next-level materials; and replenishing the shortage of materials in a timely manner, which significantly solves the problem of overstock or shortage of materials in the material management process.

[0116] In an exemplary embodiment, a product component may be any product manufactured from multiple materials. Product components may include, for example, semiconductor products, electronic products, chemical products, mechanical assembly products, etc. In an exemplary embodiment, a product component is not limited to a finished product, but may include a finished product or a semi-finished product.

[0117] As shown in FIG. 2, a flowchart of a computer-implemented method according to an exemplary embodiment of the present disclosure may include steps 11 to 13.

[0118] Step 11, obtain data on multiple next-level materials for one or more materials that have a shortage for manufacturing one or more product components, and the data on multiple next-level materials for one or more materials that have a shortage includes available inventory amounts of the multiple next-level materials.

[0119] Step 12, calculating maximum consumption amounts of multiple next-level materials for at least one of the one or more materials having a shortage.

[0120] Step 13: Determine whether there is a shortage in one or more materials according to the maximum consumption amount and available inventory amount of corresponding materials of the plurality of next-level materials.

[0121] In an exemplary embodiment, step 11 may further include steps 01 to 03 before obtaining data on multiple next-level materials for one or more materials that have a shortage for manufacturing one or more product components.

[0122] Step 01, obtain data regarding a plurality of materials for manufacturing one or more product components, the data regarding the plurality of materials including available inventory amounts of the plurality of materials.

[0123] Step 02, calculate the maximum consumption of a plurality of materials for at least one product component of the one or more product components.

[0124] 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 amount of the corresponding materials of the plurality of materials and the available inventory amount of the corresponding materials of the plurality of materials.

[0125] In an exemplary embodiment, the computer-implemented method comprises: If it is determined in step 03 that there is a shortage of a plurality of materials for manufacturing one or more product components, determining whether there is a next-level material for the material having a shortage; If it is determined that there is a next-level material for the material having a shortage, the method may further include obtaining data on multiple next-level materials for the one or more materials having a shortage for manufacturing the one or more product components.

[0126] In an exemplary embodiment, the data for the plurality of materials includes substitution relationship information between the plurality of materials; In step 11, before obtaining data of multiple next-level materials of the one or more materials having a shortage for manufacturing the one or more product components, the method may further include determining one or more materials having a shortage in a second group from the one or more materials having a shortage based on substitution relationship information between the multiple materials, where the one or more materials having a shortage in the second group are materials that are non-substitutable for at least one product component of the one or more product components.

[0127] In an exemplary embodiment, the data for the plurality of next-level materials may further include substitution relationship information between the next-level materials; Before calculating the maximum consumption amount of the plurality of next-level materials for at least one of the one or more materials having a shortage in step 12, the method may further include determining data of one or more next-level materials in the third group and data of one or more next-level materials in the fourth group from data of the one or more materials having a shortage in the second group based on substitution relationship information between the next-level materials, wherein the one or more next-level materials in the third group are materials that can be substituted for at least one of the one or more materials having a shortage in the second group, and the one or more next-level materials in the fourth group are materials that cannot be substituted for at least one of the one or more materials having a shortage in the second group.

[0128] In an exemplary embodiment, in Step 02, calculating a maximum consumption amount of the plurality of materials for at least one product component among the one or more product components may include calculating a maximum consumption amount of the one or more materials in the second group for the one or more product components based on data of the one or more materials in the second group; and in Step 03, determining whether there is a shortage of one or more materials for manufacturing the one or more product components based on the maximum consumption amount of corresponding materials of the plurality of materials and available inventory amounts of corresponding materials of the plurality of materials may include calculating a remaining amount of one or more materials in the second group based on the available inventory amounts of the one or more materials in the second group and the maximum consumption amount of the 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 amount of the one or more materials in the second group.

[0129] In an exemplary embodiment, if it is determined that there is a shortage of one or more materials in the second group, the method may further include calculating a shortage amount of the one or more materials in the second group that is in a shortage based on an available inventory amount of the one or more materials in the second group that is in a shortage and a maximum consumption amount of the one or more materials in the second group that is in a shortage.

[0130] In an exemplary embodiment, in Step 02, calculating a maximum consumption amount of the plurality of materials for at least one product component of the one or more product components may include calculating a maximum consumption amount of one or more materials for which there is a shortage in the second group for at least one product component of the one or more product components. In step 03, determining whether there is a shortage of one or more materials for manufacturing the one or more product components based on the maximum consumption amounts of corresponding materials of the plurality of materials and the available inventory amounts of corresponding materials of the plurality of materials may include calculating a remaining amount of the one or more materials in the second group that are in shortage based on the available inventory amounts of the one or more materials in the second group that are in shortage and the maximum consumption amounts of the one or more materials in the second group that are in shortage, and determining whether there is a shortage of the one or more materials in the second group that are in shortage based on the remaining amount of the one or more materials in the second group that are in shortage. If it is determined that there is a shortage of one or more materials in the second group, the method may further include obtaining a shortage amount of the one or more materials in the second group that is in shortage based on a remaining amount of the one or more materials in the second group that is in shortage.

[0131] In an example embodiment, the next-level material data may further include unit consumption values ​​of a plurality of next-level materials for the production of one or more materials in the second group that have a shortage. In step 12, calculating the maximum consumption amount of the plurality of next-level materials for at least one of the one or more materials having a shortage may include obtaining the maximum consumption amount of the one or more next-level materials in the fourth group for the one or more materials having a shortage in the second group using the sum of values ​​obtained by multiplying the shortage amount of the one or more materials having a shortage in the second group that require the one or more next-level materials in the fourth group as non-substitutable materials by the unit consumption value of the corresponding next-level materials in the fourth group for the production of the one or more corresponding materials having a shortage in the second group. In step 13, determining whether there is a shortage of one or more materials that have a shortage based on the maximum consumption and available inventory of corresponding materials of the multiple next-level materials may include: subtracting the maximum consumption of the one or more next-level materials in the fourth group from the available inventory of the one or more next-level materials in the fourth group to obtain a remaining amount of the one or more next-level materials in the fourth group; and determining that there is a shortage of one or more materials in the fourth group if the remaining amount of the one or more next-level materials in the fourth group is less than 0.

[0132] In an exemplary embodiment, if the remaining quantity of one or more next-level materials in the fourth group is greater than zero, the method may include determining, based on substitution relationship information between the next-level materials, 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.

[0133] In an exemplary embodiment, if it is determined that one or more next-level materials in the fourth group are not substitutable materials for one or more materials in the first group that have a shortage, it is determined that there is an overstock of one or more next-level materials in the fourth group.

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

[0135] In an exemplary embodiment, calculating maximum consumption amounts of a plurality of next-level materials for at least one of the one or more materials having a shortage includes calculating, using a third linear programming model, maximum consumption amounts of one or more next-level materials in a third group for the one or more materials having a shortage in the second group; In step 13, determining whether there is a shortage of one or more materials that have a shortage based on the maximum consumption and available inventory of corresponding materials of the multiple next-level materials may include: subtracting the maximum consumption of one or more next-level materials in the third group from the available inventory of the one or more next-level materials in the third group to obtain a remaining amount of the one or more next-level materials in the third group; and determining that there is a shortage of one or more next-level materials in the third group if the remaining amount of the one or more next-level materials in the third group is less than 0.

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

number

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

number

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

number

[0139] In an exemplary embodiment, the data for the plurality of materials includes substitution relationship information between the plurality of materials and demand quantities of one or more product components. In step 11, before obtaining data on multiple next-level materials for one or more materials that are in short supply for manufacturing one or more product components, the method may further include determining one or more materials in a first group from the multiple materials based on substitution relationship information between the multiple materials, and the one or more materials in the first group being substitutable materials for at least one product component of the one or more product components. In Step 02, calculating a maximum consumption amount of the plurality of materials for at least one product component of the one or more product components may include calculating a maximum consumption amount of the one or more materials in the first group for the one or more product components based on data of the one or more materials in the first group. In step 03, determining whether there is a shortage of one or more materials for manufacturing the one or more product components based on the maximum consumption amount of corresponding materials of the plurality of materials and the available inventory amount of corresponding materials of the plurality of materials may include obtaining a satisfactory amount of one or more substitutable material groups in the first group for the one or more product components when the consumption amount of the one or more materials in the first group for the one or more product components is at the maximum consumption amount, and determining whether there is a shortage of one or more substitutable material groups in the first group for the corresponding product components based on the satisfactory amount of the one or more substitutable material groups in the first group for the corresponding product components and the demand amount of the one or more product components in the first group.

[0140] In an exemplary embodiment, when determining that there is a shortage in a plurality of materials used to manufacture the one or more product components, determining whether a next-level material exists for the material with the shortage may include, when determining that there is a shortage in one or more substitutable material groups in the first group for the corresponding product component, determining whether a next-level material exists for the material group with the shortage in the first group. When it is determined that next-level materials exist for the material having a shortage, obtaining data on multiple next-level materials for the one or more materials having a shortage for manufacturing the one or more product components may include, when it is determined that next-level materials exist for a material group having a shortage in the first group, obtaining material data on one or more next-level materials for the one or more material groups having a shortage in the first group.

[0141] In an exemplary embodiment, in step 12, calculating maximum consumption amounts of the plurality of next-level materials for at least one material of the one or more materials having a shortage may include: determining the plurality of next-level materials of the one or more material groups having a shortage 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, maximum consumption amounts of the one or more next-level materials in the fifth group for product components corresponding to the one or more material groups having a shortage in the first group. In step 13, determining whether there is a shortage of one or more materials that have a shortage based on the maximum consumption and available inventory of corresponding materials of the multiple next-level materials may include calculating a remaining amount 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 a maximum consumption amount of one or more next-level materials in the fifth group for product components corresponding to the one or more corresponding material groups that have a shortage 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 amount of one or more next-level materials in the fifth group.

[0142] In an exemplary embodiment, if it is determined that there is a shortage of one or more substitutable material groups in the first group for the corresponding product component, the method may further include calculating a shortage amount of the one or more substitutable material groups in the first group for the corresponding product component based on the satisfactory amount of the one or more substitutable material groups in the first group for the corresponding product component and the demand amount of the material in the first group that has a shortage. When it is determined that one or more next-level materials in the fifth group are in short supply, the method further comprises: calculating a sixth shortage value based on the sufficient quantity of the one or more next-level materials in the fifth group for producing the corresponding materials in the first group that have a shortage and the shortage amount of the corresponding material group in the first group that has a shortage; and updating the shortage amount of the corresponding material group in the first group that has a shortage using the sixth shortage value; The method may further include obtaining a configuration parameter, reallocating a shortage amount of the shortage material in the corresponding material group having a shortage in the first group based on the configuration parameter, and updating the shortage amount of the corresponding material in the first group using the reallocated shortage amount.

[0143] In an exemplary embodiment, the method may further include, if it is determined that there is a shortage of one or more next-level materials in the fifth group, obtaining configuration parameters of the next-level materials, reallocating the shortage quantities of the corresponding next-level materials in the fifth group that have a shortage based on the configuration parameters of the next-level materials, and updating the shortage quantities of the corresponding next-level materials in the fifth group with the reallocated shortage quantities.

[0144] In an exemplary embodiment, the method may further include, if it determines that there is an overstock or shortage of one or more materials having a shortage based on the maximum consumption amounts and available inventory amounts of corresponding materials of the plurality of next-level materials, adjusting demand for the one or more product components to minimize the overstock or shortage of the next-level materials, and manufacturing the one or more product components based on the adjusted demand for the one or more product components.

[0145] In an exemplary embodiment, the method may further include generating one or more user interfaces; The one or more user interfaces include a first output interface, which is configured to display the material status of the corresponding materials in at least one of the first group to the fifth group.

[0146] In an exemplary embodiment, the one or more user interfaces may further include a first input interface, the first input interface configured to receive one or more user inputs for querying a database, the database storing data for the plurality of materials. The computer-implemented method further includes receiving a user selection of one or more conditions from the first input interface, the user selection being used to select a material condition associated with the one or more conditions, and querying the database in response to the user selection to determine one or more material conditions associated with the one or more conditions in the database. The one or more conditions may include at least one of an overstock condition for an overstocked material and a shortage condition for a shortage material. The one or more user interfaces may further include a second output interface configured to display one or more overstocked or understocked materials as a result of querying the database.

[0147] In an exemplary embodiment, the one or more user interfaces may further include a second input interface, the second input interface configured to receive one or more user inputs for adjusting the priority of the corresponding materials in the first group. The computer-implemented method may further include redetermining whether the corresponding materials in the first group are overstocked or understocked based on the adjusted priorities of the corresponding materials in the first group.

[0148] In an exemplary embodiment, the one or more user interfaces may further include a third input interface, the third input interface configured to receive one or more user inputs for adjusting demand for the one or more product components. The computer-implemented method may further include calculating an adjusted maximum consumption amount of the corresponding materials in the first group based on the adjusted demand for the one or more product components, comparing the adjusted maximum consumption amount of the corresponding materials in the first group with an available inventory amount of the corresponding materials in the first group, and redetermining whether there is an overstock or shortage of the corresponding materials in the first group.

[0149] In an exemplary embodiment, the computer-implemented method may further include, when determining, based on the maximum consumption amounts and available inventory amounts of corresponding materials of the plurality of next-level materials, that there is an overstock or shortage of one or more materials having a shortage, adjusting demand for the one or more product components to minimize the overstock or shortage of the next-level materials, and manufacturing the one or more product components based on the adjusted demand for the one or more product components. Adjusting the demand for the one or more product components may reduce shortages or overstocks of materials for manufacturing the product components and next-level materials for the materials for manufacturing the product components.

[0150] In an exemplary embodiment, if the maximum consumption amount of the corresponding materials of the plurality of next-level materials is greater than the available inventory amount, it is determined that there is still a shortage of one or more materials that have a shortage after replenishing the shortage with next-level materials; if the maximum consumption amount of the corresponding materials of the plurality of next-level materials is equal to the available inventory amount, it is determined that the one or more materials that have a shortage after replenishing the shortage with next-level materials will just meet the demand for the product component; and if the maximum consumption amount of the corresponding materials of the plurality of next-level materials is less than the available inventory amount, it is determined that there is an overstock of one or more materials that have a shortage after replenishing the shortage with next-level materials.

[0151] The following is an exemplary description of a computer-implemented method provided by an embodiment of the present disclosure, which can be applied to material management in a product manufacturing process. In an exemplary embodiment, as shown in Figures 3a and 3b, the computer-implemented method provided by an embodiment of the present disclosure may include steps 101 to 125.

[0152] Step 101: Obtain data on a plurality of materials for manufacturing one or more product components.

[0153] In an exemplary embodiment, before manufacturing (or producing) one or more product components, data on all materials for manufacturing one or more product components may be entered into a storage device. For example, all material data may be scanned into the storage device via a scanning device connected to the memory, a user may manually enter all material data into the storage device, or a user may manually enter some material data into the storage device and then scan some material data into the storage device via a scanning device. In an embodiment of the present disclosure, the material data entered into the storage device may be displayed via a graphical user interface.

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

[0155] In an exemplary embodiment, the material data for manufacturing one or more product components may include at least two of the following: a component product number, a demand quantity for the product component, a material number for a material required to manufacture the product component, a unit consumption of the material for the product component, a substitution group for the material, a material priority, and an inventory quantity of the material. The data for multiple materials for manufacturing one or more product components is shown in Table 1 below.

[0156] [Table 1]

[0157] In an exemplary embodiment, as shown in Table 1, the data on the materials required 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 data on the materials may further include unit consumptions of materials for one or more product components, where the same material may have different unit consumptions for different product components; for example, product components with product numbers PRO-1 and PRO-2 may both use material A as an ingredient in their manufacture (an ingredient in their manufacture can be understood as a material used to manufacture a product component), and the unit consumption of material A for product component with product number PRO-1 is 1, while the unit consumption of material A for product component with product number PRO-2 is 2. In an exemplary embodiment, the unit consumption may be the ratio of the amount of material (calculated by weight, moles, or number) that needs to be consumed to manufacture a certain amount of the product component to the amount of the product component.

[0158] 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 a substitution group indicator and a priority. The unit consumption of product components versus materials in Table 1 can be understood as the unit consumption of materials for product components.

[0159] In an exemplary embodiment, the same substitution group includes materials that are interchangeable when manufacturing the same product component, and materials within the same substitution group have the same substitution group designation (e.g., material A and material B for manufacturing product component number PRO-1 have the same substitution group designation D1). For example, when manufacturing (i.e., producing) product component number PRO-1, material A and material B are interchangeable, and material A and material B are in the same substitution group D1. When manufacturing product component number PRO-1, material C and material D are interchangeable, and material C and material D are in the same substitution group D2. Product component number PRO-1 can be manufactured with four different material combinations, and the material combinations include (A, D, E), (A, C, E), (B, D, E), and (B, C, E).

[0160] In an exemplary embodiment, the same substitution group may include multiple materials with different priorities. For example, the same substitution group may include a first material and a second material, where the first material may have a higher priority than the second material, and when manufacturing the corresponding product, the first material is used in preference to the second material in the same substitution group, which has a lower priority. For example, when manufacturing a product component with 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 will be used as the second material, with material A being used in preference to material B. In Table 1, within the same substitution group, a lower priority number indicates a higher priority.

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

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

[0163] 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 among the plurality of materials may include obtaining substitution group indicators for the plurality of materials from the material substitution relationship information among the plurality of materials, and determining one or more materials in the first group and one or more materials in the second group from the plurality of materials based on the substitution group indicators of the plurality of materials. In an exemplary embodiment, the one or more materials in the first group are substitutable for at least one product component in the one or more product components, and the one or more materials in the second group are non-substitutable for at least one product component in the one or more product components.

[0164] In an exemplary embodiment, materials that are distinguishable as materials in the first group for a particular product are represented by a non-NULL value in the "Alternate Group" column, i.e., the Alternate Group Indicator for the material in the first group is not NULL. In an exemplary embodiment, as shown in Table 1, non-NULL values ​​for the Alternate Group Indicator are represented as Dn, where n represents the Alternate Group number, and non-NULL values ​​for the Alternate Group Indicator may include Alternate Group No. 1 ("D1"), Alternate Group No. 2 ("D2"), and Alternate Group No. 3 ("D3"). For product PRO-1, Alternate Group No. 1 ("D1") includes Material A and Material B. For product PRO-1, Alternate Group No. 2 ("D2") includes Material C and Material D. For product PRO-4, Alternate Group No. 3 ("D3") includes Material C and Material H. As shown in Table 4, materials A, B, C, D, and H may be determined as materials in the first group, and each of materials A, B, C, D, and H may be substitutable for at least one of one or more products. For example, for product PRO-1, material A can be substituted with material B, for product PRO-2, material C can be substituted with material D, and for product PRO-4, material C can be substituted with material H.

[0165] In an exemplary embodiment, materials that can be identified as materials in the second group for a particular product are represented by "NULL" in the "Substitution Group" column, i.e., the substitution group indicator for the material in the second group is NULL. As shown in Table 4, materials A, E, F, and G may be identified as materials in the second group, and each of materials A, E, F, and G is non-substitutable for at least one of the products in one or more products. For example, material A is non-substitutable for product PRO-2, material E is non-substitutable for product PRO-1, material F is non-substitutable for product PRO-2, and material G is non-substitutable for product PRO-3.

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

[0167] In an exemplary embodiment, referring to Table 4, each material in the second group may be assigned a value of “NULL” for the alternative group (i.e., the alternative group indicator of the material in the second group is set to NULL) and may be assigned a “0” for the priority.

[0168] Step 103: extracting data of materials in a second group from data of the materials used to manufacture one or more product components based on substitution relationship information between the materials;

[0169] In an exemplary embodiment, data on materials in the second group (i.e., data on essential materials or data on non-substitutable materials) is extracted from data on multiple materials used to manufacture one or more product components in Table 1, as shown in Table 2.

[0170] [Table 2]

[0171] In an exemplary embodiment, extracting data of materials in a second group from data of a plurality of materials that manufacture one or more product components based on substitution relationship information between the plurality of materials includes extracting data of materials whose field values ​​in the substitution group are NULL.

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

[0173] In an exemplary embodiment, step 104 may include obtaining a maximum consumption amount of the one or more materials in the second group for the one or more product components by summing values ​​obtained by multiplying the demand amount for the one or more product components that require the one or more materials in the second group as non-substitutable materials by the corresponding unit consumption values ​​of the corresponding materials in the second group for the production of the one or more product components.

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

[0175] In an exemplary embodiment, the maximum consumption of one material in the second group is obtained by calculating the sum of the consumption of the material for all product components in the second group. As shown in Table 2, the consumption of material E for product PRO-1 is equal to the demand for product PRO-1 (20,000) multiplied by the unit consumption of material E for product PRO-1 (4), so the consumption of material E for product PRO-1 is equal to 20,000*4. Products PRO-2 and PRO-3 in the second group do not consume material E, that is, the consumption of material E for products PRO-2 and PRO-3 in the second group is 0. Therefore, the maximum consumption of material E is the sum of the consumption of material E for 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.

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

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

[0178] In an exemplary embodiment, if the remaining amount of one or more materials in the second group is greater than 0, it indicates that there is a remaining amount after the material meets the production demand of the product. If the remaining amount of one or more materials in the second group is equal to 0, it indicates that the material can exactly meet the production demand of the product. If the remaining amount of one or more materials in the second group is less than 0, it indicates that the material cannot meet the production demand of the product, i.e., there is a shortage of materials.

[0179] 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. By subtracting the maximum consumption of material E (20,000*4) from the inventory of material E (2,500), we obtain the remaining amount of material E in the second group: 2,500-20,000*4=-77,500. By analogy, the remaining amount of material A is 5,000-3,000*2=-1,000, the remaining amount of material F is 2,000-3,000*2=-4,000, and the remaining amount of material G is 2,000-1,000*3=-1,000. In Table 2, the remaining amounts of materials A, E, F, and G in the second group are less than 0, which indicates that there is a shortage of materials A, E, F, and G, and the shortage amounts are 1000, 77500, 4000, and 1000, respectively.

[0180] Step 106: Based on the remaining quantity of one or more materials in the second group, determine whether there is a shortage of one or more materials in the second group; if there is a shortage, execute step 107; if there is no shortage, use the remaining quantity of one or more materials in the second group to update the inventory quantity of the corresponding materials in the second group.

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

[0182] In an exemplary embodiment, determining whether there is a shortage of one or more materials in the second group based on the remaining amount of the one or more materials in the second group may include obtaining a satisfactory amount of the one or more materials in the second group for the one or more product components when the consumption amount of the one or more materials in the second group for the one or more product components is at a maximum consumption amount, and determining whether there is a shortage of the one or more materials in the second group for the corresponding product components based on the satisfactory amount of the one or more materials in the second group for the one or more product components and the demand amount of the one or more product components.

[0183] Step 107: Determine whether there are any semi-finished products in the second group of materials that are in short supply. If there are semi-finished products, execute step 108. If there are no semi-finished products, use the remaining amount of the materials that are in short supply in the second group to update the inventory amount of the corresponding materials that are in short supply in the second group.

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

[0185] In an exemplary embodiment, as can be seen from Table 2, if there are shortages for materials A, E, F, and G, and no semi-finished products exist for materials A and E, but semi-finished products exist for materials F and G, the shortages for materials A and E are used to calculate the shortages of 1000 and 77500, respectively, and the inventory quantity of material A is updated by subtracting 1000 from the remaining quantity of material A (after the update, the inventory quantity of material A becomes -1000), and the inventory quantity of material E is updated by subtracting 77500 from the remaining quantity of material E (after the update, the inventory quantity of material E becomes -77500).

[0186] Step 108: Obtain material data of the semi-finished product components of the one or more materials in the second group that have shortages.

[0187] In an exemplary embodiment, the material data of the semi-finished components of the second group of materials having shortages may include the material number of the material having shortages, the material number of the semi-finished component, the required material versus semi-finished component consumption (i.e., the semi-finished component consumption versus the required material consumption), the substitution group of the semi-finished component, the inventory amount of the semi-finished component, and the shortage amount of the material (which can be understood as the demand amount that the semi-finished component needs to fulfill). The material data of the semi-finished components of the second group of materials having shortages may be shown as shown in Table 3.

[0188] [Table 3]

[0189] As shown in Table 3, semi-finished component PCB-1 and semi-finished component PCB-2 are in the same substitution group D4, and semi-finished component PCB-1 and semi-finished component PCB-2 are substitutable for each other when producing material F, semi-finished component PCB-2 and semi-finished component PCB-5 are in the same substitution group D5, and semi-finished component PCB-2 and semi-finished component PCB-5 are substitutable for each other when producing material G, and semi-finished component PCB-10 has a NULL substitution group and a priority of 0, so semi-finished component PCB-10 is a required material for material F, and semi-finished component PCB-2 can be used to produce materials F and G, so semi-finished component PCB-2 belongs to the shared materials used to produce materials F and G.

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

[0191] In an exemplary embodiment, 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 of the material having a shortage in the second group based on the substitution relationship information of the semi-finished components may include obtaining substitution group indicators for the plurality of semi-finished components of the material having a shortage 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 indicators of the plurality of semi-finished components. In an exemplary embodiment, the one or more semi-finished components in the third group are materials that are substitutable for at least one of the one or more materials having a shortage in the second group, and the one or more semi-finished components in the fourth group are materials that are not substitutable for at least one of the one or more materials having a shortage in the second group. As shown in Table 3, the substitution group of semi-finished component PCB-10 is NULL and its priority is 0. In the production process of material F, semi-finished component PCB-10 is determined to be a non-substitutable material and a semi-finished component in the third group of materials in the second group that are in short supply. The substitution group of semi-finished components PCB-1 and PCB-2 is D4, and the substitution group of semi-finished components PCB-2 and PCB-5 is D5. Therefore, semi-finished components PCB-1, PCB-2, and PCB-5 are determined to be substitutable materials and to be semi-finished components in the fourth group of materials in the second group that are in short supply. For example, semi-finished components PCB-1 and PCB-2 are substitutable materials for producing material F, and semi-finished components PCB-2 and PCB-5 are substitutable materials for producing material G.

[0192] Step 110: based on substitution relationship information between multiple semi-finished components of the material in the second group that has a shortage, material data of one or more semi-finished components in the fourth group is obtained from material data of the semi-finished components of the one or more materials in the second group that has a shortage, and based on the material data of the one or more semi-finished components in the fourth group, calculates maximum consumption amounts of the one or more semi-finished components in the fourth group for the one or more materials in the second group that has a shortage.

[0193] In an exemplary embodiment, calculating the maximum consumption amount of the one or more semi-finished components in the fourth group for the one or more materials in the second group that are in short supply based on the material data of the one or more semi-finished components in the fourth group may include obtaining the maximum consumption amount of the one or more semi-finished components in the fourth group for the one or more materials in short supply in the second group by using a sum of values ​​obtained by multiplying the shortage amount of the one or more materials in the second group that require the one or more semi-finished components in the fourth group as non-substitutable materials by the unit consumption value of the corresponding semi-finished components in the fourth group for the production of the one or more corresponding materials in short supply in the second group.

[0194] As shown in Table 3, the material data of semi-finished component PCB-10 in the materials with shortages in the second group obtained from the material data of multiple semi-finished components of the materials with shortages in the second group includes the shortage amount of material F in the second group that requires semi-finished component PCB-10 as a non-substitutable material, the unit consumption of semi-finished component PCB-10 for material F in the second group with shortages, and the inventory amount of semi-finished component PCB-10. Data of the materials with shortages in the second group is obtained. The shortage amount of material F, 4000, in the second group, which requires semi-finished component PCB-10 as a non-substitutable material, is multiplied by the unit consumption of semi-finished component PCB-10 for material F, 1, in the second group to obtain the consumption amount of semi-finished component PCB-10, 4000, for material F, 4000, in the second group. In Table 3, material F has no shared relationship with other materials, so the maximum consumption amount of semi-finished component PCB-10 for materials, 4000, in the second group is 4000.

[0195] Step 111: subtract the maximum consumption amount of one or more semi-finished components in the fourth group for one or more materials in the second group that are in short supply from the inventory amount of one or more semi-finished components in the fourth group to obtain the remaining amount of one or more semi-finished components in the fourth group, and update the inventory amount of one or more semi-finished components in the fourth group using the remaining amount of one or more semi-finished components in the fourth group.

[0196] In an exemplary embodiment, as shown in Table 3, the remaining quantity of semi-finished component PCB-10 in the fourth group (-3000) is obtained by subtracting the maximum consumption quantity of semi-finished component PCB-10 in the fourth group (4000) for material F in the second group that is in short supply from the inventory quantity of semi-finished component PCB-10 in the fourth group (1000). In the embodiment of the present disclosure, if the remaining quantity of a semi-finished component in the fourth group is greater than 0, it indicates that the semi-finished component has a remaining quantity after making up for the shortage of the material in the second group. If the remaining quantity of a semi-finished component in the fourth group is equal to 0, it indicates that the semi-finished component can exactly make up for the shortage of the material in the second group. If the remaining quantity of a semi-finished component in the fourth group is less than 0, it indicates that the semi-finished component cannot exactly make up for the shortage of the material in the second group. Since the remaining quantity of semi-finished component PCB-10 in the fourth group (-3000) is less than 0, it indicates that there is a shortage of semi-finished component PCB-10, and the shortage quantity is 3000.

[0197] In an exemplary embodiment, one or more shortages of materials in the second group may be converted into the inventory of the corresponding semi-finished components in the fourth group, where if the inventory of the corresponding semi-finished components in the fourth group is greater than or equal to zero, it indicates that there is no shortage of the semi-finished components and that the shortages of the corresponding materials in the second group can be made up; and if the inventory of the corresponding semi-finished components in the fourth group is less than zero, it indicates that there is a shortage of the semi-finished components and that the shortages of the corresponding materials in the second group cannot be made up.

[0198] In an exemplary embodiment, if multiple materials in the second group that have shortages share one semi-finished component in the fourth group, the remaining amount of the semi-finished component may be obtained by subtracting the sum of the maximum consumption amounts of the materials that share the semi-finished component for the semi-finished component from the inventory amount of the semi-finished component.

[0199] In an exemplary embodiment, step 111 may further include determining that one or more materials in the fourth group are in short supply if the remaining amount of one or more next-level materials in the fourth group is less than zero. In an exemplary embodiment, if it is determined that one or more materials in the fourth group are in short supply, displaying the shortage status and shortage amount of the one or more materials in the fourth group via the first output interface. In an exemplary embodiment, the shortage amount may be a negative number of the remaining amount, in which case a positive number indicates a shortage, or the shortage amount may be equal to the remaining amount, in which case a negative number indicates a shortage.

[0200] In an exemplary embodiment, step 111 may further include, if the remaining quantity of one or more next-level materials in the fourth group is greater than zero, 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 have a shortage based on substitution relationship information between the next-level materials, and determining that there is overstock of one or more next-level materials in the fourth group if 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 have a shortage. In an exemplary embodiment, if it is determined that there is overstock of one or more next-level materials in the fourth group, it may further include displaying the overstock status and remaining quantity of the one or more next-level materials in the fourth group via a first output interface.

[0201] Step 112: based on substitution relationship information between multiple semi-finished components of one or more materials in the third group that have shortages, obtain material data of one or more semi-finished components in the third group from material data of the semi-finished components of the materials in the second group that have shortages, and calculate maximum consumption amounts of one or more semi-finished components in the third group for one or more materials in the second group that have shortages based on the material data of the one or more semi-finished components in the third group.

[0202] In an exemplary embodiment, calculating a maximum consumption amount of one or more semi-finished components in the third group for one or more materials in the second group that have shortages based on data on materials for the one or more semi-finished components in the third group may include calculating a maximum consumption amount of one or more semi-finished components in the third group for one or more materials in the second group that have shortages using the third linear programming model.

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

number

[0204] In an exemplary embodiment, the third objective function is used to calculate the sum of the maximum consumption amounts of one or more semi-finished components in the third group. As shown in Table 3, the satisfactory quantities of one or more semi-finished components in the third group for producing the corresponding materials in the second group that are in short supply are set as follows: the satisfactory quantity of semi-finished component PCB-1 for producing material F is set as x1; the satisfactory quantity of semi-finished component PCB-2 for producing material F is set as x2; the satisfactory quantity of semi-finished component PCB-2 for producing material G is set as x3; and the satisfactory quantity of semi-finished component PCB-5 for producing material G is set as x4. The unit consumption value of semi-finished component PCB-1 for material F is 2, and the satisfactory quantity of semi-finished component PCB-5 for material F is set as x5. The unit consumption value of finished component PCB-2 is 2, the unit consumption value of semi-finished component PCB-2 for material G is 1, and the unit consumption value of semi-finished component PCB-5 for material G is 1. The maximum consumption of one or more semi-finished components in the third group calculated using a linear programming model is as follows: the maximum consumption of semi-finished component PCB-1 for material F is 2*x1, the maximum consumption of semi-finished component PCB-2 for material F is 2*x2, the maximum consumption of semi-finished component PCB-2 for material G is 1*x3, and the maximum consumption of semi-finished component PCB-5 for 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.

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

number

[0206] 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 material in the second group that is in short supply (i.e., the demand quantity of the corresponding material in the second group that is in short supply). As shown in Table 3, there is a shortage of material F and material 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 producing material F is 1 (the semi-finished components of the group include semi-finished component PCB-1 and semi-finished component PCB-2), and the total number J of groups of two semi-finished components that can be substituted for each other when producing material G is 1 (the semi-finished components of the group include semi-finished component PCB-2 and semi-finished component PCB-5). The constraints on the shortage quantities of the corresponding materials in the second group that are in short supply are as follows: The constraint for material F with shortage in the second group is x1+x2≦4000. The constraint for material G with shortage in the second group is x3+x4≦1000.

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

number

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

[0209] In the 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 for one or more shortage materials in the second group, and the values ​​of x1, x2, x3, and x4 are obtained to maximize the sum (Max3) of the maximum consumption of one or more semi-finished components in the third group under the premise of satisfying the first constraint function and the second constraint function, so that the inventory of the semi-finished components can be reduced as much as possible and the shortage of the shortage materials in the second group can be made up as much as possible, thereby reducing the overstock of semi-finished components and the shortage of materials in the second group.

[0210] Step 113: calculate the remaining amount of the one or more semi-finished components in the third group based on the inventory amount of the one or more semi-finished components in the third group and the maximum consumption amount of the one or more semi-finished components in the third group for the one or more corresponding materials in the second group that are in short supply, and update the inventory amount of the one or more semi-finished components in the third group using the remaining amount of the one or more semi-finished components in the third group.

[0211] In an exemplary embodiment, in step 113, calculating the remaining quantities of the one or more semi-finished components in the third group based on the inventory quantities of the one or more semi-finished components in the third group and the maximum consumption quantities of the one or more semi-finished components in the third group for the corresponding materials having one or more shortages in the second group may include subtracting the maximum consumption quantities of the one or more semi-finished components in the third group for the corresponding materials having one or more shortages in the second group from the inventory quantities of the one or more semi-finished components in the third group to obtain the remaining quantities of the one or more semi-finished components in the third group.

[0212] In an exemplary embodiment, step 113 may further include determining whether the remaining amount of one or more semi-finished components in the third group is greater than or equal to 0, and if the remaining amount is greater than or equal to 0, determining that the one or more semi-finished components in the third group can make up for the shortage of one or more missing materials in the second group, and if the remaining amount is not greater than or equal to 0, determining that the one or more semi-finished components in the third group cannot make up for the shortage of one or more missing materials in the second group. Let's take the consumption of semi-finished component PCB-1 and semi-finished component PCB-2 to make up for a shortage of material F in Table 3 as an example. If the priority of semi-finished component PCB-1 is 1 and the priority of semi-finished component PCB-2 is 2, semi-finished component PCB-1 is used first to make up for the shortage of material F, and the remaining amount of semi-finished component PCB-1, 1000 - 2x1, is obtained by subtracting the maximum consumption amount of semi-finished component PCB-1 for the material that is in short supply in material F, 2x1, from the inventory amount of semi-finished component PCB-1, 1000. If 1000 - 2x1 is greater than or equal to 0, this indicates that semi-finished component PCB-1 can make up for the shortage of material F, and that the shortage of material F can be made up for without consuming semi-finished component PCB-2. If 1000-2x1 is less than 0, it indicates that semi-finished component PCB-1 cannot make up for the shortage of material F, and in this case semi-finished component PCB-2 is used to make up for the shortage of material F. The satisfactory quantity (x2) of semi-finished component PCB-2 for producing material F is equal to the value obtained by subtracting the satisfactory quantity (x1) of semi-finished component PCB-1 for producing material F from the shortage of material F (4000). The remaining quantity of semi-finished component PCB-2, 1000-2x2=1000-2(4000-x1), is obtained by subtracting the maximum consumption quantity 2x2 of semi-finished component PCB-2 for the material that is in short supply in material F from the inventory quantity of semi-finished component PCB-2, 1000. If the remaining quantity 1000-2x2 of semi-finished component PCB-2 is greater than or equal to 0, it indicates that semi-finished component PCB-2 and semi-finished component PCB-1 can make up for the shortage of material F and there is no shortage of semi-finished components in the third group for producing material F. If the remaining quantity 1000-2x2 of semi-finished component PCB-2 is less than 0, it indicates that semi-finished component PCB-2 and semi-finished component PCB-1 cannot make up for the shortage of material F and there is a shortage of semi-finished components in the third group for producing material F.

[0213] In an exemplary embodiment, the remaining quantity of one or more semi-finished components in the third group may be used to update the inventory quantity of one or more semi-finished components in the third group, and the updated inventory quantity may be used to determine whether there is a shortage of the corresponding semi-finished components in the third group when manufacturing the corresponding materials in the second group that are in shortage. If the updated inventory quantity is greater than or equal to zero, it indicates that there is no shortage of the corresponding semi-finished components in the third group. If the updated inventory quantity is less than zero, it indicates that there is a shortage of the corresponding semi-finished components in the third group. If there is a shortage and the inventory quantity is a negative number, the absolute value of the inventory quantity is the shortage amount.

[0214] In the illustrative embodiment, an example will be described in which semi-finished component PCB-1 is consumed when manufacturing material F. After using semi-finished component PCB-1 to make up for the shortage of material F, the remaining amount of semi-finished component PCB-1 is 1000-2x1, and the inventory amount of semi-finished component PCB-1 can be updated from 1000 to 1000-2x1 to avoid the inventory amount of the semi-finished component (PCB-1) being higher than the actual inventory amount, thereby enabling efficient management of materials of semi-finished components.

[0215] Step 114: calculate a third shortage value based on the satisfactory quantity of one or more semi-finished components in the third group for producing the corresponding materials that are in short supply in the second group and the shortage quantity of the corresponding materials that are in short supply in the second group; calculate a fourth shortage value based on the satisfactory quantity of one or more semi-finished components in the fourth group for producing the corresponding materials that are in short supply in the second group and the shortage quantity of the corresponding materials that are in short supply in the second group; determine a second shortage value of the corresponding materials in the second group based on the third shortage value and the fourth shortage value; and update the shortage quantity of the corresponding materials that are in short supply in the second group using the second shortage value.

[0216] In an exemplary embodiment, calculating the third shortage value based on the satisfactory quantity of one or more semi-finished components in the third group for producing the corresponding materials that are in short supply in the second group and the shortage quantity of the corresponding materials that are in short supply in the second group, and calculating the fourth shortage value based on the satisfactory quantity of one or more semi-finished components in the fourth group for producing the corresponding materials that are in short supply in the second group and the shortage quantity of the corresponding materials that are in short supply in the second group may include subtracting the satisfactory quantity of the one or more semi-finished components in the third group for producing the corresponding materials that are in short supply in the second group from the shortage quantity of the corresponding materials that are in short supply in the second group to obtain the third shortage value of the corresponding materials in the second group, and subtracting the satisfactory quantity of the one or more semi-finished components in the fourth group for producing the corresponding materials that are in short supply in the second group from the shortage quantity of the corresponding materials that are in short supply in the second group to obtain the fourth shortage value of the corresponding materials in the second group. The satisfactory quantity of one or more semi-finished components in the third group for producing the corresponding materials having shortages in the second group is equal to the integer data after rounding down to the ratio of the inventory quantity of one or more semi-finished components in the third group to the unit consumption value of one or more semi-finished components in the third and fourth groups for the corresponding materials having shortages in the second group. The satisfactory quantity of one or more semi-finished components in the fourth group for producing the corresponding materials having shortages in the second group is equal to the integer data after rounding down to the ratio of the inventory quantity of one or more semi-finished components in the fourth group to the unit consumption value of one or more semi-finished components in the fourth group for the corresponding materials having shortages in the second group.

[0217] In an exemplary embodiment, determining the second shortage value of the corresponding material in the second group based on the third shortage value and the fourth shortage value may include: when the third shortage value and the fourth shortage value of the material with the same shortage in the second group are the same, the third shortage value and the fourth shortage value are the same; when the third shortage value and the fourth shortage value of the material with the same shortage in the second group are different, the larger of the third shortage value and the fourth shortage value is the second shortage value. As shown in Table 3, an example will be described in which material F is supplemented using semi-finished component PCB-10 in the fourth group, semi-finished component PCB-1 in the third group, and semi-finished component PCB-2 in the third group. The satisfactory quantity of semi-finished component PCB-10 for producing material F is equal to the integer data after rounding down to the ratio of the inventory of semi-finished component PCB-10, 1000, to the unit consumption value of semi-finished component PCB-10 for material F, 1 (the integer data after rounding down to the value after dividing 1000 by 1 is 1000), i.e., the satisfactory quantity of semi-finished component PCB-10 for producing material F is 1000. By subtracting the satisfactory quantity of semi-finished component PCB-10, 1000, for producing material F from the shortage quantity of material F, 4000, the fourth shortage value of material F, 3000, is obtained. The satisfactory amount of semi-finished component PCB-1 and semi-finished component PCB-2 for producing material F is x1 + x2, and the satisfactory amount of semi-finished component PCB-1 and semi-finished component PCB-2 for producing material F, x1 + x2, is subtracted from the shortage amount of material F, 1000, to obtain the third shortage value of material F, 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 determined to be 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 determined to be the second shortage value of material F. If the third shortage value 1000-(x1+x2) is smaller than the fourth shortage value 3000, the fourth shortage value 3000 is set as the second shortage value of material F.

[0218] In an exemplary embodiment, when the fourth shortage value is equal to or less than zero, it indicates that one or more semi-finished components in the fourth group can satisfy the corresponding shortage of materials in the second group and one or more semi-finished components in the fourth group are not short. When the fourth shortage value is greater than zero, it indicates that one or more semi-finished components in the fourth group cannot satisfy the corresponding shortage of materials in the second group and one or more semi-finished components in the fourth group are short. In an exemplary embodiment, when semi-finished components in the third group are used to supplement the shortage of materials in the second group as limited by the first constraint function, the satisfyable quantity of one or more semi-finished components in the third group to produce the shortage of materials in the second group does not exceed the shortage of materials in the second group. For example, when semi-finished components PCB-1 and PCB-2 are used to supplement material F, the satisfyable quantity x1 + x2 of semi-finished components PCB-1 and PCB-2 to produce material F does not exceed the shortage amount 1000 of material F, so the third shortage value is typically not less than zero. A third shortage value greater than 0 indicates that one or more semi-finished product components in the third group are in shortage. A third shortage value equal to 0 indicates that one or more semi-finished product components in the third group are not in shortage.

[0219] In an exemplary embodiment, the larger of the third shortage value and the fourth shortage value is set as the second shortage value for the one or more materials in the second group that have shortages, thereby avoiding a situation where the larger shortage value still cannot meet the actual shortage when the smaller shortage value is set. In step 115, calculate shortages of one or more semi-finished components in the third group based on the inventory amounts of the one or more semi-finished components in the third group and the maximum consumption amounts of the one or more corresponding semi-finished components in the third group, and calculate shortages of one or more semi-finished components in the fourth group based on the inventory amounts of the one or more semi-finished components in the fourth group and the maximum consumption amounts of the one or more corresponding semi-finished components in the fourth group.

[0220] In an exemplary embodiment, shortage quantities of one or more materials with shortages in the second group may be converted into shortage quantities of one or more semi-finished components in the third and fourth groups and the fourth group.

[0221] In an exemplary embodiment, one or more semi-finished components in the fourth group are essential materials for producing one or more corresponding materials in the second group that are in short supply, and there are no substitutes available, so the shortage amount of one or more semi-finished components in the fourth group may be obtained by subtracting the maximum consumption amount of the one or more corresponding semi-finished components in the fourth group from the inventory amount of the one or more semi-finished components in the fourth group.

[0222] In an exemplary embodiment, one or more semi-finished components in the third group are substitutable materials for producing one or more corresponding materials in the second group that are in short supply, and therefore, shortage quantities of the same substitution group can be set based on configuration parameters. In an exemplary embodiment, the configuration parameters may include setting shortage quantities of semi-finished components using one or more of the following parameters: priority, availability, low cost of the semi-finished components, and proportional allocation, thereby facilitating adjustment of business policies. For example, in the same substitution group, semi-finished components with higher priority (lower numerical priority values) can be used preferentially, semi-finished components with greater availability can be selected preferentially, semi-finished components with lower manufacturing costs can be used preferentially, or shortage quantities can be allocated proportionally to multiple semi-finished components in the same substitution group.

[0223] Step 116: extracting data of materials in the first group from data of the plurality of materials that manufacture one or more product components based on substitution relationship information between the plurality of materials.

[0224] In an exemplary embodiment, data on materials in the first group (i.e., data on interchangeable materials) is extracted from data on multiple materials that manufacture one or more product components in Table 1, as shown in Table 4.

[0225] [Table 4]

[0226] In an exemplary embodiment, extracting data of materials in a first group from data of a plurality of materials that manufacture one or more product components based on substitution relationship information between the plurality of materials may include extracting data of product components whose field values ​​in the substitution group are not NULL.

[0227] Step 117: based on the data of one or more materials in the first group, calculate the maximum consumption of one or more materials in the first group for one or more product components; if the consumption of one or more materials in the first group is the maximum consumption, obtain the satisfactory amount of one or more substitutable material groups in the first group for the corresponding product components.

[0228] In an exemplary embodiment, step 117 may include using a first linear programming model to calculate, based on data of the one or more materials in the first group, maximum consumption amounts of the one or more materials in the first group for the one or more product components in the first group and satisfactory quantities of the one or more materials in the first group for the corresponding product components, and calculating satisfactory quantities of one or more substitutable material groups in the first group for the corresponding product components based on the satisfactory quantities of the one or more materials in the first group for the corresponding product components.

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

number

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

[0231] In an exemplary embodiment, the first objective function is constrained by a first constraint function, where the first constraint function for the first objective function is expressed as:

number

[0232] In an exemplary embodiment, the first constraint function of the first objective function can be understood as a constraint on the demand for the corresponding product components. As shown in Table 4, the product components to be produced include product component PRO-1 and product component PRO-4 (i.e., the value of l is 2), the demand Q1 for product component PRO-1 is 20,000, the demand Q2 for product component PRO-4 is 1,300, the total number J of groups of materials that can be substituted for each other when producing product component PRO-1 is 2 (one group of material groups includes material A and material B, and the other group of material groups includes material C and material D), and the total number J of groups of materials that can be substituted for each other when producing product component PRO-4 is 1 (the materials in this group include material C and material H), and the constraints on the demand for the corresponding materials in the first group are as follows: The constraints on the demand quantity of product component PRO-1 are y1+y2≦20000 and y3+y4≦20000. The constraint for product component PRO-4 is y5+y6≦1300.

[0233] In an exemplary embodiment, the first objective function is further constrained by a second constraint function, which can be expressed as:

number

[0234] In an exemplary embodiment, the second constraint function of the first objective function can be understood as a constraint on the inventory quantity of the corresponding materials in the first group. As shown in Table 4, the total number M of material types in the first group is 5 (including materials A, B, C, D, and H), the available inventory quantity of material A is 5,000, the available inventory quantity of material B is 2,000, the available inventory quantity of material C is 3,000, the available inventory quantity of material D is 1,000, and the available inventory quantity of material H is 1,000. The constraints on the inventory quantities of the corresponding materials in the first group are as follows: The constraint on the inventory quantity of material A is 0≦y1≦5000. The constraint on the inventory quantity of material B is 0≦y2≦2000. The constraint on the inventory quantity of material C is 0≦2y3+2y5≦1300. The constraint on the inventory quantity of material D is 0≦2y4≦1000. The constraint on the inventory quantity of material H is 0≦2y6≦1000.

[0235] In the exemplary embodiment, a linear programming model is used above to calculate the maximum consumption of one or more materials in the first group for one or more product components, and the values ​​of y1, y2, y3, y4, y5, and y6 that can maximize the sum (Max1) of the maximum consumption of one or more materials in the first group, subject to the first constraint function and the second constraint function of the first objective function, can be obtained, and the inventory of materials and the demand of product components can be reduced as much as possible, thereby reducing the overstock of materials and the shortage of product components.

[0236] In example embodiments, a linear programming model may be used to calculate a maximum consumption amount of each material in the first group for at least one of the one or more products. In some examples, the linear programming model is an integer linear programming model. In one example, the linear programming model is a pure integer linear programming model, where all variables are integers. In another example, the linear programming model is a mixed integer linear programming model, where some variables are integers and some are non-integer. Various suitable methods can be implemented in linear programming models. 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 relatively small subsets of solutions. The relatively small subsets can then be systematically evaluated until an optimal solution is found. Branch-and-bound methods can be implemented in pure integer linear programming models or in mixed integer linear programming models. In another example, a cutting plane method can be used, which iteratively navigates to a feasible set or objective function via linear inequalities, called cuts. Cutting plane methods can be implemented in pure integer linear programming models or in mixed integer linear programming models.

[0237] In an exemplary embodiment, the satisfactory quantities of the one or more materials in the first group for the corresponding product component calculated by the linear programming model in step 117 are satisfactory quantities for producing the corresponding product component when the one or more materials in the first group satisfy the maximum consumption quantity for the one or more product components. In an exemplary embodiment, calculating the satisfactory quantities of the one or more substitutable material groups in the first group for the corresponding product component based on the satisfactory quantities of the one or more materials in the first group for the corresponding product component may include adding the satisfactory quantities of multiple materials located in the same substitution group in the first group for producing the corresponding product component to obtain the satisfactory quantities of the one or more substitutable material groups in the first group for the corresponding product component. As shown in Table 4, in the production process of product component PRO-1, materials A and B are in the same substitution group, and the satisfactory quantity y1 of material A for producing product component PRO-1 and the satisfactory quantity y2 of material B for producing product component PRO-1 are added together to obtain the satisfactory quantities y1+y2 of materials A and B located in the same substitution group for product component PRO-1. Similarly, the sum of the satisfactory quantities of materials C and D located in the same substitution group for product component PRO-1 is y3+y4, and the sum of the satisfactory quantities of materials C and H located in the same substitution group for product component PRO-4 is y5+y6.

[0238] Step 118: Based on the available quantities of the one or more substitutable material groups in the first group for the corresponding product components and the demand quantities of the one or more product components in the first group, determine whether there is a shortage of the one or more substitutable material groups in the first group for the corresponding product components; if there is a shortage, execute step 119; if there is no shortage, calculate the remaining quantities of the one or more materials in the first group based on the inventory quantities of the one or more materials in the first group and the maximum consumption quantities of the one or more materials in the first group for the one or more product components, and update the inventory quantities of the one or more materials in the first group using the remaining quantities of the one or more materials in the first group.

[0239] In an exemplary embodiment, in step 118, determining whether there is a shortage of one or more substitutable material groups in the first group for the corresponding product component based on the satisfyable quantity of the one or more substitutable material groups in the first group for the corresponding product component and the demand quantity of the one or more product components in the first group includes: If the available quantity of the one or more substitutable material groups in the first group for the corresponding product components is greater than the demand quantity of the one or more product components in the first group, determine that there is no shortage of the one or more substitutable material groups in the first group for the corresponding product components and that there is a remaining material in the first group; If the satisfying quantity of the one or more substitutable material groups in the first group for the corresponding product components is equal to the demand quantity of the one or more product components in the first group, determining that there is no shortage of the one or more substitutable material groups in the first group for the corresponding product components, and the materials in the first group can just meet the demand for the corresponding product components; The method may include determining that there is a shortage of one or more substitutable material groups in the first group for the corresponding product component when the satisfyable quantity of the one or more substitutable material groups in the first group for the corresponding product component is less than the demand quantity of the one or more product components in the first group.

[0240] In an exemplary embodiment, in step 118, calculating the remaining quantity of the one or more materials in the first group based on the inventory quantity of the one or more materials in the first group and the maximum consumption quantity of the one or more materials in the first group for the one or more product components may include subtracting the maximum consumption quantity of the one or more materials in the first group for the one or more product components in the second group from the inventory quantity of the one or more materials in the first group to obtain the remaining quantity of the one or more materials in the first group. Let's take the consumption of materials C and H to manufacture product component PRO-4 in Table 4 as an example. If the priority of material H is 1 and the priority of material C is 2, material H is used first to manufacture product component PRO-4. The maximum consumption amount of material H for product component PRO-4, 2y6, is subtracted from the inventory amount of material H, 1000, to obtain the remaining amount of material H, 1000-2y6. If 1000-2y6 is greater than or equal to 0, material H can meet the demand for product component PRO-4, and in this case, the demand for product component PRO-4 can be met without consuming material H. If 1000-2y6 is less than 0, material H cannot meet the demand for product component PRO-4, and in this case, material C is used to supplement the demand for product component PRO-4. The satisfyable quantity (y5) of material C to produce product component PRO-4 is equal to the demand for product component PRO-4 (1300) minus the satisfyable quantity (y6) of material H to produce product component PRO-4. Subtract the maximum consumption quantity (2y5) of material C for product component PRO-4 (3000) from the inventory quantity of material C (3000) to obtain the remaining quantity of material C: 3000-2y5=3000-2(1300-y6). If the remaining quantity of material H (3000-2y5) is greater than or equal to 0, it indicates that materials C and H can satisfy the demand for product component PRO-4 and there is no shortage of materials in the first group to produce product component PRO-4. If the remaining quantity of material C (3000-2y5) is less than 0, it indicates that materials H and C cannot satisfy the demand for product component PRO-4 and there is a shortage of materials in the first group to produce product component PRO-4.

[0241] In an exemplary embodiment, the remaining amount of one or more materials in the first group may be used to update the inventory amount of one or more materials in the first group, and the updated inventory amount may be used to determine whether there is a shortage of the corresponding materials in the first group when manufacturing the corresponding product component. If the updated inventory amount is greater than or equal to zero, it indicates that there is no shortage of the corresponding materials in the first group. If the updated inventory amount is less than zero, it indicates that there is a shortage of the corresponding materials in the first group. If there is a shortage and the inventory amount is a negative number, the absolute value of the inventory amount is the shortage amount.

[0242] In the illustrative embodiment, an example will be described in which material H is consumed when manufacturing product component PRO-4. After manufacturing product component PRO-4 using material H, the remaining amount of material H is 1000-2y6, and the inventory amount of material H can be updated from 1000 to 1000-2y6 to avoid the inventory amount of material (H) being higher than the actual inventory amount, thereby enabling efficient material management.

[0243] Step 119: Determine whether there is a semi-finished product component in the material group in the first group that has a shortage. If there is, execute step 120. If there is no semi-finished product component, update the inventory of the corresponding material using the remaining amount of the material in the first group that has a shortage. Calculate the shortage amount of the one or more substitutable material groups for the product component based on the available amount of the one or more substitutable material groups in the first group for the corresponding product component and the demand amount of the one or more product components in the first group.

[0244] In an exemplary embodiment, the remaining amount of the material in the first group that is in short supply, as limited by the second constraint function of the first objective function, is a number greater than or equal to zero.

[0245] In an exemplary embodiment, calculating a shortage amount of the one or more substitutable material groups for the product component based on the satisfyable amount of the one or more substitutable material groups in the first group for the corresponding product component and the demand amount of the one or more product components in the first group may include subtracting the satisfyable amount of the one or more substitutable material groups in the first group for the corresponding product component from the demand amount of the one or more product components in the first group to obtain the shortage amount of the one or more substitutable material groups for the product component.

[0246] Step 120: obtain material data of one or more semi-finished product components of one or more material groups in the first group that have a shortage, and determine the one or more semi-finished product components of the one or more material groups in the first group that have a shortage as fifth group semi-finished product components.

[0247] In an exemplary embodiment, the material data of the plurality of semi-finished components of the material group having a shortage in the first group (i.e., the data of the materials of the fifth group semi-finished components) includes the product number of the product component, the material number of the material having a shortage, the material number of the semi-finished component, the consumption of the product component versus the semi-finished component (i.e., the consumption of the semi-finished component against the substitutable material), the inventory amount of the semi-finished component, the substitution group of the semi-finished component, and the shortage amount of the product component (which can be understood as the demand amount of the product component that the semi-finished component needs to satisfy). The material data of the semi-finished components of the material group having a shortage in the first group may be shown as in Table 6.

[0248] [Table 5]

[0249] As shown in Table 6, semi-finished components PCB-3 and PCB-4 are in the same substitution group D6, and semi-finished components PCB-1 and PCB-2 are substitutable for each other when producing material C. Semi-finished components PCB-6 and PCB-7 are in the same substitution group D7, and semi-finished components PCB-6 and PCB-7 are substitutable for each other when producing material D. Material C can be used to produce product components PRO-1 and PRO-4. Therefore, material C belongs to the shared materials used to produce product components PRO-1 and PRO-4.

[0250] Step 121: based on the data of materials of one or more semi-finished components in the fifth group, calculate the maximum consumption of one or more semi-finished components in the fifth group for the product components corresponding to the material group with one or more shortages in the first group;

[0251] In an exemplary embodiment, calculating, based on the material data for the one or more semi-finished components in the fifth group, maximum consumption amounts of the one or more semi-finished components in the fifth group for product components corresponding to the material groups having one or more shortages in the first group may include calculating, using a fifth linear programming model, maximum consumption amounts of the one or more semi-finished components in the fifth group for product components corresponding to the material groups having one or more shortages in the first group.

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

number

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

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

number

[0255] In an exemplary embodiment, the first constraint function of the fifth objective function can be understood as a constraint on the shortage of product components corresponding to the corresponding materials in the first group that are in short supply (i.e., the demand for product components corresponding to the corresponding materials in the first group that are in short supply). As shown in Table 6, there is a shortage of product component PRO-1 corresponding to materials C and D, and there is a shortage of product component PRO-4 corresponding to material C (i.e., the value of l is 3). The shortage Q1 of product component PRO-1 corresponding to material C is 20000-y1-y2, the shortage Q2 of product component PRO-1 corresponding to material D is 20000-y1-y2, and the shortage Q3 of product component PRO-4 corresponding to material C is 1300-y5-y6. The total number J of the groups of product components is 1 (the semi-finished components of the group include semi-finished component PCB-3 and semi-finished component PCB-4), the total number J of the groups of semi-finished components that can be substituted for each other when producing product component PRO-1 corresponding to material D is 1 (the semi-finished components of the group include semi-finished component PCB-6 and semi-finished component PCB-7), and the total number J of the groups of semi-finished components that can be substituted for each other when producing product component PRO-4 corresponding to material C is 1 (the semi-finished components of the group include semi-finished component PCB-3 and semi-finished component PCB-4), and the constraints on the shortage quantities of product components corresponding to the corresponding materials that are in short supply in the second group are as follows: The constraint on the shortage amount of the product component PCB-1 corresponding to materials C and D in the first group that have shortages is p1+p2+p3+p4≦20000−y3−y4. The constraint on the shortage amount of product component PCB-4 corresponding to material C in the first group that has a shortage is p5+p6≦1300−y5−y6.

[0256] In an exemplary embodiment, the fifth objective function is further constrained by a second constraint function, which can be expressed as:

number

[0257] In an exemplary embodiment, the second constraint function of the fifth objective function can be understood as a constraint on the inventory quantities 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 quantity of semi-finished component PCB-3 is 2000, the available inventory quantity of semi-finished component PCB-4 is 1500, the available inventory quantity of semi-finished component PCB-6 is 400, and the available inventory quantity of semi-finished component PCB-7 is 2000. The constraints on the inventory quantities of the corresponding semi-finished components in the fifth group are as follows: The constraint on the inventory quantity of semi-finished component PCB-3 is 4p1+4p5≦1000. The constraint on the inventory quantity of semi-finished component PCB-4 is 4p2+4p6≦1500. The manufacturing ratio for the inventory of semi-finished component PCB-6 is 4p3≦400. The inventory constraint for semi-finished component PCB-7 is 4p4≦2000.

[0258] In the 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 for the finished product components corresponding to one or more shortages of materials in the first group, and the values ​​of p1, p2, p3, and p4 that can maximize the sum (Max5) of the maximum consumption of one or more semi-finished components in the fifth group are obtained under the premise of satisfying the first constraint function and the second constraint function of the fifth objective function, so that the inventory of the semi-finished components can be reduced as much as possible and the shortage of materials in the first group can be made up as much as possible, thereby reducing the overstock of semi-finished components and the shortage of materials in the first group.

[0259] Step 122: Based on the inventory amounts of the one or more semi-finished components in the fifth group and the maximum consumption amounts of the one or more semi-finished components in the fifth group for the product components corresponding to the one or more corresponding materials in the first group that are in short supply, calculate the remaining amounts of the one or more semi-finished components in the fifth group, and update the inventory amounts of the one or more semi-finished components in the fifth group using the remaining amounts of the one or more semi-finished components in the fifth group.

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

[0261] In an exemplary embodiment, the remaining amount of material for one or more of the semi-finished product components in the fifth group is a number greater than or equal to zero, as limited by the second constraint function of the fifth objective function.

[0262] In the illustrative embodiment, an example will be described in which semi-finished component PCB-6 is consumed when manufacturing product component PRO-1 corresponding to material D. After using semi-finished component PCB-6 to make up for the shortage of product component PRO-1 corresponding to material D, the remaining amount of semi-finished component PCB-6 is 400-4p3, and the inventory amount of semi-finished component PCB-6 can be updated from 400 to 400-4p3 to avoid the inventory amount of the semi-finished component (PCB-6) being higher than the actual inventory amount, thereby enabling efficient management of materials for semi-finished components.

[0263] Step 123: calculate a fifth shortage value based on the satisfactory quantity of one or more semi-finished components in the fifth group for manufacturing the product components corresponding to the corresponding material groups having shortages in the first group and the shortage quantities of the product components corresponding to the corresponding material groups having shortages in the first group, and use the fifth shortage value to update the shortage quantities of the product components corresponding to the corresponding materials having shortages in the first group.

[0264] In an exemplary embodiment, calculating the fifth shortage value based on the satisfactory quantity of one or more semi-finished components in the fifth group for manufacturing the product component corresponding to the corresponding material group having a shortage in the first group and the shortage quantity of the product component corresponding to the corresponding material group having a shortage in the first group may include subtracting the satisfactory quantity of the one or more semi-finished components in the fifth group for manufacturing the product component corresponding to the corresponding material group having a shortage in the first group from the shortage quantity of the product component corresponding to the corresponding material group having a shortage in the first group to obtain the fifth shortage value of the product component corresponding to the corresponding material group in the first group. The satisfactory quantity of one or more semi-finished components in the fifth group for manufacturing a product component corresponding to a corresponding material group having a shortage in the first group is equal to the sum of integer data after rounding down to the ratio of the inventory amount of one or more semi-finished components in the fifth group to the unit consumption value of one or more semi-finished components in the fifth group for the product component corresponding to the corresponding material group having a shortage in the first group. In an exemplary embodiment, the satisfactory quantity of one or more semi-finished components in the fifth group for manufacturing a product component corresponding to a corresponding material group having a shortage in the first group is obtained by using a fifth linear programming model to calculate the maximum consumption amount of one or more semi-finished components in the fifth group for the product component corresponding to one or more material groups having a shortage in the first group. As shown in Table 6, the satisfactory quantities of semi-finished components PCB-3, PCB-4, PCB-6, and PCB-7 for manufacturing product component PRO-1 corresponding to substitutable material groups C and D are p1 + p2 + p3 + p4.

[0265] 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 substitute group for the corresponding product component. Satisfiable quantity of substitute group for corresponding product component = Satisfiable quantity of first group material for corresponding product component + Satisfiable quantity of fifth group semi-finished product component for corresponding product component. Take the example of producing product component PRO-1 using substitute group materials C and D, as shown in Tables 4 and 6. The satisfyable quantities of substitute group materials C and D for the corresponding product component PRO-1 are y3 + y4, and the satisfyable quantities of semi-finished components PCB-3, PCB-4, PCB-6, and PCB-7 in the fifth group for the corresponding product component PRO-1 are p1 + p2 + p3 + p4. The demand for product component PRO-1 is 20000, the shortage of product component PRO-1 = 20000 - y3 - y4, and the final shortage of product component PRO-1 = 20000 - y3 - y4 - (p1 + p2 + p3 + p4), and the fifth shortage value may be p1 + p2 + p3 + p4 - (20000 - y3 - y4).

[0266] Step 124: Calculate a sixth shortage value based on the satisfactory quantity of one or more semi-finished component parts in the fifth group for producing the corresponding materials in the first group that have a shortage and the shortage quantity of the corresponding material group in the first group that has a shortage, and use the sixth shortage value to update the shortage quantity of the corresponding material group in the first group that has a shortage.

[0267] In an exemplary embodiment, calculating the sixth shortage value based on the satisfactory quantity of one or more semi-finished component productions in the fifth group for producing the corresponding material having a shortage in the first group and the shortage quantity of the corresponding material having a shortage in the first group may include subtracting the satisfactory quantity of one or more semi-finished component productions in the fifth group for producing the corresponding material having a shortage in the first group from the shortage quantity of the corresponding material having a shortage in the first group to obtain the sixth shortage value of the corresponding material in the first group. The satisfactory quantity of one or more semi-finished components in the fifth group for producing the corresponding materials in the first group that have a shortage is equal to an integer value after rounding down to the ratio of the inventory amount of the one or more semi-finished components in the fifth group to the consumption value of the one or more semi-finished components in the fifth group for the corresponding materials in the first group that have a shortage. In an exemplary embodiment, the satisfactory quantity corresponding to one or more semi-finished components in the fifth group for producing the corresponding materials in the first group that have a shortage is obtained by the sum of the products of the satisfactory quantities of one or more semi-finished components in the fifth group for producing the product components corresponding to the corresponding materials in the first group that have a shortage and the consumption value of the corresponding materials in the first group that have a shortage for the corresponding product components. As shown in Table 6, when product component PRO-4 corresponding to material C is produced using semi-finished components PCB-3 and PCB-4, the satisfactory quantity of semi-finished components PCB-3 and PCB-4 for material C is 2p5 + 2p6. The sixth shortage value of material C is obtained by subtracting the satisfactory amount 2p5+2p6 of semi-finished components PCB-3 and PCB-4 from the shortage amount of materials C and H when manufacturing product component PRO-4, (1300-y5-y6) / 2, i.e., the sixth shortage value of material C = (1300-y5-y6) / 2-(2p5+2p6).

[0268] Step 125: obtain the configuration parameters, allocate the shortage amount of the shortage material in the corresponding material group that has a shortage in the first group according to the configuration parameters, and update the shortage amount of the corresponding material in the first group using the allocated shortage amount.

[0269] In an exemplary embodiment, the configuration parameters may include a priority of the corresponding material in the first group that has a shortage. Step 125 may include allocating a shortage amount for the corresponding material in the first group that has a shortage based on the priority of the material. In an exemplary embodiment, the shortage amount is preferentially allocated to materials with higher priority.

[0270] Table 7 shows an example of allocating shortage quantities to materials in the first group that are in short supply according to material priority.

[0271] [Table 6]

[0272] In an exemplary embodiment, the configuration parameters are not limited to the priority of the alternative materials, but can be set according to actual business needs, for example, the shortage amount can be allocated according to the size of the shared quantity of the alternative materials and the size of the availability of the alternative materials.

[0273] In an exemplary embodiment, during the manufacturing process of one or more product components, the consumption of materials (either essential materials or non-substitutable materials) in the first group is first calculated. If there is a shortage of materials in the first group, the corresponding semi-finished components are obtained and converted to the corresponding materials in the first group using the semi-finished components. The shortage or overstock status of materials in the first group is obtained. The material consumption of the first group and the corresponding semi-finished components is then calculated. Finally, the consumption of materials (substitutable materials) in the second group is calculated. If there is a shortage of materials in the second group, the materials in the semi-finished components are converted to the corresponding materials in the second group when there are semi-finished components. Finally, the overstock or shortage quantities of the first group, the second group, and the corresponding semi-finished components are obtained. If the remaining quantity of materials is greater than zero, it is called an overstock quantity. If the remaining quantity of materials is less than zero, it is called a shortage quantity (or the shortage quantity is calculated from the remaining quantity).

[0274] In an exemplary embodiment, step 122 may be followed by step M0. That is, if it is determined that there is a shortage of one or more next-level materials in the fifth group based on the remaining amount of the one or more next-level materials in the fifth group, obtaining configuration parameters of the next-level materials, reallocating the shortage amount of the deficient materials in the corresponding next-level material group in the fifth group based on the configuration parameters of the next-level materials, updating the shortage amount of the corresponding next-level material in the fifth group with the reallocated shortage amount, and displaying the updated shortage amount and shortage status of the corresponding next-level material in the fifth group through the first output interface; if it is determined that there is no shortage of one or more next-level materials in the fifth group and the remaining amount is greater than 0, outputting the remaining amount and overstock status of the one or more next-level materials in the fifth group through the first display interface; if it is determined that there is no shortage of one or more next-level materials in the fifth group and the remaining amount is 0, outputting the remaining amount and material status of the one or more next-level materials in the fifth group through the first display interface.

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

[0276] In an exemplary embodiment, after step 123 and before step 124, the method may further include outputting, via a first display interface, the shortage quantity of the product component corresponding to the corresponding material in the first group that has a shortage.

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

[0278] In an exemplary embodiment, after step 125, the method may further include outputting the updated shortage amount of the corresponding material in the first group that has a shortage through a first display interface.

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

[0280] In an exemplary embodiment, the inventory quantity of the semi-finished components in the third group obtained in step 113, the inventory quantity of the corresponding materials in the second group that are in short supply in step 114, and the inventory quantity of the semi-finished components in the third group and the inventory quantity of the semi-finished components in the fourth group obtained in step 115 may be used as reference data for determining whether the materials of the corresponding semi-finished components are in overstock or short supply when the subsequent calculation of the substitutable materials consumed by the materials in the second group does not involve the materials of the corresponding semi-finished components in the third and fourth groups; when the subsequent calculation of the substitutable materials consumed by the materials in the second group involves the materials of the corresponding semi-finished components in the third and fourth groups, the data of the related semi-finished components is not final data, but the final data obtained by calculating the consumption quantity of the second group is used as the reference data for determining whether the materials are in overstock or short supply.

[0281] In an exemplary embodiment, step 111 may further include: after obtaining the remaining amount of one or more semi-finished components in the fourth group, if the remaining amount of one or more semi-finished components in the fourth group is greater than 0, determining whether one or more materials in the fourth group are substitutable for at least one of the one or more materials in the first group and the third group that are in short supply based on substitution relationship information between the semi-finished components in the fourth group; determining that there is overstock of one or more materials in the fourth group if it is determined that the one or more materials in the fourth group are not substitutable for the one or more materials in the first group and the third group that are in short supply; and determining that there is an overstock status or shortage status of one or more materials in the fourth group based on consumption status of the one or more materials in the fourth group by the first group and the third group if it is determined that there is substitutable for the one or more materials in the fourth group that are in short supply in the first group and the third group.

[0282] In an exemplary embodiment, the semi-finished product components described above may be the next level of material from which the finished product components are manufactured.

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

[0284] In an exemplary embodiment, as shown in FIG. 4, the computer-implemented method may further include generating one or more user interfaces. The one or more user interfaces may further include a first output interface OI1 that displays the material status of the corresponding materials in at least one of the first to fourth groups.

[0285] In an exemplary embodiment, the material status may include a material shortage, a material overstock, and a material just sufficient.

[0286] In an exemplary embodiment, as shown in FIG. 4 , the one or more user interfaces may further include a first input interface II1, the first input interface II1 configured to receive one or more user inputs for querying a database, wherein the database stores data of a plurality of materials. 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 querying a database in response to the user selection to determine one or more material statuses associated with the one or more conditions in the database. The one or more conditions may include at least one of an overstock status of an overstocked material and a shortage status of a shortage material. The one or more user interfaces may further include a second output interface OI2, the second output interface OI2 configured to display the one or more overstocked or shortage materials as a result of the query of the database. In an exemplary embodiment, the one or more conditions further include at least one of a manufacturing location identifier number, a material identifier number, or a date range.

[0287] In an exemplary embodiment, the second output interface OI2 may be further configured to display identification numbers of one or more products manufactured with one or more overstock materials. In an exemplary embodiment, the second output interface OI2 may be further configured to display demand for the overstock materials to manufacture corresponding product components. A user may analyze the relationship between demand and overstock status.

[0288] In an exemplary embodiment, the one or more user interfaces may further include a second input interface II2, the second input interface II2 configured to receive one or more user inputs for adjusting the priority of the corresponding materials in the first group. The computer-implemented method may further include redetermining whether the corresponding materials in the first group are overstocked or understocked based on the adjusted priorities of the corresponding materials in the first group.

[0289] In an exemplary embodiment, the second input interface II2 may be further configured to receive one or more user inputs for adjusting the priority of the corresponding next-level materials in the third group. The computer-implemented method may further include redetermining whether the corresponding next-level materials in the third group are overstocked or understocked based on the adjusted priorities of the corresponding next-level materials in the second group.

[0290] In an exemplary embodiment, the one or more user interfaces may further include a third input interface II3, the third input interface II3 configured to receive one or more user inputs for adjusting demand for the one or more product components. The computer-implemented method includes calculating an adjusted maximum consumption amount 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 materials in the first group with the available inventory of the corresponding materials in the first group; and redetermining whether there is an overstock or shortage of the corresponding materials in the first group. 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 the one or more products. The memory further stores computer-executable instructions for controlling the one or more processors to calculate, based on the adjusted demand for the one or more products, an adjusted maximum consumption amount of the corresponding materials in the first group within the period, compare the adjusted maximum consumption amount of the corresponding materials in the first group with the available inventory amount of the corresponding materials in the first group, and redetermine whether there is an overstock of the corresponding materials in the first group. Adjusting the demand for one or more products can reduce overstock of materials, allowing manufacturers to better adapt to the market and supply products more quickly.

[0291] The one or more user interfaces may further include a third output interface OI3 configured to display an estimated surplus for the overstocked material at the first manufacturing location and an estimated loss amount for the overstocked material at the second manufacturing location. Optionally, the third output interface OI3 is configured to display a table including the identification number of the overstocked material, the identification number of the manufacturing location, the estimated surplus, and the estimated loss amount.

[0292] 5 illustrates a third output interface OI3 in some embodiments of the present disclosure. Referring to FIG. 5, the third output interface OI3 is configured to display the surplus of material Mat-1 at production location A, where it is overstocked by 5000 g, the loss amount at production location B, where it is lost by 1000 g, and the loss amount at production location C, where it is lost by 3000 g. In some embodiments, a user can allocate the overstock material between production locations based on several factors, including transportation costs, the urgency with which the overstock material is needed at the second production location, etc.

[0293] In some examples, the computer-implemented method may further include, if determining that an overstock of the corresponding material in the first group exists, adjusting demand for the one or more product components to minimize the overstock of the material, and manufacturing the one or more product components based on the adjusted demand for the one or more products. Adjusting the demand for the one or more product components may reduce the overstock of the material, allowing manufacturers to better meet the market and supply products more quickly.

[0294] In an exemplary embodiment, a remaining quantity of a material greater than zero indicates that there is an excess of the material and the remaining quantity can be used to update the excess inventory quantity. A remaining quantity less than zero indicates that there is a shortage of the material and the remaining quantity can be used to update the shortage quantity. Both the available inventory quantity and the inventory quantity refer to the quantity of the material that is available before manufacturing the corresponding product component or semi-finished component of the product component. The remaining quantity is usually obtained by subtracting the consumption quantity from the inventory quantity (or available inventory quantity). After the manufacturing of the corresponding product component is completed, the remaining quantity of the corresponding material can be used to update the inventory quantity of the corresponding material.

[0295]

[0023] Embodiments of the present disclosure further provide a manufacturing control device for one or more products, and in an exemplary embodiment, as shown in FIG. 6, the manufacturing control device for one or more products includes: Memory and one or more processors; The memory and the one or more processors are connected to each other, and the memory is connected to the one or more processors. obtaining data on a plurality of next-level materials for one or more materials having a shortage for manufacturing one or more product components, the data on the plurality of next-level materials for the one or more materials having a shortage including available inventory amounts of the plurality of next-level materials; calculating maximum consumption amounts of a plurality of next-level materials for at least one of the one or more materials having a shortage; and determining whether there is a shortage for one or more of the materials that have a shortage based on the maximum consumption amounts and available inventory amounts of corresponding materials for the plurality of next-level materials.

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

[0297] In an exemplary embodiment, one or more product manufacturing control devices may be used to control the manufacturing of one or more final products or one or more semi-finished product components. In an exemplary embodiment, a product may be a final product or product component, or a semi-finished product component, which may be the next level of material to manufacture the product component.

[0298] An embodiment of the present disclosure further provides a computer program product, comprising a computer-readable non-transitory tangible medium having computer-readable instructions, the computer-readable instructions being executable by a processor to cause the processor to: acquiring data on a plurality of next-level materials for one or more materials having a shortage for manufacturing one or more product components, the data on the plurality of next-level materials for the one or more materials having a shortage including available inventory amounts of the plurality of next-level materials; calculating a maximum consumption amount of the plurality of next-level materials for at least one material of the one or more materials having a shortage; and determining whether there is a shortage of one or more of the materials that have a shortage based on the maximum consumption amounts and available stock amounts of corresponding materials of the plurality of next-level materials.

[0299] An embodiment of the present disclosure further provides a manufacturing management device for one or more products. Referring to FIG. 6, the manufacturing management device for one or more products includes: Memory and one or more processors; The memory and the one or more processors are connected to each other, and the memory is connected to the one or more processors. receiving a material query command input by a user via a first input interface; retrieving, in response to the material query instruction, data from a data source regarding a plurality of materials for manufacturing one or more product components, the data regarding the plurality of materials including available inventory amounts of the plurality of materials; calculating a maximum consumption amount of the plurality of materials for at least one product component of the one or more product components; and determining whether there is a shortage of one or more materials for manufacturing one or more product components based on a maximum consumption amount of corresponding materials of the plurality of materials and an available inventory amount of corresponding materials of the plurality of materials.

[0300] Embodiments of the present disclosure further provide a computer program product, including a computer-readable non-transitory tangible medium having computer-readable instructions, the computer-readable instructions being executable by a processor to cause the processor to: receiving a material query command input by a user via a first input interface; retrieving, in response to the material query instruction, data from a data source regarding a plurality of materials for manufacturing one or more product components, the data regarding the plurality of materials including available inventory amounts of the plurality of materials; calculating a maximum consumption amount of the plurality of materials for at least one product component of the one or more product components; and determining whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption amount of corresponding materials of the plurality of materials and the available inventory amount of corresponding materials of the plurality of materials.

[0301] According to a computer-implemented method, an apparatus for managing the production of one or more products, and a computer program product provided by embodiments of the present disclosure, the computer-implemented method includes: receiving a material query command input by a user through a first input interface; acquiring, in response to the material query command, data on a plurality of materials used to manufacture one or more product components from a data source, the data on the plurality of materials including available inventory amounts of the plurality of materials; calculating a maximum consumption amount of the plurality of materials for at least one of the one or more product components; and determining whether there is a shortage of one or more materials used to manufacture the one or more product components based on the maximum consumption amount of corresponding materials of the plurality of materials and the available inventory amounts of corresponding materials of the plurality of materials. The technical solution according to the embodiments of the present disclosure can solve the problem of overstock or shortage of materials in a materials management process.

[0302] As will be understood by those skilled in the art, all or some steps of the methods, systems, and functional modules / units in the devices disclosed above can be implemented as software, firmware, hardware, or any suitable combination thereof. In hardware embodiments, the division between the functional modules / units mentioned above does not necessarily correspond to the division of physical components; for example, one physical component may have multiple functions, or one function or step may be performed by multiple physical components in cooperation. Some or all of the components may be implemented as software executed by a processor, such as a digital signal processor or microprocessor, or as hardware, or as an integrated circuit, such as a dedicated integrated circuit. Such software may be located on a computer-readable medium, which may include computer storage media (or non-transitory media) and communication media (or transitory media). As is well known to those skilled in the art, the term computer storage media includes volatile and non-volatile, removable and non-removable media implemented in any method or technology for storing information (e.g., 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 used to store the desired information and accessible by a computer. As known to those skilled in the art, communication media typically include computer-readable instructions, data structures, program modules, or other data in a modulated data signal, such as a carrier or other transport mechanism, and may include any information delivery media.

[0303] The embodiments of the present invention, i.e., the features of the embodiments, can be combined with each other to obtain new embodiments, unless they conflict with each other.

[0304] Although the embodiments disclosed in the present disclosure are as described above, the contents of the description are merely examples adopted for understanding the present disclosure and are not intended to limit the present disclosure. Those skilled in the art may make modifications and changes in the form and details of implementation without departing from the spirit and scope disclosed in the present disclosure, but the patent protection scope of the present disclosure shall comply with the scope described in the claims.

Claims

1. 1. A computer-implemented method comprising: receiving a material query command input by a user via a first input interface; retrieving, in response to the material query instruction, data from a data source regarding a plurality of materials for manufacturing one or more product components, the data regarding the plurality of materials including available inventory amounts of the plurality of materials; calculating a maximum consumption amount of the plurality of materials for at least one product component of the one or more product components; determining whether there is a shortage of one or more materials for manufacturing one or more product components based on a maximum consumption amount of corresponding materials of the plurality of materials and an available inventory amount of corresponding materials of the plurality of materials.

2. determining if a next level of material exists for the material having a shortage when determining that there is a shortage of a plurality of materials for manufacturing one or more product components; When determining that next-level materials exist for the material having a shortage, acquiring data of a plurality of next-level materials for the one or more materials having a shortage for manufacturing one or more product components, wherein the data of the plurality of next-level materials for the one or more materials having a shortage includes available inventory amounts of the plurality of next-level materials; calculating a maximum consumption amount of the plurality of next-level materials for at least one material of the one or more materials having a shortage; 2. The computer-implemented method of claim 1, further comprising: determining whether there is a shortage of the plurality of next-level materials based on a maximum consumption amount and an available inventory amount of corresponding materials of the plurality of next-level materials.

3. the data of the plurality of materials includes substitution relationship information between the plurality of materials, and the data of the plurality of next-level materials further includes substitution relationship information between the next-level materials; Before acquiring data of a plurality of next-level materials of the one or more materials having a shortage for manufacturing the one or more product components, the method further includes determining one or more materials having a shortage in a second group from the one or more materials having a shortage based on substitution relationship information among the plurality of materials, wherein the one or more materials having a shortage in the second group are materials that are not substitutable for at least one product component of the one or more product components; 3. The computer-implemented method of claim 2, further comprising determining data of one or more next-level materials in a third group and data of one or more next-level materials in a fourth group from data of one or more materials in a second group that have a shortage based on substitution relationship information between the next-level materials before calculating the maximum consumption amount of the plurality of next-level materials for at least one of the one or more materials that have a shortage, wherein the one or more next-level materials in the third group are substitutable for at least one of the one or more materials in the second group that have a shortage, and the one or more next-level materials in the fourth group are non-substitutable for at least one of the one or more materials in the second group that have a shortage.

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

5. 5. The computer-implemented method of claim 4, wherein calculating the maximum consumption of the one or more materials in the second group for the one or more product components based on the data of the one or more materials in the second group comprises: obtaining the maximum consumption of the one or more materials in the second group for the one or more product components by summing values ​​obtained by multiplying the demand for the one or more product components that require the one or more materials in the second group as non-substitutable materials by the corresponding unit consumption values ​​of the corresponding materials in the second group for the production of the one or more product components.

6. 5. The computer-implemented method of claim 4, further comprising, if determining that there is a shortage of one or more materials in the second group, calculating a shortage amount of the one or more materials in the second group that is in a shortage based on an available inventory amount of the one or more materials in the second group that is in a shortage and a maximum consumption amount of the one or more materials in the second group that is in a shortage.

7. calculating a maximum consumption amount of the plurality of next-level materials for at least one of the one or more materials having a shortage includes calculating a maximum consumption amount of one or more next-level materials in a fourth group for one or more materials having a shortage in the second group; 7. The computer-implemented method of claim 6, wherein determining whether there is a shortage of the plurality of next-level materials based on the maximum consumption and available inventory of the corresponding materials of the plurality of next-level materials includes: subtracting the maximum consumption of the one or more next-level materials in the fourth group from the available inventory of the one or more next-level materials in the fourth group to obtain a remaining amount of the one or more next-level materials in the fourth group; and determining whether there is a shortage of the one or more next-level materials in the fourth group based on the remaining amount of the one or more next-level materials in the fourth group.

8. 8. The computer-implemented method of claim 7, wherein calculating the maximum consumption of the one or more next-level materials in the fourth group for the one or more materials in the second group that are in short supply comprises: obtaining the maximum consumption of the one or more next-level materials in the fourth group for the one or more materials in the second group that are in short supply using a sum of values ​​obtained by multiplying the shortage amounts of the one or more next-level materials in the second group that require the one or more next-level materials in the fourth group as non-substitutable materials by the unit consumption values ​​of the corresponding next-level materials in the fourth group for the production of the one or more corresponding materials in short supply in the second group.

9. When determining that there is a shortage of one or more next-level materials in the fourth group, obtain a shortage amount of the one or more next-level materials in the fourth group based on the remaining amount of the one or more next-level materials in the fourth group, and display the shortage amount and shortage status of the one or more next-level materials in the fourth group through a 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 amount is 0, displaying the remaining amount and material status of the one or more next-level materials in the fourth group via the first output interface; 8. The computer-implemented method of claim 7, further comprising: when it is determined that one or more next-level materials in the fourth group have no shortage and a remaining amount greater than zero, 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 have a shortage based on substitution relationship information between the next-level materials; 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 have a shortage, determining that one or more next-level materials in the fourth group have an overstock; and displaying the overstock status and remaining amount of the one or more next-level materials in the fourth group via a first output interface.

10. calculating a maximum consumption amount of the plurality of next-level materials for at least one of the one or more materials having a shortage includes calculating, using a third linear programming model, a maximum consumption amount of one or more semi-finished product components in a third group for one or more materials having a shortage in the second group; 3. The computer-implemented method of claim 2, wherein determining whether there is a shortage of the plurality of next-level materials based on the maximum consumption and available inventory of the corresponding materials of the plurality of next-level materials comprises: subtracting the maximum consumption of one or more next-level materials in the third group from the available inventory of the one or more next-level materials in the third group to obtain a remaining amount of the one or more next-level materials in the third group; and determining whether there is a shortage of the one or more next-level materials in the third group based on the remaining amount of the one or more next-level materials in the third group.

11. When determining that there is a shortage of one or more next-level materials in the third group, obtain a shortage amount of the one or more next-level materials in the third group based on the remaining amount of the one or more next-level materials in the third group, and display the shortage amount and shortage status of the one or more next-level materials in the third group through a 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 amount is 0, displaying the remaining amount and material status of the one or more next-level materials in the third group via the first output interface; 11. The computer-implemented method of claim 10, further comprising: when it is determined that there is no shortage of one or more next-level materials in the third group and that the remaining amount is greater than zero, determining whether the one or more next-level materials in the third group are substitutable for at least one of the one or more materials in the first group that are in shortage based on substitution relationship information between the next-level materials; when it is determined that the one or more materials in the third group are not substitutable for the one or more materials in the first group that are in shortage, determining that there is an overstock of one or more next-level materials in the third group; and displaying the overstock status and remaining amount of the one or more next-level materials in the third group via a first output interface.

12. The third objective function of the third linear programming model is expressed as follows: [Equation 1] where x i represents the available quantity of the corresponding next-level material in the third group to produce the corresponding material in the second group that is in short supply, and d i 11. The computer-implemented method of claim 10, wherein N represents the unit consumption value of the corresponding next-level materials in the third group for the corresponding materials in the second group that have one or more shortages, where N is a positive integer and N≧1.

13. The third objective function is constrained by a first constraint function, which can be expressed as: [Equation 2] Here, Q l represents the shortage of the lth material in the second group, and (Q l ,G j ) represents a set of variables of the jth group of next-level materials for the lth missing material, and multiple next-level materials in the jth group are mutually substitutable when producing the lth missing material, and 0≦x i ≦Q l 13. The computer-implemented method of claim 12, wherein 1≦j≦J, where J represents the total number of groups of next-level materials that can be substituted for each other when producing the material with the l-th shortage.

14. The third objective function is constrained by the second constraint function, which can be expressed as: [Equation 3] where C m represents the available inventory of the mth level material in the third group, and X m 13. The computer-implemented method of claim 12, wherein m represents one set of variables for the mth next-level materials, where 1≦m≦M, and M represents a total number of types of next-level materials in the third group.

15. the data on the plurality of materials includes substitution relationship information among the plurality of materials and demand quantities of one or more product components; Before acquiring data of a plurality of next-level materials of one or more materials that are in short supply for manufacturing the one or more product components, determining one or more materials in a first group from the plurality of materials based on substitution relationship information among the plurality of materials, wherein the one or more materials in the first group are substitutable materials for at least one product component of the one or more product components; Calculating a maximum consumption amount of the plurality of materials for at least one product component of the one or more product components includes calculating a maximum consumption amount of one or more materials in the first group for the one or more product components based on data of the one or more materials in the first group; 3. The computer-implemented method of claim 2, wherein determining whether there is a shortage of one or more materials for manufacturing one or more product components based on the maximum consumption amount of corresponding materials of the plurality of materials and the available inventory amount of corresponding materials of the plurality of materials comprises: obtaining a satisfactory amount of one or more substitutable material groups in the first group for the one or more product components when the consumption amount of the one or more materials in the first group for the one or more product components is at the maximum consumption amount; and determining whether there is a shortage of one or more substitutable material groups in the first group for the corresponding product components based on the satisfactory amount of the one or more substitutable material groups in the first group for the one or more product components and the demand amount of the one or more product components.

16. When it is determined that there is a shortage of a plurality of materials for manufacturing the one or more product components, determining whether there is a next-level material for the material with the shortage includes, when it is determined that there is a shortage of one or more substitutable material groups in the first group for the corresponding product component, determining whether there is a next-level material for the material group with the shortage in the first group; When it is determined that a next-level material exists for the material having a shortage, acquiring data on a plurality of next-level materials for the one or more materials having a shortage for manufacturing the one or more product components includes, when it is determined that a next-level material exists for a material group having a shortage in the first group, acquiring material data on one or more next-level materials for the one or more material groups having a shortage in the first group; Calculating the maximum consumption amount of the plurality of next-level materials for at least one material of the one or more materials having a shortage includes: determining the plurality of next-level materials of the one or more material groups having a shortage 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 amount of the one or more next-level materials in the fifth group for the product component corresponding to the one or more material groups having a shortage in the first group; 16. The computer-implemented method of claim 15, wherein determining whether there is a shortage of the plurality of next-level materials based on the maximum consumption and available inventory of the corresponding materials of the plurality of next-level materials comprises: calculating a remaining amount of the one or more next-level materials in the fifth group based on the available inventory of the one or more next-level materials in the fifth group and a maximum consumption amount of the one or more next-level materials in the fifth group for product components corresponding to the one or more shortage-existing corresponding material groups in the first group; and determining whether there is a shortage of the one or more next-level materials in the fifth group based on the remaining amount of the one or more next-level materials in the fifth group.

17. When determining that there is a shortage of one or more substitutable material groups in the first group for the corresponding product component, the method further includes calculating a shortage amount of one or more substitutable material groups in the first group for the corresponding product component based on the available amount of the one or more substitutable material groups in the first group for the corresponding product component and the demand amount of the material in the first group that is in shortage; When determining that one or more next-level materials in the fifth group are in short supply, calculate a sixth shortage value based on the sufficient quantity of one or more next-level materials in the fifth group for producing the corresponding materials in the first group that are in short supply and the shortage amount of the corresponding material group in the first group that is in short supply, and update the shortage amount of the corresponding material group in the first group that is in short supply using the sixth shortage value; 17. The computer-implemented method of claim 16, further comprising: obtaining configuration parameters; reallocating shortage amounts of the shortage materials in the corresponding material group having shortages in the first group based on the configuration parameters; updating the shortage amounts of the corresponding materials in the first group with the allocated shortage amounts; and displaying the shortage amounts and shortage status of the corresponding materials in the first group through a first output interface.

18. When it is determined that there is a shortage of one or more next-level materials in the fifth group, obtain the shortage amount of the one or more next-level materials in the fifth group based on the remaining amount of the one or more next-level materials in the fifth group, and display the shortage amount and shortage status of the one or more next-level materials in the fifth group 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 amount is greater than 0, outputting the remaining amount and overstock status of the one or more next-level materials in the fifth group through the first display interface; 17. The computer-implemented method of claim 16, further comprising: when it is determined that there is no shortage of one or more next-level materials in the fifth group and that the remaining amount is 0, outputting the remaining amount and material status of the one or more next-level materials in the fifth group via the first display interface.

19. 17. The computer-implemented method of claim 16, further comprising: when determining that one or more next-level materials in the fifth group have a shortage, obtaining configuration parameters of the next-level materials, reallocating shortage quantities of the missing materials in the corresponding next-level material groups in the fifth group that have a shortage based on the configuration parameters of the next-level materials, updating shortage quantities of the corresponding next-level materials in the fifth group with the reallocated shortage quantities, and displaying the updated shortage quantities and shortage status of the corresponding next-level materials in the fifth group via the first output interface.

20. 17. The computer-implemented method of claim 16, further comprising, when determining that one or more next-level materials in the fifth group have a shortage, obtaining configuration parameters of the next-level materials, reallocating the shortage quantities of the corresponding next-level materials in the fifth group that have a shortage based on the configuration parameters of the next-level materials, and updating the shortage quantities of the corresponding next-level materials in the fifth group with the reallocated shortage quantities.

21. When it is determined that the next level material does not exist for the material having a shortage, displaying the shortage status of the material having a shortage via the first output interface; 3. The computer-implemented method of claim 2, further comprising: if it is determined that there is no shortage of one or more materials used to manufacture the one or more product components, displaying material information of the one or more materials used to manufacture the one or more product components via the first output interface.

22. 3. The computer-implemented method of claim 2, further comprising: when determining that there is an overstock or shortage of one or more materials having a shortage based on the maximum consumption amounts and available inventory amounts of corresponding materials of the plurality of next-level materials, adjusting demand for the one or more product components to minimize the overstock or shortage of next-level materials; and manufacturing the one or more product components based on the adjusted demand for the one or more product components.

23. generating one or more user interfaces; 3. The computer-implemented method of claim 2, wherein 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 the corresponding materials in at least one of the first group to the fifth group.

24. the one or more user interfaces further include a first input interface, the first input interface configured to receive one or more user inputs for querying a database, the database storing data on a plurality of materials; The computer-implemented method further includes receiving a user selection of one or more conditions from the first input interface, the user selection being used to select a material condition associated with the one or more conditions; and querying the database in response to the user selection to determine one or more material conditions associated with the one or more conditions in the database; the one or more conditions include at least one of an overstock condition for an overstocked material and a shortage condition for a shortage material; 24. The computer-implemented method of claim 23, wherein the one or more user interfaces further include a second output interface, the second output interface configured to display the one or more overstocked or understocked materials as a result of querying the database.

25. the one or more user interfaces further include a second input interface, the second input interface configured to receive one or more user inputs for adjusting the priority of the corresponding materials in the first group; 24. The computer-implemented method of claim 23, further comprising: re-determining whether the corresponding materials in the first group are overstocked or understocked based on the adjusted priorities of the corresponding materials in the first group.

26. the one or more user interfaces further include a third input interface, the third input interface configured to receive one or more user inputs for adjusting demand for the one or more product components; The computer-implemented method includes calculating an adjusted maximum consumption amount 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 amount of the corresponding material in the first group with the available inventory amount of the corresponding material in the first group; 24. The computer-implemented method of claim 23, further comprising redetermining whether there is an overstock or shortage of the corresponding materials in the first group.

27. receiving a material status inquiry command input by a user via the first input interface; 3. The computer-implemented method of claim 2, further comprising: in response to the material status query instruction, obtaining from a data source at least one of remaining quantities, overstock status, shortage status, and shortage quantities for a plurality of materials and a plurality of next-level materials of the plurality of materials that manufacture the one or more product components.

28. A manufacturing control device for one or more products, comprising: Memory and one or more processors; The memory and the one or more processors are connected to each other, and the memory is connected to the one or more processors. receiving a material query command input by a user via a first input interface; retrieving, in response to the material query instruction, data from a data source regarding a plurality of materials for manufacturing one or more product components, the data regarding the plurality of materials including available inventory amounts of the plurality of materials; calculating a maximum consumption amount of the plurality of materials for at least one product component of the one or more product components; and determining whether there is a shortage of one or more materials used to manufacture one or more product components based on a maximum consumption amount of corresponding materials of the plurality of materials and an available inventory amount of corresponding materials of the plurality of materials.

29. A computer program product comprising a computer-readable non-transitory tangible medium having computer-readable instructions thereon, the computer-readable instructions being executable by a processor to cause the processor to receiving a material query command input by a user via a first input interface; retrieving, in response to the material query instruction, data from a data source regarding a plurality of materials for manufacturing one or more product components, the data regarding the plurality of materials including available inventory amounts of the plurality of materials; calculating a maximum consumption amount of the plurality of materials for at least one product component of the one or more product components; and determining whether there is a shortage of one or more materials for manufacturing one or more product components based on a maximum consumption amount of corresponding materials of the plurality of materials and an available inventory amount of corresponding materials of the plurality of materials.

Images