Method, device and terminal for reducing forecast demand

By calculating the material change rate and sorting verification mechanism, the accuracy of material forecast demand reduction is solved, and the precise reduction of material forecast demand is achieved, which is applicable to framework agreements and material group environments.

CN113869555BActive Publication Date: 2024-12-24STATE GRID HEBEI ELECTRIC POWER CO LTD +1
View PDF 6 Cites 0 Cited by

Patent Information

Application Number
CN202111016898.8
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2021-08-31
Publication Date
2024-12-24
Estimated Expiration
2041-08-31

AI Technical Summary

Technical Problem

In the prior art, the reduction method for predicting material demand is low, especially in framework agreements and material groups. The calculation of the remaining amount of the protocol is complex and the detailed materials often change, resulting in inaccurate prediction results.

Method used

By obtaining the forecast demand and historical protocol, calculate the rate of change of materials for each category, and determine the predicted nuclear reduction based on the rate of change, the smaller values ​​in the predicted nuclear reduction and the historical protocol margin are used as the actual nuclear reduction, and the sorting and verification mechanism are used to adopt the to ensure the accuracy of nuclear reduction.

Benefits of technology

Improve the accuracy of material forecasting demand reduction, ensure the accuracy and reliability of forecast results, reduce errors, and are suitable for complex material sets and framework protocol environments.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN113869555B_ABST
    Figure CN113869555B_ABST
Patent Text Reader

Abstract

The present invention provides a method, device and terminal for reducing forecast demand, the method comprising: obtaining forecast demand and historical agreement; for any category, obtaining the material quantity of the first material group corresponding to the category as the first material quantity of the category, obtaining the material quantity of the second material group corresponding to the category as the second material quantity of the category, and calculating the material change rate of the category based on the first material quantity and the second material quantity of the category, determining the forecast reduction amount of the first material group corresponding to the category based on the material change rate of the category and the forecast amount of the first material group corresponding to the category, and taking the smaller value of the forecast reduction amount of the first material group corresponding to the category and the surplus amount of the second material group corresponding to the category as the actual reduction amount of the first material group corresponding to the category. The present invention can obtain an accurate actual reduction amount and accurately reduce the forecast demand.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular to a method, device and terminal for reducing predicted demand. Background Art

[0002] Framework agreements and material groups are commonly used forms of material procurement. For enterprises that use framework agreements and material groups for material procurement, when specific projects have not yet been issued, managers need to predict material demand based on historical experience, and the prediction result is all the materials required for the project. On this basis, it is also necessary to subtract the amount of materials that have not been delivered in the agreement, that is, the remaining amount of the agreement, to obtain the actual amount of materials that need to be purchased.

[0003] However, the calculation of the agreed remaining quantity is complex, and the detailed materials in the material group often change. The current method of reducing the forecast demand for materials has low accuracy. Summary of the invention

[0004] The embodiments of the present invention provide a method, device and terminal for reducing forecast demand, so as to solve the problem of improving the accuracy of reducing forecast demand for materials.

[0005] In a first aspect, an embodiment of the present invention provides a method for reducing forecast demand, including: obtaining forecast demand and historical agreements, wherein the forecast demand includes at least one category of first material groups and forecast quantities of each category of first material groups, and the historical agreements include at least one category of second material groups and surplus quantities of each category of second material groups;

[0006] For any category, obtain the material quantity of the first material group corresponding to the category as the first material quantity of the category, obtain the material quantity of the second material group corresponding to the category as the second material quantity of the category, and calculate the material change rate of the category based on the first material quantity and the second material quantity of the category;

[0007] For each category, determine the predicted reduction amount of the first material group corresponding to the category based on the material change rate of the category and the predicted amount of the first material group corresponding to the category;

[0008] For each category, the smaller value between the predicted reduction amount of the first material group corresponding to the category and the remaining amount of the second material group corresponding to the category is taken as the actual reduction amount of the first material group corresponding to the category.

[0009] In a possible implementation, the historical protocol is at least one;

[0010] The smaller value between the predicted reduction amount of the first material group corresponding to the category and the remaining amount of the second material group corresponding to the category is used as the actual reduction amount of the first material group corresponding to the category, including:

[0011] For each category, sum the balances of the second material group corresponding to the category in each historical agreement to obtain the total balance;

[0012] The smaller value between the predicted reduction amount of the first material group corresponding to the first category and the sum of the remaining amounts of the second material group corresponding to the first category is taken as the actual reduction amount of the first material group corresponding to the first category; the first category is any category.

[0013] In a possible implementation, if the predicted reduction amount of the first material group corresponding to the first category is less than the sum of the remaining amounts of the corresponding second material group, the historical agreements are sorted from small to large according to the remaining amounts of the second material group corresponding to the first category;

[0014] The predicted reduction amount of the first material group corresponding to the first category is used to write off the surplus of the second material group corresponding to the first category in each historical agreement in order, until the remaining predicted reduction amount is not greater than 0, thereby obtaining the historical agreement after write-off.

[0015] In a possible implementation, calculating the material change rate of the category based on the first material quantity and the second material quantity of the category includes:

[0016] The difference between the quantity of the first material and the quantity of the second material in the first category is taken as the material change amount of the first category; the first category is any category;

[0017] The ratio of the change amount of the first category of materials to the amount of the second material is calculated to obtain the change rate of the first category of materials.

[0018] In a possible implementation, determining the predicted reduction amount of the first material group corresponding to the category based on the material change rate of the category and the predicted amount of the first material group corresponding to the category includes:

[0019] Determine the reduction ratio corresponding to the first category based on the material change rate of the first category; the first category is any category;

[0020] The product of the reduction ratio corresponding to the first category and the predicted quantity of the first material group corresponding to the first category is calculated to obtain the predicted reduction quantity of the first category.

[0021] In a possible implementation, the balance includes the amount balance, the predicted reduction includes the predicted reduction amount, and the actual reduction includes the reduction amount;

[0022] After, for each category, taking the smaller value of the predicted reduction amount of the first material group corresponding to the category and the remaining amount of the second material group corresponding to the category as the actual reduction amount of the first material group corresponding to the category, the method further includes:

[0023] Get the price of the first material group corresponding to each category;

[0024] Subtract the corresponding actual reduction amount from the predicted reduction amount of the first material group corresponding to each category to obtain the reduced amount of the first material group corresponding to each category;

[0025] For each category, the ratio of the reduced amount of the first material group corresponding to the category to the price of the first material group corresponding to the category is calculated to obtain the reduced quantity of the first material group corresponding to the category.

[0026] In a possible implementation, the historical protocol is at least one;

[0027] Get historical agreements, including:

[0028] Determine whether the first historical agreement is signed in the form of a material group; the first historical agreement is any historical agreement;

[0029] If the first historical agreement is not signed in the form of material groups, the material balance of the first category in the first historical agreement is divided by the first material quantity corresponding to the first category to obtain the balance of the second material group corresponding to the first category in the first historical agreement; the first category is any category.

[0030] In a second aspect, an embodiment of the present invention provides a device for reducing predicted demand, including:

[0031] A first acquisition module is used to acquire forecast demand and historical agreements, wherein the forecast demand includes at least one category of first material group and forecast quantity of each category of first material group, and the historical agreement includes at least one category of second material group and surplus of each category of second material group;

[0032] A second acquisition module is used to acquire, for any category, the material quantity of the first material group corresponding to the category as the first material quantity of the category, acquire the material quantity of the second material group corresponding to the category as the second material quantity of the category, and calculate the material change rate of the category based on the first material quantity and the second material quantity of the category;

[0033] A predicted reduction amount determination module is used to determine the predicted reduction amount of each category based on the material change rate of the category and the predicted amount of the first material group corresponding to the category;

[0034] The actual reduction amount determination module is used to, for each category, take the smaller value of the predicted reduction amount of the first material group corresponding to the category and the remaining amount of the second material group corresponding to the category as the actual reduction amount of the first material group corresponding to the category.

[0035] In a third aspect, an embodiment of the present invention provides a terminal, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the computer program, the steps of the first aspect or any possible implementation method of the first aspect are implemented.

[0036] In a fourth aspect, an embodiment of the present invention provides a computer-readable storage medium, which stores a computer program. When the computer program is executed by a processor, it implements the steps of the first aspect or any possible implementation method of the first aspect.

[0037] The embodiment of the present invention provides a method for reducing forecast demand, the method comprising: obtaining forecast demand and historical agreements, the forecast demand including at least one category of first material group and the forecast quantity of each category of first material group, the historical agreement including at least one category of second material group and the surplus of each category of second material group; for any category, obtaining the material quantity of the first material group corresponding to the category as the first material quantity of the category, obtaining the material quantity of the second material group corresponding to the category as the second material quantity of the category, and calculating the material change rate of the category based on the first material quantity and the second material quantity of the category; for each category, determining the forecast reduction amount of the first material group corresponding to the category based on the material change rate of the category and the forecast quantity of the first material group corresponding to the category; for each category, the smaller value of the forecast reduction amount of the first material group corresponding to the category and the surplus of the second material group corresponding to the category is used as the actual reduction amount of the first material group corresponding to the category. The present invention determines the corresponding forecast reduction amount based on the material change rate of each category, compares the forecast reduction amount with the surplus of the historical agreement to obtain an accurate actual reduction amount, and can accurately reduce the forecast demand. BRIEF DESCRIPTION OF THE DRAWINGS

[0038] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.

[0039] Figure 1 is a flow chart for implementing a method for reducing forecast demand provided by an embodiment of the present invention;

[0040] Figure 2 It is a structural schematic diagram of a device for reducing predicted demand provided by an embodiment of the present invention;

[0041] Figure 3 is a schematic diagram of a terminal provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0042] In the following description, specific details such as specific system structures, technologies, etc. are provided for the purpose of illustration rather than limitation, so as to provide a thorough understanding of the embodiments of the present invention. However, it should be clear to those skilled in the art that the present invention may be implemented in other embodiments without these specific details. In other cases, detailed descriptions of well-known systems, devices, circuits, and methods are omitted to prevent unnecessary details from obstructing the description of the present invention.

[0043] In order to make the purpose, technical solutions and advantages of the present invention more clear, specific embodiments will be described below in conjunction with the accompanying drawings.

[0044] See also Figure 1 , which shows a flowchart of the implementation of the method for reducing the predicted demand provided by an embodiment of the present invention, the method is applied to a terminal device, and is described in detail as follows:

[0045] Step 101, obtaining forecast demand and historical agreements, wherein the forecast demand includes at least one category of first material groups and forecast quantities of each category of first material groups, and the historical agreements include at least one category of second material groups and surplus quantities of each category of second material groups.

[0046] In this embodiment, the forecast demand can be the forecast demand obtained by the planning management personnel based on the historical experience when the specific project has not been issued and the initial design plan has not been completed. The historical agreement can be an agreement signed before the forecast demand and not fully delivered, usually a framework agreement using the material group model. Each type of material group corresponds to a material group ID, and a material group is used to represent a group of materials. The forecast quantity of each type of first material group represents the forecast demand quantity or forecast demand amount of each type of first material group. The balance of each type of second material group represents the undelivered quantity or undelivered amount of each type of second material group.

[0047] Step 102, for any category, obtain the material quantity of the first material group corresponding to the category as the first material quantity of the category, obtain the material quantity of the second material group corresponding to the category as the second material quantity of the category, and calculate the material change rate of the category based on the first material quantity and the second material quantity of the category.

[0048] In this embodiment, the material quantities corresponding to the same category of material group in different time periods may be different. Since the forecast demand and the historical agreement correspond to different time periods, if there are technical reasons that cause the material composition in a certain category of material group to change, the terminal device calculates the material change rate of the category based on the material quantity of the category of material group before the change and the material quantity after the change, that is, the material change rate of the category is calculated based on the first material quantity and the second material quantity of the category. The reduction logic of the category is determined based on the material change rate of the category.

[0049] Step 103: for each category, determine the predicted reduction amount of the first material group corresponding to the category based on the material change rate of the category and the predicted amount of the first material group corresponding to the category.

[0050] In this embodiment, the smaller the material change rate of a certain category is, the less the material components of the material group corresponding to the category are increased, that is, the more the proportion of the predicted quantity that can be reduced by the historical agreement is increased. Therefore, the reduction ratio of the predicted quantity of the first material group corresponding to the category can be determined based on the material change rate of the category, and a part of the predicted quantity of the first material group corresponding to the category is used as the predicted reduction amount based on the reduction ratio. The predicted reduction amount represents the predicted quantity that can be reduced without considering the surplus in the historical agreement.

[0051] Step 104: for each category, the smaller value between the predicted reduction amount of the first material group corresponding to the category and the remaining amount of the second material group corresponding to the category is used as the actual reduction amount of the first material group corresponding to the category.

[0052] In this embodiment, after determining the predicted reduction amount of the first material group corresponding to the category, it is also necessary to compare it with the balance in the historical agreement. If the balance in the historical agreement is larger, it means that the historical agreement can fully reduce the predicted reduction amount, and the predicted reduction amount of the first material group corresponding to the category can be used as the actual reduction amount of the first material group corresponding to the category; if the balance in the historical agreement is smaller, it means that the historical agreement cannot meet the predicted reduction amount, and at most the balance in the historical agreement can be fully reduced, that is, the balance of the second material group corresponding to the category is used as the actual reduction amount of the first material group corresponding to the category.

[0053] In a possible implementation, the historical protocol is at least one;

[0054] The smaller value between the predicted reduction amount of the first material group corresponding to the category and the remaining amount of the second material group corresponding to the category is used as the actual reduction amount of the first material group corresponding to the category, including:

[0055] For each category, sum the balances of the second material group corresponding to the category in each historical agreement to obtain the total balance;

[0056] The smaller value between the predicted reduction amount of the first material group corresponding to the first category and the sum of the remaining amounts of the second material group corresponding to the first category is taken as the actual reduction amount of the first material group corresponding to the first category; the first category is any category.

[0057] In this embodiment, if there is one historical agreement corresponding to the first material group corresponding to the first category, the balance in the historical agreement is compared with the predicted reduction amount of the first material group corresponding to the first category to determine the actual reduction amount of the first material group corresponding to the first category. If there are more than or equal to two historical agreements corresponding to the first material group corresponding to the first category, the balances of all historical agreements corresponding to the first material group corresponding to the first category are summed, and the sum of the balances is compared with the predicted reduction amount of the first material group corresponding to the first category to determine the actual reduction amount of the first material group corresponding to the first category.

[0058] In a possible implementation, if the predicted reduction amount of the first material group corresponding to the first category is less than the sum of the remaining amounts of the corresponding second material group, the historical agreements are sorted from small to large according to the remaining amounts of the second material group corresponding to the first category;

[0059] The predicted reduction amount of the first material group corresponding to the first category is used to write off the surplus of the second material group corresponding to the first category in each historical agreement in order, until the remaining predicted reduction amount is not greater than 0, thereby obtaining the historical agreement after write-off.

[0060] In this embodiment, if the predicted reduction amount of the first material group corresponding to the first category is greater than the sum of the surplus of the corresponding second material group, all historical agreements corresponding to the first category will be reduced; if the predicted reduction amount of the first material group corresponding to the first category is less than the sum of the surplus of the corresponding second material group, there may be historical agreements that cannot be reduced, and it is necessary to determine which historical agreements can be reduced and which historical agreements cannot be reduced. In order to use as many historical agreements as possible, in this embodiment, the historical agreements with small surpluses are first reduced, and then the historical agreements with large surpluses are reduced until all the reduction amounts are used.

[0061] In a possible implementation, calculating the material change rate of the category based on the first material quantity and the second material quantity of the category includes:

[0062] The difference between the quantity of the first material and the quantity of the second material in the first category is taken as the material change amount of the first category; the first category is any category;

[0063] The ratio of the change amount of the first category of materials to the amount of the second material is calculated to obtain the change rate of the first category of materials.

[0064] In this embodiment, the material change rate of the first category is used to reflect the degree of change of the material composition of the material group corresponding to the first category. The greater the material change rate of the first category is, the more the material composition of the material group corresponding to the first category increases.

[0065] In a possible implementation, determining the predicted reduction amount of the first material group corresponding to the category based on the material change rate of the category and the predicted amount of the first material group corresponding to the category includes:

[0066] Determine the reduction ratio corresponding to the first category based on the material change rate of the first category; the first category is any category;

[0067] The product of the reduction ratio corresponding to the first category and the predicted quantity of the first material group corresponding to the first category is calculated to obtain the predicted reduction quantity of the first category.

[0068] In this embodiment, the corresponding reduction ratio is determined based on the range of the material change rate of the first category. Specifically, it can be:

[0069] (1) When there is no new material component in the material group (i.e. material change rate = 0), the predicted quantity will be reduced;

[0070] (2) When there is a new material component in the material group (i.e. material change rate > 0), in order to meet future matching needs, the material component is reduced according to the step ratio:

[0071] If the material change rate is not greater than 30%, the reduction ratio is 70%, and the remaining 30% of the forecast quantity is retained;

[0072] If the material change rate is not greater than 60%, the reduction ratio is 40%, and the remaining 60% of the forecast quantity is retained;

[0073] If the material change rate is greater than 60%, the reduction ratio will be 0, no reduction will be made, and the entire forecast quantity will be retained.

[0074] In a possible implementation, the balance includes the amount balance, the predicted reduction includes the predicted reduction amount, and the actual reduction includes the reduction amount;

[0075] After, for each category, the smaller value between the predicted reduction amount of the first material group corresponding to the category and the remaining amount of the second material group corresponding to the category is used as the actual reduction amount of the first material group corresponding to the category, the method further includes:

[0076] Get the price of the first material group corresponding to each category;

[0077] Subtract the corresponding actual reduction amount from the predicted reduction amount of the first material group corresponding to each category to obtain the reduced amount of the first material group corresponding to each category;

[0078] For each category, the ratio of the reduced amount of the first material group corresponding to the category to the price of the first material group corresponding to the category is calculated to obtain the reduced quantity of the first material group corresponding to the category.

[0079] In this embodiment, after determining the actual reduced amount, the terminal device deducts the reduced amount from the predicted amount to obtain the reduced amount, and then calculates the reduced quantity based on the reduced amount. The terminal device may also first determine the reduced quantity, and then determine the reduced amount based on the reduced quantity.

[0080] In a possible implementation, the historical protocol is at least one;

[0081] Get historical agreements, including:

[0082] Determine whether the first historical agreement is signed in the form of a material group; the first historical agreement is any historical agreement;

[0083] If the first historical agreement is not signed in the form of material groups, the material balance of the first category in the first historical agreement is divided by the first material quantity corresponding to the first category to obtain the balance of the second material group corresponding to the first category in the first historical agreement; the first category is any category.

[0084] In this embodiment, if there are multiple historical agreements, the signing time of each historical agreement may be different, so some historical agreements may not be signed in the form of material groups. At this time, the historical agreements that are not signed in the form of material groups can be converted into the form of material groups. The terminal device can sort out the material balances of each category in the first historical agreement, and then divide the material balance of the first category in the first historical agreement by the latest material quantity, that is, divide it by the first material quantity corresponding to the first category, to obtain the balance of the second material group corresponding to the first category in the first historical agreement.

[0085] In a specific embodiment, the method for reducing forecast demand provided by the present invention may include the following steps:

[0086] (1) Set the agreed inventory reduction threshold, set the agreed balance calculation ratio and reduction ratio corresponding to different material change rates for equipment material groups and material material groups, and set the activation date for procurement by material group mode. The activation date for procurement by material group mode is used to distinguish whether the historical agreement was signed according to the material group mode.

[0087] (2) Obtain the forecast demand to be reduced and determine the scope of reduction. The forecast demand to be reduced can be the forecast demand confirmed by the staff in the demand reduction system.

[0088] (3) Import historical agreement information into the demand reduction system. For historical agreements that are not purchased according to the material group model, they are sorted according to the latest mapping relationship between material groups and material components and then imported into the system. Historical agreement information is used to calculate material change rates and perform reductions.

[0089] (4) Calculate the material change rate of each category in each historical agreement, and calculate the benchmark material change rate by batch and benchmark material.

[0090] (5) Perform reduction based on historical agreements. According to the material group category in the forecast demand to be reduced, query the historical agreements with surplus, and obtain the agreement execution ratio and remaining amount information. Summarize the forecast amount in the forecast demand to be reduced by material group category and category ID, and allocate it to the agreement lines with surplus. Among them, each historical agreement has multiple agreement lines, and each agreement line corresponds to a category of material group.

[0091] The logic for allocating the forecast amount is as follows: Based on the "Material Group Category and Category ID" dimension, fill in the "Demand Forecast" one by one from small to large according to "Breakage", and the "Demand Forecast" amount = "Breakage" amount, until the filled-in amount = the total forecast amount.

[0092] After the allocation is completed, the system calculates according to the reduction ratio to determine the deductible amount, the reduced amount, and the amount after reduction.

[0093] The calculation logic of the reduction amount is as follows: when the balance of the first historical agreement ≧ the sum of all demand forecasts under the first historical agreement, the reduction amount = demand forecast; when the balance of the first historical agreement < the sum of all demand forecasts under the first historical agreement, the reduction amount is calculated line by line item starting from the line with the smallest agreement execution progress under the first historical agreement, and the reduction amount = demand forecast * reduction ratio, until the sum of the reduction amounts of all agreement lines under the first historical agreement = the agreement balance.

[0094] Calculation logic for the amount submitted after reduction: amount after reduction = total forecast amount - reduced amount.

[0095] (6) Update the original forecast purchase plan based on the reduced amount. Summarize the reduced amount according to the material group category and category ID, and then allocate it according to the amount of forecast demand. Determine the quantity to be purchased after the reduction using the following formula:

[0096] Quantity after reduction = apportionment amount / material group price.

[0097] (7) Update the original forecast purchase requisition based on the reduced quantity and execute the purchase process after the purchase requisition is approved.

[0098] The above steps are implemented by the staff to control the demand reduction system, and the demand reduction system can also count and display the data calculated in the above steps.

[0099] The embodiment of the present invention provides a method for reducing forecast demand, the method comprising: obtaining forecast demand and historical agreements, the forecast demand including at least one category of first material group and the forecast quantity of each category of first material group, the historical agreement including at least one category of second material group and the surplus of each category of second material group; for any category, obtaining the material quantity of the first material group corresponding to the category as the first material quantity of the category, obtaining the material quantity of the second material group corresponding to the category as the second material quantity of the category, and calculating the material change rate of the category based on the first material quantity and the second material quantity of the category; for each category, determining the forecast reduction amount of the first material group corresponding to the category based on the material change rate of the category and the forecast quantity of the first material group corresponding to the category; for each category, the smaller value of the forecast reduction amount of the first material group corresponding to the category and the surplus of the second material group corresponding to the category is used as the actual reduction amount of the first material group corresponding to the category. The present invention determines the corresponding forecast reduction amount based on the material change rate of each category, compares the forecast reduction amount with the surplus of the historical agreement to obtain an accurate actual reduction amount, and can accurately reduce the forecast demand.

[0100] It should be understood that the order of execution of the steps in the above embodiment does not necessarily mean 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 embodiment of the present invention.

[0101] The following is an embodiment of the device of the present invention. For details not described in detail therein, reference may be made to the corresponding method embodiment described above.

[0102] Figure 2 The schematic diagram of the structure of the device for reducing predicted demand provided by an embodiment of the present invention is shown. For the convenience of explanation, only the part related to the embodiment of the present invention is shown, which is described in detail as follows:

[0103] like Figure 2 As shown, the forecast demand reduction device 2 includes:

[0104] A first acquisition module 21 is used to acquire forecast demand and historical agreements, wherein the forecast demand includes at least one category of first material group and forecast quantity of each category of first material group, and the historical agreements include at least one category of second material group and surplus of each category of second material group;

[0105] The second acquisition module 22 is used to acquire, for any category, the material quantity of the first material group corresponding to the category as the first material quantity of the category, acquire the material quantity of the second material group corresponding to the category as the second material quantity of the category, and calculate the material change rate of the category based on the first material quantity and the second material quantity of the category;

[0106] A predicted reduction amount determination module 23 is used to determine the predicted reduction amount of each category based on the material change rate of the category and the predicted amount of the first material group corresponding to the category;

[0107] The actual reduction amount determination module 24 is used to, for each category, take the smaller value of the predicted reduction amount of the first material group corresponding to the category and the remaining amount of the second material group corresponding to the category as the actual reduction amount of the first material group corresponding to the category.

[0108] In a possible implementation, the historical protocol is at least one;

[0109] The actual reduction determination module 24 includes:

[0110] A summing unit is used to sum the surplus of the second material group corresponding to each category in each historical agreement to obtain the total surplus;

[0111] A determination unit is used to take the smaller value of the predicted reduction amount of the first material group corresponding to the first category and the sum of the remaining amounts of the second material group corresponding to the first category as the actual reduction amount of the first material group corresponding to the first category; the first category is any category.

[0112] In a possible implementation, the forecast demand reduction device 2 further includes a historical protocol determination module;

[0113] The historical protocol determination module includes:

[0114] A sorting unit, configured to sort the historical agreements from small to large according to the surplus of the second material group corresponding to the first category when the predicted reduction amount of the first material group corresponding to the first category is less than the sum of the surplus of the corresponding second material group;

[0115] The write-off unit is used to write off the surplus of the second material group corresponding to the first category in each historical agreement in sequence by using the predicted reduction amount of the first material group corresponding to the first category, until the remaining predicted reduction amount is not greater than 0, so as to obtain the historical agreement after write-off.

[0116] In a possible implementation, the second acquisition module 22 is specifically configured to:

[0117] The difference between the quantity of the first material and the quantity of the second material in the first category is taken as the material change amount of the first category; the first category is any category;

[0118] The ratio of the change amount of the first category of materials to the amount of the second material is calculated to obtain the change rate of the first category of materials.

[0119] In a possible implementation, the predicted reduction amount determination module 23 is specifically used to:

[0120] Determine the reduction ratio corresponding to the first category based on the material change rate of the first category; the first category is any category;

[0121] The product of the reduction ratio corresponding to the first category and the predicted quantity of the first material group corresponding to the first category is calculated to obtain the predicted reduction quantity of the first category.

[0122] In a possible implementation, the balance includes the amount balance, the predicted reduction includes the predicted reduction amount, and the actual reduction includes the reduction amount;

[0123] The forecast demand reduction device 2 also includes a module for determining the quantity after reduction;

[0124] The module for determining the quantity after reduction includes:

[0125] A first acquisition unit is used to acquire the price of the first material group corresponding to each category after taking the smaller value of the predicted reduction amount of the first material group corresponding to the category and the remaining amount of the second material group corresponding to the category as the actual reduction amount of the first material group corresponding to the category;

[0126] A post-reduction amount determination unit is used to deduct the corresponding actual reduction amount from the predicted reduction amount of the first material group corresponding to each category to obtain the post-reduction amount of the first material group corresponding to each category;

[0127] The reduced quantity determination unit is used to calculate, for each category, the ratio of the reduced amount of the first material group corresponding to the category to the price of the first material group corresponding to the category, and obtain the reduced quantity of the first material group corresponding to the category.

[0128] In a possible implementation, the historical protocol is at least one;

[0129] The first acquisition module 21 is specifically used for:

[0130] Determine whether the first historical agreement is signed in the form of a material group; the first historical agreement is any historical agreement;

[0131] If the first historical agreement is not signed in the form of material groups, the material balance of the first category in the first historical agreement is divided by the first material quantity corresponding to the first category to obtain the balance of the second material group corresponding to the first category in the first historical agreement; the first category is any category.

[0132] The embodiment of the present invention provides a method for reducing forecast demand, the method comprising: obtaining forecast demand and historical agreements, the forecast demand including at least one category of first material group and the forecast quantity of each category of first material group, the historical agreement including at least one category of second material group and the surplus of each category of second material group; for any category, obtaining the material quantity of the first material group corresponding to the category as the first material quantity of the category, obtaining the material quantity of the second material group corresponding to the category as the second material quantity of the category, and calculating the material change rate of the category based on the first material quantity and the second material quantity of the category; for each category, determining the forecast reduction amount of the first material group corresponding to the category based on the material change rate of the category and the forecast quantity of the first material group corresponding to the category; for each category, the smaller value of the forecast reduction amount of the first material group corresponding to the category and the surplus of the second material group corresponding to the category is used as the actual reduction amount of the first material group corresponding to the category. The present invention determines the corresponding forecast reduction amount based on the material change rate of each category, compares the forecast reduction amount with the surplus of the historical agreement to obtain an accurate actual reduction amount, and can accurately reduce the forecast demand.

[0133] Figure 3 is a schematic diagram of a terminal provided by an embodiment of the present invention. Figure 3 As shown, the terminal 3 of this embodiment includes: a processor 30, a memory 31, and a computer program 32 stored in the memory 31 and executable on the processor 30. When the processor 30 executes the computer program 32, the steps in the above-mentioned various forecast demand reduction method embodiments are implemented, for example Figure 1 Steps 101 to 104 are shown. Alternatively, when the processor 30 executes the computer program 32, the functions of each module / unit in the above-mentioned device embodiments are realized, for example Figure 2 Functions of the modules / units 21 to 24 are shown.

[0134] Exemplarily, the computer program 32 may be divided into one or more modules / units, which are stored in the memory 31 and executed by the processor 30 to implement the present invention. The one or more modules / units may be a series of computer program instruction segments capable of implementing specific functions, which are used to describe the execution process of the computer program 32 in the terminal 3. For example, the computer program 32 may be divided into Figure 2 Modules / units 21 to 24 are shown.

[0135] The terminal 3 may be a computing device such as a desktop computer, a notebook, a PDA, or a cloud server. The terminal 3 may include, but is not limited to, a processor 30 and a memory 31. Those skilled in the art will appreciate that Figure 3It is only an example of terminal 3 and does not constitute a limitation on terminal 3. It may include more or fewer components than shown in the figure, or a combination of certain components, or different components. For example, the terminal may also include input and output devices, network access devices, buses, etc.

[0136] The processor 30 may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. A general-purpose processor may be a microprocessor or any conventional processor, etc.

[0137] The memory 31 may be an internal storage unit of the terminal 3, such as a hard disk or memory of the terminal 3. The memory 31 may also be an external storage device of the terminal 3, such as a plug-in hard disk, a smart media card (SMC), a secure digital (SD) card, a flash card, etc. equipped on the terminal 3. Further, the memory 31 may also include both an internal storage unit of the terminal 3 and an external storage device. The memory 31 is used to store the computer program and other programs and data required by the terminal. The memory 31 may also be used to temporarily store data that has been output or is to be output.

[0138] The technicians in the relevant field can clearly understand that for the convenience and simplicity of description, only the division of the above-mentioned functional units and modules is used as an example for illustration. In practical applications, the above-mentioned function allocation can be completed by different functional units and modules as needed, that is, the internal structure of the device can be divided into different functional units or modules to complete all or part of the functions described above. The functional units and modules in the embodiment can be integrated in a processing unit, or each unit can exist physically separately, or two or more units can be integrated in one unit. The above-mentioned integrated unit can be implemented in the form of hardware or in the form of software functional units. In addition, the specific names of the functional units and modules are only for the convenience of distinguishing each other, and are not used to limit the scope of protection of this application. The specific working process of the units and modules in the above-mentioned system can refer to the corresponding process in the aforementioned method embodiment, which will not be repeated here.

[0139] In the above embodiments, the description of each embodiment has its own emphasis. For parts that are not described or recorded in detail in a certain embodiment, reference can be made to the relevant descriptions of other embodiments.

[0140] Those skilled in the art will appreciate that the units and algorithm steps of each example 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 performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of the present invention.

[0141] In the embodiments provided by the present invention, it should be understood that the disclosed devices / terminals and methods can be implemented in other ways. For example, the device / terminal embodiments described above are only schematic. For example, the division of the modules or units is only a logical function division. There may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.

[0142] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0143] In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.

[0144] If the integrated module / unit is implemented in the form of 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, the present invention implements all or part of the processes in the above-mentioned embodiment method, and can also be completed by instructing the relevant hardware through a computer program. The computer program can be stored in a computer-readable storage medium. When the computer program is executed by the processor, the steps of the above-mentioned various forecast demand reduction method embodiments can be implemented. Among them, the computer program includes computer program code, and the computer program code can be in source code form, object code form, executable file or some intermediate form. The computer-readable medium may include: any entity or device that can carry the computer program code, recording medium, U disk, mobile hard disk, disk, optical disk, computer memory, read-only memory (ROM), random access memory (RAM), electrical carrier signal, telecommunication signal and software distribution medium. It should be noted that the content contained in the computer-readable medium can be appropriately increased or decreased according to the requirements of legislation and patent practices in the jurisdiction. For example, in some jurisdictions, according to legislation and patent practices, computer-readable media does not include electrical carrier signals and telecommunication signals.

[0145] The embodiments described above are only used to illustrate the technical solutions of the present invention, rather than to limit the same. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that the technical solutions described in the aforementioned embodiments may still be modified, or some of the technical features may be replaced by equivalents. Such modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present invention, and should all be included in the protection scope of the present invention.

Claims

1. A method for reducing forecast demand, characterized in that: include: Obtain forecast demand and historical agreements. The forecast demand is the forecast demand obtained by the planning management personnel based on historical experience when the specific project has not been issued and the initial design plan has not been completed. The forecast demand includes at least one category of first material group and the forecast quantity of each category of first material group. The historical agreement is an agreement signed before the forecast demand and not fully delivered. The historical agreement includes at least one category of second material group and the balance of each category of second material group. The balance represents the undelivered quantity or undelivered amount of each category of second material group. For any category, obtain the material quantity of the first material group corresponding to the category as the first material quantity of the category, obtain the material quantity of the second material group corresponding to the category as the second material quantity of the category, and calculate the material change rate of the category based on the first material quantity and the second material quantity of the category; For each category, determine the predicted reduction amount of the first material group corresponding to the category based on the material change rate of the category and the predicted amount of the first material group corresponding to the category; For each category, the smaller value between the predicted reduction amount of the first material group corresponding to the category and the remaining amount of the second material group corresponding to the category is used as the actual reduction amount of the first material group corresponding to the category.

2. The method according to claim 1, characterized in that The number of the historical protocols is at least one; The method of taking the smaller value of the predicted reduction amount of the first material group corresponding to the category and the remaining amount of the second material group corresponding to the category as the actual reduction amount of the first material group corresponding to the category includes: For each category, sum the balances of the second material group corresponding to the category in each historical agreement to obtain the total balance; The smaller value between the predicted reduction amount of the first material group corresponding to the first category and the sum of the remaining amounts of the second material group corresponding to the first category is taken as the actual reduction amount of the first material group corresponding to the first category; the first category is any category.

3. The method according to claim 2, characterized in that The method further comprises: If the predicted reduction amount of the first material group corresponding to the first category is less than the sum of the remaining amounts of the corresponding second material group, the historical agreements are sorted from small to large according to the remaining amounts of the second material group corresponding to the first category; The predicted reduction amount of the first material group corresponding to the first category is used to write off the surplus of the second material group corresponding to the first category in each historical agreement in sequence according to the sorting, until the remaining predicted reduction amount is no more than 0, thereby obtaining the historical agreement after write-off.

4. The method according to claim 1, characterized in that: Calculating the material change rate of the category based on the first material quantity and the second material quantity of the category includes: The difference between the quantity of the first material and the quantity of the second material in the first category is taken as the material change amount of the first category; the first category is any category; The ratio of the change amount of the first category of materials to the amount of the second material is calculated to obtain the change rate of the first category of materials.

5. The method according to claim 1, characterized in that Determining the predicted reduction amount of the first material group corresponding to the category based on the material change rate of the category and the predicted amount of the first material group corresponding to the category includes: Determine the reduction ratio corresponding to the first category based on the material change rate of the first category; the first category is any category; The product of the reduction ratio corresponding to the first category and the predicted quantity of the first material group corresponding to the first category is calculated to obtain the predicted reduction quantity of the first category.

6. The method according to claim 1, characterized in that The balance includes the balance of the amount, the predicted reduction includes the predicted reduction amount, and the actual reduction includes the reduction amount; After, for each category, taking the smaller value of the predicted reduction amount of the first material group corresponding to the category and the remaining amount of the second material group corresponding to the category as the actual reduction amount of the first material group corresponding to the category, the method further includes: Get the price of the first material group corresponding to each category; Subtract the corresponding actual reduction amount from the predicted reduction amount of the first material group corresponding to each category to obtain the reduced amount of the first material group corresponding to each category; For each category, the ratio of the reduced amount of the first material group corresponding to the category to the price of the first material group corresponding to the category is calculated to obtain the reduced quantity of the first material group corresponding to the category.

7. The method according to any one of claims 1 to 6, characterized in that: The number of the historical protocols is at least one; The obtaining of the historical protocol includes: Determining whether the first historical agreement is signed in the form of a material group; the first historical agreement is any historical agreement; If the first historical agreement is not signed in the form of material groups, divide the material balance of the first category in the first historical agreement by the quantity of the first material corresponding to the first category to obtain the balance of the second material group corresponding to the first category in the first historical agreement; the first category is any category.

8. A device for reducing predicted demand, characterized in that: include: The first acquisition module is used to acquire forecast demand and historical agreements. The forecast demand is the forecast demand obtained by the planning management personnel based on historical experience when the specific project has not been issued and the initial design plan has not been completed. The forecast demand includes at least one category of first material group and the forecast quantity of each category of first material group. The historical agreement is an agreement signed before the forecast demand and not fully delivered. The historical agreement includes at least one category of second material group and the balance of each category of second material group. The balance represents the undelivered quantity or undelivered amount of each category of second material group. A second acquisition module is used to acquire, for any category, the material quantity of the first material group corresponding to the category as the first material quantity of the category, acquire the material quantity of the second material group corresponding to the category as the second material quantity of the category, and calculate the material change rate of the category based on the first material quantity and the second material quantity of the category; A predicted reduction amount determination module is used to determine the predicted reduction amount of each category based on the material change rate of the category and the predicted amount of the first material group corresponding to the category; The actual reduction amount determination module is used to, for each category, take the smaller value of the predicted reduction amount of the first material group corresponding to the category and the remaining amount of the second material group corresponding to the category as the actual reduction amount of the first material group corresponding to the category.

9. A terminal comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 7 are implemented.

10. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the steps of the method as claimed in any one of claims 1 to 7 are implemented.

Citation Information

Patent Citations

  • Range-assigned material demand planning method and relevant apparatus

    CN101388088A

  • A method and apparatus for adjusting a business document

    CN109377055A

  • Material agreement inventory demand prediction method based on hybrid model

    CN111401808A

  • Material demand prediction method, system and device and readable storage medium

    CN111489029A

  • Material operation system

    CN112884401A