Material use condition extraction method and system based on demand distribution

Abstract

The invention provides a method and a system for indexed extraction of material use conditions based on demand distribution. The indexed calculation of the multi-dimensional data of the material is realized, and a quantitative basis is provided for data clustering analysis; the use trend of the materials can be effectively fused through additional weight coefficients and quantitative indexes; the fluctuation of material use is comprehensively considered, the quantitative indexes obtained through calculation enable the quantitative indexes of the materials with stable statistical data to be increased, and the indexes of the materials with large fluctuation of use data can be reduced; and meanwhile, the iterative relation between the materials is compatible, the use amount of the materials is standardized, and the use condition indexes of the materials are closely related to the standardized use amount.

Description

Technical Field

[0001] The present invention relates to the field of power equipment production management, and in particular to a material usage extraction method and system based on demand distribution. Background Art

[0002] Electrical materials are the basic components of electrical equipment. The production of electrical equipment requires a large amount of electrical materials. In order to ensure the orderly progress of the production process, a reasonable safety stock reserve is required. There are public calculation methods for safety stock calculation, which mainly include data such as the amount of materials used, the volatility of material procurement cycles, the volatility of usage, and safety factors. The safety stock theory is a theoretical safety stock data calculation method that can calculate the material to meet unstable demand. The algorithm is as follows:

[0003]

[0004] Among them, Z is the service level, d is the average usage, LT is the lead time, σ d is the standard deviation of dosage, σ LT is the lead time standard deviation.

[0005] However, the data calculated by the above algorithm has magnified the safety stock data of materials with unstable demand to a certain extent. For materials with stable usage, the safety stock will be reduced. For materials that are not used for actual demand, the accuracy of the safety stock is also different. Therefore, it is impossible to judge the correlation between materials and production from the size of the safety stock, and it is difficult to provide a useful reference for the production process.

[0006] How to design a method to accurately reflect the correlation between materials and production so that it can extract material usage according to actual needs is an urgent problem to be solved. Summary of the invention

[0007] Purpose of the invention: The present invention provides a material usage extraction method and system based on demand distribution, in order to solve the problem that the prior art cannot accurately reflect the correlation between materials and production.

[0008] Technical solution: The present invention discloses a material usage analysis method based on demand distribution, which is characterized by comprising the following steps:

[0009] S1 collects material usage records, divides them into different periods according to a certain time unit, and extracts the material usage in each period;

[0010] S2 calculates the general average usage of the material in each cycle, where the general average usage is the arithmetic average of the total usage of the material in all statistical cycles divided by the number of cycles;

[0011] S3 sets a weighted coefficient for the material usage in each cycle, and multiplies the material usage in each cycle by the weighted coefficient as the weighted usage of the material in each cycle, and calculates the weighted average usage of all cycles;

[0012] S4 calculates the fluctuation coefficient of each material based on the general average usage in S2 and the weighted average usage in S3, and defines the quantity-to-package ratio indicator function and the indicator function of the usage in the last three periods;

[0013] S5 establishes an index function of material usage and calculates the material usage index.

[0014] Furthermore, the usage record described in S1 includes material association information, material usage quantity, and material usage time. When extracting material usage, S1 uses the volume-to-pack ratio as the usage of each material, that is, the material usage d in the i-th cycle i The ratio of the minimum packaging quantity MIN(Bag) of the material, that is

[0015]

[0016] Furthermore, when S1 extracts the material usage, it determines whether the material has an iterative relationship based on the material association information. If so, for the material with an iterative relationship, the iterated old material usage is merged into the material usage, that is,

[0017] d 0i +d 1i →d 1i

[0018] Among them, d 0i is the usage of the old material iterated in the i-th cycle, d 1i is the material usage after the iteration of the i-th cycle, and the d obtained after merging 1i Amount of material used as extraction i .

[0019] Furthermore, the calculation formula for the general average amount d of materials in the period described in S2 is:

[0020]

[0021] Among them, x is the first cycle number of the material with usage record, T is the statistical period, and COUNT(T) is the number of cycles in the total sampling period.

[0022] Furthermore, the weighting coefficient setting method described in S3 is to assign a weighting coefficient of 1 to the first cycle with a usage record, and then assign a weighting coefficient of 1.15 times the previous cycle in sequence, and the formula is expressed as:

[0023] λ i =λi-1 1.15=1.15 i-1

[0024] Among them, λ i is the weighting coefficient corresponding to the i-th period.

[0025] The weighted average usage The calculation method is:

[0026]

[0027] Furthermore, the calculation formula of the fluctuation coefficient FC described in S4 is:

[0028]

[0029] The quantity-to-packet ratio indicator function is defined as follows:

[0030]

[0031] The usage indication functions for the last three cycles are defined as follows:

[0032]

[0033] Furthermore, the material usage index function PF calculation formula described in S5 is:

[0034]

[0035] The present invention also discloses a material usage analysis system based on demand distribution, which is characterized by comprising:

[0036] The information acquisition module is used to collect material usage records, divide them into different periods according to a certain time unit, and extract the material usage in each period;

[0037] The general average usage module is used to calculate the general average usage of the material in each cycle. The general average usage is the arithmetic average of the total usage of the material in all statistical cycles divided by the number of cycles;

[0038] The weighted average usage module is used to set a weighted coefficient for the material usage in each cycle, and calculate the weighted average usage of all cycles by multiplying the material usage in each cycle by the weighted coefficient as the weighted usage of the material in each cycle;

[0039] Function parameter module, used to calculate the fluctuation coefficient of each material, and define the quantity-to-package ratio indicator function and the indicator function of the usage in the last three periods;

[0040] The indicator function module is used to establish the indicator function of material usage and calculate the material usage indicator.

[0041] Beneficial effects: The present invention provides a method and system for indexing the use of materials based on demand distribution. The method can realize the index calculation of multi-dimensional data of materials. By configuring the weight coefficients of the usage in different usage cycles, the quantitative indicators can effectively integrate the usage trends of materials. The method also takes into account the volatility of material usage and the iterative relationship between materials to make the quantitative results more accurate.

[0042] Therefore, the present invention can achieve the close correlation between material usage and actual production needs. It is a material condition extraction method that accurately reflects the correlation between materials and production and reflects actual needs, and provides a quantitative basis for data clustering analysis. BRIEF DESCRIPTION OF THE DRAWINGS

[0043] Figure 1 It is a flow chart of a material usage extraction method based on demand distribution provided by the present invention. DETAILED DESCRIPTION

[0044] The present invention is further explained below in conjunction with the accompanying drawings and specific embodiments. It should be understood that the following specific embodiments are only used to illustrate the present invention and are not used to limit the scope of the present invention. It should be noted that, unless otherwise defined, the technical terms or scientific terms used in the present invention should be the usual meanings understood by those with general skills in the field to which the present invention belongs.

[0045] like Figure 1 The figure shows a flow chart of a material usage analysis method based on demand distribution disclosed by the present invention. The method is described in steps below.

[0046] S1. Collect material usage records, divide them into different periods according to a certain time unit, and extract the material usage in each period. The usage records in S1 include material related information, material usage quantity, and material usage time. The period includes year, year-month, year-week, year-month-day, etc.

[0047] Since different materials have different effects on products, that is, their usage quantity is not equal to their unit value, the usage of all materials needs to be standardized. Here, each material is standardized according to its minimum packaging quantity, making the value of each material data comparable, so that this algorithm can achieve the best feature expression ability. The quantity-to-pack ratio is used as the standard dosage of each material. The material dosage d in the i-th cycle i The ratio to the minimum packaging quantity MIN(Bag) of the material, that is:

[0048]

[0049] Since some materials have an iterative relationship, the iterative relationship between materials needs to be considered when calculating the material usage, that is, the usage of each period of the iterated material is merged into the usage of the iterated material, which reduces the data loss of historical data and makes the calculation result more consistent with the expectation of possible future usage. When S1 extracts the material usage, it determines whether the material has an iterative relationship based on the material association information. If so, for materials with an iterative relationship, the usage of the iterated old material is merged into the usage of the material, that is,

[0050] d 0i +d 1i →d 1i

[0051] Among them, d 0i is the usage of the old material iterated in the i-th cycle, d 1i is the material usage after the iteration of the i-th cycle, and the d obtained after merging 1i Amount of material used as extraction i .

[0052] S2. Calculate the general average usage of the material in each cycle, where the general average usage is the arithmetic average of the total usage of the material in all statistical cycles divided by the number of cycles;

[0053] Furthermore, the average amount of material used in the period described in S2 is The calculation formula is:

[0054]

[0055] Among them, x is the first cycle number of the material with usage record, T is the statistical period, and COUNT(T) is the number of cycles in the total sampling period.

[0056] S3. Set a weighting coefficient for the material usage in each cycle, multiply the material usage in each cycle by the weighting coefficient as the weighted usage of the material in each cycle, and calculate the weighted average usage of all cycles;

[0057] Furthermore, the weighting coefficient setting method described in S3 is to assign a weighting coefficient of 1 to the first cycle with a usage record, and then assign a weighting coefficient of 1.15 times the previous cycle in sequence, and the formula is expressed as:

[0058] λ i =λ i-1 1.15=1.15 i-1

[0059] Among them, λ iis the weighted coefficient corresponding to the ith period. Set the weight coefficient for the usage of each period in the statistical interval. The weight is geometrically weighted. This weight coefficient can increase the weight of recent usage data to reflect the usage trend of the material; the weighted average usage of all periods The calculation method is:

[0060]

[0061] S4. Based on the general average usage in S2 and the weighted average usage in S3, calculate the fluctuation coefficient of each material, and define the quantity-to-package ratio indicator function and the indicator function of the usage in the last three periods;

[0062]

[0063] Through this algorithm, materials with stable usage, that is, materials whose usage in each statistical period is close to the average value, have a lower fluctuation coefficient; conversely, materials with unstable usage have a higher fluctuation coefficient.

[0064] Define the quantity-to-packet ratio indicator function:

[0065]

[0066] Define the usage indicator function for the last three periods:

[0067]

[0068] S5. Establish the index function of material usage and calculate the material usage index. Considering the usage, demand volatility, usage trend and other factors, calculate the index function PF of material usage.

[0069]

[0070] The calculated index value of the material is the closeness of the material to the production process, which can be used to judge the importance of the material.

[0071] The material usage extraction method provided by the present invention realizes the index calculation of multi-dimensional data of materials, and provides a quantitative basis for data cluster analysis; by configuring the weight coefficients of the usage in different usage cycles, the quantitative index can effectively integrate the usage trend of materials; the method comprehensively considers the volatility of material usage and the iterative relationship between materials. Therefore, the present invention can accurately reflect the importance of materials in production and provide support for the grading and classification of materials.

Claims

1. A material usage analysis method based on demand distribution, characterized in that: The following steps are involved: S1 collects material usage records, divides them into different periods according to a certain time unit, and extracts the material usage in each period; S2 calculates the general average usage of the material in each cycle, where the general average usage is the arithmetic average of the total usage of the material in all statistical cycles divided by the number of cycles; S3 sets a weighted coefficient for the material usage in each cycle, and multiplies the material usage in each cycle by the weighted coefficient as the weighted usage of the material in each cycle, and calculates the weighted average usage of all cycles; S4 calculates the fluctuation coefficient of each material based on the general average usage in S2 and the weighted average usage in S3, and defines the quantity-to-package ratio indicator function and the indicator function of the usage in the last three periods; S5 establishes an index function of material usage and calculates the material usage index.

2. The material usage analysis method according to claim 1, characterized in that: The usage record described in S1 includes material-related information, material usage quantity, and material usage time.

3. The material usage analysis method according to claim 2, characterized in that: S1 uses the amount-to-pack ratio as the amount of each material when extracting the material usage, that is, the material usage d in the i-th cycle i The ratio of the minimum packaging quantity MIN(Bag) of the material, that is 4. The material usage analysis method according to claim 3, characterized in that: When S1 extracts the material usage, it determines whether the material has an iterative relationship based on the material association information. If so, for the material with an iterative relationship, the usage of the iterated old material will be merged into the usage of the material, that is, d 0i +d 1i →d 1i Among them, d 0i is the usage of the old material iterated in the i-th cycle, d 1i is the material usage after the iteration of the i-th cycle, and the d obtained after merging 1i Amount of material used as extraction i .

5. The material usage analysis method according to claim 4, characterized in that: The general average amount of material used in the period described in S2 The calculation formula is: Among them, x is the first cycle number of the material with usage record, T is the statistical period, and COUNT(T) is the number of cycles in the total sampling period.

6. The material usage analysis method according to claim 5, characterized in that: The weighting coefficient setting method described in S3 is to assign a weighting coefficient of 1 to the first cycle with a usage record, and then assign a weighting coefficient of 1.15 times the previous cycle in sequence. The formula is expressed as follows: l i =λ i-1 ·1·15=1.15 i-1 Among them, λ i is the weighting coefficient corresponding to the i-th period.

7. The material usage analysis method according to claim 6, characterized in that: The weighted average usage The calculation method is:

8. The material usage analysis method according to claim 7, characterized in that: The calculation formula for the volatility coefficient FC described in S4 is: The quantity-to-packet ratio indicator function is defined as follows: The usage indication functions for the last three cycles are defined as follows:

9. The material usage analysis method according to claim 8, characterized in that: The calculation formula of the index function PF of the material usage described in S5 is:

10. A material usage analysis system based on demand distribution, characterized in that: include: The information acquisition module is used to collect material usage records, divide them into different periods according to a certain time unit, and extract the material usage in each period; The general average usage module is used to calculate the general average usage of the material in each cycle. The general average usage is the arithmetic average of the total usage of the material in all statistical cycles divided by the number of cycles; The weighted average usage module is used to set a weighted coefficient for the material usage in each cycle, and calculate the weighted average usage of all cycles by multiplying the material usage in each cycle by the weighted coefficient as the weighted usage of the material in each cycle; Function parameter module, used to calculate the fluctuation coefficient of each material, and define the quantity-to-package ratio indicator function and the indicator function of the usage in the last three periods; The indicator function module is used to establish the indicator function of material usage and calculate the material usage indicator.

Images