Material supply distribution method, electronic equipment and storage medium

Abstract

The invention provides a material supply distribution method, electronic equipment and a storage medium, and the method comprises the steps: obtaining a demand list from a customer, and determining a target material, a target material demand quantity and expected delivery time; the current stock amount of the target material is obtained, when the current stock amount is smaller than the target material demand amount, a first committed work order set from a supplier is obtained, and the expected delivery time of work orders in the first committed work order set is equal to or earlier than the expected delivery time; obtaining committed material information in the first committed work order set, determining committed work orders corresponding to committed materials capable of replacing the target materials, and obtaining a second committed work order set; and determining supply distribution information to the customer according to the second committed work order set. According to the method, the committed work order is introduced, so that excessive concentration of material requirements can be avoided, supply consumption equalization is realized, and production interruption or inventory overstock caused by insufficient or excessive material supply is avoided.

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and particularly to a method for allocating material supply, an electronic device, and a storage medium. Background Art

[0002] In modern supply chain management systems, material allocation and supplier selection are key aspects to ensure smooth production and cost control. Currently, when calculating material allocation and supply selection, the material selection strategy is usually specified depending on supply types (such as inventory) and the generality priority of materials.

[0003] However, in practical applications, when dealing with the consumption of alternative branch supply chains, this allocation strategy based on generality priority selects according to the total quantity of a certain type of supply first, rather than comprehensively considering various factors such as the production capacity of suppliers and the delivery cycle of materials. Although this selection method can maximize the demand quantity in the short term, in the long run, it is likely to lead to the centralization of material demand.

[0004] When the system preferentially selects general materials with sufficient quantity for allocation, the supply of a certain alternative branch is often frequently selected due to the quantity advantage, while some other alternative branches may never be selected, resulting in unbalanced supply consumption. This unbalanced consumption pattern will also have a negative impact on the subsequent material demand prediction results, not only reducing the overall efficiency of the supply chain, but also possibly causing problems such as inventory backlog and production delays due to prediction errors, thereby increasing the operating costs and market risks of enterprises. Summary of the Invention

[0005] One object of the present invention is to provide a method for allocating material supply to solve the technical problem in the prior art that when preferentially allocating general materials to meet the demand quantity, it is easy to cause the concentration of a certain material demand, thereby resulting in unbalanced supply consumption.

[0006] One object of the present invention is to provide an electronic device.

[0007] One object of the present invention is to provide a computer storage medium.

[0008] To achieve one of the above-mentioned invention purposes, the present invention provides a method for material supply and distribution, including: obtaining a demand order from a customer, determining the target material, the target material demand quantity, and the expected delivery time; obtaining the current inventory quantity of the target material, and when the current inventory quantity is less than the target material demand quantity, obtaining a first set of commitment work orders from a supplier, where the expected delivery time of the work orders in the first set of commitment work orders is equal to or earlier than the expected delivery time; obtaining the committed material information in the first set of commitment work orders, determining the commitment work orders corresponding to the committed materials that can replace the target material, and obtaining a second set of commitment work orders; determining the supply and distribution information to the customer according to the second set of commitment work orders.

[0009] As a further improvement of an embodiment of the present invention, the determining the supply and distribution information to the customer according to the second set of commitment work orders includes: obtaining the generation status of the committed materials in the second set of commitment work orders, sorting the work orders in the second set of commitment work orders in the order of the expected delivery time of the committed materials; determining the first N commitment work orders based on the committed delivery quantity of each work order in the sorted second set of commitment work orders; determining the supply and distribution information for providing the target material to the customer based on the first N commitment work orders; the sum of the expected delivery quantities of the first N commitment work orders is less than or equal to the target material demand quantity, N>0, and N is an integer.

[0010] As a further improvement of an embodiment of the present invention, the determining the supply and distribution information for providing the target material to the customer based on the first N commitment work orders includes: obtaining the first expected delivery quantity of the first commitment work order; determining whether the first expected delivery quantity is greater than or equal to the target material demand quantity; if so, determining the target material demand quantity as the current supply quantity, and generating the supply and distribution information according to the current supply quantity and the committed materials in the first commitment work order.

[0011] As a further improvement of an embodiment of the present invention, after determining whether the first expected delivery quantity is greater than or equal to the target material demand quantity, the method further includes: if not, obtaining the second expected delivery quantity of the second commitment work order; determining whether the sum of the first expected delivery quantity and the second expected delivery quantity is greater than or equal to the target material demand quantity; if the sum of the first expected delivery quantity and the second expected delivery quantity is greater than or equal to the target material demand quantity, determining the first expected delivery quantity as the current first supply quantity, the corresponding first committed material as the current first supplied material, and determining the difference between the target material demand quantity and the first expected delivery quantity as the current second supply quantity, the corresponding second committed material as the current second supplied material; generating the supply and distribution information according to the current first supply quantity and the current first supplied material, and the current second supply quantity and the current second supplied material.

[0012] As a further improvement of an embodiment of the present invention, before obtaining the first set of commitment work orders from the supplier, the method further includes: determining the current inventory quantity as the current supply quantity, generating first supply allocation information based on the current supply quantity of the target material, and updating and determining the demand quantity of the target material.

[0013] As a further improvement of an embodiment of the present invention, determining the supply allocation information to the customer according to the second set of commitment work orders includes: based on the updated demand quantity of the target material, determining the second supply allocation information of the target material according to the expected delivery time and the expected delivery quantity corresponding to the commitment work orders in the second set of commitment work orders; combining the first supply allocation information and the second supply allocation information to determine the supply allocation information to the customer.

[0014] As a further improvement of an embodiment of the present invention, before determining the supply allocation information to the customer according to the second set of commitment work orders, the method further includes: obtaining the first moment when the merchant sends a material demand work order to the supplier and the second moment when the merchant receives the corresponding commitment work order; updating and determining the expected delivery quantity of the commitment work orders in the current second set of commitment work orders according to the purchase quantity of the current target material and at least one of the actual delivery quantity and the in-transit supply quantity within the time range from the first moment to the second moment; determining the supply allocation information to the customer according to the second set of commitment work orders includes: determining the supply allocation information to the customer according to the updated second set of commitment work orders and the current demand quantity of the target material.

[0015] As a further improvement of an embodiment of the present invention, updating and determining the expected delivery quantity of the current commitment work order according to the purchase quantity of the current target material and at least one of the actual delivery quantity and the in-transit supply quantity within the time range from the first moment to the second moment includes: obtaining all the actual delivery work orders and all the in-transit supply work orders corresponding to the target material within the time range from the first moment to the second moment; respectively calculating the sum of the corresponding actual delivery quantity and the in-transit supply quantity according to the actual delivery work orders and the in-transit supply work orders to determine the first quantity; calculating the difference between the expected delivery quantity in the current commitment work order and the first quantity to determine the second quantity; updating and determining the expected delivery quantity of the corresponding commitment work order according to the purchase quantity of the current target material and the second quantity.

[0016] As a further improvement of an embodiment of the present invention, determining the updated expected commitment delivery quantity of the corresponding commitment work order according to the purchase quantity of the current target material and the second quantity includes: judging whether the purchase quantity is greater than the second quantity; if so, taking the difference between the purchase quantity and the second quantity as the expected delivery quantity and updating it to the corresponding commitment work order; if not, taking the second quantity as the expected delivery quantity and updating it to the corresponding commitment work order.

[0017] As a further improvement of an embodiment of the present invention, determining the supply allocation information to the customer according to the second set of commitment work orders includes: obtaining the committed materials of the commitment work orders in the second set of commitment work orders; determining the priority assigned to each commitment work order according to at least one of the primary-secondary nature and generality of the committed materials; and sequentially setting the allocation order for the commitment work orders with the same expected delivery time in the second set of commitment work orders according to the priority to determine the supply allocation information to the customer.

[0018] To achieve one of the above-mentioned invention purposes, the present invention also provides an electronic device, including: at least one processor; a memory, where the memory stores a computer program that can run on the processor, and when the processor executes the program, it executes the steps of the material supply allocation method described in any of the above technical solutions.

[0019] To achieve one of the above-mentioned invention purposes, the present invention also provides a computer storage medium, where the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, it executes the steps of the material supply allocation method described in any of the above technical solutions.

[0020] Compared with the prior art, the embodiments of the present invention have at least one of the following beneficial effects: The present invention adopts a material supply allocation method. By obtaining the demand orders from customers, determining the target materials, the target material requirements, and the expected delivery time, when the current inventory is less than the target material requirements, obtaining the first set of commitment work orders with an expected delivery time equal to or earlier than the expected delivery time, and also considering the supply commitment work orders in the second set of commitment work orders into the demand allocation, ensuring the best match in time between the supply and demand of the target materials, so that even if a certain production material or alternative material has an advantage in quantity, but if its committed delivery time does not meet the requirements or the delivery quantity cannot meet the allocation requirements, it will not be over-selected, thus being able to avoid the over-concentration of material requirements, achieve the equalization of supply consumption, and avoid production interruptions or inventory backlogs caused by insufficient or excessive material supply. BRIEF DESCRIPTION OF THE DRAWINGS

[0021] Figure 1 is a schematic diagram of the steps of the material supply allocation method in an embodiment of the present invention.

[0022] Figure 2 is a schematic diagram of the steps of step S4 in an embodiment of the present invention.

[0023] Figure 3 is a schematic diagram of the steps of step S42 in a specific embodiment of an embodiment of the present invention.

[0024] Figure 4It is a schematic diagram of the steps of the material supply and distribution method in an embodiment of the present invention.

[0025] Figure 5 It is a schematic diagram of the steps of step P42 in a specific embodiment in an embodiment of the present invention.

[0026] Figure 6 It is a schematic structural diagram of an updated commitment work order in an embodiment of the present invention.

[0027] Figure 7 It is a schematic structural diagram of a refrigeration device in an embodiment of the present invention. Specific Embodiment

[0028] The present invention will be described in detail below in conjunction with the specific embodiments shown in the drawings. However, these embodiments do not limit the present invention, and any structural, method, or functional transformation made by those of ordinary skill in the art based on these embodiments is included in the protection scope of the present invention.

[0029] It should be noted that the term "including" or any other variant thereof is intended to cover non-exclusive inclusion, so that a process, method, article, or device including a series of elements not only includes those elements, but also includes other elements not explicitly listed, or elements inherent to such a process, method, article, or device. In addition, terms such as "first" and "second" are only used for descriptive purposes and cannot be understood as indicating or implying relative importance.

[0030] As Figure 1 shown, an embodiment of the present invention provides a material supply and distribution method, including but not limited to the following steps.

[0031] Step S1, obtain a demand order from a customer, and determine the target material, the target material demand quantity, and the expected delivery time.

[0032] Step S2, obtain the current inventory of the target material. When the current inventory is less than the target material demand quantity, obtain a first set of commitment work orders from the supplier, and the expected delivery time of the work orders in the first set of commitment work orders is equal to or earlier than the expected delivery time.

[0033] Step S3, obtain the committed material information in the first set of commitment work orders, and determine the commitment work orders corresponding to the committed materials that can replace the target material to obtain a second set of commitment work orders.

[0034] Step S4, determine the supply allocation information to the customer according to the second set of commitment work orders.

[0035] Thus, by obtaining the requirement order from the customer, determining the target material, the quantity of the target material required, and the expected delivery time, when the current inventory is less than the quantity of the target material required, obtaining the first set of commitment work orders with an expected delivery time equal to or earlier than the expected delivery time, and also considering the supply commitment work orders in the second set of commitment work orders into the demand allocation, ensuring the best match in time between the supply and demand of the target material, so that even if a certain production material or alternative material has an advantage in quantity, but if its committed delivery time does not meet the demand or the delivery quantity cannot meet the allocation requirements, it will not be overselected, thus being able to avoid the over-concentration of material requirements, achieve the equalization of supply consumption, and avoid production interruptions or inventory backlogs caused by insufficient or excessive material supply.

[0036] In step S1, the target material can be the main material or an alternative material, which is clearly marked in the requirement order according to the customer's needs. Among them, the main material refers to the material that directly constitutes the core and main part of the product or component during the production or manufacturing process. The alternative material refers to the material that can be used to replace the main material in some cases to meet the same or similar functional requirements. The alternative material can exist as an alternative solution when the supply of the main material is insufficient, the price is too high, or for other considerations.

[0037] In step S2, the commitment work order (Commitment Manufacturing Time, abbreviated as CMT) is a supply commitment made by the supplier according to the customer's order requirements and its own production capacity. It includes at least one of the types of materials, the quantity of materials, the price of materials, and the expected delivery time of materials that the supplier can provide.

[0038] As the committed managed inventory, CMT represents the supplier's commitment to the quantity of materials that can be provided within a certain period of time, and its credibility is relatively high. The expected delivery time of the materials in CMT refers to the time when the materials can be produced and delivered to the customer, and the expected delivery time is earlier than or equal to the customer's expected delivery time to ensure that the customer can receive the required materials on time.

[0039] In step S1, the requirement order is a work order or request put forward by the customer to clarify its material requirements. The requirement order can record at least one of the name of the required material, the quantity of the required material, and the expected delivery time. As shown in Table 1. Among them, the expected delivery time is the latest time when the customer hopes to receive the required materials, which will be clearly indicated in the requirement order.

[0040] Table 1

[0041] According to the requirement list shown in Table 1, there are two requirements. The target materials for Requirement 1 and Requirement 2 are both A or B, where A can be the main material and B can be the alternative material. The required quantities of the target materials are 120 and 100 respectively, and the expected delivery time is December 10, 2024 for both.

[0042] In step S2, the first set of committed work orders contains the supplier committed work orders that meet the customer's time requirements. The second set of committed work orders in step S2 is a subset or screening result of the first set of committed work orders. It is obtained based on the material information in the first set of committed work orders by determining which materials can replace the target material. That is, the committed materials of all work orders in the second set of committed work orders can be used as the target material or can replace the target material. Therefore, the work orders in the second set of committed work orders not only meet the time requirements but also meet the material replacement requirements.

[0043] As Figure 2 shown, in one embodiment, step S4 may specifically include the following steps.

[0044] Step S41, obtain the generation status of the committed materials in the second set of committed work orders, and sort the work orders in the second set of committed work orders in the order of the expected delivery time of the committed materials.

[0045] Step S42, based on the committed delivery quantity of each work order in the second set of committed work orders after sorting, determine the first N committed work orders.

[0046] Step S43, based on the first N committed work orders, determine the supply allocation information for providing the target material to the customer.

[0047] Among them, the sum of the expected delivery quantities of the first N committed work orders is less than or equal to the demand quantity of the target material, N > 0, and N is an integer.

[0048] In this way, by sorting the second set of committed work orders according to the expected delivery time and selecting the first N work orders that meet the conditions to generate the supply allocation information, the supply allocation information is more accurate in the time dimension, avoiding over-reliance on a single material and making the supply of materials balanced.

[0049] In step S41, sorting the work orders in the second set of committed work orders can include two cases. One is to sort the work orders in the second set of committed work orders in ascending order according to the expected delivery time of the committed materials to determine the first N committed work orders. The other is to sort the work orders in the second set of committed work orders in descending order according to the expected delivery time of the committed materials to determine the first N committed work orders.

[0050] Specifically, when ascending order is used, the expected delivery time of the promised materials of the front committed work orders is earlier, and the first N committed work orders that meet the demand are prioritized to determine the supply allocation information. This means that customers can obtain the target materials earlier, thereby reducing the delivery risks caused by uncertain factors such as supply chain disruptions and production delays, and improving customer satisfaction. Ascending order can ensure the stability and reliability of the supply chain by giving priority to obtaining materials.

[0051] When sorting in descending order, the expected delivery time of the promised materials of the work orders in the front is later, and the first N promised work orders that meet the demand will be prioritized to determine the supply allocation information, that is, the supply allocation information will be determined based on the materials that can be delivered later. Materials delivered later mean that they can be delivered when needed, which not only helps to reduce inventory backlogs and capital occupation, but also reserves more time and options to deal with possible supply chain changes or customer demand adjustments, and has strong flexibility. Sorting in descending order can deal with uncertainty by retaining time and options, and optimize the customer's inventory and capital status.

[0052] In one embodiment, assuming that the number of work orders in the second committed work order set is M, when M is greater than N, N committed work orders are selected based on the target material demand, so that the sum of the committed delivery quantities of the N committed work orders is equal to the target material demand. In this process, there may be two situations: one is that the committed delivery quantity of the Nth committed work order is fully used to meet the target material demand; the other is that only part of the committed delivery quantity of the Nth committed work order is used to meet the target material demand.

[0053] For example, if the target material demand is 90, and the expected delivery quantities of the work orders in the second commitment work order set are 20, 20, 20, 20, 20, 30 (M is 6), then 20, 20, 20, 20 (N is 5) commitment work orders are obtained based on the target material demand, and their corresponding expected delivery quantities are 20, 20, 20, 20, 20, 20, respectively. The fifth commitment work order only needs to provide 10 units of expected delivery quantity (part of the expected delivery quantity). If the target material demand is 100, the first 5 commitment work orders (all expected delivery quantities) can be obtained.

[0054] If the committed delivery quantities of all committed work orders in the second committed work order set are less than the target material demand quantity, then based on all committed work orders in the second committed work order set, determine the first supply allocation information for providing the target material to the customer; calculate the difference between the target material demand quantity and the committed delivery quantities of all committed work orders, and based on the remaining available material information, determine the second supply allocation information for providing the target material to the customer; combine the first supply allocation information and the second supply allocation information to determine the final supply allocation information for providing the target material to the customer.

[0055] As Figure 3 shown, in a specific embodiment, step S42 may specifically include the following steps.

[0056] Step S421: Obtain the first expected delivery quantity of the first commitment work order.

[0057] Step S422: Determine whether the first expected delivery quantity is greater than or equal to the target material demand quantity.

[0058] If so, jump to step S423A, determine the target material demand quantity as the current supply quantity, and generate supply allocation information according to the current supply quantity and the committed materials in the first commitment work order.

[0059] If not, jump to step S423B to obtain the second expected delivery quantity of the second commitment work order.

[0060] Step S424: Determine whether the sum of the first expected delivery quantity and the second expected delivery quantity is greater than or equal to the target material demand quantity.

[0061] Step S425: If the sum of the first expected delivery quantity and the second expected delivery quantity is greater than or equal to the target material demand quantity, determine the first expected delivery quantity as the current first supply quantity, the corresponding first committed material as the current first supplied material, and determine the difference between the target material demand quantity and the first expected delivery quantity as the current second supply quantity, and the corresponding second committed material as the current second supplied material.

[0062] Step S426: Generate supply allocation information according to the current first supply quantity and the current first supplied material, as well as the current second supply quantity and the current second supplied material.

[0063] In this way, by accurately calculating the relationship between the delivery quantity of each commitment work order and the target demand quantity, when the delivery quantity of a single commitment work order is insufficient, the next commitment work order is automatically considered until the demand is met, ensuring the accuracy of the supply quantity.

[0064] The first commitment work order and the second commitment work order refer to the first work order and the second work order after all work orders in the second commitment work order set are arranged. Of course, if the committed delivery quantities of the first work order and the second work order have not yet met the target material demand quantity, the third work order, the fourth work order, and even the last work order can be continued to be selected. There is no specific limitation on this, and it can be adaptively adjusted according to the target material demand quantity.

[0065] In an embodiment, when the current inventory quantity is not 0 but cannot meet the target material demand quantity, the supply allocation information is preferentially determined according to the current inventory quantity, and then the remaining supply allocation information is determined based on the commitment work order set.

[0066] AsFigure 4 In a specific embodiment as described above, the method further includes the following steps.

[0067] Step S2', obtain the current inventory of the target material. When the current inventory is less than the demand for the target material, determine the current inventory as the current supply quantity, generate the first supply allocation information according to the current supply quantity of the target material, and update and determine the demand for the target material.

[0068] Step S3, obtain the promised material information in the first set of promised work orders, determine the promised work orders corresponding to the promised materials that can replace the target material, and obtain the second set of promised work orders.

[0069] Step S41, based on the updated demand for the target material, determine the second supply allocation information for the target material according to the expected delivery time and expected delivery quantity corresponding to the promised work orders in the second set of promised work orders.

[0070] Step S42, combine the first supply allocation information and the second supply allocation information to determine the supply allocation information for the customer.

[0071] In this way, by preferentially using the existing inventory to meet customer needs and using the promised work orders to supplement when the inventory is insufficient, the timeliness and flexibility of supply can be ensured.

[0072] For example, assume that the customer's demand order is the content shown in Table 1 above. Based on the work order situation shown in Table 2(a), select the general strategy supply allocation method adopted in the prior art, and determine the supply allocation information according to the priority order of the work order or material type and material generality. The corresponding supply allocation information is shown in Table 2(b) below.

[0073] Table 2(a)

[0074] In Table 2(a), ASN (Advance Shipping Notice) refers to the advance notice that the supplier has planned and sent regarding the materials to be shipped soon. Specifically, it is sent by the product shipper (Supplier 1 carrier) and is the detailed information of the goods sent to the warehouse before transportation. In the present invention, ASN can be regarded as a kind of inventory status that is about to arrive or is already in transit, and is a supply type of "expected inventory" or "in-transit inventory".

[0075] In Table 2 (a), PO (Purchase Order) refers to the agreement record between the buyer and seller of goods. It is used to record at least one of the key information such as the type of materials purchased, the quantity of materials, and the price of materials. The purchase order PO is an order issued by the purchasing department to the supplier based on the calculation results of MRP (Material Requirement Planning).

[0076] MRP calculates the demand quantity and expected delivery time of materials for a period of time based on information such as production plans, inventory status, and bill of materials. The calculation results will be used as the basis for procurement, production, and inventory management.

[0077] Table 2 (b)

[0078] The material information or work order information shown in Table 2 (a) all meets the requirement information of the demand order shown in Table 1. Priority is given to selection based on the supply type of materials and the corresponding total quantity. The first record that meets the demand quantity of the target material is selected, that is, Material A with a supply type of ASN and a quantity of 100. At this time, there is still a shortage of 20 materials. Material A with a material type of PO or Material B with a material type of PO in Table 2 (a) can be used. When the material types are the same (both are PO), the selection of material supply is determined based on the generality of the materials. Assuming that the generality index of Material A is higher than that of Material B, then the more general Material A is selected, that is, Material A is selected, and the corresponding material type for a quantity of 20 is PO. That is, based on the method adopted in the prior art, the supply allocation information shown in Table 2 (b) can be obtained.

[0079] For the supply order shown in Table 2 (b), priority is given to selection based on the supply type of materials and the corresponding total quantity, and the generality strategy is used for assistance. This will cause the supply allocation information within a certain period of time to all focus on the consumption of the supply of a certain alternative branch, which will in turn cause the supply situation to concentrate on a certain material or a certain supplier within a certain period of time, not conforming to the actual set procurement ratio, resulting in an unbalanced prediction distribution of subsequent material consumption.

[0080] It should be noted that since the purchase order PO or purchase requisition (PR) takes into account the minimum purchase package or minimum order quantity and the purchase consolidation days during the formulation process, the quantity purchased is very likely to exceed the actual demand, so as to meet the economy and efficiency of procurement. And CMT makes batch commitment responses based on the actual production capacity of the supplier. Therefore, it is closer to the actual physical consumption and demand situation in terms of quantity and time dimensions.

[0081] Based on this, the present invention introduces CMT into the material supply and distribution, and conducts supply allocation by introducing commitment work orders that meet the demand before the expected delivery time, as shown in Table 3(a). Table 3(a) shows all the commitment work orders and current available inventory information (including materials of ASN type) corresponding to the committed materials that meet the alternative target materials before the expected delivery time in the demand order.

[0082] Based on the content shown in Table 3(a), when there are currently available inventory materials, the currently available inventory materials are preferentially consumed, that is, as recorded in the first record shown in Table 3(a): Material A, material type is ASN, and quantity is 100. That is, the corresponding first supply allocation information is generated based on the currently available inventory materials, as shown in Table 3(b). That is, select Material A, material quantity is 100, and supply type is ASN. When the currently available inventory materials do not meet the demand quantity of the target material, a second set of commitment work orders is screened based on the expected delivery time in Table 1 and the expected delivery time in Table 3(a).

[0083] Table 3(a)

[0084] When the currently available inventory materials do not meet the demand quantity of the target material, based on the expected delivery time (2024 / 12 / 10) in Table 1 and the expected delivery time shown in Table 3(a), the commitment work orders less than or equal to the expected delivery time are screened, sorted in ascending order according to the expected delivery time, and the first N commitment work orders are determined so that their committed delivery quantity is equal to the demand quantity of the target material, and the supply allocation information as shown in Table 3(b) is obtained.

[0085] Table 3(b)

[0086] The supply allocation information of Table 3(b) for "Demand 2" can continue to be allocated according to the priority order of material supply type, committed delivery time, and universality index until the committed delivery quantity meets the demand quantity of the target material. In this way, this allocation method no longer takes the total supply of one category as the selection basis.

[0087] Specifically, sort based on the committed delivery time in the commitment work order, preferentially consume the work orders with a committed delivery time farther from the expected delivery time, determine the corresponding N commitment work orders based on the demand quantity of the target material and the committed delivery quantity of each commitment work order; determine the corresponding supply allocation information according to the N commitment work orders, as shown in Table 3(b) below. In this way, by reasonably handling backlogged materials and purchasing new materials, the inventory status is corrected and optimized to meet the supply demand.

[0088] Understandably, it takes two to three days from MRP calculation, to production, to releasing the forecast results, and then to the supplier's response to CMT. During this period, new actual deliveries may occur, resulting in the expected delivery volume represented by CMT no longer being the current actual situation, because some goods may have been delivered. Based on this, it is necessary to update the corresponding information of some committed work orders.

[0089] In one embodiment, before step S4, the method may further include the following steps.

[0090] Step P41, obtain the first moment when the merchant sends the material requirement work order to the supplier and the second moment when the corresponding committed work order is received.

[0091] Step P42, update and determine the expected delivery volume of the committed work orders in the current second committed work order set according to the purchase volume of the current target material and at least one of the actual delivery volume and the in-transit supply volume within the time range from the first moment to the second moment.

[0092] Step S4’, determine the supply allocation information to the customer according to the updated second committed work order set and the current target material demand.

[0093] As Figure 5 shown, in a specific embodiment, step P42 may specifically include the following steps.

[0094] Step P421, obtain all the actual delivery work orders and all the in-transit supply work orders of the target material within the time range corresponding to the first moment to the second moment.

[0095] Step P422, calculate the sum of the corresponding actual delivery volume and in-transit supply volume respectively according to the actual delivery work order and the in-transit supply work order, and determine the first quantity.

[0096] Step P423, calculate the difference between the expected delivery volume in the current committed work order and the first quantity, and determine the second quantity.

[0097] Step P424, update and determine the expected delivery volume of the corresponding committed work order according to the purchase volume of the current target material and the second quantity.

[0098] In this way, by precisely adjusting and optimizing the committed delivery volume of the committed work order, it is ensured that it is highly consistent with the actual material flow, order status and procurement requirements.

[0099] In step P41, the first moment marks the official start of the merchant's demand for materials, and the second moment marks the official commitment response of the supplier to the merchant's material demand, that is, the provision of a commitment work order. During the period between the first moment and the second moment, various material flows and order status changes may occur, such as material work orders that have been completed for delivery (actual delivery work orders) and ASN work orders (i.e., material work orders that have been issued but have not yet arrived).

[0100] In addition, the material demand calculated by MRP minus the current inventory and in-transit material quantity (including ASN and the unarrived part of the confirmed CMT) gives the corresponding demand gap, and this demand gap is filled by placing a new PO. If the quantity of CMT exceeds the quantity of POs that have been issued, and the excess part of the CMT is included in the MRP calculation, the excess part of the CMT is wrongly regarded as the arranged supply, thus reducing the actual demand gap. With the actual demand gap reduced, the purchasing department will correspondingly reduce the issuance of new POs, resulting in the possibility that the quantity of materials actually received may not meet the target material demand, unable to meet the production demand, leading to production delays or material shortages in inventory and other problems.

[0101] To avoid this situation, when calculating the actual demand, correctly identify and exclude the CMT exceeding the PO part. Based on this, in a specific embodiment, step P424 may specifically include the following steps.

[0102] Step P4241, determine whether the purchase quantity is greater than the second quantity.

[0103] If so, jump to step P4242A, and use the difference between the purchase quantity and the second quantity as the expected delivery quantity, and update it to the corresponding commitment work order.

[0104] If not, jump to step P4242B, and use the second quantity as the expected delivery quantity, and update it to the corresponding commitment work order.

[0105] In a specific embodiment, the work orders in the second commitment work order set are updated according to the priority order of the actual delivery work order, ASN, and PO.

[0106] Specifically, as Figure 6 shown, first, exclude the quantity of materials that have been actually delivered, that is, those materials that have been purchased and warehoused from the MRP operation time to the current moment, because these materials no longer require CMT for commitment management as they have completed the delivery process.

[0107] Secondly, remove the number of ASNs that are still in effect, because ASNs represent the part of the materials that have actually been ordered and are in the process of being delivered. This part of the materials has higher security and certainty, so it needs to be processed separately to avoid double counting or misjudgment.

[0108] Finally, ensure that the CMT quantity does not exceed the quantity of the current purchase order (PO) to avoid deviations when calculating the demand gap. When the CMT quantity exceeds the PO quantity, update the difference between the CMT quantity and the PO quantity as the committed delivery quantity to the CMT work order.

[0109] In one embodiment, step S4 may specifically include the following steps.

[0110] Step S41, obtain the committed materials of the committed work orders in the second committed work order set.

[0111] Step S42, determine the priority assigned to each committed work order according to at least one of the primary / secondary nature and universality of the committed materials.

[0112] Step S43, set the allocation order for the committed work orders with the same expected delivery time in the second committed work order set in sequence according to the priority to determine the supply allocation information for the customers.

[0113] In step S42, the primary / secondary nature of the committed materials refers to whether the committed materials are primary materials or substitute materials. When facing two committed work orders with the same expected delivery time, give priority to the work order with primary materials as the committed materials.

[0114] The universality of the committed materials refers to the characteristic that the materials can be commonly used in different products or production lines. When facing the same expected delivery time, give priority to the committed materials with a higher universality index.

[0115] In addition, when facing two committed work orders with the same expected delivery time and the same primary / secondary nature of the materials, give priority to the committed materials with a higher universality index. For example, if material A is used by three products and material B is used by ten products, then the universality index of material B is higher than that of material A, that is, material B is more universal.

[0116] As Figure 6 shown, an embodiment of the present invention provides an electronic device 200.

[0117] The electronic device 200 may specifically be a computer device, and this computer device may be a terminal device or a server.

[0118] The electronic device 200 includes at least one processor. The material supply and distribution method provided by the present invention can be applied to or implemented by the processor. Specifically, the processor can be a central processing unit (CPU) 21.

[0119] The electronic device 200 includes a memory. The memory is used to store various types of data to support the operation of the electronic device 200. Examples of such data include: any computer program for operating on a computer device. The memory can be a read-only memory (ROM) 22, a random access memory (RAM) 23, or other storage part 28. The storage part 28 can be located inside the electronic device 200 or outside the electronic device 200.

[0120] In one embodiment, when the processor executes the computer program stored in the memory, the steps of the material supply and distribution method in any technical solution of the present invention are executed.

[0121] In one embodiment, the electronic device 200 includes a central processing unit 21, which can perform various appropriate actions and processes according to a program stored in the read-only memory 22 or a program loaded from the storage part 28 into the random access memory 23. In the random access memory 23, various programs and data required for system operation are also stored. The central processing unit 21, the read-only memory 22, and the random access memory 23 are connected to each other through a bus 24. An input / output interface (Input / Output interface, i.e., I / O interface) 25 is also connected to the bus 24.

[0122] The following components are connected to the input / output interface 25: an input part 26 including a keyboard, a mouse, etc.; an output part 27 including a cathode ray tube (CRT), a liquid crystal display (LCD), etc. and a speaker, etc.; a storage part 28 including a hard disk, etc.; and a communication part 29 including a network interface card such as a local area network card, a modem, etc. The communication part 29 performs communication processing via a network such as the Internet. A drive 210 is also connected to the input / output interface 25 as needed. A removable medium 211, such as a disk, an optical disc, a magneto-optical disc, a semiconductor memory, etc., is installed on the drive 210 as needed so that a computer program read from it can be installed into the storage part 28 as needed.

[0123] One embodiment of the present invention provides a computer-readable storage medium.

[0124] In one embodiment, a computer-readable storage medium stores a computer program executed by the aforementioned processor, or the material supply allocation method in any of the foregoing technical solutions.

[0125] When the processor executes the computer program, it can execute the description of the material supply allocation method in any of the foregoing technical solutions. Therefore, the description will not be repeated here. In addition, the description of the beneficial effects of using the same method will not be repeated either.

[0126] The computer-readable storage medium may include: a flash drive, a read-only memory (ROM), a random access memory (RAM), a magnetic disk, an optical disc, etc.

[0127] In summary, the present invention provides a material supply allocation method, an electronic device, and a storage medium. By obtaining a demand order from a customer, determining the target material, the target material demand quantity, and the expected delivery time, when the current inventory quantity is less than the target material demand quantity, obtaining a first set of commitment work orders with an expected delivery time equal to or earlier than the expected delivery time, and also considering the supply commitment work orders in the second set of commitment work orders into the demand allocation, ensuring that the supply and demand of the target material achieve the best match in time, so that even if a certain production material or substitute material has an advantage in quantity, but if its committed delivery time does not meet the demand or the delivery quantity cannot meet the allocation requirements, it will not be over-selected, thereby being able to avoid the over-concentration of material demand, achieve the equalization of supply consumption, and avoid production interruption or inventory backlog caused by insufficient or excessive material supply.

[0128] It should be understood that although this specification is described according to embodiments, not every embodiment only contains an independent technical solution. This narrative way of the specification is only for clarity. Those skilled in the art should regard the specification as a whole, and the technical solutions in each embodiment can also be appropriately combined to form other embodiments that can be understood by those skilled in the art.

[0129] The series of detailed descriptions listed above are only specific descriptions of the feasible embodiments of the present invention, and they are not intended to limit the protection scope of the present invention. Any equivalent embodiments or changes made without departing from the technical spirit of the present invention should be included in the protection scope of the present invention.

Claims

1. A method for material supply and distribution, characterized in that Including: Obtain a requirements list from the customer, and determine the target material, the required quantity of the target material, and the expected delivery time; Obtain the current inventory of the target material. When the current inventory is less than the required quantity of the target material, obtain a first set of commitment work orders from the supplier, and the expected delivery time of the work orders in the first set of commitment work orders is equal to or earlier than the expected delivery time; Obtain the committed material information in the first set of commitment work orders, and determine the commitment work orders corresponding to the committed materials that can replace the target material to obtain a second set of commitment work orders; Determine the supply allocation information to the customer according to the second set of commitment work orders.

2. The material supply and distribution method according to claim 1, characterized in that The determining the supply allocation information to the customer according to the second set of commitment work orders includes: Obtain the production status of the committed materials in the second set of commitment work orders, and sort the work orders in the second set of commitment work orders in the order of the expected delivery time of the committed materials; Based on the committed delivery quantity of each work order in the sorted second set of commitment work orders, determine the first N commitment work orders; Based on the first N commitment work orders, determine the supply allocation information for providing the target material to the customer; the sum of the expected delivery quantities of the first N commitment work orders is less than or equal to the required quantity of the target material, N > 0, and N is an integer.

3. The material supply and distribution method according to claim 2, characterized in that The determining the supply allocation information for providing the target material to the customer based on the first N commitment work orders includes: Obtain the first expected delivery quantity of the first commitment work order; Judge whether the first expected delivery quantity is greater than or equal to the required quantity of the target material; If so, determine the required quantity of the target material as the current supply quantity, and generate supply allocation information according to the current supply quantity and the committed materials in the first commitment work order.

4. The material supply and distribution method according to claim 3, characterized in that After the judging whether the first expected delivery quantity is greater than or equal to the required quantity of the target material, the method further includes: If not, obtain the second expected delivery quantity of the second commitment work order; Judge whether the sum of the first expected delivery quantity and the second expected delivery quantity is greater than or equal to the required quantity of the target material; If the sum of the first expected delivery quantity and the second expected delivery quantity is greater than or equal to the required quantity of the target material, determine the first expected delivery quantity as the current first supply quantity, the corresponding first committed material as the current first supplied material, and determine the difference between the required quantity of the target material and the first expected delivery quantity as the current second supply quantity, and the corresponding second committed material as the current second supplied material; Generate supply allocation information according to the current first supply quantity and the current first supplied material, and the current second supply quantity and the current second supplied material.

5. The material supply and distribution method according to claim 1, characterized in that Before the obtaining the first set of commitment work orders from the supplier, the method further includes: Determine the current inventory as the current supply quantity, generate the first supply allocation information according to the current supply quantity of the target material, and update and determine the required quantity of the target material.

6. The material supply and distribution method according to claim 5, wherein The determining the supply allocation information to the customer according to the second set of commitment work orders includes: Based on the updated required quantity of the target material, determine the second supply allocation information of the target material according to the expected delivery time and the expected delivery quantity corresponding to the commitment work orders in the second set of commitment work orders; Combine the first supply allocation information and the second supply allocation information to determine the supply allocation information to the customer.

7. The material supply and distribution method according to claim 1, characterized in that Before determining the supply allocation information for the customer based on the second set of commitment work orders, the method further includes: Obtaining the first moment when the merchant sends a material requirement work order to the supplier and the second moment when the merchant receives the corresponding commitment work order; Updating and determining the expected delivery quantity of the commitment work orders in the current second set of commitment work orders according to at least one of the purchase quantity of the current target material, the actual delivery quantity and the in-transit supply quantity within the time range from the first moment to the second moment; The determining the supply allocation information for the customer based on the second set of commitment work orders includes: Determining the supply allocation information for the customer according to the updated second set of commitment work orders and the current target material demand quantity.

8. The material supply and distribution method according to claim 7, characterized in that, The updating and determining the expected delivery quantity of the current commitment work order according to at least one of the purchase quantity of the current target material, the actual delivery quantity and the in-transit supply quantity within the time range from the first moment to the second moment includes: Obtaining all actual delivery work orders and all in-transit supply work orders corresponding to the target material within the time range from the first moment to the second moment; Calculating the sum of the corresponding actual delivery quantity and in-transit supply quantity respectively according to the actual delivery work order and the in-transit supply work order to determine the first quantity; Calculating the difference between the expected delivery quantity in the current commitment work order and the first quantity to determine the second quantity; Updating and determining the expected delivery quantity of the corresponding commitment work order according to the purchase quantity of the current target material and the second quantity.

9. The material supply and distribution method according to claim 8, characterized in that, The determining and updating the expected commitment delivery quantity of the corresponding commitment work order according to the purchase quantity of the current target material and the second quantity includes: Judging whether the purchase quantity is greater than the second quantity; If so, using the difference between the purchase quantity and the second quantity as the expected delivery quantity and updating it to the corresponding commitment work order; If not, using the second quantity as the expected delivery quantity and updating it to the corresponding commitment work order.

10. The material supply and distribution method according to claim 1, characterized in that The determining the supply allocation information for the customer based on the second set of commitment work orders includes: Obtaining the committed materials of the commitment work orders in the second set of commitment work orders; Determining the priority assigned to each commitment work order according to at least one of the primary-secondary nature and generality of the committed materials; Setting the allocation order for the commitment work orders with the same expected delivery time in the second set of commitment work orders in sequence according to the priority to determine the supply allocation information for the customer.

11. An electronic device, comprising: At least one processor; A memory, the memory storing a computer program that can run on the processor, characterized in that when the processor executes the program, it executes the steps of the material supply allocation method according to any one of claims 1 to 10.

12. A computer storage medium, the computer-readable storage medium stores a computer program, characterized in that, When the computer program is executed by the processor, it executes the steps of the material supply allocation method according to any one of claims 1 to 10.

Images