Spare parts plan generation method, device, equipment and medium

Abstract

The present application discloses a method, device, equipment and medium for generating a spare parts plan. The method includes: obtaining the business data of spare parts from different business systems respectively, and aggregating them to form basic data; determining the available storage locations of spare parts, inventory data in the available storage locations, identification information of spare parts, maintenance work orders of spare parts, shipping information of assembly parts containing spare parts, alternative material groups of spare parts and bill of materials of assembly parts in the basic data; determining the classification results of spare parts according to the available storage locations, identification information and maintenance work orders; determining the shipment volume of spare parts according to the bill of materials and shipment information; determining the inventory volume of spare parts according to the inventory data and alternative material groups, and generating a spare parts plan according to the classification results, shipment volume, inventory volume and supply lead time of spare parts in the basic data. This solution can improve the generation efficiency of spare parts plans and ensure the rationality and accuracy of spare parts plans.

Description

Technical Field

[0001] The present application relates to the field of spare parts technology, and in particular to a spare parts plan generation method, device, equipment and medium. Background Art

[0002] As the business of enterprises expands, the types of products they produce increase, which also leads to a sharp increase in the types of spare parts. When customers need spare parts, enterprises need to formulate spare parts plans in a timely manner to meet customers' spare parts needs and improve customer satisfaction.

[0003] Currently, the formulation of spare parts plans requires staff to communicate with each business group separately to obtain the business data maintained by each business group, and then the staff will formulate spare parts plans based on the obtained business data.

[0004] However, the current way spare parts planning is done is inefficient. Summary of the invention

[0005] The present application provides a spare parts plan generation method, device, equipment and medium, which can solve the problem of low efficiency in formulating spare parts plans and improve the efficiency of spare parts plan generation.

[0006] In a first aspect, an embodiment of the present application provides a method for generating a spare parts plan, comprising:

[0007] Obtain spare parts business data from different business systems and aggregate them into basic data;

[0008] Determining, from the basic data, the available storage location of the spare part, the inventory data in the available storage location, the identification information of the spare part, the maintenance work order of the spare part, the shipping information of the assembly part including the spare part, the alternative material group of the spare part, and the bill of materials of the assembly part;

[0009] Determine, according to the available storage location, the identification information and the maintenance work order, a classification result of the spare parts, wherein the classification result is used to characterize the market consumption and market demand volatility of the spare parts;

[0010] Determine the shipment quantity of the spare parts according to the bill of materials and the shipment information;

[0011] Determining the inventory quantity of the spare parts according to the inventory data and the alternative material group;

[0012] A spare parts plan is generated according to the classification result, the shipment volume, the inventory volume and the supply lead time of the spare parts in the basic data.

[0013] In an embodiment of the present application, business data scattered in various business systems are unified and aggregated to form basic data, and then some data are selected from these basic data, and then the classification results, shipment volume and inventory of spare parts are determined using this part of data, thereby achieving the purpose of cleaning the basic data, and quickly cleaning the data used to generate the spare parts plan from the disorganized basic data, and then further using the classification results, shipment volume and inventory of the spare parts to generate the spare parts plan, thereby avoiding the problem of directly using disorganized basic data to construct the spare parts plan, which leads to a decrease in the efficiency of spare parts plan construction, and improving the efficiency of spare parts plan generation.

[0014] In some other embodiments of the first aspect, the acquiring the business data of spare parts from different business systems respectively includes:

[0015] Acquire first inventory data in the available warehouse locations from a first business system, where the available warehouse locations include a central warehouse, a regional warehouse, and a service station;

[0016] Acquire the inventory data of the spare part at the service station, the substitute material group, the available storage location and the maintenance work order from the second business system;

[0017] The supply lead time of the spare parts, the relationship between the central warehouse and the material group, and the demand forecast data are obtained from the third business system.

[0018] In an embodiment of the present application, by acquiring the business data maintained by different business systems respectively and aggregating them to form basic data, the manpower and material resources spent on the preliminary communication by spare parts planning personnel can be reduced, the data acquisition efficiency can be improved and the data acquisition cost can be reduced.

[0019] In some further embodiments of the first aspect, determining the classification result of the spare parts includes:

[0020] Determining historical consumption data of the spare parts in each of the available storage locations according to the identification information and the maintenance work order;

[0021] Determining the consumption level of the spare parts and the volatility of demand for the spare parts based on the historical consumption data;

[0022] A classification result of the spare parts is determined according to the consumption level and the demand volatility.

[0023] In the embodiment of the present application, by determining the classification results of spare parts, the demand quantity and demand volatility of spare parts in the market can be accurately grasped, so as to more accurately construct a reasonable spare parts plan.

[0024] In some further embodiments of the first aspect, the historical consumption data include: the consumption of the spare parts in each time period, the total number of times the spare parts are required in all time periods, the sum of the consumption of the spare parts in all time periods, the average consumption of the spare parts in each time period and at least one of the standard deviation of the demand for the spare parts in each time period.

[0025] In the embodiment of the present application, by configuring a reasonable time period and counting the spare parts consumption data for each time period, and by observing the changes in spare parts consumption in different time periods, the long-term trend and seasonal fluctuations in spare parts consumption can be identified.

[0026] In some further embodiments of the first aspect, determining the volatility of demand for the spare parts according to the historical consumption data includes:

[0027] Determining the fluctuation coefficient of the spare parts according to the average consumption of the spare parts in each time period and the demand standard deviation;

[0028] The demand volatility of the spare parts is determined according to the fluctuation coefficient and at least one set limit value.

[0029] In the embodiment of the present application, by determining the volatility of spare parts demand, a spare parts plan can be further constructed more reasonably, thereby improving the utilization rate of spare parts and avoiding inventory backlogs and the like.

[0030] In some further embodiments of the first aspect, before determining the historical consumption data of the spare part in each of the available storage locations according to the identification information and the maintenance work order, the method further includes:

[0031] According to the identification information, the consumption data of the spare parts in the maintenance work order is adjusted to the work order header line of the maintenance work order.

[0032] In an embodiment of the present application, the original work order header line structure is adjusted so that material consumption data becomes the main display object, which helps to understand the material consumption situation more intuitively.

[0033] In some further embodiments of the first aspect, determining the consumption level of the spare parts according to the historical consumption data includes:

[0034] According to the historical consumption data, obtain the consumption proportion of each spare part, where the consumption proportion includes at least one of the consumption proportion of the spare part in the available storage location and the consumption proportion of the spare part in the material group;

[0035] Sort each spare part in descending order according to the proportion of its consumption;

[0036] According to the arrangement order, at least one spare part is selected from the sorted spare parts, and the sum of the consumption proportions of the selected spare parts is determined;

[0037] The consumption level of each selected spare part is determined according to the relationship between the sum of the consumption proportions and a preset level threshold.

[0038] In an embodiment of the present application, by utilizing the consumption proportion of each spare part to sort the spare parts, and by setting level thresholds to grade the spare parts, it is possible to determine which spare parts have a large consumption and which spare parts have a small consumption, thereby further improving the rationality of the spare parts plan construction.

[0039] In some further embodiments of the first aspect, determining the shipment quantity of the spare parts according to the bill of materials and the shipment information includes:

[0040] According to the bill of materials, determining the usage of the spare parts in the assembly;

[0041] The shipment quantity of the spare parts is determined according to the shipment information of the assembly parts and the usage.

[0042] In the embodiment of the present application, by determining the actual shipment volume of spare parts, it is possible to facilitate the prediction of the market demand for spare parts, thereby further constructing a reasonable spare parts plan.

[0043] In some further embodiments of the first aspect, determining the inventory quantity of the spare parts according to the inventory data and the substitute material group includes:

[0044] Determine the inventory quantity of the spare parts according to the inventory data of the service station obtained from the second business system and the inventory data of the central warehouse and the inventory data of the regional warehouse obtained from the first business system;

[0045] The inventory data includes available inventory in stock, available inventory in transit and inventory to be delivered of unused spare parts, available inventory in stock and available inventory in transit of used spare parts, and at least one of available inventory in stock of alternative materials for the spare parts, available inventory in transit of the alternative materials and inventory to be delivered of alternative materials.

[0046] In an embodiment of the present application, by determining the inventory data of spare parts in a storage location, the spare parts data can be set more accurately when constructing a spare parts plan, thereby avoiding a backlog in the storage location due to an excessive number of spare parts when constructing a spare parts plan.

[0047] In a second aspect, the present application provides a spare parts plan generating device, comprising:

[0048] The data acquisition module is used to obtain the business data of spare parts from different business systems and aggregate them into basic data;

[0049] a data selection module, used to determine, from the basic data, the available storage location of the spare part, the inventory data in the available storage location, the identification information of the spare part, the maintenance work order of the spare part, the shipping information of the assembly part including the spare part, the alternative material group of the spare part and the bill of materials of the assembly part;

[0050] A result determination module, used to determine the classification result of the spare parts according to the available storage location, the identification information and the maintenance work order, wherein the classification result is used to characterize the market consumption and market demand volatility of the spare parts;

[0051] A shipment quantity determination module, used to determine the shipment quantity of the spare parts according to the bill of materials and the shipment information;

[0052] An inventory quantity determination module, used to determine the inventory quantity of the spare parts according to the inventory data and the substitute material group;

[0053] A plan generation module is used to generate a spare parts plan based on the classification results, the shipment volume, the inventory volume and the supply lead time of the spare parts in the basic data.

[0054] In a third aspect, the present application provides an electronic device, comprising: a processor and a memory storing computer program instructions, wherein the processor implements the steps of the method described above when executing the computer program instructions.

[0055] In a fourth aspect, the present application provides a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the steps of the method described above are implemented. BRIEF DESCRIPTION OF THE DRAWINGS

[0056] The features, advantages and technical effects of exemplary embodiments of the present application will be described below with reference to the accompanying drawings.

[0057] Figure 1 A schematic diagram of a spare parts plan construction scenario provided in an embodiment of the present application;

[0058] Figure 2 A flowchart of a method for generating a spare parts plan provided in an embodiment of the present application;

[0059] Figure 3 A schematic diagram of a spare parts plan construction process provided in an embodiment of the present application;

[0060] Figure 4 A schematic diagram of the process of obtaining business data provided in an embodiment of the present application;

[0061] Figure 5 A schematic diagram of a process for determining a spare parts classification result provided in an embodiment of the present application;

[0062] Figure 6 A schematic diagram of a volatility determination process provided in an embodiment of the present application;

[0063] Figure 7 A schematic diagram of a consumption level determination process provided in an embodiment of the present application;

[0064] Figure 8 A schematic diagram of a maintenance work order provided in an embodiment of the present application;

[0065] Fig. 9 A flow chart of a method for determining spare parts shipment quantity provided in an embodiment of the present application;

[0066] Fig.10 A schematic diagram of a method for determining spare parts inventory provided in an embodiment of the present application;

[0067] Fig.11 A flowchart of a spare parts plan generation method provided in another embodiment of the present application;

[0068] Fig.12 A schematic diagram of the structure of a spare parts plan generating device provided in an embodiment of the present application;

[0069] Fig.13 A schematic diagram of the hardware structure of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0070] In order to make the purpose, technical solution and advantages of the embodiments of the present application clearer, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.

[0071] As the business of enterprises expands globally, the customers involved are usually all over the world. The types and shipments of enterprise products have increased dramatically, which has also led to a continuous increase in the types of spare parts. When customers have spare parts needs, enterprises need to meet their spare parts needs in a timely manner to improve customer satisfaction and maintain a good image for the company. However, the construction of spare parts plans involves complex data sources, which makes it difficult to build spare parts plans.

[0072] At present, some of the business data used to build spare parts plans are scattered in different business systems, and some are not even maintained by business systems and are completely dependent on personal management by business personnel. This leads to very messy data distribution. When spare parts planners build spare parts plans, the data acquisition and communication costs are high. Moreover, after the spare parts planners obtain various business data, the efficiency of spare parts planners in formulating spare parts plans is reduced because these business data are disorganized and the data volume is large. Moreover, the whole process requires a lot of manpower and material resources, which increases the cost of building spare parts plans.

[0073] In view of the above problems, the embodiment of the present application provides a spare parts plan generation scheme, which can be applied to the scenario of building a spare parts plan when the customer has spare parts demand. Among them, the scheme can be deployed in the target system, and the target system can be connected with the above-mentioned other business systems to obtain the business data maintained by each business system to realize the aggregation of business data. At the same time, when the target system executes the scheme, it can select part of the data from the aggregated basic data, and then directly use this part of the data to generate the core data required for building the spare parts plan (specifically including the market consumption of spare parts, market demand volatility, shipments and inventory, etc.), so as to achieve the cleaning of the basic data and avoid the interference of other disorderly data (such as spare parts price and spare parts composition, etc.) in the aggregated basic data on the spare parts plan. And using the core data obtained after cleaning to directly generate the spare parts plan, this also solves the problem of decreased efficiency caused by directly using disorderly basic data to generate spare parts plans, thereby improving the efficiency of spare parts plan generation, and because there is no interference from other data, the generated spare parts plan can also be made more reasonable and accurate.

[0074] The technical solution of the present application is described in detail below through specific embodiments. It should be noted that the following specific embodiments can be combined with each other, and the same or similar concepts or processes may not be described in detail in some embodiments.

[0075] For example, Figure 1 A schematic diagram of a spare parts plan construction scenario provided in an embodiment of the present application, such as Figure 1 As shown, the target system mentioned above can be deployed in the electronic device 10. After the electronic device 10 starts the target system, the target system is run to execute the above scheme. The electronic device 10 is connected with other electronic devices 11 (other electronic devices are deployed with corresponding business systems) to achieve the connection between the target system and other business systems to obtain business data maintained by other business systems.

[0076] Figure 2The flowchart of the spare parts plan generation method provided in the embodiment of the present application is shown in FIG. The method can be executed in the above-mentioned target system. By executing the method, the business data maintained on different business systems can be aggregated into a unified target system. At the same time, the aggregated data can be cleaned to obtain the core data for building the spare parts plan to generate the spare parts plan. Specifically, Figure 2 As shown, the method may specifically include the following steps:

[0077] Step S210: Obtain the business data of spare parts from different business systems respectively, and aggregate them to form basic data.

[0078] In this embodiment, there are at least two business systems. To improve data processing efficiency, different business systems usually maintain different types of business data.

[0079] Optionally, the business system includes a spare parts data management group, a warehousing and logistics group, a spare parts guarantee department, a domestic service department, etc. The business data maintained by the spare parts data management group may be spare parts forecast data, the business data maintained by the warehousing and logistics group may be warehouse data, the business data maintained by the spare parts guarantee department may be standard supply lead time data, and the business data maintained by the domestic service department may be maintenance data.

[0080] Among them, spare parts forecast data is mainly used to predict the market demand for spare parts. Warehouse data is mainly used to confirm the inventory of spare parts in the warehouse. Standard supply lead time data is used to indicate that there is time loss in the actual supply process of spare parts. For this reason, it is necessary to set a supply lead time so that spare parts can be supplied to customers in a timely manner. Maintenance data can refer to maintenance work orders. For example, if a product needs to be replaced and repaired during actual use, relevant data needs to be recorded through maintenance work orders during the replacement of spare parts.

[0081] In this embodiment, since the spare parts business data obtained from different business systems are relatively messy, the business data can be preliminarily classified for subsequent retrieval and review. For example, each business data can be classified according to its source.

[0082] In this embodiment, the spare part may refer to a spare part of a repairable component on a product. When the component is damaged, the spare part can be replaced to maintain the integrity of the entire product. For example, taking a vehicle as an example, a vehicle usually has four wheels, each wheel usually has a wheel hub, and the spare part may refer to the wheel hub. When the wheel hub is damaged, it is not necessary to directly replace the entire wheel, but the wheel hub can be directly replaced to complete the repair, thereby reducing the repair cost.

[0083] Step S220: Determine in the basic data the available storage locations of spare parts, inventory data in the available storage locations, identification information of spare parts, maintenance work orders of spare parts, shipping information of assemblies containing spare parts, alternative material groups of spare parts and bills of materials of assemblies.

[0084] In this embodiment, the available storage location refers to a warehouse that can actually be used to store spare parts. Exemplarily, according to the level of the warehouse, it can be divided into a central warehouse, a regional warehouse, and a service station. Among them, when the service station lacks the inventory of the spare part, it can initiate a spare part application to the regional warehouse. When the regional warehouse lacks the inventory of the spare part, it can continue to initiate a spare part application to the central warehouse. When the central warehouse lacks the inventory of the spare part, it means that the spare part is not in stock in the central warehouse, the regional warehouse, and the service station. The inventory data in the available storage location can refer to the inventory quantity of the spare parts in the above warehouse.

[0085] In this embodiment, the identification information of the spare part may refer to the spare part number (Part Number, PN) of the spare part. Usually, the spare part numbers of different spare parts are different. In addition, in actual use, the spare parts can be divided into upper-layer spare parts and lower-layer spare parts. The upper-layer spare parts include multiple lower-layer spare parts, and the lowest-layer spare parts refer to after-sales repairable units. For example, continuing to take the wheel as an example, the wheel can be used as an upper-layer spare part, and the wheel hub in the wheel can be used as a lower-layer spare part. When the wheel hub is damaged, the wheel hub can be directly replaced without replacing the entire wheel.

[0086] In this embodiment, the spare parts maintenance work order is used to record and manage the spare parts required during the product maintenance process. For example, taking a vehicle as an example, a wheel usually has four wheels. If the wheel needs to be repaired, the maintenance work order can record the required spare parts as: four wheels.

[0087] In this embodiment, the assembly parts may refer to the upper-level spare parts mentioned above, and the shipment volume of the lower-level spare parts may be determined through the shipment information of the upper-level spare parts.

[0088] In this embodiment, the alternative material group of spare parts may refer to a group of materials that can be used interchangeably in the bill of materials (BOM). These materials are similar in function, specification or performance and can meet the same production needs or assembly requirements. For example, taking a 10-meter wiring harness as an example, its alternative material may be a 20-meter wiring harness. Among them, the bill of materials can provide a detailed understanding of the composition of the assembly, for example, the composition of a car includes at least four wheels and an engine.

[0089] Step S230: Determine the classification result of spare parts according to the available storage location, identification information and maintenance work order, wherein the classification result is used to characterize the market consumption and market demand volatility of spare parts.

[0090] In this embodiment, the identification information of the spare part can be used to determine which maintenance work orders use the spare part from a large number of maintenance work orders, thereby implementing the screening of maintenance work orders.

[0091] After the maintenance work orders are screened, the consumption of the spare parts can be determined by the maintenance work orders. For example, the consumption of the spare parts in the central warehouse, the consumption of the spare parts in the regional warehouse, and the consumption of the spare parts in the service station can be obtained.

[0092] Furthermore, by further dividing the time periods into a plurality of time periods and determining the consumption of spare parts in each time period, the volatility of market demand is determined based on the consumption of spare parts in each time period.

[0093] Exemplarily, the classification results of spare parts can be divided into the following 9 types: A1, A2, A3, B1, B2, B3, C1, C2, C3, where A indicates that the market consumption is small, B indicates that the market consumption is medium, and C indicates that the market consumption is large. 1 indicates that the market demand volatility is large, 2 indicates that the market demand volatility is medium, and 3 indicates that the market demand volatility is small. Combining the above letters A, B, C and the numbers 1, 2, 3, 9 classification results are formed. For example, A1 indicates that the classification result of the spare part is: the market consumption is small and the market demand volatility is large.

[0094] Step S240: Determine the shipment quantity of the spare parts according to the bill of materials and the shipment information.

[0095] In this embodiment, the bill of materials records the quantity of each lower-level spare part under the assembly part. The shipment quantity of each lower-level spare part can be determined through the shipment information of the assembly part and the quantity of the lower-level spare parts of each assembly part.

[0096] Step S250: Determine the inventory quantity of the spare parts according to the inventory data and the substitute material group.

[0097] In this embodiment, the inventory data may include the inventory of the spare part in the central warehouse, the inventory of the spare part in the regional warehouse, and the inventory of the spare part in the service station. In addition, there are alternative material groups that can replace the spare part in the central warehouse, the regional warehouse, and the service station. By counting the number of alternative material groups in the central warehouse, the regional warehouse, and the service station, the actual inventory of the spare part can be determined more accurately.

[0098] Step S260: Generate a spare parts plan based on the classification results, shipment volume, inventory volume, and supply lead time of spare parts in the basic data.

[0099] In this embodiment, after the business data obtained from various business systems are aggregated to form basic data, the basic data is very disorganized and the data volume is large. If these basic data are directly used to generate a spare parts plan, the spare parts plan may be disturbed by the disorganized data, resulting in a decrease in the rationality and accuracy of the spare parts plan. At the same time, it is time-consuming and laborious to organize these disorganized data, which also affects the efficiency of building the spare parts plan. Therefore, it is necessary to clean the data to obtain the core data for building the spare parts plan (including the classification results, shipment volume and inventory volume of subsequent spare parts).

[0100] In this embodiment, some available data (including available storage locations of spare parts, inventory data in the available storage locations, identification information of the spare parts, maintenance work orders of the spare parts, shipment information of the assembly parts including the spare parts, alternative material groups of the spare parts and the bill of materials of the assembly parts) are filtered out from the basic data, and then the core data for generating the spare parts plan is further obtained by using this part of the available data. In this way, useless business data in the basic data can be cleaned up, and then the spare parts plan is generated directly by using this part of the core data. This avoids the problem of directly using disorganized basic data to construct the spare parts plan, which leads to reduced efficiency and poor accuracy in constructing the spare parts plan.

[0101] In this embodiment, by cleaning the aggregated basic data, the market consumption of spare parts and the volatility of market demand, the shipment volume of spare parts, and the inventory volume of spare parts are obtained, and the cleaning of the aggregated basic data is realized, so that the core data required for formulating the spare parts plan is quickly obtained, and the efficiency of generating the spare parts plan is improved. At the same time, the spare parts plan is directly generated using these core data, and the interference of other messy data in the basic data is avoided, thereby improving the rationality and accuracy of the spare parts plan and avoiding the situation of spare parts backlog in the warehouse. In addition, since the method directly connects with other business systems through the target system and aggregates the basic data, the human cost invested in data acquisition can also be reduced.

[0102] Specifically, Figure 3 A schematic diagram of the spare parts plan construction process provided in the embodiment of the present application is as follows: Figure 3 As shown, the method may specifically include the following steps:

[0103] Step S310: determining the supply lead time of spare parts from basic data;

[0104] Step S320: Generate a spare parts plan based on supply lead time, market consumption and market demand volatility, shipment volume and inventory.

[0105] In this embodiment, the supply lead time of spare parts may refer to the time required for delivering spare parts to customers after the enterprise has received spare parts demand from customers and prepared spare parts. By obtaining the supply lead time, the delivery cycle of spare parts, the delivery time of spare parts, etc. can be determined. In order to meet customer needs in a timely manner, the supply lead time needs to be referred to when constructing the spare parts plan so that spare parts can be delivered to customers in a timely manner.

[0106] In this embodiment, the spare parts classification result can be used to clarify the volatility of spare parts demand and the amount of consumption, and determine which spare parts can be stocked more and which spare parts can be stocked less.

[0107] In this embodiment, the demand for stocking can be clarified through the spare parts shipment volume, that is, whether the spare parts need to be stocked. For example, the larger the shipment volume, the larger the quantity required for stocking.

[0108] In this embodiment, the actual quantity that needs to be stocked can be clearly determined through the spare parts inventory. For example, if the customer's spare parts demand is 300 and the inventory is 100, then the stocking quantity can be set to more than 200.

[0109] In the embodiment of the present application, the rationality of the spare parts plan can be improved through the above-mentioned supply lead time, market consumption and market demand volatility, shipments and inventory. Specifically, the supply lead time can be used to clarify when to start stocking, achieve timely spare parts supply and rapid response capabilities, meet customer needs, and improve customer satisfaction. In addition, the market changes in spare parts can be determined through market consumption and demand volatility, and the stocking quantity can be reasonably adjusted to control inventory levels. The future spare parts demand can be predicted through the shipment of spare parts, thereby adjusting the spare parts production plan to avoid the situation of spare parts out of stock. And through the spare parts inventory, when formulating the spare parts plan, it is possible to achieve optimal inventory management and avoid the situation of spare parts being piled up in the warehouse.

[0110] Figure 4 A schematic diagram of the process of obtaining business data provided in the embodiment of the present application is shown in FIG. Figure 4 As shown, the method may specifically include the following steps:

[0111] Step S410: Acquire first inventory data in available storage locations from a first business system;

[0112] Step S420: Acquire second inventory data, alternative material groups, available storage locations, and maintenance work orders of spare parts at the service station from the second business system;

[0113] Step S430: Obtain the supply lead time of spare parts, the relationship between the central warehouse and the material group, and the demand forecast data from the third business system.

[0114] Among them, available storage locations include central warehouses, regional warehouses and service stations.

[0115] For step S410, the target system mentioned above may be directly connected to the first business system, and the first business system directly transmits the first inventory data in the available storage location to the target system.

[0116] Exemplarily, the first business system may refer to a business system used by a warehousing and logistics group, which is responsible for maintaining warehouse data.

[0117] For step S420, the target system mentioned above can directly connect with the second business system to obtain the maintenance work order information. In addition, the target system can also connect with the second business system to obtain the second inventory data, alternative material group, and available storage location of the service station.

[0118] The first inventory data may include the inventory data of the central warehouse, the inventory data of the regional warehouse and the inventory data of the service station, and the second inventory data may refer to the real-time inventory of the service station. By obtaining the second inventory data from the service station and the first inventory data from the central warehouse and the regional warehouse at the same time, the obtained inventory data can be timely and accurate.

[0119] Among them, available storage locations refer to storage locations that are still in use. For example, in central warehouses, regional warehouses and service stations, some service stations have actually been withdrawn from use, but they may still be maintained in the second business system. At this time, these storage locations that are not still in use can be eliminated through manual identification marking to achieve the accuracy of the final inventory data.

[0120] For step S430, the third business system may refer to the business system used by the spare parts guarantee department, which may provide standard supply lead time data. The target system directly connects with the third business system to obtain supply lead time, central warehouse and material group relationship and demand forecast data.

[0121] Among them, the central warehouse usually refers to the upstream warehouse, which is responsible for the centralized management and distribution of spare parts. The material group is formed by classifying and merging multiple materials. The division of material groups helps the central warehouse to manage inventory more effectively. At the same time, the setting of material groups also facilitates the central warehouse to formulate differentiated inventory strategies according to the characteristics of different material groups. The relationship between the central warehouse and the material group is reflected in the management and distribution of the material group by the central warehouse. The demand forecast data refers to the results of forecasting and estimating future spare parts demand.

[0122] In addition, in some implementations, the business data may also be directly manually input into the target system by business personnel.

[0123] In an embodiment of the present application, by integrating different types of business data maintained by various business systems into the same system, it is possible to view and process all business data in the same system, thereby improving data cleaning efficiency. At the same time, it is also convenient for mutual verification between different types of data, improving data quality, avoiding the existence of erroneous data, and thus improving the accuracy of data cleaning results.

[0124] Figure 5 A schematic diagram of a process for determining the spare parts classification result provided in an embodiment of the present application is shown in FIG. Figure 5 , the method may specifically include the following steps:

[0125] Step S510: determining historical consumption data of spare parts in each available storage location according to the identification information and the maintenance work order;

[0126] Step S520: Determine the consumption level of spare parts and the volatility of spare parts demand based on historical consumption data;

[0127] Step S530: Determine the classification result of spare parts according to the consumption level and demand volatility.

[0128] In this embodiment, the above steps S510 to S530 may be executed in the target system mentioned above to save the manpower cost of manually performing data cleaning to obtain spare parts classification results.

[0129] For step S510, through the identification information of the spare part (such as the spare part number mentioned above), it is possible to find out which maintenance work orders use the spare part and the usage of the spare part, thereby determining the historical consumption data of the spare part.

[0130] Exemplarily, basic dimensional information may be formed according to the central warehouse, regional warehouse, service station, and spare parts number to perform statistics to calculate the consumption of spare parts in each time period in a total time period (eg, one year).

[0131] For step S520, multiple level thresholds may be configured, such as a first level threshold, a second level threshold, and a third level threshold, and then the historical consumption data of the spare parts are compared to determine the consumption level of the spare parts. Exemplarily, when the historical consumption data of the spare parts is less than the first level threshold, the consumption level of the spare parts is determined to be "small", when the historical consumption data of the spare parts is greater than the first level threshold and less than the second level threshold, the consumption level of the spare parts is determined to be "medium", and when the historical consumption data of the spare parts is greater than the second level threshold and less than the third level threshold, the consumption level of the spare parts is determined to be "high".

[0132] In addition, by comparing the historical consumption data of spare parts in different historical periods, the volatility of spare parts demand can be determined. For example, in historical period T1, the consumption of spare parts is T11, and in historical period T2, the consumption of spare parts is T21. By comparing consumption T11 and consumption T21, the volatility of spare parts demand can be determined.

[0133] For step S530, the classification result can be formed by combining the consumption level and the demand volatility. Exemplarily, it is mentioned above that the consumption level can be divided into "small", "medium" and "high". Similarly, demand volatility can be divided into "large fluctuation", "medium fluctuation" and "small fluctuation". Combining the consumption level and demand volatility in this way can form the following 9 classification results: ① "small" consumption and "large fluctuation"; ② "small" consumption and "medium fluctuation"; ③ "small" consumption and "small fluctuation"; ④ "medium" consumption and "large fluctuation"; ⑤ "medium" consumption and "medium fluctuation"; ⑥ "medium" consumption and "small fluctuation"; ⑦ "large" consumption and "large fluctuation"; ⑧ "large" consumption and "medium fluctuation"; ⑨ "large" consumption and "small fluctuation".

[0134] Furthermore, in some implementations, historical consumption data within a time period may be counted, and the time period may be divided into a number of time periods. In this way, the historical consumption data of spare parts may be specifically divided into at least one of: the consumption of spare parts in each time period, the total number of times the demand for spare parts occurs in all time periods, the total consumption of spare parts in all time periods, the average consumption of spare parts in each time period, and the standard deviation of the demand for spare parts in each time period.

[0135] For example, taking a year as a time period, 52 weeks can be divided, and each week is a time period, so that the historical consumption data of spare parts in each week can be obtained. By counting the historical consumption data of spare parts in each week, the volatility of spare parts demand can be determined more accurately. Among them, the total consumption of spare parts in all time periods is the total annual demand.

[0136] The historical consumption data of all weeks can be added up and then divided by 52 (the number of weeks) to get the average historical consumption data for each week. Then the square of the difference between the consumption data of each week and the average historical consumption data is calculated, and these square values ​​are added together to get the comprehensive value and then divided by 52 (the number of weeks) to get the variance. Finally, the square root of the variance is taken to get the standard deviation of demand.

[0137] In an embodiment of the present application, by obtaining the classification results of spare parts, the market demand and demand volatility of spare parts in historical periods can be determined, so that the accuracy of stocking quantities can be improved when constructing spare parts plans to ensure customers' spare parts needs.

[0138] Figure 6 A schematic diagram of the volatility determination process provided in the embodiment of the present application is as follows: Figure 6 As shown, the method may include the following steps:

[0139] Step S610: determining the fluctuation coefficient of spare parts according to the average consumption and demand standard deviation of spare parts in each time period;

[0140] Step S620: Determine the volatility of spare parts demand based on the volatility coefficient and at least one set limit value.

[0141] In this embodiment, the demand standard deviation may be divided by the average consumption to obtain the fluctuation coefficient. In addition, in other embodiments, the average consumption may be divided by the demand standard deviation to obtain the fluctuation coefficient.

[0142] Furthermore, multiple limit values ​​may be set, such as a first limit value and a second limit value. For example, the first limit value is 0.75 and the second limit value is 1.5. If the coefficient of fluctuation of the spare part is less than 0.75, it is marked as "large volatility", if the coefficient of fluctuation of the spare part is greater than or equal to 0.75 and less than 1.5, it is marked as "medium volatility", and if the coefficient of fluctuation of the spare part is greater than or equal to 1.5, it is marked as "small volatility".

[0143] In the embodiment of the present application, by determining the volatility of spare parts demand, it is possible to determine the changes in spare parts demand in different time periods, thereby formulating a more reasonable spare parts plan, improving spare parts utilization, and avoiding inventory backlogs and the like.

[0144] Figure 7 A schematic diagram of a consumption level determination process provided in an embodiment of the present application is shown in FIG. Figure 7 As shown, the method may include the following steps:

[0145] Step S710: Obtain the consumption ratio of each spare part according to the historical consumption data;

[0146] Step S720: sorting each spare part in descending order according to the consumption ratio of each spare part;

[0147] Step S730: selecting at least one spare part from the sorted spare parts according to the arrangement order, and determining the sum of the consumption proportions of the selected spare parts;

[0148] Step S740: Determine the consumption level of each selected spare part according to the relationship between the sum of the consumption proportions and a preset level threshold.

[0149] The consumption ratio includes at least one of the consumption ratio of spare parts in available storage locations and the consumption ratio of spare parts in material groups.

[0150] For step S710, illustratively, taking the material group including spare parts B1, B2 and B3 as an example, the consumption of spare part B1 is B11, the consumption of spare part B2 is B22, and the consumption of spare part B3 is B33, then the consumption proportion of spare part B1 is B11 / (B11+B22+B33).

[0151] Among them, by calculating the consumption of spare parts, it is possible to determine which spare parts are consumed more and which spare parts are consumed less, which can facilitate the subsequent stocking of spare parts.

[0152] For step S720, step S730 and step S740, taking spare part B1, spare part B2 and spare part B3 as an example, the spare parts arrangement order is shown in Table 1 below:

[0153]

[0154] Table 1

[0155] As shown in Table 1 above, after spare parts B1, B2 and B3 are sorted from top to bottom according to the consumption ratio, spare part B1 is selected first, and its consumption ratio is found to be 0.8. Assuming that the preset level threshold includes the first level threshold and the second level threshold, where the first level threshold is assumed to be 0.8 and the second level threshold is assumed to be 0.95, the consumption ratio of spare part B1 is equal to the first level threshold, and the consumption level of spare part B1 is determined to be the first level. Then spare part B2 is selected, and it is found that the sum of the consumption ratios of spare parts B1 and B2 is equal to the second level threshold. At this time, the consumption level of spare part B2 is determined to be the second level. Similarly, the consumption level of spare part B3 is determined to be the third level.

[0156] In an embodiment of the present application, by utilizing the consumption proportion of each spare part to sort the spare parts, and by setting level thresholds to grade the spare parts, it is possible to determine from among the spare parts which spare parts have a large consumption and which spare parts have a small consumption. Based on the consumption of the spare parts, the spare parts can be stocked more accurately, thereby further improving the rationality and accuracy of the spare parts plan.

[0157] Figure 8 A schematic diagram of a maintenance work order provided in an embodiment of the present application, such as Figure 8As shown, the header line of a maintenance work order usually only includes the work order number, creation date, customer information, equipment information, etc. In order to facilitate the identification of maintenance work orders, the system often only displays the content in the header line of the work order, such as the work order number of the maintenance work order. After the user finds the corresponding maintenance work order through the work order number query, he can enter the work order to view the relevant material consumption data.

[0158] In order to understand the material consumption more intuitively and quickly determine the consumption data of spare parts, in this case, the structure of the work order header line in the maintenance work order is adjusted, and the consumption data of spare parts in the maintenance work order is adjusted to the work order header line of the maintenance work order. In this way, the consumption data of spare parts will also be displayed in the system, and there is no need to enter the work order to view it, which improves data processing efficiency.

[0159] Fig. 9 A flow chart of a method for determining the spare parts shipment quantity provided in an embodiment of the present application is as follows: Fig. 9 As shown, it includes the following steps:

[0160] Step S910: Determine the amount of spare parts used in the assembly according to the bill of materials;

[0161] Step S920: Determine the shipment quantity of spare parts according to the shipment information and usage of the assembly parts.

[0162] Among them, taking the assembly part as a wheel as an example, the spare part may refer to the hub of the wheel.

[0163] In this embodiment, the enterprise usually sells a complete product and delivers it to the customer. During the use of the product, some parts may be damaged, which generates the demand for spare parts. However, the enterprise often counts the sales volume of the product, so it is necessary to rely on the bill of materials to further determine the shipment volume of spare parts carried in the product.

[0164] The target system can be connected to the bill of materials maintenance system to obtain the bill of materials. The bill of materials can provide detailed information about the composition of the assembly parts. For example, if the product is a car, the assembly part can be a wheel, and a wheel includes an after-sales repairable unit: the wheel hub, which can be used as a spare part.

[0165] Among them, according to the composition of the assembly, the standard amount of spare parts in the assembly can be determined, and then according to the shipment information of the assembly or the shipment information of the product, the shipment volume of spare parts can be further determined. For example, assuming that 100 cars are sold, each car usually has four wheels, and each wheel usually has a hub, then taking the hub as a spare part, the shipment volume of the hub can be calculated as: 100*4*1=400.

[0166] In an embodiment of the present application, by determining the actual shipment volume of spare parts, the potential market demand for spare parts can be determined. When the shipment volume is larger, the stock of spare parts can be larger, and when the shipment volume is smaller, the stock of spare parts can be smaller. In this way, a more reasonable spare parts plan can be generated.

[0167] Fig.10 A flow chart of a method for determining spare parts inventory provided in an embodiment of the present application is shown in FIG. Fig.10 As shown, the specific steps include:

[0168] Step S1010: Determine the inventory of spare parts based on the inventory data of the service station obtained from the second business system and the inventory data of the central warehouse and the inventory data of the regional warehouse obtained from the first business system. The inventory data includes at least one of the available inventory in stock, available inventory in transit, and inventory to be delivered of unused spare parts, the available inventory in stock and available inventory in transit of used spare parts, and the available inventory in stock of alternative materials for spare parts, available inventory in transit of alternative materials, and inventory to be delivered of alternative materials.

[0169] In this embodiment, the storage locations can be divided into at least two levels, for example, the storage locations can be divided into three levels, namely, central warehouse, regional warehouse, and service station. For another example, the storage locations can be divided into two levels, namely, central warehouse and other warehouses (including regional warehouses or service stations or both regional warehouses and service stations).

[0170] In this embodiment, unused spare parts can be called new parts, used spare parts can be called old parts, and the replaceable materials of spare parts can be called replacement materials. In order to ensure the accuracy and timeliness of inventory data and avoid inventory redundancy and waste of resources, spare parts can specifically cover three dimensions: new parts, old parts, and replacement materials, and each dimension is divided into available inventory in stock, in-transit inventory, and inventory to be delivered according to actual conditions. Among them, due to the complexity of the old parts, the inventory to be delivered is not used.

[0171] In an embodiment of the present application, by determining the inventory data of spare parts in a storage location, the spare parts data can be set more accurately when constructing a spare parts plan, thereby avoiding a backlog in the storage location due to an excessive number of spare parts when constructing a spare parts plan.

[0172] Fig.11 A flowchart of a spare parts plan generation method provided in another embodiment of the present application is shown in FIG. Fig.11 As shown, the method includes the following four steps:

[0173] Step S1110: basic data summary.

[0174] Step S1120: Classification of spare parts.

[0175] Step S1130: Spare parts shipment data.

[0176] Step S1140: Spare parts inventory data.

[0177] In this embodiment, the business data required to build the spare parts plan comes from different business systems, and a unified target system is needed to connect with each business system to realize the online transmission of business data. After the data is acquired, it will be integrated and stored according to the cleaning rules.

[0178] The basic data aggregation in step S1110 can be specifically divided into the following processes:

[0179] a) Business personnel can directly transfer spare parts supply lead time, spare parts demand forecast, and the relationship between central warehouse and material group to the target system;

[0180] b) Connect the Service Parts Management system to the Global Support Services (GSS) system to obtain service station inventory, alternative material groups and available storage locations.

[0181] The GSS system is an integrated information system that manages all information and work processes throughout the product life cycle from concept design to retirement. The SPM system is a submodule of the GSS system that manages spare parts inventory, procurement, use and scrapping processes.

[0182] c) Connect the SPM system to the Enterprise Resource Planning (ERP) system to obtain inventory data.

[0183] Among them, the ERP system is an integrated management information system used to optimize the internal and external resources of an enterprise to improve operational efficiency. It covers multiple business areas such as production, supply chain, and customer relations.

[0184] d) SPM connects to GSS to obtain maintenance work order information.

[0185] The spare parts classification in step S1120 can be specifically divided into the following processes:

[0186] a) Attribute information:

[0187] i: Storage location acquisition: Obtain available storage locations from the GSS system (including central warehouses, regional warehouses, and service stations) and eliminate redundant data (for example, some service stations have been withdrawn but not cancelled in the system).

[0188] ii: Obtaining the guaranteed PN: By inputting the assembly PN (i.e., assembly part) that needs to be guaranteed, the Product Lifecycle Management (PLM) system is connected to obtain the corresponding after-sales repairable unit under the assembly PN, i.e., the guaranteed PN, as a spare part.

[0189] b) Acquisition of basic dimensions: Basic dimension information is formed according to the central warehouse, regional warehouse, service station, and guarantee PN, and subsequent data analysis is carried out on this dimension.

[0190] c) Spare parts historical consumption demand:

[0191] i: Consumption data acquisition: Connect to the GSS system, flatten the original work order header line structure (mainly based on the work order number, and material consumption data can only be seen after entering the work order), and display the material consumption data as the main information, and the work order number and other information on the same line.

[0192] ii: Consumption data calculation: According to the consumption data obtained, statistics are performed according to the central warehouse, regional warehouse, service station, and guarantee PN dimensions. First, the weekly consumption quantity from the first week to the 52nd week is counted. Based on the consumption quantity of these 52 weeks, the number of demand occurrences (the number of demand occurrences in 52 weeks), the annual total consumption (the total demand quantity in 52 weeks), the average weekly consumption (the average weekly consumption in 52 weeks), the weekly demand standard deviation (the standard deviation of demand in 52 weeks), and the consumption proportion (calculate the consumption proportion of each PN in the warehouse location and material group).

[0193] d) Spare parts market consumption: first arrange the consumption proportions of the above-obtained storage locations, material groups, and material PNs in descending order, and perform sequential cumulative summation based on the descending results. When the cumulative summation exceeds 0.8, mark the PN that is about to exceed 0.8 as A; continue to summation, when the cumulative summation exceeds 0.95, mark the PN that is about to exceed 0.95 (excluding the PN marked as A) as B; mark the remaining PNs as C.

[0194] e) Demand volatility: Divide the weekly demand standard deviation by the weekly average consumption to get the volatility coefficient. A volatility coefficient less than 0.75 is marked as 1, a volatility coefficient greater than or equal to 0.75 and less than 1.5 is marked as 2, and a volatility coefficient greater than or equal to 1.5 is marked as 3.

[0195] f) Classification result summary: The above results of spare parts market consumption and demand volatility are combined to produce 9 results in total: A1, A2, A3, B1, B2, B3, C1, C2, C3. This provides a reference for the construction of spare parts planning. For example, C3 means that the shipment volume is small and the volatility is large, so orders can be accepted for production or procurement.

[0196] The spare parts shipment data in step S1130 can be specifically divided into the following processes:

[0197] a) Obtain the PN information of the shipping assembly in the ERP system and go to the PLM system to obtain the corresponding bill of materials information (such as software bill of materials (SBOM));

[0198] b) Extract the after-sales repairable units and their corresponding standard usage and upper-level standard usage according to the acquired SBOM information, and obtain the shipment quantity of the after-sales repairable units under the shipment assembly by cumulative multiplication;

[0199] c) Then sum up the PN categories to get the shipment volume.

[0200] The spare parts inventory data in step S1140 can be specifically divided into the following processes:

[0201] a) In some regions, spare parts planning can be divided into three levels: central warehouse, regional warehouse and service station. In other regions, spare parts planning is divided into central warehouse and other warehouses (including regional warehouse or service station or both), and their inventory value logic greatly affects the accuracy of spare parts planning;

[0202] b) To achieve timely and accurate inventory data, based on the current business status of after-sales, the data of central warehouses and regional warehouses are obtained from SAP (the bin of service stations must be excluded), and the data of service stations are obtained from GSS. For overseas country-level inventory data, since it involves regional warehouses and service stations, if there are one or more regional warehouses under a country, the regional warehouses are summed; if there are one or more service stations under a country, the service stations are summed; if there are regional warehouses or service stations under a country, the data are summed in the ERP system and GSS respectively;

[0203] c) To ensure the accuracy and timeliness of inventory data and avoid inventory redundancy and waste of resources, inventory data covers three dimensions: new parts, old parts and alternative materials. Each dimension is divided into available inventory, in-transit inventory and inventory to be delivered according to actual conditions (due to the complexity of old parts, inventory to be delivered is not used).

[0204] In an embodiment of the present application, the data scattered in different places required for constructing the spare parts plan are integrated into the same system, so that the required data can be viewed and managed in the same system, the data quality can be standardized, and calculations are performed according to certain rules to obtain the basic data required for generating the spare parts plan, thereby improving the rationality of the spare parts plan.

[0205] The following are device embodiments of the present application, which can be used to execute the method embodiments of the present application. For details not disclosed in the device embodiments of the present application, please refer to the method embodiments of the present application.

[0206] Fig.12 This is a schematic diagram of the structure of the spare parts plan generation device provided in the embodiment of the present application. The spare parts plan generation device can be integrated in an electronic device, or can be independent of the electronic device and cooperate with the electronic device to implement the present solution. Fig.12 As shown, the spare parts plan generating device 1200 may specifically include: a data acquisition module 1210, a data selection module 1220, a result determination module 1230, a shipment quantity determination module 1240, an inventory quantity determination module 1250 and a plan generating module 1260.

[0207] The data acquisition module 1210 is used to acquire the business data of spare parts from different business systems respectively, and aggregate them into basic data.

[0208] The data selection module 1220 is used to determine the available storage locations of spare parts, inventory data in the available storage locations, identification information of spare parts, maintenance work orders for spare parts, shipping information of assemblies containing spare parts, alternative material groups for spare parts and bills of materials for assemblies in the basic data.

[0209] The result determination module 1230 is used to determine the classification result of the spare parts according to the available storage locations, identification information and maintenance work orders.

[0210] The shipment quantity determination module 1240 is used to determine the shipment quantity of the spare parts according to the bill of materials and the shipment information.

[0211] The inventory quantity determination module 1250 is used to determine the inventory quantity of spare parts according to the inventory data and the substitute material group.

[0212] The plan generation module 1260 is used to generate a spare parts plan based on the classification results, shipment volume, inventory volume and supply lead time of spare parts in the basic data.

[0213] Among them, the classification results are used to characterize the market consumption and market demand volatility of spare parts.

[0214] The spare parts plan generation device provided in the embodiment of the present application cleans the aggregated basic data to obtain the market consumption and market demand volatility of spare parts, the shipment volume of spare parts, and the inventory volume of spare parts, thereby realizing the cleaning of the aggregated basic data, thereby quickly obtaining the core data required for formulating the spare parts plan, improving the efficiency of spare parts plan generation, and directly using these core data to generate spare parts plans, thereby avoiding interference from other messy data in the basic data, improving the rationality and accuracy of spare parts plans, and avoiding the occurrence of spare parts backlogs in warehouses, etc. In addition, since the method directly connects with other business systems through the target system and aggregates the basic data, it can also reduce the human cost invested in data acquisition.

[0215] Optionally, in some implementations, a plan generation module is further included, for:

[0216] Determine the supply lead time of spare parts from basic data;

[0217] Generate spare parts plans based on supply lead time, market consumption and market demand volatility, shipments and inventory levels.

[0218] Optionally, in some implementations, the data acquisition module may be specifically used for:

[0219] Acquire first inventory data in available warehouse locations from a first business system, where the available warehouse locations include a central warehouse, a regional warehouse, and a service station;

[0220] Acquire second inventory data, alternative material groups, available storage locations, and maintenance work orders of spare parts at the service station from the second business system;

[0221] Obtain spare parts supply lead time, central warehouse and material group relationship and demand forecast data from the third-party business system.

[0222] Optionally, in some implementations, the result determination module may be specifically used to:

[0223] Determine the historical consumption data of spare parts in each available storage location based on identification information and maintenance work orders;

[0224] Determine spare parts consumption levels and spare parts demand volatility based on historical consumption data;

[0225] Spare parts are categorized based on consumption levels and demand volatility.

[0226] Optionally, in some embodiments, the historical consumption data includes: the consumption of spare parts in each time period, the total number of times the spare parts are required in all time periods, the total consumption of spare parts in all time periods, the average consumption of spare parts in each time period and at least one of the standard deviation of spare parts demand in each time period.

[0227] Optionally, in some implementations, the result determination module may be specifically used to:

[0228] Determine the fluctuation coefficient of spare parts based on the average consumption and demand standard deviation of spare parts in each time period;

[0229] The demand volatility of the spare parts is determined based on the fluctuation coefficient and at least one set limit value.

[0230] Optionally, in some embodiments, a data adjustment module is further included, which is used to adjust the consumption data of spare parts in the maintenance work order to the work order header line of the maintenance work order according to the identification information.

[0231] Optionally, in some implementations, the result determination module may be specifically used to:

[0232] According to the historical consumption data, the consumption ratio of each spare part is obtained, where the consumption ratio includes at least one of the consumption ratio of the spare part in the available storage location and the consumption ratio of the spare part in the material group;

[0233] Sort each spare part in descending order according to the proportion of its consumption;

[0234] According to the arrangement order, at least one spare part is selected from the sorted spare parts, and the sum of the consumption proportions of the selected spare parts is determined;

[0235] The consumption level of each selected spare part is determined based on the relationship between the sum of the consumption proportions and a preset level threshold.

[0236] Optionally, in some implementations, the shipment volume determination module may be specifically used to:

[0237] Determine the amount of spare parts used in the assembly based on the bill of materials;

[0238] Determine the shipment quantity of spare parts based on the shipment information and usage of the assembly parts.

[0239] Optionally, in some implementations, the inventory determination module may be specifically used to:

[0240] Determine the inventory quantity of spare parts according to the inventory data of the service station obtained from the second business system and the inventory data of the central warehouse and the inventory data of the regional warehouse obtained from the first business system;

[0241] The inventory data includes available inventory in stock, available inventory in transit and inventory to be delivered of unused spare parts, available inventory in stock and available inventory in transit of used spare parts, and at least one of available inventory in stock of alternative materials for spare parts, available inventory in transit of alternative materials and inventory to be delivered of alternative materials.

[0242] The device provided in the embodiment of the present application can be used to execute the method in the above embodiment. Its implementation principle and technical effect are similar and will not be repeated here.

[0243] Fig.13 The hardware structure diagram of the electronic device provided in the embodiment of the present application is shown in FIG. Fig.13 As shown, the electronic device 1300 may include a processor 1301 and a memory 1302 storing computer program instructions.

[0244] Specifically, the processor 1301 may include a central processing unit (CPU), or an application specific integrated circuit (ASIC), or may be configured to implement one or more integrated circuits of the embodiments of the present application.

[0245] The memory 1302 may include a large capacity memory for data or instructions. By way of example and not limitation, the memory 1302 may include a hard disk drive (HDD), a floppy disk drive, a flash memory, an optical disk, a magneto-optical disk, a magnetic tape, or a universal serial bus (USB) drive, or a combination of two or more of these.

[0246] Where appropriate, the memory 1302 may include removable or non-removable (or fixed) media. Where appropriate, the memory 1302 may be internal or external to the integrated gateway disaster recovery device. In a specific embodiment, the memory 1302 is a non-volatile solid-state memory.

[0247] The memory 1302 may include a read-only memory (ROM), a random access memory (RAM), a disk storage medium device, an optical storage medium device, a flash memory device, an electrical, optical or other physical / tangible memory storage device. Therefore, generally, the memory 1302 includes one or more tangible (non-transitory) computer-readable storage media (e.g., a memory device) encoded with software including computer executable instructions, and when the software is executed (e.g., by one or more processors), it can perform the operations described in any of the methods in the above embodiments. The processor 1301 implements any of the methods in the above embodiments by reading and executing the computer program instructions stored in the memory 1302.

[0248] In one example, the electronic device 1300 may further include a communication interface 1303 and a bus 1304. Fig.13 As shown, the processor 1301, the memory 1302, and the communication interface 1303 are connected via a bus 1304 and communicate with each other.

[0249] The communication interface 1303 is mainly used to implement communication between various modules, devices, units and / or equipment in the embodiments of the present application.

[0250] Bus 1304 includes hardware, software or both, and couples the components of online data traffic billing equipment to each other. For example, but not limitation, the bus may include accelerated graphics port (AGP) or other graphics bus, enhanced industrial standard architecture (EISA) bus, front-side bus (FSB), hypertransport (HT) interconnection, industrial standard architecture (ISA) bus, infinite bandwidth interconnection, low pin count (LPC) bus, memory bus, micro channel architecture (MCA) bus, peripheral component interconnect (PCI) bus, PCI-Express (PCI-X) bus, serial advanced technology attachment (SATA) bus, video electronics standard association local (VLB) bus or other suitable bus or two or more of these combinations. Where appropriate, bus 1304 may include one or more buses. Although the present application embodiment describes and shows a specific bus, the present application considers any suitable bus or interconnection.

[0251] In addition, in combination with the spare parts plan generation method in the above embodiment, the embodiment of the present application can provide a computer storage medium for implementation. The computer storage medium stores computer program instructions; when the computer program instructions are executed by a processor, any of the spare parts plan generation methods in the above embodiment is implemented.

[0252] It should be clear that the present application is not limited to the specific configuration and processing described above and shown in the figures. For the sake of simplicity, a detailed description of the known method is omitted here. In the above embodiments, several specific steps are described and shown as examples. However, the method process of the present application is not limited to the specific steps described and shown, and those skilled in the art can make various changes, modifications and additions, or change the order between the steps after understanding the spirit of the present application.

[0253] The functional blocks shown in the above structural block diagram can be implemented as hardware, software, firmware or a combination thereof. When implemented in hardware, it can be, for example, an electronic circuit, an application-specific integrated circuit (ASIC), appropriate firmware, a plug-in, a function card, etc. When implemented in software, the elements of the present application are programs or code segments used to perform the required tasks. The program or code segment can be stored in a machine-readable medium, or transmitted on a transmission medium or a communication link by a data signal carried in a carrier. "Machine-readable medium" may include any medium capable of storing or transmitting information. Examples of machine-readable media include electronic circuits, semiconductor memory devices, ROMs, flash memories, erasable ROMs (EROMs), floppy disks, CD-ROMs, optical disks, hard disks, optical fiber media, radio frequency (RF) links, etc. The code segment can be downloaded via a computer network such as the Internet, an intranet, etc.

[0254] It should also be noted that the exemplary embodiments mentioned in this application describe some methods or systems based on a series of steps or devices. However, this application is not limited to the order of the above steps, that is, the steps can be performed in the order mentioned in the embodiment, or in a different order from the embodiment, or several steps can be performed simultaneously.

[0255] Aspects of the present disclosure are described above with reference to the flowcharts and / or block diagrams of the methods and devices (systems) according to the embodiments of the present disclosure. It should be understood that each box in the flowchart and / or block diagram and the combination of each box in the flowchart and / or block diagram can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device to produce a machine so that these instructions executed by the processor of the computer or other programmable data processing device enable the implementation of the functions / actions specified in one or more boxes of the flowchart and / or block diagram. Such a processor can be, but is not limited to, a general-purpose processor, a special-purpose processor, a special application processor, or a field programmable logic circuit. It can also be understood that each box in the block diagram and / or flowchart and the combination of boxes in the block diagram and / or flowchart can also be implemented by dedicated hardware that performs the specified function or action, or can be implemented by a combination of dedicated hardware and computer instructions.

[0256] The above are only specific implementation methods of the present application. Those skilled in the art can clearly understand that for the convenience and simplicity of description, the specific working processes of the systems, modules and units described above can refer to the corresponding processes in the aforementioned method embodiments, and will not be repeated here. It should be understood that the protection scope of the present application is not limited to this. Any technician familiar with the technical field can easily think of various equivalent modifications or replacements within the technical scope disclosed in this application, and these modifications or replacements should be included in the protection scope of this application.

Claims

1. A method for generating a spare parts plan, characterized in that: include: The business data of spare parts are obtained from different business systems respectively, and the basic data are aggregated. The different business systems include spare parts data management group, warehousing and logistics group, spare parts guarantee department and domestic service department. The business data maintained by spare parts data management group is spare parts forecast data, which is used to predict the market demand for spare parts; the business data maintained by warehousing and logistics group is warehouse data, which is used to confirm the inventory of spare parts in the warehouse; the business data maintained by spare parts guarantee department is supply lead time data, which is used to indicate that there is time loss in the actual supply process of spare parts; the business data maintained by domestic service department is maintenance data; Determining, from the basic data, the available storage location of the spare part, the inventory data in the available storage location, the identification information of the spare part, the maintenance work order of the spare part, the shipping information of the assembly part including the spare part, the alternative material group of the spare part, and the bill of materials of the assembly part; Determine, according to the available storage location, the identification information and the maintenance work order, a classification result of the spare parts, wherein the classification result is used to characterize the market consumption and market demand volatility of the spare parts; Determine the shipment quantity of the spare parts according to the bill of materials and the shipment information, wherein the shipment quantity is used to predict future spare parts demand and adjust the spare parts production plan; Determining the inventory quantity of the spare parts according to the inventory data and the alternative material group; A spare parts plan corresponding to the customer's spare parts demand is generated based on the classification results, the shipment volume, the inventory volume and the supply lead time of the spare parts in the basic data. The supply lead time is used to determine the shipment cycle and delivery time of the spare parts.

2. The method according to claim 1, characterized in that The obtaining of the business data of spare parts from different business systems respectively includes: Acquire first inventory data in the available warehouse locations from a first business system, where the available warehouse locations include a central warehouse, a regional warehouse, and a service station; Acquire the second inventory data of the spare part at the service station, the alternative material group, the available storage location and the maintenance work order from the second business system; The supply lead time, the relationship between the central warehouse and the material group, and the demand forecast data are obtained from a third business system.

3. The method according to claim 1, characterized in that Determining the classification result of the spare parts includes: Determining historical consumption data of the spare parts in each of the available storage locations according to the identification information and the maintenance work order; Determining the consumption level of the spare parts and the volatility of demand for the spare parts based on the historical consumption data; A classification result of the spare parts is determined according to the consumption level and the demand volatility.

4. The method according to claim 3, characterized in that The historical consumption data includes: the consumption of the spare parts in each time period, the total number of times the spare parts are required in all time periods, the total consumption of the spare parts in all time periods, the average consumption of the spare parts in each time period and at least one of the standard deviation of the demand for the spare parts in each time period.

5. The method according to claim 3, characterized in that: Determining the volatility of demand for the spare parts according to the historical consumption data includes: Determining the fluctuation coefficient of the spare parts according to the average consumption and demand standard deviation of the spare parts in each time period; The demand volatility of the spare parts is determined according to the fluctuation coefficient and at least one set limit value.

6. The method according to claim 3, characterized in that: Before determining the historical consumption data of the spare parts in each of the available storage locations according to the identification information and the maintenance work order, the method further includes: According to the identification information, the consumption data of the spare parts in the maintenance work order is adjusted to the work order header line of the maintenance work order.

7. The method according to claim 3, characterized in that Determining the consumption level of the spare parts according to the historical consumption data includes: According to the historical consumption data, obtain the consumption proportion of each spare part, where the consumption proportion includes at least one of the consumption proportion of the spare part in the available storage location and the consumption proportion of the spare part in the material group; Sort each spare part in descending order according to the proportion of its consumption; According to the arrangement order, at least one spare part is selected from the sorted spare parts, and the sum of the consumption proportions of the selected spare parts is determined; The consumption level of each selected spare part is determined according to the relationship between the sum of the consumption proportions and a preset level threshold.

8. The method according to any one of claims 1 to 7, characterized in that Determining the shipment quantity of the spare parts according to the bill of materials and the shipment information includes: According to the bill of materials, determining the usage of the spare parts in the assembly; The shipment quantity of the spare parts is determined according to the shipment information of the assembly parts and the usage.

9. The method according to any one of claims 1 to 7, characterized in that: Determining the inventory quantity of the spare parts according to the inventory data and the substitute material group includes: Determine the inventory quantity of the spare parts according to the inventory data of the service station obtained from the second business system and the inventory data of the central warehouse and the inventory data of the regional warehouse obtained from the first business system; The inventory data includes available inventory in stock, available inventory in transit and inventory to be delivered of unused spare parts, available inventory in stock and available inventory in transit of used spare parts, and at least one of available inventory in stock of alternative materials for the spare parts, available inventory in transit of the alternative materials and inventory to be delivered of alternative materials.

10. A spare parts plan generating device, characterized in that: include: The data acquisition module is used to obtain the business data of spare parts from different business systems respectively and aggregate them to form basic data. The different business systems include the spare parts data management group, the warehousing and logistics group, the spare parts guarantee department and the domestic service department. The business data maintained by the spare parts data management group is the spare parts forecast data, which is used to predict the market demand for spare parts; the business data maintained by the warehousing and logistics group is the warehouse data, which is used to confirm the inventory of spare parts in the warehouse; the business data maintained by the spare parts guarantee department is the supply lead time data, which is used to indicate that there is time loss in the actual supply process of spare parts; the business data maintained by the domestic service department is the maintenance data; a data selection module, used to determine, from the basic data, the available storage location of the spare part, the inventory data in the available storage location, the identification information of the spare part, the maintenance work order of the spare part, the shipping information of the assembly part including the spare part, the alternative material group of the spare part and the bill of materials of the assembly part; A result determination module, used to determine the classification result of the spare parts according to the available storage location, the identification information and the maintenance work order, wherein the classification result is used to characterize the market consumption and market demand volatility of the spare parts; A shipment quantity determination module, used to determine the shipment quantity of the spare parts according to the bill of materials and the shipment information, wherein the shipment quantity is used to predict future spare parts demand and adjust the spare parts production plan; An inventory determination module, used to determine the inventory of the spare parts according to the inventory data and the substitute material group; The plan generation module is used to generate a spare parts plan corresponding to the customer's spare parts demand based on the classification results, the shipment volume, the inventory volume and the supply lead time of the spare parts in the basic data, and the supply lead time is used to determine the shipment cycle and delivery time of the spare parts.

11. An electronic device, characterized in that: include: A processor and a memory storing computer program instructions, wherein when the processor executes the computer program instructions, the steps of the method according to any one of claims 1 to 9 are implemented.

12. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 9 are implemented.

Images