Prediction production scheduling method, prediction production scheduling device, storage medium and equipment

Abstract

The invention discloses a production scheduling prediction method, a production scheduling prediction device, a storage medium and equipment, and relates to the technical field of pipe piles. The method comprises the steps that the predicted delivery amount of the pipe piles with the pile length of the current specification is determined based on the delivery amount of the pile length of the specification of historical pipe piles; and determining an optimal production strategy based on the predicted delivery quantity of the pipe piles with the pile length of the current specification and a pile length combination strategy. According to the invention, the predicted delivery amount of the pipe pile with the pile length of the current specification is determined through the delivery amount of the pile length of the specification of the historical pipe pile, so that the optimal production strategy is determined based on the pile length combination strategy, the production is closer to the trend of the sales market, the finished product inventory of the enterprise is reduced, the cash flow of the enterprise is increased, and the cash flow pressure of the enterprise is reduced.

Description

Technical Field

[0001] The present invention relates to the technical field of pipe piles, and in particular to a prediction and scheduling method, a prediction and scheduling device, a storage medium and equipment. Background Art

[0002] The order contract of the pipe pile industry is different from the contract order of the traditional industry. The contract framework agreement is signed, with the model, total length, and supply cycle. Although the model, total length and cycle are available, due to various reasons, the pile length and total length of the pile required at the construction site every day cannot be known in advance. The supplier needs to deliver according to the national standard of 7-15 meters or 16 meters, and the length requirement of each pile is confirmed according to the on-site construction. Due to various reasons. The production of pipe piles requires multiple processes and the construction period needs to be 3-5 days. In other words, the company needs to produce 3-5 days in advance. The sales know the model when placing the production work order, but cannot accurately estimate the length. In addition, when the company supplies multiple customers at the same time, there is a production demand for the same model but different pile lengths. The common production molds can be 24 meters, 25 meters, 26 meters, etc. During workshop production, each mold is a combination of 1-3 piles, which makes the production efficiency higher, but because some combinations are temporarily unavailable, the company's product inventory and inventory cycle are increased. If the production is scheduled in a scientific and minimal cost manner, the production schedule will become more complicated. Summary of the invention

[0003] In view of the shortcomings of the prior art, the purpose of the present invention is to provide a forecasting and scheduling method, a forecasting and scheduling device, a storage medium and equipment, so that production can be closer to the trend of the sales market, reduce the company's finished product inventory, increase the company's cash flow, and reduce the company's cash flow pressure.

[0004] According to a first aspect of the present invention, a forecasting and scheduling method is provided, comprising:

[0005] Based on the historical shipment volumes of pipe piles of different lengths and specifications, the forecast shipment volumes of pipe piles of current length and specifications are determined;

[0006] The optimal production strategy is determined based on the predicted shipment volume of pipe piles of the current specification and pile length combination strategy.

[0007] The forecasting and production scheduling method of the present invention confirms the predicted shipment volume of pipe piles of the current specification and length through the shipment volume of the historical specifications and lengths of pipe piles, so as to confirm the optimal production strategy based on the pile length combination strategy, so as to make the production closer to the trend of the sales market, reduce the enterprise's finished product inventory, increase the enterprise's cash flow, and reduce the enterprise's cash flow pressure.

[0008] In some embodiments, the determining the predicted delivery volume of pipe piles of current specifications of pile length based on the production volume of historical specifications of pipe piles includes:

[0009] Obtaining the shipment volume of the historical pipe piles of the specifications of the pile length, and calculating the maximum value, minimum value and median value of the shipment volume of the historical pipe piles of the specifications of the pile length;

[0010] Calculate the compensation coefficient of the shipment quantity of the pile length of the historical pipe pile specifications;

[0011] Obtain the inventory quantity of the pile length of the current stock pipe pile specification and the inventory quantity of the pile length of the pre-configured safety stock pipe pile specification;

[0012] Based on the maximum, minimum and median values ​​of the historical shipment quantities of the pile lengths of the specifications of the pipe piles, the compensation coefficient, the inventory quantity of the pile lengths of the specifications of the current inventory pipe piles and the inventory quantity of the pile lengths of the specifications of the pre-configured safety stock pipe piles, the predicted shipment quantity of the pipe piles of the current specification pile length is confirmed.

[0013] In some embodiments, the maximum value fmax(anLj), the minimum value fmin(anLj) and the median value fmid(anLj) of the shipment volume of the pile length based on the specifications of the historical pipe piles, the compensation coefficient HQ an , and the inventory quantity DQ of the pile length of the current inventory pile specifications anLj and pre-configured safety stock piles in the specifications of pile lengths AQ anLj , confirm the forecast shipment quantity Y of the pipe piles of the current specification and pile length anLj , Y anLj The calculation formula is:

[0014] Y anLj =AQ anLj -DQ anLj +(fmax(anLj)+4fmid(anLj)+fmin(anLj)) / 6*HQ an ;

[0015] Wherein, anLj represents the number of pile lengths j of the specification an of the historical pipe piles.

[0016] In some embodiments, the compensation coefficient HQ an The calculation formula is:

[0017] When the specification an of the historical pipe pile is a conventional pile type,

[0018]

[0019] Among them, SJF anT-i Indicates the actual shipment volume of the historical piles of specification an on day Ti, YCF anT-i Indicates the forecasted shipment volume of the historical pile specification an on day Ti; or

[0020] When the specification an of the historical pipe pile is an unconventional pile type,

[0021]

[0022] Among them, SJF anT-i Indicates the actual shipment volume of the historical piles of specification an on day Ti, YCF anT-i It represents the predicted delivery volume of the historical pipe pile specification an on day Ti.

[0023] In some embodiments, the method further comprises:

[0024] Get the actual delivery status of the historical pipe pile specification an in the past m days, and the effective delivery ratio YB an The calculation formula is:

[0025]

[0026] When YB an ≥60%, the specification of the historical pipe pile is a conventional pile type;

[0027] When YB an <60%, the specification an of the historical pipe pile is an unconventional pile type.

[0028] In some embodiments, the predicted shipment volume of pipe piles of the current specification and the pile length combination strategy are used to determine the optimal production strategy, including:

[0029] Based on the predicted delivery volume of the pipe piles, the length of the pipe pile molds and the pile length combination methods, the pile length combination method set after duplication is confirmed:

[0030] Based on the invalid combination removal strategy, invalid pile length combination modes in the pile length combination mode set are removed to obtain a valid pile length combination mode set;

[0031] Deduplication is performed based on the set of effective pile length combinations to obtain a set of non-repetitive solutions, and validity verification is performed on the non-repetitive solution set to obtain a set of effective solutions;

[0032] Based on the effective solution set, solution modulus calculations are performed respectively, and an optimization is performed to obtain the optimal production strategy.

[0033] In some embodiments, the predicted shipment volume Y based on the pipe piles anLj , Length of pipe pile mold V an The pile length combination mode set COMan after confirming the removal of duplicates with the pile length combination mode Wk is:

[0034]

[0035] The invalid pile length combination modes in the pile length combination mode set COMan are removed based on the invalid combination removal strategy to obtain the valid pile length combination mode set SCRCOMan:

[0036]

[0037] The non-repetitive solution set FA is obtained by removing duplicates based on the effective pile length combination method set SCRCOMan an , and for the non-repetitive solution set FA an Validation is performed to obtain the effective solution set YXFA an , where the set of non-repeating solutions FA an and the effective solution set YXFA an They are:

[0038]

[0039] YXFA an :{fa1 YXFA ,fa2 YXFA ,fa3 YXFA , …fat YXFA};

[0040] The effective solution set YXFA an Calculate the scheme modulus respectively and search for the optimal production strategy including:

[0041] Pile length j in fat YXFA Wk inside SCRCOM The number of occurrences in the pile length combination is csj k , then the inequality of the modular equation for pile length j is:

[0042] csj1*Z w1 +csj2*Z w2 +……csj K *Z wK ≥Y anLj ;

[0043] Among them, Z Wk Indicates the modulus used in the pile length combination Wk;

[0044] Wk SCRCOM All the pile length j modulus equations and inequalities are combined into a system of equations fczfat YXFA for:

[0045]

[0046] Solve the equations and get the minimum solution set jjfat YXFA for:

[0047] jjfat YXFA :{Z w1 , Z w2 , Z w3 , ... Z wk};

[0048] jjfat YXFA The sum of the elements S t The formula is:

[0049] S t =∑jjfat YXFA ;

[0050] jjfat YXFA Medium SCRCOM Number of piles per mold B Wk SI t The formula is:

[0051] SI t =∑B Wk ;

[0052] The best solution is fapre an =fpre(YXFA an ).

[0053] According to a second aspect of the present invention, a forecasting and scheduling device is provided, and the forecasting and scheduling device is used to execute the above-mentioned forecasting and scheduling method, comprising:

[0054] A prediction module, the prediction module is used to confirm the predicted delivery volume of pipe piles of current specifications and pile lengths based on the delivery volume of historical specifications and pile lengths of pipe piles;

[0055] The optimal production strategy confirmation module is used to confirm the optimal production strategy based on the predicted delivery volume of pipe piles of the current specification and the pile length combination strategy.

[0056] According to a third aspect of the present invention, there is provided an electronic device, comprising:

[0057] at least one processor; and

[0058] a memory communicatively connected to the at least one processor; wherein,

[0059] The memory stores a computer program that can be executed by the at least one processor. The computer program is executed by the at least one processor so that the at least one processor can execute the above-mentioned forecasting and scheduling method.

[0060] According to a fourth aspect of the present invention, a computer-readable storage medium is provided, wherein the computer-readable storage medium stores computer instructions, and the computer instructions are used to implement the above-mentioned forecasting and scheduling method when executed by a processor.

[0061] Compared with the prior art, the forecasting and scheduling method, forecasting and scheduling device, storage medium and equipment of the present invention confirm the forecasted shipment volume of pipe piles of the current specification and length through the shipment volume of the historical specifications and length of pipe piles, so as to confirm the optimal production strategy based on the pile length combination strategy, so as to make the production closer to the trend of the sales market, reduce the company's finished product inventory, increase the company's cash flow, and reduce the company's cash flow pressure. BRIEF DESCRIPTION OF THE DRAWINGS

[0062] Figure 1 A flowchart of a forecasting and scheduling method according to an embodiment of the present invention;

[0063] Figure 2 A flowchart of forecasting shipment volume according to one embodiment of the present invention;

[0064] Figure 3 A flowchart of confirming the optimal production strategy according to one embodiment of the present invention;

[0065] Figure 4 It is a structural schematic diagram of a prediction and production scheduling device according to one embodiment of the present invention;

[0066] Figure 5 It is a schematic structural diagram of an electronic device according to an embodiment of the present invention. DETAILED DESCRIPTION

[0067] The present invention will be further described in detail below in conjunction with the accompanying drawings.

[0068] The present invention provides a method for predicting production scheduling, which is used to predict the production plan for the next day and update the plan every day to make the plan more accurate. Figure 1 As shown, the forecasting and scheduling method includes:

[0069] S100: based on the historical shipment quantities of pipe piles of different lengths and specifications, confirm the forecast shipment quantity of pipe piles of current length and specifications;

[0070] In this embodiment, when the manufacturer ships the pipe piles, the manufacturer will record the shipment quantity of the pile lengths of the pipe piles, so the shipment quantity of the current pipe pile lengths can be predicted based on the pattern of the shipment quantity of the pile lengths of the historical pipe piles, so as to schedule production according to the shipment quantity.

[0071] In an optional embodiment, if Figure 2As shown, step S100 confirms the predicted delivery volume of pipe piles of the current specification of pile length based on the delivery volume of the historical specification of pipe piles, including:

[0072] S110: Obtain the historical shipment volume of the pile length of the specifications of the pipe piles, and calculate the maximum value, minimum value and median value of the historical shipment volume of the pile length of the specifications of the pipe piles;

[0073] In this embodiment, the set Q of the known specifications of the pipe piles is: {a1, a2, a3, a4...an} Assume that the current day is T, T-1 is the day before T, T-2 is two days before T, and so on, there are Ti days. <i<6, When P T-i The length of j piles under the daily Q collection (5<j<17, ) of the shipment quantity X as follows:

[0074] P T-1 :{X a1Lj T-1,X a2Lj T-1,X a3Lj T-1,X a4Lj T-1, ...X anLj T-1};

[0075] P T-2 :{X a1Lj T-2,X a2Lj T--2,X a3Lj T-2,X a4Lj T-2, ...X anLj T-2};

[0076] P T-3 :{X a1Lj T-3,X a2Lj T-3,X a3Lj T-3,X a4Lj T-3, ...X anLj T-3};

[0077] P T-4 :{X a1Lj T-4,X a2Lj T-4,X a3Lj T-4,X a4Lj T-4, ...X anLj T-4};

[0078] P T-5 :{X a1Lj T--5,X a2Lj T-5,X a3Lj T-5,X a4Lj T-5, ...X anLjT-5};

[0079] The pile length of the pipe pile is in P T-1 , P T-2 , P T-3 , P T-4 , P T-5 The maximum value function fmax(anLj) in;

[0080] The pile length of the pipe pile is in P T-1 , P T-2 , P T-3 , P T-4 , P T-5 The minimum function fmin(anLj) in ;

[0081] The pile length of the pipe pile is in P T-1 , P T-2 , P T-3 , P T-4 , P T-5 The median function fmid(anLj);

[0082] Wherein, anLj represents the number of pile lengths j of the historical pipe pile specification an.

[0083] S120: Calculate the compensation coefficient of the shipment volume of the pile length of the historical pipe pile specifications;

[0084] In this embodiment, there are two cases for the compensation coefficient of the shipment quantity of the pile length of the historical pipe pile specifications. The first is that the historical pipe pile specification an is a conventional pile type, corresponding to the precise buffer coefficient (i.e., the compensation coefficient); the second is that the historical pipe pile specification an is an unconventional pile type, corresponding to the fuzzy buffer coefficient (i.e., the compensation coefficient).

[0085] In an optional implementation manner, whether the specification an of the historical pipe pile is a conventional pile type can be determined by using the conventional pile type determination function Nol of the specification an of the pipe pile. an =fNol(an) judgment, the judgment function fNol(an) rule is:

[0086] Get the specifications of historical piles n Based on the actual shipment situation in the past m days (for example, the past 30 days), the effective shipment ratio YB an The calculation formula is:

[0087]

[0088] When YB an ≥60%, the specifications of historical pipe piles are conventional pile types;

[0089] When YB an<60%, the specifications of historical pipe piles are unconventional pile types.

[0090] In an optional embodiment, when the historical pile specification an is a conventional pile type, the predicted historical difference HQ of the pile specification an can be used. an =fhis(an) to get the compensation coefficient HQ an , the rules of fhis(an) are:

[0091] Specifications of historical pipe piles an Actual delivery volume on Ti day SJF anT-i YCF with Ti-day forecast shipment volume anT-i , then the prediction difference CZ formula is:

[0092]

[0093] Then there is a precise buffer coefficient (ie compensation coefficient) HQ an The formula is:

[0094]

[0095] In an optional embodiment, when the historical pile specifications an are unconventional pile types, the average predicted historical difference HQ of the pile specifications an can be used. an =fhisagv(an) to get the compensation coefficient HQ an , the rules of fhisagv(an) are:

[0096] Specifications of historical pipe piles an Actual delivery volume on Ti day SJF anT-i YCF with Ti-day forecast shipment volume anT-i , then the prediction difference CZ formula is:

[0097]

[0098] The predicted difference SCZ of all models on day Ti is T-i for:

[0099]

[0100] Then there is a fuzzy buffer coefficient HQ an The formula is:

[0101]

[0102] S130: Obtaining the inventory quantity of the pile length of the current stock pipe pile specification and the inventory quantity of the pile length of the pre-configured safety stock pipe pile specification;

[0103] In this embodiment, the inventory of the pile length of the current stock pile specification can be obtained by statistics, and the inventory of the pile length of the pre-configured safety stock pile specification can be obtained from the configuration information. The current inventory of the pile length of the current stock pile specification an is DQ anLj , safety stock is AQ anLj .

[0104] S140: based on the maximum, minimum and median values ​​of historical shipment quantities of pipe piles of different specifications, the compensation coefficient, the inventory quantity of the current stock pipe piles of different specifications and the inventory quantity of the pre-configured safety stock pipe piles of different specifications, the predicted shipment quantity of pipe piles of different specifications is confirmed.

[0105] In this embodiment, step S110 obtains the maximum value fmax(anLj), minimum value fmin(anLj) and median value fmid(anLj) of the shipment volume of the pile length of the historical specifications of the pipe pile, and step S120 obtains the buffer coefficient HQ an Step S130 obtains the current inventory of pipe piles with the specification an and the pile length j. The current inventory is DQ anLj , safety stock is AQ anLj , then confirm the forecast shipment quantity Y of the current pile length anLj , Y anLj The calculation formula is:

[0106] Y anLj =AQ anLj- DQ anLj +(fmax(anLj)+4fmid(anLj)+fmin(anLj)) / 6*HQ an .

[0107] S200: Determine the optimal production strategy based on the predicted delivery volume of pipe piles of the current specification and pile length combination strategy.

[0108] In this embodiment, since the shipment volume of the current pile length specifications has been predicted, the optimal production strategy can be determined according to the pile length combination strategy to determine the production plan in a combination of minimum cost, minimum modulus and minimum waste rate.

[0109] In an optional embodiment, if Figure 3 As shown, step S200 determines the optimal production strategy based on the predicted delivery volume of pipe piles of the current specification and pile length combination strategy, including:

[0110] S210: confirming a set of pile length combination methods after deduplication based on the predicted delivery volume of the pipe piles, the length of the pipe pile molds, and the pile length combination methods;

[0111] In this embodiment, there are k combinations of pile lengths of pipe piles with specifications an. The pile length combination is Wk, and the variable is defined as: Z Wk is the modulus used for the pile length combination Wk, V an is the length of the mold of the pipe pile in meters, 0<V an <27,

[0112] The predicted demand and delivery volume Y of the specification an under the set Q of the specifications of the pipe pile anLj In V an The pile length combination mode Wk after deduplication COMa n as follows:

[0113]

[0114] S220: removing invalid pile length combination modes in the pile length combination mode set based on the invalid combination removal strategy to obtain a valid pile length combination mode set;

[0115] In this embodiment, the invalid combination removal strategy is an invalid combination function fscr(an), and the rule of the invalid combination function fscr(an) is:

[0116] Middle Y anLj The length of the pile >0 is less than Y anLj =0 for the pile length in meters, the combination is invalid;

[0117] There is a pile length that exceeds the range of pile length j 4<j<17, , the combination is an invalid combination;

[0118] The number of combined elements in exceeds the value range of I0 <I<4, , the combination is invalid.

[0119] Specifications of pipe piles an Remove invalid combinations of set elements fscr(an), and the function outputs the valid combination set SCRCOMa n for:

[0120]

[0121] S230: removing duplicates based on the effective pile length combination method set to obtain a non-repetitive solution set, and verifying the validity of the non-repetitive solution set to obtain a valid solution set;

[0122] In this embodiment, the effective combination set SCRCOM an There are m elements, the effective combination set SCRCOM an All elements in the solution are combined without duplication to form the solution faφ FA (0<φ≤2 m -1), solution set FA an for:

[0123]

[0124] About faφ FA Verify the validity:

[0125] Calculate faφ FA Medium SCRCOM All pile lengths j′ and Y anLj Coverage ratio of all pile lengths j″

[0126]

[0127] When FG is less than 100%, faφ FA Invalid, when FG is greater than or equal to 100% faφ FA Valid. Traverse FA an After collecting the elements, we can get a valid solution t , the effective solution set YXFA an for:

[0128] YXFA an :{fa1 YXFA ,fa2 YXFA ,fa3 YXFA , ... fat YXFA}.

[0129] S240: Calculate the scheme modulus based on the effective scheme set, and perform optimization to obtain the optimal production strategy.

[0130] In this embodiment, fat YXFA Perform scheme modulus calculation, pile length j in fat YXFA Wk inside SCRCOM The number of occurrences in the pile length combination is csj k , then the inequality of the modular equation for pile length j is:

[0131] csj1*Z w1 +csj2*Z w2 +……csj K *Z wK ≥Y anLj ;

[0132] Among them, Z Wk Indicates the modulus used in the pile length combination Wk;

[0133] Wk SCRCOM All the pile length j modulus equations and inequalities are combined into a system of equations fczfat YXFA for:

[0134]

[0135] Solve the equations and get the minimum solution set jjfat YXFA for:

[0136] jjfat YXFA :{Z w1 , Z w2 , Z w3 , ... Z wk};

[0137] jjfat YXFA The sum of the elements S t The formula is:

[0138] S t =∑jjfat YXFA ;

[0139] jjfat YXFA Medium SCRCOM Number of piles per mold B Wk SI t The formula is:

[0140] SI t =∑B Wk ;

[0141] The best solution is fapre an =fpre(YXFA an );

[0142] fpre(YXFA an ) The rules are:

[0143] About YXFA an All fat inside YXFA S t Comparing the size, if and only if S t When the minimum value is unique, S t The smallest fat YXFA Select the best solution fapre an ; When S t When the minimum value is not unique, compare SI t Value, any SI t Smallest fat YXFASelect the best solution fapre an .

[0144] In a possible scenario, assuming that 400AB-95 is a specification in the specification set Q, the current day is T, and when i=5, the shipment status in the past 5 days is as follows:

[0145]

[0146] The safety stock and current stock status of 400AB-95 are as follows:

[0147]

[0148] Demand forecast for day T:

[0149] When j=7, fmax(400AB-95-7)=16, fmin(400AB-95-7)=10, fmid(400AB-95-7)=10, DQ 400AB-95-7 =191, AQ 400AB-95-7 =190;

[0150] When j=8, fmax(400AB-95-8)=16, fmin(400AB-95-8)=10, fmid(400AB-95-8)=10, DQ 400AB-95-8 =201,AQ 400AB-95-8 =200;

[0151] When j=9, fmax(400AB-95-9)=106, fmin(400AB-95-9)=46, fmid(400AB-95-9)=10, DQ 400AB-95-9 =200, AQ 400AB-95-9 =200;

[0152] When j = 10, fmax(400AB-95-10) = 76, fmin(400AB-95-10) = 24, fmid(400AB-95-10) = 12, DQ 400AB-95-10 =201,AQ 400AB-95-10 =200;

[0153] When j = 12, fmax(400AB-95-12) = 66, fmin(400AB-95-12) = 0, fmid(400AB-95-12) = 60, DQ 400AB-95-12 =190, AQ 400AB-95-12 =200;

[0154] When j = 16, fmax(400AB-95-16) = 17, fmin(400AB-95-16) = 15, fmid(400AB-95-16) = 16, DQ 400AB-95-16 =210, AQ 400AB-95-16 =200;

[0155] Nol 400AB-95 The result is: It is a conventional pile type

[0156] HQ 400AB-95 =102%

[0157] Then we have:

[0158] Y 400AB-95-7 =190-191+(13+10*4+16) / 6*102%=10.73≈11;

[0159] Y 400AB-95-8 =200-201+(10+10*4+16) / 6*102%=10.22≈11;

[0160] Y 400AB-95-9 =200-200+(10+46*4+106) / 6*102%=50;

[0161] Y 400AB-95-10 =200-201+(12+24*4+76) / 6*102%=30.28≈31;

[0162] Y 400AB-95-12 =200-190+(0+60*4+66) / 6*102%=62.02≈63;

[0163] Y 400AB-95-16 =200-210+(15+16*4+17) / 6*102%=6.32≈7;

[0164] T-day mold transfer:

[0165] The forecast demand shipment quantity Y of specification an under specification set Q anLj In V an The pile length combinations within the table are as follows after removing duplicates:

[0166]

[0167] Then the collection COM 400AB-95 as follows:

[0168] COM 400AB-95: {7+7+12, 7+8+11, 7+9+10, 7+16+3, 8+8+10, 8+9+9, 8+12+6, 8+16+2, 9+12+5, 9+16+1, 10+16, 10+10+6, 10+12+4, 12+12+2, 12+14};

[0169] About COM 400AB -95 set elements remove the invalid combination fscr(400AB-95), the valid combinations of the function result output are as follows:

[0170]

[0171] Then the set SCRCOM 400AB-95 as follows:

[0172] SCRCOM 400AB-95 : {7+7+12, 7+8+11, 7+9+10, 8+8+10, 8+9+9, 8+12+6, 9+12+5, 10+16, 10+10+6}

[0173] Because SCRCOM 400AB-95 There are nine elements in total, so the number of solutions is 2 9 -1=511, here is the solution set FA 400AB-95 Some of the solutions are as follows:

[0174] fa1 FA : {7+8+11, 7+9+10, 8+9+9, 8+12+6, 9+12+5, 10+16, 10+10+6};

[0175] fa2 FA : {7+8+11, 7+9+10, 8+8+10, 8+9+9, 8+12+6, 9+12+5, 10+16, 10+10+6};

[0176] fa3 FA : {7+7+12, 7+8+11, 7+9+10, 8+8+10, 8+9+9, 8+12+6, 9+12+5, 10+16, 10+10+6};

[0177] fa4 FA : {7+7+12, 7+8+11};

[0178] …

[0179] The pile length coverage ratios of the listed solutions are as follows:

[0180]

[0181] Then fa4 FA :This is an invalid solution and needs to be removed

[0182] Traversing FA 400AB-95 After that, we get the effective solution set YXFA 400AB-95 , here is YXFA 400AB-95 Some of the solutions are as follows:

[0183] fa1 YXFA : {7+8+11, 7+9+10, 8+9+9, 8+12+6, 9+12+5, 10+16, 10+10+6};

[0184] fa2 YXFA : {7+8+11, 7+9+10, 8+8+10, 8+9+9, 8+12+6, 9+12+5, 10+16, 10+10+6};

[0185] fa3 YXFA : {7+8+11, 7+7+12, 7+9+10, 8+8+10, 8+9+9, 8+12+6, 9+12+5, 10+16, 10+10+6};

[0186] …

[0187] fa1 YXFA The set of equations is listed as follows:

[0188]

[0189] fa1 YXFA The minimum value of the solution to the inequality equation system is:

[0190]

[0191] Then jjfa1 YXFA The sum of the elements S1 = 0 + 12 + 0 + 11 + 52 + 7 + 6 = 88;

[0192] fa2 YXFA The set of equations is listed as follows:

[0193]

[0194] fa2 YXFA The minimum value of the solution to the inequality equation system is:

[0195]

[0196] Then jjfa2 YXFA The sum of the elements S2 = 0 + 24 + 0 + 0 + 37 + 26 + 7 + 0 = 94;

[0197] fa3YXFA The set of equations is listed as follows:

[0198]

[0199] fa3 YXFA The minimum value of the solution to the inequality equation system is:

[0200]

[0201] Then jjfa3 YXFA The sum of the elements S3 = 0 + 30 + 0 + 0 + 12 + 7 + 26 + 7 + 12 = 94;

[0202] Select the best solution from the listed solutions:

[0203]

[0204] The implementation mode of the present invention confirms the predicted shipment volume of pipe piles of the current specification and length through the shipment volume of the historical specification and length of pipe piles, so as to confirm the optimal production strategy based on the pile length combination strategy, so as to make the production closer to the trend of the sales market, reduce the finished product inventory of the enterprise, increase the cash flow of the enterprise, and reduce the cash flow pressure of the enterprise.

[0205] The embodiment of the present invention provides a prediction and scheduling device, such as Figure 4 As shown, the device can be used as a specific device to implement the forecasting and scheduling method provided in the embodiment of the present invention, such as Figure 4 As shown, the device may include:

[0206] A prediction module 100, which is used to confirm the predicted delivery volume of pipe piles of current specifications based on the delivery volume of pile lengths of historical specifications of pipe piles;

[0207] The optimal production strategy confirmation module 200 is used to confirm the optimal production strategy based on the predicted delivery volume of pipe piles of the current specification of pile length and the pile length combination strategy.

[0208] In an optional embodiment, if Figure 4 As shown, the prediction module 100 includes:

[0209] The historical shipment data module 110 is used to record the historical shipment data of pipe piles, such as the shipment data of the specifications and pile lengths of the historical pipe piles;

[0210] A real-time inventory calculator 120, which is used to calculate the inventory data of pipe piles in real time, such as the inventory data of the pile length of the specifications of the stocked pipe piles;

[0211] A safety inventory data module 130, the safety inventory data module 130 is used to pre-configure safety inventory data of pipe piles, such as pre-configuring inventory data of pile lengths of specifications of safety inventory pipe piles;

[0212] Conventional pipe pile calculator 140, which is used to judge conventional pipe piles, such as judging whether the specifications of the pipe piles are conventional pile types or unconventional pile types;

[0213] The compensation coefficient calculator 150 is used for calculating the compensation coefficient, such as calculating the compensation coefficient of the delivery quantity of the pile length of the historical pipe pile specifications;

[0214] The shipment volume prediction module 160 is used to predict the shipment volume of the current pipe piles, such as confirming the predicted shipment volume of the pipe piles of the current specification of the pile length.

[0215] In an optional embodiment, if Figure 4 As shown, the optimal production strategy confirmation module 200 includes:

[0216] The production plan combination module 210 is used to confirm the pile length combination mode set after deduplication based on the predicted delivery volume of the pipe pile, the length of the pipe pile mold and the pile length combination mode;

[0217] The invalid combination removing module 220 is used to remove invalid pile length combination modes in the pile length combination mode set based on the invalid combination removing strategy to obtain a valid pile length combination mode set;

[0218] The production solution set calculation module 230 is used to remove duplicates based on the effective pile length combination mode set to obtain a non-repeating solution set, and to verify the validity of the non-repeating solution set to obtain a valid solution set;

[0219] The module 240 for selecting the optimal production plan is used to perform plan modulus calculations based on a set of valid plans, and to search for the optimal production strategy.

[0220] It should be noted that the steps involved in the forecasting and scheduling device have been described in detail in the forecasting and scheduling method, so they will not be repeated here.

[0221] An embodiment of the present invention provides an electronic device, such as Figure 5 As shown, Figure 5 The electronic device shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present invention.

[0222] like Figure 5As shown, the electronic device is in the form of a general-purpose computing device. The components of the electronic device may include, but are not limited to: one or more processors 910, a memory 930, and a communication bus 940 connecting different system components (including the memory 930 and the processor 910).

[0223] The communication bus 940 represents one or more of several types of bus structures, including a memory bus or memory controller, a peripheral bus, a graphics acceleration port, a processor, or a local bus using any of a variety of bus structures. For example, these architectures include, but are not limited to, an Industry Standard Architecture (ISA) bus, a Micro Channel Architecture (MAC) bus, an enhanced ISA bus, a Video Electronics Standards Association (VESA) local bus, and a Peripheral Component Interconnection (PCI) bus.

[0224] Electronic devices typically include a variety of computer system readable media. These media can be any available media that can be accessed by the electronic device, including volatile and non-volatile media, removable and non-removable media.

[0225] The memory 930 may include computer system readable media in the form of volatile memory, such as random access memory (RAM) and / or cache memory. The electronic device may further include other removable / non-removable, volatile / non-volatile computer system storage media. Figure 5 Not shown in the figure, a disk drive for reading and writing a removable non-volatile disk (e.g., a "floppy disk"), and an optical disk drive for reading and writing a removable non-volatile optical disk (e.g., a compact disc read only memory (CD-ROM), a digital versatile disc read only memory (DVD-ROM), or other optical media) may be provided. In these cases, each drive may be connected to the communication bus 940 via one or more data medium interfaces. The memory 930 may include at least one program product having a set (e.g., at least one) of program modules configured to perform the functions of various embodiments of the present invention.

[0226] A program / utility having a set (at least one) of program modules may be stored in memory 930, such program modules including but not limited to an operating system, one or more application programs, other program modules, and program data, each of which or some combination may include an implementation of a network environment. The program modules generally perform the functions and / or methods of the embodiments described herein.

[0227] The electronic device may also communicate with one or more external devices, and may also communicate with one or more devices that enable a user to interact with the electronic device, or communicate with any device that enables the electronic device to communicate with one or more other computing devices (e.g., a network card, a modem, etc.). Such communication may be performed through the communication interface 920. In addition, the electronic device may also communicate with the network adapter ( Figure 5 The network adapter can communicate with one or more networks (such as a local area network (LAN), a wide area network (WAN), and / or a public network, such as the Internet) through the communication bus 940. It should be understood that although Figure 5 Not shown, other hardware and / or software modules may be used in conjunction with the electronic device, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, disk arrays (Redundant Arrays of Independent Drives; hereinafter referred to as: RAID) systems, tape drives, and data backup storage systems.

[0228] The processor 910 executes various functional applications and data processing by running the programs stored in the memory 930, such as implementing the forecasting and scheduling method provided in the embodiment of the present invention.

[0229] An embodiment of the present invention further provides a computer-readable storage medium, wherein the computer-readable storage medium stores computer instructions, and the computer instructions enable the computer to execute the forecasting and production scheduling method provided by the embodiment of the present invention.

[0230] The above-mentioned computer-readable storage medium can adopt any combination of one or more computer-readable media. The computer-readable medium can be a computer-readable signal medium or a computer-readable storage medium. The computer-readable storage medium can be, for example, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above, but is not limited to this. More specific examples (non-exhaustive list) of computer-readable storage media include: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM) or a flash memory, an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In this document, a computer-readable storage medium can be any tangible medium containing or storing a program, which can be used by an instruction execution system, a device or a device or used in combination with it.

[0231] Computer-readable signal media may include data signals propagated in baseband or as part of a carrier wave, which carry computer-readable program code. Such propagated data signals may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. Computer-readable signal media may also be any computer-readable medium other than a computer-readable storage medium, which may send, propagate, or transmit a program for use by or in conjunction with an instruction execution system, apparatus, or device.

[0232] The program code contained on the computer-readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wire, optical cable, radio frequency (RF), etc., or any suitable combination of the foregoing.

[0233] The above are only some embodiments of the present invention. For those skilled in the art, several modifications and improvements can be made without departing from the creative concept of the present invention, which all belong to the protection scope of the present invention.

Claims

1. A forecasting and scheduling method, characterized in that: include: Based on the historical shipment volumes of pipe piles of different lengths and specifications, the forecast shipment volumes of pipe piles of current length and specifications are determined; The optimal production strategy is determined based on the predicted shipment volume of pipe piles of the current specification and pile length combination strategy.

2. The forecasting and scheduling method according to claim 1, characterized in that: The method of determining the predicted delivery volume of pipe piles of current specifications based on the production volume of the specifications of the pipe piles of historical specifications of the pipe piles of current specifications of the pipe piles includes: Obtaining the shipment volume of the historical pipe piles of the specifications of the pile length, and calculating the maximum value, minimum value and median value of the shipment volume of the historical pipe piles of the specifications of the pile length; Calculate the compensation coefficient of the shipment quantity of the pile length of the historical pipe pile specifications; Obtain the inventory quantity of the pile length of the current stock pipe pile specification and the inventory quantity of the pile length of the pre-configured safety stock pipe pile specification; Based on the maximum, minimum and median values ​​of the historical shipment quantities of the pile lengths of the specifications of the pipe piles, the compensation coefficient, the inventory quantity of the pile lengths of the specifications of the current inventory pipe piles and the inventory quantity of the pile lengths of the specifications of the pre-configured safety stock pipe piles, the predicted shipment quantity of the pipe piles of the current specification pile length is confirmed.

3. The forecasting and scheduling method according to claim 2, characterized in that: The maximum value fmax(anLj), minimum value fmin(anLj) and median value fmid(anLj) of the shipment volume based on the pile length of the historical pipe pile specifications, the compensation coefficient HQ an , and the inventory quantity DQ of the pile length of the current inventory pipe pile specifications anLj and pre-configured safety stock piles in the specifications of pile lengths AQ anLj , confirm the forecast shipment quantity Y of the pipe piles of the current specification and pile length anLj , Y anLj The calculation formula is: Y anLj =AQ anLj -DQ anLj +(fmax(anLj)+4fmid(anLj)+fmin(anLj)) / 6*HQ an ; Wherein, anLj represents the number of pile lengths j of the specification an of the historical pipe piles.

4. The forecasting and scheduling method according to claim 3, characterized in that: The compensation factor HQ an The calculation formula is: When the specification an of the historical pipe pile is a conventional pile type, Among them, SJF anT-i Indicates the actual shipment volume of the historical piles of specification an on day Ti, YCF anT-i Indicates the forecasted shipment volume of the historical pile specification an on day Ti; or When the specification an of the historical pipe pile is an unconventional pile type, Among them, SJF anT-i Indicates the actual shipment volume of the historical piles of specification an on day Ti, YCF anT-i It represents the predicted delivery volume of the historical pipe pile specification an on day Ti.

5. The forecasting and scheduling method according to claim 4, characterized in that: The method further comprises: Get the actual delivery status of the historical pipe pile specification an in the past m days, and the effective delivery ratio YB an The calculation formula is: When YB an ≥60%, the specification of the historical pipe pile is a conventional pile type; When YB an <60%, the specification of the historical pipe pile is an unconventional pile type.

6. The production forecasting method according to any one of claims 1 to 5, characterized in that: The predicted shipment volume of pipe piles of the current specification and the pile length combination strategy are used to determine the optimal production strategy, including: Confirming a set of pile length combination modes after deduplication based on the predicted delivery volume of the pipe piles, the length of the pipe pile molds and the pile length combination modes; Based on the invalid combination removal strategy, invalid pile length combination modes in the pile length combination mode set are removed to obtain a valid pile length combination mode set; Deduplication is performed based on the set of effective pile length combinations to obtain a set of non-repetitive solutions, and validity verification is performed on the non-repetitive solution set to obtain a set of effective solutions; Based on the effective solution set, solution modulus calculations are performed respectively, and an optimization is performed to obtain the optimal production strategy.

7. The forecasting and scheduling method according to claim 6, characterized in that: The predicted shipment volume Y based on the pipe pile anLj , Length of pipe pile mold V an The pile length combination mode set COMan after confirming the removal of duplicates with the pile length combination mode Wk is: The invalid pile length combination modes in the pile length combination mode set COMan are removed based on the invalid combination removal strategy to obtain the valid pile length combination mode set SCRCOMan: The non-repetitive solution set FA is obtained by removing duplicates based on the effective pile length combination method set SCRCOMan an , and for the non-repetitive solution set FA an Verify the validity and obtain the effective solution set YXFA an , where the set of non-repeating solutions FA an and the effective solution set YXFA an They are: YXFA an :{fa1 YXFA ,fa2 YXFA ,fa3 YXFA ,……fat YXFA }; The effective solution set YXFA an Calculate the scheme modulus respectively and search for the optimal production strategy including: Pile length j in fat YXFA Wk inside SCRCOM The number of occurrences in the pile length combination is csj k , then the inequality of the modular equation for pile length j is: csj1*Z w1 +csj2*Z w2 +……csj K *With wK ≥Y anLj ; Among them, Z Wk Indicates the modulus used in the pile length combination Wk; Wk SCRCOM All the pile length j modulus equations and inequalities are combined into a system of equations fczfat YXFA for: Solve the equations and get the minimum solution set jjfat YXFA for: jjfat YXFA {WITH w1 ,WITH w2 ,WITH w3 ,……WITH wk }; jjfat YXFA The sum of the elements S t The formula is: S t =∑jjfat YXFA ; jjfat YXYA Medium SCRCOM Number of piles per mold B Wk SI t The formula is: AND t =∑B Wk ; The best solution is fapre an =fpre(YXFA an ).

8. A forecasting and scheduling device, characterized in that: include: A prediction module, the prediction module is used to confirm the predicted delivery volume of pipe piles of current specifications based on the delivery volume of pile lengths of historical specifications of pipe piles; The optimal production strategy confirmation module is used to confirm the optimal production strategy based on the predicted delivery volume of pipe piles of the current specification and the pile length combination strategy.

9. An electronic device, characterized in that: include: at least one processor; as well as a memory communicatively connected to the at least one processor; wherein, The memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the forecasting and scheduling method according to any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a processor to implement the forecasting and scheduling method according to any one of claims 1 to 7 when executed.

Images