Material procurement allocation method, system and storage medium

Abstract

The present invention provides a material procurement allocation method, system, and storage medium, comprising: obtaining a preset procurement ratio for N materials used to prepare a target product; upon determining that M direct-sale materials are included in the N materials, obtaining the overall demand for the other N-M materials; and determining the actual procurement ratio among the N-M materials based on the overall demand and the procurement ratios among the N-M materials in the preset procurement ratios, such that the sum of the ratio values ​​of the N-M materials matches the actual demand, where N>M>0, and N and M are both integers. By eliminating the influence of direct-sale materials on procurement allocation, this method can more accurately calculate and adjust the procurement ratios of other materials, thereby ensuring the stability of the supply chain and the balance of material supply, effectively avoiding the problem of imbalanced material ratios, and improving the flexibility and accuracy of supply chain management.

Description

Technical Field

[0001] The present invention relates to the technical field of material supply, and in particular to a material procurement and distribution method, system and storage medium. Background Art

[0002] In modern supply chain management systems, precise control of procurement ratios is crucial for ensuring smooth production processes and optimizing material inventory. However, in real-world scenarios, particularly in the complex environments of KD (knocked down) operations, correcting procurement ratios presents a host of challenges.

[0003] Under the KD business model, companies typically purchase and store products in multiple components or parts for assembly when needed. This business model increases the complexity of material management, as the procurement ratio of different components can be affected by a variety of factors, including but not limited to market demand, production plans, and supply chain stability.

[0004] Specifically, when companies procure materials based on a specific ratio, the introduction of KD (Keeper Delivery) can lead to an imbalance in this ratio. In particular, when placing an order for a large quantity of KD parts for a particular material, adjusting the ratio based on the order quantity can result in the revised quantities for other materials far exceeding actual demand. In this case, if actual demand is significantly lower than the revised quantity, some materials may be over-revisioned, while others, due to insufficient revisions, remain unordered.

[0005] This imbalance in procurement ratios not only impacts supply chain stability but can also lead to inventory backlogs and waste, increasing a company's operating costs. Therefore, how to properly adjust procurement ratios in KD business scenarios to ensure balanced material procurement and supply chain stability has become a pressing issue in current supply chain management and procurement strategies. Summary of the Invention

[0006] One of the purposes of the present invention is to provide a material procurement allocation method to solve the technical problem in the prior art that the material allocation rules do not match the actual demand, resulting in a situation where a certain material has not been purchased for a long time, resulting in an imbalance in the procurement of different materials.

[0007] One of the objectives of the present invention is to provide a material procurement and distribution system.

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

[0009] In order to achieve one of the above-mentioned purposes of the invention, the present invention provides a material procurement allocation method, including: obtaining a preset procurement ratio of N materials used to prepare a target product; when determining that M direct-sale materials are included in the N materials, obtaining the overall demand for the other NM materials; determining the actual procurement ratio between the NM materials based on the overall demand and the procurement ratio between the NM materials in the preset procurement ratio, so that the sum of the ratio values ​​of the NM materials matches the actual demand, N>M>0, and N and M are both integers.

[0010] As a further improvement of an embodiment of the present invention, the method also includes: when determining that M direct-sale materials are included in N materials, the current purchase quantity of the M direct-sale materials is also obtained, and the target purchase quantity of the other NM materials is determined based on the current purchase quantity of the M direct-sale materials and the ratio between the NM materials in the preset purchase ratio; the target purchase quantity makes the ratio between the NM materials and the M materials conform to the preset purchase ratio; the relationship between the target purchase quantities of the NM materials indicates the proportional relationship between the NM materials; based on the overall demand for the NM materials and the target purchase quantity of the NM materials, the actual purchase ratio between the NM materials is determined.

[0011] As a further improvement to an embodiment of the present invention, the M types of direct-sale materials include a first direct-sale material; determining the target purchase quantities of the other NM types of materials based on the current purchase quantities of the M types of direct-sale materials and the ratios between the NM types of materials in the preset purchase ratio includes: determining corresponding multiple ratio values ​​based on the ratio relationship between each of the NM types of materials and the first direct-sale material in the preset purchase ratio;

[0012] Get the current purchase quantity of the first direct-sale material, calculate the product of each ratio value and the current purchase quantity, and get the target purchase quantity of each of the NM materials.

[0013] As a further improvement of an embodiment of the present invention, the actual procurement ratio between NM materials is determined based on the overall demand and the procurement ratio between the NM materials in the preset procurement ratio, including: judging whether the overall demand for NM materials is less than the target procurement quantity of NM materials, and / or judging whether the overall demand for NM materials is less than the sum of the target procurement quantities of NM materials; if so, allocating the overall demand for NM materials according to the relationship between the target procurement quantities of NM materials, obtaining the actual procurement quantity of NM materials, and determining the actual ratio based on the relationship between the actual procurement quantities.

[0014] As a further improvement of an embodiment of the present invention, after determining whether the overall demand for NM materials is less than the target purchase quantity of NM materials, and / or determining whether the overall demand for NM materials is less than the sum of the target purchase quantities of NM materials, the method further includes: if not, completing the historical purchase complete quantity of some materials in the NM materials based on the remaining complete quantity of historically purchased materials of each material in the NM materials and the purchase ratio between the NM materials, to obtain the actual purchase quantity of the NM materials, and determining the actual ratio based on the relationship between the actual purchase quantities.

[0015] As a further improvement to an embodiment of the present invention, the method of completing the historically purchased complete quantity of some materials in the NM materials based on the remaining complete quantity of historically purchased materials of each material in the NM materials and the purchase ratio between the NM materials to obtain the actual purchase quantity of the NM materials includes:

[0016] According to the procurement ratio between NM types of materials and the maximum value of the remaining complete quantities of historically purchased materials among the NM types of materials, the historically purchased complete quantities of the remaining materials are supplemented to obtain the required complete quantities of the NM types of materials to be supplemented; when the overall demand for the NM types of materials is greater than the sum of the corresponding required complete quantities to be supplemented, the remaining overall complete quantities of the NM types of materials are allocated according to the procurement ratio between the NM types of materials, and the remaining overall complete quantity is equal to the difference between the overall demand and the sum of all required complete quantities to be supplemented; according to the allocation results of the required complete quantities of the NM types of materials to be supplemented and the corresponding remaining overall complete quantities of the NM types of materials, the actual procurement quantity of the NM types of materials is determined.

[0017] As a further improvement of one embodiment of the present invention, the actual purchase quantity of NM materials is determined based on the allocation results of the required complete quantities of NM materials to be replenished and the corresponding remaining total complete quantities of the NM materials, including: calculating the sum of the allocation results of the remaining total complete quantities of each material in the NM materials and the corresponding required complete quantities to be replenished, to obtain the total required complete quantities of the corresponding materials; calculating the unit usage of each material in the NM materials and the product of the corresponding total required complete quantities, to determine the actual purchase quantity of each material in the NM materials.

[0018] As a further improvement of an embodiment of the present invention, before completing the historical purchase complete quantity of NM materials based on the remaining complete quantity of historically purchased materials of each of the NM materials and the purchase ratio between the NM materials to obtain the actual purchase quantity of the NM materials, the method also includes: obtaining the historical purchase quantity and corresponding unit usage of each of the NM materials used to prepare the target product; calculating the historical purchase quantity and the corresponding unit usage to determine the remaining complete quantity of historical purchases of the material.

[0019] In order to achieve one of the above-mentioned purposes of the invention, the present invention also provides a material procurement and allocation system for executing any one of the material procurement and allocation methods, and the material procurement and allocation system includes: a first module, used to obtain the preset procurement ratio of N materials for preparing the target product, and when determining that the N materials include M direct-sale materials, obtain the overall demand for the other NM materials; a second module, used to determine the actual procurement ratio between the NM materials based on the overall demand and the procurement ratio between the NM materials in the preset procurement ratio, so that the sum of the ratio values ​​of the NM materials matches the actual demand.

[0020] 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 procurement allocation method described in any of the above-mentioned technical solutions are executed.

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

[0022] The present invention adopts a material procurement and allocation method, which obtains the preset procurement ratio of N materials used to prepare the target product, and when it is determined that M direct-sale materials are included in the N materials, obtains the overall demand for the other NM materials, and adjusts the actual procurement ratio of these materials accordingly. By excluding the influence of direct-sale materials on procurement allocation, this method can more accurately calculate and adjust the procurement ratio of other materials, thereby ensuring the stability of the supply chain and the balance of material supply, effectively avoiding the problem of imbalance in the proportion of materials in the procurement process, and improving the flexibility and accuracy of supply chain management. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] Figure 1 It is a schematic diagram of the steps of a material procurement allocation method in one embodiment of the present invention.

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

[0025] Figure 3 3 is a schematic diagram of step S3 in one embodiment of the present invention.

[0026] Figure 4 This is a schematic diagram of steps before step S32B in a specific embodiment of an embodiment of the present invention.

[0027] Figure 5 This is a schematic diagram of step S32B in a specific embodiment of an embodiment of the present invention. DETAILED DESCRIPTION

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

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

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

[0031] Step S1: Obtaining a preset purchase ratio of N types of materials for preparing a target product.

[0032] Step S2: When it is determined that the N types of materials include M types of direct-sale materials, the total demand for the other NM types of materials is obtained.

[0033] Step S3, determining the actual procurement ratio among the NM materials according to the overall demand and the procurement ratio among the NM materials in the preset procurement ratio, so that the sum of the ratio values ​​of the NM materials matches the actual demand.

[0034] In this way, by obtaining the preset procurement ratio of N materials used to prepare the target product, and when determining that M direct-sale materials are included in the N materials, the overall demand for the other NM materials is obtained, and the actual procurement ratio of these materials is adjusted accordingly. This method can more accurately calculate and adjust the procurement ratio of other materials by excluding the impact of direct-sale materials on procurement allocation, thereby ensuring the stability of the supply chain and the balance of material supply, effectively avoiding the problem of imbalance in the proportion of materials in the procurement process, and improving the flexibility and accuracy of supply chain management.

[0035] In step S1, the pre-set procurement ratio refers to the share of different suppliers or materials that the enterprise pre-determines before procurement begins, based on factors such as business needs, supplier capabilities, and material characteristics. The pre-set procurement ratio reflects the relative importance and demand relationship between various materials.

[0036] Specifically, in one embodiment, the pre-set procurement ratio refers to the ratio of the number of orders placed by an enterprise to a number of suppliers to produce a target product during the normal procurement process to the total number of orders for the same type of product. This reflects the distribution of orders among multiple suppliers and is an important indicator for measuring the degree of supplier cooperation and the effectiveness of procurement strategies.

[0037] In another embodiment, the preset purchase ratio may also refer to the ratio of the order quantity of each material to the total purchase order quantity when the enterprise purchases different materials for preparing the target product. This helps the enterprise optimize material inventory management and ensure a balanced supply of materials required for production.

[0038] In the above embodiment, the materials corresponding to the preset procurement ratio can be the procurement quantity ratio of N essential materials required for producing a target product. Alternatively, it can be the procurement quantity ratio of the main material and the substitute material when producing a target product, which is not specifically limited in the present invention.

[0039] For example, suppose the production of a target product requires three materials: Material A, Material B, and Material C. The corresponding procurement ratio is A:B:C = 30:65:5. This procurement ratio can be understood as meaning that for every 100 units of the target product, 30 units of Material A, 65 units of Material B, and 5 units of Material C are required. Alternatively, Materials A and B can be considered the primary materials for the production of the target product, while Material C is considered an alternative or backup material. Under normal circumstances, the procurement volumes of primary Materials A and B are large, accounting for 30% and 65% of the total procurement volume, respectively, while the procurement volume of alternative Material C is relatively small, accounting for only 5%.

[0040] In step S2, direct-sale materials refer to materials that can be sold directly to customers. These materials may be finished products, semi-finished products, or components, including at least one of direct purchase and sales. In supply chain management, direct-sale materials have clear sales targets and sales channels. Their procurement and inventory management are relatively independent, but they can significantly impact the procurement ratio of other materials used to prepare the target product.

[0041] For the purposes of this disclosure, direct-sale materials can be understood as a specific form of the KD business, specifically referring to KD materials imported in bulk or knocked-down form. KD business can include at least one of SKD (Semi-Knocked Down) and CKD (Completely Knocked Down). SKD refers to imported core components, modules, and other electronic parts that are partially assembled domestically to create a complete product. CKD, on the other hand, refers to imported equipment that arrives in a completely disassembled state. Domestic manufacturers must receive these components and perform detailed assembly and integration to create the final product.

[0042] In the KD (knockdown / compact) business, companies need to source various parts from multiple suppliers and assemble them domestically. To reduce logistics costs and improve assembly efficiency, companies may prefer to purchase large quantities of KD materials at once to maintain supply chain continuity and stability during the assembly process.

[0043] For this reason, the purchase volume of direct-sale materials is often large. To maintain the original purchase ratio, the purchase quantities of other materials are calculated and adjusted. However, when this adjustment is too large, and the current actual demand is far less than the adjusted quantity, a problem arises: when attempting to balance the ratio by increasing the purchase volume of other materials, due to limited actual demand, this additional purchase volume is often unable to be absorbed, resulting in a persistent imbalance in the purchase ratio. If this imbalance persists, it may even lead to a long period of no new purchase orders for a certain material, which in turn affects the stability of the entire supply chain and the company's production efficiency.

[0044] For example, continuing with the procurement ratio of A:B:C = 30:65:5 (N = 3), assume that in a KD business scenario, material C (M = 1) is a direct-sale material, and the corresponding designated order quantity of material C is 1,000k. To maintain this procurement ratio, the procurement quantities of materials A and B are adjusted. The adjusted quantity of material A is 1,000k / 5*30 = 6,000k, and the adjusted quantity of material B is 1,000k / 5*65 = 13,000k. These adjusted procurement quantities (6,000k and 13,000k) are calculated based on the designated order quantity of material C (1,000k) and the preset ratio. They do not represent actual demand at this time or in the future. When the actual demand (for example, the total demand for material A and material B is 10k) is much lower than the revised purchase quantity, material A will be purchased first to meet this larger revised purchase quantity, which may cause the actual order quantity of material B to be shelved or postponed for a long time, resulting in an imbalance in the ratio between material A and material B.

[0045] In step S3, the actual demand refers to the actual demand for the target product. The actual demand for each material is determined based on this actual demand and the BOM (Bill of Materials) information for the target product. The procurement ratios among the NM materials are determined based on the actual demand for each of the NM materials. In other words, for the NM materials, regardless of the specific number of types (e.g., three or two), the procurement ratios are allocated based on their respective actual demand, but the sum of these ratios always equals 100% (or any arbitrary sum, for ease of understanding). Therefore, for three materials, the procurement ratios might be 20%:30%:50%; for two materials, the corresponding ratios might be 40%:60%.

[0046] In step S3, "the sum of the proportion values ​​matches the actual demand" means that when purchasing NM types of materials according to the actual purchasing proportion determined above, the total amount of these materials should just meet the overall demand calculated in step S2.

[0047] like Figure 2 As shown, in one embodiment, step S2 of the present invention may specifically include the following steps.

[0048] Step S21, when determining that M direct-sale materials are included in N materials, the current purchase quantity of the M direct-sale materials is also obtained, and the target purchase quantity of the other NM materials is determined based on the current purchase quantity of the M direct-sale materials and the ratio between the NM materials in the preset purchase ratio.

[0049] Step S22: determining the actual purchase ratios among the NM materials according to the total demand for the NM materials and the target purchase quantities of the NM materials.

[0050] In this way, by first determining the purchase quantity of direct-sale materials, and then calculating the purchase quantity of other materials based on this, and determining the purchase quantity according to the proportional relationship between materials, it is helpful to achieve a reasonable allocation of resources and avoid excessive purchase of certain materials and shortage of other materials.

[0051] The target procurement quantities ensure that the ratio between the NM materials and the M materials meets the preset procurement ratio. The relationship between the target procurement quantities of the NM materials indicates the proportional relationship between the NM materials. In other words, during each procurement process, the actual procurement ratio approaches or equals the preset procurement ratio.

[0052] In step S21, the total demand refers to the total required quantity of all NM materials. The target purchase quantity is the theoretically required quantity of the NM materials, calculated based on the preset purchase ratio and the purchase quantity of the M direct-sale materials. In other words, it reflects the desired purchase quantity for the NM materials to ideally meet the total demand.

[0053] In a specific embodiment, the M types of direct-sale materials include the first direct-sale material. Step S21 determines the target purchase quantity of the other NM types of materials based on the current purchase quantity of the M types of direct-sale materials and the ratio between the NM types of materials in the preset purchase ratio, which may specifically include the following steps.

[0054] In step S211, a number of corresponding ratio values ​​are determined according to the ratio relationship between each of the NM types of materials and the first direct-sale material in the preset procurement ratio.

[0055] Step S221, obtain the current purchase quantity of the first direct-sale material, calculate the product of each ratio value and the current purchase quantity respectively, and obtain the target purchase quantity of each material in the NM materials.

[0056] In this way, by correcting the purchase quantity of NM types of materials, their target purchase quantity can be kept in a preset proportional relationship with the current purchase quantity of direct-sale materials, ensuring that they can meet the actual needs of producing target products and ensure the continuity and stability of production.

[0057] like Figure 3 As shown, in one embodiment, step S3 of the present invention may specifically include the following steps.

[0058] Step S31, determining whether the total demand for NM materials is less than the target purchase quantity of NM materials, and / or determining whether the total demand for NM materials is less than the sum of the target purchase quantities of NM materials.

[0059] If so, jump to step S32A, allocate the total demand for NM materials according to the relationship between the target purchase quantities of NM materials, obtain the actual purchase quantity of NM materials, and determine the actual proportion based on the relationship between the actual purchase quantities.

[0060] If not, jump to step S32B, and based on the remaining complete quantity of historically purchased materials of each of the NM materials and the purchasing ratio between the NM materials, make up the complete quantity of historically purchased materials of some of the NM materials to obtain the actual purchase quantity of the NM materials, and determine the actual ratio based on the relationship between the actual purchase quantities.

[0061] In this way, based on the comparison results between the overall demand for NM materials and the target procurement quantity, the actual procurement quantity of NM materials is intelligently adjusted, and a reasonable proportional relationship is ensured between the actual procurement quantities.

[0062] In other embodiments, it is also possible to determine whether the demand for at least one of the NM materials is less than the target purchase quantity of the corresponding material; if so, the overall demand for the NM materials is allocated according to the relationship between the target purchase quantities of the NM materials, the actual purchase quantity of the NM materials is obtained, and the actual proportion is determined based on the relationship between the actual purchase quantities.

[0063] To facilitate understanding of the above steps S31 to S32A, for example, assuming that the preset procurement ratio of the three materials (i.e., N=3) used to prepare the target product is A:B:C=30:65:5, and in the KD scenario, the current procurement quantity of material C (direct sale material) is specified to be 1000k. Based on the procurement ratio of other materials (i.e., material A and material B) in the preset procurement ratio (A:B=30:65), the target procurement quantities of material A and material B are determined to be 6000k and 13000k, respectively.

[0064] The total demand for material A and material B is 10k. Based on the target purchase quantity and the total demand, the actual purchase ratio of material A and material B is calculated. By splitting the total demand of 10k, we get the purchase quantity of material A as 3158 and the purchase quantity of material B as 6842, thus avoiding the imbalance of material procurement ratio.

[0065] like Figure 4 As shown, in a specific embodiment, before step S32B, the method may further include the following steps.

[0066] Step P31, obtaining the historical purchase quantity and corresponding unit usage of each material among the NM materials used to prepare the target product.

[0067] Step P32: Calculate the historical purchase quantity and the corresponding unit usage to determine the remaining complete set quantity of the historical purchase of this material.

[0068] In this way, by obtaining the historical purchase volume and corresponding unit usage of NM materials, we can fully understand the past purchase and usage of each material, and use this data to evaluate the remaining quantity of each material that can be used for future production after meeting production needs.

[0069] In step P31, historical purchase volume refers to the total amount of materials actually purchased by the company to produce the target product over the past period. Unit usage refers to the amount of a material required to produce a unit quantity of the target product. This quantity can be expressed in units of measurement such as weight, volume, or number. For example, if one unit of material A and two units of material B are required to produce one target product, the unit usage of material A is 1, and the unit usage of material B is 2.

[0070] Understandably, in the actual procurement process, due to various factors involved in procurement, transportation, storage, and preparation, it's difficult to ensure that the purchased quantity of each material precisely matches the target product's production requirements. Therefore, over- or under-purchasing of materials is possible. Therefore, in step P32, the remaining complete quantity from historical purchases refers to the quantity of material remaining after the target product's production requirements have been met for a specific period or batch.

[0071] For example, suppose that materials A and B are key materials for producing a target product, and the ratio between them is 1:1 (i.e., one unit of the target product requires one unit of material A and one unit of material B). In a historical purchase, 4k of material A and 4k of material B were purchased. However, due to production adjustments or changes in market demand, only 2k of material A and 4k of material B were actually used. In this case, the remaining 2k of material A and 0k of material B constitute the "remaining complete quantity of the historical purchase."

[0072] like Figure 5 As shown, in a specific embodiment, step S32B is described in which the historical purchase complete quantities of some materials in the NM types of materials are supplemented according to the remaining complete quantity of historically purchased materials of each material in the NM types of materials and the purchase ratio between the NM types of materials to obtain the actual purchase quantity of the NM types of materials, which may specifically include the following steps.

[0073] Step S321: Based on the purchase ratio between the NM materials and the maximum remaining complete set quantity of the NM materials purchased in the past, the complete set quantity of the remaining materials purchased in the past is supplemented to obtain the total required complete set quantity of the NM materials to be supplemented.

[0074] Step S322: When the total demand for NM types of materials is greater than the sum of the corresponding complete quantities to be replenished, the remaining total complete quantities of the NM types of materials are allocated according to the procurement ratio between the NM types of materials. The remaining total complete quantity is equal to the difference between the total demand and the sum of all complete quantities to be replenished.

[0075] Step S323: Determine the actual purchase quantity of the NM types of materials according to the required complete quantity of the NM types of materials to be replenished and the allocation result of the remaining total complete quantity of the corresponding NM types of materials.

[0076] In this way, by comprehensively considering the purchase volume of historical materials, the purchase volume of this material is adjusted, aiming to make the purchase ratio between the NM types of materials purchased this time gradually approach the preset purchase ratio, and ensure that each material remains balanced during the procurement process.

[0077] In step S321, the "complete set quantity" refers to the ratio and total amount of various materials required to ensure a certain number of complete products can be prepared or produced during a procurement or production process. In other words, within a set of materials, each material is purchased or prepared according to a preset ratio to meet the production requirements of one or more complete target products.

[0078] In step S321, the required complete quantity to be replenished refers to the quantity of each material among the NM materials that has not yet reached the complete set state (i.e., complete matching in a certain proportion and quantity) to meet the production or preparation of the target product.

[0079] For example, assuming that material A and material B are key materials for preparing a certain target product, and the ratio between them is 1:2, if the maximum remaining complete quantity of historical purchases is 2k for material A, and the remaining complete quantity of historical purchases of material B is 0, then material B will be replenished, and its corresponding required complete quantity to be replenished is 4k, while the corresponding required complete quantity to be replenished for material A is 0, so the total complete quantity to be replenished is 0+4k=4k.

[0080] In a specific embodiment, step S323 of the present invention may further specifically include the following steps.

[0081] Step S3231, calculate the distribution result of the remaining total complete set quantity of each material in the NM types of materials and the sum of the corresponding required complete set quantity to be replenished, and obtain the total required complete set quantity of the corresponding material.

[0082] Step S3232, calculate the product of the unit usage of each of the NM materials and the corresponding total required complete set quantity, and determine the actual purchase quantity of each of the NM materials.

[0083] In this way, by calculating the distribution results of the remaining overall complete set quantity and the sum of the required complete set quantity to be filled, and determining the actual purchase quantity of each material based on the unit usage of each material and this sum, on the one hand, we can make full use of the materials that have been over-purchased in the past and reduce inventory backlogs and material waste; on the other hand, we can ensure that the quantity of materials purchased this time matches the production plan, avoiding production interruptions or material shortages caused by material imbalance.

[0084] To facilitate understanding of the above-mentioned determination of the actual purchase quantity for each of NM materials based on the remaining complete set of historically purchased materials, let's take an example. The materials required to prepare target product M are two units of material A and one unit of material B. Material A exists from multiple suppliers. Assume that the proportion of material A provided by supplier 1 (let's call it material A1) is 10, the proportion of material A provided by supplier 2 (let's call it material A2) is 20, and the proportion of material B provided by supplier 1 is 30. Furthermore, the demand quantity (i.e., the total demand quantity) for target product M is 16,000, and the historical overorder quantities for materials A1, A2, and B are 0, 4,000, and 0, respectively.

[0085] Based on the historical over-order quantities of materials A1, A2, and B, which are 0, 4k, and 0, respectively, as well as the unit usage of various materials for preparing the target product M, the remaining complete quantities of materials A1, A2, and B are obtained as 0, 4k / 2k=2, and 0, respectively. The maximum value of the remaining complete quantity is used as the reference standard for the replenishment operation, that is, the maximum value of the remaining complete quantity of historically purchased materials is 2k.

[0086] Based on the ratio of material A1, material A2, and material B (10:20:30) and the maximum remaining complete set quantity, the complete set quantities of the remaining materials (A1 and B) purchased in the past are supplemented to obtain the required complete set quantities to be supplemented, that is, 1k for material A1, 0 for material A2, and 6k for material B.

[0087] After completing the historical complete quantity of the remaining materials, calculate the difference between the target product's demand and the total complete quantity to be completed to obtain the remaining net complete quantity required for target product M (i.e., the remaining total complete quantity): 16k - (1k + 6k) = 9k. Allocate the remaining total complete quantity (9k) proportionally according to the procurement ratio of materials A1, A2, and B (10:20:30), resulting in 1k, 2k, and 6k for materials A1, A2, and B, respectively.

[0088] Calculate the total required complete quantity for each material by adding the allocation results for materials A1, A2, and B to the corresponding required complete quantity to be filled. This means that the total required complete quantity for material A1 is 1k + 1k = 2k, the total required complete quantity for material A2 is 0 + 2k = 2k, and the total required complete quantity for material B is 6k + 6k = 12k.

[0089] Assuming the unit quantity of materials A1 and A2 is 2, and the unit quantity of material B is 1, the actual purchase quantity of material A1 is 2*2k = 4k, the actual purchase quantity of material A2 is 2*2k = 4k, and the actual purchase quantity of material B is 1*12k = 12k. Therefore, the actual purchase ratio of materials A1, A2, and B is A1:A2:B = 4k:4k:12k = 1:1:3, which is also the ratio set in this purchase order.

[0090] In one embodiment of the present invention, a material procurement and distribution system is provided.

[0091] The material procurement allocation system may adopt a material procurement allocation method for determining actual procurement ratios of multiple materials used to prepare a target product.

[0092] In one embodiment, the material procurement allocation method can be the embodiment and specific embodiment described above, and the corresponding technical solution settings are referenced to the material procurement allocation system provided by the present invention.

[0093] The material procurement and allocation system includes a first module, which is used to obtain the preset procurement ratio of N materials for preparing the target product, and when it is determined that the N materials include M direct-sale materials, obtain the overall demand for the other NM materials.

[0094] The material procurement allocation system includes a second module, which is used to determine the actual procurement ratio between NM materials based on the overall demand and the procurement ratio between NM materials in the preset procurement ratio, so that the sum of the ratio values ​​of NM materials matches the actual demand.

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

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

[0097] When the processor executes the computer program, it can execute the description of the material procurement 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.

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

[0099] In summary, the material procurement allocation method, system, and storage medium provided by the present invention obtain the preset procurement ratios of N materials used to prepare the target product, and when determining that M direct-sale materials are included in the N materials, obtain the overall demand for the other NM materials, and adjust the actual procurement ratios of these materials accordingly. This method can more accurately calculate and adjust the procurement ratios of other materials by eliminating the impact of direct-sale materials on procurement allocation, thereby ensuring the stability of the supply chain and the balance of material supply, effectively avoiding the problem of material ratio imbalance, and improving the flexibility and accuracy of supply chain management.

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

[0101] 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 procurement allocation method, characterized in that: include: Obtaining the preset purchase ratios of N materials used to prepare the target product; When determining that M direct-sale materials are included in N materials, the total demand for the other NM materials is obtained; wherein direct-sale materials refer to materials sold directly to customers, including at least one of direct purchase and sale; Determine the actual procurement ratios of the NM materials based on the overall demand and the procurement ratios of the NM materials in the preset procurement ratios, so that the sum of the ratios of the NM materials matches the actual demand, where N>M>0, and N and M are both integers; The step of determining the actual procurement ratios of the NM materials based on the overall demand and the procurement ratios of the NM materials in the preset procurement ratios, so that the sum of the ratios of the NM materials matches the actual demand, includes: Determine the target purchase quantity of NM materials based on the current purchase quantity of M direct-sale materials and the ratio between NM materials in the preset purchase ratio; determine the actual purchase ratio between NM materials based on the overall demand for NM materials and the target purchase quantity of NM materials; adjust the actual purchase quantity of NM materials based on whether the overall demand for NM materials is less than the target purchase quantity, and determine the actual purchase ratio based on the relationship between the actual purchase quantities.

2. The material procurement allocation method according to claim 1, characterized in that: The method further comprises: When determining that N types of materials include M types of direct-sale materials, the current purchase quantity of the M types of direct-sale materials is also obtained, and based on the current purchase quantity of the M types of direct-sale materials and the ratio between the NM types of materials in the preset purchase ratio, the target purchase quantity of the other NM types of materials is determined; the target purchase quantity is such that the ratio between the NM types of materials and the M types of materials meets the preset purchase ratio; the relationship between the target purchase quantities of the NM types of materials indicates the proportional relationship between the NM types of materials; According to the overall demand for the NM types of materials and the target purchase quantity of the NM types of materials, the actual purchase ratio between the NM types of materials is determined.

3. The material procurement allocation method according to claim 2, characterized in that: The M types of direct-sale materials include the first direct-sale material; determining the target purchase quantities of the other NM types of materials based on the current purchase quantities of the M types of direct-sale materials and the ratio between the NM types of materials in the preset purchase ratio includes: Determine the corresponding ratio values ​​based on the ratio between each of the NM materials in the preset procurement ratio and the first direct-sale material; Get the current purchase quantity of the first direct-sale material, calculate the product of each ratio value and the current purchase quantity, and get the target purchase quantity of each of the NM materials.

4. The material procurement allocation method according to claim 1, characterized in that: The determining the actual procurement ratio among the NM kinds of materials according to the overall demand and the procurement ratio among the NM kinds of materials in the preset procurement ratio includes: Determine whether the total demand for NM materials is less than the target purchase quantity of NM materials, and / or determine whether the total demand for NM materials is less than the sum of the target purchase quantities of NM materials; If so, the overall demand for NM materials is allocated according to the relationship between the target purchase quantities of NM materials, the actual purchase quantities of NM materials are obtained, and the actual proportion is determined based on the relationship between the actual purchase quantities.

5. The material procurement allocation method according to claim 4, characterized in that: After determining whether the total demand for the NM materials is less than the target purchase quantities of the NM materials, and / or determining whether the total demand for the NM materials is less than the sum of the target purchase quantities of the NM materials, the method further includes: If not, then based on the remaining complete quantity of historically purchased materials of each of the NM materials and the purchase ratio between the NM materials, the complete quantity of historically purchased materials of some of the NM materials is supplemented to obtain the actual purchase quantity of the NM materials, and the actual ratio is determined based on the relationship between the actual purchase quantities.

6. The material procurement allocation method according to claim 5, characterized in that: The method of completing the historical purchase quantity of some of the NM materials based on the remaining complete quantity of historically purchased materials of each of the NM materials and the purchase ratio between the NM materials to obtain the actual purchase quantity of the NM materials includes: Based on the procurement ratio between NM materials and the maximum remaining complete set quantity of historically purchased materials among the NM materials, the complete set quantities of the remaining materials purchased in the past are supplemented to obtain the required complete set quantities of the NM materials to be supplemented. When the total demand for NM materials is greater than the sum of the corresponding complete set quantities to be replenished, the remaining total complete set quantities of the NM materials are allocated according to the procurement ratio between the NM materials. The remaining total complete set quantity is equal to the difference between the total demand and the sum of all the complete set quantities to be replenished. The actual purchase quantity of NM materials is determined based on the allocation results of the required complete set quantity of NM materials to be replenished and the remaining overall complete set quantity of the corresponding NM materials.

7. The material procurement allocation method according to claim 6, characterized in that: The actual purchase quantity of the NM materials is determined based on the allocation results of the required complete set quantities of the NM materials to be replenished and the remaining complete set quantities of the corresponding NM materials, including: Calculate the remaining total complete quantity allocation of each material among the NM materials and the sum of the corresponding required complete quantity to be replenished, and obtain the total required complete quantity of the corresponding material; Calculate the product of the unit usage of each of the NM materials and the corresponding total required complete set quantity to determine the actual purchase quantity of each of the NM materials.

8. The material procurement allocation method according to claim 5, characterized in that: Before completing the historically purchased complete quantity of the NM materials based on the remaining complete quantity of historically purchased materials of each of the NM materials and the purchase ratio between the NM materials to obtain the actual purchase quantity of the NM materials, the method further includes: Obtain the historical purchase quantity and corresponding unit usage of each of the NM materials used to prepare the target product; Calculate the historical purchase quantity and the corresponding unit usage to determine the remaining complete set quantity of the historical purchase of this material.

9. A material procurement allocation system for executing the material procurement allocation method according to any one of claims 1 to 8, characterized in that: The material procurement and distribution system includes: The first module is used to obtain the preset purchase ratios of N materials for preparing the target product, and when it is determined that the N materials include M direct-sale materials, obtain the total demand for the other NM materials; where direct-sale materials refer to materials sold directly to customers, including at least one of direct purchase and sale; The second module is used to determine the target purchase quantity of NM materials based on the ratio between the current purchase quantity of M direct-sale materials and the preset purchase ratio of NM materials; to determine the actual purchase ratio among NM materials based on the overall demand for NM materials and the target purchase quantity of NM materials; to adjust the actual purchase quantity of NM materials based on whether the overall demand for NM materials is less than the target purchase quantity, and to determine the actual purchase ratio based on the relationship between the actual purchase quantities.

10. A computer storage medium, wherein a 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 procurement allocation method according to any one of claims 1 to 8 are performed.

Images