Electric power material purchasing and inventory optimization management system

Abstract

The file is a patent document of an electric power material purchase and inventory optimization management system, the system is mainly introduced to comprise a material information management module, a warehouse-in and warehouse-out management module, an inventory monitoring and analysis module, a purchase demand grading module and an approval process generation module, and comprehensive optimization management of electric power material purchase and inventory is achieved. According to the system, basic information and historical purchasing data of electric power materials are imported, stored and updated through a material information management module; the warehouse-in and warehouse-out management module records warehouse-in and warehouse-out information of the materials and updates inventory data in real time; the inventory monitoring and analysis module monitors the inventory in real time and performs trend analysis, and sets a residual threshold to trigger a purchase application; the purchase demand grading module sets material purchase demands and emergency degrees according to historical purchase data and trend analysis results; and the approval process generation module automatically generates approval process lists of different levels according to the purchase emergency degree. The system improves the efficiency and accuracy of electric power material purchasing, and optimizes inventory management.

Description

Technical Field

[0001] The present invention relates to the technical field, and in particular to an electric power material procurement and inventory optimization management system. Background Art

[0002] Power material procurement refers to the procurement of power equipment, materials, parts and components by power enterprises or related units to meet the needs of power production, construction and operation. This process covers all aspects from supplier selection, price negotiation, contract signing, to material receipt, inspection, warehousing and subsequent supply management. The purpose of power material procurement is to ensure the safe, stable and efficient operation of power facilities.

[0003] However, there are still some shortcomings in the existing power material procurement and inventory management. For example, the traditional material procurement methods often lack scientificity and foresight, resulting in low procurement efficiency and high costs. At the same time, there are also many problems in inventory management, such as inventory backlogs and material shortages. These problems not only affect the normal operation of power companies, but may also lead to safety accidents.

[0004] To this end, the patent proposes a power material procurement and inventory optimization management system, which aims to solve the above-mentioned deficiencies in the existing technology, improve the efficiency and accuracy of power material procurement, optimize inventory management, and ensure the safe, stable and efficient operation of power facilities.

[0005] To this end, we propose a power material procurement and inventory optimization management system Summary of the invention

[0006] The purpose of the present invention is to provide a power material procurement and inventory optimization management system to solve the above-mentioned deficiencies in the prior art.

[0007] In order to achieve the above object, the present invention provides the following technical solution: comprising:

[0008] Material information management module: used to import, store and update basic information of power materials, where the basic information of power materials includes but is not limited to material name, model, specification, supplier information, price and classification, and the material information management module is also used to import historical procurement data of power materials;

[0009] In and out warehouse management module: set up a front-end interface to record the in and out warehouse information of materials, and transmit the in and out warehouse information of materials to the material information management module. The transmitted information includes but is not limited to the in and out warehouse information of materials, in and out warehouse quantity, use reason, time information, operator information and approval information, and update the inventory data in real time to ensure the accuracy of the quantity of power materials in the system;

[0010] Inventory monitoring and analysis module: It is connected to the material information management module through an interface and is used to monitor the inventory in real time. It includes a monitoring unit and a trend analysis unit. The trend analysis unit performs trend analysis and sets the remaining threshold of each type of power material according to the fluctuation of the in-and-out quantity of each type of power material and the reason for the use of the material. The monitoring unit is used to monitor the inventory of each type of material and compare the inventory with the remaining threshold. When the inventory of this type of material drops to the preset remaining threshold, a purchase application is triggered;

[0011] Procurement demand grading module: It is used to set the procurement demand of materials according to the historical procurement data in the material information management module and the analysis structure of the inventory monitoring and analysis module, including the fixed procurement cycle and quantity of conventional consumables. Such conventional consumables are purchased regularly and have a regular procurement cycle. The procurement urgency is set to level 1. The grades of unconventional power materials are divided into levels 2 and 3 according to the analysis results of the trend analysis unit.

[0012] Approval process generation module: When the monitoring unit initiates a purchase application, the approval process generation module is used to automatically generate an approval process sheet. The approval process generation module automatically generates approval process sheets of different levels according to the urgency of the material purchase. For materials with a purchase urgency of level 1, the approval process sheet is set to regular approval, and there is no need to submit for approval every time; for materials with a purchase urgency of level 2, a normal process application is carried out; for materials with a purchase urgency of level 3, a maximum approval time is set, and the maximum approval time is evenly divided according to the number of approval levels. If the approval of a certain level times out, it will automatically transfer to the next level for purchase approval, and a reminder message will be sent to relevant personnel.

[0013] As a further description of the above technical solution: the material information management module establishes a system framework on a Web-based platform, imports, stores and updates the basic information of power materials through the database software SQL Server, and at the same time, imports historical procurement data into the software SQL Server database using Excel or CSV file format.

[0014] As a further description of the above technical solution: the front-end interface of the warehousing management module adopts a responsive design to adapt to screen devices of different sizes, ensuring that operators can easily perform warehousing and storage operations on mobile devices or desktop computers.

[0015] As a further description of the above technical solution: the monitoring unit searches the inventory data of various types of electric power materials from the database in real time through SQL, and monitors the inventory quantity of each type of material based on the real-time queried inventory data of electric power materials, and compares the inventory quantity with the set remaining threshold of electric power materials.

[0016] As a further description of the above technical solution: the specific method of the trend analysis unit to perform data analysis is divided into the following steps:

[0017] A: Collect information such as material purchase data, inbound and outbound data from the historical database, and then clean and pre-process the data, including removing duplicate data, processing missing values, and converting data formats;

[0018] B: Use association rule mining algorithms to discover the associations between materials; use cluster analysis algorithms to classify materials according to usage, procurement cycles and other characteristics; use classification algorithms to predict the demand for materials in the future;

[0019] C: Based on the results of data mining and analysis, a time series forecasting model is constructed, and the demand for materials in the future is predicted using the forecasting model. The remaining threshold of power materials is dynamically set according to the forecasting results.

[0020] As a further description of the above technical solution: the specific method of the procurement demand classification module to classify the unconventional types of power materials into level 2 and level 3 is as follows:

[0021] D: setting a remaining threshold of electric power materials according to the prediction result of the trend analysis unit, the remaining threshold being the same as the next outbound quantity of the electric power materials of the type predicted by the trend analysis unit;

[0022] E: After the next shipment of electric power materials analyzed by the trend analysis unit, if the remaining threshold is greater than 120% of the subsequent usage forecast of the materials predicted by the trend analysis unit, the purchase will be positioned at level 2. If the remaining threshold is less than 120% of the subsequent usage forecast of the materials predicted by the trend analysis unit, the purchase will be positioned at level 3.

[0023] In the above technical solution, the power material procurement and inventory optimization management system provided by the present invention has the following beneficial effects:

[0024] Classify purchases according to actual conditions: The system can scientifically and reasonably classify material purchase needs based on historical purchase data and inventory monitoring information. Conventional consumables are set with fixed purchase cycles and quantities, and unconventional materials are divided into different purchase levels based on trend analysis results, thus achieving refined management of purchases.

[0025] Automatically generate purchase review forms: When the inventory drops to the preset remaining threshold, the system will automatically trigger a purchase application and generate a corresponding purchase review form. This function greatly simplifies the purchase process and reduces the tediousness of manual operations.

[0026] No need for manual intervention: From inventory monitoring, procurement demand classification to approval process generation, the entire system is highly automated. Under the set rules and algorithms, the system can complete most of the work autonomously without frequent manual intervention, reducing the possibility of human error.

[0027] Improve audit efficiency: The system automatically generates approval process sheets of different levels according to the urgency of material procurement. For materials with a higher degree of urgency, the system sets regular approval or fast approval channels, shortening the approval cycle and improving audit efficiency. At the same time, the system can also record and display the approval progress and results of each procurement application, improving the transparency and traceability of the approval process. DETAILED DESCRIPTION

[0028] In order to enable those skilled in the art to better understand the technical solution of the present invention, the present invention will be further described in detail below.

[0029] The embodiment of the present invention provides a technical solution: a power material procurement and inventory optimization management system, comprising:

[0030] Material information management module: used to import, store and update the basic information of power materials, where the basic information of power materials includes but is not limited to material name, model, specification, supplier information, price and classification. The material information management module is also used to import the historical procurement data of power materials, establish a system framework on a Web-based platform, import, store and update the basic information of power materials through the database software SQL Server, and at the same time, import the historical procurement data into the software SQL Server database using Excel or CSV file format;

[0031] In and out warehouse management module: set up a front-end interface to record the in and out warehouse information of materials, and transmit the in and out warehouse information of materials to the material information management module. The transmitted information includes but is not limited to the in and out warehouse information of materials, the quantity of in and out warehouse, the reason for use, time information, operator information and approval information, and update the inventory data in real time to ensure the accuracy of the quantity of power materials in the system. Among them, the front-end interface of the in and out warehouse management module adopts a responsive design to adapt to screen devices of different sizes, ensuring that operators can easily perform in and out warehouse operations on mobile devices or desktop computers;

[0032] It should be noted that the in-and-out warehouse management module is responsible for recording and managing the in-and-out information of materials to ensure the real-time and accuracy of inventory data. The module is designed with an intuitive and easy-to-use front-end interface to facilitate operators to quickly enter and query the in-and-out information of materials, including material name, model, specification, in-and-out quantity, reason for use, time information, operator information and approval information, etc., and perform real-time verification of the entered data to ensure the accuracy and completeness of the data. At the same time, after the in-and-out information is entered, it can be transmitted to the material information management module in real time to achieve data synchronization and ensure real-time updating of inventory data. At the same time, the module can also generate in-and-out warehouse reports and inventory statistics, and display data through charts, trend lines, etc., to help enterprises better understand the flow of materials and inventory status. In order to ensure the security of data, the module can also adopt technical measures such as data encryption and permission management to ensure the legality and compliance of data;

[0033] Inventory monitoring and analysis module: It is connected to the material information management module through an interface and is used to monitor the inventory in real time. It includes a monitoring unit and a trend analysis unit. The trend analysis unit performs trend analysis based on the fluctuation of the in-and-out quantity of various types of power materials and the reasons for the use of materials, and sets the remaining thresholds of various types of power materials;

[0034] The specific method of data analysis by the trend analysis unit is divided into the following steps:

[0035] A: Collect information such as material purchase data, inbound and outbound data from the historical database, and then clean and pre-process the data, including removing duplicate data, processing missing values, and converting data formats;

[0036] B: Use association rule mining algorithms to discover the associations between materials; use cluster analysis algorithms to classify materials according to usage, procurement cycles and other characteristics; use classification algorithms to predict the demand for materials in the future;

[0037] C: Based on the results of data mining and analysis, a time series forecasting model is constructed, and the demand for materials in the future is predicted using the forecasting model. The remaining threshold of power materials is dynamically set according to the forecasting results.

[0038] The monitoring unit is used to monitor the inventory of each type of material and compare the inventory with the remaining threshold. When the inventory of this type of material drops to the preset remaining threshold, a purchase application is triggered:

[0039] It should be noted that the monitoring unit searches the inventory data of various types of power materials from the database in real time through SQL, and monitors the inventory of each type of material based on the inventory data of power materials queried in real time, and compares the inventory with the set power material remaining threshold;

[0040] Among them, the monitoring unit can obtain the inventory data of various types of power materials in real time and compare it with the preset remaining threshold. Once the inventory volume drops below the threshold, the system will immediately trigger the early warning mechanism, reminding relevant personnel to take timely procurement measures through email, SMS or system notification. In addition to real-time monitoring of inventory volume, the monitoring unit can also monitor the shelf life, batch number, storage location and other multi-dimensional information of materials according to the actual needs of the enterprise to ensure the safety and traceability of materials. By comparing historical inventory data with current inventory data, the monitoring unit can detect abnormal fluctuations in inventory volume, such as sudden increase or decrease, and provide early warning and decision support for the company's inventory management;

[0041] It should also be noted that, based on historical data and current market conditions, the trend analysis unit can automatically set or adjust the remaining threshold of each type of power material to ensure the rationality and economy of the inventory, and this remaining threshold is the subsequent required outbound quantity of the power material analyzed by the trend analysis unit;

[0042] Procurement demand grading module: It is used to set the procurement demand of materials according to the historical procurement data in the material information management module and the analysis structure of the inventory monitoring and analysis module, including the fixed procurement cycle and quantity of conventional consumables. Such conventional consumables are purchased regularly and have a regular procurement cycle. The procurement urgency is set to level 1. The grades of unconventional power materials are divided into levels 2 and 3 according to the analysis results of the trend analysis unit.

[0043] It should be noted that for conventional consumables, the procurement demand classification module sets fixed procurement cycles and quantities based on historical procurement data and inventory monitoring information. This management method ensures the continuous supply of conventional consumables and avoids production and operation interruptions caused by insufficient or excessive inventory;

[0044] It should be noted that when setting procurement requirements, the procurement requirements classification module can also consider a variety of factors, such as supplier delivery cycles, changes in production costs, market demand fluctuations, etc. Comprehensive consideration of these factors will help companies formulate more reasonable procurement plans, reduce procurement costs, and improve procurement efficiency;

[0045] Among them, the specific method of the procurement demand classification module to classify unconventional types of power materials into Level 2 and Level 3 is as follows:

[0046] D: setting a remaining threshold of electric power materials according to the prediction result of the trend analysis unit, the remaining threshold being the same as the next outbound quantity of the electric power materials of the type predicted by the trend analysis unit;

[0047] E: After the next power material is released from the warehouse as analyzed by the trend analysis unit, if the remaining threshold is greater than 120% of the subsequent usage forecast of the material predicted by the trend analysis unit, the purchase is positioned at level 2. If the remaining threshold is less than 120% of the subsequent usage forecast of the material predicted by the trend analysis unit, the purchase is positioned at level 3.

[0048] That is to say, the setting of the threshold is not static, but is dynamically adjusted according to the forecast results of the trend analysis unit. This ensures the accuracy and timeliness of the remaining threshold, helps enterprises better respond to market changes and demand fluctuations, and the subsequent forecast of the use of power materials predicted by the trend analysis unit plays a vital role in determining the procurement level. This forecast not only reflects the actual demand of the enterprise for power materials, but also provides an important basis for the enterprise to formulate procurement plans. When determining the procurement level, the enterprise sets a percentage threshold (such as 120%). The setting of this threshold takes into account many factors, such as market supply, price fluctuations, inventory costs, etc. When the remaining threshold is greater than 120% of the usage forecast, the enterprise believes that the inventory is relatively sufficient and the procurement level can be set to level 2; when the remaining threshold is less than 120% of the usage forecast, the enterprise believes that there may be risks in the inventory and the procurement level needs to be set to level 3.

[0049] Approval process generation module: When the monitoring unit initiates a purchase application, the approval process generation module is used to automatically generate an approval process sheet. The approval process generation module automatically generates approval process sheets of different levels according to the urgency of the material purchase. For materials with a purchase urgency of level 1, the approval process sheet is set to regular approval, and there is no need to submit for approval every time; for materials with a purchase urgency of level 2, a normal process application is carried out; for materials with a purchase urgency of level 3, a maximum approval time is set, and the maximum approval time is evenly divided according to the number of approval levels. If the approval of a certain level times out, it will automatically transfer to the next level for purchase approval, and a reminder message will be sent to relevant personnel. This function ensures the continuity and timeliness of the approval process, avoids purchase delays caused by approval delays, and when processing purchase applications of different urgency levels, it can automatically generate efficient and reasonable approval process sheets to ensure the smooth progress of the purchase process;

[0050] It should be noted that the approval process generation module can also record and display the approval progress and results of each purchase application, so that relevant personnel can understand the progress of the approval process at any time. This function improves the transparency and traceability of the approval process and helps enterprises strengthen internal management and supervision.

[0051] The above description is only by way of illustration of certain exemplary embodiments of the present invention. It is undoubted that, for those skilled in the art, the described embodiments can be modified in various ways without departing from the spirit and scope of the present invention. Therefore, the above description is illustrative in nature and should not be construed as limiting the scope of protection of the claims of the present invention.

Claims

1. Power material procurement and inventory optimization management system, characterized by: include: Material information management module: used to import, store and update basic information of power materials, where the basic information of power materials includes but is not limited to material name, model, specification, supplier information, price and classification, and the material information management module is also used to import historical procurement data of power materials; In and out warehouse management module: set up a front-end interface to record the in and out warehouse information of materials, and transmit the in and out warehouse information of materials to the material information management module. The transmitted information includes but is not limited to the in and out warehouse information of materials, in and out warehouse quantity, use reason, time information, operator information and approval information, and update the inventory data in real time to ensure the accuracy of the quantity of power materials in the system; Inventory monitoring and analysis module: It is connected to the material information management module through an interface and is used to monitor the inventory in real time. It includes a monitoring unit and a trend analysis unit. The trend analysis unit performs trend analysis and sets the remaining threshold of each type of power material according to the fluctuation of the in-and-out quantity of each type of power material and the reason for the use of the material. The monitoring unit is used to monitor the inventory of each type of material and compare the inventory with the remaining threshold. When the inventory of this type of material drops to the preset remaining threshold, a purchase application is triggered; Procurement demand grading module: It is used to set the procurement demand of materials according to the historical procurement data in the material information management module and the analysis structure of the inventory monitoring and analysis module, including the fixed procurement cycle and quantity of conventional consumables. Such conventional consumables are purchased regularly and have a regular procurement cycle. The procurement urgency is set to level 1. The grades of unconventional power materials are divided into levels 2 and 3 according to the analysis results of the trend analysis unit. Approval process generation module: When the monitoring unit initiates a purchase application, the approval process generation module is used to automatically generate an approval process sheet. The approval process generation module automatically generates approval process sheets of different levels according to the urgency of the material purchase. For materials with a purchase urgency of level 1, the approval process sheet is set to regular approval, and there is no need to submit for approval every time; for materials with a purchase urgency of level 2, a normal process application is carried out; for materials with a purchase urgency of level 3, a maximum approval time is set, and the maximum approval time is evenly divided according to the number of approval levels. If the approval of a certain level times out, it will automatically transfer to the next level for purchase approval, and a reminder message will be sent to relevant personnel.

2. The power material procurement and inventory optimization management system according to claim 1 is characterized in that: The material information management module establishes a system framework on a Web-based platform, imports, stores and updates basic information of power materials through the database software SQL Server, and imports historical procurement data into the software SQL Server database using Excel or CSV file formats.

3. The power material procurement and inventory optimization management system according to claim 1 is characterized in that: The front-end interface of the warehousing management module adopts a responsive design to adapt to screen devices of different sizes, ensuring that operators can easily perform warehousing and storage operations on mobile devices or desktop computers.

4. The power material procurement and inventory optimization management system according to claim 1 is characterized in that: The monitoring unit searches the database for inventory data of various types of electric power materials in real time through SQL, and monitors the inventory of each type of material based on the real-time queried inventory data of electric power materials, while comparing the inventory with the set remaining threshold of electric power materials.

5. The power material procurement and inventory optimization management system according to claim 1 is characterized in that: The specific method of the trend analysis unit to perform data analysis is divided into the following steps: A: Collect information such as material purchase data, inbound and outbound data from the historical database, and then clean and pre-process the data, including removing duplicate data, processing missing values, and converting data formats; B: Use association rule mining algorithms to discover the associations between materials; use cluster analysis algorithms to classify materials according to usage, procurement cycles and other characteristics; use classification algorithms to predict the demand for materials in the future; C: Based on the results of data mining and analysis, a time series forecasting model is constructed, and the demand for materials in the future is predicted using the forecasting model. The remaining threshold of power materials is dynamically set according to the forecasting results.

6. The power material procurement and inventory optimization management system according to claim 1 is characterized in that: The specific method of the procurement demand classification module to classify unconventional types of power materials into Level 2 and Level 3 is as follows: D: setting a remaining threshold of electric power materials according to the prediction result of the trend analysis unit, the remaining threshold being the same as the next outbound quantity of the electric power materials of the type predicted by the trend analysis unit; E: After the next shipment of electric power materials analyzed by the trend analysis unit, if the remaining threshold is greater than 120% of the subsequent usage forecast of the materials predicted by the trend analysis unit, the purchase will be positioned at level 2. If the remaining threshold is less than 120% of the subsequent usage forecast of the materials predicted by the trend analysis unit, the purchase will be positioned at level 3.