Material demand planning method and device, electronic equipment and storage medium

Abstract

The invention discloses a material demand planning method and device, electronic equipment and a storage medium, and relates to the technical field of logistics transportation. The method comprises the following steps: acquiring description information and material demand information of at least one material forming a target product; the material demand information comprises the demand quantity of each material and corresponding supplier information and is used for indicating candidate suppliers for supplying the materials. And according to the material inventory information and the material demand information corresponding to the candidate suppliers, determining whether the material inventory of the candidate suppliers can meet the material demand of the target product. If not, a material purchasing plan for the target product is generated based on a preset model according to the description information of the at least one material and the material demand information, and the plan comprises the number of materials purchased from the candidate suppliers. Therefore, under the scene that the customer orders the product and appoints the supplier, the pre-constructed model can be utilized to automatically realize the material demand plan, the labor cost can be saved, and the efficiency can be improved.

Description

Technical Field

[0001] The present application relates to the field of logistics and transportation technology, and in particular to a material requirement planning method, device, electronic equipment and storage medium. Background Art

[0002] Material requirement planning (MRP) is a material planning method within industrial manufacturing enterprises. Specifically, MRP refers to a practical technology that formulates a product production plan based on market demand forecasts and customer orders, and then forms a material structure table and inventory status based on the product production plan, calculates the required material demand and demand time through computers, and thus determines the material processing progress and ordering schedule.

[0003] However, this calculation method has limitations in practical application. Especially when the customer specifies the supplier, the existing material planning method can only calculate the total demand for materials but cannot allocate them to suppliers. This causes planners to spend a lot of time matching suppliers to meet customer needs. As a result, this calculation method has high labor costs and low efficiency. Summary of the invention

[0004] The embodiments of the present application provide a material requirement planning method, device, electronic device and storage medium to solve the problem of high labor cost and low efficiency of existing material requirement planning methods in a scenario where the customer specifies the supplier.

[0005] On the one hand, an embodiment of the present application provides a material requirement planning method, including:

[0006] Obtaining description information and material demand information of at least one material constituting a target product, wherein the material demand information includes the demand quantity, demand time and corresponding supplier information of each material, and the supplier information is used to indicate candidate suppliers for supplying the material;

[0007] Determine whether the material inventory of the candidate supplier can meet the material demand of the target product based on the material inventory information and material demand information corresponding to the candidate supplier;

[0008] When the material inventory corresponding to the candidate suppliers cannot meet the material requirements of the target product, a material procurement plan for the target product is generated based on the preset model according to the description information and material requirement information of at least one material, wherein the material procurement plan includes the quantity of materials purchased from the candidate suppliers corresponding to each material.

[0009] On the one hand, an embodiment of the present application provides a material requirement planning device, including:

[0010] An acquisition module, used to acquire description information and material demand information of at least one material constituting a target product, wherein the material demand information includes the required quantity of each material and corresponding supplier information, and the supplier information is used to indicate at least one candidate supplier for supplying the material;

[0011] A determination module is used to determine whether the material inventory of the candidate supplier can meet the material demand of the target product based on the material inventory information and material demand information corresponding to the candidate supplier;

[0012] A generation module is used to generate a material procurement plan for the target product based on a preset model and according to the description information and material requirement information of at least one material when the material inventory corresponding to the candidate supplier cannot meet the material requirement of the target product, wherein the material procurement plan includes the quantity of materials purchased from at least one candidate supplier.

[0013] In a possible embodiment, the acquisition module is used to:

[0014] Obtaining the user's order data, which includes the target product's ID, the target product's required quantity, and supplier information;

[0015] Based on the identification of the target product, determining at least one material constituting the target product and description information of the at least one material;

[0016] Determine the required quantity of at least one material according to the required quantity of the target product; and

[0017] The material demand information is obtained by combining the demand quantity and supplier information of at least one material.

[0018] In a possible embodiment, the description information of at least one material includes at least one of the material's identification, function, category, or category description information; and / or, the material demand information also includes at least one of the following: demand time, a threshold number of candidate suppliers corresponding to each material, or historical supplier information that supplies materials to the user.

[0019] In a possible embodiment, the device further includes a building module, which is used to:

[0020] A preset model is constructed based on the description information and material requirement information of at least one material, and the preset model corresponds to constraints and model objectives; wherein the model objective indicates minimizing the material procurement cost and / or the fastest procurement time, and the constraints indicate satisfying the material requirement information.

[0021] In a possible embodiment, the model objective of the preset model indicates minimizing the material procurement cost; the constraint conditions of the preset model include a first constraint condition and a second constraint condition, wherein the first constraint condition indicates purchasing materials from candidate suppliers indicated by the logistics demand information, and the second constraint condition indicates that the number of candidate suppliers for purchasing materials is not greater than a quantity threshold indicated by the logistics demand information.

[0022] In a possible embodiment, the model objective satisfies the following objective function:

[0023]

[0024] Where I represents the set of material types;

[0025] J represents the set of candidate suppliers;

[0026] K represents the set of demand orders;

[0027] c ij represents the unit cost of purchasing material i from supplier j;

[0028] x ijk represents the quantity of material i purchased from candidate supplier j for order k;

[0029] The first constraint satisfies the following formula:

[0030]

[0031] Among them, d ik Indicates the demand quantity of material i for demand order k;

[0032] x ijk represents the quantity of material i purchased from candidate supplier j for order k;

[0033] j∈Range ik represents the set of candidate suppliers acceptable to order k for material i;

[0034] And the second constraint satisfies the following formula:

[0035]

[0036] Among them, y jk is a binary variable. If order k purchases at least one material from candidate supplier j, then y jk The value of y is 1, otherwise jk The value of is 0;

[0037] MaxSuppliers k Indicates the number threshold of candidate suppliers that can be selected for order k.

[0038] In a possible embodiment, a generating module is used to:

[0039] When the material inventory corresponding to the candidate supplier cannot meet the material demand of the target product, the procurement demand information of the target product is determined based on the material inventory and logistics demand information corresponding to the candidate supplier; and based on the preset model, according to the description information and procurement demand information of at least one material, a material procurement plan for the target product is obtained.

[0040] On the one hand, an embodiment of the present application provides an electronic device, which includes a processor and a memory, wherein the memory stores program code, and when the program code is executed by the processor, the processor executes any one of the above-mentioned material requirement planning methods.

[0041] On the one hand, the present application provides a computer-readable storage medium, which includes a program code. When the storage medium is run on an electronic device, the program code is used to enable the electronic device to execute any of the above-mentioned material requirement planning methods.

[0042] On the one hand, an embodiment of the present application provides a computer program product, which includes computer instructions, and the computer instructions are stored in a computer-readable storage medium; when a processor of an electronic device reads the computer instructions from the computer-readable storage medium, the processor executes the computer instructions, so that the electronic device executes any one of the above-mentioned material requirement planning methods.

[0043] The beneficial effects of this application are as follows:

[0044] The embodiments of the present application provide a material requirement planning method, device, electronic device and storage medium. Among them, the material requirement planning method includes: obtaining description information and material requirement information of at least one material constituting a target product. Among them, the material requirement information includes the required quantity, demand time and corresponding supplier information of each material, and the supplier information is used to indicate the candidate supplier of the material. Further, based on the material inventory information and material requirement information corresponding to the candidate supplier, determine whether the material inventory of the candidate supplier can meet the material requirements of the target product. In the case that the material inventory corresponding to the candidate supplier cannot meet the material requirements of the target product, based on the preset model, a material procurement plan for the target product is generated according to the description information and material requirement information of at least one material, wherein the material procurement plan includes the quantity of materials purchased from the candidate suppliers corresponding to each material.

[0045] In this way, in the scenario where a customer orders a product and specifies a supplier, the pre-built model can be used to automatically generate a material procurement plan based on the customer's material requirements, which can save labor costs and improve efficiency.

[0046] Other features and advantages of the present application will be described in the following description, and partly become apparent from the description, or understood by practicing the present application. The purpose and other advantages of the present application can be realized and obtained by the structures specifically pointed out in the written description, claims, and drawings. BRIEF DESCRIPTION OF THE DRAWINGS

[0047] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the related technologies, the drawings required for use in the embodiments or the related technical descriptions are briefly introduced below. Obviously, the drawings described below are only the embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on the provided drawings without paying any creative work.

[0048] Figure 1 This is a schematic diagram of the product structure of product F;

[0049] Figure 2 A schematic diagram of an application scenario of an embodiment of the present application;

[0050] Figure 3 This is a flow chart for implementing a material requirement planning method in an embodiment of the present application;

[0051] Figure 4 This is a flow chart of a material requirement planning method applied in a scenario in an embodiment of the present application;

[0052] Figure 5 This is a schematic diagram of the structure of a material requirement planning device in an embodiment of the present application;

[0053] Figure 6 A schematic diagram of the hardware structure of an electronic device in an embodiment of the present application. DETAILED DESCRIPTION

[0054] In order to make the purpose, technical scheme and advantages of the present application clearer, the technical scheme in the embodiment of the present application will be clearly and completely described below in conjunction with the drawings in the embodiment of the present application. Obviously, the described embodiment is only a part of the embodiment of the present application, rather than all the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in the field without making creative work are within the scope of protection of the present application. In the absence of conflict, the embodiments in the present application and the features in the embodiments can be arbitrarily combined with each other. In addition, although the logical order is shown in the flow chart, in some cases, the steps shown or described can be performed in an order different from that here.

[0055] The terms "first", "second", etc. in the specification and claims of the present application and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the terms used in this way can be interchanged where appropriate, so that the embodiments of the present application described herein can be implemented in an order other than those illustrated or described herein.

[0056] The following is a brief introduction to the design concept of the embodiment of the present application:

[0057] The current material requirement planning method usually plans materials for lower-level semi-finished products and raw materials based on customer demand or demand forecast, combined with the product's bill of material (BOM) and inventory status. For example, assuming that a customer orders a quantity of M for product F (also called finished product in this embodiment), the material requirement planning method will calculate the planned quantity of each material according to the customer's order quantity, F's product structure and material inventory status.

[0058] Specifically, refer to Figure 1 It is a schematic diagram of the product structure of the finished product F. The lower structure constituting the finished product F includes H1 with a quantity of 1, H2 with a quantity of 2, and H3 with a quantity of 1. Further, 1 H1 includes material R1 with a quantity of 1, material R2 with a quantity of 2, and material R3 with a quantity of 2. 1 H2 includes material R4 with a quantity of 2, and 1 H3 includes material R5 with a quantity of 2 and material R6 with a quantity of 1. Using the current material requirement planning method, first expand downward according to the demand quantity of the finished product F, that is, calculate the demand quantity of H1, H2, and H3 in combination with the unit usage of the lower layer H1, H2, and H3, and obtain the corresponding planned quantity after deducting the inventory of H1, H2, and H3. Then, expand downward with the planned quantity of H1, H2, and H3, and calculate the demand for the underlying material (in the embodiment of the present application, the material may also be referred to as material or raw material) in combination with the unit usage and inventory of the corresponding materials (for example, R1, R2, R3, R4, R5, and R6).

[0059] Referring to Table 1, taking the customer's order demand for product F as 10 as an example, the demand for each material constituting product F is obtained using the existing material requirement planning method.

[0060] Table 1

[0061]

[0062] It can be seen that the existing material requirement planning method can only calculate the material demand plan in the form of demand + product structure + inventory, and cannot consider the scenario where the demand side specifies the supplier for the lower-level materials. In other words, the current material requirement planning method is designed based on the category, quantity and product structure of the required products. These data do not take into account the factor of the material supplier, so when calculating the material requirement plan, it is impossible to obtain the information of the specified supplier from the source of demand (customer order or forecast).

[0063] In addition, the current product structure is universal data. All identical products will reference the same product structure, and it is not possible to add the supplier attribute based on customer needs. Moreover, the supplier-specified information may be a complex combination of multiple information rather than a single supplier designation. For example, if a user specifies multiple suppliers and limits the quantity threshold of selectable suppliers, the supplier-specified information is a combination of multiple supplier information and quantity thresholds. In summary, the current material requirement planning method cannot calculate the material requirement plan in a scenario where the customer specifies the supplier that supplies the product. Instead, manual calculation is required, which has high labor costs and low efficiency.

[0064] In view of this, an embodiment of the present application provides a material requirement planning method, device, electronic device and storage medium. The material requirement planning method includes: obtaining descriptive information and material requirement information of at least one material constituting a target product. The material requirement information includes the required quantity of each material and the corresponding supplier information, and the supplier information is used to indicate the candidate supplier of the material. Further, based on the material inventory information and material requirement information corresponding to the candidate supplier, determine whether the material inventory of the candidate supplier can meet the material requirements of the target product. In the case that the material inventory corresponding to the candidate supplier cannot meet the material requirements of the target product, based on a preset model, a material procurement plan for the target product is generated according to the descriptive information and material requirement information of at least one material, wherein the material procurement plan includes the quantity of materials purchased from the candidate suppliers corresponding to each material.

[0065] In this way, in the scenario where the customer specifies a supplier, the pre-built model can be used to automatically generate a material procurement plan based on the customer's material requirements, which can save labor costs and improve efficiency.

[0066] The preferred embodiments of the present application are described below in conjunction with the drawings in the specification. It should be understood that the preferred embodiments described herein are only used to illustrate and explain the present application, and are not used to limit the present application. In addition, the embodiments and features in the embodiments of the present application may be combined with each other if there is no conflict.

[0067] like Figure 2, which is a schematic diagram of an application scenario provided by an embodiment of the present application. In the schematic diagram of the application scenario, a terminal device 201 and a server 202 are included. The terminal device 201 and the server 202 communicate with each other through a communication network.

[0068] The terminal device 201 is an electronic device used by the target object, and the electronic device may be a personal computer, a mobile phone, a tablet computer, a notebook, an e-book reader, a vehicle-mounted terminal, etc. In addition, a client related to material requirement planning may be installed on the terminal device 201, and the client may be a software (e.g., an APP, a browser, etc.), or a web page, a small program, etc. The target object may use the above-mentioned client related to material requirement planning through the terminal device 201 to perform material requirement planning related operations.

[0069] Server 202 can be an independent physical server or an edge device 202 in the field of cloud computing. It can also be a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud storage, cloud functions, network services, cloud communications, middleware services, domain name services, security services, content delivery networks (English name: Content Delivery Network, abbreviated as CDN), as well as big data and artificial intelligence platforms.

[0070] There is no restriction on the number of the terminal devices 201 and / or servers 202 .

[0071] It should be noted that the material requirement planning method in the embodiment of the present application can be executed by the terminal device 201 or the server 202 alone, or can be executed by the terminal device 201 and the server 202 together. For example, when the terminal device 201 and the server 202 are executed together, the server 202 obtains the description information and material requirement information of at least one material constituting the target product. Among them, the material requirement information includes the required quantity, the required time and the corresponding supplier information of each material, and the supplier information is used to indicate the candidate supplier of the supply material. Then, the server 202 determines whether the material inventory of the candidate supplier can meet the material demand of the target product according to the material inventory information and material requirement information corresponding to the candidate supplier. In the case that the material inventory corresponding to the candidate supplier cannot meet the material demand of the target product, based on the preset model, a material procurement plan for the target product is generated according to the description information and material requirement information of at least one material, wherein the material procurement plan includes the quantity of materials purchased from the candidate suppliers corresponding to each material. The terminal device 201 can present the material procurement plan data to the target object so that the target object purchases materials according to the material procurement plan.

[0072] The material requirement planning method provided by the exemplary embodiment of the present application is described below in combination with the above-mentioned application scenarios with reference to the accompanying drawings. It should be noted that the above-mentioned application scenarios are only shown to facilitate understanding of the spirit and principles of the present application, and the implementation methods of the present application are not limited in this regard.

[0073] refer to Figure 3 , is an implementation flow chart of a material requirement planning method provided in an embodiment of the present application. Here, the server is used as the execution subject for introduction. The specific implementation process of the method is as follows:

[0074] S301, obtaining description information and material requirement information of at least one material constituting a target product.

[0075] In the embodiments of the present application, the target product may be a finished product or a semi-finished product, and the material constituting the target product may be obtained by decomposing the structure of the target product. The material here may be a material of a lower layer constituting the target product after the component structure of the target product is unfolded. In some embodiments, the material may be determined according to actual needs, depending on the level of decomposition, and may be a component or raw material constituting the product. For example, the material may be the material of layer A after the target product is decomposed, or it may be the material of layer B after the A-layer product structure is further decomposed. For example, for the product F mentioned above, the material in the embodiments of the present application may refer to H1, H2 and H3, or may refer to R1, R2, R3, R4, R5 and R6.

[0076] In an embodiment of the present application, the description information of the material includes at least one of the identification, function, category or category description information of the material. For example, the material identification can be a material code, for example, the material code of R1 is R102001. The function of the material indicates the role, for example, the function of the R2 material can be described as "a component that makes up AAA". For the same material, the material codes of the same material provided by different manufacturers are different. Therefore, in the scenario where the manufacturer is clearly defined, the material code is also clarified. In some scenarios, when a specific manufacturer is not clearly specified, one or more materials that meet this function can also be indicated by indicating the function of the material. The category of the material can be indicated by the category code, and the category description information can describe the function of this category. For example, the category code of the R1 material is 3001, and the corresponding category description is "bearings".

[0077] In an embodiment of the present application, the material demand information includes the demand quantity, demand time and corresponding supplier information of each material. In some embodiments, the demand quantity of the material is obtained based on the quantitative relationship between the target product and the materials constituting the target product. Still referring to the example of Table 1, for product F, if the demand quantity of product F is 1, after expanding the product structure of product F, the corresponding demands of H1, H2, and H3 can be obtained as 10 respectively, and so on, the demands of R1 to R6 can be obtained respectively. In an embodiment of the present application, the supplier information is used to indicate the candidate suppliers of the supplied materials. The candidate suppliers corresponding to different materials may be the same or different. For example, the candidate suppliers corresponding to material R1 include S1 to S3, and the candidate suppliers corresponding to material R2 include S3, S4 and S5. The candidate suppliers can be determined according to the instructions of the customer order.

[0078] In some embodiments, the material demand information also includes at least one of the following: demand time, a threshold number of candidate suppliers corresponding to each material, or historical supplier information that supplies materials to the user. In some embodiments, the threshold number of candidate suppliers corresponding to each material is used to limit the number of candidate suppliers. For example, the number of candidate suppliers can be limited to no more than the threshold number. In some embodiments, the historical supplier information can indicate the historical supplier that has supplied a certain material. For customer orders of different customers, for the same material, the corresponding candidate suppliers may be different. For example, for customer 1, the supplier that has supplied material R1 to it is S1, and for customer 2, the supplier that has supplied material R1 to it is S3. Of course, for the same customer, for different materials, the corresponding candidate suppliers may also be different. For example, for customer 1, the supplier that has supplied material R1 to it is S1, and the supplier that has supplied material R2 to it is S2. In some embodiments, the historical supplier information and the threshold number of candidate suppliers are mainly used to determine the final supplier from the candidate suppliers (the final supplier can also be referred to as the target supplier). For example, in one scenario, the user's customer order provides 5 candidate suppliers S1~S5 to supply material R1, the number threshold of candidate suppliers is 3, and the historical suppliers include S1 and S2. Considering the production and after-sales situation of material R1, it is not recommended to have the same supplier supply material R1 in a short period of time, so S3~S5 can be selected as the final selected supplier. For another example, in one scenario, the user's customer order provides 5 candidate suppliers S1~S5 to supply material R1, the number threshold of candidate suppliers is 3, and the historical suppliers include S1 and S2, so S1 and S2 can be selected as the selected candidate suppliers.

[0079] In some embodiments, the material planning method provided in the embodiments of the present application can be executed in a scenario where the supply side needs to take inventory of replenished materials or make an estimate of the demand for products. In some embodiments, the material planning method provided in the embodiments of the present application can be executed in a scenario where the demand side initiates a purchase demand (for example, receiving a purchase order from a customer). For this scenario, the description information and material demand information of at least one material can be obtained after processing the customer's order data and product structure data.

[0080] As an implementation method, the user's order data can be obtained, and the order data includes the identification of the target product, the required quantity of the target product, and the supplier information. In some embodiments, the order data obtained can be for a certain user, multiple order data of the user within a period of time, or multiple order data of multiple users, which is not limited in the embodiments of the present application. In some embodiments, the order data may also include amount data, etc. Then, based on the identification of the target product, at least one material constituting the target product and the description information of at least one material are determined. It can be understood that this step of deconstructing the target product can also be performed before the user's order data is obtained. That is, there is no specific execution order between these two steps. Further, the required quantity of at least one material can be determined according to the required quantity of the target product; then, the material demand information is obtained by combining the required quantity of at least one material and the supplier information. For example, order data, manufacturer-specified data (in some embodiments, the order data may include manufacturer-specified data), manufacturer code, material code, product structure, inventory quantity and amount data can be obtained. Then, the material demand quantity and demand date, that is, the required quantity and demand date of parts and raw materials are calculated based on the order demand and the product structure.

[0081] In some embodiments, the acquired material description information and material requirement information are processed and stored according to a predefined data structure. This data structure adds attribute values ​​related to "manufacturer information" and is different from the traditional data structure representing the bill of materials. For example, taking the manufacturing industry as an example, an example of a data structure is provided in this embodiment of the application with reference to Table 2.

[0082] Table 2 Data structure

[0083]

[0084]

[0085] The meanings of the attribute values ​​in Table 2 above are as follows:

[0086] Order number: customer sales order. Based on the order data, you can obtain the material, quantity, and date information of the required finished product.

[0087] Material code: The material code of the manufacturer needs to be specified. It is used in scenarios where the manufacturer is accurately specified.

[0088] Material classification: Material classification that requires a manufacturer to be specified, used in scenarios where the manufacturer is fuzzily specified. If the customer does not accurately specify the manufacturer and the material is not accurately coded, it can be maintained by classification, simplifying the difficulty of data maintenance.

[0089] Available Manufacturers: The range of candidate manufacturers to choose from.

[0090] Upper limit of manufacturer selection: manufacturer selection relationship, e.g., out of 5 manufacturers, a maximum of 2 can be selected.

[0091] Historical Manufacturer: Consider historical use of manufacturers to avoid conflicts due to historical use and optional quantities.

[0092] "" means that the value of this attribute is empty.

[0093] S302: Determine whether the material inventory of the candidate supplier can meet the material demand of the target product based on the material inventory information and material demand information corresponding to the candidate supplier.

[0094] In some embodiments, inventory allocation is performed based on the inventory of materials matched by the designated manufacturer to calculate the net demand for materials. If the inventory of materials corresponding to the designated manufacturer is sufficient, the material requirement plan is completed based on the inventory, that is, step S303 is executed. If the inventory of materials corresponding to the candidate supplier cannot meet the material demand of the target product, it is necessary to purchase materials, that is, step S304 is executed.

[0095] S303: Formulate a material requirement plan based on the material inventory information of the candidate suppliers.

[0096] In some embodiments, the required materials are calculated based on the inventory materials corresponding to the candidate supplies.

[0097] S303: Based on a preset model, a material procurement plan for a target product is generated according to description information and material requirement information of at least one material.

[0098] In the embodiment of the present application, the material procurement plan includes the quantity of materials purchased from the candidate suppliers corresponding to each material. The material procurement plan may also include information such as the material procurement date and manufacturer.

[0099] In some embodiments, when the material inventory corresponding to the candidate supplier cannot meet the material demand of the target product, the purchase demand of the target product is determined based on the material inventory and logistics demand information corresponding to the candidate supplier. Then, based on the preset model, according to the description information and purchase demand of at least one material, a material purchase plan for the target product is obtained. In some implementations, inventory allocation can be performed first based on the inventory of materials matched by the specified manufacturer, and the net demand of the material is calculated based on the demand and inventory. The net demand of the material is the quantity of the material that needs to be purchased.

[0100] In some embodiments, the preset model can be constructed based on the description information and material demand information of at least one material, and the preset model corresponds to constraints and model objectives. The model objective indicates minimizing the material procurement cost and / or maximizing the procurement time, and the constraints indicate satisfying the material demand information.

[0101] In some embodiments, minimizing the material procurement cost is used as a model objective of the preset model. The constraints of the preset model include a first constraint and a second constraint. The first constraint indicates that the material is purchased from the candidate suppliers indicated by the logistics demand information, and the second constraint indicates that the number of candidate suppliers for purchasing the material is not greater than the quantity threshold indicated by the logistics demand information.

[0102] As an example, the model objective satisfies the following objective function:

[0103]

[0104] Among them, i represents any type of material, and I represents a collection of material types;

[0105] j represents any candidate supplier, and J represents the set of candidate suppliers;

[0106] k represents any order, K represents a set of orders;

[0107] c ij represents the unit cost of purchasing material i from supplier j;

[0108] x ijk represents the quantity of material i purchased from candidate supplier j for order k;

[0109] In this example, the first constraint satisfies the following formula:

[0110]

[0111] Among them, d ik Indicates the demand quantity of material i for demand order k;

[0112] x ijkrepresents the quantity of material i purchased from candidate supplier j for order k;

[0113] j∈Range ik represents the set of candidate suppliers acceptable to order k for material i;

[0114] And the second constraint satisfies the following formula:

[0115]

[0116] Among them, y jk is a binary variable. If order k purchases at least one material from candidate supplier j, then y jk The value of y is 1, otherwise jk The value of is 0;

[0117] MaxSuppliers k Indicates the number threshold of candidate suppliers that can be selected for order k.

[0118] Therefore, for scenarios where a manufacturer is specified, purchasing materials at the lowest cost can save economic costs while meeting the customer's order requirements.

[0119] The material requirement planning method provided in the embodiment of the present application first obtains the description information and material requirement information of at least one material constituting the target product. Among them, the material requirement information includes the required quantity, the required time and the corresponding supplier information of each material, and the supplier information is used to indicate the candidate supplier of the supply material. Further, according to the material inventory information and material requirement information corresponding to the candidate supplier, it is determined whether the material inventory of the candidate supplier can meet the material demand of the target product. In the case where the material inventory corresponding to the candidate supplier cannot meet the material demand of the target product, based on the preset model, a material procurement plan for the target product is generated according to the description information and material requirement information of at least one material, wherein the material procurement plan includes the quantity of materials purchased from the candidate supplier corresponding to each material. In this way, in the scenario where the customer specifies the supplier, the pre-built model can be used to automatically generate the material procurement plan according to the customer's material demand, which can save labor costs and improve efficiency. This application can greatly improve the efficiency of planners. In manufacturing enterprises, there are a large number of orders involving a large number of parts specified by manufacturers, and the model can quickly make decisions to select relatively better results from many combinations.

[0120] In order to better explain the method of the embodiment of the present application, refer to Figure 4 , which is a flow chart of a specific application of the material planning method of an embodiment of the present application.

[0121] refer to Figure 4, the process includes the following steps:

[0122] S401. Establish product structure, including all materials (parts, raw materials) required to make up the product and the quantity of each material.

[0123] S402. Maintain sales order data from customers (including data of designated manufacturers).

[0124] S403. Calculate the required quantity and time of all materials according to the sales order.

[0125] S404: Check whether the specified manufacturer matches the manufacturer of the stocked material. If they match, go to step S405. If they do not match, go to step S407.

[0126] S405. Based on the demand for the material, deduct the inventory of the material corresponding to the specified manufacturer.

[0127] S406. Check whether the material inventory corresponding to the designated manufacturer meets the material demand.

[0128] If not, execute step S407; if satisfied, end the process.

[0129] S407. Based on the pre-built model, with the goal of minimizing procurement costs, decide the quantity of materials that need to be purchased from the specified manufacturer.

[0130] Based on the same inventive concept, the present application embodiment also provides a material requirement planning device. Figure 5 As shown, it is a schematic diagram of the structure of the material requirement planning device 500, which may include:

[0131] The acquisition module 501 is used to acquire description information and material requirement information of at least one material constituting the target product. The material requirement information includes the required quantity of each material and the corresponding supplier information. The supplier information is used to indicate at least one candidate supplier of the material.

[0132] The determination module 502 is used to determine whether the material inventory of the candidate supplier can meet the material demand of the target product based on the material inventory information and material demand information corresponding to the candidate supplier.

[0133] Generation module 503 is used to generate a material procurement plan for the target product based on a preset model and according to the description information and material requirement information of at least one material when the material inventory corresponding to the candidate supplier cannot meet the material requirement of the target product, wherein the material procurement plan includes the quantity of materials purchased from at least one candidate supplier.

[0134] In a possible embodiment, the acquisition module 501 is used to: acquire the user's order data, the order data including the identification of the target product, the required quantity of the target product, and the supplier information; determine at least one material constituting the target product and the description information of the at least one material based on the identification of the target product; determine the required quantity of at least one material according to the required quantity of the target product; and obtain material demand information by combining the required quantity of at least one material and the supplier information.

[0135] In a possible embodiment, the description information of at least one material includes at least one of the material's identification, function, category, or category description information; and / or, the material demand information also includes at least one of the following: demand time, a threshold number of candidate suppliers corresponding to each material, or historical supplier information that supplies materials to the user.

[0136] In a possible embodiment, the device also includes a construction module, which is used to: construct a preset model based on the description information and material requirement information of at least one material, and the preset model corresponds to constraints and model objectives; wherein the model objectives indicate minimizing the material procurement cost and / or the fastest procurement time, and the constraints indicate satisfying the material requirement information.

[0137] In a possible embodiment, the model objective of the preset model indicates minimizing the material procurement cost; the constraint conditions of the preset model include a first constraint condition and a second constraint condition, wherein the first constraint condition indicates purchasing materials from candidate suppliers indicated by the logistics demand information, and the second constraint condition indicates that the number of candidate suppliers for purchasing materials is not greater than a quantity threshold indicated by the logistics demand information.

[0138] In a possible embodiment, the model objective satisfies the following objective function:

[0139]

[0140] Where I represents the set of material types;

[0141] J represents the set of candidate suppliers;

[0142] K represents the set of demand orders;

[0143] c ij represents the unit cost of purchasing material i from supplier j;

[0144] x ijk represents the quantity of material i purchased from candidate supplier j for order k;

[0145] The first constraint satisfies the following formula:

[0146]

[0147] Among them, d ik Indicates the demand quantity of material i for demand order k;

[0148] x ijk represents the quantity of material i purchased from candidate supplier j for order k;

[0149] j∈Range ik represents the set of candidate suppliers acceptable to order k for material i;

[0150] And the second constraint satisfies the following formula:

[0151]

[0152] Among them, y jk is a binary variable. If order k purchases at least one material from candidate supplier j, then y jk The value of y is 1, otherwise jk The value of is 0;

[0153] MaxSuppliers k Indicates the number threshold of candidate suppliers that can be selected for order k.

[0154] In a possible embodiment, generation module 503 is used to determine the procurement demand information of the target product based on the material inventory and logistics demand information corresponding to the candidate supplier when the material inventory corresponding to the candidate supplier cannot meet the material demand of the target product; and based on a preset model, obtain a material procurement plan for the target product based on the description information and procurement demand information of at least one material.

[0155] The material requirement planning device provided in the embodiment of the present application first obtains the description information and material requirement information of at least one material constituting the target product. Among them, the material requirement information includes the required quantity, the required time and the corresponding supplier information of each material, and the supplier information is used to indicate the candidate supplier of the material. Further, according to the material inventory information and material requirement information corresponding to the candidate supplier, it is determined whether the material inventory of the candidate supplier can meet the material requirements of the target product. In the case where the material inventory corresponding to the candidate supplier cannot meet the material requirements of the target product, based on the preset model, a material procurement plan for the target product is generated according to the description information and material requirement information of at least one material, wherein the material procurement plan includes the quantity of materials purchased from the candidate suppliers corresponding to each material. In this way, in the scenario where the customer orders a product and specifies a supplier, the pre-built model can be used to automatically generate a material procurement plan according to the customer's material requirements, which can save labor costs and improve efficiency.

[0156] In some possible implementations, the material requirement planning device according to the present application may include at least a processor and a memory. The memory stores program code, and when the program code is executed by the processor, the processor executes the steps of the material requirement planning method according to various exemplary embodiments of the present application described in this specification. For example, the processor may execute the following steps: Figure 3 or Figure 4 Follow the steps shown in .

[0157] Based on the same inventive concept, an electronic device is also provided in the embodiment of the present application, and the electronic device can realize the functions of the aforementioned material requirement planning method and device, referring to Figure 5 , the electronic device comprises:

[0158] At least one processor 601, and a memory 602 connected to the at least one processor 601. The specific connection medium between the processor 601 and the memory 602 is not limited in the embodiment of the present application. Figure 5 In the example, the processor 601 and the memory 602 are connected via a bus 600. The bus 600 is Figure 5 The connection between other components is shown by bold lines, and is not intended to be limiting. The bus 600 can be divided into an address bus, a data bus, a control bus, etc. For ease of representation, Figure 5 Only one thick line is used in the figure, but it does not mean that there is only one bus or one type of bus. Alternatively, the processor 601 can also be called a controller, and there is no limitation on the name.

[0159] In the embodiment of the present application, the memory 602 stores instructions that can be executed by at least one processor 601. The at least one processor 601 can execute the material requirement planning method discussed above by executing the instructions stored in the memory 602. The processor 601 can implement Figure 5 The functions of each module in the device shown.

[0160] Among them, the processor 601 is the control center of the device, and can use various interfaces and lines to connect the various parts of the entire control device. By running or executing instructions stored in the memory 602 and calling data stored in the memory 602, the various functions of the device and processing data, the device can be monitored as a whole.

[0161] In one possible design, the processor 601 may include one or more processing units, and the processor 601 may integrate an application processor and a modem processor, wherein the application processor mainly processes an operating system, a user interface, and application programs, and the modem processor mainly processes wireless communications. It is understandable that the modem processor may not be integrated into the processor 601. In some embodiments, the processor 601 and the memory 602 may be implemented on the same chip, and in some embodiments, they may also be implemented separately on separate chips.

[0162] Processor 601 can be a general-purpose processor, such as a central processing unit (CPU), a digital signal processor, an application-specific integrated circuit, a field programmable gate array or other programmable logic device, a discrete gate or transistor logic device, a discrete hardware component, and can implement or execute the various methods, steps and logic block diagrams disclosed in the embodiments of the present application. A general-purpose processor can be a microprocessor or any conventional processor, etc. The steps of the material requirement planning method disclosed in the embodiments of the present application can be directly embodied as a hardware processor to be executed, or a combination of hardware and software modules in the processor can be executed.

[0163] The memory 602 is a non-volatile computer-readable storage medium that can be used to store non-volatile software programs, non-volatile computer executable programs and modules. The memory 602 may include at least one type of storage medium, such as a flash memory, a hard disk, a multimedia card, a card-type memory, a random access memory (Random Access Memory, RAM), a static random access memory (Static Random Access Memory, SRAM), a programmable read-only memory (Programmable Read Only Memory, PROM), a read-only memory (Read Only Memory, ROM), an electrically erasable programmable read-only memory (Electrically Erasable Programmable Read-Only Memory, EEPROM), a magnetic memory, a disk, an optical disk, etc. The memory 602 is any other medium that can be used to carry or store a desired program code in the form of an instruction or data structure and can be accessed by a computer, but is not limited thereto. The memory 602 in the embodiment of the present application can also be a circuit or any other device that can realize a storage function, for storing program instructions and / or data.

[0164] By programming the processor 601, the code corresponding to the material requirement planning method described in the above embodiment can be fixed into the chip, so that the chip can execute the method when running. Figure 2The steps of the material requirement planning method of the embodiment shown are as follows: How to design and program the processor 601 is a technique known to those skilled in the art and will not be described in detail here.

[0165] Based on the same inventive concept, an embodiment of the present application further provides a storage medium, which stores computer instructions. When the computer instructions are executed on a computer, the computer executes the material requirement planning method discussed above.

[0166] In some possible implementations, various aspects of the material requirement planning method provided by the present application can also be implemented in the form of a program product, which includes a program code. When the program product is run on an apparatus, the program code is used to enable the control device to execute the steps of the material requirement planning method according to various exemplary embodiments of the present application described above in this specification.

[0167] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems, or computer program products. Therefore, the present application may adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment in combination with software and hardware. Moreover, the present application may adopt the form of a computer program product implemented in one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that contain computer-usable program code.

[0168] The present application is described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the embodiments of the present application. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0169] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0170] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0171] Obviously, those skilled in the art can make various changes and modifications to the present application without departing from the spirit and scope of the present application. Thus, if these modifications and variations of the present application fall within the scope of the claims of the present application and their equivalents, the present application is also intended to include these modifications and variations.

Claims

1. A material requirement planning method, characterized in that: include: Acquire description information and material demand information of at least one material constituting a target product, wherein the material demand information includes the required quantity of each material and corresponding supplier information, wherein the supplier information is used to indicate at least one candidate supplier for supplying the material; Determining, based on the material inventory information corresponding to the candidate supplier and the material demand information, whether the material inventory corresponding to the candidate supplier can meet the material demand of the target product; as well as When the material inventory corresponding to the candidate supplier cannot meet the material demand of the target product, based on the preset model, a material procurement plan for the target product is generated according to the description information and material demand information of at least one material, wherein the material procurement plan includes the quantity of the material purchased from the at least one candidate supplier.

2. The method according to claim 1, characterized in that The obtaining of description information and material requirement information of at least one material constituting the target product includes: Acquire the user's order data, wherein the order data includes the identifier of the target product, the required quantity of the target product, and the supplier information; Based on the identification of the target product, determining the at least one material constituting the target product and description information of the at least one material; Determining the required quantity of the at least one material according to the required quantity of the target product; and The material demand information is obtained by combining the demand quantity of the at least one material and the supplier information.

3. The method according to claim 1, characterized in that: The generating a material procurement plan for the target product based on the preset model and according to the description information and material requirement information of the at least one material includes: In the case where the material inventory corresponding to the candidate supplier cannot meet the material demand of the target product, determining the purchase demand of the target product according to the material inventory corresponding to the candidate supplier and the logistics demand information; and Based on the preset model, the material procurement plan for the target product is obtained according to the description information of the at least one material and the procurement demand.

4. The method according to claim 1, characterized in that The description information of the material includes at least one of the identification, function, category or category description information of the material; and / or The material demand information also includes at least one of the following: demand time, a quantity threshold of the candidate suppliers corresponding to each material, or historical supplier information that supplies the material to the user.

5. The method according to any one of claims 1 to 4, characterized in that: The method further comprises: A preset model is constructed based on the description information and material requirement information of at least one material, and the preset model corresponds to constraints and model objectives; wherein the model objectives indicate minimizing material procurement costs and / or minimizing procurement time, and the constraints indicate satisfying the material requirement information.

6. The method according to claim 5, characterized in that The model objective of the preset model indicates minimizing the material procurement cost; The constraints of the preset model include a first constraint and a second constraint, wherein the first constraint indicates that materials are purchased from candidate suppliers indicated by the logistics demand information, and the second constraint indicates that the number of candidate suppliers for purchasing materials is not greater than the quantity threshold indicated by the logistics demand information.

7. The method according to claim 6, characterized in that The model objective satisfies the following objective function: Among them, i represents any type of material, and I represents a collection of material types; j represents any candidate supplier, and J represents the set of candidate suppliers; k represents any order, K represents a set of orders; c ij represents the unit cost of purchasing material i from supplier j; x ijk represents the quantity of material i purchased from candidate supplier j for order k; The first constraint condition satisfies the following formula: Among them, d ik Indicates the demand quantity of material i for demand order k; x ijk represents the quantity of material i purchased from candidate supplier j for order k; j∈Range ik represents the set of candidate suppliers acceptable to order k for material i; And the second constraint satisfies the following formula: Among them, y jk is a binary variable. If order k purchases at least one material from candidate supplier j, then y jk The value of y is 1, otherwise jk The value of is 0; MaxSuppliers k Indicates the number of candidate suppliers that can be selected for order k.

8. A material requirement planning device, characterized in that: include: An acquisition module, used to acquire description information and material demand information of at least one material constituting a target product, wherein the material demand information includes the required quantity of each material and corresponding supplier information, and the supplier information is used to indicate at least one candidate supplier for supplying the material; A determination module, configured to determine whether the material inventory of the candidate supplier can meet the material demand of the target product according to the material inventory information corresponding to the candidate supplier and the material demand information; as well as A generation module is used to generate a material procurement plan for the target product based on a preset model and according to the description information and material requirement information of at least one material when the material inventory corresponding to the candidate supplier cannot meet the material requirement of the target product, wherein the material procurement plan includes the quantity of the material purchased from the candidate supplier.

9. An electronic device, characterized in that: The device comprises a processor and a memory, wherein the memory stores program codes, and when the program codes are executed by the processor, the processor executes any one of the methods in claims 1 to 7.

10. A computer-readable storage medium, characterized in that: The storage medium comprises a program code, and when the storage medium is run on an electronic device, the program code is used to enable the electronic device to execute any one of the methods described in claims 1 to 7.

Images