MRP operation verification test method, device, equipment and storage medium

Abstract

The present application discloses an MRP operation verification test method, device, equipment and storage medium. The method includes: obtaining actual business data; performing MRP operation according to the actual business data to obtain the result of MRP operation within a predetermined time period; judging the change trend of the total inventory within the predetermined time period; judging whether the result of MRP operation within the predetermined time period meets expectations according to the change trend of the total inventory. For the MRP operation verification test, the operation result is verified by big data business logic, and the test is more comprehensive and convincing; the business logic verification is performed by simulating actual business operations instead of verifying the correctness of various situations through BOM equivalence class division in different scenarios, which is more efficient.

Description

Technical Field

[0001] The present application relates to the field of computer technology, and in particular to an MRP operation verification test method, device, equipment and storage medium. Background Art

[0002] The existing MRP operation verification test solution is to carry out BOM verification in sequence according to the requirements, which is a very time-consuming process; or through equivalence class simulation. The biggest drawback of this method is that it can verify the accuracy of a single data, but it cannot explain whether the operation results of the entire algorithm meet expectations in big data scenarios, especially when there are common materials and incomplete substitution. Summary of the invention

[0003] The main purpose of this application is to provide an MRP operation verification test method, device, equipment and storage medium to solve the above problems.

[0004] In order to achieve the above object, according to one aspect of the present application, a MRP operation verification test method is provided, comprising:

[0005] Obtain actual business data;

[0006] Performing MRP calculation according to the actual business data to obtain the result of MRP calculation within a predetermined time period; specifically comprising:

[0007] For any day within the predetermined time period, obtain the data for that day;

[0008] Performing MRP calculation based on the data to obtain the MRP calculation result for the day;

[0009] The MRP calculation result is input into the next day, and the MRP calculation is performed to obtain the MRP calculation result of the next day;

[0010] Calculate the MRP operation results up to the last day of the predetermined time period in sequence;

[0011] The MRP operation results include production suggestions and purchase suggestions;

[0012] Determine the change trend of the total inventory within the predetermined time period;

[0013] Whether the result of the MRP operation within the predetermined time period meets expectations is determined based on the change trend of the total inventory.

[0014] In one embodiment, the method of judging whether the result of the MRP operation within the predetermined time period meets expectations according to the change trend of the total inventory includes:

[0015] If within a predetermined time period, the total inventory amount decreases as the number of MRP operations increases, and it is determined that the change trend of the total inventory amount meets the optimization condition, then the result of the MRP operation meets expectations;

[0016] If within a predetermined time period, the total inventory volume fluctuates within a certain range as the number of MRP operations increases, it is determined that the change trend of the total inventory volume does not meet the optimization conditions, and the result of the MRP operation does not meet expectations.

[0017] In one embodiment, when the result of the MRP operation does not meet expectations, the method further includes:

[0018] Each time when performing MRP calculation, obtaining a tracking indicator of each material inventory in the total inventory, wherein the tracking indicator includes at least one of a maximum inventory value, a minimum inventory value, and an average inventory value of each material inventory;

[0019] Based on the tracking indicators of each material inventory, a change trend of each material inventory is determined.

[0020] In one implementation, judging whether the MRP operation logic in a predetermined time period meets expectations according to the change trend of the total inventory includes:

[0021] If the trend of the total inventory is downward, it is determined that the MRP operation logic is in line with expectations.

[0022] In one implementation, if the trend of the total inventory is increasing, it is determined that the MRP calculation result does not meet expectations.

[0023] In one embodiment, the MRP operation results include production suggestions and procurement suggestions;

[0024] Converting the production suggestion into a production work order;

[0025] The production work order includes: work order suggested start date, work order suggested quantity, work order suggested start date + material production lead time;

[0026] Convert said procurement proposal into a procurement plan;

[0027] The procurement plan includes: the recommended delivery time, recommended purchase quantity and corresponding supplier.

[0028] In one embodiment, performing MRP calculation according to the data to obtain the MRP calculation result within a predetermined time period includes:

[0029] For any day within the predetermined time period, obtain the data for that day;

[0030] Performing MRP calculation based on the data to obtain the MRP calculation result for the day;

[0031] The MRP calculation result is input into the next day, and the MRP calculation is performed to obtain the MRP calculation result of the next day;

[0032] The MRP operation results up to the last day in the predetermined time period are calculated sequentially.

[0033] In one implementation, determining the change trend of the total inventory within the predetermined time period includes:

[0034] For any two days before and after, compare the inventory volume of the previous day with the inventory volume of the next day;

[0035] If the inventory on the following day is greater than the inventory on the previous day, it is determined that the inventory has increased;

[0036] If the inventory amount on the subsequent day is less than the inventory amount on the previous day, it is determined that the inventory amount has decreased.

[0037] In one embodiment, each time an MRP calculation is performed, the maximum inventory value, the minimum inventory value, and the average inventory value of each material are calculated.

[0038] In one embodiment, updating the inventory in real time within the predetermined time period specifically includes:

[0039] For any day within the predetermined time period, the production work order with a completion date on that day is converted into the inventory for that day; and the advance shipping list ASN with an estimated delivery date on that day is converted into the inventory.

[0040] According to an embodiment of the present invention, there is also provided an MRP operation verification test device, the device comprising:

[0041] Acquisition module, used to obtain actual business data;

[0042] The operation module is used to perform MRP operation according to the actual business data to obtain the result of MRP operation within a predetermined time period, specifically including:

[0043] For any day within the predetermined time period, obtain the data for that day;

[0044] Performing MRP calculation based on the data to obtain the MRP calculation result for the day;

[0045] The MRP calculation result is input into the next day, and the MRP calculation is performed to obtain the MRP calculation result of the next day;

[0046] Calculate the MRP operation results up to the last day of the predetermined time period in sequence;

[0047] The MRP operation results include production suggestions and purchase suggestions;

[0048] An inventory module, used to determine the change trend of the total inventory within the predetermined time period;

[0049] The judgment module is used to judge whether the result of the MRP operation within the predetermined time period meets expectations according to the overall inventory trend.

[0050] In one embodiment, the judgment module is further configured to determine that the MRP operation logic is in line with expectations if the change trend of the total inventory is decreasing, and to determine that the MRP operation result is not in line with expectations if the change trend of the total inventory is increasing.

[0051] In one embodiment, the MRP operation results include production suggestions and procurement suggestions;

[0052] The operation module is also used to convert the production suggestion into a production work order;

[0053] The production work order includes: work order suggested start date, work order suggested quantity, work order suggested start date + material production lead time;

[0054] Convert said procurement proposal into a procurement plan;

[0055] The procurement plan includes: the recommended delivery time, recommended purchase quantity and corresponding supplier.

[0056] In one embodiment, the computing module is further used to obtain data of the day for any day within the predetermined time period;

[0057] Performing MRP calculation based on the data to obtain the MRP calculation result for the day;

[0058] The MRP calculation result is input into the next day, and the MRP calculation is performed to obtain the MRP calculation result of the next day;

[0059] The MRP operation results up to the last day in the predetermined time period are calculated sequentially.

[0060] In one embodiment, the inventory module is further used to compare the inventory quantity of the previous day and the inventory quantity of the next day for any two days before and after;

[0061] If the inventory on the following day is greater than the inventory on the previous day, it is determined that the inventory has increased;

[0062] If the inventory amount on the subsequent day is less than the inventory amount on the previous day, it is determined that the inventory amount has decreased.

[0063] In one embodiment, the inventory module is also used to, for any day within the predetermined time period, convert the production work order with a completion date on that day into inventory for that day; and convert the advance shipping list ASN with an estimated delivery date on that day into inventory.

[0064] In order to achieve the above-mentioned purpose, according to the third aspect of the present application, an electronic device is provided; comprising at least one processor and at least one memory; the memory is used to store one or more program instructions; the processor is used to run one or more program instructions to execute any of the steps described above.

[0065] According to a fourth aspect of the present application, a computer-readable storage medium is provided, wherein the computer-readable storage medium contains one or more program instructions, and the one or more program instructions are used to execute any one of the steps described above.

[0066] In the embodiment of the present application, actual business data is obtained; MRP operation is performed based on the actual business data to obtain the result of MRP operation within a predetermined time period; the overall inventory trend within the predetermined time period is determined; and whether the result of MRP operation within the predetermined time period meets expectations is determined based on the overall inventory trend. For the MRP operation verification test, the operation result is verified by big data business logic, and the test is more comprehensive and convincing; the business logic verification is performed by simulating actual business operations rather than verifying the correctness of various situations through BOM equivalence class division in different scenarios, which is more efficient. BRIEF DESCRIPTION OF THE DRAWINGS

[0067] The drawings constituting a part of this application are used to provide a further understanding of this application, so that other features, purposes and advantages of this application become more obvious. The schematic embodiment drawings and their descriptions of this application are used to explain this application and do not constitute an improper limitation on this application. In the drawings:

[0068] Figure 1 is a flow chart of an MRP operation verification test method according to an embodiment of the present application;

[0069] Figure 2 is a schematic diagram of inventory according to an embodiment of the present application;

[0070] Figure 3 is a flow chart of another MRP operation verification test method according to an embodiment of the present application;

[0071] Figure 4 is a schematic diagram of a single material inventory according to an embodiment of the present application;

[0072] Figure 5 It is a structural schematic diagram of an MRP operation verification test device according to an embodiment of the present application;

[0073] Figure 6 is a structural schematic diagram of an MRP operation verification test device according to an embodiment of the present application;

[0074] Figure 7 It is a schematic diagram of the structure of an electronic device according to an embodiment of the present application. DETAILED DESCRIPTION

[0075] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present application.

[0076] It should be noted that the terms "first", "second", etc. in the specification and claims of the present application and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequential order. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of the present application described here. In addition, the terms "including" and "having" and any of their variations are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device comprising a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0077] In the present application, the terms "upper", "lower", "left", "right", "front", "back", "top", "bottom", "inner", "outer", "middle", "vertical", "horizontal", "lateral", "longitudinal" and the like indicate positions or positional relationships based on the positions or positional relationships shown in the drawings. These terms are mainly used to better describe the present invention and its embodiments, and are not used to limit the indicated devices, elements or components to have a specific orientation, or to be constructed and operated in a specific orientation.

[0078] In addition, some of the above terms may be used to express other meanings in addition to indicating a direction or position relationship. For example, the term "on" may also be used to express a certain dependency or connection relationship in some cases. For those skilled in the art, the specific meanings of these terms in the present invention can be understood according to specific circumstances.

[0079] In addition, the terms "installed", "set", "provided with", "connected", "connected", and "socketed" should be understood in a broad sense. For example, it can be a fixed connection, a detachable connection, or an integral structure; it can be a mechanical connection or an electrical connection; it can be a direct connection, or an indirect connection through an intermediate medium, or it can be an internal connection between two devices, elements, or components. For those of ordinary skill in the art, the specific meanings of the above terms in the present invention can be understood according to specific circumstances.

[0080] It should be noted that, in the absence of conflict, the embodiments and features in the embodiments of the present application can be combined with each other. The present application will be described in detail below with reference to the accompanying drawings and in combination with the embodiments.

[0081] This application proposes a MRP operation verification test method, see Appendix Figure 1 A flow chart of a MRP operation verification test method shown in FIG. 1 ; the method comprises:

[0082] Step S102, obtaining actual business data;

[0083] Among them, the data is actual business data, mainly including material master data, demand data, and supply data. The supply data mainly includes inventory, work-in-progress orders, ASNs, purchase orders, and purchase plans.

[0084] MRP runs various configuration items to set common actual business default configurations. If necessary, you can change the configuration according to the specific situation and perform simulation tests.

[0085] The default configuration items are:

[0086] Participating computing organizations: All organizations;

[0087] Organization Participation Computing Requirements: All requirements;

[0088] Whether to expand the factory requirements under the organization: No;

[0089] Whether to enable safety stock: Enable;

[0090] Organization Factory Priorities: Organization;

[0091] Demand priority: (1) customer priority, (2) product priority, (3) large order quantity priority - further confirmation is required;

[0092] Calculation type: MRP calculation;

[0093] Operational Dimension: Organization;

[0094] Key materials: PCB;

[0095] Participating supply types: (1) On-hand quantity - non-VMI; (2) On-hand quantity - VMI; (3) Work order output; (4) Work order negative demand; (5) Delivery note - non-VMI; (6) Delivery note - VMI; (7) Purchase order - non-VMI; (8) Purchase order - VMI; (9) Purchase requisition.

[0096] Supply priority: (1) existing quantity - non-VMI; (2) existing quantity - VMI; (3) work order output; (4) work order negative demand; (5) delivery note - non-VMI; (6) delivery note - VMI; (7) purchase order - non-VMI; (8) purchase order - VMI; (9) purchase requisition.

[0097] Whether to quote trial production BOM: No;

[0098] Consumption priority: (1) Prioritize small inventory quantity, (2) Prioritize high universality of demand quantity;

[0099] Cross-group dead stock balance: Not enabled.

[0100] Step S104, performing an incomplete replacement scenario MRP calculation according to the actual business data to obtain an MRP calculation result within a predetermined time period, specifically includes:

[0101] For any day within the predetermined time period, obtain the data for that day;

[0102] Performing MRP calculation based on the data to obtain the MRP calculation result for the day;

[0103] The MRP calculation result is input into the next day, and the MRP calculation is performed to obtain the MRP calculation result of the next day;

[0104] Calculate the MRP operation results up to the last day of the predetermined time period in sequence;

[0105] The MRP operation results include production suggestions and purchase suggestions;

[0106] The calculation results include: production suggestions and purchase suggestions;

[0107] After the first step is completed and the production and purchase suggestions are generated, the simulated operator performs the following operations:

[0108] Convert production suggestions into production work orders. In the actual business process, business personnel will manually confirm the production suggestions and convert them into production work orders. This operation needs to be simulated. The work order start date, work order quantity, and work order completion date are respectively: the work order suggested start date, work order suggested quantity, and work order suggested start date of the MRP calculation result + the material production lead time.

[0109] Convert purchase suggestions into purchase plans. In the actual business process, business personnel will convert purchase suggestions into purchase plans. This operation needs to be simulated. The estimated arrival time, purchase data, and supplier are the MRP calculation results, purchase suggestion arrival time, purchase suggestion quantity, and corresponding supplier.

[0110] In the actual process, business personnel will produce and warehouse the completed work orders and generate inventory data. This operation needs to be simulated. The work order completion date and work order completion quantity are the completion date and work order completion quantity of the corresponding work order, and the completion quantity is converted into the corresponding inventory data.

[0111] In the actual business process, there are cases where ASN materials are transferred to inventory. This operation needs to be simulated, and the corresponding inventory quantity is the quantity of the corresponding ASN material;

[0112] In the actual business process, there are cases where purchase orders are converted to ASNs. Generally, a purchase order for a material with an estimated delivery date two days later will be converted to an ASN. This operation process needs to be simulated, and the ASN quantity is the corresponding purchase order quantity.

[0113] In the actual business process, the purchase plan needs to be converted into a purchase order. Generally, the purchase plan with a delivery date of four days later (this data can be changed according to actual conditions) is converted into a purchase order by default, and the purchase order quantity is the purchase plan quantity.

[0114] Step S106, determining the change trend of the total inventory within the predetermined time period;

[0115] It is worth emphasizing that the above prerequisites are: the original inventory quantity is much larger than the daily demand data, for example, the original inventory quantity is more than twice the actual demand, and the substitute material inventory exists at the same time and is randomly distributed; the daily MRP operation demand is relatively stable, with changes within 10%; under this premise, with the MRP operation, the inventory quantity gradually decreases every day, and the substitute materials are effectively consumed.

[0116] Specifically, based on the collected data, the changes in the total inventory of the system as the system runs more times can be statistically calculated.

[0117] The total inventory is calculated using the following formula:

[0118]

[0119] In one embodiment, when determining the change trend of the total inventory within the predetermined time period, for any two days before and after, the inventory of the previous day and the inventory of the next day are compared; if the inventory of the next day is greater than the inventory of the previous day, it is determined that the inventory has increased; if the inventory of the next day is less than the inventory of the previous day, it is determined that the inventory has decreased. Figure 2The diagram shows the changing trend of total inventory; as the number of times increases, the inventory volume shows a downward trend.

[0120] Step S108, judging whether the result of the MRP operation within the predetermined time period meets expectations according to the change trend of the total inventory.

[0121] Specifically, if the change trend of the total inventory is downward, it is determined that the MRP operation logic is in line with expectations; if the change trend of the total inventory is upward, it is determined that the MRP operation result is not in line with expectations.

[0122] In one embodiment, assume A (demand 1000), B (inventory 1500), C (inventory 1500);

[0123] The trend analysis of demand A consumption and inventory consumption of B and C is as follows:

[0124] Without considering the demand increment, only the demand consumption is considered. Assume that the unit usage is 1, the time period is ten days, the demand consumption in the time period is 1000, and B and C consume 1000 inventory respectively;

[0125] Sum(A) consumption = Sum(B) && Sum(C);

[0126] Similarly, the peak values ​​within a time period should also be close to the same. The maximum consumption of demand A in a single day is 500; the corresponding inventory consumption of B and C is 500 each, which proves the correctness of the result, Max(A) consumption = Max(B)&&Max(C).

[0127] In one embodiment, the method of judging whether the result of the MRP operation within the predetermined time period meets expectations according to the change trend of the total inventory includes:

[0128] If within a predetermined time period, the total inventory amount decreases as the number of MRP operations increases, and it is determined that the change trend of the total inventory amount meets the optimization condition, then the result of the MRP operation meets expectations;

[0129] If within a predetermined time period, the total inventory volume fluctuates within a certain range as the number of MRP operations increases, it is determined that the change trend of the total inventory volume does not meet the optimization conditions, and the result of the MRP operation does not meet expectations.

[0130] In one embodiment, when the result of the MRP operation does not meet expectations, the method further includes:

[0131] Each time when performing MRP calculation, obtaining a tracking indicator of each material inventory in the total inventory, wherein the tracking indicator includes at least one of a maximum inventory value, a minimum inventory value, and an average inventory value of each material inventory;

[0132] Preferably, the inventory average is selected.

[0133] Based on the tracking indicators of each material inventory, a change trend of each material inventory is determined.

[0134] For example, the result of the MRP calculation of the total inventory does not meet expectations;

[0135] The materials in inventory include material A, material B and material C;

[0136] For material A, any parameter of the maximum inventory value, the minimum inventory value and the average inventory value can be used for measurement. If the average inventory value is used for measurement, the inventory trend of material A is decreasing;

[0137] It can be seen that the result of material A meets expectations;

[0138] The technical solution of the present application makes the result whether it meets the expected result more fine-grained and makes judgment on each specific material.

[0139] For material B, if the average inventory value is used for measurement, the inventory trend of material B is increasing;

[0140] The result of material B does not meet expectations;

[0141] For material C, if the average inventory value is used for measurement, the inventory trend of material C is up and down fluctuations;

[0142] The result of material C does not meet expectations;

[0143] For example, see the attached Figure 3 The two-dimensional curve of the average inventory value of a material shown in the figure can be determined based on the number of MRP calculations corresponding to the abnormal change trend. The result of the MRP operation does not meet the expected defect position, that is, the trend is abnormal during the fifth calculation, and the trend changes from decreasing to increasing. Therefore, the operation program code needs to be adjusted.

[0144] In one embodiment, when performing MRP operation based on the actual business data to obtain the result of the MRP operation within a predetermined time period, the actual business data is input into a pre-trained machine learning calculation model, and the calculation model outputs the MRP operation result.

[0145] Specifically, the actual business data has the following characteristics: the actual raw data inventory quantity is much higher than the demand data, and there is a large amount of stagnant inventory;

[0146] Actual business data can also be realized through simulation.

[0147] Among them, the machine learning calculation model can be implemented using a neural network.

[0148] When the neural network is trained in advance, both positive and negative samples can be input into the convolutional neural network. After a large amount of calculation and iterative optimization, the accuracy of the output results of the neural network can be improved.

[0149] Among them, the positive sample is an ideal purchaser, an ideal purchase quantity, and a production quantity; the negative sample is an undesirable purchaser, purchase data, and production quantity. The input sample data includes positive sample data and negative sample data, which are input into the model. When the loss function value of the model is less than the predetermined threshold, the training of the model is stopped.

[0150] The output data are: purchasing suggestions and production suggestions.

[0151] Procurement recommendations include: selected suppliers, quantity of products purchased;

[0152] Generate suggestions including: the quantity of products produced by oneself;

[0153] Exemplarily, the input data is: demand data; the demand data is: the customer needs 100 mobile phones, and the order is for 100 mobile phones; so 100 memory sticks with a specification of 2G are required.

[0154] The purchase suggestion is to purchase from supplier A, the purchase specification is 2G memory stick, and the purchase quantity is 100 pieces. The production suggestion is to produce 100 mobile phones;

[0155] Also include the delivery date;

[0156] In the list of suppliers producing 2 GB memory sticks, select supplier A which is ranked highest.

[0157] In one implementation, a priority ranking of suppliers may be set, and suppliers may be selected in sequence according to the priority ranking.

[0158] For example, the suppliers of 2G memory sticks are A, B, C, and D, which are sorted by priority. According to the core business requirements of MRP operation, inventory data should be consumed as much as possible while meeting business needs, especially in the incomplete replacement scenario, materials in the replacement group should be consumed as much as possible. Traditional MRP operation only consumes main materials, not substitute materials, which leads to stagnation of substitute materials and purchase of additional main materials.

[0159] Reduce obsolete inventory. Therefore, the statistical results should satisfy the fact that the total inventory is continuously decreasing and approaching the total safety inventory. If the total inventory decreases with the increase in the number of MRP operations, it means that the total inventory is continuously optimized as the system runs, which means that the MRP operation logic is in line with expectations and the algorithm is reasonable. If the total inventory does not follow the trend in the figure below, but fluctuates up and down within a range, it means that the total inventory has not been continuously optimized as the system runs, or the degree of optimization is very small. In extreme cases, if the total inventory increases with the number of system operations, it means that there are defects in the system (because the input quantity is within a nullable range, and there is no situation where the inventory needs to continue to increase due to the continuous increase in demand), it is necessary to locate the defect and repair the defect.

[0160] In one embodiment, the MRP operation results include production suggestions and procurement suggestions;

[0161] Converting the production suggestion into a production work order;

[0162] The production work order includes: work order suggested start date, work order suggested quantity, work order suggested start date + material production lead time;

[0163] Convert said procurement proposal into a procurement plan;

[0164] The procurement plan includes: the recommended delivery time, recommended purchase quantity and corresponding supplier.

[0165] The core logic of this solution is to simulate the subsequent processing of each MRP calculation result through the actual business data playback after verifying that the simple BOM scenario is correct, and then convert the purchase suggestions generated by the MRP calculation into purchase applications, and convert the production suggestions into production work orders; simulate the raw material warehousing and production warehousing and produce inventory data according to the purchase arrival date and the work order production completion date, and then use the simulated converted data as the supply to participate in the MRP calculation of the next day (in the actual testing process, the simulation data will enter the next run immediately after preparation, and the next calculation will simulate the new demand and new supply calculation of the next day), and generate new purchase suggestions and production suggestions, repeat the above simulation operation to calculate MRP again, and repeat this 30 times (the default MRP calculation result is one month), and then perform statistical analysis based on the core business data inventory information. If the overall inventory data is on a downward trend, it can be proved that the MRP calculation logic of the incomplete replacement scenario is in line with expectations (consume existing inventory as much as possible while meeting business needs to avoid generating stagnant inventory).

[0166] See attached Figure 4The flowchart of another MRP operation verification test method is shown; this method simulates the operation of the production environment and mainly includes two steps: the first step is to simulate the operation of MRP; the second step is to simulate the operation of ERP and SRM systems. Because there is a definite order for the operation of the two steps, the two steps can be simulated in sequence.

[0167] The first step is to simulate the MRP operation. The input data in this process is actual business data, mainly including material master data, demand data, and supply data. The supply data mainly includes inventory, work-in-progress orders, ASNs, purchase orders, and purchase plans. The MRP operation configuration items are set with the commonly used actual business default configuration. If necessary, the configuration can be changed according to the specific situation and then simulated and tested.

[0168] The default configuration items are:

[0169] Participating computing organizations: All organizations;

[0170] Organization Participation Computing Requirements: All requirements;

[0171] Whether to expand the factory requirements under the organization: No;

[0172] Whether to enable safety stock: Enable;

[0173] Organization Factory Priority: Organization.

[0174] Demand priority: (1) customer priority, (2) product priority, (3) large order quantity priority - further confirmation is required;

[0175] Calculation type: MRP calculation;

[0176] Operational Dimension: Organization;

[0177] Key materials: PCB;

[0178] Participating supply types: (1) On-hand quantity - non-VMI, (2) On-hand quantity - VMI, (3) Work order output, (4) Work order negative demand, (5) Delivery order - non-VMI, (6) Delivery order - VMI, (7) Purchase order - non-VMI, (8) Purchase order - VMI, (9) Purchase requisition;

[0179] Supply priority: (1) On-hand quantity - non-VMI, (2) On-hand quantity - VMI, (3) Work order output, (4) Work order negative demand, (5) Delivery order - non-VMI, (6) Delivery order - VMI, (7) Purchase order - non-VMI, (8) Purchase order - VMI, (9) Purchase requisition;

[0180] Whether to quote trial production BOM: No;

[0181] Consumption priority: (1) Prioritize small inventory quantity, (2) Prioritize high universality of demand quantity;

[0182] Cross-group dead stock balance: Not enabled.

[0183] The second step is to convert the production suggestion into a production work order after the first step is completed and the production and purchase suggestions are generated. In the actual business process, the business personnel will manually confirm the production suggestion and convert it into a production work order. This operation needs to be simulated. The work order start date, work order quantity, and work order completion date are respectively: the work order suggestion start date, work order suggestion quantity, and work order suggestion start date + material production lead time of the MRP calculation result; the purchase suggestion is converted into a purchase plan. In the actual business process, the business personnel will convert the purchase suggestion into a purchase plan. This operation needs to be simulated. The purchase estimated arrival time, purchase data, and supplier are respectively the purchase suggestion arrival time, purchase suggestion quantity, and corresponding supplier of the MRP calculation result;

[0184] In the actual process, business personnel will produce and warehouse the completed work orders and generate inventory data. This operation needs to be simulated. The work order completion date and work order completion quantity are the completion date and work order completion quantity of the corresponding work order, and the completion quantity is converted into the corresponding inventory data.

[0185] In the actual business process, there are cases where ASN materials are transferred to inventory. This operation needs to be simulated, and the corresponding inventory quantity is the quantity of the corresponding ASN material;

[0186] In the actual business process, there are cases where purchase orders are converted to ASNs. Generally, a purchase order for a material with an estimated delivery date two days later will be converted to an ASN. This operation process needs to be simulated, and the ASN quantity is the corresponding purchase order quantity.

[0187] In the actual business process, the purchase plan needs to be converted into a purchase order. Generally, the purchase plan with a delivery date of four days later is converted into a purchase order by default, and the purchase order quantity is the purchase plan quantity.

[0188] It is worth emphasizing that the above four days can be changed according to actual conditions.

[0189] Exemplarily, the simulation operation in the second step will be used as input data for the next calculation day to perform MRP operation, and this cycle will be repeated 30 times to simulate the system operation for one month under the big data situation.

[0190] Conduct business data analysis on the data after one month of simulation operation, and judge the correctness of the MRP operation results based on the business analysis results.

[0191] According to the core business requirements of MRP operation, inventory data should be consumed as much as possible while meeting business needs, especially in the incomplete replacement scenario, materials in the replacement group should be consumed as much as possible to reduce stagnant inventory. Therefore, the statistical results should meet the requirement that the total inventory is continuously decreasing and approaching the total safety inventory. If the total inventory decreases with the increase in the number of MRP operations, it means that the total inventory is being continuously optimized as the system runs, which means that the MRP operation logic is in line with expectations and the algorithm is reasonable; if the total inventory does not follow the trend in the figure below, but fluctuates up and down within a range, it means that the total inventory has not been continuously optimized as the system runs, or the degree of optimization is very small. In extreme cases, if the total inventory increases with the number of system operations, it means that there are defects in the system, because the input quantity is within a controllable range, and there is no situation where the continuous increase in demand causes the inventory to continue to increase. At this time, it is necessary to locate the defect and repair the defect.

[0192] In one embodiment, the present application can also perform single material analysis, and each time the MRP calculation is performed, the maximum inventory value, the minimum inventory value, and the average inventory value of each material are calculated. In the single material analysis stage, the current maximum inventory value and the current minimum inventory value of a single material among all materials, as well as the average value of all materials, will be counted as the number of calculations increases. The change in the maximum value of a single material can check whether there is a continuous increase in the inventory of a single material. If the above situation occurs, it means that there is a defect in the system, and the cause of the defect can be found based on the traceability of this material.

[0193] See attached Figure 5 A schematic diagram of a single material is shown in the figure; as shown in the figure, the maximum inventory value, minimum inventory value, and average inventory value of a single material corresponding to each running number can be counted. As the number of times increases, the inventory of a single material shows a downward trend.

[0194] The average value of all materials is similar to the total inventory. In ideal cases, it continues to decrease, and in extreme cases, it continues to increase. If it continues to increase, it means that there are defects in the system.

[0195] The MRP of this application does not completely replace the verification of the calculation results of the scenario. First, it is calculated based on the actual business data, and then the actual business operation is simulated according to the calculation results. Then, the MRP calculation is repeated again until a certain number of times are repeated. The number of times can be determined according to the number of days in the predetermined time period. The operation results are analyzed at the business level, and the business data analysis is used to verify whether the MRP calculation results meet expectations.

[0196] The calculation results of this application are verified by big data business logic, and the test is more comprehensive and convincing. The business logic is verified by simulating actual business operations instead of verifying the correctness of various situations through BOM equivalence classification in different scenarios, which is more efficient.

[0197] It should be noted that the steps shown in the flowcharts of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions, and that, although a logical order is shown in the flowcharts, in some cases, the steps shown or described can be executed in an order different from that shown here.

[0198] According to an embodiment of the present invention, a MRP operation verification test device is also provided. Figure 6 As shown, the device comprises:

[0199] An acquisition module 51 is used to acquire actual business data;

[0200] The operation module 52 is used to perform MRP operation according to the actual business data to obtain the result of MRP operation within a predetermined time period, specifically including:

[0201] For any day within the predetermined time period, obtain the data for that day;

[0202] Performing MRP calculation based on the data to obtain the MRP calculation result for the day;

[0203] The MRP calculation result is input into the next day, and the MRP calculation is performed to obtain the MRP calculation result of the next day;

[0204] Calculate the MRP operation results up to the last day of the predetermined time period in sequence;

[0205] The MRP operation results include production suggestions and purchase suggestions;

[0206] Inventory module 53, used to determine the change trend of the total inventory within the predetermined time period;

[0207] The judgment module 54 is used to judge whether the result of the MRP operation within the predetermined time period meets expectations according to the change trend of the total inventory.

[0208] In one embodiment, the judgment module 54 is further configured to: if within a predetermined time period, the total inventory amount decreases as the number of MRP operations increases, and it is determined that the change trend of the total inventory amount meets the optimization condition, then the result of the MRP operation meets expectations;

[0209] If within a predetermined time period, the total inventory volume fluctuates within a certain range as the number of MRP operations increases, it is determined that the change trend of the total inventory volume does not meet the optimization conditions, and the result of the MRP operation does not meet expectations.

[0210] In one embodiment, a tracking module is further included, which is used to obtain a tracking indicator of each material inventory in the total inventory each time the MRP calculation is performed when the result of the MRP operation does not meet expectations, wherein the tracking indicator includes at least one of a maximum inventory value, a minimum inventory value, and an average inventory value of each material inventory;

[0211] Based on the tracking indicators of each material inventory, a change trend of each material inventory is determined.

[0212] In one embodiment, the judgment module 54 is further configured to determine that the MRP operation logic is in line with expectations if the change trend of the total inventory is decreasing, and to determine that the MRP operation result is not in line with expectations if the change trend of the total inventory is increasing.

[0213] In one embodiment, the MRP operation results include production suggestions and procurement suggestions;

[0214] The operation module 52 is also used to convert the production suggestion into a production work order;

[0215] The production work order includes: work order suggested start date, work order suggested quantity, work order suggested start date + material production lead time;

[0216] Convert said procurement proposal into a procurement plan;

[0217] The procurement plan includes: the recommended delivery time, recommended purchase quantity and corresponding supplier.

[0218] In one embodiment, the calculation module 52 is further used to calculate the maximum inventory value, the minimum inventory value and the average inventory value of each material each time the MRP calculation is performed.

[0219] In one embodiment, the inventory module 53 is further used to compare the inventory quantity of the previous day and the inventory quantity of the next day for any two days before and after;

[0220] If the inventory on the following day is greater than the inventory on the previous day, it is determined that the inventory has increased;

[0221] If the inventory amount on the subsequent day is less than the inventory amount on the previous day, it is determined that the inventory amount has decreased.

[0222] In one embodiment, the inventory module 53 is also used to, for any day within the predetermined time period, convert the production work order with a completion date on that day into the inventory of that day; and convert the advance shipping list ASN with an estimated delivery date on that day into inventory.

[0223] According to a third aspect of the present application, an electronic device is provided. Figure 7 The structural diagram of the electronic device shown in the figure comprises at least one processor 61 and at least one memory 62; the memory 62 is used to store one or more program instructions; the processor 61 is used to run one or more program instructions to execute any one of the above methods.

[0224] In a fourth aspect, the present application further proposes a computer-readable storage medium, which contains one or more program instructions, and the one or more program instructions are used to execute any of the methods described above.

[0225] The methods, steps and logic block diagrams disclosed in the embodiments of the present invention can be implemented or executed. The general processor can be a microprocessor or the processor can also be any conventional processor, etc. The steps of the method disclosed in the embodiments of the present invention can be directly embodied as a hardware decoding processor for execution, or can be executed by a combination of hardware and software modules in the decoding processor. The software module can be located in a mature storage medium in the field such as a random access memory, a flash memory, a read-only memory, a programmable read-only memory or an electrically erasable programmable memory, a register, etc. The processor reads the information in the storage medium and completes the steps of the above method in combination with its hardware.

[0226] The storage medium may be a memory, which may be, for example, a volatile memory or a nonvolatile memory, or may include both volatile and nonvolatile memory.

[0227] Among them, the non-volatile memory can be a read-only memory (ROM), a programmable ROM (PROM), an erasable programmable read-only memory (EPROM), an electrically erasable programmable read-only memory (EEPROM), or a flash memory.

[0228] The volatile memory may be a random access memory (RAM) which is used as an external cache. By way of example and not limitation, many forms of RAM are available, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate synchronous DRAM (DDRSDRAM), enhanced synchronous DRAM (ESDRAM), synchronous link DRAM (SLDRAM), and direct RAM bus DRAM (DRRAM).

[0229] The storage media described in the embodiments of the present invention are intended to include, but are not limited to, these and any other suitable types of memory.

[0230] Those skilled in the art will appreciate that in one or more of the above examples, the functions described in the present invention can be implemented using a combination of hardware and software. When software is used, the corresponding functions can be stored in a computer-readable medium or transmitted as one or more instructions or codes on a computer-readable medium. Computer-readable media include computer storage media and communication media, wherein communication media include any media that facilitates the transmission of computer programs from one place to another. Storage media can be any available media that can be accessed by general or special-purpose computers.

[0231] Obviously, those skilled in the art should understand that the above modules or steps of the present invention can be implemented by a general computing device, they can be concentrated on a single computing device, or distributed on a network composed of multiple computing devices, and optionally, they can be implemented by a program code executable by a computing device, so that they can be stored in a storage device and executed by the computing device, or they can be made into individual integrated circuit modules, or multiple modules or steps therein can be made into a single integrated circuit module for implementation. Thus, the present invention is not limited to any specific combination of hardware and software.

[0232] The above description is only the preferred embodiment of the present application and is not intended to limit the present application. For those skilled in the art, the present application may have various modifications and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application shall be included in the protection scope of the present application.

Claims

1. A MRP operation verification test method, characterized in that: include: Obtain actual business data; Performing MRP calculation according to the actual business data to obtain the result of MRP calculation within a predetermined time period specifically includes: For any day within the predetermined time period, obtain the data for that day; Performing MRP calculation based on the data to obtain the MRP calculation result for the day; The MRP calculation result is input into the next day, and the MRP calculation is performed to obtain the MRP calculation result of the next day; Calculate the MRP operation results up to the last day of the predetermined time period in sequence; The MRP operation results include production suggestions and procurement suggestions; Determine the change trend of the total inventory within the predetermined time period; Determine whether the result of the MRP operation within the predetermined time period meets expectations according to the change trend of the total inventory; The MRP calculation results include production suggestions and purchase suggestions, including: Convert the production suggestion into a production work order. In the actual business process, the business personnel will manually confirm the production suggestion and convert it into a production work order. This operation needs to be simulated. The work order start date, work order quantity, and work order completion date are respectively: the work order suggestion start date, work order suggestion quantity, and work order suggestion start date of the MRP calculation result + the material production lead time; Convert purchase suggestions into purchase plans. In the actual business process, business personnel will convert purchase suggestions into purchase plans. This operation needs to be simulated. The purchase estimated arrival time, purchase data, and supplier are the purchase suggestion arrival time, purchase suggestion quantity, and corresponding supplier of the MRP calculation results respectively. When the result of the MRP operation does not meet expectations, the method further includes: Each time when performing MRP calculation, obtaining a tracking indicator of each material inventory in the total inventory, wherein the tracking indicator includes at least one of a maximum inventory value, a minimum inventory value, and an average inventory value of each material inventory; Based on the tracking indicators of each material inventory, a change trend of each material inventory is determined.

2. The MRP operation verification test method according to claim 1, characterized in that: The method of judging whether the result of the MRP operation within the predetermined time period meets expectations according to the change trend of the total inventory includes: If within a predetermined time period, the total inventory amount decreases as the number of MRP operations increases, and it is determined that the change trend of the total inventory amount meets the optimization condition, then the result of the MRP operation meets expectations; If within a predetermined time period, the total inventory volume fluctuates within a certain range as the number of MRP operations increases, it is determined that the change trend of the total inventory volume does not meet the optimization conditions, and the result of the MRP operation does not meet expectations.

3. The MRP operation verification test method according to claim 1, characterized in that: Performing MRP calculations according to the actual business data to obtain results of MRP calculations within a predetermined time period includes: The actual business data is input into a pre-trained calculation model, and the calculation model outputs an MRP operation result.

4. The MRP operation verification test method according to claim 1, characterized in that: Determining the change trend of the total inventory within the predetermined time period includes: For any two days before and after, compare the inventory volume of the previous day with the inventory volume of the next day; If the inventory on the following day is greater than the inventory on the previous day, then it is determined that the inventory has increased; If the inventory amount on the subsequent day is less than the inventory amount on the previous day, it is determined that the inventory amount has decreased.

5. The MRP operation verification test method according to claim 1, characterized in that: Also includes: During the predetermined time period, the inventory is updated in real time.

6. The MRP operation verification test method according to claim 5, characterized in that: During the predetermined time period, the inventory is updated in real time, including: For any day within the predetermined time period, the production work order with a completion date on that day is converted into the inventory for that day; and the advance shipping list ASN with an estimated delivery date on that day is converted into the inventory.

7. An MRP operation verification test device, characterized in that: include: Acquisition module, used to obtain actual business data; The operation module is used to perform MRP operation according to the actual business data to obtain the result of MRP operation within a predetermined time period, specifically including: For any day within the predetermined time period, obtain the data for that day; Performing MRP calculation based on the data to obtain the MRP calculation result for the day; The MRP calculation result is input into the next day, and the MRP calculation is performed to obtain the MRP calculation result of the next day; Calculate the MRP operation results up to the last day of the predetermined time period in sequence; The MRP operation results include production suggestions and procurement suggestions; An inventory module, used to determine the change trend of the total inventory within the predetermined time period; A judgment module, used to judge whether the result of the MRP operation within the predetermined time period meets expectations according to the change trend of the total inventory; The MRP calculation results include production suggestions and purchase suggestions, including: Convert the production suggestion into a production work order. In the actual business process, the business personnel will manually confirm the production suggestion and convert it into a production work order. This operation needs to be simulated. The work order start date, work order quantity, and work order completion date are respectively: the work order suggestion start date, work order suggestion quantity, and work order suggestion start date of the MRP calculation result + the material production lead time; Convert purchase suggestions into purchase plans. In the actual business process, business personnel will convert purchase suggestions into purchase plans. This operation needs to be simulated. The purchase estimated arrival time, purchase data, and supplier are the purchase suggestion arrival time, purchase suggestion quantity, and corresponding supplier of the MRP calculation results respectively. When the result of the MRP operation does not meet expectations, the method further includes: Each time when performing MRP calculation, obtaining a tracking indicator of each material inventory in the total inventory, wherein the tracking indicator includes at least one of a maximum inventory value, a minimum inventory value, and an average inventory value of each material inventory; Based on the tracking indicators of each material inventory, a change trend of each material inventory is determined.

8. An MRP operation verification test device, characterized in that: include: at least one processor and at least one memory; The memory is used to store one or more program instructions; The processor is used to run one or more program instructions to execute the method according to any one of claims 1-6.

9. A computer-readable storage medium, characterized in that: The computer-readable storage medium includes one or more program instructions, and the one or more program instructions are used to execute the method according to any one of claims 1 to 6.

Images