Time consumption calculation method for each stage of whole automobile part order fulfillment process

Abstract

The invention relates to the field of automobile enterprise part production and manufacturing, in particular to a time consumption calculation method for each stage of an automobile part order fulfillment whole process, which comprises the following steps of: respectively acquiring corresponding historical data from each stage of the automobile part order fulfillment whole process, and establishing data sets of different stages; and the time consumption conditions of the corresponding stages are calculated according to the data sets of the different stages, so that enterprise management personnel can rectify the later production and sales plans of the various automobile parts according to the time consumption conditions of the manufacturing stages of the various automobile parts.

Description

Technical Field

[0001] The present invention relates to the field of automobile parts production and manufacturing, and in particular to a method for calculating the time consumption at each stage of the entire process of fulfilling an automobile parts order. Background Art

[0002] In auto parts manufacturing companies, the entire process of auto parts order fulfillment is mainly divided into four stages: production preparation stage (preparation period), product manufacturing stage (manufacturing period), product warehousing stage (warehouse period) and product delivery stage (in transit period). The data of each stage is stored in different systems and departments. At present, auto parts manufacturing companies only rely on statistics on the overall time consumption of the entire process of order fulfillment of a certain part to calculate the on-time delivery index (OTD index) of the part, and use this on-time delivery index of the entire process to guide the formulation of the sales plan of the part, and assist enterprise managers to adjust the production process (or plan) of the part according to the sales plan of the part. However, this method has the following problems:

[0003] ① The various business systems that store the data of the entire process of fulfilling auto parts orders often have inconsistent data storage formats and time standards due to differences in business needs of the departments to which they belong. For example, the actual production completion time record of the production department and the delivery time record of the logistics department are inconsistent in format and time standards. This leads to data omissions, duplications, and errors when auto parts manufacturers calculate the overall time consumption of the entire process of fulfilling orders for such parts. The on-time delivery of the entire process calculated using such erroneous data will cause corporate managers to formulate sales plans that are not in line with the company's actual production situation, resulting in the company delivering products to customers based on the order. The actual impact results in the delivery quantity being less than the quantity required by the order, reducing customer satisfaction;

[0004] ② At present, the on-time delivery indicators used by auto parts manufacturers can only reflect the overall situation of the delivery of a certain part to the customer. In fact, auto parts manufacturers are often affected by various external factors throughout the order fulfillment process. Once an external emergency occurs (supply chain disruptions caused by natural disasters, changes in trade policies, etc., such as chip shortages, etc.), the traditional on-time delivery indicators for the entire process can only reflect the percentage of products that the company cannot deliver to the customer's designated location according to the time agreed with the customer in advance. It cannot help the company accurately identify which stage these problems are caused by. Even if the company wants to make corrections, it has no idea where to start;

[0005] ③Only counting the time spent in the entire process of fulfilling the order of auto parts will make auto parts manufacturers only focus on the final delivery time of such parts, while ignoring the connection time of each stage in the entire process of order fulfillment. As a result, once the early stage consumes too much time, in order to ensure that the products can be delivered on time according to the order quantity, the company can only choose high-cost expedited transportation methods to ensure the final delivery time of such products, which greatly increases the final cost. If it is found in advance that there is too much time consumption in the early stages, the company's managers can adjust the time consumption of the subsequent stages in advance, and optimize and improve the efficiency of the seriously time-consuming stages in a targeted manner, so as to avoid the embarrassing situation that the company can only guarantee on-time delivery by increasing costs.

[0006] Therefore, how to automatically obtain accurate information about the time consumption of each stage of the entire process of fulfilling auto parts orders and clearly feed it back to company managers in order to formulate a sales plan that suits the company's actual production situation has always been a problem that technical personnel in this field need to solve urgently. Summary of the invention

[0007] The purpose of the present invention is to provide a method for calculating the time consumption of each stage in the whole process of automobile parts order fulfillment in view of the corresponding deficiencies in the prior art, obtain corresponding historical data from each stage of the whole process of automobile parts order fulfillment, establish data sets for different stages, and calculate the time consumption of the corresponding stages according to the data sets for different stages, so that enterprise managers can rectify the later production and sales plans of various automobile parts according to the time consumption of the manufacturing stages of various automobile parts.

[0008] The object of the present invention is to adopt the following scheme to achieve: a method for calculating the time consumption at each stage of the whole process of fulfilling an automobile parts order, comprising the following steps:

[0009] 1) Obtain the corresponding historical data from each stage of the entire process of fulfilling Class A auto parts orders, and form preparation data sets, manufacturing data sets, inventory data sets, and delivery data sets;

[0010] 2) Calculate the production preparation time of Class A auto parts based on the data in the preparation data set, so that enterprise managers can make corrections to the later production and sales plans of Class A auto parts based on the time spent in the production preparation stage of Class A auto parts;

[0011] 3) Calculate the manufacturing time of Class A auto parts based on the data in the manufacturing data set, so that enterprise managers can make corrections to the later production and sales plans of Class A auto parts based on the time consumption of the manufacturing stage of Class A auto parts;

[0012] 4) Calculate the time spent on the warehouse of Class A auto parts based on the data in the inventory data set, so that enterprise managers can make corrections to the later production and sales plans of Class A auto parts based on the time spent on the warehouse entry of Class A auto parts;

[0013] 5) Calculate the in-transit time of Class A auto parts based on the data in the delivery data set, so that enterprise managers can make adjustments to the later production and sales plans of Class A auto parts based on the time consumed in the delivery stage of Class A auto parts.

[0014] Preferably, the specific method of acquiring corresponding historical data from each stage of the entire process of fulfilling the order of Class A auto parts and forming the preparation data set, the manufacturing data set, the inventory data set, and the delivery data set is as follows:

[0015] 1-1) Obtain preparation period data from several business systems corresponding to the production preparation stage to form a preparation data set;

[0016] 1-2) Obtain manufacturing data from several business systems corresponding to the product manufacturing stage to form a manufacturing data set;

[0017] 1-3) Obtain the inventory data from several business systems corresponding to the product warehousing stage to form an inventory data set;

[0018] 1-4) Obtain in-transit data from several business systems corresponding to the product delivery stage to form a delivery data set.

[0019] Preferably, in step 2), the specific method of calculating the production preparation period time consumption of Class A automobile parts according to the data in the preparation data set is as follows:

[0020] 2-1) Calculate the work order schedule time for Class A auto parts according to the following formula:

[0021] p=∑(mn) / o

[0022] In the formula, p is the single schedule planning time of Class A auto parts, m is the import time of each work order plan, n is the production release time of each work order schedule plan, and o is the number of work orders in a certain month;

[0023] 2-2) Calculate the distribution time and sorting time of Class A auto parts respectively;

[0024] 2-3) Calculate the time it takes to deliver Class A auto parts to the line:

[0025] t=(∑(ed)) / q

[0026] In the formula, t is the time taken to deliver Class A auto parts to the line side, e is the line side material receiving time or delivery completion time, d is the sorting completion time, and q is the number of work orders at the line side material receiving time;

[0027] 2-4) Based on the distribution time and sorting time calculated in step 2-2), calculate the production preparation time of Class A auto parts.

[0028] Preferably, in step 2-2), if sorting is performed after distribution is completed, the distribution time and sorting time of Class A auto parts are calculated as follows:

[0029] ① Calculate the time required to stock Class A auto parts in a three-dimensional warehouse according to the following formula:

[0030] x=∑(ba) / o

[0031] In the formula, x is the time taken to distribute goods in the three-dimensional warehouse of Class A auto parts, b is the time to complete the distribution of goods in the three-dimensional warehouse, a is the time to start distribution, and o is the number of work orders in a certain month;

[0032] ② Calculate the sorting time of Class A auto parts according to the following formula:

[0033] y=∑(dc) / o

[0034] In the formula, y is the sorting time of Class A auto parts, d is the sorting completion time, c is the sorting release time, and o is the number of work orders in a certain month;

[0035] Preferably, in step 2-2), if the goods are distributed and sorted at the same time, the distribution time and sorting time of Class A auto parts are calculated according to the following formula:

[0036] z=∑(da) / o

[0037] In the formula, z is the time consumed for stocking and sorting of Class A auto parts in the three-dimensional warehouse, d is the sorting completion time, a is the start time of stocking, and o is the number of work orders in a certain month.

[0038] Preferably, in step 2-4), the specific method of calculating the production preparation period time consumption of Class A automobile parts is as follows:

[0039] 2-4-1) If sorting is performed after the distribution is completed, the production preparation period of Class A auto parts can be calculated according to the following formula:

[0040] f=p+x+y+t

[0041] In the formula, f is the production preparation time of Class A auto parts, p is the work order schedule planning time of Class A auto parts, x is the three-dimensional warehouse stocking time of Class A auto parts after stocking is completed and then sorted, y is the sorting time of Class A auto parts after stocking is completed, and t is the delivery time of Class A auto parts to the line side;

[0042] 2-4-2) If the goods are sorted while being distributed, the production preparation time of Class A auto parts can be calculated according to the following formula:

[0043] f=p+z+t

[0044] Among them, f is the time consumed in the production preparation period of Class A automobile parts, p is the time consumed in the work order schedule planning of Class A automobile parts, z is the time consumed in the three-dimensional warehouse for stocking and sorting Class A automobile parts while stocking and sorting, and t is the time consumed in the delivery of Class A automobile parts to the line.

[0045] Preferably, the manufacturing time of the Class A automotive parts is calculated using the following formula:

[0046] g=(∑(je)) / k

[0047] In the formula, g is the manufacturing time of Class A auto parts, e is the completion time of work order delivery, j is the completion time of assembly line, and k is the number of assemblies;

[0048] Preferably, in step 4), the specific method of calculating the inventory time consumption of Class A automobile parts according to the data in the inventory data set is as follows:

[0049] 4-1) Calculate the storage time of Class A auto parts according to the following formula:

[0050] h=(∑(lr)) / k

[0051] In the formula, h is the storage time of Class A auto parts, l is the time of PDA scanning for outbound or outbound storage, r is the time of inbound storage, and k is the total number of units;

[0052] 4-2) Calculate the time required for loading and shipping of Class A auto parts according to the following formula:

[0053] s=(∑(ul)) / k

[0054] In the formula, s is the time taken to load and ship Class A auto parts, u is the time to ship out of the finished product warehouse, l is the time to scan the outbound PDA, and k is the total number of units;

[0055] 4-3) Based on the storage time of Class A auto parts and the loading and shipping time of Class A auto parts, the inventory time of Class A auto parts is calculated according to the following formula:

[0056] w=h+s

[0057] Where w is the inventory time of Class A auto parts, h is the storage time of Class A auto parts, and s is the loading and shipping time of Class A auto parts.

[0058] Preferably, the transit time of Class A auto parts is calculated according to the following formula:

[0059] i=(∑(vu)) / k

[0060] In the formula, i is the in-transit time of Class A auto parts, v is the time from the in-transit warehouse, u is the time from the finished product warehouse, and k is the total number of units.

[0061] Preferably, the preparation period data include the number of work orders in a certain month, the planned import time of each work order, the schedule plan production release time of each work order, the completion time of the three-dimensional warehouse distribution, the start time of distribution, the sorting release time, the sorting completion time, the line side material receiving time or the delivery completion time, and the number of work orders at the line side material receiving time; the manufacturing period data include the work order delivery completion time, the assembly completion time, and the number of assemblies; the in-warehouse period data include the time of entering the temporary storage warehouse, the time of leaving the temporary storage warehouse or the PDA scanning time for leaving the warehouse, the number of assemblies, the time of leaving the finished product warehouse, and the PDA scanning time for leaving the warehouse; the in-transit period data include the time of leaving the in-transit warehouse, the time of leaving the finished product warehouse, and the number of assemblies.

[0062] The beneficial effects of the present invention are as follows:

[0063] ① The present invention will not cause inconsistency in the format and time standard of stored data due to the fact that the data of the entire process of fulfilling the auto parts order is stored in different business systems. By calculating the time consumption of each stage separately, the enterprise administrator can clearly know the time consumption of each stage, and then formulate a sales plan that suits the actual production situation of the enterprise, so that the enterprise can deliver the products to the customer according to the order, and the delivery quantity is equal to the quantity required by the order, which greatly improves customer satisfaction;

[0064] ② The present invention can reflect the time consumption of each stage of auto parts manufacturing enterprises in delivering parts to customers. When encountering external emergencies (supply chain disruptions caused by natural disasters, changes in trade policies, etc., such as chip shortages, etc.), the present invention can not only reflect the percentage of products that meet quality requirements that the enterprise cannot deliver to the customer's designated location within the time agreed with the customer in advance, but also help enterprise managers accurately identify which stage these problems are caused by, so as to make rectifications;

[0065] ③ The present invention counts the time consumption of the four major stages of automobile parts manufacturing enterprises, namely, the production preparation stage (preparation period), the product manufacturing stage (manufacturing period), the product warehousing stage (in-warehouse period) and the product delivery stage (in-transit period). Enterprises can pay attention to the connection time of each stage in the whole process of order fulfillment. Once too much time is consumed in the early stage, enterprise managers can adjust the time consumption of subsequent stages in advance, and optimize and improve the efficiency of the seriously time-consuming stages in a targeted manner, so as to avoid the embarrassing situation that enterprises can only guarantee on-time delivery by increasing costs.

[0066] Glossary

[0067] OTD indicator: On-time delivery usually refers to the ability of an enterprise to deliver products or services that meet quality and quantity requirements to the customer's designated location at the time agreed with the customer in advance. The OTD (On-Time Delivery) indicator is the on-time delivery rate, which is a key performance indicator to measure whether the product or service can be delivered to the customer at the scheduled time in the business process such as supply chain management or service provision of the enterprise. It reflects the ability and reliability of the enterprise in meeting customer delivery time expectations.

[0068] Production Scheduling: refers to the scheduling and resource allocation of production tasks under the constraints of enterprise resources (such as manpower, equipment, raw materials, etc.), determining the execution order and time of each order, product or production task in the production system, so as to achieve efficient and orderly production process.

[0069] Order fulfillment: It is the entire business process from receiving a customer order to successfully delivering the product or service to the customer.

[0070] Preparation period: The key preparatory stage before formal production, mainly including the technical preparation stage (process design and optimization, mold and fixture preparation), raw material preparation stage (supplier selection and procurement plan, raw material inspection and storage), equipment and manpower preparation stage (production equipment commissioning and maintenance, personnel recruitment and training).

[0071] Manufacturing phase: refers to the stage from when raw materials are put into production to when finished parts are completed. During this period, it involves the implementation of various processing techniques, workers operating equipment or automated production lines, and strict quality control, inspection and correction of parts to ensure compliance with standards.

[0072] In-stock period: refers to the period from when parts are put into storage after production to when they are shipped out, including the time when finished products are stored waiting for sales, or temporarily stored in the warehouse due to order delays, etc.

[0073] In transit: Has not yet reached the destination, is in transit or waiting for transportation and is stored in the means of transport. BRIEF DESCRIPTION OF THE DRAWINGS

[0074] Figure 1 It is a flow chart of the present invention;

[0075] Figure 2 A schematic diagram of a method for calculating an on-time delivery indicator according to an embodiment of the present invention;

[0076] Figure 3 A schematic diagram of calculating the production preparation time of Class A automobile parts according to an embodiment of the present invention;

[0077] Figure 4 A schematic diagram of calculating the manufacturing time consumption of Class A automobile parts according to an embodiment of the present invention;

[0078] Figure 5 A schematic diagram of calculating the inventory time consumption of Class A automobile parts according to an embodiment of the present invention;

[0079] Figure 6 This is a schematic diagram of calculating the in-transit time of Class A automobile parts according to an embodiment of the present invention. DETAILED DESCRIPTION

[0080] like Figures 1 to 6 As shown, a method for calculating the time consumption at each stage of the entire process of fulfilling an automobile parts order comprises the following steps:

[0081] 1) Obtain the corresponding historical data from each stage of the entire process of fulfilling Class A auto parts orders, and form preparation data sets, manufacturing data sets, inventory data sets, and delivery data sets:

[0082] 1-1) Obtain preparation period data from several business systems corresponding to the production preparation stage to form a preparation data set;

[0083] 1-2) Obtain manufacturing data from several business systems corresponding to the product manufacturing stage to form a manufacturing data set;

[0084] 1-3) Obtain the inventory data from several business systems corresponding to the product warehousing stage to form an inventory data set;

[0085] 1-4) Obtain in-transit data from several business systems corresponding to the product delivery stage to form a delivery data set.

[0086] The automobile parts orders referred to in the present invention are usually only for the production and sales of a single type of parts. For example, a Class A automobile parts order (a certain assembly, a certain month, a certain model) refers to an order for automobile parts of model A used to assemble XX assembly in XX month.

[0087] 2) Calculate the time consumption of the production preparation period of Class A auto parts based on the data in the preparation data set, so that enterprise managers can make corrections to the later production and sales plans of Class A auto parts based on the time consumption of the production preparation stage of Class A auto parts:

[0088] 2-1) Calculate the work order schedule time for Class A auto parts according to the following formula:

[0089] p=∑(mn) / o

[0090] In the formula, p is the single schedule planning time of Class A auto parts, m is the import time of each work order plan, n is the production release time of each work order schedule plan, and o is the number of work orders in a certain month;

[0091] 2-2) Calculate the distribution time and sorting time of Class A auto parts respectively:

[0092] 2-2-1) If sorting is performed after distribution, the distribution time and sorting time of Class A auto parts will be calculated as follows:

[0093] ① Calculate the time required to stock Class A auto parts in a three-dimensional warehouse according to the following formula:

[0094] x=∑(ba) / o

[0095] In the formula, x is the time taken to distribute goods in the three-dimensional warehouse of Class A auto parts, b is the time to complete the distribution of goods in the three-dimensional warehouse, a is the time to start distribution, and o is the number of work orders in a certain month;

[0096] ② Calculate the sorting time of Class A auto parts according to the following formula:

[0097] y=∑(dc) / o

[0098] In the formula, y is the sorting time of Class A auto parts, d is the sorting completion time, c is the sorting release time, and o is the number of work orders in a certain month;

[0099] 2-2-2) If the goods are sorted while being distributed (for example, sorting starts after a certain period of time from the beginning of distribution), the distribution time and sorting time of Class A auto parts are calculated according to the following formula:

[0100] z=∑(da) / o

[0101] In the formula, z is the time consumed for stocking and sorting of Class A auto parts in the three-dimensional warehouse, d is the sorting completion time, a is the start time of stocking, and o is the number of work orders in a certain month.

[0102] 2-3) Calculate the time it takes to deliver Class A auto parts to the line:

[0103] t=(∑(ed)) / q

[0104] In the formula, t is the time taken to deliver Class A auto parts to the line side, e is the line side material receiving time or delivery completion time, d is the sorting completion time, and q is the number of work orders at the line side material receiving time;

[0105] 2-4) Based on the distribution time and sorting time calculated in step 2-2), calculate the production preparation time of Class A auto parts:

[0106] 2-4-1) If sorting is performed after the distribution is completed, the production preparation period of Class A auto parts can be calculated according to the following formula:

[0107] f=p+x+y+t

[0108] In the formula, f is the production preparation time of Class A auto parts, p is the work order schedule planning time of Class A auto parts, x is the three-dimensional warehouse stocking time of Class A auto parts after stocking is completed and then sorted, y is the sorting time of Class A auto parts after stocking is completed, and t is the delivery time of Class A auto parts to the line side;

[0109] 2-4-2) If the goods are sorted while being distributed, the production preparation time of Class A auto parts can be calculated according to the following formula:

[0110] f=p+z+t

[0111] Among them, f is the time consumed in the production preparation period of Class A automobile parts, p is the time consumed in the work order schedule planning of Class A automobile parts, z is the time consumed in the three-dimensional warehouse for stocking and sorting Class A automobile parts while stocking and sorting, and t is the time consumed in the delivery of Class A automobile parts to the line.

[0112] 3) Calculate the manufacturing time of Class A auto parts based on the data in the manufacturing data set, so that enterprise managers can make corrections to the later production and sales plans of Class A auto parts based on the time consumption of the manufacturing stage of Class A auto parts:

[0113] The manufacturing time of the Class A auto parts is calculated using the following formula:

[0114] g=(∑(je)) / k

[0115] In the formula, g is the manufacturing time of Class A auto parts, e is the completion time of work order delivery, j is the completion time of assembly line, and k is the number of assemblies;

[0116] 4) Calculate the time spent on the warehouse of Class A auto parts based on the data in the inventory data set, so that enterprise managers can make corrections to the later production and sales plans of Class A auto parts based on the time spent on the warehouse entry of Class A auto parts:

[0117] 4-1) Calculate the storage time of Class A auto parts according to the following formula:

[0118] h=(∑(lr)) / k

[0119] In the formula, h is the storage time of Class A auto parts, l is the time of leaving the temporary storage or the PDA scanning time, r is the time of entering the temporary storage, and k is the total number of units;

[0120] 4-2) Calculate the time required for loading and shipping of Class A auto parts according to the following formula:

[0121] s=(∑(ul)) / k

[0122] In the formula, s is the time taken to load and ship Class A auto parts, u is the time to ship out of the finished product warehouse, l is the time to scan the outbound PDA, and k is the total number of units;

[0123] 4-3) Based on the storage time of Class A auto parts and the loading and shipping time of Class A auto parts, the inventory time of Class A auto parts is calculated according to the following formula:

[0124] w=h+s

[0125] Where w is the inventory time of Class A auto parts, h is the storage time of Class A auto parts, and s is the loading and shipping time of Class A auto parts.

[0126] 5) Calculate the in-transit time of Class A auto parts based on the data in the delivery data set, so that enterprise managers can make adjustments to the later production and sales plans of Class A auto parts based on the time consumed in the delivery stage of Class A auto parts.

[0127] The transit time of Class A auto parts is calculated according to the following formula:

[0128] i=(∑(vu)) / k

[0129] In the formula, i is the in-transit time of Class A auto parts, v is the time from the in-transit warehouse, u is the time from the finished product warehouse, and k is the total number of units.

[0130] The preparation period data includes the number of work orders in a certain month, the planned import time of each work order, the schedule planning and production release time of each work order, the completion time of the three-dimensional warehouse distribution, the start time of distribution, the sorting release time, the sorting completion time, the line side material receiving time or the delivery completion time, and the number of work orders at the line side material receiving time; the manufacturing period data includes the work order delivery completion time, the assembly completion time, and the number of assemblies; the in-warehouse period data includes the time of entering the temporary storage warehouse, the time of leaving the temporary storage warehouse or the PDA scanning time for leaving the warehouse, the number of assemblies, the time of leaving the finished product warehouse, and the PDA scanning time for leaving the warehouse; the in-transit period data includes the time of leaving the in-transit warehouse, the time of leaving the finished product warehouse, and the number of assemblies.

[0131] According to the above steps, the following examples are made:

[0132] 1. If Figure 3 , calculate the production preparation time of Class A automotive parts:

[0133] 1-1) Get the number of work orders for X-type parts (Class A auto parts) of X-assembly in X-month, the planned import time of each work order, and the production schedule release time of each work order:

[0134] Then the work order schedule planning time of Class A automobile parts is: p = ∑ (mn) / o;

[0135] Among them, p is the time consumption of the work order schedule planning of Class A automobile parts, m is the import time of each work order plan, n is the production release time of each work order schedule plan, and o is the number of work orders in a certain month;

[0136] 1-2) Obtain the completion time, start time, sorting release time, and sorting completion time of the three-dimensional warehouse, and calculate the distribution time and sorting time of Class A auto parts respectively:

[0137] 1-2-1) If you want to sort after the goods are distributed (sorting will be carried out after the goods are distributed):

[0138] Then the time required for stocking Class A auto parts in a three-dimensional warehouse is: x = ∑(ba) / o;

[0139] Among them, x is the time taken to distribute goods in the three-dimensional warehouse of Class A auto parts, a is the start time of distribution, b is the completion time of distribution in the three-dimensional warehouse, and o is the number of work orders in a certain month in step 1-1);

[0140] Then the sorting time of Class A auto parts is: y = ∑(dc) / o;

[0141] The variable c is the sorting release time, d is the sorting completion time, and o is the number of work orders in a certain month in step 1-1);

[0142] 1-2-2) If sorting is done while the goods are being distributed (sorting has already started at some point during the distribution):

[0143] Then the time required for stocking and sorting of Class A auto parts in a three-dimensional warehouse is: z = ∑ (da) / o;

[0144] Where y is the time taken to sort Class A auto parts, a is the time to start distribution in (1), d is the time to complete sorting in (1), and o is the number of work orders in a certain month in step 1-1);

[0145] 1-3) Get the number of work orders for line-side material receiving time or delivery completion time, line-side material receiving time:

[0146] Then the time taken to deliver Class A auto parts to the line edge is: t = (∑(ed)) / q;

[0147] Wherein, t is the time taken to deliver Class A auto parts to the line side, e is the time when the line side materials are received or the time when the delivery is completed, d is the time when the sorting is completed in step 1-2-1), and q is the number of work orders when the line side materials are received;

[0148] 1-4) The calculation formula for the production preparation period of Class A automobile parts is as follows:

[0149] 1-4-1) If you wait until the goods are distributed before sorting:

[0150] The production preparation time of Class A automobile parts is: f = p + x + y + t;

[0151] Among them, f is the production preparation time of Class A auto parts, p is the work order schedule planning time of Class A auto parts in step 1-1), x is the three-dimensional warehouse distribution time of Class A auto parts in step 1-2-1), y is the sorting time of Class A auto parts in step 1-2-1), and t is the delivery time of Class A auto parts to the line in step 1-3);

[0152] 1-4-2) If sorting is done while spreading the goods:

[0153] The production preparation time of Class A auto parts is: f = p + z + t;

[0154] Among them, f is the time consumed in the production preparation period of Class A auto parts, p is the time consumed in the work order schedule planning of Class A auto parts in step 1-1), z is the time consumed in the three-dimensional warehouse layout and sorting of Class A auto parts in step 1-2-2), and t is the time consumed in the delivery of Class A auto parts to the line in step 1-3).

[0155] 2. If Figure 4 , calculate the manufacturing time of Class A automotive parts:

[0156] 2-1) Obtain the work order delivery completion time, assembly completion time, and assembly number:

[0157] Then the manufacturing time of Class A auto parts is: g = (∑(je)) / k;

[0158] Among them, g is the manufacturing time of Class A automobile parts, e is the completion time of work order delivery in step 1-3), j is the completion time of assembly completion and k is the number of assemblies.

[0159] 3. If Figure 5 , calculate the inventory time of Class A auto parts:

[0160] 3-1) Obtain the time of entering temporary storage, leaving temporary storage or PDA scanning time of leaving the warehouse:

[0161] Then the storage time of Class A auto parts is: h = (∑(lr)) / k;

[0162] Among them, h is the storage time of Class A auto parts, l is the time for leaving the temporary storage or the PDA scanning time for leaving the temporary storage, r is the time for entering the temporary storage, and k is the total number of units in step 2-1).

[0163] 3-2 Obtain the time of finished product delivery and PDA scanning time:

[0164] Then the time taken to load and ship Class A auto parts is: s = (∑(ul)) / k;

[0165] Among them, s is the time taken to load and ship Class A auto parts, u is the time it takes to ship finished product parts out of the warehouse, l is the PDA scanning time in step 3-1), and k is the number of completed units in step 2-1).

[0166] 3-3) The calculation formula for the inventory time of Class A auto parts is as follows:

[0167] The time spent in inventory for Class A auto parts: w = h + s;

[0168] Among them, w is the time spent in inventory for Class A auto parts, h is the time spent in warehousing for Class A auto parts in step 3-1), and s is the time spent in loading and shipping Class A auto parts in step 3-2).

[0169] 4. If Figure 6 , calculate the transit time of Class A auto parts:

[0170] 4-1) Get the time of the in-transit warehouse:

[0171] Then the transit time of Class A auto parts is: i = (∑(vu)) / k;

[0172] Among them, i is the transit time of Class A auto parts, v is the time from the in-transit warehouse, u is the time from the finished product warehouse in step 3-2), and k is the number of assembled units in step 2-1).

[0173] The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Any modification made to the present invention by those skilled in the art without departing from the spirit of the present invention shall fall within the protection scope of the present invention.

Claims

1. A method for calculating the time consumption at each stage of the entire process of fulfilling an automobile parts order, characterized in that: The following steps are involved: 1) Obtain the corresponding historical data from each stage of the entire process of fulfilling Class A auto parts orders, and form preparation data sets, manufacturing data sets, inventory data sets, and delivery data sets; 2) Calculate the production preparation time of Class A auto parts based on the data in the preparation data set, so that enterprise managers can make corrections to the later production and sales plans of Class A auto parts based on the time spent in the production preparation stage of Class A auto parts; 3) Calculate the manufacturing time of Class A auto parts based on the data in the manufacturing data set, so that enterprise managers can make corrections to the later production and sales plans of Class A auto parts based on the time consumption of the manufacturing stage of Class A auto parts; 4) Calculate the time spent on the warehouse of Class A auto parts based on the data in the inventory data set, so that enterprise managers can make corrections to the later production and sales plans of Class A auto parts based on the time spent on the warehouse entry of Class A auto parts; 5) Calculate the in-transit time of Class A auto parts based on the data in the delivery data set, so that enterprise managers can make adjustments to the later production and sales plans of Class A auto parts based on the time consumed in the delivery stage of Class A auto parts.

2. The method for calculating the time consumption at each stage of the entire process of fulfilling an automobile parts order according to claim 1 is characterized in that: The specific method of obtaining the corresponding historical data from each stage of the entire process of fulfilling the order of Class A auto parts and forming the preparation data set, manufacturing data set, inventory data set, and delivery data set is as follows: 1-1) Obtain preparation period data from several business systems corresponding to the production preparation stage to form a preparation data set; 1-2) Obtain manufacturing data from several business systems corresponding to the product manufacturing stage to form a manufacturing data set; 1-3) Obtain the inventory data from several business systems corresponding to the product warehousing stage to form an inventory data set; 1-4) Obtain in-transit data from several business systems corresponding to the product delivery stage to form a delivery data set.

3. The method for calculating the time consumption at each stage of the entire process of fulfilling an automobile parts order according to claim 1, characterized in that: In step 2), the specific method of calculating the production preparation period time consumption of Class A automobile parts based on the data in the preparation data set is as follows: 2-1) Calculate the work order schedule time for Class A auto parts according to the following formula: p=∑(mn) / o In the formula, p is the single schedule planning time of Class A auto parts, m is the import time of each work order plan, n is the production release time of each work order schedule plan, and o is the number of work orders in a certain month; 2-2) Calculate the distribution time and sorting time of Class A auto parts respectively; 2-3) Calculate the time it takes to deliver Class A auto parts to the line: t=(∑(ed)) / q In the formula, t is the time taken to deliver Class A auto parts to the line side, e is the line side material receiving time or delivery completion time, d is the sorting completion time, and q is the number of work orders at the line side material receiving time; 2-4) Based on the distribution time and sorting time calculated in step 2-2), calculate the production preparation time of Class A auto parts.

4. The method for calculating the time consumption at each stage of the entire process of fulfilling an automobile parts order according to claim 3 is characterized in that: In step 2-2), if sorting is performed after distribution is completed, the distribution time and sorting time of Class A auto parts are calculated as follows: ① Calculate the time required to stock Class A auto parts in a three-dimensional warehouse according to the following formula: x=∑(ba) / o In the formula, x is the time taken to distribute goods in the three-dimensional warehouse of Class A auto parts, b is the time to complete the distribution of goods in the three-dimensional warehouse, a is the time to start distribution, and o is the number of work orders in a certain month; ② Calculate the sorting time of Class A auto parts according to the following formula: y=∑(dc) / o In the formula, y is the sorting time of Class A auto parts, d is the sorting completion time, c is the sorting release time, and o is the number of work orders in a certain month.

5. The method for calculating the time consumption at each stage of the entire process of fulfilling an automobile parts order according to claim 3 is characterized in that: In step 2-2), if the goods are sorted while being distributed, the distribution time and sorting time of Class A auto parts are calculated according to the following formula: z=∑(da) / o In the formula, z is the time consumed for stocking and sorting of Class A auto parts in the three-dimensional warehouse, d is the sorting completion time, a is the start time of stocking, and o is the number of work orders in a certain month.

6. The method for calculating the time consumption at each stage of the entire process of fulfilling an automobile parts order according to claim 3 is characterized in that: In step 2-4), the specific method for calculating the production preparation period of Class A auto parts is as follows: 2-4-1) If sorting is performed after the distribution is completed, the production preparation period of Class A auto parts can be calculated according to the following formula: f=p+x+y+t In the formula, f is the production preparation time of Class A auto parts, p is the work order schedule planning time of Class A auto parts, x is the three-dimensional warehouse stocking time of Class A auto parts after stocking is completed and then sorted, y is the sorting time of Class A auto parts after stocking is completed, and t is the delivery time of Class A auto parts to the line side; 2-4-2) If the goods are sorted while being distributed, the production preparation time of Class A auto parts can be calculated according to the following formula: f=p+z+t Among them, f is the time consumed in the production preparation period of Class A automobile parts, p is the time consumed in the work order schedule planning of Class A automobile parts, z is the time consumed in the three-dimensional warehouse for stocking and sorting Class A automobile parts while stocking and sorting, and t is the time consumed in the delivery of Class A automobile parts to the line.

7. The method for calculating the time consumption at each stage of the entire process of fulfilling an automobile parts order according to claim 1 is characterized in that: The manufacturing time of the Class A auto parts is calculated using the following formula: g=(∑(je)) / k In the formula, g is the manufacturing time of Class A auto parts, e is the completion time of work order delivery, j is the completion time of assembly completion and k is the number of assemblies.

8. The method for calculating the time consumption at each stage of the entire process of fulfilling an automobile parts order according to claim 1, characterized in that: In step 4), the specific method of calculating the inventory time consumption of Class A auto parts based on the data in the inventory data set is as follows: 4-1) Calculate the storage time of Class A auto parts according to the following formula: h=(∑(lr)) / k In the formula, h is the storage time of Class A auto parts, l is the time of leaving the temporary storage or the PDA scanning time, r is the time of entering the temporary storage, and k is the total number of units; 4-2) Calculate the time required for loading and shipping of Class A auto parts according to the following formula: s=(∑(ul)) / k In the formula, s is the time taken to load and ship Class A auto parts, u is the time to ship out of the finished product warehouse, l is the time to scan the outbound PDA, and k is the total number of units; 4-3) Based on the storage time of Class A auto parts and the loading and shipping time of Class A auto parts, the inventory time of Class A auto parts is calculated according to the following formula: w=h+s Where w is the inventory time of Class A auto parts, h is the storage time of Class A auto parts, and s is the loading and shipping time of Class A auto parts.

9. The method for calculating the time consumption at each stage of the entire process of fulfilling an automobile parts order according to claim 1, characterized in that: The transit time of Class A auto parts is calculated according to the following formula: i=(∑(vu)) / k In the formula, i is the in-transit time of Class A auto parts, v is the time from the in-transit warehouse, u is the time from the finished product warehouse, and k is the total number of units.

10. The method for calculating the time consumption at each stage of the entire process of fulfilling an automobile parts order according to claim 1, characterized in that: The preparation period data includes the number of work orders in a certain month, the planned import time of each work order, the schedule planning and production release time of each work order, the completion time of the three-dimensional warehouse distribution, the start time of distribution, the sorting release time, the sorting completion time, the line side material receiving time or the delivery completion time, and the number of work orders at the line side material receiving time; the manufacturing period data includes the work order delivery completion time, the assembly completion time, and the number of assemblies; the in-warehouse period data includes the time of entering the temporary storage warehouse, the time of leaving the temporary storage warehouse or the PDA scanning time for leaving the warehouse, the number of assemblies, the time of leaving the finished product warehouse, and the PDA scanning time for leaving the warehouse; the in-transit period data includes the time of leaving the in-transit warehouse, the time of leaving the finished product warehouse, and the number of assemblies.

Images