Material inventory analysis method, device, equipment and medium

Abstract

The invention provides a material inventory analysis method and device, equipment and a medium. The method comprises the steps that the current inventory amount of materials needed by production equipment, the historical demand amount of the production equipment for the materials and the planned warehouse-out amount of the production equipment for the materials in a to-be-analyzed time period are obtained; acquiring a demand adjustment parameter corresponding to the material in the to-be-analyzed time period; at least based on the historical demand quantity and the demand adjustment parameters, calculating the planned demand quantity of the production equipment for the materials in the to-be-analyzed time period; and calculating the material satisfaction rate of the production equipment for the materials in the to-be-analyzed time period at least according to the current stock amount, the planned warehouse-out amount and the planned demand amount of the materials. By adopting the scheme, the accuracy of demand analysis of the production equipment on the materials can be improved, and stock overstock or shortage is avoided, so that the stock cost and the operation cost are reduced.

Description

Technical Field

[0001] The present application relates to the technical field of inventory management, and in particular to a material inventory analysis method, device, equipment and medium. Background Art

[0002] In factory production, in order to ensure that the materials stored in the warehouse can meet the needs of production equipment for product production, the inventory and demand statistics of the materials needed by the production equipment are generally analyzed to set the purchase point and purchase quantity of the materials. When the inventory is reduced to the purchase point, purchase is made according to the purchase quantity to replenish the inventory in time. For example, the inventory analysis of the spare parts required for the production equipment of milk powder on the milk powder production line is carried out to set the purchase point of the spare parts.

[0003] At present, factories usually rely on static inventory levels and historical average consumption of materials to analyze and set inventory limits / purchase points. However, static inventory levels and historical average consumption of materials are usually fixed values ​​and are not affected by other factors. In actual production, there are many factors that affect material demand. Inventory analysis methods that rely solely on historical data lack flexibility and inaccurate analysis, which may lead to excess or insufficient inventory, increasing inventory holding costs and out-of-stock costs. Summary of the invention

[0004] The present application provides a material inventory analysis method, device, equipment and medium to solve the above-mentioned technical problems in the prior art.

[0005] According to a first aspect of the present application, a material inventory analysis method is provided, the method comprising:

[0006] Obtaining the current inventory of materials required by the production equipment, the historical demand of the production equipment for the materials, and the planned outbound quantity of the materials by the production equipment during the period to be analyzed;

[0007] Obtaining the demand adjustment parameter corresponding to the material in the time period to be analyzed;

[0008] Calculate the planned demand of the material by the production equipment during the period to be analyzed based at least on the historical demand and the demand adjustment parameter;

[0009] The material satisfaction rate of the production equipment for the material in the period to be analyzed is calculated based on at least the current inventory of the material required by the production equipment, the planned delivery quantity of the material by the production equipment in the period to be analyzed, and the planned demand quantity of the material by the production equipment in the period to be analyzed.

[0010] In some embodiments, the demand adjustment parameter includes at least one of a seasonal adjustment factor, a maintenance adjustment factor, and a supply chain adjustment factor;

[0011] The obtaining of the demand adjustment parameter corresponding to the material in the time period to be analyzed includes at least one of the following items:

[0012] Determine the season corresponding to the time period to be analyzed, and determine the seasonal adjustment factor of the material according to the season;

[0013] Obtaining the maintenance demand and regular demand of the material by the production equipment during the period to be analyzed, and calculating the maintenance adjustment factor of the material during the period to be analyzed according to the maintenance demand and the regular demand;

[0014] The planned demand supply and historical supply of the material in the time period to be analyzed are obtained, and the supply chain adjustment factor of the material in the time period to be analyzed is calculated according to the planned demand supply and the historical supply.

[0015] In some implementations, the calculating, based at least on the historical demand and the demand adjustment parameter, the planned demand of the material by the production equipment during the period to be analyzed includes:

[0016] Using an established forecasting model and based on the historical demand, a forecast is performed to obtain a basic demand of the production equipment for the material during the period to be analyzed;

[0017] The basic demand is adjusted using the demand adjustment parameter to obtain the planned demand for the material by the production equipment during the period to be analyzed.

[0018] In some embodiments, the planned outbound quantity of the material by the production equipment in the time period to be analyzed includes the outbound quantity of the material used by the production equipment before the time period to be analyzed and the quantity of the material that has been matched but not outbound by the production equipment in the time period to be analyzed; the material satisfaction rate of the production equipment for the material in the time period to be analyzed is calculated at least based on the current inventory of the material required by the production equipment, the planned outbound quantity of the material by the production equipment in the time period to be analyzed, and the planned demand of the material by the production equipment in the time period to be analyzed, including:

[0019] Obtaining the priority ranking value of each production equipment in the time period to be analyzed;

[0020] Calculate the sum of the planned demand for the material of each production equipment whose priority ranking value is before the current production equipment during the period to be analyzed;

[0021] Based on the current inventory of materials required by the current production equipment, the quantity that has been shipped out, the quantity that has matched the plan but has not been shipped out, the planned demand for the materials by the current production equipment in the time period to be analyzed and the sum of the planned demand, calculate the material satisfaction rate of the current production equipment for the materials in the time period to be analyzed.

[0022] In some embodiments, obtaining the priority ranking value of each production equipment in the time period to be analyzed includes calculating the priority ranking value using the following formula:

[0023]

[0024] Wherein, t represents the time period to be analyzed, is the priority ranking value of the jth production equipment in the time period to be analyzed t, is the demand time of the material for the j-th production equipment in the time period to be analyzed t, is the priority of the j-th production equipment in the time period t to be analyzed.

[0025] In some embodiments, calculating the sum of the planned demand quantities of the material for each production equipment whose priority ranking value is before the current production equipment during the time period to be analyzed includes calculating the sum of the planned demand quantities using the following formula:

[0026]

[0027] Among them, x n is the number of the current production equipment, x i is the priority sort value at x n The number of the previous i-th production equipment, Prio(D(t,x n ,m)) is the priority sort value located at x n The sum of the planned demand for material m by all previous production equipment in the period to be analyzed, D(t,x i ,m) is the device x i The planned demand for material m in the period t to be analyzed;

[0028] The material satisfaction rate of the current production equipment for the material in the period to be analyzed is calculated according to the current inventory of the material required by the current production equipment, the quantity that has been shipped out, the quantity that has matched the plan but has not been shipped out, the planned demand of the material by the current production equipment for the material in the period to be analyzed and the sum of the planned demand, including using the following formula to calculate the material satisfaction rate:

[0029]

[0030] Among them, MFR(t,x n,m) is the current production equipment x n The material satisfaction rate of material m in the time period to be analyzed is Inv(t,m) is the current inventory of material m, Out(t-1,x n ,m) is x n The quantity of material m that has been shipped out at time t-1 before the period to be analyzed, Mt(t,x n ,m) is x n The number of material m that has been matched but not shipped out during the period to be analyzed, D(t,x n ,m) is x n The planned demand for material m during the period t to be analyzed.

[0031] In some embodiments, after calculating the material satisfaction rate of the production equipment for the material in the time period to be analyzed, at least one of the following items is further included:

[0032] Calculate the comprehensive material satisfaction rate of the production equipment for all materials in the period to be analyzed according to the material satisfaction rate of the production equipment for various materials in the period to be analyzed;

[0033] According to the planned demand quantity of the material by the production equipment in multiple time periods to be analyzed within the cycle duration, the cycle material satisfaction rate of the production equipment for the material within the cycle duration is calculated.

[0034] In some embodiments, calculating the periodic material satisfaction rate of the production equipment for the material within the periodic duration according to the planned demand of the production equipment for the material in multiple time periods to be analyzed within the periodic duration includes calculating the periodic material satisfaction rate using the following formula:

[0035]

[0036] Among them, MFR month is the material satisfaction rate of the period, Inv month Out is the current inventory of the material at the time corresponding to the cycle duration; month is the quantity of the material shipped out within the cycle duration, T is the quantity of the material to be analyzed in time period t within the cycle duration, To produce equipment x within the stated cycle time n The sum of the quantities of material m that have been matched but not shipped out, D month It is the total planned demand for the material by the production equipment in multiple time periods to be analyzed within the cycle duration.

[0037] In some embodiments, after obtaining the current inventory of materials required by the production equipment, the historical demand of the production equipment for the materials, and the planned outbound quantity of the materials by the production equipment during the period to be analyzed, the method further includes:

[0038] Obtaining the quantity of the material that has been matched with the plan but not shipped out by the production equipment in the next period of the period to be analyzed;

[0039] Obtaining a demand adjustment parameter corresponding to the next time period of the material after the time period to be analyzed;

[0040] Predicting the planned demand for the material by the production equipment in the next time period based at least on the historical demand and the demand adjustment parameter corresponding to the next time period;

[0041] The material satisfaction rate of the production equipment for the material in the next time period is predicted based on at least the current inventory of the material required by the production equipment, the quantity of the material that has been matched but not shipped out by the production equipment in the next time period, and the planned demand for the material in the next time period.

[0042] In some embodiments, the predicting the material satisfaction rate of the production equipment for the material in the next period based on at least the current inventory of the material required by the production equipment, the quantity of the material that has been matched but not shipped by the production equipment in the next period, and the planned demand for the material in the next period, includes:

[0043] Obtaining the priority ranking value of each production equipment in the next time period;

[0044] Calculate the sum of the planned demand for the material of each production equipment whose priority ranking value is before the current production equipment in the next period;

[0045] Based on the current inventory of materials required by the production equipment, the quantity of materials that have been matched but not shipped out by the production equipment in the next time period, the planned demand for the materials in the next time period and the sum of the planned demand, the material satisfaction rate of the production equipment for the materials in the next time period is predicted.

[0046] In some embodiments, after predicting the material satisfaction rate of the production equipment for the material in the next time period, the method further includes:

[0047] If the material satisfaction rate of the production equipment for the material in the time period to be analyzed is less than the preset target satisfaction rate, or the material satisfaction rate of the production equipment for the material in the next time period is less than the target satisfaction rate, a procurement alarm message is output.

[0048] According to a second aspect of the present application, a material inventory analysis device is provided, comprising:

[0049] A data acquisition module, used to acquire the current inventory of materials required by the production equipment, the historical demand of the production equipment for the materials, and the planned outbound quantity of the materials by the production equipment during the period to be analyzed;

[0050] A parameter acquisition module, used to obtain the demand adjustment parameters corresponding to the material in the period to be analyzed;

[0051] A demand calculation module, used to calculate the planned demand of the material by the production equipment in the time period to be analyzed based at least on the historical demand and the demand adjustment parameter;

[0052] The satisfaction rate calculation module is used to calculate the material satisfaction rate of the production equipment for the material in the period to be analyzed based on at least the current inventory of the material required by the production equipment, the planned delivery quantity of the material by the production equipment in the period to be analyzed, and the planned demand quantity of the material by the production equipment in the period to be analyzed.

[0053] According to a third aspect of the present application, an electronic device is provided, comprising: a processor and a memory storing computer program instructions; when the processor executes the computer program instructions, any one of the above-mentioned material inventory analysis methods is implemented.

[0054] According to a fourth aspect of the present application, a computer-readable storage medium is provided, characterized in that computer program instructions are stored on the computer-readable storage medium, and when the computer program instructions are executed by a processor, any one of the above-mentioned material inventory analysis methods is implemented.

[0055] In summary, the material inventory analysis method, device, electronic device, and computer-readable storage medium provided by the present application have at least the following beneficial effects:

[0056] By introducing the real-time current inventory of materials required by production equipment, analysis based on dynamic inventory can be performed with more accurate data. The planned demand for materials by production equipment can be obtained based on historical demand forecasts and demand adjustment parameters with high accuracy. In this way, the material satisfaction rate for the time period to be analyzed calculated based on the current inventory, planned delivery and planned demand can be more accurate, which can improve the accuracy of the demand analysis for materials by production equipment, avoid excessive inventory or emergency procurement due to inaccurate material demand, avoid inventory backlogs or shortages, and thus reduce inventory costs and operating costs. BRIEF DESCRIPTION OF THE DRAWINGS

[0057] In order to more clearly illustrate the technical solutions of the specific implementation methods of the present application, the drawings required for use in the specific implementation methods will be briefly introduced below in conjunction with the accompanying drawings. It is obvious that the drawings described below are some implementation methods of the present application. For those skilled in the art, other drawings or solutions can be obtained based on these drawings without paying any creative work.

[0058] Figure 1 A flow chart of a material inventory analysis method provided according to an embodiment of the present application;

[0059] Figure 2 A flow chart of a material inventory analysis method provided according to another embodiment of the present application;

[0060] Figure 3 A structural diagram of a material inventory analysis device provided in an embodiment of the present application;

[0061] Figure 4 A structural diagram of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0062] In order to make the above and other features and advantages of the present application more clear, the present application is further described below in conjunction with the accompanying drawings. It should be understood that the specific embodiments given herein are for the purpose of explaining to those skilled in the art and are only exemplary and not restrictive.

[0063] In the following description, many specific details are set forth to provide a thorough understanding of the present application. However, it is apparent to those skilled in the art that specific details need not be adopted to practice the present application. In other cases, well-known steps or operations are not described in detail to avoid blurring the present application.

[0064] During the research and development process, the inventors found that factories usually rely on static inventory levels and historical average consumption of materials to analyze and set inventory limits / purchase points. However, in actual production, the demand for materials by production equipment will be affected by factors such as seasonal fluctuations, market changes or supply chain disruptions. Therefore, this application comprehensively considers the influence of the above factors when calculating the material satisfaction rate to determine a more accurate material demand to avoid inventory backlogs or shortages.

[0065] The material inventory analysis method provided in the embodiment of the present application can be executed by the material inventory analysis device provided in the embodiment of the present application, and the device can be configured in an electronic device.

[0066] refer to Figure 1 A material inventory analysis method provided in the present application includes the following steps S110 to S170.

[0067] S110: Obtain the current inventory of materials required by the production equipment, the historical demand of the production equipment for the materials, and the planned outbound quantity of the materials by the production equipment in the period to be analyzed.

[0068] A production equipment needs one or more materials. Among them, the current inventory of the materials required by the production equipment is the current quantity of the materials stored in the warehouse. Specifically, the current inventory of the materials can be queried in real time from the management system that stores the inventory, so as to obtain the dynamic real-time inventory and grasp the real-time situation of the inventory.

[0069] The period to be analyzed refers to the period of time during which the material inventory needs to be analyzed, such as a certain day of the current month, or a period of the current month. The planned outbound quantity of materials for production equipment in the period to be analyzed refers to the outbound quantity of materials that the production equipment plans to use in the period to be analyzed. Specifically, the historical demand for materials by the production equipment and the planned outbound quantity for the period to be analyzed can be obtained from the recorded data, such as querying the historical demand for one or more time periods from the historical demand records, and querying the planned outbound quantity for the period to be analyzed from the planning data. It can be understood that the historical demand and planned outbound quantity can also be obtained by manual input.

[0070] S130: Obtaining demand adjustment parameters corresponding to the material in the period to be analyzed.

[0071] The demand adjustment parameters are parameters determined based on the influencing factors that affect the material demand of the production equipment, and are used to correct and adjust the material demand. For example, the influencing factors may include seasonal factors, market change factors, and supply chain conditions. Specifically, the demand adjustment parameters can be calculated based on the data related to the influencing factors on the material demand, or they can be set manually.

[0072] S150: Calculate the planned demand for the material by the production equipment in the time period to be analyzed based at least on the historical demand and the demand adjustment parameter.

[0073] Specifically, the basic demand for materials of production equipment in the period to be analyzed can be predicted based on historical demand, and then the basic demand can be adjusted using demand adjustment parameters to obtain the planned demand. When analyzing the demand, the influencing factors corresponding to the demand adjustment parameters can be taken into account, which can improve the accuracy of demand analysis.

[0074] S170: Calculate the material satisfaction rate of the production equipment for the material in the period to be analyzed based on at least the current inventory of the material required by the production equipment, the planned delivery quantity of the material by the production equipment in the period to be analyzed, and the planned demand quantity of the material by the production equipment in the period to be analyzed.

[0075] The material satisfaction rate represents the ability of the inventory materials to meet the material usage requirements. The greater the material satisfaction rate, the greater the ability to meet the material requirements and the more sufficient the inventory materials. The material satisfaction rate of the time period to be analyzed is calculated according to the current inventory, the planned outbound quantity and the planned demand for the time period to be analyzed, so as to realize the material demand analysis of the time period to be analyzed. Specifically, steps S110 to S170 can be performed for each material in the inventory respectively to obtain the material satisfaction rate of each material in the time period to be analyzed.

[0076] Specifically, for various materials required by the same production equipment, steps S110 to S170 are respectively executed to calculate the material satisfaction rate of the production equipment for various materials in the period to be analyzed. For materials required by different production equipment, steps S110 to S170 are respectively executed to obtain the material satisfaction rate of each production equipment for the material in the period to be analyzed.

[0077] The above-mentioned material inventory analysis method introduces the real-time current inventory of materials required by production equipment, thereby performing analysis based on dynamic inventory and making the data more accurate. It obtains the planned demand for materials of production equipment based on historical demand forecasts and the use of demand adjustment parameters, with high accuracy. In this way, the material satisfaction rate for the time period to be analyzed calculated based on the current inventory, planned delivery and planned demand is more accurate, which can improve the accuracy of the demand analysis for materials of production equipment, avoid excessive inventory or emergency procurement due to inaccurate material demand, avoid inventory backlogs or shortages, and thus reduce inventory costs and operating costs.

[0078] In some embodiments, after step S110 and before step S150, the process further includes: performing data preprocessing on the current inventory, historical demand, and planned delivery quantity.

[0079] Specifically, data preprocessing operations include data cleaning, denoising and normalization. By preprocessing the acquired data, the quality and consistency of the data can be ensured, the data accuracy can be improved, and the accuracy of material demand analysis can be further improved.

[0080] In some embodiments, the demand adjustment parameter includes at least one of a seasonal adjustment factor, a maintenance adjustment factor, and a supply chain adjustment factor. The seasonal adjustment factor is a parameter that takes into account the effect of season on the material demand of production equipment, the maintenance adjustment factor is a parameter that takes into account the effect of maintenance of production equipment on the material demand, and the supply chain adjustment factor is a parameter that takes into account the effect of the material supply chain on the material demand.

[0081] Specifically, step S130 includes at least one corresponding item in the following steps (a1) to (a3). For example, in an embodiment where the demand adjustment parameter includes a seasonal adjustment factor, step S130 includes step (a1), in an embodiment where the demand adjustment parameter includes a maintenance adjustment factor, step S130 includes step (a2), in an embodiment where the demand adjustment parameter includes a supply chain adjustment factor, step S130 includes step (a3), and in an embodiment where the demand adjustment parameter includes a seasonal adjustment factor, a maintenance adjustment factor, and a supply chain adjustment factor, step S130 includes steps (a1) to (a3).

[0082] Step (a1): Determine the season corresponding to the time period to be analyzed, and determine the seasonal adjustment factor of the material based on the season.

[0083] Specifically, the time period to be analyzed is a time that does not exceed the seasonal unit, such as a certain day or a certain month. The month to which the time period to be analyzed belongs is determined, and the season corresponding to the month is determined. For example, April to September is spring and summer, October to December and January to March are autumn and winter. If the time period to be analyzed is May or a certain day in May, it belongs to spring and summer, and the seasonal adjustment factor corresponding to spring and summer is determined.

[0084] Specifically, determining the seasonal adjustment factor of a material according to the season may include: calculating the seasonal adjustment factor according to the seasonal index corresponding to the season. Further, it can be calculated according to the formula: SAF = (1 + seasonal index) / 1, where SAF is the seasonal adjustment factor. Among them, the seasonal index can be obtained through seasonal analysis of historical data. For example, if the summer demand is 20% higher than the average level, the seasonal index for spring and summer is 0.2. It can be understood that the seasonal index can also be set manually according to the amount of materials used by production equipment in each season. Taking the spare parts of the production equipment on the milk powder production line as an example, through the seasonal analysis of historical data, it can be obtained that the seasonal index for spring and summer can be set to 0.2, and the seasonal index for autumn and winter can be set to 0. By calculating the seasonal adjustment factor and taking the seasonal factors into account to calculate the planned demand, the accuracy of the planned demand can be improved.

[0085] Step (a2): Obtain the maintenance demand and regular demand of the material of the production equipment during the period to be analyzed, and calculate the maintenance adjustment factor of the material during the period to be analyzed based on the maintenance demand and the regular demand.

[0086] Maintenance demand refers to the demand for materials when there is a maintenance plan for production equipment, and regular demand refers to the demand for materials when there is no maintenance plan for production equipment. Specifically, the maintenance plan of the production equipment can be searched to obtain the maintenance demand and regular demand from the maintenance plan, or the maintenance demand and regular demand input manually can be received.

[0087] Specifically, the quotient of the maintenance demand and the conventional demand can be calculated to obtain the maintenance adjustment factor, and the calculation formula is: MPAF = maintenance demand / conventional demand, where MPAF is the maintenance adjustment factor. By calculating the maintenance adjustment factor, the maintenance factor is taken into account to calculate the planned demand, which can improve the accuracy of the planned demand.

[0088] Step (a3): Obtain the planned demand supply and historical supply of the material in the period to be analyzed, and calculate the supply chain adjustment factor of the material in the period to be analyzed based on the planned demand supply and historical supply.

[0089] The planned demand supply is the planned purchase quantity of materials that the supplier needs to provide, which can be recorded in the purchase plan and extracted from the purchase plan. The historical supply can be equal to the average of the historical supply quantity of the supplier. Specifically, the quotient of the planned demand supply and the historical supply can be calculated to obtain the supply chain adjustment factor. The calculation formula is: SCF = planned demand supply / historical supply, SCF is the supply chain adjustment factor. By calculating the supply chain adjustment factor, the historical supply stability and potential risks of the supply chain are taken into account to calculate the planned demand, which can improve the accuracy of the planned demand.

[0090] For example, seasonal adjustment factors, maintenance adjustment factors, and supply chain adjustment factors are shown in Table 1. The supply chain adjustment factors shown in Table 1 are greater than 1. It can be understood that in other embodiments, the supply chain adjustment factors may also be less than or equal to 1, and are calculated based on the planned demand supply and historical supply during the period to be analyzed.

[0091] Table 1

[0092]

[0093]

[0094] In some embodiments, step S150 includes: using an established forecasting model to make forecasts based on historical demand to obtain the basic demand of the production equipment for materials in the time period to be analyzed; using demand adjustment parameters to adjust the basic demand to obtain the planned demand of the production equipment for materials in the time period to be analyzed.

[0095] By adopting the forecasting model, the basic demand can be predicted based on the historical demand, and then the basic demand can be adjusted to obtain the planned demand. Specifically, the forecasting model can use the time series analysis model (ARIMA model). The formula for the forecasting model based on historical demand is: P(t,x n ,m)=ARIMA(d i-1 , D i-2 , …D i-p ).

[0096] Among them, P(t,x n ,m) is the production equipment x n The basic demand quantity for material m in the period t to be analyzed, D i-1 is the first historical demand, D i-2 is the second historical demand, D i-p is the pth historical demand; the specific number of historical demands to be used can be set according to actual needs.

[0097] Furthermore, the accuracy of calculating the material satisfaction rate can be improved by acquiring inventory data from the management system in real time, collecting and analyzing data, and selecting an appropriate prediction algorithm to optimize the prediction model. For example, the prediction algorithm includes a regression analysis algorithm, a machine learning method, and the like.

[0098] In an embodiment where the demand adjustment parameters include a seasonal adjustment factor, a maintenance adjustment factor, and a supply chain adjustment factor, the step of using the demand adjustment parameters to adjust the basic demand to obtain the planned demand for materials by the production equipment in the time period to be analyzed includes: calculating the product of the basic demand, the seasonal adjustment factor, the maintenance adjustment factor, and the supply chain adjustment factor to obtain the planned demand for materials by the production equipment in the time period to be analyzed.

[0099] Specifically, the calculation formula for the planned demand is: D(t,x n ,m)=P(t,x n ,m)*SAF*MPAF*SCF,D(t,x n ,m) is the planned demand. By combining the seasonal adjustment factor, maintenance adjustment factor and supply chain adjustment factor to adjust the basic demand, seasonal factors, maintenance factors and supply chain factors are taken into account, and the planned demand is highly accurate.

[0100] For example, suppose the historical demand data of production equipment for material A is as follows (unit: piece):

[0101] January: 80, February: 70, March: 90, April: 80, May: 70, June: 90, July: 80, August: 70, September: 90, October: 80, November: 70, December: 100.

[0102] The ARIMA model is used to predict the basic demand for the next month (January), and the basic demand is 85. The seasonal index analysis shows that the seasonal index for January is 0, so SAF = 1.0. The maintenance plan shows that there is a large maintenance in January, and the maintenance demand increases by 10% compared with the regular demand, so MPAF = 1.1. Supply chain analysis shows that due to the stable production capacity of suppliers, the planned demand supply is basically the same as the historical supply, SCF = 1.0. Planned demand = 85*1.0*1.1*1.0 = 93.5. Therefore, the planned demand for material A by production equipment in January is about 94 units. It can be understood that if it is necessary to analyze the planned demand for materials by production equipment every day in January, the historical demand for materials by production equipment every day in a historical month can be collected, and the historical demand for multiple days can be used to predict the basic demand for the current month.

[0103] In some embodiments, the planned outbound quantity of materials by the production equipment in the time period to be analyzed includes: the outbound quantity of materials used by the production equipment in the previous time period to be analyzed and the quantity of materials that have been matched but not outbound by the production equipment in the time period to be analyzed. Among them, the outbound quantity of materials used by the production equipment in the previous time period to be analyzed refers to the quantity of materials that have been outbound due to the use of materials by the production equipment in the previous time period to be analyzed. The quantity of materials that have been matched but not outbound by the production equipment in the time period to be analyzed can be obtained from the plan table for matching materials of the production equipment.

[0104] Specifically, step S170 includes steps (b1) to (b3).

[0105] Step (b1): Obtain the priority ranking value of each production equipment in the time period to be analyzed.

[0106] The priority ranking value reflects the priority of meeting the material requirements of the production equipment. Specifically, the production equipment can be prioritized according to the priority ranking value. The higher the ranking, the higher the priority of meeting the material requirements.

[0107] Step (b2): Calculate the sum of the planned material requirements of each production equipment whose priority value is before the current production equipment during the period to be analyzed.

[0108] The current production equipment refers to the production equipment currently analyzing the material satisfaction rate. For example, the current production equipment is x n , sorted by priority value, the production equipment with priority values ​​before the current production equipment are x1, x2, ..., x n-1 Specifically, through steps S110 to S170, production equipment x1, x2, ..., xn-1 The planned demand for materials in the period to be analyzed is then summed up to obtain the total planned demand.

[0109] Step (b3): ​​Calculate the material satisfaction rate of the current production equipment for the material in the period to be analyzed based on the current inventory of the materials required by the current production equipment, the quantity that has been shipped out, the quantity that has matched the plan but has not been shipped out, the planned demand for the materials by the current production equipment in the period to be analyzed and the sum of the planned demand.

[0110] By finding the priority values ​​for the production equipment, calculating the sum of the planned demand quantities based on the priority values ​​and calculating the material fulfillment rate, the accuracy of the material fulfillment rate can be improved.

[0111] In some embodiments, step (b1) comprises calculating the priority value using the following formula:

[0112]

[0113] Where t represents the period to be analyzed, is the priority ranking value of the jth production equipment in the time period to be analyzed t, is the demand time of the material for the j-th production equipment in the time period to be analyzed t, is the priority of the jth production equipment in the time period to be analyzed t. The priorities of various types of materials can be preset.

[0114] The priority value of the production equipment is calculated by taking the natural logarithm of the demand time and priority of the production equipment. The smaller the priority value, the higher the production equipment is ranked and the higher the priority of its demand for materials is met. The real-time inventory of materials is matched first to the production equipment with earlier demand time and higher priority.

[0115] In some embodiments, step (b2) includes calculating the sum of the planned demand using the following formula:

[0116]

[0117] Among them, x n is the number of the current production equipment, x i is the priority sort value at x n The number of the previous i-th production equipment, Prio(D(t,x n ,m)) is the priority sort value located at x n The sum of the planned demand for material m by all previous production equipment in the period to be analyzed, D(t,x i ,m) is the device x i The planned demand for material m during the period t to be analyzed.

[0118] Specifically, step (b3) includes calculating the material satisfaction rate using the following formula:

[0119]

[0120] Among them, MFR(t,x n ,m) is the current production equipment x n The material satisfaction rate of material m in the time period to be analyzed is Inv(t,m) is the current inventory of material m, Out(t-1,x n ,m) is x n The quantity of material m that has been shipped out at time t-1 before the period to be analyzed, Mt(t,x n ,m) is x n The number of material m that has been matched but not shipped out during the period to be analyzed, D(t,x n ,m) is x n The planned demand for material m during the period t to be analyzed.

[0121] The material satisfaction rate calculated by the above formula can effectively reflect the ability of the inventory materials to meet the needs of production equipment. Based on this material satisfaction rate, the procurement plan can be optimized. Specifically, when MFR(t,x n ,m) meets the set target satisfaction rate, the device x n Specifically, if the period to be analyzed is a certain month, the above formula can be used to calculate the material satisfaction rate of the production equipment for material m in that month. If the period to be analyzed is the same day of the month, the above formula can be used to calculate the material satisfaction rate of the production equipment every day.

[0122] In some embodiments, reference Figure 2 , step S170 also includes at least one of step S180 and step S190.

[0123] S180: Calculate the comprehensive material satisfaction rate of the production equipment for all materials in the period to be analyzed based on the material satisfaction rate of the production equipment for various materials in the period to be analyzed.

[0124] Specifically, for different materials required by the production equipment, through steps S110 to S170, the material satisfaction rate of the production equipment for various materials in the period to be analyzed can be obtained, and the comprehensive material satisfaction rate can be specifically the average value of the material satisfaction rate of the production equipment for various materials in the period to be analyzed. By calculating the comprehensive material satisfaction rate, it can help understand the satisfaction of the overall material demand of all materials by the production equipment.

[0125] For example, step S180 may use the following formula to calculate the comprehensive material satisfaction rate:

[0126]

[0127] Among them, B1 is the production equipment x n The comprehensive material satisfaction rate for all materials in the time period to be analyzed t, p is equal to the total number of materials, m is the material number.

[0128] S190: Calculate a periodic material satisfaction rate of the production equipment for the material within the period length based on at least the planned demand for the material by the production equipment in multiple time periods to be analyzed within the period length.

[0129] Specifically, for different time periods to be analyzed, through steps S110 to S150, the planned demand in each time period to be analyzed can be obtained, and the cycle material satisfaction rate can be further calculated. By calculating the cycle material satisfaction rate, it can help understand the overall satisfaction rate of the production equipment for material demand within a cycle.

[0130] Specifically, step S190 calculates the periodic material satisfaction rate according to the following formula:

[0131]

[0132] Among them, MFR month is the period material satisfaction rate, Inv month To achieve the current inventory of materials at the time corresponding to the cycle length; Out month is the quantity of materials shipped out within the cycle time, T is the quantity of materials to be analyzed in time period t within the cycle time, Production equipment x in cycle time n The sum of the quantities of material m that have been matched but not shipped out, D month It is the total planned demand for materials by the production equipment in multiple time periods to be analyzed within the cycle time.

[0133] Advantageously, the comprehensive material satisfaction rate and the cycle material satisfaction rate can be used to assist in evaluating whether the procurement plan is effective. For example, the cycle material satisfaction rate / comprehensive material satisfaction rate in different time periods can be calculated and compared. If the comprehensive material satisfaction rate / cycle material satisfaction rate increases, it indicates that the procurement plan is successful and effective. If it decreases, the procurement plan needs to be further adjusted. In addition, by horizontally comparing the comprehensive material satisfaction rate / cycle material satisfaction rate of different factories, the ability of each factory in material management can be objectively reflected. For factories with high comprehensive material satisfaction rate / cycle material satisfaction rate and high material management level, more production tasks can be assigned to improve overall production efficiency and satisfaction rate. At the same time, through comparison between factories, competition between factories can be stimulated, and each factory can be encouraged to learn from good factories, continuously improve, continuously optimize procurement plans and strategies, and improve material management level.

[0134] In some embodiments, reference Figure 2 , step S110 also includes steps S210 to S270.

[0135] S210: Obtain the quantity of materials that have been matched with the plan but not shipped out by the production equipment in the next period of the period to be analyzed.

[0136] S230: Obtaining the demand adjustment parameter corresponding to the next time period of the material after the time period to be analyzed.

[0137] Specifically, the implementation method of obtaining the demand adjustment parameters for the next time period may be the same as the implementation method of obtaining the demand adjustment parameters for the time period to be analyzed, which will not be described in detail here.

[0138] S250: Predicting the planned demand for materials by the production equipment in the next time period based at least on the historical demand and the demand adjustment parameter corresponding to the next time period.

[0139] Specifically, a forecasting model can be used to forecast based on historical demand to obtain a basic demand, and the demand adjustment parameters for the next period can be used to adjust the basic demand to obtain a planned demand for the next period. The implementation method of adjusting the basic demand using the demand adjustment parameters for the next period is the same as the method of adjusting the basic demand using the demand adjustment parameters for the period to be analyzed, which will not be described in detail here.

[0140] Furthermore, the historical demand used to predict the basic demand for the next period can be the same as the historical demand used to predict the basic demand for the period to be analyzed, or data can be added to the historical demand used to predict the basic demand for the period to be analyzed. For example, the historical demand used to predict the basic demand for the period to be analyzed and the planned demand for the period to be analyzed can be used as new historical demand, and the basic demand for the next period can be predicted based on the new historical demand.

[0141] S270: Predict the material satisfaction rate of the production equipment for the materials in the next period based on at least the current inventory of the materials required by the production equipment, the quantity of the materials that have been matched but not shipped out by the production equipment in the next period, and the planned demand for the materials in the next period.

[0142] Among them, step S210 may also include: obtaining the updated current inventory of the material, so as to predict the material satisfaction rate of the next period based on the real-time updated current inventory. Specifically, the updated current inventory is the inventory after deducting the actual outbound quantity of the period to be analyzed from the original inventory. By predicting the material satisfaction rate of the production equipment for the material in the next period, the forward-looking prediction of material demand is achieved, and the prediction of future material demand is helpful to make procurement preparations in advance.

[0143] In some embodiments, step S270 includes steps (c1) to (c3).

[0144] Step (c1): Obtain the priority ranking value of each production equipment in the next time period.

[0145] Specifically, the implementation method of step (c1) is the same as that of step (b1), which will not be described in detail here.

[0146] Step (c2): Calculate the sum of the planned material requirements for the next period of time for each production equipment whose priority value is before the current production equipment.

[0147] The implementation method of step (c2) is the same as that of step (c2), and will not be repeated here.

[0148] Step (c3): Based on the current inventory of materials required by the production equipment, the number of materials that have been matched but not shipped out by the production equipment in the next period, the planned demand for materials in the next period, and the sum of the planned demand, predict the material satisfaction rate of the production equipment in the next period.

[0149] By finding the priority values ​​for the production equipment, calculating the sum of the planned demand quantities based on the priority values ​​and calculating the material fulfillment rate, the accuracy of the material fulfillment rate for the next period can be improved.

[0150] Specifically, step (c3) includes calculating the material satisfaction rate of the production equipment for the material in the next period using the following formula:

[0151]

[0152] Among them, MFR(N,x n ,m) is the production equipment x n The material satisfaction rate of material m in the next period N is I m is the current inventory of material m required by the production equipment in the next period, Mt(N,x i ,m) is the production equipment x n The number of material m that has been matched but not shipped out in the next period N, Prio N (D(N,x n ,m)) is the sum of the planned material requirements of the production equipment with a priority value before the current production equipment in the next period, D(N,x n ,m) is the production equipment x n The planned demand for material m in the next period N.

[0153] The material satisfaction rate calculated by the above formula can effectively reflect the ability of inventory materials to meet the needs of production equipment. Based on this material satisfaction rate, the procurement plan can be optimized.

[0154] In some embodiments, continue to refer to Figure 2 , step S270 also includes step S280 and step S290.

[0155] S280: Calculate the comprehensive material satisfaction rate of the production equipment for all materials in the next period based on the material satisfaction rate of the production equipment for various materials in the next period.

[0156] Specifically, for different materials required by the production equipment, through steps S210 to S270, the material satisfaction rate of the production equipment for various materials in the next period can be obtained. Specifically, the comprehensive material satisfaction rate of the next period can be calculated using the following formula:

[0157]

[0158] Among them, B2 is the comprehensive material satisfaction rate in the next period.

[0159] S290: Calculate a periodic material satisfaction rate of the production equipment for the material within the period length according to at least the planned demand quantities of the production equipment for the material in multiple time periods to be analyzed within the period length.

[0160] Specifically, for different next periods of the next cycle, through steps S110 to S150, the planned demand in each next period can be obtained, and the cycle material satisfaction rate can be further calculated. Specifically, the calculation method of step S290 is the same as the calculation method of step S190, which will not be repeated here.

[0161] Furthermore, after step S290, it may also include: comparing the comprehensive material satisfaction rate / cycle material satisfaction rate of different time periods before and after, and generating an evaluation result of whether the procurement plan is effective according to the change of the comprehensive material satisfaction rate / cycle material satisfaction rate. If the comprehensive material satisfaction rate / cycle material satisfaction rate of the latter time period is greater than the comprehensive material satisfaction rate / cycle material satisfaction rate of the previous time period, that is, the comprehensive material satisfaction rate / cycle material satisfaction rate is improved, then an evaluation result of the effectiveness of the procurement plan is generated; if the comprehensive material satisfaction rate / cycle material satisfaction rate of the latter time period is less than the comprehensive material satisfaction rate / cycle material satisfaction rate of the previous time period, that is, the comprehensive material satisfaction rate / cycle material satisfaction rate is reduced, then an evaluation result of the procurement plan to be adjusted is generated. In this way, a reasonable evaluation of the procurement plan is helpful to optimize the procurement plan and improve the level of material management.

[0162] In some embodiments, after step S170 and step S270, it also includes: if the material satisfaction rate of the material in the time period to be analyzed is less than the preset target satisfaction rate, or the material satisfaction rate of the material in the next time period is less than the target satisfaction rate, then outputting a procurement alarm message.

[0163] Among them, the target satisfaction rate can be set according to actual needs, such as 95%. The procurement alarm information is information used to remind procurement, which can be information for display output on a display screen, or information output in other forms such as a voice alarm and an alarm light. If either the material satisfaction rate of the time period to be analyzed or the material satisfaction rate of the next time period is less than the target satisfaction rate, an early warning is triggered and a procurement alarm information is output so that the staff can arrange corresponding procurement activities. Specifically, when the material satisfaction rate of the time period to be analyzed and the material satisfaction rate of the next time period are greater than the target satisfaction rate, the information of the material can be transferred to the stagnant material for early warning, and early warning can be issued according to the maintenance cycle. In this way, based on the calculated material satisfaction rate, an early warning system is established, which can help staff identify potential material shortage risks in advance, take procurement measures in time, and reduce the risk of out-of-stock.

[0164] In some embodiments, after outputting the procurement alarm information, the method may further include: adjusting the procurement plan according to the materials corresponding to the material satisfaction rate that is less than the target satisfaction rate.

[0165] Specifically, the purchase quantity and advance purchase time of materials corresponding to material satisfaction rates lower than the target satisfaction rate can be increased in the original purchase plan. In this way, adjusting the purchase plan according to the purchase alarm information helps to prepare materials with lower material satisfaction rates in advance. Furthermore, the target satisfaction rate can be dynamically adjusted according to historical data and changes in equipment maintenance to adapt to the ever-changing business environment.

[0166] According to the present application, a material inventory analysis device is provided, such as Figure 3 As shown, the device includes a data acquisition module 310 , a parameter acquisition module 330 , a demand quantity calculation module 350 and a satisfaction rate calculation module 370 .

[0167] The data acquisition module 310 is used to obtain the current inventory of materials required by the production equipment, the historical demand for materials by the production equipment, and the planned outbound quantity of materials by the production equipment in the period to be analyzed. The parameter acquisition module 330 is used to obtain the demand adjustment parameters corresponding to the materials in the period to be analyzed. The demand calculation module 350 is used to calculate the planned demand for materials by the production equipment in the period to be analyzed based on at least the historical demand and the demand adjustment parameters. The satisfaction rate calculation module 370 is used to calculate the material satisfaction rate of the production equipment for the materials in the period to be analyzed based on at least the current inventory of materials required by the production equipment, the planned outbound quantity of materials by the production equipment in the period to be analyzed, and the planned demand for materials by the production equipment in the period to be analyzed.

[0168] The above-mentioned material inventory analysis device introduces the real-time current inventory of materials, thereby performing analysis based on dynamic inventory and making the data more accurate. It obtains the planned demand based on historical demand forecasts and the use of demand adjustment parameters, and has high accuracy. In this way, the material satisfaction rate for the time period to be analyzed calculated based on the current inventory, planned delivery and planned demand is more accurate, which can improve the accuracy of the demand analysis of production equipment for materials, avoid excessive inventory or emergency procurement due to inaccurate material demand, avoid inventory backlogs or shortages, and thus reduce inventory costs and operating costs.

[0169] In some embodiments, the material inventory analysis device further includes a data preprocessing module for preprocessing the current inventory, historical demand, and planned delivery. Specifically, the data preprocessing operations include data cleaning, denoising, and normalization.

[0170] In some embodiments, the demand adjustment parameter includes at least one of a seasonal adjustment factor, a maintenance adjustment factor, and a supply chain adjustment factor; the parameter acquisition module 330 includes at least one of a first unit, a second unit, and a third unit. In an embodiment where the demand adjustment parameter includes a seasonal adjustment factor, the parameter acquisition module 330 includes a first unit, in an embodiment where the demand adjustment parameter includes a maintenance adjustment factor, the parameter acquisition module 330 includes a second unit, in an embodiment where the demand adjustment parameter includes a supply chain adjustment factor, the parameter acquisition module 330 includes a third unit, and in an embodiment where the demand adjustment parameter includes a seasonal adjustment factor, a maintenance adjustment factor, and a supply chain adjustment factor, the parameter acquisition module 330 includes a first unit, a second unit, and a third unit.

[0171] The first unit is used to determine the season corresponding to the period to be analyzed, and determine the seasonal adjustment factor of the material according to the season. The second unit is used to obtain the maintenance demand and regular demand of the material for the production equipment during the period to be analyzed, and calculate the maintenance adjustment factor of the material during the period to be analyzed based on the maintenance demand and regular demand. The third unit is used to obtain the planned demand supply and historical supply of the material during the period to be analyzed, and calculate the supply chain adjustment factor of the period to be analyzed based on the planned demand supply and historical supply.

[0172] In some embodiments, the demand calculation module 350 includes a basic demand calculation unit and a planned demand calculation unit. The basic demand calculation unit uses an established forecasting model to make forecasts based on historical demand to obtain the basic demand of the production equipment for the material in the period to be analyzed. The planned demand calculation unit is used to adjust the basic demand using demand adjustment parameters to obtain the planned demand of the production equipment for the material in the period to be analyzed.

[0173] Specifically, the forecasting model may use a time series analysis model (ARIMA model).

[0174] In an embodiment where the demand adjustment parameters include a seasonal adjustment factor, a maintenance adjustment factor, and a supply chain adjustment factor, the planned demand quantity calculation unit calculates the planned demand quantity using the following formula:

[0175] D(t,x n ,m)=P(t,x n ,m)*SAF*MPAF*SCF

[0176] Among them, D(t,x n ,m) is the planned demand.

[0177] In some embodiments, the planned outbound quantity of materials for production equipment in the time period to be analyzed includes: the outbound quantity of materials used by the production equipment in the time before the time period to be analyzed and the quantity of materials that have been matched but not outbound for the production equipment in the time period to be analyzed. The satisfaction rate calculation module 370 is used to: obtain the priority ranking value of each production equipment in the time period to be analyzed; calculate the sum of the planned demand for materials for each production equipment whose priority ranking value is before the current production equipment in the time period to be analyzed; calculate the material satisfaction rate of the current production equipment in the time period to be analyzed based on the current inventory of the materials required by the current production equipment, the outbound quantity, the matched plan but not outbound quantity, the planned demand for materials of the current production equipment in the time period to be analyzed and the sum of the planned demand.

[0178] Specifically, the satisfaction rate calculation module 370 calculates the material satisfaction rate according to the following formula:

[0179]

[0180] In some embodiments, the above-mentioned material inventory analysis device also includes a comprehensive analysis module, which is used to calculate the comprehensive material satisfaction rate of the production equipment for all materials in the period to be analyzed based on the material satisfaction rate of the production equipment for various materials in the period to be analyzed; at least based on the planned demand for materials of the production equipment in multiple periods to be analyzed within the cycle duration, calculate the cycle material satisfaction rate of the production equipment for materials within the cycle duration.

[0181] In some embodiments, the data acquisition module 310 is also used to obtain the number of materials that have been matched but not shipped out by the production equipment in the next period of the period to be analyzed, and further, the updated current inventory of the materials can also be obtained; the parameter acquisition module 330 is also used to obtain the demand adjustment parameters corresponding to the material in the next period after the period to be analyzed; the demand calculation module 350 is also used to predict the planned demand for materials by the production equipment in the next period based on at least the historical demand and the demand adjustment parameters corresponding to the next period; the above-mentioned material inventory analysis device also includes a prediction module, which is used to predict the material satisfaction rate of the production equipment for the material in the next period based on at least the current inventory of the materials required by the production equipment, the number of materials that have been matched but not shipped out by the production equipment in the next period, and the planned demand for the materials in the next period.

[0182] In some embodiments, the prediction module is used to obtain the priority value of each production equipment in the next time period; calculate the sum of the planned material requirements of each production equipment whose priority value is before the current production equipment in the next time period; and predict the material satisfaction rate of the production equipment in the next time period based on the current inventory of materials required by the production equipment, the number of materials that have been matched but not shipped out by the production equipment in the next time period, the planned material requirements in the next time period, and the sum of the planned requirements.

[0183] In some embodiments, the comprehensive analysis module is also used to calculate the comprehensive material satisfaction rate of the production equipment for all materials in the next time period based on the material satisfaction rate of the production equipment for various materials in the next time period; and calculate the cycle material satisfaction rate of the production equipment for materials within the cycle duration at least based on the planned demand for materials of the production equipment in multiple time periods to be analyzed within the cycle duration.

[0184] In some embodiments, the material inventory analysis device further includes an early warning module for outputting a procurement alarm message when the material satisfaction rate of the material in the time period to be analyzed is less than a preset target satisfaction rate, or the material satisfaction rate of the material in the next time period is less than the target satisfaction rate.

[0185] In some embodiments, the material inventory analysis device further includes a procurement adjustment module for adjusting the procurement plan according to materials corresponding to material satisfaction rates that are less than the target satisfaction rate after the early warning module outputs procurement alarm information.

[0186] It should be understood that the specific features, operations and details described hereinabove with respect to the method of the present application may also be similarly applied to the device of the present application, or vice versa. In addition, each step of the method of the present application described above may be performed by the corresponding components or units of the device of the present application.

[0187] It should be understood that each module / unit of the device of the present application can be implemented in whole or in part by software, hardware, firmware or a combination thereof. Each module / unit can be embedded in the processor of the electronic device or independent of the processor in the form of hardware or firmware, or can be stored in the memory of the electronic device in the form of software for the processor to call to perform the operation of each module / unit. Each module / unit can be implemented as an independent component or module, or two or more modules / units can be implemented as a single component or module.

[0188] like Figure 4 As shown, the present application provides an electronic device 400, which includes a processor 401 and a memory 402 storing computer program instructions. When the processor 401 executes the computer program instructions, each step of the above-mentioned material inventory analysis method is implemented. The electronic device 400 can be generally a server, a terminal, or any other electronic device with necessary computing and / or processing capabilities.

[0189] In one embodiment, the electronic device 400 may include a processor, a memory, a network interface, a communication interface, etc. connected through a system bus. The processor of the electronic device 400 may be used to provide necessary computing, processing and / or control capabilities. The memory of the electronic device 400 may include a non-volatile storage medium and an internal memory. The non-volatile storage medium may store an operating system, a computer program, etc. The internal memory may provide an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The network interface and the communication interface of the electronic device 400 may be used to connect and communicate with external devices through a network. When the computer program is executed by the processor, the steps of the method of the present application are executed.

[0190] In addition, the present application provides a computer-readable storage medium, on which computer program instructions are stored. When the computer program instructions are executed by a processor, the above-mentioned material inventory analysis method is implemented.

[0191] Those skilled in the art will appreciate that the method steps of the present application can be completed by instructing related hardware such as the electronic device 400 or a processor through a computer program, and the computer program can be stored in a non-temporary computer-readable storage medium, and the computer program causes the steps of the present application to be executed when it is executed. Depending on the circumstances, any reference to memory, storage, or other media herein may include non-volatile or volatile memory. Examples of non-volatile memory include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM), flash memory, magnetic tape, floppy disk, magneto-optical data storage device, optical data storage device, hard disk, solid state disk, etc. Examples of volatile memory include random access memory (RAM), external cache memory, etc.

[0192] The various technical features described above can be combined arbitrarily. Although all possible combinations of these technical features are not described, any combination of these technical features should be considered to be covered by this specification as long as there is no contradiction in such combination.

[0193] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present application, rather than to limit it. Although the present application has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or replace some or all of the technical features therein by equivalents. However, these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present application.

Claims

1. A material inventory analysis method, characterized in that: include: Obtaining the current inventory of materials required by the production equipment, the historical demand of the production equipment for the materials, and the planned outbound quantity of the materials by the production equipment during the period to be analyzed; Obtaining the demand adjustment parameter corresponding to the material in the time period to be analyzed; Calculate the planned demand of the material by the production equipment during the period to be analyzed based at least on the historical demand and the demand adjustment parameter; The material satisfaction rate of the production equipment for the material in the period to be analyzed is calculated based on at least the current inventory of the material required by the production equipment, the planned delivery quantity of the material by the production equipment in the period to be analyzed, and the planned demand quantity of the material by the production equipment in the period to be analyzed.

2. The method according to claim 1, characterized in that The demand adjustment parameter includes at least one of a seasonal adjustment factor, a maintenance adjustment factor, and a supply chain adjustment factor; The obtaining of the demand adjustment parameter corresponding to the material in the time period to be analyzed includes at least one of the following items: Determine the season corresponding to the time period to be analyzed, and determine the seasonal adjustment factor of the material according to the season; Obtaining the maintenance demand and regular demand of the material by the production equipment during the period to be analyzed, and calculating the maintenance adjustment factor of the material during the period to be analyzed according to the maintenance demand and the regular demand; The planned demand supply and historical supply of the material in the time period to be analyzed are obtained, and the supply chain adjustment factor of the material in the time period to be analyzed is calculated according to the planned demand supply and the historical supply.

3. The method according to claim 1, characterized in that: The calculating, based at least on the historical demand and the demand adjustment parameter, the planned demand of the material by the production equipment during the period to be analyzed comprises: Using an established forecasting model and based on the historical demand, a forecast is performed to obtain a basic demand of the production equipment for the material during the period to be analyzed; The basic demand is adjusted using the demand adjustment parameter to obtain the planned demand for the material by the production equipment during the period to be analyzed.

4. The method according to any one of claims 1 to 3, characterized in that: The planned outbound quantity of the material by the production equipment in the time period to be analyzed includes the outbound quantity of the material used by the production equipment before the time period to be analyzed and the quantity of the material that has been matched but not outbound by the production equipment in the time period to be analyzed; the material satisfaction rate of the production equipment for the material in the time period to be analyzed is calculated at least based on the current inventory of the material required by the production equipment, the planned outbound quantity of the material by the production equipment in the time period to be analyzed and the planned demand of the material by the production equipment in the time period to be analyzed, including: Obtaining the priority ranking value of each production equipment in the time period to be analyzed; Calculate the sum of the planned demand for the material of each production equipment whose priority ranking value is before the current production equipment during the period to be analyzed; Based on the current inventory of materials required by the current production equipment, the quantity that has been shipped out, the quantity that has matched the plan but has not been shipped out, the planned demand for the materials by the current production equipment in the time period to be analyzed and the sum of the planned demand, calculate the material satisfaction rate of the current production equipment for the materials in the time period to be analyzed.

5. The method according to claim 4, characterized in that The obtaining of the priority ranking value of each production equipment in the time period to be analyzed includes calculating the priority ranking value using the following formula: Wherein, t represents the time period to be analyzed, is the priority ranking value of the jth production equipment in the time period to be analyzed t, is the demand time of the material for the j-th production equipment in the time period to be analyzed t, is the priority of the j-th production equipment in the time period t to be analyzed.

6. The method according to claim 4, characterized in that The calculating the sum of the planned demand quantities of the material of each production equipment whose priority ranking value is before the current production equipment during the time period to be analyzed includes calculating the sum of the planned demand quantities using the following formula: Among them, x n is the number of the current production equipment, x i is the priority sort value at x n The number of the previous i-th production equipment, Prio(D(t,x n ,m)) is the priority sort value located at x n The sum of the planned demand for material m by all previous production equipment in the period to be analyzed, D(t,x i ,m) is the device x i The planned demand for material m in the period t to be analyzed; The material satisfaction rate of the current production equipment for the material in the period to be analyzed is calculated according to the current inventory of the material required by the current production equipment, the quantity that has been shipped out, the quantity that has matched the plan but has not been shipped out, the planned demand of the material by the current production equipment for the material in the period to be analyzed and the sum of the planned demand, including using the following formula to calculate the material satisfaction rate: Among them, MFR(t,x n ,m) is the current production equipment x n The material satisfaction rate of material m in the time period to be analyzed is Inv(t,m) is the current inventory of material m, Out(t-1,x n ,m) is x n The quantity of material m that has been shipped out at time t-1 before the period to be analyzed, Mt(t,x n ,m) is x n The number of material m that has been matched but not shipped out during the period to be analyzed, D(t,x n ,m) is x n The planned demand for material m during the period t to be analyzed.

7. The method according to any one of claims 1 to 3, characterized in that: After calculating the material satisfaction rate of the production equipment for the material in the time period to be analyzed, the method further includes at least one of the following: Calculate the comprehensive material satisfaction rate of the production equipment for all materials in the period to be analyzed according to the material satisfaction rate of the production equipment for various materials in the period to be analyzed; The periodic material satisfaction rate of the production equipment for the material within the periodic duration is calculated at least based on the planned demand for the material by the production equipment in multiple time periods to be analyzed within the periodic duration.

8. The method according to claim 7, characterized in that The calculating the periodic material satisfaction rate of the production equipment for the material within the periodic duration according to at least the planned demand of the production equipment for the material in multiple time periods to be analyzed within the periodic duration comprises calculating the periodic material satisfaction rate using the following formula: Among them, MFR month is the material satisfaction rate of the period, Inv month Out is the current inventory of the material at the time corresponding to the cycle duration; month is the quantity of the material shipped out within the cycle duration, T is the quantity of the material to be analyzed in time period t within the cycle duration, To produce equipment x within the stated cycle time n The sum of the quantities of material m that have been matched but not shipped out, D month It is the total planned demand for the material by the production equipment in multiple time periods to be analyzed within the cycle duration.

9. The method according to any one of claims 1 to 3, characterized in that: After obtaining the current inventory of materials required by the production equipment, the historical demand of the production equipment for the materials, and the planned outbound quantity of the materials by the production equipment during the period to be analyzed, the method further includes: Obtaining the quantity of the material that has been matched with the plan but not shipped out by the production equipment in the next period of the period to be analyzed; Obtaining a demand adjustment parameter corresponding to the next time period of the material after the time period to be analyzed; Predicting the planned demand for the material by the production equipment in the next time period based at least on the historical demand and the demand adjustment parameter corresponding to the next time period; The material satisfaction rate of the production equipment for the material in the next time period is predicted based on at least the current inventory of the material required by the production equipment, the quantity of the material that has been matched but not shipped out by the production equipment in the next time period, and the planned demand for the material in the next time period.

10. The method according to claim 9, characterized in that The predicting of the material satisfaction rate of the production equipment for the material in the next period according to at least the current inventory of the material required by the production equipment, the quantity of the material that has been matched but not shipped by the production equipment in the next period, and the planned demand for the material in the next period includes: Obtaining the priority ranking value of each production equipment in the next time period; Calculate the sum of the planned demand for the material of each production equipment whose priority ranking value is before the current production equipment in the next period; Based on the current inventory of materials required by the production equipment, the quantity of materials that have been matched but not shipped out by the production equipment in the next time period, the planned demand for the materials in the next time period and the sum of the planned demand, the material satisfaction rate of the production equipment for the materials in the next time period is predicted.

11. The method according to claim 9, characterized in that After predicting the material satisfaction rate of the production equipment for the material in the next period, the method further includes: If the material satisfaction rate of the production equipment for the material in the time period to be analyzed is less than the preset target satisfaction rate, or the material satisfaction rate of the production equipment for the material in the next time period is less than the target satisfaction rate, a procurement alarm message is output.

12. A material inventory analysis device, characterized in that: include: A data acquisition module, used to acquire the current inventory of materials required by the production equipment, the historical demand of the production equipment for the materials, and the planned outbound quantity of the materials by the production equipment during the period to be analyzed; A parameter acquisition module, used to obtain the demand adjustment parameters corresponding to the material in the period to be analyzed; A demand quantity calculation module, used for calculating the planned demand quantity of the material by the production equipment in the time period to be analyzed based at least on the historical demand quantity and the demand adjustment parameter; The satisfaction rate calculation module is used to calculate the material satisfaction rate of the production equipment for the material in the period to be analyzed based on at least the current inventory of the material required by the production equipment, the planned delivery quantity of the material by the production equipment in the period to be analyzed, and the planned demand quantity of the material by the production equipment in the period to be analyzed.

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

14. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, which, when executed by a processor, implements the steps of the method according to any one of claims 1 to 11.

Images