Material neat analysis method, system and related device

Abstract

The embodiment of the invention discloses a material neat analysis method and system and a related device, and is used for the technical field of inventory management. The method comprises the following steps: determining the material quantity of minimum-granularity materials required by a single product when the minimum-granularity materials in a material list of products form the single product; on the basis of the material number of the minimum-granularity materials needed by a single product, the first set number corresponding to the minimum-granularity materials in the material stock is determined; based on the first uniform set number, converting the minimum-granularity materials in the material stock into non-minimum-granularity materials forming the product, and obtaining the converted material stock; based on the converted material inventory and the material information of the formed product, determining a second complete set number in the material inventory; the number of all sets in the material inventory can be accurately determined, and inventory management errors are effectively avoided.

Description

Technical Field

[0001] The embodiments of the present application relate to the technical field of inventory management, and in particular to a complete set analysis method, system and related devices for materials. Background Art

[0002] Currently, the material information (including material identification and corresponding material quantity) recorded in the product's bill of materials (BOM) is often used to perform a complete set analysis on the materials in the material inventory, determine the complete set number of materials in the material inventory, that is, how many products can be matched, and determine the missing materials (shortage) in the material inventory based on the product demand number and the complete set number.

[0003] The bill of materials records the material information of the products and the subordinate material information of the materials in layers. In the commonly used complete set analysis process, the number of materials corresponding to a single product in a certain layer of the bill of materials is used to determine the complete set number corresponding to the material inventory in a certain layer, and the sum of the complete set numbers of all layers is the complete set number of the material inventory. However, during the complete set analysis, the materials in the material inventory may be shared in a certain layer and other layers. The shared materials of other layers are not considered during the complete set analysis, which can easily lead to errors in the determined complete set number and inventory management errors. Summary of the invention

[0004] The embodiments of the present application provide a material complete set analysis method, system and related devices, which can accurately determine the number of complete sets in the material inventory and effectively avoid inventory management errors.

[0005] The present application embodiment provides a complete material analysis method, including:

[0006] Obtaining material information in the material inventory and a bill of materials for the product; wherein the bill of materials records the material information constituting the product and the subordinate material information of the material in a hierarchical manner, and the material information includes the material quantity;

[0007] Determine the material quantity of the minimum granularity material required for a single product when the minimum granularity material in the material list is used to form a single product; the minimum granularity material is a material that does not have a lower-level material in the material list;

[0008] Based on the material quantity of the material with the minimum particle size required for the single product, determine the first complete set number corresponding to the material with the minimum particle size in the material inventory;

[0009] Based on the first complete set number, convert the minimum particle size material in the material inventory into non-minimum particle size materials constituting the product to obtain a converted material inventory;

[0010] Based on the converted material inventory and the material information constituting the product, the second complete set number in the material inventory is determined.

[0011] Furthermore, the determination of the material quantity of the minimum particle size material required for a single product when the minimum particle size material in the bill of materials constitutes a single product includes:

[0012] Convert the material quantity of each layer in the bill of materials into the material quantity corresponding to a single product to obtain a converted bill of materials;

[0013] The sum of the material quantities of the minimum granularity materials in the multiple layers of the converted bill of materials is determined to obtain the material quantity of the minimum granularity materials required for a single product.

[0014] Furthermore, the determining of the first number of sets corresponding to the material with the minimum particle size in the material inventory based on the material quantity of the material with the minimum particle size required for the single product includes:

[0015] Use the material quantity of the minimum particle size material in the material inventory and divide it by the material quantity of the minimum particle size material required for the single product, and take the minimum value of the obtained integer quotient as the first complete set number corresponding to the minimum particle size material in the material inventory.

[0016] Furthermore, based on the first complete set number, the minimum particle size material in the material inventory is converted into non-minimum particle size materials constituting the product to obtain the converted material inventory, including:

[0017] Determine the first material quantity of the non-minimum particle size material recorded in the first layer of the bill of materials, and the second quantity of the minimum particle size material required to form the first material quantity of the non-minimum particle size material in other layers; wherein the first layer of the bill of materials records the material information constituting the product;

[0018] The converted material inventory is obtained by adding the quantity of the non-minimum particle size material in the material inventory to the product of the first material quantity and the first complete set number; and the quantity of the minimum particle size material in the material inventory is subtracted from the product of the second material quantity and the first complete set number to obtain the converted material inventory.

[0019] Further, after determining the second complete set number in the material inventory, it also includes:

[0020] Get the demand number of the product;

[0021] If the demand quantity of the product is less than or equal to the second complete set quantity in the material inventory, it is determined that the demand for the product is met;

[0022] If the demand quantity of the product is greater than the second complete set quantity in the material inventory, the missing materials in the material inventory are determined.

[0023] Furthermore, it is determined that the materials missing from the material inventory include:

[0024] Based on the demand quantity of the product, determine the quantity of materials required in the first layer of the bill of materials; wherein the first layer of the bill of materials records the material information constituting the product;

[0025] Using the material quantity in the material inventory, deduct the material quantity required in the first layer of the bill of materials to obtain the material quantity missing in the first layer of the bill of materials;

[0026] Determine the material quantity of the non-minimum granularity material missing in the first layer of the bill of materials and the material quantity required in the second layer of the bill of materials;

[0027] Using the remaining material quantity in the material inventory after deduction, the material quantity required in the second layer of the material list is deducted, and this is repeated until the material recorded in the material list does not exist in the material inventory, and the missing materials in the material inventory are determined during the deduction process.

[0028] Furthermore, the determining of the material quantity of the non-minimum granularity material missing in the first layer of the bill of materials and the material quantity required in the second layer of the bill of materials includes:

[0029] Determine the number of complete sets of the material inventory that are missing in the first layer of the bill of materials;

[0030] Multiply the number of missing sets by the number of lower-level materials corresponding to the non-minimum granularity materials missing in the material list in the second layer, and obtain the material quantity of the non-minimum granularity materials missing in the first layer of the material list and the material quantity required in the second layer of the material list.

[0031] Furthermore, determining the missing materials in the material inventory during the deduction process includes:

[0032] The undeducted materials and the corresponding undeducted material quantities in the deducted layer are used as the missing materials and the missing material quantities in the material inventory; wherein, the materials deducted from the lower-level materials in the deducted layer belong to the deducted materials.

[0033] The present application also provides a complete material analysis system, including:

[0034] An acquisition unit, used to acquire material information in the material inventory and a bill of materials of a product; wherein the bill of materials records the material information constituting the product and the subordinate material information of the material in a hierarchical manner, and the material information includes the material quantity;

[0035] The first determination unit is used to determine the material quantity of the minimum granularity material required for a single product when the minimum granularity material in the material list constitutes a single product; the minimum granularity material is a material for which there is no subordinate material in the material list;

[0036] A second determining unit is used to determine the first complete set number corresponding to the material with the minimum particle size in the material inventory based on the material quantity of the material with the minimum particle size required for the single product;

[0037] A conversion unit, configured to convert the minimum particle size material in the material inventory into non-minimum particle size materials constituting the product based on the first complete set number, to obtain a converted material inventory;

[0038] The execution unit is used to determine the second complete set number in the material inventory based on the converted material inventory and the material information constituting the product.

[0039] The present application also provides an electronic device, including:

[0040] CPU, memory and input / output interface;

[0041] The memory is a short-term storage memory or a persistent storage memory;

[0042] The central processing unit is configured to communicate with the memory and execute instructions in the memory to perform the above method.

[0043] An embodiment of the present application also provides a computer-readable storage medium, comprising instructions, which, when executed on a computer, enable the computer to execute the method described above.

[0044] The embodiment of the present application also provides a computer program product including instructions or a computer program. When the computer program product is run on a computer, the computer executes the method described above.

[0045] The embodiment of the present application also provides a computer program product including instructions or a computer program. When the computer program product is run on a computer, the computer executes the method described above.

[0046] It can be seen from the above technical solutions that the embodiments of the present application have the following advantages:

[0047] In an embodiment of the present application, material information in a material inventory and a bill of materials for a product are obtained; when the minimum particle size material in the bill of materials of the product constitutes a single product, the material quantity of the minimum particle size material required for a single product is determined; based on the material quantity of the minimum particle size material required for a single product, a first complete set number corresponding to the minimum particle size material in the material inventory is determined; based on the first complete set number, the minimum particle size material in the material inventory is converted into non-minimum particle size material constituting the product to obtain the converted material inventory; based on the converted material inventory and the material information constituting the product, a second complete set number in the material inventory is determined.

[0048] It can be seen that directly using the converted material inventory and the material information of the constituent products to determine the second complete set number in the material inventory can avoid the impact of shared materials in the bill of materials, can accurately determine the complete set number in the material inventory, and effectively avoid inventory management errors. BRIEF DESCRIPTION OF THE DRAWINGS

[0049] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings required for use in the description of the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments recorded in the present application. For ordinary technicians in this field, other drawings can also be obtained based on these drawings.

[0050] Figure 1 A schematic diagram of a system architecture disclosed in an embodiment of the present application;

[0051] Figure 2 A flowchart of a complete set of analysis disclosed in an embodiment of the present application;

[0052] Figure 3 A flowchart of another complete set of analysis disclosed in an embodiment of the present application;

[0053] Figure 4 A flow chart for determining material shortage disclosed in an embodiment of the present application;

[0054] Figure 5 A schematic diagram of the composition of a bill of materials disclosed in an embodiment of the present application;

[0055] Figure 6 A schematic diagram of a bill of materials corresponding to a single product disclosed in an embodiment of the present application;

[0056] Figure 7 A schematic diagram of a bill of materials corresponding to one or more products disclosed in an embodiment of the present application;

[0057] Figure 8 A schematic diagram of a complete analysis system disclosed in an embodiment of the present application;

[0058] Fig. 9 A schematic diagram of an electronic device disclosed in an embodiment of the present application. DETAILED DESCRIPTION

[0059] In order to make the purpose, technical solutions and advantages of the present application clearer, the present application will be further described in detail below in conjunction with the accompanying drawings. The described embodiments should not be regarded as limiting the present application. All other embodiments obtained by ordinary technicians in the field without making creative work are within the scope of protection of this application.

[0060] The terms "first", "second", "third", "fourth", etc. (if any) in the specification and claims and drawings of the present application are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchangeable where appropriate, so that the embodiments described herein can be implemented in an order other than that illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units that are clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0061] In the following description, similar expressions such as "a specific implementation" or "a specific example" are involved, which describe a subset of all possible embodiments, but it is understood that "a specific implementation" or "a specific example" can be the same subset or different subsets of all possible embodiments, and can be combined with each other without conflict. In the following description, the term multiple refers to at least two. The numerical value mentioned in this application reaches a threshold value (if any), which may include the case where the former is greater than the latter in some specific examples.

[0062] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as those commonly understood by those skilled in the art to which this application belongs. The terms used herein are only for the purpose of describing the embodiments of this application and are not intended to limit this application.

[0063] To facilitate understanding and explanation, before further describing the embodiments of the present application in detail, the application scenarios of the present application will be briefly described.

[0064] like Figure 1 As shown, it includes: a complete set analysis device 101 and a material inventory 102. The complete set analysis device 101 can be connected to one or more material inventories 102 to determine the number of complete sets in the material inventory 102 based on the material list of the product, that is, how many products can be matched (the number of component products).

[0065] The bill of materials records the material information of the products and the subordinate material information of the materials in layers. In the commonly used complete set analysis process, the number of materials corresponding to a single product in a certain layer of the bill of materials is used to determine the complete set number corresponding to the material inventory in a certain layer, and the sum of the complete set numbers of all layers is the complete set number of the material inventory. However, during the complete set analysis, the materials in the material inventory may be shared in a certain layer and other layers. The shared materials of other layers are not considered during the complete set analysis, which can easily lead to errors in the determined complete set number and inventory management errors.

[0066] For example, Figure 5 The bill of materials shown includes: product A; materials B and C that constitute the product recorded in the first layer, and the corresponding material quantity of the single product A; the subordinate materials B and D of material C recorded in the second layer, and the corresponding material quantity of the single material C. When the material inventory is: 10B, 4C and 30D. At this time, in the existing complete set analysis process, the corresponding material quantity of each layer in the bill of materials when constituting a single product is taken; it can be obtained that the complete set number of the material inventory in the first layer is: 10B / 1B=10, 4C / 2C=2, taking the minimum value, that is, 2; the complete set number of the material inventory in the second layer is: 8B / 2B=4, 30D / 4D=7, taking the minimum value, that is, 4; the complete set number in the material inventory is 6. However, the common material B of the first layer and the second layer is not taken into account when performing the complete set analysis. In fact, the complete set number in the material inventory is less than 6; that is, the determined complete set number is wrong, resulting in errors in inventory management. Therefore, the embodiment of the present application provides a method for analyzing the completeness of materials, which can accurately determine the number of complete sets in the material inventory and effectively avoid errors in inventory management, such as Figure 2 As shown, the specific steps are as follows:

[0067] 201. Obtain material information in the material inventory and the bill of materials of the product.

[0068] In an embodiment of the present application, a complete analysis device can obtain material information in a material inventory and a bill of materials for a product; wherein corresponding material information can be obtained from the material inventory, which may be a real-time inventory or an estimated available inventory, which is not specifically limited here; the material information includes a material identification (material name or material number, etc.) and the corresponding material quantity.

[0069] The product's bill of materials can be pre-stored in a complete analysis device or obtained through a network connection, which is not limited here; the product's bill of materials records the material information that makes up the product and the subordinate material information of the materials in a hierarchical manner; generally, the first layer in the bill of materials records the material information that makes up the product (i.e., the material information that directly makes up the product), and the second layer in the bill of materials records the subordinate material information that makes up the first layer, and so on.

[0070] 202. Determine the quantity of the material with the minimum particle size required for a single product when the material with the minimum particle size in the bill of materials constitutes a single product.

[0071] After obtaining the bill of materials for a product, you can determine the quantity of the minimum granularity material required for a single product when the minimum granularity material in the bill of materials constitutes a single product. Among them, the minimum granularity material is the material that does not have a lower-level material in the bill of materials; the materials in each layer of the bill of materials are the minimum granularity materials and / or non-minimum granularity materials, and non-minimum granularity materials must have corresponding minimum granularity materials in the subsequent lower-level material layers. Figure 5 In the bill of materials shown, the materials with the smallest particle size are B and D. Only the materials with the smallest particle size can form the product A. At this time, the number of materials with the smallest particle size required for a single product A is: 3B and 4D.

[0072] 203. Based on the material quantity of the minimum particle size material required for a single product, determine the first complete set number corresponding to the minimum particle size material in the material inventory.

[0073] After obtaining the material quantity of the minimum particle size material required for a single product, the first complete set number corresponding to the minimum particle size material in the material inventory is determined based on the material quantity of the minimum particle size material required for a single product. The first complete set number is the number of products that can be composed using only the minimum particle size material in the material inventory.

[0074] Specifically, you can use the material quantity of the smallest particle size material in the material inventory, divided by the material quantity of the smallest particle size material required for a single product, and take the minimum value of the integer quotient obtained as the first set number corresponding to the smallest particle size material in the material inventory. For example, the material inventory is: 10B, 4C and 30D; for Figure 5 In the bill of materials shown, the quantity of materials with the smallest particle size required for a single product A is: 3B and 4D; then 10B / 3B=3, 30D / 4D=7, taking the minimum value 3, the first complete set number corresponding to the material with the smallest particle size in the material inventory is 3.

[0075] 204. Based on the first complete set number, the minimum particle size material in the material inventory is converted into the non-minimum particle size material constituting the product to obtain the converted material inventory.

[0076] After obtaining the first complete set number corresponding to the minimum granularity material in the material inventory, the minimum granularity material in the material inventory can be converted into the non-minimum granularity material that constitutes the product based on the first complete set number to obtain the converted material inventory; that is, the material quantity of the minimum granularity material required for a single product in the material inventory is multiplied by the first complete set number, and based on the corresponding relationship between the subordinate materials corresponding to the non-minimum granularity material in the bill of materials, it is converted into the corresponding non-minimum granularity material. For example, if the material inventory is: 10B, 4C and 30D, it can be converted into the material inventory of: 4B, 10C and 18D.

[0077] 205. Based on the converted material inventory and the material information of the constituent products, determine the second complete set number in the material inventory.

[0078] After obtaining the converted material inventory, the second complete set number in the material inventory can be determined based on the converted material inventory and the material information of the constituent products. That is, the number of materials in the converted material inventory can be divided by the number of materials that constitute the product, and the minimum value can be taken as the second complete set number in the material inventory. For example, the converted material inventory is: 4B, 10C and 18D; Figure 5 The quantity of materials that make up the product in the bill of materials shown is: 1B and 2C; 4B / 1B=4, 10C / 2C=5; it can be obtained that the second complete set number in the material inventory is 4.

[0079] It can be seen that in the embodiments of the present application, material information in the material inventory and the bill of materials of the product are obtained; when the minimum particle size material in the bill of materials of the product constitutes a single product, the material quantity of the minimum particle size material required for a single product is determined; based on the material quantity of the minimum particle size material required for a single product, the first complete set number corresponding to the minimum particle size material in the material inventory is determined; based on the first complete set number, the minimum particle size material in the material inventory is converted into non-minimum particle size material that constitutes the product to obtain the converted material inventory; based on the converted material inventory and the material information that constitutes the product, the second complete set number in the material inventory is determined.

[0080] Directly use the converted material inventory and the material information of the constituent products to determine the second complete set number in the material inventory. The material information of the constituent products is the first layer in the bill of materials. That is, you only need to determine the complete set number corresponding to the first layer of the material inventory to determine the complete set number in the material inventory; there is no need to determine the complete set number corresponding to all layers in the bill of materials. This can avoid the impact of shared materials in the bill of materials, can accurately determine the complete set number in the material inventory, and effectively avoid inventory management errors.

[0081] Further, the process of complete set analysis will be described in detail below, such as Figure 3As shown, the specific steps are as follows:

[0082] 301. Obtain material information in the material inventory and the bill of materials of the product.

[0083] It is understandable that step 301 is similar to the above step 201, and the details are not repeated here.

[0084] 302. Convert the material quantity of each layer in the bill of materials into the material quantity corresponding to a single product, and determine the material quantity of the minimum granularity material required for a single product in the converted bill of materials.

[0085] After obtaining the bill of materials for the product, the material quantity of each layer in the bill of materials can be converted into the material quantity corresponding to a single product, and the material quantity of the minimum granularity material required for a single product can be determined in the converted bill of materials.

[0086] That is, convert the material quantity of each layer in the bill of materials into the material quantity corresponding to a single product to obtain the converted bill of materials; determine the sum of the material quantities of the smallest granularity materials in multiple layers of the converted bill of materials, that is, count the material quantities of the same smallest granularity materials in multiple layers to obtain the material quantity of the smallest granularity materials required for a single product. Figure 5 The bill of materials shown is converted to Figure 6 The bill of materials shown; Figure 6 In the bill of materials shown, the materials that make up a single product A in the first layer are 1B and 2C, and the materials that make up 2C in the second layer are 2B and 4D. At this time, the sum of the material quantities of the smallest particle size materials in multiple layers can be counted, and the material quantity of the smallest particle size material required to obtain a single product A is: 3B and 4D.

[0087] 303. Based on the material quantity of the minimum particle size material required for a single product, determine the first complete set number corresponding to the minimum particle size material in the material inventory.

[0088] It is understandable that step 303 is similar to the above step 203, and the details are not repeated here.

[0089] 304. Based on the first complete set number, the minimum granularity material in the material inventory is converted into the non-minimum granularity material recorded in the first layer of the bill of materials to obtain the converted material inventory.

[0090] After determining the first complete set number corresponding to the minimum granularity material in the material inventory, the minimum granularity material in the material inventory can be converted into the non-minimum granularity material recorded in the first layer of the bill of materials based on the first complete set number to obtain the converted material inventory.

[0091] Specifically, the first material quantity of the non-minimum particle size material recorded in the first layer of the bill of materials and the second quantity of the minimum particle size material required for the non-minimum particle size material to constitute the first material quantity in other layers can be determined; the material quantity of the non-minimum particle size material in the material inventory is added to the product of the first material quantity and the first complete set number; and the material quantity of the minimum particle size material in the material inventory is subtracted from the product of the second material quantity and the first complete set number to obtain the converted material inventory.

[0092] For example, the material inventory is: 10B, 4C and 30D; the first set number corresponding to the material with the smallest particle size in the material inventory is 3; Figure 5 The first material quantity of the non-minimum particle size material recorded in the first layer of the material list shown is 2C, and the second quantity of the minimum particle size material required to form the first material quantity of the non-minimum particle size material is 2B and 4D; at this time, in the material inventory, 4C+3*2C=10C, 10B-3*2B=4B, 30D-3*4D=18D; the converted material inventory is: 4B, 10C and 18D.

[0093] 305. Based on the converted material inventory and the material information of the constituent products, determine the second complete set number in the material inventory.

[0094] After obtaining the converted material inventory, the second complete set number in the material inventory can be determined based on the converted material inventory and the material information of the constituent products. That is, the material quantity in the material inventory is divided by the material quantity in the first layer in the bill of materials, and the minimum value is taken as the second complete set number in the material inventory.

[0095] It can be seen that in the embodiment of the present application, the materials in the material inventory can be converted to the materials in the first layer of the bill of materials. When performing complete set analysis, the number of materials in the material inventory can be directly divided by the number of materials in the first layer to quickly determine the number of complete sets in the material inventory.

[0096] Furthermore, after the second complete set number in the material inventory, it is also possible to: obtain the demand number of the product, such as the demand number of the product based on the order information of the product or through manual input. If the demand number of the product is less than or equal to the second complete set number in the material inventory, it is determined that the materials in the material inventory meet the demand of the product; if the demand number of the product is greater than the second complete set number in the material inventory, it is necessary to determine the missing materials in the material inventory. Among them, if the demand number of the product is greater than the second complete set number in the material inventory, the number of incomplete sets in the material inventory can also be directly counted, that is, the number of product demand minus the second complete set number to obtain the number of incomplete sets.

[0097] It is understandable that when the number of complete sets is wrong, the shortage of material inventory determined based on the number of complete sets will also be wrong, which is not conducive to the utilization of materials in the material inventory; if the number of shortages determined is too large, it will lead to excessive purchases to replenish the shortages, resulting in redundant materials and increasing the risk of material scrapping; if the number of shortages determined is too small, it will lead to insufficient purchases to replenish the shortages, making it difficult to meet the demand for the product; therefore, in the complete set analysis of the embodiment of the present application, by Figure 4 The method shown can accurately determine the shortage of materials in the material inventory. The specific steps are as follows:

[0098] 401. Based on the demand quantity of the product, determine the quantity of materials required in the first layer of the bill of materials.

[0099] In the embodiment of the present application, the quantity of materials required in the first layer of the bill of materials can be determined based on the demand quantity of the product. Figure 7 As shown, when 10 products 10A are needed, the corresponding material quantities required in the first layer in the bill of materials are 10B and 20C; and the lower-level materials corresponding to 20C in the third layer are: 20B and 40D.

[0100] 402. Use the material quantity in the material inventory to deduct the material quantity required in the first layer of the bill of materials to obtain the material quantity missing in the first layer of the bill of materials.

[0101] After determining the quantity of materials required in the first layer of the bill of materials, you can use the quantity of materials in the material inventory to deduct the quantity of materials required in the first layer of the bill of materials to obtain the quantity of materials missing in the first layer of the bill of materials.

[0102] For example, if the materials in the material inventory are: 10B, 4C and 30D, after deducting the inventory, the remaining materials in the material inventory are: 0B, 0C and 30D, and the number of materials missing in the first layer of the bill of materials is 16C.

[0103] 403. Determine the material quantity of non-minimum granularity materials that are missing in the first layer of the bill of materials and the material quantity required in the second layer of the bill of materials.

[0104] If the missing materials in the first layer of the bill of materials include non-minimum granularity materials, determine the material quantity of the non-minimum granularity materials missing in the first layer of the bill of materials and the material quantity required in the second layer of the bill of materials. For example, if the missing material quantity in the first layer of the bill of materials is 16C, the material quantity required for 16C in the second layer of the bill of materials is 16B and 32D.

[0105] Specifically, the number of complete sets of material inventory in the first layer of the bill of materials can be determined to obtain the number of complete sets that are missing in the first layer of the bill of materials; the number of complete sets that are missing is multiplied by the number of subordinate materials corresponding to the non-minimum granularity materials missing in the bill of materials in the second layer to obtain the number of materials of the non-minimum granularity materials missing in the first layer of the bill of materials and the number of materials required in the second layer of the bill of materials. For example, if the material inventory is: 10B, 4C and 30D, the number of complete sets in the first layer of the bill of materials is 2, and the number of product requirements is 10, then the number of complete sets that are missing in the first layer of the bill of materials can be obtained as 8; the number of materials of the non-minimum granularity materials missing in the first layer of the bill of materials and the number of materials required in the second layer of the bill of materials are: 8*2B=16B, 8*4D=32D. It can be understood that by determining the number of materials of the non-minimum granularity materials missing in the first layer of the bill of materials and the number of materials required in the second layer of the bill of materials through the number of complete sets that are missing, it can avoid inaccurate data when there is unit conversion between different layers in the bill of materials.

[0106] 404. Use the remaining material quantity in the material inventory after deduction to deduct the material quantity required in the second layer of the bill of materials.

[0107] Next, you can use the remaining material quantity in the material inventory after deduction to deduct the material quantity required in the second layer of the bill of materials. That is, the remaining materials in the material inventory are: 0B, 0C and 30D, and the material quantity required in the second layer of the bill of materials: 16B and 32D are deducted to determine the missing materials in the second layer of the bill of materials: 16B and 2D.

[0108] 405. Repeat until the materials recorded in the bill of materials do not exist in the material inventory, and determine the missing materials in the material inventory during the deduction process.

[0109] Repeat until the material recorded in the BOM does not exist in the material inventory, and determine the missing materials in the material inventory during the deduction process. That is, if the missing materials in the second layer of the BOM have corresponding lower-level materials in the third layer, continue to use the remaining materials in the material inventory for deduction until the material recorded in the BOM does not exist in the material inventory.

[0110] In the process of deduction, the lack of materials in the material inventory is determined as follows: the undeducted materials and the corresponding undeducted material quantities in the deducted layer are used as the lack of materials and the lack of material quantities in the material inventory; wherein, the materials deducted from the lower-level materials in the deducted layer belong to the deducted materials. Figure 7When the bill of materials is deducted, material B in the first layer is deducted to 0, and material C in the second layer is deducted. There is no undeducted material in the first layer; the undeducted materials in the second layer and the corresponding undeducted material quantities are: 16B and 2D, so it can be determined that the missing materials in the material inventory are 16B and 2D.

[0111] It can be seen that in the embodiment of the present application, the material inventory is deducted layer by layer from the material quantity required in the first layer of the bill of materials until the material inventory does not contain the material recorded in the bill of materials, so that the shortage of material inventory and the shortage quantity can be accurately determined.

[0112] The present application also provides a complete material analysis system, such as Figure 8 As shown, including:

[0113] The acquisition unit 801 is used to acquire material information in the material inventory and a material list of the product; wherein the material list records the material information constituting the product and the subordinate material information of the material in a hierarchical manner, and the material information includes the material quantity;

[0114] The first determining unit 802 is used to determine the material quantity of the minimum granularity material required for a single product when the minimum granularity material in the material list is used to form a single product; the minimum granularity material is a material that does not have a subordinate material in the material list;

[0115] The second determining unit 803 is used to determine the first complete set number corresponding to the material with the minimum particle size in the material inventory based on the material quantity of the material with the minimum particle size required for the single product;

[0116] A conversion unit 804 is used to convert the minimum particle size material in the material inventory into non-minimum particle size materials constituting the product based on the first complete set number, so as to obtain a converted material inventory;

[0117] The execution unit 805 is used to determine the second complete set number in the material inventory based on the converted material inventory and the material information constituting the product.

[0118] Furthermore, the first determining unit 802 is specifically configured to convert the material quantity of each layer in the bill of materials into the material quantity corresponding to a single product to obtain a converted bill of materials;

[0119] The sum of the material quantities of the minimum granularity materials in the multiple layers of the converted bill of materials is determined to obtain the material quantity of the minimum granularity materials required for a single product.

[0120] Furthermore, the second determination unit 803 is specifically used to use the material quantity of the minimum particle size material in the material inventory, divided by the material quantity of the minimum particle size material required for the single product, and take the minimum value of the obtained integer quotient as the first complete set number corresponding to the minimum particle size material in the material inventory.

[0121] Further, the conversion unit 804 is specifically used to determine the first material quantity of the minimum particle size material and the second material quantity of the non-minimum particle size material recorded in the first layer of the bill of materials; wherein the first layer of the bill of materials records the material information constituting the product;

[0122] The material quantity of the material with the minimum particle size in the material inventory is subtracted from the product of the first material quantity and the first complete set number; and the material quantity of the material with non-minimum particle size in the material inventory is added to the product of the second material quantity and the first complete set number to obtain the converted material inventory.

[0123] The present application also provides an electronic device. Fig. 9 The electronic device 900 of the embodiment of the present application may include one or more central processing units (CPU) 901 and a memory 902 , in which one or more application programs or data are stored.

[0124] The memory 902 may be a volatile storage or a persistent storage. The program stored in the memory 902 may include one or more modules, each of which may include a series of instruction operations in the electronic device. Furthermore, the central processor 901 may be configured to communicate with the memory 902 and execute a series of instruction operations in the memory 902 on the electronic device 900.

[0125] The electronic device 900 may also include one or more power supplies 905, one or more wired or wireless network interfaces 904, one or more input and output interfaces 903, and / or one or more operating systems, such as Windows ServerTM, Mac OS XTM, UnixTM, LinuxTM, FreeBSDTM, etc.

[0126] The central processor 901 can execute the operations performed by the aforementioned first aspect or any specific method embodiment of the first aspect, and the details will not be repeated here.

[0127] The present application provides a computer-readable storage medium, comprising instructions, which, when executed on a computer, enable the computer to execute the method described in the first aspect or any specific implementation of the first aspect.

[0128] The present application provides a computer program product comprising instructions or a computer program. When the computer program product is run on a computer, the computer is enabled to execute the method described in the first aspect or any specific implementation of the first aspect.

[0129] It is understandable that in the various embodiments of the present application, the serial number of each step does not mean the order of execution. The execution order of each step should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present application.

[0130] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the systems, devices and units described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.

[0131] In the several embodiments provided in the present application, it should be understood that the disclosed systems, devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be an indirect coupling or communication connection through some interfaces, devices or units, which can be electrical, mechanical or other forms.

[0132] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0133] In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.

[0134] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application is essentially or the part that contributes to the prior art or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including a number of instructions to enable a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present application. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, read-only memory), random access memory (RAM, random access memory), disk or optical disk and other media that can store program code.

Claims

1. A complete material analysis method, characterized in that: include: Obtaining material information in the material inventory and a bill of materials for the product; wherein the bill of materials records the material information constituting the product and the subordinate material information of the material in a hierarchical manner, and the material information includes the material quantity; Determine the material quantity of the minimum granularity material required for a single product when the minimum granularity material in the material list is used to form a single product; the minimum granularity material is a material that does not have a lower-level material in the material list; Based on the material quantity of the material with the minimum particle size required for the single product, determine the first complete set number corresponding to the material with the minimum particle size in the material inventory; Based on the first complete set number, convert the minimum particle size material in the material inventory into non-minimum particle size materials constituting the product to obtain a converted material inventory; Based on the converted material inventory and the material information constituting the product, the second complete set number in the material inventory is determined.

2. The complete analysis method according to claim 1, characterized in that: When determining that the minimum particle size material in the bill of materials constitutes a single product, the material quantity of the minimum particle size material required for a single product includes: Convert the material quantity of each layer in the bill of materials into the material quantity corresponding to a single product to obtain a converted bill of materials; The sum of the material quantities of the minimum granularity materials in the multiple layers of the converted bill of materials is determined to obtain the material quantity of the minimum granularity materials required for a single product.

3. The complete analysis method according to claim 1, characterized in that: The determining, based on the material quantity of the material with the minimum particle size required for the single product, the first complete set number corresponding to the material with the minimum particle size in the material inventory comprises: Use the material quantity of the minimum particle size material in the material inventory and divide it by the material quantity of the minimum particle size material required for the single product, and take the minimum value of the obtained integer quotient as the first complete set number corresponding to the minimum particle size material in the material inventory.

4. The complete analysis method according to claim 1, characterized in that: Based on the first complete set number, converting the minimum particle size material in the material inventory into non-minimum particle size materials constituting the product to obtain the converted material inventory includes: Determine the first material quantity of the non-minimum particle size material recorded in the first layer of the bill of materials, and the second quantity of the minimum particle size material required to form the first material quantity of the non-minimum particle size material in other layers; wherein the first layer of the bill of materials records the material information constituting the product; The converted material inventory is obtained by adding the quantity of the non-minimum particle size material in the material inventory to the product of the first material quantity and the first complete set number; and the quantity of the minimum particle size material in the material inventory is subtracted from the product of the second material quantity and the first complete set number to obtain the converted material inventory.

5. The complete analysis method according to claim 1, characterized in that: After determining the second complete set number in the material inventory, it also includes: Get the demand number of the product; If the demand quantity of the product is less than or equal to the second complete set quantity in the material inventory, it is determined that the demand for the product is met; If the demand quantity of the product is greater than the second complete set quantity in the material inventory, the missing materials in the material inventory are determined.

6. The complete analysis method according to claim 5, characterized in that: The materials that are missing from the material inventory are determined to include: Based on the demand quantity of the product, determine the quantity of materials required in the first layer of the bill of materials; wherein the first layer of the bill of materials records the material information constituting the product; Using the material quantity in the material inventory, deduct the material quantity required in the first layer of the bill of materials to obtain the material quantity missing in the first layer of the bill of materials; Determine the material quantity of the non-minimum granularity material missing in the first layer of the bill of materials and the material quantity required in the second layer of the bill of materials; Using the remaining material quantity in the material inventory after deduction, the material quantity required in the second layer of the material list is deducted, and this is repeated until the material recorded in the material list does not exist in the material inventory, and the missing materials in the material inventory are determined during the deduction process.

7. The complete analysis method according to claim 6, characterized in that: The step of determining the quantity of non-minimum granularity materials missing in the first layer of the bill of materials and the quantity of materials required in the second layer of the bill of materials includes: Determine the number of complete sets of the material inventory in the first layer of the bill of materials, and obtain the number of complete sets of the material inventory missing in the first layer of the bill of materials; Multiply the number of missing sets by the number of lower-level materials corresponding to the non-minimum granularity materials missing in the material list in the second layer, and obtain the material quantity of the non-minimum granularity materials missing in the first layer of the material list and the material quantity required in the second layer of the material list.

8. The complete analysis method according to claim 6, characterized in that: The materials missing from the material inventory determined during the deduction process include: The undeducted materials and the corresponding undeducted material quantities in the deducted layer are used as the missing materials and the missing material quantities in the material inventory; wherein, the materials deducted from the lower-level materials in the deducted layer belong to the deducted materials.

9. A complete material analysis system, characterized in that: include: An acquisition unit, used to acquire material information in the material inventory and a bill of materials of a product; wherein the bill of materials records the material information constituting the product and the subordinate material information of the material in a hierarchical manner, and the material information includes the material quantity; The first determination unit is used to determine the material quantity of the minimum granularity material required for a single product when the minimum granularity material in the material list constitutes a single product; the minimum granularity material is a material for which there is no subordinate material in the material list; A second determining unit is used to determine the first complete set number corresponding to the material with the minimum particle size in the material inventory based on the material quantity of the material with the minimum particle size required for the single product; A conversion unit, configured to convert the minimum particle size material in the material inventory into non-minimum particle size materials constituting the product based on the first complete set number, to obtain a converted material inventory; The execution unit is used to determine the second complete set number in the material inventory based on the converted material inventory and the material information constituting the product.

10. An electronic device, characterized in that: include: CPU, memory and input / output interface; The memory is a short-term storage memory or a persistent storage memory; The central processing unit is configured to communicate with the memory and execute instructions in the memory to perform the method according to any one of claims 1 to 7.

11. A computer-readable storage medium, characterized in that: The method comprises instructions, which, when executed on a computer, cause the computer to execute the method according to any one of claims 1 to 7.

12. A computer program product comprising instructions or a computer program, characterized in that When the computer program product is run on a computer, the computer is caused to execute the method according to any one of claims 1 to 7.

Images