A cloud platform-based industrial material flow supervision method and system
By analyzing the historical average amount of industrial materials on the cloud platform and comprehensively considering multiple factors, the problem of inaccurate prediction of industrial materials flow monitoring is solved, and the accuracy of inventory management and supply chain stability are improved.
Patent Information
- Application Number
- CN202411412677.6
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-10-11
- Publication Date
- 2025-02-11
- Estimated Expiration
- 2044-10-11
AI Technical Summary
The prior art is difficult to accurately predict the theoretical demands of industrial materials at different time nodes, resulting in insufficient accuracy in material flow monitoring and prediction.
By analyzing the average usage volume of each industrial material in consecutive historical years on the cloud platform, and taking into account the current inventory, current order, estimated inventory, historical usage volume and preset safe inventory volume on a cloud platform, using multi-dimensional evaluating methods to manage inventory of industrial materials.
It improves the accuracy of industrial material inventory forecasts, ensures that the supply of target products at the future target moments is not affected by the risk of out-of-stock, and promptly detects and deals with potential out-of-stock risks.
Smart Images

Figure CN118917779B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of material flow supervision, and in particular to a cloud platform-based industrial material flow supervision method and system. Background Art
[0002] In the prior art, for material flow supervision, the material consumption corresponding to a period of history is usually used to estimate the material consumption in the future. For example, the Chinese invention patent with the publication number CN 113283844 A discloses a method for determining the inventory of time-sensitive materials, including: obtaining a first mapping relationship between the historical consumption of the target time-sensitive material and time, a second mapping relationship between the number of historical consumer objects and time, and the initial inventory of the target time-sensitive material; according to the first mapping relationship, determining the predicted consumption of the target time-sensitive material in a preset time period; according to the predicted consumption, the second mapping relationship and the initial inventory, determining the predicted inventory of the target time-sensitive material at each time point in the preset time period. Since it is applied to material inventory prediction in the catering industry, considering the changing trend of material consumption, it mainly uses the recent period before to predict the material inventory in the recent period after.
[0003] However, since industrial materials are the main source of products, they are affected by the current market trends of the products, annual production plans, and different periodic changes at different time nodes within the year. Using the above method to monitor the flow of industrial materials will not be able to reasonably take into account the theoretical demand for industrial materials at different time nodes, which will lead to inaccurate predictions.
[0004] However, there is currently no technical solution that can solve the above-mentioned technical problems, nor is there a method and system for supervising the flow of industrial materials based on a cloud platform. Summary of the invention
[0005] The present invention provides a cloud platform-based industrial material flow supervision method and system, which aims to manage the inventory of industrial materials through data analysis and prediction of the average industrial material usage in historical year-on-year periods in consecutive historical years, so as to ensure that the supply of target products at future target times is not affected by the risk of out-of-stock.
[0006] In a first aspect, the present invention provides a method for supervising industrial material flow based on a cloud platform, comprising:
[0007] Receiving an input instruction from a user, wherein the input instruction is used to obtain a shortage status of a target product at a target time in the future;
[0008] In response to the input instruction, calling the BOM list to determine all industrial materials corresponding to the target product and the current inventory of each industrial material at the current moment;
[0009] For each industrial material, determine the average usage of the industrial material in a historical period of continuous historical years, where the historical period is a corresponding historical period in each historical year from the current moment to the future target moment;
[0010] Determine the out-of-stock situation of the industrial material at the future target moment according to the current order quantity of the industrial material, the expected incoming quantity of the industrial material, the current inventory, the preset safety inventory and the average usage of the industrial material, traverse all industrial materials, and determine the out-of-stock situation of all industrial materials at the future target moment. The current order quantity of the industrial material is used to characterize the amount of industrial material required for all products currently produced using the industrial material, and the expected incoming quantity of the industrial material is used to characterize the incoming quantity of the industrial material from the current moment to the future target moment;
[0011] When it is determined that any of the industrial materials has a risk of being out of stock at the future target time, it is determined that the target product has a risk of being out of stock at the future target time.
[0012] According to the cloud platform-based industrial material circulation supervision method provided by the present invention, the determination of the average usage of the industrial material in the historical year-on-year period in consecutive historical years includes:
[0013] For any historical year in the continuous historical years, determine the historical usage of industrial materials from a first historical moment to a second historical moment in the historical year, wherein the first historical moment corresponds to the current moment, and the second historical moment corresponds to the future target moment;
[0014] All historical years are traversed to determine the historical usage of industrial materials corresponding to each historical year, and the historical usage of each industrial material corresponding to all historical years is averaged to obtain the average usage of the industrial materials.
[0015] According to the cloud platform-based industrial material circulation supervision method provided by the present invention, the out-of-stock situation of the industrial material at the future target time is determined according to the current order quantity of the industrial material, the expected warehouse quantity of the industrial material, the current inventory quantity, the preset safety inventory quantity and the average usage quantity of the industrial material, including:
[0016]
[0017] Among them, Y represents that the industrial material has no risk of being out of stock at the future target time, and N represents that the industrial material has a risk of being out of stock at the future target time. is the current inventory quantity, is the current order quantity of the industrial material, The average amount used for the industrial materials mentioned above, is the estimated storage volume of the industrial materials, The preset safety stock level.
[0018] According to the cloud platform-based industrial material flow supervision method provided by the present invention, the preset safety inventory is used to characterize the storage material quantity set to cope with emergencies, demand fluctuations and normal production losses;
[0019] Different industrial materials correspond to different preset safety stock quantities;
[0020] In the actual production process, if the current storage volume corresponding to any industrial material is lower than the preset safety storage volume corresponding to the industrial material, an early warning instruction is generated;
[0021] The early warning instruction is used to instruct the industrial material to be replenished so that the current storage volume is higher than the preset safety storage volume.
[0022] According to the cloud platform-based industrial material circulation supervision method provided by the present invention, before determining the shortage of the industrial material at the future target time according to the current order quantity of the industrial material, the expected storage quantity of the industrial material, the current inventory quantity, the preset safety inventory quantity and the average usage quantity of the industrial material, the method further includes:
[0023] Determine the first order quantity according to the current order demand of the target product;
[0024] Determining a second order quantity according to current order demand for other products produced using the industrial material;
[0025] The current order quantity of the industrial material is determined according to the first order quantity and the second order quantity.
[0026] According to the cloud platform-based industrial material circulation supervision method provided by the present invention, before determining the shortage of the industrial material at the future target time according to the current order quantity of the industrial material, the expected storage quantity of the industrial material, the current inventory quantity, the preset safety inventory quantity and the average usage quantity of the industrial material, the method further includes:
[0027] Call the industrial material flow lists corresponding to multiple supply chains from the preset cloud platform;
[0028] Extract the industrial material storage quantity from the current moment to the future target moment from each industrial material flow list;
[0029] The sum of the warehousing quantities of each industrial material corresponding to all industrial material flow lists is determined as the estimated warehousing quantity of the industrial material.
[0030] According to the cloud platform-based industrial material flow supervision method provided by the present invention, after traversing all industrial materials and determining the shortage of all industrial materials at the future target time, the method further includes:
[0031] In the case where it is determined that all industrial materials corresponding to the target product do not have a risk of being out of stock at the future target time, it is determined that the target product does not have a risk of being out of stock at the future target time;
[0032] The remaining stock of each industrial material is determined based on the current order quantity of the industrial material, the expected incoming quantity of the industrial material, the current inventory, the preset safety inventory and the average usage of the industrial material, and the remaining stock of each industrial material at the target product at the future target time is displayed in a preset interface.
[0033] According to the cloud platform-based industrial material flow supervision method provided by the present invention, after determining that the target product has a risk of being out of stock at a future target time, the method further includes:
[0034] Determine the out-of-stock quantity of each industrial material at risk of out-of-stock according to the current order quantity of the industrial material, the expected incoming quantity of the industrial material, the current inventory quantity, the preset safety inventory quantity, and the average usage of the industrial material;
[0035] The preset interface displays the remaining inventory of each industrial material that is not at risk of being out of stock, and the out-of-stock quantity of each industrial material that is at risk of being out of stock for the target product at the future target time.
[0036] According to the cloud platform-based industrial material circulation supervision method provided by the present invention, after determining the out-of-stock quantity of each industrial material with out-of-stock risk, the method further includes:
[0037] For any industrial material that is at risk of being out of stock, determine the lowest historical unit price corresponding to the industrial material based on the order data of the historical period corresponding to the current moment to the future target moment on the cloud platform;
[0038] Determine the estimated purchase order date based on the historical moment corresponding to the lowest value of the historical unit price;
[0039] Update the estimated storage quantity of the industrial material according to the estimated purchase order date and the shortage quantity of the industrial material;
[0040] Traverse all industrial materials that are at risk of being out of stock, and update the estimated inventory quantities corresponding to all industrial materials to achieve automatic flow supervision of industrial materials.
[0041] Secondly, a cloud platform-based industrial material flow supervision system is provided, including:
[0042] A receiving unit, the receiving unit is used to receive an input instruction from a user, the input instruction is used to obtain the out-of-stock status of a target product at a target time in the future;
[0043] A response unit, the response unit is used to respond to the input instruction and call the BOM list to determine all industrial materials corresponding to the target product and the current inventory of each industrial material at the current moment;
[0044] A first determining unit, the first determining unit is used to determine, for each industrial material, an average usage amount of the industrial material in a historical year-on-year period in consecutive historical years, wherein the historical year-on-year period is a corresponding historical period in each historical year from a current moment to a future target moment;
[0045] A second determination unit, the second determination unit is used to determine the shortage of the industrial material at a future target moment according to the current order quantity of the industrial material, the expected storage quantity of the industrial material, the current inventory, the preset safety inventory and the average usage of the industrial material, traverse all industrial materials, and determine the shortage of all industrial materials at the future target moment, the current order quantity of the industrial material is used to characterize the quantity of industrial materials required for all products currently produced using the industrial material, and the expected storage quantity of the industrial material is used to characterize the storage quantity of the industrial material from the current moment to the future target moment;
[0046] A third determining unit is used to determine whether the target product has a risk of being out of stock at a future target time when it is determined that any of the industrial materials has a risk of being out of stock at a future target time.
[0047] The present invention provides a cloud platform-based industrial material flow supervision method and system, which analyzes the average usage of each industrial material in the same period of the same period in consecutive historical years, takes it as one of the considerations for future material usage trends, comprehensively considers current inventory, current orders, expected warehousing, historical average usage and preset safety inventory, and adopts a multi-dimensional evaluation method to more comprehensively reflect the supply status of materials and improve the accuracy of prediction;
[0048] In the supervision of industrial materials, the role and significance of preset safety stock levels are clarified, and the rationality of different safety stock levels corresponding to different materials is pointed out. When the material storage volume is lower than the safety stock level, measures are taken to generate early warning instructions to timely discover and respond to potential out-of-stock risks;
[0049] Fully consider the order demand of current target products and other products to determine the current order quantity of industrial materials, ensure the accuracy and completeness of order demand, and provide reliable data support for subsequent out-of-stock risk assessment;
[0050] After traversing all industrial materials and determining their out-of-stock situations, we further proposed measures to determine the out-of-stock risks of target products and display the inventory balance of each material based on the evaluation results, so that users can have a more comprehensive understanding of the supply status of the supply chain and make corresponding decisions and adjustments in a timely manner. BRIEF DESCRIPTION OF THE DRAWINGS
[0051] In order to more clearly illustrate the technical solutions in the present invention or the prior art, the following briefly introduces the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.
[0052] Figure 1 It is a flow chart of the industrial material flow supervision method based on the cloud platform provided by the present invention;
[0053] Figure 2 It is a structural schematic diagram of the industrial material flow supervision system based on the cloud platform provided by the present invention;
[0054] Figure 3 It is a structural schematic diagram of the electronic device provided by the present invention. DETAILED DESCRIPTION
[0055] In order to make the purpose, technical solution and advantages of the present invention clearer, the technical solution of the present invention will be clearly and completely described below in conjunction with the drawings of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.
[0056] Figure 1 The figure is a flow chart of the industrial material flow supervision method based on the cloud platform provided by the present invention, and the industrial material flow supervision method based on the cloud platform includes:
[0057] Step 101: receiving an input instruction from a user, wherein the input instruction is used to obtain the out-of-stock status of a target product at a target time in the future;
[0058] Step 102: In response to the input instruction, call the BOM list to determine all industrial materials corresponding to the target product and the current inventory of each industrial material at the current moment;
[0059] Step 103: for each industrial material, determine the average usage of the industrial material in a historical period of continuous historical years, where the historical period is a corresponding historical period in each historical year from the current moment to the future target moment;
[0060] Step 104: determine the shortage of the industrial material at the future target time according to the current order quantity of the industrial material, the expected storage quantity of the industrial material, the current inventory, the preset safety inventory and the average usage of the industrial material, traverse all industrial materials, and determine the shortage of all industrial materials at the future target time. The current order quantity of the industrial material is used to represent the quantity of industrial materials required for all products currently produced using the industrial material, and the expected storage quantity of the industrial material is used to represent the storage quantity of the industrial material from the current time to the future target time.
[0061] Step 105: When it is determined that any of the industrial materials has a risk of being out of stock at the future target time, it is determined that the target product has a risk of being out of stock at the future target time.
[0062] In step 101, the present invention allows the user to input the identifier of the target product (such as product ID, name or SKU) and the future target time (specific date or time range) in a pre-designed user interface. After the user submits the input, the system should perform input verification to ensure the validity of the product identifier (such as checking whether the product exists in the database) and the rationality of the future target time (such as ensuring that it is not a date in the past). Once the input is verified, the system will generate a query instruction containing the product ID and the future target time, and pass it to the subsequent steps to obtain the out-of-stock status of the target product at the future target time.
[0063] In step 102, the present invention can use a preset database query language to retrieve the bill of materials of the target product from a pre-established (Bill of Materials, BOM) bill of materials database, including listing all necessary industrial materials and their quantities. Those skilled in the art understand that there are multiple products in the bill of materials database, wherein each product is composed of all the industrial materials required by it, and there are different products in the bill of materials database, as well as all the industrial materials corresponding to each product, and the current inventory of each industrial material at the current moment.
[0064] Optionally, the present invention interacts with the inventory management system through an API or database query to obtain the inventory quantity of each industrial material at the current moment, ensure that the inventory data is up to date, and take into account any real-time inventory changes. At the same time, the materials in the BOM list are integrated with the data in the inventory system to form a list containing material ID, quantity requirements and current inventory, so that when responding to the input instruction, the BOM list can be called to determine all industrial materials corresponding to the target product and the current inventory quantity of each industrial material at the current moment.
[0065] In step 103, the present invention is different from other material forecasting methods in the prior art. The industrial material usage data of each industrial material in the same time period in the past few years (i.e., the historical year-on-year period) is retrieved from the data warehouse or historical database, and the data is cleaned to remove abnormal values (such as extremely high or low values) to ensure the accuracy of the analysis. Considering that the usage in different years may vary due to market trends, seasonal changes and other factors, the average usage of each industrial material in the historical year-on-year period is calculated using statistical methods (such as arithmetic mean, weighted average, etc.).
[0066] Optionally, determining the average usage of the industrial material in a historical period of the same period in consecutive historical years includes:
[0067] For any historical year in the continuous historical years, determine the historical usage of industrial materials from a first historical moment to a second historical moment in the historical year, wherein the first historical moment corresponds to the current moment, and the second historical moment corresponds to the future target moment;
[0068] All historical years are traversed to determine the historical usage of industrial materials corresponding to each historical year, and the historical usage of each industrial material corresponding to all historical years is averaged to obtain the average usage of the industrial materials.
[0069] In an optional embodiment, for example, the current moment is May, the future target moment is October, and the continuous historical years are from 2020 to 2023, then the historical year-on-year period includes the industrial material usage from May to August 2020, the industrial material usage from May to August 2020, the industrial material usage from May to August 2021, the industrial material usage from May to August 2022, and the industrial material usage from May to August 2023. The average industrial material usage of the industrial material in the historical year-on-year period in the continuous historical years can be the average industrial material usage from May to August 2020 to 2023.
[0070] It should be noted that the present invention uses continuous historical years. For example, there are usage of current industrial materials in the historical year-on-year period from 2008 to 2012, 2014, and 2016 to 2023. The present invention only considers the continuous historical years from 2008 to 2012 and 2016 to 2023. More specifically, the present invention can also select from the two continuous historical years according to the length of the continuous years, for example, the longer 2016 to 2023 is selected as the continuous historical year, and in other embodiments, the continuous historical year closest to the current year can also be selected. The advantage of such processing is to improve the accuracy of the average amount of industrial material usage. The continuous historical years will be able to reflect the usage of industrial materials under a continuously changing state, which can better reflect the usage of industrial materials under the change of the year of continuous production of the enterprise.
[0071] In step 104, for each industrial material, the out-of-stock situation of the industrial material at a future target time is determined according to the current order quantity of the industrial material, the expected incoming quantity of the industrial material, the current inventory quantity, the preset safety inventory quantity, and the average usage quantity of the industrial material, including:
[0072]
[0073] Among them, Y represents that the industrial material has no risk of being out of stock at the future target time, and N represents that the industrial material has a risk of being out of stock at the future target time. is the current inventory quantity, is the current order quantity of the industrial material, The average amount used for the industrial materials is is the estimated storage volume of the industrial materials, The preset safety stock level.
[0074] Optionally, when the sum of the current inventory quantity and the expected incoming quantity of the industrial material is greater than or equal to the sum of the current order quantity of the industrial material, the average usage of the industrial material and the preset safety stock, it is determined that there is no risk of shortage of the industrial material at the future target time; when the sum of the current inventory quantity and the expected incoming quantity of the industrial material is less than the sum of the current order quantity of the industrial material, the average usage of the industrial material and the preset safety stock, it is determined that there is a risk of shortage of the industrial material at the future target time.
[0075] Optionally, all industrial materials are traversed to determine the shortage status of all industrial materials at a future target moment. The current order quantity of the industrial materials is used to characterize the quantity of industrial materials required for all products currently produced using the industrial materials. The estimated inventory quantity of the industrial materials is used to characterize the inventory quantity of the industrial materials from the current moment to the future target moment.
[0076] Optionally, before determining the shortage of the industrial material at the future target time according to the current order quantity of the industrial material, the expected warehouse quantity of the industrial material, the current inventory quantity, the preset safety inventory quantity and the average usage quantity of the industrial material, the method further includes:
[0077] Determine the first order quantity according to the current order demand of the target product;
[0078] Determining a second order quantity according to current order demand for other products produced using the industrial material;
[0079] The current order quantity of the industrial material is determined according to the first order quantity and the second order quantity.
[0080] Optionally, for any industrial material, the system needs to collect all order information about the current target product, including order quantity, required material type and quantity, and delivery date. According to the BOM (bill of materials) of the target product and the quantity of each order, the total amount of the industrial materials required to produce these orders is calculated, which is the first order quantity. Further, all other products that need to use the industrial material in the current production are identified. For these products, their order information is also collected, including order quantity, required material type and quantity, delivery date, etc. According to the BOM and order quantity of each product, the total amount of the industrial materials required to produce these orders is calculated, which is the second order quantity; the first order quantity and the second order quantity are added to obtain the current order quantity of the industrial material. The current order quantity represents the total material quantity required for all current product orders produced using the industrial material. After obtaining the current order quantity, the current inventory, the expected inventory, the historical average usage and the preset safety inventory can be further combined to evaluate the shortage of industrial materials at the future target time, thereby more accurately evaluating its shortage at the future target time.
[0081] Optionally, before determining the shortage of the industrial material at the future target time according to the current order quantity of the industrial material, the expected warehouse quantity of the industrial material, the current inventory quantity, the preset safety inventory quantity and the average usage quantity of the industrial material, the method further includes:
[0082] Call the industrial material flow lists corresponding to multiple supply chains from the preset cloud platform;
[0083] Extract the industrial material storage quantity from the current moment to the future target moment from each industrial material flow list;
[0084] The sum of the warehousing quantities of each industrial material corresponding to all industrial material flow lists is determined as the estimated warehousing quantity of the industrial material.
[0085] Optionally, the present invention needs to establish a connection with a preset cloud platform, which stores data of multiple supply chains. Multiple supply chain data related to the target industrial material are retrieved from the cloud platform. These data exist in the form of an industrial material flow list, which contains the flow information of the material in different supply chains. The present invention aims to realize the supervision of the industrial material flow from the current moment to the future target moment. Therefore, when determining the expected inventory quantity, it is necessary to extract the industrial material inventory quantity from the current moment to the future target moment, extract the time information from each entry, filter out the entries between the current moment and the future target moment, and extract the inventory quantity of the corresponding industrial material from these filtered entries; finally, all inventory quantities of the same industrial material from different supply chains and different industrial material flow lists within the future target time period are accumulated, and the accumulated result is the expected inventory quantity of the industrial material at the future target moment. The present invention integrates the information of multiple supply chains to realize the determination of the expected inventory quantity, so that the subsequent out-of-stock prediction results are more accurate.
[0086] Optionally, the preset safety stock quantity is used to characterize the storage material quantity set to cope with emergencies, demand fluctuations and normal production losses;
[0087] Different industrial materials correspond to different preset safety stock quantities;
[0088] In the actual production process, if the current storage volume corresponding to any industrial material is lower than the preset safety storage volume corresponding to the industrial material, an early warning instruction is generated;
[0089] The early warning instruction is used to instruct the industrial material to be replenished so that the current storage volume is higher than the preset safety storage volume.
[0090] Optionally, in the present invention, the preset safety stock is taken as one of the considerations, and an early warning mechanism based on the safety stock is provided to ensure the continuity and stability of the production process, and to ensure that when facing the above uncertainties, the enterprise still has sufficient material supply to maintain normal production activities and avoid adverse consequences such as suspension of production or delayed delivery. Different industrial materials correspond to different preset safety stocks due to differences in their characteristics, uses, supply stability, and the defective rate of the products they produce. For example, critical materials may need to set a higher safety stock; industrial materials corresponding to products with a high defective rate may need to set a higher safety stock; industrial materials with unstable supply may need to set a higher safety stock to deal with potential risks.
[0091] Optionally, in the actual production process, the present invention needs to monitor the current storage volume of each industrial material in real time, which can be achieved through the interface with the inventory management system to ensure the real-time and accuracy of the data. When the current storage volume of any industrial material is lower than its corresponding preset safety storage volume, the system should automatically generate an early warning instruction to trigger the early warning mechanism to remind relevant personnel to pay attention to the risk of material shortage. The early warning instruction should clearly indicate the type of industrial material with shortage risk, the current storage volume, the preset safety storage volume, and the shortage volume. At the same time, the early warning instruction should provide clear instructions, requiring relevant personnel to immediately take measures to replenish the shortage of industrial materials to ensure that the current storage volume can be quickly restored to above the preset safety storage volume. After receiving the early warning instruction, the relevant personnel should arrange the emergency purchase or deployment of materials according to the content of the instruction. After the replenishment operation is completed, the storage volume changes of the industrial material should continue to be monitored to ensure the effectiveness of the replenishment measures. If the storage volume is still lower than the safety inventory after replenishment, the early warning instruction should be issued again until the storage volume is restored to above the safety level.
[0092] Optionally, after traversing all industrial materials and determining the shortage of all industrial materials at the future target time, the method further includes:
[0093] In the case where it is determined that all industrial materials corresponding to the target product do not have a risk of being out of stock at the future target time, it is determined that the target product does not have a risk of being out of stock at the future target time;
[0094] The remaining stock of each industrial material is determined based on the current order quantity of the industrial material, the expected incoming quantity of the industrial material, the current inventory, the preset safety inventory and the average usage of the industrial material, and the remaining stock of each industrial material at the target product at the future target time is displayed in a preset interface.
[0095] Optionally, the present invention will consider multiple factors in the process of industrial material flow supervision based on the cloud platform, such as current order quantity, expected warehouse quantity, current inventory, preset safety inventory and average usage of industrial materials, etc. It is necessary to traverse all industrial materials related to the target product, and determine their out-of-stock situation at the future target time by comprehensively analyzing the current status and future expectations of these materials. When it is determined that all industrial materials do not have the risk of out-of-stock at the future target time, the system can further determine that the target product itself does not have the risk of out-of-stock at the future target time.
[0096] Optionally, for each industrial material, the present invention will calculate the remaining quantity at the future target time based on its current order quantity, expected incoming quantity, current inventory, preset safety inventory, and average usage information. For example, the remaining quantity at the future target time is calculated based on the sum of the current inventory and the expected incoming quantity of the industrial material, and the difference between the sum of the current order quantity of the industrial material, the average usage of the industrial material, and the preset safety inventory. This information is displayed in a preset user interface, and the preset user interface should clearly and intuitively display the remaining quantity of each industrial material of the target product at the future target time, which can be achieved through charts, numbers or other visualization means.
[0097] In step 105, if any industrial material in the BOM list is at risk of being out of stock at the target time in the future, the system should automatically determine that the target product is also at risk of being out of stock. The present invention can generate a report containing stock-out risk information, listing all industrial materials at risk and their degree of shortage, and can also point out the overall stock-out risk of the target product. Relevant personnel can also be notified by email, message push, etc., and countermeasures are recommended to reduce the risk of stock-out, and the countermeasures include but are not limited to advance procurement, adjustment of production plans, and communication with customers.
[0098] Optionally, after determining that the target product has a risk of being out of stock at a future target time, the method further includes:
[0099] Determine the out-of-stock quantity of each industrial material at risk of out-of-stock according to the current order quantity of the industrial material, the expected incoming quantity of the industrial material, the current inventory quantity, the preset safety inventory quantity, and the average usage of the industrial material;
[0100] The preset interface displays the remaining inventory of each industrial material that is not at risk of being out of stock, and the out-of-stock quantity of each industrial material that is at risk of being out of stock for the target product at the future target time.
[0101] Optionally, for those industrial materials determined to be at risk of out-of-stock, detailed calculation and analysis will also be performed based on key indicators such as their current order quantity, expected incoming quantity, current inventory, preset safety stock and average usage. For example, the out-of-stock quantity of industrial materials at risk of out-of-stock is determined based on the absolute value of the difference between the sum of the current inventory and the expected incoming quantity of the industrial material and the current order quantity of the industrial material, the average usage of the industrial material and the sum of the preset safety stock. In the preset user interface, not only the inventory balance of industrial materials that are not at risk of out-of-stock is displayed, but the out-of-stock quantity of materials at risk of out-of-stock can also be emphasized by marking in red, using bold fonts, etc. This differentiated display method will help users quickly identify the problem and concentrate on solving the out-of-stock problem of key materials.
[0102] Optionally, after determining the out-of-stock quantity of each industrial material at risk of out-of-stock, the method further includes:
[0103] For any industrial material that is at risk of being out of stock, determine the lowest historical unit price corresponding to the industrial material based on the order data of the historical period corresponding to the current moment to the future target moment on the cloud platform;
[0104] Determine the estimated purchase order date based on the historical moment corresponding to the lowest value of the historical unit price;
[0105] Update the estimated storage quantity of the industrial material according to the estimated purchase order date and the shortage quantity of the industrial material;
[0106] Traverse all industrial materials that are at risk of being out of stock, and update the estimated inventory quantities corresponding to all industrial materials to achieve automatic flow supervision of industrial materials.
[0107] Optionally, the present invention not only utilizes historical data to calculate the average usage of industrial materials, but also utilizes historical data to determine the lowest historical unit price. Specifically, through data analysis, it is possible to determine the order data of the industrial materials in the historical period corresponding to the current moment to the future target moment, and determine the estimated purchase order date according to the historical moment corresponding to the lowest historical unit price, so that the enterprise can purchase the required materials at a lower price, thereby reducing procurement costs. The estimated inventory quantity of the industrial materials will be updated accordingly based on the estimated purchase order date and the shortage of industrial materials. In order to implement an automatic circulation supervision strategy and to achieve comprehensive coverage and automated management of all industrial materials corresponding to target products, the present invention will traverse all industrial materials that are at risk of shortage, and repeat the above-mentioned analysis, prediction and update processes to ensure that the procurement and inventory of all industrial materials are properly handled. Through this automated circulation supervision method, the inventory status and procurement progress of materials can be grasped in real time, thereby making more accurate and efficient decisions.
[0108] In conjunction with this specific embodiment, while the user hopes to obtain the out-of-stock situation of the target product at the future target moment through the user's input instructions in the preset display interface, the user can also plan the out-of-stock situation at the future target moment in this specific scenario. For industrial materials that are out of stock, the estimated inventory quantity of the industrial materials is updated to achieve automated flow supervision of all industrial material purchases, and the estimated purchase order date and the out-of-stock quantity of the industrial materials are pushed to relevant purchasing personnel, thereby simplifying the process, abandoning the cumbersome manual order creation steps, and improving the company's supervision capabilities.
[0109] The present invention provides an industrial material circulation supervision method based on a cloud platform. By analyzing the average usage of each industrial material in the historical same period in consecutive historical years, it is used as one of the considerations for future material usage trends. The current inventory, current orders, expected warehousing, historical average usage and preset safety stock are comprehensively considered, and a multi-dimensional evaluation method is adopted to more comprehensively reflect the supply status of materials and improve the accuracy of prediction.
[0110] Figure 2 It is a structural diagram of the cloud platform-based industrial material flow supervision system provided by the present invention. The cloud platform-based industrial material flow supervision system includes a receiving unit 1, and the receiving unit is used to receive the user's input instructions. The input instructions are used to obtain the out-of-stock situation of the target product at the future target time. The working principle of the receiving unit 1 can refer to the aforementioned step 101 and will not be repeated here.
[0111] The cloud-based industrial material flow supervision system also includes a response unit 2, which is used to respond to the input instruction, call the BOM list to determine all industrial materials corresponding to the target product and the current inventory of each industrial material at the current moment. The working principle of the response unit 2 can refer to the aforementioned step 102 and will not be repeated here.
[0112] The cloud platform-based industrial material flow supervision system also includes a first determination unit 3, which is used to determine, for each industrial material, the average industrial material usage of the industrial material in a historical year-on-year period in consecutive historical years. The historical year-on-year period is a historical period corresponding to each historical year from the current moment to the future target moment. The working principle of the first determination unit 3 can refer to the aforementioned step 103 and will not be repeated here.
[0113] The cloud platform-based industrial material flow supervision system also includes a second determination unit 4, which is used to determine the out-of-stock situation of the industrial material at a future target moment according to the current order quantity of the industrial material, the expected incoming quantity of the industrial material, the current inventory, the preset safety inventory and the average usage of the industrial material, traverse all industrial materials, and determine the out-of-stock situation of all industrial materials at the future target moment. The current order quantity of the industrial material is used to characterize the amount of industrial material required for all products currently produced using the industrial material, and the expected incoming quantity of the industrial material is used to characterize the incoming quantity of the industrial material from the current moment to the future target moment. The working principle of the second determination unit 4 can refer to the aforementioned step 104 and will not be repeated here.
[0114] The cloud platform-based industrial material flow supervision system also includes a third determination unit 5, which is used to determine whether the target product has a risk of being out of stock at a future target time when it is determined that any of the industrial materials has a risk of being out of stock at a future target time. The working principle of the third determination unit 5 can be referred to the aforementioned step 105 and will not be repeated here.
[0115] The present invention provides an industrial material flow supervision system based on a cloud platform. By analyzing the average usage of each industrial material in the historical same period in consecutive historical years, it takes it as one of the considerations for future material usage trends, comprehensively considers current inventory, current orders, expected warehousing, historical average usage and preset safety stock, and adopts a multi-dimensional evaluation method to more comprehensively reflect the supply status of materials and improve the accuracy of prediction.
[0116] Figure 3 Schematic diagram of the structure of the electronic device provided by the present invention. Figure 3As shown, the electronic device may include: a processor 310, a communications interface 320, a memory 330 and a communications bus 340, wherein the processor 310, the communications interface 320 and the memory 330 communicate with each other through the communications bus 340. The processor 310 may call the logic instructions in the memory 330 to execute the industrial material flow supervision method based on the cloud platform, the method comprising: receiving an input instruction from a user, the input instruction being used to obtain the out-of-stock situation of the target product at a future target moment; in response to the input instruction, calling the BOM list to determine all industrial materials corresponding to the target product and the current inventory of each industrial material at the current moment; for each industrial material, determining the average usage of the industrial material in the historical year-on-year period in consecutive historical years, the historical year-on-year period being the historical period corresponding to each historical year from the current moment to the future target moment; according to the industrial material The current order quantity, the expected incoming quantity of the industrial material, the current inventory, the preset safety inventory and the average usage of the industrial material are used to determine the out-of-stock situation of the industrial material at the future target time. All industrial materials are traversed to determine the out-of-stock situation of all industrial materials at the future target time. The current order quantity of the industrial material is used to characterize the amount of industrial material required for all products currently produced using the industrial material. The expected incoming quantity of the industrial material is used to characterize the incoming quantity of the industrial material from the current time to the future target time. When it is determined that any of the industrial materials is at risk of being out of stock at the future target time, it is determined that the target product is at risk of being out of stock at the future target time.
[0117] In addition, the logic instructions in the above-mentioned memory 330 can be implemented in the form of a software functional unit and can be stored in a computer-readable storage medium when it is sold or used as an independent product. Based on this understanding, the technical solution of the present invention can be essentially or partly embodied in the form of a software product that contributes to the prior art. The computer software product is stored in a storage medium, including several instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), disk or optical disk, etc. Various media that can store program codes.
[0118] On the other hand, the present invention also provides a computer program product, which includes a computer program, which can be stored on a non-transitory computer-readable storage medium. When the computer program is executed by a processor, the computer can execute a cloud platform-based industrial material flow supervision method provided by the above methods, the method including: receiving a user's input instruction, the input instruction is used to obtain the out-of-stock situation of the target product at a future target time; in response to the input instruction, calling the BOM list to determine all industrial materials corresponding to the target product and the current inventory of each industrial material at the current time; for each industrial material, determining the average industrial material usage of the industrial material in a historical year-on-year period in consecutive historical years, the historical year-on-year period is from the current time. The historical period corresponding to the future target moment in each historical year is determined; the shortage situation of the industrial material at the future target moment is determined according to the current order quantity of the industrial material, the expected inventory quantity of the industrial material, the current inventory, the preset safety inventory and the average usage of the industrial material, all industrial materials are traversed to determine the shortage situation of all industrial materials at the future target moment, the current order quantity of the industrial material is used to characterize the industrial material quantity required for all products currently produced using the industrial material, and the expected inventory quantity of the industrial material is used to characterize the industrial material inventory from the current moment to the future target moment; when it is determined that any of the industrial materials has a risk of being out of stock at the future target moment, it is determined that the target product has a risk of being out of stock at the future target moment.
[0119] On the other hand, the present invention also provides a non-transitory computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, is implemented to execute the cloud platform-based industrial material flow supervision method provided by the above-mentioned methods, the method comprising: receiving a user's input instruction, the input instruction being used to obtain the out-of-stock situation of a target product at a future target moment; in response to the input instruction, calling a BOM list to determine all industrial materials corresponding to the target product and the current inventory of each industrial material at the current moment; for each industrial material, determining the average industrial material usage of the industrial material in a historical year-on-year period in consecutive historical years, the historical year-on-year period being from the current moment to the future target moment in each historical year the corresponding historical period; determine the out-of-stock situation of the industrial material at the future target moment according to the current order quantity of the industrial material, the expected incoming inventory of the industrial material, the current inventory, the preset safety inventory and the average usage of the industrial material, traverse all industrial materials, and determine the out-of-stock situation of all industrial materials at the future target moment, the current order quantity of the industrial material is used to characterize the amount of industrial material required for all products currently produced using the industrial material, and the expected incoming inventory of the industrial material is used to characterize the incoming inventory of the industrial material from the current moment to the future target moment; when it is determined that any of the industrial materials has a risk of being out of stock at the future target moment, determine that the target product has a risk of being out of stock at the future target moment.
[0120] The device embodiments described above are merely illustrative, wherein the units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the scheme of this embodiment. Ordinary technicians in this field can understand and implement it without paying creative labor.
[0121] Through the description of the above implementation methods, those skilled in the art can clearly understand that each implementation method can be implemented by means of software plus a necessary general hardware platform, and of course, can also be implemented by hardware. Based on this understanding, the above technical solution is essentially or the part that contributes to the prior art can be embodied in the form of a software product, and the computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, a disk, an optical disk, etc., including a number of instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in each embodiment or some parts of the embodiments.
[0122] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention 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 make equivalent replacements for some of the technical features therein. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present invention.
Claims
1. A cloud platform-based industrial material flow supervision method, characterized in that: include: Receiving an input instruction from a user, wherein the input instruction is used to obtain a shortage status of a target product at a target time in the future; In response to the input instruction, calling the BOM list to determine all industrial materials corresponding to the target product and the current inventory of each industrial material at the current moment; For each industrial material, determine the average usage of the industrial material in a historical period of continuous historical years, where the historical period is a corresponding historical period in each historical year from the current moment to the future target moment; Determine the out-of-stock situation of the industrial material at the future target moment according to the current order quantity of the industrial material, the expected incoming quantity of the industrial material, the current inventory, the preset safety inventory and the average usage of the industrial material, traverse all industrial materials, and determine the out-of-stock situation of all industrial materials at the future target moment. The current order quantity of the industrial material is used to characterize the amount of industrial material required for all products currently produced using the industrial material, and the expected incoming quantity of the industrial material is used to characterize the incoming quantity of the industrial material from the current moment to the future target moment; In the case where it is determined that any of the industrial materials has a risk of being out of stock at the future target time, determining that the target product has a risk of being out of stock at the future target time; The determining of the shortage of the industrial material at a future target time according to the current order quantity of the industrial material, the expected warehouse quantity of the industrial material, the current inventory quantity, the preset safety inventory quantity and the average usage quantity of the industrial material includes: ; Among them, Y represents that the industrial material has no risk of being out of stock at the future target time, and N represents that the industrial material has a risk of being out of stock at the future target time. is the current inventory quantity, is the current order quantity of the industrial material, The average amount used for the industrial materials is is the estimated storage volume of the industrial materials, The preset safety stock level.
2. The cloud platform-based industrial material flow supervision method according to claim 1 is characterized in that: The determining of the average usage of the industrial material in the historical period of the same period in consecutive historical years includes: For any historical year in the continuous historical years, determine the historical usage of industrial materials from a first historical moment to a second historical moment in the historical year, wherein the first historical moment corresponds to the current moment, and the second historical moment corresponds to the future target moment; All historical years are traversed to determine the historical usage of industrial materials corresponding to each historical year, and the historical usage of each industrial material corresponding to all historical years is averaged to obtain the average usage of the industrial materials.
3. The cloud platform-based industrial material flow supervision method according to claim 1 is characterized in that: The preset safety stock is used to represent the amount of stored materials set up to cope with emergencies, demand fluctuations and normal production losses; Different industrial materials correspond to different preset safety stock quantities; In the actual production process, if the current storage volume corresponding to any industrial material is lower than the preset safety storage volume corresponding to the industrial material, an early warning instruction is generated; The early warning instruction is used to instruct the industrial material to be replenished so that the current storage volume is higher than the preset safety storage volume.
4. The cloud platform-based industrial material flow supervision method according to claim 1 is characterized in that: Before determining the shortage of the industrial material at a future target time according to the current order quantity of the industrial material, the expected warehouse quantity of the industrial material, the current inventory quantity, the preset safety inventory quantity and the average usage quantity of the industrial material, the method further includes: Determine the first order quantity according to the current order demand of the target product; Determining a second order quantity according to current order demand for other products produced using the industrial material; The current order quantity of the industrial material is determined according to the first order quantity and the second order quantity.
5. The cloud platform-based industrial material flow supervision method according to claim 1 is characterized in that: Before determining the shortage of the industrial material at a future target time according to the current order quantity of the industrial material, the expected warehouse quantity of the industrial material, the current inventory quantity, the preset safety inventory quantity and the average usage quantity of the industrial material, the method further includes: Call the industrial material flow lists corresponding to multiple supply chains from the preset cloud platform; Extract the industrial material storage quantity from the current time to the future target time from each industrial material flow list; The sum of the warehousing quantities of each industrial material corresponding to all industrial material flow lists is determined as the estimated warehousing quantity of the industrial material.
6. The cloud platform-based industrial material flow supervision method according to claim 1 is characterized in that: After traversing all industrial materials and determining the shortage of all industrial materials at the future target time, the method further includes: In the case where it is determined that all industrial materials corresponding to the target product do not have a risk of being out of stock at the future target time, it is determined that the target product does not have a risk of being out of stock at the future target time; The remaining stock of each industrial material is determined based on the current order quantity of the industrial material, the expected incoming quantity of the industrial material, the current inventory, the preset safety inventory and the average usage of the industrial material, and the remaining stock of each industrial material at the target product at the future target time is displayed in a preset interface.
7. The cloud platform-based industrial material flow supervision method according to claim 1 is characterized in that: After determining that the target product has a risk of being out of stock at a future target time, the method further includes: Determine the out-of-stock quantity of each industrial material at risk of out-of-stock according to the current order quantity of the industrial material, the expected incoming quantity of the industrial material, the current inventory quantity, the preset safety inventory quantity, and the average usage of the industrial material; The preset interface displays the remaining inventory of each industrial material that is not at risk of being out of stock, and the out-of-stock quantity of each industrial material that is at risk of being out of stock for the target product at the future target time.
8. The cloud platform-based industrial material flow supervision method according to claim 7 is characterized in that: After determining the shortage quantity of each industrial material at risk of shortage, the method further includes: For any industrial material that is at risk of being out of stock, determine the lowest historical unit price corresponding to the industrial material based on the order data of the historical period corresponding to the current moment to the future target moment on the cloud platform; Determine the estimated purchase order date based on the historical moment corresponding to the lowest value of the historical unit price; Update the estimated storage quantity of the industrial material according to the estimated purchase order date and the shortage quantity of the industrial material; Traverse all industrial materials that are at risk of being out of stock, and update the estimated inventory quantities corresponding to all industrial materials to achieve automatic flow supervision of industrial materials.
9. An industrial material flow supervision system based on a cloud platform, characterized in that: include: A receiving unit, the receiving unit is used to receive an input instruction from a user, the input instruction is used to obtain the out-of-stock status of a target product at a target time in the future; A response unit, the response unit is used to respond to the input instruction and call the BOM list to determine all industrial materials corresponding to the target product and the current inventory of each industrial material at the current moment; A first determining unit, the first determining unit is used to determine, for each industrial material, an average usage amount of the industrial material in a historical year-on-year period in consecutive historical years, wherein the historical year-on-year period is a corresponding historical period in each historical year from a current moment to a future target moment; A second determination unit, the second determination unit is used to determine the shortage of the industrial material at a future target moment according to the current order quantity of the industrial material, the expected storage quantity of the industrial material, the current inventory, the preset safety inventory and the average usage of the industrial material, traverse all industrial materials, and determine the shortage of all industrial materials at the future target moment, the current order quantity of the industrial material is used to characterize the quantity of industrial materials required for all products currently produced using the industrial material, and the expected storage quantity of the industrial material is used to characterize the storage quantity of the industrial material from the current moment to the future target moment; A third determining unit, the third determining unit is used to determine that the target product has a risk of being out of stock at the future target time when it is determined that any of the industrial materials has a risk of being out of stock at the future target time; The determining of the shortage of the industrial material at a future target time according to the current order quantity of the industrial material, the expected warehouse quantity of the industrial material, the current inventory quantity, the preset safety inventory quantity and the average usage quantity of the industrial material includes: ; Among them, Y represents that the industrial material has no risk of being out of stock at the future target time, and N represents that the industrial material has a risk of being out of stock at the future target time. is the current inventory quantity, is the current order quantity of the industrial material, The average amount used for the industrial materials is is the estimated storage volume of the industrial materials, The preset safety stock level.
Citation Information
Patent Citations
Inventory determination method and device for aging sensitive materials and electronic equipment
CN113283844A
Stock management system and method
CN108022061A
Internet e-commerce commodity replenishment control method
CN115204974A