CN117893139A - Material proportioning method based on industrial chain - Google Patents
Material proportioning method based on industrial chain Download PDFInfo
- Publication number
- CN117893139A CN117893139A CN202410294532.4A CN202410294532A CN117893139A CN 117893139 A CN117893139 A CN 117893139A CN 202410294532 A CN202410294532 A CN 202410294532A CN 117893139 A CN117893139 A CN 117893139A
- Authority
- CN
- China
- Prior art keywords
- data
- material proportioning
- materials
- level
- input
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 239000000463 material Substances 0.000 title claims abstract description 282
- 238000000034 method Methods 0.000 title claims abstract description 51
- 238000004519 manufacturing process Methods 0.000 claims abstract description 52
- 238000004364 calculation method Methods 0.000 claims abstract description 45
- 238000012795 verification Methods 0.000 claims abstract description 18
- 230000001502 supplementing effect Effects 0.000 claims abstract description 8
- 239000000203 mixture Substances 0.000 claims description 16
- 210000002268 wool Anatomy 0.000 claims description 14
- 238000012384 transportation and delivery Methods 0.000 claims description 6
- 210000004209 hair Anatomy 0.000 claims description 5
- 238000012216 screening Methods 0.000 claims description 5
- 238000012790 confirmation Methods 0.000 claims description 3
- 238000005259 measurement Methods 0.000 abstract description 2
- 230000006870 function Effects 0.000 description 9
- 238000010586 diagram Methods 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 3
- 238000007726 management method Methods 0.000 description 3
- 238000013468 resource allocation Methods 0.000 description 3
- 230000008901 benefit Effects 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 239000010421 standard material Substances 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000002860 competitive effect Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000001419 dependent effect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000002708 enhancing effect Effects 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- -1 order quantity Substances 0.000 description 1
- 238000013439 planning Methods 0.000 description 1
- 239000002994 raw material Substances 0.000 description 1
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to the technical field of manufacturing industry chain material proportioning, and discloses a material proportioning method based on an industry chain, which comprises the following steps of S1: acquiring an industrial chain manufacturing order and material proportioning data of order manufacturing; s2: constructing a material proportioning verification model, verifying the integrity of material proportioning data, traversing the material proportioning data by a recursion traversal method to obtain missing data, and supplementing the missing data to obtain complete material proportioning data; s3: and constructing a material proportioning calculation model, and calculating an optimal material proportioning requirement value according to the complete material proportioning data. According to the invention, the material proportioning data manufactured by the order form is subjected to the material proportioning verification model and the material proportioning calculation model by traversing global measurement, when unexpected demands are measured, the actual situation of the real production environment is considered integrally, and the phenomenon of adapting to the on-demand production environment is effectively realized.
Description
Technical Field
The invention relates to the technical field of manufacturing industry chain material proportioning, in particular to a material proportioning method based on an industry chain.
Background
In the current production and manufacturing industry chain, a manufacturing operation management system manufactured by using an informatization technology is widely applied to the manufacturing industry, and realizes comprehensive management, monitoring and prediction of a manufacturing process.
The material proportioning of materials required in the production and manufacturing industry also enters the technical field of informatization, the material proportioning mainly uses a multiple multiplexing mode technology (Multiple Reuse Pattern, abbreviated as MRP), the MRP is a practical technology for making a production plan of a product according to a customer order, then generating a progress plan based on the product to form a material structure table and an inventory condition of the product, and calculating the required quantity and the required time of the required materials through a computer so as to determine the processing progress and the ordering schedule of the materials.
However, the manufacturing business is too complex, and the material ratio is not only dependent on the order volume and the stock state of the company, but also related to the industry and the status of the manufacturing. For example, the problems of difficulty in order production, flexibility of insertion and site, competitive delivery time and on-time delivery often occur in small and medium-sized manufacturing enterprises, the production pressure is far greater than that of some large and medium-sized enterprises, and at this time, the MRP can not obtain accurate material demand and prediction of processing progress according to the original material proportioning calculation mode. The MRP theory itself has defects and errors, as the root cause. The current architecture and manner of MRP material demand planning has been difficult to adapt to on-demand production environments.
Disclosure of Invention
In order to effectively adapt to production environments and obtain a material demand proportioning plan more suitable for the environments, the invention provides a material proportioning method based on an industrial chain.
The material proportioning method based on the industrial chain provided by the invention adopts the following technical scheme:
a material proportioning method based on an industrial chain comprises the following steps:
s1: acquiring an industrial chain manufacturing order and material proportioning data of order manufacturing;
s2: constructing a material proportioning verification model, verifying the integrity of material proportioning data, traversing the material proportioning data by a recursion traversal method to obtain missing data, and supplementing the missing data to obtain complete material proportioning data;
S3: and constructing a material proportioning calculation model, and calculating an optimal material proportioning requirement value according to the complete material proportioning data.
Further, the acquiring the material proportioning data of the industrial chain manufacturing order and the order manufacturing includes:
the method comprises the steps of inputting a source data table, extracting industrial chain manufacturing order field data in the source data table by using a reading data function, extracting order field data by using a data screening function, and grouping and marking the order field data according to a material composition structure, wherein the order data comprises industrial chain orders, order materials and order quantity, the material data comprises material demand time, latest delivery time and material process drawings, and the industrial chain orders comprise wool demand, real-time stock quantity, re-acquisition quantity, non-wool demand ex-warehouse quantity and manufactured quantity.
Further, the verifying the integrity of the material proportioning data includes:
Dividing the marked order field data into association relations of materials of all levels according to the composition structure, reading the material structure of all levels, verifying the codes and the model comparison of the input materials and the output materials of the materials of all levels, verifying the logic principle and the numerical legitimacy, and judging the integrity of the material proportioning data according to the logic principle and the numerical legitimacy; if the logic principle and the numerical legitimacy are met, the material proportioning data is complete, the method enters S3, if the logic principle and the numerical legitimacy are not met, the material proportioning data is incomplete, the material proportioning data is traversed through a recursion traversal method to obtain missing data, and the missing data is supplemented.
Further, the verifying the logic principle and the numerical legitimacy includes:
The logic principle follows: the level of the composition structure is larger than 1, the output materials of the final level are equal to the manufacturing materials of the original requirement, and the output materials of the upper level are input materials of the lower level between the adjacent levels;
The validity of the values follows: the quantity of the upper-level output materials among the adjacent layers is equal to the quantity of the lower-level input materials, and in the same layer, the quantity of the input materials is not necessarily equal to the quantity of the layer output materials; the input material of the level is more than or equal to 1, and the quantity of the output material of the final level is more than or equal to 0; the input-output ratio between adjacent layers is larger than 0, and the input-output ratio between the top layer and the final layer is larger than 0.
Further, traversing the material proportioning data by a recursive traversal method to obtain missing data and supplementing the missing data, wherein obtaining complete material proportioning data comprises the following steps:
judging the type of the missing data, and reading whether the missing data is one of a hierarchy, an input-output type and a quantity missing;
traversing the material proportioning data by adopting a recursion traversal method, and firstly obtaining the root node of the highest hierarchy. Judging whether the root node of the highest level has a left subtree, traversing the left subtree of the next level if the root node of the highest level has the left subtree, traversing the right subtree of the next level if the root node of the highest level does not have the left subtree, returning the parent node of the level if the root node of the highest level does not have the right subtree, and ending the traversing if the root node of the highest level does not have the parent node;
Supplementing the traversed nodes with data information of the missing level, input-output objects or other material proportions with the quantity matching degree of more than 80%;
if no related missing data is found after traversing, the verification of the material proportion is not passed, and the material proportion is returned to be manually configured;
If the data with the matching degree reaching more than 80% is traversed, the missing data is inserted according to the traversing result, and the material proportioning data is issued by manual confirmation.
Further, the calculating the optimal material proportioning requirement value includes:
Splitting the marked order field data into association relations of all layers of materials according to the composition structure, and reading the structure of all layers of materials, wherein the total of the layers is n layers;
Respectively calculating the wool demand, the net demand, the planned output, the planned input, the planned stock, the start time and the completion time for the ith layer structure level, wherein i < = n;
judging whether the low-level code is equal to the current level i, if so, outputting a calculation result and calculating the next material;
If not, judging whether the material has child nodes, if not, outputting a calculation result and calculating the next material;
If so, judging whether i is equal to n, if so, outputting a calculation result and calculating the next material, and if not, returning to recalculate the wool demand, the net demand, the planned output, the planned input, the estimated stock quantity, the start-up time and the completion time after i=i+1.
Further, the calculating the hair demand and the net demand includes:
The calculation of the wool demand is specifically as follows:
；
Wherein t is the operation time period, is the hair demand in the t time period, di (t) is the quantity of materials scheduled to be delivered by the ith layer of the materials in the t time period, qi is the quantity of materials of the i-1 layer required by the ith layer, and n is the structural layer.
Multiplexing the calculation modes to obtain an optimal solution of the net demand of each level;
The formula of the net demand calculation is:
；
wherein Proportion is input-output ratio in a material proportioning model, vt is real-time dynamic quantity of the extracted material, and G (t) represents input quantity of lower material Di required for outputting upper material;
when G (t) is less than or equal to 0, the existing resources which indicate the net demand of the material can be met;
when G (t) > 0, this indicates that the net demand for the material is not sufficient resources to be filled.
Further, the calculating the planned output, the planned input, and the estimated stock amount includes:
The order amount is EOQ, and the planned output amount is P (t);
G (t) > EOQ, the planned output P (t) =g (t), G (t) < EOQ, the planned output P (t) = EOQ;
R(t)=P(t)*(1-p)；
Wherein R (t) is the planned input quantity, and p is the rejection rate, and the rejection rate is a manual input parameter;
the estimated stock quantity is H (t), and the estimated stock quantity in the last period is H (t-1);
if Demandrough (t) > H (t-1) -safestock, H (t) =p (t) -G (t);
otherwise Demandrough (t) < = H (t-1) -safestock, H (t) = H (t-1) -Demandrough (t).
Further, the calculating the start time and the completion time includes:
Start time (ES):
ES(i,j)=ET(i)；
Wherein ET (i) refers to the earliest start time defined by the initial process of the BOM product, and ES (i, j) refers to the start time of the operation time period;
finishing time (EF):
EF(i,j)=ET(i)+T(i,j) = ES (i) +T (i,j)；
where T (i, j) refers to the working time, EF (i, j) refers to the finishing time within the working time, and ES (i) refers to the earliest start time.
In summary, the invention has the following beneficial technical effects:
According to the material proportioning method based on the industrial chain, the material proportioning verification model is constructed based on the industrial chain to verify the integrity of the material proportioning data, the material proportioning data is traversed through a recursion traversal method to obtain missing data, the missing data is supplemented to obtain complete material proportioning data, and the complete material proportioning data is used for calculation, so that the material proportioning method can effectively adapt to the production environment, and a material demand proportioning plan more suitable for the environment is obtained;
In the material proportioning method based on the industrial chain, the material proportioning data manufactured by the order form penetrates through the material proportioning verification model and the material proportioning calculation model by using the traversing global measurement, and when the unexpected demand is measured, the actual situation of the real production environment is considered integrally, so that the phenomenon of adapting to the on-demand production environment is effectively realized.
Drawings
Fig. 1 is a flow chart of the present invention.
Fig. 2 is a block diagram of the integrity between layers of the present invention.
FIG. 3 is a level miss read by the present invention.
FIG. 4 is a diagram showing the absence of input-output types read by the present invention.
FIG. 5 is a missing number read by the present invention.
FIG. 6 is a structural model diagram of the material A mixture ratio of the invention.
Fig. 7 is a diagram of a traversal to the left subtree of a in the present invention.
Fig. 8 is a graph of traversal to the left subtree of B in the present invention.
Fig. 9 is a diagram of traversing to the right subtree of B in the present invention.
Fig. 10 is a graph of traversal to the right sub-tree of a in the present invention.
Fig. 11 is a view of traversing a subtree of C in the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments.
According to an embodiment of the present application, there is provided an industrial chain based material proportioning method, it being noted that the steps shown in the flowcharts of the figures may be performed in a computer system such as a set of computer executable instructions, and although a logical order is shown in the flowcharts, in some cases the steps shown or described may be performed in an order different from that herein.
The embodiment of the invention discloses a material proportioning method based on an industrial chain. Referring to fig. 1, comprising:
s1: acquiring an industrial chain manufacturing order and material proportioning data of order manufacturing;
s2: constructing a material proportioning verification model, verifying the integrity of material proportioning data, traversing the material proportioning data by a recursion traversal method to obtain missing data, and supplementing the missing data to obtain complete material proportioning data;
S3: and constructing a material proportioning calculation model, and calculating an optimal material proportioning requirement value according to the complete material proportioning data.
The method specifically comprises the following steps:
the first step:
Inputting a source data table, extracting industrial chain manufacturing order field data in the source data table by using a reading data function, extracting manufactured basic data by using a data screening function, and marking the data in groups, wherein the industrial chain manufacturing basic data is acquired to cover industrial chain orders, order materials, order quantity, material demand time, latest delivery time and material process drawings.
By way of example, the source data table is presented as:
the method comprises the steps of extracting industrial chain manufacturing order field data in a source data table by using a reading data function as follows:
The data screening function is utilized to group and mark the field data of the industrial chain manufacturing order according to the material composition structure, all the field data of the industrial chain manufacturing order are merged and summarized for the same type of data, and different types of data are processed in parallel:
and a second step of:
The material proportioning model mainly performs integrity verification on a material composition structure, wherein the integrity verification method is to split marked order field data into association relations of materials of all levels according to the composition structure, read the material structures of all levels, verify the codes and the model comparison of input and output of the materials of all levels, verify logic principles and numerical legality, and judge the integrity of the material proportioning data according to the logic principles and the numerical legality; if the logic principle and the numerical legitimacy are met, the material proportioning data is complete, the next step is carried out, if the logic principle and the numerical legitimacy are not met, the material proportioning data is incomplete, the material proportioning data is traversed through a recursion traversal method to obtain missing data, and the missing data is supplemented.
Firstly, proportioning materials, wherein each material proportioning comprises raw materials and produced materials, basic data material information of manufacture is extracted, a material structure is read, logicality and numerical legitimacy are verified, the logicality principle is required to follow that the level of a composition structure is greater than 1, and the produced materials of the final level are equal to the manufactured materials of the original requirement; between adjacent layers, the output materials of the upper stage are input materials of the lower stage; the numerical value validity verification and following principle is that the quantity of the upper-level output materials between adjacent layers is equal to the quantity of the lower-level input materials; the quantity of the input materials in the same level is not necessarily equal to the quantity of the output materials in the level; the input materials of the layers are larger than or equal to 1, and the preset quantity of the output materials of the final layers is larger than or equal to 0; the input-output ratio between adjacent layers is greater than 0, and the input-output ratio between the top layer and the final layer is greater than 0, and the integrity structure is shown in fig. 2.
When the integrity of the material proportioning structure is verified, the missing data are searched and supplemented in a traversing mode, the type of the missing data is analyzed preferentially, and whether the missing data are in a hierarchy, input-output type or one of quantity missing is read, wherein the missing data are in a missing data state as shown in fig. 3, 4 and 5.
The missing data is subjected to traversal of a material proportioning model in an industrial chain, so that data information of other material proportioning with the inserted level, input and output objects and the quantity matching degree of more than 80% is supplemented; in the traversing of the industrial chain material proportioning model, a recursive traversing method is adopted to traverse the structure of the material proportioning model.
Firstly, using a material proportioning model which is subjected to integrity verification, as shown in a structural model of material proportioning A in FIG. 6:
the six node values are 123456, and the corresponding material proportioning model structure is as follows:
when A is a root node, the left subtree of A is D, the right subtree of A is E, and the value of A is 1;
when B is a root node, the left subtree of B is D, the right subtree of B is E, and the value of B is 2;
When C is the root node, the left subtree of C is null, the right subtree of C is F, and the value of C is 3;
When D is a root node, the left subtree of D is null, the right subtree of F is null, and the value is 4;
When E is a root node, the left subtree of E is null, the right subtree of F is null, and the value is 5;
when F is the root node, the left subtree of F is null, the right subtree of F is null, and the value is 6.
The traversing sequence of the material proportioning model of the industrial chain is as follows:
root node= (left subtree of root node= (right subtree of root node);
And in the whole step, firstly, a root node A is obtained, and whether the node A has a left subtree or not is judged. And traversing to the next left subtree. The right subtree is traversed without, and the parent node is returned without the right subtree. If there is no parent node, the process ends.
As shown in fig. 7, this step traverses the left subtree of a, first obtains a node, and traverses the left subtree node of a down if a is found to exist. At the moment, traversing to the node is that the element A is 1.
And reaching the node B, acquiring the node B, and judging whether the node B has a left subtree or not. And traversing to the next left subtree. The right subtree is traversed without, and the parent node is returned without the right subtree. If there is no parent node, the process ends.
As shown in fig. 8, this step traverses the left subtree of B, and if B is found to exist, the left subtree node of B is traversed down. The traversed nodes are AB, and the elements are 1 and 2.
And (3) reaching the D node, acquiring the D node, and then judging whether the D node has a left subtree or not, and traversing to the next node. The right subtree is traversed without, and the parent node is returned without the right subtree.
At this time, D is found to have no left subtree, the right subtree traversing D is found to have no right subtree, and the method returns to the node B and traverses to the right subtree of the node B. The nodes traversed at this time are ABD, and the elements are 1, 2 and 4.
As shown in fig. 9, the E node is reached and acquired. And judging whether the E has a left subtree or not. And traversing to the next node. The right subtree is traversed without, and the parent node is returned without the right subtree.
At this time, if no left or right subtree is found in the E node, the B node returns to the A node, the A node traverses to the C node again, at this time, the traversed node is ABDE, and the elements are 1, 2,4 and 5.
As shown in fig. 10, the C node is reached and acquired. And judging whether C has a left subtree or not. And traversing to the next node. The right subtree is traversed without, and the parent node is returned without the right subtree.
At this time, if the C node has no left subtree, the F node accessing the right subtree of the C node acquires the root node of the F node. Traversing the left subtree of F, wherein the obtained nodes are ABDEC, and the elements are 1, 2, 4, 5 and 3.
As shown in fig. 11, the F node is reached and acquired. The F node has no left subtree and right subtree, returns to the father node C node of the F node, and returns to the father node A node of the C. And finally, finding that the A has no father node, and ending the program. The obtained nodes are ABDECF, and the elements are 1,2, 4,5, 3 and 6.
The nodes obtained by examples in the material proportioning verification model traversal are as follows: ABDECF, wherein the elements are 1,2, 4, 5, 3 and 6; let the standard material node be: SMN, elements are: 11. 12, 13. In the material proportioning model traversal, the matching degree is 0% through node and element comparison. And traversing the material proportion verification model, and if no related data is found, failing the material proportion verification, and returning to the material proportion to be manually configured.
The nodes obtained by examples in the material proportioning verification model traversal are as follows: ABDECF, wherein the elements are 1,2, 4, 5, 3 and 6; let the standard material node be: ABDECX, the elements are: 1.2, 4, 5, 3, 9. The matching degree of the node and the element contrast in the material proportioning model traversal is 5:6 and is about 83%. Traversing to reach the matching degree of more than 80% in the material proportioning model, inserting the missing data F according to the traversing result, inserting the elements 9 and the corresponding quantity, and manually confirming to release the material proportioning data.
According to the material proportioning verification model, through the traversing calculation process of the existing material proportioning, the material proportioning calculation is conducted layer by layer from top to bottom aiming at new demands, the efficiency of material proportioning can be improved to the greatest extent under various alternative scenes, the generation of unknown demands is effectively prevented, and meanwhile, the rapid proportioning scheme of the material demands is guaranteed.
And a third step of:
and calculating an optimal result of the material demand through a material proportion calculation model, and respectively carrying out split calculation on the proportion of each material level by an algorithm to obtain an optimal material proportion demand value. The material proportioning calculation model is used for carrying out structural splitting on materials in all layers of material proportioning based on the manufacturing basic data demand degree of an industrial chain, and calculating the optimal manufacturing quantity (net demand quantity) of all layers of materials.
The material proportioning calculation model comprises the following steps:
Splitting the marked order field data into association relations of all layers of materials according to the composition structure, and reading the structure of all layers of materials, wherein the total of the layers is n layers;
Respectively calculating the wool demand, the net demand, the planned output, the planned input, the planned stock, the start time and the completion time for the ith layer structure level, wherein i < = n;
judging whether the low-level code is equal to the current level i, if so, outputting a calculation result and calculating the next material;
If not, judging whether the material has child nodes, if not, outputting a calculation result and calculating the next material;
If so, judging whether i is equal to n, if so, outputting a calculation result and calculating the next material, and if not, returning to recalculate the wool demand, the net demand, the planned output, the planned input, the estimated stock quantity, the start-up time and the completion time after i=i+1.
The calculation of the hair demand is specifically as follows:
；
Wherein t is the operation time period, is the hair demand in the t time period, di (t) is the quantity of materials scheduled to be delivered by the ith layer of the materials in the t time period, qi is the quantity of materials of the i-1 layer required by the ith layer, and n is the structural layer.
Multiplexing the calculation modes to obtain an optimal solution of the net demand of each level;
the formula for the net demand calculation is:
；
wherein Proportion is input-output ratio in a material proportioning model, vt is real-time dynamic quantity of the extracted material, and G (t) represents input quantity of lower material Di required for outputting upper material;
when G (t) is less than or equal to 0, the existing resources which indicate the net demand of the material can be met;
when G (t) > 0, this indicates that the net demand for the material is not sufficient resources to be filled.
The order amount is EOQ, and the planned output amount is P (t);
g (t) > EOQ, the planned output P (t) =g (t);
g (t) < EOQ, the planned output P (t) = EOQ.
Planned input R (t) =p (t) ×1-P;
wherein R (t) is the planned input amount, and p is the rejection rate, and the rejection rate is a manual input parameter.
The estimated stock quantity is H (t), and the estimated stock quantity in the last period is H (t-1);
if Demandrough (t) > H (t-1) -safestock, H (t) =p (t) -G (t);
otherwise Demandrough (t) < = H (t-1) -safestock, H (t) = H (t-1) -Demandrough (t).
Start time (ES):
ES (i, j) =et (i); wherein ET (i) refers to the earliest start time defined by the initial process of the BOM product, and ES (i, j) refers to the start time of the operation time period;
Finishing time (EF): EF (i, j) =et (i) +t (i, j) =es (i) +t (i, j);
where T (i, j) refers to the working time, EF (i, j) refers to the finishing time within the working time, and ES (i) refers to the earliest start time.
Taking the net demand as an example, when the net demand of materials is created in combination with the industrial chain order in the example, the top layer of the material proportioning model is taken as a service target, the top layer target demand is fully satisfied when each layer is calculated, the service target is calculated to be n-1 layers when the calculation reaches the nth layer, the layer service target is changed according to the change of the top layer demand, and therefore, under the net demand calculation multiplexing mode, the calculation result quantity has the dynamic change condition. Let the original requirement of the current period A be the extracted value 69, and the real-time Vt stock be:
in the material proportioning model structure, the wool demand of the lower layer is determined by the net demand of the upper layer, a multiplexing mode is adopted in multi-level calculation, namely, the net demand of the upper layer is extracted and is introduced into the lower layer for calculation, and the Vt value is dynamically extracted by a program in real time when the Vt is extracted.
The input-output ratio of each level of the introduced A is 1:2, and the quantity value required for producing 1 level of material of each level of the A can be written as follows according to the material proportioning model of the A; 1 a=2b+2c=4d+4e+4f. Introducing the original demand 69 of A, the original demand required by each layer of material can be calculated as follows: b=138, c=138, d=276, e=276, f=276.
In this instance, the real-time inventory of Vt is introduced, the multiplexing mode will pull the Vt values of each level, calculate one by one from the top layer, and after the level requirement of the material is satisfied, the multiplexing mode will automatically read the next level of the material ratio to calculate, if the last level has been reached, the grouping will be the recommended result of each level:
Manually confirming whether the suggested result is executed or not, if the revocation is executed, the revoked suggested result is incorporated into the next calculation to be recalculated; if the operation does not need to be canceled, outputting a calculation result; according to the result of the manual confirmation, recording a material proportioning algorithm model to perform diversified machine model learning, wherein the diversified machine model learning is decision learning based on a Bayesian theory.
According to the application, the resource allocation is optimized, and the material proportioning model is used for reasonably proportioning and optimizing the resource allocation according to the requirements and supply conditions of materials in each link of the industrial chain and through extracting the screening of industrial chain orders and material data, so that the efficiency and benefit of the whole industrial chain are improved.
The cost of demand accounting, material cost and the like are effectively reduced through reasonable material proportion, so that the cost of the whole industrial chain is reduced. The model can be reasonably proportioned according to the characteristics and the performances of materials, so that the quality and the stability of products are improved. The material proportioning algorithm model based on the industrial chain can predict the demands and supplies of the whole industrial chain, so that material preparation and adjustment are performed in advance, and the predictability of the whole industrial chain is enhanced. The algorithm model can rapidly complete demand calculation according to the existing model and other data, timely adjustment is carried out, and flexibility and adaptability of the whole industrial chain are improved.
The material proportioning algorithm model based on the industrial chain has the advantages of optimizing resource allocation, reducing cost, improving quality, enhancing predictability, improving flexibility and the like, and has important significance for development and management of the whole industrial chain manufacturing industry.
The algorithm pseudo code of a part of the process of the material proportioning algorithm model based on the industrial chain provided by the embodiment is given below.
After extracting the manufacturing data of the industrial chain, the pseudo code of the operation of the material proportioning algorithm model can be as follows:
orderItemIds-/order Material ID set
function count(orderItemIds):
TENANTMAP = loginfo. Gettenant ()/packet lock calculation
lockKey = "mes:mrpcount:redissonLock:" + tenantMap.get("id")
redissonLock = redissonClient.getLock(lockKey)
try:
isLocked = redissonLock.tryLock(10, TimeUnit.MINUTES)
if (!isLocked):
Throw BusinessException ("calculation has not been completed, please try again later |")/prompt & early warning +.
if (isEmpty(orderItemIds)):
Throw BusinessException ("select order details |")/select order
No=localdatetime. No ()/build generation record
fkRecordId = generateUUID()
record = new Record(fkRecordId)
record.setCreateDate(now)
Recordservice (save)/. Times.checking if +.
if (hasCalculatedMRP(orderItemIds)):
Throw BusinessException ("selected order details have been calculated by G (t)," please refresh page reselection | ")/obtain user selected order details data
orderItems = queryOrderItems(orderItemIds)
if (isEmpty(orderItems)):
Throw BusinessException ("no order details found
MRPPARAMETER = NEW MRPPARAMETER (record)/traversal calculation G (t)/(x)
For item in orderItems construction of G (t) calculation results
nowResult = new Result(item, fkRecordId, "0", now)
Non result. Setitems (item. Getitems ())/. Calculated Vt purchasing advice +.
if (item.getAttribute() == 1):
countOne(nowResult)
resultService.save(nowResult)
Continuous/calculating production advice of G (t)
mrpParameter.setResult(nowResult)
mrpParameter.getMaterialIds().add(nowResult.getFkMaterialId())
Recursively calculating G (t) production advice:/according to the material proportioning model
countRecursion(mrpParameter, nowResult)
except Exception as e:
Error ("error in computing G (t)", e.getMessage ())
throw e
finally:
RedissonLock ()/-recursively calculating the lower level G (t)/(x)
MRPPARAMETER-/G (t) parameter
Presult-/parent Result object
* Function countRecursion (MRPPARAMETER, presult) calculating the G (t) of the current mass
countOne(presult)
ResultService (presult)/query the composition of the proportioning model of the current material
materialId = presult.getFkMaterialId()
productBomIds = getProductBomIds(materialId)
if (isEmpty(productBomIds)):
Throw BusinessException ("Material" +presult. GetMaterialCode () + "-" +presult. GetMaterialName () + ") has no published and enabled material proportioning model"
bomProcessesInputs = getBomProcessesInputs(productBomIds)
Circulation calculating G (t) for each level of material
for item in bomProcessesInputs:
materialVo = getMaterialInfo(item.getFkMaterialId())
if (materialVo == null):
Throw BusinessException (input materials of "materials" +presult. GetMaterial name () + "), no +|" exists in the Material mixture ratio model
grossDemand = calculateGrossDemand(item, presult)
nowResult = new Result(materialVo, mrpParameter.getRecord(), presult.getId(), grossDemand, mrpParameter.getResult())/* Calculating purchase advice
if (item.getAttribute() == 1):
countOne(nowResult)
resultService.save(nowResult)
When calculating production advice, interrupting recursion if circular dependence of the material proportioning model is met
if (mrpParameter.getMaterialIds().contains(item.getFkMaterialId())):
countOne(nowResult)
resultService.save(nowResult)
Return/continue downrecursion
CountRecursion (MRPPARAMETER, nowResult)/. Calculate G (t). About.
Result-Result/subject
function countOne(result):
fkMaterialId = result.getFkMaterialId()
unsettledMap = queryUnsettledMRP(fkMaterialId)
inventorys = queryInventory(fkMaterialId, STATUS_PASS_CODE)
Calculating the current material Vt real-time inventory +.
result.setCurrentInventory(getCurrentInventory(inventorys))
Calculating the unconditional list G (t) ×
if (unsettledMap != null):
result.setMrpUnsettledNet(unsettledMap.get("mrp_unsettled_net"))
Calculating Vt procurement in transit +.
procures = queryProcure(fkMaterialId)
result.setPurchasingTransit(getPurchasingTransit(procures))
Calculating Vt production in
makes = queryQuantityByIds(fkMaterialId)
Result. SetWorkInProgress (getWorkInProgress (makes))/calculate unconditional single Vt wool demand
if (unsettledMap != null):
result.setMrpUnsettledGross(unsettledMap.get("mrp_unsettled_gross"))
If ("0". Equals (result. GetParentId ())))/number of top order delivered
result.setMrpOutbound(queryUnsettledOutput(result.getFkMaterialId()))
Else:/. Non-top material calculates the number of the non-statement that the non-statement is delivered out of the warehouse, and the upper level of the non-statement corresponds to the number of the delivery of the material to the warehouse
result.setMrpOutbound(getMrpOutbound(result.getFkMaterialId()))
Record the number of times of calculation of the current material
result.setCountNumber(1)
results = queryLatestResults(result.getFkMaterialId())
if (isNotEmpty(results)):
Result.setCountNumber (result.get (0). GetCountNumber () +1)/. Calculate G (t) net ×
result.setNetDemand()。
The above embodiments are not intended to limit the scope of the present invention, so: all equivalent changes in structure, shape and principle of the invention should be covered in the scope of protection of the invention.
Claims (9)
1. The material proportioning method based on the industrial chain is characterized by comprising the following steps of:
s1: acquiring an industrial chain manufacturing order and material proportioning data of order manufacturing;
s2: constructing a material proportioning verification model, verifying the integrity of material proportioning data, traversing the material proportioning data by a recursion traversal method to obtain missing data, and supplementing the missing data to obtain complete material proportioning data;
S3: and constructing a material proportioning calculation model, and calculating an optimal material proportioning requirement value according to the complete material proportioning data.
2. The industrial chain-based material proportioning method as claimed in claim 1, wherein: the step of acquiring the material proportioning data of the industrial chain manufacturing order and the order manufacturing comprises the following steps:
the method comprises the steps of inputting a source data table, extracting industrial chain manufacturing order field data in the source data table by using a reading data function, extracting order field data by using a data screening function, and grouping and marking the order field data according to a material composition structure, wherein the order data comprises industrial chain orders, order materials and order quantity, the material data comprises material demand time, latest delivery time and material process drawings, and the industrial chain orders comprise wool demand, real-time stock quantity, re-acquisition quantity, non-wool demand ex-warehouse quantity and manufactured quantity.
3. The industry chain based material proportioning method of claim 2, wherein verifying the integrity of the material proportioning data comprises:
Dividing the marked order field data into association relations of materials of all levels according to the composition structure, reading the material structure of all levels, verifying the codes and the model comparison of the input materials and the output materials of the materials of all levels, verifying the logic principle and the numerical legitimacy, and judging the integrity of the material proportioning data according to the logic principle and the numerical legitimacy; if the logic principle and the numerical legitimacy are met, the material proportioning data is complete, the method enters S3, if the logic principle and the numerical legitimacy are not met, the material proportioning data is incomplete, the material proportioning data is traversed through a recursion traversal method to obtain missing data, and the missing data is supplemented.
4. A method of proportioning materials based on an industrial chain as claimed in claim 3, wherein said verifying logic principles and numerical legitimacy comprises:
The logic principle is followed that the level of the composition structure is greater than 1, the output materials of the final level are equal to the manufacturing materials of the original requirement, and the output materials of the upper level are input materials of the lower level between the adjacent levels;
The numerical validity follows that the quantity of the upper-level output materials among adjacent layers is equal to the quantity of the lower-level input materials, and the quantity of the input materials in the same layer is not necessarily equal to the quantity of the layer output materials; the input material of the level is more than or equal to 1, and the quantity of the output material of the final level is more than or equal to 0; the input-output ratio between adjacent layers is larger than 0, and the input-output ratio between the top layer and the final layer is larger than 0.
5. The method for proportioning materials based on industrial chain as recited in claim 4, wherein traversing the material proportioning data by recursive traversal to obtain missing data and supplementing the missing data to obtain complete material proportioning data comprises:
judging the type of the missing data, and reading whether the missing data is one of a hierarchy, an input-output type and a quantity missing;
traversing the material proportioning data by adopting a recursion traversing method, firstly acquiring the highest-level root node, judging whether the highest-level root node has a left sub-tree, traversing the left sub-tree of the next level if the highest-level root node has the left sub-tree, traversing the right sub-tree of the next level if the highest-level root node does not have the left sub-tree, returning the parent node of the level if the right sub-tree does not have the parent node, and ending the traversing;
Supplementing the traversed nodes with data information of the missing level, input-output objects or other material proportions with the quantity matching degree of more than 80%;
if no related missing data is found after traversing, the verification of the material proportion is not passed, and the material proportion is returned to be manually configured;
If the data with the matching degree reaching more than 80% is traversed, the missing data is inserted according to the traversing result, and the material proportioning data is issued by manual confirmation.
6. The method of claim 1, wherein calculating the optimal material proportioning requirement value comprises:
Splitting the marked order field data into association relations of all layers of materials according to the composition structure, and reading the structure of all layers of materials, wherein the total of the layers is n layers;
Respectively calculating the wool demand, the net demand, the planned output, the planned input, the planned stock, the start time and the completion time for the ith layer structure level, wherein i < = n;
judging whether the low-level code is equal to the current level i, if so, outputting a calculation result and calculating the next material;
If not, judging whether the material has child nodes, if not, outputting a calculation result and calculating the next material;
If so, judging whether i is equal to n, if so, outputting a calculation result and calculating the next material, and if not, returning to recalculate the wool demand, the net demand, the planned output, the planned input, the estimated stock quantity, the start-up time and the completion time after i=i+1.
7. The industrial chain-based material proportioning method of claim 6, wherein the calculating the gross demand and the net demand comprises:
The calculation of the wool demand is specifically as follows:
；
Wherein t is the operation time period, is the hair demand in the t time period, di (t) is the quantity of materials scheduled to be delivered by the ith layer of the materials in the t time period, qi is the quantity of materials of the i-1 layer required by the ith layer, and n is the structure layer;
multiplexing the calculation modes to obtain an optimal solution of the net demand of each level;
The formula of the net demand calculation is:
；
wherein Proportion is input-output ratio in a material proportioning model, vt is real-time dynamic quantity of the extracted material, and G (t) represents input quantity of lower material Di required for outputting upper material;
when G (t) is less than or equal to 0, the existing resources which indicate the net demand of the material can be met;
when G (t) > 0, this indicates that the net demand for the material is not sufficient resources to be filled.
8. The method of claim 7, wherein calculating the planned output, the planned input, and the estimated inventory comprises:
The order amount is EOQ, and the planned output amount is P (t);
G (t) > EOQ, the planned output P (t) =g (t), G (t) < EOQ, the planned output P (t) = EOQ;
R(t)=P(t)*(1-p)；
Wherein R (t) is the planned input quantity, and p is the rejection rate, and the rejection rate is a manual input parameter;
the estimated stock quantity is H (t), and the estimated stock quantity in the last period is H (t-1);
if Demandrough (t) > H (t-1) -safestock, H (t) =p (t) -G (t);
otherwise Demandrough (t) < = H (t-1) -safestock, H (t) = H (t-1) -Demandrough (t).
9. The method of claim 8, wherein calculating the start time and the finish time comprises:
Start time (ES):
ES(i,j)=ET(i)；
Wherein ET (i) refers to the earliest start time defined by the initial process of the BOM product, and ES (i, j) refers to the start time of the operation time period;
finishing time (EF):
EF(i,j)=ET(i)+T(i,j) = ES (i) +T (i,j)；
where T (i, j) refers to the working time, EF (i, j) refers to the finishing time within the working time, and ES (i) refers to the earliest start time.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410294532.4A CN117893139A (en) | 2024-03-15 | 2024-03-15 | Material proportioning method based on industrial chain |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410294532.4A CN117893139A (en) | 2024-03-15 | 2024-03-15 | Material proportioning method based on industrial chain |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117893139A true CN117893139A (en) | 2024-04-16 |
Family
ID=90645923
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202410294532.4A Pending CN117893139A (en) | 2024-03-15 | 2024-03-15 | Material proportioning method based on industrial chain |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117893139A (en) |
Citations (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101853190A (en) * | 2010-06-04 | 2010-10-06 | 华中科技大学 | Data integrity verification method suitable for embedded processor |
| CN104794596A (en) * | 2014-01-16 | 2015-07-22 | 天津星微软件开发有限公司 | Manufacturing enterprise MRP statistical method |
| CN107170027A (en) * | 2017-05-18 | 2017-09-15 | 中邮电子商务有限公司 | A kind of image synthesis and joining method and system based on theme post office APP |
| WO2019052045A1 (en) * | 2017-09-13 | 2019-03-21 | 南京航空航天大学 | Complex product disassembly and regeneration-oriented integrated decision-making method for disassembly schemes and regeneration schemes |
| CN109840732A (en) * | 2017-11-29 | 2019-06-04 | 上海汽车集团股份有限公司 | Vehicle can configure the check system of bill of materials integrality under the conditions of freely matching |
| CN109933486A (en) * | 2017-12-19 | 2019-06-25 | 车伯乐（北京）信息科技有限公司 | A kind of monitor processing method of logistics data, apparatus and system |
| US10540725B1 (en) * | 2014-08-18 | 2020-01-21 | Intuit Inc. | Methods systems and articles of manufacture for handling non-standard screen changes in preparing an electronic tax return |
| CN111861013A (en) * | 2020-07-23 | 2020-10-30 | 长沙理工大学 | Power load prediction method and device |
| CN112862312A (en) * | 2021-02-07 | 2021-05-28 | 山东大学 | Manufacturing service resource dynamic scheduling method and system based on random online algorithm |
| US20210374563A1 (en) * | 2020-05-29 | 2021-12-02 | Joni Jezewski | Solution Automation |
| CN115116616A (en) * | 2022-08-02 | 2022-09-27 | 哈尔滨理工大学 | Intra-group optimization based multiple interpolation breast cancer deletion data interpolation model |
| KR20220156734A (en) * | 2021-05-19 | 2022-11-28 | 산동 유니버시티 | Neutral bom building method and system of process and based on bill of materials |
| CN115660563A (en) * | 2022-11-08 | 2023-01-31 | 四川启睿克科技有限公司 | Material list link management method |
| CN115758477A (en) * | 2022-11-18 | 2023-03-07 | 海南大学 | Novel data integrity verification method |
| CN117371910A (en) * | 2023-10-09 | 2024-01-09 | 浪潮通用软件有限公司 | Material warehouse-out method and device based on ERP |
| CN117424208A (en) * | 2023-09-27 | 2024-01-19 | 国网浙江省电力有限公司台州供电公司 | Probability photovoltaic power generation prediction method for comprehensive missing data |
-
2024
- 2024-03-15 CN CN202410294532.4A patent/CN117893139A/en active Pending
Patent Citations (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101853190A (en) * | 2010-06-04 | 2010-10-06 | 华中科技大学 | Data integrity verification method suitable for embedded processor |
| CN104794596A (en) * | 2014-01-16 | 2015-07-22 | 天津星微软件开发有限公司 | Manufacturing enterprise MRP statistical method |
| US10540725B1 (en) * | 2014-08-18 | 2020-01-21 | Intuit Inc. | Methods systems and articles of manufacture for handling non-standard screen changes in preparing an electronic tax return |
| CN107170027A (en) * | 2017-05-18 | 2017-09-15 | 中邮电子商务有限公司 | A kind of image synthesis and joining method and system based on theme post office APP |
| WO2019052045A1 (en) * | 2017-09-13 | 2019-03-21 | 南京航空航天大学 | Complex product disassembly and regeneration-oriented integrated decision-making method for disassembly schemes and regeneration schemes |
| CN109840732A (en) * | 2017-11-29 | 2019-06-04 | 上海汽车集团股份有限公司 | Vehicle can configure the check system of bill of materials integrality under the conditions of freely matching |
| CN109933486A (en) * | 2017-12-19 | 2019-06-25 | 车伯乐（北京）信息科技有限公司 | A kind of monitor processing method of logistics data, apparatus and system |
| US20210374563A1 (en) * | 2020-05-29 | 2021-12-02 | Joni Jezewski | Solution Automation |
| CN111861013A (en) * | 2020-07-23 | 2020-10-30 | 长沙理工大学 | Power load prediction method and device |
| CN112862312A (en) * | 2021-02-07 | 2021-05-28 | 山东大学 | Manufacturing service resource dynamic scheduling method and system based on random online algorithm |
| KR20220156734A (en) * | 2021-05-19 | 2022-11-28 | 산동 유니버시티 | Neutral bom building method and system of process and based on bill of materials |
| CN115116616A (en) * | 2022-08-02 | 2022-09-27 | 哈尔滨理工大学 | Intra-group optimization based multiple interpolation breast cancer deletion data interpolation model |
| CN115660563A (en) * | 2022-11-08 | 2023-01-31 | 四川启睿克科技有限公司 | Material list link management method |
| CN115758477A (en) * | 2022-11-18 | 2023-03-07 | 海南大学 | Novel data integrity verification method |
| CN117424208A (en) * | 2023-09-27 | 2024-01-19 | 国网浙江省电力有限公司台州供电公司 | Probability photovoltaic power generation prediction method for comprehensive missing data |
| CN117371910A (en) * | 2023-10-09 | 2024-01-09 | 浪潮通用软件有限公司 | Material warehouse-out method and device based on ERP |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6701201B2 (en) | Decomposition system and method for solving a large-scale semiconductor production planning problem | |
| US7966214B2 (en) | Method for considering hierarchical preemptive demand priorities in a supply chain optimization model | |
| US20100125486A1 (en) | System and method for determining supply chain performance standards | |
| EP1862956A1 (en) | Systems and methods for assignment generation in a value flow environment | |
| Bassok et al. | Ordering and production decisions with supply quality and demand uncertainty | |
| US20080071650A1 (en) | Systems and methods for process-driven bill of material | |
| CN108647914A (en) | Production scheduling method, apparatus, computer equipment and storage medium | |
| CN111667191B (en) | Dual-target robust resource allocation method and system under resource sharing and transfer view | |
| US9741015B2 (en) | Map based routing from bill of materials | |
| US20100153152A1 (en) | Method and system for recursion check and low-level code generation for directed graph | |
| Stamelos et al. | Estimating the development cost of custom software | |
| US20070117230A1 (en) | Computer readable storage medium for work-in-process schedules | |
| Dellaert et al. | Randomized multi-level lot-sizing heuristics for general product structures | |
| Ashayeri et al. | An application of a unified capacity planning system | |
| JP7050082B2 (en) | A system for managing the life cycle of a complex engineering facility and its implementation | |
| JP2006178864A (en) | Production planning method in production line having rework process and its production plan system | |
| Custódio et al. | Variant product configuration of industrial air handling units in a MTO environment | |
| US8050785B2 (en) | Apparatus and method for handling orders | |
| Chang et al. | Manufacturing bill-of-material planning | |
| Lee et al. | Continuous cycles of data-enabled design: reimagining the IoT development process | |
| CN117893139A (en) | Material proportioning method based on industrial chain | |
| Zhao et al. | Supply chain contracts in the small data regime | |
| US20050177479A1 (en) | System and method for calculating low-level codes for items in a bill of material | |
| Siksnys et al. | SolveDB+: Sql-based prescriptive analytics | |
| Ramyar et al. | A new bi-objective mathematical model to optimize reliability and cost of aggregate production planning system in a paper and wood company |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |