Automobile stamping data processing method, gateway system, electronic device and storage medium

Abstract

The invention provides an automobile stamping data processing method and system, an electronic device and a storage medium. Automobile part number information is obtained through calculation; the number information of the automobile parts comprises the checking number in the last month, the daily warehousing number in the current month, the daily consumption number in the current month and the daily demand number in the current month; converting the number information of the automobile parts into part production scheduling demand information; the part production scheduling demand information comprises to-be-supplemented demands of parts; and according to a preset limiting condition, the part production scheduling demand information and the automobile part number information, generating daily demand data of the automobile parts. The same parts on different dates are orderly and intensively arranged according to the required dates of the later project, and the resource consumption is reduced by reducing the die changing times of a stamping workshop; the planned production scheduling quantity is carried out according to the multiple of the minimum economic batch, the produced parts can be consumed by later projects in a short time, and the occupied space, time and funds of a warehouse are reduced.

Description

Technical Field

[0001] The present invention relates to the technical field of commercial vehicles, and in particular to an automobile stamping data processing method, a gateway system, an electronic device and a storage medium. Background Art

[0002] In the current domestic commercial vehicle field, the existing technology has the following defects: 1. There are obvious off-seasons and peak seasons; 2. There are thousands of models, resulting in more than 100 types of commonly used stamping parts; 3. Stamping parts must be mass-produced because they require special molds and mold switching affects efficiency. 4. In the daily planning mode, when emphasizing the end-to-end delivery cycle, the method of cyclic scheduling according to the turnover days of stamping parts will generate a large amount of backlog inventory. The present invention is a technical solution obtained by trying to solve the above four problems. Summary of the invention

[0003] In view of this, the purpose of the embodiment of the present invention is to provide support for customers to quickly adjust the scheduling order and time of future stamping plans according to actual conditions every day, so as to improve the execution rate of the plan. In order to solve the technical problem that the production cycle is insufficient under the traditional daily planning mode, and the method of scheduling production according to the turnover days of stamping parts will generate a large amount of backlog inventory.

[0004] A first aspect of the present invention provides a method for processing automobile stamping data, the method comprising:

[0005] S101, calculate and obtain automobile parts quantity information; the automobile parts quantity information includes the inventory count of last month, the daily warehouse quantity of this month, the daily consumption quantity of this month, and the daily demand quantity of this month;

[0006] S102, converting the automobile parts quantity information into parts production scheduling demand information; the parts production scheduling demand information includes parts to be replenished;

[0007] S103, generating daily demand data for automobile parts according to preset restriction conditions, the parts production scheduling demand information, and the automobile parts quantity information.

[0008] Furthermore, in S1, the daily consumption quantity of this month includes the daily consumption quantity of stamping parts for welding and the daily consumption quantity of stamping parts for spare parts;

[0009] Among them, the body's on-line passing point information is read from the welding manufacturing execution system, and the welding body model that is on-line on that day is found according to the passing point data, and the parts list is selected from the welding BOM structure, and then the number of stamping parts consumed by the welding daily is generated according to the stamping basic parts list;

[0010] The parts list is screened from the welding BOM structure according to the spare parts outbound voucher of the welding workshop, and then the daily stamping parts consumption quantity of the spare parts is generated according to the stamping basic parts list.

[0011] Further, in S101, the calculation and acquisition of the daily demand quantity of this month includes:

[0012] Based on the historical production schedule, new vehicle daily plans are generated based on the available production dates according to the remaining capacity and the new vehicle customer orders;

[0013] Generate spare parts production plan based on the newly added spare parts after-sales orders submitted daily, as well as the spare parts production capacity of each workshop and the historical scheduled quantity;

[0014] According to the vehicle daily plan and spare parts production plan, the parts list is screened from the BOM structure, and then the daily required quantity of spare parts is generated based on the stamping basic parts list.

[0015] Further, the S102 includes:

[0016] Calculate the daily remaining quantity and the daily quantity to be replenished; among which, the quantity to be replenished on the first day = (round up (beginning quantity - first day demand quantity) / minimum economic batch) * minimum economic batch; the first day's remaining quantity = the first day's remaining quantity - the first day's demand quantity; the next day's remaining quantity = the previous day's (first day's) remaining quantity - the current day's demand quantity;

[0017] Generate the schedulable time interval A, merge the types and quantities of the demand to be replenished according to the attributes in the basic parts list, and generate the demand to be scheduled.

[0018] Furthermore, the preset restriction condition includes the number of available punching tools; S103 includes:

[0019] Step 1, A takes the date E in ascending order; if there is a date, take the next uncalculated date and execute step 2; if there is no date, end the loop and execute step 14;

[0020] Step 2, write the demand to be scheduled that is less than or equal to date E into the record C of date E; wherein, the demand that has been scheduled into C is eliminated to generate the unscheduled demand N; the line shift capacity and the shift corresponding to the date can obtain the line daily capacity, and refer to the capacity occupancy in the record C of date E to obtain the remaining daily capacity M; the rule library is converted into a daily rule capacity box according to the date and the daily rule capacity box is updated according to the record C of date to obtain the daily remaining capacity box S; the daily rule capacity box includes the maximum number of available stamping tools on that day;

[0021] Step 3, create a two-dimensional array R[M+1(rows), N+1(columns)] and initialize the value to 0;

[0022] Step 4, start looping from X=1 and add 1 each time; if X<=M+1, execute step 5; if X>M+1, execute step 13;

[0023] Step 5, start the loop sequence by adding 1 each time from Y=1; if Y<=N+1, execute step 6; if Y>N+1, execute step 4;

[0024] Step 6, determine whether the quantity a in the Yth element of N is greater than X; if N[Y].a>X, execute step 11; if N[Y].a<=X, execute step 7;

[0025] Step 7, read the value F1 of R[XN[Y].a,Y-1], and trace back the daily rule capacity frame to the occupied capacity T at R[XN[Y].a,Y-1];

[0026] Step 8, determine the size of T.a+N[Y].a and X; if T.a+N[Y].a>X, execute step 11; if T.a+N[Y].a<=X, execute step 9;

[0027] Step 9, calculate the score F1 of N[Y] according to the scoring criteria, and calculate the ability value S1 of N[Y] in T1 according to the daily ability frame;

[0028] Step 10, determine the size of T+T1 and S and determine the size of F1+F2 and R[X,Y-1] value F; wherein, if T+T1<=S and F1+F2>F, execute step 12; if T+T1>S or F1+F2<=F, execute step 11;

[0029] Step 11, update the value of R[X,Y-1] to R[X,Y] and execute step 5;

[0030] Step 12, update the value of F1+F2 to R[X,Y] and execute step 5;

[0031] Step 13, using a backtracking method to record the elements entered by N at date E and execute;

[0032] Step 14, sum up the elements in all N in all dates;

[0033] Step 15, fill in the eliminated needs according to the mold and several varieties in the stamping basic parts list.

[0034] Furthermore, the backtracking method comprises:

[0035] Loop forward the two-dimensional array R[M,N] from X=M,Y=N by decreasing Y by 1 each time. If R[X,Y] and R[X,Y-1] are not equal, the Yth element in N is considered to have been used. In this case, X is subtracted from N[Y] until X=1,Y=1.

[0036] In addition, the second aspect of the present invention provides an automobile stamping data processing system, the system comprising an acquisition module, a conversion module and a generation module, characterized in that:

[0037] An acquisition module is used to calculate and acquire the quantity information of automobile parts; the quantity information of automobile parts includes the inventory count of the previous month, the daily warehouse quantity of this month, the daily consumption quantity of this month, and the daily demand quantity of this month;

[0038] A conversion module, used for converting the automobile parts quantity information into parts production scheduling demand information; the parts production scheduling demand information includes parts to be replenished demand;

[0039] The generation module is used to generate daily demand data for automobile parts according to preset restriction conditions, the parts production scheduling demand information, and the automobile parts quantity information.

[0040] In addition, the third aspect of the present invention provides an electronic device, which includes: one or more processors, and a memory, wherein the memory is used to store one or more computer programs; characterized in that the computer program is configured to be executed by the one or more processors, and the program includes steps for executing the automobile stamping data processing method described in the first aspect.

[0041] In addition, a fourth aspect of the present invention is a storage medium storing a computer program; the program is loaded by a processor and executes the steps of the automobile stamping data processing method as described in the first aspect.

[0042] In the scheme of the present invention, the quantity information of automobile parts is calculated and obtained; the automobile parts quantity information includes the inventory quantity of the previous month, the daily warehouse quantity of this month, the daily consumption quantity of this month, and the daily demand quantity of this month; the automobile parts quantity information is converted into the parts production scheduling demand information; the parts production scheduling demand information includes the parts to be replenished demand; according to the preset restriction conditions, the parts production scheduling demand information, and the automobile parts quantity information, the automobile parts daily demand data is generated. Based on this, on the one hand, since there are many varieties of stamping parts daily demand screened according to the vehicle order and BOM structure, and the quantity is not fixed, the present invention can orderly schedule the same parts of different dates according to the demand date of the later project, and reduce the resource consumption by reducing the number of mold changes in the stamping workshop; on the other hand, the planned production quantity is based on the multiples of the minimum economic batch, and the produced parts can be consumed by the later project in a short time, reducing the space, time and funds occupied by the warehouse; on the third hand, through the system's collection of various data, the planner can intuitively grasp the real situation and quickly prepare the stamping plan. BRIEF DESCRIPTION OF THE DRAWINGS

[0043] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for use in the embodiments are briefly introduced below. It should be understood that the following drawings only show certain embodiments of the present invention and therefore should not be regarded as limiting the scope. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without creative work.

[0044] Figure 1 is a flow chart of a method for processing automobile stamping data disclosed in an embodiment of the present invention;

[0045] Figure 2 It is a diagram of the unfilled quantity to be supplemented disclosed in the embodiment of the present invention;

[0046] Figure 3 is a quantity diagram after filling the quantity to be supplemented disclosed in an embodiment of the present invention;

[0047] Figure 4 It is a schematic diagram of the overall system structure disclosed in the embodiment of the present invention;

[0048] Figure 5 It is a schematic diagram of the system calculation process disclosed in the embodiment of the present invention;

[0049] Figure 6 It is a display interface for the daily demand data of automobile parts generated by the subsequent plan disclosed in the embodiment of the present invention. DETAILED DESCRIPTION

[0050] Example embodiments will now be described more fully with reference to the accompanying drawings. However, example embodiments can be implemented in a variety of forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this application will be more comprehensive and complete and fully convey the concept of the example embodiments to those skilled in the art.

[0051] In addition, described feature, structure or characteristic can be combined in one or more embodiments in any suitable manner. In the following description, many specific details are provided to provide a full understanding of the embodiments of the present application. However, those skilled in the art will appreciate that the technical scheme of the present application can be put into practice without one or more of the specific details, or other methods, components, devices, steps, etc. can be adopted. In other cases, known methods, devices, realizations or operations are not shown or described in detail to avoid blurring the various aspects of the application.

[0052] The block diagrams shown in the accompanying drawings are merely functional entities and do not necessarily correspond to physically independent entities. That is, these functional entities may be implemented in software form, or in one or more hardware modules or integrated circuits, or in different networks and / or processor devices and / or microcontroller devices.

[0053] The flowcharts shown in the accompanying drawings are only exemplary and do not necessarily include all the contents and operations / steps, nor must they be executed in the order described. For example, some operations / steps can be decomposed, and some operations / steps can be combined or partially combined, so the actual execution order may change according to actual conditions.

[0054] It should be noted that the “plurality” mentioned in this article refers to two or more.

[0055] The implementation details of the technical solution of the embodiment of the present application are described in detail below:

[0056] The first aspect of the present invention provides a method for processing automobile stamping data, such as Figure 1 As shown, the method includes:

[0057] S1, calculate and obtain automobile parts quantity information; the automobile parts quantity information includes the inventory quantity of last month, the daily warehouse quantity of this month, the daily consumption quantity of this month, and the daily demand quantity of this month.

[0058] In this embodiment, the general automobile processing process is divided into stamping workshop and welding workshop operations. Therefore, regarding the calculation of the inventory count of the previous month, in this embodiment, for the stamping workshop: the electronic inventory list made by the stamping workshop after the physical inventory is manually counted at the end of the month is imported into the system as inventory (there are scenarios such as parts modification, parts scrapping, and parts replacement that are not included in the system management, so the number of parts needs to be counted every month).

[0059] In this embodiment, the inventory count of the welding workshop is divided into two categories. (1) Physical inventory is conducted at the end of the month, and an electronic inventory list is prepared as the inventory import system. (2) No physical inventory is conducted at the end of the month. The inventory is obtained by subtracting the number of parts on hand at the closing of the previous month and adding the number of parts received in the welding warehouse this month from the number of parts and quantity extracted from the stamping basic parts list in the welding order BOM structure according to the completed welding and assembly types and quantities of this month. If the value is less than 0, it is entered as 0.

[0060] Among them, the inventory of welding and stamping workshops is not on the last day of the month, and production may continue after the inventory. When importing the inventory list, you need to select the real inventory date.

[0061] The method for obtaining the daily inventory quantity for this month can be as follows: In the first stage, the workshop staff enters the daily inventory quantity; (the warehouse keeper's off-duty time is not synchronized with the workshop production off-duty time, and the time when the warehouse keeper enters the inventory quantity does not match the system calculation time, so it is designed to be modifiable on the same day, and the adjustment on the next day needs to be offset). In the second stage, the stamping workshop tools and stamping equipment are linked through handheld devices and RFID, and the logistics vehicle automatically enters the warehouse on the surface, and the custodian performs transfer and outbound operations; the daily inventory quantity is counted according to the flow.

[0062] Furthermore, in S1, the daily consumption quantity of this month includes the daily consumption quantity of stamping parts for welding and the daily consumption quantity of stamping parts for spare parts;

[0063] Among them, the body's on-line passing point information is read from the welding manufacturing execution system, and the welding body model that is on-line on that day is found according to the passing point data, and the parts list is selected from the welding BOM structure, and then the number of stamping parts consumed by the welding daily is generated according to the stamping basic parts list;

[0064] The parts list is screened from the welding BOM structure according to the spare parts outbound voucher of the welding workshop, and then the daily stamping parts consumption quantity of the spare parts is generated according to the stamping basic parts list.

[0065] Furthermore, in S1, the calculation and acquisition of the daily demand quantity for this month includes: generating a new vehicle daily plan based on the historical production scheduling and the remaining production capacity based on the schedulable date for the newly added vehicle customer orders; generating a spare parts production plan based on the newly added spare parts after-sales orders submitted daily and based on the spare parts production capacity of each workshop and the historical scheduled quantity; screening the parts list from the BOM structure according to the vehicle daily plan and the spare parts production plan, and then generating the daily demand quantity of spare parts based on the stamping basic parts list.

[0066] Specifically, in this embodiment, the vehicle daily plan: the marketing department submits new vehicle customer orders to the production department every day. The production department generates a new daily production plan for the new orders based on the schedulable date according to the remaining production capacity based on the historical production schedule. Spare parts plan: the marketing department submits new spare parts (produced / assembled in the welding workshop and sold directly without assembly in the general assembly workshop) after-sales orders to the production department every day. The production department generates a spare parts production plan based on the spare parts production capacity of each workshop and the historical scheduled quantity. The vehicle daily plan & spare parts plan selects the parts list from the BOM structure, and then generates the daily demand quantity of spare parts based on the stamping basic parts list.

[0067] S102, converting the automobile parts quantity information into parts production scheduling demand information; the parts production scheduling demand information includes parts to be replenished demand.

[0068] In this embodiment, there are multiple versions of parts in the research and development process due to various situations such as changes in drawings, but stamping parts are strongly related to molds, and mold changes are irreversible. The production of new stamping parts must be communicated and coordinated with the workshop & planner due to the limitations of molds, fixtures, and common equipment. In actual production, multiple versions of stamping parts will also be merged into the same part for batch production, so the stamping basic parts list can be improved through manual statistics and post-maintenance without omissions. The stamping basic parts list can effectively screen stamping parts through the order BOM and convert multi-version parts into basic part numbers to achieve the effect of part number merging. Among them, the order BOM is a list of parts including sources and production workshops required to produce products (car models, spare parts).

[0069] In this embodiment, the demand to be supplemented needs to be merged in type and quantity according to the attributes in the basic parts list of stamping to generate the demand to be arranged. (Example 1: 100 pieces of d and 80 pieces of e. In the basic parts list of stamping, d and e are formed once with the same mold to produce 1 piece of d and 1 piece of e respectively. Then, only 100 pieces of d remain after the parts are merged. Example 2: 100 pieces of f. In the basic parts list of stamping, one mold of f is formed once to produce 3 pieces of f. After the parts are merged, 34 pieces of f remain.)

[0070] Further, the S102 includes:

[0071] Calculate the daily remaining quantity and the daily gap quantity;

[0072] Sort the daily gaps by date from small to large, take the gap date, divide the gap quantity on this date by the minimum economic batch (minimum production quantity), round up, and then multiply by the minimum economic batch to get the demand to be replenished. This is the demand to be replenished on this day. When calculating the gap quantity on subsequent dates, add this day's demand to be replenished as the planned inventory quantity. After looping through all gap dates, get the quantity to be replenished for the whole month.

[0073] Generate the schedulable time interval A, merge the types and quantities of the demand to be replenished according to the attributes in the basic parts list, and generate the demand to be scheduled.

[0074] Furthermore, in this embodiment, the quantity of parts to be replenished can be calculated according to the following method:

[0075] Starting from the beginning date, add the parts to the daily production, subtract the daily consumption when it is less than the current date, subtract the daily demand when it is equal to the current date, subtract the daily demand when it is greater than or equal to the current date plus one working day, and subtract the safety stock on the last demand date to calculate the daily remaining quantity.

[0076] The data on which the daily remaining quantity is less than 0 and the data on which the daily required quantity is greater than 0 on the current date is the daily gap; (If there is a material with a daily remaining quantity less than 0 and no required quantity, it is assumed by default that no replenishment is required, because in this case, the inventory entry on that day has not been entered when the plan is prepared. 1 The real shortage will theoretically be entered on that day, and 2 False gaps exclude noise). The daily gap quantity is calculated.

[0077] Sort the daily gaps by date from small to large, take the gap date, divide the gap quantity on this date by the minimum economic batch (minimum production quantity), round up, and then multiply by the minimum economic batch to get the demand to be replenished. When calculating the gap quantity of subsequent dates, add the demand to be replenished on this day as the planned inventory quantity, and cycle through all gap dates to get the total month's supply. Among them, the minimum economic batch = round up ((production volume of the third month before / production times of the third month before + production volume of the second month before / production times of the second month before + production volume of the first month before / production times of the first month before) / 3).

[0078] like Figure 2-3 As shown, Figure 2 It is a map of the quantity that has not been filled and needs to be supplemented; Figure 3 A quantity chart to fill in the quantity to be replenished.

[0079] like Figure 2 The figure shows the unfilled quantity to be replenished. Assuming that the current date is September 1, according to the above, on September 2, the remaining quantity of material code 5123111-G17101 (front crossbeam-floor) is -10, the remaining quantity of material code 51106048-G17101 (right fender) is -1; the remaining quantity of material code 57V67-01012 (top cover) is -80. Therefore, based on Figure 2 The materials are replenished. Among them, the quantity to be replenished of material code 5123111-G17101 (front beam-floor) and material code 57V67-01012 (top cover) is greater than the normal threshold, indicating

[0080] like Figure 3 The figure shows the quantity after the quantity to be replenished is filled. Similarly, the current date is September 1st. It can be found that among the requirements to be replenished, 100 pieces of material code 5123111-G17101 (front beam-floor) were filled in on September 2nd, and 100 pieces of material code 57V67-01012 were filled in on September 2nd and September 4th respectively.

[0081] S103, generating daily demand data for automobile parts according to preset restriction conditions, the parts production scheduling demand information, and the automobile parts quantity information.

[0082] See also Figure 4This is a schematic diagram of the overall system structure implemented in this example. According to the data of the inventory count last month, the daily warehouse quantity this month, the daily consumption quantity this month, and the daily demand quantity this month obtained in step S101, the demand to be replenished is calculated (which can be implemented according to the implementation method of the above step S102). Then the demand to be replenished is input into the system operation, and the stamping plan is generated.

[0083] In step S103, the preset restriction condition includes the number of available punching tools;

[0084] In this embodiment, generally before step S103, a data cleaning step is required. On the one hand, by generating a schedulable time interval A (excluding factory rest dates and clarifying schedulable dates). On the other hand, the demand to be supplemented is generated by merging varieties and quantities according to the attributes in the basic parts list for stamping to generate the demand to be scheduled. (Example 1: 100 pieces of d and 80 pieces of e. In the basic parts list for stamping, d and e use the same mold to produce 1 piece of d and 1 piece of e at a time. When the parts are merged, only 100 pieces of d remain. Example 2: 100 pieces of f. In the basic parts list for stamping, one mold f produces 3 pieces at a time. After the parts are merged, 34 pieces of f remain.)

[0085] Further, the S103 includes executing system calculations, such as Figure 5 As shown, the system calculation specifically includes:

[0086] Step 1, A takes the date E in ascending order; if there is a date, take the next uncalculated date and execute step 2; if there is no date, end the loop and execute step 14;

[0087] Step 2, write the demand to be scheduled that is less than or equal to date E into the record C of date E; wherein, the demand that has been scheduled into C is eliminated to generate the unscheduled demand N; the line shift capacity and the shift corresponding to the date can obtain the line daily capacity, and refer to the capacity occupancy in the record C of date E to obtain the remaining daily capacity M; the rule library is converted into a daily rule capacity box according to the date and the daily rule capacity box is updated according to the record C of date to obtain the daily remaining capacity box S; the daily rule capacity box includes the maximum number of available stamping tools on the day;

[0088] Step 3, create a two-dimensional array R[M+1(rows), N+1(columns)] and initialize the value to 0;

[0089] Step 4, start looping from X=1 and add 1 each time; if X<=M+1, execute step 5; if X>M+1, execute step 13;

[0090] Step 5, start the loop sequence by adding 1 each time from Y=1; if Y<=N+1, execute step 6; if Y>N+1, execute step 4;

[0091] Step 6, determine whether the quantity a in the Yth element of N is greater than X; if N[Y].a>X, execute step 11; if N[Y].a<=X, execute step 7;

[0092] Step 7, read the value F1 of R[XN[Y].a,Y-1], and trace back the daily rule capacity frame to the occupied capacity T at R[XN[Y].a,Y-1];

[0093] Step 8, determine the size of T.a+N[Y].a and X; if T.a+N[Y].a>X, execute step 11; if T.a+N[Y].a<=X, execute step 9;

[0094] Step 9: Calculate the score F1 of N[Y] according to the scoring criteria, and calculate the ability value S1 of N[Y] in T1 according to the daily ability frame

[0095] Step 10, determine the size of T+T1 and S and determine the size of F1+F2 and R[X,Y-1] value F; where, if T+T1<=S and F1+F2>F, execute step 12; if T+T1>S or F1+F2<=F, execute step 11.

[0096] Step 11, update the value of R[X,Y-1] to R[X,Y] and execute step 5;

[0097] Step 12, update the value of F1+F2 to R[X,Y] and execute step 5;

[0098] Step 13, use a backtracking method to record the elements entered by N at date E and execute.

[0099] Step 14, summarize the elements in all N for all dates.

[0100] Step 15, fill in the eliminated needs according to the mold and several varieties in the stamping basic parts list.

[0101] Furthermore, the backtracking method comprises:

[0102] Loop forward the two-dimensional array R[M,N] from X=M,Y=N by decreasing Y by 1 each time. If R[X,Y] and R[X,Y-1] are not equal, the Yth element in N is considered to have been used. In this case, X is subtracted from N[Y] until X=1,Y=1.

[0103] like Figure 6 The following is a display interface of the daily demand data of auto parts generated by the subsequent plan based on the above S103 system calculation scheme in this embodiment. In the figure, according to the calculation of S103 above, the daily demand data of auto parts generated by the subsequent plan in September is calculated as shown in the table.

[0104] In addition, a second aspect of this embodiment provides an automobile stamping data processing system, the system comprising an acquisition module, a conversion module and a generation module; wherein:

[0105] An acquisition module is used to calculate and acquire the quantity information of automobile parts; the quantity information of automobile parts includes the inventory count of last month, the daily warehouse quantity of this month, the daily consumption quantity of this month, and the daily demand quantity of this month;

[0106] A conversion module, used for converting the automobile parts quantity information into parts production scheduling demand information; the parts production scheduling demand information includes parts to be replenished demand;

[0107] The generation module is used to generate daily demand data for automobile parts according to preset restriction conditions, the parts production scheduling demand information, and the automobile parts quantity information.

[0108] In addition, the specific implementation steps of each module can refer to the first aspect of this embodiment. It includes calculating and obtaining automobile parts quantity information; the automobile parts quantity information includes the inventory quantity of the previous month, the daily warehouse quantity of this month, the daily consumption quantity of this month, and the daily demand quantity of this month; converting the automobile parts quantity information into parts production scheduling demand information; the parts production scheduling demand information includes the demand for parts to be replenished; and generating automobile parts daily demand data according to preset constraints, the parts production scheduling demand information, and the automobile parts quantity information.

[0109] In addition, the third aspect of this embodiment provides an electronic device, which includes: one or more processors, and a memory, wherein the memory is used to store one or more computer programs; characterized in that the computer program is configured to be executed by the one or more processors, and the program includes steps for executing the automobile stamping data processing method described in the first aspect.

[0110] In addition, a fourth aspect of this embodiment is a storage medium storing a computer program; the program is loaded by a processor and executes the steps of the automobile stamping data processing method as described in the first aspect.

[0111] Those of ordinary skill in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, computer software, or a combination of the two. In order to clearly illustrate the interchangeability of hardware and software, the composition and steps of each example have been generally described in terms of function in the above description. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of the present invention.

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

[0113] The units described as separate components may or may not be physically separated. As a unit, it can be appreciated by those skilled in the art that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, computer software, or a combination of the two. In order to clearly illustrate the interchangeability of hardware and software, the composition and steps of each example have been generally described in terms of function in the above description. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of the present invention.

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

[0115] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention is essentially or the part that contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including a number of instructions for a computer device (which can be a personal computer, a server, or a grid device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), disk or optical disk and other media that can store program codes.

[0116] The specific implementation methods described above further illustrate the objectives, technical solutions and beneficial effects of the present invention in detail. It should be understood that the above description is only a specific implementation method of the present invention and is not intended to limit the scope of protection of the present invention. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention should be included in the scope of protection of the present invention.

Claims

1. A method for processing automobile stamping data, characterized in that: The method comprises: S101, obtaining automobile parts quantity information; the automobile parts quantity information includes the inventory count of last month, the daily warehouse quantity of this month, the daily consumption quantity of this month, and the daily demand quantity of this month; S102, converting the automobile parts quantity information into parts production scheduling demand information; the parts production scheduling demand information includes parts to be replenished; S103, generating daily demand data for automobile parts according to preset restriction conditions, the parts production scheduling demand information, and the automobile parts quantity information.

2. The automobile stamping data processing method according to claim 1, characterized in that: In S101, the daily consumption quantity of this month includes the daily consumption quantity of stamping parts for welding and the daily consumption quantity of stamping parts for spare parts; Among them, the body's on-line passing point information is read from the welding manufacturing execution system, the welding body model that is on-line on that day is found according to the passing point data, and the parts list is screened from the welding BOM structure, and then the number of stamping parts consumed by the welding daily is generated according to the stamping basic parts list; The parts list is screened from the welding BOM structure according to the spare parts outbound voucher of the welding workshop, and then the daily stamping parts consumption quantity of the spare parts is generated according to the stamping basic parts list.

3. The automobile stamping data processing method according to claim 2, characterized in that: In S101, the acquisition of the daily demand quantity of this month includes: Based on the historical production schedule, new vehicle daily plans are generated based on the available production dates according to the remaining capacity and the new vehicle customer orders; Generate spare parts production plan based on the newly added spare parts after-sales orders submitted daily, as well as the spare parts production capacity of each workshop and the historical scheduled quantity; According to the vehicle daily plan and spare parts production plan, the parts list is screened from the BOM structure, and then the daily required quantity of spare parts is generated based on the stamping basic parts list.

4. The automobile stamping data processing method according to claim 3, characterized in that: The S102 includes: Calculate the daily remaining quantity and the daily quantity to be replenished; among which, the quantity to be replenished on the first day = (round up (beginning quantity - first day demand quantity) / minimum economic batch) * minimum economic batch; the first day's remaining quantity = the first day's remaining quantity - the first day's demand quantity; the next day's remaining quantity = the previous day's (first day's) remaining quantity - the current day's demand quantity; Generate the schedulable time interval A, merge the types and quantities of the demand to be supplemented according to the attributes in the stamping basic parts list, and generate the demand to be scheduled.

5. The automobile stamping data processing method according to claim 4, characterized in that: The preset restriction condition includes the number of available punching tools; S103 includes: Step 1, A takes the date E in ascending order; if there is a date, take the next uncalculated date and execute step 2; if there is no date, end the loop and execute step 14; Step 2, write the demand to be scheduled that is less than or equal to date E into the record C of date E; wherein, the demand that has been scheduled into C is eliminated to generate the unscheduled demand N; the line daily capacity can be obtained from the line shift capacity and the shift corresponding to the date, and the capacity occupancy in date E is updated with reference to the record C to obtain the remaining daily capacity M; the rule library is converted into a daily rule capacity box according to the date and the daily rule capacity box is updated according to the record C to obtain the daily remaining capacity box S; the daily rule capacity box includes the maximum number of available stamping tools on the day; Step 3, create a two-dimensional array R[M+1(rows), N+1(columns)] and initialize the value to 0; Step 4, start looping from X=1 and add 1 each time; if X<=M+1, execute step 5; if X>M+1, execute step 13; Step 5, start the loop sequence by adding 1 each time from Y=1; if Y<=N+1, execute step 6; if Y>N+1, execute step 4; Step 6, determine the size of the number a and X in the Yth element in N; where N[Y].a>X, execute step 11; N[Y].a<=X, execute step 7; Step 7, read the value F1 of R[XN[Y].a,Y-1], and trace back the daily rule capacity frame to the occupied capacity T at R[XN[Y].a,Y-1]; Step 8, determine the size of T.a+N[Y].a and X; if T.a+N[Y].a>X, execute step 11; if T.a+N[Y].a<=X, execute step 9; Step 9, calculate the score F1 of N[Y] according to the scoring criteria, and calculate the ability value S1 of N[Y] in T1 according to the daily ability frame; Step 10, determine the size of T+T1 and S and determine the size of F1+F2 and R[X,Y-1] value F; wherein, if T+T1<=S and F1+F2>F, execute step 12; if T+T1>S or F1+F2<=F, execute step 11; Step 11, update the value of R[X,Y-1] to R[X,Y] and execute step 5; Step 12, update the value of F1+F2 to R[X,Y] and execute step 5; Step 13, using a backtracking method to record the elements entered by N at date E and execute; Step 14, sum up the elements in all N in all dates; Step 15, fill in the eliminated waiting requirements according to the one mold and several varieties in the stamping basic parts list.

6. The automobile stamping data processing method according to claim 5, characterized in that: The backtracking method comprises: In the two-dimensional array R[M,N], start from X=M,Y=N and loop forward by subtracting 1 from Y each time. If R[X,Y] and R[X,Y-1] are not equal, it is considered that the Yth element in N has been used. In this case, X is subtracted from N[Y] until X=1,Y=1.

7. An automobile stamping data processing system, characterized in that: The system comprises an acquisition module, a conversion module and a generation module, and is characterized in that: An acquisition module is used to acquire the quantity information of automobile parts; the quantity information of automobile parts includes the inventory count of last month, the daily warehouse quantity of this month, the daily consumption quantity of this month, and the daily demand quantity of this month; A conversion module, used for converting the automobile parts quantity information into parts production scheduling demand information; the parts production scheduling demand information includes parts to be replenished demand; The generation module is used to generate daily demand data for automobile parts according to preset restriction conditions, the parts production scheduling demand information, and the automobile parts quantity information.

8. An electronic device, comprising: One or more processors, a memory, wherein the memory is used to store one or more computer programs; characterized in that the computer program is configured to be executed by the one or more processors, and the program includes steps for executing the automobile stamping data processing method as described in any one of claims 1-6.

9. A storage medium storing a computer program; the program is loaded and executed by a processor to implement the steps of the automobile stamping data processing method according to any one of claims 1 to 6.

Images