Material supply distribution method, electronic equipment and storage medium

Abstract

The present invention provides a material supply allocation method, electronic device, and storage medium. The method includes: obtaining a demand order from a customer, determining a target material, a target material demand, and an expected delivery time; obtaining the current inventory of the target material, and when the current inventory is less than the target material demand, obtaining a first set of committed work orders from suppliers, wherein the expected delivery time of the work orders in the first set of committed work orders is equal to or earlier than the expected delivery time; obtaining committed material information in the first set of committed work orders, determining committed work orders corresponding to committed materials that can replace the target material, and obtaining a second set of committed work orders; and determining supply allocation information to the customer based on the second set of committed work orders. By introducing committed work orders, the method can avoid excessive concentration of material demand, achieve balanced supply and consumption, and avoid production interruptions or inventory backlogs caused by insufficient or excessive material supply.

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular to a material supply and distribution method, electronic equipment, and storage medium. Background Art

[0002] In modern supply chain management systems, material allocation and supplier selection are key steps in ensuring smooth production and cost control. Current material allocation and supplier selection strategies typically rely on supply type (such as inventory) and the material's general availability priority to determine the material selection strategy.

[0003] However, in actual applications, this allocation strategy based on universality priority gives priority to selecting based on the total quantity of a certain type of supply when dealing with alternative branch supply chain consumption, rather than comprehensively considering multiple factors such as the supplier's production capacity and material delivery cycle. Although this selection method can maximize demand in the short term, in the long run, it is easy to lead to the concentration of material demand.

[0004] When the system prioritizes allocation of general materials with sufficient quantities, the supply of a certain alternative branch will often be frequently selected due to its quantity advantage, while other alternative branches may never be selected, resulting in an imbalance in supply and consumption. This unbalanced consumption pattern will also have a negative impact on the subsequent material demand forecast results, not only reducing the overall efficiency of the supply chain, but also potentially causing inventory backlogs, production delays and other problems due to forecasting errors, thereby increasing the company's operating costs and market risks. Summary of the Invention

[0005] One of the purposes of the present invention is to provide a material supply distribution method to solve the technical problem in the prior art that general materials that meet demand are distributed first, which easily leads to concentrated demand for certain materials and thus causes unbalanced supply and consumption.

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

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

[0008] In order to achieve one of the above-mentioned purposes of the invention, the present invention provides a material supply allocation method, 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 of the target material, and when the current inventory is less than the target material demand quantity, obtaining a first set of committed work orders from the supplier, and the expected delivery time of the work orders in the first set of committed work orders is equal to or earlier than the expected delivery time; obtaining committed material information in the first set of committed work orders, determining the committed work orders corresponding to the committed materials that can replace the target materials, and obtaining a second set of committed work orders; and determining the supply allocation information to the customer based on the second set of committed work orders.

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

[0010] As a further improvement of an embodiment of the present invention, the supply allocation information of the target material to the customer is determined based on the first N committed work orders, including: obtaining a first expected delivery quantity of the first committed work order; judging whether the first expected delivery quantity is greater than or equal to the target material demand; if so, determining the target material demand as the current supply quantity, and generating supply allocation information based on the current supply quantity and the committed material in the first committed 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, the method further includes: if not, obtaining the second expected delivery quantity of the second committed 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; 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, determining the first expected delivery quantity as the current first supply quantity, and the corresponding first committed material as the current first supply material, and determining the difference between the target material demand and the first expected delivery quantity as the current second supply quantity, and the corresponding second committed material as the current second supply material; generating supply allocation information based on the current first supply quantity and the current first supply material, as well as the current second supply quantity and the current second supply material.

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

[0013] As a further improvement of one embodiment of the present invention, the supply allocation information to the customer is determined based on the second set of committed work orders, including: based on the updated target material demand, according to the expected delivery time and expected delivery quantity corresponding to the committed work orders in the second set of committed work orders, determining the second supply allocation information of the target material; 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 based on the second commitment work order set, the method also includes: obtaining the first moment when the merchant sends the 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 commitment work order set based on the current purchase quantity of the 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 based on the second commitment work order set includes: determining the supply allocation information to the customer based on the updated second commitment work order set and the current target material demand quantity.

[0015] As a further improvement of an embodiment of the present invention, the updating and determining of the expected delivery quantity of the current committed work order based on the current purchase quantity of the 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 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 quantities and the in-transit supply quantities based on the actual delivery work orders and the in-transit supply work orders respectively to determine the first quantity; calculating the difference between the expected delivery quantity in the current committed work order and the first quantity to determine the second quantity; and updating and determining the expected delivery quantity of the corresponding committed work order based on the current purchase quantity of the target material and the second quantity.

[0016] As a further improvement of an embodiment of the present invention, the method of determining and updating the expected committed delivery quantity of the corresponding commitment work order based on the current purchase quantity of the 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 one embodiment of the present invention, determining the supply allocation information to the customer based on the second set of committed work orders includes: obtaining the committed materials of the committed work orders in the second set of committed work orders; determining the priority of allocation of each committed work order based on at least one of the priority and versatility of the committed materials; and setting an allocation order for the committed work orders with the same expected delivery time in the second set of committed work orders according to the priority to determine the supply allocation information to the customer.

[0018] In order to achieve one of the above-mentioned purposes of the invention, the present invention also provides an electronic device, comprising: at least one processor; a memory, wherein the memory stores a computer program that can be run on the processor, and when the processor executes the program, it performs the steps of the material supply and distribution method described in any of the above-mentioned technical solutions.

[0019] In order to achieve one of the above-mentioned objects of the invention, the present invention also provides a computer storage medium, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the steps of the material supply and distribution method described in any of the above-mentioned technical solutions are executed.

[0020] Compared with the prior art, the embodiments of the present invention have at least one of the following beneficial effects:

[0021] The present invention adopts a material supply allocation method, which obtains a demand order from a customer, determines the target material, the target material demand quantity and the expected delivery time, and when the current inventory is less than the target material demand quantity, obtains a first commitment work order set with an expected delivery time equal to or earlier than the expected delivery time, and also takes the supply commitment work orders in the second commitment work order set into consideration for demand allocation, to ensure that the supply and demand of the target material are optimally matched in time, so that even if a certain production material or alternative material has an advantage in quantity, it will not be over-selected if its promised delivery time does not meet the demand or the delivery quantity cannot meet the allocation requirements, thereby avoiding excessive concentration of material demand, achieving balanced supply and consumption, and avoiding production interruptions or inventory backlogs due to insufficient or excessive material supply. BRIEF DESCRIPTION OF THE DRAWINGS

[0022] Figure 1 1 is a schematic diagram of the steps of a material supply distribution method in one embodiment of the present invention.

[0023] Figure 2 FIG. 1 is a schematic diagram of step S4 in an embodiment of the present invention.

[0024] Figure 3 1 is a schematic diagram of step S42 of a specific embodiment of an embodiment of the present invention.

[0025] Figure 41 is a schematic diagram of the steps of a material supply distribution method in one embodiment of the present invention.

[0026] Figure 5 This is a schematic diagram of step P42 in a specific embodiment of an embodiment of the present invention.

[0027] Figure 6 It is a structural diagram of updating a commitment work order in one embodiment of the present invention.

[0028] Figure 7 It is a structural schematic diagram of a refrigeration device in one embodiment of the present invention. DETAILED DESCRIPTION

[0029] The present invention will be described in detail below with reference to the specific embodiments shown in the accompanying drawings. However, these embodiments do not limit the present invention, and any structural, methodological, or functional changes made by those skilled in the art based on these embodiments are all within the scope of protection of the present invention.

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

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

[0032] Step S1: Obtain a demand form from a customer, determine the target material, target material demand quantity, and expected delivery time.

[0033] Step S2: obtaining the current inventory of the target material. When the current inventory is less than the target material demand, obtaining a first set of committed work orders from the supplier, wherein the expected delivery time of the work orders in the first set of committed work orders is equal to or earlier than the expected delivery time.

[0034] Step S3: Obtain committed material information in the first committed work order set, determine committed work orders corresponding to committed materials that can replace the target material, and obtain a second committed work order set.

[0035] Step S4: Determine the supply allocation information to the customer based on the second committed work order set.

[0036] In this way, by obtaining demand orders from customers, 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 expected delivery time equal to or earlier than the expected delivery time, and taking the supply commitment work orders in the second set of commitment work orders into consideration for demand allocation, it is ensured that the supply and demand of the target material are optimally matched in time, so that even if a certain production material or substitute material has an advantage in quantity, it will not be over-selected if its promised delivery time does not meet the demand or the delivery quantity cannot meet the allocation requirements, thereby avoiding excessive concentration of material demand, achieving balanced supply and consumption, and avoiding production interruptions or inventory backlogs due to insufficient or excessive material supply.

[0037] In step S1, the target material can be either a primary material or an alternative material, clearly marked in the request form based on customer needs. A primary material refers to a material that directly constitutes the core or primary component of a product or component during the production or manufacturing process. An alternative material is a material that can, in certain circumstances, replace the primary material to meet the same or similar functional requirements. Alternative materials can serve as an alternative when the primary material is in short supply, too expensive, or for other reasons.

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

[0039] CMT, as commitment-managed inventory, represents a supplier's commitment to the quantity of material they can provide over a certain period of time, and it offers a high degree of reliability. The expected delivery time for materials in CMT refers to the time when the materials can be produced and delivered to the customer. This expected delivery time is set before or equal to the customer's expected delivery time to ensure that the customer receives the required materials on time.

[0040] In step S1, a request is a work order or request submitted by a customer to clarify their material needs. The request may include at least one of the required material name, required quantity, and expected delivery time, as shown in Table 1. The expected delivery time is the latest time the customer wishes to receive the required material, and is clearly stated in the request.

[0041] Table 1

[0042]

[0043] According to the demand list shown in Table 1, there are two demands. The target materials of demand 1 and demand 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 2024 / 12 / 10.

[0044] In step S2, the first set of committed work orders includes 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 filtered result of the first set of committed work orders. This set is derived based on the material information in the first set of committed work orders and by determining which materials can substitute for the target material. That is, the committed materials of all work orders in the second set of committed work orders can serve as the target material or can substitute for 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 substitution requirements.

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

[0046] Step S41: obtaining the generation status of the promised materials in the second set of promised work orders, and sorting the work orders in the second set of promised work orders according to the order of the expected delivery time of the promised materials.

[0047] Step S42: Determine the top N committed work orders based on the committed delivery quantity of each work order in the sorted second committed work order set.

[0048] Step S43: Based on the first N committed work orders, determine the supply allocation information of the target material to be provided to the customer.

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

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

[0051] In step S41, sorting the work orders in the second set of committed work orders may include two scenarios: one is to sort the work orders in the second set of committed work orders in ascending order based on the expected delivery time of the committed materials to determine the top N committed work orders; the other is to sort the work orders in the second set of committed work orders in descending order based on the expected delivery time of the committed materials to determine the top N committed work orders.

[0052] Specifically, when sorting in ascending order, the top committed work orders have earlier expected delivery dates for the materials they promise, and the first N committed work orders that meet demand are prioritized for supply allocation. This means customers can obtain their desired materials sooner, reducing delivery risks caused by uncertainties such as supply chain disruptions and production delays, and improving customer satisfaction. Sorting in ascending order ensures supply chain stability and reliability by prioritizing material acquisition.

[0053] When sorting in descending order, the top work orders have later expected delivery times for committed materials. Supply allocation information is prioritized based on the first N committed work orders that meet demand. This means that supply allocation information is prioritized based on materials that can be delivered later. Late delivery means materials can be delivered when needed, which not only helps reduce inventory backlogs and tied up capital, but also provides more time and options to respond to potential supply chain changes or adjustments in customer demand, providing greater flexibility. Sorting in descending order allows you to address uncertainty by preserving time and options, optimizing your customers' inventory and capital status.

[0054] In one embodiment, assuming 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 equals the target material demand. During this process, two situations may occur: one is that the committed delivery quantity of the Nth committed work order is fully utilized to meet the target material demand; the other is that only a portion of the committed delivery quantity of the Nth committed work order is used to meet the target material demand.

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

[0056] If the promised delivery quantities of all the promised work orders in the second set of promised work orders are less than the target material demand quantity, then based on all the promised work orders in the second set of promised work orders, 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 promised delivery quantities of all the promised 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.

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

[0058] Step S421: Obtain a first expected delivery quantity of a first committed work order.

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

[0060] 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 promised materials in the first committed work order.

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

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

[0063] 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, the first expected delivery quantity is determined as the current first supply quantity, and the corresponding first committed material is determined as the current first supply material. The difference between the target material demand and the first expected delivery quantity is determined as the current second supply quantity, and the corresponding second committed material is determined as the current second supply material.

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

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

[0066] The first and second committed work orders refer to the first and second work orders in the second committed work order set after all work orders are sorted. Of course, if the committed delivery quantities of the first and second work orders do not meet the target material demand, the third, fourth, and final work orders can be selected. There is no specific limit to this, and the selection process can be adaptively adjusted based on the target material demand.

[0067] In one embodiment, when the current inventory is not 0 but cannot meet the target material demand, the supply allocation information is determined based on the current inventory first, and then the remaining supply allocation information is determined based on the committed work order set.

[0068] like Figure 4 In a specific embodiment, the method further includes the following steps.

[0069] Step S2', obtaining the current inventory of the target material, and when the current inventory is less than the target material demand, determining the current inventory as the current supply, generating first supply allocation information according to the current supply of the target material, and updating the target material demand.

[0070] Step S3: Obtain committed material information in the first committed work order set, determine committed work orders corresponding to committed materials that can replace the target material, and obtain a second committed work order set.

[0071] Step S41 : Based on the updated target material demand quantity, second supply allocation information of the target material is determined according to the expected delivery time and expected delivery quantity corresponding to the committed work orders in the second committed work order set.

[0072] Step S42: combining the first supply allocation information and the second supply allocation information to determine supply allocation information for the customer.

[0073] In this way, by giving priority to using existing inventory to meet customer needs, and then using committed work orders to replenish inventory when it is insufficient, we can ensure the timeliness and flexibility of supply.

[0074] For example, assuming that the customer's demand order is as shown in Table 1 above, based on the work order situation shown in Table 2 (a), the universal strategy supply allocation method used in the existing technology is selected, and the supply allocation information is determined according to the priority order of the work order or material type and the universality of the material. The corresponding supply allocation information is shown in Table 2 (b) below.

[0075] Table 2(a)

[0076]

[0077] In Table 2(a), an Advance Shipping Notice (ASN) indicates a supplier's planned and issued advance notice regarding upcoming shipments. Specifically, it refers to detailed information about the goods sent by the product shipper (Supplier 1's transporter) to the warehouse prior to shipment. In this disclosure, an ASN can be considered a status of inventory that is about to arrive or is already in transit, representing a supply type of "expected inventory" or "in-transit inventory."

[0078] In Table 2(a), a purchase order (PO) is a document that documents the agreement between the buyer and seller of goods. It records key information such as at least one of the following: the type, quantity, or price of the material being purchased. A PO is a purchase order issued by the purchasing department to the supplier based on the results of Material Requirement Planning (MRP) calculations.

[0079] MRP calculates the material demand and expected delivery time for a period of time based on information such as production plans, inventory status, and bills of materials. This calculation results will serve as the basis for procurement, production, and inventory management.

[0080] Table 2(b)

[0081]

[0082] The material information or work order information shown in Table 2(a) all meet the requirements of the demand order shown in Table 1. The material supply type and corresponding total quantity are prioritized for selection. The first record that meets the target material demand is selected, namely, material A with an ASN supply type and a quantity of 100. At this point, a quantity of 20 is still missing. Either material A with a PO type or material B with a PO type in Table 2(a) can be used. If the material types are the same (both are PO), the material supply selection is determined based on the material's versatility. Assuming that material A has a higher versatility index than material B, material A with higher versatility is selected. That is, material A with a quantity of 20 corresponding to the PO type is selected. That is, based on the methods used in the prior art, the supply allocation information shown in Table 2(b) can be obtained.

[0083] The supply sequence shown in Table 2 (b) prioritizes selection based on the material supply type and the corresponding total quantity, and is assisted by a universal strategy. This will result in the supply allocation information within a certain period of time being concentrated on the supply of a certain alternative branch for consumption, which in turn causes the supply situation to be concentrated on a certain material or a certain supplier within a period of time, which is inconsistent with the actual set procurement ratio, resulting in an uneven distribution of subsequent material consumption forecasts.

[0084] It should be noted that because the minimum package or order quantity, as well as the number of days required for combined purchases, are considered during the development of purchase orders (POs) or purchase requisitions (PRs), the quantity procured is likely to exceed actual demand. This ensures procurement efficiency and cost-effectiveness. CMT, on the other hand, responds to commitments in batches based on the supplier's actual production capacity. Therefore, in terms of quantity and timeframe, it more closely reflects actual physical consumption and demand.

[0085] Based on this, the present invention introduces CMT into material supply allocation, using committed work orders that meet demand before the expected delivery time for supply allocation, as shown in Table 3(a). Table 3(a) shows all committed work orders and current available inventory information (including ASN-type materials) corresponding to committed materials that meet the target material requirement before the expected delivery time in the demand order.

[0086] Based on the information shown in Table 3(a), if available inventory materials are available, priority is given to consuming the currently available inventory materials. This refers to the first record in Table 3(a): Material A, material type ASN, and quantity 100. This generates the corresponding first supply allocation information based on the currently available inventory materials, as shown in Table 3(b). Specifically, Material A, with a quantity of 100 and a supply type ASN, is selected. If the currently available inventory materials do not meet the target material demand, a second set of commitment work orders is obtained based on the expected delivery times in Table 1 and Table 3(a).

[0087] Table 3(a)

[0088]

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

[0090] Table 3(b)

[0091]

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

[0093] Specifically, we prioritize work orders based on their promised delivery times, prioritizing those with promised delivery times farther from the expected delivery time. Based on the target material demand and the promised delivery quantity of each work order, we determine the corresponding N promised work orders. Based on these N promised work orders, we determine the corresponding supply allocation information, as shown in Table 3(b). This allows us to correct and optimize inventory status to meet supply demand by rationally handling backlogs and procuring new materials.

[0094] Understandably, it takes two to three days from MRP calculation, production, forecast release, and supplier response to the CMT. During this time, new actual deliveries may occur, causing the expected delivery volume represented by the CMT to no longer reflect the current situation. This is because some goods may have already been delivered. Based on this, the corresponding information of some commitment work orders needs to be updated.

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

[0096] Step P41, obtain the first moment when the merchant sends the material demand work order to the supplier, and the second moment when the merchant receives the corresponding commitment work order.

[0097] Step P42: Update and determine the expected delivery quantity of the committed work orders in the current second committed work order set based on the current purchase quantity of the 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.

[0098] Step S4': Determine the supply allocation information for the customer based on the updated second committed work order set and the current target material demand.

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

[0100] Step P421: Obtain 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.

[0101] Step P422: Calculate the sum of the actual delivery quantity and the in-transit supply quantity based on the actual delivery work order and the in-transit supply work order to determine the first quantity.

[0102] Step P423: Calculate the difference between the expected delivery quantity in the current committed work order and the first quantity to determine the second quantity.

[0103] Step P424: Update and determine the expected delivery quantity of the corresponding committed work order based on the current purchase quantity of the target material and the second quantity.

[0104] In this way, the committed delivery quantity of the committed work order is precisely adjusted and optimized to ensure that it is highly consistent with the actual material flow, order status and procurement needs.

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

[0106] Furthermore, the material demand calculated by MRP is subtracted from the current inventory and in-transit material (including ASNs and confirmed but undelivered CMTs) to arrive at the corresponding demand gap, which is filled by placing new POs. If the number of CMTs exceeds the number of POs already issued, and the excess CMTs are included in the MRP calculation, the excess CMTs are mistakenly considered as scheduled supply, thereby reducing the actual demand gap. As the actual demand gap decreases, procurement will correspondingly reduce the issuance of new POs, resulting in the actual material quantity arriving possibly failing to meet the target material demand and production needs, leading to production delays or inventory shortages.

[0107] To avoid this situation, when calculating actual demand, the CMT exceeding the PO portion is correctly identified and excluded. Based on this, in a specific embodiment, step P424 may specifically include the following steps.

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

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

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

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

[0112] Specifically, if Figure 6 As shown, first, exclude the quantity of materials that have been actually delivered, that is, those materials that have been purchased and put into storage from the start of MRP calculation time to the current moment, because these materials no longer need CMT for commitment management because they have completed the delivery process.

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

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

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

[0116] Step S41: Obtain the promised materials of the promised work orders in the second committed work order set.

[0117] Step S42: determining the priority of each promised work order according to at least one of the priority and versatility of the promised materials.

[0118] Step S43 : setting an allocation order for the committed work orders with the same expected delivery time in the second committed work order set according to the priority, so as to determine supply allocation information to the customer.

[0119] In step S42, the priority of the promised material refers to whether the promised material is the main material or the substitute material. When faced with two promised work orders with the same expected delivery time, the work order with the promised material as the main material is selected first.

[0120] The versatility of a committed material refers to the property that the material can be used in different products or production lines. When faced with the same expected delivery time, committed materials with a higher versatility index are given priority.

[0121] Furthermore, when faced with two commitment work orders with the same expected delivery time and the same priority of materials, the material with the higher universality index is preferred. For example, if material A is used in three products and material B is used in ten products, then material B's universality index is higher than that of material A, indicating that material B is more universal.

[0122] like Figure 7 As shown, an embodiment of the present invention provides an electronic device 200.

[0123] The electronic device 200 may specifically be a computer device, which may be a terminal device or a server.

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

[0125] Electronic device 200 includes memory. This memory is used to store various types of data to support the operation of electronic device 200. Examples of this data include any computer program used to operate on a computing device. This memory may be a read-only memory (ROM) 22, a random access memory (RAM) 23, or another storage unit 28. This storage unit 28 may be located within or outside of electronic device 200.

[0126] In one embodiment, when the processor executes the computer program stored in the memory, the steps of the material supply allocation method in any technical solution of the present invention are performed.

[0127] In one embodiment, electronic device 200 includes a central processing unit (CPU) 21, which can execute various appropriate actions and processes based on programs stored in read-only memory (ROM) 22 or programs loaded from storage unit 28 into random access memory (RAM) 23. RAM 23 also stores various programs and data required for system operation. CPU 21, ROM 22, and RAM 23 are interconnected via a bus 24. An input / output (I / O) interface 25 is also connected to bus 24.

[0128] The following components are connected to the input / output interface 25: an input section 26 including a keyboard, mouse, and the like; an output section 27 including devices such as a cathode ray tube (CRT), a liquid crystal display (LCD), and speakers; a storage section 28 including a hard disk; and a communication section 29 including a network interface card such as a local area network card or a modem. The communication section 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. Removable media 211, such as a magnetic disk, an optical disk, a magneto-optical disk, or a semiconductor memory, is installed in the drive 210 as needed, so that computer programs read from the media can be installed in the storage section 28 as needed.

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

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

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

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

[0133] In summary, the material supply allocation method, electronic device, and storage medium provided by the present invention obtain a demand order from a customer, determine the target material, the target material demand, and the expected delivery time, and when the current inventory is less than the target material demand, obtain a first set of commitment work orders with an expected delivery time equal to or earlier than the expected delivery time, and also take the supply commitment work orders in the second set of commitment work orders into consideration when allocating demand, to ensure that the supply and demand of the target material are optimally matched in time, so that even if a certain production material or substitute material has an advantage in quantity, it will not be over-selected if its promised delivery time does not meet the demand or the delivery quantity cannot meet the allocation requirements, thereby avoiding excessive concentration of material demand, achieving balanced supply and consumption, and avoiding production interruptions or inventory backlogs caused by insufficient or excessive material supply.

[0134] It should be understood that although this specification is described in terms of implementation methods, not every implementation method contains only one independent technical solution. This narrative method of the specification is only for the sake of clarity. Those skilled in the art should regard the specification as a whole. The technical solutions in each implementation method can also be appropriately combined to form other implementation methods that can be understood by those skilled in the art.

[0135] The series of detailed descriptions listed above are only specific descriptions of feasible implementation methods of the present invention. They are not intended to limit the scope of protection of the present invention. Any equivalent implementation methods or changes that do not deviate from the technical spirit of the present invention should be included in the scope of protection of the present invention.

Claims

1. A material supply distribution method, characterized in that: include: Obtain demand orders from customers, determine target materials, target material demand quantities, and expected delivery time; Obtaining a current inventory of the target material, and when the current inventory is less than the target material demand, obtaining a first set of committed work orders from suppliers, where the expected delivery time of the work orders in the first set of committed work orders 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 that can replace the target material, and obtaining a second committed work order set; Determine the supply allocation information to the customer based on the second committed work order set; The step of determining the supply allocation information to the customer based on the second committed work order set includes: Obtaining the generation status of the promised materials in the second set of promised work orders, and sorting the work orders in the second set of promised work orders according to the expected delivery time of the promised materials; Based on the committed delivery quantity of each work order in the second committed work order set after sorting, determine the top N committed work orders; based on the top N committed work orders, determine the supply allocation information for providing the target material to the customer; the sum of the expected delivery quantities of the top N committed work orders is less than or equal to the target material demand, N>0, and N is an integer.

2. The material supply and distribution method according to claim 1, characterized in that: Determining the supply allocation information of target materials to customers based on the first N committed work orders includes: Obtain the first expected delivery volume of the first committed work order; Determining whether the first expected delivery quantity is greater than or equal to the target material demand quantity; If so, the target material demand quantity is determined as the current supply quantity, and supply allocation information is generated according to the current supply quantity and the committed materials in the first committed work order.

3. The material supply and distribution method according to claim 2, characterized in that: 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, obtain the second expected delivery quantity of the second committed 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; 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, the first expected delivery quantity is determined as the current first supply quantity, and the corresponding first committed material is determined as the current first supply material; and the difference between the target material demand and the first expected delivery quantity is determined as the current second supply quantity, and the corresponding second committed material is determined as the current second supply material; The supply allocation information is generated according to the current first supply quantity and the current first supply material, the current second supply quantity and the current second supply material.

4. The material supply and distribution method according to claim 1, characterized in that: Before obtaining the first committed work order set from the supplier, the method further includes: The current inventory quantity is determined as the current supply quantity, first supply allocation information is generated according to the current supply quantity of the target material, and the target material demand quantity is updated and determined.

5. The material supply and distribution method according to claim 4, characterized in that: Determining the supply allocation information to the customer based on the second committed work order set includes: Based on the updated target material demand, determine the second supply allocation information of the target material according to the expected delivery time and expected delivery quantity corresponding to the committed work orders in the second committed work order set; The first supply allocation information and the second supply allocation information are combined to determine supply allocation information for the customer.

6. The material supply and distribution method according to claim 1, characterized in that: Before determining the supply allocation information to the customer based on the second committed work order set, the method further includes: Obtain the first moment when the merchant sends the material demand work order to the supplier, and the second moment when the merchant receives the corresponding commitment work order; Update and determine the expected delivery quantity of the committed work orders in the current second committed work order set based on the current purchase quantity of the 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 based on the second committed work order set includes: Determine the supply allocation information to the customer based on the updated second commitment work order set and the current target material demand.

7. The material supply and distribution method according to claim 6, characterized in that: The updating and determining of the expected delivery quantity of the current committed work order based on the current purchase quantity of the 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: Obtain 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; Calculate the sum of the actual delivery quantity and the in-transit supply quantity based on 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 committed work order and the first quantity to determine a second quantity; Based on the current purchase quantity of the target material and the second quantity, the expected delivery quantity of the corresponding committed work order is updated and determined.

8. The material supply and distribution method according to claim 7, characterized in that: The step of determining and updating the expected committed delivery quantity of the corresponding committed work order based on the current purchase quantity of the target material and the second quantity includes: determining whether the purchase quantity is greater than the second quantity; If yes, the difference between the purchase quantity and the second quantity is used as the expected delivery quantity and updated to the corresponding commitment work order; If not, the second quantity will be used as the expected delivery quantity and updated to the corresponding commitment work order.

9. The material supply and distribution method according to claim 1, characterized in that: Determining the supply allocation information to the customer based on the second committed work order set includes: Obtain the promised materials of the promised work orders in the second promised work order set; Determine the priority of each commitment work order based on at least one of the priority and commonality of the committed materials; An allocation order is set for the committed work orders with the same expected delivery time in the second committed work order set according to the priority to determine supply allocation information to the customer.

10. An electronic device comprising: at least one processor; A memory storing a computer program that can be run on the processor, wherein the processor executes the steps of the material supply and distribution method according to any one of claims 1 to 9 when executing the program.

11. A computer storage medium, wherein the computer readable storage medium stores a computer program, characterized in that: When the computer program is executed by a processor, the steps of the material supply allocation method according to any one of claims 1 to 9 are performed.

Images