Material purchasing management system and method

Abstract

The invention discloses a material purchasing management system, and the system comprises a historical data summarization and analysis module which summarizes the historical data of material purchasing; the intelligent purchase plan drawing and demand prediction module draws a purchase plan according to historical data and real-time demands, predicts future demands, and constructs a seasonal change demand prediction model in combination with industry characteristics and seasonal factors; the arrival plan making and inventory management module is used for making an arrival plan; the purchase demand adjusting module is used for adjusting the purchase demand; the emergency demand plan processing module judges whether the temporary demand plan is an emergency demand plan or not, adjusts the purchase plan according to the emergency degree, provides an emergency purchase channel, adjusts the purchase plan according to the emergency demand, and feeds back an adjustment result to the seasonal change demand prediction model; and the sub-warehouse distribution plan making and real-time adjusting module is used for making sub-warehouse distribution plans according to different regions and the arrival plans.

Description

Technical Field

[0001] The present invention relates to the technical field of material procurement, and in particular to a material procurement management system and method. Background Art

[0002] In modern enterprise operations, material procurement plays a vital role. It is directly related to the enterprise's cost control, production efficiency, product quality and market competitiveness. Therefore, establishing an efficient and accurate material procurement management system is of great significance to the long-term development of the enterprise. Enterprises need to continuously improve their operational efficiency to reduce costs and enhance competitiveness. As an important part of the production and operation of an enterprise, the efficiency and quality of material procurement directly affect the overall performance of the enterprise.

[0003] In the prior art, in some industries, material procurement demand may be affected by seasonal changes. It is difficult for existing material procurement management systems to accurately capture the subtle differences in seasonal changes, resulting in overly conservative or overly aggressive procurement plans, causing inventory backlogs or shortages, increasing capital occupation and production costs, and leading to inaccurate forecasting results. Therefore, a material procurement management system and method are proposed. Summary of the invention

[0004] The purpose of the present invention is to solve the problem in the prior art that material procurement demand has seasonal changes, and the existing material procurement management system cannot accurately capture these seasonal changes, resulting in inaccurate prediction results, and to propose a material procurement management system and method.

[0005] In order to achieve the above object, the present invention adopts the following technical solutions:

[0006] A material procurement management system, comprising:

[0007] Historical data aggregation and analysis module: aggregates historical data on material procurement, including procurement records, material usage, supplier information, etc., uses data analysis tools to analyze historical data, identifies problems and improvement points in the procurement process, and transmits the historical data to the intelligent procurement plan formulation and demand forecasting module and the arrival plan formulation and inventory management module;

[0008] Intelligent procurement plan formulation and demand forecasting module: formulate procurement plans based on historical data and real-time demand, and predict future demand. Combined with industry characteristics and seasonal factors, a seasonal demand forecasting model is built based on ARIMA. Based on the forecast results and corporate strategies, multiple procurement plans are automatically generated for decision makers to choose from. The procurement plan includes procurement quantity, procurement time, and supplier selection. The procurement plan selected by the decision maker serves as the basis for the formulation of the arrival plan.

[0009] Arrival planning and inventory management module: real-time monitoring of inventory status, determination of real-time demand, summary of procurement plans and demands, and formulation of arrival plans based on warehouse capacity;

[0010] Procurement demand adjustment module: Count the actual quantity of delivered materials, adjust the procurement demand based on the first inspection pass rate of the batch, and feed the adjusted procurement demand back to the seasonal change demand forecasting model;

[0011] Emergency demand plan processing module: determines whether a temporary demand plan is an emergency demand plan, and quickly adjusts the procurement plan according to the degree of urgency, provides an emergency procurement channel, and ensures that emergency needs are met in a timely manner. The emergency demand plan processing module adjusts the procurement plan according to the emergency needs, and feeds the adjustment results back to the seasonal change demand forecasting model;

[0012] Arrived materials performance test and project fund update module: Perform performance tests on the arrived materials to ensure that the quality of the materials meets the standards. The performance test results will be used as the basis for adjusting the procurement requirements. The project funds will be updated according to the performance test results to reflect the impact of material procurement on the project budget;

[0013] Sub-warehouse distribution plan formulation and real-time adjustment module: Use multi-objective optimization to formulate sub-warehouse distribution plans based on different regions and arrival plans to ensure that materials are delivered to designated locations on time and in quantity. Combined with real-time distribution conditions, the distribution plan can be locked or unlocked to achieve flexible adjustment of the distribution plan. In emergency situations, it responds to emergency needs plans to ensure that emergency materials are delivered as soon as possible.

[0014] The above technical solution further includes:

[0015] Furthermore, the historical data summary and analysis module includes a data collection unit, a data storage unit, a data analysis unit, a data visualization unit and a data transmission unit. The data collection unit is responsible for collecting historical data of material procurement from multiple sources. The data storage unit is used to store the integrated historical data for subsequent analysis and query. The data analysis unit uses data analysis tools to analyze historical data and generate analysis results. The data visualization unit visualizes the analysis results in the form of charts, reports, etc. The data transmission unit is responsible for transmitting the processed historical data and analysis results to the intelligent procurement plan formulation and demand forecasting module and the arrival plan formulation and inventory management module. The data collection unit transmits the collected historical data to the data storage unit for storage. The data analysis unit obtains the required historical data from the data storage unit for analysis. The data analysis unit transmits the analysis results to the data visualization unit for visual display. Users view the analysis results through the data visualization unit to understand the procurement situation and make decisions.

[0016] Furthermore, the intelligent procurement plan formulation and demand forecasting module includes a data collection unit, a data analysis and forecasting unit, a procurement plan formulation unit and a monitoring and optimization unit. The data collection unit is responsible for collecting historical procurement data, real-time demand data and industry-related information from multiple data sources. The data analysis and forecasting unit constructs a seasonal demand forecasting model based on the data collected by the data collection unit. The procurement plan formulation unit generates a procurement plan based on the forecast results and the company's procurement strategy. The monitoring and optimization unit is responsible for monitoring the execution of the procurement plan and promptly discovering and solving problems.

[0017] Furthermore, the specific steps of constructing the seasonal variation demand forecasting model are:

[0018] Data collection and preprocessing: Collect historical sales data, including time series data (such as monthly, quarterly or annual sales) and other factors that may affect sales (such as promotional activities, market competition, etc.), collect industry-related seasonal data, such as holidays, seasonal consumption trends, etc., clean the data, remove outliers and missing values, standardize or normalize the data to eliminate the impact of different dimensions, and convert time series data into a format suitable for model processing, such as time series difference or logarithmic transformation;

[0019] Feature selection and extraction: Extract seasonal features, such as months, quarters, holidays, etc. For holidays, further extract the time period features before, during, and after the holidays. According to industry characteristics, select other features that affect demand, such as promotional activities, product life cycle, etc.;

[0020] Model construction and training: Based on ARIMA, a seasonal demand forecasting model is constructed. Seasonal characteristics and other relevant characteristics are introduced into the model. The model is trained using historical data. Model parameters are adjusted to minimize the forecast error. Cross-validation is used to evaluate the performance of the model during the training process. The calculation formula of ARIMA is:

[0021] Y t =φ1Y t-1 +φ2Y t-2 +…+φ p Y t-p +∈ t -θ1∈ t-1 -θ2∈ t-2 …―θ q ∈ t-q

[0022] Among them, Y t is the observed value at time t, φ1, φ2, ..., φ p are the autoregressive coefficients, θ1, θ2, ..., θq is the moving average coefficient, ∈ t is the white noise error term;

[0023] Model optimization and verification: Optimize the model based on the training results, such as adjusting feature weights, adding regularization terms, etc. Use the validation data set to verify the model, evaluate the model's prediction performance, and evaluate the model's performance by calculating indicators such as prediction error and accuracy.

[0024] Forecasting and adjustment: Use the trained model to forecast demand in the future. The forecast results include the impact of seasonal changes. The forecast results are adjusted and optimized in real time according to real-time demand and market changes.

[0025] Furthermore, the arrival plan formulation and inventory management module includes an inventory monitoring unit, a demand determination unit, a procurement plan summary unit, an arrival plan formulation unit and an inventory management optimization unit. The inventory monitoring unit is responsible for real-time monitoring of the inventory status of each warehouse of the enterprise, including information such as the type, quantity, and storage location of materials. At the same time, it issues early warnings for inventory changes and promptly reminds the enterprise to take corresponding measures. The demand determination unit determines the real-time material demand based on factors such as the enterprise's production plan, sales plan, and market changes. This unit needs to be closely integrated with the enterprise's production planning system, sales management system, etc. to achieve real-time data sharing and synchronization. The procurement plan summary unit summarizes the procurement plans and demands of various departments to form a unified procurement demand list. At the same time, it tracks and monitors the execution of the procurement plan to ensure that the procurement plan can be completed on time and in quantity. The arrival plan formulation unit combines the warehouse's capacity, transportation conditions, and the supplier's supply capacity to formulate a scientific and reasonable arrival plan. The arrival plan needs to specify information such as the type, quantity, arrival time and transportation method of the materials. The inventory management optimization unit analyzes the inventory data to discover the problems and bottlenecks in inventory management and puts forward corresponding optimization suggestions. The inventory monitoring unit passes the inventory data monitored in real time to the demand determination unit as a basis for determining the real-time demand. The demand determination unit passes the determined real-time demand to the procurement plan summary unit as a reference for formulating the procurement plan. The procurement plan summary unit passes the summarized procurement demand list to the arrival plan formulation unit as a basis for formulating the arrival plan. When formulating the arrival plan, the arrival plan formulation unit considers the optimization suggestions put forward by the inventory management optimization unit to ensure the scientificity and rationality of the arrival plan. The inventory management optimization unit analyzes the inventory data to discover the problems and bottlenecks in inventory management, and feeds back the analysis results to the arrival plan formulation unit and the procurement plan summary unit so as to make corresponding adjustments and optimizations to the arrival plan and the procurement plan.

[0026] Furthermore, the procurement demand adjustment module includes an arrival quantity statistics unit, a batch first inspection pass rate analysis unit, a procurement demand adjustment unit and a seasonal change demand forecasting model optimization unit. The arrival quantity statistics unit is responsible for real-time statistics of the quantity of arrived materials, and provides it to the batch first inspection pass rate analysis unit and the procurement demand adjustment unit for use. The batch first inspection pass rate analysis unit performs a first inspection on the arrived batch, and statistics the pass rate, and provides the analysis result to the procurement demand adjustment unit as a basis for adjusting the procurement demand. The procurement demand adjustment unit adjusts the procurement demand according to the data provided by the arrival quantity statistics unit and the batch first inspection pass rate analysis unit, and the adjusted procurement demand will be fed back to the seasonal change demand forecasting model optimization unit. The seasonal change demand forecasting model optimization unit receives the adjusted procurement demand data provided by the procurement demand adjustment unit, and optimizes the seasonal change demand forecasting model to improve the accuracy of the prediction.

[0027] Furthermore, the emergency demand plan processing module includes an emergency demand judgment unit, a procurement plan adjustment unit, an emergency procurement channel management unit, and an adjustment result feedback unit. The emergency demand judgment unit is responsible for judging whether a temporary demand plan is an emergency demand plan. This unit needs to make a comprehensive consideration based on multiple factors such as the actual needs, production plan, and inventory status of the enterprise, and give a judgment result. The procurement plan adjustment unit quickly adjusts the original procurement plan according to the judgment result of the emergency demand judgment unit. The adjustment may include procurement quantity, procurement time, supplier selection, and other aspects. At the same time, the unit also needs to communicate with the enterprise's procurement management system, supplier The management system and other systems are integrated to realize real-time sharing and synchronization of data. The emergency procurement channel management unit provides a special procurement channel for the emergency need plan to ensure that emergency materials can be purchased as soon as possible. This unit needs to communicate and coordinate with the company's procurement department, suppliers and other parties to ensure the smooth progress of the procurement process. The adjustment result feedback unit feeds the adjusted procurement plan back to the seasonal change demand forecasting model. This unit ensures that the feedback data is accurate and can be received and processed by the seasonal change demand forecasting model. At the same time, the unit also tracks and monitors the feedback results to ensure that the model can be updated and optimized according to actual conditions.

[0028] Furthermore, the arrival material performance test and project fund update module includes a performance test unit, a result analysis unit, a procurement demand adjustment unit, a project fund update unit and a financial management unit. The performance test unit is responsible for the performance test of the arrival materials, including the preparation of test equipment, the formulation of test methods, the execution of the test process and the recording of test results. The result analysis unit analyzes the test results provided by the performance test unit to evaluate whether the performance of the materials meets the standards. If the test results are unqualified, it is necessary to promptly notify the procurement department and relevant suppliers. The procurement demand adjustment unit adjusts and optimizes the procurement requirements according to the performance test results provided by the result analysis unit. The adjustment content may include procurement quantity, procurement time, supplier selection and other aspects. The project fund update unit updates and adjusts the project funds according to the performance test results and the adjustment plan provided by the procurement demand adjustment unit. The updated project funds will reflect the impact of material procurement on the project budget. The financial management unit works closely with the project fund update unit to ensure the accuracy and compliance of the project funds. The financial management unit is responsible for the disbursement, accounting and supervision of funds to ensure the rational use and effective management of project funds.

[0029] Furthermore, the sub-warehouse distribution plan formulation and real-time adjustment module includes a plan formulation unit, a real-time monitoring unit, an adjustment execution unit, a locking and unlocking unit, and an emergency response unit. The plan formulation unit is responsible for formulating a detailed sub-warehouse distribution plan based on the arrival plan and the demand situation in each region. The plan formulation unit interacts with the arrival plan formulation and inventory management module and the emergency demand plan processing module to obtain the latest arrival information and demand information. The real-time monitoring unit is responsible for real-time tracking and monitoring the distribution process to understand the progress, status and possible problems of distribution. The unit is integrated with the distribution management system, logistics information system, etc. to realize real-time sharing and synchronization of data. The adjustment execution unit is based on the data provided by the real-time monitoring unit. and feedback, adjust the distribution plan, the unit communicates and coordinates with other relevant departments and personnel, such as distribution personnel, warehouse managers, etc., to ensure that the adjusted distribution plan can be smoothly implemented. The locking and unlocking unit is responsible for the locking and unlocking operations of the distribution plan. After the distribution plan is determined, the locking and unlocking unit will lock the distribution plan to prevent it from being accidentally modified or deleted. When the distribution plan needs to be modified, the locking and unlocking unit will unlock it and make corresponding adjustments. In an emergency, the emergency response unit is responsible for quickly responding to the emergency need plan to ensure that emergency materials can be delivered to the designated location as soon as possible. This unit needs to conduct emergency communication and coordination with other relevant departments and personnel, such as the procurement department, suppliers, etc., to ensure the timely procurement and distribution of emergency materials.

[0030] A management method for a material procurement management system comprises the following steps:

[0031] Demand analysis and plan formulation: Each department or project team submits material demand applications to the procurement department based on actual needs. The procurement department summarizes the needs and communicates with relevant departments to ensure the accuracy and completeness of the needs. The procurement department uses the data from the historical data summary and analysis module and the seasonal demand forecasting model provided by the intelligent procurement plan formulation and demand forecasting module to forecast and analyze material needs. Based on the forecast results, a preliminary procurement plan is formulated, including the types, quantities, and expected arrival times of the purchased materials.

[0032] Supplier selection and evaluation: Screen out qualified suppliers from the supplier database and conduct qualification review on qualified suppliers, including business license, production license, quality management system certification, etc. Through on-site inspection, sample testing, price comparison, etc., conduct a comprehensive evaluation on the supply capacity, product quality, price level, after-sales service, etc. of qualified suppliers. Based on the evaluation results, select the best supplier as a partner;

[0033] Signing and execution of procurement contracts: Signing procurement contracts with selected suppliers to clarify the rights and obligations of both parties, including material names, specifications, quantities, prices, delivery times, payment methods, etc., ensuring that the contract content complies with relevant laws and regulations and company policies, tracking the execution of contracts, including the supplier's production progress, delivery status, etc., communicating with suppliers in a timely manner, and resolving problems that may arise during the performance of the contract;

[0034] Arrival acceptance and inventory management: Acceptance of arrived materials, check whether the quantity, specifications, quality, etc. meet the contract requirements. If any problems are found, communicate with suppliers in a timely manner and negotiate solutions. Real-time monitoring and management of inventory materials are carried out through the arrival plan formulation and inventory management module. According to the inventory situation, the procurement plan and arrival plan are adjusted to ensure the reasonable storage and turnover of inventory materials;

[0035] Performance testing and fund update: Perform performance testing on the incoming materials to ensure that the quality of the materials meets the company standards and project requirements. Feedback the performance test results to the procurement demand adjustment and optimization module as a reference for subsequent procurement. Update the project fund budget based on the performance test results and project fund usage to ensure the rational use and effective management of funds, and provide guarantee for the smooth progress of the project.

[0036] Emergency plan processing: When encountering an emergency, the emergency plan processing module is activated to quickly adjust the procurement plan and delivery plan to ensure that emergency materials can be delivered to the designated location as soon as possible. The implementation of the emergency plan is tracked and evaluated, and lessons learned are summarized to provide reference for future emergency needs processing;

[0037] Supplier evaluation and feedback: Regularly conduct performance evaluations on suppliers, including supply quality, delivery time, price level, after-sales service, etc. According to the evaluation results, classify and manage suppliers, optimize the supplier structure, and feedback the performance evaluation results to suppliers to encourage them to improve and enhance. Maintain communication and cooperation with suppliers to jointly promote the continuous improvement and optimization of procurement management.

[0038] The present invention has the following beneficial effects:

[0039] 1. In the present invention, a seasonal change demand forecasting model is introduced. Combining industry characteristics and seasonal factors, it can more accurately predict future material procurement needs, which helps companies prepare in advance and avoid inventory backlogs or shortages, thereby reducing costs and improving operational efficiency.

[0040] 2. In the present invention, an emergency procurement mechanism is established to determine whether a temporary demand plan is an emergency demand plan, and to quickly adjust the procurement plan according to the degree of urgency, which helps enterprises ensure that emergency needs are met in a timely manner and improve customer satisfaction and operational efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0041] Figure 1 This is a system block diagram of a material procurement management system and method proposed by the present invention;

[0042] Figure 2 The present invention provides a flow chart of a material procurement management system and method. DETAILED DESCRIPTION

[0043] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only 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.

[0044] See also Figure 1-Figure 2 As shown, the present invention is a material procurement management system, comprising:

[0045] Historical data aggregation and analysis module: aggregates historical data on material procurement, including procurement records, material usage, supplier information, etc., uses data analysis tools to analyze historical data, identifies problems and improvement points in the procurement process, and transmits the historical data to the intelligent procurement plan formulation and demand forecasting module and the arrival plan formulation and inventory management module;

[0046] Intelligent procurement plan formulation and demand forecasting module: formulate procurement plans based on historical data and real-time demand, and predict future demand. Combined with industry characteristics and seasonal factors, a seasonal demand forecasting model is built based on ARIMA. Based on the forecast results and corporate strategies, multiple procurement plans are automatically generated for decision makers to choose from. The procurement plan includes procurement quantity, procurement time, and supplier selection. The procurement plan selected by the decision maker serves as the basis for the formulation of the arrival plan.

[0047] Arrival planning and inventory management module: real-time monitoring of inventory status, determination of real-time demand, summary of procurement plans and demands, and formulation of arrival plans based on warehouse capacity;

[0048] Procurement demand adjustment module: Count the actual quantity of delivered materials, adjust the procurement demand based on the first inspection pass rate of the batch, and feed the adjusted procurement demand back to the seasonal change demand forecasting model;

[0049] Emergency demand plan processing module: determines whether a temporary demand plan is an emergency demand plan, and quickly adjusts the procurement plan according to the degree of urgency, provides an emergency procurement channel, and ensures that emergency needs are met in a timely manner. The emergency demand plan processing module adjusts the procurement plan according to the emergency needs, and feeds the adjustment results back to the seasonal change demand forecasting model;

[0050] Arrived materials performance test and project fund update module: Perform performance tests on the arrived materials to ensure that the quality of the materials meets the standards. The performance test results will be used as the basis for adjusting the procurement requirements. The project funds will be updated according to the performance test results to reflect the impact of material procurement on the project budget;

[0051] Sub-warehouse distribution plan formulation and real-time adjustment module: Use multi-objective optimization to formulate sub-warehouse distribution plans based on different regions and arrival plans to ensure that materials are delivered to designated locations on time and in quantity. Combined with real-time distribution conditions, the distribution plan can be locked or unlocked to achieve flexible adjustment of the distribution plan. In emergency situations, it responds to emergency needs plans to ensure that emergency materials are delivered as soon as possible.

[0052] In one embodiment, for the above-mentioned historical data summary and analysis module, the historical data summary and analysis module includes a data acquisition unit, a data storage unit, a data analysis unit, a data visualization unit and a data transmission unit. The data acquisition unit is responsible for collecting historical data of material procurement from multiple sources. The data storage unit is used to store the integrated historical data for subsequent analysis and query. The data analysis unit uses data analysis tools to analyze historical data and generate analysis results. The data visualization unit visualizes the analysis results in the form of charts, reports, etc. The data transmission unit is responsible for transmitting the processed historical data and analysis results to the intelligent procurement plan formulation and demand forecasting module and the arrival plan formulation and inventory management module. The data acquisition unit transmits the collected historical data to the data storage unit for storage. The data analysis unit obtains the required historical data from the data storage unit for analysis. The data analysis unit transmits the analysis results to the data visualization unit for visual display. Users view the analysis results through the data visualization unit to understand the procurement situation and make decisions.

[0053] In one embodiment, for the above-mentioned intelligent procurement plan formulation and demand forecasting module, the intelligent procurement plan formulation and demand forecasting module includes a data collection unit, a data analysis and forecasting unit, a procurement plan formulation unit and a monitoring and optimization unit. The data collection unit is responsible for collecting historical procurement data, real-time demand data and industry-related information from multiple data sources. The data analysis and forecasting unit builds a seasonal demand forecasting model based on the data collected by the data collection unit. The procurement plan formulation unit generates a procurement plan based on the forecast results and the company's procurement strategy. The monitoring and optimization unit is responsible for monitoring the execution of the procurement plan and promptly discovering and solving problems.

[0054] In one embodiment, for the seasonal variation demand forecasting model, the specific steps of constructing the seasonal variation demand forecasting model are:

[0055] Data collection and preprocessing: Collect historical sales data, including time series data (such as monthly, quarterly or annual sales) and other factors that may affect sales (such as promotional activities, market competition, etc.), collect industry-related seasonal data, such as holidays, seasonal consumption trends, etc., clean the data, remove outliers and missing values, standardize or normalize the data to eliminate the impact of different dimensions, and convert time series data into a format suitable for model processing, such as time series difference or logarithmic transformation;

[0056] Feature selection and extraction: Extract seasonal features, such as months, quarters, holidays, etc. For holidays, further extract the time period features before, during, and after the holidays. According to industry characteristics, select other features that affect demand, such as promotional activities, product life cycle, etc.;

[0057] Model construction and training: Based on ARIMA, a seasonal demand forecasting model is constructed. Seasonal characteristics and other relevant characteristics are introduced into the model. The model is trained using historical data. Model parameters are adjusted to minimize the forecast error. Cross-validation is used to evaluate the performance of the model during the training process. The calculation formula of ARIMA is:

[0058] Y t =φ1Y t-1 +φ2Y t-2 +…+φ p Y t-p +∈ t -θ1∈ t-1 -θ2∈ t-2 …-θ q ∈ t-q

[0059] Among them, Y t is the observed value at time t, φ1, φ2, ..., φ p are the autoregressive coefficients, θ1, θ2, ..., θ q is the moving average coefficient, ∈ t is the white noise error term;

[0060] Model optimization and verification: Optimize the model based on the training results, such as adjusting feature weights, adding regularization terms, etc. Use the validation data set to verify the model, evaluate the model's prediction performance, and evaluate the model's performance by calculating indicators such as prediction error and accuracy.

[0061] Prediction and adjustment: Use the trained model to predict demand in the future. The forecast results include the impact of seasonal changes. According to real-time demand and market changes, the forecast results are adjusted and optimized in real time.

[0062] Data Collection: Collect monthly sales data for the past few years, as well as holiday information.

[0063] Data preprocessing: Clean and standardize the data and extract seasonal characteristics (such as months, holidays, etc.).

[0064] Model construction: SARIMA model is selected as the forecasting model, and seasonal characteristics are introduced.

[0065] Model training: Use historical data to train the model and adjust model parameters.

[0066] Model validation: Use the validation dataset to validate the model and evaluate the prediction performance.

[0067] Forecasting: Use the trained model to predict sales for the next year, including sales during the holiday season.

[0068] Real-time adjustment: Make real-time adjustments and optimizations to forecast results based on real-time sales data and market changes.

[0069] In one embodiment, for the above-mentioned arrival plan formulation and inventory management module, the arrival plan formulation and inventory management module includes an inventory monitoring unit, a demand determination unit, a procurement plan summary unit, an arrival plan formulation unit and an inventory management optimization unit. The inventory monitoring unit is responsible for real-time monitoring of the inventory status of each warehouse of the enterprise, including information such as the type, quantity, and storage location of materials. At the same time, it issues early warnings for inventory changes and promptly reminds the enterprise to take corresponding measures. The demand determination unit determines the real-time material demand based on factors such as the enterprise's production plan, sales plan, and market changes. This unit needs to be closely integrated with the enterprise's production planning system, sales management system, etc. to achieve real-time data sharing and synchronization. The procurement plan summary unit summarizes the procurement plans and demands of various departments to form a unified procurement demand list. At the same time, it tracks and monitors the execution of the procurement plan to ensure that the procurement plan can be completed on time and in quantity. The arrival plan formulation unit combines the warehouse's capacity, transportation conditions, and the supplier's supply capacity to formulate A scientific and reasonable arrival plan is determined. The arrival plan needs to specify the type, quantity, arrival time and transportation method of the materials. The inventory management optimization unit analyzes the inventory data to find the problems and bottlenecks in inventory management and puts forward corresponding optimization suggestions. The inventory monitoring unit passes the inventory data monitored in real time to the demand determination unit as a basis for determining the real-time demand. The demand determination unit passes the determined real-time demand to the procurement plan summary unit as a reference for formulating the procurement plan. The procurement plan summary unit passes the summarized procurement demand list to the arrival plan formulation unit as a basis for formulating the arrival plan. When formulating the arrival plan, the arrival plan formulation unit considers the optimization suggestions put forward by the inventory management optimization unit to ensure the scientificity and rationality of the arrival plan. The inventory management optimization unit analyzes the inventory data to find the problems and bottlenecks in inventory management, and feeds back the analysis results to the arrival plan formulation unit and the procurement plan summary unit so as to make corresponding adjustments and optimizations to the arrival plan and the procurement plan.

[0070] In one embodiment, for the above-mentioned procurement demand adjustment module, the procurement demand adjustment module includes an arrival quantity statistics unit, a batch first inspection pass rate analysis unit, a procurement demand adjustment unit and a seasonal change demand forecasting model optimization unit. The arrival quantity statistics unit is responsible for real-time statistics of the quantity of arrived materials, and provides it to the batch first inspection pass rate analysis unit and the procurement demand adjustment unit for use. The batch first inspection pass rate analysis unit performs a first inspection on the arrived batch, and statistics the pass rate, and provides the analysis result to the procurement demand adjustment unit as a basis for adjusting the procurement demand. The procurement demand adjustment unit adjusts the procurement demand according to the data provided by the arrival quantity statistics unit and the batch first inspection pass rate analysis unit, and the adjusted procurement demand will be fed back to the seasonal change demand forecasting model optimization unit. The seasonal change demand forecasting model optimization unit receives the adjusted procurement demand data provided by the procurement demand adjustment unit, and optimizes the seasonal change demand forecasting model to improve the accuracy of the prediction.

[0071] In one embodiment, for the above-mentioned emergency demand plan processing module, the emergency demand plan processing module includes an emergency demand judgment unit, a procurement plan adjustment unit, an emergency procurement channel management unit and an adjustment result feedback unit. The emergency demand judgment unit is responsible for judging whether a temporary demand plan is an emergency demand plan. This unit needs to comprehensively consider multiple factors such as the actual needs, production plan and inventory status of the enterprise and give a judgment result. The procurement plan adjustment unit quickly adjusts the original procurement plan according to the judgment result of the emergency demand judgment unit. The adjustment content may include procurement quantity, procurement time, supplier selection and other aspects. At the same time, the unit also needs to communicate with the enterprise The procurement management system, supplier management system and other systems are integrated to achieve real-time sharing and synchronization of data. The emergency procurement channel management unit provides a special procurement channel for emergency needs plans to ensure that emergency materials can be purchased as soon as possible. This unit needs to communicate and coordinate with the company's procurement department, suppliers and other parties to ensure the smooth progress of the procurement process. The adjustment result feedback unit feeds the adjusted procurement plan back to the seasonal demand forecasting model. This unit ensures that the feedback data is accurate and can be received and processed by the seasonal demand forecasting model. At the same time, the unit also tracks and monitors the feedback results to ensure that the model can be updated and optimized according to actual conditions.

[0072] In one embodiment, for the above-mentioned arrival material performance test and project fund update module, the arrival material performance test and project fund update module includes a performance test unit, a result analysis unit, a procurement demand adjustment unit, a project fund update unit and a financial management unit. The performance test unit is responsible for the performance test of the arrival materials, including the preparation of test equipment, the formulation of test methods, the execution of the test process and the recording of test results. The result analysis unit analyzes the test results provided by the performance test unit to evaluate whether the performance of the materials meets the standards. If the test results are unqualified, it is necessary to promptly notify the procurement department and relevant suppliers. The procurement demand adjustment unit adjusts and optimizes the procurement requirements according to the performance test results provided by the result analysis unit. The adjustment content may include multiple aspects such as procurement quantity, procurement time, and supplier selection. The project fund update unit updates and adjusts the project funds according to the performance test results and the adjustment plan provided by the procurement demand adjustment unit. The updated project funds will reflect the impact of material procurement on the project budget. The financial management unit works closely with the project fund update unit to ensure the accuracy and compliance of the project funds. The financial management unit is responsible for the disbursement, accounting and supervision of funds to ensure the reasonable use and effective management of project funds.

[0073] In one embodiment, for the above-mentioned branch warehouse distribution plan formulation and real-time adjustment module, the branch warehouse distribution plan formulation and real-time adjustment module includes a plan formulation unit, a real-time monitoring unit, an adjustment execution unit, a locking and unlocking unit and an emergency response unit. The plan formulation unit is responsible for formulating a detailed branch warehouse distribution plan according to the arrival plan and the demand situation in each region. The plan formulation unit interacts with the arrival plan formulation and inventory management module and the emergency demand plan processing module to obtain the latest arrival information and demand information. The real-time monitoring unit is responsible for real-time tracking and monitoring the distribution process to understand the progress, status and possible problems of the distribution. The unit is integrated with the distribution management system, the logistics information system, etc. to realize real-time sharing and synchronization of data. The adjustment execution unit The distribution plan is adjusted according to the data and feedback provided by the real-time monitoring unit. The unit communicates and coordinates with other relevant departments and personnel, such as distribution personnel, warehouse managers, etc., to ensure that the adjusted distribution plan can be smoothly executed. The locking and unlocking unit is responsible for the locking and unlocking operations of the distribution plan. After the distribution plan is determined, the locking and unlocking unit locks the distribution plan to prevent it from being accidentally modified or deleted. When the distribution plan needs to be modified, the locking and unlocking unit unlocks it and makes corresponding adjustments. In an emergency, the emergency response unit is responsible for quickly responding to the emergency need plan to ensure that emergency materials can be delivered to the designated location as soon as possible. The unit needs to communicate and coordinate urgently with other relevant departments and personnel, such as the procurement department, suppliers, etc., to ensure the timely procurement and distribution of emergency materials.

[0074] A management method for a material procurement management system comprises the following steps:

[0075] Demand analysis and plan formulation: Each department or project team submits material demand applications to the procurement department based on actual needs. The procurement department summarizes the needs and communicates with relevant departments to ensure the accuracy and completeness of the needs. The procurement department uses the data from the historical data summary and analysis module and the seasonal demand forecasting model provided by the intelligent procurement plan formulation and demand forecasting module to forecast and analyze material needs. Based on the forecast results, a preliminary procurement plan is formulated, including the types, quantities, and expected arrival times of the purchased materials.

[0076] Supplier selection and evaluation: Screen out qualified suppliers from the supplier database and conduct qualification review on qualified suppliers, including business license, production license, quality management system certification, etc. Through on-site inspection, sample testing, price comparison, etc., conduct a comprehensive evaluation on the supply capacity, product quality, price level, after-sales service, etc. of qualified suppliers. Based on the evaluation results, select the best supplier as a partner;

[0077] Signing and execution of procurement contracts: Signing procurement contracts with selected suppliers to clarify the rights and obligations of both parties, including material names, specifications, quantities, prices, delivery times, payment methods, etc., ensuring that the contract content complies with relevant laws and regulations and company policies, tracking the execution of contracts, including the supplier's production progress, delivery status, etc., communicating with suppliers in a timely manner, and resolving problems that may arise during the performance of the contract;

[0078] Arrival acceptance and inventory management: Acceptance of arrived materials, check whether the quantity, specifications, quality, etc. meet the contract requirements. If any problems are found, communicate with suppliers in a timely manner and negotiate solutions. Real-time monitoring and management of inventory materials are carried out through the arrival plan formulation and inventory management module. According to the inventory situation, the procurement plan and arrival plan are adjusted to ensure the reasonable storage and turnover of inventory materials;

[0079] Performance testing and fund update: Perform performance testing on the incoming materials to ensure that the quality of the materials meets the company standards and project requirements. Feedback the performance test results to the procurement demand adjustment and optimization module as a reference for subsequent procurement. Update the project fund budget based on the performance test results and project fund usage to ensure the rational use and effective management of funds, and provide guarantee for the smooth progress of the project.

[0080] Emergency plan processing: When encountering an emergency, the emergency plan processing module is activated to quickly adjust the procurement plan and delivery plan to ensure that emergency materials can be delivered to the designated location as soon as possible. The implementation of the emergency plan is tracked and evaluated, and lessons learned are summarized to provide reference for future emergency needs processing;

[0081] Supplier evaluation and feedback: Regularly conduct performance evaluations on suppliers, including supply quality, delivery time, price level, after-sales service, etc. According to the evaluation results, classify and manage suppliers, optimize the supplier structure, and feedback the performance evaluation results to suppliers to encourage them to improve and enhance. Maintain communication and cooperation with suppliers to jointly promote the continuous improvement and optimization of procurement management.

[0082] Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that various changes, modifications, substitutions and variations may be made to the embodiments without departing from the principles and spirit of the present invention, and that the scope of the present invention is defined by the appended claims and their equivalents.

Claims

1. A material procurement management system, characterized in that: include: Historical data aggregation and analysis module: aggregates historical data of material procurement, uses Hadoop to analyze historical data, identifies problems and improvement points in the procurement process, and transmits the historical data to the intelligent procurement plan formulation and demand forecasting module and the arrival plan formulation and inventory management module; Intelligent procurement plan formulation and demand forecasting module: formulate procurement plans based on historical data and real-time demand, and predict future demand. Combined with industry characteristics and seasonal factors, a seasonal demand forecasting model is built based on ARIMA. Based on the forecast results and corporate strategies, multiple procurement plans are automatically generated for decision makers to choose from. The procurement plan includes procurement quantity, procurement time, and supplier selection. The procurement plan selected by the decision maker serves as the basis for the formulation of the arrival plan. Arrival planning and inventory management module: real-time monitoring of inventory status, determination of real-time demand, summary of procurement plans and demands, and formulation of arrival plans based on warehouse capacity; Procurement demand adjustment module: Count the actual quantity of delivered materials, adjust the procurement demand based on the first inspection pass rate of the batch, and feed the adjusted procurement demand back to the seasonal change demand forecasting model; Emergency demand plan processing module: determines whether a temporary demand plan is an emergency demand plan, adjusts the procurement plan according to the degree of urgency, and provides an emergency procurement channel. The emergency demand plan processing module adjusts the procurement plan according to the emergency demand, and feeds the adjustment result back to the seasonal change demand forecasting model; Arrived materials performance test and project fund update module: Perform performance test on the arrived materials. The performance test results will be used as the basis for adjusting the procurement demand. The project funds will be updated according to the performance test results to reflect the impact of material procurement on the project budget. Sub-warehouse distribution plan formulation and real-time adjustment module: formulate sub-warehouse distribution plans based on different regions and arrival plans using multi-objective optimization, lock or unlock distribution plans based on real-time distribution conditions, and respond to emergency plans in emergency situations.

2. A material procurement management system according to claim 1, characterized in that: The historical data summary and analysis module includes a data collection unit, a data storage unit, a data analysis unit, a data visualization unit and a data transmission unit. The data collection unit is responsible for collecting historical data of material procurement from multiple sources. The data storage unit is used to store integrated historical data. The data analysis unit uses data analysis tools to analyze historical data and generate analysis results. The data visualization unit visualizes the analysis results. The data transmission unit is responsible for transmitting the processed historical data and analysis results to the intelligent procurement plan formulation and demand forecasting module and the arrival plan formulation and inventory management module. The data collection unit transmits the collected historical data to the data storage unit for storage. The data analysis unit obtains the required historical data from the data storage unit for analysis. The data analysis unit transmits the analysis results to the data visualization unit for visualization. Users view the analysis results through the data visualization unit.

3. A material procurement management system according to claim 1, characterized in that: The intelligent procurement plan formulation and demand forecasting module includes a data collection unit, a data analysis and forecasting unit, a procurement plan formulation unit and a monitoring and optimization unit. The data collection unit is responsible for collecting historical procurement data, real-time demand data and industry-related information from multiple data sources. The data analysis and forecasting unit constructs a seasonal demand forecasting model based on the data collected by the data collection unit. The procurement plan formulation unit generates a procurement plan based on the forecast results and the company's procurement strategy. The monitoring and optimization unit is responsible for monitoring the execution of the procurement plan.

4. A material procurement management system according to claim 3, characterized in that: The specific steps of constructing the seasonal variation demand forecasting model are: Data collection and preprocessing: Collect historical sales data, collect industry-related seasonal data, clean the data, remove outliers and missing values, standardize or normalize the data, and convert time series data into a format suitable for model processing; Feature selection and extraction: Extract seasonal features. For holidays, further extract the time period features before, during, and after the holidays. Select other features that affect demand based on industry characteristics. Model construction and training: Based on ARIMA, a seasonal demand forecasting model is constructed. Seasonal characteristics and other relevant characteristics are introduced into the model. The model is trained using historical data. Model parameters are adjusted to minimize the forecast error. Cross-validation is used to evaluate the performance of the model during the training process. The calculation formula of ARIMA is: Y t =φ1Y t-1 +φ2Y t-2 +…+φ P Y t-p +e t -θ l ∈ t-l -θ2∈ t-2 -…-θ q ∈ t-q Among them, Y t is the observed value at time t, φ1, φ2, ..., φ p are the autoregressive coefficients, θ1, θ2, ..., θ q is the moving average coefficient, ∈ t is the white noise error term; Model optimization and validation: Optimize the model based on the training results, validate the model using the validation data set, and evaluate the model’s predictive performance; Forecasting and adjustment: Use the trained model to forecast demand in the future. The forecast results include the impact of seasonal changes. The forecast results are adjusted and optimized in real time according to real-time demand and market changes.

5. A material procurement management system according to claim 1, characterized in that: The arrival plan formulation and inventory management module includes an inventory monitoring unit, a demand determination unit, a procurement plan summary unit, an arrival plan formulation unit and an inventory management optimization unit. The inventory monitoring unit is responsible for real-time monitoring of the inventory status of each warehouse of the enterprise and, at the same time, issuing early warnings for inventory changes. The demand determination unit determines the real-time material demand. The procurement plan summary unit summarizes the procurement plans and demands of various departments to form a unified procurement demand list and, at the same time, tracks and monitors the execution of the procurement plan. The arrival plan formulation unit formulates an arrival plan based on the warehouse's capacity, transportation conditions and the supplier's supply capacity. The inventory management optimization unit calculates the inventory data and calculates the delivery status of the goods. According to the analysis, problems and bottlenecks in inventory management are discovered. The inventory monitoring unit transmits the real-time monitored inventory data to the demand determination unit. The demand determination unit transmits the determined real-time demand to the procurement plan summary unit as a reference for formulating the procurement plan. The procurement plan summary unit transmits the summarized procurement demand list to the arrival plan formulation unit as a basis for formulating the arrival plan. When formulating the arrival plan, the arrival plan formulation unit considers the optimization suggestions put forward by the inventory management optimization unit. The inventory management optimization unit discovers the problems and bottlenecks in inventory management by analyzing the inventory data, and feeds back the analysis results to the arrival plan formulation unit and the procurement plan summary unit.

6. A material procurement management system according to claim 3, characterized in that: The procurement demand adjustment module includes an arrival quantity statistics unit, a batch first inspection pass rate analysis unit, a procurement demand adjustment unit and a seasonal change demand forecasting model optimization unit. The arrival quantity statistics unit is responsible for real-time statistics of the quantity of arrived materials, and provides it to the batch first inspection pass rate analysis unit and the procurement demand adjustment unit for use. The batch first inspection pass rate analysis unit performs a first inspection on the arrived batch, and statistics the pass rate, and provides the analysis result to the procurement demand adjustment unit. The procurement demand adjustment unit adjusts the procurement demand based on the data provided by the arrival quantity statistics unit and the batch first inspection pass rate analysis unit, and the adjusted procurement demand is fed back to the seasonal change demand forecasting model optimization unit. The seasonal change demand forecasting model optimization unit receives the adjusted procurement demand data provided by the procurement demand adjustment unit, and optimizes the seasonal change demand forecasting model.

7. A material procurement management system according to claim 1, characterized in that: The emergency demand plan processing module includes an emergency demand judgment unit, a procurement plan adjustment unit, an emergency procurement channel management unit and an adjustment result feedback unit. The emergency demand judgment unit is responsible for judging whether a temporary demand plan is an emergency demand plan. The procurement plan adjustment unit quickly adjusts the original procurement plan according to the judgment result of the emergency demand judgment unit. The emergency procurement channel management unit provides a procurement channel for the emergency demand plan. The adjustment result feedback unit feeds the adjusted procurement plan back to the seasonal change demand forecasting model.

8. A material procurement management system according to claim 1, characterized in that: The arrival materials performance test and project fund update module includes a performance test unit, a result analysis unit, a procurement demand adjustment unit, a project fund update unit and a financial management unit. The performance test unit is responsible for the performance test of the arrival materials. The result analysis unit analyzes the test results provided by the performance test unit to evaluate whether the performance of the materials meets the standards. The procurement demand adjustment unit adjusts and optimizes the procurement demand according to the performance test results provided by the result analysis unit. The project fund update unit updates and adjusts the project funds according to the performance test results and the adjustment plan provided by the procurement demand adjustment unit. The financial management unit works closely with the project fund update unit and is responsible for the disbursement, accounting and supervision of funds.

9. A material procurement management system according to claim 1, characterized in that: The sub-warehouse distribution plan formulation and real-time adjustment module includes a plan formulation unit, a real-time monitoring unit, an adjustment execution unit, a locking and unlocking unit and an emergency response unit. The plan formulation unit is responsible for formulating the sub-warehouse distribution plan according to the arrival plan and the demand situation in each region. The plan formulation unit interacts with the arrival plan formulation and inventory management module and the emergency demand plan processing module to obtain arrival information and demand information. The real-time monitoring unit is responsible for real-time tracking and monitoring the distribution process. The adjustment execution unit adjusts the distribution plan according to the data and feedback provided by the real-time monitoring unit. The locking and unlocking unit is responsible for the locking and unlocking operations of the distribution plan. In an emergency, the emergency response unit is responsible for quickly responding to the emergency demand plan.

10. The management method of a material procurement management system according to claim 1, characterized in that: The following steps are involved: Demand analysis and plan formulation: Submit material demand applications to the procurement department based on actual demand. The procurement department summarizes the demand and uses the data from the historical data summary and analysis module, combined with the seasonal demand forecasting model provided by the intelligent procurement plan formulation and demand forecasting module, to forecast and analyze material demand. Based on the forecast results, a preliminary procurement plan is formulated. Supplier selection and evaluation: Screen out qualified suppliers from the supplier database, conduct qualification review on qualified suppliers, conduct comprehensive evaluation on qualified suppliers, and select suppliers as partners based on the evaluation results; Procurement contract signing and execution: Signing procurement contracts with selected suppliers and tracking the execution of contracts; Arrival acceptance and inventory management: Acceptance of arrived materials, real-time monitoring and management of inventory materials through arrival planning and inventory management modules, and adjustment of procurement plans and arrival plans based on inventory conditions; Performance testing and fund update: Perform performance testing on the delivered materials, and feed back the performance test results to the procurement demand adjustment and optimization module. Update the project fund budget based on the performance test results and project fund usage; Emergency plan processing: When encountering an emergency situation, activate the emergency plan processing module to quickly adjust the procurement plan and arrival plan, and track and evaluate the implementation of the emergency plan.

Images