A procurement plan management system and working method thereof

Abstract

The present invention relates to a procurement plan management system and a working method thereof, and belongs to the technical field of data analysis and processing. The management system and the working method thereof include a data acquisition module and a data processing module; the data acquisition module is used to acquire order data, product processing qualification rate, various data of each sub-level material under each parent material, and corresponding supplier data; the data processing module is used to generate a parent material arrival plan, a parent material priority ranking, and credit scoring for suppliers supplying each sub-level material, and finally generate a procurement plan for each parent material. The present invention can comprehensively determine the optimal procurement plan based on the production, inventory, suppliers, etc. of an enterprise, realize dynamic intelligent management, effectively avoid over-reliance on the experience of purchasers, reduce the labor intensity of purchasers, and effectively reduce procurement costs and procurement risks, which is of great significance to the good operation of an enterprise.

Description

Technical Field

[0001] The present invention relates to the technical field of data analysis and processing, and in particular to a procurement plan management system and a working method thereof. Background Art

[0002] Material procurement is an important part of business operations. Under the premise of ensuring production, optimizing procurement plans is the key to reducing corporate procurement costs and risks. When a company receives a new order and generates a new material arrival plan, one order often corresponds to multiple materials, one material may correspond to multiple products and multiple suppliers, and a supplier may supply multiple materials and multiple products at the same time. Therefore, there is a complex many-to-many relationship between materials, suppliers and products.

[0003] Traditional procurement plans rely heavily on manual experience, and are determined based on production schedules, inventory data, supplier conditions, procurement costs and other factors, which places high demands on purchasers. Due to the influence of human experience and subjective factors, it is not conducive to the good operation of the enterprise. Therefore, there is an urgent need for a scientific, reasonable and highly operational procurement plan management system that can comprehensively determine the optimal procurement plan based on the company's production, inventory, suppliers and other conditions. Summary of the invention

[0004] The purpose of the present invention is to provide a procurement plan management system and a working method thereof, which can comprehensively determine the optimal procurement plan based on the company's production, inventory, suppliers, etc., thereby effectively reducing the company's procurement costs and supply risks.

[0005] In order to achieve the above-mentioned object, the present invention is implemented by adopting the following technical scheme: a procurement plan management system, characterized in that: the procurement plan management system includes a data acquisition module, a data processing module, a procurement plan risk assessment module, a procurement plan adjustment module, a receiving concentration adjustment module, an early warning module, and a data operation and maintenance module;

[0006] The data acquisition module is connected to the data processing module; the data acquisition module is used to obtain order data, product processing qualification rate, theoretical supply ratio of each sub-level material under the parent material, actual supply progress ratio, effective inventory quantity, in-transit quantity, theoretical safety inventory number, arrival qualification rate, arrival on-time rate, full arrival rate and supplier data; the supplier data of each sub-level material includes the minimum supply quantity, full package supply quantity, supply cycle and supply address of the supplier corresponding to each sub-level material for the sub-level material;

[0007] The data processing module is used to calculate the procurement plan for all parent materials based on the information obtained by the data acquisition module; the data processing module includes a parent material arrival plan generation module, a parent material priority sorting module, a supplier reputation scoring module, a procurement plan generation module, a procurement plan risk assessment module, and a procurement plan adjustment module.

[0008] Preferably, the parent material arrival plan generation module is used to determine the production schedule according to the order data and the product processing qualification rate, and calculate the parent material arrival plan according to the production schedule, the effective inventory quantity of each sub-level material, the quantity in transit, the arrival qualification rate, and the theoretical safety stock number; the parent material priority sorting module is used to judge the urgency of each parent material, and sort the sub-level materials according to the length of time available for production before the arrival of each parent material, with the shortest time priority being ranked first and the longest time being ranked last;

[0009] The supplier credit scoring module is used to judge the credit score corresponding to the supplier supplying each sub-level material according to the arrival qualification rate, on-time arrival rate and full arrival rate of each sub-level material;

[0010] The procurement plan generation module is used to make procurement plan according to the priority order of the parent materials obtained by the parent material priority sorting module; first, the procurement plan is made for the parent material with the first priority: the suppliers that meet the arrival requirements are screened according to the supplier data of the sub-materials under the parent material, and then the actual supply ratio of each sub-material that meets the supply demand is calculated according to the theoretical supply ratio and the actual supply progress ratio of each sub-material that meets the supply demand, so as to obtain a preliminary procurement plan; then, the procurement plan is made for the parent material with the second priority according to the above method until the procurement plan for all parent materials is completed.

[0011] Preferably, the procurement plan risk assessment module is connected to the data acquisition module and the data processing module respectively; the procurement plan risk assessment module is used to evaluate whether the procurement plans for each parent material generated by the procurement plan generation module have the risk that the supply of emergency materials is too concentrated on a single supplier. The specific evaluation method is: the total number of parent material types is N, and the parent material priority sorting module sorts them to screen out the top three parent materials, and find out the sub-material suppliers whose procurement volume exceeds 50% in these parent material procurement plans, which are called key suppliers. If there is a supplier that is a key supplier of two or more parent materials at the same time, then it is determined that the procurement plans for each parent material generated by the procurement plan generation module belong to risky procurement plans, the supplier is a risky supplier, and the sub-material becomes a risky sub-material.

[0012] Preferably, the procurement plan adjustment module; the procurement plan adjustment module is connected to the data acquisition module, the data processing module and the procurement plan risk assessment module respectively;

[0013] The procurement plan adjustment module includes a supply concentration adjustment module, which is used to adjust the supply concentration of the procurement plan. The adjustment method is:

[0014] When the procurement plan risk assessment module does not determine that the procurement plans of the parent materials generated by the procurement plan generation module belong to risky procurement plans, the supply concentration adjustment module determines the procurement plans of the parent materials generated by the procurement plan generation module as the final procurement plan;

[0015] When the procurement plan risk assessment module determines that the procurement plans of each parent material generated by the procurement plan generation module belong to risk procurement plans, the supply concentration adjustment module adjusts the procurement plan according to the credit score level of each sub-level material supplied by the risk supplier, and adjusts the procurement quantity of at least one risk sub-level material. The procurement quantity adjustment method is:

[0016] The credit scores of suppliers supplying each sub-level material are divided into four levels: excellent, good, average and poor. The corresponding adjustments for the four levels are -5%, -10%, -15% and -20% of the original purchase volume respectively.

[0017] The reduced purchase volume is then added to the supplier with the highest credit score among the sub-materials that meet the supply demand of the parent material, thereby obtaining the adjusted parent material procurement plan, which is sent to the procurement plan risk assessment module for re-risk assessment; if it is still determined to be a risky procurement plan, the procurement plan adjustment module will continue to adjust it until the risk is eliminated, and a risk-free procurement plan for each parent material is obtained as the final procurement plan.

[0018] Preferably, the procurement plan adjustment module also includes a receipt concentration adjustment module, which is used to calculate the receipt concentration of each sub-level material in the parent material procurement plan within the procurement cycle based on the data of each sub-level material supplier. If it is determined that there is a situation of receipt concentration, the arrival date of individual sub-level materials is adjusted based on the actual utilization rate of the warehouse while meeting the arrival requirements.

[0019] Preferably, the warning information includes a warning icon and warning text. When the procurement plan risk assessment module determines that the procurement plan is a risky procurement plan for 0 times, the warning icon is displayed in green, and the warning text is "safe procurement plan"; when the procurement plan risk assessment module determines that the procurement plan is a risky procurement plan for 1 time, the warning icon is displayed in blue, and the warning text is "one risky procurement plan"; when the procurement plan risk assessment module determines that the procurement plan is a risky procurement plan for 2 times, the warning icon is displayed in orange, and the warning text is "twice risky procurement plans"; when the procurement plan risk assessment module determines that the procurement plan is a risky procurement plan for 3 times or more, the warning icon is displayed in red, and the warning text is "high-risk procurement plan".

[0020] Preferably, the data operation and maintenance module is connected to the data acquisition module; the data operation and maintenance module is used to update the arrival qualification rate, arrival on time rate and full arrival rate of each sub-level material according to the actual arrival situation; update the product processing qualification rate, the effective inventory quantity, in-transit quantity and actual supply progress ratio of each sub-level material according to the actual production and material consumption situation; update the theoretical safety stock quantity and theoretical supply ratio of each sub-level material and the minimum supply quantity, full package supply quantity, supply cycle and supply address of each sub-level material supplier for the sub-level materials according to the actual situation.

[0021] Preferably, the working method comprises the following steps: S110, generating a parent material arrival plan;

[0022] S120, parent material priority sorting;

[0023] S130. Credit score each sub-level material supplied by the supplier;

[0024] S140, generate a procurement plan;

[0025] S150. Conduct risk assessment on procurement plans;

[0026] S160, adjust the procurement plan;

[0027] S170. Provide early warning for risky procurement plans.

[0028] Preferably, in the step of generating a procurement plan in S140, the calculation method of the actual supply ratio of each sub-level material that meets the supply demand is as follows:

[0029] Sub-level materials A1-A that meet supply requirements i The theoretical supply ratio is L1:L2:......:L i , the actual supply progress ratio is M1, M2, ..., M i, when Mi≥(M1+M2+......+M i ) / i, the corresponding sub-level material actual supply ratio is Li*[1-(M1+M2+......+M i ) / i)]; when Mi<(M1+M2+......+M i ) / i, the corresponding sub-level material actual supply ratio is Li*[1+(M1+M2+......+M i ) / i)].

[0030] Preferably, the working method also includes step S180, data operation and maintenance: the data operation and maintenance module updates the arrival qualification rate, arrival time rate, and full arrival rate of each sub-level material according to the actual arrival situation; updates the product processing qualification rate, the effective inventory quantity, the in-transit quantity, and the actual supply progress ratio of each sub-level material according to the actual production and material consumption situation; updates the theoretical safety inventory quantity, theoretical supply ratio of each sub-level material, and the minimum supply quantity, full package supply quantity, supply cycle, and supply address of each sub-level material supplier for the sub-level materials according to the actual situation.

[0031] Beneficial effects of the present invention:

[0032] The present invention prioritizes the parent materials corresponding to the order through the parent material priority sorting module, and rates the reputation of the suppliers supplying the sub-materials through the supplier reputation scoring module. The generated procurement plan takes into account the theoretical supply ratio and actual supply progress ratio of the suppliers supplying the sub-materials, and fully considers the priority of the parent material, the reputation of the suppliers supplying the sub-materials, and the risk of concentrated supply. It can comprehensively determine the optimal procurement plan based on the company's production, inventory, suppliers, etc., realize dynamic intelligent management, effectively avoid over-reliance on the experience of purchasers, reduce the labor intensity of purchasers, and effectively reduce procurement costs and procurement risks, which is of great significance to the good operation of the company. BRIEF DESCRIPTION OF THE DRAWINGS

[0033] Figure 1 It is an overall schematic block diagram of the procurement plan management system of specific embodiment 1 of the present invention. DETAILED DESCRIPTION

[0034] In order to make the purpose, technical solutions and advantages of the present invention more clearly understood, the present invention is further described in detail below in conjunction with the accompanying drawings and specific implementation methods.

[0035] 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 those skilled in the art without creative work are within the scope of protection of the present invention.

[0036] Example 1

[0037] like Figure 1 As shown, this embodiment provides a procurement plan management system, including a data acquisition module and a data processing module; the data acquisition module is connected to the data processing module;

[0038] The data acquisition module is used to obtain order data, product processing qualification rate, theoretical supply ratio of each sub-level material under the parent material, actual supply progress ratio, effective inventory quantity, in-transit quantity, theoretical safety inventory number, arrival qualification rate, on-time arrival rate, full arrival rate and supplier data; the supplier data of each sub-level material includes the minimum supply quantity, full package supply quantity, supply cycle and supply address of the supplier corresponding to each sub-level material for the sub-level material;

[0039] The data processing module is used to calculate the procurement plan of all parent materials according to the information obtained by the data acquisition module; the data processing module includes a parent material arrival plan generation module, a parent material priority sorting module, a supplier reputation scoring module, a procurement plan generation module, a procurement plan risk assessment module, and a procurement plan adjustment module;

[0040] The parent material arrival plan generation module is used to determine the production schedule according to the order data and the product processing qualification rate, and calculate the parent material arrival plan according to the production schedule, the effective inventory quantity, the in-transit quantity, the arrival qualification rate and the theoretical safety stock number of each sub-level material;

[0041] The parent material priority sorting module is used to determine the urgency of each parent material and sort them according to the length of time the sum of the corresponding child materials before the arrival of each parent material can be produced, with the shortest time being ranked first and the longest time being ranked last;

[0042] The supplier credit scoring module is used to judge the credit score corresponding to the supplier supplying each sub-level material according to the arrival qualification rate, on-time arrival rate and full arrival rate of each sub-level material;

[0043] The procurement plan generation module is used to make procurement plan according to the priority order of the parent materials obtained by the parent material priority sorting module; first, the procurement plan is made for the parent material with the first priority: the suppliers that meet the arrival requirements are screened according to the supplier data of the sub-materials under the parent material, and then the actual supply ratio of each sub-material that meets the supply demand is calculated according to the theoretical supply ratio and the actual supply progress ratio of each sub-material that meets the supply demand, so as to obtain a preliminary procurement plan; then, the procurement plan is made for the parent material with the second priority according to the above method until the procurement plan for all parent materials is completed.

[0044] Furthermore, it also includes a procurement plan risk assessment module; the procurement plan risk assessment module is connected to the data acquisition module and the data processing module respectively; the procurement plan risk assessment module is used to evaluate whether the procurement plans for each parent material generated by the procurement plan generation module have the risk that the supply of emergency materials is too concentrated on a single supplier. The specific evaluation method is: the total number of parent materials is N, and they are sorted by the parent material priority sorting module to screen out the top three parent materials, and find out the sub-material suppliers whose procurement volume exceeds 50% in these parent material procurement plans, which are called key suppliers. If there is a supplier that is a key supplier of two or more parent materials at the same time, then it is determined that the procurement plans for each parent material generated by the procurement plan generation module belong to risky procurement plans, the supplier is a risky supplier, and the sub-material becomes a risky sub-material.

[0045] Furthermore, it also includes a procurement plan adjustment module; the procurement plan adjustment module is connected to the data acquisition module, the data processing module and the procurement plan risk assessment module respectively;

[0046] The procurement plan adjustment module includes a supply concentration adjustment module, which is used to adjust the supply concentration of the procurement plan. The adjustment method is:

[0047] When the procurement plan risk assessment module does not determine that the procurement plans of the parent materials generated by the procurement plan generation module belong to risky procurement plans, the supply concentration adjustment module determines the procurement plans of the parent materials generated by the procurement plan generation module as the final procurement plan;

[0048] When the procurement plan risk assessment module determines that the procurement plans of each parent material generated by the procurement plan generation module belong to risk procurement plans, the supply concentration adjustment module adjusts the procurement plan according to the credit score level of each sub-level material supplied by the risk supplier, and adjusts the procurement quantity of at least one risk sub-level material. The procurement quantity adjustment method is:

[0049] The credit scores of suppliers for each sub-level of materials are divided into four levels: excellent, good, average and poor. The corresponding adjustments for the four levels are -5%, -10%, -15% and -20% of the original purchase volume respectively.

[0050] The reduced purchase volume is then added to the supplier with the highest credit score among the sub-materials that meet the supply demand of the parent material, thereby obtaining the adjusted parent material procurement plan, which is sent to the procurement plan risk assessment module for re-risk assessment; if it is still determined to be a risky procurement plan, the procurement plan adjustment module will continue to adjust it until the risk is eliminated, and a risk-free procurement plan for each parent material is obtained as the final procurement plan.

[0051] Furthermore, the procurement plan adjustment module also includes a receipt concentration adjustment module, which is used to calculate the receipt concentration of each sub-level material in the parent material procurement plan within the procurement cycle based on the data of each sub-level material supplier. If it is determined that there is a situation of receipt concentration, the arrival date of individual sub-level materials is adjusted based on the actual utilization rate of the warehouse while meeting the arrival requirements.

[0052] Furthermore, it also includes an early warning module; the early warning module is connected to the procurement plan risk assessment module; the early warning module is used to output early warning information according to the number of times the procurement plan risk assessment module determines that the procurement plan is a risky procurement plan, thereby reminding the staff to pay attention.

[0053] Furthermore, the warning information includes a warning icon and warning text. When the procurement plan risk assessment module determines that the procurement plan is a risky procurement plan for 0 times, the warning icon is displayed in green and the warning text is "safe procurement plan"; when the procurement plan risk assessment module determines that the procurement plan is a risky procurement plan for 1 time, the warning icon is displayed in blue and the warning text is "one risky procurement plan"; when the procurement plan risk assessment module determines that the procurement plan is a risky procurement plan for 2 times, the warning icon is displayed in orange and the warning text is "twice risky procurement plans"; when the procurement plan risk assessment module determines that the procurement plan is a risky procurement plan for 3 times or more, the warning icon is displayed in red and the warning text is "high-risk procurement plan".

[0054] Furthermore, it also includes a data operation and maintenance module, which is connected to the data acquisition module; the data operation and maintenance module is used to update the arrival qualification rate, arrival time rate, and full arrival rate of each sub-level material according to the actual arrival situation; update the product processing qualification rate, the effective inventory quantity, in-transit quantity, and actual supply progress ratio of each sub-level material according to the actual production and material consumption situation; update the theoretical safety inventory quantity, theoretical supply ratio of each sub-level material, and the minimum supply quantity, full package supply quantity, supply cycle, and supply address of each sub-level material supplier for the sub-level materials according to the actual situation.

[0055] Example 2

[0056] The present invention also provides a working method of a procurement plan management system, comprising the following steps:

[0057] S110, generating a parent material arrival plan: the parent material arrival plan generating module determines the production schedule according to the order data and the product processing qualification rate, and calculates the parent material arrival plan according to the production schedule, the effective inventory quantity, the in-transit quantity, the arrival qualification rate, and the theoretical safety stock number of each sub-level material;

[0058] S120, parent material priority sorting: the parent material priority sorting module sorts the parent materials according to the length of time the sum of the corresponding child materials before the arrival of each parent material is available for production, with the shortest time being ranked first and the longest time being ranked last, which is used to judge the urgency of each parent material;

[0059] S130, credit scoring of each sub-level material supplied by the supplier: the supplier credit scoring module judges the credit score corresponding to each sub-level material supplied by the supplier according to the qualified arrival rate, on-time arrival rate and full arrival rate of each sub-level material;

[0060] S140, generate a procurement plan: the procurement plan generation module performs a procurement plan according to the priority order of the parent materials obtained by the parent material priority sorting module; first, a procurement plan is performed for the parent material with the first priority: the supplier that meets the arrival demand is screened according to the supplier data of each sub-material under the parent material, and then the actual supply ratio of each sub-material that meets the supply demand is calculated according to the theoretical supply ratio and the actual supply progress ratio of each sub-material that meets the supply demand, thereby obtaining a preliminary procurement plan; then, the procurement plan is performed for the parent material with the second priority according to the above method until the procurement plan for all parent materials is completed;

[0061] S150. Risk assessment of procurement plans: The procurement plan risk assessment module assesses whether the procurement plans of each parent material generated by the procurement plan generation module have the risk that the supply source of emergency materials is too concentrated on a single supplier. The specific evaluation method is as follows: the total number of parent materials is N. The parent materials are sorted by the parent material priority sorting module, and the top three parent materials are selected. The sub-material suppliers whose procurement volume exceeds 50% in the procurement plan of these parent materials are found respectively, and they are called key suppliers. If there is a supplier that is a key supplier of two or more parent materials at the same time, the procurement plans of each parent material generated by the procurement plan generation module are judged to be risk procurement plans, the supplier is a risk supplier, and the sub-material becomes a risk sub-material.

[0062] S160. Adjustment of procurement plan:

[0063] Adjust the supply concentration of the procurement plan:

[0064] When the procurement plan risk assessment module does not determine that the procurement plans of each parent material generated by the procurement plan generation module belong to risk procurement plans, the supply concentration adjustment module determines the procurement plans of each parent material generated by the procurement plan generation module as the final procurement plan;

[0065] When the procurement plan risk assessment module determines that the procurement plans of each parent material generated by the procurement plan generation module belong to risky procurement plans, the supply concentration adjustment module adjusts the procurement plan according to the credit score level of each sub-level material supplied by the risk supplier, and adjusts the procurement volume of at least one risk sub-level material. The adjustment method is:

[0066] The credit scores of suppliers supplying each sub-level material are divided into four levels: excellent, good, average and poor. The corresponding adjustments for the four levels are -5%, -10%, -15% and -20% of the original purchase volume respectively.

[0067] Then, the reduced purchase quantity is added to the supplier with the highest credit score among the sub-materials that meet the supply demand of the parent material, so as to obtain the adjusted parent material procurement plan, and send it to the procurement plan risk assessment module for re-risk assessment; if it is still determined to be a risky procurement plan, it will continue to be adjusted by the procurement plan adjustment module until the risk is eliminated, and a risk-free procurement plan for each parent material is obtained as the final procurement plan;

[0068] Adjust the receiving concentration of the procurement plan:

[0069] The receiving concentration adjustment module calculates the receiving concentration of each sub-level material in the parent material procurement plan within the procurement cycle based on the supplier data of each sub-level material. If it is determined that there is a situation of receiving concentration, the arrival date of individual sub-level materials is adjusted based on the actual utilization rate of the warehouse while meeting the arrival demand.

[0070] S170. Issue early warning for risky procurement plans: The early warning information includes an early warning icon and early warning text. When the procurement plan risk assessment module determines that the procurement plan is a risky procurement plan for 0 times, the early warning icon is displayed in green, and the early warning text is "safe procurement plan"; when the procurement plan risk assessment module determines that the procurement plan is a risky procurement plan for 1 time, the early warning icon is displayed in blue, and the early warning text is "one risky procurement plan"; when the procurement plan risk assessment module determines that the procurement plan is a risky procurement plan for 2 times, the early warning icon is displayed in orange, and the early warning text is "twice risky procurement plans"; when the procurement plan risk assessment module determines that the procurement plan is a risky procurement plan for 3 times or more, the early warning icon is displayed in red, and the early warning text is "high-risk procurement plan".

[0071] Furthermore, in the step of generating a procurement plan in S140, the calculation method of the actual supply ratio of each sub-level material that meets the supply demand is as follows:

[0072] Sub-level materials A1-A that meet supply requirements i The theoretical supply ratio is L1:L2:......:L i , the actual supply progress ratio is M1, M2, ..., M i , when Mi≥(M1+M2+......+M i ) / i, the corresponding sub-level material actual supply ratio is Li*[1-(M1+M2+......+M i ) / i)]; when Mi<(M1+M2+......+M i ) / i, the corresponding sub-level material actual supply ratio is Li*[1+(M1+M2+......+M i ) / i)].

[0073] Furthermore, it also includes step S180, data operation and maintenance: the data operation and maintenance module updates the arrival qualification rate, arrival time rate, and full arrival rate of each sub-level material according to the actual arrival situation; updates the product processing qualification rate, the effective inventory quantity, in-transit quantity, and actual supply progress ratio of each sub-level material according to the actual production and material consumption situation; updates the theoretical safety stock quantity, theoretical supply ratio of each sub-level material, and the minimum supply quantity, full package supply quantity, supply cycle, and supply address of each sub-level material supplier for the sub-level materials according to the actual situation.

[0074] The above examples are only used to further illustrate the technical content of the present invention, so that readers can understand it more easily, but they do not mean that the implementation of the present invention is limited to this. Any technical extension or re-creation made according to the present invention is protected by the present invention. The protection scope of the present invention shall be subject to the claims.

Claims

1. A procurement plan management system, characterized by: The procurement plan management system includes a data acquisition module, a data processing module, a procurement plan risk assessment module, a procurement plan adjustment module, a receiving concentration adjustment module, an early warning module, and a data operation and maintenance module; The data acquisition module is connected to the data processing module; the data acquisition module is used to obtain order data, product processing qualification rate, theoretical supply ratio of each sub-level material under the parent material, actual supply progress ratio, effective inventory quantity, in-transit quantity, theoretical safety inventory number, arrival qualification rate, arrival on-time rate, full arrival rate and supplier data; the supplier data of each sub-level material includes the minimum supply quantity, full package supply quantity, supply cycle and supply address of the supplier corresponding to each sub-level material for the sub-level material; The data processing module is used to calculate the procurement plan of all parent materials according to the information obtained by the data acquisition module; the data processing module includes a parent material arrival plan generation module, a parent material priority sorting module, a supplier reputation scoring module, a procurement plan generation module, a procurement plan risk assessment module, and a procurement plan adjustment module; The parent material arrival plan generation module is used to determine the production schedule according to the order data and the product processing qualification rate, and calculate the parent material arrival plan according to the production schedule, the effective inventory quantity of each sub-level material, the quantity in transit, the arrival qualification rate, and the theoretical safety stock number; the parent material priority sorting module is used to judge the urgency of each parent material, and sort the sub-level materials according to the length of time available for production before the arrival of each parent material, with the shortest time being ranked first and the longest time being ranked last; The supplier credit scoring module is used to judge the credit score corresponding to the supplier supplying each sub-level material according to the qualified arrival rate, on-time arrival rate and full arrival rate of each sub-level material; The procurement plan generation module is used to make procurement plan according to the priority order of the parent materials obtained by the parent material priority sorting module; first, the procurement plan is made for the parent material with the first priority: the supplier that meets the arrival demand is screened according to the supplier data of each sub-material under the parent material, and then the actual supply ratio of each sub-material that meets the supply demand is calculated according to the theoretical supply ratio and the actual supply progress ratio of each sub-material that meets the supply demand, so as to obtain a preliminary procurement plan; then, the procurement plan is made for the parent material with the second priority according to the above method until the procurement plan for all parent materials is completed; The procurement plan risk assessment module is connected to the data acquisition module and the data processing module respectively; the procurement plan risk assessment module is used to assess whether the procurement plans of each parent material generated by the procurement plan generation module have the risk that the supply source of emergency materials is too concentrated on a single supplier. The specific evaluation method is: the total number of parent materials is N, and the parent materials are sorted by the parent material priority sorting module to screen out the top three parent materials, and the sub-material suppliers whose procurement volume exceeds 50% in these parent material procurement plans are found respectively, which are called key suppliers. If there is a supplier that is a key supplier of two or more parent materials at the same time, then the procurement plans of each parent material generated by the procurement plan generation module are judged to be risk procurement plans, the supplier is a risk supplier, and the sub-material becomes a risk sub-material; The procurement plan adjustment module; The procurement plan adjustment module is connected to the data acquisition module, the data processing module and the procurement plan risk assessment module respectively; The procurement plan adjustment module includes a supply concentration adjustment module, which is used to adjust the supply concentration of the procurement plan. The adjustment method is: When the procurement plan risk assessment module does not determine that the procurement plans of the parent materials generated by the procurement plan generation module belong to risky procurement plans, the supply concentration adjustment module determines the procurement plans of the parent materials generated by the procurement plan generation module as the final procurement plan; When the procurement plan risk assessment module determines that the procurement plans of each parent material generated by the procurement plan generation module belong to risk procurement plans, the supply concentration adjustment module adjusts the procurement plan according to the credit score level of each sub-level material supplied by the risk supplier, and adjusts the procurement quantity of at least one risk sub-level material. The procurement quantity adjustment method is: The credit scores of suppliers for each sub-level of materials are divided into four levels: excellent, good, average and poor. The corresponding adjustments for the four levels are -5%, -10%, -15% and -20% of the original purchase volume respectively. Then, the reduced purchase quantity is added to the supplier with the highest credit score among the sub-materials that meet the supply demand of the parent material, so as to obtain the adjusted parent material procurement plan, and send it to the procurement plan risk assessment module for re-risk assessment; If it is still determined to be a risky procurement plan, the procurement plan adjustment module will continue to adjust it until the risk is eliminated and a risk-free procurement plan for each parent material is obtained as the final procurement plan; The procurement plan adjustment module also includes a receipt concentration adjustment module, which is used to calculate the receipt concentration of each sub-level material in the parent material procurement plan within the procurement cycle based on the data of each sub-level material supplier. If it is determined that there is a situation of receipt concentration, the arrival date of individual sub-level materials is adjusted in combination with the actual utilization rate of the warehouse while meeting the arrival requirements.

2. A procurement plan management system according to claim 1, characterized in that: Warning information includes warning icons and warning text. When the procurement plan risk assessment module determines that the procurement plan is a risky procurement plan 0 times, the warning icon is displayed in green and the warning text is "Safe Procurement Plan"; When the procurement plan risk assessment module determines that a procurement plan is a risky procurement plan once, the warning icon is displayed in blue and the warning text is "One risky procurement plan"; When the procurement plan risk assessment module determines that a procurement plan is a risky procurement plan twice, the warning icon is displayed in orange and the warning text is "risky procurement plan twice"; When the procurement plan risk assessment module determines that a procurement plan is a risky procurement plan for more than or equal to 3 times, the warning icon is displayed in red and the warning text is "High-risk procurement plan".

3. A procurement plan management system according to claim 1, characterized in that: The data operation and maintenance module is connected to the data acquisition module; the data operation and maintenance module is used to update the arrival qualification rate, arrival on time rate, and full arrival rate of each sub-level material according to the actual arrival situation; update the product processing qualification rate, the effective inventory quantity, in-transit quantity, and actual supply progress ratio of each sub-level material according to the actual production and material consumption situation; update the theoretical safety inventory quantity, theoretical supply ratio of each sub-level material, and the minimum supply quantity, full package supply quantity, supply cycle, and supply address of each sub-level material supplier for the sub-level materials according to the actual situation.

4. A working method based on the procurement plan management system according to any one of claims 1 to 3, characterized in that: The working method comprises the following steps: S110, generate the parent material arrival plan; S120, parent material priority sorting; S130. Credit score each sub-level material supplied by the supplier; S140, generate a procurement plan; S150. Conduct risk assessment on procurement plans; S160, adjust the procurement plan; S170, early warning of risky procurement plans; Among them, in the step of generating a procurement plan in S140, the calculation method of the actual supply ratio of each sub-level material that meets the supply demand is as follows: Sub-level materials A1-A that meet supply requirements i The theoretical supply ratio is L1:L2:......:L i , the actual supply progress ratio is M1, M2, ..., M i , when M i ≥(M1+M2+......+M i ) / i, the corresponding sub-level material actual supply ratio is Li*[1-(M1+M2+......+M i ) / i)]; when M i <(M1+M2+......+M i ) / i, the corresponding sub-level material actual supply ratio is Li*[1+(M1+M2+......+M i ) / i)].

5. The working method according to claim 4, characterized in that: The working method also includes step S180, data operation and maintenance: the data operation and maintenance module updates the arrival qualification rate, arrival on time rate, and full arrival rate of each sub-level material according to the actual arrival situation; updates the product processing qualification rate, the effective inventory quantity, the in-transit quantity, and the actual supply progress ratio of each sub-level material according to the actual production and material consumption situation; updates the theoretical safety inventory quantity, theoretical supply ratio of each sub-level material, and the minimum supply quantity, full package supply quantity, supply cycle, and supply address of each sub-level material supplier for the sub-level material according to the actual situation.

Images