Material procurement information pre-matching method and device
By pre-matching and screening based on customer priority and inventory conditions in the procurement of materials for the power distribution network, the problem of low matching efficiency in the existing technology has been solved, a more efficient material procurement process has been achieved, and the construction supervision needs have been met.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- STATE GRID HEBEI ELECTRIC POWER CO LTD
- Filing Date
- 2023-09-25
- Publication Date
- 2026-06-02
Smart Images
Figure CN117349485B_ABST
Abstract
Description
Technical Field
[0001] This application belongs to the field of material matching technology, and in particular relates to a method and apparatus for pre-matching material procurement information. Background Technology
[0002] Most power distribution network materials are procured using a negotiated inventory procurement model. After selecting contracted suppliers, this model involves providing the required quantities of products in batches via delivery orders or by requiring suppliers to deliver within specified timeframes, based on actual needs. Negotiated inventory procurement effectively integrates procurement resources, improves bidding efficiency, and enhances the return on power grid investment. However, when project management submits material requirements, they undergo multi-level approval processes before the materials company matches them to the negotiated inventory. Matching failures are frequent, necessitating modifications to the material requirements, followed by further approval. Sometimes, this requires multiple rounds of revisions by the project department until a successful match is achieved, resulting in low efficiency.
[0003] In existing technologies, such as the patent application number 201910987395.1, a method for intelligent matching of protocol inventory is proposed. This method uses an ant colony algorithm to find the optimal solution and improves the matching speed by setting a reasonable pheromone intensity. Although this patent can improve the matching speed, the method requires traversing all cases under given conditions, resulting in a huge computational load and slow convergence speed. In addition, in actual calculations, this algorithm is difficult to obtain optimal results under a given number of iterations. Therefore, the matching results cannot reach the best level, and matching failures still occur, leading to low matching efficiency and the inability to quickly complete protocol matching. This reduces the efficiency of material supply and seriously affects the timely procurement of distribution network materials, failing to meet the requirements of distribution network construction supervision. Summary of the Invention
[0004] This application provides a method and apparatus for pre-matching material procurement information to improve the matching efficiency of material procurement information in power distribution networks.
[0005] This application is achieved through the following technical solution:
[0006] In a first aspect, embodiments of this application provide a method for pre-matching material procurement information, including:
[0007] It can obtain information on multiple material procurements and various materials in inventory; among them, the material information includes the material's identification, the total inventory value of the material, and the matched value of the material; the material procurement information includes the identification of the material to be procured, the amount of the material to be procured, and customer information.
[0008] Based on the amount of multiple materials to be purchased and multiple customer information, customer matching priority is obtained.
[0009] Based on customer matching priority, multiple material procurement information, and information on various types of materials, determine the proportion of materials matched for each material to be procured.
[0010] Based on the matching ratio of each material to be purchased, the preset execution upper limit of various materials in the inventory, and the difference threshold of the shipment ratio between different warehouses, the pre-matching result of each material to be purchased is obtained.
[0011] In conjunction with the first aspect, in some possible implementations, customer information includes the total amount of purchases made by the customer and the number of purchases made.
[0012] Based on the total value of multiple items to be procured and information on multiple customers, a customer matching priority is determined, including:
[0013] For each customer, the average purchase amount is obtained based on the total amount and number of purchases completed by the customer. The matching coefficient for the customer is determined based on the corresponding amount of materials to be purchased and the average purchase amount. The matching coefficient represents the ratio of the amount of materials to be purchased to the average purchase amount for the customer.
[0014] The matching coefficients of each customer are sorted from largest to smallest to obtain the customer matching priority; where the customer matching priority represents the order in which the materials to be purchased for each customer are matched.
[0015] In conjunction with the first aspect, among some possible implementation methods, the proportion of material matching for each material to be procured is determined based on customer matching priority, multiple material procurement information, and information on various types of materials. This includes:
[0016] For each item to be purchased, matching is performed according to customer matching priority. During matching, based on the identity identifier of the item to be purchased and the identity identifier of various items in the inventory, the total inventory value and the matched value of the corresponding item in the inventory are determined. Based on the value of the item to be purchased, as well as the total inventory value and the matched value of the corresponding item in the inventory, the matching ratio of the items to be purchased is obtained.
[0017] In conjunction with the first aspect, in some possible implementation methods, based on the amount of the materials to be purchased, and the total inventory amount and matched amount of such materials in the corresponding inventory, the matching ratio of the materials to be purchased is obtained, including:
[0018] According to the expression The ratio of materials matched with the materials to be purchased is obtained.
[0019] Where Ci represents the proportion of material i in the materials to be purchased after matching, P1i represents the total inventory value of material i in the inventory corresponding to the materials to be purchased, P2i represents the matched value of material i in the inventory corresponding to the materials to be purchased, and P3i represents the amount of material i to be purchased.
[0020] In conjunction with the first aspect, in some possible implementation methods, based on the matching ratio of each material to be procured, the preset execution upper limit of various materials in inventory, and the threshold difference in the shipment ratio between different warehouses, the pre-matching result of each material to be procured is obtained, including:
[0021] For each material to be procured, if the proportion of the material to be procured after matching is less than or equal to the preset execution limit of the corresponding material in the inventory, then the preset shipment proportion of the material to be procured in different warehouses in the inventory is obtained; for the preset shipment proportion of each warehouse, the difference between the shipment proportions of different warehouses is calculated; if the difference is less than or equal to the difference threshold, then the material to be procured is determined to be successfully matched; if the difference is greater than the difference threshold, then the material to be procured is determined to be unmatched.
[0022] In conjunction with the first aspect, some possible implementations, after determining that the matching of the materials to be procured has failed, also include:
[0023] Obtain the minimum actual shipment ratio of warehouses in different warehouses, and determine the range of actual shipment ratios of the remaining warehouses in different warehouses based on the minimum actual shipment ratio of warehouses in different warehouses and the difference threshold.
[0024] Based on the minimum actual shipment ratio and the range of actual shipment ratios of the remaining warehouses, determine whether the maximum sum of the shipment ratios of different warehouses is greater than or equal to the demand ratio of the materials to be purchased. The demand ratio of the materials to be purchased represents the ratio of the amount of the materials to be purchased to the total amount of the inventory of that type of material in the corresponding inventory.
[0025] If the maximum sum of the shipment ratios of different warehouses is greater than or equal to the demand ratio of the materials to be purchased, then the shipment ratios of different warehouses are adjusted based on the minimum actual shipment ratio and the range of actual shipment ratios of the remaining warehouses; wherein, the difference between the shipment ratios of different warehouses after adjustment is less than or equal to the difference threshold, and the sum of the shipment ratios of different warehouses is equal to the demand ratio of the materials to be purchased.
[0026] In conjunction with the first aspect, some possible implementations, after determining that the matching of the materials to be procured has failed, also include:
[0027] Obtain the minimum actual shipment ratio of warehouses in different warehouses, and determine the range of actual shipment ratios of the remaining warehouses in different warehouses based on the minimum actual shipment ratio of warehouses in different warehouses and the difference threshold.
[0028] Based on the minimum actual shipment ratio and the range of actual shipment ratios of the remaining warehouses, determine whether the maximum sum of the shipment ratios of different warehouses is greater than or equal to the demand ratio of the materials to be purchased. The demand ratio of the materials to be purchased represents the ratio of the amount of the materials to be purchased to the total amount of the inventory of that type of material in the corresponding inventory.
[0029] If the maximum sum of the shipment ratios from different warehouses is less than the demand ratio of the materials to be purchased, then the difference threshold is adjusted.
[0030] Based on the minimum actual shipment ratio of warehouses in different warehouses and the corrected difference threshold, determine the range of corrected actual shipment ratios of the remaining warehouses in different warehouses.
[0031] Based on the minimum actual shipment ratio and the corrected range of actual shipment ratios for the remaining warehouses, determine whether the maximum sum of the shipment ratios of different warehouses is greater than or equal to the demand ratio of the materials to be purchased. The demand ratio of the materials to be purchased represents the ratio of the amount of the materials to be purchased to the total amount of the inventory of that type of material in the corresponding inventory.
[0032] If the maximum sum of the shipment ratios of different warehouses is greater than or equal to the demand ratio of the materials to be purchased, then the shipment ratios of different warehouses are adjusted based on the minimum actual shipment ratio and the range of actual shipment ratios of the remaining warehouses; wherein, the difference between the shipment ratios of different warehouses after adjustment is less than or equal to the adjusted difference threshold, and the sum of the shipment ratios of different warehouses is equal to the demand ratio of the materials to be purchased.
[0033] In conjunction with the first aspect, in some possible implementations, the corrected difference threshold is a preset multiple of the original difference threshold.
[0034] In conjunction with the first aspect, in some possible implementation methods, the identification of materials includes: the material category number and the technical specification ID number.
[0035] Secondly, embodiments of this application provide a pre-matching device for material procurement information, comprising:
[0036] The acquisition module is used to acquire multiple material procurement information and information on various materials in inventory. The material information includes the material's identification, the total inventory value of the material, and the matched value of the material. The material procurement information includes the identification of the material to be procured, the amount of the material to be procured, and customer information.
[0037] The priority module is used to determine customer matching priorities based on the amount of multiple materials to be purchased and multiple customer information.
[0038] The calculation module is used to determine the matching ratio of each material to be purchased based on customer matching priority, multiple material procurement information, and information on various materials.
[0039] The results output module is used to obtain the pre-matching result of each material to be purchased based on the material matching ratio corresponding to each material to be purchased, the preset execution upper limit of various materials in the inventory, and the difference threshold of the shipment ratio between different warehouses.
[0040] It is understandable that the beneficial effects of the second aspect mentioned above can be found in the relevant descriptions in the first aspect mentioned above, and will not be repeated here.
[0041] The beneficial effects of the embodiments in this application compared with the prior art are:
[0042] This application embodiment limits the chaotic matching order by using the amount of materials to be purchased and customer information, standardizes the matching priority, and matches the materials to be purchased sequentially according to the matching priority. During the matching process, the matching materials to be purchased are filtered based on the preset execution upper limit of various materials in the inventory and the difference threshold of the shipment ratio between different warehouses, so as to obtain the pre-matching result. Thus, when the match is successful, it can be submitted to the superior for review. The processing of this embodiment makes it impossible for unreasonable or unfeasible solutions to be submitted to the superior for review, reduces the possibility of multiple modifications to the materials to be purchased solution, reduces the review time, and thus improves the matching efficiency of the solution, which can meet the requirements of power distribution network construction supervision.
[0043] It should be understood that the above general description and the following detailed description are exemplary and explanatory only, and are not intended to limit this specification. Attached Figure Description
[0044] To more clearly illustrate the technical solutions in the embodiments of this application, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.
[0045] Figure 1 This is a flowchart illustrating a pre-matching method for material procurement information provided in an embodiment of this application;
[0046] Figure 2 This is a flowchart illustrating a pre-matching method for material procurement information provided in another embodiment of this application;
[0047] Figure 3 This is a schematic diagram of the structure of a material procurement information pre-matching device provided in an embodiment of this application. Detailed Implementation
[0048] In the following description, specific details such as particular system architectures and techniques are set forth for illustrative purposes and not for limitation, in order to provide a thorough understanding of the embodiments of this application. However, those skilled in the art will understand that this application may also be implemented in other embodiments without these specific details. In other instances, detailed descriptions of well-known systems, apparatuses, circuits, and methods have been omitted so as not to obscure the description of this application with unnecessary detail.
[0049] It should be understood that, when used in this application specification and the appended claims, the term "comprising" indicates the presence of the described features, integrals, steps, operations, elements and / or components, but does not exclude the presence or addition of one or more other features, integrals, steps, operations, elements, components and / or a collection thereof.
[0050] It should also be understood that the term “and / or” as used in this application specification and the appended claims means any combination of one or more of the associated listed items and all possible combinations, and includes such combinations.
[0051] As used in this application specification and the appended claims, the term "if" may be interpreted, depending on the context, as "when," "once," "in response to determination," or "in response to detection." Similarly, the phrase "if determined" or "if detected [the described condition or event]" may be interpreted, depending on the context, as meaning "once determined," "in response to determination," "once detected [the described condition or event]," or "in response to detection [the described condition or event]."
[0052] Furthermore, in the description of this application and the appended claims, the terms "first," "second," "third," etc., are used only to distinguish descriptions and should not be construed as indicating or implying relative importance.
[0053] References to "one embodiment" or "some embodiments" as described in this specification mean that one or more embodiments of this application include a specific feature, structure, or characteristic described in connection with that embodiment. Therefore, the phrases "in one embodiment," "in some embodiments," "in other embodiments," "in still other embodiments," etc., appearing in different parts of this specification do not necessarily refer to the same embodiment, but rather mean "one or more, but not all, embodiments," unless otherwise specifically emphasized. The terms "comprising," "including," "having," and variations thereof mean "including but not limited to," unless otherwise specifically emphasized.
[0054] In related technologies, the project management department submits material demand information, which is then approved at multiple levels. The material company then matches the inventory. For example, the material company matches the inventory in each warehouse in sequence. If a warehouse fails to match, the relevant department is notified to modify the material demand information, and the modified material demand is then approved. Sometimes, a material demand information may be modified multiple times, resulting in low matching efficiency, which seriously affects the timely procurement of power distribution network materials and fails to meet the supervision requirements for power distribution network construction.
[0055] To address the aforementioned issues, this embodiment determines the matching priority based on the amount of materials to be procured and customer information. Subsequently, it pre-matches the solutions using matching priorities and constraints. This pre-matching of solutions before formally submitting them for approval by higher authorities reduces the number of subsequent modifications required due to approval failures, shortens the overall process, and improves the efficiency of solution matching.
[0056] Figure 1 This is a schematic flowchart of a pre-matching method for material procurement information provided in an embodiment of this application, with reference to... Figure 1 The detailed description of the pre-matching method for the procurement information of this material is as follows:
[0057] Step 101: Obtain information on multiple material procurements and various materials in inventory; among which, the material information includes the material's identification, the total inventory value of the material, and the matched value of the material; the material procurement information includes the identification of the material to be procured, the amount of the material to be procured, and customer information.
[0058] For example, in this embodiment, customer information may include the total amount of purchases completed by the customer and the number of purchases.
[0059] Here, the total amount and number of completed purchases in this embodiment can be understood as the total amount and number of times the customer has purchased goods, or the total amount and number of times the customer has purchased goods within a past period. The specific time period can be set according to the actual situation, such as within one week or one month prior to the current time.
[0060] In this embodiment, the identification identifier can be the material category number and technical specification ID number. Each type of material has a corresponding material category number and technical specification ID number.
[0061] Step 102: Based on the amount of multiple materials to be purchased and multiple customer information, obtain the customer matching priority.
[0062] For example, in this embodiment, step 102 may include:
[0063] For each customer, the average purchase amount is obtained based on the total amount and number of purchases completed by the customer. The matching coefficient for the customer is determined based on the corresponding amount of materials to be purchased and the average purchase amount. The matching coefficient represents the ratio of the amount of materials to be purchased to the average purchase amount for the customer.
[0064] The matching coefficients of each customer are sorted from largest to smallest to obtain the customer matching priority; where the customer matching priority represents the order in which the materials to be purchased for each customer are matched.
[0065] In this embodiment, the customer matching priority is determined by the size of the customer matching coefficient. This can comprehensively consider the difference between the amount of this purchase and the amount of previous purchases. For those items compared with the customer's previous purchase amounts, the level of the purchased materials is evaluated (the ratio of the amount of the materials to be purchased to the average purchase amount). Those with higher levels can be given priority in matching to meet the customer's needs.
[0066] Step 103: Based on customer matching priority, multiple material procurement information and information on various materials, determine the material matching ratio for each material to be procured.
[0067] For example, in this embodiment, step 103 may include:
[0068] For each item to be purchased, matching is performed according to customer matching priority. During matching, based on the identity identifier of the item to be purchased and the identity identifier of various items in the inventory, the total inventory value and the matched value of the corresponding item in the inventory are determined. Based on the value of the item to be purchased, as well as the total inventory value and the matched value of the corresponding item in the inventory, the matching ratio of the items to be purchased is obtained.
[0069] In this embodiment of the application, to increase the probability of successful pre-matching of materials to be procured, both the total inventory value and the matched value of the materials are updated. For example, since the total inventory value of the materials can be considered fixed over a period of time, the interval between updates can be longer, such as once every 24 hours or once every 48 hours. Regarding the matched value of the materials, the matched value of this type of material increases after each material to be procured is matched. To ensure the accuracy of the final pre-matching results for subsequent materials of the same type, the matched value needs to be updated at this time.
[0070] Specifically, in another feasible embodiment, after obtaining the matching ratio of the materials to be purchased, the matched amount of the materials to be purchased is updated.
[0071] Optionally, during matching, the identification of the material to be purchased needs to be matched with the identification of various materials in the inventory. The identification can be the category number and technical specification ID number. For category numbers, similar materials may differ by only two or three digits. For example, a 5cm diameter cable has a category number of 100001, while a 10cm diameter cable has a category number of 100002. Furthermore, if a customer wants to purchase a material that can be substituted with a similar material, and the customer agrees to the substitution (with the same technical specification ID number), the similar material can be used as the material to be purchased for matching. For example, if no material corresponding to the material to be purchased is found in the inventory, a prompt can be generated asking whether to substitute the material. If a substitution request is received, based on this request, materials in the inventory with a similarity within a preset range to the material to be purchased are used as substitute materials. For example, materials with a category number similar to the material to be purchased within a preset range are used as substitute materials. The preset range can be set according to actual circumstances. Specifically, if the category number of the material to be purchased by the customer is 100001, and the customer agrees to a substitute, and there are similar materials in the inventory, that is, materials with category numbers 100002 and 100003 that are similar to the category number of the material to be purchased within a preset range, then materials with category numbers 100002 or 100003 can be used as the materials in the inventory corresponding to the material to be purchased.
[0072] For example, in this embodiment, based on the amount of the materials to be purchased, and the total inventory amount and matched amount of the corresponding materials in the inventory, the matching ratio of the materials to be purchased can be obtained, which may include:
[0073] According to the expression The ratio of materials matched with the materials to be purchased is obtained.
[0074] Where Ci represents the proportion of material i in the materials to be purchased after matching, P1i represents the total inventory value of material i in the inventory corresponding to the materials to be purchased, P2i represents the matched value of material i in the inventory corresponding to the materials to be purchased, and P3i represents the amount of material i to be purchased.
[0075] Step 104: Based on the material matching ratio corresponding to each material to be purchased, the preset execution upper limit of various materials in the inventory, and the difference threshold of the shipment ratio between different warehouses, the pre-matching result of each material to be purchased is obtained.
[0076] Here, if the materials to be purchased in the material procurement information are of one type, then the pre-matching result of that type of materials to be purchased corresponds to the pre-matching result of the material procurement information. If the materials to be purchased in the material procurement information are of multiple types, then if the pre-matching result of each material to be purchased is a successful match, then the material procurement information can be considered to have been pre-matched successfully.
[0077] For example, in this embodiment, step 104 may include:
[0078] For each material to be procured, if the proportion of the material to be procured after matching is less than or equal to the preset execution limit of the corresponding material in the inventory, then the preset shipment proportion of the material to be procured in different warehouses in the inventory is obtained; for the preset shipment proportion of each warehouse, the difference between the shipment proportions of different warehouses is calculated; if the difference is less than or equal to the difference threshold, then the material to be procured is determined to be successfully matched; if the difference is greater than the difference threshold, then the material to be procured is determined to be unmatched.
[0079] For example, such as Figure 2 As shown in this embodiment, after obtaining the material procurement information, the customer matching priority is first calculated. When multiple customers submit material procurement information at the same time, matching is performed in order according to the customer matching priority. During the matching process, the material number and technical specification ID of the material to be procured are used to match materials in the inventory to obtain the materials corresponding to the material to be procured. The matching ratio P of the materials corresponding to the material to be procured is calculated, and then a judgment process is performed. If P is less than or equal to the preset execution limit of the material type, the judgment continues. If P is greater than the preset execution limit of the material type, the matching fails because the materials in the inventory are stored in multiple warehouses, so the demand ratio of the material to be procured is the same as the sum of the shipment ratios of multiple warehouses. It is judged whether the difference between the shipment ratios of multiple warehouses is less than the difference threshold. If it is, the matching is successful; otherwise, the matching fails. Here, the ratio of the material to be procured is the ratio of the amount of the material to be procured to the total inventory amount of the material type in the corresponding inventory.
[0080] Here, to ensure even consumption of materials in different warehouses, the difference in the shipment ratio between different warehouses needs to be less than or equal to a threshold difference. This threshold difference can be set according to the actual situation, such as 10% or 20%. The preset shipment ratio of the materials to be purchased in different warehouses can be the initial preset shipment ratio, which can be any value.
[0081] Optionally, in real life, there is no significant difference for customers in choosing which warehouse to take the purchased materials from. However, this behavior will affect the probability of matching failure to some extent. Suppose the purchased material is A, and there are 10 warehouses containing material A. If the customer only takes the materials from one warehouse, it will indirectly cause the final matching scheme to fail, and then make modifications, resulting in low matching efficiency. However, in this embodiment, it is stipulated that the customer must take some materials from each warehouse. This will, to some extent, avoid matching failure caused by the customer's subjective factors.
[0082] For example, in this embodiment, after determining that the matching of the materials to be purchased has failed, the following may also be included:
[0083] Obtain the minimum actual shipment ratio of warehouses in different warehouses, and determine the range of actual shipment ratios of the remaining warehouses in different warehouses based on the minimum actual shipment ratio of warehouses in different warehouses and the difference threshold.
[0084] Based on the minimum actual shipment ratio and the range of actual shipment ratios of the remaining warehouses, determine whether the maximum sum of the shipment ratios of different warehouses is greater than or equal to the demand ratio of the materials to be purchased. The demand ratio of the materials to be purchased represents the ratio of the amount of the materials to be purchased to the total amount of the inventory of that type of material in the corresponding inventory.
[0085] If the maximum sum of the shipment ratios of different warehouses is greater than or equal to the demand ratio of the materials to be purchased, then the shipment ratios of different warehouses are adjusted based on the minimum actual shipment ratio and the range of actual shipment ratios of the remaining warehouses; wherein, the difference between the shipment ratios of different warehouses after adjustment is less than or equal to the difference threshold, and the sum of the shipment ratios of different warehouses is equal to the demand ratio of the materials to be purchased.
[0086] In this embodiment of the application, in order to ensure the success rate of matching, when the difference between the shipment ratios of different warehouses cannot meet the requirement of being less than or equal to the difference threshold, the shipment ratios of different warehouses can be modified so that the difference between the shipment ratios of different warehouses meets the requirements.
[0087] Specifically, assuming there are three warehouses, A, B, and C, with preset shipment ratios of 1, 4, and 4 respectively, and the minimum actual shipment ratio between different warehouses is 3, then the actual shipment ratio of the remaining warehouses is 2.4-3.6. The maximum actual shipment ratio is 3 + 3.6 + 3.6 = 10.2, which is greater than 1 + 4 + 4 = 9. In this case, we only need to adjust the sum of the remaining two warehouse ratios to 6. If the minimum actual shipment ratio between different warehouses is 3 for warehouse A, then warehouse B's shipment ratio is 3, and warehouse C's shipment ratio is 3, resulting in a corrected shipment ratio of 3, 3, and 3. Alternatively, warehouse B's shipment ratio is 2.8, and warehouse C's shipment ratio is 3.2, resulting in a corrected shipment ratio of 3, 2.8, and 3.2.
[0088] For example, in this embodiment, after determining that the matching of the materials to be purchased has failed, the following may also be included:
[0089] Obtain the minimum actual shipment ratio of warehouses in different warehouses, and determine the range of actual shipment ratios of the remaining warehouses in different warehouses based on the minimum actual shipment ratio of warehouses in different warehouses and the difference threshold.
[0090] Based on the minimum actual shipment ratio and the range of actual shipment ratios of the remaining warehouses, determine whether the maximum sum of the shipment ratios of different warehouses is greater than or equal to the demand ratio of the materials to be purchased. The demand ratio of the materials to be purchased represents the ratio of the amount of the materials to be purchased to the total amount of the inventory of that type of material in the corresponding inventory.
[0091] If the maximum sum of the shipment ratios from different warehouses is less than the demand ratio of the materials to be purchased, then the difference threshold is adjusted.
[0092] Based on the minimum actual shipment ratio of warehouses in different warehouses and the corrected difference threshold, determine the range of corrected actual shipment ratios of the remaining warehouses in different warehouses.
[0093] Based on the minimum actual shipment ratio and the corrected range of actual shipment ratios for the remaining warehouses, determine whether the maximum sum of the shipment ratios of different warehouses is greater than or equal to the demand ratio of the materials to be purchased. The demand ratio of the materials to be purchased represents the ratio of the amount of the materials to be purchased to the total amount of the inventory of that type of material in the corresponding inventory.
[0094] If the maximum sum of the shipment ratios of different warehouses is greater than or equal to the demand ratio of the materials to be purchased, then the shipment ratios of different warehouses are adjusted based on the minimum actual shipment ratio and the range of actual shipment ratios of the remaining warehouses; wherein, the difference between the shipment ratios of different warehouses after adjustment is less than or equal to the adjusted difference threshold, and the sum of the shipment ratios of different warehouses is equal to the demand ratio of the materials to be purchased.
[0095] In actual production and daily life, during matching, there may be situations where a certain warehouse has very little stock. In this case, even if the difference threshold is met, the maximum output of multiple warehouses may not be able to meet customer demand. In this case, the difference threshold can be adjusted adaptively to ensure the matching success rate. The adjustment of the difference threshold needs to be limited to a certain range. The maximum of the adjusted difference threshold can be a preset multiple of the original threshold, which can be up to 1.05 times. Of course, the maximum value of the preset multiple also needs to meet certain conditions. The adjustment of the maximum value of the preset multiple needs to ensure that there will be no significant difference in the remaining quantity of the material after output from multiple warehouses.
[0096] The aforementioned pre-matching method for material procurement information limits the chaotic matching order by using the amount of materials to be procured and customer information, and standardizes the matching priority. Materials to be procured are matched sequentially according to the matching priority. Subsequently, the matched materials to be procured are filtered based on the preset execution upper limit of various materials in the inventory and the difference threshold of the shipment ratio between different warehouses to obtain the pre-matching result. If the pre-matching result is successful, the plan for the materials to be procured can be submitted to the superior for review. Because of the existence of the pre-matching process, obviously unreasonable or unfeasible plans cannot be submitted to the superior for review, reducing the possibility of multiple modifications to the plan for the materials to be procured, reducing the time of repeated review, and thus improving the matching efficiency of the plan, which can meet the requirements of power distribution network construction supervision.
[0097] It should be understood that the sequence number of each step in the above embodiments does not imply the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of this application.
[0098] Corresponding to the material procurement information pre-matching method described in the above embodiments, Figure 3 The diagram shows a structural block diagram of the material procurement information pre-matching device provided in the embodiments of this application. For ease of explanation, only the parts related to the embodiments of this application are shown.
[0099] See Figure 3 The material procurement information pre-matching device in this application embodiment may include:
[0100] The acquisition module 301 is used to acquire multiple material procurement information and information on various materials in inventory; among them, the material information includes the material's identification, the total inventory value of the material, and the matched value of the material; the material procurement information includes the identification of the material to be procured, the amount of the material to be procured, and customer information.
[0101] Priority module 302 is used to obtain customer matching priority based on the amount of multiple materials to be purchased and multiple customer information.
[0102] The calculation module 303 is used to determine the proportion of material matching for each material to be purchased based on customer matching priority, multiple material procurement information and information on various materials.
[0103] The result output module 304 is used to obtain the pre-matching result of each material to be purchased based on the material matching ratio corresponding to each material to be purchased, the preset execution upper limit of various materials in the inventory, and the difference threshold of the shipment ratio between different warehouses.
[0104] For example, customer information includes the total amount of purchases made by the customer and the number of purchases made.
[0105] For example, priority module 302 can be used to:
[0106] For each customer, the average purchase amount is obtained based on the total amount and number of purchases completed by the customer. The matching coefficient for the customer is determined based on the corresponding amount of materials to be purchased and the average purchase amount. The matching coefficient represents the ratio of the amount of materials to be purchased to the average purchase amount for the customer.
[0107] The matching coefficients of each customer are sorted from largest to smallest to obtain the customer matching priority; where the customer matching priority represents the order in which the materials to be purchased for each customer are matched.
[0108] For example, the calculation module 303 can be used to:
[0109] For each item to be purchased, matching is performed according to customer matching priority. During matching, based on the identity identifier of the item to be purchased and the identity identifier of various items in the inventory, the total inventory value and the matched value of the corresponding item in the inventory are determined. Based on the value of the item to be purchased, as well as the total inventory value and the matched value of the corresponding item in the inventory, the matching ratio of the items to be purchased is obtained.
[0110] For example, the computing module 303 can also be used for:
[0111] According to the expression The ratio of materials matched with the materials to be purchased is obtained.
[0112] Where Ci represents the proportion of material i in the materials to be purchased after matching, P1i represents the total inventory value of material i in the inventory corresponding to the materials to be purchased, P2i represents the matched value of material i in the inventory corresponding to the materials to be purchased, and P3i represents the amount of material i to be purchased.
[0113] For example, the result output module 304 can be used to:
[0114] For each material to be procured, if the proportion of the material to be procured after matching is less than or equal to the preset execution limit of the corresponding material in the inventory, then the preset shipment proportion of the material to be procured in different warehouses in the inventory is obtained; for the preset shipment proportion of each warehouse, the difference between the shipment proportions of different warehouses is calculated; if the difference is less than or equal to the difference threshold, then the material to be procured is determined to be successfully matched; if the difference is greater than the difference threshold, then the material to be procured is determined to be unmatched.
[0115] For example, the result output module 304 can also be used for:
[0116] Obtain the minimum actual shipment ratio of warehouses in different warehouses, and determine the range of actual shipment ratios of the remaining warehouses in different warehouses based on the minimum actual shipment ratio of warehouses in different warehouses and the difference threshold.
[0117] Based on the minimum actual shipment ratio and the range of actual shipment ratios of the remaining warehouses, determine whether the maximum sum of the shipment ratios of different warehouses is greater than or equal to the demand ratio of the materials to be purchased. The demand ratio of the materials to be purchased represents the ratio of the amount of the materials to be purchased to the total amount of the inventory of that type of material in the corresponding inventory.
[0118] If the maximum sum of the shipment ratios of different warehouses is greater than or equal to the demand ratio of the materials to be purchased, then the shipment ratios of different warehouses are adjusted based on the minimum actual shipment ratio and the range of actual shipment ratios of the remaining warehouses; wherein, the difference between the shipment ratios of different warehouses after adjustment is less than or equal to the difference threshold, and the sum of the shipment ratios of different warehouses is equal to the demand ratio of the materials to be purchased.
[0119] For example, the result output module 304 can also be used for:
[0120] Obtain the minimum actual shipment ratio of warehouses in different warehouses, and determine the range of actual shipment ratios of the remaining warehouses in different warehouses based on the minimum actual shipment ratio of warehouses in different warehouses and the difference threshold.
[0121] Based on the minimum actual shipment ratio and the range of actual shipment ratios of the remaining warehouses, determine whether the maximum sum of the shipment ratios of different warehouses is greater than or equal to the demand ratio of the materials to be purchased. The demand ratio of the materials to be purchased represents the ratio of the amount of the materials to be purchased to the total amount of the inventory of that type of material in the corresponding inventory.
[0122] If the maximum sum of the shipment ratios from different warehouses is less than the demand ratio of the materials to be purchased, then the difference threshold is adjusted.
[0123] Based on the minimum actual shipment ratio of warehouses in different warehouses and the corrected difference threshold, determine the range of corrected actual shipment ratios of the remaining warehouses in different warehouses.
[0124] Based on the minimum actual shipment ratio and the corrected range of actual shipment ratios for the remaining warehouses, determine whether the maximum sum of the shipment ratios of different warehouses is greater than or equal to the demand ratio of the materials to be purchased. The demand ratio of the materials to be purchased represents the ratio of the amount of the materials to be purchased to the total amount of the inventory of that type of material in the corresponding inventory.
[0125] If the maximum sum of the shipment ratios of different warehouses is greater than or equal to the demand ratio of the materials to be purchased, then the shipment ratios of different warehouses are adjusted based on the minimum actual shipment ratio and the range of actual shipment ratios of the remaining warehouses; wherein, the difference between the shipment ratios of different warehouses after adjustment is less than or equal to the adjusted difference threshold, and the sum of the shipment ratios of different warehouses is equal to the demand ratio of the materials to be purchased.
[0126] For example, the corrected difference threshold is a preset multiple of the original difference threshold.
[0127] For example, the identification of materials includes: the material category number and the technical specification ID number.
[0128] In the above embodiments, the descriptions of each embodiment have different focuses. For parts that are not described in detail or recorded in a certain embodiment, please refer to the relevant descriptions of other embodiments.
[0129] Those skilled in the art will recognize that the templates, units, and algorithm steps of the various examples described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are implemented in hardware or software depends on the specific application and design constraints of the technical solution. Those skilled in the art can use different methods to implement the described functions for each specific application, but such implementations should not be considered beyond the scope of this invention.
[0130] If the module / unit is implemented as a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, all or part of the processes in the above embodiments of the present invention can also be implemented by a computer program instructing related hardware. The computer program can be stored in a computer-readable storage medium, and when executed by a processor, it can implement the steps of the above embodiments of the material procurement information pre-matching method. The computer program includes computer program code, which can be in the form of source code, object code, executable file, or some intermediate form. The computer-readable medium can include: any entity or device capable of carrying the computer program code, a recording medium, a USB flash drive, a portable hard drive, a magnetic disk, an optical disk, a computer memory, a read-only memory, a random access memory, an electrical carrier signal, a telecommunication signal, and a software distribution medium, etc.
[0131] The above-described embodiments are only used to illustrate the technical solutions of the present invention, and are not intended to limit it. Although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some of the technical features. Such modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present invention, and should all be included within the protection scope of the present invention.
Claims
1. A method for pre-matching material procurement information, characterized in that, include: The system acquires multiple material procurement information and information on various materials in inventory; wherein, the material information includes the material's identification identifier, the total inventory value of the material, and the matched value of the material; the material procurement information includes the identification identifier of the material to be procured, the amount of the material to be procured, and customer information; Based on the amounts of the materials to be purchased and the customer information, a customer matching priority is obtained; Based on the customer matching priority, the multiple material procurement information and the information of various materials, determine the proportion of material matching for each material to be procured; Based on the matching ratio of each material to be purchased, the preset execution upper limit of each type of material in the inventory, and the difference threshold of the shipment ratio between different warehouses, the pre-matching result of each material to be purchased is obtained. The customer information includes the total amount and number of purchases completed by the customer. The process of obtaining customer matching priority based on the amounts of multiple items to be purchased and multiple customer information includes: For each customer, based on the total amount and number of purchases completed by the customer, the average purchase amount is obtained. Based on the corresponding amount of materials to be purchased and the average purchase amount, the customer's matching coefficient is determined. The matching coefficient represents the ratio of the amount of materials to be purchased corresponding to the customer to the average purchase amount. The matching coefficients of each customer are sorted from largest to smallest to obtain the customer matching priority; wherein, the customer matching priority represents the order in which the materials to be purchased for each customer are matched.
2. The material procurement information pre-matching method as described in claim 1, characterized in that, The step of determining the matching ratio of each material to be procured based on the customer matching priority, the multiple material procurement information, and the information of various types of materials includes: For each item to be purchased, matching is performed according to the customer matching priority. During matching, based on the identity identifier of the item to be purchased and the identity identifier of each type of item in the inventory, the total inventory value and the matched value of the corresponding item in the inventory are determined. Based on the value of the item to be purchased, and the total inventory value and the matched value of the corresponding item in the inventory, the matching ratio of the items to be purchased is obtained.
3. The material procurement information pre-matching method as described in claim 2, characterized in that, The process of obtaining the matching ratio of materials to be purchased based on the amount of the materials to be purchased, the total inventory amount of such materials in the corresponding inventory, and the already matched amount, includes: According to the expression Obtain the matching ratio of the materials to be procured; in, Indicates the materials to be procured. The corresponding proportion of matched supplies This indicates the materials in the inventory corresponding to the materials to be purchased. Total inventory amount This indicates the materials in the inventory corresponding to the materials to be purchased. Matched amount Indicates supplies The amount of materials to be purchased.
4. The material procurement information pre-matching method as described in any one of claims 1 to 3, characterized in that, The pre-matching result for each item to be purchased is obtained based on the matching ratio of each item to be purchased, the preset execution upper limit of each type of item in the inventory, and the threshold difference in the shipment ratio between different warehouses. This includes: For each material to be procured, if the proportion of the material to be procured after matching is less than or equal to the preset execution limit of the corresponding material in the inventory, then the preset shipment proportion of the material to be procured in different warehouses in the inventory is obtained; for the preset shipment proportion of each warehouse, the difference between the shipment proportions of different warehouses is calculated; if the difference is less than or equal to the difference threshold, then the material to be procured is determined to be successfully matched; if the difference is greater than the difference threshold, then the material to be procured is determined to be unmatched.
5. The material procurement information pre-matching method as described in claim 4, characterized in that, After determining that the matching of the materials to be purchased has failed, the following steps are also included: Obtain the minimum actual shipment ratio of warehouses in different warehouses, and determine the range of actual shipment ratios of the remaining warehouses in different warehouses based on the minimum actual shipment ratio of warehouses in different warehouses and the difference threshold. Based on the minimum actual shipment ratio and the range of actual shipment ratios of the remaining warehouses, determine whether the maximum sum of the shipment ratios of the different warehouses is greater than or equal to the demand ratio of the materials to be purchased, wherein the demand ratio of the materials to be purchased represents the ratio of the amount of the materials to be purchased to the total amount of the inventory of that type of materials in the inventory corresponding to the materials to be purchased. If the maximum sum of the shipment ratios of the different warehouses is greater than or equal to the demand ratio of the materials to be purchased, then the shipment ratios of the different warehouses are adjusted based on the minimum actual shipment ratio and the range of actual shipment ratios of the remaining warehouses; wherein, the difference between the shipment ratios of the different warehouses after adjustment is less than or equal to the difference threshold, and the sum of the shipment ratios of the different warehouses is equal to the demand ratio of the materials to be purchased.
6. The material procurement information pre-matching method as described in claim 4, characterized in that, After determining that the matching of the materials to be purchased has failed, the following steps are also included: Obtain the minimum actual shipment ratio of warehouses in different warehouses, and determine the range of actual shipment ratios of the remaining warehouses in different warehouses based on the minimum actual shipment ratio of warehouses in different warehouses and the difference threshold. Based on the minimum actual shipment ratio and the range of actual shipment ratios of the remaining warehouses, determine whether the maximum sum of the shipment ratios of the different warehouses is greater than or equal to the demand ratio of the materials to be purchased, wherein the demand ratio of the materials to be purchased represents the ratio of the amount of the materials to be purchased to the total amount of the inventory of that type of materials in the inventory corresponding to the materials to be purchased. If the maximum sum of the shipment ratios of the different warehouses is less than the demand ratio of the materials to be purchased, then the difference threshold is adjusted. Based on the minimum actual shipment ratio of the warehouses in the different warehouses and the corrected difference threshold, determine the corrected actual shipment ratio range of the remaining warehouses in the different warehouses; Based on the minimum actual shipment ratio and the corrected range of actual shipment ratios for the remaining warehouses, determine whether the maximum sum of the shipment ratios of the different warehouses is greater than or equal to the demand ratio of the materials to be purchased. The demand ratio of the materials to be purchased represents the ratio of the amount of the materials to be purchased to the total amount of the inventory of that type of material in the corresponding inventory. If the maximum sum of the shipment ratios of the different warehouses is greater than or equal to the demand ratio of the materials to be purchased, then the shipment ratios of the different warehouses are adjusted based on the minimum actual shipment ratio and the range of actual shipment ratios of the remaining warehouses; wherein, the difference between the shipment ratios of the different warehouses after adjustment is less than or equal to the adjusted difference threshold, and the sum of the shipment ratios of the different warehouses is equal to the demand ratio of the materials to be purchased.
7. The material procurement information pre-matching method as described in claim 6, characterized in that, The corrected difference threshold is a preset multiple of the original difference threshold.
8. The material procurement information pre-matching method as described in claim 1, characterized in that, The identification of the materials includes: the material category number and the technical specification ID number.
9. A pre-matching device for material procurement information, characterized in that, include: The acquisition module is used to acquire multiple material procurement information and information on various materials in inventory; wherein, the material information includes the material's identification, the total inventory value of the material, and the matched value of the material; the material procurement information includes the identification of the material to be procured, the amount of the material to be procured, and customer information; The priority module is used to obtain customer matching priority based on the amount of multiple items to be purchased and multiple customer information. The calculation module is used to determine the proportion of material matching for each material to be purchased based on the customer matching priority, the multiple material procurement information and the information of various materials. The result output module is used to obtain the pre-matching result of each material to be purchased based on the material matching ratio corresponding to each material to be purchased, the preset execution upper limit of various materials in the inventory, and the difference threshold of the shipment ratio between different warehouses. The customer information includes the total amount and number of purchases completed by the customer. The priority module is used for: For each customer, based on the total amount and number of purchases completed by the customer, the average purchase amount is obtained. Based on the corresponding amount of materials to be purchased and the average purchase amount, the customer's matching coefficient is determined. The matching coefficient represents the ratio of the amount of materials to be purchased corresponding to the customer to the average purchase amount. The matching coefficients of each customer are sorted from largest to smallest to obtain the customer matching priority; wherein, the customer matching priority represents the order in which the materials to be purchased for each customer are matched.